123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101 |
- <?php
- namespace app\common\model;
- use think\facade\Db;
- class Article extends BaseModel
- {
- public $page_info;
-
- public function getArticleList($condition,$pagesize='',$order='article_sort asc,article_time desc'){
- if ($pagesize) {
- $result = Db::name('article')->where($condition)->order($order)->paginate(['list_rows'=>$pagesize,'query' => request()->param()],false);
- $this->page_info = $result;
- return $result->items();
- } else {
- return Db::name('article')->where($condition)->order($order)->limit(10)->select()->toArray();
- }
- }
-
- public function getJoinArticleList($where,$limit=0,$field='*',$order='article.article_sort'){
- $result = Db::name('article')->alias('article')->join('articleclass article_class','article.ac_id=article_class.ac_id','LEFT')->field($field)->where($where)->limit($limit)->order($order)->select()->toArray();
- return $result;
- }
-
- public function getOneArticle($condition){
- $result = Db::name('article')->where($condition)->find();
- return $result;
- }
-
- public function addArticle($data){
- $result = Db::name('article')->insertGetId($data);
- return $result;
- }
-
- public function editArticle($data,$article_id){
- $result = Db::name('article')->where(array('article_id'=>$article_id))->update($data);
- return $result;
- }
-
- public function delArticle($id){
- return Db::name('article')->where(array('article_id'=>$id))->delete();
- }
- }
|