/**
* Loads step data from the database into the object
*
* @param int $id
* @return boolean
*/
private function load($id)
{
$query = new \TaskerMAN\Core\DBQuery("SELECT `steps`.*,\r\n\t\t\t(\r\n\t\t\t\tSELECT `assignee_uid`\r\n\t\t\t\tFROM `tasks`\r\n\t\t\t\tWHERE `id` = `steps`.`task_id`\r\n\t\t\t) AS `assignee_uid`\r\n\t\t\tFROM `steps`\r\n\t\t\tWHERE `steps`.`id` = ?\r\n\t\t\tLIMIT 1\r\n\t\t");
$query->execute($id);
if ($query->rowCount() == 0) {
return false;
}
$fetch = $query->row();
$this->id = $id;
$this->task_id = $fetch['task_id'];
$this->assignee_uid = $fetch['assignee_uid'];
$this->title = $fetch['title'];
$this->comment = $fetch['comment'];
return true;
}
/**
* Loads task details from the database into the object
*
* @param int $id
* @return boolean
*/
private function load($id)
{
$query = new \TaskerMAN\Core\DBQuery("SELECT `tasks`.*,\r\n\t\t\t`users_assignee`.`name` AS `assignee_name`,\r\n\t\t\t`users_created`.`name` AS `created_name`\r\n\t\t\t\r\n\t\t\tFROM `tasks`\r\n\r\n\t\t\tJOIN `users` AS `users_assignee` ON `users_assignee`.`id` = `tasks`.`assignee_uid`\r\n\t\t\tJOIN `users` AS `users_created` ON `users_created`.`id` = `tasks`.`created_uid`\r\n\r\n\t\t\tWHERE `tasks`.`id` = ?\r\n\t\t\tLIMIT 1\r\n\t\t");
$query->execute($id);
if ($query->rowCount() == 0) {
return false;
}
$fetch = $query->row();
$this->id = $fetch['id'];
$this->created_uid = $fetch['created_uid'];
$this->created_name = $fetch['created_name'];
$this->created_time = $fetch['created_time'];
$this->assignee_uid = $fetch['assignee_uid'];
$this->assignee_name = $fetch['assignee_name'];
$this->due_by = $fetch['due_by'];
$this->completed_time = $fetch['completed_time'];
$this->status = $fetch['status'];
$this->title = $fetch['title'];
}
/**
* Creates a new user. Returns false if error, or the new user's id if success
*
* @param string $email
* @param string $name
* @param string $password
* @param boolean $admin
* @return mixed
* @throws UserManagementException
*/
public static function create($email, $name, $password, $admin = false)
{
// Check if email is valid
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
throw new UserManagementException('Invalid email ' . $email);
return false;
}
// Validate password
if (!self::validatePassword($password)) {
return false;
}
// Validate username
if (empty($name) || strlen($name) > 50) {
throw new UserManagementException('Name cannot be empty, and no more than 50 characters');
return false;
}
// Check if user with this email already exists
$query = new \TaskerMAN\Core\DBQuery("SELECT `email`\r\n\t\t\tFROM `users`\r\n\t\t\tWHERE `email` = ?\r\n\t\t\tLIMIT 1\r\n\t\t");
$query->execute($email);
if ($query->rowCount() > 0) {
throw new UserManagementException('User with email ' . $email . ' already exists');
return false;
}
// Hash password
$password = password_hash($password, PASSWORD_DEFAULT);
// Generate API Token
$api_token = API::generateAPIToken();
// Store user
$query = new \TaskerMAN\Core\DBQuery("INSERT INTO `users`\r\n\t\t\t(`email`, `name`, `password`, `admin`, `api_token`)\r\n\t\t\tVALUES\r\n\t\t\t(:email, :name, :password, :admin, :api_token)\r\n\t\t");
$query->bindValue(':email', $email);
$query->bindValue(':name', $name);
$query->bindValue(':password', $password);
$query->bindValue(':admin', (int) $admin);
$query->bindValue(':api_token', $api_token);
$query->execute();
return (int) $query->lastInsertID();
}
/**
* Returns the API token for a given user id
*
* @param int user id
* @return string API Token
*/
public static function getUserAPIToken($uid)
{
$query = new \TaskerMAN\Core\DBQuery("SELECT `api_token`\r\n\t\t\tFROM `users`\r\n\t\t\tWHERE `id` = ?\r\n\t\t\tLIMIT 1\r\n\t\t");
$query->execute($uid);
if ($query->rowCount() < 1) {
return false;
}
$fetch = $query->row();
return $fetch['api_token'];
}
