コード例 #1
0
ファイル: spot.php プロジェクト: CrazyBobik/allotaxi.test
 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;
     }
 }
コード例 #2
0
ファイル: transfer.php プロジェクト: CrazyBobik/allotaxi.test
  ');
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(
            
コード例 #3
0
ファイル: objects.php プロジェクト: CrazyBobik/allotaxi.test
 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');
 }