PHP DataGrid::column_detail方法代码示例

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     //filter
     $filter = new DataFilter("Filtro de soporte", 'soporte');
     $filter->usuario = new inputField("Usuario", "usuario");
     $filter->estampa = new inputField("Estampa", "estampa");
     $filter->titulo = new inputField("Titulo", "titulo");
     $filter->comentario = new inputField("Comentario", "comentario");
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = "supervisor/sopor/dataedit/show/<#id#>";
     $grid = new DataGrid("Filtro de soporte");
     //$grid->order_by("nombre","asc");
     $grid->per_page = 20;
     $grid->column_detail("Usuario", "usuario", $uri);
     $grid->column("Estampa", "estampa");
     $grid->column("Titulo", "titulo");
     $grid->column("Comentario", "comentario");
     $grid->add("supervisor/soporte/dataedit/create");
     $grid->build();
     //grid
     $data["crud"] = $filter->output . $grid->output;
     $data["titulo"] = 'Soporte';
     $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 la tabla scli del Modulo de N&oacute;mina</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 index()
 {
     $this->rapyd->load('datagrid');
     $this->rapyd->load('datafilter');
     $control = array(false, false);
     $filter = new DataFilter('Filtro de Facturas');
     $filter->fechad = new dateField('Desde', 'fechad', 'd/m/Y');
     $filter->fechad->operator = '>=';
     $filter->fechah = new dateField('Hasta', 'fechah', 'd/m/Y');
     $filter->fechah->operator = '<=';
     $filter->fechah->clause = $filter->fechad->clause = 'where';
     $filter->fechah->db_name = $filter->fechad->db_name = 'fecha';
     $filter->fechah->size = $filter->fechad->size = 10;
     $filter->fechah->insertValue = $filter->fechad->insertValue = date('Y/m/d');
     $filter->fechah->group = $filter->fechad->group = 'Fecha';
     $filter->nombre = new inputField('Nombre', 'nombre');
     $filter->nombre->db_name = "CONCAT(b.nombres,' ',b.apellidos)";
     $filter->cedula = new inputField('C&eacute;dula/RIF', 'cedula');
     $filter->buttons('reset', 'search');
     $action = "javascript:window.location='" . site_url('supermercado/poscuadre') . "'";
     $filter->button('btn_regresa', 'Regresar', $action, 'TR');
     $filter->build();
     if (empty($filter->fechah->value) or $filter->fechah->value == date('Y/m/d')) {
         $control[0] = true;
     }
     if (empty($filter->fechah->value) or $filter->fechah->value == date('Y/m/d')) {
         $control[1] = true;
     }
     $grid = new DataGrid();
     $grid->per_page = 10;
     $select = array('b.cedula', "DATE_FORMAT(a.fecha, '%d/%m/%Y') fecha", 'a.cajero', 'a.caja', 'a.tipo', 'a.numero', "DATE_FORMAT(a.fecha, '%Y%m%d') qfecha", "IF(b.nombres IS NULL,a.nombres,CONCAT(b.nombres,' ',b.apellidos)) nombres", 'a.impuesto', 'a.gtotal', 'a.hora');
     $grid->db->select($select);
     $grid->db->from('viefac a');
     $grid->db->join('club b', 'a.cliente=b.cod_tar', 'LEFT');
     if ($control[0]) {
         $grid->db->where('a.fecha>=', 'NOW()');
     }
     if ($control[1]) {
         $grid->db->where('a.fecha<=', 'NOW()');
     }
     $grid->db->orderby('a.fecha, a.caja, a.numero');
     $grid->column_detail('Caja', 'caja', site_url("supermercado/buscafac/verfactura/<#caja#>/<#cajero#>/<#qfecha#>/<#numero#>"));
     $grid->column('Cajero', 'cajero');
     $grid->column('Tipo', 'tipo');
     $grid->column('N&uacute;mero', 'numero');
     $grid->column('Fecha', 'fecha');
     $grid->column('Cedula', 'cedula');
     $grid->column('Nombres', 'nombres');
     $grid->column('Impuesto', 'impuesto');
     $grid->column('Total', 'gtotal');
     $grid->build();
     //echo $grid->db->last_query();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = '<h1>Consulta de facturas</h1>';
     $data['head'] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

 function index()
 {
     $this->rapyd->load("datagrid");
     $this->rapyd->load("datafilter");
     $control = array(false, false);
     $filter = new DataFilter("Filtro de Facturas");
     $filter->fechad = new dateField("Desde", "fechad", "d/m/Y");
     $filter->fechad->operator = ">=";
     $filter->fechah = new dateField("Hasta", "fechah", "d/m/Y");
     $filter->fechah->operator = "<=";
     $filter->fechah->clause = $filter->fechad->clause = "where";
     $filter->fechah->db_name = $filter->fechad->db_name = "fecha";
     $filter->fechah->size = $filter->fechad->size = 10;
     $filter->fechah->insertValue = $filter->fechad->insertValue = date('Y/m/d');
     $filter->nombre = new inputField("Nombre", "nombre");
     $filter->nombre->db_name = "concat(b.nombres,' ',b.apellidos)";
     $filter->cedula = new inputField("C&eacute;dula/RIF", "cedula");
     $filter->buttons("reset", "search");
     $filter->build();
     if (empty($filter->fechah->value) or $filter->fechah->value == date('Y/m/d')) {
         $control[0] = true;
     }
     if (empty($filter->fechah->value) or $filter->fechah->value == date('Y/m/d')) {
         $control[1] = true;
     }
     $grid = new DataGrid();
     $grid->per_page = 10;
     $select = array("b.cedula", "DATE_FORMAT(a.fecha, '%d/%m/%Y') fecha", "a.cajero", "a.caja", "a.tipo", "a.numero", "DATE_FORMAT(a.fecha, '%Y%m%d') qfecha", "if(b.nombres IS NULL,a.nombres,concat(b.nombres,' ',b.apellidos)) nombres", "a.impuesto", "a.gtotal", "a.hora");
     $grid->db->select($select);
     $grid->db->from("viefac a");
     $grid->db->join("club b", "a.cliente=b.cod_tar", "LEFT");
     if ($control[0]) {
         $grid->db->where('a.fecha>=', 'NOW()');
     }
     if ($control[1]) {
         $grid->db->where('a.fecha<=', 'NOW()');
     }
     $grid->db->orderby('a.fecha, a.caja, a.numero');
     $grid->column_detail("Caja", "caja", site_url("supermercado/buscafac/verfactura/<#caja#>/<#cajero#>/<#qfecha#>/<#numero#>"));
     $grid->column("Cajero", "cajero");
     $grid->column("Tipo", "tipo");
     $grid->column("Numero", "numero");
     $grid->column("Fecha", "fecha");
     $grid->column("Cedula", "cedula");
     $grid->column("Nombres", "nombres");
     $grid->column("Impuesto", "impuesto");
     $grid->column("Total", "gtotal");
     $grid->build();
     //echo $grid->db->last_query();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = '<h2>Consulta de facturas desde la fecha ' . $filter->fechad->value . ' hasta ' . $filter->fechah->value . '</h2>';
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

 function index()
 {
     $this->rapyd->load("datagrid");
     $this->rapyd->load("datafilter");
     $diai = $this->uri->segment(4);
     $mesi = $this->uri->segment(5);
     $anoi = $this->uri->segment(6);
     if ($diai === FALSE or $mesi === FALSE or $anoi === FALSE) {
         $fechai = date('Y/m/d');
         $qfechai = date('Ymd');
     } else {
         $fechai = "{$anoi}/{$mesi}/{$diai}";
         $qfechai = $anoi . $mesi . $diai;
     }
     $filter = new DataForm('supermercado/poscuadre/index');
     $filter->title('Filtro de cajas');
     $filter->fechai = new dateField("Fecha", "fechai", "d/m/Y");
     $filter->fechai->insertValue = $fechai;
     $filter->fechai->size = 10;
     $filter->button("btnsubmit", "Buscar", form2uri(site_url('supermercado/poscuadre/index'), 'fechai'), $position = "BL");
     $filter->build_form();
     $grid = new DataGrid();
     //$grid->db->select("a.caja caja,IFNULL(b.nombre,'N/A') nombre, a.cajero as cajero,FORMAT(SUM(a.gtotal),2) monto, sum(TRUNCATE(a.gtotal/50000,0)) cupones ");
     $select = array("a.caja caja", "IFNULL(b.nombre,'N/A') nombre", "a.cajero as cajero", "FORMAT(SUM(a.gtotal),2) monto", "sum(TRUNCATE(a.gtotal/50000,0)) cupones");
     $grid->db->select($select);
     $grid->db->from("posfact a");
     $grid->db->where("substring(numero,1,1)!=", 'X');
     $grid->db->where("fecha", $qfechai);
     $grid->db->join("scaj b", "a.cajero=b.cajero", "LEFT");
     $grid->db->groupby('a.caja,a.cajero');
     $grid->column_detail("Caja", "caja", site_url("supermercado/poscuadre/concaja/<#caja#>/<#cajero#>/{$qfechai}"));
     $grid->column("Nombre", "nombre");
     $grid->column("Cajero", "cajero", 'align="center"');
     $grid->column("Cupones", "cupones", 'align="center"');
     $grid->column("Monto", "monto", 'align="right"');
     $grid->build();
     //echo $grid->db->last_query();
     $consul = new DataForm('supermercado/buscafac/index/search/osp');
     $consul->title('Buscar Factura');
     $consul->fechad = new dateField("Desde", "fechad", "d/m/Y");
     $consul->fechah = new dateField("Hasta", "fechah", "d/m/Y");
     $consul->nombre = new inputField("Nombre", "nombre");
     $consul->cedula = new inputField("C&eacute;dula/RIF", "cedula");
     $consul->fechad->insertValue = $consul->fechah->insertValue = date("Y/m/d");
     $consul->fechah->size = $consul->fechad->size = 10;
     $consul->submit("btn_submit", "Buscar");
     $consul->build_form();
     $data['content'] = $filter->output . $grid->output . $consul->output;
     $data['title'] = "<h1>Consulta de Cajas</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

 function datagrid()
 {
     //datagrid//
     $this->rapyd->load("datagrid");
     $link = site_url('rapyd/crudsamples/dataedit/show/<#article_id#>');
     $grid = new DataGrid("Article List", "articles");
     $grid->per_page = 5;
     $grid->use_function("substr", "strtoupper");
     $grid->column_detail("ID", "article_id", $link);
     $grid->column("Title", 'title', ' style="color:#ff0000" ');
     $grid->column("Body", "<substr><#body#>|0|7</substr>..");
     $grid->build();
     $data["grid"] = $grid->output;
     //enddatagrid//
     $content["content"] = $this->load->view('rapyd/datagrid', $data, true);
     $content["rapyd_head"] = $this->rapyd->get_head();
     $content["code"] = highlight_code_file(THISFILE, "//datagrid//", "//enddatagrid//");
     $this->load->view('rapyd/template', $content);
 }

 function items_grid()
 {
     $this->rapyd->load("datagrid");
     $art_id = intval($this->uri->segment(4));
     $grid = new DataGrid("Art�culos", "itstra");
     $grid->db->where("numero", $art_id);
     $modify = site_url("inventario/stra/items_edit/{$art_id}/modify/<#numero#>/<#codigo#>");
     $delete = anchor("inventario/stra/items_edit/{$art_id}/do_delete/<#numero#>/<#codigo#>", "Eliminar");
     $grid->order_by("codigo", "desc");
     $grid->per_page = 20;
     $grid->column_detail("N�mero", "numero", $modify);
     $grid->column("C�digo", "codigo");
     $grid->column("Descripci�n", "descrip");
     $grid->column("Cantidad", "cantidad");
     $grid->column("Eliminar", $delete);
     $grid->add("inventario/stra/items_edit/{$art_id}/create");
     $grid->build();
     $head = $this->rapyd->get_head();
     $this->loadiframe($grid->output, $head, "related");
 }

 function buscafac()
 {
     $this->rapyd->load("datagrid");
     $this->rapyd->load("datafilter");
     $control = array(false, false);
     $filter = new DataFilter("Filtro de Facturas");
     $filter->fechad = new dateField("Desde", "fechad", "d/m/Y");
     $filter->fechad->operator = ">=";
     $filter->fechah = new dateField("Hasta", "fechah", "d/m/Y");
     $filter->fechah->operator = "<=";
     $filter->fechah->clause = $filter->fechad->clause = "where";
     $filter->fechah->db_name = $filter->fechad->db_name = "fecha";
     $filter->fechah->size = $filter->fechad->size = 10;
     $filter->fechah->insertValue = $filter->fechad->insertValue = date('Y/m/d');
     $filter->nombre = new inputField("Nombre", "nombre");
     $filter->nombre->db_name = "concat(b.nombres,' ',b.apellidos)";
     $filter->cedula = new inputField("C&eacute;dula/RIF", "cedula");
     $filter->buttons("reset", "search");
     $filter->build();
     if (empty($filter->fechah->value) or $filter->fechah->value == date('Y/m/d')) {
         $control[0] = true;
     }
     if (empty($filter->fechah->value) or $filter->fechah->value == date('Y/m/d')) {
         $control[1] = true;
     }
     $grid = new DataGrid();
     $grid->per_page = 10;
     $grid->db->select("b.cedula, DATE_FORMAT('a.fecha', '%d/%m/%Y') fecha, a.cajero, a.caja, a.tipo, a.numero, a.fecha, if(b.nombres IS NULL,a.nombres,concat(b.nombres,' ',b.apellidos)) nombres, a.impuesto, a.gtotal, a.hora ");
     $grid->db->from("viefac a");
     $grid->db->join("club b", "a.cliente=b.cod_tar", "LEFT");
     if ($control[0]) {
         $grid->db->where('a.fecha>=NOW()');
     }
     if ($control[1]) {
         $grid->db->where('a.fecha<=NOW()');
     }
     $grid->db->orderby('a.fecha, a.caja, a.numero');
     $grid->column_detail("Caja", "caja", site_url("supermercado/factura/<#caja#>/<#cajero#>/<#fecha#>/<#numero#>"));
     $grid->column("Cajero", "cajero");
     $grid->column("Tipo", "tipo");
     $grid->column("Numero", "numero");
     $grid->column("Fecha", "fecha");
     $grid->column("Cedula", "cedula");
     $grid->column("Nombres", "nombres");
     $grid->column("Impuesto", "impuesto");
     $grid->column("Total", "gtotal");
     $grid->build();
     //echo $grid->db->last_query();
     $data['lista'] = '';
     $data['forma'] = $filter->output . $grid->output;
     $data['titulo'] = $this->rapyd->get_head() . '<center><h2>CONSULTA DE FACTURAS DESDE LA FECHA ' . $filter->fechad->value . ' HASTA ' . $filter->fechah->value . '</h2></center>';
     $this->layout->buildPage('ventas/view_ventas', $data);
 }

 function filteredgrid()
 {
     //filteredgrid//
     $this->rapyd->load("datafilter", "datagrid");
     //filter
     $filter = new DataFilter("Article Filter");
     //****************************************************************************
     //* NOTES 1:
     //* After the new DataFilter() instruction the DF constructor call the DF    *
     //* sniff_action() methode witch it gives the GFID if it is not set.         *
     //* so $filter->gfid is knowed directly after this instantiation....           *
     //****************************************************************************
     $filter->db->select("articles.*, authors.*");
     $filter->db->from("articles");
     $filter->db->join("authors", "authors.author_id=articles.author_id", "LEFT");
     $filter->title = new inputField("Title", "title");
     $filter->ispublic = new dropdownField("Public", "public");
     $filter->ispublic->option("", "");
     $filter->ispublic->options(array("y" => "Yes", "n" => "No"));
     $filter->buttons("reset", "search");
     $filter->build();
     //grid
     //****************************************************************************
     //* NOTES 2:                                                                 *
     //* The Standard acces link to DataEdit, affected to the colum_detail col    *
     //* (No support for back session because GFID in not into the URI).          *
     //* Don't use it for the test....                                            *
     //****************************************************************************
     $linkSTDshow = site_url('rapyd/sessiontest/dataedit/show/<#article_id#>');
     $grid = new DataGrid("Article List", null, $filter->uri_array);
     $grid->order_by("article_id", "asc");
     $grid->per_page = 5;
     $grid->use_function("substr");
     $grid->column_detail("ID", "article_id", $linkSTDshow);
     $grid->column_orderby("title", "title", "title");
     $grid->column("body", "<substr><#body#>|0|4</substr>....");
     $grid->column("Author", "<#firstname#> <#lastname#>");
     //*********************************************************************************
     //* NOTES 3:                                                                      *
     //* The differents acces link to DataEdit in diffenrent states, with GFID in URI  *
     //* DE is now compliance with GFID in URI, to generate right back_url             *
     //*********************************************************************************
     $linkshow = anchor("rapyd/sessiontest/directdataedit/gfid/{$grid->gfid}/show/<#article_id#>", "Show");
     $linkedit = anchor("rapyd/sessiontest/directdataedit/gfid/{$grid->gfid}/modify/<#article_id#>", "Modify");
     $linkdelete = anchor("rapyd/sessiontest/directdataedit/gfid/{$grid->gfid}/delete/<#article_id#>", "Delete");
     $linkcreate = anchor("rapyd/sessiontest/directdataedit/gfid/{$grid->gfid}/create", "Create");
     //*********************************************************************
     //* NOTES 4:                                                          *
     //* URI to DataEdit Change:                                           *
     //* For me it is the most problematic thing of this solution          *
     //* the URI to DE need now a DF property value for that back session  *
     //* Work. The uri IS MORE COMPLICATE;                                 *
     //*
     //*********************************************************************
     $grid->column("Actions", $linkcreate . " - " . $linkshow . " - " . $linkedit . " - " . $linkdelete);
     //****************************************************************
     //* NOTES 5:                                                     *
     //* We also need to add the GFID in the 'add' URI                *
     //****************************************************************
     $grid->add("rapyd/sessiontest/directdataedit/gfid/{$grid->gfid}/create");
     $grid->build();
     $test = "GFID current Value => " . $filter->gfid . "<br>";
     $data["crud"] = $test . $filter->output . $grid->output;
     //endfilteredgrid//
     $content["content"] = $this->load->view('rapyd/crud', $data, true);
     $content["rapyd_head"] = $this->rapyd->get_head();
     $content["code"] = highlight_code_file(THISFILE, "//filteredgrid//", "//endfilteredgrid//");
     $this->load->view('rapyd/template_test', $content);
 }

 function importgext_grid()
 {
     //commentsgrid//
     $this->rapyd->load("datagrid");
     $numero = $this->uri->segment(4);
     $grid = new DataGrid("Gastos en el Exterior", "importgext");
     $grid->db->where("numero", $numero);
     $modify = site_url("import/importa/importgext_edit/{$numero}/modify/<#codigo#>");
     $delete = anchor("import/importa/importgext_edit/{$numero}/do_delete/<#codigo#>", "delete");
     $grid->order_by("factura", "desc");
     $grid->per_page = 6;
     $grid->column_detail("Factura", "factura", $modify, "align=left");
     $grid->column("Fecha", "fecha");
     $grid->column("Descripci&oacute;n", "descrip");
     $grid->column("Precio", "<number_format><#precio#>|2</number_format>", "align=right");
     $grid->column("Importe", "<number_format><#importe#>|2</number_format>", "align=right");
     $grid->column("borrar", $delete);
     $grid->add("import/importa/importgext_edit/{$numero}/create");
     $grid->build();
     $head = $this->rapyd->get_head();
     $this->loadiframe($grid->output, $head, "related");
     //endcommentsgrid//
 }

 function comments_grid()
 {
     //commentsgrid//
     $this->rapyd->load("datagrid");
     $art_id = intval($this->uri->segment(4));
     $grid = new DataGrid("Comments", "comments");
     $grid->db->where("article_id", $art_id);
     $modify = site_url("inventario/crudsamples/comments_edit/{$art_id}/modify/<#comment_id#>");
     $delete = anchor("inventario/crudsamples/comments_edit/{$art_id}/do_delete/<#comment_id#>", "delete");
     $grid->order_by("comment_id", "desc");
     $grid->per_page = 6;
     $grid->column_detail("ID", "comment_id", $modify);
     $grid->column("comment", "<substr><#comment#>|0|100</substr>....");
     $grid->column("delete", $delete);
     $grid->add("inventario/crudsamples/comments_edit/{$art_id}/create");
     $grid->build();
     $head = $this->rapyd->get_head();
     $this->loadiframe($grid->output, $head, "related");
     //endcommentsgrid//
 }

 function comments_grid()
 {
     //commentsgrid//
     $this->rapyd->load("datagrid");
     $numero = $this->uri->segment(4);
     $grid = new DataGrid("Comments", "itfmay");
     $grid->db->where("numero", $numero);
     $modify = site_url("import/crudsamples/comments_edit/{$numero}/modify/<#codigo#>");
     $delete = anchor("import/crudsamples/comments_edit/{$numero}/do_delete/<#codigo#>", "delete");
     $grid->order_by("codigo", "desc");
     $grid->per_page = 6;
     $grid->column_detail("Codigo", "codigo", $modify, "align=left");
     $grid->column("Descripcion", "descrip");
     $grid->column("Cant.", "cantidad", "align=right");
     $grid->column("Frac.", "fraccion", "align=right");
     $grid->column("Precio", "<number_format><#precio#>|2</number_format>", "align=right");
     $grid->column("Importe", "<number_format><#importe#>|2</number_format>", "align=right");
     $grid->column("borrar", $delete);
     $grid->add("import/crudsamples/comments_edit/{$numero}/create");
     $grid->build();
     $head = $this->rapyd->get_head();
     $this->loadiframe($grid->output, $head, "related");
     //endcommentsgrid//
 }