public function __construct() { if ($_GET['ref']) { $sql = 'SELECT iuser FROM {{iusers_options}} WHERE selfcode=\'' . $_GET['ref'] . '\''; $iuser = DB::getOne($sql); if ($iuser) { $_SESSION['referal'] = $iuser; } } $sql = 'SELECT * FROM {{tree}} WHERE parent=410 AND visible=1 ORDER BY num'; $list = DB::getAll($sql); foreach ($list as $item) { $fields = Fields::getFieldsByTree($item['id'], 'wide'); $item['pic'] = $fields['files_gal']['image'][0]['path']; $multi = Fields::getMultiFields($item['id']); foreach ($multi['color'] as $row) { $item['list'][$row] = Funcs::$referenceId['color'][$row]['name']; } Run::$colors[$item['id']] = $item; } //print '<pre>';print_r(Run::$colors);die; $sql = 'SELECT * FROM {{tree}} WHERE id=1'; $row = DB::getRow($sql); Run::$socTitle = $row['seo_title']; Run::$socDescription = $row['seo_description']; }
public function getList($id, $count = '') { DB::escapeGet(); $data = array(); if ($count != '') { $sql = 'SELECT * FROM {{tree}} WHERE parent=' . $id . ' AND visible=1 ORDER BY udate DESC LIMIT 0,' . $count; $list = DB::getAll($sql); } elseif ($_GET['d']) { $d = explode('-', $_GET['d']); $db = date('Y-m-d 00:00:01', strtotime($d[0] . '-' . $d[1] . '-01 00:00:01')); $de = date('Y-m-d 00:00:01', strtotime($d[0] . '-' . $d[1] . '-01 00:00:01 +1 month')); $sql = ' SELECT * FROM {{tree}} WHERE parent=' . $id . ' AND visible=1 AND (udate BETWEEN \'' . $db . '\' AND \'' . $de . '\') ORDER BY udate DESC '; $list = DB::getPagi($sql); } elseif ($_GET['tag']) { $sql = ' SELECT {{tree}}.* FROM {{tree}} INNER JOIN ( {{data}} INNER JOIN ({{relations}} INNER JOIN {{reference}} ON {{relations}}.id2={{reference}}.id ) ON {{data}}.id={{relations}}.id1 ) ON {{tree}}.id={{data}}.tree WHERE {{tree}}.parent=' . $id . ' AND {{data}}.path=\'tags\' AND {{tree}}.visible=1 AND {{reference}}.name=\'' . $_GET['tag'] . '\' ORDER BY {{tree}}.udate DESC '; $list = DB::getPagi($sql); } else { $sql = 'SELECT * FROM {{tree}} WHERE parent=' . $id . ' AND visible=1 ORDER BY udate DESC'; $list = DB::getPagi($sql); } foreach ($list as $item) { $field = Fields::getFieldsByTree($item['id'], 'wide'); $path = Tree::getPathToTree($item['id']); $tags = array(); $multi = Fields::getMultiFields($item['id']); foreach ($multi['tags'] as $tag) { $tags[] = Funcs::$referenceId['tags'][$tag]['name']; } $data[] = array('id' => $item['id'], 'name' => $item['name'], 'preview' => $field['preview'], 'path' => $path, 'udate' => $item['udate'], 'day' => date('d', strtotime($item['udate'])), 'mon' => Funcs::$monthsRus[date('n', strtotime($item['udate'])) - 1], 'date' => date('d', strtotime($item['udate'])) . ' ' . Funcs::$monthsRus[date('n', strtotime($item['udate'])) - 1] . ' ' . date('Y', strtotime($item['udate'])), 'pic' => $field['files_gal']['image'][0]['path'], 'tags' => $tags); } return $data; }
public function getOne($id) { //die($id); if (!Cache::get('model' . $id)) { $fields = Fields::getReserveFieldsByModulePath('catalog'); $sql = ' SELECT {{catalog}}.*, {{tree}}.* FROM {{catalog}} INNER JOIN {{tree}} ON {{catalog}}.tree={{tree}}.id WHERE {{tree}}.id =' . $id . ' '; $model = DB::getRow($sql); if ($model) { foreach ($fields as $key => $item) { if (in_array($item['path'], OneSSA::$catalogStandart)) { $temp[$item['path']] = $model[$item['path']]; } } $return = $temp; $return['id'] = $id; $parentpath = Tree::getPathToTree($model['parent']); $return['path'] = $parentpath . $id . '/'; $return['tree'] = $id; $return['name'] = $model['name']; $return['parent'] = $model['parent']; $return['rating'] = $model['rating']; $return['report'] = Catalog::getCountReport($id); $return['sale'] = $item['price'] - $item['supprice']; $fields = Fields::getFieldsByTree($id, 'wide'); $return['pics'] = $fields['files_gal']['image']; /*$date_b=explode('.', Funcs::$conf['akcia']['date_begin']); $date_e=explode('.', Funcs::$conf['akcia']['date_end']); $date_b=mktime(0,0,0,$date_b[1], $date_b[0],$date_b[2]); $date_e=mktime(23,59,59,$date_e[1], $date_e[0],$date_e[2]); $today=mktime(); $yes=0; if (($today>=$date_b)&&($today<=$date_e)) $yes=1; $akcia='0'; if ($yes==1) $akcia=$model['akcia'];*/ $return['akcia'] = $akcia; $return['files'] = $fields['files_gal']['application']; $multi = Fields::getMultiFields($id); if (count($multi['tv']) > 0) { $return['descr1'] = 'Телевидение'; $return['descr2'] = Funcs::$referenceId['tv'][$multi['tv'][0]]['name']; } unset($fields['files_gal']); unset($fields['gal']); $return['additional'] = Catalog::getAdditionalFieldsArray($fields); Cache::set('model' . $id, $return); return $return; } } else { return Cache::get('model' . $id); } }