assign('breadcrumb1','拼团活动');
$this->assign('breadcrumb2','活动列表');
}
/**
* 列表页
*
* */
public function index(Model $Model){
// 接收参数
$code = request('code','');
$name = request('name','');
$productName = request('product_name','');
$status = request('status','');
$start_time = request('start_time','');
$end_time = request('end_time','');
// 查询条件
$map = [];
// 组合条件
if( $name ) $map[] = ['regiment_active.name','=',$name];
if( $code ){
$id = $Model->codeToId($code);
$map[] = ['regiment_active.id','=',$id];
}
if( $productName ) $map[] = ['product.name','=',$productName];
if( $status ) $map[] = ['regiment_active.status','=',$status];
if( $start_time ) {
$start_time = strtotime($start_time);
$map[] = ['regiment_active.start_time','>=',$start_time];
}
if( $end_time ) {
$end_time = strtotime($end_time);
$map[] = ['regiment_active.end_time','<=',$end_time];
}
// 当前登录的角色数据
$session = session('userRule') ? session('userRule') : ['business_id'=>0,'menu_type'=>0,'data_type'=>0];
// 是否存在对应的商业公司ID
if ( $session['business_id'] ) $map[] = ['regiment_active.business_id','=',$session['business_id']];
// 数据类型
$shopIds = ($session['menu_type'] == 1 && $session['data_type'] == 2) ? Business::query()->where('leader_uid',$session['admin_uid'])->pluck('id')->toArray() : [];
// 查询数据
$list = $Model->query()
->join('product','product.id','=','regiment_active.product_id');
if ( $shopIds ) $list->whereIn('regiment_active.business_id',$shopIds);
$list = $list->where($map)
->select(['regiment_active.*','product.name as product_name'])
->orderByDesc('regiment_active.id')
->paginate(config('page_num',10));
// 循环处理数据
foreach ($list as &$value) {
$value['code'] = $Model->idToCode($value['id']);
$value['business_name'] = Business::query()->where([['id','=',$value['business_id']]])->value('name');
}
// 分配数据
$this->assign('empty', '
~~暂无数据 |
');
$this->assign('list',$list);
// 加载模板
return $this->fetch();
}
/**
* 添加
*
* */
public function add(Request $request, Model $Model, Product $Product,Business $Business){
if( request()->isMethod('post') ){
// 验证参数
$request->scene('add')->validate();
// 接收数据
$product_code = request('product_code','');
$data['product_id'] = $Product->codeToId($product_code);
if (!$data['product_id']) return json_send(['code'=>'error','msg'=>'产品不存在']);
$data['regiment_price'] = request('regiment_price',0);
$data['quota'] = request('quota','');
$data['name'] = request('name','');
$data['number'] = request('number',0);
$expiration_hours = request('expiration_hours',0);
//$data['expiration'] = $expiration_day * 24 + $expiration_hours;
$data['expiration'] = $expiration_hours;
$data['start_time'] = request('start_time','');
$data['end_time'] = request('end_time','');
$data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : 0;
$data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : 0;
$data['participation_number'] = request('participation_number',0);
$data['open_people'] = request('open_people',0);
$data['partake_people'] = request('partake_people',0);
$data['exceed_people'] = request('exceed_people',0);
$data['automatic'] = request('automatic',0);
$data['virtually'] = request('virtually',0);
$data['business_id'] = request('business_id',0);
$data['status'] = 1;
// 核对产品
$product_res = $Model->query()->where([['status','=', 1],['product_id','=', $data['product_id']],['end_time','>=', time()]])->first();
// 提示
if ($product_res) return json_send(['code'=>'error','msg'=>'该产品正在参加拼团活动']);
// 核对产品
$product_res = $Product->query()->where([['business_id','=', $data['business_id']],['id','=', $data['product_id']]])->first();
if (!$product_res) return json_send(['code'=>'error','msg'=>'该店铺产品不存在']);
//核对产品价格
$productInfo = $Product->getOne($data['product_id']);
// 如果拼团价格大于产品价格
if ($productInfo['price'] < $data['regiment_price']) return json_send(['code'=>'error','msg'=>'拼团价格不能大于产品价格']);
// 写入数据表
$id = $Model->add($data);
// 如果操作失败
if( !$id ) return json_send(['code'=>'error','msg'=>'新增失败']);
//商户开团
if ($data['automatic'] == 1 ) {
// 开团信息
$regimentData = [
'custom_uid' => 0,
'active_id' => $id,
'product_id' => $data['product_id'],
'status' => 0,
'start_time' => $data['start_time'],
'end_time' => $data['start_time'] + $data['expiration']*60*60,
'update_time' => time(),
'insert_time' => time(),
];
// 开团
$regimentRes = Regiment::query()->insert($regimentData);
// 开团结果
if (!$regimentRes) return json_send(['code'=>'error','msg'=>'商户开团失败']);
}
// 记录行为
$this->addAdminHistory(admin('uid'),$Model->getTable(),$id,1,[],$data);
// 告知结果
return json_send(['code'=>'success','msg'=>'新增成功','action'=>'add']);
}
// 标签列表
$tagList = [];
$cityList = [];
$businessList = $Business->getList();
// 分配数据
$this->assign('cityList',$cityList);
$this->assign('tagList',$tagList);
$this->assign('businessList',$businessList);
$this->assign('crumbs','新增');
// 加载模板
return $this->fetch();
}
/**
* 修改
*
* */
public function edit(Request $request,Model $Model,Product $Product,Business $Business){
// 接收参数
$id = request('id',0);
// 查询用户
$oldData = $Model->where(['id'=>$id])->first()->toArray();
// 修改
if(request()->isMethod('post')) {
// 验证参数
$request->scene('edit')->validate();
// 接收数据
$product_code = request('product_code','');
$data['product_id'] = $Product->codeToId($product_code);
if (!$data['product_id']) return json_send(['code'=>'error','msg'=>'产品不存在']);
$data['regiment_price'] = request('regiment_price',0);
$data['quota'] = request('quota','');
$data['name'] = request('name','');
$data['number'] = request('number',0);
$expiration_day = request('expiration_day',0);
$expiration_hours = request('expiration_hours',0);
$data['expiration'] = $expiration_day * 24 + $expiration_hours;
$data['start_time'] = request('start_time','');
$data['end_time'] = request('end_time','');
$data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : 0;
$data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : 0;
$data['participation_number'] = request('participation_number',0);
$data['open_people'] = request('open_people',0);
$data['partake_people'] = request('partake_people',0);
$data['exceed_people'] = request('exceed_people',0);
$data['automatic'] = request('automatic',0);
$data['virtually'] = request('virtually',0);
$data['status'] = 1;
$data['business_id'] = request('business_id',0);
// 核对产品
$product_res = $Model::query()->where([['id','><', $id],['status','=', 1],['product_id','=', $data['product_id']],['end_time','>=', time()]])->first();
// 提示
if ($product_res) return json_send(['code'=>'error','msg'=>'该产品正在参加拼团活动']);
//核对产品价格
$productInfo = $Product->getOne($data['product_id']);
if ($productInfo['price'] < $data['regiment_price']) return json_send(['code'=>'error','msg'=>'拼团价格不能大于产品价格']);
// 写入数据表
$id = $Model->edit($id,$data);
// 如果操作失败
if( !$id ) return json_send(['code'=>'error','msg'=>'新增失败']);
//商户开团
if ($data['automatic'] == 1 ) {
// 开团信息
$regimentData = [
'custom_uid' => 0,
'active_id' => $id,
'product_id' => $data['product_id'],
'status' => 1,
'start_time' => $data['start_time'],
'end_time' => $data['start_time'] + $data['expiration']*60*60,
'update_time' => time(),
'insert_time' => time(),
];
//查询开团信息
$regimentIfo = Regiment::query()->where([['active_id','=',$id]])->first();
if (!$regimentIfo){
// 开团
$regimentRes = Regiment::query()->insert($regimentData);
// 开团结果
if (!$regimentRes) return json_send(['code'=>'error','msg'=>'商户开团失败']);
}
}
// 记录行为
$this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,$data);
// 告知结果
return json_send(['code'=>'success','msg'=>'修改成功','action'=>'edit']);
}
// 错误告知
if( !$oldData ) return $this->error('查无数据');
$businessList = $Business->getList();
// 返回结果
$oldData['product_code'] = $Product->idToCode($oldData['product_id']);
$this->assign('oldData',$oldData);
$this->assign('businessList',$businessList);
$this->assign('crumbs','修改');
// 加载模板
return $this->fetch();
}
/**
* 修改状态
*
* */
public function set_status(Request $request,Model $Model){
// 验证参数
$request->scene('set_status')->validate();
// 设置状态
$id = request('id',0);
$status = request('status',0);
// 查询用户
$oldData = $Model->where(['id'=>$id])->first();
// 如果用户不存在
if( !$oldData ) return json_send(['code'=>'error','msg'=>'数据不存在']);
// 执行修改
$result = $Model->edit($id,['status'=>$status]);
// 提示新增失败
if( !$result ) return json_send(['code'=>'error','msg'=>'设置失败']);
// 记录行为
$this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,['status'=>$status]);
// 告知结果
return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
}
/**
* 复制
*
* */
public function copy(Request $request,Model $Model,Product $Product){
// 接收参数
$id = request('id',0);
// 查询用户
$oldData = $Model->where(['id'=>$id])->first()->toArray();
// 修改
if(request()->isMethod('post')) {
// 验证参数
$request->scene('edit')->validate();
// 接收数据
$product_code = request('product_code','');
$data['product_id'] = $Product->codeToId($product_code);
if (!$data['product_id']) return json_send(['code'=>'error','msg'=>'产品不存在']);
$data['regiment_price'] = request('regiment_price',0);
$data['quota'] = request('quota','');
$data['name'] = request('name','');
$data['number'] = request('number',0);
$expiration_day = request('expiration_day',0);
$expiration_hours = request('expiration_hours',0);
$data['expiration'] = $expiration_day * 24 + $expiration_hours;
$data['start_time'] = request('start_time','');
$data['end_time'] = request('end_time','');
$data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : 0;
$data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : 0;
$data['participation_number'] = request('participation_number',0);
$data['open_people'] = request('open_people',0);
$data['partake_people'] = request('partake_people',0);
$data['exceed_people'] = request('exceed_people',0);
$data['automatic'] = request('automatic',0);
$data['virtually'] = request('virtually',0);
// 核对产品
$product_res = $Model::query()->where([['status','=', 1],['product_id','=', $data['product_id']],['end_time','>=', time()]])->first();
// 提示
if ($product_res) return json_send(['code'=>'error','msg'=>'该产品正在参加拼团活动']);
// 写入数据表
$result = $Model->add($data);
// 如果操作失败
if( !$result ) return json_send(['code'=>'error','msg'=>'复制失败']);
//商户开团
if ($data['automatic'] == 1 ) {
// 开团信息
$regimentData = [
'custom_uid' => 0,
'active_id' => $id,
'product_id' => $data['product_id'],
'status' => 1,
'start_time' => $data['start_time'],
'end_time' => $data['start_time'] + $data['expiration']*60*60,
'update_time' => time(),
'insert_time' => time(),
];
// 开团
$regimentRes = Regiment::query()->insert($regimentData);
// 开团结果
if (!$regimentRes) return json_send(['code'=>'error','msg'=>'商户开团失败']);
}
// 记录行为
$this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,$data);
// 告知结果
return json_send(['code'=>'success','msg'=>'复制成功','action'=>'edit']);
}
// 错误告知
if( !$oldData ) return $this->error('查无数据');
// 返回结果
$oldData['product_code'] = $Product->idToCode($oldData['product_id']);
$this->assign('oldData',$oldData);
$this->assign('crumbs','修改');
// 加载模板
return $this->fetch();
}
}