function vista() { $this->rapyd->load("datagrid2"); $f1 = $this->input->post('fechad'); $f2 = $this->input->post('fechah'); $fechad = $this->db->escape(human_to_dbdate($f1)); $fechah = $this->db->escape(human_to_dbdate($f2)); $codigoadm = ''; $fondo = ''; $codigoadm2 = $this->db->escape($this->input->post('codigoadm')); $fondo2 = $this->db->escape($this->input->post('fondo')); function blanco($codigo) { if ($codigo > 0) { $codigo = str_pad($codigo, 8, '0', STR_PAD_LEFT); } return $codigo; } function union($fecha, $codigo) { return date('Ym', strtotime($fecha)) . str_pad($codigo, 8, '0', STR_PAD_LEFT); } $uri = anchor($this->url . 'dataedit/show/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>'); //$cant = $this->datasis->dameval("SELECT COUNT(*) //JOIN pades b ON a.numero = b.pago //JOIN desem c ON b.desem = c.numero //WHERE c.status='D2' AND reten >0 AND fdesem>=$fechad AND fdesem<= $fechah"); $query = "SELECT COUNT(*) FROM ("; $query .= "\r\n\t\tSELECT '',a.numero,a.impmunicipal,c.fdesem,factura,controlfac,fechafac,a.fmunicipal,c.cod_prov FROM odirect a \r\n\t\tJOIN pades b ON a.numero = b.pago\r\n\t\tJOIN desem c ON b.desem = c.numero\r\n\t\tJOIN sprv p ON c.cod_prov = p.proveed\r\n\t\tWHERE c.status='D2' AND impmunicipal >0 AND fdesem>={$fechad} AND fdesem<= {$fechah} AND MID(a.status,1,1)<>'F' AND (a.mmuni IS NULL) "; if (!empty($codigoadm)) { $query .= " AND a.estadmin='{$codigoadm}'"; } if (!empty($fondo)) { $query .= " AND a.fondo='{$fondo}'"; } $query .= "\r\n\t\t)a "; $cant = $this->datasis->dameval($query); $this->db->query("DROP TABLE IF EXISTS MUNICIPAL"); $query = "\r\n\t\tCREATE TABLE MUNICIPAL SELECT * FROM ("; $query .= "\r\n\t\t\r\n\t\tSELECT a.numero,a.impmunicipal,c.fdesem,factura,controlfac,fechafac,a.fmunicipal,c.cod_prov,a.estadmin codigoadm,a.fondo FROM odirect a \r\n\t\tJOIN pades b ON a.numero = b.pago\r\n\t\tJOIN desem c ON b.desem = c.numero\r\n\t\tJOIN sprv p ON c.cod_prov = p.proveed\r\n\t\tWHERE c.status='D2' AND impmunicipal >0 AND fdesem>={$fechad} AND fdesem<= {$fechah} AND MID(a.status,1,1)<>'F' AND (a.mmuni IS NULL)"; if (!empty($codigoadm)) { $query .= " AND a.estadmin='{$codigoadm}'"; } if (!empty($fondo)) { $query .= " AND a.fondo='{$fondo}'"; } $query .= "\r\n\t\t)a JOIN sprv b ON a.cod_prov = b.proveed "; $this->db->query($query); $grid = new DataGrid2("Lista de " . $this->titp); $grid->db->from("MUNICIPAL"); $grid->order_by("numero", "desc"); $grid->per_page = 1000; $grid->use_function('substr', 'str_pad', 'blanco', 'union'); $grid->use_function('sta'); $grid->column("orden de Pago", "<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>"); $grid->column("O. Compra", "<blanco><#ocompra#>|8|0|STR_PAD_LEFT</blanco>"); $grid->column("Emision", "<dbdate_to_human><#fmunicipal#></dbdate_to_human>", "align='center'"); $grid->column("Factura", "factura"); $grid->column("Nro. Control", "controlfac"); $grid->column("Fecha Fac", "<dbdate_to_human><#fechafac#></dbdate_to_human>", "align='center'"); $grid->column("Proveedor", "nombre"); $grid->column("RIF", "rif"); $grid->column("Monto", "<number_format><#impmunicipal#>|2|,|.</number_format>", "align='right'"); $grid->column("Est. Admin", "codigoadm"); $grid->column("Fondo", "fondo"); $grid->totalizar('impmunicipal'); $grid->build(); //echo $grid->db->last_query(); //exit(); $campo = "\r\n \t\t<input size='100' type='hidden' name='fechad' value='{$f1}'>\r\n \t\t<input size='100' type='hidden' name='fechah' value='{$f2}'>\r\n \t\t<input size='100' type='hidden' name='cant' value='{$cant}'>\r\n \t\t<input size='100' type='hidden' name='codigoadm' value='{$codigoadm}'>\r\n \t\t<input size='100' type='hidden' name='fondo' value='{$fondo}'>\r\n \t\t"; $data['content'] = anchor($this->url . "nuevo", 'Ir atras') . $grid->output . form_open($this->url . 'guardar') . $campo . form_submit('mysubmit', 'Guardar') . form_close(); $data['title'] = " {$this->titp} "; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function filteredgrid() { $this->rapyd->load("datafilter", "datagrid2"); $scli = array('tabla' => 'scli', 'columnas' => array('cliente' => 'Código Cliente', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('cliente' => 'Código Cliente', 'nombre' => 'Nombre'), 'retornar' => array('cliente' => 'cliente'), 'titulo' => 'Buscar Cliente'); $boton = $this->datasis->modbus($scli); $filter = new DataFilter("Filtro de Control de Tiket"); $select = array("a.id as idm", "a.sucursal", "a.asignacion", "a.idt as idt", "a.padre", "a.pertenece", "a.prioridad", "a.usuario as usuarios", "a.contenido", "a.estampa", "a.actualizado", "a.estado", "b.id", "b.cliente as clientes", "b.ubicacion", "b.url", "b.basededato", "b.puerto", "b.puerto", "b.usuario", "b.clave", "b.observacion", "c.nombre", "a.minutos"); $filter->db->select($select); $filter->db->from("tiketc AS a"); $filter->db->join("tiketconec AS b", "a.sucursal=b.id"); $filter->db->join("scli AS c", "b.cliente=c.cliente"); $filter->fechad = new dateonlyField("Fecha Desde", "fechad", 'd/m/Y'); $filter->fechad->clause = "where"; $filter->fechad->db_name = "estampa"; $filter->fechad->operator = ">="; $filter->fechad->size = 12; $filter->fechah = new dateonlyField("Fecha Hasta", "fechah", 'd/m/Y'); $filter->fechah->clause = "where"; $filter->fechah->db_name = "estampa"; $filter->fechah->operator = "<="; $filter->fechah->size = 12; $filter->estado = new dropdownField("Estado", "estado"); $filter->estado->option("", "Todos"); $filter->estado->options($this->estado); $filter->prioridad = new dropdownField("Prioridad", "prioridad"); $filter->prioridad->option("", "Todos"); $filter->prioridad->options($this->prioridad); $filter->contenido = new inputField("Contenido", "contenido"); //$filter->contenido->clause ="likesensitive"; //$filter->contenido->append("Sencible a las Mayuscúlas"); $filter->asignacion = new dropdownField("Asignacion", "asignacion"); $filter->asignacion->option("", "Todos"); $filter->asignacion->options("SELECT codigo, codigo as value FROM tiketservi"); $filter->asignacion->style = "width:150px"; $filter->cliente = new inputField("Cliente", "cliente"); $filter->cliente->size = 20; $filter->cliente->db_name = "c.cliente"; $filter->cliente->append($boton); $filter->idt = new inputField("Numero", "idt"); $filter->idt->size = 20; $filter->idt->db_name = "idt"; $filter->buttons("reset", "search"); $filter->build(); $grid = new DataGrid2("Lista de Control de Tiket"); $grid->order_by("a.id", "desc"); $grid->per_page = 20; $link = anchor("supervisor/tiketc/dataedit/modify/<#idm#>", "<#idm#>"); $grid->column("Id", $link); $grid->column("Numero tiket", "idt"); $grid->column("Fecha de Ingreso", "<dbdate_to_human><#estampa#>|d/m/Y h:m:s</dbdate_to_human>"); $grid->column("Cliente", "nombre"); $grid->column("Usuario", "usuarios"); $grid->column("Contenido", "contenido"); $grid->column("Prioridad", "prioridad"); $grid->column("Estado", "estado"); $grid->column("Asignacion", "asignacion"); $grid->column("Tiempo", "minutos"); //$grid->column("URL","url"); //$resp=anchor("http://merida.matloca.com/proteoerp/supervisor/tiket/dataedit/pertenece/<#idt#>/create"", 'IR'); $resp = '<a href="http://<#url#>/proteoerp/supervisor/tiket/dataedit/pertenece/<#idt#>/create">Ir</a>'; //$resp='http://merida.matloca.com/proteoerp/supervisor/tiket/dataedit/pertenece/67/create'; $grid->column("Responder", $resp); $grid->totalizar('minutos'); //$grid->add("supervisor/tiketc/dataedit/create"); $grid->build(); //echo $grid->db->last_query(); $data['content'] = $filter->output . $grid->output; $data["head"] = $this->rapyd->get_head(); $data['title'] = ' Control de Tiket '; $this->load->view('view_ventanas', $data); }
function vista($vd = '') { $this->rapyd->load('datagrid2'); $select = array('vd', 'tipo_doc', 'numero', 'fecha', 'vence', 'pagada', 'dias', 'comision', 'comical', 'cod_cli', 'nombre', 'sepago', 'comision'); $grid = new DataGrid2('Lista de ' . $this->titp); $grid->db->select($select); $grid->db->from('sfac'); $grid->db->where('tipo_doc <>', 'X'); if (!empty($vd)) { $grid->db->where('vd', $vd); } $grid->db->where('sepago', 'N'); $grid->db->where('pagada >= fecha'); $grid->order_by('numero', 'desc'); $grid->per_page = 1000; $grid->use_function('substr', 'str_pad', 'comi'); $grid->use_function('sta'); $grid->column('Vendedor', 'vd'); $grid->column('Tipo', '<colum><#tipo_doc#></colum>'); $grid->column('Número', 'numero'); $grid->column('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>'); $grid->column('Vence', '<dbdate_to_human><#vence#></dbdate_to_human>'); $grid->column('Pagada', '<dbdate_to_human><#pagada#></dbdate_to_human>'); $grid->column('Dias', 'dias', 'align=\'right\''); $grid->column('Comisión', '<nformat><#comision#></nformat>', 'align=\'right\''); $grid->column('Comisión Calculada', '<nformat><#comical#></nformat>', 'align=\'right\''); $grid->column('Cliente', 'cod_cli'); $grid->column('Nombre', 'nombre'); //$grid->totalizar('reiva'); $grid->build(); $data['content'] = anchor($this->url . "filteredgrid", 'Atras') . $grid->output; $data['title'] = "<h1>{$this->titp}</h1>"; $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function resumen() { $this->rapyd->load('datagrid2', 'datafilter', 'datatable'); $form = new DataForm("finanzas/resumendiario/resumen/process"); $form->fecha = new dateonlyField("Fecha", "fecha"); $form->fecha->insertValue = date("Y-m-d"); $form->fecha->rule = "required|chfecha"; $form->fecha->size = 12; $form->submit("btnsubmit", "Consultar"); $form->build_form(); if ($form->on_success()) { $this->fecha = $form->fecha->newValue; } $dbfecha = $this->db->escape($this->fecha); //*********************************** // RESUMEN DE CAJAS (RCAJ) //*********************************** $grid = new DataGrid2("Resumen de Cajas"); $grid->db->select(array("cajero", "ingreso AS venta", "recibido", "(ingreso - recibido) AS diferencia")); $grid->db->from("rcaj"); $grid->db->where("fecha", $this->fecha); $grid->order_by("caja", "asc"); //$grid->per_page = 15; $grid->column('Caja', 'cajero', "align='center'"); $grid->column('Venta', '<nformat><#venta#></nformat>', "align='right'"); $grid->column('Recibido', '<nformat><#recibido#></nformat>', "align='right'"); $grid->column('Diferencia', '<nformat><#diferencia#></nformat>', "align='right'"); $grid->totalizar("venta", "recibido", "diferencia"); $grid->build(); //*********************************** //DISTRIBUCION DE LA COBRANZA (SFPA) //*********************************** $grid2 = new DataGrid2('Distribución de la cobranza'); $grid2->db->select(array('a.tipo', 'b.nombre', 'sum(a.monto) AS monto', 'COUNT(*) AS cantidad')); $grid2->db->from('sfpa a'); $grid2->db->join('tarjeta b', 'a.tipo=b.tipo'); $grid2->db->where('f_factura', $this->fecha); $grid2->db->groupby('a.tipo'); $grid2->order_by('a.tipo', 'asc'); //$grid2->per_page = 15; $grid2->column('Tipo', '(<#tipo#>) <#nombre#>', "align='left'"); $grid2->column('Cantidad', 'cantidad', "align='right'"); $grid2->column('Monto', '<nformat><#monto#></nformat>', "align='right'"); $grid2->totalizar('monto'); $grid2->build(); //*********************************** // VENTAS Y DEVOLUCIONES //*********************************** function vdnom($tipo_doc, $referen) { $nombre = $tipo_doc == 'D' ? 'Devoluciones ' : 'Ventas '; $nombre .= $referen == 'E' ? 'al Contado' : 'a Credito'; return $nombre; } $grid3 = new DataGrid2("Distribución de la cobranza"); $grid3->db->select(array('tipo_doc', 'referen', 'COUNT(*) AS cana', 'SUM(totals)*IF(tipo_doc = "D" ,-1,1) AS monto')); $grid3->db->from("sfac a"); $grid3->db->where('referen <>', 'P'); $grid3->db->where('fecha', $this->fecha); $grid3->db->groupby('tipo_doc'); $grid3->db->groupby('referen'); $grid3->use_function('vdnom'); $grid3->column('Tipo', '<vdnom><#tipo_doc#>|<#referen#></vdnom>', "align='left'"); $grid3->column('Cantidad', '<nformat><#cana#>|0</nformat>', "align='right'"); $grid3->column('Monto', '<nformat><#monto#></nformat>', "align='right'"); $grid3->totalizar('monto'); $grid3->build(); //*********************************** // RESUMEN DE VENTAS //*********************************** $udia = days_in_month(substr($this->fecha, 4, 2), substr($this->fecha, 0, 4)); $fdesde = substr($this->fecha, 0, 6) . '01'; $fhasta = substr($this->fecha, 0, 6) . $udia; $ano = substr($this->fecha, 0, 4); $row1 = $this->datasis->damerow("SELECT COUNT(*) AS a,SUM(totals*(IF(tipo_doc = 'F',1,-1))) AS b FROM sfac WHERE tipo_doc <>'X' AND YEAR(fecha) = {$ano} AND fecha < {$dbfecha}"); $row2 = $this->datasis->damerow("SELECT COUNT(*) AS a,SUM(totals*(IF(tipo_doc = 'F',1,-1))) AS b FROM sfac WHERE tipo_doc <>'X' AND fecha BETWEEN {$fdesde} AND {$fhasta}"); $row3 = $this->datasis->damerow("SELECT COUNT(*) AS a,SUM(totals*(IF(tipo_doc = 'F',1,-1))) AS b FROM sfac WHERE tipo_doc <>'X' AND fecha = {$dbfecha}"); $cost1 = $this->datasis->dameval("SELECT SUM(costo*cana*(IF(tipoa = 'F',1,-1))) AS a FROM sitems WHERE tipoa <>'X' AND YEAR(fecha) = {$ano} AND fecha < {$dbfecha}"); $cost2 = $this->datasis->dameval("SELECT SUM(costo*cana*(IF(tipoa = 'F',1,-1))) AS a FROM sitems WHERE tipoa <>'X' AND fecha BETWEEN {$fdesde} AND {$dbfecha}"); $cost3 = $this->datasis->dameval("SELECT SUM(costo*cana*(IF(tipoa = 'F',1,-1))) AS a FROM sitems WHERE tipoa <>'X' AND fecha = {$dbfecha}"); if (empty($row1)) { $row1 = array('a' => 0, 'b' => 0); } if (empty($row2)) { $row2 = array('a' => 0, 'b' => 0); } if (empty($row3)) { $row3 = array('a' => 0, 'b' => 0); } $row1['c'] = $cost1; $row2['c'] = $cost2; $row3['c'] = $cost3; $rdata[0] = array('a' => $row1['a'], 'b' => $row1['b'], 'c' => $row1['c'], 'd' => $row1['b'] - $row1['c'], 'razon' => 'Ventas en lo que va de año'); $rdata[1] = array('a' => $row2['a'], 'b' => $row2['b'], 'c' => $row2['c'], 'd' => $row2['b'] - $row2['c'], 'razon' => 'Ventas en lo que va de mes'); $rdata[2] = array('a' => $row3['a'], 'b' => $row3['b'], 'c' => $row3['c'], 'd' => $row3['b'] - $row3['c'], 'razon' => 'Ventas de hoy'); $grid8 = new DataGrid("Resumen de Ventas " . $this->fecha, $rdata); $grid8->column("Razón", "razon"); $grid8->column("Cantidad", "a", "align='right'"); $grid8->column("Costo", "<nformat><#c#></nformat>", "align='right'"); $grid8->column("Monto", "<nformat><#b#></nformat>", "align='right'"); $grid8->column("Margen", "<nformat><#d#></nformat>", "align='right'"); $grid8->build(); $rdata = array(); //*********************************** // CUENTAS POR COBRAR (smov) //*********************************** $grid4 = new DataGrid2('Cuentas por Cobrar'); $grid4->db->select(array("c.gr_desc grupo", "SUM((a.monto-a.abonos)*IF(tipo_doc='AN',-1,1))saldo")); $grid4->db->from('smov a'); $grid4->db->join('scli b', 'a.cod_cli = b.cliente'); $grid4->db->join('grcl c', 'b.grupo = c.grupo'); $grid4->db->where("a.tipo_doc IN ('FC','ND','GI','AN')"); $grid4->db->groupby('c.gr_desc'); $grid4->order_by("c.gr_desc", "asc"); //$grid4->per_page = 15; $grid4->column('Grupo de Clientes', 'grupo', "align='left'"); $grid4->column('Monto', '<nformat><#saldo#></nformat>', "align='right'"); $grid4->totalizar('saldo'); $grid4->build(); //*********************************** // GASTOS //*********************************** $row = $this->datasis->dameval("SELECT SUM(montotot) AS a FROM scst WHERE tipo_doc = 'FC' AND recep = {$dbfecha}"); $row2 = $this->datasis->dameval("SELECT SUM(totbruto) AS a FROM gser WHERE tipo_doc = 'FC' AND fecha = {$dbfecha}"); $rdata[0] = array('nombre' => 'Total de Compras', 'monto' => $row); $rdata[1] = array('nombre' => 'Total de Gastos', 'monto' => $row2); $grid7 = new DataGrid2('Total Compras y Gastos de Hoy', $rdata); $grid7->column('Razón', 'nombre'); $grid7->column('Monto', '<nformat><#monto#></nformat>', "align='right'"); $grid7->totalizar('monto'); $grid7->build(); //*********************************** // CUENTAS POR PAGAR (sprm) //*********************************** $grid5 = new DataGrid2('Cuentas por Pagar'); $grid5->db->select(array('c.gr_desc grupo', "SUM((a.monto-a.abonos)*IF(tipo_doc = 'AN',-1,1)) saldo")); $grid5->db->from('sprm a'); $grid5->db->join('sprv b', 'a.cod_prv = b.proveed'); $grid5->db->join('grpr c', 'b.grupo = c.grupo'); $grid5->db->where("a.tipo_doc IN ('FC','ND','GI','AN')"); $grid5->db->groupby('c.gr_desc'); $grid5->order_by('c.gr_desc', 'asc'); //$grid5->per_page = 15; $grid5->column('Grupo de Proveedoores', 'grupo', "align='left'"); $grid5->column('Monto', '<nformat><#saldo#></nformat>', "align='right'"); $grid5->totalizar('saldo'); $grid5->build(); //*********************************** // PROMEDIO INVENTARIO (sinv) //*********************************** $grid6 = new DataGrid2('Total de Inventario'); $grid6->db->select(array('d.descrip AS descrip', 'SUM(a.pond*a.existen) AS suma')); $grid6->db->from('sinv a'); $grid6->db->join('grup b ', 'a.grupo = b.grupo'); $grid6->db->join('line c ', 'b.linea = c.linea'); $grid6->db->join('dpto d ', 'd.depto = c.depto'); $grid6->db->groupby('c.depto'); $grid6->db->order_by('d.descrip'); //$grid6->per_page = 15; $grid6->column('Departamento', 'descrip', "align='left'"); $grid6->column('Monto', '<nformat><#suma#></nformat>', "align='right'"); $grid6->totalizar('suma'); $grid6->build(); $data['rcaj'] = $grid->output; $data['sfpa'] = $grid2->output; $data['tot'] = $grid3->output; $data['resven'] = $grid8->output; $data['smov'] = $grid4->output; $data['scstgser'] = $grid7->output; $data['sprm'] = $grid5->output; $data['sinv'] = $grid6->output; $data0['content'] = $form->output . $this->load->view('view_resumendiario', $data, TRUE); $data0['head'] = $this->rapyd->get_head(); $data0['title'] = "<h1>" . $this->t**s . " para la fecha " . dbdate_to_human($this->fecha) . "</h1>"; $this->load->view('view_ventanas', $data0); }
function gserchipros($codbanc = null) { if (empty($codbanc)) { show_error('Faltan parametros'); } $dbcodbanc = $this->db->escape($codbanc); $mSQL = 'SELECT COUNT(*) AS cana, SUM(exento+montasa+monadic+monredu+tasa+sobretasa+reducida) AS monto FROM gserchi WHERE ngasto IS NULL AND aceptado="S" AND codbanc=' . $dbcodbanc; $r = $this->datasis->damerow($mSQL); if ($r['cana'] == 0) { echo heading("Caja {$codbanc} no tiene gastos aprobados, debe primero aprobar algun gasto y luego si puede reponerla"); return false; } $mSQL = "SELECT a.codprv, b.nombre FROM banc AS a JOIN sprv AS b ON a.codprv=b.proveed WHERE a.codbanc={$dbcodbanc}"; $query = $this->db->query($mSQL); if ($query->num_rows() > 0) { $row = $query->row(); $nombre = $row->nombre; $codprv = $row->codprv; } else { $nombre = $codprv = ''; } $sql = 'SELECT TRIM(a.codbanc) AS codbanc,tbanco FROM banc AS a'; $query = $this->db->query($sql); $comis = array(); if ($query->num_rows() > 0) { foreach ($query->result() as $row) { $ind = '_' . $row->codbanc; $comis[$ind]['tbanco'] = $row->tbanco; } } $json_comis = json_encode($comis); $this->rapyd->load('dataform', 'datagrid2'); $modbus = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Codigo Proveedor', 'nombre' => 'Nombre', 'rif' => 'RIF'), 'filtro' => array('proveed' => 'Codigo Proveedor', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'codprv', 'nombre' => 'nombre'), 'titulo' => 'Buscar Proveedor', 'script' => array('post_modbus()')); $bsprv = $this->datasis->modbus($modbus); $script = 'var comis = ' . $json_comis . '; $(document).ready(function() { desactivacampo(""); $("#codprv").autocomplete({ source: function( req, add){ $.ajax({ url: "' . site_url('ajax/buscasprv') . '", type: "POST", dataType: "json", data: {"q":req.term}, success: function(data){ var sugiere = []; if(data.length==0){ $("#nombre").val(""); $("#nombre_val").text(""); $("#codprv").val(""); }else{ $.each(data, function(i, val){ sugiere.push( val ); } ); } add(sugiere); }, }) }, minLength: 2, select: function( event, ui ) { $("#codprv").attr("readonly", "readonly"); $("#nombre").val(ui.item.nombre); $("#nombre_val").text(ui.item.nombre); $("#codprv").val(ui.item.proveed); setTimeout(function(){ $("#codprv").removeAttr("readonly"); }, 1500); } }); desactivacampo($("#cargo").val()); }); function post_modbus(){ nombre=$("#nombre").val(); $("#nombre_val").text(nombre); } function desactivacampo(codb1){ if(codb1.length>0 && codb1!="' . $this->mcred . '"){ eval("tbanco=comis._"+codb1+".tbanco;" ); if(tbanco=="CAJ"){ $("#cheque").attr("disabled","disabled"); $("#benefi").attr("disabled","disabled"); }else{ $("#cheque").removeAttr("disabled"); $("#benefi").removeAttr("disabled"); } }else{ $("#cheque").attr("disabled","disabled"); $("#benefi").attr("disabled","disabled"); } }'; $pcchi = $this->datasis->damerow("SELECT proveed, nombre FROM sprv WHERE nombre LIKE '%CAJA%CHICA%' LIMIT 1"); $form = new DataForm($this->url . 'gserchipros/' . $codbanc . '/process'); $form->title("Número de facturas aceptadas {$r['cana']}, monto total <b>" . nformat($r['monto']) . '</b> para la caja ' . $codbanc); $form->script($script); $form->codprv = new inputField('Proveedor', 'codprv'); $form->codprv->rule = 'required'; $form->codprv->insertValue = $codprv; $form->codprv->size = 8; $form->codprv->append($bsprv); $form->codprv->insertValue = empty($pcchi) ? '' : $pcchi['proveed']; $form->nombre = new inputField('Nombre', 'nombre'); $form->nombre->rule = 'required'; $form->nombre->insertValue = $nombre; $form->nombre->in = 'codprv'; $form->nombre->type = 'inputhidden'; $form->nombre->insertValue = empty($pcchi) ? '' : $pcchi['nombre']; $dbcodban = $this->db->escape($codbanc); $form->cargo = new dropdownField('Reponer desde', 'cargo'); $form->cargo->option('', 'Seleccionar'); $form->cargo->options("SELECT codbanc, CONCAT_WS('-',codbanc,banco) AS label FROM banc WHERE activo='S' AND codbanc<>{$dbcodban} ORDER BY codbanc"); $form->cargo->option($this->mcred, 'CREDITO'); $form->cargo->onchange = 'desactivacampo(this.value)'; $form->cargo->rule = 'max_length[5]|required'; $form->cheque = new inputField('Cheque Numero', 'cheque'); $form->cheque->rule = 'condi_required|callback_chobligaban'; //$form->cheque->append('Aplica si es un banco'); $form->cheque->group = 'Aplica si repone desde un Banco'; $form->cheque->size = 12; $form->benefi = new inputField('Beneficiario', 'benefi'); $form->benefi->insertValue = $nombre; $form->benefi->rule = 'condi_required|callback_chobligaban|strtoupper'; //$form->benefi->append('Aplica si es un banco'); $form->benefi->group = $form->cheque->group; $form->build_form(); $grid = new DataGrid2("Lista de facturas aceptadas para pagar de la caja {$codbanc}", 'gserchi'); $select = array('exento + montasa + monadic + monredu + tasa + sobretasa + reducida AS totneto', 'descrip', 'tasa + sobretasa + reducida AS totiva', 'proveedor', 'fechafac', 'numfac', 'codbanc'); $grid->totalizar('totneto', 'totiva'); $grid->db->select($select); $grid->db->where('aceptado', 'S'); $grid->db->where('ngasto IS NULL'); $grid->db->where('codbanc', $codbanc); $grid->order_by('fechafac', 'desc'); $grid->per_page = 15; //$grid->column('Caja','codbanc'); $grid->column('Número', 'numfac'); $grid->column('Fecha', '<dbdate_to_human><#fechafac#></dbdate_to_human>', 'align=\'center\''); $grid->column('Proveedor', 'proveedor'); $grid->column('Descripción', 'descrip'); $grid->column('IVA', '<nformat><#totiva#></nformat>', 'align=\'right\''); $grid->column('Monto', '<b><nformat><#totneto#></nformat></b>', 'align=\'right\''); //$grid->add('finanzas/gser/datagserchi/create','Agregar nueva factura'); $grid->build(); if ($form->on_success()) { $codprv = $form->codprv->newValue; $cargo = $form->cargo->newValue; $nombre = $form->nombre->newValue; $benefi = $form->benefi->newValue; $cheque = $form->cheque->newValue; $rt = $this->_gserchipros($codbanc, $cargo, $codprv, $benefi, $cheque); if ($rt) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => array('id' => $this->idgser)); echo json_encode($rt); } else { $rt = array('status' => 'B', 'mensaje' => 'No se pudo guardar', 'pk' => ''); echo json_encode($rt); } } else { echo $form->output . $grid->output; } }
function filteredgrid() { function ractivo($estado, $numero) { if ($estado == 'R') { $retorna = array('name' => $numero, 'id' => $estado, 'value' => 'accept', 'checked' => TRUE); } else { $retorna = array('name' => $numero, 'id' => $estado, 'value' => 'accept', 'checked' => FALSE); } return form_checkbox($retorna); } $this->rapyd->load("datafilter", "datagrid2"); $scli = array('tabla' => 'scli', 'columnas' => array('cliente' => 'Código Cliente', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('cliente' => 'Código Cliente', 'nombre' => 'Nombre'), 'retornar' => array('cliente' => 'cliente'), 'titulo' => 'Buscar Cliente'); $boton = $this->datasis->modbus($scli); $filter = new DataFilter("Filtro de Control de Tiket"); $select = array("a.id as idm", "a.sucursal", "a.asignacion", "a.idt as idt", "a.padre", "a.pertenece", "a.prioridad", "a.usuario as usuarios", "a.contenido", "a.estampa", "a.actualizado", "a.estado as testado", "IF(a.estado='N','Nuevo',IF(a.estado='R','Resuelto',IF(a.estado='P','Pendiente','En Proceso')))as estado", "b.id", "b.cliente as clientes", "b.ubicacion", "b.url", "b.basededato", "b.puerto", "b.puerto", "b.usuario", "b.clave", "b.observacion", "c.nombre", "a.minutos"); $filter->db->select($select); $filter->db->from("tiketc AS a"); $filter->db->join("tiketconec AS b", "a.sucursal=b.id"); $filter->db->join("scli AS c", "b.cliente=c.cliente"); $filter->fechad = new dateonlyField("Fecha Desde", "fechad", 'd/m/Y'); $filter->fechad->clause = "where"; $filter->fechad->db_name = "estampa"; $filter->fechad->operator = ">="; $filter->fechad->size = 12; $filter->fechah = new dateonlyField("Fecha Hasta", "fechah", 'd/m/Y'); $filter->fechah->clause = "where"; $filter->fechah->db_name = "estampa"; $filter->fechah->operator = "<="; $filter->fechah->size = 12; $filter->estado = new dropdownField("Estado", "estado"); $filter->estado->option("", "Todos"); $filter->estado->options($this->estado); $filter->prioridad = new dropdownField("Prioridad", "prioridad"); $filter->prioridad->option("", "Todos"); $filter->prioridad->options($this->prioridad); $filter->contenido = new inputField("Contenido", "contenido"); //$filter->contenido->clause ="likesensitive"; //$filter->contenido->append("Sencible a las Mayuscúlas"); $filter->asignacion = new dropdownField("Asignacion", "asignacion"); $filter->asignacion->option("", "Todos"); $filter->asignacion->options("SELECT codigo, codigo as value FROM tiketservi"); $filter->asignacion->style = "width:150px"; $filter->cliente = new inputField("Cliente", "cliente"); $filter->cliente->size = 20; $filter->cliente->db_name = "c.cliente"; $filter->cliente->append($boton); $filter->idt = new inputField("Numero", "idt"); $filter->idt->size = 20; $filter->idt->db_name = "idt"; $filter->buttons("reset", "search"); $filter->build(); $grid = new DataGrid2("Lista de Control de Tiket"); $grid->order_by("a.id", "desc"); $grid->per_page = 10; $link = anchor("supervisor/tiketc/dataedit/modify/<#idm#>", "<#idm#>"); $grid->use_function('ractivo'); $grid->column("Id", $link); $grid->column("Resuelto", "<ractivo><#testado#>|<#idm#></ractivo>", 'align="center"'); $grid->column("Numero tiket", "idt"); $grid->column("Fecha de Ingreso", "<dbdate_to_human><#estampa#>|d/m/Y h:m:s</dbdate_to_human>"); $grid->column("Cliente", "nombre"); $grid->column("Usuario", "usuarios"); $grid->column("Contenido", "contenido"); $grid->column("Prioridad", "prioridad"); //$grid->column("Estado","estado"); $grid->column("Asignacion", "asignacion"); $grid->column("Tiempo", "minutos"); //$grid->column("URL","url"); //$resp=anchor("http://merida.matloca.com/proteoerp/supervisor/tiket/dataedit/pertenece/<#idt#>/create"", 'IR'); $resp = '<a href="http://<#url#>/proteoerp/supervisor/tiket/dataedit/pertenece/<#idt#>/create">Ir</a>'; //$resp='http://merida.matloca.com/proteoerp/supervisor/tiket/dataedit/pertenece/67/create'; $grid->column("Responder", $resp); $grid->totalizar('minutos'); //$grid->add("supervisor/tiketc/dataedit/create"); $grid->build(); //echo $grid->db->last_query(); $script = ''; $url = site_url('supervisor/tiketc/activar'); $data['script'] = '<script type="text/javascript"> $(document).ready(function() { $("form :checkbox").click(function () { $.ajax({ type: "POST", url: "' . $url . '", data: "numero="+this.name+"&estado="+this.id, success: function(msg){ //alert(msg); } }); }).change(); }); </script>'; $data['content'] = $filter->output . form_open('') . $grid->output . form_close() . $script; $data['title'] = "<h1>Ticket de Clientes</h1>"; $data["head"] = script("jquery-1.2.6.pack.js"); $data["head"] .= script("plugins/jquery.checkboxes.pack.js") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function ver_cliente($cli) { function ractivo($estado, $numero) { if ($estado == 'R') { $retorna = array('name' => $numero, 'id' => $estado, 'value' => 'accept', 'checked' => TRUE); } else { $retorna = array('name' => $numero, 'id' => $estado, 'value' => 'accept', 'checked' => FALSE); } return form_checkbox($retorna); } $this->rapyd->load("datafilter", "datagrid2"); $cliente = $this->datasis->dameval("Select nombre from scli where cliente='" . $cli . "'"); //echo $cliente; $filter = new DataFilter("Filtro de Control de Tiket"); $select = array("a.id as idm", "a.sucursal", "a.asignacion", "a.idt as idt", "a.padre", "a.pertenece", "a.prioridad", "a.usuario as usuarios", "a.contenido", "a.estampa", "a.actualizado", "a.estado as testado", "IF(a.estado='N','Nuevo',IF(a.estado='R','Resuelto',IF(a.estado='P','Pendiente','En Proceso')))as estado", "b.id", "b.cliente as clientes", "b.url", "b.basededato", "b.puerto", "b.puerto", "b.usuario", "b.clave", "b.observacion", "c.nombre", "a.minutos"); $filter->db->select($select); $filter->db->from("tiketc AS a"); $filter->db->join("tiketconec AS b", "a.sucursal=b.id"); $filter->db->join("scli AS c", "b.cliente=c.cliente"); $filter->db->where("b.cliente", "{$cli}"); $filter->db->where("a.estado !=", "R"); $filter->db->where("a.estado !=", "C"); $filter->estado = new dropdownField("Estado", "estado"); $filter->estado->option("P", "Pendiente"); $filter->prioridad = new dropdownField("Prioridad", "prioridad"); $filter->prioridad->option("", "Todos"); $filter->asignacion = new dropdownField("Asignacion", "asignacion"); $filter->asignacion->option("", "Todos"); $filter->asignacion->options("SELECT codigo, codigo as value FROM tiketservi"); $filter->asignacion->style = "width:150px"; $filter->nombre = new inputField("Nombre", "nombre"); $filter->nombre->size = 40; $filter->usuario = new inputField("Usuario", "usuario"); $filter->usuario->size = 20; $filter->buttons("reset", "search"); $filter->build('dataformfiltro'); $ticket = anchor('supervisor/tiket/traertiket/', 'Traer Todos los Ticket'); $atras = anchor('supervisor/tiketmaes/', img(array('src' => 'images/regresar.jpg', 'border' => '0', 'alt' => 'Editar', 'height' => '40'))); $uri2 = anchor('supervisor/tiketmaes/traertiket/' . $cli, 'Traer Ticket'); $uri_3 = anchor("supervisor/tiketc/dataedit/modify/<#idm#>", img(array('src' => 'images/editar.png', 'border' => '0', 'alt' => 'Editar', 'height' => '12'))); $grid = new DataGrid2($atras . '<br><center>Lista de Ticket Pendientes y Nuevos -->' . $uri2 . "</center>"); $grid->order_by("a.id", "desc"); $grid->per_page = 10; $link = anchor("supervisor/tiketc/dataedit/modify/<#idm#>", "<#idm#>"); $grid->use_function('ractivo'); $grid->column('Acción', $uri_3, 'align=center'); $grid->column("Resuelto", "<ractivo><#testado#>|<#idm#></ractivo>", 'align="center"'); $grid->column_orderby("Id", $link, 'idm'); $grid->column_orderby("Numero tiket", "idt", 'idt'); $grid->column_orderby("Fecha de Ingreso", "<dbdate_to_human><#estampa#>|d/m/Y h:m:s</dbdate_to_human>", 'estampa'); $grid->column_orderby("Cliente", "nombre", 'nombre'); $grid->column_orderby("Estado", "estado", "estado"); $grid->column("Usuario", "usuarios"); $grid->column("Contenido", "contenido"); $grid->column("Prioridad", "prioridad"); $grid->column("Asignacion", "asignacion"); $resp = '<a href="http://<#url#>/proteoerp/supervisor/tiket/dataedit/pertenece/<#idt#>/create">Ir</a>'; $grid->column("Responder", $resp); $grid->totalizar('minutos'); $grid->build('datagridST'); //echo $grid->db->last_query(); //************ SUPER TABLE ************* $extras = ' <script type="text/javascript"> //<![CDATA[ (function() { var mySt = new superTable("demoTable", { cssSkin : "sSky", fixedCols : 1, headerRows : 1, onStart : function () { this.start = new Date();}, onFinish : function () {document.getElementById("testDiv").innerHTML += "Finished...<br>" + ((new Date()) - this.start) + "ms.<br>";} }); })(); //]]> </script> '; $style = ' <style type="text/css"> .fakeContainer { /* The parent container */ margin: 5px; padding: 0px; border: none; width: 740px; /* Required to set */ height: 320px; /* Required to set */ overflow: hidden; /* Required to set */ } </style> '; //**************************************** $script = ''; $url = site_url('supervisor/tiketc/activar'); $data['script'] = '<script type="text/javascript"> $(document).ready(function() { $("form :checkbox").click(function () { $.ajax({ type: "POST", url: "' . $url . '", data: "numero="+this.name+"&estado="+this.id, success: function(msg){ //alert(msg); } }); }).change(); }); </script>'; $data['style'] = $style; $data['style'] .= style('superTables.css'); $data['extras'] = $extras; $data['content'] = $grid->output; $data['filtro'] = $filter->output; $data['script'] .= script('jquery.js'); $data["script"] .= script('superTables.js') . script("jquery-1.2.6.pack.js") . script("plugins/jquery.checkboxes.pack.js"); //$data['content']= form_open('').$grid->output.form_close().$script; $data['title'] = heading('Ticket ' . $cliente); $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function cdatos() { $this->rapyd->uri->keep_persistence(); $this->rapyd->load('datagrid2', 'fields'); function ctipo($id, $tipo, $ejecuta) { if ($tipo == 'C') { return 'Calculado'; } else { $rt = str_replace('return', '', $ejecuta); $rt = str_replace(';', '', $rt); $name = "pvalor[{$id}]"; $data = array('name' => $name, 'id' => $name, 'value' => trim($rt), 'maxlength' => '100', 'size' => '15', 'class' => 'inputnum'); return form_input($data); } } //echo date('Y-m-d H:i:s',mktime(0, 0, 0, date('n')-1, 1)).' - '.date('Y-m-d H:i:s',mktime(0, 0, 0, date('n') , 0)); $fdesde = new dateonlyField('Fecha de inicio: ', 'fdesde'); $fhasta = new dateonlyField('Fecha Final: ', 'fhasta'); $fdesde->insertValue = date('Y-m-d H:i:s', mktime(0, 0, 0, date('n') - 1, 1)); $fhasta->insertValue = date('Y-m-d H:i:s', mktime(0, 0, 0, date('n'), 0)); $fdesde->status = $fhasta->status = 'create'; $fdesde->size = $fhasta->size = 8; $fdesde->dbformat = $fhasta->dbformat = 'Ymd'; $fdesde->build(); $fhasta->build(); $fcorte1 = new dateonlyField('Fecha de Corte: ', 'fcorte1'); $fcorte1->insertValue = date('Y-m-d H:i:s', mktime(0, 0, 0, date('n') - 1, 15)); $fcorte1->dbformat = 'Ymd'; $fcorte1->status = 'create'; $fcorte1->size = 8; $fcorte1->build(); $error = $msj = ''; if ($this->input->post('pros') !== false) { $fdesde->_getNewValue(); $fhasta->_getNewValue(); $fcorte1->_getNewValue(); $url = $this->url . 'ejecutor/' . $fdesde->newValue . '/' . $fcorte1->newValue . '/' . $fhasta->newValue; redirect($url); $pmargen = $this->input->post('pmargen'); $pobject = $this->input->post('pobjetivo'); $pvalor = $this->input->post('pvalor'); if (is_array($pmargen)) { if (array_sum($pmargen) == 100) { foreach ($pmargen as $id => $pm) { if (is_numeric($pobject[$id])) { $po = $pobject[$id]; } else { $po = 0; } if (isset($pvalor[$id]) && is_numeric($pvalor[$id])) { $pv = 'return ' . $pvalor[$id] . ';'; } else { $pv = null; } if (is_numeric($pm) && $pm >= 0) { $this->db->where('id', $id); $data = array(); $data['puntos'] = $pm; $data['objetivo'] = $po; if (!empty($pv)) { $data['ejecuta'] = $pv; } $this->db->update('gestion_indicador', $data); } 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('/finanzas/gestion/cdatos') . '<p align="center">'; $ggrid .= '<b>' . $fdesde->label . '</b>' . $fdesde->output; $ggrid .= '<b>' . $fhasta->label . '</b>' . $fhasta->output; $ggrid .= br() . '<b>' . $fcorte1->label . '</b>' . $fcorte1->output; $ggrid .= '</p>'; $grid = new DataGrid2('Selección de indicadores'); $grid->agrupar(' ', 'nomgrup'); $grid->use_function('ctipo'); $select = array('a.descrip', 'a.indicador', 'a.tipo', 'a.puntos', 'a.id', 'a.objetivo', 'a.ejecuta', 'b.nombre AS nomgrup', 'unidad'); $grid->db->select($select); $grid->db->from('gestion_indicador AS a'); $grid->db->join('gestion_grupo AS b', 'a.id_gestion_grupo=b.id'); $grid->db->where('a.activo', 'S'); $grid->order_by('nomgrup'); $campo = new inputField('Campo', 'puntos'); $campo->grid_name = 'pmargen[<#id#>]'; $campo->status = 'modify'; $campo->size = 6; $campo->autocomplete = false; $campo->css_class = 'inputnum'; $campo->disable_paste = true; $meta = new inputField('Meta', 'objetivo'); $meta->grid_name = 'pobjetivo[<#id#>]'; $meta->status = 'modify'; $meta->size = 15; $meta->autocomplete = false; $meta->css_class = 'inputnum'; $meta->disable_paste = true; $grid->column_orderby('Indicador', 'indicador', 'indicador'); $grid->column('Puntos %', $campo, 'align=\'center\''); $grid->column('Objetivo', $meta, 'align=\'center\''); $grid->column('Unidad', 'unidad'); $grid->column('Tipo', "<ctipo><#id#>|<#tipo#>|<#ejecuta#></ctipo>"); $action = "javascript:window.location='" . site_url('ventas/metas/filteredgrid') . "'"; $grid->button('btn_regresa', 'Regresar', $action, 'TR'); $grid->submit('pros', 'Generar', '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('Indicadores de Gestión'); $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 _showordiva($id, $stat = 'C') { $this->rapyd->load('datagrid2'); $grid = new DataGrid2('Lista de impuestos al valor agregado', 'ordiva'); $grid->totalizar('montoiva'); $grid->db->where('ordeni', $id); $grid->use_function('str_pad'); $grid->order_by('id', 'desc'); $grid->per_page = 5; $status = $this->datasis->dameval('SELECT status FROM ordi WHERE numero=' . $this->db->escape($id)); $uri = $status != 'C' ? anchor('import/ordi/ordiva/' . $id . '/modify/<#id#>', '<nformat><#tasa#></nformat>%') : '<nformat><#tasa#></nformat>%'; $grid->column('Tasa', $uri); $grid->column('Base Imponible', '<nformat><#base#></nformat>', 'align=\'right\''); $grid->column('IVA', '<nformat><#montoiva#></nformat>', 'align=\'right\''); $grid->column('Concepto', 'concepto'); if ($stat != 'C') { $grid->add('import/ordi/ordiva/' . $id . '/create', 'Agregar IVA'); } $grid->build(); //echo $grid->db->last_query(); if ($grid->recordCount > 0) { return $grid->output; } elseif ($stat != 'C') { return $grid->_button_container['TR'][0]; } else { return ''; } }
function vista() { $this->rapyd->load("datagrid2"); $f1 = $this->input->post('fechad'); $f2 = $this->input->post('fechah'); $codigoadm = $this->input->post('codigoadm'); $fondo = $this->input->post('fondo'); $d = explode('/', $this->input->post('fechad')); $h = explode('/', $this->input->post('fechah')); $fechad = implode('', array($d[2], $d[1], $d[0])); $fechah = implode('', array($h[2], $h[1], $h[0])); function blanco($codigo) { if ($codigo > 0) { return $codigo = str_pad($codigo, 8, '0', STR_PAD_LEFT); } } function union($fecha, $codigo) { return date('Ym', strtotime($fecha)) . str_pad($codigo, 8, '0', STR_PAD_LEFT); } $uri = anchor($this->url . 'dataedit/show/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>'); $query = "SELECT COUNT(*) FROM riva WHERE status='B' AND tipo_doc<>'AN' AND emision >= {$fechad} AND emision<={$fechah}"; if (!empty($codigoadm)) { $query .= " AND codigoadm='{$codigoadm}'"; } if (!empty($fondo)) { $query .= " AND fondo='{$fondo}'"; } $cant = $this->datasis->dameval($query); $grid = new DataGrid2("Lista de " . $this->titp); $grid->db->from("riva"); $grid->db->where("status", "B"); $grid->db->where("tipo_doc <>", "AN"); $grid->db->where("emision >=", $fechad); $grid->db->where("emision <=", $fechah); if (!empty($codigoadm)) { $grid->db->where("codigoadm", $codigoadm); } if (!empty($fondo)) { $grid->db->where("fondo", $fondo); } $grid->order_by("nrocomp", "desc"); $grid->per_page = 1000; $grid->use_function('substr', 'str_pad', 'blanco', 'union'); $grid->use_function('sta'); $grid->column("Número", "<union><#emision#>|<#nrocomp#></union>"); $grid->column("O. Compra", "<blanco><#ocompra#>|8|0|STR_PAD_LEFT</blanco>"); $grid->column("O. Pago", "<blanco><#odirect#>|8|0|STR_PAD_LEFT</blanco>"); $grid->column("Multiple", "<blanco><#itfac#>|8|0|STR_PAD_LEFT</blanco>"); $grid->column("Emision", "<dbdate_to_human><#emision#></dbdate_to_human>", "align='center'"); $grid->column("Tipo", "tipo_doc"); $grid->column("Factura", "numero"); $grid->column("Nro. Control", "nfiscal"); $grid->column("Fecha Fac", "<dbdate_to_human><#ffactura#></dbdate_to_human>", "align='center'"); $grid->column("RIF", "rif"); $grid->column("Monto", "<number_format><#reiva#>|2|,|.</number_format>", "align='right'"); $grid->column("Est. Admin", "codigoadm"); $grid->column("Fondo", "fondo"); $grid->totalizar('reiva'); $grid->build(); $campo = "\n \t\t<input size='100' type='hidden' name='fechad' value='{$fechad}'>\n \t\t<input size='100' type='hidden' name='fechah' value='{$fechah}'>\n \t\t<input size='100' type='hidden' name='cant' value='{$cant}'>\n \t\t<input size='100' type='hidden' name='codigoadm' value='{$codigoadm}'>\n \t\t<input size='100' type='hidden' name='fondo' value='{$fondo}'>\n \t\t"; //$salida = anchor("tesoreria/piva/guardar/$fechad/$fechah/$cant","Crear orden de Pago"); $data['content'] = anchor($this->url . "nuevo", 'Ir atras') . $grid->output . form_open($this->url . 'guardar') . $campo . form_submit('mysubmit', 'Guardar') . form_close(); $data['title'] = " {$this->titp} "; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function vista($vd = '') { $this->rapyd->load("datagrid2"); $select = array("vd", "tipo_doc", "numero", "fecha", "vence", "pagada", "dias", "comision", "comical", "cod_cli", "nombre", "sepago", "comision"); $grid = new DataGrid2("Lista de " . $this->titp); $grid->db->select($select); $grid->db->from("sfac"); $grid->db->where("tipo_doc <>", "X"); if (!empty($vd)) { $grid->db->where("vd", $vd); } $grid->db->where("sepago", "N"); $grid->db->where('pagada >= fecha'); $grid->order_by("numero", "desc"); $grid->per_page = 1000; $grid->use_function('substr', 'str_pad', 'comi'); $grid->use_function('sta'); $grid->column("Vendedor", '<#vd#>'); $grid->column("Tipo", "<colum><#tipo_doc#></colum>"); $grid->column("Número", '<#numero#>'); $grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>"); $grid->column("Vence", "<dbdate_to_human><#vence#></dbdate_to_human>"); $grid->column("Pagada", "<dbdate_to_human><#pagada#></dbdate_to_human>"); $grid->column("Dias", 'dias', "align='right'"); $grid->column("Comision", '<number_format><#comision#>|2|,|.</number_format>', "align='right'"); $grid->column("Comisión Calculada", '<number_format><#comical#>|2|,|.</number_format>', "align='right'"); $grid->column("Cliente", '<#cod_cli#>'); $grid->column("Nombre", '<#nombre#>'); //$grid->totalizar('reiva'); $grid->build(); $data['content'] = anchor($this->url . "filteredgrid", 'Atras') . $grid->output; $data['title'] = "<h1>{$this->titp}</h1>"; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }