public function getOneBySubIdLot($subId, $lot)
{
if (empty($subId) || empty($lot)) {
return array();
}
$table =& $this->dbTable;
$where = $table->getAdapter()->quoteInto('sub_id=?', $subId);
$where .= ' AND ' . $table->getAdapter()->quoteInto('lot=?', $lot);
$antique = $table->fetchAll($table->select()->from($table, '*')->where($where))->toArray();
$antique = $antique[0];
if (!empty($antique)) {
if ($this->withActivity) {
$tableActivity = new Application_Model_DbTable_Activity();
$activity = $tableActivity->find($antique['activity_id'])->toArray();
$antique['activity'] = $activity[0];
}
if ($this->withSubActivity) {
$tableSubActivity = new Application_Model_DbTable_SubActivity();
$subActivity = $tableSubActivity->find($antique['sub_id'])->toArray();
$antique['sub'] = $subActivity[0];
}
if ($this->withCompany) {
$tableCompany = new Application_Model_DbTable_Company();
$company = $tableCompany->find($antique['activity']['company_id'])->toArray();
$antique['company'] = $company[0];
}
if ($this->withPhoto) {
$modelPhoto = new Application_Model_Photo();
$photo = $modelPhoto->getByAntiqueIds($id);
$antique['photo'] = $photo;
}
}
return $antique;
}