PHP mslib_befe::tep_get_categories_select Examples

Example #1

File: class.mslib_befe.php Project: bvbmedia/multishop

 public function tep_get_categories_select($categories_id = '0', $aid = '', $level = 0, $selectedid = '')
 {
     $qry = $GLOBALS['TYPO3_DB']->SELECTquery('cd.categories_name, c.categories_id, c.parent_id', 'tx_multishop_categories c, tx_multishop_categories_description cd', 'c.parent_id=\'' . $categories_id . '\' and c.status=1 and c.categories_id=cd.categories_id and c.page_uid=\'' . $this->shop_pid . '\'', '', 'c.sort_order, cd.categories_name', '');
     $parent_categories_query = $GLOBALS['TYPO3_DB']->sql_query($qry);
     $html = '';
     while (($parent_categories = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($parent_categories_query)) != false) {
         $html .= '<option value="' . $parent_categories['categories_id'] . '" ' . ($selectedid == $parent_categories['categories_id'] ? 'selected' : '') . '>';
         for ($i = 0; $i < $level; $i++) {
             $html .= '--';
         }
         $html .= $parent_categories['categories_name'] . '</option>';
         $strchk = $GLOBALS['TYPO3_DB']->SELECTquery('count(1) as total', 'tx_multishop_categories', 'c.parent_id=\'' . $parent_categories['categories_id'] . '\'', '', '', '');
         $qrychk = $GLOBALS['TYPO3_DB']->sql_query($strchk);
         $rowTotal = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($qrychk);
         if ($rowTotal['total']) {
             $html .= mslib_befe::tep_get_categories_select($parent_categories['categories_id'], $aid, $level + 1, $selectedid);
         }
     }
     if (!$categories_id) {
         $html .= '</select>';
     }
     return $html;
 }