uf_conectar();
require_once("../../shared/class_folder/class_mensajes.php");
$io_msg=new class_mensajes();
require_once("../../shared/class_folder/class_sql.php");
$SQL=new class_sql($con);
$ds=new class_datastore();
require_once("../../shared/class_folder/class_funciones.php");
$fun=new class_funciones();
$ls_codemp=$arr["codemp"];
if(array_key_exists("operacion",$_POST))
{
$ls_operacion=$_POST["operacion"];
$ls_codban="%".$_POST["codigo"]."%";
$ls_cuenta="%".$_POST["cuenta"]."%";
$ls_numche="%".$_POST["denominacion"]."%";
}
else
{
$ls_operacion="";
}
print "
";
print "";
print "| Cheque | ";
print "Chequera | ";
print "Banco | ";
print "Cuenta | ";
print "Status | ";
print "
";
if($ls_operacion=="BUSCAR")
{
$ls_sql="SELECT a.codban as codban,a.ctaban as ctaban ,a.numche as numche,a.numchequera as numchequera,b.nomban as nomban,c.dencta as dencta,d.codtipcta as codtipcta,d.nomtipcta as nomtipcta,a.estche as estche
FROM scb_cheques a,scb_banco b,scb_ctabanco c,scb_tipocuenta d
WHERE a.codemp=b.codemp AND a.codemp=c.codemp AND a.codemp='".$ls_codemp."' AND a.codban like '".$ls_codban."' AND a.ctaban like '".$ls_cuenta."' AND a.numche like '".$ls_numche."' AND a.codban=b.codban AND a.ctaban=c.ctaban
AND b.codban=c.codban AND c.codtipcta=d.codtipcta";
$rs_cta=$SQL->select($ls_sql);
$data=$rs_cta;
if($rs_cta===false)
{
$io_msg("Error en select");
}
else
{
if($row=$SQL->fetch_row($rs_cta))
{
$data=$SQL->obtener_datos($rs_cta);
$arrcols=array_keys($data);
$totcol=count($arrcols);
$ds->data=$data;
$totrow=$ds->getRowCount("numche");
for($z=1;$z<=$totrow;$z++)
{
print "";
$codban=$data["codban"][$z];
$nomban=$data["nomban"][$z];
$ctaban=$data["ctaban"][$z];
$dencta=$data["dencta"][$z];
$codtipcta=$data["codtipcta"][$z];
$nomtipcta=$data["nomtipcta"][$z];
$numche=$data["numche"][$z];
$numchequera=$data["numchequera"][$z];
$status=$data["estche"][$z];
print "| ".$numche." | ";
print "".$numchequera." | ";
print "".$nomban." | ";
print "".$ctaban." | ";
print "".$status." | ";
print "
";
}
}
else
{
$io_msg->message("No se han definido cheques");
}
}
}
print "
";
?>