function get($criteria = null, $order = null)
{
$sql = "SELECT tasks.*, CONCAT(users.first_name, ' ', users.last_name) AS assigned_to_name\n FROM tasks\n LEFT JOIN users ON users.id = tasks.assigned_to";
if (isset($criteria) && is_numeric($criteria)) {
$sql .= " WHERE tasks.id = {$criteria}";
$task = parent::get_one($sql);
$this->update_status();
return $task;
} else {
$sql = $this->add_criteria($sql, $criteria);
$sql = $this->modify_sql_for_user_type($sql);
$sql = $this->add_order_by($sql, $order);
$tasks = parent::get($sql);
foreach ($tasks as &$task) {
//create the invoice
$task_object = new Task($task);
//todo: i don't think this makes any sense because the invoice status will already be updated when I create the invoice using new Invoice
//store the current task status as it exists in the database
$old_status = $task_object->status_text;
//update the task status
$task_object->update_status();
//if the old status and the new status do not match, then we need to save this task back to the database.
if ($old_status != (string) $task_object->status_text) {
//todo:make sure this isn't saving each time
$task_object->save(false);
}
//we need to add the status text back the task array, since we're sending the array to the client,
//not the object
$task['status_text'] = $task_object->status_text;
}
return $tasks;
}
}
public function after()
{
echo "after\n";
$insert = 0;
// 判断是否插入表
$class_name = get_class($this);
$type = str_replace('Event', '', $class_name);
$task = new Task();
if ($this->event_rs['err_no'] > 0) {
// 代表错误
$task->is_success = 0;
$this->event_rs['class'] = $this->class;
$this->event_rs['param'] = $this->param;
if ($this->retry_cnt >= 3) {
$insert = 1;
}
} else {
$task->is_success = 1;
$insert = 1;
}
// 成功则入库 第一次失败则不入库 第三次失败才一起入库
$task->create_time = time();
$task->retry_cnt = $this->retry_cnt;
$task->event = $type;
$task->param = json_encode($this->param);
if ($insert > 0) {
$task->save();
}
$this->event_rs['retry_cnt'] = $this->retry_cnt;
}
/**
* Store a newly created resource in storage.
* POST /task
*
* @return Response
*/
public function store()
{
// Input::merge(array_map('trim', Input::all()));
$input = Input::all();
$validation = Validator::make($input, Task::$rules);
if ($validation->passes()) {
$task = new Task();
$task->task = strtoupper(Input::get('task'));
$task->description = strtoupper(Input::get('description'));
$task->save();
$id = $task->id;
$gettime = time() - 14400;
$datetime_now = date("H:i:s", $gettime);
$task_approver = Input::get('task_approver');
$task_receiver = Input::get('task_receiver');
foreach ($task_approver as $row_approver) {
DB::table('task_approver')->insert(array(['task_id' => $id, 'user_id' => $row_approver, 'datetime_created' => date('Y-m-d') . $datetime_now]));
}
foreach ($task_receiver as $row_receiver) {
DB::table('task_receiver')->insert(array(['task_id' => $id, 'user_id' => $row_receiver, 'datetime_created' => date('Y-m-d') . $datetime_now]));
}
return Redirect::route('task.index')->with('class', 'success')->with('message', 'Record successfully created.');
} else {
return Redirect::route('task.create')->withInput()->withErrors($validation)->with('class', 'error')->with('message', 'There were validation error.');
}
}
public function actionCreate()
{
switch ($_GET['model']) {
case 'user':
$model = new User('create');
break;
case 'task':
$model = new Task();
break;
default:
$this->_sendResponse(501, Yii::t('tasklist', 'Mode "create" is not implemented for model "{model}"', array('{model}' => $_GET['model'])));
exit;
}
foreach ($_POST as $var => $value) {
if ($model->hasAttribute($var)) {
$model->{$var} = $value;
} else {
$this->_sendResponse(500, Yii::t('tasklist', 'Parameter "{param}" is not allowed', array('{param}' => $var)));
}
}
if ($model->save()) {
$this->_sendResponse(200, CJSON::encode($model->attributes));
} else {
$this->_sendResponse(500, CJSON::encode($model->errors));
}
}
public function testKanbanItemSave()
{
$accounts = Account::getByName('anAccount');
$user = UserTestHelper::createBasicUser('Billy');
$task = new Task();
$task->name = 'MyTask';
$task->owner = $user;
$task->requestedByUser = $user;
$task->description = 'my test description';
$taskCheckListItem = new TaskCheckListItem();
$taskCheckListItem->name = 'Test Check List Item';
$task->checkListItems->add($taskCheckListItem);
$task->activityItems->add($accounts[0]);
$task->status = Task::STATUS_IN_PROGRESS;
$this->assertTrue($task->save());
$this->assertEquals(1, KanbanItem::getCount());
$id = $task->id;
unset($task);
$task = Task::getById($id);
//KanbanItem is created after saving Task
$kanbanItems = KanbanItem::getAll();
$this->assertCount(1, $kanbanItems);
$kanbanItem = $kanbanItems[0];
$this->assertEquals(KanbanItem::TYPE_IN_PROGRESS, $kanbanItem->type);
}
public static function store()
{
self::check_logged_in();
$params = $_POST;
if (empty($_POST['projects'])) {
$errors[] = 'Select at least one project!';
$projects = '';
} else {
$projects = $_POST['projects'];
}
$attributes = array('description' => $params['description'], 'priority' => $params['priority'], 'status' => 0, 'projectids' => $projects);
$task = new Task($attributes);
//$errors = $task->errors(); // Deprecated: Switched to valitron. Calls all validators
$errors = $task->validateTask();
// Valitron takes care of putting all errors in one array
//Kint::dump($params); // Debug, comment out Redirect if used!
//Kint::dump($task);
if (count($errors) == 0) {
$task->save();
// Tell task-model to save this object to DB
foreach ($projects as $project) {
Project::addTask($task->id, $project);
// We don't know the id before it is saved!
Project::updateCount($project);
}
Redirect::to('/task/' . $task->id, array('message' => 'Task added to database!'));
} else {
Kint::dump($errors);
$projects = Project::all();
Kint::dump($attributes);
Kint::dump($projects);
View::make('task/new.html', array('errors' => $errors, 'attributes' => $attributes, 'projects' => $projects));
}
}
function uncomplete_task()
{
$id = $this->input->post('id');
$user = new User();
$task = new Task();
if ($task->where('user_id', $this->dx_auth->get_user_id())->where('id', $id)->count() == 0) {
return;
}
$task->get_by_id($id);
$task->completed = 0;
$task->save();
$docket = new Docket();
$docket->get_by_id($task->docket_id);
$task->clear();
if ($task->where('docket_id', $docket->id)->where('completed', 0)->count() == 0) {
$docket->completed = 1;
$docket->save();
} else {
$docket->completed = 0;
$docket->save();
}
$gold = $this->treasure->decrease($this->dx_auth->get_user_id());
$task->clear();
$task->get_by_id($id);
$result = array('id' => $task->id, 'name' => $task->name, 'docket_id' => $docket->id, 'due' => $task->due, 'gold' => $gold);
echo json_encode($result);
}
public static function store()
{
parent::check_logged_in();
// POST-pyynnön muuttujat sijaitsevat $_POST nimisessä assosiaatiolistassa
$params = $_POST;
// Alustetaan uusi task-luokan olion käyttäjän syöttämillä arvoilla
/*$task = new task(array(
'name' => $params['name'],
'description' => $params['description'],
'publisher' => $params['publisher'],
'published' => $params['published']
));*/
$params['user_id'] = parent::get_user_logged_in()->id;
$task = new Task($params);
$errors = $task->validate();
if (!$errors) {
// Kutsutaan alustamamme olion save metodia, joka tallentaa olion tietokantaan
$task->save();
// Ohjataan käyttäjä lisäyksen jälkeen pelin esittelysivulle
//Redirect::to('/task/' . $task->id, array('message' => 'Task has been added!'));
Redirect::to('/task', array('message' => 'Task has been added!'));
} else {
View::make('task/new.html', array('errors' => $errors, 'attributes' => $params, 'title' => 'new task'));
}
}
public function addTask()
{
if ($_POST) {
// Lets start validation
// validate input
$rules = array('name' => 'required|max:50', 'description' => 'required', 'didyouknow' => 'required', 'reference' => 'required');
$validation = Validator::make(Input::all(), $rules);
if ($validation->fails()) {
Input::flash();
return Redirect::back()->withInput()->withErrors($validation);
}
$task = new Task();
$task->name = Input::get('name');
$task->description = Input::get('description');
$task->didyouknow = Input::get('didyouknow');
$task->reference = Input::get('reference');
$task->author = Input::get('taskauthor');
$task->createdby = 0;
$task->suspended = 0;
$task->number = 0;
$task->save();
return Redirect::to('tasks/manage');
}
return View::make('task.add');
}
/**
* Show the form for creating a new resource.
* GET /tasks/create
*
* @return Response
*/
public function create()
{
// Rules
$rules = array('weight' => 'integer|between:1,5', 'name' => 'required');
// Custom messages
$messages = array('between' => 'The :attribute must be between :min - :max.', 'integer' => ':attribute must be a number');
// Create validation
$validator = Validator::make(Input::all(), $rules, $messages);
// Check validation
if ($validator->fails()) {
return Redirect::back()->withErrors($validator)->withInput();
}
// Insert the task to database
$task = new Task();
$task->project_id = Input::get('projectId');
$task->user_id = Auth::id();
$task->name = Input::get('name');
$task->weight = Input::get('weight');
if (!Input::get('weight')) {
$task->weight = 1;
}
$task->state = "incomplete";
$task->save();
// Increase the users overall task count
$user = User::find(Auth::id());
$user->tasks_created = $user->tasks_created + 1;
$user->save();
return Redirect::back()->with('success', Input::get('name') . " has been created.");
}
public function store()
{
$task = new Task(Input::all());
if (!$task->save()) {
return Redirect::back()->withInput()->withErrors($task->getErrors());
}
return Redirect::home();
}
/**
* [addPostTask description]
*/
public function store()
{
if (Input::has('task_label')) {
$task = new Task();
$task->label = Input::get('task_label');
$task->save();
}
return Redirect::back();
}
/**
* 開始寫入資料
*/
private function GetNewSEOState()
{
$taskModel = new Task();
$date = new DateTime();
$taskModel->attributes = array('date' => $date->format("Y-m-d H:i:s"));
$taskModel->save();
$taskID = $taskModel->getPrimaryKey();
$this->GetSEOState($taskID);
}
/**
* Store a newly created resource in storage.
* POST /tasks
*
* @param Project $project
* @return Response
*/
public function store(Project $project)
{
$input = Input::all();
$input['project_id'] = $project->id;
$task = new Task($input);
if ($task->save()) {
return Redirect::route('projects.show', $project->slug)->with('message', 'Task created.');
} else {
return Redirect::route('projects.tasks.create', $project->slug)->withInput()->withErrors($task->errors());
}
}
public function run()
{
$task1 = new Task();
$task1->description = 'Do something';
$task1->list_id = 1;
$task1->save();
$task2 = new Task();
$task2->description = 'Do something else';
$task2->list_id = 1;
$task2->save();
}
function test_getDescription()
{
//Arrange
$description = "Wash the dog";
$test_task = new Task($description);
$test_task->save();
//Act
$result = $test_task->getDescription();
//Assert
$this->assertEquals("Wash the dog", $result);
}
function createTask()
{
$validator = Validator::make(Input::all(), ['name' => 'required|max:255']);
if ($validator->fails()) {
return redirect('/')->withInput()->withErrors($validator);
}
$task = new Task();
$task->name = Input::get('name');
$task->save();
return Redirect::to('/');
}
public function testCreateChecklistItemViewForTaskUsingAjax()
{
$super = $this->logoutCurrentUserLoginNewUserAndGetByUsername('super');
$task = new Task();
$task->name = 'aTest1';
$nowStamp = DateTimeUtil::convertTimestampToDbFormatDateTime(time());
$this->assertTrue($task->save());
$this->setGetArray(array('id' => $task->id, 'uniquePageId' => 'TaskCheckItemInlineEditForModelView'));
$content = $this->runControllerWithNoExceptionsAndGetContent('tasks/taskCheckItems/inlineCreateTaskCheckItemFromAjax', false);
$this->assertContains('TaskCheckListItem_name', $content);
}
function test_find()
{
$description = "Wash the dog";
$description2 = "Water the lawn";
$test_Task = new Task($description);
$test_Task->save();
$test_Task2 = new Task($description2);
$test_Task2->save();
$id = $test_Task->getId();
$result = Task::find($id);
$this->assertEquals($test_Task, $result);
}
public function saveTask()
{
$taskName = Input::get('name');
$taskDate = Input::get('due_date');
$taskDone = false;
$task = new Task();
$task->name = $taskName;
$task->due_date = $taskDate;
$task->done = $taskDone;
$task->save();
return Response::json($task);
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param PropelPDO $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(PropelPDO $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their coresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aTaskRelatedByTaskId !== null) {
if ($this->aTaskRelatedByTaskId->isModified() || $this->aTaskRelatedByTaskId->isNew()) {
$affectedRows += $this->aTaskRelatedByTaskId->save($con);
}
$this->setTaskRelatedByTaskId($this->aTaskRelatedByTaskId);
}
if ($this->aTaskRelatedByOverrideTaskId !== null) {
if ($this->aTaskRelatedByOverrideTaskId->isModified() || $this->aTaskRelatedByOverrideTaskId->isNew()) {
$affectedRows += $this->aTaskRelatedByOverrideTaskId->save($con);
}
$this->setTaskRelatedByOverrideTaskId($this->aTaskRelatedByOverrideTaskId);
}
if ($this->aUser !== null) {
if ($this->aUser->isModified() || $this->aUser->isNew()) {
$affectedRows += $this->aUser->save($con);
}
$this->setUser($this->aUser);
}
if ($this->isNew()) {
$this->modifiedColumns[] = OverrideTaskPeer::ID;
}
// If this object has been modified, then save it to the database.
if ($this->isModified()) {
if ($this->isNew()) {
$pk = OverrideTaskPeer::doInsert($this, $con);
$affectedRows += 1;
// we are assuming that there is only 1 row per doInsert() which
// should always be true here (even though technically
// BasePeer::doInsert() can insert multiple rows).
$this->setId($pk);
//[IMV] update autoincrement primary key
$this->setNew(false);
} else {
$affectedRows += OverrideTaskPeer::doUpdate($this, $con);
}
$this->resetModified();
// [HL] After being saved an object is no longer 'modified'
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
$task = new Task();
$task->unguard();
$task->fill(Input::only(['name', 'user_id', 'description', 'status']));
$task->deadline = new DateTime(Input::get('deadline'));
if ($task->validate()) {
$task->save();
} else {
return View::make('tasks.edit', ['task' => $task])->withErrors($task->validator());
}
return Redirect::to(route('tasks.index'))->with('message', ['content' => 'Taak met succes aangemaakt!', 'class' => 'success']);
}
public function postTask(Request $request)
{
if (Auth::user()) {
$id = Auth::user()->id;
$tache = new Task();
$tache->user_id = $id;
$tache->name = $request->input('tache');
$tache->descriptionTache = $request->input('description');
$tache->fini = "0";
$tache->save();
return redirect('/')->with('flash_message', 'Ajouté avec succés');
}
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Task();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Task'])) {
$model->attributes = $_POST['Task'];
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->id));
}
}
$this->render('create', array('model' => $model));
}
public function testInlineCreateTaskCheckItemSave()
{
$this->logoutCurrentUserLoginNewUserAndGetByUsername('super');
$task = new Task();
$task->name = 'aTest';
$this->assertTrue($task->save());
$this->setGetArray(array('relatedModelId' => $task->id, 'relatedModelClassName' => 'Task', 'relatedModelRelationName' => 'checkListItems', 'url' => Yii::app()->createUrl('tasks/taskCheckItems/inlineCreateTaskCheckItemFromAjax', array('id' => $task->id, 'uniquePageId' => 'TaskCheckItemInlineEditForModelView'))));
$this->setPostArray(array('TaskCheckListItem' => array('name' => 'Test Item'), 'ajax' => 'task-check-item-inline-edit-form'));
$this->runControllerWithExitExceptionAndGetContent('tasks/taskCheckItems/inlineCreateTaskCheckItemSave', true);
$this->setGetArray(array('relatedModelId' => $task->id, 'relatedModelClassName' => 'Task', 'relatedModelRelationName' => 'checkListItems', 'url' => Yii::app()->createUrl('tasks/taskCheckItems/inlineCreateTaskCheckItemFromAjax', array('id' => $task->id, 'uniquePageId' => 'TaskCheckItemInlineEditForModelView'))));
$this->setPostArray(array('TaskCheckListItem' => array('name' => 'Test Item')));
$this->runControllerWithNoExceptionsAndGetContent('tasks/taskCheckItems/inlineCreateTaskCheckItemSave', true);
}
public function storage()
{
$user_id = 2;
if (Task::where('user_id', $user_id)->count()) {
$task = Task::where('user_id', $user_id)->first();
} else {
$task = new Task();
}
$task->user_id = $user_id;
$task->tasks = json_encode($_POST);
$task->save();
exit;
}
public function executeUpdate()
{
$jira = new sfJiraPlugin($this->getUser()->getProfile()->getJiraLogin(), $this->getUser()->getProfile()->getJiraPassword());
$aProjects = $jira->getProjects();
foreach ($aProjects as $project) {
#var_dump( $project );
$c = new Criteria();
$c->add(ProjectPeer::USER_ID, $this->getUser()->getProfile()->getId());
$c->add(ProjectPeer::KEY, $project->key);
$p = ProjectPeer::doSelectOne($c);
$c = new Criteria();
$c->add(UserPeer::JIRA_LOGIN, $project->lead);
$u = UserPeer::doSelectOne($c);
if (empty($p)) {
$p = new Project();
$p->setKey($project->key);
$p->setLeadId(!empty($u) ? $u->getId() : null);
$p->setUserId($this->getUser()->getProfile()->getId());
$p->setName($project->name);
$p->setUpdated(date('r'));
$p->save();
}
$issues = $jira->getIssuesForProject($p->getKey());
foreach ($issues as $issue) {
#die($p->getKey());
if ($issue->assignee == $this->getUser()->getProfile()->getJiraLogin()) {
$c = new Criteria();
$c->add(TaskPeer::KEY, $issue->key);
$t = TaskPeer::doSelectOne($c);
if (empty($t)) {
$c = new Criteria();
$c->add(UserPeer::JIRA_LOGIN, $issue->reporter);
$u = UserPeer::doSelectOne($c);
$t = new Task();
$t->setProjectId($p->getId());
$t->setTitle($issue->summary);
$t->setDescription($issue->description);
$t->setKey($issue->key);
$t->setUpdated(date('r'));
$t->setStatusId($issue->status);
$t->setPriorityId($issue->priority);
$t->setLeadId(!empty($u) ? $u->getId() : null);
$t->save();
}
}
}
}
$this->redirect('@homepage');
return sfView::NONE;
}
public function saveCreate()
{
$data = Input::all();
$rules = array('title' => 'required', 'body' => 'required');
$validator = Validator::make($data, $rules);
if ($validator->passes()) {
$task = new Task();
$task->title = Input::get('title');
$task->body = Input::get('body');
$task->save();
return Redirect::action('TasksController@home');
}
return Redirect::action('TasksController@create');
}
function test_deleteAll()
{
//Arrange
$description = "Wash the dog";
$description2 = "Water the lawn";
$test_Task = new Task($description);
$test_Task->save();
$test_Task2 = new Task($description2);
$test_Task2->save();
//Act
Task::deleteAll();
//Assert
$result = Task::getAll();
$this->assertEquals([], $result);
}
public static function createTaskWithOwnerAndRelatedAccount($name, $owner, $account)
{
$dueStamp = DateTimeUtil::convertTimestampToDbFormatDateTime(time() + 10000);
$completedStamp = DateTimeUtil::convertTimestampToDbFormatDateTime(time() + 9000);
$task = new Task();
$task->name = $name;
$task->owner = $owner;
$task->dueDateTime = $dueStamp;
$task->completedDateTime = $completedStamp;
$task->description = 'my test description';
$task->activityItems->add($account);
$saved = $task->save();
assert('$saved');
return $task;
}
