Set.php 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260
  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. $goods_info = Dever::db('goods/info')->one($goods_id);
  79. $w = array();
  80. $w['goods_id'] = $goods_id;
  81. $w['shop_id'] = $shop_id;
  82. $info = Dever::db('shop/goods')->one($w);
  83. $w['status'] = $goods_info['status'];
  84. $w['total_num'] = $v['num'];
  85. $w['min'] = $v['min'];
  86. if (!$info) {
  87. Dever::db('shop/goods')->insert($w);
  88. } else {
  89. $w['total_num'] += $info['total_num'];
  90. $w['where_id'] = $info['id'];
  91. $w['state'] = 1;
  92. Dever::db('shop/goods')->update($w);
  93. }
  94. $w = array();
  95. $w['goods_id'] = $goods_id;
  96. $w['shop_id'] = $shop_id;
  97. $w['sku_id'] = $sku_id;
  98. $info = Dever::db('shop/goods_sku')->one($w);
  99. $w['status'] = $goods_info['status'];
  100. $w['total_num'] = $v['num'];
  101. $w['min'] = $v['min'];
  102. if (!$info) {
  103. Dever::db('shop/goods_sku')->insert($w);
  104. } else {
  105. $w['total_num'] += $info['total_num'];
  106. $w['where_id'] = $info['id'];
  107. $w['state'] = 1;
  108. Dever::db('shop/goods_sku')->update($w);
  109. }
  110. }
  111. }
  112. return Dever::url('project/database/list&project=shop&&table=info&menu=shop&search_option_state=1', 'manage');
  113. }
  114. # 获取工厂列表
  115. public function getFactory_api()
  116. {
  117. $shop_id = Dever::input('shop_id', 1);
  118. $shop_factory = Dever::db('shop/factory')->getAll(array('shop_id' => $shop_id));
  119. $factory = Dever::db('factory/info')->select(array('status' => 1));
  120. $result = array();
  121. foreach ($factory as $k => $v) {
  122. $key = $v['area'];
  123. $area = Dever::load('area/api')->string($key, '', true, '');
  124. if (!isset($result[$key])) {
  125. $result[$key] = array();
  126. $result[$key]['id'] = $v['id'];
  127. $result[$key]['name'] = $area;
  128. $result[$key]['select'] = 2;
  129. $result[$key]['end'] = false;
  130. $result[$key]['children'] = array();
  131. }
  132. $data = array();
  133. $data['id'] = $v['id'];
  134. $data['name'] = $v['name'];
  135. $data['area'] = $area;
  136. $data['select'] = 2;
  137. $data['end'] = true;
  138. if (isset($shop_factory[$v['id']]) && $shop_factory[$v['id']]) {
  139. $data['select'] = 1;
  140. }
  141. $result[$key]['children'][] = $data;
  142. }
  143. $result = array_values($result);
  144. return Dever::outDiy($result);
  145. }
  146. # 分配工厂
  147. public function factory_api()
  148. {
  149. $data = array();
  150. $data['shop_id'] = Dever::input('id', 1);
  151. $data['host'] = Dever::url('lib/set.factory', 'shop');
  152. $data['url'] = Dever::url('lib/set.getFactory?shop_id=' . $data['shop_id'], 'shop');
  153. $data['search'] = Dever::url('lib/set.search?yes='.$data['shop_id'].'&json=1', 'shop');
  154. $data['submit'] = Dever::url('lib/set.source_cmmmit?json=1&type=factory', 'shop');
  155. return Dever::render('setFactory', $data);
  156. }
  157. # 获取仓库列表
  158. public function getStore_api()
  159. {
  160. $shop_id = Dever::input('shop_id', 1);
  161. $shop_store = Dever::db('shop/store')->getAll(array('shop_id' => $shop_id));
  162. $store = Dever::db('store/info')->select(array('status' => 1));
  163. $result = array();
  164. foreach ($store as $k => $v) {
  165. $key = $v['area'];
  166. $area = Dever::load('area/api')->string($key, '', true, '');
  167. if (!isset($result[$key])) {
  168. $result[$key] = array();
  169. $result[$key]['id'] = $v['id'];
  170. $result[$key]['name'] = $area;
  171. $result[$key]['select'] = 2;
  172. $result[$key]['end'] = false;
  173. $result[$key]['children'] = array();
  174. }
  175. $data = array();
  176. $data['id'] = $v['id'];
  177. $data['name'] = $v['name'];
  178. $data['area'] = $area;
  179. $data['select'] = 2;
  180. $data['end'] = true;
  181. if (isset($shop_store[$v['id']]) && $shop_store[$v['id']]) {
  182. $data['select'] = 1;
  183. }
  184. $result[$key]['children'][] = $data;
  185. }
  186. $result = array_values($result);
  187. return Dever::outDiy($result);
  188. }
  189. # 分配仓库
  190. public function store_api()
  191. {
  192. $data = array();
  193. $data['shop_id'] = Dever::input('id', 1);
  194. $data['host'] = Dever::url('lib/set.store', 'shop');
  195. $data['url'] = Dever::url('lib/set.getStore?shop_id=' . $data['shop_id'], 'shop');
  196. $data['search'] = Dever::url('lib/set.search?yes='.$data['shop_id'].'&json=1', 'shop');
  197. $data['submit'] = Dever::url('lib/set.source_cmmmit?json=1&type=store', 'shop');
  198. return Dever::render('setStore', $data);
  199. }
  200. public function source_cmmmit_api()
  201. {
  202. $value = Dever::input('value');
  203. if (!$value) {
  204. Dever::alert('未选择');
  205. }
  206. $value = Dever::json_decode($value);
  207. $shop_id = Dever::input('shop_id');
  208. $type = Dever::input('type');
  209. $col = $type . '_id';
  210. $table = 'shop/' . $type;
  211. $where['option_shop_id'] = $shop_id;
  212. $where['set_state'] = 2;
  213. Dever::db($table)->updates($where);
  214. foreach ($value as $k => $v) {
  215. $w = array();
  216. $w[$col] = $v['id'];
  217. $w['shop_id'] = $shop_id;
  218. $info = Dever::db($table)->one($w);
  219. if (!$info) {
  220. Dever::db($table)->insert($w);
  221. } else {
  222. $w['where_id'] = $info['id'];
  223. $w['state'] = 1;
  224. Dever::db($table)->update($w);
  225. }
  226. }
  227. return Dever::url('project/database/list&project=shop&&table=info&menu=shop&search_option_state=1', 'manage');
  228. }
  229. }