1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192 |
- <?php
- namespace app\common\model;
- use think\facade\Db;
- class Activitydetail extends BaseModel
- {
- public $page_info;
-
- public function addActivitydetail($data){
- return Db::name('activitydetail')->insertGetId($data);
- }
-
- public function editActivitydetail($data,$condition){
- return Db::name('activitydetail')->where($condition)->update($data);
- }
-
- public function delActivitydetail($condition){
- return Db::name('activitydetail')->where($condition)->delete();
- }
-
- public function getActivitydetailList($condition,$pagesize='',$order='activitydetail_sort desc'){
- if ($pagesize) {
- $res = Db::name('activitydetail')->where($condition)->order($order)->paginate(['list_rows'=>$pagesize,'query' => request()->param()],false);
- $this->page_info = $res;
- return $res->items();
- }else{
- return Db::name('activitydetail')->where($condition)->order($order)->select()->toArray();
- }
- }
-
- public function getGoodsJoinList($condition,$pagesize='',$order='',$group=''){
- $field = 'activitydetail.*,goods.*';
- $res=Db::name('activitydetail')->alias('activitydetail')->join('goods goods','activitydetail.item_id=goods.goods_id')->field($field)->where($condition)->order($order);
- if($group){
- $res=$res->group($group);
- }
- if ($pagesize) {
- $res=$res->paginate(['list_rows'=>$pagesize,'query' => request()->param()],false);
- $this->page_info=$res;
- return $res->items();
- }else{
- return $res->select()->toArray();
- }
- }
- }
|