public function destroy($id) { $issues = Issue::where('registration_id', '=', $id)->delete(); $placements = Placement::where('registration_id', '=', $id)->delete(); $receivables = Receivable::where('registration_id', '=', $id)->get(); foreach ($receivables as $receivable) { $installments = Installment::where('receivable_id', '=', $receivable->id)->get(); foreach ($installments as $installment) { $earnings = Earning::where('earnable_type', '=', 'Installment')->where('earnable_id', '=', $installment->id)->get(); foreach ($earnings as $earning) { $earning->delete(); } $installment->delete(); } $earnings = Earning::where('earnable_type', '=', 'Receivable')->where('earnable_id', '=', $receivable->id)->delete(); $reductions = Reduction::where('receivable_id', '=', $receivable->id)->delete(); $receivable->delete(); } Registration::destroy($id); Session::flash('message', 'Sukses membatalkan Pendaftaran!, Semua Data terkait pendaftaran ini telah dihapus!'); }
public function show($id) { try { $iteration = Iterations::findOrFail($id); $iterations = Iterations::where('projectid', '=', $iteration->projectid)->get(); $project = Project::findOrFail($iteration->projectid); $issues = Issue::where('iterationid', '=', $id)->get(); //$issues = $iteration->issues; $countIssues = sizeof($issues); $categories = Category::all(); $idCategory = 0; $totalPoints = $issues->sum('points'); $materiales = Material::all(); $personal = PersonalType::all(); $team = Teams::where('projectid', '=', $project->id)->get()->first(); $members = DB::table('memberof')->where('teamid', '=', $team->id)->get(); $hasmembers = sizeof($members) > 0 ? true : false; $users = array(); foreach ($members as $member) { $users[] = User::findOrFail($member->usersid); echo $hasmembers; } $this->layout->content = View::make('layouts.iterations.show')->with('iteration', $iteration)->with('iterations', $iterations)->with('issues', $issues)->with('categories', $categories)->with('idCategory', $idCategory)->with('countIssues', $countIssues)->with('totalPoints', $totalPoints)->with('project', $project)->with('materiales', $materiales)->with('personal', $personal)->with('hasmembers', $hasmembers)->with('members', $members)->with('users', $users)->with('message', ''); } catch (Illuminate\Database\Eloquent\ModelNotFoundException $e) { return Redirect::to('/projects/')->with('message', 'Error al crear la iteración'); } }
public function studentPerGenerationFilter($id) { $generation_id = $id; $generation = Generation::find($generation_id); $generations = Generation::all(); $issues = Issue::where('project_id', '=', Auth::user()->curr_project_id)->where('generation_id', '=', $generation_id)->get(); $menu = 'report'; return View::make('reports.studentpergeneration', compact('generations', 'generation', 'issues', 'menu')); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($string) { $book_list = Books::select('book_id', 'title', 'author', 'description', 'category_id')->where('title', 'like', '%' . $string . '%')->orWhere('author', 'like', '%' . $string . '%')->orderBy('book_id'); $book_list = $book_list->get(); foreach ($book_list as $book) { $conditions = array('book_id' => $book->book_id, 'available_status' => 1); $count = Issue::where($conditions)->count(); $book->avaliability = $count > 0 ? true : false; } return $book_list; }
public function suggestIssue($course_id) { $course = Course::find($course_id); $program = Program::find($course->program->id); $year = date('y'); $month = date('m'); $counter = Issue::where('project_id', '=', Auth::user()->curr_project_id)->count(); $counter += 1; $issue = substr($program->name, 0, 1) . $year . $month . str_pad($counter, 5, "0", STR_PAD_LEFT); return Response::json(array('issue' => $issue)); }
public function newIssue() { $issue_name = Input::get('issue_name'); $already_created = Issue::where('issue_name', 'like', '%' . $issue_name . '%'); $return = array('1' => '1', '2' => '2'); if (!($already_created->count() > 0)) { if (isset($issue_name)) { $issue = Issue::create(array('issue_name' => $issue_name, 'created_by' => Auth::user()->id)); $issue->save(); return null; } } else { return Response::json(array('issue_name' => $already_created->first()->issue_name)); } //return Response::json($return); }
public function showDashboard() { $menu = ''; $_301 = Issue::where('generation_id', '=', 1)->where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->count(); $_201 = Issue::where('generation_id', '=', 2)->where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->count(); $_101 = Issue::where('generation_id', '=', 3)->where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->count(); $_302 = Issue::where('generation_id', '=', 4)->where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->count(); $_202 = Issue::where('generation_id', '=', 5)->where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->count(); $_102 = Issue::where('generation_id', '=', 6)->where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->count(); $_603 = Issue::where('generation_id', '=', 7)->where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->count(); $_503 = Issue::where('generation_id', '=', 8)->where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->count(); $_403 = Issue::where('generation_id', '=', 9)->where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->count(); $last_month_registrations = Registration::where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->where(DB::raw('month(registration_date)'), '<>', date('m'))->where(DB::raw('year(registration_date)'), '=', date('Y'))->count(); $curr_month_registrations = Registration::where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->where(DB::raw('month(registration_date)'), '=', date('m'))->where(DB::raw('year(registration_date)'), '=', date('Y'))->count(); $movement_registrations = Registration::where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->where('classification_id', '=', 10)->count(); $curr_active_students = Placement::where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->where('active', '=', 1)->count(); $curr_do_students = Resign::where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->where('classification_id', '=', 13)->count(); $curr_resign_students = Resign::where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->where('classification_id', '=', 14)->count(); $curr_relocate_students = Resign::where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->where('classification_id', '=', 15)->count(); $courses = Course::where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->get(); return View::make('dashboard.home', compact('_301', '_201', '_101', '_302', '_202', '_102', '_603', '_503', '_403', 'last_month_registrations', 'curr_month_registrations', 'movement_registrations', 'curr_active_students', 'curr_do_students', 'curr_resign_students', 'curr_relocate_students', 'courses', 'menu')); }
public function search() { $search_term = Input::get('search_term'); if (isset($search_term) && $search_term != '') { $search_query = '%' . $search_term . '%'; $politicians = Politician::where('full_name', 'like', $search_query)->orWhere('party', 'like', $search_query)->orWhere('state', 'like', $search_query)->orWhere('city', 'like', $search_query)->orWhere('office', 'like', $search_query)->orWhere('sex', 'like', $search_query)->orWhere('bio', 'like', $search_query)->orWhere('district', 'like', $search_query)->get(); if ($politicians->count() == 0) { $politicians = null; } $users = User::where('username', 'like', $search_query)->orWhere('first_name', 'like', $search_query)->orWhere('last_name', 'like', $search_query)->orWhere('email', 'like', $search_query)->orWhere('party', 'like', $search_query)->orWhere('state', 'like', $search_query)->orWhere('city', 'like', $search_query)->get(); if ($users->count() == 0) { $users = null; } $issue = Issue::where('issue_name', '=', $search_term)->first(); //don't want to repeat same articles in issue and in news. //don't want to do unnescesarry google news calls either //either news or issues if ($issue == null) { $news = $this->gNews($search_term); } else { $news = null; } $found = !($issue == null && $politicians == null && $news == null && $users == null); $user_id = Auth::check() ? Auth::user()->id : 0; //we're saving search attempts for study later. who searches and wether results are given. $search = Search::create(array('search_term' => $search_term, 'found' => $found, 'user_id' => $user_id)); $search->save(); } else { $politicians = null; $issue = null; $news = null; $users = null; } return View::make('results')->with('politicians', $politicians)->with('news', $news)->with('users', $users)->with('issue', $issue); }
public function searchIssues($id) { $iteration = Iterations::findOrFail($id); $aux = Issue::where('iterationid', '=', $id)->get(); return $aux; }
public function index() { $issues = Issue::where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->orderBy('generation_id', 'asc')->get(); $menu = 'student'; return View::make('students.index', compact('issues', 'menu')); }
public function iterationSummary2($id) { $iteration = Iterations::findOrFail($id); $issues = Issue::where('iterationid', '=', $iteration->id)->get(); $tasksId = array(); foreach ($issues as $issue) { $tasksId[] = $issue->id; } $tasks = Task::whereIn('issueid', $tasksId)->get(); $countTODO = 0; $countDOING = 0; $countDONE = 0; foreach ($tasks as $task) { switch ($task->scrumid) { case 1: $countTODO++; break; case 2: $countDOING++; break; case 3: $countDONE++; break; } } }