public function getUnreadMsg() { $user_id = Session::get('user_id'); $data = PhpConvert::toArray(DB::fetch('msg_notif', array('to_id' => $user_id, 'status' => 0))); foreach ($data as $key => $value) { $temp = User::getPublicUserData($value['user_id'], ['username', 'first_name', 'last_name', 'profile_pic'])[0]; $data[$key] = array_merge($data[$key], $temp); } return $data; }
public function getMessages($username) { $id = User::getPublicUserId($username); $user_id = Session::get('user_id'); $data1 = (array) DB::fetch(array('msg' => ['msg', 'time']), array('from_id' => $id, 'to_id' => $user_id)); $data2 = (array) DB::fetch(array('msg' => ['msg', 'time']), array('from_id' => $user_id, 'to_id' => $id)); foreach ($data1 as $key => $value) { $data1[$key] = (array) $value; $data1[$key]['type'] = 'sent'; } foreach ($data2 as $key => $value) { $data2[$key] = (array) $value; $data2[$key]['type'] = 'received'; } $data = array_merge($data1, $data2); usort($data, function ($a, $b) { return $a['time'] - $b['time']; }); return PhpConvert::toArray($data); }
public function getGroupData($id) { return PhpConvert::toArray(DB::fetch(array('group' => ['group_id', 'group_name', 'desp', 'group_pic', 'time']), array('group_id' => $id))); }
public function search($table, $data, $logic = 'AND') { $columns = '*'; if (gettype($table) === 'array') { if (isset($table[0])) { $table = $table[0]; } else { $columns = ''; $tableData = $table; $table = array_keys($tableData)[0]; $tableData = $tableData[$table]; if (gettype($tableData) === 'string') { $tableData = [$tableData]; } $i = 0; foreach ($tableData as $value) { if ($i === 0) { $columns .= '`' . $value . '`'; } else { $columns .= ', `' . $value . '`'; } $i++; } } } if (count($data) === 1) { $type = gettype($data[array_keys($data)[0]]); if ($type === 'array') { $key = array_keys($data)[0]; $sql = "SELECT " . $columns . " FROM `" . $table . "` WHERE "; $i = 0; foreach ($data[$key] as $value) { if ($i === 0) { $sql .= "`" . $key . "` LIKE '%" . $value . "%'"; } else { $sql .= " " . $logic . " " . "`" . $key . "` LIKE '%" . $value . "%'"; } $i++; } } else { $sql = "SELECT " . $columns . " FROM `" . $table . "` WHERE `" . array_keys($data)[0] . "` LIKE '%" . array_values($data)[0] . "%'"; } } else { $sql = "SELECT " . $columns . " FROM `" . $table . "` WHERE "; $i = 0; foreach ($data as $key => $value) { if ($i === 0) { $sql .= "`" . $key . "` LIKE '%" . $value . "%'"; } else { $sql .= " " . $logic . " " . "`" . $key . "` LIKE '%" . $value . "%'"; } $i++; } } self::query($sql, TRUE); return PhpConvert::toArray($this->_results); }
public function getAcceptedUsersData() { $id = Session::get('user_id'); $sent = DB::fetch(array('request' => 'other_user_id'), array('user_id' => $id, 'status' => 1)); $received = DB::fetch(array('request' => 'user_id'), array('other_user_id' => $id, 'status' => 1)); $ids = array_merge($sent, $received); foreach ($ids as $value) { $value = (array) $value; $id = array_values($value)[0]; $data[] = self::getPublicUserData($id, ['username', 'first_name', 'last_name'])[0]; } return PhpConvert::toArray($data); }
public function getVote($id) { $data = PhpConvert::toArray(DB::fetch(array('vote' => ['vote']), array('user_id' => Session::get('user_id'), 'q_id' => $id))); if (count($data) > 0) { return $data[0]['vote']; } else { return []; } }