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 ".
" ORDER BY a.codded ASC";
$rs_data = $io_sql->select($ls_sql);
$data = $rs_data;
if ($row=$io_sql->fetch_row($rs_data))
{
$data = $io_sql->obtener_datos($rs_data);
$arrcols = array_keys($data);
$totcol = count($arrcols);
$io_data->data=$data;
$totrow = $io_data->getRowCount("codded");
print "
";
print "";
print "| Código | ";
print "Denominación | ";
print "SCG | ";
print "Deducible | ";
print "Fórmula | ";
print "
";
for ($z=1;$z<=$totrow;$z++)
{
print "";
$ls_codded = $data["codded"][$z];
$ls_dended = $data["dended"][$z];
$ld_porded = $data["porded"][$z];
$ls_cuenta = $data["sc_cuenta"][$z];
$ls_dencue = $data["denominacion"][$z];
$ld_monded = number_format($data["monded"][$z],2,',','.');
$ls_forded = $data["formula"][$z];
$li_islr = $data["islr"][$z];
$li_iva = $data["iva"][$z];
$li_impmun = $data["estretmun"][$z];
$li_impmil = $data["estretmil"][$z];
$li_otras = $data["otras"][$z];
$tipopersdeduccion = $data["tipopers"][$z];
$li_retaposol = $data["retaposol"][$z];
$ls_codconret = $data["codconret"][$z];
$ls_denconret = $data["desact"][$z];
if ($li_islr==1)
{
$ls_tipded = "S";
}
else
if ($li_iva==1)
{
$ls_tipded = "I";
}
else
if ($li_impmun==1)
{
$ls_tipded = "M";
}
if ($li_otras==1)
{
$ls_tipded = "O";
}
if ($li_retaposol==1)
{
$ls_tipded = "A";
}
if ($li_impmil==1)
{
$ls_tipded = "1";
}
print "| ".$ls_codded." | ";
print "".$ls_dended." | ";
print "".$ls_cuenta." | ";
print "".$ld_monded." | ";
print "".$ls_forded." | ";
print "
";
}//End del For...
print "
";
$io_sql->free_result($rs_data);
}//End del if($row=$io_sql->fetch_row($rs_data))...
else
{
?>