function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$this->rapyd->uri->keep_persistence();
$this->datasis->modulo_id(707, 1);
$script = '
$(function() {
$(".inputnum").numeric(".");
});
';
$filter = new DataFilter("Filtro de Personal", 'pers');
$filter->script($script, "create");
$filter->script($script, "modify");
$filter->script->css_class = 'inputnum';
$filter->cedula = new inputField("Cédula", "cedula");
$filter->cedula->size = 10;
$filter->cedula->css_class = 'inputnum';
$filter->nombre = new inputField("Nombre", "nombre");
$filter->nombre->size = 30;
$filter->apellido = new inputField("Apellido", "apellido");
$filter->apellido->size = 30;
$filter->contrato = new dropdownField("Contrato", "contrato");
$filter->contrato->style = "width:400px;";
$filter->contrato->option("", "");
$filter->contrato->options("SELECT codigo,CONCAT('',codigo,nombre)as nombre FROM noco ORDER BY codigo");
$filter->divi = new dropdownField("División", "divi");
$filter->divi->style = "width:250px;";
$filter->divi->option("", "");
$filter->divi->options("SELECT division,descrip FROM divi ORDER BY division");
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('nomina/pers/dataedit/show/<#codigo#>', '<#codigo#>');
$grid = new DataGrid("Lista de Personal");
$grid->order_by("codigo", "asc");
$grid->per_page = 20;
$grid->column("Código", $uri);
$grid->column("Cédula", "cedula");
$grid->column("Nombre", "nombre");
$grid->column("Apellidos", "apellido");
$grid->add("nomina/pers/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = "<h1>Personal</h1>";
$data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$script = '';
$filter = new DataFilter("Lista");
$filter->db->from("suminr");
$filter->db->join("sprv", "suminr.proveed=sprv.proveed", "LEFT");
$filter->script($script);
$filter->numero = new inputField("Numero", "numero");
$filter->numero->size = 15;
$filter->fecha = new dateonlyField("Fecha", "fecha");
$filter->fecha->dbformat = "Y-m-d";
$filter->fecha->size = 12;
$modbus = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Codigo', 'nombre' => 'Nombre'), 'filtro' => array('proveed' => 'Codigo', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'titulo' => 'Buscar Beneficiario');
$bproveed = $this->datasis->modbus($modbus);
$filter->proveed = new inputField("Beneficiario", "proveed");
$filter->proveed->append($bproveed);
$filter->proveed->size = 7;
$filter->observacion = new inputField("Observación", "observacion");
$filter->observacion->size = 40;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('suministros/suminr/dataedit/show/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>');
function sta($status)
{
switch ($status) {
case "P":
return "Pendiente";
break;
case "A":
return "Anulado";
break;
case "C":
return "Recibida";
break;
}
}
$grid = new DataGrid();
$grid->order_by("numero", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad', 'sta');
$grid->column_orderby("Número", $uri, "numero");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'");
$grid->column_orderby("Beneficiario", "nombre", "proveed", "align='left'");
$grid->column_orderby("Total", "total", "total", "align='rigth'");
$grid->column_orderby("Observación", "<wordwrap><#observacion#>|50|\n|true</wordwrap>", "observacion", "align='left'");
$grid->column_orderby("Estado", "<sta><#status#></sta>", "status", "align='center' ");
$grid->add("suministros/suminr/dataedit/create");
$grid->build();
//echo $grid->db->last_query();
// $data['content'] = $filter->output.$grid->output;
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "Notas de Recepción";
$data["head"] = script("jquery.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
//$this->datasis->modulo_id(24,1);
$this->rapyd->load("datafilter", "datagrid");
$link = site_url('presupuesto/requisicion/getadmin');
$script = '
$(function() {
$(".inputnum").numeric(".");
});
';
$filter = new DataFilter("");
$filter->script($script);
$filter->db->select(array("a.numero numero", "a.fecha fecha", "a.total total"));
$filter->db->from("ingresos a");
//$filter->db->join("uejecutora b" ,"a.uejecuta=b.codigo");
$filter->numero = new inputField("Número", "numero");
$filter->numero->size = 15;
$filter->fecha = new dateonlyField("Fecha", "fecha");
$filter->fecha->size = 12;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . 'dataedit/show/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>');
$grid = new DataGrid("");
$grid->order_by("numero", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad');
$grid->column_orderby("Número", $uri, "numero");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'");
$grid->column_orderby("Total", "<nformat><#total#></nformat>", "total", "align='right' ");
$grid->add($this->url . "dataedit/create");
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['title'] = $this->titp;
$data['script'] = script("jquery.js") . "\n";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
//$this->datasis->modulo_id(224,1);
$this->rapyd->load("datafilter", "datagrid");
$link = site_url('presupuesto/requisicion/getadmin');
$script = '
$(function() {
$(".inputnum").numeric(".");
});
function get_uadmin(){
$.post("' . $link . '",{ uejecuta:$("#uejecuta").val() },function(data){$("#td_uadministra").html(data);})
}
';
$filter = new DataFilter("");
$filter->script($script);
$filter->db->select(array("a.status", "a.numero numero", "a.fecha fecha", "a.uejecuta", "b.nombre uejecuta2", "c.nombre uadministra2", "a.ano", "tsoli", "tdisp"));
$filter->db->from("cdisp a");
$filter->db->join("itcdisp d", "a.numero=d.numero", "LEFT");
$filter->db->join("uejecutora b", "a.uejecuta=b.codigo", "LEFT");
$filter->db->join("uadministra c", "a.uadministra=b.codigo", "LEFT");
$filter->db->groupby("a.numero");
$filter->numero = new inputField("Número", "numero");
$filter->numero->size = 15;
$filter->fecha = new dateonlyField("Fecha", "fecha");
$filter->fecha->size = 12;
$filter->uejecuta = new dropdownField("U.Ejecutora", "uejecuta");
$filter->uejecuta->option("", "Seccionar");
$filter->uejecuta->options("SELECT codigo,nombre FROM uejecutora ORDER BY nombre");
$filter->uejecuta->onchange = "get_uadmin();";
$filter->status = new dropdownField("Estado", "status");
$filter->status->option('', '');
$filter->status->option('C', 'Pre-Comprometido');
$filter->status->option('A', 'Anulado');
$filter->status->option('F', 'Finalizado Pre-Compromiso');
$filter->status->option('P', 'Pendiente');
$filter->codigoadm = new dropdownField("Est. Administrativa", "codigoadm");
$filter->codigoadm->option("", "Seccionar");
$filter->codigoadm->options("SELECT b.codigo, CONCAT_WS(' ',b.codigo,b.denominacion) AS val FROM presupuesto AS a JOIN estruadm AS b ON a.codigoadm=b.codigo GROUP BY b.codigo");
$filter->codigoadm->db_name = 'd.codigoadm';
$filter->fondo = new dropdownField("Fuente de Financiamiento", "fondo");
$filter->fondo->option("", "");
$filter->fondo->options("SELECT fondo,CONCAT_WS(' ',fondo,descrip)a FROM fondo");
$filter->fondo->db_name = 'd.fondo';
$filter->codigopres = new inputField("Partida", "codigopres");
$filter->codigopres->db_name = "d.codigopres";
//$filter->codigopres->clause ="likerigth";
$filter->codigopres->size = 25;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . 'dataedit/show/<#numero#>', '<#numero#>');
function status($status = '')
{
switch ($status) {
case 'C':
$status = "Pre-Comprometido";
break;
case 'A':
$status = "Anulado";
break;
case 'F':
$status = "Finalizado";
break;
case 'P':
$status = "Pendiente";
break;
}
return $status;
}
$grid = new DataGrid("");
$grid->order_by("numero", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad', 'status');
$grid->column_orderby("Número", $uri, "numero");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'");
$grid->column_orderby("Unidad Ejecutora", "uejecuta2", "uejecuta2", "align='left' NOWRAP");
$grid->column_orderby("Unidad Administrativa", "uadministra2", "uadministra2", "align='left' NOWRAP");
$grid->column_orderby("Disponible", "<nformat><#tdisp#></nformat>", "tdisp", "align='right' NOWRAP");
$grid->column_orderby("Solicitado", "<nformat><#tsoli#></nformat>", "tsoli", "align='right' NOWRAP");
$grid->column_orderby("Estado", "<status><#status#></status>", "status", "align='left'");
$grid->add($this->url . "dataedit/create");
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['title'] = $this->titp;
$data['script'] = script("jquery.js") . "\n";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function index()
{
$this->rapyd->load('datafilter', 'datagrid');
$link = site_url('supervisor/sfacfiscal/arreglaserial');
$linkd = site_url('supervisor/sfacfiscal/arreglaserialdev');
$link2 = site_url('supervisor/sfacfiscal/arreglanfiscal');
$link4 = site_url('supervisor/sfacfiscal/arreglanfiscaldev');
$link3 = site_url('supervisor/sfacfiscal/traereferen');
$jquery = '
function riega(id){
if(confirm("Esta seguro que regar el serial para las facturas?")){
if(confirm("Desea cambiar solo los registros vacios?"))
resp=0;
else
resp=1;
$.post("' . $link . '",{ cajero:$("#cajero").val(),fecha:$("#fecha").val(), serial:id ,noresp:resp, nulos:$("#nulos").val(),usuario:$("#usuario").val()},
function(data){
alert(data);
});
}
}
function riegadev(id){
if(confirm("Esta seguro que regar el serial por las devoluciones?")){
if(confirm("Desea cambiar solo los registros vacios?"))
resp=0;
else
resp=1;
$.post("' . $linkd . '",{ cajero:$("#cajero").val(),fecha:$("#fecha").val(), serial:id ,noresp:resp, nulos:$("#nulos").val(),usuario:$("#usuario").val()},
function(data){
alert(data);
});
}
}
function nfiscal(id){
if(confirm("Esta seguro que regar el numero fiscal?")){
if(confirm("Desea cambiar solo los registros vacios?"))
resp=0;
else
resp=1;
$.post("' . $link2 . '",{ cajero:$("#cajero").val(),fecha:$("#fecha").val(), numero:id ,noresp:resp, nulos:$("#nulos").val(),usuario:$("#usuario").val()},
function(data){
alert(data);
});
}
}
function nfiscaldev(id){
if(confirm("Esta seguro que regar el numero fiscal?")){
if(confirm("Desea cambiar solo los registros vacios?"))
resp=0;
else
resp=1;
$.post("' . $link4 . '",{ cajero:$("#cajero").val(),fecha:$("#fecha").val(), numero:id ,noresp:resp, nulos:$("#nulos").val(),usuario:$("#usuario").val()},
function(data){
alert(data);
});
}
}
function buscaref(){
referenc = prompt("Introduce una referencia");
$.post("' . $link3 . '",{ referen: referenc },
function(data){
alert(data);
});
}';
function exissinv($cen, $t, $tipo_doc)
{
if (!empty($cen)) {
if ($t == 1) {
if ($tipo_doc == 'F') {
$rt = form_button('asignar', $cen, 'onclick="riega(\'' . $cen . '\');"');
} else {
$rt = form_button('asignar', $cen, 'onclick="riegadev(\'' . $cen . '\');"');
}
} else {
if ($tipo_doc == 'F') {
$rt = form_button('asignar', $cen, 'onclick="nfiscal(\'' . $cen . '\');"');
} else {
$rt = form_button('asignar', $cen, 'onclick="nfiscaldev(\'' . $cen . '\');"');
}
}
} else {
$rt = '--';
}
return $rt;
}
$atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '0', 'screeny' => '0');
$filter = new DataFilter('', 'sfac');
//$filter->db->where('tipo_doc','F');
$filter->script($jquery);
$filter->fecha = new dateonlyField('Desde', 'fecha');
$filter->fecha->clause = 'where';
$filter->fecha->db_name = 'fecha';
$filter->fecha->insertValue = date('Y-m-d');
$filter->fecha->operator = '=';
$filter->fecha->rule = 'required|chfecha';
$filter->fecha->append("<a onclick='buscaref()'>Traer de referencia</a>");
$filter->cajero = new dropdownField('Cajero', 'cajero');
$filter->cajero->option('', 'Seleccionar');
$filter->cajero->option(' ', 'Creditos');
$filter->cajero->options('SELECT cajero, CONCAT_WS("-",cajero,nombre) FROM scaj ORDER BY cajero');
$filter->usuario = new dropdownField('Usuario', 'usuario');
$filter->usuario->option('', 'Todos');
$filter->usuario->options('SELECT us_codigo AS cod,us_codigo FROM usuario ORDER BY us_codigo');
$filter->usuario->rule = 'condi_required|callback_chusuario';
$filter->tipo_doc = new dropdownField('Tipo Doc.', 'tipo_doc');
$filter->tipo_doc->option('F', 'Facturas');
$filter->tipo_doc->option('D', 'Devoluciones');
$filter->tipo_doc->rule = 'required|enum[D,F]';
$filter->nulos = new dropdownField('Filtrar seriales nulos', 'nulos');
$filter->nulos->option('s', 'Si');
$filter->nulos->option('n', 'No');
$filter->nulos->clause = '';
$filter->nulos->group = 'No afecta el filtro';
$filter->nulos->append('Si se activa esta opcion no se riega el número en los campos donde el serial de la máquina fiscal es nulo');
$filter->nulos->rule = 'enum[s,n]';
$filter->buttons('reset', 'search');
$filter->build();
if ($this->rapyd->uri->is_set('search') && $filter->is_valid()) {
$fecha = $filter->fecha->newValue;
$dbfecha = $this->db->escape($fecha);
$fields = $this->db->field_data('sfac');
$ppk = array();
foreach ($fields as $field) {
if ($field->primary_key == 1) {
$ppk[] = '<#' . $field->name . '#>';
}
}
$llink = anchor('supervisor/sfacfiscal/editsfac/modify/' . implode('/', $ppk), '<#tipo_doc#><#numero#>');
$uri2 = anchor_popup('formatos/verhtml/FACTURA/<#tipo_doc#>/<#numero#>', 'Ver HTML', $atts);
$grid = new DataGrid('');
$grid->use_function('exissinv');
$grid->per_page = 30;
$grid->db->orderby('numero');
$grid->column('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>', 'fecha');
$grid->column('Nombre', 'nombre');
$grid->column('Referencia', $llink);
$grid->column('Usuario', 'usuario');
$grid->column('Cajero', 'cajero');
$grid->column('Monto', '<nformat><#totalg#></nformat>', 'align="right"');
$grid->column('N.Fiscal', '<exissinv><#nfiscal#>|2|<#tipo_doc#></exissinv>', 'align="center"');
$grid->column('Serial Maq.', '<exissinv><#maqfiscal#>|1|<#tipo_doc#></exissinv>', 'align="center"');
$grid->column('Ver factura', $uri2, 'align="center"');
$grid->build();
//echo $grid->db->last_query();
$mSQL = $grid->db->last_query();
$mSQL = str_replace('*', 'SUM(totalg)', $mSQL);
$corte = stripos($mSQL, 'ORDER');
if ($corte !== false) {
$mSQL = substr($mSQL, 0, $corte);
}
$monto = $this->datasis->dameval($mSQL);
$tabla = 'Monto: ' . nformat($monto) . $grid->output;
$mSQL = 'SELECT COUNT(*) AS cana,serial, MAX(factura) AS factura,MAX(ncnumero) AS ncnumero,SUM(exento+base+iva+base1+iva1+base2+iva2-ncexento-ncbase-nciva-ncbase1-nciva1-ncbase2-nciva2) AS total FROM fiscalz WHERE fecha=' . $dbfecha . ' GROUP BY serial';
$query = $this->db->query($mSQL);
foreach ($query->result() as $row) {
$tabla .= $row->serial . ' x' . $row->cana . ' - F' . $row->factura . ' - D' . $row->ncnumero . ' - ' . nformat($row->total) . br();
}
} else {
$tabla = '<div class="alert">' . $filter->error_string . '</div>';
}
//if(strlen($filter->error_string)) $data['error']=$filter->error_string;
$data['content'] = $filter->output . $tabla;
$data['title'] = '<h1>Arreglos de consistencias fiscal en facturas</h1>';
$data['head'] = $this->rapyd->get_head() . script('jquery.js');
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
//$this->datasis->modulo_id(24,1);
$this->rapyd->load("datafilter", "datagrid");
$link = site_url('presupuesto/requisicion/getadmin');
$script = '
$(function() {
$(".inputnum").numeric(".");
$("#mostrar").attr("title","Haz Click aqui para Mostrar el Filtro, y poder Buscar Documentos de una manera mas rápida y cencilla");
$("input[name=\\"btn_add\\"]").attr("title","Haz Click aqui para Agregar un nuevo Documento");
$("#mostrar,.button,.enlace,.tuxhelp").tooltip({
track: true,
delay: 0,
showURL: false,
opacity: 1,
fixPNG: true,
showBody: " - ",
extraClass: "pretty fancy",
top: -15,
left: 5
});
});
function get_uadmin(){
$.post("' . $link . '",{ uejecuta:$("#uejecuta").val() },function(data){$("#td_uadministra").html(data);})
}
';
$filter = new DataFilter("");
$filter->script($script);
$filter->db->select(array("a.numero numero", "a.fecha fecha", "a.uejecuta", "b.nombre uejecuta2", "c.nombre uadministra2"));
$filter->db->from("anoprox a");
$filter->db->join("uejecutora b", "a.uejecuta=b.codigo");
$filter->db->join("uadministra c", "a.uadministra=b.codigo", "LEFT");
if ($this->datasis->traevalor('ESPEJO') == "S" && !$this->datasis->essuper()) {
$filter->db->where("usuario", $this->session->userdata('usuario'));
}
$filter->numero = new inputField("Número", "numero");
$filter->numero->size = 15;
$filter->fecha = new dateonlyField("Fecha", "fecha", "d/m/Y");
$filter->fecha->size = 12;
$filter->uejecuta = new dropdownField("U.Ejecutora", "uejecuta");
$filter->uejecuta->option("", "Seccionar");
$filter->uejecuta->options("SELECT codigo,nombre FROM uejecutora ORDER BY nombre");
$filter->uejecuta->onchange = "get_uadmin();";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . 'dataedit/show/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>', array("title" => "Haz Click para ver el Documento de Proyección Número <#numero#>", "class" => "enlace"));
$grid = new DataGrid("Haz Click en cualquier número de Documento para verlo");
$grid->order_by("numero", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad');
$grid->column_orderby("Número", $uri, "numero");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'");
$grid->column_orderby("Unidad Ejecutora", "uejecuta2", "uejecuta2", "align='left' NOWRAP");
$grid->column_orderby("Unidad Administrativa", "uadministra2", "uadministra2", "align='left' NOWRAP");
$grid->add($this->url . "dataedit/create");
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['title'] = $this->titp;
$data["head"] = $this->rapyd->get_head() . script('jquery.js') . script('jquery-ui.js') . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.json.min.js") . script('plugins/jquery.tooltip.js') . script('plugins/jquery.autocomplete.js') . style('jquery.autocomplete.css') . style('jquery.tooltip.css') . style('tooltip.css') . style('vino/jquery-ui.css');
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
//$this->datasis->modulo_id(24,1);
$this->rapyd->load("datafilter", "datagrid");
$link = site_url('presupuesto/requisicion/getadmin');
$script = '
$(function() {
$(".inputnum").numeric(".");
function get_uadmin(){
$.post("' . $link . '",{ uejecuta:$("#uejecuta").val() },function(data){$("#td_uadministra").html(data);})
}
';
$filter = new DataFilter("");
$filter->script($script);
$filter->db->select(array("a.numero numero", "a.fecha fecha", "a.uejecuta", "b.nombre uejecuta2", "concepto", "total", "status"));
$filter->db->from("reinte a");
$filter->db->join("uejecutora b", "a.uejecuta=b.codigo", "LEFT");
$filter->db->join("uadministra c", "a.uadministra=b.codigo", "LEFT");
$filter->numero = new inputField("Número", "numero");
$filter->numero->size = 15;
$filter->fecha = new dateonlyField("Fecha", "fecha", "d/m/Y");
$filter->fecha->size = 12;
$filter->uejecuta = new dropdownField("U.Ejecutora", "uejecuta");
$filter->uejecuta->option("", "Seccionar");
$filter->uejecuta->options("SELECT codigo,nombre FROM uejecutora ORDER BY nombre");
$filter->uejecuta->onchange = "get_uadmin();";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . 'dataedit/show/<#numero#>', '<#numero#>');
function sta($sta)
{
switch ($sta) {
case 'P':
return 'Pendiente';
case 'E2':
return 'Pagado';
case 'O2':
return 'O. Pago';
case 'T2':
return 'Causado';
case 'C2':
return 'Comprometido';
case 'C1':
return 'Causado';
case 'T1':
return 'O. Pago';
case 'O1':
return 'Pagado';
// case 'E1':return 'Comprometido';
}
}
$grid = new DataGrid("Haz Click en cualquier número de Documento para verlo");
$grid->order_by("numero", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad', 'sta');
$grid->column_orderby("Número", $uri, "numero");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'");
$grid->column_orderby("Unidad Ejecutora", "uejecuta2", "uejecuta2", "align='left' ");
$grid->column_orderby("Concepto", "concepto", "concepto", "align='left' ");
$grid->column_orderby("Total", "total", "total", "align='right' ");
$grid->column_orderby("Estado", "<sta><#status#></sta>", "status", "align='right' ");
if ($this->datasis->puede(319)) {
$grid->add($this->url . "dataedit/create");
}
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['title'] = $this->titp;
$data["head"] = $this->rapyd->get_head() . script('jquery.js') . script('jquery-ui.js') . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.json.min.js") . script('plugins/jquery.tooltip.js') . script('plugins/jquery.autocomplete.js') . style('jquery.autocomplete.css') . style('jquery.tooltip.css') . style('tooltip.css') . style('vino/jquery-ui.css');
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->load->helper('form');
$this->rapyd->load('dataobject', "datafilter", "datagrid");
$this->rapyd->uri->keep_persistence();
$this->datasis->modulo_id(52, 1);
$mNOCO = array('tabla' => 'noco', 'columnas' => array('codigo' => 'Código de Sucursal', 'nombre' => 'Nombre'), 'filtro' => array('codigo' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('codigo' => 'contrato'), 'titulo' => 'Buscar Contratos', 'where' => 'tipo <> "O"');
$bNOCO = $this->datasis->modbus($mNOCO);
$script = '
$(function() {
});
';
$filter = new DataFilter("", 'pers');
$filter->db->select(array("noco.nombre noconombre", "pers.codigo", "pers.nacional", "pers.cedula", "pers.nombre", "pers.nombre2", "pers.apellido", "pers.apellido2", "pers.direc1", "pers.direc2", "pers.direc3", "pers.telefono", "pers.nacimi", "pers.sso", "pers.sexo", "pers.civil", "pers.depto", "pers.cargo", "pers.sueldo", "pers.ingreso", "pers.retiro", "pers.tipo", "pers.contrato", "pers.dialib", "pers.status", "pers.banco", "pers.cutipo", "pers.cuenta", "pers.vari1", "pers.vari2", "pers.vari3", "pers.vari4", "pers.vari5", "pers.vari6", "pers.vari7", "pers.vari8", "pers.uaumento", "pers.formato", "pers.dialab", "pers.xdialab", "pers.sucursal", "pers.divi", "pers.carnet", "pers.enlace", "pers.estampa", "pers.usuario", "pers.hora", "pers.transac", "pers.cuentab", "pers.profes", "pers.niveled", "pers.vence", "pers.horario", "pers.rif", "pers.codigoadm", "pers.fondo", "pers.codigopres", "pers.email", "pers.tipoe", "pers.observa", "pers.sueldo", "divi.descrip division"));
$filter->db->join("noco", "pers.contrato=noco.codigo", "LEFT");
$filter->db->join("divi", "divi.division=pers.divi", "LEFT");
$filter->script($script, "create");
$filter->script($script, "modify");
$filter->codigo = new inputField("Codigo", "codigo");
$filter->codigo->size = 30;
$filter->codigo->db_name = 'pers.codigo';
$filter->cedula = new inputField("Cédula", "cedula");
$filter->cedula->size = 10;
$filter->cedula->css_class = 'inputnum';
$filter->cedula->db_name = 'pers.cedula';
$filter->nombre = new inputField("Nombre", "nombre");
$filter->nombre->size = 30;
$filter->nombre->db_name = 'pers.nombre';
$filter->apellido = new inputField("Apellido", "apellido");
$filter->apellido->size = 30;
$filter->apellido->db_name = 'pers.apellido';
$filter->fondo = new inputField("Fondo", "fondo");
$filter->fondo->db_name = 'pers.fondo';
$filter->divi = new dropdownField("División", "divi");
$filter->divi->style = "width:250px;";
$filter->divi->option("", "");
$filter->divi->options("SELECT division,CONCAT_WS(' ',division,descrip)des FROM divi ORDER BY division");
//$filter->divi->group = "Relación Laboral";
$filter->codigoadm = new inputField("Est. Administrativa", "codigoadm");
$filter->codigoadm->db_name = 'pers.codigoadm';
$filter->codigopres = new inputField("Codigo Partida", "codigopres");
$filter->codigopres->db_name = 'pers.codigopres';
$filter->contrato = new inputField("Contrato", "contrato");
$filter->contrato->size = 4;
$filter->contrato->maxlength = 5;
$filter->contrato->append($bNOCO);
$filter->contrato->clause = 'where';
$filter->contrato->operator = '=';
$filter->sueldo = new inputField("Sueldo", "sueldo");
$filter->sueldo->db_name = 'pers.sueldo';
$filter->status = new dropdownField("Estatus", "status");
$filter->status->option("", "");
$filter->status->options(array("A" => "Activo", "V" => "Vacaciones", "R" => "Retirado"));
$filter->status->group = "Relación Laboral";
$filter->status->style = "width:100px;";
//$filter->script->css_class='inputnum';
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('nomina/pers/dataedit/show/<raencode><#codigo#></raencode>', '<#codigo#>');
$grid = new DataGrid("");
$grid->order_by("pers.codigo", "asc");
$grid->per_page = 20;
$grid->column_orderby("Código", $uri, "pers.codigo");
$grid->column_orderby("Cédula", "cedula", "cedula");
$grid->column_orderby("Nombre", "nombre", "nombre", "align='left'NOWRAP");
$grid->column_orderby("Apellidos", "apellido", "apellido", "align='left'NOWRAP");
$grid->column_orderby("Division", "division", "divi.descrip", "");
$grid->column_orderby("Contrato", "noconombre", "noconombre", "");
$grid->column_orderby("Sueldo", "sueldo", "sueldo", "");
$grid->add("nomina/pers/dataedit/create");
$grid->build();
$sql = $grid->db->last_query();
$cantidad = $grid->recordCount;
$hidden = array('sql' => $sql, 'cantidad' => $cantidad);
$form = form_open($this->url . "masivo", '', $hidden);
$form .= form_submit('modificar', 'Modificar Masivo');
//$data['content'] = $filter->output.$grid->output;
$data['filtro'] = $filter->output;
$data['content'] = $grid->output . $form;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "Personal";
$data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->datasis->modulo_id(24, 1);
$this->rapyd->load("datafilter", "datagrid");
$link = site_url('presupuesto/requisicion/getadmin');
$script = '
$(function() {
$(".inputnum").numeric(".");
});
function get_uadmin(){
$.post("' . $link . '",{ uejecuta:$("#uejecuta").val() },function(data){$("#td_uadministra").html(data);})
}
';
$filter = new DataFilter("");
$filter->script($script);
$filter->db->select("a.numero,a.numero numero,a.fecha fecha,a.uejecuta uejecuta,a.uadministra,a.responsable,a.objetivo,a.tcantidad,a.timporte,a.status,a.ocompra,b.nombre uejecuta2,c.nombre uadministra2");
$filter->db->from("requi a");
$filter->db->join("uejecutora b", "a.uejecuta=b.codigo");
$filter->db->join("uadministra c", "a.uadministra=b.codigo", "LEFT");
$filter->numero = new inputField("Número", "numero");
$filter->numero->size = 15;
$filter->fecha = new dateonlyField("Fecha", "fecha");
$filter->fecha->size = 12;
$filter->uejecuta = new dropdownField("U.Ejecutora", "uejecuta");
$filter->uejecuta->option("", "Seccionar");
$filter->uejecuta->options("SELECT codigo,nombre FROM uejecutora ORDER BY nombre");
$filter->uejecuta->onchange = "get_uadmin();";
$filter->uejecuta->rule = "required";
$filter->ocompra = new inputField("O. Compra", "ocompra");
$filter->ocompra->size = 15;
//$filter->uadministra = new dropdownField("U.Administrativa", "uadministra");
//$filter->uadministra->option("","Ninguna");
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('presupuesto/requisicion/dataedit/show/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>');
//$uri2 = anchor('presupuesto/requisicion/asig_part/modify/<#id#>','<str_pad><#id#>|8|0|STR_PAD_LEFT</str_pad>');
$grid = new DataGrid("");
$grid->order_by("numero", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad');
$grid->column_orderby("Número", $uri, "numero");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'");
$grid->column_orderby("Unidad Ejecutora", "uejecuta2", "uejecuta2", "align='left' NOWRAP");
$grid->column_orderby("Unidad Administrativa", "uadministra2", "uadministra2", "align='left' NOWRAP");
$grid->column_orderby("O.Compra", '<str_pad><#ocompra#>|8|0|STR_PAD_LEFT</str_pad>', "ocompra");
$grid->column_orderby("Estado", "status", "status");
$grid->column_orderby("Responsable", "responsable", "responsable");
$grid->column_orderby("Objetivo", "objetivo", "objetivo");
//$grid->column("Asig. Partida" ,$uri2);
$grid->add("presupuesto/requisicion/dataedit/create");
$grid->build();
//$ingrid = '<script type="text/javascript">
//$(document).ready(
// function() {
// $("#tablagrid").ingrid({
// url: "remote.html",
// height: 350
// });
// }
//);
//</script> ';
//
//$data['style'] = style("ingrid.css");
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['title'] = "Requisiciones";
//"";
$data['script'] = script("jquery.js") . "\n";
//.script("jquery.ingrid.js")."\n".$ingrid;
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
