function datatable() { //datatable// $this->rapyd->load("datatable"); $table = new DataTable(null, $this->data); $table->per_row = 3; $table->per_page = 6; $table->use_function("substr", "strtoupper"); $table->cell_template = ' <div style="padding:4px"> <div style="color:#119911; font-weight:bold"><#title#></div> This is the body number <substr><#body#>|5|100</substr> </div>'; $table->build(); $data["table"] = $table->output; //enddatatable// $content["content"] = $this->load->view('rapyd/datatable', $data, true); $content["rapyd_head"] = $this->rapyd->get_head(); $content["code"] = highlight_code_file(THISFILE, "//datatable//", "//enddatatable//"); $this->load->view('rapyd/template', $content); }
function enlistar() { //$this->session->_flashdata_sweep(); //echo '<pre>';print_r($this->session->userdata);echo '</pre>'; $repo = $this->uri->segment(3); $this->rapyd->load("datatable"); $this->rapyd->config->set_item("theme", "clean"); if ($repo) { $repo = strtoupper($repo); $grid = new DataTable(); //$grid->db->select('titulo, mensaje, SUBSTR(SUBSTRING_INDEX(REPLACE(ejecutar, "\'",\'"\'), \'"\', 2),10) AS nombre'); //$grid->db->from("tmenus"); //$grid->db->where("modulo='".$repo."LIS' AND TRIM(ejecutar) LIKE 'REPOSQL(%)'"); $grid->db->select('a.titulo, a.mensaje, a.nombre'); $grid->db->from("intrarepo AS a"); $grid->db->join("reportes AS b", "a.nombre=b.nombre"); $grid->db->where('a.modulo', $repo); $grid->db->where('a.activo', 'S'); $grid->per_row = 3; $grid->use_function("substr", "strtoupper"); $grid->cell_template = ' <div style="padding:4px"> <div style="color:#119911; font-weight:bold">' . anchor('reportes/ver/<#nombre#>/' . $repo, "<#titulo#>", array('onclick' => "parent.navegador.afiltro()")) . '</div> <htmlspecialchars><#mensaje#></htmlspecialchars> </div>'; $grid->build(); //echo $grid->db->last_query(); } if ($repo and $grid->recordCount > 0) { $data['forma'] = $grid->output; } else { $data['forma'] = '<p class="mainheader">No se encontrarón reportes.</p>'; } //echo $grid->db->last_query(); $data['head'] = $this->rapyd->get_head(); $data['titulo'] = "<center><h2>Listados Disponibles</h2></center>"; $data['repo'] = $repo; //$CI->session->set_userdata('estaba', $CI->uri->uri_string()); $this->load->view('view_reportes', $data); }