Sale.php 168 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056305730583059306030613062306330643065306630673068306930703071307230733074307530763077307830793080308130823083308430853086308730883089309030913092309330943095309630973098309931003101310231033104310531063107310831093110311131123113311431153116311731183119312031213122312331243125312631273128312931303131313231333134313531363137313831393140314131423143314431453146314731483149315031513152315331543155315631573158315931603161316231633164316531663167316831693170317131723173317431753176317731783179318031813182318331843185318631873188318931903191319231933194319531963197319831993200320132023203320432053206320732083209321032113212321332143215321632173218321932203221322232233224322532263227322832293230323132323233323432353236323732383239324032413242324332443245324632473248324932503251325232533254325532563257325832593260326132623263326432653266326732683269327032713272327332743275327632773278327932803281328232833284328532863287328832893290329132923293329432953296329732983299330033013302330333043305330633073308330933103311331233133314331533163317331833193320332133223323332433253326332733283329333033313332333333343335333633373338333933403341334233433344334533463347334833493350335133523353335433553356335733583359336033613362336333643365336633673368336933703371337233733374337533763377337833793380338133823383338433853386338733883389339033913392339333943395339633973398339934003401340234033404
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\model\GoodLog;
  4. use app\admin\model\ProcessOrder;
  5. use Exception;
  6. use think\App;
  7. use think\facade\Db;
  8. use app\admin\model\ActionLog;
  9. use think\facade\Validate;
  10. //销售单
  11. class Sale extends Base
  12. {
  13. public $noble=[];
  14. public function __construct(App $app)
  15. {
  16. parent::__construct($app);
  17. $this->noble=\think\facade\Config::get("noble");
  18. }
  19. public function create()
  20. {
  21. $token = isset($this->post['token']) && $this->post['token'] !=="" ?trim($this->post['token']):"";
  22. $orderCode=makeNo("QR");
  23. $customer_code= isset($this->post['customer_code'])&& $this->post['customer_code'] !=="" ? trim($this->post['customer_code']) :"";
  24. if($customer_code==""){
  25. return error_show(1002,"客户customer_code不能为空");
  26. }
  27. $customer=Db::name("customer_info")->where(["companyNo"=>$customer_code])->find();
  28. if($customer==false){
  29. return error_show(1004,"未找到客户数据");
  30. }
  31. $supplierNo= isset($this->post['supplierNo']) && $this->post['supplierNo'] !=="" ? trim($this->post['supplierNo']) :"";
  32. if($supplierNo==""){
  33. return error_show(1002,"参数supplierNo不能为空");
  34. }
  35. $supplier=Db::name("business")->where(["companyNo"=>$supplierNo])->find();
  36. if($supplier==false){
  37. return error_show(1004,"未找到平台供应商数据");
  38. }
  39. $goodtype =isset($this->post['goodtype']) && $this->post['goodtype'] !=="" ?intval($this->post['goodtype']):"1";
  40. $order_type =isset($this->post['order_type']) && $this->post['order_type'] !=="" ?intval($this->post['order_type'])
  41. :"1";
  42. $sendtype =isset($this->post['sendtype']) && $this->post['sendtype'] !=="" ?intval($this->post['sendtype']):"";
  43. if($sendtype===''){
  44. return error_show(1004,"参数sendtype不能为空");
  45. }
  46. $platform_id =isset($this->post['platform_id']) && $this->post['platform_id'] !=="" ?intval($this->post['platform_id']):"";
  47. if($platform_id==''){
  48. return error_show(1004,"参数platform_id不能为空");
  49. }
  50. $platform_order =isset($this->post['platform_order']) && $this->post['platform_order'] !=="" ?trim($this->post['platform_order']):"";
  51. $good_code =isset($this->post['good_code']) && $this->post['good_code'] !=="" ?trim($this->post['good_code']):"";
  52. if($good_code==''){
  53. return error_show(1004,"参数good_code不能为空");
  54. }
  55. $good_num =isset($this->post['good_num']) && $this->post['good_num'] !=="" ?intval($this->post['good_num']):"";
  56. if($good_num===''){
  57. return error_show(1004,"参数good_num不能为空");
  58. }
  59. $arrtime = isset($this->post['arrtime'])&&$this->post['arrtime']!="" ?$this->post['arrtime']:"";
  60. if($arrtime==""){
  61. return error_show(1004,"参数arrtime不能为空");
  62. }
  63. $paytime =isset($this->post['paytime'])&&$this->post['paytime']!=""? $this->post['paytime']:"";
  64. $workNo =isset($this->post['workNo'])&&$this->post['workNo']!=""? trim($this->post['workNo']):"";
  65. // $poNo =isset($this->post['poNo'])&&$this->post['poNo']!=""? trim($this->post['poNo']):"";
  66. $ct = Db::name('good_platform')->alias('a')->join('good b', 'b.spuCode=a.spuCode', 'left')
  67. ->where(['a.skuCode' => $good_code])->field("b.*,a.skuCode,a.platform_code,a.plat_code")->find();
  68. if ($ct == false) {
  69. return error_show(1002, "未找到商品数据");
  70. }
  71. $goodinfo=$ct;
  72. $is_stock=$ct['is_stock'];
  73. $spuCode = $ct['spuCode'];
  74. $skuCode = $ct['skuCode'];
  75. $is_activity= isset($this->post['is_activity'])&&$this->post['is_activity']!=="" ?$this->post['is_activity']:"";
  76. $actcode= isset($this->post['act_code'])&&$this->post['act_code']!=="" ?trim($this->post['act_code']):"";
  77. if($order_type==1){
  78. if($is_activity===""){
  79. return error_show(1002, "参数is_activity不能为空");
  80. }
  81. if($is_activity==1 &&$actcode=="" ){
  82. return error_show(1002, "参数act_code不能为空");
  83. }
  84. }
  85. if($goodinfo['is_stock']==1){
  86. $stock =Db::name("good_stock")->alias("a")->leftJoin("warehouse_info b","a.wsm_code=b.wsm_code")->where
  87. (["spuCode"=>$spuCode, "a.is_del"=>0,"a.status"=>1,"b.companyNo"=>$supplierNo])->field("a.id,a.usable_stock,a.wait_out_stock")->find();
  88. if($stock==false||$stock['usable_stock']<$good_num){
  89. return error_show(1003,"库存数量不足");
  90. }
  91. }
  92. $origin = Db::name("good_nake")->where([["spuCode","=",$spuCode],["min_num","<=",$good_num],["is_del","=",0]])->order("min_num desc")->find();
  93. if($origin==false){
  94. return error_show(1003,"未找到相关阶梯成本价格");
  95. }
  96. $origin_price = $origin['nake_total'];
  97. $sale_price = isset($this->post['good_price'])&&$this->post['good_price']!="" ? floatval($this->post['good_price']):0;
  98. if($goodtype==1){
  99. $good = Db::name("good_ladder")->where(["skuCode"=>$skuCode,"is_del"=>0,"status"=>1])->where([["min_num","<=",$good_num]])->order("min_num desc")->find();
  100. if($good==false){
  101. return error_show(1003,"未找到相关阶梯价格");
  102. }
  103. $sale_price = $good['sale_price'];
  104. if($is_activity==1){
  105. $act = Db::name("activity_info")->alias("a")->leftJoin("good_activity b","a.activity_code=b.activity_code")
  106. ->where(["a.skuCode"=>$skuCode,"a.activity_code"=>$actcode,"a.is_del"=>0,"a.status"=>1,"b.status"=>6,"b.is_del"=>0])
  107. ->find();
  108. if($act==false){
  109. return error_show(1003,"未找到相关活动价");
  110. }
  111. if($act['moq_num']>$good_num){
  112. return error_show(1003,"商品不满足活动价起订量{$act['moq_num']}");
  113. }
  114. if($act['activity_stock']<$good_num){
  115. return error_show(1003,"商品活动库存剩余{$act['activity_stock']}");
  116. }
  117. $sale_price=$act['activity_price'];
  118. }
  119. }
  120. $cgd=[
  121. "supplierNo"=>$ct['supplierNo'],
  122. "companyNo"=>$supplierNo,
  123. "orderCode"=>$orderCode,
  124. "spuCode"=>$ct['spuCode'],
  125. "skuCode"=>$ct['skuCode'],
  126. "good_name"=>$ct['good_name'],
  127. "sale_price"=>$origin_price,
  128. "total_fee"=>$origin_price*$good_num,
  129. "pakge_fee"=>$ct['packing_fee'],
  130. "cert_fee"=>$ct['cert_fee'],
  131. "open_fee"=>$ct['open_fee'],
  132. "cost_fee"=>$ct['cost_fee'],
  133. "mark_fee"=>$ct['mark_fee'],
  134. "demo_fee"=>$ct['demo_fee'],
  135. "good_num"=>$good_num,
  136. "good_type"=>$goodtype,
  137. "order_type"=>$is_stock==1?1:2,
  138. "createrid"=>$origin['creater_id'],
  139. "creater"=>$origin['creater'],
  140. 'send_way'=>2
  141. ];
  142. $addrlist = isset($this->post['addrlist']) && $this->post['addrlist'] !=="" ?$this->post['addrlist']:"";
  143. $send_num =0;
  144. if($sendtype==1){
  145. if($addrlist=="" || empty($addrlist) ||!is_array($addrlist)){
  146. return error_show(1004,"参数addrlist不能为空");
  147. }
  148. $send_num = array_sum(array_column($addrlist,"receipt_quantity"));
  149. }
  150. $remark =isset($this->post['remark']) && $this->post['remark'] !=="" ?trim($this->post['remark']):"";
  151. $apply_id =GetUserInfo($token);
  152. if(empty($apply_id)||$apply_id['code']!=0){
  153. return error_show(1002,"申请人数据不存在");
  154. }
  155. $rm= isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  156. $ri= isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  157. Db::startTrans();
  158. try {
  159. $data=[
  160. "orderCode"=>$orderCode,
  161. "good_code"=>$spuCode,
  162. "skuCode"=>$skuCode,
  163. "customer_code"=>$customer_code,
  164. "good_name"=>isset($goodinfo['good_name'])&&$goodinfo['good_name']!==''?$goodinfo['good_name']:'',
  165. "good_num"=>$good_num,
  166. "cat_id"=>$goodinfo['cat_id'],
  167. "apply_id"=>$rm,
  168. "apply_name"=>$ri,
  169. "origin_price"=>$origin_price,
  170. "sale_price"=>$sale_price,
  171. "post_fee"=>0,
  172. "status"=>$send_num == 0 ? 0 : ($good_num==$send_num ? 2 : 1),
  173. "send_num"=>$send_num,
  174. "wsend_num"=>$good_num-$send_num,
  175. "send_status"=>$good_num==$send_num? 3 :($send_num==0?1 :2) ,
  176. "good_type"=>$goodtype,
  177. "send_type"=>$sendtype,
  178. "supplierNo"=>$supplierNo,
  179. "is_del"=>0,
  180. "zxNo"=>"",
  181. "platform_order"=>$platform_order,
  182. "platform_id"=>$platform_id,
  183. "remark"=>$remark,
  184. "is_stock"=>$is_stock,
  185. "is_activity"=>$is_activity===""?0:$is_activity,
  186. "order_type"=>$order_type,
  187. // "poNo"=>$poNo,
  188. 'good_weight'=>$ct['weight'],
  189. 'gold_price'=>$ct['cgd_gold_price'],
  190. 'cost_price'=>$ct['cost_fee'],
  191. 'diff_weight'=>0,
  192. 'diff_fee'=>0,
  193. "workNo"=>$workNo,
  194. "addtime"=>date("Y-m-d H:i:s"),
  195. "updatetime"=>date("Y-m-d H:i:s"),
  196. 'total_price'=>round($sale_price*$good_num,2),
  197. ];
  198. $paytime==""?"": $data['paytime'] = $paytime;
  199. $datainfo = Db::name('sale')->insert($data,true);
  200. if($datainfo>0){
  201. if($is_activity==1){
  202. $actup =[
  203. "activity_stock"=> $act['activity_stock'] - $good_num,
  204. "updatetime"=>date("Y-m-d H:i:s")
  205. ];
  206. $actupp= Db::name("activity_info")->where(["skuCode"=>$skuCode,"activity_code"=>$actcode,
  207. "is_del"=>0,"status"=>1])->save($actup);
  208. if($actupp==false){
  209. Db::rollback();
  210. return error_show(1002,"活动库存修改失败");
  211. }
  212. }
  213. if($is_stock==0){
  214. $bol=$this->createCgd($cgd);
  215. if($bol==false){
  216. Db::rollback();
  217. return error_show(1002,"订单创建失败");
  218. }
  219. }else{
  220. $bol =$this->RelaCgd(['orderCode'=>$orderCode,"good_num"=>$good_num,"spuCode"=>$spuCode,"companyNo"=>$supplierNo]);
  221. if($bol==false){
  222. Db::rollback();
  223. return error_show(1002,"库存商品关联采购单失败");
  224. }
  225. if(isset($stock)){
  226. $stck = [
  227. "usable_stock"=>$stock['usable_stock']-$good_num,
  228. "wait_out_stock"=>$stock['wait_out_stock']+$good_num,
  229. "updatetime"=>date("Y-m-d H:i:s")
  230. ];
  231. $upad=Db::name("good_stock")->where($stock)->update($stck);
  232. if($upad==false){
  233. Db::rollback();
  234. return error_show(1002,"库存商品更新库存失败");
  235. }
  236. //商品变动日志表,good_log_code字段存储采购单号
  237. $good_data[] = ['good_log_code' => $orderCode, "stock_id" => $datainfo, "type" => 2,'stock'=>$good_num, "stock_name" => "usable_stock"];
  238. $good_data[] = ['good_log_code' => $orderCode, "stock_id" => $datainfo, "type" => 1,'stock'=>$good_num, "stock_name" => "wait_out_stock"];
  239. GoodLog::LogAdd($this->post['token'],$good_data,"XSQRD");
  240. }
  241. }
  242. if($sendtype==1){
  243. foreach ($addrlist as $value){
  244. $temp=[];
  245. $addrs=[];
  246. if($value['addr_code']!==''&&is_array($value['addr_code'])){
  247. $addrs['provice_code'] = $value['addr_code'][0];
  248. $addrs['city_code'] = $value['addr_code'][1];
  249. $addrs['area_code'] = $value['addr_code'][2];
  250. $addr = json_encode($addrs);
  251. }else{
  252. $addr = isset($value['addr_code'])?$value['addr_code']:'';
  253. }
  254. $temp['orderCode']=$orderCode;
  255. $temp['contactor']=$value['contactor'];
  256. $temp['mobile'] = $value['mobile'];
  257. $temp['addr'] = $value['addr'];
  258. $temp['addr_code']=$addr;
  259. $temp['customer_code'] =$customer_code;
  260. $temp['receipt_quantity']=$value['receipt_quantity'];
  261. $temp['post_fee'] =0;
  262. $temp['is_del'] =0;
  263. $temp['addtime'] =date("Y-m-d H:i:s");
  264. $temp['updatetime'] =date("Y-m-d H:i:s");
  265. $temp['arrive_time']=$arrtime;
  266. $vmp = Db::name('order_addr')->insert($temp,true);
  267. if($vmp>0){
  268. if($is_stock==1) {
  269. $order = Db::name("order_num")->where(["orderCode" => $orderCode, "status" => 1])->where([["wsend_num", ">=", 0]])
  270. ->lock(true)->find();
  271. if ($order==false) {
  272. return error_show(1004, "未找到可以发货得采购单数据");
  273. }
  274. $num = $value['receipt_quantity'];
  275. $outCode = makeNo("DF");
  276. $order['wsend_num']-=$num;
  277. $order['send_num']+=$num;
  278. $or = Db::name("order_num")->save($order);
  279. if ($or == false) {
  280. Db::rollback();
  281. return error_show(1002, "发货地址添加创建失败");
  282. }
  283. $tep = [
  284. "cgdNo" => $order['cgdNo'],
  285. "outCode" => $outCode,
  286. "send_num" => $num,
  287. "status" => 1,
  288. "addtime" => date("Y-m-d H:i:s"),
  289. "updatetime" => date("Y-m-d H:i:s")
  290. ];
  291. $sen = Db::name("order_send")->save($tep);
  292. if ($sen == false) {
  293. Db::rollback();
  294. return error_show(1002, "发货地址添加创建失败");
  295. }
  296. $cgdinfo = Db::name("purchease_order")->where(["cgdNo" => $order['cgdNo']])->find();
  297. if ($cgdinfo == false) {
  298. Db::rollback();
  299. return error_show(1002, "未匹配到采购数据");
  300. }
  301. $out = [
  302. "orderCode" => $orderCode,
  303. "outCode" => $outCode,
  304. "apply_id" => $rm,
  305. "apply_name" => $ri,
  306. "addrid" => $vmp,
  307. "post_name" => "",
  308. "post_code" => "",
  309. "post_fee" => 0,
  310. "sendtime" => date("Y-m-d H:i:s"),
  311. "send_num" => $num,
  312. "check_num" => 0,
  313. "error_num" => 0,
  314. "wsm_code" => $cgdinfo['wsm_code'],
  315. "order_type" =>1,
  316. "status" => 1,
  317. "addtime" => date("Y-m-d H:i:s"),
  318. "updatetime" => date("Y-m-d H:i:s")
  319. ];
  320. $ou = Db::name("order_out")->insert($out);
  321. if ($ou == false) {
  322. Db::rollback();
  323. return error_show(1002, "发货地址添加创建失败");
  324. }else{
  325. //修改状态,添加待办
  326. ActionLog::logAdd($this->post['token'], [
  327. "order_code" => $outCode,//出库单号
  328. "status" => 0,//这里的status是之前的值
  329. "action_remark" => '',//备注
  330. "action_type" => "create"//新建create,编辑edit,更改状态status
  331. ], "CKD", 0, $out);
  332. ProcessOrder::AddProcess($this->post['token'], [
  333. "order_type" => 'CKD',
  334. "order_code" => $outCode,//出库单号
  335. "order_id" => 0,
  336. "order_status" => 0
  337. ]);
  338. }
  339. }
  340. }else{
  341. Db::rollback();
  342. return error_show(1002,"发货地址添加创建失败");
  343. }
  344. }
  345. }
  346. Db::commit();
  347. return error_show(0,"咨询订单创建成功",["order_code"=>$orderCode]);
  348. }
  349. Db::rollback();
  350. return error_show(1002,"咨询订单创建失败");
  351. }catch(\Exception $e){
  352. Db::rollback();
  353. return error_show(1005,$e->getMessage());
  354. }
  355. }
  356. //采购单
  357. public function createCgd($data){
  358. $cgdCode = makeNo("CG");
  359. $supplier=Db::name("supplier")->where(["code"=>$data['supplierNo'],"is_del"=>0])->find();
  360. if($supplier==false){
  361. return false;
  362. }
  363. $wsm= Db::name("warehouse_info")->where(["supplierNo"=>$data["supplierNo"],"companyNo"=>$data['companyNo'],"is_del"=>0])->find();
  364. if($wsm==false){
  365. $wsm_code = makeNo("WSM");
  366. $inwsm=[
  367. "wsm_code"=>$wsm_code,
  368. "name"=>$supplier['name'],
  369. "wsm_type"=>2,
  370. "supplierNo"=>$supplier['code'],
  371. "addr"=>"",
  372. "addrs_code"=>"",
  373. "contactor"=>0,
  374. "contactor_name"=>0,
  375. "mobile"=>"",
  376. "position"=>"",
  377. "companyNo"=>$data['companyNo'],
  378. "status"=>1,
  379. "is_del"=>0,
  380. "addtime"=>date("Y-m-d H:i:s"),
  381. "updatetime"=>date("Y-m-d H:i:s")
  382. ];
  383. $in = Db::name("warehouse_info")->insert($inwsm);
  384. if($in==false){
  385. return false;
  386. }
  387. }else{
  388. $wsm_code =$wsm['wsm_code'];
  389. }
  390. $cg =["cgdNo"=>$cgdCode,
  391. "bkcode"=>"",
  392. "wsm_code"=>$wsm_code,
  393. "cgder"=>$data['order_type']==1? $supplier['person']:$data['creater'],
  394. "cgder_id"=>$data['order_type']==1? $supplier['personid']:$data['createrid'],
  395. "spuCode"=>$data['spuCode'],
  396. "skuCode"=>$data['skuCode'],
  397. "good_name"=>$data['good_name'],
  398. "good_num"=>$data['good_num'],
  399. "good_price"=>$data['sale_price'],
  400. "total_fee"=>round($data['sale_price']*$data['good_num'],2),
  401. "pakge_fee"=>$data['pakge_fee'],
  402. "cert_fee"=>$data['cert_fee'],
  403. "open_fee"=>$data['open_fee'],
  404. "teach_fee"=>$data['cost_fee'],
  405. "mark_fee"=>$data['mark_fee'],
  406. "demo_fee"=>$data['demo_fee'],
  407. #"weight"=>$data['weight'],
  408. "diff_weight"=>"0",
  409. "diff_fee"=>"0",
  410. "gold_price"=>"0",
  411. "supplierNo"=>$data['supplierNo'],
  412. "supplier_name"=>$supplier['name'],
  413. "companyNo"=>$data['companyNo'],
  414. "send_status"=>1,
  415. "send_num"=>0,
  416. "wsend_num"=>$data['good_num'],
  417. "remark"=>"",
  418. "status"=>0,//0初始化
  419. "lasttime"=>date("Y-m-d H:i:s"),
  420. "is_del"=>0,
  421. "order_type"=>$data['order_type'],
  422. "good_type"=>$data['good_type'],
  423. "addtime"=>date("Y-m-d H:i:s"),
  424. "updatetime"=>date("Y-m-d H:i:s")
  425. ];
  426. $up =Db::name("purchease_order")->insert($cg,true);
  427. if($up){
  428. //修改状态,添加待办
  429. ActionLog::logAdd($this->post['token'], [
  430. "order_code" => $cg['cgdNo'],//销售单code
  431. "status" => 0,//这里的status是之前的值
  432. "action_remark" => '',//备注
  433. "action_type" => "create"//新建create,编辑edit,更改状态status
  434. ], "CGD", $cg['status'], $cg);
  435. ProcessOrder::AddProcess($this->post['token'], [
  436. "order_type" => 'CGD',
  437. "order_code" => $cg['cgdNo'],//销售单code
  438. "order_id" => $up,
  439. "order_status" => $cg['status']
  440. ]);
  441. $rela=[
  442. "orderCode"=>$data['orderCode'],
  443. "cgdNo"=>$cgdCode,
  444. "spuCode"=>$data['spuCode'],
  445. "good_num"=>$data['good_num'],
  446. "wsend_num"=>$data['good_num'],
  447. "send_num"=>0,
  448. "wait_num"=>0,
  449. "status"=>1,
  450. "source"=>2
  451. ];
  452. $re =Db::name("order_num")->save($rela);
  453. if($re==false){
  454. return false;
  455. }else{
  456. $stokc =Db::name("good_stock")->where(['spuCode'=>$data['spuCode'],"wsm_code"=>$wsm_code,
  457. "is_del"=>0])->find();
  458. if($stokc==false){
  459. $stokc=[
  460. "spuCode"=>$data['spuCode'],
  461. "wsm_code"=>$wsm_code,
  462. "wait_in_stock"=>$data['good_num'],
  463. "wait_out_stock"=>0,
  464. "usable_stock"=>0,
  465. "intra_stock"=>0,
  466. "total_stock"=>0,
  467. "status"=>1,
  468. "addtime"=>date("Y-m-d H:i:s"),
  469. "updatetime"=>date("Y-m-d H:i:s")
  470. ];
  471. $stoc= Db::name("good_stock")->save($stokc);
  472. if($stoc==false){
  473. return false;
  474. }
  475. }
  476. return true;
  477. }
  478. }else{
  479. return false;
  480. }
  481. }
  482. public function addAddr(){
  483. $orderCode = isset($this->post['orderCode'])&&$this->post['orderCode']!=""? trim($this->post['orderCode']):"";
  484. $etid = Db::name("sale")->where(["orderCode" => $orderCode, "is_del" => 0])->find();
  485. if (empty($etid)) {
  486. return error_show(1002, "未找到数据");
  487. }
  488. $arrtime = isset($this->post['arrtime'])&&$this->post['arrtime']!="" ?$this->post['arrtime']:"";
  489. if($arrtime==""){
  490. return error_show(1004,"参数arrtime不能为空");
  491. }
  492. $token = isset($this->post['token']) && $this->post['token'] !=="" ?trim($this->post['token']):"";
  493. $apply_id =GetUserInfo($token);
  494. if(empty($apply_id)||$apply_id['code']!=0){
  495. return error_show(1002,"申请人数据不存在");
  496. }
  497. $rm= isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  498. $ri= isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  499. $addrlist = isset($this->post['addrlist']) && $this->post['addrlist'] !=="" ?$this->post['addrlist']:"";
  500. if($addrlist=="" || empty($addrlist) ||!is_array($addrlist)){
  501. return error_show(1004,"参数addrlist不能为空");
  502. }
  503. Db::startTrans();
  504. try{
  505. foreach ($addrlist as $value){
  506. $temp=[];
  507. $addrs=[];
  508. if($value['addr_code']!==''&&is_array($value['addr_code'])){
  509. $addrs['provice_code'] = $value['addr_code'][0];
  510. $addrs['city_code'] = $value['addr_code'][1];
  511. $addrs['area_code'] = $value['addr_code'][2];
  512. $addr = json_encode($addrs);
  513. }else{
  514. $addr = isset($value['addr_code'])?$value['addr_code']:'';
  515. }
  516. $temp['orderCode']=$orderCode;
  517. $temp['contactor']=$value['contactor'];
  518. $temp['mobile'] = $value['mobile'];
  519. $temp['addr'] = $value['addr'];
  520. $temp['addr_code']=$addr;
  521. $temp['customer_code'] =$etid['customer_code'];
  522. $temp['receipt_quantity']=$value['receipt_quantity'];
  523. $temp['post_fee'] =0;
  524. $temp['is_del'] =0;
  525. $temp['addtime'] =date("Y-m-d H:i:s");
  526. $temp['updatetime'] =date("Y-m-d H:i:s");
  527. $temp['arrive_time']=$arrtime;
  528. $vmp = Db::name('order_addr')->insert($temp,true);
  529. if($vmp>0){
  530. $order =Db::name("order_num")->where(["orderCode"=>$orderCode,"status"=>1])->where([["wsend_num",">=",0]])
  531. ->select()->toArray();
  532. if(empty($order)){
  533. return error_show(1004,"未找到可以发货得采购单数据");
  534. }
  535. $num = $value['receipt_quantity'];
  536. $orsend=[];
  537. foreach ($order as $val){
  538. $outCode=makeNo("DF");
  539. $tep=[];
  540. $ornum=0;
  541. if($val['wsend_num']>=$num){
  542. $val['wsend_num']-=$num;
  543. $val['send_num']+=$num;
  544. $ornum =$num;
  545. $num=0;
  546. }else{
  547. $num-=$val['wsend_num'];
  548. $val['send_num']+=$val['wsend_num'];
  549. $ornum =$val['wsend_num'];
  550. $val['wsend_num']=0;
  551. }
  552. $or =Db::name("order_num")->save($val);
  553. if($or==false){
  554. Db::rollback();
  555. return error_show(1002,"发货地址添加创建失败");
  556. }
  557. $tep=[
  558. "cgdNo"=>$val['cgdNo'],
  559. "outCode"=>$outCode,
  560. "send_num"=>$ornum,
  561. "status"=>1,
  562. "addtime"=>date("Y-m-d H:i:s"),
  563. "updatetime"=>date("Y-m-d H:i:s")
  564. ];
  565. $sen=Db::name("order_send")->save($tep);
  566. if($sen==false){
  567. Db::rollback();
  568. return error_show(1002,"发货地址添加创建失败");
  569. }
  570. $cgdinfo =Db::name("purchease_order")->where(["cgdNo"=>$val['cgdNo']])->find();
  571. if($cgdinfo==false){
  572. Db::rollback();
  573. return error_show(1002,"未匹配到采购数据");
  574. }
  575. $out=[
  576. "orderCode"=>$orderCode,
  577. "outCode"=>$outCode,
  578. "apply_id"=>$rm,
  579. "apply_name"=>$ri,
  580. "addrid"=>$vmp,
  581. "post_name"=>"",
  582. "post_code"=>"",
  583. "post_fee"=>0,
  584. "sendtime"=>date("Y-m-d H:i:s"),
  585. "send_num"=>$ornum,
  586. "check_num"=>0,
  587. "error_num"=>1,
  588. "wsm_code"=>$cgdinfo['wsm_code'],
  589. "order_type"=>$etid['order_type'],
  590. "status"=>0,
  591. "addtime"=>date("Y-m-d H:i:s"),
  592. "updatetime"=>date("Y-m-d H:i:s")
  593. ];
  594. $ou =Db::name("order_out")->insert($out);
  595. if($ou==false){
  596. Db::rollback();
  597. return error_show(1002,"发货地址添加创建失败");
  598. }else{
  599. //修改状态,添加待办
  600. ActionLog::logAdd($this->post['token'], [
  601. "order_code" => $outCode,//出库单号
  602. "status" => 0,//这里的status是之前的值
  603. "action_remark" => '',//备注
  604. "action_type" => "create"//新建create,编辑edit,更改状态status
  605. ], "CKD", 0, $out);
  606. ProcessOrder::AddProcess($this->post['token'], [
  607. "order_type" => 'CKD',
  608. "order_code" => $outCode,//出库单号
  609. "order_id" => 0,
  610. "order_status" => 0
  611. ]);
  612. }
  613. //维护商品所在仓库的库存 --- start
  614. $temp = Db::name('good_stock')
  615. ->field('id,usable_stock,wait_out_stock')
  616. ->where(['spuCode' => $val['spuCode'], 'wsm_code' => $cgdinfo['wsm_code']])
  617. ->find();
  618. if ($temp == false) {
  619. Db::rollback();
  620. return error_show(1004, '库存不足');
  621. }
  622. if (($temp['usable_stock'] - $ornum) < 0) {
  623. Db::rollback();
  624. return error_show(1004, '库存不足');
  625. }
  626. $up =Db::name('good_stock')
  627. ->where('id', $temp['id'])
  628. ->update([
  629. 'usable_stock' => $temp['usable_stock'] - $ornum,
  630. 'wait_out_stock' => $temp['wait_out_stock'] + $ornum,
  631. 'updatetime' => date('Y-m-d H:i:s'),
  632. ]);
  633. if($up==false){
  634. Db::rollback();
  635. return error_show(1004, '库存更新失败');
  636. }
  637. //维护商品所在仓库的库存 --- end
  638. if($num==0){
  639. break;
  640. }
  641. }
  642. }else{
  643. Db::rollback();
  644. return error_show(1002,"发货地址添加创建失败");
  645. }
  646. }
  647. Db::commit();
  648. return app_show(0,"发货地址添加完成");
  649. }catch(\Exception $e){
  650. Db::rollback();
  651. return error_show(1002,$e->getMessage());
  652. }
  653. }
  654. public function consultOrder(){
  655. $bidNo =isset($this->post['bidNo'])&&$this->post['bidNo']!="" ? trim($this->post['bidNo']):"";
  656. if($bidNo==""){
  657. return error_show(1003,"参数bidNo不能为空");
  658. }
  659. $zxinfo = Db::name("consult_bids")->where(["bidNo"=>$bidNo,"is_del"=>0])->find();
  660. if($zxinfo==false){
  661. return error_show(1003,"未找到咨询单商品信息");
  662. }
  663. if($zxinfo['status']!=6){
  664. return error_show(1003,"咨询单状态有误无法转单");
  665. }
  666. $zx =Db::name("consult_info")->where(["infoNo"=>$zxinfo['infoNo'],"is_del"=>0])->find();
  667. if($zx==false){
  668. return error_show(1003,"未找到咨询单信息");
  669. }
  670. if($zx['status']!=4){
  671. return error_show(1003,"咨询单状态有误无法转单");
  672. }
  673. $zxorder =Db::name("consult_order")->where(["zxNo"=>$zx["zxNo"],"is_del"=>0])->find();
  674. if($zxorder==false){
  675. return error_show(1003,"未找到咨询单信息");
  676. }
  677. $good_num =isset($this->post['good_num'])&&$this->post['good_num']!="" ? intval($this->post['good_num']):"";
  678. if($good_num===""){
  679. return error_show(1003,"参数 good_num 不能为空");
  680. }
  681. $sale_price = isset($this->post['sale_price']) && $this->post['sale_price'] != "" ? floatval($this->post['sale_price']) : "";
  682. if ($sale_price === "") {
  683. return error_show(1003, "参数 sale_price 销售单价 不能为空");
  684. }
  685. if ($sale_price < $zxinfo['sale_price']) {
  686. return error_show(1003, "修改的销售单价不能低于原来的销售单价");
  687. }
  688. $sendtype = isset($this->post['sendtype'])&&$this->post['sendtype']!="" ? intval($this->post['sendtype']):"";
  689. if($sendtype==""){
  690. return error_show(1003,"参数sendtype不能为空");
  691. }
  692. $remark = isset($this->post['remark'])&&$this->post['remark']!="" ? trim($this->post['remark']):"";
  693. $orderCode = makeNo("QR");
  694. $spuCode = $zxinfo['spuCode'];
  695. $skuCode = "";
  696. $is_stock=0;
  697. $cgd=[
  698. "supplierNo"=>$zxinfo['supplierNo'],
  699. "companyNo"=>$zxorder['companyNo'],
  700. "spuCode"=>$spuCode,
  701. "skuCode"=>$skuCode,
  702. "orderCode"=>$orderCode,
  703. "good_name"=>$zxinfo['good_name'],
  704. "sale_price"=>$zxinfo['total_fee'],
  705. "total_fee"=>round($zxinfo['total_fee']* $good_num, 2),
  706. "pakge_fee"=>$zxinfo['pakge_fee'],
  707. "cert_fee"=>$zxinfo['cert_fee'],
  708. "open_fee"=>$zxinfo['open_fee'],
  709. "cost_fee"=>$zxinfo['cost_fee'],
  710. "mark_fee"=>$zxinfo['mark_fee'],
  711. "demo_fee"=>$zxinfo['demo_fee'],
  712. "good_num"=>$good_num,
  713. "createrid"=>$zxinfo['createrid'],
  714. "creater"=>$zxinfo['creater'],
  715. "good_type"=>1,
  716. "is_diff"=>$zxinfo['is_diff'],
  717. "order_type"=>3,
  718. 'send_way'=>$zxinfo['send_way']
  719. ];
  720. $token=isset($this->post['token'])&&$this->post['token']!=""? trim($this->post['token']):"";
  721. if($token==""){
  722. return error_show(102, "参数token不能为空");
  723. }
  724. $apply_id = GetUserInfo($token);
  725. if (empty($apply_id) || $apply_id['code'] != 0) {
  726. return error_show(102, "申请人数据不存在");
  727. }
  728. $rm = isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  729. $ri = isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  730. $va = isset($this->post['order_addr']) && $this->post['order_addr'] !== "" ? $this->post['order_addr'] : "";
  731. $send_num=0;
  732. if($sendtype==1){
  733. if ($va == "") {
  734. return error_show(1002, "参数order_addr不能为空");
  735. }
  736. $send_num = array_sum(array_column($va,"receipt_quantity"));
  737. }
  738. $arrtime=isset($this->post['arrtime'])&&$this->post['arrtime']!="" ?$this->post['arrtime']:"";
  739. if($arrtime==""){
  740. return error_show(1002, "参数arrtime不能为空");
  741. }
  742. //新加字段
  743. $platform_order=isset($this->post['platform_order'])&&$this->post['platform_order']!="" ?$this->post['platform_order']:"";
  744. $workNo=isset($this->post['workNo'])&&$this->post['workNo']!="" ?$this->post['workNo']:"";
  745. Db::startTrans();
  746. try{
  747. $data=[
  748. "orderCode"=>$orderCode,
  749. "good_code"=>$spuCode,
  750. "skuCode"=>$skuCode,
  751. "customer_code"=>$zxorder['khNo'],
  752. "good_name"=>isset($zxinfo['good_name'])&&$zxinfo['good_name']!==''?$zxinfo['good_name']:'',
  753. "good_num"=>$good_num,
  754. "cat_id"=>$zxinfo['cat_id'],
  755. "apply_id"=>$rm,
  756. "apply_name"=>$ri,
  757. "origin_price"=>$zxinfo['total_fee'],
  758. "sale_price" => $sale_price,//销售单价支持修改
  759. "post_fee"=>0,
  760. "status"=>$send_num == 0 ? 0 : ($good_num==$send_num ?2 : 1),
  761. "send_num"=>$send_num,
  762. "wsend_num"=>$good_num-$send_num,
  763. "send_status"=>$good_num==$send_num? 3 :($send_num==0?1 :2) ,
  764. "good_type"=>1,
  765. "send_type"=>$sendtype,
  766. "supplierNo"=>$zxorder['companyNo'],
  767. "is_del"=>0,
  768. "zxNo"=>$bidNo,
  769. "platform_order"=>$platform_order,
  770. "platform_id"=>0,
  771. "remark"=>$remark,
  772. "arrive_time"=>$arrtime,
  773. "is_stock"=>0,
  774. "is_activity"=>0,
  775. "proof_id"=>0,
  776. "order_type"=>3,
  777. 'good_weight'=>$zxinfo['good_weight'],
  778. 'gold_price'=>$zxinfo['total_fee'],
  779. 'cost_price'=>$zxinfo['sale_cost_fee'],
  780. 'diff_weight'=>0,
  781. 'diff_fee'=>0,
  782. "addtime"=>date("Y-m-d H:i:s"),
  783. "updatetime"=>date("Y-m-d H:i:s"),
  784. 'total_price' => round($sale_price * $good_num, 2),
  785. 'workNo'=>$workNo,
  786. ];
  787. $datainfo = Db::name('sale')->insert($data, true);
  788. if($datainfo>0){
  789. $old_zx_status = $zx['status'];
  790. $zx['status']=5;
  791. $zx['updatetime']=date("Y-m-d H:i:s");
  792. $sa=Db::name("consult_info")->save($zx);
  793. if($sa==false){
  794. Db::rollback();
  795. return error_show(1002,"咨询单修改失败");
  796. }else{
  797. //修改状态,添加待办
  798. ActionLog::logAdd($this->post['token'], [
  799. "order_code" => $zx['infoNo'],//咨询单详情编号
  800. "status" => $old_zx_status,//这里的status是之前的值
  801. "action_remark" => '',//备注
  802. "action_type" => "status"//新建create,编辑edit,更改状态status
  803. ], "ZXD", 5, $zx);
  804. ProcessOrder::AddProcess($this->post['token'], [
  805. "order_type" => 'ZXD',
  806. "order_code" => $zx['infoNo'],//咨询单详情编号
  807. "order_id" => $zx['id'],
  808. "order_status" => 5
  809. ]);
  810. }
  811. $bol=$this->createCgd($cgd);
  812. if($bol==false){
  813. Db::rollback();
  814. return error_show(1002,"咨询订单创建失败");
  815. }
  816. $limt=[
  817. "spuCode"=>$zxinfo['spuCode'],
  818. "good_name"=>$zxinfo['good_name'],
  819. "brand_id"=>$zxinfo['brand_id'],
  820. "good_unit"=>$zxinfo['unit_id'],
  821. "cat_id"=>$zxinfo['cat_id'],
  822. "good_type"=>0,
  823. "moq"=>1,
  824. "customized"=>$zxinfo['work_day'],
  825. "tax"=>$zxinfo['tax'],
  826. "supplierNo"=>$zxinfo["supplierNo"],
  827. "is_auth"=>0,
  828. "craft_desc"=>$zxinfo['good_name'],
  829. "good_remark"=>"",
  830. "platform_id"=>$zxorder['platform_id'],
  831. "good_img"=>$zxinfo['good_img'],
  832. "good_thumb_img"=>"",
  833. "good_info_img"=>"",
  834. "specinfo"=>$zxinfo['specinfo'],
  835. "work_day"=>$zxinfo['work_day'],
  836. "noble_metal"=>$zxinfo['metal_id'],
  837. "is_gold_price"=>$zxinfo['is_gold_price'],
  838. "config"=>$zxinfo['config'],
  839. "other_config"=>$zxinfo['other_config'],
  840. "weight"=>$zxinfo['weight'],
  841. "good_weight"=>$zxinfo['good_weight'],
  842. "is_diff"=>$zxinfo['is_diff'],
  843. "supply_area"=>$zxinfo['supply_area'],
  844. "pay_way"=>$zxinfo['pay_way'],
  845. "send_way"=>$zxinfo['send_way'],
  846. "status"=>1,
  847. "is_del"=>0,
  848. "createrid"=>$zxinfo['createrid'],
  849. "creater"=>$zxinfo['creater'],
  850. "addtime"=>date("Y-m-d H:i:s"),
  851. "updatetime"=>date("Y-m-d H:i:s")
  852. ];
  853. $good = Db::name("good_zixun")->insert($limt);
  854. if(!$good){
  855. Db::rollback();
  856. return error_show(1006,"咨询商品录入失败");
  857. }
  858. if(!empty($va)){
  859. $order =Db::name("order_num")->where(["orderCode"=>$orderCode,"status"=>1])->where([["wsend_num",">=",0]])
  860. ->find();
  861. if($order==false){
  862. Db::rollback();
  863. return error_show(1006,"采购单关联数据未找到");
  864. }
  865. foreach ($va as $value){
  866. $temp=[];
  867. $addrs=[];
  868. if($value['addr_code']!==''&&is_array($value['addr_code'])){
  869. $addrs['provice_code'] = $value['addr_code'][0];
  870. $addrs['city_code'] = $value['addr_code'][1];
  871. $addrs['area_code'] = $value['addr_code'][2];
  872. $addr = json_encode($addrs);
  873. }else{
  874. $addr = isset($value['addr_code'])?$value['addr_code']:'';
  875. }
  876. $temp['orderCode']=$orderCode;
  877. $temp['contactor']=$value['contactor'];
  878. $temp['mobile'] = $value['mobile'];
  879. $temp['addr'] = $value['addr'];
  880. $temp['addr_code']=$addr;
  881. $temp['customer_code'] =$zxorder['khNo'];
  882. $temp['receipt_quantity']=$value['receipt_quantity'];
  883. $temp['post_fee'] =0;
  884. $temp['is_del'] =0;
  885. $temp['addtime'] =date("Y-m-d H:i:s");
  886. $temp['updatetime'] =date("Y-m-d H:i:s");
  887. $temp['arrive_time']=$arrtime;
  888. $vmp = Db::name('order_addr')->insert($temp,true);
  889. if($vmp>0){
  890. $outCode=makeNo("DF");
  891. $out=[
  892. "orderCode"=>$orderCode,
  893. "outCode"=>$outCode,
  894. "apply_id"=>$rm,
  895. "apply_name"=>$ri,
  896. "addrid"=>$vmp,
  897. "post_name"=>"",
  898. "post_code"=>"",
  899. "post_fee"=>0,
  900. "sendtime"=>date("Y-m-d H:i:s"),
  901. "send_num"=>$value['receipt_quantity'],
  902. "check_num"=>0,
  903. "error_num"=>0,
  904. "wsm_code"=>"",
  905. "order_type"=>3,
  906. "status"=>0,
  907. "addtime"=>date("Y-m-d H:i:s"),
  908. "updatetime"=>date("Y-m-d H:i:s")
  909. ];
  910. $ou =Db::name("order_out")->insert($out);
  911. if($ou==false){
  912. Db::rollback();
  913. return error_show(1002,"发货地址添加创建失败");
  914. }else{
  915. //修改状态,添加待办
  916. ActionLog::logAdd($this->post['token'], [
  917. "order_code" => $outCode,//出库单号
  918. "status" => 0,//这里的status是之前的值
  919. "action_remark" => '',//备注
  920. "action_type" => "create"//新建create,编辑edit,更改状态status
  921. ], "CKD", 0, $out);
  922. ProcessOrder::AddProcess($this->post['token'], [
  923. "order_type" => 'CKD',
  924. "order_code" => $outCode,//出库单号
  925. "order_id" => 0,
  926. "order_status" => 0
  927. ]);
  928. }
  929. $order['send_num']+=$value['receipt_quantity'];
  930. $order['wsend_num']-=$value['receipt_quantity'];
  931. if($order['wsend_num']<0){
  932. Db::rollback();
  933. return error_show(1002,"发货数量已超出总数");
  934. }
  935. $ups = Db::name("order_num")->save($order);
  936. if($ups){
  937. $tep=[
  938. "cgdNo"=>$order['cgdNo'],
  939. "outCode"=>$outCode,
  940. "send_num"=>$value['receipt_quantity'],
  941. "status"=>1,
  942. "addtime"=>date("Y-m-d H:i:s"),
  943. "updatetime"=>date("Y-m-d H:i:s")
  944. ];
  945. $sen=Db::name("order_send")->save($tep);
  946. if($sen==false){
  947. Db::rollback();
  948. return error_show(1002,"发货地址添加创建失败");
  949. }
  950. }
  951. }else{
  952. Db::rollback();
  953. return error_show(1002,"发货地址添加创建失败");
  954. }
  955. }
  956. }
  957. Db::commit();
  958. return error_show(0,"咨询订单创建成功",["order_code"=>$orderCode]);
  959. }
  960. Db::rollback();
  961. return error_show(1002,"咨询订单创建失败");
  962. }catch(\Exception $e){
  963. Db::rollback();
  964. return error_show(1003,$e->getMessage());
  965. }
  966. }
  967. /**
  968. * @return \think\response\Json|void
  969. * @throws \think\db\exception\DataNotFoundException
  970. * @throws \think\db\exception\DbException
  971. * @throws \think\db\exception\ModelNotFoundException
  972. */
  973. public function projectCreate(){
  974. $planNo =isset($this->post['planNo'])&&$this->post['planNo']!=""?trim($this->post['planNo']):"";
  975. if($planNo==""){
  976. return error_show(1004,"参数planNo不能为空");
  977. }
  978. $plan =Db::name("project_plan")->where(["planNo"=>$planNo,"is_del"=>0])->find();
  979. if($plan==false){
  980. return error_show(1004,"未找到方案信息");
  981. }
  982. $feedbackid = Db::name("project_plan_rela")->where(["planNo"=>$planNo,"is_del"=>0])->column("feedback_id,sale_price,sale_num");
  983. if($feedbackid==false){
  984. return error_show(1004,"未找到方案反馈信息");
  985. }
  986. $project = Db::name("project")->where(["projectNo"=>$plan['projectNo'],"is_del"=>0])->find();
  987. if($project==false){
  988. return error_show(1004,"未找到方案信息");
  989. }
  990. $arrtime=isset($this->post['arrtime'])&&$this->post['arrtime']!="" ?$this->post['arrtime']:"";
  991. if($arrtime==""){
  992. return error_show(1002, "参数arrtime不能为空");
  993. }
  994. $planinfo =isset($this->post['planinfo'])&&!empty($this->post['planinfo']) ?$this->post['planinfo']:"";
  995. if($planinfo==""){
  996. return error_show(1002, "参数planinfo不能为空");
  997. }
  998. $token=isset($this->post['token'])&&$this->post['token']!=""? trim($this->post['token']):"";
  999. if($token==""){
  1000. return error_show(102, "参数token不能为空");
  1001. }
  1002. $apply_id = GetUserInfo($token);
  1003. if (empty($apply_id) || $apply_id['code'] != 0) {
  1004. return error_show(102, "申请人数据不存在");
  1005. }
  1006. $rm = isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  1007. $ri = isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  1008. Db::startTrans();
  1009. try {
  1010. $feedid = array_column($feedbackid,"feedback_id");
  1011. foreach ($planinfo as $value){
  1012. $good=[];
  1013. $feedback = Db::name("project_feedback")->where(["id"=>$value['feedback_id'],"projectNo"=>$plan['projectNo'],
  1014. "is_del"=>0])->find();
  1015. if($feedback==false){
  1016. Db::rollback();
  1017. return error_show(1002, "反馈数据未找到");
  1018. }
  1019. $key =array_search($feedback['id'],$feedid);
  1020. $price = $feedbackid[$key];
  1021. $good['spuCode'] = $feedback['spuCode'];
  1022. $good['skuCode'] = $feedback['skuCode'];
  1023. $good['good_num'] = $price['sale_num'];
  1024. $good['sendtype'] = $value['sendtype'];
  1025. $good['sale_price']=$price['sale_price'];
  1026. $good['origin_price']=$feedback['origin_price'];
  1027. $good['companyNo']=$project['companyNo'];
  1028. $good['customerNo']=$project['khNo'];
  1029. $good['pgNo']=$feedback['pgNo'];
  1030. $good['arrtime']=$arrtime;
  1031. $good['rm']=$rm;
  1032. $good['ri']=$ri;
  1033. $good['send_num']=0;
  1034. if($value['sendtype']==1){
  1035. if(!isset($value['addrlist'])||empty($value['addrlist'])){
  1036. Db::rollback();
  1037. return error_show(1002, "订单地址不能为空");
  1038. }
  1039. $good['addrlist'] = $value['addrlist'];
  1040. $good['send_num'] = array_sum(array_column($value['addrlist'],"receipt_quantity"));
  1041. }
  1042. if($feedback['data_source']==1){
  1043. $feed=$this->project_good($good);
  1044. if($feed !==true){
  1045. Db::rollback();
  1046. switch ($feed){
  1047. case 1:
  1048. $msg='库存不足';
  1049. break;
  1050. case 2:
  1051. $msg='库存更新失败';
  1052. break;
  1053. case 3:
  1054. $msg='关联采购失败';
  1055. break;
  1056. case 4:
  1057. $msg='商品信息未找到';
  1058. break;
  1059. default:
  1060. $msg='咨询订单生成失败';
  1061. }
  1062. return error_show(1002,$msg);
  1063. }
  1064. }else{
  1065. $feed=$this->project_zx($good);
  1066. if($feed==false){
  1067. Db::rollback();
  1068. return error_show(1002, "咨询订单生成失败");
  1069. }
  1070. }
  1071. $feedback['status']=2;
  1072. $feedback['updatetime']=date("Y-m-d H:i:s");
  1073. $fed =Db::name("project_feedback")->save($feedback);
  1074. if($fed==false){
  1075. Db::rollback();
  1076. return error_show(1002, "项目订单生成失败");
  1077. }
  1078. }
  1079. $old_plan_status = $plan['status'];
  1080. $plan['status']=2;
  1081. $plan['updatetime']=date("Y-m-d H:i:s");
  1082. $in =Db::name("project_plan")->save($plan);
  1083. if($in==false){
  1084. Db::rollback();
  1085. return error_show(1002, "项目订单生成失败");
  1086. }else{
  1087. //修改状态,添加待办,只记录动作
  1088. ActionLog::logAdd($this->post['token'], [
  1089. "order_code" => $planNo,//编码
  1090. "status" => $old_plan_status,//这里的status是之前的值
  1091. "action_remark" => '',//备注
  1092. "action_type" => "edit"//新建create,编辑edit,更改状态status
  1093. ], "PRO", 2, $plan);
  1094. }
  1095. $old_project_status = $project["status"];
  1096. $project["status"]=6;
  1097. $project['updatetime']=date("Y-m-d H:i:s");
  1098. $pr =Db::name("project")->save($project);
  1099. if($pr==false){
  1100. Db::rollback();
  1101. return error_show(1002, "项目订单生成失败");
  1102. }else{
  1103. //修改状态,添加待办
  1104. ActionLog::logAdd($this->post['token'], [
  1105. "order_code" => $project['projectNo'],//项目编码
  1106. "status" => $old_project_status,//这里的status是之前的值
  1107. "action_remark" => '',//备注
  1108. "action_type" => "status"//新建create,编辑edit,更改状态status
  1109. ], "PRO", 6, $project);
  1110. ProcessOrder::AddProcess($this->post['token'], [
  1111. "order_type" => 'PRO',
  1112. "order_code" => $project['projectNo'],
  1113. "order_id" => $project['id'],
  1114. "order_status" => 6
  1115. ]);
  1116. }
  1117. Db::commit();
  1118. return app_show(0, "咨询订单生成成功");
  1119. }catch (\Exception $e){
  1120. Db::rollback();
  1121. return error_show(1002, $e->getMessage());
  1122. }
  1123. }
  1124. /**
  1125. * @param $data
  1126. * @return false
  1127. * @throws \think\db\exception\DataNotFoundException
  1128. * @throws \think\db\exception\DbException
  1129. * @throws \think\db\exception\ModelNotFoundException
  1130. *
  1131. */
  1132. public function project_zx($data){
  1133. $goodinfo = Db::name("consult_bids")->where(["spuCode"=>$data['spuCode'],"is_del"=>0])->find();
  1134. if($goodinfo==false){
  1135. return false;
  1136. }
  1137. $orderCode=makeNo("QR");
  1138. $cgd=[
  1139. "supplierNo"=>$goodinfo['supplierNo'],
  1140. "companyNo"=>$data['companyNo'],
  1141. "spuCode"=>$data['spuCode'],
  1142. "skuCode"=>"",
  1143. "orderCode"=>$orderCode,
  1144. "good_name"=>$goodinfo['good_name'],
  1145. "sale_price"=>$goodinfo['total_fee'],
  1146. "total_fee"=>round($goodinfo['total_fee']*$data['good_num'],2),
  1147. "pakge_fee"=>$goodinfo['pakge_fee'],
  1148. "cert_fee"=>$goodinfo['cert_fee'],
  1149. "open_fee"=>$goodinfo['open_fee'],
  1150. "cost_fee"=>$goodinfo['cost_fee'],
  1151. "mark_fee"=>$goodinfo['mark_fee'],
  1152. "demo_fee"=>$goodinfo['demo_fee'],
  1153. "good_num"=>$data['good_num'],
  1154. "createrid"=>$goodinfo['createrid'],
  1155. "creater"=>$goodinfo['creater'],
  1156. "good_type"=>1,
  1157. "order_type"=>4,
  1158. "send_way"=>$goodinfo['send_way'],
  1159. ];
  1160. $datas=[
  1161. "orderCode"=>$orderCode,
  1162. "good_code"=>$data['spuCode'],
  1163. "skuCode"=>"",
  1164. "customer_code"=>$data['customerNo'],
  1165. "good_name"=>isset($goodinfo['good_name'])&&$goodinfo['good_name']!==''?$goodinfo['good_name']:'',
  1166. "good_num"=>$data['good_num'],
  1167. "cat_id"=>$goodinfo['cat_id'],
  1168. "apply_id"=>$data['rm'],
  1169. "apply_name"=>$data['ri'],
  1170. "origin_price"=>$goodinfo['total_fee'],
  1171. "sale_price"=>$data['sale_price'],
  1172. "post_fee"=>0,
  1173. "status"=>$data['good_num']==$data['send_num']?2:($data['send_num']==0?0 :1),
  1174. "send_num"=>$data['send_num'],
  1175. "wsend_num"=>$data['good_num']-$data['send_num'],
  1176. "send_status"=>$data['good_num']==$data['send_num']? 3 :($data['send_num']==0?1 :2),
  1177. "good_type"=>1,
  1178. "send_type"=>$data['sendtype'],
  1179. "supplierNo"=>$data['companyNo'],
  1180. "is_del"=>0,
  1181. "zxNo"=>$data["pgNo"],
  1182. "platform_order"=>"",
  1183. "platform_id"=>0,
  1184. "remark"=>"",
  1185. "is_stock"=>0,
  1186. "is_activity"=>0,
  1187. "proof_id"=>0,
  1188. "order_type"=>4,
  1189. 'good_weight'=>$goodinfo['good_weight'],
  1190. 'gold_price'=>$goodinfo['sale_price'],
  1191. 'cost_price'=>$goodinfo['sale_cost_fee'],
  1192. 'diff_weight'=>0,
  1193. 'diff_fee'=>0,
  1194. "addtime"=>date("Y-m-d H:i:s"),
  1195. "updatetime"=>date("Y-m-d H:i:s"),
  1196. 'total_price'=>round($data['sale_price']*$data['good_num'],2),
  1197. ];
  1198. $datainfo = Db::name('sale')->insert($datas, true);
  1199. if($datainfo>0){
  1200. $bol = $this->createCgd($cgd);
  1201. if ($bol == false) {
  1202. return false;
  1203. }
  1204. $goodinfo['status']=6;
  1205. $goodinfo['updatetime']=date("Y-m-d H:i:s");
  1206. $sa=Db::name("consult_bids")->save($goodinfo);
  1207. if($sa==false){
  1208. return false;
  1209. }
  1210. $zxorder =Db::name("consult_order")->where(["zxNo"=>$goodinfo["zxNo"],"is_del"=>0])->find();
  1211. if($zxorder==false){
  1212. return false;
  1213. }
  1214. $limt=[
  1215. "spuCode"=>$goodinfo['spuCode'],
  1216. "good_name"=>$goodinfo['good_name'],
  1217. "brand_id"=>$goodinfo['brand_id'],
  1218. "good_unit"=>$goodinfo['unit_id'],
  1219. "cat_id"=>$goodinfo['cat_id'],
  1220. "good_type"=>0,
  1221. "moq"=>1,
  1222. "customized"=>$goodinfo['work_day'],
  1223. "tax"=>$goodinfo['tax'],
  1224. "supplierNo"=>$goodinfo["supplierNo"],
  1225. "is_auth"=>0,
  1226. "craft_desc"=>$goodinfo['good_name'],
  1227. "good_remark"=>"",
  1228. "good_img"=>$goodinfo['good_img'],
  1229. "good_thumb_img"=>"",
  1230. "good_info_img"=>"",
  1231. "platform_id"=>$zxorder['platform_id'],
  1232. "specinfo"=>$goodinfo['specinfo'],
  1233. "work_day"=>$goodinfo['work_day'],
  1234. "noble_metal"=>$goodinfo['metal_id'],
  1235. "is_gold_price"=>$goodinfo['is_gold_price'],
  1236. "good_weight"=>$goodinfo['good_weight'],
  1237. "config"=>$goodinfo['config'],
  1238. "other_config"=>$goodinfo['other_config'],
  1239. "weight"=>$goodinfo['weight'],
  1240. "is_diff"=>$goodinfo['is_diff'],
  1241. "supply_area"=>$goodinfo['supply_area'],
  1242. "pay_way"=>$goodinfo['pay_way'],
  1243. "send_way"=>$goodinfo['send_way'],
  1244. "status"=>1,
  1245. "is_del"=>0,
  1246. "createrid"=>$goodinfo['createrid'],
  1247. "creater"=>$goodinfo['creater'],
  1248. "addtime"=>date("Y-m-d H:i:s"),
  1249. "updatetime"=>date("Y-m-d H:i:s")
  1250. ];
  1251. $good = Db::name("good_zixun")->insert($limt);
  1252. if(!$good){
  1253. return false;
  1254. }
  1255. if ($data['sendtype']==1&&!empty($data['addrlist'])) {
  1256. $order = Db::name("order_num")->where(["orderCode" => $orderCode, "status" => 1])->where([["wsend_num", ">=", 0]])
  1257. ->find();
  1258. if ($order == false) {
  1259. return false;
  1260. }
  1261. foreach ($data['addrlist'] as $value) {
  1262. $temp = [];
  1263. $addrs = [];
  1264. if ($value['addr_code'] !== '' && is_array($value['addr_code'])) {
  1265. $addrs['provice_code'] = $value['addr_code'][0];
  1266. $addrs['city_code'] = $value['addr_code'][1];
  1267. $addrs['area_code'] = $value['addr_code'][2];
  1268. $addr = json_encode($addrs);
  1269. } else {
  1270. $addr = isset($value['addr_code']) ? $value['addr_code'] : '';
  1271. }
  1272. $temp['orderCode'] = $orderCode;
  1273. $temp['contactor'] = $value['contactor'];
  1274. $temp['mobile'] = $value['mobile'];
  1275. $temp['addr'] = $value['addr'];
  1276. $temp['addr_code'] = $addr;
  1277. $temp['customer_code'] = $data['companyNo'];
  1278. $temp['receipt_quantity'] = $value['receipt_quantity'];
  1279. $temp['post_fee'] = 0;
  1280. $temp['is_del'] = 0;
  1281. $temp['addtime'] = date("Y-m-d H:i:s");
  1282. $temp['updatetime'] = date("Y-m-d H:i:s");
  1283. $temp['arrive_time'] = $data['arrtime'];
  1284. $vmp = Db::name('order_addr')->insert($temp, true);
  1285. if ($vmp > 0) {
  1286. // $outCode = makeNo("CK");
  1287. // $out = [
  1288. // "orderCode" => $orderCode,
  1289. // "outCode" => $outCode,
  1290. // "apply_id"=>$data['rm'],
  1291. // "apply_name"=>$data['ri'],
  1292. // "addrid" => $vmp,
  1293. // "post_name" => "",
  1294. // "post_code" => "",
  1295. // "post_fee" => 0,
  1296. // "sendtime" => date("Y-m-d H:i:s"),
  1297. // "send_num" => $value['receipt_quantity'],
  1298. // "check_num" => 0,
  1299. // "error_num" => 0,
  1300. // "wsm_code" => "",
  1301. // "order_type" => 4,
  1302. // "status" => 0,
  1303. // "addtime" => date("Y-m-d H:i:s"),
  1304. // "updatetime" => date("Y-m-d H:i:s")
  1305. // ];
  1306. // $ou = Db::name("order_out")->insert($out);
  1307. // if ($ou == false) {
  1308. // return false;
  1309. // }
  1310. // $order['send_num'] += $value['receipt_quantity'];
  1311. // $order['wsend_num'] -= $value['receipt_quantity'];
  1312. // if ($order['wsend_num'] < 0) {
  1313. // return false;
  1314. // }
  1315. // $ups = Db::name("order_num")->save($order);
  1316. // if ($ups) {
  1317. // $tep = [
  1318. // "cgdNo" => $order['cgdNo'],
  1319. // "outCode" => $outCode,
  1320. // "send_num" => $value['receipt_quantity'],
  1321. // "status" => 1,
  1322. // "addtime" => date("Y-m-d H:i:s"),
  1323. // "updatetime" => date("Y-m-d H:i:s")
  1324. // ];
  1325. // $sen = Db::name("order_send")->save($tep);
  1326. // if ($sen == false) {
  1327. // return false;
  1328. // }
  1329. // }
  1330. } else {
  1331. return false;
  1332. }
  1333. }
  1334. }
  1335. }
  1336. return true;
  1337. }
  1338. /**
  1339. * @param $data
  1340. * @return bool
  1341. * @throws \think\db\exception\DataNotFoundException
  1342. * @throws \think\db\exception\DbException
  1343. * @throws \think\db\exception\ModelNotFoundException
  1344. */
  1345. public function project_good($data){
  1346. $good=Db::name('good')
  1347. ->alias("a")
  1348. ->leftJoin("good_platform b","a.spuCode=b.spuCode")
  1349. ->where(["b.skuCode"=>$data['skuCode'],"a.is_del"=>0,"b.is_del"=>0])
  1350. ->find();
  1351. if($good==false){
  1352. return 4; //商品信息未找到
  1353. }
  1354. $goodlass = Db::name("good_ladder")->where(["skuCode"=>$data['skuCode'],"is_del"=>0,"status"=>1])->where([["min_num",
  1355. "<=",$data['good_num']]])->order("min_num desc")->find();
  1356. if($goodlass==false){
  1357. return 4;//商品信息未找到
  1358. }
  1359. $sale_price = $goodlass['sale_price'];
  1360. $origin = Db::name("good_nake")->where([["spuCode","=",$data['spuCode']],["min_num","<=",$data['good_num']],
  1361. ["is_del","=",0]])->order("min_num desc")->find();
  1362. if($origin==false){
  1363. return 4;//商品信息未找到
  1364. }
  1365. $origin_price = $origin['nake_total'];
  1366. $orderCode=makeNo("QR");
  1367. $datas=[
  1368. "orderCode"=>$orderCode,
  1369. "good_code"=>$data['spuCode'],
  1370. "skuCode"=>$data['skuCode'],
  1371. "customer_code"=>$data['customerNo'],
  1372. "good_name"=>isset($good['good_name'])&&$good['good_name']!==''?$good['good_name']:'',
  1373. "good_num"=>$data['good_num'],
  1374. "cat_id"=>$good['cat_id'],
  1375. "apply_id"=>$data['rm'],
  1376. "apply_name"=>$data['ri'],
  1377. "origin_price"=>$origin_price,
  1378. "sale_price"=>$sale_price,
  1379. "post_fee"=>0,
  1380. "status"=>$data['good_num']==$data['send_num']? 2 :($data['send_num']==0?0 :1),
  1381. "send_num"=>$data['send_num'],
  1382. "wsend_num"=>$data['good_num']-$data['send_num'],
  1383. "send_status"=>$data['good_num']==$data['send_num']? 3 :($data['send_num']==0?1 :2) ,
  1384. "good_type"=>1,
  1385. "send_type"=>$data['sendtype'],
  1386. "supplierNo"=>$data['companyNo'],
  1387. "is_del"=>0,
  1388. "zxNo"=>$data["pgNo"],
  1389. "platform_order"=>"",
  1390. "platform_id"=>0,
  1391. "remark"=>"",
  1392. "is_stock"=>$good['is_stock'],
  1393. "is_activity"=>0,
  1394. "proof_id"=>0,
  1395. "order_type"=>2,
  1396. 'good_weight'=>$good['weight'],
  1397. 'gold_price'=>$good['cgd_gold_price'],
  1398. 'cost_price'=>$good['cost_fee'],
  1399. 'diff_weight'=>0,
  1400. 'diff_fee'=>0,
  1401. "addtime"=>date("Y-m-d H:i:s"),
  1402. "updatetime"=>date("Y-m-d H:i:s"),
  1403. 'total_price'=>round($sale_price*$data['good_num'],2),
  1404. ];
  1405. $datainfo = Db::name('sale')->insert($datas, true);
  1406. if($datainfo>0) {
  1407. $cgd=[
  1408. "supplierNo"=>$good['supplierNo'],
  1409. "companyNo"=>$data['companyNo'],
  1410. "orderCode"=>$orderCode,
  1411. "spuCode"=>$good['spuCode'],
  1412. "skuCode"=>$good['skuCode'],
  1413. "good_name"=>$good['good_name'],
  1414. "sale_price"=>$origin_price,
  1415. "total_fee"=>$origin_price*$data['good_num'],
  1416. "pakge_fee"=>$origin['package_fee'],
  1417. "cert_fee"=>$origin['cert_fee'],
  1418. "open_fee"=>$good['open_fee'],
  1419. "cost_fee"=>$origin['cost_fee'],
  1420. "mark_fee"=>$origin['mark_fee'],
  1421. "demo_fee"=>$good['demo_fee'],
  1422. "good_num"=>$data['good_num'],
  1423. "good_type"=>1,
  1424. "createrid"=>$origin['creater_id'],
  1425. "creater"=>$origin['creater'],
  1426. "order_type"=>$good['is_stock']==1?1:2,
  1427. 'send_way'=>2
  1428. ];
  1429. if($good['is_stock']==0) {
  1430. $bol = $this->createCgd($cgd);
  1431. if ($bol == false) {
  1432. return 3;//关联采购失败
  1433. }
  1434. }else{
  1435. $stock =Db::name("good_stock")->alias("a")->leftJoin("warehouse_info b","a.wsm_code=b.wsm_code")->where
  1436. (["spuCode"=>$good['spuCode'], "a.is_del"=>0,"a.status"=>1,"b.companyNo"=>$data['companyNo']])->field("a.id,a.usable_stock,a.wait_out_stock")->find();
  1437. if($stock==false||$stock['usable_stock']<$data['good_num']){
  1438. return 1; //库存不足
  1439. }
  1440. $bol =$this->RelaCgd(['orderCode'=>$orderCode,"good_num"=>$data['good_num'],"spuCode"=>$good['spuCode'],"companyNo"=>$data['companyNo']]);
  1441. if($bol==false){
  1442. return 3;//关联采购失败
  1443. }
  1444. if(isset($stock)){
  1445. $stck = [
  1446. "usable_stock"=>$stock['usable_stock']-$data['good_num'],
  1447. "wait_out_stock"=>$stock['wait_out_stock']+$data['good_num'],
  1448. "updatetime"=>date("Y-m-d H:i:s")
  1449. ];
  1450. $upad=Db::name("good_stock")->where($stock)->update($stck);
  1451. if($upad==false){
  1452. return 2; //库存更新失败
  1453. }
  1454. //商品变动日志表,good_log_code字段存储采购单号
  1455. $good_data[] = ['good_log_code' => $orderCode, "stock_id" => $datainfo, "type" => 2,'stock'=>$data['good_num'], "stock_name" => "usable_stock"];
  1456. $good_data[] = ['good_log_code' => $orderCode, "stock_id" => $datainfo, "type" => 1,'stock'=>$data['good_num'], "stock_name" => "wait_out_stock"];
  1457. GoodLog::LogAdd($this->post['token'],$good_data,"XSQRD");
  1458. }
  1459. }
  1460. if ($data['sendtype']==1&&!empty($data['addrlist'])) {
  1461. foreach ($data['addrlist'] as $value) {
  1462. $temp = [];
  1463. $addrs = [];
  1464. if ($value['addr_code'] !== '' && is_array($value['addr_code'])) {
  1465. $addrs['provice_code'] = $value['addr_code'][0];
  1466. $addrs['city_code'] = $value['addr_code'][1];
  1467. $addrs['area_code'] = $value['addr_code'][2];
  1468. $addr = json_encode($addrs);
  1469. } else {
  1470. $addr = isset($value['addr_code']) ? $value['addr_code'] : '';
  1471. }
  1472. $temp['orderCode'] = $orderCode;
  1473. $temp['contactor'] = $value['contactor'];
  1474. $temp['mobile'] = $value['mobile'];
  1475. $temp['addr'] = $value['addr'];
  1476. $temp['addr_code'] = $addr;
  1477. $temp['customer_code'] =$data['companyNo'];
  1478. $temp['receipt_quantity'] = $value['receipt_quantity'];
  1479. $temp['post_fee'] = 0;
  1480. $temp['is_del'] = 0;
  1481. $temp['addtime'] = date("Y-m-d H:i:s");
  1482. $temp['updatetime'] = date("Y-m-d H:i:s");
  1483. $temp['arrive_time'] = $data['arrtime'];
  1484. $vmp = Db::name('order_addr')->insert($temp, true);
  1485. if ($vmp > 0) {
  1486. if ($good['is_stock'] == 1) {
  1487. $order = Db::name("order_num")->where(["orderCode" => $orderCode, "status" => 1])->where([["wsend_num", ">=", 0]])
  1488. ->lock(true)->find();
  1489. if ($order == false) {
  1490. return 3;
  1491. }
  1492. $num = $value['receipt_quantity'];
  1493. $outCode = makeNo("DF");
  1494. $order['wsend_num'] -= $num;
  1495. $order['send_num'] += $num;
  1496. $or = Db::name("order_num")->save($order);
  1497. if ($or == false) {
  1498. return 3;
  1499. }
  1500. $tep = [
  1501. "cgdNo" => $order['cgdNo'],
  1502. "outCode" => $outCode,
  1503. "send_num" => $num,
  1504. "status" => 1,
  1505. "addtime" => date("Y-m-d H:i:s"),
  1506. "updatetime" => date("Y-m-d H:i:s")
  1507. ];
  1508. $sen = Db::name("order_send")->save($tep);
  1509. if ($sen == false) {
  1510. return 3;
  1511. }
  1512. $cgdinfo = Db::name("purchease_order")->where(["cgdNo" => $order['cgdNo']])->find();
  1513. if ($cgdinfo == false) {
  1514. return 4;
  1515. }
  1516. $out = [
  1517. "orderCode" => $orderCode,
  1518. "outCode" => $outCode,
  1519. "apply_id" => $data['rm'],
  1520. "apply_name" => $data['ri'],
  1521. "addrid" => $vmp,
  1522. "post_name" => "",
  1523. "post_code" => "",
  1524. "post_fee" => 0,
  1525. "sendtime" => date("Y-m-d H:i:s"),
  1526. "send_num" => $num,
  1527. "check_num" => 0,
  1528. "error_num" => 0,
  1529. "wsm_code" => $cgdinfo['wsm_code'],
  1530. "order_type" => 1,
  1531. "status" => 1,
  1532. "addtime" => date("Y-m-d H:i:s"),
  1533. "updatetime" => date("Y-m-d H:i:s")
  1534. ];
  1535. $ou = Db::name("order_out")->insert($out);
  1536. if ($ou == false) {
  1537. return 0;
  1538. } else {
  1539. //修改状态,添加待办
  1540. ActionLog::logAdd($this->post['token'], [
  1541. "order_code" => $outCode,//出库单号
  1542. "status" => 0,//这里的status是之前的值
  1543. "action_remark" => '',//备注
  1544. "action_type" => "create"//新建create,编辑edit,更改状态status
  1545. ], "CKD", 0, $out);
  1546. ProcessOrder::AddProcess($this->post['token'], [
  1547. "order_type" => 'CKD',
  1548. "order_code" => $outCode,//出库单号
  1549. "order_id" => 0,
  1550. "order_status" => 0
  1551. ]);
  1552. }
  1553. } else {
  1554. return false;
  1555. }
  1556. }
  1557. }
  1558. }
  1559. }
  1560. return true;
  1561. }
  1562. public function list()
  1563. {
  1564. $page = isset($this->post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) : "1";
  1565. $size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) : "10";
  1566. $where[] = ['is_del', "=", 0];
  1567. $orderCode = isset($this->post['orderCode']) && $this->post['orderCode'] !== "" ? trim($this->post['orderCode']) : "";
  1568. if ($orderCode !== "") {
  1569. $where[] = ['orderCode', "like", "%$orderCode%"];
  1570. }
  1571. $apply_name = isset($this->post['apply_name']) && $this->post['apply_name'] !== "" ? trim($this->post['apply_name'])
  1572. : "";
  1573. if ($apply_name !== "") {
  1574. $where[] = ['apply_name', "like", "%$apply_name%"];
  1575. }
  1576. $good_name = isset($this->post['good_name']) && $this->post['good_name'] !== "" ? trim($this->post['good_name'])
  1577. : "";
  1578. if ($good_name !== "") {
  1579. $where[] = ['good_name', "like", "%$good_name%"];
  1580. }
  1581. $good_code = isset($this->post['good_code']) && $this->post['good_code'] !== "" ? trim($this->post['good_code']) : "";
  1582. if ($good_code !== "") {
  1583. $where[] = ['good_code', "like", "%$good_code%"];
  1584. }
  1585. $customer_code = isset($this->post['customer_code']) && $this->post['customer_code'] !== "" ? trim($this->post['customer_code']) : "";
  1586. if ($customer_code !== "") {
  1587. $where[] = ['customer_code', "like", "%$customer_code%"];
  1588. }
  1589. $supplierNo = isset($this->post['supplierNo']) && $this->post['supplierNo'] !== "" ? trim($this->post['supplierNo']) : "";
  1590. if ($supplierNo !== "") {
  1591. $where[] = ['supplierNo', "like", "%$supplierNo%"];
  1592. }
  1593. $ordertype = isset($this->post['order_type']) && $this->post['order_type'] !== "" ? intval($this->post['order_type'])
  1594. : "";
  1595. if ($ordertype !== "") {
  1596. $where[] = ['order_type', "=", $ordertype];
  1597. }
  1598. $status = isset($this->post['status']) && $this->post['status'] !== "" ? trim($this->post['status']) : "";
  1599. if ($status !== "") {
  1600. $where[] = ['status', "=", $status];
  1601. }
  1602. $start = isset($this->post['start']) && $this->post['start'] !== "" ? $this->post['start'] : "";
  1603. if ($start != "") {
  1604. $where[] = ["addtime", '>=', $start];
  1605. }
  1606. $end = isset($this->post['end']) && $this->post['end'] !== "" ? $this->post['end'] : "";
  1607. if ($end != "") {
  1608. $where[] = ["addtime", '<=', $end];
  1609. }
  1610. $count = Db::name('sale')->where($where)->count();
  1611. $total = ceil($count / $size);
  1612. $page = $page >= $total ? $total : $page;
  1613. $list = Db::name('sale')->where($where)->order("addtime desc")->page($page, $size)->select();
  1614. $data = [];
  1615. foreach ($list as $value) {
  1616. if($value['order_type']==3|| $value['order_type']==4){
  1617. $var = Db::name("good_zixun")->where(["spuCode"=>$value['good_code'],"is_del"=>0])->find();
  1618. $value["speclist"]=isset($var['specinfo'])&&$var['specinfo']!=""? json_decode($var['specinfo'],true):"";
  1619. }else {
  1620. $var = Db::name('good_platform')->alias('a')->join('good b', 'b.spuCode=a.spuCode', 'left')
  1621. ->where(['a.skuCode' => $value['skuCode']])->find();
  1622. $spec = Db::name("good_spec")->where(["spuCode"=>$var['spuCode'],"is_del"=>0])->select()->toArray();
  1623. $speclist=[];
  1624. if(!empty($spec)){
  1625. foreach ($spec as $val){
  1626. $temp=[];
  1627. $temp['id']=$val['id'];
  1628. $temp['spuCode']=$val['spuCode'];
  1629. $temp['spec_id']=$val['spec_id'];
  1630. $temp['spec_value_id']=$val['spec_value_id'];
  1631. $sp = Db::name("specs")->where(["id"=>$val['spec_id']])->find();
  1632. $temp['spec_name']=isset($sp["spec_name"]) ? $sp["spec_name"]:"";
  1633. $spv = Db::name("spec_value")->where(["id"=>$val['spec_value_id']])->find();
  1634. $temp['spec_value']=isset($spv["spec_value"]) ? $spv["spec_value"]:"";
  1635. $speclist[]=$temp;
  1636. }
  1637. }
  1638. $value["speclist"]=empty($speclist)?[]:$speclist;
  1639. }
  1640. $value['can'] = isset($var['cat_id']) && $var['cat_id'] != 0 ? made($var['cat_id']) : [];
  1641. $value['supplierName'] = '';
  1642. if ($value['supplierNo'] != "") {
  1643. $supplier = Db::name("business")->where(["companyNo" => $value['supplierNo']])->find();
  1644. $value['supplierName'] = isset($supplier['company']) ? $supplier['company'] : "";
  1645. }
  1646. $value['customerName'] = '';
  1647. if ($value['customer_code'] != "") {
  1648. $supplier = Db::name("customer_info")->where(["companyNo" => $value['customer_code']])->find();
  1649. $value['customerName'] = isset($supplier['companyName']) ? $supplier['companyName'] : "";
  1650. }
  1651. $value['useage']="";
  1652. if($value['use_order']!=0){
  1653. $use =Db::name("order_use")->where(["id"=>$value['use_order']])->find();
  1654. $value['useage'] = isset($use['order_use']) ?$use['order_use']:"";
  1655. }else{
  1656. $value['use_order']='';
  1657. }
  1658. $data[] = $value;
  1659. }
  1660. return app_show(0, "获取成功", ['list' => $data, 'count' => $count]);
  1661. }
  1662. public function edit()
  1663. {
  1664. $token = isset($this->post['token']) && $this->post['token'] !== "" ? trim($this->post['token']) : "";
  1665. $id = isset($this->post['id']) && $this->post['id'] !== "" ? trim($this->post['id']) : "";
  1666. if ($id == "") {
  1667. return error_show(1002, "参数id不能为空");
  1668. }
  1669. $etid = Db::name("sale")->where(["id" => $id, "is_del" => 0])->find();
  1670. if (empty($etid)) {
  1671. return error_show(1002, "未找到数据");
  1672. }
  1673. // $orderCode=isset($this->post['orderCode']) && $this->post['orderCode'] !=="" ? trim($this->post['orderCode']) :"";
  1674. // if($orderCode==""){
  1675. // return error_show(1002,"销售单code不能为空");
  1676. // }
  1677. $good_code = isset($this->post['good_code']) && $this->post['good_code'] !== "" ? trim($this->post['good_code']) : "";
  1678. if ($good_code == "") {
  1679. return error_show(1002, "商品code不能为空");
  1680. }
  1681. $ct = Db::name('good')->alias('a')->join('good_type b', 'b.good_code=a.good_code', 'left')
  1682. ->where(['b.type_code' => $good_code])->find();
  1683. if ($ct == "") {
  1684. return error_show(1002, "未找到商品数据");
  1685. }
  1686. $customer_code = isset($this->post['customer_code']) && $this->post['customer_code'] !== "" ? trim($this->post['customer_code']) : "";
  1687. if ($customer_code == "") {
  1688. return error_show(1002, "客户code不能为空");
  1689. }
  1690. $customer = Db::name("customer_info")->where(["companyNo" => $customer_code])->find();
  1691. if ($customer == false) {
  1692. return error_show(1004, "未找到客户数据");
  1693. }
  1694. $supplierNo = $this->post['supplierNo'] && $this->post['supplierNo'] !== "" ? trim($this->post['supplierNo']) : "";
  1695. if ($supplierNo == "") {
  1696. return error_show(1002, "参数supplierNo不能为空");
  1697. }
  1698. $supplier = Db::name("supplier")->where(["code" => $supplierNo])->find();
  1699. if ($supplier == false) {
  1700. return error_show(1004, "未找到平台供应商数据");
  1701. }
  1702. $apply_id = GetUserInfo($token);
  1703. if (empty($apply_id) || $apply_id['code'] != 0) {
  1704. return error_show(1002, "申请人数据不存在");
  1705. }
  1706. $rm = isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  1707. $ri = isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  1708. // $good_name = isset($this->post['good_name']) && $this->post['good_name'] !== "" ? trim
  1709. //($this->post['good_name']) : "";
  1710. // $good_num = isset($this->post['good_num']) && $this->post['good_num'] !== "" ? intval
  1711. //($this->post['good_num']) : "";
  1712. // $origin_price = isset($this->post['origin_price']) && $this->post['origin_price'] !== "" ? intval
  1713. // ($this->post['origin_price']) : "";
  1714. // $sale_price = isset($this->post['sale_price']) && $this->post['sale_price'] !== "" ? trim($this->post['sale_price']) : "";
  1715. // $total_price = isset($this->post['total_price']) && $this->post['total_price'] !== "" ? trim($this->post['total_price']) : "";
  1716. // $post_fee = isset($this->post['post_fee']) && $this->post['post_fee'] !== "" ? trim($this->post['post_fee']) : "";
  1717. // $status = isset($this->post['status']) && $this->post['status'] !== "" ? intval($this->post['status']) : "";
  1718. $vr = isset($this->post['order_addr']) && $this->post['order_addr'] !== "" ? $this->post['order_addr'] : "";
  1719. if ($vr == "") {
  1720. return error_show(1002, "参数order_addr不能为空");
  1721. }
  1722. $vi = isset($this->post['good_stock']) && $this->post['good_stock'] !== "" ? $this->post['good_stock'] : "";
  1723. if ($vi == "") {
  1724. return error_show(1002, "参数good_stock不能为空");
  1725. }
  1726. $good_num = intval(array_sum(array_column($vi, "num")));
  1727. Db::startTrans();
  1728. try {
  1729. $datn = [
  1730. "id" => $id,
  1731. "good_code" => $good_code,
  1732. "customer_code" => $customer_code,
  1733. "good_num" => $good_num,
  1734. "supplierNo" => $supplierNo,
  1735. "apply_id" => $rm,
  1736. "apply_name" => $ri,
  1737. "is_del" => 0,
  1738. "updatetime" => date("Y-m-d H:i:s")
  1739. ];
  1740. $datninfo = Db::name('sale')->where(['id' => $id, 'is_del' => 0])->save($datn);
  1741. if ($datninfo > 0) {
  1742. $stn = ["order_code"=>$etid['orderCode'],"status"=>$etid['status'],"action_remark"=>'',"action_type"=>"edit"];
  1743. ActionLog::logAdd($this->post['token'],$stn,"XSQRD",$etid['status'],$datn);
  1744. $order=["order_type"=>'XSQRD',"order_code"=>$etid['orderCode'],"order_id"=>$id,"order_status"=>$etid['status']];
  1745. ProcessOrder::AddProcess($this->post['token'],$order);
  1746. foreach ($vi as $ion) {
  1747. $iten = [];
  1748. isset($ion['id']) && $ion['id'] !== "" ? $iten['id'] = $ion['id'] : '';
  1749. $iten['orderCode'] = $etid['orderCode'];
  1750. $iten['wsm_code'] = $ion['wsm_code'];
  1751. $iten['stock_id'] = 0;
  1752. $iten['num'] = $ion['num'];
  1753. $iten['status'] = 1;
  1754. $iten['sale_price'] = $ct['original_price'];
  1755. isset($ion['id']) && $ion['id'] !== "" ? '' : $iten['addtime'] = date("Y-m-d H:i:s");
  1756. $iten['updatetime'] = date("Y-m-d H:i:s");
  1757. $vp = Db::name('sale_info')->save($iten);
  1758. if ($vp == false)
  1759. {
  1760. Db::rollback();
  1761. return error_show(1002, "更新失败");
  1762. }
  1763. }
  1764. foreach ($vr as $value) {
  1765. $temp = [];
  1766. isset($value['id']) && $value['id'] !== "" ? $temp['id'] = $value['id'] : '';
  1767. $temp['orderCode'] = $etid['orderCode'];
  1768. $temp['contactor'] = $value['contactor'];
  1769. $temp['mobile'] = $value['mobile'];
  1770. $temp['addr'] = $value['addr'];
  1771. $temp['addr_code'] = $value['addr_code'];
  1772. $temp['customer_code'] = $customer_code;
  1773. $temp['receipt_quantity'] = $value['receipt_quantity'];
  1774. $temp['post_fee'] = 0;
  1775. $temp['is_del'] = $value['is_del'];
  1776. isset($value['id']) && $value['id'] !== "" ? '' : $temp['addtime'] = date("Y-m-d H:i:s");
  1777. $temp['updatetime'] = date("Y-m-d H:i:s");
  1778. $temp['arrive_time'] = date("Y-m-d H:i:s");
  1779. $dat = Db::name('order_addr')->save($temp);
  1780. if ($dat == false) {
  1781. Db::rollback();
  1782. return error_show(1002, "更新失败");
  1783. }
  1784. }
  1785. Db::commit();
  1786. return error_show(0, "更新成功");
  1787. }
  1788. Db::rollback();
  1789. return error_show(1002, "更新失败");
  1790. } catch (Exception $e) {
  1791. Db::rollback();
  1792. return error_show(1005, $e->getMessage());
  1793. }
  1794. }
  1795. public function info()
  1796. {
  1797. $id = isset($this->post['id']) && $this->post['id'] !== "" ? intval($this->post['id']) : "";
  1798. if ($id == "") {
  1799. return error_show(1002, "参数id不能为空");
  1800. }
  1801. $einfo = Db::name('sale')->where(['id' => $id, 'is_del' => 0])->find();
  1802. if (empty($einfo)) {
  1803. return error_show(1002, "未找到销售订单数据");
  1804. }
  1805. if($einfo['order_type']==3|| $einfo['order_type']==4){
  1806. $goon = Db::name("good_zixun")->where(["spuCode"=>$einfo['good_code'],"is_del"=>0])->find();
  1807. }else {
  1808. $goon = Db::name('good_platform')->alias('a')->join('good b', 'b.spuCode=a.spuCode', 'left')
  1809. ->where(['a.skuCode' => $einfo['skuCode']])->find();
  1810. }
  1811. if ($goon==false) {
  1812. return error_show(1003, "未找到商品数据");
  1813. }else{
  1814. $goon['exclusive']=isset($goon['is_exclusive'])?makeExcluse($goon['is_exclusive']):"";
  1815. $unit =Db::name("unit")->where(["id"=>$goon['good_unit']])->find();
  1816. $goon['unit'] = isset($unit['unit'])?$unit['unit']:'';
  1817. $spec = Db::name("good_spec")->where(["spuCode"=>$goon['spuCode'],"is_del"=>0])->select()->toArray();
  1818. $speclist=[];
  1819. if(!empty($spec)){
  1820. foreach ($spec as $value){
  1821. $temp=[];
  1822. $temp['id']=$value['id'];
  1823. $temp['spuCode']=$value['spuCode'];
  1824. $temp['spec_id']=$value['spec_id'];
  1825. $temp['spec_value_id']=$value['spec_value_id'];
  1826. $temp['is_del']=$value['is_del'];
  1827. $sp = Db::name("specs")->where(["id"=>$value['spec_id']])->find();
  1828. $temp['spec_name']=isset($sp["spec_name"]) ? $sp["spec_name"]:"";
  1829. $spv = Db::name("spec_value")->where(["id"=>$value['spec_value_id']])->find();
  1830. $temp['spec_value']=isset($spv["spec_value"]) ? $spv["spec_value"]:"";
  1831. $speclist[]=$temp;
  1832. }
  1833. }
  1834. $goon["speclist"]=empty($speclist)?[]:$speclist;
  1835. $proof =Db::name("good_proof")->where(["spuCode"=>$goon['spuCode'],"is_del"=>0])->order("updatetime desc")->field("id,proof_type,proof_url")->find();
  1836. $goon['proof'] = isset($proof)&&$proof!=false? $proof:[];
  1837. $goon['origin_place_cn']="";
  1838. $goon['delivery_place_cn']="";
  1839. if(isset($goon['delivery_place'])&&$goon['delivery_place']!==""){
  1840. $place = ["provice_code"=>"","city_code"=>"","area_code"=>""];
  1841. list($place['provice_code'],$place['city_code'],$place['area_code'])=explode(",",$goon['delivery_place']);
  1842. $goon['delivery_place_cn']=GetAddr(json_encode($place));
  1843. }
  1844. if(isset($goon['delivery_place'])&&$goon['origin_place']!==""){
  1845. $place = ["provice_code"=>"","city_code"=>"","area_code"=>""];
  1846. list($place['provice_code'],$place['city_code'],$place['area_code'])=explode(",",$goon['origin_place']);
  1847. $goon['origin_place_cn']=GetAddr(json_encode($place));
  1848. }
  1849. if($goon['brand_id']!=0){
  1850. $brand=Db::name("brand")->where(["id"=>$goon['brand_id']])->find();
  1851. $goon["brand_name"]=isset($brand['brand_name'])?$brand['brand_name']:"";
  1852. }else{
  1853. $goon["brand_name"]="";
  1854. $goon["brand_id"]="";
  1855. }
  1856. $supplier = Db::name("supplier")->where(["code"=>$goon['supplierNo']])->find();
  1857. $goon['supplierName'] = isset($supplier['name'])?$supplier['name']:"";
  1858. $goon['noble_name']=isset($goon['noble_metal'])&&$goon['noble_metal']!=0?$this->noble[$goon['noble_metal']] :"";
  1859. if(isset($goon['companyNo'])&&$goon['companyNo']!=""){
  1860. $company = Db::name("business")->where(["companyNo"=>$goon['companyNo']])->find();
  1861. }
  1862. $goon['company'] = isset($company['company'])?$company['company']:"";
  1863. }
  1864. $int = isset($goon['cat_id']) && $goon['cat_id'] != 0 ? made($goon['cat_id']) : [];
  1865. $in = Db::name('customer_info')->where(['companyNo' => $einfo['customer_code']])->field('companyName')->find();
  1866. $einfo['supplierName'] = '';
  1867. if ($einfo['supplierNo'] != "") {
  1868. $supplier = Db::name("business")->where(["companyNo" => $einfo['supplierNo']])->find();
  1869. $einfo['supplierName'] = isset($supplier['company']) ? $supplier['company'] : "";
  1870. }
  1871. $fo = Db::name('order_addr')->alias("a")->leftJoin("order_out b","a.id=b.addrid")
  1872. ->where(['a.orderCode' => $einfo['orderCode'], 'a.is_del' => 0])->field("a.*,b.post_name,b.post_code,
  1873. b.post_fee,b.sendtime,b.send_num,b.check_num,b.error_num,b.wsm_code,b.order_type,b.status as send_status,b.outCode")
  1874. ->select();
  1875. $addrs = [];
  1876. if (!empty($fo)) {
  1877. foreach ($fo as $value) {
  1878. $value['addr_info'] = "";
  1879. $value['send_num'] = 0;
  1880. if ($value['addr_code'] != "") {
  1881. $place = ["provice_code"=>"","city_code"=>"","area_code"=>""];
  1882. list($place['provice_code'],$place['city_code'],$place['area_code'])=explode(",",$value['addr_code']);
  1883. $addr = GetAddr(json_encode($place));
  1884. $value['addr_info'] = $addr;
  1885. }
  1886. $value['wsm_name']="";
  1887. if(isset($value['wsm_code'])&&$value['wsm_code']!=""){
  1888. $wsmcode = Db::name("warehouse_info")->where(["wsm_code" => $value['wsm_code']])->find();
  1889. $value['wsm_name'] =isset($wsmcode['name'])?$wsmcode['name']:"";
  1890. }
  1891. $addrs[] = $value;
  1892. }
  1893. }
  1894. $einfo['useage']="";
  1895. if($einfo['use_order']!=0){
  1896. $use =Db::name("order_use")->where(["id"=>$einfo['use_order']])->find();
  1897. $einfo['useage'] = isset($use['order_use']) ?$use['order_use']:"";
  1898. }else{
  1899. $einfo['use_order']='';
  1900. }
  1901. $einfo['platform_name']='';
  1902. if($einfo['platform_id']!=0){
  1903. $plat=Db::name("platform")->where(['id'=>$einfo['platform_id']])->find();
  1904. $einfo['platform_name']=isset($plat['platform_name'])?$plat['platform_name']:"";
  1905. }
  1906. $einfo['companyName'] = isset($in['companyName']) ? $in['companyName'] : "";
  1907. $einfo['addrs'] = $addrs;
  1908. $einfo['can'] = $int;
  1909. $einfo['goodinfo'] = $goon;
  1910. if (empty($einfo)) {
  1911. return error_show(1002, "未找到销售订单数据");
  1912. } else {
  1913. return app_show(0, "获取成功", $einfo);
  1914. }
  1915. }
  1916. public function del()
  1917. {
  1918. $id = isset($this->post['id']) && $this->post['id'] !== "" ? intval($this->post['id']) : "";
  1919. if ($id === "") {
  1920. return error_show(1002, "参数id不能为空");
  1921. }
  1922. $ed = Db::name('sale')->where(['id' => $id, 'is_del' => 0])->find();
  1923. if (empty($ed)) {
  1924. return error_show(1002, "未找到销售订单数据");
  1925. }
  1926. $str = Db::name('sale')->update(['id' => $id, 'is_del' => 1, 'updatetime' => date("Y-m-d H:i:s")]);
  1927. if ($str) {
  1928. $stc = ["order_code"=>$id,"status"=>$ed['status'],"action_remark"=>'',"action_type"=>"delete"];
  1929. ActionLog::logAdd($this->post['token'],$stc,"XSQRD",$ed['status'],['id' => $id, 'is_del' => 1, 'updatetime' => date("Y-m-d H:i:s")]);
  1930. $order=["order_type"=>'XSQRD',"order_code"=>$ed['orderCode'],"order_id"=>$id,"order_status"=>$ed['status']];
  1931. ProcessOrder::workdel($order);
  1932. return error_show(0, "删除成功");
  1933. } else {
  1934. return error_show(1002, "删除失败");
  1935. }
  1936. }
  1937. public function status()
  1938. {
  1939. $token = isset($this->post['token']) && $this->post['token'] !== "" ? trim($this->post['token']) : "";
  1940. $id = isset($this->post['id']) && $this->post['id'] !== "" ? intval($this->post['id']) : "";
  1941. if ($id == "") {
  1942. return error_show(1002, "参数id不能为空");
  1943. }
  1944. $status = isset($this->post['status']) && $this->post['status'] !== "" ? intval($this->post['status']) : "";
  1945. if ($status == "") {
  1946. return error_show(1002, "订单状态不能为空");
  1947. }
  1948. $dio = Db::name('sale')->where(['id' => $id, 'is_del' => 0])->find();
  1949. if (empty($dio)) {
  1950. return error_show(1002, "销售单信息未找到");
  1951. }
  1952. if ($status == 1 && $dio['order_type'] == 2) {
  1953. $zxinfo = Db::name("consult")->where(["zxNo" => $dio['zxNo'], "is_del" => 0])->find();
  1954. if ($zxinfo == false) {
  1955. return error_show(1004, "未找到咨询单数据");
  1956. }
  1957. $gold['price'] = 0;
  1958. if ($zxinfo['zx_type'] == 2) {
  1959. if ($zxinfo['metals'] == "") {
  1960. return error_show(1004, "未找到咨询单贵金属类型数据");
  1961. }
  1962. $metals = $zxinfo['metals'] == '18K' ? 1 : ($zxinfo['metals'] == '24K' ? 2 : 3);
  1963. $gold = Db::name("gold_price")->where(["type" => $metals])->order("addtime desc")->find();
  1964. if (empty($gold)) {
  1965. return error_show(1004, "未找到咨询单贵金属类型数据");
  1966. }
  1967. $dio['gold_price'] = $gold['price'];
  1968. }
  1969. $wsm = Db::name("warehouse_info")->where(["supplierNo" => $zxinfo['gysNo'], "wsm_type" => 2])->find();
  1970. if (empty($wsm)) {
  1971. return error_show(1002, "供应商仓库未找到");
  1972. }
  1973. }
  1974. $apply_id = GetUserInfo($token);
  1975. if (empty($apply_id) || $apply_id['code'] != 0) {
  1976. return error_show(1002, "申请人数据不存在");
  1977. }
  1978. $rm = isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  1979. $ri = isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  1980. Db::startTrans();
  1981. try {
  1982. $vmp =$dio['status'];
  1983. $dio['status'] = $status;
  1984. $dio['updatetime'] = date("Y-m-d H:i:s");
  1985. $st = Db::name('sale')->save($dio);
  1986. if ($st) {
  1987. $stn = ["order_code"=>$dio['orderCode'],"status"=>$vmp,"action_remark"=>'',"action_type"=>"status"];
  1988. ActionLog::logAdd($this->post['token'],$stn, $dio['order_type'] == 2?"ZXQRD":"XSQRD",$dio['status'],$dio);
  1989. $order=["order_type"=>$dio['order_type'] == 2?"ZXQRD":"XSQRD","order_code"=>$dio['orderCode'],"order_id"=>$id,"order_status"=>$dio['status']];
  1990. ProcessOrder::AddProcess($this->post['token'],$order);
  1991. if ($status == 3 && $dio['order_type'] == 1) {
  1992. $dn = Db::name('sale_info')->where(['orderCode' => $st['orderCode']])->select();
  1993. foreach ($dn as $value) {
  1994. $dm = Db::name('good_stock')->where(['wsm_code' => $value['wsm_code'], 'good_type_code' => $st['good_code']])->find();
  1995. if ($dm == "") {
  1996. Db::rollback();
  1997. return error_show(1003, "未找到商品数据");
  1998. }
  1999. if ($value['num'] > $dm['usable_stock']) {
  2000. Db::rollback();
  2001. return error_show(1002, "超出库存数量");
  2002. }
  2003. $dm['usable_stock'] -= $value['num'];
  2004. $dm['wait_out_stock'] += $value['num'];
  2005. $send = Db::name("order_out")->where(["wsm_code" => $value['wsm_code']])->sum("send_num");
  2006. $value['send_num'] = $send ?? 0;
  2007. $value['wsend_num'] = $value['num'] - $value['send_num'];
  2008. $Db = Db::name('good_stock')->update($dm);
  2009. $Db['updatetime'] = date('Y-m-d H:i:s');
  2010. if ($Db == false) {
  2011. Db::rollback();
  2012. return error_show(1002, "状态更新失败");
  2013. }
  2014. }
  2015. }
  2016. if ($status == 1 && $dio['order_type'] == 2) {
  2017. $cgd = makeNo("CG");
  2018. $clll = [
  2019. "cgdNo" => $cgd,
  2020. "bkcode" => $dio['orderCode'],
  2021. "wsm_code" => $wsm['wsm_code'],
  2022. "cgder_id" => Db::name('depart_user')->where('nickname',$zxinfo['saler'])->value('uid')??0,//重名以及多个账号的话…………
  2023. "cgder" => $zxinfo['saler'],
  2024. "good_code" => "GD-" . $zxinfo['cpNo'],
  2025. "good_name" => $zxinfo['cpName'],
  2026. "good_type_code" => $zxinfo['cpNo'],
  2027. "good_num" => $dio['good_num'],
  2028. "good_price" => $zxinfo['total_fee'],
  2029. "total_fee" => round($zxinfo['total_fee'] * $dio['good_num'], 2),
  2030. "pakge_fee" => $zxinfo['package_fee'],
  2031. "cert_fee" => $zxinfo['cert_fee'],
  2032. "open_fee" => $zxinfo['open_fee'],
  2033. "delivery_fee" => $zxinfo['delivery_fee'],
  2034. "mark_fee" => $zxinfo['mark_fee'],
  2035. "teach_fee" => $zxinfo['cost_fee'],
  2036. "demo_fee" => $zxinfo['demo_fee'],
  2037. "nake_fee" => $zxinfo['bare_fee'],
  2038. "weight" => isset($zxinfo['weight']) ? $zxinfo['weight'] : 0,
  2039. "supplierNo" => $zxinfo['gysNo'],
  2040. "supplier_name" => $zxinfo['gysname'],
  2041. "gold_price" => $gold['price'],
  2042. "send_num" => 0,
  2043. "wsend_num" => $dio['good_num'],
  2044. "remark" => '',
  2045. "lasttime" => date("Y-m-d H:i:s"),
  2046. "is_del" => 0,
  2047. "status" => $dio['send_type'] == 1 ? 3 : 0,
  2048. "order_type" => 2,
  2049. "addtime" => date("Y-m-d H:i:s"),
  2050. "updatetime" => date("Y-m-d H:i:s")
  2051. ];
  2052. $cgin = Db::name("purchease_order")->insert($clll);
  2053. // var_dump(Db::name("purchease_order")->getLastSql(),$clll);
  2054. if ($cgin == false) {
  2055. $stb = ["order_code"=>$cgd,"status"=> $clll['status'],"action_remark"=>'',"action_type"=>"create"];
  2056. ActionLog::logAdd($this->post['token'],$stb,"xsd", $clll['status'],$stb);
  2057. Db::rollback();
  2058. return error_show(1002, "咨询采购单创建商品失败");
  2059. }
  2060. if ($dio['send_type'] == 1) {
  2061. $addr = Db::name('order_addr')->where(["orderCode" => $dio['orderCode'], 'is_del' => 0])->select();
  2062. foreach ($addr as $value) {
  2063. $outCode = makeNo("DF");
  2064. $data = [
  2065. "wsm_code" => $wsm['wsm_code'],
  2066. "orderCode" => $dio['orderCode'],
  2067. "outCode" => $outCode,
  2068. "order_type" => $dio['order_type'],
  2069. "apply_id" => $rm,
  2070. "apply_name" => $ri,
  2071. "addrid" => $value['id'],
  2072. "post_name" => '',
  2073. "post_code" => '',
  2074. "post_fee" => '',
  2075. "sendtime" => date("Y-m-d H:i:s"),
  2076. "send_num" => $value['receipt_quantity'],
  2077. "check_num" => 0,
  2078. "error_num" => 0,
  2079. "status" => 0,
  2080. "addtime" => date("Y-m-d H:i:s"),
  2081. "updatetime" => date("Y-m-d H:i:s")
  2082. ];
  2083. $datainfo = Db::name('order_out')->insert($data);
  2084. if (!$datainfo) {
  2085. $sti = ["order_code"=>$dio['orderCode'],"status"=> 0,"action_remark"=>'',"action_type"=>"create"];
  2086. ActionLog::logAdd($this->post['token'],$sti,"xsd",0,$sti);
  2087. Db::rollback();
  2088. return error_show(1003, "创建失败");
  2089. }else{
  2090. //修改状态,添加待办
  2091. ActionLog::logAdd($this->post['token'], [
  2092. "order_code" => $outCode,//出库单号
  2093. "status" => 0,//这里的status是之前的值
  2094. "action_remark" => '',//备注
  2095. "action_type" => "create"//新建create,编辑edit,更改状态status
  2096. ], "CKD", 0, $data);
  2097. ProcessOrder::AddProcess($this->post['token'], [
  2098. "order_type" => 'CKD',
  2099. "order_code" => $outCode,//出库单号
  2100. "order_id" => 0,
  2101. "order_status" => 0
  2102. ]);
  2103. }
  2104. }
  2105. $wsm_in_code = makeNo("CF");
  2106. $orin = [
  2107. "wsm_in_code" => $wsm_in_code,
  2108. "cgdNo" => $cgd,
  2109. "wsm_code" => $wsm['wsm_code'],
  2110. "wsm_reaper" => "",
  2111. "send_num" => $dio['good_num'],
  2112. "post_company" => '',
  2113. "post_code" => '',
  2114. "post_fee" => '',
  2115. "sendtime" => date("Y-m-d H:i:s"),
  2116. "apply_id" => $rm,
  2117. "apply_name" => $ri,
  2118. "wait_num" => 0,
  2119. "status" => 4,
  2120. "addtime" => date("Y-m-d H:i:s"),
  2121. "updatetime" => date("Y-m-d H:i:s")
  2122. ];
  2123. $win = Db::name("purchease_in")->insert($orin);
  2124. if (!$win){
  2125. $stv = ["order_code"=>$wsm_in_code,"status"=>4,"action_remark"=>'',"action_type"=>"create"];
  2126. ActionLog::logAdd($this->post['token'],$stv,"xsd",4,$stv);
  2127. Db::rollback();
  2128. return error_show(1003, "创建失败");
  2129. }
  2130. $good = Db::name("good_stock")->where(["wsm_code" => $wsm['wsm_code'], "good_type_code" => $zxinfo['cpNo'], "is_del" => 0])->find();
  2131. if (empty($good)) {
  2132. $good = [
  2133. "good_type_code" => $zxinfo['cpNo'],
  2134. "wsm_code" => $wsm['wsm_code'],
  2135. "usable_stock" => 0,
  2136. "wait_out_stock" => 0,
  2137. "total_stock" => 0,
  2138. "addtime" => date("Y-m-d H:i:s"),
  2139. "updatetime" => date("Y-m-d H:i:s"),
  2140. ];
  2141. }
  2142. $good['wait_out_stock'] += $dio['good_num'];
  2143. $good['total_stock'] = $good['usable_stock'] + $good['wait_out_stock'];
  2144. $good['updatetime'] = date("Y-m-d H:i:s");
  2145. $upd = Db::name("good_stock")->save($good);
  2146. if (!$upd) {
  2147. $ste = ["order_code"=> $zxinfo['cpNo'],"status"=>0,"action_remark"=>'',"action_type"=>"create"];
  2148. ActionLog::logAdd($this->post['token'],$ste,"xsd",0,$ste);
  2149. Db::rollback();
  2150. return error_show(1003, "创建失败");
  2151. }
  2152. }
  2153. }
  2154. }
  2155. Db::commit();
  2156. return error_show(0, "订单状态更新成功");
  2157. } catch (Exception $e) {
  2158. Db::rollback();
  2159. return error_show(1005, $e->getMessage());
  2160. }
  2161. }
  2162. public function fee()
  2163. {
  2164. $id = isset($this->post['id']) && $this->post['id'] !== "" ? trim($this->post['id']) : "";
  2165. if ($id == "") {
  2166. return error_show(1002, "参数id不能为空");
  2167. }
  2168. $etid = Db::name("sale")->where(["id" => $id, "is_del" => 0])->find();
  2169. if (empty($etid)) {
  2170. return error_show(1002, "未找到数据");
  2171. }
  2172. $vr = isset($this->post['order_addr']) && $this->post['order_addr'] !== "" ? $this->post['order_addr'] : "";
  2173. if ($vr == "") {
  2174. return error_show(1002, "参数order_addr不能为空");
  2175. }
  2176. Db::startTrans();
  2177. try {
  2178. $data = [
  2179. "id" => $id,
  2180. "status" => 2,
  2181. "is_del" => 0,
  2182. "updatetime" => date("Y-m-d H:i:s")
  2183. ];
  2184. $datainfo = Db::name('sale')->where(['id' => $id, 'is_del' => 0])->save($data);
  2185. if ($datainfo) {
  2186. $stx = ["order_code"=> $etid['orderCode'],"status"=>$etid['status'],"action_remark"=>'',
  2187. "action_type"=>"edit"];
  2188. ActionLog::logAdd($this->post['token'],$stx,$etid['order_type'] == 2?"ZXQRD":"XSQRD",2,$data);
  2189. $order=["order_type"=>$etid['order_type'] == 2?"ZXQRD":"XSQRD","order_code"=>$etid['orderCode'],"order_id"=>$id,"order_status"=>$data['status']];
  2190. ProcessOrder::AddProcess($this->post['token'],$order);
  2191. foreach ($vr as $value) {
  2192. $tm = [];
  2193. $tm['id'] = $value['id'];
  2194. $tm['orderCode'] = $etid['orderCode'];
  2195. $tm['post_fee'] = $value['post_fee'];
  2196. $tm['updatetime'] = date("Y-m-d H:i:s");
  2197. $dn = Db::name('order_addr')->save($tm);
  2198. if ($dn == false) {
  2199. Db::rollback();
  2200. return error_show(1002, "更新失败");
  2201. }
  2202. }
  2203. Db::commit();
  2204. return error_show(0, "更新成功");
  2205. }
  2206. Db::rollback();
  2207. return error_show(1003, "更新失败");
  2208. } catch (Exception $e) {
  2209. Db::rollback();
  2210. return error_show(1005, $e->getMessage());
  2211. }
  2212. }
  2213. public function out()
  2214. {
  2215. $token = isset($this->post['token']) && $this->post['token'] !== "" ? trim($this->post['token']) : "";
  2216. $outCode = makeNo("DF");
  2217. $orderCode = isset($this->post['orderCode']) && $this->post['orderCode'] !== "" ? trim($this->post['orderCode']) : "";
  2218. if ($orderCode == "") {
  2219. return error_show(1002, "参数orderCoder不能为空");
  2220. }
  2221. $der = Db::name('sale')->where(['orderCode' => $orderCode])->find();
  2222. if ($der == "") {
  2223. return error_show(1002, "未找到出库订单单号");
  2224. }
  2225. // $wsm_code = isset($this->post['wsm_code']) && $this->post['wsm_code'] !== "" ? trim($this->post['wsm_code']) : "";
  2226. // if ($wsm_code == "") {
  2227. // return error_show(1002, "参数wsm_code不能为空");
  2228. // }
  2229. // $wsm = Db::name('sale_info')->where(['wsm_code' => $wsm_code, 'orderCode' => $der['orderCode']])->find();
  2230. // if ($wsm == "") {
  2231. // return error_show(1002, "未找到仓库编码");
  2232. // }
  2233. $post_name = isset($this->post['post_name']) && $this->post['post_name'] !== "" ? trim($this->post['post_name']) : "";
  2234. if ($post_name == "") {
  2235. return error_show(1002, "物流公司不能为空");
  2236. }
  2237. $post_code = isset($this->post['post_code']) && $this->post['post_code'] !== "" ? trim($this->post['post_code']) : "";
  2238. if ($post_code == "") {
  2239. return error_show(1002, "物流单号不能为空");
  2240. }
  2241. $post_fee = isset($this->post['post_fee']) && $this->post['post_fee'] !== "" ? intval($this->post['post_fee']) : "";
  2242. if ($post_fee == "") {
  2243. return error_show(1002, "物流费不能为空");
  2244. }
  2245. $send_num = isset($this->post['send_num']) && $this->post['send_num'] !== "" ? $this->post['send_num'] : "";
  2246. if ($send_num == "") {
  2247. return error_show(1002, "发货数量不能为空");
  2248. }
  2249. if ($send_num > $der['wsend_num']) {
  2250. return error_show(1002, "超出可发货数量");
  2251. }
  2252. $apply_id = GetUserInfo($token);
  2253. if (empty($apply_id) || $apply_id['code'] != 0) {
  2254. return error_show(1002, "申请人数据不存在");
  2255. }
  2256. $rm = isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  2257. $ri = isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  2258. $addrid = isset($this->post['addrid']) && $this->post['addrid'] !== "" ? intval($this->post['addrid']) : "";
  2259. $dr = Db::name('order_addr')->where(['id' => $addrid, 'is_del' => 0])->find();
  2260. if (empty($dr)) {
  2261. return error_show(1003, "收货人信息未找到");
  2262. }
  2263. if ($dr['orderCode'] !== $orderCode) {
  2264. return error_show(1002, "订单code不存在");
  2265. }
  2266. $sendtime = isset($this->post['sendtime']) && $this->post['sendtime'] !== "" ? $this->post['sendtime'] : date("Y-m-d H:i:s");
  2267. // $check_num = isset($this->post['check_num']) && $this->post['check_num'] !=="" ? $this->post['check_num'] :"";
  2268. // $error_num = isset($this->post['error_num']) && $this->post['error_num'] !=="" ? $this->post['error_num'] :"";
  2269. $status = isset($this->post['status']) && $this->post['status'] !== "" ? $this->post['status'] : "1";
  2270. //$order_type = isset($this->post['order_type']) && $this->post['order_type'] !=="" ? $this->post['order_type'] :"1";
  2271. //$dn=Db::name('sale_info')->where(['wsm_code'=>$outCode])->find();
  2272. Db::startTrans();
  2273. try {
  2274. $data = [
  2275. "wsm_code" => "",
  2276. "orderCode" => $orderCode,
  2277. "outCode" => $outCode,
  2278. "order_type" => $der['order_type'],
  2279. "apply_id" => $rm,
  2280. "apply_name" => $ri,
  2281. "addrid" => $dr['id'],
  2282. "post_name" => $post_name,
  2283. "post_code" => $post_code,
  2284. "post_fee" => $post_fee,
  2285. "sendtime" => $sendtime,
  2286. "send_num" => $send_num,
  2287. "check_num" => 0,
  2288. "error_num" => 0,
  2289. "status" => $status,
  2290. "addtime" => date("Y-m-d H:i:s"),
  2291. "updatetime" => date("Y-m-d H:i:s")
  2292. ];
  2293. $datainfo = Db::name('order_out')->insert($data,true);
  2294. if ($datainfo>0) {
  2295. $stx = ["order_code"=>$outCode,"status"=>$status,"action_remark"=>'',"action_type"=>"create"];
  2296. ActionLog::logAdd($this->post['token'],$stx,$der['order_type']==1?"CKD":'ZXCKD',$status,$data);
  2297. $order=["order_type"=>$der['order_type']==1?"CKD":'ZXCKD',"order_code"=>$outCode,"order_id"=>$datainfo,"order_status"=>$data['status']];
  2298. ProcessOrder::AddProcess($this->post['token'],$order);
  2299. if ($status == 1) {
  2300. $item =$der['status'];
  2301. $der['send_num'] += $send_num;
  2302. $der['wsend_num'] -= $send_num;//($der['send_num'])?$der['wsend_num'] =="" ? $der['send']
  2303. $der['send_status'] = $der['send_num'] == 0 ? 1 : $der['wsend_num'] == 0 ? 3 : 2;
  2304. $der['status'] = $der['send_num'] == 0 ? 3 : $der['wsend_num'] == 0 ? 5 : 4;
  2305. $der['updatetime'] = date("Y-m-d H:i:s");
  2306. $si = Db::name('sale')->save($der);
  2307. if ($si == false) {
  2308. Db::rollback();
  2309. return error_show(1003, "更新失败");
  2310. }
  2311. $stx = ["order_code"=>$orderCode,"status"=>$item,"action_remark"=>'',"action_type"=>"edit"];
  2312. ActionLog::logAdd($this->post['token'],$stx,$der['order_type'] == 2?"ZXQRD":"XSQRD",$der['status'],$der);
  2313. $order=["order_type"=>$der['order_type'] == 2?"ZXQRD":"XSQRD","order_code"=>$orderCode,"order_id"=>$der['id'],"order_status"=>$data['status']];
  2314. ProcessOrder::AddProcess($this->post['token'],$order);
  2315. $str = Db::name('good_stock')->where(['wsm_code' => $var['wsm_code'], 'good_type_code' => $der['good_code']])->find();
  2316. if ($str == false) {
  2317. Db::rollback();
  2318. return error_show(1002, "商品数据未找到");
  2319. }
  2320. if ($send_num > $str['wait_out_stock']) {
  2321. Db::rollback();
  2322. return error_show(1002, "超出库存数量");
  2323. }
  2324. $str['wait_out_stock'] -= $send_num;
  2325. $str['intra_stock'] += $send_num;
  2326. $str['updatetime'] = date("Y-m-d H:i:s");
  2327. $stre = Db::name('good_stock')->save($str);
  2328. if ($stre == false) {
  2329. Db::rollback();
  2330. return error_show(1002, "状态更新失败");
  2331. }
  2332. //商品变动日志表,good_log_code字段存储采购单号
  2333. $good_data[] = ['good_log_code' => $outCode, "stock_id" => $str['id'], "type" => 2, 'stock' => $send_num, "stock_name" => "wait_out_stock"];
  2334. $good_data[] = ['good_log_code' => $outCode, "stock_id" => $str['id'], "type" => 1, 'stock' => $send_num, "stock_name" => "intra_stock"];
  2335. GoodLog::LogAdd($this->post['token'],$good_data,$der['order_type'] != 1?"ZXQRD":"XSQRD");
  2336. }
  2337. Db::commit();
  2338. return error_show(0, "创建成功");
  2339. } else {
  2340. Db::rollback();
  2341. return error_show(1003, "创建失败");
  2342. }
  2343. } catch (Exception $e) {
  2344. Db::rollback();
  2345. return error_show(1005, $e->getMessage());
  2346. }
  2347. }
  2348. public function customer()
  2349. {
  2350. $outCode = isset($this->post['outCode']) && $this->post['outCode'] !== "" ? trim($this->post['outCode']) : "";
  2351. if (empty($outCode)) {
  2352. return error_show(1002, "销售订单编号不能为空");
  2353. }
  2354. $codeinfo = Db::name('order_out')->where(['outCode' => $outCode])->find();
  2355. if ($codeinfo == "") {
  2356. return error_show(1003, "未找到订单数据");
  2357. }
  2358. // $orderCode = isset($this->post['orderCode']) && $this->post['orderCode'] !=="" ? trim($this->post['orderCode']) :"";
  2359. // if($orderCode==""){
  2360. // return error_show(1002,"参数orderCoder不能为空");
  2361. // }
  2362. $dr = Db::name('sale')->where(['orderCode' => $codeinfo['orderCode']])->find();
  2363. if ($dr == "") {
  2364. return error_show(1002, "未找到销售订单");
  2365. }
  2366. $status = isset($this->post['status']) && $this->post['status'] !== "" ? $this->post['status'] : "";
  2367. if ($status == "") {
  2368. return error_show(10002, "状态不能为空");
  2369. }
  2370. Db::startTrans();
  2371. try {
  2372. $time = $codeinfo['status'];
  2373. $codeinfo['status'] = $status;
  2374. $codeinfo['updatetime'] = date("Y-m-d H:i:s");
  2375. $cust = Db::name('order_out')->save($codeinfo);
  2376. if ($cust) {
  2377. $stx = ["order_code"=>$outCode,"status"=>$time,"action_remark"=>'',"action_type"=>"status"];
  2378. ActionLog::logAdd($this->post['token'],$stx,$codeinfo['order_type'] == 2?"ZXCKD":"CKD",$codeinfo['status'],$codeinfo);
  2379. $order=["order_type"=>$codeinfo['order_type'] == 2?"ZXCKD":"CKD","order_code"=>$outCode,
  2380. "order_id"=>$codeinfo['id'],"order_status"=>$codeinfo['status']];
  2381. ProcessOrder::AddProcess($this->post['token'],$order);
  2382. if ($status == 1) {
  2383. $stokc =Db::name("good_stock")->where(['spuCode'=>$codeinfo['spuCode'],"wsm_code"=>$codeinfo['wsm_code'],
  2384. "is_del"=>0])->find();
  2385. if($stokc==false){
  2386. Db::rollback();
  2387. return error_show(1002, "未找库存到数据");
  2388. }else{
  2389. if ($codeinfo['send_num'] > $stokc['usable_stock']) {
  2390. Db::rollback();
  2391. return error_show(1002, "超出库存数量");
  2392. }
  2393. $stokc['wait_out_stock']+=$codeinfo['send_num'];
  2394. $stokc['usable_stock']-=$codeinfo['send_num'];
  2395. $stokc['updatetime']=date("Y-m-d H:i:s");
  2396. }
  2397. $stoc= Db::name("good_stock")->save($stokc);
  2398. if($stoc==false){
  2399. Db::rollback();
  2400. return error_show(1002, "库存更新失败");
  2401. }
  2402. $item =$dr['status'];
  2403. $dr['send_num'] +=$codeinfo['send_num'];
  2404. $dr['wsend_num'] -= $codeinfo['send_num'];//($der['send_num'])?$der['wsend_num'] =="" ? $der['send']
  2405. $dr['send_status'] = $dr['send_num'] == 0 ? 1 : $dr['wsend_num'] == 0 ? 3 : 2;
  2406. $dr['status'] = $dr['send_num'] == 0 ? 3 : $dr['wsend_num'] == 0 ? 5 : 4;
  2407. $dr['updatetime'] = date("Y-m-d H:i:s");
  2408. $si = Db::name('sale')->save($dr);
  2409. if ($si == false) {
  2410. Db::rollback();
  2411. return error_show(1003, "更新失败");
  2412. }
  2413. $stx = ["order_code"=>$dr['orderCode'],"status"=>$item,"action_remark"=>'',"action_type"=>"edit"];
  2414. ActionLog::logAdd($this->post['token'],$stx,$dr['order_type'] == 2?"ZXQRD":"XSQRD",$dr['status'],
  2415. $dr);
  2416. $order=["order_type"=>$dr['order_type'] == 2?"ZXQRD":"XSQRD","order_code"=>$dr['orderCode'],"order_id"=>$dr['id'],"order_status"=>$dr['status']];
  2417. ProcessOrder::AddProcess($this->post['token'],$order);
  2418. //商品变动日志表,good_log_code字段存储销售订单编号
  2419. $good_data[] = ['good_log_code' => $outCode, "stock_id" => $stoc['id'], "type" => 1, 'stock' => $codeinfo['send_num'], "stock_name" => "wait_out_stock"];
  2420. $good_data[] = ['good_log_code' => $outCode, "stock_id" => $stoc['id'], "type" => 2, 'stock' => $codeinfo['send_num'], "stock_name" => "usable_stock"];
  2421. GoodLog::LogAdd($this->post['token'],$good_data,'CKD');
  2422. }
  2423. if ($status == 3) {
  2424. $var = Db::name('good_stock')->where(['wsm_code' => $codeinfo['wsm_code'], 'good_type_code' => $dr['good_code']])->find();
  2425. if ($var == false) {
  2426. Db::rollback();
  2427. return error_show(1002, "未找到商品数据");
  2428. }
  2429. if ($codeinfo['send_num'] > $var['intra_stock']) {
  2430. Db::rollback();
  2431. return error_show(1003, "超出在途库存数量");
  2432. }
  2433. $var['intra_stock'] -= $codeinfo['send_num'];
  2434. $var['updatetime'] = date("Y-m-d H:i:s");
  2435. $stre = Db::name('good_stock')->save($var);
  2436. //商品变动日志表,good_log_code字段存储销售订单编号
  2437. $good_data[] = ['good_log_code' => $outCode, "stock_id" => $var['id'], "type" => 2, 'stock' => $codeinfo['send_num'], "stock_name" => "intra_stock"];
  2438. GoodLog::LogAdd($this->post['token'],$good_data,$codeinfo['order_type'] == 2?"ZXCKD":"CKD");
  2439. if ($stre == false) {
  2440. Db::rollback();
  2441. return error_show(1002, "状态更新失败");
  2442. }
  2443. }
  2444. Db::commit();
  2445. return error_show(0, "出库订单更新成功");
  2446. } else {
  2447. Db::rollback();
  2448. return error_show(1003, "出库订单更新失败");
  2449. }
  2450. } catch (Exception $e) {
  2451. Db::rollback();
  2452. return error_show(1005, $e->getMessage());
  2453. }
  2454. }
  2455. public function difflist()
  2456. {
  2457. $page = isset($this->post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) : "1";
  2458. $size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) : "10";
  2459. $where = [];
  2460. $cgdNo = isset($this->post['orderCode']) && $this->post['orderCode'] != "" ? trim($this->post['orderCode']) : "";
  2461. if ($cgdNo != "") {
  2462. $where[] = ['a.orderCode', "like", "%$cgdNo%"];
  2463. }
  2464. $diffNo = isset($this->post['diffCode']) && $this->post['diffCode'] != "" ? trim($this->post['diffCode']) : "";
  2465. if ($diffNo != "") {
  2466. $where[] = ['a.diffCode', "like", "%$diffNo%"];
  2467. }
  2468. $status = isset($this->post['status']) && $this->post['status'] !== "" ? intval($this->post['status']) : "";
  2469. if ($status !== "") {
  2470. $where[] = ['a.status', "=", $status];
  2471. }
  2472. $start = isset($this->post['start']) && $this->post['start'] !== "" ? $this->post['start'] : "";
  2473. if ($start != "") {
  2474. $where[] = ["a.addtime", '>=', $start];
  2475. }
  2476. $end = isset($this->post['end']) && $this->post['end'] !== "" ? $this->post['end'] : "";
  2477. if ($end != "") {
  2478. $where[] = ["a.addtime", '<=', $end];
  2479. }
  2480. // $apply_name = isset($this->post['apply_name']) && $this->post['apply_name'] !==""? intval($this->post['apply_name']):"";
  2481. // if($apply_name!==""){
  2482. // $where[]=['a.apply_name',"like","%$apply_name%"];
  2483. // }
  2484. $supplierNo = isset($this->post['supplierNo']) && $this->post['supplierNo'] !== "" ? trim($this->post['supplierNo']) : "";
  2485. if ($supplierNo != "") {
  2486. // $supplier = Db::name("business")->where([['code', "like", "%$supplierNo%"]])->column('code');
  2487. //// if(empty($supplier)){
  2488. //// return error_show(1004,"未找到供应商信息");
  2489. //// }
  2490. // $wsmcode = Db::name("sale")->where(["is_del" => 0, "supplierNo" => $supplier])->column("orderCode");
  2491. $where[] = ['c.supplierNo', "like", "%$supplierNo%"];
  2492. }
  2493. $companyNo =isset($this->post['companyNo']) &&$this->post['companyNo'] !=="" ? trim($this->post['companyNo']):"";
  2494. if($companyNo!=""){
  2495. $where[]=['c.customer_code',"like","%$companyNo%"];
  2496. }
  2497. $count = Db::name('sale_diff')->alias('a')
  2498. ->join("sale c", "c.orderCode=a.orderCode", "left")
  2499. ->join("customer_info v", "v.companyNo=c.customer_code", "left")
  2500. ->where($where)->count();
  2501. $total = ceil($count / $size);
  2502. $page = $page >= $total ? intval($total) : $page;
  2503. $list = Db::name('sale_diff')->alias('a')
  2504. ->join("sale c", "c.orderCode=a.orderCode", "left")
  2505. ->join("customer_info v", "v.companyNo=c.customer_code", "left")
  2506. ->where($where)->page($page, $size)->field("a.*,c.customer_code,v.companyName,c.skuCode,c.order_type,c.supplierNo")
  2507. ->order("a.addtime desc")->select();
  2508. $data = [];
  2509. foreach ($list as $value) {
  2510. if($value['order_type']==3|| $value['order_type']==4){
  2511. $goon = Db::name("good_zixun")->where(["spuCode"=>$value['good_code'],"is_del"=>0])->find();
  2512. }else {
  2513. $goon = Db::name('good_platform')->alias('a')->join('good b', 'b.spuCode=a.spuCode', 'left')
  2514. ->where(['a.skuCode' => $value['skuCode']])->find();
  2515. }
  2516. $value['can'] = isset($goon['cat_id']) && $goon['cat_id'] != 0 ? made($goon['cat_id']) : [];
  2517. $wsm = Db::name("business")->where(['companyNo' => $value['supplierNo']])->find();
  2518. $value['supplierNo'] = isset($wsm['companyNo']) ? $wsm['companyNo'] : "";
  2519. $value['supplierName'] = isset($wsm['company']) ? $wsm['company'] : "";
  2520. $data[] = $value;
  2521. }
  2522. return app_show(0, "获取成功", ['list' => $data, 'count' => $count]);
  2523. }
  2524. /**
  2525. * @return \think\response\Json|void
  2526. * @throws \think\db\exception\DataNotFoundException
  2527. * @throws \think\db\exception\DbException
  2528. * @throws \think\db\exception\ModelNotFoundException
  2529. */
  2530. public function diffcheck()
  2531. {
  2532. $token = isset($this->post['token']) && $this->post['token'] !== "" ? trim($this->post['token']) : "";
  2533. $id = isset($this->post['id']) && $this->post['id'] !== "" ? intval($this->post['id']) : "";
  2534. if ($id === "") {
  2535. return error_show(1004, "参数id不能为空");
  2536. }
  2537. $info = Db::name("sale_diff")->where(["id" => $id])->find();
  2538. if (empty($info)) {
  2539. return error_show(1004, "订单数据未找到");
  2540. }
  2541. $is_act = isset($this->post['is_act']) && $this->post['is_act'] !== "" ? intval($this->post['is_act']) : "";
  2542. if ($is_act === '') {
  2543. return error_show(1004, "参数is_act不能为空");
  2544. }
  2545. $customer_remark = isset($this->post['customer_remark']) && $this->post['customer_remark'] !== "" ? trim($this->post['customer_remark']) : "";
  2546. if ($customer_remark === '') {
  2547. return error_show(1004, "参数customer_remark不能为空");
  2548. }
  2549. $status = isset($this->post['status']) && $this->post['status'] !== "" ? intval($this->post['status']) : "2";
  2550. $remark = isset($this->post['remark']) && $this->post['remark'] !== "" ? trim($this->post['remark']) : "";
  2551. $item = $info['status'];
  2552. $info['is_act'] = $is_act;
  2553. $info['customer_remark'] = $customer_remark;
  2554. $info['status'] = $status;
  2555. $info['remark'] = $remark;
  2556. $info['updatetime'] = date("Y-m-d H:i:s");
  2557. $up = Db::name("sale_diff")->save($info);
  2558. if ($up) {
  2559. $stx = ["order_code"=>$info["orderCode"],"status"=>$item,"action_remark"=>'',"action_type"=>"edit"];
  2560. ActionLog::logAdd($this->post['token'],$stx,"QRGCD",$info['status'],$info);
  2561. $order=["order_type"=>"QRGCD","order_code"=>$info["orderCode"],"order_id"=>$info['id'],"order_status"=>$info['status']];
  2562. ProcessOrder::AddProcess($this->post['token'],$order);
  2563. return app_show(0, "更新成功");
  2564. } else {
  2565. return error_show(1003, "更新失败");
  2566. }
  2567. }
  2568. /**
  2569. * @return \think\response\Json|void
  2570. * @throws \think\db\exception\DataNotFoundException
  2571. * @throws \think\db\exception\DbException
  2572. * @throws \think\db\exception\ModelNotFoundException
  2573. */
  2574. public function diffstatus()
  2575. {
  2576. $token = isset($this->post['token']) && $this->post['token'] !== "" ? trim($this->post['token']) : "";
  2577. $id = isset($this->post['id']) && $this->post['id'] !== "" ? intval($this->post['id']) : "";
  2578. if ($id === "") {
  2579. return error_show(1004, "参数id不能为空");
  2580. }
  2581. $info = Db::name("sale_diff")->where(["id" => $id])->find();
  2582. if ($info==false) {
  2583. return error_show(1004, "订单数据未找到");
  2584. }
  2585. $cgd = Db::name("purchease_diff")->where(['id'=>$info['cgd_diffid']])->find();
  2586. if($cgd==false){
  2587. return error_show(1004, "采购工差单数据未找到");
  2588. }
  2589. $status = isset($this->post['status']) && $this->post['status'] !== "" ? intval($this->post['status']) : "3";
  2590. $remark = isset($this->post['remark']) && $this->post['remark'] !== "" ? trim($this->post['remark']) : "";
  2591. $ite=$info['status'];
  2592. Db::startTrans();
  2593. try{
  2594. $upda=[
  2595. "status"=>$status,
  2596. "remark"=>$remark,
  2597. "updatetime"=> date("Y-m-d H:i:s"),
  2598. ];
  2599. $up = Db::name("sale_diff")->where($info)->save($upda);
  2600. if ($up) {
  2601. $stx = ["order_code"=>$info["orderCode"],"status"=>$ite,"action_remark"=>'',"action_type"=>"status"];
  2602. ActionLog::logAdd($this->post['token'],$stx,"QRGCD",$info['status'],$info);
  2603. $order=["order_type"=>"QRGCD","order_code"=>$info["orderCode"],"order_id"=>$info['id'],"order_status"=>$status];
  2604. ProcessOrder::AddProcess($this->post['token'],$order);
  2605. $cgdup =Db::name("purchease_diff")->where(["id"=>$info['cgd_diffid']])->save($upda);
  2606. if($cgdup){
  2607. Db::commit();
  2608. return app_show(0, "更新成功");
  2609. }
  2610. }
  2611. Db::rollback();
  2612. return error_show(1003, "更新失败");
  2613. }catch (\Exception $e){
  2614. Db::rollback();
  2615. return error_show(1003,$e->getMessage());
  2616. }
  2617. }
  2618. /**
  2619. * @return \think\response\Json|void
  2620. * @throws \think\db\exception\DataNotFoundException
  2621. * @throws \think\db\exception\DbException
  2622. * @throws \think\db\exception\ModelNotFoundException
  2623. */
  2624. public function diffinfo()
  2625. {
  2626. $id = isset($this->post['id']) && $this->post['id'] !== "" ? intval($this->post['id']) : "";
  2627. if ($id === "") {
  2628. return error_show(1004, "参数id不能为空");
  2629. }
  2630. $info = Db::name('sale_diff')->where(["id" => $id])->find();
  2631. if (empty($info)) {
  2632. return error_show(1004, "工差订单数据未找到");
  2633. }
  2634. $einfo = Db::name('sale')->where(['orderCode' => $info['orderCode'], 'is_del' => 0])->find();
  2635. if ($einfo==false) {
  2636. return error_show(1002, "未找到销售订单数据");
  2637. }
  2638. if($einfo['order_type']==3|| $einfo['order_type']==4){
  2639. $goon = Db::name("good_zixun")->where(["spuCode"=>$einfo['good_code'],"is_del"=>0])->find();
  2640. }else {
  2641. $goon = Db::name('good_platform')->alias('a')->join('good b', 'b.spuCode=a.spuCode', 'left')
  2642. ->where(['a.skuCode' => $einfo['skuCode']])->find();
  2643. }
  2644. if($goon==false){
  2645. return error_show(1002, "未找到商品数据");
  2646. }
  2647. $info['skuCode'] =isset($goon['skuCode']) ? $goon['skuCode']:"";
  2648. $info['spuCode'] =isset($goon['spuCode']) ? $goon['spuCode']:"";
  2649. $info['order_type'] =isset($einfo['order_type']) ? $einfo['order_type']:"";
  2650. $info['can'] = isset($info['cat_id']) && $info['cat_id'] !== 0 ? made($info['cat_id']) : [];
  2651. return app_show(0, "获取成功", $info);
  2652. }
  2653. public function saleout(){
  2654. $page = isset($this->post['page']) && $this->post['page'] !=="" ? intval($this->post['page']):"1";
  2655. $size = isset($this->post['size']) && $this->post['size'] !=="" ? intval($this->post['size']) :"10";
  2656. $where= [];
  2657. $orderCode=isset($this->post['orderCode']) && $this->post['orderCode'] !=="" ? trim($this->post['orderCode'])
  2658. :"";
  2659. if($orderCode !==""){
  2660. $where[]=['a.orderCode',"like","%$orderCode%"];
  2661. }
  2662. $order_type=isset($this->post['order_type']) && $this->post['order_type'] !=="" ? trim($this->post['order_type'])
  2663. :"";
  2664. if($order_type !==""){
  2665. $where[]=['a.order_type',"=",$order_type];
  2666. }
  2667. $outCode=isset($this->post['outCode']) && $this->post['outCode'] !=="" ? trim($this->post['outCode'])
  2668. :"";
  2669. if($outCode !==""){
  2670. $where[]=['a.outCode',"like","%$outCode%"];
  2671. }
  2672. $apply_name=isset($this->post['apply_name']) && $this->post['apply_name'] !=="" ? trim($this->post['apply_name'])
  2673. :"";
  2674. if($apply_name !==""){
  2675. $where[]=['a.apply_name',"like","%$apply_name%"];
  2676. }
  2677. $good_code=isset($this->post['good_code']) && $this->post['good_code'] !=="" ? trim($this->post['good_code'])
  2678. :"";
  2679. if($good_code !==""){
  2680. $where[]=['b.good_code',"like","%$good_code%"];
  2681. }
  2682. $good_name=isset($this->post['good_name']) && $this->post['good_name'] !=="" ? trim($this->post['good_name'])
  2683. :"";
  2684. if($good_name !==""){
  2685. $where[]=['b.good_name',"like","%$good_name%"];
  2686. }
  2687. $status=isset($this->post['status']) && $this->post['status'] !=="" ? trim($this->post['status']):"";
  2688. if($status !==""){
  2689. $where[]=['a.status',"=",$status];
  2690. }
  2691. $start = isset($this->post['start']) && $this->post['start'] !=="" ? $this->post['start'] :"";
  2692. if($start !=""){
  2693. $where[]= ["a.addtime",'>=',$start];
  2694. }
  2695. $end = isset($this->post['end']) && $this->post['end'] !=="" ? $this->post['end'] :"";
  2696. if($end !=""){
  2697. $where[]= ["a.addtime",'<=',$end];
  2698. }
  2699. $companyNo =isset($this->post['companyNo']) &&$this->post['companyNo'] !=="" ? trim($this->post['companyNo']):"";
  2700. if($companyNo!=""){
  2701. $where[]=['b.customer_code',"like","%$companyNo%"];
  2702. }
  2703. $count = Db::name('order_out')->alias('a')
  2704. ->join("sale b", "b.orderCode=a.orderCode", "left")
  2705. ->join("customer_info v", "v.companyNo=b.customer_code", "left")
  2706. //->join("good n","n.good_code=b.good_code","left")
  2707. ->where($where)->count();
  2708. $total = ceil($count / $size);
  2709. $page = $page >= $total ? $total : $page;
  2710. $list = Db::name('order_out')->alias('a')->join("sale b", "b.orderCode=a.orderCode", "left")
  2711. ->join("customer_info v", "v.companyNo=b.customer_code", "left")
  2712. //->join("good n","n.good_code=b.good_code","left")
  2713. ->field("a.*,b.good_name,b.good_code,b.skuCode,b.supplierNo,b.customer_code,v.companyName,b.origin_price,b.sale_price,b.total_price")
  2714. ->where($where)->order("addtime desc")->page($page, $size)->select();
  2715. $data=[];
  2716. foreach ($list as $value) {
  2717. $wsmcode = Db::name("warehouse_info")->alias("k")->leftJoin("supplier c", "k.supplierNo=c.code")
  2718. ->where(["k.wsm_code" => $value['wsm_code']])->field("k.name as wsm_name,c.name,c.code")->find();
  2719. $addr = Db::name("order_addr")->where(["id" => $value['addrid']])->find();
  2720. if($value['order_type']==3|| $value['order_type']==4){
  2721. $goon = Db::name("good_zixun")->where(["spuCode"=>$value['good_code'],"is_del"=>0])->find();
  2722. }else {
  2723. $goon = Db::name('good_platform')->alias('a')->join('good b', 'b.spuCode=a.spuCode', 'left')
  2724. ->where(['a.skuCode' => $value['skuCode']])->find();
  2725. }
  2726. $value['wsm_name'] = isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name'] : "";
  2727. $value['wsm_supplier'] = isset($wsmcode['name']) ? $wsmcode['name'] : "";
  2728. $value['wsm_supplierNo'] = isset($wsmcode['code']) ? $wsmcode['code'] : "";
  2729. $value['addr'] = isset($addr['addr']) ? $addr['addr'] : "";
  2730. $value['contactor'] = isset($addr['contactor']) ? $addr['contactor'] : "";
  2731. $value['mobile'] = isset($addr['mobile']) ? $addr['mobile'] : "";
  2732. $value['can'] = isset($goon['cat_id']) && $goon['cat_id'] != 0 ? made($goon['cat_id']) : [];
  2733. $data[] = $value;
  2734. }
  2735. return app_show(0, "获取成功", ['list' => $data, 'count' => $count]);
  2736. }
  2737. public function outinfo()
  2738. {
  2739. $outCode = isset($this->post['outCode']) && $this->post['outCode'] !== "" ? trim($this->post['outCode']) : "";
  2740. if ($outCode == "") {
  2741. return error_show(1002, "参数outcode不能为空");
  2742. }
  2743. $codeinfo = Db::name("order_out")->where(['outCode' => $outCode])->find();
  2744. if (empty($codeinfo)) {
  2745. return error_show(1002, "未找到出库数据");
  2746. }
  2747. $item = Db::name("sale")->where(['orderCode' => $codeinfo['orderCode']])->find();
  2748. if($item['order_type']==3|| $item['order_type']==4){
  2749. $goodinfo = Db::name("good_zixun")->where(["spuCode"=>$item['good_code'],"is_del"=>0])->find();
  2750. if($goodinfo==false){
  2751. return error_show(1004,"未找到商品数据");
  2752. }
  2753. }else{
  2754. $goodinfo = Db::name('good_platform')->alias('a')->join('good b', 'b.spuCode=a.spuCode', 'left')
  2755. ->where(['a.skuCode' =>$item['skuCode']])->find();
  2756. if ($goodinfo == false) {
  2757. return error_show(1002, "未找到商品数据");
  2758. }
  2759. }
  2760. $int = isset($goodinfo['cat_id']) && $goodinfo['cat_id'] != 0 ? made($goodinfo['cat_id']) : [];
  2761. $addr = Db::name("order_addr")->where(["id" => $codeinfo['addrid']])->find();
  2762. $codeinfo['good_name'] = isset($item['good_name']) ? $item['good_name'] : "";
  2763. $codeinfo['good_num'] = isset($item['good_num']) ? $item['good_num'] : "";
  2764. $codeinfo['good_code'] = isset($item['good_code']) ? $item['good_code'] : "";
  2765. $codeinfo['origin_price'] = isset($item['origin_price']) ? $item['origin_price'] : "";
  2766. $codeinfo['sale_price'] = isset($item['sale_price']) ? $item['sale_price'] : "";
  2767. $codeinfo['total_price'] = isset($item['total_price']) ? $item['total_price'] : "";
  2768. $codeinfo['skuCode'] = isset($item['skuCode']) ? $item['skuCode'] : "";
  2769. $codeinfo['addr'] = GetAddr($addr['addr_code']);
  2770. $codeinfo['addr'] .= isset($addr['addr']) ? $addr['addr'] : "";
  2771. $codeinfo['addr_code'] = isset($addr['addr_code']) ? $addr['addr_code'] : "";
  2772. $codeinfo['contactor'] = isset($addr['contactor']) ? $addr['contactor'] : "";
  2773. $codeinfo['mobile'] = isset($addr['mobile']) ? $addr['mobile'] : "";
  2774. $codeinfo['can'] = $int;
  2775. $orderReturn = Db::name("order_return")->where(["outCode"=>$outCode,"is_del"=>0])->order("id desc")->find();
  2776. $codeinfo['order_return'] = $orderReturn ;
  2777. return app_show(0, "获取成功", $codeinfo);
  2778. }
  2779. public function outadd(){
  2780. $token = isset($this->post['token']) && $this->post['token'] !== "" ? trim($this->post['token']) : "";
  2781. $orderCode = isset($this->post['orderCode']) && $this->post['orderCode'] !== "" ? trim($this->post['orderCode']) : "";
  2782. if ($orderCode == "") {
  2783. return error_show(1002, "参数orderCoder不能为空");
  2784. }
  2785. $der = Db::name('sale')->where(['orderCode' => $orderCode,"is_del"=>0])->find();
  2786. if ($der == "") {
  2787. return error_show(1002, "未找到出库订单单号");
  2788. }
  2789. $send_num = isset($this->post['send_num']) && $this->post['send_num'] !== "" ? $this->post['send_num'] : "";
  2790. if ($send_num == "") {
  2791. return error_show(1002, "发货数量不能为空");
  2792. }
  2793. if ($send_num > $der['wsend_num']) {
  2794. return error_show(1002, "超出可发货数量");
  2795. }
  2796. $contactor = isset($this->post['contactor'])&&$this->post['contactor']!="" ? trim($this->post['contactor']):"";
  2797. if($contactor==""){
  2798. return error_show(1002, "参数contactor不能为空");
  2799. }
  2800. $mobile = isset($this->post['mobile'])&&$this->post['mobile']!="" ? trim($this->post['mobile']):"";
  2801. if($mobile==""){
  2802. return error_show(1002, "参数mobile不能为空");
  2803. }
  2804. $addr = isset($this->post['addr'])&&$this->post['addr']!="" ? trim($this->post['addr']):"";
  2805. if($addr==""){
  2806. return error_show(1002, "参数addr不能为空");
  2807. }
  2808. $addr_code = isset($this->post['addr_code'])&&$this->post['addr_code']!="" ? trim($this->post['addr_code']):"";
  2809. if($addr_code==""){
  2810. return error_show(1002, "参数addr_code不能为空");
  2811. }
  2812. $apply_id = GetUserInfo($token);
  2813. if (empty($apply_id) || $apply_id['code'] != 0) {
  2814. return error_show(1002, "申请人数据不存在");
  2815. }
  2816. $rm = isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  2817. $ri = isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  2818. $sendtime = isset($this->post['sendtime']) && $this->post['sendtime'] !== "" ? $this->post['sendtime'] : date("Y-m-d H:i:s");
  2819. $order =Db::name("order_num")->where(["orderCode"=>$orderCode,"status"=>1])->where([["wsend_num",">=",0]])
  2820. ->find();
  2821. if(empty($order)){
  2822. return error_show(1004,"未找到可以发货得采购单数据");
  2823. }
  2824. Db::startTrans();
  2825. try {
  2826. $order =Db::name("order_num")->where(["orderCode"=>$orderCode,"status"=>1])->where([["wsend_num",">=",0]])
  2827. ->lock(true)->find();
  2828. if($order==false){
  2829. Db::rollback();
  2830. return error_show(1004,"未找到可以发货得采购单数据");
  2831. }
  2832. $addrlst =[
  2833. "orderCode"=>$orderCode,
  2834. "addr"=>$addr,
  2835. "addr_code"=>json_encode($addr_code),
  2836. "contactor"=>$contactor,
  2837. "mobile"=>$mobile,
  2838. "customer_code"=>$der['customer_code'],
  2839. "post_fee"=>$der['post_fee'],
  2840. "arrive_time"=>$sendtime,
  2841. "receipt_quantity"=>$send_num,
  2842. "is_del"=>0,
  2843. "addtime"=>date("Y-m-d H:i:s"),
  2844. "updatetime"=>date("Y-m-d H:i:s")
  2845. ];
  2846. $addrid = Db::name("order_addr")->insert($addrlst,true);
  2847. if($addrid>0){
  2848. $der['send_num'] +=$send_num;
  2849. $der['wsend_num'] -= $send_num;
  2850. $der['send_status'] = $der['send_num'] == 0 ? 1 : $der['wsend_num'] == 0 ? 3 : 2;
  2851. $der['status'] = $der['send_num'] == 0 ? 0 : $der['wsend_num'] == 0 ?2 :1;
  2852. $der['updatetime'] = date("Y-m-d H:i:s");
  2853. $si = Db::name('sale')->save($der);
  2854. if($si==false){
  2855. Db::rollback();
  2856. return error_show(1002,"出库单新建失败");
  2857. }
  2858. $outCode = makeNo("DF");
  2859. $cgd =Db::name("purchease_order")->where(["cgdNo"=>$order['cgdNo']])->find();
  2860. if($cgd==false){
  2861. Db::rollback();
  2862. return error_show(1002,"未找到对应的采购单数据");
  2863. }
  2864. $order['wsend_num']-=$send_num;
  2865. $order['send_num']+=$send_num;
  2866. $or =Db::name("order_num")->save($order);
  2867. if($or==false){
  2868. Db::rollback();
  2869. return error_show(1002,"发货地址添加创建失败");
  2870. }
  2871. $tep=[
  2872. "cgdNo"=>$order['cgdNo'],
  2873. "outCode"=>$outCode,
  2874. "send_num"=>$send_num,
  2875. "status"=>1,
  2876. "addtime"=>date("Y-m-d H:i:s"),
  2877. "updatetime"=>date("Y-m-d H:i:s")
  2878. ];
  2879. $sen=Db::name("order_send")->save($tep);
  2880. if($sen==false){
  2881. Db::rollback();
  2882. return error_show(1002,"发货地址添加创建失败");
  2883. }
  2884. $data = [
  2885. "wsm_code" => isset($cgd['wsm_code'])? $cgd['wsm_code']:"",
  2886. "orderCode" => $orderCode,
  2887. "outCode" => $outCode,
  2888. "order_type" => $der['order_type'],
  2889. "apply_id" => $rm,
  2890. "apply_name" => $ri,
  2891. "addrid" => $addrid,
  2892. "post_name" => "",
  2893. "post_code" =>"",
  2894. "post_fee" => "",
  2895. "sendtime" => $sendtime,
  2896. "send_num" => $send_num,
  2897. "check_num" => 0,
  2898. "error_num" => 0,
  2899. "status" => 1,
  2900. "addtime" => date("Y-m-d H:i:s"),
  2901. "updatetime" => date("Y-m-d H:i:s")
  2902. ];
  2903. if($der['is_stock']==0){
  2904. //维护商品所在仓库的库存 --- start
  2905. $temp = Db::name('good_stock')
  2906. ->field('id,usable_stock,wait_out_stock')
  2907. ->where(['spuCode' => $der['good_code'], 'wsm_code' => $cgd['wsm_code']])
  2908. ->find();
  2909. if ($temp == false) {
  2910. Db::rollback();
  2911. return error_show(1004, '库存不足');
  2912. }
  2913. if (($temp['usable_stock'] - $send_num) < 0) {
  2914. Db::rollback();
  2915. return error_show(1004, '库存不足');
  2916. }
  2917. $up =Db::name('good_stock')
  2918. ->where('id', $temp['id'])
  2919. ->update([
  2920. 'usable_stock' => $temp['usable_stock'] - $send_num,
  2921. 'wait_out_stock' => $temp['wait_out_stock'] + $send_num,
  2922. 'updatetime' => date('Y-m-d H:i:s'),
  2923. ]);
  2924. if($up==false){
  2925. Db::rollback();
  2926. return error_show(1004, '库存更新失败');
  2927. }
  2928. }
  2929. $datainfo = Db::name('order_out')->insert($data,true);
  2930. if($datainfo>0){
  2931. //修改状态,添加待办
  2932. ActionLog::logAdd($this->post['token'], [
  2933. "order_code" => $data['outCode'],//出库单号
  2934. "status" => $data['status'],//这里的status是之前的值
  2935. "action_remark" => '',//备注
  2936. "action_type" => "create"//新建create,编辑edit,更改状态status
  2937. ], "CKD", $data['status'], $data);
  2938. ProcessOrder::AddProcess($this->post['token'], [
  2939. "order_type" => 'CKD',
  2940. "order_code" => $data['outCode'],//出库单号
  2941. "order_id" => $datainfo,
  2942. "order_status" => $data['status']
  2943. ]);
  2944. Db::commit();
  2945. return app_show(0,"出库单新建成功");
  2946. }
  2947. }
  2948. Db::rollback();
  2949. return error_show(1004,"出库单新建失败");
  2950. } catch (Exception $e) {
  2951. Db::rollback();
  2952. return error_show(1005, $e->getMessage());
  2953. }
  2954. }
  2955. public function outdel(){
  2956. }
  2957. public function outSend(){
  2958. $outCode=isset($this->post['outCode'])&& $this->post['outCode']!=""? trim($this->post['outCode']):"";
  2959. if($outCode==""){
  2960. return error_show(1004,"参数outCode不能为空");
  2961. }
  2962. $outinfo = Db::name("order_out")->where(["outCode"=>$outCode])->find();
  2963. if($outinfo==false){
  2964. return error_show(1004,"发货数据未找到");
  2965. }
  2966. $einfo = Db::name('sale')->where(['orderCode' => $outinfo['orderCode'], 'is_del' => 0])->find();
  2967. if (empty($einfo)) {
  2968. return error_show(1002, "未找到销售订单数据");
  2969. }
  2970. $post_name = isset($this->post['post_name']) &&$this->post['post_name']!="" ? trim($this->post['post_name']):"";
  2971. if($post_name==""){
  2972. return error_show(1004,"参数post_name不能为空");
  2973. }
  2974. $post_code = isset($this->post['post_code']) &&$this->post['post_code']!="" ? trim($this->post['post_code']):"";
  2975. if($post_code==""){
  2976. return error_show(1004,"参数post_code不能为空");
  2977. }
  2978. $post_fee = isset($this->post['post_fee']) && $this->post['post_fee']!="" ? floatval($this->post['post_fee']):"";
  2979. $outinfo['post_name'] = $post_name;
  2980. $outinfo['post_code'] = $post_code;
  2981. $outinfo['post_fee'] = $post_fee;
  2982. $outinfo['sendtime'] = date("Y-m-d H:i:s");
  2983. $old_outinfo_status = $outinfo['status'];
  2984. $outinfo['status'] = 2;
  2985. $outinfo['updatetime'] = date("Y-m-d H:i:s");
  2986. Db::startTrans();
  2987. try{
  2988. $up =Db::name("order_out")->save($outinfo);
  2989. if($up){
  2990. //修改状态,添加待办
  2991. ActionLog::logAdd($this->post['token'], [
  2992. "order_code" => $outinfo['outCode'],//出库单号
  2993. "status" => $old_outinfo_status,//这里的status是之前的值
  2994. "action_remark" => '',//备注
  2995. "action_type" => "edit"//新建create,编辑edit,更改状态status
  2996. ], "CKD", $outinfo['status'], $outinfo);
  2997. ProcessOrder::AddProcess($this->post['token'], [
  2998. "order_type" => 'CKD',
  2999. "order_code" => $outinfo['outCode'],//出库单号
  3000. "order_id" => $outinfo['id'],
  3001. "order_status" => $outinfo['status']
  3002. ]);
  3003. $stokc =Db::name("good_stock")->where(['spuCode'=>$einfo['good_code'],"wsm_code"=>$outinfo['wsm_code'],"is_del"=>0])->find();
  3004. if($stokc==false){
  3005. Db::rollback();
  3006. return error_show(1002, "未找库存到数据");
  3007. }else{
  3008. if ($outinfo['send_num'] > $stokc['wait_out_stock']) {
  3009. Db::rollback();
  3010. return error_show(1002, "超出库存数量");
  3011. }
  3012. $stokc['wait_out_stock']-=$outinfo['send_num'];
  3013. // $stokc['intra_stock']+=$outinfo['send_num'];
  3014. $stokc['updatetime']=date("Y-m-d H:i:s");
  3015. }
  3016. $stoc= Db::name("good_stock")->save($stokc);
  3017. if($stoc==false){
  3018. Db::rollback();
  3019. return error_show(1002, "库存更新失败");
  3020. }
  3021. Db::commit();
  3022. return app_show(0,"发货成功");
  3023. }else{
  3024. Db::rollback();
  3025. return error_show(1004,"发货失败");
  3026. }
  3027. }catch (\Exception $e){
  3028. Db::rollback();
  3029. return error_show(1004,$e->getMessage());
  3030. }
  3031. }
  3032. public function RelaCgd($outinfo){
  3033. $cgd = Db::name("order_bk")->where([["spuCode","=",$outinfo['spuCode']],["is_del","=",0],["balance_num",">=",
  3034. $outinfo['good_num']],['companyNo',"=",$outinfo['companyNo']]])->lock(true)->find();
  3035. if($cgd==false){
  3036. return false;
  3037. }
  3038. $cgd['balance_num']-=$outinfo['good_num'];
  3039. $cgd['merge_num']+=$outinfo['good_num'];
  3040. $cgd['updatetime']=date("Y-m-d H:i:s");
  3041. $up=Db::name("order_bk")->save($cgd);
  3042. if($up==false){
  3043. return false;
  3044. }
  3045. $data=[
  3046. "orderCode"=>$outinfo['orderCode'],
  3047. "cgdNo"=>$cgd['cgdNo'],
  3048. "spuCode"=>$outinfo['spuCode'],
  3049. "companyNo"=>$outinfo['companyNo'],
  3050. "good_num"=>$outinfo['good_num'],
  3051. "wsend_num"=>$outinfo['good_num'],
  3052. "send_num"=>0,
  3053. "wait_num"=>$outinfo['good_num'],
  3054. "status"=>1,
  3055. "source"=>1,
  3056. ];
  3057. $order =Db::name("order_num")->save($data);
  3058. if($order==false){
  3059. return false;
  3060. }
  3061. return true;
  3062. }
  3063. public function addother(){
  3064. $orderCode =isset($this->post['orderCode']) && $this->post['orderCode']!=""?trim($this->post['orderCode']):"";
  3065. if($orderCode==""){
  3066. return error_show(1004,"参数orderCode不能为空");
  3067. }
  3068. $order =Db::name("sale")->where(["orderCode"=>$orderCode,"is_del"=>0])->find();
  3069. if($order==false){
  3070. return error_show(1004,"未找到订单数据");
  3071. }
  3072. $paytime =isset($this->post['paytime'])&&$this->post['paytime']!=""? $this->post['paytime']:"";
  3073. $workNo =isset($this->post['workNo'])&&$this->post['workNo']!=""? trim($this->post['workNo']):"";
  3074. $platform_order =isset($this->post['platform_order'])&&$this->post['platform_order']!=""? trim($this->post['platform_order']):"";
  3075. $paytime==""?"":$order['paytime']=$paytime;
  3076. $order['workNo']=$workNo;
  3077. $order['platform_order']=$platform_order;
  3078. $order['updatetime']=date("Y-m-d H:i:s");
  3079. $sa=Db::name("sale")->save($order);
  3080. if($sa){
  3081. return app_show(0,"更新成功");
  3082. }else{
  3083. return error_show(1004,"更新失败");
  3084. }
  3085. }
  3086. public function getPrice()
  3087. {
  3088. $skuCode = isset($this->post['skuCode']) && $this->post['skuCode'] != "" ? trim($this->post['skuCode']) : "";
  3089. if ($skuCode === "") {
  3090. return error_show(1003, "参数skuCode不能为空");
  3091. }
  3092. $is_activity = isset($this->post['is_activity']) && $this->post['is_activity'] !== "" ? intval($this->post['is_activity'])
  3093. : "";
  3094. if ($is_activity === "") {
  3095. return error_show(1003, "参数is_activity不能为空");
  3096. }
  3097. $sale_num = isset($this->post['sale_num']) && $this->post['sale_num'] !== "" ? intval($this->post['sale_num']) : "";
  3098. if ($sale_num === "") {
  3099. return error_show(1003, "参数sale_num不能为空");
  3100. }
  3101. $ct = Db::name('good_platform')->alias('a')->join('good b', 'b.spuCode=a.spuCode', 'left')
  3102. ->where(['a.skuCode' => $skuCode])->find();
  3103. if ($ct == false) {
  3104. return error_show(1002, "未找到商品数据");
  3105. }
  3106. $stock = 0;
  3107. if ($ct['is_stock'] == 1) {
  3108. $good_stock = Db::name("good_stock")->where(["spuCode" => $ct['spuCode'], "is_del" => 0])->find();
  3109. $stock = isset($good_stock['usable_stock']) ? $good_stock['usable_stock'] : "0";
  3110. }
  3111. if ($is_activity == 1) {
  3112. $act = Db::name("activity_info")->alias("a")->leftJoin("good_activity b", "a.activity_code=b.activity_code")
  3113. ->where(["a.skuCode" => $skuCode, "a.is_del" => 0, "a.status" => 1, "b.status" => 6, "b.is_del" => 0])->find();
  3114. if ($act == false) {
  3115. return error_show(1003, "未找到相关活动价");
  3116. }
  3117. if ($act['moq_num'] > $sale_num) {
  3118. return error_show(1003, "商品不满足活动价起订量{$act['moq_num']}");
  3119. }
  3120. if ($act['activity_stock'] < $sale_num) {
  3121. return error_show(1003, "商品活动库存剩余{$act['activity_stock']}");
  3122. }
  3123. return app_show(0, "获取成功", ['sale_price' => $act['activity_price'], "stock" => $act['activity_stock']]);
  3124. } else {
  3125. if ($ct['is_stock'] == 0) {
  3126. //good_nake 成本阶梯 good_ladder销售阶梯
  3127. $origin = Db::name("good_nake")->where([["spuCode", "=", $ct['spuCode']], ["is_del", "=", 0]])->order("min_num asc")->find();
  3128. if (!$origin) {
  3129. return error_show(1003, "没有找到成本数据");
  3130. }
  3131. }
  3132. $good = Db::name("good_ladder")->where(["skuCode" => $skuCode, "is_del" => 0, "status" => 1])->order("min_num asc")->find();
  3133. if (!$good) {
  3134. return error_show(1003, "未找到相关阶梯价格");
  3135. }
  3136. if (!isset($origin['min_num'])) $origin['min_num'] = 0;
  3137. $lastnum = max($origin['min_num'] ?? 0, $good['min_num']);
  3138. if ($sale_num < $lastnum) {
  3139. return error_show(1003, "商品不满足起订量{$lastnum}");
  3140. }
  3141. $good_temp = Db::name("good_ladder")->where(["skuCode" => $skuCode, "is_del" => 0, "status" => 1])->where('min_num', '<=', $sale_num)->order("min_num desc")->find();
  3142. if (!$good_temp) {
  3143. return error_show(1003, "未找到相关阶梯价格");
  3144. }
  3145. $cat_top_list = made($ct['cat_id']);
  3146. $cat_top_id = isset($cat_top_list[0]['id']) ? $cat_top_list[0]['id'] : 0;
  3147. if ($ct['is_stock'] == 0 && $ct['is_gold_price'] == 1 && $cat_top_id == 6) {
  3148. $gold = Db::name("gold_price1")
  3149. ->field('id,price')
  3150. ->where(["type" => $ct['noble_metal'], "is_del" => 0, "status" => 1])
  3151. ->order("addtime desc")
  3152. ->find();
  3153. //$saleprice(最终售价) = (打样费/购买数量 + 开模费/购买数量 + 商品重量* 最新金价 + 工艺费* 商品重量+包装费+加标费+证书费+产品裸价+物流费)/(1-成本售价/100);
  3154. $total_fee = $ct['demo_fee'] / $sale_num + $ct['open_fee'] / $sale_num + $ct['weight'] * $gold["price"] + $good_temp['cost_fee'] * $ct['weight'] + $ct['packing_fee'] + $ct['mark_fee'] + $ct['cert_fee'] + $origin['nake_fee'] + $origin['delivery_fee'];
  3155. $order_rate = Db::name("cat")->where(["id" => $ct['cat_id']])->value('order_rate');
  3156. $budget = isset($order_rate) ? $order_rate / 100 : 0;
  3157. $saleprice = $total_fee / (1 - $budget);
  3158. return app_show(0, "获取成功", ['sale_price' => $saleprice, "stock" => $stock]);
  3159. }
  3160. return app_show(0, "获取成功", ['sale_price' => $good_temp['sale_price'], "stock" => $stock]);
  3161. }
  3162. }
  3163. public function saleuse(){
  3164. $orderCode= isset($this->post['orderCode'])&&!empty($this->post['orderCode'])?$this->post['orderCode']:"";
  3165. if($orderCode==""){
  3166. return error_show(1003,"参数orderCode不能为空");
  3167. }
  3168. $order= Db::name("sale")->where(["orderCode"=>$orderCode,"is_del"=>0])->select()->toArray();
  3169. if(empty($order)){
  3170. return error_show(1003,"订单数据未找到");
  3171. }
  3172. $useid= isset($this->post['useid'])&&$this->post['useid']!=""?intval($this->post['useid']):"";
  3173. if($useid==""){
  3174. return error_show(1003,"参数useid不能为空");
  3175. }
  3176. $use =Db::name("order_use")->where(["id"=>$useid,"is_del"=>0])->find();
  3177. if($use==false){
  3178. return error_show(1003,"用途数据未找到");
  3179. }
  3180. $asve=['use_order'=>$useid,"updatetime"=>date("Y-m-d H:i:s")];
  3181. $up=Db::name("sale")->where(["orderCode"=>$orderCode,"is_del"=>0])->update($asve);
  3182. if($up>0){
  3183. return app_show(0,"更新成功");
  3184. }else{
  3185. return error_show(1003,"更新失败");
  3186. }
  3187. }
  3188. public function goodzxinfo(){
  3189. $orderCode= isset($this->post['spuCode'])&&$this->post['spuCode']!=''?trim($this->post['spuCode']):"";
  3190. if($orderCode==""){
  3191. return error_show(1003,"参数spuCode不能为空");
  3192. }
  3193. $order= Db::name("good_zixun")->where(["spuCode"=>$orderCode,"is_del"=>0])->find();
  3194. if(empty($order)){
  3195. return error_show(1003,"订单数据未找到");
  3196. }
  3197. $unit =Db::name("unit")->where(["id"=>$order['good_unit']])->find();
  3198. if($order['brand_id']!=0){
  3199. $brand=Db::name("brand")->where(["id"=>$order['brand_id']])->find();
  3200. $order["brand_name"]=isset($brand['brand_name'])?$brand['brand_name']:"";
  3201. }else{
  3202. $order["brand_name"]="";
  3203. $order["brand_id"]="";
  3204. }
  3205. $order['specinfo']=json_decode($order['specinfo'],true);
  3206. $order['unit'] = isset($unit['unit'])?$unit['unit']:'';
  3207. $order['cat_info'] = made($order['cat_id'],[]);
  3208. $order['noble_name']=isset($order['noble_metal'])&&$order['noble_metal']!=0?$this->noble[$order['noble_metal']] :"";
  3209. if($order['is_gold_price']==1){
  3210. $price=Db::name("gold_price1")->where(["type"=>$order['noble_metal'],"status"=>1,"is_del"=>0])->order("addtime desc")->find();
  3211. }
  3212. $supplier = Db::name("supplier")->where(["code"=>$order['supplierNo']])->find();
  3213. $order['supplier_name'] = isset($supplier['name']) ? $supplier['name']:"";
  3214. $palt =Db::name("platform")->where(["id"=>$order['platform_id']])->find();
  3215. $order['platform_name']=isset($palt['platform_name']) ? $palt['platform_name']:"";
  3216. $order["gold_price"] = isset($price['price'])?$price['price']:0;
  3217. $order["noble_weight"] = isset($order['weight'])?$order['weight']:0;
  3218. return app_show(0,"获取成功",$order);
  3219. }
  3220. //获取采反商品详情,当数据不在good_zixun中,模仿goodzxinfo
  3221. public function getGoodZxInfoByNotZixun(){
  3222. $param=$this->request->only(['spuCode'],'post','trim');
  3223. $val=Validate::rule(['spuCode'=>'require']);
  3224. if(!$val->check($param)) return error_show(1004,$val->getError());
  3225. $order = Db::name('consult_bids')
  3226. ->field(true)
  3227. ->where(['spuCode'=>$param['spuCode'],'is_del'=>0])
  3228. ->find();
  3229. // $orderCode= isset($this->post['spuCode'])&&$this->post['spuCode']!=''?trim($this->post['spuCode']):"";
  3230. // if($orderCode==""){
  3231. // return error_show(1003,"参数spuCode不能为空");
  3232. // }
  3233. // $order= Db::name("good_zixun")->where(["spuCode"=>$orderCode,"is_del"=>0])->find();
  3234. // if(empty($order)){
  3235. // return error_show(1003,"订单数据未找到");
  3236. // }
  3237. $unit =Db::name("unit")->where(["id"=>$order['unit_id']])->find();
  3238. if($order['brand_id']!=0){
  3239. $brand=Db::name("brand")->where(["id"=>$order['brand_id']])->find();
  3240. $order["brand_name"]=isset($brand['brand_name'])?$brand['brand_name']:"";
  3241. }else{
  3242. $order["brand_name"]="";
  3243. $order["brand_id"]="";
  3244. }
  3245. $order['specinfo']=json_decode($order['specinfo'],true);
  3246. $order['unit'] = isset($unit['unit'])?$unit['unit']:'';
  3247. $order['cat_info'] = made($order['cat_id'],[]);
  3248. $order['noble_name']=isset($order['metal_id'])&&$order['metal_id']!=0?$this->noble[$order['metal_id']] :"";
  3249. if($order['is_gold_price']==1){
  3250. $price=Db::name("gold_price1")->where(["type"=>$order['metal_id'],"status"=>1,"is_del"=>0])->order("addtime desc")->find();
  3251. }
  3252. $supplier = Db::name("supplier")->where(["code"=>$order['supplierNo']])->find();
  3253. $order['supplier_name'] = isset($supplier['name']) ? $supplier['name']:"";
  3254. // $palt =Db::name("platform")->where(["id"=>$order['platform_id']])->find();
  3255. // $order['platform_name']=isset($palt['platform_name']) ? $palt['platform_name']:"";
  3256. $order["gold_price"] = isset($price['price'])?$price['price']:0;
  3257. $order["noble_weight"] = isset($order['weight'])?$order['weight']:0;
  3258. return app_show(0,"获取成功",$order);
  3259. }
  3260. }