Project.php 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664
  1. <?php
  2. namespace app\admin\controller;
  3. use think\App;
  4. use think\facade\Db;
  5. class Project extends Base
  6. {
  7. public function __construct(App $app)
  8. {
  9. parent::__construct($app);
  10. }
  11. public function create(){
  12. $name = isset($this->post['name'])&&$this->post['name']!=""? trim($this->post['name']):"";
  13. if($name==""){
  14. return error_show(1004,"参数name不能为空");
  15. }
  16. $platform = isset($this->post['platform'])&&$this->post['platform']!=""? trim($this->post['platform']):"";
  17. if($platform==""){
  18. return error_show(1004,"参数platform不能为空");
  19. }
  20. $khNo = isset($this->post['khNo'])&&$this->post['khNo']!=""?trim($this->post['khNo']):"";
  21. $companyNo = isset($this->post['companyNo'])&&$this->post['companyNo']!=""?trim($this->post['companyNo']):"";
  22. if($khNo==""){
  23. return error_show(1004,"参数khNo不能为空");
  24. }
  25. if($companyNo==""){
  26. return error_show(1004,"参数companyNo不能为空");
  27. }
  28. $use_desc = isset($this->post['use_desc'])&&$this->post['use_desc']!=""?trim($this->post['use_desc']):"";
  29. $budget_total = isset($this->post['budget_total'])&&$this->post['budget_total']!=""?floatval($this->post['budget_total']):"";
  30. $arrtime = isset($this->post['arrtime'])&&$this->post['arrtime']!=""?$this->post['arrtime']:"";
  31. $endtime = isset($this->post['endtime'])&&$this->post['endtime']!=""?$this->post['endtime']:"";
  32. if($use_desc==""){
  33. return error_show(1004,"参数use_desc不能为空");
  34. }
  35. if($budget_total==""){
  36. return error_show(1004,"参数budget_total不能为空");
  37. }
  38. if($arrtime==""){
  39. return error_show(1004,"参数arrtime不能为空");
  40. }
  41. if($endtime==""){
  42. return error_show(1004,"参数endtime不能为空");
  43. }
  44. $low_rate = isset($this->post['low_rate'])&&$this->post['low_rate']!=""?floatval($this->post['low_rate']):"0";
  45. // if($low_rate==""){
  46. // return error_show(1004,"参数low_rate不能为空");
  47. // }
  48. $ladder = isset($this->post['ladder'])&&!empty($this->post['ladder'])? $this->post['ladder']:"";
  49. if($ladder==""){
  50. return error_show(1004,"参数ladder不能为空");
  51. }
  52. $token = isset($this->post['token'])&& $this->post['token']!='' ? trim($this->post['token']):"";
  53. if($token==''){
  54. return error_show(1005,"参数token不能为空");
  55. }
  56. $user =GetUserInfo($token);
  57. if(empty($user)||$user['code']!=0){
  58. return error_show(1002,"用户数据不存在");
  59. }
  60. $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  61. $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  62. Db::startTrans();
  63. try {
  64. $projectNo = makeNo("PRO");
  65. $data=[
  66. "projectNo"=>$projectNo,
  67. "platform_id"=>$platform,
  68. "khNo"=>$khNo,
  69. "companyNo"=>$companyNo,
  70. "project_name"=>$name,
  71. "budget_total"=>$budget_total,
  72. "use_desc"=>$use_desc,
  73. "low_rate"=>$low_rate,
  74. "creater"=>$creater,
  75. "createrid"=>$createrid,
  76. "arrtime"=>$arrtime,
  77. "endtime"=>$endtime,
  78. "status"=>1,
  79. "is_del"=>0,
  80. "addtime"=>date("Y-m-d H:i:s"),
  81. "updatetime"=>date("Y-m-d H:i:s")
  82. ];
  83. $pro=Db::name("project")->insert($data);
  84. if($pro){
  85. if(!empty($ladder)){
  86. $la=[];
  87. foreach ($ladder as $value){
  88. $pgNo = makeNo("PRI");
  89. $temp=[];
  90. $temp['pgNo']=$pgNo;
  91. $temp['projectNo']=$projectNo;
  92. $temp['good_type']=$value['good_type'];
  93. $temp['good_name']=$value['good_name'];
  94. $temp['good_img']=$value['good_img'];
  95. $temp['cat_id']=$value['cat_id'];
  96. $temp['budget_price']=$value['budget_price'];
  97. $temp['num']=$value['num'];
  98. $temp['creater']=$creater;
  99. $temp['createrid']=$createrid;
  100. $temp['status']=1;
  101. $temp['is_del']=0;
  102. $temp['addtime']=date("Y-m-d H:i:s");
  103. $temp['updatetime']=date("Y-m-d H:i:s");
  104. $la[]=$temp;
  105. }
  106. $in = Db::name("project_info")->insertAll($la);
  107. if($in>0){
  108. Db::commit();
  109. return app_show(0,"项目新建成功",['projectNo'=>$projectNo]);
  110. }
  111. }
  112. }
  113. Db::rollback();
  114. return error_show(1004,"项目新建失败");
  115. }catch (\Exception $e){
  116. Db::rollback();
  117. return error_show(1004,$e->getMessage());
  118. }
  119. }
  120. public function addfeed(){
  121. $pgNo =isset($this->post['pgNo']) && $this->post['pgNo']!=""? trim($this->post['pgNo']):"";
  122. if($pgNo==""){
  123. return error_show(1004,"参数pgNo不能为空");
  124. }
  125. $projectinfo = Db::name("project_info")->where(["pgNo"=>$pgNo,"is_del"=>0])->find();
  126. if($projectinfo==false){
  127. return error_show(1004,"未找到项目阶梯信息");
  128. }
  129. $spuCode =isset($this->post['spuCode'])&&!empty($this->post['spuCode']) ?$this->post['spuCode']:"";
  130. if($spuCode==""){
  131. return error_show(1004,"参数spuCode不能为空");
  132. }
  133. $source =isset($this->post['source'])&&$this->post['source']!=="" ?intval($this->post['source']):"1";
  134. if($source==""){
  135. return error_show(1004,"参数source不能为空");
  136. }
  137. $good=[];
  138. if($source==1){
  139. $good=Db::name("good_platform")->alias("a")->leftJoin("good b","a.spuCode=b.spuCode")->where
  140. (["a.skuCode"=>$spuCode,"a.is_del"=>0])->select()->toArray();
  141. if(empty($good)){
  142. return error_show(1004,"未找到商品信息");
  143. }
  144. }else{
  145. $good=Db::name("consult_bids")->where(["spuCode"=>$spuCode,"is_del"=>0])->select()->toArray();
  146. if(empty($good)){
  147. return error_show(1004,"未找到商品信息");
  148. }
  149. }
  150. $token = isset($this->post['token'])&& $this->post['token']!='' ? trim($this->post['token']):"";
  151. if($token==''){
  152. return error_show(1005,"参数token不能为空");
  153. }
  154. $user =GetUserInfo($token);
  155. if(empty($user)||$user['code']!=0){
  156. return error_show($user['code'],"用户数据不存在");
  157. }
  158. $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  159. $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  160. Db::startTrans();
  161. try{
  162. $data=[];
  163. foreach ($good as $value){
  164. $temp=[];
  165. $temp['spuCode']=$value['spuCode'];
  166. $temp['skuCode']=isset($value['skuCode'])?$value['skuCode']:"";
  167. $temp['pgNo']=$projectinfo['pgNo'];
  168. $temp['projectNo']=$projectinfo['projectNo'];
  169. $temp['good_name']=$value['good_name'];
  170. $temp['good_type']=$projectinfo['good_type'];
  171. $temp['data_source']=$source;
  172. $temp['cat_id']=$value['cat_id'];
  173. $temp['budget_price']=$projectinfo['budget_price'];
  174. if($source==1){
  175. $ladd = Db::name("good_ladder")->where([["skuCode","=",$value['skuCode']],["min_num","<=",
  176. $projectinfo["num"]],["status","=",1],["is_del","=",0]])->order("min_num desc")->find();
  177. $sale_price = $ladd['sale_price'];
  178. }else{
  179. $sale_price =$value['sale_price'];
  180. }
  181. $temp['sale_price']=$sale_price;
  182. $temp['num']=$projectinfo['num'];
  183. $temp['status']=0;
  184. $temp['is_del']=0;
  185. $temp['creater']=$creater;
  186. $temp['createrid']=$createrid;
  187. $temp['addtime']=date("Y-m-d H:i:s");
  188. $temp['updatetime']=date("Y-m-d H:i:s");
  189. $data[]=$temp;
  190. }
  191. $nu = Db::name("project_feedback")->insertAll($data);
  192. if($nu>0){
  193. Db::commit();
  194. return app_show(0,"添加成功");
  195. }else{
  196. Db::rollback();
  197. return app_show(0,"添加成功");
  198. }
  199. }catch (\Exception $e){
  200. Db::rollback();
  201. return error_show(1004,$e->getMessage());
  202. }
  203. }
  204. public function list(){
  205. $page =isset($this->post['page'])&&$this->post['page']!=="" ? intval($this->post['page']):1;
  206. $size =isset($this->post['size'])&&$this->post['size']!==""? intval($this->post['size']):10;
  207. $where=[["is_del","=",0]];
  208. $khNo = isset($this->post['khNo']) &&$this->post['khNo']!==""? trim($this->post['khNo']):"";
  209. if($khNo!==""){
  210. $where[]=["khNo","=",$khNo];
  211. }
  212. $project_name = isset($this->post['project_name']) &&$this->post['project_name']!==""? trim($this->post['project_name']):"";
  213. if($project_name!==""){
  214. $where[]=["project_name","like","%$project_name%"];
  215. }
  216. $status = isset($this->post['status']) &&$this->post['status']!==""? intval($this->post['status']):"";
  217. if($status!==""){
  218. $where[]=["status","=",$status];
  219. }
  220. $start = isset($this->post['start'])&&$this->post['start']!=="" ? $this->post['start']:"";
  221. if($start!==''){
  222. $where[]=["addtime",">=",$start];
  223. }
  224. $end = isset($this->post['end'])&&$this->post['end']!=="" ? $this->post['end']:"";
  225. if($end!==''){
  226. $where[]=["addtime","<=",$end];
  227. }
  228. $low = isset($this->post['low'])&&$this->post['low']!=="" ? floatval($this->post['low']):"";
  229. if($low!==''){
  230. $where[]=["budget_total",">=",$low];
  231. }
  232. $up = isset($this->post['up'])&&$this->post['up']!=="" ? floatval($this->post['up']):"";
  233. if($up!==''){
  234. $where[]=["budget_total","<=",$up];
  235. }
  236. $companyNo = isset($this->post['companyNo'])&&$this->post['companyNo']!=="" ? trim($this->post['companyNo']):"";
  237. if($companyNo!==''){
  238. $where[]=["companyNo","like","%$companyNo%"];
  239. }
  240. $platform_id = isset($this->post['platform_id'])&&$this->post['platform_id']!=="" ? intval($this->post['platform_id']):"";
  241. if($platform_id!==''){
  242. $where[]=["platform_id","=",$platform_id];
  243. }
  244. $count = Db::name('project')->where($where)->count();
  245. $total = ceil($count / $size);
  246. $page = $page >= $total ? $total : $page;
  247. $list = Db::name('project')->where($where)->page($page,$size)->order("addtime desc")->select();
  248. $data=[];
  249. foreach ($list as $value){
  250. $info = Db::name("platform")->where(['id'=>$value['platform_id']])->find();
  251. $value['platform_name']=isset($info['platform_name'])?$info['platform_name']:"";
  252. $value['platform_code']=isset($info['platform_code'])?$info['platform_code']:"";
  253. $khinfo = Db::name("customer_info")->where(["companyNo"=>$value['khNo']])->find();
  254. $value['khName'] = isset($khinfo['companyName'])?$khinfo['companyName']:"";
  255. $company = Db::name("business")->where(["companyNo"=>$value['companyNo']])->find();
  256. $value['company'] = isset($company['company'])?$company['company']:"";
  257. $data[]=$value;
  258. }
  259. return app_show(0,"获取成功",['list'=>$data,'count'=>$count]);
  260. }
  261. public function feedlist(){
  262. $page =isset($this->post['page'])&&$this->post['page']!=="" ? intval($this->post['page']):1;
  263. $size =isset($this->post['size'])&&$this->post['size']!==""? intval($this->post['size']):10;
  264. $where=[["is_del","=",0]];
  265. $pgNo =isset($this->post['pgNo'])&&$this->post['pgNo']!==""?trim($this->post['pgNo']):"";
  266. if($pgNo!==""){
  267. $where[]=["pgNo","=",$pgNo];
  268. }
  269. $source =isset($this->post['source'])&&$this->post['source']!==""?intval($this->post['source']):"";
  270. if($source!==""){
  271. $where[]=["data_source","=",$source];
  272. }
  273. $cat_id =isset($this->post['cat_id'])&&$this->post['cat_id']!==""?intval($this->post['cat_id']):"";
  274. if($cat_id!==""){
  275. $where[]=["cat_id","=",$cat_id];
  276. }
  277. $count = Db::name('project_feedback')->where($where)->count();
  278. $total = ceil($count / $size);
  279. $page = $page >= $total ? $total : $page;
  280. $list = Db::name('project_feedback')->where($where)->page($page,$size)->order("addtime desc")->select();
  281. $data=[];
  282. foreach ($list as $value){
  283. $value['can']=isset($value['cat_id'])&&$value['cat_id']!=""?made($value['cat_id']):"";
  284. $data[]=$value;
  285. }
  286. return app_show(0,"获取成功",['list'=>$data,'count'=>$count]);
  287. }
  288. public function info(){
  289. $projectNo = isset($this->post['projectNo'])&&$this->post['projectNo']!==""?trim($this->post['projectNo']):"";
  290. if($projectNo==""){
  291. return error_show(1004,"参数projectNo不能为空");
  292. }
  293. $type = isset($this->post['type'])&&$this->post['type']!=="" ? intval($this->post['type']) :0;
  294. $info =Db::name("project")->where(["projectNo"=>$projectNo,"is_del"=>0])->find();
  295. if($info==false){
  296. return error_show(1004,"未找到项目信息");
  297. }
  298. $plat = Db::name("platform")->where(['id'=>$info['platform_id']])->find();
  299. $info['platform_name']=isset($plat['platform_name'])?$plat['platform_name']:"";
  300. $info['platform_code']=isset($plat['platform_code'])?$plat['platform_code']:"";
  301. $khinfo = Db::name("customer_info")->where(["companyNo"=>$info['khNo']])->find();
  302. $info['khName'] = isset($khinfo['companyName'])?$khinfo['companyName']:"";
  303. $company = Db::name("business")->where(["companyNo"=>$info['companyNo']])->find();
  304. $info['company'] = isset($company['company'])?$company['company']:"";
  305. $ladder = Db::name("project_info")->where(['projectNo'=>$projectNo,"is_del"=>0])->select()->toArray();
  306. $info['ladder']=[];
  307. if(!empty($ladder)){
  308. foreach ($ladder as $value){
  309. $value["cat_info"]=isset($value['cat_id']) &&$value['cat_id']!=""? made($value['cat_id'],[]):[];
  310. $condition = $type==0?['pgNo'=>$value['pgNo'],"is_del"=>0] : ['pgNo'=>$value['pgNo'],"is_del"=>0,"status"=>1];
  311. $feedback = Db::name("project_feedback")->where($condition)->select()->toArray();
  312. array_walk($feedback,function (&$v){
  313. $v["cat_info"]=isset($v['cat_id'])&&$v['cat_id']!=""? made($v['cat_id'],[]):[];
  314. });
  315. // $zx = Db::name("consult_info")->where(["pgNo"=>$value["pgNo"],"is_del"=>0,"bargain_status"=>0])
  316. // ->column("infoNo");
  317. // if(!empty($zx)){
  318. // $zxback = Db::name("consult_bids")->where(["infoNo"=>$zx,"is_del"=>0])->select()->toArray();
  319. // array_walk($zxback,function (&$v){
  320. // $v["cat_info"]=isset($v['cat_id'])? made($v['cat_id'],[]):[];
  321. // });
  322. // }else{
  323. // $zxback=[];
  324. // }
  325. $value['feedback']=$feedback;
  326. // $value['zxback']=$zxback;
  327. $info['ladder'][]=$value;
  328. }
  329. }
  330. return app_show(0,"获取成功",$info);
  331. }
  332. public function plan_create(){
  333. $projectNo = isset($this->post['projectNo'])&&$this->post['projectNo']!==""?trim($this->post['projectNo']):"";
  334. if($projectNo==""){
  335. return error_show(1004,"参数projectNo不能为空");
  336. }
  337. $info =Db::name("project")->where(["projectNo"=>$projectNo,"is_del"=>0])->find();
  338. if($info==false){
  339. return error_show(1004,"未找到项目信息");
  340. }
  341. $feedback =isset($this->post['feedback'])&&!empty($this->post['feedback'])?$this->post['feedback']:"";
  342. if($feedback==""){
  343. return error_show(1004,"参数feedback不能为空");
  344. }
  345. $feedinfo = Db::name("project_feedback")->where(['id'=>$feedback,"projectNo"=>$projectNo,"is_del"=>0])
  346. ->select()->toArray();
  347. if(empty($feedinfo)){
  348. return error_show(1004,"反馈数据未找到");
  349. }
  350. $token = isset($this->post['token'])&& $this->post['token']!='' ? trim($this->post['token']):"";
  351. if($token==''){
  352. return error_show(1005,"参数token不能为空");
  353. }
  354. $user =GetUserInfo($token);
  355. if(empty($user)||$user['code']!=0){
  356. return error_show(1002,"用户数据不存在");
  357. }
  358. $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  359. $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  360. Db::startTrans();
  361. try {
  362. $planNo=makeNo("PLA");
  363. $total=0;
  364. $dl=[];
  365. foreach ($feedinfo as $value){
  366. $temp=[];
  367. $temp['planNo']=$planNo;
  368. $temp['feedback_id']=$value['id'];
  369. $temp['status']=1;
  370. $temp['is_del']=0;
  371. $temp['addtime']=date("Y-m-d H:i:s");
  372. $temp['updatetime']=date("Y-m-d H:i:s");
  373. $total+=$value['num']*$value['sale_price'];
  374. $dl[]=$temp;
  375. }
  376. $inn=Db::name("project_plan_rela")->insertAll($dl);
  377. if($inn>0){
  378. $data=[
  379. "planNo"=>$planNo,
  380. "projectNo"=>$projectNo,
  381. "createrid"=>$createrid,
  382. "creater"=>$creater,
  383. "sale_total"=>round($total,2),
  384. "status"=>0,
  385. "is_del"=>0,
  386. "addtime"=>date("Y-m-d H:i:s"),
  387. "updatetime"=>date("Y-m-d H:i:s")
  388. ];
  389. $up =Db::name("project_plan")->insert($data);
  390. if($up){
  391. Db::commit();
  392. return app_show(0,"方案制作成功",["planNo"=>$planNo]);
  393. }
  394. }
  395. Db::rollback();
  396. return error_show(1004,"方案制作失败");
  397. }catch (\Exception $e){
  398. Db::rollback();
  399. return error_show(1004,$e->getMessage());
  400. }
  401. }
  402. public function planinfo(){
  403. $planNo = isset($this->post['planNo'])&& $this->post['planNo']!==""?trim($this->post["planNo"]):"";
  404. if($planNo==""){
  405. return error_show(1004,"参数planNo不能为空");
  406. }
  407. $plan = Db::name("project_plan")->where(["planNo"=>$planNo,"is_del"=>0])->find();
  408. if($plan==false){
  409. return error_show(1004,"未找到项目方案信息");
  410. }
  411. $plan['feedback']=[];
  412. $feedback =Db::name("project_plan_rela")->where(["planNo"=>$planNo,"is_del"=>0])->column("feedback_id");
  413. if(!empty($feedback)){
  414. $feedlist = Db::name("project_feedback")->where(["id"=>$feedback,"is_del"=>0])->select();
  415. if(!empty($feedlist)){
  416. foreach ($feedlist as $value){
  417. $value["cat_info"]=isset($value['cat_id'])&&$value['cat_id']!=""? made($value['cat_id'],[]):[];
  418. $plan['feedback'][]=$value;
  419. }
  420. }
  421. }
  422. return app_show(0,"获取成功",$plan);
  423. }
  424. public function project_plan(){
  425. $projectNo = isset($this->post['projectNo'])&&$this->post['projectNo']!==""?trim($this->post['projectNo']):"";
  426. if($projectNo==""){
  427. return error_show(1004,"参数projectNo不能为空");
  428. }
  429. $type = isset($this->post['type'])&&$this->post['type']!=="" ? intval($this->post['type']) :0;
  430. $info =Db::name("project")->where(["projectNo"=>$projectNo,"is_del"=>0])->find();
  431. if($info==false){
  432. return error_show(1004,"未找到项目信息");
  433. }
  434. $plat = Db::name("platform")->where(['id'=>$info['platform_id']])->find();
  435. $info['platform_name']=isset($plat['platform_name'])?$plat['platform_name']:"";
  436. $info['platform_code']=isset($plat['platform_code'])?$plat['platform_code']:"";
  437. $khinfo = Db::name("customer_info")->where(["companyNo"=>$plat['khNo']])->find();
  438. $info['khName'] = isset($khinfo['CompanyName'])?$khinfo['CompanyName']:"";
  439. $ladder = Db::name("project_plan")->where(['projectNo'=>$projectNo,"is_del"=>0])->select()->toArray();
  440. $info['plan']=[];
  441. if(!empty($ladder)){
  442. foreach ($ladder as $value){
  443. $value['feedback']=[];
  444. $feedback =Db::name("project_plan_rela")->where(["planNo"=>$value['planNo'],"is_del"=>0])->column("feedback_id");
  445. if(!empty($feedback)){
  446. $feedlist = Db::name("project_feedback")->where(["id"=>$feedback,"is_del"=>0])->select();
  447. if(!empty($feedlist)){
  448. foreach ($feedlist as $value){
  449. $value["cat_info"]=isset($value['cat_id'])&&$value['cat_id']!=""? made($value['cat_id'],[]):[];
  450. $plan['feedback'][]=$value;
  451. }
  452. }
  453. }
  454. $info['plan'][]=$value;
  455. }
  456. }
  457. return app_show(0,"获取成功",$info);
  458. }
  459. public function feedCheck(){
  460. $feedid = isset($this->post['feedid'])&&!empty($this->post['feedid']) ? $this->post['feedid'] :[];
  461. if(empty($feedid)){
  462. return error_show(1004,"参数feedid不能为空");
  463. }
  464. $selec = Db::name("project_feedback")->where(["id"=>$feedid,'is_del'=>0,"status"=>0])->select();
  465. if(empty($selec)){
  466. return error_show(1004,"反馈数据信息未找到");
  467. }
  468. $up = Db::name("project_feedback")->where(["id"=>$feedid,'is_del'=>0,"status"=>0])->save(["status"=>1,"updatetime"=>date("Y-m-d H:i:s")]);
  469. if($up){
  470. return app_show(0,"反馈数据选择成功");
  471. }else{
  472. return error_show(1004,"反馈数据选择失败");
  473. }
  474. }
  475. public function planCheck(){
  476. $planNos = isset($this->post['planNos'])&&!empty($this->post['planNos'])? $this->post['planNos'] :"";
  477. if($planNos==""){
  478. return error_show(1004,"参数planNos不能为空");
  479. }
  480. $status=isset($this->post['status'])&&$this->post['status']!=="" ? intval($this->post['status']):"";
  481. if($status==""){
  482. return error_show(1004,"参数status不能为空");
  483. }
  484. $selec = Db::name("project_plan")->where(["planNo"=>$planNos,'is_del'=>0,"status"=>0])->select();
  485. if(empty($selec)){
  486. return error_show(1004,"项目方案数据信息未找到");
  487. }
  488. $up = Db::name("project_plan")->where(["planNo"=>$planNos,'is_del'=>0,"status"=>0])->save(["status"=>1,"updatetime"=>date("Y-m-d H:i:s")]);
  489. if($up){
  490. return app_show(0,"方案数据修改成功");
  491. }else{
  492. return error_show(1004,"方案数据修改失败");
  493. }
  494. }
  495. public function changeRate(){
  496. $projectNo = isset($this->post['projectNo'])&&$this->post['projectNo']!==""?trim($this->post['projectNo']):"";
  497. if($projectNo==""){
  498. return error_show(1004,"参数projectNo不能为空");
  499. }
  500. $info =Db::name("project")->where(["projectNo"=>$projectNo,"is_del"=>0])->find();
  501. if($info==false){
  502. return error_show(1004,"未找到项目信息");
  503. }
  504. $rate = isset($this->post['rate'])&&$this->post['rate']!=="" ?floatval($this->post['rate']):"";
  505. if($rate===""){
  506. return error_show(1004,"参数rate不能为空");
  507. }
  508. $info['low_rate']=$rate;
  509. $info['updatetime']=date("Y-m-d H:i:s");
  510. $up =Db::name("project")->save($info);
  511. if($up){
  512. return app_show(0,"利润率修改成功");
  513. }else{
  514. return error_show(1004,"利润率修改失败");
  515. }
  516. }
  517. public function order(){
  518. $id = isset($this->post['id'])&& $this->post['id']!=="" ? intval($this->post['id']):"";
  519. if($id==""){
  520. return error_show(1004,"参数id不能为空");
  521. }
  522. $backinfo = Db::name("project_feedback")->where(["id"=>$id,"is_del"=>0])->find();
  523. if($backinfo==false){
  524. return error_show(1004,"未找到数据");
  525. }
  526. $prject = Db::name("project")->where(["projectNo"=>$backinfo['projectNo'],"is_del"=>0])->find();
  527. if($prject==false) {
  528. return error_show(1004, "未找到项目数据");
  529. }
  530. $send_type =isset($this->post['send_type'])&&$this->post['send_type']!=""? intval($this->post['send_type']):"";
  531. if($send_type==""){
  532. return error_show(1004,"参数send_type不能为空");
  533. }
  534. if($send_type==1){
  535. $va = isset($this->post['order_addr']) && $this->post['order_addr'] !== "" ? $this->post['order_addr'] : "";
  536. if ($va == "") {
  537. return error_show(1002, "参数order_addr不能为空");
  538. }
  539. }
  540. $plat = Db::name("platform")->where(["id"=>$prject['platform_id']])->find();
  541. $token = isset($this->post['token'])&& $this->post['token']!=="" ? trim($this->post['token']):"";
  542. if($token==""){
  543. return error_show(1004,"参数token不能为空");
  544. }
  545. $apply_id = GetUserInfo($token);
  546. if (empty($apply_id) || $apply_id['code'] != 0) {
  547. return error_show(1002, "申请人数据不存在");
  548. }
  549. $rm = isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  550. $ri = isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  551. $orderCode = makeNo("CX");
  552. Db::startTrans();
  553. try{
  554. $data = [
  555. "orderCode" => $orderCode,
  556. "good_code" => $backinfo['spuCode'],
  557. "customer_code" => $prject['khNo'],
  558. "good_name" => $backinfo['good_name'],
  559. "good_num" => $backinfo['num'],
  560. "order_type" =>3,
  561. "item_code"=>isset($plat['platform_code'])? $plat['platform_code']:"",
  562. "good_type"=>1,
  563. "apply_id" => $rm,
  564. "apply_name" => $ri,
  565. "origin_price" =>$backinfo['nake_price'],
  566. "sale_price" => $backinfo['sale_price'],
  567. "post_fee" => 0,
  568. "status" => 0,
  569. "supplierNo" =>$prject['companyNo'],
  570. "send_num" => 0,
  571. "zxNo"=>$backinfo['pgNo'],
  572. "wsend_num" => $backinfo['num'],
  573. "send_type" => $send_type,
  574. "send_status" => 1,
  575. "is_del" => 0,
  576. "addtime" => date("Y-m-d H:i:s"),
  577. "updatetime" => date("Y-m-d H:i:s"),
  578. 'total_price' => $backinfo['sale_price'] * $backinfo['num'],
  579. ];
  580. $datainfo = Db::name('sale')->insert($data, true);
  581. if($datainfo>0){
  582. if($send_type==1){
  583. foreach ($va as $value) {
  584. $temp = [];
  585. $addrs = [];
  586. if ($value['addr_code'] !== '' && is_array($value['addr_code'])) {
  587. $addrs['provice_code'] = $value['addr_code'][0];
  588. $addrs['city_code'] = $value['addr_code'][1];
  589. $addrs['area_code'] = $value['addr_code'][2];
  590. $addr = json_encode($addrs);
  591. } else {
  592. $addr = isset($value['addr_code']) ? $value['addr_code'] : '';
  593. }
  594. $temp['orderCode'] = $orderCode;
  595. $temp['contactor'] = $value['contactor'];
  596. $temp['mobile'] = $value['mobile'];
  597. $temp['addr'] = $value['addr'];
  598. $temp['addr_code'] = $addr;
  599. $temp['customer_code'] = $prject['khNo'];
  600. $temp['receipt_quantity'] = $value['receipt_quantity'];
  601. $temp['post_fee'] = 0;
  602. $temp['is_del'] = 0;
  603. $temp['addtime'] = date("Y-m-d H:i:s");
  604. $temp['updatetime'] = date("Y-m-d H:i:s");
  605. $temp['arrive_time'] = date("Y-m-d H:i:s");
  606. $vat[] = $temp;
  607. }
  608. $vmp = Db::name('order_addr')->insertAll($vat);
  609. if ($vmp==false) {
  610. Db::rollback();
  611. return error_show(1004, "销售订单创建失败");
  612. }
  613. }
  614. Db::commit();
  615. return error_show(0, "销售订单创建成功");
  616. }
  617. Db::rollback();
  618. return error_show(1004, "销售订单创建失败");
  619. }catch (\Exception $w){
  620. Db::rollback();
  621. return error_show(1004, $w->getMessage());
  622. }
  623. }
  624. public function feeddel(){
  625. $feedid = isset($this->post['id'])&&!empty($this->post['id']) ? $this->post['id'] :[];
  626. if(empty($feedid)){
  627. return error_show(1004,"参数feedid不能为空");
  628. }
  629. $selec = Db::name("project_feedback")->where(["id"=>$feedid,'is_del'=>0])->select();
  630. if(empty($selec)){
  631. return error_show(1004,"反馈数据信息未找到");
  632. }
  633. $up = Db::name("project_feedback")->where(["id"=>$feedid,'is_del'=>0])->save(["is_del"=>1,"updatetime"=>date("Y-m-d H:i:s")]);
  634. if($up){
  635. return app_show(0,"反馈数据删除成功");
  636. }else{
  637. return error_show(1004,"反馈数据删除失败");
  638. }
  639. }
  640. }