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