/** * Lists all Todo models. * @return mixed */ public function actionIndex() { $dataProvider = new ActiveDataProvider(['query' => Todo::find()]); return $this->render('index', ['dataProvider' => $dataProvider]); }
public function fooAction() { $list = Todo::find(); $this->view->todoList = $list; }
private function _indexList() { $userId = \Yii::$app->user->id; $key = $this->getParam('key', 1); $sort = $this->getParam('order'); $start = $this->getParam('start', 1); $pageSize = $this->getParam('length', 10); $columns = $this->getParam('columns'); switch ($key) { case 0: $startDate = $this->getParam('startDate', date('Y-m-d')); $endDate = $this->getParam('endDate', date('Y-m-d')); $andWhere = ['and', ['>=', 'todo_date', $startDate], ['<=', 'todo_date', $endDate]]; break; case 1: $andWhere = ['todo_date' => date('Y-m-d')]; break; case 2: $andWhere = ['todo_date' => date('Y-m-d', strtotime('-1 day'))]; break; case 3: $andWhere = ['>=', 'todo_date', date('Y-m-d', strtotime('this week'))]; break; case 4: $andWhere = ['and', ['>=', 'todo_date', date('Y-m-d', strtotime('last week'))], ['<', 'todo_date', date('Y-m-d', strtotime('this week'))]]; break; case 5: $andWhere = ['>=', 'todo_date', date('Y-m-01')]; break; case 6: $andWhere = ['and', ['>=', 'todo_date', date('Y-m-01', strtotime('-1 month'))], ['<', 'todo_date', date('Y-m-01')]]; break; case 7: $season = ceil(date('n') / 3); $andWhere = ['>=', 'todo_date', date('Y-m-d', mktime(0, 0, 0, $season * 3 - 3 + 1, 1, date('Y')))]; break; case 8: $andWhere = ['>=', 'todo_date', date('Y-01-01')]; break; case 9: $andWhere = ['or', ['todo_date' => ''], ['todo_date' => null]]; break; case 10: $andWhere = ['todo_status' => [Todo::STATUS_WAIT, Todo::STATUS_DOING]]; break; case 11: $andWhere = '1=1'; break; default: $andWhere = '1=1'; } $order = $columns[$sort[0]['column']]['name']; $asc = $sort[0]['dir'] == 'asc' ? SORT_ASC : SORT_DESC; $list = Todo::find()->where(['todo_account' => $userId])->andWhere($andWhere)->offset($start)->limit($pageSize)->orderBy([$order => $asc])->asArray()->all(); $total = Todo::find()->where(['todo_account' => $userId])->andWhere($andWhere)->count(); echo Json::encode(['recordsTotal' => $total, 'recordsFiltered' => $total, 'data' => $list]); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $todo = Todo::find($id); $todo->delete(); return redirect()->route('admin.todos.index')->with('message', 'Se ha eliminado ' . $todo->name . ' de forma correcta.'); }
public function todoMoveDown(Request $request) { $todoItem = Todo::find($request->input('todoId')); $currentPriority = intval($todoItem->priority); if (1 == intval($currentPriority)) { return "false"; } else { $newPriority = intval($currentPriority) - 1; $todoItem2 = Todo::where('priority', $newPriority)->first(); $todoItem2->priority = $currentPriority; $todoItem2->save(); $todoItem->priority = $newPriority; $todoItem->save(); return "true"; } }