StoreProduct.php 27 KB

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