Example #1
0
 public static function getSentMessages()
 {
     $results = array();
     $results = \DB::query("SELECT\n                               CM.id\n                              ,CM.client_id\n                              ,CM.company_id\n                              ,subject\n                              ,DATE_FORMAT(date, '%d-%m-%Y %H:%i') AS date\n                              ,`from`\n                              ,status_id\n                              ,CMS.description\n                              ,LOWER(CMS.description) AS icon\n                              ,(\n                                SELECT\n                                  U.name\n                                FROM\n                                  clientarea_messages_posts AS CMP\n                                LEFT JOIN\n                                  users AS U ON CMP.user_id = U.id\n                                WHERE\n                                  CMP.message_id = CM.id\n                                AND\n                                  `from` = 'user'\n                                ORDER BY\n                                  date ASC\n                                LIMIT 1\n                              ) AS message_from\n                            FROM\n                              clientarea_messages AS CM\n                            LEFT JOIN\n                               clientarea_messages_statuses AS CMS ON CM.status_id = CMS.id\n                            AND\n                              `from` = 'user'\n                            AND\n                              CM.company_id = " . \Auth::get('call_center_id') . "\n                            ORDER BY\n                              date DESC\n                           ", \DB::SELECT)->execute()->as_array();
     foreach ($results as $key => $result) {
         $Client = Client::forge($result['client_id'], $result['company_id']);
         if ($result['from'] == 'user') {
             $results[$key]['message_from'] = $Client->fullName();
         }
         $results[$key]['client_name'] = $Client->fullName();
         unset($Client);
     }
     return $results;
 }
Example #2
0
 public function post_validate_client_id()
 {
     $clientID = (int) \Input::post('clientID');
     $companyID = (int) \Input::post('companyID');
     Model_ClientArea::forge($companyID, $clientID);
     $data = array();
     if (Model_ClientArea::validateClientID() === true) {
         $Client = Client::forge($clientID, $companyID);
         $data = array('fullName' => $Client->fullName());
         $status = 'success';
     } else {
         $status = 'failed';
     }
     $this->response(array('status' => $status, 'message' => '', 'data' => $data));
 }