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()));
}
}
