PHP zen_get_sub_categoriesの例

コード例 #1

ファイル: easypopulate_4_export.php プロジェクト: gs125790/EasyPopulate-4.0

        $ep_dltype = 'full';
        // Complete Products
    } elseif ($_POST['ep_export_type'] == '1') {
        $ep_dltype = 'priceqty';
        // Model/Price/Qty
    } elseif ($_POST['ep_export_type'] == '2') {
        $ep_dltype = 'pricebreaks';
        // Model/Price/Breaks
    }
}
$sql_filter = '';
if (isset($_POST['ep_category_filter'])) {
    if (!empty($_POST['ep_category_filter'])) {
        $sub_categories = array();
        $categories_query_addition = 'ptoc.categories_id = ' . (int) $_POST['ep_category_filter'] . '';
        zen_get_sub_categories($sub_categories, $_POST['ep_category_filter']);
        foreach ($sub_categories as $key => $category) {
            $categories_query_addition .= ' OR ptoc.categories_id = ' . (int) $category . '';
        }
        $sql_filter .= ' AND (' . $categories_query_addition . ')';
    }
}
if (isset($_POST['ep_manufacturer_filter'])) {
    if ($_POST['ep_manufacturer_filter'] != '') {
        $sql_filter .= ' AND p.manufacturers_id = ' . (int) $_POST['ep_manufacturer_filter'];
    }
}
if (isset($_POST['ep_status_filter'])) {
    if ($_POST['ep_status_filter'] != '3') {
        $sql_filter .= ' AND p.products_status = ' . (int) $_POST['ep_status_filter'];
    }

コード例 #2

ファイル: easypopulate_4_functions.php プロジェクト: xiaoguizhidao/EasyPopulate-4.0

 function zen_get_sub_categories(&$categories, $categories_id)
 {
     global $db;
     $project = PROJECT_VERSION_MAJOR . '.' . PROJECT_VERSION_MINOR;
     $ep_uses_mysqli = PROJECT_VERSION_MAJOR > '1' || PROJECT_VERSION_MINOR >= '5.3' ? true : false;
     $sub_categories_query = $ep_uses_mysqli ? mysqli_query($db->link, "SELECT categories_id FROM " . TABLE_CATEGORIES . " WHERE parent_id = '" . (int) $categories_id . "'") : mysql_query("SELECT categories_id FROM " . TABLE_CATEGORIES . " WHERE parent_id = '" . (int) $categories_id . "'");
     while ($sub_categories = $ep_uses_mysqli ? mysqli_fetch_array($sub_categories_query) : mysql_fetch_array($sub_categories_query)) {
         if ($sub_categories['categories_id'] == 0) {
             return true;
         }
         $categories[sizeof($categories)] = $sub_categories['categories_id'];
         if ($sub_categories['categories_id'] != $categories_id) {
             zen_get_sub_categories($categories, $sub_categories['categories_id']);
         }
     }
 }