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