EVOLUTION-MANAGER

Edit File: socios.svc.php

<?php
/**
 * Modulo
 * @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_SERVICE);
//$xQL		= new MQL();
//$xLi		= new cSQLListas();
$xF			= new cFecha();

header("Content-type: text/xml");
$txt		= "";
$nombre		= parametro("nombre");
$apaterno	= parametro("apaterno");
$amaterno	= parametro("amaterno");

$ByNombre	= ($nombre != "") ? " AND nombrecompleto LIKE '%$nombre%' " : "";
$ByAPaterno	= ($apaterno != "") ? " AND apellidopaterno LIKE '%$apaterno%' " : "";
$ByAMaterno	= ($amaterno != "") ? " AND apellidomaterno LIKE '%$amaterno%' " : "";

$sqllike 	= "SELECT
		`socios_general`.`codigo`          AS `codigo`,
		`socios_general`.`apellidopaterno` AS `apellido_paterno`,
		`socios_general`.`apellidomaterno` AS `apellido_materno`,
		`socios_general`.`nombrecompleto`  AS `nombres`,
		`socios_general`.`curp`
	FROM
		`socios_general` `socios_general`
	WHERE
		codigo != " . DEFAULT_SOCIO . "
		$ByNombre
		$ByAPaterno
		$ByAMaterno
	ORDER BY
		`socios_general`.`apellidopaterno`,
		`socios_general`.`apellidomaterno`,
		`socios_general`.`nombrecompleto`
	LIMIT 0,10 ";
$xQL	= new MQL();
$rs		= $xQL->getRecordset($sqllike);
//$socios	= new medoo(MY_DB_IN);
//$data		= $suc->select(, "*");
if(trim("$nombre$amaterno$apaterno") !== ""){
	while($rw	= $rs->fetch_assoc() ){
		$txt	.= "<persona codigo=\"" . $rw["codigo"] . "\">";
		$txt	.= "";// . $rw[""] . "</socio>";
		$txt	.= $rw["nombres"];
		$txt	.= " " . $rw["apellido_paterno"];
		$txt	.= " " . $rw["apellido_materno"];
		$txt	.= "</persona>\n";
	}
}
echo "<?xml version =\"1.0\" ?>\n<result>\n" . $txt . "</result>";
?>