123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263 |
- <?php
- namespace app\admin\service\common;
- use app\admin\service\Service;
- use app\admin\model\wechat\WechatNews as WechatNewsModel;
- use app\common\models\wechat\WechatNewsArticle as WechatNewsArticleModel;
- class Wechat extends Service {
-
- public static function getContent($data){
- $type = $data["type"]??"text";
- $content = $data["content"]??"";
- $news = [];
- if($type == "image"){
- $content = file_exists(ltrim($content,"/")) ? $content : "/static/images/default.jpg";
- }else if($type == "news"){
- $news = WechatNewsModel::where(["id"=>$content])->find();
- if(!empty($news["article_id"])){
- $news["article"] = WechatNewsArticleModel::where("id","in",$news["article_id"])
- ->orderRaw('find_in_set(id,"'.$news["article_id"].'")')
- ->select()->toArray();
- }
- }
- return [ "content"=>$content, "news"=>$news ];
- }
-
- public static function getArticle($data){
- $count = WechatUsersModel::withSearch(["title"],[ 'title'=>$data['key']["title"]??'' ])->count();
- $result = WechatUsersModel::withSearch(["title"],[ 'title'=>$data['key']["title"]??'' ])->order("id","desc")->page($data["page"]??1,$data["limit"]??10)->select()->toArray();
- foreach($result as $key=>$item){
- $article = WechatNewsArticleModel::where("id","in",$item["article_id"])->orderRaw('find_in_set(id,"'.$item["article_id"].'")')->find();
- $list[$key]["title"] = $article["title"];
- $list[$key]["local_url"] = $article["local_url"];
- }
- return ["count"=>$count, "data"=>$result];
- }
- }
|