public function getUsersId()
{
$sql = "SELECT uid\n FROM `{$this->tableName}` ";
$result = $this->connect->queryAll($sql);
$arrId = [];
for ($i = 0; $i < count($result); $i++) {
$arrId[] = $result[$i]['uid'];
}
return $arrId;
}
public function getByGid($gid)
{
$sql = "SELECT `uid` FROM `{$this->tableName}`\n WHERE gid = :gid";
$result = $this->connect->queryAll($sql, [':gid' => $gid]);
$arr = [];
for ($i = 0; $i < count($result); $i++) {
$arr[] = $result[$i]['uid'];
}
return $arr;
}
/**
* Retrieve tasks-data of project
* Database query selects all opened records, and all columns of type timestamp output
* formatting for JavaScript identification
* @return array|null
*/
public function get()
{
$sql = "SELECT *,\n DATE_FORMAT( `start_date`, '%d-%m-%Y %H:%i:%s') as start_date,\n DATE_FORMAT( `end_date`, '%d-%m-%Y %H:%i:%s') as end_date\n FROM `{$this->tableName}` WHERE open = 1";
return $this->connect->queryAll($sql);
}
public function get()
{
$sql = "SELECT uid\n FROM `{$this->tableName}` ";
$result = $this->connect->queryAll($sql);
return $result;
}