class_datastore PHP 코드 예제들

예제 #1

0

파일 보기

파일: sigesp_saf_cat_pais.php 프로젝트: ssolano/cafe_sigesp

function uf_imprimirresultados($as_codpai, $as_despai)
{
    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_msg = new class_mensajes();
    require_once "../shared/class_folder/class_sql.php";
    $io_sql = new class_sql($con);
    $ds = new class_datastore();
    print "<table width=500 border=0 cellpadding=1 cellspacing=1 class=fondo-tabla align=center>";
    print "<tr class=titulo-celda>";
    print "<td width=60>Código</td>";
    print "<td width=440>Descripción</td>";
    print "</tr>";
    $ls_sql = "SELECT codpai,despai FROM sigesp_pais" . " WHERE codpai like '" . $as_codpai . "'" . " AND despai like '" . $as_despai . "'";
    $rs_pai = $io_sql->select($ls_sql);
    if ($row = $io_sql->fetch_row($rs_pai)) {
        $data = $io_sql->obtener_datos($rs_pai);
        $ds->data = $data;
        $li_rows = $ds->getRowCount("codpai");
        for ($li_index = 1; $li_index <= $li_rows; $li_index++) {
            print "<tr class=celdas-blancas>";
            $ls_codpai = $data["codpai"][$li_index];
            $ls_despai = $data["despai"][$li_index];
            print "<td><a href=\"javascript: aceptar('{$ls_codpai}','{$ls_despai}');\">" . $ls_codpai . "</a></td>";
            print "<td>" . $ls_despai . "</td>";
            print "</tr>";
        }
    } else {
        $io_msg->message("No hay registros");
    }
    print "</table>";
}

예제 #2

0

파일 보기

파일: sigesp_cat_estado.php 프로젝트: ssolano/cafe_sigesp

   function uf_imprimirresultados($as_codpai, $as_codest, $as_desest)
   {
		require_once("..\shared\class_folder\sigesp_include.php");
		$in=new sigesp_include();
		$con=$in->uf_conectar();
		require_once("..\shared\class_folder\class_mensajes.php");
		$msg=new class_mensajes();
		require_once("..\shared\class_folder\class_sql.php");
		$SQL=new class_sql($con);
		$ds=new class_datastore();
		print "<table width=500 border=0 cellpadding=1 cellspacing=1 class=fondo-tabla align=center>";
		print "<tr class=titulo-celda>";
		print "<td width=60>Código</td>";
		print "<td width=440>Descripción</td>";
		print "</tr>";
		$ls_sql="SELECT codest,desest FROM sigesp_estados".
				" WHERE (codpai='".$as_codpai."')".
				" AND(codest like '".$as_codest."'".
				" AND desest like '".$as_desest."')";
				
		$rs_est=$SQL->select($ls_sql);
		if($row=$SQL->fetch_row($rs_est))
		{
			$data=$SQL->obtener_datos($rs_est);
			$ds->data=$data;
			$li_rows=$ds->getRowCount("codest");
			for($li_index=1;$li_index<=$li_rows;$li_index++)
			{
				print "<tr class=celdas-blancas>";
				$ls_codest=$data["codest"][$li_index];
				$ls_desest=$data["desest"][$li_index];
				
				print "<td><a href=\"javascript: aceptar('$ls_codest','$ls_desest');\">".$ls_codest."</a></td>";
				print "<td>".$ls_desest."</td>";
				print "</tr>";			
			}
		}
		print "</table>";
   }

예제 #3

0

파일 보기

파일: sigesp_spg_cat_ctaspg.php 프로젝트: ssolano/cafe_sigesp

$ls_loncodestpro3 = $_SESSION["la_empresa"]["loncodestpro3"];
$li_longestpro3 = 25 - $ls_loncodestpro3 + 1;
if ($li_estmodest == '2') {
    $ls_loncodestpro4 = $_SESSION["la_empresa"]["loncodestpro4"];
    $li_longestpro4 = 25 - $ls_loncodestpro4 + 1;
    $ls_loncodestpro5 = $_SESSION["la_empresa"]["loncodestpro5"];
    $li_longestpro5 = 25 - $ls_loncodestpro5 + 1;
}
$in = new sigesp_include();
$con = $in->uf_conectar();
$dat = $_SESSION["la_empresa"];
$io_msg = new class_mensajes();
$grid = new grid_param();
$io_funcion = new class_funciones();
$io_sql = new class_sql($con);
$io_ds = new class_datastore();
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Cat&aacute;logo de Cuentas Presupuestarias</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
a:link {
	color: #006699;
}
a:visited {
	color: #006699;
}

예제 #4

0

파일 보기

파일: sigesp_cxp_cat_documentos.php 프로젝트: ssolano/cafe_sigesp

</style></head>

<body>
<table width="500" border="0" align="center" cellpadding="1" cellspacing="1">
  <tr>
   <td width="496" colspan="2" class="titulo-celda">Cat&aacute;logo de Documentos</td>
  </tr>
</table>
<div align="center"><br>
  <?php 
require_once "../../shared/class_folder/sigesp_include.php";
require_once "../../shared/class_folder/class_datastore.php";
require_once "../../shared/class_folder/class_sql.php";
$io_in = new sigesp_include();
$con = $io_in->uf_conectar();
$io_ds = new class_datastore();
$io_sql = new class_sql($con);
$arr = $_SESSION["la_empresa"];
$ls_sql = " SELECT codtipdoc,dentipdoc,estpre,estcon,tipodocanti " . " FROM cxp_documento " . " ORDER BY codtipdoc ASC";
$rs_doc = $io_sql->select($ls_sql);
$data = $rs_doc;
if ($row = $io_sql->fetch_row($rs_doc)) {
    //1
    $data = $io_sql->obtener_datos($rs_doc);
    $arrcols = array_keys($data);
    $totcol = count($arrcols);
    $io_ds->data = $data;
    $totrow = $io_ds->getRowCount("codtipdoc");
    print "<table width=500 border=0 cellpadding=1 cellspacing=1 class=fondo-tabla>";
    print "<tr class=titulo-celda>";
    print "<td>Código </td>";

예제 #5

0

파일 보기

파일: sigesp_scb_class_report_ori.php 프로젝트: ssolano/cafe_sigesp

	function uf_calcular($data,$ls_mesano)		 
	{
		$ds_mov=new class_datastore();	
		$ds_mov->data=$data;
		$li_total=$ds_mov->getRowCount("numdoc");
		$ldec_CreditosTmp=0;
		$ldec_CreditosTmpNeg=0;
		$ldec_DebitosTmp=0;
		$ldec_DebitosTmpNeg=0;
		for($li_i=1;$li_i<=$li_total;$li_i++)
		{
			$ls_codope=$ds_mov->getValue("codope",$li_i);
			$ls_estmov=$ds_mov->getValue("estmov",$li_i);
			$ldec_monto=$ds_mov->getValue("monto",$li_i);
			if((($ls_codope=='CH')||($ls_codope=='ND')||($ls_codope=='RE'))&&($ls_estmov<>'A'))
			{
				$ldec_CreditosTmp=$ldec_CreditosTmp+$ldec_monto;
			}
			if((($ls_codope=='CH')||($ls_codope=='ND')||($ls_codope=='RE'))&&($ls_estmov=='A'))
			{
				$ldec_CreditosTmpNeg=$ldec_CreditosTmpNeg+$ldec_monto;
			}
			if((($ls_codope=='DP')||($ls_codope=='NC'))&&($ls_estmov<>'A'))
			{
				$ldec_DebitosTmp=$ldec_DebitosTmp+$ldec_monto;
			}
			if((($ls_codope=='DP')||($ls_codope=='NC'))&&($ls_estmov=='A'))
			{
				$ldec_DebitosTmpNeg=$ldec_DebitosTmpNeg+$ldec_monto;
			}
		}
		$ldec_DebitosAnt = $ldec_DebitosTmp-$ldec_DebitosTmpNeg;
		$ldec_CreditosAnt = $ldec_CreditosTmp-$ldec_CreditosTmpNeg;
		$ldec_SaldoAnterior = $ldec_DebitosAnt - $ldec_CreditosAnt;
				
		return round($ldec_SaldoAnterior,2);	
	
	}

예제 #6

0

파일 보기

파일: sigesp_cxp_rfs_solicitudes_sata.php 프로젝트: ssolano/cafe_sigesp

    $la_columnas = array('titulo' => '<b>Factura</b>', 'monto' => '<b>Total</b>');
    $la_config = array('showHeadings' => 0, 'fontSize' => 9, 'titleFontSize' => 12, 'showLines' => 0, 'shaded' => 0, 'width' => 540, 'maxWidth' => 540, 'xOrientation' => 'center', 'outerLineThickness' => 0.5, 'innerLineThickness' => 0.5, 'cols' => array('titulo' => array('justification' => 'right', 'width' => 480), 'monto' => array('justification' => 'right', 'width' => 90)));
    // Justificación y ancho de la columna
    $io_pdf->ezTable($la_datatot, $la_columnas, '', $la_config);
}
// end function uf_print_total_bsf
//-----------------------------------------------------------------------------------------------------------------------------------
//-----------------------------------------------------  Instancia de las clases  ------------------------------------------------
require_once "../../shared/ezpdf/class.ezpdf.php";
require_once "../../shared/class_folder/class_funciones.php";
$io_funciones = new class_funciones();
require_once "../class_folder/class_funciones_cxp.php";
$io_fun_cxp = new class_funciones_cxp();
$ls_estmodest = $_SESSION["la_empresa"]["estmodest"];
require_once "../../shared/class_folder/class_datastore.php";
$ds_dentipdoc = new class_datastore();
//Instancio a la clase de conversión de numeros a letras.
include "../../shared/class_folder/class_numero_a_letra.php";
$numalet = new class_numero_a_letra();
//imprime numero con los valore por defecto
//cambia a minusculas
$numalet->setMayusculas(1);
//cambia a femenino
$numalet->setGenero(1);
//cambia moneda
$numalet->setMoneda("Bolivares");
//cambia prefijo
$numalet->setPrefijo("***");
//cambia sufijo
$numalet->setSufijo("***");
if ($ls_estmodest == 1) {

예제 #7

0

파일 보기

파일: sigesp_scv_cat_transporte.php 프로젝트: ssolano/cafe_sigesp

        </select></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td height="22"><div align="right"><a href="javascript: ue_search();"><img src="../shared/imagebank/tools15/buscar.gif" alt="Buscar" width="15" height="15" border="0">Buscar</a></div></td>
      </tr>
    </table>
  <br>
    <?php
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_msg= new class_mensajes();
require_once("../shared/class_folder/class_datastore.php");
$ds=     new class_datastore();
require_once("../shared/class_folder/class_sql.php");
$io_sql= new class_sql($con);
require_once("../shared/class_folder/class_funciones.php");
$io_fun= new class_funciones();
$arr=$_SESSION["la_empresa"];
$ls_codemp=$arr["codemp"];

if(array_key_exists("operacion",$_POST))
{
	$ls_operacion=$_POST["operacion"];
	$ls_codtra="%".$_POST["txtcodtra"]."%";
	$ls_dentra="%".$_POST["txtdentra"]."%";
	$ls_codtiptra=$_POST["cmbcodtiptra"];
}
else

예제 #8

0

파일 보기

파일: sigesp_cat_estados.php 프로젝트: ssolano/cafe_sigesp

<body>
<table width="500" border="0" align="center" cellpadding="1" cellspacing="1">
    <tr>
      <td width="496" colspan="2" class="titulo-celda">Cat&aacute;logo de Estados</td>
    </tr>
</table>
<br>
    <?
require_once("sigesp_include.php");
require_once ("class_folder\class_datastore.php");
require_once ("class_folder\class_sql.php");

$io_conect=new sigesp_include();
$conn=$io_conect->uf_conectar();
$io_dsest=new class_datastore();
$io_sql=new class_sql($conn);

if (array_key_exists("operacion",$_POST))
{
	$ls_codpais=$_POST["hidpais"];
}
else
{
	if(array_key_exists("pais",$_GET))
	{
		$ls_codpais=$_GET["pais"];
	}
	else
	{
		$ls_codpais="";

예제 #9

0

파일 보기

파일: sigesp_scb_cat_conceptos.php 프로젝트: ssolano/cafe_sigesp

      </tr>
      <tr>
        <td height="22">&nbsp;</td>
        <td height="22"><div align="right"><a href="javascript: ue_search();"><img src="../../shared/imagebank/tools20/buscar.gif" alt="Buscar" width="20" height="20" border="0"> Buscar</a></div></td>
      </tr>
    </table>
	<br>
    <?php 
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_msg = new class_mensajes();
require_once "../../shared/class_folder/class_sql.php";
$SQL = new class_sql($con);
$ds = new class_datastore();
$ls_codemp = $arr["codemp"];
require_once "../class_folder/class_funciones_cfg.php";
$fun = new class_funciones_cfg();
$ls_destino = $fun->uf_obtenervalor_get("destino", "");
if (array_key_exists("operacion", $_POST)) {
    $ls_operacion = $_POST["operacion"];
    $ls_codigo = "%" . $_POST["codigo"] . "%";
    $ls_denominacion = "%" . $_POST["denominacion"] . "%";
} else {
    $ls_operacion = "BUSCAR";
    $ls_codigo = "%%";
    $ls_denominacion = "%%";
}
print "<table width=500 border=0 cellpadding=1 cellspacing=1 class=fondo-tabla align=center>";
print "<tr class=titulo-celda>";

예제 #10

0

파일 보기

파일: sigesp_cat_ctabancoorigen.php 프로젝트: ssolano/cafe_sigesp

<link href="../shared/css/tablas.css" rel="stylesheet" type="text/css">
<script type="text/javascript" language="JavaScript1.2" src="../shared/js/number_format.js"></script>
</head>

<body>
<form name="form1" method="post" action="">
<?php

require_once("../shared/class_folder/sigesp_include.php");
$in=new sigesp_include();
$con=$in->uf_conectar();
require_once("../shared/class_folder/class_mensajes.php");
$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"];
require_once("sigesp_c_cuentas_banco.php");
$io_ctaban = new sigesp_c_cuentas_banco();

if(array_key_exists("operacion",$_POST))
{
	$ls_operacion=$_POST["operacion"];
	$ls_codigo=$_POST["codigo"];
	$ls_denban=$_POST["denban"];
	$ls_ctaban="%".$_POST["cuenta"]."%";
	$ls_denominacion="%".$_POST["denominacion"]."%";
}
else

예제 #11

0

파일 보기

파일: sigesp_cat_unidades.php 프로젝트: ssolano/cafe_sigesp

<body>
<form name="form1" method="post" action="">
<input type="hidden" name="campo" id="campo" value="<? print $ls_campo;?>" >
<input type="hidden" name="orden" id="orden" value="<? print $ls_orden;?>">
<?

require_once("../shared/class_folder/sigesp_include.php");
require_once("../shared/class_folder/class_mensajes.php");
require_once("../shared/class_folder/class_sql.php");
require_once("../shared/class_folder/class_funciones.php");
require_once("class_folder/sigesp_sob_c_unidad.php");
$io_include=new sigesp_include();
$io_connect=$io_include->uf_conectar();
$io_msg=new class_mensajes();
$io_sql=new class_sql($io_connect);
$io_data=new class_datastore();
$io_funcion=new class_funciones();
$io_cunid=new sigesp_sob_c_unidad();
$ls_codemp=$la_datemp["codemp"];

if(array_key_exists("operacion",$_POST))
{
	$ls_operacion=$_POST["operacion"];
	$ls_codtun="%".$_POST["cmbtipouni"]."%";
	$ls_nomuni="%".$_POST["nomuni"]."%";
	$ls_tipounidad=$_POST["cmbtipouni"];
	$ls_nomunidad=$_POST["nomuni"];

}
else
{

예제 #12

0

파일 보기

파일: sigesp_cat_tipocontrato.php 프로젝트: ssolano/cafe_sigesp

  </tr>
</table>
<br>
<form name="form1" method="post" action="">
<input type="hidden" name="campo" id="campo" value="<? print $ls_campo;?>" >
<input type="hidden" name="orden" id="orden" value="<? print $ls_orden;?>">
  <div align="center">
<?Php
	require_once("../shared/class_folder/sigesp_include.php");
	require_once("../shared/class_folder/class_datastore.php");
	require_once("../shared/class_folder/class_sql.php");
	require_once("../shared/class_folder/class_mensajes.php");
	$io_msg=new class_mensajes();	
	$io_conect=new sigesp_include();
	$conn=$io_conect->uf_conectar();
	$io_dstipocontrato=new class_datastore();
	$io_sql=new class_sql($conn);
	$ls_sql=" SELECT *
			  FROM sob_tipocontrato
			  ORDER BY $ls_campo $ls_orden";
	$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);
		$la_arrcols=array_keys($data);
		$li_totcol=count($la_arrcols);
		$io_dstipocontrato->data=$data;
		$li_totrow=$io_dstipocontrato->getRowCount("codtco");
		print "<table width=500 border=0 cellpadding=1 cellspacing=1 class=fondo-tabla>";
		print "<tr class=titulo-celda>";

예제 #13

0

파일 보기

파일: sigesp_cat_aumento.php 프로젝트: ssolano/cafe_sigesp

<?php
session_start();
require_once("../shared/class_folder/sigesp_include.php");
require_once("../shared/class_folder/class_funciones.php");
require_once("../shared/class_folder/class_mensajes.php");
require_once("../shared/class_folder/class_fecha.php");
require_once("../shared/class_folder/class_datastore.php");
require_once("../shared/class_folder/class_sql.php");
require_once("../shared/class_folder/class_sigesp_int.php");
require_once("../shared/class_folder/class_sigesp_int_scg.php");
$in=new sigesp_include();
$con=$in->uf_conectar();
$int_scg=new class_sigesp_int_scg();
$msg=new class_mensajes();
$ds=new class_datastore();
$ds_procedencias=new class_datastore();
$SQL=new class_sql($con);
$SQL_cmp=new class_sql($con);
$arr=$_SESSION["la_empresa"];
$as_codemp=$arr["codemp"];
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Catalogo de Comprobante de Credito/Ingreso Adicional</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
a:link {
	color: #006699;

예제 #14

0

파일 보기

파일: sigesp_cat_bancosdestino.php 프로젝트: ssolano/cafe_sigesp

      </tr>
      <tr>
        <td>&nbsp;</td>
        <td><div align="right"><a href="javascript: ue_search();"><img src="../shared/imagebank/tools20/buscar.gif" alt="Buscar" width="20" height="20" border="0"> Buscar</a></div></td>
      </tr>
    </table>
	<br>
    <?php
require_once("../shared/class_folder/sigesp_include.php");
$in=new sigesp_include();
$con=$in->uf_conectar();
require_once("../shared/class_folder/class_mensajes.php");
$msg=new class_mensajes();
require_once("../shared/class_folder/class_sql.php");
$SQL=new class_sql($con);
$ds=new class_datastore();

$ls_codemp=$arr["codemp"];

if(array_key_exists("operacion",$_POST))
{
	$ls_operacion=$_POST["operacion"];
	$ls_codigo="%".$_POST["codigo"]."%";
	$ls_denominacion="%".$_POST["denominacion"]."%";
}
else
{
	$ls_operacion="";

}
print "<table width=500 border=0 cellpadding=1 cellspacing=1 class=fondo-tabla align=center>";

예제 #15

0

파일 보기

파일: sigesp_scb_rpp_voucher_redtv.php 프로젝트: ssolano/cafe_sigesp

require_once("sigesp_scb_report.php");
require_once('../../shared/class_folder/class_pdf.php');
require_once("../../shared/class_folder/class_sql.php");
require_once("../../shared/class_folder/class_funciones.php");
require_once("../../shared/class_folder/sigesp_include.php");
require_once("../../shared/class_folder/class_datastore.php");
require_once("../../shared/class_folder/class_numero_a_letra.php");

$io_include   = new sigesp_include();
$ls_conect    = $io_include->uf_conectar();
$io_sql		  = new class_sql($ls_conect);	
$class_report = new sigesp_scb_report($ls_conect);
$io_funciones = new class_funciones();				
$ds_voucher	  = new class_datastore();	
$ds_dt_scg	  = new class_datastore();				
$ds_dt_spg	  = new class_datastore();
$numalet	  = new class_numero_a_letra();

//imprime numero con los valore por defecto
//cambia a minusculas
$numalet->setMayusculas(1);
//cambia a femenino
$numalet->setGenero(1);
//cambia moneda
$numalet->setMoneda("Bolivares");
//cambia prefijo
$numalet->setPrefijo("***");
//cambia sufijo
$numalet->setSufijo("***");

	$ls_codemp = $_SESSION["la_empresa"]["codemp"];

예제 #16

0

파일 보기

파일: sigesp_scv_cat_categorias.php 프로젝트: ssolano/cafe_sigesp

}
a:active {
	color: #006699;
}
-->
</style></head>

<body>
<?php
require_once("../shared/class_folder/sigesp_include.php");
require_once("../shared/class_folder/class_datastore.php");
require_once("../shared/class_folder/class_sql.php");

$io_conect= new sigesp_include();
$conn = $io_conect->uf_conectar();
$io_dstar= new class_datastore();
$io_sql= new class_sql($conn);
$ls_codemp=$_SESSION["la_empresa"]["codemp"];
$ls_sql= " SELECT * FROM scv_categorias".
		 " WHERE codemp='".$ls_codemp."'".
		 " ORDER BY codcat ASC ";
$rs_data= $io_sql->select($ls_sql);
$data= $rs_data;
?>
<table width="500" border="0" align="center" cellpadding="1" cellspacing="1">
  <tr>
   <td width="496" colspan="2" class="titulo-celda">Cat&aacute;logo de Categor&iacute;as de Vi&aacute;ticos</td>
  </tr>
</table>
  <br>
<form name="form1" method="post" action="">

예제 #17

0

파일 보기

파일: sigesp_spg_cat_tipomod.php 프로젝트: ssolano/cafe_sigesp

a:active {
	color: #006699;
}
-->
</style></head>

<body>
<?php
require_once("../shared/class_folder/sigesp_include.php");
require_once("../shared/class_folder/class_datastore.php");
require_once("../shared/class_folder/class_sql.php");


$io_conect=new sigesp_include();
$conn=$io_conect->uf_conectar();
$io_dsfuente=new class_datastore();
$io_sql=new class_sql($conn);

$arr=$_SESSION["la_empresa"];
$ls_sql="SELECT codtipmodpre, dentipmodpre, pretipmodpre, contipmodpre ".
        "  FROM spg_tipomodificacion".
		" WHERE codtipmodpre <> '----' ".
		" ORDER BY codtipmodpre ASC ";
$rs_fuente=$io_sql->select($ls_sql);
$data=$rs_fuente;
?>
<table width="500" border="0" align="center" cellpadding="1" cellspacing="1">
  <tr>
   <td width="496" colspan="2" class="titulo-celda">Cat&aacute;logo de Tipo de Modificaciones Presupuestarias </td>
  </tr>
</table>

예제 #18

0

파일 보기

파일: sigesp_cat_usuarios.php 프로젝트: ssolano/cafe_sigesp

        </div></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td><div align="right"><a href="javascript: ue_search();"><img src="../shared/imagebank/tools15/buscar.gif" alt="Buscar" width="15" height="15" border="0">Buscar</a></div></td>
      </tr>
    </table>
  <br>
    <?php
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_msg=new class_mensajes();
require_once("../shared/class_folder/class_datastore.php");
$ds=new class_datastore();
require_once("../shared/class_folder/class_sql.php");
$io_sql=new class_sql($con);
require_once("../shared/class_folder/class_funciones.php");
$io_fun=new class_funciones();

$arr=$_SESSION["la_empresa"];

if(array_key_exists("operacion",$_POST))
{
	$ls_operacion=$_POST["operacion"];
	$ls_empresa="%".$_POST["txtempresa"]."%";
	$ls_nombre="%".$_POST["txtnombre"]."%";
	$ls_loginviejo="%".$_POST["txtloginviejo"]."%";
	$ls_codigo="%".$_POST["txtcodigo"]."%";
	$ls_status="%".$_POST["hidstatus"]."%";

예제 #19

0

파일 보기

파일: sigesp_saf_cat_recepciones.php 프로젝트: ssolano/cafe_sigesp

.Estilo1 {font-size: 36px}
-->
</style>
</head>

<body>
<?php 
require_once "../shared/class_folder/sigesp_include.php";
require_once "../shared/class_folder/class_mensajes.php";
require_once "../shared/class_folder/class_datastore.php";
require_once "../shared/class_folder/class_sql.php";
require_once "../shared/class_folder/class_funciones.php";
$io_in = new sigesp_include();
$con = $io_in->uf_conectar();
$io_msg = new class_mensajes();
$io_ds = new class_datastore();
$io_sql = new class_sql($con);
$io_fun = new class_funciones();
$la_emp = $_SESSION["la_empresa"];
if (array_key_exists("operacion", $_POST)) {
    $ls_operacion = $_POST["operacion"];
} else {
    $ls_operacion = "";
}
if (array_key_exists("txtnumrec", $_POST)) {
    $ls_numrec = $_POST["txtnumrec"];
} else {
    $ls_numrec = "";
}
if (array_key_exists("cmbconcepto", $_POST)) {
    $ls_concepto = $_POST["cmbconcepto"];

예제 #20

0

파일 보기

파일: sigesp_catdinamic_ctas.php 프로젝트: ssolano/cafe_sigesp

      <tr>
        <td height="22">&nbsp;</td>
        <td height="22">&nbsp;</td>
        <td height="22"><div align="right"><a href="javascript: ue_search();"><img src="../../shared/imagebank/tools20/buscar.gif" alt="Buscar" width="20" height="20" border="0"> Buscar </a></div></td>
      </tr>
    </table>
	<br>
    <?php 
require_once "../../shared/class_folder/sigesp_include.php";
require_once "../../shared/class_folder/class_sql.php";
require_once "../../shared/class_folder/class_datastore.php";
require_once "../../cfg/class_folder/class_funciones_configuracion.php";
$io_fun_cfg = new class_funciones_configuracion();
$in = new sigesp_include();
$con = $in->uf_conectar();
$ds = new class_datastore();
$io_sql = new class_sql($con);
$arr = $_SESSION["la_empresa"];
$as_codemp = $arr["codemp"];
if (array_key_exists("operacion", $_POST)) {
    $ls_operacion = $_POST["operacion"];
    $ls_codigo = $_POST["codigo"];
    $ls_denominacion = "%" . $_POST["nombre"] . "%";
} else {
    $ls_operacion = "";
}
$ls_cuenta = $io_fun_cfg->uf_obtenervalor_get("cuenta", "");
print "<table width=500 border=0 cellpadding=1 cellspacing=1 class=fondo-tabla align=center>";
print "<tr class=titulo-celda>";
print "<td style=text-align:center width=100>Cuenta Contable</td>";
print "<td style=text-align:center width=400>Denominación</td>";

예제 #21

0

파일 보기

파일: sigesp_scb_c_cmp_ret_iva.php 프로젝트: ssolano/cafe_sigesp

	function uf_select_cmp_ret($as_numcom,$as_codret,&$object,&$li_total_rows)
	{
		/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
		//  Function:    uf_cargar_dt_cmp_ret
		//	Description: - Metodo que se encarga de seleccionar los detalles de un comprobante de retencion y los retorna en 
		//				   un arreglo de Objects que sera enviado a la clase grid_param.	
		//  Arguments:   - $as_numcom:    - Numero del comprobante de retenci�n a buscar.
		//				 - $as_codret:    - Codigo de la Retenci� a buscar.	
		//				 - $object:       - Arreglo de object que se retorna como referencia, lleno con los detalles del 
		//									comprobante en caso de poseer.
		//				 - $li_total_rows - Total de filas retornadas en la consulta.
		/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////		
		$ds_temp=new class_datastore();
		$li_total_rows=0;		
		$ls_codemp=$this->dat_emp["codemp"];
		
		$ls_sql="SELECT codemp, codret, numcom, numope, fecfac, numfac, numcon, numnd, numnc, 
		                tiptrans, totcmp_sin_iva, totcmp_con_iva, basimp, porimp, totimp,
						iva_ret, desope, numsop, codban, ctaban, numdoc, codope 
				 FROM   scb_dt_cmp_ret 
				 WHERE  codemp='".$ls_codemp."' AND numcom='".$as_numcom."' AND codret='".$as_codret."'";	
		
		$rs_result=$this->io_sql->select($ls_sql);
		
		if($rs_result===false)
		{
			$this->is_msg_error="Error en uf_cargar_dt_cmp_ret, ".$this->io_function->uf_convertirmsg($this->io_sql->message);
			$lb_valido=false;
		}
		else
		{
			if($row=$this->io_sql->fetch_row($rs_result))
			{
				$ds_temp->data=$this->io_sql->obtener_datos($rs_result);
				$li_total_rows=$ds_temp->getRowCount("numcom");
				for($li_i=1;$li_i<=$li_total_rows;$li_i++)
				{
					$ls_numope  = $ds_temp->getValue("numope",$li_i);	
					$ls_numfac  = $ds_temp->getValue("numfac",$li_i);	
					$ls_numcon  = $ds_temp->getValue("numcon",$li_i);	
					$ld_fecfac  = $ds_temp->getValue("fecfac",$li_i);	
					$ld_fecfac  = $this->io_function->uf_convertirfecmostrar($ld_fecfac);
					$ldec_totalsiniva= $ds_temp->getValue("totcmp_sin_iva",$li_i);	
					$ldec_totalconiva= $ds_temp->getValue("totcmp_con_iva",$li_i);	
					$ldec_baseimp    = $ds_temp->getValue("basimp",$li_i);	
					$ldec_porimp     = $ds_temp->getValue("porimp",$li_i);	
					$ldec_totimp     = $ds_temp->getValue("totimp",$li_i);
					$ldec_ivaret     = $ds_temp->getValue("iva_ret",$li_i);	
					$ls_numdoc  = $ds_temp->getValue("numdoc",$li_i);	
					
					
				  	$ldec_totalsiniva = number_format($ldec_totalsiniva,2,",","."); 
					$ldec_totalconiva = number_format($ldec_totalconiva,2,",",".");			
					$ldec_baseimp     = number_format($ldec_baseimp,2,",",".");			
					$ldec_porimp      = number_format($ldec_porimp,2,",",".");			
				    $ldec_totimp      = number_format($ldec_totimp,2,",",".");				
					$ldec_ivaret      = number_format($ldec_ivaret,2,",",".");		
					
					$object[$li_i][1] = "<input type=text name=txtnumope".$li_i." value='$ls_numope' style=text-align:center class=sin-borde size=15 readonly>"; 
					$object[$li_i][2] = "<input type=text name=txtnumfac".$li_i." value='$ls_numfac' style=text-align:center class=sin-borde size=16 readonly>";
					$object[$li_i][3] = "<input type=text name=txtnrocon".$li_i." value='$ls_numcon' style=text-align:center class=sin-borde size=16 readonly>";					
					$object[$li_i][4] = "<input type=text name=txtfecfac".$li_i." value='$ld_fecfac' style=text-align:center class=sin-borde size=13 readonly>";
					$object[$li_i][5] = "<input type=text name=txtsiniva".$li_i." value='$ldec_totalsiniva' style=text-align:right class=sin-borde size=15 onKeyPress=return(currencyFormat(this,'.',',',event)) >";
					$object[$li_i][6] = "<input type=text name=txtconiva".$li_i." value='$ldec_totalconiva' style=text-align:right class=sin-borde size=15 onKeyPress=return(currencyFormat(this,'.',',',event)) >";
					$object[$li_i][7] = "<input type=text name=txtbasimp".$li_i." value='$ldec_baseimp'     style=text-align:right class=sin-borde size=15 onKeyPress=return(currencyFormat(this,'.',',',event)) >";
					$object[$li_i][8] = "<input type=text name=txtporiva".$li_i." value='$ldec_porimp'      style=text-align:right class=sin-borde size=15 onKeyPress=return(currencyFormat(this,'.',',',event)) <a href=javascript:uf_iva(".$li_i.");><img src=../shared/imagebank/tools15/buscar.gif width=15 height=15 border=0></a>";						
					$object[$li_i][9] = "<input type=text name=txttotimp".$li_i." value='$ldec_totimp'      style=text-align:right class=sin-borde size=15 onKeyPress=return(currencyFormat(this,'.',',',event)) >";					
					$object[$li_i][10] = "<input type=text name=txtivaret".$li_i." value='$ldec_ivaret'      style=text-align:right class=sin-borde size=15 onKeyPress=return(currencyFormat(this,'.',',',event)) >";			
					$object[$li_i][11]= "<input type=text name=txtnumdoc".$li_i." value='$ls_numdoc'        style=text-align:right class=sin-borde size=16 onKeyPress=return(currencyFormat(this,'.',',',event)) >";					
					$object[$li_i][12]= "<a href=javascript:uf_delete_dt('$ls_numope','$ls_numfac');><img src=../shared/imagebank/tools15/eliminar.gif alt='Eliminar Retencion' width=15 height=10 border=0></a><input type=hidden name=hidforcar".$li_i."  value=''><input type=hidden name=hidcodded".$li_i."  value=''><input type=hidden name=hidforded".$li_i."  value=''>";	
				}
			}
		}		
	}

예제 #22

0

파일 보기

파일: sigesp_sob_d_valuacion.php 프로젝트: ssolano/cafe_sigesp

require_once("class_folder/sigesp_sob_c_funciones_sob.php");
require_once("../shared/class_folder/grid_param.php");
require_once("../shared/class_folder/class_mensajes.php");
require_once("../shared/class_folder/class_datastore.php");
require_once("../shared/class_folder/class_funciones.php");
require_once("../shared/class_folder/evaluate_formula.php");
$io_asignacion=new sigesp_sob_class_asignacion();
$io_valuacion=new sigesp_sob_c_valuacion();
$io_obra=new sigesp_sob_class_obra();
$io_funcsob=new sigesp_sob_c_funciones_sob();
$io_evalform=new evaluate_formula();
$io_grid=new grid_param();
$io_msg=new class_mensajes();
$io_datastore=new class_datastore();
$io_function=new class_funciones();
$io_datastore=new class_datastore();

$ls_tituloretenciones="Retenciones Asignadas";
$li_anchoretenciones=600;
$ls_nametable="grid";
$la_columretenciones[1]="Código";
$la_columretenciones[2]="Descripción";
$la_columretenciones[3]="Cuenta";
$la_columretenciones[4]="Deducible";
$la_columretenciones[5]="Monto";
$la_columretenciones[6]="Total";
$la_columretenciones[7]="Edición";

$ls_titulopartidas="Partidas Asignadas";
$li_anchopartidas=600;
$ls_nametable="grid2";

예제 #23

0

파일 보기

파일: sigesp_cat_sistemaconstructivo.php 프로젝트: ssolano/cafe_sigesp

<br>
<form name="form1" method="post" action="">
<input type="hidden" name="campo" id="campo" value="<? print $ls_campo;?>" >
<input type="hidden" name="orden" id="orden" value="<? print $ls_orden;?>">

  <div align="center">
<?Php
	require_once("../shared/class_folder/sigesp_include.php");
	require_once("../shared/class_folder/class_datastore.php");
	require_once("../shared/class_folder/class_sql.php");
	require_once("../shared/class_folder/class_mensajes.php");
	$ls_empresa=$_SESSION["la_empresa"];
	$io_msg=new class_mensajes();	
	$io_conect=new sigesp_include();
	$conn=$io_conect->uf_conectar();
	$io_datastore=new class_datastore();
	$io_sql=new class_sql($conn);
	$ls_sql=" SELECT *
			  FROM sob_sistemaconstructivo 
			  WHERE codemp='".$ls_empresa["codemp"]."'  ORDER BY $ls_campo $ls_orden ";
	$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);
		$la_arrcols=array_keys($data);
		$li_totcol=count($la_arrcols);
		$io_datastore->data=$data;
		$li_totrow=$io_datastore->getRowCount("codsiscon");
		print "<table width=600 border=0 cellpadding=1 cellspacing=1 class=fondo-tabla>";
		print "<tr class=titulo-celda>";

예제 #24

0

파일 보기

파일: sigesp_sob_c_catalogo_ajax.php 프로젝트: ssolano/cafe_sigesp

	function uf_print_amortizacion()
   	{
		////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
		//	     Function: uf_print_amortizacion
		//		   Access: private
		//	    Arguments: 
		//	  Description: Función que obtiene e imprime los resultados de la busqueda de compromisos
		//	   Creado Por: Ing. Yesenia Moreno/ Ing. Luis Lang
		// Fecha Creación: 09/05/2007 								Fecha Última Modificación : 
		////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
		global $io_funciones_sob;
		
		require_once("../../shared/class_folder/class_mensajes.php");
		$io_mensajes=new class_mensajes();		
		require_once("../../shared/class_folder/class_funciones.php");
		$io_funciones=new class_funciones();		
		require_once("sigesp_sob_c_recepcion.php");
		$io_recepcion=new sigesp_sob_c_recepcion("../../");		
		require_once("../../shared/class_folder/class_datastore.php");
		$io_ds_amortizacion=new class_datastore(); // Datastored de cuentas contables
		$ls_codigo=$_POST['codigo'];
		$ls_tipodes=$_POST['tipodes'];
		switch($ls_tipodes)
		{
			case "P":
				$ls_codprov=$ls_codigo;
				$ls_cedbene="----------";
				break;
			case "B":
				$ls_codprov="----------";
				$ls_cedbene=$ls_codigo;
				break;
		}
		if(array_key_exists("amortizacion",$_SESSION))
		{
			$io_ds_amortizacion->data=$_SESSION["amortizacion"];
		}
		$lb_valido=$io_recepcion->uf_select_amortizaciones($ls_codprov,$ls_cedbene);
		if($lb_valido==true)
		{
				$li_totrow=$io_recepcion->io_ds_anticipos->getRowCount('numrecdoc');
				if($li_totrow>0)
				{//print_r($io_ds_amortizacion->data);
					print "<table width=600 border=0 cellpadding=1 cellspacing=1 class=fondo-tabla align=center>";
					print "<tr class=titulo-celda>";
					print "	<td align='center' >Recepcion</td>";
					print "	<td align='rigth' >Total Anticipo</td>";
					print "	<td align='rigth' >Saldo</td>";
					print "	<td align='rigth' >Amortizacion</td>";
					print "</tr>";
					for($li_i=1;($li_i<=$li_totrow)&&($lb_valido);$li_i++)
					{
						$ls_numrecdoc=trim($io_recepcion->io_ds_anticipos->data["numrecdoc"][$li_i]);
						$ls_codtipdoc=trim($io_recepcion->io_ds_anticipos->data["codtipdoc"][$li_i]);
						$li_monsal=$io_recepcion->io_ds_anticipos->data["monsal"][$li_i];
						$li_montotamo=$io_recepcion->io_ds_anticipos->data["montotamo"][$li_i];				  
						$ls_cuenta=$io_recepcion->io_ds_anticipos->data["cuenta"][$li_i];				  
						$ls_codamo=$io_recepcion->io_ds_anticipos->data["codamo"][$li_i];				  
						$li_monamo=0;
						if($lb_valido)
						{
							$li_row=$io_ds_amortizacion->findValues(array('recdocant'=>$ls_numrecdoc,'codtipdoc'=>$ls_codtipdoc),"recdocant");
							if($li_row>0)
							{
								$li_monamo=$io_ds_amortizacion->getValue("monto",$li_row);
							}
							print "<tr class=celdas-blancas>";
							print "	<td  width=155 align=center><input name=txtnumrecdoc".$li_i." type=text class=sin-borde style=text-align:center id=txtnumrecdoc".$li_i."' value=".$ls_numrecdoc." readonly/>".
								  "	<input name=txtcuenta".$li_i." type=hidden id=txtcuenta".$li_i."' value=".$ls_cuenta."  /><input name=txtcodtipdoc".$li_i." type=hidden id=txtcodtipdoc".$li_i."' value=".$ls_codtipdoc."  />".
								  " <input name=txtcodamo".$li_i." type=hidden id=txtcodamo".$li_i."' value=".$ls_codamo."  /></td>";
							print "	<td  width=155  align=right>".number_format($li_montotamo,2,',','.')."</td>";
							print " <td  width=155 align=right><input name=txtsaldo".$li_i." type=text class=sin-borde style=text-align:right id=txtsaldo".$li_i."' value=".number_format($li_monsal,2,',','.')." readonly/></td>";
							print " <td  width=155 align=right><input name=txtmonto".$li_i." type=text class=sin-borde style=text-align:right id=txtmonto".$li_i."' value=".number_format($li_monamo,2,',','.')." onKeyPress=return(ue_formatonumero(this,'.',',',event)); onBlur= ue_validarmonto(); /> </td>";
							print "</tr>";
						}
					}
					print "<tr><td>";
					print "<input name=txttotrow type=hidden class=sin-borde  id=txttotrow value=".$li_totrow." onKeyPress=return(ue_formatonumero(this,'.',',',event)); />";
					print "</td></tr>";
					print "</table>";
				}
				else
				{
        			$io_mensajes->message("ERROR->No hay Anticipos asociados a este Proveedor ó Beneficiario"); 
				}
			}
		unset($io_mensajes);
		unset($io_funciones);
		unset($io_recepcion);
	}// end function uf_print_compromisos

예제 #25

0

파일 보기

파일: sigesp_spg_cat_fuente.php 프로젝트: ssolano/cafe_sigesp

<body>
<table width="500" border="0" align="center" cellpadding="1" cellspacing="1">
  <tr>
   <td width="496" colspan="2" class="titulo-celda"> Cat&aacute;logo de Fuente de Financiamiento</td>
  </tr>
</table>
<div align="center"><br>
<?php
	require_once("../shared/class_folder/sigesp_include.php");
	require_once("../shared/class_folder/class_datastore.php");
	require_once("../shared/class_folder/class_sql.php");

	$io_in=new sigesp_include();
	$con=$io_in->uf_conectar();
	$io_ds=new class_datastore();
	$io_sql=new class_sql($con);
	$arr=$_SESSION["la_empresa"];
	$ls_codemp=$arr["codemp"];
	if(array_key_exists("tipo",$_GET))
	{
	$ls_tipo=$_GET["tipo"];
	}
	else
	{
	$ls_tipo="";
	}
	
	
	$ls_sql=" SELECT *                               ".
			" FROM    sigesp_fuentefinanciamiento    ".

예제 #26

0

파일 보기

파일: sigesp_cat_plantilla.php 프로젝트: ssolano/cafe_sigesp

<?php
//session_id('8675309');
session_start();
require_once("../shared/class_folder/class_fecha.php");
require_once("../shared/class_folder/class_mensajes.php");
require_once("../shared/class_folder/class_funciones.php");
require_once("../shared/class_folder/class_sql.php");
require_once("../shared/class_folder/sigesp_include.php");
require_once("../shared/class_folder/class_sigesp_int.php");
require_once("../shared/class_folder/class_sigesp_int_scg.php");
$in=new sigesp_include();
$con=$in->uf_conectar();
$int_scg=new class_sigesp_int_scg();
$msg=new class_mensajes();
$ds=new class_datastore();
$ds_procedencias=new class_datastore();
$SQL=new class_sql($con);
$SQL_cmp=new class_sql($con);
$arr=$_SESSION["la_empresa"];
$as_codemp=$arr["codemp"];
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Catalogo de Comprobantes</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
a:link {
	color: #006699;

예제 #27

0

파일 보기

파일: sigesp_spg_reporte.php 프로젝트: ssolano/cafe_sigesp

    function uf_spg_reporte_disponibilidad_formato2($as_codestpro1_ori,$as_codestpro2_ori,$as_codestpro3_ori,$as_codestpro4_ori,
	                                                $as_codestpro5_ori,$as_codestpro1_des,$as_codestpro2_des,$as_codestpro3_des,
												    $as_codestpro4_des,$as_codestpro5_des,$adt_fecini,$adt_fecfin,
												    $as_cuenta_from,$as_cuenta_to)
    {//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
	 //	      Function :	uf_spg_reporte_disponibilidad_formato2
	 //         Access :	private
	 //     Argumentos :    as_codestpro1_ori .. $as_codestpro5_ori  // codigo de la estructura programatica origen 
     //              	    as_codestpro1_des .. $as_codestpro5_des  // codigo de la estructura programatica destino
	 //                     $adt_fecini   //  fecha de inicio 
	 //                     $adt_fecfin  // fecha de  fin
	 //                     $as_cuenta_from   //  cuenta desde
	 //                     $as_cuenta_to    //  desde hasta 
     //	       Returns :	Retorna true en caso de exito de la consulta o false en otro caso 
	 //	   Description :	Reporte que genera la salida para el disponible presupuestario acumulada segun fecha seleccionada 
	 //     Creado por :    Ing. Yozelin Barragán.
	 // Fecha Creación :    26/01/2007          Fecha última Modificacion :      Hora :
  	 ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
		$lb_existe = false;	 
		$lb_valido = true;
		$ls_codemp = $this->dts_empresa["codemp"];
	    $this->dts_reporte->reset_ds();
        $ls_str_sql_where="";
		$dts_disponible=new class_datastore();
		$rs_data=0;
		$ls_estructura_desde=$as_codestpro1_ori.$as_codestpro2_ori.$as_codestpro3_ori.$as_codestpro4_ori.$as_codestpro5_ori;
		$ls_estructura_hasta=$as_codestpro1_des.$as_codestpro2_des.$as_codestpro3_des.$as_codestpro4_des.$as_codestpro5_des;
		$this->uf_obtener_rango_programatica($as_codestpro1_ori,$as_codestpro2_ori,$as_codestpro3_ori,$as_codestpro4_ori,$as_codestpro5_ori,
											 $as_codestpro1_des,$as_codestpro2_des,$as_codestpro3_des,$as_codestpro4_des,$as_codestpro5_des,
											 $ls_Sql_Where,$ls_str_estructura_from,$ls_str_estructura_to);

		$ls_Sql_Where = trim($ls_Sql_Where);
		if ( !empty($ls_Sql_Where) )  
		{
		   $ls_str_sql_where=$ls_Sql_Where." AND ";
		}
		else
		{
		   $ls_str_sql_where="";
		}
		$ls_gestor = $_SESSION["ls_gestor"];
		if(strtoupper($ls_gestor)=="MYSQL")
		{
		   $ls_concat="CONCAT(PCT.codestpro1, PCT.codestpro2, PCT.codestpro3, PCT.codestpro4,PCT.codestpro5)";
		}
		else
		{
		   $ls_concat="(PCT.codestpro1||PCT.codestpro2||PCT.codestpro3||PCT.codestpro4||PCT.codestpro5)";
		}
		$ls_sql=" SELECT ".$ls_concat." AS programatica, PCT.codestpro1, PCT.codestpro2, PCT.codestpro3, PCT.codestpro4, ".
				"        PCT.codestpro5, PCT.spg_cuenta, PCT.denominacion, PCT.status, EP.denestpro5  ".
				" FROM   spg_cuentas PCT, spg_ep5 EP ".
				" WHERE  PCT.codemp='".$ls_codemp."' AND PCT.codemp=EP.codemp AND  PCT.codestpro1=EP.codestpro1 AND ".
				"        PCT.codestpro2=EP.codestpro2 AND PCT.codestpro3=EP.codestpro3 AND PCT.codestpro4=EP.codestpro4 AND ".
				"        PCT.codestpro5=EP.codestpro5 AND ".$ls_str_sql_where." ".
				"        PCT.spg_cuenta between '".$as_cuenta_from."' AND  '".$as_cuenta_to."' ".
				" ORDER BY PCT.codestpro1, PCT.codestpro2, PCT.codestpro3, PCT.codestpro4, PCT.codestpro5, PCT.spg_cuenta ";
	   $rs_data=$this->SQL->select($ls_sql);
	   if($rs_data===false)
	   {
		  $lb_valido=false;
		  $this->io_msg->message("CLASE->sigesp_spg_class_report MÉTODO->uf_spg_reporte_disponibilidad_presupuestaria ERROR->".$this->fun->uf_convertirmsg($this->SQL->message));
	   }
	   else
	   {
		   if($row=$this->SQL->fetch_row($rs_data))
		   {
			  $dts_disponible->data=$this->SQL->obtener_datos($rs_data);
			  $lb_existe=true;
		   }
		   $this->SQL->free_result($rs_data);   
		   if($lb_existe==false)
		   {
			  return false; // no hay registro
		   }
		   $li_total_row=$dts_disponible->getRowCount("spg_cuenta");			
		   for ($li_i=1;$li_i<=$li_total_row;$li_i++)
		   {   
			   $ls_codestpro1 = $dts_disponible->getValue("codestpro1",$li_i);
			   $ls_codestpro2 = $dts_disponible->getValue("codestpro2",$li_i);
			   $ls_codestpro3 = $dts_disponible->getValue("codestpro3",$li_i);
			   $ls_codestpro4 = $dts_disponible->getValue("codestpro4",$li_i);
			   $ls_codestpro5 = $dts_disponible->getValue("codestpro5",$li_i);
			   $ls_programatica = $ls_codestpro1.$ls_codestpro2.$ls_codestpro3.$ls_codestpro4.$ls_codestpro5;
			   $ls_spg_cuenta = $dts_disponible->getValue("spg_cuenta",$li_i);
			   $ls_denominacion = $dts_disponible->getValue("denominacion",$li_i);
			   $ls_status = $dts_disponible->getValue("status",$li_i);
			   $ls_denestpro5 = $dts_disponible->getValue("denestpro5",$li_i);
			   
			   $ld_monto_asignado=0;
			   $ld_monto_aumento=0;
			   $ld_monto_disminucion=0;
			   $ld_monto_precompromiso=0;
			   $ld_monto_compromiso=0;
			   $ld_monto_causado=0;
			   $ld_monto_pagado=0;
			   $ld_monto_aumento_a=0;
			   $ld_monto_disminucion_a=0;
			   $ld_monto_precompromiso_a=0;
			   $ld_monto_compromiso_a=0;
			   
			   if(!$this->uf_calcular_disponible_operacion_por_cuenta($ls_codestpro1,$ls_codestpro2,$ls_codestpro3,$ls_codestpro4,
																	  $ls_codestpro5,$ls_spg_cuenta,$adt_fecini,$adt_fecfin,
																	  &$ld_monto_asignado,&$ld_monto_aumento,&$ld_monto_disminucion,
																	  &$ld_monto_precompromiso,&$ld_monto_compromiso,&$ld_monto_causado,
																	  &$ld_monto_pagado,&$ld_monto_aumento_a,&$ld_monto_disminucion_a,
																	  &$ld_monto_precompromiso_a,&$ld_monto_compromiso_a))
				{
				  return false;
				}
				else
				{	
					$ld_asignado=$ld_monto_asignado+$ld_monto_aumento_a+$ld_monto_aumento-$ld_monto_disminucion_a-$ld_monto_disminucion;
					$ld_disponible=$ld_monto_asignado+$ld_monto_aumento-$ld_monto_disminucion-$ld_monto_compromiso-$ld_monto_precompromiso;
                    
					$ld_monto_ejecutado=0;
					$ld_monto_acumulado=0;
					$ldt_fecini=$this->fun->uf_convertirfecmostrar($adt_fecini);
					$ldt_fecfin=$this->fun->uf_convertirfecmostrar($adt_fecfin);
					$lb_valido=$this->uf_spg_reporte_calcular_ejecutado($ls_spg_cuenta,$ls_estructura_desde,$ls_estructura_hasta,
					                                                    $ldt_fecini,$ldt_fecfin,$ld_monto_ejecutado,$ld_monto_acumulado);					
					
					$this->dts_reporte->insertRow("programatica",$ls_programatica);
					$this->dts_reporte->insertRow("spg_cuenta",$ls_spg_cuenta);
					$this->dts_reporte->insertRow("denominacion",$ls_denominacion);
					$this->dts_reporte->insertRow("status",$ls_status);
					$this->dts_reporte->insertRow("denestpro5",$ls_denestpro5);
					$this->dts_reporte->insertRow("asignado",$ld_asignado);
					$this->dts_reporte->insertRow("disponible",$ld_disponible);
					$this->dts_reporte->insertRow("monto_ejecutado",$ld_monto_ejecutado);
					$this->dts_reporte->insertRow("monto_acumulado",$ld_monto_acumulado);
					$lb_valido = true;
			    }	
		   }//for
	   }//else 
  return $lb_valido;
}//fin uf_spg_reporte_disponibilidad_formato2

예제 #28

0

파일 보기

파일: sigesp_scb_rpp_voucher_fondemi.php 프로젝트: ssolano/cafe_sigesp

uf_inicializar_variables();
require_once("sigesp_scb_report.php");
require_once('../../shared/class_folder/class_pdf.php');
require_once("../../shared/class_folder/class_sql.php");
require_once("../../shared/class_folder/class_funciones.php");
require_once("../../shared/class_folder/sigesp_include.php");
require_once("../../shared/class_folder/class_datastore.php");
require_once("../../shared/class_folder/class_numero_a_letra.php");

$io_include   = new sigesp_include();
$ls_conect    = $io_include->uf_conectar();
$io_sql		  = new class_sql($ls_conect);	
$class_report = new sigesp_scb_report($ls_conect);
$io_funciones = new class_funciones();				
$ds_voucher	  = new class_datastore();	
$ds_dt_scg	  = new class_datastore();				
$ds_dt_spg	  = new class_datastore();
$numalet	  = new class_numero_a_letra();

//imprime numero con los valore por defecto
//cambia a minusculas
$numalet->setMayusculas(1);
//cambia a femenino
$numalet->setGenero(1);
//cambia moneda
$numalet->setMoneda("Bolivares");
//cambia prefijo
$numalet->setPrefijo("***");
//cambia sufijo
$numalet->setSufijo("***");

예제 #29

0

파일 보기

파일: sigesp_scg_wproc_prog_oaf_trim.php 프로젝트: ssolano/cafe_sigesp

								 print"</tr>";
							 }//for
		         }//if($lb_valido)
				else
				{
				  $msg->message("Error al cargar los datos");
				}
			}//if($ls_cod_report==0409")
		}//($li_rtn>0)
			
	    elseif(($lb_valido)&&($ai_cuantos>0))
	    {
  
	     $rs_cta=$iscg_procesos->uf_select_datastore_trim( $ls_codemp, $ls_cod_report );
		 $data=$SQL->obtener_datos($rs_cta);
		 $ds_proaf=new class_datastore();
		 $ds_proaf->data=$data;
		 $li_num=$ds_proaf->getRowCount("cod_report");
		 for($i=1;$i<=$li_num;$i++)
		 { 
			$ls_status=$ds_proaf->getValue("status",$i);
			if($ls_status=="C")
			{
				?>
    <tr class="celdas-azules">
      <td ><a href="javascript: aceptar('<?php print $ds_proaf->getValue("asignado",$i);?>','<?php print $ds_proaf->getValue("sc_cuenta",$i);?>','<?php print $i?>','<?php print $li_num?>','<?php print $ls_status ?>');"><?php print $ds_proaf->getValue("sc_cuenta",$i);?></a></td>
      <?php
		    }
		    elseif($ls_status=="S")
		    {
			   ?>

예제 #30

0

파일 보기

파일: sigesp_w_regdt_deducciones.php 프로젝트: ssolano/cafe_sigesp

<link href="../shared/css/general.css" rel="stylesheet" type="text/css">
<link href="../shared/css/tablas.css" rel="stylesheet" type="text/css">
<script type="text/javascript" language="JavaScript1.2" src="../shared/js/number_format.js"></script>
<script type="text/javascript" language="JavaScript1.2" src="../shared/js/disabled_keys.js"></script>
</head>
<body>
<?Php
require_once("../shared/class_folder/sigesp_include.php");
$io_in=new sigesp_include();
$con=$io_in->uf_conectar();

require_once("../shared/class_folder/class_mensajes.php");
$io_msg=new class_mensajes();

require_once("../shared/class_folder/class_datastore.php");
$io_ds=new class_datastore();

require_once("../shared/class_folder/class_sql.php");
$io_sql=new class_sql($con);

require_once("../shared/class_folder/class_funciones.php");
$fun=new class_funciones(); 

require_once("../shared/class_folder/grid_param.php");
$grid=new grid_param();


$la_emp=$_SESSION["la_empresa"];

if(array_key_exists("operacion",$_POST))
{

PHP class_datastore 예제들