public static function getObject($ind)
{
if (!$ind) {
return false;
}
if (is_numeric($ind)) {
$key = 'id';
$notUrl = ' and url=""';
// дополнительная проверка на пустой урл для этого обьекта, что-бы небыло повторов страниц
} else {
$key = 'url';
$ind = trim($ind, '/');
if (!$ind) {
return false;
}
}
// $objectModel = new Admin_Model_Object;
// $object = $objectModel->mfr(select()->where(array($key => $ind)));
// select *,(select name from obj_types where id=obj_objects.type limit 1) as typename, (select anchID from obj_objects where id=".$_REQUEST['look']." limit 1) as filial_info, (select symbol from obj_branches where id=obj_objects.branchID) as letter from obj_objects where id=".$_REQUEST['look']." limit 1"
// $db->setQuery('select id,title,text from obj_plans where objID='.$this->data['id'].'');
// phone, address, email
$q = new K_Query();
$row = $q->q("SELECT o.*, b.symbol letter, t.name typename, o.branchID filial_info, b.symbol letter, b.phone, b.address, b.email FROM `obj_objects` o \n LEFT JOIN obj_rooms r ON r.id = o.id\n LEFT JOIN obj_types t ON t.id = o.type\n LEFT JOIN obj_branches b ON b.id = o.branchID \n WHERE o." . $key . "=" . K_Db_Quote::quote($ind) . ' ' . $notUrl, true);
if ($row) {
return $row[0];
} else {
return false;
}
}
public function editAction()
{
$this->disableLayout = true;
$id = intval($_GET['objectid']);
$query = new K_Query();
$itemModel = new Admin_Model_Object();
$itemRow = $itemModel->mfr("SELECT o.*, b.symbol letter, t.name typename, o.branchID filial_info, b.symbol letter, b.phone, b.address, b.email FROM `obj_objects` o \n LEFT JOIN obj_rooms r ON r.id = o.id\n LEFT JOIN obj_types t ON t.id = o.type\n LEFT JOIN obj_branches b ON b.id = o.branchID \n WHERE o.id='" . $id . "'");
$this->view->regions = $query->q('select title as t from obj_regions WHERE city LIKE "г.Одесса" order by t', true);
// сделать вывод планировок.
// var_dump($itemRow);
$this->view->objectRow = $itemRow;
$this->render('edit');
}
