Goods.php 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162
  1. <?php
  2. namespace Shop\Lib;
  3. use Dever;
  4. class Goods
  5. {
  6. # 根据店铺获取商品列表
  7. public function getList()
  8. {
  9. $shop_id = Dever::input('shop_id');
  10. $lng = Dever::input('lng');
  11. $lat = Dever::input('lat');
  12. $column = Dever::db('goods/column')->select();
  13. $data = array();
  14. # 这里要加一下缓存
  15. $data['shop'] = Dever::load('shop/lib/info')->getOne($shop_id, $lng, $lat);
  16. if ($column) {
  17. foreach ($column as $k => $v) {
  18. $v['data'] = Dever::load('shop/lib/info')->getGoods($shop_id, $v['id'], false, 1);
  19. if ($v['data']) {
  20. $data['cate'][] = $v;
  21. }
  22. }
  23. }
  24. $data['banner'] = Dever::load('push/lib/data')->get('list_banner', '商品列表焦点图', 5);
  25. return $data;
  26. }
  27. # 处理库存操作 1是增加,2是减少 1是总库存,2是销量
  28. public function oper($order, $type, $col, $data)
  29. {
  30. if (!$data) {
  31. return;
  32. }
  33. if ($type == 1) {
  34. $method = 'inc';
  35. $otherMethod = 'dec';
  36. } else {
  37. $method = 'dec';
  38. $otherMethod = 'inc';
  39. }
  40. if ($col == 1) {
  41. $method .= 'Total';
  42. $otherMethod .= 'Total';
  43. $num = 'total_num';
  44. } else {
  45. $method .= 'Sell';
  46. $otherMethod .= 'Sell';
  47. $num = 'sell_num';
  48. }
  49. $up = array();
  50. $table = 'shop';
  51. if (isset($order['shop_id'])) {
  52. $up['where_shop_id'] = $order['shop_id'];
  53. /*
  54. # 如果是仓库直发
  55. if (isset($order['store_id']) && $order['store_id'] && isset($order['store']) && $order['store'] == 1) {
  56. $table = 'store';
  57. $up['where_store_id'] = $order['store_id'];
  58. } elseif (isset($order['shop_type']) && $order['shop_type'] == 2) {
  59. # 如果是平台店下单,就不扣库存了
  60. return;
  61. }
  62. */
  63. } elseif (isset($order['type'])) {
  64. if ($order['type'] == 1) {
  65. $up['where_shop_id'] = $order['type_id'];
  66. } elseif ($order['type'] == 2) {
  67. $table = 'store';
  68. $up['where_store_id'] = $order['type_id'];
  69. }
  70. } else {
  71. return false;
  72. }
  73. foreach ($data as $k => $v) {
  74. if (!$v['sku_id']) {
  75. $v['sku_id'] = -1;
  76. }
  77. $goods = Dever::db('goods/info')->one($v['goods_id']);
  78. if (!$goods) {
  79. continue;
  80. }
  81. if ($goods['price_type'] == 4) {
  82. $goods['goods'] = Dever::array_decode($goods['goods']);
  83. if ($goods['goods']) {
  84. foreach ($goods['goods'] as $k1 => $v1) {
  85. if ($v1['goods_id']) {
  86. if (!isset($v1['sku_id'])) {
  87. $v1['sku_id'] = -1;
  88. }
  89. $v1['num'] = $v1['num'] * $v['num'];
  90. $this->set($up, $order, $num, $table, $method, $otherMethod, $type, $col, $v1);
  91. }
  92. }
  93. }
  94. } else {
  95. $this->set($up, $order, $num, $table, $method, $otherMethod, $type, $col, $v);
  96. }
  97. }
  98. }
  99. private function set($up, $order, $num, $table, $method, $otherMethod, $type, $col, $v)
  100. {
  101. # 先验证有没有信息吧
  102. foreach ($up as $k1 => $v1) {
  103. $k1 = str_replace('where_', '', $k1);
  104. $w[$k1] = $v1;
  105. }
  106. $w['goods_id'] = $v['goods_id'];
  107. $info = Dever::db($table . '/goods')->one($w);
  108. if (!$info) {
  109. Dever::db($table . '/goods')->insert($w);
  110. } else {
  111. Dever::db($table . '/goods')->update(array('where_id' => $info['id'], 'state' => 1));
  112. }
  113. $w['sku_id'] = $v['sku_id'];
  114. $info = Dever::db($table . '/goods_sku')->one($w);
  115. if (!$info) {
  116. Dever::db($table . '/goods_sku')->insert($w);
  117. } else {
  118. Dever::db($table . '/goods_sku')->update(array('where_id' => $info['id'], 'state' => 1));
  119. }
  120. $up['where_goods_id'] = $v['goods_id'];
  121. $up[$num] = $v['num'];
  122. $state = Dever::db($table . '/goods')->$method($up);
  123. if ($state) {
  124. $upSku = $up;
  125. $upSku['where_sku_id'] = $v['sku_id'];
  126. $state = Dever::db($table . '/goods_sku')->$method($upSku);
  127. if (!$state) {
  128. Dever::db($table . '/goods')->$otherMethod($up);
  129. }
  130. if (isset($order['source_type']) && $order['source_type'] == 2 && $order['type'] != 2 && $type == 1 && $col == 1) {
  131. # 如果是仓库发货的,要减少仓库库存
  132. $sup['where_store_id'] = $order['source_id'];
  133. $sup['where_goods_id'] = $v['goods_id'];
  134. $sup[$num] = $v['num'];
  135. $state = Dever::db('store/goods')->$otherMethod($sup);
  136. if ($state) {
  137. $supSku = $sup;
  138. $supSku['where_sku_id'] = $v['sku_id'];
  139. $state = Dever::db('store/goods_sku')->$otherMethod($supSku);
  140. }
  141. }
  142. }
  143. }
  144. }