Example #1
0
 public function saveAction()
 {
     $tasksHrsData = $this->_getParam('data');
     $calWeek = $this->_getParam('calWeek');
     $week = $this->_getParam('week');
     $weekStartDate = $this->_getParam('weekStart');
     $weekEndDate = $this->_getParam('weekEnd');
     $selYrMon = $this->_getParam('selYrMon');
     $tasksData = explode(',', $tasksHrsData);
     $callval = $this->getRequest()->getParam('call');
     $sunNote = $this->_getParam('sun_note');
     $monNote = $this->_getParam('mon_note');
     $tueNote = $this->_getParam('tue_note');
     $wedNote = $this->_getParam('wed_note');
     $thuNote = $this->_getParam('thu_note');
     $friNote = $this->_getParam('fri_note');
     $satNote = $this->_getParam('sat_note');
     $weekNote = $this->_getParam('week_note');
     $storage = new Zend_Auth_Storage_Session();
     $sessionData = $storage->read();
     $selYrMonArray = explode('-', $selYrMon);
     $myTsModel = new Timemanagement_Model_MyTimesheet();
     $projTasksArray = array();
     $projsArray = array();
     $date = new Zend_Date();
     $projectId = '';
     if ($this->getRequest()->getPost() && $tasksHrsData != '') {
         foreach ($tasksData as $data) {
             $taskDataArray = explode('#', $data);
             $sun_hrs = $taskDataArray[2] != null ? $taskDataArray[2] : 0;
             $sun_tot = 0;
             if (!empty($sun_hrs)) {
                 $sun_dur = explode(':', $sun_hrs);
                 $sun_tot += $sun_dur[0] * 60;
                 $sun_tot += $sun_dur[1];
             }
             $mon_hrs = $taskDataArray[3] != null ? $taskDataArray[3] : 0;
             $mon_tot = 0;
             if (!empty($mon_hrs)) {
                 $mon_dur = explode(':', $mon_hrs);
                 $mon_tot += $mon_dur[0] * 60;
                 $mon_tot += $mon_dur[1];
             }
             $tue_hrs = $taskDataArray[4] != null ? $taskDataArray[4] : 0;
             $tue_tot = 0;
             if (!empty($tue_hrs)) {
                 $tue_dur = explode(':', $tue_hrs);
                 $tue_tot += $tue_dur[0] * 60;
                 $tue_tot += $tue_dur[1];
             }
             $wed_hrs = $taskDataArray[5] != null ? $taskDataArray[5] : 0;
             $wed_tot = 0;
             if (!empty($wed_hrs)) {
                 $wed_dur = explode(':', $wed_hrs);
                 $wed_tot += $wed_dur[0] * 60;
                 $wed_tot += $wed_dur[1];
             }
             $thu_hrs = $taskDataArray[6] != null ? $taskDataArray[6] : 0;
             $thu_tot = 0;
             if (!empty($thu_hrs)) {
                 $thu_dur = explode(':', $thu_hrs);
                 $thu_tot += $thu_dur[0] * 60;
                 $thu_tot += $thu_dur[1];
             }
             $fri_hrs = $taskDataArray[7] != null ? $taskDataArray[7] : 0;
             $fri_tot = 0;
             if (!empty($fri_hrs)) {
                 $fri_dur = explode(':', $fri_hrs);
                 $fri_tot += $fri_dur[0] * 60;
                 $fri_tot += $fri_dur[1];
             }
             $sat_hrs = $taskDataArray[8] != null ? $taskDataArray[8] : 0;
             $sat_tot = 0;
             if (!empty($sat_hrs)) {
                 $sat_dur = explode(':', $sat_hrs);
                 $sat_tot += $sat_dur[0] * 60;
                 $sat_tot += $sat_dur[1];
             }
             $week_tot_time = intval($sun_tot) + intval($mon_tot) + intval($tue_tot) + intval($wed_tot) + intval($thu_tot) + intval($fri_tot) + intval($sat_tot);
             $wkHrsPart = floor($week_tot_time / 60);
             $wkMinsPart = $week_tot_time % 60;
             if (strlen($wkHrsPart . '') == 1) {
                 $wkHrsPart = '0' . $wkHrsPart;
             }
             if (strlen($wkMinsPart . '') == 1) {
                 $wkMinsPart = '0' . $wkMinsPart;
             }
             $week_tot = $wkHrsPart . ':' . $wkMinsPart;
             array_push($projTasksArray, $taskDataArray[0]);
             $data = array('emp_id' => $sessionData->id, 'project_task_id' => $taskDataArray[0], 'project_id' => $taskDataArray[1], 'ts_year' => $selYrMonArray[0], 'ts_month' => $selYrMonArray[1], 'ts_week' => $week, 'cal_week' => $calWeek, 'sun_date' => date('Y-m-d', strtotime($weekStartDate)), 'sun_duration' => $taskDataArray[2] != null ? $taskDataArray[2] : '00:00', 'mon_date' => date('Y-m-d', strtotime('+1 day', strtotime($weekStartDate))), 'mon_duration' => $taskDataArray[3] != null ? $taskDataArray[3] : '00:00', 'tue_date' => date('Y-m-d', strtotime('+2 day', strtotime($weekStartDate))), 'tue_duration' => $taskDataArray[4] != null ? $taskDataArray[4] : '00:00', 'wed_date' => date('Y-m-d', strtotime('+3 day', strtotime($weekStartDate))), 'wed_duration' => $taskDataArray[5] != null ? $taskDataArray[5] : '00:00', 'thu_date' => date('Y-m-d', strtotime('+4 day', strtotime($weekStartDate))), 'thu_duration' => $taskDataArray[6] != null ? $taskDataArray[6] : '00:00', 'fri_date' => date('Y-m-d', strtotime('+5 day', strtotime($weekStartDate))), 'fri_duration' => $taskDataArray[7] != null ? $taskDataArray[7] : '00:00', 'sat_date' => date('Y-m-d', strtotime('+6 day', strtotime($weekStartDate))), 'sat_duration' => $taskDataArray[8] != null ? $taskDataArray[8] : '00:00', 'week_duration' => $week_tot, 'created_by' => $sessionData->id, 'is_active' => 1, 'created' => Zend_Registry::get('currentdate'));
             $checkProjNull = $myTsModel->getProjNullRecordCountInTimeSheet($sessionData->id, $selYrMonArray[0], $selYrMonArray[1], $week);
             if ($checkProjNull != 0) {
                 $where = " ts_year = " . $selYrMonArray[0] . " and ts_month = " . $selYrMonArray[1] . " and ts_week = " . $week . " and emp_id = " . $sessionData->id . " and project_id is null";
                 unset($data['created']);
                 $data['modified'] = Zend_Registry::get('currentdate');
                 $myTsModel->updateTimesheetRecord($data, $where);
             } else {
                 $myTsModel->SaveOrUpdateTimesheet($data);
             }
             if ($projectId != $taskDataArray[1]) {
                 $projectId = $taskDataArray[1];
                 array_push($projsArray, $taskDataArray[1]);
             }
         }
         foreach ($projsArray as $proj) {
             $projHrsData = $myTsModel->getWeekProjectHrs($sessionData->id, $proj, $selYrMonArray[0], $selYrMonArray[1], $week);
             $statusData = array('emp_id' => $sessionData->id, 'project_id' => $proj, 'ts_year' => $selYrMonArray[0], 'ts_month' => $selYrMonArray[1], 'ts_week' => $week, 'cal_week' => $calWeek, 'sun_date' => date('Y-m-d', strtotime($weekStartDate)), 'sun_project_status' => $projHrsData[0]['sun_duration'] != '00:00' ? 'saved' : 'no_entry', 'sun_status' => $projHrsData[0]['sun_duration'] != '00:00' ? 'saved' : 'no_entry', 'sun_status_date' => Zend_Registry::get('currentdate'), 'mon_date' => date('Y-m-d', strtotime('+1 day', strtotime($weekStartDate))), 'mon_project_status' => $projHrsData[0]['mon_duration'] != '00:00' ? 'saved' : 'no_entry', 'mon_status' => $projHrsData[0]['mon_duration'] != '00:00' ? 'saved' : 'no_entry', 'mon_status_date' => Zend_Registry::get('currentdate'), 'tue_date' => date('Y-m-d', strtotime('+2 day', strtotime($weekStartDate))), 'tue_project_status' => $projHrsData[0]['tue_duration'] != '00:00' ? 'saved' : 'no_entry', 'tue_status' => $projHrsData[0]['tue_duration'] != '00:00' ? 'saved' : 'no_entry', 'tue_status_date' => Zend_Registry::get('currentdate'), 'wed_date' => date('Y-m-d', strtotime('+3 day', strtotime($weekStartDate))), 'wed_project_status' => $projHrsData[0]['wed_duration'] != '00:00' ? 'saved' : 'no_entry', 'wed_status' => $projHrsData[0]['wed_duration'] != '00:00' ? 'saved' : 'no_entry', 'wed_status_date' => Zend_Registry::get('currentdate'), 'thu_date' => date('Y-m-d', strtotime('+4 day', strtotime($weekStartDate))), 'thu_project_status' => $projHrsData[0]['thu_duration'] != '00:00' ? 'saved' : 'no_entry', 'thu_status' => $projHrsData[0]['thu_duration'] != '00:00' ? 'saved' : 'no_entry', 'thu_status_date' => Zend_Registry::get('currentdate'), 'fri_date' => date('Y-m-d', strtotime('+5 day', strtotime($weekStartDate))), 'fri_project_status' => $projHrsData[0]['fri_duration'] != '00:00' ? 'saved' : 'no_entry', 'fri_status' => $projHrsData[0]['fri_duration'] != '00:00' ? 'saved' : 'no_entry', 'fri_status_date' => Zend_Registry::get('currentdate'), 'sat_date' => date('Y-m-d', strtotime('+6 day', strtotime($weekStartDate))), 'sat_project_status' => $projHrsData[0]['sat_duration'] != '00:00' ? 'saved' : 'no_entry', 'sat_status' => $projHrsData[0]['sat_duration'] != '00:00' ? 'saved' : 'no_entry', 'sat_status_date' => Zend_Registry::get('currentdate'), 'week_status' => $projHrsData[0]['week_duration'] != '00:00' ? 'saved' : 'no_entry', 'created_by' => $sessionData->id, 'is_active' => 1, 'created' => Zend_Registry::get('currentdate'));
             $checkProjNull = $myTsModel->getProjNullRecordCountInStatus($sessionData->id, $selYrMonArray[0], $selYrMonArray[1], $week);
             if ($checkProjNull != 0) {
                 $where = " ts_year = " . $selYrMonArray[0] . " and ts_month = " . $selYrMonArray[1] . " and ts_week = " . $week . " and emp_id = " . $sessionData->id . " and project_id is null";
                 unset($statusData['created']);
                 $statusData['modified'] = Zend_Registry::get('currentdate');
                 $myTsModel->updateStatusRecord($statusData, $where);
             } else {
                 $myTsModel->SaveOrUpdateTimesheetStatus($statusData);
             }
         }
         $notesData = array('emp_id' => $sessionData->id, 'ts_year' => $selYrMonArray[0], 'ts_month' => $selYrMonArray[1], 'ts_week' => $week, 'cal_week' => $calWeek, 'sun_date' => date('Y-m-d', strtotime($weekStartDate)), 'sun_note' => $sunNote, 'mon_date' => date('Y-m-d', strtotime('+1 day', strtotime($weekStartDate))), 'mon_note' => $monNote, 'tue_date' => date('Y-m-d', strtotime('+2 day', strtotime($weekStartDate))), 'tue_note' => $tueNote, 'wed_date' => date('Y-m-d', strtotime('+3 day', strtotime($weekStartDate))), 'wed_note' => $wedNote, 'thu_date' => date('Y-m-d', strtotime('+4 day', strtotime($weekStartDate))), 'thu_note' => $thuNote, 'fri_date' => date('Y-m-d', strtotime('+5 day', strtotime($weekStartDate))), 'fri_note' => $friNote, 'sat_date' => date('Y-m-d', strtotime('+6 day', strtotime($weekStartDate))), 'sat_note' => $satNote, 'week_note' => $weekNote, 'created_by' => $sessionData->id, 'is_active' => 1, 'created' => Zend_Registry::get('currentdate'));
         $myTsModel->SaveOrUpdateTimesheetNotes($notesData);
     }
     $empDeletedTasks = $myTsModel->empployeeDeletedTasks($sessionData->id, $selYrMonArray[0], $selYrMonArray[1], $week, $calWeek, $projTasksArray);
     if (is_array($empDeletedTasks)) {
         foreach ($empDeletedTasks as $taskId) {
             $deleteTasksData = array('emp_id' => $sessionData->id, 'project_task_id' => $taskId, 'ts_year' => $selYrMonArray[0], 'ts_month' => $selYrMonArray[1], 'ts_week' => $week, 'cal_week' => $calWeek, 'sun_duration' => '00:00', 'mon_duration' => '00:00', 'tue_duration' => '00:00', 'wed_duration' => '00:00', 'thu_duration' => '00:00', 'fri_duration' => '00:00', 'sat_duration' => '00:00', 'week_duration' => '00:00', 'is_active' => 0, 'modified_by' => $sessionData->id, 'modified' => Zend_Registry::get('currentdate'));
             $myTsModel->deleteTimesheetTask($sessionData->id, $deleteTasksData, $taskId, $selYrMonArray[0], $selYrMonArray[1], $week);
         }
     }
     $empDeletedProjects = $myTsModel->empployeeDeletedProjects($sessionData->id, $selYrMonArray[0], $selYrMonArray[1], $week, $calWeek, $projsArray);
     if (is_array($empDeletedProjects)) {
         foreach ($empDeletedProjects as $projId) {
             $deleteProjectsData = array('emp_id' => $sessionData->id, 'project_id' => $taskId, 'ts_year' => $selYrMonArray[0], 'ts_month' => $selYrMonArray[1], 'ts_week' => $week, 'cal_week' => $calWeek, 'sun_project_status' => 'no_entry', 'mon_project_status' => 'no_entry', 'tue_project_status' => 'no_entry', 'wed_project_status' => 'no_entry', 'thu_project_status' => 'no_entry', 'fri_project_status' => 'no_entry', 'sat_project_status' => 'no_entry', 'is_active' => 0, 'modified_by' => $sessionData->id, 'modified' => Zend_Registry::get('currentdate'));
             $myTsModel->deleteWeekProjectStatus($sessionData->id, $deleteProjectsData, $projId, $selYrMonArray[0], $selYrMonArray[1], $week);
         }
     }
     $myTsModel->updateDayStatus($sessionData->id, $selYrMonArray[0], $selYrMonArray[1], $week);
     $myTsModel->updateWeekStatus($sessionData->id, $selYrMonArray[0], $selYrMonArray[1], $week);
     if ($callval == 'ajaxcall') {
         $this->_helper->layout->disableLayout();
     }
     $this->view->status = 'success';
     $this->view->message = 'Time sheet saved successfully.';
 }