kisukedeath

Jtable pagination

Aug 28th, 2013
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.13 KB | None | 0 0
  1. $results = $this->_convertObjectToArrayRecursivelly($this->userModel->read(
  2.                         'id_user, firstname, name, date_of_birth, address, zip_code, city, mobile_phone, login, email', // DON'T GET PASSWORD !
  3.                         $where, (($this->input->get('jtPageSize'))) ? $this->input->get('jtPageSize') : null, (($this->input->get('jtStartIndex'))) ? $this->input->get('jtStartIndex') : 0, null, (($this->input->get('jtSorting'))) ? $this->input->get('jtSorting') : null, null, false
  4.                 )
  5.         );
  6.  
  7.         foreach ($results as $key => $result) {
  8.             $result->address = deleteBR($result->address);
  9.         }
  10.  
  11.         $count = $this->userModel->read('count(*) as "count"', $where)->count;
  12.  
  13.         if ($count > 0) {
  14.             if ($this->input->get('options')) {
  15.                 foreach ($results as $key => $value) {
  16.                     // Create a complex description for the user.
  17.                     // Format: Nom/Type
  18.                     //         Catégorie/Famille
  19.                     $options[$key]['DisplayText'] = ($this->input->get('displayType') == "select") ? $value->pseudo : '<span class="i b my-tooltip" rel="tooltip" title="<b>Id</b>: ' . $value->id_user . '. <br /><b>Pseudo</b>: ' . $value->pseudo . '. <br /><b>Email</b>: ' . $value->email . '">' . $value->pseudo . '</span>';
  20.                     $options[$key]['Value'] = $value->id_user;
  21.                 }
  22.  
  23.                 $jTableResult['Result'] = "OK";
  24.                 $jTableResult['Options'] = $options;
  25.                 $jTableResult['TotalRecordCount'] = $count;
  26.             } else {
  27.                 $jTableResult['Result'] = "OK";
  28.                 $jTableResult['Records'] = $results;
  29.                 $jTableResult['TotalRecordCount'] = $count;
  30.             }
  31.         } else {
  32.             $jTableResult['Result'] = "OK";
  33.             $jTableResult['Message'] = lang('lang_controller_research_no_result_administrator');
  34.             $jTableResult['TotalRecordCount'] = $count;
  35.             $jTableResult['Options'] = array();
  36.             $jTableResult['Records'] = array();
  37.         }
  38.  
  39.         echo json_encode($jTableResult);
Advertisement
Add Comment
Please, Sign In to add comment