1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495 |
- <?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();
- }
- }
- }
|