WebsiteService.php 128 KB

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