model = Db::name('user_money_log'); } /** * 列表 * @return void */ public function getList() { try { $status = $this->request->param('status',1);//状态:1待使用,2已失效 $userId = $this->auth->id; $companyId = $this->auth->company_id; $field = 'id,coupon_name,coupon_info,endtime,number,remain'; $where['user_id'] = $userId; $where['company_id'] = $companyId; $whereOr = []; if ($status == 1) { $where['remain'] = ['gt',0]; } else { $whereOr['remain'] = ['elt',0]; $whereOr['endtime'] = ['lt',time()]; } $result = $this->model->field($field)->where($where)->where(function($query) use ($whereOr){ $query->whereOr($whereOr); })->order('createtime desc')->autopage()->select(); if (!empty($result)) { foreach ($result as $key => &$value) { !empty($value['endtime']) && $value['endtime'] = date('Y.m.d H:i:s',$value['endtime']); } } $this->success('获取成功',$result); } catch (Exception $e) { $this->error($e->getMessage()); } } }