Please help me for fix this if statement |
public function getlessonlist($session, $id = null)
{ $class_section_array = $this->customlib->get_myClassSection(); $loggedinUserId = $_SESSION['admin']['id']; if ($this->userdata['role_id'] == '2') { // loggedin user id $this->datatables ->select('lesson.*,subject_groups.name as sgname,subjects.name as subname,subjects.code as subjects_code,sections.section as sname,sections.id as sectionid,subject_groups.id as subjectgroupsid,subjects.id as subjectid,class_sections.id as csectionid,classes.class as cname,classes.id as classid') ->searchable('classes.class,sections.section,subject_groups.name,subjects.name,lesson.name') ->orderable('classes.class,sections.section,subject_groups.name,subjects.name,lesson.name') ->join("subject_group_subjects", "subject_group_subjects.id = lesson.subject_group_subject_id") ->join("subject_groups", "subject_groups.id = subject_group_subjects.subject_group_id") ->join("subjects", "subjects.id = subject_group_subjects.subject_id") ->join("subject_group_class_sections", "subject_group_class_sections.id = lesson.subject_group_class_sections_id", 'inner') ->join("class_sections", "class_sections.id = subject_group_class_sections.class_section_id") ->join("sections", "sections.id = class_sections.section_id") ->join("classes", "classes.id = class_sections.class_id") ->where('lesson.session_id', $session) ->where('lesson.created_by', $loggedinUserId); } else { $this->datatables ->select('lesson.*,subject_groups.name as sgname,subjects.name as subname,subjects.code as subjects_code,sections.section as sname,sections.id as sectionid,subject_groups.id as subjectgroupsid,subjects.id as subjectid,class_sections.id as csectionid,classes.class as cname,classes.id as classid') ->searchable('sections.section,subject_groups.name,subjects.name,lesson.name') ->orderable('classes.class,sections.section,subject_groups.name,subjects.name,lesson.name') ->join("subject_group_subjects", "subject_group_subjects.id = lesson.subject_group_subject_id") ->join("subject_groups", "subject_groups.id = subject_group_subjects.subject_group_id") ->join("subjects", "subjects.id = subject_group_subjects.subject_id") ->join("subject_group_class_sections", "subject_group_class_sections.id = lesson.subject_group_class_sections_id", 'inner') ->join("class_sections", "class_sections.id = subject_group_class_sections.class_section_id") ->join("sections", "sections.id = class_sections.section_id") ->join("classes", "classes.id = class_sections.class_id") ->where('lesson.session_id', $session); } $this->datatables->group_by("lesson.subject_group_subject_id"); $this->datatables->group_by("lesson.subject_group_class_sections_id"); $this->datatables->from('lesson'); return $this->datatables->generate('json'); } } |
Welcome Guest, Not a member yet? Register Sign In |