OLAS/app/controllers/ProgramsController.php

<?php

class ProgramsController extends \BaseController
{

  /**
   * Shows a particular program
   */

  public function show($id)
  {

    $program = Program::find($id);
    $title= $program->school->name.': '.$program->name;
    $program_courses = $program->courses;
//     $outcomes = Outcome::orderBy('name', 'asc')->get();
    $schools = School::all();
//     $outcomeCount = Outcome::all()->count();

    $selected_semesters = Semester::find(Session::get('semesters_ids'));

	$level=$program->is_graduate;
	$min_start="9000-01-01 00:00:00";
	$max_end="1000-01-01 00:00:00";
	foreach($selected_semesters as $semester)
	{
		if($min_start>$semester->start)
		{
			$min_start=$semester->start;
		}
		if($max_end<$semester->end)
		{
			$max_end=$semester->end;
		}
	}
	$outcomes = Outcome::where(function($query) use ($min_start)
							   {
									$query->where('deactivation_date', '>=', $min_start)
										  ->orWhere('deactivation_date', null);
							   })
						->where('activation_date', '<=', $max_end)
						->where(function($query2) use ($level)
								{
									$query2->where("level", $level+1)
										   ->orWhere("level",3);
								})
						->orderBy('name', 'ASC')
						->get();
	$outcomeCount = Outcome::where(function($query) use ($min_start)
								   {
										$query->where('deactivation_date', '>=', $min_start)
											  ->orWhere('deactivation_date', null);
									})
						->where('activation_date', '<=', $max_end)
						->where(function($query2) use ($level)
									{
										$query2->where("level",$level+1)
											   ->orWhere("level",3);
									})
							->count();

	foreach($outcomes as $outcome)
	{
		$outcomes_attempted[$outcome->id]=$program->attempted_outcome($outcome->id, $selected_semesters);
		if($outcomes_attempted[$outcome->id])$outcomes_achieved[$outcome->id]=$program->achieved_outcome($outcome->id, $selected_semesters);
	}
	
	foreach($outcomes as $outcome)
	{
		$assessed_courses[$outcome->id]=DB::table('activity_criterion')
	    	->join('activities', 'activity_criterion.activity_id', '=', 'activities.id')
	    	->join('courses', 'activities.course_id', '=', 'courses.id')
	    	->join('programs', 'programs.id', '=', 'courses.program_id')
	    	->join('criterion_objective_outcome', 'criterion_objective_outcome.criterion_id', '=', 'activity_criterion.criterion_id')
	    	->where('criterion_objective_outcome.outcome_id','=',$outcome->id)
	    	->where('programs.id','=',$program->id)
	    	->where('courses.semester_id','=',$semester)
	    	->count(DB::raw('DISTINCT courses.id'))
			;	    	
	}
	$assessed_courses_count=array_sum($assessed_courses);
    /**
     * List of grouped courses (grouped sections)
     */
	
    $grouped_courses = Course::
      select(DB::raw('name, code, number, max(outcomes_attempted) as outcomes_attempted, semester_id, program_id'))
      ->with('semester')
      ->with('program')
      ->where('program_id', $program->id)
      ->whereIn('semester_id', Session::get('semesters_ids'))
      ->groupBy(array('code', 'number', 'semester_id'))
      ->orderBy('code')
      ->orderBy('number')
      ->orderBy('semester_id')
      ->get();

    // Program contact information
    $users = User::
        select('users.*')
        ->leftJoin('program_user', 'users.id', '=', 'program_user.user_id')
        ->where(function($query) use($program)
        {
            $query
                ->where('school_id', $program->school_id)
                ->where('role', 2);
        })
        ->orWhere(function($query) use($program)
        {
            $query
                ->where('role', 3)
                ->where('program_id', $program->id);
        })
        ->orWhere(function($query) use($program)
        {
            $query
                ->where('role', 4)
                ->where('program_id', $program->id);
        })
        ->get();

// 	var_dump($outcomes_attempted);
// 	print "<br>";
// 	var_dump($outcomes_achieved);
// 	print "<br>";
    return View::make('local.managers.shared.program', compact('title', 'outcomes', 'outcomes_attempted', 'outcomes_achieved', 'schools', 'program_courses', 'assessed_courses_count', 'grouped_courses', 'program', 'users'));

}

//   public function show($id)
//   {
// 
//     $program = Program::find($id);
//     $title= $program->school->name.': '.$program->name;
//     $program_courses = $program->courses;
//     $outcomes = Outcome::orderBy('name', 'asc')->get();
//     $schools = School::all();
//     $outcomeCount = Outcome::all()->count();
// 
// 
//     $outcomes_achieved = array_fill(1, $outcomeCount, 0);
//     $outcomes_attempted = array_fill(1, $outcomeCount, 0);
// 
//     $assessed_courses_count=0;
//     foreach ($program_courses as $course)
//     {
//         if($course->outcomes_achieved!=NULL)
//         {
//             $course_outcomes_achieved =json_decode($course->outcomes_achieved, true);
//             $course_outcomes_attempted =json_decode($course->outcomes_attempted, true);
//             for($i=1; $i<=count($outcomes_attempted); $i++)
//             {
//                 $outcomes_achieved[$i]+=$course_outcomes_achieved[$i];
//                 $outcomes_attempted[$i]+=$course_outcomes_attempted[$i];
//             }
//             $assessed_courses_count+=1;
//         }
//     }
// 
//     /**
//      * List of grouped courses (grouped sections)
//      */
// 
//     $grouped_courses = Course::
//       select(DB::raw('name, code, number, max(outcomes_attempted) as outcomes_attempted, semester_id, program_id'))
//       ->with('semester')
//       ->with('program')
//       ->where('program_id', $program->id)
//       ->whereIn('semester_id', Session::get('semesters_ids'))
//       ->groupBy(array('code', 'number', 'semester_id'))
//       ->orderBy('code')
//       ->orderBy('number')
//       ->orderBy('semester_id')
//       ->get();
// 
//     // Program contact information
//     $users = User::
//         select('users.*')
//         ->leftJoin('program_user', 'users.id', '=', 'program_user.user_id')
//         ->where(function($query) use($program)
//         {
//             $query
//                 ->where('school_id', $program->school_id)
//                 ->where('role', 2);
//         })
//         ->orWhere(function($query) use($program)
//         {
//             $query
//                 ->where('role', 3)
//                 ->where('program_id', $program->id);
//         })
//         ->orWhere(function($query) use($program)
//         {
//             $query
//                 ->where('role', 4)
//                 ->where('program_id', $program->id);
//         })
//         ->get();
// 
//     return View::make('local.managers.shared.program', compact('title', 'outcomes', 'outcomes_attempted', 'outcomes_achieved', 'schools', 'program_courses', 'assessed_courses_count', 'grouped_courses', 'program', 'users'));
// 
// }

  /**
   * Info to print a program
   */
  public function print_program($id)
  {

    $program = Program::find($id);
    $title= $program->name.' Assessment Report - '.date('m/d/Y');
    $program_courses = $program->courses;
    $outcomes = Outcome::orderBy('name', 'asc')->get();
    $schools = School::all();
    $outcomeCount = Outcome::all()->count();


    $outcomes_achieved = array_fill(1, $outcomeCount, 0);
    $outcomes_attempted = array_fill(1, $outcomeCount, 0);

    $assessed_courses_count=0;
    foreach ($program_courses as $course)
    {
      if($course->outcomes_achieved!=NULL)
      {
        $course_outcomes_achieved =json_decode($course->outcomes_achieved, true);
        $course_outcomes_attempted =json_decode($course->outcomes_attempted, true);
        for($i=1; $i<=count($outcomes_attempted); $i++)
        {
          $outcomes_achieved[$i]+=$course_outcomes_achieved[$i];
          $outcomes_attempted[$i]+=$course_outcomes_attempted[$i];
        }
        $assessed_courses_count+=1;
      }
    }

    /**
     * List of grouped courses (grouped sections)
     */

    $grouped_courses = Course::
      select(DB::raw('name, code, number, max(outcomes_attempted) as outcomes_attempted, semester_id, program_id'))
      ->with('semester')
      ->with('program')
      ->where('program_id', $program->id)
      ->whereIn('semester_id', Session::get('semesters_ids'))
      ->groupBy(array('code', 'number', 'semester_id'))
      ->orderBy('code')
      ->orderBy('number')
      ->orderBy('semester_id')
      ->get();

    return View::make('local.managers.shared.print_program', compact('title', 'program', 'outcomes', 'outcomes_attempted', 'outcomes_achieved', 'schools', 'program_courses', 'assessed_courses_count', 'grouped_courses'));
  }


  /**
   * A list of all programs
   */
  public function index()
  {
    $title = "Programs by School";
    $programs = Program::orderBy('name')->get();
    $schools = School::all();

    return View::make('local.managers.shared.programs', compact('programs', 'schools', 'title'));
  }

  /**
  * Fetch a program
  */
  public function fetch()
  {
    Log::info('id:'.Input::get('id'));
    return School::find(Input::get('id'))->programs;
  }
}