Example #1
0
 /**
  * Method used to get the list of technical account managers for
  * a given customer ID.
  *
  * @return  array The list of account managers
  */
 public function getEventumAccountManagers()
 {
     $stmt = 'SELECT
                 cam_usr_id,
                 usr_email,
                 cam_type
              FROM
                 {{%customer_account_manager}},
                 {{%user}}
              WHERE
                 cam_usr_id=usr_id AND
                 cam_prj_id=? AND
                 cam_customer_id=?';
     $params = array($this->crm->getProjectID(), $this->customer_id);
     try {
         $res = DB_Helper::getInstance()->getAll($stmt, $params);
     } catch (DbException $e) {
         return array();
     }
     if (empty($res)) {
         return array();
     }
     return $res;
 }