/** * Init task * * @param int $id Article ID * * @since 1.0.0 * @author Dennis Eichhorn <*****@*****.**> */ public function init($id) { $this->id = $id; $data = null; $elements = null; switch ($this->dbPool->get('core')->getType()) { case \phpOMS\DataStorage\Database\DatabaseType::MYSQL: $sth = $this->dbPool->get('core')->con->prepare('SELECT `' . $this->dbPool->get('core')->prefix . 'tasks`.* FROM `' . $this->dbPool->get('core')->prefix . 'tasks` WHERE `' . $this->dbPool->get('core')->prefix . 'tasks`.`TaskID` = :id'); $sth->bindValue(':id', $id, \PDO::PARAM_INT); $sth->execute(); $data = $sth->fetchAll()[0]; $sth = $this->dbPool->get('core')->con->prepare('SELECT `' . $this->dbPool->get('core')->prefix . 'tasks_element`.* FROM `' . $this->dbPool->get('core')->prefix . 'tasks_element` WHERE `' . $this->dbPool->get('core')->prefix . 'tasks_element`.`task` = :id'); $sth->bindValue(':id', $id, \PDO::PARAM_INT); $sth->execute(); $elements = $sth->fetchAll(); break; } $this->title = $data['title']; $this->creator = $data['creator']; $this->created = new \DateTime($data['created']); $this->description = $data['desc']; $this->status = $data['status']; $this->due = new \DateTime($data['due']); $this->done = new \DateTime($data['done']); foreach ($elements as $element) { $elementOBJ = new TaskElement($this->dbPool); $elementOBJ->setID($element['TaskelementID']); $elementOBJ->setTask($element['task']); $elementOBJ->setStatus($element['status']); $elementOBJ->setCreated(new \DateTime($element['created'])); $elementOBJ->setCreator($element['creator']); $elementOBJ->setDescription($element['desc']); $elementOBJ->setDue(new \DateTime($element['due'])); $elementOBJ->setForwarded($element['forwarded']); $this->addElement($elementOBJ); } }
/** * Get all staff members * * This function gets all accounts in a range * * @param array $filter Filter for search results * @param int $offset Offset for first account * @param int $limit Limit for results * * @return array * * @since 1.0.0 * @author Dennis Eichhorn <*****@*****.**> */ public function getList($filter = null, $offset = 0, $limit = 100) { $result = null; switch ($this->dbPool->get('core')->getType()) { case \phpOMS\DataStorage\Database\DatabaseType::MYSQL: $search = $this->dbPool->get('core')->generate_sql_filter($filter, true); $sth = $this->dbPool->get('core')->con->prepare('SELECT `' . $this->dbPool->get('core')->prefix . 'hr_staff`.* FROM `' . $this->dbPool->get('core')->prefix . 'hr_staff` ' . $search . 'LIMIT ' . $offset . ',' . $limit); $sth->execute(); $result['list'] = $sth->fetchAll(); $sth = $this->dbPool->get('core')->con->prepare('SELECT FOUND_ROWS();'); $sth->execute(); $result['count'] = $sth->fetchAll()[0][0]; break; } return $result; }
/** * Get all accounts * * This function gets all accounts in a range * * @param array $filter Filter for search results * @param int $offset Offset for first account * @param int $limit Limit for results * * @return array * * @since 1.0.0 * @author Dennis Eichhorn <*****@*****.**> */ public function getList($filter = null, $offset = 0, $limit = 100) { $result = null; switch ($this->dbPool->get('core')->getType()) { case \phpOMS\DataStorage\Database\DatabaseType::MYSQL: $search = $this->dbPool->get('core')->generate_sql_filter($filter, true); $sth = $this->dbPool->get('core')->con->prepare('SELECT `' . $this->dbPool->get('core')->prefix . 'tasks`.*, `' . $this->dbPool->get('core')->prefix . 'tasks_element`.`forwarded` FROM `' . $this->dbPool->get('core')->prefix . 'tasks` LEFT JOIN `' . $this->dbPool->get('core')->prefix . 'tasks_element` ON `' . $this->dbPool->get('core')->prefix . 'tasks`.`TaskID` = `' . $this->dbPool->get('core')->prefix . 'tasks_element`.`task` AND `' . $this->dbPool->get('core')->prefix . 'tasks_element`.`forwarded` = 1 GROUP BY `' . $this->dbPool->get('core')->prefix . 'tasks`.`TaskID` ' . $search . 'LIMIT ' . $offset . ',' . $limit); $sth->execute(); $result['list'] = $sth->fetchAll(); $sth = $this->dbPool->get('core')->con->prepare('SELECT FOUND_ROWS();'); $sth->execute(); $result['count'] = $sth->fetchAll()[0][0]; break; } return $result; }
/** * Get all clients * * This function gets all accounts in a range * * @param array $filter Filter for search results * @param int $offset Offset for first account * @param int $limit Limit for results * * @return array * * @since 1.0.0 * @author Dennis Eichhorn <*****@*****.**> */ public function getList($filter = null, $offset = 0, $limit = 100) { $result = null; switch ($this->dbPool->get('core')->getType()) { case \phpOMS\DataStorage\Database\DatabaseType::MYSQL: $search = $this->dbPool->get('core')->generate_sql_filter($filter, true); // SQL_CALC_FOUND_ROWS $sth = $this->dbPool->get('core')->con->prepare('SELECT DISTINCT `' . $this->dbPool->get('core')->prefix . 'sales_client`.*, `' . $this->dbPool->get('core')->prefix . 'accounts_data`.`name1`, `' . $this->dbPool->get('core')->prefix . 'accounts_data`.`name2`, `' . $this->dbPool->get('core')->prefix . 'accounts_data`.`name3` FROM `' . $this->dbPool->get('core')->prefix . 'sales_client` LEFT JOIN `' . $this->dbPool->get('core')->prefix . 'accounts_data` ON `' . $this->dbPool->get('core')->prefix . 'sales_client`.`account` = `' . $this->dbPool->get('core')->prefix . 'accounts_data`.`account` GROUP BY `' . $this->dbPool->get('core')->prefix . 'sales_client`.`SalesClientID` ' . $search . 'LIMIT ' . $offset . ',' . $limit); $sth->execute(); $result['list'] = $sth->fetchAll(); $sth = $this->dbPool->get('core')->con->prepare('SELECT FOUND_ROWS();'); $sth->execute(); $result['count'] = $sth->fetchAll()[0][0]; break; } return $result; }