/**
* Funcion para Agregar Llamada
*/
function Common_eb8d3f1b179bfca7a3d31880b4d66778($strOrden)
{
$d = explode(STD_LITERAL_DIVISOR, $strOrden, 4);
$socio = $d[0];
$solicitud = $d[1];
$fecha = $d[2];
$hora = $d[3];
$observaciones = "AGREGADO_DESDE_EL_CALENDARIO";
saveError(11, $_SESSION["SN_b80bb7740288fda1f201890375a60c8f"], "Se creo la Llamada del Socio {$socio} por el Credito {$solicitud}");
setNewLlamadaBySocio($socio, $solicitud, $fecha, $hora, $observaciones);
return "Llamada Agregada al socio {$socio} por el Credito {$solicitud}";
}
function setCompacWtExportarPolizas($fecha_inicial, $fecha_final, $FolioInicial = 0, $FolioFinal = 999999, $mTipo = "todas")
{
$sucursal = getSucursal();
//Traducciones del ContPaqw
$CWTipoMvto = array("1" => 1, "-1" => "2");
//Formato : polizas + fecha + sucursal;
$mTmpFileAlias = "{$sucursal}-polizas-" . date("Y-m-d") . "";
$mNametmpFile = PATH_TMP . $mTmpFileAlias . ".txt";
if (file_exists($mNametmpFile)) {
$BKPFile = fopen($mNametmpFile, "a+");
} else {
//$mNametmpFile = tempnam (PATH_BACKUPS, "polizas" . date("Y-m-d") . $sucursal . ".sbk");
$BKPFile = fopen($mNametmpFile, "a");
}
//filtros
$wByTipo = $mTipo == "todas" ? "" : " AND (`contable_polizas`.`tipopoliza` =" . $mTipo . ") ";
//Generar Polizas
$FInicial = $FolioInicial;
$FFinal = $FolioFinal;
$sqlPol = "SELECT\r\n\t\t\t\t\t\t*\r\n\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t`contable_polizas` `contable_polizas` \r\n\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t(`contable_polizas`.`fecha` >='{$fecha_inicial}')\r\n\t\t\t\t\t\t\tAND\r\n\t\t\t\t\t\t\t(`contable_polizas`.`fecha` <='{$fecha_final}')\r\n\t\t\t\t\t\t\tAND\r\n\t\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t(`contable_polizas`.`numeropoliza` >={$FInicial}) \r\n\t\t\t\t\t\t\tAND\r\n\t\t\t\t\t\t\t(`contable_polizas`.`numeropoliza` <={$FFinal}) \r\n\t\t\t\t\t\t\t) {$wByTipo} ";
//echo $sqlPol;
$rs = mysql_query($sqlPol, cnnGeneral());
if (!$rs) {
//Codigo de Control de Error
saveError(2, $_SESSION["SN_b80bb7740288fda1f201890375a60c8f"], "Depurar :" . mysql_error() . "|||Numero: " . mysql_errno() . "|||Instruccion SQL: \n " . $sqlPol);
}
while ($rw = mysql_fetch_array($rs)) {
//Seleccionar los Movimientos
$ejercicio = $rw["ejercicio"];
$periodo = $rw["periodo"];
$tipoPoliza = $rw["tipopoliza"];
$numeroPoliza = $rw["numeropoliza"];
$fechaPoliza = $rw["fecha"];
$conceptoPoliza = $rw["concepto"];
$WriteText = "P " . date("Ymd", strtotime($fechaPoliza));
$WriteText .= " " . $tipoPoliza;
$WriteText .= " " . substr(str_pad($numeroPoliza, 8, "0", STR_PAD_LEFT), -8);
$WriteText .= " 1 000 " . substr(str_pad($conceptoPoliza, 100, " ", STR_PAD_RIGHT), 0, 100);
$WriteText .= " 01 2 \r\n";
//Escribe la Poliza
@fwrite($BKPFile, $WriteText);
/*
3 Caracter para quien sabe.- Diario.- supongo
2 Caracter para quien sabe
1 Caracter Espacion
1 Caracter Para quien Sabe
1 Caracter Espacio
*/
$sqlMvtos = "SELECT\r\n\t\t\t\t\t\t`contable_movimientos`.* \r\n\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t`contable_movimientos` `contable_movimientos` \r\n\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t(`contable_movimientos`.`ejercicio` ={$ejercicio}) AND\r\n\t\t\t\t\t\t\t(`contable_movimientos`.`periodo` ={$periodo}) AND\r\n\t\t\t\t\t\t\t(`contable_movimientos`.`tipopoliza` ={$tipoPoliza}) AND\r\n\t\t\t\t\t\t\t(`contable_movimientos`.`numeropoliza` ={$numeroPoliza})\r\n\t\t\t\t\t\tORDER BY `contable_movimientos`.`ejercicio`,\r\n\t\t\t\t\t\t`contable_movimientos`.`periodo`,\r\n\t\t\t\t\t\t`contable_movimientos`.`tipopoliza`,\r\n\t\t\t\t\t\t`contable_movimientos`.`numeropoliza`,\r\n\t\t\t\t\t\t`contable_movimientos`.`numeromovimiento`\r\n\t\t\t\t\t\t";
$MRs = mysql_query($sqlMvtos, cnnGeneral());
while ($MRw = mysql_fetch_array($MRs)) {
$cuenta = $MRw["numerocuenta"];
$referencia = $MRw["referencia"];
//Corrige la Cuenta de Cuadre
if ($cuenta == CUENTA_DE_CUADRE) {
$cuenta = "_CUADRE";
}
//Tipo M + espacio
//Cuenta 20
//Referencia 10
//TipoMvto 2 espacios 1 Cargo 2 Abono
//Importe 16 Alineado
//espacio + 000 + espacio + " 0.00 "
//concepto 30 + espacio
$WriteMvto = "M " . substr(str_pad($cuenta, 20, " ", STR_PAD_RIGHT), 0, 20);
$WriteMvto .= " " . substr(str_pad($referencia, 10, " ", STR_PAD_RIGHT), 0, 10);
$WriteMvto .= " " . $CWTipoMvto[$MRw["tipomovimiento"]];
$WriteMvto .= " " . substr(str_pad($MRw["importe"], 16, " ", STR_PAD_LEFT), -16);
$WriteMvto .= " 000 " . " 0.00 " . substr(str_pad($MRw["concepto"], 30, " ", STR_PAD_RIGHT), 0, 30) . " \r\n";
@fwrite($BKPFile, $WriteMvto);
}
}
@fclose($BKPFile);
return "<a href=\"../utils/download.php?type=txt&download={$mTmpFileAlias}&file={$mTmpFileAlias}\" target=\"_blank\" class='boton'>Descargar Archivo de Polizas</a>";
}
function getSIPAKALPermissions($myFile)
{
//Tratar el __FILE__, eliminar el directorio
$vUno = substr_count($myFile, "/");
$vDos = substr_count($myFile, "\\");
$notes = "";
$pUSRID = isset($_SESSION["SN_b80bb7740288fda1f201890375a60c8f"]) ? $_SESSION["SN_b80bb7740288fda1f201890375a60c8f"] : 0;
$pUSRNivel = isset($_SESSION["SN_d567c9b2d95fbc0a51e94d665abe9da3"]) ? $_SESSION["SN_d567c9b2d95fbc0a51e94d665abe9da3"] : 0;
$pUSRPWD = isset($_SESSION["SN_0d35c1f17675a8a2bf3caaacd59a65de"]) ? $_SESSION["SN_0d35c1f17675a8a2bf3caaacd59a65de"] : "";
$mUSR = isset($_SESSION["SN_0a744893951e0d1706ff74a7afccf561"]) ? $_SESSION["SN_0a744893951e0d1706ff74a7afccf561"] : "";
//
//obtener variables por CONTEXT
if (isset($_REQUEST)) {
if (isset($_REQUEST["ctx"])) {
$ctx = md5($_REQUEST["ctx"]);
$sql = "SELECT\t`t_03f996214fba4a1d05a68b18fece8e71`.*\r\n\t\t\tFROM `t_03f996214fba4a1d05a68b18fece8e71` WHERE \r\n\t\t\t(MD5(MD5(CONCAT(MD5(`t_03f996214fba4a1d05a68b18fece8e71`.`idusuarios`) , '|', MD5(`t_03f996214fba4a1d05a68b18fece8e71`.`f_34023acbff254d34664f94c3e08d836e`)))) = '{$ctx}') \r\n\t\t\tOR\r\n\t\t\t(MD5(MD5(CONCAT(MD5(`t_03f996214fba4a1d05a68b18fece8e71`.`f_28fb96d57b21090705cfdf8bc3445d2a`) , '|', MD5(`t_03f996214fba4a1d05a68b18fece8e71`.`f_34023acbff254d34664f94c3e08d836e`)))) = '{$ctx}')\r\n\t\t\tLIMIT 0,1 ";
//$notes = $sql;
$xMQL = new MQL();
$data = $xMQL->getDataRecord($sql);
foreach ($data as $rows) {
$pUSRID = $rows["idusuarios"];
$pUSRNivel = $rows["f_f2cd801e90b78ef4dc673a4659c1482d"];
$pUSRPWD = $rows["f_34023acbff254d34664f94c3e08d836e"];
$mUSR = $rows["f_28fb96d57b21090705cfdf8bc3445d2a"];
$_SESSION["SN_b80bb7740288fda1f201890375a60c8f"] = $pUSRID;
$_SESSION["SN_d567c9b2d95fbc0a51e94d665abe9da3"] = $pUSRNivel;
$_SESSION["SN_0d35c1f17675a8a2bf3caaacd59a65de"] = $pUSRPWD;
$_SESSION["SN_0a744893951e0d1706ff74a7afccf561"] = $mUSR;
}
//
}
}
$PUBLICSVC = array("personas.svc.php" => true, "personas.actividades.economicas.php" => true, "listanegra.svc.php" => true, "equivalente.moneda.svc.php" => true, "cantidad_en_letras.php" => true);
//servicios publicos
$PFile = "";
$myPermission = false;
if ($vUno >= 1) {
$DCFile = explode("/", $myFile);
$elems = count($DCFile) - 1;
if ($elems >= 0) {
$PFile = $DCFile[$elems];
}
} else {
$DCFile = explode("\\", $myFile);
$elems = count($DCFile) - 1;
if ($elems >= 0) {
$PFile = $DCFile[$elems];
}
}
if (isset($PUBLICSVC[$PFile])) {
$myPermission = true;
//setLog("Acceso Publico al Servicio $PFile");
} else {
$tmpPWD = $mUSR != "" ? goLogged("contrasenna", $mUSR) : md5(session_id());
if ($tmpPWD != $pUSRPWD) {
$myPermission = false;
//salvar el error
saveError(98, session_id(), "NO HA DEFINIDO UNA SESSION PARA EL ARCHIVO {$myFile} {$notes}");
//salir si no esta definida la session
session_unset();
// Finalmente, destruye la sesión
session_destroy();
header("location:inicio.php");
exit;
}
$myPermission = false;
//checar si la variable esta inicializada
//si no enviar un unsetsession
if (isset($pUSRNivel) and $pUSRNivel > 0) {
$sqlRULES = "SELECT COUNT(idgeneral_menu) AS 'items', menu_rules FROM general_menu\r\n\t\t\t\t\t\tWHERE menu_file LIKE '%{$PFile}'\r\n\t\t\t\t\t\tAND (FIND_IN_SET('{$pUSRNivel}@rw', menu_rules)>0\r\n\t\t\t\t\t\tOR FIND_IN_SET('{$pUSRNivel}@ro', menu_rules)>0)\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t/*LIMIT 0,1*/ ";
//setLog($sqlRULES);
$cnxT = mysql_connect(WORK_HOST, USR_PERMISSIONS, PWD_PERMISSIONS);
$dbT = mysql_select_db(MY_DB_IN, $cnxT);
$rsRULES = mysql_query($sqlRULES, $cnxT);
if (!isset($rsRULES)) {
saveError(98, $_SESSION["SN_b80bb7740288fda1f201890375a60c8f"], mysql_error($cnxT));
}
$aRULES = mysql_fetch_array($rsRULES);
/**
* Verifica la autenticacion
* busca la pocision del permiso
* //
**/
$mos = strtoupper(substr(PHP_OS, 0, 3));
$myFile = str_replace("/", "|", $myFile);
$myFile = str_replace("\\", "|", $myFile);
$dFile = explode("|", $myFile);
$idfile = sizeof($dFile) - 1;
$myFile = $dFile[$idfile - 1] . "/" . $dFile[$idfile];
//DIRECTORY_SEPARATOR
if ($aRULES["items"] == 0) {
$sqlA = "INSERT INTO `general_menu` (`menu_title`, `menu_file`) VALUES ('{$PFile}', '{$myFile}')";
@mysql_query($sqlA, $cnxT);
}
if (!isset($aRULES["menu_rules"]) or empty($aRULES["menu_rules"]) or $aRULES["menu_rules"] == "") {
//saveError(97, $_SESSION["SN_b80bb7740288fda1f201890375a60c8f"], $sqlRULES);
saveError(999, $_SESSION["SN_b80bb7740288fda1f201890375a60c8f"], "Acceso no permitido a :" . addslashes($myFile) . " {$notes}");
$myPermission = false;
} else {
$ARls = explode(",", $aRULES["menu_rules"]);
if (in_array("{$pUSRNivel}@rw", $ARls)) {
$myPermission = "ReadWrite";
} else {
$myPermission = "ReadOnly";
}
}
@mysql_free_result($rsRULES);
@mysql_close($cnxT);
unset($rsRULES);
unset($cnxT);
unset($dbT);
} else {
$myPermission = false;
//salvar el error
saveError(98, session_id(), "NO HA DEFINIDO UNA SESSION PARA EL ARCHIVO {$myFile} {$notes}\r\n");
//salir si no esta definida la session
session_unset();
// Finalmente, destruye la sesión
session_destroy();
header("location:inicio.php");
exit;
}
}
return $myPermission;
}
<?php
/**
* @author Balam Gonzalez Luis Humberto
* @version 1.0
* @package caja.forms
*
*/
//=====================================================================================================
include_once "../core/go.login.inc.php";
include_once "../core/core.error.inc.php";
include_once "../core/core.html.inc.php";
include_once "../core/core.init.inc.php";
$permiso = getSIPAKALPermissions(__FILE__);
if ($permiso === false) {
saveError(999, $_SESSION["SN_b80bb7740288fda1f201890375a60c8f"], "Acceso no permitido a :" . addslashes(__FILE__));
header("location:404.php?i=999");
} else {
$_SESSION["current_file"] = addslashes(__FILE__);
}
$iduser = $_SESSION["log_id"];
//=====================================================================================================
$xHP = new cHPage("TR.Cobro de Multas");
$idrecibo = 0;
$xCaja = new cCaja();
$jscallback = parametro("callback");
$tiny = parametro("tiny");
$form = parametro("form");
$action = parametro("action", SYS_NINGUNO);
$fecha = parametro("idfecha-0", false, MQL_DATE);
$fecha = parametro("idfechaactual", $fecha, MQL_DATE);
$permiso = getSIPAKALPermissions($theFile);
if ($permiso === false) {
header("location:../404.php?i=999");
}
$_SESSION["current_file"] = addslashes($theFile);
//<===== FIN_H
$iduser = $_SESSION["log_id"];
//=====================================================================================================
include_once "../core/entidad.datos.php";
include_once "../core/core.deprecated.inc.php";
include_once "../core/core.fechas.inc.php";
include_once "../libs/sql.inc.php";
include_once "../core/core.config.inc.php";
include_once "../core/core.operaciones.inc.php";
$oficial = elusuario($iduser);
$idrec = $_POST["idrecibo"];
//$frn = $_GET["u"];
if (!$idrec) {
echo JS_CLOSE;
}
$cRec = new cReciboDeOperacion(false, false, $idrec);
$cRec->setNumeroDeRecibo($idrec);
$cRec->setRevertir();
//echo $cRec->getMessages("html");
saveError(10, $_SESSION["SN_b80bb7740288fda1f201890375a60c8f"], "EL Usuario {$oficial} Elimino el Recibo {$idrec} y sus Operaciones");
if ($u == "exn") {
header("location: frmeditarrecibos.php");
} else {
header("location: frmeliminarrecibos.php");
}
//*/
//$mNametmpFile = tempnam (PATH_BACKUPS, "polizas" . date("Y-m-d") . $sucursal . ".sbk");
$BKPFile = fopen($mNametmpFile, "a");
}
//filtros
$wByTipo = $_POST["ctipopolizas"] == "todas" ? "" : " AND (`contable_polizas`.`tipopoliza` =" . $_POST["ctipopolizas"] . ") ";
//Generar Polizas
$fecha_inicial = $_POST["elanno0"] . "-" . $_POST["elmes0"] . "-" . $_POST["eldia0"];
$fecha_final = $_POST["elanno1"] . "-" . $_POST["elmes1"] . "-" . $_POST["eldia1"];
$FInicial = $_POST["cNumeroInicial"];
$FFinal = $_POST["cNumeroFinal"];
$sqlPol = "SELECT\n\t\t\t\t\t\t*\n\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t`contable_polizas` `contable_polizas` \n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t(`contable_polizas`.`fecha` >='{$fecha_inicial}')\n\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t(`contable_polizas`.`fecha` <='{$fecha_final}')\n\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t(`contable_polizas`.`numeropoliza` >={$FInicial}) \n\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t(`contable_polizas`.`numeropoliza` <={$FFinal}) \n\t\t\t\t\t\t\t) {$wByTipo} ";
//echo $sqlPol;
$rs = mysql_query($sqlPol, cnnGeneral());
if (!$rs) {
//Codigo de Control de Error
saveError(2, $_SESSION["SN_b80bb7740288fda1f201890375a60c8f"], "Depurar :" . mysql_error() . "|||Numero: " . mysql_errno() . "|||Instruccion SQL: \n " . $sqlPol);
}
while ($rw = mysql_fetch_array($rs)) {
//Seleccionar los Movimientos
$ejercicio = $rw["ejercicio"];
$periodo = $rw["periodo"];
$tipoPoliza = $rw["tipopoliza"];
$numeroPoliza = $rw["numeropoliza"];
$fechaPoliza = $rw["fecha"];
$conceptoPoliza = $rw["concepto"];
$WriteText = "P " . date("Ymd", strtotime($fechaPoliza));
$WriteText .= " " . $tipoPoliza;
$WriteText .= " " . substr(str_pad($numeroPoliza, 8, "0", STR_PAD_LEFT), -8);
$WriteText .= " 1 000 " . substr(str_pad($conceptoPoliza, 100, " ", STR_PAD_RIGHT), 0, 100);
$WriteText .= " 01 2 \n";
//Escribe la Poliza
function setExport($FechaInicial = false, $FechaFinal = false)
{
$wByFi = $FechaInicial == false ? "" : " WHERE fecha_de_alta>='{$FechaInicial}' ";
$wByFf = $FechaFinal == false ? "" : " AND fecha_de_alta<='{$FechaFinal}' ";
$sucursal = getSucursal();
$arrTipos = array("AD" => "A", "AA" => "B", "PD" => "C", "PA" => "D", "CD" => "E", "CA" => "F", "RD" => "G", "RA" => "H", "OD" => "K", "OA" => "L", "ED" => "I", "EA" => "J");
//safe => Compaq
$arrMayor = array("3" => "1", "4" => "2", "1" => "3", "2" => "4");
//3 safe mayor
$WriteText = "F 00000000000000\r\n";
//cuenta de flujo de efectivo
$sql = "SELECT numero, equivalencia, nombre, tipo, ctamayor, afectable, centro_de_costo, fecha_de_alta, digitoagrupador \r\n \t\t\tFROM contable_catalogo {$wByFi} {$wByFf} \r\n \t\t\tORDER BY numero\r\n \t\t\t";
$rs = mysql_query($sql, cnnGeneral());
if (!$rs) {
//Codigo de Control de Error
saveError(2, $_SESSION["SN_b80bb7740288fda1f201890375a60c8f"], "Depurar :" . mysql_error() . "|||Numero: " . mysql_errno() . "|||Instruccion SQL: \n " . $sql);
}
//$WriteText .= "$sql\r\n";
while ($rw = mysql_fetch_array($rs)) {
//XXX: Si el titulo asignar 0 a superior
//$WriteText .= "C ";
//CompAQi
$WriteText .= "C ";
//$WriteText .= substr(str_pad($rw["numero"], 20, " ", STR_PAD_RIGHT), 0, 20);
$WriteText .= substr(str_pad($rw["numero"], 30, " ", STR_PAD_RIGHT), 0, 30);
$WriteText .= " ";
$WriteText .= substr(str_pad(trim($rw["nombre"]), 50, " ", STR_PAD_RIGHT), 0, 50);
$WriteText .= " ";
$WriteText .= substr(str_pad("", 50, " ", STR_PAD_RIGHT), 0, 50);
$WriteText .= " ";
//cuenta superior, mod a 30. compaqi
//$WriteText .= substr(str_pad( cuenta_superior( $rw["numero"] ), 20, " ", STR_PAD_RIGHT), 0, 20);
$WriteText .= $rw["ctamayor"] == 1 ? substr(str_pad(cuenta_superior("0"), 30, " ", STR_PAD_RIGHT), 0, 30) : substr(str_pad(cuenta_superior($rw["numero"]), 30, " ", STR_PAD_RIGHT), 0, 30);
$WriteText .= " ";
$WriteText .= $arrTipos[$rw["tipo"]];
$WriteText .= " ";
$WriteText .= "0 ";
//Baja
$WriteText .= $arrMayor[$rw["ctamayor"]];
$WriteText .= " ";
$WriteText .= "0 ";
$WriteText .= date("Ymd", strtotime($rw["fecha_de_alta"]));
$WriteText .= " ";
//Actualizacion ContPAQi
$WriteText .= "81 ";
//Sistema de Origen
$WriteText .= " 1 ";
//Moneda
$WriteText .= " 0 ";
//Digito Agrupador
$WriteText .= "0 ";
//Segmento de Negocio
$WriteText .= "0 ";
//Mvto.Segmento de Negocio
$WriteText .= "\r\n";
//$WriteText .= "01 01 0000 000\r\n";
}
$nombre = "{$sucursal}-catalogo-contable-" . date("Ymd", strtotime(fechasys())) . "-" . rand(0, 1000) . "";
$xFile = new cFileLog($nombre);
$xFile->setWrite($WriteText);
$xFile->setClose();
return $xFile->getLinkDownload($nombre);
}
function SearchRecord($filter)
{
$limit_find = 5;
$n_type = gettype($filter);
if ($n_type == "string") {
$filter = "'%{$filter}%'";
} else {
$filter = "'%{$filter}%'";
}
$sql = "SELECT * FROM general_formulas WHERE aplicado_a LIKE {$filter} LIMIT 0,{$limit_find}";
$rs = mysql_query($sql, cnnGeneral());
if (!$rs) {
saveError(2, $_SESSION["SN_b80bb7740288fda1f201890375a60c8f"], "Depurar :" . mysql_error() . "|Numero: " . mysql_errno() . "|Instruccion SQL:" . $sql);
}
$tds = "";
while ($row = mysql_fetch_array($rs)) {
$tds = $tds . "<tr> \r\n\r\n <th onclick='cmdClick(" . $row["aplicado_a"] . "); jsGetRegistro(); '>" . $row["aplicado_a"] . "</th>\r\n <td>{$row['1']}</td> \r\n\r\n </tr> \r\n ";
}
@mysql_free_result($rs);
return "<div id='i_lst'>\r\n <table border='1'> \r\n {$tds} \r\n </table>\r\n </div>\r\n ";
}
function getTabla($caption)
{
$table = "";
$td = "";
$head = "";
if ($caption) {
$this->mTitle = $caption;
$head = "<tr>\n\t\t\t\t<td colspan='3' class='csubtitle'>{$caption}</td>\n\t\t\t\t</tr>";
}
$rs = mysql_query($this->mSql, cnnGeneral());
if (!$rs) {
saveError(2, $_SESSION["SN_b80bb7740288fda1f201890375a60c8f"], "Depurar :" . mysql_error() . "|Numero: " . mysql_errno() . "|Instruccion SQL:" . $this->mSql . "|EN:" . $_SESSION["current_file"]);
}
while ($rw = mysql_fetch_array($rs)) {
$numero = $rw["numero"];
$nombre = $rw["nombre"];
$importe = $rw["imp" . $this->mPeriodo] * $this->factor;
if ($importe < 0) {
//$importe = $importe * -1;
}
$importe_fmt = getFMoney($importe);
$td = $td . "\n\t\t<tr>\n\t\t\t<td class='cmayor'>{$nombre}</td>\n\t\t\t<td class='mny' width='20%'>{$importe_fmt}</td>\n\t\t\t<td width='20%'></td>\n\t\t</tr>";
$this->mSuma += $importe;
}
@mysql_free_result($rs);
$suma_fmt = getFMoney($this->mSuma);
return "<table width='100%'>\n\t<tbody>\n\t{$head}\n\t{$td}\n\t\t<tr>\n\t\t\t<td class=\"csubtitle-footer\">TOTAL " . $this->mTitle . "</td>\n\t\t\t<td></td>\n\t\t\t<th class='mny'> " . $suma_fmt . " </th>\n\t\t</tr>\n\t</tbody>\n</table>";
}
function setEndSession()
{
$oficial = $this->getUserInfo();
$iduser = $this->mCodeUser;
$oficial = elusuario($iduser);
/**
* Eliminar al Usuarios de Conectados
*/
$mduser = md5($iduser);
$sqlDELCnn = "DELETE FROM usuarios_web_connected WHERE webid='{$mduser}' ";
my_query($sqlDELCnn);
saveError(10, $this->mCodeUser, "{$oficial} cerro sesion");
// sin variables
session_unset();
//$_SESSION = array();
session_destroy();
}
$_SESSION["en_depurado"] = true;
}
saveError(10, session_id(), "El Usuario {$iUser} Inicio Sesion ");
/**
* Agregar a Conectados al usuario
*/
$mdID = md5($ciduser);
//option1 = fecha
//option2 = hora
$opt1 = date("Y-m-d");
$opt2 = date("H:i:s");
$sqlNCnn = "INSERT INTO usuarios_web_connected\r\n\t\t\t\t\t\t(webid, option1, option2)\r\n \t\t\t\t\tVALUES\r\n\t\t\t\t\t\t('{$mdID}', '{$opt1}', '{$opt2}')";
$xcnn = new mysqli(WORK_HOST, USR_ERROR, PWD_ERROR, MY_DB_IN, PORT_HOST);
$xcnn->query($sqlNCnn);
$xcnn->close();
header("location:{$fileSet}");
//====== Eliminar datos del usuario
unset($ciduser);
unset($nivel);
unset($iPwd);
unset($iUser);
} else {
saveError(98, session_id(), "{$iUser} Datos Incorrectos ");
header("location:inicio.php");
exit;
}
} else {
saveError(98, session_id(), "Faltan Datos para Iniciar session");
header("location:inicio.php");
exit;
}
function __construct($aplicado_a)
{
$sql = "SELECT * FROM general_formulas WHERE aplicado_a='{$aplicado_a}' LIMIT 0,1";
$rs = mysql_query($sql, cnnGeneral());
if (!$rs) {
saveError(2, $_SESSION["SN_b80bb7740288fda1f201890375a60c8f"], "Depurar :" . mysql_error() . "|Numero: " . mysql_errno() . "|Instruccion SQL: \n " . $sql . "|EN:" . $_SESSION["current_file"]);
}
$this->mInfoF = mysql_fetch_array($rs);
$this->mEstruct = $this->mInfoF["estructura_de_la_formula"];
@mysql_free_result($rs);
}
/** Devuelve cualquier dato de la tabla segun indice e id dado */
function damecredito($jimbo)
{
//SOLICITUD,IDCAMPO
$kimbo = explode(" ", $jimbo);
if (isset($kimbo[0]) and trim($kimbo[0]) != "") {
$sqlbind = "SELECT * FROM creditos_solicitud\r\n\t\t\t\t\tWHERE numero_solicitud={$kimbo['0']} LIMIT 0,1";
$tirar = 0;
$rsbind = mysql_query($sqlbind, cnnGeneral());
if (!$rsbind) {
saveError(2, $_SESSION["SN_b80bb7740288fda1f201890375a60c8f"], "Depurar :" . mysql_error() . "|Numero: " . mysql_errno() . "|Instruccion SQL:" . $sqlbind);
} else {
while ($rw = mysql_fetch_array($rsbind)) {
$tirar = $rw[$kimbo[1]];
}
}
return $tirar;
@mysql_free_result($rsbind);
} else {
//saveError(2,$_SESSION["SN_b80bb7740288fda1f201890375a60c8f"], "Depurar :SQL Fallido o sin algun dato");
return 0;
}
}
$operacion = $DPar[5];
if ($aPagaCompleto[$operacion] == true) {
$pago_total = true;
$monto_a_operar = TESORERIA_MONTO_MAXIMO_OPERADO;
}
$mTipoPago = isset($DPar[6]) ? trim($DPar[6]) : DEFAULT_TIPO_PAGO;
$mReciboFiscal = isset($DPar[7]) ? $DPar[7] : DEFAULT_RECIBO_FISCAL;
$procesado = isset($_GET["procesar"]) ? $_GET["procesar"] : "normal";
$total = 0;
$tdCobranza = "";
$claveCbza = OPERACION_CLAVE_DE_COBRANZA;
$generarIVA = isset($aActosNoGravados[$mTipoPago]) ? false : true;
$montoCobranza = 0;
for ($ix = 0; $ix <= $limParms; $ix++) {
if (!isset($DPar[$ix]) or $DPar[$ix] == "") {
saveError(210, $_SESSION["SN_b80bb7740288fda1f201890375a60c8f"], "Faltan Parametros({$params}) para el cobro, el Parametro {$ix} resulto " . $DPar[$ix]);
header("location:../404.php?i=210");
//provocar error 404
exit;
}
}
$xCred = new cCredito($solicitud, $socio);
$xCred->init();
$xLetra = null;
$tds = "";
$esp_tds = "";
$mMvtos = array();
$alerts = "";
//Movimientos que afectan al Capital
$cAfectCapital = new cBases(2004);
$aAfectCapital = $cAfectCapital->getMembers_InArray();
