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);
}
