/**
* タスク新規追加(Ajax)
*/
public function postCreate(Request $request)
{
$this->isAjax($request);
$result = DB::transaction(function () use($request) {
// seqの番号取得
$selectSql = "\n\t\t\t\tSELECT\n\t\t\t\t\tMAX(seq) + 1 as maxSeq\n\t\t\t\tFROM\n\t\t\t\t\ttasks\n\t\t\t\tWHERE\n\t\t\t\t\tproject_id = ?\n\t\t\t";
$data = DB::select($selectSql, [$request->project_id]);
if ($data[0]->maxSeq != null) {
$seq = $data[0]->maxSeq;
} else {
$seq = 0;
}
// タスク新規追加
$task = Task::create($request->all());
$task->seq = $seq;
$task->save();
return $task;
});
return \Response::json($result);
}
