public function render() { $borderStyle = 'border-bottom-left-none'; $mainPathDiv = new Div(); $mainPathDiv->addStyleClass("main-path"); if (array_key_exists(UrlParameters::PAGE_NAME, $_GET)) { $pageName = Utils::getFromGET(UrlParameters::PAGE_NAME); /*log::temp('path-link render 1');*/ if (array_key_exists(UrlParameters::KEY, $_GET)) { /*log::temp('path-link render 2');*/ $navKeys = new DBNavKeyType(); if ($pageName == UrlParameters::PAGE__SINGLE_ITEM) { /*log::temp('path-link render 3');*/ $div = new Div(); $div->addStyleClasses(array($borderStyle, "font_arial", "float_left", "path_link_item", "text_non_select", "cursor_pointer")); $div->updateId("path_link"); $div->addAttribute(TagLabels::ON_CLICK, Utils::getWindowOnclickValue(URLBuilder::getPathLinkSingleItem())); $div->addChild($navKeys->getNameByKey(Utils::getFromGET(UrlParameters::KEY)) . " стр. " . Utils::getFromGET(UrlParameters::PAGE)); $mainPathDiv->addChild($div); $divContainer = new Div(); $divContainer->updateId('store_mode_container'); $div1 = new Div(); $div1->updateId('path_'); $divContainer->addChild($div1); $div2 = new Div(); $div2->updateId('path__'); $divContainer->addChild($div2); $mainPathDiv->addChild($divContainer); } echo $mainPathDiv->getHtml(); } } }
public function getAllLabels() { $navKeyType = new DBNavKeyType(); $navKeys = $navKeyType->getList(); $result = []; while ($row = mysql_fetch_array($navKeys)) { array_push($result, $row[DB::TABLE_NAV_KEY__VALUE]); } return $result; }
public function getLeafs() { $individual = array_key_exists(UrlParameters::CHECK_FIZ, $_GET) ? "g.individual='YES'" : ''; $person = array_key_exists(UrlParameters::CHECK_UR, $_GET) ? "g.person='YES'" : ''; $store = ''; if ($individual != '' && $person != '') { $store = " (" . $individual . " or " . $person . ") and "; } elseif ($individual == '' && $person != '') { $store = $person . " and "; } elseif ($individual != '' && $person == '') { $store = $individual . " and "; } $sqlCommand = "SELECT DISTINCT nk.* FROM nav_key nk, goods g WHERE " . $store . " nk.key_item=SUBSTRING(g.key_item, 1, 2)"; $navKeys = new DBNavKeyType(); return $navKeys->execute($sqlCommand); }
public static function getList() { $dbGoodsKeys = new DBNavKeyType(); $dbGoodsKeys->getList(); $ret = []; $resKeys = [DB::TABLE_NAV_KEY__ID, DB::TABLE_NAV_KEY__VALUE, DB::TABLE_NAV_KEY__KEY_ITEM, DB::TABLE_NAV_KEY__PARENT_KEY, DB::TABLE_NAV_KEY__HOME_VIEW]; $response = $dbGoodsKeys->getResponse(); while ($row = mysql_fetch_array($response)) { $item = []; foreach ($resKeys as $key) { $item[$key] = $row[$key]; } array_push($ret, $item); } return $ret; }
public function getItemsMenuData($pageNumber, $num, $key) { $goods = new DBGoodsType(); $navKeys = new DBNavKeyType(); $treeUtils = new TreeUtils(); $navKeys->executeRequest('', '', DB::TABLE_ORDER); $tree = $treeUtils->buildTreeByLeafs(); $keys = $treeUtils->getTreeLeafesForKey($tree, $key); $goods->getGoodsKeyCount($keys); $this->dataTotalCount = $goods->getTotalCount(); $limitBegin = ($pageNumber - 1) * $num; $limitEnd = $num; if ($this->isAdminOrderEnabled()) { $goods->getUserSortedForMenu($keys, $limitBegin, $limitEnd); } else { $str = implode('|', $keys); $goods->executeRequestRegExpWithLimit(DB::TABLE_NAV_KEY__KEY_ITEM, "^(" . $str . "){1}", DB::TABLE_GOODS___ORDER, DB::ASC, $limitBegin, $limitEnd); } $this->data = $goods->getResponse(); $this->dataCount = $goods->getResponseSize(); }
public function buildTreeByLeafs() { $navKeys = new DBNavKeyType(); $leafsMysql = $navKeys->getLeafs(); $leafs = array(); while ($row = mysql_fetch_array($leafsMysql)) { array_push($leafs, $row[DB::TABLE_NAV_KEY__KEY_ITEM]); } $navKeys->executeRequest('', '', DB::TABLE_NAV_KEY__ID, DB::ASC); //build full tree $mainTree = $this->buildTree($navKeys->getResponse(), "GN"); $this->clearTree($mainTree, $leafs); return $mainTree; }