Example #1
0
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;
}
Example #2
0
<?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') {
Example #3
0
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;
}
Example #4
0
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;
}
Example #5
0
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>' : '';
    }
}
Example #6
0
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>
Example #10
0
     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>' : '';
    }
}