function filteredgrid() { $this->rapyd->load("datafilter", "datagrid"); $atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '0', 'screeny' => '0'); $filter = new DataFilter("Filtro de Busqueda", 'sitemslog'); $filter->fechad = new dateonlyField("Desde", "fechad", 'd/m/Y'); $filter->fechah = new dateonlyField("Hasta", "fechah", 'd/m/Y'); $filter->fechad->clause = $filter->fechah->clause = "where"; $filter->fechad->db_name = $filter->fechah->db_name = "fecha"; $filter->fechad->size = $filter->fechah->size = 12; $filter->fechad->insertValue = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d") - 30, date("Y"))); $filter->fechah->insertValue = date("Y-m-d"); $filter->fechad->operator = ">="; $filter->fechah->operator = "<="; $filter->cajero = new dropdownField("Cajero", "cajero"); $filter->cajero->option('', 'Todos'); $filter->cajero->options("Select cajero, nombre as value from scaj "); $filter->cajero->style = 'width:150px;'; $filter->vendedor = new dropdownField("Vendedor", "vendedor"); $filter->vendedor->option('', 'Todos'); $filter->vendedor->options("Select vendedor, nombre from vend "); $filter->vendedor->style = 'width:150px;'; $filter->buttons("reset", "search"); $filter->build(); if ($this->rapyd->uri->is_set("search") and $filter->is_valid()) { $grid = new DataGrid("Resultados"); $grid->per_page = 15; $uri = anchor_popup('supervisor/sitemslog/detalle/<#id#>', '<#id#>', $atts); $grid->column("Numero", $uri); $grid->column("Fecha", "<b><dbdate_to_human><#fecha#></dbdate_to_human></b>", 'fecha', "align='center'"); $grid->column("Cajero", "cajero"); $grid->column("Vendedor", "vendedor"); $grid->column("Tipo", "tipo"); $grid->column("Cliente", "cod_cli"); $grid->column("Hora", "<#hora#>", 'hora', "align='center'"); $grid->build(); //echo $grid->db->last_query(); $tabla = $grid->output; } else { $tabla = ''; } $data['content'] = $filter->output . $tabla; $data['title'] = "<h1>Log de Ventas</h1>"; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function filteredgrid() { $this->rapyd->load("datafilter", "datagrid"); $filter = new DataFilter("Filtro de Busqueda", 'logusu'); //$filter->db->select(array()); $filter->usuario = new dropdownField("Usuario", "usuario"); $filter->usuario->option('', 'Todos'); $filter->usuario->options("Select usuario, usuario as value from logusu group by usuario"); $filter->usuario->style = 'width:150px;'; $filter->fechad = new dateonlyField("Desde", "fechad", 'd/m/Y'); $filter->fechah = new dateonlyField("Hasta", "fechah", 'd/m/Y'); $filter->fechad->clause = $filter->fechah->clause = "where"; $filter->fechad->db_name = $filter->fechah->db_name = "fecha"; $filter->fechad->size = $filter->fechah->size = 12; $filter->fechad->insertValue = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d") - 30, date("Y"))); $filter->fechah->insertValue = date("Y-m-d"); $filter->fechad->operator = ">="; $filter->fechah->operator = "<="; $filter->modulo = new inputField("Módulo", "modulo"); $filter->modulo->size = 6; $filter->referencia = new inputField("Referencia", "comenta"); $filter->referencia->size = 60; $filter->buttons("reset", "search"); $filter->build(); if ($this->rapyd->uri->is_set("search") and $filter->is_valid()) { $grid = new DataGrid("Resultados"); $grid->per_page = 15; $grid->column_orderby("Usuario", "usuario", 'usuario'); $grid->column_orderby("Fecha", "<b><dbdate_to_human><#fecha#></dbdate_to_human></b>", 'fecha', "align='center'"); $grid->column_orderby("Hora", "<#hora#>", 'hora', "align='center'"); $grid->column_orderby("Módulo", "modulo", 'modulo'); $grid->column_orderby("Acción", "comenta", 'comenta'); $grid->build(); //echo $grid->db->last_query(); $tabla = $grid->output; } else { $tabla = ''; } $data['content'] = $filter->output . $tabla; $data['title'] = "<h1>Log de Usuarios</h1>"; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
$bool = $this->db->query("CREATE TABLE PRENOM{$contra} SELECT * FROM {$tabla}"); if ($bool) { echo "_Si"; } } function montos() { $this->rapyd->load('datagrid', 'fields', 'datafilter'); $error = ''; if ($this->input->post('pros') !== FALSE) { $concepto = $this->input->post('concepto'); $conceptoe = $this->db->escape($concepto); $pmontos = $this->input->post('monto'); //$this->load->library('pnomina'); $formula = $this->datasis->dameval("SELECT formula FROM conc WHERE concepto={$conceptoe}"); foreach ($pmontos as $cod => $cant) { if (!is_numeric($cant)) { $error .= "{$cant} no es un valor num&erico;rico<br>"; } else { $this->actualizaprenom($cod, $cant, $concepto, $formula); $this->calculaprenom(false, $cod); } } } $filter = new DataFilter(" ", 'prenom'); $filter->error_string = $error; $filter->concepto = new dropdownField("Concepto", "concepto"); $filter->concepto->option("", "Seleccionar"); $filter->concepto->options("SELECT concepto,CONCAT_WS(' ',concepto,descrip) descrip FROM prenom WHERE formula like '%XMONTO%' GROUP BY concepto ORDER BY descrip"); $filter->concepto->clause = "where"; $filter->concepto->operator = "="; $filter->concepto->rule = "required"; $filter->buttons("reset", "search"); $filter->build(); $ggrid = ''; if ($filter->is_valid()) { $ggrid = form_open('/nomina/prenom/montos/search/osp'); $ggrid .= form_hidden('concepto', $filter->concepto->newValue); $monto = new inputField("Monto", "monto"); $monto->grid_name = 'monto[<#codigo#>]'; $monto->status = 'modify'; $monto->size = 12; $monto->css_class = 'inputnum'; $grid = new DataGrid("Concepto (" . $filter->concepto->newValue . ") " . $filter->concepto->options[$filter->concepto->newValue]); $grid->column("Código", "codigo"); $grid->column("Nombre", "nombre"); $grid->column("Monto", $monto, 'align=\'right\''); $grid->column("Valor", 'valor', 'align=\'right\''); $grid->submit('pros', 'Guardar', "BR"); $grid->build(); $ggrid .= $grid->output; $ggrid .= form_close(); } $script = ' <script type="text/javascript"> $(function() { $(".inputnum").numeric("."); }); </script>'; $data['content'] = $filter->output . anchor('nomina/prenom', 'Inicio') . $ggrid;
function filteredgrid() { $this->rapyd->load('datafilter', 'datagrid'); $filter = new DataFilter('Filtro de Búsqueda', 'sitemslog'); $filter->fechad = new dateonlyField('Rango de Fechas', 'fechad', 'd/m/Y'); $filter->fechah = new dateonlyField('Hasta', 'fechah', 'd/m/Y'); $filter->fechad->clause = $filter->fechah->clause = 'where'; $filter->fechad->db_name = $filter->fechah->db_name = 'fecha'; $filter->fechad->size = $filter->fechah->size = 12; //$filter->fechad->insertValue = date("Y-m-d",mktime(0, 0, 0, date("m"), date("d")-1, date("Y"))); $filter->fechad->insertValue = date('Y-m-d'); $filter->fechah->insertValue = date('Y-m-d'); $filter->fechad->operator = '>='; $filter->fechah->operator = '<='; $filter->fechah->in = 'fechad'; $filter->cajero = new dropdownField('Cajero', 'cajero'); $filter->cajero->option('', 'Todos'); $filter->cajero->options('SELECT cajero, nombre AS value FROM scaj ORDER BY cajero'); $filter->cajero->style = 'width:150px;'; $filter->vendedor = new dropdownField('Vendedor', 'vendedor'); $filter->vendedor->option('', 'Todos'); $filter->vendedor->options('SELECT vendedor, nombre FROM vend ORDER BY vendedor'); $filter->vendedor->style = 'width:150px;'; $filter->numero = new inputField('Número', 'numero'); $filter->numero->size = 15; $filter->numero->maxlength = 15; $filter->descrip = new inputField('Descripción', 'desca'); $filter->usuario = new dropdownField('Usuario', 'usuario'); $filter->usuario->option('', 'Todos'); $filter->usuario->options('SELECT us_codigo,CONCAT_WS(\'-\',us_codigo,us_nombre) AS val FROM usuario ORDER BY us_codigo'); $filter->usuario->style = 'width:150px;'; $filter->tipo = new dropdownField('Operación', 'tipo'); $filter->tipo->option('', 'Todos'); $filter->tipo->option('ABORTADO', 'ABORTADO'); $filter->tipo->option('AGREGA', 'AGREGA'); $filter->tipo->option('ELIMINADO', 'ELIMINADO'); $filter->tipo->option('MODIFICA', 'MODIFICA'); $filter->tipo->style = 'width:150px;'; $filter->buttons('reset', 'search'); $filter->build(); if ($this->rapyd->uri->is_set('search') and $filter->is_valid()) { $grid = new DataGrid('Resultados'); $grid->per_page = 15; $grid->column_orderby('Operación', 'tipo', 'tipo', 'align=\'left\''); $grid->column_orderby('Numero', '<b><#tipoa#><#numa#></b>', 'numa', 'align=\'left\''); $grid->column_orderby('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human> <#hora#>', 'fecha', 'align=\'center\''); $grid->column_orderby('Código', 'codigoa', 'codigoa', 'align=\'left\''); $grid->column_orderby('Descripción', 'desca', 'desca', 'align=\'left\''); $grid->column_orderby('Cantidad', '<nformat><#cana#></nformat>', 'cana', 'align=\'right\''); $grid->column_orderby('Precio', '<format><#preca#></nformat>', 'preca', 'align=\'right\''); $grid->column_orderby('Total', '<nformat><#tota#></nformat>', 'tota', 'align=\'right\''); $grid->column_orderby('Vendedor', 'vendedor', 'vendedor', 'align=\'center\''); $grid->column_orderby('Cajero', 'cajero', 'cajero', 'align=\'center\''); $grid->column_orderby('Usuario', 'usuario', 'usuario'); $grid->build(); $tabla = $grid->output; $sq = preg_replace('/LIMIT +[0-9]+[, ]*[0-9]*/', '', $grid->db->last_query()); $sq = raencode(base64_encode($this->encrypt->encode($sq))); $tabla .= anchor('xlsauto/repo64/' . $sq, 'Descargar a Excell'); } else { $tabla = ''; } $data['content'] = $filter->output . $tabla; $data['title'] = heading('Bitácora de Facturación'); $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function montos() { $this->rapyd->load('datagrid', 'fields', 'datafilter'); /*$this->load->library('form_validation'); if ($this->form_validation->run() == FALSE){ $this->load->view('myform'); }else{ $this->load->view('formsuccess'); }*/ $error = ''; if ($this->input->post('pros') !== FALSE) { $concepto = $this->db->escape($this->input->post('concepto')); $pmontos = $this->input->post('monto'); foreach ($pmontos as $cod => $cant) { $cod = $this->db->escape($cod); if (!is_numeric($cant)) { $error .= "{$cant} no es un valor numerico<br>"; } else { $data = array('monto' => $cant); $where = "codigo = {$cod} AND concepto ={$concepto} "; $mSQL = $this->db->update_string('prenom', $data, $where); $this->db->simple_query($mSQL); } } } $filter = new DataFilter(" ", 'prenom'); $filter->error_string = $error; $filter->concepto = new dropdownField("Concepto", "concepto"); $filter->concepto->option("", "Seleccionar"); $filter->concepto->options("SELECT concepto,descrip FROM prenom GROUP BY concepto ORDER BY descrip"); $filter->concepto->clause = "where"; $filter->concepto->operator = "="; $filter->concepto->rule = "required"; $filter->buttons("reset", "search"); $filter->build(); $ggrid = ''; if ($filter->is_valid()) { $ggrid = form_open('/nomina/prenom/montos/search/osp'); $ggrid .= form_hidden('concepto', $filter->concepto->newValue); $monto = new inputField("Monto", "monto"); $monto->grid_name = 'monto[<#codigo#>]'; $monto->status = 'modify'; $monto->size = 12; $monto->css_class = 'inputnum'; $grid = new DataGrid("Concepto (" . $filter->concepto->newValue . ") " . $filter->concepto->options[$filter->concepto->newValue]); //$grid->db->where('concepto','015'); //$grid->per_page = $filter->db->num_rows() ; $grid->column("Código", "codigo"); $grid->column("Nombre", "nombre"); $grid->column("Monto", $monto, 'align=\'right\''); $grid->submit('pros', 'Guardar', "BR"); $grid->build(); $ggrid .= $grid->output; $ggrid .= form_close(); } $script = ' <script type="text/javascript"> $(function() { $(".inputnum").numeric("."); }); </script>'; $data['content'] = $filter->output . $ggrid; $data['title'] = '<h1>Asignación de montos</h1>'; $data['script'] = $script; $data["head"] = $this->rapyd->get_head() . script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js"); $this->load->view('view_ventanas', $data); }
function copia($usua = null) { $this->rapyd->load("datafilter", "datagrid"); $usuario = $usua; function ractivo($acceso, $codigo) { if ($acceso == 'S') { $retorna = form_checkbox($codigo, 'accept', TRUE); } else { $retorna = form_checkbox($codigo, 'accept', FALSE); } return $retorna; } $filter = new DataFilter(""); $filter->db->select(array("b.modulo", 'b.codigo', "a.usuario", "a.usuario as value", "a.acceso", "b.titulo")); $filter->db->from("sida AS a"); $filter->db->join("tmenus AS b", "a.modulo=b.codigo"); $filter->db->orderby("b.modulo"); $filter->usuario = new dropdownField("Copiar de", "usuario"); $filter->usuario->options("Select us_codigo as value,CONCAT_WS(' - ', us_codigo, us_nombre) as codigo from usuario group by us_codigo"); $filter->usuario->style = 'width:250px;'; $filter->buttons("reset", "search"); $filter->build(); if ($this->rapyd->uri->is_set("search") and $filter->is_valid()) { $usr = $filter->usuario->newValue; $mSQL = "INSERT IGNORE INTO sida SELECT '{$usr}',b.codigo,'N' FROM sida AS a RIGHT JOIN tmenus AS b ON a.modulo=b.codigo AND a.usuario='{$usr}' WHERE a.modulo IS NULL"; $this->db->simple_query($mSQL); $copiar = anchor("supervisor/acdatasis/copiar/{$usr}/{$usuario}", 'Copiar'); $grid = new Datagrid("Resultados"); $grid->use_function('ractivo'); $link = site_url('/supervisor/acdatasis/activar'); //$grid->per_page = 15; $grid->column("Módulo", "modulo"); $grid->column("Nombre", "titulo"); $grid->column("Acceso", "<ractivo><#acceso#>|<#codigo#>|</ractivo>", 'align="center"'); $grid->build(); $tabla = $copiar . $grid->output; //echo $grid->db->last_query(); $url = site_url('supervisor/acdatasis/activar'); $data['script'] = '<script type="text/javascript"> $(document).ready(function() { $("form :checkbox").click(function () { usr=$("#usuario").attr("value"); $.ajax({type: "POST", url: "' . $url . '", data: "codigo="+this.name+"&usuario="+usr, success: function(msg){ if (msg==0) alert("Ocurrio un problema"); } }); }).change(); }); </script>'; } else { $tabla = ''; } $data['content'] = ' Usuario:' . $usuario . $filter->output . form_open('') . $tabla . form_close(); $data['title'] = "<h1>Copiar Accesos de Usuario en DataSIS</h1>"; $data["head"] = script("jquery.js") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function index() { $this->rapyd->load('datafilter', 'datagrid'); $link = site_url('supervisor/sfacfiscal/arreglaserial'); $linkd = site_url('supervisor/sfacfiscal/arreglaserialdev'); $link2 = site_url('supervisor/sfacfiscal/arreglanfiscal'); $link4 = site_url('supervisor/sfacfiscal/arreglanfiscaldev'); $link3 = site_url('supervisor/sfacfiscal/traereferen'); $jquery = ' function riega(id){ if(confirm("Esta seguro que regar el serial para las facturas?")){ if(confirm("Desea cambiar solo los registros vacios?")) resp=0; else resp=1; $.post("' . $link . '",{ cajero:$("#cajero").val(),fecha:$("#fecha").val(), serial:id ,noresp:resp, nulos:$("#nulos").val(),usuario:$("#usuario").val()}, function(data){ alert(data); }); } } function riegadev(id){ if(confirm("Esta seguro que regar el serial por las devoluciones?")){ if(confirm("Desea cambiar solo los registros vacios?")) resp=0; else resp=1; $.post("' . $linkd . '",{ cajero:$("#cajero").val(),fecha:$("#fecha").val(), serial:id ,noresp:resp, nulos:$("#nulos").val(),usuario:$("#usuario").val()}, function(data){ alert(data); }); } } function nfiscal(id){ if(confirm("Esta seguro que regar el numero fiscal?")){ if(confirm("Desea cambiar solo los registros vacios?")) resp=0; else resp=1; $.post("' . $link2 . '",{ cajero:$("#cajero").val(),fecha:$("#fecha").val(), numero:id ,noresp:resp, nulos:$("#nulos").val(),usuario:$("#usuario").val()}, function(data){ alert(data); }); } } function nfiscaldev(id){ if(confirm("Esta seguro que regar el numero fiscal?")){ if(confirm("Desea cambiar solo los registros vacios?")) resp=0; else resp=1; $.post("' . $link4 . '",{ cajero:$("#cajero").val(),fecha:$("#fecha").val(), numero:id ,noresp:resp, nulos:$("#nulos").val(),usuario:$("#usuario").val()}, function(data){ alert(data); }); } } function buscaref(){ referenc = prompt("Introduce una referencia"); $.post("' . $link3 . '",{ referen: referenc }, function(data){ alert(data); }); }'; function exissinv($cen, $t, $tipo_doc) { if (!empty($cen)) { if ($t == 1) { if ($tipo_doc == 'F') { $rt = form_button('asignar', $cen, 'onclick="riega(\'' . $cen . '\');"'); } else { $rt = form_button('asignar', $cen, 'onclick="riegadev(\'' . $cen . '\');"'); } } else { if ($tipo_doc == 'F') { $rt = form_button('asignar', $cen, 'onclick="nfiscal(\'' . $cen . '\');"'); } else { $rt = form_button('asignar', $cen, 'onclick="nfiscaldev(\'' . $cen . '\');"'); } } } else { $rt = '--'; } return $rt; } $atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '0', 'screeny' => '0'); $filter = new DataFilter('', 'sfac'); //$filter->db->where('tipo_doc','F'); $filter->script($jquery); $filter->fecha = new dateonlyField('Desde', 'fecha'); $filter->fecha->clause = 'where'; $filter->fecha->db_name = 'fecha'; $filter->fecha->insertValue = date('Y-m-d'); $filter->fecha->operator = '='; $filter->fecha->rule = 'required|chfecha'; $filter->fecha->append("<a onclick='buscaref()'>Traer de referencia</a>"); $filter->cajero = new dropdownField('Cajero', 'cajero'); $filter->cajero->option('', 'Seleccionar'); $filter->cajero->option(' ', 'Creditos'); $filter->cajero->options('SELECT cajero, CONCAT_WS("-",cajero,nombre) FROM scaj ORDER BY cajero'); $filter->usuario = new dropdownField('Usuario', 'usuario'); $filter->usuario->option('', 'Todos'); $filter->usuario->options('SELECT us_codigo AS cod,us_codigo FROM usuario ORDER BY us_codigo'); $filter->usuario->rule = 'condi_required|callback_chusuario'; $filter->tipo_doc = new dropdownField('Tipo Doc.', 'tipo_doc'); $filter->tipo_doc->option('F', 'Facturas'); $filter->tipo_doc->option('D', 'Devoluciones'); $filter->tipo_doc->rule = 'required|enum[D,F]'; $filter->nulos = new dropdownField('Filtrar seriales nulos', 'nulos'); $filter->nulos->option('s', 'Si'); $filter->nulos->option('n', 'No'); $filter->nulos->clause = ''; $filter->nulos->group = 'No afecta el filtro'; $filter->nulos->append('Si se activa esta opcion no se riega el número en los campos donde el serial de la máquina fiscal es nulo'); $filter->nulos->rule = 'enum[s,n]'; $filter->buttons('reset', 'search'); $filter->build(); if ($this->rapyd->uri->is_set('search') && $filter->is_valid()) { $fecha = $filter->fecha->newValue; $dbfecha = $this->db->escape($fecha); $fields = $this->db->field_data('sfac'); $ppk = array(); foreach ($fields as $field) { if ($field->primary_key == 1) { $ppk[] = '<#' . $field->name . '#>'; } } $llink = anchor('supervisor/sfacfiscal/editsfac/modify/' . implode('/', $ppk), '<#tipo_doc#><#numero#>'); $uri2 = anchor_popup('formatos/verhtml/FACTURA/<#tipo_doc#>/<#numero#>', 'Ver HTML', $atts); $grid = new DataGrid(''); $grid->use_function('exissinv'); $grid->per_page = 30; $grid->db->orderby('numero'); $grid->column('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>', 'fecha'); $grid->column('Nombre', 'nombre'); $grid->column('Referencia', $llink); $grid->column('Usuario', 'usuario'); $grid->column('Cajero', 'cajero'); $grid->column('Monto', '<nformat><#totalg#></nformat>', 'align="right"'); $grid->column('N.Fiscal', '<exissinv><#nfiscal#>|2|<#tipo_doc#></exissinv>', 'align="center"'); $grid->column('Serial Maq.', '<exissinv><#maqfiscal#>|1|<#tipo_doc#></exissinv>', 'align="center"'); $grid->column('Ver factura', $uri2, 'align="center"'); $grid->build(); //echo $grid->db->last_query(); $mSQL = $grid->db->last_query(); $mSQL = str_replace('*', 'SUM(totalg)', $mSQL); $corte = stripos($mSQL, 'ORDER'); if ($corte !== false) { $mSQL = substr($mSQL, 0, $corte); } $monto = $this->datasis->dameval($mSQL); $tabla = 'Monto: ' . nformat($monto) . $grid->output; $mSQL = 'SELECT COUNT(*) AS cana,serial, MAX(factura) AS factura,MAX(ncnumero) AS ncnumero,SUM(exento+base+iva+base1+iva1+base2+iva2-ncexento-ncbase-nciva-ncbase1-nciva1-ncbase2-nciva2) AS total FROM fiscalz WHERE fecha=' . $dbfecha . ' GROUP BY serial'; $query = $this->db->query($mSQL); foreach ($query->result() as $row) { $tabla .= $row->serial . ' x' . $row->cana . ' - F' . $row->factura . ' - D' . $row->ncnumero . ' - ' . nformat($row->total) . br(); } } else { $tabla = '<div class="alert">' . $filter->error_string . '</div>'; } //if(strlen($filter->error_string)) $data['error']=$filter->error_string; $data['content'] = $filter->output . $tabla; $data['title'] = '<h1>Arreglos de consistencias fiscal en facturas</h1>'; $data['head'] = $this->rapyd->get_head() . script('jquery.js'); $this->load->view('view_ventanas', $data); }
function montos() { $this->rapyd->load('datagrid', 'fields', 'datafilter'); $error = ''; if ($this->input->post('pros') !== false) { $concepto = $this->db->escape($this->input->post('concepto')); $pmontos = $this->input->post('monto'); $this->load->library('pnomina'); $formula = $this->datasis->dameval("SELECT formula FROM conc WHERE concepto={$concepto}"); foreach ($pmontos as $cod => $cant) { if (!is_numeric($cant)) { $error .= "{$cant} no es un valor numérico<br>"; } else { $this->pnomina->CODIGO = $cod; $this->pnomina->MONTO = $cant; //$valor=0; $valor = $this->pnomina->evalform($formula); $cod = $this->db->escape($cod); $data = array('monto' => $cant, 'valor' => $valor); $where = "codigo = {$cod} AND concepto ={$concepto} "; $mSQL = $this->db->update_string('prenom', $data, $where); $this->db->simple_query($mSQL); } } } $filter = new DataFilter(' ', 'prenom'); $filter->error_string = $error; $filter->concepto = new dropdownField('Concepto', 'concepto'); $filter->concepto->option('', 'Seleccionar'); $filter->concepto->options("SELECT concepto,descrip FROM prenom GROUP BY concepto ORDER BY descrip"); $filter->concepto->clause = 'where'; $filter->concepto->operator = '='; $filter->concepto->rule = 'required'; $filter->buttons('reset', 'search'); $filter->build(); $ggrid = ''; if ($filter->is_valid()) { $ggrid = form_open('/nomina/prenom/montos/search/osp'); $ggrid .= form_hidden('concepto', $filter->concepto->newValue); $monto = new inputField('Monto', 'monto'); $monto->grid_name = 'monto[<#codigo#>]'; $monto->status = 'modify'; $monto->size = 12; $monto->css_class = 'inputnum'; $grid = new DataGrid("Concepto (" . $filter->concepto->newValue . ") " . $filter->concepto->options[$filter->concepto->newValue]); $grid->column('Código', 'codigo'); $grid->column('Nombre', 'nombre'); $grid->column('Monto', $monto, 'align=\'right\''); $grid->column('Valor', 'valor', 'align=\'right\''); $grid->submit('pros', 'Guardar', 'BR'); $grid->build(); $ggrid .= $grid->output; $ggrid .= form_close(); } $script = ' <script type="text/javascript"> $(function() { $(".inputnum").numeric("."); }); </script>'; $data['content'] = $filter->output . $ggrid; $data['title'] = '<h1>Asignación de montos</h1>'; $data['script'] = $script; $data['head'] = $this->rapyd->get_head() . script('jquery.pack.js') . script('plugins/jquery.numeric.pack.js') . script('plugins/jquery.floatnumber.js'); $this->load->view('view_ventanas', $data); }
function index() { //SELECT * FROM bmov //WHERE codbanc='01' AND EXTRACT(YEAR_MONTH FROM fecha)<=201004 AND anulado!='S' AND liable!='N' AND //(concilia=0 OR EXTRACT(YEAR_MONTH FROM concilia)>=20100430 OR concilia<fecha) $this->rapyd->load('datafilter', 'datagrid'); $filter = new DataFilter(''); $filter->db->from('bmov'); $filter->db->where('anulado !=', 'S'); $filter->db->where('liable !=', 'N'); $filter->mes = new dropdownField('Fecha', 'mes'); $filter->mes->clause = ''; $filter->mes->rule = 'required'; $filter->mes->style = 'width:50px'; for ($i = 1; $i <= 12; $i++) { $mmes = str_pad($i, 2, '0', STR_PAD_LEFT); $filter->mes->option($mmes, $mmes); } $filter->anio = new inputField('Año', 'anio'); $filter->anio->rule = 'required'; $filter->anio->clause = ''; $filter->anio->in = 'mes'; $filter->anio->size = 5; $filter->banco = new dropdownField('Banco', 'codbanc'); $filter->banco->rule = 'required'; $filter->banco->clause = 'where'; $filter->banco->option('', 'Seleccionar'); $filter->banco->options('SELECT codbanc AS CLAVE, banco FROM banc WHERE CHAR_LENGTH(tbanco)>0 ORDER BY banco'); $filter->banco->operator = '='; $filter->tipo_op = new dropdownField('Tipo de Operacion', 'tipo_op'); $filter->tipo_op->option('', 'Todos'); $filter->tipo_op->option('NC', 'Nota de Crédito'); $filter->tipo_op->option('ND', 'Nota de Debito'); $filter->tipo_op->option('DE', 'Deposito'); /*$filter->concilia = new dropdownField('Conciliado', 'concilia'); $filter->concilia->option('','Todos'); $filter->concilia->option('S','Si'); $filter->concilia->option('N','No');*/ //$filter->submit('btnsubmit','Descargar'); $filter->buttons('search'); $filter->build(); if ($this->rapyd->uri->is_set('search') and $filter->is_valid()) { function conci($conci, $codbanc, $tipo_op, $numero, $fecha) { $fech = explode('-', $conci); $arr = array($codbanc, $tipo_op, $numero, $fecha); if ($fech[0] + $fech[1] + $fech[2] == 0) { return form_checkbox($codbanc . $tipo_op . $numero, serialize($arr)); } else { return form_checkbox($codbanc . $tipo_op . $numero, serialize($arr), TRUE) . dbdate_to_human($conci); } } $fecha = $filter->anio->newValue . $filter->mes->newValue . days_in_month($filter->mes->newValue); $grid = new DataGrid('Efectos por conciliar'); $grid->use_function('conci'); $grid->order_by('fecha', 'desc'); $grid->per_page = 15; $grid->column_orderby('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>', 'fecha', 'align=\'center\''); $grid->column_orderby('Numero', 'numero', 'numero'); $grid->column_orderby('Descripción', 'nombre', 'nombre'); $grid->column_orderby('Monto', '<nformat><#monto#></nformat>', 'monto', 'align=\'right\''); $grid->column_orderby('Conciliado', "<conci><#concilia#>|<#codbanc#>|<#tipo_op#>|<#numero#>|{$fecha}</conci>", 'concilia', 'align=\'center\''); $grid->build(); //echo $grid->db->last_query(); $ggrid = $grid->output; } else { $ggrid = ''; } $data['content'] = $filter->output . $ggrid; $data['title'] = '<h1>Conciliaciones de Bancos</h1>'; $data['script'] = '<script language="javascript" type="text/javascript">'; $data['script'] .= ' $(document).ready(function(){ $(":checkbox").change(function(){ name=$(this).attr("name"); $.post("' . site_url('finanzas/conci/cconci') . '",{ data: $(this).val()}, function(data){ if(data=="1"){ return true; }else{ $("input[name=\'"+name+"\']").removeAttr("checked"); alert("Hubo un error, comuniquese con soporte tecnico"); return false; } }); }); });'; $data['script'] .= '</script>'; $data['head'] = $this->rapyd->get_head() . script('jquery.js'); $this->load->view('view_ventanas', $data); }
function filteredgrid() { $this->rapyd->load('datafilter', 'datagrid2'); function convierte($par, $link) { $atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '5', 'screeny' => '5', 'style' => 'text-decoration:none;font-weight: bold;font-size:0.85em;color:#2357B5'); switch ($par) { case '3I': return anchor_popup($link, 'Ventas Caja', $atts); break; case '3R': return anchor_popup($link, 'Ventas Restaurante', $atts); break; case '3M': return anchor_popup($link, 'Ventas Mayor', $atts); break; case '1T': return anchor_popup($link, 'Transferencias', $atts); break; case '2C': return anchor_popup($link, 'Compras', $atts); break; case '4N': return anchor_popup($link, 'Nota/Entrega', $atts); break; case '6C': return anchor_popup($link, 'Conversión', $atts); break; case '5C': return anchor_popup($link, 'Ajuste', $atts); break; case '5D': return anchor_popup($link, 'Consignación', $atts); break; case '0F': return anchor_popup($link, 'Inventario', $atts); break; case '9F': return anchor_popup($link, 'Inventario', $atts); break; default: return $par; } } function colorgal($par) { switch ($par) { case '3I': return '( 0,163, 0, 0.4)'; break; case '3R': return '( 0,163, 0, 0.4)'; break; case '3M': return '( 0,163, 0, 0.4)'; break; case '1T': return '(255, 34, 5, 0.4)'; break; case '2C': return '(183, 84, 35, 0.4)'; break; case '4N': return '( 17, 19,148, 0.4)'; break; case '6C': return '( 0, 0, 0, 0.4)'; break; case '5C': return '( 65,185,255, 0.4)'; break; case '5D': return '(144, 0,255, 0.4)'; break; case '0F': return '(255,221, 0, 0.4)'; break; case '9F': return '(255,221, 0, 0.4)'; break; default: return '(255,255,255, 0.4)'; } } $modbus = array('tabla' => 'sinv', 'columnas' => array('codigo' => 'Código', 'descrip' => 'Descripción', 'precio1' => 'Precio 1', 'precio2' => 'Precio 2', 'precio3' => 'Precio 3', 'precio4' => 'Precio 4'), 'filtro' => array('codigo' => 'Código', 'descrip' => 'Descripción'), 'retornar' => array('codigo' => 'codigo'), 'titulo' => 'Buscar en inventario'); $boton = $this->datasis->modbus($modbus); $maxfecha = $this->datasis->dameval("SELECT MAX(fecha) AS fecha FROM costos"); if (!empty($maxfecha)) { $corte = ' corte: <b>' . dbdate_to_human($maxfecha) . '</b>'; } else { $corte = ''; } $filter = new DataFilter('Kardex de Inventario ' . $corte); //$script= '$(function(){ $("#kardextabla").columnHover(); });'; //$filter->script($script); $filter->codigo = new inputField('Código ', 'codigo'); $filter->codigo->db_name = 'a.codigo'; $filter->codigo->rule = 'required'; $filter->codigo->operator = '='; $filter->codigo->size = 25; $filter->codigo->clause = 'where'; $filter->codigo->append($boton); $filter->codigo->group = 'UNO'; $filter->ubica = new dropdownField('Almacén', 'ubica'); $filter->ubica->option('', 'Todos'); $filter->ubica->db_name = 'a.ubica'; $filter->ubica->options("SELECT ubica,CONCAT(ubica,' ',ubides) descrip FROM caub WHERE gasto='N'"); $filter->ubica->operator = '='; $filter->ubica->clause = 'where'; $filter->ubica->group = 'UNO'; $filter->origen = new dropdownField('Orígen', 'origen'); $filter->origen->option('', 'Todos'); $filter->origen->option('3I', 'Ventas Caja'); $filter->origen->option('3R', 'Ventas Restaurante'); $filter->origen->option('3M', 'Ventas Mayor'); $filter->origen->option('1T', 'Transferencias'); $filter->origen->option('2C', 'Compras'); $filter->origen->option('4N', 'Nota/Entrega'); $filter->origen->option('6C', 'Conversión'); $filter->origen->option('5C', 'Ajuste de inventario'); $filter->origen->option('5D', 'Consignación'); $filter->origen->option('0F', 'Inv. FÃsico comienzo del dÃa'); $filter->origen->option('9F', 'Inv. FÃsico final del dÃa'); //$filter->origen->style = 'width:120px'; $filter->origen->group = 'UNO'; $filter->fechad = new dateonlyField('Desde', 'fecha', 'd/m/Y'); $filter->fechad->operator = '>='; $filter->fechad->insertValue = date('Y-m-d', mktime(0, 0, 0, date('m'), date('d') - 30, date('Y'))); $filter->fechad->group = 'DOS'; $filter->fechah = new dateonlyField('Hasta', 'fechah', 'd/m/Y'); $filter->fechah->db_name = 'fecha'; $filter->fechah->operator = '<='; $filter->fechah->insertValue = date('Y-m-d'); $filter->fechah->group = 'DOS'; $filter->fechah->clause = $filter->fechad->clause = $filter->codigo->clause = 'where'; $filter->fechah->size = $filter->fechad->size = 10; $filter->fechah->rule = $filter->fechad->rule = 'required|chfecha'; $filter->buttons('reset', 'search'); $filter->build('dataformfiltro'); $data['filtro'] = $filter->output; $code = $this->input->post('codigo'); $data['content'] = ''; $cana = 0; if ($code && $filter->is_valid()) { $dbcode = $this->db->escape($code); $mSQL = "SELECT CONCAT_WS(' ',TRIM(descrip),TRIM(descrip2)) descrip,existen,activo FROM sinv WHERE codigo={$dbcode}"; $query = $this->db->query($mSQL); if ($query->num_rows() > 0) { $row = $query->row(); $descrip = $row->descrip; $activo = $row->activo; $existen = floatval($row->existen); $actual = $this->datasis->dameval("SELECT SUM(existen) AS cana FROM itsinv WHERE codigo={$dbcode}"); if (floatval($actual) != $existen) { $this->db->simple_query("UPDATE sinv SET existen={$actual} WHERE codigo={$dbcode}"); } } else { $activo = 'N'; $descrip = 'No encontrado.'; $existen = 0; } $link = "/inventario/kardex/grid/<#origen#>/<dbdate_to_human><#fecha#>|Ymd</dbdate_to_human>/<raencode><#codigo#></raencode>/<raencode><#ubica#></raencode>"; $grid = new DataGrid2("Producto: ({$code}) {$descrip}"); $grid->table_id = 'kardextabla'; $grid->agrupar(' ', 'almacen'); $grid->use_function('convierte', 'str_replace', 'colorgal'); $grid->db->select(array('IFNULL( b.ubides , a.ubica ) almacen', 'a.ubica', 'a.fecha', 'a.venta', 'a.cantidad', 'a.saldo', 'a.monto', 'a.salcant', 'TRIM(a.codigo) AS codigo', 'a.origen', 'a.promedio', '(a.venta/a.cantidad)*(a.cantidad>0) AS vpromedio', 'ROUND(100-(a.promedio*100/(a.venta/a.cantidad)),2)*(a.origen="3I") AS vmargen', '((a.venta/a.cantidad)-a.promedio)*a.cantidad*(a.origen="3I") AS vutil', 'c.activo', 'c.grupo')); $grid->db->from('costos a'); $grid->db->join('caub b', 'b.ubica=a.ubica', 'LEFT'); $grid->db->join('sinv c', 'a.codigo=c.codigo', 'LEFT'); $grid->db->orderby('almacen, fecha, origen'); $grid->per_page = 60; $grid->column('Orígen', '<p style="background-color: rgba<colorgal><#origen#></colorgal>;font-size:1.3em;font-weight: bold;margin:0px;padding:0px;border:0px;"><convierte><#origen#>|' . $link . '</convierte></p>', 'align=\'left\' nowrap'); $grid->column('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>'); $grid->column('Cantidad', '<nformat><#cantidad#></nformat>', 'align=\'right\''); $grid->column('<b style="color:#FFFFFF">Acumulado</b>', '<b style="font-size:1.3em"><nformat><#salcant#></nformat></b>', 'align=\'right\''); $grid->column('Monto', '<nformat><#monto#></nformat>', 'align=\'right\''); $grid->column('Saldo', '<nformat><#saldo#></nformat>', 'align=\'right\''); $grid->column('Costo Prom.', '<nformat><#promedio#></nformat>', 'align=\'right\''); $grid->column('Ventas', '<nformat><#venta#></nformat>', 'align=\'right\''); $grid->column('Precio Prom.', '<nformat><#vpromedio#></nformat>', 'align=\'right\''); $grid->column('Margen %', '<nformat><#vmargen#></nformat>', 'align=\'right\''); $grid->column('Margen Bs.', '<nformat><#vutil#></nformat>', 'align=\'right\''); $grid->build(); $data['content'] = '<h4 style="text-align:center;padding:0px;margin:0px;">Movimiento comprendido desde la fecha <b style="color:#000000; font-size:1.2em">' . $filter->fechad->value . '</b> Hasta <b style="color:#000000; font-size:1.2em">' . $filter->fechah->value . '</b></h4>'; $data['content'] .= $grid->output; $ffinal = $this->datasis->dameval("SELECT MAX(fecha) AS fecha FROM costos WHERE codigo={$dbcode}"); if (!empty($ffinal)) { $dbfinal = $this->db->escape($ffinal); $ventas = $this->datasis->dameval("SELECT SUM(IF(tipoa='D',-1,1)*cana) AS cana FROM sitems WHERE codigoa={$dbcode} AND fecha>{$dbfinal} AND MID(numa,1,1)<>'_' AND tipoa IN ('F','D')"); $compras = $this->datasis->dameval("SELECT SUM(IF(b.tipo_doc='ND',-1,1)*a.cantidad) AS cana FROM itscst AS a JOIN scst AS b ON a.control=b.control WHERE a.codigo={$dbcode} AND b.actuali>=b.fecha AND b.recep>{$dbfinal}"); $nentreg = $this->datasis->dameval("SELECT SUM(a.cana) AS cana FROM itsnte AS a JOIN snte AS b ON a.numero=b.numero WHERE a.codigo={$dbcode} AND estampa>{$dbfinal}"); $ajustes = $this->datasis->dameval("SELECT SUM(IF(b.tipo='E',1,-1)*cantidad) AS cana FROM itssal AS a JOIN ssal AS b ON a.numero = b.numero WHERE a.codigo = {$dbcode} AND b.fecha>{$dbfinal}"); $conver = $this->datasis->dameval("SELECT SUM(a.entrada-a.salida) AS cana FROM itconv AS a JOIN conv AS b ON a.numero = b.numero WHERE a.codigo = {$dbcode} AND b.fecha>{$dbfinal}"); if ($this->db->table_exists('itscon')) { $consi = $this->datasis->dameval("SELECT SUM(IF(tipod='E',-1,1)*a.cana) AS cana FROM itscon AS a JOIN scon AS b ON a.id_scon=b.id WHERE a.codigo = {$dbcode} AND b.fecha>{$dbfinal}"); } else { $consi = 0; } $ventas = empty($ventas) ? htmlnformat(0) : htmlnformat($ventas); $compras = empty($compras) ? htmlnformat(0) : htmlnformat($compras); $nentreg = empty($nentreg) ? htmlnformat(0) : htmlnformat($nentreg); $actual = empty($actual) ? htmlnformat(0) : htmlnformat($actual); $ajustes = empty($ajustes) ? htmlnformat(0) : htmlnformat($ajustes); $conver = empty($conver) ? htmlnformat(0) : htmlnformat($conver); $consi = empty($consi) ? htmlnformat(0) : htmlnformat($consi); if ($activo == 'S') { $sactivo = '<span style=\'font-size:0.7em;color:green;\'>ACTIVO</span>'; } else { $sactivo = '<span style=\'font-size:0.7em;color:red;\'>INACTIVO</span>'; } $optadd = '<div style="">'; $optadd .= ' <table>'; $optadd .= ' <tr><td colspan=\'5\'><b style="text-size:1.4em;font-weight:bold;">Movimientos posteriores a la fecha ' . dbdate_to_human($ffinal) . ' para todos los almacenes</b></td></tr>'; $optadd .= " <tr><td>Ventas </td><td style='text-align:right' ><b> {$ventas}</b></td><td style='padding-left:50px;'>Ajustes </td><td style='text-align:right' ><b>{$ajustes}</b></td><td rowspan='3' style='text-align:center'>Existencia actual <p style='font-size:2em;padding:0 0 0 0;margin: 0 0 0 0;font-weight:bold;'>{$actual}</p>{$sactivo}</td></tr>"; $optadd .= " <tr><td>Compras </td><td style='text-align:right' ><b>{$compras}</b></td><td style='padding-left:50px;'>Conversiones </td><td style='text-align:right' ><b> {$conver}</b></td></tr>"; $optadd .= " <tr><td>N.Entrega</td><td style='text-align:right' ><b>{$nentreg}</b></td><td style='padding-left:50px;'>Consignaciones</td><td style='text-align:right' ><b> {$consi}</b></td></tr>"; $optadd .= ' </table>'; $optadd .= '</div>'; } else { $optadd = ''; } $data['content'] .= $optadd; //echo $grid->db->last_query(); $cana = $grid->recordCount; } if ($cana <= 0) { $data['content'] .= '<script type="text/javascript"> $(function(){ $("#cajafiltro").show(); }); </script>'; } $data['forma'] = ''; $data['script'] = script('jquery.js') . '<style type="text/css">#kardextabla tr:hover { background-color: #ffff99; }</style>'; //$data['script'].= script('plugins/jquery.columnhover.pack.js'); $data['title'] = heading('Kardex de Inventario'); $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function almainconsis() { $this->rapyd->load("datafilter", "datagrid"); $filter = new DataFilter("Clientes inconsistentes"); $filter->fechad = new dateonlyField('Desde', 'fechad'); $filter->fechah = new dateonlyField('Hasta', 'fechah'); $filter->fechad->clause = $filter->fechah->clause = "where"; $filter->fechad->db_name = $filter->fechah->db_name = "fecha"; $filter->fechad->insertValue = date("Y-m-d"); $filter->fechah->insertValue = date("Y-m-d"); $filter->fechad->operator = ">="; $filter->fechah->operator = "<="; $filter->buttons("reset", "search"); $filter->build(); if ($this->rapyd->uri->is_set("search") and $filter->is_valid()) { $fechah = $filter->fechah->newValue; $fechad = $filter->fechad->newValue; $alma = $this->datasis->dameval("SELECT a.ubica FROM (`costos` as a) LEFT JOIN `caub` AS b ON `a`.`ubica`=`b`.`ubica` WHERE `b`.`ubica` = 'NULL' AND `origen` = '3I' AND a.fecha >= '{$fechad}' AND a.fecha <= '{$fechah}'"); //echo $alma; $uri = anchor('supervisor/mantenimiento/cambioalma/modify/<#tipo_doc#>/<#numero#>', 'Cambio'); $grid = new DataGrid('Almacenes inconsistentes'); $select = array('a.fecha', 'a.numero', 'a.cod_cli', 'a.tipo_doc', 'a.totalg', 'a.almacen'); $grid->db->select($select); $grid->db->from('sfac as a'); $grid->db->where("a.almacen", $alma); $grid->db->where("a.fecha >= ", $fechad); $grid->db->where("a.fecha <=", $fechah); $grid->per_page = 15; $grid->column('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>', 'fecha'); $grid->column('Numero', 'numero'); $grid->column('Cliente', 'cod_cli'); $grid->column('Tipo', 'tipo_doc'); $grid->column('Monto', 'totalg'); $grid->column('Almacen', 'almacen'); $grid->column('Realizar', $uri); $grid->build(); //echo $grid->db->last_query(); //memowrite($grid->db->last_query()); $tabla = $grid->output; } else { $tabla = ''; } $data['content'] = $filter->output . $tabla; $data['title'] = "<h1>Almacenes con problemas de incosistencias</h1>"; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function filteredgrid() { //$this->datasis->modulo_id(35,1); $this->rapyd->load("datafilter", "datagrid"); //$this->rapyd->uri->keep_persistence(); $where = 'activo = "S"'; $mf = $this->datasis->puede(333); $mo = $this->datasis->puede(334); if ($mf && $mo) { } elseif ($mf) { $where .= ' AND tipocta="F"'; } elseif ($mo) { $where .= ' AND tipocta<>"F"'; } $mBANC = array('tabla' => 'banc', 'columnas' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'numcuent' => 'Cuenta', 'saldo' => 'Saldo'), 'filtro' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'saldo' => 'Saldo', 'numcuent' => 'Cuenta'), 'retornar' => array('codbanc' => 'codbanc', 'banco' => 'nombreb'), 'where' => $where, 'titulo' => 'Buscar Bancos'); $bBANC = $this->datasis->p_modbus($mBANC, "banc"); $filter = new DataFilter(""); $filter->db->from("mbancnoc a"); $filter->id = new inputField("Número", "id"); $filter->id->db_name = "a.id"; $filter->id->size = 10; $filter->cheque = new inputField("Cheque", "cheque"); $filter->cheque->db_name = "a.cheque"; $filter->cheque->size = 10; $filter->fecha = new dateonlyField("Fecha", "fecha"); $filter->fecha->dbformat = "Y-m-d"; $filter->fecha->size = 12; $filter->fconcilia = new dateonlyField("F. Conciliado", "fconcilia"); $filter->fconcilia->dbformat = "Y-m-d"; $filter->fconcilia->size = 12; $filter->codbanc = new inputField("Banco", 'codbanc'); $filter->codbanc->size = 6; $filter->codbanc->append($bBANC); $filter->monto = new inputField("Monto", 'monto'); $filter->monto->size = 6; $filter->benefi = new inputField("A nombre de", 'benefi'); $filter->benefi->size = 20; $filter->tipo_doc = new dropdownField("Tipo Doc", "tipo_doc"); $filter->tipo_doc->option("", ""); $filter->tipo_doc->option("ND", "Nota de Debito"); $filter->tipo_doc->option("NC", "Nota de Credito"); $filter->tipo_doc->option("CH", "Cheque"); $filter->tipo_doc->option("DP", "Deposito"); $filter->vnoc = new dropdownField("Ver", "vnoc"); $filter->vnoc->clause = " "; $filter->vnoc->db_name = " "; $filter->vnoc->option('', 'TODOS'); $filter->vnoc->option('S', 'CONCILIADOS'); $filter->vnoc->option('N', 'NO CONCILIADOS'); $filter->buttons("reset", "search"); $filter->build(); $uri = anchor($this->url . 'dataedit/show/<#id#>', '<str_pad><#id#>|8|0|STR_PAD_LEFT</str_pad>'); $uri2 = anchor($this->url . 'fconci/modify/<#id#>', 'Conciliar'); if ($filter->is_valid()) { $q1 = $filter->db->_compile_select(); $vnoc = $filter->vnoc->newValue; $q = "SELECT todo.* FROM ("; $q .= $q1; $q .= ")todo"; if ($vnoc == 'S') { $q .= " WHERE fconcilia IS NOT NULL"; } if ($vnoc == 'N') { $q .= " WHERE fconcilia IS NULL"; } $qa = $this->db->query($q); $qa = $qa->result_array($qa); $grid = new DataGrid("No Contabilizados", $qa); $grid->order_by("id", "desc"); $grid->per_page = 20; $grid->use_function('substr', 'str_pad'); $grid->column_orderby("Número", $uri, "numero"); $grid->column_orderby("Cheque", "cheque", "cheque"); $grid->column_orderby("Tipo", "tipo_doc", "tipo_doc"); $grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'"); $grid->column_orderby("Banco", "codbanc", "fecha", "align='center'"); $grid->column_orderby("Monto", "<nformat><#monto#>|2|,|.</nformat>", "monto", "align='right'"); $grid->column_orderby("F. Conciliado", "<dbdate_to_human><#fconcilia#></dbdate_to_human>", "fconcilia", "align='center'"); $grid->column_orderby("Conciliar", $uri2, "id"); $grid->add($this->url . "dataedit/create"); $grid->build(); $ggrid = $grid->output; } else { $ggrid = ''; } //$data['content'] = $filter->output.$grid->output; $data['filtro'] = $filter->output; $data['content'] = $ggrid; $data['script'] = script("jquery.js") . "\n"; $data['title'] = "{$this->titp}"; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function index() { $this->load->library('PDFReporte2'); $this->rapyd->load("datafilter"); $repo = $this->uri->segment(3); $esta = $this->uri->segment(4); //************************** $filter = new DataFilter("Filtro del Reporte"); $filter->attributes = array('onsubmit' => 'is_loaded()'); $filter->db->select("fecha, numero, tipo_op,concepto, (tipo_op NOT IN ('CH','ND'))*monto as debitos, (tipo_op IN ('CH','ND'))*monto as creditos,' ' as grupo"); $filter->db->from('bmov as a'); $filter->db->join('banc as b', 'a.codbanc=b.codbanc'); $filter->db->orderby('fecha'); $filter->fecha = new dateonlyField("Desde", "fechad", 'm/Y'); $filter->fecha->clause = 'where'; $filter->fecha->db_name = "EXTRACT(YEAR_MONTH FROM fecha)"; $filter->fecha->insertValue = date("Y-m-d"); $filter->fecha->operator = "="; $filter->fecha->dbformat = 'Ym'; $filter->fecha->size = 7; $filter->fecha->append(' mes/año'); $filter->fecha->rule = "required"; $filter->banco = new dropdownField("Caja/Banco", "codbanc"); $filter->banco->db_name = "a.codbanc"; $filter->banco->option("", ""); $filter->banco->options("SELECT codbanc, banco FROM bmov ORDER BY banco "); $filter->banco->rule = "required"; $filter->buttons("search"); $filter->build(); if ($this->rapyd->uri->is_set("search") and $filter->is_valid()) { $mSQL = $filter->db->_compile_select(); //echo $mSQL; $mSALDOANT = $this->datasis->dameval("SELECT SUM(IF(tipo_op IN ('CH', 'ND'),-1,1)*monto) AS saldo FROM bmov WHERE EXTRACT(YEAR_MONTH FROM fecha) <" . $filter->fecha->newValue . " AND codbanc = '" . $filter->banco->newValue . "'"); $mSALDOACT = 0; $sobretabla = ''; if (!empty($filter->banco->newValue)) { $sobretabla .= 'Banco: ' . $filter->banco->newValue; } $pdf = new PDFReporte2($mSQL); $pdf->setHeadValores('TITULO1'); $pdf->setSubHeadValores('TITULO2', 'TITULO3'); $pdf->setTitulo("Estado de Cuenta"); $pdf->setSobreTabla($sobretabla); $pdf->setSubTitulo("Para la fecha: " . $this->input->post('fechad')); $pdf->AddPage(); $pdf->setTableTitu(8, 'Times'); $pdf->AddCol('fecha', 20, 'Fecha', 'L', 8); $pdf->AddCol('numero', 25, 'Número', 'L', 8); $pdf->AddCol('tipo_op', 15, 'Tipo Op', 'L', 8); $pdf->AddCol('concepto', 70, 'Concepto', 'L', 8); $pdf->AddCol('debitos', 30, 'Débitos', 'R', 8); $pdf->AddCol('creditos', 30, 'Créditos', 'R', 8); $pdf->setTotalizar('debitos', 'creditos'); $pdf->setGrupoLabel("<#grupo#>Saldo Anterior: {$mSALDOANT}, Saldo Actual: {$mSALDOACT}"); $pdf->setGrupo('grupo'); $pdf->Table(); $pdf->Output(); } else { if (strlen($filter->error_string)) { $data["error"] = $filter->error_string; } $data["filtro"] = $filter->output; $data["titulo"] = '<h2 class="mainheader">Estado de Cuenta<h2>'; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_freportes', $data); } //************************** //************************** }
function filteredgrid() { $this->rapyd->load('datafilter', 'datagrid2'); $atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '5', 'screeny' => '5'); function convierte($par, $link) { $atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '5', 'screeny' => '5'); switch ($par) { case '3I': return anchor_popup($link, 'Ventas Caja', $atts); break; case '3M': return anchor_popup($link, 'Ventas Mayor', $atts); break; case '1T': return anchor_popup($link, 'Transferencias', $atts); break; case '2C': return anchor_popup($link, 'Compras', $atts); break; case '4N': return anchor_popup($link, 'Nota/Entrega', $atts); break; case '6C': return 'Conversiones'; break; case '5A': return 'Ajustes'; break; case '0F': return 'Inventario'; break; case '9F': return 'Inventario'; break; default: return $par; } } $modbus = array('tabla' => 'maes', 'columnas' => array('codigo' => 'Código', 'descrip' => 'Descripción', 'precio1' => 'Precio 1', 'precio2' => 'Precio 2', 'precio3' => 'Precio 3', 'precio4' => 'Precio 4', 'precio5' => 'Precio 5'), 'filtro' => array('codigo' => 'Código', 'descrip' => 'Descripción'), 'retornar' => array('codigo' => 'codigo'), 'titulo' => 'Buscar en inventario'); $boton = $this->datasis->modbus($modbus); $maxfecha = $this->datasis->dameval("SELECT MAX(fecha) AS fecha FROM costos"); if (!empty($maxfecha)) { $corte = ' corte: <b>' . dbdate_to_human($maxfecha) . '</b>'; } else { $corte = ''; } $filter = new DataFilter('Kardex de Inventario (' . anchor_popup('/supermercado/lfisico', 'Resumen de inventarios', $atts) . ') ' . $corte); $filter->codigo = new inputField('Código de Producto', 'codigo'); $filter->codigo->size = '10'; $filter->codigo->rule = 'required'; $filter->codigo->append($boton); $filter->codigo->group = 'UNO'; $filter->ubica = new dropdownField('Almacén', 'ubica'); $filter->ubica->option('', 'Todos'); $filter->ubica->db_name = 'a.ubica'; $filter->ubica->options("SELECT ubica,CONCAT(ubica,' ',ubides) descrip FROM caub WHERE gasto='N' "); $filter->ubica->operator = '='; $filter->ubica->clause = 'where'; $filter->ubica->group = 'UNO'; $filter->fechad = new dateonlyField('Desde', 'fecha', 'd/m/Y'); $filter->fechad->operator = '>='; $filter->fechad->insertValue = date('Y-m-d', mktime(0, 0, 0, date('m'), date('d') - 30, date('Y'))); $filter->fechad->group = 'DOS'; $filter->fechah = new dateonlyField('Hasta', 'fechah', 'd/m/Y'); $filter->fechah->db_name = 'fecha'; $filter->fechah->operator = '<='; $filter->fechah->insertValue = date('Y-m-d'); $filter->fechah->group = 'DOS'; $filter->fechah->clause = $filter->fechad->clause = $filter->codigo->clause = 'where'; $filter->fechah->rule = $filter->fechad->rule = 'required|chfecha'; $filter->fechah->size = $filter->fechad->size = 10; $filter->buttons('reset', 'search'); $filter->build('dataformfiltro'); $data['content'] = $filter->output; $code = $this->input->post('codigo'); if ($code && $filter->is_valid()) { $dbcode = $this->db->escape($code); $mSQL = "SELECT descrip FROM maes WHERE codigo={$dbcode}"; $ffinal = $this->datasis->dameval("SELECT MAX(fecha) AS fecha FROM costos WHERE codigo={$dbcode}"); $query = $this->db->query($mSQL); $descrip = ''; if ($query->num_rows() > 0) { $row = $query->row(); $descrip = trim($row->descrip); //$activo =trim($row->activo); $actual = $this->datasis->dameval("SELECT SUM(cantidad) AS cana FROM ubic WHERE codigo={$dbcode}"); $fracci = $this->datasis->dameval("SELECT SUM(fraccion) AS cana FROM ubic WHERE codigo={$dbcode}"); } else { //$activo =''; } $link = "/supermercado/kardex/grid/<#origen#>/<dbdate_to_human><#fecha#>|Ymd</dbdate_to_human>/<str_replace>/|:slach:|<#codigo#></str_replace>/<#ubica#>"; $grid = new DataGrid2("({$code}) {$descrip}"); $grid->agrupar('Almacén: ', 'almacen'); $grid->use_function('convierte', 'number_format', 'str_replace'); $grid->db->select("IFNULL( b.ubides , a.ubica ) almacen,a.ubica ,a.fecha, a.venta, a.cantidad, a.saldo, a.monto, a.salcant, a.codigo, a.origen, a.promedio"); $grid->db->from('costos a'); $grid->db->join('caub b ', 'b.ubica=a.ubica', 'LEFT'); $grid->db->orderby('almacen, fecha, origen'); $grid->per_page = 20; $grid->column('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>'); $grid->column('Orígen', "<convierte><#origen#>|{$link}</convierte>", 'align=left'); $grid->column('Cantidad', '<nformat><#cantidad#></nformat>', 'align=right'); $grid->column('Acumulado', '<nformat><#salcant#></nformat>', 'align=right'); $grid->column('Monto', '<nformat><#monto#></nformat>', 'align=right'); $grid->column('Saldo', '<nformat><#saldo#></nformat>', 'align=right'); $grid->column('Costo Prom.', '<nformat><#promedio#></nformat>', 'align=right'); $grid->column('Ventas', '<nformat><#venta#></nformat>', 'align=right'); $grid->build(); $data['content'] .= $grid->output; //echo $grid->db->last_query(); } if (!empty($ffinal)) { $dbfinal = $this->db->escape($ffinal); $mayor = $this->datasis->dameval("SELECT SUM(cantidad) AS cana FROM itfmay WHERE codigo={$dbcode} AND fecha>{$dbfinal}"); $ventas = $this->datasis->dameval("SELECT SUM(cantidad) AS cana FROM positfact WHERE codigo={$dbcode} AND fecha>{$dbfinal}"); $compras = $this->datasis->dameval("SELECT SUM(IF(b.tipo_doc='ND',-1,1)*a.cantidad) AS cana FROM itscst AS a JOIN scst AS b ON a.control=b.control WHERE a.codigo={$dbcode} AND b.actuali>=b.fecha AND b.actuali>{$dbfinal}"); $nentreg = $this->datasis->dameval("SELECT SUM(a.cana) AS cana FROM itsnte AS a JOIN snte AS b ON a.numero=b.numero WHERE a.codigo={$dbcode} AND b.fecha>{$dbfinal}"); $ajustes = $this->datasis->dameval("SELECT SUM(IF(b.tipo='E',1,-1)*cantidad) AS cana FROM itssal AS a JOIN ssal AS b ON a.numero = b.numero WHERE a.codigo = {$dbcode} AND b.fecha>{$dbfinal}"); $conver = $this->datasis->dameval("SELECT SUM(a.entrada-a.salida) AS cana FROM itconv AS a JOIN conv AS b ON a.numero = b.numero WHERE a.codigo = {$dbcode} AND b.fecha>{$dbfinal}"); $ventas = empty($ventas) ? htmlnformat(0) : htmlnformat($ventas); $compras = empty($compras) ? htmlnformat(0) : htmlnformat($compras); $nentreg = empty($nentreg) ? htmlnformat(0) : htmlnformat($nentreg); $actual = empty($actual) ? htmlnformat(0) : htmlnformat($actual); $ajustes = empty($ajustes) ? htmlnformat(0) : htmlnformat($ajustes); $conver = empty($conver) ? htmlnformat(0) : htmlnformat($conver); $consi = empty($consi) ? htmlnformat(0) : htmlnformat($consi); $mayor = empty($mayor) ? htmlnformat(0) : htmlnformat($mayor); //if($activo=='S'){ // $sactivo='<span style=\'font-size:0.7em;color:green;\'>ACTIVO</span>'; //}else{ // $sactivo='<span style=\'font-size:0.7em;color:red;\'>INACTIVO</span>'; //} $optadd = '<div style="">'; $optadd .= ' <table>'; $optadd .= ' <tr><td colspan=\'5\'><b style="text-size:1.4em;font-weight:bold;">Movimientos posteriores a la fecha ' . dbdate_to_human($ffinal) . ' para todos los almacenes</b></td></tr>'; $optadd .= " <tr><td>Ventas </td><td style='text-align:right' ><b> {$ventas}</b></td><td style='padding-left:50px;'>Ajustes </td><td style='text-align:right' ><b>{$ajustes}</b></td><td rowspan='3' style='text-align:center'>Existencia actual <p style='font-size:2em;padding:0 0 0 0;margin: 0 0 0 0;font-weight:bold;'>{$actual} / {$fracci}</p></td></tr>"; $optadd .= " <tr><td>Compras </td><td style='text-align:right' ><b>{$compras}</b></td><td style='padding-left:50px;'>Conversiones </td><td style='text-align:right' ><b> {$conver}</b></td></tr>"; $optadd .= " <tr><td>N.Entrega</td><td style='text-align:right' ><b>{$nentreg}</b></td><td style='padding-left:50px;'>Mayor </td><td style='text-align:right' ><b> {$mayor}</b></td></tr>"; $optadd .= ' </table>'; $optadd .= '</div>'; } else { $optadd = ''; } $data['content'] .= $optadd; $data['title'] = heading('Kardex de Inventario'); $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function sntealma() { $this->datasis->modulo_id('900', 1); $this->rapyd->load("datafilter", "datagrid"); $filter = new DataFilter("Cambio de almacén en notas de entrega", 'snte'); $filter->numero = new inputField('Número', 'numero'); $filter->numero->size = 10; $filter->fechad = new dateonlyField('Desde', 'fechad'); $filter->fechah = new dateonlyField('Hasta', 'fechah'); $filter->fechad->clause = $filter->fechah->clause = "where"; $filter->fechad->db_name = $filter->fechah->db_name = "fecha"; $filter->fechad->insertValue = date("Y-m-d"); $filter->fechah->insertValue = date("Y-m-d"); $filter->fechad->operator = ">="; $filter->fechah->operator = "<="; $filter->buttons("reset", "search"); $filter->build(); if ($this->rapyd->uri->is_set('search') && $filter->is_valid()) { $uri = anchor('supervisor/mantenimiento/sntecambioalma/modify/<#numero#>', '<#almacen#>'); $grid = new DataGrid('Notas de entrega'); $grid->per_page = 15; $grid->column('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>'); $grid->column('Almacén', $uri); $grid->column('Numero', 'numero'); $grid->column('Cliente', 'cod_cli'); $grid->column('Nombre', 'nombre'); $grid->column('Monto', '<nformat><#gtotal#></nformat>', 'align="right"'); $grid->build(); $tabla = $grid->output; } else { $tabla = ''; } $data['content'] = $filter->output . $tabla; $data['title'] = "<h1>Cambio de almacén en notas de entrega</h1>"; $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function index() { //SELECT * FROM bmov //WHERE codbanc='01' AND EXTRACT(YEAR_MONTH FROM fecha)<=201004 AND anulado!='S' AND liable!='N' AND //(concilia=0 OR EXTRACT(YEAR_MONTH FROM concilia)>=20100430 OR concilia<fecha) $this->rapyd->load('datafilter', 'datagrid'); $filter = new DataFilter(''); $filter->db->from('mbanc'); $filter->db->where('(MID(status,2,1) =2 or status="NC")'); //$filter->db->where('liable !=','N' ); $where = 'activo = "S"'; $mf = $this->datasis->puede(333); $mo = $this->datasis->puede(334); if ($mf && $mo) { } elseif ($mf) { $where .= ' AND tipocta="F"'; } elseif ($mo) { $where .= ' AND tipocta<>"F"'; } $mBANC = array('tabla' => 'banc', 'columnas' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'numcuent' => 'Cuenta', 'saldo' => 'Saldo'), 'filtro' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'saldo' => 'Saldo', 'numcuent' => 'Cuenta'), 'retornar' => array('codbanc' => 'codbanc'), 'where' => $where, 'titulo' => 'Buscar Bancos'); $bBANC = $this->datasis->p_modbus($mBANC, "banc"); $mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'rif' => 'Rif', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre', 'rif' => 'Rif'), 'retornar' => array('proveed' => 'cod_prov'), 'titulo' => 'Buscar Beneficiario'); $bSPRV = $this->datasis->p_modbus($mSPRV, "proveed"); $filter->tipo_doc = new dropdownField('Tipo de Operacion', 'tipo_doc'); $filter->tipo_doc->option('', 'Todos'); $filter->tipo_doc->option('NC', 'Nota de Crédito'); $filter->tipo_doc->option('ND', 'Nota de Debito'); $filter->tipo_doc->option('DE', 'Deposito'); $filter->tipo_doc->option('CH', 'Cheque'); //$filter->tipo_op->db_name='a.tipo_doc'; $filter->fechad = new dateonlyField("Desde", "fechad", 'd/m/Y'); $filter->fechad->clause = "where"; $filter->fechad->db_name = "fecha"; $filter->fechad->operator = ">="; $filter->fechad->insertValue = date("Ymd", mktime(0, 0, 0, date("m"), date("d") - 30, date("Y"))); $filter->fechad->group = "Fecha de Cheque"; //$filter->fechad->dbformat='Y-m-d'; //$filter->fechad->db_name='a.fecha'; $filter->fechad->rule = 'required'; $filter->fechah = new dateonlyField("Hasta", "fechah", 'd/m/Y'); $filter->fechah->clause = "where"; $filter->fechah->insertValue = date("Ymd"); $filter->fechah->db_name = "fecha"; $filter->fechah->operator = "<="; $filter->fechah->group = "Fecha de Cheque"; //$filter->fechaH->dbformat='Y-m-d'; //$filter->fechah->db_name='a.fecha'; $filter->fecha2d = new dateonlyField("Desde", "fecha2d", 'd/m/Y'); $filter->fecha2d->clause = "where"; $filter->fecha2d->db_name = "fecha2"; $filter->fecha2d->operator = ">="; // $filter->fecha2d->insertValue = date("Ymd",mktime(0, 0, 0, date("m"), date("d")-30, date("Y"))); $filter->fecha2d->group = "Fecha de Planilla"; //$filter->fechad->dbformat='Y-m-d'; //$filter->fechad->db_name='a.fecha'; // $filter->fecha2d->rule ='required'; $filter->fecha2h = new dateonlyField("Hasta", "fecha2h", 'd/m/Y'); $filter->fecha2h->clause = "where"; // $filter->fecha2h->insertValue = date("Ymd"); $filter->fecha2h->db_name = "fecha2"; $filter->fecha2h->operator = "<="; $filter->fecha2h->group = "Fecha de Planilla"; //$filter->fechaH->dbformat='Y-m-d'; //$filter->fechah->db_name='a.fecha'; $filter->cheque = new inputField("Transaccion", "cheque"); $filter->cheque->db_name = "cheque"; $filter->cheque->size = 10; //$filter->cheque->db_name='a.cheque'; $filter->cod_prov = new inputField("Beneficiario", 'cod_prov'); $filter->cod_prov->size = 6; $filter->cod_prov->append($bSPRV); //$filter->cod_prov->db_name='a.cod_prov'; $filter->benefi = new inputField("A Nombre de", "benefi"); $filter->benefi->size = 40; //$filter->benefi->db_name='a.benefi'; $filter->concilia = new dropdownField('Conciliado', 'concilia'); $filter->concilia->option('', 'Todos'); $filter->concilia->option('S', 'Si'); $filter->concilia->option('N', 'No'); //$filter->concilia->db_name='a.concilia'; $filter->vnoc = new dropdownField("Ver No Conciliados con Fecha anterior", "vnoc"); $filter->vnoc->clause = " "; $filter->vnoc->db_name = " "; $filter->vnoc->option('', 'NO'); $filter->vnoc->option('S', 'SI'); $filter->des8 = new containerField("", "<div style='background-color:#CCEEEE;padding:5px;'>INTRODUCE LOS DATOS DEL ESTADO DE CUENTA</div>"); $filter->des8->group = "Datos de Estado de Cuenta"; $filter->des8->clause = ' '; $filter->codbanc = new inputField("Banco", 'codbanc'); $filter->codbanc->db_name = 'codbanc'; $filter->codbanc->rule = 'required'; $filter->codbanc->size = 3; $filter->codbanc->append($bBANC); $filter->codbanc->group = "Datos de Estado de Cuenta"; $filter->codbanc->clause = "where"; $filter->codbanc->operator = "="; //$filter->codbanc->db_name='a.codbanc'; $y = date('Y'); $filter->anio = new dropdownField('Año', 'anio'); $filter->anio->option($y, $y); for ($i = $y - 2; $i <= $y + 2; $i++) { $filter->anio->option($i, $i); } $filter->anio->rule = 'required'; $filter->anio->clause = ''; $filter->anio->in = 'mes'; $filter->anio->size = 5; $filter->anio->style = "width:100px;"; $filter->anio->group = "Datos de Estado de Cuenta"; $filter->mes = new dropdownField('Fecha mes/año', 'mes'); $filter->mes->clause = ''; $filter->mes->rule = 'required'; $filter->mes->style = 'width:50px'; for ($i = 1; $i <= 12; $i++) { $mmes = str_pad($i, 2, '0', STR_PAD_LEFT); $filter->mes->option($mmes, $mmes); } $filter->mes->group = "Datos de Estado de Cuenta"; $filter->buttons('reset', 'search'); $filter->build(); $tipos = array("tch" => "T. Cheques", "tnd" => "T. ND", "tdp" => "T. Depositos", "tnc" => "T. NC"); $salida = ''; foreach ($tipos as $key => $value) { ${$key} = new inputField($value, $key); ${$key}->status = "create"; ${$key}->size = 15; ${$key}->build(); $salida .= ${$key}->label . ${$key}->output; } if ($this->rapyd->uri->is_set('search') and $filter->is_valid()) { $q1 = $filter->db->_compile_select(); $fechad = $filter->fechad->newValue; $codbanc = $filter->codbanc->newValue; $tipo_doc = $filter->tipo_doc->newValue; $codbanc = $filter->codbanc->newValue; $cheque = $filter->cheque->newValue; $cod_prov = $filter->cod_prov->newValue; $benefi = $filter->benefi->newValue; $codbance = $this->db->escape($codbanc); $fechaddb = $fechad; $tipo_doce = $this->db->escape($tipo_doc); $chequee = $this->db->escape($cheque); $benefie = $this->db->escape($benefi); $vnoc = $this->input->post('vnoc'); $anio = $filter->anio->newValue; $mes = $filter->mes->newValue; $q = "SELECT todo.tipo_doc='DP' tdp,MID(cheque,LENGTH(cheque)-3,4) ordena,todo.* FROM ( "; $q .= $q1; if ($vnoc) { $q2 = " SELECT * FROM mbanc WHERE codbanc={$codbance} AND fecha<{$fechaddb} AND concilia='N' AND status NOT IN ('AN') "; if ($tipo_doc) { $q2 .= " AND tipo_doc={$tipo_doce} "; } if ($cheque) { $q2 .= " AND tipo_doc={$chequee} "; } if ($benefi) { $q2 .= " AND tipo_doc={$benefie} "; } $q .= " UNION ALL "; $q .= $q2; } $q .= ")todo ORDER BY " . $this->datasis->traevalor("CONCIORDENA", "fecha,cheque"); $qa = $this->db->query($q); $qa = $qa->result_array($qa); //'MID(status,2,1) ','2' function conci($conci, $codbanc, $tipo_op, $numero, $fecha, $id) { //$numero='hoa'; $numero = raencode($numero); $arr = array($codbanc, $tipo_op, $numero, $fecha, $id); //print_r($arr); //echo $id; if ($conci != 'S') { return form_checkbox($codbanc . $tipo_op . $numero . $id, serialize($arr)); } else { return form_checkbox($codbanc . $tipo_op . $numero . $id, serialize($arr), TRUE); } } function caja($codbanc, $tipo_doc, $cheque, $monto) { //$fech=explode('-',$conci); $arr = array($codbanc, $tipo_doc, $numero, $fecha); return form_input($codbanc . $tipo_op . $numero, serialize($arr), TRUE); } $monto = new inputField("Monto", "monto"); $monto->grid_name = 'monto<#codbanc#><#tipo_doc#><#cheque#>'; $monto->status = 'modify'; $monto->size = 12; $monto->css_class = 'inputnum'; $fconci = new dateField('', 'fconci', 'd/m/Y'); $fconci->status = 'create'; $fconci->size = 10; $fconci->insertValue = date('Ymt', mktime(0, 0, 0, $mes, 1, $anio)); $fconci->build(); $fecha = $filter->anio->newValue . $filter->mes->newValue . days_in_month($filter->mes->newValue); $grid = new DataGrid('Efectos Conciliables' . "</br>Fecha Conciliación " . $fconci->output, $qa); $grid->use_function('conci'); //$grid->order_by($ord); $grid->per_page = 10000; $grid->column_orderby('Ref.', 'id', 'id'); $grid->column_orderby('Tipo doc', 'tipo_doc', 'tipo_doc'); $grid->column_orderby('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>', 'fecha'); $grid->column_orderby('Fecha Doc', '<dbdate_to_human><#fecha2#></dbdate_to_human>', 'fecha2'); $grid->column_orderby('Transaccion', "<wordwrap><#cheque#>|50|\n|true</wordwrap>", 'cheque', 'width="200px"'); $grid->column_orderby('Monto', $monto, 'monto'); $grid->column_orderby('Conciliado', "<conci><#concilia#>|<#codbanc#>|<#tipo_doc#>|<#cheque#>|{$fecha}|<#id#></conci>", 'concilia'); $grid->column_orderby('F conciliacion', '<dbdate_to_human><#fconcilia#></dbdate_to_human>', 'fcocilia'); $grid->column_orderby('Beneficiario', 'benefi', 'benefi'); $grid->column_orderby('Concepto', 'observa', 'observa'); $grid->build(); $ggrid = $grid->output; } else { $ggrid = ''; } $data['filtro'] = $filter->output; $data['content'] = $salida . $ggrid; $data['title'] = 'Conciliaciones de Bancos'; $data['script'] = '<script language="javascript" type="text/javascript">'; $data['script'] .= ' function suma(){ tch =0;tdp=0;tnc=0;tnd=0; $(":checkbox").each(function(i,val){ if(val.checked==true){ monto=parseFloat($("#monto"+val.name).val()); tipo =val.name.substr(2,2); if(tipo=="CH")tch=tch+monto; if(tipo=="DP")tdp=tdp+monto; if(tipo=="NC")tnc=tnc+monto; if(tipo=="ND")tnd=tnd+monto; } }); $("#tch").val(Math.round(tch*100)/100); $("#tdp").val(Math.round(tdp*100)/100); $("#tnc").val(Math.round(tnc*100)/100); $("#tnd").val(Math.round(tnd*100)/100); } $(document).ready(function(){ suma(); $(":checkbox").change(function(){ name=$(this).attr("name"); ch=$(this).is(":checked"); fc=$("#fconci").val(); $.post("' . site_url('tesoreria/conci/cconci') . '",{ data: $(this).val(),accion:ch,fconci:fc}, function(data){ if(data=="1"){ suma(); return true; }else{ $("input[name=\'"+name+"\']").removeAttr("checked"); alert(data); return false; } }); }); });'; $data['script'] .= '</script>'; $data['head'] = $this->rapyd->get_head() . script('jquery.js'); $this->load->view('view_ventanas', $data); }