public function getHost($app_id) { $this->db->select('server_login,server_api,server_mq'); $query = $this->db->get_where($this->tb_app, array('app_id' => $app_id)); $result = resultFilter($query->result_array()); return $result; }
public function getUser($user) { $this->db->select('user_id,app_id,login_id,user_name,user_img,user_email,user_phone,notice_pm,notice_pm_value,notice_filter,user_prefer'); $query = $this->db->get_where($this->tb_user, $user); $result = resultFilter($query->result_array()); return $result; }
public function getDeviceByUser($user_id) { $sql = 'select device_id from ' . $this->tb_bind . ' where user_id =' . $user_id; $result = $this->db->query($sql)->result_array(); $array = array(); if ($result) { foreach ($result as $row) { $array[] = $this->getDevice(array('device_id' => $row['device_id'])); } } return resultFilter($array); }