EVOLUTION-MANAGER

Edit File: export-persona.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();
//$jxc = new TinyAjax();
//$jxc ->exportFunction('datos_del_pago', array('idsolicitud', 'idparcialidad'), "#iddatos_pago");
//$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);
$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);
$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");

$xHP->init();

$xFRM		= new cHForm("frmexportpersona", "./");
$xSel		= new cHSelect();
$xFRM->setTitle($xHP->getTitle());

//$xFRM->addJsBasico();
$sql		= "SELECT DISTINCT INFORMATION_SCHEMA.COLUMNS.TABLE_SCHEMA,
INFORMATION_SCHEMA.TABLES.TABLE_TYPE ,
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME AS 'tabla', 
INFORMATION_SCHEMA.COLUMNS.COLUMN_NAME AS 'columna'

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='matriz' AND INFORMATION_SCHEMA.TABLES.TABLE_TYPE NOT LIKE \"%VIEW%\"
AND
((column_name LIKE '%persona%')
OR
(column_name LIKE '%socio%')
)
AND

(column_name NOT LIKE 'idsocio%')
AND
(column_name NOT LIKE 'idpersona%')
AND
(column_name NOT LIKE 'idaml_personas_%')
AND
(column_name NOT LIKE 'representante_numero_%') /*solo en exportacion*/
AND
(column_name NOT LIKE 'vocal_vigilancia_numero_%') /*solo en exportacion*/

AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME NOT LIKE 'vw_%'
AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME NOT LIKE 'tmp_%'
AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME NOT LIKE 'temp_%'
AND

INFORMATION_SCHEMA.COLUMNS.TABLE_NAME NOT LIKE 'vv_%'
AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME NOT LIKE 'sumas_%'

AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME != 'creditos'
AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME != 'letras'
AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME != 'domicilios'
AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME != 'general_folios'
AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME != 'creditos_a_final_de_plazo'

AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME != 'listado_de_ingresos'
AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME != 'operaciones'
AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME != 'operaciones_sumas'

AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME NOT LIKE 'creditos_letras_%'
AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME != 'historial_de_pagos'
AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME != 'personas_operaciones_recursivas'
AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME != 'primeras_letras'
AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME != 'operaciones_no_estadisticas'
AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME NOT LIKE 'migracion_%'
AND
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME != 'solicitudes'";

$rs		= $xQL->getDataRecord($sql);
$xLog	= new cCoreLog();
foreach ($rs as $rw){
	$tabla		= $rw["tabla"];
	$columna	= $rw["columna"];
	//$xLog->add( "mysql -e \"SELECT * FROM $tabla WHERE $columna=\$PERSONA\" --user=root --password=\$MPASS \$MDB >> \$MDB-\$PERSONA.txt\n");
	//'
	$xLog->add( "mysqldump --skip-triggers --compact --extended-insert=FALSE --no-create-info --user=root --password=\$MPASS -B \$MDB --tables $tabla --where='" . $columna . "='+\$PERSONA >> \$MDB-\$PERSONA.sql\n");
}
$xFRM->addLog($xLog->getMessages());
echo $xFRM->get();

//$jxc ->drawJavaScript(false, true);
$xHP->fin();
?>