123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131 |
- <?php
- namespace app\common\model;
- use think\facade\Db;
- class Complain extends BaseModel {
- public $page_info;
-
- public function getComplainCount($condition) {
- return Db::name('complain')->where($condition)->count();
- }
-
- public function addComplain($data) {
- return Db::name('complain')->insertGetId($data);
- }
-
- public function editComplain($update_array, $where_array) {
- return Db::name('complain')->where($where_array)->update($update_array);
- }
-
- public function delComplain($condition) {
- return Db::name('complain')->where($condition)->delete();
- }
-
- public function getComplainList($condition = '', $pagesize = '',$order='complain_id desc') {
- if ($pagesize) {
- $res = Db::name('complain')->where($condition)->order($order)->paginate(['list_rows'=>$pagesize,'query' => request()->param()],false);
- $this->page_info = $res;
- return $res->items();
- } else {
- return Db::name('complain')->where($condition)->order($order)->select()->toArray();
- }
- }
-
- public function getComplainGoodsList($complain_list) {
- $goods_ids = array();
- if (!empty($complain_list) && is_array($complain_list)) {
- foreach ($complain_list as $key => $value) {
- $goods_ids[] = $value['order_goods_id'];
- }
- }
- $res = Db::name('ordergoods')->where('rec_id','in',$goods_ids)->select()->toArray();
- return ds_change_arraykey($res, 'rec_id');
- }
-
- public function isComplainExist($condition = '') {
- $list = Db::name('complain')->where($condition)->select()->toArray();
- if (empty($list)) {
- return false;
- } else {
- return true;
- }
- }
-
- public function getOneComplain($complain_id) {
- return Db::name('complain')->where('complain_id',intval($complain_id))->find();
- }
- }
|