function getSubCategories($catNo, $includeSelf, $catNameOrder = "ASC") { //use recursive $l = 0; $retArr = array(); if ($includeSelf == true) { $query = 'SELECT * FROM Category ' . 'WHERE ' . catNo . " = '{$catNo}'"; $result = DB::query($query, true); if ($result == null) { return null; } $retArr[$l++] = $result[0]; } $query = 'SELECT * FROM Category ' . 'WHERE ' . catParent . " = '{$catNo}' " . 'ORDER BY ' . catName . ' ' . $catNameOrder; $result = DB::query($query, false); if ($result === null) { return $retArr; } while ($row = $result->fetch_assoc()) { $subcatArr = getSubCategories($row[catNo], true, $catNameOrder); foreach ($subcatArr as $val) { $retArr[$l++] = $val; } } return $retArr; }
<?php error_reporting(E_ALL); $errors = array(); if (isset($_GET['classSchedId'])) { $classSchedId = $_GET['classSchedId']; } $chooseState = getAllState($dbconn); $majorCat = getMajorCategories($dbconn); $subCat = getSubCategories($dbconn); $schedClass = getSchClassAllInfo($dbconn, $classSchedId); $numReg = getCountParticipants($dbconn, $classSchedId); $contactId = $schedClass['contactId']; $allTrLocate = getAllTrLocations($dbconn, $contactId); $datetime = strtotime($schedClass['classDateTime']); $date = date('M/d/Y', $datetime); $time = date('h:i a', $datetime); try { if (isset($_POST['edit'])) { if ($_POST['classMaxParticipants'] < $numReg['total']) { $errors['classMaxParticipants'] = "You have more students registered than your new maximum number."; } //validators if (!is_numeric($_POST['classPrice'])) { $errors['classPrice'] = "Numbers only please"; } if (!is_numeric($_POST['classMaxParticipants'])) { $errors['classMaxParticipants'] = "Numbers only please"; } //Location validators if ($_POST['location'] == 'new') {
function getCategories() { $categories = getWpapi()->listcategories(); $categoryNames = array(); foreach ($categories as $c) { array_push($categoryNames, $c['*']); $subCategories = getSubCategories($c['*']); foreach ($subCategories as $sc) { array_push($categoryNames, $sc); } } return $categoryNames; }
function getSubCategories($parentid) { global $db, $current_language; $tbl_cat = MYSQL_TABLE_PREFIX . 'media_categories'; $p = (int) $parentid; $childIds = array(); $childs = $db->SelectList($tbl_cat, "*", "`parentid`=" . $p . " AND (`language` = '' OR `language` = '" . $current_language . "')"); foreach ($childs as $child) { $childIdsDummy = getSubCategories($child['categoryid']); foreach ($childIdsDummy as $childDummy) { $childIds[] = $childDummy['categoryid']; } $childIds[] = $child['categoryid']; } return $childIds; }
function getLefPanel($category_id, $acccnow = '', $active = '') { global $CI; $CI->load->model('category_model'); $sql = getSubCategories($category_id); if (count($sql) > 0) { echo $category_id != 0 ? '<ul>' : ''; foreach ($sql as $key => $value) { $parentCat = $CI->category_model->getSingleCategory($value['cat_parent']); $parentCatName = isset($parentCat['cat_title']) ? $parentCat['cat_title'] : ''; $image = ''; $catTitle = str_replace(' ', '_', strtolower(trim($value['cat_title']))); if ($category_id != 0) { $url = site_url() . 'product/' . strtolower(trim($parentCatName)) . '/' . $catTitle; } else { $url = site_url() . 'category/' . $catTitle; if (getSubCategories($value['cat_id'])) { $image = $acccnow == $value['cat_id'] ? '<img src="images/bullet3.png"/>' : '<img src="images/bullet4.png"/>'; } } $clsAccnow = $acccnow == $value['cat_id'] ? 'acccnow' : ''; $clsActive = $active == $value['cat_id'] || $acccnow == $value['cat_id'] ? 'active' : ''; echo '<li class="' . $clsAccnow . '"><a class="' . $clsActive . '" href="' . $url . '">' . $value['cat_title'] . $image . '</a>'; echo getLefPanel($value['cat_id'], $acccnow, $active); echo '</li>'; } echo $category_id != 0 ? '</ul>' : ''; } }
function getSalesSummaryByCat($suppNo, $catNo) { //if distNo not set --> get all district and return an array // $districts[distNo] --> result $category_famliy = getSubCategories($catNo, true); $condition = catNo . " IN("; foreach ($category_famliy as $c) { $condition .= "'" . $c[catNo] . "'" . ","; } $condition = rtrim($condition, ",") . ") "; $query = "SELECT Customer." . custGender . ", District." . distNo . ", District." . distName . ", OrderLine." . prodNo . ", Product." . prodName . ", Product." . prodPhoto . ", Product." . catNo . ", Category." . catName . ", SUM(OrderLine." . qty . ") AS Sold " . "FROM OrderLine " . "JOIN CustOrder ON OrderLine." . ordNo . " = CustOrder." . ordNo . " " . "JOIN Product ON Product." . prodNo . " = OrderLine." . prodNo . " " . "JOIN Category ON Product." . catNo . " = Category." . catNo . " " . "JOIN District ON CustOrder." . distNo . " = District." . distNo . " " . "JOIN Customer ON Customer." . custNo . " = CustOrder." . custNo . " " . "WHERE Product." . suppNo . " = '{$suppNo}' " . "AND Category." . $condition . "AND " . isDeleted . " = 0 " . "GROUP BY Product." . prodNo . " " . DB::genOrderByStr(func_get_args(), func_num_args(), 2); return DB::query($query); }
function getSubCategories($category_name, $levels) { if ($levels == 0) { return array(); } # result arrays $result = array(); $subcategories = array(); # get database and table names $db = wfGetDB(DB_SLAVE); extract($db->tableNames('page', 'categorylinks')); $cat_ns = NS_CATEGORY; # preparing categories $query_category = trim($category_name); $query_category = str_replace(' ', '_', $query_category); $query_category = str_replace("'", "\\'", $query_category); $sql = "SELECT p.page_title, p.page_namespace\n\t\t\tFROM {$categorylinks} cl\n\t\t\tJOIN {$page} p on cl.cl_from = p.page_id\n\t\t\tWHERE cl.cl_to = '{$query_category}'\n\t\t\tAND p.page_namespace = {$cat_ns}\n\t\t\tORDER BY cl.cl_sortkey"; $res = $db->query($sql); # parsing result while ($row = $db->fetchRow($res)) { $subcategories[] = $row[0]; $result[] = $row[0]; } $db->freeResult($res); # merging recursive foreach ($subcategories as $subcategory) { $result = array_merge($result, getSubCategories($subcategory, $levels - 1)); } return $result; }
//if updatedate is not the same date then look for online category version if ($updatetime[0] < date("Y-m-d")) { $res = $cs->GetCategories($req); $onlineversion = $res->getCategoryVersion(); } else { //else don't look - once a day is enough $onlineversion = $localversion; } } } } $a_start_cat = HTML_A_START . CURRENT_SCRIPT . '?catid=#&x=' . $x . '" style="cursor:hand">'; if ($catid) { $main_content .= HTML_B_START . AUCTIONS_TEXT_CATEGORIES_ROOT_PATH . HTML_B_END . HTML_HR . HTML_BR; $path = '<div width="275">' . getCategoryPath($catid) . '</div>'; $categories = getSubCategories($catid); $content = AUCTIONS_TEXT_CATEGORIES_SUB_CAT; } else { //if onlineversion is equal to offlineversion if ($localversion == $onlineversion) { if ($localversion) { $main_content .= HTML_NBSP . sprintf(AUCTIONS_TEXT_CATEGORIES_VERSION_OK, $localversion); insertVersion($onlineversion, date(AUCTIONS_DATE_FORMAT)); } } else { //download new category-tree $main_content .= HTML_NBSP . AUCTIONS_TEXT_CATEGORIES_DOWNLOAD . olc_draw_form("category", basename($PHP_SELF), 'post', EMPTY_STRING, 'onsubmit="check_submit()"') . olc_draw_submit_button('updatecat', AUCTIONS_TEXT_CATEGORIES_CAT_UPDATE) . "\n\t\t</form>\n"; } $path = EMPTY_STRING; $categories = getRootCategories(); $content = HTML_NBSP . AUCTIONS_TEXT_CATEGORIES_ROOT_CAT;
</div> <br> <label class="control-label">Sub-Category<span class="required">*</span></label> <div class="controls"> <select class="span4" name="subcategory" <?php echo isset($_GET['update']) ? "disabled" : ""; ?> > <?php $subcategories = getSubCategories(); while ($subcategory = mysqli_fetch_object($subcategories)) { echo "<option value=\"{$subcategory->subcategory_id}\" " . ($case ? $case->subcategory_id == $subcategory->subcategory_id ? "selected" : "" : "") . ">{$subcategory->subcategory_name}</option>"; } ?> </select> </div> </div> </div> </div>
getCountryDetails(); break; case 'getCustomerVoice': getCustomerVoice(); break; case 'getLocations': getLocations(); break; case 'getModels': getModels(); break; case 'getCategories': getCategories(); break; case 'getSubCategories': getSubCategories(); break; case 'getPartDetails': getPartDetails(); break; case 'notice_board': notice_board(); break; case 'getCVCirculars': getCvCirculars(); break; case 'getMcCirculars': getMcCirculars(); break; case 'getKtmModels': getKtmModels();
function getLefPanel($category_id, $acccnow = '', $active = '') { $sql = getSubCategories($category_id); if (count($sql) > 0) { echo $category_id != 0 ? '<ul>' : ''; foreach ($sql as $key => $value) { $image = ''; if ($category_id != 0) { $url = site_url() . '/product/cat/' . $value['cat_id'] . '/0/0'; } else { $url = site_url() . '/category/index/' . $value['cat_id']; if (getSubCategories($value['cat_id'])) { $image = $acccnow == $value['cat_id'] ? '<img src="images/bullet3.png"/>' : '<img src="images/bullet4.png"/>'; } } $clsAccnow = $acccnow == $value['cat_id'] ? 'acccnow' : ''; $clsActive = $active == $value['cat_id'] || $acccnow == $value['cat_id'] ? 'active' : ''; echo '<li class="' . $clsAccnow . '"><a class="' . $clsActive . '" href="' . $url . '">' . $value['cat_title'] . $image . '</a>'; echo getLefPanel($value['cat_id'], $acccnow, $active); echo '</li>'; } echo $category_id != 0 ? '</ul>' : ''; } }