Web.php 746 B

123456789101112131415161718192021222324
  1. <?php
  2. namespace app\controller\api;
  3. use crmeb\basic\BaseController;
  4. use think\facade\Db;
  5. class Web extends BaseController
  6. {
  7. public function article_list(){
  8. [$page, $limit] = $this->getPage();
  9. $query = Db::name('Article') -> where('cid',53) -> where('status',1) -> where('wechat_news_id',0);
  10. $count = $query -> count();
  11. $list = $query
  12. -> page($page,$limit)
  13. -> order('create_time desc')
  14. -> field('article_id,image_input,title,synopsis,create_time,author')
  15. -> select()
  16. -> each(function ($item){
  17. $item['synopsis'] = substr($item['synopsis'], 0, 80);
  18. });
  19. return app('json')->success(compact('count','list'));
  20. }
  21. }