/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$token = JWTAuth::getToken();
$user = JWTAuth::toUser($token);
$data['user'] = Auth::User();
$data['tasks'] = Task::with('priority', 'tags')->own()->get();
$data['priorities'] = Priority::all();
$data['tags'] = Tag::all();
return response()->json($data);
}
public function editTask($id)
{
if (Auth::check()) {
$task = Task::findorfail($id);
$discussions = Discussions::getDiscussionsForPost($id);
$users = User::orderBy('id', 'desc')->get();
$priorities = Priority::orderBy('id', 'asc')->get();
$colors = Color::orderBy('id', 'asc')->get();
$status = Status::orderBy('id', 'asc')->get();
$data = array('task' => $task, 'discussions' => $discussions, 'users' => $users, 'priorities' => $priorities, 'colors' => $colors, 'status' => $status);
return view('taskedit', $data);
} else {
return redirect('/')->withErrors('You must be authenticated to edit a task.');
}
}
/**
* View create detail feature
* @return [type] [description]
*/
public function createDetailFeature()
{
$featureprojects = FeatureProject::all();
$statusprojects = StatusProject::all();
$categoryfeatures = CategoryFeature::all();
$priorities = Priority::all();
$employees = Employee::all();
return view('manageproject.createdetailfeature', compact('featureprojects', 'statusprojects', 'categoryfeatures', 'priorities', 'employees'));
}
public function fetchAll()
{
return Priority::orderBy('id', 'asc')->get();
}
/**
* Update a new task: load date and forward to view
*
* @param Request $request, Task $task
* @return view
*/
public function update(Request $request, Task $task)
{
$categories = Category::where('is_note', '=', 0)->orderBy('seq')->get();
$priorities = Priority::All(['id', 'name']);
$stages = Stage::All(['id', 'name']);
$user = User::find($request->user()->id);
//get next id
$tasks = DB::table('tasks')->leftjoin('categories', 'tasks.category_id', '=', 'categories.id')->join('priorities', 'tasks.priority_id', '=', 'priorities.id')->join('stages', 'tasks.stage_id', '=', 'stages.id')->select('tasks.id as id')->where('user_id', '=', $request->user()->id);
//handle stages
$ses_stage_id = $request->session()->get('stage_id');
if ($ses_stage_id) {
$tasks->where('stage_id', '=', $ses_stage_id);
}
//handle categories
$ses_category_id = $request->session()->get('category_id');
if ($ses_category_id) {
$tasks->where('category_id', '=', $ses_category_id);
}
//handle search
$search = $request->session()->get('search');
if (strlen($search) > 0) {
$tasks->where(function ($query) use($search) {
$query->where('tasks.name', 'like', "%" . $search . "%")->orWhere('tasks.description', 'like', "%" . $search . "%");
});
}
//handle filters
$filter_deadline = $request->session()->get('filter_deadline');
if ($filter_deadline == 1) {
$tasks->where('deadline', '!=', '0000-00-00')->where('deadline', '<=', date('Y-m-d', time()));
}
//handle sort order
$order = $request->session()->get('order');
if (!$order) {
$order = 'priority_id';
}
//handle sort direction
$dir = $request->session()->get('dir');
if (!$dir) {
$dir = 'ASC';
}
$pagination_number = $request->session()->get('pagination_number');
$tasks = $tasks->orderBy('tasks.' . $order, $dir)->orderBy('deadline', 'ASC')->orderBy('tasks.name', 'ASC')->paginate($pagination_number);
$previous_id = 0;
$next_id = 0;
$counter = 0;
$found = false;
foreach ($tasks as $temp) {
if ($found) {
$next_id = $temp->id;
break;
}
if ($temp->id == $task->id) {
$found = true;
}
$counter++;
if (!$found) {
$previous_id = $temp->id;
}
}
return view('tasks.update', ['categories' => $categories, 'priorities' => $priorities, 'stages' => $stages, 'task' => $task, 'category_id' => False, 'previous_id' => $previous_id, 'next_id' => $next_id, 'counter' => $counter, 'total' => count($tasks), 'page' => $request->session()->get('page'), 'filetab' => $request->filetab])->withTask($task);
}
