WebsiteService.php 142 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459346034613462346334643465346634673468346934703471347234733474347534763477347834793480348134823483348434853486348734883489349034913492349334943495349634973498349935003501350235033504350535063507350835093510351135123513351435153516351735183519352035213522352335243525352635273528352935303531353235333534353535363537353835393540354135423543354435453546354735483549355035513552355335543555355635573558355935603561356235633564356535663567356835693570357135723573357435753576357735783579358035813582358335843585358635873588358935903591359235933594359535963597359835993600360136023603360436053606360736083609361036113612361336143615361636173618361936203621362236233624
  1. <?php
  2. namespace App\JsonRpc;
  3. use App\Model\Article;
  4. use App\Model\Ad;
  5. use App\Model\Category;
  6. use App\Model\AdPlace;
  7. use App\Model\Department;
  8. use App\Model\District;
  9. use App\Model\FooterCategory;
  10. use App\Model\FooterContent;
  11. use App\Model\WebsiteTemplateInfo;
  12. use App\Model\Link;
  13. use App\Model\LetterOfComplaint;
  14. use App\Model\TemplateClass;
  15. use App\Model\Template;
  16. use App\Model\User;
  17. use App\Model\UserInfo;
  18. use App\Model\WebsiteRole;
  19. use App\Model\WebsiteRoleUser;
  20. use App\Model\Website;
  21. use App\Model\WebsiteColumn;
  22. use App\Model\Good;
  23. use App\Model\Book;
  24. use App\Model\ChatRecords;
  25. use App\Model\ChatTopic;
  26. use App\Model\JobRecruiting;
  27. use App\Model\JobHunting;
  28. use App\Model\Notice;
  29. use App\Model\Complaint;
  30. use App\Model\Order;
  31. use App\Model\WebsiteImg;
  32. use App\Model\Company;
  33. use App\Model\Project;
  34. use App\Model\ChatTopicsReply;
  35. use Hyperf\HttpServer\Contract\RequestInterface;
  36. use Hyperf\DbConnection\Db;
  37. use Hyperf\RpcServer\Annotation\RpcService;
  38. use App\Tools\Result;
  39. use Carbon\Carbon;
  40. use App\Model\WebsiteCategory;
  41. use App\Model\WebsiteGroup;
  42. use App\Model\WebsiteTemplate;
  43. use App\Model\Sector;
  44. use PhpParser\Node\Stmt\Return_;
  45. use SimpleKafkaClient\Metadata\Topic;
  46. use function PHPUnit\Framework\isNull;
  47. use Overtrue\Pinyin\Pinyin;
  48. use App\Tools\buildTree;
  49. use App\Model\WhiteRouter;
  50. use App\Model\Size;
  51. use App\Tools\PinyinHelper;
  52. use Hyperf\HttpServer\Annotation\AutoController;
  53. use Hyperf\Utils\Parallel;
  54. use Hyperf\Coroutine\Concurrent;
  55. use function Hyperf\Coroutine\batch;
  56. use Swoole\Coroutine;
  57. #[RpcService(name: "WebsiteService", protocol: "jsonrpc-http", server: "jsonrpc-http")]
  58. class WebsiteService implements WebsiteServiceInterface
  59. {
  60. /**
  61. * 获取网站列表
  62. * @param string $keyword
  63. * @param int $page
  64. * @param int $pageSize
  65. * @return array
  66. */
  67. public function getWebsitetList(array $data): array
  68. {
  69. // 构建查询
  70. $query = Website::when($data, function ($query) use ($data) {
  71. if (isset($data['keyword']) && !empty($data['keyword'])) {
  72. $query->where('website.website_name', 'like', '%' . trim($data['keyword']) . '%');
  73. }
  74. if (isset($data['website_column_id']) && !empty($data['website_column_id'])) {
  75. $query->whereJsonContains("website.website_column_arr_id", intval($data['website_column_id']));
  76. }
  77. if (isset($data['city_id']) && !empty($data['city_id'])) {
  78. $query->whereJsonContains("website.city_arr_id", intval($data['city_id']));
  79. }
  80. });
  81. // 执行查询并获取总数和结果
  82. $queryWithJoins = $query->leftJoin("website_column", "website.website_column_id", "website_column.id")
  83. ->leftJoin("district", "district.id", "website.city_id");
  84. $count = $queryWithJoins->count();
  85. $result = $queryWithJoins->select("website.*", "website_column.column_name", "district.name as city_name")
  86. ->limit($data['pageSize'])
  87. ->offset(($data['page'] - 1) * $data['pageSize'])
  88. ->orderBy("website.updated_at", "desc")
  89. ->get();
  90. if (empty($result)) {
  91. return Result::error("没有数据", 0);
  92. }
  93. $data = [
  94. 'rows' => $result->toArray(),
  95. 'count' => $count,
  96. ];
  97. return Result::success($data);
  98. }
  99. /**
  100. * @param array $data
  101. */
  102. public function createWebsite(array $data): array
  103. {
  104. var_dump("网站数据:", $data);
  105. // $wzbs = $this->getWebsitetAdkey($data);
  106. // return Result::success($wzbs);
  107. $web = Website::where('ad_key', $data['ad_key'])->first();
  108. if (!empty($web)) {
  109. return Result::error("网站名称简写重复,请填写", 0);
  110. }
  111. $insertData = [
  112. 'website_name' => $data['website_name'],
  113. 'logo' => $data['logo'] ?? '',
  114. 'website_url' => $data['website_url'] ?? '',
  115. //'city_id'=>$data['city_id']??0,
  116. 'website_column_id' => $data['website_column_id'],
  117. 'title' => $data['title'] ?? '',
  118. 'keywords' => $data['keywords'] ?? '',
  119. 'description' => $data['description'] ?? '',
  120. 'status' => $data['status'] ?? 1,
  121. 'website_column_arr_id' => $data['website_column_arr_id'],
  122. //'city_arr_id'=>$data['city_arr_id']??[0],
  123. 'template_id' => $data['template_id'] ?? 0,
  124. 'suffix' => $data['suffix'] ?? "",
  125. 'ad_key' => $data['ad_key'] ?? "",
  126. ];
  127. $result = Website::insertGetId($insertData);
  128. if (empty($result)) {
  129. return Result::error("创建网站失败", 0);
  130. } else {
  131. return Result::success(["id" => $result]);
  132. }
  133. }
  134. /**
  135. * 修改网站头部基础信息
  136. * @param array $data
  137. */
  138. public function updateWebsite(int $id, array $data): array
  139. {
  140. $website = Website::where('id', $id)->first();
  141. if (empty($website)) {
  142. return Result::error("网站不存在", 0);
  143. }
  144. $insertData = [
  145. 'website_name' => $data['website_name'],
  146. 'logo' => $data['logo'] ?? '',
  147. 'website_url' => $data['website_url'] ?? '',
  148. // 'city_id'=>$data['city_id']??0,
  149. 'website_column_id' => $data['website_column_id'],
  150. 'title' => $data['title'] ?? '',
  151. 'keywords' => $data['keywords'] ?? '',
  152. 'description' => $data['description'] ?? '',
  153. // 'status' => $data['status'] ?? 0,
  154. 'website_column_arr_id' => $data['website_column_arr_id'],
  155. // 'city_arr_id'=>$data['city_arr_id']??[0],
  156. 'template_id' => $data['template_id'] ?? 0,
  157. 'suffix' => $data['suffix'] ?? "",
  158. 'ad_key' => $data['ad_key'] ?? "",
  159. ];
  160. $web_templsate = WebsiteTemplateInfo::where('website_id', $data['id'])->first();
  161. // `status` tinyint(1) DEFAULT '0' COMMENT '0:未构建 1:未应用 2:已应用',
  162. if (!empty($web_templsate) && $web_templsate['status'] == 2) {
  163. return Result::error("此网站已应用,不可修改基本信息", 0);
  164. }
  165. Db::beginTransaction();
  166. try{
  167. if($data['ad_key'] != $website['ad_key']){
  168. $web = Website::where(function ($query) use ($data) {
  169. $query->where('id','!=', $data['id'])
  170. ->where('ad_key', $data['ad_key']);
  171. })->first();
  172. if (!empty($web)) {
  173. Db::rollBack();
  174. return Result::error("网站名称简写重复,请填写", 0);
  175. }
  176. $ad_place = AdPlace::where('website_id', $data['id'])->select('ad_tag','id')->get()->toArray();
  177. if (!empty($ad_place)) {
  178. foreach($ad_place as $key => $val){
  179. $ad_keys = explode('_', $val['ad_tag']);
  180. $ad_keys[0] = $data['ad_key'];
  181. $ad_place[$key]['ad_tag'] = implode('_', $ad_keys);
  182. // $up_adtags = AdPlace::where('id', $val['id'])->update(['ad_tag' => $ad_tags[$key]]);
  183. }
  184. $up_adtags = AdPlace::upsert($ad_place, ['id'], ['ad_tag']);
  185. if(empty($up_adtags)){
  186. Db::rollBack();
  187. return Result::error('广告位标识同步失败', 0);
  188. }
  189. }
  190. $template = WebsiteTemplate::where('website_id', $data['id'])->first();
  191. if (!empty($template)) {
  192. // Eloquent 没有 replace 方法,推测你可能是想替换模板中的字符串,假设是更新 content 字段
  193. $uptemplate = WebsiteTemplate::where('website_id', $data['id'])->update([
  194. 'template_data' => DB::raw("REPLACE(template_data, '{$website['ad_key']}', '{$data['ad_key']}')")
  195. ]);
  196. if(empty($uptemplate)){
  197. Db::rollBack();
  198. return Result::error("更新模板失败!", 0);
  199. }
  200. }
  201. }
  202. // return Result::success($UP_template);
  203. $result = Website::where('id', $data['id'])->update($insertData);
  204. if(empty($result)){
  205. Db::rollBack();
  206. return Result::error("更新网站失败!", 0);
  207. }
  208. Db::commit();
  209. return Result::success("更新成功");
  210. }catch(\Exception $e){
  211. Db::rollBack();
  212. return Result::error($e->getMessage(), 0);
  213. }
  214. }
  215. /**
  216. * @param int $id
  217. * @return array
  218. */
  219. public function delWebsite(int $id): array
  220. {
  221. $result = Website::where('id', $id)->delete();
  222. if (empty($result)) {
  223. return Result::error("删除失败", 0);
  224. } else {
  225. return Result::success();
  226. }
  227. }
  228. /**
  229. * @param int $id
  230. * @return array
  231. */
  232. public function getWebsiteInfo(int $id): array
  233. {
  234. $where = [
  235. ['website.id', '=', $id],
  236. ];
  237. $result = Website::where($where)
  238. ->leftJoin("template", "template.id", "website.template_id")
  239. ->select("website.*", "template.template_name", "template.template_img")
  240. ->first();
  241. if (empty($result)) {
  242. return Result::error("数据不存在", 0);
  243. } else {
  244. return Result::success($result->toArray());
  245. }
  246. }
  247. /**
  248. * 查询所有的站点栏目
  249. * @return array
  250. */
  251. public function getWebsiteColumn(array $data): array
  252. {
  253. $result = WebsiteColumn::where($data)->get();
  254. if (empty($result)) {
  255. return Result::error("数据不存在", 0);
  256. } else {
  257. return Result::success($result->toArray());
  258. }
  259. }
  260. /**
  261. * @param string $keyword
  262. * @param int $page
  263. * @param int $pageSize
  264. * @return array
  265. */
  266. public function getWebsiteColumnList(array $data): array
  267. {
  268. $where = [];
  269. if (isset($data['keyword']) && $data['keyword']) {
  270. array_push($where, ['website_column.column_name', 'like', '%' . $data['keyword'] . '%']);
  271. }
  272. $result = WebsiteColumn::where($where)
  273. ->leftJoin("website_column as wc", "website_column.pid", "wc.id")
  274. ->select("website_column.*", "wc.column_name as parent_column_name")
  275. ->limit($data['pageSize'])->offset(($data['page'] - 1) * $data['pageSize'])->get();
  276. $count = WebsiteColumn::where($where)->count();
  277. if (empty($result)) {
  278. return Result::error("没有数据", 0);
  279. }
  280. $data = [
  281. 'rows' => $result->toArray(),
  282. 'count' => $count,
  283. ];
  284. return Result::success($data);
  285. }
  286. /**
  287. * @param array $data
  288. * @return array
  289. */
  290. public function createWebsiteColumn(array $data): array
  291. {
  292. $insertData = [
  293. 'column_name' => $data['column_name'],
  294. 'pid' => $data['pid'] ?? '',
  295. 'column_arr_id' => $data['column_arr_id'] ?? [0],
  296. 'sort' => $data['sort'] ?? 0,
  297. 'remark' => $data['remark'] ?? '',
  298. ];
  299. $result = WebsiteColumn::insertGetId($insertData);
  300. if (empty($result)) {
  301. return Result::error("创建失败", 0);
  302. } else {
  303. return Result::success(["id" => $result]);
  304. }
  305. }
  306. /**
  307. * @param int $id
  308. * @param array $data
  309. * @return array
  310. */
  311. public function updateWebsiteColumn(int $id, array $data): array
  312. {
  313. $insertData = [
  314. 'column_name' => $data['column_name'],
  315. 'pid' => $data['pid'] ?? '',
  316. 'column_arr_id' => $data['column_arr_id'] ?? [0],
  317. 'sort' => $data['sort'] ?? 0,
  318. 'remark' => $data['remark'] ?? '',
  319. ];
  320. $result = WebsiteColumn::where('id', $id)->update($insertData);
  321. if (empty($result)) {
  322. return Result::error("更新失败", 0);
  323. } else {
  324. return Result::success();
  325. }
  326. }
  327. /**
  328. * @param int $id
  329. * @return array
  330. */
  331. public function delWebsiteColumn(int $id): array
  332. {
  333. $list = WebsiteColumn::where(['pid' => $id])->get();
  334. if ($list) {
  335. return Result::error("存在子网系,不能删除,请先删除子网系", 0);
  336. }
  337. $result = WebsiteColumn::where('id', $id)->delete();
  338. if (empty($result)) {
  339. return Result::error("删除失败", 0);
  340. } else {
  341. return Result::success();
  342. }
  343. }
  344. /**
  345. * @param string $keyword
  346. * @param int $page
  347. * @param int $pageSize
  348. * @return array
  349. */
  350. public function getWebsiteRoleList(string $keyword, int $page, int $pageSize, int $websiteId): array
  351. {
  352. $where = [
  353. ['role.role_name', 'like', '%' . $keyword . '%'],
  354. ['website_role.website_id', '=', $websiteId],
  355. ];
  356. $result = WebsiteRole::where($where)
  357. ->leftJoin("role", "role.id", "website_role.role_id")
  358. ->select("role.*", "website_role.type", "website_role.role_id", "website_role.id as website_role_id", "website_role.website_id")
  359. ->limit($pageSize)->offset(($page - 1) * $pageSize)->get();
  360. $count = WebsiteRole::where($where)->leftJoin("role", "role.id", "website_role.role_id")->count();
  361. if (empty($result)) {
  362. return Result::error("没有数据", 0);
  363. }
  364. $data = [
  365. 'rows' => $result->toArray(),
  366. 'count' => $count,
  367. ];
  368. return Result::success($data);
  369. }
  370. /**
  371. * @param array $data
  372. * @return array
  373. */
  374. public function createWebsiteRole(array $data): array
  375. {
  376. $insertData = [
  377. 'website_id' => $data['website_id'],
  378. 'role_id' => $data['role_id'] ?? '',
  379. ];
  380. $info = WebsiteRole::where($insertData)->first();
  381. if ($info) {
  382. return Result::error("不能重复添加角色", 0);
  383. }
  384. $insertData['admin_user_id'] = $data['admin_user_id'] ?? '';
  385. $insertData['type'] = $data['type'] ?? '';
  386. $result = WebsiteRole::insertGetId($insertData);
  387. if (empty($result)) {
  388. return Result::error("创建失败", 0);
  389. } else {
  390. return Result::success(["id" => $result]);
  391. }
  392. }
  393. /**
  394. * 暂时用不上
  395. * @param int $id
  396. * @param array $data
  397. * @return array
  398. */
  399. public function updateWebsiteRole(int $id, array $data): array
  400. {
  401. $insertData = [
  402. 'website_id' => $data['website_id'],
  403. 'type' => $data['type'] ?? '',
  404. ];
  405. $result = WebsiteRole::where('id', $id)->update($insertData);
  406. if (empty($result)) {
  407. return Result::error("更新失败", 0);
  408. } else {
  409. return Result::success();
  410. }
  411. }
  412. /**
  413. * @param int $id
  414. * @return array
  415. */
  416. public function delWebsiteRole(int $id): array
  417. {
  418. $result = WebsiteRole::where('id', $id)->delete();
  419. if (empty($result)) {
  420. return Result::error("删除失败", 0);
  421. } else {
  422. return Result::success();
  423. }
  424. }
  425. /**
  426. * @param string $keyword
  427. * @param int $page
  428. * @param int $pageSize
  429. * @return array
  430. */
  431. public function getWebsiteRoleUserList(string $keyword, int $page, int $pageSize, int $websiteId, int $roleId): array
  432. {
  433. $where = [
  434. ['website_role_user.website_id', '=', $websiteId],
  435. ['website_role_user.role_id', '=', $roleId],
  436. ];
  437. $count = WebsiteRoleUser::where($where)->count();
  438. $where[] = ['u.user_name', 'like', '%' . $keyword . '%'];
  439. $result = WebsiteRoleUser::where($where)
  440. ->leftJoin("user as u", "website_role_user.user_id", "u.id")
  441. ->leftJoin("website as w", "website_role_user.website_id", "u.id")
  442. ->leftJoin("role as r", "website_role_user.role_id", "r.id")
  443. ->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')
  444. ->limit($pageSize)->offset(($page - 1) * $pageSize)->get();
  445. if (empty($result)) {
  446. return Result::error("没有数据", 0);
  447. }
  448. $data = [
  449. 'rows' => $result->toArray(),
  450. 'count' => $count,
  451. ];
  452. return Result::success($data);
  453. }
  454. /**
  455. * @param array $data
  456. * @return array
  457. */
  458. public function createWebsiteRoleUser(array $data): array
  459. {
  460. $insertData = [
  461. 'website_id' => $data['website_id'],
  462. 'user_id' => $data['user_id'] ?? '',
  463. ];
  464. $info = WebsiteRoleUser::where($insertData)->first();
  465. if ($info) {
  466. return Result::error("不能重复添加角色用户", 0);
  467. }
  468. $insertData['role_id'] = $data['role_id'] ?? '';
  469. $insertData['admin_user_id'] = $data['admin_user_id'] ?? '';
  470. $insertData['type'] = $data['type'] ?? '';
  471. $result = WebsiteRoleUser::insertGetId($insertData);
  472. if (empty($result)) {
  473. return Result::error("创建失败", 0);
  474. } else {
  475. return Result::success(["id" => $result]);
  476. }
  477. }
  478. /**
  479. * @param int $id
  480. * @param array $data
  481. * @return array
  482. */
  483. public function updateWebsiteRoleUser(int $id, array $data): array
  484. {
  485. $insertData = [
  486. 'website_id' => $data['website_id'],
  487. 'type' => $data['type'] ?? '',
  488. 'type_id' => $data['type_id'] ?? '',
  489. 'role_id' => $data['role_id'] ?? '',
  490. ];
  491. $result = WebsiteRoleUser::where('id', $id)->update($insertData);
  492. if (empty($result)) {
  493. return Result::error("更新失败", 0);
  494. } else {
  495. return Result::success();
  496. }
  497. }
  498. /**
  499. * @param int $id
  500. * @return array
  501. */
  502. public function delWebsiteRoleUser(int $id): array
  503. {
  504. $result = WebsiteRoleUser::where('id', $id)->delete();
  505. if (empty($result)) {
  506. return Result::error("删除失败", 0);
  507. } else {
  508. return Result::success();
  509. }
  510. }
  511. /**
  512. * 根据域名获取网站 站点id
  513. * @param array $data
  514. * @return array
  515. */
  516. public function getWebsiteId(array $data): array
  517. {
  518. $result = Website::whereJsonContains('website_url', $data['website_url'])->first();
  519. if (empty($result)) {
  520. return Result::error("查询站点失败", 0);
  521. } else {
  522. return Result::success($result);
  523. }
  524. }
  525. /**
  526. * 查询网站下面的导航
  527. * @param array $data
  528. * @return array
  529. */
  530. public function getWebsiteCategory(array $data): array
  531. {
  532. $where = [
  533. 'website_id' => $data['website_id'],
  534. ];
  535. // 使用递归查询构建树状结构
  536. $category = WebsiteCategory::where($where)
  537. ->with([
  538. 'children' => function ($query) {
  539. $query->orderBy('sort', 'asc');
  540. },
  541. ])
  542. ->orderBy('sort', 'asc')
  543. ->where('pid', 0) // 仅查询顶级节点
  544. ->get()->all();
  545. if (empty($category)) {
  546. return Result::error("查询站点栏目失败", 0);
  547. } else {
  548. $count = WebsiteCategory::where($where)->count();
  549. $result = [
  550. 'rep' => $category,
  551. 'count' => $count,
  552. ];
  553. return Result::success($result);
  554. }
  555. }
  556. /**
  557. * 查询网站的广告
  558. * @param array $data
  559. * @return array
  560. */
  561. public function getWebsiteAdvertisement(array $data): array
  562. {
  563. $where = [
  564. 'ad_place.status' => 1,
  565. ];
  566. if (isset($data['ad_tag']) && !empty($data['ad_tag'])) {
  567. $now = Carbon::now()->format('Y-m-d H:i:s'); // 获取当前时间
  568. $where[] = ['ad_place.ad_tag', 'like', '%' . $data['ad_tag'] . '%'];
  569. // return Result::success($where);
  570. $result = AdPlace::where($where)
  571. ->leftJoin("ad", function ($join) use ($now) {
  572. $join->on("ad.pid", "=", "ad_place.id")
  573. ->where('ad.status', 1)
  574. ->where('ad.fromtime', '<=', $now)
  575. ->where('ad.totime', '>=', $now);
  576. })
  577. ->select(
  578. 'ad_place.name as place_name',
  579. 'ad_place.thumb',
  580. 'ad_place.ad_tag',
  581. 'ad_place.introduce',
  582. 'ad.name as ad_name',
  583. 'ad.image_src',
  584. 'ad.image_url',
  585. 'ad.image_alt',
  586. 'ad_place.ad_url'
  587. )
  588. ->get()->all();
  589. } else {
  590. $now = Carbon::now()->format('Y-m-d H:i:s'); // 获取当前时间
  591. // return Result::success($where);
  592. $result = AdPlace::where($where)
  593. ->where('ad_place.website_id', $data['website_id'])
  594. ->leftJoin("ad", function ($join) use ($now) {
  595. $join->on("ad.pid", "=", "ad_place.id")
  596. ->where('ad.status', 1)
  597. ->where('ad.fromtime', '<=', $now)
  598. ->where('ad.totime', '>=', $now);
  599. })
  600. ->select(
  601. 'ad_place.name as place_name',
  602. 'ad_place.thumb',
  603. 'ad_place.ad_tag',
  604. 'ad_place.introduce',
  605. 'ad.name as ad_name',
  606. 'ad.image_src',
  607. 'ad.image_url',
  608. 'ad.image_alt',
  609. 'ad_place.ad_url',
  610. )
  611. ->get()->all();
  612. // return Result::error("请选择广告位!",0);
  613. }
  614. if (empty($result)) {
  615. return Result::error("此广告位不存在!", 0);
  616. }
  617. return Result::success($result);
  618. }
  619. /**
  620. *
  621. * @param array $data
  622. * @return array
  623. */
  624. /**网站行政职能搜索 */
  625. public function selectWebsiteDepartment(array $data): array
  626. {
  627. $depart = Department::where('pid', 0)->orderBy('id', 'asc')->get();
  628. if (isset($data['keyword']) && !empty($data['keyword'])) {
  629. $departments = Department::where('name', 'like', '%' . $data['keyword'] . '%')->get();
  630. if (empty($departments)) {
  631. $result['message'] = "未查询到与此相关职能部门";
  632. } else {
  633. $count = Department::where('name', 'like', "%{$data['keyword']}%")->count();
  634. $m = [
  635. 'department' => $depart,
  636. 'type' => $departments,
  637. 'count' => $count,
  638. ];
  639. }
  640. $result['sele'] = $m;
  641. return Result::success($result['sele']);
  642. }
  643. $result = $depart;
  644. return Result::success($result);
  645. }
  646. /**
  647. * 搜索地区
  648. * @param array $data
  649. * @return array
  650. */
  651. public function selectWebsiteArea(array $data): array
  652. {
  653. // return Result::success($data);
  654. $pid = $data['pid'] ?? 0;
  655. $result = District::leftJoin('district as district2', 'district.pid', '=', 'district2.id')
  656. ->where('district.pid', $pid)
  657. ->where('district.status', 1)
  658. ->select('district.*', 'district2.name as pid_name')
  659. ->orderBy('district.code')->get();
  660. if (empty($result)) {
  661. return Result::error("未查询到此地区", 0);
  662. } else {
  663. return Result::success($result);
  664. }
  665. }
  666. /**
  667. * 获取栏目
  668. * @param array $data
  669. * @return array
  670. */
  671. public function getWebsiteModelCategory(array $data): array
  672. {
  673. // return Result::success($data);
  674. $website_id = [
  675. 'website_id' => $data['website_id'],
  676. ];
  677. // 初始化 $pid 数组
  678. // $pid = [];
  679. // 以下注释掉的代码是之前的逻辑,用于获取非顶级分类的 pid
  680. $pidQuery = WebsiteCategory::where($website_id)
  681. ->where('pid', '!=', 0)
  682. ->orderBy('sort')
  683. ->select('pid', 'category_id', 'alias', 'aLIas_pinyin');
  684. $pid = $pidQuery->pluck('pid');
  685. $pid = array_values(array_unique($pid->toArray()));
  686. // 构建查询语句
  687. $query = WebsiteCategory::where($website_id)
  688. ->where('pid', $data['pid'])
  689. ->offset($data['placeid'])
  690. ->limit($data['num'])
  691. ->orderBy('sort')
  692. ->orderBy('updated_at', 'desc');
  693. // 如果 $pid 数组不为空,添加 CASE WHEN 条件
  694. if (!empty($pid)) {
  695. $placeholders = implode(',', array_fill(0, count($pid), '?'));
  696. $query->selectRaw("website_category.*, CASE WHEN website_category.category_id IN ($placeholders) THEN 1 ELSE 0 END AS children_count", $pid);
  697. } else {
  698. // 如果 $pid 数组为空,不添加 CASE WHEN 条件,添加字段 children_count 并赋值为 0
  699. $query->select('website_category.*', DB::raw('0 as children_count'));
  700. }
  701. // 执行查询
  702. $placeid = $data['placeid'] - 1;
  703. $result = $query->offset($placeid)->limit($data['num'])->get();
  704. if (!empty($result)) {
  705. $pidResults = $pidQuery->get();
  706. if (isset($data['type']) && $data['type'] == 1) {
  707. $result = $result->map(function ($item) use ($pidResults) {
  708. $children = $pidResults->where('pid', $item->category_id)->map(function ($child) {
  709. if (!empty($child)) {
  710. return $child;
  711. }
  712. });
  713. // 重置索引,使 key 值从 0 开始
  714. $item->children = $children->values();
  715. return $item;
  716. });
  717. } else {
  718. $pidMap = $pidResults->keyBy('pid');
  719. $result->each(function ($record) use ($pidMap) {
  720. if ($pidMap->has($record->category_id)) {
  721. $pidResult = $pidMap->get($record->category_id);
  722. $record->chilid_id = $pidResult->category_id;
  723. $record->chilid_alias = $pidResult->alias;
  724. // $record->aLIas_pinyin = $pidResult->aLIas_pinyin;
  725. }
  726. });
  727. }
  728. return Result::success($result);
  729. } else {
  730. return Result::error("本网站暂无栏目", 0);
  731. }
  732. }
  733. /**
  734. * 获取友情链接
  735. * @param array $data
  736. * @return array
  737. */
  738. public function selectWebsiteLinks(array $data): array
  739. {
  740. $where = [
  741. 'website_id' => $data['website_id'],
  742. 'status' => 1,
  743. 'type' => $data['type'],
  744. ];
  745. $num = $data['num'];
  746. $result = Link::where($where)->orderBy('sort')->limit($num)->get();
  747. if (!empty($result)) {
  748. return Result::success($result);
  749. } else {
  750. return Result::error("本网站暂无此类型友情链接", 0);
  751. }
  752. }
  753. /**
  754. * 网站首页数据统计, 管理员
  755. * @return void
  756. */
  757. public function getAdminIndex(array $data): array
  758. {
  759. var_dump("用户类型:", $data);
  760. switch ($data['type_id']) {
  761. case 10000:
  762. $res = [];
  763. //网站
  764. $res['website']['count'] = 0;
  765. $res['website']['growth_rate'] = 0;
  766. //资讯
  767. $res['article']['count'] = 0;
  768. $res['article']['growth_rate'] = 0;
  769. //导航池
  770. $res['category']['count'] = 0;
  771. $res['category']['growth_rate'] = 0;
  772. //商品
  773. $res['good']['count'] = 0;
  774. $res['book']['count'] = 0;
  775. $res['jobHunting']['count'] = 0;
  776. $res['jobRecruiting']['count'] = 0;
  777. //近一月数据
  778. $res['monthArticle'] = [];
  779. //用户类型
  780. $res['userType'] = [];
  781. $res['website']['count'] = Website::where([])->count();
  782. $res['article']['count'] = Article::whereIn('status', [1])->count();
  783. $res['category']['count'] = Category::where([])->count();
  784. $res['good']['count'] = Good::whereIn('status', [2])->count();
  785. $res['book']['count'] = Book::whereIn('status', [2])->count();
  786. $res['jobHunting']['count'] = JobHunting::whereIn('status', [2])->count();
  787. $res['jobRecruiting']['count'] = JobRecruiting::whereIn('status', [1])->count();
  788. $res['complaint']['count'] = Complaint::whereIn('status', [2])->count();
  789. $res['notice']['count'] = Notice::whereIn('status', [2])->count();
  790. //已审核数量
  791. $res['company']['count'] = Company::whereIn('status', [1])->count();
  792. $res['project']['count'] = Project::whereIn('status', [1])->count();
  793. // $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;');
  794. $res['monthArticle'] = Db::select(' SELECT DATE(article.created_at) AS date,COUNT(*) AS count ,user.type_id FROM article left JOIN user on article.admin_user_id = user.id WHERE
  795. article.status =1 and article.created_at >= CURDATE() - INTERVAL 30 DAY GROUP BY DATE(article.created_at),`user`.type_id ORDER BY date ASC');
  796. $res['monthGood'] = Db::select(' SELECT DATE(good.created_at) AS date,COUNT(*) AS count ,user.type_id FROM good left JOIN user on good.user_id = user.id WHERE
  797. good.status =2 and good.created_at >= CURDATE() - INTERVAL 30 DAY GROUP BY DATE(good.created_at),`user`.type_id ORDER BY date ASC');
  798. $res['monthBook'] = Db::select(' SELECT DATE(book.created_at) AS date,COUNT(*) AS count ,user.type_id FROM book left JOIN user on book.user_id = user.id WHERE book.status =2 and book.created_at >= CURDATE() - INTERVAL 30 DAY GROUP BY DATE(book.created_at),`user`.type_id ORDER BY date ASC');
  799. $res['monthJobHunting'] = Db::select(' SELECT DATE(job_hunting.created_at) AS date,COUNT(*) AS count ,user.type_id FROM job_hunting left JOIN user on job_hunting.user_id = user.id WHERE job_hunting.status =2 and job_hunting.created_at >= CURDATE() - INTERVAL 30 DAY GROUP BY DATE(job_hunting.created_at),`user`.type_id ORDER BY date ASC');
  800. $res['monthJobRecruiting'] = Db::select(' SELECT DATE(job_recruiting.created_at) AS date,COUNT(*) AS count ,user.type_id FROM job_recruiting left JOIN user on job_recruiting.user_id = user.id WHERE job_recruiting.status =1 and job_recruiting.created_at >= CURDATE() - INTERVAL 30 DAY GROUP BY DATE(job_recruiting.created_at),`user`.type_id ORDER BY date ASC');
  801. //company project 1 已审核
  802. $res['monthCompany'] = Db::select(' SELECT DATE(company.created_at) AS date,COUNT(*) AS count ,user.type_id FROM company left JOIN user on company.user_id = user.id WHERE company.status =1 and company.created_at >= CURDATE() - INTERVAL 30 DAY GROUP BY DATE(company.created_at),`user`.type_id ORDER BY date ASC');
  803. $res['monthProject'] = Db::select(' SELECT DATE(project.created_at) AS date,COUNT(*) AS count ,user.type_id FROM project left JOIN user on project.user_id = user.id WHERE project.status =1 and project.created_at >= CURDATE() - INTERVAL 30 DAY GROUP BY DATE(project.created_at),`user`.type_id ORDER BY date ASC');
  804. $res['userType'] = User::where([])->selectRaw("count(*) as counts,type_id")->groupBy('type_id')->get();
  805. //待审核数据
  806. $res['apply']['article'] = Article::where(['status' => 0])->count(); //
  807. $res['apply']['good'] = Good::where(['status' => 1])->count();
  808. $res['apply']['book'] = Book::where(['status' => 1])->count();
  809. $res['apply']['jobHunting'] = JobHunting::where(['status' => 1])->count();
  810. $res['apply']['jobRecruiting'] = JobRecruiting::where(['status' => 0])->count();
  811. $res['apply']['complaint'] = Complaint::where(['status' => 1])->count();
  812. $res['apply']['notice'] = Notice::where(['status' => 1])->count(); //订单状态:1:通过;2:驳回;3:撤回;4:修改;5:过期;6:待审核;7:结束',
  813. $res['apply']['order'] = Order::where(['status' => 6])->count();
  814. $res['apply']['company'] = Company::where(['status' => 1])->count();
  815. $res['apply']['project'] = Project::where(['status' => 1])->count();
  816. return Result::success($res);
  817. case 1:
  818. case 2:
  819. case 3:
  820. case 4:
  821. $res = [];
  822. if ($data['type_id'] == 4) {
  823. $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;');
  824. $res = [];
  825. //查询已审核文章
  826. $user_id = $data['user_id'];
  827. $article = Article::where('status', 1)
  828. ->where('admin_user_id', $user_id)
  829. ->orderBy('updated_at', 'desc')
  830. ->limit(10)
  831. ->get();
  832. $res['letterOfComplaintList'] = $result;
  833. $res['article'] = $article;
  834. }
  835. //查询已审核文章
  836. $user_id = $data['user_id'];
  837. $now = Carbon::now();
  838. // 系统提醒审核消息
  839. $sys_msg = [];
  840. $article = Article::where('status', 0)
  841. ->where('admin_user_id', $user_id)
  842. ->orderBy('updated_at', 'desc')
  843. ->limit(5)
  844. ->get(['id', 'title', 'updated_at'])
  845. ->map(function ($item) use ($now) {
  846. $item->class = '资讯';
  847. $item->formatted_updated_at = $this->timeAgo($item->updated_at, $now);
  848. return $item;
  849. });
  850. var_dump($article, '---1--');
  851. $good = Good::where('status', 1)
  852. ->where('user_id', $user_id)
  853. ->orderBy('updated_at', 'desc')
  854. ->get(['id', 'name as title', 'updated_at'])
  855. ->map(function ($item) use ($now) {
  856. //去掉name的属性
  857. $item->class = '商品';
  858. $item->formatted_updated_at = $this->timeAgo($item->updated_at, $now);
  859. return $item;
  860. });
  861. $book = Book::query()
  862. ->where('status', 1)
  863. ->where('user_id', $user_id)
  864. ->orderBy('updated_at', 'desc')
  865. ->get(['id', 'title', 'updated_at'])
  866. ->map(function ($item) use ($now) {
  867. //去掉name的属性
  868. $item->class = '书刊';
  869. $item->formatted_updated_at = $this->timeAgo($item->updated_at, $now);
  870. return $item;
  871. });
  872. //招聘 求职
  873. $jobhunting = JobHunting::query()
  874. ->where('status', 1)
  875. ->where('user_id', $user_id)
  876. ->orderBy('updated_at', 'desc')
  877. ->get(['id', 'name as title', 'updated_at'])
  878. ->map(function ($item) use ($now) {
  879. //去掉name的属性
  880. $item->class = '求职';
  881. $item->formatted_updated_at = $this->timeAgo($item->updated_at, $now);
  882. return $item;
  883. });
  884. $jobrecruiting = JobRecruiting::query()
  885. ->where('status', 0)
  886. ->where('user_id', $user_id)
  887. ->orderBy('updated_at', 'desc')
  888. ->get(['id', 'title', 'updated_at'])
  889. ->map(function ($item) use ($now) {
  890. //去掉name的属性
  891. $item->class = '招聘';
  892. $item->formatted_updated_at = $this->timeAgo($item->updated_at, $now);
  893. return $item;
  894. });
  895. //通知 投诉
  896. $notice = Notice::query()
  897. ->where('status', 1)
  898. ->where('user_id', $user_id)
  899. ->orderBy('updated_at', 'desc')
  900. ->get(['id', 'title', 'updated_at'])
  901. ->map(function ($item) use ($now) {
  902. //去掉name的属性
  903. $item->class = $item->type == 1 ? "通知" : "公告";
  904. $item->formatted_updated_at = $this->timeAgo($item->updated_at, $now);
  905. return $item;
  906. });
  907. $complaint = Complaint::query()
  908. ->where('status', 1)
  909. ->where('user_id', $user_id)
  910. ->orderBy('updated_at', 'desc')
  911. ->get(['id', 'title', 'updated_at'])
  912. ->map(function ($item) use ($now) {
  913. //去掉name的属性
  914. $item->class = "投诉";
  915. $item->formatted_updated_at = $this->timeAgo($item->updated_at, $now);
  916. return $item;
  917. });
  918. //项目 公司 待审核 :0:未审核;1:已审核;2:已拒绝
  919. $project = Project::query()
  920. ->where('status', 0)
  921. ->where('user_id', $user_id)
  922. ->orderBy('updated_at', 'desc')
  923. ->get(['id', 'title', 'updated_at'])
  924. ->map(function ($item) use ($now) {
  925. //去掉name的属性
  926. $item->class = "项目";
  927. $item->formatted_updated_at = $this->timeAgo($item->updated_at, $now);
  928. return $item;
  929. });
  930. $company = Company::query()
  931. ->where('status', 0)
  932. ->where('user_id', $user_id)
  933. ->orderBy('updated_at', 'desc')
  934. ->get(['id', 'title', 'updated_at'])
  935. ->map(function ($item) use ($now) {
  936. //去掉name的属性
  937. $item->class = "公司";
  938. $item->formatted_updated_at = $this->timeAgo($item->updated_at, $now);
  939. return $item;
  940. });
  941. // var_dump($jobrecruiting, '-1--------------------11111111111111--');
  942. // var_dump($good, '-3--');
  943. // $s = $article->toArray();
  944. // var_dump($s, '=====31111111111111111');
  945. // 合并两个集合
  946. // 合并两个集合,并按 updated_at 倒序排序
  947. // $combined = $article->merge($good)->sortByDesc('updated_at');
  948. $combined = $article
  949. ->concat($good)
  950. ->concat($book)
  951. ->concat($jobhunting)
  952. ->concat($jobrecruiting)
  953. ->concat($notice)
  954. ->concat($complaint)
  955. ->concat($project)
  956. ->concat($company)
  957. ->sortByDesc(function ($item) {
  958. return Carbon::createFromFormat('Y-m-d H:i:s', $item->updated_at);
  959. });
  960. // ->sortBy('updated_at');
  961. // var_dump($combined, '--4--');
  962. // 转换为数组输出
  963. $res['sys_msg'] = $combined->values()->all();
  964. // 互动消息
  965. $chat_msg = [];
  966. // 通知投诉
  967. $notice_msg = [];
  968. // $res['sys_msg'] = $sys_msg;
  969. $chat_single_msg = ChatRecords::where('user_id', $user_id)
  970. ->where('is_read', 0)
  971. ->where('talk_type', 1)
  972. ->orderBy('updated_at', 'desc')
  973. ->limit(5)
  974. ->get(['id', 'content', 'updated_at'])
  975. ->map(function ($item) use ($now) {
  976. $item->class = "单聊";
  977. $item->formatted_updated_at = $this->timeAgo($item->updated_at, $now);
  978. return $item;
  979. });
  980. $chat_group_msg = ChatRecords::where('user_id', $user_id)
  981. ->where('is_read', 0)
  982. ->where('talk_type', 2)
  983. ->leftJoin('chat_groups', 'chat_records.receiver_id', '=', 'chat_groups.id')
  984. ->orderBy('updated_at', 'desc')
  985. ->limit(5)
  986. ->get(['chat_records.id', 'content as content1', 'chat_records.updated_at', 'chat_groups.group_name as content'])
  987. ->map(function ($item) use ($now) {
  988. $item->class = "群聊";
  989. $item->formatted_updated_at = $this->timeAgo($item->updated_at, $now);
  990. return $item;
  991. });
  992. $topic_msg = ChatTopic::where('chat_topics.user_id', $user_id)
  993. ->whereNotNull('chat_topics_reply.updated_at')
  994. ->leftJoin('chat_topics_reply', 'chat_topics.id', '=', 'chat_topics_reply.topic_id')
  995. ->select('chat_topics.id', 'chat_topics.title as content', 'chat_topics_reply.updated_at as updated_at')
  996. ->orderBy('updated_at', 'desc')
  997. ->limit(5)
  998. ->get(['chat_topics.id', 'chat_topics.content', 'chat_topics.updated_at'])
  999. ->map(function ($item) use ($now) {
  1000. $item->class = "话题";
  1001. // $item->content = $item->content;
  1002. $item->formatted_updated_at = $this->timeAgo($item->updated_at, $now);
  1003. return $item;
  1004. });
  1005. // 合并单聊和群聊消息
  1006. $chat_msg = $chat_single_msg
  1007. ->concat($chat_group_msg)
  1008. ->concat($topic_msg)
  1009. ->sortByDesc(function ($item) {
  1010. return Carbon::createFromFormat('Y-m-d H:i:s', $item->updated_at);
  1011. })->values()->all();
  1012. $res['chat_msg'] = $chat_msg;
  1013. //未读消息
  1014. $notce_recieve_msg = Notice::where('status', 1)
  1015. ->whereJsonContains('re_user_ids', $user_id)
  1016. ->where(function ($query) use ($user_id) {
  1017. $query->whereNull('read_id')
  1018. ->orWhereRaw('NOT JSON_CONTAINS(`read_id`, ?)', [$user_id]);
  1019. })
  1020. ->orderBy('updated_at', 'desc')
  1021. ->limit(5)
  1022. ->get(['id', 'title', 'updated_at'])
  1023. ->map(function ($item) use ($now) {
  1024. $item->class = "通知";
  1025. $item->formatted_updated_at = $this->timeAgo($item->updated_at, $now);
  1026. return $item;
  1027. });
  1028. $complaint_recieve_msg = Complaint::where('status', 1)
  1029. ->whereJsonContains('re_user_ids', $user_id)
  1030. ->where(function ($query) use ($user_id) {
  1031. $query->whereNull('read_id')
  1032. ->orWhereRaw('NOT JSON_CONTAINS(`read_id`, ?)', [$user_id]);
  1033. })
  1034. ->orderBy('updated_at', 'desc')
  1035. ->limit(5)
  1036. ->get(['id', 'title', 'updated_at'])
  1037. ->map(function ($item) use ($now) {
  1038. $item->class = "投诉";
  1039. $item->formatted_updated_at = $this->timeAgo($item->updated_at, $now);
  1040. return $item;
  1041. });
  1042. // 合并消息
  1043. $notice_msg = $notce_recieve_msg
  1044. ->concat($complaint_recieve_msg)
  1045. ->sortByDesc(function ($item) {
  1046. return Carbon::createFromFormat('Y-m-d H:i:s', $item->updated_at);
  1047. })->values()->all();
  1048. $res['notice_msg'] = $notice_msg;
  1049. // $res['article'] = $article;
  1050. $res['website']['count'] = Website::where([])->count();
  1051. $res['article']['count'] = Article::whereIn('status', [1])->where('admin_user_id', $user_id)->count();
  1052. $res['category']['count'] = Category::where([])->count();
  1053. $res['good']['count'] = Good::whereIn('status', [2])
  1054. ->where('user_id', $user_id)->count();
  1055. $res['book']['count'] = Book::whereIn('status', [2])
  1056. ->where('user_id', $user_id)->count();
  1057. $res['jobHunting']['count'] = JobHunting::whereIn('status', [2])
  1058. ->where('user_id', $user_id)->count();
  1059. $res['jobRecruiting']['count'] = JobRecruiting::whereIn('status', [1])
  1060. ->where('user_id', $user_id)->count();
  1061. $res['complaint']['count'] = Complaint::whereIn('status', [2])
  1062. ->where('user_id', $user_id)->count();
  1063. $res['notice']['count'] = Notice::whereIn('status', [2])
  1064. ->where('user_id', $user_id)->count();
  1065. //company project 0 待审核 1 已审核
  1066. $res['company']['count'] = Company::whereIn('status', [1])
  1067. ->where('user_id', $user_id)->count();
  1068. $res['project']['count'] = Project::whereIn('status', [1])
  1069. ->where('user_id', $user_id)->count();
  1070. //待处理的complaint
  1071. $res['complaint_deal']['count'] = Complaint::where(['status' => 2])
  1072. ->where('deal', 1)
  1073. // ->where('user_id', $user_id)
  1074. ->whereJsonContains('re_user_ids', $user_id)
  1075. ->count();
  1076. //待审核数据
  1077. $res['apply']['article'] = Article::where(['status' => 0])->where('admin_user_id', $user_id)->count(); //
  1078. $res['apply']['good'] = Good::where(['status' => 1])->where('user_id', $user_id)->count();
  1079. $res['apply']['book'] = Book::where(['status' => 1])->where('user_id', $user_id)->count();
  1080. $res['apply']['jobHunting'] = JobHunting::where(['status' => 1])->where('user_id', $user_id)->count();
  1081. $res['apply']['jobRecruiting'] = JobRecruiting::where(['status' => 0])->where('user_id', $user_id)->count();
  1082. $res['apply']['complaint'] = Complaint::where(['status' => 1])->where('user_id', $user_id)->count();
  1083. $res['apply']['notice'] = Notice::where(['status' => 1])->where('user_id', $user_id)->count();
  1084. //project company
  1085. $res['apply']['project'] = Project::whereIn('status', [0])
  1086. ->where('user_id', $user_id)->count();
  1087. $res['apply']['company'] = Company::whereIn('status', [0])
  1088. ->where('user_id', $user_id)->count();
  1089. return Result::success($res);
  1090. }
  1091. return [];
  1092. }
  1093. private function timeAgo(string $date, Carbon $now): string
  1094. {
  1095. $diff = (new Carbon($date))->diffInMinutes($now);
  1096. if ($diff < 1) {
  1097. return '刚刚';
  1098. } elseif ($diff < 60) {
  1099. return "{$diff} 分钟前";
  1100. } elseif ($diff < 1440) {
  1101. return (int)($diff / 60) . " 小时前";
  1102. } elseif ($diff < 2880) { // 两天内
  1103. return "1 天前";
  1104. } elseif ($diff < 7 * 1440) {
  1105. return (int)($diff / 1440) . " 天前";
  1106. } else {
  1107. return (new Carbon($date))->format('Y-m-d');
  1108. }
  1109. }
  1110. /**
  1111. * 获取分类下的模板
  1112. * @param array $data
  1113. * @return array
  1114. */
  1115. public function getTemplate(array $data): array
  1116. {
  1117. $page = $data['page'];
  1118. $pageSize = $data['pageSize'];
  1119. $where = [];
  1120. if (isset($data['template_class_id']) && $data['template_class_id']) {
  1121. array_push($where, ['template_class_id', '=', $data['template_class_id']]);
  1122. }
  1123. $result = Template::where($where)
  1124. ->limit($pageSize)->offset(($page - 1) * $pageSize)->get();
  1125. $count = Template::where($where)->count();
  1126. if (empty($result)) {
  1127. return Result::error("没有数据", 0);
  1128. }
  1129. $data = [
  1130. 'rows' => $result->toArray(),
  1131. 'count' => $count,
  1132. ];
  1133. return Result::success($data);
  1134. }
  1135. /**
  1136. * 创建模板
  1137. * @param
  1138. * @return void
  1139. */
  1140. public function addTemplate(array $data): array
  1141. {
  1142. $insertData = [
  1143. 'template_name' => $data['template_name'],
  1144. 'template_img' => json_encode($data['template_img']),
  1145. 'template_class_id' => $data['template_class_id'],
  1146. ];
  1147. $result = Template::insertGetId($insertData);
  1148. if (empty($result)) {
  1149. return Result::error("创建模板失败", 0);
  1150. } else {
  1151. return Result::success(["id" => $result]);
  1152. }
  1153. }
  1154. /**
  1155. * 更新模板
  1156. * @param array $data
  1157. * @return array
  1158. */
  1159. public function upTemplate(array $data): array
  1160. {
  1161. $where = [
  1162. 'id' => $data['id'],
  1163. ];
  1164. $insertData = [
  1165. 'template_name' => $data['template_name'],
  1166. 'template_img' => json_encode($data['template_img']),
  1167. 'template_class_id' => $data['template_class_id'],
  1168. ];
  1169. $result = Template::where($where)->update($insertData);
  1170. if (empty($result)) {
  1171. return Result::error("更新模板失败", 0);
  1172. } else {
  1173. return Result::success();
  1174. }
  1175. }
  1176. /**
  1177. * 删除模板
  1178. * @param array $data
  1179. * @return array
  1180. */
  1181. public function delTemplate(array $data): array
  1182. {
  1183. $where = [
  1184. 'id' => $data['id'],
  1185. ];
  1186. $result = Template::where($where)->delete();
  1187. if (empty($result)) {
  1188. return Result::error("删除模板失败", 0);
  1189. } else {
  1190. return Result::success();
  1191. }
  1192. }
  1193. /**
  1194. * 搜索网站
  1195. * @param array $data
  1196. * @return array
  1197. */
  1198. public function websiteList(array $data): array
  1199. {
  1200. $where = [];
  1201. if (isset($data['keyword']) && !empty($data['keyword'])) {
  1202. array_push($where, ['website.website_name', 'like', '%' . $data['keyword'] . '%']);
  1203. }
  1204. $result = Website::where($where)->get();
  1205. if (isset($data['website_column_id'])) {
  1206. $target = $data['website_column_id'];
  1207. $result = $result->filter(function ($item) use ($target) {
  1208. $arr = json_decode($item->website_column_arr_id, true);
  1209. return !in_array($target, $arr);
  1210. });
  1211. }
  1212. if ($result) {
  1213. return Result::success($result);
  1214. } else {
  1215. return Result::error("没有网站", 0);
  1216. }
  1217. }
  1218. public function addWebsiteCategory(array $data): array
  1219. {
  1220. $website_id = $data['website_id'];
  1221. $category_arr_id = $data['category_arr_id'];
  1222. $categoryList = Category::whereIn('id', $category_arr_id)->get();
  1223. $categoryListIds = [];
  1224. if ($categoryList) {
  1225. foreach ($categoryList->toArray() as $val) {
  1226. array_push($categoryListIds, $val['id']);
  1227. }
  1228. }
  1229. $arr = [];
  1230. if ($categoryListIds) {
  1231. foreach ($categoryListIds as $v) {
  1232. $ids = $this->getUnderlingUIds(intval($v));
  1233. $ids_arr = explode(",", $ids);
  1234. array_push($arr, $ids_arr);
  1235. }
  1236. }
  1237. $mergedArray = [];
  1238. foreach ($arr as $subarray) {
  1239. $mergedArray = array_merge($mergedArray, $subarray);
  1240. }
  1241. var_dump("所有:", $arr, $mergedArray);
  1242. //查询出所有的分类进行分割插入 组装数据
  1243. $categoryListData = Category::whereIn('id', $mergedArray)->get();
  1244. $categoryListData = $categoryListData->toArray();
  1245. $insertData = [];
  1246. if ($categoryListData) {
  1247. foreach ($categoryListData as $key => $value) {
  1248. $insertData[$key]['website_id'] = $website_id;
  1249. $insertData[$key]['name'] = $value['name'];
  1250. $insertData[$key]['sort'] = $value['sort'];
  1251. $insertData[$key]['pid'] = $value['pid'];
  1252. $insertData[$key]['pid_arr'] = $value['pid_arr'];
  1253. $insertData[$key]['seo_title'] = $value['seo_title'];
  1254. $insertData[$key]['seo_keywords'] = $value['seo_keywords'];
  1255. $insertData[$key]['seo_description'] = $value['seo_description'];
  1256. $insertData[$key]['alias'] = $value['name'];
  1257. $insertData[$key]['category_id'] = $value['id'];
  1258. }
  1259. }
  1260. $result = WebsiteCategory::insert($insertData);
  1261. var_dump("插入数据状态:", $result);
  1262. if ($result) {
  1263. return Result::success($result);
  1264. } else {
  1265. return Result::error("创建失败", 0);
  1266. }
  1267. }
  1268. /**
  1269. * 删除网站导航
  1270. * @param array $data
  1271. * @return array
  1272. */
  1273. public function delWebsiteCategory(array $data): array
  1274. {
  1275. $website_id = $data['website_id'] ?? 0;
  1276. $category_id = $data['category_id'] ?? 0;
  1277. $ids = $this->getUnderlingUIds(intval($category_id));
  1278. $ids_arr = explode(",", $ids);
  1279. $result = WebsiteCategory::where(['website_id' => $website_id])->whereIn("category_id", $ids_arr)->delete();
  1280. if ($result) {
  1281. return Result::success($result);
  1282. } else {
  1283. return Result::error("删除失败", 0);
  1284. }
  1285. }
  1286. /**
  1287. * 获取网站导航
  1288. * @param array $data
  1289. * @return array
  1290. */
  1291. public function getAdminWebsiteCategory(array $data): array
  1292. {
  1293. $where = [
  1294. 'website_id' => $data['website_id'],
  1295. ];
  1296. $result = WebsiteCategory::where($where)->orderBy('sort', 'asc')->get();
  1297. $list = [];
  1298. if ($result) {
  1299. foreach ($result->toArray() as $val) {
  1300. array_push($list, json_decode($val['category_arr_id']));
  1301. }
  1302. }
  1303. if ($result) {
  1304. return Result::success($list);
  1305. } else {
  1306. return Result::error("查询失败", 0);
  1307. }
  1308. }
  1309. /**
  1310. * 更新网站导航
  1311. * @param array $data
  1312. * @return array
  1313. */
  1314. public function upWebsiteCategory(array $data): array
  1315. {
  1316. $pinyin = new Pinyin();
  1317. Db::beginTransaction();
  1318. try {
  1319. if (!empty($data['category_arr_id'])) {
  1320. $websiteId = $data['website_id'];
  1321. // 1. 获取旧的 category_id 列表
  1322. $oldCategoryListIds = WebsiteCategory::where('website_id', $websiteId)->pluck('category_id')->toArray();
  1323. // 2. 获取新的 category_id 列表(去重)
  1324. $newCategoryListIds = [];
  1325. foreach ($data['category_arr_id'] as $arr) {
  1326. $lastId = end($arr);
  1327. $newCategoryListIds[] = $lastId;
  1328. }
  1329. $newCategoryListIds = array_unique($newCategoryListIds);
  1330. // 3. 需要删除的 category_id
  1331. $toDelete = array_diff($oldCategoryListIds, $newCategoryListIds);
  1332. if (!empty($toDelete)) {
  1333. WebsiteCategory::where('website_id', $websiteId)
  1334. ->whereIn('category_id', $toDelete)
  1335. ->delete();
  1336. }
  1337. // 4. 批量查出所有需要的 category 信息
  1338. $categories = Category::whereIn('id', $newCategoryListIds)->get()->keyBy('id');
  1339. // 5. 组装 upsertData,确保 category_id 不重复
  1340. $upsertData = [];
  1341. $handledCategoryIds = [];
  1342. foreach ($data['category_arr_id'] as $arr) {
  1343. $categoryId = end($arr);
  1344. if (!isset($categories[$categoryId]) || in_array($categoryId, $handledCategoryIds)) continue;
  1345. $info = $categories[$categoryId];
  1346. $aLIas_pinyin = $pinyin->permalink($info->name, '');
  1347. $upsertData[] = [
  1348. 'website_id' => $websiteId,
  1349. 'category_id' => $categoryId,
  1350. 'name' => $info->name ?? '',
  1351. 'alias' => $info->name ?? '',
  1352. 'aLIas_pinyin' => $aLIas_pinyin ?? '',
  1353. 'sort' => $info->sort ?? 0,
  1354. 'pid' => $info->pid ?? 0,
  1355. 'pid_arr' => $info->pid_arr ?? json_encode([]),
  1356. 'seo_title' => $info->seo_title ?? "",
  1357. 'seo_keywords' => $info->seo_keywords ?? "",
  1358. 'seo_description' => $info->seo_description ?? "",
  1359. 'is_url' => $info->is_url ?? 0,
  1360. 'web_url' => $info->web_url ?? '',
  1361. 'type' => $info->type ?? 1,
  1362. 'category_arr_id' => json_encode($arr)
  1363. ];
  1364. $handledCategoryIds[] = $categoryId;
  1365. }
  1366. // 6. upsert
  1367. if (!empty($upsertData)) {
  1368. WebsiteCategory::upsert(
  1369. $upsertData,
  1370. ['website_id', 'category_id'],
  1371. [
  1372. 'aLIas_pinyin',
  1373. 'pid',
  1374. 'pid_arr',
  1375. 'is_url',
  1376. 'web_url',
  1377. 'category_arr_id'
  1378. ]
  1379. );
  1380. }
  1381. }
  1382. //处理所有path
  1383. var_dump($data, '--------111----');
  1384. $website_id = $data['website_id'];
  1385. //获取所有数据
  1386. $result = WebsiteCategory::where(['website_id' => $website_id, 'path' => NULL])->get()->toArray();
  1387. if (empty($result)) {
  1388. return Result::error("没有数据", 0);
  1389. }
  1390. //处理path
  1391. foreach ($result as $key => $value) {
  1392. $array_category_arr_id = json_decode($value['category_arr_id'], true);
  1393. $result[$key]['path'] = WebsiteCategory::where('website_id', $website_id)
  1394. ->orderByRaw('FIELD(category_id, ' . implode(',', $array_category_arr_id) . ')')
  1395. ->whereIn('category_id', $array_category_arr_id)
  1396. ->pluck('aLIas_pinyin')
  1397. ->implode('/');
  1398. }
  1399. //批量更新数据path
  1400. $updateData = [];
  1401. foreach ($result as $item) {
  1402. $updateData[] = [
  1403. 'id' => $item['id'],
  1404. 'path' => $item['path']
  1405. ];
  1406. }
  1407. //批量更新
  1408. DB::beginTransaction();
  1409. try {
  1410. foreach ($result as $item) {
  1411. WebsiteCategory::where('id', $item['id'])->update(['path' => $item['path']]);
  1412. }
  1413. DB::commit();
  1414. } catch (\Exception $e) {
  1415. DB::rollBack();
  1416. throw $e; // 或者返回错误信息
  1417. }
  1418. Db::commit();
  1419. return Result::success();
  1420. } catch (\Throwable $ex) {
  1421. Db::rollBack();
  1422. return Result::error("修改失败" . $ex->getMessage(), 0);
  1423. }
  1424. }
  1425. /**
  1426. * 获取网站列表
  1427. * @param array $data
  1428. * @return array
  1429. */
  1430. public function getWebsiteCategoryList(array $data): array
  1431. {
  1432. $where = [];
  1433. if (isset($data['keyword']) && !empty($data['keyword'])) {
  1434. array_push($where, ['website.website_name', 'like', '%' . $data['keyword'] . '%']);
  1435. }
  1436. if (isset($data['website_column_id']) && !empty($data['website_column_id'])) {
  1437. array_push($where, ['website.website_column_id', '=', $data['website_column_id']]);
  1438. }
  1439. $result = Website::where($where)
  1440. ->with(["websiteCategory" => function ($query) {
  1441. $query->where(['pid' => 0])->select('website_id', 'name', 'alias', 'category_id');
  1442. }])
  1443. ->limit($data['pageSize'])->orderBy("updated_at", "desc")->offset(($data['page'] - 1) * $data['pageSize'])
  1444. ->get();
  1445. $count = Website::where($where)->count();
  1446. if (empty($result)) {
  1447. return Result::error("没有数据", 0);
  1448. }
  1449. $data = [
  1450. 'rows' => $result->toArray(),
  1451. 'count' => $count,
  1452. ];
  1453. if ($result) {
  1454. return Result::success($data);
  1455. } else {
  1456. return Result::error("查询失败", 0);
  1457. }
  1458. }
  1459. /**
  1460. * 删除网站下的所有导航
  1461. * @param array $data
  1462. * @return array
  1463. */
  1464. public function delWebsiteAllCategory(array $data): array
  1465. {
  1466. $website_id = $data['website_id'];
  1467. $result = WebsiteCategory::where(['website_id' => $website_id])->delete();
  1468. if ($result) {
  1469. return Result::success($result);
  1470. } else {
  1471. return Result::error("删除失败", 0);
  1472. }
  1473. }
  1474. /**
  1475. * 获取网站下的某一个导航
  1476. * @param array $data
  1477. * @return array
  1478. */
  1479. public function getWebsiteCategoryOnes(array $data): array
  1480. {
  1481. $website_id = $data['website_id'];
  1482. $category_id = $data['category_id'];
  1483. $result = WebsiteCategory::where(['website_category.website_id' => $website_id, 'website_category.category_id' => $category_id])
  1484. ->first();
  1485. if ($result) {
  1486. return Result::success($result);
  1487. } else {
  1488. return Result::error("查询失败", 0);
  1489. }
  1490. }
  1491. /**
  1492. * 更新网闸下的某一个导航
  1493. * @param array $data
  1494. * @return array
  1495. */
  1496. public function upWebsiteCategoryones(array $data): array
  1497. {
  1498. //处理所有数据
  1499. //获取所有数据
  1500. if (isset($data['all']) && $data['all'] == 'all') {
  1501. $result = WebsiteCategory::get();
  1502. $result = $result->toArray();
  1503. var_dump($result, '------------');
  1504. $pinyin = new Pinyin();
  1505. $letters = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
  1506. for ($i = 0; $i < count($result); $i++) {
  1507. // $randss = substr(str_shuffle($letters), 0, 4);
  1508. $result[$i]['aLIas_pinyin'] = $pinyin->permalink($result[$i]['alias'], '');
  1509. WebsiteCategory::where(['id' => $result[$i]['id']])->update(['aLIas_pinyin' => $result[$i]['aLIas_pinyin']]);
  1510. }
  1511. var_dump($result, '--------222----');
  1512. if ($result) {
  1513. return Result::success($result);
  1514. } else {
  1515. return Result::error("更新失败", 0);
  1516. }
  1517. }
  1518. //处理所有path
  1519. if (isset($data['pathone']) && $data['pathone'] == 'pathone') {
  1520. var_dump($data, '--------111----');
  1521. $website_id = $data['website_id'];
  1522. //获取所有数据
  1523. $result = WebsiteCategory::where(['website_id' => $website_id, 'path' => NULL])->get()->toArray();
  1524. if (empty($result)) {
  1525. return Result::error("没有数据", 0);
  1526. }
  1527. //处理path
  1528. foreach ($result as $key => $value) {
  1529. $array_category_arr_id = json_decode($value['category_arr_id'], true);
  1530. $result[$key]['path'] = WebsiteCategory::where('website_id', $website_id)
  1531. ->orderByRaw('FIELD(category_id, ' . implode(',', $array_category_arr_id) . ')')
  1532. ->whereIn('category_id', $array_category_arr_id)
  1533. ->pluck('aLIas_pinyin')
  1534. ->implode('/');
  1535. }
  1536. //批量更新数据path
  1537. $updateData = [];
  1538. foreach ($result as $item) {
  1539. $updateData[] = [
  1540. 'id' => $item['id'],
  1541. 'path' => $item['path']
  1542. ];
  1543. }
  1544. //批量更新
  1545. DB::beginTransaction();
  1546. try {
  1547. foreach ($result as $item) {
  1548. WebsiteCategory::where('id', $item['id'])->update(['path' => $item['path']]);
  1549. }
  1550. DB::commit();
  1551. } catch (\Exception $e) {
  1552. DB::rollBack();
  1553. throw $e; // 或者返回错误信息
  1554. }
  1555. return Result::success($result);
  1556. }
  1557. if (isset($data['pathall']) && $data['pathall'] == 'pathall') {
  1558. //获取所有数据
  1559. $result = WebsiteCategory::where(['path' => NULL])->get()->toArray();
  1560. if (empty($result)) {
  1561. return Result::error("没有数据", 0);
  1562. }
  1563. //处理path
  1564. foreach ($result as $key => $value) {
  1565. if (empty($value['category_arr_id'])) continue;
  1566. if ($key >= 4) { // 改为 >= 4 如果你想处理最多4个元素
  1567. // break;
  1568. }
  1569. $array_category_arr_id = json_decode($value['category_arr_id'], true);
  1570. $result[$key]['path'] = WebsiteCategory::where('website_id', $value['website_id'])
  1571. ->orderByRaw('FIELD(category_id, ' . implode(',', $array_category_arr_id) . ')')
  1572. ->whereIn('category_id', $array_category_arr_id)
  1573. ->pluck('aLIas_pinyin')
  1574. ->implode('/');
  1575. }
  1576. //批量更新数据path
  1577. $updateData = [];
  1578. foreach ($result as $item) {
  1579. $updateData[] = [
  1580. 'id' => $item['id'],
  1581. 'category_arr_id' => $item['category_arr_id'],
  1582. 'path' => $item['path']
  1583. ];
  1584. }
  1585. // var_dump($updateData);
  1586. // return Result::success($updateData);
  1587. //批量更新
  1588. DB::beginTransaction();
  1589. try {
  1590. foreach ($result as $item) {
  1591. WebsiteCategory::where('id', $item['id'])->update(['path' => $item['path']]);
  1592. }
  1593. DB::commit();
  1594. } catch (\Exception $e) {
  1595. DB::rollBack();
  1596. throw $e; // 或者返回错误信息
  1597. }
  1598. return Result::success($result);
  1599. }
  1600. $where = [
  1601. 'website_id' => $data['website_id'],
  1602. 'category_id' => $data['category_id'],
  1603. ];
  1604. $alias = $data['alias'];
  1605. $pinyin = new Pinyin();
  1606. $aLIas_pinyin = $pinyin->permalink($alias, '');
  1607. //从WebsiteCategory取出alis ,并转成拼音存放到aLIas_pinyin
  1608. $result = WebsiteCategory::where($where)->first();
  1609. if (empty($result)) {
  1610. return Result::error("没有数据", 0);
  1611. }
  1612. $result = $result->toArray();
  1613. //+四位随机字母
  1614. $letters = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
  1615. // 打乱字符串顺序并截取前四位
  1616. // $randss = substr(str_shuffle($letters), 0, 4);
  1617. $data['aLIas_pinyin'] = $aLIas_pinyin;
  1618. //处理path
  1619. $category_arr_id = json_decode($result['category_arr_id'], true);
  1620. //取出来设置path
  1621. $path = WebsiteCategory::where('website_id', $data['website_id'])
  1622. ->orderByRaw('FIELD(category_id, ' . implode(',', $category_arr_id) . ')')
  1623. ->whereIn('category_id', $category_arr_id)
  1624. ->pluck('aLIas_pinyin')
  1625. ->implode('/');
  1626. $data['path'] = $path;
  1627. //处理包含此id的所有path
  1628. // 取出category_arr_id包含此id的所有数据
  1629. $all_other = WebsiteCategory::where('website_id', $data['website_id'])
  1630. ->whereJsonContains('category_arr_id', $data['category_id'])
  1631. ->get();
  1632. var_dump($all_other, '------------');
  1633. // 遍历所有数据,更新path
  1634. $newAliasPinyin = $aLIas_pinyin ?? ''; // 添加空值判断
  1635. $oldAliasPinyin = $result['alias_pinyin'] ?? ''; // 修正键名大小写
  1636. // 收集需要更新的ID和路径
  1637. $updateData = [];
  1638. foreach ($all_other as $item) {
  1639. $newPath = str_replace($oldAliasPinyin, $newAliasPinyin, $item->path);
  1640. if ($newPath !== $item->path) { // 仅在路径变化时更新
  1641. $updateData[] = [
  1642. 'id' => $item->id,
  1643. 'path' => $newPath
  1644. ];
  1645. }
  1646. }
  1647. // 批量更新提高性能
  1648. if (!empty($updateData)) {
  1649. // 假设模型对应的数据表为 'table_name',请替换为实际表名
  1650. Db::table('website_category')->updateOrInsert(
  1651. ['id' => DB::raw('VALUES(id)')],
  1652. $updateData
  1653. );
  1654. }
  1655. $result = WebsiteCategory::where($where)->update($data);
  1656. if ($result) {
  1657. return Result::success($result);
  1658. } else {
  1659. return Result::error("更新失败", 0);
  1660. }
  1661. }
  1662. /**
  1663. * 获取网站下的所有导航(包含子导航)
  1664. * @param array $data
  1665. * @return array
  1666. */
  1667. public function getWebsiteAllCategory(array $data): array
  1668. {
  1669. $where = [];
  1670. if (isset($data['website_id']) && !empty($data['website_id'])) {
  1671. array_push($where, ['website_category.website_id', '=', $data['website_id']]);
  1672. }
  1673. // if (isset($data['name']) && !empty($data['name'])) {
  1674. // array_push($where, ['website_category.name', 'like', '%' . $data['name'] . '%']);
  1675. // }
  1676. // if (isset($data['alias']) && !empty($data['alias'])) {
  1677. // array_push($where, ['website_category.alias', 'like', '%' . $data['alias'] . '%']);
  1678. // }
  1679. // if (isset($data['department_id']) && !empty($data['department_id'])) {
  1680. // array_push($where, ['category.department_id', '=', $data['department_id']]);
  1681. // }
  1682. // if (isset($data['city_id']) && !empty($data['city_id'])) {
  1683. // array_push($where, ['category.city_id', '=', $data['city_id']]);
  1684. // }
  1685. $result = WebsiteCategory::where($where)
  1686. ->leftJoin("category", 'website_category.category_id', 'category.id')
  1687. ->select("website_category.*", "category.name as name")
  1688. // ->leftJoin("category", 'website_category.category_id', 'category.id')
  1689. // ->leftJoin("department", 'category.department_id', 'department.id')
  1690. // ->leftJoin("district", 'category.city_id', 'district.id')
  1691. // ->select("website_category.*", "department.name as department_name", "district.name as city_name")
  1692. // ->limit($data['pageSize'])->offset(($data['page'] - 1) * $data['pageSize'])
  1693. ->orderBy("sort", "asc")
  1694. ->orderBy("updated_at", "desc")
  1695. ->get();
  1696. // $count = WebsiteCategory::where($where)
  1697. // ->leftJoin("category", 'website_category.category_id', 'category.id')
  1698. // ->leftJoin("department", 'category.department_id', 'department.id')
  1699. // ->leftJoin("district", 'category.city_id', 'district.id')
  1700. // ->count();
  1701. if (empty($result)) {
  1702. return Result::error("没有数据", 0);
  1703. }
  1704. // $data = [
  1705. // 'rows' => $result->toArray(),
  1706. // 'count' => $count,
  1707. // ];
  1708. if ($result) {
  1709. return Result::success($result->toArray());
  1710. } else {
  1711. return Result::error("查询失败", 0);
  1712. }
  1713. }
  1714. /**
  1715. * 递归查询数据
  1716. * @param $id
  1717. * @param $ids
  1718. * @return string
  1719. */
  1720. public function getUnderlingUIds($id, $ids = '')
  1721. {
  1722. $back = Category::where(['pid' => $id])->get();
  1723. $back = $back->toArray();
  1724. if (!empty($back) && is_array($back)) {
  1725. foreach ($back as $v) {
  1726. //防止当前人的ID重复去查询,形成恶性循环
  1727. if ($v['id'] == $id) {
  1728. continue;
  1729. }
  1730. $back2 = Category::where(['pid' => $id])->count('id');
  1731. if ($back2 > 0) {
  1732. $ids = $this->getUnderlingUIds($v['id'], $ids);
  1733. } else {
  1734. $ids .= ',' . $v['id'];
  1735. }
  1736. }
  1737. }
  1738. $ids = $id . ',' . $ids . ',';
  1739. $ids = str_replace(',,', ",", $ids);
  1740. $ids = trim($ids, ',');
  1741. return $ids;
  1742. }
  1743. /**
  1744. * 检测网站名称是否重复
  1745. * @param array $data
  1746. * @return array
  1747. */
  1748. public function checkWebsiteName(array $data): array
  1749. {
  1750. if (isset($data['id'])) {
  1751. $data[] = ['id', "!=", $data['id']];
  1752. unset($data['id']);
  1753. }
  1754. $websiteInfo = Website::query()->where($data)->first();
  1755. if (empty($websiteInfo)) {
  1756. return Result::error("找不到网站", 0);
  1757. }
  1758. return Result::success($websiteInfo->toArray());
  1759. }
  1760. /**
  1761. * 检测网站url是否重复
  1762. * @param array $data
  1763. * @return array
  1764. */
  1765. public function checkWebsiteUrl(array $data): array
  1766. {
  1767. $whereData = [];
  1768. if (isset($data['id'])) {
  1769. $whereData = [['id', "!=", $data['id']]];
  1770. unset($data['id']);
  1771. }
  1772. $websiteInfo = Website::query()->where($whereData)->whereJsonContains('website_url', $data['website_url'])->first();
  1773. if (empty($websiteInfo)) {
  1774. return Result::error("找不到URL", 0);
  1775. }
  1776. return Result::success($websiteInfo->toArray());
  1777. }
  1778. /**
  1779. * 获取网站底部基础信息
  1780. * @param array $data
  1781. * @return array
  1782. */
  1783. public function getWebsiteFootInfo(array $data): array
  1784. {
  1785. if (isset($data['website_id']) && !empty($data['website_id'])) {
  1786. $website_head = Website::where('id', $data['website_id'])
  1787. ->where('status', 1)
  1788. ->select('id', 'website_name', 'logo', 'title', 'keywords', 'description', 'suffix', 'website_url')
  1789. ->first();
  1790. if (empty($website_head)) {
  1791. return Result::error("找不到网站", 0);
  1792. }
  1793. } else {
  1794. return Result::error("参数错误", 0);
  1795. }
  1796. $website_head = Website::where('id', $data['website_id'])
  1797. ->select('id', 'website_name', 'logo', 'title', 'keywords', 'description', 'suffix', 'website_url')->first();
  1798. $website_foot = WebsiteTemplateInfo::where('website_id', $data['website_id'])->first();
  1799. if (empty($website_foot)) {
  1800. return Result::error("暂无底部基础信息", 0);
  1801. }
  1802. $website_head['website_url'] = $website_head['website_url'] ? json_decode($website_head['website_url']) : [];
  1803. $result = [
  1804. 'website_foot' => $website_foot,
  1805. 'website_head' => $website_head,
  1806. ];
  1807. return Result::success($result);
  1808. }
  1809. /**
  1810. * 获取网站底部导航
  1811. * @param array $data
  1812. * @return array
  1813. */
  1814. public function getWebsiteFooterCategory(array $data): array
  1815. {
  1816. if (isset($data['website_id']) && !empty($data['website_id'])) {
  1817. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  1818. if (empty($website)) {
  1819. return Result::error("找不到网站", 0);
  1820. }
  1821. } else {
  1822. return Result::error("参数错误", 0);
  1823. }
  1824. $result = FooterCategory::where('website_id', $data['website_id'])->get();
  1825. if (empty($result)) {
  1826. return Result::error("暂无底部导航", 0);
  1827. }
  1828. return Result::success($result->toArray());
  1829. }
  1830. /**
  1831. * 获取网站底部导航列表
  1832. * @param array $data
  1833. * @return array
  1834. */
  1835. public function getWebsiteFooterCategoryList(array $data): array
  1836. {
  1837. if (isset($data['website_id']) && !empty($data['website_id'])) {
  1838. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  1839. if (empty($website)) {
  1840. return Result::error("找不到网站", 0);
  1841. }
  1842. } else {
  1843. return Result::error("参数错误", 0);
  1844. }
  1845. $footercategory = FooterCategory::where('website_id', $data['website_id'])->where('id', $data['fcat_id'])->first();
  1846. // '底部导航类型 0:内容型;1:列表型;',
  1847. if (!isset($footercategory['type']) || $footercategory['type'] == 0) {
  1848. return Result::error("底部导航id错误", 0);
  1849. } else {
  1850. $query = FooterContent::where('fcat_id', $data['fcat_id']);
  1851. if ($query->count() == 0) {
  1852. return Result::error("暂无底部导航列表", 0);
  1853. } elseif ($query->count() == 1) {
  1854. $result = $query->first();
  1855. } else {
  1856. $result = $query->get();
  1857. }
  1858. }
  1859. return Result::success($result);
  1860. }
  1861. /**
  1862. * 获取网站底部导航
  1863. * @param array $data
  1864. * @return array
  1865. */
  1866. public function getWebsiteFooterCategoryInfo(array $data): array
  1867. {
  1868. if (isset($data['website_id']) && !empty($data['website_id'])) {
  1869. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  1870. if (empty($website)) {
  1871. return Result::error("找不到网站", 0);
  1872. }
  1873. } else {
  1874. return Result::error("参数错误", 0);
  1875. }
  1876. if (isset($data['type']) && $data['type'] == 0) {
  1877. $fcatid = FooterCategory::where('website_id', $data['website_id'])->where('id', $data['fcat_id'])->first();
  1878. if (empty($fcatid)) {
  1879. return Result::error("底部导航id错误", 0);
  1880. }
  1881. $result = FooterContent::where('fcat_id', $data['fcat_id'])->first();
  1882. } else {
  1883. $result = FooterContent::where('id', $data['fcat_id'])->first();
  1884. }
  1885. if (empty($result)) {
  1886. return Result::error("暂无底部导航内容", 0);
  1887. }
  1888. return Result::success($result);
  1889. }
  1890. /*
  1891. * 搜索网站二级导航
  1892. * @param array $data
  1893. * @return array
  1894. * */
  1895. public function selectWebsiteCategory(array $data): array
  1896. {
  1897. if (isset($data['website_id']) && !empty($data['website_id'])) {
  1898. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  1899. if (empty($website)) {
  1900. return Result::error("暂无该网站", 0);
  1901. }
  1902. $category = WebsiteCategory::where('website_id', $data['website_id'])->pluck('category_id')->all();
  1903. // return Result::success($category);
  1904. if (empty($category)) {
  1905. return Result::error("暂无此导航", 0);
  1906. }
  1907. $query = Category::whereIn('id', $category);
  1908. if (isset($data['cityid']) && !empty($data['cityid'])) {
  1909. $cityid = District::where('id', $data['cityid'])->first();
  1910. if (empty($cityid)) {
  1911. return Result::error("暂无此城市", 0);
  1912. } else {
  1913. $city_category = $query->whereRaw('JSON_CONTAINS(city_arr_id,?)', [$data['cityid']])->pluck('id');
  1914. // $where[] = ['JSON_CONTAINS(city_arr_id, ?)', $data['cityid']];
  1915. if (empty($city_category)) {
  1916. return Result::error("暂无此城市下的导航", 0);
  1917. }
  1918. $result['catid'] = $city_category;
  1919. $city = 1;
  1920. // var_dump("城市====================",$result);
  1921. }
  1922. }
  1923. if (isset($data['department_id']) && !empty($data['department_id'])) {
  1924. $departmentid = Department::where('id', $data['department_id'])->first();
  1925. if (empty($departmentid)) {
  1926. return Result::error("暂无此部门", 0);
  1927. } else {
  1928. $depart_category = $query->whereRaw('JSON_CONTAINS(department_arr_id,?)', [$data['department_id']])->pluck('id');
  1929. if (empty($depart_category)) {
  1930. return Result::error("暂无此部门下的导航", 0);
  1931. }
  1932. $result['catid'] = $depart_category;
  1933. // var_dump("职能部门*******************",$result);
  1934. $department = 1;
  1935. }
  1936. }
  1937. if (!empty($city) && !empty($department)) {
  1938. // var_dump("城市和职能部门----------------------",$result);
  1939. $sel_category = $query->whereRaw('JSON_CONTAINS(city_arr_id,?)', [$data['cityid']])->whereRaw('JSON_CONTAINS(department_arr_id,?)', [$data['department_id']])->pluck('id');
  1940. if (empty($sel_category)) {
  1941. return Result::error("暂无此城市和职能部门下的导航", 0);
  1942. }
  1943. $result['catid'] = $sel_category;
  1944. }
  1945. if (empty($result)) {
  1946. return Result::error("暂无导航", 0);
  1947. }
  1948. // department_id
  1949. } else {
  1950. return Result::error("参数错误", 0);
  1951. }
  1952. return Result::success($result);
  1953. }
  1954. /**
  1955. * 获取网站栏目seo
  1956. * @param array $data
  1957. * @return array
  1958. */
  1959. public function getWebsiteCategoryHead(array $data): array
  1960. {
  1961. if (isset($data['website_id']) && !empty($data['website_id'])) {
  1962. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  1963. if (empty($website)) {
  1964. return Result::error("找不到网站", 0);
  1965. }
  1966. } else {
  1967. return Result::error("参数错误", 0);
  1968. }
  1969. if (isset($data['catid']) && !empty($data['catid'])) {
  1970. $result = WebsiteCategory::where('website_id', $data['website_id'])->where('category_id', $data['catid'])->first();
  1971. }
  1972. if (empty($result)) {
  1973. return Result::error("暂无导航", 0);
  1974. }
  1975. $result['website_name'] = $website['website_name'] ?? '';
  1976. $result['suffix'] = $website['suffix'] ?? '';
  1977. return Result::success($result);
  1978. }
  1979. /*
  1980. * 获取某个栏目
  1981. * @param array $data
  1982. * @return array
  1983. * */
  1984. public function getOneWebsiteCategory(array $data): array
  1985. {
  1986. if (isset($data['website_id']) && !empty($data['website_id'])) {
  1987. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  1988. if (empty($website)) {
  1989. return Result::error("暂无该网站", 0);
  1990. }
  1991. $category = WebsiteCategory::where('website_id', $data['website_id'])->where('category_id', $data['category_id'])->first();
  1992. if (empty($category)) {
  1993. return Result::error("暂无此导航", 0);
  1994. }
  1995. $category['children_count'] = WebsiteCategory::where('website_id', $data['website_id'])->where('pid', $data['category_id'])->count();
  1996. $parent = WebsiteCategory::where('website_id', $data['website_id'])->where('category_id', $category['pid'])->select('category_id as parent_id', 'alias as parent_name', 'aLIas_pinyin')->first();
  1997. $category['parent_id'] = $parent['parent_id'] ?? '';
  1998. $category['parent_pinyin'] = $parent['aLIas_pinyin'] ?? '';
  1999. $category['parent_name'] = $parent['parent_name'] ?? '';
  2000. return Result::success($category);
  2001. } else {
  2002. return Result::error("参数错误", 0);
  2003. }
  2004. }
  2005. // 自助建站--fr-------------------
  2006. /**
  2007. * 获取并搜索 网站模板信息
  2008. * @param array $data
  2009. * @return array
  2010. */
  2011. public function getWebsiteintel(array $data): array
  2012. {
  2013. //查询所有网站模板信息
  2014. $query = Website::where('website.status', 1)
  2015. ->leftJoin("website_template_info", "website_template_info.website_id", "website.id")
  2016. ->leftJoin("template", "template.template_id", "website_template_info.template_id")
  2017. ->leftJoin("template_class", "template_class.class_id", "template.template_class_id")
  2018. ->leftJoin('website_column', 'website_column.id', 'website.website_column_id')
  2019. ->leftJoin('website_column as parent_column', function ($join) {
  2020. $join->on('website_column.pid', '=', 'parent_column.id')
  2021. ->where('website_column.pid', 2);
  2022. })
  2023. ->whereRaw('JSON_CONTAINS(website_column_arr_id,?)', [2])
  2024. ->select(
  2025. "website_template_info.id",
  2026. "template_class.name",
  2027. "website.id as website_id",
  2028. "website.website_name",
  2029. "website.website_url",
  2030. "website_template_info.action_id",
  2031. "website_template_info.created_at",
  2032. "website_template_info.updated_at",
  2033. "website_template_info.page_type",
  2034. 'website_column.column_name',
  2035. 'parent_column.column_name as parent_column_name',
  2036. DB::raw("COALESCE(website_template_info.status, 0) as template_status"),
  2037. "template.template_name"
  2038. );
  2039. //若存在条件;则在$query的基础上进行筛选
  2040. if (isset($data['website_name']) && !empty($data['website_name'])) {
  2041. $query->where('website.website_name', 'like', '%' . $data['website_name'] . '%');
  2042. }
  2043. if (isset($data['status']) && !empty($data['status'])) {
  2044. $query->where('website_template_info.status', $data['status']);
  2045. }
  2046. $count = $query->count();
  2047. $query->limit($data['pageSize'])
  2048. ->offset(($data['page'] - 1) * $data['pageSize'])
  2049. ->orderBy("website_template_info.updated_at", "desc");
  2050. $rep = $query->get();
  2051. if ($rep->count() == 0) {
  2052. return Result::error("没有查找到相关数据", 0);
  2053. } else {
  2054. $rep->each(function ($item) {
  2055. if (!empty($item->page_type)) {
  2056. $pageTypeArray = json_decode($item->page_type, true);
  2057. if (is_array($pageTypeArray)) {
  2058. $item->page_type = $pageTypeArray;
  2059. }
  2060. }
  2061. });
  2062. $result = [
  2063. "rows" => $rep->toArray(),
  2064. "count" => $count,
  2065. ];
  2066. return Result::success($result);
  2067. }
  2068. // return Result::success($result);
  2069. }
  2070. /**
  2071. * 自助建站-验证搭建网站
  2072. * @param array $data
  2073. * @return array
  2074. */
  2075. public function checkWebsiteBuild(array $data): array
  2076. {
  2077. $website = Website::where('website.id', $data['website_id'])->first();
  2078. if (empty($website)) {
  2079. return Result::error("请输入正确的网站id!", 0);
  2080. }
  2081. if (empty($website['website_column_id'])) {
  2082. return Result::error("请先关联导航池!", 0);
  2083. }
  2084. // 获取此网站的底部导航 类型 type: 0:内容型底部导航(只有一条详情内容);1:列表型底部导航(可以有多条详情内容)
  2085. $foot_type = FooterCategory::where('website_id', $data['website_id'])->pluck('type')->toArray();
  2086. if (empty($foot_type)) {
  2087. return Result::error("请先关联单页!", 0);
  2088. }
  2089. // if (!in_array(1, $foot_type) ) {
  2090. // $missingTypes[] = "列表型底部导航";
  2091. // }
  2092. if (!in_array(0, $foot_type) ) {
  2093. $missingTypes[] = "单页(详情)";
  2094. }
  2095. if (!empty($missingTypes)) {
  2096. $errorMessage = "请先添加" . $missingTypes . "!";
  2097. return Result::error($errorMessage, 0);
  2098. }
  2099. $result['foot_type'] = $foot_type;
  2100. // 友情链接类型'1:图片 2:文字 3:底部';
  2101. $types = Link::where('website_id', $data['website_id'])->pluck('type')->toArray();
  2102. $missingTypes = [];
  2103. if (!in_array(1, $types)) {
  2104. $missingTypes[] = "文字链接";
  2105. }
  2106. if (!in_array(2, $types)) {
  2107. $missingTypes[] = "图片链接";
  2108. }
  2109. if (!in_array(3, $types)) {
  2110. $missingTypes[] = "底部链接";
  2111. }
  2112. if (!empty($missingTypes)) {
  2113. $errorMessage = "请先添加 " . implode(" 和 ", $missingTypes) . "!";
  2114. return Result::error($errorMessage, 0);
  2115. }
  2116. return Result::success($result);
  2117. }
  2118. /**
  2119. * 自助建站-验证编辑网站
  2120. * @return array
  2121. *
  2122. */
  2123. public function checkWebsiteEdit(array $data): array
  2124. {
  2125. $result = WebsiteTemplateInfo::where('website_template_info.website_id', $data['website_id'])->first();
  2126. if (empty($result)) {
  2127. return Result::error("请输入正确的网站id!", 0);
  2128. }
  2129. // 订单状态:1:通过;2:驳回;3:撤回;4:修改;5:过期;6:待审核;7:结束
  2130. $order = Order::where('website_id', $data['website_id'])->where('status', 1)->first();
  2131. if (!empty($order)) {
  2132. return Result::error("此网站的广告位正在使用中,暂不可编辑!", 0);
  2133. }
  2134. $check = $this->checkWebsiteBuild($data);
  2135. if($check['code'] != 200){
  2136. return Result::error($check['message'], 0);
  2137. }
  2138. // return Result::success($check);
  2139. if ($result['page_type']) {
  2140. $result['page_type'] = json_decode($result['page_type'], true);
  2141. return Result::success('网站编辑验证通过!');
  2142. } else {
  2143. return Result::error("请先选择网站页面类型!", 0);
  2144. }
  2145. }
  2146. /**
  2147. * 修改网站基础信息
  2148. *
  2149. * @return array
  2150. */
  2151. public function upWebsiteTemplateintel(array $data): array
  2152. {
  2153. $web = Website::where('website.id', $data['website_id'])->first();
  2154. if (empty($web)) {
  2155. return Result::error("请输入正确的网站id!", 0);
  2156. }
  2157. $where = ['website_id' => $data['website_id']];
  2158. $result = WebsiteTemplateInfo::where($where)->first();
  2159. if (empty($result)) {
  2160. return Result::error("请先添加网站基础信息!", 0);
  2161. } else {
  2162. unset($data['website_id']);
  2163. // 删除重复元素
  2164. $data['page_type'] = array_unique($data['page_type']);
  2165. // 重新索引数组
  2166. $data['page_type'] = array_values($data['page_type']);
  2167. // 数组中同时包含值为 1(首页) 和值为 7 (底部导航详情页)的元素
  2168. if (in_array(1, $data['page_type']) && in_array(7, $data['page_type'])) {
  2169. // 将数组转换为 JSON 字符串
  2170. $data['page_type'] = json_encode($data['page_type']) ?? '';
  2171. try {
  2172. $result = WebsiteTemplateInfo::where($where)->update($data);
  2173. } catch (\Exception $e) {
  2174. if ($e->getCode() == 22001) {
  2175. $errorMessage = $e->getMessage();
  2176. return Result::error("请检查表单,某个字段超出了长度限制!");
  2177. } else {
  2178. // 处理其他类型的数据库错误
  2179. return Result::error("修改操作失败: " . $e->getMessage());
  2180. }
  2181. return Result::error("修改失败!", 0);
  2182. }
  2183. } else {
  2184. return Result::error("请先选择首页和单页(详情)!", 0);
  2185. }
  2186. }
  2187. if (empty($result)) {
  2188. return Result::error("修改失败!", 0);
  2189. } else {
  2190. return Result::success($result);
  2191. }
  2192. }
  2193. /**
  2194. * 获取所有网站风格信息
  2195. *
  2196. * @return array
  2197. */
  2198. public function getAllTemplateClass(array $data): array
  2199. {
  2200. $result = TemplateClass::all();
  2201. if (empty($result)) {
  2202. return Result::error("没有查找到相关数据!", 0);
  2203. } else {
  2204. return Result::success($result);
  2205. }
  2206. }
  2207. /**
  2208. * 搜索并获取网站模板信息
  2209. * @param array $data
  2210. * @return array
  2211. */
  2212. public function getWebsiteTemplateList(array $data): array
  2213. {
  2214. $website = Website::where('website.id', $data['website_id'])->first();
  2215. if (empty($website)) {
  2216. return Result::error("请输入正确的网站id!", 0);
  2217. } else {
  2218. $page_type = WebsiteTemplateInfo::where('website_id', $data['website_id'])->select('page_type')->first();
  2219. if (empty($page_type)) {
  2220. return Result::error("此网站还未添加基础信息!", 0);
  2221. } else {
  2222. $where = json_decode($page_type['page_type'], true);
  2223. // $where = $data["page_type"];
  2224. if (isset($data['template_class_id']) && !empty($data['template_class_id'])) {
  2225. $template_class = TemplateClass::where('id', $data['template_class_id'])->first();
  2226. if (empty($template_class)) {
  2227. return Result::error("请输入正确的模板风格id!", 0);
  2228. } else {
  2229. // 获取指定风格下的模板
  2230. $rep = Template::where('template_class_id', $data['template_class_id'])
  2231. ->where(function ($query) use ($where) {
  2232. foreach ($where as $value) {
  2233. $query->whereJsonContains('template_img', ['value' => $value]);
  2234. }
  2235. })
  2236. ->limit($data['pageSize'])
  2237. ->offset(($data['page'] - 1) * $data['pageSize'])
  2238. ->orderBy("template.updated_at", "desc")
  2239. ->get();
  2240. $count = Template::where('template_class_id', $data['template_class_id'])
  2241. ->where(function ($query) use ($where) {
  2242. foreach ($where as $value) {
  2243. $query->whereJsonContains('template_img', ['value' => $value]);
  2244. }
  2245. })->count();
  2246. }
  2247. } else {
  2248. //获取所有模板
  2249. $rep = Template::where(function ($query) use ($where) {
  2250. foreach ($where as $value) {
  2251. $query->whereJsonContains('template_img', ['value' => $value]);
  2252. }
  2253. })
  2254. ->limit($data['pageSize'])
  2255. ->offset(($data['page'] - 1) * $data['pageSize'])
  2256. ->orderBy("template.updated_at", "desc")
  2257. ->get();
  2258. $count = Template::where(function ($query) use ($where) {
  2259. foreach ($where as $value) {
  2260. $query->whereJsonContains('template_img', ['value' => $value]);
  2261. }
  2262. })->count();
  2263. }
  2264. if (empty($rep) || $rep->count() == 0) {
  2265. return Result::error("没有查找到相关数据!", 0);
  2266. } else {
  2267. // 过滤 template_img 字段 只获取 基础信息中 包含的模板图片
  2268. // $rep->each(function ($item) use ($where) {
  2269. // $template_img = json_decode($item->template_img, true);
  2270. // if(is_array($template_img)){
  2271. // $filtered_img = array_filter($template_img, function ($img) use ($where) {
  2272. // return isset($img['value']) && in_array($img['value'], $where);
  2273. // });
  2274. // }
  2275. // $item->template_img = $filtered_img;
  2276. // });
  2277. // $result = [
  2278. // "rows" => $rep->toArray(),
  2279. // "count" => $count
  2280. // ];
  2281. $rep->each(function ($item) use ($where) {
  2282. $template_img = json_decode($item->template_img, true);
  2283. if (is_array($template_img)) {
  2284. $filtered_img = array_filter($template_img, function ($img) use ($where) {
  2285. return isset($img['value']) && in_array($img['value'], $where);
  2286. });
  2287. // 对过滤后的数组进行重新排序
  2288. $sorted_img = array_values($filtered_img);
  2289. $item->template_img = $sorted_img;
  2290. } else {
  2291. $item->template_img = []; // 如果无法解码为数组,则设置为空数组
  2292. }
  2293. });
  2294. $result = [
  2295. "rows" => $rep->toArray(),
  2296. "count" => $count,
  2297. ];
  2298. }
  2299. }
  2300. }
  2301. return Result::success($result);
  2302. }
  2303. /**
  2304. * 添加网站模板
  2305. * @param array $data
  2306. */
  2307. public function addWebsiteTemplateclassintel(array $data): array
  2308. {
  2309. $template = Template::where('id', $data['template_id'])->first();
  2310. $web = Website::where('id', $data['website_id'])->first();
  2311. if (empty($template)) {
  2312. return Result::error("请输入正确的模板id", 0);
  2313. }
  2314. if (empty($web)) {
  2315. return Result::error("请输入正确的网站id", 0);
  2316. }
  2317. $result = WebsiteTemplateInfo::where('website_id', $data['website_id'])->update(['template_id' => $data['template_id'], 'action_id' => 2]);
  2318. if (empty($result)) {
  2319. return Result::error("添加失败", 0);
  2320. } else {
  2321. return Result::success($result);
  2322. }
  2323. }
  2324. /**
  2325. * 获取网站模板信息
  2326. * @param array $data
  2327. */
  2328. public function getWebsiteTemplateclassintel(array $data): array
  2329. {
  2330. // return Result::success($data);
  2331. $template = WebsiteTemplateInfo::where('website_id', $data['website_id'])->first();
  2332. if (empty($template)) {
  2333. return Result::error("请输入正确的搭建网站id", 0);
  2334. }
  2335. $page_type = json_decode($template['page_type'], true);
  2336. // 获取指定网站下的基础信息和模板及风格信息
  2337. $result = WebsiteTemplateInfo::where([
  2338. ['website_template_info.website_id', $data['website_id']],
  2339. ['website_template_info.template_id', '!=', null],
  2340. ])
  2341. ->leftJoin('template', 'template.id', 'website_template_info.template_id')
  2342. ->leftJoin('template_class', 'template_class.id', 'template.template_class_id')
  2343. ->where(function ($query) use ($page_type) {
  2344. // 假设 $data['page_type'] 是一个数组,包含需要匹配的 page_type 值
  2345. foreach ($page_type as $pageType) {
  2346. $query->orWhereJsonContains('template.template_img', ['value' => $pageType]);
  2347. }
  2348. })
  2349. ->select(
  2350. 'template.template_name',
  2351. 'template.template_img',
  2352. 'template.id as tid',
  2353. 'template_class.name',
  2354. 'template_class.id as class_id',
  2355. 'website_template_info.page_type',
  2356. 'website_template_info.website_id'
  2357. )
  2358. ->first();
  2359. if (empty($result)) {
  2360. return Result::error("没有查找到相关数据", 0);
  2361. }
  2362. // return Result::success($result);
  2363. // 过滤 template_img 字段 只获取 基础信息中 包含的模板图片
  2364. $template_img = $result['template_img'] !== null ? json_decode($result['template_img'], true) : [];
  2365. $page_type = $result['page_type'] !== null ? json_decode($result['page_type'], true) : [];
  2366. foreach ($template_img as $key => $value) {
  2367. if (!in_array($value['value'], $page_type)) {
  2368. unset($template_img[$key]);
  2369. }
  2370. }
  2371. // return Result::success($result);
  2372. $result['template_img'] = array_values($template_img);
  2373. $result['page_type'] = $page_type;
  2374. // $templateList = $this->getWebsiteTemplateList($data);
  2375. // $count = $templateList['data']['count']??'';
  2376. // $pages = $count / $data['pageSize'];
  2377. // $found = false;
  2378. // while ($pages && !$found) {
  2379. // $templates = $this->getWebsiteTemplateList($pages,$data['pageSize']);
  2380. // $index = array_search($template['template_id'], array_column($templates['rows'], 'id'));
  2381. // if ($index !== false) {
  2382. // $found = true;
  2383. // $result['page'] = $pages;
  2384. // $pages = 0;
  2385. // // echo "查询到的 template 在第 $page 页";
  2386. // }
  2387. // $pages--;
  2388. // }
  2389. return Result::success($result);
  2390. }
  2391. /**
  2392. * 获取网站模板下的板块信息
  2393. * @param array $data
  2394. */
  2395. public function getWebsiteSectorList(array $data): array
  2396. {
  2397. $website = Website::where('id', $data['website_id'])->first();
  2398. if (empty($website)) {
  2399. return Result::error("请输入正确的网站id", 0);
  2400. }
  2401. $template = WebsiteTemplateInfo::where('website_id', $data['website_id'])->first();
  2402. if (empty($template['template_id'])) {
  2403. return Result::error("请先添加网站模板", 0);
  2404. }
  2405. $query = Sector::where('template_id', $template['template_id']);
  2406. if ($query->count() == 0) {
  2407. return Result::error("没有查找到相关板块数据", 0);
  2408. } elseif ($query->count() == 1) {
  2409. $sector = $query->first();
  2410. } else {
  2411. $sector = $query->get();
  2412. }
  2413. $result['page_type'] = $template['page_type'];
  2414. $result['tid'] = $template['template_id'];
  2415. $result = [
  2416. "tid" => $template['template_id'],
  2417. "page_type" => $template['page_type'],
  2418. "sector" => $sector,
  2419. ];
  2420. return Result::success($result);
  2421. }
  2422. // 自助建站---------------fr---------------
  2423. // 网站底基础信息--fr-------------------
  2424. /**
  2425. * 添加网站底基础信息
  2426. * @param array $data
  2427. */
  2428. public function addWebFootInfo(array $data): array
  2429. {
  2430. $website = Website::where('id', $data['website_id'])->first();
  2431. if (empty($website)) {
  2432. return Result::error("请输入正确的网站id!", 0);
  2433. }
  2434. $info = WebsiteTemplateInfo::where('website_id', $data['website_id'])->first();
  2435. if (!empty($info)) {
  2436. return Result::error("该网站已经添加过了!", 0);
  2437. }
  2438. $result = WebsiteTemplateInfo::where('website_id', $data['website_id'])->insertGetId($data);
  2439. if (empty($result)) {
  2440. return Result::error("请先添加网站基础信息!", 0);
  2441. } else {
  2442. return Result::success($result);
  2443. }
  2444. }
  2445. /**
  2446. * 获取网站底基础信息
  2447. * @param array $data
  2448. */
  2449. public function getWebFootInfo(array $data): array
  2450. {
  2451. $website = Website::where('id', $data['website_id'])->first();
  2452. if (empty($website)) {
  2453. return Result::error("请输入正确的网站id!", 0);
  2454. }
  2455. $result = WebsiteTemplateInfo::where('website_id', $data['website_id'])->first();
  2456. if (empty($result)) {
  2457. return Result::error("请先添加网站基础信息!", 0);
  2458. }
  2459. return Result::success($result);
  2460. }
  2461. /**
  2462. * 修改网站底基础信息
  2463. * @param array $data
  2464. */
  2465. public function upWebFootInfo(array $data): array
  2466. {
  2467. // return Result::success($data);
  2468. $website = Website::where('id', $data['website_id'])->first();
  2469. if (empty($website)) {
  2470. return Result::error("请输入正确的网站id!", 0);
  2471. }
  2472. $web = $data['website_id'];
  2473. unset($data['website_id']);
  2474. $where = ['website_id' => $web];
  2475. // return Result::success($data);
  2476. $result = WebsiteTemplateInfo::where($where)->first();
  2477. if (empty($result)) {
  2478. $data['website_id'] = $web;
  2479. $result = WebsiteTemplateInfo::insertGetId($data);
  2480. // return Result::error("请先添加网站基础信息!",0);
  2481. } else {
  2482. $result = WebsiteTemplateInfo::where($where)->update($data);
  2483. }
  2484. // $where = ['website_id'=>$data['website_id']];
  2485. // unset($data['website_id']);
  2486. // $result = WebsiteTemplateInfo::updateOrInsert($where, $data);
  2487. if (empty($result)) {
  2488. return Result::error("修改失败!", 0);
  2489. }
  2490. return Result::success($result);
  2491. }
  2492. /*
  2493. * 获取父级/子级栏目------路由
  2494. * @param array $data
  2495. * @return array
  2496. * */
  2497. public function getWebsiteParentCategory(array $data): array
  2498. {
  2499. // return Result::success($data);
  2500. if (isset($data['website_id']) && !empty($data['website_id'])) {
  2501. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  2502. }
  2503. if (empty($website)) {
  2504. return Result::error("暂无该网站", 0);
  2505. }
  2506. // 在 Hyperf 中,查询构建器(Builder)没有 `map` 方法,`map` 方法是集合(Collection)的方法。
  2507. // 因此,需要先调用 `get()` 方法获取查询结果集合,再使用 `map` 方法进行处理。
  2508. $category['parent'] = WebsiteCategory::where('website_id', $data['website_id'])
  2509. ->where('pid', 0)
  2510. ->selectRaw("category_id as cid, alias as name, CONCAT('/', '', aLIas_pinyin, '/') as path")
  2511. ->get() // 添加 get() 方法获取结果集合
  2512. ->all();
  2513. // 提前查询所有父级栏目,避免在 map 中多次查询
  2514. // 提前查询所有父级栏目信息并以 category_id 作为键存储
  2515. $parentCategories = WebsiteCategory::where('website_id', $data['website_id'])
  2516. ->where('pid', 0)
  2517. ->select('category_id', 'aLIas_pinyin')
  2518. ->get()
  2519. ->keyBy('category_id');
  2520. // 直接查询子栏目信息
  2521. $child = WebsiteCategory::where('website_id', $data['website_id'])
  2522. ->where('pid', '!=', 0)
  2523. ->select('alias', 'category_id', 'aLIas_pinyin', 'pid')
  2524. ->get();
  2525. // 使用集合的 map 方法处理子栏目信息
  2526. $category['child'] = $child->map(function ($item) use ($parentCategories) {
  2527. $alias = $item->alias;
  2528. $category_id = $item->category_id;
  2529. $aLIas_pinyin = $item->aLIas_pinyin;
  2530. $parent = $parentCategories->get($item->pid);
  2531. $parentAlias = $parent ? $parent->aLIas_pinyin : '';
  2532. $result = [
  2533. 'name' => $alias,
  2534. 'cid' => $category_id
  2535. ];
  2536. if (!empty($aLIas_pinyin) && !empty($parentAlias)) {
  2537. $result['path'] = "/{$parentAlias}/{$aLIas_pinyin}/";
  2538. }
  2539. return $result;
  2540. })->values()->all();
  2541. if (empty($category)) {
  2542. return Result::error("暂无此导航", 0);
  2543. }
  2544. return Result::success($category);
  2545. }
  2546. /**
  2547. * 获取网站栏目信息
  2548. * @param array $data
  2549. */
  2550. public function getWebsiteFootAll(array $data): array
  2551. {
  2552. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  2553. if (empty($website)) {
  2554. return Result::error("暂无该网站", 0);
  2555. }
  2556. // 1:图片 2:文字 3:底部
  2557. $result['foot_cate'] = FooterCategory::where('website_id', $data['website_id'])->get()->all();
  2558. $result['link_img'] = Link::where('website_id', $data['website_id'])->where('type', 1)->where('status', 1)->limit($data['link_imgnum'])->orderBy('sort')->get()->all();
  2559. $result['link_text'] = Link::where('website_id', $data['website_id'])->where('type', 2)->where('status', 1)->limit($data['link_textnum'])->orderBy('sort')->get()->all();
  2560. $result['link_foot'] = Link::where('website_id', $data['website_id'])->where('type', 3)->where('status', 1)->limit($data['link_footnum'])->orderBy('sort')->get()->all();
  2561. $result['foot_info'] = WebsiteTemplateInfo::where('website_id', $data['website_id'])->first();
  2562. if (empty($result)) {
  2563. return Result::error("暂无此网站信息", 0);
  2564. }
  2565. return Result::success($result);
  2566. }
  2567. /**
  2568. * 获取网站顶部信息
  2569. * @param array $data
  2570. */
  2571. public function getWebsiteHead(array $data): array
  2572. {
  2573. $result = Website::where('id', $data['website_id'])->where('status', 1)->select('website_name', 'logo')->first();
  2574. if (empty($result)) {
  2575. return Result::error("暂无该网站", 0);
  2576. }
  2577. return Result::success($result);
  2578. }
  2579. /**
  2580. * 路由匹配
  2581. * @param array $data
  2582. */
  2583. public function getWebsiteRoute(array $data): array
  2584. {
  2585. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  2586. if (empty($website)) {
  2587. return Result::error("暂无该网站", 0);
  2588. }
  2589. if (isset($data['pinyin']) && !empty($data['pinyin'])) {
  2590. $result = WebsiteCategory::where('website_category.website_id', $data['website_id'])
  2591. ->where('website_category.aLIas_pinyin', $data['pinyin'])
  2592. ->leftJoin('website_category as pc', function ($join) use ($data) {
  2593. $join->on('pc.pid', '=', 'website_category.category_id')
  2594. ->where('pc.website_id', '=', $data['website_id']);
  2595. })
  2596. ->select('website_category.category_id', 'website_category.type', 'website_category.alias', DB::raw('CASE WHEN pc.category_id IS NOT NULL THEN 1 ELSE 0 END as children_count'))
  2597. ->first();
  2598. }
  2599. if (isset($data['foot_pinyin']) && !empty($data['foot_pinyin'])) {
  2600. $result = FooterCategory::where('website_id', $data['website_id'])->where('name_pinyin', $data['foot_pinyin'])->first(['id']);
  2601. }
  2602. if (!isset($result) || empty($result)) {
  2603. return Result::error("暂无该导航", 0);
  2604. }
  2605. return Result::success($result);
  2606. }
  2607. /**
  2608. * 获取网站栏目信息
  2609. * @param array $data
  2610. */
  2611. public function getWebsiteAllinfo(array $data): array
  2612. {
  2613. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  2614. if (empty($website)) {
  2615. return Result::error("暂无该网站", 0);
  2616. }
  2617. if (isset($data['website_id']) && !empty($data['website_id'])) {
  2618. $website_head = Website::where('id', $data['website_id'])
  2619. ->where('status', 1)
  2620. ->select(
  2621. 'id',
  2622. 'website_name',
  2623. 'logo',
  2624. 'title',
  2625. 'keywords',
  2626. 'description',
  2627. 'suffix',
  2628. 'website_url',
  2629. 'ad_key',
  2630. 'api_url',
  2631. 'login_url',
  2632. 'weblog_url'
  2633. )
  2634. ->first();
  2635. if (empty($website_head)) {
  2636. return Result::error("找不到网站", 0);
  2637. }
  2638. } else {
  2639. return Result::error("参数错误", 0);
  2640. }
  2641. $website_foot['foot_info'] = WebsiteTemplateInfo::where('website_id', $data['website_id'])->first();
  2642. if (empty($website_foot)) {
  2643. return Result::error("暂无底部基础信息", 0);
  2644. }
  2645. $website_head['website_url'] = $website_head['website_url'] ? json_decode($website_head['website_url']) : [];
  2646. $result['website_head'] = $website_head;
  2647. $result['website_foot'] = $website_foot;
  2648. // return Result::success($result);
  2649. // 1:图片 2:文字 3:底部
  2650. $result['website_foot']['foot_cate'] = FooterCategory::where('website_id', $data['website_id'])->get()->all();
  2651. $result['website_foot']['link_img'] = Link::where('website_id', $data['website_id'])->where('type', 1)->where('status', 1)->limit($data['link_imgnum'])->orderBy('sort')->get()->all();
  2652. $result['website_foot']['link_text'] = Link::where('website_id', $data['website_id'])->where('type', 2)->where('status', 1)->limit($data['link_textnum'])->orderBy('sort')->get()->all();
  2653. $result['website_foot']['link_foot'] = Link::where('website_id', $data['website_id'])->where('type', 3)->where('status', 1)->limit($data['link_footnum'])->orderBy('sort')->get()->all();
  2654. if (empty($result)) {
  2655. return Result::error("暂无此网站信息", 0);
  2656. }
  2657. return Result::success($result);
  2658. }
  2659. //20250212 网站标识
  2660. public function addWebsiteGroup(array $data): array
  2661. {
  2662. //判斷name是不是重复
  2663. $websiteGroupInfo = WebsiteGroup::query()->where('name', $data['name'])->first();
  2664. if (!empty($websiteGroupInfo)) {
  2665. return Result::error("网站标识重复", 0);
  2666. }
  2667. //添加信息
  2668. $result = WebsiteGroup::insertGetId($data);
  2669. var_dump($result);
  2670. if (empty($result)) {
  2671. return Result::error("创建失败", 0);
  2672. } else {
  2673. return Result::success($result);
  2674. }
  2675. }
  2676. public function getWebsiteGroupList(array $data): array
  2677. {
  2678. $where = [];
  2679. if (isset($data['name']) && !empty($data['name'])) {
  2680. array_push($where, ['website_group.name', 'like', '%' . $data['name'] . '%']);
  2681. }
  2682. $result = WebsiteGroup::where($where)
  2683. ->limit($data['pageSize'])->orderBy("id", "desc")->offset(($data['page'] - 1) * $data['pageSize'])
  2684. ->get();
  2685. foreach ($result as $websiteGroup) {
  2686. $webIds = json_decode($websiteGroup->web_ids, true);
  2687. $websites = Website::whereIn('id', $webIds)->get();
  2688. $websiteNames = $websites->pluck('website_name', 'id')->toArray();
  2689. $websiteGroup->website_names = $websiteNames;
  2690. $websiteGroup->website_names1 = implode(',', array_values($websiteNames));
  2691. }
  2692. $count = WebsiteGroup::where($where)->count();
  2693. if (empty($result)) {
  2694. return Result::error("没有数据", 0);
  2695. }
  2696. return Result::success(['list' => $result->toArray(), 'count' => $count]);
  2697. }
  2698. public function getWebsiteGroupInfo(array $data): array
  2699. {
  2700. $websiteInfo = WebsiteGroup::query()->where('id', $data['id'])->first();
  2701. $webIds = json_decode($websiteInfo->web_ids, true);
  2702. $websites = Website::whereIn('id', $webIds)->get();
  2703. $websiteNames = $websites->pluck('website_name', 'id')->toArray();
  2704. $websiteInfo->website_names = $websiteNames;
  2705. $websiteInfo->website_names1 = implode(',', array_values($websiteNames));
  2706. if (empty($websiteInfo)) {
  2707. return Result::error("找不到URL", 0);
  2708. }
  2709. return Result::success($websiteInfo->toArray());
  2710. }
  2711. public function updateWebsiteGroup(array $data): array
  2712. {
  2713. $where = [
  2714. 'id' => $data['id'],
  2715. ];
  2716. $insertData = [
  2717. 'name' => $data['name'],
  2718. 'web_ids' => $data['web_ids'],
  2719. ];
  2720. //判斷name是不是重复
  2721. $websiteGroupInfo = WebsiteGroup::query()->where('name', $data['name'])->first();
  2722. if (!empty($websiteGroupInfo) && $websiteGroupInfo->id != $data['id']) {
  2723. return Result::error("网站标识重复", 0);
  2724. }
  2725. $result = WebsiteGroup::where($where)->update($insertData);
  2726. var_dump($result, '------更新');
  2727. if (empty($result)) {
  2728. return Result::error("更新失败", 0);
  2729. } else {
  2730. return Result::success();
  2731. }
  2732. }
  2733. public function deleteWebsiteGroup(array $data): array
  2734. {
  2735. $where = [
  2736. 'id' => $data['id'],
  2737. ];
  2738. //看看user表是不是有这个id
  2739. $userGroup = User::query()->where('sszq', $data['id'])->first();
  2740. if (!empty($userGroup)) {
  2741. return Result::error("有用户在使用该网站标识,不能删除", 0);
  2742. }
  2743. $result = WebsiteGroup::where($where)->delete();
  2744. if (empty($result)) {
  2745. return Result::error("删除失败", 0);
  2746. } else {
  2747. return Result::success();
  2748. }
  2749. }
  2750. public function getWebsiteNavList(array $data): array
  2751. {
  2752. $data['type'] = isset($data['type']) ? $data['type'] : 1;
  2753. $where = [];
  2754. if (isset($data['website_id']) && !empty($data['website_id'])) {
  2755. array_push($where, ['website_id', '=', $data['website_id']]);
  2756. }
  2757. if (isset($data['pid'])) {
  2758. array_push($where, ['pid', '=', $data['pid']]);
  2759. }
  2760. if (isset($data['type']) && !empty($data['type'])) {
  2761. array_push($where, ['type', '=', $data['type']]);
  2762. }
  2763. // 根据站点和type获取websiteCategory 中的id
  2764. $websiteCategoryids = WebsiteCategory::query()
  2765. ->where('website_id', '=', $data['website_id'])
  2766. ->where('type', '=', $data['type'])
  2767. ->pluck('category_arr_id')->toArray();
  2768. var_dump($websiteCategoryids, '------获取websiteCategory 中的id');
  2769. //合并去重
  2770. $category_ids = [];
  2771. foreach ($websiteCategoryids as $key => $value) {
  2772. $v = json_decode($value, true);
  2773. $category_ids = array_unique(array_merge($category_ids, $v));
  2774. }
  2775. // var_dump($category_ids, '------获取websiteCategory 中的id');
  2776. //根据pid取出所有的websiteCategory 中的id
  2777. $list = WebsiteCategory::query()
  2778. ->where('website_id', '=', $data['website_id'])
  2779. ->where('is_url', '!=', 1)
  2780. ->where('pid', '=', $data['pid'])
  2781. ->whereIn('category_id', $category_ids)
  2782. ->get();
  2783. if (empty($list)) {
  2784. return Result::error("获取失败", 0);
  2785. } else {
  2786. return Result::success($list);
  2787. }
  2788. }
  2789. // 20250307 根据网站标识获和导航获取站点
  2790. public function getWebsiteNavPoolSite(array $data): array
  2791. {
  2792. $where = [];
  2793. if (isset($data['category_id']) && !empty($data['category_id'])) {
  2794. array_push($where, ['category_id', '=', $data['category_id']]);
  2795. }
  2796. $list = WebsiteCategory::query()->where($where)
  2797. ->leftJoin('website', 'website.id', '=', 'website_category.website_id')
  2798. ->select('website_category.*', 'website.website_name')
  2799. ->distinct()
  2800. ->get();
  2801. if (empty($list)) {
  2802. return Result::error("获取失败", 0);
  2803. } else {
  2804. return Result::success($list);
  2805. }
  2806. }
  2807. public function getWebsiteNavPool(array $data): array
  2808. {
  2809. // 初始化查询条件数组
  2810. $query = WebsiteCategory::query();
  2811. // 如果传入了 websiteids,则添加到查询条件中
  2812. if (isset($data['websiteids']) && !empty($data['websiteids'])) {
  2813. $query->whereIn('website_id', $data['websiteids']);
  2814. }
  2815. // 如果传入了 pid,则添加到查询条件中
  2816. if (isset($data['pid'])) {
  2817. $query->where('pid', '=', $data['pid']);
  2818. }
  2819. // 执行查询 唯一性 id
  2820. $list = $query->distinct()->get();
  2821. // 根据查询结果返回相应的结果
  2822. if ($list->isEmpty()) {
  2823. return Result::error("获取失败", 0);
  2824. } else {
  2825. return Result::success($list->toArray());
  2826. }
  2827. }
  2828. /**
  2829. *
  2830. * @param array $data
  2831. * @return array
  2832. */
  2833. public function getAllCategory(array $data): array
  2834. {
  2835. $total = Category::count();
  2836. $pageSize = 2000;
  2837. $pages = (int) ceil($total / $pageSize);
  2838. $results = [];
  2839. $concurrency = 5; // 最大并发数
  2840. $running = 0;
  2841. $chan = new \Swoole\Coroutine\Channel($pages);
  2842. for ($i = 0; $i < $pages; $i++) {
  2843. Coroutine::create(function () use ($i, $pageSize, $chan) {
  2844. $offset = $i * $pageSize;
  2845. $data = Category::useIndex('idx_covering')
  2846. ->orderBy('id', 'asc')
  2847. ->select('id', 'name', 'pid')
  2848. ->offset($offset)
  2849. ->limit($pageSize)
  2850. ->get()
  2851. ->toArray();
  2852. $chan->push($data);
  2853. });
  2854. }
  2855. for ($i = 0; $i < $pages; $i++) {
  2856. $res = $chan->pop();
  2857. if (is_array($res)) {
  2858. $results = array_merge($results, $res);
  2859. }
  2860. }
  2861. return Result::success($results);
  2862. }
  2863. /**
  2864. * 修改网站栏目排序
  2865. * @param array $data
  2866. * @return array
  2867. */
  2868. public function upWebsiteCategorySort(array $data): array
  2869. {
  2870. $where = [
  2871. 'website_id' => $data['website_id'],
  2872. 'id' => $data['id'],
  2873. ];
  2874. $result = WebsiteCategory::where($where)->update($data);
  2875. if ($result) {
  2876. return Result::success($result);
  2877. } else {
  2878. return Result::error("更新失败", 0);
  2879. }
  2880. }
  2881. //获取底部导航内容详情
  2882. public function getFooterContentInfo(array $data): array
  2883. {
  2884. $where = [
  2885. "id" => $data['content_id']
  2886. ];
  2887. $result = FooterContent::where($where)->first();
  2888. if ($result) {
  2889. return Result::success($result);
  2890. } else {
  2891. return Result::error("没有数据");
  2892. }
  2893. }
  2894. //获取底部导航内容列表
  2895. public function getFooterContentList(array $data): array
  2896. {
  2897. $where = [
  2898. "fcat_id" => $data['fcat_id'],
  2899. ];
  2900. switch (intval($data['type'])) {
  2901. case 0:
  2902. $result = FooterContent::where($where)->first();
  2903. break;
  2904. case 1:
  2905. $result = FooterContent::where($where)->get();
  2906. break;
  2907. }
  2908. if ($result) {
  2909. return Result::success($result);
  2910. } else {
  2911. return Result::error("没有数据");
  2912. }
  2913. }
  2914. /**
  2915. * 获取底部导航列表
  2916. * @param array $data
  2917. * @return array
  2918. */
  2919. public function getFooterCategoryList(array $data): array
  2920. {
  2921. $where = [
  2922. "website_id" => $data['website_id']
  2923. ];
  2924. $result = FooterCategory::where($where)->get();
  2925. if ($result) {
  2926. return Result::success($result);
  2927. } else {
  2928. return Result::error("没有数据");
  2929. }
  2930. }
  2931. // --自助建站-----------20250522fr----------------------start
  2932. /**
  2933. * 获取网站模板下的板块信息
  2934. * @param array $data
  2935. * @return array
  2936. */
  2937. public function getStaticResourceList(array $data): array
  2938. {
  2939. // return Result::success($data);
  2940. $where = [];
  2941. if (isset($data['img_alias']) && !empty($data['img_alias'])) {
  2942. array_push($where, ['website_img.img_alias', 'like', '%' . $data['img_alias'] . '%']);
  2943. }
  2944. if (isset($data['img_type']) && !empty($data['img_type'])) {
  2945. array_push($where, ['website_img.img_type', '=', $data['img_type']]);
  2946. }
  2947. if (isset($data['website_name']) && !empty($data['website_name'])) {
  2948. $website = Website::where('website_name', 'like', '%' . $data['website_name'] . '%')->first();
  2949. if (empty($website)) {
  2950. return Result::error("没有查找到相关数据", 0);
  2951. } else {
  2952. array_push($where, ['website_img.website_id', '=', $website['id']]);
  2953. }
  2954. }
  2955. // return Result::success($where);
  2956. $query = WebsiteImg::when(!empty($where), function ($query) use ($where) {
  2957. $query->where($where);
  2958. })
  2959. ->orderBy('updated_at', 'desc');
  2960. $count = $query->count();
  2961. $row = $query->leftJoin('website', 'website.id', '=', 'website_img.website_id')
  2962. ->select('website_img.*', 'website.website_name')
  2963. ->limit($data['pageSize'])
  2964. ->offset(($data['page'] - 1) * $data['pageSize'])
  2965. ->get();
  2966. if (empty($row)) {
  2967. return Result::error("没有查找到相关数据", 0);
  2968. } else {
  2969. $result = [
  2970. 'row' => $row,
  2971. 'count' => $count,
  2972. ];
  2973. }
  2974. return Result::success($result);
  2975. }
  2976. /**
  2977. * 添加网站模板下的板块信息
  2978. * @param array $data
  2979. */
  2980. public function addStaticResource(array $data): array
  2981. {
  2982. // $file = $data['img_url']->file('image');
  2983. // $size = $file->getSize();
  2984. $img_data = [
  2985. 'website_id' => $data['website_id'] ?? 0,
  2986. 'img_alias' => $data['img_alias'] ?? '',
  2987. 'img_url' => $data['img_url'],
  2988. 'img_size' => $data['img_size'],
  2989. ];
  2990. $img = WebsiteImg::insertGetId($img_data);
  2991. if (empty($img)) {
  2992. return Result::error("添加失败", 0);
  2993. }
  2994. $img_id['id'] = $img;
  2995. $url = WebsiteImg::where($img_id)->value('img_url');
  2996. // 1. 分割路径部分(以 / 为分隔符)
  2997. $pathSegments = explode('/', parse_url($url, PHP_URL_PATH));
  2998. // 2. 取最后一个元素作为文件名
  2999. $fileName = end($pathSegments); // 1743041040714597.jpg
  3000. // 3. 分割文件名获取扩展名
  3001. $fileParts = explode('.', $fileName);
  3002. $fileType = end($fileParts); // jpg
  3003. $img_datas = [
  3004. 'img_type' => $fileType,
  3005. 'name' => $fileName
  3006. ];
  3007. $up_img = WebsiteImg::where($img_id)->update($img_datas);
  3008. if (empty($up_img)) {
  3009. return Result::error("修改失败", 0);
  3010. }
  3011. return Result::success($up_img);
  3012. // 将字节转换为更友好的单位
  3013. // $friendlySize = $this->formatFileSize($size);
  3014. // $data['img_size'] = $friendlySize;
  3015. }
  3016. /**
  3017. * 修改网站模板下的板块信息
  3018. * @param array $data
  3019. */
  3020. public function delStaticResource(array $data): array
  3021. {
  3022. $where = [
  3023. 'id' => $data['id'],
  3024. ];
  3025. $result = WebsiteImg::where($where)->delete();
  3026. if (empty($result)) {
  3027. return Result::error("修改失败", 0);
  3028. }
  3029. return Result::success($result);
  3030. }
  3031. /**
  3032. * 获取尺寸列表
  3033. * @param array $data
  3034. */
  3035. public function getSizeList(array $data): array
  3036. {
  3037. $where = [];
  3038. if (isset($data['width']) && !empty($data['width'])) {
  3039. array_push($where, ['width', 'like', '%' . $data['width'] . '%']);
  3040. }
  3041. if (isset($data['height']) && !empty($data['height'])) {
  3042. array_push($where, ['height', 'like', '%' . $data['height'] . '%']);
  3043. }
  3044. $query = Size::when($where, function ($query) use ($where) {
  3045. $query->where($where);
  3046. })
  3047. ->orderBy('updated_at', 'desc');
  3048. $count = $query->count();
  3049. $rep = $query
  3050. ->offset(($data['page'] - 1) * $data['pageSize'])
  3051. ->limit($data['pageSize'])
  3052. ->get();
  3053. $result = [
  3054. 'row' => $rep,
  3055. 'count' => $count,
  3056. ];
  3057. if (empty($result)) {
  3058. return Result::error("获取失败", 0);
  3059. } else {
  3060. return Result::success($result);
  3061. }
  3062. }
  3063. /**
  3064. * 添加尺寸
  3065. * @param array $data
  3066. */
  3067. public function addSize(array $data): array
  3068. {
  3069. $size = Size::where('width', $data['width'])->where('height', $data['height'])->first();
  3070. if (!empty($size)) {
  3071. return Result::error("尺寸已存在", 0);
  3072. }
  3073. $result = Size::insertGetId($data);
  3074. if (empty($result)) {
  3075. return Result::error("添加失败", 0);
  3076. }
  3077. return Result::success($result);
  3078. }
  3079. /**
  3080. * 删除尺寸
  3081. * @param array $data
  3082. */
  3083. public function delSize(array $data): array
  3084. {
  3085. $where = [
  3086. 'id' => $data['id'],
  3087. ];
  3088. $result = Size::where($where)->delete();
  3089. if (empty($result)) {
  3090. return Result::error("删除失败", 0);
  3091. }
  3092. return Result::success($result);
  3093. }
  3094. /**
  3095. * 修改尺寸
  3096. * @param array $data
  3097. */
  3098. public function upSize(array $data): array
  3099. {
  3100. $where = [
  3101. 'id' => $data['id'],
  3102. ];
  3103. $size = Size::where('id', '!=', $data['id'])->where('width', $data['width'])->where('height', $data['height'])->first();
  3104. if (!empty($size)) {
  3105. return Result::error("尺寸已存在", 0);
  3106. }
  3107. $result = Size::where($where)->update($data);
  3108. if (empty($result)) {
  3109. return Result::error("修改失败", 0);
  3110. }
  3111. return Result::success($result);
  3112. }
  3113. /**
  3114. * 获取尺寸详情
  3115. * @param array $data
  3116. */
  3117. public function getSizeInfo(array $data): array
  3118. {
  3119. $where = [
  3120. 'id' => $data['id'],
  3121. ];
  3122. $result = Size::where($where)->first();
  3123. if (empty($result)) {
  3124. return Result::error("获取失败", 0);
  3125. } else {
  3126. return Result::success($result);
  3127. }
  3128. }
  3129. /**
  3130. * 获取网站名称缩写
  3131. * @param array $data
  3132. */
  3133. public function getWebsiteAdkey(array $data): array
  3134. {
  3135. $result = PinyinHelper::getFirstLetter($data['website_name']);
  3136. if (empty($result)) {
  3137. return Result::error("没有数据", 0);
  3138. } else {
  3139. return Result::success($result);
  3140. }
  3141. }
  3142. /**
  3143. * 静态资源管理-修改图片别名
  3144. * @param array $data
  3145. */
  3146. public function upStaticResource(array $data): array
  3147. {
  3148. $id = $data['id'];
  3149. unset($data['id']);
  3150. $result = WebsiteImg::where('id', $id)->update($data);
  3151. if (empty($result)) {
  3152. return Result::error("修改失败", 0);
  3153. }
  3154. return Result::success($result);
  3155. }
  3156. /**
  3157. * 自助建站-修改网站应用状态
  3158. * @param array $data
  3159. */
  3160. public function upWebsiteStatus(array $data): array
  3161. {
  3162. $where = [
  3163. 'website_id' => $data['website_id'],
  3164. ];
  3165. $website_template = WebsiteTemplate::where($where)->first();
  3166. unset($data['website_id']);
  3167. if ($data['status'] == 2) {
  3168. $template_status = 6;
  3169. } else {
  3170. $template_status = 1;
  3171. }
  3172. if (empty($website_template)) {
  3173. return Result::error("网站预制模板获取失败", 0);
  3174. } else {
  3175. Db::beginTransaction();
  3176. try {
  3177. $result['website_template'] = WebsiteTemplate::where($where)->update(['status' => $template_status]);
  3178. if (empty($result['website_template'])) {
  3179. return Result::error("修改网站模板状态失败", 0);
  3180. }
  3181. $result['website_template_info'] = WebsiteTemplateInfo::where($where)->update(['status' => $data['status']]);
  3182. if (empty($result['website_template_info'])) {
  3183. return Result::error("修改网站基础信息状态失败", 0);
  3184. }
  3185. Db::commit();
  3186. return Result::success($result);
  3187. } catch (\Exception $e) {
  3188. Db::rollBack();
  3189. return Result::error($e->getMessage(), 0);
  3190. }
  3191. }
  3192. }
  3193. // --自助建站-----------20250522fr----------------------end
  3194. /**
  3195. * 获取网站白名单路由地址
  3196. * @param array $data
  3197. * @return array
  3198. */
  3199. public function getWhiteRouterList(array $data): array
  3200. {
  3201. // 构建基础查询
  3202. $baseQuery = WhiteRouter::query();
  3203. // 功能名称模糊查询
  3204. if (!empty($data['function_name'])) {
  3205. $baseQuery->where('function_name', 'like', '%' . $data['function_name'] . '%');
  3206. }
  3207. // 网站ID查询 - 使用 JSON_CONTAINS 检查数组中是否包含指定的 website_id
  3208. if (!empty($data['website_id'])) {
  3209. $baseQuery->whereRaw('JSON_CONTAINS(website_id, ?)', [json_encode((int)$data['website_id'])]);
  3210. }
  3211. // 获取总数
  3212. $count = $baseQuery->count();
  3213. // 分页查询
  3214. $result = $baseQuery->orderBy('updated_at', 'desc')
  3215. ->limit($data['pageSize'])
  3216. ->offset(($data['page'] - 1) * $data['pageSize'])
  3217. ->get();
  3218. if (empty($result)) {
  3219. return Result::error("暂无数据", 0);
  3220. }
  3221. // 处理结果,将 website_id 转换为数组并获取对应的网站名称
  3222. $result->transform(function ($item) {
  3223. $websiteIds = json_decode($item->website_id, true);
  3224. $websiteNames = Website::whereIn('id', $websiteIds)
  3225. ->pluck('website_name')
  3226. ->toArray();
  3227. $item->website_names = $websiteNames;
  3228. $item->website_id = $websiteIds; // 将 website_id 转换为数组
  3229. return $item;
  3230. });
  3231. return Result::success([
  3232. 'rows' => $result->toArray(),
  3233. 'count' => $count
  3234. ]);
  3235. }
  3236. /**
  3237. * 添加网站白名单路由地址
  3238. * @param array $data
  3239. * @return array
  3240. */
  3241. public function addWhiteRouter(array $data): array
  3242. {
  3243. // 确保 website_id 是数组
  3244. $websiteIds = is_array($data['website_id']) ? $data['website_id'] : [$data['website_id']];
  3245. // 过滤空值并去重
  3246. $websiteIds = array_filter($websiteIds);
  3247. $websiteIds = array_unique($websiteIds);
  3248. // 将数组中的值转换为整数
  3249. $websiteIds = array_map(function ($value) {
  3250. return (int)$value;
  3251. }, $websiteIds);
  3252. // 转换为 JSON 字符串存储
  3253. $data['website_id'] = json_encode($websiteIds);
  3254. $result = WhiteRouter::insertGetId($data);
  3255. if (empty($result)) {
  3256. return Result::error("添加失败", 0);
  3257. }
  3258. return Result::success($result);
  3259. }
  3260. /**
  3261. * 修改网站白名单路由地址
  3262. * @param array $data
  3263. * @return array
  3264. */
  3265. public function upWhiteRouter(array $data): array
  3266. {
  3267. $where = [
  3268. 'id' => $data['id'],
  3269. ];
  3270. // 确保 website_id 是数组
  3271. $websiteIds = is_array($data['website_id']) ? $data['website_id'] : [$data['website_id']];
  3272. // 过滤空值并去重
  3273. $websiteIds = array_filter($websiteIds);
  3274. $websiteIds = array_unique($websiteIds);
  3275. // 将数组中的值转换为整数
  3276. $websiteIds = array_map(function ($value) {
  3277. return (int)$value;
  3278. }, $websiteIds);
  3279. // 转换为 JSON 字符串存储
  3280. $data['website_id'] = json_encode($websiteIds);
  3281. $result = WhiteRouter::where($where)->update($data);
  3282. if (empty($result)) {
  3283. return Result::error("修改失败", 0);
  3284. }
  3285. return Result::success($result);
  3286. }
  3287. /**
  3288. * 删除网站白名单路由地址
  3289. * @param array $data
  3290. * @return array
  3291. */
  3292. public function delWhiteRouter(array $data): array
  3293. {
  3294. $where = [
  3295. 'id' => $data['id'],
  3296. ];
  3297. $result = WhiteRouter::where($where)->delete();
  3298. if (empty($result)) {
  3299. return Result::error("删除失败", 0);
  3300. }
  3301. return Result::success($result);
  3302. }
  3303. /**
  3304. * 获取网站白名单路由地址详情
  3305. * @param array $data
  3306. * @return array
  3307. */
  3308. public function getWhiteRouterInfo(array $data): array
  3309. {
  3310. $where = [
  3311. 'id' => $data['id'],
  3312. ];
  3313. $result = WhiteRouter::where($where)->first();
  3314. if (empty($result)) {
  3315. return Result::error("没有查找到相关数据", 0);
  3316. }
  3317. // 将 website_id 从 JSON 字符串转换为数组
  3318. $result->website_id = json_decode($result->website_id, true);
  3319. return Result::success($result);
  3320. }
  3321. /**
  3322. * 克隆网站
  3323. * @param array $data
  3324. * @return array
  3325. */
  3326. public function cloneWebsite(array $data): array
  3327. {
  3328. DB::beginTransaction();
  3329. try {
  3330. // 获取原始网站信息
  3331. $originalWebsite = Website::find($data['website_id']);
  3332. if (!$originalWebsite) {
  3333. return Result::error("找不到该网站", 0);
  3334. }
  3335. // 提取基础名称(去除已有 _copy 或 _copy_xxx)
  3336. $baseName = preg_replace('/_copy(\d+)?$/', '', $originalWebsite->website_name);
  3337. // 查询当前系统中已存在的克隆名称数量
  3338. $count = Website::where('website_name', 'like', $baseName . '_copy%')
  3339. ->orWhere('website_name', $baseName)
  3340. ->count();
  3341. // 构造新名称:第一次是 _copy,之后是 _copy_1, _copy_2 ...
  3342. $newName = $baseName . ($count === 0 ? '_copy' : '_copy_' . $count);
  3343. // 创建克隆网站实例
  3344. $clone_website = $originalWebsite->replicate();
  3345. $clone_website->website_name = $newName;
  3346. $clone_website->save();
  3347. $clone_website->website_url = "[]";
  3348. $clone_website->save();
  3349. // var_dump("返回值:",$clone_website->id);
  3350. //克隆网站基础信息 website_template_info website_category
  3351. $resultWebsiteTemplateInfo = WebsiteTemplateInfo::where(['website_id' => $data['website_id']])->first();
  3352. $clone_website_template_info = $resultWebsiteTemplateInfo->replicate();
  3353. $clone_website_template_info->website_id = $clone_website->id;
  3354. $clone_website_template_info->save();
  3355. //克隆网站导航 获取原始 website_id 对应的所有 WebsiteCategory 记录
  3356. $originalCategories = WebsiteCategory::where('website_id', $data['website_id'])->get();
  3357. // 克隆网站后的新 ID(假设 $clone_website->id 已存在)
  3358. $newWebsiteId = $clone_website->id;
  3359. // 遍历每条记录并克隆
  3360. foreach ($originalCategories as $category) {
  3361. // 使用 replicate() 方法创建模型副本(不包含主键)
  3362. $clonedCategory = $category->replicate();
  3363. // 修改外键字段指向新网站 ID
  3364. $clonedCategory->website_id = $newWebsiteId;
  3365. // 保存克隆后的记录到数据库
  3366. $clonedCategory->save();
  3367. }
  3368. //克隆友情链接 Link 对应的是多个
  3369. $originalLinks = Link::where('website_id', $data['website_id'])->get();
  3370. foreach ($originalLinks as $link) {
  3371. // 使用 replicate() 方法创建模型副本(不包含主键)
  3372. $clonedLink = $link->replicate();
  3373. // 修改外键字段指向新网站 ID
  3374. $clonedLink->website_id = $newWebsiteId;
  3375. // 保存克隆后的记录到数据库
  3376. $clonedLink->save();
  3377. }
  3378. //克隆网站底部信息 footer_category 表 和footer_content 表 footer_category.id = footer_content.fcat_id 都是一对多关系
  3379. $originalFooterCategories = FooterCategory::where('website_id', $data['website_id'])->get();
  3380. foreach ($originalFooterCategories as $footerCategory) {
  3381. $clonedFooterCategory = $footerCategory->replicate();
  3382. $clonedFooterCategory->website_id = $newWebsiteId;
  3383. $clonedFooterCategory->save();
  3384. $originalFooterContents = FooterContent::where('fcat_id', $footerCategory->id)->get();
  3385. foreach ($originalFooterContents as $footerContent) {
  3386. $clonedFooterContent = $footerContent->replicate();
  3387. $clonedFooterContent->fcat_id = $clonedFooterCategory->id;
  3388. $clonedFooterContent->save();
  3389. }
  3390. }
  3391. Db::commit();
  3392. return Result::success([]);
  3393. } catch (\Exception $e) {
  3394. Db::rollBack();
  3395. return Result::error($e->getMessage(), 0);
  3396. }
  3397. }
  3398. /**
  3399. * 更新网站状态
  3400. * @param array $data
  3401. * @return array
  3402. */
  3403. public function updateWebsiteStatus(array $data): array
  3404. {
  3405. try {
  3406. Website::where(["id" => $data['id']])->update(["status" => intval($data['status'])]);
  3407. return Result::success([]);
  3408. } catch (\Exception $e) {
  3409. return Result::error($e->getMessage(), 0);
  3410. }
  3411. }
  3412. /**
  3413. * 删除网站url
  3414. * @param array $data
  3415. * @return array
  3416. */
  3417. public function delWebsiteUrl(array $data): array{
  3418. try {
  3419. $wensiteInfo = Website::where(["id" => $data['website_id']])->first();
  3420. if (empty($wensiteInfo)) {
  3421. return Result::error("找不到该网站", 0);
  3422. }
  3423. $websiteUrlArray = [];
  3424. if (!empty($wensiteInfo->website_url)) {
  3425. $decoded = json_decode((string) $wensiteInfo->website_url, true);
  3426. $websiteUrlArray = is_array($decoded) ? $decoded : [];
  3427. }
  3428. // 从数组中按值删除对应的 URL
  3429. $index = array_search($data['website_url'] ?? null, $websiteUrlArray, true);
  3430. if ($index !== false) {
  3431. unset($websiteUrlArray[$index]);
  3432. // 重新索引,保持为连续的 JSON 数组
  3433. $websiteUrlArray = array_values($websiteUrlArray);
  3434. }
  3435. $newWebsiteUrlJson = json_encode($websiteUrlArray, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
  3436. Website::where(["id" => $data['website_id']])->update(["website_url" => $newWebsiteUrlJson]);
  3437. return Result::success([]);
  3438. } catch (\Exception $e) {
  3439. return Result::error($e->getMessage(), 0);
  3440. }
  3441. }
  3442. }