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; }
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)); }