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 [];
}
}
