Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //-------------------Control-------------------------------------------------
- public function index() {
- Template::set('toolbar_title', 'Manage Employees List');
- Template::render();
- }
- public function pagination() {
- $this->employees_list_model->search_document();
- }
- //--------------------Model------------------------------------------------
- public function search_document() {
- $input = array('dataperpage', 'query', 'curpage');
- foreach ($input as $val)
- $$val = $this->input->post($val);
- $query = $this->db->escape_like_str($query);
- $where = "'no_badge' LIKE '%{$query}%' OR 'position' LIKE '%{$query}%'";
- $query = $this->db->query("SELECT COUNT('id') AS 'HASIL' FROM bf_employees_list WHERE
- $where");
- $total = $query->row()->HASIL;
- $npage = ceil($total / $dataperpage);
- $start = $curpage * $dataperpage;
- $end = $start + $dataperpage;
- $query = $this->db->query("SELECT 'no_badge', 'position', 'status' FROM bf_employees_list
- WHERE $where LIMIT $start, $dataperpage");
- $hasil = array(
- 'data' => array(),
- 'pagination' => '',
- 'numpage' => $npage - 1,
- );
- if ($query->num_rows() > 0) {
- foreach ($query->result() as $row) {
- $hasil['data'][] = array(
- 'judul' => $row->no_badge,
- 'pengarang' => $row->position,
- 'tahun' => $row->status
- );
- }
- }
- $hasil['pagination'] .= '<ul>
- <li class="'. ($curpage == 0 ? 'disabled' : '') .'" onclick="return Document.prevPage
- ()"><a href>«</li>';
- for ($i = 1; $i <= $npage; $i++) {
- $hasil['pagination'] .= '<li class="' . ($curpage == ($i - 1) ? 'active' : '') . '"
- onclick="return Document.setPage(' . ($i - 1) .')"><a href>' . $i . '</a></li>';
- }
- $hasil['pagination'] .= '<li class="' . ($curpage == $npage - 1 ? 'disabled' : '') . '"
- onclick="return Document.nextPage()"><a href>»</a></li>
- </ul>';
- echo json_encode($hasil, JSON_HEX_TAG | JSON_HEX_APOS | JSON_HEX_QUOT | JSON_HEX_AMP);
- }
- //--------------------Views------------------------------------------------
- <script>
- var Document = {
- param: {
- dataperpage: 10, // jumlah data per halaman
- query: '',
- curpage: 0,
- numpage: 0
- },
- url: "<?=base_url().'/admin/employees/employees_list/'?>",
- search: function() {
- this.param.query = $('#query').val();
- this.param.curpage = 0;
- this.loadData();
- return false;
- },
- setPage: function(n) {
- this.param.curpage = n;
- this.loadData();
- return false;
- },
- prevPage: function() {
- if (this.param.curpage > 0) {
- this.param.curpage--;
- this.loadData();
- }
- return false;
- },
- nextPage: function() {
- if (this.param.curpage < this.param.numpage) {
- this.param.curpage++;
- this.loadData();
- }
- return false;
- },
- loadData: function() {
- $.ajax({
- url: Document.url,
- type: 'POST',
- dataType: 'json',
- data: jQuery.param(Document.param),
- success: function(d) {
- $('#pagination').html(d.pagination);
- Document.param.numpage = d.numpage;
- var t = '', dt = {};
- for (var i = 0; i < d.data.length; i++) {
- dt = d.data[i];
- t += '<tr><td>' + dt.judul +'</td>' +
- '<td>' + dt.pengarang + '</td>' +
- '<td>' + dt.tahun + '</td></tr>';
- }
- $('#document-data').html(t); // id dari tbody tabel data
- }
- });
- }
- }
- $(document).ready(function() {
- Document.search();
- });
- </script>
- <div class="admin-box">
- <h3>Employees List</h3>
- <form class="form-inline">
- <input type="text" name="query" id="query" class="input-large">
- <button class="btn" onclick="return Document.search()"><i class="icon-search"></i>
- Cari</button>
- </form>
- <hr>
- <table class="table table-bordered table-condensed table-striped">
- <thead>
- <tr>
- <th>Judul</th>
- <th>Pengarang</th>
- <th>Tahun</th>
- </tr>
- </thead>
- <tbody id="document-data">
- <tr>
- <td></td>
- <td></td>
- <td></td>
- </tr>
- </tbody>
- </table>
- <hr>
- <div class="pagination pagination-centered pagination-medium" id="pagination">
- </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement