123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061 |
- <?php
- namespace App\JsonRpc;
- 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\WebsiteTemplateInfo;
- use App\Model\Link;
- use App\Model\LetterOfComplaint;
- use App\Model\TemplateClass;
- use App\Model\Template;
- use App\Model\User;
- use App\Model\WebsiteRole;
- use App\Model\WebsiteRoleUser;
- use App\Model\Website;
- use App\Model\WebsiteColumn;
- 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\Sector;
- use PhpParser\Node\Stmt\Return_;
- use function PHPUnit\Framework\isNull;
- #[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
- {
- $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']]);
- }
- if(isset($data['city_id']) && !empty($data['city_id'])){
- array_push($where,['website.city_id','=',$data['city_id']]);
- }
- $result = Website::where($where)
- ->leftJoin("website_column","website.website_column_id","website_column.id")
- ->leftJoin("district","district.id","website.city_id")
- ->select("website.*","website_column.column_name","district.name as city_name")
- ->limit($data['pageSize'])->offset(($data['page']-1)*$data['pageSize'])->orderBy("website.id","desc")->get();
- $count = Website::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 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']??0,
- 'website_column_arr_id'=>$data['website_column_arr_id'],
- 'city_arr_id'=>$data['city_arr_id']??[0],
- 'template_id' =>$data['template_id']??0,
- ];
- $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,
- ];
- $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'],
- 'pid'=>0
- ];
- $result = WebsiteCategory::where($where)->get();
- if($result){
- return Result::success($result);
- }else{
- return Result::error("查询失败",0);
- }
- }
- /**
- * 更新网站导航
- * @param array $data
- * @return array
- */
- public function upWebsiteCategory(array $data): array
- {
- Db::beginTransaction();
- try{
- //合并栏目id
- $reqIds = array_merge($data['old_category_arr_id'],$data['new_category_arr_id']);
- //对比old 数组差异化,把差异化的删除
- $result = WebsiteCategory::where(['website_id'=>$data['website_id'],'pid'=>0])->get();
- $result = $result->toArray();
- $categoryIds = [];
- if($result){
- foreach ($result as $val){
- array_push($categoryIds,$val['category_id']);
- }
- }
- //和原始数据对比取交际
- $reqidsIntersect = array_intersect($reqIds,$categoryIds);
- //再取差集 进行对比
- $differenceIDS = array_merge(array_diff($reqidsIntersect, $categoryIds),array_diff($categoryIds,$reqidsIntersect));
- var_dump("差集:",$differenceIDS);
- $arr_ids = [];
- if(count($differenceIDS)>0){
- foreach ($differenceIDS as $vv){
- $idV = $this->getUnderlingUIds(intval($vv));
- $ids_arrV = explode(",", $idV);
- array_push($arr_ids,$ids_arrV);
- }
- }
- $del_ids = array_reduce($arr_ids, 'array_merge', array());
- //有差异 删除
- if(count($del_ids)>0){
- WebsiteCategory::where(['website_id'=>$data['website_id']])->whereIn("category_id",$del_ids)->delete();
- }
- //传过来的值 和 交际 对比,选出要添加的值 进行插入
- $insertIDS = array_merge(array_diff($reqIds, $reqidsIntersect),array_diff($reqidsIntersect,$reqIds));
- var_dump("要存储的:",$insertIDS);
- //新的数组重新创建
- if(count($insertIDS)>0){
- $arr = [];
- $categoryListIds = $insertIDS;
- 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("要插入的ID:",$mergedArray);
- //查询出所有的分类进行分割插入 组装数据
- $categoryListData = Category::whereIn('id',$mergedArray)->get();
- $categoryListData = $categoryListData->toArray();
- $insertData = [];
- if($categoryListData){
- foreach ($categoryListData as $key=>$value){
- $insertData[$key]['website_id'] = $data['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'];
- }
- }
- WebsiteCategory::insert($insertData);
- }
- 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 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'])->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'],
- ];
- $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'])
- ->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($data);
- }else{
- return Result::error("查询失败",0);
- }
- if($result){
- return Result::success($result);
- }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);
- }
- $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();
- }
- 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);
- }
- }
-
- // 自助建站--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
- {
- $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 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---------------
- // 网站底基础信息--fr-------------------
- /**
- * 添加网站底基础信息
- * @param array $data
- */
- public function addWebFootInfo(array $data): array
- {
- $website = Website::where('id',$data['website_id'])->first();
- if(empty($website)){
- return Result::error("请输入正确的网站id!", 0);
- }
- $info = WebsiteTemplateInfo::where('website_id',$data['website_id'])->first();
- if(!empty($info)){
- return Result::error("该网站已经添加过了!", 0);
- }
- $result = WebsiteTemplateInfo::where('website_id',$data['website_id'])->insertGetId($data);
- if(empty($result)){
- return Result::error("请先添加网站基础信息!",0);
- }else{
- return Result::success($result);
- }
- }
- /**
- * 获取网站底基础信息
- * @param array $data
- */
- public function getWebFootInfo(array $data): array
- {
- $website = Website::where('id',$data['website_id'])->first();
- if(empty($website)){
- return Result::error("请输入正确的网站id!", 0);
- }
- $result = WebsiteTemplateInfo::where('website_id',$data['website_id'])->first();
- if(empty($result)){
- return Result::error("请先添加网站基础信息!",0);
- }
- return Result::success($result);
- }
- /**
- * 修改网站底基础信息
- * @param array $data
- */
- public function upWebFootInfo(array $data): array
- {
- // return Result::success($data['website_id']);
- $website = Website::where('id',$data['website_id'])->first();
- if(empty($website)){
- return Result::error("请输入正确的网站id!", 0);
-
- }
- $where = ['website_id'=>$data['website_id']];
- unset($data['website_id']);
- $result = WebsiteTemplateInfo::where($where)->first();
- if(empty($result)){
- return Result::error("请先添加网站基础信息!",0);
- }
- // $where = ['website_id'=>$data['website_id']];
- // unset($data['website_id']);
- $result = WebsiteTemplateInfo::where($where)->update($data);
- if(empty($result)){
- return Result::error("修改失败!",0);
- }
- return Result::success($result);
- }
- /*
- * 获取父级/子级栏目
- * @param array $data
- * @return array
- * */
- public function getWebsiteParentCategory(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);
- }
- if($data['id']==0){
- $category = WebsiteCategory::where('website_id', $data['website_id'])
- ->where('pid', 0)
- ->pluck('aLIas_pinyin')
- ->map(function ($alias) {
- return "/{$alias}/:id";
- })
- ->values()
- ->all();
- }else{
- $category = WebsiteCategory::where('website_id', $data['website_id'])
- ->where('pid','!=', 0)
- ->pluck('aLIas_pinyin')
- ->map(function ($alias) {
- return "/{$alias}/:id";
- })
- ->values()
- ->all();
- }
- if (empty($category)) {
- return Result::error("暂无此导航",0);
- }
- // $result = [];
- return Result::success($category);
- }
- }
|