Catálogo de Colocación

Cuenta
Nombre
Banco
 

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_numcol="%".$_POST["denominacion"]."%"; } else { $ls_operacion=""; } print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; if($ls_operacion=="BUSCAR") { /*$ls_sql=" SELECT a.CodBan as CodBan,b.NomBan as NomBan,a.CtaBan as CtaBan,c.DenCta as DenCta,a.NumCol as NumCol, a.DenCol as DenCol ,a.CodTipCol as CodTipCol,d.NomTipCol as NomTipCol,a.FecCol as FecCol,a.DiaCol as DiaCol,a.TasCol as TasCol,a.Monto as Monto,a.FecVenCol as FecVenCol,a.MonInt as MonInt,a.SC_Cuenta as SC_Cuenta,a.SPI_Cuenta as SPI_Cuenta,a.EstReiCol as EstReiCol FROM scb_colocacion a,scb_banco b,scb_ctabanco c,scb_tipocolocacion 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.NumCol like '".$ls_numcol."' AND a.CodBan=b.CodBan AND b.CodBan=c.CodBan AND a.CtaBan=c.CtaBan AND a.CodTipCol=d.CodTipCol ";*/ $ls_sql="SELECT a.codban as codban,b.nomban as nomban,a.ctaban as ctaban,c.dencta as dencta,a.numcol as numcol, a.dencol as dencol ,a.codtipcol as codtipcol,d.nomtipcol as nomtipcol,a.feccol as feccol, a.diacol as diacol,a.tascol as tascol,a.monto as monto,a.fecvencol as fecvencol,a.monint as monint, a.sc_cuenta as sc_cuenta,e.denominacion as denominacion,a.spi_cuenta as spi_cuenta,a.estreicol as estreicol FROM scb_colocacion a,scb_banco b,scb_ctabanco c,scb_tipocolocacion d,scg_cuentas e WHERE a.codemp=b.codemp AND a.codemp=c.codemp AND a.codemp=e.codemp AND a.codban=b.codban AND a.codban=c.codban AND a.ctaban=c.ctaban AND a.codtipcol=d.codtipcol AND a.codemp='0001' AND a.codban like '%".$ls_codban."%' AND a.ctaban like '%".$ls_cuenta."%' AND a.numcol like '%".$ls_numcol."%' AND a.sc_cuenta=e.sc_cuenta"; $rs_cta=$SQL->select($ls_sql); $data=$rs_cta; if($rs_cta===false) { $io_msg->message($fun->uf_convertirmsg($SQL->message)); } 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("numcol"); for($z=1;$z<=$totrow;$z++) { print ""; $codban=$data["codban"][$z]; $nomban=$data["nomban"][$z]; $ctaban=$data["ctaban"][$z]; $dencta=$data["dencta"][$z]; $numcol=$data["numcol"][$z]; $dencol=$data["dencol"][$z]; $codtipcol=$data["codtipcol"][$z]; $nomtipcol=$data["nomtipcol"][$z]; $feccol=$fun->uf_convertirfecmostrar($data["feccol"][$z]); $diacol=$data["diacol"][$z]; $tascol=$data["tascol"][$z]; $monto =$data["monto"][$z]; $fecvencol=$fun->uf_convertirfecmostrar($data["fecvencol"][$z]); $monint=$data["monint"][$z]; $sc_cuenta=$data["sc_cuenta"][$z]; $denscg=$data["denominacion"][$z]; $spi_cuenta=$data["spi_cuenta"][$z]; $status=$data["estreicol"][$z]; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; } } else { $io_msg->message("No se han creado colocaciones"); } } } print "
ColocaciónDenominaciónBancoCuentaMontoInteresesTasaDiasStatus
".$numcol."".$dencol."".$nomban."".$ctaban."".number_format($monto,2,",",".")."".number_format($monint,2,",",".")."".$tascol."".$diacol."".$status."
"; ?>