public function getMessageTopParent($id)
{
$rid = $id;
if ($rid > 0) {
while ($rid > 0) {
$parent = $rid;
$res = $this->connect->select("rid", $this->tableName, "id = :id", [':id' => $rid]);
$rid = $res[0]['rid'];
}
}
return $parent;
}
private function setAllText()
{
$result = Connect::select("text", "");
foreach ($result as $val) {
App::$text[$val['key_t']] = $val['content'];
}
}
public function getUserStatus($mid)
{
if ($mid) {
$users = array();
$userlist = $this->connect->select('uid, status', $this->tableName, 'mid = ' . $mid);
foreach ($userlist as $u => $user) {
$users[$user['uid']] = $user['status'];
}
return $users;
} else {
return false;
}
}
function login()
{
require_once ROOT_REQUEST . "loginRequest.php";
$req = new loginRequest();
if ($req->_error()) {
$user = Connect::select("user", " WHERE email='" . $req->_req('email') . "' and password='******'password')) . "' ");
if (count($user) > 0) {
$_SESSION['email'] = $req->_req('email');
$_SESSION['password'] = md5($req->_req('password'));
echo json_encode(['status' => true]);
exit(0);
}
}
echo json_encode(['status' => false]);
}
/**
* @param $id
* @return mixed
*/
public function getChildren($id)
{
$message = $this->connect->select("*", $this->tableName, "status < 2 AND rid = :rid ", [':rid' => $id]);
return $message;
}
public function getById($id)
{
$project = $this->connect->select("*", $this->tableName, "id = :id", [':id' => 1]);
return $project;
}
public function getMimeType($id)
{
$mimetype = $this->connect->select("mimetype", "oc_mimetypes", "id = :id", [':id' => $id]);
return $mimetype;
}
public function getById($id)
{
$user = $this->connect->select("*", $this->tableName, "uid = :id", [':id' => $id]);
return $user;
}
/**
* Retrieve all date of links project-tasks
* @return array|null
*/
public function get()
{
return $this->connect->select('*', $this->tableName);
}
/**
* Retrieve all date of links project-tasks
*
* @return array|null
*/
public function get()
{
return $this->connect->select('*', $this->tableName, 'deleted != 1');
}
