示例#1
0
 function index()
 {
     $this->rapyd->load('dataform');
     $this->load->helper('openflash');
     $dolar = $this->datasis->dameval("SELECT valor FROM valores WHERE nombre='dolar'");
     $filter = new DataForm("inventario/cambioprecio/consulta/");
     $filter->attributes = array('onsubmit' => "this.action='index/'+this.form.mes.value+'/'+this.form.anio.value+'/';return FALSE;");
     $filter->title('¿Desea cambiar el precio de sus artículos en el inventario según el precio del dólar?');
     $filter->dolar = new inputField("Precio del Dólar", "dolar");
     $filter->dolar->size = 12;
     $filter->dolar->maxlength = 10;
     $filter->dolar->insertValue = $dolar;
     $filter->desc2 = new inputField("Descuento Precio2", "desc2");
     $filter->desc2->size = 12;
     $filter->desc2->maxlength = 10;
     $filter->desc2->insertValue = '3';
     $filter->desc3 = new inputField("Descuento Precio3", "desc3");
     $filter->desc3->size = 12;
     $filter->desc3->maxlength = 10;
     $filter->desc3->insertValue = '5';
     $filter->desc4 = new inputField("Descuento Precio4", "desc4");
     $filter->desc4->size = 12;
     $filter->desc4->maxlength = 10;
     $filter->desc4->insertValue = '7';
     $filter->button("btnsubmit", "Aceptar", form2uri(site_url('inventario/cambioprecio/cambio'), array('dolar', 'desc2', 'desc3', 'desc4')), $position = "BL");
     $filter->build_form();
     $data['content'] = $filter->output;
     $data['head'] = $this->rapyd->get_head();
     $data['title'] = "<h1>Cambio de Precio</h1>";
     $this->load->view('view_ventanas', $data);
 }
示例#2
0
 function imprimir()
 {
     $this->rapyd->load("dataform");
     $scli = array('tabla' => 'scli', 'columnas' => array('cliente' => 'C&oacute;digo Cliente', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('cliente' => 'C&oacute;digo Cliente', 'nombre' => 'Nombre'), 'retornar' => array('cliente' => 'cliente'), 'titulo' => 'Buscar Cliente');
     $cboton = $this->datasis->modbus($scli);
     $filter = new DataForm('/tiketimp/index');
     $filter->title('Filtro de Impresion de Tiket');
     $filter->fechad = new dateonlyField("Desde", "fechad", 'Ymd');
     $filter->fechah = new dateonlyField("Hasta", "fechah", 'Ymd');
     $filter->fechad->clause = $filter->fechah->clause = "where";
     $filter->fechad->db_name = $filter->fechah->db_name = "fecha";
     //$filter->fechad->insertValue = $fechad;
     //$filter->fechah->insertValue = $fechah;
     $filter->fechah->size = $filter->fechad->size = 10;
     $filter->fechad->operator = ">=";
     $filter->fechah->operator = "<=";
     $filter->cliente = new inputField("Cliente", "cliente");
     $filter->cliente->size = 10;
     //$filter->cliente->insertValue=$cliente;
     $filter->cliente->maxlength = 10;
     $filter->cliente->append($cboton);
     $filter->button("btnsubmit", "Buscar", form2uri(site_url("/formatos/ver/TIKET/"), array('cliente', 'fechad', 'fechah')), $position = "BL");
     //
     $filter->build_form();
     $data['content'] = $filter->output;
     $data['title'] = "<h1>Imprimir</h1>";
     $data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
示例#3
0
 function index()
 {
     $this->rapyd->load("dataform");
     $this->load->helper('openflash');
     if ($this->uri->segment(4)) {
         $anio = $this->uri->segment(4);
     } elseif (isset($_POST['anio'])) {
         $anio = $_POST['anio'];
     }
     if (empty($anio)) {
         $anio = date("Y");
     }
     $filter = new DataForm('ventas/vendedoresanuales');
     $filter->title('Filtro de Ventas Anuales');
     $filter->anio = new inputField("A&ntilde;o", "anio");
     $filter->anio->size = 4;
     $filter->anio->insertValue = $anio;
     $filter->anio->rule = "max_length[4]";
     $filter->button("btnsubmit", "Buscar", form2uri(site_url('ventas/vendedoresanuales /index'), array('anio')), $position = "BL");
     $filter->build_form();
     $grafico = open_flash_chart_object(760, 300, site_url("ventas/vendedoresanuales/grafico/{$anio}/"));
     $data['content'] = $grafico;
     $data['content'] .= $filter->output;
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = $this->rapyd->get_head() . "<h1>Ventas</h1>";
     $this->load->view('view_ventanas', $data);
 }
示例#4
0
 function index()
 {
     $this->rapyd->load('datagrid2');
     $this->rapyd->load('datafilter');
     $diai = $this->uri->segment(4);
     $mesi = $this->uri->segment(5);
     $anoi = $this->uri->segment(6);
     if ($diai === FALSE or $mesi === FALSE or $anoi === FALSE) {
         $fechai = date('Y/m/d');
         $qfechai = date('Ymd');
     } else {
         $fechai = "{$anoi}/{$mesi}/{$diai}";
         $qfechai = $anoi . $mesi . $diai;
     }
     $filter = new DataForm('supermercado/poscuadre/index');
     $filter->title('Filtro de cajas');
     $filter->fechai = new dateField("Fecha", "fechai", "d/m/Y");
     $filter->fechai->insertValue = $fechai;
     $filter->fechai->size = 10;
     $filter->button("btnsubmit", "Buscar", form2uri(site_url('supermercado/poscuadre/index'), 'fechai'), $position = "BL");
     $filter->build_form();
     $grid = new DataGrid2();
     $select = array('a.caja caja', "IFNULL(b.nombre,'N/A') nombre", 'a.cajero AS cajero', 'SUM(a.gtotal) AS monto');
     $cupon = floatval($this->datasis->traevalor('FMAYCUPON'));
     if ($cupon > 0) {
         $select[] = "SUM(TRUNCATE(a.gtotal/{$cupon},0)) AS cupones";
     } else {
         $select[] = '(0) AS  cupones';
     }
     $grid->db->select($select);
     $grid->db->from('posfact AS a');
     $grid->db->where('SUBSTRING(numero,1,1)!=', 'X');
     $grid->db->where('fecha', $qfechai);
     $grid->db->join('scaj b', 'a.cajero=b.cajero', 'LEFT');
     $grid->db->groupby('a.caja,a.cajero');
     $link = anchor("supermercado/poscuadre/concaja/<#caja#>/<#cajero#>/{$qfechai}", '<#caja#>');
     $grid->column('Caja', $link);
     $grid->column('Nombre', 'nombre');
     $grid->column('Cajero', 'cajero', 'align="center"');
     $grid->column('Cupones', 'cupones', 'align="center"');
     $grid->column('Monto', '<nformat><#monto#></nformat>', 'align="right"');
     $grid->totalizar('monto');
     $grid->build();
     //echo $grid->db->last_query();
     $consul = new DataForm('supermercado/buscafac/index/search/osp');
     $consul->title('Buscar Factura');
     $consul->fechad = new dateField("Desde", "fechad", "d/m/Y");
     $consul->fechah = new dateField("Hasta", "fechah", "d/m/Y");
     $consul->nombre = new inputField("Nombre", "nombre");
     $consul->cedula = new inputField("C&eacute;dula/RIF", "cedula");
     $consul->fechad->insertValue = $consul->fechah->insertValue = date("Y/m/d");
     $consul->fechah->size = $consul->fechad->size = 10;
     $consul->submit("btn_submit", "Buscar");
     $consul->build_form();
     $data['content'] = $filter->output . $grid->output . $consul->output;
     $data['title'] = '<h1>Consulta de Cajas</h1>';
     $data['head'] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
示例#5
0
    function index()
    {
        $this->rapyd->load("datagrid2");
        $this->rapyd->load("dataform");
        $this->load->helper('openflash');
        if ($this->uri->segment(4)) {
            $anio = $this->uri->segment(4);
        } elseif (isset($_POST['anio'])) {
            $anio = $_POST['anio'];
        }
        if (empty($anio)) {
            $anio = date("Y");
        }
        $fechai = $anio . '0101';
        $fechaf = $anio . '1231';
        $filter = new DataForm('hospitalidad/anuales');
        $filter->title('Filtro de ventas Anuales');
        $filter->anio = new inputField("A&ntilde;o", "anio");
        $filter->anio->size = 4;
        $filter->anio->insertValue = $anio;
        $filter->anio->maxlength = 4;
        //$filter->anio->onkeypress="return acceptNum(event)";
        $filter->button("btnsubmit", "Buscar", form2uri(site_url('hospitalidad/anuales/index'), array('anio')), $position = "BL");
        $filter->build_form();
        $data = $this->_sincrodata($fechai, $fechaf);
        $grid = new DataGrid2('', $data);
        $grid->totalizar('impuesto', 'cobrado', 'contado', 'credito', 'subtotal', 'numfac');
        $grid->column("Mes", "mes");
        $grid->column("Sub-Total", "<number_format><#subtotal#>|2|,|.</number_format>", 'align=right');
        $grid->column("Impuesto", "<number_format><#impuesto#>|2|,|.</number_format>", 'align=right');
        $grid->column("Contado", "<number_format><#contado#>|2|,|.</number_format>", 'align=right');
        $grid->column("Credito", "<number_format><#credito#>|2|,|.</number_format>", 'align=right');
        $grid->column("Cobrado", "<number_format><#cobrado#>|2|,|.</number_format>", 'align=right');
        $grid->column("% Ventas", "<number_format><#porcentaje#>|2|,|.</number_format>", 'align=right');
        $grid->column("Cant. Fact", "numfac", 'align=right');
        $grid->build();
        $data['content'] = open_flash_chart_object(680, 300, site_url("hospitalidad/anuales/grafico/{$anio}"));
        $data['content'] .= $filter->output . $grid->output;
        $data['title'] = $this->rapyd->get_head() . "<h1>Ventas Anuales</h1>";
        $data['script'] = '<script type="text/javascript">
		$(document).ready(function() {
			$("#anio").keypress(function(event) {
				acceptNum(evt);
				return false;
			});
		});
	  var nav4 = window.Event ? true : false;
	  function acceptNum(evt)
    {	
    		var key = nav4 ? evt.which : evt.keyCode;	
    		return (key <= 13 || (key >= 48 && key <= 57));
    		
    }
		</script>';
        $data["head"] = script("jquery-1.2.6.pack.js") . $this->rapyd->get_head();
        $this->load->view('view_ventanas', $data);
    }
示例#6
0
 function index()
 {
     $this->rapyd->load("datagrid2");
     $this->rapyd->load("dataform");
     $this->load->helper('openflash');
     if ($this->uri->segment(4)) {
         $mes = $this->uri->segment(4);
     } elseif (isset($_POST['mes'])) {
         $mes = $_POST['mes'];
     }
     if ($this->uri->segment(5)) {
         $anio = $this->uri->segment(5);
     } elseif (isset($_POST['anio'])) {
         $anio = $_POST['anio'];
     }
     if (empty($mes) or empty($anio)) {
         $mes = date("n");
     }
     $anio = date("Y");
     $fechai = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '01';
     $fechaf = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '31';
     $filter = new DataForm('ventas/mensuales');
     $filter->attributes = array('onsubmit' => "this.action='index/'+this.form.mes.value+'/'+this.form.anio.value+'/';return FALSE;");
     $filter->title('Filtro de ventas mensuales');
     $filter->mes = new dropdownField("Mes/A&ntilde;o", "mes");
     for ($i = 1; $i < 13; $i++) {
         $filter->mes->option(str_pad($i, 2, '0', STR_PAD_LEFT), str_pad($i, 2, '0', STR_PAD_LEFT));
     }
     $filter->mes->size = 2;
     $filter->mes->style = '';
     $filter->mes->insertValue = $mes;
     $filter->anio = new inputField("A&ntilde;o", "anio");
     $filter->anio->in = 'mes';
     $filter->anio->size = 4;
     $filter->anio->insertValue = $anio;
     $filter->anio->maxlength = 4;
     $filter->button("btnsubmit", "Buscar", form2uri(site_url('hospitalidad/mensuales/index'), array('mes', 'anio')), $position = "BL");
     $filter->build_form();
     $data = $this->_sincrodata($fechai, $fechaf);
     $grid = new DataGrid2('', $data);
     $grid->totalizar('impuesto', 'cobrado', 'contado', 'credito', 'subtotal', 'numfac');
     $grid->column("Dia", "dia");
     $grid->column("Sub-Total", "<number_format><#subtotal#>|2|,|.</number_format>", 'align=right');
     $grid->column("Impuesto", "<number_format><#impuesto#>|2|,|.</number_format>", 'align=right');
     $grid->column("Contado", "<number_format><#contado#>|2|,|.</number_format>", 'align=right');
     $grid->column("Credito", "<number_format><#credito#>|2|,|.</number_format>", 'align=right');
     $grid->column("Cobrado", "<number_format><#cobrado#>|2|,|.</number_format>", 'align=right');
     $grid->column("% Ventas", "<number_format><#porcentaje#>|2|,|.</number_format>", 'align=right');
     $grid->column("Cant. Fact", "numfac", 'align=right');
     $grid->build();
     $data['content'] = open_flash_chart_object(680, 300, site_url("hospitalidad/mensuales/grafico/{$mes}/{$anio}"));
     $data['content'] .= $filter->output . $grid->output;
     $data['title'] = $this->rapyd->get_head() . "<h1>Ventas Mensuales</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
示例#7
0
 function index()
 {
     //$this->rapyd->load("datagrid");
     $this->rapyd->load("dataform");
     $this->load->helper('openflash');
     if ($this->uri->segment(4)) {
         $anio = $this->uri->segment(4);
     } elseif (isset($_POST['anio'])) {
         $anio = $_POST['anio'];
     }
     if (empty($anio)) {
         $anio = date("Y");
     }
     $fechai = $anio . '0101';
     $fechaf = $anio . '1231';
     $filter = new DataForm('nomina/promediosueldos');
     $filter->title('Filtro de Promedio de Sueldos');
     $filter->anio = new inputField("A&ntilde;o", "anio");
     $filter->anio->size = 4;
     $filter->anio->insertValue = $anio;
     $filter->anio->rule = "max_length[4]";
     $filter->button("btnsubmit", "Buscar", form2uri(site_url('nomina/promediosueldos /index'), array('anio')), $position = "BL");
     $filter->build_form();
     /*
     		$grid = new DataGrid();
     		$select=array( "fecha","MONTH(fecha)as mes",                                            
     		"SUM(montonet*IF(tipo_doc='D', -1, 1)) AS anterior",                             
     		"SUM(credito*IF(tipo_doc='D', -1, 1)) as contado",        
     		"SUM(inicial*IF(tipo_doc='D', -1, 1)) as credito", 
         "FORMAT(sum(montotot*IF(tipo_doc='D',-1,1)),2) AS subtotal", 
         "FORMAT(sum(montoiva*IF(tipo_doc='D',-1,1)),2) AS impuesto", 
         "COUNT(*) AS numfac"); 
                  		
     		$grid->db->select($select);  
     		$grid->db->from("scst");
     		$grid->db->where('a.tipo<>','X');
     		$grid->db->where('fecha >= ', $fechai);  
     		$grid->db->where('fecha <= ',$fechaf); 
     		$grid->db->groupby("mes");
     		
     		$grid->column("Fecha"          , "fecha"    );
     		$grid->column("Sub-Total"      , "subtotal" ,'align=right');
     		$grid->column("Impuesto"       , "impuesto" ,'align=right');
     		$grid->column("Total"          , "anterior",'align=right');
     		$grid->column("Contado"        , "contado"  ,'align=right');
     		$grid->column("Credito"        , "credito"  ,'align=right');
     		$grid->column("N&uacute;mero"  , "numfac"   ,'align=right');
     		$grid->build();*/
     $grafico = open_flash_chart_object(760, 300, site_url("nomina/promediosueldos/grafico/{$anio}/"));
     $data['content'] = $grafico;
     $data['content'] .= $filter->output;
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = $this->rapyd->get_head() . " Nomina ";
     $this->load->view('view_ventanas', $data);
 }
示例#8
0
    function anuales()
    {
        $this->rapyd->load("datagrid2");
        $this->rapyd->load("dataform");
        $this->load->helper('openflash');
        $script = '
		$(function() {
			$(".inputnum").numeric(".");
		});
		';
        if ($this->uri->segment(4)) {
            $anio = $this->uri->segment(4);
        } elseif (isset($_POST['anio'])) {
            $anio = $_POST['anio'];
        }
        if (empty($anio)) {
            $anio = date("Y");
        }
        $fechai = $anio . '0101';
        $fechaf = $anio . '1231';
        $filter = new DataForm('ventas/productos/anuales');
        $filter->title('Filtro de Ventas Anuales');
        $filter->script($script, "create");
        $filter->script($script, "modify");
        $filter->anio = new inputField("A&ntilde;o", "anio");
        $filter->anio->size = 4;
        $filter->anio->insertValue = $anio;
        $filter->anio->rule = "max_length[4]";
        $filter->anio->rule = "trim";
        $filter->anio->css_class = 'inputnum';
        $filter->button("btnsubmit", "Buscar", form2uri(site_url('ventas/productos/anuales/'), array('anio')), $position = "BL");
        $filter->build_form();
        $grid = new DataGrid2();
        $select = array("a.codigo", "b.descrip AS nombre", "a.cantidad AS cantidad", "SUM(a.venta)AS grantotal", "COUNT(*) AS numfac");
        $grid->db->select($select);
        $grid->db->from("costos AS a");
        $grid->db->join("sinv AS b", "a.codigo=b.codigo");
        $grid->db->where('fecha >= ', $fechai);
        $grid->db->where('fecha <= ', $fechaf);
        $grid->db->groupby("a.codigo");
        $grid->db->orderby("grantotal DESC");
        $grid->per_page = 15;
        $grid->column("Producto", "nombre", "align='left'");
        $grid->column("Total", "<number_format><#grantotal#>|2|,|.</number_format>", 'align=right');
        $grid->column("Cantidad", "<number_format><#cantidad#>|2|,|.</number_format>", 'align=right');
        $grid->column("Cant. Fact", "numfac", 'align=right');
        $grid->totalizar('grantotal');
        $grid->build();
        $grafico = open_flash_chart_object(680, 450, site_url("ventas/productos/ganuales/{$anio}/"));
        $data['content'] = $grafico;
        $data['content'] .= $filter->output . $grid->output;
        $data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
        $data['title'] = $this->rapyd->get_head() . "<h1>Ventas Anuales</h1>";
        $this->load->view('view_ventanas', $data);
    }
示例#9
0
 function index()
 {
     $this->rapyd->load("datagrid");
     $this->rapyd->load("datafilter");
     $diai = $this->uri->segment(4);
     $mesi = $this->uri->segment(5);
     $anoi = $this->uri->segment(6);
     if ($diai === FALSE or $mesi === FALSE or $anoi === FALSE) {
         $fechai = date('Y/m/d');
         $qfechai = date('Ymd');
     } else {
         $fechai = "{$anoi}/{$mesi}/{$diai}";
         $qfechai = $anoi . $mesi . $diai;
     }
     $filter = new DataForm('supermercado/poscuadre/index');
     $filter->title('Filtro de cajas');
     $filter->fechai = new dateField("Fecha", "fechai", "d/m/Y");
     $filter->fechai->insertValue = $fechai;
     $filter->fechai->size = 10;
     $filter->button("btnsubmit", "Buscar", form2uri(site_url('supermercado/poscuadre/index'), 'fechai'), $position = "BL");
     $filter->build_form();
     $grid = new DataGrid();
     //$grid->db->select("a.caja caja,IFNULL(b.nombre,'N/A') nombre, a.cajero as cajero,FORMAT(SUM(a.gtotal),2) monto, sum(TRUNCATE(a.gtotal/50000,0)) cupones ");
     $select = array("a.caja caja", "IFNULL(b.nombre,'N/A') nombre", "a.cajero as cajero", "FORMAT(SUM(a.gtotal),2) monto", "sum(TRUNCATE(a.gtotal/50000,0)) cupones");
     $grid->db->select($select);
     $grid->db->from("posfact a");
     $grid->db->where("substring(numero,1,1)!=", 'X');
     $grid->db->where("fecha", $qfechai);
     $grid->db->join("scaj b", "a.cajero=b.cajero", "LEFT");
     $grid->db->groupby('a.caja,a.cajero');
     $grid->column_detail("Caja", "caja", site_url("supermercado/poscuadre/concaja/<#caja#>/<#cajero#>/{$qfechai}"));
     $grid->column("Nombre", "nombre");
     $grid->column("Cajero", "cajero", 'align="center"');
     $grid->column("Cupones", "cupones", 'align="center"');
     $grid->column("Monto", "monto", 'align="right"');
     $grid->build();
     //echo $grid->db->last_query();
     $consul = new DataForm('supermercado/buscafac/index/search/osp');
     $consul->title('Buscar Factura');
     $consul->fechad = new dateField("Desde", "fechad", "d/m/Y");
     $consul->fechah = new dateField("Hasta", "fechah", "d/m/Y");
     $consul->nombre = new inputField("Nombre", "nombre");
     $consul->cedula = new inputField("C&eacute;dula/RIF", "cedula");
     $consul->fechad->insertValue = $consul->fechah->insertValue = date("Y/m/d");
     $consul->fechah->size = $consul->fechad->size = 10;
     $consul->submit("btn_submit", "Buscar");
     $consul->build_form();
     $data['content'] = $filter->output . $grid->output . $consul->output;
     $data['title'] = "<h1>Consulta de Cajas</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
示例#10
0
    function index()
    {
        //$this->datasis->modulo_id(123,1);
        $this->rapyd->load("dataform", "datatable");
        $this->load->library('table');
        $modbus = array('tabla' => 'maes', 'columnas' => array('codigo' => 'C&oacute;digo', 'descrip' => 'Descripci&oacute;n', 'precio1' => 'Precio 1', 'precio2' => 'Precio 2', 'precio3' => 'Precio 3', 'precio4' => 'Precio 4', 'precio5' => 'Precio 5'), 'filtro' => array('codigo' => 'C&oacute;digo', 'descrip' => 'Descripci&oacute;n'), 'retornar' => array('codigo' => 'codigo'), 'titulo' => 'Buscar en inventario');
        $boton = $this->datasis->modbus($modbus);
        $filter = new DataForm('supermercado/consulcajas/index/process');
        $filter->title('Seleccione un producto');
        $filter->codigo = new inputField("Codigo", "codigo");
        $filter->codigo->append($boton);
        $filter->codigo->size = 10;
        $filter->button("btnsubmit", "Consultar", '', $position = "BL");
        $filter->build_form();
        $table = new DataTable(null);
        $table->cell_attributes = 'style="vertical-align:middle;"';
        $table->db->select(array('caja', 'ubica'));
        $table->db->from("caja");
        $table->db->where("ubica REGEXP  '^([1-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5])\\.(([0-9]{1,2}|1[0-9]{2}|2[0-4][0-9]|25[0-5])\\.){2}([0-9]{1,2}|1[0-9]{2}|2[0-4][0-9]|25[0-5])\$' ");
        $table->db->orderby('caja');
        $table->per_row = 2;
        $table->per_page = 30;
        $celda = array(array(image('caja_abierta.gif', "Caja  <#caja#>", array('border' => 0, 'align' => 'center')) . '<br>Caja <#caja#>', '<div name="cc<#caja#>" id="<#ubica#>"></div>'));
        $table->cell_template = $this->table->generate($celda);
        $table->build();
        $link = site_url('supermercado/consulcajas/preciocaj');
        $script = <<<script
\t\t<script type='text/javascript'>

\t\t\$(document).ready(function() {
\t\t\t\$("input[name='btnsubmit']").click(function () { 
\t\t\t  
\t\t\t  var producto=jQuery.trim(\$('#codigo').val());
\t\t\t\tif (producto.length==0){
\t\t\t\t\talert('Debe introducir un producto');
\t\t\t\t\treturn false;
\t\t\t\t}
\t\t\t\t\$("div[name^='cc']").each(function (i) {
\t\t\t    \$(this).load("{$link}"+'/'+this.id+'/'+producto);
\t\t\t  });
\t\t\t  
\t\t\t});
\t\t});

\t\t</script>
script;
        $data['content'] = $filter->output . $table->output;
        $data['title'] = "<h1>Consulta de productos en cajas</h1>";
        $data["head"] = $this->rapyd->get_head() . script("jquery.js") . $script;
        $this->load->view('view_ventanas', $data);
    }
示例#11
0
 function dias()
 {
     $this->rapyd->load("datagrid2", "dataform");
     $fechad = $this->uri->segment(4);
     if (empty($fechad)) {
         $fechad = date("Y-m-d");
         $date = new DateTime();
         $date->setDate(substr($fechad, 0, 4), substr($fechad, 5, 2), substr($fechad, 8, 2));
         $date->modify("-6 month");
         $fechad = $date->format("j-n-Y");
     }
     $fechah = $this->uri->segment(5);
     if (empty($fechah)) {
         $fechah = date("d-m-Y");
     }
     $filter = new DataForm();
     $filter->title('Filtro de Analisis de Gastos');
     $filter->fechad = new dateonlyField("Desde", "fechad", 'd-m-Y');
     $filter->fechah = new dateonlyField("Hasta", "fechah", 'd-m-Y');
     $filter->fechad->clause = $filter->fechah->clause = "where";
     $filter->fechad->db_name = $filter->fechah->db_name = "fecha";
     $filter->fechad->insertValue = $fechad;
     $filter->fechah->insertValue = $fechah;
     $filter->fechah->size = $filter->fechad->size = 10;
     $filter->fechad->operator = ">=";
     $filter->fechah->operator = "<=";
     $filter->button("btnsubmit", "Buscar", form2uri(site_url('/ventas/analisisventas/dias'), array('fechad', 'fechah')), $position = "BL");
     $filter->build_form();
     $link = "ventas/analisisventas/dia/<#fecha#>";
     $grid = new DataGrid2("Ventas Por D&iacute;as");
     $grid->column("Fecha", anchor($link, "<dbdate_to_human><#fecha#></dbdate_to_human>"), "align=center");
     $grid->column("Ventas", "<number_format><#ventas#>|2|,|.</number_format>", 'align=right');
     $grid->column("Anulaciones", "<number_format><#anulaciones#>|2|,|.</number_format>", 'align=right');
     $select = array("fecha", "sum(tota*(tipoa<>'X')) as ventas", "sum(tota*(tipoa='X')) as anulaciones");
     $grid->db->select($select);
     $grid->db->from('sitems');
     $fechad2 = substr($fechad, 6, 4) . substr($fechad, 3, 2) . substr($fechad, 0, 2);
     $fechah2 = substr($fechah, 6, 4) . substr($fechah, 3, 2) . substr($fechah, 0, 2);
     $grid->db->where('fecha >= ', $fechad2);
     $grid->db->where('fecha <= ', $fechah2);
     $grid->db->groupby("fecha");
     $grid->build();
     //echo $grid->db->last_query();
     $data['content'] = $filter->output . '<div style="overflow: auto; width: 100%;">' . $grid->output . '</div>';
     $data['title'] = "<h1>Analisis de Ventas</h1>";
     $data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
示例#12
0
    function index()
    {
        $this->rapyd->load("datagrid", "dataform");
        $this->load->helper('openflash');
        $anio = $this->uri->segment(4);
        if (empty($anio)) {
            $anio = date("Y");
        }
        $script = '
			$(function() {
				$(".inputnum").numeric(".");
			});
			';
        $filter = new DataForm();
        $filter->title('Filtro de An&aacute;lisis de Ventas');
        $filter->script($script, "create");
        $filter->script($script, "modify");
        $filter->anio = new inputField("A&ntilde;o", "anio");
        $filter->anio->size = 4;
        $filter->anio->insertValue = $anio;
        $filter->anio->maxlength = 4;
        $filter->anio->rule = "trim";
        $filter->anio->css_class = 'inputnum';
        $filter->button("btnsubmit", "Buscar", form2uri(site_url('/supermercado/analisis/index'), array('anio')), $position = "BL");
        $filter->build_form();
        $link = "supermercado/analisis/departamento/<#depto#>/{$anio}";
        $select = array('a.fecha', 'a.depto', 'a.familia', 'a.grupo', 'a.codigo', 'a.impuesto', 'a.monto', 'a.cantidad', 'a.transac', 'a.tipo', 'b.descrip');
        $grid = new DataGrid('Ventas por Departamentos');
        $grid->column("Departamento", anchor($link, '<#descrip#>'), 'nowrap=yes');
        for ($i = 1; $i <= 12; $i++) {
            $nmes = $this->calendar->get_month_name(str_pad($i, 2, "0", STR_PAD_LEFT));
            $grid->column($nmes, "<nformat><#m{$i}#></nformat>", 'align=right');
            $select[] = "sum(a.monto*(month(a.fecha)={$i}))  AS m{$i}";
        }
        $grid->db->select($select);
        $grid->db->from('est_item  AS a');
        $grid->db->join('dpto  AS b', 'a.depto=b.depto');
        $grid->db->where('YEAR(a.fecha)', $anio);
        $grid->db->where("a.tipo", 'I');
        $grid->db->groupby('a.depto');
        $grid->build();
        //echo  $grid->db->last_query();
        $data['content'] = $filter->output . '<div style="overflow: auto; width: 100%;">' . $grid->output . '</div>';
        $data['title'] = "<h1>An&aacute;lisis de Ventas</h1>";
        $data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
        $this->load->view('view_ventanas', $data);
    }
示例#13
0
 function anuales()
 {
     $this->rapyd->load("datagrid2");
     $this->rapyd->load("dataform");
     $this->load->helper('openflash');
     if ($this->uri->segment(4)) {
         $anio = $this->uri->segment(4);
     } elseif (isset($_POST['anio'])) {
         $anio = $_POST['anio'];
     }
     if (empty($anio)) {
         $anio = date("Y");
     }
     $fechai = $anio . '0101';
     $fechaf = $anio . '1231';
     $filter = new DataForm('finanzas/ggastos/anuales');
     $filter->title('Filtro de Gastos Anuales');
     $filter->anio = new inputField("A&ntilde;o", "anio");
     $filter->anio->size = 4;
     $filter->anio->insertValue = $anio;
     $filter->anio->maxlength = 4;
     $filter->button("btnsubmit", "Buscar", form2uri(site_url('finanzas/ggastos/anuales/'), array('anio')), $position = "BL");
     $filter->build_form();
     $grid = new DataGrid2();
     $select = array("fecha", "proveed", "nombre", "SUM(totneto)AS grantotal", "COUNT(*) AS numfac");
     $grid->db->select($select);
     $grid->db->from("gser");
     $grid->db->where('fecha >= ', $fechai);
     $grid->db->where('fecha <= ', $fechaf);
     $grid->db->groupby("proveed");
     $grid->db->orderby("grantotal DESC");
     $grid->column("Gasto", "nombre", "align='left'");
     $grid->column("Total", "<number_format><#grantotal#>|2|,|.</number_format>", 'align=right');
     $grid->column("Cant. Fact", "numfac", 'align=right');
     $grid->totalizar('grantotal');
     $grid->build();
     $grafico = open_flash_chart_object(680, 450, site_url("finanzas/ggastos/ganuales/{$anio}/"));
     $data['content'] = $grafico;
     $data['content'] .= $filter->output . $grid->output;
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = $this->rapyd->get_head() . "<h1>Gastos Anuales</h1>";
     $this->load->view('view_ventanas', $data);
 }
示例#14
0
 function index()
 {
     $this->rapyd->load("dataform");
     $this->load->helper('openflash');
     $mes = $this->uri->segment(4);
     $anio = $this->uri->segment(5);
     if (empty($mes)) {
         $mes = date("m");
     }
     if (empty($anio)) {
         $anio = date("Y");
     }
     $fechai = $anio . $mes . '01';
     $fechaf = $anio . $mes . '31';
     $filter = new DataForm();
     $filter->title('Filtro de ventas mensuales');
     $filter->mes = new dropdownField("Mes/A&ntilde;o", "mes");
     for ($i = 1; $i < 13; $i++) {
         $filter->mes->option(str_pad($i, 2, '0', STR_PAD_LEFT), str_pad($i, 2, '0', STR_PAD_LEFT));
     }
     $filter->mes->size = 2;
     $filter->mes->style = '';
     $filter->mes->insertValue = $mes;
     $filter->anio = new inputField("A&ntilde;o", "anio");
     $filter->anio->in = 'mes';
     $filter->anio->size = 4;
     $filter->anio->insertValue = $anio;
     $filter->anio->rule = "max_length[4]";
     $filter->button("btnsubmit", "Buscar", form2uri(site_url('compras/analisis/index'), array('mes', 'anio')), $position = "BL");
     $filter->build_form();
     $data['forma'] = '';
     $data['lista'] = $filter->output;
     $data['lista'] .= open_flash_chart_object(800, 300, site_url("compras/analisis/departa/{$mes}/{$anio}"));
     $data['titulo'] = $this->rapyd->get_head() . "<center><h2>VENTAS MENSUALES</h2></center>";
     $this->layout->buildPage('ventas/view_ventas', $data);
 }
示例#15
0
 function traer()
 {
     $this->datasis->modulo_id($this->modulo, 1);
     //$this->datasis->modulo_id(11D,1);
     $this->rapyd->load("dataform", "datatable", 'datagrid');
     $this->load->library('table');
     $scli = array('tabla' => 'scli', 'columnas' => array('cliente' => 'C&oacute;digo Cliente', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('cliente' => 'C&oacute;digo Cliente', 'nombre' => 'Nombre'), 'retornar' => array('cliente' => 'cliente'), 'titulo' => 'Buscar Cliente');
     $boton = $this->datasis->modbus($scli);
     $filter = new DataForm('supervisor/tiketrpc/tiket/process');
     $filter->title('Filtro de fecha');
     //$filter->fechad = new dateonlyField("Fecha Desde", "fechad",'Ymd');
     //$filter->fechad->insertValue = date("Y-m-d");
     //$filter->fechad->size=12;
     $filter->cliente = new inputField("Cliente", "cliente");
     $filter->cliente->size = 15;
     $filter->cliente->append($boton);
     //$filter->button("btnsubmit", "Consultar", '', $position="BL");
     $filter->button("btnsubmit", "Traer Tikets", form2uri(site_url("/supervisor/tiket/traertiket"), array('cliente')), $position = "BL");
     //
     //$filter->button("btnsubmit", "Traer Tikets", form2uri(site_url("/supervisor/tiket/traertiket"), $position="BL");//
     $filter->build_form();
     $data = array();
     $mSQL = "SELECT a.id,a.cliente,a.ubicacion,a.url,a.basededato,a.puerto,a.usuario,a.clave,a.observacion, b.nombre FROM tiketconec AS a JOIN scli AS b ON a.cliente=b.cliente WHERE url REGEXP '^([[:alnum:]]+\\.{0,1})+\$' ORDER BY id";
     $query = $this->db->query($mSQL);
     if ($query->num_rows() > 0) {
         foreach ($query->result_array() as $row) {
             $data[] = $row;
         }
     }
     $grid = new DataGrid("Clientes", $data);
     $grid->column("Cliente", '<b><#nombre#></b>');
     $grid->column("URL", 'url');
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = " Traer tikets de clientes ";
     $data["head"] = $this->rapyd->get_head() . script("jquery.js") . script("plugins/jquery.json.min.js");
     $this->load->view('view_ventanas', $data);
 }
示例#16
0
 function diarias($anio = '', $proveed = '', $mes = '')
 {
     $this->rapyd->load('datagrid2');
     $this->rapyd->load('dataform');
     $this->load->helper('openflash');
     $proveed = radecode($proveed);
     if (isset($_POST['anio']) && empty($anio)) {
         $anio = $_POST['anio'];
     }
     if (isset($_POST['mes']) && empty($mes)) {
         $mes = $_POST['mes'];
     }
     if (isset($_POST['proveed']) && empty($proveed)) {
         $proveed = $_POST['proveed'];
     }
     if (empty($mes)) {
         redirect("compras/proveedores/mensuales/{$anio}/{$proveed}");
     }
     $fechai = $anio . str_pad($mes, 2, '0', STR_PAD_LEFT) . '01';
     $fechaf = $anio . str_pad($mes, 2, '0', STR_PAD_LEFT) . '31';
     $scli = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Codigo proveedor', 'nombre' => 'Nombre'), 'filtro' => array('proveed' => 'Còdigo proveedor', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'titulo' => 'Buscar proveedor');
     $cboton = $this->datasis->modbus($scli);
     $filter = new DataForm('compras/proveedoresdiarios');
     $filter->attributes = array('onsubmit' => "this.action='index/'+this.form.mes.value+'/'+this.form.anio.value+'/';return FALSE;");
     $filter->title('Filtro de Compras Diarias');
     $filter->mes = new dropdownField('Mes/A&ntilde;o', 'mes');
     for ($i = 1; $i < 13; $i++) {
         $filter->mes->option(str_pad($i, 2, '0', STR_PAD_LEFT), str_pad($i, 2, '0', STR_PAD_LEFT));
     }
     $filter->mes->size = 2;
     $filter->mes->style = '';
     $filter->mes->insertValue = $mes;
     $filter->anio = new inputField('A&ntilde;o', 'anio');
     $filter->anio->in = 'mes';
     $filter->anio->size = 4;
     $filter->anio->insertValue = $anio;
     $filter->anio->rule = 'max_length[4]';
     $filter->proveedor = new inputField('Proveedor', 'proveed');
     $filter->proveedor->size = 10;
     $filter->proveedor->insertValue = $proveed;
     $filter->proveedor->rule = 'max_length[4]';
     $filter->proveedor->append($cboton);
     $filter->button('btnsubmit', 'Buscar', form2uri(site_url('compras/proveedores/diarias/'), array('anio', 'proveed', 'mes')), $position = 'BL');
     $filter->build_form();
     $grid = new DataGrid2();
     $select = array('proveed', "DATE_FORMAT(fecha,'%d/%m/%Y') AS fecha", "SUM(montonet*IF(tipo_doc='NC',-1,1)) AS grantotal", "SUM(inicial*IF( tipo_doc='NC',-1,1)) AS contado", "SUM(credito*IF( tipo_doc='NC',-1,1)) AS credito", "SUM(montotot*IF(tipo_doc='NC',-1,1)) AS subtotal", "SUM(montoiva*IF(tipo_doc='NC',-1,1)) AS impuesto", 'COUNT(*) AS numfac');
     $grid->db->select($select);
     $grid->db->from('scst');
     $grid->db->where('tipo_doc <> ', 'NE');
     $grid->db->where('fecha >= ', $fechai);
     $grid->db->where('fecha <= ', $fechaf);
     $grid->db->where('proveed', $proveed);
     $grid->db->where('actuali >= fecha');
     $grid->db->groupby('fecha');
     $grid->column('Fecha', "fecha", "align='center'");
     $grid->column('Sub-Total', "<number_format><#subtotal#>|2|,|.</number_format>", 'align=right');
     $grid->column('Impuesto', "<number_format><#impuesto#>|2|,|.</number_format>", 'align=right');
     $grid->column('Total', "<number_format><#grantotal#>|2|,|.</number_format>", 'align=right');
     $grid->column('Contado', "<number_format><#contado#>|2|,|.</number_format>", 'align=right');
     $grid->column('Credito', "<number_format><#credito#>|2|,|.</number_format>", 'align=right');
     $grid->column('Cant. Fact', "numfac", 'align=right');
     $grid->totalizar('impuesto', 'grantotal', 'contado', 'credito', 'subtotal');
     $grid->build();
     $proveed = raencode($proveed);
     $grafico = open_flash_chart_object(680, 350, site_url("compras/proveedores/gdiarias/{$anio}/{$proveed}/{$mes}"));
     $data['content'] = $grafico;
     $data['content'] .= $filter->output . $grid->output;
     $data['head'] = $this->rapyd->get_head();
     $data['title'] = '<h1>Compras Diarias</h1>';
     $this->load->view('view_ventanas', $data);
 }
示例#17
0
    function mensuales($anio = '', $mes = '')
    {
        $this->rapyd->load("datagrid2");
        $this->rapyd->load("dataform");
        $this->load->helper('openflash');
        if (isset($_POST['anio']) and empty($anio)) {
            $anio = $_POST['anio'];
        }
        if (isset($_POST['mes']) and empty($mes)) {
            $mes = $_POST['mes'];
        }
        if (empty($mes)) {
            redirect("supermercado/ventas/anuales/{$anio}");
        }
        $script = '
		$(function() {
			$(".inputnum").numeric(".");
		});
		';
        $fechai = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '01';
        $fechaf = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '31';
        $filter = new DataForm('supermercado/ventas/mensuales');
        $filter->attributes = array('onsubmit' => "this.action='index/'+this.form.mes.value+'/'+this.form.anio.value+'/';return FALSE;");
        $filter->title('Filtro de Ventas Mensuales');
        $filter->script($script, "create");
        $filter->script($script, "modify");
        $filter->mes = new dropdownField("Mes/A&ntilde;o", "mes");
        for ($i = 1; $i < 13; $i++) {
            $filter->mes->option(str_pad($i, 2, '0', STR_PAD_LEFT), str_pad($i, 2, '0', STR_PAD_LEFT));
        }
        $filter->mes->size = 2;
        $filter->mes->style = '';
        $filter->mes->insertValue = $mes;
        $filter->mes->rule = "trim";
        $filter->anio = new inputField("A&ntilde;o", "anio");
        $filter->anio->in = 'mes';
        $filter->anio->size = 4;
        $filter->anio->insertValue = $anio;
        $filter->anio->maxlength = 4;
        $filter->anio->rule = "trim";
        $filter->anio->css_class = 'inputnum';
        $filter->button("btnsubmit", "Buscar", form2uri(site_url('supermercado/ventas/mensuales'), array('anio', 'mes')), $position = "BL");
        $filter->build_form();
        $grid = new DataGrid2();
        $select = array("fecha", "DATE_FORMAT(fecha,'%d') AS dia", "SUM(monto)AS grantotal", "SUM(impuesto)AS iva", "SUM(transac)as transacciones");
        $grid->db->select($select);
        $grid->db->from("est_fecha");
        $grid->db->where('fecha >= ', $fechai);
        $grid->db->where('fecha <= ', $fechaf);
        $grid->db->groupby("fecha");
        $grid->db->orderby("fecha ASC");
        //$grid->db->limit(15,0);
        $grid->column("Dia", "dia", "align='left'");
        $grid->column("Total", "<number_format><#grantotal#>|2|,|.</number_format>", 'align=right');
        $grid->column("Impuesto", "<number_format><#iva#>|2|,|.</number_format>", 'align=right');
        $grid->column("Cant.Transac", "transacciones", 'align=right');
        $grid->totalizar('iva', 'grantotal');
        $grid->build();
        $grafico = open_flash_chart_object(680, 350, site_url("supermercado/ventas/gmensuales/{$anio}/{$mes}"));
        $data['content'] = $grafico;
        $data['content'] .= $filter->output . $grid->output;
        $data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
        $data['title'] = $this->rapyd->get_head() . "<h1>Ventas Mensuales</h1>";
        $this->load->view('view_ventanas', $data);
    }
示例#18
0
 function presup($numero)
 {
     $this->rapyd->load("dataform");
     $this->load->helper('openflash');
     $filter = new DataForm("ventas/presupuesto/presupdolar/");
     $filter->attributes = array('onsubmit' => "this.action='index/'+this.form.mes.value+'/'+this.form.anio.value+'/';return FALSE;");
     $filter->title('Seleccione el Precio del D&oacute;lar con que desea Trabajar');
     $filter->dolar = new dropdownField("Precio del D&oacute;lar", "dolar");
     $filter->dolar->option("b.dolar", "Precio1");
     $filter->dolar->option("b.dolar2", "Precio2");
     $filter->dolar->option("b.dolar3", "Precio3");
     $filter->dolar->option("b.dolar4", "Precio4");
     $filter->dolar->style = 'width:150px;';
     $filter->button("btnsubmit", "Aceptar", form2uri(site_url("formatos/ver/PRESUP/{$numero}/"), array('dolar')), $position = "BL");
     $filter->build_form();
     $data['content'] = $filter->output;
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = "<h1>Presupuesto en Bolivares</h1>";
     $this->load->view('view_ventanas', $data);
 }
示例#19
0
    function autotranfer2($fecha = null)
    {
        //***************************
        $this->cajas = $this->config->item('cajas');
        foreach ($this->cajas as $inv => $val) {
            $codban = $this->db->escape($val);
            $cana = $this->datasis->dameval("SELECT COUNT(*) AS cana FROM banc WHERE codbanc={$codban}");
            if ($cana == 0) {
                show_error('La caja ' . $val . ' no esta registrada en el sistema, debe registrarla por el modulo de bancos o ajustar la configuracion en config/datasis.php');
            }
        }
        //***************************
        $this->rapyd->load('dataform');
        $this->load->library('validation');
        $val = $this->validation->chfecha($fecha, 'Y-m-d');
        if ($val) {
            $montosis = $this->_montoautotranf($this->cajas['cobranzas'], $fecha);
            if ($montosis > 0) {
                $script = '
					function totaliza(){
						if($("#tarjeta").val().length>0)  tarjeta =parseFloat($("#tarjeta").val());  else tarjeta =0;
						if($("#efectivo").val().length>0) efectivo=parseFloat($("#efectivo").val()); else efectivo=0;
						if($("#gastos").val().length>0)   gastos  =parseFloat($("#gastos").val());   else gastos  =0;
						if($("#valores").val().length>0)  valores =parseFloat($("#valores").val());  else valores =0;
						monto=tarjeta+gastos+efectivo+valores;
						$("#monto").val(roundNumber(monto,2));
					}';
                $edit = new DataForm("finanzas/bcaj/autotranfer2/{$fecha}/process");
                $edit->title = 'Transferencia automatica entre cajas';
                $edit->script($script);
                //$edit->back_url = site_url('finanzas/bcaj/index');
                $campos = array('efectivo' => 'Efectivo caja: ' . $this->cajas['efectivo'], 'tarjeta' => 'Tarjeta de D&eacute;bito y Cr&eacute;dito caja: ' . $this->cajas['tarjetas'], 'gastos' => 'Gastos por Justificar caja: ' . $this->cajas['gastos'], 'valores' => 'Valores, Cesta Tickes y Cheques caja: ' . $this->cajas['valores'], 'monto' => 'Monto total');
                foreach ($campos as $obj => $titulo) {
                    $edit->{$obj} = new inputField($titulo, $obj);
                    $edit->{$obj}->css_class = 'inputnum';
                    $edit->{$obj}->rule = 'trim|numeric';
                    $edit->{$obj}->maxlength = 15;
                    $edit->{$obj}->size = 20;
                    $edit->{$obj}->group = 'Montos';
                    $edit->{$obj}->autocomplete = false;
                }
                $edit->{$obj}->rule = 'trim|numeric|callback_chtotal|required';
                $edit->{$obj}->readonly = true;
                $back_url = site_url('finanzas/bcaj/index');
                $edit->button('btn_undo', 'Regresar', "javascript:window.location='{$back_url}'", 'BL');
                $edit->submit('btnsubmit', 'Guardar');
                $edit->build_form();
                $salida = 'El monto total a tranferir para la fecha <b id="ffecha">' . dbdate_to_human($fecha) . '</b> debe ser de: <b id="mmonto">' . nformat($montosis) . '</b>';
                if ($edit->on_success()) {
                    //$fecha=$edit->fecha->newValue;
                    foreach ($campos as $obj => $titulo) {
                        ${$obj} = $edit->{$obj}->newValue;
                    }
                    if (round($montosis, 2) == round($efectivo + $tarjeta + $gastos + $valores, 2)) {
                        $rt = $this->_autotranfer($fecha, $efectivo, $tarjeta, $gastos, $valores);
                        if ($rt) {
                            redirect('/finanzas/bcaj/listo/n/' . $this->bcajnumero);
                        } else {
                            redirect('/finanzas/bcaj/listo/s');
                        }
                    } else {
                        $edit->error_string = 'El monto total a transferir debe ser de :<b>' . nformat($montosis) . '</b>, faltan ' . nformat($montosis - $efectivo - $tarjeta - $gastos - $valores);
                        $edit->build_form();
                        //$salida .= $edit->output;
                    }
                }
                $salida .= $edit->output;
                $url = site_url('finanzas/bcaj/ajaxmonto');
                $this->rapyd->jquery[] = '$(".inputnum").numeric(".");';
                $this->rapyd->jquery[] = '$(".inputnum").bind("keyup",function() { totaliza(); });';
                $this->rapyd->jquery[] = '$("td").removeAttr("style");';
                $this->rapyd->jquery[] = '$("input[name=\'traesaldo\']").click(function() {
					fecha=$("#fecha").val();
					if(fecha.length > 0){
						$.post("' . $url . '", { fecha: $("#fecha").val() },
							function(data){
								$("#mmonto").html(nformat(data));
								$("#ffecha").html($("#fecha").val());
								$(".alert").hide("slow");
							});
					}else{
						alert("Debe introducir una fecha");
					}
					});';
            } else {
                $dbfecha = $this->db->escape($fecha);
                $mSQL = "SELECT COUNT(*) AS cana FROM bcaj WHERE concep2='AUTOTRANFER' AND fecha={$dbfecha}";
                $cana = $this->datasis->dameval($mSQL);
                if ($cana > 0) {
                    $salida = 'Ya fue hecha una tranferencias para la fecha dada, si desea puede reversarla haciendo click ' . anchor('finanzas/bcaj/reverautotranfer/' . $fecha, 'aqui') . ' ';
                    $salida .= ' o puede ' . anchor('finanzas/bcaj/index', 'regresar') . ' al inicio.';
                } else {
                    $salida = 'No hay monto disponible para transferir ' . anchor('finanzas/bcaj/autotranfer', 'Regresar');
                }
            }
        } else {
            show_error('Falta el parametro fecha');
        }
        $data['content'] = $salida;
        $data['title'] = '<h1>Conciliaci&oacute;n de cierre </h1>';
        $data['head'] = $this->rapyd->get_head() . phpscript('nformat.js');
        $this->load->view('view_ventanas', $data);
    }
示例#20
0
    function filtro()
    {
        $this->rapyd->load("datagrid2");
        $this->rapyd->load("dataform");
        $this->load->helper('openflash');
        $sinv = array('tabla' => 'sinv', 'columnas' => array('codigo' => 'C&oacute;digo', 'descrip' => 'descrip'), 'filtro' => array('codigo' => 'C&oacute;digo', 'descrip' => 'descrip'), 'retornar' => array('codigo' => 'codigo'), 'titulo' => 'Buscar Articulo');
        $iboton = $this->datasis->modbus($sinv);
        if ($this->uri->segment(4)) {
            $codigo = $this->uri->segment(4);
        } elseif (isset($_POST['codigo'])) {
            $codigo = $_POST['codigo'];
        }
        if (empty($codigo)) {
            $codigo = $this->datasis->dameval("SELECT codigo FROM sinv");
        }
        if ($this->uri->segment(5)) {
            $mes = $this->uri->segment(5);
        } elseif (isset($_POST['mes'])) {
            $mes = $_POST['mes'];
        } else {
            $mes = date('m');
        }
        if ($this->uri->segment(6)) {
            $anio = $this->uri->segment(6);
        } elseif (isset($_POST['anio'])) {
            $anio = $_POST['anio'];
        } else {
            $anio = date('Y');
        }
        $script = '
			$(function() {
				$(".inputnum").numeric(".");
			});
			';
        $fechad = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '01';
        $fechah = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '31';
        $filter = new DataForm('ventas/mensuales');
        $filter->attributes = array('onsubmit' => "this.action='index/'+this.form.mes.value+'/'+this.form.anio.value+'/';return FALSE;");
        $filter->title('Filtro de Ventas por Existencias');
        $filter->script($script, "create");
        $filter->script($script, "modify");
        $filter->mes = new dropdownField("Mes/A&ntilde;o", "mes");
        for ($i = 1; $i < 13; $i++) {
            $filter->mes->option(str_pad($i, 2, '0', STR_PAD_LEFT), str_pad($i, 2, '0', STR_PAD_LEFT));
        }
        $filter->mes->size = 2;
        $filter->mes->style = '';
        $filter->mes->insertValue = $mes;
        $filter->anio = new inputField("A&ntilde;o", "anio");
        $filter->anio->in = 'mes';
        $filter->anio->size = 4;
        $filter->anio->insertValue = $anio;
        $filter->anio->maxlength = 4;
        $filter->anio->rule = "trim";
        $filter->anio->css_class = 'inputnum';
        $filter->codigo = new inputField("C&oacute;digo", "codigo");
        $filter->codigo->size = 15;
        $filter->codigo->append($iboton);
        $filter->codigo->insertValue = $codigo;
        $filter->button("btnsubmit", "Buscar", form2uri(site_url('inventario/gproductos/filtro/'), array('codigo', 'mes', 'anio')), $position = "BL");
        $filter->build_form();
        $grid = new DataGrid2();
        $select = array("fecha", "codigo", "sum(cantidad) cantidad", "IF(sum(cantidad)<=salcant,sum(cantidad),salcant)*(salcant>0)as salcant");
        $grid->db->select($select);
        $grid->db->from("costos");
        $grid->db->where('codigo', $coigo);
        $grid->db->where('fecha >= ', $fechai);
        $grid->db->where('fecha <= ', $fechaf);
        $grid->db->where('origen', '3I');
        $grid->db->groupby("fecha");
        $grid->db->orderby("fecha");
        $grid->db->having("cantidad>0");
        $grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", 'align=center');
        $grid->column("Ventas", "cantidad", 'align=center');
        $grid->column("Existencias", "salcant", 'align=center');
        //$grid->totalizar('grantotal');
        $grid->build();
        //echo $grid->db->last_query();
        $grafico = open_flash_chart_object(680, 450, site_url("inventario/gproductos/grafico/{$codigo}/{$mes}/{$anio}/"));
        $data['content'] = $grafico;
        $data['content'] .= $filter->output . $grid->output;
        $data["head"] = $this->rapyd->get_head();
        $data['title'] = $this->rapyd->get_head() . "<h1>Ventas por Existencias</h1>";
        $this->load->view('view_ventanas', $data);
    }
示例#21
0
    function cargar($control)
    {
        $this->rapyd->uri->keep_persistence();
        $this->rapyd->load('dataform');
        $dbcontrol = $this->db->escape($control);
        $farmaxDB = $this->load->database('farmax', TRUE);
        $farmaxdb = $farmaxDB->database;
        $localdb = $this->db->database;
        $msj = '';
        $block = trim($this->datasis->traevalor('SCSTACTIVABLOQUEO', 'Activa la bloque al cargar compras, P:por promedio,M:por valor maximo'));
        if ($block == 'P' || $block == 'M') {
            $mSQL = "SELECT COALESCE(c.abarras,b.codigo) AS codigo,a.descrip, a.cantidad\n\t\t\tFROM {$farmaxdb}.itscst AS a\n\t\t\tLEFT JOIN {$localdb}.sinv AS b ON a.codigo=b.codigo\n\t\t\tLEFT JOIN {$localdb}.farmaxasig AS c ON a.codigo=c.barras AND c.proveed=a.proveed\n\t\t\tWHERE a.control={$dbcontrol}";
            $query = $this->db->query($mSQL);
            foreach ($query->result() as $row) {
                if (empty($row->codigo)) {
                    continue;
                }
                $cana = intval($row->cantidad);
                $fdesde = date('Ymd', mktime(0, 0, 0, date('n') - 2, 1, date('Y')));
                $fhasta = date('Ymd', mktime(0, 0, 0, date('n'), 0, date('Y')));
                if ($block == 'P') {
                    $sql = "SELECT SUM(cana) AS cana FROM sitems WHERE fecha BETWEEN {$fdesde} AND {$fhasta} AND codigoa=" . $this->db->escape($row->codigo);
                    $venta = $this->datasis->dameval($sql);
                    if (empty($venta)) {
                        $venta = 0;
                    } else {
                        $venta = ceil($venta / 2);
                    }
                    $fdesde = date('Ymd', mktime(0, 0, 0, date('n'), 1, date('Y')));
                    $fhasta = date('Ymd');
                    $sql = "SELECT SUM(IF(b.tipo_doc IN ('FC','NE'),1,-1)*a.cantidad) AS cana FROM itscst AS a JOIN scst AS b ON a.control=b.control  WHERE b.recep BETWEEN {$fdesde} AND {$fhasta} AND a.codigo=" . $this->db->escape($row->codigo);
                    $compra = $this->datasis->dameval($sql);
                    if (empty($compra)) {
                        $compra = 0;
                    }
                    $lim = $cana + $compra;
                    if ($lim > $venta) {
                        $msj .= '&nbsp;&nbsp;-' . $row->codigo . '-' . $row->descrip . ', Cantidad: <b>' . nformat($cana) . '</b>, Compra en el mes: <b>' . nformat($compra) . '</b>, L&iacute;mite: <b>' . nformat($venta) . '</b>' . br();
                    }
                } else {
                    $sql = "SELECT COUNT(*) FROM sinv WHERE existen+{$cana} > exmax AND codigo=" . $this->db->escape($row->codigo);
                    $ch = $this->datasis->dameval($sql);
                    if ($ch > 0) {
                        $msj .= $row->codigo . '-' . $row->descrip . ', Se esta comprando mas del m&aacute;ximo establecido.' . br();
                    }
                }
            }
        }
        $form = new DataForm("farmacia/scst/cargar/{$control}/process");
        $form->title('Carga de compra proveniente de droguer&iacute;a');
        $form->nfiscal = new inputField('Control F&iacute;scal', 'nfiscal');
        $form->nfiscal->rule = 'required|strtoupper';
        $form->nfiscal->autocomplete = false;
        $form->nfiscal->rows = 10;
        $cana = $this->datasis->dameval("SELECT COUNT(*) AS val FROM caub WHERE gasto='N' and invfis='N'");
        $form->almacen = new dropdownField('Almac&eacute;n', 'almacen');
        if ($cana > 1) {
            $form->almacen->option('', 'Seleccionar');
        }
        $form->almacen->options("SELECT ubica,CONCAT_WS('-',ubica,ubides) AS val FROM caub WHERE gasto='N' and invfis='N' ORDER BY ubides");
        $form->almacen->insertValue = $this->datasis->traevalor('ALMACEN');
        $form->almacen->rule = 'required';
        $proveed = $this->_traesprv($control);
        $dias = $this->datasis->dameval('SELECT b.dcredito FROM sprv AS b WHERE b.proveed=' . $this->db->escape($proveed));
        $form->dias = new inputField('D&iacute;as de cr&eacute;dito', 'dias');
        $form->dias->insertValue = $dias > 0 ? $dias : 21;
        $form->dias->rule = 'required|integer';
        $form->dias->css_class = 'inputnum';
        $form->dias->size = 5;
        if (strlen($msj) > 0) {
            $form->free = new containerField('', '<p class="alert">Se ha detectado sobre existencia en los siguientes productos:' . br() . $msj . 'Es necesaria la clave de aprobaci&oacute;n para continuar</p>');
            $form->clavef = new inputField('Clave de aprobaci&oacute;n', 'clavef');
            $form->clavef->rule = 'callback_chclavef|required';
            $form->clavef->size = 10;
            $form->clavef->autocomplete = false;
            $form->clavef->type = 'password';
        }
        $action = "javascript:window.location='" . site_url('farmacia/scst/dataedit/show/' . $control) . "'";
        $form->button('btn_regresa', 'Regresar', $action, 'TR');
        $form->submit('btnsubmit', 'Guardar');
        $form->build_form();
        if ($form->on_success()) {
            $nfiscal = $form->nfiscal->newValue;
            $almacen = $form->almacen->newValue;
            $dias = $form->dias->newValue;
            $data['content'] = $this->_cargar($control, $nfiscal, $almacen, $dias) . br() . anchor('farmacia/scst/dataedit/show/' . $control, 'Regresar');
        } else {
            $data['content'] = $form->output;
        }
        $script = '<script type="text/javascript" >
		$(function() {
		    $(".inputnum").numeric(".");
		});
		</script>';
        $data['script'] = $script;
        $data['head'] = $this->rapyd->get_head() . script('jquery.js') . script('plugins/jquery.numeric.pack.js');
        $data['title'] = '<h1>Cargar compra ' . $control . '</h1>';
        $this->load->view('view_ventanas', $data);
    }
示例#22
0
    function mostrar($data4)
    {
        $this->rapyd->load("datagrid2", "dataform");
        $form = new DataForm("/supervisor/subexls/actualiza");
        $form->free = new freeField("Campos.Archivo xls", "free", "Campos de El Sistema");
        //var_dump($data4);
        //print_r($data4);
        $grid = new DataGrid2("Archivo Cargado", $data4);
        $j = 0;
        $campos .= 'cols="+$("#cols").val()+"&&dir="+$("#dir").val()';
        foreach ($cols as $col) {
            $grid->column("{$col}", "<#{$col}#>");
            $campo = "campo{$j}";
            $form->{$campo} = new dropdownField("{$col}", "campo{$j}");
            $form->{$campo}->option("ignorar", "ignorar");
            $form->{$campo}->option("codigo", "codigo");
            $form->{$campo}->option("costo", "costo");
            $form->{$campo}->option("descrip", "descrip");
            $form->{$campo}->option("descrip2", "descrip2");
            $form->{$campo}->option("clave", "clave");
            $form->{$campo}->option("grupo", "grupo");
            $form->{$campo}->option("iva", "iva");
            for ($i = 1; $i <= 3; $i++) {
                $form->{$campo}->option("base{$i}", "Base{$i}");
                $form->{$campo}->option("margen{$i}", "Margen{$i}");
                $form->{$campo}->option("precio{$i}", "Precio{$i}");
            }
            $form->{$campo}->style = 'width:150px;';
            $j++;
            $campos .= "+" . "\"&&" . $campo . "=\"+\$(\"#" . $campo . "\").val()";
        }
        //echo $campos;
        $form->cols = new inputField("", "cols");
        $form->cols->insertValue = implode(',', $cols);
        $form->cols->type = 'hidden';
        $form->dir = new inputField("", "dir");
        $form->dir->insertValue = $dir;
        $form->dir->type = 'hidden';
        //$form->submit("btnsubmit","Actualizar");
        $link = site_url('supervisor/subexls/actualiza');
        $script = '
		function actu(){
			a=confirm("�Esta Seguro que de desea Actualizar el Inventario ?");
			if(a){
				 $.ajax({
				 type: "POST",
				 processData:false,
					url: "' . $link . '",
					data: "' . $campos . ',
					success: function(msg){
						if(msg=="s.i"){
							alert("El Inventario fue Actualizado.");
						}
						else{
							alert(msg);
						}
					}
				});
			}
		}
		';
        $form->script($script);
        $form->button("actualiza", "Actualizar", "javascript:actu();");
        $form->build_form();
        $grid->build();
        $data2['content'] = $form->output . $salida . $grid->output;
    }
示例#23
0
 function index()
 {
     //$this->rapyd->load("datagrid");
     $this->rapyd->load("dataform");
     $this->load->helper('openflash');
     if (isset($_POST['anio']) and empty($anio)) {
         $anio = $_POST['anio'];
     }
     if (isset($_POST['codigo']) and empty($codigo)) {
         $codigo = $_POST['codigo'];
     }
     if (empty($anio)) {
         $anio = date("Y");
     }
     //if(empty($codigo)) redirect('ventas/anioventcli/');
     $fechai = $anio . '0101';
     $fechaf = $anio . '1231';
     $scli = array('tabla' => 'pers', 'columnas' => array('codigo' => 'C&oacute;digo Empleado', 'nombre' => 'Nombre'), 'filtro' => array('codigo' => 'C&oacute;digo codigo', 'nombre' => 'Nombre'), 'retornar' => array('codigo' => 'codigo'), 'titulo' => 'Buscar Empleado');
     $cboton = $this->datasis->modbus($scli);
     $filter = new DataForm('ventas/aumentoempleados');
     $filter->title('Filtro de Aumento de Sueldo ');
     $filter->anio = new inputField("A&ntilde;o", "anio");
     $filter->anio->size = 4;
     $filter->anio->insertValue = $anio;
     $filter->anio->rule = "max_length[4]";
     $filter->codigo = new inputField("C&oacute;digo", "codigo");
     $filter->codigo->size = 10;
     $filter->codigo->insertValue = $codigo;
     $filter->codigo->rule = "max_length[4]";
     $filter->codigo->append($cboton);
     $filter->button("btnsubmit", "Buscar", form2uri(site_url('ventas/aumentoempleados/index'), array('anio', 'vd')), $position = "BL");
     $filter->build_form();
     /*
        	$grid = new DataGrid();
     		$select=array("vd", "fecha",                                            
     		"SUM(totalg*IF(tipo_doc='D', -1, 1)) AS sueldoa","MONTH(fecha) as mes",                              
     		"SUM(totalg*(referen IN ('E', 'M'))*IF(tipo_doc='D', -1, 1)) as contado",        
     		"SUM(totalg*(referen NOT IN ('E', 'M'))*IF(tipo_doc='D', -1, 1)) as credito", 
         "FORMAT(sum(totals*IF(tipo_doc='D',-1,1)),2) AS subtotal", 
         "FORMAT(sum(iva*IF(tipo_doc='D',-1,1)),2) AS impuesto", 
         "COUNT(*) AS numfac");  
              		
     		$grid->db->select($select);  
     		$grid->db->from("sfac");
     		$grid->db->where('tipo_doc<>','X');
     		$grid->db->where('fecha >= ',$fechai);  
     		$grid->db->where('fecha <= ',$fechaf);  
     		$grid->db->where('vd',$codigo);  
     		$grid->db->groupby("mes");
     		
     		$grid->column("Fecha"          , "fecha"    );
     		$grid->column("Sub-Total"      , "subtotal" ,'align=right');
     		$grid->column("Impuesto"       , "impuesto" ,'align=right');
     		$grid->column("Total"          , "sueldoa",'align=right');
     		$grid->column("Contado"        , "contado"  ,'align=right');
     		$grid->column("Credito"        , "credito"  ,'align=right');
     		$grid->column("N&uacute;mero"  , "numfac"   ,'align=right');
     		$grid->build();*/
     $grafico = open_flash_chart_object(800, 300, site_url("nomina/aumentoempleados/grafico/{$anio}/{$codigo}"));
     $data['content'] = $grafico;
     $data['content'] .= $filter->output;
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = $this->rapyd->get_head() . "<h1>Nomina</h1>";
     $this->load->view('view_ventanas', $data);
 }
示例#24
0
 function meses()
 {
     $this->rapyd->load("datagrid2", "dataform");
     $cod = $this->uri->segment(4);
     $ano = $this->uri->segment(5);
     $filter = new DataForm("finanzas/analisisbanc/meses/process");
     $filter->title('Filtro de Caja y Bancos');
     //$filter->ano = new inputField("A&ntilde;o","ano");
     //$filter->ano->insertValue=$ano;
     //$filter->ano->maxlength=4;
     //$filter->ano->size=5;
     $filter->ano = new dropdownField("A&ntilde;o", "ano");
     $filter->ano->option($ano, $ano);
     $filter->ano->options('SELECT ano,ano as ano2 FROM bsal GROUP BY ano ORDER BY ano');
     $filter->ano->style = 'width:80px;';
     $filter->cod = new inputField("C&oacute;digo", "cod");
     $filter->cod->insertValue = $cod;
     $filter->cod->size = 5;
     $filter->cod->maxlength = 2;
     $filter->cod->type = 'hidden';
     $filter->button("btnsubmit", "Buscar", form2uri(site_url("/finanzas/analisisbanc/meses"), array('cod', 'ano')), $position = "BL");
     //
     $filter->build_form();
     function blanco($num)
     {
         if (empty($num) || $num == 0) {
             return '';
         } else {
             return number_format($num, 2, ',', '.');
         }
     }
     ///////////////////////////////////////////////////////////////////////////////////////////////////////
     $bdata = $this->datasis->damerow("SELECT saldo01,saldo02,saldo03,saldo04,saldo05,saldo06,saldo06,saldo07,saldo08,saldo09,saldo10,saldo11,saldo12 FROM bsal WHERE codbanc='{$cod}' AND ano='{$ano}'");
     $d = array();
     //print_r($bdata);
     //if($bdata['saldo01']!=0){
     if (!($bdata == NULL)) {
         for ($i = 0; $i < 12; ++$i) {
             $r = 'saldo' . str_pad($i + 1, 2, '0', STR_PAD_LEFT);
             $d[$i]['saldo'] = $bdata[$r];
             switch ($i + 1) {
                 case 1:
                     $d[$i]['mes'] = 'Enero';
                     $d[$i]['m'] = $i + 1;
                     break;
                 case 2:
                     $d[$i]['mes'] = 'Febrero';
                     $d[$i]['m'] = $i + 1;
                     break;
                 case 3:
                     $d[$i]['mes'] = 'Marzo';
                     $d[$i]['m'] = $i + 1;
                     break;
                 case 4:
                     $d[$i]['mes'] = 'Abril';
                     $d[$i]['m'] = $i + 1;
                     break;
                 case 5:
                     $d[$i]['mes'] = 'Mayo';
                     $d[$i]['m'] = $i + 1;
                     break;
                 case 6:
                     $d[$i]['mes'] = 'Junio';
                     $d[$i]['m'] = $i + 1;
                     break;
                 case 7:
                     $d[$i]['mes'] = 'Julio';
                     $d[$i]['m'] = $i + 1;
                     break;
                 case 8:
                     $d[$i]['mes'] = 'Agosto';
                     $d[$i]['m'] = $i + 1;
                     break;
                 case 9:
                     $d[$i]['mes'] = 'Septiembre';
                     $d[$i]['m'] = $i + 1;
                     break;
                 case 10:
                     $d[$i]['mes'] = 'Octubre';
                     $d[$i]['m'] = $i + 1;
                     break;
                 case 11:
                     $d[$i]['mes'] = 'Noviembre';
                     $d[$i]['m'] = $i + 1;
                     break;
                 case 12:
                     $d[$i]['mes'] = 'Diciembre';
                     $d[$i]['m'] = $i + 1;
                     break;
             }
         }
     }
     $link = "finanzas/analisisbanc/movimientos/{$cod}/{$ano}/<#m#>";
     //print_r($d);
     $grid = new DataGrid2("Movimientos por meses", $d);
     $grid->use_function('blanco');
     $grid->column("Mes", anchor($link, '<#mes#>'), "align=left");
     $grid->column("Saldo", "<blanco><#saldo#></blanco>", "align=right");
     //$grid->column("m","<#m#>","align=left");
     $grid->build();
     //memowrite( $grid->db->last_query());
     $salida = anchor("finanzas/analisisbanc/", "Atras");
     $data['content'] = $filter->output . $salida . $grid->output;
     $data['title'] = "<h1>Relaci&oacute;n de Caja y Bancos</h1>";
     $data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
示例#25
0
    function producto($anio = '', $depto = '', $fami = '', $grupo = '')
    {
        $this->rapyd->load("datagrid2");
        $this->rapyd->load("dataform");
        $this->load->helper('openflash');
        if ($this->uri->segment(4)) {
            $anio = $this->uri->segment(4);
        } elseif (isset($_POST['anio'])) {
            $anio = $_POST['anio'];
        }
        if (empty($anio)) {
            $anio = date("Y");
        }
        $fechai = $anio . '0101';
        $fechaf = $anio . '1231';
        $ajax_onchange = '
			function get_familias(){
			  var url = "' . site_url('supermercado/maes/maesfamilias') . '";
			  var pars = "dpto="+$F("depto");
			  var myAjax = new Ajax.Updater("td_familia", url, { method: "post", parameters: pars });
			
			  var url = "' . site_url('supermercado/maes/maesgrupos') . '";
			  var gmyAjax = new Ajax.Updater("td_grupo", url);
			}
			
			function get_grupo(){
			  var url = "' . site_url('supermercado/maes/maesgrupos') . '";
			  var pars = "dpto="+$F("depto")+"&fami="+$F("familia");
			  var myAjax = new Ajax.Updater("td_grupo", url, { method: "post", parameters: pars });
			}';
        $filter = new DataForm('supermercado/tventas/producto');
        $filter->script($ajax_onchange);
        $filter->title('Filtro de ventas por Producto');
        $filter->anio = new inputField("A&ntilde;o", "anio");
        $filter->anio->size = 4;
        $filter->anio->insertValue = $anio;
        $filter->anio->maxlength = 4;
        $filter->depto = new dropdownField("Departamento", "depto");
        $filter->depto->options("SELECT depto, descrip FROM dpto GROUP BY depto ORDER BY depto");
        $filter->depto->insertValue = $depto;
        $filter->depto->style = 'width:200px;';
        $filter->fami = new dropdownField("Familia", "familia");
        $filter->fami->options("SELECT familia,descrip FROM fami GROUP BY familia ORDER BY familia");
        $filter->fami->insertValue = $fami;
        $filter->fami->style = 'width:200px;';
        $filter->grupo = new dropdownField("Grupo", "grupo");
        $filter->grupo->options("SELECT grupo,nom_grup FROM grup GROUP BY grupo ORDER BY grupo");
        $filter->grupo->insertValue = $grupo;
        $filter->grupo->style = 'width:200px;';
        $filter->button("btnsubmit", "Buscar", form2uri(site_url('supermercado/tventas/producto'), array('anio', 'depto', 'familia', 'grupo')), $position = "BL");
        $filter->build_form();
        $grid = new DataGrid2();
        $select = array("a.depto", "a.familia", "a.grupo", "b.descrip", "SUM(a.monto) AS grantotal", "SUM(a.costo) AS costo", "SUM(a.cantidad) AS cantidad", "SUM(a.monto)-SUM(a.costo) AS ganancia", "(SUM(a.monto)-SUM(a.costo))*100/SUM(a.monto) AS pganancia");
        $grid->db->select($select);
        $grid->db->from("est_item AS a");
        $grid->db->join("maes AS b", "a.codigo=b.codigo");
        $grid->db->where('fecha >= ', $fechai);
        $grid->db->where('fecha <= ', $fechaf);
        $grid->db->where('a.depto', $depto);
        $grid->db->where('a.familia', $fami);
        $grid->db->where('a.grupo', $grupo);
        $grid->db->groupby("a.codigo");
        //$grid->db->limit=10;
        $grid->column("Producto", "descrip", "align='left'");
        $grid->column("Total", "<number_format><#grantotal#>|2|,|.</number_format>", 'align=right');
        $grid->column("Ganancia", "<number_format><#ganancia#>|2|,|.</number_format>", 'align=right');
        $grid->column("% Ganancia", "<number_format><#pganancia#>|2|,|.</number_format> %", 'align=right');
        $grid->column("Cantidad", "cantidad", "align='right'");
        $grid->totalizar('grantotal', 'ganancia');
        $grid->build();
        //echo $grid->db->last_query();
        $grafico = open_flash_chart_object(720, 450, site_url("supermercado/tventas/gproducto/{$anio}/{$depto}/{$fami}/{$grupo}"));
        $data['content'] = $grafico;
        $data['content'] .= $filter->output . $grid->output;
        $data["head"] = $this->rapyd->get_head();
        $data['title'] = "<h1>Ventas por Producto</h1>";
        $this->load->view('view_ventanas', $data);
    }
示例#26
0
    function forcierre($numero)
    {
        $this->rapyd->load('dataform');
        $dbnumero = $this->db->escape($numero);
        $cana = $this->datasis->dameval('SELECT COUNT(*) FROM rcaj WHERE tipo="T" AND numero=' . $dbnumero);
        if ($cana < 1) {
            $data['content'] = 'El efecto a cerrar es inv&aacute;lido o ya fue cerrado ' . anchor('ventas/rcaj/filteredgrid/search', 'Regresar');
            $data['title'] = '<h1>Recepci&oacute;n de cajas</h1>';
            $data['head'] = $this->rapyd->get_head() . script('jquery.pack.js') . script('plugins/jquery.numeric.pack.js') . script('plugins/jquery.floatnumber.js');
            $this->load->view('view_ventanas', $data);
            return;
        } else {
            $caja = $this->datasis->dameval('SELECT caja FROM rcaj WHERE tipo="T" AND numero=' . $dbnumero);
            if (empty($caja)) {
                $data['content'] = 'Falta registro de la caja ' . anchor('ventas/rcaj/filteredgrid/search', 'Regresar');
                $data['title'] = '<h1>Recepci&oacute;n de cajas</h1>';
                $data['head'] = $this->rapyd->get_head() . script('jquery.pack.js') . script('plugins/jquery.numeric.pack.js') . script('plugins/jquery.floatnumber.js');
                $this->load->view('view_ventanas', $data);
                return;
            }
        }
        $nomcajero = $this->datasis->dameval('SELECT CONCAT(TRIM(a.cajero),b.nombre) cajero FROM rcaj a JOIN scaj b ON a.cajero=b.cajero WHERE a.tipo="T" AND a.numero=' . $dbnumero);
        $form = new DataForm("ventas/rcaj/forcierre/{$numero}/process");
        $attr = array('class' => 'ui-state-default ui-corner-all', 'onclick' => "javascript:window.location='" . site_url('ventas/rcaj/filteredgrid') . "'", 'value' => 'Regresar');
        $totales = array(0, 0, 0, 0);
        $retiros = array();
        $sel = array('TRIM(tipo) AS tipo', 'SUM(monto) AS monto');
        $this->db->select($sel);
        $this->db->from('rret');
        $this->db->where('cierre', $numero);
        $this->db->group_by('tipo');
        $query = $this->db->get();
        foreach ($query->result() as $row) {
            $retiros[$row->tipo] = $row->monto;
            $totales[0] += $row->monto;
        }
        $mSQL = "SELECT TRIM(c.tipo) AS tipo,0 AS retiro,c.nombre,b.recibido,b.sistema,b.diferencia,a.caja\n\t\tFROM rcaj    AS a\n\t\tJOIN itrcaj  AS b ON a.numero=b.numero\n\t\tJOIN tarjeta AS c ON c.tipo=b.tipo\n\t\tWHERE a.numero={$dbnumero} AND c.tipo<>'RP'";
        $query = $this->db->query($mSQL);
        if ($query->num_rows() > 0) {
            $arr = array('retiro', 'recibido', 'sistema', 'diferencia');
            foreach ($query->result() as $i => $row) {
                foreach ($arr as $o => $nobj) {
                    $obj = $nobj . $row->tipo;
                    $totales[$o] += $row->{$nobj};
                    $form->{$obj} = new inputField('(' . $row->tipo . ') ' . $row->nombre, $obj);
                    $form->{$obj}->style = 'text-align:right';
                    $form->{$obj}->css_class = 'inputnum';
                    if ($nobj == 'retiro') {
                        $form->{$obj}->insertValue = isset($retiros[$row->tipo]) ? $retiros[$row->tipo] : '0';
                        $form->{$obj}->showformat = 'decimal';
                    } else {
                        $form->{$obj}->insertValue = $row->{$nobj};
                        $form->{$obj}->rule = 'numeric';
                    }
                    $form->{$obj}->size = 10;
                    $form->{$obj}->autocomplete = false;
                    if ($o != 1 || in_array($row->tipo, array('RI', 'IR'))) {
                        $form->{$obj}->readonly = true;
                        $form->{$obj}->type = 'inputhidden';
                    }
                }
            }
            foreach ($arr as $o => $nobj) {
                $obj = 't' . $nobj;
                $form->{$obj} = new inputField('<b>Totales:</b>', $obj);
                $form->{$obj}->style = 'text-align:right';
                $form->{$obj}->size = 10;
                $form->{$obj}->insertValue = $totales[$o];
                $form->{$obj}->rule = 'numeric';
                $form->{$obj}->autocomplete = false;
                if ($o == 0) {
                    $sobj = $obj;
                } else {
                    $form->{$obj}->in = $sobj;
                }
                $form->{$obj}->readonly = true;
                $form->{$obj}->type = 'inputhidden';
            }
        }
        $b_fiscal = $this->datasis->traevalor('USAMAQFISCAL', 'Activa el modo fiscal en el cierre de caja');
        if ($b_fiscal == 'S') {
            $form->x_venta = new inputField('Total Venta seg&uacute;n cierre fiscal', 'xventa');
            $form->x_venta->rule = 'max_length[17]|numeric|required';
            $form->x_venta->css_class = 'inputnum';
            $form->x_venta->size = 19;
            $form->x_venta->maxlength = 17;
            $form->x_venta->autocomplete = false;
            $form->x_viva = new inputField('Total IVA seg&uacute;n cierre fiscal', 'xviva');
            $form->x_viva->rule = 'max_length[17]|numeric|required';
            $form->x_viva->css_class = 'inputnum';
            $form->x_viva->size = 19;
            $form->x_viva->maxlength = 17;
            $form->x_viva->autocomplete = false;
            $form->x_devo = new inputField('Total de notas de cr&eacute;dito seg&uacute;n cierre fiscal', 'xdevo');
            $form->x_devo->rule = 'max_length[17]|numeric|required';
            $form->x_devo->css_class = 'inputnum';
            $form->x_devo->size = 19;
            $form->x_devo->maxlength = 17;
            $form->x_devo->autocomplete = false;
            $form->x_diva = new inputField('Total de IVA seg&uacute;n cierre fiscal', 'xdiva');
            $form->x_diva->rule = 'max_length[17]|numeric|required';
            $form->x_diva->css_class = 'inputnum';
            $form->x_diva->size = 19;
            $form->x_diva->maxlength = 17;
            $form->x_diva->autocomplete = false;
            $form->x_maqfiscal = new inputField('Serial M&aacute;quina F&iacute;scal', 'maqfiscal');
            $form->x_maqfiscal->rule = 'max_length[17]|strtoupper|required';
            $form->x_maqfiscal->size = 19;
            $form->x_maqfiscal->maxlength = 17;
            $form->x_maqfiscal->autocomplete = false;
            $form->x_ultimafc = new inputField('N&uacute;mero &uacute;ltima Factura', 'ultimafc');
            $form->x_ultimafc->rule = 'max_length[10]|required';
            $form->x_ultimafc->size = 12;
            $form->x_ultimafc->maxlength = 10;
            $form->x_ultimafc->autocomplete = false;
            $form->x_ultimanc = new inputField('N&uacute;mero &uacute;ltima NC', 'ultimanc');
            $form->x_ultimanc->rule = 'max_length[10]|required';
            $form->x_ultimanc->size = 12;
            $form->x_ultimanc->maxlength = 10;
            $form->x_ultimanc->autocomplete = false;
        }
        $form->button('btn_reg', 'Regresar', "javascript:window.location='" . site_url('ventas/rcaj/filteredgrid/search') . "'", 'BL');
        $form->submit('btnsubmit', 'Cerrar cajero');
        $form->build_form();
        $this->rapyd->jquery[] = '$(".inputnum").numeric(".");';
        $this->rapyd->jquery[] = '$(":input").click(function (){ $(this).select(); } );';
        $this->rapyd->jquery[] = '$(":input").focus(function (){ $(this).select(); } );';
        $this->rapyd->jquery[] = '$(\'input[name^="recibido"]\').bind("keyup",function() { gtotal(); });';
        $this->rapyd->jquery[] = '$(\'input[name^="recibido"]\').bind("mouseleave",function() { gtotal(); });';
        $this->rapyd->jquery[] = '$("#df1").submit(function() { return confirm("Estas seguro de realizar el Cierre?"); })';
        $this->rapyd->jquery[] = 'function gtotal(){
			TRECI=TSIS=TDIFE=0;
			$(\'input[name^="recibido"]\').each(function(i,e){
				nombre=this.name;
				tipo=nombre.substring(nombre.length-2,nombre.length);

				if($(this).val().length>0){
					recibido   =parseFloat($(this).val());
					sistema    =parseFloat($("#sistema"+tipo).val());
					diferencia=recibido-sistema;
					$("#diferencia"+tipo).val(roundNumber(diferencia,2));
					$("#diferencia"+tipo+"_val").text(nformat(diferencia,2));
				}
				if($(this).val().length>0) TRECI = TRECI+parseFloat($(this).val());
			});

			$(\'input[name^="diferencia"]\').each(function(i,e){
				if($(this).val().length>0){
					pval=parseFloat($(this).val());
					TDIFE = TDIFE+pval;
				}
			});

			$("#trecibido").val(roundNumber(TRECI,2));
			$("#tdiferencia").val(roundNumber(TDIFE,2));
			$("#trecibido_val").text(nformat(TRECI,2));
			$("#tdiferencia_val").text(nformat(TDIFE,2));
			$("#tretiro_val").text(nformat($("#tretiro").val(),2));
			$("#tsistema_val").text(nformat($("#tsistema").val(),2));
		}';
        $this->rapyd->jquery[] = 'gtotal();';
        //Cierre de caja
        if ($form->on_success()) {
            $usuario = $this->secu->usuario();
            $estampa = date('Y-m-d');
            $hora = date('H:i:s');
            $mSQL = "SELECT a.fecha,c.tipo,c.nombre ,b.recibido,b.sistema,b.diferencia, a.transac\n\t\t\tFROM rcaj    AS a\n\t\t\tJOIN itrcaj  AS b ON a.numero=b.numero\n\t\t\tJOIN tarjeta AS c ON c.tipo=b.tipo\n\t\t\tWHERE a.numero={$dbnumero}";
            $query = $this->db->query($mSQL);
            if ($query->num_rows() > 0) {
                $str = '';
                $arr = array();
                $rrecibido = $sistema = $depositos = 0;
                foreach ($query->result() as $i => $row) {
                    $nobj = 'recibido' . $row->tipo;
                    $recibido = isset($form->{$nobj}) ? empty($form->{$nobj}->newValue) ? 0.0 : floatval($form->{$nobj}->newValue) : 0.0;
                    if ($row->sistema > 0 || $recibido > 0) {
                        $str .= $row->tipo . ' ' . $recibido . '  ';
                        $arr['recibido'] = $recibido;
                        $arr['sistema'] = $row->sistema;
                        $arr['diferencia'] = $recibido - $row->sistema;
                        $arr['numero'] = $numero;
                        $arr['cierre'] = 'S';
                        $arr['tipo'] = $row->tipo;
                        if ($row->tipo == 'DE') {
                            $depositos += $recibido;
                        } else {
                            $rrecibido += $recibido;
                        }
                        $sistema += $row->sistema;
                        $mmSQL = $this->db->insert_string('itrcaj', $arr);
                        $this->db->query($mmSQL);
                    }
                }
                $rcajfecha = $this->db->escape($row->fecha);
                $transac = $row->transac;
                $arr = array('tipo' => 'F', 'recibido' => $rrecibido + $depositos, 'observa' => $str);
                if ($b_fiscal == 'S') {
                    $arr['xventa'] = $form->x_venta->newValue;
                    $arr['xviva'] = $form->x_viva->newValue;
                    $arr['xdevo'] = $form->x_devo->newValue;
                    $arr['xdiva'] = $form->x_diva->newValue;
                    $arr['maqfiscal'] = $form->x_maqfiscal->newValue;
                    $arr['ultimafc'] = $form->x_ultimafc->newValue;
                    $arr['ultimanc'] = $form->x_ultimanc->newValue;
                }
                $where = 'numero=' . $this->db->escape($numero);
                $mmSQL = $this->db->update_string('rcaj', $arr, $where);
                $this->db->query($mmSQL);
                //cierra el cajero
                $cajero = $this->datasis->dameval('SELECT cajero FROM rcaj WHERE numero=' . $dbnumero);
                $dbcajero = $this->db->escape($cajero);
                $sifact = intval($this->datasis->dameval("SELECT COUNT(*) AS cana FROM sfac WHERE cajero  ={$dbcajero} AND fecha > {$rcajfecha}"));
                $sifact += intval($this->datasis->dameval("SELECT COUNT(*) AS cana FROM sfpa WHERE cobrador={$dbcajero} AND fecha > {$rcajfecha}"));
                if ($sifact == 0) {
                    $arr = array('status' => 'C', 'fechac' => date('Ymd'), 'horac' => date('h:i:s'), 'cierre' => $rrecibido + $depositos, 'caja' => $caja);
                    $where = 'cajero=' . $this->db->escape($cajero);
                    $mmSQL = $this->db->update_string('scaj', $arr, $where);
                    $ban = $this->db->query($mmSQL);
                    if ($ban == false) {
                        memowrite($mmSQL, 'rcaj');
                    }
                }
                //Inicio de las transacciones ISLR
                $mmSQL = "SELECT a.monto,a.fecha,a.numero,c.nombre,a.transac\n\t\t\t\tFROM sfpa AS a\n\t\t\t\tJOIN rcaj AS b ON a.fecha=b.fecha AND a.cobrador=b.cajero\n\t\t\t\tJOIN scli AS c ON a.cod_cli=c.cliente\n\t\t\t\tWHERE b.numero={$dbnumero} AND a.tipo='IR'";
                $qquery = $this->db->query($mmSQL);
                foreach ($qquery->result() as $rrow) {
                    $XNUMERO = $this->datasis->fprox_numero('ndcli');
                    $data['tipo_doc'] = 'ND';
                    $data['numero'] = $XNUMERO;
                    $data['cod_cli'] = 'RETEN';
                    $data['nombre'] = 'RETENCION DE ISLR';
                    $data['fecha'] = $rrow->fecha;
                    $data['monto'] = $rrow->monto;
                    $data['impuesto'] = 0;
                    $data['vence'] = date('Ymd', mktime(0, 0, 0, substr($rrow->fecha, 5, 2) + 1, 3, substr($rrow->fecha, 0, 4)));
                    $data['observa1'] = 'RET/ISLR DE FE ' . $rrow->numero;
                    $data['observa2'] = 'CLIENTE ' . $rrow->nombre;
                    $data['banco'] = '';
                    $data['tipo_op'] = '';
                    $data['num_op'] = '';
                    $data['reten'] = 0;
                    $data['ppago'] = 0;
                    $data['control'] = '';
                    $data['cambio'] = 0;
                    $data['mora'] = 0;
                    $data['abonos'] = 0;
                    $data['transac'] = $rrow->transac;
                    $data['usuario'] = $usuario;
                    $data['estampa'] = $estampa;
                    $data['hora'] = $hora;
                    $mSQL = $this->db->insert_string('smov', $data);
                    $ban = $this->db->query($mSQL);
                    if ($ban == false) {
                        memowrite($mSQL, 'rcaj');
                    }
                }
                //Fin de las retenciones ISLR
                //Crea el movimiento en bmov
                $mSQL = 'SELECT fecha, cajero FROM rcaj WHERE numero=' . $dbnumero;
                $query = $this->db->query($mSQL);
                $row = $query->first_row();
                $fecha = $row->fecha;
                $sfecha = str_replace('', '-', $fecha);
                $cajero = $row->cajero;
                $nbmov = $this->_banprox($caja);
                $mSQL = 'SELECT moneda, numcuent,banco,saldo FROM banc WHERE codbanc= ? ';
                $query = $this->db->query($mSQL, array($caja));
                $row = $query->first_row();
                $data = array();
                $data['codbanc'] = $caja;
                $data['moneda'] = $row->moneda;
                $data['numcuent'] = $row->numcuent;
                $data['banco'] = $row->banco;
                $data['saldo'] = $row->saldo;
                $data['tipo_op'] = 'NC';
                $data['numero'] = $nbmov;
                $data['fecha'] = $fecha;
                $data['clipro'] = 'O';
                $data['codcp'] = 'VENT';
                $data['nombre'] = 'INGRESOS DIARIOS';
                $data['monto'] = $rrecibido;
                $data['concepto'] = "ENTREGA FINAL CAJERO {$cajero} DIA " . dbdate_to_human($fecha);
                $data['transac'] = $transac;
                $data['usuario'] = $usuario;
                $data['estampa'] = $estampa;
                $data['hora'] = $hora;
                $mSQL = $this->db->insert_string('bmov', $data);
                $ban = $this->db->query($mSQL);
                if ($ban == false) {
                    memowrite($mSQL, 'rcaj');
                }
                //Fin del movimiento en bmov
                //Monto por depositos
                if ($depositos > 0) {
                    $nbmov = $this->_banprox($caja);
                    $data = array();
                    $data['codbanc'] = $caja;
                    $data['moneda'] = $row->moneda;
                    $data['numcuent'] = $row->numcuent;
                    $data['banco'] = $row->banco;
                    $data['saldo'] = $row->saldo;
                    $data['tipo_op'] = 'NC';
                    $data['numero'] = $nbmov;
                    $data['fecha'] = $fecha;
                    $data['clipro'] = 'O';
                    $data['codcp'] = 'VENT';
                    $data['nombre'] = 'INGRESOS DIARIOS';
                    $data['monto'] = $depositos;
                    $data['concepto'] = "DEPOSITOS RECIBIDOS CAJERO {$cajero} DIA " . dbdate_to_human($fecha);
                    $data['transac'] = $transac;
                    $data['usuario'] = $usuario;
                    $data['estampa'] = $estampa;
                    $data['hora'] = $hora;
                    $mSQL = $this->db->insert_string('bmov', $data);
                    $ban = $this->db->query($mSQL);
                    if ($ban == false) {
                        memowrite($mSQL, 'rcaj');
                    }
                }
                //Fin del monto por deposito
                //Actualiza el saldo en la caja
                $this->datasis->actusal($caja, $sfecha, $rrecibido + $depositos);
                //Crea la diferencia en caja si la hay
                $dif = $rrecibido + $depositos - $sistema;
                if ($dif != 0.0) {
                    $mSQL = 'SELECT COUNT(*) AS n  FROM banc WHERE codbanc="DF"';
                    $query = $this->db->query($mSQL);
                    $row = $query->first_row();
                    if ($row->n == 0) {
                        $data = array();
                        $data['codbanc'] = 'DF';
                        $data['tbanco'] = 'CAJ';
                        $data['moneda'] = 'Bs';
                        $data['banco'] = 'CAJA';
                        //$data['nombre']  ='DIFERENCIA EN CAJA';
                        $data['numcuent'] = 'DIFERENCIA EN CAJA';
                        $data['activo'] = 'S';
                        $data['tipocta'] = 'C';
                        $data['saldo'] = 0;
                        $mSQL = $this->db->insert_string('banc', $data);
                        $ban = $this->db->query($mSQL);
                        if ($ban == false) {
                            memowrite($mSQL, 'rcaj');
                        }
                    }
                    $nbmov = $this->_banprox('DF');
                    $mSQL = 'SELECT moneda, numcuent,banco,saldo FROM banc WHERE codbanc="DF"';
                    $query = $this->db->query($mSQL);
                    $row = $query->first_row();
                    if ($dif < 0) {
                        // crea la NC a causa del faltante de caja
                        $data = array();
                        $data['codbanc'] = 'DF';
                        $data['moneda'] = $row->moneda;
                        $data['numcuent'] = $row->numcuent;
                        $data['banco'] = $row->banco;
                        $data['saldo'] = $row->saldo;
                        $data['tipo_op'] = 'NC';
                        $data['numero'] = $nbmov;
                        $data['fecha'] = $fecha;
                        $data['clipro'] = 'O';
                        $data['codcp'] = 'VENT';
                        $data['nombre'] = 'INGRESOS DIARIOS';
                        $data['monto'] = abs($dif);
                        $data['concepto'] = "FALTANTE EN CAJA {$caja} CAJERO {$cajero} DIA " . dbdate_to_human($fecha);
                        $data['transac'] = $transac;
                        $data['usuario'] = $usuario;
                        $data['estampa'] = $estampa;
                        $data['hora'] = $hora;
                        $mSQL = $this->db->insert_string('bmov', $data);
                        $ban = $this->db->query($mSQL);
                        if ($ban == false) {
                            memowrite($mSQL, 'rcaj');
                        }
                    } else {
                        //Crea la ND a causa del sobrante de caja
                        $data = array();
                        $data['codbanc'] = 'DF';
                        $data['moneda'] = $row->moneda;
                        $data['numcuent'] = $row->numcuent;
                        $data['banco'] = $row->banco;
                        $data['saldo'] = $row->saldo;
                        $data['tipo_op'] = 'ND';
                        $data['numero'] = $nbmov;
                        $data['fecha'] = $fecha;
                        $data['clipro'] = 'O';
                        $data['codcp'] = 'VENT';
                        $data['nombre'] = 'INGRESOS DIARIOS';
                        $data['monto'] = abs($dif);
                        $data['concepto'] = "SOBRANTE EN CAJA {$caja} CAJERO {$cajero} DIA " . dbdate_to_human($fecha);
                        $data['transac'] = $transac;
                        $data['usuario'] = $usuario;
                        $data['estampa'] = $estampa;
                        $data['hora'] = $hora;
                        $mSQL = $this->db->insert_string('bmov', $data);
                        $ban = $this->db->query($mSQL);
                        if ($ban == false) {
                            memowrite($mSQL, 'rcaj');
                        }
                    }
                    $this->datasis->actusal('DF', $sfecha, $dif);
                }
                //Crea los movimientos bmov a consecuencia de los pagos con depositos
                //$mSQL="INSERT IGNORE INTO bmov ( codbanc, tipo_op, numero, fecha, clipro, codcp, nombre, monto, concepto, status, liable, transac, usuario, estampa, hora, anulado)
                //SELECT a.banco codbanc, a.tipo tipo_op, a.num_ref numero, a.fecha, 'C' clipro, a.cod_cli codcp, b.nombre, a.monto, 'INGRESO POR COBRANZA' concepto, 'P' status, 'S' liable, a.transac, a.usuario, a.estampa, a.hora, 'N' anulado
                //FROM sfpa a JOIN scli b ON a.cod_cli=b.cliente
                //WHERE a.tipo='DE' AND tipo_doc='FE' AND fecha=${dbfecha}";
                //$ban=$this->db->query($mSQL);
                //if($ban==false) memowrite($mSQL,'rcaj');
                logusu('rcaj', "Cerro cajero {$cajero} de {$fecha}");
                redirect('ventas/rcaj/filteredgrid/search');
            }
        }
        $attr = array('class' => 'ui-state-default ui-corner-all', 'onclick' => "javascript:window.location='" . site_url('ventas/rcaj/filteredgrid/search') . "'", 'value' => 'Regresar');
        $credito = $this->datasis->dameval("SELECT SUM((a.totalg-a.inicial)*IF(a.tipo_doc='D',-1,1)) AS credito\n\t\tFROM sfac AS a\n\t\tJOIN rcaj AS b ON a.fecha=b.fecha AND b.cajero=a.cajero\n\t\tWHERE a.referen='C' AND b.numero={$dbnumero}");
        $rp = 0;
        $mSQL = "SELECT SUM(a.monto) AS rp\n\t\tFROM sfpa AS a JOIN rcaj AS b ON a.fecha=b.fecha AND a.cobrador=b.cajero\n\t\tWHERE b.numero={$dbnumero} AND a.tipo='RP'";
        $rp += $this->datasis->dameval($mSQL);
        //Toma en cuenta los cambios de cheque
        $ccheq = 0;
        $ccquery = $this->db->query("SELECT SUM(d.monto) AS monto\n\t\tFROM sfpa AS d JOIN rcaj AS b ON d.fecha=b.fecha AND d.cobrador=b.cajero\n\t\tWHERE b.numero={$dbnumero} AND d.tipo_doc = 'CC'");
        foreach ($ccquery->result() as $ccrow) {
            $ccheq += $ccrow->monto;
        }
        $cont['b_fiscal'] = $b_fiscal;
        $cont['rp'] = $rp;
        $cont['cc'] = $ccheq;
        $cont['retiros'] = $retiros;
        $cont['credito'] = empty($credito) ? 0 : $credito;
        $cont['form'] =& $form;
        $data['content'] = $this->load->view('view_rcajcierre', $cont, true);
        //$data['content'] = $form->output;
        $data['title'] = heading('Recepci&oacute;n de Caja ' . $nomcajero);
        $data['head'] = $this->rapyd->get_head() . script('plugins/jquery.numeric.pack.js') . script('plugins/jquery.floatnumber.js') . phpscript('nformat.js');
        $this->load->view('view_ventanas', $data);
    }
示例#27
0
    function diarias($anio = '', $vendedor = '', $mes = '')
    {
        $this->rapyd->load("datagrid2");
        $this->rapyd->load("dataform");
        $this->load->helper('openflash');
        $script = '
		$(function() {
			$(".inputnum").numeric(".");
		});
		';
        if (isset($_POST['anio']) and empty($anio)) {
            $anio = $_POST['anio'];
        }
        if (isset($_POST['mes']) and empty($mes)) {
            $mes = $_POST['mes'];
        }
        if (isset($_POST['vd']) and empty($vendedor)) {
            $vendedor = $_POST['vd'];
        }
        //if(empty($anio) OR ($vendedor)) redirect("ventas/vendedoresanuales/index/$anio");
        if (empty($mes)) {
            redirect("ventas/vendedores/mensuales/{$anio}/{$vendedor}");
        }
        $fechai = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '01';
        $fechaf = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '31';
        $scli = array('tabla' => 'scli', 'columnas' => array('cliente' => 'C<p align="right">&oacute;</p>digo Vendedor', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('cliente' => 'C&oacute;digo Cliente', 'nombre' => 'Nombre'), 'retornar' => array('cliente' => 'cod_cli'), 'titulo' => 'Buscar Cliente');
        $cboton = $this->datasis->modbus($scli);
        $filter = new DataForm('ventas/vendedores/diarias');
        $filter->attributes = array('onsubmit' => "this.action='index/'+this.form.mes.value+'/'+this.form.anio.value+'/';return FALSE;");
        $filter->title('Filtro de Ventas Diarias');
        $filter->script($script, "create");
        $filter->script($script, "modify");
        $filter->mes = new dropdownField("Mes/A&ntilde;o", "mes");
        for ($i = 1; $i < 13; $i++) {
            $filter->mes->option(str_pad($i, 2, '0', STR_PAD_LEFT), str_pad($i, 2, '0', STR_PAD_LEFT));
        }
        $filter->mes->size = 2;
        $filter->mes->style = '';
        $filter->mes->insertValue = $mes;
        $filter->anio = new inputField("A&ntilde;o", "anio");
        $filter->anio->in = 'mes';
        $filter->anio->size = 4;
        $filter->anio->insertValue = $anio;
        $filter->anio->maxlength = 4;
        $filter->anio->rule = "trim";
        $filter->anio->css_class = 'inputnum';
        $filter->vendedor = new inputField("Vendedor", "vd");
        $filter->vendedor->size = 10;
        $filter->vendedor->insertValue = $vendedor;
        $filter->vendedor->rule = "max_length[4]";
        $filter->vendedor->append($cboton);
        $filter->button("btnsubmit", "Buscar", form2uri(site_url('ventas/vendedores/diarias/'), array('anio', 'vd', 'mes')), $position = "BL");
        $filter->build_form();
        $grid = new DataGrid2();
        $select = array("vd", "DATE_FORMAT(fecha,'%d/%m/%Y') AS fecha", "SUM(totalg*IF(tipo_doc='D', -1, 1)) AS grantotal", "SUM(totalg*IF(tipo_doc='D', -1, 1))/ COUNT(*) AS porcentaje", "SUM(totalg*(referen IN ('E', 'M'))*IF(tipo_doc='D', -1, 1)) as contado", "SUM(totalg*(referen NOT IN ('E', 'M'))*IF(tipo_doc='D', -1, 1)) as credito", "FORMAT(sum(totals*IF(tipo_doc='D',-1,1)),2) AS subtotal", "FORMAT(sum(iva*IF(tipo_doc='D',-1,1)),2) AS impuesto", "COUNT(*) AS numfac");
        $grid->db->select($select);
        $grid->db->from("sfac");
        $grid->db->where('tipo_doc <> ', 'X');
        $grid->db->where('fecha >= ', $fechai);
        $grid->db->where('fecha <= ', $fechaf);
        $grid->db->where('vd ', $vendedor);
        $grid->db->groupby("fecha");
        $grid->column("Dia", "fecha", "align='center'");
        $grid->column("Sub-Total", "<number_format><#subtotal#>|2|,|.</number_format>", 'align=right');
        $grid->column("Impuesto", "<number_format><#impuesto#>|2|,|.</number_format>", 'align=right');
        $grid->column("Total", "<number_format><#grantotal#>|2|,|.</number_format>", 'align=right');
        $grid->column("Contado", "<number_format><#contado#>|2|,|.</number_format>", 'align=right');
        $grid->column("Cr&eacute;dito", "<number_format><#credito#>|2|,|.</number_format>", 'align=right');
        $grid->column("Participaci&oacute;n", "<number_format><#porcentaje#>|2|,|.</number_format>", 'align=right');
        $grid->column("Cant. Fact", "numfac", 'align=right');
        $grid->totalizar('subtotal', 'impuesto', 'grantotal', 'contado', 'credito');
        $grid->build();
        $grafico = open_flash_chart_object(680, 350, site_url("ventas/vendedores/gdiarias/{$anio}/{$vendedor}/{$mes}"));
        $data['content'] = $grafico;
        $data['content'] .= $filter->output . $grid->output;
        $data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
        $data['title'] = $this->rapyd->get_head() . "<h1>Vendedores</h1>";
        $this->load->view('view_ventanas', $data);
    }
示例#28
0
 function diarias($anio = '', $cliente = '', $mes = '')
 {
     $this->rapyd->load("datagrid2");
     $this->rapyd->load("dataform");
     $this->load->helper('openflash');
     if (isset($_POST['anio']) and empty($anio)) {
         $anio = $_POST['anio'];
     }
     if (isset($_POST['mes']) and empty($mes)) {
         $mes = $_POST['mes'];
     }
     if (isset($_POST['cod_cli']) and empty($cliente)) {
         $cliente = $_POST['cod_cli'];
     }
     if (empty($mes)) {
         redirect("hospitalidad/clientes/mensuales/{$anio}/{$cliente}");
     }
     $fechai = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '01';
     $fechaf = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '31';
     $scli = array('tabla' => 'scli', 'columnas' => array('cliente' => 'C&oacute;digo Cliente', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('cliente' => 'C&oacute;digo Cliente', 'nombre' => 'Nombre'), 'retornar' => array('cliente' => 'cod_cli'), 'titulo' => 'Buscar Cliente');
     $cboton = $this->datasis->modbus($scli);
     $filter = new DataForm('hospitalidad/clientesdiarias');
     $filter->attributes = array('onsubmit' => "this.action='index/'+this.form.mes.value+'/'+this.form.anio.value+'/';return FALSE;");
     $filter->title('Filtro de Ventas Diarias');
     $filter->mes = new dropdownField("Mes/A&ntilde;o", "mes");
     for ($i = 1; $i < 13; $i++) {
         $filter->mes->option(str_pad($i, 2, '0', STR_PAD_LEFT), str_pad($i, 2, '0', STR_PAD_LEFT));
     }
     $filter->mes->size = 2;
     $filter->mes->style = '';
     $filter->mes->insertValue = $mes;
     $filter->anio = new inputField("A&ntilde;o", "anio");
     $filter->anio->in = 'mes';
     $filter->anio->size = 4;
     $filter->anio->insertValue = $anio;
     $filter->anio->maxlength = 4;
     $filter->cliente = new inputField("Cliente", "cod_cli");
     $filter->cliente->size = 10;
     $filter->cliente->insertValue = $cliente;
     $filter->cliente->rule = "max_length[4]";
     $filter->cliente->append($cboton);
     $filter->button("btnsubmit", "Buscar", form2uri(site_url('hospitalidad/clientes/diarias/'), array('anio', 'cod_cli', 'mes')), $position = "BL");
     $filter->build_form();
     $grid = new DataGrid2();
     $select = array("cod_cli,nombre", "DATE_FORMAT(fecha,'%d/%m/%Y') AS fecha", "SUM(gtotal*IF(tipo='D', -1, 1)) AS grantotal", "SUM(gtotal*IF(tipo='D', -1, 1))/ COUNT(*) AS porcentaje", "SUM(gtotal*IF(tipo='D', -1, 1)) AS contado", "SUM(gtotal*IF(tipo='D', -1, 1)) AS credito", "SUM(stotal*IF(tipo='D',-1,1))AS subtotal", "SUM(impuesto*IF(tipo='D',-1,1))AS impuesto", "COUNT(*) AS numfac");
     $grid->db->select($select);
     $grid->db->from("fmay");
     $grid->db->where('tipo<>', 'X');
     $grid->db->where('fecha >= ', $fechai);
     $grid->db->where('fecha <= ', $fechaf);
     $grid->db->where('cod_cli', $cliente);
     $grid->db->groupby("fecha");
     $grid->column("Dia", "fecha", "align='center'");
     $grid->column("Sub-Total", "<number_format><#subtotal#>|2|,|.</number_format>", 'align=right');
     $grid->column("Impuesto", "<number_format><#impuesto#>|2|,|.</number_format>", 'align=right');
     $grid->column("Total", "<number_format><#grantotal#>|2|,|.</number_format>", 'align=right');
     $grid->column("Contado", "<number_format><#contado#>|2|,|.</number_format>", 'align=right');
     $grid->column("Credito", "<number_format><#credito#>|2|,|.</number_format>", 'align=right');
     $grid->column("Participaci&oacute;n", "<number_format><#porcentaje#>|2|,|.</number_format>", 'align=right');
     $grid->column("Cant. Fact", "numfac", 'align=right');
     $grid->totalizar('impuesto', 'grantotal', 'contado', 'credito', 'subtotal');
     $grid->build();
     $grafico = open_flash_chart_object(720, 350, site_url("hospitalidad/clientes/gdiarias/{$anio}/{$cliente}/{$mes}"));
     $data['content'] = $grafico;
     $data['content'] .= $filter->output . $grid->output;
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = $this->rapyd->get_head() . "<h1>Clientes</h1>";
     $this->load->view('view_ventanas', $data);
 }
示例#29
0
    function read()
    {
        $this->load->library("Spreadsheet_Excel_Reader");
        $this->rapyd->load("datagrid2", "dataform");
        $salida = anchor('inventario/sinvactu', 'Atras');
        $type = '';
        if (isset($_FILES['archivoUserFile']['type'])) {
            $type = $_FILES['archivoUserFile']['type'];
        }
        if ($type == 'application/x-msexcel') {
            $name = $_FILES['archivoUserFile']['name'];
            $dir = ".././" . $name;
            if (copy($_FILES['archivoUserFile']['tmp_name'], $dir)) {
                $tmp = $dir;
                //$_FILES['archivoUserFile']['tmp_name'];
                $data = new Spreadsheet_Excel_Reader();
                $data->setOutputEncoding('CP1251');
                $data->read($tmp);
                error_reporting(E_ALL ^ E_NOTICE);
                $cols = array();
                for ($i = 0; $i <= $data->sheets[0]['numRows']; $i++) {
                    $ref = 0;
                    for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
                        $cols[$j - 1] = $data->sheets[0]['cells'][$i][$j];
                        if (!empty($data->sheets[0]['cells'][$i][$j])) {
                            $ref++;
                        }
                    }
                    if ($ref > 2) {
                        break;
                    }
                }
                $c = 0;
                for ($i = 0; $i <= $data->sheets[0]['numRows']; $i++) {
                    $ref = 0;
                    $j = 1;
                    foreach ($cols as $col) {
                        $data3[$i][$col] = $data->sheets[0]['cells'][$i][$j];
                        if (!empty($data->sheets[0]['cells'][$i][$j])) {
                            $ref++;
                        }
                        $j++;
                    }
                    if ($ref > 2 && implode(' ', $data3[$i]) != implode(' ', $cols)) {
                        $data4[$c] = $data3[$i];
                        $c++;
                    }
                }
                $form = new DataForm("/inventario/sinvactu/actualiza");
                $form->free = new freeField("Campos.Archivo xls", "free", "Campos de El Sistema");
                $grid = new DataGrid2("Archivo Cargado", $data4);
                $j = 0;
                $campos .= 'cols="+$("#cols").val()+"&&dir="+$("#dir").val()';
                foreach ($cols as $col) {
                    $grid->column("{$col}", "<#{$col}#>");
                    $campo = "campo{$j}";
                    $form->{$campo} = new dropdownField("{$col}", "campo{$j}");
                    $form->{$campo}->option("ignorar", "ignorar");
                    $form->{$campo}->option("codigo", "codigo");
                    $form->{$campo}->option("costo", "costo");
                    $form->{$campo}->option("descrip", "descrip");
                    $form->{$campo}->option("descrip2", "descrip2");
                    $form->{$campo}->option("clave", "clave");
                    $form->{$campo}->option("grupo", "grupo");
                    $form->{$campo}->option("iva", "iva");
                    for ($i = 1; $i <= 3; $i++) {
                        $form->{$campo}->option("base{$i}", "Base{$i}");
                        $form->{$campo}->option("margen{$i}", "Margen{$i}");
                        $form->{$campo}->option("precio{$i}", "Precio{$i}");
                    }
                    $form->{$campo}->style = 'width:150px;';
                    $j++;
                    $campos .= "+" . "\"&&" . $campo . "=\"+\$(\"#" . $campo . "\").val()";
                }
                //echo $campos;
                $form->cols = new inputField("", "cols");
                $form->cols->insertValue = implode(',', $cols);
                $form->cols->type = 'hidden';
                $form->dir = new inputField("", "dir");
                $form->dir->insertValue = $dir;
                $form->dir->type = 'hidden';
                //$form->submit("btnsubmit","Actualizar");
                $link = site_url('inventario/sinvactu/actualiza');
                $script = '
				function actu(){
					a=confirm("¿Esta Seguro que de desea Actualizar el Inventario ?");
					if(a){
						 $.ajax({
						 type: "POST",
						 processData:false,
							url: "' . $link . '",
							data: "' . $campos . ',
							success: function(msg){
								if(msg=="s.i"){
									alert("El Inventario fue Actualizado.");
								}
								else{
									alert(msg);
								}
							}
						});
					}
				}
				';
                $form->script($script);
                $form->button("actualiza", "Actualizar", "javascript:actu();");
                $form->build_form();
                $grid->build();
                $data2['content'] = $form->output . $salida . $grid->output;
            }
        } else {
            $data2['content'] = $salida;
        }
        $data2['title'] = "<h1>Actualizaci&oacute;n de Inventario</h1>";
        $data2["head"] = script("jquery.pack.js") . $this->rapyd->get_head();
        $this->load->view('view_ventanas', $data2);
    }
示例#30
0
    function gserchipros($codbanc = null)
    {
        if (empty($codbanc)) {
            show_error('Faltan par&aacute;metros');
        }
        $dbcodbanc = $this->db->escape($codbanc);
        $mSQL = 'SELECT COUNT(*) AS cana, SUM(exento+montasa+monadic+monredu+tasa+sobretasa+reducida) AS monto FROM gserchi WHERE ngasto IS NULL AND aceptado="S" AND codbanc=' . $dbcodbanc;
        $r = $this->datasis->damerow($mSQL);
        if ($r['cana'] == 0) {
            show_error('Caja sin gastos');
        }
        $mSQL = "SELECT a.codprv, b.nombre FROM banc AS a JOIN sprv AS b ON a.codprv=b.proveed WHERE a.codbanc={$dbcodbanc}";
        $query = $this->db->query($mSQL);
        if ($query->num_rows() > 0) {
            $row = $query->row();
            $nombre = $row->nombre;
            $codprv = $row->codprv;
        } else {
            $nombre = $codprv = '';
        }
        $sql = 'SELECT TRIM(a.codbanc) AS codbanc,tbanco FROM banc AS a';
        $query = $this->db->query($sql);
        $comis = array();
        if ($query->num_rows() > 0) {
            foreach ($query->result() as $row) {
                $ind = '_' . $row->codbanc;
                $comis[$ind]['tbanco'] = $row->tbanco;
            }
        }
        $json_comis = json_encode($comis);
        $this->rapyd->load('dataform', 'datagrid');
        $modbus = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'C&oacute;digo Proveedor', 'nombre' => 'Nombre', 'rif' => 'RIF'), 'filtro' => array('proveed' => 'C&oacute;digo Proveedor', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'codprv', 'nombre' => 'nombre'), 'titulo' => 'Buscar Proveedor');
        $bsprv = $this->datasis->modbus($modbus);
        $script = 'var comis = ' . $json_comis . ';
		
		$(document).ready(function() {
			desactivacampo("");
		});
		
		function desactivacampo(codb1){
			if(codb1.length>0 && codb1!="' . $this->mcred . '"){
				eval("tbanco=comis._"+codb1+".tbanco;"  );
				if(tbanco=="CAJ"){
					$("#cheque").attr("disabled","disabled");
					$("#benefi").attr("disabled","disabled");
				}else{
					$("#cheque").removeAttr("disabled");
					$("#benefi").removeAttr("disabled");
				}
			}else{
				$("#cheque").attr("disabled","disabled");
				$("#benefi").attr("disabled","disabled");
			}
		}';
        $form = new DataForm('finanzas/gser/gserchipros/' . $codbanc . '/process');
        $form->title("N&uacute;mero de facturas aceptadas {$r['cana']}, monto total <b>" . nformat($r['monto']) . '</b>');
        $form->script($script);
        $form->codprv = new inputField('Proveedor', 'codprv');
        $form->codprv->rule = 'required';
        $form->codprv->insertValue = $codprv;
        $form->codprv->size = 5;
        $form->codprv->append($bsprv);
        $form->nombre = new inputField('Nombre', 'nombre');
        $form->nombre->rule = 'required';
        $form->nombre->insertValue = $nombre;
        $form->nombre->in = 'codprv';
        $form->cargo = new dropdownField('Con cargo a', 'cargo');
        $form->cargo->option($this->mcred, 'Cr&eacute;dito');
        $form->cargo->options("SELECT codbanc, CONCAT_WS('-',codbanc,banco) AS label FROM banc WHERE activo='S' ORDER BY codbanc");
        $form->cargo->onchange = 'desactivacampo(this.value)';
        $form->cargo->rule = 'max_length[5]|required';
        $form->cheque = new inputField('N&uacute;mero de cheque', 'cheque');
        $form->cheque->rule = 'condi_required|callback_chobligaban';
        $form->cheque->append('Aplica  solo si el cargo es a un banco');
        $form->benefi = new inputField('Beneficiario', 'benefi');
        $form->benefi->insertValue = $nombre;
        $form->benefi->rule = 'condi_required|callback_chobligaban';
        $form->benefi->append('Aplica  solo si el cargo es a un banco');
        $action = "javascript:window.location='" . site_url('finanzas/gser/cierregserchi/' . $codbanc) . "'";
        $form->button('btn_regresa', 'Regresar', $action, 'BR');
        $form->submit('btnsubmit', 'Procesar');
        $form->build_form();
        $grid = new DataGrid('Lista de Gastos', 'gserchi');
        $select = array('exento + montasa + monadic + monredu + tasa + sobretasa + reducida AS totneto', 'tasa + sobretasa + reducida AS totiva', 'proveedor', 'fechafac', 'numfac', 'codbanc');
        $grid->db->select($select);
        $grid->db->where('aceptado', 'S');
        $grid->db->where('ngasto IS NULL');
        $grid->db->where('codbanc', $codbanc);
        $grid->order_by('numfac', 'desc');
        $grid->per_page = 15;
        $grid->column('Caja', 'codbanc');
        $grid->column('N&uacute;mero', 'numfac');
        $grid->column('Fecha', '<dbdate_to_human><#fechafac#></dbdate_to_human>', 'align=\'center\'');
        $grid->column('Proveedor', 'proveedor');
        $grid->column('IVA', 'totiva', 'align=\'right\'');
        $grid->column('Monto', 'totneto', 'align=\'right\'');
        //$grid->add('finanzas/gser/datagserchi/create','Agregar nueva factura');
        $grid->build();
        if ($form->on_success()) {
            $codprv = $form->codprv->newValue;
            $cargo = $form->cargo->newValue;
            $nombre = $form->nombre->newValue;
            $benefi = $form->benefi->newValue;
            $cheque = $form->cheque->newValue;
            $rt = $this->_gserchipros($codbanc, $cargo, $codprv, $benefi, $cheque);
            //var_dump($rt);
            if ($rt) {
                redirect('finanzas/gser/listo/n');
            } else {
                redirect('finanzas/gser/listo/s');
            }
        }
        $data['content'] = $form->output . $grid->output;
        $data['title'] = heading('Reposici&oacute;n de caja chica ' . $codbanc);
        $data['head'] = $this->rapyd->get_head() . script('jquery.js');
        $data['head'] .= phpscript('nformat.js');
        $this->load->view('view_ventanas', $data);
    }