Good.php 72 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\model\DataGroup as DataGroupModel;
  4. use app\admin\model\GoodLog;
  5. use app\txx\model\YzGood;
  6. use think\App;
  7. use think\db\Raw;
  8. use think\facade\Db;
  9. use think\facade\Validate;
  10. //线上商品
  11. class Good extends Base
  12. {
  13. private $acton=[];
  14. public $noble=[];
  15. public function __construct(App $app)
  16. {
  17. parent::__construct($app);
  18. $this->noble=\think\facade\Config::get("noble");
  19. $order=\think\facade\Config::get("order");
  20. $this->acton=$order['order_type'];
  21. }
  22. public function list(){
  23. $page = isset($this->post['page']) && $this->post['page'] !==""? intval($this->post['page']):"1";
  24. $size = isset($this->post['size']) && $this->post['size'] !==""? intval($this->post['size']):"10";
  25. $where =[["a.is_del","=",0]];
  26. $cat_id = isset($this->post['cat_id']) && $this->post['cat_id'] !=="" ? trim($this->post['cat_id']):"";
  27. if($cat_id!==""){
  28. $where[]=['a.cat_id',"=",$cat_id];
  29. }
  30. $good_name = isset($this->post['good_name']) && $this->post['good_name'] !=="" ? trim($this->post['good_name']):"";
  31. if($good_name!==""){
  32. $where[]=['a.good_name',"like","%$good_name%"];
  33. }
  34. $skucode = isset($this->post['skucode']) && $this->post['skucode'] !=="" ? trim($this->post['skucode']):"";
  35. if($skucode!==""){
  36. $where [] = ['b.skucode',"like","%$skucode%"];
  37. }
  38. $spucode = isset($this->post['spucode']) && $this->post['spucode'] !=="" ? trim($this->post['spucode']):"";
  39. if($spucode!==""){
  40. $where [] = ['b.spucode',"like","%$spucode%"];
  41. }
  42. $start = isset($this->post['start']) && $this->post['start']!=="" ? $this->post['start']:"";
  43. if($start!==""){
  44. $where[]=['b.addtime',">=",date('Y-m-d H:i:s',strtotime($start))];
  45. }
  46. $end = isset($this->post['end']) && $this->post['end']!=="" ? $this->post['end']:"";
  47. if($end!==""){
  48. $where[]=['b.addtime',"<",date('Y-m-d H:i:s',strtotime($end)+24*3600)];
  49. }
  50. $is_stock = isset($this->post['is_stock']) && $this->post['is_stock'] !=="" ? intval($this->post['is_stock']) :"";
  51. if($is_stock!==""){
  52. $where[]=['a.is_stock',"=",$is_stock];
  53. }
  54. $good_type = isset($this->post['good_type']) && $this->post['good_type'] !=="" ? intval($this->post['good_type']) :"";
  55. if($good_type!==""){
  56. $where[]=['a.good_type',"=",$good_type];
  57. }
  58. $supplierNo = isset($this->post['supplierNo']) && $this->post['supplierNo'] !=="" ? trim($this->post['supplierNo']) :"";
  59. if($supplierNo!==""){
  60. $where[]=['a.supplierNo',"like","%$supplierNo%"];
  61. }
  62. $companyNo = isset($this->post['companyNo']) && $this->post['companyNo'] !=="" ? trim($this->post['companyNo']) :"";
  63. if($companyNo!==""){
  64. $where[]=['a.companyNo',"like","%$companyNo%"];
  65. }
  66. $creater = isset($this->post['creater']) && $this->post['creater'] !=="" ? trim($this->post['creater']):"";
  67. if($creater!==""){
  68. $where[]=['a.creater',"like","%$creater%"];
  69. }
  70. $online_creater = isset($this->post['online_creater']) && $this->post['online_creater'] !=="" ? trim($this->post['online_creater'])
  71. :"";
  72. if($online_creater!==""){
  73. $where[]=['b.creater',"like","%$online_creater%"];
  74. }
  75. $createrid = isset($this->post['createrid']) && $this->post['createrid'] !=="" ? intval($this->post['createrid']):"";
  76. if($createrid!==""){
  77. $where[]=['a.createrid',"=",$createrid];
  78. }
  79. $status = isset($this->post['status']) && $this->post['status'] !=="" ? intval($this->post['status']) :"";
  80. if($status!==""){
  81. $where[]=['a.status',"=",$status];
  82. }
  83. $platform_code = isset($this->post['platform_code']) && $this->post['platform_code'] !=="" ? trim($this->post['platform_code']) :"";
  84. if($platform_code!==""){
  85. //$platform = Db::name("good_platform")->where(["platform_code"=>$platform_code,"is_del"=>0])->column
  86. //("spuCode");
  87. $where[]=["b.platform_code","=",$platform_code];
  88. }
  89. $plat_code = isset($this->post['plat_code']) && $this->post['plat_code'] !=="" ? trim($this->post['plat_code']) :"";
  90. if($plat_code!==""){
  91. $where[]=["b.plat_code","like","%$plat_code%"];
  92. }
  93. $exam_status = isset($this->post['exam_status']) && $this->post['exam_status'] !=="" ? intval($this->post['exam_status']) :"";
  94. if($exam_status!==""){
  95. $where[]=['b.exam_status',"=",$exam_status];
  96. }
  97. $brand_id = isset($this->post['brand_id']) && $this->post['brand_id'] !=="" ? intval($this->post['brand_id']) :"";
  98. if($brand_id!==""){
  99. $where[]=['a.brand_id',"=",$brand_id];
  100. }
  101. $is_compliance = isset($this->post['is_compliance']) && $this->post['is_compliance'] !=="" ? intval($this->post['is_compliance']) :"";
  102. if($is_compliance!==""){
  103. $where[]=['b.is_compliance',"=",$is_compliance];
  104. }
  105. $supplier = isset($this->post['supplier_name']) && $this->post['supplier_name'] !=="" ? trim($this->post['supplier_name']) :"";
  106. if($supplier!==""){
  107. $where[]=['a.supplierName',"like","%$supplier%"];
  108. }
  109. $company_name = isset($this->post['company_name']) && $this->post['company_name'] !== "" ? trim($this->post['company_name']) : "";
  110. if ($company_name !== "") $where[] = ["b.createrid", 'in', get_company_item_user_by_name($company_name)];
  111. $relaComNo = isset($this->post['relaComNo']) && $this->post['relaComNo'] != "" ? trim($this->post['relaComNo']) : "";
  112. if ($relaComNo != "") $where[] = ['a.companyNo|a.supplierNo', '=', $relaComNo];
  113. $count = Db::name('good')
  114. ->alias("a")
  115. ->rightJoin("good_platform b","a.spuCode=b.spuCode")
  116. ->leftJoin("platform p","p.id=b.platform_code")
  117. ->where('p.platform_type',0)//只筛选非对接平台的商品
  118. ->where($where)
  119. ->count('a.id');
  120. $total = ceil($count / $size);
  121. $page = $page >= $total ? $total : $page;
  122. $list = Db::name('good')
  123. ->alias("a")
  124. ->field("b.skuCode,b.platform_code,b.plat_code,b.id as good_id,a.cat_id,a.good_name,a.good_img,b.is_fixed,
  125. a.good_info_img,a.good_thumb_img,b.createrid,a.is_exclusive,a.brand_id,a.supplierNo,a.supplierName,
  126. a.good_unit,a.noble_metal,a.companyNo,a.companyName,a.spuCode,a.good_type,b.creater,b.addtime,b.updatetime,
  127. b.exam_status,a.createrid purchase_id,a.creater purchase,a.is_stock,p.platform_name,b.is_compliance,b.compliance_remark")
  128. //成本表里的创建人,也是线上商品的采购人,为了防止混淆,给creater取个别名
  129. ->rightJoin("good_platform b","a.spuCode=b.spuCode")
  130. ->leftJoin("platform p","p.id=b.platform_code")
  131. ->where('p.platform_type',0)//只筛选非对接平台的商品
  132. ->where($where)
  133. ->page($page,$size)
  134. ->order("b.addtime desc")
  135. ->select()
  136. ->toArray();
  137. $all_createrid = array_column($list,'createrid');
  138. $item = get_company_name_by_uid($all_createrid);
  139. $brand=Db::name('brand')
  140. ->where(['id'=>array_column($list,'brand_id')])
  141. ->column('brand_name','id');
  142. $unit = Db::name('unit')
  143. ->where(['id'=>array_column($list,'good_unit')])
  144. ->column('unit','id');
  145. // $userCommon = \app\admin\common\User::getIns();
  146. // $names = $userCommon->handle('getCodeAndName',['code'=>array_merge(array_column($list,'companyNo'),
  147. // array_column($list,'supplierNo'))]);
  148. $data=[];
  149. foreach ($list as $value){
  150. $value['cat_info']= made($value['cat_id']);
  151. // $platform = Db::name("platform")->where(["id"=>$value['platform_code']])->find();
  152. // $value['platform_name'] = isset($platform['platform_name']) ? $platform['platform_name']:"";
  153. // $value['platform_code_en'] = isset($platform['platform_code_en']) ? $platform['platform_code_en']:"";
  154. // $supplier = Db::name("supplier")->where(["code"=>$value['supplierNo']])->find();
  155. // $value['supplier_name'] = isset($supplier['name']) ? $supplier['name']:"";
  156. // $brand=Db::name("brand")->where(["id"=>$value['brand_id']])->find();
  157. $value["brand_name"]=$brand[$value['brand_id']]??'';//isset($brand['brand_name'])?$brand['brand_name']:"";
  158. // $unit = Db::name("unit")->where(["id"=>$value['good_unit']])->find();
  159. $value['unit'] =$unit[$value['good_unit']]??'';//isset($unit['unit'])?$unit['unit']:"";
  160. // $company = Db::name("business")->where(["companyNo"=>$value['companyNo']])->find();
  161. $value['company'] = $value['companyName'];//$names['data'][$value['companyNo']]??'';//isset($company['company'])?$company['company']:"";
  162. // $value['supplierName'] = $names['data'][$value['supplierNo']]??'';//isset($company['company'])//?$company['company']:"";
  163. $value['stock_total'] = Db::name("good_stock")->where(['spuCode'=>$value['spuCode'],"is_del"=>0])->sum("usable_stock");
  164. $value['status']=$value['exam_status'];
  165. $value['exclusive']=makeExcluse($value['is_exclusive']);
  166. // $value['good_info_img']=$value['good_info_img'];
  167. // $value['good_img']=$value['good_img'];
  168. $spec = Db::name("good_spec")->where(["spuCode"=>$value['spuCode'],"is_del"=>0])->select()->toArray();
  169. $speclist=[];
  170. if(!empty($spec)){
  171. foreach ($spec as $val){
  172. $temp=[];
  173. $temp['spec_id']=$val['spec_id'];
  174. $temp['spec_value_id']=$val['spec_value_id'];
  175. $sp = Db::name("specs")->where(["id"=>$val['spec_id']])->find();
  176. $temp['spec_name']=isset($sp["spec_name"]) ? $sp["spec_name"]:"";
  177. $spv = Db::name("spec_value")->where(["id"=>$val['spec_value_id']])->find();
  178. $temp['spec_value']=isset($spv["spec_value"]) ? $spv["spec_value"]:"";
  179. $speclist[]=$temp;
  180. }
  181. }
  182. $value['specinfo']=$speclist;
  183. $value['noble_name']=isset($value['noble_metal'])&&$value['noble_metal']!=0?$this->noble[$value['noble_metal']] :"";
  184. $value['company_name'] = $item[$value['createrid']]??'';
  185. //是否具有编辑权限
  186. // $value['is_allow_update'] = 0;
  187. // if (in_array($this->roleid, [1, 33]) || in_array($value['createrid'], $role[DataGroupModel::$type_可编辑])) $value['is_allow_update'] = 1;
  188. $data[]=$value;
  189. }
  190. return app_show(0, "获取成功", ['count' => $count, 'list' => $data]);
  191. }
  192. //获取跟有赞对接的平台所属的商品上线信息
  193. public function listByYz()
  194. {
  195. $param = $this->request->only([
  196. 'page' => 1,
  197. 'size' => 15,
  198. 'cat_id' => '',
  199. 'good_name' => '',
  200. 'skucode' => '',
  201. 'spucode' => '',
  202. 'start' => '',
  203. 'end' => '',
  204. 'is_stock' => '',
  205. 'good_type' => '',
  206. 'supplierNo' => '',
  207. 'companyNo' => '',
  208. 'creater' => '',
  209. 'online_creater' => '',
  210. 'createrid' => '',
  211. 'status' => '',
  212. 'platform_code' => '',
  213. 'plat_code' => '',
  214. 'exam_status' => '',
  215. 'brand_id' => '',
  216. 'company_name' => '',
  217. 'relaComNo' => '',
  218. ], 'post', 'trim');
  219. $where = [["b.is_del", "=", 0]];
  220. if ($param['cat_id'] !== "") $where[] = ['a.cat_id', "=", $param['cat_id']];
  221. if ($param['good_name'] !== "") $where[] = ['a.good_name', 'like', '%' . $param['good_name'] . '%'];
  222. if ($param['skucode'] !== '') $where [] = ['b.skucode', 'like', '%' . $param['skucode'] . '%'];
  223. if ($param['spucode'] !== '') $where [] = ['b.spucode', 'like', '%' . $param['spucode'] . '%'];
  224. if ($param['start'] !== '') $where[] = ['b.addtime', '>=', date('Y-m-d H:i:s', strtotime($param['start']))];
  225. if ($param['end'] !== "") $where[] = ['b.addtime', "<", date('Y-m-d H:i:s', strtotime($param['end']) + 24 * 3600)];
  226. if ($param['is_stock'] !== "") $where[] = ['a.is_stock', "=", $param['is_stock']];
  227. if ($param['good_type'] !== "") $where[] = ['a.good_type', "=", $param['good_type']];
  228. if ($param['supplierNo'] !== "") $where[] = ['a.supplierNo', "=", $param['supplierNo']];
  229. if ($param['companyNo'] !== "") $where[] = ['a.companyNo', "like", '%' . $param['companyNo'] . '%'];
  230. if ($param['online_creater'] !== '') $where[] = ['b.creater', "like", '%' . $param['online_creater'] . '%'];
  231. if ($param['creater'] !== '') $where[] = ['a.creater', "like", '%' . $param['creater'] . '%'];
  232. if ($param['createrid'] !== '') $where[] = ['a.createrid', "=", $param['createrid']];
  233. if ($param['status'] !== '') $where[] = ['a.status', '=', $param['status']];
  234. if ($param['platform_code'] !== "") $where[] = ["b.platform_id", '=', $param['platform_code']];
  235. if ($param['plat_code'] !== '') $where[] = ["b.plat_code", "like", '%' . $param['plat_code'] . '%'];
  236. if ($param['exam_status'] !== '') $where[] = ['b.exam_status', "=", $param['exam_status']];
  237. if ($param['brand_id'] !== "") $where[] = ['a.brand_id', "=", $param['brand_id']];
  238. // $role = $this->checkRole();
  239. // if (!empty($role['write'])) $where[] = ["a.createrid", "in", $role['write']];
  240. // $role = $this->checkDataShare();
  241. // $hand = resign_hand_user($this->uid,0);
  242. // if (!empty($role[DataGroupModel::$type_全部])) {
  243. // $arr= array_unique(array_merge($hand,$role[DataGroupModel::$type_全部]));
  244. // $where[] = ['b.createrid', 'in',$arr];
  245. // }
  246. if ($param['company_name'] !== '') $where[] = ["a.createrid", 'in', get_company_item_user_by_name($param['company_name'])];
  247. // $relaComNo = isset($this->post['relaComNo']) && $this->post['relaComNo']!="" ? trim($this->post['relaComNo']):"";
  248. if($param['relaComNo'] !== '') $where[]=['a.companyNo|a.supplierNo','=', $param['relaComNo']];
  249. $count = Db::name('platform_youzan')
  250. ->alias("b")
  251. ->leftJoin("good_basic a", "a.spuCode=b.spuCode")
  252. // ->leftJoin("depart_user u", "u.uid=a.createrid AND u.is_del=0")
  253. ->where($where)
  254. ->count();
  255. $total = ceil($count / $param['size']);
  256. $param['page'] = $param['page'] >= $total ? $total : $param['page'];
  257. $list = Db::name('platform_youzan')
  258. ->alias("b")
  259. ->field("b.skuCode,b.platform_id platform_code,b.plat_code,b.id as platform_youzan_id,a.cat_id,a.good_name,a.good_img,a.good_info_img,a.good_thumb_img,b.createrid,a.is_exclusive,a.brand_id,a.supplierNo,a.good_unit,a.noble_metal,a.companyNo,a.spuCode,a.good_type,b.creater,b.addtime,b.updatetime,b.exam_status,a.createrid purchase_id,a.creater purchase")//成本表里的创建人,也是线上商品的采购人,为了防止混淆,给creater取个别名
  260. ->leftJoin("good_basic a", "a.spuCode=b.spuCode")
  261. ->where($where)
  262. ->page($param['page'], $param['size'])
  263. ->order("b.addtime desc")
  264. ->select()
  265. ->toArray();
  266. $all_createrid = array_column($list,'createrid');
  267. $item = get_company_name_by_uid($all_createrid);
  268. //取回所有的详情链接字段
  269. $all_skuCode = array_column($list,'skuCode');
  270. $detail_url_skuCode = YzGood::where(['item_no'=>$all_skuCode,'is_del'=>0])
  271. ->column('detail_url','item_no');
  272. $brand = Db::name('brand')
  273. ->where(['id'=>array_column($list,'brand_id')])
  274. ->column('brand_name','id');
  275. $unit = Db::name('unit')
  276. ->where(['id'=>array_column($list,'good_unit')])
  277. ->column('unit','id');
  278. $platform = Db::name('platform')
  279. ->where(['id'=>array_column($list,'platform_code')])
  280. ->column('platform_name','id');
  281. $userCommon = \app\admin\common\User::getIns();
  282. $names = $userCommon->handle('getCodeAndName',['code'=>array_merge(array_column($list,'companyNo'),array_column($list,'supplierNo'))]);
  283. $data = [];
  284. $tmp_cat = [];
  285. foreach ($list as $value) {
  286. if(!isset($tmp_cat[$value['cat_id']])) $tmp_cat[$value['cat_id']] = made($value['cat_id'], []);
  287. $value['cat_info'] = $tmp_cat[$value['cat_id']];
  288. // $platform = Db::name("platform")->field('id,platform_name')->where(["id" => $value['platform_code']])->find();
  289. $value['platform_name'] = $platform[$value['platform_code']]??'';//isset($platform['platform_name']) ? $platform['platform_name'] : "";
  290. $value['platform_code_en'] = "";
  291. // $supplier = Db::name("supplier")->field('id,name')->where(["code" => $value['supplierNo']])->find();
  292. $value['supplier_name'] = $names['data'][$value['supplierNo']]??'';//isset($supplier['name']) ? $supplier['name'] : "";
  293. // $brand = Db::name("brand")->field('id,brand_name')->where(["id" => $value['brand_id']])->find();
  294. $value["brand_name"] = $brand[$value['brand_id']]??'';//isset($brand['brand_name']) ? $brand['brand_name'] : "";
  295. // $unit = Db::name("unit")->field('id,unit')->where(["id" => $value['good_unit']])->find();
  296. $value['unit'] = $unit[$value['good_unit']]??'';//isset($unit['unit']) ? $unit['unit'] : "";
  297. // $company = Db::name("business")->field('id,company')->where(["companyNo" => $value['companyNo']])->find();
  298. $value['company'] = $names['data'][$value['companyNo']]??'';//isset($company['company']) ? $company['company'] : "";
  299. $value['stock_total'] = Db::name("good_stock")->where(['spuCode' => $value['spuCode'], "is_del" => 0])->sum("usable_stock");
  300. $value['status'] = $value['exam_status'];
  301. $value['exclusive'] = makeExcluse($value['is_exclusive']);
  302. // $value['good_info_img']=$value['good_info_img'];
  303. // $value['good_img']=$value['good_img'];
  304. $spec = Db::name("good_spec")
  305. ->where(["spuCode" => $value['spuCode'], "is_del" => 0])
  306. ->select()
  307. ->toArray();
  308. $speclist = [];
  309. if (!empty($spec)) {
  310. foreach ($spec as $val) {
  311. $temp = [];
  312. $temp['spec_id'] = $val['spec_id'];
  313. $temp['spec_value_id'] = $val['spec_value_id'];
  314. $sp = Db::name("specs")->where(["id" => $val['spec_id']])->find();
  315. $temp['spec_name'] = isset($sp["spec_name"]) ? $sp["spec_name"] : "";
  316. $spv = Db::name("spec_value")->where(["id" => $val['spec_value_id']])->find();
  317. $temp['spec_value'] = isset($spv["spec_value"]) ? $spv["spec_value"] : "";
  318. $speclist[] = $temp;
  319. }
  320. }
  321. $value['specinfo'] = $speclist;
  322. $value['noble_name'] = isset($value['noble_metal']) && $value['noble_metal'] != 0 ? $this->noble[$value['noble_metal']] : "";
  323. $value['company_name'] = $item[$value['createrid']]??'';
  324. //是否具有编辑权限
  325. $value['is_allow_update'] = 0;
  326. // if (in_array($this->roleid, [1, 33]) || in_array($value['createrid'], $role[DataGroupModel::$type_可编辑])) $value['is_allow_update'] = 1;
  327. //补充商品详情链接字段
  328. $value['detail_url'] = $detail_url_skuCode[$value['skuCode']]??'';
  329. $data[] = $value;
  330. }
  331. return app_show(0, "获取成功", ['list' => $data, 'count' => $count]);
  332. }
  333. public function info(){
  334. $skucode=isset($this->post['skuCode'])&&$this->post['skuCode']!=""?trim($this->post['skuCode']):"";
  335. if($skucode==""){
  336. return error_show(1005,"参数skuCode不能为空");
  337. }
  338. $good_platform = Db::name("good_platform")->where(['skuCode'=>$skucode,"is_del"=>0])->find();
  339. if($good_platform==false){
  340. return error_show(1004,"未找到商品数据");
  341. }
  342. $data = Db::name("good")->where(["spuCode"=>$good_platform['spuCode'],"is_del"=>0])->find();
  343. if($data==false){
  344. return error_show(1004,"未找到商品数据");
  345. }
  346. $plat =Db::name("platform")->where(["id"=>$good_platform['platform_code']])->find();
  347. $data['skuCode']=$good_platform['skuCode'];
  348. $data['is_fixed']=$good_platform['is_fixed'];
  349. $data['platform_id']=$good_platform['platform_code'];
  350. $data['platform_code_en']=isset($plat['platform_code'])?$plat['platform_code']:"";
  351. $data['platform_name']=isset($plat['platform_name'])?$plat['platform_name']:"";
  352. $data['online_reason']=$good_platform['online_reason'];
  353. $data['online_time']=$good_platform['online_time'];
  354. $data['online_remark']=$good_platform['online_remark'];
  355. $data['exam_status']=$good_platform['exam_status'];
  356. $data['is_online']=$good_platform['is_online'];
  357. $data['plat_code']=$good_platform['plat_code'];
  358. $data['createrid']=$good_platform['createrid']??'';
  359. $data['creater']=$good_platform['creater']??'';
  360. $data['exclusive']=makeExcluse($data['is_exclusive']);
  361. $unit =Db::name("unit")->where(["id"=>$data['good_unit']])->find();
  362. $data['unit'] = isset($unit['unit'])?$unit['unit']:'';
  363. $data['cat_info'] = made($data['cat_id'],[]);
  364. $spec = Db::name("good_spec")->where(["spuCode"=>$good_platform['spuCode'],"is_del"=>0])->select()->toArray();
  365. $userCommon = \app\admin\common\User::getIns();
  366. $names = $userCommon->handle('getCodeAndName',['code'=>[$data['supplierNo'],$data['companyNo']]]);
  367. $supplier = $userCommon->handle('sInfo',['code'=>$data['supplierNo']]);
  368. // $supplier = Db::name("supplier")->where(["code"=>$data['supplierNo']])->find();
  369. $data['supplierName'] = $names['data'][$data['supplierNo']]??'';//isset($supplier['name'])?$supplier['name']:"";
  370. // $company = Db::name("business")->where(["companyNo"=>$data['companyNo']])->find();
  371. $data['company'] = $names['data'][$data['companyNo']]??'';//isset($company['company'])?$company['company']:"";
  372. $data['noble_name']=isset($data['noble_metal'])&&$data['noble_metal']!=0?$this->noble[$data['noble_metal']] :"";
  373. if($data['brand_id']!=0){
  374. $brand=Db::name("brand")->where(["id"=>$data['brand_id']])->find();
  375. $data["brand_name"]=isset($brand['brand_name'])?$brand['brand_name']:"";
  376. }else{
  377. $data["brand_name"]="";
  378. $data["brand_id"]="";
  379. }
  380. $data['origin_place_cn']="";
  381. $data['delivery_place_cn']="";
  382. if($data['delivery_place']!==""){
  383. $place = ["provice_code"=>"","city_code"=>"","area_code"=>""];
  384. list($place['provice_code'],$place['city_code'],$place['area_code'])=explode(",",$data['delivery_place']);
  385. $data['delivery_place_cn']=GetAddr(json_encode($place));
  386. }
  387. if($data['origin_place']!==""){
  388. $place = ["provice_code"=>"","city_code"=>"","area_code"=>""];
  389. list($place['provice_code'],$place['city_code'],$place['area_code'])=explode(",",$data['origin_place']);
  390. $data['origin_place_cn']=GetAddr(json_encode($place));
  391. }
  392. $excluse = makeExcluse($data['is_exclusive']);
  393. $data['exclusive']=$excluse;
  394. $data["good_info_img"]=$data['good_info_img']!=""? $data['good_info_img']:[];
  395. $data["good_img"]=$data['good_img']!=""? $data['good_img']:[];
  396. $speclist=[];
  397. if(!empty($spec)){
  398. foreach ($spec as $value){
  399. $temp=[];
  400. $temp['id']=$value['id'];
  401. $temp['spuCode']=$value['spuCode'];
  402. $temp['spec_id']=$value['spec_id'];
  403. $temp['spec_value_id']=$value['spec_value_id'];
  404. $temp['is_del']=$value['is_del'];
  405. $sp = Db::name("specs")->where(["id"=>$value['spec_id']])->find();
  406. $temp['spec_name']=isset($sp["spec_name"]) ? $sp["spec_name"]:"";
  407. $spv = Db::name("spec_value")->where(["id"=>$value['spec_value_id']])->find();
  408. $temp['spec_value']=isset($spv["spec_value"]) ? $spv["spec_value"]:"";
  409. $speclist[]=$temp;
  410. }
  411. }
  412. $data["speclist"]=empty($speclist)?[]:$speclist;
  413. $ladder = Db::name("good_ladder")->where(['skuCode'=>$skucode,"is_del"=>0])->select()->toArray();
  414. $data["ladderlist"]=!empty($ladder)?$ladder:[];
  415. $nakelist = Db::name("good_nake")->where(['spuCode'=>$good_platform['spuCode'],"is_del"=>0])->select()->toArray();
  416. // $catinfo = Db::name("cat")->where(["id"=>$data['cat_id']])->find();
  417. $cat_top_list = $data['cat_info'];
  418. $cat_top_id = isset($cat_top_list[0]['id']) ? $cat_top_list[0]['id'] : 0;
  419. // $budget = isset($catinfo['order_rate']) ? $catinfo['order_rate']/100:0;
  420. $gold_price=0;
  421. if ($data['is_gold_price']==1 && $cat_top_id==6) {
  422. $gold_price = Db::name("gold_price1")->where(["type" => $data['noble_metal'], "status" => 1, "is_del" => 0])->order("addtime desc")->value('price', 0);
  423. }
  424. $data['gold_price'] =$gold_price;
  425. $nakearry=[];
  426. if(!empty($nakelist)){
  427. //实时金价
  428. foreach ($nakelist as $value){
  429. $value['sale_price'] =$value['nake_total'];
  430. //计算最终售价
  431. if ($data['is_gold_price']==1 && $cat_top_id==6) {
  432. //普通商品:直接用财务提交的售价字段;
  433. //贵金属( 商品重量* 最新金价 + 工艺费(财务定价提交的)* 商品重量+包装费+加标费+证书费+产品裸价+其他费用)=商品库商品直接下单的售价
  434. $value['sale_price'] = ($data['weight'] * $gold_price + $value['cost_fee'] * $data['weight'] + $value['package_fee'] + $value['mark_fee'] + $value['cert_fee'] + $value['nake_fee'] + $value['other_fee']);
  435. }
  436. $nakearry[] = $value;
  437. }
  438. }
  439. $proof =Db::name("good_proof")->where(["spuCode"=>$good_platform['spuCode'],"is_del"=>0])->order("updatetime desc")->field("id,proof_type,proof_url")->find();
  440. $data['proof'] = isset($proof)&&$proof!=false? $proof:[];
  441. $data["nakelist"]=$nakearry;
  442. //补充采购员字段
  443. //成本表里的创建人,也是线上商品的采购人,为了防止混淆,给creater取个别名
  444. $temp_basic_info = Db::name('good_basic')
  445. ->field('id,createrid purchase_id,creater purchase')
  446. ->where(['spuCode' => $data['spuCode'], 'is_del' => 0])
  447. ->find();
  448. $data['good_createrid'] = $data['purchase_id'] = $temp_basic_info['purchase_id'] ?? 0;
  449. $data['good_creater'] = $data['purchase'] = $temp_basic_info['purchase'] ?? '';
  450. $data['cgderid'] = $supplier['data']['personid'] ?? 0;
  451. $data['cgder'] = $supplier['data']['person'] ?? '';
  452. return app_show(0, "获取成功", $data);
  453. }
  454. public function SetWarn(){
  455. $condition=["is_del"=>0];
  456. $wsm_code = isset($this->post['wsm_code']) &&$this->post['wsm_code'] !=="" ? trim($this->post['wsm_code']):"";
  457. if($wsm_code!=""){
  458. $condition["wsm_code"] = $wsm_code;
  459. }else{
  460. return error_show(1004,"参数wsm_code 不能为空");
  461. }
  462. // $type_code = isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  463. // if($type_code!=""){
  464. // $condition["good_type_code"] = $type_code;
  465. // }else{
  466. // return error_show(1004,"参数type_code 不能为空");
  467. // }
  468. $good= Db::name("good_stock")->where($condition)->find();
  469. if(empty($good)){
  470. return error_show(1005,"未找到数据");
  471. }
  472. $warn_stock = isset($this->post['warn_stock']) &&$this->post['warn_stock'] !=="" ? intval($this->post['warn_stock']):"";
  473. if($warn_stock===""){
  474. return error_show(1005,"参数warn_stock 不能为空");
  475. }
  476. $good['warn_stock'] = $warn_stock;
  477. $good['updatetime'] = date("Y-m-d H:i:s");
  478. $up= Db::name("good_stock")->save($good);
  479. if($up){
  480. //商品变动日志表,good_log_code字段存储仓库编码
  481. $data = ['good_log_code' => $wsm_code, "stock_id" => $good['id'], "type" => 1, 'stock' => $warn_stock, "stock_name" => "warn_stock"];
  482. GoodLog::LogAdd($this->post['token'],$data,'setwarn');
  483. return app_show(0,"预警库存更新成功");
  484. }else{
  485. return error_show(1005,"预警库存更新失败");
  486. }
  487. }
  488. public function SetStatus(){
  489. $id = isset($this->post['id']) &&$this->post['id'] !=="" ? intval($this->post['id']):"";
  490. if($id===""){
  491. return error_show(1005,"参数id 不能为空");
  492. }
  493. $good= Db::name("good_type")->where(["id"=>$id,"is_del"=>0])->find();
  494. if(empty($good)){
  495. return error_show(1005,"未找到数据");
  496. }
  497. $good['status'] = $good['status']==1?0 :1;
  498. $good['updatetime'] = date("Y-m-d H:i:s");
  499. $msg = $good['status']==1?"下架" :"上架";
  500. $up= Db::name("good_type")->save($good);
  501. return $up ? app_show(0,"商品{$msg}成功"): error_show(1005,"商品{$msg}失败");
  502. }
  503. public function GetStock(){
  504. $condition = [["a.is_del","=",0]];
  505. $type_code = isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  506. if($type_code!==""){
  507. $condition[]=["a.spuCode","=",$type_code];
  508. }
  509. $wsm_code = isset($this->post['wsm_code']) &&$this->post['wsm_code'] !=="" ? trim($this->post['wsm_code'])
  510. :"";
  511. if($wsm_code!==""){
  512. //$condition["a.wsm_code"]=$wsm_code;
  513. $condition[]=["a.wsm_code","=",$type_code];
  514. }
  515. $suplierNo = isset($this->post['supplierNo']) &&$this->post['supplierNo'] !=="" ? trim($this->post['supplierNo'])
  516. :"";
  517. if($suplierNo!==""){
  518. $wsmcode = Db::name("warehouse_info")->where(['supplierNo'=>$suplierNo,"is_del"=>0])->column("wsm_code");
  519. $condition[]=["a.wsm_code","in",$wsmcode];
  520. }
  521. $list = Db::name("good_stock")->alias("a")->join("warehouse_info b","a.wsm_code=b.wsm_code","left")->join("supplier c","b.supplierNo=c.code","left")
  522. ->where($condition)->field("a.id,b.name as wsm_name,c.code,c.name,a.wait_in_stock,a.wait_out_stock,a.usable_stock,a.intra_stock,(a.wait_out_stock+a.usable_stock) as total_stock,a.status,a.warn_stock")->select();
  523. if(empty($list)){
  524. return error_show(1004,"未找到数据");
  525. }
  526. return app_show(0,"获取成功",$list);
  527. }
  528. //库存统计 区间统计
  529. public function GetStockBet(){
  530. $page = isset($this->post['page']) &&$this->post['page'] !=="" ? intval($this->post['page']):1;
  531. $size = isset($this->post['size']) &&$this->post['size'] !=="" ? intval($this->post['size']):10;
  532. $condition = [["is_del","=",0]];
  533. $type_code = isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  534. if($type_code!==""){
  535. $condition[]=["spuCode","like","%{$type_code}%"];
  536. }
  537. $wsm_code = isset($this->post['wsm_code']) &&$this->post['wsm_code'] !=="" ? trim($this->post['wsm_code'])
  538. :"";
  539. if($wsm_code!==""){
  540. $condition[]=["wsm_code","=",$wsm_code];
  541. }
  542. $suplierNo = isset($this->post['suplierNo']) &&$this->post['suplierNo'] !=="" ? trim($this->post['suplierNo']):"";
  543. if($suplierNo!==""){
  544. $wsmcode = Db::name("warehouse_info")->where(['supplierNo'=>$suplierNo,"is_del"=>0])->column("wsm_code");
  545. $condition[]=["wsm_code","in",$wsmcode];
  546. }
  547. $companyNo = isset($this->post['companyNo']) && $this->post['companyNo'] !== "" ? trim($this->post['companyNo']) : "";
  548. if ($companyNo !== "") {
  549. $wsmcode = Db::name("warehouse_info")->where(['companyNo'=>$companyNo,"is_del"=>0])->column("wsm_code");
  550. $condition[]=["wsm_code","in",$wsmcode];
  551. }
  552. $relaComNo = isset($this->post['relaComNo']) && $this->post['relaComNo']!="" ? trim($this->post['relaComNo']):"";
  553. if($relaComNo!=""){
  554. $wsmcode = Db::name("warehouse_info")->where(['companyNo'=>$relaComNo,"is_del"=>0])->column("wsm_code");
  555. $condition[]=["wsm_code","in",$wsmcode];
  556. }
  557. $start = isset($this->post['start']) &&$this->post['start'] !=="" ? $this->post['start']:"";
  558. $end = isset($this->post['end']) &&$this->post['end'] !=="" ? $this->post['end']:"";
  559. if($start!=""){
  560. $condition[]=["addtime",">=",$start];
  561. }
  562. if($end!=""){
  563. $condition[]=["addtime","<=",$end];
  564. }
  565. $count = Db::name("good_stock")->where($condition)->count();
  566. $page>=ceil($count/$size) ? $page=ceil($count/$size) :"";
  567. $list = Db::name("good_stock")->where($condition)->page($page,$size)->order("addtime desc")->select();
  568. $data=[];
  569. $userCommon = \app\admin\common\User::getIns();
  570. foreach ($list as $key=>$value){
  571. $temp=[];
  572. if($value['wsm_code']!=""){
  573. $wsm = Db::name("warehouse_info")
  574. ->alias("a")
  575. // ->leftJoin("supplier b","a.supplierNo=b.code")
  576. // ->leftJoin("business bus","a.companyNo=bus.companyNo")
  577. ->where(['a.wsm_code'=>$value['wsm_code'],"a.is_del"=>0])
  578. ->field("a.name as wsm_name,wsm_code,a.supplierNo,a.companyNo")
  579. ->find();
  580. $names = $userCommon->handle('getCodeAndName',['code'=>[$wsm['supplierNo'],$wsm['companyNo']]]);
  581. $wsm['supplierName'] = $names['data'][$wsm['supplierNo']]??'';
  582. $wsm['company'] = $names['data'][$wsm['companyNo']]??'';
  583. }
  584. $temp['wsm_name'] = isset($wsm['wsm_name'])?$wsm['wsm_name']:"";
  585. $temp['wsm_code']=$value['wsm_code'];
  586. $temp['supplier_code']=isset($wsm['supplierNo'])?$wsm['supplierNo']:"";
  587. $temp['supplier_name']=isset($wsm['supplierName'])?$wsm['supplierName']:"";
  588. $temp['company_no']=isset($wsm['companyNo'])?$wsm['companyNo']:"";
  589. $temp['company_name']=isset($wsm['company'])?$wsm['company']:"";
  590. if($value['spuCode']!=""){
  591. $good=Db::name("good")
  592. ->alias('g')
  593. ->field('g.*,b.brand_name,u.unit')
  594. ->where(["g.spuCode"=>$value['spuCode'],"g.is_del"=>0])
  595. ->leftJoin('brand b','b.id=g.brand_id')
  596. ->leftJoin('unit u','u.id=g.good_unit')
  597. ->find();
  598. if (empty($good)) {
  599. $good = Db::name("good_zixun")
  600. ->alias('g')
  601. ->field('g.*,b.brand_name,u.unit')
  602. ->where(["g.spuCode" => $value['spuCode'], "g.is_del" => 0])
  603. ->leftJoin('brand b', 'b.id=g.brand_id')
  604. ->leftJoin('unit u', 'u.id=g.good_unit')
  605. ->find();
  606. $speclist =json_decode($good['specinfo'],true);
  607. }else{
  608. //规格信息
  609. $spec = Db::name("good_spec")->field('id,spec_id,spec_value_id')->where(["spuCode" => $value['spuCode'], "is_del" => 0])->select()->toArray();
  610. $speclist = [];
  611. if (!empty($spec)) {
  612. foreach ($spec as $val) {
  613. $tmp = [];
  614. $tmp['spec_id'] = $val['spec_id'];
  615. $tmp['spec_value_id'] = $val['spec_value_id'];
  616. $sp = Db::name("specs")->where(["id" => $val['spec_id']])->find();
  617. $tmp['spec_name'] = isset($sp["spec_name"]) ? $sp["spec_name"] : "";
  618. $spv = Db::name("spec_value")->where(["id" => $val['spec_value_id']])->find();
  619. $tmp['spec_value_name'] = isset($spv["spec_value"]) ? $spv["spec_value"] : "";
  620. $speclist[] = $tmp;
  621. }
  622. }
  623. }
  624. $temp['specinfo'] = $speclist;
  625. }
  626. $temp['good_code']=isset($good['spuCode'])?$good['spuCode']:"";
  627. // $temp['type_code']=isset($good['type_code'])?$good['type_code']:"";
  628. $temp['good_name']=isset($good['good_name'])?$good['good_name']:"";
  629. $temp['unit']=isset($good['unit'])?$good['unit']:"";
  630. $temp['brand_name']=isset($good['brand_name'])?$good['brand_name']:"";
  631. // $temp['attribute']=isset($good['attribute'])?$good['attribute']:"";
  632. $temp['sort_f']=isset($good['cat_id'])?$good['cat_id']:"";
  633. $temp['cat_info']=isset($good['cat_id'])?made($good['cat_id']):"";
  634. $temp['usable_stock'] = $value['usable_stock'];
  635. $temp['wait_in_stock'] = $value['wait_in_stock'];
  636. $temp['wait_out_stock'] = $value['wait_out_stock'];
  637. $temp['intra_stock'] = $value['intra_stock'];
  638. $temp['total_stock'] = $value['wait_out_stock']+$value['usable_stock'];
  639. $temp['warn_stock'] = $value['warn_stock'];
  640. $temp['id'] = $value['id'];
  641. $temp['out_total'] =0;
  642. $temp['in_total'] = 0;
  643. $temp['addtime'] = $value['addtime'];
  644. $data[]=$temp;
  645. }
  646. return app_show(0,"获取成功",["list"=>$data,"count"=>$count]);
  647. }
  648. //库存统计 仓库维度
  649. public function GetStockWsm(){
  650. $page = isset($this->post['page']) &&$this->post['page'] !=="" ? intval($this->post['page']):1;
  651. $size = isset($this->post['size']) &&$this->post['size'] !=="" ? intval($this->post['size']):10;
  652. $condition = [["gs.is_del","=",0]];
  653. $wsm_code = isset($this->post['wsm_code']) &&$this->post['wsm_code'] !=="" ? trim($this->post['wsm_code']):"";
  654. if($wsm_code!==""){
  655. $condition[]=["gs.wsm_code","=",$wsm_code];
  656. }
  657. // $suplierNo = isset($this->post['supplierNo']) &&$this->post['supplierNo'] !=="" ? trim($this->post['supplierNo']):"";
  658. // if($suplierNo!==""){
  659. // $wsmcode = Db::name("warehouse_info")->where(['supplierNo'=>$suplierNo,"is_del"=>0])->column("wsm_code");
  660. // $condition[]=["gs.wsm_code","in",$wsmcode];
  661. // }
  662. $companyNo = isset($this->post['companyNo']) && $this->post['companyNo'] !== "" ? trim($this->post['companyNo']) : "";
  663. if ($companyNo !== "") {
  664. $wsmcode = Db::name("warehouse_info")->where(['companyNo'=>$companyNo,"is_del"=>0])->column("wsm_code");
  665. $condition[]=["gs.wsm_code","in",$wsmcode];
  666. }
  667. $relaComNo = isset($this->post['relaComNo']) && $this->post['relaComNo']!="" ? trim($this->post['relaComNo']):"";
  668. if($relaComNo!=""){
  669. $wsmcode = Db::name("warehouse_info")->where(['companyNo'=>$relaComNo,"is_del"=>0])->column("wsm_code");
  670. $condition[]=["gs.wsm_code","in",$wsmcode];
  671. }
  672. $build= Db::name("good_stock")
  673. ->alias('gs')
  674. ->where($condition)
  675. ->where('whi.wsm_type','<>',2)//2表示虚拟仓,虚拟仓不参加统计
  676. ->leftJoin('warehouse_info whi','whi.wsm_code=gs.wsm_code AND whi.is_del=0')
  677. ->group("gs.wsm_code")
  678. ->field("gs.wsm_code")
  679. ->buildSql();
  680. $count = Db::table($build." a")->count();
  681. $page>=ceil($count/$size) ? $page=ceil($count/$size) :"";
  682. $list = Db::name("good_stock")
  683. ->alias('gs')
  684. ->where($condition)
  685. ->where('whi.wsm_type','<>',2)//2表示虚拟仓,虚拟仓不参加统计
  686. ->page($page,$size)
  687. ->leftJoin('warehouse_info whi','whi.wsm_code=gs.wsm_code AND whi.is_del=0')
  688. ->group("gs.wsm_code")
  689. ->field("gs.wsm_code,sum(wait_in_stock) wait_in_stock,sum(wait_out_stock) wait_out_stock,sum(usable_stock) usable_stock,sum(intra_stock) intra_stock,sum(warn_stock) warn_stock,sum(usable_stock+wait_out_stock) total_stock")
  690. ->select()
  691. ->toArray();
  692. $warehouse_info = Db::name("warehouse_info")
  693. ->alias("a")
  694. ->where(['a.wsm_code'=>array_column($list,'wsm_code'),"a.is_del"=>0])
  695. ->column("a.name as wsm_name,wsm_code,a.supplierNo,a.supplierName,a.companyNo,a.companyName,a
  696. .contactor_name",'a.wsm_code');
  697. // ->find();
  698. $persionArr = get_personid_by_supplierNo(array_unique(array_column($warehouse_info,'supplierNo')),'person');
  699. $data=[];
  700. foreach ($list as $key=>$value){
  701. $temp=[];
  702. $temp['wsm_name'] = isset($warehouse_info[$value['wsm_code']]['wsm_name'])?$warehouse_info[$value['wsm_code']]['wsm_name']:"";
  703. $temp['wsm_code']=$value['wsm_code'];
  704. $temp['supplier_code']=isset($warehouse_info[$value['wsm_code']]['supplierNo'])?$warehouse_info[$value['wsm_code']]['supplierNo']:"";
  705. $temp['supplier_name']=isset($warehouse_info[$value['wsm_code']]['supplierName'])?$warehouse_info[$value['wsm_code']]['supplierName']:"";
  706. $temp['company_no']=isset($warehouse_info[$value['wsm_code']]['companyNo'])?$warehouse_info[$value['wsm_code']]['companyNo']:"";
  707. $temp['company_name']=isset($warehouse_info[$value['wsm_code']]['companyName'])?$warehouse_info[$value['wsm_code']]['companyName']:"";
  708. $temp['contactor_name']=isset($warehouse_info[$value['wsm_code']]['contactor_name'])?$warehouse_info[$value['wsm_code']]['contactor_name']:"";
  709. $temp['person']=$persionArr[$warehouse_info[$value['wsm_code']]['supplierNo']]??"";
  710. $temp['usable_stock'] = $value['usable_stock'];
  711. $temp['wait_in_stock'] = $value['wait_in_stock'];
  712. $temp['wait_out_stock'] = $value['wait_out_stock'];
  713. $temp['intra_stock'] = $value['intra_stock'];
  714. $temp['total_stock'] = $value['usable_stock']+$value['wait_out_stock'] ;
  715. // $temp['child']=isset($good)&&!empty($good) ? $good:[];
  716. $data[]=$temp;
  717. }
  718. return app_show(0,"获取成功",["list"=>$data,"count"=>$count]);
  719. }
  720. //库存统计 仓库维度 明细
  721. public function GetStockWsmChild()
  722. {
  723. $wsm_code = $this->request->post('wsm_code', '', 'trim');
  724. $good = Db::name("good_stock")
  725. ->alias("a")
  726. ->leftJoin("good c", "c.spuCode=a.spuCode")
  727. ->where(["a.wsm_code" => $wsm_code, "a.is_del" => 0, "c.is_del" => 0])
  728. ->select()
  729. ->toArray();
  730. // $names = $userCommon->handle('getCodeAndName', [$wsm['supplierNo'], $wsm['companyNo']]);
  731. // $wsm['supplierName'] = $names['data'][$wsm['supplierNo']] ?? '';
  732. // $wsm['company'] = $names['data'][$wsm['companyNo']] ?? '';
  733. //商品单位和品牌
  734. $good_unit_s = Db::name("unit")
  735. ->whereIn('id', array_column($good, 'good_unit'))
  736. ->where('is_del', 0)
  737. ->column('unit', 'id');
  738. $brands = Db::name("brand")
  739. ->whereIn('id', array_column($good, 'brand_id'))
  740. ->where('is_del', 0)
  741. ->column('brand_name', 'id');
  742. foreach ($good as &$item_good) {
  743. //规格信息
  744. $spec = Db::name("good_spec")->field('id,spec_id,spec_value_id')->where(["spuCode" => $item_good['spuCode'], "is_del" => 0])->select()->toArray();
  745. $speclist = [];
  746. if (!empty($spec)) {
  747. foreach ($spec as $val) {
  748. $tmp = [];
  749. $tmp['spec_id'] = $val['spec_id'];
  750. $tmp['spec_value_id'] = $val['spec_value_id'];
  751. $sp = Db::name("specs")->where(["id" => $val['spec_id']])->find();
  752. $tmp['spec_name'] = isset($sp["spec_name"]) ? $sp["spec_name"] : "";
  753. $spv = Db::name("spec_value")->where(["id" => $val['spec_value_id']])->find();
  754. $tmp['spec_value_name'] = isset($spv["spec_value"]) ? $spv["spec_value"] : "";
  755. $speclist[] = $tmp;
  756. }
  757. }
  758. $item_good['specinfo'] = $speclist;
  759. $item_good['unit'] = $good_unit_s[$item_good['good_unit']] ?? '';
  760. $item_good['brand_name'] = $brands[$item_good['brand_id']] ?? '';
  761. $item_good['can'] = made($item_good['cat_id'], []);
  762. $item_good['total_stock'] = $item_good['usable_stock'] + $item_good['wait_out_stock'];
  763. }
  764. return json_show(0, '获取成功', $good);
  765. }
  766. //库存统计 商品维度
  767. public function GetStockGod(){
  768. $page = isset($this->post['page']) &&$this->post['page'] !=="" ? intval($this->post['page']):1;
  769. $size = isset($this->post['size']) &&$this->post['size'] !=="" ? intval($this->post['size']):10;
  770. // $condition = [["b.is_del","=",0],["c.usable_stock",">",0],["a.wsm_type","<>",2]];
  771. $condition = [["b.is_del", "=", 0], ["a.wsm_type", "<>", 2]];//库存为0的也要显示出来
  772. $type_code = isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  773. if($type_code!==""){
  774. $condition[]=["b.spuCode","like","%{$type_code}%"];
  775. }
  776. $good_name = isset($this->post['good_name']) && $this->post['good_name'] !== "" ? trim($this->post['good_name']) : "";
  777. if ($good_name !== "") {
  778. $condition[] = ["b.good_name", "like", "%{$good_name}%"];
  779. }
  780. $relaComNo = isset($this->post['relaComNo']) && $this->post['relaComNo']!="" ? trim($this->post['relaComNo']):"";
  781. if($relaComNo!="") $condition[]=['b.companyNo','=', $relaComNo];
  782. $supplierNo = isset($this->post['supplierNo']) && $this->post['supplierNo']!="" ? trim($this->post['supplierNo']):"";
  783. if($supplierNo!=="") $condition[]=['b.supplierNo','=', $supplierNo];
  784. $count = Db::name("good")
  785. ->alias("b")
  786. ->join("good_stock c","c.spuCode = b.spuCode","left")
  787. ->leftJoin("warehouse_info a","a.wsm_code=c.wsm_code")
  788. ->where($condition)
  789. ->group("b.spuCode,b.good_name,b.good_unit,b.cat_id,b.craft_desc,b.addtime")
  790. ->count();
  791. $page>=ceil($count/$size) ? $page=ceil($count/$size) :"";
  792. $list = Db::name("good")
  793. ->alias("b")
  794. ->join("good_stock c","c.spuCode = b.spuCode","left")
  795. ->leftJoin("warehouse_info a","a.wsm_code=c.wsm_code")
  796. ->where($condition)
  797. ->field("b.spuCode,b.good_name,b.good_unit,b.brand_id,b.cat_id,b.craft_desc,b.addtime,sum(c.wait_in_stock) wait_in_stock,sum(c.wait_out_stock) wait_out_stock,sum(c.usable_stock) usable_stock,sum(c.intra_stock) intra_stock,sum(c.warn_stock) warn_stock,(sum(c.usable_stock)+sum(c.wait_out_stock)) total_stock")
  798. ->page($page,$size)
  799. ->order("b.addtime desc")
  800. ->group("b.spuCode,b.good_name,b.good_unit,b.brand_id,b.cat_id,b.craft_desc,b.addtime")
  801. ->select()
  802. ->toArray();
  803. $data=[];
  804. if($list) {
  805. //商品单位和品牌
  806. $good_unit_s = Db::name("unit")->whereIn('id', array_column($list, 'good_unit'))->where('is_del', 0)->column('unit', 'id');
  807. $brands = Db::name("brand")->whereIn('id', array_column($list, 'brand_id'))->where('is_del', 0)->column('brand_name', 'id');
  808. $userCommon = \app\admin\common\User::getIns();
  809. foreach ($list as $key => $value) {
  810. $temp = [];
  811. if ($value['spuCode'] != "") {
  812. $child = Db::name("good_stock")
  813. ->alias("a")
  814. ->join("warehouse_info b", "a.wsm_code=b.wsm_code", "left")
  815. ->where(['a.spuCode' => $value['spuCode'], "a.is_del" => 0])
  816. ->where("b.wsm_type","<>",2)
  817. ->field("a.wsm_code,b.name wsm_name,a.wait_in_stock,a.wait_out_stock,a.usable_stock,a.intra_stock,(a.wait_out_stock+a.usable_stock) total_stock,a.warn_stock,b.supplierNo,b.companyNo,b.contactor_name")
  818. ->select()
  819. ->toArray();
  820. foreach ($child as &$vvv){
  821. $names = $userCommon->handle('getCodeAndName',['code'=>[$vvv['supplierNo'],$vvv['companyNo']]]);
  822. $person = get_personid_by_supplierNo([$vvv['supplierNo']],'person');
  823. $vvv['person'] =$person[$vvv['supplierNo']]??"";
  824. $vvv['supplierName'] = $names['data'][$vvv['supplierNo']]??'';
  825. $vvv['company'] = $names['data'][$vvv['companyNo']]??'';
  826. }
  827. // echo Db::name("good_stock")->getLastSql();
  828. }
  829. $temp['good_name'] = $value['good_name'];
  830. $temp['good_code'] = $value['spuCode'];
  831. $temp['type_code'] = '';
  832. // $unit = Db::name("unit")->where(['id' => $value['good_unit']])->find();
  833. $temp['unit'] =$good_unit_s[$value['good_unit']]??'';
  834. $temp['brand_name'] =$brands[$value['brand_id']]??'';
  835. $temp['sort_f'] = isset($value['cat_id']) ? made($value['cat_id']) : [];
  836. $temp['sort_f'] = implode('/', array_column($temp['sort_f'], 'name'));//由于这个字段原样在页面显示,所以在这里特意拼接成字符串
  837. $temp['attribute'] = $value['craft_desc'];
  838. $temp['addtime'] = $value['addtime'];
  839. $temp['usable_stock'] = isset($value['usable_stock']) ? $value['usable_stock'] : "";
  840. $temp['wait_in_stock'] = isset($value['wait_in_stock']) ? $value['wait_in_stock'] : "";
  841. $temp['wait_out_stock'] = isset($value['wait_out_stock']) ? $value['wait_out_stock'] : "";
  842. $temp['intra_stock'] = isset($value['intra_stock']) ? $value['intra_stock'] : "";
  843. $temp['total_stock'] = intval($value['wait_out_stock'])+intval($value['usable_stock']);
  844. // $temp['warn_stock'] = isset($value['warn_stock'])? $value['warn_stock']:"";
  845. $temp['child'] = isset($child) && !empty($child) ? $child : [];
  846. //规格信息
  847. $spec = Db::name("good_spec")->field('id,spec_id,spec_value_id')->where(["spuCode" => $value['spuCode'], "is_del" => 0])->select()->toArray();
  848. $speclist = [];
  849. if (!empty($spec)) {
  850. foreach ($spec as $val) {
  851. $tmp = [];
  852. $tmp['spec_id'] = $val['spec_id'];
  853. $tmp['spec_value_id'] = $val['spec_value_id'];
  854. $sp = Db::name("specs")->where(["id" => $val['spec_id']])->find();
  855. $tmp['spec_name'] = isset($sp["spec_name"]) ? $sp["spec_name"] : "";
  856. $spv = Db::name("spec_value")->where(["id" => $val['spec_value_id']])->find();
  857. $tmp['spec_value_name'] = isset($spv["spec_value"]) ? $spv["spec_value"] : "";
  858. $speclist[] = $tmp;
  859. }
  860. }
  861. $temp['specinfo'] = $speclist;
  862. $data[] = $temp;
  863. }
  864. }
  865. return app_show(0,"获取成功",["list"=>$data,"count"=>$count]);
  866. }
  867. /**
  868. * @return \think\response\Json|void
  869. * @throws \think\db\exception\DataNotFoundException
  870. * @throws \think\db\exception\DbException
  871. * @throws \think\db\exception\ModelNotFoundException
  872. */
  873. public function Stat(){
  874. $condition =[["gs.is_del","=",0]];
  875. $wsm_code = isset($this->post['wsm_code']) &&$this->post['wsm_code'] !=="" ? trim($this->post['wsm_code']):"";
  876. if($wsm_code!=""){
  877. //$condition["gs.wsm_code"] = $wsm_code;
  878. $condition[]=["gs.wsm_code","=",$wsm_code];
  879. }
  880. $supplierNo = isset($this->post['supplierNo']) &&$this->post['supplierNo'] !=="" ? trim($this->post['supplierNo']) :"";
  881. if($supplierNo!=="") $condition[]=["whi.supplierNo","=",$supplierNo];
  882. $companyNo = isset($this->post['companyNo']) && $this->post['companyNo'] !== "" ? trim($this->post['companyNo']) : "";
  883. if ($companyNo !== "") {
  884. // $where['khNo'] = $khNo;
  885. $wsmcode = Db::name("warehouse_info")->where(['companyNo' => $companyNo, "is_del" => 0])->column("wsm_code");
  886. $condition[] = ["gs.wsm_code", "in", $wsmcode];
  887. }
  888. $relaComNo = isset($this->post['relaComNo']) && $this->post['relaComNo']!="" ? trim($this->post['relaComNo']):"";
  889. if($relaComNo!="") {
  890. $wsmcode = Db::name("warehouse_info")
  891. ->where(['companyNo'=>$relaComNo,"is_del"=>0])
  892. ->column("wsm_code");
  893. $condition[]=["gs.wsm_code","in",$wsmcode];
  894. }
  895. $good_name = trim($this->post['good_name'] ?? '');
  896. if ($good_name !== '') $condition[] = ['c.good_name', 'like', '%' . $good_name . '%'];
  897. $spuCode = trim($this->post['spuCode'] ?? '');
  898. if ($spuCode !== '') $condition[] = ['gs.spuCode', 'like', '%' . $spuCode . '%'];
  899. $is_stock = trim($this->post['is_stock'] ?? '');
  900. if ($is_stock !== '') $condition[] = ['c.is_stock', '=', $is_stock];
  901. // $type_code = isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  902. // if($type_code!=""){
  903. // $condition[] = ["gs.good_type_code","=",$type_code];
  904. // }
  905. $statlist = Db::name("good_stock")
  906. ->alias('gs')
  907. ->where($condition)
  908. ->where('whi.wsm_type','<>',2)//2表示虚拟仓,虚拟仓不参与
  909. ->leftJoin('warehouse_info whi','whi.wsm_code=gs.wsm_code AND whi.is_del=0')
  910. ->leftJoin('good_basic c','c.spuCode=gs.spuCode AND c.is_del=0')
  911. ->field("sum(gs.wait_in_stock) as wait_in_stock,sum(gs.wait_out_stock) as wait_out_stock ,sum(gs.usable_stock) as usable_stock,sum(gs.intra_stock) as intra_stock,sum(gs.usable_stock+gs.wait_out_stock) as total_stock,sum(gs.warn_stock) as warn_stock")
  912. ->findOrEmpty();
  913. return app_show(0,"获取成功",$statlist);
  914. }
  915. //废弃接口
  916. public function all(){
  917. $condtion=["a.is_del"=>0,"b.is_del"=>0];
  918. $wsmcode =isset($this->post['wsmcode']) &&$this->post['wsmcode'] !=="" ? trim($this->post['wsmcode']):"";
  919. if($wsmcode!=""){
  920. $typecode= Db::name("good_stock")->where(["wsm_code"=>$wsmcode,'is_del'=>0])->column("good_type_code");
  921. $condtion["b.type_code"] = $typecode;
  922. }
  923. $good_code =isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  924. if($good_code!=""){
  925. $condtion['b.type_code'] = $good_code;
  926. }
  927. $goodcode =isset($this->post['good_code']) &&$this->post['good_code'] !=="" ? trim($this->post['good_code'])
  928. :"";
  929. if($goodcode!=""){
  930. $condtion['a.good_code'] = $goodcode;
  931. }
  932. $good_name =isset($this->post['good_name']) &&$this->post['good_name'] !=="" ? trim($this->post['good_name'])
  933. :"";
  934. if($good_name!=""){
  935. $condtion['a.good_name'] = Db::raw("like '%{$good_name}%'");
  936. }
  937. $supplierNo =isset($this->post['supplierNo']) &&$this->post['supplierNo'] !=="" ? trim($this->post['supplierNo']):"";
  938. if($supplierNo!=""){
  939. // $supplier = Db::name("supplier")->where(["code"=>$supplierNo])->find();
  940. // if(empty($supplier)){
  941. // return error_show(1004,"未找到供应商信息");
  942. // }
  943. $condtion["a.gys_code"] = $supplierNo;
  944. }
  945. $list = Db::name("good_type")->alias("b")->join("good a","a.good_code = b.good_code","left")
  946. ->where($condtion)->field("b.id,a.good_code,a.good_name,a.good_desc,a.brand,a.original_price,a.cg_saler,a.good_type,a.market_fee,a.gys_code,a.unit,
  947. a.sort_f,a.sort_s,a.sort_t,b.color,b.material,b.specs,b.is_main,b.type_code,b.attribute,b.status as bstatus,a.addtime,a.updatetime")
  948. ->select();
  949. $data=[];
  950. foreach ($list as $key=>$value){
  951. $stock = Db::name("good_stock")->where(["good_type_code"=>$value['type_code'],"is_del"=>0])->sum("usable_stock");
  952. $value['usable_stock']=$stock;
  953. //废弃
  954. $supplier = Db::name("supplier")->where(["code"=>$value['gys_code']])->find();//废弃
  955. $value['supplier_name'] =isset($supplier['name']) ?$supplier['name'] :"";
  956. $data[]=$value;
  957. }
  958. return app_show(0,"获取成功",$data);
  959. }
  960. //库存概况
  961. public function loglist(){
  962. $param = $this->request->filter('trim')->only(['wsm_code'=>'','supplierNo'=>'','companyNo'=>'','is_stock'=>'','good_name'=>'','spuCode'=>'','page'=>1,'size'=>10,'relaComNo'=>''],'post');
  963. $where=[];
  964. if($param['wsm_code']!="") $where[]=['b.wsm_code',"like","%".$param['wsm_code']."%"];
  965. // $supplierNo =isset($this->post['supplierNo']) &&$this->post['supplierNo'] !=="" ? trim($this->post['supplierNo']):"";
  966. if($param['supplierNo']!=""){
  967. $where[]=['c.supplierNo',"=",$param['supplierNo']];
  968. }
  969. // $companyNo = isset($this->post['companyNo']) && $this->post['companyNo'] !== "" ? trim($this->post['companyNo']) : "";
  970. if ($param['companyNo'] !== "") {
  971. $wsmcode = Db::name("warehouse_info")->where(['companyNo'=>$param['companyNo'],"is_del"=>0])->column("wsm_code");
  972. $where[]=["b.wsm_code","in",$wsmcode];
  973. }
  974. if ($param['relaComNo'] != '') {
  975. $wsmcode = Db::name("warehouse_info")
  976. ->where(['companyNo' => $param['relaComNo'], "is_del" => 0])
  977. ->column("wsm_code");
  978. $where[] = ["b.wsm_code", "in", $wsmcode];
  979. }
  980. if($param['is_stock']!="") $where[]=['c.is_stock','=',$param['is_stock']];
  981. if($param['good_name']!="") $where[]=['c.good_name','like','%'.$param['good_name'].'%'];
  982. if($param['spuCode']!="") $where[]=['b.spuCode','like','%'.$param['spuCode'].'%'];
  983. $count = Db::name("good_log")
  984. ->alias('a')
  985. ->leftJoin("good_stock b","b.id=a.stock_id")
  986. ->leftJoin('good c','c.spuCode=b.spuCode')
  987. ->where($where)
  988. ->count();
  989. $total = ceil($count/$param['size']);
  990. $page = $total>=$param['page'] ? $param['page'] :$total;
  991. $list = Db::name("good_log")
  992. ->alias('a')
  993. ->field("a.good_log_code,a.action_name,a.type,a.stock_name,a.stock,a.action_type,b.spuCode,a.addtime,a.action_uid,b.wsm_code,c.is_stock,c.good_name,c.cat_id,c.companyNo,c.supplierNo")
  994. ->leftJoin('good_stock b','b.id=a.stock_id')
  995. ->leftJoin('good c','c.spuCode=b.spuCode')
  996. ->where($where)
  997. ->page($page,$param['size'])
  998. ->order("a.addtime desc")
  999. ->select()
  1000. ->toArray();
  1001. // $data=[];
  1002. $action_uids = array_column($list, 'action_uid');
  1003. $action_uids = array_unique($action_uids);
  1004. $item = get_company_name_by_uid($action_uids);
  1005. // $item = [];
  1006. // foreach ($action_uids as $action_uid) {
  1007. // $items = Db::name("depart_user")->where('uid', $action_uid)->column("itemid");
  1008. // foreach ($items as $it) {
  1009. // $item[$action_uid][] = implode('/', array_column(GetPart($it), 'name'));
  1010. // }
  1011. // }
  1012. $userCommon = \app\admin\common\User::getIns();
  1013. $wsmcode = Db::name("warehouse_info")
  1014. ->alias("a")
  1015. ->where(['a.wsm_code'=>array_column($list,"wsm_code"),"a.is_del"=>0])
  1016. ->column("a.name as wsm_name","wsm_code");
  1017. $names = $userCommon->handle('getCodeAndName', ['code' =>array_merge(array_column($list,"companyNo"),array_column($list,"supplierNo"))]);
  1018. foreach ($list as &$value){
  1019. $value['supplierName'] = $names['data'][$value['supplierNo']] ?? '';
  1020. $value['company'] = $names['data'][$value['companyNo']] ?? '';
  1021. $int = isset($value['cat_id']) && $value['cat_id'] != 0 ? made($value['cat_id']) : [];
  1022. $value['wsm_name'] =$wsmcode[$value['wsm_code']]??"";
  1023. $value['action_type_cn'] =$this->acton[$value['action_type']];
  1024. $value['item'] = $item[$value['action_uid']] ?? '';
  1025. $value['can'] =$int;
  1026. }
  1027. return app_show(0,"获取成功",['list'=>$list,'count'=>$count]);
  1028. }
  1029. public function goodlist()
  1030. {
  1031. $page = isset($this->post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) : "1";
  1032. $size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) : "10";
  1033. $where = [["a.is_del", "=", 0], ["b.exam_status", "=", 3], ["b.is_del", "=", 0], ["c.is_del", "=", 0], ["c.status", "=", 1]];
  1034. $paltcode = isset($this->post["platform_code"]) && $this->post["platform_code"] != "" ? trim($this->post["platform_code"]) : "";
  1035. if ($paltcode != "") {
  1036. $where[] = ["platform_code", "=", $paltcode];
  1037. }
  1038. $companyNo = isset($this->post["companyNo"]) && $this->post["companyNo"] != "" ? trim($this->post["companyNo"]) : "";
  1039. if ($companyNo != "") {
  1040. $where[] = ["companyNo", "like", "%$companyNo%"];
  1041. }
  1042. $cat_id = isset($this->post["cat_id"]) && $this->post["cat_id"] !== "" ? intval($this->post["cat_id"]) : "";
  1043. if ($cat_id !== "") {
  1044. //获取当前分类及所有子级
  1045. $where[] = ["cat_id", "in", manger([$cat_id])];
  1046. }
  1047. $buy_num = isset($this->post["buy_num"]) && $this->post["buy_num"] !== "" ? intval($this->post["buy_num"]) : "";
  1048. if ($buy_num !== "") {
  1049. $where[] = ["c.min_num", "<=", $buy_num];
  1050. }
  1051. $price = isset($this->post["price"]) && $this->post["price"] !== "" ? floatval($this->post["price"]) : "";
  1052. if ($price !== "") {
  1053. $where[] = ["c.sale_price", "<=", $price];
  1054. }
  1055. $temp = Db::name('good_ladder')
  1056. ->field('skuCode,MAX(min_num) min_num')
  1057. ->where([
  1058. ['min_num', '<=', $buy_num],
  1059. ['sale_price', '<=', $price],
  1060. ['is_del', '=', 0],
  1061. ['status', '=', 1],
  1062. ])->group('skuCode')
  1063. ->order('skuCode', 'desc')->buildSql();
  1064. $count = Db::name('good_ladder')
  1065. ->alias('c')
  1066. ->field('c.id,c.skuCode,c.min_num,c.sale_price,a.good_name,a.`spuCode`,a.`cat_id`,a.`brand_id`,a.`companyNo`,a.`supplierNo`,a.`good_unit`,b.`skuCode`,b.`platform_code`,b.`plat_code`,b.id AS good_id,b.`addtime`,b.`updatetime`,b.`exam_status`')
  1067. ->join($temp . ' temp', 'temp.skuCode = c.skuCode AND temp.min_num = c.min_num')
  1068. ->leftJoin('good_platform b', 'b.skuCode=c.skuCode')
  1069. ->leftJoin('good a', 'a.spuCode = b.spuCode AND a.is_del=0')
  1070. ->where($where)
  1071. ->count();
  1072. $total = ceil($count / $size);
  1073. $page = $page >= $total ? $total : $page;
  1074. $list = Db::name('good_ladder')
  1075. ->alias('c')
  1076. ->field('c.id,c.skuCode,c.min_num,c.sale_price,a.good_name,a.`spuCode`,a.`cat_id`,a.`brand_id`,a.`companyNo`,a.`supplierNo`,a.`good_unit`,b.`skuCode`,b.`platform_code`,b.`plat_code`,b.id AS good_id,b.`addtime`,b.`updatetime`,b.`exam_status`')
  1077. ->join($temp . ' temp', 'temp.skuCode = c.skuCode AND temp.min_num = c.min_num')
  1078. ->leftJoin('good_platform b', 'b.skuCode=c.skuCode')
  1079. ->leftJoin('good a', 'a.spuCode = b.spuCode AND a.is_del=0')
  1080. ->where($where)
  1081. ->page($page,$size)
  1082. ->select()
  1083. ->toArray();
  1084. // $list = Db::name('good')
  1085. // ->alias("a")
  1086. // ->leftJoin("good_platform b","a.spuCode=b.spuCode")
  1087. // ->leftJoin("good_ladder c","b.skuCode=c.skuCode")
  1088. // ->where($where)->fetchSql()
  1089. // ->where('a.spuCode','SKU2205251851017540')
  1090. // ->page($page,$size)
  1091. // ->field("c.id,c.min_num,c.sale_price,a.good_name,a.spuCode,a.cat_id,a.brand_id,a.companyNo,a.supplierNo,a.good_unit,b.skuCode,b.platform_code,b.plat_code,b.id as good_id,b.addtime,b.updatetime,b.exam_status")
  1092. // ->order("b.addtime desc")
  1093. // ->select();halt($list);
  1094. // ->toArray();
  1095. $data = [];
  1096. $platform = Db::name('platform')
  1097. ->whereIn('id',array_column($list,'platform_code'))
  1098. ->column('platform_name,platform_code','id');
  1099. $brand = Db::name('brand')
  1100. ->whereIn('id',array_column($list,'brand_id'))
  1101. ->column('brand_name','id');
  1102. $unit = Db::name('unit')
  1103. ->whereIn('id',array_column($list,'good_unit'))
  1104. ->column('unit','id');
  1105. $userCommon =\app\admin\common\User::getIns();
  1106. $names = $userCommon->handle('getCodeAndName',['code'=>array_merge(array_column($list,'supplierNo'),array_column($list,'companyNo'))]);
  1107. foreach ($list as $value) {
  1108. $value['cat_info'] = made($value['cat_id'], []);
  1109. // $platform = Db::name("platform")->where(["id" => $value['platform_code']])->find();
  1110. $value['platform_name'] = $platform[$value['platform_code']]['platform_name']??'';//isset($platform['platform_name']) ? $platform['platform_name'] : "";
  1111. $value['platform_code_en'] = $platform[$value['platform_code']]['platform_code']??'';//isset($platform['platform_code']) ? $platform['platform_code'] : "";
  1112. // $supplier = Db::name("supplier")->where(["code" => $value['supplierNo']])->find();
  1113. $value['supplier_name'] = $names['data'][$value['supplierNo']]??'';//isset($supplier['name']) ? $supplier['name'] : "";
  1114. // $brand = Db::name("brand")->where(["id" => $value['brand_id']])->find();
  1115. $value["brand_name"] = $brand[$value['brand_id']]??'';//isset($brand['brand_name']) ? $brand['brand_name'] : "";
  1116. // $unit = Db::name("unit")->where(["id" => $value['good_unit']])->find();
  1117. $value['unit'] = $unit[$value['good_unit']]??'';//isset($unit['unit']) ? $unit['unit'] : "";
  1118. // $company = Db::name("business")->where(["companyNo" => $value['companyNo']])->find();
  1119. $value['company'] = $names['data'][$value['companyNo']]??'';//isset($company['company']) ? $company['company'] : "";
  1120. $value['stock_total'] = Db::name("good_stock")->where(['spuCode' => $value['spuCode'], "is_del" => 0])->sum("usable_stock");
  1121. $value['status'] = $value['exam_status'];
  1122. $data[] = $value;
  1123. }
  1124. return app_show(0, "获取成功", ['list' => $data, 'count' => $count]);
  1125. }
  1126. //根据价格区间,筛选符合条件的商品列表
  1127. public function getGoodListByLadder()
  1128. {
  1129. //1.请求参数
  1130. $param = $this->request->only([
  1131. 'good_type' => '',
  1132. // 'start' => '',
  1133. // 'end' => '',
  1134. 'is_stock' => '',
  1135. 'cat_id' => 0,
  1136. 'brand_id' => 0,
  1137. 'min_price' => 0,
  1138. 'max_price' => 0,
  1139. 'moq' => 0,//最低起订量?
  1140. 'good_name' => '',
  1141. 'skucode' => '',
  1142. 'spucode' => '',
  1143. 'companyNo' => '',//业务企业编号
  1144. 'plat_code' => '',//平台商品编号
  1145. 'creater' => '',//创建人
  1146. 'platform_code' => '',
  1147. 'supplierNo' => '',
  1148. 'page' => 1,
  1149. 'size' => 15,
  1150. 'company_name'=>'',
  1151. 'relaComNo'=>'',
  1152. ], 'post', 'trim');
  1153. $where = [["gl.is_del", "=", 0], ['gp.exam_status', '=', 3]];//exam_status==6已上线
  1154. if ($param['good_type']!='') $where[] = ['gb.good_type', '=', $param['good_type']];
  1155. // if (!empty($param['start'])) $where[] = ['gl.addtime', '>=', $param['start']];
  1156. // if (!empty($param['end'])) $where[] = ['gl.addtime', '<=', $param['end'] . ' 23:59:59'];
  1157. if ($param['is_stock']!='') $where[] = ['gb.is_stock', '=', $param['is_stock']];
  1158. if (!empty($param['cat_id'])) $where[] = ['gb.cat_id', '=', $param['cat_id']];
  1159. if (!empty($param['brand_id'])) $where[] = ['gb.brand_id', '=', $param['brand_id']];
  1160. if ($param['min_price']!='' && $param['max_price']!='') $where[] = ['gl.sale_price', 'between', [$param['min_price'], $param['max_price']]];
  1161. if (!empty($param['moq'])) $where[] = ['gl.min_num', '>=', $param['moq']];
  1162. if (!empty($param['good_name'])) $where[] = ['gb.good_name', 'like', '%' . $param['good_name'] . '%'];
  1163. if (!empty($param['skucode'])) $where[] = ['gl.skuCode', 'like', '%' . $param['skucode'] . '%'];
  1164. if (!empty($param['spucode'])) $where[] = ['gp.spuCode', 'like', '%' . $param['spucode'] . '%'];
  1165. if (!empty($param['companyNo'])) $where[] = ['gb.companyNo', 'like', '%' . $param['companyNo'], '%'];
  1166. if (!empty($param['plat_code'])) $where[] = ['gp.plat_code', 'like', '%' . $param['plat_code'], '%'];
  1167. if (!empty($param['creater'])) $where[] = ['gb.creater', 'like', '%' . $param['creater'], '%'];
  1168. if (!empty($param['platform_code'])) $where[] = ['gp.platform_code', 'like', '%' . $param['platform_code'], '%'];
  1169. if (!empty($param['company_name'])) $where[] = ['gb.createrid', 'in', get_company_item_user_by_name($param['company_name'])];
  1170. // if (!empty($param['supplierNo'])) $where[] = ['supplierNo', 'like', '%'.$param['supplierNo'],'%'];
  1171. if ($param['relaComNo'] != '') $where[] = ['gb.companyNo|gb.supplierNo', '=', $param['relaComNo']];
  1172. //5.获取结果
  1173. $count = Db::name('good_ladder')
  1174. ->alias('gl')
  1175. //->field('gl.id,gl.skuCode,gp.spuCode,p.platform_name,gb.good_thumb_img,gb.good_name,gb.cat_id,gb.good_type,gb.is_stock,gb.brand_id,gp.plat_code,gl.min_num,gl.sale_price,gb.creater purchase,gb.creater,gb.companyNo,u.itemid')
  1176. ->leftJoin('good_platform gp', 'gp.skuCode=gl.skuCode AND gp.is_del=0')
  1177. ->leftJoin('platform p', 'p.id=gp.platform_code AND p.is_del=0')
  1178. ->leftJoin('good gb', 'gb.spuCode=gp.spuCode AND gb.is_del=0')
  1179. // ->leftJoin("depart_user u", "u.uid=gb.createrid AND u.is_del=0")
  1180. ->where($where)
  1181. ->count('gl.id');
  1182. $list = Db::name('good_ladder')
  1183. ->alias('gl')
  1184. ->field('gl.id,gl.skuCode,gp.spuCode,p.platform_name,gb.good_thumb_img,gb.good_name,gb.cat_id,gb.good_type,gb.is_stock,gb.brand_id,gp.plat_code,gl.min_num moq,gl.sale_price,gb.creater ,"" purchase,gb.createrid,gb.companyNo,gb.companyName,gb.supplierNo')
  1185. ->leftJoin('good_platform gp', 'gp.skuCode=gl.skuCode AND gp.is_del=0')
  1186. ->leftJoin('platform p', 'p.id=gp.platform_code AND p.is_del=0')
  1187. ->leftJoin('good_basic gb', 'gb.spuCode=gp.spuCode AND gb.is_del=0')
  1188. ->where($where)
  1189. ->page($param['page'], $param['size'])
  1190. ->order(['gl.skuCode' => 'asc', 'gl.addtime' => 'desc', 'gl.id' => 'desc'])
  1191. ->select()
  1192. ->toArray();
  1193. $all_createrid = array_column($list,'createrid');
  1194. $item = get_company_name_by_uid($all_createrid);
  1195. //6.补充数据,照搬list方法
  1196. $all_brand = Db::name('brand')
  1197. ->where('is_del', 0)
  1198. ->whereIn('id', array_column($list, 'brand_id'))
  1199. ->column('brand_name', 'id');
  1200. $userCommon = \app\admin\common\User::getIns();
  1201. $temp = $userCommon->handle('sGetList',['more_code'=>array_column($list,'supplierNo')]);
  1202. $person = array_column($temp['data']['list'],'person','code');
  1203. // $names = $userCommon->handle('getCodeAndName', ['code' => array_column($list, 'companyNo')]);
  1204. // $all_company = $names['data'];
  1205. // $all_company = Db::name('business')
  1206. // ->where('is_del', 0)
  1207. // ->whereIn('companyNo', array_column($list, 'companyNo'))
  1208. // ->column('company', 'companyNo');
  1209. foreach ($list as &$value) {
  1210. $value['cat_info'] = made($value['cat_id'], []);
  1211. $value['brand_name'] = isset($all_brand[$value['brand_id']]) ? $all_brand[$value['brand_id']] : '';
  1212. // $value['company'] = isset($all_company[$value['companyNo']]) ? $all_company[$value['companyNo']] : '';
  1213. $value['stock_total'] = Db::name("good_stock")
  1214. ->where(['spuCode' => $value['spuCode'], "is_del" => 0])
  1215. ->sum("usable_stock");
  1216. $value['company_name'] = $item[$value['createrid']]??'';
  1217. $value['purchase'] = $person[$value['supplierNo']] ?? '';//供应商负责人
  1218. }
  1219. return app_show(0, "获取成功", ['list' => $list, 'count' => $count]);
  1220. }
  1221. }