EVOLUTION-MANAGER

Edit File: sucursales.fix.frm.php

<?php
/**
 * @author Balam Gonzalez Luis Humberto
 * @version 0.0.01
 * @package
 */
//=====================================================================================================
	include_once("../core/go.login.inc.php");
	include_once("../core/core.error.inc.php");
	include_once("../core/core.html.inc.php");
	include_once("../core/core.init.inc.php");
	include_once("../core/core.db.inc.php");
	$theFile			= __FILE__;
	$permiso			= getSIPAKALPermissions($theFile);
	if($permiso === false){	header ("location:../404.php?i=999");	}
	$_SESSION["current_file"]	= addslashes( $theFile );
//=====================================================================================================
$xHP		= new cHPage("", HP_FORM);
$xQL		= new MQL();
$xLi		= new cSQLListas();
$xF			= new cFecha();
$xDic		= new cHDicccionarioDeTablas();
$xLog		= new cCoreLog();
$jxc 		= new TinyAjax();
//$tab 		= new TinyAjaxBehavior();
//$tab -> add(TabSetValue::getBehavior("idide", $x));
//return $tab -> getString();
function jsaFixSucursales(){
	$xQL	= new MQL();
	$xLog	= new cCoreLog();
	
	$sql	= "SELECT DISTINCT INFORMATION_SCHEMA.COLUMNS.TABLE_SCHEMA, INFORMATION_SCHEMA.TABLES.TABLE_TYPE, INFORMATION_SCHEMA.COLUMNS.TABLE_NAME, INFORMATION_SCHEMA.COLUMNS.COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS INNER JOIN INFORMATION_SCHEMA.TABLES ON INFORMATION_SCHEMA.TABLES.TABLE_SCHEMA = INFORMATION_SCHEMA.COLUMNS.TABLE_SCHEMA
WHERE INFORMATION_SCHEMA.COLUMNS.TABLE_SCHEMA='" . MY_DB_IN . "' AND INFORMATION_SCHEMA.TABLES.TABLE_TYPE NOT LIKE '%VIEW%' AND ((column_name LIKE '%idsucursal%') OR (column_name LIKE '%sucursal%'))";
	
	$xQL->setRawQuery("ALTER TABLE `general_sucursales` CHANGE COLUMN `codigo_sucursal` `codigo_sucursal` VARCHAR(20) NOT NULL");
	
	$rs		= $xQL->getRecordset($sql);
	while($rw = $rs->fetch_assoc()){
		$tabla	= $rw["TABLE_NAME"];
		$campo	= $rw["COLUMN_NAME"];
		
		$res	= $xQL->setRawQuery("ALTER TABLE `$tabla` CHANGE `$campo` `$campo` VARCHAR(20) CHARSET utf8 COLLATE utf8_general_ci DEFAULT 'matriz' NULL");
		if($res === false){
			$xLog->add("ERROR\tFallo en la tabla $tabla campo $campo \r\n");
		} else {
			$xLog->add("OK\tla tabla $tabla campo $campo \r\n");
		}
		//$xLog->add($xQL->getMessages());
		$xQL->setRawQuery("UPDATE `$tabla` SET `$campo`=LOWER(`$campo`) ");
		
		$xQL->setRawQuery("UPDATE `$tabla` SET `$campo`='matriz' WHERE (SELECT COUNT(*) FROM `general_sucursales` WHERE `general_sucursales`.`codigo_sucursal`=`$tabla`.`$campo`)<=0");
	}
}
function jsaChangeSucursales($idanterior, $idnuevo){
	$xQL	= new MQL();
	$xLog	= new cCoreLog();
	$sql	= "SELECT DISTINCT INFORMATION_SCHEMA.COLUMNS.TABLE_SCHEMA, INFORMATION_SCHEMA.TABLES.TABLE_TYPE, INFORMATION_SCHEMA.COLUMNS.TABLE_NAME, INFORMATION_SCHEMA.COLUMNS.COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS INNER JOIN INFORMATION_SCHEMA.TABLES ON INFORMATION_SCHEMA.TABLES.TABLE_SCHEMA = INFORMATION_SCHEMA.COLUMNS.TABLE_SCHEMA
WHERE INFORMATION_SCHEMA.COLUMNS.TABLE_SCHEMA='" . MY_DB_IN . "' AND INFORMATION_SCHEMA.TABLES.TABLE_TYPE NOT LIKE '%VIEW%' AND ((column_name LIKE '%idsucursal%') OR (column_name LIKE '%sucursal%'))";
	
	$rs		= $xQL->getRecordset($sql);
	while($rw = $rs->fetch_assoc()){
		$tabla	= $rw["TABLE_NAME"];
		$campo	= $rw["COLUMN_NAME"];
		
		$res	= $xQL->setRawQuery("UPDATE `$tabla` SET `$campo`='$idnuevo' WHERE  `$campo`='$idanterior' ");
		
	}
	$xQL->setRawQuery("UPDATE `general_sucursales` SET `codigo_sucursal`='$idnuevo' WHERE `codigo_sucursal`='$idanterior' ");
}
$jxc->exportFunction('jsaFixSucursales', array('idsucursalanterior', 'idsucursalnuevo'), "#idmsg");
$jxc->exportFunction('jsaChangeSucursales', array('idsucursalanterior', 'idsucursalnuevo'), "#idmsg");

$jxc->process();
$clave			= parametro("id", 0, MQL_INT); $clave		= parametro("clave", $clave, MQL_INT);  
$fecha			= parametro("idfecha-0", false, MQL_DATE); $fecha = parametro("idfechaactual", $fecha, MQL_DATE);  $fecha = parametro("idfecha", $fecha, MQL_DATE);
$persona		= parametro("persona", DEFAULT_SOCIO, MQL_INT); $persona = parametro("socio", $persona, MQL_INT); $persona = parametro("idsocio", $persona, MQL_INT);
$credito		= parametro("credito", DEFAULT_CREDITO, MQL_INT); $credito = parametro("idsolicitud", $credito, MQL_INT); $credito = parametro("solicitud", $credito, MQL_INT);
$cuenta			= parametro("cuenta", DEFAULT_CUENTA_CORRIENTE, MQL_INT); $cuenta = parametro("idcuenta", $cuenta, MQL_INT);
$jscallback		= parametro("callback"); $tiny = parametro("tiny"); $form = parametro("form"); $action = parametro("action", SYS_NINGUNO);$action	= strtolower($action);
$monto			= parametro("monto",0, MQL_FLOAT); $monto	= parametro("idmonto",$monto, MQL_FLOAT); 
$recibo			= parametro("recibo", 0, MQL_INT); $recibo	= parametro("idrecibo", $recibo, MQL_INT);
$empresa		= parametro("empresa", 0, MQL_INT); $empresa	= parametro("idempresa", $empresa, MQL_INT); $empresa	= parametro("iddependencia", $empresa, MQL_INT); $empresa	= parametro("dependencia", $empresa, MQL_INT);
$grupo			= parametro("idgrupo", 0, MQL_INT); $grupo	= parametro("grupo", $grupo, MQL_INT);
$ctabancaria 	= parametro("idcodigodecuenta", 0, MQL_INT); $ctabancaria = parametro("cuentabancaria", $ctabancaria, MQL_INT);
$observaciones	= parametro("idobservaciones"); $observaciones	= parametro("observaciones", $observaciones);

$xHP->init();

$idsucursalanterior = parametro("idsucursalanterior"); $idsucursalanterior = strtolower($idsucursalanterior);
$idsucursalnuevo = parametro("idsucursalnuevo"); $idsucursalnuevo = strtolower($idsucursalnuevo);

$xFRM		= new cHForm("frm", "./sucursales.fix.frm.php");
$xSel		= new cHSelect();
$xFRM->setTitle($xHP->getTitle());

$xFRM->OButton("TR.Corregir", "jsFixSucursales()");

$xFRM->OButton("TR.CAMBIAR", "jsChangeSucursales()");

//if($action == SYS_NINGUNO){
	//$xFRM->addCreditBasico();
	$xFRM->OText_13("idsucursalanterior", "", "TR.SUCURSAL ANTERIOR");
	$xFRM->OText_13("idsucursalnuevo", "", "TR.SUCURSAL NUEVO");
	
	$xFRM->addSubmit();
//}
//$xFRM->addLog($xLog->getMessages());

$xFRM->addAviso("", "idmsg");

echo $xFRM->get();
?>
<script>
var xG	= new Gen();
function jsFixSucursales(){
	xG.confirmar({msg: "CONFIRMA_ACTUALIZACION", callback: jsaFixSucursales});
}
function jsChangeSucursales(){
	xG.confirmar({msg: "CONFIRMA_ACTUALIZACION", callback: jsaChangeSucursales});
}
</script>
<?php

$jxc ->drawJavaScript(false, true);

$xHP->fin();
?>