Project.php 58 KB

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