1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798 |
- <?php namespace App\Http\Controllers\Admin;
- use App\Models\Custom;
- use App\Models\CustomCoupon as Model;
- use App\Models\Coupon as Coupon;
- use App\Http\Requests\Admin\CustomCoupon as Request;
- /**
- * 优惠券管理
- *
- * @author 刘相欣
- *
- */
- class CustomCoupon extends Auth{
-
- protected function _initialize(){
- parent::_initialize();
- $this->assign('breadcrumb1','营销管理');
- $this->assign('breadcrumb2','客户优惠券');
- }
- /**
- * 首页列表
- *
- * */
- public function index(Model $Model,Coupon $Coupon,Custom $Custom){
- // 接受参数
- $code = request('coupon_code','');
- $customCode = request('custom_code','');
- $startTime = request('start_time','');
- $endTime = request('end_time','');
- $status = request('status');
- // 编码转ID
- $couponId = $code ? $Coupon->codeToId($code) : 0;
- $customUid = $customCode ? $Custom->codeToId($customCode) : 0;
- // 查询条件
- $map = [];
- // 编码ID
- if( $couponId ) $map[] = ['coupon.id','=',$couponId];
- if( $customUid ) $map[] = ['custom_coupon.custom_uid','=',$customUid];
- if( $startTime ) $map[] = ['custom_coupon.insert_time','>=',strtotime($startTime)];
- if( $endTime ) $map[] = ['custom_coupon.insert_time','<=',strtotime($endTime)];
- if( !is_null($status) ) $map[] = ['custom_coupon.status','=',$status];
- // 查询数据
- $list = $Model
- ->query()->join('coupon','custom_coupon.coupon_id','=','coupon.id')
- ->where($map)
- ->orderBy('custom_coupon.status')
- ->orderByDesc('custom_coupon.id')
- ->select(['custom_coupon.id','coupon.id as coupon_id','coupon.name as coupon_name','coupon.type_id','coupon.rebate_type','coupon.std_pay','coupon.rebate','custom_coupon.status','custom_coupon.custom_uid','custom_coupon.exp_time'])
- ->paginate(request('limit',config('page_num',10)))
- ->appends(request()->all());
- // 循环处理数据
- foreach ($list as $key => $value) {
- // id转编号
- $value['coupon_code']= $Coupon->idToCode($value['coupon_id']);
- // id转编号
- $value['custom_code'] = $Custom->idToCode($value['custom_uid']);
- // 如果过期时间
- if( $value['status'] == 0 && ( $value['exp_time']>0 && $value['exp_time']< time() ) ) {
- // 状态设置
- $Model->edit($value['id'],['status'=>3]);
- // 状态设置
- $value['status'] = 3;
- }
- // 重组
- $list[$key] = $value;
- }
- // 分配数据
- $this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
- $this->assign('list', $list);
- // 加载模板
- return $this->fetch();
- }
- /**
- * 状态
- *
- * */
- public function set_status( Request $request, Model $Model){
- // 验证参数
- $request->scene('set_status')->validate();
- // 接收参数
- $id = request('id',0);
- $status = request('status',0);
- // 查询数据
- $result = $Model->edit($id,['status'=>$status]);
- // 提示新增失败
- if( !$result ) return json_send(['code'=>'error','msg'=>'设置失败']);
- // 记录行为
- $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,[],['status'=>$status]);
- // 告知结果
- return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
- }
-
- }
|