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;
}
}
}
