307 lines
9.7 KiB
PHP
307 lines
9.7 KiB
PHP
|
<?php
|
||
|
|
|
||
|
|
namespace app\model;
|
||
|
|
|
||
|
|
class Category extends Base
|
||
|
|
{
|
||
|
|
const AboutMarketId = 56;//关于市场顶级id
|
||
|
|
const ProductCategoryId = 57;//产品顶级id
|
||
|
|
const AquaticSupplyAndDemandId = 62;//水产供求顶级id
|
||
|
|
const NewsId = 58;//新闻顶级id
|
||
|
|
|
||
|
|
const indexAquaticSupplyDemandId = 74;//首页水产供求id(不是顶级栏目)
|
||
|
|
const indexAquacultureInformationId = 76;//首页水产养殖资讯id(不是顶级栏目)
|
||
|
|
|
||
|
|
const indexAquaticSeedlingId = 66;//首页水产鱼苗id(不是顶级栏目)
|
||
|
|
const indexFisheryFeedId = 67;//首页渔用饲料id(不是顶级栏目)
|
||
|
|
const indexDomesticFishWholesaleId = 68;//首页家鱼批发id(不是顶级栏目)
|
||
|
|
const indexSeafoodWholesaleId = 69;//首页海鲜批发id(不是顶级栏目)
|
||
|
|
const indexFisherySuppliesId = 70;//首页渔需物资id(不是顶级栏目)
|
||
|
|
|
||
|
|
|
||
|
|
//获取首页栏目ID
|
||
|
|
public static function getIndex()
|
||
|
|
{
|
||
|
|
return self::where('is_index', 1)->findOrEmpty()->toArray();
|
||
|
|
}
|
||
|
|
|
||
|
|
//根据上级ID和语言获取下级栏目
|
||
|
|
public static function getChildrenByParentId($parentId)
|
||
|
|
{
|
||
|
|
if ($parentId <= 0) {
|
||
|
|
return [];
|
||
|
|
}
|
||
|
|
$category = self::getById($parentId);
|
||
|
|
if (empty($category)) {
|
||
|
|
return [];
|
||
|
|
}
|
||
|
|
return self::alias('c')
|
||
|
|
->leftJoin('model m', 'c.model_id=m.id')
|
||
|
|
->field('c.*, m.manager, m.template, m.name as modelName')
|
||
|
|
->where('c.parent_id', $parentId)
|
||
|
|
->order('c.sort', 'asc')
|
||
|
|
->select()
|
||
|
|
->toArray();
|
||
|
|
}
|
||
|
|
|
||
|
|
//重写方法
|
||
|
|
public static function getById($categoryId)
|
||
|
|
{
|
||
|
|
return self::alias('c')
|
||
|
|
->leftJoin('model m', 'c.model_id = m.id')
|
||
|
|
->where('c.id', $categoryId)
|
||
|
|
->field('c.*, m.template')
|
||
|
|
->findOrEmpty()
|
||
|
|
->toArray();
|
||
|
|
}
|
||
|
|
|
||
|
|
//查看是否有下级栏目
|
||
|
|
public static function hasChildren($categoryId)
|
||
|
|
{
|
||
|
|
if (is_array($categoryId)) {
|
||
|
|
$count = self::where('parent_id', 'in', $categoryId)->count();
|
||
|
|
} else {
|
||
|
|
$count = self::where(['parent_id' => $categoryId])->count();
|
||
|
|
}
|
||
|
|
return $count ? true : false;
|
||
|
|
}
|
||
|
|
|
||
|
|
//获取前台菜单
|
||
|
|
public static function getListForFrontMenu()
|
||
|
|
{
|
||
|
|
$items = self::alias('c')
|
||
|
|
->leftJoin('model m', 'c.model_id=m.id')
|
||
|
|
->field('c.*, m.manager, m.template')
|
||
|
|
->where('c.state', 1)
|
||
|
|
->order('is_index desc, sort asc')
|
||
|
|
->select()
|
||
|
|
->toArray();
|
||
|
|
return self::getCates($items);
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* 获取栏目
|
||
|
|
* @param bool $limit 是否限制查询
|
||
|
|
* @param array $cates 需要限制查询的栏目IDs
|
||
|
|
*/
|
||
|
|
public static function getList($limit = false, $cates = [])
|
||
|
|
{
|
||
|
|
if ($limit && empty($cates)) {
|
||
|
|
return [];
|
||
|
|
}
|
||
|
|
return self::alias('c')
|
||
|
|
->leftJoin('model m', 'c.model_id=m.id')
|
||
|
|
->field('c.*, m.manager, m.name as modelName')
|
||
|
|
->when($limit, function ($query) use ($cates) {
|
||
|
|
$query->whereIn('c.id', $cates);
|
||
|
|
})
|
||
|
|
->order('sort', 'asc')
|
||
|
|
->select()
|
||
|
|
->toArray();
|
||
|
|
}
|
||
|
|
|
||
|
|
//获取栏目分级列表
|
||
|
|
public static function getListTree($isMenu = false)
|
||
|
|
{
|
||
|
|
if ($isMenu) {
|
||
|
|
$items = self::where('c.state', 1)->order('sort', 'asc')->select()->toArray();
|
||
|
|
} else {
|
||
|
|
$items = self::order('sort', 'asc')->select()->toArray();
|
||
|
|
}
|
||
|
|
return self::getCates($items);
|
||
|
|
}
|
||
|
|
|
||
|
|
//获取递归栏目
|
||
|
|
public static function getCates($cates, $parentId = 0)
|
||
|
|
{
|
||
|
|
$menus = [];
|
||
|
|
foreach ($cates as $cate) {
|
||
|
|
if ($cate['parent_id'] == $parentId) {
|
||
|
|
$children = self::getCates($cates, $cate['id']);
|
||
|
|
if (!empty($children)) {
|
||
|
|
$cate['children'] = $children;
|
||
|
|
}
|
||
|
|
$menus[] = $cate;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
return $menus;
|
||
|
|
}
|
||
|
|
|
||
|
|
public static function onAfterInsert($category)
|
||
|
|
{
|
||
|
|
$category->sort = $category->id;
|
||
|
|
$category->save();
|
||
|
|
}
|
||
|
|
|
||
|
|
//递归获取栏目名称面包屑
|
||
|
|
public static function getCatesCrumbs($currentId = 0)
|
||
|
|
{
|
||
|
|
$crumbs = [];
|
||
|
|
$category = self::getById($currentId);
|
||
|
|
if ($category) {
|
||
|
|
if ($category['parent_id'] != 0) {
|
||
|
|
$categoryIds = explode(',', trim($category['path'], ','));
|
||
|
|
$categories = self::where('id', 'in', $categoryIds)->column('*', 'id');
|
||
|
|
foreach ($categoryIds as $id) {
|
||
|
|
if (isset($categories[$id])) {
|
||
|
|
$crumbs[] = $categories[$id]['title'];
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
$crumbs[] = $category['title'];
|
||
|
|
}
|
||
|
|
return $crumbs;
|
||
|
|
}
|
||
|
|
|
||
|
|
//获取栏目中涉及到的文件
|
||
|
|
public static function getFilesInUse()
|
||
|
|
{
|
||
|
|
$items = self::select()->toArray();
|
||
|
|
$data = [];
|
||
|
|
foreach ($items as $item) {
|
||
|
|
$src = trim($item['src']);
|
||
|
|
if (!empty($src)) {
|
||
|
|
$key = getKeyByPath($src);
|
||
|
|
$data[$key] = $src;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
return $data;
|
||
|
|
}
|
||
|
|
|
||
|
|
//当前分类的最高级分类Id
|
||
|
|
public static function firstGradeById($id)
|
||
|
|
{
|
||
|
|
$res = 0;
|
||
|
|
$item = self::getById($id);
|
||
|
|
if ($item) {
|
||
|
|
$res = $id;
|
||
|
|
if ($item['parent_id'] > 0) {
|
||
|
|
$items = self::select()->toArray();
|
||
|
|
$first = self::getFirstGrade($items, $item['parent_id']);
|
||
|
|
if (!empty($first)) {
|
||
|
|
$res = $first['id'];
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
return $res;
|
||
|
|
}
|
||
|
|
|
||
|
|
public static function getFirstGrade($items, $parentId)
|
||
|
|
{
|
||
|
|
$data = [];
|
||
|
|
foreach ($items as $key => $item) {
|
||
|
|
if ($item['id'] == $parentId) {
|
||
|
|
if ($item['parent_id'] > 0) {
|
||
|
|
unset($items[$key]);
|
||
|
|
$parent = self::getFirstGrade($items, $item['parent_id']);
|
||
|
|
if (!empty($parent)) {
|
||
|
|
$data = $parent;
|
||
|
|
} else {
|
||
|
|
$data = $item;
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
$data = $item;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
return $data;
|
||
|
|
}
|
||
|
|
|
||
|
|
public static function getFooterMenu()
|
||
|
|
{
|
||
|
|
$items = self::alias('c')
|
||
|
|
->leftJoin('model m', 'c.model_id=m.id')
|
||
|
|
->field('c.*, m.manager, m.template')
|
||
|
|
->where('c.state', 1)
|
||
|
|
->where('c.id', "in", self::footer_menu_ids)
|
||
|
|
->whereOr('c.parent_id', "in", self::footer_menu_ids)
|
||
|
|
->order('is_index desc, sort asc')
|
||
|
|
->select()
|
||
|
|
->toArray();
|
||
|
|
return self::getCates($items);
|
||
|
|
}
|
||
|
|
|
||
|
|
public static function getChildrenIds($parentId)
|
||
|
|
{
|
||
|
|
return self::where("parent_id", $parentId)->column("id");
|
||
|
|
}
|
||
|
|
|
||
|
|
//获取当前位置
|
||
|
|
public static function getPosition($categoryId, $isIndex = true)
|
||
|
|
{
|
||
|
|
$position = "";
|
||
|
|
$getFirstGrade = self::alias('c')
|
||
|
|
->leftJoin('model m', 'c.model_id=m.id')
|
||
|
|
->field('c.*, m.manager, m.template, m.name as modelName')
|
||
|
|
->where("c.id", $categoryId)
|
||
|
|
->find()
|
||
|
|
->toArray();
|
||
|
|
|
||
|
|
if (!$getFirstGrade) return $position;
|
||
|
|
|
||
|
|
$position = '<a href="' . getUri($getFirstGrade) . '">' . $getFirstGrade["title"] . "</a> " . $position;
|
||
|
|
if (!in_array($getFirstGrade["parent_id"], [0, 1])) {
|
||
|
|
$position = (self::getPosition($getFirstGrade["parent_id"], false) . $position);
|
||
|
|
}
|
||
|
|
return ($isIndex ? "<a href='/'>首页</a>" : "") . $position;
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
public static function getProductNewsChildrenIds()
|
||
|
|
{
|
||
|
|
return self::where("parent_id","in",[
|
||
|
|
self::NewsId,
|
||
|
|
self::ProductCategoryId,
|
||
|
|
])->column("id");
|
||
|
|
}
|
||
|
|
// ----------web -------
|
||
|
|
//关于市场
|
||
|
|
public static function getAboutMarket()
|
||
|
|
{
|
||
|
|
$ids = self::where("parent_id", self::AboutMarketId)->column("id");
|
||
|
|
return self::alias('c')
|
||
|
|
->leftJoin('model m', 'c.model_id=m.id')
|
||
|
|
->field('c.*, m.manager, m.template, m.name as modelName')
|
||
|
|
->where('c.id', "in", $ids)
|
||
|
|
->order('c.sort', 'asc')
|
||
|
|
->select()
|
||
|
|
->toArray();
|
||
|
|
}
|
||
|
|
|
||
|
|
//产品展示
|
||
|
|
public static function getProduct()
|
||
|
|
{
|
||
|
|
return self::alias('c')
|
||
|
|
->leftJoin('model m', 'c.model_id=m.id')
|
||
|
|
->field('c.*, m.manager, m.template, m.name as modelName')
|
||
|
|
->where('c.parent_id', "=", self::ProductCategoryId)
|
||
|
|
->order('c.sort', 'asc')
|
||
|
|
->select()
|
||
|
|
->toArray();
|
||
|
|
}
|
||
|
|
|
||
|
|
//水产供求
|
||
|
|
public static function getAquaticSupplyAndDemand()
|
||
|
|
{
|
||
|
|
return self::alias('c')
|
||
|
|
->leftJoin('model m', 'c.model_id=m.id')
|
||
|
|
->field('c.*, m.manager, m.template, m.name as modelName')
|
||
|
|
->where('c.parent_id', "=", self::AquaticSupplyAndDemandId)
|
||
|
|
->order('c.sort', 'asc')
|
||
|
|
->select()
|
||
|
|
->toArray();
|
||
|
|
}
|
||
|
|
|
||
|
|
//新闻 市场动态
|
||
|
|
public static function getNews()
|
||
|
|
{
|
||
|
|
return self::alias('c')
|
||
|
|
->leftJoin('model m', 'c.model_id=m.id')
|
||
|
|
->field('c.*, m.manager, m.template, m.name as modelName')
|
||
|
|
->where('c.parent_id', "=", self::NewsId)
|
||
|
|
->order('c.sort', 'asc')
|
||
|
|
->select()
|
||
|
|
->toArray();
|
||
|
|
}
|
||
|
|
}
|