ProductService.php 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782
  1. <?php
  2. namespace App\Service;
  3. use App\Model\BasicType;
  4. use App\Model\Employee;
  5. use App\Model\Product;
  6. use App\Model\ProductActivity;
  7. use App\Model\ProductActivityPrice;
  8. use App\Model\ProductCategory;
  9. use App\Model\ProductInfo;
  10. use App\Model\ProductIntroduction;
  11. use App\Model\ProductPriceDetail;
  12. use App\Model\SeeRange;
  13. use Illuminate\Support\Facades\DB;
  14. /**
  15. * 产品管理
  16. */
  17. class ProductService extends Service
  18. {
  19. /**
  20. * 产品分类编辑
  21. * @param $data
  22. * @param $user
  23. * @return array
  24. */
  25. public function productCategoryEdit($data,$user){
  26. list($status,$msg) = $this->productCategoryRule($data,$user,false);
  27. if(!$status) return [$status,$msg];
  28. $update = $msg['data'][0];
  29. $model = new ProductCategory();
  30. $model->where('id',$data['id'])->update($update);
  31. return [true,''];
  32. }
  33. /**
  34. * 产品分类新增
  35. * @param $data
  36. * @param $user
  37. * @return array
  38. */
  39. public function productCategoryAdd($data,$user){
  40. list($status,$msg) = $this->productCategoryRule($data,$user);
  41. if(!$status) return [$status,$msg];
  42. ProductCategory::insert($msg['data']);
  43. return [true,''];
  44. }
  45. /**
  46. * 产品分类删除
  47. * @param $data
  48. * @return array
  49. */
  50. public function productCategoryDel($data){
  51. if($this->isEmpty($data,'id')) return [false,'请选择数据!'];
  52. $bool = Product::where('del_time',0)
  53. ->where('product_category_id',$data['id'])
  54. ->exists();
  55. if($bool) return [false,'产品分类下已添加产品,操作失败'];
  56. try {
  57. DB::beginTransaction();
  58. ProductCategory::where('id',$data['id'])->update([
  59. 'del_time' => time()
  60. ]);
  61. DB::commit();
  62. }catch (\Exception $exception){
  63. DB::rollBack();
  64. return [false,$exception->getMessage()];
  65. }
  66. return [true,''];
  67. }
  68. /**
  69. * 产品分类列表
  70. * @param $data
  71. * @param $user
  72. * @return array
  73. */
  74. public function productCategoryList($data,$user){
  75. $model = ProductCategory::TopClear($user,$data);
  76. $model = $model->where('del_time',0)
  77. ->select('title','id','parent_id')
  78. ->orderby('id','desc');
  79. if(! empty($data['title'])) $model->where('title', 'LIKE', '%'.$data['title'].'%');
  80. $list = $model->get()->toArray();
  81. $list_tree = $list;
  82. if(! empty($list_tree)) {
  83. $list_tree = $this->makeTree(0,$list_tree);
  84. $list_tree = $this->set_sort_circle($list_tree);
  85. }
  86. return [200, ['data' => $list,'tree' => $list_tree]];
  87. }
  88. /**
  89. * 产品分类参数规则
  90. * @param $data
  91. * @param $is_add
  92. * @return array
  93. */
  94. public function productCategoryRule($data,$user, $is_add = true){
  95. if($this->isEmpty($data,'data')) return [false,'数据不能为空!'];
  96. //所属部门 以及 顶级部门
  97. if(empty($data['depart_id'])) $data['depart_id'] = $this->getDepart($user);
  98. $data['top_depart_id'] = $user['depart_map'][$data['depart_id']] ?? 0;
  99. $title = array_column($data['data'],'title');
  100. $title = array_map(function($val) {
  101. return $val !== null ? $val : 0;
  102. }, $title);
  103. $title_count = array_count_values($title);
  104. foreach ($title as $value){
  105. if(empty($value)) return [false,'名称不能为空!'];
  106. if($title_count[$value] > 1) return [false,'名称不能重复'];
  107. }
  108. foreach ($data['data'] as $key => $value){
  109. $data['data'][$key]['upd_time'] = time();
  110. if($is_add){
  111. $parent_id = 0;
  112. if(! empty($value['parent_id'])) {
  113. $bool = Product::where('del_time',0)
  114. ->where('product_category_id',$value['parent_id'])
  115. ->exists();
  116. if($bool) {
  117. $title = ProductCategory::where('id',$value['parent_id'])->select('title')->value('title');
  118. return [false,'产品分类:'. $title .'下已添加产品,不允许添加子分类'];
  119. }
  120. $parent_id = $value['parent_id'];
  121. }
  122. $data['data'][$key]['parent_id'] = $parent_id;
  123. $data['data'][$key]['crt_time'] = time();
  124. $data['data'][$key]['depart_id'] = $data['depart_id'];
  125. $data['data'][$key]['top_depart_id'] = $data['top_depart_id'];
  126. $bool = ProductCategory::where('title',$value['title'])
  127. ->where('top_depart_id',$data['top_depart_id'])
  128. ->where('del_time',0)
  129. ->exists();
  130. }else{
  131. if($this->isEmpty($data,'id')) return [false,'id不能为空!'];
  132. $top_depart_id = ProductCategory::where('id',$data['id'])->value('top_depart_id');
  133. $bool = ProductCategory::where('title',$value['title'])
  134. ->where('top_depart_id',$top_depart_id)
  135. ->where('id','<>',$data['id'])
  136. ->where('del_time',0)
  137. ->exists();
  138. }
  139. if($bool) return [false,'分类名称不能重复'];
  140. }
  141. return [true, $data];
  142. }
  143. /**
  144. * 产品编辑
  145. * @param $data
  146. * @param $user
  147. * @return array
  148. */
  149. public function productEdit($data,$user){
  150. list($status,$msg) = $this->productRule($data, $user, false);
  151. if(!$status) return [$status,$msg];
  152. try {
  153. DB::beginTransaction();
  154. $model = Product::where('id',$data['id'])->first();
  155. $model->product_category_id = $data['product_category_id'] ?? 0;
  156. $model->product_category = $data['product_category'] ?? '';
  157. $model->title = $data['title'];
  158. $model->code = $data['code'] ?? '';
  159. $model->warranty_time = $data['warranty_time'] ?? 0;
  160. $model->install_time = $data['install_time'] ?? 0;
  161. $model->size = $data['size'] ?? '';
  162. $model->unit = $data['unit'] ?? 0;
  163. $model->bar_code = $data['bar_code'] ?? '';
  164. $model->cost = $data['cost'] ?? 0;
  165. $model->retail_price = $data['retail_price'] ?? 0;
  166. $model->mark = $data['mark'] ?? '';
  167. $model->state = $data['state'] ?? 0;
  168. $model->save();
  169. $time = time();
  170. ProductIntroduction::where('product_id',$data['id'])
  171. ->where('del_time',0)
  172. ->update(['del_time' => $time]);
  173. if(! empty($data['introduction'])){
  174. $models = new ProductIntroduction();
  175. $models->product_id = $model->id;
  176. $models->introduction = $data['introduction'];
  177. $models->save();
  178. }
  179. ProductInfo::where('del_time',0)
  180. ->where('product_id',$data['id'])
  181. ->update(['del_time' => $time]);
  182. if(! empty($data['img'])){
  183. $insert = [];
  184. foreach ($data['img'] as $value){
  185. $insert[] = [
  186. 'product_id' => $model->id,
  187. 'file' => $value['url'],
  188. 'type' => ProductInfo::type_one,
  189. 'name' => $value['name'],
  190. 'crt_time' => $time,
  191. ];
  192. }
  193. ProductInfo::insert($insert);
  194. }
  195. if(! empty($data['file'])){
  196. $insert = [];
  197. foreach ($data['file'] as $value){
  198. $insert[] = [
  199. 'product_id' => $model->id,
  200. 'file' => $value['url'],
  201. 'type' => ProductInfo::type_two,
  202. 'name' => $value['name'],
  203. 'crt_time' => $time,
  204. ];
  205. }
  206. ProductInfo::insert($insert);
  207. }
  208. ProductPriceDetail::where('del_time',0)
  209. ->where('product_id',$data['id'])
  210. ->update(['del_time' => $time]);
  211. if(! empty($data['product_price'])){
  212. $insert = [];
  213. foreach ($data['product_price'] as $value){
  214. $insert[] = [
  215. 'product_id' => $model->id,
  216. 'basic_type_id' => $value['basic_type_id'],
  217. 'price' => $value['price'] ?? 0,
  218. 'crt_time' => $time,
  219. ];
  220. }
  221. ProductPriceDetail::insert($insert);
  222. }
  223. DB::commit();
  224. }catch (\Exception $exception){
  225. DB::rollBack();
  226. return [false,$exception->getMessage()];
  227. }
  228. return [true,''];
  229. }
  230. /**
  231. * 产品新增
  232. * @param $data
  233. * @param $user
  234. * @return array
  235. */
  236. public function productAdd($data,$user){
  237. list($status,$msg) = $this->productRule($data, $user);
  238. if(!$status) return [$status,$msg];
  239. try {
  240. DB::beginTransaction();
  241. $model = new Product();
  242. $model->product_category_id = $data['product_category_id'] ?? 0;
  243. $model->product_category = $data['product_category'] ?? '';
  244. $model->title = $data['title'];
  245. $model->code = $data['code'] ?? '';
  246. $model->warranty_time = $data['warranty_time'] ?? 0;
  247. $model->install_time = $data['install_time'] ?? 0;
  248. $model->size = $data['size'] ?? '';
  249. $model->unit = $data['unit'] ?? 0;
  250. $model->bar_code = $data['bar_code'] ?? '';
  251. $model->cost = $data['cost'] ?? 0;
  252. $model->retail_price = $data['retail_price'] ?? 0;
  253. $model->mark = $data['mark'] ?? '';
  254. $model->state = $data['state'] ?? 0;
  255. $model->crt_id = $user['id'];
  256. $model->depart_id = $data['depart_id'] ?? 0;
  257. $model->top_depart_id = $data['top_depart_id'] ?? 0;
  258. $model->save();
  259. $time = time();
  260. if(! empty($data['introduction'])){
  261. $models = new ProductIntroduction();
  262. $models->product_id = $model->id;
  263. $models->introduction = $data['introduction'];
  264. $models->save();
  265. }
  266. if(! empty($data['img'])){
  267. $insert = [];
  268. foreach ($data['img'] as $value){
  269. $insert[] = [
  270. 'product_id' => $model->id,
  271. 'file' => $value['url'],
  272. 'type' => ProductInfo::type_one,
  273. 'name' => $value['name'],
  274. 'crt_time' => $time,
  275. ];
  276. }
  277. ProductInfo::insert($insert);
  278. }
  279. if(! empty($data['file'])){
  280. $insert = [];
  281. foreach ($data['file'] as $value){
  282. $insert[] = [
  283. 'product_id' => $model->id,
  284. 'file' => $value['url'],
  285. 'type' => ProductInfo::type_two,
  286. 'name' => $value['name'],
  287. 'crt_time' => $time,
  288. ];
  289. }
  290. ProductInfo::insert($insert);
  291. }
  292. if(! empty($data['product_price'])){
  293. $insert = [];
  294. foreach ($data['product_price'] as $value){
  295. $insert[] = [
  296. 'product_id' => $model->id,
  297. 'basic_type_id' => $value['basic_type_id'],
  298. 'price' => $value['price'] ?? 0,
  299. 'crt_time' => $time,
  300. ];
  301. }
  302. ProductPriceDetail::insert($insert);
  303. }
  304. DB::commit();
  305. }catch (\Exception $exception){
  306. DB::rollBack();
  307. return [false,$exception->getMessage()];
  308. }
  309. return [true,''];
  310. }
  311. /**
  312. * 产品删除
  313. * @param $data
  314. * @return array
  315. */
  316. public function productDel($data){
  317. if($this->isEmpty($data,'id')) return [false,'请选择数据!'];
  318. try {
  319. DB::beginTransaction();
  320. $time = time();
  321. Product::where('del_time',0)->where('id',$data['id'])->update(['del_time' => $time]);
  322. ProductIntroduction::where('product_id',$data['id'])
  323. ->where('del_time',0)
  324. ->update(['del_time' => $time]);
  325. ProductInfo::where('del_time',0)
  326. ->where('product_id',$data['id'])
  327. ->update(['del_time' => $time]);
  328. ProductPriceDetail::where('del_time',0)
  329. ->where('product_id',$data['id'])
  330. ->update(['del_time' => $time]);
  331. (new RangeService())->RangeDelete($data['id'],SeeRange::type_four);
  332. DB::commit();
  333. }catch (\Exception $exception){
  334. DB::rollBack();
  335. return [false,$exception->getMessage()];
  336. }
  337. return [true,''];
  338. }
  339. /**
  340. * 产品详情
  341. * @param $data
  342. * @param $user
  343. * @return array
  344. */
  345. public function productDetail($data,$user){
  346. if($this->isEmpty($data,'id')) return [false,'请选择数据!'];
  347. $customer = Product::where('del_time',0)
  348. ->where('id',$data['id'])
  349. ->first();
  350. if(empty($customer)) return [false,'产品不存在或已被删除'];
  351. $customer = $customer->toArray();
  352. $customer['product_category'] = ! empty($customer['product_category']) ? json_decode($customer['product_category'],true): [];
  353. $category = ProductCategory::where('id',$customer['product_category_id'])
  354. ->value('title');
  355. $customer['product_category_title'] = $category;
  356. $customer['introduction'] = "";
  357. $in = ProductIntroduction::where('del_time',0)
  358. ->where('product_id',$data['id'])
  359. ->first();
  360. if(! empty($in)) $customer['introduction'] = $in->introduction;
  361. $model = BasicType::TopClear($user,$data);
  362. $basic = $model->where('del_time',0)
  363. ->where('type',22)
  364. ->select('title','id','type')
  365. ->orderby('id', 'asc')->get()->toArray();
  366. $detail = ProductPriceDetail::where('del_time',0)
  367. ->where('product_id',$data['id'])
  368. ->select('product_id','basic_type_id','price')
  369. ->get()->toArray();
  370. $title_map = BasicType::whereIn('id',array_unique(array_merge_recursive(array_column($detail,'basic_type_id'),array_column($basic,'id'))))
  371. ->pluck('title','id')
  372. ->toArray();
  373. //是否总公司
  374. $is_main = $user['is_all_depart'];
  375. $top_depart = $user['depart_top'][0] ?? [];
  376. $customer['is_edit'] = $customer['top_depart_id'] == $top_depart['depart_id'] ? 1 : 0;
  377. $customer['product_price'] = [];
  378. //展示金额
  379. foreach ($detail as $value){
  380. if(! $is_main && ($top_depart['basic_type_id'] != $value['basic_type_id'])) {
  381. $is_show = 0;
  382. }else{
  383. $is_show = 1;
  384. }
  385. $customer['product_price'][$value['basic_type_id']] = [
  386. 'basic_type_id' => $value['basic_type_id'],
  387. 'basic_type_title' => $title_map[$value['basic_type_id']] ?? '',
  388. 'price' => $value['price'],
  389. 'is_show' => $is_show,
  390. ];
  391. }
  392. foreach ($basic as $value){
  393. if(! $is_main && ($top_depart['basic_type_id'] != $value['id'])) {
  394. $is_show = 0;
  395. }else{
  396. $is_show = 1;
  397. }
  398. if(! isset($customer['product_price'][$value['id']])){
  399. $customer['product_price'][$value['id']] = [
  400. 'basic_type_id' => $value['id'],
  401. 'basic_type_title' => $title_map[$value['id']] ?? '',
  402. 'price' => 0,
  403. 'is_show' => $is_show,
  404. ];
  405. }
  406. }
  407. $customer['product_price'] = array_values($customer['product_price']);
  408. //单位
  409. $title = BasicType::where('id',$customer['unit'])->value('title');
  410. $customer['unit_name'] = $title;
  411. $customer['img'] = $customer['file'] = $customer['depart'] = $customer['employee'] = [];
  412. $customer_info = ProductInfo::where('del_time',0)
  413. ->where('product_id',$customer['id'])
  414. ->select('id','product_id','file','type','name')
  415. ->get()->toArray();
  416. foreach ($customer_info as $value){
  417. $tmp = [
  418. 'url' => $value['file'],
  419. 'name' => $value['name'],
  420. ];
  421. if($value['type'] == ProductInfo::type_one){
  422. $customer['img'][] = $tmp;
  423. }elseif ($value['type'] == ProductInfo::type_two){
  424. $customer['file'][] = $tmp;
  425. }
  426. }
  427. $customer['crt_name'] = Employee::where('id',$customer['crt_id'])->value('emp_name');
  428. $customer['crt_time'] = $customer['crt_time'] ? date("Y-m-d H:i:s",$customer['crt_time']): '';
  429. //可见范围
  430. $return = (new RangeService())->RangeDetail($data['id'],SeeRange::type_four);
  431. $customer['depart'] = $return[0] ?? [];
  432. $customer['employee'] = $return[1] ?? [];
  433. return [true, $customer];
  434. }
  435. /**
  436. * 产品列表
  437. * @param $data
  438. * @param $user
  439. * @return array
  440. */
  441. public function productList($data,$user){
  442. $model = Product::ProductClear($user,$data);
  443. $model = $model->where('del_time',0)
  444. ->select('title','id','product_category_id','code','size','unit','bar_code','retail_price','cost','state','crt_id','crt_time','mark','depart_id','top_depart_id','install_time')
  445. ->orderby('id', 'desc');
  446. if(! empty($data['title'])) $model->where('title', 'LIKE', '%'.$data['title'].'%');
  447. if(isset($data['state'])) $model->where('state', $data['state']);
  448. if(! empty($data['product_category_id'])) $model->where('product_category_id', $data['product_category_id']);
  449. if(! empty($data['product_category'])) {
  450. $product_category = ProductCategory::where('del_time',0)
  451. ->where('title', 'LIKE', '%'.$data['product_category'].'%')
  452. ->select('id')
  453. ->get()->toArray();
  454. $model->whereIn('product_category_id',array_unique(array_column($product_category,'id')));
  455. }
  456. if(! empty($data['code'])) $model->where('code', 'LIKE', '%'.$data['code'].'%');
  457. if(! empty($data['bar_code'])) $model->where('bar_code', 'LIKE', '%'.$data['bar_code'].'%');
  458. if(! empty($data['crt_time'][0]) && ! empty($data['crt_time'][1])) {
  459. $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);
  460. $model->where('crt_time','>=',$return[0]);
  461. $model->where('crt_time','<=',$return[1]);
  462. }
  463. $list = $this->limit($model,'',$data);
  464. $list = $this->fillData($list,$user,$data);
  465. return [true, $list];
  466. }
  467. public function productList2($data,$user){
  468. $model = ProductCategory::TopClear($user,$data);
  469. $model = $model->where('del_time',0)
  470. ->select('title','id','parent_id')
  471. ->orderby('id','desc');
  472. if(! empty($data['title'])) $model->where('title', 'LIKE', '%'.$data['title'].'%');
  473. $list = $model->get()->toArray();
  474. if(! empty($list)) {
  475. $productList = Product::where('del_time',0)
  476. ->whereIn('product_category_id',array_column($list,'id'))
  477. ->select('id','product_category_id','title','code')
  478. ->get()->toArray();
  479. $productMap = [];
  480. foreach ($productList as $value){
  481. $productMap[$value['product_category_id']][] = $value;
  482. }
  483. foreach ($list as $key => $value){
  484. if(isset($productMap[$value['id']])) $list[$key]['product'] = $productMap[$value['id']];
  485. }
  486. $list = $this->makeTree(0,$list);
  487. $list = $this->set_sort_circle($list);
  488. }
  489. return [200, $list];
  490. }
  491. /**
  492. * 产品参数规则
  493. * @param $data
  494. * @param $is_add
  495. * @return array
  496. */
  497. public function productRule(&$data, $user, $is_add = true){
  498. if(empty($data['title'])) return [false,'产品名称不能为空'];
  499. if(empty($data['product_category_id'])) return [false,'产品分类不能为空'];
  500. if(empty($data['code'])) return [false,'产品编码不能为空'];
  501. if(empty($data['cost'])) return [false,'成本不能为空'];
  502. $res = $this->checkNumber($data['cost']);
  503. if(! $res) return [false,'成本请输入不超过两位小数并且大于0的数值'];
  504. if(empty($data['retail_price'])) return [false,'零售价不能为空'];
  505. $res = $this->checkNumber($data['retail_price']);
  506. if(! $res) return [false,'零售价格请输入不超过两位小数并且大于0的数值'];
  507. if(! empty($data['product_price'])){
  508. $map = BasicType::whereIn('id',array_column($data['product_price'],'basic_type_id'))
  509. ->pluck('title','id')
  510. ->toArray();
  511. foreach ($data['product_price'] as $value){
  512. if(! empty($value['price'])) {
  513. $tmp = $map[$value['basic_type_id']] ?? '';
  514. $res = $this->checkNumber($value['price']);
  515. if(! $res) return [false, $tmp . '请输入不超过两位小数并且大于0的数值'];
  516. }
  517. }
  518. }
  519. if(! empty($data['product_category'])) $data['product_category'] = json_encode($data['product_category']);
  520. //所属部门 以及 顶级部门
  521. if(empty($data['depart_id'])) {
  522. $data['depart_id'] = $this->getDepart($user);
  523. $data['top_depart_id'] = $user['depart_map'][$data['depart_id']] ?? 0;
  524. }
  525. //总社id
  526. $top_depart_id = $user['head'] ?? [];
  527. $top_depart_id = $top_depart_id['id'] ?? 0;
  528. if($is_add){
  529. $bool = Product::whereRaw("(binary code = '{$data['code']}' OR title = '{$data['title']}') AND (top_depart_id = {$data['top_depart_id']} OR top_depart_id = {$top_depart_id})")
  530. ->where('del_time',0)
  531. ->exists();
  532. }else{
  533. if(empty($data['id'])) return [false,'ID不能为空'];
  534. $bool = Product::whereRaw("(binary code = '{$data['code']}' OR title = '{$data['title']}') AND (top_depart_id = {$data['top_depart_id']} OR top_depart_id = {$top_depart_id})")
  535. ->where('id','<>',$data['id'])
  536. ->where('del_time',0)
  537. ->exists();
  538. }
  539. if($bool) return [false,'产品名称、编码不能重复'];
  540. return [true, $data];
  541. }
  542. /**
  543. * 拼接数据
  544. * @param $data
  545. * @return array
  546. */
  547. public function fillData($data, $user, $search){
  548. if(empty($data['data'])) return $data;
  549. $type = $search['type'] ?? 0;
  550. $emp = Employee::whereIn('id',array_unique(array_column($data['data'],'crt_id')))
  551. ->pluck('emp_name','id')
  552. ->toArray();
  553. $category = ProductCategory::whereIn('id',array_unique(array_column($data['data'],'product_category_id')))
  554. ->pluck('title','id')
  555. ->toArray();
  556. $basic_map = BasicType::whereIn('id',array_unique(array_column($data['data'],'unit')))
  557. ->orWhere('type',BasicType::type_22)
  558. ->pluck('title','id')
  559. ->toArray();
  560. //产品使用价格
  561. $detail_map = $this->getProductPrice(array_column($data['data'],'id'), $type);
  562. //是否总公司
  563. $is_main = $user['is_all_depart'];
  564. $top_depart = $user['depart_top'][0] ?? [];
  565. foreach ($data['data'] as $key => $value){
  566. $tmp = [];
  567. if(isset($detail_map[$value['id']])){
  568. $d = $detail_map[$value['id']];
  569. foreach ($d as $v){
  570. if(! $is_main && ($top_depart['basic_type_id'] != $v['basic_type_id'])) {
  571. $is_show = 0;
  572. }else{
  573. $is_show = 1;
  574. }
  575. if($top_depart['basic_type_id'] != $v['basic_type_id']) {
  576. $is_use = 0;
  577. }else{
  578. $is_use = 1;
  579. }
  580. $tmp[] = [
  581. 'basic_type_id' => $v['basic_type_id'],
  582. 'basic_type_title' => $basic_map[$v['basic_type_id']] ?? '',
  583. 'price' => $v['price'],
  584. 'is_show' => $is_show,
  585. 'is_use' => $is_use
  586. ];
  587. }
  588. }
  589. $data['data'][$key]['product_price'] = $tmp;
  590. $data['data'][$key]['crt_time'] = $value['crt_time'] ? date('Y-m-d H:i:s',$value['crt_time']) : '';
  591. $data['data'][$key]['crt_name'] = $emp[$value['crt_id']] ?? '';
  592. $data['data'][$key]['product_category_name'] = $category[$value['product_category_id']] ?? '';
  593. $data['data'][$key]['state_name'] = Product::$state[$value['state']] ?? '';
  594. $data['data'][$key]['unit_name'] = $basic_map[$value['unit']] ?? '';
  595. }
  596. return $data;
  597. }
  598. //获取产品字典
  599. public function getProductDetail($product_id = []){
  600. if(empty($product_id)) return [];
  601. $pro = Product::whereIn('id', $product_id)->get()->toArray();
  602. return array_column($pro,null,'id');
  603. }
  604. //获取产品使用价格
  605. public function getProductPrice($product_id = [], $type = 1){
  606. //type 1 采购 2 合同 和 活动包
  607. $detail_map = [];
  608. $time = time();
  609. if($type == 1) {
  610. //供应商活动价格
  611. $activity = ProductActivityPrice::from('product_activity_price as a')
  612. ->join('product_activity as b','b.id','a.product_activity_id')
  613. ->where('a.del_time',0)
  614. ->whereIn('a.product_id',$product_id)
  615. ->where('a.start_time','<=',$time)
  616. ->where('a.end_time','>=',$time)
  617. ->where('b.type',ProductActivity::type_two)
  618. ->select('a.product_id','a.basic_type_id','a.price')
  619. ->get()->toArray();
  620. foreach ($activity as $value){
  621. $detail_map[$value['product_id']][] = $value;
  622. }
  623. //分社价 没有供应商活动价格使用分社价格
  624. $detail = ProductPriceDetail::where('del_time',0)
  625. ->whereIn('product_id',$product_id)
  626. ->select('product_id','basic_type_id','price')
  627. ->get()->toArray();
  628. foreach ($detail as $value){
  629. if(! isset($detail_map[$value['product_id']])){
  630. $detail_map[$value['product_id']][] = $value;
  631. }
  632. }
  633. }else{
  634. //零售活动价格
  635. $activity = ProductActivityPrice::from('product_activity_price as a')
  636. ->join('product_activity as b','b.id','a.product_activity_id')
  637. ->where('a.del_time',0)
  638. ->whereIn('a.product_id',$product_id)
  639. ->where('a.start_time','<=',$time)
  640. ->where('a.end_time','>=',$time)
  641. ->where('b.type',ProductActivity::type_one)
  642. ->select('a.product_id','a.basic_type_id','a.price')
  643. ->get()->toArray();
  644. foreach ($activity as $value){
  645. $detail_map[$value['product_id']][] = $value;
  646. }
  647. }
  648. return $detail_map;
  649. }
  650. public function getProductPriceTmp($product_id = []){
  651. //type 0 采购 1 合同
  652. //分社价
  653. $detail = ProductPriceDetail::where('del_time',0)
  654. ->whereIn('product_id',$product_id)
  655. ->select('product_id','basic_type_id','price')
  656. ->get()->toArray();
  657. $detail_map = [];
  658. foreach ($detail as $value){
  659. $detail_map[$value['product_id']][] = $value;
  660. }
  661. $return = $detail_map;
  662. //活动价格
  663. $time = time();
  664. $activity = ProductActivityPrice::where('del_time',0)
  665. ->whereIn('product_id',$product_id)
  666. ->where('start_time','<=',$time)
  667. ->where('end_time','>=',$time)
  668. ->select('product_id','basic_type_id','price')
  669. ->get()->toArray();
  670. if(! empty($activity)){
  671. foreach ($activity as $value){
  672. if(! isset($detail_map[$value['product_id']])) {
  673. $return[$value['product_id']][] = $value;
  674. }else{
  675. $basic_type = array_column($detail_map[$value['product_id']],'basic_type_id');
  676. if(! in_array($value['basic_type_id'], $basic_type)){
  677. $return[$value['product_id']][] = $value;
  678. continue;
  679. }
  680. foreach ($detail_map[$value['product_id']] as $key => $val){
  681. if($value['basic_type_id'] == $val['basic_type_id']) {
  682. //活动价格替换
  683. $return[$value['product_id']][$key]['price'] = $value['price'];
  684. }
  685. }
  686. }
  687. }
  688. }unset($detail_map);
  689. return $return;
  690. }
  691. }