Consult.php 126 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375
  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. use think\facade\Validate;
  8. //竞价单(咨询单)
  9. class Consult extends Base
  10. {
  11. public $noble=[];
  12. public function __construct(App $app)
  13. {
  14. parent::__construct($app);
  15. $this->noble =\think\facade\Config::get("noble");
  16. }
  17. public function conlist(){
  18. $page = isset($this->post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) :"1";
  19. $size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) :"10";
  20. $where=[['a.is_del',"=",0],['b.is_del',"=",0]];
  21. $infoNo = isset($this->post['zxNo']) && $this->post['zxNo'] !== "" ? trim($this->post['zxNo']) : "";
  22. if ($infoNo !== "") {
  23. $where[] = ['a.infoNo','like','%'.$infoNo.'%'];
  24. }
  25. $salesman = isset($this->post['salesman']) && $this->post['salesman'] !== "" ? trim($this->post['salesman']) : "";
  26. if ($salesman !== "") {
  27. //$where["salesman"] =Db::Raw("like '%$salesman%'");
  28. $where[]= ["b.salesman",'like',"%$salesman%"];
  29. }
  30. $cpName = isset($this->post['cpName']) && $this->post['cpName'] !== "" ? trim($this->post['cpName']) : "";
  31. if ($cpName !== "") {
  32. //$where["cpName"]= Db::Raw("like '%$cpName%'");
  33. $where[]= ["a.good_Name",'like',"%$cpName%"];
  34. }
  35. $khNo = isset($this->post['khNo']) && $this->post['khNo'] !== "" ? trim($this->post['khNo']) : "";
  36. if ($khNo !== "") {
  37. // $where['khNo'] = $khNo;
  38. $where[]= ["b.khNo",'like',"%$khNo%"];
  39. }
  40. $companyNo = isset($this->post['companyNo']) && $this->post['companyNo'] !== "" ? trim($this->post['companyNo']) : "";
  41. if ($companyNo !== "") {
  42. // $where['khNo'] = $khNo;
  43. $where[]= ["b.companyNo",'like',"%$companyNo%"];
  44. }
  45. $start= isset($this->post['start']) && $this->post['start'] !== "" ? $this->post['start']:"";
  46. if ($start !="") {
  47. //$where = ["zxtime"=>Db::raw(">= '{$start}'")];
  48. $where[]= ["a.addtime",'>=',$start];
  49. }
  50. $end = isset($this->post['end']) && $this->post['end'] !== "" ? $this->post['end'] :"";
  51. if($end !=""){
  52. $where[]= ["a.addtime",'<=',$end];
  53. }
  54. $status = isset($this->post['status']) && $this->post['status'] !== "" ? trim($this->post['status']) : "";
  55. if ($status !== "") {
  56. $where[]= ["a.status",'=',$status];
  57. }
  58. $company_name = isset($this->post['company_name']) && $this->post['company_name'] !== "" ? trim($this->post['company_name']) : "";
  59. if ($company_name !== "") $where[] = ["b.createrid", 'in', get_company_item_user_by_name($company_name)];
  60. $role=$this->checkRole();
  61. if(!empty($role['write'])){
  62. $where[]=["b.createrid","in",$role['write']];
  63. }
  64. // if(!empty($role['platform']) ){
  65. // $where[]=["b.platform_code","in",$role['platform']];
  66. // }
  67. $count = Db::name('consult_info')->alias("a")->leftJoin("consult_order b","a.zxNo=b.zxNo")->where($where)
  68. ->count();
  69. $total = ceil($count / $size);
  70. $page = $page >= $total ? $total : $page;
  71. $list = Db::name('consult_info')
  72. ->alias("a")
  73. ->leftJoin("consult_order b", "a.zxNo=b.zxNo")
  74. ->leftJoin("depart_user u", "u.uid=b.createrid AND u.is_del=0")
  75. ->where($where)
  76. ->page($page, $size)
  77. ->field("a.*,b.createrid,b.creater,b.is_project,b.projectNo,b.khNo,b.endtime,b.platform_code,b.saleid,b.salesman,b.depart,u.itemid")
  78. ->order("a.id desc")
  79. ->cursor();
  80. $data=[];
  81. foreach ($list as $value){
  82. $value['can']= isset($value['cat_id']) && $value['cat_id'] !=0 ? made($value['cat_id']):[];
  83. $value['specinfo']=isset($value['specinfo'])&&$value['specinfo']!=""? json_decode($value['specinfo'],
  84. true):[];
  85. $brand = Db::name("brand")->where(['id'=>$value['brand_id']])->find();
  86. $value['brand_name']= isset($brand['brand_name']) && $brand['brand_name']!='' ? $brand['brand_name']:"";
  87. $value['khname']="";
  88. if($value['khNo']!==""){
  89. $kh=Db::name("customer_info")->where(['companyNo'=>$value['khNo']])->find();
  90. $value['khname']= isset($kh['companyName'])?$kh['companyName']:"";
  91. }
  92. $value['metal_name']=isset($value['metal_id'])&& $value['metal_id']!=0?$this->noble[$value['metal_id']]:"";
  93. $value['company_name'] = implode('/', array_column(GetPart($value['itemid']), 'name'));
  94. $data[]=$value;
  95. }
  96. return app_show(0,"获取成功",['count'=>$count,'list'=>$data]);
  97. }
  98. public function info(){
  99. $id = isset($this->post['id']) && $this->post['id'] !=="" ? intval($this->post['id']) : "";
  100. if($id==""){
  101. return error_show(1002,"咨询单编号不能为空");
  102. }
  103. $fo = Db::name('consult')->where(['id'=>$id,'is_del'=>0])->find();
  104. $in= isset($fo['cat_id']) && $fo['cat_id'] !=0 ? made($fo['cat_id']):[];
  105. $fo['can']=$in;
  106. if(empty($fo)){
  107. return error_show(1002,"未找到咨询单编号");
  108. }else{
  109. return app_show(0,"获取成功",$fo);
  110. }
  111. }
  112. public function del(){
  113. $id = isset($this->post['id']) && $this->post['id'] !=="" ? intval($this->post['id']) : "";
  114. $de = Db::name('consult')->where(['id'=>$id,'is_del'=>0])->find();
  115. if($de==false){
  116. return error_show(1002,'咨询单信息未找到');
  117. }
  118. $dell= Db::name('consult')->update(['id'=>$id,'is_del'=>1,'updatetime'=>date("Y-m-d H:i:s")]);
  119. if($dell){
  120. return error_show(0,"删除成功");
  121. }else
  122. return error_show(1002,"删除失败");
  123. }
  124. public function create(){
  125. $is_project= isset($this->post['is_project']) && $this->post['is_project'] !=="" ? intval($this->post['is_project']) : "";
  126. if($is_project===""){
  127. return error_show(1002,"参数is_project不能为空");
  128. }
  129. if($is_project==1){
  130. $projectNo= isset($this->post['projectNo']) && $this->post['projectNo'] !=="" ? trim($this->post['projectNo']) : "";
  131. if($projectNo===""){
  132. return error_show(1002,"参数projectNo不能为空");
  133. }
  134. }
  135. $khNo = isset($this->post['khNo']) && $this->post['khNo'] !=="" ? trim($this->post['khNo']) : "";
  136. if($khNo===""){
  137. return error_show(1002,"参数khNo不能为空");
  138. }
  139. $companyNo = isset($this->post['companyNo']) && $this->post['companyNo'] !=="" ? trim($this->post['companyNo']) : "";
  140. if($companyNo===""){
  141. return error_show(1002,"参数companyNo不能为空");
  142. }
  143. $endtime = isset($this->post['endtime']) && $this->post['endtime'] !=="" ? $this->post['endtime'] : "";
  144. if($endtime===""){
  145. return error_show(1002,"参数endtime不能为空");
  146. }
  147. $platform_code = isset($this->post['platform_code']) && $this->post['platform_code'] !=="" ? trim($this->post['platform_code']) :
  148. "";
  149. if($platform_code===""){
  150. return error_show(1002,"参数platform_code不能为空");
  151. }
  152. $ladder = isset($this->post['ladder'])&&!empty($this->post['ladder']) ? $this->post['ladder']:"";
  153. if($ladder==""){
  154. return error_show(1005,"参数ladder不能为空");
  155. }
  156. $token = isset($this->post['token'])&& $this->post['token']!='' ? trim($this->post['token']):"";
  157. if($token==''){
  158. return error_show(105,"参数token不能为空");
  159. }
  160. $user =GetUserInfo($token);
  161. if(empty($user)||$user['code']!=0){
  162. return error_show(102,"用户数据不存在");
  163. }
  164. $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  165. $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  166. $depart= Db::name("depart_user")->where(["uid"=>$createrid,"status"=>1,"is_del"=>0])->find();
  167. $zxNo=makeNo("ZX");
  168. Db::startTrans();
  169. try{
  170. $data=[
  171. "zxNo"=>$zxNo,
  172. "createrid"=>$createrid,
  173. "creater"=>$creater,
  174. "is_project"=>$is_project,
  175. "projectNo"=>isset($projectNo) ? $projectNo:"",
  176. "khNo"=>$khNo,
  177. "companyNo"=>$companyNo,
  178. "endtime"=>$endtime,
  179. "salesman"=>$creater,
  180. "platform_code"=>$platform_code,
  181. "saleid"=>$createrid,
  182. "depart"=>isset($depart['itemid'])?$depart['itemid']:0,
  183. "status"=>0,
  184. "is_del"=>0,
  185. "addtime"=>date("Y-m-d H:i:s"),
  186. "updatetime"=>date("Y-m-d H:i:s"),
  187. ];
  188. $zx = Db::name("consult_order")->insert($data);
  189. if($zx){
  190. //判断是否是项目,且该项目是否存在台账记录中
  191. if($is_project==1) $stand_exists=Db::name('standing_book')->field('id')->where('projectNo',$projectNo)->find();
  192. foreach ($ladder as $value){
  193. $infoNo=makeNo("IF");
  194. $specinfo=[];
  195. if(isset($value['specinfo']) &&!empty($value['specinfo'])){
  196. foreach ($value["specinfo"] as $v){
  197. $spec =Db::name("specs")->where(["id"=>$v['specid']])->find();
  198. $spec_value =Db::name("spec_value")->where(["id"=>$v['spec_value_id']])->find();
  199. $v['spec_name']=isset($spec['spec_name'])? $spec['spec_name']:"";
  200. $v['spec_value_name']=isset($spec_value['spec_value'])?$spec_value['spec_value']:"" ;
  201. $specinfo[]=$v;
  202. }
  203. }
  204. $info=[
  205. "infoNo"=>$infoNo,
  206. "zxNo"=>$zxNo,
  207. "spuCode"=>"",
  208. "good_name"=>$value['good_name'],
  209. "good_img"=>$value['good_img'],
  210. "cat_id"=>$value['cat_id'],
  211. "unit"=>$value['unit'],
  212. "brand_id"=>$value['brand_id'],
  213. "arrival_time"=>$value['arrival_time'],
  214. "specinfo"=>empty($specinfo)?"" : json_encode($specinfo),
  215. "cost_desc" => isset($value['cost_desc']) ? $value['cost_desc'] : '',
  216. "is_addrs"=>$value['is_addrs'],
  217. "is_custom"=>$value['is_custom'],
  218. "metal_id"=>$value['metal_id'],
  219. "config"=>isset($value['config'])?$value['config']:"",
  220. "other_config"=>isset($value['other_config'])?$value['other_config']:"",
  221. "specs_weight"=>isset($value['specs_weight'])?$value['specs_weight']:"0",
  222. "gold_price"=>isset($value['gold_price'])?$value['gold_price']:"0",
  223. "is_gold_price"=>isset($value['is_gold_price'])?$value['is_gold_price']:"0",
  224. "total_weight"=>isset($value['total_weight'])?$value['total_weight']:"0",
  225. "budget_price"=>$value['budget_price'],
  226. "num"=>$value['num'],
  227. "pgNo"=>isset($value['pgNo'])&&$value['pgNo']!==""?trim($value['pgNo']):"",
  228. "use_desc"=>$value['use_desc'],
  229. "remark"=>$value['remark'],
  230. "status"=>1,
  231. "is_del"=>0,
  232. "addtime"=>date("Y-m-d H:i:s"),
  233. "updatetime"=>date("Y-m-d H:i:s"),
  234. 'enclosure_file'=>isset($value['enclosure_file'])?$value['enclosure_file']:'',
  235. ];
  236. $up = Db::name("consult_info")->insertGetId($info);
  237. if(!$up){
  238. Db::rollback();
  239. return error_show(1004,'添加失败');
  240. }else{
  241. //修改状态
  242. ActionLog::logAdd(['id' => $createrid, 'nickname' => $creater], [
  243. "order_code" => $infoNo,//咨询单详情编号
  244. "status" => 1,//这里的status是之前的值
  245. "action_remark" => '',//备注
  246. "action_type" => "create"//新建create,编辑edit,更改状态status
  247. ], "ZXD", 1, $info);
  248. //竞价单不走流程,不推待办已办
  249. // ProcessOrder::AddProcess(['id' => $createrid, 'nickname' => $creater], [
  250. // "order_type" => 'ZXD',
  251. // "order_code" => $infoNo,//咨询单详情编号
  252. // "order_id" => $up,
  253. // "order_status" => 1,
  254. // 'before_status'=>0
  255. // ]);
  256. //如果存在该项目编码,更新对应的第一个竞价单编码,其他竞价单编码新增(带着项目编码)
  257. if (isset($stand_exists)) {
  258. Db::name('standing_book')
  259. ->where('id', $stand_exists['id'])
  260. ->update([
  261. 'infoNo' => $infoNo,
  262. 'updatetime' => date('Y-m-d H:i:s')
  263. ]);
  264. unset($stand_exists);//后面的竞价单编码不用更新,都是新增
  265. } else {
  266. //添加台账信息
  267. Db::name('standing_book')
  268. ->insert([
  269. 'standBookNo' => makeNo("IO"),
  270. 'projectNo' => isset($projectNo) ? $projectNo : '',
  271. 'infoNo' => $infoNo,
  272. 'companyNo' => $companyNo,
  273. 'customer_code' => $khNo,
  274. 'addtime' => date('Y-m-d H:i:s'),
  275. 'updatetime' => date('Y-m-d H:i:s')
  276. ]);
  277. }
  278. }
  279. }
  280. Db::commit();
  281. return app_show(0,"新建成功",["zxNo"=>$zxNo]);
  282. }else{
  283. Db::rollback();
  284. return error_show(1004,"新建失败");
  285. }
  286. }catch (\Exception $e){
  287. Db::rollback();
  288. return error_show(1003,$e->getMessage());
  289. }
  290. }
  291. public function zxinfo(){
  292. $infoNo= isset($this->post['infoNo'])&&$this->post['infoNo']!=""?trim($this->post['infoNo']):"";
  293. if($infoNo==""){
  294. return error_show(1004,"参数infoNo不能为空");
  295. }
  296. $zxinfo = Db::name("consult_info")->where(["infoNo"=>$infoNo,"is_del"=>0])->find();
  297. if($zxinfo==false){
  298. return error_show(1004,"未找到信息数据");
  299. }
  300. $zxorder = Db::name("consult_order")->where(["zxNo"=>$zxinfo['zxNo'],"is_del"=>0])->find();
  301. if($zxorder==false){
  302. return error_show(1004,"未找到咨询信息数据");
  303. }
  304. $cat =Db::name("cat")->where(["id"=>$zxinfo['cat_id']])->find();
  305. $budget = isset($cat['order_rate']) ? $cat['order_rate']:0;
  306. $zxinfo['can']= isset($zxinfo['cat_id']) && $zxinfo['cat_id'] !=0 ? made($zxinfo['cat_id'],[]):[];
  307. $zxinfo['khname']="";
  308. $zxinfo['original_price']=sprintf("%.2f",$zxinfo['budget_price']* (1 -$budget/100));
  309. $zxinfo['khNo']="";
  310. $zxinfo['brand_id']=$zxinfo['brand_id']==0 ?"":$zxinfo['brand_id'];
  311. $zxinfo['brand']="";
  312. $zxinfo['companyNo']=isset($zxorder['companyNo'])?$zxorder['companyNo']:"";
  313. $zxinfo['projectNo']=isset($zxorder['projectNo'])?$zxorder['projectNo']:"";
  314. $zxinfo['is_project']=isset($zxorder['is_project'])?$zxorder['is_project']:"";
  315. $zxinfo['company']="";
  316. $zxinfo['endtime']=isset($zxorder['endtime'])?$zxorder['endtime']:"";
  317. $zxinfo['platform_code'] =isset($zxorder['platform_code'])?$zxorder['platform_code']:"";
  318. $zxinfo['salesman'] =isset($zxorder['salesman'])?$zxorder['salesman']:"";
  319. $zxinfo['saleid'] =isset($zxorder['saleid'])?$zxorder['saleid']:"";
  320. $zxinfo['depart'] =isset($zxorder['depart'])?$zxorder['depart']:"";
  321. $zxinfo['project_name']="";
  322. $zxinfo['budget_total']="";
  323. $zxinfo['departinfo']=[];
  324. $zxinfo['unit_name']="";
  325. $zxinfo['metal_name']=isset($zxinfo['metal_id'])&& $zxinfo['metal_id']!=0?$this->noble[$zxinfo['metal_id']]:"";
  326. $zxinfo['specinfo']=json_decode($zxinfo['specinfo'],true);
  327. if($zxorder['khNo']!==""){
  328. $kh=Db::name("customer_info")->where(['companyNo'=>$zxorder['khNo']])->find();
  329. $zxinfo['khname']= isset($kh['companyName'])?$kh['companyName']:"";
  330. $zxinfo['khNo']= $zxorder['khNo'];
  331. }
  332. if($zxinfo['unit']!==""){
  333. $unit=Db::name("unit")->where(['id'=>$zxinfo['unit']])->find();
  334. $zxinfo['unit_name']= isset($unit['unit'])?$unit['unit']:"";
  335. }
  336. if($zxinfo['brand_id']!==""){
  337. $unit=Db::name("brand")->where(['id'=>$zxinfo['brand_id']])->find();
  338. $zxinfo['brand']= isset($unit['brand_name'])?$unit['brand_name']:"";
  339. }
  340. if($zxorder['companyNo']!==""){
  341. $kh=Db::name("business")->where(['companyNo'=>$zxorder['companyNo']])->find();
  342. $zxinfo['company']= isset($kh['company'])?$kh['company']:"";
  343. }
  344. if($zxorder['is_project']==1 && $zxorder['projectNo']!==""){
  345. $project = Db::name("project")->where(["projectNo"=>$zxorder['projectNo'],"is_del"=>0])->find();
  346. $zxinfo['project_name']=isset($project['project_name'])?$project['project_name']:"";
  347. $zxinfo['budget_total']=isset($project['budget_total'])?$project['budget_total']:"";
  348. $zxinfo['project_use_desc']=isset($project['use_desc'])?$project['use_desc']:"";
  349. $projectinfo = Db::name("project_info")->where(["pgNo"=>$zxinfo['pgNo']])->find();
  350. $zxinfo['pgNo'] = isset($projectinfo['pgNo']) ? $projectinfo['pgNo']:"";
  351. }
  352. if($zxorder['depart']>0){
  353. $zxinfo['departinfo']=GetPart($zxorder['depart']);
  354. }
  355. if($zxorder['platform_code']>0){
  356. $palt=Db::name("platform")->where(["id"=>$zxorder['platform_code']])->find();
  357. $zxinfo['platform_name']=isset($palt['platform_name'])?$palt['platform_name']:"";
  358. }
  359. return app_show(0,"获取成功",$zxinfo);
  360. }
  361. public function zxedit(){
  362. $infoNo= isset($this->post['infoNo'])&&$this->post['infoNo']!=""?trim($this->post['infoNo']):"";
  363. if($infoNo==""){
  364. return error_show(1004,"参数infoNo不能为空");
  365. }
  366. $zxinfo = Db::name("consult_info")->where(["infoNo"=>$infoNo,"is_del"=>0])->find();
  367. if($zxinfo==false){
  368. return error_show(1004,"未找到信息数据");
  369. }
  370. $enclosure_file =isset($this->post['enclosure_file'])&&$this->post['enclosure_file']!=""?trim($this->post['enclosure_file']):$zxinfo['enclosure_file'];
  371. $good_name= isset($this->post['good_name'])&&$this->post['good_name']!=""?trim($this->post['good_name']):"";
  372. if($good_name==""){
  373. return error_show(1003,"参数good_name不能为空");
  374. }
  375. $good_img= isset($this->post['good_img'])&&$this->post['good_img']!=""?trim($this->post['good_img']):"";
  376. if($good_img==""){
  377. return error_show(1003,"参数good_img不能为空");
  378. }
  379. $cat_id= isset($this->post['cat_id'])&&$this->post['cat_id']!=""?intval($this->post['cat_id']):"";
  380. if($cat_id==""){
  381. return error_show(1003,"参数cat_id不能为空");
  382. }
  383. $unit= isset($this->post['unit'])&&$this->post['unit']!=""?trim($this->post['unit']):"";
  384. if($unit==""){
  385. return error_show(1003,"参数unit不能为空");
  386. }
  387. $brand_id= isset($this->post['brand_id'])&&$this->post['brand_id']!==""?intval($this->post['brand_id']):"0";
  388. $arrival_time= isset($this->post['arrival_time'])&&$this->post['arrival_time']!=""?$this->post['arrival_time']:"";
  389. if($arrival_time==""){
  390. return error_show(1003,"参数arrival_time不能为空");
  391. }
  392. $specin= isset($this->post['specinfo'])&&!empty($this->post['specinfo'])?$this->post['specinfo']:"";
  393. if($specin==""){
  394. return error_show(1003,"参数specinfo不能为空");
  395. }
  396. $cost_desc= isset($this->post['cost_desc'])&&$this->post['cost_desc']!=""?trim($this->post['cost_desc']):"";
  397. // if($cost_desc==""){
  398. // return error_show(1003,"参数cost_desc不能为空");
  399. // }
  400. $is_addrs= isset($this->post['is_addrs'])&&$this->post['is_addrs']!==""?intval($this->post['is_addrs']):"";
  401. if($is_addrs===""){
  402. return error_show(1003,"参数is_addrs不能为空");
  403. }
  404. $is_custom= isset($this->post['is_custom'])&&$this->post['is_custom']!==""?trim($this->post['is_custom']):"";
  405. if($is_custom===""){
  406. return error_show(1003,"参数is_custom不能为空");
  407. }
  408. $metal_id= isset($this->post['metal_id'])&&$this->post['metal_id']!==""?intval($this->post['metal_id']):"";
  409. if($metal_id===""){
  410. return error_show(1003,"参数metal_id不能为空");
  411. }
  412. $config = isset($this->post['config'])&& $this->post['config']!=""?trim($this->post['config']):"";
  413. $other_config = isset($this->post['other_config'])&& $this->post['other_config']!=""?trim($this->post['other_config']):"";
  414. $specs_weight = isset($this->post['specs_weight'])&& $this->post['specs_weight']!==""?floatval($this->post['specs_weight']):"";
  415. $gold_price = isset($this->post['gold_price'])&& $this->post['gold_price']!==""?floatval($this->post['gold_price']):"";
  416. $is_gold_price = isset($this->post['is_gold_price'])&& $this->post['is_gold_price']!==""?intval($this->post['is_gold_price']):"0";
  417. $budget_price = isset($this->post['budget_price'])&& $this->post['budget_price']!==""?floatval($this->post['budget_price']):"";
  418. $total_weight = isset($this->post['total_weight'])&& $this->post['total_weight']!==""?floatval($this->post['total_weight']):"";
  419. $num = isset($this->post['num'])&& $this->post['num']!==""?intval($this->post['num']):"";
  420. if($num===""){
  421. return error_show(1003,"参数num不能为空");
  422. }
  423. if($budget_price===""){
  424. return error_show(1003,"参数budget_price不能为空");
  425. }
  426. $pgNo = isset($this->post['pgNo'])&& $this->post['pgNo']!="" ? trim($this->post['pgNo']):"";
  427. $use_desc = isset($this->post['use_desc'])&& $this->post['use_desc']!="" ? trim($this->post['use_desc']):"";
  428. if($use_desc==""){
  429. return error_show(1003,"参数use_desc不能为空");
  430. }
  431. $remark = isset($this->post['remark'])&& $this->post['remark']!="" ? trim($this->post['remark']):"";
  432. if($remark==""){
  433. return error_show(1003,"参数remark不能为空");
  434. }
  435. $endtime = isset($this->post['endtime'])&& $this->post['endtime']!="" ? trim($this->post['endtime']):"";
  436. if($endtime==""){
  437. return error_show(1003,"参数endtime不能为空");
  438. }
  439. if($metal_id!=0){
  440. if($config==""){
  441. return error_show(1003,"参数config不能为空");
  442. }
  443. if($other_config==""){
  444. return error_show(1003,"参数other_config不能为空");
  445. }
  446. if($specs_weight===""){
  447. return error_show(1003,"参数specs_weight不能为空");
  448. }
  449. if($gold_price===""){
  450. return error_show(1003,"参数gold_price不能为空");
  451. }
  452. }
  453. $token = isset($this->post['token'])&& $this->post['token']!='' ? trim($this->post['token']):"";
  454. if($token==''){
  455. return error_show(102,"参数token不能为空");
  456. }
  457. $user =GetUserInfo($token);
  458. if(empty($user)||$user['code']!=0){
  459. return error_show(105,"用户数据不存在");
  460. }
  461. $specinfo=[];
  462. foreach ($specin as $v){
  463. $spec =Db::name("specs")->where(["id"=>$v['specid']])->find();
  464. $spec_value =Db::name("spec_value")->where(["id"=>$v['spec_value_id']])->find();
  465. $v['spec_name']=isset($spec['spec_name'])?$spec['spec_name']:"";
  466. $v['spec_value_name']=isset($spec_value['spec_value'])?$spec_value['spec_value']:"";
  467. $specinfo[]=$v;
  468. }
  469. $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  470. $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  471. $bidlist = Db::name("consult_bids")->where(["infoNo"=>$zxinfo['infoNo'],"is_del"=>0])->select();
  472. Db::startTrans();
  473. try{
  474. $innew =makeNo("IF");
  475. $info=[
  476. "infoNo"=>$innew,
  477. "zxNo"=>$zxinfo['zxNo'],
  478. "spuCode"=>"",
  479. "good_name"=>$good_name,
  480. "good_img"=>$good_img,
  481. "cat_id"=>$cat_id,
  482. "unit"=>$unit,
  483. "brand_id"=>$brand_id,
  484. "arrival_time"=>$arrival_time,
  485. "specinfo"=>json_encode($specinfo),
  486. // "color"=>$color,
  487. // "material"=>$material,
  488. "cost_desc"=>$cost_desc,
  489. "is_addrs"=>$is_addrs,
  490. "is_custom"=>$is_custom,
  491. "metal_id"=>$metal_id,
  492. "config"=>$config,
  493. "other_config"=>$other_config,
  494. "specs_weight"=>$specs_weight===""?0:$specs_weight,
  495. "gold_price"=>$gold_price===""? 0 : $gold_price,
  496. "is_gold_price"=>$is_gold_price===""?0:$is_gold_price,
  497. "total_weight"=>$total_weight===""? $num*$specs_weight :$total_weight,
  498. "budget_price"=>$budget_price,
  499. "num"=>$num,
  500. "pgNo"=>$pgNo,
  501. "use_desc"=>$use_desc,
  502. "remark"=>$remark,
  503. "bargain_num"=>$zxinfo['bargain_num']+1,
  504. "status"=>1,
  505. "is_del"=>0,
  506. "addtime"=>date("Y-m-d H:i:s"),
  507. "updatetime"=>date("Y-m-d H:i:s"),
  508. 'bargain_status'=>1,
  509. 'enclosure_file'=>$enclosure_file
  510. ];
  511. $up = Db::name("consult_info")->insert($info);
  512. if($up){
  513. //操作记录
  514. ActionLog::logAdd($this->post['token'], [
  515. "order_code" => $innew,//咨询单详情编号
  516. "status" => 1,//这里的status是之前的值
  517. "action_remark" => '',//备注
  518. "action_type" => "edit"//新建create,编辑edit,更改状态status
  519. ], "ZXD", 1, $this->post);
  520. // ProcessOrder::AddProcess($this->post['token'], [
  521. // "order_type" => 'ZXD',
  522. // "order_code" => $innew,//咨询单详情编号
  523. // "order_id" => 0,
  524. // "order_status" => 1
  525. // ]);
  526. if (!empty($bidlist)){
  527. foreach ($bidlist as $value){
  528. unset($value['id']);
  529. $value['infoNo']=$innew;
  530. $value['bidNo']=makeNo("BD");
  531. $value['spuCode']=makeNo("SKU");
  532. $value['status'] =0;
  533. $value['updatetime'] =date("Y-m-d H:i:s");
  534. $in = Db::name("consult_bids")->insert($value);
  535. if($in==false){
  536. Db::rollback();
  537. return error_show(1004,"反馈商品新建失败");
  538. }
  539. ActionLog::logAdd($this->post['token'], [
  540. "order_code" => $innew,//咨询单详情编号
  541. "status" => 1,//这里的status是之前的值
  542. "action_remark" => '',//备注
  543. "action_type" => "edit"//新建create,编辑edit,更改状态status
  544. ], "FKD", 1, $this->post);
  545. }
  546. }
  547. $zxinfo["bargain_status"] =1;
  548. $zxinfo["status"] =6;
  549. $zxinfo["bargain_code"] =$innew;
  550. $zxinfo["updatetime"] =date("Y-m-d H:i:s");
  551. $bar=Db::name("consult_info")->save($zxinfo);
  552. if($bar==false){
  553. Db::rollback();
  554. return error_show(1004,"反馈商品更新失败");
  555. }else{
  556. //修改状态,添加待办
  557. ActionLog::logAdd($this->post['token'], [
  558. "order_code" => $zxinfo['infoNo'],//咨询单详情编号
  559. "status" => $zxinfo['status'],//这里的status是之前的值
  560. "action_remark" => '',//备注
  561. "action_type" => "edit"//新建create,编辑edit,更改状态status
  562. ], "ZXD", $zxinfo['status'], $zxinfo);
  563. }
  564. //更新consule_order记录
  565. $op = Db::name('consult_order')->where('zxNo',$zxinfo['zxNo'])->update(['endtime'=>$endtime,
  566. 'updatetime'=>date('Y-m-d H:i:s')]);
  567. if($op==false){
  568. Db::rollback();
  569. return error_show(1004,'咨询单结束时间更新失败');
  570. }
  571. //维护台账记录
  572. $insert_standing_book_data=[
  573. 'standBookNo'=>makeNo('IO'),
  574. 'infoNo'=>$innew,
  575. 'addtime' => date('Y-m-d H:i:s'),
  576. 'updatetime' => date('Y-m-d H:i:s')
  577. ];
  578. $temp_project = Db::name('consult_order')->field('id,projectNo,khNo,companyNo')->where(['zxNo'=>$zxinfo['zxNo'], 'is_del'=>0])->find();
  579. if(!empty($temp_project)){
  580. $insert_standing_book_data['projectNo']=$temp_project['projectNo'];
  581. $insert_standing_book_data['companyNo']=$temp_project['companyNo'];
  582. $insert_standing_book_data['customer_code']=$temp_project['khNo'];
  583. }
  584. Db::name('standing_book')->insert($insert_standing_book_data);
  585. Db::commit();
  586. return app_show(0,"咨询新建成功",["infoNo"=>$innew]);
  587. }
  588. }catch (\Exception $e){
  589. Db::rollback();
  590. return error_show(1004,$e->getMessage());
  591. }
  592. }
  593. //** 发布竞标任务 */
  594. public function bargain(){
  595. $infoNo= isset($this->post['infoNo'])&&$this->post['infoNo']!=""?trim($this->post['infoNo']):"";
  596. if($infoNo==""){
  597. return error_show(1004,"参数infoNo不能为空");
  598. }
  599. $zxinfo = Db::name("consult_info")->where(["infoNo"=>$infoNo,"is_del"=>0])->find();
  600. if($zxinfo==false){
  601. return error_show(1004,"未找到信息数据");
  602. }
  603. $status =isset($this->post['status']) && $this->post['status']!=="" ? intval($this->post['status']):"";
  604. if($status===""){
  605. return error_show(1004,"参数status不能为空");
  606. }
  607. // if($status==1&&$zxinfo['status']>1){
  608. // $zxinfo['bargain_num']=+1;
  609. // }
  610. $old_zxinfo_status = $zxinfo['status'];
  611. $zxinfo['status']=$status;
  612. $zxinfo['updatetime']=date("Y-m-d H:i:s");
  613. $up = Db::name("consult_info")->save($zxinfo);
  614. if($up){
  615. //修改状态,添加待办
  616. ActionLog::logAdd($this->post['token'], [
  617. "order_code" => $zxinfo['infoNo'],//咨询单详情编号
  618. "status" => $old_zxinfo_status,//这里的status是之前的值
  619. "action_remark" => '',//备注
  620. "action_type" => "status"//新建create,编辑edit,更改状态status
  621. ], "ZXD", $zxinfo['status'], $zxinfo);
  622. return app_show(0,"状态更新成功");
  623. }else{
  624. return error_show(1003,"状态更新失败");
  625. }
  626. }
  627. //反馈商品添加
  628. public function feadback(){
  629. $infoNo= isset($this->post['infoNo'])&&$this->post['infoNo']!=""?trim($this->post['infoNo']):"";
  630. if($infoNo==""){
  631. return error_show(1002,"参数infoNo不能为空");
  632. }
  633. $zxinfo = Db::name("consult_info")->where(["infoNo"=>$infoNo,"is_del"=>0])->find();
  634. if($zxinfo==false){
  635. return error_show(1003,"未找到信息数据");
  636. }
  637. if($zxinfo['status']!=1){
  638. return error_show(1004,"任务未进行");
  639. }
  640. $zx = Db::name("consult_order")->where(["zxNo"=>$zxinfo['zxNo'],"is_del"=>0])->find();
  641. if($zx==false){
  642. return error_show(1003,"未找咨询信息数据");
  643. }
  644. $pname = isset($this->post['pname'])&&$this->post['pname']!=""? trim($this->post['pname']):"";
  645. if($pname==""){
  646. return error_show(1002,"参数pname不能为空");
  647. }
  648. $brandid = isset($this->post['brandid'])&&$this->post['brandid']!=""? intval($this->post['brandid']):"";
  649. $cat_id = isset($this->post['cat_id'])&&$this->post['cat_id']!=""? trim($this->post['cat_id']):"";
  650. if($cat_id==""){
  651. return error_show(1002,"参数cat_id不能为空");
  652. }
  653. $specin= isset($this->post['specinfo'])&&!empty($this->post['specinfo'])?$this->post['specinfo']:"";
  654. if($specin==""){
  655. return error_show(1003,"参数specinfo不能为空");
  656. }
  657. $specinfo=[];
  658. foreach ($specin as $v){
  659. $spec =Db::name("specs")->where(["id"=>$v['specid']])->find();
  660. $spec_value =Db::name("spec_value")->where(["id"=>$v['spec_value_id']])->find();
  661. $v['spec_name']=isset($spec['spec_name'])?$spec['spec_name']:"";
  662. $v['spec_value_name']=isset($spec_value['spec_value'])?$spec_value['spec_value']:"";
  663. $specinfo[]=$v;
  664. }
  665. $unit_id = isset($this->post['unit_id'])&&$this->post['unit_id']!=""? intval($this->post['unit_id']):"";
  666. $cost_desc = isset($this->post['cost_desc'])&&$this->post['cost_desc']!=""? trim($this->post['cost_desc']):"";
  667. $work_day = isset($this->post['work_day'])&&$this->post['work_day']!=""? intval($this->post['work_day']):"";
  668. $delivery_day = isset($this->post['delivery_day'])&&$this->post['delivery_day']!=""? intval($this->post['delivery_day']):"";
  669. $good_img = isset($this->post['good_img'])&&$this->post['good_img']!=""? $this->post['good_img']:[];
  670. $expire_day = isset($this->post['expire_day'])&&$this->post['expire_day']!=""? intval($this->post['expire_day']) :"";
  671. $origin_place = isset($this->post['origin_place'])&&$this->post['origin_place']!=""? trim($this->post['origin_place']):"";
  672. $supplierNo = isset($this->post['supplierNo'])&&$this->post['supplierNo']!=""? trim($this->post['supplierNo']):"";
  673. $pay_way = isset($this->post['pay_way'])&&$this->post['pay_way']!=""? intval($this->post['pay_way']):"";
  674. $tax = isset($this->post['tax'])&&$this->post['tax']!=""? trim($this->post['tax']):"";
  675. $send_way = isset($this->post['send_way'])&&$this->post['send_way']!=""? intval($this->post['send_way']):"";
  676. $metal_id = isset($this->post['metal_id'])&&$this->post['metal_id']!=""? intval($this->post['metal_id']):"0";
  677. $is_gold_price = isset($this->post['is_gold_price'])&&$this->post['is_gold_price']!=""? intval($this->post['is_gold_price']):"0";
  678. $config = isset($this->post['config'])&&$this->post['config']!=""? $this->post['config']:"";
  679. $other_config = isset($this->post['other_config'])&&$this->post['other_config']!=""? $this->post['other_config']:"";
  680. $weight = isset($this->post['weight'])&&$this->post['weight']!==""? floatval($this->post['weight']):"0";
  681. $good_weight = isset($this->post['noble_weight'])&&$this->post['noble_weight']!==""? floatval($this->post['noble_weight']):"0";
  682. $demo_fee = isset($this->post['demo_fee'])&&$this->post['demo_fee']!==""? floatval($this->post['demo_fee']):"0";
  683. $delivery_fee = isset($this->post['delivery_fee'])&&$this->post['delivery_fee']!==""? floatval($this->post['delivery_fee']):"0";
  684. $open_fee = isset($this->post['open_fee'])&&$this->post['open_fee']!==""? floatval($this->post['open_fee']):"0";
  685. $pakge_fee = isset($this->post['pakge_fee'])&&$this->post['pakge_fee']!==""? floatval($this->post['pakge_fee']):"0";
  686. $nake_fee = isset($this->post['nake_fee'])&&$this->post['nake_fee']!==""? floatval($this->post['nake_fee']):"0";
  687. $mark_fee = isset($this->post['mark_fee'])&&$this->post['mark_fee']!==""? floatval($this->post['mark_fee']):"0";
  688. $cert_fee = isset($this->post['cert_fee'])&&$this->post['cert_fee']!==""? floatval($this->post['cert_fee']):"0";
  689. $cost_fee = isset($this->post['cost_fee'])&&$this->post['cost_fee']!==""? floatval($this->post['cost_fee']):"0";
  690. if($nake_fee==="" ){
  691. return error_show(1004,"参数nake_fee不能为空");
  692. }
  693. $is_diff = isset($this->post['is_diff'])&&$this->post['is_diff']!==""? intval($this->post['is_diff']):"";
  694. $supply_area = isset($this->post['supply_area'])&&$this->post['supply_area']!==""? intval($this->post['supply_area']):"";
  695. $remark = isset($this->post['remark'])&&$this->post['remark']!=""? trim($this->post['remark']):"";
  696. $delivery_place = isset($this->post['delivery_place'])&& $this->post['delivery_place']!='' ? trim($this->post['delivery_place']):"";
  697. if($delivery_place==''){
  698. return error_show(1002,"参数delivery_place不能为空");
  699. }
  700. $token = isset($this->post['token'])&& $this->post['token']!='' ? trim($this->post['token']):"";
  701. if($token==''){
  702. return error_show(1002,"参数token不能为空");
  703. }
  704. $user =GetUserInfo($token);
  705. if(empty($user)||$user['code']!=0){
  706. return error_show(1005,"用户数据不存在");
  707. }
  708. $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  709. $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  710. $bidNo=makeNo("BD");
  711. $spucode=makeNo("SKU");
  712. $catinfo = Db::name("cat")->where(["id"=>$cat_id])->find();
  713. $budget = isset($catinfo['order_rate']) ? $catinfo['order_rate']/100:0;
  714. //部分参数的大小校验
  715. $vali = Validate::rule([
  716. 'expire_day|有效时长'=>'require|elt:214748364',
  717. 'delivery_day|物流时长'=>'require|elt:214748364',
  718. 'work_day|生产工期'=>'require|elt:214748364',
  719. 'weight|总重量'=>'require|max:10',
  720. ]);
  721. $temp = [
  722. 'expire_day'=>$expire_day,
  723. 'delivery_day'=>$delivery_day,
  724. 'work_day'=>$work_day,
  725. 'weight'=>$weight,
  726. ];
  727. if(!$vali->check($temp)) return error_show(0,$vali->getError());
  728. $sale_cost_fee = $cost_fee;//销售工艺费默认取传值
  729. $cat_top_list = made($cat_id);
  730. $cat_top_id = isset($cat_top_list[0]['id']) ? $cat_top_list[0]['id'] : 0;
  731. if ($is_gold_price == 1 && $cat_top_id == 6) {
  732. $gold = Db::name("gold_price1")->where(["type"=>$metal_id,"is_del"=>0,"status"=>1])->order("addtime desc")
  733. ->find();
  734. //$total_fee = $open_fee/$zxinfo['num'] + $weight* $gold["price"] + $cost_fee*$weight+$pakge_fee+$mark_fee+$cert_fee+$nake_fee;
  735. //$total_fee(成本合计初始价格) =打样费/购买数量 + 开模费/购买数量 + 商品重量* 最新金价 + 工艺费* 商品重量+包装费+加标费+证书费+产品裸价0+运费;
  736. $total_fee = $demo_fee / $zxinfo['num'] + $open_fee / $zxinfo['num'] + $good_weight * $gold["price"] + $cost_fee * $good_weight + $pakge_fee + $mark_fee + $cert_fee + $nake_fee + $delivery_fee;
  737. // $saleprice = $open_fee/$zxinfo['num'] + $weight* $gold["price"] + $cost_fee/(1-$budget)* $weight+$pakge_fee+$mark_fee+$cert_fee+$nake_fee;
  738. //$saleprice(最终售价) = (开模费/购买数量 + 商品重量* 最新金价 + 工艺费* 商品重量+包装费+加标费+证书费+产品裸价)/(1-成本售价/100);
  739. // $saleprice = ($open_fee / $zxinfo['num'] + $weight * $gold["price"] + $cost_fee * $weight + $pakge_fee + $mark_fee + $cert_fee + $nake_fee) / (1 - $budget);
  740. $saleprice = $total_fee/ (1 - $budget);
  741. //销售工艺费=((开模费/购买数量 + 商品重量* 最新金价 + 工艺费* 商品重量+包装费+加标费+证书费+产品裸价)/(1-成本售价/100)-(打样费/购买数量 + 开模费/购买数量 +包装费+加标费+证书费+产品裸价0+运费) )/商品重量-最新金价
  742. $sale_cost_fee = ($saleprice - ($demo_fee / $zxinfo['num'] + $open_fee / $zxinfo['num'] + $pakge_fee + $mark_fee + $cert_fee + $nake_fee + $delivery_fee)) /$good_weight - $gold["price"];
  743. }else{
  744. if($nake_fee){
  745. $saleprice = ($demo_fee / $zxinfo['num']+$delivery_fee+$open_fee / $zxinfo['num'] + $cost_fee * $good_weight +
  746. $pakge_fee + $mark_fee + $cert_fee +$nake_fee)/ (1 - $budget);
  747. $total_fee = $demo_fee / $zxinfo['num']+$delivery_fee+$open_fee / $zxinfo['num'] + $cost_fee *$good_weight + $pakge_fee + $mark_fee + $cert_fee + $nake_fee;
  748. }else{
  749. $saleprice = ($demo_fee/$zxinfo['num']+$delivery_fee+$open_fee / $zxinfo['num'] + $cost_fee * $good_weight + $pakge_fee + $mark_fee + $cert_fee) /
  750. (1 - $budget);
  751. $total_fee = $demo_fee/$zxinfo['num']+$delivery_fee+$open_fee / $zxinfo['num'] + $cost_fee *$good_weight + $pakge_fee + $mark_fee + $cert_fee;
  752. }
  753. }
  754. $supplier = Db::name('supplier')
  755. ->field('id,person,personid')
  756. ->where('code',$supplierNo)
  757. ->findOrEmpty();
  758. $data=[
  759. "bidNo"=>$bidNo,
  760. "infoNo"=>$infoNo,
  761. "zxNo"=>$zxinfo['zxNo'],
  762. "spuCode"=>$spucode,
  763. "good_name"=>$pname,
  764. "brand_id"=>$brandid,
  765. "cat_id"=>$cat_id,
  766. "specinfo"=>json_encode($specinfo),
  767. "unit_id"=>$unit_id,
  768. "cost_desc"=>$cost_desc,
  769. "work_day"=>$work_day,
  770. "delivery_day"=>$delivery_day,
  771. "good_img"=>is_array($good_img)?implode(',',$good_img):$good_img,
  772. "expire_day"=>$expire_day,
  773. "origin_place"=>$origin_place,
  774. "supplierNo"=>$supplierNo,
  775. "pay_way"=>$pay_way,
  776. "tax"=>$tax,
  777. "send_way"=>$send_way,
  778. "metal_id"=>$metal_id,
  779. "is_gold_price"=>$is_gold_price,
  780. "config"=>$config,
  781. "other_config"=>$other_config,
  782. "weight"=>$weight,
  783. "good_weight"=>$good_weight,
  784. "gold_price"=>isset($gold["price"])?$gold["price"]:0,
  785. "is_diff"=>$is_diff,
  786. "demo_fee"=>$demo_fee,
  787. "delivery_fee"=>$delivery_fee,
  788. "open_fee"=>$open_fee,
  789. "pakge_fee"=>$pakge_fee,
  790. "nake_fee"=>$nake_fee,
  791. "mark_fee"=>$mark_fee,
  792. "cert_fee"=>$cert_fee,
  793. "cost_fee"=>$cost_fee,
  794. "total_fee"=>$total_fee,
  795. "supply_area"=>$supply_area,
  796. "remark"=>$remark,
  797. "sale_price"=>$saleprice,
  798. "sale_cost_fee"=>$sale_cost_fee,
  799. "origin_cost_fee"=>$sale_cost_fee,
  800. "origin_price"=>$saleprice,
  801. "createrid"=>$createrid,
  802. "creater"=>$creater,
  803. "status"=>$zxinfo['status']==1 ?1 :2,
  804. "is_del"=>0,
  805. "addtime"=>date("Y-m-d H:i:s"),
  806. "updatetime"=>date("Y-m-d H:i:s"),
  807. 'delivery_place'=>$delivery_place,//发货地
  808. 'cgder' => $supplier['person'] ?? '',
  809. 'cgderid' => $supplier['personid'] ?? 0,
  810. ];
  811. Db::startTrans();
  812. try{
  813. $insert= Db::name("consult_bids")->insert($data);
  814. if($insert){
  815. if($zx['is_project']==1 && $zx['projectNo']!="" && $zxinfo['pgNo']!=""){
  816. $projectinfo =Db::name("project_info")->where(["pgNo"=>$zxinfo["pgNo"],"projectNo"=>$zx['projectNo'],"is_del"=>0])->find();
  817. if($projectinfo==false){
  818. Db::rollback();
  819. return error_show(1006,"未找到项目信息");
  820. }
  821. $temp=[];
  822. $temp['spuCode']=$spucode;
  823. $temp['skuCode']="";
  824. $temp['pgNo']=$zxinfo['pgNo'];
  825. $temp['projectNo']=$zx['projectNo'];
  826. $temp['good_name']=$pname;
  827. $temp['good_type']=$projectinfo['good_type'];
  828. $temp['data_source']=2;
  829. $temp['cat_id']=$cat_id;
  830. $temp['budget_price']=$projectinfo['budget_price'];
  831. $temp['sale_price']=$saleprice;
  832. $temp['origin_price']=$total_fee;
  833. $temp['num']=$zxinfo['num'];
  834. $temp['status']=0;
  835. $temp['is_del']=0;
  836. $temp['creater']=$creater;
  837. $temp['createrid']=$createrid;
  838. $temp['addtime']=date("Y-m-d H:i:s");
  839. $temp['updatetime']=date("Y-m-d H:i:s");
  840. $nu = Db::name("project_feedback")->insert($temp);
  841. if($nu==false){
  842. Db::rollback();
  843. return error_show(1006,"项目反馈失败");
  844. }else{
  845. $old_projectinfo_status = $projectinfo['status'];
  846. $projectinfo['status']=2;
  847. $projectinfo['updatetime']=date("Y-m-d H:i:s");
  848. $up = Db::name("project_info")->save($projectinfo);
  849. if($up){
  850. //修改状态,添加待办,只记录动作
  851. ActionLog::logAdd($this->post['token'], [
  852. "order_code" => $projectinfo['pgNo'],//编码
  853. "status" => $old_projectinfo_status,//这里的status是之前的值
  854. "action_remark" => '',//备注
  855. "action_type" => "status"//新建create,编辑edit,更改状态status
  856. ], "PRI", 2, $projectinfo);
  857. $count = Db::name("project_info")->where(["projectNo"=>$projectinfo['projectNo'],"status"=>1])
  858. ->count();
  859. if($count==0){
  860. $projetc =Db::name("project")->where(["projectNo"=>$projectinfo['projectNo'],"status"=>1])->find();
  861. if($projetc!=false){
  862. $proc =Db::name("project")->where(["projectNo"=>$projectinfo['projectNo'],"status"=>1])->save
  863. (["status"=>2,"updatetime"=>date("Y-m-d H:i:s")]);
  864. if($proc==false){
  865. Db::rollback();
  866. return error_show(1006,"项目反馈失败");
  867. }else{
  868. //修改状态,添加待办
  869. ActionLog::logAdd($this->post['token'], [
  870. "order_code" => $projetc['projectNo'],//项目编码
  871. "status" => 1,//这里的status是之前的值
  872. "action_remark" => '',//备注
  873. "action_type" => "status"//新建create,编辑edit,更改状态status
  874. ], "PRO", 2, $projetc);
  875. ProcessOrder::AddProcess($this->post['token'], [
  876. "order_type" => 'PRO',
  877. "order_code" => $projetc['projectNo'],
  878. "order_id" => $projetc['id'],
  879. "order_status" => 2,"before_status"=>1
  880. ]);
  881. }
  882. }
  883. }
  884. }
  885. }
  886. }
  887. Db::commit();
  888. return app_show(0,"反馈成功",["bidNo"=>$bidNo]);
  889. }else{
  890. Db::rollback();
  891. return error_show(1006,"反馈失败");
  892. }
  893. }catch (\Exception $e){
  894. Db::rollback();
  895. return error_show(1006,$e->getMessage());
  896. }
  897. }
  898. //反馈商品详情
  899. public function feadinfo(){
  900. $bidNo =isset($this->post['bidNo'])&& $this->post['bidNo']!=""?trim($this->post['bidNo']):"";
  901. if($bidNo==""){
  902. return error_show(1004,"参数bidNo不能为空");
  903. }
  904. $info =Db::name("consult_bids")->where(['bidNo'=>$bidNo,"is_del"=>0])->find();
  905. if($info==false){
  906. return error_show(1004,"未找到商品数据");
  907. }
  908. $unit =Db::name("unit")->where(["id"=>$info['unit_id']])->find();
  909. $info['unit'] = isset($unit['unit'])?$unit['unit']:'';
  910. $info['cat_info'] = made($info['cat_id'],[]);
  911. $info['noble_weight'] = $info['good_weight'];
  912. $supplier = Db::name("supplier")->where(["code"=>$info['supplierNo']])->find();
  913. $info['supplierName'] = isset($supplier['name'])?$supplier['name']:"";
  914. if($info['brand_id']!=0){
  915. $brand=Db::name("brand")->where(["id"=>$info['brand_id']])->find();
  916. $info["brand_name"]=isset($brand['brand_name'])?$brand['brand_name']:"";
  917. }else{
  918. $info["brand_name"]="";
  919. $info["brand_id"]="";
  920. }
  921. $catinfo = Db::name("cat")->where(["id"=>$info['cat_id']])->find();
  922. $bidinfo = Db::name("consult_info")->where(["infoNo"=>$info["infoNo"]])->find();
  923. $budget = isset($catinfo['order_rate']) ? $catinfo['order_rate']:0;
  924. $god=[
  925. "metal_id"=>$info['metal_id'],
  926. "weight"=>$info["good_weight"],
  927. "demo_fee"=>$info["demo_fee"],
  928. "delivery_fee"=>$info["delivery_fee"],
  929. "open_fee"=>$info["open_fee"],
  930. "packing_fee"=>$info["pakge_fee"],
  931. "mark_fee"=>$info["mark_fee"],
  932. "nake_fee"=>$info["nake_fee"],
  933. "cert_fee"=>$info["cert_fee"],
  934. "cost_fee"=>$info["cost_fee"],
  935. "num"=>$bidinfo["num"],
  936. ];
  937. if($info['is_gold_price']==1){
  938. $price = GoldPrice($god, $budget/100);
  939. $info['sale_price'] =round($price,2);
  940. }
  941. $info['specinfo'] = json_decode($info['specinfo'],true);
  942. $place = ["provice_code"=>"","city_code"=>"","area_code"=>""];
  943. if($info['delivery_place']!=""){
  944. list($place['provice_code'],$place['city_code'],$place['area_code'])=explode(",",$info['delivery_place']);
  945. }
  946. $info['delivery_place_cn']=GetAddr(json_encode($place));
  947. $place = ["provice_code"=>"","city_code"=>"","area_code"=>""];
  948. if($info['origin_place']!=""){
  949. list($place['provice_code'],$place['city_code'],$place['area_code'])=explode(",",$info['origin_place']);
  950. }
  951. $info['origin_place_cn']=GetAddr(json_encode($place));
  952. $info['metal_name']=isset($info['metal_id'])&& $info['metal_id']!=0?$this->noble[$info['metal_id']]:"";
  953. $bargain =Db::name("bargain_order")->where(['bidsNo'=>$bidNo,"is_del"=>0])->find();
  954. $info['bargain'] =$bargain;
  955. $info['good_img'] = explode(',',$info['good_img']);
  956. //添加商品创建人字段
  957. $good_info = Db::name('good_basic')
  958. ->field('id,createrid,creater')
  959. ->where('is_del',0)
  960. ->where('spuCode',$info['spuCode'])
  961. ->findOrEmpty();
  962. $info['good_createrid'] = $good_info['createrid']??0;
  963. $info['good_creater'] = $good_info['creater']??'';
  964. return app_show(0,"获取成功",$info);
  965. }
  966. //反馈商品编辑
  967. public function feededit(){
  968. $bidNo= isset($this->post['bidNo'])&&$this->post['bidNo']!=""?trim($this->post['bidNo']):"";
  969. if($bidNo==""){
  970. return error_show(1002,"参数bidNo不能为空");
  971. }
  972. $bidinfo = Db::name("consult_bids")->where(["bidNo"=>$bidNo,"is_del"=>0])->find();
  973. if($bidinfo==false){
  974. return error_show(1003,"未找到信息数据");
  975. }
  976. if($bidinfo['status']>=5){
  977. return error_show(1004,"咨询单已确认无法修改");
  978. }
  979. $zxinfo = Db::name("consult_info")->where(["infoNo"=>$bidinfo['infoNo'],"is_del"=>0])->find();
  980. if($zxinfo==false){
  981. return error_show(1003,"未找到信息数据");
  982. }
  983. $zx = Db::name("consult_order")->where(["zxNo"=>$zxinfo['zxNo'],"is_del"=>0])->find();
  984. if($zx==false){
  985. return error_show(1003,"未找咨询信息数据");
  986. }
  987. $pname = isset($this->post['pname'])&&$this->post['pname']!=""? trim($this->post['pname']):"";
  988. if($pname==""){
  989. return error_show(1002,"参数pname不能为空");
  990. }
  991. $brandid = isset($this->post['brandid'])&&$this->post['brandid']!=""? intval($this->post['brandid']):"";
  992. // if($brandid==""){
  993. // return error_show(1002,"参数brandid不能为空");
  994. // }
  995. $cat_id = isset($this->post['cat_id'])&&$this->post['cat_id']!=""? trim($this->post['cat_id']):"";
  996. if($cat_id==""){
  997. return error_show(1002,"参数cat_id不能为空");
  998. }
  999. $specin= isset($this->post['specinfo'])&&!empty($this->post['specinfo'])?$this->post['specinfo']:"";
  1000. if($specin==""){
  1001. return error_show(1003,"参数specinfo不能为空");
  1002. }
  1003. $specinfo=[];
  1004. foreach ($specin as $v){
  1005. $spec =Db::name("specs")->where(["id"=>$v['specid']])->find();
  1006. $spec_value =Db::name("spec_value")->where(["id"=>$v['spec_value_id']])->find();
  1007. $v['spec_name']=isset($spec['spec_name'])?$spec['spec_name']:"";
  1008. $v['spec_value_name']=isset($spec_value['spec_value'])?$spec_value['spec_value']:"";
  1009. $specinfo[]=$v;
  1010. }
  1011. $unit_id = isset($this->post['unit_id'])&&$this->post['unit_id']!=""? intval($this->post['unit_id']):"";
  1012. $cost_desc = isset($this->post['cost_desc'])&&$this->post['cost_desc']!=""? trim($this->post['cost_desc']):"";
  1013. $work_day = isset($this->post['work_day'])&&$this->post['work_day']!=""? intval($this->post['work_day']):"";
  1014. $delivery_day = isset($this->post['delivery_day'])&&$this->post['delivery_day']!=""? intval($this->post['delivery_day']):"";
  1015. $good_img = isset($this->post['good_img'])&&$this->post['good_img']!=""? $this->post['good_img']:[];
  1016. $expire_day = isset($this->post['expire_day'])&&$this->post['expire_day']!=""? intval($this->post['expire_day'])
  1017. :"";
  1018. $origin_place = isset($this->post['origin_place'])&&$this->post['origin_place']!=""? trim($this->post['origin_place']):"";
  1019. $supplierNo = isset($this->post['supplierNo'])&&$this->post['supplierNo']!=""? trim($this->post['supplierNo']):"";
  1020. $pay_way = isset($this->post['pay_way'])&&$this->post['pay_way']!=""? intval($this->post['pay_way']):"";
  1021. $tax = isset($this->post['tax'])&&$this->post['tax']!=""? trim($this->post['tax']):"";
  1022. $send_way = isset($this->post['send_way'])&&$this->post['send_way']!=""? intval($this->post['send_way']):"0";
  1023. $metal_id = isset($this->post['metal_id'])&&$this->post['metal_id']!=""? intval($this->post['metal_id']):"0";
  1024. $is_gold_price = isset($this->post['is_gold_price'])&&$this->post['is_gold_price']!=""? intval($this->post['is_gold_price']):"0";
  1025. $config = isset($this->post['config'])&&$this->post['config']!=""? $this->post['config']:"";
  1026. $other_config = isset($this->post['other_config'])&&$this->post['other_config']!=""? $this->post['other_config']:"";
  1027. $weight = isset($this->post['weight'])&&$this->post['weight']!=""? floatval($this->post['weight']):"0";
  1028. $noble_weight = isset($this->post['noble_weight'])&&$this->post['noble_weight']!=""? floatval($this->post['noble_weight']):"0";
  1029. $demo_fee = isset($this->post['demo_fee'])&&$this->post['demo_fee']!=""? floatval($this->post['demo_fee']):"0";
  1030. $delivery_fee = isset($this->post['delivery_fee'])&&$this->post['delivery_fee']!=""? floatval($this->post['delivery_fee']):"0";
  1031. $open_fee = isset($this->post['open_fee'])&&$this->post['open_fee']!=""? floatval($this->post['open_fee']):"0";
  1032. $pakge_fee = isset($this->post['pakge_fee'])&&$this->post['pakge_fee']!=""? floatval($this->post['pakge_fee']):"0";
  1033. $nake_fee = isset($this->post['nake_fee'])&&$this->post['nake_fee']!==""? floatval($this->post['nake_fee']):0;
  1034. $mark_fee = isset($this->post['mark_fee'])&&$this->post['mark_fee']!=""? floatval($this->post['mark_fee']):"0";
  1035. $cert_fee = isset($this->post['cert_fee'])&&$this->post['cert_fee']!=""? floatval($this->post['cert_fee']):"0";
  1036. $cost_fee = isset($this->post['cost_fee'])&&$this->post['cost_fee']!=""? floatval($this->post['cost_fee']):"0";
  1037. $is_diff = isset($this->post['is_diff'])&&$this->post['is_diff']!==""? intval($this->post['is_diff']):"";
  1038. $supply_area = isset($this->post['supply_area'])&&$this->post['supply_area']!==""? intval($this->post['supply_area']):"";
  1039. $remark = isset($this->post['remark'])&&$this->post['remark']!=""? trim($this->post['remark']):"";
  1040. $delivery_place = isset($this->post['delivery_place'])&& $this->post['delivery_place']!='' ? trim($this->post['delivery_place']):"";
  1041. if($delivery_place==''){
  1042. return error_show(1002,"参数delivery_place不能为空");
  1043. }
  1044. $catinfo = Db::name("cat")->where(["id"=>$cat_id])->find();
  1045. $budget = isset($catinfo['order_rate']) ? $catinfo['order_rate']/100:0;
  1046. $sale_cost_fee = $bidinfo['sale_cost_fee'];
  1047. $cat_top_list = made($cat_id);
  1048. $cat_top_id = isset($cat_top_list[0]['id']) ? $cat_top_list[0]['id'] : 0;
  1049. if ($is_gold_price == 1 && $cat_top_id == 6) {
  1050. $gold = Db::name("gold_price1")->where(["type"=>$metal_id,"is_del"=>0,"status"=>1])->order("addtime desc")
  1051. ->find();
  1052. //$total_fee(成本合计初始价格) =打样费/购买数量 + 开模费/购买数量 + 商品重量* 最新金价 + 工艺费* 商品重量+包装费+加标费+证书费+产品裸价0+运费;
  1053. $total_fee = $demo_fee / $zxinfo['num'] + $open_fee / $zxinfo['num'] + $noble_weight * $gold["price"] + $cost_fee * $noble_weight + $pakge_fee + $mark_fee + $cert_fee + $nake_fee + $delivery_fee;
  1054. // $saleprice = $open_fee/$zxinfo['num'] + $weight* $gold["price"] + $cost_fee/(1-$budget)* $weight+$pakge_fee+$mark_fee+$cert_fee+$nake_fee;
  1055. //$saleprice(最终售价) = (开模费/购买数量 + 商品重量* 最新金价 + 工艺费* 商品重量+包装费+加标费+证书费+产品裸价)/(1-成本售价/100);
  1056. $saleprice = $total_fee / (1 - $budget);
  1057. //销售工艺费=((开模费/购买数量 + 商品重量* 最新金价 + 工艺费* 商品重量+包装费+加标费+证书费+产品裸价)/(1-成本售价/100)-(打样费/购买数量 + 开模费/购买数量 +包装费+加标费+证书费+产品裸价0+运费) )/商品重量-最新金价
  1058. $sale_cost_fee = ( $saleprice- ($demo_fee / $zxinfo['num'] + $open_fee / $zxinfo['num'] + $pakge_fee + $mark_fee + $cert_fee + $nake_fee + $delivery_fee)) / $noble_weight - $gold["price"];
  1059. }else{
  1060. $saleprice = ($demo_fee / $zxinfo['num']+$delivery_fee+$open_fee / $zxinfo['num'] + $cost_fee*$noble_weight + $pakge_fee +
  1061. $mark_fee + $cert_fee + $nake_fee) / (1 - $budget);
  1062. $total_fee = $demo_fee/$zxinfo['num']+$delivery_fee+$open_fee/$zxinfo['num'] + $cost_fee * $noble_weight + $pakge_fee + $mark_fee+$cert_fee +$nake_fee;
  1063. }
  1064. Db::startTrans();
  1065. try{
  1066. $data=[
  1067. "good_name"=>$pname,
  1068. "brand_id"=>$brandid,
  1069. "cat_id"=>$cat_id,
  1070. "specinfo"=>json_encode($specinfo),
  1071. // "material"=>$material,
  1072. "unit_id"=>$unit_id,
  1073. "cost_desc"=>$cost_desc,
  1074. "work_day"=>$work_day,
  1075. "delivery_day"=>$delivery_day,
  1076. "good_img"=>is_array($good_img)?implode(',',$good_img):$good_img,
  1077. "expire_day"=>$expire_day,
  1078. "origin_place"=>$origin_place,
  1079. "supplierNo"=>$supplierNo,
  1080. "pay_way"=>$pay_way,
  1081. "tax"=>$tax,
  1082. "send_way"=>$send_way,
  1083. "metal_id"=>$metal_id,
  1084. "is_gold_price"=>$is_gold_price,
  1085. "config"=>$config,
  1086. "other_config"=>$other_config,
  1087. "weight"=>$weight,
  1088. "good_weight"=>$noble_weight,
  1089. "is_diff"=>$is_diff,
  1090. "demo_fee"=>$demo_fee,
  1091. "gold_price"=>isset($gold["price"])?$gold["price"]:0,
  1092. "delivery_fee"=>$delivery_fee,
  1093. "open_fee"=>$open_fee,
  1094. "pakge_fee"=>$pakge_fee,
  1095. "nake_fee"=>$nake_fee,
  1096. "mark_fee"=>$mark_fee,
  1097. "cert_fee"=>$cert_fee,
  1098. "cost_fee"=>$cost_fee,
  1099. "sale_cost_fee"=>$sale_cost_fee,
  1100. "origin_cost_fee"=>$sale_cost_fee,
  1101. "total_fee"=>$total_fee,
  1102. "sale_price"=>$saleprice,
  1103. "origin_price"=>$saleprice,
  1104. "supply_area"=>$supply_area,
  1105. "remark"=>$remark,
  1106. "status"=>0,
  1107. "updatetime"=>date("Y-m-d H:i:s"),
  1108. 'delivery_place' => $delivery_place
  1109. ];
  1110. $insert= Db::name("consult_bids")->where($bidinfo)->save($data);
  1111. if($insert){
  1112. if($zxinfo['bargain_status']==1){
  1113. $zxinfo['bargain_status']=0;
  1114. $infoip =Db::name("consult_info")->save($zxinfo);
  1115. if($infoip==false){
  1116. Db::rollback();
  1117. return error_show(1006,"咨询信息状态更新失败");
  1118. }
  1119. }
  1120. if($zx['is_project']==1 && $zx['projectNo']!="" && $zxinfo['pgNo']!=""){
  1121. $projectinfo =Db::name("project_info")->where(["pgNo"=>$zxinfo["pgNo"],"projectNo"=>$zx['projectNo'],"is_del"=>0])->find();
  1122. if($projectinfo==false){
  1123. Db::rollback();
  1124. return error_show(1006,"未找到项目信息");
  1125. }
  1126. $feed = Db::name("project_feedback")->where(["pgNo"=>$zxinfo["pgNo"],"projectNo"=>$zx['projectNo'],"spuCode"=>$bidinfo['spuCode'],"is_del"=>0])->find();
  1127. if($feed!=false) {
  1128. $feed['good_name']=$pname;
  1129. $feed['good_type']=$projectinfo['good_type'];
  1130. $feed['cat_id']=$cat_id;
  1131. $feed['sale_price']=$saleprice;
  1132. $feed['origin_price']=$total_fee;
  1133. $feed['updatetime']=date("Y-m-d H:i:s");
  1134. $temp['updatetime']=date("Y-m-d H:i:s");
  1135. $nu=Db::name("project_feedback")->save($feed);
  1136. if ($nu == false) {
  1137. Db::rollback();
  1138. return error_show(1006 , "项目反馈失败");
  1139. } else {
  1140. $old_projectinfo_status=$projectinfo['status'];
  1141. $projectinfo['status']=2;
  1142. $projectinfo['updatetime']=date("Y-m-d H:i:s");
  1143. $up=Db::name("project_info")->save($projectinfo);
  1144. if ($up) {
  1145. //修改状态,添加待办,只记录动作
  1146. ActionLog::logAdd($this->post['token'] , [
  1147. "order_code"=>$projectinfo['pgNo'] ,//编码
  1148. "status"=>$old_projectinfo_status ,//这里的status是之前的值
  1149. "action_remark"=>'' ,//备注
  1150. "action_type"=>"status"//新建create,编辑edit,更改状态status
  1151. ] , "PRI" , 2 , $projectinfo
  1152. );
  1153. $count=Db::name("project_info")->where(["projectNo"=>$projectinfo['projectNo'] , "status"=>1])->count();
  1154. if ($count == 0) {
  1155. //先查询是否存在status==1的项目,有的话再更新,否则跳过
  1156. $project_id=Db::name("project")->where(["projectNo"=>$projectinfo['projectNo'] , "status"=>1])->value('id' , 0);
  1157. if ($project_id) {
  1158. $proc=Db::name("project")->where(["id"=>$project_id])->update(["status"=>2 , "updatetime"=>date("Y-m-d H:i:s")]);
  1159. if ($proc == false) {
  1160. Db::rollback();
  1161. return error_show(1006 , "项目反馈失败");
  1162. } else {
  1163. //修改状态,添加待办
  1164. ActionLog::logAdd($this->post['token'] , [
  1165. "order_code"=>$projectinfo['projectNo'] ,//项目编码
  1166. "status"=>1 ,//这里的status是之前的值
  1167. "action_remark"=>'' ,//备注
  1168. "action_type"=>"status"//新建create,编辑edit,更改状态status
  1169. ] , "PRO" , 2 , $this->post
  1170. );
  1171. ProcessOrder::AddProcess($this->post['token'] , [
  1172. "order_type"=>'PRO' ,
  1173. "order_code"=>$projectinfo['projectNo'] ,
  1174. "order_id"=>$project_id ,
  1175. "order_status"=>2 , "before_status"=>1
  1176. ]
  1177. );
  1178. }
  1179. }
  1180. }
  1181. }
  1182. }
  1183. }
  1184. }
  1185. Db::commit();
  1186. return app_show(0,"编辑成功");
  1187. }else{
  1188. Db::rollback();
  1189. return error_show(1004,"编辑失败");
  1190. }
  1191. }catch (\Exception $e){
  1192. Db::rollback();
  1193. return error_show(1004,$e->getMessage());
  1194. }
  1195. }
  1196. //生成议价单
  1197. public function bargain_add(){
  1198. $bidNo = isset($this->post['bidNo'])&& $this->post['bidNo']!=""?trim($this->post['bidNo']):"";
  1199. if($bidNo===""){
  1200. return error_show(1004,"参数bidNo不能为空");
  1201. }
  1202. $info =Db::name("consult_bids")->where(['bidNo'=>$bidNo,"is_del"=>0])->find();
  1203. if($info==false){
  1204. return error_show(1004,"未找到商品数据");
  1205. }
  1206. $consult =Db::name("consult_info")->where(['infoNo'=>$info['infoNo'],"is_del"=>0])->find();
  1207. if($consult==false){
  1208. return error_show(1004,"未找到咨询数据");
  1209. }
  1210. $bargain_price = isset($this->post['bargain_price'])&& $this->post['bargain_price']!=""?floatval($this->post['bargain_price']):"";
  1211. if($bargain_price===""){
  1212. return error_show(1004,"参数bargain_price不能为空");
  1213. }
  1214. $cost_price = isset($this->post['cost_price'])&& $this->post['cost_price']!=""?floatval($this->post['cost_price']):"";
  1215. if($info['is_gold_price']==1){
  1216. if($cost_price==""){
  1217. return error_show(1004,"参数cost_price不能为空");
  1218. }
  1219. $catinfo = Db::name("cat")->where(["id"=>$info['cat_id']])->find();
  1220. $budget = isset($catinfo['order_rate']) ? $catinfo['order_rate']/100:0;
  1221. $gold = Db::name("gold_price1")->where(["type"=>$info['metal_id'],"is_del"=>0,"status"=>1])->order("addtime desc")
  1222. ->find();
  1223. $bargain_price = ($info['demo_fee']/$consult['num']+$info['delivery_fee']+$info['open_fee']/$consult['num']+$info['good_weight'] * $gold["price"] + $cost_price *$info['good_weight']+$info['pakge_fee']+$info['mark_fee'] +$info['cert_fee'] +$info['nake_fee']) / (1 - $budget);
  1224. }
  1225. $bargain_reason = isset($this->post['bargain_reason'])&& $this->post['bargain_reason']!=""?trim($this->post['bargain_reason']):"";
  1226. // if($bargain_reason===""){
  1227. // return error_show(1004,"参数bargain_reason不能为空");
  1228. // }
  1229. $infos =Db::name("consult_info")->where(['infoNo'=>$info['infoNo'],"is_del"=>0])->find();
  1230. if($infos==false){
  1231. return error_show(1004,"未找到商品数据");
  1232. }
  1233. if($infos['status']!=2&&$infos['status']!=3&&$infos['status']!=7){
  1234. return error_show(1004,"咨询单招标未结束或已确认商品");
  1235. }
  1236. $token = isset($this->post['token'])&& $this->post['token']!='' ? trim($this->post['token']):"";
  1237. if($token==''){
  1238. return error_show(105,"参数token不能为空");
  1239. }
  1240. $user =GetUserInfo($token);
  1241. if(empty($user)||$user['code']!=0){
  1242. return error_show(1002,"用户数据不存在");
  1243. }
  1244. //新增两个字段
  1245. //议价备注
  1246. $bargain_remark = isset($this->post['bargain_remark']) && $this->post['bargain_remark'] != "" ? trim($this->post['bargain_remark']) : "";
  1247. //议价原因id
  1248. $result_info_id = isset($this->post['result_info_id']) && $this->post['result_info_id'] != "" ? $this->post['result_info_id'] : "";
  1249. if ($result_info_id != '') {
  1250. $temp = Db::name('result_info')->field('id')->where(['result_code' => $result_info_id, 'type' => 7, 'status' => 1, 'is_del' => 0])->find();//type 7议价原因
  1251. if (empty($temp)) return error_show(1004, "议价原因选择不正确");
  1252. }
  1253. $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  1254. $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  1255. $bargainNo =makeNo("BA");
  1256. Db::startTrans();//::todo 金价 毛利计算
  1257. try{
  1258. $data=[
  1259. "bidsNo"=>$bidNo,
  1260. "infoNo"=>$info['infoNo'],
  1261. "zxNo"=>$info['zxNo'],
  1262. "bargainNo"=>$bargainNo,
  1263. "bargain_type"=>1,
  1264. "bargain_reason"=>$bargain_reason,
  1265. "sale_price"=>$info['sale_price'],
  1266. "cost_before_price"=>$info['sale_cost_fee'],
  1267. "cost_after_price"=>$cost_price,
  1268. "before_rate"=>round(($info['origin_price']-$info['total_fee'])/$info['origin_price'],2),
  1269. "after_rate"=>round(($bargain_price-$info['total_fee'])/$bargain_price,2),
  1270. "after_price"=>$bargain_price,
  1271. "exam_info"=>"",
  1272. "status"=>0,
  1273. "is_del"=>0,
  1274. "creater"=>$creater,
  1275. "createrid"=>$createrid,
  1276. "addtime"=>date("Y-m-d H:i:s"),
  1277. "updatetime"=>date("Y-m-d H:i:s"),
  1278. 'bargain_remark'=>$bargain_remark,
  1279. 'result_info_id'=>$result_info_id,
  1280. ];
  1281. $int = Db::name("bargain_order")->insertGetId($data);
  1282. if($int){
  1283. //修改状态,添加待办
  1284. ActionLog::logAdd($this->post['token'], [
  1285. "order_code" => $bargainNo,//咨询单详情编号
  1286. "status" => 0,//这里的status是之前的值
  1287. "action_remark" => '',//备注
  1288. "action_type" => "status"//新建create,编辑edit,更改状态status
  1289. ], "YJD", $data['status'], $data);
  1290. ProcessOrder::AddProcess($this->post['token'], [
  1291. "order_type" => 'YJD',
  1292. "order_code" => $bargainNo,
  1293. "order_id" => $int,
  1294. "order_status" =>0,
  1295. "before_status"=>0,
  1296. 'holder_id'=>$data['createrid']
  1297. ]);
  1298. $odlstatus=$info['status'];
  1299. $info['status']=3;
  1300. $info['updatetime']=date("Y-m-d H:i:s");
  1301. $up =Db::name("consult_bids")->save($info);
  1302. if($up){
  1303. //修改状态,添加待办
  1304. ActionLog::logAdd($this->post['token'], [
  1305. "order_code" => $bidNo,//咨询单详情编号
  1306. "status" => $odlstatus,//这里的status是之前的值
  1307. "action_remark" => '',//备注
  1308. "action_type" => "status"//新建create,编辑edit,更改状态status
  1309. ], "FKD", $info['status'], $info);
  1310. $old_infos_status = $infos['status'];
  1311. $infos['status']=3;
  1312. $infos['updatetime']=date("Y-m-d H:i:s");
  1313. $ups =Db::name("consult_info")->save($infos);
  1314. if($ups){
  1315. //修改状态,添加待办
  1316. ActionLog::logAdd($this->post['token'], [
  1317. "order_code" => $infos['infoNo'],//咨询单详情编号
  1318. "status" => $old_infos_status,//这里的status是之前的值
  1319. "action_remark" => '',//备注
  1320. "action_type" => "status"//新建create,编辑edit,更改状态status
  1321. ], "ZXD", $infos['status'], $infos);
  1322. //维护台账信息
  1323. Db::name('standing_book')->where('infoNo', $info['infoNo'])->update(['bargainNo' => $bargainNo,'updatetime' => date('Y-m-d H:i:s')]);
  1324. Db::commit();
  1325. return app_show(0,"议价单生成成功",["bargainNo"=>$bargainNo]);
  1326. }
  1327. }
  1328. }
  1329. Db::rollback();
  1330. return error_show(1004,"议价单新建失败");
  1331. }catch (\Exception $e){
  1332. Db::rollback();
  1333. return error_show(1004,$e->getMessage());
  1334. }
  1335. }
  1336. //选择商品
  1337. public function bids_check(){
  1338. $bidNo = isset($this->post['bidNo'])&& $this->post['bidNo']!=""?trim($this->post['bidNo']):"";
  1339. if($bidNo===""){
  1340. return error_show(1004,"参数bidNo不能为空");
  1341. }
  1342. $info =Db::name("consult_bids")->where(['bidNo'=>$bidNo,"is_del"=>0])->find();
  1343. if($info==false){
  1344. return error_show(1004,"未找到商品数据");
  1345. }
  1346. $infos =Db::name("consult_info")->where(['infoNo'=>$info['infoNo'],"is_del"=>0])->find();
  1347. if($infos==false){
  1348. return error_show(1004,"未找到商品数据");
  1349. }
  1350. if($infos['status']!=2&&$infos['status']!=3&&$infos['status']!=7){
  1351. return error_show(1004,"咨询单招标未结束或已确认商品");
  1352. }
  1353. Db::startTrans();
  1354. try {
  1355. $oldstattus=$info['status'];
  1356. $info['status']=6;
  1357. $info['updatetime']=date("Y-m-d H:i:s");
  1358. $bids = Db::name("consult_bids")->save($info);
  1359. if($bids){
  1360. //修改状态,添加待办
  1361. ActionLog::logAdd($this->post['token'], [
  1362. "order_code" =>$bidNo,//咨询单详情编号
  1363. "status" => $oldstattus,//这里的status是之前的值
  1364. "action_remark" => '',//备注
  1365. "action_type" => "status"//新建create,编辑edit,更改状态status
  1366. ], "FKD", $info['status'], $info);
  1367. $old_infos_status = $infos['status'];
  1368. $infos['status']=4;
  1369. $infos['updatetime']=date("Y-m-d H:i:s");
  1370. $se = Db::name("consult_info")->save($infos);
  1371. if($se){
  1372. //修改状态,添加待办
  1373. ActionLog::logAdd($this->post['token'], [
  1374. "order_code" => $infos['infoNo'],//咨询单详情编号
  1375. "status" => $old_infos_status,//这里的status是之前的值
  1376. "action_remark" => '',//备注
  1377. "action_type" => "status"//新建create,编辑edit,更改状态status
  1378. ], "ZXD", $infos['status'], $infos);
  1379. Db::name("bargain_order")->where(["bidsNo"=>$bidNo,"is_del"=>0,"status"=>[0,2,4,5,7]])
  1380. ->update(['status'=>12,"remark"=>'已选择商品,取消议价',"updatetime"=>date("Y-m-d H:i:s")]);
  1381. Db::commit();
  1382. return app_show(0,"商品确定成功");
  1383. }
  1384. }
  1385. Db::rollback();
  1386. return error_show(1004,"商品确认失败");
  1387. }catch (\Exception $e){
  1388. Db::rollback();
  1389. return error_show(1004,$e->getMessage());
  1390. }
  1391. }
  1392. //议价审核
  1393. /**
  1394. * status:
  1395. * 0待审核 1业务主管审核通过 2 业务税率未通过 3 业务驳回 4 专员通过 5 专员驳回 6 财务通过 7 财务税率未通过 8财务驳回 9 boss通过 10 boss 税率越线通过 11 驳回
  1396. */
  1397. public function bargain_status(){
  1398. $bargainNo = isset($this->post['bargainNo'])&& $this->post['bargainNo']!=""?trim($this->post['bargainNo']):"";
  1399. if($bargainNo===""){
  1400. return error_show(1004,"参数bargainNo不能为空");
  1401. }
  1402. $info =Db::name("bargain_order")->where(['bargainNo'=>$bargainNo,"is_del"=>0])->find();
  1403. if($info==false){
  1404. return error_show(1004,"未找到议价数据");
  1405. }
  1406. if($info['status']==12){
  1407. return error_show(1004,"议价单已取消");
  1408. }
  1409. $bids=Db::name("consult_bids")->where(["bidNo"=>$info["bidsNo"],"is_del"=>0])->find();
  1410. if($bids==false){
  1411. return error_show(1004,"未找到商品数据");
  1412. }
  1413. $coninfo=Db::name("consult_info")->where(["infoNo"=>$bids["infoNo"],"is_del"=>0])->find();
  1414. if($coninfo==false){
  1415. return error_show(1004,"未找到咨询单数据");
  1416. }
  1417. if($bids['status']==6){
  1418. return error_show(1004,"咨询已选择商品");
  1419. }
  1420. $status = isset($this->post['status'])&& $this->post['status']!=='' ? intval($this->post['status']):"";
  1421. if($status===''){
  1422. return error_show(1005,"参数status不能为空");
  1423. }
  1424. $catinfo = Db::name("cat")->where(["id"=>$bids['cat_id']])->find();
  1425. $budget = isset($catinfo['order_rate']) ? $catinfo['order_rate']/100:0;
  1426. $rate = isset($catinfo['rate']) ? $catinfo['rate']/100:0; //业务主管利率
  1427. $money_rate = isset($catinfo['money_rate']) ? $catinfo['money_rate']/100:0;//财务主管利率
  1428. $lower_rate = isset($catinfo['lower_rate']) ? $catinfo['lower_rate']/100:0;//boss主管利率
  1429. if($bids['is_gold_price']==1){
  1430. $gold = Db::name("gold_price1")->where(["type"=>$bids['metal_id'],"is_del"=>0,"status"=>1])->order("addtime desc")
  1431. ->find();
  1432. // $saleprice = $open_fee/$zxinfo['num'] + $weight* $gold["price"] + $cost_fee/(1-$budget)* $weight+$pakge_fee+$mark_fee+$cert_fee+$nake_fee;
  1433. //$saleprice(最终售价) = (开模费/购买数量 + 商品重量* 最新金价 + 工艺费* 商品重量+包装费+加标费+证书费+产品裸价)/(1-成本售价/100);
  1434. $total_fe= $bids['demo_fee'] / $coninfo['num']+$bids['delivery_fee']+$bids['open_fee'] / $coninfo['num'] +
  1435. $bids['good_weight']*$gold["price"] +$bids['cost_fee']*$bids['good_weight'] + $bids['pakge_fee'] +$bids['mark_fee'] + $bids['cert_fee'] + $bids['nake_fee'];
  1436. $saleprice =$total_fe / (1 - $budget);
  1437. $rate_price = $total_fe / (1 - $rate);
  1438. $money_price =$total_fe / (1 - $money_rate);
  1439. $lower_price =$total_fe / (1 - $lower_rate);
  1440. }else{
  1441. $total_fe= $bids['demo_fee']/$coninfo['num']+$bids['delivery_fee']+$bids['open_fee'] /
  1442. $coninfo['num']+$bids['cost_fee']*$bids['good_weight']+$bids['pakge_fee'] +$bids['mark_fee']+ $bids['cert_fee'] + $bids['nake_fee'];
  1443. if($bids['nake_fee']!=0){
  1444. $saleprice = ($total_fe)/ (1 - $budget);
  1445. $rate_price = ($total_fe)/ (1 - $rate);
  1446. $money_price =($total_fe)/ (1 - $money_rate);
  1447. $lower_price = ($total_fe) / (1 - $lower_rate);
  1448. }else{
  1449. $saleprice = $total_fe / (1 - $budget);
  1450. $rate_price =$total_fe/ (1 - $rate);
  1451. $money_price =$total_fe / (1 - $money_rate);
  1452. $lower_price = $total_fe/ (1 - $lower_rate);
  1453. }
  1454. }
  1455. $ra_status = $info['status'];
  1456. if($status==1){
  1457. if($info['status']==0){
  1458. if($info['after_price']<$rate_price){
  1459. $info['status']=2;
  1460. }else{
  1461. $info['status']=1;
  1462. }
  1463. }elseif($info['status']==2){
  1464. $info['status']=4;
  1465. }elseif($info['status']==4||$info['status']==5){
  1466. if($info['after_price']<$money_price){
  1467. $info['status']=7;
  1468. }else{
  1469. $info['status']=6;
  1470. }
  1471. }elseif($info['status']==7){
  1472. $info['lower_price'] =$lower_price;
  1473. if($info['after_price']<$lower_price){
  1474. $info['status']=10;
  1475. }else{
  1476. $info['status']=9;
  1477. }
  1478. }
  1479. }else{
  1480. if($info['status']==0){
  1481. $info['status']=3;
  1482. }elseif($info['status']==2){
  1483. $info['status']=4;
  1484. }elseif($info['status']==4||$info['status']==5){
  1485. $info['status']=8;
  1486. }elseif($info['status']==7){
  1487. $info['lower_price'] =$lower_price;
  1488. $info['status']=11;
  1489. }
  1490. }
  1491. $remark = isset($this->post['remark'])&& $this->post['remark']!=""?trim($this->post['remark']):"";
  1492. $token = isset($this->post['token'])&& $this->post['token']!='' ? trim($this->post['token']):"";
  1493. if($token==''){
  1494. return error_show(105,"参数token不能为空");
  1495. }
  1496. $user =GetUserInfo($token);
  1497. if(empty($user)||$user['code']!=0){
  1498. return error_show(1002,"用户数据不存在");
  1499. }
  1500. $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  1501. $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  1502. Db::startTrans();
  1503. try{
  1504. $examinfo = isset($info['exam_info'])&&$info['exam_info']!="" ? json_decode($info['exam_info'],true):[];
  1505. $examinfo[]=["status"=>$status,"info_status"=>$ra_status,"remark"=>$remark,"createrid"=>$createrid,
  1506. "creater"=>$creater];
  1507. // $info['status'] =$status;
  1508. $info['remark'] =$remark;
  1509. $info['exam_info']=json_encode($examinfo) ;
  1510. $info['updatetime'] =date("Y-m-d H:i:s");
  1511. $up =Db::name("bargain_order")->save($info);
  1512. if($up){
  1513. //修改状态,添加待办
  1514. ActionLog::logAdd($this->post['token'], [
  1515. "order_code" => $bargainNo,//咨询单详情编号
  1516. "status" =>$ra_status,//这里的status是之前的值
  1517. "action_remark" => '',//备注
  1518. "action_type" => "status"//新建create,编辑edit,更改状态status
  1519. ], "YJD", $info['status'], $info);
  1520. $process=["order_code"=>$bargainNo,"order_id"=>$info['id'],"order_status"=>$info['status'],"order_type"=>'YJD',"before_status"=>$ra_status,'holder_id'=>$info['createrid']
  1521. ];
  1522. ProcessOrder::AddProcess($token,$process);
  1523. if($info['status']==1||$info['status']==3||$info['status']==8||$info['status']==6||$info['status']==9||$info['status']==10||$info['status']==11){
  1524. $bidstatus=$bids['status'];
  1525. $bids['status']=5;
  1526. if($info['status']==1||$info['status']==6||$info['status']==9||$info['status']==10){
  1527. $bids['sale_price']=$info['after_price'];
  1528. if($bids['is_gold_price']==1){
  1529. // $gold = Db::name("gold_price1")->where(["type"=>$bids['metal_id'],"is_del"=>0,"status"=>1])->order("addtime desc")
  1530. // ->find();
  1531. // $bids['sale_price']= ($bids['open_fee'] / $coninfo['num'] + $bids['weight'] * $gold["price"] + $info['cost_after_price'] *$bids['weight'] +
  1532. // $bids['pakge_fee'] + $bids['mark_fee'] +$bids['cert_fee'] +$bids['nake_fee']) /(1 - $budget);
  1533. $bids['sale_cost_fee'] = $info['cost_after_price'];
  1534. $bids['gold_price'] =isset($gold["price"])?$gold["price"]:0;
  1535. }
  1536. }
  1537. $bids['updatetime']=date("Y-m-d H:i:s");
  1538. $up =Db::name("consult_bids")->save($bids);
  1539. if($up==false){
  1540. Db::rollback();
  1541. return error_show(1004,"数据更新失败");
  1542. }
  1543. ActionLog::logAdd($this->post['token'], [
  1544. "order_code" => $info["bidsNo"],//咨询单详情编号
  1545. "status" => $bidstatus,//这里的status是之前的值
  1546. "action_remark" => '',//备注
  1547. "action_type" => "status"//新建create,编辑edit,更改状态status
  1548. ], "FKD", $bids['status'], $bids);
  1549. }
  1550. Db::commit();
  1551. return app_show(0,"更新成功");
  1552. }
  1553. }catch (\Exception $e){
  1554. Db::rollback();
  1555. return error_show(1004,$e->getMessage());
  1556. }
  1557. }
  1558. public function bargain_info(){
  1559. $bargainNo = isset($this->post['bargainNo'])&& $this->post['bargainNo']!=""?trim($this->post['bargainNo']):"";
  1560. if($bargainNo===""){
  1561. return error_show(1004,"参数bargainNo不能为空");
  1562. }
  1563. $info =Db::name("bargain_order")->where(['bargainNo'=>$bargainNo,"is_del"=>0])->find();
  1564. if($info==false){
  1565. return error_show(1004,"未找到议价数据");
  1566. }
  1567. $bidinfos = Db::name("consult_bids")->where([["bidNo","=",$info['bidsNo']],["is_del","=",0]])->find();
  1568. if($bidinfos==false){
  1569. return error_show(1004,"未找到商品数据");
  1570. }
  1571. $consultinfos =Db::name("consult_info")->where([["infoNo","=",$bidinfos['infoNo']],["is_del","=",0]])->find();
  1572. if($consultinfos==false){
  1573. return error_show(1004,"未找到咨询商品数据");
  1574. }
  1575. $info['spuCode'] = isset($bidinfos['spuCode'])?$bidinfos['spuCode']:"";
  1576. $info['good_name'] = isset($bidinfos['good_name'])?$bidinfos['good_name']:"";
  1577. $info['good_img'] = isset($bidinfos['good_img'])?$bidinfos['good_img']:"";
  1578. $info['brand_id'] = isset($bidinfos['brand_id'])?$bidinfos['brand_id']:"";
  1579. $info['good_num'] = isset($consultinfos['num'])?$consultinfos['num']:"";
  1580. $info['before_rate'] =round($info['before_rate']*100,2);
  1581. $info['sale_price'] =round($bidinfos['origin_price'],2);
  1582. $info['cost_before_price'] =round($bidinfos['origin_cost_fee'],2);
  1583. $info['after_rate'] = round($info['after_rate']*100,2);
  1584. $info['exam_info'] = isset($info['exam_info'])&&$info['exam_info']!=""?json_decode($info['exam_info'],true):"";
  1585. if($bidinfos['brand_id']!=0){
  1586. $info['brand_id'] = $bidinfos['brand_id'];
  1587. $brand=Db::name("brand")->where(["id"=>$bidinfos['brand_id']])->find();
  1588. $info["brand_name"]=isset($brand['brand_name'])?$brand['brand_name']:"";
  1589. }else{
  1590. $info["brand_name"]="";
  1591. $info["brand_id"]="";
  1592. }
  1593. $catinfo = Db::name("cat")->where(["id"=>$bidinfos['cat_id']])->find();
  1594. $info['can']= isset($bidinfos['cat_id']) && $bidinfos['cat_id'] !=0 ? made($bidinfos['cat_id']):[];
  1595. $unit =Db::name("unit")->where(["id"=>$bidinfos['unit_id']])->find();
  1596. $info['unit'] = isset($unit['unit'])?$unit['unit']:'';
  1597. $bidinfoe = Db::name("consult_info")->where(["infoNo"=>$info["infoNo"]])->find();
  1598. $budget = isset($catinfo['order_rate']) ? $catinfo['order_rate']:0;
  1599. $lower_rate = isset($catinfo['lower_rate']) ? $catinfo['lower_rate']/100:0;//boss主管利率
  1600. $info['budget'] =$budget;
  1601. $info['rate_status'] =0; //利率状态 0 业务主管利率无法通过 1 财务主管利率无法通过 2 boos利率无法通过 3 完全通过
  1602. if($info['after_rate']>=$catinfo['rate']){
  1603. //业务主管利率
  1604. $info['rate_status'] =1;
  1605. }
  1606. elseif ($info['after_rate']>=$catinfo['money_rate']){
  1607. //财务主管利率
  1608. $info['rate_status'] =2;
  1609. }
  1610. elseif ($info['after_rate']>=$catinfo['lower_rate']){
  1611. //boss利率
  1612. $info['rate_status'] =3;
  1613. }
  1614. $god=[
  1615. "metal_id"=>$bidinfos['metal_id'],
  1616. "weight"=>$bidinfos["good_weight"],
  1617. "demo_fee"=>$bidinfos["demo_fee"],
  1618. "delivery_fee"=>$bidinfos["delivery_fee"],
  1619. "open_fee"=>$bidinfos["open_fee"],
  1620. "packing_fee"=>$bidinfos["pakge_fee"],
  1621. "mark_fee"=>$bidinfos["mark_fee"],
  1622. "nake_fee"=>$bidinfos["nake_fee"],
  1623. "cert_fee"=>$bidinfos["cert_fee"],
  1624. "cost_fee"=>$bidinfos["cost_fee"],
  1625. "num"=>$bidinfoe["num"],
  1626. ];
  1627. $info['gold_price']=0;
  1628. $info['noble_weight']=$bidinfos['good_weight'];
  1629. if($bidinfos['is_gold_price']==1 &&$bidinfos['metal_id']>0){
  1630. $gold = Db::name("gold_price1")->where(["type"=>$bidinfos["metal_id"],"is_del"=>0,"status"=>1])->order("addtime desc")
  1631. ->find();
  1632. $info['gold_price'] =$gold['price'];
  1633. $lower_price = ($bidinfos['demo_fee']/$consultinfos['num']+$bidinfos['delivery_fee']+$bidinfos['open_fee']/$consultinfos['num'] + $bidinfos['good_weight']* $gold["price"] +$bidinfos['cost_fee']*$bidinfos['good_weight'] + $bidinfos['pakge_fee'] +$bidinfos['mark_fee'] + $bidinfos['cert_fee'] + $bidinfos['nake_fee']) / (1 - $lower_rate);
  1634. }else{
  1635. if($bidinfos['nake_fee']!=0){
  1636. $lower_price =($bidinfos['demo_fee']/$consultinfos['num']+$bidinfos['delivery_fee']+$bidinfos['open_fee']/$consultinfos['num']+$bidinfos['cost_fee']*$bidinfos['good_weight']+$bidinfos['pakge_fee'] +$bidinfos['mark_fee']+ $bidinfos['cert_fee'] + $bidinfos['nake_fee']) / (1 - $lower_rate);
  1637. }else{
  1638. $lower_price = ($bidinfos['demo_fee']/$consultinfos['num']+$bidinfos['delivery_fee']+$bidinfos['open_fee']/$consultinfos['num']+$bidinfos['cost_fee']*$bidinfos['good_weight']+$bidinfos['pakge_fee'] +$bidinfos['mark_fee']+ $bidinfos['cert_fee'])/ (1 - $lower_rate);
  1639. }
  1640. }
  1641. $info['cost_desc'] =$bidinfos['cost_desc'];
  1642. $info['work_day'] =$bidinfos['work_day'];
  1643. $info['delivery_day'] =$bidinfos['delivery_day'];
  1644. $info['expire_day'] =$bidinfos['expire_day'];
  1645. $info['origin_place'] =$bidinfos['origin_place'];
  1646. $info['origin_addr'] ="";
  1647. if($bidinfos['origin_place']!=''){
  1648. $code = explode(",",$bidinfos['origin_place']);
  1649. $temp=[];
  1650. $temp['provice_code']=isset($code[0])?$code[0]:"";
  1651. $temp['city_code']=isset($code[1])?$code[1]:"";
  1652. $temp['area_code']=isset($code[2])?$code[2]:"";
  1653. $addr= GetAddr(json_encode($temp));
  1654. $info['origin_addr'] = $addr;
  1655. }
  1656. $info['supplierNo'] =$bidinfos['supplierNo'];
  1657. $supplier = Db::name("supplier")->where(["code"=>$info['supplierNo']])->find();
  1658. $info['supplier_name'] = isset($supplier['name'])?$supplier['name']:"";
  1659. $info['pay_way'] =$bidinfos['pay_way'];
  1660. $info['tax'] =$bidinfos['tax'];
  1661. $info['send_way'] =$bidinfos['send_way'];
  1662. $info['metal_id'] =$bidinfos['metal_id'];
  1663. $info['is_gold_price'] =$bidinfos['is_gold_price'];
  1664. $info['config'] =$bidinfos['config'];
  1665. $info['other_config'] =$bidinfos['other_config'];
  1666. $info['weight'] =$bidinfos['weight'];
  1667. $info['good_weight'] =$bidinfos['good_weight'];
  1668. $info['is_diff'] =$bidinfos['is_diff'];
  1669. $info['demo_fee'] =$bidinfos['demo_fee'];
  1670. $info['delivery_fee'] =$bidinfos['delivery_fee'];
  1671. $info['open_fee'] =$bidinfos['open_fee'];
  1672. $info['pakge_fee'] =$bidinfos['pakge_fee'];
  1673. $info['nake_fee'] =$bidinfos['nake_fee'];
  1674. $info['mark_fee'] =$bidinfos['mark_fee'];
  1675. $info['cert_fee'] =$bidinfos['cert_fee'];
  1676. $info['cost_fee'] =$bidinfos['cost_fee'];
  1677. $info['total_fee'] =$bidinfos['total_fee'];
  1678. $info['supply_area'] =$bidinfos['supply_area'];
  1679. $info['remark'] =$bidinfos['remark'];
  1680. $info['is_addrs'] =$consultinfos['is_addrs'];
  1681. $info['is_custom'] =$consultinfos['is_custom'];
  1682. $info['metal_name']=isset($bidinfos['metal_id'])&& $bidinfos['metal_id']!=0?$this->noble[$bidinfos['metal_id']]:"";
  1683. // $info['sale_price'] =round($bidinfos['sale_price'],2);//议价前价格
  1684. $info['specinfo'] = isset($bidinfos['specinfo'])&&$bidinfos['specinfo']!=""?json_decode($bidinfos['specinfo'],true):[];
  1685. if($info['status']==7){
  1686. $info['lower_price'] =round($lower_price,2);
  1687. }
  1688. //获取议价原因
  1689. if ($info['result_info_id'] != 0) {
  1690. $info['result_info'] = Db::name('result_info')->where(['result_code' => $info['result_info_id'], 'type' => 7, 'status' => 1, 'is_del' => 0])->value('result');
  1691. } else {
  1692. $info['result_info'] = '';
  1693. }
  1694. return app_show(0,"获取成功",$info);
  1695. }
  1696. public function bidlist(){
  1697. $page = isset($this->post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) :"1";
  1698. $size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) :"10";
  1699. $where=[['is_del',"=",0]];
  1700. $zxNo = isset($this->post['zxNo']) && $this->post['zxNo'] !== "" ? trim($this->post['zxNo']) : "";
  1701. if ($zxNo !== "") {
  1702. $where[] = ['zxNo','like','%'.$zxNo.'%'];
  1703. }
  1704. $infoNo = isset($this->post['infoNo']) && $this->post['infoNo'] !== "" ? trim($this->post['infoNo']) : "";
  1705. if ($infoNo !== "") {
  1706. $where[] = ['infoNo','like','%'.$infoNo.'%'];
  1707. }
  1708. $bidNo = isset($this->post['bidNo']) && $this->post['bidNo'] !== "" ? trim($this->post['bidNo']) : "";
  1709. if ($bidNo !== "") {
  1710. $where[] = ['bidNo','like','%'.$bidNo.'%'];
  1711. }
  1712. $pgNo = isset($this->post['pgNo']) && $this->post['pgNo'] !== "" ? trim($this->post['pgNo']) : "";
  1713. if ($pgNo !== "") {
  1714. $bidinfo = Db::name("consult_info")->where([["pgNo","=",$pgNo],["is_del","=",0]])->column("infoNo");
  1715. $where[] = ['infoNo','in',$bidinfo];
  1716. }
  1717. $bargain_status = isset($this->post['bargain_status']) && $this->post['bargain_status'] !== "" ? intval($this->post['bargain_status']) : "";
  1718. if ($bargain_status !== "") {
  1719. $bidinfo = Db::name("consult_info")->where([["bargain_status","=",$bargain_status],["is_del","=",0]])->column("infoNo");
  1720. $where[] = ['infoNo','in',$bidinfo];
  1721. }
  1722. $projectNo = isset($this->post['projectNo']) && $this->post['projectNo'] !== "" ? trim($this->post['projectNo']) : "";
  1723. if ($projectNo !== "") {
  1724. $zxlist = Db::name("consult_order")->where(["projectNo"=>$projectNo,"is_del"=>0,"is_project"=>1])->column
  1725. ("zxNo");
  1726. $where[] = ['zxNo','in',$zxlist];
  1727. }
  1728. $is_own = isset($this->post['is_own']) ? intval($this->post['is_own']) : "0";
  1729. if($is_own==1){
  1730. $token = isset($this->post['token']) ? trim($this->post['token']) : "";
  1731. if($token==""){
  1732. return error_show(101,'token不能为空');
  1733. }
  1734. $apply_id =GetUserInfo($token);
  1735. if(empty($apply_id)||$apply_id['code']!=0){
  1736. return error_show(1002,"申请人数据不存在");
  1737. }
  1738. $rm= isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  1739. $where[]=['createrid',"=",$rm];
  1740. }
  1741. $count = Db::name('consult_bids')->where($where)->count();
  1742. $total = ceil($count / $size);
  1743. $page = $page >= $total ? $total : $page;
  1744. $list =Db::name('consult_bids')->where($where)->page($page,$size)->select()->toArray();
  1745. $data=[];
  1746. foreach ($list as $value){
  1747. $catinfo = Db::name("cat")->where(["id"=>$value['cat_id']])->find();
  1748. $value['can']= isset($value['cat_id']) && $value['cat_id'] !=0 ? made($value['cat_id']):[];
  1749. $unit =Db::name("unit")->where(["id"=>$value['unit_id']])->find();
  1750. $value['unit'] = isset($unit['unit'])?$unit['unit']:'';
  1751. $supplier = Db::name("supplier")->where(["code"=>$value['supplierNo']])->find();
  1752. $value['supplierName'] = isset($supplier['name'])?$supplier['name']:"";
  1753. if($value['brand_id']!=0){
  1754. $brand=Db::name("brand")->where(["id"=>$value['brand_id']])->find();
  1755. $value["brand_name"]=isset($brand['brand_name'])?$brand['brand_name']:"";
  1756. }else{
  1757. $value["brand_name"]="";
  1758. $value["brand_id"]="";
  1759. }
  1760. $bidinfo = Db::name("consult_info")->where(["infoNo"=>$value["infoNo"]])->find();
  1761. $budget = isset($catinfo['order_rate']) ? $catinfo['order_rate']:0;
  1762. $god=[
  1763. "metal_id"=>$value['metal_id'],
  1764. "weight"=>$value["good_weight"],
  1765. "demo_fee"=>$value["demo_fee"],
  1766. "delivery_fee"=>$value["delivery_fee"],
  1767. "open_fee"=>$value["open_fee"],
  1768. "packing_fee"=>$value["pakge_fee"],
  1769. "mark_fee"=>$value["mark_fee"],
  1770. "nake_fee"=>$value["nake_fee"],
  1771. "cert_fee"=>$value["cert_fee"],
  1772. // "cost_fee"=>$value["cost_fee"],
  1773. "cost_fee"=>$value["sale_cost_fee"]!=$value['origin_cost_fee']? $value["sale_cost_fee"]: $value["cost_fee"],
  1774. //暂时注掉,搞不清楚原因@吴广广
  1775. "num"=>$bidinfo["num"],
  1776. ];
  1777. $top_cat = made($value['cat_id']);
  1778. $top_cat_id = isset($top_cat[0]['id'])?$top_cat[0]['id']:0;
  1779. if($value['is_gold_price']==1 && $top_cat_id==6 ){
  1780. $price = GoldPrice($god, $budget/100);
  1781. $value['sale_price'] = round($price,2);
  1782. $value['origin_price'] = $value["sale_cost_fee"]!=$value['origin_cost_fee']? $value["sale_price"]:
  1783. $value["origin_price"];
  1784. }
  1785. $value['cost_fee'] =$value['origin_cost_fee'];
  1786. $value['specinfo'] = json_decode($value['specinfo'],true);
  1787. $value['metal_name']=isset($value['metal_id'])&& $value['metal_id']!=0?$this->noble[$value['metal_id']]:"";
  1788. $value['bargain_status']=$bidinfo['bargain_status'];
  1789. //reject驳回原因,status==5表示驳回
  1790. $value['reject']=[];
  1791. if ($value['status'] >=5) {
  1792. $value['reject'] = Db::name('bargain_order')
  1793. ->field('id,remark,status')
  1794. ->where(['infoNo' => $infoNo, 'bidsNo' => $value['bidNo']])
  1795. ->whereIn('status', [3,8,11])->order("id desc")
  1796. ->find();
  1797. }
  1798. //产地
  1799. $place = ["provice_code"=>"","city_code"=>"","area_code"=>""];
  1800. if($value['delivery_place']!=""){
  1801. list($place['provice_code'],$place['city_code'],$place['area_code'])=explode(",",$value['delivery_place']);
  1802. }
  1803. $value['delivery_place_cn']=GetAddr(json_encode($place));
  1804. $place = ["provice_code"=>"","city_code"=>"","area_code"=>""];
  1805. if($value['origin_place']!=""){
  1806. list($place['provice_code'],$place['city_code'],$place['area_code'])=explode(",",$value['origin_place']);
  1807. }
  1808. $value['origin_addr']=GetAddr(json_encode($place));
  1809. // if($value['origin_place']!=''){
  1810. // $code = explode(",",$value['origin_place']);
  1811. // $temp=[];
  1812. // $temp['provice_code']=isset($code[0])?$code[0]:"";
  1813. // $temp['city_code']=isset($code[1])?$code[1]:"";
  1814. // $temp['area_code']=isset($code[2])?$code[2]:"";
  1815. // $addr= GetAddr(json_encode($temp));
  1816. // $value['origin_addr'] = $addr;
  1817. // }
  1818. $good_info = Db::name('good_basic')
  1819. ->field('id,createrid,creater')
  1820. ->where('is_del',0)
  1821. ->where('spuCode',$value['spuCode'])
  1822. ->findOrEmpty();
  1823. $value['good_createrid']=$good_info['createrid']??$value['createrid'];
  1824. $value['good_creater']=$good_info['creater']??$value['creater'];
  1825. $data[] = $value;
  1826. }
  1827. return app_show(0,"获取成功",['count'=>$count,'list'=>$data]);
  1828. }
  1829. public function feedlist(){
  1830. $where=[['is_del',"=",0]];
  1831. $zxNo = isset($this->post['zxNo']) && $this->post['zxNo'] !== "" ? trim($this->post['zxNo']) : "";
  1832. if ($zxNo !== "") {
  1833. $where[] = ['zxNo','=',$zxNo];
  1834. }
  1835. $infoNo = isset($this->post['infoNo']) && $this->post['infoNo'] !== "" ? trim($this->post['infoNo']) : "";
  1836. if ($infoNo !== "") {
  1837. $where[] = ['infoNo','=',$infoNo];
  1838. }
  1839. $bidNo = isset($this->post['bidNo']) && $this->post['bidNo'] !== "" ? trim($this->post['bidNo']) : "";
  1840. if ($bidNo !== "") {
  1841. $where[] = ['bidNo','=',$bidNo];
  1842. }
  1843. $projectNo = isset($this->post['projectNo']) && $this->post['projectNo'] !== "" ? trim($this->post['projectNo']) : "";
  1844. if ($projectNo !== "") {
  1845. $zxlist = Db::name("consult_order")->where(["projectNo"=>$projectNo,"is_del"=>0,"is_project"=>1])->column
  1846. ("zxNo");
  1847. $where[] = ['zxNo','in',$zxlist];
  1848. }
  1849. $token = isset($this->post['token'])&& $this->post['token']!='' ? trim($this->post['token']):"";
  1850. if($token==''){
  1851. return error_show(102,"参数token不能为空");
  1852. }
  1853. $is_own = isset($this->post['is_own']) ? intval($this->post['is_own']) : "0";
  1854. if($is_own==1){
  1855. $token = isset($this->post['token']) ? trim($this->post['token']) : "";
  1856. if($token==""){
  1857. return error_show(101,'token不能为空');
  1858. }
  1859. $apply_id =GetUserInfo($token);
  1860. if(empty($apply_id)||$apply_id['code']!=0){
  1861. return error_show(1002,"申请人数据不存在");
  1862. }
  1863. $rm= isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  1864. $where[]=['createrid',"=",$rm];
  1865. }
  1866. $list =Db::name('consult_bids')->where($where)->select();
  1867. $data=[];
  1868. foreach ($list as $value){
  1869. $catinfo = Db::name("cat")->where(["id"=>$value['cat_id']])->find();
  1870. $value['can']= isset($value['cat_id']) && $value['cat_id'] !=0 ? made($value['cat_id']):[];
  1871. $unit =Db::name("unit")->where(["id"=>$value['unit_id']])->find();
  1872. $value['unit'] = isset($unit['unit'])?$unit['unit']:'';
  1873. $supplier = Db::name("supplier")->where(["code"=>$value['supplierNo']])->find();
  1874. $value['supplierName'] = isset($supplier['name'])?$supplier['name']:"";
  1875. if($value['brand_id']!=0){
  1876. $brand=Db::name("brand")->where(["id"=>$value['brand_id']])->find();
  1877. $value["brand_name"]=isset($brand['brand_name'])?$brand['brand_name']:"";
  1878. }else{
  1879. $value["brand_name"]="";
  1880. $value["brand_id"]="";
  1881. }
  1882. $bidinfo = Db::name("consult_info")->where(["infoNo"=>$value["infoNo"]])->find();
  1883. $budget = isset($catinfo['order_rate']) ? $catinfo['order_rate']:0;
  1884. $god=[
  1885. "metal_id"=>$value['metal_id'],
  1886. "weight"=>$value["good_weight"],
  1887. "demo_fee"=>$value["demo_fee"],
  1888. "delivery_fee"=>$value["delivery_fee"],
  1889. "open_fee"=>$value["open_fee"],
  1890. "packing_fee"=>$value["pakge_fee"],
  1891. "mark_fee"=>$value["mark_fee"],
  1892. "nake_fee"=>$value["nake_fee"],
  1893. "cert_fee"=>$value["cert_fee"],
  1894. "cost_fee"=>$value["cost_fee"],
  1895. "num"=>$bidinfo["num"],
  1896. ];
  1897. if ($value['is_gold_price'] == 1 ) {
  1898. $gold = Db::name("gold_price1")->where(["type"=>$value['metal_id'],"is_del"=>0,"status"=>1])->order("addtime desc")
  1899. ->find();
  1900. //$total_fee(成本合计初始价格) =打样费/购买数量 + 开模费/购买数量 + 商品重量* 最新金价 + 工艺费* 商品重量+包装费+加标费+证书费+产品裸价0+运费;
  1901. //$saleprice(最终售价) = (开模费/购买数量 + 商品重量* 最新金价 + 工艺费* 商品重量+包装费+加标费+证书费+产品裸价)/(1-成本售价/100);
  1902. $saleprice = ($value['demo_fee']/$bidinfo['num']+$value['delivery_fee']+$value["open_fee"]/$bidinfo['num'] +$value["good_weight"] *$gold["price"] +
  1903. $value["cost_fee"] * $value["good_weight"] + $value["pakge_fee"]+ $value["mark_fee"] +$value["cert_fee"] +$value["nake_fee"]) / (1 - $budget);
  1904. // //销售工艺费=((开模费/购买数量 + 商品重量* 最新金价 + 工艺费* 商品重量+包装费+加标费+证书费+产品裸价)/(1-成本售价/100)-(打样费/购买数量 + 开模费/购买数量 +包装费+加标费+证书费+产品裸价0+运费) )/商品重量-最新金价
  1905. // $sale_cost_fee = (($open_fee / $zxinfo['num'] + $weight * $gold["price"] + $cost_fee * $weight + $pakge_fee + $mark_fee + $cert_fee + $nake_fee) / (1 - $budget) - ($demo_fee / $zxinfo['num'] + $open_fee / $zxinfo['num'] + $pakge_fee + $mark_fee + $cert_fee + $nake_fee + $delivery_fee)) / $weight - $gold["price"];
  1906. }else{
  1907. if($value["nake_fee"]){
  1908. $saleprice = ($value['demo_fee']/$bidinfo['num']+$value['delivery_fee']+$value["open_fee"]/$bidinfo['num']+$value["cost_fee"] * $value["good_weight"]+ $value["pakge_fee"]+ $value["mark_fee"] +$value["cert_fee"] +$value["nake_fee"])/ (1 - $budget);
  1909. }else{
  1910. $saleprice = ($value['demo_fee']/$bidinfo['num']+$value['delivery_fee']+$value["open_fee"]/$bidinfo['num']+$value["cost_fee"] * $value["good_weight"]+ $value["pakge_fee"]+ $value["mark_fee"] +$value["cert_fee"] +$value["nake_fee"]) /
  1911. (1 - $budget);
  1912. }
  1913. }
  1914. $value['metal_name']=isset($value['metal_id'])&& $value['metal_id']!=0?$this->noble[$value['metal_id']]:"";
  1915. $value['specinfo'] = json_decode($value['specinfo'],true);
  1916. $value['bargain_status']=$bidinfo['bargain_status'];
  1917. $data[]=$value;
  1918. }
  1919. return app_show(0,"获取成功",$data);
  1920. }
  1921. public function bragain_list(){
  1922. $page = isset($this->post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) :"1";
  1923. $size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) :"10";
  1924. $where=[['bo.is_del',"=",0]];
  1925. $bidsNo = isset($this->post['bidsNo'])&&$this->post['bidsNo']!=""?trim($this->post['bidsNo']):"";
  1926. if($bidsNo!=""){
  1927. $where[]=["bo.bidsNo","like","%$bidsNo%"];
  1928. }
  1929. $zxNo = isset($this->post['zxNo']) && $this->post['zxNo'] !== "" ? trim($this->post['zxNo']) : "";
  1930. if ($zxNo !== "") {
  1931. $where[] = ['bo.zxNo','like',"%$zxNo%"];
  1932. }
  1933. $bargainNo = isset($this->post['bargainNo']) && $this->post['bargainNo'] !== "" ? trim($this->post['bargainNo']) : "";
  1934. if ($bargainNo !== "") {
  1935. $where[] = ['bo.bargainNo','like',"%$bargainNo%"];
  1936. }
  1937. $status = isset($this->post['status']) && $this->post['status'] !== "" ? intval($this->post['status']) : "";
  1938. if ($status!== "") {
  1939. $where[] = ['bo.status','=',$status];
  1940. }
  1941. $infoNo = isset($this->post['infoNo']) && $this->post['infoNo'] !== "" ? trim($this->post['infoNo']) : "";
  1942. if ($infoNo !== "") {
  1943. $where[] = ['bo.infoNo','like',"%$infoNo%"];
  1944. }
  1945. $projectNo = isset($this->post['projectNo']) && $this->post['projectNo'] !== "" ? trim($this->post['projectNo']) : "";
  1946. if ($projectNo !== "") {
  1947. $zxlist = Db::name("consult_order")->where(["projectNo"=>$projectNo,"is_del"=>0,"is_project"=>1])->column
  1948. ("zxNo");
  1949. $where[] = ['bo.zxNo','in',$zxlist];
  1950. }
  1951. $pgNo = isset($this->post['pgNo']) && $this->post['pgNo'] !== "" ? trim($this->post['pgNo']) : "";
  1952. if ($pgNo !== "") {
  1953. $bidinfo = Db::name("consult_info")->where([["pgNo","=",$pgNo],["is_del","=",0]])->column("infoNo");
  1954. $where[] = ['bo.infoNo','in',$bidinfo];
  1955. }
  1956. $start= isset($this->post['start']) && $this->post['start'] !== "" ? $this->post['start'] : "";
  1957. $end= isset($this->post['end']) && $this->post['end'] !== "" ? $this->post['end'] : "";
  1958. if($start!=""){
  1959. $where[]=["bo.addtime",">=",date("Y-m-d H:i:s",strtotime($start))];
  1960. }
  1961. if($end!=""){
  1962. $where[]=["bo.addtime","<=",date("Y-m-d H:i:s",strtotime($end))];
  1963. }
  1964. $company_name = isset($this->post['company_name']) && $this->post['company_name'] !== "" ? trim($this->post['company_name']) : "";
  1965. if ($company_name !== "") $where[] = ["bo.createrid", 'in', get_company_item_user_by_name($company_name)];
  1966. $role=$this->checkRole();
  1967. if(!empty($role['write'])){
  1968. $where[]=["bo.createrid","in",$role['write']];
  1969. }
  1970. $count=Db::name("bargain_order")->alias('bo')->leftJoin("depart_user u", "u.uid=bo.createrid AND u.is_del=0")->where($where)->count();
  1971. $total = ceil($count / $size);
  1972. $page = $page >= $total ? $total : $page;
  1973. $list = Db::name('bargain_order')
  1974. ->alias('bo')
  1975. ->field('bo.*,u.itemid')
  1976. ->leftJoin("depart_user u", "u.uid=bo.createrid AND u.is_del=0")
  1977. ->where($where)
  1978. ->page($page, $size)
  1979. ->order('bo.addtime', 'desc')
  1980. ->cursor();
  1981. $data=[];
  1982. foreach ($list as $value){
  1983. $bidinfos = Db::name("consult_bids")->where([["bidNo","=",$value['bidsNo']],["is_del","=",0]])->find();
  1984. $value['spuCode'] = isset($bidinfos['spuCode'])?$bidinfos['spuCode']:"";
  1985. $value['good_name'] = isset($bidinfos['good_name'])?$bidinfos['good_name']:"";
  1986. $value['good_img'] = isset($bidinfos['good_img'])?$bidinfos['good_img']:"";
  1987. $value['brand_id'] = isset($bidinfos['brand_id'])?$bidinfos['brand_id']:"";
  1988. if($bidinfos['brand_id']!=0){
  1989. $value['brand_id'] = $bidinfos['brand_id'];
  1990. $brand=Db::name("brand")->where(["id"=>$bidinfos['brand_id']])->find();
  1991. $value["brand_name"]=isset($brand['brand_name'])?$brand['brand_name']:"";
  1992. }else{
  1993. $value["brand_name"]="";
  1994. $value["brand_id"]="";
  1995. }
  1996. $catinfo = Db::name("cat")->where(["id"=>$bidinfos['cat_id']])->find();
  1997. $value['can']= isset($bidinfos['cat_id']) && $bidinfos['cat_id'] !=0 ? made($bidinfos['cat_id']):[];
  1998. $unit =Db::name("unit")->where(["id"=>$bidinfos['unit_id']])->find();
  1999. $value['unit'] = isset($unit['unit'])?$unit['unit']:'';
  2000. $bidinfoe = Db::name("consult_info")->where(["infoNo"=>$value["infoNo"]])->find();
  2001. $budget = isset($catinfo['order_rate']) ? $catinfo['order_rate']:0;
  2002. $value['budget'] =$budget;
  2003. $god=[
  2004. "metal_id"=>$bidinfos['metal_id'],
  2005. "weight"=>$bidinfos["good_weight"],
  2006. "demo_fee"=>$bidinfos["demo_fee"],
  2007. "delivery_fee"=>$bidinfos["delivery_fee"],
  2008. "open_fee"=>$bidinfos["open_fee"],
  2009. "packing_fee"=>$bidinfos["pakge_fee"],
  2010. "mark_fee"=>$bidinfos["mark_fee"],
  2011. "nake_fee"=>$bidinfos["nake_fee"],
  2012. "cert_fee"=>$bidinfos["cert_fee"],
  2013. "cost_fee"=>$bidinfos["cost_fee"],
  2014. "num"=>$bidinfoe["num"],
  2015. ];
  2016. // if($bidinfos['is_gold_price']==1){
  2017. // $price = GoldPrice($god, $budget/100);
  2018. // }else{
  2019. // $price = GoodPrice($god, $budget/100);
  2020. // }
  2021. $value['metal_name']=isset($bidinfos['metal_id'])&& $bidinfos['metal_id']!=0?$this->noble[$bidinfos['metal_id']]:"";
  2022. $value['sale_price'] =round($bidinfos['origin_price'],2);
  2023. $value['cost_before_price'] =round($bidinfos['origin_cost_fee'],2);
  2024. $value['specinfo'] = isset($bidinfos['specinfo'])&&$bidinfos['specinfo']!=""?json_decode($bidinfos['specinfo'],true):[];
  2025. $value['company_name'] = implode('/', array_column(GetPart($value['itemid']), 'name'));
  2026. $data[]=$value;
  2027. }
  2028. return app_show(0,"获取成功",["list"=>$data,"count"=>$count]);
  2029. }
  2030. public function crontablist(){
  2031. $page = isset($this->post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) :"1";
  2032. $size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) :"10";
  2033. $where=[['a.is_del',"=",0],['b.is_del',"=",0]];
  2034. $zxNo = isset($this->post['zxNo']) && $this->post['zxNo'] !== "" ? trim($this->post['zxNo']) : "";
  2035. if ($zxNo !== "") {
  2036. $where[] = ['a.zxNo','=',$zxNo];
  2037. }
  2038. $salesman = isset($this->post['salesman']) && $this->post['salesman'] !== "" ? trim($this->post['salesman']) : "";
  2039. if ($salesman !== "") {
  2040. //$where["salesman"] =Db::Raw("like '%$salesman%'");
  2041. $where[]= ["b.salesman",'like',"%$salesman%"];
  2042. }
  2043. $cpName = isset($this->post['cpName']) && $this->post['cpName'] !== "" ? trim($this->post['cpName']) : "";
  2044. if ($cpName !== "") {
  2045. //$where["cpName"]= Db::Raw("like '%$cpName%'");
  2046. $where[]= ["a.good_Name",'like',"%$cpName%"];
  2047. }
  2048. $khNo = isset($this->post['khNo']) && $this->post['khNo'] !== "" ? trim($this->post['khNo']) : "";
  2049. if ($khNo !== "") {
  2050. // $where['khNo'] = $khNo;
  2051. $where[]= ["b.khNo",'like',"%$khNo%"];
  2052. }
  2053. $start= isset($this->post['start']) && $this->post['start'] !== "" ? $this->post['start']:"";
  2054. if ($start !="") {
  2055. //$where = ["zxtime"=>Db::raw(">= '{$start}'")];
  2056. $where[]= ["a.addtime",'>=',$start];
  2057. }
  2058. $end = isset($this->post['end']) && $this->post['end'] !== "" ? $this->post['end'] :"";
  2059. if($end !=""){
  2060. $where[]= ["a.addtime",'<=',$end];
  2061. }
  2062. $status = isset($this->post['status']) && $this->post['status'] !== "" ? trim($this->post['status']) : "";
  2063. if ($status !== "") {
  2064. $where[]= ["a.status",'=',$status];
  2065. }
  2066. // $role=$this->checkRole();
  2067. // if(!empty($role['platform']) ){
  2068. // $where[]=["b.platform_code","in",$role['platform']];
  2069. // }
  2070. $count = Db::name('consult_info')->alias("a")->leftJoin("consult_order b","a.zxNo=b.zxNo")->where($where)
  2071. ->count();
  2072. $total = ceil($count / $size);
  2073. $page = $page >= $total ? $total : $page;
  2074. $list =Db::name('consult_info')->alias("a")->leftJoin("consult_order b","a.zxNo=b.zxNo")->where($where)->page($page,$size)
  2075. ->field("a.*,b.createrid,b.creater,b.is_project,b.projectNo,b.khNo,b.endtime,b.platform_code,b.saleid,b.salesman,b.depart")->select();
  2076. $data=[];
  2077. foreach ($list as $value){
  2078. $value['can']= isset($value['cat_id']) && $value['cat_id'] !=0 ? made($value['cat_id']):[];
  2079. $cat =Db::name("cat")->where(["id"=>$value['cat_id']])->find();
  2080. $budget = isset($cat['order_rate']) ? $cat['order_rate']:0;
  2081. $value['original_price']=sprintf("%.2f",$value['budget_price']* (1 -$budget/100));
  2082. $brand = Db::name("brand")->where(['id'=>$value['brand_id']])->find();
  2083. $value['brand_name']= isset($brand['brand_name']) && $brand['brand_name']!='' ? $brand['brand_name']:"";
  2084. $value['khname']="";
  2085. $value['specinfo']=isset($value['specinfo'])&&$value['specinfo']!=""? json_decode($value['specinfo'],
  2086. true):[];
  2087. if($value['khNo']!==""){
  2088. $kh=Db::name("customer_info")->where(['companyNo'=>$value['khNo']])->find();
  2089. $value['khname']= isset($kh['companyName'])?$kh['companyName']:"";
  2090. }
  2091. $consult =Db::name("consult_bids")->where(["infoNo"=>$value['infoNo'],"createrid"=>$this->uid,"is_del"=>0])
  2092. ->find();
  2093. $consults =Db::name("consult_bids")->where(["infoNo"=>$value['infoNo'],"is_del"=>0])->find();
  2094. $value['is_feed'] =$consult==false?0:1;
  2095. $value['is_all_feed'] =$consults==false?0:1;
  2096. $value['metal_name']=isset($value['metal_id'])&& $value['metal_id']!=0?$this->noble[$value['metal_id']]:"";
  2097. $data[]=$value;
  2098. }
  2099. return app_show(0,"获取成功",['count'=>$count,'list'=>$data]);
  2100. }
  2101. //复制上面的bidlist方法,只更改排序方式
  2102. public function bidlistCopy()
  2103. {
  2104. $page = isset($this->post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) : "1";
  2105. $size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) : "10";
  2106. $where = [['cb.is_del', "=", 0],['c.status','<>',6]];//不要'取消转单'状态下的数据
  2107. $zxNo = isset($this->post['zxNo']) && $this->post['zxNo'] !== "" ? trim($this->post['zxNo']) : "";
  2108. if ($zxNo !== "") $where[] = ['cb.zxNo', 'like', '%' . $zxNo . '%'];
  2109. $infoNo = isset($this->post['infoNo']) && $this->post['infoNo'] !== "" ? trim($this->post['infoNo']) : "";
  2110. if ($infoNo !== "") $where[] = ['cb.infoNo', 'like', '%' . $infoNo . '%'];
  2111. $bidNo = isset($this->post['bidNo']) && $this->post['bidNo'] !== "" ? trim($this->post['bidNo']) : "";
  2112. if ($bidNo !== "") $where[] = ['cb.bidNo', 'like', '%' . $bidNo . '%'];
  2113. $pgNo = isset($this->post['pgNo']) && $this->post['pgNo'] !== "" ? trim($this->post['pgNo']) : "";
  2114. if ($pgNo !== "") {
  2115. $bidinfo = Db::name("consult_info")->where([["pgNo", "=", $pgNo], ["is_del", "=", 0]])->column("infoNo");
  2116. $where[] = ['cb.infoNo', 'in', $bidinfo];
  2117. }
  2118. $bargain_status = isset($this->post['bargain_status']) && $this->post['bargain_status'] !== "" ? intval($this->post['bargain_status']) : "";
  2119. if ($bargain_status !== "") {
  2120. $bidinfo = Db::name("consult_info")->where([["bargain_status", "=", $bargain_status], ["is_del", "=", 0]])->column("infoNo");
  2121. $where[] = ['cb.infoNo', 'in', $bidinfo];
  2122. }
  2123. $projectNo = isset($this->post['projectNo']) && $this->post['projectNo'] !== "" ? trim($this->post['projectNo']) : "";
  2124. if ($projectNo !== "") {
  2125. $zxlist = Db::name("consult_order")->where(["projectNo" => $projectNo, "is_del" => 0, "is_project" => 1])->column("zxNo");
  2126. $where[] = ['cb.zxNo', 'in', $zxlist];
  2127. }
  2128. $is_own = isset($this->post['is_own']) ? intval($this->post['is_own']) : "0";
  2129. if ($is_own == 1) {
  2130. $token = isset($this->post['token']) ? trim($this->post['token']) : "";
  2131. if ($token == "") return error_show(101, 'token不能为空');
  2132. $apply_id = GetUserInfo($token);
  2133. if (empty($apply_id) || $apply_id['code'] != 0) return error_show(1002, "申请人数据不存在");
  2134. $rm = isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  2135. $where[] = ['cb.createrid', "=", $rm];
  2136. }
  2137. $company_name = isset($this->post['company_name']) && $this->post['company_name'] !== "" ? trim($this->post['company_name']) : "";
  2138. if ($company_name !== "") $where[] = ["cb.createrid", 'in', get_company_item_user_by_name($company_name)];
  2139. $good_name = isset($this->post['good_name']) && $this->post['good_name'] !== "" ? trim($this->post['good_name']) : "";
  2140. if ($good_name !== "") $where[] = ["cb.good_name", 'like', '%' . $good_name . '%'];
  2141. $supplierName = isset($this->post['supplierName']) && $this->post['supplierName'] !== "" ? trim($this->post['supplierName']) : "";
  2142. if ($supplierName !== "") $where[] = ["s.name", 'like', '%' . $supplierName . '%'];
  2143. $count = Db::name('consult_bids')
  2144. ->alias('cb')
  2145. ->leftJoin("depart_user u", "u.uid=cb.createrid AND u.is_del=0")
  2146. ->leftJoin("consult_info c", "c.infoNo=cb.infoNo")
  2147. ->leftJoin('supplier s', 's.code=cb.supplierNo')
  2148. ->where($where)
  2149. ->count();
  2150. $total = ceil($count / $size);
  2151. $page = $page >= $total ? $total : $page;
  2152. $list = Db::name('consult_bids')
  2153. ->alias('cb')
  2154. ->field('cb.*,u.itemid,s.name supplierName')
  2155. ->leftJoin("depart_user u", "u.uid=cb.createrid AND u.is_del=0")
  2156. ->leftJoin("consult_info c", "c.infoNo=cb.infoNo")
  2157. ->leftJoin('supplier s', 's.code=cb.supplierNo')
  2158. ->where($where)
  2159. ->page($page, $size)
  2160. ->order('cb.addtime', 'desc')
  2161. ->cursor();
  2162. $data = [];
  2163. foreach ($list as $value) {
  2164. $catinfo = Db::name("cat")->where(["id" => $value['cat_id']])->find();
  2165. $value['can'] = isset($value['cat_id']) && $value['cat_id'] != 0 ? made($value['cat_id']) : [];
  2166. $unit = Db::name("unit")->where(["id" => $value['unit_id']])->find();
  2167. $value['unit'] = isset($unit['unit']) ? $unit['unit'] : '';
  2168. // $supplier = Db::name("supplier")->where(["code" => $value['supplierNo']])->find();
  2169. // $value['supplierName'] = isset($supplier['name']) ? $supplier['name'] : "";
  2170. if ($value['brand_id'] != 0) {
  2171. $brand = Db::name("brand")->where(["id" => $value['brand_id']])->find();
  2172. $value["brand_name"] = isset($brand['brand_name']) ? $brand['brand_name'] : "";
  2173. } else {
  2174. $value["brand_name"] = "";
  2175. $value["brand_id"] = "";
  2176. }
  2177. $bidinfo = Db::name("consult_info")->where(["infoNo" => $value["infoNo"]])->find();
  2178. $budget = isset($catinfo['order_rate']) ? $catinfo['order_rate'] : 0;
  2179. $god = [
  2180. "metal_id" => $value['metal_id'],
  2181. "weight" => $value["good_weight"],
  2182. "demo_fee" => $value["demo_fee"],
  2183. "delivery_fee" => $value["delivery_fee"],
  2184. "open_fee" => $value["open_fee"],
  2185. "packing_fee" => $value["pakge_fee"],
  2186. "mark_fee" => $value["mark_fee"],
  2187. "nake_fee" => $value["nake_fee"],
  2188. "cert_fee" => $value["cert_fee"],
  2189. "cost_fee" => $value["sale_cost_fee"]!=$value["origin_cost_fee"] ? $value["sale_cost_fee"] : $value["cost_fee"],
  2190. "num" => $bidinfo["num"],
  2191. ];
  2192. if ($value['is_gold_price'] == 1) {
  2193. $price = GoldPrice($god, $budget / 100);
  2194. $value['sale_price'] = round($price, 2);
  2195. }
  2196. $value['cost_fee'] = $value['origin_cost_fee'];
  2197. $value['specinfo'] = json_decode($value['specinfo'], true);
  2198. $value['metal_name'] = isset($value['metal_id']) && $value['metal_id'] != 0 ? $this->noble[$value['metal_id']] : "";
  2199. $value['bargain_status'] = $bidinfo['bargain_status'];
  2200. //reject驳回原因,status==5表示驳回
  2201. $value['reject'] = [];
  2202. if ($value['status'] >= 5) {
  2203. $value['reject'] = Db::name('bargain_order')
  2204. ->field('id,remark,status')
  2205. ->where(['infoNo' => $infoNo, 'bidsNo' => $value['bidNo']])
  2206. ->whereIn('status', [3, 8, 11])->order("id desc")
  2207. ->find();
  2208. }
  2209. //产地
  2210. $place = ["provice_code" => "", "city_code" => "", "area_code" => ""];
  2211. if ($value['delivery_place'] != "") {
  2212. list($place['provice_code'], $place['city_code'], $place['area_code']) = explode(",", $value['delivery_place']);
  2213. }
  2214. $value['delivery_place_cn'] = GetAddr(json_encode($place));
  2215. $place = ["provice_code" => "", "city_code" => "", "area_code" => ""];
  2216. if ($value['origin_place'] != "") {
  2217. list($place['provice_code'], $place['city_code'], $place['area_code']) = explode(",", $value['origin_place']);
  2218. }
  2219. $value['origin_addr'] = GetAddr(json_encode($place));
  2220. // if($value['origin_place']!=''){
  2221. // $code = explode(",",$value['origin_place']);
  2222. // $temp=[];
  2223. // $temp['provice_code']=isset($code[0])?$code[0]:"";
  2224. // $temp['city_code']=isset($code[1])?$code[1]:"";
  2225. // $temp['area_code']=isset($code[2])?$code[2]:"";
  2226. // $addr= GetAddr(json_encode($temp));
  2227. // $value['origin_addr'] = $addr;
  2228. // }
  2229. $value['company_name'] = implode('/', array_column(GetPart($value['itemid']), 'name'));
  2230. $data[] = $value;
  2231. }
  2232. return app_show(0, "获取成功", ['count' => $count, 'list' => $data]);
  2233. }
  2234. }