Project.php 60 KB

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