$idsOne = []; $idsTwo = []; $idsThree = []; $ids = []; $gjc_catid = M('gjc_catid')->where(['gjcword_id' => $id])->select(); foreach ($gjc_catid as $index => $item) { if ($item['level'] == 3) { $idsThree[] = $item['category_id']; } if ($item['level'] == 2) { $idsTwo[] = $item['category_id']; } if ($item['level'] == 1) { $idsOne[] = $item['category_id']; } } if (!empty($idsOne)) { $idsOneList = M('category')->field('catid')->where(['parentid' => ['IN', $idsOne]])->select(); if (empty($idsOneList)) { //只有一级分类直接查询产品 $ids = $idsOne; } else { foreach ($idsOneList as $index => $item) { $idsTwo[] = $item['catid']; } $idsOneList2 = M('category')->field('catid')->where(['parentid' => ['IN', $idsTwo]])->select(); if (empty($idsOneList2)) { //判断是否有三级分类,没有直接查询产品 $ids = $idsTwo; } else { foreach ($idsOneList2 as $index => $item) { $idsThree[] = $item['catid']; } $ids = $idsThree; } } } if (!empty($idsTwo)) { //获取选择的一级分类下的二级分类 $idsTwoList = M('category')->field('catid')->where(['parentid' => ['IN', $idsOne]])->select(); foreach ($idsTwoList as $index => $item) { $idsTwo[] = $item['catid']; } //判断是否有三级分类 $idsThreeList = M('category')->field('catid')->where(['parentid' => ['IN', $idsTwo]])->select(); if (empty($idsThreeList)) { $ids = $idsTwo; } else { foreach ($idsThreeList as $index => $item) { $idsThree[] = $item['catid']; } $ids = $idsThree; } } if (!empty($idsThree)) { $ids = $idsThree; } $ids = array_unique($ids); // 产品查询条件 $products_where = []; // 审核状态 $products_where['status'] = array("EQ", 99); // 是否删除 $products_where['is_del'] = array("EQ", 0); if (!empty($ids)) { $products_where['catid'] = ['IN', $ids]; } $products = M('product')->where($products_where)->order('RAND()')->limit(12)->select(); $img = M('seoimage')->order('RAND()')->limit(16)->select(); $gjc = M('gjcword')->order('RAND()')->limit(45)->select(); // 聚合页面配置 $aggregate_pages = sp_get_aggregate_pages(); Acrylic Laser Engraving Machine