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; } }
'); foreach ($clients as $v) { $tok = explode('<!--:-->', $v['meta_value']); K_Query::query('UPDATE tree SET tree_meta_title="' . str_replace('<!--:ru-->', '', $tok[0]) . '", tree_meta_title_uk="' . str_replace('<!--:uk-->', '', $tok[1]) . '" WHERE tree_id="' . $v['tree_id'] . '"'); } $clients = K_Query::query('SELECT * FROM tree t LEFT JOIN wp_posts p ON t.tree_name=p.post_name LEFT JOIN wp_postmeta pm ON pm.post_id=p.ID WHERE pm.meta_key="description" '); foreach ($clients as $v) { $tok = explode('<!--:-->', $v['meta_value']); K_Query::query('UPDATE tree SET tree_meta_description="' . str_replace('<!--:ru-->', '', $tok[0]) . '", tree_meta_description_uk="' . str_replace('<!--:uk-->', '', $tok[1]) . '" WHERE tree_id="' . $v['tree_id'] . '"'); } $clients = K_Query::query('SELECT * FROM tree t LEFT JOIN wp_posts p ON t.tree_name=p.post_name LEFT JOIN wp_postmeta pm ON pm.post_id=p.ID WHERE pm.meta_key="keywords" '); foreach ($clients as $v) { $tok = explode('<!--:-->', $v['meta_value']); K_Query::query('UPDATE tree SET tree_meta_keywords="' . str_replace('<!--:ru-->', '', $tok[0]) . '", tree_meta_keywords_uk="' . str_replace('<!--:uk-->', '', $tok[1]) . '" WHERE tree_id="' . $v['tree_id'] . '"'); } /* $clients = K_Query::query('SELECT * FROM `wp_posts` WHERE guid LIKE "http://www.glassok.ua/nashi-klienty/%"'); $typeM = new Type_Model_Clients; foreach($clients as $v){ $content = explode('<!--:-->', $v['post_content']); $title = explode('<!--:-->', $v['post_title']); $data = array(
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'); }