public function fetchAll($where = null, $orderby = null) { $resultSet = $this->getDbTable()->fetchAll($where, $orderby); $entries = array(); foreach ($resultSet as $row) { $entry = new Default_Model_Experience(); $entry->setId($row->res_experience_id); $entry->setResumeId($row->resume_id); $entry->setStartDate($row->start_date); $entry->setEndDate($row->end_date); $entry->setJobTitle($row->job_title); $entry->setCompanyName($row->company_name); $entry->setDuties($row->duties); $entry->setExperienceOther($row->experience_other); $entry->setSortOrder($row->sort_order); $entries[] = $entry; } return $entries; }
public function saveExperienceAction() { $post = $this->getRequest()->getPost(); //$date = new DateTime($post['startdate']); //$startDate = $date->format('Y-m-d'); //$date = new DateTime($post['enddate']); //$endDate = $date->format('Y-m-d'); $experienceRowset = new Default_Model_Experience(); $experienceRowset->setId($post['experid']); $experienceRowset->setResumeId($post['resume_id']); $experienceRowset->setStartDate($post['startdate']); $experienceRowset->setEndDate($post['enddate']); $experienceRowset->setJobTitle($post['job_title']); $experienceRowset->setCompanyName($post['company_name']); $experienceRowset->setDuties($post['duties']); $experienceRowset->setSortOrder(1); $experienceMapper = new Default_Model_ExperienceMapper(); $experienceId = $experienceMapper->save($experienceRowset); if ($experienceId) { $resumeMapper = new Default_Model_ResumeMapper(); $resumeMapper->updateResumDate($post['resume_id']); } $experienceMapper->delExperFunction($experienceId); foreach ($post['option'] as $functionId) { $experienceMapper->saveExperFunction($experienceId, $functionId); } if ($post['button'] == 'Next') { $this->_redirect('resume/expectation/id/' . $post['resume_id']); } else { $this->_redirect('/resume/experience/id/' . $post['resume_id']); } }