Set.php 8.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255
  1. <?php
  2. namespace Shop\Lib;
  3. use Dever;
  4. # 批量设置商品
  5. class Set
  6. {
  7. # 导出订单
  8. public function __construct()
  9. {
  10. Dever::load('manage/auth.init');
  11. }
  12. # 获取门店
  13. public function search_api()
  14. {
  15. return Dever::search('shop/info');
  16. }
  17. # 获取商品列表
  18. public function goods_api()
  19. {
  20. $shop_id = Dever::input('shop_id', 1);
  21. return Dever::outDiy(Dever::load('goods/lib/set')->getGoodsList($shop_id, 'shop_id', 'shop/goods_sku'));
  22. }
  23. # 设置生产能力
  24. public function home_api()
  25. {
  26. $data = array();
  27. $data['shop_id'] = Dever::input('id', 1);
  28. $data['host'] = Dever::url('lib/set.home', 'shop');
  29. $data['url'] = Dever::url('lib/set.goods?shop_id=' . $data['shop_id'], 'shop');
  30. $data['search'] = Dever::url('lib/set.search?yes='.$data['shop_id'].'&json=1', 'shop');
  31. $data['submit'] = Dever::url('lib/set.action_cmmmit?json=1', 'shop');
  32. return Dever::render('setGoods', $data);
  33. }
  34. # 设置生产能力
  35. public function action_cmmmit_api()
  36. {
  37. $goods = Dever::input('goods');
  38. if (!$goods) {
  39. Dever::alert('请传入商品');
  40. }
  41. $goods = Dever::json_decode($goods);
  42. $shop_id = Dever::input('shop_id');
  43. $where['option_shop_id'] = $shop_id;
  44. $where['set_state'] = 2;
  45. Dever::db('shop/goods')->updates($where);
  46. Dever::db('shop/goods_sku')->updates($where);
  47. foreach ($goods as $k => $v) {
  48. $temp = explode('-', $k);
  49. $goods_id = $temp[0];
  50. if (isset($temp[1])) {
  51. $sku_id = $temp[1];
  52. } else {
  53. $sku_id = -1;
  54. }
  55. if ($v['num'] < 0) {
  56. continue;
  57. }
  58. if ($v['del'] == 2) {
  59. $w = array();
  60. $w['goods_id'] = $goods_id;
  61. $w['shop_id'] = $shop_id;
  62. $w['sku_id'] = $sku_id;
  63. $sku_info = Dever::db('shop/goods_sku')->one($w);
  64. if ($sku_info) {
  65. Dever::db('shop/goods_sku')->update(array('where_id' => $sku_info['id'], 'state' => 2));
  66. }
  67. unset($w['sku_id']);
  68. $t = $w;
  69. $t['state'] = 1;
  70. $total = Dever::db('shop/goods_sku')->total($t);
  71. if ($total <= 0) {
  72. $info = Dever::db('shop/goods')->one($w);
  73. if ($info) {
  74. Dever::db('shop/goods')->update(array('where_id' => $info['id'], 'state' => 2));
  75. }
  76. }
  77. } else {
  78. $w = array();
  79. $w['goods_id'] = $goods_id;
  80. $w['shop_id'] = $shop_id;
  81. $info = Dever::db('shop/goods')->one($w);
  82. $w['total_num'] = $v['num'];
  83. if (!$info) {
  84. Dever::db('shop/goods')->insert($w);
  85. } else {
  86. $w['total_num'] += $info['total_num'];
  87. $w['where_id'] = $info['id'];
  88. $w['state'] = 1;
  89. Dever::db('shop/goods')->update($w);
  90. }
  91. $w = array();
  92. $w['goods_id'] = $goods_id;
  93. $w['shop_id'] = $shop_id;
  94. $w['sku_id'] = $sku_id;
  95. $info = Dever::db('shop/goods_sku')->one($w);
  96. $w['total_num'] = $v['num'];
  97. if (!$info) {
  98. Dever::db('shop/goods_sku')->insert($w);
  99. } else {
  100. $w['total_num'] += $info['total_num'];
  101. $w['where_id'] = $info['id'];
  102. $w['state'] = 1;
  103. Dever::db('shop/goods_sku')->update($w);
  104. }
  105. }
  106. }
  107. return Dever::url('project/database/list&project=shop&&table=info&menu=shop&search_option_state=1', 'manage');
  108. }
  109. # 获取工厂列表
  110. public function getFactory_api()
  111. {
  112. $shop_id = Dever::input('shop_id', 1);
  113. $shop_factory = Dever::db('shop/factory')->getAll(array('shop_id' => $shop_id));
  114. $factory = Dever::db('factory/info')->select(array('status' => 1));
  115. $result = array();
  116. foreach ($factory as $k => $v) {
  117. $key = $v['area'];
  118. $area = Dever::load('area/api')->string($key, '', true, '');
  119. if (!isset($result[$key])) {
  120. $result[$key] = array();
  121. $result[$key]['id'] = $v['id'];
  122. $result[$key]['name'] = $area;
  123. $result[$key]['select'] = 2;
  124. $result[$key]['end'] = false;
  125. $result[$key]['children'] = array();
  126. }
  127. $data = array();
  128. $data['id'] = $v['id'];
  129. $data['name'] = $v['name'];
  130. $data['area'] = $area;
  131. $data['select'] = 2;
  132. $data['end'] = true;
  133. if (isset($shop_factory[$v['id']]) && $shop_factory[$v['id']]) {
  134. $data['select'] = 1;
  135. }
  136. $result[$key]['children'][] = $data;
  137. }
  138. $result = array_values($result);
  139. return Dever::outDiy($result);
  140. }
  141. # 分配工厂
  142. public function factory_api()
  143. {
  144. $data = array();
  145. $data['shop_id'] = Dever::input('id', 1);
  146. $data['host'] = Dever::url('lib/set.factory', 'shop');
  147. $data['url'] = Dever::url('lib/set.getFactory?shop_id=' . $data['shop_id'], 'shop');
  148. $data['search'] = Dever::url('lib/set.search?yes='.$data['shop_id'].'&json=1', 'shop');
  149. $data['submit'] = Dever::url('lib/set.source_cmmmit?json=1&type=factory', 'shop');
  150. return Dever::render('setFactory', $data);
  151. }
  152. # 获取仓库列表
  153. public function getStore_api()
  154. {
  155. $shop_id = Dever::input('shop_id', 1);
  156. $shop_store = Dever::db('shop/store')->getAll(array('shop_id' => $shop_id));
  157. $store = Dever::db('store/info')->select(array('status' => 1));
  158. $result = array();
  159. foreach ($store as $k => $v) {
  160. $key = $v['area'];
  161. $area = Dever::load('area/api')->string($key, '', true, '');
  162. if (!isset($result[$key])) {
  163. $result[$key] = array();
  164. $result[$key]['id'] = $v['id'];
  165. $result[$key]['name'] = $area;
  166. $result[$key]['select'] = 2;
  167. $result[$key]['end'] = false;
  168. $result[$key]['children'] = array();
  169. }
  170. $data = array();
  171. $data['id'] = $v['id'];
  172. $data['name'] = $v['name'];
  173. $data['area'] = $area;
  174. $data['select'] = 2;
  175. $data['end'] = true;
  176. if (isset($shop_store[$v['id']]) && $shop_store[$v['id']]) {
  177. $data['select'] = 1;
  178. }
  179. $result[$key]['children'][] = $data;
  180. }
  181. $result = array_values($result);
  182. return Dever::outDiy($result);
  183. }
  184. # 分配仓库
  185. public function store_api()
  186. {
  187. $data = array();
  188. $data['shop_id'] = Dever::input('id', 1);
  189. $data['host'] = Dever::url('lib/set.store', 'shop');
  190. $data['url'] = Dever::url('lib/set.getStore?shop_id=' . $data['shop_id'], 'shop');
  191. $data['search'] = Dever::url('lib/set.search?yes='.$data['shop_id'].'&json=1', 'shop');
  192. $data['submit'] = Dever::url('lib/set.source_cmmmit?json=1&type=store', 'shop');
  193. return Dever::render('setStore', $data);
  194. }
  195. public function source_cmmmit_api()
  196. {
  197. $value = Dever::input('value');
  198. if (!$value) {
  199. Dever::alert('未选择');
  200. }
  201. $value = Dever::json_decode($value);
  202. $shop_id = Dever::input('shop_id');
  203. $type = Dever::input('type');
  204. $col = $type . '_id';
  205. $table = 'shop/' . $type;
  206. $where['option_shop_id'] = $shop_id;
  207. $where['set_state'] = 2;
  208. Dever::db($table)->updates($where);
  209. foreach ($value as $k => $v) {
  210. $w = array();
  211. $w[$col] = $v['id'];
  212. $w['shop_id'] = $shop_id;
  213. $info = Dever::db($table)->one($w);
  214. if (!$info) {
  215. Dever::db($table)->insert($w);
  216. } else {
  217. $w['where_id'] = $info['id'];
  218. $w['state'] = 1;
  219. Dever::db($table)->update($w);
  220. }
  221. }
  222. return Dever::url('project/database/list&project=shop&&table=info&menu=shop&search_option_state=1', 'manage');
  223. }
  224. }