Project.php 46 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939
  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(105,"参数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(105,"参数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. $nake =Db::name("good_nake")->where(["spuCode"=>$value['spuCode'],"is_del"=>0])->where([["min_num","<=",$projectinfo['num']]])
  178. ->order("min_num desc")->find();
  179. $origin_price=isset($nake['nake_total'])?$nake['nake_total']:"0" ;
  180. $sale_price = $ladd['sale_price'];
  181. }else{
  182. $sale_price =$value['sale_price'];
  183. $origin_price =$value['sale_price'];
  184. }
  185. $temp['sale_price']=$sale_price;
  186. $temp['origin_price']=$origin_price;
  187. $temp['num']=$projectinfo['num'];
  188. $temp['status']=0;
  189. $temp['is_del']=0;
  190. $temp['creater']=$creater;
  191. $temp['createrid']=$createrid;
  192. $temp['addtime']=date("Y-m-d H:i:s");
  193. $temp['updatetime']=date("Y-m-d H:i:s");
  194. $data[]=$temp;
  195. }
  196. $nu = Db::name("project_feedback")->insertAll($data);
  197. if($nu>0){
  198. $projectinfo['status']=2;
  199. $projectinfo['updatetime']=date("Y-m-d H:i:s");
  200. $up = Db::name("project_info")->save($projectinfo);
  201. if($up){
  202. $count = Db::name("project_info")->where(["projectNo"=>$projectinfo['projectNo'],"status"=>1])
  203. ->count();
  204. if($count==0){
  205. $proc =Db::name("project")->where(["projectNo"=>$projectinfo['projectNo'],"status"=>1])->save
  206. (["status"=>2,"updatetime"=>date("Y-m-d H:i:s")]);
  207. if($proc){
  208. Db::commit();
  209. return app_show(0,"添加成功");
  210. }
  211. }
  212. }
  213. Db::commit();
  214. return app_show(0,"添加成功");
  215. }else{
  216. Db::rollback();
  217. return error_show(1004,"添加失败");
  218. }
  219. }catch (\Exception $e){
  220. Db::rollback();
  221. return error_show(1004,$e->getMessage());
  222. }
  223. }
  224. public function list(){
  225. $page =isset($this->post['page'])&&$this->post['page']!=="" ? intval($this->post['page']):1;
  226. $size =isset($this->post['size'])&&$this->post['size']!==""? intval($this->post['size']):10;
  227. $where=[["is_del","=",0]];
  228. $khNo = isset($this->post['khNo']) &&$this->post['khNo']!==""? trim($this->post['khNo']):"";
  229. if($khNo!==""){
  230. $where[]=["khNo","=",$khNo];
  231. }
  232. $project_name = isset($this->post['project_name']) &&$this->post['project_name']!==""? trim($this->post['project_name']):"";
  233. if($project_name!==""){
  234. $where[]=["project_name","like","%$project_name%"];
  235. }
  236. $status = isset($this->post['status']) &&$this->post['status']!==""? intval($this->post['status']):"";
  237. if($status!==""){
  238. $where[]=["status","=",$status];
  239. }
  240. $start = isset($this->post['start'])&&$this->post['start']!=="" ? $this->post['start']:"";
  241. if($start!==''){
  242. $where[]=["addtime",">=",$start];
  243. }
  244. $end = isset($this->post['end'])&&$this->post['end']!=="" ? $this->post['end']:"";
  245. if($end!==''){
  246. $where[]=["addtime","<=",$end];
  247. }
  248. $low = isset($this->post['low'])&&$this->post['low']!=="" ? floatval($this->post['low']):"";
  249. if($low!==''){
  250. $where[]=["budget_total",">=",$low];
  251. }
  252. $up = isset($this->post['up'])&&$this->post['up']!=="" ? floatval($this->post['up']):"";
  253. if($up!==''){
  254. $where[]=["budget_total","<=",$up];
  255. }
  256. $companyNo = isset($this->post['companyNo'])&&$this->post['companyNo']!=="" ? trim($this->post['companyNo']):"";
  257. if($companyNo!==''){
  258. $where[]=["companyNo","like","%$companyNo%"];
  259. }
  260. $platform_id = isset($this->post['platform_id'])&&$this->post['platform_id']!=="" ? intval($this->post['platform_id']):"";
  261. if($platform_id!==''){
  262. $where[]=["platform_id","=",$platform_id];
  263. }
  264. $count = Db::name('project')->where($where)->count();
  265. $total = ceil($count / $size);
  266. $page = $page >= $total ? $total : $page;
  267. $list = Db::name('project')->where($where)->page($page,$size)->order("addtime desc")->select();
  268. $data=[];
  269. foreach ($list as $value){
  270. $info = Db::name("platform")->where(['id'=>$value['platform_id']])->find();
  271. $value['platform_name']=isset($info['platform_name'])?$info['platform_name']:"";
  272. $value['platform_code']=isset($info['platform_code'])?$info['platform_code']:"";
  273. $khinfo = Db::name("customer_info")->where(["companyNo"=>$value['khNo']])->find();
  274. $value['khName'] = isset($khinfo['companyName'])?$khinfo['companyName']:"";
  275. $company = Db::name("business")->where(["companyNo"=>$value['companyNo']])->find();
  276. $value['company'] = isset($company['company'])?$company['company']:"";
  277. $data[]=$value;
  278. }
  279. return app_show(0,"获取成功",['list'=>$data,'count'=>$count]);
  280. }
  281. public function feedlist(){
  282. $page =isset($this->post['page'])&&$this->post['page']!=="" ? intval($this->post['page']):1;
  283. $size =isset($this->post['size'])&&$this->post['size']!==""? intval($this->post['size']):10;
  284. $where=[["is_del","=",0]];
  285. $pgNo =isset($this->post['pgNo'])&&$this->post['pgNo']!==""?trim($this->post['pgNo']):"";
  286. if($pgNo!==""){
  287. $where[]=["pgNo","=",$pgNo];
  288. }
  289. $projectNo =isset($this->post['projectNo'])&&$this->post['projectNo']!==""?trim($this->post['projectNo']):"";
  290. if($projectNo!==""){
  291. $where[]=["projectNo","=",$projectNo];
  292. }
  293. $source =isset($this->post['source'])&&$this->post['source']!==""?intval($this->post['source']):"";
  294. if($source!==""){
  295. $where[]=["data_source","=",$source];
  296. }
  297. $cat_id =isset($this->post['cat_id'])&&$this->post['cat_id']!==""?intval($this->post['cat_id']):"";
  298. if($cat_id!==""){
  299. $where[]=["cat_id","=",$cat_id];
  300. }
  301. $status =isset($this->post['status'])&&$this->post['status']!==""?intval($this->post['status']):"";
  302. if($status!==""){
  303. $where[]=["status","=",$status];
  304. }
  305. $count = Db::name('project_feedback')->where($where)->count();
  306. $total = ceil($count / $size);
  307. $page = $page >= $total ? $total : $page;
  308. $list = Db::name('project_feedback')->where($where)->page($page,$size)->order("addtime desc")->select();
  309. $data=[];
  310. foreach ($list as $value){
  311. $value['can']=isset($value['cat_id'])&&$value['cat_id']!=""?made($value['cat_id']):"";
  312. if($value['data_source']==1){
  313. $good=Db::name("good_platform")->alias("a")->leftJoin("good b","a.spuCode=b.spuCode")->where
  314. (["a.skuCode"=>$value['skuCode'],"a.is_del"=>0])->find();
  315. $nake = Db::name("good_nake")->where([["spuCode","=",$value['spuCode']],["min_num","<=",
  316. $value["num"]],["is_del","=",0]])->order("min_num desc")->find();
  317. $good['unit_id'] = isset($good['good_unit'])?$good['good_unit']:"";
  318. $good['cost_desc'] = isset($good['craft_desc'])?$good['craft_desc']:"";
  319. $good['pakge_fee'] = isset($nake['package_fee'])?$nake['package_fee']:"0";
  320. $good['mark_fee'] = isset($nake['mark_fee'])?$nake['mark_fee']:"0";
  321. $good['other_fee'] = isset($nake['other_fee'])?$nake['other_fee']:"0";
  322. $good['cert_fee'] = isset($nake['cert_fee'])?$nake['cert_fee']:"0";
  323. $good['delivery_fee'] = isset($nake['delivery_fee'])?$nake['delivery_fee']:"0";
  324. $good['nake_fee'] = isset($nake['nake_fee'])?$nake['nake_fee']:"0";
  325. $good['metal_id'] = isset($good['noble_metal'])?$good['noble_metal']:"0";
  326. //有效期
  327. $good['expire_day']=Db::name('consult_bids')->where(['spuCode'=>$value['spuCode']])->value('expire_day');
  328. $spec = Db::name("good_spec")->where(["spuCode"=>$good['spuCode'],"is_del"=>0])->select()->toArray();
  329. $good['specinfo']=[];
  330. if(!empty($spec)){
  331. foreach ($spec as $vae){
  332. $specs=Db::name("specs")->where(["id"=>$vae['spec_id']])->find();
  333. $spec_value = Db::name("spec_value")->where(["id"=>$vae["spec_value_id"]])->find();
  334. $temp = ["specid"=>$vae['spec_id'],"spec_name"=>$specs['spec_name'],"spec_value_id"=>$vae['spec_value_id'],"spec_value_name"=>$spec_value["spec_value"]];
  335. $good['specinfo'][]=$temp;
  336. }
  337. }
  338. $nake =Db::name("good_nake")->where(["spuCode"=>$good['spuCode'],"is_del"=>0])->where([["min_num","<=",$value['num']]])
  339. ->order("min_num desc")->find();
  340. $good['origin_price']=$nake['nake_total'];
  341. $good['work_day']=$good['lead_time'];
  342. $good_img = $good['good_thumb_img'];
  343. }else{
  344. $good=Db::name("consult_bids")->where(["spuCode"=>$value['spuCode'],"is_del"=>0])->find();
  345. $good['specinfo'] = isset($good['specinfo'])&&$good['specinfo']!=""?json_decode($good['specinfo'],
  346. true):"";
  347. $catinfo = Db::name("cat")->where(["id"=>$good['cat_id']])->find();
  348. $budget = isset($catinfo['order_rate']) ? $catinfo['order_rate']:100;
  349. // $good=[
  350. // "metal_id"=>$good['metal_id'],
  351. // "weight"=>$good["weight"],
  352. // "demo_fee"=>$good["demo_fee"],
  353. // "delivery_fee"=>$good["delivery_fee"],
  354. // "open_fee"=>$good["open_fee"],
  355. // "packing_fee"=>$good["pakge_fee"],
  356. // "mark_fee"=>$good["mark_fee"],
  357. // "nake_fee"=>$good["nake_fee"],
  358. // "cert_fee"=>$good["cert_fee"],
  359. // "cost_fee"=>$good["cost_fee"],
  360. // "num"=>$value["num"],
  361. // "good_img"=>$good["good_img"],
  362. // "good_img"=>$good["good_img"],
  363. // "good_img"=>$good["good_img"],
  364. // "good_img"=>$good["good_img"],
  365. // "good_img"=>$good["good_img"],
  366. // ];
  367. $good_img = $good['good_img'];
  368. // if($good['is_gold_price']==1){
  369. // $price = GoldPrice($god, 0);
  370. // }else{
  371. // $price = GoodPrice($god, 0);
  372. // }
  373. }
  374. $nobel =\think\facade\Config::get("noble");
  375. $value['good_name'] = isset($good['good_name'])?$good['good_name']:"";
  376. // $value['good_img'] = isset($good['good_img'])?$good['good_img']:"";
  377. $value['brand_id'] = isset($good['brand_id'])?$good['brand_id']:"";
  378. $brand = Db::name("brand")->where(['id'=>$value["brand_id"]])->find();
  379. $value['brand_name'] =isset($brand['brand_name']) ? $brand['brand_name']:"";
  380. $value['specinfo'] = isset($good['specinfo'])&&$good['specinfo']!=""?$good['specinfo']:[];
  381. $value['unit_id'] = isset($good['unit_id'])?$good['unit_id']:"";
  382. $unit = Db::name("unit")->where(['id'=>$value["unit_id"]])->find();
  383. $value["unit_name"]=isset($unit['unit'])?$unit['unit']:"";
  384. $value['cost_desc'] = isset($good['cost_desc'])?$good['cost_desc']:"";
  385. $value['work_day'] = isset($good['work_day'])?$good['work_day']:"";
  386. $value['delivery_day'] = isset($good['delivery_day'])?$good['delivery_day']:"";
  387. $value['expire_day'] = isset($good['expire_day'])?$good['expire_day']:"0";
  388. $value['good_img'] = $good_img;
  389. $value['expire_day'] = isset($good['expire_day'])?$good['expire_day']:"";
  390. $value['origin_place'] = isset($good['origin_place'])?$good['origin_place']:"";
  391. $value['supplierNo'] = isset($good['supplierNo'])?$good['supplierNo']:"";
  392. $value['pay_way'] = isset($good['pay_way'])?$good['pay_way']:"";
  393. $value['tax'] = isset($good['tax'])?$good['tax']:"";
  394. $value['send_way'] = isset($good['send_way'])?$good['send_way']:"";
  395. $value['metal_id'] = isset($good['metal_id'])?$good['metal_id']:"";
  396. $value['metal_name'] = isset($nobel[$good['metal_id']])?$nobel[$good['metal_id']]:"";
  397. $value['is_gold_price'] = isset($good['is_gold_price'])?$good['is_gold_price']:"0";
  398. $value['config'] = isset($good['config'])?$good['config']:"";
  399. $value['other_config'] = isset($good['other_config'])?$good['other_config']:"";
  400. $value['weight'] = isset($good['weight'])?$good['weight']:"";
  401. $value['is_diff'] = isset($good['is_diff'])?$good['is_diff']:"0";
  402. $value['demo_fee'] = isset($good['demo_fee'])?$good['demo_fee']:"0";
  403. $value['deivery_fee'] = isset($good['deivery_fee'])?$good['deivery_fee']:"0";
  404. $value['open_fee'] = isset($good['open_fee'])?$good['open_fee']:"0";
  405. $value['pakge_fee'] = isset($good['pakge_fee'])?$good['pakge_fee']:"0";
  406. $value['nake_fee'] = isset($good['nake_fee'])?$good['nake_fee']:"0";
  407. $value['mark_fee'] = isset($good['mark_fee'])?$good['mark_fee']:"0";
  408. $value['cert_fee'] = isset($good['cert_fee'])?$good['cert_fee']:"0";
  409. $value['cost_fee'] = isset($good['cost_fee'])?$good['cost_fee']:"0";
  410. $value['rate'] =round(($value['sale_price'] - $value['origin_price'])/$value['sale_price'] * 100,2);
  411. $value['supply_area'] = isset($good['supply_area'])?$good['supply_area']:"";
  412. $data[]=$value;
  413. }
  414. return app_show(0,"获取成功",['list'=>$data,'count'=>$count]);
  415. }
  416. public function info(){
  417. $projectNo = isset($this->post['projectNo'])&&$this->post['projectNo']!==""?trim($this->post['projectNo']):"";
  418. if($projectNo==""){
  419. return error_show(1004,"参数projectNo不能为空");
  420. }
  421. $type = isset($this->post['type'])&&$this->post['type']!=="" ? intval($this->post['type']) :0;
  422. $info =Db::name("project")->where(["projectNo"=>$projectNo,"is_del"=>0])->find();
  423. if($info==false){
  424. return error_show(1004,"未找到项目信息");
  425. }
  426. $plat = Db::name("platform")->where(['id'=>$info['platform_id']])->find();
  427. $info['platform_name']=isset($plat['platform_name'])?$plat['platform_name']:"";
  428. $info['platform_code']=isset($plat['platform_code'])?$plat['platform_code']:"";
  429. $khinfo = Db::name("customer_info")->where(["companyNo"=>$info['khNo']])->find();
  430. $info['khName'] = isset($khinfo['companyName'])?$khinfo['companyName']:"";
  431. $company = Db::name("business")->where(["companyNo"=>$info['companyNo']])->find();
  432. $info['company'] = isset($company['company'])?$company['company']:"";
  433. $ladder = Db::name("project_info")->where(['projectNo'=>$projectNo,"is_del"=>0])->select()->toArray();
  434. $info['ladder']=[];
  435. if(!empty($ladder)){
  436. foreach ($ladder as $value){
  437. $value["cat_info"]=isset($value['cat_id']) &&$value['cat_id']!=""? made($value['cat_id'],[]):[];
  438. $condition = $type==0?['pgNo'=>$value['pgNo'],"is_del"=>0] : ['pgNo'=>$value['pgNo'],"is_del"=>0,"status"=>1];
  439. $feedback = Db::name("project_feedback")->where($condition)->select()->toArray();
  440. array_walk($feedback,function (&$v){
  441. $v["cat_info"]=isset($v['cat_id'])&&$v['cat_id']!=""? made($v['cat_id'],[]):[];
  442. });
  443. // $zx = Db::name("consult_info")->where(["pgNo"=>$value["pgNo"],"is_del"=>0,"bargain_status"=>0])
  444. // ->column("infoNo");
  445. // if(!empty($zx)){
  446. // $zxback = Db::name("consult_bids")->where(["infoNo"=>$zx,"is_del"=>0])->select()->toArray();
  447. // array_walk($zxback,function (&$v){
  448. // $v["cat_info"]=isset($v['cat_id'])? made($v['cat_id'],[]):[];
  449. // });
  450. // }else{
  451. // $zxback=[];
  452. // }
  453. $value['feedback']=$feedback;
  454. // $value['zxback']=$zxback;
  455. $info['ladder'][]=$value;
  456. }
  457. }
  458. return app_show(0,"获取成功",$info);
  459. }
  460. public function plan_create(){
  461. $projectNo = isset($this->post['projectNo'])&&$this->post['projectNo']!==""?trim($this->post['projectNo']):"";
  462. if($projectNo==""){
  463. return error_show(1004,"参数projectNo不能为空");
  464. }
  465. $info =Db::name("project")->where(["projectNo"=>$projectNo,"is_del"=>0])->find();
  466. if($info==false){
  467. return error_show(1004,"未找到项目信息");
  468. }
  469. if($info['status']!=3 && $info['status']!=4){
  470. return error_show(1004,"项目状态有误");
  471. }
  472. $feedback =isset($this->post['feedback'])&&!empty($this->post['feedback'])?$this->post['feedback']:"";
  473. if($feedback==""){
  474. return error_show(1004,"参数feedback不能为空");
  475. }
  476. $feedid =array_column($feedback,"feedid");
  477. $feedinfo = Db::name("project_feedback")->where(['id'=>$feedid,"projectNo"=>$projectNo,"is_del"=>0])
  478. ->select()->toArray();
  479. if(empty($feedinfo)){
  480. return error_show(1004,"反馈数据未找到");
  481. }
  482. $token = isset($this->post['token'])&& $this->post['token']!='' ? trim($this->post['token']):"";
  483. if($token==''){
  484. return error_show(105,"参数token不能为空");
  485. }
  486. $user =GetUserInfo($token);
  487. if(empty($user)||$user['code']!=0){
  488. return error_show(1002,"用户数据不存在");
  489. }
  490. $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  491. $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  492. Db::startTrans();
  493. try {
  494. $planNo=makeNo("PLA");
  495. $total=0;
  496. $num_t=0;
  497. $origia=0;
  498. $dl=[];
  499. foreach ($feedinfo as $value){
  500. $key =array_search($value['id'],$feedid);
  501. $price = $feedback[$key];
  502. if($price['sale_price']<$value['origin_price']){
  503. Db::rollback();
  504. return error_show(1004,"反馈商品价格不能小于初始金额");
  505. }
  506. if($price['good_num']<$value['num']){
  507. Db::rollback();
  508. return error_show(1004,"商品数量不能小于初始数量");
  509. }
  510. if($value['data_source']==2){
  511. $bids =Db::name("consult_info")->where(["pgNo"=>$value['pgNo'],"is_del"=>0])->find();
  512. if($bids==false){
  513. Db::rollback();
  514. return error_show(1004,"未找到反馈商品咨询单");
  515. }
  516. $bids["status"]=3;
  517. $bids["updatetime"]=date("Y-m-d H:i:s");
  518. $bd=Db::name("consult_info")->save($bids);
  519. if($bd==false){
  520. Db::rollback();
  521. return error_show(1004,"反馈商品咨询单更新失败");
  522. }
  523. }
  524. // $value['sale_price'] = $price['sale_price'];
  525. // $value['updatetime'] = date("Y-m-d H:i:s");
  526. // $cre=Db::name("project_feedback")->save($value);
  527. // if($cre==false){
  528. // Db::rollback();
  529. // return error_show(1004,"反馈商品价格修改失败");
  530. // }
  531. $temp=[];
  532. $temp['planNo']=$planNo;
  533. $temp['feedback_id']=$value['id'];
  534. $temp['sale_price']=$price["sale_price"];
  535. $temp['sale_num']=$price["good_num"];
  536. $temp['status']=1;
  537. $temp['is_del']=0;
  538. $temp['addtime']=date("Y-m-d H:i:s");
  539. $temp['updatetime']=date("Y-m-d H:i:s");
  540. $total+=$price['good_num']*$price["sale_price"];
  541. $origia+=$price['good_num']*$value["origin_price"];
  542. $num_t+=$price['good_num'];
  543. $dl[]=$temp;
  544. }
  545. $inn=Db::name("project_plan_rela")->insertAll($dl);
  546. if($inn>0){
  547. $data=[
  548. "planNo"=>$planNo,
  549. "projectNo"=>$projectNo,
  550. "createrid"=>$createrid,
  551. "creater"=>$creater,
  552. "sale_total"=>round($total,2),
  553. "total_num"=>$num_t,
  554. "origin_total"=>round($origia,2),
  555. "sale_rate"=>round(($total-$origia)/$total,4)*100,
  556. "status"=>0,
  557. "is_del"=>0,
  558. "addtime"=>date("Y-m-d H:i:s"),
  559. "updatetime"=>date("Y-m-d H:i:s")
  560. ];
  561. $up =Db::name("project_plan")->insert($data);
  562. if($up){
  563. $info['status']=4;
  564. $info['updatetime']=date("Y-m-d H:i:s");
  565. $cr =Db::name("project")->save($info);
  566. if($cr){
  567. Db::commit();
  568. return app_show(0,"方案制作成功",["planNo"=>$planNo]);
  569. }
  570. }
  571. }
  572. Db::rollback();
  573. return error_show(1004,"方案制作失败");
  574. }catch (\Exception $e){
  575. Db::rollback();
  576. return error_show(1004,$e->getMessage());
  577. }
  578. }
  579. public function planinfo(){
  580. $planNo = isset($this->post['planNo'])&& $this->post['planNo']!==""?trim($this->post["planNo"]):"";
  581. if($planNo==""){
  582. return error_show(1004,"参数planNo不能为空");
  583. }
  584. $plan = Db::name("project_plan")->where(["planNo"=>$planNo,"is_del"=>0])->find();
  585. if($plan==false){
  586. return error_show(1004,"未找到项目方案信息");
  587. }
  588. $plan['feedback']=[];
  589. $feedback =Db::name("project_plan_rela")->where(["planNo"=>$planNo,"is_del"=>0])->column("feedback_id,sale_price,sale_num");
  590. if(!empty($feedback)){
  591. $feedid = array_column($feedback,"feedback_id");
  592. $feedlist = Db::name("project_feedback")->where(["id"=>$feedid,"is_del"=>0])->select();
  593. if(!empty($feedlist)){
  594. foreach ($feedlist as $value){
  595. $key =array_search($value['id'],$feedid);
  596. $price = $feedback[$key]['sale_price'];
  597. $value["cat_info"]=isset($value['cat_id'])&&$value['cat_id']!=""? made($value['cat_id'],[]):[];
  598. $value["sale_price"]=$price;
  599. $value["origin_num"]=$value['num'];
  600. $value["num"]=$feedback[$key]['sale_num'];
  601. $plan['feedback'][]=$value;
  602. }
  603. }
  604. }
  605. return app_show(0,"获取成功",$plan);
  606. }
  607. public function project_plan(){
  608. $projectNo = isset($this->post['projectNo'])&&$this->post['projectNo']!==""?trim($this->post['projectNo']):"";
  609. if($projectNo==""){
  610. return error_show(1004,"参数projectNo不能为空");
  611. }
  612. $type = isset($this->post['type'])&&$this->post['type']!=="" ? intval($this->post['type']) :0;
  613. $info =Db::name("project")->where(["projectNo"=>$projectNo,"is_del"=>0])->find();
  614. if($info==false){
  615. return error_show(1004,"未找到项目信息");
  616. }
  617. $plat = Db::name("platform")->where(['id'=>$info['platform_id']])->find();
  618. $info['platform_name']=isset($plat['platform_name'])?$plat['platform_name']:"";
  619. $info['platform_code']=isset($plat['platform_code'])?$plat['platform_code']:"";
  620. $khinfo = Db::name("customer_info")->where(["companyNo"=>$info['khNo']])->find();
  621. $info['khName'] = isset($khinfo['companyName'])?$khinfo['companyName']:"";
  622. if($type==1){
  623. $where = ['projectNo'=>$projectNo,"is_del"=>0,"status"=>1];
  624. }else{
  625. $where = ['projectNo'=>$projectNo,"is_del"=>0];
  626. }
  627. $ladder = Db::name("project_plan")->where($where)->order("addtime desc")->select()->toArray();
  628. $info=[];
  629. if(!empty($ladder)){
  630. foreach ($ladder as $value){
  631. $value['feedback']=[];
  632. $feedback =Db::name("project_plan_rela")->where(["planNo"=>$value['planNo'],"is_del"=>0])->column("feedback_id,sale_price,sale_num");
  633. if(!empty($feedback)){
  634. $feedid = array_column($feedback,"feedback_id");
  635. $feedlist = Db::name("project_feedback")->where(["id"=>$feedid,"is_del"=>0])->select();
  636. if(!empty($feedlist)){
  637. foreach ($feedlist as $val){
  638. $key =array_search($val['id'],$feedid);
  639. $price = $feedback[$key]['sale_price'];
  640. $val["cat_info"]=isset($val['cat_id'])&&$val['cat_id']!=""? made($val['cat_id'],[]):[];
  641. $val["sale_price"]=$price;
  642. $val["origin_num"]=$val['num'];
  643. $val["num"]=$feedback[$key]['sale_num'];
  644. if($val['data_source']!=1){
  645. $good=Db::name("consult_bids")->where(["spuCode"=>$val['spuCode'],"is_del"=>0])->find();
  646. $good['specinfo']=isset($good['specinfo'])&&$good['specinfo']!=""?json_decode($good['specinfo'],true):[];
  647. }else{
  648. $good=Db::name("good")->where(["spuCode"=>$val['spuCode'],"is_del"=>0])->find();
  649. $spec = Db::name("good_spec")->where(["spuCode"=>$val['spuCode'],"is_del"=>0])->select()->toArray();
  650. $good['specinfo']=[];
  651. if(!empty($spec)){
  652. foreach ($spec as $vae){
  653. $specs=Db::name("specs")->where(["id"=>$vae['spec_id']])->find();
  654. $spec_value = Db::name("spec_value")->where(["id"=>$vae["spec_value_id"]])->find();
  655. $temp = ["specid"=>$vae['spec_id'],"spec_name"=>$specs['spec_name'],"spec_value_id"=>$vae['spec_value_id'],"spec_value_name"=>$spec_value["spec_value"]];
  656. $good['specinfo'][]=$temp;
  657. }
  658. }
  659. }
  660. if(isset($good['brand_id'])){
  661. $brand =Db::name("brand")->where(["id"=>$good['brand_id']])->find();
  662. }
  663. $val['good_img']=isset($good['good_img'])&&$good['good_img']!=""?trim($good['good_img']):"";
  664. $val['brand_id']=isset($good['brand_id'])&&$good['brand_id']!=""?$good['brand_id']:"";
  665. $val['brand_name']=isset($brand['brand_name'])&&$brand['brand_name']!=""?$brand['brand_name']:"";
  666. $val['specinfo']=isset($good['specinfo'])&&$good['specinfo']!=""?$good['specinfo']:[];
  667. $value['feedback'][]=$val;
  668. }
  669. }
  670. }
  671. $info[]=$value;
  672. }
  673. }
  674. return app_show(0,"获取成功",$info);
  675. }
  676. public function feedCheck(){
  677. $feedid = isset($this->post['feedid'])&&!empty($this->post['feedid']) ? $this->post['feedid'] :[];
  678. if(empty($feedid)){
  679. return error_show(1004,"参数feedid不能为空");
  680. }
  681. $feedid=array_unique($feedid);
  682. $selec = Db::name("project_feedback")->where(["id"=>$feedid,'is_del'=>0,"status"=>0])->select()->toArray();
  683. if(empty($selec)){
  684. return error_show(1004,"反馈数据信息未找到");
  685. }
  686. $pgnos =array_column($selec,"pgNo");
  687. $infolist = Db::name("project_info")->where(['pgNo'=>$pgnos])->select()->toArray();
  688. if(empty($infolist)){
  689. return error_show(1004,"项目商品数据未找到");
  690. }
  691. Db::startTrans();
  692. try{
  693. $up = Db::name("project_feedback")->where(["id"=>$feedid,'is_del'=>0,"status"=>0])->save(["status"=>1,"updatetime"=>date("Y-m-d H:i:s")]);
  694. if($up){
  695. foreach ($infolist as $value){
  696. $value['status']=3;
  697. $value['updatetime']=date("Y-m-d H:i:s");
  698. $up = Db::name("project_info")->save($value);
  699. if($up){
  700. $count = Db::name("project_info")->where(["projectNo"=>$value['projectNo'],"status"=>2])
  701. ->count();
  702. if($count==0){
  703. $proc =Db::name("project")->where(["projectNo"=>$value['projectNo']])->save
  704. (["status"=>3,"updatetime"=>date("Y-m-d H:i:s")]);
  705. if(!$proc){
  706. Db::rollback();
  707. return error_show(1004,"反馈数据选择失败");
  708. }
  709. }
  710. }else{
  711. Db::rollback();
  712. return error_show(1004,"反馈数据选择失败");
  713. }
  714. }
  715. Db::commit();
  716. return app_show(0,"反馈数据选择成功");
  717. }else{
  718. Db::rollback();
  719. return error_show(1004,"反馈数据选择失败");
  720. }
  721. }catch (\Exception $e){
  722. Db::rollback();
  723. return error_show(1004,$e->getMessage());
  724. }
  725. }
  726. public function planCheck(){
  727. $planNos = isset($this->post['planNos'])&&!empty($this->post['planNos'])? $this->post['planNos'] :"";
  728. if($planNos==""){
  729. return error_show(1004,"参数planNos不能为空");
  730. }
  731. $status=isset($this->post['status'])&&$this->post['status']!=="" ? intval($this->post['status']):"";
  732. if($status==""){
  733. return error_show(1004,"参数status不能为空");
  734. }
  735. $selec = Db::name("project_plan")->where(["planNo"=>$planNos,'is_del'=>0,"status"=>0])->select()->toArray();
  736. if(empty($selec)){
  737. return error_show(1004,"项目方案数据信息未找到");
  738. }
  739. Db::startTrans();
  740. try{
  741. $up = Db::name("project_plan")->where(["planNo"=>$planNos,'is_del'=>0,"status"=>0])->save(["status"=>1,"updatetime"=>date("Y-m-d H:i:s")]);
  742. if($up) {
  743. $project = array_column($selec, "projectNo");
  744. if (empty($project)) {
  745. Db::rollback();
  746. return error_show(1004, "方案选择失败");
  747. }
  748. $pro = Db::name("project")->where(["projectNo" => $project, "status" => 4])->save(["status" => 5, "updatetime" => date("Y-m-d H:i:s")]);
  749. if ($pro) {
  750. Db::commit();
  751. return app_show(0, "方案数据修改成功");
  752. }
  753. }
  754. Db::rollback();
  755. return error_show(1004,"方案选择失败");
  756. }catch (\Exception $e){
  757. Db::rollback();
  758. return error_show(1004,$e->getMessage());
  759. }
  760. }
  761. public function changeRate(){
  762. $projectNo = isset($this->post['projectNo'])&&$this->post['projectNo']!==""?trim($this->post['projectNo']):"";
  763. if($projectNo==""){
  764. return error_show(1004,"参数projectNo不能为空");
  765. }
  766. $info =Db::name("project")->where(["projectNo"=>$projectNo,"is_del"=>0])->find();
  767. if($info==false){
  768. return error_show(1004,"未找到项目信息");
  769. }
  770. $rate = isset($this->post['rate'])&&$this->post['rate']!=="" ?floatval($this->post['rate']):"";
  771. if($rate===""){
  772. return error_show(1004,"参数rate不能为空");
  773. }
  774. $info['low_rate']=$rate;
  775. $info['updatetime']=date("Y-m-d H:i:s");
  776. $up =Db::name("project")->save($info);
  777. if($up){
  778. return app_show(0,"利润率修改成功");
  779. }else{
  780. return error_show(1004,"利润率修改失败");
  781. }
  782. }
  783. public function order(){
  784. $id = isset($this->post['id'])&& $this->post['id']!=="" ? intval($this->post['id']):"";
  785. if($id==""){
  786. return error_show(1004,"参数id不能为空");
  787. }
  788. $backinfo = Db::name("project_feedback")->where(["id"=>$id,"is_del"=>0])->find();
  789. if($backinfo==false){
  790. return error_show(1004,"未找到数据");
  791. }
  792. $prject = Db::name("project")->where(["projectNo"=>$backinfo['projectNo'],"is_del"=>0])->find();
  793. if($prject==false) {
  794. return error_show(1004, "未找到项目数据");
  795. }
  796. $send_type =isset($this->post['send_type'])&&$this->post['send_type']!=""? intval($this->post['send_type']):"";
  797. if($send_type==""){
  798. return error_show(1004,"参数send_type不能为空");
  799. }
  800. if($send_type==1){
  801. $va = isset($this->post['order_addr']) && $this->post['order_addr'] !== "" ? $this->post['order_addr'] : "";
  802. if ($va == "") {
  803. return error_show(1002, "参数order_addr不能为空");
  804. }
  805. }
  806. $plat = Db::name("platform")->where(["id"=>$prject['platform_id']])->find();
  807. $token = isset($this->post['token'])&& $this->post['token']!=="" ? trim($this->post['token']):"";
  808. if($token==""){
  809. return error_show(1004,"参数token不能为空");
  810. }
  811. $apply_id = GetUserInfo($token);
  812. if (empty($apply_id) || $apply_id['code'] != 0) {
  813. return error_show(1002, "申请人数据不存在");
  814. }
  815. $rm = isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  816. $ri = isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  817. $orderCode = makeNo("CX");
  818. Db::startTrans();
  819. try{
  820. $data = [
  821. "orderCode" => $orderCode,
  822. "good_code" => $backinfo['spuCode'],
  823. "customer_code" => $prject['khNo'],
  824. "good_name" => $backinfo['good_name'],
  825. "good_num" => $backinfo['num'],
  826. "order_type" =>3,
  827. "item_code"=>isset($plat['platform_code'])? $plat['platform_code']:"",
  828. "good_type"=>1,
  829. "apply_id" => $rm,
  830. "apply_name" => $ri,
  831. "origin_price" =>$backinfo['nake_price'],
  832. "sale_price" => $backinfo['sale_price'],
  833. "post_fee" => 0,
  834. "status" => 0,
  835. "supplierNo" =>$prject['companyNo'],
  836. "send_num" => 0,
  837. "zxNo"=>$backinfo['pgNo'],
  838. "wsend_num" => $backinfo['num'],
  839. "send_type" => $send_type,
  840. "send_status" => 1,
  841. "is_del" => 0,
  842. "addtime" => date("Y-m-d H:i:s"),
  843. "updatetime" => date("Y-m-d H:i:s"),
  844. 'total_price' => $backinfo['sale_price'] * $backinfo['num'],
  845. ];
  846. $datainfo = Db::name('sale')->insert($data, true);
  847. if($datainfo>0){
  848. if($send_type==1){
  849. foreach ($va as $value) {
  850. $temp = [];
  851. $addrs = [];
  852. if ($value['addr_code'] !== '' && is_array($value['addr_code'])) {
  853. $addrs['provice_code'] = $value['addr_code'][0];
  854. $addrs['city_code'] = $value['addr_code'][1];
  855. $addrs['area_code'] = $value['addr_code'][2];
  856. $addr = json_encode($addrs);
  857. } else {
  858. $addr = isset($value['addr_code']) ? $value['addr_code'] : '';
  859. }
  860. $temp['orderCode'] = $orderCode;
  861. $temp['contactor'] = $value['contactor'];
  862. $temp['mobile'] = $value['mobile'];
  863. $temp['addr'] = $value['addr'];
  864. $temp['addr_code'] = $addr;
  865. $temp['customer_code'] = $prject['khNo'];
  866. $temp['receipt_quantity'] = $value['receipt_quantity'];
  867. $temp['post_fee'] = 0;
  868. $temp['is_del'] = 0;
  869. $temp['addtime'] = date("Y-m-d H:i:s");
  870. $temp['updatetime'] = date("Y-m-d H:i:s");
  871. $temp['arrive_time'] = date("Y-m-d H:i:s");
  872. $vat[] = $temp;
  873. }
  874. $vmp = Db::name('order_addr')->insertAll($vat);
  875. if ($vmp==false) {
  876. Db::rollback();
  877. return error_show(1004, "销售订单创建失败");
  878. }
  879. }
  880. Db::commit();
  881. return error_show(0, "销售订单创建成功");
  882. }
  883. Db::rollback();
  884. return error_show(1004, "销售订单创建失败");
  885. }catch (\Exception $w){
  886. Db::rollback();
  887. return error_show(1004, $w->getMessage());
  888. }
  889. }
  890. public function feeddel(){
  891. $feedid = isset($this->post['id'])&&!empty($this->post['id']) ? $this->post['id'] :[];
  892. if(empty($feedid)){
  893. return error_show(1004,"参数feedid不能为空");
  894. }
  895. $selec = Db::name("project_feedback")->where(["id"=>$feedid,'is_del'=>0])->select();
  896. if(empty($selec)){
  897. return error_show(1004,"反馈数据信息未找到");
  898. }
  899. $up = Db::name("project_feedback")->where(["id"=>$feedid,'is_del'=>0])->save(["is_del"=>1,"updatetime"=>date("Y-m-d H:i:s")]);
  900. if($up){
  901. return app_show(0,"反馈数据删除成功");
  902. }else{
  903. return error_show(1004,"反馈数据删除失败");
  904. }
  905. }
  906. }