Resign.php 33 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677
  1. <?php
  2. /**
  3. * 备库申请
  4. */
  5. namespace app\admin\controller;
  6. use app\admin\model\ActionLog;
  7. use app\admin\model\ProcessOrder;
  8. use app\BaseController;
  9. use think\facade\Db;
  10. use think\App;
  11. class Resign extends BaseController
  12. {
  13. public $post="";
  14. public function __construct(App $app)
  15. {
  16. parent::__construct($app);
  17. $this->post = $this->request->post();
  18. $token = isset($this->post['token']) ? trim($this->post['token']) : "";
  19. if($token==""){
  20. return error_show(101,'token不能为空');
  21. }
  22. $effetc = VerifyTokens($token);
  23. if(!empty($effetc) && $effetc['code']!=0) {
  24. return error_show($effetc['code'], $effetc['message']);
  25. }
  26. }
  27. public function list(){
  28. $page = isset($this->post['page']) && $this->post['page'] !=="" ? intval($this->post['page']):"1";
  29. $size = isset($this->post['size']) && $this->post['size'] !=="" ? intval($this->post['size']):"10";
  30. $where =[['is_del',"=",0]];
  31. $bkcode = isset($this->post['bk_code']) && $this->post['bk_code']!="" ? trim($this->post['bk_code']):"";
  32. if($bkcode!=""){
  33. //$where['bk_code'] = $bk_code;
  34. $where[]=['bk_code',"like","%{$bkcode}%"];
  35. }
  36. $good_code = isset($this->post['good_code']) && $this->post['good_code']!="" ? trim($this->post['good_code']):"";
  37. if($good_code!=""){
  38. // $where['good_code'] = $good_code;
  39. $where[]=['good_code',"like","%{$good_code}%"];
  40. }
  41. $good_type_code = isset($this->post['good_type_code']) && $this->post['good_type_code']!="" ? trim($this->post['good_type_code']):"";
  42. if($good_type_code!=""){
  43. // $where['good_type_code'] = $good_type_code;
  44. $where[]=['good_type_code',"like","%{$good_type_code}%"];
  45. }
  46. $wsm_code = isset($this->post['wsm_code']) && $this->post['wsm_code']!="" ? trim($this->post['wsm_code']):"";
  47. if($wsm_code!=""){
  48. //$where['wsm_code'] = $wsm_code;
  49. $where[]=['wsm_code',"=",$wsm_code];
  50. }
  51. $good_name = isset($this->post['good_name']) && $this->post['good_name']!="" ? trim($this->post['good_name']):"";
  52. if($good_name!=""){
  53. // $where['good_name'] = Db::raw(" like '%{$good_name}%'");
  54. $where[]=['good_name',"like","%{$good_name}%"];
  55. }
  56. $apply_name = isset($this->post['apply_name']) && $this->post['apply_name']!="" ? trim($this->post['apply_name']):"";
  57. if($apply_name!=""){
  58. // $where['apply_name'] =Db::Raw("like '%{$apply_name}%'");
  59. $where[]=['apply_name',"like","%{$apply_name}%"];
  60. }
  61. $status = isset($this->post['status']) && $this->post['status']!=="" ? intval($this->post['status']):"";
  62. if($status!==""){
  63. // $where['status'] = $status;
  64. $where[]=['status',"=",$status];
  65. }
  66. $start = isset($this->post['start']) && $this->post['start']!=="" ? $this->post['start']:"";
  67. if($start!==""){
  68. //$where['addtime'] = Db::Raw(">= '{$start}'");
  69. $where[]=['addtime',">=",$start];
  70. }
  71. $end = isset($this->post['end']) && $this->post['end']!=="" ? $this->post['end']:"";
  72. if($end!==""){
  73. // $where['addtime'] = Db::Raw("<= '{$end}'");
  74. $where[]=['addtime',"<=",$end];
  75. }
  76. $count=Db::name("purchease")->where($where)->count();
  77. $total = ceil($count/$size);
  78. $page = $page >= $total ? $total : $page;
  79. $list = Db::name("purchease")->where($where)->page($page,$size)->order("addtime desc")->select();
  80. $data=[];
  81. foreach ($list as $value){
  82. $value['wsm_name']="";
  83. $value['wsm_supplier']="";
  84. $value['wsm_supplierNo']="";
  85. if($value['wsm_code']!=""){
  86. $wsmcode = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code")
  87. ->where(["a.wsm_code"=>$value['wsm_code']])->field("a.name as wsm_name,b.name,b.code")->find();
  88. $value['wsm_name'] =isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name']:"";
  89. $value['wsm_supplier'] =isset($wsmcode['name']) ? $wsmcode['name']:"";
  90. $value['wsm_supplierNo'] =isset($wsmcode['code']) ? $wsmcode['code']:"";
  91. }
  92. $data[]=$value;
  93. }
  94. return app_show(0,"获取成功",["list"=>$data,"count"=>$count]);
  95. }
  96. public function add(){
  97. $token = isset($this->post['token']) ? trim($this->post['token']) : "";
  98. if($token==""){
  99. return error_show(101,'token不能为空');
  100. }
  101. $good_code = isset($this->post['good_code'])&&$this->post['good_code']!="" ? trim($this->post['good_code']):"";
  102. if($good_code==""){
  103. return error_show(1002,'参数good_code 不能为空');
  104. }
  105. $good = Db::name("good")->where(['good_code'=>$good_code,'is_del'=>0])->find();
  106. if(empty($good)){
  107. return error_show(1002,'未找到商品数据');
  108. }
  109. $good_type_code = isset($this->post['good_type_code'])&&$this->post['good_type_code']!="" ? trim($this->post['good_type_code'])
  110. :"";
  111. if($good_type_code!==""){
  112. $good_type= Db::name("good_type")->where(['good_code'=>$good_code,'is_del'=>0,'type_code'=>$good_type_code])
  113. ->find();
  114. if(empty($good_type)){
  115. return error_show(1002,'未找到商品属性数据');
  116. }
  117. }
  118. $good_num = isset($this->post['good_num'])&&$this->post['good_num']!=="" ? intval($this->post['good_num']) :"";
  119. if($good_num==''){
  120. return error_show(1002,'参数good_num 不能为空或零');
  121. }
  122. $wsm_code = isset($this->post['wsm_code'])&&$this->post['wsm_code']!="" ? trim($this->post['wsm_code']):"";
  123. if($wsm_code==""){
  124. return error_show(1002,'参数wsm_code 不能为空');
  125. }
  126. $wsminfo = Db::name("warehouse_info")->where(['wsm_code'=>$wsm_code,"is_del"=>0])->find();
  127. if(empty($wsminfo)){
  128. return error_show(1002,'未找到仓库数据');
  129. }
  130. $lastime = isset($this->post['lastime'])&&$this->post['lastime']!="" ? $this->post['lastime']:"";
  131. if($lastime==""){
  132. return error_show(1002,'参数lastime 不能为空');
  133. }
  134. $data = GetUserInfo($token);
  135. if((!empty($data) && $data['code']!=0) ||empty($data) ){
  136. return error_show($data['code'],$data['message']);
  137. }
  138. $userinfo = $data['data'];
  139. $bk_code=makeNo("BK");
  140. $info = [
  141. "good_code"=>$good_code,
  142. "good_name"=>$good['good_name'],
  143. "good_num"=>$good_num,
  144. "good_type_code"=>$good_type_code,
  145. "wsm_code"=>$wsm_code,
  146. "lasttime"=>$lastime,
  147. "addtime"=>date("Y-m-d H:i:s"),
  148. "updatetime"=>date("Y-m-d H:i:s"),
  149. "apply_id"=>$userinfo['id'],
  150. "apply_name"=>$userinfo['nickname'],
  151. "bk_code"=>$bk_code
  152. ];
  153. $in = Db::name("purchease")->insert($info,true);
  154. if($in>0){
  155. $order=["order_type"=>'BHD',"order_code"=>$bk_code,"order_id"=>$in,"order_status"=>0];
  156. ProcessOrder::AddProcess($token,$order);
  157. $ste = ["order_code"=>$bk_code,"status"=>0,"action_remark"=>'',"action_type"=>"create"];
  158. ActionLog::logAdd($token,$ste,"BHD",0,$info);
  159. return app_show(0,"新建成功",['bk_code'=>$bk_code]);
  160. }else{
  161. return error_show(1005,"新建失败");
  162. }
  163. }
  164. /**
  165. * @return \think\response\Json|void
  166. * @throws \think\db\exception\DataNotFoundException
  167. * @throws \think\db\exception\DbException
  168. * @throws \think\db\exception\ModelNotFoundException
  169. */
  170. public function copy(){
  171. $id = isset($this->post['id']) ? intval($this->post['id']) : "";
  172. if($id==""){
  173. return error_show(1001,'id不能为空');
  174. }
  175. $info = Db::name("purchease")->where(["id"=>$id,"is_del"=>0])->find();
  176. if(empty($info)){
  177. return error_show(1002,'未找到数据');
  178. }
  179. $data = GetUserInfo($this->post['token']);
  180. if((!empty($data) && $data['code']!=0) ||empty($data) ){
  181. return error_show($data['code'],$data['message']);
  182. }
  183. $userinfo = $data['data'];
  184. $bk_code=makeNo("BK");
  185. $info['bk_code']=$bk_code;
  186. $info['status']=0;
  187. $info['addtime']=date("Y-m-d H:i:s");
  188. $info['updatetime']=date("Y-m-d H:i:s");
  189. $info['apply_id']=$userinfo['id'];
  190. $info['apply_name']=$userinfo['nickname'];
  191. unset($info['id']);
  192. $in = Db::name("purchease")->insert($info,true);
  193. if($in>0){
  194. $order=["order_type"=>'BHD',"order_code"=>$bk_code,"order_id"=>$in,"order_status"=>0];
  195. ProcessOrder::AddProcess($this->post['token'],$order);
  196. $ste = ["order_code"=>$bk_code,"status"=>0,"action_remark"=>'',"action_type"=>"create"];
  197. ActionLog::logAdd($this->post['token'],$ste,"BHD",0,$info);
  198. return app_show(0,"新建成功",['bk_code'=>$bk_code]);
  199. }else{
  200. return error_show(1005,"新建失败");
  201. }
  202. }
  203. /**
  204. * @return \think\response\Json|void
  205. * @throws \think\db\exception\DataNotFoundException
  206. * @throws \think\db\exception\DbException
  207. * @throws \think\db\exception\ModelNotFoundException
  208. */
  209. public function info(){
  210. $id = isset($this->post['id']) ? intval($this->post['id']) : "";
  211. if($id==""){
  212. return error_show(1001,'id不能为空');
  213. }
  214. $info = Db::name("purchease")->where(["id"=>$id,"is_del"=>0])->find();
  215. if(empty($info)){
  216. return error_show(1002,'未找到数据');
  217. }
  218. $goon = Db::name('good')->alias("a")->leftJoin("good_type b","a.good_code=b.good_code")->where
  219. (['a.good_code'=>$info['good_code']])->field("cat_id,noble_metal")->find();
  220. if(empty($goon)){
  221. return error_show(1002,"未找到商品数据");
  222. }
  223. $int= isset($goon['cat_id']) && $goon['cat_id'] !=0 ? made($goon['cat_id']):[];
  224. $info['noble_metal']= isset($goon['noble_metal']) && $goon['noble_metal'] !='' ? $goon['noble_metal']:'';
  225. $info['noble_id']= isset($goon['noble_metal']) && $goon['noble_metal'] !='' ? array_search($goon['noble_metal'],\think\facade\Config::get("noble")):'';
  226. $info['wsm_name']="";
  227. if($info['wsm_code']!=""){
  228. $wsmcode = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code")
  229. ->where(["a.wsm_code"=>$info['wsm_code']])->field("a.name as wsm_name,b.name,b.code")->find();
  230. $info['wsm_name'] =isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name']:"";
  231. $info['wsm_supplier'] =isset($wsmcode['name']) ? $wsmcode['name']:"";
  232. $info['wsm_supplierNo'] =isset($wsmcode['code']) ? $wsmcode['code']:"";
  233. }
  234. $feed = Db::name("purchease_feedback")->where(['bkcode'=>$info['bk_code'],'is_del'=>0])->find();
  235. $info['feedback'] = [];
  236. if(!empty($feed)){
  237. $feed['wsm_name']="";
  238. if($feed['warehouse']!=""){
  239. $wsmcode = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code")
  240. ->where(["a.wsm_code"=>$feed['warehouse']])->field("a.name as wsm_name,b.name,b.code")->find();
  241. $feed['wsm_name'] =isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name']:"";
  242. $feed['wsm_supplier'] =isset($wsmcode['name']) ? $wsmcode['name']:"";
  243. $feed['wsm_supplierNo'] =isset($wsmcode['code']) ? $wsmcode['code']:"";
  244. }
  245. if($feed['supplier']!=""){
  246. $supplie = Db::name("supplier")->where(['code'=>$feed['supplier'],"is_del"=>0])->find();
  247. $feed['supplier_name'] =isset($supplie['name']) ? $supplie['name']:"";
  248. }
  249. $info['feedback'] = $feed;
  250. }
  251. $info['can']=$int;
  252. return app_show(0,"获取成功",$info);
  253. }
  254. public function edit(){
  255. $token = isset($this->post['token']) ? trim($this->post['token']) : "";
  256. if($token==""){
  257. return error_show(101,'token不能为空');
  258. }
  259. $id = isset($this->post['id']) ? intval($this->post['id']) : "";
  260. if($id==""){
  261. return error_show(1001,'id不能为空');
  262. }
  263. $info = Db::name("purchease")->where(["id"=>$id,"is_del"=>0])->find();
  264. if(empty($info)){
  265. return error_show(1002,'未找到数据');
  266. }
  267. $good_code = isset($this->post['good_code'])&&$this->post['good_code']!="" ? trim($this->post['good_code']):"";
  268. if($good_code==""){
  269. return error_show(1002,'参数good_code 不能为空');
  270. }
  271. $good = Db::name("good")->where(['good_code'=>$good_code,'is_del'=>0])->find();
  272. if(empty($good)){
  273. return error_show(1002,'未找到商品数据');
  274. }
  275. $good_type_code = isset($this->post['good_type_code'])&&$this->post['good_type_code']!="" ? trim($this->post['good_type_code'])
  276. :"";
  277. if($good_type_code!=''){
  278. $good_type= Db::name("good_type")->where(['good_code'=>$good_code,'is_del'=>0,'type_code'=>$good_type_code])
  279. ->find();
  280. if(empty($good_type)){
  281. return error_show(1002,'未找到商品属性数据');
  282. }
  283. }
  284. $good_num = isset($this->post['good_num'])&&$this->post['good_num']!=="" ? intval($this->post['good_num']) :"";
  285. if($good_num==''){
  286. return error_show(1002,'参数good_num 不能为空或零');
  287. }
  288. $wsm_code = isset($this->post['wsm_code'])&&$this->post['wsm_code']!="" ? trim($this->post['wsm_code']):"";
  289. if($wsm_code==""){
  290. return error_show(1002,'参数wsm_code 不能为空');
  291. }
  292. $wsminfo = Db::name("warehouse_info")->where(['wsm_code'=>$wsm_code,"is_del"=>0])->find();
  293. if(empty($wsminfo)){
  294. return error_show(1002,'未找到仓库数据');
  295. }
  296. $lastime = isset($this->post['lastime'])&&$this->post['lastime']!="" ? $this->post['lastime']:"";
  297. if($lastime==""){
  298. return error_show(1002,'参数lastime 不能为空');
  299. }
  300. $data = GetUserInfo($token);
  301. if((!empty($data) && $data['code']!=0) ||empty($data) ){
  302. return error_show($data['code'],$data['message']);
  303. }
  304. $userinfo = $data['data'];
  305. $up = [
  306. "good_code"=>$good_code,
  307. "good_name"=>$good['good_name'],
  308. "good_num"=>$good_num,
  309. "good_type_code"=>$good_type_code,
  310. "wsm_code"=>$wsm_code,
  311. "lasttime"=>$lastime,
  312. "updatetime"=>date("Y-m-d H:i:s"),
  313. "apply_id"=>$userinfo['id'],
  314. "apply_name"=>$userinfo['nickname']
  315. ];
  316. $in = Db::name("purchease")->where($info)->save($up);
  317. if($in){
  318. $order=["order_type"=>'BHD',"order_code"=>$info['bk_code'],"order_id"=>$info['id'],"order_status"=>$info['status']];
  319. ProcessOrder::AddProcess($this->post['token'],$order);
  320. $ste = ["order_code"=>$info['bk_code'],"status"=>$info['status'],"action_remark"=>'',"action_type"=>"edit"];
  321. ActionLog::logAdd($this->post['token'],$ste,"BHD",0,$up);
  322. return app_show(0,"更新成功",['bk_code'=>$info['bk_code']]);
  323. }else{
  324. return error_show(1005,"更新失败");
  325. }
  326. }
  327. public function delete(){
  328. $id = isset($this->post['id']) ? intval($this->post['id']) : "";
  329. if($id==""){
  330. return error_show(1001,'id不能为空');
  331. }
  332. $info = Db::name("purchease")->where(["id"=>$id,"is_del"=>0])->find();
  333. if(empty($info)){
  334. return error_show(1002,'未找到数据');
  335. }
  336. $info['is_del']=1;
  337. $info['updatetime']=date("Y-m-d H:i:s");
  338. $up = Db::name("purchease")->update($info);
  339. if($up){
  340. $order=["order_type"=>'BHD',"order_code"=>$info['bk_code'],"order_id"=>$info['id'],"order_status"=>$info['status']];
  341. ProcessOrder::workdel($order);
  342. $ste = ["order_code"=>$info['bk_code'],"status"=>$info['status'],"action_remark"=>'',"action_type"=>"delete"];
  343. ActionLog::logAdd($this->post['token'],$ste,"BHD",0,$info);
  344. }
  345. return $up ? app_show(0,"删除成功"):error_show(1005,"删除失败");
  346. }
  347. public function status(){
  348. $id = isset($this->post['id']) ? intval($this->post['id']) : "";
  349. if($id==""){
  350. return error_show(1001,'id不能为空');
  351. }
  352. $info = Db::name("purchease")->where(["id"=>$id,"is_del"=>0])->find();
  353. if(empty($info)){
  354. return error_show(1002,'未找到数据');
  355. }
  356. $status = isset($this->post['status'])&&$this->post['status']!=='' ? intval($this->post['status']) : "";
  357. if($status===""){
  358. return error_show(1001,'status不能为空');
  359. }
  360. $temp = $info['status'];
  361. $info['status']= $status;
  362. $info['updatetime']=date("Y-m-d H:i:s");
  363. $up = Db::name("purchease")->update($info);
  364. if($up){
  365. $order=["order_type"=>'BHD',"order_code"=>$info['bk_code'],"order_id"=>$info['id'],"order_status"=>$status];
  366. ProcessOrder::AddProcess($this->post['token'],$order);
  367. $ste = ["order_code"=>$info['bk_code'],"status"=> $temp,"action_remark"=>'',"action_type"=>"status"];
  368. ActionLog::logAdd($this->post['token'],$ste,"BHD",$status,$info);
  369. return app_show(0,"更新成功",['bk_code'=>$info['bk_code']]);
  370. }else{
  371. return error_show(1005,"更新失败");
  372. }
  373. }
  374. public function addFeed(){
  375. $token = isset($this->post['token']) ? trim($this->post['token']) : "";
  376. if($token==""){
  377. return error_show(101,'token不能为空');
  378. }
  379. $id = isset($this->post['id']) ? intval($this->post['id']) : "";
  380. if($id==""){
  381. return error_show(1001,'id不能为空');
  382. }
  383. $info = Db::name("purchease")->where(["id"=>$id,"is_del"=>0])->find();
  384. if(empty($info)){
  385. return error_show(1002,'未找到备库数据');
  386. }
  387. if($info['status']!=1){
  388. return error_show(1002,'备库数据状态有误');
  389. }
  390. $num = isset($this->post['num']) && $this->post['num']!=="" ? intval($this->post['num']):"";
  391. if($num==''){
  392. return error_show(1002,'参数num 不能为空或零');
  393. }
  394. $expecttime = isset($this->post['expecttime'])&&$this->post['expecttime']!=''?$this->post['expecttime'] :"";
  395. if($expecttime==''){
  396. return error_show(1002,'参数expecttime 不能为空');
  397. }
  398. $wsm_code = isset($this->post['wsm_code'])&&$this->post['wsm_code']!="" ? trim($this->post['wsm_code']):"";
  399. if($wsm_code==""){
  400. return error_show(1002,'参数wsm_code 不能为空');
  401. }
  402. $wsminfo = Db::name("warehouse_info")->where(['wsm_code'=>$wsm_code,"is_del"=>0])->find();
  403. if(empty($wsminfo)){
  404. return error_show(1002,'未找到仓库数据');
  405. }
  406. $supplierNo = isset($this->post['supplierNo'])&&$this->post['supplierNo']!="" ? trim($this->post['supplierNo']):"";
  407. if($supplierNo==""){
  408. return error_show(1002,'参数supplierNo 不能为空');
  409. }
  410. $supplie = Db::name("supplier")->where(['code'=>$supplierNo,"is_del"=>0])->find();
  411. if(empty($supplie)){
  412. return error_show(1002,'未找到供应商');
  413. }
  414. $good_price = isset($this->post['good_price'])&&$this->post['good_price']!=="" ? $this->post['good_price']:"";
  415. if($good_price===""){
  416. return error_show(1002,'参数good_price 不能为空');
  417. }
  418. $pakge_fee = isset($this->post['pakge_fee'])&&$this->post['pakge_fee']!=="" ? $this->post['pakge_fee']:0;
  419. $cert_fee = isset($this->post['cert_fee'])&&$this->post['cert_fee']!=="" ? $this->post['cert_fee']:0;
  420. $open_fee = isset($this->post['open_fee'])&&$this->post['open_fee']!=="" ? $this->post['open_fee']:0;
  421. $delivery_fee = isset($this->post['delivery_fee'])&&$this->post['delivery_fee']!=="" ? $this->post['delivery_fee']:0;
  422. $mark_fee = isset($this->post['mark_fee'])&&$this->post['mark_fee']!=="" ? $this->post['mark_fee']:0;
  423. $teach_fee = isset($this->post['teach_fee'])&&$this->post['teach_fee']!=="" ? $this->post['teach_fee']:0;
  424. $nake_fee = isset($this->post['nake_fee'])&&$this->post['nake_fee']!=="" ? $this->post['nake_fee']:0;
  425. $demo_fee = isset($this->post['demo_fee'])&&$this->post['demo_fee']!=="" ? $this->post['demo_fee']:0;
  426. $weight = isset($this->post['weight'])&&$this->post['weight']!=="" ? $this->post['weight']:0;
  427. $diff_weight =isset($this->post['diff_weight'])&&$this->post['diff_weight']!=="" ? $this->post['diff_weight']:0;
  428. $diff_price =isset($this->post['diff_price'])&&$this->post['diff_price']!=="" ? $this->post['diff_price']:0;
  429. $remark =isset($this->post['remark'])&&$this->post['remark']!=="" ? $this->post['remark']:'';
  430. $data = GetUserInfo($token);
  431. if((!empty($data) && $data['code']!=0) ||empty($data) ){
  432. return error_show($data['code'],$data['message']);
  433. }
  434. $userinfo = $data['data'];
  435. $data=[
  436. "bkcode"=>$info['bk_code'],
  437. "warehouse"=>$wsm_code,
  438. "num"=>$num,
  439. 'expecttime'=>$expecttime,
  440. 'supplier'=>isset($supplie) && $supplie['code']!=''? $supplie['code']:'',
  441. 'good_price'=>$good_price,
  442. 'pakge_fee'=>$pakge_fee,
  443. 'cert_fee'=>$cert_fee,
  444. 'open_fee'=>$open_fee,
  445. 'mark_fee'=>$mark_fee,
  446. 'teach_fee'=>$teach_fee,
  447. 'nake_fee'=>$nake_fee,
  448. 'demo_fee'=>$demo_fee,
  449. 'delivery_fee'=>$delivery_fee,
  450. 'weight'=>$weight,
  451. 'remark'=>$remark,
  452. 'diff_weight'=>$diff_weight,
  453. 'diff_price'=>$diff_price,
  454. 'purchaser'=>$userinfo['nickname'],
  455. 'purchaser_id'=>$userinfo['id'],
  456. "addtime"=>date("Y-m-d H:i:s"),
  457. "updatetime"=>date("Y-m-d H:i:s")
  458. ];
  459. Db::startTrans();
  460. try{
  461. $in = Db::name('purchease_feedback')->insert($data,true);
  462. if($in>0){
  463. $order=["order_type"=>'FKD',"order_code"=>$info['bk_code'],"order_id"=>$in, "order_status"=>0];
  464. ProcessOrder::AddProcess($this->post['token'],$order);
  465. $ste = ["order_code"=>$info['bk_code'],"status"=>0,"action_remark"=>'',"action_type"=>"create"];
  466. ActionLog::logAdd($this->post['token'],$ste,"FKD",0,$data);
  467. $temp=$info['status'];
  468. $info['status']=2;
  469. $info['addtime']=date("Y-m-d H:i:s");
  470. $ood=Db::name('purchease')->save($info);
  471. if($ood){
  472. $order=["order_type"=>'BHD',"order_code"=>$info['bk_code'],"order_id"=>$info['id'], "order_status"=>$info['status']];
  473. ProcessOrder::AddProcess($this->post['token'],$order);
  474. $ste = ["order_code"=>$info['bk_code'],"status"=>$temp,"action_remark"=>'',"action_type"=>"status"];
  475. ActionLog::logAdd($this->post['token'],$ste,"BHD",$info['status'],$info);
  476. Db::commit();
  477. return app_show(0,"新建成功");
  478. }
  479. }
  480. Db::rollback();
  481. return error_show(1005,"新建失败");
  482. }catch (\Exception $e){
  483. Db::rollback();
  484. return error_show(1005,"新建失败");
  485. }
  486. // return $in ? app_show(0,"新建成功"):error_show(1005,"新建失败");
  487. }
  488. public function delFeed(){
  489. $id = isset($this->post['id']) ? intval($this->post['id']) : "";
  490. if($id==""){
  491. return error_show(1001,'id不能为空');
  492. }
  493. $feed = Db::name("purchease_feedback")->where(['id'=>$id,'is_del'=>0])->find();
  494. if(empty($feed)){
  495. return error_show(1004,'未找到数据');
  496. }
  497. if($feed['status']==1){
  498. return error_show(1004,'反馈数据已采用无法删除');
  499. }
  500. $feed['is_del']= 1;
  501. $feed['updatetime']=date("Y-m-d H:i:s");
  502. $up = Db::name("purchease_feedback")->update($feed);
  503. if($up){
  504. $order=["order_type"=>'FKD',"order_code"=>$feed['bk_code'],"order_id"=>$feed['id'], "order_status"=>0];
  505. ProcessOrder::workdel($order);
  506. $ste = ["order_code"=>$feed['bk_code'],"status"=>$feed['status'],"action_remark"=>'',"action_type"=>"delete"];
  507. ActionLog::logAdd($this->post['token'],$ste,"FKD",$feed['status'],$feed);
  508. }
  509. return $up ? app_show(0,"删除成功"):error_show(1005,"删除失败");
  510. }
  511. public function infoFeed(){
  512. $id = isset($this->post['id']) ? intval($this->post['id']) : "";
  513. if($id==""){
  514. return error_show(1001,'id不能为空');
  515. }
  516. $info = Db::name("purchease")->where(["id"=>$id,"is_del"=>0])->find();
  517. if(empty($info)){
  518. return error_show(1002,'未找到备库数据');
  519. }
  520. $feed = Db::name("purchease_feedback")->where(['bkcode'=>$info['bk_code'],'is_del'=>0])->find();
  521. if(empty($feed)){
  522. return error_show(1004,'未找到反馈数据');
  523. }
  524. $feed['wsm_name']="";
  525. if($feed['warehouse']!=""){
  526. $wsmcode = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code")
  527. ->where(["a.wsm_code"=>$feed['warehouse']])->field("a.name as wsm_name,b.name,b.code")->find();
  528. $feed['wsm_name'] =isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name']:"";
  529. $feed['wsm_supplier'] =isset($wsmcode['name']) ? $wsmcode['name']:"";
  530. $feed['wsm_supplierNo'] =isset($wsmcode['code']) ? $wsmcode['code']:"";
  531. }
  532. if($feed['supplier']!=""){
  533. $supplie = Db::name("supplier")->where(['code'=>$feed['supplier'],"is_del"=>0])->find();
  534. $feed['supplier_name'] =isset($supplie['name']) ? $supplie['name']:"";
  535. }
  536. return app_show(0,"获取成功",$feed);
  537. }
  538. public function changeFeed(){
  539. $id = isset($this->post['id']) ? intval($this->post['id']) : "";
  540. if($id==""){
  541. return error_show(1001,'id不能为空');
  542. }
  543. $feed = Db::name("purchease")->where(['id'=>$id,'is_del'=>0])->find();
  544. if(empty($feed)){
  545. return error_show(1004,'未找到数据');
  546. }
  547. $status = isset($this->post['status'])&& $this->post['status']!=='' ? intval($this->post['status']) : "";
  548. if($status==""){
  549. return error_show(1001,'参数status 不能为空');
  550. }
  551. $remark = isset($this->post['remark'])&& $this->post['remark']!=='' ? trim($this->post['remark']) : "";
  552. Db::startTrans();
  553. try{
  554. $tem =$feed['status'];
  555. $feed['remark']= $remark;
  556. $feed['status']= $status;
  557. $feed['updatetime']=date("Y-m-d H:i:s");
  558. $up = Db::name("purchease")->update($feed);
  559. if($up){
  560. $order=["order_type"=>'BHD',"order_code"=>$feed['bk_code'],"order_id"=>$feed['id'],"order_status"=>$feed['status']];
  561. ProcessOrder::AddProcess($this->post['token'],$order);
  562. $ste = ["order_code"=>$feed['bk_code'],"status"=>$tem,"action_remark"=>'',"action_type"=>"edit"];
  563. ActionLog::logAdd($this->post['token'],$ste,"BHD",$feed['status'],$feed);
  564. if($status==3){
  565. // $ware = Db::name("warehouse_addr")->where(["wsm_code"=>$feed['warehouse'],"is_del"=>0])->find();
  566. $purse = Db::name("purchease_feedback")->where(['bkcode'=>$feed['bk_code'],"is_del"=>0])->find();
  567. if(empty($purse)){
  568. Db::rollback();
  569. return error_show(1001,'未找到备库反馈数据');
  570. }
  571. $pe = $purse['status'];
  572. $purse['status']=1;
  573. $purse['addtime']=date("Y-m-d H:i:s");
  574. $up = Db::name("purchease_feedback")->save($purse);
  575. if($up==false){
  576. Db::rollback();
  577. return error_show(1001,'备库反馈数据状态修改失败');
  578. }
  579. $order=["order_type"=>'FKD',"order_code"=>$feed['bk_code'],"order_id"=>$purse['id'],"order_status"=>$purse['status']];
  580. ProcessOrder::AddProcess($this->post['token'],$order);
  581. $ste = ["order_code"=>$feed['bk_code'],"status"=>$pe,"action_remark"=>'',"action_type"=>"status"];
  582. ActionLog::logAdd($this->post['token'],$ste,"FKD",$feed['status'],$purse);
  583. $supplier = Db::name("supplier")->where(["code"=>$purse['supplier']])->find();
  584. $inw = makeNo("CG");
  585. $data=[
  586. "bkcode"=>$purse['bkcode'],
  587. 'cgdNo'=>$inw,
  588. "wsm_code"=>$purse['warehouse'],
  589. "good_code"=>$feed['good_code'],
  590. "good_name"=>$feed['good_name'],
  591. "good_type_code"=>$feed['good_type_code'],
  592. "good_num"=>$feed['good_num'],
  593. "send_num"=>0,
  594. "wsend_num"=>$feed['good_num'],
  595. 'good_price'=>$purse['good_price'],
  596. "total_fee"=>$purse['good_price'],
  597. 'pakge_fee'=>$purse['pakge_fee'],
  598. 'cert_fee'=>$purse['cert_fee'],
  599. 'open_fee'=>$purse['open_fee'],
  600. 'mark_fee'=>$purse['mark_fee'],
  601. 'teach_fee'=>$purse['teach_fee'],
  602. 'nake_fee'=>$purse['nake_fee'],
  603. 'demo_fee'=>$purse['demo_fee'],
  604. 'delivery_fee'=>$purse['delivery_fee'],
  605. 'weight'=>$purse['weight'],
  606. 'diff_weight'=>$purse['diff_weight'],
  607. 'diff_fee'=>$purse['diff_price'],
  608. 'cgder_id'=>$purse['purchaser_id'],
  609. 'cgder'=>$purse['purchaser'],
  610. "remark"=>$purse['remark'],
  611. "status"=>0,
  612. 'supplierNo'=>$purse['supplier'],
  613. 'supplier_name'=>isset($supplier['name']) ? $supplier['name']:"",
  614. 'lasttime'=>$purse['expecttime'],
  615. "addtime"=>date("Y-m-d H:i:s"),
  616. "updatetime"=>date("Y-m-d H:i:s")
  617. ];
  618. $in= Db::name("purchease_order")->insert($data,true);
  619. if($in>0){
  620. $order=["order_type"=>'CGD',"order_code"=>$data['cgdNo'],"order_id"=>$in,"order_status"=>$data['status']];
  621. ProcessOrder::AddProcess($this->post['token'],$order);
  622. $ste = ["order_code"=>$inw,"status"=>$data['status'],"action_remark"=>'',"action_type"=>"create"];
  623. ActionLog::logAdd($this->post['token'],$ste,"CGD",$data['status'],$data);
  624. Db::commit();
  625. return app_show(0,"更新成功",['cgdNo'=>$inw]);
  626. }
  627. }else{
  628. if($status==4){
  629. $purse = Db::name("purchease_feedback")->where(['bkcode'=>$feed['bk_code'],"is_del"=>0])->find();
  630. if(empty($purse)){
  631. Db::rollback();
  632. return error_show(1001,'未找到备库反馈数据');
  633. }
  634. $pe=$purse['status'];
  635. $purse['status']=2;
  636. $purse['addtime']=date("Y-m-d H:i:s");
  637. $up = Db::name("purchease_feedback")->save($purse);
  638. if($up==false){
  639. Db::rollback();
  640. return error_show(1001,'备库反馈数据状态修改失败');
  641. }
  642. $order=["order_type"=>'FKD',"order_code"=>$feed['bk_code'],"order_id"=>$purse['id'],"order_status"=>$purse['status']];
  643. ProcessOrder::AddProcess($this->post['token'],$order);
  644. $ste = ["order_code"=>$feed['bk_code'],"status"=>$pe,"action_remark"=>'',"action_type"=>"status"];
  645. ActionLog::logAdd($this->post['token'],$ste,"FKD",$feed['status'],$purse);
  646. }
  647. Db::commit();
  648. return app_show(0,"更新成功");
  649. }
  650. }
  651. Db::rollback();
  652. return error_show(1004,"更新失败");
  653. }catch (\Exception $e){
  654. Db::rollback();
  655. return error_show(1005,$e->getMessage());
  656. }
  657. }
  658. }