WebsiteService.php 142 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265326632673268326932703271327232733274327532763277327832793280328132823283328432853286328732883289329032913292329332943295329632973298329933003301330233033304330533063307330833093310331133123313331433153316331733183319332033213322332333243325332633273328332933303331333233333334333533363337333833393340334133423343334433453346334733483349335033513352335333543355335633573358335933603361336233633364336533663367336833693370337133723373337433753376337733783379338033813382338333843385338633873388338933903391339233933394339533963397339833993400340134023403340434053406340734083409341034113412341334143415341634173418341934203421342234233424342534263427342834293430343134323433343434353436343734383439344034413442344334443445344634473448344934503451345234533454345534563457345834593460346134623463346434653466346734683469347034713472347334743475347634773478347934803481348234833484348534863487348834893490349134923493349434953496349734983499350035013502350335043505350635073508350935103511351235133514351535163517351835193520352135223523352435253526352735283529353035313532353335343535353635373538353935403541354235433544354535463547354835493550355135523553355435553556355735583559356035613562356335643565356635673568356935703571357235733574357535763577357835793580358135823583358435853586358735883589359035913592359335943595359635973598359936003601360236033604360536063607360836093610361136123613361436153616361736183619362036213622362336243625362636273628
  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. WebsiteCategory::where($where)->update(['aLIas_pinyin' => $data['aLIas_pinyin']]);
  1620. //处理path
  1621. $category_arr_id = json_decode($result['category_arr_id'], true);
  1622. //取出来设置path
  1623. $path = WebsiteCategory::where('website_id', $data['website_id'])
  1624. ->orderByRaw('FIELD(category_id, ' . implode(',', $category_arr_id) . ')')
  1625. ->whereIn('category_id', $category_arr_id)
  1626. ->pluck('aLIas_pinyin')
  1627. ->implode('/');
  1628. $data['path'] = $path;
  1629. //处理包含此id的所有path
  1630. // 取出category_arr_id包含此id的所有数据
  1631. $all_other = WebsiteCategory::where('website_id', $data['website_id'])
  1632. ->whereJsonContains('category_arr_id', $data['category_id'])
  1633. ->get();
  1634. var_dump($all_other, '------------');
  1635. // 遍历所有数据,更新path
  1636. $newAliasPinyin = $aLIas_pinyin ?? ''; // 添加空值判断
  1637. $oldAliasPinyin = $result['alias_pinyin'] ?? ''; // 修正键名大小写
  1638. // 收集需要更新的ID和路径
  1639. $updateData = [];
  1640. foreach ($all_other as $item) {
  1641. $newPath = str_replace($oldAliasPinyin, $newAliasPinyin, $item->path);
  1642. if ($newPath !== $item->path) { // 仅在路径变化时更新
  1643. $updateData[] = [
  1644. 'id' => $item->id,
  1645. 'path' => $newPath
  1646. ];
  1647. }
  1648. }
  1649. // 批量更新提高性能
  1650. if (!empty($updateData)) {
  1651. // 假设模型对应的数据表为 'table_name',请替换为实际表名
  1652. Db::table('website_category')->updateOrInsert(
  1653. ['id' => DB::raw('VALUES(id)')],
  1654. $updateData
  1655. );
  1656. }
  1657. $result = WebsiteCategory::where($where)->update($data);
  1658. if ($result) {
  1659. return Result::success($result);
  1660. } else {
  1661. return Result::error("更新失败", 0);
  1662. }
  1663. }
  1664. /**
  1665. * 获取网站下的所有导航(包含子导航)
  1666. * @param array $data
  1667. * @return array
  1668. */
  1669. public function getWebsiteAllCategory(array $data): array
  1670. {
  1671. $where = [];
  1672. if (isset($data['website_id']) && !empty($data['website_id'])) {
  1673. array_push($where, ['website_category.website_id', '=', $data['website_id']]);
  1674. }
  1675. // if (isset($data['name']) && !empty($data['name'])) {
  1676. // array_push($where, ['website_category.name', 'like', '%' . $data['name'] . '%']);
  1677. // }
  1678. // if (isset($data['alias']) && !empty($data['alias'])) {
  1679. // array_push($where, ['website_category.alias', 'like', '%' . $data['alias'] . '%']);
  1680. // }
  1681. // if (isset($data['department_id']) && !empty($data['department_id'])) {
  1682. // array_push($where, ['category.department_id', '=', $data['department_id']]);
  1683. // }
  1684. // if (isset($data['city_id']) && !empty($data['city_id'])) {
  1685. // array_push($where, ['category.city_id', '=', $data['city_id']]);
  1686. // }
  1687. $result = WebsiteCategory::where($where)
  1688. ->leftJoin("category", 'website_category.category_id', 'category.id')
  1689. ->select("website_category.*", "category.name as name")
  1690. // ->leftJoin("category", 'website_category.category_id', 'category.id')
  1691. // ->leftJoin("department", 'category.department_id', 'department.id')
  1692. // ->leftJoin("district", 'category.city_id', 'district.id')
  1693. // ->select("website_category.*", "department.name as department_name", "district.name as city_name")
  1694. // ->limit($data['pageSize'])->offset(($data['page'] - 1) * $data['pageSize'])
  1695. ->orderBy("sort", "asc")
  1696. ->orderBy("updated_at", "desc")
  1697. ->get();
  1698. // $count = WebsiteCategory::where($where)
  1699. // ->leftJoin("category", 'website_category.category_id', 'category.id')
  1700. // ->leftJoin("department", 'category.department_id', 'department.id')
  1701. // ->leftJoin("district", 'category.city_id', 'district.id')
  1702. // ->count();
  1703. if (empty($result)) {
  1704. return Result::error("没有数据", 0);
  1705. }
  1706. // $data = [
  1707. // 'rows' => $result->toArray(),
  1708. // 'count' => $count,
  1709. // ];
  1710. if ($result) {
  1711. return Result::success($result->toArray());
  1712. } else {
  1713. return Result::error("查询失败", 0);
  1714. }
  1715. }
  1716. /**
  1717. * 递归查询数据
  1718. * @param $id
  1719. * @param $ids
  1720. * @return string
  1721. */
  1722. public function getUnderlingUIds($id, $ids = '')
  1723. {
  1724. $back = Category::where(['pid' => $id])->get();
  1725. $back = $back->toArray();
  1726. if (!empty($back) && is_array($back)) {
  1727. foreach ($back as $v) {
  1728. //防止当前人的ID重复去查询,形成恶性循环
  1729. if ($v['id'] == $id) {
  1730. continue;
  1731. }
  1732. $back2 = Category::where(['pid' => $id])->count('id');
  1733. if ($back2 > 0) {
  1734. $ids = $this->getUnderlingUIds($v['id'], $ids);
  1735. } else {
  1736. $ids .= ',' . $v['id'];
  1737. }
  1738. }
  1739. }
  1740. $ids = $id . ',' . $ids . ',';
  1741. $ids = str_replace(',,', ",", $ids);
  1742. $ids = trim($ids, ',');
  1743. return $ids;
  1744. }
  1745. /**
  1746. * 检测网站名称是否重复
  1747. * @param array $data
  1748. * @return array
  1749. */
  1750. public function checkWebsiteName(array $data): array
  1751. {
  1752. if (isset($data['id'])) {
  1753. $data[] = ['id', "!=", $data['id']];
  1754. unset($data['id']);
  1755. }
  1756. $websiteInfo = Website::query()->where($data)->first();
  1757. if (empty($websiteInfo)) {
  1758. return Result::error("找不到网站", 0);
  1759. }
  1760. return Result::success($websiteInfo->toArray());
  1761. }
  1762. /**
  1763. * 检测网站url是否重复
  1764. * @param array $data
  1765. * @return array
  1766. */
  1767. public function checkWebsiteUrl(array $data): array
  1768. {
  1769. $whereData = [];
  1770. if (isset($data['id'])) {
  1771. $whereData = [['id', "!=", $data['id']]];
  1772. unset($data['id']);
  1773. }
  1774. $websiteInfo = Website::query()->where($whereData)->whereJsonContains('website_url', $data['website_url'])->first();
  1775. if (empty($websiteInfo)) {
  1776. return Result::error("找不到URL", 0);
  1777. }
  1778. return Result::success($websiteInfo->toArray());
  1779. }
  1780. /**
  1781. * 获取网站底部基础信息
  1782. * @param array $data
  1783. * @return array
  1784. */
  1785. public function getWebsiteFootInfo(array $data): array
  1786. {
  1787. if (isset($data['website_id']) && !empty($data['website_id'])) {
  1788. $website_head = Website::where('id', $data['website_id'])
  1789. ->where('status', 1)
  1790. ->select('id', 'website_name', 'logo', 'title', 'keywords', 'description', 'suffix', 'website_url')
  1791. ->first();
  1792. if (empty($website_head)) {
  1793. return Result::error("找不到网站", 0);
  1794. }
  1795. } else {
  1796. return Result::error("参数错误", 0);
  1797. }
  1798. $website_head = Website::where('id', $data['website_id'])
  1799. ->select('id', 'website_name', 'logo', 'title', 'keywords', 'description', 'suffix', 'website_url')->first();
  1800. $website_foot = WebsiteTemplateInfo::where('website_id', $data['website_id'])->first();
  1801. if (empty($website_foot)) {
  1802. return Result::error("暂无底部基础信息", 0);
  1803. }
  1804. $website_head['website_url'] = $website_head['website_url'] ? json_decode($website_head['website_url']) : [];
  1805. $result = [
  1806. 'website_foot' => $website_foot,
  1807. 'website_head' => $website_head,
  1808. ];
  1809. return Result::success($result);
  1810. }
  1811. /**
  1812. * 获取网站底部导航
  1813. * @param array $data
  1814. * @return array
  1815. */
  1816. public function getWebsiteFooterCategory(array $data): array
  1817. {
  1818. if (isset($data['website_id']) && !empty($data['website_id'])) {
  1819. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  1820. if (empty($website)) {
  1821. return Result::error("找不到网站", 0);
  1822. }
  1823. } else {
  1824. return Result::error("参数错误", 0);
  1825. }
  1826. $result = FooterCategory::where('website_id', $data['website_id'])->get();
  1827. if (empty($result)) {
  1828. return Result::error("暂无底部导航", 0);
  1829. }
  1830. return Result::success($result->toArray());
  1831. }
  1832. /**
  1833. * 获取网站底部导航列表
  1834. * @param array $data
  1835. * @return array
  1836. */
  1837. public function getWebsiteFooterCategoryList(array $data): array
  1838. {
  1839. if (isset($data['website_id']) && !empty($data['website_id'])) {
  1840. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  1841. if (empty($website)) {
  1842. return Result::error("找不到网站", 0);
  1843. }
  1844. } else {
  1845. return Result::error("参数错误", 0);
  1846. }
  1847. $footercategory = FooterCategory::where('website_id', $data['website_id'])->where('id', $data['fcat_id'])->first();
  1848. // '底部导航类型 0:内容型;1:列表型;',
  1849. if (!isset($footercategory['type']) || $footercategory['type'] == 0) {
  1850. return Result::error("底部导航id错误", 0);
  1851. } else {
  1852. $query = FooterContent::where('fcat_id', $data['fcat_id']);
  1853. if ($query->count() == 0) {
  1854. return Result::error("暂无底部导航列表", 0);
  1855. } elseif ($query->count() == 1) {
  1856. $result = $query->first();
  1857. } else {
  1858. $result = $query->get();
  1859. }
  1860. }
  1861. return Result::success($result);
  1862. }
  1863. /**
  1864. * 获取网站底部导航
  1865. * @param array $data
  1866. * @return array
  1867. */
  1868. public function getWebsiteFooterCategoryInfo(array $data): array
  1869. {
  1870. if (isset($data['website_id']) && !empty($data['website_id'])) {
  1871. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  1872. if (empty($website)) {
  1873. return Result::error("找不到网站", 0);
  1874. }
  1875. } else {
  1876. return Result::error("参数错误", 0);
  1877. }
  1878. if (isset($data['type']) && $data['type'] == 0) {
  1879. $fcatid = FooterCategory::where('website_id', $data['website_id'])->where('id', $data['fcat_id'])->first();
  1880. if (empty($fcatid)) {
  1881. return Result::error("底部导航id错误", 0);
  1882. }
  1883. $result = FooterContent::where('fcat_id', $data['fcat_id'])->first();
  1884. } else {
  1885. $result = FooterContent::where('id', $data['fcat_id'])->first();
  1886. }
  1887. if (empty($result)) {
  1888. return Result::error("暂无底部导航内容", 0);
  1889. }
  1890. return Result::success($result);
  1891. }
  1892. /*
  1893. * 搜索网站二级导航
  1894. * @param array $data
  1895. * @return array
  1896. * */
  1897. public function selectWebsiteCategory(array $data): array
  1898. {
  1899. if (isset($data['website_id']) && !empty($data['website_id'])) {
  1900. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  1901. if (empty($website)) {
  1902. return Result::error("暂无该网站", 0);
  1903. }
  1904. $category = WebsiteCategory::where('website_id', $data['website_id'])->pluck('category_id')->all();
  1905. // return Result::success($category);
  1906. if (empty($category)) {
  1907. return Result::error("暂无此导航", 0);
  1908. }
  1909. $query = Category::whereIn('id', $category);
  1910. if (isset($data['cityid']) && !empty($data['cityid'])) {
  1911. $cityid = District::where('id', $data['cityid'])->first();
  1912. if (empty($cityid)) {
  1913. return Result::error("暂无此城市", 0);
  1914. } else {
  1915. $city_category = $query->whereRaw('JSON_CONTAINS(city_arr_id,?)', [$data['cityid']])->pluck('id');
  1916. // $where[] = ['JSON_CONTAINS(city_arr_id, ?)', $data['cityid']];
  1917. if (empty($city_category)) {
  1918. return Result::error("暂无此城市下的导航", 0);
  1919. }
  1920. $result['catid'] = $city_category;
  1921. $city = 1;
  1922. // var_dump("城市====================",$result);
  1923. }
  1924. }
  1925. if (isset($data['department_id']) && !empty($data['department_id'])) {
  1926. $departmentid = Department::where('id', $data['department_id'])->first();
  1927. if (empty($departmentid)) {
  1928. return Result::error("暂无此部门", 0);
  1929. } else {
  1930. $depart_category = $query->whereRaw('JSON_CONTAINS(department_arr_id,?)', [$data['department_id']])->pluck('id');
  1931. if (empty($depart_category)) {
  1932. return Result::error("暂无此部门下的导航", 0);
  1933. }
  1934. $result['catid'] = $depart_category;
  1935. // var_dump("职能部门*******************",$result);
  1936. $department = 1;
  1937. }
  1938. }
  1939. if (!empty($city) && !empty($department)) {
  1940. // var_dump("城市和职能部门----------------------",$result);
  1941. $sel_category = $query->whereRaw('JSON_CONTAINS(city_arr_id,?)', [$data['cityid']])->whereRaw('JSON_CONTAINS(department_arr_id,?)', [$data['department_id']])->pluck('id');
  1942. if (empty($sel_category)) {
  1943. return Result::error("暂无此城市和职能部门下的导航", 0);
  1944. }
  1945. $result['catid'] = $sel_category;
  1946. }
  1947. if (empty($result)) {
  1948. return Result::error("暂无导航", 0);
  1949. }
  1950. // department_id
  1951. } else {
  1952. return Result::error("参数错误", 0);
  1953. }
  1954. return Result::success($result);
  1955. }
  1956. /**
  1957. * 获取网站栏目seo
  1958. * @param array $data
  1959. * @return array
  1960. */
  1961. public function getWebsiteCategoryHead(array $data): array
  1962. {
  1963. if (isset($data['website_id']) && !empty($data['website_id'])) {
  1964. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  1965. if (empty($website)) {
  1966. return Result::error("找不到网站", 0);
  1967. }
  1968. } else {
  1969. return Result::error("参数错误", 0);
  1970. }
  1971. if (isset($data['catid']) && !empty($data['catid'])) {
  1972. $result = WebsiteCategory::where('website_id', $data['website_id'])->where('category_id', $data['catid'])->first();
  1973. }
  1974. if (empty($result)) {
  1975. return Result::error("暂无导航", 0);
  1976. }
  1977. $result['website_name'] = $website['website_name'] ?? '';
  1978. $result['suffix'] = $website['suffix'] ?? '';
  1979. return Result::success($result);
  1980. }
  1981. /*
  1982. * 获取某个栏目
  1983. * @param array $data
  1984. * @return array
  1985. * */
  1986. public function getOneWebsiteCategory(array $data): array
  1987. {
  1988. if (isset($data['website_id']) && !empty($data['website_id'])) {
  1989. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  1990. if (empty($website)) {
  1991. return Result::error("暂无该网站", 0);
  1992. }
  1993. $category = WebsiteCategory::where('website_id', $data['website_id'])->where('category_id', $data['category_id'])->first();
  1994. if (empty($category)) {
  1995. return Result::error("暂无此导航", 0);
  1996. }
  1997. $category['children_count'] = WebsiteCategory::where('website_id', $data['website_id'])->where('pid', $data['category_id'])->count();
  1998. $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();
  1999. $category['parent_id'] = $parent['parent_id'] ?? '';
  2000. $category['parent_pinyin'] = $parent['aLIas_pinyin'] ?? '';
  2001. $category['parent_name'] = $parent['parent_name'] ?? '';
  2002. return Result::success($category);
  2003. } else {
  2004. return Result::error("参数错误", 0);
  2005. }
  2006. }
  2007. // 自助建站--fr-------------------
  2008. /**
  2009. * 获取并搜索 网站模板信息
  2010. * @param array $data
  2011. * @return array
  2012. */
  2013. public function getWebsiteintel(array $data): array
  2014. {
  2015. //查询所有网站模板信息
  2016. $query = Website::where('website.status', 1)
  2017. ->leftJoin("website_template_info", "website_template_info.website_id", "website.id")
  2018. ->leftJoin("template", "template.template_id", "website_template_info.template_id")
  2019. ->leftJoin("template_class", "template_class.class_id", "template.template_class_id")
  2020. ->leftJoin('website_column', 'website_column.id', 'website.website_column_id')
  2021. ->leftJoin('website_column as parent_column', function ($join) {
  2022. $join->on('website_column.pid', '=', 'parent_column.id')
  2023. ->where('website_column.pid', 2);
  2024. })
  2025. ->whereRaw('JSON_CONTAINS(website_column_arr_id,?)', [2])
  2026. ->select(
  2027. "website_template_info.id",
  2028. "template_class.name",
  2029. "website.id as website_id",
  2030. "website.website_name",
  2031. "website.website_url",
  2032. "website_template_info.action_id",
  2033. "website_template_info.created_at",
  2034. "website_template_info.updated_at",
  2035. "website_template_info.page_type",
  2036. 'website_column.column_name',
  2037. 'parent_column.column_name as parent_column_name',
  2038. DB::raw("COALESCE(website_template_info.status, 0) as template_status"),
  2039. "template.template_name"
  2040. );
  2041. //若存在条件;则在$query的基础上进行筛选
  2042. if (isset($data['website_name']) && !empty($data['website_name'])) {
  2043. $query->where('website.website_name', 'like', '%' . $data['website_name'] . '%');
  2044. }
  2045. if (isset($data['status']) && !empty($data['status'])) {
  2046. $query->where('website_template_info.status', $data['status']);
  2047. }
  2048. $count = $query->count();
  2049. $query->limit($data['pageSize'])
  2050. ->offset(($data['page'] - 1) * $data['pageSize'])
  2051. ->orderBy("website_template_info.updated_at", "desc");
  2052. $rep = $query->get();
  2053. if ($rep->count() == 0) {
  2054. return Result::error("没有查找到相关数据", 0);
  2055. } else {
  2056. $rep->each(function ($item) {
  2057. if (!empty($item->page_type)) {
  2058. $pageTypeArray = json_decode($item->page_type, true);
  2059. if (is_array($pageTypeArray)) {
  2060. $item->page_type = $pageTypeArray;
  2061. }
  2062. }
  2063. });
  2064. $result = [
  2065. "rows" => $rep->toArray(),
  2066. "count" => $count,
  2067. ];
  2068. return Result::success($result);
  2069. }
  2070. // return Result::success($result);
  2071. }
  2072. /**
  2073. * 自助建站-验证搭建网站
  2074. * @param array $data
  2075. * @return array
  2076. */
  2077. public function checkWebsiteBuild(array $data): array
  2078. {
  2079. $website = Website::where('website.id', $data['website_id'])->first();
  2080. if (empty($website)) {
  2081. return Result::error("请输入正确的网站id!", 0);
  2082. }
  2083. if (empty($website['website_column_id'])) {
  2084. return Result::error("请先关联导航池!", 0);
  2085. }
  2086. // 获取此网站的底部导航 类型 type: 0:内容型底部导航(只有一条详情内容);1:列表型底部导航(可以有多条详情内容)
  2087. $foot_type = FooterCategory::where('website_id', $data['website_id'])->pluck('type')->toArray();
  2088. if (empty($foot_type)) {
  2089. return Result::error("请先关联单页!", 0);
  2090. }
  2091. // if (!in_array(1, $foot_type) ) {
  2092. // $missingTypes[] = "列表型底部导航";
  2093. // }
  2094. if (!in_array(0, $foot_type)) {
  2095. $missingTypes[] = "单页(详情)";
  2096. }
  2097. if (!empty($missingTypes)) {
  2098. $errorMessage = "请先添加" . $missingTypes . "!";
  2099. return Result::error($errorMessage, 0);
  2100. }
  2101. $result['foot_type'] = $foot_type;
  2102. // 友情链接类型'1:图片 2:文字 3:底部';
  2103. $types = Link::where('website_id', $data['website_id'])->pluck('type')->toArray();
  2104. $missingTypes = [];
  2105. if (!in_array(1, $types)) {
  2106. $missingTypes[] = "文字链接";
  2107. }
  2108. if (!in_array(2, $types)) {
  2109. $missingTypes[] = "图片链接";
  2110. }
  2111. if (!in_array(3, $types)) {
  2112. $missingTypes[] = "底部链接";
  2113. }
  2114. if (!empty($missingTypes)) {
  2115. $errorMessage = "请先添加 " . implode(" 和 ", $missingTypes) . "!";
  2116. return Result::error($errorMessage, 0);
  2117. }
  2118. return Result::success($result);
  2119. }
  2120. /**
  2121. * 自助建站-验证编辑网站
  2122. * @return array
  2123. *
  2124. */
  2125. public function checkWebsiteEdit(array $data): array
  2126. {
  2127. $result = WebsiteTemplateInfo::where('website_template_info.website_id', $data['website_id'])->first();
  2128. if (empty($result)) {
  2129. return Result::error("请输入正确的网站id!", 0);
  2130. }
  2131. // 0:未构建 1:未应用 2:已应用
  2132. if($result['status'] == 2){
  2133. return Result::error("此网站的模板正在应用中,暂不可编辑!", 0);
  2134. }
  2135. // 订单状态:1:通过;2:驳回;3:撤回;4:修改;5:过期;6:待审核;7:结束
  2136. $order = Order::where('website_id', $data['website_id'])->where('status', 1)->first();
  2137. if (!empty($order)) {
  2138. return Result::error("此网站的广告位正在使用中,暂不可编辑!", 0);
  2139. }
  2140. $check = $this->checkWebsiteBuild($data);
  2141. if ($check['code'] != 200) {
  2142. return Result::error($check['message'], 0);
  2143. }
  2144. // return Result::success($check);
  2145. if ($result['page_type']) {
  2146. $result['page_type'] = json_decode($result['page_type'], true);
  2147. return Result::success('网站编辑验证通过!');
  2148. } else {
  2149. return Result::error("请先选择网站页面类型!", 0);
  2150. }
  2151. }
  2152. /**
  2153. * 修改网站基础信息
  2154. *
  2155. * @return array
  2156. */
  2157. public function upWebsiteTemplateintel(array $data): array
  2158. {
  2159. $web = Website::where('website.id', $data['website_id'])->first();
  2160. if (empty($web)) {
  2161. return Result::error("请输入正确的网站id!", 0);
  2162. }
  2163. $where = ['website_id' => $data['website_id']];
  2164. $result = WebsiteTemplateInfo::where($where)->first();
  2165. if (empty($result)) {
  2166. return Result::error("请先添加网站基础信息!", 0);
  2167. } else {
  2168. unset($data['website_id']);
  2169. // 删除重复元素
  2170. $data['page_type'] = array_unique($data['page_type']);
  2171. // 重新索引数组
  2172. $data['page_type'] = array_values($data['page_type']);
  2173. // 数组中同时包含值为 1(首页) 和值为 7 (底部导航详情页)的元素
  2174. if (in_array(1, $data['page_type']) && in_array(7, $data['page_type'])) {
  2175. // 将数组转换为 JSON 字符串
  2176. $data['page_type'] = json_encode($data['page_type']) ?? '';
  2177. try {
  2178. $result = WebsiteTemplateInfo::where($where)->update($data);
  2179. } catch (\Exception $e) {
  2180. if ($e->getCode() == 22001) {
  2181. $errorMessage = $e->getMessage();
  2182. return Result::error("请检查表单,某个字段超出了长度限制!");
  2183. } else {
  2184. // 处理其他类型的数据库错误
  2185. return Result::error("修改操作失败: " . $e->getMessage());
  2186. }
  2187. return Result::error("修改失败!", 0);
  2188. }
  2189. } else {
  2190. return Result::error("请先选择首页和单页(详情)!", 0);
  2191. }
  2192. }
  2193. if (empty($result)) {
  2194. return Result::error("修改失败!", 0);
  2195. } else {
  2196. return Result::success($result);
  2197. }
  2198. }
  2199. /**
  2200. * 获取所有网站风格信息
  2201. *
  2202. * @return array
  2203. */
  2204. public function getAllTemplateClass(array $data): array
  2205. {
  2206. $result = TemplateClass::all();
  2207. if (empty($result)) {
  2208. return Result::error("没有查找到相关数据!", 0);
  2209. } else {
  2210. return Result::success($result);
  2211. }
  2212. }
  2213. /**
  2214. * 搜索并获取网站模板信息
  2215. * @param array $data
  2216. * @return array
  2217. */
  2218. public function getWebsiteTemplateList(array $data): array
  2219. {
  2220. $website = Website::where('website.id', $data['website_id'])->first();
  2221. if (empty($website)) {
  2222. return Result::error("请输入正确的网站id!", 0);
  2223. } else {
  2224. $page_type = WebsiteTemplateInfo::where('website_id', $data['website_id'])->select('page_type')->first();
  2225. if (empty($page_type)) {
  2226. return Result::error("此网站还未添加基础信息!", 0);
  2227. } else {
  2228. $where = json_decode($page_type['page_type'], true);
  2229. // $where = $data["page_type"];
  2230. if (isset($data['template_class_id']) && !empty($data['template_class_id'])) {
  2231. $template_class = TemplateClass::where('id', $data['template_class_id'])->first();
  2232. if (empty($template_class)) {
  2233. return Result::error("请输入正确的模板风格id!", 0);
  2234. } else {
  2235. // 获取指定风格下的模板
  2236. $rep = Template::where('template_class_id', $data['template_class_id'])
  2237. ->where(function ($query) use ($where) {
  2238. foreach ($where as $value) {
  2239. $query->whereJsonContains('template_img', ['value' => $value]);
  2240. }
  2241. })
  2242. ->limit($data['pageSize'])
  2243. ->offset(($data['page'] - 1) * $data['pageSize'])
  2244. ->orderBy("template.updated_at", "desc")
  2245. ->get();
  2246. $count = Template::where('template_class_id', $data['template_class_id'])
  2247. ->where(function ($query) use ($where) {
  2248. foreach ($where as $value) {
  2249. $query->whereJsonContains('template_img', ['value' => $value]);
  2250. }
  2251. })->count();
  2252. }
  2253. } else {
  2254. //获取所有模板
  2255. $rep = Template::where(function ($query) use ($where) {
  2256. foreach ($where as $value) {
  2257. $query->whereJsonContains('template_img', ['value' => $value]);
  2258. }
  2259. })
  2260. ->limit($data['pageSize'])
  2261. ->offset(($data['page'] - 1) * $data['pageSize'])
  2262. ->orderBy("template.updated_at", "desc")
  2263. ->get();
  2264. $count = Template::where(function ($query) use ($where) {
  2265. foreach ($where as $value) {
  2266. $query->whereJsonContains('template_img', ['value' => $value]);
  2267. }
  2268. })->count();
  2269. }
  2270. if (empty($rep) || $rep->count() == 0) {
  2271. return Result::error("没有查找到相关数据!", 0);
  2272. } else {
  2273. // 过滤 template_img 字段 只获取 基础信息中 包含的模板图片
  2274. // $rep->each(function ($item) use ($where) {
  2275. // $template_img = json_decode($item->template_img, true);
  2276. // if(is_array($template_img)){
  2277. // $filtered_img = array_filter($template_img, function ($img) use ($where) {
  2278. // return isset($img['value']) && in_array($img['value'], $where);
  2279. // });
  2280. // }
  2281. // $item->template_img = $filtered_img;
  2282. // });
  2283. // $result = [
  2284. // "rows" => $rep->toArray(),
  2285. // "count" => $count
  2286. // ];
  2287. $rep->each(function ($item) use ($where) {
  2288. $template_img = json_decode($item->template_img, true);
  2289. if (is_array($template_img)) {
  2290. $filtered_img = array_filter($template_img, function ($img) use ($where) {
  2291. return isset($img['value']) && in_array($img['value'], $where);
  2292. });
  2293. // 对过滤后的数组进行重新排序
  2294. $sorted_img = array_values($filtered_img);
  2295. $item->template_img = $sorted_img;
  2296. } else {
  2297. $item->template_img = []; // 如果无法解码为数组,则设置为空数组
  2298. }
  2299. });
  2300. $result = [
  2301. "rows" => $rep->toArray(),
  2302. "count" => $count,
  2303. ];
  2304. }
  2305. }
  2306. }
  2307. return Result::success($result);
  2308. }
  2309. /**
  2310. * 添加网站模板
  2311. * @param array $data
  2312. */
  2313. public function addWebsiteTemplateclassintel(array $data): array
  2314. {
  2315. $template = Template::where('id', $data['template_id'])->first();
  2316. $web = Website::where('id', $data['website_id'])->first();
  2317. if (empty($template)) {
  2318. return Result::error("请输入正确的模板id", 0);
  2319. }
  2320. if (empty($web)) {
  2321. return Result::error("请输入正确的网站id", 0);
  2322. }
  2323. $result = WebsiteTemplateInfo::where('website_id', $data['website_id'])->update(['template_id' => $data['template_id'], 'action_id' => 2]);
  2324. if (empty($result)) {
  2325. return Result::error("添加失败", 0);
  2326. } else {
  2327. return Result::success($result);
  2328. }
  2329. }
  2330. /**
  2331. * 获取网站模板信息
  2332. * @param array $data
  2333. */
  2334. public function getWebsiteTemplateclassintel(array $data): array
  2335. {
  2336. // return Result::success($data);
  2337. $template = WebsiteTemplateInfo::where('website_id', $data['website_id'])->first();
  2338. if (empty($template)) {
  2339. return Result::error("请输入正确的搭建网站id", 0);
  2340. }
  2341. $page_type = json_decode($template['page_type'], true);
  2342. // 获取指定网站下的基础信息和模板及风格信息
  2343. $result = WebsiteTemplateInfo::where([
  2344. ['website_template_info.website_id', $data['website_id']],
  2345. ['website_template_info.template_id', '!=', null],
  2346. ])
  2347. ->leftJoin('template', 'template.id', 'website_template_info.template_id')
  2348. ->leftJoin('template_class', 'template_class.id', 'template.template_class_id')
  2349. ->where(function ($query) use ($page_type) {
  2350. // 假设 $data['page_type'] 是一个数组,包含需要匹配的 page_type 值
  2351. foreach ($page_type as $pageType) {
  2352. $query->orWhereJsonContains('template.template_img', ['value' => $pageType]);
  2353. }
  2354. })
  2355. ->select(
  2356. 'template.template_name',
  2357. 'template.template_img',
  2358. 'template.id as tid',
  2359. 'template_class.name',
  2360. 'template_class.id as class_id',
  2361. 'website_template_info.page_type',
  2362. 'website_template_info.website_id'
  2363. )
  2364. ->first();
  2365. if (empty($result)) {
  2366. return Result::error("没有查找到相关数据", 0);
  2367. }
  2368. // return Result::success($result);
  2369. // 过滤 template_img 字段 只获取 基础信息中 包含的模板图片
  2370. $template_img = $result['template_img'] !== null ? json_decode($result['template_img'], true) : [];
  2371. $page_type = $result['page_type'] !== null ? json_decode($result['page_type'], true) : [];
  2372. foreach ($template_img as $key => $value) {
  2373. if (!in_array($value['value'], $page_type)) {
  2374. unset($template_img[$key]);
  2375. }
  2376. }
  2377. // return Result::success($result);
  2378. $result['template_img'] = array_values($template_img);
  2379. $result['page_type'] = $page_type;
  2380. // $templateList = $this->getWebsiteTemplateList($data);
  2381. // $count = $templateList['data']['count']??'';
  2382. // $pages = $count / $data['pageSize'];
  2383. // $found = false;
  2384. // while ($pages && !$found) {
  2385. // $templates = $this->getWebsiteTemplateList($pages,$data['pageSize']);
  2386. // $index = array_search($template['template_id'], array_column($templates['rows'], 'id'));
  2387. // if ($index !== false) {
  2388. // $found = true;
  2389. // $result['page'] = $pages;
  2390. // $pages = 0;
  2391. // // echo "查询到的 template 在第 $page 页";
  2392. // }
  2393. // $pages--;
  2394. // }
  2395. return Result::success($result);
  2396. }
  2397. /**
  2398. * 获取网站模板下的板块信息
  2399. * @param array $data
  2400. */
  2401. public function getWebsiteSectorList(array $data): array
  2402. {
  2403. $website = Website::where('id', $data['website_id'])->first();
  2404. if (empty($website)) {
  2405. return Result::error("请输入正确的网站id", 0);
  2406. }
  2407. $template = WebsiteTemplateInfo::where('website_id', $data['website_id'])->first();
  2408. if (empty($template['template_id'])) {
  2409. return Result::error("请先添加网站模板", 0);
  2410. }
  2411. $query = Sector::where('template_id', $template['template_id']);
  2412. if ($query->count() == 0) {
  2413. return Result::error("没有查找到相关板块数据", 0);
  2414. } elseif ($query->count() == 1) {
  2415. $sector = $query->first();
  2416. } else {
  2417. $sector = $query->get();
  2418. }
  2419. $result['page_type'] = $template['page_type'];
  2420. $result['tid'] = $template['template_id'];
  2421. $result = [
  2422. "tid" => $template['template_id'],
  2423. "page_type" => $template['page_type'],
  2424. "sector" => $sector,
  2425. ];
  2426. return Result::success($result);
  2427. }
  2428. // 自助建站---------------fr---------------
  2429. // 网站底基础信息--fr-------------------
  2430. /**
  2431. * 添加网站底基础信息
  2432. * @param array $data
  2433. */
  2434. public function addWebFootInfo(array $data): array
  2435. {
  2436. $website = Website::where('id', $data['website_id'])->first();
  2437. if (empty($website)) {
  2438. return Result::error("请输入正确的网站id!", 0);
  2439. }
  2440. $info = WebsiteTemplateInfo::where('website_id', $data['website_id'])->first();
  2441. if (!empty($info)) {
  2442. return Result::error("该网站已经添加过了!", 0);
  2443. }
  2444. $result = WebsiteTemplateInfo::where('website_id', $data['website_id'])->insertGetId($data);
  2445. if (empty($result)) {
  2446. return Result::error("请先添加网站基础信息!", 0);
  2447. } else {
  2448. return Result::success($result);
  2449. }
  2450. }
  2451. /**
  2452. * 获取网站底基础信息
  2453. * @param array $data
  2454. */
  2455. public function getWebFootInfo(array $data): array
  2456. {
  2457. $website = Website::where('id', $data['website_id'])->first();
  2458. if (empty($website)) {
  2459. return Result::error("请输入正确的网站id!", 0);
  2460. }
  2461. $result = WebsiteTemplateInfo::where('website_id', $data['website_id'])->first();
  2462. if (empty($result)) {
  2463. return Result::error("请先添加网站基础信息!", 0);
  2464. }
  2465. return Result::success($result);
  2466. }
  2467. /**
  2468. * 修改网站底基础信息
  2469. * @param array $data
  2470. */
  2471. public function upWebFootInfo(array $data): array
  2472. {
  2473. // return Result::success($data);
  2474. $website = Website::where('id', $data['website_id'])->first();
  2475. if (empty($website)) {
  2476. return Result::error("请输入正确的网站id!", 0);
  2477. }
  2478. $web = $data['website_id'];
  2479. unset($data['website_id']);
  2480. $where = ['website_id' => $web];
  2481. // return Result::success($data);
  2482. $result = WebsiteTemplateInfo::where($where)->first();
  2483. if (empty($result)) {
  2484. $data['website_id'] = $web;
  2485. $result = WebsiteTemplateInfo::insertGetId($data);
  2486. // return Result::error("请先添加网站基础信息!",0);
  2487. } else {
  2488. $result = WebsiteTemplateInfo::where($where)->update($data);
  2489. }
  2490. // $where = ['website_id'=>$data['website_id']];
  2491. // unset($data['website_id']);
  2492. // $result = WebsiteTemplateInfo::updateOrInsert($where, $data);
  2493. if (empty($result)) {
  2494. return Result::error("修改失败!", 0);
  2495. }
  2496. return Result::success($result);
  2497. }
  2498. /*
  2499. * 获取父级/子级栏目------路由
  2500. * @param array $data
  2501. * @return array
  2502. * */
  2503. public function getWebsiteParentCategory(array $data): array
  2504. {
  2505. // return Result::success($data);
  2506. if (isset($data['website_id']) && !empty($data['website_id'])) {
  2507. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  2508. }
  2509. if (empty($website)) {
  2510. return Result::error("暂无该网站", 0);
  2511. }
  2512. // 在 Hyperf 中,查询构建器(Builder)没有 `map` 方法,`map` 方法是集合(Collection)的方法。
  2513. // 因此,需要先调用 `get()` 方法获取查询结果集合,再使用 `map` 方法进行处理。
  2514. $category['parent'] = WebsiteCategory::where('website_id', $data['website_id'])
  2515. ->where('pid', 0)
  2516. ->selectRaw("category_id as cid, alias as name, CONCAT('/', '', aLIas_pinyin, '/') as path")
  2517. ->get() // 添加 get() 方法获取结果集合
  2518. ->all();
  2519. // 提前查询所有父级栏目,避免在 map 中多次查询
  2520. // 提前查询所有父级栏目信息并以 category_id 作为键存储
  2521. $parentCategories = WebsiteCategory::where('website_id', $data['website_id'])
  2522. ->where('pid', 0)
  2523. ->select('category_id', 'aLIas_pinyin')
  2524. ->get()
  2525. ->keyBy('category_id');
  2526. // 直接查询子栏目信息
  2527. $child = WebsiteCategory::where('website_id', $data['website_id'])
  2528. ->where('pid', '!=', 0)
  2529. ->select('alias', 'category_id', 'aLIas_pinyin', 'pid')
  2530. ->get();
  2531. // 使用集合的 map 方法处理子栏目信息
  2532. $category['child'] = $child->map(function ($item) use ($parentCategories) {
  2533. $alias = $item->alias;
  2534. $category_id = $item->category_id;
  2535. $aLIas_pinyin = $item->aLIas_pinyin;
  2536. $parent = $parentCategories->get($item->pid);
  2537. $parentAlias = $parent ? $parent->aLIas_pinyin : '';
  2538. $result = [
  2539. 'name' => $alias,
  2540. 'cid' => $category_id
  2541. ];
  2542. if (!empty($aLIas_pinyin) && !empty($parentAlias)) {
  2543. $result['path'] = "/{$parentAlias}/{$aLIas_pinyin}/";
  2544. }
  2545. return $result;
  2546. })->values()->all();
  2547. if (empty($category)) {
  2548. return Result::error("暂无此导航", 0);
  2549. }
  2550. return Result::success($category);
  2551. }
  2552. /**
  2553. * 获取网站栏目信息
  2554. * @param array $data
  2555. */
  2556. public function getWebsiteFootAll(array $data): array
  2557. {
  2558. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  2559. if (empty($website)) {
  2560. return Result::error("暂无该网站", 0);
  2561. }
  2562. // 1:图片 2:文字 3:底部
  2563. $result['foot_cate'] = FooterCategory::where('website_id', $data['website_id'])->get()->all();
  2564. $result['link_img'] = Link::where('website_id', $data['website_id'])->where('type', 1)->where('status', 1)->limit($data['link_imgnum'])->orderBy('sort')->get()->all();
  2565. $result['link_text'] = Link::where('website_id', $data['website_id'])->where('type', 2)->where('status', 1)->limit($data['link_textnum'])->orderBy('sort')->get()->all();
  2566. $result['link_foot'] = Link::where('website_id', $data['website_id'])->where('type', 3)->where('status', 1)->limit($data['link_footnum'])->orderBy('sort')->get()->all();
  2567. $result['foot_info'] = WebsiteTemplateInfo::where('website_id', $data['website_id'])->first();
  2568. if (empty($result)) {
  2569. return Result::error("暂无此网站信息", 0);
  2570. }
  2571. return Result::success($result);
  2572. }
  2573. /**
  2574. * 获取网站顶部信息
  2575. * @param array $data
  2576. */
  2577. public function getWebsiteHead(array $data): array
  2578. {
  2579. $result = Website::where('id', $data['website_id'])->where('status', 1)->select('website_name', 'logo')->first();
  2580. if (empty($result)) {
  2581. return Result::error("暂无该网站", 0);
  2582. }
  2583. return Result::success($result);
  2584. }
  2585. /**
  2586. * 路由匹配
  2587. * @param array $data
  2588. */
  2589. public function getWebsiteRoute(array $data): array
  2590. {
  2591. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  2592. if (empty($website)) {
  2593. return Result::error("暂无该网站", 0);
  2594. }
  2595. if (isset($data['pinyin']) && !empty($data['pinyin'])) {
  2596. $result = WebsiteCategory::where('website_category.website_id', $data['website_id'])
  2597. ->where('website_category.aLIas_pinyin', $data['pinyin'])
  2598. ->leftJoin('website_category as pc', function ($join) use ($data) {
  2599. $join->on('pc.pid', '=', 'website_category.category_id')
  2600. ->where('pc.website_id', '=', $data['website_id']);
  2601. })
  2602. ->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'))
  2603. ->first();
  2604. }
  2605. if (isset($data['foot_pinyin']) && !empty($data['foot_pinyin'])) {
  2606. $result = FooterCategory::where('website_id', $data['website_id'])->where('name_pinyin', $data['foot_pinyin'])->first(['id']);
  2607. }
  2608. if (!isset($result) || empty($result)) {
  2609. return Result::error("暂无该导航", 0);
  2610. }
  2611. return Result::success($result);
  2612. }
  2613. /**
  2614. * 获取网站栏目信息
  2615. * @param array $data
  2616. */
  2617. public function getWebsiteAllinfo(array $data): array
  2618. {
  2619. $website = Website::where('id', $data['website_id'])->where('status', 1)->first();
  2620. if (empty($website)) {
  2621. return Result::error("暂无该网站", 0);
  2622. }
  2623. if (isset($data['website_id']) && !empty($data['website_id'])) {
  2624. $website_head = Website::where('id', $data['website_id'])
  2625. ->where('status', 1)
  2626. ->select(
  2627. 'id',
  2628. 'website_name',
  2629. 'logo',
  2630. 'title',
  2631. 'keywords',
  2632. 'description',
  2633. 'suffix',
  2634. 'website_url',
  2635. 'ad_key',
  2636. 'api_url',
  2637. 'login_url',
  2638. 'weblog_url'
  2639. )
  2640. ->first();
  2641. if (empty($website_head)) {
  2642. return Result::error("找不到网站", 0);
  2643. }
  2644. } else {
  2645. return Result::error("参数错误", 0);
  2646. }
  2647. $website_foot['foot_info'] = WebsiteTemplateInfo::where('website_id', $data['website_id'])->first();
  2648. if (empty($website_foot)) {
  2649. return Result::error("暂无底部基础信息", 0);
  2650. }
  2651. $website_head['website_url'] = $website_head['website_url'] ? json_decode($website_head['website_url']) : [];
  2652. $result['website_head'] = $website_head;
  2653. $result['website_foot'] = $website_foot;
  2654. // return Result::success($result);
  2655. // 1:图片 2:文字 3:底部
  2656. $result['website_foot']['foot_cate'] = FooterCategory::where('website_id', $data['website_id'])->get()->all();
  2657. $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();
  2658. $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();
  2659. $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();
  2660. if (empty($result)) {
  2661. return Result::error("暂无此网站信息", 0);
  2662. }
  2663. return Result::success($result);
  2664. }
  2665. //20250212 网站标识
  2666. public function addWebsiteGroup(array $data): array
  2667. {
  2668. //判斷name是不是重复
  2669. $websiteGroupInfo = WebsiteGroup::query()->where('name', $data['name'])->first();
  2670. if (!empty($websiteGroupInfo)) {
  2671. return Result::error("网站标识重复", 0);
  2672. }
  2673. //添加信息
  2674. $result = WebsiteGroup::insertGetId($data);
  2675. var_dump($result);
  2676. if (empty($result)) {
  2677. return Result::error("创建失败", 0);
  2678. } else {
  2679. return Result::success($result);
  2680. }
  2681. }
  2682. public function getWebsiteGroupList(array $data): array
  2683. {
  2684. $where = [];
  2685. if (isset($data['name']) && !empty($data['name'])) {
  2686. array_push($where, ['website_group.name', 'like', '%' . $data['name'] . '%']);
  2687. }
  2688. $result = WebsiteGroup::where($where)
  2689. ->limit($data['pageSize'])->orderBy("id", "desc")->offset(($data['page'] - 1) * $data['pageSize'])
  2690. ->get();
  2691. foreach ($result as $websiteGroup) {
  2692. $webIds = json_decode($websiteGroup->web_ids, true);
  2693. $websites = Website::whereIn('id', $webIds)->get();
  2694. $websiteNames = $websites->pluck('website_name', 'id')->toArray();
  2695. $websiteGroup->website_names = $websiteNames;
  2696. $websiteGroup->website_names1 = implode(',', array_values($websiteNames));
  2697. }
  2698. $count = WebsiteGroup::where($where)->count();
  2699. if (empty($result)) {
  2700. return Result::error("没有数据", 0);
  2701. }
  2702. return Result::success(['list' => $result->toArray(), 'count' => $count]);
  2703. }
  2704. public function getWebsiteGroupInfo(array $data): array
  2705. {
  2706. $websiteInfo = WebsiteGroup::query()->where('id', $data['id'])->first();
  2707. $webIds = json_decode($websiteInfo->web_ids, true);
  2708. $websites = Website::whereIn('id', $webIds)->get();
  2709. $websiteNames = $websites->pluck('website_name', 'id')->toArray();
  2710. $websiteInfo->website_names = $websiteNames;
  2711. $websiteInfo->website_names1 = implode(',', array_values($websiteNames));
  2712. if (empty($websiteInfo)) {
  2713. return Result::error("找不到URL", 0);
  2714. }
  2715. return Result::success($websiteInfo->toArray());
  2716. }
  2717. public function updateWebsiteGroup(array $data): array
  2718. {
  2719. $where = [
  2720. 'id' => $data['id'],
  2721. ];
  2722. $insertData = [
  2723. 'name' => $data['name'],
  2724. 'web_ids' => $data['web_ids'],
  2725. ];
  2726. //判斷name是不是重复
  2727. $websiteGroupInfo = WebsiteGroup::query()->where('name', $data['name'])->first();
  2728. if (!empty($websiteGroupInfo) && $websiteGroupInfo->id != $data['id']) {
  2729. return Result::error("网站标识重复", 0);
  2730. }
  2731. $result = WebsiteGroup::where($where)->update($insertData);
  2732. var_dump($result, '------更新');
  2733. if (empty($result)) {
  2734. return Result::error("更新失败", 0);
  2735. } else {
  2736. return Result::success();
  2737. }
  2738. }
  2739. public function deleteWebsiteGroup(array $data): array
  2740. {
  2741. $where = [
  2742. 'id' => $data['id'],
  2743. ];
  2744. //看看user表是不是有这个id
  2745. $userGroup = User::query()->where('sszq', $data['id'])->first();
  2746. if (!empty($userGroup)) {
  2747. return Result::error("有用户在使用该网站标识,不能删除", 0);
  2748. }
  2749. $result = WebsiteGroup::where($where)->delete();
  2750. if (empty($result)) {
  2751. return Result::error("删除失败", 0);
  2752. } else {
  2753. return Result::success();
  2754. }
  2755. }
  2756. public function getWebsiteNavList(array $data): array
  2757. {
  2758. $data['type'] = isset($data['type']) ? $data['type'] : 1;
  2759. $where = [];
  2760. if (isset($data['website_id']) && !empty($data['website_id'])) {
  2761. array_push($where, ['website_id', '=', $data['website_id']]);
  2762. }
  2763. if (isset($data['pid'])) {
  2764. array_push($where, ['pid', '=', $data['pid']]);
  2765. }
  2766. if (isset($data['type']) && !empty($data['type'])) {
  2767. array_push($where, ['type', '=', $data['type']]);
  2768. }
  2769. // 根据站点和type获取websiteCategory 中的id
  2770. $websiteCategoryids = WebsiteCategory::query()
  2771. ->where('website_id', '=', $data['website_id'])
  2772. ->where('type', '=', $data['type'])
  2773. ->pluck('category_arr_id')->toArray();
  2774. var_dump($websiteCategoryids, '------获取websiteCategory 中的id');
  2775. //合并去重
  2776. $category_ids = [];
  2777. foreach ($websiteCategoryids as $key => $value) {
  2778. $v = json_decode($value, true);
  2779. $category_ids = array_unique(array_merge($category_ids, $v));
  2780. }
  2781. // var_dump($category_ids, '------获取websiteCategory 中的id');
  2782. //根据pid取出所有的websiteCategory 中的id
  2783. $list = WebsiteCategory::query()
  2784. ->where('website_id', '=', $data['website_id'])
  2785. ->where('is_url', '!=', 1)
  2786. ->where('pid', '=', $data['pid'])
  2787. ->whereIn('category_id', $category_ids)
  2788. ->get();
  2789. if (empty($list)) {
  2790. return Result::error("获取失败", 0);
  2791. } else {
  2792. return Result::success($list);
  2793. }
  2794. }
  2795. // 20250307 根据网站标识获和导航获取站点
  2796. public function getWebsiteNavPoolSite(array $data): array
  2797. {
  2798. $where = [];
  2799. if (isset($data['category_id']) && !empty($data['category_id'])) {
  2800. array_push($where, ['category_id', '=', $data['category_id']]);
  2801. }
  2802. $list = WebsiteCategory::query()->where($where)
  2803. ->leftJoin('website', 'website.id', '=', 'website_category.website_id')
  2804. ->select('website_category.*', 'website.website_name')
  2805. ->distinct()
  2806. ->get();
  2807. if (empty($list)) {
  2808. return Result::error("获取失败", 0);
  2809. } else {
  2810. return Result::success($list);
  2811. }
  2812. }
  2813. public function getWebsiteNavPool(array $data): array
  2814. {
  2815. // 初始化查询条件数组
  2816. $query = WebsiteCategory::query();
  2817. // 如果传入了 websiteids,则添加到查询条件中
  2818. if (isset($data['websiteids']) && !empty($data['websiteids'])) {
  2819. $query->whereIn('website_id', $data['websiteids']);
  2820. }
  2821. // 如果传入了 pid,则添加到查询条件中
  2822. if (isset($data['pid'])) {
  2823. $query->where('pid', '=', $data['pid']);
  2824. }
  2825. // 执行查询 唯一性 id
  2826. $list = $query->distinct()->get();
  2827. // 根据查询结果返回相应的结果
  2828. if ($list->isEmpty()) {
  2829. return Result::error("获取失败", 0);
  2830. } else {
  2831. return Result::success($list->toArray());
  2832. }
  2833. }
  2834. /**
  2835. *
  2836. * @param array $data
  2837. * @return array
  2838. */
  2839. public function getAllCategory(array $data): array
  2840. {
  2841. $total = Category::count();
  2842. $pageSize = 2000;
  2843. $pages = (int) ceil($total / $pageSize);
  2844. $results = [];
  2845. $concurrency = 5; // 最大并发数
  2846. $running = 0;
  2847. $chan = new \Swoole\Coroutine\Channel($pages);
  2848. for ($i = 0; $i < $pages; $i++) {
  2849. Coroutine::create(function () use ($i, $pageSize, $chan) {
  2850. $offset = $i * $pageSize;
  2851. $data = Category::useIndex('idx_covering')
  2852. ->orderBy('id', 'asc')
  2853. ->select('id', 'name', 'pid')
  2854. ->offset($offset)
  2855. ->limit($pageSize)
  2856. ->get()
  2857. ->toArray();
  2858. $chan->push($data);
  2859. });
  2860. }
  2861. for ($i = 0; $i < $pages; $i++) {
  2862. $res = $chan->pop();
  2863. if (is_array($res)) {
  2864. $results = array_merge($results, $res);
  2865. }
  2866. }
  2867. return Result::success($results);
  2868. }
  2869. /**
  2870. * 修改网站栏目排序
  2871. * @param array $data
  2872. * @return array
  2873. */
  2874. public function upWebsiteCategorySort(array $data): array
  2875. {
  2876. $where = [
  2877. 'website_id' => $data['website_id'],
  2878. 'id' => $data['id'],
  2879. ];
  2880. $result = WebsiteCategory::where($where)->update($data);
  2881. if ($result) {
  2882. return Result::success($result);
  2883. } else {
  2884. return Result::error("更新失败", 0);
  2885. }
  2886. }
  2887. //获取底部导航内容详情
  2888. public function getFooterContentInfo(array $data): array
  2889. {
  2890. $where = [
  2891. "id" => $data['content_id']
  2892. ];
  2893. $result = FooterContent::where($where)->first();
  2894. if ($result) {
  2895. return Result::success($result);
  2896. } else {
  2897. return Result::error("没有数据");
  2898. }
  2899. }
  2900. //获取底部导航内容列表
  2901. public function getFooterContentList(array $data): array
  2902. {
  2903. $where = [
  2904. "fcat_id" => $data['fcat_id'],
  2905. ];
  2906. switch (intval($data['type'])) {
  2907. case 0:
  2908. $result = FooterContent::where($where)->first();
  2909. break;
  2910. case 1:
  2911. $result = FooterContent::where($where)->get();
  2912. break;
  2913. }
  2914. if ($result) {
  2915. return Result::success($result);
  2916. } else {
  2917. return Result::error("没有数据");
  2918. }
  2919. }
  2920. /**
  2921. * 获取底部导航列表
  2922. * @param array $data
  2923. * @return array
  2924. */
  2925. public function getFooterCategoryList(array $data): array
  2926. {
  2927. $where = [
  2928. "website_id" => $data['website_id']
  2929. ];
  2930. $result = FooterCategory::where($where)->get();
  2931. if ($result) {
  2932. return Result::success($result);
  2933. } else {
  2934. return Result::error("没有数据");
  2935. }
  2936. }
  2937. // --自助建站-----------20250522fr----------------------start
  2938. /**
  2939. * 获取网站模板下的板块信息
  2940. * @param array $data
  2941. * @return array
  2942. */
  2943. public function getStaticResourceList(array $data): array
  2944. {
  2945. // return Result::success($data);
  2946. $where = [];
  2947. if (isset($data['img_alias']) && !empty($data['img_alias'])) {
  2948. array_push($where, ['website_img.img_alias', 'like', '%' . $data['img_alias'] . '%']);
  2949. }
  2950. if (isset($data['img_type']) && !empty($data['img_type'])) {
  2951. array_push($where, ['website_img.img_type', '=', $data['img_type']]);
  2952. }
  2953. if (isset($data['website_name']) && !empty($data['website_name'])) {
  2954. $website = Website::where('website_name', 'like', '%' . $data['website_name'] . '%')->first();
  2955. if (empty($website)) {
  2956. return Result::error("没有查找到相关数据", 0);
  2957. } else {
  2958. array_push($where, ['website_img.website_id', '=', $website['id']]);
  2959. }
  2960. }
  2961. // return Result::success($where);
  2962. $query = WebsiteImg::when(!empty($where), function ($query) use ($where) {
  2963. $query->where($where);
  2964. })
  2965. ->orderBy('updated_at', 'desc');
  2966. $count = $query->count();
  2967. $row = $query->leftJoin('website', 'website.id', '=', 'website_img.website_id')
  2968. ->select('website_img.*', 'website.website_name')
  2969. ->limit($data['pageSize'])
  2970. ->offset(($data['page'] - 1) * $data['pageSize'])
  2971. ->get();
  2972. if (empty($row)) {
  2973. return Result::error("没有查找到相关数据", 0);
  2974. } else {
  2975. $result = [
  2976. 'row' => $row,
  2977. 'count' => $count,
  2978. ];
  2979. }
  2980. return Result::success($result);
  2981. }
  2982. /**
  2983. * 添加网站模板下的板块信息
  2984. * @param array $data
  2985. */
  2986. public function addStaticResource(array $data): array
  2987. {
  2988. // $file = $data['img_url']->file('image');
  2989. // $size = $file->getSize();
  2990. $img_data = [
  2991. 'website_id' => $data['website_id'] ?? 0,
  2992. 'img_alias' => $data['img_alias'] ?? '',
  2993. 'img_url' => $data['img_url'],
  2994. 'img_size' => $data['img_size'],
  2995. ];
  2996. $img = WebsiteImg::insertGetId($img_data);
  2997. if (empty($img)) {
  2998. return Result::error("添加失败", 0);
  2999. }
  3000. $img_id['id'] = $img;
  3001. $url = WebsiteImg::where($img_id)->value('img_url');
  3002. // 1. 分割路径部分(以 / 为分隔符)
  3003. $pathSegments = explode('/', parse_url($url, PHP_URL_PATH));
  3004. // 2. 取最后一个元素作为文件名
  3005. $fileName = end($pathSegments); // 1743041040714597.jpg
  3006. // 3. 分割文件名获取扩展名
  3007. $fileParts = explode('.', $fileName);
  3008. $fileType = end($fileParts); // jpg
  3009. $img_datas = [
  3010. 'img_type' => $fileType,
  3011. 'name' => $fileName
  3012. ];
  3013. $up_img = WebsiteImg::where($img_id)->update($img_datas);
  3014. if (empty($up_img)) {
  3015. return Result::error("修改失败", 0);
  3016. }
  3017. return Result::success($up_img);
  3018. // 将字节转换为更友好的单位
  3019. // $friendlySize = $this->formatFileSize($size);
  3020. // $data['img_size'] = $friendlySize;
  3021. }
  3022. /**
  3023. * 修改网站模板下的板块信息
  3024. * @param array $data
  3025. */
  3026. public function delStaticResource(array $data): array
  3027. {
  3028. $where = [
  3029. 'id' => $data['id'],
  3030. ];
  3031. $result = WebsiteImg::where($where)->delete();
  3032. if (empty($result)) {
  3033. return Result::error("修改失败", 0);
  3034. }
  3035. return Result::success($result);
  3036. }
  3037. /**
  3038. * 获取尺寸列表
  3039. * @param array $data
  3040. */
  3041. public function getSizeList(array $data): array
  3042. {
  3043. $where = [];
  3044. if (isset($data['width']) && !empty($data['width'])) {
  3045. array_push($where, ['width', 'like', '%' . $data['width'] . '%']);
  3046. }
  3047. if (isset($data['height']) && !empty($data['height'])) {
  3048. array_push($where, ['height', 'like', '%' . $data['height'] . '%']);
  3049. }
  3050. $query = Size::when($where, function ($query) use ($where) {
  3051. $query->where($where);
  3052. })
  3053. ->orderBy('updated_at', 'desc');
  3054. $count = $query->count();
  3055. $rep = $query
  3056. ->offset(($data['page'] - 1) * $data['pageSize'])
  3057. ->limit($data['pageSize'])
  3058. ->get();
  3059. $result = [
  3060. 'row' => $rep,
  3061. 'count' => $count,
  3062. ];
  3063. if (empty($result)) {
  3064. return Result::error("获取失败", 0);
  3065. } else {
  3066. return Result::success($result);
  3067. }
  3068. }
  3069. /**
  3070. * 添加尺寸
  3071. * @param array $data
  3072. */
  3073. public function addSize(array $data): array
  3074. {
  3075. $size = Size::where('width', $data['width'])->where('height', $data['height'])->first();
  3076. if (!empty($size)) {
  3077. return Result::error("尺寸已存在", 0);
  3078. }
  3079. $result = Size::insertGetId($data);
  3080. if (empty($result)) {
  3081. return Result::error("添加失败", 0);
  3082. }
  3083. return Result::success($result);
  3084. }
  3085. /**
  3086. * 删除尺寸
  3087. * @param array $data
  3088. */
  3089. public function delSize(array $data): array
  3090. {
  3091. $where = [
  3092. 'id' => $data['id'],
  3093. ];
  3094. $result = Size::where($where)->delete();
  3095. if (empty($result)) {
  3096. return Result::error("删除失败", 0);
  3097. }
  3098. return Result::success($result);
  3099. }
  3100. /**
  3101. * 修改尺寸
  3102. * @param array $data
  3103. */
  3104. public function upSize(array $data): array
  3105. {
  3106. $where = [
  3107. 'id' => $data['id'],
  3108. ];
  3109. $size = Size::where('id', '!=', $data['id'])->where('width', $data['width'])->where('height', $data['height'])->first();
  3110. if (!empty($size)) {
  3111. return Result::error("尺寸已存在", 0);
  3112. }
  3113. $result = Size::where($where)->update($data);
  3114. if (empty($result)) {
  3115. return Result::error("修改失败", 0);
  3116. }
  3117. return Result::success($result);
  3118. }
  3119. /**
  3120. * 获取尺寸详情
  3121. * @param array $data
  3122. */
  3123. public function getSizeInfo(array $data): array
  3124. {
  3125. $where = [
  3126. 'id' => $data['id'],
  3127. ];
  3128. $result = Size::where($where)->first();
  3129. if (empty($result)) {
  3130. return Result::error("获取失败", 0);
  3131. } else {
  3132. return Result::success($result);
  3133. }
  3134. }
  3135. /**
  3136. * 获取网站名称缩写
  3137. * @param array $data
  3138. */
  3139. public function getWebsiteAdkey(array $data): array
  3140. {
  3141. $result = PinyinHelper::getFirstLetter($data['website_name']);
  3142. if (empty($result)) {
  3143. return Result::error("没有数据", 0);
  3144. } else {
  3145. return Result::success($result);
  3146. }
  3147. }
  3148. /**
  3149. * 静态资源管理-修改图片别名
  3150. * @param array $data
  3151. */
  3152. public function upStaticResource(array $data): array
  3153. {
  3154. $id = $data['id'];
  3155. unset($data['id']);
  3156. $result = WebsiteImg::where('id', $id)->update($data);
  3157. if (empty($result)) {
  3158. return Result::error("修改失败", 0);
  3159. }
  3160. return Result::success($result);
  3161. }
  3162. /**
  3163. * 自助建站-修改网站应用状态
  3164. * @param array $data
  3165. */
  3166. public function upWebsiteStatus(array $data): array
  3167. {
  3168. $where = [
  3169. 'website_id' => $data['website_id'],
  3170. ];
  3171. $website_template = WebsiteTemplate::where($where)->first();
  3172. unset($data['website_id']);
  3173. if ($data['status'] == 2) {
  3174. $template_status = 6;
  3175. } else {
  3176. $template_status = 1;
  3177. }
  3178. if (empty($website_template)) {
  3179. return Result::error("网站预制模板获取失败", 0);
  3180. } else {
  3181. Db::beginTransaction();
  3182. try {
  3183. $result['website_template'] = WebsiteTemplate::where($where)->update(['status' => $template_status]);
  3184. if (empty($result['website_template'])) {
  3185. return Result::error("修改网站模板状态失败", 0);
  3186. }
  3187. $result['website_template_info'] = WebsiteTemplateInfo::where($where)->update(['status' => $data['status']]);
  3188. if (empty($result['website_template_info'])) {
  3189. return Result::error("修改网站基础信息状态失败", 0);
  3190. }
  3191. Db::commit();
  3192. return Result::success($result);
  3193. } catch (\Exception $e) {
  3194. Db::rollBack();
  3195. return Result::error($e->getMessage(), 0);
  3196. }
  3197. }
  3198. }
  3199. // --自助建站-----------20250522fr----------------------end
  3200. /**
  3201. * 获取网站白名单路由地址
  3202. * @param array $data
  3203. * @return array
  3204. */
  3205. public function getWhiteRouterList(array $data): array
  3206. {
  3207. // 构建基础查询
  3208. $baseQuery = WhiteRouter::query();
  3209. // 功能名称模糊查询
  3210. if (!empty($data['function_name'])) {
  3211. $baseQuery->where('function_name', 'like', '%' . $data['function_name'] . '%');
  3212. }
  3213. // 网站ID查询 - 使用 JSON_CONTAINS 检查数组中是否包含指定的 website_id
  3214. if (!empty($data['website_id'])) {
  3215. $baseQuery->whereRaw('JSON_CONTAINS(website_id, ?)', [json_encode((int)$data['website_id'])]);
  3216. }
  3217. // 获取总数
  3218. $count = $baseQuery->count();
  3219. // 分页查询
  3220. $result = $baseQuery->orderBy('updated_at', 'desc')
  3221. ->limit($data['pageSize'])
  3222. ->offset(($data['page'] - 1) * $data['pageSize'])
  3223. ->get();
  3224. if (empty($result)) {
  3225. return Result::error("暂无数据", 0);
  3226. }
  3227. // 处理结果,将 website_id 转换为数组并获取对应的网站名称
  3228. $result->transform(function ($item) {
  3229. $websiteIds = json_decode($item->website_id, true);
  3230. $websiteNames = Website::whereIn('id', $websiteIds)
  3231. ->pluck('website_name')
  3232. ->toArray();
  3233. $item->website_names = $websiteNames;
  3234. $item->website_id = $websiteIds; // 将 website_id 转换为数组
  3235. return $item;
  3236. });
  3237. return Result::success([
  3238. 'rows' => $result->toArray(),
  3239. 'count' => $count
  3240. ]);
  3241. }
  3242. /**
  3243. * 添加网站白名单路由地址
  3244. * @param array $data
  3245. * @return array
  3246. */
  3247. public function addWhiteRouter(array $data): array
  3248. {
  3249. // 确保 website_id 是数组
  3250. $websiteIds = is_array($data['website_id']) ? $data['website_id'] : [$data['website_id']];
  3251. // 过滤空值并去重
  3252. $websiteIds = array_filter($websiteIds);
  3253. $websiteIds = array_unique($websiteIds);
  3254. // 将数组中的值转换为整数
  3255. $websiteIds = array_map(function ($value) {
  3256. return (int)$value;
  3257. }, $websiteIds);
  3258. // 转换为 JSON 字符串存储
  3259. $data['website_id'] = json_encode($websiteIds);
  3260. $result = WhiteRouter::insertGetId($data);
  3261. if (empty($result)) {
  3262. return Result::error("添加失败", 0);
  3263. }
  3264. return Result::success($result);
  3265. }
  3266. /**
  3267. * 修改网站白名单路由地址
  3268. * @param array $data
  3269. * @return array
  3270. */
  3271. public function upWhiteRouter(array $data): array
  3272. {
  3273. $where = [
  3274. 'id' => $data['id'],
  3275. ];
  3276. // 确保 website_id 是数组
  3277. $websiteIds = is_array($data['website_id']) ? $data['website_id'] : [$data['website_id']];
  3278. // 过滤空值并去重
  3279. $websiteIds = array_filter($websiteIds);
  3280. $websiteIds = array_unique($websiteIds);
  3281. // 将数组中的值转换为整数
  3282. $websiteIds = array_map(function ($value) {
  3283. return (int)$value;
  3284. }, $websiteIds);
  3285. // 转换为 JSON 字符串存储
  3286. $data['website_id'] = json_encode($websiteIds);
  3287. $result = WhiteRouter::where($where)->update($data);
  3288. if (empty($result)) {
  3289. return Result::error("修改失败", 0);
  3290. }
  3291. return Result::success($result);
  3292. }
  3293. /**
  3294. * 删除网站白名单路由地址
  3295. * @param array $data
  3296. * @return array
  3297. */
  3298. public function delWhiteRouter(array $data): array
  3299. {
  3300. $where = [
  3301. 'id' => $data['id'],
  3302. ];
  3303. $result = WhiteRouter::where($where)->delete();
  3304. if (empty($result)) {
  3305. return Result::error("删除失败", 0);
  3306. }
  3307. return Result::success($result);
  3308. }
  3309. /**
  3310. * 获取网站白名单路由地址详情
  3311. * @param array $data
  3312. * @return array
  3313. */
  3314. public function getWhiteRouterInfo(array $data): array
  3315. {
  3316. $where = [
  3317. 'id' => $data['id'],
  3318. ];
  3319. $result = WhiteRouter::where($where)->first();
  3320. if (empty($result)) {
  3321. return Result::error("没有查找到相关数据", 0);
  3322. }
  3323. // 将 website_id 从 JSON 字符串转换为数组
  3324. $result->website_id = json_decode($result->website_id, true);
  3325. return Result::success($result);
  3326. }
  3327. /**
  3328. * 克隆网站
  3329. * @param array $data
  3330. * @return array
  3331. */
  3332. public function cloneWebsite(array $data): array
  3333. {
  3334. DB::beginTransaction();
  3335. try {
  3336. // 获取原始网站信息
  3337. $originalWebsite = Website::find($data['website_id']);
  3338. if (!$originalWebsite) {
  3339. return Result::error("找不到该网站", 0);
  3340. }
  3341. // 提取基础名称(去除已有 _copy 或 _copy_xxx)
  3342. $baseName = preg_replace('/_copy(\d+)?$/', '', $originalWebsite->website_name);
  3343. // 查询当前系统中已存在的克隆名称数量
  3344. $count = Website::where('website_name', 'like', $baseName . '_copy%')
  3345. ->orWhere('website_name', $baseName)
  3346. ->count();
  3347. // 构造新名称:第一次是 _copy,之后是 _copy_1, _copy_2 ...
  3348. $newName = $baseName . ($count === 0 ? '_copy' : '_copy_' . $count);
  3349. // 创建克隆网站实例
  3350. $clone_website = $originalWebsite->replicate();
  3351. $clone_website->website_name = $newName;
  3352. $clone_website->save();
  3353. $clone_website->website_url = "[]";
  3354. $clone_website->save();
  3355. // var_dump("返回值:",$clone_website->id);
  3356. //克隆网站基础信息 website_template_info website_category
  3357. $resultWebsiteTemplateInfo = WebsiteTemplateInfo::where(['website_id' => $data['website_id']])->first();
  3358. $clone_website_template_info = $resultWebsiteTemplateInfo->replicate();
  3359. $clone_website_template_info->website_id = $clone_website->id;
  3360. $clone_website_template_info->save();
  3361. //克隆网站导航 获取原始 website_id 对应的所有 WebsiteCategory 记录
  3362. $originalCategories = WebsiteCategory::where('website_id', $data['website_id'])->get();
  3363. // 克隆网站后的新 ID(假设 $clone_website->id 已存在)
  3364. $newWebsiteId = $clone_website->id;
  3365. // 遍历每条记录并克隆
  3366. foreach ($originalCategories as $category) {
  3367. // 使用 replicate() 方法创建模型副本(不包含主键)
  3368. $clonedCategory = $category->replicate();
  3369. // 修改外键字段指向新网站 ID
  3370. $clonedCategory->website_id = $newWebsiteId;
  3371. // 保存克隆后的记录到数据库
  3372. $clonedCategory->save();
  3373. }
  3374. //克隆友情链接 Link 对应的是多个
  3375. $originalLinks = Link::where('website_id', $data['website_id'])->get();
  3376. foreach ($originalLinks as $link) {
  3377. // 使用 replicate() 方法创建模型副本(不包含主键)
  3378. $clonedLink = $link->replicate();
  3379. // 修改外键字段指向新网站 ID
  3380. $clonedLink->website_id = $newWebsiteId;
  3381. // 保存克隆后的记录到数据库
  3382. $clonedLink->save();
  3383. }
  3384. //克隆网站底部信息 footer_category 表 和footer_content 表 footer_category.id = footer_content.fcat_id 都是一对多关系
  3385. $originalFooterCategories = FooterCategory::where('website_id', $data['website_id'])->get();
  3386. foreach ($originalFooterCategories as $footerCategory) {
  3387. $clonedFooterCategory = $footerCategory->replicate();
  3388. $clonedFooterCategory->website_id = $newWebsiteId;
  3389. $clonedFooterCategory->save();
  3390. $originalFooterContents = FooterContent::where('fcat_id', $footerCategory->id)->get();
  3391. foreach ($originalFooterContents as $footerContent) {
  3392. $clonedFooterContent = $footerContent->replicate();
  3393. $clonedFooterContent->fcat_id = $clonedFooterCategory->id;
  3394. $clonedFooterContent->save();
  3395. }
  3396. }
  3397. Db::commit();
  3398. return Result::success([]);
  3399. } catch (\Exception $e) {
  3400. Db::rollBack();
  3401. return Result::error($e->getMessage(), 0);
  3402. }
  3403. }
  3404. /**
  3405. * 更新网站状态
  3406. * @param array $data
  3407. * @return array
  3408. */
  3409. public function updateWebsiteStatus(array $data): array
  3410. {
  3411. try {
  3412. Website::where(["id" => $data['id']])->update(["status" => intval($data['status'])]);
  3413. return Result::success([]);
  3414. } catch (\Exception $e) {
  3415. return Result::error($e->getMessage(), 0);
  3416. }
  3417. }
  3418. /**
  3419. * 删除网站url
  3420. * @param array $data
  3421. * @return array
  3422. */
  3423. public function delWebsiteUrl(array $data): array
  3424. {
  3425. try {
  3426. $wensiteInfo = Website::where(["id" => $data['website_id']])->first();
  3427. if (empty($wensiteInfo)) {
  3428. return Result::error("找不到该网站", 0);
  3429. }
  3430. $websiteUrlArray = [];
  3431. if (!empty($wensiteInfo->website_url)) {
  3432. $decoded = json_decode((string) $wensiteInfo->website_url, true);
  3433. $websiteUrlArray = is_array($decoded) ? $decoded : [];
  3434. }
  3435. // 从数组中按值删除对应的 URL
  3436. $index = array_search($data['website_url'] ?? null, $websiteUrlArray, true);
  3437. if ($index !== false) {
  3438. unset($websiteUrlArray[$index]);
  3439. // 重新索引,保持为连续的 JSON 数组
  3440. $websiteUrlArray = array_values($websiteUrlArray);
  3441. }
  3442. $newWebsiteUrlJson = json_encode($websiteUrlArray, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
  3443. Website::where(["id" => $data['website_id']])->update(["website_url" => $newWebsiteUrlJson]);
  3444. return Result::success([]);
  3445. } catch (\Exception $e) {
  3446. return Result::error($e->getMessage(), 0);
  3447. }
  3448. }
  3449. }