RegimentActive.php 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300
  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\Regiment;
  5. use App\Models\Product as Product;
  6. use Illuminate\Support\Facades\DB;
  7. /**
  8. * 拼团活动
  9. *
  10. * @author jun
  11. *
  12. */
  13. class RegimentActive extends Auth{
  14. protected function _initialize(){
  15. parent::_initialize();
  16. $this->assign('breadcrumb1','拼团活动');
  17. $this->assign('breadcrumb2','活动列表');
  18. }
  19. /**
  20. * 列表页
  21. *
  22. * */
  23. public function index(Model $Model){
  24. // 接收参数
  25. $name = request('name','');
  26. // 查询条件
  27. $map = [];
  28. // 组合条件
  29. if( $name ) $map[] = ['regiment_active.name','=',$name];
  30. // 查询数据
  31. $list = $Model->query()
  32. ->join('product','product.id','=','regiment_active.product_id')
  33. ->where($map)
  34. ->select(['regiment_active.*','product.name as product_name'])
  35. ->orderByDesc('regiment_active.id')
  36. ->paginate(config('page_num',10));
  37. // 循环处理数据
  38. foreach ($list as &$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['expiration'] = $expiration_hours;
  67. $data['start_time'] = request('start_time','');
  68. $data['end_time'] = request('end_time','');
  69. $data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : 0;
  70. $data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : 0;
  71. $data['participation_number'] = request('participation_number',0);
  72. $data['open_people'] = request('open_people',0);
  73. $data['partake_people'] = request('partake_people',0);
  74. $data['exceed_people'] = request('exceed_people',0);
  75. $data['automatic'] = request('automatic',0);
  76. $data['virtually'] = request('virtually',0);
  77. $data['status'] = 1;
  78. // 核对产品
  79. $product_res = $Model::query()->where([['status','=', 1],['product_id','=', $data['product_id']],['end_time','>=', time()]])->first();
  80. // 提示
  81. if ($product_res) return json_send(['code'=>'error','msg'=>'该产品正在参加拼团活动']);
  82. // 写入数据表
  83. $id = $Model->add($data);
  84. // 如果操作失败
  85. if( !$id ) return json_send(['code'=>'error','msg'=>'新增失败']);
  86. //商户开团
  87. if ($data['automatic'] == 1 ) {
  88. // 开团信息
  89. $regimentData = [
  90. 'custom_uid' => 0,
  91. 'active_id' => $id,
  92. 'product_id' => $data['product_id'],
  93. 'status' => 1,
  94. 'start_time' => $data['start_time'],
  95. 'end_time' => $data['start_time'] + $data['expiration']*60*60,
  96. 'update_time' => time(),
  97. 'insert_time' => time(),
  98. ];
  99. // 开团
  100. $regimentRes = Regiment::query()->insert($regimentData);
  101. // 开团结果
  102. if (!$regimentRes) return json_send(['code'=>'error','msg'=>'商户开团失败']);
  103. }
  104. // 记录行为
  105. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,1,[],$data);
  106. // 告知结果
  107. return json_send(['code'=>'success','msg'=>'新增成功','action'=>'add']);
  108. }
  109. // 标签列表
  110. $tagList = [];
  111. $cityList = [];
  112. // 分配数据
  113. $this->assign('cityList',$cityList);
  114. $this->assign('tagList',$tagList);
  115. $this->assign('crumbs','新增');
  116. // 加载模板
  117. return $this->fetch();
  118. }
  119. /**
  120. * 修改
  121. *
  122. * */
  123. public function edit(Request $request,Model $Model,Product $Product,Regiment $Regiment){
  124. // 接收参数
  125. $id = request('id',0);
  126. // 查询用户
  127. $oldData = $Model->where(['id'=>$id])->first()->toArray();
  128. // 修改
  129. if(request()->isMethod('post')) {
  130. // 验证参数
  131. $request->scene('edit')->validate();
  132. // 接收数据
  133. $product_code = request('product_code','');
  134. $data['product_id'] = $Product->codeToId($product_code);
  135. if (!$data['product_id']) return json_send(['code'=>'error','msg'=>'产品不存在']);
  136. $data['regiment_price'] = request('regiment_price',0);
  137. $data['quota'] = request('quota','');
  138. $data['name'] = request('name','');
  139. $data['number'] = request('number',0);
  140. $expiration_day = request('expiration_day',0);
  141. $expiration_hours = request('expiration_hours',0);
  142. $data['expiration'] = $expiration_day * 24 + $expiration_hours;
  143. $data['start_time'] = request('start_time','');
  144. $data['end_time'] = request('end_time','');
  145. $data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : 0;
  146. $data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : 0;
  147. $data['participation_number'] = request('participation_number',0);
  148. $data['open_people'] = request('open_people',0);
  149. $data['partake_people'] = request('partake_people',0);
  150. $data['exceed_people'] = request('exceed_people',0);
  151. $data['automatic'] = request('automatic',0);
  152. $data['virtually'] = request('virtually',0);
  153. $data['status'] = 1;
  154. // 核对产品
  155. $product_res = $Model::query()->where([['status','=', 1],['product_id','=', $data['product_id']],['end_time','>=', time()]])->first();
  156. // 提示
  157. if ($product_res) return json_send(['code'=>'error','msg'=>'该产品正在参加拼团活动']);
  158. // 写入数据表
  159. $id = $Model->add($data);
  160. // 如果操作失败
  161. if( !$id ) return json_send(['code'=>'error','msg'=>'新增失败']);
  162. //商户开团
  163. if ($data['automatic'] == 1 ) {
  164. // 开团信息
  165. $regimentData = [
  166. 'custom_uid' => 0,
  167. 'active_id' => $id,
  168. 'product_id' => $data['product_id'],
  169. 'status' => 1,
  170. 'start_time' => $data['start_time'],
  171. 'end_time' => $data['start_time'] + $data['expiration']*60*60,
  172. 'update_time' => time(),
  173. 'insert_time' => time(),
  174. ];
  175. // 开团
  176. $regimentRes = Regiment::query()->insert($regimentData);
  177. // 开团结果
  178. if (!$regimentRes) return json_send(['code'=>'error','msg'=>'商户开团失败']);
  179. }
  180. // 记录行为
  181. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,$data);
  182. // 告知结果
  183. return json_send(['code'=>'success','msg'=>'修改成功','action'=>'edit']);
  184. }
  185. // 错误告知
  186. if( !$oldData ) return $this->error('查无数据');
  187. // 返回结果
  188. $oldData['product_code'] = $Product->idToCode($oldData['product_id']);
  189. $this->assign('oldData',$oldData);
  190. $this->assign('crumbs','修改');
  191. // 加载模板
  192. return $this->fetch();
  193. }
  194. /**
  195. * 修改状态
  196. *
  197. * */
  198. public function set_status(Request $request,Model $Model){
  199. // 验证参数
  200. $request->scene('set_status')->validate();
  201. // 设置状态
  202. $id = request('id',0);
  203. $status = request('status',0);
  204. // 查询用户
  205. $oldData = $Model->where(['id'=>$id])->first();
  206. // 如果用户不存在
  207. if( !$oldData ) return json_send(['code'=>'error','msg'=>'数据不存在']);
  208. // 执行修改
  209. $result = $Model->edit($id,['status'=>$status]);
  210. // 提示新增失败
  211. if( !$result ) return json_send(['code'=>'error','msg'=>'设置失败']);
  212. // 记录行为
  213. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,['status'=>$status]);
  214. // 告知结果
  215. return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
  216. }
  217. /**
  218. * 复制
  219. *
  220. * */
  221. public function copy(Request $request,Model $Model,Product $Product){
  222. // 接收参数
  223. $id = request('id',0);
  224. // 查询用户
  225. $oldData = $Model->where(['id'=>$id])->first()->toArray();
  226. // 修改
  227. if(request()->isMethod('post')) {
  228. // 验证参数
  229. $request->scene('edit')->validate();
  230. // 接收数据
  231. $product_code = request('product_code','');
  232. $data['product_id'] = $Product->codeToId($product_code);
  233. if (!$data['product_id']) return json_send(['code'=>'error','msg'=>'产品不存在']);
  234. $data['regiment_price'] = request('regiment_price',0);
  235. $data['quota'] = request('quota','');
  236. $data['name'] = request('name','');
  237. $data['number'] = request('number',0);
  238. $expiration_day = request('expiration_day',0);
  239. $expiration_hours = request('expiration_hours',0);
  240. $data['expiration'] = $expiration_day * 24 + $expiration_hours;
  241. $data['start_time'] = request('start_time','');
  242. $data['end_time'] = request('end_time','');
  243. $data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : 0;
  244. $data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : 0;
  245. $data['participation_number'] = request('participation_number',0);
  246. $data['open_people'] = request('open_people',0);
  247. $data['partake_people'] = request('partake_people',0);
  248. $data['exceed_people'] = request('exceed_people',0);
  249. $data['automatic'] = request('automatic',0);
  250. $data['virtually'] = request('virtually',0);
  251. // 核对产品
  252. $product_res = $Model::query()->where([['status','=', 1],['product_id','=', $data['product_id']],['end_time','>=', time()]])->first();
  253. // 提示
  254. if ($product_res) return json_send(['code'=>'error','msg'=>'该产品正在参加拼团活动']);
  255. // 写入数据表
  256. $result = $Model->add($data);
  257. // 如果操作失败
  258. if( !$result ) return json_send(['code'=>'error','msg'=>'复制失败']);
  259. //商户开团
  260. if ($data['automatic'] == 1 ) {
  261. // 开团信息
  262. $regimentData = [
  263. 'custom_uid' => 0,
  264. 'active_id' => $id,
  265. 'product_id' => $data['product_id'],
  266. 'status' => 1,
  267. 'start_time' => $data['start_time'],
  268. 'end_time' => $data['start_time'] + $data['expiration']*60*60,
  269. 'update_time' => time(),
  270. 'insert_time' => time(),
  271. ];
  272. // 开团
  273. $regimentRes = Regiment::query()->insert($regimentData);
  274. // 开团结果
  275. if (!$regimentRes) return json_send(['code'=>'error','msg'=>'商户开团失败']);
  276. }
  277. // 记录行为
  278. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,$data);
  279. // 告知结果
  280. return json_send(['code'=>'success','msg'=>'复制成功','action'=>'edit']);
  281. }
  282. // 错误告知
  283. if( !$oldData ) return $this->error('查无数据');
  284. // 返回结果
  285. $oldData['product_code'] = $Product->idToCode($oldData['product_id']);
  286. $this->assign('oldData',$oldData);
  287. $this->assign('crumbs','修改');
  288. // 加载模板
  289. return $this->fetch();
  290. }
  291. }