function verfactura($caja, $cajero, $fecha, $numero)
{
$this->rapyd->load("datagrid2");
$grid = new DataGrid2();
$grid->db->select = array("a.codigo", "b.descrip", "a.precio", "a.monto", "a.cantidad", "a.impuesto");
$grid->db->from("vieite AS a");
$grid->db->join("maes AS b", 'a.codigo=b.codigo');
$grid->db->where("fecha", $fecha);
$grid->db->where("cajero", $cajero);
$grid->db->where("caja", $caja);
$grid->db->where("a.numero", $numero);
$grid->db->orderby('a.fecha, a.caja, a.numero');
$grid->column("Código", "codigo");
$grid->column("Descripción", "descrip");
$grid->column("Cantidad", "cantidad", 'align="right"');
$grid->column("Precio", "precio", 'align="right"');
$grid->column("Impuesto", "impuesto", 'align="right"');
$grid->column("Total", "monto", 'align="right"');
$grid->totalizar('monto');
$grid->build();
$back = anchor("supermercado/buscafac/index/search/osp", 'Regresar');
$data['content'] = $grid->output . $back;
$data["head"] = $this->rapyd->get_head();
$data['title'] = '<h1>Factura</h1>';
$this->load->view('view_ventanas', $data);
}
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é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);
}
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);
}
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ñ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);
}
function index()
{
$this->rapyd->load('dataform');
$this->rapyd->load('datagrid2');
$this->load->library('encrypt');
function dif($a, $b)
{
return number_format($a - $b, 2, ',', '.');
}
$form = new DataForm('supermercado/conciliacion/index/process');
$form->fechad = new dateonlyField('Desde', 'fechad', 'd/m/Y');
$form->fechad->insertValue = date('Y-m-d', mktime(0, 0, 0, date("m"), date("d") - 30, date("Y")));
$form->fechad->rule = 'required';
$form->fechah = new dateonlyField('Hasta', 'fechah', 'd/m/Y');
$form->fechah->insertValue = date('Y-m-d');
$form->fechah->rule = 'required';
$form->submit('btnsubmit', 'Buscar');
$form->build_form();
$tabla = '';
if ($form->on_success()) {
$fechad = $form->fechad->newValue;
$fechah = $form->fechah->newValue;
//$mSQL="SELECT 'PV' ,caja,SUM(gtotal*IF(MID(numero,1,2)='NC',-1,1)) FROM viefac WHERE fecha BETWEEN '$fechad' AND '$fechah' GROUP BY caja UNION
//SELECT 'PV' ,'MAYO',SUM(gtotal*IF(tipo='D',-1,1)) FROM fmay WHERE fecha BETWEEN '$fechad' AND '$fechah' UNION
//SELECT 'CZ' ,caja,SUM(exento+base+iva+base1+iva1+base2+iva2-ncexento-ncbase-nciva-ncbase1-nciva1-ncbase2-nciva2) FROM fiscalz WHERE fecha BETWEEN '$fechad' AND '$fechah' GROUP BY caja";
$mSQL = "SELECT a.fecha, a.caja, sum(a.gtotal*if(MID(a.numero,1,2)='NC',-1,1)) AS factura,\n\t\t\t(SELECT sum(exento+base+iva-ncexento-ncbase-nciva) venta FROM fiscalz c WHERE c.fecha=a.fecha AND c.caja=a.caja ) AS cierrez,\n\t\t\t(SELECT sum(exento+base+iva-ncexento-ncbase-nciva) venta FROM fiscalz c WHERE c.fecha=a.fecha AND c.caja=a.caja )-\n\t\t\tsum(a.gtotal*if(MID(a.numero,1,2)='NC',-1,1)) AS dife\n\t\t\tFROM viefac a\n\t\t\tWHERE a.fecha BETWEEN '{$fechad}' AND '{$fechah}' GROUP BY a.fecha, a.caja ORDER BY a.caja,a.fecha";
$grid = new DataGrid2('Resúmen');
$grid->db->_escape_char = '';
$grid->db->_protect_identifiers = false;
//$grid->per_page = 20;
$grid->use_function('dif');
$select = array('a.fecha', 'b.caja', '(SELECT sum(exento+base+iva+base1+iva1+base2+iva2-ncexento-ncbase-nciva-ncbase1-nciva1-ncbase2-nciva2) FROM fiscalz c WHERE c.fecha=a.fecha AND c.caja=b.caja) AS cierrez', '(SELECT sum(d.gtotal) FROM viefac AS d WHERE d.fecha=a.fecha AND d.caja=b.caja) AS factura');
$grid->db->select($select);
$grid->db->from('tiempo AS a');
$grid->db->join("caja AS b", "a.fecha BETWEEN '{$fechad}' AND '{$fechah}'");
$grid->db->orderby("caja,fecha");
$grid->db->having("cierrez IS NOT null OR factura IS NOT null");
$grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "align='center'");
$grid->column("Caja", "caja", 'align=center');
$grid->column("Factura", "<nformat><#factura#></nformat>", 'align=right');
$grid->column("Cierre Z", "<nformat><#cierrez#></nformat>", 'align=right');
$grid->column("Diferencia", "<dif><#factura#>|<#cierrez#></dif>", 'align=right');
$grid->totalizar('factura', 'cierrez');
$grid->build();
//echo $grid->db->last_query();
$tabla = $grid->output;
}
$reporte = anchor('reportes/ver/CONCILIACI', 'Imprimir');
$data['content'] = $form->output . $reporte . $tabla;
$data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
$data['title'] = heading('Concialiaciones de Cierre Z');
$this->load->view('view_ventanas', $data);
}
function ver_tabla($numero)
{
$this->rapyd->load("datagrid2");
$grid = new DataGrid2();
$grid->db->select(array("codigo", "descri1", "precio", "cantidad", "importe", "hora"));
$grid->db->from("sitems");
$grid->db->where('numero', $numero);
$grid->totalizar('importe');
//$grid->add("hospitalidad/restaurante/agregar/$numero");
$grid->column("Descripción", "descri1");
$grid->column("Precio", "<number_format><#precio#>|2|,|.</number_format>", 'align=right');
$grid->column("Cantidad", "<number_format><#cantidad#>|2|,|.</number_format>", 'align=right');
$grid->column("Importe", "<number_format><#importe#>|2|,|.</number_format>", 'align=right');
$grid->column("Hora", "hora", 'align=right');
$grid->build();
$data['content'] = $grid->output;
//'<input type="button" value="Regresar" name="Back" onclick="history.back()" />'.
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas_sola', $data);
}
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);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid2");
$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 DataFilter("Filtro de Control de Tiket");
$select = array("a.id as idm", "a.sucursal", "a.asignacion", "a.idt as idt", "a.padre", "a.pertenece", "a.prioridad", "a.usuario as usuarios", "a.contenido", "a.estampa", "a.actualizado", "a.estado", "b.id", "b.cliente as clientes", "b.ubicacion", "b.url", "b.basededato", "b.puerto", "b.puerto", "b.usuario", "b.clave", "b.observacion", "c.nombre", "a.minutos");
$filter->db->select($select);
$filter->db->from("tiketc AS a");
$filter->db->join("tiketconec AS b", "a.sucursal=b.id");
$filter->db->join("scli AS c", "b.cliente=c.cliente");
$filter->fechad = new dateonlyField("Fecha Desde", "fechad", 'd/m/Y');
$filter->fechad->clause = "where";
$filter->fechad->db_name = "estampa";
$filter->fechad->operator = ">=";
$filter->fechad->size = 12;
$filter->fechah = new dateonlyField("Fecha Hasta", "fechah", 'd/m/Y');
$filter->fechah->clause = "where";
$filter->fechah->db_name = "estampa";
$filter->fechah->operator = "<=";
$filter->fechah->size = 12;
$filter->estado = new dropdownField("Estado", "estado");
$filter->estado->option("", "Todos");
$filter->estado->options($this->estado);
$filter->prioridad = new dropdownField("Prioridad", "prioridad");
$filter->prioridad->option("", "Todos");
$filter->prioridad->options($this->prioridad);
$filter->contenido = new inputField("Contenido", "contenido");
//$filter->contenido->clause ="likesensitive";
//$filter->contenido->append("Sencible a las Mayuscúlas");
$filter->asignacion = new dropdownField("Asignacion", "asignacion");
$filter->asignacion->option("", "Todos");
$filter->asignacion->options("SELECT codigo, codigo as value FROM tiketservi");
$filter->asignacion->style = "width:150px";
$filter->cliente = new inputField("Cliente", "cliente");
$filter->cliente->size = 20;
$filter->cliente->db_name = "c.cliente";
$filter->cliente->append($boton);
$filter->idt = new inputField("Numero", "idt");
$filter->idt->size = 20;
$filter->idt->db_name = "idt";
$filter->buttons("reset", "search");
$filter->build();
$grid = new DataGrid2("Lista de Control de Tiket");
$grid->order_by("a.id", "desc");
$grid->per_page = 20;
$link = anchor("supervisor/tiketc/dataedit/modify/<#idm#>", "<#idm#>");
$grid->column("Id", $link);
$grid->column("Numero tiket", "idt");
$grid->column("Fecha de Ingreso", "<dbdate_to_human><#estampa#>|d/m/Y h:m:s</dbdate_to_human>");
$grid->column("Cliente", "nombre");
$grid->column("Usuario", "usuarios");
$grid->column("Contenido", "contenido");
$grid->column("Prioridad", "prioridad");
$grid->column("Estado", "estado");
$grid->column("Asignacion", "asignacion");
$grid->column("Tiempo", "minutos");
//$grid->column("URL","url");
//$resp=anchor("http://merida.matloca.com/proteoerp/supervisor/tiket/dataedit/pertenece/<#idt#>/create"", 'IR');
$resp = '<a href="http://<#url#>/proteoerp/supervisor/tiket/dataedit/pertenece/<#idt#>/create">Ir</a>';
//$resp='http://merida.matloca.com/proteoerp/supervisor/tiket/dataedit/pertenece/67/create';
$grid->column("Responder", $resp);
$grid->totalizar('minutos');
//$grid->add("supervisor/tiketc/dataedit/create");
$grid->build();
//echo $grid->db->last_query();
$data['content'] = $filter->output . $grid->output;
$data["head"] = $this->rapyd->get_head();
$data['title'] = ' Control de Tiket ';
$this->load->view('view_ventanas', $data);
}
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ñ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);
}
function movimientos()
{
$this->rapyd->load("dataform", "datagrid2");
if (isset($_POST['fechad']) && $_POST['fechad'] != '') {
$fechad = $_POST['fechad'];
} else {
$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("Y/n/j");
}
if (isset($_POST['fechah']) && $_POST['fechah'] != '') {
$fechah = $_POST['fechah'];
} else {
$fechah = date("Y/m/d");
}
if (isset($_POST['cod'])) {
$cod = $_POST['cod'];
} elseif ($cod = $this->uri->segment(4)) {
} else {
redirect("finanzas/analisisbanc");
}
if (isset($_POST['campo'])) {
$campo = $_POST['campo'];
} else {
$campo = '';
}
if (isset($_POST['oper'])) {
$oper = $_POST['oper'];
if ($oper != '') {
$valor = $oper;
}
}
if (isset($_POST['valor'])) {
$valor = $_POST['valor'];
if ($valor == '') {
if (isset($_POST['oper'])) {
$oper = $_POST['oper'];
if ($oper != '') {
$valor = $oper;
} else {
$campo = '';
}
}
}
} else {
$campo = '';
}
if (isset($_POST['oper'])) {
$oper = $_POST['oper'];
if ($oper != '') {
$valor = $oper;
}
}
if (isset($_POST['orden'])) {
$orden = $_POST['orden'];
if ($orden == '') {
$orden = 'fecha';
}
} else {
$orden = 'fecha';
}
if (isset($_POST['desc'])) {
$desc = $_POST['desc'];
if ($desc == '') {
$desc = 'asc';
}
if ($desc == '0') {
$desc = 'asc';
}
if ($desc == '1') {
$desc = 'desc';
}
} else {
$desc = 'asc';
}
$cod = $this->uri->segment(4);
$ano = $this->uri->segment(5);
$mes = $this->uri->segment(6);
if ($cod == 'process') {
if (isset($_POST['cod'])) {
$cod = $_POST['cod'];
} else {
$cod = '|!';
$ano = '';
$mes = '';
}
} else {
if (!empty($ano) && !empty($mes)) {
for ($dia = 28; $dia <= 31; $dia++) {
if (checkdate($mes, $dia, $ano)) {
$mes = str_pad($mes, 2, '0', STR_PAD_LEFT);
$fechah = "{$ano}/{$mes}/{$dia}";
}
}
$fechad = "{$ano}/{$mes}/01";
}
}
//echo $cod.'/'.$ano.'/'.$mes;
//echo $fechad."---".$fechah;
$script = '
function filtro(){
$("#tr_valor").hide();
$("#tr_oper").hide();
campo=$("#campo").val();
valor.value="";
if(campo.length>0){
if(campo=="tipo_op"){
$("#tr_oper").show();
}else{
$("#tr_valor").show();
}
}
}
$(document).ready(function(){
$("#tr_cod").hide();
$(".inputnum").numeric(".");
$("#campo").change(function () { filtro(); }).change();
});
';
$filter = new DataForm("finanzas/analisisbanc/movimientos/process");
$filter->title('Filtro de Caja y Bancos');
$filter->script($script, "create");
$filter->script($script, "modify");
$filter->fechad = new dateonlyField("Desde", "fechad", 'm/Y');
$filter->fechah = new dateonlyField("Hasta", "fechah", '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->cod = new inputField("", "cod");
$filter->cod->insertValue = $cod;
$filter->cod->readonly = TRUE;
$filter->cod->type = 'hidden';
$filter->campo = new dropdownField("Filtrar por:", "campo");
$filter->campo->option("", "");
$filter->campo->option("numero", "Numero");
$filter->campo->option("tipo_op", "Tipo Operación");
$filter->campo->option("benefi", "Beneficiario");
$filter->campo->style = 'width:150px;';
$filter->oper = new dropdownField("Tipo:", "oper");
$filter->oper->option("", "");
$filter->oper->option('CH', "Cheque");
$filter->oper->option('DE', "Deposito");
$filter->oper->option('NC', "Nota de Crédito");
$filter->oper->option('ND', "Nota de Débito");
$filter->oper->style = 'width:150px;';
$filter->valor = new inputField("", "valor");
$filter->valor->size = 20;
$filter->valor->rule = "trim";
$filter->orden = new dropdownField("Ordenar por:", "orden");
$filter->orden->option("fecha", "Fecha");
$filter->orden->option("numero", "Numero");
$filter->orden->option("tipo_op", "Tipo Operación");
$filter->orden->option("benefi", "Beneficiario");
$filter->orden->style = 'width:150px;';
$filter->desc = new radiogroupField("desc", "desc", array("0" => "Ascendente", "1" => "Descendente"), '0');
$filter->desc->in = 'orden';
$filter->submit("btnsubmit", "Buscar");
$filter->build_form();
if ($cod != '|!') {
$fila = $this->datasis->damerow("SELECT moneda,banco,numcuent FROM banc WHERE codbanc='{$cod}'");
} else {
$fila['moneda'] = '';
$fila['numcuent'] = '';
$fila['banco'] = '';
}
//print_r($fila);
function blanco($num, $m = '')
{
if (empty($num) || $num == 0) {
return '';
} else {
return number_format($num, 2, ',', '.') . $m;
}
}
$atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '5', 'screeny' => '5');
$link = "finanzas/bmovshow/dataedit/show/<#codbanc#>/<#tipo_op#>/<#numero#>";
////////////////////////consulta grid//////////////////////////////
$this->db->select("codbanc,fecha, numero, tipo_op, monto*(tipo_op IN ('DE','NC')) as ingresos,monto*(tipo_op NOT IN ('DE','NC')) as egresos,CONCAT(concepto,' ',concep2,' ',concep3) as concep, \n benefi,monto*(tipo_op IN ('DE','NC'))-monto*(tipo_op NOT IN ('DE','NC')) as saldo,CASE (tipo_op)\n\t\t\tWHEN 'CH' THEN 'Cheque'\n\t\t\tWHEN 'DE' THEN 'Deposito'\n\t\t\tWHEN 'NC' THEN 'Nota de Crédito'\n\t\t\tWHEN 'ND' THEN 'Nota de Débito'\n\t\t \tEND\n\t\t AS tipo");
$this->db->from('bmov as a');
if ($campo && $valor) {
$consult = "AND {$campo} LIKE '%{$valor}%'";
} else {
$consult = '';
}
if ($cod != '|!') {
$b = "codbanc='{$cod}' AND ";
} else {
$b = '';
}
if (strpos(substr($fechad, 6, 4), '/') == NULL) {
$fechad2 = substr($fechad, 3, 4) . substr($fechad, 0, 2);
//.substr($fechad, 0,2);
$fechah2 = substr($fechah, 3, 4) . substr($fechah, 0, 2);
//.substr($fechah, 0,2));
} else {
$fechad2 = substr($fechad, 0, 4) . substr($fechad, 5, 2);
$fechah2 = substr($fechah, 0, 4) . substr($fechah, 5, 2);
}
$this->db->where("{$b} EXTRACT(YEAR_MONTH FROM fecha) BETWEEN '{$fechad2}' AND '{$fechah2}'{$consult}");
//a.fecha like '%-$mm-%'
$this->db->orderby($orden . ' ' . $desc);
$query = $this->db->get();
//memowrite($this->db->last_query());
////////////////////////consulta grid//////////////////////////////
///////////////////////SALDO ANTERIOR//////////////////////////////
$ddata = array();
$banmes = '';
$anterior = 0;
foreach ($query->result_array() as $row) {
if ($banmes != substr($row['fecha'], 5, 2)) {
$ban = $banmes = substr($row['fecha'], 5, 2);
$ano2 = substr($row['fecha'], 0, 4);
if (1 * $banmes == 1) {
$ban = 13;
$ano2 = 1 * $ano2 - 1;
}
$campo = 'saldo' . str_pad(1 * $ban - 1, 2, '0', STR_PAD_LEFT);
$sal = $this->datasis->dameval("SELECT {$campo} FROM bsal WHERE codbanc='{$cod}' AND ano='{$ano2}'");
if ($sal == NULL) {
$sal = 0;
$row['salAnterior'] = number_format($sal, 2, ',', '.');
} else {
$anterior = $sal;
$row['salAnterior'] = number_format($anterior, 2, ',', '.');
$anterior = $anterior + $row['saldo'];
}
} else {
$row['salAnterior'] = number_format($anterior, 2, ',', '.');
$anterior = $anterior + $row['saldo'];
//$campo='';
}
//$campo;//
$ddata[] = $row;
}
///////////////////////SALDO ANTERIOR//////////////////////////////
//print_r($ddata);
if ($cod != '|!') {
$o = "Movimientos del Banco " . $fila['banco'] . " cuenta #" . $fila['numcuent'] . " desde {$fechad} hasta {$fechah}";
} else {
$o = "Todos los Bancos";
}
$grid = new DataGrid2($o, $ddata);
$grid->use_function('blanco');
if ($cod == '|!') {
$grid->column("Banco", "<#codbanc#>", 'align=left');
}
$grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>");
$grid->column("Numero", anchor_popup($link, '<#numero#>', $atts), 'nowrap=yes');
$grid->column("Tipo Operación", "<#tipo#>", 'align=left');
$grid->column("Ingresos", "<number_format><#ingresos#>|2|,|.</number_format>", "align=right");
$grid->column("Egresos", "<number_format><#egresos#>|2|,|.</number_format>", "align=right");
$grid->column("Saldo", "<number_format><#saldo#>|2|,|.</number_format>", "align=right");
$grid->column("Saldo Anterior", "<#salAnterior#>", "align=right");
$grid->column("Beneficiario", "<#benefi#>", 'align=left');
$grid->column("Concepto", "<#concep#>", 'align=left');
$grid->totalizar('ingresos', 'egresos', 'saldo');
$grid->build();
//memowrite( $grid->db->last_query());
if (!isset($ano2)) {
$ano2 = $ano;
}
$salida = anchor("finanzas/analisisbanc/meses/{$cod}/{$ano2}", "Atras");
$data['content'] = $salida . $grid->output;
$data['title'] = "<h1>Relació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);
}
function diarias()
{
$this->rapyd->load("datagrid2");
$this->rapyd->load("dataform");
$this->load->helper('openflash');
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Código', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'cprv1'), 'titulo' => 'Buscar Proveedor');
$bSPRV = $this->datasis->modbus($mSPRV);
if (isset($_POST['anio'])) {
$anio = $_POST['anio'];
}
if (isset($_POST['mes'])) {
$mes = $_POST['mes'];
} else {
$mes = '01';
}
if (isset($_POST['ubica'])) {
$ubica = $_POST['ubica'];
} else {
$ubica = NULL;
}
if (isset($_POST['cprv1'])) {
$proveed = $_POST['cprv1'];
} else {
$cprv1 = NULL;
}
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';
$sinv = array('tabla' => 'sinv', '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($sinv);
$filter = new DataForm('supermercado/productos/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;
//cprv1
$filter->almacen = new dropdownField("Almacen", "ubica");
$filter->almacen->option('', 'Todos');
$filter->almacen->options('SELECT ubica, ubides FROM caub WHERE gasto="N"');
$filter->almacen->dbname = 'a.ubica';
$filter->almacen->insertValue = $ubica;
$filter->proveed = new inputField("Proveedor", "cprv1");
$filter->proveed->db_name = "b.cprv1";
$filter->proveed->append($bSPRV);
$filter->anio = new inputField("Añ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('supermercado/productos/diarias/'),array('anio','mes','ubica','cprv1')), $position="BL");
$filter->submit("btnsubmit", "Buscar");
$filter->build_form();
$grid = new DataGrid2();
$select = array("a.codigo AS codigo", "b.descrip AS nombre", "SUM(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("maes AS b", "a.codigo=b.codigo");
$grid->db->where('fecha >= ', $fechai);
$grid->db->where('fecha <= ', $fechaf);
$grid->db->where("origen IN ('3I','3M','3R')");
if (!empty($ubica)) {
$grid->db->where('a.ubica', $ubica);
}
if (!empty($proveed)) {
$grid->db->where('b.cprv1', $proveed);
}
$grid->db->groupby("b.codigo");
$grid->db->orderby("cantidad", 'desc');
$grid->db->limit(500);
$grid->column("Codigo", "codigo", "align='left'");
$grid->column("Descripción", "nombre");
$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();
//echo $grid->db->last_query();
$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);
}
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);
}
function ver_cliente($cli)
{
function ractivo($estado, $numero)
{
if ($estado == 'R') {
$retorna = array('name' => $numero, 'id' => $estado, 'value' => 'accept', 'checked' => TRUE);
} else {
$retorna = array('name' => $numero, 'id' => $estado, 'value' => 'accept', 'checked' => FALSE);
}
return form_checkbox($retorna);
}
$this->rapyd->load("datafilter", "datagrid2");
$cliente = $this->datasis->dameval("Select nombre from scli where cliente='" . $cli . "'");
//echo $cliente;
$filter = new DataFilter("Filtro de Control de Tiket");
$select = array("a.id as idm", "a.sucursal", "a.asignacion", "a.idt as idt", "a.padre", "a.pertenece", "a.prioridad", "a.usuario as usuarios", "a.contenido", "a.estampa", "a.actualizado", "a.estado as testado", "IF(a.estado='N','Nuevo',IF(a.estado='R','Resuelto',IF(a.estado='P','Pendiente','En Proceso')))as estado", "b.id", "b.cliente as clientes", "b.url", "b.basededato", "b.puerto", "b.puerto", "b.usuario", "b.clave", "b.observacion", "c.nombre", "a.minutos");
$filter->db->select($select);
$filter->db->from("tiketc AS a");
$filter->db->join("tiketconec AS b", "a.sucursal=b.id");
$filter->db->join("scli AS c", "b.cliente=c.cliente");
$filter->db->where("b.cliente", "{$cli}");
$filter->db->where("a.estado !=", "R");
$filter->db->where("a.estado !=", "C");
$filter->estado = new dropdownField("Estado", "estado");
$filter->estado->option("P", "Pendiente");
$filter->prioridad = new dropdownField("Prioridad", "prioridad");
$filter->prioridad->option("", "Todos");
$filter->asignacion = new dropdownField("Asignacion", "asignacion");
$filter->asignacion->option("", "Todos");
$filter->asignacion->options("SELECT codigo, codigo as value FROM tiketservi");
$filter->asignacion->style = "width:150px";
$filter->nombre = new inputField("Nombre", "nombre");
$filter->nombre->size = 40;
$filter->usuario = new inputField("Usuario", "usuario");
$filter->usuario->size = 20;
$filter->buttons("reset", "search");
$filter->build('dataformfiltro');
$ticket = anchor('supervisor/tiket/traertiket/', 'Traer Todos los Ticket');
$atras = anchor('supervisor/tiketmaes/', img(array('src' => 'images/regresar.jpg', 'border' => '0', 'alt' => 'Editar', 'height' => '40')));
$uri2 = anchor('supervisor/tiketmaes/traertiket/' . $cli, 'Traer Ticket');
$uri_3 = anchor("supervisor/tiketc/dataedit/modify/<#idm#>", img(array('src' => 'images/editar.png', 'border' => '0', 'alt' => 'Editar', 'height' => '12')));
$grid = new DataGrid2($atras . '<br><center>Lista de Ticket Pendientes y Nuevos -->' . $uri2 . "</center>");
$grid->order_by("a.id", "desc");
$grid->per_page = 10;
$link = anchor("supervisor/tiketc/dataedit/modify/<#idm#>", "<#idm#>");
$grid->use_function('ractivo');
$grid->column('Acción', $uri_3, 'align=center');
$grid->column("Resuelto", "<ractivo><#testado#>|<#idm#></ractivo>", 'align="center"');
$grid->column_orderby("Id", $link, 'idm');
$grid->column_orderby("Numero tiket", "idt", 'idt');
$grid->column_orderby("Fecha de Ingreso", "<dbdate_to_human><#estampa#>|d/m/Y h:m:s</dbdate_to_human>", 'estampa');
$grid->column_orderby("Cliente", "nombre", 'nombre');
$grid->column_orderby("Estado", "estado", "estado");
$grid->column("Usuario", "usuarios");
$grid->column("Contenido", "contenido");
$grid->column("Prioridad", "prioridad");
$grid->column("Asignacion", "asignacion");
$resp = '<a href="http://<#url#>/proteoerp/supervisor/tiket/dataedit/pertenece/<#idt#>/create">Ir</a>';
$grid->column("Responder", $resp);
$grid->totalizar('minutos');
$grid->build('datagridST');
//echo $grid->db->last_query();
//************ SUPER TABLE *************
$extras = '
<script type="text/javascript">
//<![CDATA[
(function() {
var mySt = new superTable("demoTable", {
cssSkin : "sSky",
fixedCols : 1,
headerRows : 1,
onStart : function () { this.start = new Date();},
onFinish : function () {document.getElementById("testDiv").innerHTML += "Finished...<br>" + ((new Date()) - this.start) + "ms.<br>";}
});
})();
//]]>
</script>
';
$style = '
<style type="text/css">
.fakeContainer { /* The parent container */
margin: 5px;
padding: 0px;
border: none;
width: 740px; /* Required to set */
height: 320px; /* Required to set */
overflow: hidden; /* Required to set */
}
</style>
';
//****************************************
$script = '';
$url = site_url('supervisor/tiketc/activar');
$data['script'] = '<script type="text/javascript">
$(document).ready(function() {
$("form :checkbox").click(function () {
$.ajax({
type: "POST",
url: "' . $url . '",
data: "numero="+this.name+"&estado="+this.id,
success: function(msg){
//alert(msg);
}
});
}).change();
});
</script>';
$data['style'] = $style;
$data['style'] .= style('superTables.css');
$data['extras'] = $extras;
$data['content'] = $grid->output;
$data['filtro'] = $filter->output;
$data['script'] .= script('jquery.js');
$data["script"] .= script('superTables.js') . script("jquery-1.2.6.pack.js") . script("plugins/jquery.checkboxes.pack.js");
//$data['content']= form_open('').$grid->output.form_close().$script;
$data['title'] = heading('Ticket ' . $cliente);
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
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álisis de Ventas</h1>";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function diarias($anio = '', $producto = '', $mes = '')
{
$this->rapyd->load("datagrid2");
$this->rapyd->load("dataform");
$this->load->helper('openflash');
$producto = radecode($producto);
$meses = array('01' => 'ENERO', '02' => 'FEBRERO', '03' => 'MARZO', '04' => 'ABRIL', '05' => 'MAYO', '06' => 'JUNIO', '07' => 'JULIO', '08' => 'AGOSTO', '09' => 'SEPTIEMBRE', '10' => 'OCTBRE', '11' => 'NOVIEMBRE', '12' => 'DICIEMBRE');
if (isset($_POST['anio']) and empty($anio)) {
$anio = $_POST['anio'];
}
if (isset($_POST['codigo']) and empty($producto)) {
$producto = $_POST['codigo'];
}
if (isset($_POST['mes']) and empty($mes)) {
$mes = $_POST['mes'];
}
//$mes=str_pad($mes, 2, "0", STR_PAD_LEFT);
if (empty($anio) or empty($producto)) {
redirect("compras/productos/anuales/{$anio}");
}
if (empty($mes)) {
redirect("compras/productos/mensuales/{$anio}/" . raencode($producto));
}
$fechai = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '01';
$fechaf = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '31';
$sinv = array('tabla' => 'sinv', '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($sinv);
$filter = new DataForm('compras/productos/diarias');
$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->mes = new dropdownField("Mes", "mes");
$filter->mes->option($mes, $meses[str_pad($mes, 2, "0", STR_PAD_LEFT)]);
$filter->mes->options($meses);
$filter->mes->style = "width:110px;";
$filter->producto = new inputField("Producto", "codigo");
$filter->producto->size = 10;
$filter->producto->insertValue = $producto;
$filter->producto->append($cboton);
//$filter->producto2 = new inputField("", "codigoE");
//$filter->producto2->insertValue=raencode($producto);
#$filter->button("btnsubmit", "Buscar", form2uri(site_url('compras/productos/mensuales/'),array('anio','codigo')), $position="BL");
$filter->submit("btnsubmit", "Buscar");
$filter->build_form();
$grid = new DataGrid2();
$select = array("codigo", "descrip", "DAYOFMONTH(fecha) as dia", "SUM(cantidad)AS cantidad", "SUM(importe)AS grantotal", "COUNT(*) AS numfac");
$grid->db->select($select);
$grid->db->from("itscst");
$grid->db->where('fecha >= ', $fechai);
$grid->db->where('fecha <= ', $fechaf);
$grid->db->where('codigo ', $producto);
$grid->db->groupby("dia");
$grid->db->orderby("fecha");
$grid->column("Dia", "dia", "align='center'");
$grid->column("Total", "<number_format><#grantotal#>|2|,|.</number_format>", 'align=right');
$grid->column("Cantidad", "numfac", 'align=right');
$grid->totalizar('grantotal');
$grid->build();
//echo $grid->db->last_query();
$producto = raencode($producto);
$att['title'] = "Regresar al listado de meses por año";
$salida = anchor("compras/productos/mensuales/{$anio}/{$producto}", "Meses", $att);
$salida .= " del año";
$att['title'] = "Regresar al listado de Productos por año";
$salida .= anchor("compras/productos/anuales/{$anio}/", " {$anio}", $att);
$grafico = open_flash_chart_object(680, 450, site_url("compras/productos/gdiarias/{$anio}/{$producto}/{$mes}"));
$data['content'] = $grafico;
$data['content'] .= $filter->output . $salida . $grid->output;
$data["head"] = $this->rapyd->get_head();
$data['title'] = $this->rapyd->get_head() . "<h1>Compras Diarias</h1>";
$this->load->view('view_ventanas', $data);
}
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ñ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);
}
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">ó</p>digo Vendedor', '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('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ñ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ñ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édito", "<number_format><#credito#>|2|,|.</number_format>", 'align=right');
$grid->column("Participació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);
}
function itclinconsis($cliente = '', $numero = '', $tipo_doc)
{
$this->rapyd->load("datagrid2");
$uri = anchor('supervisor/mantenimiento/clinconsis', 'Regresar');
$select = array('numccli', 'tipoccli', 'fecha', 'abono', 'tipo_doc', 'cod_cli');
$grid = new DataGrid2($uri);
$grid->per_page = 15;
$grid->db->select($select);
$grid->db->from('itccli');
$grid->db->where('cod_cli', $cliente);
$grid->db->where('tipo_doc', $tipo_doc);
$grid->db->where('numero', $numero);
$grid->column('Numero', 'numccli');
$grid->column('Tipo', 'tipoccli');
$grid->column('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>');
$grid->column('Abono', 'abono');
$grid->totalizar('abono');
$grid->build();
//echo $grid->db->last_query();
//memowrite($grid->db->last_query());
$data['content'] = $grid->output;
$data['title'] = "<h1>Detalle de los Abonos del cliente:{$cliente}</h1>";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
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);
}
function ejecutar()
{
$this->rapyd->load('datagrid2', 'fields');
function dif($a, $b)
{
return number_format($a - $b, 2, ',', '.');
}
function escasql($text)
{
$text = preg_replace("/\r\n+|\r+|\n+|\t+/i", ' ', $text);
$text = htmlspecialchars($text);
$text = str_replace(array("'", '"'), array(''', '"'), $text);
return $text;
}
$modulo = $_POST['modulo'];
$dbmodulo = $this->db->escape($modulo);
$mFECHA = date('Ymd', timestampFromInputDate($_POST['fecha'], 'd/m/Y'));
$mTABLA = $this->datasis->dameval("SELECT origen FROM reglascont WHERE modulo={$dbmodulo} AND regla=1 ");
$mCONTROL = $this->datasis->dameval("SELECT control FROM reglascont WHERE modulo={$dbmodulo} AND regla=1 ");
$action = "javascript:window.location='" . site_url("contabilidad/reglas/index/{$mFECHA}") . "'";
$data['content'] = '';
$query = $this->db->query("SELECT a.{$mCONTROL} FROM {$mTABLA} WHERE a.fecha={$mFECHA} GROUP BY {$mCONTROL} ");
foreach ($query->result_array() as $fila) {
$aregla = $this->_hace_regla($modulo, $mCONTROL, $fila[$mCONTROL]);
//echo '<pre>';print_r($aregla);'</pre>';
$encab = $encab_titu = $pivote = array();
//Construye los encabezados
foreach ($aregla['casi'] as $mSQL) {
$casi_query = $this->db->query($mSQL);
if ($casi_query->num_rows() > 0) {
$row = $casi_query->row();
$encab[$row->comprob] = array();
$encab_titu[$row->comprob] = '<b>Comprobante:</b> ' . $row->comprob . ' <b>Fecha:</b> ' . date('d/m/Y', timestampFromInputDate($row->fecha, 'Y-m-d')) . ' <b>Concepto:</b> ' . $row->concepto;
}
}
//echo $query;
//Construye la data de los encabezados
foreach ($aregla['itcasi'] as $mSQL) {
//echo $mSQL;
$itcasi_query = $this->db->query($mSQL);
$acumulador = array(0, 0);
if ($itcasi_query->num_rows() > 0) {
foreach ($itcasi_query->result() as $row) {
$pivote['origen'] = $row->clave;
$pivote['cuenta'] = $row->cuenta;
$pivote['referen'] = $row->referen;
$pivote['concepto'] = $row->concepto;
$pivote['debe'] = $row->debe;
$pivote['haber'] = $row->haber;
$pivote['sucursal'] = $row->sucursal;
$pivote['ccosto'] = $row->ccosto;
$pivote['msql'] = $mSQL;
$encab[$row->comprob][] = $pivote;
//$acumulador[0]+=$row->debe;
//$acumulador[1]+=$row->haber;
}
$pivote['origen'] = $pivote['cuenta'] = $pivote['referen'] = $pivote['concepto'] = $pivote['sucursal'] = '';
$pivote['debe'] = nformat($acumulador[0]);
$pivote['haber'] = nformat($acumulador[1]);
$pivote['diferencia'] = nformat($acumulador[0] - $acumulador[1]);
//$encab[$row->comprob][]=$pivote;
}
}
foreach ($encab as $comprob => $tabla) {
if (array_key_exists($comprob, $encab_titu)) {
$titulo = $encab_titu[$comprob];
} else {
$titulo = 'HUERFANO';
}
$grid = new DataGrid2($titulo, $tabla);
$grid->per_page = count($tabla);
$grid->use_function('dif', 'escasql');
//$grid->column('Orígen', 'msql');
$grid->column('Orígen', '<span title="<escasql><#msql#></escasql>" onclick="prompt(\'Consulta\',this.title)"><#origen#></span>');
$grid->column('Cuenta', 'cuenta');
$grid->column('Referencia', 'referen');
$grid->column('Concepto', 'concepto');
$grid->column('Debe', '<nformat><#debe#></nformat>', 'align=\'right\'');
$grid->column('Haber', '<nformat><#haber#></nformat>', 'align=\'right\'');
//$grid->column("Diferencia" , "<dif><#debe#>|<#haber#></dif>",'align=right');
$grid->column('Sucursal', 'sucursal', 'align=\'right\'');
$grid->column('C. Costo', 'ccosto', 'align=\'right\'');
$grid->totalizar('debe', 'haber');
$grid->build();
//echo $grid->db->last_query();
$data['content'] .= $grid->output;
}
}
$data['content'] .= HTML::button('regresa', RAPYD_BUTTON_BACK, $action, 'button', 'button');
$data['head'] = $this->rapyd->get_head();
$data['title'] = "<h1>Ejecución de la regla {$modulo}</h1>";
$this->load->view('view_ventanas', $data);
}
function resumen()
{
$this->rapyd->load('datagrid2', 'datafilter', 'datatable');
$form = new DataForm("finanzas/resumendiario/resumen/process");
$form->fecha = new dateonlyField("Fecha", "fecha");
$form->fecha->insertValue = date("Y-m-d");
$form->fecha->rule = "required|chfecha";
$form->fecha->size = 12;
$form->submit("btnsubmit", "Consultar");
$form->build_form();
if ($form->on_success()) {
$this->fecha = $form->fecha->newValue;
}
$dbfecha = $this->db->escape($this->fecha);
//***********************************
// RESUMEN DE CAJAS (RCAJ)
//***********************************
$grid = new DataGrid2("Resumen de Cajas");
$grid->db->select(array("cajero", "ingreso AS venta", "recibido", "(ingreso - recibido) AS diferencia"));
$grid->db->from("rcaj");
$grid->db->where("fecha", $this->fecha);
$grid->order_by("caja", "asc");
//$grid->per_page = 15;
$grid->column('Caja', 'cajero', "align='center'");
$grid->column('Venta', '<nformat><#venta#></nformat>', "align='right'");
$grid->column('Recibido', '<nformat><#recibido#></nformat>', "align='right'");
$grid->column('Diferencia', '<nformat><#diferencia#></nformat>', "align='right'");
$grid->totalizar("venta", "recibido", "diferencia");
$grid->build();
//***********************************
//DISTRIBUCION DE LA COBRANZA (SFPA)
//***********************************
$grid2 = new DataGrid2('Distribución de la cobranza');
$grid2->db->select(array('a.tipo', 'b.nombre', 'sum(a.monto) AS monto', 'COUNT(*) AS cantidad'));
$grid2->db->from('sfpa a');
$grid2->db->join('tarjeta b', 'a.tipo=b.tipo');
$grid2->db->where('f_factura', $this->fecha);
$grid2->db->groupby('a.tipo');
$grid2->order_by('a.tipo', 'asc');
//$grid2->per_page = 15;
$grid2->column('Tipo', '(<#tipo#>) <#nombre#>', "align='left'");
$grid2->column('Cantidad', 'cantidad', "align='right'");
$grid2->column('Monto', '<nformat><#monto#></nformat>', "align='right'");
$grid2->totalizar('monto');
$grid2->build();
//***********************************
// VENTAS Y DEVOLUCIONES
//***********************************
function vdnom($tipo_doc, $referen)
{
$nombre = $tipo_doc == 'D' ? 'Devoluciones ' : 'Ventas ';
$nombre .= $referen == 'E' ? 'al Contado' : 'a Credito';
return $nombre;
}
$grid3 = new DataGrid2("Distribución de la cobranza");
$grid3->db->select(array('tipo_doc', 'referen', 'COUNT(*) AS cana', 'SUM(totals)*IF(tipo_doc = "D" ,-1,1) AS monto'));
$grid3->db->from("sfac a");
$grid3->db->where('referen <>', 'P');
$grid3->db->where('fecha', $this->fecha);
$grid3->db->groupby('tipo_doc');
$grid3->db->groupby('referen');
$grid3->use_function('vdnom');
$grid3->column('Tipo', '<vdnom><#tipo_doc#>|<#referen#></vdnom>', "align='left'");
$grid3->column('Cantidad', '<nformat><#cana#>|0</nformat>', "align='right'");
$grid3->column('Monto', '<nformat><#monto#></nformat>', "align='right'");
$grid3->totalizar('monto');
$grid3->build();
//***********************************
// RESUMEN DE VENTAS
//***********************************
$udia = days_in_month(substr($this->fecha, 4, 2), substr($this->fecha, 0, 4));
$fdesde = substr($this->fecha, 0, 6) . '01';
$fhasta = substr($this->fecha, 0, 6) . $udia;
$ano = substr($this->fecha, 0, 4);
$row1 = $this->datasis->damerow("SELECT COUNT(*) AS a,SUM(totals*(IF(tipo_doc = 'F',1,-1))) AS b FROM sfac WHERE tipo_doc <>'X' AND YEAR(fecha) = {$ano} AND fecha < {$dbfecha}");
$row2 = $this->datasis->damerow("SELECT COUNT(*) AS a,SUM(totals*(IF(tipo_doc = 'F',1,-1))) AS b FROM sfac WHERE tipo_doc <>'X' AND fecha BETWEEN {$fdesde} AND {$fhasta}");
$row3 = $this->datasis->damerow("SELECT COUNT(*) AS a,SUM(totals*(IF(tipo_doc = 'F',1,-1))) AS b FROM sfac WHERE tipo_doc <>'X' AND fecha = {$dbfecha}");
$cost1 = $this->datasis->dameval("SELECT SUM(costo*cana*(IF(tipoa = 'F',1,-1))) AS a FROM sitems WHERE tipoa <>'X' AND YEAR(fecha) = {$ano} AND fecha < {$dbfecha}");
$cost2 = $this->datasis->dameval("SELECT SUM(costo*cana*(IF(tipoa = 'F',1,-1))) AS a FROM sitems WHERE tipoa <>'X' AND fecha BETWEEN {$fdesde} AND {$dbfecha}");
$cost3 = $this->datasis->dameval("SELECT SUM(costo*cana*(IF(tipoa = 'F',1,-1))) AS a FROM sitems WHERE tipoa <>'X' AND fecha = {$dbfecha}");
if (empty($row1)) {
$row1 = array('a' => 0, 'b' => 0);
}
if (empty($row2)) {
$row2 = array('a' => 0, 'b' => 0);
}
if (empty($row3)) {
$row3 = array('a' => 0, 'b' => 0);
}
$row1['c'] = $cost1;
$row2['c'] = $cost2;
$row3['c'] = $cost3;
$rdata[0] = array('a' => $row1['a'], 'b' => $row1['b'], 'c' => $row1['c'], 'd' => $row1['b'] - $row1['c'], 'razon' => 'Ventas en lo que va de año');
$rdata[1] = array('a' => $row2['a'], 'b' => $row2['b'], 'c' => $row2['c'], 'd' => $row2['b'] - $row2['c'], 'razon' => 'Ventas en lo que va de mes');
$rdata[2] = array('a' => $row3['a'], 'b' => $row3['b'], 'c' => $row3['c'], 'd' => $row3['b'] - $row3['c'], 'razon' => 'Ventas de hoy');
$grid8 = new DataGrid("Resumen de Ventas " . $this->fecha, $rdata);
$grid8->column("Razón", "razon");
$grid8->column("Cantidad", "a", "align='right'");
$grid8->column("Costo", "<nformat><#c#></nformat>", "align='right'");
$grid8->column("Monto", "<nformat><#b#></nformat>", "align='right'");
$grid8->column("Margen", "<nformat><#d#></nformat>", "align='right'");
$grid8->build();
$rdata = array();
//***********************************
// CUENTAS POR COBRAR (smov)
//***********************************
$grid4 = new DataGrid2('Cuentas por Cobrar');
$grid4->db->select(array("c.gr_desc grupo", "SUM((a.monto-a.abonos)*IF(tipo_doc='AN',-1,1))saldo"));
$grid4->db->from('smov a');
$grid4->db->join('scli b', 'a.cod_cli = b.cliente');
$grid4->db->join('grcl c', 'b.grupo = c.grupo');
$grid4->db->where("a.tipo_doc IN ('FC','ND','GI','AN')");
$grid4->db->groupby('c.gr_desc');
$grid4->order_by("c.gr_desc", "asc");
//$grid4->per_page = 15;
$grid4->column('Grupo de Clientes', 'grupo', "align='left'");
$grid4->column('Monto', '<nformat><#saldo#></nformat>', "align='right'");
$grid4->totalizar('saldo');
$grid4->build();
//***********************************
// GASTOS
//***********************************
$row = $this->datasis->dameval("SELECT SUM(montotot) AS a FROM scst WHERE tipo_doc = 'FC' AND recep = {$dbfecha}");
$row2 = $this->datasis->dameval("SELECT SUM(totbruto) AS a FROM gser WHERE tipo_doc = 'FC' AND fecha = {$dbfecha}");
$rdata[0] = array('nombre' => 'Total de Compras', 'monto' => $row);
$rdata[1] = array('nombre' => 'Total de Gastos', 'monto' => $row2);
$grid7 = new DataGrid2('Total Compras y Gastos de Hoy', $rdata);
$grid7->column('Razón', 'nombre');
$grid7->column('Monto', '<nformat><#monto#></nformat>', "align='right'");
$grid7->totalizar('monto');
$grid7->build();
//***********************************
// CUENTAS POR PAGAR (sprm)
//***********************************
$grid5 = new DataGrid2('Cuentas por Pagar');
$grid5->db->select(array('c.gr_desc grupo', "SUM((a.monto-a.abonos)*IF(tipo_doc = 'AN',-1,1)) saldo"));
$grid5->db->from('sprm a');
$grid5->db->join('sprv b', 'a.cod_prv = b.proveed');
$grid5->db->join('grpr c', 'b.grupo = c.grupo');
$grid5->db->where("a.tipo_doc IN ('FC','ND','GI','AN')");
$grid5->db->groupby('c.gr_desc');
$grid5->order_by('c.gr_desc', 'asc');
//$grid5->per_page = 15;
$grid5->column('Grupo de Proveedoores', 'grupo', "align='left'");
$grid5->column('Monto', '<nformat><#saldo#></nformat>', "align='right'");
$grid5->totalizar('saldo');
$grid5->build();
//***********************************
// PROMEDIO INVENTARIO (sinv)
//***********************************
$grid6 = new DataGrid2('Total de Inventario');
$grid6->db->select(array('d.descrip AS descrip', 'SUM(a.pond*a.existen) AS suma'));
$grid6->db->from('sinv a');
$grid6->db->join('grup b ', 'a.grupo = b.grupo');
$grid6->db->join('line c ', 'b.linea = c.linea');
$grid6->db->join('dpto d ', 'd.depto = c.depto');
$grid6->db->groupby('c.depto');
$grid6->db->order_by('d.descrip');
//$grid6->per_page = 15;
$grid6->column('Departamento', 'descrip', "align='left'");
$grid6->column('Monto', '<nformat><#suma#></nformat>', "align='right'");
$grid6->totalizar('suma');
$grid6->build();
$data['rcaj'] = $grid->output;
$data['sfpa'] = $grid2->output;
$data['tot'] = $grid3->output;
$data['resven'] = $grid8->output;
$data['smov'] = $grid4->output;
$data['scstgser'] = $grid7->output;
$data['sprm'] = $grid5->output;
$data['sinv'] = $grid6->output;
$data0['content'] = $form->output . $this->load->view('view_resumendiario', $data, TRUE);
$data0['head'] = $this->rapyd->get_head();
$data0['title'] = "<h1>" . $this->t**s . " para la fecha " . dbdate_to_human($this->fecha) . "</h1>";
$this->load->view('view_ventanas', $data0);
}
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ñ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ú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);
}
function verfactura($caja, $cajero, $fecha, $numero)
{
$this->rapyd->load('datagrid2');
$grid = new DataGrid2();
$grid->db->select = array('a.codigo', 'b.descrip', 'a.precio', 'a.monto', 'a.cantidad', 'a.impuesto');
$grid->db->from('vieite AS a');
$grid->db->join('maes AS b', 'a.codigo=b.codigo');
$grid->db->where('fecha', $fecha);
$grid->db->where('cajero', $cajero);
$grid->db->where('caja', $caja);
$grid->db->where('a.numero', $numero);
$grid->db->orderby('a.fecha, a.caja, a.numero');
$grid->column('Código', 'codigo');
$grid->column('Descripción', 'descrip');
$grid->column('Cantidad', 'cantidad', 'align="right"');
$grid->column('Precio', 'precio', 'align="right"');
$grid->column('Impuesto', 'impuesto', 'align="right"');
$grid->column('Total', 'monto', 'align="right"');
$grid->totalizar('monto');
$grid->build();
$back = anchor('supermercado/buscafac/index/search/osp', 'Regresar');
$data['content'] = $grid->output . $back;
$data['head'] = $this->rapyd->get_head();
$data['title'] = '<h1>Factura</h1>';
$this->load->view('view_ventanas', $data);
}
function gserchipros($codbanc = null)
{
if (empty($codbanc)) {
show_error('Faltan parametros');
}
$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) {
echo heading("Caja {$codbanc} no tiene gastos aprobados, debe primero aprobar algun gasto y luego si puede reponerla");
return false;
}
$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', 'datagrid2');
$modbus = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Codigo Proveedor', 'nombre' => 'Nombre', 'rif' => 'RIF'), 'filtro' => array('proveed' => 'Codigo Proveedor', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'codprv', 'nombre' => 'nombre'), 'titulo' => 'Buscar Proveedor', 'script' => array('post_modbus()'));
$bsprv = $this->datasis->modbus($modbus);
$script = 'var comis = ' . $json_comis . ';
$(document).ready(function() {
desactivacampo("");
$("#codprv").autocomplete({
source: function( req, add){
$.ajax({
url: "' . site_url('ajax/buscasprv') . '",
type: "POST",
dataType: "json",
data: {"q":req.term},
success:
function(data){
var sugiere = [];
if(data.length==0){
$("#nombre").val("");
$("#nombre_val").text("");
$("#codprv").val("");
}else{
$.each(data,
function(i, val){
sugiere.push( val );
}
);
}
add(sugiere);
},
})
},
minLength: 2,
select: function( event, ui ) {
$("#codprv").attr("readonly", "readonly");
$("#nombre").val(ui.item.nombre);
$("#nombre_val").text(ui.item.nombre);
$("#codprv").val(ui.item.proveed);
setTimeout(function(){ $("#codprv").removeAttr("readonly"); }, 1500);
}
});
desactivacampo($("#cargo").val());
});
function post_modbus(){
nombre=$("#nombre").val();
$("#nombre_val").text(nombre);
}
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");
}
}';
$pcchi = $this->datasis->damerow("SELECT proveed, nombre FROM sprv WHERE nombre LIKE '%CAJA%CHICA%' LIMIT 1");
$form = new DataForm($this->url . 'gserchipros/' . $codbanc . '/process');
$form->title("Número de facturas aceptadas {$r['cana']}, monto total <b>" . nformat($r['monto']) . '</b> para la caja ' . $codbanc);
$form->script($script);
$form->codprv = new inputField('Proveedor', 'codprv');
$form->codprv->rule = 'required';
$form->codprv->insertValue = $codprv;
$form->codprv->size = 8;
$form->codprv->append($bsprv);
$form->codprv->insertValue = empty($pcchi) ? '' : $pcchi['proveed'];
$form->nombre = new inputField('Nombre', 'nombre');
$form->nombre->rule = 'required';
$form->nombre->insertValue = $nombre;
$form->nombre->in = 'codprv';
$form->nombre->type = 'inputhidden';
$form->nombre->insertValue = empty($pcchi) ? '' : $pcchi['nombre'];
$dbcodban = $this->db->escape($codbanc);
$form->cargo = new dropdownField('Reponer desde', 'cargo');
$form->cargo->option('', 'Seleccionar');
$form->cargo->options("SELECT codbanc, CONCAT_WS('-',codbanc,banco) AS label FROM banc WHERE activo='S' AND codbanc<>{$dbcodban} ORDER BY codbanc");
$form->cargo->option($this->mcred, 'CREDITO');
$form->cargo->onchange = 'desactivacampo(this.value)';
$form->cargo->rule = 'max_length[5]|required';
$form->cheque = new inputField('Cheque Numero', 'cheque');
$form->cheque->rule = 'condi_required|callback_chobligaban';
//$form->cheque->append('Aplica si es un banco');
$form->cheque->group = 'Aplica si repone desde un Banco';
$form->cheque->size = 12;
$form->benefi = new inputField('Beneficiario', 'benefi');
$form->benefi->insertValue = $nombre;
$form->benefi->rule = 'condi_required|callback_chobligaban|strtoupper';
//$form->benefi->append('Aplica si es un banco');
$form->benefi->group = $form->cheque->group;
$form->build_form();
$grid = new DataGrid2("Lista de facturas aceptadas para pagar de la caja {$codbanc}", 'gserchi');
$select = array('exento + montasa + monadic + monredu + tasa + sobretasa + reducida AS totneto', 'descrip', 'tasa + sobretasa + reducida AS totiva', 'proveedor', 'fechafac', 'numfac', 'codbanc');
$grid->totalizar('totneto', 'totiva');
$grid->db->select($select);
$grid->db->where('aceptado', 'S');
$grid->db->where('ngasto IS NULL');
$grid->db->where('codbanc', $codbanc);
$grid->order_by('fechafac', 'desc');
$grid->per_page = 15;
//$grid->column('Caja','codbanc');
$grid->column('Número', 'numfac');
$grid->column('Fecha', '<dbdate_to_human><#fechafac#></dbdate_to_human>', 'align=\'center\'');
$grid->column('Proveedor', 'proveedor');
$grid->column('Descripción', 'descrip');
$grid->column('IVA', '<nformat><#totiva#></nformat>', 'align=\'right\'');
$grid->column('Monto', '<b><nformat><#totneto#></nformat></b>', '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);
if ($rt) {
$rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => array('id' => $this->idgser));
echo json_encode($rt);
} else {
$rt = array('status' => 'B', 'mensaje' => 'No se pudo guardar', 'pk' => '');
echo json_encode($rt);
}
} else {
echo $form->output . $grid->output;
}
}
function vista()
{
$this->rapyd->load("datagrid2");
$f1 = $this->input->post('fechad');
$f2 = $this->input->post('fechah');
$fechad = $this->db->escape(human_to_dbdate($f1));
$fechah = $this->db->escape(human_to_dbdate($f2));
$codigoadm = '';
$fondo = '';
$codigoadm2 = $this->db->escape($this->input->post('codigoadm'));
$fondo2 = $this->db->escape($this->input->post('fondo'));
function blanco($codigo)
{
if ($codigo > 0) {
$codigo = str_pad($codigo, 8, '0', STR_PAD_LEFT);
}
return $codigo;
}
function union($fecha, $codigo)
{
return date('Ym', strtotime($fecha)) . str_pad($codigo, 8, '0', STR_PAD_LEFT);
}
$uri = anchor($this->url . 'dataedit/show/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>');
//$cant = $this->datasis->dameval("SELECT COUNT(*)
//JOIN pades b ON a.numero = b.pago
//JOIN desem c ON b.desem = c.numero
//WHERE c.status='D2' AND reten >0 AND fdesem>=$fechad AND fdesem<= $fechah");
$query = "SELECT COUNT(*) FROM (";
$query .= "\r\n\t\tSELECT '',a.numero,a.impmunicipal,c.fdesem,factura,controlfac,fechafac,a.fmunicipal,c.cod_prov FROM odirect a \r\n\t\tJOIN pades b ON a.numero = b.pago\r\n\t\tJOIN desem c ON b.desem = c.numero\r\n\t\tJOIN sprv p ON c.cod_prov = p.proveed\r\n\t\tWHERE c.status='D2' AND impmunicipal >0 AND fdesem>={$fechad} AND fdesem<= {$fechah} AND MID(a.status,1,1)<>'F' AND (a.mmuni IS NULL) ";
if (!empty($codigoadm)) {
$query .= " AND a.estadmin='{$codigoadm}'";
}
if (!empty($fondo)) {
$query .= " AND a.fondo='{$fondo}'";
}
$query .= "\r\n\t\t)a ";
$cant = $this->datasis->dameval($query);
$this->db->query("DROP TABLE IF EXISTS MUNICIPAL");
$query = "\r\n\t\tCREATE TABLE MUNICIPAL SELECT * FROM (";
$query .= "\r\n\t\t\r\n\t\tSELECT a.numero,a.impmunicipal,c.fdesem,factura,controlfac,fechafac,a.fmunicipal,c.cod_prov,a.estadmin codigoadm,a.fondo FROM odirect a \r\n\t\tJOIN pades b ON a.numero = b.pago\r\n\t\tJOIN desem c ON b.desem = c.numero\r\n\t\tJOIN sprv p ON c.cod_prov = p.proveed\r\n\t\tWHERE c.status='D2' AND impmunicipal >0 AND fdesem>={$fechad} AND fdesem<= {$fechah} AND MID(a.status,1,1)<>'F' AND (a.mmuni IS NULL)";
if (!empty($codigoadm)) {
$query .= " AND a.estadmin='{$codigoadm}'";
}
if (!empty($fondo)) {
$query .= " AND a.fondo='{$fondo}'";
}
$query .= "\r\n\t\t)a JOIN sprv b ON a.cod_prov = b.proveed ";
$this->db->query($query);
$grid = new DataGrid2("Lista de " . $this->titp);
$grid->db->from("MUNICIPAL");
$grid->order_by("numero", "desc");
$grid->per_page = 1000;
$grid->use_function('substr', 'str_pad', 'blanco', 'union');
$grid->use_function('sta');
$grid->column("orden de Pago", "<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>");
$grid->column("O. Compra", "<blanco><#ocompra#>|8|0|STR_PAD_LEFT</blanco>");
$grid->column("Emision", "<dbdate_to_human><#fmunicipal#></dbdate_to_human>", "align='center'");
$grid->column("Factura", "factura");
$grid->column("Nro. Control", "controlfac");
$grid->column("Fecha Fac", "<dbdate_to_human><#fechafac#></dbdate_to_human>", "align='center'");
$grid->column("Proveedor", "nombre");
$grid->column("RIF", "rif");
$grid->column("Monto", "<number_format><#impmunicipal#>|2|,|.</number_format>", "align='right'");
$grid->column("Est. Admin", "codigoadm");
$grid->column("Fondo", "fondo");
$grid->totalizar('impmunicipal');
$grid->build();
//echo $grid->db->last_query();
//exit();
$campo = "\r\n \t\t<input size='100' type='hidden' name='fechad' value='{$f1}'>\r\n \t\t<input size='100' type='hidden' name='fechah' value='{$f2}'>\r\n \t\t<input size='100' type='hidden' name='cant' value='{$cant}'>\r\n \t\t<input size='100' type='hidden' name='codigoadm' value='{$codigoadm}'>\r\n \t\t<input size='100' type='hidden' name='fondo' value='{$fondo}'>\r\n \t\t";
$data['content'] = anchor($this->url . "nuevo", 'Ir atras') . $grid->output . form_open($this->url . 'guardar') . $campo . form_submit('mysubmit', 'Guardar') . form_close();
$data['title'] = " {$this->titp} ";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
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ñ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);
}
function filteredgrid()
{
function ractivo($estado, $numero)
{
if ($estado == 'R') {
$retorna = array('name' => $numero, 'id' => $estado, 'value' => 'accept', 'checked' => TRUE);
} else {
$retorna = array('name' => $numero, 'id' => $estado, 'value' => 'accept', 'checked' => FALSE);
}
return form_checkbox($retorna);
}
$this->rapyd->load("datafilter", "datagrid2");
$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 DataFilter("Filtro de Control de Tiket");
$select = array("a.id as idm", "a.sucursal", "a.asignacion", "a.idt as idt", "a.padre", "a.pertenece", "a.prioridad", "a.usuario as usuarios", "a.contenido", "a.estampa", "a.actualizado", "a.estado as testado", "IF(a.estado='N','Nuevo',IF(a.estado='R','Resuelto',IF(a.estado='P','Pendiente','En Proceso')))as estado", "b.id", "b.cliente as clientes", "b.ubicacion", "b.url", "b.basededato", "b.puerto", "b.puerto", "b.usuario", "b.clave", "b.observacion", "c.nombre", "a.minutos");
$filter->db->select($select);
$filter->db->from("tiketc AS a");
$filter->db->join("tiketconec AS b", "a.sucursal=b.id");
$filter->db->join("scli AS c", "b.cliente=c.cliente");
$filter->fechad = new dateonlyField("Fecha Desde", "fechad", 'd/m/Y');
$filter->fechad->clause = "where";
$filter->fechad->db_name = "estampa";
$filter->fechad->operator = ">=";
$filter->fechad->size = 12;
$filter->fechah = new dateonlyField("Fecha Hasta", "fechah", 'd/m/Y');
$filter->fechah->clause = "where";
$filter->fechah->db_name = "estampa";
$filter->fechah->operator = "<=";
$filter->fechah->size = 12;
$filter->estado = new dropdownField("Estado", "estado");
$filter->estado->option("", "Todos");
$filter->estado->options($this->estado);
$filter->prioridad = new dropdownField("Prioridad", "prioridad");
$filter->prioridad->option("", "Todos");
$filter->prioridad->options($this->prioridad);
$filter->contenido = new inputField("Contenido", "contenido");
//$filter->contenido->clause ="likesensitive";
//$filter->contenido->append("Sencible a las Mayuscúlas");
$filter->asignacion = new dropdownField("Asignacion", "asignacion");
$filter->asignacion->option("", "Todos");
$filter->asignacion->options("SELECT codigo, codigo as value FROM tiketservi");
$filter->asignacion->style = "width:150px";
$filter->cliente = new inputField("Cliente", "cliente");
$filter->cliente->size = 20;
$filter->cliente->db_name = "c.cliente";
$filter->cliente->append($boton);
$filter->idt = new inputField("Numero", "idt");
$filter->idt->size = 20;
$filter->idt->db_name = "idt";
$filter->buttons("reset", "search");
$filter->build();
$grid = new DataGrid2("Lista de Control de Tiket");
$grid->order_by("a.id", "desc");
$grid->per_page = 10;
$link = anchor("supervisor/tiketc/dataedit/modify/<#idm#>", "<#idm#>");
$grid->use_function('ractivo');
$grid->column("Id", $link);
$grid->column("Resuelto", "<ractivo><#testado#>|<#idm#></ractivo>", 'align="center"');
$grid->column("Numero tiket", "idt");
$grid->column("Fecha de Ingreso", "<dbdate_to_human><#estampa#>|d/m/Y h:m:s</dbdate_to_human>");
$grid->column("Cliente", "nombre");
$grid->column("Usuario", "usuarios");
$grid->column("Contenido", "contenido");
$grid->column("Prioridad", "prioridad");
//$grid->column("Estado","estado");
$grid->column("Asignacion", "asignacion");
$grid->column("Tiempo", "minutos");
//$grid->column("URL","url");
//$resp=anchor("http://merida.matloca.com/proteoerp/supervisor/tiket/dataedit/pertenece/<#idt#>/create"", 'IR');
$resp = '<a href="http://<#url#>/proteoerp/supervisor/tiket/dataedit/pertenece/<#idt#>/create">Ir</a>';
//$resp='http://merida.matloca.com/proteoerp/supervisor/tiket/dataedit/pertenece/67/create';
$grid->column("Responder", $resp);
$grid->totalizar('minutos');
//$grid->add("supervisor/tiketc/dataedit/create");
$grid->build();
//echo $grid->db->last_query();
$script = '';
$url = site_url('supervisor/tiketc/activar');
$data['script'] = '<script type="text/javascript">
$(document).ready(function() {
$("form :checkbox").click(function () {
$.ajax({
type: "POST",
url: "' . $url . '",
data: "numero="+this.name+"&estado="+this.id,
success: function(msg){
//alert(msg);
}
});
}).change();
});
</script>';
$data['content'] = $filter->output . form_open('') . $grid->output . form_close() . $script;
$data['title'] = "<h1>Ticket de Clientes</h1>";
$data["head"] = script("jquery-1.2.6.pack.js");
$data["head"] .= script("plugins/jquery.checkboxes.pack.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
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ñ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);
}
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ñ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ó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);
}
function diarias($anio = '', $concep = '', $mes = '')
{
$this->rapyd->load("datagrid2");
$this->rapyd->load("dataform");
$this->load->helper('openflash');
if (isset($_POST['anio']) and empty($anio)) {
$anio = $_POST['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('supermercado/bancos/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ño", "anio");
$filter->anio->in = 'mes';
$filter->anio->size = 4;
$filter->anio->insertValue = $anio;
$filter->anio->maxlength = 4;
$filter->concep = new dropdownField("Banco", "concep");
$filter->concep->options("SELECT codbanc, banco FROM banc GROUP BY codbanc ORDER BY codbanc");
$filter->concep->insertValue = $concep;
$filter->concep->style = "width:200px";
$filter->button("btnsubmit", "Buscar", form2uri(site_url('supermercado/bancos/diarias'), array('anio', 'concep', 'mes')), $position = "BL");
$filter->build_form();
$grid = new DataGrid2();
$select = array("a.fecha", "a.concep", "b.nombre", "DATE_FORMAT(fecha,'%d') AS dia", "SUM(a.monto)AS grantotal", "SUM(a.transac)AS transacciones");
$grid->db->select($select);
$grid->db->from("est_pago as a");
$grid->db->join("banc as b", "a.concep=b.codbanc");
$grid->db->where('fecha >= ', $fechai);
$grid->db->where('fecha <= ', $fechaf);
$grid->db->where('a.concep', $concep);
$grid->db->groupby("fecha");
$grid->db->orderby("dia 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("Cant.Transac", "transacciones", 'align=right');
$grid->totalizar('grantotal');
$grid->build();
$grafico = open_flash_chart_object(680, 350, site_url("supermercado/bancos/gdiarias/{$anio}/{$concep}/{$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);
}
