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"];
print "
";
print "";
print "| Chequera | ";
print "Banco | ";
print "Cuenta | ";
print "
";
if($ls_operacion=="BUSCAR")
{
$li_x=0;
$ls_sql="SELECT DISTINCT (a.numchequera) as numchequera,a.codban as codban,a.ctaban as ctaban ,b.nomban as nomban,c.dencta as dencta,d.codtipcta as codtipcta,d.nomtipcta as nomtipcta
FROM scb_cheques a,scb_banco b,scb_ctabanco c,scb_tipocuenta d
WHERE a.codemp='".$ls_codemp."'
AND a.codban like '".$ls_codban."'
AND a.ctaban like '".$ls_cuenta."'
AND a.codemp=b.codemp
AND a.codemp=c.codemp
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
{
while($row=$SQL->fetch_row($rs_cta))
{
$li_x=$li_x+1;
print "";
$codban=$row["codban"];
$nomban=$row["nomban"];
$ctaban=$row["ctaban"];
$dencta=$row["dencta"];
$codtipcta=$row["codtipcta"];
$nomtipcta=$row["nomtipcta"];
$numchequera=$row["numchequera"];
print "| ".$numchequera." | ";
print "".$nomban." | ";
print "".$ctaban." | ";
print "
";
}
if($li_x==0)
{
$io_msg->message("No se han definido Chequeras");
}
}
}
print "
";
?>