public function adjustperiodAction() { $objfacultyadjustment = new Acad_Model_DbTable_FacultyAdjustment(); $request = $this->getRequest(); $period_id = $request->getParam('period_id'); $staff_id = $request->getParam('staff_id'); $target_subject = $request->getParam('target_subject'); $target_staff_id = $request->getParam('target_staff_id'); $adjustment_dateobj = new Zend_Date($request->getParam('adjustment_date'), 'dd-MM-YYYY'); $adjustment_date = $adjustment_dateobj->toString('YYYY-MM-dd'); $resultSet = Acad_Model_DbTable_TimeTable::getPeriodIdTimetable($period_id, $adjustment_date, $staff_id); $insertData = NULL; $cnt = 0; foreach ($resultSet as $key => $value) { $adj_resultSet = Acad_Model_DbTable_TimeTable::getSubjectTimetableids($value['department_id'], $value['degree_id'], $value['semester_id'], $target_subject, $value['subject_mode_id'], $value['group_id']); if (count($adj_resultSet) > 0) { $insertData[$cnt++] = array('source_timetable_id' => $value['timetable_id'], 'start_date' => $adjustment_date, 'source_staff_id' => $staff_id, 'target_timetable_id' => $adj_resultSet[0], 'target_staff_id' => $target_staff_id); } else { $this->getResponse()->setHttpResponseCode(400); echo 'Timetable Entry does not exists for ' . implode(',', array($target_subject, $value['subject_mode_id'], $value['group_id'])); return; } } $result = $objfacultyadjustment->adjustperiod($insertData); if ($result) { echo "Period successfully adjusted "; } else { $this->getResponse()->setHttpResponseCode(400); echo 'Error occured while adjustment'; } }