public function attendanceAction() { $department_id = $this->_getParam('department_id'); $programme_id = $this->_getParam('programme_id'); $semester_id = $this->_getParam('semester_id'); $faculty_id = $this->_getParam('faculty_id'); $dateFrom = $this->_getParam('date_from'); $dateUpto = $this->_getParam('date_upto'); $format = $this->_getParam('format', 'html'); $faculty = new Acad_Model_Member_Faculty(); if (true) { $faculty->setFacultyId($faculty_id); } $faculty->setDepartment($department_id); $objLevel = null; if ($department_id) { $objLevel = new Acad_Model_Department(); $objLevel->setDepartment($department_id); } if ($department_id and $programme_id and $semester_id) { $objLevel = new Acad_Model_Class(); $objLevel->setDepartment($department_id)->setProgramme_id($programme_id)->setSemester($semester_id); } $subjects = $faculty->getInHandSubjects($objLevel, TRUE); foreach ($subjects as $subject_code => $subjectClasses) { $subject = new Acad_Model_Course_Subject(array('subject_code' => $subject_code)); $subjectName = $subject->getSubject_name(); foreach ($subjectClasses as $key => $subjectClass) { $subjects[$subject_code][$key]['subject_name'] = $subjectName; } } switch (strtolower($format)) { case 'test': $this->_helper->logger($subjects); return; case 'html': $this->_helper->logger($subjects); $this->_helper->viewRenderer->setNoRender(false); $this->_helper->layout()->enableLayout(); $this->view->assign('department_id', $this->view->escape($department_id)); $urlSubjectDetail = $this->_helper->url('attendance', 'subject'); $this->view->assign('urlSubjetDetail', $this->view->escape($urlSubjectDetail)); $this->view->assign('subjects', $subjects); $this->view->assign('date_from', $this->view->escape($dateFrom)); $this->view->assign('date_upto', $this->view->escape($dateUpto)); $this->view->assign('faculty', $faculty); $this->view->assign('viewLevel', $objLevel); return; case 'json': echo $this->_helper->json($subjects, false); return; case 'jsonp': $callback = $this->_getParam('callback'); echo $callback . '(' . $this->_helper->json($subjects, false) . ')'; return; } }
/** * Department wise detail of data * Enter description here ... */ public function getdetaildataAction() { $request = $this->getRequest(); //Getting Request Parameters $period_dateobj = new Zend_Date($request->getParam('attendance_date'), 'dd-MM-YYYY'); $period_date = $period_dateobj->toString('YYYY-MM-dd'); $department = $request->getParam('department_id'); //$this->_helper->viewRenderer->setNoRender(false); //$this->_helper->layout()->enableLayout(); $depttObj = new Acad_Model_Department(); $depttObj->setDepartment($department); $result = $depttObj->getAttendanceDetail($period_date); $this->_helper->logger($result); $this->gridparam['page'] = $request->getParam('page', 1); // get the requested page $this->gridparam['limit'] = $request->getParam('rows', 20); // rows limit in Grid $this->_count = count($result); $response = new stdClass(); foreach ($result as $key => $value) { $response->rows[$key]['id'] = $value['subject_code']; $response->rows[$key]['cell'] = array($value['staff_id'], $value['marked_date'], $value['degree_id'], $value['semester_id'], $value['periods_covered'], $value['subject_code'], $value['subject_mode_id'], $value['group_id']); } $response->page = $this->gridparam['page']; $response->total = 1; $response->records = $this->_count; echo $this->_helper->json($response, false); }