__('Question'), 'ROOM' => __('Room'), // 'COURSE' => __('Course'), // 'PAPER' => __('Paper'), ]; } public function getLevelList() { return ['1' => __('Level 1'), '2' => __('Level 2'), '3' => __('Level 3')]; } public function getUsesList() { return ['ALL' => __('ALL'), 'ONLY_MEMBER' => __('ONLY_MEMBER')]; } public function getIsFreeList() { return ['0' => __('is_free 0'), '1' => __('is_free 1')]; } public function getStatusList() { return ['0' => __('status 0'), '1' => __('status 1')]; } public function getIsLookList() { return ['0' => __('is_look 0'), '1' => __('is_look 1')]; } public function getKindTextAttr($value, $data) { $value = $value ? $value : ($data['kind'] ?? ''); $list = $this->getKindList(); return $list[$value] ?? ''; } public function getLevelTextAttr($value, $data) { $value = $value ? $value : ($data['level'] ?? ''); $list = $this->getLevelList(); return $list[$value] ?? ''; } /** * 组装筛选三级分类格式 * @param string $kind * @return array[] */ public static function threeLevel(string $kind) { $data = self::all(function ($query) use ($kind) { $query->where('status', '1')->where('kind', $kind)->order('sort desc'); }); $result = [ [ 'name' => '全部', 'value' => 'all', 'submenu' => [ 'name' => '全部', 'value' => 'all' ] ] ]; $level1 = []; $level2 = []; $level3 = []; // 分级 foreach ($data as $item) { switch ($item['level']) { case 1: array_push($level1, $item); break; case 2: array_push($level2, $item); break; case 3: array_push($level3, $item); break; } } // 先组装level2和level3的数据,即level1的子级 $level1_sub_menu = []; foreach ($level2 as $item2) { $sub_menu = []; foreach ($level3 as $item3) { if ($item3['parent_id'] == $item2['id']) { $sub_menu[] = [ 'name' => $item3['name'], 'value' => $item3['id'], ]; } } $level1_sub_menu[] = [ 'name' => $item2['name'], 'value' => $item2['id'], 'submenu' => $sub_menu, 'parent_id' => $item2['parent_id'] ]; } // 装载level1 foreach ($level1 as $item) { $level1_menu = [ 'name' => $item['name'], 'value' => $item['id'], ]; foreach ($level1_sub_menu as $sub_menu) { if ($sub_menu['parent_id'] == $item['id']) { $level1_menu['submenu'][] = $sub_menu; } } $result[] = $level1_menu; } return $result; } /** * 获取子分类id * @param $cate_id * @return array */ public static function getChildId($cate_id) { if (!$cate_id || is_nan($cate_id)) { return []; } $prefix = Config::get('database.prefix'); $table_name = "{$prefix}exam_cate"; $ids = Db::query(" SELECT id FROM {$table_name} WHERE parent_id = $cate_id UNION SELECT id FROM {$table_name} WHERE parent_id IN (SELECT id FROM {$table_name} WHERE parent_id = $cate_id) "); return $ids ? array_column($ids, 'id') : []; } /** * 组装三级分类格式 * @param string $kind * @param string $type * @return array[] */ public static function threeLevel2(string $kind, $type = '') { $data = self::all(function ($query) use ($kind, $type) { $query->where('status', '1')->where('kind', $kind)->order('sort desc'); if ($type == 'look') { $query->where('is_look', 1); } else if ($type == 'train') { $query->where('is_train', 1); } }); $result = []; $level1 = []; $level2 = []; $level3 = []; // 分级 foreach ($data as $item) { switch ($item['level']) { case 1: array_push($level1, $item); break; case 2: array_push($level2, $item); break; case 3: array_push($level3, $item); break; } } // 先组装level2和level3的数据,即level1的子级 $level1_sub_menu = []; foreach ($level2 as $item2) { $children = []; foreach ($level3 as $item3) { if ($item3['parent_id'] == $item2['id']) { $children[] = [ 'text' => $item3['name'] . self::memberSuffix($item3), 'value' => $item3['id'], ]; } } $level1_sub_menu[] = [ 'text' => $item2['name'] . self::memberSuffix($item2), 'value' => $item2['id'], 'children' => $children, 'parent_id' => $item2['parent_id'] ]; } // 装载level1 foreach ($level1 as $item) { $level1_menu = [ 'text' => $item['name'] . self::memberSuffix($item), 'value' => $item['id'], ]; foreach ($level1_sub_menu as $children) { if ($children['parent_id'] == $item['id']) { $level1_menu['children'][] = $children; } } $result[] = $level1_menu; } return $result; } /** * 会员标识后缀 * @param $cate * @return string */ public static function memberSuffix($cate) { if ($cate['uses'] == CateUses::ONLY_MEMBER) { return '(仅会员可用)'; } return ''; } /** * 获取顶级分类 * @param $cate_id * @return self */ public static function getTop($cate_id) { if (!$cate_id || !is_numeric($cate_id)) { return null; } $cate = self::get($cate_id); if (!$cate) { return null; } if (!$cate['parent_id']) { return $cate; } return self::getTop($cate['parent_id']); } /** * 获取分类上级名称 * @param $cate_id * @return array */ public static function getFullCates($cate_id) { $cate = self::get($cate_id); $cate_names = $cate['name']; $cate_ids = $cate_id; if ($cate['parent_id'] > 0) { $parent_cate = CateModel::get($cate['parent_id']); $cate_names = $parent_cate['name'] . '-' . $cate_names; $cate_ids = $parent_cate['id'] . ',' . $cate_ids; if ($parent_cate['parent_id'] > 0) { $top_parent_cate = CateModel::get($parent_cate['parent_id']); $cate_names = $top_parent_cate['name'] . '-' . $cate_names; $cate_ids = $top_parent_cate['id'] . ',' . $cate_ids; } } return [ 'cate_names' => $cate_names, 'cate_ids' => $cate_ids ]; } }