1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960 |
- <?php
- namespace app\api\controller;
- use app\common\model\ArticleCate;
- use app\common\model\ArticleComment;
- use app\common\model\ArticleCommentLike;
- use app\common\model\ArticleIntro;
- use app\common\model\ArticleItem;
- use app\common\model\ArticleLike;
- use app\common\model\DatumUrl;
- use app\common\model\PlatformSwitch;
- use app\common\model\SeriesArticleCate;
- use app\common\model\TopSearch;
- use app\common\model\User;
- use app\common\model\UserCollect;
- use app\common\model\UserArticle;
- use app\common\model\UserLearn;
- use app\common\model\UserLevelRank;
- use app\common\model\UserMessage;
- use app\common\model\UserSearch;
- use app\common\model\UserTag;
- use app\common\model\UserTrack;
- use app\common\model\VideoUrl;
- use app\common\service\CheckPower;
- use app\common\service\UserSynth;
- use library\tools\Data;
- use think\Db;
- use think\db\Query;
- class Article extends Base
- {
-
- protected $need_login = [
- 'articleTransmit',
- 'articleRead',
- 'articleTags',
- 'articleComment',
- 'delComment',
- 'secondCommend',
- 'commentTags',
- 'articleCollect',
- 'userReferArticle',
- 'getMyArticleList',
- 'getUserArticleDetail',
- 'delUserArticle',
- 'delComment',
- 'getLearnHistory',
- 'getArticleCollect',
- 'getCommentArticle',
- 'commentMyArticle',
- 'getPurchaseArticle',
- 'getReplyArticle',
- 'getReplyComment',
- 'getTagsArticle',
- 'getBoundList',
- 'getFollowUpList',
- 'getFollowUpMessage',
- 'getTagsComment',
- 'getMarkNum',
- 'unreadChange',
- 'batchesDel',
- ];
- public function initialize()
- {
- parent::initialize();
- parent::setUid();
- $this->source_type= $this->request->header('source-type',1);
- }
-
- public function classIntro(){}
-
- public function getArticleCate()
- {
- $type = input('type',2);
- if($type == 1) {
- $list = ArticleCate::where(['is_deleted'=>0,'status'=>1])->field('id,logo,title,pid')->order('sort desc,id asc')->select()->toArray();
- }else{
- $list = SeriesArticleCate::where(['is_deleted'=>0,'status'=>1])->field('id,logo,title,pid')->order('sort desc,id asc')->select()->toArray();
- }
- $list = make_tree($list);
- foreach ($list as &$v) {
- if(empty($v['children']))$v['children'] = null;
- }
- $this->success('ok',['list'=>$list]);
- }
-
- public function getRecommendList()
- {
- $user_id = $this->user_id ? $this->user_id : input('rand_user');
- if(!$user_id) $this->error('参数错误');
- $list = UserSynth::getRecommendList($user_id,'article',$this->page,$this->page_num);
- if($list['code'] != 200) $this->error($list['msg']);
- $this->success('ok',$list);
- $search_log = UserSearch::getSearchTitle($this->user_id,2);
- $search_arr = [];
- $where_str = 'b.id > 0';
- foreach ($search_log as $t){
- $search_arr[] = " b.title like '".'%'.$t."%'" .' ';
- $search_arr[] = " b.label like '".'%'.$t."%'" .' ';
- }
- if(!empty($search_arr)) $where_str = implode(' OR ',$search_arr);
- $field = ' a.id,a.title,a.cover,a.content_type,a.pdf,a.images,a.create_at,a.user_id,a.is_vip,a.read_num,a.article_id ,a.author,IFNULL(is_recommend,0) is_recommend ';
- $table = 'dd_article_item';
- $order_by_two = 'a.read_num';
- $time_str = date("Y-m-d H:i:s");
- $sql = "SELECT $field FROM " .$table . " a LEFT JOIN ( SELECT id,IF(id,1,1) is_recommend FROM $table b WHERE ( $where_str )) AS c ON c.id = a.id LEFT JOIN dd_article_intro as k ON k.id = a.article_id WHERE a.is_deleted = 0 AND a.release_time < '". $time_str ."' AND a.status =1 AND k.status = 1 AND k.is_deleted = 0 ORDER BY is_recommend DESC , $order_by_two desc LIMIT {$this->off_set},{$this->page_num}";
- $list = Db::query($sql);
- $list = dispose_recommend($list);
- array_walk($list,function (&$v,$k){
- $v['read_num'] = numTransform($v['read_num']);
- $article_auth = ArticleItem::getArticleAuth($v['user_id'],APPNAME,APPLOGO);
- $v['app_name'] = $article_auth['app_name'];
- $v['app_logo'] = $article_auth['app_logo'];
- $v['images_arr'] = $v['images'] ? explode('|',$v['images']):null;
- $v['create_at'] = substr($v['create_at'],0,10);
- $v['is_release'] = UserLearn::checkRelease($this->user_id,3,$v['id']);
- });
- $sql2 = "SELECT count(a.id) num FROM " .$table . " a LEFT JOIN ( SELECT id,IF(id,1,1) is_recommend FROM $table b WHERE ( $where_str )) AS c ON c.id = a.id LEFT JOIN dd_article_intro as k ON k.id = a.article_id WHERE a.is_deleted = 0 AND a.release_time < '". $time_str ."' AND a.status =1 AND k.status = 1 AND k.is_deleted = 0 ";
- $total = Db::query($sql2);
- $this->success('ok',['list'=>$list,'total_count'=>$total[0]['num'],'page_num'=>$this->page_num]);
- }
-
- public function getArticleList()
- {
- $sel_where = [];
- $title = input('get.title');
- $type = input('get.type',2);
- $is_tj = input('get.is_tj',0);
- $sort_type = input('get.sort_type',1);
- $first_classify = input('get.first_classify');
- $second_classify = input('get.second_classify');
- $sel_where[] = ['is_deleted','=',0];
- $sel_where[] = ['status','=',1];
- $sel_where[] = ['item_num','>',0];
- if($title) $sel_where[] = ['title|label','like','%'.$title.'%'];
- if($type) $sel_where[] = ['type','=',$type];
- if($first_classify) $sel_where[] = ['first_classify','=',$first_classify];
- if($second_classify) $sel_where[] = ['second_classify','=',$second_classify];
- switch ($sort_type) {
- case 1:
- $order = ['sort'=>'desc','read_num'=>'desc'];
- break;
- case 2:
- $order = ['id'=>'asc','sort'=>'desc'];
- break;
- case 3:
- $order = ['id'=>'desc','sort'=>'desc'];
- break;
- }
- if($title && $this->user_id)UserSearch::saveSearchTitle($this->user_id,$title,2);
- $where_str = 'id > 0';
- $list = ArticleIntro::where($sel_where)->with('itemList2')
- ->limit($this->off_set,$this->page_num)
- ->where($where_str)
- ->order($order)
- ->select()->toArray();
- array_walk($list,function (&$v,$k){
- $v['item_list'] = $v['item_list2'];
- $recently_id = UserTrack::getRecentlyTrack($this->user_id,3,$v['id']);
- $v['recently_title'] = ArticleItem::where('id',$recently_id)->value('title');
- unset($v['item_list2']);
- $v['read_num']= array_sum(array_column($v['item_list'],'read_num'));
- $v['read_num'] = numTransform($v['read_num']);
- unset($v['content']);
- foreach ($v['item_list'] as &$iv) {
-
- if(in_array($this->source_type,[1])) unset($iv['pdf_clear']);
- $iv['read_num'] = numTransform($iv['read_num']);
- $article_auth = ArticleItem::getArticleAuth($iv['user_id'],APPNAME,APPLOGO);
- $iv['app_name'] = $article_auth['app_name'];
- $iv['app_logo'] = $article_auth['app_logo'];
- }
- });
- $total_num = ArticleIntro::where($sel_where) ->where($where_str)->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
-
- public function getSeriesList()
- {
- $type = input('get.type',2);
- $first_classify = input('get.first_classify');
- $second_classify = input('get.second_classify');
- $list = SeriesArticleCate::where(['is_deleted'=>0,'status'=>1])
- ->field('id second_classify,title')->where('pid',$first_classify)
- ->when($second_classify,function ($query)use ($second_classify){if($second_classify){$query->where('id',$second_classify);}})
- ->order('sort desc,id asc')->select()->toArray();
- foreach ($list as &$v) {
- $v['series_list'] = ArticleIntro::field('id,title,cover,is_vip,is_over,create_at')
- ->where('second_classify',$v['second_classify'])
- ->where('type',$type)
- ->where('status',1)
- ->where('is_deleted',0)
- ->where('item_num','>',0)
- ->limit($this->off_set,100)
- ->order('sort desc,id desc')->select()->toArray();
- }
- $this->success('ok',['list'=>$list]);
- }
-
- public function getArticleDetail()
- {
- $form = input('get.from','H5');
- $sel_where = [];
- $sel_where[] = ['id','=',input('get.id')];
- $sort_type = input('get.sort_type',1);
- $is_release = UserLearn::checkRelease($this->user_id,3,input('get.id'));
- $detail = ArticleIntro::where($sel_where)->with(['itemList3'=>function($query)use($sort_type,$is_release){
- switch ($sort_type) {
- case 1:
- $order = ['sort'=>'desc','id'=>'asc'];
- break;
- case 2:
- $order = ['id'=>'asc','sort'=>'desc'];
- break;
- case 3:
- $order = ['id'=>'desc','sort'=>'desc'];
- break;
- }
- return $is_release ? $query->order($order) : $query->where('status',1)->order($order);
- }])->find()->toArray();
- $detail['item_list'] = $detail['item_list3'];
- unset($detail['item_list3']);
- $detail['is_release'] = $is_release;
- if($is_release && $detail['is_deleted'] )$this->error('该图文已下线');
- if(!$detail['is_release'] && ($detail['is_deleted'] == 1 || $detail['status'] == 0))$this->error('该图文已下线');
- if(in_array($this->source_type,[1])) $detail['content'] = openssl_encrypt($detail['content'],'DES-ECB',123456,0);
- $detail['read_num'] = array_sum(array_column($detail['item_list'],'read_num'));
- $detail['read_num'] = numTransform($detail['read_num']);
- $detail['follow_switch'] = PlatformSwitch::checkSwitch($this->user_id,$detail['id'],3);
- $recently_id = UserTrack::getRecentlyTrack($this->user_id,3,$detail['id']);
- $level_id = UserLevelRank::getUserVip($this->user_id);
- $detail['user_level'] = $level_id;
- foreach ($detail['item_list'] as &$dv) {
- if(in_array($this->source_type,[1])) unset($dv['pdf_clear']);
- if(in_array($this->source_type,[1])) $dv['content'] = openssl_encrypt($dv['content'],'DES-ECB',123456,0);
- $dv['switch_open'] = PlatformSwitch::checkSwitch($this->user_id,$dv['id'],8);
- $dv['comment_num'] = ArticleComment::getArticleCommentNum($dv['id']);
- $dv['collect_num'] = UserCollect::where(['coll_type'=>3,'coll_id'=>$detail['id'],'children_id'=>$dv['id']])->count();
- $dv['collect_num'] = numTransform($dv['collect_num']);
- $dv['transmit_num'] = numTransform($dv['transmit_num']);
- $dv['is_collect'] = UserCollect::checkCollectByType($this->user_id,3,$detail['id'],$dv['id']);
- $dv['read_num'] = numTransform($dv['read_num']);
- $dv['is_recently'] = $dv['id'] == $recently_id ? 1 : 0;
- $dv['is_like'] = ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$dv['article_id'],'item_id'=>$dv['id']])->count();
- $dv['like_num'] = ArticleLike::where(['article_id'=>$dv['article_id'],'item_id'=>$dv['id']])->count();
- $article_auth = ArticleItem::getArticleAuth($dv['user_id'],APPNAME,APPLOGO);
- $dv['app_name'] = $article_auth['app_name'];
- $dv['app_logo'] = $article_auth['app_logo'];
- $dv['video_jump'] = VideoUrl::checkVip($dv['video_item'],$this->user_id);
- $dv['datum_jump'] = DatumUrl::checkVip($dv['datum_item'],$this->user_id);
- }
- $this->success('ok',['detail'=>$detail]);
- }
-
- public function getArticleDetail2()
- {
- $form = input('get.from','H5');
- $sel_where = [];
- $sel_where[] = ['id','=',input('get.id')];
- $sort_type = input('get.sort_type',1);
- $is_release = UserLearn::checkRelease($this->user_id,3,input('get.id'));
- $detail = ArticleIntro::where($sel_where)->with(['itemList2'=>function($query)use($sort_type,$is_release){
- switch ($sort_type) {
- case 1:
- $order = ['sort'=>'desc','id'=>'asc'];
- break;
- case 2:
- $order = ['id'=>'asc','sort'=>'desc'];
- break;
- case 3:
- $order = ['id'=>'desc','sort'=>'desc'];
- break;
- }
- return $is_release ? $query->order($order) : $query->where('status',1)->order($order);
- }])->find()->toArray();
- $detail['item_list'] = $detail['item_list2'];
- unset($detail['item_list2']);
- $detail['is_release'] = $is_release;
- if($is_release && $detail['is_deleted'] )$this->error('该图文已下线');
- if(!$detail['is_release'] && ($detail['is_deleted'] == 1 || $detail['status'] == 0))$this->error('该图文已下线');
- $detail['read_num'] = array_sum(array_column($detail['item_list'],'read_num'));
- $detail['read_num'] = numTransform($detail['read_num']);
- $detail['follow_switch'] = PlatformSwitch::checkSwitch($this->user_id,$detail['id'],3);
- $recently_id = UserTrack::getRecentlyTrack($this->user_id,3,$detail['id']);
- $level_id = UserLevelRank::getUserVip($this->user_id);
- $detail['user_level'] = $level_id;
- foreach ($detail['item_list'] as &$dv) {
- if(in_array($this->source_type,[1])) unset($dv['pdf_clear']);
- $dv['switch_open'] = PlatformSwitch::checkSwitch($this->user_id,$dv['id'],8);
- $dv['comment_num'] = ArticleComment::getArticleCommentNum($dv['id']);
- $dv['collect_num'] = UserCollect::where(['coll_type'=>3,'coll_id'=>$detail['id'],'children_id'=>$dv['id']])->count();
- $dv['collect_num'] = numTransform($dv['collect_num']);
- $dv['transmit_num'] = numTransform($dv['transmit_num']);
- $dv['is_collect'] = UserCollect::checkCollectByType($this->user_id,3,$detail['id'],$dv['id']);
- $dv['read_num'] = numTransform($dv['read_num']);
- $dv['is_recently'] = $dv['id'] == $recently_id ? 1 : 0;
- $dv['is_like'] = ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$dv['article_id'],'item_id'=>$dv['id']])->count();
- $dv['like_num'] = ArticleLike::where(['article_id'=>$dv['article_id'],'item_id'=>$dv['id']])->count();
- $article_auth = ArticleItem::getArticleAuth($dv['user_id'],APPNAME,APPLOGO);
- $dv['app_name'] = $article_auth['app_name'];
- $dv['app_logo'] = $article_auth['app_logo'];
- $dv['video_jump'] = VideoUrl::checkVip($dv['video_item'],$this->user_id);
- $dv['datum_jump'] = DatumUrl::checkVip($dv['datum_item'],$this->user_id);
- }
- $this->success('ok',['detail'=>$detail]);
- }
-
- public function getArticleItemInfo()
- {
- $item_id = input('get.item_id');
- $form = input('get.from','H5');
- $detail = ArticleItem::field('a.*,t.is_deleted td,t.status tus,t.title article_title')->where('a.id',$item_id)->alias('a')->leftJoin('ArticleIntro t','t.id= a.article_id')->find()->toArray();
- $is_release = UserLearn::checkRelease($this->user_id,3,$detail['article_id']);
- if($is_release && ($detail['is_deleted'] == 1 || $detail['td'] == 1))$this->error('图文已下架');
- if(!$is_release && ($detail['is_deleted'] == 1 || $detail['status'] == 0 || $detail['td'] == 1 || $detail['tus']==0) ) $this->error('图文已下架');
- $detail['series_title'] = $detail['article_title'];
- if(in_array($this->source_type,[1])) unset($detail['pdf_clear']);
- $detail['collect_num'] = UserCollect::where(['coll_type'=>3,'coll_id'=>$detail['article_id'],'children_id'=>$detail['id']])->count();
- $detail['is_collect'] = UserCollect::checkCollectByType($this->user_id,3,$detail['article_id'],$detail['id']);
- $detail['is_like'] = ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$detail['article_id'],'item_id'=>$detail['id']])->count();
- if(in_array($this->source_type,[1])) $detail['content'] = openssl_encrypt($detail['content'],'DES-ECB',123456,0);
- $detail['like_num'] = ArticleLike::where(['article_id'=>$detail['article_id'],'item_id'=>$detail['id']])->count();
- $detail['like_num'] = numTransform($detail['like_num']);
- $detail['read_num'] = numTransform($detail['read_num']);
- $detail['comment_num'] =ArticleComment::getArticleCommentNum($detail['id']);
- $detail['collect_num'] = numTransform($detail['collect_num']);
- $detail['transmit_num'] = numTransform($detail['transmit_num']);
- $detail['is_release'] = $is_release;
- UserTrack::crateTrack($this->user_id,3,$detail['article_id'],$item_id);
- $article_auth = ArticleItem::getArticleAuth($detail['user_id'],APPNAME,APPLOGO);
- $detail['app_name'] = $article_auth['app_name'];
- $detail['app_logo'] = $article_auth['app_logo'];
- $detail['follow_switch'] = PlatformSwitch::checkSwitch($this->user_id,$detail['article_id'],3);
- $detail['switch_open'] = PlatformSwitch::checkSwitch($this->user_id,$detail['id'],8);
-
- ArticleItem::where('id',$item_id)->setInc('read_num');
- ArticleIntro::where('id',$detail['article_id'])->setInc('read_num');
- TopSearch::seIncHotNum($item_id,$this->request->controller());
- $this->success('ok',['detail'=>$detail]);
- }
-
- public function getArticleCommentList()
- {
- $where = [];
- $where[] = ['c.article_id','=',input('get.article_id')];
- $where[] = ['c.is_deleted','=',0];
- $user_id = $this->user_id;
- $sort_type= input('sort_type',1);
- if(input('get.item_id')) $where[] = ['c.item_id','=',input('get.item_id')];
- switch ($sort_type) {
- case 1:
- $order = ['is_top'=>'desc','id'=>'desc'];
- break;
- default:
- $order = ['is_top'=>'desc','like_times'=>'desc'];
- break;
- }
- $list =ArticleComment::where($where)
- ->alias('c')
- ->field('c.*,u.name,u.headimg')
- ->leftJoin('store_member u','u.id = c.user_id')
- ->order($order)
- ->limit($this->off_set,$this->page_num)
- ->select()->toArray();
- array_walk($list,function (&$val,$k)use($user_id){
- $children = ArticleComment::where(['c.pid'=>$val['id']])
- ->alias('c')->field('c.*,u.name,u.headimg')
- ->leftJoin('store_member u','u.id = c.user_id')
- ->order('c.is_top desc,c.id asc')
- ->select()->toArray();
- $val['children'] = $children;
- $val['like_num'] = ArticleCommentLike::where('like_id',$val['id'])->count();
- $val['like_num'] = numTransform($val['like_num']);
- $val['is_like'] = ArticleCommentLike::where(['like_id'=>$val['id'],'user_id'=>$user_id])->count();
- $parent = ArticleComment::where(['c.id'=>$val['pid']])
- ->alias('c')->field('c.*,u.name,u.headimg')
- ->leftJoin('store_member u','u.id = c.user_id')
- ->find();
- $val['parent'] = $parent ? $parent->toArray() : null;
- $val['can_delete'] = $val['user_id'] == $this->user_id ? 1 :0;
- });
- $total_num = ArticleComment::where($where)->alias('c') ->leftJoin('store_member u','u.id = c.user_id')->count();
- $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
-
-
-
- public function needLogin(){}
-
- public function articleTransmit()
- {
- $item_id = input('post.item_id',0);
- ArticleItem::where('id',$item_id)->setInc('transmit_num');
- $this->success('ok');
- }
-
- public function articleRead()
- {
- $item_id = input('post.item_id',0);
- $article_id = ArticleItem::where('id',$item_id)->value('article_id');
- ArticleItem::where('id',$item_id)->setInc('read_num');
- ArticleIntro::where('id',$article_id)->setInc('read_num');
- TopSearch::seIncHotNum($item_id,$this->request->controller());
- $this->success('ok');
- }
-
- public function articleTags()
- {
- $ids = input('post.item_id');
- $ret_val = 0;
- foreach (explode(',',$ids) as $item_id) {
- $article_id = ArticleItem::where('id',$item_id)->value('article_id');
- $check_tags = ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$article_id,'item_id'=>$item_id])->value('id');
- if($check_tags) {
- ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$article_id,'item_id'=>$item_id])->delete();
- }else{
- $p_user_id = ArticleItem::where('id',$item_id)->value('user_id');
- $is_read = $p_user_id == $this->user_id ? 1 : 0;
- Data::save('ArticleLike',
- ['user_id'=>$this->user_id,'article_id'=>$article_id,'item_id'=>$item_id,'is_read'=>$is_read],'user_id',
- ['user_id'=>$this->user_id,'article_id'=>$article_id,'item_id'=>$item_id]);
- $ret_val = 1;
- }
- }
- $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
- }
-
- public function articleComment()
- {
- $article_id = input('post.article_id');
- $item_id = input('post.item_id');
- $content = input('post.content',0);
- if(!$content) $this->error('请输入评论内容');
- $comment_switch = ArticleItem::where('id',$item_id)->value('comment_switch');
- $send_user = ArticleItem::where('id',$item_id)->value('user_id');
- if(!$comment_switch) $this->error('评论功能已关闭');
- $res = ArticleComment::create([
- 'user_id'=>$this->user_id,
- 'content'=>$content
- ,'article_id'=>$article_id,
- 'item_id'=>$item_id,
- 'is_read' => $send_user == $this->user_id ? 1 : 0,
- 'source_read' => $send_user == $this->user_id ? 1 : 0,
- ]);
- $detail =ArticleComment::where('c.id',$res->id)
- ->alias('c')
- ->field('c.id,c.content,c.create_at,u.name,u.headimg')
- ->leftJoin('store_member u','u.id = c.user_id')
- ->find()->toArray();
- $user_info = $this->userInfo('name');
- if($send_user != $this->user_id) UserMessage:: sendUserMessage($send_user,'article',4,0,$this->user_id,$item_id,$content,$item_id,$article_id);
- $this->success('评论成功',['detail'=>$detail]);
- }
-
- public function delComment(){
- ArticleComment::where(['id'=>input('post.id'),'user_id'=>$this->user_id])->update(['is_deleted'=>1]);
- $this->success('删除成功');
- }
-
- public function secondCommend()
- {
- $comment = ArticleComment::where('id',input('post.id'))->find()->toArray();
- $content = input('post.content');
- $user_info = $this->userInfo('name');
- if($comment['user_id'] != $this->user_id)UserMessage:: sendUserMessage($comment['user_id'],'article',3,0,$this->user_id,$comment['id'],$content,$comment['item_id'],$comment['article_id']);
- $send_user = ArticleItem::where('id',$comment['item_id'])->value('user_id');
- $comment_switch = ArticleItem::where('id',$comment['item_id'])->value('comment_switch');
- if(!$comment_switch) $this->error('评论功能已关闭');
-
- $to_user = $comment['user_id'];
- unset($comment['id']);
- unset($comment['create_at']);
- unset($comment['to_deleted']);
- unset($comment['is_top']);
- unset($comment['is_deleted']);
- $comment['pid'] = input('post.id');
- $comment['user_id'] = $this->user_id;
- $comment['content'] = $content;
- $comment['lev']++;
- $comment['is_read']= $this->user_id == $to_user ? 1 :0 ;
- $comment['source_read'] = $this->user_id == $send_user ? 1 :0 ;
- if(!$comment['source_id']) $comment['source_id'] = input('post.id');
- $res = ArticleComment::create($comment);
- $detail = ArticleComment::where('c.id',$res->id)
- ->alias('c')
- ->field('c.id,c.content,c.create_at,u.name,u.headimg')
- ->leftJoin('store_member u','u.id = c.user_id')
- ->find()->toArray();
- $this->success('评论成功',['detail'=>$detail]);
- }
-
- public function commentTags()
- {
- $comment_id = input('post.comment_id');
- $ret_val = 0;
- $check_tags = ArticleCommentLike::where(['user_id'=>$this->user_id,'like_id'=>$comment_id])->value('id');
- if($check_tags) {
- ArticleCommentLike::where(['user_id'=>$this->user_id,'like_id'=>$comment_id])->delete();
-
- }else{
- $p_user_id = ArticleComment::where('id',$comment_id)->value('user_id');
- $is_read = $p_user_id == $this->user_id ? 1 : 0;
- Data::save('ArticleCommentLike',
- ['user_id'=>$this->user_id,'like_id'=>$comment_id,'is_read'=>$is_read],'user_id',
- ['user_id'=>$this->user_id,'like_id'=>$comment_id]);
- $ret_val = 1;
-
- }
- $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
- }
-
- public function articleCollect()
- {
- $coll_type = input('post.coll_type',3);
- $coll_id = input('post.article_id',0);
- $item_id = input('post.item_id',0);
- $collect_check = UserCollect::checkCollectByType($this->user_id,$coll_type,$coll_id,$item_id);
- if($collect_check) {
- UserCollect::where(['user_id'=>$this->user_id,'coll_type'=>$coll_type,'coll_id'=>$coll_id,'children_id'=>$item_id])->delete();
- $this->success('取消收藏成功',['status'=>0]);
- }else{
- Data::save('UserCollect', [
- 'user_id'=>$this->user_id,
- 'coll_type'=>$coll_type,
- 'coll_id'=>$coll_id,
- 'children_id'=>$item_id,
- 'create_int'=>time()],'user_id',['user_id'=>$this->user_id,'coll_type'=>$coll_type, 'coll_id'=>$coll_id,'children_id'=>$item_id]);
- $this->success('收藏成功',['status'=>1]);
- }
- }
-
-
- public function userReferArticle()
- {
- $id = input('post.id',0);
- $title = input('post.title');
- $desc = input('post.desc');
- $images = input('post.images');
- $label = input('post.label');
- $document = input('post.document');
-
- if($id){
- $check_status = UserArticle::where('id',$id)->value('status');
- if($check_status == 1) $this->error('已审核通过,不允许修改');
- }
- $data = [
- 'title' => $title,
- 'user_id' => $this->user_id,
- 'desc' => $desc,
- 'images' => $images,
- 'label' => $label,
- 'document' => $document,
- 'cover' => $images ? explode('|',$images)[0] : '',
- 'status' => 0,
- 'remark' => '',
- ];
- if($id) $data['id'] = $id;
- if($id){
- UserArticle::where('id',$id)->update($data);
- }else{
- $res= UserArticle::create($data) ;
- }
-
- $this->success('提交成功,请等待审核',['id'=> $id ? :$res->id]);
- }
-
- public function getMyArticleList()
- {
- $sel_where = [];
- $sel_where[] = ['is_deleted','=',0];
- $sel_where[] = ['user_id','=',$this->user_id];
- $title = input('get.title');
- if($title) $sel_where[] = ['title|label','like','%'.$title.'%'];
- $list = UserArticle::where($sel_where)
- ->field('id,title,desc,images,status,remark,create_at,label')
- ->order('id desc')
- ->limit($this->off_set,$this->page_num)
- ->select()->toArray();
- array_map(function (&$v){
- $v['label_name'] =$v['label'] ? explode(',',trim($v['label'],',')) :null;
- $v['images_arr'] = $v['images'] ? explode('|',$v['images']):null;
- },$list);
- $total_num = UserArticle::where($sel_where)->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
-
- public function getUserArticleDetail()
- {
- $detail =UserArticle::where('id',input('get.id'))->field('id,title,desc,images,status,remark,label,document')->find();
- if(!$detail) $this->error('图文有误');
- $this->success('ok',['detail'=>$detail->toArray()]);
- }
-
- public function delUserArticle()
- {
- UserArticle::where(['user_id'=>$this->user_id,'id'=>input('post.id')])->delete();
- $this->success('删除成功');
- }
-
- public function learn(){}
-
- public function getLearnHistory()
- {
- $sel_where = [];
- $sel_where[] = ['t.user_id','=',$this->user_id];
- $sel_where[] = ['t.type','=',3];
- $title = input('get.title');
- if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
- $list = UserTrack::where($sel_where)
- ->alias('t')
- ->field('t.id,t.update_int,t.first_id article_id,t.second_id item_id,i.title,i.cover,i.read_num,i.user_id,x.title series_title')
- ->leftJoin('ArticleItem i','t.second_id = i.id')
- ->leftJoin('ArticleIntro x','t.first_id = x.id')
- ->order('update_int desc')
- ->limit($this->off_set,$this->page_num)
- ->select()->toArray();
- foreach ($list as &$v) {
- $v['read_num'] = numTransform($v['read_num']);
- $v['time'] = date("Y-m-d H:i:s",$v['update_int']);
- $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
- $article_auth = ArticleItem::getArticleAuth($v['user_id'],APPNAME,APPLOGO);
- $v['app_name'] = $article_auth['app_name'];
- $v['app_logo'] = $article_auth['app_logo'];
- }
- $total_num = UserTrack::where($sel_where)->alias('t') ->leftJoin('ArticleItem i','t.second_id = i.id')->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
-
- public function getArticleCollect()
- {
- $sel_where = [];
- $title = input('get.title');
- if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
- $sel_where[] = ['t.user_id','=',$this->user_id];
- $sel_where[] = ['t.coll_type','=',3];
- $list = UserCollect::where($sel_where)
- ->alias('t')
- ->field('t.id,t.create_at,t.coll_id article_id,t.children_id item_id,i.title,i.cover,i.read_num,i.transmit_num,i.desc,x.title series_title,i.user_id')
- ->leftJoin('ArticleItem i','t.children_id = i.id')
- ->leftJoin('ArticleIntro x','t.coll_id = x.id')
- ->order('id desc')
- ->limit($this->off_set,$this->page_num)
- ->select()->toArray();
- array_walk($list,function (&$v){
- $v['switch_open'] = PlatformSwitch::checkSwitch($this->user_id,$v['item_id'],8);
- $v['read_num'] = numTransform($v['read_num']);
- $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
- $v['transmit_num'] = numTransform($v['transmit_num']);
- $v['collect_num'] = UserCollect::where(['coll_type'=>3,'coll_id'=>$v['article_id'],'children_id'=>$v['item_id']])->count();
- $v['collect_num'] = numTransform($v['collect_num']);
- $v['is_collect'] = UserCollect::checkCollectByType($this->user_id,3,$v['article_id'],$v['item_id']);
- $v['like_num'] = ArticleLike::where(['article_id'=>$v['article_id'],'item_id'=>$v['item_id']])->count();
- $v['like_num'] = numTransform($v['like_num']);
- $v['comment_num'] = ArticleComment::getArticleCommentNum($v['item_id']);
- $v['is_like'] = ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$v['article_id'],'item_id'=>$v['item_id']])->count();
- $article_auth = ArticleItem::getArticleAuth($v['user_id'],APPNAME,APPLOGO);
- $v['app_name'] = $article_auth['app_name'];
- $v['app_logo'] = $article_auth['app_logo'];
- });
- $total_num = UserCollect::where($sel_where)->alias('t') ->leftJoin('ArticleItem i','t.children_id = i.id')->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
-
- public function getCommentArticle()
- {
- $user_info = $this->userInfo();
- $sel_where = [];
- $title = input('get.title');
- if($title) $sel_where[] = ['i.title|i.label|t.content','like','%'.$title.'%'];
- $sel_where[] = ['t.user_id','=',$this->user_id];
- $sel_where[] = ['t.is_deleted','=',0];
- $sel_where[] = ['t.lev','=',1];
- $sel_where[] = ['t.pid','=',0];
- $list = ArticleComment::where($sel_where)
- ->alias('t')
- ->field('t.id,t.create_at,t.article_id,t.item_id,t.is_top,t.lev,t.content,i.title,i.cover,x.title series_title,i.user_id,i.read_num')
- ->leftJoin('ArticleItem i','t.item_id = i.id')
- ->leftJoin('ArticleIntro x','t.article_id = x.id')
- ->order('t.is_top desc,id desc')
- ->limit($this->off_set,$this->page_num)
- ->select()->toArray();
- foreach ($list as &$v)
- {
- $v['read_num'] = numTransform($v['read_num']);
- $v['user_name'] = $user_info['name'];
- $v['headimg'] = $user_info['headimg'];
- $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
- $article_auth = ArticleItem::getArticleAuth($v['user_id'],APPNAME,APPLOGO);
- $v['app_name'] = $article_auth['app_name'];
- $v['app_logo'] = $article_auth['app_logo'];
- }
- $total_num = ArticleComment::where($sel_where)->alias('t') ->leftJoin('ArticleItem i','t.item_id = i.id')->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
-
- public function commentMyArticle()
- {
- $sel_where = [];
- $title = input('get.title');
- if($title) $sel_where[] = ['i.title|i.label|t.content','like','%'.$title.'%'];
- $sel_where[] = ['t.is_deleted','=',0];
- $sel_where[] = ['i.user_id','=',$this->user_id];
- $sel_where[] = ['t.user_id','<>',$this->user_id];
- $sel_where[] = ['t.source_deleted','=',0];
- $sel_where[] = ['t.pid','=',0];
- $list = ArticleComment::where($sel_where)
- ->alias('t')
- ->field('t.id,t.is_read,t.is_top,t.create_at,i.read_num,t.article_id,t.item_id,t.lev,t.content,i.title,i.label,i.cover,u.name user_name,u.headimg,x.title series_title')
- ->leftJoin('ArticleItem i','t.item_id = i.id')
- ->leftJoin('ArticleIntro x','t.article_id = x.id')
- ->leftJoin('store_member u','t.user_id = u.id')
- ->order('t.id desc')
- ->limit($this->off_set,$this->page_num)
- ->select()->toArray();
- $user_info = $this->userInfo('name,headimg');
- array_walk($list,function (&$v)use ($user_info){
- $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
- $v['read_num'] = numTransform($v['read_num']);
- $v['app_name'] = $user_info['name'];
- $v['app_logo'] = $user_info['headimg'];
- });
- $total_num= ArticleComment::where($sel_where)->alias('t')->leftJoin('ArticleItem i','t.item_id = i.id')
- ->leftJoin('store_member u','t.user_id = u.id')->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
-
- public function getPurchaseArticle()
- {
- $sel_where = [];
- $title = input('get.title');
- if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
- $sel_where[] = ['t.user_id','=',$this->user_id];
- $sel_where[] = ['t.type','=',3];
- $sel_where[] = ['t.end_int','>',time()];
- $sel_where[] = ['t.is_deleted','=',0];
- $sel_where[] = ['a.is_deleted','=',0];
- $list = UserLearn::where($sel_where)
- ->alias('t')
- ->field('t.id,t.create_at,t.first_id article_id,t.second_id item_id,a.title,a.cover,a.total_sequel')
- ->leftJoin('ArticleIntro a','t.first_id = a.id')
- ->leftJoin('ArticleItem i','t.second_id = i.id')
- ->order('id desc')
- ->limit($this->off_set,$this->page_num)
- ->select()->toArray();
- array_walk($list,function (&$v){
- $v['is_normal'] = 1;
- $recently_id = UserTrack::getRecentlyTrack($this->user_id,3,$v['article_id']);
- $v['is_recently'] = $recently_id ? 1 : 0;
- $v['recently_title'] = ArticleItem::where('id',$recently_id)->value('title');
- });
- $total_num = UserLearn::where($sel_where)->alias('t') ->leftJoin('ArticleItem i','t.second_id = i.id')
- ->leftJoin('ArticleIntro a','t.first_id = a.id')->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
-
- public function getReplyArticle()
- {
- $user_info = $this->userInfo();
- $sel_where = [];
- $title = input('get.title');
- if($title) $sel_where[] = ['i.title|i.label|t.content','like','%'.$title.'%'];
- $sel_where[] = ['t.user_id','=',$this->user_id];
- $sel_where[] = ['t.is_deleted','=',0];
- $sel_where[] = ['t.lev','>=',2];
- $list = ArticleComment::where($sel_where)
- ->alias('t')
- ->field('t.id,t.article_id,t.is_top,t.item_id,t.create_at,t.lev,t.content,i.title,t.pid,i.read_num')
- ->leftJoin('ArticleItem i','t.item_id = i.id')
- ->order('t.is_top desc,t.id desc')
- ->limit($this->off_set,$this->page_num)
- ->select()->toArray();
- foreach ($list as &$v) {
- $v['user_name'] = $user_info['name'];
- $v['headimg'] = $user_info['headimg'];
- $v['read_num'] = numTransform($v['read_num']);
- $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
- $parent_comment = ArticleComment::where([['t.id','=',$v['pid']]])
- ->field('t.id,t.article_id,t.is_top,t.item_id,t.content,i.title,i.user_id,i.cover,t.pid,u.name,x.title series_title')
- ->alias('t')
- ->leftJoin('ArticleItem i','t.item_id = i.id')
- ->leftJoin('ArticleIntro x','t.article_id = x.id')
- ->leftJoin('store_member u','t.user_id = u.id')
- ->find()->toArray();
- $article_auth = ArticleItem::getArticleAuth($parent_comment['user_id'],APPNAME,APPLOGO);
- $parent_comment['app_name'] = $article_auth['app_name'];
- $parent_comment['app_logo'] = $article_auth['app_logo'];
- $parent_comment['read_num'] = numTransform($v['read_num']);
- $v['parent_comment'] = $parent_comment;
- }
- $total_num = ArticleComment::where($sel_where)->alias('t') ->leftJoin('ArticleItem i','t.item_id = i.id')->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
-
- public function getReplyComment()
- {
- $all_comment = ArticleComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
- if(empty($all_comment)) $this->success('ok',['list'=>[]]);
- $sel_where = [];
- $title = input('get.title');
- if($title) $sel_where[] = ['i.title|i.label|t.content','like','%'.$title.'%'];
- $sel_where[] = ['t.is_deleted','=',0];
- $sel_where[] = ['t.lev','>=',2];
- $sel_where[] = ['t.user_id','<>',$this->user_id];
- $sel_where[] = ['t.to_deleted','=',0];
- $sel_where[] = ['t.pid','in',implode(',',$all_comment)];
- $list = ArticleComment::where($sel_where)
- ->alias('t')
- ->field('t.id,t.is_read,t.article_id,t.is_top,t.is_deleted,t.item_id,t.create_at,t.lev,t.content,t.pid,u.name user_name,u.headimg,i.user_id')
- ->leftJoin('store_member u','t.user_id = u.id')
- ->leftJoin('ArticleItem i','t.item_id = i.id')
- ->order('t.is_top desc,t.id desc')
- ->limit($this->off_set,$this->page_num)
- ->select()->toArray();
- foreach ($list as &$v) {
- $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
- $parent_comment = ArticleComment::where([['t.id','=',$v['pid']]])
- ->field('t.id,t.article_id,t.is_top,t.item_id,t.content,i.title,i.cover,t.pid,u.name,t.is_deleted,i.user_id,i.read_num,x.title series_title')
- ->alias('t')
- ->leftJoin('ArticleItem i','t.item_id = i.id')
- ->leftJoin('ArticleIntro x','t.article_id = x.id')
- ->leftJoin('store_member u','t.user_id = u.id')
- ->find()->toArray();
- $article_auth = ArticleItem::getArticleAuth($parent_comment['user_id'],APPNAME,APPLOGO);
- $parent_comment['read_num'] = numTransform($parent_comment['read_num']);
- $parent_comment['app_name'] = $article_auth['app_name'];
- $parent_comment['app_logo'] = $article_auth['app_logo'];
- $v['parent_comment'] = $parent_comment;
- }
- $total_num = ArticleComment::where($sel_where)->alias('t') ->leftJoin('store_member u','t.user_id = u.id')
- ->leftJoin('ArticleItem i','t.item_id = i.id')->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
-
- public function getTagsArticle()
- {
- $sel_where = [];
- $title = input('get.title');
- if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
- $sel_where[] = ['t.user_id','=',$this->user_id];
- $list = ArticleLike::where($sel_where)
- ->alias('t')
- ->field('t.id,t.create_at,t.article_id,t.item_id,i.title,i.cover,i.is_vip,i.images,i.read_num,i.user_id,i.transmit_num,i.desc,x.title series_title')
- ->leftJoin('ArticleItem i','t.item_id = i.id')
- ->leftJoin('ArticleIntro x','t.article_id = x.id')
- ->order('id desc')
- ->limit($this->off_set,$this->page_num)
- ->select()->toArray();
- foreach ($list as &$v) {
- $v['switch_open'] = PlatformSwitch::checkSwitch($this->user_id,$v['item_id'],8);
- $v['like_num'] = ArticleLike::where(['article_id'=>$v['article_id'],'item_id'=>$v['item_id']])->count();
- $v['like_num'] = numTransform($v['like_num']);
- $v['read_num'] = numTransform($v['read_num']);
- $v['is_like'] = ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$v['article_id'],'item_id'=>$v['item_id']])->count();
- $v['images_arr'] = $v['images'] ? explode('|',$v['images']):null;
- $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
- $article_auth = ArticleItem::getArticleAuth($v['user_id'],APPNAME,APPLOGO);
- $v['app_name'] = $article_auth['app_name'];
- $v['app_logo'] = $article_auth['app_logo'];
- $v['is_collect'] = UserCollect::checkCollectByType($this->user_id,3,$v['article_id'],$v['item_id']);
- $v['collect_num'] = UserCollect::getCollectNum(3,$v['article_id'],$v['item_id']);
- $v['comment_num'] = ArticleComment::getArticleCommentNum($v['item_id']);
- }
- $total_num = ArticleLike::where($sel_where)->alias('t') ->leftJoin('ArticleItem i','t.item_id = i.id')->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
-
- public function secondPhase(){}
-
- public function getBoundList()
- {
- $sel_where = [];
- $title = input('get.title');
- $sel_where[] = ['t.user_id','=',$this->user_id];
- $sel_where[] = ['t.is_deleted','=',0];
- if($title) $sel_where[] = ['t.title|t.label','like','%'.$title.'%'];
- $list = ArticleItem::where($sel_where)
- ->alias('t')
- ->field('t.id,t.title,t.cover,t.read_num,t.label,t.is_vip,t.article_id,t.create_at,x.title series_title')
- ->leftJoin('ArticleIntro x','t.article_id = x.id')
- ->order('id desc')
- ->limit($this->off_set,$this->page_num)
- ->select()->toArray();
- foreach ($list as &$v) {
- $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['id'],$this->request->controller());;
- $v['label_name'] =$v['label'] ? explode(',',trim($v['label'],',')) :null;
- }
- $total_num = ArticleItem::where($sel_where)->alias('t')->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
-
- public function getFollowUpList()
- {
- $sel_where = [];
- $sel_where[] = ['p.user_id','=',$this->user_id];
- $sel_where[] = ['p.type','=',3];
- $sel_where[] = ['p.switch_value','=',1];
- $title = input('title');
- if($title) $sel_where[] = ['a.title','like','%'.$title.'%'];
- $field = 'p.id,p.switch_id as article_id,p.create_at,a.title,a.total_sequel,a.cover,a.status ,a.is_deleted';
- $list = PlatformSwitch::field($field)
- ->alias('p')
- ->leftJoin('ArticleIntro a','p.switch_id = a.id')
- ->where($sel_where)
- ->limit($this->off_set,$this->page_num)
- ->order('p.id desc')
- ->select()->toArray();
- array_walk($list,function (&$v){
- $v['is_normal'] = $v['status'] == 1 && $v['is_deleted'] == 0 ? 1 : 0;
- $recently_id = UserTrack::getRecentlyTrack($this->user_id,3,$v['article_id']);
- $v['is_recently'] = $recently_id ? 1 : 0;
- $v['recently_id'] = $recently_id ? $recently_id : 0;
- $v['recently_title'] = ArticleItem::where('id',$recently_id)->value('title');
- });
- $total_num= PlatformSwitch::field($field)->alias('p') ->leftJoin('ArticleIntro a','p.switch_id = a.id')->where($sel_where)->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
-
- public function getFollowUpMessage()
- {
- $title = input('title');
- $list = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0,'m.module'=>'article','m.type_id'=>5])
- ->alias('m')
- ->when($title,function ($query)use ($title){
- if($title) $query->where('m.content','like','%'.$title.'%');})
- ->field('m.id,v.create_at,m.is_read,m.content,m.relation_id article_id,m.module,v.title article_title,m.children_id')
- ->leftJoin('ArticleIntro v','v.id= m.relation_id')
- ->limit($this->off_set,$this->page_num)
- ->order(['m.id'=>'desc'])
- ->select()->toArray();
- foreach ($list as &$v) {
- $v['series_title'] =$v['article_title'];
- $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['children_id'],$this->request->controller());
- }
- $total_num = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0,'m.module'=>'article','m.type_id'=>5])
- ->alias('m')->leftJoin('ArticleIntro v','v.id= m.relation_id')->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
-
- public function getTagsComment()
- {
- $list = ArticleCommentLike::field('l.*,i.read_num,c.content,i.read_num,i.title,i.cover,u.name user_name,u.headimg,i.user_id buid,i.id item_id,i.article_id,x.title series_title')
- ->alias('l')
- ->where(['l.user_id'=>$this->user_id,'l.type'=>1])
- ->leftJoin('ArticleComment c','l.like_id = c.id')
- ->leftJoin('ArticleItem i','i.id = c.item_id')
- ->leftJoin('ArticleIntro x','x.id = i.article_id')
- ->leftJoin('store_member u','u.id = c.user_id')
- ->order('l.id desc')
- ->limit($this->off_set,$this->page_num)
- ->select()->toArray();
- array_walk($list,function (&$v){
- $article_auth = ArticleItem::getArticleAuth($v['buid'],APPNAME,APPLOGO);
- $v['app_name'] = $article_auth['app_name'];
- $v['app_logo'] = $article_auth['app_logo'];
- $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
- });
- $total_num =ArticleCommentLike::where(['l.user_id'=>$this->user_id,'l.type'=>1])
- ->alias('l')
- ->leftJoin('ArticleComment c','l.like_id = c.id')
- ->leftJoin('ArticleItem i','i.id = c.item_id')
- ->leftJoin('store_member u','u.id = c.user_id')
- ->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
-
- public function getMarkNum()
- {
-
- $comment_num = ArticleComment::where([['t.is_deleted','=',0],['i.user_id','=',$this->user_id],['t.user_id','<>',$this->user_id],['is_read','=',0],['t.pid','=',0]])
- ->leftJoin('ArticleItem i','t.item_id = i.id')
- ->alias('t')->count();
-
- $all_comment = ArticleComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
- $reply_num = $all_comment ? ArticleComment::where([['t.is_deleted','=',0],['t.to_deleted','=',0],['t.user_id','<>',$this->user_id],['t.lev','>=',2],['is_read','=',0],['t.pid','in',implode(',',$all_comment)]])->alias('t')->count() : 0;
-
- $all_article = ArticleItem::where('user_id',$this->user_id)->where('is_deleted',0)->column('id');
- $article_praise_num = ArticleLike ::where([['is_read','=',0],['item_id','in',$all_article],['user_id','<>',$this->user_id]])->count();
- $comment_praise_num = ArticleCommentLike::where([['is_read','=',0],['like_id','in',$all_comment],['user_id','<>',$this->user_id]])->count();
- $praise_num = $article_praise_num + $comment_praise_num;
- $follow_num = UserMessage::getUnreadNum($this->user_id,'article',5);
- $this->success('ok',compact(['reply_num','comment_num','praise_num','article_praise_num','comment_praise_num','follow_num']));
- }
-
- public function unreadChange()
- {
- $type = input('post.type',1);
- $id = input('post.id');
- $where = [];
- switch ($type) {
- case 1:
- ArticleComment::where([['i.user_id','=',$this->user_id],['t.pid','=',0]])
- ->when($id ,function ($query)use ($id){
- if($id) return $query->where('t.id','in',$id);
- })->leftJoin('ArticleItem i','t.item_id = i.id')
- ->alias('t')->update(['source_read'=>input('post.is_read'),'is_read'=>input('post.is_read')]);
- break;
- case 2:
- $all_comment = ArticleComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
- ArticleComment::where([['t.pid','in',implode(',',$all_comment)]])
- ->when($id ,function ($query)use ($id){
- if($id) return $query->where('t.id','in',$id);
- })->alias('t')->update(['is_read'=>input('post.is_read')]);
- break;
- case 3:
- $where[] = ['user_id','=',$this->user_id];
- if($id) $where[] = ['id','in',$id];
- UserMessage::where($where)->update(['is_read'=>input('post.is_read')]);
- break;
- case 4:
- $all_article = ArticleItem::where('user_id',$this->user_id)->where('is_deleted',0)->column('id');
- ArticleLike::where([['is_read','=',0],['item_id','in',$all_article]])->update(['is_read'=>1]);
- break;
- case 5:
- $all_comment = ArticleComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
- ArticleCommentLike ::where([['is_read','=',0],['like_id','in',$all_comment]])->update(['is_read'=>1]);
- break;
- }
- $this->success('消息变更成功');
- }
-
- public function batchesDel(){
- $type = input('post.type',1);
- $del_where = [];
- $del_where[] = ['id','in',input('post.id')];
- if(in_array($type,[1,3,4,5,6,7,8,9])) $del_where[] = ['user_id','=',$this->user_id];
- if(in_array($type,[1,3])) ArticleComment::where($del_where)->update(['is_deleted'=>1]);
- if(in_array($type,[2])) ArticleComment::where($del_where)->update(['source_deleted'=>1,'source_read'=>1,'is_read'=>1]);
- if(in_array($type,[10])) ArticleComment::where($del_where)->update(['to_deleted'=>1,'is_read'=>1]);
- if(in_array($type,[4])) UserLearn::where($del_where)->update(['is_deleted'=>1]);
- if(in_array($type,[5])) UserArticle::where($del_where)->update(['is_deleted'=>1]);
- if(in_array($type,[6])) PlatformSwitch::where($del_where)->delete();
- if(in_array($type,[7])) UserMessage::where($del_where)->update(['is_deleted'=>1]);
- if(in_array($type,[8])) ArticleLike::where($del_where)->delete();
- if(in_array($type,[11])) ArticleLike::where($del_where)->update(['to_deleted'=>1,'is_read'=>1]);
- if(in_array($type,[9])) ArticleCommentLike::where($del_where)->delete();
- if(in_array($type,[12])) ArticleCommentLike::where($del_where)->update(['to_deleted'=>1,'is_read'=>1]);
- if(in_array($type,[13])) UserCollect::where($del_where)->delete();
- $this->success('操作成功');
- }
-
- public function praiseMyArticleList()
- {
- $all_list = ArticleItem::where('user_id',$this->user_id)->where('is_deleted',0)->column('id');
- $user_info = $this->userInfo('name,headimg');
- $list = ArticleLike::where([['l.item_id','in',$all_list],['l.to_deleted','=',0],['l.user_id','<>',$this->user_id]])
- ->alias('l')
- ->field('l.id,l.user_id,m.name user_name,m.headimg,l.create_at,v.cover,v.title,v.read_num,x.title series_title,v.article_id,l.item_id')
- ->leftJoin('StoreMember m','m.id = l.user_id')
- ->leftJoin('ArticleItem v','v.id = l.item_id')
- ->leftJoin('ArticleIntro x','x.id = v.article_id')
- ->limit($this->off_set,$this->page_num)
- ->select()->toArray();
- array_walk($list,function (&$v,$k)use ($user_info){
- $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
- $v['app_name'] = $user_info['name'] ;
- $v['app_logo'] = $user_info['headimg'];
- $v['read_num'] = numTransform($v['read_num']);
- });
- $total_num = ArticleLike::where([['item_id','in',$all_list],['l.to_deleted','=',0],['l.user_id','<>',$this->user_id]])
- ->alias('l')
- ->leftJoin('StoreMember m','m.id = l.user_id')
- ->leftJoin('ArticleItem v','v.id = l.item_id')
- ->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
-
- public function praiseMyComment()
- {
- $user_info = $this->userInfo('name,headimg');
- $list = ArticleCommentLike::where([['c.user_id','=',$this->user_id],['l.to_deleted','=',0],['l.user_id','<>',$this->user_id]])
- ->alias('l')
- ->field('l.id,l.user_id,l.like_id,m.name user_name,m.headimg,l.create_at,v.cover,c.content,v.title,v.read_num,x.title series_title,v.article_id,c.item_id,v.user_id buid')
- ->leftJoin('StoreMember m','m.id = l.user_id')
- ->leftJoin('ArticleComment c','c.id = l.like_id')
- ->leftJoin('ArticleItem v','v.id = c.item_id')
- ->leftJoin('ArticleIntro x','x.id = v.article_id')
- ->order('l.id desc')
- ->limit($this->off_set,$this->page_num)
- ->select()->toArray();
- array_walk($list,function (&$v,$k)use ($user_info){
- $v['self_name'] = $user_info['name'] ;
- $article_auth = ArticleItem::getArticleAuth($v['buid'],APPNAME,APPLOGO);
- $v['app_name'] = $article_auth['app_name'];
- $v['app_logo'] = $article_auth['app_logo'];
- $v['read_num'] = numTransform($v['read_num']);
- $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
- });
- $total_num = ArticleCommentLike::where([['c.user_id','=',$this->user_id],['l.to_deleted','=',0],['l.user_id','<>',$this->user_id]])
- ->alias('l')->leftJoin('StoreMember m','m.id = l.user_id')
- ->leftJoin('ArticleComment c','c.id = l.like_id')
- ->leftJoin('ArticleItem v','v.id = c.item_id')->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
- }
|