function filteredgrid()
{
$this->datasis->modulo_id(103, 1);
$this->rapyd->load("datafilter2", "datagrid");
$link = site_url('presupuesto/programas/get_programa');
$script = '
$(document).ready(function(){
$("#sect_pres").change(function(){
$.post("' . $link . '",{ sect_pres:$(this).val() },function(data){$("#prog_pres").html(data);})
});
});
';
$filter = new DataFilter2("Filtro por Proyectos", "proyectos");
$filter->script($script, "create");
$filter->script($script, "modify");
$filter->sect_pres = new dropdownField("Sector", "sect_pres");
$filter->sect_pres->option("", "");
$filter->sect_pres->options("SELECT sect_pres, CONCAT_WS(' ',sect_pres,nomb_sect) AS nomb_sect FROM sectores ORDER BY sect_pres");
$filter->sect_pres->style = 'width:300px;';
$filter->prog_pres = new dropdownField("Programa", "prog_pres");
$filter->prog_pres->option("", "");
$filter->prog_pres->style = 'width:300px;';
$sect_pres = $filter->getval('sect_pres');
if ($sect_pres !== FALSE) {
$filter->prog_pres->options("SELECT prog_pres, CONCAT_WS(' ',prog_pres,nomb_prog) AS nomb_prog FROM programas WHERE sect_pres ='{$sect_pres}' ORDER BY prog_pres");
} else {
$filter->prog_pres->option("", "Seleccione un Sector primero");
}
$filter->id_proy = new inputField("Identificador Proyecto", "id_proy");
$filter->id_proy->size = 5;
$filter->id_proy->maxlength = 2;
$filter->proy_pres = new inputField("Código Proyecto", "proy_pres");
$filter->proy_pres->size = 5;
$filter->proy_pres->maxlength = 2;
$filter->nomb_proy = new inputField("Nombre Proyecto", "nomb_proy");
$filter->nomb_proy->size = 40;
$filter->nomb_proy->maxlength = 80;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('presupuesto/proyectos/dataedit/show/<#id_proy#>', '<#id_proy#>');
$grid = new DataGrid("Lista de Proyectos");
$grid->order_by("proy_pres", "asc");
$grid->column("Identificador", $uri, "align='center'");
$grid->column("Sector", "sect_pres", "align='left'");
$grid->column("Programa", "prog_pres", "align='left'");
$grid->column("Proyecto", "proy_pres", "align='left'");
$grid->column("Nombre", "nomb_proy", "align='left'");
$grid->add("presupuesto/proyectos/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = " Proyectos ";
$data["head"] = script("jquery.pack.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$script = '';
$filter = new DataFilter2("");
$filter->db->from("view_sumi_saldo");
$filter->script($script);
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 15;
$filter->descrip = new inputField("Descripción", "descrip");
$filter->descrip->size = 40;
$filter->unidad = new inputField("Unidad", "unidad");
$filter->unidad->size = 40;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . 'redi/<raencode><#codigo#></raencode>', '<#codigo#>');
$grid = new DataGrid("");
$grid->order_by("codigo", "asc");
$grid->per_page = 100;
$grid->use_function('substr', 'str_pad', 'sta');
$grid->column_orderby("Código", $uri, "codigo");
$grid->column_orderby("Descripción", "descrip", "descrip", "align='left' ");
$grid->column_orderby("Unidad", "unidad", "unidad", "align='left' ");
$grid->column_orderby("Cantidad", "cantidad", "cantidad", "align='left' NOWRAP");
//$grid->add($this->url."/dataedit/create");
$grid->build();
//$data['content'] = $filter->output.$grid->output;
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['title'] = $this->t**s;
$data['script'] = script("jquery.js") . "\n";
$data["head"] = script("jquery.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$this->rapyd->uri->keep_persistence();
$script = '
$(function() {
$(".inputnum").numeric(".");
});
';
$filter = new DataFilter2("", "pers");
$filter->script($script, "create");
$filter->script($script, "modify");
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 10;
$filter->codigo->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 = 35;
$filter->apellido = new inputField("Apellido", "apellido");
$filter->apellido->size = 35;
$filter->contrato = new dropdownField("Contrato", "contrato");
$filter->contrato->option("", "");
$filter->contrato->options('SELECT codigo, CONCAT_WS(" * ",codigo,nombre) a FROM noco ORDER BY nombre');
$filter->contrato->style = "width:300px;";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('forma/ver/RECIBO/2/<#codigo#>', 'Imprimir');
$grid = new DataGrid("");
$grid->order_by("codigo", "asc");
$grid->per_page = 20;
$grid->column_orderby("Código", "codigo", "codigo", "align='center'");
$grid->column_orderby("Cédula", "cedula", "cedula", "align='center'");
$grid->column_orderby("Nombre", "nombre", "nombre", "align='left'NOWRAP");
$grid->column_orderby("Apellidos", "apellido", "apellido", "align='left'NOWRAP");
$grid->column_orderby("Contrato", "contrato", "contrato");
$grid->column_orderby("Recibo", $uri, "codigo");
$grid->build();
//$data['content'] = $filter->output.$grid->output;
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "Recibos de Pago";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$script = '
$(function() {
});
';
$filter = new DataFilter2("", "bi_trasla");
$filter->script($script);
$filter->numero = new inputField("Número", "numero");
$filter->numero->size = 15;
$filter->fecha = new dateonlyField("Fecha", "fecha");
$filter->fecha->dbformat = "Y-m-d";
$filter->fecha->size = 12;
$filter->concepto = new inputField("Concepto", "concepto");
$filter->concepto->size = 40;
$filter->status = new dropdownField("Estado", "status");
$filter->status->option("", "");
$filter->status->option("P", "Sin Ejecutar");
$filter->status->option("C", "Ejecutado");
$filter->status->style = "width:100px";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . '/dataedit/show/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>');
function sta($status)
{
switch ($status) {
case "P":
return "Sin Ejecutar";
break;
case "C":
return "Ejecutado";
break;
//case "O":return "Ordenado Pago";break;
//case "A":return "Anulado";break;
}
}
$grid = new DataGrid("");
$grid->order_by("numero", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad');
$grid->use_function('sta');
$grid->column_orderby("Número", $uri, "numero");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha");
$grid->column_orderby("Concepto", "concepto", "concepto");
$grid->column_orderby("Estado", "<sta><#status#></sta>", "status");
$grid->add($this->url . "/dataedit/create");
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = $this->t**s;
$data["head"] = script("jquery.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$link2 = site_url('inventario/common/get_linea');
$link3 = site_url('inventario/common/get_grupo');
$script = '
<script language="javascript" type="text/javascript">
$(function(){
$(".inputnum").numeric(".");
});
</script>
';
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Código', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'titulo' => 'Buscar Proveedor');
$bSPRV = $this->datasis->modbus($mSPRV);
$mSINV = array('tabla' => 'sinv', 'columnas' => array('codigo' => 'Cóodigo', 'descrip' => 'Descripción', 'descrip2' => 'Descripción 2'), 'filtro' => array('codigo' => 'Código', 'descrip' => 'Descripción'), 'retornar' => array('codigo' => 'codigo'), 'titulo' => 'Buscar Codigo');
$bSINV = $this->datasis->modbus($mSINV);
$js = 'function depto(){
if($("#depto").val()!=""){
$("#nom_depto").attr("disabled","disabled");
}else{
$("#nom_depto").attr("disabled","");
}
}
function linea(){
if($("#linea").val()!=""){
$("#nom_linea").attr("disabled","disabled");
}else{
$("#nom_linea").attr("disabled","");
}
}
function grupo(){
if($("#grupo").val()!=""){
$("#nom_grupo").attr("disabled","disabled");
}else{
$("#nom_grupo").attr("disabled","");
}
}';
$select = array('a.codigo as codigo', 'a.suplemen', 'b.descrip', 'b.marca', 'b.precio1', 'b.depto', 'b.grupo', 'b.linea');
$filter = new DataFilter2('Filtro de Codigo de Barras');
$filter->script($js);
$filter->db->select($select);
$filter->db->from('barraspos AS a');
$filter->db->join('sinv AS b', 'a.codigo=b.codigo');
$filter->codigo = new inputField('Código de producto', 'codigo');
$filter->codigo->db_name = 'a.codigo';
$filter->codigo->size = 15;
$filter->codigo->maxlength = 15;
$filter->codigo->append($bSINV);
$filter->suplemen = new inputField('Barras adicionales', 'suplemen');
$filter->suplemen->db_name = 'a.suplemen';
$filter->suplemen->size = 15;
$filter->suplemen->maxlength = 20;
$filter->proveed = new inputField('Proveedor', 'proveed');
$filter->proveed->append($bSPRV);
$filter->proveed->db_name = 'b.prov1';
$filter->proveed->size = 25;
$filter->depto = new dropdownField('Departamento', 'depto');
$filter->depto->db_name = 'b.depto';
$filter->depto->option("", "Seleccione un Departamento");
$filter->depto->options("SELECT depto, CONCAT(depto,' ',descrip) descrip FROM dpto WHERE tipo='I' ORDER BY depto");
$filter->linea2 = new dropdownField("Línea", "linea");
$filter->linea2->db_name = "b.linea";
$filter->linea2->option("", "Seleccione un Departamento primero");
$depto = $filter->getval('depto');
if ($depto !== FALSE) {
$filter->linea2->options("SELECT linea, CONCAT(linea,' ',descrip) descrip FROM line WHERE depto='{$depto}' ORDER BY descrip");
} else {
$filter->linea2->option("", "Seleccione un Departamento primero");
}
$filter->grupo = new dropdownField("Grupo", "grupo");
$filter->grupo->db_name = 'c.grupo';
$filter->grupo->option("", "Seleccione una Línea primero");
$linea = $filter->getval('linea2');
if ($linea !== FALSE) {
$filter->grupo->options("SELECT grupo, nom_grup FROM grup WHERE linea='{$linea}' ORDER BY nom_grup");
} else {
$filter->grupo->option('', 'Seleccione un Departamento primero');
}
$filter->marca = new dropdownField('Marca', 'marca');
$filter->marca->db_name = 'b.marca';
$filter->marca->option('', 'Todas');
$filter->marca->options('SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM marc ORDER BY marca');
$filter->marca->style = 'width:220px;';
$filter->buttons('reset', 'search');
$filter->build('dataformfiltro');
$link = anchor('/inventario/barraspos/dataedit/show/<#codigo#>/<#suplemen#>', '<#codigo#>');
$grid = new DataGrid('Lista de Productoss');
$grid->order_by('codigo', 'asc');
$grid->per_page = 15;
$grid->column_orderby('Código', $link, 'codigo');
$grid->column_orderby('Descripción', 'descrip', 'descrip');
$grid->column_orderby('Marca', 'marca', 'marca');
$grid->column_orderby('Barras', 'suplemen', 'suplemen', 'align="right"');
$grid->add('inventario/barraspos/dataedit/create');
$grid->build();
$this->rapyd->jquery[] = '
$("select:not(#margen)").change( function() {
$.ajax({
type: "POST",
url: "' . site_url('inventario/sinvpromo/cmargen') . '",
data: "cod="+$(this).attr("name")+"&margen="+$(this).val(),
success: function(msg){
if (msg=="0"){
alert("Error al actualizar");
}
} });
});';
$this->rapyd->jquery[] = '
$("#depto").change(function(){
depto();
$.post("' . $link2 . '",{ depto:$(this).val() },function(data){$("#linea").html(data);})
$.post("' . $link3 . '",{ linea:"" },function(data){$("#grupo").html(data);})
});
$("#linea").change(function(){
linea();
$.post("' . $link3 . '",{ linea:$(this).val() },function(data){$("#grupo").html(data);})
});
$("#grupo").change(function(){
grupo();
});
depto();linea();grupo();';
$data['content'] = $grid->output;
$data['filtro'] = $filter->output;
$data['title'] = heading('Códigos de Baras Adicionales');
$data['head'] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$link2 = site_url('inventario/common/get_linea');
$link3 = site_url('inventario/common/get_grupo');
$js = 'function depto(){
if($("#depto").val()!=""){
$("#nom_depto").attr("disabled","disabled");
}else{
$("#nom_depto").attr("disabled","");
}
}
function linea(){
if($("#linea").val()!=""){
$("#nom_linea").attr("disabled","disabled");
}else{
$("#nom_linea").attr("disabled","");
}
}
function grupo(){
if($("#grupo").val()!=""){
$("#nom_grupo").attr("disabled","disabled");
}else{
$("#nom_grupo").attr("disabled","");
}
}';
$mSINV = array('tabla' => 'sinv', 'columnas' => array('codigo' => 'Cóodigo', 'descrip' => 'Descripción', 'descrip2' => 'Descripción 2'), 'filtro' => array('codigo' => 'Código', 'descrip' => 'Descripción'), 'retornar' => array('codigo' => 'codigo'), 'titulo' => 'Buscar Codigo');
$bSINV = $this->datasis->modbus($mSINV);
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'rif' => 'Rif'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'titulo' => 'Buscar Codigo');
$bSPRV = $this->datasis->modbus($mSPRV);
$select = array('a.proveed', 'a.codigo', 'a.codigop', 'c.nombre', 'b.descrip', 'b.marca');
$filter = new DataFilter2('Filtro de promociones');
$filter->script($js);
$filter->db->select($select);
$filter->db->from('sinvprov AS a');
// $filter->db->from('sinv AS b');
// $filter->db->from('sprv AS c');
$filter->db->join('sinv AS b', 'a.codigo=b.codigo');
$filter->db->join('sprv AS c', 'a.proveed=c.proveed');
$filter->proveed = new inputField("Código de proveedor", "proveed");
$filter->proveed->append($bSPRV);
$filter->proveed->db_name = 'a.proveed';
$filter->proveed->size = 15;
$filter->proveed->maxlength = 15;
$filter->codigo = new inputField('Código de producto', 'codigo');
$filter->codigo->db_name = 'a.codigo';
$filter->codigo->size = 15;
$filter->codigo->maxlength = 15;
$filter->codigo->append($bSINV);
$filter->codigop = new inputField("Código", "codigop");
$filter->codigop->db_name = 'a.codigop';
$filter->codigop->size = 15;
$filter->codigop->maxlength = 15;
// $filter->proveed = new inputField('Proveedor', 'proveed');
// $filter->proveed->append($bSPRV);
// $filter->proveed->db_name='b.prov1';
// $filter->proveed->size=25;
$filter->depto = new dropdownField('Departamento', 'depto');
$filter->depto->db_name = 'b.depto';
$filter->depto->option("", "Seleccione un Departamento");
$filter->depto->options("SELECT depto, descrip FROM dpto WHERE tipo='I' ORDER BY depto");
$filter->linea2 = new dropdownField("Línea", "linea");
$filter->linea2->db_name = "b.linea";
$filter->linea2->option("", "Seleccione un Departamento primero");
$depto = $filter->getval('depto');
if ($depto !== FALSE) {
$filter->linea2->options("SELECT linea, descrip FROM line WHERE depto='{$depto}' ORDER BY descrip");
} else {
$filter->linea2->option("", "Seleccione un Departamento primero");
}
$filter->grupo = new dropdownField("Grupo", "grupo");
$filter->grupo->db_name = 'c.grupo';
$filter->grupo->option("", "Seleccione una Línea primero");
$linea = $filter->getval('linea2');
if ($linea !== FALSE) {
$filter->grupo->options("SELECT grupo, nom_grup FROM grup WHERE linea='{$linea}' ORDER BY nom_grup");
} else {
$filter->grupo->option('', 'Seleccione un Departamento primero');
}
$filter->marca = new dropdownField('Marca', 'marca');
$filter->marca->db_name = 'b.marca';
$filter->marca->option('', 'Todas');
$filter->marca->options('SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM marc ORDER BY marca');
$filter->marca->style = 'width:220px;';
$filter->buttons("reset", "search");
$filter->build();
$link = anchor('/inventario/sinvprov/dataedit/modify/<#proveed#>/<#codigop#>/<#codigo#>', '<#proveed#>');
$grid = new DataGrid("Lista de proveedores");
$grid->order_by("proveed", "asc");
$grid->per_page = 15;
$grid->use_function('str_replace');
$grid->column_orderby("Código de proveedor", $link, "proveed");
$grid->column_orderby("Proveedor", 'nombre', "nombre");
$grid->column_orderby("Código de producto", 'codigo', "codigo");
$grid->column_orderby("Descripción", 'descrip', "proveed");
$grid->column_orderby("Código", "codigop", "codigop");
$grid->add("inventario/sinvprov/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = "<h1>Lista de Proveedores</h1>";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$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);
$script = '';
$filter = new DataFilter2("");
$filter->db->from("sumine");
$filter->db->join("su_alma", "sumine.alma=su_alma.codigo", '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;
$filter->observacion = new inputField("Observación", "observacion");
$filter->observacion->size = 40;
$filter->status = new dropdownField("Estado", "status");
$filter->status->option("", "");
$filter->status->option("P", "Por Entregar");
$filter->status->option("R", "Por Solicitar");
$filter->status->option("A", "Anulado");
$filter->status->option("C", "Entregado");
$filter->status->style = "width:150px";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('suministros/sumine/dataedit/show/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>');
function sta($status)
{
switch ($status) {
case "P":
return "Por Entregar";
break;
case "R":
return "Por Solicitar";
break;
case "A":
return "Anulado";
break;
case "C":
return "Entregado";
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("Receptor", "descrip", "descrip", "align='left' ");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center' ");
$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($this->url . "/dataedit/create");
$grid->build();
//$data['content'] = $filter->output.$grid->output;
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['title'] = "Notas de Entrega";
$data['script'] = script("jquery.js") . "\n";
$data["head"] = script("jquery.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid($para = '')
{
$this->rapyd->load("datafilter2", "datagrid", "dataobject", "fields");
$user = $this->session->userdata('usuario');
$link2 = site_url('inventario/common/get_fami');
$link3 = site_url('inventario/common/get_grupo_m');
$link1 = site_url('supermercado/etiqueta_maes/menu');
$script = '
$(document).ready(function(){
$("#depto").change(function(){
$("#objnumero").val("");
depto();
$.post("' . $link2 . '",{ depto:$(this).val() },function(data){$("#fami").html(data);})
$.post("' . $link3 . '",{ fami:"" },function(data){$("#grupo").html(data);})
});
$("#fami").change(function(){
fami();
$.post("' . $link3 . '",{ lfami:$(this).val() },function(data){$("#grupo").html(data);})
});
$("#grupo").change(function(){
grupo();
});
depto();
fami();
grupo();
});
function depto(){
if($("#depto").val()!=""){
$("#nom_depto").attr("disabled","disabled");
}
else{
$("#nom_depto").attr("disabled","");
}
}
function fami(){
if($("#fami").val()!=""){
$("#nom_fami").attr("disabled","disabled");
}
else{
$("#nom_fami").attr("disabled","");
}
}
function grupo(){
if($("#grupo").val()!=""){
$("#nom_grupo").attr("disabled","disabled");
}
else{
$("#nom_grupo").attr("disabled","");
}
}
';
$filter = new DataFilter2("Filtro por Producto");
$filter->db->_escape_char = '';
$filter->db->_protect_identifiers = false;
$filter->script($script);
$filter->descrip = new inputField("Descripción", "descrip");
$filter->descrip->db_name = 'CONCAT_WS(" ",a.descrip,a.descrip2)';
$filter->descrip->size = 25;
$filter->depto = new dropdownField("Departamento", "depto");
$filter->depto->db_name = "d.depto";
$filter->depto->option("", "Seleccione un Departamento");
$filter->depto->options("SELECT depto, descrip FROM dpto WHERE tipo='I' ORDER BY depto");
$filter->fami = new dropdownField("Familia", "fami");
$filter->fami->db_name = "c.familia";
$filter->fami->option("", "Seleccione un Departamento primero");
$depto = $filter->getval('depto');
if ($depto !== FALSE) {
$filter->fami->options("SELECT familia, descrip FROM fami WHERE depto='{$depto}' ORDER BY descrip");
} else {
$filter->fami->option("", "Seleccione un Departamento primero");
}
$filter->grupo = new dropdownField("Grupo", "grupo");
$filter->grupo->db_name = "b.grupo";
$filter->grupo->option("", "Seleccione una familia primero");
$fami = $filter->getval('fami');
if ($fami !== FALSE) {
$filter->grupo->options("SELECT grupo, nom_grup FROM grup WHERE familia='{$fami}' ORDER BY nom_grup");
} else {
$filter->grupo->option("", "Seleccione un Departamento primero");
}
$filter->marca = new dropdownField("Marca", "marca");
$filter->marca->option("", "");
$filter->marca->options("SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM marc ORDER BY marca");
$filter->marca->style = 'width:220px;';
$filter->buttons("reset", "search");
$filter->build();
$tabla = "";
if ($this->rapyd->uri->is_set("search") and $filter->is_valid()) {
$tabla = form_open("forma/ver/etiqueta_m");
$grid = new DataGrid("Lista de Artículos Para Etiquetas");
$grid->db->select("COUNT(*) AS num,a.tipo AS tipo,a.codigo as codigo,a.descrip,a.precio1 as precio,a.barras,\n\t\t\tb.nom_grup AS nom_grup, b.grupo AS grupoid,\n\t\t\tc.descrip AS nom_familia, c.familia AS familia,\n\t\t\td.descrip AS nom_depto, d.depto AS depto");
$grid->db->from("maes AS a");
$grid->db->join("grup AS b", "a.grupo=b.grupo");
$grid->db->join("fami AS c", "b.familia=c.familia");
$grid->db->join("dpto AS d", "c.depto=d.depto");
$grid->db->group_by("a.codigo");
$grid->db->_escape_char = '';
$grid->db->_protect_identifiers = false;
$grid->order_by("codigo", "asc");
$grid->use_function('asigna');
$grid->column_orderby("código", "codigo", "codigo");
$grid->column_orderby("Departamento", "<#nom_depto#>", "nom_depto", 'align=left');
$grid->column_orderby("Familia", "<#nom_familia#>", "nom_familia", 'align=left');
$grid->column_orderby("Grupo", "<#nom_grup#>", "nom_grup", 'align=left');
$grid->column_orderby("Descripción", "descrip", "descrip");
$grid->build();
$consul = $this->db->last_query();
$tabla .= form_hidden('consul', $consul);
$data = array('name' => 'cant', 'id' => 'cant', 'value' => '1', 'maxlength' => '5', 'size' => '5');
$tabla .= $grid->output . form_label("Numero de etiquetas por producto:") . "   " . form_input($data) . form_submit('mysubmit', 'Generar');
$tabla .= form_close();
}
$data['smenu'] = "<a href='" . $link1 . "' >Atras</a>";
$back = "<table width='100%'border='0'><tr><td width='80%'></td><td width='20%'><a href='javascript:atras()'><spam id='regresar'align='right'>REGRESAR</spam></a></td></tr></table>";
$data['filtro'] = $filter->output;
$data['tabla'] = $tabla;
$data['title'] = "Genera Etiquetas";
$data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . script("sinvmaes2.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas_pru', $data);
}
function especial()
{
$this->rapyd->load('datafilter2', 'datagrid', 'fields');
$link2 = site_url('inventario/common/get_linea');
$link3 = site_url('inventario/common/get_grupo');
$script = '
$(document).ready(function(){
$(".inputnum").numeric(".");
$(\'input[name^="monto"]\').keyup(function(){
var val=$(this).val();
alert(val);
});
});';
$filter = new DataFilter2($this->titp);
$select = array('a.existen', 'a.marca', 'a.semestral', 'a.trimestral', 'a.mensual', 'a.quincenal', 'a.semanal', 'a.descrip', 'a.barras', 'e.cobeca', 'e.dronena', 'e.drolanca', 'e.mafarta', 'e.cobeca_cana', 'e.dronena_cana', 'e.drolanca_cana', 'e.mafarta_cana');
$filter->db->select($select);
$filter->db->from('view_pednegocia AS a');
$filter->db->join('droguerias.inventarios AS e', 'a.barras=e.barras');
$filter->script($script);
$filter->descrip = new inputField('Descripción', 'descrip');
$filter->descrip->db_name = 'a.descrip';
$filter->descrip->size = 30;
$filter->marca = new dropdownField('Laboratorio', 'marca');
$filter->marca->option('', 'Todas');
$filter->marca->options('SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM view_pednegocia GROUP BY marca');
$filter->marca->style = 'width:220px;';
$filter->buttons('reset', 'search');
$filter->build();
$uri = anchor($this->url . 'dataedit/show/<raencode><#id#></raencode>', '<#id#>');
function opts($mafarta, $cobeca, $dronena, $drolanca, $mafarta_cana, $cobeca_cana, $dronena_cana, $drolanca_cana)
{
$vals = array('cobeca' => $cobeca, 'mafarta' => $mafarta, 'dronena' => $dronena, 'drolanca' => $drolanca);
//sort($val,SORT_NUMERIC);
$val = array('cobeca' => "Merida {$cobeca_cana} - {$cobeca} Bs.", 'mafarta' => "Marta {$mafarta_cana} - {$mafarta} Bs.", 'dronena' => "Dronena {$dronena_cana} - {$dronena} Bs.", 'drolanca' => "Drolanca {$drolanca_cana} - {$drolanca} Bs.");
return form_dropdown('aa', $val, '', 'style="width: 250px"');
}
$grid = new DataGrid('');
$grid->use_function('opts');
$grid->order_by('descrip');
$grid->per_page = 40;
$monto = new inputField('Monto', 'monto');
$monto->grid_name = 'monto[<#barras#>]';
$monto->status = 'modify';
$monto->size = 8;
$monto->css_class = 'inputnum';
$grid->column_orderby('Código', 'barras', 'barras');
$grid->column_orderby('Descripción', 'descrip', 'descrip');
$grid->column_orderby('Laboratorio', 'marca', 'marca');
$grid->column('Existencia', '<nformat><#existen#></nformat>', 'align=\'right\'');
$grid->column('Cantidad a pedir', $monto, 'align=\'right\'');
//$grid->column('Droguerias' ,'<opts><#mafarta#>|<#cobeca#>|<#dronena#>|<#drolanca#>|<#mafarta_cana#>|<#cobeca_cana#>|<#dronena_cana#>|<#drolanca_cana#></opts>' ,'align=\'right\'');
$grid->column('Semestral', '<nformat><#semestral#></nformat>', 'align=\'right\'');
$grid->column('Trimestral', '<nformat><#trimestral#></nformat>', 'align=\'right\'');
$grid->column('Mensual', '<nformat><#mensual#></nformat>', 'align=\'right\'');
$grid->column('Semanal', '<nformat><#semanal#></nformat>', 'align=\'right\'');
$grid->column('Merida', '<nformat><#cobeca#></nformat>', 'align=\'right\'');
$grid->column('Mafarta', '<nformat><#mafarta#></nformat>', 'align=\'right\'');
$grid->column('Dronena', '<nformat><#dronena#></nformat>', 'align=\'right\'');
$grid->column('Drolanca', '<nformat><#drolanca#></nformat>', 'align=\'right\'');
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['head'] = $this->rapyd->get_head() . script('jquery.js');
$data['title'] = heading($this->titp);
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'titulo' => 'Buscar Proveedor');
$bSPRV = $this->datasis->modbus($mSPRV);
$link2 = site_url('inventario/common/get_linea');
$link3 = site_url('inventario/common/get_grupo');
$script = '
$(document).ready(function(){
$("#depto").change(function(){
depto();
$.post("' . $link2 . '",{ depto:$(this).val() },function(data){$("#linea").html(data);})
$.post("' . $link3 . '",{ linea:"" },function(data){$("#grupo").html(data);})
});
$("#linea").change(function(){
linea();
$.post("' . $link3 . '",{ linea:$(this).val() },function(data){$("#grupo").html(data);})
});
$("#grupo").change(function(){
grupo();
});
depto();
linea();
grupo();
});
function depto(){
if($("#depto").val()!=""){
$("#nom_depto").attr("disabled","disabled");
}
else{
$("#nom_depto").attr("disabled","");
}
}
function linea(){
if($("#linea").val()!=""){
$("#nom_linea").attr("disabled","disabled");
}
else{
$("#nom_linea").attr("disabled","");
}
}
function grupo(){
if($("#grupo").val()!=""){
$("#nom_grupo").attr("disabled","disabled");
}
else{
$("#nom_grupo").attr("disabled","");
}
}
';
//filter
$filter = new DataFilter2("Filtro por Producto");
$filter->script($script);
$filter->db->select('a.codigo');
$filter->db->select('a.descrip');
$filter->db->select('s.exmin');
$filter->db->select('s.id');
$filter->db->from('eventas as a');
$filter->db->join("grup as b", "a.grupo=b.grupo ", 'LEFT');
$filter->db->join("sinv as s", "a.codigo=s.codigo ", 'LEFT');
$filter->db->groupby('a.codigo');
$filter->fechad = new dateonlyField("Desde", "fechad", 'm/Y');
$filter->fechah = new dateonlyField("Hasta", "fechah", 'm/Y');
$filter->fechad->dbformat = 'Y-m-';
$filter->fechah->dbformat = 'Y-m-';
$filter->fechah->rule = "required";
$filter->fechad->rule = "required";
$filter->fechad->clause = $filter->fechah->clause = '';
$filter->fechad->insertValue = date("Y-m-d", mktime(0, 0, 0, date('m') - 12, date('j'), date('Y')));
$filter->fechah->insertValue = date("Y-m-d");
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 25;
/*$filter->descrip = new inputField("Descripción", "descrip");
$filter->descrip->db_name='CONCAT_WS(" ",a.descrip,a.descrip2)';
$filter->descrip -> size=25;
$filter->tipo = new dropdownField("Tipo", "tipo");
$filter->tipo->db_name=("a.tipo");
$filter->tipo->option("","Todos");
$filter->tipo->option("Articulo","Artículo");
$filter->tipo->option("Servicio","Servicio");
$filter->tipo->option("Descartar","Descartar");
$filter->tipo->option("Consumo","Consumo");
$filter->tipo->option("Fraccion","Fracción");
$filter->tipo ->style='width:220px;';
$filter->clave = new inputField("Clave", "clave");
$filter->clave -> size=25;
$filter->activo = new dropdownField("Activo", "activo");
$filter->activo->option("","");
$filter->activo->option("S","Si");
$filter->activo->option("N","No");
$filter->activo ->style='width:220px;';
$filter->proveed = new inputField("Proveedor", "proveed");
$filter->proveed->append($bSPRV);
$filter->proveed->clause ="in";
$filter->proveed->db_name='( a.prov1, a.prov2, a.prov3 )';
$filter->proveed -> size=25;
$filter->depto2 = new inputField("Departamento", "nom_depto");
$filter->depto2->db_name="d.descrip";
$filter->depto2 -> size=10;
$filter->depto = new dropdownField("Departamento","depto");
$filter->depto->db_name="d.depto";
$filter->depto->option("","Seleccione un Departamento");
$filter->depto->options("SELECT depto, descrip FROM dpto WHERE tipo='I' ORDER BY depto");
$filter->depto->in="depto2";
$filter->linea = new inputField("Linea", "nom_linea");
$filter->linea->db_name="c.descrip";
$filter->linea -> size=10;
$filter->linea2 = new dropdownField("Línea","linea");
$filter->linea2->db_name="c.linea";
$filter->linea2->option("","Seleccione un Departamento primero");
$filter->linea2->in="linea";
$depto=$filter->getval('depto');
if($depto!==FALSE){
$filter->linea2->options("SELECT linea, descrip FROM line WHERE depto='$depto' ORDER BY descrip");
}else{
$filter->linea2->option("","Seleccione un Departamento primero");
}
$filter->grupo2 = new inputField("Grupo", "nom_grupo");
$filter->grupo2->db_name="b.nom_grup";
$filter->grupo2 -> size=10;
$filter->grupo = new dropdownField("Grupo", "grupo");
$filter->grupo->db_name="b.grupo";
$filter->grupo->option("","Seleccione una Línea primero");
$filter->grupo->in="grupo2";
$linea=$filter->getval('linea2');
if($linea!==FALSE){
$filter->grupo->options("SELECT grupo, nom_grup FROM grup WHERE linea='$linea' ORDER BY nom_grup");
}else{
$filter->grupo->option("","Seleccione un Departamento primero");
}
$filter->marca = new dropdownField("Marca", "marca");
$filter->marca->option("","");
$filter->marca->options("SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM marc ORDER BY marca");
$filter->marca -> style='width:220px;';
*/
$filter->buttons("reset", "search");
$filter->build();
$uri = "inventario/sinv/dataedit/show/<#codigo#>";
function minimos($param)
{
$data = func_get_args();
$valor = array_sum($data) - min($data) - max($data);
return ceil($valor / (count($data) - 2));
}
$tabla = '';
if ($filter->is_valid()) {
$udia = days_in_month(substr($filter->fechah->newValue, 4), substr($filter->fechah->newValue, 0, 4));
$fechad = $filter->fechad->newValue . '01';
$fechah = $filter->fechah->newValue . $udia;
$filter->db->where('a.fecha >=', $fechad);
$filter->db->where('a.fecha <=', $fechah);
$datetime1 = new DateTime($fechad);
$datetime2 = new DateTime($fechah);
$interval = $datetime1->diff($datetime2);
$ffechad = explode('-', $fechad);
$grid = new DataGrid("Lista de Artículos");
$grid->order_by("codigo", "asc");
$grid->use_function('minimos');
$grid->per_page = 15;
$grid->column("Código", 'codigo');
$grid->column("Descripción", "descrip");
$columncal = array();
for ($i = 0; $i <= $interval->m + 1; $i++) {
$mk = mktime(0, 0, 0, $ffechad[1] + $i, 1, $ffechad[0]);
$udia = days_in_month(date('m', $mk), date('Y', $mk));
$sqdesde = date("Y-m-d", $mk);
$sqhasta = date("Y-m-", $mk) . $udia;
$etiq = date("m/Y", $mk);
$select = "SUM(cana*(fecha BETWEEN '{$sqdesde}' AND '{$sqhasta}')) AS '{$etiq}'";
$filter->db->select($select);
$grid->column($etiq, "<nformat><#{$etiq}#></nformat>", 'align=right');
$columncal[] = "<#{$etiq}#>";
}
$grid->column('Promedio', '<nformat><minimos>' . implode('|', $columncal) . '</minimos></nformat>', 'align=right');
$grid->column('Minimo', '<nformat><#exmin#></nformat>', 'align=right');
$grid->column(' ', '<a href="javascript:actumin(\'<#id#>\',\'<minimos>' . implode('|', $columncal) . '</minimos>\')" >Actualizar</a>', 'align=right');
$grid->build();
$tabla = $grid->output;
}
$url = site_url('inventario/comparativo/actumin/') . '/';
$data['script'] = '<script language="javascript" type="text/javascript">
function actumin(id,val){
$.get("' . $url . '"+id+"/"+val, function(data) {
alert(data);
});
}
</script>';
$data['content'] = $filter->output . $tabla;
$data['title'] = "<h1>Comparativo de Mínimos de Inventario</h1>";
$data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . script("sinvmaes2.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'titulo' => 'Buscar Beneficiario');
$bSPRV = $this->datasis->modbus($mSPRV);
$link2 = site_url('inventario/common/get_linea');
$link3 = site_url('inventario/common/get_grupo');
$script = '
$(document).ready(function(){
$("#depto").change(function(){
depto();
$.post("' . $link2 . '",{ depto:$(this).val() },function(data){$("#linea").html(data);})
$.post("' . $link3 . '",{ linea:"" },function(data){$("#grupo").html(data);})
});
$("#linea").change(function(){
linea();
$.post("' . $link3 . '",{ linea:$(this).val() },function(data){$("#grupo").html(data);})
});
$("#grupo").change(function(){
grupo();
});
depto();
linea();
grupo();
});
function depto(){
if($("#depto").val()!=""){
$("#nom_depto").attr("disabled","disabled");
}
else{
$("#nom_depto").attr("disabled","");
}
}
function linea(){
if($("#linea").val()!=""){
$("#nom_linea").attr("disabled","disabled");
}
else{
$("#nom_linea").attr("disabled","");
}
}
function grupo(){
if($("#grupo").val()!=""){
$("#nom_grupo").attr("disabled","disabled");
}
else{
$("#nom_grupo").attr("disabled","");
}
}
';
//filter
$filter = new DataFilter2("");
$filter->db->select("a.id,a.tipo AS tipo,codigo,a.descrip,b.nom_grup AS nom_grup,b.grupo AS grupoid,c.descrip AS nom_linea,c.linea AS linea,d.descrip AS nom_depto,d.depto AS depto");
$filter->db->from("sumi AS a");
$filter->db->join("grup AS b", "a.grupo=b.grupo", "LEFT");
$filter->db->join("line AS c", "b.linea=c.linea", "LEFT");
$filter->db->join("dpto AS d", "c.depto=d.depto", "LEFT");
$filter->script($script);
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 25;
$filter->descrip = new inputField("Descripción", "descrip");
$filter->descrip->db_name = 'a.descrip';
$filter->descrip->size = 25;
//$filter->tipo = new dropdownField("Tipo", "tipo");
//$filter->tipo->db_name=("a.tipo");
//$filter->tipo->option("","Todos");
//$filter->tipo->option("Articulo","Artículo");
//$filter->tipo->option("Servicio","Servicio");
//$filter->tipo->option("Descartar","Descartar");
//$filter->tipo->option("Consumo","Consumo");
//$filter->tipo->option("Fraccion","Fracción");
//$filter->tipo ->style='width:220px;';
//
//$filter->clave = new inputField("Clave", "clave");
//$filter->clave -> size=25;
//
//$filter->activo = new dropdownField("Activo", "activo");
//$filter->activo->option("","");
//$filter->activo->option("S","Si");
//$filter->activo->option("N","No");
//$filter->activo ->style='width:220px;';
//$filter->proveed = new inputField("Beneficiario", "proveed");
//$filter->proveed->append($bSPRV);
//$filter->proveed->clause ="in";
//$filter->proveed->db_name='( a.prov1, a.prov2, a.prov3 )';
//$filter->proveed -> size=25;
$filter->depto2 = new inputField("Departamento", "nom_depto");
$filter->depto2->db_name = "d.descrip";
$filter->depto2->size = 10;
$filter->depto = new dropdownField("Departamento", "depto");
$filter->depto->db_name = "d.depto";
$filter->depto->option("", "Seleccione un Departamento");
$filter->depto->options("SELECT depto, descrip FROM dpto WHERE tipo='I' ORDER BY depto");
$filter->depto->in = "depto2";
//
$filter->linea = new inputField("Linea", "nom_linea");
$filter->linea->db_name = "c.descrip";
$filter->linea->size = 10;
$filter->linea2 = new dropdownField("Línea", "linea");
$filter->linea2->db_name = "c.linea";
$filter->linea2->option("", "Seleccione un Departamento primero");
$filter->linea2->in = "linea";
$depto = $filter->getval('depto');
if ($depto !== FALSE) {
$filter->linea2->options("SELECT linea, descrip FROM line WHERE depto='{$depto}' ORDER BY descrip");
} else {
$filter->linea2->option("", "Seleccione un Departamento primero");
}
$filter->grupo2 = new inputField("Grupo", "nom_grupo");
$filter->grupo2->db_name = "b.nom_grup";
$filter->grupo2->size = 10;
$filter->grupo = new dropdownField("Grupo", "grupo");
$filter->grupo->db_name = "b.grupo";
$filter->grupo->option("", "");
$filter->grupo->in = "grupo2";
$filter->grupo->options("SELECT grupo, nom_grup FROM grup ORDER BY nom_grup");
//WHERE linea='$linea'
//$linea=$filter->getval('linea2');
//if($linea!==FALSE){
// $filter->grupo->options("SELECT grupo, nom_grup FROM grup WHERE linea='$linea' ORDER BY nom_grup");
//}else{
// $filter->grupo->option("","Seleccione un Departamento primero");
//}
//$filter->marca = new dropdownField("Marca", "marca");
//$filter->marca->option("","");
//$filter->marca->options("SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM marc ORDER BY marca");
//$filter->marca -> style='width:220px;';
$filter->buttons("reset", "search");
$filter->build();
$uri = "suministros/sumi/dataedit/show/<raencode><#codigo#></raencode>";
$grid = new DataGrid("");
$grid->order_by("codigo", "asc");
$grid->per_page = 20;
$link = anchor('/suministros/sumi/dataedit/show/<#id#>', '<#codigo#>');
$uri_2 = anchor('suministros/sumi/dataedit/create/<raencode><#codigo#></raencode>', 'Duplicar');
$grid->column_orderby("código", $link, "codigo");
$grid->column("Departamento", "<#nom_depto#>", 'align=left');
$grid->column("Línea", "<#nom_linea#>", 'align=left');
$grid->column_orderby("Grupo", "<#nom_grup#>", "nom_grup", "align='left'NOWRAP");
$grid->column_orderby("Descripción", "descrip", "descrip", "align='left'NOWRAP");
//$grid->column("Precio 1","<number_format><#precio1#>|2|,|.</number_format>",'align=right');
//$grid->column("Precio 2","<number_format><#precio2#>|2|,|.</number_format>",'align=right');
//$grid->column("Precio 3","<number_format><#precio3#>|2|,|.</number_format>",'align=right');
//$grid->column("Precio 4","<number_format><#precio4#>|2|,|.</number_format>",'align=right');
$grid->column("Duplicar", $uri_2, "align='center'");
$grid->add("suministros/sumi/dataedit/create");
$grid->build();
//$data['content'] = $filter->output.$grid->output;
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "Maestro de Inventario";
$data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . script("sinvmaes2.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function inven($tabla)
{
if (!$this->db->table_exists($tabla)) {
show_error('Inventario físico no exite');
}
$tifecha = dbdate_to_human(substr($tabla, -8));
$tialmacen = substr($tabla, 3, -8);
$this->rapyd->load('datagrid', 'dataobject', 'fields', 'datafilter2');
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'titulo' => 'Buscar Proveedor');
$bSPRV = $this->datasis->modbus($mSPRV);
$link2 = site_url('inventario/common/get_linea');
$link3 = site_url('inventario/common/get_grupo');
$script = '
$(document).ready(function(){
$("#depto").change(function(){
depto();
$.post("' . $link2 . '",{ depto:$(this).val() },function(data){$("#linea").html(data);})
$.post("' . $link3 . '",{ linea:"" },function(data){$("#grupo").html(data);})
});
$("#linea").change(function(){
linea();
$.post("' . $link3 . '",{ linea:$(this).val() },function(data){$("#grupo").html(data);})
});
$("#grupo").change(function(){
grupo();
});
depto();
linea();
grupo();
});
function depto(){
if($("#depto").val()!=""){
$("#nom_depto").attr("disabled","disabled");
}
else{
$("#nom_depto").attr("disabled","");
}
}
function linea(){
if($("#linea").val()!=""){
$("#nom_linea").attr("disabled","disabled");
}
else{
$("#nom_linea").attr("disabled","");
}
}
function grupo(){
if($("#grupo").val()!=""){
$("#nom_grupo").attr("disabled","disabled");
}
else{
$("#nom_grupo").attr("disabled","");
}
}';
$filter = new DataFilter2('');
$this->db->_escape_char = '';
$this->db->_protect_identifiers = false;
$filter->db->select("e.existen,e.modificado,e.contado,e.agregar,e.quitar,e.sustituir,a.tipo AS tipo,a.id,e.codigo,a.descrip,precio1,precio2,precio3,precio4,b.nom_grup AS nom_grup,a.barras,b.grupo AS grupoid,c.descrip AS nom_linea,c.linea AS linea,d.descrip AS nom_depto,d.depto AS depto,e.id AS idfis,e.despacha, a.ubica, if( a.activo = 'S', ' ' , '*' ) activo");
$filter->db->from("{$tabla} AS e");
$filter->db->join('sinv AS a', 'a.codigo=e.codigo');
$filter->db->join('grup AS b', 'a.grupo=b.grupo');
$filter->db->join('line AS c', 'b.linea=c.linea');
$filter->db->join('dpto AS d', 'c.depto=d.depto');
//$filter->db->where('activo','S');
$filter->db->where('actualizado IS NULL', '', false);
//$filter->db->order_by("d.depto,c.linea,b.grupo,a.descrip");
$filter->script($script);
$filter->codigo = new inputField('Código', 'codigo');
$filter->codigo->db_name = 'e.codigo';
$filter->codigo->size = 25;
$filter->descrip = new inputField('Descripción', 'descrip');
$filter->descrip->db_name = 'CONCAT_WS(" ",a.descrip,a.descrip2)';
$filter->descrip->size = 25;
$filter->tipo = new dropdownField('Tipo', 'tipo');
$filter->tipo->db_name = 'a.tipo';
$filter->tipo->option('', 'Todos');
$filter->tipo->option('Articulo', 'Artículo');
$filter->tipo->option('Servicio', 'Servicio');
$filter->tipo->option('Descartar', 'Descartar');
$filter->tipo->option('Consumo', 'Consumo');
$filter->tipo->option('Fraccion', 'Fracción');
$filter->tipo->style = 'width:220px;';
$filter->clave = new inputField('Clave', 'clave');
$filter->clave->size = 25;
$filter->activo = new dropdownField('Activo', 'activo');
$filter->activo->option('', 'Todos');
$filter->activo->option('S', 'Si');
$filter->activo->option('N', 'No');
$filter->activo->style = 'width:220px;';
$filter->activo->db_name = 'a.activo';
$filter->proveed = new inputField('Proveedor', 'proveed');
$filter->proveed->append($bSPRV);
$filter->proveed->db_name = 'CONCAT_WS("_", a.prov1, a.prov2, a.prov3)';
$filter->proveed->size = 25;
$filter->depto2 = new inputField('Departamento', 'nom_depto');
$filter->depto2->db_name = 'd.descrip';
$filter->depto2->size = 10;
$filter->depto = new dropdownField("Departamento", "depto");
$filter->depto->db_name = "d.depto";
$filter->depto->option('', "Seleccione un Departamento");
$filter->depto->options("SELECT depto, descrip FROM dpto WHERE tipo='I' ORDER BY depto");
$filter->depto->in = "depto2";
$filter->linea = new inputField("Linea", "nom_linea");
$filter->linea->db_name = "c.descrip";
$filter->linea->size = 10;
$filter->linea2 = new dropdownField("Línea", "linea");
$filter->linea2->db_name = 'c.linea';
$filter->linea2->option('', 'Seleccione un Departamento primero');
$filter->linea2->in = 'linea';
$depto = $filter->getval('depto');
if ($depto !== false) {
$filter->linea2->options("SELECT linea, descrip FROM line WHERE depto='{$depto}' ORDER BY descrip");
} else {
$filter->linea2->option('', 'Seleccione un Departamento primero');
}
$filter->grupo2 = new inputField('Grupo', 'nom_grupo');
$filter->grupo2->db_name = 'b.nom_grup';
$filter->grupo2->size = 10;
$filter->grupo = new dropdownField('Grupo', 'grupo');
$filter->grupo->db_name = 'b.grupo';
$filter->grupo->option('', 'Seleccione una Línea primero');
$filter->grupo->in = 'grupo2';
$linea = $filter->getval('linea2');
if ($linea !== false) {
$filter->grupo->options("SELECT grupo, nom_grup FROM grup WHERE linea='{$linea}' ORDER BY nom_grup");
} else {
$filter->grupo->option('', 'Seleccione un Departamento primero');
}
$filter->marca = new dropdownField('Marca', 'marca');
$filter->marca->option('', 'Todas');
$filter->marca->options("SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM marc ORDER BY marca");
$filter->marca->style = 'width:220px;';
$filter->ubica = new inputField('Ubicacion', 'ubica');
$filter->ubica->db_name = 'a.ubica';
$filter->ubica->size = 15;
$filter->buttons('reset', 'search');
$filter->build();
function caja($campo2, $valor, $codigo, $readonly = false, $fila, $desp, $ccana)
{
$campo = new inputField2('Title', $campo2);
$campo->status = 'create';
$campo->css_class = 'inputnum';
$campo->size = 5;
$campo->insertValue = $valor;
$campo->readonly = $readonly;
if ($campo2 == 'c') {
$campo->type = 'inputhidden';
}
$campo->name = $codigo;
//$campo->name = 'I'.$campo2.'_'.$codigo;
$campo->id = 'I' . $campo2 . '_' . $codigo;
$campo->tabindex = $desp * $ccana + $fila;
$campo->build();
return $campo->output;
}
function pinta($modifi, $cont, $idfis, $pos)
{
$iidfis = "{$idfis}class";
if (empty($modifi)) {
$rt = '<span class="' . $iidfis . '">' . $cont . '</span>';
} else {
$rt = '<span class="' . $iidfis . '" style="color : red;">' . $cont . '</span>';
}
return $rt;
}
$atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '0', 'screeny' => '0');
$titulo1 = anchor_popup("reportes/ver/INVFIS/{$tabla}", 'Conteo', $atts);
$titulo2 = anchor_popup('reportes/ver/SINVFIS', 'Hoja de trabajo', $atts);
$cana = 100;
$grid = new DataGrid('Reportes -->' . $titulo1 . ' ' . $titulo2);
$grid->table_id = 'conteotabla';
$grid->per_page = $cana;
$grid->use_function('caja', 'pinta');
$action = "javascript:window.location='" . site_url($this->url) . "'";
$grid->button('btn_regresa', 'Regresar', $action, 'TR');
$grid->column('X', 'activo', 'activo', 'align=center');
$grid->column_orderby('Dpto', 'depto', 'd.depto', 'align=center');
$grid->column_orderby('Linea', 'linea', 'c.linea', 'align=center');
$grid->column_orderby('Grupo', 'grupoid', 'b.grupo', 'align=center');
$grid->column_orderby('Barras', 'barras', 'b.grupo', 'align=center');
$grid->column_orderby('Ubica', 'ubica', 'a.ubica', 'align=center');
$grid->column_orderby('Codigo', '<pinta><#modificado#>|<#codigo#>|<#idfis#>|a</pinta>', 'codigo', 'align=center');
$grid->column_orderby('Descripción', '<pinta><#modificado#>|<#descrip#>|<#idfis#>|b</pinta>', 'descrip');
$grid->column_orderby('P.Desp.', '<pinta><#modificado#>|<#despacha#>|<#idfis#>|d</pinta>', 'despacha', 'align=right');
$grid->column_orderby('Anterior', '<pinta><#modificado#>|<#existen#>|<#idfis#>|d</pinta>', 'existen', 'align=right');
$grid->column_orderby('Contado', '<caja>c|<#contado#>|<#idfis#>|true|<#dg_row_id#>|0|' . $cana . '</caja>', 'contado', 'align=right');
$grid->column('Agregar', '<caja>a|<#agregar#>|<#idfis#>|false|<#dg_row_id#>|1|' . $cana . '</caja>');
$grid->column('Quitar', '<caja>q|<#quitar#>|<#idfis#>|false|<#dg_row_id#>|2|' . $cana . '</caja>');
$grid->column('Sustituir', '<caja>s||<#idfis#>|false|<#dg_row_id#>|3|' . $cana . '</caja>');
$grid->build();
//echo $grid->db->last_query();
$data['script'] = '<script language="javascript" type="text/javascript">
function traer(cod){
$.post("' . site_url($this->url . 'traer') . '",{ codigo:cod,tabla:"' . $tabla . '" },function(data){
$("#Ic_"+cod).val(data);
$("#Ic_"+cod+"_val").text(data);
})
}
$(function(){
$(".inputnum").numeric(".");
$("input[id^=\'I\']").focus(function(){
var cod =$(this).attr("name");
traer(cod);
$(this).select();
});
$("input[id^=\'I\']").click(function(){
$(this).select();
});
$("input[id^=\'Ia_\']").change(function(){
var cod =$(this).attr("name");
var val = $("#Ia_"+cod).val();
var con = $("#Ic_"+cod).val();
$.post("' . site_url($this->url . 'agregar') . '",{ codigo:cod,valor:val,tabla:"' . $tabla . '",contado:con },function(data){
$("#Ia_"+cod).val(0);
if(data.length>0){
alert(data);
}else{
$("."+cod+"class").attr("style","color:orange;");
}
traer(cod);
});
});
$("input[id^=\'Iq_\']").change(function(){
var cod =$(this).attr("name");
var val = $("#Iq_"+cod).val();
var con = $("#Ic_"+cod).val();
$.post("' . site_url($this->url . 'quitar') . '",{ codigo:cod,valor:val,tabla:"' . $tabla . '",contado:con },function(data){
$("#Iq_"+cod).val(0);
if(data.length>0){
alert(data);
}else{
$("."+cod+"class").attr("style","color:orange;");
}
traer(cod);
});
});
$("input[id^=\'Is_\']").change(function(){
var cod =$(this).attr("name");
var val = $("#Is_"+cod).val();
var con = $("#Ic_"+cod).val();
$.post("' . site_url($this->url . 'sustituir') . '",{ codigo:cod,valor:val,tabla:"' . $tabla . '",contado:con },function(data){
$("#Is_"+cod).val("");
if(data.length>0){
alert(data);
}else{
$("."+cod+"class").attr("style","color:orange;");
}
traer(cod);
});
});
});
</script>
<style type="text/css">#conteotabla tr:hover { background-color: #ffff99; }</style>';
$leyenda = '<span style="color:orange">Recién contado</span> ';
$leyenda .= '<span style="color:red">Ya contado</span> ';
$leyenda .= '<span style="color:black">No se ha contado</span> ';
$salida = anchor($this->url, 'Regresar');
$data['content'] = $grid->output . $leyenda;
$data['filtro'] = $filter->output;
$data['title'] = heading("Conteo de inventario, fecha {$tifecha}, almacén {$tialmacen}");
$data['head'] = script('jquery.js');
$data['head'] .= script('plugins/jquery.numeric.pack.js') . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->datasis->modulo_id(75, 1);
$this->rapyd->load("datafilter2", "datagrid");
$script = '
$(function() {
$("#estadmin").change(function(){
$.post("' . site_url('presupuesto/presupuesto/get_tipo') . '",{ codigoadm:$("#estadmin").val() },function(data){$("#fondo").html(data);})
});
});
';
$filter = new DataFilter2("", "trasla");
$filter->script($script);
$filter->numero = new inputField("Número", "numero");
$filter->numero->size = 15;
$filter->nrooficio = new inputField("Decreto", "nrooficio");
$filter->nrooficio->size = 15;
$filter->fecha = new dateonlyField("Fecha", "fecha");
$filter->fecha->dbformat = "Y-m-d";
$filter->fecha->size = 12;
$filter->motivo = new inputField("Motivo", "motivo");
$filter->motivo->size = 40;
$filter->status = new dropdownField("Estado", "status");
$filter->status->option("", "");
$filter->status->option("P", "Sin Ejecutar");
$filter->status->option("C", "Ejecutado");
$filter->status->style = "width:100px";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('presupuesto/trasla/dataedit/show/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>');
function sta($status)
{
switch ($status) {
case "P":
return "Sin Ejecutar";
break;
case "C":
return "Ejecutado";
break;
//case "O":return "Ordenado Pago";break;
//case "O":return "Ordenado Pago";break;
case "A":
return "Anulado";
break;
}
}
$grid = new DataGrid("");
$grid->order_by("numero", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad');
$grid->use_function('sta');
$grid->column_orderby("Número", $uri, "numero");
$grid->column_orderby("Decreto", "nrooficio", "nrooficio");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'");
$grid->column_orderby("Motivo", "<#motivo#>|50|\n|true</wordwrap>", "motivo", "align='left' ");
$grid->column_orderby("Disminucion", "tdisminucion", "tdisminucion", "align='right'");
$grid->column_orderby("Aumento", "taumento", "taumento", "align='right'");
$grid->column_orderby("Estado", "<sta><#status#></sta>", "status", "align='center'");
//$grid->column("E. Administrativa." ,"estadmin");
//$grid->column("Fondo" ,"fondo");
$grid->add("presupuesto/trasla/dataedit/create");
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "Traslados de Partidas";
//$data['content'] = $filter->output.$grid->output;
//$data['title'] = " Traslado de Partidas ";
$data["head"] = script("jquery.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function inven($tabla)
{
$this->rapyd->load("datagrid", "dataobject", "fields", "datafilter2");
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'titulo' => 'Buscar Proveedor');
$bSPRV = $this->datasis->modbus($mSPRV);
$link2 = site_url('inventario/common/get_linea');
$link3 = site_url('inventario/common/get_grupo');
$script = '
$(document).ready(function(){
$("#depto").change(function(){
depto();
$.post("' . $link2 . '",{ depto:$(this).val() },function(data){$("#linea").html(data);})
$.post("' . $link3 . '",{ linea:"" },function(data){$("#grupo").html(data);})
});
$("#linea").change(function(){
linea();
$.post("' . $link3 . '",{ linea:$(this).val() },function(data){$("#grupo").html(data);})
});
$("#grupo").change(function(){
grupo();
});
depto();
linea();
grupo();
});
function depto(){
if($("#depto").val()!=""){
$("#nom_depto").attr("disabled","disabled");
}
else{
$("#nom_depto").attr("disabled","");
}
}
function linea(){
if($("#linea").val()!=""){
$("#nom_linea").attr("disabled","disabled");
}
else{
$("#nom_linea").attr("disabled","");
}
}
function grupo(){
if($("#grupo").val()!=""){
$("#nom_grupo").attr("disabled","disabled");
}
else{
$("#nom_grupo").attr("disabled","");
}
}';
$filter = new DataFilter2("Filtro por Producto");
$filter->db->select("e.existen,e.modificado,e.contado,e.agregar,e.quitar,e.sustituir,a.tipo AS tipo,id,e.codigo,a.descrip,precio1,precio2,precio3,precio4,b.nom_grup AS nom_grup,b.grupo AS grupoid,c.descrip AS nom_linea,c.linea AS linea,d.descrip AS nom_depto,d.depto AS depto");
$filter->db->from("{$tabla} AS e");
$filter->db->join('sinv AS a', 'a.codigo=e.codigo');
$filter->db->join('grup AS b', 'a.grupo=b.grupo');
$filter->db->join('line AS c', 'b.linea=c.linea');
$filter->db->join('dpto AS d', 'c.depto=d.depto');
$filter->db->where('activo', 'S');
$filter->db->where('actualizado IS NULL', '', false);
$filter->script($script);
$filter->codigo = new inputField('Código', 'codigo');
$filter->codigo->db_name = 'e.codigo';
$filter->codigo->size = 25;
$filter->descrip = new inputField("Descripción", "descrip");
$filter->descrip->db_name = 'CONCAT_WS(" ",a.descrip,a.descrip2)';
$filter->descrip->size = 25;
$filter->tipo = new dropdownField("Tipo", "tipo");
$filter->tipo->db_name = "a.tipo";
$filter->tipo->option("", "Todos");
$filter->tipo->option("Articulo", "Artículo");
$filter->tipo->option("Servicio", "Servicio");
$filter->tipo->option("Descartar", "Descartar");
$filter->tipo->option("Consumo", "Consumo");
$filter->tipo->option("Fraccion", "Fracción");
$filter->tipo->style = 'width:220px;';
$filter->clave = new inputField("Clave", "clave");
$filter->clave->size = 25;
$filter->activo = new dropdownField("Activo", "activo");
$filter->activo->option("", "Todos");
$filter->activo->option("S", "Si");
$filter->activo->option("N", "No");
$filter->activo->style = 'width:220px;';
$filter->proveed = new inputField("Proveedor", "proveed");
$filter->proveed->append($bSPRV);
$filter->proveed->clause = "in";
$filter->proveed->db_name = '( a.prov1, a.prov2, a.prov3 )';
$filter->proveed->size = 25;
$filter->depto2 = new inputField("Departamento", "nom_depto");
$filter->depto2->db_name = "d.descrip";
$filter->depto2->size = 10;
$filter->depto = new dropdownField("Departamento", "depto");
$filter->depto->db_name = "d.depto";
$filter->depto->option("", "Seleccione un Departamento");
$filter->depto->options("SELECT depto, descrip FROM dpto WHERE tipo='I' ORDER BY depto");
$filter->depto->in = "depto2";
$filter->linea = new inputField("Linea", "nom_linea");
$filter->linea->db_name = "c.descrip";
$filter->linea->size = 10;
$filter->linea2 = new dropdownField("Línea", "linea");
$filter->linea2->db_name = "c.linea";
$filter->linea2->option("", "Seleccione un Departamento primero");
$filter->linea2->in = "linea";
$depto = $filter->getval('depto');
if ($depto !== FALSE) {
$filter->linea2->options("SELECT linea, descrip FROM line WHERE depto='{$depto}' ORDER BY descrip");
} else {
$filter->linea2->option("", "Seleccione un Departamento primero");
}
$filter->grupo2 = new inputField("Grupo", "nom_grupo");
$filter->grupo2->db_name = "b.nom_grup";
$filter->grupo2->size = 10;
$filter->grupo = new dropdownField("Grupo", "grupo");
$filter->grupo->db_name = "b.grupo";
$filter->grupo->option("", "Seleccione una Línea primero");
$filter->grupo->in = "grupo2";
$linea = $filter->getval('linea2');
if ($linea !== FALSE) {
$filter->grupo->options("SELECT grupo, nom_grup FROM grup WHERE linea='{$linea}' ORDER BY nom_grup");
} else {
$filter->grupo->option("", "Seleccione un Departamento primero");
}
$filter->marca = new dropdownField("Marca", "marca");
$filter->marca->option('', 'Todas');
$filter->marca->options("SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM marc ORDER BY marca");
$filter->marca->style = 'width:220px;';
$filter->buttons("reset", "search");
$filter->build();
function caja($campo2, $valor, $codigo, $readonly = false)
{
$campo = new inputField2("Title", $campo2);
$campo->status = "create";
$campo->css_class = 'inputnum';
$campo->size = 10;
$campo->insertValue = $valor;
$campo->readonly = $readonly;
$campo->name = $codigo;
$campo->id = 'I' . $campo2 . '_' . $codigo;
$campo->build();
return $campo->output;
}
function pinta($modifi, $cont)
{
if ($modifi == null) {
return $cont;
} else {
return "<span style='color:FF0000;'>{$cont}</span>";
}
}
$atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '0', 'screeny' => '0');
$titulo = anchor_popup("reportes/ver/INVFIS/{$tabla}", 'Imprimir', $atts);
$grid = new DataGrid("Inventario Fisico -->" . $titulo);
$grid->per_page = 10;
$grid->db->limit = 10;
$grid->use_function('caja', 'pinta');
$grid->column_orderby("Codigo", "<pinta><#modificado#>|<#codigo#></pinta>", "codigo", 'align=center');
$grid->column_orderby("Descripción", "<pinta><#modificado#>|<#descrip#></pinta>", "descrip");
$grid->column_orderby("Anterior", "<pinta><#modificado#>|<#existen#></pinta>", "existen", 'align=right');
$grid->column_orderby("Contado", "<caja>c|<#contado#>|<#codigo#>|true</caja>");
$grid->column("Agregar", "<caja>a|<#agregar#>|<#codigo#></caja>");
$grid->column("Quitar", "<caja>q|<#quitar#>|<#codigo#></caja>");
$grid->column("Sustituir", "<caja>s|<#sustituir#>|<#codigo#></caja>");
$grid->build();
//echo $grid->db->last_query();
$data['script'] = '<script language="javascript" type="text/javascript">
$(function() {
$(".inputnum").numeric(".");
function traer(cod){
$.post("' . site_url($this->url . 'traer') . '",{ codigo:cod,tabla:"' . $tabla . '" },function(data){
$("#Ic_"+cod).val(data);
})
}
$("input[id^=\'I\']").focus(function(){
cod =$(this).attr("name");
traer(cod);
});
$("input[id^=\'Ia_\']").change(function(){
cod =$(this).attr("name");
val = $("#Ia_"+cod).val();
con = $("#Ic_"+cod).val();
$.post("' . site_url($this->url . 'agregar') . '",{ codigo:cod,valor:val,tabla:"' . $tabla . '",contado:con },function(data){
$("#Ia_"+cod).val(0);
if(data){
alert(data);
}
})
traer(cod);
});
$("input[id^=\'Iq_\']").change(function(){
cod =$(this).attr("name");
val = $("#Iq_"+cod).val();
con = $("#Ic_"+cod).val();
$.post("' . site_url($this->url . 'quitar') . '",{ codigo:cod,valor:val,tabla:"' . $tabla . '",contado:con },function(data){
$("#Iq_"+cod).val(0);
if(data){
alert(data);
}
})
traer(cod);
});
$("input[id^=\'Is_\']").change(function(){
cod =$(this).attr("name");
val = $("#Is_"+cod).val();
con = $("#Ic_"+cod).val();
$.post("' . site_url($this->url . 'sustituir') . '",{ codigo:cod,valor:val,tabla:"' . $tabla . '",contado:con },function(data){
$("#Is_"+cod).val(0);
if(data){
alert(data);
}
})
traer(cod);
});
});
</script>';
$salida = anchor($this->url, "Regresar");
$data['content'] = $filter->output . $salida . $grid->output;
//$data['title'] = "($codigoadm) $codigoadmdes $tipo";
$data["head"] = script("jquery.js") . script("plugins/jquery.numeric.pack.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function cprecios()
{
$this->rapyd->uri->keep_persistence();
$cpre = $this->input->post('pros');
if ($cpre !== false) {
$msj = $this->_cprecios();
} else {
$msj = '';
}
$this->rapyd->load('datafilter2', 'datagrid');
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Código', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'titulo' => 'Buscar Proveedor');
$bSPRV = $this->datasis->modbus($mSPRV);
$link2 = site_url('inventario/common/get_linea');
$link3 = site_url('inventario/common/get_grupo');
$script = '
$(document).ready(function(){
$(".inputnum").numeric(".");
$("#depto").change(function(){
depto();
$.post("' . $link2 . '",{ depto:$(this).val() },function(data){$("#linea").html(data);})
$.post("' . $link3 . '",{ linea:"" },function(data){$("#grupo").html(data);})
});
$("#linea").change(function(){
linea();
$.post("' . $link3 . '",{ linea:$(this).val() },function(data){$("#grupo").html(data);})
});
$("#grupo").change(function(){
grupo();
});
$("#sinvprecioc").submit(function() {
return confirm("Se van a actualizar todos los precios en pantalla \\nEstas seguro de que quieres seguir??");
});
depto();
linea();
grupo();
});
function depto(){
if($("#depto").val()!=""){
$("#nom_depto").attr("disabled","disabled");
}
else{
$("#nom_depto").attr("disabled","");
}
}
function linea(){
if($("#linea").val()!=""){
$("#nom_linea").attr("disabled","disabled");
}
else{
$("#nom_linea").attr("disabled","");
}
}
function grupo(){
if($("#grupo").val()!=""){
$("#nom_grupo").attr("disabled","disabled");
}
else{
$("#nom_grupo").attr("disabled","");
}
}';
$filter = new DataFilter2('Filtro por Producto');
$select = array('IF(formcal=\'U\',ultimo,IF(formcal=\'P\',pond,IF(formcal=\'S\',standard,GREATEST(ultimo,pond)))) AS costo', 'a.existen', 'a.marca', 'a.tipo', 'a.id', 'TRIM(codigo) AS codigo', 'a.descrip', 'precio1', 'precio2', 'precio3', 'precio4', 'b.nom_grup', 'b.grupo', 'c.descrip AS nom_linea', 'c.linea', 'd.descrip AS nom_depto', 'd.depto AS depto', 'a.base1', 'a.base2', 'a.base3', 'a.base4');
$filter->db->select($select);
$filter->db->from('sinv AS a');
$filter->db->join('grup AS b', 'a.grupo=b.grupo');
$filter->db->join('line AS c', 'b.linea=c.linea');
$filter->db->join('dpto AS d', 'c.depto=d.depto');
$filter->db->where('a.activo', 'S');
$filter->script($script);
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 15;
$filter->codigo->group = "Uno";
$filter->descrip = new inputField("Descripción", "descrip");
$filter->descrip->db_name = 'CONCAT_WS(" ",a.descrip,a.descrip2)';
$filter->descrip->size = 30;
$filter->descrip->group = "Uno";
$filter->tipo = new dropdownField("Tipo", "tipo");
$filter->tipo->db_name = "a.tipo";
$filter->tipo->option('', "Todos");
$filter->tipo->option("Articulo", "Artículo");
$filter->tipo->option("Servicio", "Servicio");
$filter->tipo->option("Descartar", "Descartar");
$filter->tipo->option("Consumo", "Consumo");
$filter->tipo->option("Fraccion", "Fracción");
$filter->tipo->style = 'width:120px;';
$filter->tipo->group = "Uno";
$filter->clave = new inputField("Clave", "clave");
$filter->clave->size = 15;
$filter->clave->group = "Uno";
$filter->proveed = new inputField("Proveedor", "proveed");
$filter->proveed->append($bSPRV);
$filter->proveed->db_name = 'CONCAT_WS("-",`a`.`prov1`, `a`.`prov2`, `a`.`prov3`)';
$filter->proveed->size = 10;
$filter->proveed->group = "Dos";
$filter->depto2 = new inputField("Departamento", "nom_depto");
$filter->depto2->db_name = "d.descrip";
$filter->depto2->size = 5;
$filter->depto2->group = "Dos";
$filter->depto = new dropdownField("Departamento", "depto");
$filter->depto->db_name = "d.depto";
$filter->depto->option("", "Seleccione un Departamento");
$filter->depto->options("SELECT depto, CONCAT(depto,'-',descrip) descrip FROM dpto WHERE tipo='I' ORDER BY depto");
$filter->depto->in = "depto2";
$filter->depto->group = "Dos";
$filter->depto->style = 'width:190px;';
$filter->linea = new inputField('Linea', 'nom_linea');
$filter->linea->db_name = 'c.descrip';
$filter->linea->size = 5;
$filter->linea->group = 'Dos';
$filter->linea2 = new dropdownField('Línea', 'linea');
$filter->linea2->db_name = 'c.linea';
$filter->linea2->option('', "Seleccione un Departamento primero");
$filter->linea2->in = 'linea';
$filter->linea2->group = 'Dos';
$filter->linea2->style = 'width:190px;';
$depto = $filter->getval('depto');
if ($depto !== false) {
$filter->linea2->options("SELECT linea, CONCAT(linea,'-',descrip) descrip FROM line WHERE depto='{$depto}' ORDER BY descrip");
} else {
$filter->linea2->option("", "Seleccione un Departamento primero");
}
$filter->grupo2 = new inputField('Grupo', 'nom_grupo');
$filter->grupo2->db_name = 'b.nom_grup';
$filter->grupo2->size = 5;
$filter->grupo2->group = 'Dos';
$filter->grupo = new dropdownField('Grupo', 'grupo');
$filter->grupo->db_name = 'b.grupo';
$filter->grupo->option('', 'Seleccione una Línea primero');
$filter->grupo->in = 'grupo2';
$filter->grupo->group = 'Dos';
$filter->grupo->style = 'width:190px;';
$linea = $filter->getval('linea2');
if ($linea !== false) {
$filter->grupo->options("SELECT grupo, CONCAT(grupo,'-',nom_grup) nom_grup FROM grup WHERE linea='{$linea}' ORDER BY nom_grup");
} else {
$filter->grupo->option("", "Seleccione un Departamento primero");
}
$filter->marca = new dropdownField("Marca", "marca");
$filter->marca->option('', 'Todas');
$filter->marca->options("SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM marc ORDER BY marca");
$filter->marca->style = 'width:220px;';
$filter->marca->group = "Dos";
$filter->buttons('reset', 'search');
$filter->build('dataformfiltro');
$ggrid = '';
if ($filter->is_valid()) {
$attr = array('id' => 'sinvprecioc');
$ggrid = form_open(uri_string(), $attr);
foreach ($filter->_fields as $field_name => $field_copy) {
$ggrid .= form_hidden($field_copy->id, $field_copy->value);
}
$grid = new DataGrid('Artículos de Inventario');
$grid->order_by('codigo', 'asc');
$grid->per_page = 15;
$link = anchor('inventario/sinv/dataedit/show/<#id#>', '<#codigo#>');
$uri_2 = anchor('inventario/sinv/dataedit/create/<#id#>', 'Duplicar');
$grid->column_orderby('Código', 'codigo', 'codigo');
$grid->column_orderby('Descripción', 'descrip', 'descrip');
$grid->column_orderby('Marca', 'marca', 'marca');
for ($i = 1; $i < 5; $i++) {
$obj = 'precio' . $i;
${$obj} = new inputField($obj, $obj);
${$obj}->grid_name = $obj . '[<#id#>]';
${$obj}->status = 'modify';
${$obj}->size = 8;
${$obj}->css_class = 'inputnum';
${$obj}->autocomplete = false;
$grid->column("Precio {$i}", ${$obj}, 'align=right');
}
$grid->column('Costo', '<nformat><#costo#></nformat>', 'align=right');
$grid->column('Existencia', '<nformat><#existen#></nformat>', 'align=right');
$grid->submit('pros', 'Cambiar', 'BR');
$grid->build();
$ggrid .= $grid->output;
$ggrid .= form_close();
//echo $this->db->last_query();
}
$data['content'] = '<div class="alert">' . $msj . '</div>';
$data['content'] .= $ggrid;
$data['filtro'] = $filter->output;
$data['title'] = heading('Cambio de precios');
$data['head'] = $this->rapyd->get_head() . script('jquery.pack.js');
$data['head'] .= script('plugins/jquery.numeric.pack.js') . script('plugins/jquery.floatnumber.js');
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->datasis->modulo_id(310, 1);
$this->rapyd->load("datafilter2", "datagrid");
$this->rapyd->uri->keep_persistence();
//rapydlib("prototype");
$ajax_onchange = '
function get_linea(){
var url = "' . site_url('reportes/sinvlineas') . '";
var pars = "dpto="+$F("depto");
var myAjax = new Ajax.Updater("td_linea", url, { method: "post", parameters: pars });
}
function get_grupo(){
var url = "' . site_url('reportes/sinvgrupos') . '";
var pars = "dpto="+$F("depto")+"&linea="+$F("linea");
var myAjax = new Ajax.Updater("td_grupo", url, { method: "post", parameters: pars });
}';
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Código', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'titulo' => 'Buscar Proveedor');
$bSPRV = $this->datasis->modbus($mSPRV);
$filter = new DataFilter2("Filtro por Producto");
if ($this->input->post("fotos")) {
$ddire = '';
} else {
$ddire = 'left';
}
$filter->db->select("a.codigo as scodigo,a.descrip,a.grupo,b.codigo,a.id, a.marca, a.precio1,a.precio2,a.precio3,a.precio4");
$filter->db->from("sinv AS a");
$filter->db->join("sinvfot AS b", "a.codigo=b.codigo", $ddire);
$filter->db->groupby("a.codigo");
$filter->script($ajax_onchange);
$filter->codigo = new inputField("Código", "a.codigo");
$filter->codigo->size = 15;
$filter->clave = new inputField("Clave", "clave");
$filter->clave->size = 15;
$filter->proveed = new inputField("Proveedor", "proveed");
$filter->proveed->append($bSPRV);
$filter->proveed->clause = "in";
$filter->proveed->db_name = '( a.prov1, a.prov2, a.prov3 )';
$filter->proveed->size = 15;
$filter->descrip = new inputField("Descripción", "a.descrip");
$filter->descrip->db_name = 'CONCAT_WS(" ",descrip,descrip2)';
$filter->descrip->size = 34;
$filter->dpto = new dropdownField("Departamento", "depto");
$filter->dpto->clause = '';
$filter->dpto->option("", "");
$filter->dpto->options("SELECT depto, descrip FROM dpto ORDER BY descrip");
$filter->dpto->onchange = "get_linea();";
//$filter->dpto->style = "width:220px";
$filter->linea = new dropdownField("Linea", "linea");
$filter->linea->clause = '';
$filter->linea->option("", "Seleccione un departamento");
$filter->linea->onchange = "get_grupo();";
//$filter->linea->style = "width:300px";
$filter->grupo = new dropdownField("Grupo", "grupo");
$filter->grupo->db_name = "a.grupo";
$filter->grupo->option("", "Seleccione una Linea");
//$filter->grupo->style = "width:220px";
$filter->marca = new dropdownField("Marca", "marca");
$filter->marca->option("", "");
$filter->marca->options("SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM marc ORDER BY marca");
$filter->marca->style = "width:140px";
$filter->fotos = new checkboxField("Mostrar solo productos con fotos", "fotos", "y", "n");
$filter->fotos->clause = '';
$filter->fotos->insertValue = "n";
$filter->buttons("reset", "search");
$filter->build('dataformfiltro');
$grid = new DataGrid("Lista de Artículos");
$grid->order_by("a.codigo", "asc");
$grid->per_page = 50;
$link = anchor('/inventario/fotos/dataedit/<#id#>/create/', '<#scodigo#>');
$grid->use_function('str_replace');
$grid->column("Código", $link);
$grid->column("Descripción", 'descrip');
$grid->column("Precio 1", "<nformat><#precio1#></nformat>", 'align=Right');
$grid->column("Precio 2", "<nformat><#precio2#></nformat>", 'align=Right');
$grid->column("Precio 3", "<nformat><#precio3#></nformat>", 'align=Right');
$grid->column("Precio 4", "<nformat><#precio4#></nformat>", 'align=Right');
$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>';
//****************************************
$data['content'] = $grid->output;
$data['filtro'] = $filter->output;
$data['script'] = script('jquery.js');
$data['head'] = $this->rapyd->get_head();
$data['style'] = $style;
$data['extras'] = $extras;
$data['title'] = '<h1>Lista de Artículos para Fotos </h1>';
$this->load->view('view_ventanas', $data);
}
function filteredgrid($para = '')
{
$this->rapyd->load("datafilter2", "datagrid", "dataobject", "fields");
$user = $this->session->userdata('usuario');
$link2 = site_url('inventario/common/get_linea');
$link3 = site_url('inventario/common/get_grupo');
$link4 = site_url('inventario/gfotos/tabla');
$link5 = site_url();
$script = '
function atras(){
window.location="' . $link5 . '/";
}
$(document).ready(function(){
$("#depto").change(function(){
$("#objnumero").val("");
depto();
$.post("' . $link2 . '",{ depto:$(this).val() },function(data){$("#linea").html(data);})
$.post("' . $link3 . '",{ linea:"" },function(data){$("#grupo").html(data);})
});
$("#linea").change(function(){
linea();
$.post("' . $link3 . '",{ linea:$(this).val() },function(data){$("#grupo").html(data);})
});
$("#grupo").change(function(){
grupo();
});
depto();
linea();
grupo();
});
function depto(){
if($("#depto").val()!=""){
$("#nom_depto").attr("disabled","disabled");
}
else{
$("#nom_depto").attr("disabled","");
}
}
function linea(){
if($("#linea").val()!=""){
$("#nom_linea").attr("disabled","disabled");
}
else{
$("#nom_linea").attr("disabled","");
}
}
function grupo(){
if($("#grupo").val()!=""){
$("#nom_grupo").attr("disabled","disabled");
}
else{
$("#nom_grupo").attr("disabled","");
}
}
';
$filter = new DataFilter2("Filtro por Producto");
$filter->db->_escape_char = '';
$filter->db->_protect_identifiers = false;
$filter->script($script);
$filter->descrip = new inputField("Descripción", "descrip");
$filter->descrip->db_name = 'CONCAT_WS(" ",a.descrip,a.descrip2)';
$filter->descrip->size = 25;
$filter->depto = new dropdownField("Departamento", "depto");
$filter->depto->db_name = "d.depto";
$filter->depto->option("", "Seleccione un Departamento");
$filter->depto->options("SELECT depto, descrip FROM dpto WHERE tipo='I' ORDER BY depto");
$filter->linea2 = new dropdownField("Línea", "linea");
$filter->linea2->db_name = "c.linea";
$filter->linea2->option("", "Seleccione un Departamento primero");
$depto = $filter->getval('depto');
if ($depto !== FALSE) {
$filter->linea2->options("SELECT linea, descrip FROM line WHERE depto='{$depto}' ORDER BY descrip");
} else {
$filter->linea2->option("", "Seleccione un Departamento primero");
}
$filter->grupo = new dropdownField("Grupo", "grupo");
$filter->grupo->db_name = "b.grupo";
$filter->grupo->option("", "Seleccione una Línea primero");
$linea = $filter->getval('linea2');
if ($linea !== FALSE) {
$filter->grupo->options("SELECT grupo, nom_grup FROM grup WHERE linea='{$linea}' ORDER BY nom_grup");
} else {
$filter->grupo->option("", "Seleccione un Departamento primero");
}
$filter->marca = new dropdownField("Marca", "marca");
$filter->marca->option("", "");
$filter->marca->options("SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM marc ORDER BY marca");
$filter->marca->style = 'width:220px;';
$filter->buttons("reset", "search");
$filter->build();
$tabla = "";
if ($this->rapyd->uri->is_set("search") and $filter->is_valid()) {
$tabla = form_open("forma/ver/catalogo2");
$grid = new DataGrid("Lista de Artículos Para el Catalogo");
$grid->db->select("COUNT(*) AS num,GROUP_CONCAT(a.codigo) as articulos,\n\t\t\te.sinv_id as sinv_id,e.nombre AS nombre,e.ruta AS ruta,\n\t\t\te.comentario AS comentario,e.principal AS principal,\n\t\t\ta.tipo AS tipo,a.id as id,a.codigo as codigo,a.descrip,\n\t\t\tb.nom_grup AS nom_grup, b.grupo AS grupoid,\n\t\t\tc.descrip AS nom_linea, c.linea AS linea,\n\t\t\td.descrip AS nom_depto, d.depto AS depto");
$grid->db->from("sinv AS a");
$grid->db->join("grup AS b", "a.grupo=b.grupo");
$grid->db->join("line AS c", "b.linea=c.linea");
$grid->db->join("dpto AS d", "c.depto=d.depto");
$grid->db->join("sinvfot AS e", "e.sinv_id=a.id");
$grid->db->group_by("e.nombre");
$grid->db->_escape_char = '';
$grid->db->_protect_identifiers = false;
$grid->order_by("codigo", "asc");
$grid->use_function('asigna');
$grid->column_orderby("código", "codigo", "codigo");
$grid->column_orderby("Departamento", "<#nom_depto#>", "nom_depto", 'align=left');
$grid->column_orderby("Línea", "<#nom_linea#>", "nom_linea", 'align=left');
$grid->column_orderby("Grupo", "<#nom_grup#>", "nom_grup", 'align=left');
$grid->column_orderby("Descripción", "descrip", "descrip");
// $grid->column("Nombre","nombre");
$grid->build();
$consul = $this->db->last_query();
// $options = array(
// 'D' => 'DESCARGAR',
// 'I' => 'VER',
// );
$tabla .= form_hidden('consul', $consul);
//$tabla.=$grid->output.form_dropdown('opcion', $options, 'D').form_submit('mysubmit', 'Generar');
$tabla .= $grid->output . form_submit('mysubmit', 'Generar');
$tabla .= form_close();
}
$back = "<table width='100%'border='0'><tr><td width='80%'></td><td width='20%'><a href='javascript:atras()'><spam id='regresar'align='right'>REGRESAR</spam></a></td></tr></table>";
//$data['filtro']=$filter->output;
$data['content'] = $filter->output . $tabla;
//$data['smenu'] = $back;//.$grid->output;
$data['title'] = "Genera Catalogo";
$data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . script("sinvmaes2.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$script = '
$(function() {
$("#estadmin").change(function(){
$.post("' . site_url('presupuesto/presupuesto/get_tipo') . '",{ codigoadm:$("#estadmin").val() },function(data){$("#fondo").html(data);})
});
});
';
$filter = new DataFilter2("", "audis");
$filter->script($script);
$filter->numero = new inputField("Número", "numero");
$filter->numero->size = 15;
//$filter->numero->clause="likerigth";
$filter->nrooficio = new inputField("Decreto", "nrooficio");
$filter->nrooficio->size = 15;
$filter->tipo = new dropdownField("Tipo", "tipo");
$filter->tipo->option("", "Aumentos y Disminuciones");
$filter->tipo->option("AUMENTO", "Aumentos");
$filter->tipo->option("DISMINUCION", "Disminuciones");
$filter->fecha = new dateonlyField("Fecha", "fecha");
$filter->fecha->dbformat = "Y-m-d";
$filter->fecha->size = 12;
$filter->estadmin = new dropdownField("E. Administrativa", "estadmin");
$filter->estadmin->rule = 'required';
$filter->estadmin->option("", "");
$filter->estadmin->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->fondo = new dropdownField("Fondos", "fondo");
$filter->motivo = new inputField("Motivo", "motivo");
$filter->motivo->size = 40;
$filter->status = new dropdownField("Estado", "status");
$filter->status->option("", "");
$filter->status->option("P", "Sin Ejecutar");
$filter->status->option("C", "Ejecutado");
$filter->status->style = "width:100px";
// $filter->total = new inputField("Total", "total");
// $filter->total->size=15;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('presupuesto/audis/dataedit/show/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>');
function sta($status)
{
switch ($status) {
case "P":
return "Sin Ejecutar";
break;
case "C":
return "Ejecutado";
break;
//case "O":return "Ordenado Pago";break;
//case "A":return "Anulado";break;
}
}
$grid = new DataGrid("");
$grid->order_by("numero", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad');
$grid->use_function('sta');
$grid->column_orderby("Número", $uri, "numero");
$grid->column_orderby("Decreto", "nrooficio", "nrooficio");
$grid->column_orderby("Tipo", "tipo", "tipo");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'");
$grid->column_orderby("Motivo", "motivo", "motivo");
$grid->column_orderby("Total", "total", "total", "align='right'");
$grid->column_orderby("Estado", "<sta><#status#></sta>", "status", "align='center'NOWRAP");
$grid->add("presupuesto/audis/dataedit/create");
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "Aumentos y Disminuciones";
//$data['content'] = $filter->output.$grid->output;
//$data['title'] = " Aumentos y Disminuciones ";
$data["head"] = script("jquery.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
rapydlib("prototype");
$ajax_onchange = '
function get_linea(){
var url = "' . site_url('reportes/sinvlineas') . '";
var pars = "dpto="+$F("depto");
var myAjax = new Ajax.Updater("td_linea", url, { method: "post", parameters: pars });
}
function get_grupo(){
var url = "' . site_url('reportes/sinvgrupos') . '";
var pars = "dpto="+$F("depto")+"&linea="+$F("linea");
var myAjax = new Ajax.Updater("td_grupo", url, { method: "post", parameters: pars });
}';
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Código', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'titulo' => 'Buscar Proveedor');
$bSPRV = $this->datasis->modbus($mSPRV);
$filter = new DataFilter2("Filtro por Producto");
if ($this->input->post("fotos")) {
$ddire = '';
} else {
$ddire = 'left';
}
$filter->db->select("a.codigo as scodigo,a.descrip,a.grupo,b.codigo,a.id,a.precio1,a.precio2,a.precio3,a.precio4");
$filter->db->from("sinv AS a");
$filter->db->join("sinvfot AS b", "a.codigo=b.codigo", $ddire);
$filter->db->groupby("a.codigo");
$filter->script($ajax_onchange);
$filter->codigo = new inputField("Código", "a.codigo");
$filter->codigo->size = 15;
$filter->clave = new inputField("Clave", "clave");
$filter->clave->size = 15;
$filter->proveed = new inputField("Proveedor", "proveed");
$filter->proveed->append($bSPRV);
$filter->proveed->clause = "in";
$filter->proveed->db_name = '( a.prov1, a.prov2, a.prov3 )';
$filter->proveed->size = 15;
$filter->descrip = new inputField("Descripción", "a.descrip");
$filter->descrip->db_name = 'CONCAT_WS(" ",descrip,descrip2)';
$filter->descrip->size = 34;
$filter->dpto = new dropdownField("Departamento", "depto");
$filter->dpto->clause = '';
$filter->dpto->option("", "");
$filter->dpto->options("SELECT depto, descrip FROM dpto ORDER BY descrip");
$filter->dpto->onchange = "get_linea();";
//$filter->dpto->style = "width:220px";
$filter->linea = new dropdownField("Linea", "linea");
$filter->linea->clause = '';
$filter->linea->option("", "Seleccione un departamento");
$filter->linea->onchange = "get_grupo();";
//$filter->linea->style = "width:300px";
$filter->grupo = new dropdownField("Grupo", "grupo");
$filter->grupo->db_name = "a.grupo";
$filter->grupo->option("", "Seleccione una Linea");
//$filter->grupo->style = "width:220px";
$filter->marca = new dropdownField("Marca", "marca");
$filter->marca->option("", "");
$filter->marca->options("SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM marc ORDER BY marca");
$filter->marca->style = "width:140px";
$filter->fotos = new checkboxField("Mostrar solo productos con fotos", "fotos", "y", "n");
$filter->fotos->clause = '';
$filter->fotos->insertValue = "n";
$filter->buttons("reset", "search");
$filter->build();
$grid = new DataGrid("Lista de Artículos");
$grid->order_by("a.codigo", "asc");
$grid->per_page = 15;
$link = anchor('/inventario/fotos/dataedit/<#id#>/create/', '<#scodigo#>');
$grid->use_function('str_replace');
$grid->column("Código", $link);
$grid->column("Descripción", "descrip");
$grid->column("Precio 1", "<number_format><#precio1#>|2|,|.</number_format>", 'align=Right');
$grid->column("Precio 2", "<number_format><#precio2#>|2|,|.</number_format>", 'align=Right');
$grid->column("Precio 3", "<number_format><#precio3#>|2|,|.</number_format>", 'align=Right');
$grid->column("Precio 4", "<number_format><#precio4#>|2|,|.</number_format>", 'align=Right');
$grid->build();
//echo $grid->db->last_query();
$data['content'] = $filter->output . $grid->output;
$data["head"] = script("tabber.js") . script("prototype.js") . $this->rapyd->get_head() . script("scriptaculous.js") . script("effects.js");
$data['title'] = '<h1>Lista de Artículos</h1>';
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load('datafilter2', 'datagrid');
$link2 = site_url('inventario/common/get_linea');
$link3 = site_url('inventario/common/get_grupo');
$mSINV = array('tabla' => 'sinv', 'columnas' => array('codigo' => 'Cóodigo', 'descrip' => 'Descripción', 'descrip2' => 'Descripción 2'), 'filtro' => array('codigo' => 'Código', 'descrip' => 'Descripción'), 'retornar' => array('codigo' => 'codigo'), 'titulo' => 'Buscar Codigo');
$bSINV = $this->datasis->modbus($mSINV);
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Código', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'titulo' => 'Buscar Proveedor');
$bSPRV = $this->datasis->modbus($mSPRV);
$attr = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '0', 'screeny' => '0');
$op = array();
$mSQL = 'SELECT margen,CONCAT(margen,"%") AS val FROM sinvpromo GROUP BY margen';
$query = $this->db->query($mSQL);
if ($query->num_rows() > 0) {
foreach ($query->result() as $row) {
$op[$row->margen] = $row->val;
}
}
$sop = serialize($op);
function dropdown($cod, $margen, $sop)
{
$op = unserialize($sop);
return form_dropdown($cod, $op, $margen);
}
$js = 'function depto(){
if($("#depto").val()!=""){
$("#nom_depto").attr("disabled","disabled");
}else{
$("#nom_depto").attr("disabled","");
}
}
function linea(){
if($("#linea").val()!=""){
$("#nom_linea").attr("disabled","disabled");
}else{
$("#nom_linea").attr("disabled","");
}
}
function grupo(){
if($("#grupo").val()!=""){
$("#nom_grupo").attr("disabled","disabled");
}else{
$("#nom_grupo").attr("disabled","");
}
}';
$select = array('a.id', 'a.codigo', 'b.ultimo', 'b.descrip', 'b.marca', 'b.precio1', 'a.margen', 'a.cantidad', 'b.precio1*(1-(a.margen/100)) AS pfinal', 'b.id AS sinvid');
$filter = new DataFilter2('Filtro de promociones');
$filter->script($js);
$filter->db->select($select);
$filter->db->from('sinvpromo AS a');
$filter->db->join('sinv AS b', 'a.codigo=b.codigo');
$filter->codigo = new inputField('Código de producto', 'codigo');
$filter->codigo->db_name = 'a.codigo';
$filter->codigo->size = 15;
$filter->codigo->maxlength = 15;
$filter->codigo->append($bSINV);
$filter->descrip = new inputField('Descripción', 'descrip');
$filter->descrip->db_name = 'b.descrip';
$filter->proveed = new inputField('Proveedor', 'proveed');
$filter->proveed->append($bSPRV);
$filter->proveed->db_name = 'b.prov1';
$filter->proveed->size = 25;
$filter->depto = new dropdownField('Departamento', 'depto');
$filter->depto->db_name = 'b.depto';
$filter->depto->option("", "Seleccione un Departamento");
$filter->depto->options("SELECT depto, descrip FROM dpto WHERE tipo='I' ORDER BY depto");
$filter->linea2 = new dropdownField("Línea", "linea");
$filter->linea2->db_name = "b.linea";
$filter->linea2->option("", "Seleccione un Departamento primero");
$depto = $filter->getval('depto');
if ($depto !== FALSE) {
$filter->linea2->options("SELECT linea, descrip FROM line WHERE depto='{$depto}' ORDER BY descrip");
} else {
$filter->linea2->option("", "Seleccione un Departamento primero");
}
$filter->grupo = new dropdownField("Grupo", "grupo");
$filter->grupo->db_name = 'c.grupo';
$filter->grupo->option("", "Seleccione una Línea primero");
$linea = $filter->getval('linea2');
if ($linea !== FALSE) {
$filter->grupo->options("SELECT grupo, nom_grup FROM grup WHERE linea='{$linea}' ORDER BY nom_grup");
} else {
$filter->grupo->option('', 'Seleccione un Departamento primero');
}
$filter->margen = new dropdownField('Promoción', 'margen');
$filter->margen->db_name = 'a.margen';
$filter->margen->option('', 'Todas');
$filter->margen->options($op);
$filter->margen->style = 'width:120px;';
$filter->marca = new dropdownField('Marca', 'marca');
$filter->marca->db_name = 'b.marca';
$filter->marca->option('', 'Todas');
$filter->marca->options('SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM marc ORDER BY marca');
$filter->marca->style = 'width:220px;';
$filter->buttons('reset', 'search');
$filter->build();
$link = anchor('/inventario/sinvpromo/dataedit/modify/<#id#>', '<#codigo#>');
$llink = anchor_popup('inventario/consultas/preciosgeneral/<#codigo#>', 'Consultar precio', $attr);
$attr['width'] = '420';
$attr['height'] = '400';
$llin2 = anchor_popup('inventario/precios_sinv/dataedit/modify/<#sinvid#>', '<nformat><#precio1#></nformat>', $attr);
function pinta($u, $d, $char)
{
if ($u > $d) {
return "<b style='color:red'>{$char}</b>";
}
return "<b style='color:green'>{$char}</b>";
}
$grid = new DataGrid('Lista de Artículos');
$grid->use_function('dropdown', 'pinta');
$grid->order_by('codigo', 'asc');
$grid->per_page = 15;
$grid->column_orderby('Código', $link, 'codigo');
$grid->column_orderby('Descripción', '<pinta><#ultimo#>|<#pfinal#>|<#descrip#></pinta>', 'descrip');
$grid->column_orderby('Costo', '<nformat><#ultimo#></nformat>', 'ultimo', 'align=\'right\'');
$grid->column_orderby('P.Final', '<nformat><#pfinal#></nformat>', 'pfinal', 'align=\'right\'');
$grid->column_orderby('PVP', $llin2, 'precio1', 'align=\'right\'');
$grid->column_orderby('Marca', 'marca', 'marca');
$grid->column_orderby('Promoción', "<dropdown><#id#>|<#margen#>|{$sop}</dropdown>", 'margen', 'align="right"');
$grid->column('Consulta', $llink);
//$grid->column_orderby('F.Desde' ,'<dbdate_to_human>fechad</dbdate_to_human>','fechad');
//$grid->column_orderby('F.Hasta' ,'<dbdate_to_human>fechah</dbdate_to_human>','fechah');
$grid->add('inventario/sinvpromo/dataedit/create');
$grid->build();
//echo $grid->db->last_query();
$this->rapyd->jquery[] = '
$("select:not(#margen)").change( function() {
$.ajax({
type: "POST",
url: "' . site_url('inventario/sinvpromo/cmargen') . '",
data: "cod="+$(this).attr("name")+"&margen="+$(this).val(),
success: function(msg){
if (msg=="0"){
alert("Error al actualizar");
}
} });
});';
$this->rapyd->jquery[] = '
$("#depto").change(function(){
depto();
$.post("' . $link2 . '",{ depto:$(this).val() },function(data){$("#linea").html(data);})
$.post("' . $link3 . '",{ linea:"" },function(data){$("#grupo").html(data);})
});
$("#linea").change(function(){
linea();
$.post("' . $link3 . '",{ linea:$(this).val() },function(data){$("#grupo").html(data);})
});
$("#grupo").change(function(){
grupo();
});
depto();linea();grupo();';
$data['content'] = $filter->output . form_open('', array('id' => 'selec_promo')) . $grid->output . form_close();
$data['title'] = '<h1>Descuentos promocionales</h1>';
$data['head'] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
<?php
$base_process_uri = $this->rapyd->uri->implode_uri("base_uri", "gfid", "orderby");
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'rif' => 'Rif', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre', 'rif' => 'Rif'), 'retornar' => array('proveed' => 'cod_prov'), 'titulo' => 'Buscar Proveedor');
$bSPRV = $this->datasis->p_modbus($mSPRV, "proveed");
$script = '
$(function() {
$("#estadmin").change(function(){
$.post("' . site_url('presupuesto/presupuesto/get_tipo') . '",{ codigoadm:$("#estadmin").val() },function(data){$("#fondo").html(data);})
});
});
';
$filter = new DataFilter2($this->rapyd->uri->add_clause($base_process_uri, "search"));
$filter->db->from('view_pres');
$filter->script($script);
$filter->title('');
$filter->attributes = array('onsubmit' => 'is_loaded()');
$ng1 = 'CAMPOS A FILTRAR';
$filter->fechah = new dateonlyField("Hasta", "fechah", 'd/m/Y');
$filter->fechah->clause = " ";
$filter->fechah->insertValue = date("Y-m-d");
$filter->fechah->db_name = "fecha";
$filter->fechah->operator = " ";
$filter->fechah->dbformat = 'Y-m-d';
$filter->fechah->group = $ng1;
$filter->estadmin = new dropdownField("Estructura Administrativa", "estadmin");
$filter->estadmin->db_name = 'codigoadm';
$filter->estadmin->option("", "Seleccione");
$filter->estadmin->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->estadmin->style="width:600px";
$filter->estadmin->group = $ng1;
function filteredgrid()
{
$this->rapyd->load('datafilter2', 'datagrid');
$link1 = site_url('inventario/etiqueta_sinv/menu');
$link2 = site_url('inventario/common/get_linea');
$link3 = site_url('inventario/common/get_grupo');
$script = '
$(document).ready(function(){
$("#depto").change(function(){
$("#objnumero").val("");
depto();
$.post("' . $link2 . '",{ depto:$(this).val() },function(data){$("#linea").html(data);})
$.post("' . $link3 . '",{ linea:"" },function(data){$("#grupo").html(data);})
});
$("#linea").change(function(){
linea();
$.post("' . $link3 . '",{ linea:$(this).val() },function(data){$("#grupo").html(data);})
});
$("#grupo").change(function(){
grupo();
});
depto();
linea();
grupo();
});
function depto(){
if($("#depto").val()!=""){
$("#nom_depto").attr("disabled","disabled");
}else{
$("#nom_depto").attr("disabled","");
}
}
function linea(){
if($("#linea").val()!=""){
$("#nom_linea").attr("disabled","disabled");
}else{
$("#nom_linea").attr("disabled","");
}
}
function grupo(){
if($("#grupo").val()!=""){
$("#nom_grupo").attr("disabled","disabled");
}else{
$("#nom_grupo").attr("disabled","");
}
}';
$filter = new DataFilter2('Filtro por Producto');
$filter->script($script);
$filter->codigo = new inputField('Código', 'codigo');
$filter->codigo->db_name = 'a.codigo';
$filter->codigo->size = 20;
$filter->codigo->clause = 'where';
$filter->codigo->operator = '=';
$filter->descrip = new inputField('Descripción', 'descrip');
$filter->descrip->db_name = 'CONCAT_WS(\' \',a.descrip,a.descrip2)';
$filter->descrip->size = 25;
$filter->depto = new dropdownField('Departamento', 'depto');
$filter->depto->db_name = 'd.depto';
$filter->depto->option('', 'Seleccione un Departamento');
$filter->depto->options("SELECT depto, descrip FROM dpto WHERE tipo='I' ORDER BY depto");
$filter->linea2 = new dropdownField('Línea', 'linea');
$filter->linea2->db_name = 'c.linea';
$filter->linea2->option('', 'Seleccione un Departamento primero');
$depto = $filter->getval('depto');
if ($depto !== false) {
$dbdepto = $this->db->escape($depto);
$filter->linea2->options("SELECT linea, descrip FROM line WHERE depto={$dbdepto} ORDER BY descrip");
} else {
$filter->linea2->option('', 'Seleccione un Departamento primero');
}
$filter->grupo = new dropdownField('Grupo', 'grupo');
$filter->grupo->db_name = 'b.grupo';
$filter->grupo->option('', 'Seleccione una Línea primero');
$linea = $filter->getval('linea2');
if ($linea !== false) {
$dblinea = $this->db->escape($linea);
$filter->grupo->options("SELECT grupo, nom_grup FROM grup WHERE linea={$dblinea} ORDER BY nom_grup");
} else {
$filter->grupo->option('', 'Seleccione un Departamento primero');
}
$filter->marca = new dropdownField('Marca', 'marca');
$filter->marca->option('', 'Seleccionar');
$filter->marca->options('SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM marc ORDER BY marca');
$filter->marca->style = 'width:220px;';
$filter->cant = new inputField('Cantidad de etiquetas por productos', 'cant');
$filter->cant->css_class = 'inputnum';
$filter->cant->insertValue = '1';
$filter->cant->clause = '';
$filter->cant->size = 8;
$filter->cant->rule = 'required|numeric';
$filter->cant->group = 'Configuración';
$filter->salformat = new radiogroupField('Formato de salida', 'salformat');
$filter->salformat->options(array('pdf' => 'pdf', 'txt' => 'txt'));
$filter->salformat->insertValue = 'pdf';
$filter->salformat->clause = '';
$filter->salformat->group = 'Opciones';
$filter->button('btn_undo', 'Regresar', 'javascript:window.location=\'' . site_url('inventario/etiqueta_sinv') . '\'', 'BL');
$filter->buttons('reset', 'search');
$filter->build();
if ($this->rapyd->uri->is_set('search') && $filter->is_valid()) {
$formato = $filter->salformat->newValue;
if ($formato == 'txt') {
$tabla = form_open('formatos/descargartxt/' . $this->formato);
} else {
$tabla = form_open('forma/ver/' . $this->formato);
}
$select = array('a.tipo', 'a.id', 'a.codigo', 'a.descrip', 'a.precio1 AS precio', 'a.precio2 AS precio2', 'a.precio3 AS precio3', 'a.barras', 'b.nom_grup', 'b.grupo AS grupoid', 'c.descrip AS nom_linea', 'c.linea', 'd.descrip AS nom_depto', 'd.depto AS depto', 'a.pfecha1 AS cfecha', 'a.iva');
$grid = new DataGrid('Lista de Artículos para imprimir');
$grid->per_page = 15;
$grid->db->select($select);
$grid->db->from('sinv AS a');
$grid->db->join('grup AS b', 'a.grupo=b.grupo');
$grid->db->join('line AS c', 'b.linea=c.linea');
$grid->db->join('dpto AS d', 'c.depto=d.depto');
$grid->db->group_by('a.codigo');
$grid->order_by('codigo', 'asc');
$grid->column_orderby('Código', 'codigo', 'codigo');
$grid->column_orderby('Departamento', 'nom_depto', 'nom_depto', 'align=\'left\'');
$grid->column_orderby('Línea', 'nom_linea', 'nom_linea', 'align=\'left\'');
$grid->column_orderby('Grupo', 'nom_grup', 'nom_grup', 'align=\'left\'');
$grid->column_orderby('Descripción', 'descrip', 'descrip');
$grid->column_orderby('Precio', 'precio', 'precio', 'align=\'right\'');
$grid->build();
$limite = 300;
if ($grid->recordCount > 0 && $grid->recordCount <= $limite) {
$consul = $this->db->last_query();
$mSQL = substr($consul, 0, strpos($consul, 'LIMIT'));
$data = array('cant' => $this->input->post('cant'), 'consul' => $mSQL);
$tabla .= form_hidden($data);
$tabla .= $grid->output . form_submit('mysubmit', 'Generar');
$tabla .= form_close();
} elseif ($grid->recordCount > $limite) {
$tabla = 'No se puede generar habladores con más de ' . $limite . ' árticulos';
} else {
$tabla = 'No se encontrarón productos';
}
} else {
$tabla = $filter->error_string;
}
$data['content'] = $filter->output . $tabla;
$data['title'] = heading('Habladores por filtro de productos');
$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 agregar($para = "")
{
// echo $para;
$this->rapyd->load("datafilter2", "datagrid", "dataobject", "fields");
$mod = array('tabla' => 'sinvlist', 'columnas' => array('numero' => 'Cóodigo', 'concepto' => 'Concepto', 'usuario' => 'Usuario'), 'filtro' => array('numero' => 'Número'), 'retornar' => array('numero' => 'nume'), 'titulo' => 'Buscar Proveedor');
$modnume = $this->datasis->modbus($mod);
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'script' => array('limpia2()'), 'titulo' => 'Buscar Proveedor');
$bSPRV = $this->datasis->modbus($mSPRV);
$mSPRV1 = array('tabla' => 'snot', 'columnas' => array('numero' => 'Número'), 'filtro' => array('numero' => 'Número'), 'retornar' => array('numero' => 'objnumero'), 'script' => array('limpia()'), 'titulo' => 'Buscar Número');
$bSPRV1 = $this->datasis->modbus($mSPRV1);
$mSPRV2 = array('tabla' => 'spre', 'columnas' => array('numero' => 'Número'), 'filtro' => array('numero' => 'Número'), 'retornar' => array('numero' => 'objnumero'), 'script' => array('limpia()'), 'titulo' => 'Buscar Número');
$bSPRV2 = $this->datasis->modbus($mSPRV2);
$mSPRV3 = array('tabla' => 'scst', 'columnas' => array('numero' => 'Número'), 'filtro' => array('numero' => 'Número'), 'retornar' => array('numero' => 'objnumero'), 'script' => array('limpia()'), 'titulo' => 'Buscar Número');
$bSPRV3 = $this->datasis->modbus($mSPRV3);
$mSPRV4 = array('tabla' => 'snte', 'columnas' => array('numero' => 'Número'), 'filtro' => array('numero' => 'Número'), 'retornar' => array('numero' => 'objnumero'), 'script' => array('limpia()'), 'titulo' => 'Buscar Número');
$bSPRV4 = $this->datasis->modbus($mSPRV4);
$mSPRV5 = array('tabla' => 'sfac', 'columnas' => array('numero' => 'Número', 'tipo_doc' => 'Tipo De Documento'), 'filtro' => array('numero' => 'Número'), 'retornar' => array('numero' => 'objnumero'), 'script' => array('limpia()'), 'titulo' => 'Buscar Número');
$bSPRV5 = $this->datasis->modbus($mSPRV5);
$user = $this->session->userdata('usuario');
$link2 = site_url('inventario/common/get_linea');
$link3 = site_url('inventario/common/get_grupo');
$link4 = site_url('inventario/sinvlist/tabla');
$link5 = site_url('inventario/sinvlist/');
$script = '
function limpia(){
$("#codigo").val("");
$("#descrip").val("");
$("#marca").val("");
$("#proveed").val("");
$("#tipo").val("");
$("#clave").val("");
$("#depto").val("");
$("#linea").val("");
$("#grupo").val("");
}
function limpia2(){
$("#objnumero").val("");
}
function envia(){
nume = $("#nume").val();
tlist = $("#tlist").val();
objnumero = $("#objnumero").val();
msj="Nueva lista";
if(nume != ""){
msj="lista numero "+nume;
}
if(objnumero != ""){
alert("Se creare lista de productos de la tabla "+tlist+" con codigo "+objnumero+" en "+msj);
window.location="' . $link4 . '/"+tlist+"/"+objnumero+"/"+nume;
}else{
alert("El campo Numero no contine valor");
}
}
function atras(){
window.location="' . $link5 . '/";
}
$(document).ready(function(){
$("#marca").change(function(){$("#objnumero").val("");});
$("#clave").focus(function(){$("#objnumero").val("");});
$("#codigo").focus(function(){$("#objnumero").val("");});
$("#descrip").focus(function(){$("#objnumero").val("");});
$("#tipo").change(function(){$("#objnumero").val("");});
//$("#proveed").change(function(){$("#objnumero").val("");});
if(!$("#proveed").val()){
$("#objnumero").val("");
}
$("#tlist").change(function(){
vallist=$("#tlist").val();
//alert(vallist);
switch(vallist){
case "sitems": $("#modo1").hide();$("#modo2").hide();
$("#modo3").hide();$("#modo4").hide();
$("#modo5").show();
break
case "itsnot": $("#modo5").hide();$("#modo2").hide();
$("#modo3").hide();$("#modo4").hide();
$("#modo1").show();
break
case "itsnte": $("#modo1").hide();$("#modo2").hide();
$("#modo3").hide();$("#modo5").hide();
$("#modo4").show();
break
case "itspre": $("#modo1").hide();$("#modo5").hide();
$("#modo3").hide();$("#modo4").hide();
$("#modo2").show();
break
case "itscst": $("#modo1").hide();$("#modo2").hide();
$("#modo5").hide();$("#modo4").hide();
$("#modo3").show();
break
default:
}
//$("#modo1").css("display", "none");
});
$("#depto").change(function(){
$("#objnumero").val("");
depto();
$.post("' . $link2 . '",{ depto:$(this).val() },function(data){$("#linea").html(data);})
$.post("' . $link3 . '",{ linea:"" },function(data){$("#grupo").html(data);})
});
$("#linea").change(function(){
linea();
$.post("' . $link3 . '",{ linea:$(this).val() },function(data){$("#grupo").html(data);})
});
$("#grupo").change(function(){
grupo();
});
depto();
linea();
grupo();
});
function depto(){
if($("#depto").val()!=""){
$("#nom_depto").attr("disabled","disabled");
}
else{
$("#nom_depto").attr("disabled","");
}
}
function linea(){
if($("#linea").val()!=""){
$("#nom_linea").attr("disabled","disabled");
}
else{
$("#nom_linea").attr("disabled","");
}
}
function grupo(){
if($("#grupo").val()!=""){
$("#nom_grupo").attr("disabled","disabled");
}
else{
$("#nom_grupo").attr("disabled","");
}
}
';
$filter = new DataFilter2("Filtro por Producto");
$filter->db->_escape_char = '';
$filter->db->_protect_identifiers = false;
$filter->script($script);
$filter->nume = new inputField("Nro. Lista", "nume");
$filter->nume->size = 25;
$filter->nume->db_name = "";
$filter->nume->clause = "";
if ($para != "") {
if ($para != "search" || $para != "reset") {
$filter->nume->mode = "readonly";
$filter->nume->insertValue = $para;
} else {
$filter->nume->append($modnume);
}
} else {
$filter->nume->append($modnume);
}
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 25;
//$filter->codigo->rule='callback_repetido|required';
$filter->descrip = new inputField("Descripción", "descrip");
$filter->descrip->db_name = 'CONCAT_WS(" ",a.descrip,a.descrip2)';
$filter->descrip->size = 25;
$filter->tipo = new dropdownField("Tipo", "tipo");
$filter->tipo->db_name = "a.tipo";
$filter->tipo->option("", "Todos");
$filter->tipo->option("Articulo", "Artículo");
$filter->tipo->option("Servicio", "Servicio");
$filter->tipo->option("Descartar", "Descartar");
$filter->tipo->option("Consumo", "Consumo");
$filter->tipo->option("Fraccion", "Fracción");
$filter->tipo->style = 'width:220px;';
$filter->clave = new inputField("Clave", "clave");
$filter->clave->size = 25;
$filter->proveed = new inputField("Proveedor", "proveed");
$filter->proveed->append($bSPRV);
$filter->proveed->db_name = 'a.prov1';
$filter->proveed->size = 25;
$filter->depto = new dropdownField("Departamento", "depto");
$filter->depto->db_name = "d.depto";
$filter->depto->option("", "Seleccione un Departamento");
$filter->depto->options("SELECT depto, descrip FROM dpto WHERE tipo='I' ORDER BY depto");
$filter->linea2 = new dropdownField("Línea", "linea");
$filter->linea2->db_name = "c.linea";
$filter->linea2->option("", "Seleccione un Departamento primero");
$depto = $filter->getval('depto');
if ($depto !== FALSE) {
$filter->linea2->options("SELECT linea, descrip FROM line WHERE depto='{$depto}' ORDER BY descrip");
} else {
$filter->linea2->option("", "Seleccione un Departamento primero");
}
$filter->grupo = new dropdownField("Grupo", "grupo");
$filter->grupo->db_name = "b.grupo";
$filter->grupo->option("", "Seleccione una Línea primero");
$linea = $filter->getval('linea2');
if ($linea !== FALSE) {
$filter->grupo->options("SELECT grupo, nom_grup FROM grup WHERE linea='{$linea}' ORDER BY nom_grup");
} else {
$filter->grupo->option("", "Seleccione un Departamento primero");
}
$filter->marca = new dropdownField("Marca", "marca");
$filter->marca->option("", "");
$filter->marca->options("SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM marc ORDER BY marca");
$filter->marca->style = 'width:220px;';
$filter->tlist = new dropdownField("Extraer de:", "tlist");
$filter->tlist->option("sitems", "Facturas");
$filter->tlist->option("itspre", "Presupuesto");
$filter->tlist->option("itsnot", "N.Despacho");
$filter->tlist->option("itsnte", "N.Entrega");
$filter->tlist->option("itscst", "N.Compra");
$filter->tlist->style = 'width:220px;';
$filter->tlist->db_name = "";
$filter->tlist->clause = "";
$filter->tlist->in = "objnumero";
$salida = "<a href='javascript:envia()'>Crear Lista en Base a Tabla</a>";
$filter->objnumero = new inputField("Numero", "objnumero");
$filter->objnumero->size = 10;
$filter->objnumero->db_name = "";
$filter->objnumero->clause = "";
$filter->objnumero->append("<spam id='modo1'style='display:none;'>{$bSPRV1}</espam><spam id='modo2'style='display:none;>{$bSPRV2}</spam><spam id='modo3'style='display:none;>{$bSPRV3}</spam><spam id='modo4'style='display:none;>{$bSPRV4}</spam><spam id='modo5'>{$bSPRV5}</spam>");
$filter->buttons("reset", "search");
$filter->build();
$tabla = "";
if ($this->rapyd->uri->is_set("search") and $filter->is_valid()) {
//echo "=>".$this->input->post("objnumero")."epale";
function asigna($numero)
{
$data = array('name' => "sepago[]", 'id' => $numero, 'value' => $numero, 'checked' => TRUE);
return form_checkbox($data);
}
if ($para == "" || $para == "search") {
$para = $this->input->post("nume");
}
$tabla = form_open("inventario/sinvlist/inserta/{$para}");
$ddata = array('nume' => $this->input->post("nume"));
if (!$this->input->post("objnumero") !== false) {
//echo "aqui tambien";
$grid = new DataGrid("Lista de Artículos");
$grid->db->select("a.tipo AS tipo,id,codigo,a.descrip,precio1,\n\t\t\t\t\t\t\t\t\tprecio2,precio3,precio4,a.prov1,\n\t\t\t\t\t\t\t\t\tb.nom_grup AS nom_grup,b.grupo AS grupoid,\n\t\t\t\t\t\t\t\t\tc.descrip AS nom_linea,c.linea AS linea,\n\t\t\t\t\t\t\t\t\td.descrip AS nom_depto,d.depto AS depto,a.prov1,a.prov2,a.prov3");
$grid->db->from("sinv AS a");
$grid->db->join("grup AS b", "a.grupo=b.grupo");
$grid->db->join("line AS c", "b.linea=c.linea");
$grid->db->join("dpto AS d", "c.depto=d.depto");
$grid->db->_escape_char = '';
$grid->db->_protect_identifiers = false;
$grid->order_by("codigo", "asc");
$grid->per_page = 50;
//$link=anchor('/inventario/sinvlist/dataedit/show/<#id#>','<#codigo#>');
$uri_2 = anchor('inventario/sinv/dataedit/create/<#id#>', 'Duplicar');
$grid->use_function('asigna');
$grid->column("código", "codigo");
$grid->column("Departamento", "<#nom_depto#>", 'align=left');
$grid->column("Línea", "<#nom_linea#>", 'align=left');
$grid->column("Grupo", "<#nom_grup#>", 'align=left');
$grid->column("Descripción", "descrip");
$grid->column("Accioón", "<asigna><#codigo#></asigna>", "align='right'");
$grid->build();
//echo $grid->db->last_query();
$tabla .= $grid->output . form_submit('mysubmit', 'Guardar');
$tabla .= form_close();
} else {
//echo "aqui";
//$_POST['depto']='';
$tabla1 = $this->input->post("tlist");
$cod = $this->input->post("objnumero");
$num = $this->input->post("nume");
$campo = "";
$campo1 = "codigo";
$campo2 = "descrip";
$cod2 = $this->db->escape($cod);
$cod3 = str_pad($cod, 8, '0', STR_PAD_LEFT);
switch ($tabla1) {
case "sitems":
$campo = "numa";
$campo1 = "codigoa";
$campo2 = 'desca';
break;
case "itsnot":
$campo = "numero";
break;
case "itsnte":
$campo = "numero";
$campo2 = "desca";
break;
case "itspre":
$campo = "numero";
$campo2 = "desca";
break;
case "itscst":
$campo = "numero";
break;
default:
echo "Tabla no valida.........";
break;
}
$grid2 = new DataGrid("Lista de Artículos Por Tabla");
$grid2->db->from("{$tabla1}");
$grid2->db->select(array("{$campo1}", "{$campo2}"));
$grid2->db->where("{$campo}", "{$cod3}");
$grid2->per_page = 50;
//$link=anchor('/inventario/sinvlist/dataedit/show/<#id#>','<#codigo#>');
$grid2->use_function('asigna');
$grid2->column("código", "{$campo1}");
$grid2->column("Descripción", "{$campo2}");
$grid2->column("Accioón", "<asigna><#{$campo1}#></asigna>", "align='right'");
$grid2->build();
$grid2->db->last_query();
$tabla .= $grid2->output . form_submit('mysubmit', 'Guardar');
$tabla .= form_close();
}
}
$back = "<table width='100%'border='0'><tr><td width='80%'></td><td width='20%'><a href='javascript:atras()'><spam id='regresar'align='right'>REGRESAR</spam></a></td></tr></table>";
$data['filtro'] = $filter->output;
$data['tabla'] = $tabla;
$data['smenu'] = $back;
//.$grid->output;
$data['title'] = "Agregar Listado Por Patron";
$data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . script("sinvmaes2.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas_pru', $data);
}
function bussug()
{
$this->rapyd->load('datagrid', 'datafilter2', 'fields');
//$uri = anchor('compras/ordc/dataedit/show/<#codigo#>','<#codigo#>');
$uri = '<a href="javascript:void(0);" class="articulo" onclick="oselect(<jse><#codigo#></jse>,<jse><#descrip#></jse>,<jse><#iva#></jse>,<jse><#peso#></jse>,<jse><#ultimo#></jse>,<jse><#sug#></jse>,<#id#>)"><#codigo#></a>';
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Código', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'titulo' => 'Buscar Proveedor');
$bSPRV = $this->datasis->modbus($mSPRV);
$script = '
var vals = new Array();
$(function(){
$(".inputnum").numeric(".");
$(\'input[name^="campo"]\').focus(function() {
obj = $(this);
obj.select();
});
marcacod();
});
function marcacod(){
vals = window.opener.$(\'input[name^="codigo_"]\').map(function(){return $(this).val().replace(/^\\s+/g,\'\').replace(/\\s+$/g,\'\'); }).get();
var arr=$(".articulo");
jQuery.each(arr, function(){
codigo=$(this).text();
$(this).css("color" ,"");
$(this).attr("title","Haga click para agregarlo a la lista.");
for (key in vals){
if(vals[key] == codigo){
$(this).css("color","red");
$(this).attr("title", "Producto ya esta en la lista.");
break;
}
}
});
}
function oselect(codigo,descrip,iva,peso,costo,cantidad,idd){
var sug = Number($("#campo_"+idd).val());
if(sug>0){
if(window.opener !== null){
var id=window.opener.add_itordc();
window.opener.document.getElementById("codigo_"+id).value =codigo;
window.opener.document.getElementById("descrip_"+id).value =descrip;
window.opener.document.getElementById("iva_"+id).valuel =iva;
window.opener.document.getElementById("sinvpeso_"+id).value=peso;
window.opener.document.getElementById("costo_"+id).value =costo;
window.opener.document.getElementById("cantidad_"+id).value=sug;
window.opener.post_modbus_sinv(id);
window.opener.importe(id);
window.opener.totalizar();
marcacod();
}else{
alert("Ventana de destino no existe");
}
}else{
alert("La cantidad sugerida debe ser mayor a cero");
}
return false;
}';
function jse($string)
{
$string = str_replace("\r", '', $string);
$string = str_replace("\n", '', $string);
$string = preg_replace('/\\s\\s+/', ' ', $string);
$string = addslashes($string);
$string = str_replace('<', '\\<', $string);
$string = str_replace('>', '\\>', $string);
$string = str_replace(';', '\\;', $string);
$string = str_replace('\\"', "'+String.fromCharCode(34)+'", $string);
$string = '\'' . $string . '\'';
return $string;
}
function divi($dividendo, $divisor)
{
if ($divisor > 0) {
return ceil($dividendo / $divisor);
} else {
return 0;
}
}
$filter = new DataFilter2('');
$filter->script($script);
$filter->db->select(array('a.id', 'TRIM(a.codigo) AS codigo', 'a.descrip', 'a.exmax', 'a.exmin', 'a.existen', 'a.ultimo', 'IF(a.exmax>a.existen,CEIL(a.exmax-IF(a.existen>0,a.existen,0)),0) AS sug', 'a.pfecha1', 'a.prov1', 'a.peso', 'a.iva'));
$filter->db->from('sinv AS a');
//$filter->db->join('sitems AS b','a.codigo=b.codigoa AND b.tipoa="F" AND b.fecha >= DATE_SUB(CURDATE(),INTERVAL 30 DAY)','left');
//$filter->db->where('a.existen <= a.exmin');
$filter->db->where('a.activo', 'S');
$filter->db->where('a.tipo', 'Articulo');
$filter->db->groupby('a.codigo');
$filter->codigo = new inputField('Código', 'codigo');
$filter->codigo->db_name = 'a.codigo';
$filter->codigo->size = 10;
$filter->codigo->maxlength = 15;
$filter->descrip = new inputField('Descripción', 'descrip');
$filter->descrip->rule = 'max_length[45]';
$filter->descrip->db_name = 'a.descrip';
$filter->descrip->size = 47;
$filter->descrip->maxlength = 45;
$filter->descrip->in = 'codigo';
$filter->sprv = new inputField('Proveedor', 'proveed');
$filter->sprv->size = 10;
$filter->sprv->maxlength = 15;
$filter->sprv->db_name = 'a.prov1';
$filter->sprv->append($bSPRV);
$filter->buttons('reset', 'search');
$filter->build();
$grid = new DataGrid();
$grid->use_function('jse', 'divi');
$grid->order_by('codigo', 'desc');
$grid->per_page = 40;
$campo = new inputField('Campo', 'sug');
$campo->grid_name = 'campo_<#id#>';
$campo->status = 'modify';
$campo->size = 6;
$campo->autocomplete = false;
$campo->css_class = 'inputnum';
$campo->disable_paste = true;
$grid->column_orderby('Código', $uri, 'codigo');
$grid->column_orderby('Descripción', '<#descrip#>', 'descrip');
$grid->column('Máx-Min', '<nformat><#exmax#>|0</nformat><b>-</b><nformat><#exmin#>|0</nformat>', "align='center'");
$grid->column_orderby('Existencia', '<nformat><#existen#></nformat>', 'existen', "align='right'");
//$grid->column('Sugerido' ,'<b><nformat><#sug#>|0</nformat></b>' , "align='right'");
$grid->column('Sugerido', $campo, "align='right'");
$grid->column('Último costo', '<nformat><#ultimo#></nformat>', "align='right'");
$grid->column('Última compra', '<dbdate_to_human><#pfecha1#></dbdate_to_human> <#prov1#>');
//$grid->column('Ventas S.','<nformat><divi><#venta#>|4</divi>|0</nformat>', "align='right'");
//$grid->column('Ventas Q.','<nformat><divi><#venta#>|2</divi>|0</nformat>', "align='right'");
//$grid->column('Ventas M.','<nformat><#venta#>|0</nformat>', "align='right'");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = heading('Productos sugueridos');
$data['head'] = script('jquery.js');
$data['head'] .= $this->rapyd->get_head();
$data['head'] .= phpscript('nformat.js');
$data['head'] .= script('plugins/jquery.numeric.pack.js');
$data['head'] .= script('plugins/jquery.floatnumber.js');
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
//$this->rapyd->uri->keep_persistence();
rapydlib("prototype");
$ajax_onchange = '
function get_linea(){
var url = "' . site_url('reportes/sinvlineas') . '";
var pars = "dpto="+$F("depto");
var myAjax = new Ajax.Updater("td_linea", url, { method: "post", parameters: pars });
}
function get_grupo(){
var url = "' . site_url('reportes/sinvgrupos') . '";
var pars = "dpto="+$F("depto")+"&linea="+$F("linea");
var myAjax = new Ajax.Updater("td_grupo", url, { method: "post", parameters: pars });
}';
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'titulo' => 'Buscar Beneficiario');
$bSPRV = $this->datasis->modbus($mSPRV);
//filter
$filter = new DataFilter2("Filtro por Producto", 'sinv');
$filter->codigo = new inputField("Código", "codigo");
$filter->script($ajax_onchange);
$filter->descrip = new inputField("Descripción", "descrip");
$filter->descrip->db_name = 'CONCAT_WS(" ",descrip,descrip2)';
$filter->tipo = new dropdownField("Tipo", "tipo");
$filter->tipo->option("", "Todos");
$filter->tipo->option("Articulo", "Artículo");
$filter->tipo->option("Servicio", "Servicio");
$filter->tipo->option("Descartar", "Descartar");
$filter->tipo->option("Consumo", "Consumo");
$filter->tipo->option("Fraccion", "Fracción");
$filter->clave = new inputField("Clave", "clave");
$filter->activo = new dropdownField("Activo", "activo");
$filter->activo->option("", "");
$filter->activo->option("S", "Si");
$filter->activo->option("N", "No");
$filter->proveed = new inputField("Beneficiario", "proveed");
$filter->proveed->append($bSPRV);
$filter->proveed->clause = "in";
$filter->proveed->db_name = '( s.prov1, s.prov2, s.prov3 )';
$filter->dpto = new dropdownField("Departamento", "depto");
$filter->dpto->option("", "");
$filter->dpto->options("SELECT depto, descrip FROM dpto ORDER BY descrip");
$filter->dpto->onchange = "get_linea();";
$filter->linea = new dropdownField("Linea", "linea");
$filter->linea->option("", "Seleccione un departamento");
$filter->linea->onchange = "get_grupo();";
$filter->grupo = new dropdownField("Grupo", "grupo");
$filter->grupo->option("", "Seleccione una Línea");
$filter->marca = new dropdownField("Marca", "marca");
$filter->marca->option("", "");
$filter->marca->options("SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM marc ORDER BY marca");
$filter->buttons("reset", "search");
$filter->build();
$uri = "inventario/sinv/dataedit/show/<#codigo#>";
$grid = new DataGrid("Lista de Artículos");
$grid->order_by("codigo", "asc");
$grid->per_page = 20;
$link = anchor('/inventario/sinv/dataedit/show/<#id#>', '<#codigo#>');
$grid->column("código", $link);
$grid->column("Descripción", "descrip");
$grid->column("Precio 1", "precio1");
$grid->column("Precio 2", "precio2");
$grid->column("Precio 3", "precio3");
$grid->column("Precio 4", "precio4");
$grid->add("inventario/sinv/dataedit/create");
$grid->build();
//grid
$data["crud"] = $filter->output . $grid->output;
$data["titulo"] = 'Lista de Artículos';
$content["content"] = $this->load->view('rapyd/crud', $data, true);
$content["rapyd_head"] = $this->rapyd->get_head();
$content["code"] = '';
$content["lista"] = "\r\n\t\t\t<h3>Editar o Agregar</h3>\r\n\t\t\t<div>Con esta pantalla se puede editar o agregar datos a los Departamentos del Módulo de Inventario</div>\r\n\t\t\t<div class='line'></div>\r\n\t\t\t<a href='#' onclick='window.close()'>Cerrar</a>\r\n\t\t\t<div class='line'></div>\n<br><br><br>\n";
$this->load->view('rapyd/tmpsolo', $content);
}
function filteredgrid()
{
$this->datasis->modulo_id($this->id, 1);
if ($this->input->post('btn_cambio_2') !== false) {
unset($_POST['btn_cambio_2']);
$_POST['btn_submit'] = 'a';
$_cambiomin = true;
} else {
$_cambiomin = false;
}
$this->rapyd->load("datafilter2", "datagrid");
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'titulo' => 'Buscar Proveedor');
$bSPRV = $this->datasis->modbus($mSPRV);
$link2 = site_url('inventario/common/get_linea');
$link3 = site_url('inventario/common/get_grupo');
$script = '
$(document).ready(function(){
$("#depto").change(function(){
depto();
$.post("' . $link2 . '",{ depto:$(this).val() },function(data){$("#linea").html(data);})
$.post("' . $link3 . '",{ linea:"" },function(data){$("#grupo").html(data);})
});
$("#linea").change(function(){
linea();
$.post("' . $link3 . '",{ linea:$(this).val() },function(data){$("#grupo").html(data);})
});
$("#grupo").change(function(){
grupo();
});
depto();
linea();
grupo();
});
function depto(){
if($("#depto").val()!=""){
$("#nom_depto").attr("disabled","disabled");
}
else{
$("#nom_depto").attr("disabled","");
}
}
function linea(){
if($("#linea").val()!=""){
$("#nom_linea").attr("disabled","disabled");
}
else{
$("#nom_linea").attr("disabled","");
}
}
function grupo(){
if($("#grupo").val()!=""){
$("#nom_grupo").attr("disabled","disabled");
}
else{
$("#nom_grupo").attr("disabled","");
}
}';
$filter = new DataFilter2("Filtro por Producto");
$filter->script($script);
$filter->db->select('a.codigo');
$filter->db->select('a.descrip');
$filter->db->select('s.exmin');
$filter->db->select('s.id');
$filter->db->from('eventas as a');
$filter->db->join('grup AS b', 'a.grupo=b.grupo');
//$filter->db->join('line AS c' ,'c.linea=b.linea');
//$filter->db->join('dpto AS d' ,'c.depto=d.depto');
$filter->db->join('sinv AS s', 'a.codigo=s.codigo');
//$filter->db->where('s.activo','S');
$filter->db->where('s.tipo', 'Articulo');
$filter->db->groupby('a.descrip');
//Agregar proveedor y filtro de activo, columna de activo maximo=doble minu +1 predeterminado, guardar historial de cambios
//Diferencias porcentual enete el minimo calculado y el minimo actual-
$filter->fechad = new dateonlyField("Desde", "fechad", 'm/Y');
$filter->fechah = new dateonlyField("Hasta", "fechah", 'm/Y');
$filter->fechad->dbformat = 'Y-m-';
$filter->fechah->dbformat = 'Y-m-';
$filter->fechah->rule = "required";
$filter->fechad->rule = "required";
$filter->fechad->clause = $filter->fechah->clause = '';
$filter->fechad->insertValue = date("Y-m-d", mktime(0, 0, 0, date('m') - 12, date('j'), date('Y')));
$filter->fechah->insertValue = date("Y-m-d");
$filter->fechah->size = $filter->fechad->size = 9;
$filter->depto = new dropdownField("Departamento", "depto");
$filter->depto->db_name = "a.depto";
$filter->depto->option("", "Seleccione un Departamento");
$filter->depto->options("SELECT depto, descrip FROM dpto WHERE tipo='I' ORDER BY depto");
$filter->linea2 = new dropdownField("Línea", "linea");
$filter->linea2->db_name = "a.linea";
$filter->linea2->option("", "Seleccione un Departamento primero");
$depto = $filter->getval('depto');
if ($depto !== FALSE) {
$filter->linea2->options("SELECT linea, descrip FROM line WHERE depto='{$depto}' ORDER BY descrip");
} else {
$filter->linea2->option("", "Seleccione un Departamento primero");
}
$filter->grupo = new dropdownField("Grupo", "grupo");
$filter->grupo->db_name = 'a.grupo';
$filter->grupo->option("", "Seleccione una Línea primero");
$linea = $filter->getval('linea2');
if ($linea !== FALSE) {
$filter->grupo->options("SELECT grupo, nom_grup FROM grup WHERE linea='{$linea}' ORDER BY nom_grup");
} else {
$filter->grupo->option("", "Seleccione un Departamento primero");
}
$filter->marca = new dropdownField("Marca", "marca");
$filter->marca->option('', 'Todas');
$filter->marca->options("SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM marc ORDER BY marca");
$filter->marca->style = 'width:220px;';
$filter->estadistica = new dropdownField('Estadística a usar', 'estadistica');
$filter->estadistica->clause = '';
$filter->estadistica->rule = 'required';
$filter->estadistica->option('promediot', 'Promedio truncado');
$filter->estadistica->option('promedio', 'Promedio');
$filter->estadistica->option('mediana', 'Mediana');
$filter->estadistica->option('maximo', 'Valor Máximo');
$filter->estadistica->option('minimo', 'Valor Mínimo');
//$filter->estadistica->option('moda' ,'Moda');
$filter->estadistica->group = 'Configuración';
$filter->maximos = new dropdownField('Cálculo de máximos', 'maximos');
$filter->maximos->clause = '';
$filter->maximos->option('', 'No alterar');
$filter->maximos->option('max_dupli', 'Doble del mínimo');
$filter->maximos->group = 'Configuración';
$filter->frecuencia = new dropdownField('Frecuencia', 'frecuencia');
$filter->frecuencia->clause = '';
$filter->frecuencia->rule = 'required';
$filter->frecuencia->option('1', 'Mensual');
$filter->frecuencia->option('2', 'BiMenusal');
$filter->frecuencia->option('4', 'Semanal');
$filter->frecuencia->option('8', 'BiSemanal');
$filter->frecuencia->group = 'Configuración';
$filter->buttons('reset', 'search');
if ($this->rapyd->uri->is_set('search')) {
$filter->submit('btn_cambio_2', 'Actualizar todos', "BR");
}
$filter->build();
$uri = 'inventario/sinv/dataedit/show/<#codigo#>';
$tabla = '';
if ($filter->is_valid()) {
$estadistica = $filter->estadistica->newValue;
$maximos = $filter->maximos->newValue;
$frecuencia = $filter->frecuencia->newValue;
$udia = days_in_month(substr($filter->fechah->newValue, 4), substr($filter->fechah->newValue, 0, 4));
$fechad = $filter->fechad->newValue . '01';
$fechah = $filter->fechah->newValue . $udia;
$filter->db->where('a.fecha >=', $fechad);
$filter->db->where('a.fecha <=', $fechah);
$datetime1 = new DateTime($fechad);
$datetime2 = new DateTime($fechah);
$interval = $datetime1->diff($datetime2);
$ffechad = explode('-', $fechad);
$grid = new DataGrid('Lista de Artículos');
$grid->order_by('codigo', 'asc');
$grid->use_function('divisor', $estadistica);
$grid->per_page = 15;
$grid->column('Código', 'codigo');
$grid->column('Descripción', 'descrip');
$columncal = $ccolumncal = array();
for ($i = 0; $i <= $interval->m + 1; $i++) {
$mk = mktime(0, 0, 0, $ffechad[1] + $i, 1, $ffechad[0]);
$udia = days_in_month(date('m', $mk), date('Y', $mk));
$sqdesde = date("Y-m-d", $mk);
$sqhasta = date("Y-m-", $mk) . $udia;
$etiq = date("m/Y", $mk);
$select = "SUM(cana*(fecha BETWEEN '{$sqdesde}' AND '{$sqhasta}')) AS '{$etiq}'";
$filter->db->select($select);
$grid->column($etiq, "<nformat><#{$etiq}#></nformat>", 'align=right');
$columncal[] = "<#{$etiq}#>";
$ccolumncal[] = $etiq;
}
$grid->column('Promedio', '<b style="color:red"><nformat><divisor><' . $estadistica . '>' . implode('|', $columncal) . '</' . $estadistica . '>|' . $frecuencia . '</divisor></nformat></b>', 'align=right');
$grid->column('Mínimo', '<nformat><#exmin#></nformat>', 'align=right');
$grid->column(' ', '<a href="javascript:actumin(\'<#id#>\',\'<divisor><' . $estadistica . '>' . implode('|', $columncal) . '</' . $estadistica . '>|' . $frecuencia . '</divisor>\')" >Actualizar</a>', 'align=right');
if ($_cambiomin) {
//echo 'Cambios de todos';
unset($_POST['btn_cambio_2']);
$_POST['btn_submit'] = 'a';
$sql = $filter->db->_compile_select();
$query = $this->db->query($sql);
if ($query->num_rows() > 0) {
foreach ($query->result() as $row) {
$param = array();
foreach ($ccolumncal as $obj) {
$param[] = $row->{$obj};
}
$min = ceil($estadistica($param) / $frecuencia);
$where = 'codigo =' . $this->db->escape($row->codigo);
$data = array('exmin' => $min);
if (!empty($maximos)) {
$data['exmax'] = $maximos($min);
}
$sSQL = $this->db->update_string('sinv', $data, $where);
$this->db->simple_query($sSQL);
}
}
}
$grid->build();
$tabla = $grid->output;
}
$url = site_url('inventario/comparativo/actumin/') . '/';
$data['script'] = '<script language="javascript" type="text/javascript">
function actumin(id,val){
vval = prompt("Actualizar minimo a:",val);
if(vval)
$.get("' . $url . '"+id+"/"+vval, function(data) { alert(data); });
}
</script>';
$data['content'] = $filter->output . $tabla;
$data['title'] = header('Comparativo de Mínimos de Inventario');
$data['head'] = script('jquery.pack.js') . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . script("sinvmaes2.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
