Version.php 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368
  1. <?php
  2. namespace app\admin\controller;
  3. use app\BaseController;
  4. use think\App;
  5. use think\facade\Db;
  6. class Version extends BaseController
  7. {
  8. public function __construct(App $app)
  9. {
  10. parent::__construct($app);
  11. $this->post = $this->request->post();
  12. }
  13. public function list(){
  14. $page = isset($this->post['page'])&&$this->post['page']!="" ? intval($this->post['page']) : 1;
  15. $size = isset($this->post['size'])&&$this->post['size']!="" ? intval($this->post['size']) :10;
  16. $count= Db::name("version")->count();
  17. $total = ceil($count/$size);
  18. $page = $page>=$total? $total:$page;
  19. $list = Db::name("version")->page($page,$size)->order("addtime desc")->select();
  20. return app_show(0,"获取成功",["list"=>$list,"count"=>$count]);
  21. }
  22. public function create(){
  23. $title = isset($this->post['title'])&&$this->post['title']!="" ? $this->post['title']:"";
  24. if($title==""){
  25. return error_show(1004,"参数title 不能为空");
  26. }
  27. $content = isset($this->post['content'])&&$this->post['content']!="" ? $this->post['content']:"";
  28. if($content==""){
  29. return error_show(1004,"参数content 不能为空");
  30. }
  31. $version = isset($this->post['version'])&&$this->post['version']!="" ? $this->post['version']:"";
  32. if($version==""){
  33. return error_show(1004,"参数version 不能为空");
  34. }
  35. $data=[
  36. "title"=>$title,
  37. "content"=>$content,
  38. "version"=>$version,
  39. "addtime"=>date("Y-m-d H:i:s")
  40. ];
  41. $inert= Db::name("version")->insert($data);
  42. if($inert){
  43. return app_show(0,"版本信息新建成功");
  44. }else{
  45. return app_show(0,"版本信息新建失败");
  46. }
  47. }
  48. public function info(){
  49. $projectNo = isset($this->post['projectNo'])&&$this->post['projectNo']!==""?trim($this->post['projectNo']):"";
  50. if($projectNo==""){
  51. return error_show(1004,"参数projectNo不能为空");
  52. }
  53. $type = isset($this->post['type'])&&$this->post['type']!=="" ? intval($this->post['type']) :0;
  54. $info =Db::name("project")->where(["projectNo"=>$projectNo,"is_del"=>0])->find();
  55. if($info==false){
  56. return error_show(1004,"未找到项目信息");
  57. }
  58. $plat = Db::name("platform")->where(['id'=>$info['platform_id']])->find();
  59. $info['platform_name']=isset($plat['platform_name'])?$plat['platform_name']:"";
  60. $info['platform_code']=isset($plat['platform_code'])?$plat['platform_code']:"";
  61. $khinfo = Db::name("customer_info")->where(["companyNo"=>$info['khNo']])->find();
  62. $info['khName'] = isset($khinfo['companyName'])?$khinfo['companyName']:"";
  63. $company = Db::name("business")->where(["companyNo"=>$info['companyNo']])->find();
  64. $info['company'] = isset($company['company'])?$company['company']:"";
  65. $ladder = Db::name("project_info")->where(['projectNo'=>$projectNo,"is_del"=>0])->select()->toArray();
  66. $info['ladder']=[];
  67. if(!empty($ladder)){
  68. foreach ($ladder as $value){
  69. $value["cat_info"]=isset($value['cat_id']) &&$value['cat_id']!=""? made($value['cat_id'],[]):[];
  70. $condition = $type==0?['pgNo'=>$value['pgNo'],"is_del"=>0] : ['pgNo'=>$value['pgNo'],"is_del"=>0,"status"=>1];
  71. $feedback = Db::name("project_feedback")->where($condition)->select()->toArray();
  72. array_walk($feedback,function (&$v){
  73. $v["cat_info"]=isset($v['cat_id'])&&$v['cat_id']!=""? made($v['cat_id'],[]):[];
  74. });
  75. $value['feedback']=$feedback;
  76. $info['ladder'][]=$value;
  77. }
  78. }
  79. return app_show(0,"获取成功",$info);
  80. }
  81. public function feedlist(){
  82. $page =isset($this->post['page'])&&$this->post['page']!=="" ? intval($this->post['page']):1;
  83. $size =isset($this->post['size'])&&$this->post['size']!==""? intval($this->post['size']):10;
  84. $where=[["is_del","=",0]];
  85. $pgNo =isset($this->post['pgNo'])&&$this->post['pgNo']!==""?trim($this->post['pgNo']):"";
  86. if($pgNo!==""){
  87. $where[]=["pgNo","=",$pgNo];
  88. }
  89. $projectNo =isset($this->post['projectNo'])&&$this->post['projectNo']!==""?trim($this->post['projectNo']):"";
  90. if($projectNo!==""){
  91. $where[]=["projectNo","=",$projectNo];
  92. }
  93. $source =isset($this->post['source'])&&$this->post['source']!==""?intval($this->post['source']):"";
  94. if($source!==""){
  95. $where[]=["data_source","=",$source];
  96. }
  97. $cat_id =isset($this->post['cat_id'])&&$this->post['cat_id']!==""?intval($this->post['cat_id']):"";
  98. if($cat_id!==""){
  99. $where[]=["cat_id","=",$cat_id];
  100. }
  101. $status =isset($this->post['status'])&&$this->post['status']!==""?intval($this->post['status']):"";
  102. if($status!==""){
  103. $where[]=["status","=",$status];
  104. }
  105. $count = Db::name('project_feedback')->where($where)->count();
  106. $total = ceil($count / $size);
  107. $page = $page >= $total ? $total : $page;
  108. $list = Db::name('project_feedback')->where($where)->page($page,$size)->order("addtime desc")->select();
  109. $data=[];
  110. foreach ($list as $value){
  111. $value['can']=isset($value['cat_id'])&&$value['cat_id']!=""?made($value['cat_id']):"";
  112. if($value['data_source']==1){
  113. $good=Db::name("good_platform")->alias("a")->leftJoin("good b","a.spuCode=b.spuCode")->where
  114. (["a.skuCode"=>$value['skuCode'],"a.is_del"=>0])->find();
  115. $nake = Db::name("good_nake")->where([["spuCode","=",$value['spuCode']],["min_num","<=",
  116. $value["num"]],["is_del","=",0]])->order("min_num desc")->find();
  117. $good['unit_id'] = isset($good['good_unit'])?$good['good_unit']:"";
  118. $good['cost_desc'] = isset($good['craft_desc'])?$good['craft_desc']:"";
  119. $good['pakge_fee'] = isset($nake['package_fee'])?$nake['package_fee']:"0";
  120. $good['mark_fee'] = isset($nake['mark_fee'])?$nake['mark_fee']:"0";
  121. $good['other_fee'] = isset($nake['other_fee'])?$nake['other_fee']:"0";
  122. $good['cert_fee'] = isset($nake['cert_fee'])?$nake['cert_fee']:"0";
  123. $good['delivery_fee'] = isset($nake['delivery_fee'])?$nake['delivery_fee']:"0";
  124. $good['nake_fee'] = isset($nake['nake_fee'])?$nake['nake_fee']:"0";
  125. $good['metal_id'] = isset($good['noble_metal'])?$good['noble_metal']:"0";
  126. $spec = Db::name("good_spec")->where(["spuCode"=>$good['spuCode'],"is_del"=>0])->select()->toArray();
  127. $good['specinfo']=[];
  128. if(!empty($spec)){
  129. foreach ($spec as $vae){
  130. $specs=Db::name("specs")->where(["id"=>$vae['spec_id']])->find();
  131. $spec_value = Db::name("spec_value")->where(["id"=>$vae["spec_value_id"]])->find();
  132. $temp = ["specid"=>$vae['spec_id'],"spec_name"=>$specs['spec_name'],"spec_value_id"=>$vae['spec_value_id'],"spec_value_name"=>$spec_value["spec_value"]];
  133. $good['specinfo'][]=$temp;
  134. }
  135. }
  136. $nake =Db::name("good_nake")->where(["spuCode"=>$good['spuCode'],"is_del"=>0])->where([["min_num","<=",$value['num']]])
  137. ->order("min_num desc")->find();
  138. $good['origin_price']=$nake['nake_total'];
  139. $good['work_day']=$good['lead_time'];
  140. $good_img = $good['good_thumb_img'];
  141. }else{
  142. $good=Db::name("consult_bids")->where(["spuCode"=>$value['spuCode'],"is_del"=>0])->find();
  143. $good['specinfo'] = isset($good['specinfo'])&&$good['specinfo']!=""?json_decode($good['specinfo'],
  144. true):"";
  145. $catinfo = Db::name("cat")->where(["id"=>$good['cat_id']])->find();
  146. $budget = isset($catinfo['order_rate']) ? $catinfo['order_rate']:100;
  147. $good_img = $good['good_img'];
  148. }
  149. $nobel =\think\facade\Config::get("noble");
  150. $value['good_name'] = isset($good['good_name'])?$good['good_name']:"";
  151. // $value['good_img'] = isset($good['good_img'])?$good['good_img']:"";
  152. $value['brand_id'] = isset($good['brand_id'])?$good['brand_id']:"";
  153. $brand = Db::name("brand")->where(['id'=>$value["brand_id"]])->find();
  154. $value['brand_name'] =isset($brand['brand_name']) ? $brand['brand_name']:"";
  155. $value['specinfo'] = isset($good['specinfo'])&&$good['specinfo']!=""?$good['specinfo']:[];
  156. $value['unit_id'] = isset($good['unit_id'])?$good['unit_id']:"";
  157. $unit = Db::name("unit")->where(['id'=>$value["unit_id"]])->find();
  158. $value["unit_name"]=isset($unit['unit'])?$unit['unit']:"";
  159. $value['cost_desc'] = isset($good['cost_desc'])?$good['cost_desc']:"";
  160. $value['work_day'] = isset($good['work_day'])?$good['work_day']:"";
  161. $value['delivery_day'] = isset($good['delivery_day'])?$good['delivery_day']:"";
  162. $value['expire_day'] = isset($good['expire_day'])?$good['expire_day']:"0";
  163. $value['good_img'] = $good_img;
  164. $value['expire_day'] = isset($good['expire_day'])?$good['expire_day']:"";
  165. $value['origin_place'] = isset($good['origin_place'])?$good['origin_place']:"";
  166. $value['supplierNo'] = isset($good['supplierNo'])?$good['supplierNo']:"";
  167. $value['pay_way'] = isset($good['pay_way'])?$good['pay_way']:"";
  168. $value['tax'] = isset($good['tax'])?$good['tax']:"";
  169. $value['send_way'] = isset($good['send_way'])?$good['send_way']:"";
  170. $value['metal_id'] = isset($good['metal_id'])?$good['metal_id']:"";
  171. $value['metal_name'] = isset($nobel[$good['metal_id']])?$nobel[$good['metal_id']]:"";
  172. $value['is_gold_price'] = isset($good['is_gold_price'])?$good['is_gold_price']:"0";
  173. $value['config'] = isset($good['config'])?$good['config']:"";
  174. $value['other_config'] = isset($good['other_config'])?$good['other_config']:"";
  175. $value['weight'] = isset($good['weight'])?$good['weight']:"";
  176. $value['is_diff'] = isset($good['is_diff'])?$good['is_diff']:"0";
  177. $value['demo_fee'] = isset($good['demo_fee'])?$good['demo_fee']:"0";
  178. $value['deivery_fee'] = isset($good['deivery_fee'])?$good['deivery_fee']:"0";
  179. $value['open_fee'] = isset($good['open_fee'])?$good['open_fee']:"0";
  180. $value['pakge_fee'] = isset($good['pakge_fee'])?$good['pakge_fee']:"0";
  181. $value['nake_fee'] = isset($good['nake_fee'])?$good['nake_fee']:"0";
  182. $value['mark_fee'] = isset($good['mark_fee'])?$good['mark_fee']:"0";
  183. $value['cert_fee'] = isset($good['cert_fee'])?$good['cert_fee']:"0";
  184. $value['cost_fee'] = isset($good['cost_fee'])?$good['cost_fee']:"0";
  185. $value['rate'] =round(($value['sale_price'] - $value['origin_price'])/$value['sale_price'] * 100,2);
  186. $value['supply_area'] = isset($good['supply_area'])?$good['supply_area']:"";
  187. $data[]=$value;
  188. }
  189. return app_show(0,"获取成功",['list'=>$data,'count'=>$count]);
  190. }
  191. public function project_plan(){
  192. $projectNo = isset($this->post['projectNo'])&&$this->post['projectNo']!==""?trim($this->post['projectNo']):"";
  193. if($projectNo==""){
  194. return error_show(1004,"参数projectNo不能为空");
  195. }
  196. $type = isset($this->post['type'])&&$this->post['type']!=="" ? intval($this->post['type']) :0;
  197. $info =Db::name("project")->where(["projectNo"=>$projectNo,"is_del"=>0])->find();
  198. if($info==false){
  199. return error_show(1004,"未找到项目信息");
  200. }
  201. $plat = Db::name("platform")->where(['id'=>$info['platform_id']])->find();
  202. $info['platform_name']=isset($plat['platform_name'])?$plat['platform_name']:"";
  203. $info['platform_code']=isset($plat['platform_code'])?$plat['platform_code']:"";
  204. $khinfo = Db::name("customer_info")->where(["companyNo"=>$info['khNo']])->find();
  205. $info['khName'] = isset($khinfo['companyName'])?$khinfo['companyName']:"";
  206. if($type==1){
  207. $where = ['projectNo'=>$projectNo,"is_del"=>0,"status"=>1];
  208. }else{
  209. $where = ['projectNo'=>$projectNo,"is_del"=>0];
  210. }
  211. $ladder = Db::name("project_plan")->where($where)->order("addtime desc")->select()->toArray();
  212. $info=[];
  213. if(!empty($ladder)){
  214. foreach ($ladder as $value){
  215. $value['feedback']=[];
  216. $feedback =Db::name("project_plan_rela")->where(["planNo"=>$value['planNo'],"is_del"=>0])->column("feedback_id,sale_price,sale_num");
  217. if(!empty($feedback)){
  218. $feedid = array_column($feedback,"feedback_id");
  219. $feedlist = Db::name("project_feedback")->where(["id"=>$feedid,"is_del"=>0])->select();
  220. if(!empty($feedlist)){
  221. foreach ($feedlist as $val){
  222. $key =array_search($val['id'],$feedid);
  223. $price = $feedback[$key]['sale_price'];
  224. $val["cat_info"]=isset($val['cat_id'])&&$val['cat_id']!=""? made($val['cat_id'],[]):[];
  225. $val["sale_price"]=$price;
  226. $val["origin_num"]=$val['num'];
  227. $val["num"]=$feedback[$key]['sale_num'];
  228. if($val['data_source']!=1){
  229. $good=Db::name("consult_bids")->where(["spuCode"=>$val['spuCode'],"is_del"=>0])->find();
  230. $good['specinfo']=isset($good['specinfo'])&&$good['specinfo']!=""?json_decode($good['specinfo'],true):[];
  231. }else{
  232. $good=Db::name("good")->where(["spuCode"=>$val['spuCode'],"is_del"=>0])->find();
  233. $spec = Db::name("good_spec")->where(["spuCode"=>$val['spuCode'],"is_del"=>0])->select()->toArray();
  234. $good['specinfo']=[];
  235. if(!empty($spec)){
  236. foreach ($spec as $vae){
  237. $specs=Db::name("specs")->where(["id"=>$vae['spec_id']])->find();
  238. $spec_value = Db::name("spec_value")->where(["id"=>$vae["spec_value_id"]])->find();
  239. $temp = ["specid"=>$vae['spec_id'],"spec_name"=>$specs['spec_name'],"spec_value_id"=>$vae['spec_value_id'],"spec_value_name"=>$spec_value["spec_value"]];
  240. $good['specinfo'][]=$temp;
  241. }
  242. }
  243. }
  244. if(isset($good['brand_id'])){
  245. $brand =Db::name("brand")->where(["id"=>$good['brand_id']])->find();
  246. }
  247. $val['good_img']=isset($good['good_img'])&&$good['good_img']!=""?trim($good['good_img']):"";
  248. $val['brand_id']=isset($good['brand_id'])&&$good['brand_id']!=""?$good['brand_id']:"";
  249. $val['brand_name']=isset($brand['brand_name'])&&$brand['brand_name']!=""?$brand['brand_name']:"";
  250. $val['specinfo']=isset($good['specinfo'])&&$good['specinfo']!=""?$good['specinfo']:[];
  251. $value['feedback'][]=$val;
  252. }
  253. }
  254. }
  255. $info[]=$value;
  256. }
  257. }
  258. return app_show(0,"获取成功",$info);
  259. }
  260. public function feedCheck(){
  261. $feedid = isset($this->post['feedid'])&&!empty($this->post['feedid']) ? $this->post['feedid'] :[];
  262. if(empty($feedid)){
  263. return error_show(1004,"参数feedid不能为空");
  264. }
  265. $feedid=array_unique($feedid);
  266. $selec = Db::name("project_feedback")->where(["id"=>$feedid,'is_del'=>0,"status"=>0])->select()->toArray();
  267. if(empty($selec)){
  268. return error_show(1004,"反馈数据信息未找到");
  269. }
  270. $pgnos =array_column($selec,"pgNo");
  271. $infolist = Db::name("project_info")->where(['pgNo'=>$pgnos])->select()->toArray();
  272. if(empty($infolist)){
  273. return error_show(1004,"项目商品数据未找到");
  274. }
  275. Db::startTrans();
  276. try{
  277. $up = Db::name("project_feedback")->where(["id"=>$feedid,'is_del'=>0,"status"=>0])->save(["status"=>1,"updatetime"=>date("Y-m-d H:i:s")]);
  278. if($up){
  279. foreach ($infolist as $value){
  280. $value['status']=3;
  281. $value['updatetime']=date("Y-m-d H:i:s");
  282. $up = Db::name("project_info")->save($value);
  283. if($up){
  284. $count = Db::name("project_info")->where(["projectNo"=>$value['projectNo'],"status"=>2])
  285. ->count();
  286. if($count==0){
  287. $proc =Db::name("project")->where(["projectNo"=>$value['projectNo']])->save
  288. (["status"=>3,"updatetime"=>date("Y-m-d H:i:s")]);
  289. if(!$proc){
  290. Db::rollback();
  291. return error_show(1004,"反馈数据选择失败");
  292. }
  293. }
  294. }else{
  295. Db::rollback();
  296. return error_show(1004,"反馈数据选择失败");
  297. }
  298. }
  299. Db::commit();
  300. return app_show(0,"反馈数据选择成功");
  301. }else{
  302. Db::rollback();
  303. return error_show(1004,"反馈数据选择失败");
  304. }
  305. }catch (\Exception $e){
  306. Db::rollback();
  307. return error_show(1004,$e->getMessage());
  308. }
  309. }
  310. public function planCheck(){
  311. $planNos = isset($this->post['planNos'])&&!empty($this->post['planNos'])? $this->post['planNos'] :"";
  312. if($planNos==""){
  313. return error_show(1004,"参数planNos不能为空");
  314. }
  315. $status=isset($this->post['status'])&&$this->post['status']!=="" ? intval($this->post['status']):"";
  316. if($status==""){
  317. return error_show(1004,"参数status不能为空");
  318. }
  319. $selec = Db::name("project_plan")->where(["planNo"=>$planNos,'is_del'=>0,"status"=>0])->select()->toArray();
  320. if(empty($selec)){
  321. return error_show(1004,"项目方案数据信息未找到");
  322. }
  323. Db::startTrans();
  324. try{
  325. $up = Db::name("project_plan")->where(["planNo"=>$planNos,'is_del'=>0,"status"=>0])->save(["status"=>1,"updatetime"=>date("Y-m-d H:i:s")]);
  326. if($up) {
  327. $project = array_column($selec, "projectNo");
  328. if (empty($project)) {
  329. Db::rollback();
  330. return error_show(1004, "方案选择失败");
  331. }
  332. $pro = Db::name("project")->where(["projectNo" => $project, "status" => 4])->save(["status" => 5, "updatetime" => date("Y-m-d H:i:s")]);
  333. if ($pro) {
  334. Db::commit();
  335. return app_show(0, "方案数据修改成功");
  336. }
  337. }
  338. Db::rollback();
  339. return error_show(1004,"方案选择失败");
  340. }catch (\Exception $e){
  341. Db::rollback();
  342. return error_show(1004,$e->getMessage());
  343. }
  344. }
  345. }