123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154 |
- <?php
-
- use Illuminate\Database\Eloquent\SoftDeletingTrait;
-
- class Objective extends Eloquent
- {
- use SoftDeletingTrait;
- protected $fillable = array('text', 'outcome_id', 'active');
- protected $table = 'objectives';
- protected $appends = array("grouped_annual_course", 'programs');
-
-
-
- public function getProgramsAttribute()
- {
- return Program::join('objective_program', 'programs.id', '=', 'objective_program.program_id')
- ->where('objective_program.objective_id', $this->id)
- ->get();
- }
-
-
-
- public function getPairedOutcomeAttribute()
- {
- if (isset($this->typ_semester_objective_id))
- return Outcome::join('typ_semester_outcome', 'typ_semester_outcome.outcome_id', '=', 'outcomes.id')
- ->join('typ_semester_objectives', 'typ_semester_objectives.typ_semester_outcome_id', '=', 'typ_semester_outcome.id')
- ->where('typ_semester_objectives.id', $this->typ_semester_objective_id)
- ->select('typ_semester_outcome.id as typ_semester_outcome_id', 'outcomes.*')
- ->first();
- }
-
-
-
-
-
-
-
-
- public function getGroupedAnnualCourseAttribute()
- {
- if (isset($this->typ_semester_objective_id)) {
-
-
-
- return Course::join('typ_semester_courses', 'courses.id', '=', 'typ_semester_courses.course_id')
- ->where('typ_semester_objective_id', $this->typ_semester_objective_id)
-
- ->select('courses.*', 'typ_semester_courses.id as typ_semester_course_id', DB::raw("'{$this->semester_id}' as semester_id"), "courses.program_id")
- ->get();
-
-
-
-
-
-
- }
- return null;
- }
-
-
-
-
-
-
-
- public static function getPlanReport($objective)
- {
- $course_codes = DB::table('typ_semester_courses')
- ->join('courses', 'courses.id', '=', 'typ_semester_courses.course_id')
- ->where('typ_semester_objective_id', $objective->typ_semester_objective_id)
- ->where('courses.program_id', $objective->program_id)
- ->select('courses.code', 'courses.number', 'courses.id as course_id', 'typ_semester_courses.id as typ_semester_course_id', DB::raw("{$objective->semester_id} as semester_id"), "courses.program_id")
- ->get();
-
- Log::info("No es aqui");
-
-
-
- foreach ($course_codes as $course_code) {
- $course_code->transforming_actions = DB::table('annual_plan_transformative')
- ->join('transformative_actions', 'transformative_actions.id', '=', 'annual_plan_transformative.trans_id')
- ->where('typ_semester_course_id', $course_code->typ_semester_course_id)
- ->select('transformative_actions.*')
- ->get();
- $course_code->future_typ_course_id = Course::getFutureTypSemesterCourses($course_code->typ_semester_course_id, $course_code->program_id);
- $course_code->grouped = 1;
-
- $course_code->students = Course::getStudentReportForOutcome($course_code);
-
- Log::info("dimelo");
- $course_code->criteria = Course::getCriteriaPlanReport($course_code);
- }
- Log::info("???");
- return $course_codes;
- }
- public function outcomes()
- {
- return $this->belongsToMany('Outcome', 'objective_outcome', 'objective_id', 'outcome_id');
- }
-
- public function outcome()
- {
- return $this->belongsTo('Outcome');
- }
-
-
-
-
-
-
- public function outcome_id()
- {
- return $this->hasMany('Objective_Outcome', 'objective_id');
- }
- }
|