StoreAdminAttrForm.php 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319
  1. <?php
  2. /**
  3. * 重庆赤晓店信息科技有限公司
  4. * https://www.chixiaodian.com
  5. * Copyright (c) 2023 赤店商城 All rights reserved.
  6. */
  7. namespace app\modules\alliance\models\store;
  8. use app\jobs\SyncMdGoodsJob;
  9. use app\models\Attr;
  10. use app\models\AttrGroup;
  11. use app\models\Goods;
  12. use app\models\GoodsBook;
  13. use app\models\GoodsCat;
  14. use app\models\GoodsPic;
  15. use yii\base\Model;
  16. use yii\helpers\Json;
  17. class StoreAdminAttrForm extends Model
  18. {
  19. public $store_id;
  20. public function goodsAttrBook($goods_info){
  21. $t = \Yii::$app->db->beginTransaction();
  22. try {
  23. // 预约
  24. if ($goods_info['product_type'] == Goods::GOODS_TYPE_DATE) {
  25. if (empty($goods_info['date_book'])) {
  26. $t->rollBack();
  27. throw new \Exception('请检查预约日期相关配置是否正确');
  28. }
  29. foreach ($goods_info['date_book'] as $k => $v) {
  30. if (intval($v['num']) < 0 || $v['price'] <= 0) {
  31. $t->rollBack();
  32. throw new \Exception('请检查预约日期的价格和库存参数是否填写正确');
  33. }
  34. }
  35. $goods_book = GoodsBook::findOne(['goods_id' => $goods_info['id']]);
  36. if (!$goods_book) {
  37. $goods_book = new GoodsBook();
  38. }
  39. $goods_book->goods_id = $goods_info['id'];
  40. $goods_book->date_book = Json::encode($goods_info['date_book']);
  41. $goods_book->save();
  42. }
  43. if ($goods_info['product_type'] == Goods::GOODS_TYPE_TIME) {
  44. if (empty($goods_info['service_book']) || !is_array($goods_info['service_book']) || empty($goods_info['service_book']['data'])) {
  45. $t->rollBack();
  46. throw new \Exception('请检查服务商品预定参数');
  47. }
  48. if (count($goods_info['service_book']['data']) != $goods_info['service_book']['date']) {
  49. $t->rollBack();
  50. throw new \Exception('请检查是否少填写时间段和价格参数');
  51. }
  52. $time_arr = [];
  53. foreach ($goods_info['service_book']['data'] as $val) {
  54. if (empty($val['time'])) {
  55. $t->rollBack();
  56. throw new \Exception('请检查是否少填写时间段');
  57. }
  58. foreach ($val['time'] as $v) {
  59. if (empty($v['start_time']) || empty($v['end_time'])) {
  60. $t->rollBack();
  61. throw new \Exception('请检查是否少填写时间段');
  62. }
  63. if (empty($v['times']) || !is_array($v['times'])) {
  64. $t->rollBack();
  65. throw new \Exception('请检查时间段下是否未选择详细时间');
  66. }
  67. foreach ($v['times'] as $m) {
  68. if (empty($m['time']) || empty($m['price'] || empty($m['num']))) {
  69. $t->rollBack();
  70. throw new \Exception('请检查是否少填写时间点, 价格以及库存');
  71. }
  72. }
  73. $time_arr[] = [
  74. 'start_time' => $v['start_time'],
  75. 'end_time' => $v['end_time'],
  76. ];
  77. }
  78. }
  79. $goods_book = GoodsBook::findOne(['goods_id' => $goods_info['id']]);
  80. if (!$goods_book) {
  81. $goods_book = new GoodsBook();
  82. $goods_book->goods_id = $goods_info['id'];
  83. }
  84. $goods_book->service_book = Json::encode($goods_info['service_book']);
  85. $goods_book->save();
  86. }
  87. // 设置规格
  88. try {
  89. $result = $this->setAttr($goods_info);
  90. if ($result['code']) {
  91. throw new \Exception($result['msg']);
  92. }
  93. } catch(\Exception $e){
  94. return [
  95. 'code' => 1,
  96. 'msg' => $e->getMessage()
  97. ];
  98. }
  99. if ($goods_info['cat_id'] && count($goods_info['cat_id'])) {
  100. if ($goods_info['id'] > 0) {
  101. GoodsCat::deleteAll(['goods_id' => $goods_info['id']]);
  102. }
  103. $goodsCatForm = new GoodsCat();
  104. foreach ($goods_info['cat_id'] as $cat_id) {
  105. $goodsCat = clone $goodsCatForm;
  106. $goodsCat->goods_id = $goods_info['id'];
  107. $goodsCat->cat_id = $cat_id;
  108. $goodsCat->store_id = $goods_info['store_id'];
  109. if (!$goodsCat->save()) {
  110. throw new \Exception('保存失败');
  111. }
  112. }
  113. }
  114. if ($goods_info['goods_pic_list']) {
  115. if ($goods_info['id'] > 0) {
  116. GoodsPic::deleteAll(['goods_id' => $goods_info['id']]);
  117. }
  118. $goodsPicForm = new GoodsPic();
  119. foreach ($goods_info['goods_pic_list'] as $pic) {
  120. $goodsPic = clone $goodsPicForm;
  121. $goodsPic->goods_id = $goods_info['id'];
  122. $goodsPic->pic_url = $pic['pic_url'];
  123. if (!$goodsPic->save()) {
  124. throw new \Exception('保存失败');
  125. }
  126. }
  127. }
  128. queue_push(new SyncMdGoodsJob(['goods_ids' => [$goods_info['id']]]), 0, 1);
  129. $t->commit();
  130. return [
  131. 'code' => 0,
  132. 'msg' => "操作成功"
  133. ];
  134. } catch (\Exception $e){
  135. $t->rollBack();
  136. return [
  137. 'code' => 0,
  138. 'msg' => $e->getMessage()
  139. ];
  140. }
  141. }
  142. //设置规格
  143. private function setAttr($goods_info)
  144. {
  145. try {
  146. $store_id = $this->store_id;
  147. $goods = Goods::findOne($goods_info['id']);
  148. if ($goods_info['product_type'] == Goods::GOODS_TYPE_DATE || $goods_info['product_type'] == Goods::GOODS_TYPE_TIME) {
  149. $defaultAttr = '[{"attr_list":[{"attr_id":1,"attr_name":"默认"}],"num":0,"price":0,"no":"","pic":"","share_commission_first":"","share_commission_second":"","share_commission_third":""}]';
  150. $goods->attr = $defaultAttr;
  151. $goods->save();
  152. return;
  153. }
  154. if (!$goods_info['use_attr']) {
  155. list($default_attr, $default_attr_group) = $this->getDefaultAttr();
  156. if (empty($goods_info['attr'])) {
  157. $goods_info['attr'] = [
  158. [
  159. 'attr_list' => [
  160. [
  161. 'attr_group_name' => $default_attr_group->attr_group_name,
  162. 'attr_id' => $default_attr->id,
  163. 'attr_name' => $default_attr->attr_name,
  164. ],
  165. ],
  166. 'num' => intval($goods_info['goods_num']) ?: 0,
  167. 'price' => $goods_info['price'],
  168. 'integral_price' => $goods_info['integral_price'],
  169. 'cost_price' => $goods->cost_price,
  170. 'no' => $goods_info['goods_no'],
  171. 'sku_id' => '',
  172. 'original_price' => $goods->original_price,
  173. ],
  174. ];
  175. } else {
  176. $attr_list = [
  177. [
  178. 'attr_group_name' => $default_attr_group->attr_group_name,
  179. 'attr_id' => $default_attr->id,
  180. 'attr_name' => $default_attr->attr_name,
  181. ],
  182. ];
  183. $goods_info['attr'][0]['attr_list'] = $attr_list;
  184. $goods_info['attr'][0]['num'] = intval($goods_info['goods_num']) ?: 0;
  185. $goods_info['attr'][0]['price'] = intval($goods_info['price']) ?: 0;
  186. $goods_info['attr'][0]['no'] = $goods_info['goods_no'];
  187. $goods_info['attr'][0]['integral_price'] = intval($goods_info['integral_price']) ?: 0;
  188. $goods_info['attr'][0]['cost_price'] = doubleval($goods_info['integral_price']) ?: 0;
  189. $goods_info['attr'][0]['original_price'] = doubleval($goods->original_price) ?: 0;
  190. }
  191. }
  192. if (empty($goods_info['attr']) || !is_array($goods_info['attr'])) {
  193. return [
  194. 'code' => 0,
  195. 'msg' => "没有规格"
  196. ];
  197. }
  198. $new_attr = [];
  199. foreach ($goods_info['attr'] as $i => $item) {
  200. $new_attr_item = [
  201. 'attr_list' => [],
  202. 'num' => intval($item['num']),
  203. 'price' => doubleval($item['price']),
  204. 'no' => $item['no'] ? $item['no'] : '',
  205. 'pic' => $item['pic'] ? $item['pic'] : '',
  206. 'cost_price' => sprintf('%.2f', $item['cost_price'] ?? $item['price']),
  207. 'share_commission_first' => $item['share_commission_first'] ?: '',
  208. 'share_commission_second' => $item['share_commission_second'] ?: '',
  209. 'share_commission_third' => $item['share_commission_third'] ?: '',
  210. ];
  211. foreach ($item as $k => $v) {
  212. if (strpos($k,'member') !== false) {
  213. $new_attr_item[$k] = $v;
  214. }
  215. }
  216. foreach ($item['attr_list'] as $a) {
  217. $attr_group_model = AttrGroup::findOne(['store_id' => $store_id, 'attr_group_name' => $a['attr_group_name'], 'is_delete' => 0]);
  218. if (!$attr_group_model) {
  219. $attr_group_model = new AttrGroup();
  220. $attr_group_model->attr_group_name = $a['attr_group_name'];
  221. $attr_group_model->store_id = $store_id;
  222. $attr_group_model->is_delete = 0;
  223. $attr_group_model->save();
  224. }
  225. $attr_model = Attr::findOne(['attr_group_id' => $attr_group_model->id, 'attr_name' => $a['attr_name'], 'is_delete' => 0]);
  226. if (!$attr_model) {
  227. $attr_model = new Attr();
  228. $attr_model->attr_name = $a['attr_name'];
  229. $attr_model->attr_group_id = $attr_group_model->id;
  230. $attr_model->is_delete = 0;
  231. $attr_model->save();
  232. }
  233. \Yii::error((array)$attr_model,"今天是个好日子");
  234. $new_attr_item['attr_list'][] = [
  235. 'attr_id' => $attr_model->id,
  236. 'attr_name' => $attr_model->attr_name,
  237. ];
  238. }
  239. $new_attr_id = array_column($new_attr_item['attr_list'], 'attr_id');
  240. sort($new_attr_id);
  241. $goods_attr = json_decode($goods->attr, true);
  242. if ($goods_attr) {
  243. foreach ($goods_attr as $goods_attr_item) {
  244. $goods_attr_item_attr_id = array_column($goods_attr_item['attr_list'], 'attr_id');
  245. sort($goods_attr_item_attr_id);
  246. if (!array_diff($goods_attr_item_attr_id, $new_attr_id)) {
  247. $new_attr_item['cost_price'] = $goods_attr_item['cost_price'];
  248. }
  249. }
  250. }
  251. $new_attr[] = $new_attr_item;
  252. }
  253. $goods->attr = Json::encode($new_attr);
  254. if (!$goods->save()) {
  255. throw new \Exception(json_encode($goods->errors));
  256. }
  257. return [
  258. 'code' => 0,
  259. 'msg' => '操作成功'
  260. ];
  261. } catch (\Exception $e) {
  262. return [
  263. 'code' => 1,
  264. 'msg' => $e->getMessage()
  265. ];
  266. }
  267. }
  268. //设置默认规格
  269. public function getDefaultAttr()
  270. {
  271. $default_attr_name = '默认';
  272. $default_attr_group_name = '规格';
  273. $store_id = $this->store_id;
  274. $attr = Attr::findOne([
  275. 'attr_name' => $default_attr_name,
  276. 'is_delete' => 0,
  277. 'is_default' => 1,
  278. ]);
  279. $attr_group = null;
  280. if (!$attr) {
  281. $attr_group = AttrGroup::findOne([
  282. 'attr_group_name' => $default_attr_group_name,
  283. 'is_delete' => 0,
  284. ]);
  285. if (!$attr_group) {
  286. $attr_group = new AttrGroup();
  287. $attr_group->store_id = $store_id;
  288. $attr_group->attr_group_name = $default_attr_group_name;
  289. $attr_group->is_delete = 0;
  290. $attr_group->save(false);
  291. }
  292. $attr = new Attr();
  293. $attr->attr_group_id = $attr_group->id;
  294. $attr->attr_name = $default_attr_name;
  295. $attr->is_delete = 0;
  296. $attr->is_default = 1;
  297. $attr->save(false);
  298. } else {
  299. $attr_group = AttrGroup::findOne($attr->attr_group_id);
  300. }
  301. return [$attr, $attr_group];
  302. }
  303. }