function index() { $this->rapyd->load('datagrid', 'dataform', 'datafilter'); $this->rapyd->uri->keep_persistence(); $form = new DataFilter('Seleccione las fallas'); foreach ($this->falla as $ind => $checkbox) { $id = 'f_' . $ind; $form->{$id} = new checkboxField($checkbox['nombre'], $id, '1'); $form->{$id}->clause = ''; } $form->submit('reset', 'Resetear'); $form->submit('btnsubmit', 'Buscar'); $form->build_form(); $algo['falla'] = $this->falla; $algo['form'] =& $form; $salida = $this->load->view('view_fallas', $algo, true); if ($this->input->post('btnsubmit')) { $grid = new DataGrid('Lista de Productos'); $grid->db->select = array('codigo', 'LEFT(descrip,20)AS descrip', 'margen1', 'margen2', 'margen3', 'margen4', 'base1', 'base2', 'base3', 'base4', 'precio1', 'precio2', 'precio3', 'precio4', 'id', 'existen', 'ultimo', 'pond'); $grid->db->from('sinv'); $grid->per_page = 15; $grid->order_by('existen', 'desc'); foreach ($this->falla as $ind => $data) { $id = 'f_' . $ind; if ($this->input->post($id)) { $grid->db->or_where($data['sql']); } } $atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '0', 'screeny' => '0'); $link = anchor_popup('/inventario/sinv/dataedit/show/<#id#>', '<#codigo#>', $atts); $grid->column('Código', $link); $grid->column('Descripción', 'descrip'); $grid->column('Margenes', '<ol><li><#margen1#></li><li><#margen2#></li><li><#margen3#></li><li><#margen4#></li></ol>'); $grid->column('Bases', '<ol><li><#base1#></li><li><#base2#></li><li><#base3#></li><li><#base4#></li></ol>'); $grid->column('Precios', '<ol><li><#precio1#></li><li><#precio2#></li><li><#precio3#></li><li><#precio4#></li></ol>'); $grid->column('Costos', '<ul><li><b>Ultimo:</b><#ultimo#></li><li><b>Promedio:</b><#pond#></li></ul>'); $grid->column_orderby('Existencia', 'existen', 'existen', 'align=\'right\''); $grid->build(); //echo $grid->db->last_query(); $salida .= $grid->output; $salida .= $grid->recordCount . ' Registros encontrados'; } $data['content'] = $salida; $data['title'] = '<h1>Productos con fallas</h1>'; $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function index() { $this->rapyd->load("datagrid", 'dataform', 'datafilter'); $this->rapyd->uri->keep_persistence(); $form = new DataFilter("Seleccione las fallas"); foreach ($this->falla as $ind => $checkbox) { $id = 'f_' . $ind; $form->{$id} = new checkboxField($checkbox['nombre'], $id, '1'); $form->{$id}->clause = ''; } $form->submit("reset", "Resetear"); $form->submit("btnsubmit", "Buscar"); $form->build_form(); $algo['falla'] = $this->falla; $algo['form'] =& $form; $salida = $this->load->view('view_fallas', $algo, true); if ($this->input->post('btnsubmit')) { $grid = new DataGrid("Lista de Productos"); $grid->db->select = array("codigo", "LEFT(descrip,20)AS descrip", "margen1", "margen2", "margen3", "margen4", "base1", "base2", "base3", "base4", "precio1", "precio2", "precio3", "precio4", "id", "existen", "ultimo", "pond"); $grid->db->from('sinv'); $grid->per_page = 15; foreach ($this->falla as $ind => $data) { $id = 'f_' . $ind; if ($this->input->post($id)) { $grid->db->or_where($data['sql']); } } $link = anchor('/inventario/sinv/dataedit/show/<#id#>', '<#codigo#>'); //$grid->column("Código",$link); $grid->column("Código", 'codigo'); $grid->column("Descripción", "descrip"); $grid->column("Margenes", "<ol><li><#margen1#></li><li><#margen2#></li><li><#margen3#></li><li><#margen4#></li></ol>"); $grid->column("Bases", "<ol><li><#base1#></li><li><#base2#></li><li><#base3#></li><li><#base4#></li></ol>"); $grid->column("Precios", "<ol><li><#precio1#></li><li><#precio2#></li><li><#precio3#></li><li><#precio4#></li></ol>"); $grid->column("Costos", "<ul><li><b>Ultimo:</b><#ultimo#></li><li><b>Promedio:</b><#pond#></li></ul>"); $grid->column("Existencia", "existen", "align='right'"); $grid->build(); //echo $grid->db->last_query(); $salida .= $grid->output; } $data['content'] = $salida; $data['title'] = "<h1>Productos con fallas</h1>"; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }