Catálogo de Retenciones

uf_conectar(); $io_data = new class_datastore(); $io_sql = new class_sql($con); $arr = $_SESSION["la_empresa"]; $ls_codemp = $arr["codemp"]; $ls_sql ="SELECT a.*,b.denominacion, (SELECT desact FROM sigesp_conceptoretencion WHERE a.codemp=sigesp_conceptoretencion.codemp AND a.codconret=sigesp_conceptoretencion.codconret) AS desact FROM sigesp_deducciones a,scg_cuentas b WHERE a.codemp='".$ls_codemp."' AND a.codemp=b.codemp AND a.sc_cuenta=b.sc_cuenta AND a.retventa='1' ORDER BY a.codded ASC"; $rs_data = $io_sql->select($ls_sql); if ($rs_data->RecordCount()) { print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; $clave = 1; foreach ($rs_data as $data){ print ""; $ls_codded = $data["codded"]; $ls_dended = $data["dended"]; $ld_porded = $data["porded"]; $ls_cuenta = $data["sc_cuenta"]; $ls_dencue = $data["denominacion"]; $ld_monded = number_format($data["monded"],2,',','.'); $ls_forded = $data["formula"]; $li_islr = $data["islr"]; $li_iva = $data["iva"]; $li_impmun = $data["estretmun"]; $li_impmil = $data["estretmil"]; $li_otras = $data["otras"]; $tipopersdeduccion = $data["tipopers"]; $li_retaposol = $data["retaposol"]; $ls_codconret = $data["codconret"]; $ls_denconret = $data["desact"]; if ($li_islr==1){ $ls_tipded = "S"; $dentipded = "I.S.L.R"; } else if ($li_iva==1){ $ls_tipded = "I"; $dentipded = "IVA"; } else if ($li_impmun==1){ $ls_tipded = "M"; $dentipded = "MUNICIPAL"; } if ($li_otras==1){ $ls_tipded = "O"; $dentipded = "OTROS"; } if ($li_retaposol==1){ $ls_tipded = "A"; $dentipded = "APORTE SOCIAL"; } if ($li_impmil==1){ $ls_tipded = "1"; $dentipded = "1 X 1000"; } print ""; print ""; print ""; print ""; print ""; print ""; $clave++; }//End del For... print "
CódigoDenominaciónSCGPorc(%)Tipo
".$ls_codded."".$data["dended"]."".$data["sc_cuenta"]."".$data["porded"]."".$dentipded. ''. "
"; $io_sql->free_result($rs_data); }//End del if($row=$io_sql->fetch_row($rs_data))... else { ?>