public_producer/app/JsonRpc/WebsiteService.php

<?php
namespace App\JsonRpc;

use App\Model\AdSize;
use App\Model\Article;

use App\Model\Ad;
use App\Model\Category;

use App\Model\AdPlace;
use App\Model\Department;
use App\Model\District;
use App\Model\FooterCategory;
use App\Model\FooterContent;
use App\Model\LetterOfComplaint;
use App\Model\Link;
use App\Model\TemplateClass;
use App\Model\Template;
use App\Model\User;
use App\Model\UserInfo;
use App\Model\WebsiteRole;
use App\Model\WebsiteRoleUser;
use App\Model\Website;
use App\Model\WebsiteColumn;
use App\Model\Sector;
use Hyperf\DbConnection\Db;
use Hyperf\RpcServer\Annotation\RpcService;
use App\Tools\Result;
use Carbon\Carbon;
use App\Model\WebsiteCategory;
use App\Model\WebsiteTemplate;
use App\Model\WebsiteTemplateInfo;
use Hamcrest\Arrays\IsArray;
use PhpParser\Node\Stmt\Return_;
use App\Model\WebsiteGroup;
use function PHPUnit\Framework\isNull;
use App\Model\Component;
// use Illuminate\Support\Facades\DB;
#[RpcService(name: "WebsiteService", protocol: "jsonrpc-http", server: "jsonrpc-http")]
class WebsiteService implements WebsiteServiceInterface
{
    /**
     * @param string $keyword
     * @param int $page
     * @param int $pageSize
     * @return array
     */
    public function getWebsitetList(array $data): array
    {
        // 构建查询
        $query = Website::when($data, function ($query) use ($data) {
            if (isset($data['keyword']) && !empty($data['keyword'])) {
                $query->where('website.website_name', 'like', '%' . trim($data['keyword']) . '%');
            }
            if (isset($data['website_column_id']) && !empty($data['website_column_id'])) {
                $query->whereJsonContains("website.website_column_arr_id", intval($data['website_column_id']));
            }
            if (isset($data['city_id']) && !empty($data['city_id'])) {
                $query->whereJsonContains("website.city_arr_id", intval($data['city_id']));
            }
        });

        // 执行查询并获取总数和结果
        $queryWithJoins = $query->leftJoin("website_column", "website.website_column_id", "website_column.id")
            ->leftJoin("district", "district.id", "website.city_id");

        $count = $queryWithJoins->count();
        $result = $queryWithJoins->select("website.*", "website_column.column_name", "district.name as city_name")
            ->limit($data['pageSize'])
            ->offset(($data['page'] - 1) * $data['pageSize'])
            ->orderBy("website.updated_at", "desc")
            ->get();
        if (empty($result)) {
            return Result::error("没有数据", 0);
        }
        $data = [
            'rows' => $result->toArray(),
            'count' => $count,
        ];
        return Result::success($data);
    }

    /**
     * @param array $data
     * @return array
     */
    public function createWebsite(array $data): array
    {
        var_dump("网站数据:", $data);
        $insertData = [
            'website_name' => $data['website_name'],
            'logo' => $data['logo'] ?? '',
            'website_url' => $data['website_url'] ?? '',
//           'city_id'=>$data['city_id']??0,
            'website_column_id' => $data['website_column_id'],
            'title' => $data['title'] ?? '',
            'keywords' => $data['keywords'] ?? '',
            'description' => $data['description'] ?? '',
            'status' => $data['status'] ?? 1,
            'website_column_arr_id' => $data['website_column_arr_id'],
//           'city_arr_id'=>$data['city_arr_id']??[0],
            'template_id' => $data['template_id'] ?? 0,
            'suffix' => $data['suffix'] ??"",
        ];
        $result = Website::insertGetId($insertData);
        if (empty($result)) {
            return Result::error("创建失败", 0);
        } else {
            return Result::success(["id" => $result]);
        }
    }

    /**
     * @param int $id
     * @param array $data
     * @return array
     */
    public function updateWebsite(int $id, array $data): array
    {
        $insertData = [
            'website_name' => $data['website_name'],
            'logo' => $data['logo'] ?? '',
            'website_url' => $data['website_url'] ?? '',
//           'city_id'=>$data['city_id']??0,
            'website_column_id' => $data['website_column_id'],
            'title' => $data['title'] ?? '',
            'keywords' => $data['keywords'] ?? '',
            'description' => $data['description'] ?? '',
//            'status' => $data['status'] ?? 0,
            'website_column_arr_id' => $data['website_column_arr_id'],
//           'city_arr_id'=>$data['city_arr_id']??[0],
            'template_id' => $data['template_id'] ?? 0,
            'suffix' => $data['suffix'] ??"",
        ];
        var_dump("=========:",$insertData);
        $result = Website::where('id', $id)->update($insertData);
        var_dump("更新站点", $result);
        if (empty($result)) {
            return Result::error("更新失败", 0);
        } else {
            return Result::success();
        }
    }

    /**
     * @param int $id
     * @return array
     */
    public function delWebsite(int $id): array
    {
        $result = Website::where('id', $id)->delete();
        if (empty($result)) {
            return Result::error("删除失败", 0);
        } else {
            return Result::success();
        }
    }

    /**
     * @param int $id
     * @return array
     */
    public function getWebsiteInfo(int $id): array
    {

        $where = [
            ['website.id', '=', $id],
        ];
        $result = Website::where($where)
            ->leftJoin("template", "template.id", "website.template_id")
            ->select("website.*", "template.template_name", "template.template_img")
            ->first();
        if (empty($result)) {
            return Result::error("数据不存在", 0);
        } else {
            return Result::success($result->toArray());
        }

    }

    /**
     * 查询所有的站点栏目
     * @return array
     */
    public function getWebsiteColumn(array $data): array
    {
        $result = WebsiteColumn::where($data)->get();
        if (empty($result)) {
            return Result::error("数据不存在", 0);
        } else {
            return Result::success($result->toArray());
        }

    }

    /**
     * @param string $keyword
     * @param int $page
     * @param int $pageSize
     * @return array
     */
    public function getWebsiteColumnList(array $data): array
    {
        $where = [];
        if (isset($data['keyword']) && $data['keyword']) {
            array_push($where, ['website_column.column_name', 'like', '%' . $data['keyword'] . '%']);
        }
        $result = WebsiteColumn::where($where)
            ->leftJoin("website_column as wc", "website_column.pid", "wc.id")
            ->select("website_column.*", "wc.column_name as parent_column_name")
            ->limit($data['pageSize'])->offset(($data['page'] - 1) * $data['pageSize'])->get();
        $count = WebsiteColumn::where($where)->count();
        if (empty($result)) {
            return Result::error("没有数据", 0);
        }
        $data = [
            'rows' => $result->toArray(),
            'count' => $count,
        ];
        return Result::success($data);
    }

    /**
     * @param array $data
     * @return array
     */
    public function createWebsiteColumn(array $data): array
    {
        $insertData = [
            'column_name' => $data['column_name'],
            'pid' => $data['pid'] ?? '',
            'column_arr_id' => $data['column_arr_id'] ?? [0],
            'sort' => $data['sort'] ?? 0,
            'remark' => $data['remark'] ?? '',
        ];
        $result = WebsiteColumn::insertGetId($insertData);
        if (empty($result)) {
            return Result::error("创建失败", 0);
        } else {
            return Result::success(["id" => $result]);
        }
    }

    /**
     * @param int $id
     * @param array $data
     * @return array
     */
    public function updateWebsiteColumn(int $id, array $data): array
    {
        $insertData = [
            'column_name' => $data['column_name'],
            'pid' => $data['pid'] ?? '',
            'column_arr_id' => $data['column_arr_id'] ?? [0],
            'sort' => $data['sort'] ?? 0,
            'remark' => $data['remark'] ?? '',
        ];
        $result = WebsiteColumn::where('id', $id)->update($insertData);
        if (empty($result)) {
            return Result::error("更新失败", 0);
        } else {
            return Result::success();
        }
    }

    /**
     * @param int $id
     * @return array
     */
    public function delWebsiteColumn(int $id): array
    {
        $list = WebsiteColumn::where(['pid' => $id])->get();
        if ($list) {
            return Result::error("存在子网系,不能删除,请先删除子网系", 0);
        }
        $result = WebsiteColumn::where('id', $id)->delete();
        if (empty($result)) {
            return Result::error("删除失败", 0);
        } else {
            return Result::success();
        }
    }

    /**
     * @param string $keyword
     * @param int $page
     * @param int $pageSize
     * @return array
     */
    public function getWebsiteRoleList(string $keyword, int $page, int $pageSize, int $websiteId): array
    {
        $where = [
            ['role.role_name', 'like', '%' . $keyword . '%'],
            ['website_role.website_id', '=', $websiteId],
        ];
        $result = WebsiteRole::where($where)
            ->leftJoin("role", "role.id", "website_role.role_id")
            ->select("role.*", "website_role.type", "website_role.role_id", "website_role.id as website_role_id", "website_role.website_id")
            ->limit($pageSize)->offset(($page - 1) * $pageSize)->get();
        $count = WebsiteRole::where($where)->leftJoin("role", "role.id", "website_role.role_id")->count();
        if (empty($result)) {
            return Result::error("没有数据", 0);
        }
        $data = [
            'rows' => $result->toArray(),
            'count' => $count,
        ];
        return Result::success($data);
    }

    /**
     * @param array $data
     * @return array
     */
    public function createWebsiteRole(array $data): array
    {

        $insertData = [
            'website_id' => $data['website_id'],
            'role_id' => $data['role_id'] ?? '',
        ];
        $info = WebsiteRole::where($insertData)->first();
        if ($info) {
            return Result::error("不能重复添加角色", 0);
        }
        $insertData['admin_user_id'] = $data['admin_user_id'] ?? '';
        $insertData['type'] = $data['type'] ?? '';
        $result = WebsiteRole::insertGetId($insertData);
        if (empty($result)) {
            return Result::error("创建失败", 0);
        } else {
            return Result::success(["id" => $result]);
        }
    }

    /**
     * 暂时用不上
     * @param int $id
     * @param array $data
     * @return array
     */
    public function updateWebsiteRole(int $id, array $data): array
    {
        $insertData = [
            'website_id' => $data['website_id'],
            'type' => $data['type'] ?? '',
        ];
        $result = WebsiteRole::where('id', $id)->update($insertData);
        if (empty($result)) {
            return Result::error("更新失败", 0);
        } else {
            return Result::success();
        }
    }

    /**
     * @param int $id
     * @return array
     */
    public function delWebsiteRole(int $id): array
    {
        $result = WebsiteRole::where('id', $id)->delete();
        if (empty($result)) {
            return Result::error("删除失败", 0);
        } else {
            return Result::success();
        }
    }

    /**
     * @param string $keyword
     * @param int $page
     * @param int $pageSize
     * @return array
     */
    public function getWebsiteRoleUserList(string $keyword, int $page, int $pageSize, int $websiteId, int $roleId): array
    {
        $where = [
            ['website_role_user.website_id', '=', $websiteId],
            ['website_role_user.role_id', '=', $roleId],
        ];
        $count = WebsiteRoleUser::where($where)->count();
        $where[] = ['u.user_name', 'like', '%' . $keyword . '%'];
        $result = WebsiteRoleUser::where($where)
            ->leftJoin("user as u", "website_role_user.user_id", "u.id")
            ->leftJoin("website as w", "website_role_user.website_id", "u.id")
            ->leftJoin("role as r", "website_role_user.role_id", "r.id")
            ->select("u.*", "u.user_name", 'w.website_name', 'r.role_name', 'website_role_user.id as website_role_user_id', 'website_role_user.updated_at as user_update_at')
            ->limit($pageSize)->offset(($page - 1) * $pageSize)->get();

        if (empty($result)) {
            return Result::error("没有数据", 0);
        }
        $data = [
            'rows' => $result->toArray(),
            'count' => $count,
        ];
        return Result::success($data);
    }

    /**
     * @param array $data
     * @return array
     */
    public function createWebsiteRoleUser(array $data): array
    {
        $insertData = [
            'website_id' => $data['website_id'],
            'user_id' => $data['user_id'] ?? '',
        ];
        $info = WebsiteRoleUser::where($insertData)->first();
        if ($info) {
            return Result::error("不能重复添加角色用户", 0);
        }
        $insertData['role_id'] = $data['role_id'] ?? '';
        $insertData['admin_user_id'] = $data['admin_user_id'] ?? '';
        $insertData['type'] = $data['type'] ?? '';
        $result = WebsiteRoleUser::insertGetId($insertData);
        if (empty($result)) {
            return Result::error("创建失败", 0);
        } else {
            return Result::success(["id" => $result]);
        }
    }

    /**
     * @param int $id
     * @param array $data
     * @return array
     */
    public function updateWebsiteRoleUser(int $id, array $data): array
    {
        $insertData = [
            'website_id' => $data['website_id'],
            'type' => $data['type'] ?? '',
            'type_id' => $data['type_id'] ?? '',
            'role_id' => $data['role_id'] ?? '',
        ];
        $result = WebsiteRoleUser::where('id', $id)->update($insertData);
        if (empty($result)) {
            return Result::error("更新失败", 0);
        } else {
            return Result::success();
        }
    }

    /**
     * @param int $id
     * @return array
     */
    public function delWebsiteRoleUser(int $id): array
    {
        $result = WebsiteRoleUser::where('id', $id)->delete();
        if (empty($result)) {
            return Result::error("删除失败", 0);
        } else {
            return Result::success();
        }
    }

    /**
     * 根据域名获取网站 站点id
     * @param array $data
     * @return array
     */
    public function getWebsiteId(array $data): array
    {
        $result = Website::whereJsonContains('website_url', $data['website_url'])->first();
        if (empty($result)) {
            return Result::error("查询站点失败", 0);
        } else {
            return Result::success($result);
        }
    }

    /**
     * 查询网站下面的导航
     * @param array $data
     * @return array
     */
    public function getWebsiteCategory(array $data): array
    {
        $where = [
            'website_id' => $data['website_id'],
        ];
        // 使用递归查询构建树状结构
        $category = WebsiteCategory::where($where)
            ->with([
                'children' => function ($query) {
                    $query->orderBy('sort', 'asc');
                },
            ])
            ->orderBy('sort', 'asc')
            ->where('pid', 0) // 仅查询顶级节点
            ->get()->all();
        if (empty($category)) {
            return Result::error("查询站点栏目失败", 0);
        } else {
            $count = WebsiteCategory::where($where)->count();
            $result = [
                'rep' => $category,
                'count' => $count,
            ];
            return Result::success($result);
        }
    }

    /**
     * 查询网站的广告
     * @param array $data
     * @return array
     */
    public function getWebsiteAdvertisement(array $data): array
    {
        $where = [
            'ad_place.status' => 1,
        ];
        if (isset($data['ad_tag']) && !empty($data['ad_tag'])) {
            $now = Carbon::now()->format('Y-m-d H:i:s'); // 获取当前时间
            $where[] = ['ad_place.ad_tag','like','%'.$data['ad_tag'].'%'];
            // return Result::success($where);
            $result =  AdPlace::where($where)
            ->leftJoin("ad", function ($join) use ($now) {
                $join->on("ad.pid", "=", "ad_place.id")
                     ->where('ad.status', 1)
                     ->where('ad.fromtime', '<=', $now)
                     ->where('ad.totime', '>=', $now);
            })
            ->select("ad_place.*",'ad.*',"ad_place.id as ad_place_id","ad.name as ad_name")
            ->get()->all();
            if(empty($result)){
                return Result::error("此广告位不存在！",0);
            } 
        }else{
            return Result::error("请选择广告位！",0);
        }
        return Result::success($result);

    }

    /**
     *
     * @param array $data
     * @return array
     */
    /**网站行政职能搜索 */
    public function selectWebsiteDepartment(array $data): array
    {

        $depart = Department::where('pid',0)->orderBy('id','asc')->get(); 
        if(isset($data['keyword']) && !empty($data['keyword'])){ 
            $departments= Department::where('name', 'like', '%' . $data['keyword'] . '%')->get();
            if(empty($departments)){
                $result['message']="未查询到与此相关职能部门"; 
            }else{ 
                $count = Department::where('name','like',"%{$data['keyword']}%")->count();
                $m = [
                    'department'=>$depart, 
                    'type'=>$departments,
                    'count'=>$count
                ]; 
            }
            
            $result['sele'] = $m; 
            return Result::success($result['sele']); 
            
        }
        $result=$depart;
        return Result::success($result); 
    }

    /**
     * 搜索地区
     * @param array $data 
     * @return array 
     */ 
    public function selectWebsiteArea(array $data): array 
    { 
        // return Result::success($data);
        $pid = $data['pid'] ?? 0;
        $result = District::where('pid',$pid)->where('status',1)->orderBy('code')->get();
        if(empty($result)){
            return Result::error("未查询到此地区",0);
        }else{
            return Result::success($result);
        }
    }

    /**
     * 获取栏目
     * @param array $data
     * @return array
     */

    public function getWebsiteModelCategory(array $data): array
    {
        // return Result::success($data);
        $website_id=[ 
            'website_id' => $data['website_id'] 
        ];
        // 初始化 $pid 数组
        // $pid = [];
        // 以下注释掉的代码是之前的逻辑，用于获取非顶级分类的 pid
        $pid = WebsiteCategory::where($website_id)
            ->where('pid', '!=', 0)
            ->pluck('pid');
        $pid = array_values(array_unique($pid->toArray()));

        // 构建查询语句
        $query = WebsiteCategory::where($website_id)
            ->where('pid', $data['pid'])
            ->offset($data['placeid'])
            ->limit($data['num'])
            ->orderBy('sort');
        // 如果 $pid 数组不为空，添加 CASE WHEN 条件
        if (!empty($pid)) {
            $placeholders = implode(',', array_fill(0, count($pid), '?'));
            $query->selectRaw("website_category.*, CASE WHEN website_category.category_id IN ($placeholders) THEN 1 ELSE 0 END AS children_count", $pid);
        } else {
            // 如果 $pid 数组为空，不添加 CASE WHEN 条件，添加字段 children_count 并赋值为 0
            $query->select('website_category.*', DB::raw('0 as children_count'));
        }

        // 执行查询
        $placeid = $data['placeid']-1;
        $result = $query->offset($placeid)->limit($data['num'])->get();
        if(!empty($result)){ 
            return Result::success($result);  
        }else{ 
            return Result::error("本网站暂无栏目",0);  
        } 
    } 

    /**
     * 获取友情链接
     * @param array $data
     * @return array
     */

    public function selectWebsiteLinks(array $data): array
    {
        $where = [
            'website_id' => $data['website_id'],
            'status' => 1,
            'type' => $data['type'],
        ];
        $num = $data['num'];
        $result = Link::where($where)->orderBy('sort')->limit($num)->get();
        if (!empty($result)) {
            return Result::success($result);
        } else {
            return Result::error("本网站暂无此类型友情链接", 0);
        }
    }

    /**
     * 网站首页数据统计， 管理员
     * @return void
     */
    public function getAdminIndex(array $data): array
    {
        var_dump("用户类型：", $data['type_id']);
        switch ($data['type_id']) {
            case 4:
                $result = Db::select('SELECT  DATE(created_at) AS date,COUNT(*) AS total_count FROM  letter_of_complaint  WHERE  created_at >= CURDATE() - INTERVAL 30 DAY  GROUP BY  DATE(created_at)  ORDER BY  date ASC;');
                return Result::success($result);
                break;
            case 10000:
                $res = [];
                //网站
                $res['website']['count'] = 0;
                $res['website']['growth_rate'] = 0;
                //资讯
                $res['article']['count'] = 0;
                $res['article']['growth_rate'] = 0;
                //导航池
                $res['category']['count'] = 0;
                $res['category']['growth_rate'] = 0;
                //近一月数据
                $res['monthArticle'] = [];
                //用户类型
                $res['userType'] = [];
                $res['website']['count'] = Website::where([])->count();
                $res['article']['count'] = Article::whereNotIn('status', ['404'])->count();
                $res['category']['count'] = Category::where([])->count();
                $res['monthArticle'] = Db::select('SELECT  DATE(created_at) AS date,COUNT(*) AS total_count FROM  article  WHERE  created_at >= CURDATE() - INTERVAL 30 DAY  GROUP BY  DATE(created_at)  ORDER BY  date ASC;');
                $res['userType'] = User::where([])->selectRaw("count(*) as counts,type_id")->groupBy('type_id')->get();
                return Result::success($res);

        }

        return [];
    }

    /**
     * 获取模板类型
     * @return void
     */
    public function getTemplateClass(array $data): array
    {
        $where = [];
        if (isset($data['name']) && $data['name']) {
            array_push($where, ['name', 'like', '%' . $data['name'] . '%']);
        }
        $result = TemplateClass::where($where)->orderBy('sort', 'asc')->get();
        if (empty($result)) {
            return Result::error("没有模板类型", 0);
        } else {
            return Result::success($result);
        }
    }

    /**
     * 添加模板类型
     * @param
     * @return void
     */
    public function addTemplateClass(array $data): array
    {
        $insertData = [
            'name' => $data['name'],
        ];
        $result = TemplateClass::insertGetId($insertData);
        if (empty($result)) {
            return Result::error("创建失败", 0);
        } else {
            return Result::success(["id" => $result]);
        }
    }

    /**
     * 更新模板
     * @param array $data
     * @return array
     */
    public function upTemplateClass(array $data): array
    {
        $where = [
            'id' => $data['id'],
        ];
        $insertData = [
            'name' => $data['name'],
        ];
        $result = TemplateClass::where($where)->update($insertData);
        if (empty($result)) {
            return Result::error("更新失败", 0);
        } else {
            return Result::success();
        }
    }

    /**
     * 删除模板
     * @param array $data
     * @return array
     */
    public function delTemplateClass(array $data): array
    {
        $where = [
            'id' => $data['id'],
        ];

        $result = TemplateClass::where($where)->delete();
        if (empty($result)) {
            return Result::error("删除失败", 0);
        } else {
            return Result::success();
        }
    }

    /**
     * 获取分类下的模板
     * @param array $data
     * @return array
     */
    public function getTemplate(array $data): array
    {
        $page = $data['page'];
        $pageSize = $data['pageSize'];
        $where = [];
        if (isset($data['template_class_id']) && $data['template_class_id']) {
            array_push($where, ['template_class_id', '=', $data['template_class_id']]);
        }
        $result = Template::where($where)
            ->limit($pageSize)->offset(($page - 1) * $pageSize)->get();
        $count = Template::where($where)->count();
        if (empty($result)) {
            return Result::error("没有数据", 0);
        }
        $data = [
            'rows' => $result->toArray(),
            'count' => $count,
        ];
        return Result::success($data);
    }

    /**
     * 创建模板
     * @param
     * @return void
     */
    public function addTemplate(array $data): array
    {
        $insertData = [
            'template_name' => $data['template_name'],
            'template_img' => json_encode($data['template_img']),
            'template_class_id' => $data['template_class_id'],
        ];
        $result = Template::insertGetId($insertData);
        if (empty($result)) {
            return Result::error("创建模板失败", 0);
        } else {
            return Result::success(["id" => $result]);
        }
    }

    /**
     * 更新模板
     * @param array $data
     * @return array
     */
    public function upTemplate(array $data): array
    {
        $where = [
            'id' => $data['id'],
        ];
        $insertData = [
            'template_name' => $data['template_name'],
            'template_img' => json_encode($data['template_img']),
            'template_class_id' => $data['template_class_id'],
        ];
        $result = Template::where($where)->update($insertData);
        if (empty($result)) {
            return Result::error("更新模板失败", 0);
        } else {
            return Result::success();
        }
    }

    /**
     * 删除模板
     * @param array $data
     * @return array
     */
    public function delTemplate(array $data): array
    {
        $where = [
            'id' => $data['id'],
        ];
        $result = Template::where($where)->delete();
        if (empty($result)) {
            return Result::error("删除模板失败", 0);
        } else {
            return Result::success();
        }
    }

    /**
     * 搜索网站
     * @param array $data
     * @return array
     */
    public function websiteList(array $data): array
    {
        $where = [];
        if (isset($data['keyword']) && !empty($data['keyword'])) {
            array_push($where, ['website.website_name', 'like', '%' . $data['keyword'] . '%']);
        }
        $result = Website::where($where)->get();
        if ($result) {
            return Result::success($result);
        } else {
            return Result::error("没有网站", 0);
        }
    }

    public function addWebsiteCategory(array $data): array
    {
        $website_id = $data['website_id'];
        $category_arr_id = $data['category_arr_id'];
        $categoryList = Category::whereIn('id', $category_arr_id)->get();
        $categoryListIds = [];
        if ($categoryList) {
            foreach ($categoryList->toArray() as $val) {
                array_push($categoryListIds, $val['id']);
            }
        }
        $arr = [];
        if ($categoryListIds) {
            foreach ($categoryListIds as $v) {
                $ids = $this->getUnderlingUIds(intval($v));
                $ids_arr = explode(",", $ids);
                array_push($arr, $ids_arr);
            }
        }
        $mergedArray = [];
        foreach ($arr as $subarray) {
            $mergedArray = array_merge($mergedArray, $subarray);
        }
        var_dump("所有:", $arr, $mergedArray);
        //查询出所有的分类进行分割插入 组装数据
        $categoryListData = Category::whereIn('id', $mergedArray)->get();
        $categoryListData = $categoryListData->toArray();
        $insertData = [];
        if ($categoryListData) {
            foreach ($categoryListData as $key => $value) {
                $insertData[$key]['website_id'] = $website_id;
                $insertData[$key]['name'] = $value['name'];
                $insertData[$key]['sort'] = $value['sort'];
                $insertData[$key]['pid'] = $value['pid'];
                $insertData[$key]['pid_arr'] = $value['pid_arr'];
                $insertData[$key]['seo_title'] = $value['seo_title'];
                $insertData[$key]['seo_keywords'] = $value['seo_keywords'];
                $insertData[$key]['seo_description'] = $value['seo_description'];
                $insertData[$key]['alias'] = $value['name'];
                $insertData[$key]['category_id'] = $value['id'];
            }
        }
        $result = WebsiteCategory::insert($insertData);
        var_dump("插入数据状态：", $result);
        if ($result) {
            return Result::success($result);
        } else {
            return Result::error("创建失败", 0);
        }
    }

    /**
     * 删除网站导航
     * @param array $data
     * @return array
     */
    public function delWebsiteCategory(array $data): array
    {
        $website_id = $data['website_id'] ?? 0;
        $category_id = $data['category_id'] ?? 0;
        $ids = $this->getUnderlingUIds(intval($category_id));
        $ids_arr = explode(",", $ids);
        $result = WebsiteCategory::where(['website_id' => $website_id])->whereIn("category_id", $ids_arr)->delete();
        if ($result) {
            return Result::success($result);
        } else {
            return Result::error("删除失败", 0);
        }
    }

    /**
     * 获取网站导航
     * @param array $data
     * @return array
     */
    public function getAdminWebsiteCategory(array $data): array
    {
        $where = [
            'website_id' => $data['website_id'],
        ];
        $result = WebsiteCategory::where($where)->orderBy('sort', 'asc')->get();
        $list = [];
        if($result){
            foreach ($result->toArray() as $val) {
                array_push($list, json_decode($val['category_arr_id']));
            }
        }
        if ($result) {
            return Result::success($list);
        } else {
            return Result::error("查询失败", 0);
        }
    }

    /**
     * 更新网站导航
     * @param array $data
     * @return array
     */
    public function upWebsiteCategory(array $data): array
    {
        Db::beginTransaction();
        try {
             if($data['category_arr_id']){
                 $oldCategoryList = WebsiteCategory::where(['website_id' => $data['website_id']])->get();
                 if($oldCategoryList){
                     $oldCategoryList = $oldCategoryList->toArray();
                     $oldCategoryListIds = [];
                     foreach ($oldCategoryList as $val) {
                         array_push($oldCategoryListIds, $val['category_id']);
                     }
                     $newCategoryListIds = [];
                     foreach ($data['category_arr_id'] as $v){
                         array_push($newCategoryListIds, end($v));
                     }
                     $differenceIDS = array_merge(array_diff($oldCategoryListIds, $newCategoryListIds), array_diff($newCategoryListIds, $oldCategoryListIds));
                     if($differenceIDS){
                         foreach ($differenceIDS as $v){
                             WebsiteCategory::where(['website_id' => $data['website_id'], 'category_id' => $v])->delete();
                         }
                     }
                     foreach ($data['category_arr_id'] as $key => $value){
                         $info = Category::where(['id' => end($value)])->first();
                         $info = $info->toArray();
                         // 假设 $data、$value 和 $info 是已经定义好的变量
                         $attributes = [
                             'website_id' => $data['website_id'],
                             'category_id' => end($value)
                         ];
                        // 先复制一份要更新或创建的数据
                         $values = [
                             'website_id' => $data['website_id'],
                             'name' => $info['name']?? '',
                             'alias' => $info['name']?? '',
                             'sort' => $info['sort']?? 0,
                             'pid' => $info['pid']?? 0,
                             'pid_arr' => $info['pid_arr']?? json_encode([]),
                             'seo_title' => $info['seo_title']?? "",
                             'seo_keywords' => $info['seo_keywords']?? "",
                             'seo_description' => $info['seo_description']?? "",
                             'is_url' => $info['is_url']?? 0,
                             'web_url' => $info['web_url']?? '',
                             'category_id' => end($value),
                             'category_arr_id' => $value? json_encode($value) : json_encode([])
                         ];
                        // 检查数据库中是否已有该记录
                         $existingRecord = WebsiteCategory::where($attributes)->first();
                         if ($existingRecord && $existingRecord->name) {
                             unset($values['name']);
                         }
                         if ($existingRecord && $existingRecord->sort>=0) {
                             unset($values['sort']);
                         }
                         if ($existingRecord && $existingRecord->seo_title) {
                             unset($values['seo_title']);
                         }
                         if ($existingRecord && $existingRecord->seo_keywords) {
                             unset($values['seo_keywords']);
                         }
                         if ($existingRecord && $existingRecord->seo_description) {
                             unset($values['seo_description']);
                         }
                         if ($existingRecord && $existingRecord->alias) {
                             unset($values['alias']);
                         }
                        // 执行 updateOrCreate 操作
                         WebsiteCategory::updateOrCreate($attributes, $values);
                     }
                 }
             }
            Db::commit();
            return Result::success();
        } catch (\Throwable $ex) {
            Db::rollBack();
//            var_dump($ex->getMessage());
            return Result::error("修改失败".$ex->getMessage(), 0);
        }


    }

    /**
     * 获取网站列表
     * @param array $data
     * @return array
     */
    public function getWebsiteCategoryList(array $data): array
    {
        $where = [];
        if (isset($data['keyword']) && !empty($data['keyword'])) {
            array_push($where, ['website.website_name', 'like', '%' . $data['keyword'] . '%']);
        }
        if (isset($data['website_column_id']) && !empty($data['website_column_id'])) {
            array_push($where, ['website.website_column_id', '=', $data['website_column_id']]);
        }
        $result = Website::where($where)
            ->with(["websiteCategory" => function ($query) {
                $query->where(['pid' => 0])->select('website_id', 'name', 'alias', 'category_id');
            }])
            ->limit($data['pageSize'])->orderBy("updated_at", "desc")->offset(($data['page'] - 1) * $data['pageSize'])
            ->get();

        $count = Website::where($where)->count();
        if (empty($result)) {
            return Result::error("没有数据", 0);
        }
        $data = [
            'rows' => $result->toArray(),
            'count' => $count,
        ];
        if ($result) {
            return Result::success($data);
        } else {
            return Result::error("查询失败", 0);
        }
    }

    /**
     * 删除网站下的所有导航
     * @param array $data
     * @return array
     */
    public function delWebsiteAllCategory(array $data): array
    {
        $website_id = $data['website_id'];
        $result = WebsiteCategory::where(['website_id' => $website_id])->delete();

        if ($result) {
            return Result::success($result);
        } else {
            return Result::error("删除失败", 0);
        }
    }

    /**
     * 获取网站下的某一个导航
     * @param array $data
     * @return array
     */
    public function getWebsiteCategoryOnes(array $data): array
    {
        $website_id = $data['website_id'];
        $category_id = $data['category_id'];
        $result = WebsiteCategory::where(['website_category.website_id' => $website_id, 'website_category.category_id' => $category_id])
            ->first();
        if ($result) {
            return Result::success($result);
        } else {
            return Result::error("查询失败", 0);
        }
    }

    /**
     * 更新网闸下的某一个导航
     * @param array $data
     * @return array
     */
    public function upWebsiteCategoryones(array $data): array
    {
        $where = [
            'website_id' => $data['website_id'],
            'category_id' => $data['category_id'],
        ];
        $data['sort'] = $data['sort'] ?? 0;
        $result = WebsiteCategory::where($where)->update($data);
        if ($result) {
            return Result::success($result);
        } else {
            return Result::error("更新失败", 0);
        }
    }

    /**
     * 获取网站下的所有导航（包含子导航）
     * @param array $data
     * @return array
     */
    public function getWebsiteAllCategory(array $data): array
    {
        $where = [];
        if (isset($data['website_id']) && !empty($data['website_id'])) {
            array_push($where, ['website_category.website_id', '=', $data['website_id']]);
        }
//        if (isset($data['name']) && !empty($data['name'])) {
//            array_push($where, ['website_category.name', 'like', '%' . $data['name'] . '%']);
//        }
//        if (isset($data['alias']) && !empty($data['alias'])) {
//            array_push($where, ['website_category.alias', 'like', '%' . $data['alias'] . '%']);
//        }
//        if (isset($data['department_id']) && !empty($data['department_id'])) {
//            array_push($where, ['category.department_id', '=', $data['department_id']]);
//        }
//        if (isset($data['city_id']) && !empty($data['city_id'])) {
//            array_push($where, ['category.city_id', '=', $data['city_id']]);
//        }
        $result = WebsiteCategory::where($where)
//            ->leftJoin("category", 'website_category.category_id', 'category.id')
//            ->leftJoin("department", 'category.department_id', 'department.id')
//            ->leftJoin("district", 'category.city_id', 'district.id')
//            ->select("website_category.*", "department.name as department_name", "district.name as city_name")
//            ->limit($data['pageSize'])->offset(($data['page'] - 1) * $data['pageSize'])
            ->orderBy("sort","asc")
            ->get();

//        $count = WebsiteCategory::where($where)
//            ->leftJoin("category", 'website_category.category_id', 'category.id')
//            ->leftJoin("department", 'category.department_id', 'department.id')
//            ->leftJoin("district", 'category.city_id', 'district.id')
//            ->count();
        if (empty($result)) {
            return Result::error("没有数据", 0);
        }
//        $data = [
//            'rows' => $result->toArray(),
//            'count' => $count,
//        ];
        if ($result) {
            return Result::success( $result->toArray());
        } else {
            return Result::error("查询失败", 0);
        }

    }

    /**
     * 递归查询数据
     * @param $id
     * @param $ids
     * @return string
     */
    public function getUnderlingUIds($id, $ids = '')
    {
        $back = Category::where(['pid' => $id])->get();
        $back = $back->toArray();
        if (!empty($back) && is_array($back)) {
            foreach ($back as $v) {
                //防止当前人的ID重复去查询，形成恶性循环
                if ($v['id'] == $id) {
                    continue;
                }
                $back2 = Category::where(['pid' => $id])->count('id');
                if ($back2 > 0) {
                    $ids = $this->getUnderlingUIds($v['id'], $ids);
                } else {
                    $ids .= ',' . $v['id'];
                }
            }
        }
        $ids = $id . ',' . $ids . ',';
        $ids = str_replace(',,', ",", $ids);
        $ids = trim($ids, ',');
        return $ids;
    }

    /**
     * 检测网站名称是否重复
     * @param array $data
     * @return array
     */
    public function checkWebsiteName(array $data): array
    {
        if (isset($data['id'])) {
            $data[] = ['id', "!=", $data['id']];
            unset($data['id']);
        }
        $websiteInfo = Website::query()->where($data)->first();
        if (empty($websiteInfo)) {
            return Result::error("找不到网站", 0);
        }
        return Result::success($websiteInfo->toArray());
    }
    /**
     * 检测网站url是否重复
     * @param array $data
     * @return array
     */
    public function checkWebsiteUrl(array $data): array
    {
        $whereData = [];
        if (isset($data['id'])) {
            $whereData = [['id', "!=", $data['id']]];
            unset($data['id']);
        }
        $websiteInfo = Website::query()->where($whereData)->whereJsonContains('website_url', $data['website_url'])->first();
        if (empty($websiteInfo)) {
            return Result::error("找不到URL", 0);
        }
        return Result::success($websiteInfo->toArray());
    }

    /**
     * 获取网站底部基础信息
     * @param array $data
     * @return array
     */
    public function getWebsiteFootInfo(array $data): array
    {

        if(isset($data['website_id']) && !empty($data['website_id'])){
            $website_head = Website::where('id',$data['website_id'])
                ->where('status',1)
                ->select('id', 'website_name', 'logo', 'title', 'keywords', 'description', 'suffix', 'website_url')
                ->first();
            if (empty($website_head)) {
                return Result::error("找不到网站",0); 
            }
        } else {
            return Result::error("参数错误", 0);
        }
        $website_foot = WebsiteTemplateInfo::where('website_id', $data['website_id'])->where('status', 2)->first();
        if (empty($website_foot)) {
            return Result::error("暂无底部基础信息", 0);
        }
        if (empty($website_head)) {
            return Result::error("暂无头部基础信息", 0);
        }
        $website_head['website_url'] = $website_head['website_url']?json_decode($website_head['website_url']):[];
        $result = [
            'website_foot' => $website_foot,
            'website_head' => $website_head,
        ];
        return Result::success($result);
        
    }
    /**
     * 获取网站底部导航
     * @param array $data
     * @return array
     */
    public function getWebsiteFooterCategory(array $data): array
    {
        if (isset($data['website_id']) && !empty($data['website_id'])) {
            $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
            if (empty($website)) {
                return Result::error("找不到网站", 0);
            }
        } else {
            return Result::error("参数错误", 0);
        }
        $result = FooterCategory::where('website_id', $data['website_id'])->get();
        if (empty($result)) {
            return Result::error("暂无底部导航", 0);
        }
        return Result::success($result->toArray());
    }
    /**
     * 获取网站底部导航列表
     * @param array $data
     * @return array
     */
    public function getWebsiteFooterCategoryList(array $data): array
    {
        if (isset($data['website_id']) && !empty($data['website_id'])) {
            $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
            if (empty($website)) {
                return Result::error("找不到网站", 0);
            }
        } else {
            return Result::error("参数错误", 0);
        }
        $footercategory = FooterCategory::where('website_id', $data['website_id'])->where('id', $data['fcat_id'])->first();
        // '底部导航类型   0：内容型；1：列表型；',
        if (!isset($footercategory['type']) || $footercategory['type'] == 0) {
            return Result::error("底部导航id错误", 0);
        } else {
            $query = FooterContent::where('fcat_id', $data['fcat_id']);
            if ($query->count() == 0) {
                return Result::error("暂无底部导航列表", 0);
            } elseif ($query->count() == 1) {
                $result = $query->first();
            } else {
                $result = $query->get();
            }
        }
        return Result::success($result);
    }
    /**
     * 获取网站底部导航
     * @param array $data
     * @return array
     */
    public function getWebsiteFooterCategoryInfo(array $data): array
    {
        if (isset($data['website_id']) && !empty($data['website_id'])) {
            $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
            if (empty($website)) {
                return Result::error("找不到网站", 0);
            }
        } else {
            return Result::error("参数错误", 0);
        }
        if (isset($data['type']) && $data['type'] == 0) {
            $fcatid = FooterCategory::where('website_id', $data['website_id'])->where('id', $data['fcat_id'])->first();
            if (empty($fcatid)) {
                return Result::error("底部导航id错误", 0);
            }
            $result = FooterContent::where('fcat_id', $data['fcat_id'])->first();
        } else {
            $result = FooterContent::where('id', $data['fcat_id'])->first();
        }
        if (empty($result)) {
            return Result::error("暂无底部导航内容", 0);
        }
        return Result::success($result);
    }
    /*
     * 搜索网站二级导航
     * @param array $data
     * @return array
     * */
    public function selectWebsiteCategory(array $data): array
    {
        if (isset($data['website_id']) && !empty($data['website_id'])) {
            $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
            if (empty($website)) {
                return Result::error("暂无该网站", 0);
            }
            $category = WebsiteCategory::where('website_id', $data['website_id'])->pluck('category_id')->all();
            // return Result::success($category);
            if (empty($category)) {
                return Result::error("暂无此导航", 0);
            }
            $query = Category::whereIn('id', $category);
            if (isset($data['cityid']) && !empty($data['cityid'])) {
                $cityid = District::where('id', $data['cityid'])->first();
                if (empty($cityid)) {
                    return Result::error("暂无此城市", 0);
                } else {
                    $city_category = $query->whereRaw('JSON_CONTAINS(city_arr_id,?)', [$data['cityid']])->pluck('id');
                    // $where[] = ['JSON_CONTAINS(city_arr_id, ?)', $data['cityid']];
                    if (empty($city_category)) {
                        return Result::error("暂无此城市下的导航", 0);
                    }
                    $result['catid'] = $city_category;
                    $city = 1;
                    // var_dump("城市====================",$result);
                }
            }
            if (isset($data['department_id']) && !empty($data['department_id'])) {
                $departmentid = Department::where('id', $data['department_id'])->first();
                if (empty($departmentid)) {
                    return Result::error("暂无此部门", 0);
                } else {
                    $depart_category = $query->whereRaw('JSON_CONTAINS(department_arr_id,?)', [$data['department_id']])->pluck('id');
                    if (empty($depart_category)) {
                        return Result::error("暂无此部门下的导航", 0);
                    }
                    $result['catid'] = $depart_category;
                    // var_dump("职能部门*******************",$result);
                    $department = 1;
                }
            }
            if (!empty($city) && !empty($department)) {
                // var_dump("城市和职能部门----------------------",$result);
                $sel_category = $query->whereRaw('JSON_CONTAINS(city_arr_id,?)', [$data['cityid']])->whereRaw('JSON_CONTAINS(department_arr_id,?)', [$data['department_id']])->pluck('id');
                if (empty($sel_category)) {
                    return Result::error("暂无此城市和职能部门下的导航", 0);
                }
                $result['catid'] = $sel_category;
            }
            if (empty($result)) {
                return Result::error("暂无导航", 0);
            }
            // department_id
        } else {
            return Result::error("参数错误", 0);
        }
        return Result::success($result);
    }
    /**
     * 获取网站栏目seo
     * @param array $data
     * @return array
     */
    public function getWebsiteCategoryHead(array $data): array
    {

        if (isset($data['website_id']) && !empty($data['website_id'])) {
            $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
            if (empty($website)) {
                return Result::error("找不到网站", 0);
            }
        } else {
            return Result::error("参数错误", 0);
        }
        if (isset($data['catid']) && !empty($data['catid'])) {
            $fcatid = WebsiteCategory::where('website_id', $data['website_id'])->where('category_id', $data['catid'])->first();
            if (empty($fcatid)) {
                return Result::error("导航id错误", 0);
            }
            $result = Category::where('id', $data['catid'])->first();
            $result['website_name'] = $website['website_name']??'';
            $result['suffix'] = $website['suffix']??'';
        }
        if (empty($result)) {
            return Result::error("暂无导航", 0);
        }
        return Result::success($result);
    }

    /*
     * 获取某个栏目
     * @param array $data
     * @return array
     * */
    public function getOneWebsiteCategory(array $data): array
    {
        if (isset($data['website_id']) && !empty($data['website_id'])) {
            $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
            if (empty($website)) {

                return Result::error("暂无该网站",0); 
            }
            $category = WebsiteCategory::where('website_id',$data['website_id'])->where('category_id',$data['category_id'])->first();
            if (empty($category)) {
                return Result::error("暂无此导航",0);
            }
            $category['children_count'] = WebsiteCategory::where('website_id',$data['website_id'])->where('pid',$data['category_id'])->count();
            $parent = WebsiteCategory::where('website_id',$data['website_id'])->where('category_id',$category['pid'])->select('category_id as parent_id','alias as parent_name')->first();
            $category['parent_id'] = $parent['parent_id']?? '';
            $category['parent_name'] = $parent['parent_name']?? '';
            return Result::success($category);
        }else{
            return Result::error("参数错误",0);
        }
    }

    //20250212  网站标识
    public function addWebsiteGroup(array $data): array
    {
        //判斷name是不是重复
        $websiteGroupInfo = WebsiteGroup::query()->where('name', $data['name'])->first();
        if (!empty($websiteGroupInfo)) {
            return Result::error("网站标识重复", 0);
        }
        //添加信息
        $result = WebsiteGroup::insertGetId($data);
        var_dump($result);
        if (empty($result)) {
            return Result::error("创建失败", 0);
        } else {
            return Result::success($result);
        }
    }
    public function getWebsiteGroupList(array $data): array
    {
        $where = [];
        if (isset($data['name']) && !empty($data['name'])) {
            array_push($where, ['website_group.name', 'like', '%' . $data['name'] . '%']);
        }
        $result = WebsiteGroup::where($where)
            ->limit($data['pageSize'])->orderBy("id", "desc")->offset(($data['page'] - 1) * $data['pageSize'])
            ->get();

        foreach ($result as $websiteGroup) {
            $webIds = json_decode($websiteGroup->web_ids, true);
            $websites = Website::whereIn('id', $webIds)->get();
            $websiteNames = $websites->pluck('website_name', 'id')->toArray();
            $websiteGroup->website_names = $websiteNames;
            $websiteGroup->website_names1 = implode(',', array_values($websiteNames));
        }
        $count = WebsiteGroup::where($where)->count();
        if (empty($result)) {
            return Result::error("没有数据", 0);
        }
        return Result::success(['list' => $result->toArray(), 'count' => $count]);
    }
    public function getWebsiteGroupInfo(array $data): array
    {
        $websiteInfo = WebsiteGroup::query()->where('id', $data['id'])->first();
        $webIds = json_decode($websiteInfo->web_ids, true);
        $websites = Website::whereIn('id', $webIds)->get();
        $websiteNames = $websites->pluck('website_name', 'id')->toArray();
        $websiteInfo->website_names = $websiteNames;
        $websiteInfo->website_names1 = implode(',', array_values($websiteNames));
        if (empty($websiteInfo)) {
            return Result::error("找不到URL", 0);
        }
        return Result::success($websiteInfo->toArray());
    }
    public function updateWebsiteGroup(array $data): array
    {
        $where = [
            'id' => $data['id'],
        ];
        $insertData = [
            'name' => $data['name'],
            'web_ids' => $data['web_ids'],
        ];

        //判斷name是不是重复
        $websiteGroupInfo = WebsiteGroup::query()->where('name', $data['name'])->first();
        if (!empty($websiteGroupInfo)) {
            return Result::error("网站标识重复", 0);
        }

        $result = WebsiteGroup::where($where)->update($insertData);
        var_dump($result, '------更新');
        if (empty($result)) {
            return Result::error("更新失败", 0);
        } else {
            return Result::success();
        }
    }
    public function deleteWebsiteGroup(array $data): array
    {
        $where = [
            'id' => $data['id'],
        ];
        //看看user表是不是有这个id
        $userGroup = User::query()->where('sszq', $data['id'])->first();
        if (!empty($userGroup)) {
            return Result::error("有用户在使用该网站标识，不能删除", 0);
        }
        $result = WebsiteGroup::where($where)->delete();
        if (empty($result)) {
            return Result::error("删除失败", 0);
        } else {
            return Result::success();
        }
    }
    public function getWebsiteNavList(array $data): array
    {
        $where = [];
        if (isset($data['website_id']) && !empty($data['website_id'])) {
            array_push($where, ['website_id', '=', $data['website_id']]);
        }
        if (isset($data['pid'])) {
            array_push($where, ['pid', '=', $data['pid']]);
        }
        $list = WebsiteCategory::query()->where($where)->get();
        if (empty($list)) {
            return Result::error("获取失败", 0);
        } else {
            return Result::success($list);
        }
    }
    //20250212  网站标识
    // 自助建站--fr-------------------

    /**
     * 获取并搜索 网站模板信息
     * @param array $data
     * @return array
     */
    public function getWebsiteintel(array $data): array
    {
        //查询所有网站模板信息
        $query = Website::where('website.status', 1)
            ->leftJoin("website_template_info", "website_template_info.website_id", "website.id")
            ->leftJoin("template", "template.id", "website_template_info.template_id")
            ->leftJoin("template_class", "template_class.id", "template.template_class_id")
            ->select(
                "website_template_info.id",
                "template_class.name",
                "website.id as website_id",
                "website.website_name",
                "website.website_url",
                "website_template_info.action_id",
                "website_template_info.created_at",
                "website_template_info.updated_at",
                "website_template_info.page_type",
                DB::raw("COALESCE(website_template_info.status, 0) as template_status"),
                "template.template_name"
            );
        //若存在条件；则在$query的基础上进行筛选
        if (isset($data['website_name']) && !empty($data['website_name'])) {
            $query->where('website.website_name', 'like', '%' . $data['website_name'] . '%');
        }
        if (isset($data['status']) && !empty($data['status'])) {
            $query->where('website_template_info.status', $data['status']);
        }
        $count = $query->count();
        $query->limit($data['pageSize'])
            ->offset(($data['page'] - 1) * $data['pageSize'])
            ->orderBy("website_template_info.updated_at", "desc");
        $rep = $query->get();
        if ($rep->count() == 0) {
            return Result::error("没有查找到相关数据", 0);
        } else {
            $rep->each(function ($item) {
                if (!empty($item->page_type)) {
                    $pageTypeArray = json_decode($item->page_type, true);
                    if (is_array($pageTypeArray)) {
                        $item->page_type = $pageTypeArray;
                    }
                }
            });

            $result = [
                "rows" => $rep->toArray(),
                "count" => $count,
            ];
            return Result::success($result);
        }
        // return Result::success($result);
    }

    /**
     * 添加网站基础信息
     * @param array $data
     * @return array
     */
    public function addWebsiteTemplateintel(array $data): array
    {
//        var_dump("接收参数：",$data['webSiteData']['base']);
        Db::beginTransaction();
        try {
            $websiteTemplateInfo = WebsiteTemplate::where(['website_id' => $data['webSiteData']['base']['websiteId']])->first();
//            var_dump($websiteTemplateInfo);
            //原始数据
            $templateList = $data['webSiteData']['template'];
            if ($websiteTemplateInfo) {
                //模板存在-更新广告

            } else {
                //创建广告

                $adList = $this->getAdlist($templateList);
                if (!empty($adList)) {
                    AdPlace::insert($adList);
                }
            }
//            $result =  WebsiteTemplate::updateOrInsert(['website_id'=>$data['webSiteData']['base']['websiteId']],['template_data'=>json_encode($data['webSiteData']),'updated_at'=>date("Y-m-d H:i:s",time())]);
            Db::commit();
        } catch (\Throwable $ex) {
            Db::rollBack();
            var_dump($ex->getMessage());
            return Result::error("创建失败", 0);
            $website = Website::where('website.id', $data['website_id'])->first();
            if (empty($website)) {
                return Result::error("请输入正确的网站id！", 0);
            }
            if (empty($website['website_column_id'])) {
                return Result::error("请先关联导航池！", 0);
            }
            // 获取此网站的底部导航  类型   type：  0：内容型底部导航（只有一条详情内容）；1：列表型底部导航（可以有多条详情内容）
            $foot_type = FooterCategory::where('website_id', $data['website_id'])->pluck('type')->toArray();
            if (empty($foot_type)) {
                return Result::error("请先关联底部导航池！", 0);
            } elseif (in_array(1, $foot_type)) {
                $foot_type = 1;
            } else {
                $foot_type = 0;
            }
            $result['foot_type'] = $foot_type;
            //  友情链接类型'1:图片 2：文字 3：底部';
            $types = Link::where('website_id', $data['website_id'])->pluck('type')->toArray();
            $missingTypes = [];
            if (!in_array(1, $types)) {
                $missingTypes[] = "文字链接";
            }
            if (!in_array(2, $types)) {
                $missingTypes[] = "图片链接";
            }
            if (!in_array(3, $types)) {
                $missingTypes[] = "底部链接";
            }
            if (!empty($missingTypes)) {
                $errorMessage = "请先添加 " . implode(" 和 ", $missingTypes) . "！";
                return Result::error($errorMessage, 0);
            }
            if (isset($data['page_type'])) {
                // 删除重复元素并重新索引数组
                $data['page_type'] = array_unique($data['page_type']);
                $data['page_type'] = array_values($data['page_type']);
                if (in_array(1, $data['page_type']) && in_array(7, $data['page_type'])) {
                    // 数组中同时包含值为 1（首页） 和值为 7 （底部导航详情页）的元素
                    $info = WebsiteTemplateInfo::where('website_id', $data['website_id'])->first();
                    if (empty($info)) {
                        // 将数组转换为 JSON 字符串
                        $data['page_type'] = json_encode($data['page_type']) ?? '';
                        // 操作状态：1：填写完成基础信息；2：选择完成模板；0：未构建
                        $data['action_id'] = 1;

                        try {
                            $result = WebsiteTemplateInfo::insertGetId($data);
                        } catch (\Exception $e) {
                            if ($e->getCode() == 22001) {
                                $errorMessage = $e->getMessage();
                                return Result::error("请检查表单，某个字段超出了长度限制！");
                            } else {
                                // 处理其他类型的数据库错误
                                return Result::error("插入操作失败: " . $e->getMessage());
                            }
                            return Result::error("添加失败！", 0);
                        }
                    } else {
                        return Result::error("该网站已经构建过了！", 0);
                    }
                } else {
                    return Result::error("请先选择首页和底部导航详情页！", 0);
                }
            }
        }
        if (empty($result)) {
            return Result::error("添加失败！", 0);
        } else {
            return Result::success($result);
        }
        return Result::success();

    }
    //获取传过来的广告列表
    public function getAdlist($templateList)
    {
        if ($templateList) {
            $adList = [];
            foreach ($templateList as $val) {
                if ($val) {
                    foreach ($val as $v) {
                        if ($v['componentList']) {
                            foreach ($v['componentList'] as $p) {
                                if ($p['component_type'] == 3) {
//                                            var_dump("ppppppppppppp:",$p);
                                    $adSizeInfo = AdSize::where(['width' => $p['componentData']['width'], 'height' => $p['componentData']['height']])->first();
                                    $adSizeInfo = $adSizeInfo->toArray();
                                    $adData = [
                                        'website_id' => $data['webSiteData']['base']['websiteId'],
                                        'status' => 1,
                                        'name' => $p['componentData']['text'],
                                        'ad_id' => $p['componentData']['ad_id'],
                                        'ad_size_id' => $adSizeInfo['id'],
                                    ];
                                    array_push($adList, $adData);
                                }
                            }
                        }
                    }
                }
            }
            if (count($adList) > 0) {
                return $adList;
            }
        }
    }
    /**
     * 获取网站基础信息
     *
     * @return array
     */
    public function getWebsiteTemplateintel(array $data): array
    {

        $result = WebsiteTemplateInfo::where('website_template_info.website_id', $data['website_id'])
            ->leftJoin('footer_category', 'footer_category.website_id', 'website_template_info.website_id')
            ->leftJoin('website', 'website.id', 'website_template_info.website_id')
            ->select(
                "website_template_info.*",
                "footer_category.type",
                "website.website_name",
                "website.id as website_id"
            )
            ->first();
        if (empty($result['website_name'])) {
            return Result::error("请输入正确的网站id！", 0);
        }
        if ($result) {
            $result['page_type'] = json_decode($result['page_type'], true);
            return Result::success($result);
        } else {
            return Result::error("请先添加网站基础信息！", 0);
        }
    }
    /**
     * 修改网站基础信息
     *
     * @return array
     */
    public function upWebsiteTemplateintel(array $data): array
    {
        $web = Website::where('website.id', $data['website_id'])->first();
        if (empty($web)) {
            return Result::error("请输入正确的网站id！", 0);
        }
        $where = ['website_id' => $data['website_id']];
        $result = WebsiteTemplateInfo::where($where)->first();
        if (empty($result)) {
            return Result::error("请先添加网站基础信息！", 0);
        } else {
            unset($data['website_id']);
            // 删除重复元素
            $data['page_type'] = array_unique($data['page_type']);
            // 重新索引数组
            $data['page_type'] = array_values($data['page_type']);
            //  数组中同时包含值为 1（首页） 和值为 7 （底部导航详情页）的元素
            if (in_array(1, $data['page_type']) && in_array(7, $data['page_type'])) {
                // 将数组转换为 JSON 字符串
                $data['page_type'] = json_encode($data['page_type']) ?? '';
                try {
                    $result = WebsiteTemplateInfo::where($where)->update($data);
                } catch (\Exception $e) {
                    if ($e->getCode() == 22001) {
                        $errorMessage = $e->getMessage();
                        return Result::error("请检查表单，某个字段超出了长度限制！");
                    } else {
                        // 处理其他类型的数据库错误
                        return Result::error("修改操作失败: " . $e->getMessage());
                    }
                    return Result::error("修改失败！", 0);
                }
            } else {
                return Result::error("请先选择首页和底部导航详情页！", 0);
            }
        }
        if (empty($result)) {
            return Result::error("修改失败！", 0);
        } else {
            return Result::success($result);
        }
    }
    /**
     * 获取所有网站风格信息
     *
     * @return array
     */
    public function getAllTemplateClass(array $data): array
    {
        $result = TemplateClass::all();
        if (empty($result)) {
            return Result::error("没有查找到相关数据！", 0);
        } else {
            return Result::success($result);
        }
    }

    /**
     * 搜索并获取网站模板信息
     * @param array $data
     * @return array
     */
    public function getWebsiteTemplateList(array $data): array
    {

        $website = Website::where('website.id', $data['website_id'])->first();
        if (empty($website)) {
            return Result::error("请输入正确的网站id！", 0);
        } else {
            $page_type = WebsiteTemplateInfo::where('website_id', $data['website_id'])->select('page_type')->first();
            if (empty($page_type)) {
                return Result::error("此网站还未添加基础信息！", 0);
            } else {
                $where = json_decode($page_type['page_type'], true);
                // $where = $data["page_type"];
                if (isset($data['template_class_id']) && !empty($data['template_class_id'])) {
                    $template_class = TemplateClass::where('id', $data['template_class_id'])->first();
                    if (empty($template_class)) {
                        return Result::error("请输入正确的模板风格id！", 0);
                    } else {
                        // 获取指定风格下的模板
                        $rep = Template::where('template_class_id', $data['template_class_id'])
                            ->where(function ($query) use ($where) {
                                foreach ($where as $value) {
                                    $query->whereJsonContains('template_img', ['value' => $value]);
                                }
                            })
                            ->limit($data['pageSize'])
                            ->offset(($data['page'] - 1) * $data['pageSize'])
                            ->orderBy("template.updated_at", "desc")
                            ->get();
                        $count = Template::where('template_class_id', $data['template_class_id'])
                            ->where(function ($query) use ($where) {
                                foreach ($where as $value) {
                                    $query->whereJsonContains('template_img', ['value' => $value]);
                                }
                            })->count();
                    }
                } else {

                    //获取所有模板
                    $rep = Template::where(function ($query) use ($where) {
                        foreach ($where as $value) {
                            $query->whereJsonContains('template_img', ['value' => $value]);
                        }
                    })
                        ->limit($data['pageSize'])
                        ->offset(($data['page'] - 1) * $data['pageSize'])
                        ->orderBy("template.updated_at", "desc")
                        ->get();
                    $count = Template::where(function ($query) use ($where) {
                        foreach ($where as $value) {
                            $query->whereJsonContains('template_img', ['value' => $value]);
                        }
                    })->count();

                }
                if (empty($rep) || $rep->count() == 0) {
                    return Result::error("没有查找到相关数据！", 0);
                } else {
                    // 过滤 template_img 字段 只获取 基础信息中 包含的模板图片
                    // $rep->each(function ($item) use ($where) {
                    //     $template_img = json_decode($item->template_img, true);
                    //     if(is_array($template_img)){
                    //         $filtered_img = array_filter($template_img, function ($img) use ($where) {
                    //             return isset($img['value']) && in_array($img['value'], $where);
                    //         });
                    //     }

                    //     $item->template_img = $filtered_img;
                    // });
                    // $result = [
                    //     "rows" => $rep->toArray(),
                    //     "count" => $count
                    // ];
                    $rep->each(function ($item) use ($where) {
                        $template_img = json_decode($item->template_img, true);
                        if (is_array($template_img)) {
                            $filtered_img = array_filter($template_img, function ($img) use ($where) {
                                return isset($img['value']) && in_array($img['value'], $where);
                            });
                            // 对过滤后的数组进行重新排序
                            $sorted_img = array_values($filtered_img);
                            $item->template_img = $sorted_img;
                        } else {
                            $item->template_img = []; // 如果无法解码为数组，则设置为空数组
                        }
                    });

                    $result = [
                        "rows" => $rep->toArray(),
                        "count" => $count,
                    ];
                }
            }
        }
        return Result::success($result);

    }

    /**
     * 添加网站模板
     * @param array $data
     */
    public function addWebsiteTemplateclassintel(array $data): array
    {
        $template = Template::where('id', $data['template_id'])->first();
        $web = Website::where('id', $data['website_id'])->first();
        if (empty($template)) {
            return Result::error("请输入正确的模板id", 0);
        }
        if (empty($web)) {
            return Result::error("请输入正确的网站id", 0);
        }

        $result = WebsiteTemplateInfo::where('website_id', $data['website_id'])->update(['template_id' => $data['template_id'], 'action_id' => 2]);
        if (empty($result)) {
            return Result::error("添加失败", 0);
        } else {
            return Result::success($result);
        }

    }
    /**
     * 获取网站模板信息
     * @param array $data
     */
    public function getWebsiteTemplateclassintel(array $data): array
    {
        // return Result::success($data);
        $template = WebsiteTemplateInfo::where('website_id', $data['website_id'])->first();
        if (empty($template)) {
            return Result::error("请输入正确的搭建网站id", 0);
        }
        $page_type = json_decode($template['page_type'], true);
        // 获取指定网站下的基础信息和模板及风格信息
        $result = WebsiteTemplateInfo::where([
            ['website_template_info.website_id', $data['website_id']],
            ['template_id', '!=', null],
        ])
            ->leftJoin('template', 'template.id', 'website_template_info.template_id')
            ->leftJoin('template_class', 'template_class.id', 'template.template_class_id')
            ->where(function ($query) use ($page_type) {
                // 假设 $data['page_type'] 是一个数组，包含需要匹配的 page_type 值
                foreach ($page_type as $pageType) {
                    $query->orWhereJsonContains('template.template_img', ['value' => $pageType]);
                }
            })
            ->select(
                'template.template_name',
                'template.template_img',
                'template.id as tid',
                'template_class.name',
                'template_class.id as class_id',
                'website_template_info.page_type',
                'website_template_info.website_id')
            ->first();

        if (empty($result)) {
            return Result::error("没有查找到相关数据", 0);
        }

        // return Result::success($result);
        // 过滤 template_img 字段  只获取 基础信息中 包含的模板图片
        $template_img = $result['template_img'] !== null ? json_decode($result['template_img'], true) : [];
        $page_type = $result['page_type'] !== null ? json_decode($result['page_type'], true) : [];
        foreach ($template_img as $key => $value) {
            if (!in_array($value['value'], $page_type)) {
                unset($template_img[$key]);
            }
        }
        // return Result::success($result);
        $result['template_img'] = array_values($template_img);
        $result['page_type'] = $page_type;

        // $templateList = $this->getWebsiteTemplateList($data);
        // $count = $templateList['data']['count']??'';
        // $pages = $count / $data['pageSize'];
        // $found = false;
        // while ($pages && !$found) {
        //     $templates = $this->getWebsiteTemplateList($pages,$data['pageSize']);
        //     $index = array_search($template['template_id'], array_column($templates['rows'], 'id'));
        //     if ($index !== false) {
        //         $found = true;
        //         $result['page'] = $pages;
        //         $pages = 0;
        //         // echo "查询到的 template 在第 $page 页";
        //     }
        //     $pages--;
        // }

        return Result::success($result);
    }
    /**
     * 获取网站模板下的板块信息
     * @param array $data
     */
    public function getWebsiteSectorList(array $data): array
    {
        $website = Website::where('id', $data['website_id'])->first();
        if (empty($website)) {
            return Result::error("请输入正确的网站id", 0);
        }
        $template = WebsiteTemplateInfo::where('website_id', $data['website_id'])->first();
        if (empty($template['template_id'])) {
            return Result::error("请先添加网站模板", 0);
        }
        $query = Sector::where('template_id', $template['template_id']);
        if ($query->count() == 0) {
            return Result::error("没有查找到相关板块数据", 0);
        } elseif ($query->count() == 1) {
            $sector = $query->first();
        } else {
            $sector = $query->get();
        }
        $result['page_type'] = $template['page_type'];
        $result['tid'] = $template['template_id'];
        $result = [
            "tid" => $template['template_id'],
            "page_type" => $template['page_type'],
            "sector" => $sector,
        ];
        return Result::success($result);
    }

    // 自助建站---------------fr---------------

    // 自助建站------liu-------------
    /**
     * 风格下的板块
     * @return void
     */
    public function templateSectorList(array $data): array
    {
        $where = [
            'template_id' => $data['template_id'],
        ];
        $result = Sector::where($where)->whereJsonContains("page_type", $data['page_type'])
            ->limit($data['pageSize'])->offset(($data['page'] - 1) * $data['pageSize'])
            ->get();

        $count = Sector::where($where)->count();
        if (empty($result)) {
            return Result::error("没有数据", 0);
        }
        $data = [
            'rows' => $result->toArray(),
            'count' => $count,
        ];
        if (empty($result)) {
            return Result::error("没有数据", 0);
        }
        return Result::success($data);
    }

    /**
     * 板块下的组件
     * @param array $data
     * @return array
     */
    public function sectorComponentList(array $data): array
    {
        $where = [
            'template_id' => $data['template_id'],
            'sector_id' => $data['sector_id'],
        ];
        $result = Component::where($where)
            ->select("*")
            ->limit($data['pageSize'])->offset(($data['page'] - 1) * $data['pageSize'])
            ->get();

        $count = Component::where($where)->count();
        if (empty($result)) {
            return Result::error("没有数据", 0);
        }
        $data = [
            'rows' => $result->toArray(),
            'count' => $count,
        ];
        if (empty($result)) {
            return Result::error("没有数据", 0);
        }
        return Result::success($data);
    }
    /**
     * 获取模板内容
     * @return void
     */
    public function getWebsiteTemplateInfo(array $data): array//丢了

    {
        $wehre = [
            "website_id" => $data['website_id'],
        ];
        $result = WebsiteTemplate::where($wehre)->first();
        if ($result) {
            return Result::success($result);
        } else {
            return Result::error("没有数据", 0);
        }
    }
    /**
     * 保存网站模板
     * @param array $data
     * @return array
     */
    public function addWebsiteTemplate(array $data): array
    {
//        var_dump("接收参数：",$data['webSiteData']['base']);
        Db::beginTransaction();
        try {
            $websiteTemplateInfo = WebsiteTemplate::where(['website_id' => $data['webSiteData']['base']['websiteId']])->first();
//            var_dump($websiteTemplateInfo);
            //原始数据
            $templateList = $data['webSiteData']['template'];
            if ($websiteTemplateInfo) {
                //模板存在-更新广告

            } else {
                //创建广告

                $adList = $this->getAdlist($templateList);
                if (!empty($adList)) {
                    AdPlace::insert($adList);
                }
            }
//            $result =  WebsiteTemplate::updateOrInsert(['website_id'=>$data['webSiteData']['base']['websiteId']],['template_data'=>json_encode($data['webSiteData']),'updated_at'=>date("Y-m-d H:i:s",time())]);
            Db::commit();
        } catch (\Throwable $ex) {
            Db::rollBack();
            var_dump($ex->getMessage());
            return Result::error("创建失败", 0);
        }
        return Result::success();

    }
    /**
     * 预览网站首页模板数据
     * @param array $data
     * @return array
     */
    public function getWebsiteTemplateData(array $data): array
    {
        $wehre = [
            "website_id" => $data['website_id'],
        ];
        $result = WebsiteTemplate::where($wehre)->first();
        if ($result) {
            $templateData = json_decode($result['template_data'], true);
//            var_dump("数据：",$templateData[1]);
            $templateData[1] = $this->getNewsList($templateData[1]);

            return Result::success($templateData);
        } else {
            return Result::error("没有数据", 0);
        }
    }

    /**
     * 获取列表数据
     * @return void
     */
    public function getNewsList(array $data): array
    {
        if ($data) {
            foreach ($data as $key => $val) {
                if ($val) {
                    foreach ($val['data'] as $k => $item) {
                        if ($item['isReturn'] && intval($item['isReturn']) == 1) {
                            $imgList = [];
                            if ($item['data']['imgNum'] && intval($item['data']['imgNum']) > 0) {
                                $imgList = Article::where('imgurl', "!=", "")
                                    ->where('catid', $item['data']['category_id'])
                                    ->select($item['data']['selectField'])
                                    ->orderBy("created_at", "desc")
                                    ->offset(0)
                                    ->limit(intval($item['data']['imgNum']))
                                    ->get();
                                $imgList = $imgList->toArray();
                                $listIds = [];
                                if ($imgList) {
                                    $listIds = array_column($imgList, 'id');
                                }
                                $dataList = Article::whereNotIn('id', $listIds)
                                    ->where('catid', $item['data']['category_id'])
                                    ->select($item['data']['selectField'])
                                    ->orderBy("created_at", "desc")
                                    ->offset(0)
                                    ->limit(intval($item['data']['pageSize']) - intval($item['data']['imgNum']))
                                    ->get();
                                $dataList = $dataList->toArray();
                                var_dump("图片列表：", $imgList, "数据列表：", $dataList);
                                $datas = array_merge($imgList, $dataList);
//                                return $datas;
                                var_dump("合并列表：", $datas);
                                $data[$key]['data'][$k]['dataList'] = $datas;
                            } else {
                                $dataList = Article::where('catid', $item['data']['category_id'])
                                    ->select($item['data']['selectField'])
                                    ->orderBy("created_at", "desc")
                                    ->offset(0)
                                    ->limit(intval($item['data']['pageSize']))
                                    ->get();
                                $dataList = $dataList->toArray();
                                var_dump("数据列表：", $dataList);
                            }
                        }
                    }
                }

            }
        }
        return $data;
    }

    /**
     * 获取底部导航列表
     * @param array $data
     * @return array
     */
    public function getFooterCategoryList(array $data): array
    {
        $where = [
            "website_id" => $data['website_id'],
        ];
        $result = FooterCategory::where($where)->get();
        if ($result) {
            return Result::success($result);
        } else {
            return Result::error("没有数据");
        }
    }

    //获取底部导航内容列表
    public function getFooterContentList(array $data): array
    {
        $where = [
            "fcat_id" => $data['fcat_id'],
        ];
        switch (intval($data['type'])) {
            case 0:
                $result = FooterContent::where($where)->first();
                break;
            case 1:
                $result = FooterContent::where($where)->get();
                break;
        }
        if ($result) {
            return Result::success($result);
        } else {
            return Result::error("没有数据");
        }
    }
    //获取底部导航内容详情
    public function getFooterContentInfo(array $data): array
    {
        $where = [
            "id" => $data['content_id'],
        ];
        $result = FooterContent::where($where)->first();
        if ($result) {
            return Result::success($result);
        } else {
            return Result::error("没有数据");
        }
    }

// 自传建站---------------liu------------
    // 20250307 根据网站标识获和导航获取站点

    public function getWebsiteNavPoolSite(array $data): array
    {
        $where = [];
        if (isset($data['category_id']) && !empty($data['category_id'])) {
            array_push($where, ['category_id', '=', $data['category_id']]);
        }
        $list = WebsiteCategory::query()->where($where)
            ->leftJoin('website', 'website.id', '=', 'website_category.website_id')
            ->select('website_category.*', 'website.website_name')
            ->distinct()
            ->get();
        if (empty($list)) {
            return Result::error("获取失败", 0);
        } else {
            return Result::success($list);
        }
    }
    public function getWebsiteNavPool(array $data): array
    {
        // 初始化查询条件数组
        $query = WebsiteCategory::query();

        // 如果传入了 websiteids，则添加到查询条件中
        if (isset($data['websiteids']) && !empty($data['websiteids'])) {
            $query->whereIn('website_id', $data['websiteids']);
        }

        // 如果传入了 pid，则添加到查询条件中
        if (isset($data['pid'])) {
            $query->where('pid', '=', $data['pid']);
        }

        // 执行查询 唯一性 id
        $list = $query->distinct()->get();

        // 根据查询结果返回相应的结果
        if ($list->isEmpty()) {
            return Result::error("获取失败", 0);
        } else {
            return Result::success($list->toArray());
        }
    }
    // 20250307 根据网站标识获和导航获取站点

    /**
     *
     * @param array $data
     * @return array
     */
    public function getAllCategory(array $data): array
    {
        $result = Category::when($data, function ($query) use ($data) {
            if (isset($data['name']) && !empty($data['name'])) {
                $query->where('category.name', 'like', '%' . trim($data['name']) . '%');
            }
        })->get();
        if (empty($result)) {
            return Result::error("获取失败", 0);
        } else {
            return Result::success($result);
        }
    }

    /**
     * 修改网站栏目排序
     * @param array $data
     * @return array
     */
    public function upWebsiteCategorySort(array $data): array
    {
        $where = [
            'website_id' => $data['website_id'],
            'id' => $data['id'],
        ];
        $result = WebsiteCategory::where($where)->update($data);
        if ($result) {
            return Result::success($result);
        } else {
            return Result::error("更新失败", 0);
        }
    }

}