function detalle() { $this->rapyd->load("datagrid", "dataform"); $modulo = $this->uri->segment(4) ? $this->uri->segment(4) : $this->input->post('modulo'); if (!$modulo) { redirect('/contabilidad/reglas'); } $form = new DataForm('contabilidad/reglas/ejecutar'); $form->title('Fecha para la ejecución'); $form->fecha = new dateonlyField("Fecha", "fecha", "d/m/Y"); $form->fecha->size = 10; $form->fecha->insertValue = $this->input->post('fecha') ? $this->input->post('fecha') : date("Ymd"); $form->fecha->append("<input type='hidden' name='modulo' value='{$modulo}' id='modulo'>"); $form->submit = new submitField("Ejecutar", "btn_submit"); $form->submit->in = 'fecha'; $form->build_form(); $link = anchor('/contabilidad/reglas/dataedit/<#modulo#>/show/<#modulo#>/<#regla#>', 'Ver regla'); $link2 = anchor('/contabilidad/reglas/duplicar/<#modulo#>/<#regla#>', 'Duplicar'); $action = "javascript:window.location='" . site_url('contabilidad/reglas') . "'"; $grid = new DataGrid(); $grid->add("contabilidad/reglas/dataedit/{$modulo}/create", 'Agregar Regla'); $grid->button('cancelar', RAPYD_BUTTON_BACK, $action); $grid->db->select('modulo, regla, tabla, descripcion,condicion'); $grid->db->from('`reglascont`'); $grid->db->where('modulo', $modulo); $grid->db->orderby('modulo,tabla,regla'); $grid->column("Modulo", "modulo"); $grid->column("Regla", "regla"); $grid->column("Tabla", "tabla"); $grid->column("Descripcion", "descripcion"); //$grid->column("Condicion", "condicion"); $grid->column('', $link, 'align="center"'); $grid->column('', $link2, 'align="center"'); $grid->build(); $data['content'] = $form->output . $grid->output; $data["head"] = $this->rapyd->get_head(); $data['title'] = "Detalle de regla {$modulo}"; $this->load->view('view_ventanas', $data); }
function filteredgrid() { $this->rapyd->load("datafilter2", "datagrid"); //$this->rapyd->uri->keep_persistence(); $mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'cod_prov'), 'titulo' => 'Buscar Beneficiario'); $bSPRV = $this->datasis->p_modbus($mSPRV, "proveed"); $filter = new DataFilter2(""); $filter->db->select(array("b.ocompra", "a.reverso", "b.codigoadm", "b.fondo", "b.partida", "b.ordinal", "a.numero", "a.fecha", "a.tipo", "a.compra", "a.uejecutora", "a.estadmin", "a.fondo", "a.cod_prov", "a.nombre", "a.beneficiario", "a.pago", "a.total2", "a.status", "MID(a.observa,1,50) observa", "c.nombre nombre2")); $filter->db->from("odirect a"); $filter->db->join("itodirect b", "a.numero=b.numero", "LEFT"); $filter->db->join("sprv c", "c.proveed =a.cod_prov", "LEFT"); $filter->db->groupby("a.numero"); $filter->numero = new inputField("Número", "numero"); $filter->numero->size = 12; //$filter->numero->clause="likerigth"; $filter->numero->db_name = 'a.numero'; $filter->ocompra = new inputField("Compromiso Ref", "ocompra"); $filter->ocompra->size = 12; $filter->ocompra->db_name = 'b.ocompra'; $filter->tipo = new dropdownField("Orden de ", "a.tipo"); $filter->tipo->option("", ""); $filter->tipo->option("Compra", "Compra"); $filter->tipo->option("Servicio", "Servicio"); $filter->tipo->style = "width:100px;"; $filter->tipo->db_name = 'a.tipo'; $filter->fecha = new dateonlyField("Fecha", "fecha"); $filter->fecha->size = 12; $filter->fecha->db_name = 'a.fecha'; $filter->fecha->dbformat = 'Y-m-d'; $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->cod_prov->clause = 'where'; $filter->cod_prov->operator = '='; $filter->codigo = new inputField("Codigo Presupuestario", "codigo"); $filter->codigo->db_name = 'CONCAT(b.codigoadm,".",b.partida)'; $filter->fondo = new dropdownField("Fondo", "fondo"); $filter->fondo->option("", ""); $filter->fondo->options("SELECT fondo,CONCAT_WS(' ',fondo,descrip)a FROM fondo"); $filter->fondo->db_name = 'b.fondo'; $filter->observa = new inputField("Observacion", "observa"); $filter->observa->size = 20; $filter->observa->db_name = 'a.observa'; $filter->total2 = new inputField("Monto", "total2"); $filter->total2->size = 20; $filter->tipo = new dropdownField("Tipo O.P.", "tipo"); $filter->tipo->option("", ""); $filter->tipo->option("M", "O.P Sin Imputacion"); $filter->tipo->option("C", "O.P General"); $filter->tipo->option("B", "O.P Directo"); $filter->tipo->option("K", "O.P Nomina"); $filter->tipo->style = "width:150px"; $filter->tipo->db_name = 'MID(a.status,1,1)'; $filter->status = new dropdownField("Estado", "status"); $filter->status->option("", ""); $filter->status->option("2", "Causado"); $filter->status->option("1", "Por Causar"); $filter->status->option("3", "Pagado"); $filter->status->option("A", "Anulado"); $filter->status->style = "width:150px"; $filter->status->db_name = 'MID(a.status,2,1)'; $filter->buttons("reset", "search"); $filter->build(); $uri = anchor($this->url . 'dataedit/show/<#numero#>', '<#numero#>'); $uri_2 = anchor($this->url . 'dataedit/create/<#numero#>', 'Duplicar'); function sta($status) { switch (substr($status, 1, 1)) { case "1": return "Por Causar"; break; case "2": return "Causado"; break; case "3": return "Pagado"; break; case "A": return "Anulado"; break; } } function tipo($tipo) { switch ($tipo) { case "C": return "Contrato"; break; case "T": return "Transferencia"; break; case "N": return "Nómina"; break; } } function select_url($status, $numero) { $atts2 = array('width' => '1024', 'height' => '768', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '0', 'screeny' => '0'); switch (substr($status, 0, 1)) { case "M": return anchor_popup('presupuesto/pagomonetario/dataedit/opagof/show/' . $numero, $numero, $atts2); break; case "C": return anchor_popup('presupuesto/opagoc/dataedit/opagof/show/' . $numero, $numero, $atts2); break; case "K": return anchor_popup('presupuesto/pagonom/dataedit/opagof/show/' . $numero, $numero, $atts2); break; case "B": return anchor_popup('presupuesto/odirect/dataedit/opagof/show/' . $numero, $numero, $atts2); break; case "F": return anchor_popup('presupuesto/opago/dataedit/opagof/show/' . $numero, $numero, $atts2); break; } } $grid = new DataGrid($this->titp); $grid->order_by("numero", "desc"); $grid->per_page = 20; $grid->use_function('substr', 'str_pad', 'sta', 'tipo', 'select_url'); $grid->column_orderby("Número", "<select_url><#status#>|<#numero#></select_url>", "numero"); $grid->column_orderby("Tipo", "tipo", "tipo", "align='center'"); $grid->column_orderby("Fecha", "fecha", "fecha", "align='center'"); $grid->column_orderby("Compromiso Ref", "ocompra", "ocompra", "NOWRAP"); $grid->column_orderby("Est. Adm", "codigoadm", "estamdin", "NOWRAP"); $grid->column_orderby("Fondo", "fondo", "fondo", "NOWRAP"); $grid->column_orderby("Partida", "partida", "partida", "NOWRAP"); $grid->column_orderby("Beneficiario", "nombre2", "c.nombre"); //,"NOWRAP" $grid->column_orderby("Observacion", "observa", "observa"); //,"NOWRAP" $grid->column_orderby("Monto", "total2", "total2", "align='right'"); $grid->column_orderby("Estado", "<sta><#status#></sta>", "status", "align='center' "); //NOWRAP $action = "javascript:window.open('" . site_url('presupuesto/opagoc/selectoc/') . "','_blank','width=1024, height=768,scrollbars=yes,status=yes,resizable=yes,screenx=0,screeny=0')"; $grid->button("add_opagoc", "Orden de Pago", $action, "TR"); $action = "javascript:window.open('" . site_url('presupuesto/odirect/dataedit/create') . "','_blank','width=1024, height=768,scrollbars=yes,status=yes,resizable=yes,screenx=0,screeny=0')"; $grid->button("add_odirect", "O.P. Directo", $action, "TR"); $action = "javascript:window.open('" . site_url('presupuesto/pagomonetario/dataedit/create') . "','_blank','width=1024, height=768,scrollbars=yes,status=yes,resizable=yes,screenx=0,screeny=0')"; $grid->button("add_opsinimpu", "O.P. Sin Imputacion", $action, "TR"); $action = "javascript:window.open('" . site_url('presupuesto/pagonom/') . "','_blank','width=1024, height=768,scrollbars=yes,status=yes,resizable=yes,screenx=0,screeny=0')"; $grid->button("add_pagonom", "O.P. Nomina", $action, "TR"); $grid->build(); // echo $grid->db->last_query(); $data['filtro'] = $filter->output; $data['content'] = $grid->output; $data['script'] = script("jquery.js") . "\n"; $data['title'] = ""; //" $this->titp "; //$data['content'] = $filter->output.$grid->output; $data['title'] = "{$this->titp}"; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function cierregserchi() { $this->rapyd->load('datafilter', 'datagrid'); $this->rapyd->uri->keep_persistence(); $uri = anchor('finanzas/gser/gserchipros/<#codbanc#>', '<#codbanc#>'); $grid = new DataGrid(''); $select = array('MAX(fechafac) AS fdesde', 'MIN(fechafac) AS fhasta', 'SUM(tasa+sobretasa+reducida) AS totiva', 'SUM(montasa+monadic+monredu+tasa+sobretasa+reducida+exento) AS total', 'TRIM(codbanc) AS codbanc', 'COUNT(*) AS cana'); $grid->db->select($select); $grid->db->from('gserchi'); $grid->db->where('ngasto IS NULL'); $grid->db->where('aceptado', 'S'); $grid->db->groupby('codbanc'); $grid->order_by('codbanc', 'desc'); $grid->per_page = 15; $grid->column_orderby('Caja', $uri, 'codbanc'); $grid->column('N.facturas', 'cana', 'align=\'center\''); $grid->column_orderby('Fecha inicial', '<dbdate_to_human><#fdesde#></dbdate_to_human>', 'fdesde', 'align=\'center\''); $grid->column_orderby('Fecha final', '<dbdate_to_human><#fhasta#></dbdate_to_human>', 'fdesde', 'align=\'center\''); $grid->column_orderby('IVA', '<nformat><#totiva#></nformat>', 'totiva', 'align=\'right\''); $grid->column_orderby('Monto', '<nformat><#total#></nformat>', 'total', 'align=\'right\''); $action = "javascript:window.location='" . site_url('finanzas/gser/agregar') . "'"; $grid->button('btn_regresa', 'Regresar', $action, 'TR'); $grid->build(); //echo $grid->db->last_query(); $data['content'] = $grid->output; $data['head'] = $this->rapyd->get_head(); $data['title'] = heading('Cajas pendientes por cerrar'); $this->load->view('view_ventanas', $data); }
function detitfact() { $this->rapyd->load('datagrid'); $caja = $this->uri->segment(4); $cajero = $this->uri->segment(5); $fecha = $this->uri->segment(6); $menvia = site_url("supermercado/poscuadre/concaja/{$caja}/{$cajero}/{$fecha}"); $grid = new DataGrid('Ventas por artículos'); $grid->per_page = 20; $select = array('codigo', 'descrip', 'SUM(cantidad) cantidad', 'SUM(monto) monto', 'SUM(impuesto) impuesto', 'referen'); $grid->db->select($select); $grid->db->from('positfact'); $grid->db->where('fecha', $fecha); $grid->db->where('cajero', $cajero); $grid->db->where('caja', $caja); $grid->db->groupby('codigo'); $grid->column('Código', 'codigo'); $grid->column('Descripción', 'descrip'); $grid->column('Cantidad', 'cantidad', 'align="right"'); $grid->column('Monto', '<nformat><#monto#></nformat>', 'align="right"'); $grid->column('Referencia', 'referen'); $grid->button('btn_reg', 'Regresar', "javascript:window.location='" . site_url("supermercado/poscuadre/concaja/{$caja}/{$cajero}/{$fecha}") . "'", 'TR'); $grid->build(); if ($grid->recordCount > 0) { $data['content'] = $grid->output; } else { $data['content'] = '<p class="mainheader">No se encontrarón resultados.</p>'; $data['content'] .= "<a href='{$menvia}'>Regresar</a>"; } $data['title'] = '<h1>Ventas por artículo ' . $cajero . ' caja ' . $caja . ' fecha ' . dbdate_to_human($fecha) . '</h1>'; $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function detalle() { $this->rapyd->load('datagrid', 'dataform'); $modulo = $this->uri->segment(4) ? $this->uri->segment(4) : $this->input->post('modulo'); if (!$modulo) { redirect('/contabilidad/reglas'); } $form = new DataForm('contabilidad/reglas/ejecutar'); $form->title('Fecha para la ejecución'); $form->fecha = new dateonlyField('Fecha', 'fecha', 'd/m/Y'); $form->fecha->size = 10; $form->fecha->insertValue = $this->input->post('fecha') ? $this->input->post('fecha') : date('Ymd'); $form->fecha->append("<input type='hidden' name='modulo' value='{$modulo}' id='modulo'>"); $form->submit = new submitField('Ejecutar', 'btn_submit'); $form->submit->in = 'fecha'; $form->build_form(); function marca($encab, $val) { if ($encab == 'CASI') { return ''; } if (!empty($val)) { if (is_numeric($val) && floatval($val) == 0) { return ''; } else { return '<div style="background:green"> - </div>'; } } return ''; } $sel = array('modulo', 'descripcion', 'regla', 'tabla', 'debe', 'haber'); $link = anchor('/contabilidad/reglas/dataedit/<#modulo#>/show/<#modulo#>/<#regla#>', 'Ver regla'); $link2 = anchor('/contabilidad/reglas/duplicar/<#modulo#>/<#regla#>', 'Duplicar'); $action = "javascript:window.location='" . site_url('contabilidad/reglas') . "'"; $grid = new DataGrid(); $grid->use_function('marca'); $grid->add("contabilidad/reglas/dataedit/{$modulo}/create", 'Agregar Regla'); $grid->button('cancelar', RAPYD_BUTTON_BACK, $action); $grid->db->select($sel); $grid->db->from('`reglascont`'); $grid->db->where('modulo', $modulo); $grid->db->orderby('modulo,tabla,regla'); $grid->column('Modulo', 'modulo'); $grid->column('Regla', 'regla'); $grid->column('Tabla', 'tabla'); $grid->column('Descripcion', 'descripcion'); $grid->column('Debe', '<marca><#tabla#>|<#debe#></marca>', 'align="center"'); $grid->column('Haber', '<marca><#tabla#>|<#haber#></marca>', 'align="center"'); $grid->column('', $link, 'align="center"'); $grid->column('', $link2, 'align="center"'); $grid->build(); $data['content'] = $form->output . $grid->output; $data['head'] = $this->rapyd->get_head(); $data['title'] = "<h1>Detalle de regla {$modulo}</h1>"; $this->load->view('view_ventanas', $data); }
function agregar() { $this->rapyd->load('datafilter', 'datagrid'); $atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '0', 'screeny' => '0'); $recep = anchor('ventas/rcaj/forcierre/', 'Recepcion de Caja'); $data['content'] = ''; function iconcaja($cajero, $audi) { if (empty($audi)) { return image('caja_abierta.gif', "Caja disponible"); } else { return image('caja_precerrada.gif', "En auditoria"); } } $data['forma'] = ''; $urip = anchor('formatos/ver/RECAJA/<#numero#>', 'Descargar html'); $urih = anchor_popup('formatos/verhtml/RECAJA/<#numero#>', ' Ver cuadre pantalla', $atts); $grid = new DataGrid('Lista de caja'); $grid->order_by('fecha', 'desc'); $grid->per_page = 15; $grid = new DataGrid('Arqueo de cajas'); $select = array('a.codbanc AS cajero', 'a.banco AS nombre', 'a.saldo', 'b.id AS audi'); $grid->db->select($select); $grid->db->from('banc AS a'); $grid->db->join('caudi AS b', 'a.codbanc=b.caja AND b.status=\'P\'', 'left'); $grid->db->where('a.tbanco', 'CAJ'); $grid->use_function('iconcaja'); $link = anchor('finanzas/caudi/auditoria/<#cajero#>', 'Arquear'); $grid->column('Caja', '<iconcaja><#cajero#>|<#audi#></iconcaja>'); $grid->column('Cajero', '<#cajero#>-<#nombre#>'); $grid->column('Saldo', '<nformat><#saldo#></nformat>', 'align=\'right\''); $grid->column('Arqueo', $link); //$grid->column('Ver html' ,"<siinulo><#numero#>|---|$urih</siinulo>",'align=\'center\''); $action = 'javascript:window.location=\'' . site_url($this->url . '/filteredgrid') . '\''; $grid->button('btn_reg', 'Regresar', $action, 'TR'); $grid->build(); //echo $grid->db->last_query(); $data['content'] .= $grid->output; $data['title'] = '<h1>Recepción de cajas</h1>'; $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function cmetas() { $this->rapyd->uri->keep_persistence(); $this->rapyd->load('datagrid', 'fields'); $error = $msj = ''; if ($this->input->post('pros') !== false) { $pmargen = $this->input->post('pmargen'); if (is_array($pmargen)) { $sum = array_sum($pmargen); if (round($sum, 2) == 100.0) { foreach ($pmargen as $id => $pm) { if (is_numeric($pm) && $pm >= 0) { $this->db->where('id', $id); $this->db->update('vend', array('pmargen' => $pm)); } else { $error .= 'Valor no numérico o negativo ' . $id; } } } else { $error .= 'La suma de los valores debe dar exactamente 100'; } } else { $error = 'No se puede procesar el requerimiento'; } } $ggrid = form_open('/ventas/metas/cmetas'); $grid = new DataGrid('Ajuste de distribución de la meta'); $grid->order_by('nombre'); $select = array('vendedor', 'nombre', 'pmargen', 'id'); $grid->db->select($select); $grid->db->from('vend AS a'); $campo = new inputField('Campo', 'pmargen'); $campo->grid_name = 'pmargen[<#id#>]'; //$campo->pattern =''; $campo->status = 'modify'; $campo->size = 6; $campo->autocomplete = false; $campo->css_class = 'inputnum'; $campo->disable_paste = true; $grid->column_orderby('Vendedor', 'vendedor', 'vendedor'); $grid->column_orderby('Nombre', 'nombre', 'nombre'); $grid->column('Margen %', $campo, 'align=\'center\''); $action = "javascript:window.location='" . site_url('ventas/metas/filteredgrid') . "'"; $grid->button('btn_regresa', 'Regresar', $action, 'TR'); $grid->submit('pros', 'Guardar', 'BR'); $grid->build(); $ggrid .= $grid->output; $ggrid .= form_close(); $script = '<script language="javascript" type="text/javascript"> $(function(){ $(".inputnum").numeric("."); $(\'input[name^="pmargen"]\').focus(function() { obj = $(this); vval = Number(obj.val()); tota=0; $(\'input[name^="pmargen"]\').each(function (i) { tota+=Number(this.value); }); val=roundNumber(100-(tota-vval),2); obj.val(val); obj.select(); }); }); </script>'; $data['content'] = '<div class="alert">' . $error . '</div>'; $data['content'] .= '<div>' . $msj . '</div>'; $data['content'] .= $ggrid; $data['title'] = heading('Cambio en las metas para vendedores'); $data['script'] = $script; $data['script'] .= phpscript('nformat.js'); $data['head'] = $this->rapyd->get_head() . script('jquery.pack.js') . script('plugins/jquery.numeric.pack.js') . script('plugins/jquery.floatnumber.js'); $data['head'] .= style('estilos.css'); $data['head'] .= phpscript('nformat.js'); $this->load->view('view_ventanas', $data); }
function filteredgrid() { $this->rapyd->load('datafilter', 'datagrid'); $mBANC = array('tabla' => 'banc', 'columnas' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'numcuent' => 'Cuenta', 'saldo' => 'Saldo'), 'filtro' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'numcuent' => 'Cuenta'), 'retornar' => array('codbanc' => 'codbanc'), 'where' => 'activo = "S"', 'titulo' => 'Buscar Bancos'); $bBANC = $this->datasis->modbus($mBANC); $filter = new DataFilter($this->titp, 'r_mbancrel a'); $filter->db->select(array('a.id', 'a.codbanc', 'a.tipo_doc', 'a.cheque', 'a.monto', 'a.total', 'a.fecha', 'a.fechaing', 'a.concepto')); $filter->db->join('r_mbanc b', 'a.id=b.id_mbancrel'); $filter->db->group_by('a.id'); $filter->id = new inputField('Id', 'id'); $filter->id->rule = 'trim'; $filter->id->size = 13; $filter->id->maxlength = 11; $filter->id->db_name = 'a.id'; $filter->codbanc = new inputField('Codbanc', 'codbanc'); $filter->codbanc->rule = 'trim'; $filter->codbanc->size = 12; $filter->codbanc->maxlength = 10; $filter->codbanc->append($bBANC); $filter->codbanc->db_name = 'a.codbanc'; $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->tipo_doc->db_name = 'a.tipo_doc'; $filter->cheque = new inputField('Transaccion', 'cheque'); $filter->cheque->rule = 'trim'; $filter->cheque->size = 10; $filter->cheque->db_name = 'a.cheque'; $filter->monto = new inputField('Monto', 'monto'); $filter->monto->rule = 'trim|numeric'; $filter->monto->css_class = 'inputnum'; $filter->monto->size = 21; $filter->monto->maxlength = 19; $filter->monto->db_name = 'a.monto'; $filter->total = new inputField('Total Items', 'total'); $filter->total->rule = 'trim|numeric'; $filter->total->css_class = 'inputnum'; $filter->total->size = 21; $filter->total->maxlength = 19; $filter->total->db_name = 'a.total'; $filter->fecha = new dateOnlyField('Fecha Transaccion', 'fecha'); $filter->fecha->db_name = 'a.fecha'; $filter->fecha->rule = 'chfecha'; $filter->fecha->size = 10; $filter->fecha->maxlength = 8; $filter->fecha->db_name = 'fecha'; $filter->fecha->clause = 'where'; $filter->fecha->operator = '='; $filter->fechaing = new dateOnlyField('Fecha Ingreso', 'fechaing'); $filter->fechaing->rule = 'chfecha'; $filter->fechaing->size = 10; $filter->fechaing->maxlength = 8; $filter->fechaing->db_name = 'fechaing'; $filter->fechaing->clause = 'where'; $filter->fechaing->operator = '='; $filter->concepto = new inputField('Concepto', 'concepto'); $filter->concepto->rule = 'trim'; $filter->concepto->size = 20; $filter->concepto->db_name = 'a.concepto'; $filter->transacciones = new inputField('Transaccion Detalle', 'transacciones'); $filter->transacciones->rule = 'trim'; $filter->transacciones->size = 10; $filter->transacciones->db_name = 'b.cheque'; $filter->buttons('reset', 'search'); $filter->build(); $uri = anchor($this->url . 'dataedit/show/<raencode><#id#></raencode>', '<#id#>'); $grid = new DataGrid(''); $grid->order_by('a.id', 'desc'); $grid->per_page = 10000; $grid->column_orderby('Id', "{$uri}", 'id', 'align="left"'); $grid->column_orderby('Codbanc', "codbanc", 'codbanc', 'align="left"'); $grid->column_orderby('Tipo_doc', "tipo_doc", 'tipo_doc', 'align="left"'); $grid->column_orderby('Cheque', "cheque", 'cheque', 'align="left"'); $grid->column_orderby('Monto', "<nformat><#monto#></nformat>", 'monto', 'align="right"'); $grid->column_orderby('Total', "<nformat><#total#></nformat>", 'total', 'align="right"'); $grid->column_orderby('Fecha', "<dbdate_to_human><#fecha#></dbdate_to_human>", 'fecha', 'align="center"'); $grid->column_orderby('Fecha Ingreso', "<dbdate_to_human><#fechaing#></dbdate_to_human>", 'fechaing', 'align="center"'); $grid->column_orderby('Concepto', "concepto", 'concepto', 'align="left"'); $action = "javascript:window.location='" . site_url($this->url . 'reparafecha') . "'"; $grid->button("reperafecha", "Reparar Fechas de Efectivo", $action, "TL"); $grid->add($this->url . 'selectr_mbanc'); $grid->build(); $data['filtro'] = $filter->output; $data['content'] = $grid->output; $data['head'] = $this->rapyd->get_head() . script('jquery.js'); $data['title'] = $this->titp; $this->load->view('view_ventanas', $data); }
function cprecios($control) { $this->rapyd->uri->keep_persistence(); $this->rapyd->load('datagrid', 'fields'); $error = ''; $msj = ''; if ($this->input->post('scstp_1') !== false) { $precio1 = $this->input->post('scstp_1'); $precio2 = $this->input->post('scstp_2'); $precio3 = $this->input->post('scstp_3'); $precio4 = $this->input->post('scstp_4'); foreach (array_keys($precio1) as $ind) { $pt1 = $precio1[$ind] >= $precio2[$ind] && $precio2[$ind] >= $precio3[$ind] && $precio3[$ind] >= $precio4[$ind]; $pt2 = $precio1[$ind] > 0 && $precio2[$ind] > 0 && $precio3[$ind] > 0 && $precio4[$ind] > 0; if ($pt1 && $pt2) { $data = array('precio1' => $precio1[$ind], 'precio2' => $precio2[$ind], 'precio3' => $precio3[$ind], 'precio4' => $precio4[$ind]); $where = 'id = ' . $this->db->escape($ind); $mSQL = $this->db->update_string('itscst', $data, $where); $ban = $this->db->simple_query($mSQL); } else { $error = 'Los precios deben cumplir esta regla (precio 1 >= precio 2 >= precio 3 >= precio 4) y mayores a cero'; } } if (strlen($error) == 0) { $msj = 'Nuevos Precios guardados'; } if ($this->solo) { return '{"status":"C","id":"' . $control . '" ,"mensaje":"' . $msj . $error . '"}'; } } if ($this->solo) { $ggrid = form_open('/compras/scst/solo/cprecios/' . $control, array("id" => "df1")); } else { $ggrid = form_open('/compras/scst/cprecios/' . $control); } function costo($formcal, $pond, $ultimo, $standard, $existen, $itcana) { $CI =& get_instance(); $costo_pond = $CI->_pond($existen, $itcana, $pond, $ultimo); return $CI->_costos($formcal, $costo_pond, $ultimo, $standard); } function margen($formcal, $pond, $ultimo, $standard, $existen, $itcana, $precio, $iva) { $costo = costo($formcal, $pond, $ultimo, $standard, $existen, $itcana); if ($precio == 0) { return 0; } return round(100 - $costo * 100 / ($precio / (1 + $iva / 100)), 2); } function tcosto($id, $iva, $formcal, $pond, $ultimo, $standard, $existen, $itcana) { $costo = costo($formcal, $pond, $ultimo, $standard, $existen, $itcana); $rt = nformat($costo); $rt .= '<input type="hidden" id="costo[' . $id . ']" name="costo[' . $id . ']" value="' . $costo . '" />'; $rt .= '<input type="hidden" id="iva[' . $id . ']" name="iva[' . $id . ']" value="' . $iva . '" />'; return $rt; } $grid = new DataGrid('Precios de artículos'); $grid->use_function('costo', 'margen', 'tcosto'); $grid->order_by('descrip'); $select = array('b.codigo', 'b.descrip', 'b.formcal', 'a.costo', 'b.ultimo', 'b.pond', 'b.standard', 'a.id', 'a.precio1 AS scstp_1', 'a.precio2 AS scstp_2', 'a.precio3 AS scstp_3', 'a.precio4 AS scstp_4', 'b.precio1 AS sinvp1', 'b.precio2 AS sinvp2', 'b.precio3 AS sinvp3', 'b.precio4 AS sinvp4', 'b.formcal', 'a.cantidad', 'b.existen', 'b.iva'); $grid->db->select($select); $grid->db->from('itscst AS a'); $grid->db->join('sinv AS b', 'a.codigo=b.codigo'); $grid->db->where('control', $control); //$grid->column('Código' , '' ); $grid->column_orderby('Descripción', '<b class=\'mininegro\'><#codigo#></b><br><#descrip#>', 'descrip'); $ittt = array('sinvp1', 'sinvp2', 'sinvp3', 'sinvp4'); $itt = array('scstp_1', 'scstp_2', 'scstp_3', 'scstp_4'); foreach ($itt as $id => $val) { $ind = $val; $campo = new inputField('Campo', $ind); $campo->grid_name = $ind . '[<#id#>]'; $campo->status = 'modify'; $campo->size = 8; $campo->autocomplete = false; $campo->css_class = 'inputnum'; $campo->append('<#' . $ittt[$id] . '#>'); $campo->disable_paste = true; $grid->column('Precio ' . ($id + 1), $campo, 'align=\'center\''); } $itt = array('margen_1', 'margen_2', 'margen_3', 'margen_4'); foreach ($itt as $id => $val) { $ind = $val; $campo = new inputField('Campo', $ind); $campo->grid_name = $ind . '[<#id#>]'; $campo->pattern = '<margen><#formcal#>|<#pond#>|<#costo#>|<#standard#>|<#existen#>|<#cantidad#>|<#scstp_' . ($id + 1) . '#>|<#iva#></margen>'; $campo->status = 'modify'; $campo->size = 3; $campo->autocomplete = false; $campo->css_class = 'inputnum'; $campo->disable_paste = true; $grid->column('Marg.' . ($id + 1), $campo, 'align=\'center\''); } $grid->column('Costo', '<tcosto><#id#>|<#iva#>|<#formcal#>|<#pond#>|<#costo#>|<#standard#>|<#existen#>|<#cantidad#></tcosto>', 'align=\'right\''); if (!$this->solo) { $action = "javascript:window.location='" . site_url('compras/scst/dataedit/show/' . $control) . "'"; $grid->button('btn_regresa', 'Regresar', $action, 'TR'); $grid->submit('pros', 'Guardar', 'BR'); } $grid->build(); $ggrid .= $grid->output; $ggrid .= form_close(); $script = '<script language="javascript" type="text/javascript"> $(function(){ $(".inputnum").numeric("."); $(".inputonlynum").numeric(); $(\'input[name^="margen_"]\').keyup(function() { nom=this.name; pos0=this.name.lastIndexOf("_"); pos1=this.name.lastIndexOf("["); pos2=this.name.lastIndexOf("]"); if(pos0>0 && pos1>0 && pos2>0){ idp = this.name.substring(pos0+1,pos1); ind = this.name.substring(pos1+1,pos2); costo = Number($("#costo\\\\["+ind+"\\\\]").val()); iva = Number($("#iva\\\\["+ind+"\\\\]").val()); margen = Number($(this).val()); precio = roundNumber((costo*100/(100-margen))*(1+(iva/100)),2); $("#scstp_"+idp+"\\\\["+ind+"\\\\]").val(precio); } }); $(\'input[name^="scstp_"]\').keyup(function() { nom=this.name; pos0=this.name.lastIndexOf("_"); pos1=this.name.lastIndexOf("["); pos2=this.name.lastIndexOf("]"); if(pos0>0 && pos1>0 && pos2>0){ idp = this.name.substring(pos0+1,pos1); ind = this.name.substring(pos1+1,pos2); precio = Number($(this).val()); costo = Number($("#costo\\\\["+ind+"\\\\]").val()); iva = Number($("#iva\\\\["+ind+"\\\\]").val()); margen=roundNumber(100-((costo*100)/(precio/(1+(iva/100)))),2); $("#margen_"+idp+"\\\\["+ind+"\\\\]").val(margen); } }); }); </script>'; $data['content'] = '<div class="alert">' . $error . '</div>'; $data['content'] .= '<div>' . $msj . '</div>'; $data['content'] .= $ggrid; if ($this->solo) { $mensaje = "<table><tr><td>Mensaje: " . $msj . "</td><td>Error: " . $error . "</td></tr></table>\n"; return $script . "\n" . $data['content']; } else { $data['title'] = heading('Cambio de precios'); $data['script'] = $script; $data['script'] .= phpscript('nformat.js'); $data['head'] = $this->rapyd->get_head(); $data['head'] = script('jquery.pack.js'); $data['head'] = script('plugins/jquery.numeric.pack.js'); $data['head'] = script('plugins/jquery.floatnumber.js'); $data['head'] .= style('estilos.css'); $this->load->view('view_ventanas', $data); } }
function inven($tabla) { if (!$this->db->table_exists($tabla)) { show_error('Inventario físico no exite'); } $tifecha = dbdate_to_human(substr($tabla, -8)); $tialmacen = substr($tabla, 3, -8); $this->rapyd->load('datagrid', 'dataobject', 'fields', 'datafilter2'); $mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'titulo' => 'Buscar Proveedor'); $bSPRV = $this->datasis->modbus($mSPRV); $link2 = site_url('inventario/common/get_linea'); $link3 = site_url('inventario/common/get_grupo'); $script = ' $(document).ready(function(){ $("#depto").change(function(){ depto(); $.post("' . $link2 . '",{ depto:$(this).val() },function(data){$("#linea").html(data);}) $.post("' . $link3 . '",{ linea:"" },function(data){$("#grupo").html(data);}) }); $("#linea").change(function(){ linea(); $.post("' . $link3 . '",{ linea:$(this).val() },function(data){$("#grupo").html(data);}) }); $("#grupo").change(function(){ grupo(); }); depto(); linea(); grupo(); }); function depto(){ if($("#depto").val()!=""){ $("#nom_depto").attr("disabled","disabled"); } else{ $("#nom_depto").attr("disabled",""); } } function linea(){ if($("#linea").val()!=""){ $("#nom_linea").attr("disabled","disabled"); } else{ $("#nom_linea").attr("disabled",""); } } function grupo(){ if($("#grupo").val()!=""){ $("#nom_grupo").attr("disabled","disabled"); } else{ $("#nom_grupo").attr("disabled",""); } }'; $filter = new DataFilter2(''); $this->db->_escape_char = ''; $this->db->_protect_identifiers = false; $filter->db->select("e.existen,e.modificado,e.contado,e.agregar,e.quitar,e.sustituir,a.tipo AS tipo,a.id,e.codigo,a.descrip,precio1,precio2,precio3,precio4,b.nom_grup AS nom_grup,a.barras,b.grupo AS grupoid,c.descrip AS nom_linea,c.linea AS linea,d.descrip AS nom_depto,d.depto AS depto,e.id AS idfis,e.despacha, a.ubica, if( a.activo = 'S', ' ' , '*' ) activo"); $filter->db->from("{$tabla} AS e"); $filter->db->join('sinv AS a', 'a.codigo=e.codigo'); $filter->db->join('grup AS b', 'a.grupo=b.grupo'); $filter->db->join('line AS c', 'b.linea=c.linea'); $filter->db->join('dpto AS d', 'c.depto=d.depto'); //$filter->db->where('activo','S'); $filter->db->where('actualizado IS NULL', '', false); //$filter->db->order_by("d.depto,c.linea,b.grupo,a.descrip"); $filter->script($script); $filter->codigo = new inputField('Código', 'codigo'); $filter->codigo->db_name = 'e.codigo'; $filter->codigo->size = 25; $filter->descrip = new inputField('Descripción', 'descrip'); $filter->descrip->db_name = 'CONCAT_WS(" ",a.descrip,a.descrip2)'; $filter->descrip->size = 25; $filter->tipo = new dropdownField('Tipo', 'tipo'); $filter->tipo->db_name = 'a.tipo'; $filter->tipo->option('', 'Todos'); $filter->tipo->option('Articulo', 'Artículo'); $filter->tipo->option('Servicio', 'Servicio'); $filter->tipo->option('Descartar', 'Descartar'); $filter->tipo->option('Consumo', 'Consumo'); $filter->tipo->option('Fraccion', 'Fracción'); $filter->tipo->style = 'width:220px;'; $filter->clave = new inputField('Clave', 'clave'); $filter->clave->size = 25; $filter->activo = new dropdownField('Activo', 'activo'); $filter->activo->option('', 'Todos'); $filter->activo->option('S', 'Si'); $filter->activo->option('N', 'No'); $filter->activo->style = 'width:220px;'; $filter->activo->db_name = 'a.activo'; $filter->proveed = new inputField('Proveedor', 'proveed'); $filter->proveed->append($bSPRV); $filter->proveed->db_name = 'CONCAT_WS("_", a.prov1, a.prov2, a.prov3)'; $filter->proveed->size = 25; $filter->depto2 = new inputField('Departamento', 'nom_depto'); $filter->depto2->db_name = 'd.descrip'; $filter->depto2->size = 10; $filter->depto = new dropdownField("Departamento", "depto"); $filter->depto->db_name = "d.depto"; $filter->depto->option('', "Seleccione un Departamento"); $filter->depto->options("SELECT depto, descrip FROM dpto WHERE tipo='I' ORDER BY depto"); $filter->depto->in = "depto2"; $filter->linea = new inputField("Linea", "nom_linea"); $filter->linea->db_name = "c.descrip"; $filter->linea->size = 10; $filter->linea2 = new dropdownField("Línea", "linea"); $filter->linea2->db_name = 'c.linea'; $filter->linea2->option('', 'Seleccione un Departamento primero'); $filter->linea2->in = 'linea'; $depto = $filter->getval('depto'); if ($depto !== false) { $filter->linea2->options("SELECT linea, descrip FROM line WHERE depto='{$depto}' ORDER BY descrip"); } else { $filter->linea2->option('', 'Seleccione un Departamento primero'); } $filter->grupo2 = new inputField('Grupo', 'nom_grupo'); $filter->grupo2->db_name = 'b.nom_grup'; $filter->grupo2->size = 10; $filter->grupo = new dropdownField('Grupo', 'grupo'); $filter->grupo->db_name = 'b.grupo'; $filter->grupo->option('', 'Seleccione una Línea primero'); $filter->grupo->in = 'grupo2'; $linea = $filter->getval('linea2'); if ($linea !== false) { $filter->grupo->options("SELECT grupo, nom_grup FROM grup WHERE linea='{$linea}' ORDER BY nom_grup"); } else { $filter->grupo->option('', 'Seleccione un Departamento primero'); } $filter->marca = new dropdownField('Marca', 'marca'); $filter->marca->option('', 'Todas'); $filter->marca->options("SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM marc ORDER BY marca"); $filter->marca->style = 'width:220px;'; $filter->ubica = new inputField('Ubicacion', 'ubica'); $filter->ubica->db_name = 'a.ubica'; $filter->ubica->size = 15; $filter->buttons('reset', 'search'); $filter->build(); function caja($campo2, $valor, $codigo, $readonly = false, $fila, $desp, $ccana) { $campo = new inputField2('Title', $campo2); $campo->status = 'create'; $campo->css_class = 'inputnum'; $campo->size = 5; $campo->insertValue = $valor; $campo->readonly = $readonly; if ($campo2 == 'c') { $campo->type = 'inputhidden'; } $campo->name = $codigo; //$campo->name = 'I'.$campo2.'_'.$codigo; $campo->id = 'I' . $campo2 . '_' . $codigo; $campo->tabindex = $desp * $ccana + $fila; $campo->build(); return $campo->output; } function pinta($modifi, $cont, $idfis, $pos) { $iidfis = "{$idfis}class"; if (empty($modifi)) { $rt = '<span class="' . $iidfis . '">' . $cont . '</span>'; } else { $rt = '<span class="' . $iidfis . '" style="color : red;">' . $cont . '</span>'; } return $rt; } $atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '0', 'screeny' => '0'); $titulo1 = anchor_popup("reportes/ver/INVFIS/{$tabla}", 'Conteo', $atts); $titulo2 = anchor_popup('reportes/ver/SINVFIS', 'Hoja de trabajo', $atts); $cana = 100; $grid = new DataGrid('Reportes -->' . $titulo1 . ' ' . $titulo2); $grid->table_id = 'conteotabla'; $grid->per_page = $cana; $grid->use_function('caja', 'pinta'); $action = "javascript:window.location='" . site_url($this->url) . "'"; $grid->button('btn_regresa', 'Regresar', $action, 'TR'); $grid->column('X', 'activo', 'activo', 'align=center'); $grid->column_orderby('Dpto', 'depto', 'd.depto', 'align=center'); $grid->column_orderby('Linea', 'linea', 'c.linea', 'align=center'); $grid->column_orderby('Grupo', 'grupoid', 'b.grupo', 'align=center'); $grid->column_orderby('Barras', 'barras', 'b.grupo', 'align=center'); $grid->column_orderby('Ubica', 'ubica', 'a.ubica', 'align=center'); $grid->column_orderby('Codigo', '<pinta><#modificado#>|<#codigo#>|<#idfis#>|a</pinta>', 'codigo', 'align=center'); $grid->column_orderby('Descripción', '<pinta><#modificado#>|<#descrip#>|<#idfis#>|b</pinta>', 'descrip'); $grid->column_orderby('P.Desp.', '<pinta><#modificado#>|<#despacha#>|<#idfis#>|d</pinta>', 'despacha', 'align=right'); $grid->column_orderby('Anterior', '<pinta><#modificado#>|<#existen#>|<#idfis#>|d</pinta>', 'existen', 'align=right'); $grid->column_orderby('Contado', '<caja>c|<#contado#>|<#idfis#>|true|<#dg_row_id#>|0|' . $cana . '</caja>', 'contado', 'align=right'); $grid->column('Agregar', '<caja>a|<#agregar#>|<#idfis#>|false|<#dg_row_id#>|1|' . $cana . '</caja>'); $grid->column('Quitar', '<caja>q|<#quitar#>|<#idfis#>|false|<#dg_row_id#>|2|' . $cana . '</caja>'); $grid->column('Sustituir', '<caja>s||<#idfis#>|false|<#dg_row_id#>|3|' . $cana . '</caja>'); $grid->build(); //echo $grid->db->last_query(); $data['script'] = '<script language="javascript" type="text/javascript"> function traer(cod){ $.post("' . site_url($this->url . 'traer') . '",{ codigo:cod,tabla:"' . $tabla . '" },function(data){ $("#Ic_"+cod).val(data); $("#Ic_"+cod+"_val").text(data); }) } $(function(){ $(".inputnum").numeric("."); $("input[id^=\'I\']").focus(function(){ var cod =$(this).attr("name"); traer(cod); $(this).select(); }); $("input[id^=\'I\']").click(function(){ $(this).select(); }); $("input[id^=\'Ia_\']").change(function(){ var cod =$(this).attr("name"); var val = $("#Ia_"+cod).val(); var con = $("#Ic_"+cod).val(); $.post("' . site_url($this->url . 'agregar') . '",{ codigo:cod,valor:val,tabla:"' . $tabla . '",contado:con },function(data){ $("#Ia_"+cod).val(0); if(data.length>0){ alert(data); }else{ $("."+cod+"class").attr("style","color:orange;"); } traer(cod); }); }); $("input[id^=\'Iq_\']").change(function(){ var cod =$(this).attr("name"); var val = $("#Iq_"+cod).val(); var con = $("#Ic_"+cod).val(); $.post("' . site_url($this->url . 'quitar') . '",{ codigo:cod,valor:val,tabla:"' . $tabla . '",contado:con },function(data){ $("#Iq_"+cod).val(0); if(data.length>0){ alert(data); }else{ $("."+cod+"class").attr("style","color:orange;"); } traer(cod); }); }); $("input[id^=\'Is_\']").change(function(){ var cod =$(this).attr("name"); var val = $("#Is_"+cod).val(); var con = $("#Ic_"+cod).val(); $.post("' . site_url($this->url . 'sustituir') . '",{ codigo:cod,valor:val,tabla:"' . $tabla . '",contado:con },function(data){ $("#Is_"+cod).val(""); if(data.length>0){ alert(data); }else{ $("."+cod+"class").attr("style","color:orange;"); } traer(cod); }); }); }); </script> <style type="text/css">#conteotabla tr:hover { background-color: #ffff99; }</style>'; $leyenda = '<span style="color:orange">Recién contado</span> '; $leyenda .= '<span style="color:red">Ya contado</span> '; $leyenda .= '<span style="color:black">No se ha contado</span> '; $salida = anchor($this->url, 'Regresar'); $data['content'] = $grid->output . $leyenda; $data['filtro'] = $filter->output; $data['title'] = heading("Conteo de inventario, fecha {$tifecha}, almacén {$tialmacen}"); $data['head'] = script('jquery.js'); $data['head'] .= script('plugins/jquery.numeric.pack.js') . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function clinconsissobreapl($id_scli) { $this->rapyd->load('datagrid'); $this->rapyd->uri->keep_persistence(); $persistence = $this->rapyd->session->get_persistence('supervisor/mantenimiento/clinconsis', $this->rapyd->uri->gfid); $back = isset($persistence['back_uri']) ? $persistence['back_uri'] : 'supervisor/mantenimiento/clinconsis'; $dbid_scli = intval($id_scli); $cod_cli = $this->datasis->dameval("SELECT TRIM(cliente) AS val FROM scli WHERE id={$dbid_scli}"); if (empty($cod_cli)) { show_error('Error en los parametros'); /*redirect($back);*/ } $dbcod_cli = $this->db->escape($cod_cli); $mSQL = "SELECT\n\t\t\taa.tipo_doc,aa.transac,aa.numero,aa.monto,bb.monto AS aplicado\n\t\t\tFROM smov AS aa\n\t\t\tJOIN\n\t\t\t\t(SELECT\n\t\t\t\t\ta.tipoccli,a.numccli,SUM(a.abono) AS monto\n\t\t\t\tFROM itccli AS a\n\t\t\t\tWHERE a.cod_cli={$dbcod_cli} AND a.tipoccli IN ('NC','AB','ND')\n\t\t\t\tGROUP BY a.tipoccli,a.numccli ) AS bb\n\t\t\tON aa.tipo_doc=bb.tipoccli AND aa.numero=bb.numccli\n\t\t\tWHERE bb.monto>aa.monto"; $query = $this->db->query($mSQL); $data = array(); foreach ($query->result() as $row) { $data[] = array('tipo_doc' => $row->tipo_doc, 'transac' => $row->transac, 'numero' => $row->numero, 'monto' => $row->monto, 'aplicado' => $row->aplicado); } $grid = new DataGrid('Lista', $data); $grid->per_page = 1000; //$grid->use_function('str_replace'); $grid->column('Tipo Doc', 'tipo_doc'); $grid->column('Numero', 'numero'); $grid->column('Monto', '<nformat><#monto#></nformat>', 'align=\'right\''); $grid->column('Aplicado', '<nformat><#aplicado#></nformat>', 'align=\'right\''); $action = 'javascript:window.location=\'' . site_url($back) . '\''; $grid->button('btn_reg', 'Regresar', $action, 'TR'); $grid->build(); $data['content'] = $grid->output; $data['title'] = heading('Efectos sobre-aplicados al cliente ' . $cod_cli); $data['head'] = script('jquery.js'); $data['head'] .= script('plugins/jquery.checkboxes.pack.js') . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function arancif($id) { $this->rapyd->load('datagrid', 'fields'); $error = ''; if ($this->input->post('pros') !== FALSE) { $pmontos = $this->input->post('arancif'); foreach ($pmontos as $iid => $cant) { if (!is_numeric($cant)) { $error .= "{$cant} no es un valor numérico<br>"; } else { $data = array('arancif' => $cant); $dbid = $this->db->escape($iid); $where = "id = {$dbid}"; $mSQL = $this->db->update_string('itordi', $data, $where); $this->db->simple_query($mSQL); } } } $this->_calcula($id); $ggrid = form_open('/import/ordi/arancif/' . $id); $monto = new inputField('Arancif', 'arancif'); $monto->grid_name = 'arancif[<#id#>]'; $monto->status = 'modify'; $monto->size = 12; $monto->autocomplete = false; $monto->css_class = 'inputnum'; $expli = 'En caso de que en la aduana calcule el valor del arancel en base a un costo estadístico diferente puede asignar el nuevo costo en los campos siguientes, en caso de dejarlo en cero se tomará el valor del importe CIF real.'; $select = array('a.codigo', 'a.descrip', 'a.cantidad', 'a.importecif', 'a.id', 'a.arancif', 'a.montoaran', 'a.arancel', 'a.importeciflocal'); $grid = new DataGrid($expli); $grid->db->select($select); $grid->db->from('itordi AS a'); $grid->db->join('ordi AS b', 'a.numero=b.numero'); $grid->db->where('a.numero', $id); //$grid->order_by('a.numero','desc'); $grid->column_orderby('Código', 'codigo', 'codigo'); $grid->column_orderby('Descripción', 'descrip', 'descrip'); $grid->column_orderby('Cantidad', '<nformat><#cantidad#></nformat>', 'cantidad', 'align=\'right\''); $grid->column_orderby('Importe CIF Real', '<nformat><#importeciflocal#></nformat>', 'importeciflocal', 'align=\'right\''); $grid->column_orderby('Monto del arancel', '<b><nformat><#montoaran#></nformat></b> (<nformat><#arancel#></nformat>%)', 'montoaran', 'align=\'right\''); $grid->column('Importe CIF estadístico en moneda local', $monto, 'align=\'right\''); $grid->submit('pros', 'Guardar y calcular', 'BR'); $grid->button('btn_reg', 'Regresar', "javascript:window.location='" . site_url('/import/ordi/dataedit/show/' . $id) . "'", 'BR'); $grid->build(); //echo $grid->db->last_query(); $ggrid .= $grid->output; $ggrid .= form_close(); $script = ' <script type="text/javascript"> $(function() { $(".inputnum").numeric("."); }); </script>'; $data['content'] = '<div class=\'alert\'>' . $error . '</div>' . $ggrid; $data['title'] = '<h1>Asignación en los montos estadísticos para el cálculo de los aranceles</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 filteredgrid() { $this->rapyd->load('datafilter', 'datagrid'); $filter = new DataFilter($this->titp, 'r_recibo'); $user = $this->session->userdata('usuario'); $usere = $this->db->escape($user); $r_caja = $this->datasis->damerow("SELECT r_caja.id,punto_codbanc FROM r_caja JOIN usuario ON r_caja.id=usuario.caja WHERE us_codigo ={$usere}"); if (count($r_caja) > 0) { $caja = $r_caja['id']; $punto_codbanc = $r_caja['punto_codbanc']; } else { $caja = 0; } if ($caja > 0) { $filter->db->where('caja', $caja); } $filter->id = new inputField('Ref.', 'id'); $filter->id->rule = 'max_length[11]'; $filter->id->size = 13; $filter->id->maxlength = 11; $filter->id->clause = 'where'; $filter->id->operator = '='; $filter->fecha = new dateField('Fecha', 'fecha'); $filter->fecha->rule = 'chfecha'; $filter->fecha->size = 10; $filter->fecha->maxlength = 8; $filter->fecha->clause = 'where'; $filter->fecha->operator = '='; $filter->numero = new inputField('Numero.', 'numero'); $filter->numero->rule = 'max_length[11]'; $filter->numero->size = 13; $filter->numero->maxlength = 11; $filter->numero->clause = 'where'; $filter->numero->operator = '='; $filter->rifci = new inputField('rifci', 'rifci'); $filter->rifci->rule = 'max_length[12]'; $filter->rifci->size = 14; $filter->rifci->maxlength = 12; $filter->nombre = new inputField('Nombre', 'nombre'); $filter->nombre->rule = 'max_length[100]'; $filter->nombre->size = 40; $filter->nombre->maxlength = 100; $filter->monto = new inputField('Monto.', 'monto'); $filter->monto->rule = 'max_length[11]'; $filter->monto->size = 13; $filter->monto->maxlength = 11; $filter->caja = new dropdownField("Caja", "cajas"); $filter->caja->option("", ""); $filter->caja->options("SELECT id,nombre FROM r_caja "); $filter->caja->db_name = 'r_recibo.caja'; $filter->buttons('reset', 'search'); $filter->build(); $uri = anchor($this->url . 'dataedit/show/<raencode><#id#></raencode>', '<#id#>'); $grid = new DataGrid(''); $grid->order_by('id', 'desc'); $grid->per_page = 40; $grid->column_orderby('Ref.', "{$uri}", 'id', 'align="left"'); $grid->column_orderby('Numero', "numero", 'numero', 'align="left"'); $grid->column_orderby('Fecha', "<dbdate_to_human><#fecha#></dbdate_to_human>", 'fecha', 'align="center"'); $grid->column_orderby('Rif/CI', "rifci", 'rifci', 'align="left"'); $grid->column_orderby('Nombre', "nombre", 'nombre', 'align="left"'); $grid->column_orderby('Monto', "<numbre_format><#monto#></numbre_format>", 'monto', 'align="left"'); $grid->column_orderby('Caja', "caja", 'caja', 'align="left"'); $action = "javascript:window.location='" . site_url('recaudacion/r_abonos/filteredgrid') . "'"; $grid->button("ir_cobranza", "Ir a Cobranza", $action, "TL"); $grid->add($this->url . 'dataedit/create'); $grid->build(); $data['filtro'] = $filter->output; $data['content'] = $grid->output; $data['head'] = $this->rapyd->get_head() . script('jquery.js'); $data['title'] = $this->titp . ($this->cajan ? " CAJA {$this->cajan}" : ""); $this->load->view('view_ventanas', $data); }
function auditsprv() { $this->rapyd->load('datagrid', 'dataform'); $qformato = $this->datasis->formato_cpla(); $mCPLA = array('tabla' => 'cpla', 'columnas' => array('codigo' => 'Código', 'descrip' => 'Descripción'), 'filtro' => array('codigo' => 'Código', 'descrip' => 'Descripción'), 'retornar' => array('codigo' => 'cuenta'), 'titulo' => 'Buscar Cuenta', 'where' => "codigo LIKE \"{$qformato}\""); $bcpla = $this->datasis->modbus($mCPLA); $atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '0', 'screeny' => '0'); $uri = anchor_popup('compras/sprv/dataedit/modify/<#id#>', '<#proveed#>', $atts); $grid = new DataGrid('Registros cuya cuenta no existe en el plan de cuentas'); $grid->db->select(array('a.proveed', 'a.rif', 'a.nombre', 'a.cuenta', 'a.grupo', 'a.id')); $grid->db->from('sprv AS a'); $grid->db->join('cpla AS b', 'a.cuenta=b.codigo', 'LEFT'); $grid->db->where('b.codigo IS NULL'); $grid->per_page = 40; $grid->column_orderby('Código', $uri, 'proveed'); $grid->column_orderby('Grupo', 'grupo', 'grupo'); $grid->column_orderby('Nombre', 'nombre', 'nombre'); $grid->column_orderby('Rif', 'rif', 'rif'); $grid->column_orderby('Cuenta', 'cuenta', 'cuenta'); $action = "javascript:window.location='" . site_url('contabilidad/casi/auditoria') . "'"; $grid->button('btn_regresa', 'Regresar', $action, 'TR'); $grid->build(); $form = new DataForm('contabilidad/casi/auditsprv/process'); $form->cuenta = new inputField('Cuenta contable', 'cuenta'); $form->cuenta->rule = 'trim|required|existecpla'; $form->cuenta->size = 15; $form->cuenta->append($bcpla . 'Coloque la cuenta contable para ser asginada a todos los registros encontrados y presione cambiar.'); $form->grupo = new dropdownField('Grupo', 'grupo'); $form->grupo->option('', 'Todos'); $form->grupo->options("SELECT grupo,grupo AS val FROM sprv GROUP BY grupo"); $form->grupo->style = 'width:140px'; $form->grupo->append('Adicionalmente puede elegir un grupo para condicionar la asignación'); $form->submit('btnsubmit', 'Cambiar'); $form->build_form(); if ($form->on_success()) { $cuenta = $this->db->escape($form->cuenta->newValue); $grupo = $form->grupo->newValue; if (!empty($grupo)) { $ww = ' AND a.grupo=' . $this->db->escape($grupo); } else { $ww = ''; } $mSQL = 'UPDATE sprv AS a LEFT JOIN cpla AS b ON a.cuenta=b.codigo SET a.cuenta=' . $cuenta . ' WHERE b.codigo IS NULL' . $ww; $this->db->simple_query($mSQL); redirect('contabilidad/casi/auditsprv'); } $data['content'] = $grid->recordCount > 0 ? $form->output : ''; $data['content'] .= $grid->output; $data['head'] = $this->rapyd->get_head(); $data['title'] = heading('Auditoria de cuentas en proveedores'); $this->load->view('view_ventanas', $data); }
function procesar($id_tabla = null) { $this->rapyd->load('dataedit', 'datagrid', 'fields'); if (empty($id_tabla)) { show_error('Faltan parametros'); } $id_tabla = intval($id_tabla); if ($id_tabla <= 0) { show_error('Error en parametros'); } $tabla = $this->tabla; $select = $titu = array(); //Se trae la cantidad de columnas $dbide_tabla = $this->db->escape($id_tabla); $ccolum = $this->datasis->dameval("SELECT MAX(aa.cana) FROM (SELECT COUNT(*) AS cana FROM {$tabla} WHERE id_tabla={$dbide_tabla} GROUP BY fila) AS aa"); //Se trae la definicion de la tabla //$query = $this->db->query("SELECT columna,valor,tipo FROM `impor_data` WHERE fila=0 AND id_tabla=${dbide_tabla}"); //if($query->num_rows()>0){ // foreach ($query->result() as $row){ // $titu[$row->columna]=$row->valor; // } //} $options = array('' => 'Ignorar', 'codigo' => 'Código', 'descrip' => 'Descripción', 'standard' => 'Costo Estandar', 'exmin' => 'Mínimo', 'exmax' => 'Máximo', 'marca' => 'Marca'); if ($this->secu->essuper()) { $options['ultimo'] = 'Costo Último'; $options['pond'] = 'Costo Promedio'; } $colunma = new dropdownField('Tabla', 'tabla'); $colunma->options($options); $colunma->status = 'create'; $colunma->style = 'width:100%;'; $colunma->rule = 'required'; $grid = new DataGrid('Tabla importada'); $grid->db->from($tabla); $grid->db->where('id_tabla', $id_tabla); //$grid->db->where('fila >',0); $grid->db->groupby('fila'); $grid->db->orderby('fila'); $grid->per_page = 25; $select[] = '(fila+1) AS fila'; $grid->column('Fila', '<b><#fila#></b>', 'align="right"'); for ($i = 0; $i < $ccolum; $i++) { $select[] = "GROUP_CONCAT(IF(columna={$i},valor,NULL)) AS c{$i}"; //$titulo=(isset($titu[$i]))? $titu[$i]: 'Columna '.($i+1); $colunma->name = $colunma->id = "c{$i}"; $colunma->build(); $titulo = 'Columna ' . ($i + 1) . $colunma->output; $grid->column_orderby($titulo, "c{$i}", "c{$i}"); } $grid->db->select($select); $action = "javascript:window.location='" . site_url($this->url . 'load') . "'"; $grid->button('btn_regresa', 'Regresar', $action, 'TR'); $grid->build(); //echo $grid->db->last_query(); $form = new DataForm($this->url . 'procesar/' . $id_tabla . '/process'); $form->tabla = new dropdownField('Tabla', 'tabla'); $form->tabla->option('sinv', 'Inventario'); //$form->tabla->option('sinvpromo','Promociones'); $form->tabla->rule = 'required|enum[sinv,sinvpromo]'; $form->fila = new inputField('Procesar a partir de la fila', 'fila'); $form->fila->append(' Incluyente.'); $form->fila->size = 5; $form->fila->insertValue = '1'; $form->fila->rule = 'numeric|positive'; $form->errores = new checkboxField('Ignorar Errores', 'errores', 'S', 'N'); $form->errores->insertValue = 'N'; $form->errores->rule = 'enum[S,N]'; $form->container = new containerField('tabla', $grid->output); $form->submit('btnsubmit', 'Procesar'); $form->build_form(); if ($form->on_success()) { $def = array(); $val = false; for ($o = 0; $o < $i; $o++) { $itdef = $this->input->post('c' . $o); if (!empty($itdef)) { if (!in_array($itdef, $def)) { $def[$o] = $itdef; } else { $val = true; $form->error_string = 'Columna ' . ($o + 1) . ' tiene la defición repetida.'; $form->build_form(); break; } } } if (!$val) { $rt = $this->_validar($form->tabla->newValue, $id_tabla, $def, intval($form->fila->newValue), $form->errores->newValue); if (!$rt) { $form->error_string = $this->val_error; $form->build_form(); } else { $rt = $this->_procesar($form->tabla->newValue, $id_tabla, $def); if ($rt) { redirect($this->url . 'resultado/' . $this->afecta); } else { $form->error_string = 'Hubo problemas para cagar la data.'; $form->build_form(); } } } } $data['content'] = $form->output; $data['title'] = heading('Tabla Importada'); $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function filteredgrid() { $this->rapyd->load('datafilter', 'datagrid'); $mBANC = array('tabla' => 'banc', 'columnas' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'tbanco' => 'T Banco', 'numcuent' => 'Cuenta', 'saldo' => 'Saldo'), 'filtro' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'tbanco' => 'T Banco', 'saldo' => 'Saldo'), 'retornar' => array('codbanc' => 'codbanc'), 'where' => 'activo = "S"', 'titulo' => 'Buscar Bancos'); $bBANC = $this->datasis->p_modbus($mBANC, "banc"); $filter = new DataFilter($this->titp); $filter->db->select(array('b.abono id', 'c.nombre', 'GROUP_CONCAT(c.numero SEPARATOR " ") numero', 'c.nombre', 'c.rifci', 'c.fecha', 'GROUP_CONCAT(c.id SEPARATOR " ") id_recibo', 'GROUP_CONCAT(d.cheque SEPARATOR " ") cheque', 'GROUP_CONCAT(IF(d.tipo_doc="EF","Efectivo",IF(d.tipo_doc="DP","Deposito",IF(d.tipo_doc="DB","T. Debito",IF(d.tipo_doc="CR","T. Credito",IF(d.tipo_doc="DF","Diferencia","")))))) tipo_doc', 'd.monto monto_banco', 'c.monto monto_recibo')); $filter->db->from('r_abonosit b'); $filter->db->join('r_recibo c', 'b.recibo=c.id'); $filter->db->join('r_mbanc d', 'b.abono=d.abono'); $filter->db->groupby('b.abono'); $user = $this->session->userdata('usuario'); $usere = $this->db->escape($user); $r_caja = $this->datasis->damerow("SELECT r_caja.id,punto_codbanc FROM r_caja JOIN usuario ON r_caja.id=usuario.caja WHERE us_codigo ={$usere}"); if (count($r_caja) > 0) { $caja = $r_caja['id']; $punto_codbanc = $r_caja['punto_codbanc']; } else { $caja = 0; } if ($caja > 0) { $filter->db->where('c.caja', $caja); } $filter->numero = new inputField('Recibo', 'numero'); $filter->numero->rule = 'max_length[11]'; $filter->numero->size = 13; $filter->numero->clause = 'where'; $filter->numero->operator = '='; $filter->numero->group = 'Datos Recibo'; $filter->id2 = new inputField('Ref Recibo', 'id2'); $filter->id2->rule = 'max_length[11]'; $filter->id2->size = 13; $filter->id2->maxlength = 11; $filter->id2->db_name = "c.id"; $filter->id2->clause = 'where'; $filter->id2->operator = '='; $filter->id2->group = 'Datos Recibo'; $filter->nombre = new inputField('Nombre', 'nombre'); $filter->nombre->size = 20; $filter->nombre->group = "Contribuyente"; $filter->nombre->group = 'Datos Recibo'; $filter->rifci = new inputField('Rif/Ced', 'rifci'); $filter->rifci->rule = 'max_length[13]'; $filter->rifci->size = 15; $filter->rifci->maxlength = 13; $filter->rifci->group = "Contribuyente"; $filter->rifci->group = 'Datos Recibo'; $filter->monto = new inputField('Monto Recibo', 'monto'); $filter->monto->rule = 'max_length[13]'; $filter->monto->size = 15; $filter->monto->maxlength = 13; $filter->monto->db_name = "c.monto"; $filter->monto->group = 'Datos Recibo'; $filter->id = new inputField('Ref', 'id'); $filter->id->rule = 'max_length[11]'; $filter->id->size = 13; $filter->id->maxlength = 11; $filter->id->db_name = "b.abono"; $filter->id->clause = 'where'; $filter->id->operator = '='; $filter->id->group = 'Datos Bancarios'; $filter->codbanc = new inputField("Banco", 'codbanc'); $filter->codbanc->size = 6; $filter->codbanc->append($bBANC); $filter->codbanc->db_name = "d.codbanc"; $filter->codbanc->group = 'Datos Bancarios'; $filter->fecha = new dateonlyField('Fecha', 'fecha'); $filter->fecha->db_name = "d.fecha"; //$filter->fecha->rule ='chfecha'; $filter->fecha->size = 10; $filter->fecha->maxlength = 8; $filter->fecha->clause = 'where'; $filter->fecha->operator = '='; $filter->fecha->group = 'Datos Bancarios'; $filter->tipo_doc = new dropdownField("Tipo Documento", "tipo_doc"); $filter->tipo_doc->db_name = 'd.tipo_doc'; $filter->tipo_doc->style = "width:130px;"; $filter->tipo_doc->option("", ""); $filter->tipo_doc->option("EF", "Efectivo"); $filter->tipo_doc->option("DP", "Deposito"); $filter->tipo_doc->option("DB", "Tarjeta Débito"); $filter->tipo_doc->option("CR", "Tarjeta Credito"); $filter->tipo_doc->option("DF", "Diferencia"); $filter->cheque = new inputField("Transaccion", "cheque"); $filter->cheque->db_name = "d.cheque"; $filter->cheque->size = 10; $filter->cheque->group = 'Datos Bancarios'; $filter->montob = new inputField('Monto Banco', 'montob'); $filter->montob->rule = 'max_length[13]'; $filter->montob->size = 15; $filter->montob->maxlength = 13; $filter->montob->db_name = "d.monto"; $filter->montob->group = 'Datos Bancarios'; $filter->buttons('reset', 'search'); $filter->build(); $uri = anchor($this->url . 'dataedit/show/<raencode><#id#></raencode>', '<#id#>'); $grid = new DataGrid(''); $grid->order_by('b.abono ', 'desc'); $grid->per_page = 40; $grid->column_orderby('Ref.', "{$uri}", 'id', 'align="left"'); $grid->column_orderby('Recibo', "numero", 'numero', 'align="left"'); $grid->column_orderby('Ref Recibo', "id_recibo", 'id_recibo', 'align="left"'); $grid->column_orderby('Nombre', "nombre", 'nombre', 'align="left"'); $grid->column_orderby('Documento', "tipo_doc", 'tipo_doc', 'align="left"'); $grid->column_orderby('Transacciones', "cheque", 'cheque', 'align="left"'); $grid->column_orderby('Monto de un Recibo', "monto_recibo", 'c.monto', 'align="right"'); $grid->column_orderby('Monto de una Transaccion Bancaria', "monto_banco", 'd.monto', 'align="right"'); $action = "javascript:window.location='" . site_url('recaudacion/r_recibo/filteredgrid') . "'"; $grid->button("ir_cobranza", "Ir a Recibos", $action, "TL"); $grid->add($this->url . 'dataedit/create'); $grid->build(); $data['filtro'] = $filter->output; $data['content'] = $grid->output; $data['head'] = $this->rapyd->get_head() . script('jquery.js'); $data['title'] = $this->titp . ($this->cajan ? " CAJA {$this->cajan}" : ""); $this->load->view('view_ventanas', $data); }
function configurar() { $this->rapyd->load("datafilter", "datagrid"); $uri = anchor('finanzas/libros/cedit/show/<#metodo#>', '<#nombre#>'); $link = site_url('/finanzas/libros'); $grid = new DataGrid("Seleccione las opciones que desea activar para el modulo"); $grid->use_function('form_checkbox'); $grid->db->select(array('nombre', 'IF(tipo="D","Descarga","Generar") AS tipo', 'activo="S" AS activo', 'metodo')); $grid->db->from('libros'); $grid->order_by("tipo", "asc"); $grid->column("Activo", "<form_checkbox><#metodo#>|<#metodo#>|<#activo#></form_checkbox>", 'align="center"'); $grid->column("Nombre", $uri); $grid->column("Tipo", "tipo"); $grid->add("finanzas/libros/cedit/create"); $grid->button('back', RAPYD_BUTTON_BACK, "javascript:window.location='{$link}'", "BL"); $grid->build(); //echo $grid->db->last_query(); $link = site_url('/finanzas/libros/activar'); $data['script'] = '<script type="text/javascript"> $(document).ready(function() { $(":checkbox").click(function () { activar($(this).attr("value")); }); }); function activar(metodo){ var url = "' . $link . '"+"/"+metodo; $.ajax({ url: url, success: function(msg){ if(msg=0) alert("Error"); } }); } </script>'; $data['content'] = '<form>' . $grid->output . '</form>'; $data['title'] = "<h1>Configuracion de libros</h1>"; $data["head"] = script("jquery-1.2.6.pack.js") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function _num_compra($control, $cana, $formato) { $dbcontrol = $this->db->escape($control); if ($formato == 'txt') { $tabla = form_open('formatos/descargartxt/' . $this->formato); } else { $tabla = form_open('forma/ver/' . $this->formato); } $sel = array('a.barras AS barras', 'a.precio2 AS precio2', 'a.grupo AS grupoid', 'a.precio3 AS precio3', 'a.codigo AS codigo', 'a.descrip AS descrip', 'a.precio1 AS precio', 'b.control AS control', 'a.pfecha1 AS cfecha', 'a.iva'); $grid = new DataGrid('Lista de artículos a imprimir'); $grid->db->select($sel); $grid->db->from('sinv AS a'); $grid->db->join('itscst AS b', 'a.codigo=b.codigo'); $grid->db->where('b.control', $control); $grid->column('Código', 'codigo'); $grid->column('Descripción', 'descrip'); $grid->column('Precio', 'precio', 'align=\'right\''); $grid->button('btn_undo', 'Regresar', 'javascript:window.location=\'' . site_url('inventario/etiqueta_sinv/num_compra') . '\'', 'BL'); $grid->button('btn_gene', 'Generar', 'javascript:this.form.submit();', 'BL'); $grid->build(); if ($grid->recordCount > 0) { $data = array('cant' => $cana, 'consul' => $this->db->last_query()); $tabla .= form_hidden($data); $tabla .= $grid->output; //.form_submit('mysubmit', 'Generar'); $tabla .= form_close(); } else { $tabla = 'No se consiguieron productos asociados a esa compra'; } return $tabla; }