"; print "close();"; print "opener.document.form1.submit();"; print ""; } //---------------------------------------------------------------------------------------------------------------------------- function uf_imprimirresultados($as_codcom,$as_disponibilidad) { //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// // Function: uf_imprimirresultados // Access: private // Arguments: as_codcom // Número de Comprobante // Description: Función que Imprime los detalles del comprobante // Creado Por: Ing. Yesenia Moreno // Fecha Creación: 31/10/2006 Fecha Última Modificación : //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// global $in_class_mis; require_once("../shared/class_folder/sigesp_include.php"); $in=new sigesp_include(); $con=$in->uf_conectar(); require_once("../shared/class_folder/class_mensajes.php"); $io_mensajes=new class_mensajes(); require_once("../shared/class_folder/class_sql.php"); $io_sql=new class_sql($con); require_once("../shared/class_folder/class_sql.php"); $io_sql2=new class_sql($con); require_once("../shared/class_folder/class_funciones.php"); $io_funciones=new class_funciones(); $ls_codemp=$_SESSION["la_empresa"]["codemp"]; require_once("../shared/class_folder/class_sigesp_int.php"); require_once("../shared/class_folder/class_sigesp_int_int.php"); require_once("../shared/class_folder/class_sigesp_int_scg.php"); require_once("../shared/class_folder/class_sigesp_int_spg.php"); $io_int_spg=new class_sigesp_int_spg(); $ls_group=""; $ls_criterio=""; switch(substr($as_codcom,14,1)) { case "A": // Aportes $ls_group = "GROUP BY codemp, codcom, codnom, codperi, codcomapo, descripcion, cod_pro, ced_bene, tipo_destino, ". " codestpro1, codestpro2, codestpro3, codestpro4, codestpro5, estcla "; break; case "N": // Nómina $ls_group = "GROUP BY codemp, codcom, codnom, codperi, codcomapo, descripcion, cod_pro, ced_bene, tipo_destino, ". " codestpro1, codestpro2, codestpro3, codestpro4, codestpro5, estcla "; break; case "I": // Ingresos $ls_group = "GROUP BY codemp, codcom, codnom, codperi, codcomapo, descripcion, cod_pro, ced_bene, tipo_destino, ". " codestpro1, codestpro2, codestpro3, codestpro4, codestpro5, estcla "; break; case "P": // Prestación $ls_group = "GROUP BY codemp, codcom, codnom, codperi, codcomapo, descripcion, cod_pro, ced_bene, tipo_destino, ". " codestpro1, codestpro2, codestpro3, codestpro4, codestpro5, estcla "; break; case "K": // Intereses Prestación $ls_group = "GROUP BY codemp, codcom, codnom, codperi, codcomapo, descripcion, cod_pro, ced_bene, tipo_destino, ". " codestpro1, codestpro2, codestpro3, codestpro4, codestpro5, estcla "; break; case "L": // Liquidacion $ls_group = "GROUP BY codemp, codcom, codnom, codperi, codcomapo, descripcion, cod_pro, ced_bene, tipo_destino, ". " codestpro1, codestpro2, codestpro3, codestpro4, codestpro5, estcla "; break; case "X": // Anticipos $ls_group = "GROUP BY codemp, codcom, codnom, codperi, codcomapo, descripcion, cod_pro, ced_bene, tipo_destino, ". " codestpro1, codestpro2, codestpro3, codestpro4, codestpro5, estcla "; break; } switch($_SESSION["ls_gestor"]) { case "MYSQLT": $ls_cadena="CONVERT(' ' USING utf8) as operacion"; break; case "POSTGRES": $ls_cadena="CAST(' ' AS char(3)) as operacion"; break; case "INFORMIX": $ls_cadena="CAST(' ' AS char(3)) as operacion"; break; } $ls_sql="SELECT descripcion, cod_pro, ced_bene, tipo_destino, MAX(operacion) AS operacion, codcomapo, ". " (SELECT nompro FROM rpc_proveedor ". " WHERE rpc_proveedor.codemp = sno_dt_spg.codemp ". " AND rpc_proveedor.cod_pro = sno_dt_spg.cod_pro ) as nompro, ". " (SELECT nombene FROM rpc_beneficiario ". " WHERE rpc_beneficiario.codemp = sno_dt_spg.codemp ". " AND rpc_beneficiario.ced_bene = sno_dt_spg.ced_bene ) as nombene, ". " (SELECT apebene FROM rpc_beneficiario ". " WHERE rpc_beneficiario.codemp = sno_dt_spg.codemp ". " AND rpc_beneficiario.ced_bene = sno_dt_spg.ced_bene ) as apebene, ". " (SELECT MAX(fechasper) FROM sno_periodo ". " WHERE sno_periodo.codemp = sno_dt_spg.codemp ". " AND sno_periodo.codnom = sno_dt_spg.codnom ". " AND sno_periodo.codperi = sno_dt_spg.codperi ) as fechasper, ". " '-------------------------' as codestpro1, '-------------------------' as codestpro2, ". " '-------------------------' as codestpro3, '-------------------------' as codestpro4, ". " '-------------------------' as codestpro5, '-' as estcla ". " FROM sno_dt_spg ". " WHERE codemp='".$ls_codemp."'". " AND codcom='".$as_codcom."' ". $ls_group. " UNION ". "SELECT descripcion, cod_pro, ced_bene, tipo_destino, MAX(operacion) AS operacion, codcomapo, ". " (SELECT nompro FROM rpc_proveedor ". " WHERE rpc_proveedor.codemp = sno_dt_spi.codemp ". " AND rpc_proveedor.cod_pro = sno_dt_spi.cod_pro ) as nompro, ". " (SELECT nombene FROM rpc_beneficiario ". " WHERE rpc_beneficiario.codemp = sno_dt_spi.codemp ". " AND rpc_beneficiario.ced_bene = sno_dt_spi.ced_bene ) as nombene, ". " (SELECT apebene FROM rpc_beneficiario ". " WHERE rpc_beneficiario.codemp = sno_dt_spi.codemp ". " AND rpc_beneficiario.ced_bene = sno_dt_spi.ced_bene ) as apebene, ". " (SELECT MAX(fechasper) FROM sno_periodo ". " WHERE sno_periodo.codemp = sno_dt_spi.codemp ". " AND sno_periodo.codnom = sno_dt_spi.codnom ". " AND sno_periodo.codperi = sno_dt_spi.codperi ) as fechasper, ". " codestpro1, codestpro2, codestpro3, codestpro4, codestpro5, estcla ". " FROM sno_dt_spi ". " WHERE codemp='".$ls_codemp."' ". " AND codcom='".$as_codcom."' ". $ls_group. " UNION ". "SELECT descripcion, cod_pro, ced_bene, tipo_destino, ".$ls_cadena.", codcomapo, ". " (SELECT nompro FROM rpc_proveedor ". " WHERE rpc_proveedor.codemp = sno_dt_scg.codemp ". " AND rpc_proveedor.cod_pro = sno_dt_scg.cod_pro ) as nompro, ". " (SELECT nombene FROM rpc_beneficiario ". " WHERE rpc_beneficiario.codemp = sno_dt_scg.codemp ". " AND rpc_beneficiario.ced_bene = sno_dt_scg.ced_bene ) as nombene, ". " (SELECT apebene FROM rpc_beneficiario ". " WHERE rpc_beneficiario.codemp = sno_dt_scg.codemp ". " AND rpc_beneficiario.ced_bene = sno_dt_scg.ced_bene ) as apebene, ". " (SELECT MAX(fechasper) FROM sno_periodo ". " WHERE sno_periodo.codemp = sno_dt_scg.codemp ". " AND sno_periodo.codnom = sno_dt_scg.codnom ". " AND sno_periodo.codperi = sno_dt_scg.codperi ) as fechasper, ". " '-------------------------' as codestpro1, '-------------------------' as codestpro2, ". " '-------------------------' as codestpro3, '-------------------------' as codestpro4, ". " '-------------------------' as codestpro5, '-' as estcla ". " FROM sno_dt_scg ". " WHERE codemp='".$ls_codemp."' ". " AND codcom='".$as_codcom."' ". " AND codcom NOT IN (SELECT codcom FROM sno_dt_spg WHERE codemp = '".$ls_codemp."' ) ". " AND codcom NOT IN (SELECT codcom FROM sno_dt_spi WHERE codemp = '".$ls_codemp."' ) ". $ls_group; $rs_data=$io_sql->select($ls_sql); if($rs_data===false) { $io_mensajes->message("ERROR->".$io_funciones->uf_convertirmsg($io_sql->message)); } else { while(!$rs_data->EOF) { $ls_criterio=""; $ls_codcomapo=$rs_data->fields["codcomapo"]; $ls_comprobante=$as_codcom; switch(substr($as_codcom,14,1)) { case "A": // Aportes $ls_criterio = " AND codcomapo = '".$ls_codcomapo."'"; $ls_comprobante=$ls_codcomapo; break; case "L": // Liquidacion $ls_criterio = " AND codcomapo = '".$ls_codcomapo."'"; $ls_comprobante=$ls_codcomapo; break; } $ls_descripcion=$rs_data->fields["descripcion"]; $ls_tipo_destino=$rs_data->fields["tipo_destino"]; $ls_operacion=rtrim($rs_data->fields["operacion"]); $ld_fechasper=$io_funciones->uf_convertirfecmostrar($rs_data->fields["fechasper"]); $_SESSION["fechacomprobante"]=$ld_fechasper; switch($ls_tipo_destino) { case "P": $ls_destino="Proveedor"; $ls_nombre_destino=$rs_data->fields["cod_pro"]." - ".$rs_data->fields["nompro"]; break; case "B": $ls_destino="Beneficiario"; $ls_nombre_destino=$rs_data->fields["ced_bene"]." - ".$rs_data->fields["apebene"].", ".$rs_data->fields["nombene"]; break; case "-": $ls_destino="-"; $ls_nombre_destino="-"; break; } switch($ls_operacion) { case "O": $ls_operacion="COMPROMETE"; break; case "OC": $ls_operacion="COMPROMETE Y CAUSA"; break; case "OCP": $ls_operacion="COMPROMETE, CAUSA Y PAGA"; break; case "CP": $ls_operacion="CAUSAR Y PAGAR"; break; case "DC": $ls_operacion="DEVENGADO Y COBRADO"; break; case "": $ls_operacion="CONTABLE"; break; } print "
| Información del Comprobante | "; print "
Comprobante | ";
print " ".$ls_comprobante." | ";
print "
Fecha | ";
print " ".$ld_fechasper." | ";
print "
Descripción | ";
print " ".$ls_descripcion." | ";
print "
".$ls_destino." | ";
print " ".$ls_nombre_destino." | ";
print "
Contabilización | ";
print " ".$ls_operacion." | ";
print "
| "; print " | "; print " |
| Detalle Presupuestario | "; print "||||
| ".$ls_titulo." | "; print "Estatus | "; print "Cuenta | "; print "Monto | "; print "Disponibilidad | "; print "
| ".$ls_programatica." | "; print "".$ls_estatus." | "; print "".$ls_cuenta." | "; print "".$li_monto." | "; print "|
| Total | "; print "".$li_total." | "; print ""; print " | ||
| Detalle Presupuestario de Ingreso | "; print "|||||||||||
| Cuenta | "; print "Monto | "; print "||||||||||
| Detalle Presupuestario de Ingreso | "; print "|||||||||||
| Estructura Presupuestaria | "; print "Estatus | "; print "Cuenta | "; print "Monto | "; print "||||||||
| ".$ls_cuenta." | "; print "".$li_monto." | "; print "||||||||||
| ".$ls_programatica." | "; print "".$ls_estatus." | "; print "".$ls_cuenta." | "; print "".$li_monto." | "; print "||||||||
| Total | "; print "".$li_total." | "; print "||||||||||
| Detalle Contable | "; print "||
| Cuenta | "; print "Debe | "; print "Haber | "; print "
| ".$ls_cuenta." | "; print "".$li_debe." | "; print "".$li_haber." | "; print "
| ".$ls_cta_cestatikt." | "; print "".$li_debe." | "; print "".$li_total_deb_ct." | "; print "
| ".$ls_cuenta." | "; print "".$li_debe." | "; print "".$li_haber." | "; print "
| Total | "; print "".$li_total_deb." | "; print "".$li_total_hab." | "; print "