RegimentActive.php 9.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229
  1. <?php namespace App\Http\Controllers\Admin;
  2. use App\Http\Requests\Admin\RegimentActive as Request;
  3. use App\Models\RegimentActive as Model;
  4. use App\Models\Product as Product;
  5. use Illuminate\Support\Facades\DB;
  6. /**
  7. * 拼团活动
  8. *
  9. * @author jun
  10. *
  11. */
  12. class RegimentActive extends Auth{
  13. protected function _initialize(){
  14. parent::_initialize();
  15. $this->assign('breadcrumb1','拼团活动');
  16. $this->assign('breadcrumb2','拼团活动列表');
  17. }
  18. /**
  19. * 列表页
  20. *
  21. * */
  22. public function index(Model $Model){
  23. // 接收参数
  24. $name = request('name','');
  25. // 查询条件
  26. $map = [];
  27. // 组合条件
  28. if( $name ) $map[] = ['regiment_active.name','=',$name];
  29. $select = ['regiment_active.*','product.name as product_name'];
  30. // 查询数据
  31. $list = $Model->query()
  32. ->join('product','product.id','=','regiment_active.product_id')
  33. ->where($map)
  34. ->select($select)
  35. ->orderByDesc('regiment_active.id')
  36. ->paginate(config('page_num',10));
  37. // 循环处理数据
  38. foreach ($list as $key => &$value) {
  39. $value['code'] = $Model->idToCode($value['id']);
  40. }
  41. // 分配数据
  42. $this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
  43. $this->assign('list',$list);
  44. // 加载模板
  45. return $this->fetch();
  46. }
  47. /**
  48. * 添加
  49. *
  50. * */
  51. public function add(Request $request, Model $Model, Product $Product){
  52. if( request()->isMethod('post') ){
  53. // 验证参数
  54. $request->scene('add')->validate();
  55. // 接收数据
  56. $product_code = request('product_code','');
  57. $data['product_id'] = $Product->codeToId($product_code);
  58. if (!$data['product_id']) return json_send(['code'=>'error','msg'=>'产品不存在']);
  59. $data['regiment_price'] = request('regiment_price',0);
  60. $data['quota'] = request('quota','');
  61. $data['name'] = request('name','');
  62. $data['number'] = request('number',0);
  63. $expiration_day = request('expiration_day',0);
  64. $expiration_hours = request('expiration_hours',0);
  65. $data['expiration'] = $expiration_day * 24 + $expiration_hours;
  66. $data['start_time'] = request('start_time','');
  67. $data['end_time'] = request('end_time','');
  68. $data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : 0;
  69. $data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : 0;
  70. $data['participation_number'] = request('participation_number',0);
  71. $data['open_people'] = request('open_people',1);
  72. $data['partake_people'] = request('partake_people',1);
  73. $data['exceed_people'] = request('exceed_people',1);
  74. $data['automatic'] = request('automatic',1);
  75. $data['virtually'] = request('virtually',1);
  76. $data['status'] = 1;
  77. $where = [
  78. ['status','=', 1],
  79. ['product_id','=', $data['product_id']],
  80. ['end_time','>=', time()]
  81. ];
  82. $product_res = $Model::query()->where($where)->first();
  83. if ($product_res) return json_send(['code'=>'error','msg'=>'该产品正在参加拼团活动']);
  84. // 写入数据表
  85. $id = $Model->add($data);
  86. // 如果操作失败
  87. if( !$id ) return json_send(['code'=>'error','msg'=>'新增失败']);
  88. // 记录行为
  89. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,1,[],$data);
  90. // 告知结果
  91. return json_send(['code'=>'success','msg'=>'新增成功','action'=>'add']);
  92. }
  93. // 标签列表
  94. $tagList = [];
  95. $cityList = [];
  96. // 分配数据
  97. $this->assign('cityList',$cityList);
  98. $this->assign('tagList',$tagList);
  99. $this->assign('crumbs','新增');
  100. // 加载模板
  101. return $this->fetch();
  102. }
  103. /**
  104. * 修改
  105. *
  106. * */
  107. public function edit(Request $request,Model $Model,Product $Product){
  108. // 接收参数
  109. $id = request('id',0);
  110. // 查询用户
  111. $oldData = $Model->where(['id'=>$id])->first()->toArray();
  112. // 修改
  113. if(request()->isMethod('post')){
  114. // 验证参数
  115. $request->scene('edit')->validate();
  116. // 接收数据
  117. $product_code = request('product_code','');
  118. $data['product_id'] = $Product->codeToId($product_code);
  119. if (!$data['product_id']) return json_send(['code'=>'error','msg'=>'产品不存在']);
  120. $data['regiment_price'] = request('regiment_price',0);
  121. $data['quota'] = request('quota','');
  122. $data['name'] = request('name','');
  123. $data['number'] = request('number',0);
  124. $expiration_day = request('expiration_day',0);
  125. $expiration_hours = request('expiration_hours',0);
  126. $data['expiration'] = $expiration_day * 24 + $expiration_hours;
  127. $data['start_time'] = request('start_time','');
  128. $data['end_time'] = request('end_time','');
  129. $data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : 0;
  130. $data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : 0;
  131. $data['participation_number'] = request('participation_number',0);
  132. $data['open_people'] = request('open_people',1);
  133. $data['partake_people'] = request('partake_people',1);
  134. $data['exceed_people'] = request('exceed_people',1);
  135. $data['automatic'] = request('automatic',1);
  136. $data['virtually'] = request('virtually',1);
  137. // 写入数据表
  138. $result = $Model->edit($id,$data);
  139. // 如果操作失败
  140. if( !$result ) return json_send(['code'=>'error','msg'=>'修改失败']);
  141. // 记录行为
  142. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,$data);
  143. // 告知结果
  144. return json_send(['code'=>'success','msg'=>'修改成功','action'=>'edit']);
  145. }
  146. // 错误告知
  147. if( !$oldData ) return $this->error('查无数据');
  148. $oldData['product_code'] = $Product->idToCode($oldData['product_id']);
  149. $this->assign('oldData',$oldData);
  150. $this->assign('crumbs','修改');
  151. // 加载模板
  152. return $this->fetch();
  153. }
  154. /**
  155. * 修改状态
  156. *
  157. * */
  158. public function set_status(Request $request,Model $Model){
  159. // 验证参数
  160. $request->scene('set_status')->validate();
  161. // 设置状态
  162. $id = request('id',0);
  163. $status = request('status',0);
  164. // 查询用户
  165. $oldData = $Model->where(['id'=>$id])->first();
  166. // 如果用户不存在
  167. if( !$oldData ) return json_send(['code'=>'error','msg'=>'数据不存在']);
  168. // 执行修改
  169. $result = $Model->edit($id,['status'=>$status]);
  170. // 提示新增失败
  171. if( !$result ) return json_send(['code'=>'error','msg'=>'设置失败']);
  172. // 记录行为
  173. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,['status'=>$status]);
  174. // 告知结果
  175. return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
  176. }
  177. /**
  178. * 复制
  179. *
  180. * */
  181. public function copy(Request $request,Model $Model,Clockin $Clockin){
  182. // 验证参数
  183. $request->scene('copy')->validate();
  184. // 设置状态
  185. $id = request('id',0);
  186. $time = time();
  187. // 查询
  188. $data = $Model->where(['id'=>$id])->first()->toArray();
  189. if (!$data) json_send(['code'=>'error','msg'=>'复制失败,活动不存在']);
  190. $clockinList = $Clockin->getActiveList($id);
  191. DB::beginTransaction();
  192. try {
  193. unset($data['id']);
  194. $data['status'] = 1;
  195. $data['name'] = $data['name'].'复制';
  196. //复制活动
  197. $newId = $Model->add($data);
  198. if (!$newId){
  199. DB::rollBack();
  200. return json_send(['code'=>'error','msg'=>'复制失败']);
  201. }
  202. if ($clockinList){
  203. foreach ($clockinList as &$clockin){
  204. $clockin['active_id'] = $newId;
  205. $clockin['insert_time'] = $time;
  206. $clockin['update_time'] = $time;
  207. unset($clockin['id']);
  208. }
  209. $re = $Clockin->Query()->insert($clockinList);
  210. if (!$re) return json_send(['code'=>'error','msg'=>'复制失败']);
  211. }
  212. DB::commit();
  213. }catch (\Exception $e){
  214. // 回退数据
  215. DB::rollBack();
  216. // 失败提示
  217. return json_send(['code'=>'error','msg'=>'复制失败','data'=>['error'=>$e->getMessage().$e->getLine()]]);
  218. }
  219. return json_send(['code'=>'success','msg'=>'复制成功','path'=>'']);
  220. }
  221. }