OrderStock.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340
  1. <?php
  2. /**
  3. * Niushop商城系统 - 团队十年电商经验汇集巨献!
  4. * =========================================================
  5. * Copy right 2019-2029 杭州牛之云科技有限公司, 保留所有权利。
  6. * ----------------------------------------------
  7. * 官方网址: https://www.niushop.com
  8. * =========================================================
  9. */
  10. namespace app\model\order;
  11. use app\model\BaseModel;
  12. use app\model\goods\Goods;
  13. use app\model\stock\GoodsStock;
  14. use app\model\stock\SaleStock;
  15. use app\model\store\Store;
  16. use app\model\storegoods\StoreGoods;
  17. use think\facade\Cache;
  18. use addon\stock\model\stock\Stock as StockAddonModel;
  19. /**
  20. * 商品库存
  21. */
  22. class OrderStock extends BaseModel
  23. {
  24. /**
  25. * 设置库存原子
  26. * @param $sku_id
  27. * @return array
  28. */
  29. public function setGoodsSkuStock($sku_id, $store_id = 0)
  30. {
  31. // $goods_model = new Goods();
  32. // $goods_sku_condition = array(
  33. // ['sku_id', '=', $sku_id]
  34. // );
  35. // $goods_sku_info = $goods_model->getGoodsSkuInfo($goods_sku_condition, 'stock')['data'] ?? [];
  36. if ($store_id == 0) {
  37. $store_model = new Store();
  38. $store_info = $store_model->getDefaultStore()[ 'data' ] ?? [];
  39. $store_id = $store_info[ 'store_id' ];
  40. }
  41. $store_goods_model = new StoreGoods();
  42. $store_goods_condition = array (
  43. [ 'sku_id', '=', $sku_id ],
  44. [ 'store_id', '=', $store_id ]
  45. );
  46. $store_sku_info = $store_goods_model->getStoreGoodsSkuInfo($store_goods_condition)[ 'data' ] ?? [];
  47. if (empty($store_sku_info))
  48. return $this->error();
  49. $stock = $store_sku_info[ 'stock' ];
  50. //设定商品数量
  51. $key = "goods_sku_stock" . $sku_id;
  52. //创建连接redis对象
  53. $redis = Cache::store('redis')->handler();
  54. $surplus_stock = $redis->llen($key);
  55. $count = $stock - $surplus_stock;
  56. for ($i = 1; $i <= $count; $i++) {
  57. //将商品id push到列表中
  58. $redis->rPush($key, 1);
  59. }
  60. Cache::set('order_goods_sku_stock' . $sku_id, 1);
  61. return $this->success();
  62. }
  63. /**
  64. * 检测库存原子
  65. * @param $params
  66. * @return array
  67. */
  68. public function checkOrderSkuStock($params)
  69. {
  70. $sku_id = $params[ 'sku_id' ];
  71. $goods_stock_cache = Cache::get('order_goods_sku_stock' . $sku_id);
  72. if (empty($goods_stock_cache)) {
  73. $this->setGoodsSkuStock($sku_id);
  74. }
  75. return $this->success();
  76. }
  77. /**
  78. * 扣除订单库存
  79. * @param $sku_id
  80. * @param $num
  81. * @return array
  82. */
  83. public function decOrderSaleStock($sku_id, $num, $store_id = 0)
  84. {
  85. $cache_driver = config('cache')[ 'default' ];
  86. if ($cache_driver == 'redis') {//todo 应该会有特定的开关
  87. $this->checkOrderSkuStock([ 'sku_id' => $sku_id ]);
  88. $redis = Cache::store('redis')->handler();
  89. $key = 'goods_sku_stock' . $sku_id;
  90. $start_num = 0;
  91. while ($start_num < $num) {
  92. $start_num++;
  93. $item = $redis->lPop($key);
  94. if (!$item) {
  95. return $this->error();
  96. }
  97. }
  98. }
  99. $sale_stock_model = new SaleStock();
  100. if ($store_id > 0) {
  101. $store_model = new Store();
  102. $store_condition = array (
  103. [ 'store_id', '=', $store_id ]
  104. );
  105. $store_info = $store_model->getStoreInfo($store_condition)[ 'data' ] ?? [];
  106. $stock_type = $store_info[ 'stock_type' ];
  107. if ($stock_type == 'all') {//如果总部统一库存的话就扣除总店的
  108. $store_id = 0;
  109. }
  110. }
  111. $sale_stock_result = $sale_stock_model->decGoodsStock([ 'sku_id' => $sku_id, 'stock' => $num, 'store_id' => $store_id ]);
  112. if ($sale_stock_result[ 'code' ] < 0) {
  113. return $sale_stock_result;
  114. }
  115. return $this->success();
  116. }
  117. /**
  118. * 扣除订单库存
  119. * @param $sku_id
  120. * @param $num
  121. * @return array
  122. */
  123. public function incOrderSaleStock($sku_id, $num, $store_id = 0)
  124. {
  125. $cache_driver = config('cache')[ 'default' ];
  126. //todo 返回库存的话还得把原子加上
  127. if ($cache_driver == 'redis') {//todo 应该会有特定的开关
  128. $this->checkOrderSkuStock([ 'sku_id' => $sku_id ]);
  129. $redis = Cache::store('redis')->handler();
  130. $key = 'goods_sku_stock' . $sku_id;
  131. $start_num = 0;
  132. while ($start_num < $num) {
  133. $start_num++;
  134. //增加原子
  135. $redis->rPush($key, 1);
  136. }
  137. }
  138. $sale_stock_model = new SaleStock();
  139. if ($store_id > 0) {
  140. $store_model = new Store();
  141. $store_condition = array (
  142. [ 'store_id', '=', $store_id ]
  143. );
  144. $store_info = $store_model->getStoreInfo($store_condition)[ 'data' ] ?? [];
  145. $stock_type = $store_info[ 'stock_type' ];
  146. if ($stock_type == 'all') {//如果总部统一库存的话就扣除总店的
  147. $store_id = 0;
  148. }
  149. }
  150. $sale_stock_result = $sale_stock_model->incGoodsStock([ 'sku_id' => $sku_id, 'stock' => $num, 'store_id' => $store_id ]);
  151. if ($sale_stock_result[ 'code' ] < 0) {
  152. return $sale_stock_result;
  153. }
  154. return $this->success();
  155. }
  156. /**
  157. * 阻塞式锁
  158. */
  159. public function lock()
  160. {
  161. $redis = Cache::store('redis')->handler();
  162. $store = 1000;//库存()
  163. // $redis = new \Redis();
  164. // $result = $redis->connect('127.0.0.1', 6379);
  165. $res = $redis->llen('goods_store');
  166. echo $res;
  167. $count = $store - $res;
  168. for ($i = 0; $i < $count; $i++) {
  169. $redis->lpush('goods_store', 1);
  170. }
  171. echo $redis->llen('goods_store');
  172. }
  173. /**
  174. * 扣除库存(用于订单)
  175. * @param $params
  176. * @return array
  177. */
  178. public function decOrderStock($params)
  179. {
  180. $params[ 'is_out_stock' ] = 0;//不再改变销售库存
  181. $store_id = $params[ 'store_id' ] ?? 0;
  182. if ($store_id > 0) {
  183. $store_model = new Store();
  184. $store_condition = array (
  185. [ 'store_id', '=', $store_id ]
  186. );
  187. $store_info = $store_model->getStoreInfo($store_condition)[ 'data' ] ?? [];
  188. $stock_type = $store_info[ 'stock_type' ];
  189. if ($stock_type == 'all') {//如果总部统一库存的话就扣除总店的
  190. $params[ 'store_id' ] = 0;
  191. }
  192. }
  193. $is_exist = addon_is_exit('stock');
  194. if ($is_exist) {
  195. $stock_model = new StockAddonModel();
  196. }
  197. $goods_sku_list = $params[ 'goods_sku_list' ] ?? [];
  198. if (!empty($goods_sku_list)) {
  199. $goods_sku_list_1 = [];
  200. $goods_sku_list_2 = [];
  201. foreach ($goods_sku_list as $k => $v) {
  202. if ($is_exist && $v[ 'goods_class' ] == 1) {
  203. $goods_sku_list_1[] = $v;
  204. } else {
  205. if (in_array($v[ 'goods_class' ], [ 1, 2, 3, 4, 5, 6 ])) {
  206. $goods_sku_list_2[] = $v;
  207. }
  208. }
  209. }
  210. if (!empty($goods_sku_list_1)) {
  211. $params[ 'goods_sku_list' ] = $goods_sku_list_1;
  212. $params[ 'key' ] = 'SEAILCK';
  213. $result = $stock_model->changeStock($params);
  214. if ($result[ 'code' ] < 0) {
  215. return $result;
  216. }
  217. }
  218. if (!empty($goods_sku_list_2)) {
  219. $params[ 'goods_sku_list' ] = $goods_sku_list_2;
  220. $goods_stock_model = new GoodsStock();
  221. $result = $goods_stock_model->decGoodsStock($params);
  222. if ($result[ 'code' ] < 0) {
  223. return $result;
  224. }
  225. }
  226. } else {
  227. if(isset($params['goods_class']) && isset($params[ 'stock' ])){
  228. $goods_class = $params[ 'goods_class' ];
  229. $params[ 'stock' ] = $params[ 'num' ] ?? $params[ 'stock' ];
  230. // $params['stock'] = 1;
  231. if ($is_exist && $goods_class == 1) {
  232. $params[ 'key' ] = 'SEAILCK';
  233. $result = $stock_model->changeStock($params);
  234. } else {//没有的话直接生成支付单据
  235. $goods_stock_model = new GoodsStock();
  236. $result = $goods_stock_model->decGoodsStock($params);
  237. }
  238. }
  239. }
  240. return $result ?? $this->success();
  241. }
  242. /**
  243. * 返还库存(用于订单)
  244. * @param $params
  245. * @return array
  246. */
  247. public function incOrderStock($params)
  248. {
  249. $store_id = $params[ 'store_id' ] ?? 0;
  250. if ($store_id > 0) {
  251. $store_model = new Store();
  252. $store_condition = array (
  253. [ 'store_id', '=', $store_id ]
  254. );
  255. $store_info = $store_model->getStoreInfo($store_condition)[ 'data' ] ?? [];
  256. $stock_type = $store_info[ 'stock_type' ];
  257. if ($stock_type == 'all') {//如果总部统一库存的话就返还总店的
  258. $params[ 'store_id' ] = 0;
  259. }
  260. }
  261. $is_exist = addon_is_exit('stock');
  262. if ($is_exist) {
  263. $stock_model = new StockAddonModel();
  264. }
  265. $goods_sku_list = $params[ 'goods_sku_list' ] ?? [];
  266. if (!empty($goods_sku_list)) {
  267. $goods_sku_list_1 = [];
  268. $goods_sku_list_2 = [];
  269. foreach ($goods_sku_list as $k => $v) {
  270. if ($is_exist && $v[ 'goods_class' ] == 1) {
  271. $goods_sku_list_1[] = $v;
  272. } else {
  273. if (in_array($v[ 'goods_class' ], [ 1, 2, 3, 4, 5, 6 ])) {
  274. $goods_sku_list_2[] = $v;
  275. }
  276. }
  277. }
  278. if (!empty($goods_sku_list_1)) {
  279. $params[ 'goods_sku_list' ] = $goods_sku_list_1;
  280. $params[ 'key' ] = 'REFUND';
  281. $result = $stock_model->changeStock($params);
  282. if ($result[ 'code' ] < 0) {
  283. return $result;
  284. }
  285. }
  286. if (!empty($goods_sku_list_2)) {
  287. $params[ 'goods_sku_list' ] = $goods_sku_list_2;
  288. $goods_stock_model = new GoodsStock();
  289. $result = $goods_stock_model->incGoodsStock($params);
  290. if ($result[ 'code' ] < 0) {
  291. return $result;
  292. }
  293. }
  294. } else {
  295. $goods_class = $params[ 'goods_class' ];
  296. $params[ 'stock' ] = $params[ 'num' ] ?? $params[ 'stock' ];
  297. if ($is_exist && $goods_class == 1) {
  298. $params[ 'key' ] = 'REFUND';
  299. $result = $stock_model->changeStock($params);
  300. } else {//没有的话直接生成支付单据
  301. $goods_stock_model = new GoodsStock();
  302. $result = $goods_stock_model->incGoodsStock($params);
  303. }
  304. }
  305. return $result ?? $this->success();
  306. }
  307. }