StoreProduct.php 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648
  1. <?php
  2. /**
  3. *
  4. * @author: xaboy<365615158@qq.com>
  5. * @day: 2017/12/12
  6. */
  7. namespace app\models\store;
  8. use app\admin\model\store\StoreProductAttrValue as StoreProductAttrValueModel;
  9. use app\admin\model\system\SystemStoreProductStock;
  10. use app\models\system\SystemUserLevel;
  11. use app\models\user\UserLevel;
  12. use crmeb\basic\BaseModel;
  13. use crmeb\services\GroupDataService;
  14. use crmeb\services\workerman\ChannelService;
  15. use crmeb\traits\ModelTrait;
  16. use app\models\store\{
  17. StoreBargain, StoreCombination, StoreSeckill
  18. };
  19. /**
  20. * TODO 产品Model
  21. * Class StoreProduct
  22. * @package app\models\store
  23. */
  24. class StoreProduct extends BaseModel
  25. {
  26. /**
  27. * 数据表主键
  28. * @var string
  29. */
  30. protected $pk = 'id';
  31. /**
  32. * 模型名称
  33. * @var string
  34. */
  35. protected $name = 'store_product';
  36. use ModelTrait;
  37. protected function getSliderImageAttr($value)
  38. {
  39. $sliderImage = json_decode($value, true) ?: [];
  40. foreach ($sliderImage as &$item) {
  41. $item = str_replace('\\', '/', $item);
  42. }
  43. return $sliderImage;
  44. }
  45. protected function getImageAttr($value)
  46. {
  47. return str_replace('\\', '/', $value);
  48. }
  49. public function getDescriptionAttr($value)
  50. {
  51. return htmlspecialchars_decode($value);
  52. }
  53. public static function getValidProduct($productId, $field = 'add_time,browse,cate_id,code_path,cost,ficti,give_integral,id,image,is_sub,is_bargain,is_benefit,is_best,is_del,is_hot,is_new,is_postage,is_seckill,is_show,keyword,mer_id,mer_use,ot_price,postage,price,sales,slider_image,sort,stock,store_info,store_name,unit_name,vip_price,spec_type,IFNULL(sales,0) + IFNULL(ficti,0) as fsales,video_link')
  54. {
  55. $Product = self::where('is_del', 0)->where('is_show', 1)->where('id', $productId)->field($field)->find();
  56. if ($Product) return $Product->toArray();
  57. else return false;
  58. }
  59. public static function getGoodList($limit = 18, $field = '*')
  60. {
  61. $list = self::validWhere()->where('is_good', 1)->order('sort desc,id desc')->limit($limit)->field($field)->select();
  62. $list = count($list) ? $list->toArray() : [];
  63. if (!empty($list)) {
  64. foreach ($list as $k => $v) {
  65. $list[$k]['activity'] = self::activity($v['id']);
  66. }
  67. }
  68. return $list;
  69. }
  70. public static function validWhere()
  71. {
  72. return self::where('is_del', 0)->where('is_show', 1)->where('mer_id', 0);
  73. }
  74. public static function getProductList($data, $uid, $store_id = 0)
  75. {
  76. $sId = $data['sid'];
  77. $cId = $data['cid'];
  78. $keyword = $data['keyword'];
  79. $priceOrder = $data['priceOrder'];
  80. $salesOrder = $data['salesOrder'];
  81. $news = $data['news'];
  82. $page = $data['page'];
  83. $limit = $data['limit'];
  84. $type = $data['type']; // 某些模板需要购物车数量 1 = 需要查询,0 = 不需要
  85. $model = self::validWhere();
  86. if ($sId) {
  87. $model->whereIn('id', function ($query) use ($sId) {
  88. $query->name('store_product_cate')->where('cate_id', $sId)->field('product_id')->select();
  89. });
  90. } elseif ($cId) {
  91. $model->whereIn('id', function ($query) use ($cId) {
  92. $query->name('store_product_cate')->whereIn('cate_id', function ($q) use ($cId) {
  93. $q->name('store_category')->where('pid', $cId)->field('id')->select();
  94. })->field('product_id')->select();
  95. });
  96. }
  97. if (!empty($keyword)) $model->where('keyword|store_name', 'LIKE', htmlspecialchars("%$keyword%"));
  98. if ($news != 0) $model->where('is_new', 1);
  99. $baseOrder = '';
  100. if ($priceOrder) $baseOrder = $priceOrder == 'desc' ? 'price DESC' : 'price ASC';
  101. // if($salesOrder) $baseOrder = $salesOrder == 'desc' ? 'sales DESC' : 'sales ASC';//真实销量
  102. if ($salesOrder) $baseOrder = $salesOrder == 'desc' ? 'sales DESC' : 'sales ASC';//虚拟销量
  103. if ($baseOrder) $baseOrder .= ', ';
  104. $model->order($baseOrder . 'sort DESC, add_time DESC');
  105. $list = $model->page((int)$page, (int)$limit)->field('id,store_name,store_info,keyword,cate_id,image,IFNULL(sales,0) + IFNULL(ficti,0) as sales,price,stock,ot_price')->select()->each(function ($item) use ($uid, $type, $store_id) {
  106. $item['percent'] = bcdiv($item['stock'], bcadd($item['stock'], $item['sales']), 4) * 100;
  107. $item['keyword'] = explode(',', $item['keyword']);
  108. if ($type) {
  109. $item['is_att'] = StoreProductAttrValueModel::where('product_id', $item['id'])->count() ? true : false;
  110. if ($uid) $item['cart_num'] = StoreCart::where('is_pay', 0)->where('is_del', 0)->where('is_new', 0)->where('type', 'product')->where('product_id', $item['id'])->where('uid', $uid)->value('cart_num');
  111. else $item['cart_num'] = 0;
  112. if (is_null($item['cart_num'])) $item['cart_num'] = 0;
  113. }
  114. if ($store_id) {
  115. $stockinfo = SystemStoreProductStock::where('product_id', $item['id'])->where('store_id', $store_id)->find();
  116. $item['price'] = ($stockinfo && SystemStoreProductStock::where('product_id', $item['id'])->where('store_id', $store_id)->min('price') > 0) ? SystemStoreProductStock::where('product_id', $item['id'])->where('store_id', $store_id)->min('price') : $item['price'];
  117. }
  118. });
  119. $list = count($list) ? $list->toArray() : [];
  120. if (!empty($list)) {
  121. foreach ($list as $k => $v) {
  122. $list[$k]['activity'] = self::activity($v['id']);
  123. }
  124. }
  125. return self::setLevelPrice($list, $uid);
  126. }
  127. /*
  128. * 分类搜索
  129. * @param string $value
  130. * @return array
  131. * */
  132. public static function getSearchStorePage($keyword, $page, $limit, $uid, $cutApart = [' ', ',', '-'])
  133. {
  134. $model = self::validWhere();
  135. $keyword = trim($keyword);
  136. if (strlen($keyword)) {
  137. $cut = false;
  138. foreach ($cutApart as $val) {
  139. if (strstr($keyword, $val) !== false) {
  140. $cut = $val;
  141. break;
  142. }
  143. }
  144. if ($cut !== false) {
  145. $keywordArray = explode($cut, $keyword);
  146. $sql = [];
  147. foreach ($keywordArray as $item) {
  148. $sql[] = '(`store_name` LIKE "%' . $item . '%" OR `keyword` LIKE "%' . $item . '%")';
  149. }
  150. $model = $model->where(implode(' OR ', $sql));
  151. } else {
  152. $model = $model->where('store_name|keyword', 'LIKE', "%$keyword%");
  153. }
  154. }
  155. $list = $model->field('id,store_name,cate_id,image,ficti as sales,price,stock')->page($page, $limit)->select();
  156. $list = count($list) ? $list->toArray() : [];
  157. if (!empty($list)) {
  158. foreach ($list as $k => $v) {
  159. $list[$k]['activity'] = self::activity($v['id']);
  160. }
  161. }
  162. return self::setLevelPrice($list, $uid);
  163. }
  164. /**
  165. * 新品产品
  166. * @param string $field
  167. * @param int $limit
  168. * @return false|\PDOStatement|string|\think\Collection
  169. */
  170. public static function getNewProduct($field = '*', $limit = 0, $uid = 0, bool $bool = true, $store_id = 0)
  171. {
  172. if (!$limit && !$bool) return [];
  173. $model = self::where('is_new', 1)->where('is_del', 0)->where('mer_id', 0)
  174. ->where('stock', '>', 0)->where('is_show', 1)->field($field)
  175. ->order('sort DESC, id DESC');
  176. if ($limit) $model->limit($limit);
  177. $list = $model->select();
  178. $list = count($list) ? $list->toArray() : [];
  179. if (!empty($list)) {
  180. foreach ($list as $k => $v) {
  181. if ($store_id) {
  182. $stockinfo = SystemStoreProductStock::where('product_id', $v['id'])->where('store_id', $store_id)->find();
  183. $min = SystemStoreProductStock::where('product_id', $v['id'])->where('store_id', $store_id)->where('price', '>', 0)->min('price');
  184. $list[$k]['price'] = ($stockinfo && $min > 0) ? $min : $v['price'];
  185. }
  186. $list[$k]['activity'] = self::activity($v['id']);
  187. }
  188. }
  189. return self::setLevelPrice($list, $uid);
  190. }
  191. /**
  192. * 热卖产品
  193. * @param string $field
  194. * @param int $limit
  195. * @return false|\PDOStatement|string|\think\Collection
  196. */
  197. public static function getHotProduct($field = '*', $limit = 0, $uid = 0, $store_id = 0)
  198. {
  199. $model = self::where('is_hot', 1)->where('is_del', 0)->where('mer_id', 0)
  200. ->where('stock', '>', 0)->where('is_show', 1)->field($field)
  201. ->order('sort DESC, id DESC');
  202. if ($limit) $model->limit($limit);
  203. $list = $model->select();
  204. $list = count($list) ? $list->toArray() : [];
  205. if (!empty($list)) {
  206. foreach ($list as $k => $v) {
  207. if ($store_id) {
  208. $stockinfo = SystemStoreProductStock::where('product_id', $v['id'])->where('store_id', $store_id)->find();
  209. $min = SystemStoreProductStock::where('product_id', $v['id'])->where('store_id', $store_id)->where('price', '>', 0)->min('price');
  210. $list[$k]['price'] = ($stockinfo && $min > 0) ? $min : $v['price'];
  211. }
  212. $list[$k]['activity'] = self::activity($v['id']);
  213. }
  214. }
  215. return self::setLevelPrice($list, $uid);
  216. }
  217. /**
  218. * 热卖产品
  219. * @param string $field
  220. * @param int $page
  221. * @param int $limit
  222. * @return array|\think\Collection
  223. * @throws \think\db\exception\DataNotFoundException
  224. * @throws \think\db\exception\ModelNotFoundException
  225. * @throws \think\exception\DbException
  226. */
  227. public static function getHotProductLoading($field = '*', $page = 0, $limit = 0)
  228. {
  229. if (!$limit) return [];
  230. $model = self::where('is_hot', 1)->where('is_del', 0)->where('mer_id', 0)
  231. ->where('stock', '>', 0)->where('is_show', 1)->field($field)
  232. ->order('sort DESC, id DESC');
  233. if ($page) $model->page($page, $limit);
  234. $list = $model->select();
  235. if (is_object($list)) return $list->toArray();
  236. return $list;
  237. }
  238. /**
  239. * 精品产品
  240. * @param string $field
  241. * @param int $limit
  242. * @return false|\PDOStatement|string|\think\Collection
  243. */
  244. public static function getBestProduct($field = '*', $limit = 0, $uid = 0, bool $bool = true, $store_id = 0)
  245. {
  246. if (!$limit && !$bool) return [];
  247. $model = self::where('is_best', 1)->where('is_del', 0)->where('mer_id', 0)
  248. ->where('stock', '>', 0)->where('is_show', 1)->field($field)
  249. ->order('sort DESC, id DESC');
  250. if ($limit) $model->limit($limit);
  251. $list = $model->select();
  252. $list = count($list) ? $list->toArray() : [];
  253. if (!empty($list)) {
  254. foreach ($list as $k => $v) {
  255. $list[$k]['activity'] = self::activity($v['id']);
  256. if ($store_id) {
  257. $stockinfo = SystemStoreProductStock::where('product_id', $v['id'])->where('store_id', $store_id)->find();
  258. $min = SystemStoreProductStock::where('product_id', $v['id'])->where('store_id', $store_id)->where('price', '>', 0)->min('price');
  259. $list[$k]['price'] = ($stockinfo && $min > 0) ? $min : $v['price'];
  260. }
  261. }
  262. }
  263. return self::setLevelPrice($list, $uid);
  264. }
  265. /**
  266. * 设置会员价格
  267. * @param object | array $list 产品列表
  268. * @param int $uid 用户uid
  269. * @return array
  270. * */
  271. public static function setLevelPrice($list, $uid, $isSingle = false)
  272. {
  273. if (is_object($list)) $list = count($list) ? $list->toArray() : [];
  274. if (!sys_config('vip_open')) {
  275. if (is_array($list)) return $list;
  276. return $isSingle ? $list : 0;
  277. }
  278. $levelId = UserLevel::getUserLevel($uid);
  279. if ($levelId) {
  280. $discount = UserLevel::getUserLevelInfo($levelId, 'discount');
  281. $discount = bcsub(1, bcdiv($discount, 100, 2), 2);
  282. } else {
  283. $discount = SystemUserLevel::getLevelDiscount();
  284. $discount = bcsub(1, bcdiv($discount, 100, 2), 2);
  285. }
  286. //如果不是数组直接执行减去会员优惠金额
  287. if (!is_array($list))
  288. //不是会员原价返回
  289. if ($levelId)
  290. //如果$isSingle==true 返回优惠后的总金额,否则返回优惠的金额
  291. return $isSingle ? bcsub($list, bcmul($discount, $list, 2), 2) : bcmul($discount, $list, 2);
  292. else
  293. return $isSingle ? $list : 0;
  294. //当$list为数组时$isSingle==true为一维数组 ,否则为二维
  295. if ($isSingle)
  296. $list['vip_price'] = isset($list['price']) ? bcsub($list['price'], bcmul($discount, $list['price'], 2), 2) : 0;
  297. else
  298. foreach ($list as &$item) {
  299. $item['vip_price'] = isset($item['price']) ? bcsub($item['price'], bcmul($discount, $item['price'], 2), 2) : 0;
  300. }
  301. return $list;
  302. }
  303. /**
  304. * 优惠产品
  305. * @param string $field
  306. * @param int $limit
  307. * @return false|\PDOStatement|string|\think\Collection
  308. */
  309. public static function getBenefitProduct($field = '*', $limit = 0, $store_id = 0)
  310. {
  311. $model = self::where('is_benefit', 1)
  312. ->where('is_del', 0)->where('mer_id', 0)->where('stock', '>', 0)
  313. ->where('is_show', 1)->field($field)
  314. ->order('sort DESC, id DESC');
  315. if ($limit) $model->limit($limit);
  316. $data = $model->select();
  317. if (count($data) > 0) {
  318. foreach ($data as $k => $v) {
  319. if ($store_id) {
  320. $stockinfo = SystemStoreProductStock::where('product_id', $v['id'])->where('store_id', $store_id)->find();
  321. $min = SystemStoreProductStock::where('product_id', $v['id'])->where('store_id', $store_id)->where('price', '>', 0)->min('price');
  322. $data[$k]['price'] = ($stockinfo && $min > 0) ? $min : $v['price'];
  323. }
  324. $data[$k]['activity'] = self::activity($v['id']);
  325. }
  326. }
  327. return $data;
  328. }
  329. public static function cateIdBySimilarityProduct($cateId, $field = '*', $limit = 0)
  330. {
  331. $pid = StoreCategory::cateIdByPid($cateId) ?: $cateId;
  332. $cateList = StoreCategory::pidByCategory($pid, 'id') ?: [];
  333. $cid = [$pid];
  334. foreach ($cateList as $cate) {
  335. $cid[] = $cate['id'];
  336. }
  337. $model = self::where('cate_id', 'IN', $cid)->where('is_show', 1)->where('is_del', 0)
  338. ->field($field)->order('sort DESC,id DESC');
  339. if ($limit) $model->limit($limit);
  340. return $model->select();
  341. }
  342. public static function isValidProduct($productId)
  343. {
  344. return self::be(['id' => $productId, 'is_del' => 0, 'is_show' => 1]) > 0;
  345. }
  346. public static function getProductStock($productId, $uniqueId = '')
  347. {
  348. return $uniqueId == '' ?
  349. self::where('id', $productId)->value('stock') ?: 0
  350. : StoreProductAttr::uniqueByStock($uniqueId);
  351. }
  352. /**
  353. * 加销量减销量
  354. * @param $num
  355. * @param $productId
  356. * @param string $unique
  357. * @return bool
  358. */
  359. public static function decProductStock($num, $productId, $unique = '')
  360. {
  361. if ($unique) {
  362. $res = false !== StoreProductAttrValueModel::decProductAttrStock($productId, $unique, $num, 0);
  363. $res = $res && self::where('id', $productId)->dec('stock', $num)->inc('sales', $num)->update();
  364. } else {
  365. $res = false !== self::where('id', $productId)->dec('stock', $num)->inc('sales', $num)->update();
  366. }
  367. if ($res) {
  368. $stock = self::where('id', $productId)->value('stock');
  369. $replenishment_num = sys_config('store_stock') ?? 0;//库存预警界限
  370. if ($replenishment_num >= $stock) {
  371. try {
  372. ChannelService::instance()->send('STORE_STOCK', ['id' => $productId]);
  373. } catch (\Exception $e) {
  374. }
  375. }
  376. }
  377. return $res;
  378. }
  379. /**
  380. * 减少销量,增加库存
  381. * @param int $num 增加库存数量
  382. * @param int $productId 产品id
  383. * @param string $unique 属性唯一值
  384. * @return boolean
  385. */
  386. public static function incProductStock($num, $productId, $unique = '')
  387. {
  388. $product = self::where('id', $productId)->field(['sales', 'stock'])->find();
  389. if (!$product) return true;
  390. if ($product->sales > 0) $product->sales = bcsub($product->sales, $num, 0);
  391. if ($product->sales < 0) $product->sales = 0;
  392. if ($unique) {
  393. $res = false !== StoreProductAttrValueModel::incProductAttrStock($productId, $unique, $num);
  394. //没有修改销量则直接返回
  395. if ($product->sales == 0) return true;
  396. $res = $res && $product->save();
  397. } else {
  398. $product->stock = bcadd($product->stock, $num, 0);
  399. $res = false !== $product->save();
  400. }
  401. return $res;
  402. }
  403. /**
  404. * 获取产品分销佣金最低和最高
  405. * @param $storeInfo
  406. * @param $productValue
  407. * @return int|string
  408. */
  409. public static function getPacketPrice($storeInfo, $productValue)
  410. {
  411. $store_brokerage_ratio = sys_config('store_brokerage_ratio');
  412. $store_brokerage_ratio = bcdiv($store_brokerage_ratio, 100, 2);
  413. if (isset($storeInfo['is_sub']) && $storeInfo['is_sub'] == 1) {
  414. $Maxkey = self::getArrayMax($productValue, 'brokerage');
  415. $Minkey = self::getArrayMin($productValue, 'brokerage');
  416. $maxPrice = bcadd(isset($productValue[$Maxkey]) ? $productValue[$Maxkey]['brokerage'] : 0, 0, 0);
  417. $minPrice = bcadd(isset($productValue[$Minkey]) ? $productValue[$Minkey]['brokerage'] : 0, 0, 0);
  418. } else {
  419. $Maxkey = self::getArrayMax($productValue, 'price');
  420. $Minkey = self::getArrayMin($productValue, 'price');
  421. $maxPrice = bcmul($store_brokerage_ratio, bcadd(isset($productValue[$Maxkey]) ? $productValue[$Maxkey]['price'] : 0, 0, 0), 0);
  422. $minPrice = bcmul($store_brokerage_ratio, bcadd(isset($productValue[$Minkey]) ? $productValue[$Minkey]['price'] : 0, 0, 0), 0);
  423. }
  424. if ($minPrice == 0 && $maxPrice == 0)
  425. return 0;
  426. else if ($minPrice == 0 && $maxPrice)
  427. return $maxPrice;
  428. else if ($maxPrice == 0 && $minPrice)
  429. return $minPrice;
  430. else if ($maxPrice == $minPrice && $minPrice)
  431. return $maxPrice;
  432. else
  433. return $minPrice . '~' . $maxPrice;
  434. }
  435. /**
  436. * 获取二维数组中最大的值
  437. * @param $arr
  438. * @param $field
  439. * @return int|string
  440. */
  441. public static function getArrayMax($arr, $field)
  442. {
  443. $temp = [];
  444. foreach ($arr as $k => $v) {
  445. $temp[] = $v[$field];
  446. }
  447. if (!count($temp)) return 0;
  448. $maxNumber = max($temp);
  449. foreach ($arr as $k => $v) {
  450. if ($maxNumber == $v[$field]) return $k;
  451. }
  452. return 0;
  453. }
  454. /**
  455. * 获取二维数组中最小的值
  456. * @param $arr
  457. * @param $field
  458. * @return int|string
  459. */
  460. public static function getArrayMin($arr, $field)
  461. {
  462. $temp = [];
  463. foreach ($arr as $k => $v) {
  464. $temp[] = $v[$field];
  465. }
  466. if (!count($temp)) return 0;
  467. $minNumber = min($temp);
  468. foreach ($arr as $k => $v) {
  469. if ($minNumber == $v[$field]) return $k;
  470. }
  471. return 0;
  472. }
  473. /**
  474. * 产品名称 图片
  475. * @param array $productIds
  476. * @return array
  477. */
  478. public static function getProductStoreNameOrImage(array $productIds)
  479. {
  480. return self::whereIn('id', $productIds)->column('store_name,image', 'id');
  481. }
  482. /**
  483. * TODO 获取某个字段值
  484. * @param $id
  485. * @param string $field
  486. * @return mixed
  487. */
  488. public static function getProductField($id, $field = 'store_name')
  489. {
  490. if (is_array($id))
  491. return self::where('id', 'in', $id)->field($field)->select();
  492. else
  493. return self::where('id', $id)->value($field);
  494. }
  495. /**
  496. * 获取产品返佣金额
  497. * @param array $cartId
  498. * @param bool $type true = 一级返佣, fasle = 二级返佣
  499. * @return array
  500. */
  501. public static function getProductBrokerage(array $cartId, bool $type = true)
  502. {
  503. $cartInfo = StoreOrderCartInfo::whereIn('cart_id', $cartId)->column('cart_info');
  504. $oneBrokerageReal = 0;//一级返佣金额
  505. $twoBrokerageReal = 0;//二级返佣金额
  506. $sumProductPriceReal = 0;//非指定返佣商品总金额
  507. $oneBrokerageVirtual = 0;//一级返佣金额
  508. $twoBrokerageVirtual = 0;//二级返佣金额
  509. $sumProductPriceVirtual = 0;//非指定返佣商品总金额
  510. foreach ($cartInfo as $value) {
  511. $product = json_decode($value, true);
  512. $cartNum = $product['cart_num'] ?? 0;
  513. if (isset($product['productInfo'])) {
  514. $productInfo = $product['productInfo'];
  515. //指定返佣金额
  516. if (isset($productInfo['is_sub']) && $productInfo['is_sub'] == 1) {
  517. if ($productInfo['store_type'] == 1) {
  518. $oneBrokerageReal = bcadd($oneBrokerageReal, bcmul($cartNum, $productInfo['attrInfo']['brokerage'] ?? 0, 2), 2);
  519. $twoBrokerageReal = bcadd($twoBrokerageReal, bcmul($cartNum, $productInfo['attrInfo']['brokerage_two'] ?? 0, 2), 2);
  520. } else {
  521. $oneBrokerageVirtual = bcadd($oneBrokerageVirtual, bcmul($cartNum, $productInfo['attrInfo']['brokerage'] ?? 0, 2), 2);
  522. $twoBrokerageVirtual = bcadd($twoBrokerageVirtual, bcmul($cartNum, $productInfo['attrInfo']['brokerage_two'] ?? 0, 2), 2);
  523. }
  524. } else {
  525. //比例返佣
  526. if ($productInfo['store_type'] == 1) {
  527. if (isset($productInfo['attrInfo'])) {
  528. $sumProductPriceReal = bcadd($sumProductPriceReal, bcmul($cartNum, $productInfo['attrInfo']['price'] ?? 0, 2), 2);
  529. } else {
  530. $sumProductPriceReal = bcadd($sumProductPriceReal, bcmul($cartNum, $productInfo['price'] ?? 0, 2), 2);
  531. }
  532. } else {
  533. if (isset($productInfo['attrInfo'])) {
  534. $sumProductPriceVirtual = bcadd($sumProductPriceVirtual, bcmul($cartNum, $productInfo['attrInfo']['price'] ?? 0, 2), 2);
  535. } else {
  536. $sumProductPriceVirtual = bcadd($sumProductPriceVirtual, bcmul($cartNum, $productInfo['price'] ?? 0, 2), 2);
  537. }
  538. }
  539. }
  540. }
  541. }
  542. if ($type) {
  543. //获取后台一级返佣比例
  544. $storeBrokerageRatio = sys_config('store_brokerage_ratio');
  545. //一级返佣比例 小于等于零时直接返回 不返佣
  546. if ($storeBrokerageRatio <= 0) {
  547. return [$oneBrokerageReal, $oneBrokerageVirtual];
  548. }
  549. //计算获取一级返佣比例
  550. $brokerageRatio = bcdiv($storeBrokerageRatio, 100, 2);
  551. $brokeragePriceReal = bcmul($sumProductPriceReal, $brokerageRatio, 2);
  552. $brokeragePriceVirtual = bcmul($sumProductPriceVirtual, $brokerageRatio, 2);
  553. //固定返佣 + 比例返佣 = 一级总返佣金额
  554. return [bcadd($oneBrokerageReal, $brokeragePriceReal, 2), bcadd($oneBrokerageVirtual, $brokeragePriceVirtual, 2)];
  555. } else {
  556. //获取二级返佣比例
  557. $storeBrokerageTwo = sys_config('store_brokerage_two');
  558. //二级返佣比例小于等于0 直接返回
  559. if ($storeBrokerageTwo <= 0) {
  560. return [$twoBrokerageReal, $twoBrokerageVirtual];
  561. }
  562. //计算获取二级返佣比例
  563. $brokerageRatio = bcdiv($storeBrokerageTwo, 100, 2);
  564. $brokeragePriceReal = bcmul($sumProductPriceReal, $brokerageRatio, 2);
  565. $brokeragePriceVirtual = bcmul($sumProductPriceVirtual, $brokerageRatio, 2);
  566. //固定返佣 + 比例返佣 = 二级总返佣金额
  567. return [bcadd($twoBrokerageReal, $brokeragePriceReal, 2), bcadd($twoBrokerageVirtual, $brokeragePriceVirtual, 2)];
  568. }
  569. }
  570. /**
  571. * 获取商品在此时段活动优先类型
  572. */
  573. public static function activity($id, $status = true)
  574. {
  575. $activity = self::where('id', $id)->value('activity');
  576. if (!$activity) $activity = '1,2,3';//如果老商品没有活动顺序,默认活动顺序,秒杀-砍价-拼团
  577. $activity = explode(',', $activity);
  578. $activityId = [];
  579. $time = 0;
  580. $seckillId = StoreSeckill::where('is_del', 0)->where('status', 1)->where('start_time', '<=', time())->where('stop_time', '>=', time() - 86400)->where('product_id', $id)->field('id,time_id')->select();
  581. if ($seckillId) {
  582. foreach ($seckillId as $v) {
  583. $timeInfo = GroupDataService::getDataNumber((int)$v['time_id']);
  584. if ($timeInfo && isset($timeInfo['time']) && isset($timeInfo['continued'])) {
  585. if (date('H') >= $timeInfo['time'] && date('H') < ($timeInfo['time'] + $timeInfo['continued'])) {
  586. $activityId[1] = $v['id'];
  587. $time = strtotime(date("Y-m-d"), time()) + 3600 * ($timeInfo['time'] + $timeInfo['continued']);
  588. }
  589. }
  590. }
  591. }
  592. $bargainId = StoreBargain::where('is_del', 0)->where('status', 1)->where('start_time', '<=', time())->where('stop_time', '>=', time())->where('product_id', $id)->value('id');
  593. if ($bargainId) $activityId[2] = $bargainId;
  594. $combinationId = StoreCombination::where('is_del', 0)->where('is_show', 1)->where('start_time', '<=', time())->where('stop_time', '>=', time())->where('product_id', $id)->value('id');
  595. if ($combinationId) $activityId[3] = $combinationId;
  596. $data = [];
  597. foreach ($activity as $k => $v) {
  598. if (array_key_exists($v, $activityId)) {
  599. if ($status) {
  600. $data['type'] = $v;
  601. $data['id'] = $activityId[$v];
  602. if ($v == 1) $data['time'] = $time;
  603. break;
  604. } else {
  605. $arr['type'] = $v;
  606. $arr['id'] = $activityId[$v];
  607. if ($v == 1) $arr['time'] = $time;
  608. $data[] = $arr;
  609. }
  610. }
  611. }
  612. return $data;
  613. }
  614. }