PHP form2uriの例

コード例 #1

ファイル: cambioprecio.php プロジェクト: codethics/proteoerp

 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

ファイル: anuales.php プロジェクト: codethics/proteoerp

 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ñ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);
 }

コード例 #3

ファイル: tiketimp.php プロジェクト: codethics/proteoerp

 function imprimir()
 {
     $this->rapyd->load("dataform");
     $scli = array('tabla' => 'scli', 'columnas' => array('cliente' => 'Código Cliente', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('cliente' => 'Có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);
 }

コード例 #4

ファイル: poscuadre.php プロジェクト: codethics/proteoerp

 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

ファイル: anuales.php プロジェクト: codethics/proteoerp

    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ñ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

ファイル: mensuales.php プロジェクト: codethics/proteoerp

 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ñ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

ファイル: aumentosueldos.php プロジェクト: enderochoa/tortuga

 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ñ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

ファイル: productos.php プロジェクト: codethics/proteoerp

    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ñ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

ファイル: poscuadre.php プロジェクト: codethics/proteoerp

 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

ファイル: analisisventas.php プロジェクト: codethics/proteoerp

 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);
 }

コード例 #11

ファイル: analisis.php プロジェクト: codethics/proteoerp

    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álisis de Ventas');
        $filter->script($script, "create");
        $filter->script($script, "modify");
        $filter->anio = new inputField("Añ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);
    }

コード例 #12

ファイル: ggastos.php プロジェクト: codethics/proteoerp

 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ñ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);
 }

コード例 #13

ファイル: analisis.php プロジェクト: codethics/proteoerp

 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ñ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);
 }

コード例 #14

ファイル: proveedores.php プロジェクト: codethics/proteoerp

 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ñ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);
 }

コード例 #15

ファイル: gprestamos.php プロジェクト: enderochoa/tortuga

 function mensuales($anio = '', $mes = '')
 {
     $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)) {
         $mes = date("m");
     }
     if (empty($anio)) {
         $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('nomina/gprestamos/mensuales');
     $filter->attributes = array('onsubmit' => "this.action='index/'+this.form.mes.value+'/'+this.form.anio.value+'/';return FALSE;");
     $filter->title('Filtro de Prestamos mensuales');
     $filter->mes = new dropdownField("Mes/Añ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('nomina/gprestamos/mensuales/'), array('mes', 'anio')), $position = "BL");
     $filter->build_form();
     $grid = new DataGrid2();
     $select = array("fecha", "DAYOFMONTH(fecha)AS dia", "SUM(monto)AS grantotal", "COUNT(*) AS numfac");
     $grid->db->select($select);
     $grid->db->from("pres ");
     $grid->db->where('fecha >= ', $fechai);
     $grid->db->where('fecha <= ', $fechaf);
     $grid->db->groupby("fecha");
     $grid->column("Dia", "dia", "align='left'");
     $grid->column("Total", "<number_format><#grantotal#>|2|,|.</number_format>", 'align=right');
     $grid->column("Cant. Prest", "numfac", 'align=right');
     $grid->totalizar('grantotal');
     $grid->build();
     $grafico = open_flash_chart_object(680, 350, site_url("nomina/gprestamos/gmensuales/{$mes}/{$anio}"));
     $data['content'] = $grafico;
     $data['content'] .= $filter->output . $grid->output;
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = $this->rapyd->get_head() . " Prestamos Mensuales ";
     $this->load->view('view_ventanas', $data);
 }

コード例 #16

ファイル: presupuestos.php プロジェクト: codethics/proteoerp

 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ólar con que desea Trabajar');
     $filter->dolar = new dropdownField("Precio del Dó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);
 }

コード例 #17

ファイル: analisis.php プロジェクト: codethics/proteoerp

    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(".");
			});
			$("#df1").submit(function() {
					valor=$("#anio").attr("value");
					location.href="' . site_url('ventas/analisis/index') . '/"+valor;
					return false;
				});
			';
        function blanco($num)
        {
            if (empty($num) || $num == 0) {
                return '';
            } else {
                return number_format($num, 2, ',', '.');
            }
        }
        // Katy Oviedo
        //$data['lista'] = open_flash_chart_object(800,300, site_url("ventas/mensuales/grafico/$mes/$anio"));
        $filter = new DataForm();
        $filter->title('Filtro de Análisis ventas');
        $filter->script($script, "create");
        $filter->script($script, "modify");
        $filter->anio = new inputField("Año", "anio");
        $filter->anio->size = 4;
        $filter->anio->insertValue = $anio;
        $filter->anio->maxlength = 4;
        $filter->anio->rule = "trim";
        $filter->anio->css_class = 'inputnum';
        //$filter->anio = new dropdownField("Año", "anio");
        //$filter->anio->option("hola","df");
        //$filter->anio->options('SELECT YEAR(fecha),YEAR(fecha) AS fecha2 FROM eventas GROUP BY fecha2');
        //$filter->anio->style='width:80px;';
        $filter->button("btnsubmit", "Buscar", form2uri(site_url('/ventas/analisis/index'), array('anio')), $position = "BL");
        $filter->build_form();
        $link = "ventas/analisis/departamento/<#depto#>/{$anio}";
        $select = array('IFNULL(e.descrip, e.depto) dpto', 'e.depto');
        //, a.linea, a.grupo, a.codigo
        $grid = new DataGrid('Ventas por Departamentos');
        $grid->use_function('blanco');
        $grid->use_function('number_format');
        $grid->column("Departamento", anchor($link, '<#dpto#>'), '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, "<blanco><#m{$i}#>|2|,|.</blanco>", 'align=right');
            $select[] = "sum(a.tota*(month(a.fecha)={$i}))  AS m{$i}";
        }
        $grid->db->select($select);
        $grid->db->from('sfac AS f');
        $grid->db->join('sitems AS a', 'f.numero=a.numa AND f.tipo_doc=a.tipoa AND f.fecha=a.fecha', 'LEFT');
        $grid->db->join('sinv AS b', 'a.codigoa=b.codigo', 'LEFT');
        $grid->db->join('grup AS c', 'b.grupo=c.grupo', 'LEFT');
        $grid->db->join('line AS d', 'c.linea=d.linea', 'LEFT');
        $grid->db->join('dpto AS e', 'd.depto=e.depto', 'LEFT');
        $grid->db->where('YEAR(f.fecha)', $anio);
        $grid->db->where("f.tipo_doc <>", 'X');
        $grid->db->groupby('EXTRACT(YEAR_MONTH FROM f.fecha)');
        $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);
    }

コード例 #18

ファイル: posfact.php プロジェクト: codethics/proteoerp

 function index()
 {
     $this->rapyd->load('datagrid2');
     $this->rapyd->load('dataform');
     $this->load->helper('openflash');
     $diai = $this->uri->segment(4);
     $mesi = $this->uri->segment(5);
     $anoi = $this->uri->segment(6);
     $diaf = $this->uri->segment(7);
     $mesf = $this->uri->segment(8);
     $anof = $this->uri->segment(9);
     $sucu = $this->uri->segment(10);
     if ($diai === FALSE or $mesi === FALSE or $anoi === FALSE or $diaf === FALSE or $mesf === FALSE or $anof === FALSE) {
         $usema = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
         $fechai = $fechaf = date('Y/m/d', $usema);
         $qfechai = $qfechaf = date('Ymd', $usema);
     } else {
         $qfechai = $anoi . $mesi . $diai;
         $qfechaf = $anof . $mesf . $diaf;
         $fechai = "{$anoi}/{$mesi}/{$diai}";
         $fechaf = "{$anof}/{$mesf}/{$diaf}";
     }
     $select = array("date_format(fecha,'%d/%m/%Y') AS fecha", "SUM((gtotal-impuesto)*(SUBSTRING(numero,1,1)<>'X')) AS subtotal", "SUM(impuesto*(SUBSTRING(numero,1,1)<>'X')) AS iva", "SUM(gtotal*(SUBSTRING(numero,1,1)<>'X')) AS total", "SUM(gtotal*(SUBSTRING(numero,1,1)<>'X' AND gtotal<0) ) AS devolu", "SUM(gtotal*(SUBSTRING(numero,1,1)='X')) AS nulas", "COUNT(*) AS trans");
     $grid = new DataGrid2();
     $grid->db->select($select);
     $grid->db->from('posfact');
     $grid->db->join('scaj', 'posfact.cajero=scaj.cajero');
     $grid->db->join('caub', 'scaj.almacen=caub.ubica');
     $grid->db->where('caub.sucursal LIKE', "{$sucu}%");
     $grid->db->where('fecha', 'CURDATE()');
     $grid->db->groupby('fecha');
     $grid->column('Fecha', 'fecha');
     $grid->column('Sub-Total', 'subtotal', 'align=right');
     $grid->column('I.V.A.', 'iva', 'align=right');
     $grid->column('Total', 'total', 'align=right');
     $grid->column('Devoluciones', 'devolu', 'align=right');
     $grid->column('Anuladas', 'nula', 'align=right');
     $grid->column('Transferencias', 'trans', 'align=right');
     $grid->build();
     //echo $grid->db->last_query();
     $filter = new DataForm('/venta/posfact/index');
     $filter->title('Filtro de ventas cerradas');
     $filter->fechai = new dateField("Desde", "fechai", "d/m/Y");
     $filter->fechai->insertValue = $fechai;
     $filter->fechaf = new dateField("Hasta", "fechaf", "d/m/Y");
     $filter->fechaf->insertValue = $fechaf;
     $filter->fechai->size = $filter->fechaf->size = 10;
     $filter->sucu = new dropdownField("Sucursal", "sucu");
     $filter->sucu->option("", "Todas");
     $filter->sucu->options("SELECT codigo,sucursal FROM sucu");
     $filter->button("btnsubmit", "Buscar", form2uri(site_url('supermercado/posfact/index'), array('fechai', 'fechaf', 'sucu')), $position = "BL");
     $filter->build_form();
     $grid2 = new DataGrid2('Resultados');
     $grid2->totalizar('subtotal', 'iva', 'devolu', 'total');
     $grid2->db->select($select);
     $grid2->db->from('viefac');
     $grid2->db->join('scaj', 'viefac.cajero=scaj.cajero');
     $grid2->db->join('caub', 'scaj.almacen=caub.ubica');
     $grid2->db->where("caub.sucursal LIKE", "{$sucu}%");
     $grid2->db->where("fecha >=", "{$qfechai}");
     $grid2->db->where("fecha <=", "{$qfechaf}");
     $grid2->db->groupby("fecha");
     $grid2->column("Fecha", "fecha");
     $grid2->column("Sub-Total", "<number_format><#subtotal#>|2|,|.</number_format>", 'align=right');
     $grid2->column("I.V.A.", "<number_format><#iva#>|2|,|.</number_format>", 'align=right');
     $grid2->column("Total", "<number_format><#total#>|2|,|.</number_format>", 'align=right');
     $grid2->column("Devoluciones", "devolu", 'align=right');
     $grid2->column("Anuladas", "nulas", 'align=right');
     $grid2->column("Transferencias", "trans", 'align=right');
     $grid2->build();
     $data['content'] = open_flash_chart_object(680, 400, site_url("supermercado/posfact/grafico/{$qfechai}/{$qfechaf}/{$sucu}/"));
     $data['content'] .= '<h3>Ventas en Curso</h3>' . $grid->output;
     $data['content'] .= '<h3>Ventas ya Cerradas</h3>';
     $data['content'] .= $filter->output . $grid2->output;
     $data['title'] = "<h1>An&aacute;lisis de Ventas</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

コード例 #19

ファイル: gproductos.php プロジェクト: codethics/proteoerp

    function filtro()
    {
        $this->rapyd->load("datagrid2");
        $this->rapyd->load("dataform");
        $this->load->helper('openflash');
        $sinv = array('tabla' => 'sinv', 'columnas' => array('codigo' => 'Código', 'descrip' => 'descrip'), 'filtro' => array('codigo' => 'Có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ñ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);
    }

コード例 #20

ファイル: analisisbanc.php プロジェクト: codethics/proteoerp

 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ño","ano");
     //$filter->ano->insertValue=$ano;
     //$filter->ano->maxlength=4;
     //$filter->ano->size=5;
     $filter->ano = new dropdownField("Añ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ó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);
 }

コード例 #21

ファイル: ventas.php プロジェクト: codethics/proteoerp

    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ñ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);
    }

コード例 #22

ファイル: tiket.php プロジェクト: enderochoa/tortuga

 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ódigo Cliente', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('cliente' => 'Có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);
 }

コード例 #23

ファイル: tventas.php プロジェクト: codethics/proteoerp

    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ñ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);
    }

コード例 #24

ファイル: vendedores.php プロジェクト: codethics/proteoerp

    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);
    }

コード例 #25

ファイル: aumentoempleados.php プロジェクト: codethics/proteoerp

 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ódigo Empleado', 'nombre' => 'Nombre'), 'filtro' => array('codigo' => 'Có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ño", "anio");
     $filter->anio->size = 4;
     $filter->anio->insertValue = $anio;
     $filter->anio->rule = "max_length[4]";
     $filter->codigo = new inputField("Có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);
 }

コード例 #26

ファイル: gcompras.php プロジェクト: codethics/proteoerp

 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("compras/gcompras/anuales/{$anio}");
     }
     $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('compras/gcompras/mensuales');
     $filter->attributes = array('onsubmit' => "this.action='index/'+this.form.mes.value+'/'+this.form.anio.value+'/';return FALSE;");
     $filter->title('Filtro de Compras Mensuales');
     $filter->mes = new dropdownField("Mes/Añ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('compras/gcompras/mensuales'), array('anio', 'mes')), $position = "BL");
     $filter->build_form();
     $grid = new DataGrid2();
     $select = array("fecha", "DAYOFMONTH(fecha) as dia", "SUM(montonet*IF(tipo_doc='D', -1, 1)) AS grantotal", "SUM(credito*IF(tipo_doc='D', -1, 1)) as contado", "SUM(inicial*IF(tipo_doc='D', -1, 1)) as credito", "SUM(montotot*IF(tipo_doc='D',-1,1))AS subtotal", "SUM(montoiva*IF(tipo_doc='D',-1,1))AS impuesto", "COUNT(*) AS numfac");
     $grid->db->select($select);
     $grid->db->from("scst");
     $grid->db->where("tipo_doc <> ", 'X');
     $grid->db->where('fecha >= ', $fechai);
     $grid->db->where('fecha <= ', $fechaf);
     $grid->db->groupby("fecha");
     $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("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("N&uacute;mero", "numfac", 'align=right');
     $grid->totalizar('impuesto', 'grantotal', 'contado', 'credito', 'subtotal');
     $grid->build();
     $grafico = open_flash_chart_object(680, 350, site_url("compras/gcompras/gmensuales/{$anio}/{$mes}"));
     $data['content'] = $grafico;
     $data['content'] .= $filter->output . $grid->output;
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = $this->rapyd->get_head() . "<h1>Compras Mensuales</h1>";
     $this->load->view('view_ventanas', $data);
 }

コード例 #27

ファイル: clientes.php プロジェクト: codethics/proteoerp

 function mensuales($anio = '', $cliente = '')
 {
     $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['cod_cli']) and empty($cliente)) {
         $cliente = $_POST['cod_cli'];
     }
     if (empty($anio) or empty($cliente)) {
         redirect("supermercado/clientes/anuales/{$anio}");
     }
     $fechai = $anio . '0101';
     $fechaf = $anio . '1231';
     $scli = array('tabla' => 'scli', 'columnas' => array('cliente' => 'Código Cliente', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('cliente' => 'Código Cliente', 'nombre' => 'Nombre'), 'retornar' => array('cliente' => 'cod_cli'), 'titulo' => 'Buscar Cliente');
     $cboton = $this->datasis->modbus($scli);
     $filter = new DataForm('supermercado/clientes/mensuales');
     $filter->title('Filtro de ventas Mensuales');
     $filter->anio = new inputField("Año", "anio");
     $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('supermercado/clientes/mensuales'), array('anio', 'cod_cli')), $position = "BL");
     $filter->build_form();
     $grid = new DataGrid2();
     $select = array("cliente,nombres,DATE_FORMAT(fecha,'%m')AS mes,\n\t\tSUM(gtotal)AS grantotal,\n\t\tSUM(impuesto)AS impuesto");
     $grid->db->select($select);
     $grid->db->from("viefac");
     $grid->db->where('tipo<>', 'X');
     $grid->db->where('fecha >= ', $fechai);
     $grid->db->where('fecha <= ', $fechaf);
     $grid->db->where('cliente', $cliente);
     $grid->db->groupby("MONTH(fecha)");
     $grid->db->orderby("mes");
     $grid->column("Mes", "mes", "align='left'");
     $grid->column("Impuesto", "<number_format><#impuesto#>|2|,|.</number_format>", 'align=right');
     $grid->column("Total", "<number_format><#grantotal#>|2|,|.</number_format>", 'align=right');
     $grid->totalizar('impuesto', 'grantotal');
     $grid->build();
     //echo $grid->db->last_query();
     $grafico = open_flash_chart_object(750, 350, site_url("supermercado/clientes/gmensuales/{$anio}/{$cliente}"));
     $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);
 }

コード例 #28

ファイル: ganancias.php プロジェクト: codethics/proteoerp

    function producto($anio = '', $departamento = '', $linea = '', $grupo = '')
    {
        $this->rapyd->load("datagrid2");
        $this->rapyd->load("dataform");
        $this->load->helper('openflash');
        rapydlib("prototype");
        $ajax_onchange = '
	  function get_linea(){
	    var url = "' . site_url('reportes/sinvlineas') . '";
	    var pars = "dpto="+$F("depto");
	    var myAjax = new Ajax.Updater("td_linea", url, { method: "post", parameters: pars });
	    get_grupo();
	  }
	  function get_grupo(){
	    var url = "' . site_url('reportes/sinvgrupos') . '";
	    var pars = "dpto="+$F("depto")+"&linea="+$F("linea");
	    var myAjax = new Ajax.Updater("td_grupo", url, { method: "post", parameters: pars });
	  }
	  ';
        if (isset($_POST['anio']) and empty($anio)) {
            $anio = $_POST['anio'];
        }
        if (isset($_POST['depto']) and empty($departamento)) {
            $departamento = $_POST['depto'];
        }
        if (isset($_POST['linea']) and empty($linea)) {
            $linea = $_POST['linea'];
        }
        if (isset($_POST['grupo']) and empty($grupo)) {
            $grupo = $_POST['grupo'];
        }
        if (empty($anio) or empty($departamento)) {
            redirect("ventas/ganancias/departamento");
        }
        if (empty($linea)) {
            redirect("ventas/ganancias/linea/{$anio}/{$departamento}");
        }
        if (empty($grupo)) {
            redirect("ventas/ganancias/grupo/{$anio}/{$departamento}/{$linea}");
        }
        $fechai = $anio . '0101';
        $fechaf = $anio . '1231';
        $filter = new DataForm('ventas/ganancias/producto');
        $filter->script($ajax_onchange);
        $filter->title('Filtro de Ganancias');
        $filter->anio = new inputField("Año", "anio");
        $filter->anio->size = 4;
        $filter->anio->insertValue = $anio;
        $filter->anio->rule = "max_length[4]";
        $filter->anio->maxlength = 4;
        $filter->departamento = new dropdownField("Departamento", "depto");
        $filter->departamento->insertValue = $departamento;
        $filter->departamento->options("SELECT depto, descrip FROM dpto WHERE tipo='I' ORDER BY depto");
        $filter->departamento->onchange = "get_linea();";
        $filter->linea = new dropdownField("Linea", "linea");
        $filter->linea->insertValue = $linea;
        $filter->linea->options("SELECT linea, descrip FROM line WHERE depto='{$departamento}'");
        $filter->linea->onchange = "get_grupo();";
        $filter->grupo = new dropdownField("Grupo", "grupo");
        $filter->grupo->insertValue = $grupo;
        $filter->grupo->options("SELECT grupo, nom_grup FROM grup WHERE depto='{$departamento}' AND linea='{$linea}'");
        $filter->button("btnsubmit", "Buscar", form2uri(site_url('ventas/ganancias/producto/'), array('anio', 'depto', 'linea', 'grupo')), $position = "BL");
        $filter->build_form();
        $grid = new DataGrid2();
        $select = array("a.fecha", "b.codigo", "b.descrip AS nombre", "e.depto", "e.descrip", "d.linea", "d.descrip", "b.grupo", "b.descrip", "c.nom_grup as ngrupo", "SUM(a.promedio*a.cantidad) AS costo", "SUM(a.venta) AS ventas", "SUM(a.venta)/COUNT(*)AS porcentaje", "SUM(a.venta)-SUM(a.promedio*a.cantidad) AS ganancias", "COUNT(*) AS numfac");
        $grid->db->select($select);
        $grid->db->from($this->from);
        foreach ($this->join as $valor) {
            $grid->db->join($valor[0], $valor[1], $valor[2]);
        }
        $grid->db->where("a.origen IN ('3I','3M')");
        $grid->db->where('fecha >= ', $fechai);
        $grid->db->where('fecha <= ', $fechaf);
        $grid->db->where('e.depto', $departamento);
        $grid->db->where('b.grupo', $grupo);
        $grid->db->groupby("a.codigo");
        $grid->db->orderby("ganancias DESC");
        $grid->column("Producto", "nombre", "align='left'");
        $grid->column("Costo", "<number_format><#costo#>|2|,|.</number_format>", 'align=right');
        $grid->column("Ventas", "<number_format><#ventas#>|2|,|.</number_format>", 'align=right');
        $grid->column("Ganancias", "<number_format><#ganancias#>|2|,|.</number_format>", 'align=right');
        $grid->column("% Ventas", "<number_format><#porcentaje#>|2|,|.</number_format>", 'align=right');
        $grid->column("Cant. Fact", "numfac", 'align=right');
        $grid->totalizar('costo', 'ganancias', 'ventas');
        $grid->build();
        $grafico = open_flash_chart_object(680, 500, site_url("ventas/ganancias/gproducto/{$anio}/{$departamento}/{$linea}/{$grupo}"));
        $data['content'] = $grafico;
        $data['content'] .= $filter->output . $grid->output;
        $data["head"] = $this->rapyd->get_head();
        $data['title'] = $this->rapyd->get_head() . "<h1>Ganancias por Producto</h1>";
        $this->load->view('view_ventanas', $data);
    }

コード例 #29

ファイル: clientes.php プロジェクト: codethics/proteoerp

 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ódigo Cliente', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('cliente' => 'Có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ñ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);
 }

コード例 #30

ファイル: gproductos.php プロジェクト: codethics/proteoerp

 function diarias($anio = '', $producto = '', $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['codigo']) and empty($producto)) {
         $producto = $_POST['codigo'];
     }
     //if(empty($anio) OR ($producto)) redirect("supermercado/gproductosanuales/index/$anio");
     if (empty($mes)) {
         redirect("supermercado/gproductos/mensuales/{$anio}/{$producto}");
     }
     $fechai = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '01';
     $fechaf = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '31';
     $maes = array('tabla' => 'maes', 'columnas' => array('codigo' => 'Código Producto', 'descrip' => 'Nombre'), 'filtro' => array('codigo' => 'Código Producto', 'descrip' => 'Nombre'), 'retornar' => array('codigo' => 'codigo'), 'titulo' => 'Buscar Vendedor');
     $cboton = $this->datasis->modbus($maes);
     $filter = new DataForm('supermercado/gproductos/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->mes = new dropdownField("Mes/Añ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->producto = new inputField("Producto", "codigo");
     $filter->producto->size = 10;
     $filter->producto->insertValue = $producto;
     $filter->producto->rule = "max_length[4]";
     $filter->producto->append($cboton);
     $filter->button("btnsubmit", "Buscar", form2uri(site_url('supermercado/gproductos/diarias/'), array('anio', 'codigo', 'mes')), $position = "BL");
     $filter->build_form();
     $grid = new DataGrid2();
     $select = array("a.codigo AS codigo", "b.descrip AS nombre", "a.cantidad AS cantidad", "DATE_FORMAT(fecha,'%m/%Y')AS mes", "SUM(a.venta)AS grantotal", "COUNT(*) AS numfac");
     $grid->db->select($select);
     $grid->db->from("costos 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.codigo', $producto);
     $grid->db->groupby("fecha");
     $grid->db->orderby("fecha");
     $grid->column("Fecha", "mes", "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, 350, site_url("supermercado/gproductos/gdiarias/{$anio}/{$producto}/{$mes}"));
     $data['content'] = $grafico;
     $data['content'] .= $filter->output . $grid->output;
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = $this->rapyd->get_head() . "<h1>Ventas Diarias</h1>";
     $this->load->view('view_ventanas', $data);
 }