Project.php 56 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\model\ActionLog;
  4. use app\admin\model\ProcessOrder;
  5. use think\App;
  6. use think\facade\Db;
  7. //项目
  8. class Project extends Base
  9. {
  10. public function __construct(App $app)
  11. {
  12. parent::__construct($app);
  13. }
  14. public function create(){
  15. $name = isset($this->post['name'])&&$this->post['name']!=""? trim($this->post['name']):"";
  16. if($name==""){
  17. return error_show(1004,"参数name不能为空");
  18. }
  19. $platform = isset($this->post['platform'])&&$this->post['platform']!=""? trim($this->post['platform']):"";
  20. if($platform==""){
  21. return error_show(1004,"参数platform不能为空");
  22. }
  23. $khNo = isset($this->post['khNo'])&&$this->post['khNo']!=""?trim($this->post['khNo']):"";
  24. $companyNo = isset($this->post['companyNo'])&&$this->post['companyNo']!=""?trim($this->post['companyNo']):"";
  25. if($khNo==""){
  26. return error_show(1004,"参数khNo不能为空");
  27. }
  28. if($companyNo==""){
  29. return error_show(1004,"参数companyNo不能为空");
  30. }
  31. $use_desc = isset($this->post['use_desc'])&&$this->post['use_desc']!=""?trim($this->post['use_desc']):"";
  32. $budget_total = isset($this->post['budget_total'])&&$this->post['budget_total']!=""?floatval($this->post['budget_total']):"";
  33. $arrtime = isset($this->post['arrtime'])&&$this->post['arrtime']!=""?$this->post['arrtime']:"";
  34. $endtime = isset($this->post['endtime'])&&$this->post['endtime']!=""?$this->post['endtime']:"";
  35. if($use_desc==""){
  36. return error_show(1004,"参数use_desc不能为空");
  37. }
  38. if($budget_total==""){
  39. return error_show(1004,"参数budget_total不能为空");
  40. }
  41. if($arrtime==""){
  42. return error_show(1004,"参数arrtime不能为空");
  43. }
  44. if($endtime==""){
  45. return error_show(1004,"参数endtime不能为空");
  46. }
  47. $low_rate = isset($this->post['low_rate'])&&$this->post['low_rate']!=""?floatval($this->post['low_rate']):"0";
  48. // if($low_rate==""){
  49. // return error_show(1004,"参数low_rate不能为空");
  50. // }
  51. $ladder = isset($this->post['ladder'])&&!empty($this->post['ladder'])? $this->post['ladder']:"";
  52. if($ladder==""){
  53. return error_show(1004,"参数ladder不能为空");
  54. }
  55. $token = isset($this->post['token'])&& $this->post['token']!='' ? trim($this->post['token']):"";
  56. if($token==''){
  57. return error_show(105,"参数token不能为空");
  58. }
  59. $user =GetUserInfo($token);
  60. if(empty($user)||$user['code']!=0){
  61. return error_show(1002,"用户数据不存在");
  62. }
  63. $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  64. $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  65. Db::startTrans();
  66. try {
  67. $projectNo = makeNo("PR");
  68. $data=[
  69. "projectNo"=>$projectNo,
  70. "platform_id"=>$platform,
  71. "khNo"=>$khNo,
  72. "companyNo"=>$companyNo,
  73. "project_name"=>$name,
  74. "budget_total"=>$budget_total,
  75. "use_desc"=>$use_desc,
  76. "low_rate"=>$low_rate,
  77. "creater"=>$creater,
  78. "createrid"=>$createrid,
  79. "arrtime"=>$arrtime,
  80. "endtime"=>$endtime,
  81. "status"=>1,
  82. "is_del"=>0,
  83. "addtime"=>date("Y-m-d H:i:s"),
  84. "updatetime"=>date("Y-m-d H:i:s")
  85. ];
  86. $pro=Db::name("project")->insertGetId($data);
  87. if($pro>0){
  88. if(!empty($ladder)){
  89. $la=[];
  90. foreach ($ladder as $value){
  91. $pgNo = makeNo("PI");
  92. $temp=[];
  93. $temp['pgNo']=$pgNo;
  94. $temp['projectNo']=$projectNo;
  95. $temp['good_type']=$value['good_type'];
  96. $temp['good_name']=$value['good_name'];
  97. $temp['good_img']=$value['good_img'];
  98. $temp['cat_id']=$value['cat_id'];
  99. $temp['budget_price']=$value['budget_price'];
  100. $temp['num']=$value['num'];
  101. $temp['creater']=$creater;
  102. $temp['createrid']=$createrid;
  103. $temp['status']=1;
  104. $temp['is_del']=0;
  105. $temp['addtime']=date("Y-m-d H:i:s");
  106. $temp['updatetime']=date("Y-m-d H:i:s");
  107. $in = Db::name("project_info")->insert($temp,true);
  108. if($in>0){
  109. ActionLog::logAdd($this->post['token'], [
  110. "order_code" => $pgNo,//编码,这里是project的编码
  111. "status" => 1,//这里的status是之前的值
  112. "action_remark" => '',//备注
  113. "action_type" => "status"//新建create,编辑edit,更改状态status
  114. ], "PRI", 1, $temp);
  115. }else{
  116. Db::rollback();
  117. return error_show(1004,"项目新建失败");
  118. }
  119. }
  120. //修改状态,添加待办
  121. ActionLog::logAdd($this->post['token'], [
  122. "order_code" => $projectNo,//项目编码
  123. "status" =>0,//这里的status是之前的值
  124. "action_remark" => '',//备注
  125. "action_type" => "edit"//新建create,编辑edit更改状态status
  126. ], "PRT", 1, $this->post);
  127. $process = ["order_code" => $projectNo, "order_id" => Db::name("project")->getLastInsID(), "order_status" =>1, "order_type" => 'PRT',"before_status"=>1];//order_status==7修改毛利率
  128. ProcessOrder::AddProcess($this->post['token'], $process);
  129. //修改状态,添加待办,只记录动作
  130. ActionLog::logAdd($this->post['token'], [
  131. "order_code" => $projectNo,//编码,这里是project的编码
  132. "status" => 1,//这里的status是之前的值
  133. "action_remark" => '',//备注
  134. "action_type" => "create"//新建create,编辑edit,更改状态status
  135. ], "PRO", 1, $this->post);
  136. $process = ["order_code" => $projectNo, "order_id" => Db::name("project")->getLastInsID(), "order_status" =>1, "order_type" =>"PRO","before_status"=>1];
  137. ProcessOrder::AddProcess($this->post['token'], $process);
  138. //台账记录
  139. Db::name('standing_book')
  140. ->insert([
  141. 'standBookNo' => makeNo("IO"),
  142. 'projectNo' => $projectNo,
  143. 'addtime' => date('Y-m-d H:i:s'),
  144. 'updatetime' => date('Y-m-d H:i:s')
  145. ]);
  146. Db::commit();
  147. return app_show(0,"项目新建成功",['projectNo'=>$projectNo]);
  148. }
  149. }
  150. Db::rollback();
  151. return error_show(1004,"项目新建失败");
  152. }catch (\Exception $e){
  153. Db::rollback();
  154. return error_show(1004,$e->getMessage());
  155. }
  156. }
  157. public function addfeed(){
  158. $pgNo =isset($this->post['pgNo']) && $this->post['pgNo']!=""? trim($this->post['pgNo']):"";
  159. if($pgNo==""){
  160. return error_show(1004,"参数pgNo不能为空");
  161. }
  162. $projectinfo = Db::name("project_info")->where(["pgNo"=>$pgNo,"is_del"=>0])->find();
  163. if($projectinfo==false){
  164. return error_show(1004,"未找到项目阶梯信息");
  165. }
  166. $project = Db::name("project")->where(["projectNo"=>$projectinfo['projectNo'],"is_del"=>0])->find();
  167. if($project==false){
  168. return error_show(1004,"未找到项目阶梯信息");
  169. }
  170. $spuCode =isset($this->post['spuCode'])&&!empty($this->post['spuCode']) ?$this->post['spuCode']:"";
  171. if($spuCode==""){
  172. return error_show(1004,"参数spuCode不能为空");
  173. }
  174. $source =isset($this->post['source'])&&$this->post['source']!=="" ?intval($this->post['source']):"1";
  175. if($source==""){
  176. return error_show(1004,"参数source不能为空");
  177. }
  178. $good=[];
  179. if($source==1){
  180. $good=Db::name("good_platform")->alias("a")->leftJoin("good b","a.spuCode=b.spuCode")->where
  181. (["a.skuCode"=>$spuCode,"a.is_del"=>0])->select()->toArray();
  182. if(empty($good)){
  183. return error_show(1004,"未找到商品信息");
  184. }
  185. }else{
  186. $good=Db::name("consult_bids")->where(["spuCode"=>$spuCode,"is_del"=>0])->select()->toArray();
  187. if(empty($good)){
  188. return error_show(1004,"未找到商品信息");
  189. }
  190. }
  191. $token = isset($this->post['token'])&& $this->post['token']!='' ? trim($this->post['token']):"";
  192. if($token==''){
  193. return error_show(105,"参数token不能为空");
  194. }
  195. $user =GetUserInfo($token);
  196. if(empty($user)||$user['code']!=0){
  197. return error_show($user['code'],"用户数据不存在");
  198. }
  199. $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  200. $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  201. Db::startTrans();
  202. try{
  203. $data=[];
  204. foreach ($good as $value){
  205. $temp=[];
  206. $temp['spuCode']=$value['spuCode'];
  207. $temp['skuCode']=isset($value['skuCode'])?$value['skuCode']:"";
  208. $temp['pgNo']=$projectinfo['pgNo'];
  209. $temp['projectNo']=$projectinfo['projectNo'];
  210. $temp['good_name']=$value['good_name'];
  211. $temp['good_type']=$projectinfo['good_type'];
  212. $temp['data_source']=$source;
  213. $temp['cat_id']=$value['cat_id'];
  214. $temp['budget_price']=$projectinfo['budget_price'];
  215. if($source==1){
  216. $ladd = Db::name("good_ladder")->where([["skuCode","=",$value['skuCode']],["min_num","<=",
  217. $projectinfo["num"]],["status","=",1],["is_del","=",0]])->order("min_num desc")->find();
  218. $nake =Db::name("good_nake")->where(["spuCode"=>$value['spuCode'],"is_del"=>0])->where([["min_num","<=",$projectinfo['num']]])
  219. ->order("min_num desc")->find();
  220. $origin_price=isset($nake['nake_total'])?$nake['nake_total']:"0" ;
  221. $sale_price = $ladd['sale_price'];
  222. }else{
  223. $sale_price =$value['sale_price'];
  224. $origin_price =$value['sale_price'];
  225. }
  226. $temp['sale_price']=$sale_price;
  227. $temp['origin_price']=$origin_price;
  228. $temp['num']=$projectinfo['num'];
  229. $temp['status']=0;
  230. $temp['is_del']=0;
  231. $temp['creater']=$creater;
  232. $temp['createrid']=$createrid;
  233. $temp['addtime']=date("Y-m-d H:i:s");
  234. $temp['updatetime']=date("Y-m-d H:i:s");
  235. $data[]=$temp;
  236. }
  237. $nu = Db::name("project_feedback")->insertAll($data);
  238. if($nu>0){
  239. $old_projectinfo_status = $projectinfo['status'];
  240. $projectinfo['status']=2;
  241. $projectinfo['updatetime']=date("Y-m-d H:i:s");
  242. $up = Db::name("project_info")->save($projectinfo);
  243. if($up){
  244. //修改状态,添加待办,只记录动作
  245. ActionLog::logAdd($this->post['token'], [
  246. "order_code" => $pgNo,//编码,这里是project的编码
  247. "status" => $old_projectinfo_status,//这里的status是之前的值
  248. "action_remark" => '',//备注
  249. "action_type" => "status"//新建create,编辑edit,更改状态status
  250. ], "PRI", 2, $projectinfo);
  251. $count = Db::name("project_info")->where(["projectNo"=>$projectinfo['projectNo'],"status"=>1])
  252. ->count();
  253. if($count==0){
  254. $proc =Db::name("project")->where(["projectNo"=>$projectinfo['projectNo'],"status"=>1])->save
  255. (["status"=>2,"updatetime"=>date("Y-m-d H:i:s")]);
  256. if($proc){
  257. //修改状态,添加待办
  258. ActionLog::logAdd($this->post['token'], [
  259. "order_code"=>$projectinfo['projectNo'],//项目编码
  260. "status"=>1,//这里的status是之前的值
  261. "action_remark"=>'',//备注
  262. "action_type"=>"status"//新建create,编辑edit,更改状态status
  263. ],"PRO",2,["status"=>2,"updatetime"=>date("Y-m-d H:i:s")]);
  264. ProcessOrder::AddProcess($this->post['token'],[
  265. "order_type"=>'PRO',
  266. "order_code"=>$projectinfo['projectNo'],
  267. "order_id"=>$project['id'],//这里更新是根据编码更新的,没有主键id
  268. "order_status"=>2,"before_status"=>1
  269. ]);
  270. Db::commit();
  271. return app_show(0,"添加成功");
  272. }
  273. }
  274. }
  275. Db::commit();
  276. return app_show(0,"添加成功");
  277. }else{
  278. Db::rollback();
  279. return error_show(1004,"添加失败");
  280. }
  281. }catch (\Exception $e){
  282. Db::rollback();
  283. return error_show(1004,$e->getMessage());
  284. }
  285. }
  286. public function list(){
  287. $page =isset($this->post['page'])&&$this->post['page']!=="" ? intval($this->post['page']):1;
  288. $size =isset($this->post['size'])&&$this->post['size']!==""? intval($this->post['size']):10;
  289. $where=[["p.is_del","=",0]];
  290. $khNo = isset($this->post['khNo']) &&$this->post['khNo']!==""? trim($this->post['khNo']):"";
  291. if($khNo!==""){
  292. $where[]=["p.khNo","=",$khNo];
  293. }
  294. $project_name = isset($this->post['project_name']) &&$this->post['project_name']!==""? trim($this->post['project_name']):"";
  295. if($project_name!==""){
  296. $where[]=["p.project_name","like","%$project_name%"];
  297. }
  298. $status = isset($this->post['status']) &&$this->post['status']!==""? intval($this->post['status']):"";
  299. if($status!==""){
  300. $where[]=["p.status","=",$status];
  301. }
  302. $start = isset($this->post['start'])&&$this->post['start']!=="" ? $this->post['start']:"";
  303. if($start!==''){
  304. $where[]=["p.addtime",">=",$start];
  305. }
  306. $end = isset($this->post['end'])&&$this->post['end']!=="" ? $this->post['end']:"";
  307. if($end!==''){
  308. $where[]=["p.addtime","<=",$end];
  309. }
  310. $low = isset($this->post['low'])&&$this->post['low']!=="" ? floatval($this->post['low']):"";
  311. if($low!==''){
  312. $where[]=["p.budget_total",">=",$low];
  313. }
  314. $up = isset($this->post['up'])&&$this->post['up']!=="" ? floatval($this->post['up']):"";
  315. if($up!==''){
  316. $where[]=["p.budget_total","<=",$up];
  317. }
  318. $companyNo = isset($this->post['companyNo'])&&$this->post['companyNo']!=="" ? trim($this->post['companyNo']):"";
  319. if($companyNo!==''){
  320. $where[]=["p.companyNo","like","%$companyNo%"];
  321. }
  322. $platform_id = isset($this->post['platform_id'])&&$this->post['platform_id']!=="" ? intval($this->post['platform_id']):"";
  323. if($platform_id!==''){
  324. $where[]=["p.platform_id","=",$platform_id];
  325. }
  326. $company_name = isset($this->post['company_name'])&&$this->post['company_name']!=="" ? trim($this->post['company_name']):"";
  327. if($company_name!=='') $where[] = ["p.createrid", 'in', get_company_item_user_by_name($company_name)];
  328. $role=$this->checkRole();
  329. if(!empty($role['write'])){
  330. $where[]=["p.createrid","in",$role['write']];
  331. }
  332. // if(!empty($role['platform'])){
  333. // $where[]=["p.platform_id","in",$role['platform']];
  334. // }
  335. $count = Db::name('project') ->alias('p')->where($where)->count();
  336. $total = ceil($count / $size);
  337. $page = $page >= $total ? $total : $page;
  338. $list = Db::name('project')
  339. ->alias('p')
  340. ->field('p.*,u.itemid')
  341. ->leftJoin('depart_user u', 'u.uid=p.createrid AND u.is_del=0')
  342. ->where($where)
  343. ->page($page,$size)
  344. ->order("p.addtime desc")
  345. ->cursor();
  346. $data=[];
  347. foreach ($list as $value){
  348. $info = Db::name("platform")->where(['id'=>$value['platform_id']])->find();
  349. $value['platform_name']=isset($info['platform_name'])?$info['platform_name']:"";
  350. $value['platform_code']=isset($info['platform_code'])?$info['platform_code']:"";
  351. $khinfo = Db::name("customer_info")->where(["companyNo"=>$value['khNo']])->find();
  352. $value['khName'] = isset($khinfo['companyName'])?$khinfo['companyName']:"";
  353. $company = Db::name("business")->where(["companyNo"=>$value['companyNo']])->find();
  354. $value['company'] = isset($company['company'])?$company['company']:"";
  355. $value['company_name'] = implode('/', array_column(GetPart($value['itemid']), 'name'));
  356. $data[]=$value;
  357. }
  358. return app_show(0,"获取成功",['list'=>$data,'count'=>$count]);
  359. }
  360. public function feedlist(){
  361. $page =isset($this->post['page'])&&$this->post['page']!=="" ? intval($this->post['page']):1;
  362. $size =isset($this->post['size'])&&$this->post['size']!==""? intval($this->post['size']):10;
  363. $where=[["is_del","=",0]];
  364. $pgNo =isset($this->post['pgNo'])&&$this->post['pgNo']!==""?trim($this->post['pgNo']):"";
  365. if($pgNo!==""){
  366. $where[]=["pgNo","=",$pgNo];
  367. }
  368. $projectNo =isset($this->post['projectNo'])&&$this->post['projectNo']!==""?trim($this->post['projectNo']):"";
  369. if($projectNo!==""){
  370. $where[]=["projectNo","=",$projectNo];
  371. }
  372. $source =isset($this->post['source'])&&$this->post['source']!==""?intval($this->post['source']):"";
  373. if($source!==""){
  374. $where[]=["data_source","=",$source];
  375. }
  376. $cat_id =isset($this->post['cat_id'])&&$this->post['cat_id']!==""?intval($this->post['cat_id']):"";
  377. if($cat_id!==""){
  378. $where[]=["cat_id","=",$cat_id];
  379. }
  380. $status =isset($this->post['status'])&&$this->post['status']!==""?intval($this->post['status']):"";
  381. if($status!==""){
  382. $where[]=["status","=",$status];
  383. }
  384. $count = Db::name('project_feedback')->where($where)->count();
  385. $total = ceil($count / $size);
  386. $page = $page >= $total ? $total : $page;
  387. $list = Db::name('project_feedback')->where($where)->page($page,$size)->order("addtime desc")->select();
  388. $data=[];
  389. foreach ($list as $value){
  390. $value['can']=isset($value['cat_id'])&&$value['cat_id']!=""?made($value['cat_id']):"";
  391. if($value['data_source']==1){
  392. $good=Db::name("good_platform")->alias("a")->leftJoin("good b","a.spuCode=b.spuCode")->where
  393. (["a.skuCode"=>$value['skuCode'],"a.is_del"=>0])->find();
  394. $nake = Db::name("good_nake")->where([["spuCode","=",$value['spuCode']],["min_num","<=",
  395. $value["num"]],["is_del","=",0]])->order("min_num desc")->find();
  396. $good['unit_id'] = isset($good['good_unit'])?$good['good_unit']:"";
  397. $good['cost_desc'] = isset($good['craft_desc'])?$good['craft_desc']:"";
  398. $good['pakge_fee'] = isset($nake['package_fee'])?$nake['package_fee']:"0";
  399. $good['mark_fee'] = isset($nake['mark_fee'])?$nake['mark_fee']:"0";
  400. $good['other_fee'] = isset($nake['other_fee'])?$nake['other_fee']:"0";
  401. $good['cert_fee'] = isset($nake['cert_fee'])?$nake['cert_fee']:"0";
  402. $good['delivery_fee'] = isset($nake['delivery_fee'])?$nake['delivery_fee']:"0";
  403. $good['nake_fee'] = isset($nake['nake_fee'])?$nake['nake_fee']:"0";
  404. $good['metal_id'] = isset($good['noble_metal'])?$good['noble_metal']:"0";
  405. $spec = Db::name("good_spec")->where(["spuCode"=>$good['spuCode'],"is_del"=>0])->select()->toArray();
  406. $good['specinfo']=[];
  407. if(!empty($spec)){
  408. foreach ($spec as $vae){
  409. $specs=Db::name("specs")->where(["id"=>$vae['spec_id']])->find();
  410. $spec_value = Db::name("spec_value")->where(["id"=>$vae["spec_value_id"]])->find();
  411. $temp = ["specid"=>$vae['spec_id'],"spec_name"=>$specs['spec_name'],"spec_value_id"=>$vae['spec_value_id'],"spec_value_name"=>$spec_value["spec_value"]];
  412. $good['specinfo'][]=$temp;
  413. }
  414. }
  415. $nake =Db::name("good_nake")->where(["spuCode"=>$good['spuCode'],"is_del"=>0])->where([["min_num","<=",$value['num']]])
  416. ->order("min_num desc")->find();
  417. $good['origin_price']=$nake['nake_total'];
  418. $good['work_day']=$good['lead_time'];
  419. $good_img = $good['good_thumb_img'];
  420. }else{
  421. $good=Db::name("consult_bids")->where(["spuCode"=>$value['spuCode'],"is_del"=>0])->find();
  422. $good['specinfo'] = isset($good['specinfo'])&&$good['specinfo']!=""?json_decode($good['specinfo'],
  423. true):"";
  424. $catinfo = Db::name("cat")->where(["id"=>$good['cat_id']])->find();
  425. $budget = isset($catinfo['order_rate']) ? $catinfo['order_rate']:100;
  426. $good_img = $good['good_img'];
  427. }
  428. $nobel =\think\facade\Config::get("noble");
  429. $value['good_name'] = isset($good['good_name'])?$good['good_name']:"";
  430. // $value['good_img'] = isset($good['good_img'])?$good['good_img']:"";
  431. $value['brand_id'] = isset($good['brand_id'])?$good['brand_id']:"";
  432. $brand = Db::name("brand")->where(['id'=>$value["brand_id"]])->find();
  433. $value['brand_name'] =isset($brand['brand_name']) ? $brand['brand_name']:"";
  434. $value['specinfo'] = isset($good['specinfo'])&&$good['specinfo']!=""?$good['specinfo']:[];
  435. $value['unit_id'] = isset($good['unit_id'])?$good['unit_id']:"";
  436. $unit = Db::name("unit")->where(['id'=>$value["unit_id"]])->find();
  437. $value["unit_name"]=isset($unit['unit'])?$unit['unit']:"";
  438. $value['cost_desc'] = isset($good['cost_desc'])?$good['cost_desc']:"";
  439. $value['work_day'] = isset($good['work_day'])?$good['work_day']:"";
  440. $value['delivery_day'] = isset($good['delivery_day'])?$good['delivery_day']:"";
  441. $value['expire_day'] = isset($good['expire_day'])?$good['expire_day']:"0";
  442. $value['good_img'] = $good_img;
  443. $value['expire_day'] = isset($good['expire_day'])?$good['expire_day']:"";
  444. $value['origin_place'] = isset($good['origin_place'])?$good['origin_place']:"";
  445. $value['supplierNo'] = isset($good['supplierNo'])?$good['supplierNo']:"";
  446. $value['pay_way'] = isset($good['pay_way'])?$good['pay_way']:"";
  447. $value['tax'] = isset($good['tax'])?$good['tax']:"";
  448. $value['send_way'] = isset($good['send_way'])?$good['send_way']:"";
  449. $value['metal_id'] = isset($good['metal_id'])?$good['metal_id']:"";
  450. $value['metal_name'] = isset($nobel[$good['metal_id']])?$nobel[$good['metal_id']]:"";
  451. $value['is_gold_price'] = isset($good['is_gold_price'])?$good['is_gold_price']:"0";
  452. $value['config'] = isset($good['config'])?$good['config']:"";
  453. $value['other_config'] = isset($good['other_config'])?$good['other_config']:"";
  454. $value['weight'] = isset($good['weight'])?$good['weight']:"";
  455. $value['is_diff'] = isset($good['is_diff'])?$good['is_diff']:"0";
  456. $value['demo_fee'] = isset($good['demo_fee'])?$good['demo_fee']:"0";
  457. $value['deivery_fee'] = isset($good['deivery_fee'])?$good['deivery_fee']:"0";
  458. $value['open_fee'] = isset($good['open_fee'])?$good['open_fee']:"0";
  459. $value['pakge_fee'] = isset($good['pakge_fee'])?$good['pakge_fee']:"0";
  460. $value['nake_fee'] = isset($good['nake_fee'])?$good['nake_fee']:"0";
  461. $value['mark_fee'] = isset($good['mark_fee'])?$good['mark_fee']:"0";
  462. $value['cert_fee'] = isset($good['cert_fee'])?$good['cert_fee']:"0";
  463. $value['cost_fee'] = isset($good['cost_fee'])?$good['cost_fee']:"0";
  464. $value['rate'] =round(($value['sale_price'] - $value['origin_price'])/$value['sale_price'] * 100,2);
  465. $value['supply_area'] = isset($good['supply_area'])?$good['supply_area']:"";
  466. $data[]=$value;
  467. }
  468. return app_show(0,"获取成功",['list'=>$data,'count'=>$count]);
  469. }
  470. public function info(){
  471. $projectNo = isset($this->post['projectNo'])&&$this->post['projectNo']!==""?trim($this->post['projectNo']):"";
  472. if($projectNo==""){
  473. return error_show(1004,"参数projectNo不能为空");
  474. }
  475. $type = isset($this->post['type'])&&$this->post['type']!=="" ? intval($this->post['type']) :0;
  476. $info =Db::name("project")->where(["projectNo"=>$projectNo,"is_del"=>0])->find();
  477. if($info==false){
  478. return error_show(1004,"未找到项目信息");
  479. }
  480. $plat = Db::name("platform")->where(['id'=>$info['platform_id']])->find();
  481. $info['platform_name']=isset($plat['platform_name'])?$plat['platform_name']:"";
  482. $info['platform_code']=isset($plat['platform_code'])?$plat['platform_code']:"";
  483. $khinfo = Db::name("customer_info")->where(["companyNo"=>$info['khNo']])->find();
  484. $info['khName'] = isset($khinfo['companyName'])?$khinfo['companyName']:"";
  485. $company = Db::name("business")->where(["companyNo"=>$info['companyNo']])->find();
  486. $info['company'] = isset($company['company'])?$company['company']:"";
  487. $ladder = Db::name("project_info")->where(['projectNo'=>$projectNo,"is_del"=>0])->select()->toArray();
  488. $info['ladder']=[];
  489. if(!empty($ladder)){
  490. foreach ($ladder as $value){
  491. $value["cat_info"]=isset($value['cat_id']) &&$value['cat_id']!=""? made($value['cat_id'],[]):[];
  492. $condition = $type==0?['pgNo'=>$value['pgNo'],"is_del"=>0] : ['pgNo'=>$value['pgNo'],"is_del"=>0,"status"=>1];
  493. $feedback = Db::name("project_feedback")->where($condition)->select()->toArray();
  494. array_walk($feedback,function (&$v){
  495. $v["cat_info"]=isset($v['cat_id'])&&$v['cat_id']!=""? made($v['cat_id'],[]):[];
  496. });
  497. // $zx = Db::name("consult_info")->where(["pgNo"=>$value["pgNo"],"is_del"=>0,"bargain_status"=>0])
  498. // ->column("infoNo");
  499. // if(!empty($zx)){
  500. // $zxback = Db::name("consult_bids")->where(["infoNo"=>$zx,"is_del"=>0])->select()->toArray();
  501. // array_walk($zxback,function (&$v){
  502. // $v["cat_info"]=isset($v['cat_id'])? made($v['cat_id'],[]):[];
  503. // });
  504. // }else{
  505. // $zxback=[];
  506. // }
  507. $value['feedback']=$feedback;
  508. // $value['zxback']=$zxback;
  509. $info['ladder'][]=$value;
  510. }
  511. }
  512. return app_show(0,"获取成功",$info);
  513. }
  514. public function plan_create(){
  515. $projectNo = isset($this->post['projectNo'])&&$this->post['projectNo']!==""?trim($this->post['projectNo']):"";
  516. if($projectNo==""){
  517. return error_show(1004,"参数projectNo不能为空");
  518. }
  519. $info =Db::name("project")->where(["projectNo"=>$projectNo,"is_del"=>0])->find();
  520. if($info==false){
  521. return error_show(1004,"未找到项目信息");
  522. }
  523. if($info['status']!=3 && $info['status']!=4){
  524. return error_show(1004,"项目状态有误");
  525. }
  526. $feedback =isset($this->post['feedback'])&&!empty($this->post['feedback'])?$this->post['feedback']:"";
  527. if($feedback==""){
  528. return error_show(1004,"参数feedback不能为空");
  529. }
  530. $feedid =array_column($feedback,"feedid");
  531. $feedinfo = Db::name("project_feedback")->where(['id'=>$feedid,"projectNo"=>$projectNo,"is_del"=>0])
  532. ->select()->toArray();
  533. if(empty($feedinfo)){
  534. return error_show(1004,"反馈数据未找到");
  535. }
  536. $token = isset($this->post['token'])&& $this->post['token']!='' ? trim($this->post['token']):"";
  537. if($token==''){
  538. return error_show(105,"参数token不能为空");
  539. }
  540. $user =GetUserInfo($token);
  541. if(empty($user)||$user['code']!=0){
  542. return error_show(1002,"用户数据不存在");
  543. }
  544. $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  545. $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  546. Db::startTrans();
  547. try {
  548. $planNo=makeNo("PL");
  549. $total=0;
  550. $num_t=0;
  551. $origia=0;
  552. $dl=[];
  553. foreach ($feedinfo as $value){
  554. $key =array_search($value['id'],$feedid);
  555. $price = $feedback[$key];
  556. if($price['sale_price']<$value['origin_price']){
  557. Db::rollback();
  558. return error_show(1004,"反馈商品价格不能小于初始金额");
  559. }
  560. if($price['good_num']<$value['num']){
  561. Db::rollback();
  562. return error_show(1004,"商品数量不能小于初始数量");
  563. }
  564. if($value['data_source']==2){
  565. $bids =Db::name("consult_info")->where(["pgNo"=>$value['pgNo'],"is_del"=>0])->find();
  566. if($bids==false){
  567. Db::rollback();
  568. return error_show(1004,"未找到反馈商品咨询单");
  569. }
  570. $old_bids_status = $bids["status"];
  571. $bids["status"]=3;
  572. $bids["updatetime"]=date("Y-m-d H:i:s");
  573. $bd=Db::name("consult_info")->save($bids);
  574. if($bd==false){
  575. Db::rollback();
  576. return error_show(1004,"反馈商品咨询单更新失败");
  577. }else{
  578. //修改状态,添加待办
  579. ActionLog::logAdd($this->post['token'], [
  580. "order_code" => $bids['infoNo'],//咨询单详情编号
  581. "status" => $old_bids_status,//这里的status是之前的值
  582. "action_remark" => '',//备注
  583. "action_type" => "status"//新建create,编辑edit,更改状态status
  584. ], "ZXD", 3, $bids);
  585. }
  586. }
  587. // $value['sale_price'] = $price['sale_price'];
  588. // $value['updatetime'] = date("Y-m-d H:i:s");
  589. // $cre=Db::name("project_feedback")->save($value);
  590. // if($cre==false){
  591. // Db::rollback();
  592. // return error_show(1004,"反馈商品价格修改失败");
  593. // }
  594. $temp=[];
  595. $temp['planNo']=$planNo;
  596. $temp['feedback_id']=$value['id'];
  597. $temp['sale_price']=$price["sale_price"];
  598. $temp['sale_num']=$price["good_num"];
  599. $temp['status']=1;
  600. $temp['is_del']=0;
  601. $temp['addtime']=date("Y-m-d H:i:s");
  602. $temp['updatetime']=date("Y-m-d H:i:s");
  603. $total+=$price['good_num']*$price["sale_price"];
  604. $origia+=$price['good_num']*$value["origin_price"];
  605. $num_t+=$price['good_num'];
  606. $dl[]=$temp;
  607. }
  608. $inn=Db::name("project_plan_rela")->insertAll($dl);
  609. if($inn>0){
  610. $data=[
  611. "planNo"=>$planNo,
  612. "projectNo"=>$projectNo,
  613. "createrid"=>$createrid,
  614. "creater"=>$creater,
  615. "sale_total"=>round($total,2),
  616. "total_num"=>$num_t,
  617. "origin_total"=>round($origia,2),
  618. "sale_rate"=>round(($total-$origia)/$total,4)*100,
  619. "status"=>0,
  620. "is_del"=>0,
  621. "addtime"=>date("Y-m-d H:i:s"),
  622. "updatetime"=>date("Y-m-d H:i:s")
  623. ];
  624. $up =Db::name("project_plan")->insert($data);
  625. if($up){
  626. $old_project_status = $info['status'];
  627. $info['status']=4;
  628. $info['updatetime']=date("Y-m-d H:i:s");
  629. $cr =Db::name("project")->save($info);
  630. if($cr){
  631. //修改状态,添加待办
  632. ActionLog::logAdd($this->post['token'], [
  633. "order_code" => $projectNo,//项目编码
  634. "status" => $old_project_status,//这里的status是之前的值
  635. "action_remark" => '',//备注
  636. "action_type" => "status"//新建create,编辑edit,更改状态status
  637. ], "PRO", 4, $info);
  638. ProcessOrder::AddProcess($this->post['token'], [
  639. "order_type" => 'PRO',
  640. "order_code" => $projectNo,
  641. "order_id" => $info['id'],
  642. "order_status" => 4,"before_status"=>$old_project_status
  643. ]);
  644. Db::commit();
  645. return app_show(0,"方案制作成功",["planNo"=>$planNo]);
  646. }
  647. }
  648. }
  649. Db::rollback();
  650. return error_show(1004,"方案制作失败");
  651. }catch (\Exception $e){
  652. Db::rollback();
  653. return error_show(1004,$e->getMessage());
  654. }
  655. }
  656. public function planinfo(){
  657. $planNo = isset($this->post['planNo'])&& $this->post['planNo']!==""?trim($this->post["planNo"]):"";
  658. if($planNo==""){
  659. return error_show(1004,"参数planNo不能为空");
  660. }
  661. $plan = Db::name("project_plan")->where(["planNo"=>$planNo,"is_del"=>0])->find();
  662. if($plan==false){
  663. return error_show(1004,"未找到项目方案信息");
  664. }
  665. $plan['feedback']=[];
  666. $feedback =Db::name("project_plan_rela")->where(["planNo"=>$planNo,"is_del"=>0])->column("feedback_id,sale_price,sale_num");
  667. if(!empty($feedback)){
  668. $feedid = array_column($feedback,"feedback_id");
  669. $feedlist = Db::name("project_feedback")->where(["id"=>$feedid,"is_del"=>0])->select();
  670. if(!empty($feedlist)){
  671. foreach ($feedlist as $value){
  672. $key =array_search($value['id'],$feedid);
  673. $price = $feedback[$key]['sale_price'];
  674. $value["cat_info"]=isset($value['cat_id'])&&$value['cat_id']!=""? made($value['cat_id'],[]):[];
  675. $value["sale_price"]=$price;
  676. $value["origin_num"]=$value['num'];
  677. $value["num"]=$feedback[$key]['sale_num'];
  678. $plan['feedback'][]=$value;
  679. }
  680. }
  681. }
  682. return app_show(0,"获取成功",$plan);
  683. }
  684. public function project_plan(){
  685. $projectNo = isset($this->post['projectNo'])&&$this->post['projectNo']!==""?trim($this->post['projectNo']):"";
  686. if($projectNo==""){
  687. return error_show(1004,"参数projectNo不能为空");
  688. }
  689. $type = isset($this->post['type'])&&$this->post['type']!=="" ? intval($this->post['type']) :0;
  690. $info =Db::name("project")->where(["projectNo"=>$projectNo,"is_del"=>0])->find();
  691. if($info==false){
  692. return error_show(1004,"未找到项目信息");
  693. }
  694. $plat = Db::name("platform")->where(['id'=>$info['platform_id']])->find();
  695. $info['platform_name']=isset($plat['platform_name'])?$plat['platform_name']:"";
  696. $info['platform_code']=isset($plat['platform_code'])?$plat['platform_code']:"";
  697. $khinfo = Db::name("customer_info")->where(["companyNo"=>$info['khNo']])->find();
  698. $info['khName'] = isset($khinfo['companyName'])?$khinfo['companyName']:"";
  699. if($type==1){
  700. $where = ['projectNo'=>$projectNo,"is_del"=>0,"status"=>1];
  701. }else{
  702. $where = ['projectNo'=>$projectNo,"is_del"=>0];
  703. }
  704. $ladder = Db::name("project_plan")->where($where)->order("addtime desc")->select()->toArray();
  705. $info=[];
  706. if(!empty($ladder)){
  707. foreach ($ladder as $value){
  708. $value['feedback']=[];
  709. $feedback =Db::name("project_plan_rela")->where(["planNo"=>$value['planNo'],"is_del"=>0])->column("feedback_id,sale_price,sale_num");
  710. if(!empty($feedback)){
  711. $feedid = array_column($feedback,"feedback_id");
  712. $feedlist = Db::name("project_feedback")->where(["id"=>$feedid,"is_del"=>0])->select();
  713. if(!empty($feedlist)){
  714. foreach ($feedlist as $val){
  715. $key =array_search($val['id'],$feedid);
  716. $price = $feedback[$key]['sale_price'];
  717. $val["cat_info"]=isset($val['cat_id'])&&$val['cat_id']!=""? made($val['cat_id'],[]):[];
  718. $val["origin_sale_price"]=$val['sale_price'];
  719. $val["sale_price"]=$price;
  720. $val["origin_num"]=$val['num'];
  721. $val["num"]=$feedback[$key]['sale_num'];
  722. if($val['data_source']!=1){
  723. $good=Db::name("consult_bids")->where(["spuCode"=>$val['spuCode'],"is_del"=>0])->find();
  724. $good['specinfo']=isset($good['specinfo'])&&$good['specinfo']!=""?json_decode($good['specinfo'],true):[];
  725. }else{
  726. $good=Db::name("good")->where(["spuCode"=>$val['spuCode'],"is_del"=>0])->find();
  727. $spec = Db::name("good_spec")->where(["spuCode"=>$val['spuCode'],"is_del"=>0])->select()->toArray();
  728. $good['specinfo']=[];
  729. if(!empty($spec)){
  730. foreach ($spec as $vae){
  731. $specs=Db::name("specs")->where(["id"=>$vae['spec_id']])->find();
  732. $spec_value = Db::name("spec_value")->where(["id"=>$vae["spec_value_id"]])->find();
  733. $temp = ["specid"=>$vae['spec_id'],"spec_name"=>$specs['spec_name'],"spec_value_id"=>$vae['spec_value_id'],"spec_value_name"=>$spec_value["spec_value"]];
  734. $good['specinfo'][]=$temp;
  735. }
  736. }
  737. }
  738. if(isset($good['brand_id'])){
  739. $brand =Db::name("brand")->where(["id"=>$good['brand_id']])->find();
  740. }
  741. $val['good_img']=isset($good['good_thumb_img'])&&$good['good_thumb_img']!=""?trim($good['good_thumb_img']):"";
  742. $val['brand_id']=isset($good['brand_id'])&&$good['brand_id']!=""?$good['brand_id']:"";
  743. $val['brand_name']=isset($brand['brand_name'])&&$brand['brand_name']!=""?$brand['brand_name']:"";
  744. $val['specinfo']=isset($good['specinfo'])&&$good['specinfo']!=""?$good['specinfo']:[];
  745. $value['feedback'][]=$val;
  746. }
  747. }
  748. }
  749. $info[]=$value;
  750. }
  751. }
  752. return app_show(0,"获取成功",$info);
  753. }
  754. public function feedCheck(){
  755. $feedid = isset($this->post['feedid'])&&!empty($this->post['feedid']) ? $this->post['feedid'] :[];
  756. if(empty($feedid)){
  757. return error_show(1004,"参数feedid不能为空");
  758. }
  759. $feedid=array_unique($feedid);
  760. $selec = Db::name("project_feedback")->where(["id"=>$feedid,'is_del'=>0,"status"=>0])->select()->toArray();
  761. if(empty($selec)){
  762. return error_show(1004,"反馈数据信息未找到");
  763. }
  764. $pgnos =array_column($selec,"pgNo");
  765. $infolist = Db::name("project_info")->where(['pgNo'=>$pgnos])->select()->toArray();
  766. if(empty($infolist)){
  767. return error_show(1004,"项目商品数据未找到");
  768. }
  769. Db::startTrans();
  770. try{
  771. $up = Db::name("project_feedback")->where(["id"=>$feedid,'is_del'=>0,"status"=>0])->save(["status"=>1,"updatetime"=>date("Y-m-d H:i:s")]);
  772. if($up){
  773. foreach ($infolist as $value){
  774. $poject=Db::name("project")->where(["projectNo"=>$value['projectNo']])->find();
  775. if($poject==false){
  776. Db::rollback();
  777. return error_show(1004,"项目单未找到");
  778. }
  779. $old_projectinfo_status = $value['status'];
  780. $value['status']=3;
  781. $value['updatetime']=date("Y-m-d H:i:s");
  782. $up = Db::name("project_info")->save($value);
  783. if($up){
  784. //修改状态,添加待办,只记录动作
  785. ActionLog::logAdd($this->post['token'], [
  786. "order_code" => $value['pgNo'],//编码
  787. "status" => $old_projectinfo_status,//这里的status是之前的值
  788. "action_remark" => '',//备注
  789. "action_type" => "status"//新建create,编辑edit,更改状态status
  790. ], "PRI", 3, $value);
  791. $count = Db::name("project_info")->where(["projectNo"=>$value['projectNo'],"status"=>2])
  792. ->count();
  793. if($count==0){
  794. $proc =Db::name("project")->where(["projectNo"=>$value['projectNo']])->save
  795. (["status"=>3,"updatetime"=>date("Y-m-d H:i:s")]);
  796. if(!$proc){
  797. Db::rollback();
  798. return error_show(1004,"反馈数据选择失败");
  799. }else{
  800. //修改状态,添加待办
  801. ActionLog::logAdd($this->post['token'], [
  802. "order_code" =>$value['projectNo'],//项目编码
  803. "status" => $poject['status'],//这里的status是之前的值
  804. "action_remark" => '',//备注
  805. "action_type" => "status"//新建create,编辑edit,更改状态status
  806. ], "PRO", 3, ["status"=>3,"updatetime"=>date("Y-m-d H:i:s")]);
  807. ProcessOrder::AddProcess($this->post['token'], [
  808. "order_type" => 'PRO',
  809. "order_code" =>$value['projectNo'],
  810. "order_id" => $poject['id'],
  811. "order_status" => 3,"before_status"=>$poject['status']
  812. ]);
  813. }
  814. }
  815. }else{
  816. Db::rollback();
  817. return error_show(1004,"反馈数据选择失败");
  818. }
  819. }
  820. Db::commit();
  821. return app_show(0,"反馈数据选择成功");
  822. }else{
  823. Db::rollback();
  824. return error_show(1004,"反馈数据选择失败");
  825. }
  826. }catch (\Exception $e){
  827. Db::rollback();
  828. return error_show(1004,$e->getMessage());
  829. }
  830. }
  831. public function planCheck(){
  832. $planNos = isset($this->post['planNos'])&&!empty($this->post['planNos'])? $this->post['planNos'] :"";
  833. if($planNos==""){
  834. return error_show(1004,"参数planNos不能为空");
  835. }
  836. $status=isset($this->post['status'])&&$this->post['status']!=="" ? intval($this->post['status']):"";
  837. if($status==""){
  838. return error_show(1004,"参数status不能为空");
  839. }
  840. $selec = Db::name("project_plan")->where(["planNo"=>$planNos,'is_del'=>0,"status"=>0])->select()->toArray();
  841. if(empty($selec)){
  842. return error_show(1004,"项目方案数据信息未找到");
  843. }
  844. Db::startTrans();
  845. try{
  846. $up = Db::name("project_plan")->where(["planNo"=>$planNos,'is_del'=>0,"status"=>0])->save(["status"=>1,"updatetime"=>date("Y-m-d H:i:s")]);
  847. if($up) {
  848. foreach ($selec as $value){
  849. //修改状态,添加待办,只记录动作
  850. ActionLog::logAdd($this->post['token'], [
  851. "order_code" => $value['planNo'],//编码
  852. "status" => $value['status'],//这里的status是之前的值
  853. "action_remark" => '',//备注
  854. "action_type" => "edit"//新建create,编辑edit,更改状态status
  855. ], "PRO", 1, $value);
  856. }
  857. $project = array_column($selec, "projectNo");
  858. if (empty($project)) {
  859. Db::rollback();
  860. return error_show(1004, "方案选择失败");
  861. }
  862. $pro = Db::name("project")->where(["projectNo" => $project, "status" => 4])->save(["status" => 5, "updatetime" => date("Y-m-d H:i:s")]);
  863. if ($pro) {
  864. foreach ($project as $value){
  865. $poject=Db::name("project")->where(["projectNo"=>$value])->find();
  866. if($poject==false){
  867. Db::rollback();
  868. return error_show(1004,"项目单未找到");
  869. }
  870. //修改状态,添加待办
  871. ActionLog::logAdd($this->post['token'], [
  872. "order_code" =>$value,//项目编码
  873. "status" => 4,//这里的status是之前的值
  874. "action_remark" => '',//备注
  875. "action_type" => "status"//新建create,编辑edit,更改状态status
  876. ], "PRO", 5, ["status"=>5,"updatetime"=>date("Y-m-d H:i:s")]);
  877. ProcessOrder::AddProcess($this->post['token'], [
  878. "order_type" => 'PRO',
  879. "order_code" =>$value,
  880. "order_id" => $poject['id'],
  881. "order_status" => 5,"before_status"=>4
  882. ]);
  883. }
  884. Db::commit();
  885. return app_show(0, "方案数据修改成功");
  886. }
  887. }
  888. Db::rollback();
  889. return error_show(1004,"方案选择失败");
  890. }catch (\Exception $e){
  891. Db::rollback();
  892. return error_show(1004,$e->getMessage());
  893. }
  894. }
  895. public function changeRate(){
  896. $projectNo = isset($this->post['projectNo'])&&$this->post['projectNo']!==""?trim($this->post['projectNo']):"";
  897. if($projectNo==""){
  898. return error_show(1004,"参数projectNo不能为空");
  899. }
  900. $info =Db::name("project")->where(["projectNo"=>$projectNo,"is_del"=>0])->find();
  901. if($info==false){
  902. return error_show(1004,"未找到项目信息");
  903. }
  904. $rate = isset($this->post['rate'])&&$this->post['rate']!=="" ?floatval($this->post['rate']):"";
  905. if($rate===""){
  906. return error_show(1004,"参数rate不能为空");
  907. }
  908. $info['low_rate']=$rate;
  909. $info['updatetime']=date("Y-m-d H:i:s");
  910. $up =Db::name("project")->save($info);
  911. if($up){
  912. return app_show(0,"利润率修改成功");
  913. }else{
  914. return error_show(1004,"利润率修改失败");
  915. }
  916. }
  917. public function order(){
  918. $id = isset($this->post['id'])&& $this->post['id']!=="" ? intval($this->post['id']):"";
  919. if($id==""){
  920. return error_show(1004,"参数id不能为空");
  921. }
  922. $backinfo = Db::name("project_feedback")->where(["id"=>$id,"is_del"=>0])->find();
  923. if($backinfo==false){
  924. return error_show(1004,"未找到数据");
  925. }
  926. $prject = Db::name("project")->where(["projectNo"=>$backinfo['projectNo'],"is_del"=>0])->find();
  927. if($prject==false) {
  928. return error_show(1004, "未找到项目数据");
  929. }
  930. $send_type =isset($this->post['send_type'])&&$this->post['send_type']!=""? intval($this->post['send_type']):"";
  931. if($send_type==""){
  932. return error_show(1004,"参数send_type不能为空");
  933. }
  934. if($send_type==1){
  935. $va = isset($this->post['order_addr']) && $this->post['order_addr'] !== "" ? $this->post['order_addr'] : "";
  936. if ($va == "") {
  937. return error_show(1002, "参数order_addr不能为空");
  938. }
  939. }
  940. $plat = Db::name("platform")->where(["id"=>$prject['platform_id']])->find();
  941. $token = isset($this->post['token'])&& $this->post['token']!=="" ? trim($this->post['token']):"";
  942. if($token==""){
  943. return error_show(1004,"参数token不能为空");
  944. }
  945. $apply_id = GetUserInfo($token);
  946. if (empty($apply_id) || $apply_id['code'] != 0) {
  947. return error_show(1002, "申请人数据不存在");
  948. }
  949. $rm = isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  950. $ri = isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  951. $orderCode = makeNo("QR");
  952. Db::startTrans();
  953. try{
  954. $data = [
  955. "orderCode" => $orderCode,
  956. "good_code" => $backinfo['spuCode'],
  957. "customer_code" => $prject['khNo'],
  958. "good_name" => $backinfo['good_name'],
  959. "good_num" => $backinfo['num'],
  960. "order_type" =>3,
  961. "order_source" =>3,//3项目
  962. "item_code"=>isset($plat['platform_code'])? $plat['platform_code']:"",
  963. "good_type"=>1,
  964. "apply_id" => $rm,
  965. "apply_name" => $ri,
  966. "origin_price" =>$backinfo['nake_price'],
  967. "sale_price" => $backinfo['sale_price'],
  968. "post_fee" => 0,
  969. "status" => 0,
  970. "supplierNo" =>$prject['companyNo'],
  971. "send_num" => 0,
  972. "zxNo"=>$backinfo['pgNo'],
  973. "wsend_num" => $backinfo['num'],
  974. "send_type" => $send_type,
  975. "send_status" => 1,
  976. "is_del" => 0,
  977. "addtime" => date("Y-m-d H:i:s"),
  978. "updatetime" => date("Y-m-d H:i:s"),
  979. 'total_price' => $backinfo['sale_price'] * $backinfo['num'],
  980. ];
  981. $datainfo = Db::name('sale')->insert($data, true);
  982. if($datainfo>0){
  983. if($send_type==1){
  984. foreach ($va as $value) {
  985. $temp = [];
  986. $addrs = [];
  987. if ($value['addr_code'] !== '' && is_array($value['addr_code'])) {
  988. $addrs['provice_code'] = $value['addr_code'][0];
  989. $addrs['city_code'] = $value['addr_code'][1];
  990. $addrs['area_code'] = $value['addr_code'][2];
  991. $addr = json_encode($addrs);
  992. } else {
  993. $addr = isset($value['addr_code']) ? $value['addr_code'] : '';
  994. }
  995. $temp['orderCode'] = $orderCode;
  996. $temp['contactor'] = $value['contactor'];
  997. $temp['mobile'] = $value['mobile'];
  998. $temp['addr'] = $value['addr'];
  999. $temp['addr_code'] = $addr;
  1000. $temp['customer_code'] = $prject['khNo'];
  1001. $temp['receipt_quantity'] = $value['receipt_quantity'];
  1002. $temp['post_fee'] = 0;
  1003. $temp['is_del'] = 0;
  1004. $temp['addtime'] = date("Y-m-d H:i:s");
  1005. $temp['updatetime'] = date("Y-m-d H:i:s");
  1006. $temp['arrive_time'] = date("Y-m-d H:i:s");
  1007. $vat[] = $temp;
  1008. }
  1009. $vmp = Db::name('order_addr')->insertAll($vat);
  1010. if ($vmp==false) {
  1011. Db::rollback();
  1012. return error_show(1004, "销售订单创建失败");
  1013. }
  1014. }
  1015. Db::name('standing_book')
  1016. ->where('projectNo', $backinfo['projectNo'])
  1017. ->update([
  1018. 'sale_id' => $datainfo,
  1019. 'orderCode' => $orderCode,
  1020. 'customer_code' => $prject['khNo'],
  1021. 'spuCode' => $backinfo['spuCode'],
  1022. 'order_type' => $data['order_type'],
  1023. 'order_source' => $data['order_source'],
  1024. 'supplierNo' => $prject['companyNo'],
  1025. 'updatetime' => date("Y-m-d H:i:s")
  1026. ]);
  1027. Db::commit();
  1028. return error_show(0, "销售订单创建成功");
  1029. }
  1030. Db::rollback();
  1031. return error_show(1004, "销售订单创建失败");
  1032. }catch (\Exception $w){
  1033. Db::rollback();
  1034. return error_show(1004, $w->getMessage());
  1035. }
  1036. }
  1037. public function feeddel(){
  1038. $feedid = isset($this->post['id'])&&!empty($this->post['id']) ? $this->post['id'] :[];
  1039. if(empty($feedid)){
  1040. return error_show(1004,"参数feedid不能为空");
  1041. }
  1042. $selec = Db::name("project_feedback")->where(["id"=>$feedid,'is_del'=>0])->select();
  1043. if(empty($selec)){
  1044. return error_show(1004,"反馈数据信息未找到");
  1045. }
  1046. $up = Db::name("project_feedback")->where(["id"=>$feedid,'is_del'=>0])->save(["is_del"=>1,"updatetime"=>date("Y-m-d H:i:s")]);
  1047. if($up){
  1048. return app_show(0,"反馈数据删除成功");
  1049. }else{
  1050. return error_show(1004,"反馈数据删除失败");
  1051. }
  1052. }
  1053. }