public function get()
{
$sql = "SELECT *\n FROM `{$this->tableName}` ";
$result = $this->connect->queryAll($sql);
return $result;
}
/**
* 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);
}
/**
* Retrieve all records from Users
*
* @return mixed
*/
public function getGroupsUsers()
{
$sql = "SELECT gu.uid, gu.gid, u.displayname\n FROM *PREFIX*group_user gu\n LEFT JOIN *PREFIX*users u ON (u.uid = gu.uid)";
return $this->connect->queryAll($sql);
}
public function getAllTalks()
{
$sql = "SELECT *\n FROM `{$this->tableName}` WHERE rid=0 ";
$result = $this->connect->queryAll($sql);
return $result;
}
