StockWarning.php
4.8 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
<?php
namespace addons\groupon\library\traits;
use addons\groupon\exception\Exception;
use addons\groupon\model\StockWarning as StockWarningModel;
use addons\groupon\model\Goods;
use addons\groupon\model\GoodsSkuPrice;
/**
* 库存预警
*/
trait StockWarning
{
/**
* 获取全局库存配置
*
* @return void
*/
public function getStockConfig() {
$config = json_decode(\addons\groupon\model\Config::cache(60)->where(['name' => 'order'])->value('value'), true);
$stockConfig = $config && isset($config['goods']) ? $config['goods'] : [];
if (!isset($stockConfig['stock_warning'])) {
$stockConfig['stock_warning'] = 0;
}
return $stockConfig;
}
/**
* 获取库存预警阀值
*
* @param [type] $goodsSkuPrice
* @return void
*/
public function getStockWarning($goodsSkuPrice) {
if (!is_null($goodsSkuPrice['stock_warning'])) {
$stock_warning = $goodsSkuPrice['stock_warning'];
} else {
$stockConfig = $this->getStockConfig();
$stock_warning = $stockConfig['stock_warning'];
}
return $stock_warning;
}
/**
* 检测库存是否低于预警阀值，并且记录
*
* @param [type] $goodsSkuPrice
* @return void
*/
public function checkStockWarning ($goodsSkuPrice, $type = 'edit') {
$stock_warning = $this->getStockWarning($goodsSkuPrice);
// 读取系统配置库存预警值
if ($goodsSkuPrice['stock'] < $stock_warning) {
// 增加库存不足记录
$this->addStockWarning($goodsSkuPrice, $stock_warning);
} else {
if ($type == 'edit') {
// 如果编辑了并且库存大于预警值需要检查并把记录删除
$this->delStockWarning($goodsSkuPrice['id'], $goodsSkuPrice['goods_id']);
}
}
}
/**
* 检测这个商品的所有规格库存预警
*
* @param [type] $goodsSkuPrices
* @return void
*/
public function checkAllStockWarning($goodsSkuPrices, $type = 'add') {
foreach ($goodsSkuPrices as $key => $goodsSkuPrice) {
$this->checkStockWarning($goodsSkuPrice, $type);
}
}
/**
* 记录库存低于预警值
*
* @param [type] $goodsSkuPrice
* @param [type] $stock_warning
* @return void
*/
public function addStockWarning($goodsSkuPrice, $stock_warning) {
$stockWarning = StockWarningModel::where('goods_sku_price_id', $goodsSkuPrice['id'])
->where('goods_id', $goodsSkuPrice['goods_id'])->find();
if ($stockWarning) {
if ($stockWarning['stock_warning'] != $stock_warning
|| $stockWarning->goods_sku_text != $goodsSkuPrice['goods_sku_text']
) {
$stockWarning->goods_sku_text = is_array($goodsSkuPrice['goods_sku_text']) ? join(',', $goodsSkuPrice['goods_sku_text']) : $goodsSkuPrice['goods_sku_text'];;
$stockWarning->stock_warning = $stock_warning;
$stockWarning->save();
}
} else {
$stockWarning = new StockWarningModel();
$stockWarning->goods_id = $goodsSkuPrice['goods_id'];
$stockWarning->goods_sku_price_id = $goodsSkuPrice['id'];
$stockWarning->goods_sku_text = is_array($goodsSkuPrice['goods_sku_text']) ? join(',', $goodsSkuPrice['goods_sku_text']) : $goodsSkuPrice['goods_sku_text'];
$stockWarning->stock_warning = $stock_warning;
$stockWarning->save();
}
return $stockWarning;
}
/**
* 删除规格预警，比如：多规格编辑之后，作废的规格预警，补充库存之后的规格预警
*
* @param array $ids
* @param integer $goods_id
* @return void
*/
public function delStockWarning($goodsSkuPriceIds = [], $goods_id = 0) {
$goodsSkuPriceIds = is_array($goodsSkuPriceIds) ? $goodsSkuPriceIds : [$goodsSkuPriceIds];
StockWarningModel::destroy(function ($query) use ($goods_id, $goodsSkuPriceIds) {
$query->where('goods_id', $goods_id)
->where('goods_sku_price_id', 'in', $goodsSkuPriceIds);
});
}
/**
* 删除商品除了这些规格之外的规格预警
*
* @param array $ids
* @param integer $goods_id
* @return void
*/
public function delNotStockWarning($goodsSkuPriceIds = [], $goods_id = 0) {
$goodsSkuPriceIds = is_array($goodsSkuPriceIds) ? $goodsSkuPriceIds : [$goodsSkuPriceIds];
StockWarningModel::destroy(function ($query) use ($goods_id, $goodsSkuPriceIds) {
$query->where('goods_id', $goods_id)
->where('goods_sku_price_id', 'not in', $goodsSkuPriceIds);
});
}
}