Query('SELECT * FROM menu WHERE menu.parent="0" ORDER BY menu.id'); while($row = mysqli_fetch_array($result)) { $res_array[$count] = $row; $count++; } return $res_array; } //Функция выборки подменю function get_two($parent) { $this->Query('SELECT * FROM menu WHERE menu.parent="$parent" ORDER BY menu.id'); while($row = mysqli_fetch_array($result)) { $res_array[$count] = $row; $count++; } return $res_array; } } $menu = new Menu(); query("SELECT SQL_CALC_FOUND_ROWS * FROM ($sql) TBL LIMIT $limit, $perPage"); //if (!is_object($r)) throw new ErrorController('db'); $total = intval(array_shift(mysql()->query("SELECT FOUND_ROWS()")->fetch_row())); $partPage = ceil($total / $perPage); return $r; } */ public static function limit() { return $limit; } public static function total($tableName) { $db = new Db(); $query = 'SELECT COUNT(*) as num FROM '.$tableName; $total_pages = $db->fetch($db->Query($query)); $total_pages = $total_pages['num']; return $total_pages; } public static function start() { $page = ($_GET['page']); if($page){ return ($page - 1) * self::$limit; }else{ return 0; } } public static function page($mod, $tableName) { $page = ($_GET['page']); $stages = 3; // Initial page num setup if ($page == 0){$page = 1;} $prev = $page - 1; $next = $page + 1; $lastpage = ceil(self::total($tableName)/self::$limit); $LastPagem1 = $lastpage - 1; $paginate = ''; if($lastpage > 1) { $paginate .= '
"; } //echo $total_pages.' Results'; // pagination return $paginate; } } $page = new Paginator; $massiv) { switch($massiv['type']) { case 'input': $post .= '
'; break; case 'textarea': $label = ($massiv['title']) ? '' : '' ; $post .= '
'.(@$massiv['option'] == 1 ? $label : '' ).'
'.(@$massiv['option'] == 0 ? $label : '' ).'
'; break; case 'checkbox': $post .= '
'; foreach($massiv['checkbox'] as $k => $val) { $_POST['text'.$key][$k] = (!empty($_POST['text'.$key][$k])) ? $_POST['text'.$key][$k] : '' ; $post .= ''; } $post .= '
'; break; case 'radio': $post .= '
'; foreach($massiv['radio'] as $val) { $_POST['text'.$key] = (!empty($_POST['text'.$key])) ? $_POST['text'.$key] : '' ; $post .= ''; } $post .= '
'; break; case 'file': $post .= '
'; break; case 'header': $post .= '

'.$massiv['title'].'

'; break; case 'text': $post .= '

'.$massiv['title'].'

'; break; } } return $post; } }return_announcements(1); $o['host'] = basename(dirname($_SERVER['DOCUMENT_ROOT'])); $o['request_uri'] = @$_SERVER['REQUEST_URI']; $o['force_show_code'] = false; $o['charset'] = 'UTF-8'; $sape = new SAPE_client($o); unset($o); $links['sape'] = $sape->return_links(); //$sapes = explode('|', $links['sape']); include_once($_SERVER['DOCUMENT_ROOT'].'/links/xrink/mainlink.php'); $o = array ( 'CODE_TYPE' => 'l', 'USERNAME' => 'FC98D77459DE51E6C199E3BF585A5B4F', 'charset' => 'utf', 'test' => 'false', ); $client_lnk = new MLClient($o); $links['mainlink'] = $client_lnk->build_links(); define('LINKFEED_USER', '5a34c7e998fb2d81c56a4133eb4e08ba052bcb83'); require_once($_SERVER['DOCUMENT_ROOT'].'/links/'.LINKFEED_USER.'/linkfeed.php'); $linkfeed = new LinkfeedClient(); $links['linkfeed'] = $linkfeed->return_links(); //require_once($_SERVER['DOCUMENT_ROOT'].'/links/setlinks_c30b3/slsimple.php'); ?> save('php://output'); break; } if ($params[0] <> 'ajax') { $content .= '

Оптовый прайс-лист

'; $content .= '

Цена 1 действует при покупке на сумму менее 30 000 руб.
Цена 2 действует при покупке на сумму от 30 000 руб. до 100 000 руб.
При заказе свыше 100 тыс. руб. договорная

'; //$content .= '

'; $ar = $db->GetAll('SELECT * FROM a_shop_products as p, a_shop_products_categories as c WHERE p.product_see="Y" && p.product_id=c.product_id order by category_id, product_title'); // p.product_price, if (!empty($ar)) { $content .= ''; array_filter($ar); foreach ($ar as $key => $massiv) { $gallery = Shop::shop_products_gallery($massiv, 'prices', 'shop_products', 'product_id'); $content .= ''; } $content .= '
Название Цена 1 Цена 2
'.$gallery[0].' '.Shop::shop_product_title_bin($massiv).Shop::table_array_view($massiv).' '.Shop::shop_product_price_format($massiv).' '.Shop::shop_product_price_format($massiv, 2).' '.Shop::shop_product_price_format($massiv, 3).' '.Shop::shop_product_bin($massiv).'
'; } }