OrderClass.php 156 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459
  1. <?php
  2. namespace bizGhs\order\classes;
  3. use bizGhs\custom\classes\DistClass;
  4. use bizGhs\item\classes\ItemClassClass;
  5. use bizHd\purchase\classes\PurchaseItemClass;
  6. use common\components\arrayUtil;
  7. use common\components\noticeUtil;
  8. use wkhtmltox\Image\Converter;
  9. use biz\shop\classes\ShopCapitalClass;
  10. use biz\shop\classes\ShopClass;
  11. use biz\shop\classes\ShopExtClass;
  12. use biz\shop\models\Shop;
  13. use biz\sj\classes\SjClass;
  14. use biz\stat\classes\StatItemClass;
  15. use biz\stat\classes\StatKdClass;
  16. use biz\stat\classes\StatKhCgClass;
  17. use biz\stat\classes\StatOrderCountClass;
  18. use biz\stat\classes\StatOutClass;
  19. use biz\stat\classes\StatRefundClass;
  20. use biz\stat\classes\StatSaleClass;
  21. use bizGhs\express\services\DadaExpressServices;
  22. use bizGhs\order\traits\OrderTrait;
  23. use bizGhs\order\models\Order;
  24. use bizGhs\product\classes\ProductClass;
  25. use bizGhs\admin\classes\AdminClass;
  26. use bizGhs\custom\classes\CustomClass;
  27. use bizGhs\custom\models\Custom;
  28. use bizGhs\shop\classes\MainClass;
  29. use bizGhs\stock\classes\StockRecordClass;
  30. use bizHd\purchase\classes\PurchaseClass;
  31. use bizHd\stat\classes\StatIncomeClass;
  32. use common\components\dict;
  33. use common\components\imgUtil;
  34. use common\components\orderSn;
  35. use common\components\printUtil;
  36. use common\components\stringUtil;
  37. use common\components\util;
  38. use bizGhs\base\classes\BaseClass;
  39. use Yii;
  40. use yii\helpers\ArrayHelper;
  41. class OrderClass extends BaseClass
  42. {
  43. use OrderTrait;
  44. public static $baseFile = '\bizGhs\order\models\Order';
  45. //已取消
  46. const ORDER_STATUS_CANCEL = 5;
  47. //已完成
  48. const ORDER_STATUS_COMPLETE = 4;
  49. //配送中
  50. const ORDER_STATUS_SENDING = 3;
  51. //待配送
  52. const ORDER_STATUS_UN_SEND = 2;
  53. //待付款,待确认
  54. const ORDER_STATUS_UN_PAY = 1;
  55. //出车
  56. const SEND_TYPE_CAR_GET = 0;
  57. //到店自取
  58. const SEND_TYPE_SHOP_GET = 1;
  59. //发快递
  60. const SEND_TYPE_THIRD_SEND = 2;
  61. //未确认,这里的数值是错的,请参考dict.php的数值
  62. const SEND_TYPE_UNKNOWN = 1;
  63. //自取,这里的数值是错的,请参考dict.php的数值
  64. const SEND_TYPE_NO = 2;
  65. //自己送,这里的数值是错的,请参考dict.php的数值
  66. const SEND_TYPE_MYSELF = 3;
  67. //快递送,这里的数值是错的,请参考dict.php的数值
  68. const SEND_TYPE_THIRD = 4;
  69. public static $sendTypeMap = [
  70. self::SEND_TYPE_UNKNOWN => '未确认',
  71. self::SEND_TYPE_NO => '自取',
  72. self::SEND_TYPE_MYSELF => '商家配送',
  73. self::SEND_TYPE_THIRD => '快递配送',
  74. ];
  75. //待付款
  76. const PAY_STATUS_UN_PAY = 0;
  77. //已付款
  78. const PAY_STATUS_HAS_PAY = 1;
  79. const SEND_STATUS_UNSEND = 0; //未发货
  80. const SEND_STATUS_SENDING = 1; //已发货(配送中)
  81. const SEND_STATUS_COMPLETED = 2; //已送达
  82. const SEND_STATUS_CANCEL = 3; //取消
  83. //订单总流程数
  84. const TOTAL_FLOW = 3;
  85. //清算方式
  86. //欠款
  87. const CLEAR_DEBT = 1;
  88. //已付款
  89. const CLEAR_HAS_GATHERING = 2;
  90. //没有欠款
  91. const DEBT_NO = 0;
  92. //欠款
  93. const DEBT_YES = 1;
  94. //正常订单
  95. const REFUND_NO = 1;
  96. //已退款订单
  97. const REFUND_YES = 2;
  98. public static $refundMap = [
  99. self::REFUND_NO => '',
  100. self::REFUND_YES => '有退款',
  101. ];
  102. public static function printMyWlList($shop, $beginTime, $endTime)
  103. {
  104. $end = strtotime($endTime);
  105. $begin = strtotime($beginTime);
  106. $different = $end - $begin;
  107. if ($different > 172800) {
  108. util::fail('最多可打印2天订单');
  109. }
  110. $mainId = $shop->mainId;
  111. $orderList = OrderClass::getAllByCondition(['mainId' => $mainId, 'payTime' => ['between', [$beginTime, $endTime]], 'payStatus' => 1], 'id asc', '*', null, true);
  112. if (empty($orderList)) {
  113. util::fail('没有订单需要打印');
  114. }
  115. $ids = [];
  116. foreach ($orderList as $order) {
  117. $customId = $order->customId;
  118. $ids[] = $customId;
  119. }
  120. $ids = array_unique(array_filter($ids));
  121. $customList = CustomClass::getAllByCondition(['id' => ['in', $ids]], null, 'id,mainId,shortName,mobile,wlName', 'id');
  122. $myList = [];
  123. foreach ($orderList as $order) {
  124. $customId = $order->customId;
  125. $custom = $customList[$customId] ?? [];
  126. $sendNum = $order->sendNum;
  127. $customMobile = $order->customMobile;
  128. $shortName = $custom['shortName'] ?? '';
  129. $wlName = $custom['wlName'] ?? '';
  130. $myList[] = ['sendNum' => $sendNum, 'customMobile' => $customMobile, 'shortName' => $shortName, 'wlName' => $wlName];
  131. }
  132. $myList = arrayUtil::arraySort($myList, 'customMobile');
  133. $size = 50;
  134. $arr = array_chunk($myList, $size);
  135. $totalPage = count($arr);
  136. foreach ($arr as $key => $sonList) {
  137. $content = '';
  138. if ($totalPage > 1) {
  139. $currentPage = bcadd($key, 1);
  140. $content .= "<CB>第{$currentPage}页,共{$totalPage}页</CB><BR>";
  141. }
  142. $content .= '<BR>';
  143. $content .= '--------------------------------<BR>';
  144. if (!empty($sonList)) {
  145. foreach ($sonList as $info) {
  146. $sendNum = $info['sendNum'];
  147. $customMobile = $info['customMobile'];
  148. $shortName = $info['shortName'];
  149. $wlName = $info['wlName'];
  150. $content .= '<B>' . $sendNum . ' ' . $shortName . '</B><BR>';
  151. $content .= '<BR>';
  152. $content .= '<B>' . $customMobile . ' ' . $wlName . '</B><BR>';
  153. $content .= '--------------------------------<BR>';
  154. }
  155. }
  156. $content .= '<BR>';
  157. $shopId = $shop->id;
  158. $ext = ShopExtClass::getByCondition(['shopId' => $shopId]);
  159. $printSn = $ext['printSn'] ?? '';
  160. if (empty($printSn)) {
  161. util::fail('没有设置打印机');
  162. }
  163. $p = new printUtil($printSn);
  164. $p->printMsg($content, $shop);
  165. }
  166. }
  167. public static function exportOrderData($respond, $mainId)
  168. {
  169. $orderList = $respond['list'] ?? [];
  170. if (empty($orderList)) {
  171. util::fail('没有数据需要导出');
  172. }
  173. $orderSnList = array_column($orderList, 'orderSn');
  174. $orderItemData = OrderItemClass::getAllByCondition(['orderSn' => ['in', $orderSnList]], null, '*');
  175. $orderItemList = [];
  176. if (!empty($orderItemData)) {
  177. foreach ($orderItemData as $itemInfo) {
  178. $orderSn = $itemInfo['orderSn'] ?? '';
  179. $orderItemList[$orderSn][] = $itemInfo;
  180. }
  181. }
  182. foreach ($orderList as $key => $orderInfo) {
  183. $book = $orderInfo['book'] ?? 0;
  184. $actPrice = $orderInfo['actPrice'] ?? 0;
  185. $status = $orderInfo['status'] ?? 0;
  186. if ($book == 1 && $status == 2) {
  187. //预订单待发货的不算收入
  188. unset($orderList[$key]);
  189. continue;
  190. }
  191. if ($status == 1 || $status == 5) {
  192. unset($orderList[$key]);
  193. continue;
  194. }
  195. if ($actPrice <= 0) {
  196. unset($orderList[$key]);
  197. continue;
  198. }
  199. $orderSn = $orderInfo['orderSn'] ?? '';
  200. $itemList = $orderItemList[$orderSn] ?? [];
  201. $orderList[$key]['itemList'] = $itemList;
  202. }
  203. $classList = ItemClassClass::getAllByCondition(['mainId' => $mainId], null, '*', 'id');
  204. $phpExcelFile = Yii::getAlias("@vendor/phpoffice/phpexcel/");
  205. require_once($phpExcelFile . 'Classes/PHPExcel.php');
  206. $objPHPExcel = new \PHPExcel();
  207. $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
  208. ->setLastModifiedBy("Maarten Balliauw")
  209. ->setTitle("Office 2007 XLSX Document")
  210. ->setSubject("Office 2007 XLSX Document")
  211. ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
  212. ->setKeywords("office 2007 openxml php")
  213. ->setCategory("file");
  214. $ghsTitle = '供货商';
  215. $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader(date('n月j日') . " " . $ghsTitle);
  216. $objPHPExcel->getActiveSheet()->getPageMargins()->setTop(0.7);
  217. $objPHPExcel->getActiveSheet()->getPageMargins()->setBottom(0.1);
  218. $objPHPExcel->getActiveSheet()->getPageMargins()->setLeft(0.5);
  219. $objPHPExcel->getActiveSheet()->getPageMargins()->setRight(0);
  220. $objPHPExcel->getActiveSheet()->getPageMargins()->setHeader(0.1);
  221. $objPHPExcel->getActiveSheet()->getPageMargins()->setFooter(0);
  222. $objPHPExcel->getActiveSheet()->setCellValue('A1', '订单号');
  223. $objPHPExcel->getActiveSheet()->setCellValue('B1', '创建时间');
  224. $objPHPExcel->getActiveSheet()->setCellValue('C1', '账单日期');
  225. $objPHPExcel->getActiveSheet()->setCellValue('D1', '订单金额');
  226. $objPHPExcel->getActiveSheet()->setCellValue('E1', '退款金额');
  227. $objPHPExcel->getActiveSheet()->setCellValue('F1', '实际金额');
  228. $objPHPExcel->getActiveSheet()->setCellValue('G1', '客户');
  229. $objPHPExcel->getActiveSheet()->setCellValue('H1', '客户手机号');
  230. $objPHPExcel->getActiveSheet()->setCellValue('I1', '在线支付');
  231. $objPHPExcel->getActiveSheet()->setCellValue('J1', '结清状态');
  232. $objPHPExcel->getActiveSheet()->setCellValue('K1', '已优惠');
  233. $objPHPExcel->getActiveSheet()->setCellValue('L1', '备注');
  234. $objPHPExcel->getActiveSheet()->setCellValue('M1', '开单人');
  235. $objPHPExcel->getActiveSheet()->setCellValue('N1', '花材Id');
  236. $objPHPExcel->getActiveSheet()->setCellValue('O1', '花材名称');
  237. $objPHPExcel->getActiveSheet()->setCellValue('P1', '单价');
  238. $objPHPExcel->getActiveSheet()->setCellValue('Q1', '数量');
  239. $objPHPExcel->getActiveSheet()->setCellValue('R1', '已退数量');
  240. $objPHPExcel->getActiveSheet()->setCellValue('S1', '金额');
  241. $objPHPExcel->getActiveSheet()->setCellValue('T1', '分类');
  242. $objPHPExcel->getActiveSheet()->setCellValue('U1', '备注');
  243. $objPHPExcel->getActiveSheet()->setCellValue('V1', '成本');
  244. //设置宽度
  245. $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
  246. $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
  247. $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
  248. $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(16);
  249. $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(20);
  250. $objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(20);
  251. $objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(20);
  252. $objPHPExcel->getActiveSheet()->getColumnDimension('T')->setWidth(18);
  253. $objPHPExcel->getActiveSheet()->getColumnDimension('U')->setWidth(18);
  254. //加粗
  255. $objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(9)->setBold(true);
  256. $objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setSize(9)->setBold(true);
  257. $objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setSize(9)->setBold(true);
  258. $objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setSize(9)->setBold(true);
  259. $objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setSize(9)->setBold(true);
  260. $objPHPExcel->getActiveSheet()->getStyle('F1')->getFont()->setSize(9)->setBold(true);
  261. $objPHPExcel->getActiveSheet()->getStyle('G1')->getFont()->setSize(9)->setBold(true);
  262. $objPHPExcel->getActiveSheet()->getStyle('H1')->getFont()->setSize(9)->setBold(true);
  263. $objPHPExcel->getActiveSheet()->getStyle('I1')->getFont()->setSize(9)->setBold(true);
  264. $objPHPExcel->getActiveSheet()->getStyle('J1')->getFont()->setSize(9)->setBold(true);
  265. $objPHPExcel->getActiveSheet()->getStyle('K1')->getFont()->setSize(9)->setBold(true);
  266. $objPHPExcel->getActiveSheet()->getStyle('L1')->getFont()->setSize(9)->setBold(true);
  267. $objPHPExcel->getActiveSheet()->getStyle('M1')->getFont()->setSize(9)->setBold(true);
  268. $objPHPExcel->getActiveSheet()->getStyle('N1')->getFont()->setSize(9)->setBold(true);
  269. $objPHPExcel->getActiveSheet()->getStyle('O1')->getFont()->setSize(9)->setBold(true);
  270. $objPHPExcel->getActiveSheet()->getStyle('P1')->getFont()->setSize(9)->setBold(true);
  271. $objPHPExcel->getActiveSheet()->getStyle('Q1')->getFont()->setSize(9)->setBold(true);
  272. $objPHPExcel->getActiveSheet()->getStyle('R1')->getFont()->setSize(9)->setBold(true);
  273. $objPHPExcel->getActiveSheet()->getStyle('S1')->getFont()->setSize(9)->setBold(true);
  274. $objPHPExcel->getActiveSheet()->getStyle('T1')->getFont()->setSize(9)->setBold(true);
  275. $objPHPExcel->getActiveSheet()->getStyle('U1')->getFont()->setSize(9)->setBold(true);
  276. $objPHPExcel->getActiveSheet()->getStyle('V1')->getFont()->setSize(9)->setBold(true);
  277. $objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  278. $objPHPExcel->getActiveSheet()->getStyle('B1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  279. $objPHPExcel->getActiveSheet()->getStyle('C1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  280. $objPHPExcel->getActiveSheet()->getStyle('D1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  281. $objPHPExcel->getActiveSheet()->getStyle('E1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  282. $objPHPExcel->getActiveSheet()->getStyle('F1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  283. $objPHPExcel->getActiveSheet()->getStyle('G1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  284. $objPHPExcel->getActiveSheet()->getStyle('H1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  285. $objPHPExcel->getActiveSheet()->getStyle('I1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  286. $objPHPExcel->getActiveSheet()->getStyle('J1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  287. $objPHPExcel->getActiveSheet()->getStyle('K1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  288. $objPHPExcel->getActiveSheet()->getStyle('L1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  289. $objPHPExcel->getActiveSheet()->getStyle('M1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  290. $objPHPExcel->getActiveSheet()->getStyle('N1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  291. $objPHPExcel->getActiveSheet()->getStyle('O1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  292. $objPHPExcel->getActiveSheet()->getStyle('P1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  293. $objPHPExcel->getActiveSheet()->getStyle('Q1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  294. $objPHPExcel->getActiveSheet()->getStyle('R1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  295. $objPHPExcel->getActiveSheet()->getStyle('S1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  296. $objPHPExcel->getActiveSheet()->getStyle('T1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  297. $objPHPExcel->getActiveSheet()->getStyle('U1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  298. $objPHPExcel->getActiveSheet()->getStyle('V1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  299. $objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  300. $objPHPExcel->getActiveSheet()->getStyle('B1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  301. $objPHPExcel->getActiveSheet()->getStyle('C1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  302. $objPHPExcel->getActiveSheet()->getStyle('D1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  303. $objPHPExcel->getActiveSheet()->getStyle('E1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  304. $objPHPExcel->getActiveSheet()->getStyle('F1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  305. $objPHPExcel->getActiveSheet()->getStyle('G1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  306. $objPHPExcel->getActiveSheet()->getStyle('H1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  307. $objPHPExcel->getActiveSheet()->getStyle('I1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  308. $objPHPExcel->getActiveSheet()->getStyle('J1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  309. $objPHPExcel->getActiveSheet()->getStyle('K1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  310. $objPHPExcel->getActiveSheet()->getStyle('L1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  311. $objPHPExcel->getActiveSheet()->getStyle('M1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  312. $objPHPExcel->getActiveSheet()->getStyle('N1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  313. $objPHPExcel->getActiveSheet()->getStyle('O1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  314. $objPHPExcel->getActiveSheet()->getStyle('P1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  315. $objPHPExcel->getActiveSheet()->getStyle('Q1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  316. $objPHPExcel->getActiveSheet()->getStyle('R1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  317. $objPHPExcel->getActiveSheet()->getStyle('S1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  318. $objPHPExcel->getActiveSheet()->getStyle('T1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  319. $objPHPExcel->getActiveSheet()->getStyle('U1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  320. $objPHPExcel->getActiveSheet()->getStyle('V1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
  321. $baseRow = 2;
  322. $x = 0;
  323. foreach ($orderList as $key => $orderData) {
  324. $currentList = $orderData['itemList'] ?? [];
  325. if (!empty($currentList)) {
  326. foreach ($currentList as $k => $orderInfo) {
  327. $i = $baseRow + $x;
  328. $x++;
  329. $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $orderData['orderSn']);
  330. $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, $orderData['addTime']);
  331. $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, $orderData['payTime']);
  332. $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, $orderData['orderPrice']);
  333. $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, $orderData['tkPrice']);
  334. $objPHPExcel->getActiveSheet()->setCellValue('F' . $i, $orderData['actPrice']);
  335. $objPHPExcel->getActiveSheet()->setCellValue('G' . $i, $orderData['customName']);
  336. $objPHPExcel->getActiveSheet()->setCellValue('H' . $i, $orderData['customMobile']);
  337. $objPHPExcel->getActiveSheet()->setCellValue('I' . $i, $orderData['onlinePay'] == 1 ? '否' : '是');
  338. $objPHPExcel->getActiveSheet()->setCellValue('J' . $i, $orderData['debt'] == 1 ? '未结清' : '已结清');
  339. $objPHPExcel->getActiveSheet()->setCellValue('K' . $i, $orderData['discountAmount']);
  340. $objPHPExcel->getActiveSheet()->setCellValue('L' . $i, $orderData['remark']);
  341. $objPHPExcel->getActiveSheet()->setCellValue('M' . $i, $orderData['shopAdminName']);
  342. $objPHPExcel->getActiveSheet()->setCellValue('N' . $i, $orderInfo['productId']);
  343. $objPHPExcel->getActiveSheet()->setCellValue('O' . $i, $orderInfo['name']);
  344. $objPHPExcel->getActiveSheet()->setCellValue('P' . $i, $orderInfo['xhUnitPrice']);
  345. $remainNum = bcsub($orderInfo['xhNum'], $orderInfo['refundNum']);
  346. $price = bcmul($remainNum, $orderInfo['xhUnitPrice'], 2);
  347. $objPHPExcel->getActiveSheet()->setCellValue('Q' . $i, $remainNum);
  348. $objPHPExcel->getActiveSheet()->setCellValue('R' . $i, $orderInfo['refundNum']);
  349. $objPHPExcel->getActiveSheet()->setCellValue('S' . $i, $price);
  350. $classId = $orderInfo['classId'] ?? 0;
  351. $className = isset($classList[$classId]) && isset($classList[$classId]['name']) ? $classList[$classId]['name'] : '';
  352. $objPHPExcel->getActiveSheet()->setCellValue('T' . $i, $className);
  353. $objPHPExcel->getActiveSheet()->setCellValue('U' . $i, $orderInfo['remark']);
  354. $objPHPExcel->getActiveSheet()->setCellValue('V' . $i, $orderInfo['cost']);
  355. //居左
  356. $objPHPExcel->getActiveSheet()->getStyle('A' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  357. $objPHPExcel->getActiveSheet()->getStyle('B' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  358. $objPHPExcel->getActiveSheet()->getStyle('C' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  359. $objPHPExcel->getActiveSheet()->getStyle('D' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  360. $objPHPExcel->getActiveSheet()->getStyle('E' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  361. $objPHPExcel->getActiveSheet()->getStyle('F' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  362. $objPHPExcel->getActiveSheet()->getStyle('G' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  363. $objPHPExcel->getActiveSheet()->getStyle('H' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  364. $objPHPExcel->getActiveSheet()->getStyle('I' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  365. $objPHPExcel->getActiveSheet()->getStyle('J' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  366. $objPHPExcel->getActiveSheet()->getStyle('K' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  367. $objPHPExcel->getActiveSheet()->getStyle('L' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  368. $objPHPExcel->getActiveSheet()->getStyle('M' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  369. $objPHPExcel->getActiveSheet()->getStyle('N' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  370. $objPHPExcel->getActiveSheet()->getStyle('O' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  371. $objPHPExcel->getActiveSheet()->getStyle('P' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  372. $objPHPExcel->getActiveSheet()->getStyle('Q' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  373. $objPHPExcel->getActiveSheet()->getStyle('R' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  374. $objPHPExcel->getActiveSheet()->getStyle('S' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  375. $objPHPExcel->getActiveSheet()->getStyle('T' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  376. $objPHPExcel->getActiveSheet()->getStyle('V' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  377. }
  378. }
  379. }
  380. $fileName = '订单明细-' . time();
  381. $objPHPExcel->getActiveSheet()->setTitle($fileName);
  382. $objPHPExcel->setActiveSheetIndex(0);
  383. $dir = './priceTable/' . $mainId;
  384. if (file_exists($dir) == false) {
  385. mkdir($dir, 0777, true);
  386. }
  387. $date = $fileName;
  388. $file = $date . '.xls';
  389. $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
  390. if (file_exists($dir . '/' . $file)) {
  391. unlink($dir . '/' . $file);
  392. }
  393. $objWriter->save($dir . '/' . $file);
  394. $fileUrl = Yii::$app->params['ghsHost'] . '/priceTable/' . $mainId . '/' . $file;
  395. util::success(['file' => $fileUrl, 'shortFile' => $file]);
  396. }
  397. public static function hasSend($order, $params = [])
  398. {
  399. $order->status = 3;
  400. $order->save();
  401. $cgId = $order->purchaseId ?? 0;
  402. $cg = PurchaseClass::getById($cgId, true);
  403. if (empty($cg)) {
  404. util::fail('没有找到采购信息');
  405. }
  406. $cg->status = 3;
  407. $cg->save();
  408. }
  409. public static function confirmReach($order, $params = [])
  410. {
  411. $cgId = $order->purchaseId ?? 0;
  412. $cg = PurchaseClass::getById($cgId, true);
  413. if (empty($cg)) {
  414. util::fail('没有找到采购信息');
  415. }
  416. $customId = $order->customId ?? 0;
  417. $custom = CustomClass::getById($customId, true);
  418. if (empty($custom)) {
  419. util::fail('没有找到客户信息,编号:' . $customId);
  420. }
  421. $shopId = $custom->shopId ?? 0;
  422. $customShop = ShopClass::getById($shopId, true);
  423. if (empty($customShop)) {
  424. util::fail('没有找到客户的门店');
  425. }
  426. //订单如果没有发货则先发货
  427. if ($order->status == 2) {
  428. $staffId = $params['staffId'] ?? 0;
  429. $staffName = $params['staffName'] ?? '';
  430. $notice = $params['notice'] ?? true;
  431. $element = ['staffId' => $staffId, 'staffName' => $staffName, 'notice' => $notice];
  432. self::orderSend($order, $element, true);
  433. $cg = PurchaseClass::getById($cgId, true);
  434. }
  435. // 构建“冲销”函数的参数 -- 变动前的花材存库数据
  436. $purchaseItems = PurchaseItemClass::getAllByCondition(['orderSn' => $cg->orderSn], null, "productId");
  437. $productIds = ArrayHelper::getColumn($purchaseItems, 'productId'); //$productIds 是本次入库涉及的花材ID数组
  438. $oldStocks = [];
  439. foreach ($productIds as $productId) {
  440. $product = ProductClass::getById($productId, true);
  441. $oldStocks[$productId] = $product;
  442. }
  443. PurchaseClass::takeToPutIn($cg);
  444. $shop = ShopClass::getLockById($shopId);
  445. if (empty($shop)) {
  446. util::fail('没有找到门店14');
  447. }
  448. $adminId = $shop->adminId;
  449. $mainId = $shop->mainId;
  450. PurchaseClass::rollbackProductStock($oldStocks, $shop, $adminId, $mainId, '系统');
  451. }
  452. //订单发货主方法 ssh 20231119
  453. public static function orderSend($order, $params, $allowRepeat = false)
  454. {
  455. self::orderFh($order, $params, $allowRepeat);
  456. $cgId = $order->purchaseId ?? 0;
  457. $cgInfo = PurchaseClass::getById($cgId, true);
  458. if (empty($cgInfo)) {
  459. util::fail('没有找到采购信息');
  460. }
  461. $notice = $params['notice'] ?? true; // 兼容处理,实现控制是否发发货通知
  462. PurchaseClass::orderFh($cgInfo, $params, $allowRepeat, $notice);
  463. }
  464. //取消发货 ssh 20250917
  465. public static function cancelOrderSend($order, $params)
  466. {
  467. $order->status = 2;
  468. $order->save();
  469. $cgId = $order->purchaseId ?? 0;
  470. $cgInfo = PurchaseClass::getById($cgId, true);
  471. if (empty($cgInfo)) {
  472. util::fail('没有找到采购信息');
  473. }
  474. PurchaseClass::cancelFh($cgInfo, $params);
  475. }
  476. //订单发货子方法 ssh 20231119
  477. public static function orderFh($order, $params, $allowRepeat = false)
  478. {
  479. if ($order->status == 3) {
  480. if (!$allowRepeat) {
  481. util::fail('订单已发货');
  482. } else {
  483. return true;
  484. }
  485. }
  486. $fhType = $params['fhType'] ?? 0;
  487. if (!is_numeric($fhType)) {
  488. util::fail('请选择发货类型');
  489. }
  490. if ($fhType == 1) {
  491. $fhWl = $params['fhWl'] ?? '';
  492. $fhWlNo = $params['fhWlNo'] ?? '';
  493. if (empty($fhWl)) {
  494. util::fail('请填写物流名称');
  495. }
  496. if (empty($fhWlNo)) {
  497. util::fail('请填写物流编号');
  498. }
  499. $order->fhWl = $fhWl;
  500. $order->fhWlNo = $fhWlNo;
  501. }
  502. $order->fhType = $fhType;
  503. $order->status = 3;
  504. $order->fhTime = date("Y-m-d H:i:s");
  505. $staffId = $params['staffId'] ?? 0;
  506. $staffName = $params['staffName'] ?? '';
  507. $order->sendStaffId = $staffId;
  508. $order->sendStaffName = $staffName;
  509. $order->save();
  510. }
  511. public static function arrival($order, $data)
  512. {
  513. if ($order->stockChange == 1) {
  514. util::fail('您已操作过了');
  515. }
  516. $sendCost = isset($data['sendCost']) && is_numeric($data['sendCost']) ? $data['sendCost'] : 0;
  517. $packCost = isset($data['packCost']) && is_numeric($data['packCost']) ? $data['packCost'] : 0;
  518. $order->sendCost = $sendCost;
  519. $order->packCost = $packCost;
  520. $order->save();
  521. $sjId = $order->sjId ?? 0;
  522. $shopId = $order->shopId ?? 0;
  523. $mainId = $order->mainId ?? 0;
  524. //product [{"productId":"3674","num":0,"price":1}]
  525. $product = $data['product'] ?? '';
  526. if (empty($product)) {
  527. util::fail('没有花材?');
  528. }
  529. $ids = [];
  530. $format = [];
  531. foreach ($product as $val) {
  532. $productId = $val['productId'] ?? 0;
  533. $ids[] = $productId;
  534. $format[$productId] = $val;
  535. }
  536. $info = ProductClass::getByIds($ids, null, 'id');
  537. $orderSn = $order->orderSn ?? '';
  538. $customName = $order->customName ?? '';
  539. $list = OrderItemClass::getAllByCondition(['orderSn' => $orderSn], null, '*', null, true);
  540. if (empty($list)) {
  541. util::fail('没有找到订单的花材');
  542. }
  543. $itemPrice = 0;
  544. $weight = 0;
  545. foreach ($list as $key => $val) {
  546. $productId = $val->productId ?? 0;
  547. $num = $format[$productId]['num'] ?? 0;
  548. $unitPrice = $format[$productId]['price'] ?? 0;
  549. $price = bcmul($unitPrice, $num, 2);
  550. $name = $val->name ?? '';
  551. $xhUnitName = $val->xhUnitName ?? '';
  552. $xhPreNum = $val->xhPreNum ?? 0;
  553. if ($unitPrice <= 0) {
  554. util::fail('花材金额需要大于0');
  555. }
  556. if ($num > $xhPreNum) {
  557. //util::fail($name . "数量不能超过{$xhPreNum}{$xhUnitName}");
  558. }
  559. $val->cost = $unitPrice;
  560. $val->unitPrice = $unitPrice;
  561. $val->price = $price;
  562. $val->bigNum = $num;
  563. $val->num = $num;
  564. $val->xhNum = $num;
  565. $val->xhUnitPrice = $unitPrice;
  566. $val->xhPrice = $price;
  567. $val->save();
  568. if ($val->xhPreNum > $num) {
  569. //客户下单退货数增加
  570. $subNum = bcsub($val->xhPreNum, $num);
  571. StatKhCgClass::ghsBookOrderRefundNum($order, $subNum);
  572. //花材销量榜减少
  573. StatItemClass::ghsBookOrderRefundNum($order, $val, $subNum);
  574. }
  575. $itemPrice = bcadd($itemPrice, $price, 2);
  576. $productWeight = $info[$productId]['weight'] ?? 0;
  577. $currentWeight = bcmul($productWeight, $num, 2);
  578. $weight = bcadd($currentWeight, $weight, 2);
  579. //减少库存
  580. $unitType = $val->xhUnitType ?? 0;
  581. $bigNum = 0;
  582. $smallNum = 0;
  583. if ($unitType == dict::getDict('unitType', 'big')) {
  584. $bigNum = $num;
  585. $itemNum = $num;
  586. } else {
  587. $smallNum = $num;
  588. $itemNum = bcdiv($num, $val->ratio, 2);
  589. }
  590. $checkStock = true;
  591. $stockInfo = ProductClass::decreaseStock($productId, $bigNum, $smallNum, $checkStock);
  592. $recordData = [];
  593. $recordData['sjId'] = $sjId;
  594. $recordData['shopId'] = $shopId;
  595. $recordData['mainId'] = $mainId;
  596. $recordData['itemId'] = $val->itemId;
  597. $recordData['itemNum'] = $itemNum;
  598. $recordData['oldStock'] = $stockInfo['oldStock'];
  599. $recordData['newStock'] = $stockInfo['newStock'];
  600. $recordData['productId'] = $productId;
  601. $recordData['orderSn'] = $orderSn;
  602. $recordData['relateName'] = $customName;
  603. $recordData['ptStyle'] = dict::getDict('ptStyle', 'ghs');
  604. StockRecordClass::addSellStockOrderRecord($recordData);
  605. }
  606. $order->itemPrice = $itemPrice;
  607. $sendCost = $order->sendCost ?? 0;
  608. $currentPrice = bcadd($itemPrice, $sendCost, 2);
  609. $packCost = $order->packCost ?? 0;
  610. $currentPrice = bcadd($currentPrice, $packCost, 2);
  611. $shopId = $order->shopId ?? 0;
  612. $shop = ShopClass::getLockById($shopId);
  613. if (empty($shop)) {
  614. util::fail('没有找到门店6');
  615. }
  616. $mainId = $shop->mainId ?? 0;
  617. $main = MainClass::getLockById($mainId);
  618. if (empty($main)) {
  619. util::fail('没有main信息4');
  620. }
  621. $main->unSendOrder -= 1;
  622. $main->finishOrder += 1;
  623. $main->save();
  624. $kiloFee = $shop->kiloFee ?? 0;
  625. $miniKilo = $shop->miniKilo ?? 0;
  626. $calcWeight = $weight > $miniKilo ? $weight : $miniKilo;
  627. $allKiloFee = bcmul($calcWeight, $kiloFee, 2);
  628. $currentPrice = bcadd($currentPrice, $allKiloFee, 2);
  629. $order->prePrice = $currentPrice;
  630. $order->orderPrice = $currentPrice;
  631. $order->actPrice = $currentPrice;
  632. $order->realPrice = $currentPrice;
  633. $order->stockChange = 1;
  634. $order->save();
  635. $bookPrice = $order->bookPrice ?? 0;
  636. $mainId = $shop->mainId ?? 0;
  637. $sjId = $shop->sjId ?? 0;
  638. $customId = $order->customId ?? 0;
  639. $relateOrderSn = $order->orderSn ?? '';
  640. $shopAdminId = $data['shopAdminId'] ?? 0;
  641. $shopAdminName = $data['shopAdminName'] ?? '';
  642. $refund = null;
  643. if ($bookPrice != $currentPrice) {
  644. if ($bookPrice > $currentPrice) {
  645. $refundPrice = bcsub($bookPrice, $currentPrice, 2);
  646. $order->refundPrice = $refundPrice;
  647. $order->tkPrice = bcadd($order->tkPrice, $refundPrice, 2);
  648. $order->refund = self::REFUND_YES;
  649. $order->refundLog = 1;
  650. $order->save();
  651. $orderSn = orderSn::getGhsRefundSn();
  652. $book = 1;
  653. $refundData = [
  654. 'mainId' => $mainId,
  655. 'shopId' => $shopId,
  656. 'sjId' => $sjId,
  657. 'customId' => $customId,
  658. 'orderSn' => $orderSn,
  659. 'relateOrderSn' => $relateOrderSn,
  660. 'book' => $book,
  661. 'status' => RefundOrderClass::STATUS_COMPLETE,
  662. 'shopAdminId' => $shopAdminId,
  663. 'shopAdminName' => $shopAdminName,
  664. 'refundPrice' => $refundPrice,
  665. 'refundType' => RefundOrderClass::REFUND_TYPE_MONEY,
  666. ];
  667. //退款
  668. $refund = RefundOrderClass::add($refundData, true);
  669. //余额减少
  670. ShopClass::ghsBookOrderRefundReduceBalance($main, $shop, $refund, $refundPrice);
  671. //总支出增加
  672. $currentTotalExpend = bcadd($main->totalExpend, $refundPrice, 2);
  673. $main->totalExpend = $currentTotalExpend;
  674. $totalRefund = bcadd($main->totalRefund, $refundPrice, 2);
  675. $main->totalRefund = $totalRefund;
  676. $main->save();
  677. //支出流水
  678. $thisType = dict::getDict('capitalType', 'ghsBookRefund', 'id');
  679. $sjId = $order->sjId ?? 0;
  680. $event = "预订单多付退给{$customName}";
  681. $capitalData = [
  682. 'capitalType' => $thisType,
  683. 'io' => 0,
  684. 'totalExpend' => $currentTotalExpend,
  685. 'payWay' => 0,
  686. 'amount' => $refundPrice,
  687. 'sjId' => $sjId,
  688. 'shopId' => $shopId,
  689. 'event' => $event,
  690. 'mainId' => $mainId,
  691. ];
  692. ShopCapitalClass::addCapital($capitalData);
  693. //支出统计
  694. StatOutClass::updateOrInsert($main, $shop, $refundPrice);
  695. //退款统计
  696. $payWay = $order->payWay ?? 0;
  697. StatRefundClass::replace($main, $shop, $payWay, $refundPrice);
  698. //供货商预订单退款给客户,客户采购金额减少
  699. StatKhCgClass::ghsBookOrderChange(false, $order, $refundPrice);
  700. } else {
  701. //欠款
  702. $currentDebt = bcsub($currentPrice, $bookPrice, 2);
  703. $order->debtPrice = $currentDebt;
  704. $order->remainDebtPrice = $currentDebt;
  705. $order->debt = OrderClass::DEBT_YES;
  706. $order->save();
  707. $currentTotalIncome = bcadd($main->totalIncome, $currentDebt, 2);
  708. $main->totalIncome = $currentTotalIncome;
  709. $main->save();
  710. $payWay = dict::getDict('payWay', 'debtPay');
  711. $pair = \bizGhs\custom\services\GhsRechargeSettleService::lockAccountPair(['id' => $customId]);
  712. $custom = $pair['custom'];
  713. $ghs = $pair['ghs'];
  714. if (empty($custom)) {
  715. util::fail('没有找到客户');
  716. }
  717. CustomClass::cgDebtAmountAdd($custom, $order, true, $ghs);
  718. //收入增加
  719. StatIncomeClass::updateOrInsert($main, $shop, $currentDebt);
  720. //收入流水增加
  721. $orderId = $order->id;
  722. $capitalType = dict::getDict('capitalType', 'ghsBookOrderGetBack', 'id');
  723. $shopAdminId = $order->shopAdminId ?? 0;
  724. $shopAdminName = $order->shopAdminName ?? '';
  725. $event = "预订单 {$orderSn} 差价补款";
  726. $mainId = $shop->mainId ?? 0;
  727. $sjId = $order->sjId ?? 0;
  728. $shopId = $order->shopId ?? 0;
  729. $capital = [
  730. 'capitalType' => $capitalType,
  731. 'relateId' => $orderId,
  732. 'io' => 1,
  733. 'amount' => $currentDebt,
  734. 'totalIncome' => $currentTotalIncome,
  735. 'payWay' => $payWay,
  736. 'event' => $event,
  737. 'mainId' => $mainId,
  738. 'sjId' => $sjId,
  739. 'shopId' => $shopId,
  740. 'shopAdminId' => $shopAdminId,
  741. 'shopAdminName' => $shopAdminName,
  742. ];
  743. ShopCapitalClass::addCapital($capital);
  744. //各渠道收入金额统计
  745. StatKdClass::replace($shop, $currentDebt, $payWay);
  746. //每天销售收入统计
  747. StatSaleClass::replace($main, $shop, $currentDebt);
  748. //预订单,客户补款给供货商,客户采购金额增加
  749. StatKhCgClass::ghsBookOrderChange(true, $order, $currentDebt);
  750. }
  751. }
  752. return ['kiloFee' => $kiloFee, 'refund' => $refund, 'miniKilo' => $miniKilo];
  753. }
  754. //添加订单 ssh 2019.12.5
  755. public static function addOrder($data, $custom = [])
  756. {
  757. $shopId = $data['shopId'] ?? 0;
  758. $mainId = $data['mainId'] ?? 0;
  759. $ghsId = $data['ghsId'] ?? 0;
  760. $customId = $data['customId'] ?? 0;
  761. $distId = $custom['distId'] ?? 0;
  762. $data['customDistId'] = $distId;
  763. $snData = ['shopId' => $shopId, 'mainId' => $mainId, 'ghsId' => $ghsId, 'customId' => $customId];
  764. $orderSn = orderSn::getGhsOrderSn($snData);
  765. $data['orderSn'] = $orderSn;
  766. $data['payStatus'] = self::PAY_STATUS_UN_PAY;
  767. $data['customId'] = !empty($data['customId']) ? $data['customId'] : 0;
  768. $live = $data['live'] ?? 1;
  769. $shop = ShopClass::getLockById($shopId);
  770. if (empty($shop)) {
  771. util::fail('没有找到门店7');
  772. }
  773. $mainId = $shop->mainId ?? 0;
  774. $main = MainClass::getLockById($mainId);
  775. if (empty($main)) {
  776. util::fail('没有main信息5');
  777. }
  778. //花材
  779. $product = $data['product'];
  780. $book = $data['book'] ?? 0;
  781. $stockMayChange = true;
  782. $data['stockChange'] = 1;
  783. if ($book == 1) {
  784. $stockMayChange = false;
  785. $data['stockChange'] = 0;
  786. }
  787. //花店向虚拟批发店采购的,批发店没有的花材需要补充
  788. if ($live == 0) {
  789. $product = \bizHd\product\classes\ProductClass::hdToggleGhs($product, $shop);
  790. }
  791. $customShopAdminId = $data['customShopAdminId'] ?? 0;
  792. $moreParams = ['book' => $book, 'customShopAdminId' => $customShopAdminId, 'custom' => $custom];
  793. $respond = OrderItemClass::replaceItem($orderSn, $product, $data, $stockMayChange, $moreParams);
  794. $sendCost = isset($data['sendCost']) && is_numeric($data['sendCost']) ? $data['sendCost'] : 0;
  795. $data['sendCost'] = $sendCost;
  796. $data['bigNum'] = $respond['bigNum'] ?? 0;
  797. $data['smallNum'] = $respond['smallNum'] ?? 0;
  798. $data['itemNum'] = $respond['totalItemNum'] ?? 0;
  799. //这个字段记录每个花材满多少扎减掉的金额,并汇总金额,区别于整单满减的 $cutAmount。保存起来应该是在哪里有用,$totalReachDiscount在这边不影响actPrice,估计因为取花材的价格里::getFinalPrice()已经使用了优惠后的价格,有多处,关键词 reachDiscountPrice_explain ssh 20260116
  800. $data['reachDiscountPrice'] = $respond['totalReachDiscount'] ?? 0;
  801. //记录订单的总成本
  802. $totalCost = $respond['totalCost'] ?? 0;
  803. $packCost = $data['packCost'] ?? 0;
  804. $totalCost = bcadd($totalCost, $packCost, 2);
  805. $totalCost = bcadd($totalCost, $sendCost, 2);
  806. $data['totalCost'] = $totalCost;
  807. $data['remainCost'] = $totalCost;
  808. //默认订单要打单
  809. $data['needPrint'] = $data['needPrint'] ?? dict::getDict('needPrint', 'need');
  810. $weight = $respond['weight'];
  811. $data['weight'] = $weight;
  812. $itemPrice = $respond['price'] ?? 0;
  813. $data['itemPrice'] = $itemPrice;
  814. $currentPrice = bcadd($itemPrice, $sendCost, 2);
  815. $packCost = isset($data['packCost']) && $data['packCost'] > 0 ? $data['packCost'] : 0;
  816. $currentPrice = bcadd($currentPrice, $packCost, 2);
  817. //预订单需要增加服务费
  818. if ($book == 1) {
  819. $kiloFee = $shop->kiloFee ?? 0;
  820. $miniKilo = $shop->miniKilo ?? 0;
  821. $calcWeight = max($weight, $miniKilo);
  822. $allKiloFee = bcmul($calcWeight, $kiloFee, 2);
  823. $currentPrice = bcadd($currentPrice, $allKiloFee, 2);
  824. $data['allKiloFee'] = $allKiloFee;
  825. $data['kiloFee'] = $kiloFee;
  826. $data['miniKilo'] = $miniKilo;
  827. }
  828. $data['prePrice'] = $currentPrice;
  829. $actPrice = $currentPrice;
  830. //商家自己开单时
  831. if (isset($data['modifyPrice'])) {
  832. $modifyPrice = $data['modifyPrice'] ?? 0;
  833. if ($modifyPrice <= 0) {
  834. util::fail('收款金额必须大于0');
  835. }
  836. if ($modifyPrice > $currentPrice) {
  837. //人工和资材费用
  838. $data['labourCost'] = bcsub($modifyPrice, $currentPrice, 2);
  839. }
  840. if ($modifyPrice < $currentPrice) {
  841. //优惠金额
  842. $data['discountAmount'] = bcsub($currentPrice, $modifyPrice, 2);
  843. $data['discountType'] = dict::getDict('discountType', 'discount');
  844. }
  845. $actPrice = $modifyPrice;
  846. if ($book == 1) {
  847. $actPrice = 0;
  848. }
  849. } else {
  850. //客户自己下单才有整单满减,门店帮忙开单没有,,多个地方要同步修改,关键词 meet_amount_num_reduce
  851. if ($book == 0) {
  852. $meetNum = $shop->meetNum ?? 0;
  853. $meetAmount = $shop->meetAmount ?? 0;
  854. $cutOption = $shop->cutAmount ?? 0;
  855. $cutStyle = $shop->cutStyle ?? 0;
  856. if ($cutStyle == 0) {
  857. $cutAmount = $cutOption;
  858. } else {
  859. $miniOption = bcsub(1, $cutOption, 2);
  860. $cutAmount = bcmul($actPrice, $miniOption, 2);
  861. }
  862. if ($cutAmount > 0 && $meetNum > 0 && $meetAmount > 0) {
  863. if (isset($data['bigNum']) && $data['bigNum'] >= $meetNum && isset($data['itemPrice']) && $data['itemPrice'] >= $meetAmount) {
  864. if ($cutAmount < $actPrice) {
  865. $actPrice = bcsub($actPrice, $cutAmount, 2);
  866. $data['orderReachDiscountPrice'] = $cutAmount;
  867. } else {
  868. noticeUtil::push('订单金额不足满减金额,customId:' . $customId, '15280215347');
  869. }
  870. }
  871. }
  872. }
  873. }
  874. //如果有设置指定客户涨价百分之几,然后又设置了涨价的幅度。【这个功能主要用于客户不收他运费,门店不赚钱,收他运费客户不乐意,所以把运费加到花材里】,多处同步修改,关键词 rise_percent_rang
  875. if (isset($data['itemPrice'])) {
  876. if (isset($data['orderReachDiscountPrice'])) {
  877. $originActPrice = bcadd($actPrice, $data['orderReachDiscountPrice'], 2);
  878. } else {
  879. $originActPrice = $actPrice;
  880. }
  881. if ($originActPrice >= $data['itemPrice']) {
  882. if (isset($custom['risePercent']) && $custom['risePercent'] > 0) {
  883. if (isset($custom['riseRange']) && $custom['riseRange'] > 0) {
  884. $risePercent = $custom['risePercent'];
  885. $riseRange = $custom['riseRange'];
  886. // 计算涨价金额:涨价后金额 * (涨价百分比 / (100 + 涨价百分比))
  887. $riseAmount = bcmul($data['itemPrice'], bcdiv($risePercent, bcadd(100, $risePercent, 0), 4), 2);
  888. if ($riseAmount > $riseRange) {
  889. //应该退回的金额
  890. $backAmount = bcsub($riseAmount, $riseRange, 2);
  891. $actPrice = bcsub($actPrice, $backAmount, 2);
  892. if (isset($data['orderReachDiscountPrice'])) {
  893. if ($data['orderReachDiscountPrice'] < $backAmount) {
  894. //前面整单满减的,就不减了,所以这里面加回来
  895. $actPrice = bcadd($actPrice, $data['orderReachDiscountPrice'], 2);
  896. //改成减多加钱里面的
  897. $data['orderReachDiscountPrice'] = $backAmount;
  898. }
  899. } else {
  900. $data['orderReachDiscountPrice'] = $backAmount;
  901. }
  902. }
  903. }
  904. }
  905. }
  906. }
  907. //客户采购时使用红包时
  908. if (isset($data['discountType']) && $data['discountType'] == dict::getDict('discountType', 'hb')) {
  909. $discountAmount = $data['discountAmount'] ?? 0;
  910. $currentDiscountPrice = bcsub($currentPrice, $discountAmount, 2);
  911. $actPrice = $currentDiscountPrice;
  912. }
  913. $data['actPrice'] = $actPrice;
  914. $data['bookPrice'] = $actPrice;
  915. $data['orderPrice'] = $actPrice;
  916. $data['realPrice'] = $actPrice;
  917. $data['sendTimeWant'] = isset($data['sendTimeWant']) && !empty($data['sendTimeWant']) ? $data['sendTimeWant'] : date("Y-m-d");
  918. //订单有效期
  919. $validTime = dict::getDict('order_pay_has_time');
  920. $current = time() + $validTime;
  921. $data['deadline'] = $data['deadline'] ?? date("Y-m-d H:i:s", $current);
  922. $data['status'] = self::ORDER_STATUS_UN_PAY;
  923. $main->totalOrder += 1;
  924. $main->unPayOrder += 1;
  925. $main->save();
  926. //将当天日期+花店每天的总订单数作为编号,批发的加个0作为前缀,跟零售的编号这样来区分
  927. $data['sendNum'] = '0' . date("j") . StatOrderCountClass::addOrder($shop, $main);
  928. //订单有效期
  929. $currentTime = time();
  930. $validTime = dict::getDict('order_pay_has_time');
  931. $current = $currentTime + $validTime;
  932. $data['deadline'] = $data['deadline'] ?? date("Y-m-d H:i:s", $current);
  933. if ($book == 1) {
  934. $fiveTime = bcmul(86400, 5);
  935. $bookDeadline = bcadd($currentTime, $fiveTime);
  936. $data['deadline'] = date("Y-m-d H:i:s", $bookDeadline);
  937. }
  938. //订单自动记为欠款单时间
  939. $localConfirmTime = dict::getDict('local_gys_kd_auto_set_debt_time');
  940. $currentSet = $currentTime + $localConfirmTime;
  941. $data['autoSetTime'] = $data['autoSetTime'] ?? date("Y-m-d H:i:s", $currentSet);
  942. $data['salt'] = $data['salt'] ?? stringUtil::charsShuffleLowerCase(10);
  943. $return = self::add($data, true);
  944. return $return;
  945. }
  946. //修改订单 ssh 2019.12.5
  947. public static function updateOrder($order, $data)
  948. {
  949. $sjId = $order->sjId ?? 0;
  950. $orderSn = $order->orderSn ?? 0;
  951. $currentShopId = $order->shopId ?? 0;
  952. $data['payStatus'] = self::PAY_STATUS_UN_PAY;
  953. //花材列表
  954. $product = $data['product'];
  955. //删除花材再添加
  956. OrderItemClass::deleteByCondition(['orderSn' => $orderSn]);
  957. $respond = OrderItemClass::replaceItem($orderSn, $product, $data);
  958. $sendCost = isset($data['sendCost']) && is_numeric($data['sendCost']) ? $data['sendCost'] : 0;
  959. $data['sendCost'] = $sendCost;
  960. $data['bigNum'] = $respond['bigNum'] ?? 0;
  961. $data['smallNum'] = $respond['smallNum'] ?? 0;
  962. $price = $respond['price'] ?? 0;
  963. $currentPrice = bcadd($price, $sendCost, 2);
  964. $data['prePrice'] = $currentPrice;
  965. if (isset($data['modifyPrice'])) {
  966. //商家打折,修改金额
  967. $modifyPrice = $data['modifyPrice'] ?? 0;
  968. if ($modifyPrice > $currentPrice) {
  969. util::fail('实收金额大于订单总金额');
  970. }
  971. if ($modifyPrice < $currentPrice) {
  972. $data['discountAmount'] = bcsub($currentPrice, $modifyPrice, 2);
  973. $data['discountType'] = dict::getDict('discountType', 'discount');
  974. $currentPrice = $modifyPrice;
  975. }
  976. }
  977. $data['actPrice'] = $currentPrice;
  978. $data['realPrice'] = $currentPrice;
  979. //如果有平台补贴
  980. if (isset($data['discountType']) && $data['discountType'] == dict::getDict('discountType', 'usePtCoupon')) {
  981. $discountAmount = $data['discountAmount'] ?? 0;
  982. $data['realPrice'] = bcsub($currentPrice, $discountAmount, 2);
  983. }
  984. $data['sendTime'] = isset($data['sendTime']) && !empty($data['sendTime']) ? $data['sendTime'] : '0000-00-00 00:00:00';
  985. //订单有效期
  986. $validTime = dict::getDict('order_pay_has_time');
  987. $current = time() + $validTime;
  988. $data['deadline'] = $data['deadline'] ?? date("Y-m-d H:i:s", $current);
  989. $data['status'] = self::ORDER_STATUS_UN_PAY;
  990. //计算总重量(kg)
  991. $weight = 0;
  992. $productMapData = ProductClass::getProductMapData($product);
  993. foreach ($product as $key => $val) {
  994. $w = ProductClass::getWeight($val['productId'], $val['bigNum'], $val['smallNum']);
  995. $productId = $val['productId'];
  996. $weight = bcadd($w, $weight, 2);
  997. $checkStock = true;
  998. $stockInfo = ProductClass::decreaseStock($val['productId'], $val['bigNum'], $val['smallNum'], $checkStock);
  999. //记录库存流水
  1000. $recordData = [];
  1001. $recordData['sjId'] = $sjId;
  1002. $recordData['shopId'] = $currentShopId;
  1003. $recordData['itemId'] = $productMapData[$productId]['itemId'] ?? 0;
  1004. $ratio = $productMapData[$productId]['ratio'] ?? 0;
  1005. $recordData['itemNum'] = ProductClass::mergeItemNum($val['bigNum'], $val['smallNum'], $ratio);
  1006. $recordData['oldStock'] = $stockInfo['oldStock'];
  1007. $recordData['newStock'] = $stockInfo['newStock'];
  1008. $recordData['productId'] = $productId;
  1009. $recordData['orderSn'] = $orderSn;
  1010. StockRecordClass::addSellStockOrderRecord($recordData);
  1011. }
  1012. $data['weight'] = $weight;
  1013. $current = time() + 300;
  1014. $data['deadline'] = isset($data['deadline']) ? $data['deadline'] : date("Y-m-d H:i:s", $current);
  1015. //修改订单暂时不打印
  1016. $data['needPrint'] = $data['needPrint'] ?? dict::getDict('needPrint', 'need');
  1017. $orderId = $order->id ?? 0;
  1018. self::updateById($orderId, $data);
  1019. $return = self::getLockById($orderId);
  1020. //门店总订单数+1
  1021. $shop = ShopClass::getLockById($currentShopId);
  1022. if (empty($shop)) {
  1023. util::fail('没有找到门店8');
  1024. }
  1025. $shop->unPayOrder += 1;
  1026. $shop->cancelOrder -= 1;
  1027. $shop->save();
  1028. return $return;
  1029. }
  1030. //根据订单编号查询 ssh 2021.19
  1031. public static function getByOrderSn($orderSn, $returnObj = false)
  1032. {
  1033. return self::getByCondition(['orderSn' => $orderSn], $returnObj);
  1034. }
  1035. //根据编号列表查订单
  1036. public static function getOrderInfoBySnList($snList)
  1037. {
  1038. $list = self::getAllByCondition(['orderSn' => ['in', $snList]], null, '*', 'orderSn');
  1039. $list = self::groupOrder($list, true, false, false, true);
  1040. return $list;
  1041. }
  1042. //显示操作按钮
  1043. public static function getShowButton($showButton, $isList, $order)
  1044. {
  1045. if ($showButton == false) {
  1046. return [];
  1047. }
  1048. $print = ['type' => 'print', 'show' => 1, 'disable' => 0, 'name' => '打印'];
  1049. $modifyProduct = ['type' => 'modifyProduct', 'show' => 0, 'disable' => 0, 'name' => '修改花材'];
  1050. $confirm = ['type' => 'confirm', 'show' => 0, 'disable' => 1, 'name' => '确认'];
  1051. $cancel = ['type' => 'cancel', 'show' => 0, 'disable' => 0, 'name' => '取消'];
  1052. $arrival = ['type' => 'arrival', 'show' => 0, 'disable' => 0, 'name' => '确认发货'];
  1053. if ($isList) {
  1054. //订单列表页显示的按钮
  1055. $send = ['type' => 'send', 'show' => 0, 'disable' => 0, 'name' => '发货'];
  1056. $selfGet = ['type' => 'selfGet', 'show' => 0, 'disable' => 1, 'name' => '自取'];
  1057. if ($order['status'] == self::ORDER_STATUS_UN_PAY) {
  1058. //待确认订单,打印和修改花材按钮可以使用
  1059. $send['disable'] = 1;
  1060. $selfGet['disable'] = 1;
  1061. $print['disable'] = 0;
  1062. $confirm['disable'] = 0;
  1063. }
  1064. if ($order['status'] == self::ORDER_STATUS_UN_SEND) {
  1065. //待配送订单,改花材按钮不可点,自取可点
  1066. $selfGet['disable'] = 0;
  1067. }
  1068. //自取订单发货按钮置灰
  1069. if ($order['sendType'] == self::SEND_TYPE_NO) {
  1070. $send['disable'] = 1;
  1071. }
  1072. //取消订单置灰
  1073. if ($order['status'] == self::ORDER_STATUS_CANCEL) {
  1074. $send['disable'] = 1;
  1075. $selfGet['disable'] = 1;
  1076. $print['disable'] = 1;
  1077. }
  1078. if ($order['status'] == self::ORDER_STATUS_COMPLETE) {
  1079. $send['name'] = '发货记录';
  1080. }
  1081. return [$send, $selfGet, $print, $confirm];
  1082. } else {
  1083. //订单详情页显示的按钮
  1084. if (isset($order['book']) && $order['book'] == 1 && isset($order['stockChange']) && $order['stockChange'] == 0) {
  1085. if ($order['status'] == self::ORDER_STATUS_UN_SEND) {
  1086. $arrival['show'] = 1;
  1087. }
  1088. }
  1089. //待确认订单显示延期付和已付款
  1090. if ($order['status'] == self::ORDER_STATUS_UN_PAY) {
  1091. $debtPay = ['type' => 'debtPay', 'show' => 0, 'disable' => 0, 'name' => '延期收款'];
  1092. $hasPay = ['type' => 'hasPay', 'show' => 0, 'disable' => 0, 'name' => '欠款'];
  1093. $confirm['disable'] = 0;
  1094. return [$print, $debtPay, $hasPay, $confirm, $cancel, $arrival];
  1095. }
  1096. //待配送订单显示打印、发货和自取
  1097. if ($order['status'] == self::ORDER_STATUS_UN_SEND) {
  1098. $selfGet = ['type' => 'selfGet', 'show' => 0, 'disable' => 1, 'name' => '自取'];
  1099. $send = ['type' => 'send', 'show' => 0, 'disable' => 1, 'name' => '发货'];
  1100. if ($order['hasItem'] == 2) {
  1101. return [$print, $selfGet, $send, $arrival];
  1102. }
  1103. $selfGet['disable'] = 0;
  1104. $send['disable'] = 0;
  1105. return [$print, $selfGet, $send, $arrival];
  1106. }
  1107. //配送中显示按钮
  1108. if ($order['status'] == self::ORDER_STATUS_SENDING) {
  1109. $send = ['type' => 'send', 'show' => 0, 'disable' => 0, 'name' => '发货'];
  1110. return [$print, $send, $arrival];
  1111. }
  1112. //完成
  1113. if ($order['status'] == self::ORDER_STATUS_COMPLETE) {
  1114. $send = ['type' => 'send', 'show' => 0, 'disable' => 0, 'name' => '发货记录'];
  1115. //自取订单不显示发货按钮
  1116. if ($order['sendType'] == self::SEND_TYPE_NO) {
  1117. $send['show'] = 0;
  1118. }
  1119. return [$print, $send, $arrival];
  1120. }
  1121. //取消订单置灰
  1122. if ($order['status'] == self::ORDER_STATUS_CANCEL) {
  1123. $selfGet['disable'] = 1;
  1124. $send['disable'] = 1;
  1125. $print['disable'] = 1;
  1126. return [$modifyProduct, $arrival];
  1127. }
  1128. return [];
  1129. }
  1130. }
  1131. //显示进度 ssh 2021.3.1
  1132. public static function getShowProgress($showProgress, $order)
  1133. {
  1134. if ($showProgress == false) {
  1135. return [];
  1136. }
  1137. $create = ['name' => '创建', 'complete' => 1];
  1138. $unConfirm = ['name' => '待确认', 'complete' => 0];
  1139. if ($order['status'] > 0) {
  1140. $unConfirm['complete'] = 1;
  1141. }
  1142. $out = ['name' => '出库', 'complete' => 0];
  1143. if ($order['status'] > 1) {
  1144. $out['complete'] = 1;
  1145. }
  1146. return [$create, $unConfirm, $out];
  1147. }
  1148. //退款等需要使用原来的订单花材结构
  1149. public static function getOriginalShowItem($showItem, $order)
  1150. {
  1151. if ($showItem == false) {
  1152. return ['list' => [], 'itemStat' => []];
  1153. }
  1154. $orderSn = $order['orderSn'];
  1155. $list = OrderItemClass::getOrderItem($orderSn);
  1156. $totalPrice = 0;
  1157. $totalBigNum = 0;
  1158. $totalSmallNum = 0;
  1159. $kind = 0;
  1160. $itemStat = [];
  1161. if (!empty($list)) {
  1162. $ids = array_column($list, 'productId');
  1163. $ids = array_filter(array_unique($ids));
  1164. $productInfo = ProductClass::getByIds($ids, null, 'id');
  1165. foreach ($list as $key => $val) {
  1166. $productId = $val['productId'] ?? 0;
  1167. $currentInfo = $productInfo[$productId];
  1168. $currentPrice = $productInfo[$productId]['price'] ?? 0;
  1169. $unitPrice = isset($val['xhUnitPrice']) ? floatval($val['xhUnitPrice']) : 0;
  1170. $list[$key]['currentHdPrice'] = $unitPrice;
  1171. //原有售价
  1172. $list[$key]['itemSalePrice'] = floatval($currentPrice);
  1173. //自己填的价格
  1174. $list[$key]['itemModifyPrice'] = $unitPrice;
  1175. $list[$key]['property'] = '';
  1176. $list[$key]['cost'] = $currentInfo['cost'] ?? 0;
  1177. $list[$key]['stock'] = $currentInfo['stock'] ? floatval($currentInfo['stock']) : 0;
  1178. $price = $val['price'];
  1179. $totalPrice = stringUtil::calcAdd($totalPrice, $price);
  1180. $kind++;
  1181. $currentBigNum = $val['bigNum'] ?? 0;
  1182. $currentSmallNum = $val['smallNum'] ?? 0;
  1183. $currentGiveNum = $val['giveNum'] ?? 0;
  1184. $totalBigNum = stringUtil::calcAdd($totalBigNum, $currentBigNum);
  1185. $totalBigNum = bcadd($totalBigNum, $currentGiveNum);
  1186. $totalSmallNum = stringUtil::calcAdd($totalSmallNum, $currentSmallNum);
  1187. }
  1188. $itemStat = ['kind' => $kind, 'bigNum' => $totalBigNum, 'smallNun' => $totalSmallNum, 'totalPrice' => $totalPrice];
  1189. }
  1190. return ['list' => $list, 'itemStat' => $itemStat];
  1191. }
  1192. public static function getShowItem($showItem, $order)
  1193. {
  1194. if ($showItem == false) {
  1195. return ['list' => [], 'itemStat' => []];
  1196. }
  1197. $orderSn = $order['orderSn'];
  1198. $list = OrderItemClass::getOrderItem($orderSn);
  1199. $totalPrice = 0;
  1200. $totalBigNum = 0;
  1201. $totalSmallNum = 0;
  1202. $kind = 0;
  1203. $itemStat = [];
  1204. //小菊增加部分
  1205. $xjAddList = [];
  1206. if (!empty($list)) {
  1207. foreach ($list as $key => $val) {
  1208. $price = $val['price'];
  1209. $totalPrice = stringUtil::calcAdd($totalPrice, $price);
  1210. $kind++;
  1211. $currentBigNum = $val['bigNum'];
  1212. $currentSmallNum = $val['smallNum'];
  1213. $unitType = $val['xhUnitType'] ?? 0;
  1214. $refundNum = $val['refundNum'] ?? 0;
  1215. if ($unitType == 0) {
  1216. $currentBigNum = bcsub($currentBigNum, $refundNum);
  1217. } else {
  1218. $currentSmallNum = bcsub($currentSmallNum, $refundNum);
  1219. }
  1220. $totalBigNum = stringUtil::calcAdd($totalBigNum, $currentBigNum);
  1221. $totalSmallNum = stringUtil::calcAdd($totalSmallNum, $currentSmallNum);
  1222. //赠送数量
  1223. $giveNum = $val['giveNum'] ?? 0;
  1224. $totalBigNum = bcadd($totalBigNum, $giveNum);
  1225. $list[$key]['property'] = '';
  1226. //小菊
  1227. if (isset($val['variety']) && $val['variety'] == 1) {
  1228. $currentItemId = $val['id'] ?? 0;
  1229. $xjList = OrderXjClass::getAllByCondition(['itemId' => $currentItemId], null, '*');
  1230. if (!empty($xjList)) {
  1231. //选了有颜色的小菊才把原小菊删除不显示出来!!!
  1232. unset($list[$key]);
  1233. foreach ($xjList as $xjKey => $xj) {
  1234. $xjBase = $val;
  1235. $num = $xj['num'] ?? 0;
  1236. $price = $xj['price'] ?? 0;
  1237. $name = $xj['name'] ?? '';
  1238. $cover = $xj['cover'] ?? '';
  1239. if ($num > 0) {
  1240. $bigTotalPrice = bcmul($price, $num, 2);
  1241. $xjBase['cover'] = imgUtil::groupImg($cover) . "?x-oss-process=image/resize,m_fill,h_130,w_130";
  1242. $xjBase['bigCover'] = imgUtil::groupImg($cover) . "?x-oss-process=image/resize,m_fill,h_700,w_700";
  1243. $xjBase['unitPrice'] = $price;
  1244. $xjBase['price'] = floatval($bigTotalPrice);
  1245. $xjBase['num'] = floatval($num);
  1246. $xjBase['bigNum'] = floatval($num);
  1247. $xjBase['name'] = $name;
  1248. $xjBase['property'] = '';
  1249. $xjBase['userPrice'] = $bigTotalPrice;
  1250. $xjBase['xhNum'] = floatval($num);
  1251. $xjBase['xhPreNum'] = floatval($num);
  1252. $xjBase['xhPrice'] = floatval($bigTotalPrice);
  1253. $xjAddList[] = $xjBase;
  1254. }
  1255. }
  1256. }
  1257. }
  1258. }
  1259. if (!empty($xjAddList)) {
  1260. $list = array_merge($list, $xjAddList);
  1261. }
  1262. $itemStat = ['kind' => $kind, 'bigNum' => $totalBigNum, 'smallNun' => $totalSmallNum, 'totalPrice' => $totalPrice];
  1263. }
  1264. return ['list' => $list, 'itemStat' => $itemStat];
  1265. }
  1266. /**
  1267. * 列表分享:批量附加采购单 salt,仅查 purchase 表 id,salt
  1268. */
  1269. public static function attachCgSaltForList($list)
  1270. {
  1271. if (empty($list)) {
  1272. return $list;
  1273. }
  1274. $purchaseIds = array_unique(array_filter(array_column($list, 'purchaseId')));
  1275. $cgSaltMap = [];
  1276. if (!empty($purchaseIds)) {
  1277. $cgList = PurchaseClass::getByIds($purchaseIds, null, 'id', 'id,salt');
  1278. foreach ($cgList as $cg) {
  1279. $cgId = $cg['id'] ?? 0;
  1280. if (!empty($cgId)) {
  1281. $cgSaltMap[$cgId] = $cg['salt'] ?? '';
  1282. }
  1283. }
  1284. }
  1285. foreach ($list as $key => $val) {
  1286. $purchaseId = $val['purchaseId'] ?? 0;
  1287. $list[$key]['cgSalt'] = !empty($purchaseId) ? ($cgSaltMap[$purchaseId] ?? '') : '';
  1288. }
  1289. return $list;
  1290. }
  1291. //订单列表 ssh 2021.1.19
  1292. public static function getOrderList($where)
  1293. {
  1294. $data = self::getList('*', $where, 'addTime DESC');
  1295. $data['totalActPrice'] = 0;
  1296. $data['totalTkPrice'] = 0;
  1297. if (!empty($data['list'])) {
  1298. $distIds = array_unique(array_filter(array_column($data['list'], 'customDistId')));
  1299. $distMap = [];
  1300. if (!empty($distIds)) {
  1301. $distMap = DistClass::getByIds($distIds, null, 'id');
  1302. }
  1303. foreach ($data['list'] as $key => $val) {
  1304. $customDistId = intval($val['customDistId'] ?? 0);
  1305. $data['list'][$key]['customDistName'] = $customDistId > 0 && isset($distMap[$customDistId])
  1306. ? ($distMap[$customDistId]['name'] ?? '')
  1307. : '';
  1308. //同个人同地址当天订单数
  1309. $sameNum = $val['mergeNum'];
  1310. if ($sameNum > 0) {
  1311. $mergeId = $val['mergeId'] ?? 0;
  1312. if (!empty($mergeId)) {
  1313. $mergeList = OrderMergeClass::getAllByCondition(['mergeId' => $mergeId], null, 'orderId');
  1314. $ids = array_column($mergeList, 'orderId');
  1315. $sameTimeIds = implode(',', $ids);
  1316. $data['list'][$key]['sameTimeIds'] = $sameTimeIds;
  1317. $data['list'][$key]['mergeStatus'] = '已经使用新版本';
  1318. }
  1319. } else {
  1320. $sameTimeIds = $val['sameTimeIds'] ?? '';
  1321. if (!empty($sameTimeIds)) {
  1322. $sameIds = explode(',', $sameTimeIds);
  1323. $sameNum = count($sameIds);
  1324. }
  1325. }
  1326. $data['list'][$key]['sameTimeIdsNum'] = $sameNum;
  1327. $data['list'][$key]['customAvatarUrl'] = imgUtil::groupImg('');
  1328. }
  1329. $data['list'] = self::attachCgSaltForList($data['list']);
  1330. }
  1331. return $data;
  1332. }
  1333. //按片区排列的订单列表
  1334. public static function getDistOrderList($where)
  1335. {
  1336. /** @var Order $model */
  1337. $model = self::getActiveRecord();
  1338. $query = $model->conditionQuery($where)
  1339. ->alias('o')
  1340. ->leftJoin(['c' => Custom::tableName()], 'c.id = o.customId')
  1341. ->select(['o.id', 'o.mainId', 'o.customId', 'o.customName', 'o.customAvatar', 'o.fullAddress', 'o.remark', 'c.name', 'c.mobile', 'c.distId', 'distId' => 'c.distId']);
  1342. // $clone = clone $query;
  1343. // $count = intval($clone->count('o.id'));
  1344. $orderList = $query
  1345. ->orderBy(['c.distId' => SORT_ASC, 'o.addTime' => SORT_DESC]) // ->offset($offset)->limit($pageSize)
  1346. ->asArray()
  1347. ->all();
  1348. $distIds = array_unique(array_filter(array_column($orderList, 'distId')));
  1349. $distMap = [];
  1350. if (!empty($distIds)) {
  1351. $distMap = DistClass::getByIds($distIds, null, 'id');
  1352. }
  1353. $grouped = [];
  1354. foreach ($orderList as $orderInfo) {
  1355. $distId = intval($orderInfo['distId']);
  1356. if (!isset($grouped[$distId]) && isset($distMap[$distId])) {
  1357. $grouped[$distId] = [
  1358. 'distId' => $distId,
  1359. 'distName' => $distMap[$distId]['name'],
  1360. 'list' => [],
  1361. ];
  1362. }
  1363. $grouped[$distId]['list'][$orderInfo['customId']][] = $orderInfo;
  1364. }
  1365. return [
  1366. 'list' => array_values($grouped),
  1367. ];
  1368. }
  1369. //整合订单员工和供货商等信息 ssh 2021.1.19
  1370. //$isList 是否列表页
  1371. public static function groupOrder($list, $showButton = false, $showItem = false, $showExpress = false, $isList = false)
  1372. {
  1373. if (empty($list)) {
  1374. return $list;
  1375. }
  1376. $adminIds = array_unique(array_filter(array_column($list, 'adminId')));
  1377. $adminInfo = AdminClass::getAdminByIds($adminIds, null, 'id');
  1378. //退款需要显示原有的花材结构,不显示小菊的多颜色
  1379. $getOriginalItem = Yii::$app->request->get('getOriginalItem', 0);
  1380. $getOriginalItem2 = Yii::$app->request->post('getOriginalItem', 0);
  1381. $customIds = array_column($list, 'customId');
  1382. $customIds = array_unique(array_filter($customIds));
  1383. $customInfoList = CustomClass::getByIds($customIds, null, 'id');
  1384. foreach ($list as $key => $val) {
  1385. $adminId = $val['adminId'] ?? 0;
  1386. $list[$key]['adminName'] = $adminInfo[$adminId]['name'] ?? '';
  1387. $list[$key]['customAddress'] = $val['fullAddress'] ?? '';
  1388. //显示列表页的操作按钮
  1389. $list[$key]['buttonList'] = self::getShowButton($showButton, $isList, $val);
  1390. //为了列表页的打印按钮能用,列表也强制显示花材
  1391. $showItem = true;
  1392. if ($getOriginalItem == 1 || $getOriginalItem2 == 1) {
  1393. $showItemData = self::getOriginalShowItem($showItem, $val);
  1394. } else {
  1395. $showItemData = self::getShowItem($showItem, $val);
  1396. }
  1397. $list[$key]['product'] = $showItemData['list'];
  1398. $list[$key]['productStat'] = $showItemData['itemStat'];
  1399. $showResetItem = 0;
  1400. //待付款订单显示改花材按钮
  1401. if ($val['status'] == self::PAY_STATUS_UN_PAY) {
  1402. $showResetItem = 1;
  1403. }
  1404. $list[$key]['showResetItem'] = $showResetItem;
  1405. //获取配送进展
  1406. $expressProgress = '';
  1407. if ($val['sendType'] == 4) {
  1408. $expressInfo = OrderExpressClass::getByCondition(['orderSn' => $val['orderSn']]);
  1409. if ($expressInfo) {
  1410. $expressProgress = ['progressName' => OrderExpressClass::$statusMap[$expressInfo['status']] ?? ''];
  1411. }
  1412. }
  1413. $list[$key]['sendTypeName'] = self::$sendTypeMap[$val['sendType']] ?? '未知';
  1414. $list[$key]['expressProgress'] = $expressProgress;
  1415. $list[$key]['customAvatarUrl'] = imgUtil::groupImg($val['customAvatar']);
  1416. $list[$key]['customName'] = !empty($val['customId']) ? $val['customName'] : '散客';
  1417. $customId = $val['customId'] ?? '';
  1418. $balance = $customInfoList[$customId]['balance'] ?? 0.00;
  1419. $debtAmount = $balance < 0 ? abs($balance) : 0;
  1420. //打印数据组合
  1421. $printData = self::getPrintData($val, $debtAmount, $showItemData);
  1422. $list[$key]['printData'] = json_encode($printData);
  1423. $list[$key]['debtAmount'] = $debtAmount;
  1424. $list[$key]['customShopId'] = $customInfoList[$customId]['shopId'] ?? 0;
  1425. //计算利润
  1426. $actPrice = $val['actPrice'] ?? 0;
  1427. $remainCost = $val['remainCost'] ?? 0;
  1428. $profit = bcsub($actPrice, $remainCost, 2);
  1429. $profit = floatval($profit);
  1430. $list[$key]['profit'] = $profit;
  1431. }
  1432. return self::attachCgSaltForList($list);
  1433. }
  1434. public static function printGroup($current, $content, $showPrice = 1, $fontSizeType = 0)
  1435. {
  1436. //58mm的机器,一行打印16个汉字,32个字母
  1437. $productPrice = $current['price'] ?? '';
  1438. $unitPrice = $current['unitPrice'] ?? '';
  1439. $name = $current['name'] ?? '';
  1440. if (floatval($unitPrice) == 0.01) {
  1441. $name = $name . '(送)';
  1442. }
  1443. $productNum = $current['num'] ?? '';
  1444. $itemNum = $current['itemNum'] ?? 0;
  1445. $refundNum = $current['refundNum'] ?? 0;
  1446. $unitName = $current['unitName'] ?? '扎';
  1447. $remark = $current['remark'] ?? '';
  1448. $ratioType = $current['ratioType'] === null ? -1 : intval($current['ratioType']);
  1449. $ratio = $current['ratio'];
  1450. $lastNum = bcsub($itemNum, $refundNum);
  1451. if (!empty($remark)) {
  1452. $show = $lastNum . $unitName . ' ' . $name . "【" . $remark . "】";
  1453. } else {
  1454. $show = $lastNum . $unitName . ' ' . $name;
  1455. }
  1456. if ($fontSizeType == 1) {
  1457. $content .= '<L>' . $show . '</L><BR>';
  1458. } else {
  1459. $content .= '<B>' . $show . '</B><BR>';
  1460. }
  1461. if ($refundNum > 0) {
  1462. $content .= '(买' . $itemNum . $unitName . ' 退' . $refundNum . $unitName . ')<BR>';
  1463. }
  1464. if ($showPrice == 1) {
  1465. if (floatval($unitPrice) == 0.01) {
  1466. $content .= $productNum . ' = ' . $productPrice . '元 赠送价<BR>';
  1467. } else {
  1468. $content .= $productNum . ' = ' . $productPrice . '元 ' . ($ratioType == 0 ? $ratio . '支装' : ($ratioType == 1 ? '若干支装' : '')) . '<BR>';
  1469. }
  1470. } else {
  1471. $content .= ' ' . ($ratioType == 0 ? $ratio . '支装' : ($ratioType == 1 ? '若干支装' : '')) . '<BR>';
  1472. }
  1473. $content .= '--------------------------------<BR>';
  1474. return $content;
  1475. }
  1476. //合并打印订单 ssh 20230929
  1477. public static function mergePrintOrder($ids, $mainId)
  1478. {
  1479. $all = OrderClass::getAllByCondition(['id' => ['in', $ids]], null, '*', null, true);
  1480. if (empty($all)) {
  1481. util::fail('没有找到订单');
  1482. }
  1483. $snList = [];
  1484. $sendNumList = [];
  1485. $remarkList = [];
  1486. foreach ($all as $info) {
  1487. if ($info->mainId != $mainId) {
  1488. util::fail('不是你的订单');
  1489. }
  1490. $orderSn = $info->orderSn;
  1491. if ($info->payStatus == 1) {
  1492. $snList[] = $orderSn;
  1493. $orderInfo = $info;
  1494. $sendNumList[] = $info->sendNum;
  1495. if (!empty($info->remark)) {
  1496. $remarkList[] = $info->remark;
  1497. }
  1498. }
  1499. }
  1500. $sendNumString = '';
  1501. if (!empty($sendNumList)) {
  1502. $sendNumString = implode(',', $sendNumList);
  1503. }
  1504. $remarkString = '';
  1505. if (!empty($remarkList)) {
  1506. $remarkString = implode(',', $remarkList);
  1507. }
  1508. $allItem = OrderItemClass::getAllByCondition(['orderSn' => ['in', $snList]], null, '*');
  1509. if (empty($allItem)) {
  1510. util::fail('没有花材信息');
  1511. }
  1512. $new = [];
  1513. foreach ($allItem as $currentItem) {
  1514. $unitType = $currentItem['xhPreUnitType'] ?? 1;
  1515. $productId = $currentItem['productId'] ?? 0;
  1516. if ($unitType == 0 && $productId > 0) {
  1517. if (isset($new[$productId])) {
  1518. $xhNum = $currentItem['xhNum'] ?? 0;
  1519. $refundNum = $currentItem['refundNum'] ?? 0;
  1520. $giveNum = $currentItem['giveNum'] ?? 0;
  1521. $new[$productId]['xhNum'] = bcadd($new[$productId]['xhNum'], $xhNum);
  1522. $new[$productId]['refundNum'] = bcadd($new[$productId]['refundNum'], $refundNum);
  1523. $new[$productId]['giveNum'] = bcadd($new[$productId]['giveNum'], $giveNum);
  1524. $remark = $currentItem['remark'] ?? '';
  1525. if (!empty($remark)) {
  1526. $new[$productId]['remark'] = $remark;
  1527. }
  1528. } else {
  1529. $new[$productId] = $currentItem;
  1530. }
  1531. }
  1532. }
  1533. $showPrice = 1;
  1534. $customId = $orderInfo->customId ?? 0;
  1535. $c = CustomClass::getById($customId);
  1536. $debtAmount = $c['debtAmount'] ?? 0.00;
  1537. $shopId = $orderInfo->shopId ?? 0;
  1538. $shop = ShopClass::getById($shopId, true);
  1539. if (empty($shop)) {
  1540. util::fail('打印失败,没有找到门店9');
  1541. }
  1542. $sjId = $shop->sjId ?? 0;
  1543. $fontSizeType = $shop->fontSize ?? 0;
  1544. $telephone = $shop->telephone ?? '';
  1545. $sj = SjClass::getById($sjId, true);
  1546. $sjName = $sj->name ?? '';
  1547. $shopName = $shop->shopName ?? '';
  1548. $currentName = $shopName == '首店' ? $sjName : $sjName . ' ' . $shopName;
  1549. $fromType = $orderInfo->fromType ?? dict::getDict('fromType', 'shop');
  1550. $fromTypeMap = dict::getDict('fromTypeMap');
  1551. $fromTypeName = $fromTypeMap[$fromType] ?? '门店';
  1552. $content = "<CB>" . $currentName . "</CB>";
  1553. $content .= "<CB>销售单</CB><BR><BR>";
  1554. $content .= '<B>' . $sendNumString . ' ' . $fromTypeName . '</B><BR>';
  1555. $content .= '--------------------------------<BR>';
  1556. //快捷开单不需要打印买家信息
  1557. if ($customId != $shop->skCustomId) {
  1558. $content .= '<B>买家信息:</B><BR><BR>';
  1559. $content .= '<B>' . $orderInfo->customName . '</B><BR>';
  1560. $content .= '<B>' . $orderInfo->customMobile . '</B><BR>';
  1561. if (isset($orderInfo->address) && !empty($orderInfo->address)) {
  1562. $content .= $orderInfo->fullAddress;
  1563. if (isset($orderInfo->showAddress) && !empty($orderInfo->showAddress)) {
  1564. $content .= '(' . $orderInfo->showAddress . ')<BR>';
  1565. } else {
  1566. $content .= '<BR>';
  1567. }
  1568. }
  1569. }
  1570. if (isset($orderInfo->book) && $orderInfo->book == 1) {
  1571. $content .= '<B>预订单</B><BR>';
  1572. }
  1573. if (isset($orderInfo->presell) && $orderInfo->presell == 1) {
  1574. $content .= '<B>预售单</B><BR>';
  1575. }
  1576. if (isset($shop->pfLevel) && $shop->pfLevel == 1) {
  1577. if (isset($orderInfo->transType)) {
  1578. $sendName = '同城配送';
  1579. if ($orderInfo->transType == 0) {
  1580. $sendName = '德邦物流';
  1581. }
  1582. if ($orderInfo->transType == 1) {
  1583. $sendName = '顺丰物流';
  1584. }
  1585. if ($orderInfo->transType == 2) {
  1586. $sendName = '冷链物流';
  1587. }
  1588. if ($orderInfo->transType == 3) {
  1589. $sendName = '航空物流';
  1590. }
  1591. if ($orderInfo->transType == 4) {
  1592. $sendName = '同城配送';
  1593. }
  1594. if ($orderInfo->transType == 5) {
  1595. $sendName = '到店自取';
  1596. }
  1597. $content .= '<BR><B>' . $sendName . '</B><BR>';
  1598. }
  1599. } else {
  1600. if (isset($orderInfo->sendType)) {
  1601. $sendName = '送货上门';
  1602. if ($orderInfo->sendType == 1) {
  1603. $sendName = '到店自取';
  1604. }
  1605. if ($orderInfo->sendType == 2) {
  1606. $sendName = '跑腿送';
  1607. }
  1608. if ($orderInfo->sendType == 3) {
  1609. $wlName = $orderInfo['wlName'] ?? '未填物流';
  1610. $sendName = $wlName;
  1611. }
  1612. if ($orderInfo->sendType == 4) {
  1613. $sendName = '发快递';
  1614. }
  1615. $content .= '<BR><B>' . $sendName . '</B><BR>';
  1616. }
  1617. }
  1618. if (!empty($remarkString)) {
  1619. $content .= '<BR>';
  1620. $content .= '备注:<BR>';
  1621. $content .= '<B>' . $remarkString . '</B><BR>';
  1622. }
  1623. $content .= '<BR>';
  1624. $content .= '商品 数量/单价 金额 <BR>';
  1625. $content .= '--------------------------------<BR>';
  1626. $totalNum = 0;
  1627. $refundTotalNum = 0;
  1628. foreach ($new as $current) {
  1629. //58mm的机器,一行打印16个汉字,32个字母
  1630. $productPrice = $current['xhUnitPrice'] ?? '';
  1631. $name = $current['name'] ?? '';
  1632. if (floatval($productPrice) == 0.01) {
  1633. $name = $name . '(送)';
  1634. }
  1635. $giveNum = $current['giveNum'] ?? 0;
  1636. $refundNum = $current['refundNum'] ?? 0;
  1637. $productNum = $current['xhNum'] ?? '';
  1638. $unitName = $current['xhUnitName'] ?? '扎';
  1639. $remark = $current['remark'] ?? '';
  1640. $totalNum = bcadd($totalNum, $giveNum);
  1641. $refundTotalNum = bcadd($refundTotalNum, $refundNum);
  1642. $lastNum = bcadd($productNum, $giveNum);
  1643. $lastNum = bcsub($lastNum, $refundNum);
  1644. $show = $name . ' ' . $lastNum . $unitName;
  1645. if (!empty($remark)) {
  1646. $show .= "【{$remark}】";
  1647. }
  1648. $hint = '';
  1649. if ($refundNum > 0 || $giveNum > 0) {
  1650. $hint .= '(买' . $productNum . $unitName;
  1651. }
  1652. if ($refundNum > 0) {
  1653. $hint .= ' 退' . $refundNum . $unitName;
  1654. if ($giveNum <= 0) {
  1655. $hint .= ')';
  1656. }
  1657. }
  1658. if ($giveNum > 0) {
  1659. $hint .= ' 送' . $giveNum . $unitName . ')';
  1660. }
  1661. $content .= '<B>' . $show . '</B><BR>';
  1662. if (!empty($hint)) {
  1663. $content .= $hint . '<BR>';
  1664. }
  1665. $content .= '--------------------------------<BR>';
  1666. $totalNum = bcadd($totalNum, $productNum);
  1667. }
  1668. $content .= '********************************<BR>';
  1669. $kindNum = count($new);
  1670. $remainNum = bcsub($totalNum, $refundTotalNum);
  1671. $content .= "<CB>共{$kindNum}种";
  1672. $content .= ",{$remainNum}扎";
  1673. $content .= "</CB>";
  1674. $content .= '********************************<BR><BR>';
  1675. $ext = ShopExtClass::getByCondition(['shopId' => $shopId]);
  1676. $printSn = $ext['printSn'] ?? '';
  1677. if (!empty($printSn)) {
  1678. $p = new printUtil($printSn);
  1679. $p->printMsg($content, $shop);
  1680. }
  1681. foreach ($all as $info) {
  1682. if ($info->payStatus == 1) {
  1683. $info->printNum += 1;
  1684. $info->printStatus = 2;
  1685. $info->save();
  1686. }
  1687. }
  1688. }
  1689. //超出数量的打印 sssh 20240605
  1690. public static function onlinePrintOver($showItem, $orderInfo, $currentName, $shop)
  1691. {
  1692. $itemList = $showItem['list'];
  1693. $orderSn = $orderInfo->orderSn ?? '';
  1694. $arr = array_chunk($itemList, 40);
  1695. $totalPage = count($arr);
  1696. foreach ($arr as $key => $itemList) {
  1697. $content = '';
  1698. $content .= "<CB>{$currentName}</CB><BR>";
  1699. $content .= "<CB>销售单</CB><BR><BR>";
  1700. $content .= '<CB>' . $orderSn . '</CB><BR><BR>';
  1701. //快捷开单不需要打印买家信息
  1702. if ($orderInfo->customId != $shop->skCustomId) {
  1703. $content .= '<B>买家信息:</B><BR><BR>';
  1704. $content .= '<B>' . $orderInfo->customName . '</B><BR>';
  1705. $content .= '<B>' . $orderInfo->customMobile . '</B><BR>';
  1706. if (isset($orderInfo['address']) && !empty($orderInfo['address'])) {
  1707. $content .= $orderInfo->fullAddress;
  1708. if (isset($orderInfo['showAddress']) && !empty($orderInfo['showAddress']) && $orderInfo->fullAddress != $orderInfo['showAddress']) {
  1709. $content .= '(' . $orderInfo['showAddress'] . ')<BR><BR>';
  1710. } else {
  1711. $content .= '<BR><BR>';
  1712. }
  1713. }
  1714. }
  1715. if ($totalPage > 1) {
  1716. $currentPage = bcadd($key, 1);
  1717. $content .= "<CB>第{$currentPage}页,共{$totalPage}页</CB><BR>";
  1718. }
  1719. $content .= '<BR>';
  1720. $content .= '商品 数量 <BR>';
  1721. $content .= '--------------------------------<BR>';
  1722. if (isset($itemList) && !empty($itemList)) {
  1723. foreach ($itemList as $info) {
  1724. $name = $info['name'] ?? '';
  1725. $num = $info['xhNum'] ?? 0;
  1726. $refundNum = $info['refundNum'] ?? 0;
  1727. $lastNum = bcsub($num, $refundNum);
  1728. $unitName = $info['xhUnitName'] ?? '';
  1729. $show = $name . ' ' . $lastNum . $unitName;
  1730. $content .= '<B>' . $show . '</B><BR>';
  1731. $content .= '--------------------------------<BR>';
  1732. }
  1733. }
  1734. $kindNum = $showItem['itemStat']['kind'] ?? 0;
  1735. $bigNum = $showItem['itemStat']['bigNum'] ?? 0;
  1736. $smallNun = $showItem['itemStat']['smallNun'] ?? 0;
  1737. $content .= '********************************<BR>';
  1738. $content .= "<CB>共{$kindNum}种";
  1739. $content .= " 数量:";
  1740. if ($bigNum > 0) {
  1741. $content .= "{$bigNum}";
  1742. }
  1743. if ($smallNun > 0) {
  1744. $content .= "{$smallNun}";
  1745. }
  1746. $content .= "</CB>";
  1747. $content .= '********************************<BR><BR>';
  1748. $content .= '<BR>';
  1749. $content .= '<BR>';
  1750. $shopId = $shop->id;
  1751. $ext = ShopExtClass::getByCondition(['shopId' => $shopId]);
  1752. $printSn = $ext['printSn'] ?? '';
  1753. if (!empty($printSn)) {
  1754. $p = new printUtil($printSn);
  1755. $p->printMsg($content, $shop);
  1756. }
  1757. }
  1758. }
  1759. //云打印 ssh 20210709
  1760. public static function onlinePrint($orderInfo, $showPrice = 1)
  1761. {
  1762. if (getenv('YII_ENV') == 'production') {
  1763. //淮北花语集、丽子鲜花,客户线上下单不显示价格,门店开单显示价格
  1764. if ($orderInfo->shopId == 1527 || $orderInfo->mainId == 52291) {
  1765. if (!empty($orderInfo->customShopAdminId)) {
  1766. $showPrice = 0;
  1767. }
  1768. }
  1769. //源花汇小票不带价格
  1770. if (isset($orderInfo->mainId) && $orderInfo->mainId == 62382) {
  1771. $showPrice = 0;
  1772. }
  1773. //三明易批花非洲菊 不带价格
  1774. if (isset($orderInfo->mainId) && $orderInfo->mainId == 10536) {
  1775. $showPrice = 0;
  1776. }
  1777. //义乌我要花 不带价格
  1778. if (isset($orderInfo->mainId) && $orderInfo->mainId == 83694) {
  1779. $showPrice = 0;
  1780. }
  1781. //衡阳昕得鲜花批发,线上下单,不显示价格
  1782. if (isset($orderInfo->mainId) && $orderInfo->mainId == 85744) {
  1783. if (!empty($orderInfo->customShopAdminId)) {
  1784. $showPrice = 0;
  1785. }
  1786. }
  1787. //清流美朵花业线上下单不显示价格
  1788. if (isset($orderInfo->mainId) && $orderInfo->mainId == 99641) {
  1789. if (!empty($orderInfo->customShopAdminId)) {
  1790. $showPrice = 0;
  1791. }
  1792. }
  1793. //北京花篮子,线上下单,不显示价格
  1794. if (isset($orderInfo->mainId) && $orderInfo->mainId == 10735) {
  1795. if (!empty($orderInfo->customShopAdminId)) {
  1796. $showPrice = 0;
  1797. }
  1798. }
  1799. //美婷鲜花批发,线上下单,不显示价格
  1800. if (isset($orderInfo->mainId) && $orderInfo->mainId == 73125) {
  1801. if (!empty($orderInfo->customShopAdminId)) {
  1802. $showPrice = 0;
  1803. }
  1804. }
  1805. //淄博花超鲜花小票不带价格
  1806. if (isset($orderInfo->mainId) && $orderInfo->mainId == 16293) {
  1807. $showPrice = 0;
  1808. }
  1809. } else {
  1810. if (isset($orderInfo->mainId) && $orderInfo->mainId == 644) {
  1811. //$showPrice = 0;
  1812. }
  1813. }
  1814. if (isset($orderInfo['actPrice']) && $orderInfo['actPrice'] == 0 && $orderInfo['book'] == 0) {
  1815. //全额退款了,也要能打小票
  1816. //util::fail('已全额退款,不能打小票');
  1817. }
  1818. $showItem = OrderClass::getShowItem(true, $orderInfo);
  1819. $customId = $orderInfo['customId'] ?? 0;
  1820. $c = CustomClass::getById($customId);
  1821. $balance = $c['balance'] ?? 0.00;
  1822. $debtAmount = $balance < 0 ? abs($balance) : 0;
  1823. $orderSn = $orderInfo['orderSn'] ?? '';
  1824. $shopId = $orderInfo['shopId'] ?? 0;
  1825. $shop = ShopClass::getById($shopId, true);
  1826. if (empty($shop)) {
  1827. util::fail('打印失败,没有找到门店10');
  1828. }
  1829. $sjId = $shop->sjId ?? 0;
  1830. $fontSizeType = $shop->fontSize ?? 0;
  1831. $telephone = $shop->telephone ?? '';
  1832. $telephone2 = $shop->telephone2 ?? '';
  1833. $sj = SjClass::getById($sjId, true);
  1834. $sjName = $sj->name ?? '';
  1835. $shopName = $shop->shopName ?? '';
  1836. $currentName = $shopName == '首店' ? $sjName : $sjName . ' ' . $shopName;
  1837. $ext = ShopExtClass::getByCondition(['shopId' => $shopId], true);
  1838. $printSn = $ext->printSn ?? '';
  1839. /**************************如果是好多花的云仓还要再打一下标签纸,多处要同步修改,关键词 hdh_yc *****************************/
  1840. $orderMainId = $orderInfo['mainId'] ?? 0;
  1841. if (getenv('YII_ENV') == 'production') {
  1842. //东莞我要花不要自动打印标准,mainId=2644,已经去掉了
  1843. $map = [65726, 58, 25119, 28500, 1294, 12925, 83694];
  1844. } else {
  1845. $map = [828];
  1846. }
  1847. if (in_array($orderMainId, $map)) {
  1848. self::printLogisticsLabel($orderInfo, $shop, $ext);
  1849. }
  1850. /**************************如果是好多花的云仓还要再打一下标签纸,多处要同步修改,关键词 hdh_yc *****************************/
  1851. // $itemList = $showItem['list'] ?? [];
  1852. // if (count($itemList) > 40) {
  1853. // //超出数量的打印
  1854. // self::onlinePrintOver($showItem, $orderInfo, $currentName, $shop);
  1855. // return true;
  1856. // }
  1857. $fromType = $orderInfo['fromType'] ?? dict::getDict('fromType', 'shop');
  1858. $fromTypeMap = dict::getDict('fromTypeMap');
  1859. $fromTypeName = $fromTypeMap[$fromType] ?? '门店';
  1860. $content = "<CB>" . $currentName . "</CB>";
  1861. $content .= "<CB>销售单</CB><BR><BR>";
  1862. $respond = self::getPrintData($orderInfo, $debtAmount, $showItem);
  1863. $content .= '<B>' . $respond['sendNum'] . ' ' . $fromTypeName . '</B><BR>';
  1864. $content .= '--------------------------------<BR>';
  1865. //快捷开单不需要打印买家信息
  1866. if ($customId != $shop->skCustomId) {
  1867. $content .= '<B>买家信息:</B><BR><BR>';
  1868. $content .= '<B>' . $respond['custom']['customName'] . '</B><BR>';
  1869. if (isset($orderInfo->mainId) && $orderInfo->mainId == 62382) {
  1870. //三明易批花非洲菊,比较特殊,不要带客户手机号
  1871. $content .= '';
  1872. } else {
  1873. $content .= '<B>' . $respond['custom']['customMobile'] . '</B><BR>';
  1874. }
  1875. if (isset($orderInfo['address']) && !empty($orderInfo['address'])) {
  1876. $content .= $respond['custom']['fullAddress'];
  1877. if (isset($orderInfo['showAddress']) && !empty($orderInfo['showAddress']) && $orderInfo['showAddress'] != $respond['custom']['fullAddress']) {
  1878. $content .= '(' . $orderInfo['showAddress'] . ')<BR>';
  1879. } else {
  1880. $content .= '<BR>';
  1881. }
  1882. }
  1883. }
  1884. $payDate = date("Y-m-d", strtotime($orderInfo['payTime']));
  1885. $sendTimWant = $orderInfo['sendTimeWant'] ?? '';
  1886. if ($payDate != $sendTimWant) {
  1887. $content .= '<BR><BR>';
  1888. $content .= '********************************<BR>';
  1889. $content .= '<CB>注意! 送货时间</CB><BR>';
  1890. $content .= '<CB><BOLD>【' . $orderInfo['sendTimeWant'] . '】</BOLD></CB>';
  1891. $content .= '********************************<BR><BR><BR>';
  1892. }
  1893. if (isset($orderInfo['book']) && $orderInfo['book'] == 1) {
  1894. $content .= '<B>预订单</B><BR>';
  1895. }
  1896. if (isset($orderInfo['presell']) && $orderInfo['presell'] == 1) {
  1897. $content .= '<B>预售单</B><BR>';
  1898. }
  1899. if (isset($shop->pfLevel) && $shop->pfLevel == 1) {
  1900. if (isset($orderInfo['transType'])) {
  1901. $sendName = '同城配送';
  1902. if ($orderInfo['transType'] == 0) {
  1903. $sendName = '德邦物流';
  1904. }
  1905. if ($orderInfo['transType'] == 1) {
  1906. $sendName = '顺丰物流';
  1907. }
  1908. if ($orderInfo['transType'] == 2) {
  1909. $sendName = '冷链物流';
  1910. }
  1911. if ($orderInfo['transType'] == 3) {
  1912. $sendName = '航空物流';
  1913. }
  1914. if ($orderInfo['transType'] == 4) {
  1915. $sendName = '同城配送';
  1916. }
  1917. if ($orderInfo['transType'] == 5) {
  1918. $sendName = '到店自取';
  1919. }
  1920. $content .= '<BR><B>' . $sendName . '</B><BR>';
  1921. }
  1922. } else {
  1923. if (isset($orderInfo['sendType'])) {
  1924. $sendName = '送货上门';
  1925. if ($orderInfo['sendType'] == 1) {
  1926. $sendName = '到店自取';
  1927. }
  1928. if ($orderInfo['sendType'] == 2) {
  1929. $sendName = '跑腿送';
  1930. }
  1931. if ($orderInfo['sendType'] == 3) {
  1932. $wlName = $orderInfo['wlName'] ?? '未填物流';
  1933. $sendName = $wlName;
  1934. }
  1935. if ($orderInfo['sendType'] == 4) {
  1936. $sendName = '发快递';
  1937. }
  1938. $content .= '<BR><B>' . $sendName . '</B><BR>';
  1939. }
  1940. }
  1941. if (isset($respond['remark']) && !empty($respond['remark'])) {
  1942. $content .= '<BR>';
  1943. $content .= '备注:<BR>';
  1944. $content .= '<B>' . $respond['remark'] . '</B><BR>';
  1945. }
  1946. $content .= '<BR>';
  1947. $content .= '商品 数量/单价 金额 <BR>';
  1948. $content .= '--------------------------------<BR>';
  1949. if (isset($respond['product']) && !empty($respond['product'])) {
  1950. foreach ($respond['product'] as $current) {
  1951. $content = self::printGroup($current, $content, $showPrice, $fontSizeType);
  1952. }
  1953. }
  1954. if (isset($respond['give']) && !empty($respond['give'])) {
  1955. $content .= '<BR><CB>【赠送】</CB><BR>';
  1956. foreach ($respond['give'] as $current) {
  1957. //58mm的机器,一行打印16个汉字,32个字母
  1958. $name = $current['name'] ?? '';
  1959. $count = $current['count'] ?? '';
  1960. if ($fontSizeType == 1) {
  1961. $content .= '<L>' . $name . ' ' . $count . '</L><BR>';
  1962. } else {
  1963. $content .= '<B>' . $name . ' ' . $count . '</B><BR>';
  1964. }
  1965. $content .= '--------------------------------<BR>';
  1966. }
  1967. }
  1968. $kindNum = $showItem['itemStat']['kind'] ?? 0;
  1969. $bigNum = $showItem['itemStat']['bigNum'] ?? 0;
  1970. $smallNun = $showItem['itemStat']['smallNun'] ?? 0;
  1971. $content .= '********************************<BR>';
  1972. $content .= "<CB>共{$kindNum}种 ";
  1973. if ($bigNum > 0) {
  1974. $content .= "{$bigNum}扎";
  1975. }
  1976. if ($smallNun > 0) {
  1977. $content .= "{$smallNun}支";
  1978. }
  1979. $content .= "</CB>";
  1980. $content .= '********************************<BR><BR>';
  1981. if ($showPrice == 1) {
  1982. if (isset($orderInfo['itemPrice']) && $orderInfo['itemPrice'] > 0) {
  1983. $content .= '商品金额:' . floatval($orderInfo['itemPrice']) . '<BR>';
  1984. }
  1985. if (isset($respond['sendCost']) && $respond['sendCost'] > 0) {
  1986. $content .= '<B>跑腿费:' . floatval($respond['sendCost']) . '</B><BR>';
  1987. }
  1988. if (isset($orderInfo['packCost']) && $orderInfo['packCost'] > 0) {
  1989. $content .= ' 打包费:' . floatval($orderInfo['packCost']) . '<BR>';
  1990. }
  1991. $content .= '合计金额:' . floatval($respond['prePrice']) . '<BR>';
  1992. if (isset($respond['discountAmount']) && !empty($respond['discountAmount']) && $respond['discountAmount'] > 0) {
  1993. $content .= '优惠扣除:-' . floatval($respond['discountAmount']) . '<BR>';
  1994. }
  1995. if (isset($orderInfo['book']) && $orderInfo['book'] == 1) {
  1996. $content .= '预付金额:' . floatval($orderInfo['bookPrice']) . '<BR>';
  1997. }
  1998. if (isset($orderInfo['tkPrice']) && $orderInfo['tkPrice'] > 0) {
  1999. $content .= '退款金额:' . floatval($orderInfo['tkPrice']) . '<BR>';
  2000. }
  2001. $content .= '<B>金额:' . floatval($respond['realPrice']) . '</B><BR>';
  2002. if (isset($respond['debt']) && $respond['debt'] == 1) {
  2003. $content .= '实付金额:0<BR>';
  2004. } else {
  2005. $content .= '实付金额:' . floatval($respond['realPrice']) . '<BR>';
  2006. }
  2007. if ($debtAmount > 0) {
  2008. $content .= '累计待结:' . floatval($debtAmount) . '<BR>';
  2009. }
  2010. $content .= '--------------------------------<BR>';
  2011. }
  2012. $getInfo = self::getById($orderInfo['id']);
  2013. if (!empty($telephone)) {
  2014. $content .= '联系电话:' . $telephone . '<BR>';
  2015. }
  2016. if (!empty($telephone2)) {
  2017. $content .= '联系电话2:' . $telephone2 . '<BR>';
  2018. }
  2019. $content .= '订单日期:' . date("Y-m-d H:i", strtotime($getInfo['addTime'])) . '<BR>';
  2020. $content .= '订单编号:' . $respond['orderSn'] . '<BR>';
  2021. if (isset($orderInfo['shopAdminId']) && !empty($orderInfo['shopAdminId'])) {
  2022. $content .= '本单由员工(' . $orderInfo['shopAdminName'] . ')开单<BR>';
  2023. } else {
  2024. $content .= '本单由客户(' . $orderInfo['customShopAdminName'] . ')下单<BR>';
  2025. }
  2026. $content .= "<BR>";
  2027. if (getenv('YII_ENV') == 'production') {
  2028. //丽子鲜花、花样年华、镜中花卉、满天星、世纪花、盛丰、福清辉煌、美阁都不显示扫码买花
  2029. if (!in_array($orderInfo->shopId, [1527, 1585, 1596, 16454, 33668, 38492, 36596, 35389, 38322, 43274, 40312, 44556, 42946, 51758, 8391, 65591, 8596, 81437, 14248])) {
  2030. //勇记、国恋、花悠星零售开单不需要打印扫码买花
  2031. // if ($customId != 12145 || $customId != 12487 || $customId != 12281) {
  2032. // $content .= "<BR>";
  2033. // $content .= "<C>扫码买花结账</C>";
  2034. // $content .= "<BR>";
  2035. // $host = Yii::$app->params['hdHost'];
  2036. // $content .= "<QR>" . $host . "/#/admin/home/workbench</QR>";
  2037. // }
  2038. }
  2039. }
  2040. $content .= "<BR>";
  2041. $content .= "<BR>";
  2042. if (!empty($printSn)) {
  2043. $p = new printUtil($printSn);
  2044. // onlinePrint 每次打印均写入飞鹅打印日志缓存
  2045. $logMeta = [
  2046. 'writeLog' => true,
  2047. 'mainId' => intval($orderInfo['mainId'] ?? 0),
  2048. 'orderId' => intval($orderInfo['id'] ?? 0),
  2049. 'orderSn' => (string)$orderSn,
  2050. 'printSn' => (string)$printSn,
  2051. ];
  2052. $p->printMsg($content, $shop, $orderSn, $logMeta);
  2053. }
  2054. }
  2055. //打印数据 ssh 20210702
  2056. public static function getPrintData($val, $debtAmount, $showItem)
  2057. {
  2058. $giveList = [];
  2059. $printProduct = [];
  2060. if (isset($showItem['list']) && !empty($showItem['list'])) {
  2061. foreach ($showItem['list'] as $itemKey => $itemVal) {
  2062. $bigNum = $itemVal['bigNum'] ?? 0;
  2063. $bigUnitPrice = $itemVal['unitPrice'] ?? 0;
  2064. $smallUnitPrice = $itemVal['smallUnitPrice'] ?? 0;
  2065. $smallNum = $itemVal['smallNum'] ?? 0;
  2066. $giveNum = $itemVal['giveNum'] ?? 0;
  2067. $xhUnitName = $itemVal['xhUnitName'] ?? '扎';
  2068. $refundNum = $itemVal['refundNum'] ?? 0;
  2069. $remark = $itemVal['remark'] ?? '';
  2070. if ($bigNum > 0) {
  2071. $bigTotalPrice = bcmul($bigUnitPrice, $bigNum, 2);
  2072. $printProduct[] = [
  2073. 'name' => $itemVal['name'] ?? '',
  2074. 'num' => floatval($bigNum) . $xhUnitName . ' * ' . floatval($bigUnitPrice) . '元',
  2075. 'count' => floatval($bigNum) . $xhUnitName,
  2076. 'price' => floatval($bigTotalPrice),
  2077. 'unitPrice' => floatval($bigUnitPrice),
  2078. 'refundNum' => $refundNum,
  2079. 'unitName' => $xhUnitName,
  2080. 'itemNum' => $bigNum,
  2081. 'remark' => $remark,
  2082. 'ratioType' => $itemVal['ratioType'],
  2083. 'ratio' => $itemVal['ratio']
  2084. ];
  2085. }
  2086. if ($smallNum > 0) {
  2087. $smallTotalPrice = bcmul($smallUnitPrice, $smallNum, 2);
  2088. $printProduct[] = [
  2089. 'name' => $itemVal['name'] ?? '',
  2090. 'num' => floatval($smallNum) . '支 * ' . floatval($smallUnitPrice) . '元',
  2091. 'count' => floatval($smallNum) . '支',
  2092. 'price' => floatval($smallTotalPrice),
  2093. 'unitPrice' => floatval($smallUnitPrice),
  2094. 'refundNum' => $refundNum,
  2095. 'unitName' => '支',
  2096. 'itemNum' => $smallNum,
  2097. 'remark' => $remark,
  2098. ];
  2099. }
  2100. if ($giveNum > 0) {
  2101. $giveList[] = [
  2102. 'name' => $itemVal['name'] ?? '',
  2103. 'num' => floatval($giveNum) . $xhUnitName . ' * 0元',
  2104. 'count' => floatval($giveNum) . $xhUnitName,
  2105. 'price' => 0,
  2106. 'unitPrice' => 0,
  2107. 'unitName' => $xhUnitName,
  2108. 'itemNum' => $giveNum,
  2109. 'remark' => $remark,
  2110. ];
  2111. }
  2112. }
  2113. }
  2114. $sendNum = $val['sendNum'] ?? '';
  2115. $relateOrderSn = $val['orderSn'] ?? '';
  2116. $refundList = [];
  2117. $refundData = RefundOrderClass::getAllByCondition(['relateOrderSn' => $relateOrderSn], null, '*', null, true);
  2118. if (!empty($refundData)) {
  2119. foreach ($refundData as $refund) {
  2120. $refundOrderSn = $refund->orderSn ?? '';
  2121. $refundProductList = RefundOrderItemClass::getAllByCondition(['orderSn' => $refundOrderSn], null, '*');
  2122. if (!empty($refundProductList)) {
  2123. foreach ($refundProductList as $currentRefund) {
  2124. $num = $currentRefund['xhNum'] ?? 0;
  2125. $unitName = $currentRefund['xhUnitName'] ?? '';
  2126. $unitPrice = $currentRefund['xhUnitPrice'] ?? 0;
  2127. $currentPrice = bcmul($unitPrice, $num, 2);
  2128. $refundList[] = [
  2129. 'name' => $currentRefund['name'] ?? '',
  2130. 'num' => floatval($num) . $unitName . '*' . floatval($unitPrice),
  2131. 'count' => floatval($num) . $unitName,
  2132. 'price' => floatval($currentPrice),
  2133. ];
  2134. }
  2135. }
  2136. }
  2137. }
  2138. $printData = [
  2139. 'address' => '',
  2140. 'sendCost' => $val['sendCost'] ?? '0.00',
  2141. 'prePrice' => $val['prePrice'] ?? '0.00',
  2142. 'discountAmount' => $val['discountAmount'] ?? '0.00',
  2143. 'realPrice' => $val['realPrice'] ?? '0.00',
  2144. 'refundPrice' => $val['refundPrice'] ?? '0.00',
  2145. 'debt' => $val['debt'] ?? 0,
  2146. 'orderSn' => $val['orderSn'] ?? '',
  2147. 'date' => $val['addTime'] ?? '',
  2148. 'remark' => $val['remark'] ?? '',
  2149. 'custom' => [
  2150. 'customName' => $val['customName'] ?? '',
  2151. 'customMobile' => $val['customMobile'] ?? '',
  2152. 'fullAddress' => $val['fullAddress'] ?? '',
  2153. ],
  2154. 'product' => $printProduct,
  2155. 'refund' => $refundList,
  2156. 'sendNum' => $sendNum,
  2157. 'debtAmount' => $debtAmount,
  2158. 'give' => $giveList,
  2159. ];
  2160. return $printData;
  2161. }
  2162. //订单的验证 ssh 2021.3.2
  2163. public static function valid($info, $shopId)
  2164. {
  2165. if (empty($info)) {
  2166. util::fail('没有找到订单');
  2167. }
  2168. if (isset($info['shopId']) && $info['shopId'] == $shopId) {
  2169. return true;
  2170. }
  2171. util::fail('无法操作的订单');
  2172. }
  2173. //快递送 ssh 2021.3.16
  2174. public static function thirdSend($order, $expressInfo)
  2175. {
  2176. if ($order->status == self::ORDER_STATUS_UN_PAY) {
  2177. util::fail('订单未付款');
  2178. }
  2179. if ($order->status != self::ORDER_STATUS_UN_SEND) {
  2180. util::fail('不是待配送状态');
  2181. }
  2182. $id = $order->id;
  2183. $expressId = $expressInfo['expressId'] ?? 1;
  2184. $expressName = $expressInfo['deliveryName'] ?? '达达';
  2185. $expressRemark = $expressInfo['remark'] ?? '';
  2186. $order->status = self::ORDER_STATUS_SENDING;
  2187. $order->sendType = self::SEND_TYPE_THIRD;
  2188. $order->expressId = $expressId;
  2189. $order->save();
  2190. $shopId = $order->shopId;
  2191. $shop = Shop::findBySql('select * from ' . Shop::tableName() . ' where id = :id for update', ['id' => $shopId])->one();
  2192. if (empty($shop)) {
  2193. util::fail('没有找到门店11');
  2194. }
  2195. $shop->unSendOrder -= 1;
  2196. $shop->sendingOrder += 1;
  2197. $shop->save();
  2198. $express = OrderExpressClass::getByCondition(['orderId' => $id]);
  2199. if (!empty($express)) {
  2200. util::fail('已经发过了');
  2201. }
  2202. //达达
  2203. $dadaRes = DadaExpressServices::addOrder($order, $expressRemark);
  2204. $orderSn = $order->orderSn;
  2205. $sjId = $order->sjId ?? 0;
  2206. /*
  2207. $getInfo = ExpressClass::getExpressInfo($expressId);
  2208. $hour = $expressInfo['sendTime'] ?? '12:00';
  2209. $sendCost = 12;
  2210. $distance = 5;
  2211. $sendTime = strtotime(date("Y-m-d ") . $hour);
  2212. OrderSendClass::thirdSend($order);
  2213. */
  2214. $sendTime = $order->sendTime;
  2215. if ($sendTime == '0000-00-00 00:00:00') {
  2216. $sendTime = time();
  2217. } else {
  2218. $sendTime = strtotime($order->sendTime);
  2219. }
  2220. $expData = [
  2221. 'orderId' => $id,
  2222. 'orderSn' => $orderSn,
  2223. 'sjId' => $sjId,
  2224. 'expressId' => $expressId,
  2225. 'sendTime' => $sendTime,
  2226. 'cost' => $dadaRes['fee'],
  2227. 'distance' => $dadaRes['distance'],
  2228. 'status' => 1,
  2229. 'expressName' => $expressName,
  2230. 'remark' => $expressRemark,
  2231. ];
  2232. OrderExpressClass::addExpress($expData);
  2233. OrderSendClass::thirdSend($order);
  2234. $respond = [
  2235. 'expressName' => $expressName,
  2236. 'expressId' => $expressId,
  2237. 'distance' => $dadaRes['distance'],
  2238. 'cost' => $dadaRes['fee'],
  2239. 'status' => 2,
  2240. 'tip' => 0,
  2241. ];
  2242. //采购单变成已发货
  2243. $purchaseId = $order->purchaseId ?? 0;
  2244. PurchaseClass::sending($purchaseId);
  2245. return $respond;
  2246. }
  2247. //本店送 ssh 2021.1.24
  2248. public static function selfSend($info)
  2249. {
  2250. if ($info->status == self::ORDER_STATUS_UN_PAY) {
  2251. util::fail('订单未付款');
  2252. }
  2253. if ($info->status != self::ORDER_STATUS_UN_SEND) {
  2254. util::fail('不是待配送状态');
  2255. }
  2256. $info->status = self::ORDER_STATUS_SENDING;
  2257. $info->sendType = self::SEND_TYPE_MYSELF;
  2258. $info->save();
  2259. $shopId = $info->shopId;
  2260. $shop = Shop::findBySql('select * from ' . Shop::tableName() . ' where id = :id for update', ['id' => $shopId])->one();
  2261. if (empty($shop)) {
  2262. util::fail('没有找到门店12');
  2263. }
  2264. $shop->unSendOrder -= 1;
  2265. $shop->sendingOrder += 1;
  2266. $shop->save();
  2267. OrderSendClass::selfSend($info);
  2268. //采购单变成已发货
  2269. $purchaseId = $info->purchaseId ?? 0;
  2270. PurchaseClass::sending($purchaseId);
  2271. }
  2272. //订单完成 ssh 2020.3.12
  2273. public static function complete($order, $shop)
  2274. {
  2275. $order->status = OrderClass::ORDER_STATUS_COMPLETE;
  2276. $order->currentFlow = self::TOTAL_FLOW;
  2277. $order->totalFlow = self::TOTAL_FLOW;
  2278. $order->save();
  2279. $shop->finishOrder += 1;
  2280. $shop->sendingOrder -= 1;
  2281. $shop->save();
  2282. return $order;
  2283. }
  2284. //修改订单表的配送信息 lqh 2021.3.28
  2285. public static function updateCustomExpressInfo($id, $expressAddInfo)
  2286. {
  2287. $data = [
  2288. 'province' => $expressAddInfo['province'],
  2289. 'city' => $expressAddInfo['city'],
  2290. 'address' => $expressAddInfo['address'],
  2291. 'floor' => $expressAddInfo['floor'],
  2292. 'fullAddress' => $expressAddInfo['city'] . $expressAddInfo['address'] . $expressAddInfo['floor'],
  2293. 'lat' => $expressAddInfo['lat'],
  2294. 'long' => $expressAddInfo['long'],
  2295. 'sendTime' => $expressAddInfo['sendTime'],
  2296. ];
  2297. return self::updateById($id, $data);
  2298. }
  2299. //最客户最近的订单 ssh 2021.5.4
  2300. public static function getCustomOrder($id, $limit = 10, $order = null, $with = null)
  2301. {
  2302. $where = ['customId' => $id, 'payStatus' => 1];
  2303. return self::getLimitList('*', $where, $limit, $order, $with);
  2304. }
  2305. //销售单取消 ssh 2021.5.14
  2306. public static function cancel($id)
  2307. {
  2308. $order = self::getLockById($id);
  2309. if ($order->status != OrderClass::ORDER_STATUS_UN_PAY) {
  2310. util::fail("销售单{$id}不是待付款状态,无法取消");
  2311. }
  2312. $order->status = self::ORDER_STATUS_CANCEL;
  2313. $order->cancelTime = date("Y-m-d H:i:s");
  2314. $order->save();
  2315. $shopId = $order->shopId;
  2316. $shop = ShopClass::getLockById($shopId);
  2317. if (empty($shop)) {
  2318. util::fail('没有找到门店13');
  2319. }
  2320. $mainId = $shop->mainId ?? 0;
  2321. $main = MainClass::getLockById($mainId);
  2322. if (empty($main)) {
  2323. util::fail('没有main信息6');
  2324. }
  2325. $main->unPayOrder -= 1;
  2326. $main->cancelOrder += 1;
  2327. $main->save();
  2328. if ($order->book != 1) {
  2329. //非预订单库存回滚
  2330. $orderItem = OrderItemClass::getOrderItem($order->orderSn);
  2331. foreach ($orderItem as $v) {
  2332. $stockInfo = ProductClass::addStockByItemNum($v['productId'], $v['num']);
  2333. ProductClass::tryRecoverLimitBuyWhenStockRollbackFromZero($v['productId'], $stockInfo['oldStock']);
  2334. $recordData = [];
  2335. $recordData['sjId'] = $order->sjId;
  2336. $recordData['shopId'] = $shopId;
  2337. //增加中央ID
  2338. $recordData['mainId'] = ProductClass::getMainIdByProductId($v['productId']);
  2339. $recordData['itemId'] = $v['itemId'] ?? 0;
  2340. $recordData['itemNum'] = $v['num'];
  2341. $recordData['oldStock'] = $stockInfo['oldStock'];
  2342. $recordData['newStock'] = $stockInfo['newStock'];
  2343. $recordData['productId'] = $v['productId'];
  2344. $recordData['orderSn'] = $order->orderSn;
  2345. $recordData['relateName'] = $order->customName ?? '';
  2346. $recordData['ptStyle'] = dict::getDict('ptStyle', 'ghs');
  2347. StockRecordClass::addSellStockOrderCancelRecord($recordData);
  2348. //如果有限购数量占用,也需要清除
  2349. $customId = $order->customId ?? 0;
  2350. $num = floor($v['num']);
  2351. if (!empty($customId) && $num > 0) {
  2352. ProductClass::baseClearLimitBuy($v['productId'], $customId, $num);
  2353. }
  2354. }
  2355. }
  2356. return $order;
  2357. }
  2358. //新订单入队列 ssh 20211012
  2359. public static function newOrderAddQueue($order)
  2360. {
  2361. $shopId = $order->shopId ?? 0;
  2362. if (empty($shopId)) {
  2363. return false;
  2364. }
  2365. $id = $order->id ?? 0;
  2366. if (empty($id)) {
  2367. return false;
  2368. }
  2369. $newOrderKey = 'ghsNewOrder_' . $shopId;
  2370. Yii::$app->redis->executeCommand('LPUSH', [$newOrderKey, $id]);
  2371. }
  2372. public static function createImgOrder($order, $shop, $staff, $all)
  2373. {
  2374. $staffName = $order->shopAdminName ?? '';
  2375. $shopName = $shop->shopName ?? '';
  2376. $sjName = $shop->merchantName ?? '';
  2377. $fullSjName = $shopName == '首店' ? $sjName : $sjName . ' ' . $shopName;
  2378. $customName = $order->customName ?? '';
  2379. $customId = $order->customId ?? 0;
  2380. $custom = CustomClass::getById($customId, true);
  2381. $debtAmount = $custom->debtAmount ?? 0;
  2382. $mainId = $order->mainId ?? 0;
  2383. $dir = Yii::getAlias('@app/web/html/' . $mainId . '/');
  2384. if (!file_exists($dir)) {
  2385. //检查是否有该文件夹,如果没有就创建,并给予最高权限
  2386. mkdir($dir, 0700, true);
  2387. }
  2388. $payTime = $order->payTime ?? '';
  2389. $currentDate = date("Y-m-d", strtotime($payTime));
  2390. $sameTimeIds = $order->sameTimeIds;
  2391. $sameIds = [];
  2392. if (!empty($sameTimeIds)) {
  2393. $sameIds = explode(',', $sameTimeIds);
  2394. }
  2395. $sameNum = count($sameIds);
  2396. if ($all == 1 && $sameNum > 1) {
  2397. $orderList = OrderClass::getAllByCondition(['id' => ['in', $sameIds]], null, '*');
  2398. if (empty($orderList)) {
  2399. return ['imgFile' => ''];
  2400. }
  2401. $itemList = [];
  2402. $remainDebtPrice = 0;
  2403. $actPrice = 0;
  2404. $tkPrice = 0;
  2405. foreach ($orderList as $currentOrder) {
  2406. $orderSn = $currentOrder['orderSn'] ?? '';
  2407. $remainDebtPrice = bcadd($currentOrder['remainDebtPrice'], $remainDebtPrice, 2);
  2408. $actPrice = bcadd($currentOrder['actPrice'], $actPrice, 2);
  2409. $tkPrice = bcadd($tkPrice, $currentOrder['tkPrice'], 2);
  2410. $itemData = OrderItemClass::getAllByCondition(['orderSn' => $orderSn], 'id asc', '*', null);
  2411. if (!empty($itemData)) {
  2412. foreach ($itemData as $singleItem) {
  2413. $productId = $singleItem['productId'] ?? 0;
  2414. $unitPrice = $singleItem['xhUnitPrice'] ?? 0;
  2415. $unitPrice = floatval($unitPrice);
  2416. $xhNum = $singleItem['xhNum'] ?? 0;
  2417. $refundNum = $singleItem['refundNum'] ?? 0;
  2418. if (isset($itemList[$productId . '_' . $unitPrice])) {
  2419. $currentInfo = $itemList[$productId . '_' . $unitPrice];
  2420. $thisNum = bcadd($currentInfo['xhNum'], $xhNum);
  2421. $thisRefundNum = bcadd($currentInfo['refundNum'], $refundNum);
  2422. $itemList[$productId . '_' . $unitPrice]['xhNum'] = $thisNum;
  2423. $itemList[$productId . '_' . $unitPrice]['refundNum'] = $thisRefundNum;
  2424. } else {
  2425. $itemList[$productId . '_' . $unitPrice] = $singleItem;
  2426. }
  2427. }
  2428. }
  2429. }
  2430. $itemList = array_values($itemList);
  2431. $beforeDebtPrice = bcsub($debtAmount, $remainDebtPrice, 2);
  2432. $tkString = '';
  2433. if ($tkPrice > 0) {
  2434. $tkString = "<span style='margin-right:15px;'>已退款:{$tkPrice}</span>";
  2435. }
  2436. } else {
  2437. $orderSn = $order->orderSn ?? '';
  2438. $remainDebtPrice = $order->remainDebtPrice ?? 0;
  2439. $beforeDebtPrice = bcsub($debtAmount, $remainDebtPrice, 2);
  2440. $actPrice = $order->actPrice ?? 0;
  2441. $tkPrice = $order->tkPrice ?? 0;
  2442. $tkString = '';
  2443. if ($tkPrice > 0) {
  2444. $tkString = "<span style='margin-right:15px;'>已退款:{$tkPrice}</span>";
  2445. }
  2446. $itemList = OrderItemClass::getAllByCondition(['orderSn' => $orderSn], 'id asc', '*', null);
  2447. }
  2448. if (empty($itemList)) {
  2449. return ['imgFile' => ''];
  2450. }
  2451. $balance = $custom->balance ?? 0;
  2452. $balanceContent = '';
  2453. if ($balance > 0 && $balance > $debtAmount) {
  2454. if ($debtAmount > 0 && $balance > $debtAmount) {
  2455. $remainBalance = bcsub($balance, $debtAmount, 2);
  2456. $balanceContent = '<span style="margin-right:15px;">余额:' . $balance . ',最终余额:' . $remainBalance . '</span>';
  2457. } else {
  2458. $balanceContent = '<span style="margin-right:15px;">余额:' . $balance . '</span>';
  2459. }
  2460. }
  2461. if ($debtAmount >= $balance) {
  2462. $debtAmount = bcsub($debtAmount, $balance, 2);
  2463. }
  2464. if ($beforeDebtPrice >= $balance) {
  2465. $beforeDebtPrice = bcsub($beforeDebtPrice, $balance, 2);
  2466. }
  2467. $totalNum = 0;
  2468. $totalAmount = 0;
  2469. foreach ($itemList as $item) {
  2470. $xhNum = $item['xhNum'] ?? 0;
  2471. $refundNum = $item['refundNum'] ?? 0;
  2472. $realNum = bcsub($xhNum, $refundNum);
  2473. $unitPrice = $item['xhUnitPrice'] ?? 0;
  2474. $amount = bcmul($realNum, $unitPrice, 2);
  2475. $totalNum = bcadd($totalNum, $realNum);
  2476. $totalAmount = bcadd($totalAmount, $amount, 2);
  2477. }
  2478. $totalAmount = floatval($totalAmount);
  2479. $itemList[] = ['xhNum' => $totalNum, 'totalAmount' => $totalAmount,];
  2480. $content = <<<XL
  2481. <html>
  2482. <head>
  2483. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  2484. </head>
  2485. <body>
  2486. XL;
  2487. $total = count($itemList);
  2488. $pageSize = 14;
  2489. $totalPage = ceil($total / $pageSize);
  2490. for ($page = 1; $page <= $totalPage; $page++) {
  2491. $start = ($page - 1) * $pageSize;
  2492. $currentList = array_slice($itemList, $start, $pageSize);
  2493. if (!empty($currentList)) {
  2494. $tableList = '';
  2495. foreach ($currentList as $key => $item) {
  2496. $index = bcadd($key, $start);
  2497. $index++;
  2498. $name = $item['name'] ?? '';
  2499. $num = $item['xhNum'];
  2500. $refundNum = $item['refundNum'] ?? 0;
  2501. $realNum = bcsub($num, $refundNum);
  2502. $bigUnit = $item['xhUnitName'] ?? '';
  2503. $unitPrice = $item['xhUnitPrice'] ?? 0;
  2504. $unitPrice = floatval($unitPrice);
  2505. $amount = bcmul($realNum, $unitPrice, 2);
  2506. $amount = floatval($amount);
  2507. if ($name == '') {
  2508. $index = '合计';
  2509. $amount = $item['totalAmount'] ?? 0;
  2510. }
  2511. $remark = $item['remark'] ?? '';
  2512. $tableList .= "<tr>";
  2513. $tableList .= "<td>{$index}</td>";
  2514. $tableList .= "<td>{$name}</td>";
  2515. $tableList .= "<td>{$realNum}</td>";
  2516. $tableList .= "<td>{$bigUnit}</td>";
  2517. $tableList .= "<td>{$unitPrice}</td>";
  2518. $tableList .= "<td>{$amount}</td>";
  2519. $tableList .= "<td>{$remark}</td>";
  2520. $tableList .= "</tr>";
  2521. }
  2522. $content .= <<<XL
  2523. <div style="width:760px;height:4px;background-color:black;margin-bottom:10px;"></div>
  2524. <div style="width:750px;text-align:center;font-weight:bold;margin-bottom:20px;font-size:18px;">
  2525. <div>{$fullSjName}</div>
  2526. <div style="margin-top:5px;">销售单</div>
  2527. </div>
  2528. <div style="width:750px;">
  2529. <span>单据日期:{$currentDate}</span>
  2530. <span style="margin-left:80px;">开单:{$staffName}</span>
  2531. <span style="margin-left:80px;">客户:{$customName}</span>
  2532. <span style="float:right;">编号:{$orderSn}</span>
  2533. <div>
  2534. <table border="1" style="border: 1px solid black;border-collapse:collapse;text-align:center;font-size:14px;width:750px;margin-top:5px;">
  2535. <tr style="font-weight:bold;">
  2536. <td style="width:70px;">编号</td>
  2537. <td style="width:200px;">名称</td>
  2538. <td style="width:70px;">数量</td>
  2539. <td style="width:70px;">单位</td>
  2540. <td style="width:70px;">单价</td>
  2541. <td style="width:90px;">金额</td>
  2542. <td style="width:160px;">备注</td>
  2543. </tr>
  2544. {$tableList}
  2545. </table>
  2546. <div style="margin-top:5px;margin-bottom:20px;">
  2547. {$tkString}
  2548. <span style="margin-right:15px;">本单:{$actPrice}</span>
  2549. <span style="margin-right:15px;">上次欠款:{$beforeDebtPrice}</span>
  2550. <span style="margin-right:15px;">待付欠款:{$debtAmount}</span>
  2551. {$balanceContent}
  2552. </div>
  2553. <div style="margin-top:5px;margin-bottom:20px;">
  2554. <span style="margin-right:15px;color:red;font-weight:bold;font-size:20px;">请在收到货后12小时以内验货,超12小时概不负责!</span>
  2555. </div>
  2556. XL;
  2557. }
  2558. }
  2559. $content .= <<<XL
  2560. </body>
  2561. <style>
  2562. body{
  2563. font-size:14px;
  2564. }
  2565. td{
  2566. padding:4px;
  2567. }
  2568. </style>
  2569. </html>
  2570. XL;
  2571. $file = $dir . $orderSn . '.html';
  2572. $imgFile = $dir . $orderSn . '.png';
  2573. if (file_exists($file)) {
  2574. unlink($file);
  2575. }
  2576. if (file_exists($imgFile)) {
  2577. unlink($imgFile);
  2578. }
  2579. file_put_contents($file, $content);
  2580. $con = new Converter(null, [
  2581. "fmt" => "png",
  2582. "in" => $file,
  2583. "out" => $imgFile,
  2584. ]);
  2585. $con->convert();
  2586. return ['imgFile' => $imgFile];
  2587. }
  2588. //应收统计下载 ssh 20240530
  2589. public static function exportAccountList($list, $mainId)
  2590. {
  2591. $phpExcelFile = Yii::getAlias("@vendor/phpoffice/phpexcel/");
  2592. require_once($phpExcelFile . 'Classes/PHPExcel.php');
  2593. $objPHPExcel = new \PHPExcel();
  2594. $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
  2595. ->setLastModifiedBy("Maarten Balliauw")
  2596. ->setTitle("Office 2007 XLSX Document")
  2597. ->setSubject("Office 2007 XLSX Document")
  2598. ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
  2599. ->setKeywords("office 2007 openxml php")
  2600. ->setCategory("file");
  2601. $ghsTitle = '供货商';
  2602. $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader(date('n月j日') . " " . $ghsTitle);
  2603. $objPHPExcel->getActiveSheet()->getPageMargins()->setTop(0.7);
  2604. $objPHPExcel->getActiveSheet()->getPageMargins()->setBottom(0.1);
  2605. $objPHPExcel->getActiveSheet()->getPageMargins()->setLeft(0.5);
  2606. $objPHPExcel->getActiveSheet()->getPageMargins()->setRight(0);
  2607. $objPHPExcel->getActiveSheet()->getPageMargins()->setHeader(0.1);
  2608. $objPHPExcel->getActiveSheet()->getPageMargins()->setFooter(0);
  2609. $objPHPExcel->getActiveSheet()->setCellValue('A1', 'ID');
  2610. $objPHPExcel->getActiveSheet()->setCellValue('B1', '名称');
  2611. $objPHPExcel->getActiveSheet()->setCellValue('C1', '金额');
  2612. $objPHPExcel->getActiveSheet()->setCellValue('D1', '订单数');
  2613. //设置宽度
  2614. $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(25);
  2615. $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
  2616. $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
  2617. //加粗
  2618. $objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(9)->setBold(true);
  2619. $objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setSize(9)->setBold(true);
  2620. $objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setSize(9)->setBold(true);
  2621. $objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setSize(9)->setBold(true);
  2622. $objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2623. $objPHPExcel->getActiveSheet()->getStyle('B1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2624. $objPHPExcel->getActiveSheet()->getStyle('C1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2625. $objPHPExcel->getActiveSheet()->getStyle('D1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2626. $baseRow = 2;
  2627. foreach ($list as $key => $custom) {
  2628. $i = $baseRow + $key;
  2629. $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $custom['id']);
  2630. $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, $custom['name']);
  2631. $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, $custom['amount']);
  2632. $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, $custom['num']);
  2633. //居左
  2634. $objPHPExcel->getActiveSheet()->getStyle('A' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2635. $objPHPExcel->getActiveSheet()->getStyle('B' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2636. $objPHPExcel->getActiveSheet()->getStyle('C' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2637. $objPHPExcel->getActiveSheet()->getStyle('D' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2638. }
  2639. $fileName = '应收统计-' . date("m-d");
  2640. $objPHPExcel->getActiveSheet()->setTitle($fileName);
  2641. $objPHPExcel->setActiveSheetIndex(0);
  2642. $dir = './priceTable/' . $mainId;
  2643. if (file_exists($dir) == false) {
  2644. mkdir($dir, 0777, true);
  2645. }
  2646. $date = $fileName;
  2647. $file = $date . '.xls';
  2648. $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
  2649. if (file_exists($dir . '/' . $file)) {
  2650. unlink($dir . '/' . $file);
  2651. }
  2652. $objWriter->save($dir . '/' . $file);
  2653. $fileUrl = Yii::$app->params['ghsHost'] . '/priceTable/' . $mainId . '/' . $file;
  2654. util::success(['file' => $fileUrl, 'shortFile' => $file]);
  2655. }
  2656. //应收统计下载 ssh 20240530
  2657. public static function exportPastList($list, $mainId)
  2658. {
  2659. $phpExcelFile = Yii::getAlias("@vendor/phpoffice/phpexcel/");
  2660. require_once($phpExcelFile . 'Classes/PHPExcel.php');
  2661. $objPHPExcel = new \PHPExcel();
  2662. $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
  2663. ->setLastModifiedBy("Maarten Balliauw")
  2664. ->setTitle("Office 2007 XLSX Document")
  2665. ->setSubject("Office 2007 XLSX Document")
  2666. ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
  2667. ->setKeywords("office 2007 openxml php")
  2668. ->setCategory("file");
  2669. $ghsTitle = '供货商';
  2670. $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader(date('n月j日') . " " . $ghsTitle);
  2671. $objPHPExcel->getActiveSheet()->getPageMargins()->setTop(0.7);
  2672. $objPHPExcel->getActiveSheet()->getPageMargins()->setBottom(0.1);
  2673. $objPHPExcel->getActiveSheet()->getPageMargins()->setLeft(0.5);
  2674. $objPHPExcel->getActiveSheet()->getPageMargins()->setRight(0);
  2675. $objPHPExcel->getActiveSheet()->getPageMargins()->setHeader(0.1);
  2676. $objPHPExcel->getActiveSheet()->getPageMargins()->setFooter(0);
  2677. $objPHPExcel->getActiveSheet()->setCellValue('A1', 'ID');
  2678. $objPHPExcel->getActiveSheet()->setCellValue('B1', '客户');
  2679. $objPHPExcel->getActiveSheet()->setCellValue('C1', '手机号');
  2680. $objPHPExcel->getActiveSheet()->setCellValue('D1', '欠款金额');
  2681. //设置宽度
  2682. $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(25);
  2683. $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
  2684. $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
  2685. //加粗
  2686. $objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(9)->setBold(true);
  2687. $objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setSize(9)->setBold(true);
  2688. $objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setSize(9)->setBold(true);
  2689. $objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setSize(9)->setBold(true);
  2690. $objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2691. $objPHPExcel->getActiveSheet()->getStyle('B1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2692. $objPHPExcel->getActiveSheet()->getStyle('C1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2693. $objPHPExcel->getActiveSheet()->getStyle('D1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2694. $baseRow = 2;
  2695. foreach ($list as $key => $custom) {
  2696. $i = $baseRow + $key;
  2697. $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $custom['id']);
  2698. $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, $custom['name']);
  2699. $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, $custom['mobile']);
  2700. $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, $custom['currentDebAmount']);
  2701. //居左
  2702. $objPHPExcel->getActiveSheet()->getStyle('A' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2703. $objPHPExcel->getActiveSheet()->getStyle('B' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2704. $objPHPExcel->getActiveSheet()->getStyle('C' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2705. $objPHPExcel->getActiveSheet()->getStyle('D' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2706. }
  2707. $fileName = '历史应收-' . date("m-d");
  2708. $objPHPExcel->getActiveSheet()->setTitle($fileName);
  2709. $objPHPExcel->setActiveSheetIndex(0);
  2710. $dir = './priceTable/' . $mainId;
  2711. if (file_exists($dir) == false) {
  2712. mkdir($dir, 0777, true);
  2713. }
  2714. $date = $fileName;
  2715. $file = $date . '.xls';
  2716. $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
  2717. if (file_exists($dir . '/' . $file)) {
  2718. unlink($dir . '/' . $file);
  2719. }
  2720. $objWriter->save($dir . '/' . $file);
  2721. $fileUrl = Yii::$app->params['ghsHost'] . '/priceTable/' . $mainId . '/' . $file;
  2722. util::success(['file' => $fileUrl, 'shortFile' => $file]);
  2723. }
  2724. public static function exportYj($list, $mainId)
  2725. {
  2726. $phpExcelFile = Yii::getAlias("@vendor/phpoffice/phpexcel/");
  2727. require_once($phpExcelFile . 'Classes/PHPExcel.php');
  2728. $objPHPExcel = new \PHPExcel();
  2729. $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
  2730. ->setLastModifiedBy("Maarten Balliauw")
  2731. ->setTitle("Office 2007 XLSX Document")
  2732. ->setSubject("Office 2007 XLSX Document")
  2733. ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
  2734. ->setKeywords("office 2007 openxml php")
  2735. ->setCategory("file");
  2736. $ghsTitle = '供货商';
  2737. $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader(date('n月j日') . " " . $ghsTitle);
  2738. $objPHPExcel->getActiveSheet()->getPageMargins()->setTop(0.7);
  2739. $objPHPExcel->getActiveSheet()->getPageMargins()->setBottom(0.1);
  2740. $objPHPExcel->getActiveSheet()->getPageMargins()->setLeft(0.5);
  2741. $objPHPExcel->getActiveSheet()->getPageMargins()->setRight(0);
  2742. $objPHPExcel->getActiveSheet()->getPageMargins()->setHeader(0.1);
  2743. $objPHPExcel->getActiveSheet()->getPageMargins()->setFooter(0);
  2744. $objPHPExcel->getActiveSheet()->setCellValue('A1', 'ID');
  2745. $objPHPExcel->getActiveSheet()->setCellValue('B1', '客户');
  2746. $objPHPExcel->getActiveSheet()->setCellValue('C1', '手机号');
  2747. $objPHPExcel->getActiveSheet()->setCellValue('D1', '订单数');
  2748. $objPHPExcel->getActiveSheet()->setCellValue('E1', '订单金额');
  2749. $objPHPExcel->getActiveSheet()->setCellValue('F1', '退款金额');
  2750. $objPHPExcel->getActiveSheet()->setCellValue('G1', '实际金额');
  2751. $objPHPExcel->getActiveSheet()->setCellValue('H1', '纸箱费');
  2752. $objPHPExcel->getActiveSheet()->setCellValue('I1', '打包费');
  2753. $objPHPExcel->getActiveSheet()->setCellValue('J1', '运费');
  2754. //设置宽度
  2755. $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
  2756. $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
  2757. //加粗
  2758. $objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(9)->setBold(true);
  2759. $objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setSize(9)->setBold(true);
  2760. $objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setSize(9)->setBold(true);
  2761. $objPHPExcel->getActiveSheet()->getStyle('D1')->getFont()->setSize(9)->setBold(true);
  2762. $objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setSize(9)->setBold(true);
  2763. $objPHPExcel->getActiveSheet()->getStyle('F1')->getFont()->setSize(9)->setBold(true);
  2764. $objPHPExcel->getActiveSheet()->getStyle('G1')->getFont()->setSize(9)->setBold(true);
  2765. $objPHPExcel->getActiveSheet()->getStyle('H1')->getFont()->setSize(9)->setBold(true);
  2766. $objPHPExcel->getActiveSheet()->getStyle('I1')->getFont()->setSize(9)->setBold(true);
  2767. $objPHPExcel->getActiveSheet()->getStyle('J1')->getFont()->setSize(9)->setBold(true);
  2768. $objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2769. $objPHPExcel->getActiveSheet()->getStyle('B1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2770. $objPHPExcel->getActiveSheet()->getStyle('C1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2771. $objPHPExcel->getActiveSheet()->getStyle('D1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2772. $objPHPExcel->getActiveSheet()->getStyle('E1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2773. $objPHPExcel->getActiveSheet()->getStyle('F1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2774. $objPHPExcel->getActiveSheet()->getStyle('G1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2775. $objPHPExcel->getActiveSheet()->getStyle('H1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2776. $objPHPExcel->getActiveSheet()->getStyle('I1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2777. $objPHPExcel->getActiveSheet()->getStyle('J1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2778. $baseRow = 2;
  2779. foreach ($list as $key => $custom) {
  2780. $i = $baseRow + $key;
  2781. $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $custom['id']);
  2782. $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, $custom['name']);
  2783. $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, $custom['mobile']);
  2784. $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, $custom['num']);
  2785. $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, $custom['orderPrice']);
  2786. $objPHPExcel->getActiveSheet()->setCellValue('F' . $i, $custom['tkPrice']);
  2787. $objPHPExcel->getActiveSheet()->setCellValue('G' . $i, $custom['actPrice']);
  2788. $objPHPExcel->getActiveSheet()->setCellValue('H' . $i, $custom['carton']);
  2789. $objPHPExcel->getActiveSheet()->setCellValue('I' . $i, $custom['pack']);
  2790. $objPHPExcel->getActiveSheet()->setCellValue('J' . $i, $custom['freight']);
  2791. //居左
  2792. $objPHPExcel->getActiveSheet()->getStyle('A' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2793. $objPHPExcel->getActiveSheet()->getStyle('B' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2794. $objPHPExcel->getActiveSheet()->getStyle('C' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2795. $objPHPExcel->getActiveSheet()->getStyle('D' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2796. $objPHPExcel->getActiveSheet()->getStyle('E' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2797. $objPHPExcel->getActiveSheet()->getStyle('F' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2798. $objPHPExcel->getActiveSheet()->getStyle('G' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2799. $objPHPExcel->getActiveSheet()->getStyle('H' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2800. $objPHPExcel->getActiveSheet()->getStyle('I' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2801. $objPHPExcel->getActiveSheet()->getStyle('J' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2802. }
  2803. $fileName = '客户业绩-' . date("m-d");
  2804. $objPHPExcel->getActiveSheet()->setTitle($fileName);
  2805. $objPHPExcel->setActiveSheetIndex(0);
  2806. $dir = './priceTable/' . $mainId;
  2807. if (file_exists($dir) == false) {
  2808. mkdir($dir, 0777, true);
  2809. }
  2810. $date = $fileName;
  2811. $file = $date . '.xls';
  2812. $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
  2813. if (file_exists($dir . '/' . $file)) {
  2814. unlink($dir . '/' . $file);
  2815. }
  2816. $objWriter->save($dir . '/' . $file);
  2817. $fileUrl = Yii::$app->params['ghsHost'] . '/priceTable/' . $mainId . '/' . $file;
  2818. util::success(['file' => $fileUrl, 'shortFile' => $file]);
  2819. }
  2820. public static function printLogisticsLabel($order, $shop, $ext)
  2821. {
  2822. /**************************如果是好多花的云仓还要再打一下标签纸,多处要同步修改,关键词 hdh_yc *****************************/
  2823. $orderMainId = $order->mainId;
  2824. if (getenv('YII_ENV') == 'production') {
  2825. $map = [65726, 58, 25119, 28500, 1294, 12925, 2644, 10652, 2084, 89473, 83694];
  2826. } else {
  2827. $map = [828];
  2828. }
  2829. /**************************如果是好多花的云仓还要再打一下标签纸,多处要同步修改,关键词 hdh_yc *****************************/
  2830. $customId = $order->customId ?? 0;
  2831. $custom = CustomClass::getById($customId, true);
  2832. if (empty($custom)) {
  2833. if (!in_array($orderMainId, $map)) {
  2834. util::fail('没有找到客户');
  2835. } else {
  2836. return false;
  2837. }
  2838. }
  2839. $shortName = $custom->shortName ?? '未命名';
  2840. $shortName = stringUtil::subStringUtf8($shortName, 5);
  2841. $customMobile = $order->customMobile ?? '';
  2842. if (empty($customMobile)) {
  2843. if (!in_array($orderMainId, $map)) {
  2844. util::fail('客户手机号无效');
  2845. } else {
  2846. return false;
  2847. }
  2848. }
  2849. //东莞我要花 手机后四号变星号
  2850. if (in_array((int)$orderMainId, [2644, 10652, 89473], true)) {
  2851. $customMobile = preg_replace('/(.{4})$/u', '****', trim($customMobile));
  2852. }
  2853. $customName = $order->customName ?? '';
  2854. $remark = $order->remark ?? '';
  2855. $shortRemark = stringUtil::subStringUtf8($remark, 8);
  2856. $wlName = $custom->wlName ?? '';
  2857. if (empty($wlName)) {
  2858. $wlName = $shortRemark;
  2859. }
  2860. $distId = $custom->distId ?? '';
  2861. $dist = DistClass::getById($distId, true);
  2862. $distName = $dist->name ?? '未分区';
  2863. $address = $order->address ?? '';
  2864. $floor = $order->floor ?? '';
  2865. $fullAddress = $address . $floor;
  2866. $shopName = $shop->shopName ?? '';
  2867. $sjName = $shop->merchantName;
  2868. $currentName = $shopName == '首店' ? $sjName : $sjName . ' ' . $shopName;
  2869. $telephone = $shop->telephone ?? '';
  2870. $wlLabelSn = $ext->wlLabelSn ?? '';
  2871. if (empty($wlLabelSn)) {
  2872. if (!in_array($orderMainId, $map)) {
  2873. util::fail('请绑定物流标签机');
  2874. } else {
  2875. return false;
  2876. }
  2877. }
  2878. $p = new printUtil($wlLabelSn);
  2879. if (!in_array($orderMainId, $map)) {
  2880. $p->times = 1;
  2881. //安庆三叶鲜花批发,比较特殊
  2882. if ($orderMainId == 2071) {
  2883. $content = '<TEXT x="386" y="120" font="12" w="4" h="4" r="90">' . $shortName . '</TEXT>';
  2884. $content .= '<TEXT x="363" y="10" font="12" w="2" h="2" r="90">地址</TEXT>';
  2885. $content .= '<TEXT x="270" y="120" font="12" w="3" h="3" r="90">' . $customMobile . '</TEXT>';
  2886. $content .= '<TEXT x="256" y="10" font="12" w="2" h="2" r="90">号码</TEXT>';
  2887. $content .= '<TEXT x="182" y="120" font="12" w="4" h="4" r="90">' . $wlName . '</TEXT>';
  2888. $content .= '<TEXT x="158" y="10" font="12" w="2" h="2" r="90">物流</TEXT>';
  2889. $content .= '<TEXT x="65" y="35" font="12" w="2" h="2" r="90">' . $currentName . ' ' . $telephone . '</TEXT>';
  2890. } else {
  2891. $content = '<TEXT x="420" y="130" font="12" w="4" h="4" r="90">' . $shortName . '</TEXT>';
  2892. $content .= '<TEXT x="395" y="10" font="12" w="2" h="2" r="90">地址</TEXT>';
  2893. $content .= '<TEXT x="290" y="130" font="12" w="3" h="3" r="90">' . $customMobile . '</TEXT>';
  2894. $content .= '<TEXT x="265" y="10" font="12" w="2" h="2" r="90">号码</TEXT>';
  2895. $content .= '<TEXT x="170" y="130" font="12" w="4" h="4" r="90">' . $wlName . '</TEXT>';
  2896. $content .= '<TEXT x="150" y="10" font="12" w="2" h="2" r="90">物流</TEXT>';
  2897. $content .= '<TEXT x="45" y="70" font="12" w="2" h="2" r="90">' . $currentName . ' ' . $telephone . '</TEXT>';
  2898. }
  2899. } else {
  2900. /**************************如果是好多花的云仓还要再打一下标签纸,多处要同步修改,关键词 hdh_yc *****************************/
  2901. $sameTimeIds = $order->sameTimeIds;
  2902. $num = 1;
  2903. if (!empty($sameTimeIds)) {
  2904. $ids = explode(',', $sameTimeIds);
  2905. if (!empty($ids)) {
  2906. $num = count($ids);
  2907. }
  2908. }
  2909. if ($num > 1) {
  2910. $customName = $customName . ' 共' . $num . '单';
  2911. }
  2912. $itemNum = $order->itemNum ?? 0;
  2913. $itemNum = floatval($itemNum);
  2914. $payTime = $order->payTime ?? '';
  2915. $payDate = date('m-d H:i', strtotime($payTime));
  2916. $content = '<TEXT x="400" y="30" font="12" w="3" h="3" r="90">' . $customName . '</TEXT>';
  2917. // 地址超过15个字,字体大小(w和h)变小一级(由 w="2" h="2" 变为 w="1" h="1")
  2918. $addressLen = mb_strlen($fullAddress, 'UTF-8');
  2919. $fontScale = $addressLen > 16 ? '1' : '2';
  2920. $content .= '<TEXT x="280" y="30" font="12" w="' . $fontScale . '" h="' . $fontScale . '" r="90">' . $fullAddress . '</TEXT>';
  2921. $content .= '<TEXT x="180" y="30" font="12" w="2" h="2" r="90">' . $customMobile . ' ' . $itemNum . '扎</TEXT>';
  2922. $content .= '<TEXT x="86" y="30" font="12" w="2" h="2" r="90">' . $distName . ' ' . $payDate . '</TEXT>';
  2923. /**************************如果是好多花的云仓还要再打一下标签纸,多处要同步修改,关键词 hdh_yc *****************************/
  2924. }
  2925. $p->printLabelMsg($content);
  2926. if (is_object($order) && method_exists($order, 'save')) {
  2927. $order->printWlNum = intval($order->printWlNum ?? 0) + 1;
  2928. $order->save();
  2929. }
  2930. return true;
  2931. }
  2932. //打印花材的物流标 ssh 20260507
  2933. public static function printItemLabel($order, $shop, $ext, $product, $num, $boxNum, $orderItem)
  2934. {
  2935. $customId = $order->customId ?? 0;
  2936. $custom = CustomClass::getById($customId, true);
  2937. $customMobile = $order->customMobile ?? '';
  2938. $customName = $order->customName ?? '';
  2939. $remark = $order->remark ?? '';
  2940. $shortRemark = stringUtil::subStringUtf8($remark, 8);
  2941. $wlName = $custom->wlName ?? '';
  2942. if (empty($wlName)) {
  2943. $wlName = $shortRemark;
  2944. }
  2945. $distId = $custom->distId ?? '';
  2946. $dist = DistClass::getById($distId, true);
  2947. $distName = $dist->name ?? '未分区';
  2948. $address = $order->address ?? '';
  2949. $floor = $order->floor ?? '';
  2950. $fullAddress = $address . $floor;
  2951. $wlLabelSn = $ext->wlLabelSn ?? '';
  2952. if (empty($wlLabelSn)) {
  2953. util::fail('请绑定物流标签机');
  2954. }
  2955. $p = new printUtil($wlLabelSn);
  2956. $p->times = $num;
  2957. $sameTimeIds = $order->sameTimeIds;
  2958. $num = 1;
  2959. if (!empty($sameTimeIds)) {
  2960. $ids = explode(',', $sameTimeIds);
  2961. if (!empty($ids)) {
  2962. $num = count($ids);
  2963. }
  2964. }
  2965. if ($num > 1) {
  2966. $customName = $customName . ' ' . $num . '单';
  2967. }
  2968. $remark = '';
  2969. if (!empty($orderItem->remark)) {
  2970. $remark .= $orderItem->remark;
  2971. }
  2972. if (!empty($order->remark)) {
  2973. if (!empty($remark)) {
  2974. $remark .= ' ' . $order->remark;
  2975. } else {
  2976. $remark .= $order->remark;
  2977. }
  2978. }
  2979. $productName = $product->name ?? '';
  2980. $content = '<TEXT x="400" y="30" font="12" w="2" h="2" r="90">' . $productName . ' 装箱数:' . $boxNum . '</TEXT>';
  2981. $content .= '<TEXT x="325" y="30" font="12" w="2" h="2" r="90">————————————————————</TEXT>';
  2982. $content .= '<TEXT x="250" y="30" font="12" w="2" h="2" r="90">客户:' . $customName . '</TEXT>';
  2983. $content .= '<TEXT x="180" y="30" font="12" w="2" h="2" r="90">地址:' . $fullAddress . '</TEXT>';
  2984. $content .= '<TEXT x="120" y="30" font="12" w="2" h="2" r="90">电话:' . $customMobile . '</TEXT>';
  2985. $content .= '<TEXT x="60" y="30" font="12" w="2" h="2" r="90">备注:' . $remark . '</TEXT>';
  2986. $p->printLabelMsg($content);
  2987. return true;
  2988. }
  2989. //更新客户同一天的订单 $update 0 添加 1 修改
  2990. public static function updateMergeOrder($order, $update = 0)
  2991. {
  2992. $date = substr($order->payTime, 0, 10);
  2993. $customId = $order->customId ?? 0;
  2994. $mainId = $order->mainId ?? 0;
  2995. $orderId = $order->id ?? 0;
  2996. //找到当前订单客户的账单日期为 $date 的所有订单
  2997. $startTime = $date . ' 00:00:00';
  2998. $endTime = $date . ' 23:59:59';
  2999. $dayOrders = self::getAllByCondition([
  3000. 'mainId' => $mainId,
  3001. 'customId' => $customId,
  3002. 'payTime' => ['between', [$startTime, $endTime]]
  3003. ], 'id ASC', 'id');
  3004. if (empty($dayOrders)) {
  3005. return false;
  3006. }
  3007. $ids = array_column($dayOrders, 'id');
  3008. $count = count($ids);
  3009. if ($update == 0) {
  3010. if ($count <= 1) {
  3011. //新增,如果当天只有一个订单,不需要操作
  3012. return false;
  3013. }
  3014. $hasMerge = OrderMergeSnClass::getByCondition(['customId' => $customId, 'mergeDate' => $date], true);
  3015. if (!empty($hasMerge)) {
  3016. $hasMergeId = $hasMerge->id ?? 0;
  3017. $order->mergeId = $hasMergeId;
  3018. $order->save();
  3019. OrderMergeClass::add(['mergeId' => $hasMergeId, 'orderId' => $orderId, 'mergeDate' => $date, 'customId' => $customId, 'mainId' => $mainId]);
  3020. self::syncOrderMergeNumForMergeId($hasMergeId);
  3021. PurchaseClass::syncMergeRelationByOrderIds([$orderId]);
  3022. } else {
  3023. self::rebuildOrderMergeGroupForDay($ids, $date, $customId, $mainId);
  3024. }
  3025. } else {
  3026. //修改账单日:订单 payTime 已在调用方改为新日 $date
  3027. $oldMergeId = (int)($order->mergeId ?? 0);
  3028. if ($oldMergeId > 0) {
  3029. $oldMergeSn = OrderMergeSnClass::getById($oldMergeId, true);
  3030. if (empty($oldMergeSn)) {
  3031. // 订单仍挂着 mergeId,但主档已不存在,避免后续报错并清理脏数据
  3032. $order->mergeId = 0;
  3033. $order->mergeNum = 0;
  3034. $order->save();
  3035. } else {
  3036. $oldDate = $oldMergeSn->mergeDate ?? '';
  3037. if ($oldDate == $date) {
  3038. //合并组账单日与当前一致,无需调整
  3039. return false;
  3040. }
  3041. $oldMergeList = OrderMergeClass::getAllByCondition(['mergeId' => $oldMergeId], null, '*', null, true);
  3042. if (count($oldMergeList) <= 2) {
  3043. //合并组内至多 2 单:整组 dissolve(与原先「只剩一单合并无意义」一致)
  3044. $oldMergeSn->delete();
  3045. $del = [];
  3046. foreach ($oldMergeList as $mergeRow) {
  3047. $del[] = $mergeRow->orderId;
  3048. $mergeRow->delete();
  3049. }
  3050. self::updateByIds($del, ['mergeId' => 0, 'mergeNum' => 0]);
  3051. } else {
  3052. $order->mergeId = 0;
  3053. $order->mergeNum = 0;
  3054. $order->save();
  3055. OrderMergeClass::deleteByCondition(['mergeId' => $oldMergeId, 'orderId' => $orderId]);
  3056. self::syncOrderMergeNumForMergeId($oldMergeId);
  3057. }
  3058. }
  3059. }
  3060. $hasNewMerge = OrderMergeSnClass::getByCondition(['customId' => $customId, 'mergeDate' => $date], true);
  3061. if (!empty($hasNewMerge)) {
  3062. $newMergeId = $hasNewMerge->id ?? 0;
  3063. $order->mergeId = $newMergeId;
  3064. $order->save();
  3065. OrderMergeClass::add(['mergeId' => $newMergeId, 'orderId' => $orderId, 'mergeDate' => $date, 'customId' => $customId, 'mainId' => $mainId]);
  3066. self::syncOrderMergeNumForMergeId($newMergeId);
  3067. PurchaseClass::syncMergeRelationByOrderIds([$orderId]);
  3068. } else {
  3069. self::rebuildOrderMergeGroupForDay($ids, $date, $customId, $mainId);
  3070. }
  3071. }
  3072. return true;
  3073. }
  3074. /**
  3075. * 指定客户、某日多单:新建合并主档,回写订单 mergeId,并批量写入 xhGhsOrderMerge。
  3076. *
  3077. * @param int[] $ids 当日同客户订单 id 列表
  3078. */
  3079. private static function rebuildOrderMergeGroupForDay(array $ids, $date, $customId, $mainId)
  3080. {
  3081. $mergeData = ['mergeDate' => $date, 'customId' => $customId, 'mainId' => $mainId];
  3082. $mergeId = orderSn::getGhsOrderMergeId($mergeData);
  3083. $mergeNum = count($ids);
  3084. self::updateByIds($ids, ['mergeId' => $mergeId, 'mergeNum' => $mergeNum]);
  3085. $addData = [];
  3086. foreach ($ids as $currentId) {
  3087. $addData[] = ['mergeId' => $mergeId, 'orderId' => $currentId, 'mergeDate' => $date, 'customId' => $customId, 'mainId' => $mainId];
  3088. }
  3089. OrderMergeClass::batchAdd($addData);
  3090. PurchaseClass::syncMergeRelationByOrderIds($ids);
  3091. }
  3092. /** 按 xhGhsOrderMerge 明细数量,回写该合并组内所有订单的 mergeNum */
  3093. private static function syncOrderMergeNumForMergeId($mergeId)
  3094. {
  3095. $mergeId = (int)$mergeId;
  3096. if ($mergeId <= 0) {
  3097. return;
  3098. }
  3099. $rows = OrderMergeClass::getAllByCondition(['mergeId' => $mergeId], null, 'orderId', null, true);
  3100. $mergeNum = count($rows);
  3101. if ($mergeNum === 0) {
  3102. return;
  3103. }
  3104. $orderIds = [];
  3105. foreach ($rows as $row) {
  3106. $orderIds[] = (int)(is_object($row) ? ($row->orderId ?? 0) : ($row['orderId'] ?? 0));
  3107. }
  3108. $orderIds = array_values(array_filter($orderIds));
  3109. if (!empty($orderIds)) {
  3110. self::updateByIds($orderIds, ['mergeNum' => $mergeNum]);
  3111. }
  3112. }
  3113. // 更新同天内的所有订单的 sameTimeIds
  3114. public static function updateSameTimeIds($order, $date)
  3115. {
  3116. $id = $order->id ?? 0;
  3117. $customId = $order->customId ?? 0;
  3118. $mainId = $order->mainId ?? 0;
  3119. $oldSameTimeIds = $order->sameTimeIds ?? '';
  3120. //找到当前订单客户的账单日期为 $date 的所有订单,然后更新同天内的所有订单的 sameTimeIds(加此次要改变的订单的订单号$id)
  3121. $startTime = $date . ' 00:00:00';
  3122. $endTime = $date . ' 23:59:59';
  3123. $dayOrders = self::getAllByCondition([
  3124. 'mainId' => $mainId,
  3125. 'customId' => $customId,
  3126. 'payTime' => ['between', [$startTime, $endTime]]
  3127. ], 'id ASC', 'id, sameTimeIds');
  3128. $ids = [];
  3129. if (!empty($dayOrders)) {
  3130. $ids = array_column($dayOrders, 'id');
  3131. }
  3132. // 确保当前订单ID在列表中
  3133. if (!in_array($id, $ids)) {
  3134. $ids[] = $id;
  3135. }
  3136. // 排序并去重
  3137. sort($ids);
  3138. $ids = array_unique($ids);
  3139. // 限制最多 90 单,避免 someTimeIds 过长(兼容原先业务逻辑限制)
  3140. if (count($ids) > 90) {
  3141. $ids = array_slice($ids, 0, 90);
  3142. }
  3143. $sameTimeIdsStr = implode(',', $ids);
  3144. // 更新所有相关订单
  3145. if (!empty($ids) && in_array($id, $ids)) {
  3146. self::updateByIds($ids, ['sameTimeIds' => $sameTimeIdsStr]);
  3147. }
  3148. //从原先同天内的订单中删除此次要改变的订单的订单号$id
  3149. if (!empty($oldSameTimeIds) && $oldSameTimeIds != $sameTimeIdsStr) {
  3150. $oldSameTimeIdsArr = explode(',', $oldSameTimeIds);
  3151. if (in_array($id, $oldSameTimeIdsArr)) {
  3152. $oldSameTimeIdsArr = array_diff($oldSameTimeIdsArr, [$id]);
  3153. $oldSameTimeIdsStr = implode(',', $oldSameTimeIdsArr);
  3154. if (!empty($oldSameTimeIdsArr)) {
  3155. self::updateByIds($oldSameTimeIdsArr, ['sameTimeIds' => $oldSameTimeIdsStr]);
  3156. }
  3157. }
  3158. }
  3159. //noticeUtil::push("orderIds = {$sameTimeIdsStr}, sameTimeIdsStr: {$sameTimeIdsStr}");
  3160. }
  3161. }