public function find($cppId, Pment_Models_Cpp $cpp) { $result = $this->getDbTable()->find($cppId); if (0 == count($result)) { return; } $row = $result->current(); $cpp->setCppId($row->cppId) ->setContactId($row->contactId) ->setPostId($row->postId) ->setProjectId($row->projectId) ->setQualif($row->qualif) ->setStartDate($row->startDate) ->setResponsi($row->responsi) ->setRemark($row->remark) ->setCertId($row->certId) ->setCTime($row->cTime); $contactId = $cpp->getContactId(); $projectId = $cpp->getProjectId(); $postId = $cpp->getPostId(); $contacts = new Employee_Models_ContactMapper(); $cpp->setContactName($contacts->findContactName($contactId)); $projects = new Project_Models_ProjectMapper(); $cpp->setProjectName($projects->findProjectName($projectId)); $posts = new General_Models_PostMapper(); $post = $posts->findPostName($postId); $cpp->setPostName($post['name']); $cpp->setPostDetail($post['detail']); }
public function findVerecordJoin($recordId,Vehicle_Models_Verecord $verecord) { $row = $this->getDbTable()->fetchRow('recordId = '.$recordId); if (0 == count($row)){ return; } $verecord->setRecordId($row->recordId) ->setVeId($row->veId) ->setPrjFlag($row->prjFlag) ->setProjectId($row->projectId) ->setStartDate($row->startDate) ->setEndDate($row->endDate) ->setPeriod($row->period) ->setRoute($row->route) ->setMileBf($row->mileBf) ->setMileAf($row->mileAf) ->setMile($row->mile) ->setPurpose($row->purpose) ->setContactId($row->contactId) ->setUser($row->user) ->setMileRef($row->mileRef) ->setAmount($row->amount) ->setRemark($row->remark) ->setCTime($row->cTime); $veId = $verecord->getVeId(); $vehicles = new Vehicle_Models_VehicleMapper(); $plateNo = $vehicles->findPlateNo($veId); $verecord->setPlateNo($plateNo); $contacts = new Employee_Models_ContactMapper(); $contactName = $contacts->findContactName($verecord->getContactId()); $verecord->setContactName($contactName); if($verecord->getPrjFlag() == '0') { $verecord->setPrjFlag(General_Models_Text::$text_verecord_prjFlag_false); $verecord->setProjectName(General_Models_Text::$text_verecord_prjFlag_false); } elseif($verecord->getPrjFlag() == '1') { $verecord->setPrjFlag(General_Models_Text::$text_verecord_prjFlag_true); $projects = new Project_Models_ProjectMapper(); $verecord->setProjectName($projects->findProjectName($verecord->getProjectId())); } }