Sell.php 91 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347
  1. <?php
  2. # 销售支付
  3. namespace Shop\Lib;
  4. use Dever;
  5. class Sell
  6. {
  7. # 1是用户,2是门店
  8. public $type = 1;
  9. # 1是列表,2是详情
  10. public $view = 1;
  11. # 获取配置
  12. public $config = array();
  13. # table
  14. public $table = 'shop/sell_order';
  15. public function __construct()
  16. {
  17. $this->config = Dever::db($this->table)->config;
  18. }
  19. # 设置订单的类型
  20. public function set($type, $view)
  21. {
  22. $this->type = $type;
  23. $this->view = $view;
  24. return $this;
  25. }
  26. # 获取公共的where
  27. public function where($id)
  28. {
  29. $where = array();
  30. if ($this->type == 1) {
  31. $where['uid'] = $id;
  32. } elseif ($this->type == 2) {
  33. $where['shop_id'] = $id;
  34. }
  35. if (!$where) {
  36. Dever::alert('参数错误');
  37. }
  38. return $where;
  39. }
  40. # 获取订单列表
  41. public function getList($id)
  42. {
  43. $result = array();
  44. $where = $this->where($id);
  45. $mobile = Dever::input('mobile');
  46. if ($mobile) {
  47. $where['mobile'] = $mobile;
  48. }
  49. $status = Dever::input('status');
  50. if ($status) {
  51. $where['status'] = $status;
  52. }
  53. $method = Dever::input('method');
  54. if ($method) {
  55. $where['method'] = $method;
  56. }
  57. $pay_method = Dever::input('pay_method');
  58. if ($pay_method) {
  59. $where['pay_method'] = $pay_method;
  60. }
  61. $result['search_value'] = $where;
  62. $result['search_value']['day'] = $day = Dever::input('day');
  63. if ($day) {
  64. $where['start'] = Dever::maketime($day . ' 00:00:00');
  65. $where['end'] = Dever::maketime($day . ' 23:59:59');
  66. }
  67. $result['order'] = Dever::db($this->table)->getAll($where);
  68. if ($result['order']) {
  69. foreach ($result['order'] as $k => $v) {
  70. $result['order'][$k] = $this->getInfo($v);
  71. }
  72. }
  73. $result['search'] = array();
  74. $result['search']['status'] = array
  75. (
  76. array('value' => 1, 'name' => '待支付'),
  77. array('value' => 2, 'name' => '待处理'),
  78. );
  79. if ($method == 1) {
  80. $result['search']['status'][] = array('value' => 3, 'name' => '待自提');
  81. } elseif ($method == 2) {
  82. $result['search']['status'][] = array('value' => 3, 'name' => '配送中');
  83. } else {
  84. $result['search']['status'][] = array('value' => 3, 'name' => '待自提');
  85. $result['search']['status'][] = array('value' => 3, 'name' => '配送中');
  86. }
  87. $result['search']['status'][] = array('value' => 8, 'name' => '退款');
  88. $result['search']['status'][] = array('value' => '5,6', 'name' => '已完成');
  89. $result['search']['status'][] = array('value' => '7,11', 'name' => '已取消');
  90. $result['search']['method'] = array
  91. (
  92. array('value' => 1, 'name' => '自提'),
  93. array('value' => 2, 'name' => '配送')
  94. );
  95. $result['search']['pay_method'] = array
  96. (
  97. array('value' => 1, 'name' => '平台结算'),
  98. array('value' => 2, 'name' => '门店代下单')
  99. );
  100. return $result;
  101. }
  102. # 查看详情
  103. public function getView($id, $order_id, $show = true)
  104. {
  105. $where = $this->where($id);
  106. $where['id'] = $order_id;
  107. $result = Dever::db($this->table)->find($where);
  108. if (!$result) {
  109. Dever::alert('订单不存在');
  110. }
  111. if ($show) {
  112. $result = $this->getInfo($result);
  113. }
  114. return $result;
  115. }
  116. # 获取订单详细信息
  117. public function getInfo($info)
  118. {
  119. $info['time'] = 0;
  120. if ($info['status'] == 1) {
  121. # 15分钟内支付,900秒
  122. $m = 900;
  123. # 支付倒计时
  124. $info['time'] = time() - $info['cdate'];
  125. if ($info['time'] >= $m) {
  126. # 已过期,自动取消
  127. $info['time'] = -1;
  128. //Dever::db($this->table)->update(array('where_id' => $info['id'], 'status' => 11));
  129. # 还原库存
  130. if ($this->type == 1) {
  131. $this->cancel($info['uid'], $info['id'], 11);
  132. } else {
  133. $this->type = 2;
  134. $this->cancel($info['shop_id'], $info['id'], 11);
  135. }
  136. $info['status'] = 11;
  137. } else {
  138. $info['time'] = $m - $info['time'];
  139. }
  140. }
  141. $info['status_name'] = $this->config['status'][$info['status']];
  142. $info['method_name'] = $this->config['method'][$info['method']];
  143. $info['pay_method_name'] = $this->config['pay_method'][$info['pay_method']];
  144. $info['pay_type_name'] = $this->config['pay_type'][$info['pay_type']];
  145. if (!$info['coupon_cash']) {
  146. $info['coupon_cash'] = 0;
  147. }
  148. if (!$info['discount_cash']) {
  149. $info['discount_cash'] = 0;
  150. }
  151. if (!$info['refund_cash']) {
  152. $info['refund_cash'] = 0;
  153. }
  154. if (!$info['ps_cash']) {
  155. $info['ps_cash'] = 0;
  156. }
  157. if (!$info['ps_cash']) {
  158. $info['ps_cash'] = 0;
  159. }
  160. if (!$info['wallet_cash']) {
  161. $info['wallet_cash'] = 0;
  162. } else {
  163. $info['wallet_cash'] = round($info['wallet_cash'], 2);
  164. }
  165. if (!$info['card_code_cash']) {
  166. $info['card_code_cash'] = 0;
  167. } else {
  168. $info['card_code_cash'] = round($info['card_code_cash'], 2);
  169. }
  170. $tk = Dever::db('shop/sell_order_refund')->find(array('order_id' => $info['id'], 'process' => 2));
  171. if ($tk) {
  172. $info['tk_status'] = 1;
  173. } else {
  174. $info['tk_status'] = 2;
  175. }
  176. $info['card'] = array();
  177. if ($info['card_code_id'] > 0) {
  178. $config = Dever::db('main/sell_config')->find();
  179. $info['card']['name'] = $config['card_name'];
  180. $card_code = Dever::db('card/code')->find($info['card_code_id']);
  181. if ($card_code) {
  182. $card_info = Dever::db('card/info')->find($card_code['card_id']);
  183. if ($card_info) {
  184. $card_type = Dever::db('card/type')->find($card_info['type_id']);
  185. $card = substr($card_code['card'], -4);
  186. $info['card']['name'] .= '('.$card_type['name'].$card.')';
  187. $info['card']['info'] = $card_info;
  188. $info['card']['id'] = $card_code['id'];
  189. $info['card']['card'] = $card_code['card'];
  190. $info['card']['cash'] = $info['card_code_cash'];
  191. }
  192. }
  193. }
  194. if ($this->type == 1) {
  195. if ($info['status'] == 2) {
  196. $info['status_name'] = '支付成功';
  197. }
  198. if ($info['status'] == 3) {
  199. if ($info['method'] == 1) {
  200. $info['status_name'] = '待自提';
  201. } else {
  202. $info['status_name'] = '配送中';
  203. }
  204. }
  205. } elseif ($this->type == 2) {
  206. if ($info['status'] == 2) {
  207. $info['status_name'] = '待处理';
  208. }
  209. if ($info['status'] == 3) {
  210. if ($info['method'] == 1) {
  211. $info['status_name'] = '待自提';
  212. } else {
  213. $info['status_name'] = '配送中';
  214. }
  215. }
  216. }
  217. if ($info['method'] == 2) {
  218. $info['ps_info'] = Dever::db('shop/sell_order_ps')->find(array('order_id' => $info['id']));
  219. if ($info['ps_info']) {
  220. $info['ps_info']['service'] = Dever::array_decode($info['ps_info']['service']);
  221. $info['ps_info']['cdate'] = date('Y-m-d H:i', $info['ps_info']['cdate']);
  222. if ($info['ps_info']['qu_date']) {
  223. $info['ps_info']['qu_date'] = date('Y-m-d H:i', $info['ps_info']['qu_date']);
  224. }
  225. if ($info['ps_info']['qs_date']) {
  226. $info['ps_info']['qs_date'] = date('Y-m-d H:i', $info['ps_info']['qs_date']);
  227. }
  228. $status = Dever::db('shop/sell_order_ps')->config['status'];
  229. $info['ps_info']['status_name'] = $status[$info['ps_info']['status']];
  230. if ($info['ps_info']['service']) {
  231. foreach ($info['ps_info']['service'] as $k => $v) {
  232. if (isset($v['order_num']) && $v['order_num']) {
  233. $info['ps_info']['service'][$k]['service_name'] = '商家自送';
  234. if ($v['service_id'] > 0) {
  235. $service = Dever::db('shop/service')->find($v['service_id']);
  236. $info['ps_info']['service'][$k]['service_name'] = $service['name'];
  237. }
  238. } else {
  239. unset($info['ps_info']['service'][$k]);
  240. }
  241. }
  242. }
  243. }
  244. }
  245. $info['goods'] = Dever::db('shop/sell_order_goods')->select(array('order_id' => $info['id']));
  246. if ($info['uid'] && $info['uid'] > 0) {
  247. $info['user'] = Dever::load('passport/api')->info($info['uid']);
  248. }
  249. $info['shop'] = Dever::db('shop/info')->getOne($info['shop_id']);
  250. $info['cdate'] = date('Y-m-d H:i', $info['cdate']);
  251. if ($info['operdate']) {
  252. $info['operdate'] = date('Y-m-d H:i', $info['operdate']);
  253. } else {
  254. $info['operdate'] = '';
  255. }
  256. if ($info['fdate']) {
  257. $info['fdate'] = date('Y-m-d H:i', $info['fdate']);
  258. } else {
  259. $info['fdate'] = '';
  260. }
  261. $goods_status = Dever::db('shop/sell_order_goods')->config['status'];
  262. if ($info['address_id']) {
  263. $info['address'] = Dever::db('passport/address')->find($info['address_id']);
  264. }
  265. if ($this->view == 2) {
  266. $check = false;
  267. if (isset($card_info) && $card_info) {
  268. $info['card']['goods'] = array();
  269. $check = false;
  270. $shop = Dever::db('shop/info')->find($info['shop_id']);
  271. if ($shop['type'] == 1 && $card_info['shop_set'] == 1) {
  272. $check = false;
  273. } else {
  274. $goods = Dever::db('card/info_goods')->getData(array('card_id' => $card_info['id']));
  275. if ($goods || $card_info['category']) {
  276. $check = true;
  277. $card_info['category'] = explode(',', $card_info['category']);
  278. if ($goods) {
  279. $goods = array_keys($goods);
  280. }
  281. }
  282. }
  283. }
  284. $info['discount_goods'] = array();
  285. foreach ($info['goods'] as $k => $v) {
  286. $info['goods'][$k]['info'] = Dever::load('goods/lib/info')->getPayInfo($v['goods_id'], $v['sku_id']);
  287. $info['goods'][$k]['status_name'] = $goods_status[$v['status']];
  288. if ($check) {
  289. if ($goods) {
  290. if (in_array($v['goods_id'], $goods)) {
  291. if ($card_info['category']) {
  292. if (in_array($info['goods'][$k]['info']['top_category_id'], $card_info['category'])) {
  293. $info['card']['goods'][] = $info['goods'][$k]['info'];
  294. }
  295. } else {
  296. $info['card']['goods'][] = $info['goods'][$k]['info'];
  297. }
  298. }
  299. } elseif ($card_info['category']) {
  300. if (in_array($info['goods'][$k]['info']['top_category_id'], $card_info['category'])) {
  301. $info['card']['goods'][] = $info['goods'][$k]['info'];
  302. }
  303. }
  304. }
  305. if ($v['discount_id'] && $v['discount_id'] > 0) {
  306. $info['discount_goods'][] = $info['goods'][$k];
  307. }
  308. }
  309. if ($info['invoice_id']) {
  310. $info['invoice'] = Dever::db('passport/invoice')->find($info['invoice_id']);
  311. }
  312. if ($info['user_coupon_id']) {
  313. $coupon = Dever::db('shop/user_coupon')->find($info['user_coupon_id']);
  314. if ($coupon) {
  315. $info['coupon'] = Dever::db('goods/coupon')->find($coupon['coupon_id']);
  316. }
  317. }
  318. } else {
  319. foreach ($info['goods'] as $k => $v) {
  320. $goods = Dever::db('goods/info')->one($v['goods_id']);
  321. $info['goods'][$k]['name'] = $goods['name'];
  322. $info['goods'][$k]['cover'] = $goods['cover'];
  323. $info['goods'][$k]['status_name'] = $goods_status[$v['status']];
  324. }
  325. }
  326. return $info;
  327. }
  328. # 取消订单
  329. public function cancel($id, $order_id, $status = 7)
  330. {
  331. $data = $this->getView($id, $order_id, false);
  332. if ($data['status'] == 1) {
  333. $state = Dever::db('shop/sell_order')->update(array('where_id' => $data['id'], 'status' => $status, 'operdate' => time()));
  334. if ($state) {
  335. if ($data['user_coupon_id']) {
  336. # 还原优惠券
  337. Dever::db('shop/user_coupon')->update(array('where_id' => $data['user_coupon_id'], 'status' => 1));
  338. }
  339. if (isset($data['card_code_id']) && $data['card_code_id'] && $data['card_code_cash'] > 0) {
  340. # 还原礼品卡
  341. Dever::db('card/code')->decUseCash(array('where_id' => $data['card_code_id'], 'set_use_cash' => $data['card_code_cash']));
  342. Dever::load('cash/lib/order')->up($data, 3, 2, false, 2);
  343. /*
  344. $code = Dever::db('card/code')->find($data['card_code_id']);
  345. if ($code) {
  346. $card_info = Dever::db('card/info')->find($code['card_id']);
  347. if ($card_info) {
  348. if ($code['type'] == 2) {
  349. $zhe = 0.9;
  350. } else {
  351. $zhe = $card_info['price']/$card_info['value'];
  352. }
  353. $price = round($data['card_code_cash']*$zhe, 2);
  354. $data['type'] = 1;
  355. $data['type_id'] = $data['shop_id'];
  356. $data['source_type'] = 4;
  357. $data['source_id'] = -1;
  358. $data['price'] = $price;
  359. $data['p_price'] = $data['card_code_cash'];
  360. Dever::load('cash/lib/order')->up($data, 3, 2, false, 2);
  361. }
  362. }
  363. */
  364. } elseif (isset($data['wallet_cash']) && $data['wallet_cash'] && $data['wallet_cash'] > 0) {
  365. # 还原钱包
  366. Dever::load('shop/lib/money')->up($data['uid'], 4, $data['wallet_cash'], $data['id'], '商品退款', 2);
  367. Dever::load('cash/lib/order')->up($data, 3, 2, false, 3);
  368. }
  369. $this->updateSell($data, 2);
  370. }
  371. return 'ok';
  372. } else {
  373. Dever::alert('当前订单状态不允许取消');
  374. }
  375. }
  376. # 获取优惠券
  377. public function coupon(&$data, $type = 1)
  378. {
  379. $user_coupon_id = Dever::input('user_coupon_id');
  380. $shop_coupon_id = Dever::input('shop_coupon_id');
  381. $data['user_coupon_id'] = 0;
  382. $data['coupon_id'] = 0;
  383. $data['coupon_cash'] = 0;
  384. if ($data['pay_method'] == 3) {
  385. return $data;
  386. }
  387. if ($type == 1) {
  388. if (isset($data['uid']) && $data['uid'] > 0) {
  389. # 默认选择优惠券
  390. # 查找符合要求的优惠券
  391. $coupon = Dever::db('shop/user_coupon')->getAll(array('uid' => $data['uid'], 'city' => $data['shop']['city'], 'status' => 1, 'edate' => time()));
  392. if ($coupon) {
  393. foreach ($coupon as $k => $v) {
  394. $coupon_info = Dever::db('goods/coupon')->find($v['coupon_id']);
  395. if ($coupon_info) {
  396. if ($v['shop_id'] != $data['shop']['id'] && $coupon_info['method'] == 3) {
  397. # 门店专属券 不能给别的门店用
  398. continue;
  399. }
  400. $kou = false;
  401. if ($coupon_info['type'] == 1) {
  402. # 满减券
  403. if ($data['price'] >= $coupon_info['total_cash']) {
  404. $kou = true;
  405. }
  406. } else {
  407. $kou = true;
  408. }
  409. if ($kou) {
  410. $coupon_info['user_coupon_id'] = $v['id'];
  411. $coupon_info['uid'] = $v['uid'];
  412. $coupon_info['edate'] = date('Y-m-d', $v['edate']);
  413. $coupon_info['shop_id'] = $v['shop_id'];
  414. $coupon_info['coupon_id'] = $v['coupon_id'];
  415. $coupon_info['city'] = $v['city'];
  416. $coupon_info = Dever::load('shop/lib/coupon')->getShop($coupon_info, $data['shop'], false);
  417. $data['coupon'][] = $coupon_info;
  418. if (!$user_coupon_id && $data['coupon_cash'] <= $coupon_info['cash']) {
  419. $data['user_coupon_id'] = $v['id'];
  420. $data['coupon_id'] = $coupon_info['id'];
  421. $data['coupon_cash'] = $coupon_info['cash'];
  422. }
  423. }
  424. }
  425. }
  426. }
  427. } else {
  428. $coupon = Dever::db('shop/coupon')->getAll(array('shop_id' => $data['shop']['id']));
  429. if ($coupon) {
  430. foreach ($coupon as $k => $v) {
  431. $coupon_info = Dever::db('goods/coupon')->find($v['coupon_id']);
  432. $kou = false;
  433. if ($coupon_info['type'] == 1) {
  434. # 满减券
  435. if ($data['price'] >= $coupon_info['total_cash']) {
  436. $kou = true;
  437. }
  438. } else {
  439. $kou = true;
  440. }
  441. if ($kou) {
  442. $coupon_info['shop_id'] = $v['shop_id'];
  443. $coupon_info['shop_coupon_id'] = $v['id'];
  444. $coupon_info['coupon_id'] = $v['coupon_id'];
  445. $coupon_info['city'] = $v['city'];
  446. $coupon_info = Dever::load('shop/lib/coupon')->getShop($coupon_info, $data['shop'], false);
  447. $data['coupon'][] = $coupon_info;
  448. }
  449. }
  450. }
  451. }
  452. }
  453. if ($user_coupon_id && isset($data['uid']) && $data['uid'] > 0) {
  454. # 用户自己使用优惠券
  455. if ($data['price'] <= 0) {
  456. Dever::alert('付款价格错误');
  457. }
  458. $coupon = Dever::db('shop/user_coupon')->find(array('uid' => $data['uid'], 'id' => $user_coupon_id, 'status' => 1));
  459. if (!$coupon) {
  460. Dever::alert('优惠券不可用');
  461. }
  462. if (time() > $coupon['edate']) {
  463. Dever::db('shop/user_coupon')->update(array('where_id' => $user_coupon_id, 'status' => 3));
  464. Dever::alert('优惠券已过期');
  465. }
  466. $goods_coupon = Dever::db('goods/coupon')->find($coupon['coupon_id']);
  467. if (!$goods_coupon) {
  468. Dever::alert('优惠券不可用');
  469. }
  470. if ($coupon['shop_id'] != $data['shop']['id']) {
  471. if ($goods_coupon['method'] == 3) {
  472. Dever::alert('优惠券不可用');
  473. } else {
  474. $coupon_info = Dever::db('shop/coupon')->find(array('shop_id' => $coupon['shop_id'], 'coupon_id' => $coupon['coupon_id'], 'city' => $coupon['city']));
  475. if (!$coupon_info) {
  476. Dever::alert('优惠券不可用');
  477. }
  478. }
  479. }
  480. if ($goods_coupon['type'] == 2 && $data['price'] < $goods_coupon['total_cash']) {
  481. Dever::alert('优惠券不可用');
  482. }
  483. $data['user_coupon_id'] = $user_coupon_id;
  484. $data['coupon_id'] = $goods_coupon['id'];
  485. $data['coupon_cash'] = $goods_coupon['cash'];
  486. } elseif ($shop_coupon_id) {
  487. # 店里直接给用优惠券
  488. if ($data['price'] <= 0) {
  489. Dever::alert('付款价格错误');
  490. }
  491. $coupon_info = Dever::db('shop/coupon')->find(array('shop_id' => $data['shop']['id'], 'id' => $shop_coupon_id));
  492. if (!$coupon_info) {
  493. Dever::alert('优惠券不可用');
  494. }
  495. $goods_coupon = Dever::db('goods/coupon')->find($coupon_info['coupon_id']);
  496. if (!$goods_coupon) {
  497. Dever::alert('优惠券不可用');
  498. }
  499. if ($goods_coupon['type'] == 2 && $data['price'] < $goods_coupon['total_cash']) {
  500. Dever::alert('优惠券不可用');
  501. }
  502. $data['user_coupon_id'] = -1;
  503. $data['coupon_id'] = $goods_coupon['id'];
  504. $data['coupon_cash'] = $goods_coupon['cash'];
  505. }
  506. if (isset($data['coupon_cash']) && $data['coupon_cash'] > 0) {
  507. # 这里还要计算每个商品的优惠金额
  508. if (isset($data['list']) && $data['list']) {
  509. foreach ($data['list'] as $k => $v) {
  510. $data['list'][$k]['coupon_id'] = $data['coupon_id'];
  511. $data['list'][$k]['user_coupon_id'] = $data['user_coupon_id'];
  512. $data['list'][$k]['coupon_cash'] = round(($v['price'] * $v['buy_num'])/$data['price'], 2) * $data['coupon_cash'];
  513. $data['list'][$k]['cash'] = $v['price'] - $data['list'][$k]['coupon_cash'];
  514. }
  515. }
  516. $data['price'] -= $data['coupon_cash'];
  517. }
  518. # 计算礼品卡
  519. $card = Dever::input('card');
  520. $wallet = Dever::input('wallet');
  521. if ($data['price'] > 0 && isset($data['uid']) && $data['uid'] > 0 && $data['discount_id'] <= 0) {
  522. if ($card) {
  523. # 验证这个礼品卡属于自己
  524. $card_code = Dever::db('card/code')->find($card);
  525. if ($card_code['dh_uid'] == $data['uid']) {
  526. $card_state = Dever::load('card/lib/code')->check($card_code);
  527. if ($card_state == 1) {
  528. if (!$card_code['total_cash']) {
  529. $card_code['total_cash'] = $card_code['info']['value'];
  530. }
  531. if (!$card_code['use_cash']) {
  532. $card_code['use_cash'] = 0;
  533. }
  534. $card_cash = $card_code['total_cash'] - $card_code['use_cash'];
  535. if ($card_cash > 0) {
  536. $data['card'] = array();
  537. $card_goods = array();
  538. $check = false;
  539. $xian = false;
  540. if ($data['shop']['type'] == 1 && $card_code['info']['shop_set'] == 1) {
  541. $check = false;
  542. $xian = false;
  543. } else {
  544. $xian = true;
  545. $goods = Dever::db('card/info_goods')->getData(array('card_id' => $card_code['info']['id']));
  546. if ($goods || $card_code['info']['category']) {
  547. $check = true;
  548. }
  549. }
  550. if ($check) {
  551. $price = 0;
  552. $card_code['info']['category'] = explode(',', $card_code['info']['category']);
  553. if ($goods) {
  554. $goods = array_keys($goods);
  555. }
  556. # 检测当前商品是否符合该卡的限制
  557. foreach ($data['list'] as $k => $v) {
  558. if (!isset($v['cash'])) {
  559. $v['cash'] = $v['price'];
  560. }
  561. if ($goods) {
  562. if (in_array($v['id'], $goods)) {
  563. if ($card_code['info']['category']) {
  564. if (in_array($v['top_category_id'], $card_code['info']['category'])) {
  565. $price += ($v['cash'] * $v['num']);
  566. $card_goods[] = $v;
  567. }
  568. } else {
  569. $price += ($v['cash'] * $v['num']);
  570. $card_goods[] = $v;
  571. }
  572. }
  573. } elseif ($card_code['info']['category']) {
  574. if (in_array($v['top_category_id'], $card_code['info']['category'])) {
  575. $price += ($v['cash'] * $v['num']);
  576. $card_goods[] = $v;
  577. }
  578. }
  579. }
  580. } else {
  581. $price = $data['price'];
  582. }
  583. if ($card_cash > $price) {
  584. $data['card']['cash'] = $price;
  585. } else {
  586. $data['card']['cash'] = $card_cash;
  587. }
  588. $data['price'] -= $data['card']['cash'];
  589. if ($xian && ($price <= 0 || ($card_code['info']['min'] > 0 && $price < $card_code['info']['min']))) {
  590. # 不满足限额
  591. unset($data['card']);
  592. } else {
  593. $data['card']['info'] = $card_code['info'];
  594. $data['card']['goods'] = $card_goods;
  595. $data['card']['id'] = $card_code['id'];
  596. $data['card']['card'] = $card_code['card'];
  597. $data['card']['cash'] = round($data['card']['cash'], 2);
  598. $config = Dever::db('main/sell_config')->find();
  599. $card_type = Dever::db('card/type')->find($card_code['info']['type_id']);
  600. $data['card']['name'] = $config['card_name'];
  601. $card = substr($card_code['card'], -4);
  602. $data['card']['name'] .= '('.$card_type['name'].$card.')';
  603. }
  604. }
  605. }
  606. }
  607. } elseif ($wallet && $wallet > 0) {
  608. $user = Dever::db('passport/user')->find($data['uid']);
  609. if ($user) {
  610. if ($user['cash'] >= $data['price']) {
  611. $data['wallet_cash'] = $data['price'];
  612. $data['price'] = 0;
  613. } else {
  614. $data['wallet_cash'] = $user['cash'];
  615. $data['price'] = $data['price'] - $user['cash'];
  616. }
  617. }
  618. }
  619. }
  620. if ($data['price'] < 0) {
  621. $data['price'] = 0;
  622. }
  623. $data['price'] = round($data['price'], 2);
  624. return $data;
  625. }
  626. # 获取礼品卡 - 更改商品卡 - 废弃
  627. public function card($uid, $shop)
  628. {
  629. $card = Dever::input('card');
  630. $pwd = Dever::input('pwd');
  631. if (!$card) {
  632. Dever::alert('卡号/密码错误');
  633. }
  634. if (!$pwd) {
  635. Dever::alert('卡号/密码错误');
  636. }
  637. $data = Dever::db('goods/card_code')->find(array('card' => $card, 'pwd' => $pwd));
  638. if (!$data) {
  639. Dever::alert('卡号/密码错误');
  640. }
  641. $info = Dever::db('goods/card')->find($data['card_id']);
  642. if (!$info || ($info && $info['status'] != 1)) {
  643. Dever::alert('卡号/密码错误');
  644. }
  645. if ($data['uid'] && $data['uid'] > 0) {
  646. if ($data['uid'] != $uid) {
  647. Dever::alert('礼品卡已被领取');
  648. }
  649. if (time() > $data['edate']) {
  650. # 更新礼品卡状态
  651. $card_update['where_id'] = $data['id'];
  652. $card_update['status'] = 5;
  653. Dever::db('goods/card_code')->update($card_update);
  654. Dever::alert('礼品卡已失效');
  655. }
  656. } else {
  657. if (time() > $data['edate']) {
  658. # 更新礼品卡状态
  659. $card_update['where_id'] = $data['id'];
  660. $card_update['uid'] = $uid;
  661. $card_update['status'] = 5;
  662. if ($shop) {
  663. $card_update['shop_id'] = $shop['id'];
  664. }
  665. Dever::db('goods/card_code')->update($card_update);
  666. Dever::alert('礼品卡已失效');
  667. } else {
  668. # 更新礼品卡状态
  669. $card_update['where_id'] = $data['id'];
  670. $card_update['status'] = 2;
  671. $card_update['uid'] = $uid;
  672. $card_update['ddate'] = time();
  673. if ($shop) {
  674. $card_update['shop_id'] = $shop['id'];
  675. }
  676. Dever::db('goods/card_code')->update($card_update);
  677. }
  678. }
  679. $data = Dever::db('goods/card_code')->find($data['id']);
  680. $data['goods'] = $info['goods'];
  681. return $data;
  682. }
  683. # 得到商品和总价
  684. public function goods(&$data)
  685. {
  686. # 1自提,2配送
  687. $data['method'] = Dever::input('method', 1);
  688. $data['pay_method'] = Dever::input('pay_method');
  689. if ($data['pay_method'] == 3) {
  690. $data['card'] = $this->card($data['uid'], $data['shop']);
  691. $goods = Dever::array_decode($data['card']['goods']);
  692. $goods_id = array();
  693. $num = array();
  694. $sku_id = array();
  695. foreach ($goods as $k => $v) {
  696. $goods_id[] = $v['goods_id'];
  697. $num[] = $v['num'];
  698. $sku_id[] = -1;
  699. }
  700. } else {
  701. $goods_id = Dever::input('goods_id');
  702. if (!$goods_id) {
  703. Dever::alert('请传入商品');
  704. }
  705. $goods_id = explode(',', $goods_id);
  706. $sku_id = Dever::input('price_id');
  707. if ($sku_id) {
  708. $sku_id = explode(',', $sku_id);
  709. }
  710. $single_id = Dever::input('single_id');
  711. if ($single_id) {
  712. $single_id = explode(',', $single_id);
  713. }
  714. $input_id = Dever::input('input_id');
  715. if ($input_id) {
  716. $input_id = explode(',', $input_id);
  717. }
  718. $input_value = Dever::input('input_value');
  719. if ($input_value) {
  720. $input_value = explode(',', $input_value);
  721. }
  722. $num = Dever::input('num');
  723. if (!$num) {
  724. Dever::alert('请传入商品数量');
  725. }
  726. $num = explode(',', $num);
  727. }
  728. # 钱包金额
  729. $data['wallet_cash'] = 0;
  730. # 配送金额
  731. $data['ps_cash'] = 0;
  732. # 原价
  733. $data['oprice'] = 0;
  734. # 现价
  735. $data['price'] = 0;
  736. $data['num'] = 0;
  737. $data['name'] = array();
  738. $count = count($goods_id);
  739. # 获取角色
  740. $role = $this->getRole($data);
  741. $data['discount_goods'] = array();
  742. $data['discount_cash'] = 0;
  743. $data['discount_id'] = 0;
  744. # 计算总价格
  745. foreach ($goods_id as $k => $v) {
  746. $s = isset($sku_id[$k]) ? $sku_id[$k] : -1;
  747. $n = isset($num[$k]) ? $num[$k] : 1;
  748. $data['list'][$k] = Dever::load('goods/lib/info')->getPayInfo($v, $s);
  749. $w = array();
  750. $w['goods_id'] = $v;
  751. $w['sku_id'] = $s;
  752. $w['shop_id'] = $data['shop']['id'];
  753. $goods_sku = Dever::db('shop/goods_sku')->find($w);
  754. if ($goods_sku) {
  755. if (isset($goods_sku['min'])) {
  756. $data['list'][$k]['min'] = $goods_sku['min'];
  757. }
  758. if (isset($goods_sku['price_id']) && $goods_sku['price_id'] > 0) {
  759. $price_template = Dever::load('price/lib/data')->get($v, $s, $goods_sku['price_id']);
  760. if ($price_template) {
  761. /*
  762. if ($goods_sku['min'] <= 0 && $price_template['price_num'] > 0) {
  763. $data['list'][$k]['min'] = $price_template['price_num'];
  764. }
  765. */
  766. if ($price_template['price_sell'] && $price_template['price_sell'] > 0) {
  767. $data['list'][$k]['price'] = $price_template['price_sell'];
  768. }
  769. }
  770. }
  771. }
  772. $data['list'][$k]['cash'] = $data['list'][$k]['price'];
  773. $data['list'][$k]['num'] = $n;
  774. # 2是库存不足
  775. $data['list'][$k]['ku_state'] = 1;
  776. # 验证是否有货
  777. $total = Dever::load('shop/lib/info')->checkTotal($n, $v, $data['shop']['id'], $s);
  778. if (isset($data['list'][$k]['min']) && $data['list'][$k]['min'] > 0) {
  779. if ($total < $data['list'][$k]['min']) {
  780. $total = 0;
  781. }
  782. }
  783. if ($total <= 0) {
  784. $data['list'][$k]['ku_state'] = 2;
  785. $data['list'][$k]['buy_num'] = 0;
  786. }
  787. if ($data['list'][$k]['ku_state'] == 1) {
  788. $data['list'][$k]['buy_num'] = $n;
  789. $data['num'] += $n;
  790. # 根据角色设置折扣
  791. if ($role) {
  792. $role_state = false;
  793. $discount_goods = Dever::db('act/discount_goods')->getData(array('discount_id' => $role['id']));
  794. if ($discount_goods) {
  795. $discount_goods = array_keys($discount_goods);
  796. if (in_array($data['list'][$k]['id'], $discount_goods)) {
  797. $role_state = true;
  798. }
  799. } elseif ($role['category'] && in_array($data['list'][$k]['top_category_id'], $role['category'])) {
  800. $role_state = true;
  801. }
  802. if ($role_state) {
  803. $discount_cash = round($data['list'][$k]['price'] * ($role['num']/10), 2);
  804. $data['list'][$k]['discount_id'] = $role['id'];
  805. $data['discount_goods'][] = $data['list'][$k];
  806. $data['discount_id'] = $role['id'];
  807. $data['list'][$k]['discount_cash'] = round(($data['list'][$k]['price'] - $discount_cash) * $n, 2);
  808. $data['discount_cash'] += $data['list'][$k]['discount_cash'];
  809. $data['price'] += $discount_cash * $n;
  810. } else {
  811. $data['price'] += $data['list'][$k]['price'] * $n;
  812. }
  813. } else {
  814. $data['price'] += $data['list'][$k]['price'] * $n;
  815. }
  816. $data['oprice'] += $data['list'][$k]['cash'] * $n;
  817. $data['name'][] = $data['list'][$k]['name'];
  818. }
  819. }
  820. $data['name'] = implode(',', $data['name']);
  821. if ($data['method'] == 2) {
  822. $data['ps_cash'] = $data['shop']['ps_cash'];
  823. if ($data['shop']['free_ps_cash'] && $data['shop']['free_ps_cash'] > 0 && $data['price'] >= $data['shop']['free_ps_cash']) {
  824. $data['ps_cash'] = 0;
  825. }
  826. if (!$data['ps_cash']) {
  827. $data['ps_cash'] = 0;
  828. }
  829. }
  830. return $data;
  831. }
  832. public function getRole($data)
  833. {
  834. if(isset($data['uid']) && $data['uid'] > 0) {
  835. return Dever::load('shop/lib/info')->getRole($data['uid']);
  836. }
  837. return false;
  838. }
  839. # 发起支付
  840. public function pay($method, $pay_method, $pay_type, $user, $shop, $name, $num, $goods, $oprice, $price, $cash, $address_id, $invoice_id, $info, $card, $wallet_cash, $coupon_id, $user_coupon_id, $coupon_cash, $discount_id, $discount_cash, $cart = false, $system_source = 5, $refer = '')
  841. {
  842. if (!$user) {
  843. Dever::alert('错误的用户信息');
  844. }
  845. $uid = $user['id'];
  846. if ($uid > 0) {
  847. $wechat = Dever::db('passport/wechat')->one(array('uid' => $uid, 'type' => 1, 'system_id' => 1));
  848. if (!$wechat) {
  849. //Dever::alert('错误的用户信息');
  850. }
  851. }
  852. if ($method == 2) {
  853. $ps_cash = $shop['ps_cash'];
  854. if ($shop['free_ps_cash'] && $shop['free_ps_cash'] > 0 && $price >= $shop['free_ps_cash']) {
  855. $ps_cash = 0;
  856. }
  857. if (!$ps_cash) {
  858. $ps_cash = 0;
  859. }
  860. $order_data['ps_cash'] = $ps_cash;
  861. $price += $order_data['ps_cash'];
  862. }
  863. $order_data['shop_id'] = $shop['id'];
  864. if ($shop['type'] == 10) {
  865. $order_data['shop_type'] = 2;
  866. } else {
  867. $order_data['shop_type'] = 1;
  868. }
  869. $order_data['area'] = $shop['area'] . ',' . $shop['id'];
  870. $order_data['uid'] = $uid;
  871. $order_data['mobile'] = $user['mobile'];
  872. $order_data['address_id'] = $address_id;
  873. $order_data['invoice_id'] = $invoice_id;
  874. $order_data['name'] = $name;
  875. $order_data['num'] = $num;
  876. $order_data['info'] = $info;
  877. $order_data['oprice'] = $oprice;
  878. $order_data['price'] = $price;
  879. $order_data['kou_cash'] = $cash;
  880. $order_data['method'] = $method;
  881. $order_data['pay_method'] = $pay_method;
  882. $order_data['pay_type'] = $pay_type;
  883. $order_data['refund_cash'] = 0;
  884. if ($card) {
  885. // $order_data['card_id'] = $card['info']['id'];
  886. $order_data['card_code_id'] = $card['id'];
  887. $order_data['card_code_card'] = $card['card'];
  888. $order_data['card_code_cash'] = $card['cash'];
  889. } elseif ($wallet_cash) {
  890. $order_data['wallet_cash'] = $wallet_cash;
  891. }
  892. if ($user_coupon_id) {
  893. $order_data['user_coupon_id'] = $user_coupon_id;
  894. }
  895. if ($coupon_id) {
  896. $order_data['coupon_id'] = $coupon_id;
  897. }
  898. if ($coupon_cash) {
  899. $order_data['coupon_cash'] = $coupon_cash;
  900. }
  901. if ($discount_id) {
  902. $order_data['discount_id'] = $discount_id;
  903. }
  904. if ($discount_cash) {
  905. $order_data['discount_cash'] = $discount_cash;
  906. }
  907. $order_data['order_num'] = $this->getOrderId();
  908. $id = Dever::db('shop/sell_order')->insert($order_data);
  909. if (!$id) {
  910. Dever::alert('支付失败');
  911. }
  912. foreach($goods as $k => $v) {
  913. if ($v['ku_state'] == 1) {
  914. $data['uid'] = $uid;
  915. $data['order_id'] = $id;
  916. $data['shop_id'] = $shop['id'];
  917. $data['goods_id'] = $v['id'];
  918. $data['sku_id'] = $v['sku_id'];
  919. $data['price'] = $v['price'];
  920. $data['num'] = $v['buy_num'];
  921. if (isset($v['user_coupon_id']) && $v['user_coupon_id']) {
  922. $data['user_coupon_id'] = $v['user_coupon_id'];
  923. }
  924. if (isset($v['coupon_id']) && $v['coupon_id']) {
  925. $data['coupon_id'] = $v['coupon_id'];
  926. }
  927. if (isset($v['coupon_cash']) && $v['coupon_cash']) {
  928. $data['coupon_cash'] = $v['coupon_cash'];
  929. } else {
  930. $data['coupon_cash'] = 0;
  931. }
  932. if (isset($v['discount_id']) && $v['discount_id']) {
  933. $data['discount_id'] = $v['discount_id'];
  934. }
  935. if (isset($v['discount_cash']) && $v['discount_cash']) {
  936. $data['discount_cash'] = $v['discount_cash'];
  937. }
  938. Dever::db('shop/sell_order_goods')->insert($data);
  939. }
  940. }
  941. # 减少库存 增加销量
  942. $order_data['id'] = $id;
  943. $this->updateSell($order_data);
  944. if ($price <= 0 || $pay_type == 2) {
  945. $param['pay_product_id'] = $id;
  946. $param['pay_order_id'] = $order_data['order_num'];
  947. $param['pay_status'] = 2;
  948. $param['pay_cash'] = $price;
  949. $param['pay_msg'] = '';
  950. $this->success($param);
  951. if ($cart) {
  952. # 来自购物车,要清空一下
  953. $this->dropCart($cart, $uid, $goods, $shop['id']);
  954. }
  955. # 使用优惠券
  956. $this->useCoupon($order_data, $coupon_id, $user_coupon_id, $card, $wallet_cash);
  957. /*
  958. if ($card) {
  959. # 更新礼品卡状态
  960. $card_update['where_id'] = $card['id'];
  961. $card_update['status'] = 3;
  962. $card_update['order_id'] = $id;
  963. $card_update['shop_id'] = $shop['id'];
  964. Dever::db('goods/card_code')->update($card_update);
  965. }*/
  966. return array
  967. (
  968. 'order' => '',
  969. 'order_num' => $order_data['order_num'],
  970. 'order_id' => $id,
  971. 'type' => 'test',
  972. );
  973. }
  974. $sell_config = Dever::db('main/sell_config')->one();
  975. # 分账
  976. $other = false;
  977. if (isset($shop['mid']) && $shop['mid']) {
  978. $other = array
  979. (
  980. 'mid' => $shop['mid'],
  981. 'order_id' => $order_data['order_num'] . '_' . $shop['id'],
  982. 'per' => $sell_config['per'],
  983. 'oprice' => $oprice,
  984. );
  985. }
  986. $param = array
  987. (
  988. 'project_id' => 1,
  989. 'channel_id' => 1,
  990. 'system_source' => $system_source,
  991. 'uid' => $uid,
  992. 'name' => $order_data['name'],
  993. 'cash' => $price,
  994. 'product_id' => $id,
  995. 'order_id' => $order_data['order_num'],
  996. 'other' => $other,
  997. 'refer' => $refer,
  998. );
  999. if ($uid > 0 && isset($wechat) && $wechat) {
  1000. $param['openid'] = $wechat['openid'];
  1001. }
  1002. $receipt = Dever::input('receipt');
  1003. if ($receipt) {
  1004. $param['receipt'] = $receipt;
  1005. }
  1006. $result = Dever::load('pay/api.pay', $param);
  1007. //$result['type'] = 'test';
  1008. //$result['order'] = '';
  1009. if ($cart) {
  1010. # 来自购物车,要清空一下
  1011. $this->dropCart($cart, $uid, $goods, $shop['id']);
  1012. }
  1013. # 使用优惠券
  1014. $this->useCoupon($order_data, $coupon_id, $user_coupon_id, $card, $wallet_cash);
  1015. $result['order_num'] = $order_data['order_num'];
  1016. $result['order_id'] = $id;
  1017. return $result;
  1018. }
  1019. public function dropCart($cart, $uid, $goods, $shop_id)
  1020. {
  1021. $where['uid'] = $uid;
  1022. $where['shop_id'] = $shop_id;
  1023. foreach ($goods as $k => $v) {
  1024. $where['goods_id'] = $v['id'];
  1025. if ($cart == 1) {
  1026. Dever::db('shop/cart')->delete($where);
  1027. } else {
  1028. unset($where['uid']);
  1029. Dever::db('shop/shop_cart')->delete($where);
  1030. }
  1031. }
  1032. }
  1033. public function useCoupon($order_data, $coupon_id, $user_coupon_id, $card, $wallet_cash)
  1034. {
  1035. if ($user_coupon_id) {
  1036. Dever::db('shop/user_coupon')->update(array('where_id' => $user_coupon_id, 'status' => 2));
  1037. }
  1038. # 使用礼品卡
  1039. if ($card) {
  1040. $state = Dever::db('card/code')->incUseCash(array('where_id' => $card['id'], 'set_use_cash' => $card['cash']));
  1041. # 生成结算单
  1042. $code = Dever::db('card/code')->find($card['id']);
  1043. if ($code) {
  1044. $card_info = Dever::db('card/info')->find($code['card_id']);
  1045. if ($card_info) {
  1046. if ($code['type'] == 2) {
  1047. $zhe = 0.9;
  1048. } else {
  1049. $zhe = $card_info['price']/$card_info['value'];
  1050. }
  1051. $price = round($card['cash']*$zhe, 2);
  1052. $order_data['type'] = 1;
  1053. $order_data['type_id'] = $order_data['shop_id'];
  1054. $order_data['source_type'] = 4;
  1055. $order_data['source_id'] = -1;
  1056. $order_data['price'] = $price;
  1057. $order_data['p_price'] = $card['cash'];
  1058. Dever::load('cash/lib/order')->up($order_data, 3, 1, false, 2);
  1059. }
  1060. }
  1061. } elseif ($wallet_cash) {
  1062. //$wallet_cash = -1*$wallet_cash;
  1063. Dever::load('shop/lib/money')->up($order_data['uid'], 12, $wallet_cash, $order_data['id'], '购买商品', 2);
  1064. $order_data['type'] = 1;
  1065. $order_data['type_id'] = $order_data['shop_id'];
  1066. $order_data['source_type'] = 4;
  1067. $order_data['source_id'] = -1;
  1068. $order_data['price'] = $wallet_cash;
  1069. $order_data['p_price'] = $wallet_cash;
  1070. Dever::load('cash/lib/order')->up($order_data, 3, 1, false, 3);
  1071. }
  1072. # 这里可以记录一下使用日志
  1073. }
  1074. # 再次发起支付
  1075. public function rpay($id, $system_source = 5, $refer = '')
  1076. {
  1077. $order = Dever::db('shop/sell_order')->find($id);
  1078. if (!$order) {
  1079. Dever::alert('订单信息错误');
  1080. }
  1081. if ($order['status'] > 1) {
  1082. Dever::alert('订单已支付或已取消');
  1083. }
  1084. $param = array
  1085. (
  1086. 'project_id' => 1,
  1087. 'channel_id' => 1,
  1088. 'system_source' => $system_source,
  1089. 'uid' => $order['uid'],
  1090. 'name' => $order['name'],
  1091. 'cash' => $order['price'],
  1092. 'product_id' => $id,
  1093. 'order_id' => $order['order_num'],
  1094. 'refer' => $refer,
  1095. );
  1096. $receipt = Dever::input('receipt');
  1097. if ($receipt) {
  1098. $param['receipt'] = $receipt;
  1099. }
  1100. $order = $this->getInfo($order);
  1101. $result = Dever::load('pay/api.pay', $param);
  1102. $result['order_time'] = $order['time'];
  1103. $result['order_price'] = $order['price'];
  1104. $result['order_num'] = $order['order_num'];
  1105. $result['order_id'] = $id;
  1106. return $result;
  1107. }
  1108. # 查询是否支付
  1109. public function cpay($id, $system_source = 5, $refer = '')
  1110. {
  1111. $order = Dever::db('shop/sell_order')->find($id);
  1112. if (!$order) {
  1113. Dever::alert('订单信息错误');
  1114. }
  1115. $result['order_num'] = $order['order_num'];
  1116. $result['order_id'] = $id;
  1117. if ($order['status'] > 1 && $order['status'] <= 6) {
  1118. # 已支付
  1119. $result['status'] = 1;
  1120. } else {
  1121. # 待支付
  1122. $result['status'] = 2;
  1123. }
  1124. return $result;
  1125. }
  1126. # 支付成功回调 安全加密 设置token
  1127. public function success_secure_api_token()
  1128. {
  1129. $project_id = Dever::input('pay_project_id');
  1130. $info = Dever::db('pay/project')->one($project_id);
  1131. if ($info) {
  1132. return $info['key'];
  1133. }
  1134. return 'shop_dever_2020';
  1135. }
  1136. # 支付成功回调 安全加密
  1137. public function success_secure_api($param = array())
  1138. {
  1139. $this->success($param);
  1140. }
  1141. # 支付成功回调
  1142. public function success($param = array())
  1143. {
  1144. $send = $param ? $param : Dever::preInput('pay_');
  1145. $product_id = $send['pay_product_id'];
  1146. $order_id = $send['pay_order_id'];
  1147. $status = $send['pay_status'];
  1148. $cash = $send['pay_cash'];
  1149. $msg = $send['pay_msg'];
  1150. $order = Dever::db('shop/sell_order')->one(array('id' => $product_id, 'time' => time()));
  1151. if ($order && $order['status'] == 1) {
  1152. $update = array();
  1153. if ($status == 2) {
  1154. # 生成自提码或者取件码
  1155. $update['code'] = $this->getCode();
  1156. if ($order['method'] == 1) {
  1157. $msg = '您有一件自提商品已订购成功,取件码:' . $update['code'];
  1158. } else {
  1159. $msg = '您有一件外送商品已订购成功,核销码:' . $update['code'];
  1160. # 分配配送信息
  1161. //$this->updatePs($order);
  1162. }
  1163. # 发消息
  1164. if (Dever::project('message') && $order['uid']) {
  1165. $shop = Dever::db('shop/info')->one($order['shop_id']);
  1166. $msg_param['type'] = 1;//消息类型1是订单消息
  1167. $msg_param['id'] = $order['id'];
  1168. $msg_param['name'] = $shop['name'];
  1169. $msg_param = Dever::json_encode($msg_param);
  1170. Dever::project('message') && Dever::load('message/lib/data')->push(-1, $order['uid'], '订购成功通知', $msg, 2, 1, false, $msg_param);
  1171. }
  1172. if ($order['pay_method'] == 2) {
  1173. if ($order['refund_cash'] > 0) {
  1174. $status = 6;
  1175. } else {
  1176. $status = 5;
  1177. }
  1178. $update['fdate'] = time();
  1179. }
  1180. $update['status'] = $status;
  1181. $update['where_id'] = $order['id'];
  1182. $update['paydate'] = time();
  1183. Dever::db('shop/sell_order')->update($update);
  1184. }
  1185. }
  1186. return 'ok';
  1187. }
  1188. # 添加配送信息
  1189. public function updatePs($order, $status = 1, $service_id = -1, $order_num = '')
  1190. {
  1191. $where['order_id'] = $order['id'];
  1192. $where['clear'] = true;
  1193. $data = Dever::db('shop/sell_order_ps')->find($where);
  1194. $service = array();
  1195. if ($service_id) {
  1196. $service['service_id'] = $service_id;
  1197. }
  1198. if ($order_num) {
  1199. $service['order_num'] = $order_num;
  1200. }
  1201. if (!$data) {
  1202. $insert = $where;
  1203. if ($service) {
  1204. $insert['service'][] = $service;
  1205. $insert['service'] = Dever::array_encode($insert['service']);
  1206. }
  1207. $insert['status'] = $status;
  1208. if ($status == 2) {
  1209. $insert['qu_date'] = time();
  1210. }
  1211. Dever::db('shop/sell_order_ps')->insert($insert);
  1212. } else {
  1213. $update = $where;
  1214. $update['where_id'] = $data['id'];
  1215. $update['status'] = $status;
  1216. if ($status == 2) {
  1217. $update['qu_date'] = time();
  1218. }
  1219. if ($status == 3) {
  1220. $update['qs_date'] = time();
  1221. }
  1222. if ($service) {
  1223. $data['service'] = Dever::array_decode($data['service']);
  1224. $update['service'] = $data['service'];
  1225. $update['service'][] = $service;
  1226. $insert['service'] = Dever::array_encode($update['service']);
  1227. }
  1228. Dever::db('shop/sell_order_ps')->update($update);
  1229. }
  1230. }
  1231. # 减少库存,增加销量
  1232. public function updateSell($order, $type = 1)
  1233. {
  1234. $where['order_id'] = $order['id'];
  1235. $where['status'] = 1;
  1236. $data = Dever::db('shop/sell_order_goods')->select($where);
  1237. if ($data) {
  1238. Dever::load('shop/lib/goods')->oper($order, $type, 2, $data);
  1239. }
  1240. }
  1241. # 完成
  1242. public function finish($info, $shop_id)
  1243. {
  1244. if ($info && $info['shop_id'] == $shop_id && $info['status'] <= 4) {
  1245. if ($info['refund_cash'] > 0) {
  1246. $status = 6;
  1247. } else {
  1248. $status = 5;
  1249. }
  1250. $state = Dever::db('shop/sell_order')->update(array('where_id' => $info['id'], 'status' => $status, 'fdate' => time()));
  1251. # 给用户发消息
  1252. if ($info['uid'] && $info['uid'] > 0) {
  1253. $shop = Dever::db('shop/info')->one($info['shop_id']);
  1254. $msg_param['type'] = 1;//消息类型1是订单消息
  1255. $msg_param['id'] = $info['id'];
  1256. $msg_param['name'] = $shop['name'];
  1257. $msg_param = Dever::json_encode($msg_param);
  1258. $msg = '您有一笔订单已签收,祝您用餐愉快~';
  1259. Dever::project('message') && Dever::project('message') && Dever::load('message/lib/data')->push(-1, $info['uid'], '订单完成通知', $msg, 2, 1, false, $msg_param);
  1260. }
  1261. if ($info['method'] == 2) {
  1262. Dever::load('shop/lib/sell')->updatePs($info, 3);
  1263. }
  1264. if ($info['card_code_id'] && $info['card_code_id'] > 0) {
  1265. # 更新礼品卡状态
  1266. $card_update['where_id'] = $info['card_code_id'];
  1267. $card_update['status'] = 4;
  1268. Dever::db('goods/card_code')->update($card_update);
  1269. Dever::load('cash/lib/order')->up($info, 3, 2, false, 2);
  1270. /*
  1271. $code = Dever::db('card/code')->find($info['card_code_id']);
  1272. if ($code) {
  1273. $card_info = Dever::db('card/info')->find($code['card_id']);
  1274. if ($card_info) {
  1275. if ($code['type'] == 2) {
  1276. $zhe = 0.9;
  1277. } else {
  1278. $zhe = $card_info['price']/$card_info['value'];
  1279. }
  1280. $price = round($info['card_code_cash']*$zhe, 2);
  1281. $info['type'] = 1;
  1282. $info['type_id'] = $info['shop_id'];
  1283. $info['source_type'] = 4;
  1284. $info['source_id'] = -1;
  1285. $info['price'] = $price;
  1286. $info['p_price'] = $info['card_code_cash'];
  1287. Dever::load('cash/lib/order')->up($info, 3, 2, false, 2);
  1288. }
  1289. }
  1290. */
  1291. } elseif (isset($info['wallet_cash']) && $info['wallet_cash'] && $info['wallet_cash'] > 0) {
  1292. Dever::load('cash/lib/order')->up($info, 3, 2, false, 3);
  1293. }
  1294. if ($info['shop_type'] == 2) {
  1295. $w['parent_type'] = 2;
  1296. $w['parent_order_id'] = $info['id'];
  1297. $w['status'] = 4;
  1298. $buy_order = Dever::db('shop/buy_order')->select($w);
  1299. if ($buy_order) {
  1300. foreach ($buy_order as $k => $v) {
  1301. Dever::load('mshop/lib/buy')->set(1,1)->finish($shop_id, $v['id']);
  1302. }
  1303. }
  1304. }
  1305. return 'ok';
  1306. } else {
  1307. Dever::alert('您没有权限核销');
  1308. }
  1309. }
  1310. # 平台订单已收货
  1311. public function yes_api()
  1312. {
  1313. $shop_id = Dever::input('shop_id');
  1314. $order_id = Dever::input('order_id');
  1315. $info = Dever::db('shop/sell_order')->find(array('id' => $order_id));
  1316. if ($info && $info['type'] == 10) {
  1317. $this->finish($info, $shop_id);
  1318. } else {
  1319. Dever::alert('您没有权限核销');
  1320. }
  1321. return 'reload';
  1322. }
  1323. # 生成自提码
  1324. public function getCode()
  1325. {
  1326. $where['code'] = Dever::rand(6, 0);
  1327. $state = Dever::db('shop/sell_order')->one($where);
  1328. if (!$state) {
  1329. return $where['code'];
  1330. } else {
  1331. return $this->getCode();
  1332. }
  1333. }
  1334. # 生成订单号
  1335. public function getOrderId()
  1336. {
  1337. $where['order_num'] = Dever::order('G');
  1338. $state = Dever::db('shop/sell_order')->one($where);
  1339. if (!$state) {
  1340. return $where['order_num'];
  1341. } else {
  1342. return $this->getOrderId();
  1343. }
  1344. }
  1345. # 展示订单详情
  1346. public function show()
  1347. {
  1348. $id = Dever::input('order_id');
  1349. $config = Dever::db('shop/sell_order')->config;
  1350. $info = Dever::db('shop/sell_order')->one($id);
  1351. $tk_status = Dever::db('shop/sell_order_refund')->config['status'];
  1352. $tk_process = Dever::db('shop/sell_order_refund')->config['process'];
  1353. $status = $config['status_manage'][$info['status']];
  1354. $tk = Dever::db('shop/sell_order_refund')->find(array('order_id' => $info['id'], 'type' => 1));
  1355. $shop = Dever::db('shop/info')->find($info['shop_id']);
  1356. $user = Dever::db('passport/user')->find($info['uid']);
  1357. $cdate = date('Y-m-d H:i', $info['cdate']);
  1358. if ($info['operdate']) {
  1359. $opertime = date('Y-m-d H:i', $info['operdate']);
  1360. } else {
  1361. $opertime = '';
  1362. }
  1363. if ($info['fdate'] && $info['fdate'] > 0) {
  1364. $fdate = date('Y-m-d H:i', $info['fdate']);
  1365. } else {
  1366. $fdate = '';
  1367. }
  1368. if (!$user) {
  1369. $user['username'] = '无';
  1370. }
  1371. if (!isset($user['truename'])) {
  1372. $user['truename'] = $user['username'];
  1373. }
  1374. if (!$info['coupon_cash']) {
  1375. $info['coupon_cash'] = 0;
  1376. }
  1377. if (!$info['discount_cash']) {
  1378. $info['discount_cash'] = 0;
  1379. }
  1380. if (!$info['kou_cash']) {
  1381. $info['kou_cash'] = 0;
  1382. }
  1383. if (!$info['ps_cash']) {
  1384. $info['ps_cash'] = 0;
  1385. }
  1386. if (!$info['wallet_cash']) {
  1387. $info['wallet_cash'] = 0;
  1388. }
  1389. if (!$info['card_code_cash']) {
  1390. $info['card_code_cash'] = 0;
  1391. }
  1392. if ($info['card_code_card']) {
  1393. $info['card_code_cash'] .= '('.$info['card_code_card'].')';
  1394. }
  1395. if ($tk && $tk['process'] == 1) {
  1396. $status = '申请' . $tk_status[$tk['status']];
  1397. $process = $tk_process[$tk['process']];
  1398. $process = '';
  1399. }
  1400. $time = array();
  1401. $time[] = array('下单时间', $cdate);
  1402. if ($opertime) {
  1403. if ($info['status'] == 2) {
  1404. $time[] = array('通知时间', $opertime);
  1405. }
  1406. if ($info['status'] == 7) {
  1407. $time[] = array('取消时间', $opertime);
  1408. }
  1409. }
  1410. if ($fdate) {
  1411. $time[] = array('完成时间', $fdate);
  1412. }
  1413. $result = array();
  1414. $info['card'] = '';
  1415. if ($info['card_code_id']) {
  1416. $code = Dever::db('card/code')->find($info['card_code_id']);
  1417. if ($code) {
  1418. $card_info = Dever::db('card/info')->find($code['card_id']);
  1419. if ($card_info) {
  1420. if (!$code['total_cash']) {
  1421. $code['total_cash'] = $card_info['value'];
  1422. }
  1423. $info['card'] = '(' . $card_info['name'] .$code['card']. ',面值:'.$code['total_cash'].', 剩余:'.round($code['total_cash']-$code['use_cash'], 2).')';
  1424. }
  1425. }
  1426. }
  1427. $result[$info['order_num']] = array
  1428. (
  1429. 'type' => 'info',
  1430. 'content' => array
  1431. (
  1432. array
  1433. (
  1434. array('订单状态', $status),
  1435. array('支付方式', $config['pay_method'][$info['pay_method']]),
  1436. array('配送方式', $config['method'][$info['method']]),
  1437. ),
  1438. array
  1439. (
  1440. array('门店名称', $shop['name']),
  1441. array('联系人', $shop['truename']),
  1442. array('联系电话', $shop['mobile']),
  1443. ),
  1444. array
  1445. (
  1446. array('下单用户', $user['username']),
  1447. array('联系电话', $info['mobile']),
  1448. array('订单备注', $info['info']),
  1449. ),
  1450. array
  1451. (
  1452. array('支付金额', '¥ ' . round($info['price'], 2)),
  1453. array('优惠券满减', '¥ ' . $info['coupon_cash']),
  1454. array('配送费', '¥ ' . $info['ps_cash']),
  1455. ),
  1456. array
  1457. (
  1458. array('礼品卡抵扣', '¥ ' . round($info['card_code_cash'], 2) . $info['card']),
  1459. array('钱包抵扣', '¥ ' . round($info['wallet_cash'], 2)),
  1460. array('抹零', '¥ ' . round($info['kou_cash'], 2)),
  1461. array('代理优惠', '¥ ' . round($info['discount_cash'], 2)),
  1462. ),
  1463. $time,
  1464. )
  1465. );
  1466. if ($info['address_id'] > 0) {
  1467. $address = Dever::load('passport/address')->getOne($info['uid'], $info['address_id']);
  1468. if ($address) {
  1469. $result['收货地址'] = array
  1470. (
  1471. 'type' => 'info',
  1472. 'content' => array
  1473. (
  1474. array
  1475. (
  1476. array('联系人', $address['contact']),
  1477. array('联系电话', $address['mobile']),
  1478. ),
  1479. array
  1480. (
  1481. array('收货地址', $address['address_info']),
  1482. array('门牌号', $address['house_number']),
  1483. ),
  1484. ),
  1485. );
  1486. }
  1487. }
  1488. if ($info['invoice_id'] > 0) {
  1489. $invoice = Dever::load('passport/invoice')->getOne($info['uid'], $info['invoice_id']);
  1490. if ($invoice) {
  1491. $result['发票信息'] = array
  1492. (
  1493. 'type' => 'info',
  1494. 'content' => array
  1495. (
  1496. array
  1497. (
  1498. array('发票类型', $invoice['title_type_name']),
  1499. array('抬头', $invoice['title']),
  1500. array('税号', $invoice['number']),
  1501. ),
  1502. array
  1503. (
  1504. array('手机号', $invoice['mobile']),
  1505. array('邮箱', $invoice['email']),
  1506. ),
  1507. ),
  1508. );
  1509. }
  1510. }
  1511. $audit = Dever::input('audit');
  1512. if ($audit == 1) {
  1513. # 审核信息
  1514. $this->show_audit($info, $result);
  1515. } else {
  1516. # 配送信息
  1517. $this->show_ps($info, $result);
  1518. # 退款信息
  1519. $this->show_refund($info, $result, $tk, $tk_process);
  1520. # 商品信息
  1521. $this->show_goods($info, $result, $tk_status);
  1522. # 对账信息
  1523. $this->show_dz($info, $result);
  1524. }
  1525. $button = array();
  1526. if (Dever::load('manage/auth')->checkFunc('menu_61.menu_218', 'editaddress', '修改地址')) {
  1527. if ($info['address_id']>0){
  1528. $button[0]['btn'][] = array
  1529. (
  1530. 'type' => 'edit',
  1531. 'link' => Dever::url('project/database/update?project=passport&table=address&where_id='.$info['address_id'].'&status=1&col=contact,mobile,area,address,house_number', 'manage'),
  1532. 'name' => '修改地址',
  1533. );
  1534. }
  1535. }
  1536. $head = array
  1537. (
  1538. 'name' => '基本信息',
  1539. 'btn' => array(),
  1540. );
  1541. $foot = $button;
  1542. $html = Dever::show($head, $result,$foot);
  1543. return $html;
  1544. }
  1545. private function show_goods($info, &$result, $tk_status)
  1546. {
  1547. $body = $refund_body = array();
  1548. $body_total = array();
  1549. $body_total['price'] = 0;
  1550. $body_total['num'] = 0;
  1551. $refund_body_total = array();
  1552. $refund_body_total['price'] = 0;
  1553. $refund_body_total['num'] = 0;
  1554. $goods = Dever::db('shop/sell_order_goods')->select(array('order_id' => $info['id']));
  1555. $goods_status = Dever::db('shop/sell_order_goods')->config['status'];
  1556. foreach ($goods as $k => $v) {
  1557. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  1558. $status = $goods_status[$v['status']];
  1559. $tk = Dever::db('shop/sell_order_refund')->find(array('order_id' => $info['id'], 'order_goods_id' => $v['id'], 'type' => 2));
  1560. if ($tk && $tk['process'] == 1) {
  1561. $status = '申请' . $tk_status[$tk['status']];
  1562. //$status .= '&nbsp;&nbsp;[' . $tk_process[$tk['process']] . ']';
  1563. }
  1564. if (isset($goods_info['sku'])) {
  1565. $sku = $goods_info['sku']['string'];
  1566. } else {
  1567. $sku = '无';
  1568. }
  1569. if ($info['shop_type'] == 2 && $info['status'] > 1 && $info['status'] < 7) {
  1570. $tui = Dever::url('buy_order_tui?shop_id='.$v['shop_id'].'&order_goods_id=' . $v['id'] . '&order_id=' . $info['id'] . '&cash=' . $v['price'], 'shop');
  1571. $status = '<a href="javascript:;" onclick="fastEdit($(this), \''.$tui.'\', \'退款\', \'\', 1)" class="layui-btn">退款</a>';
  1572. }
  1573. $d = array
  1574. (
  1575. 'pic' => $goods_info['cover'],
  1576. 'name' => $goods_info['name'],
  1577. 'sku' => $sku,
  1578. 'price' => $v['price'],
  1579. 'num' => $v['num'] . $goods_info['unit'],
  1580. 'status' => $status,
  1581. );
  1582. if ($goods_info['price_type'] > 2) {
  1583. $d['goods'] = $goods_info['goods'];
  1584. }
  1585. if ($tk && $v['status'] == 3) {
  1586. $d['status'] = $tk_status[$tk['status']];
  1587. $refund_body[] = $d;
  1588. $price = $v['price']*$v['num'];
  1589. $refund_body_total['price'] += $price;
  1590. $refund_body_total['num'] += $v['num'];
  1591. } else {
  1592. $body[] = $d;
  1593. $price = $v['price']*$v['num'];
  1594. $body_total['price'] += $price;
  1595. $body_total['num'] += $v['num'];
  1596. }
  1597. }
  1598. if ($body) {
  1599. if ($refund_body_total['price']) {
  1600. $body_total['set_price'] = $body_total['price'] - $refund_body_total['price'];
  1601. }
  1602. if ($refund_body_total['num']) {
  1603. $body_total['set_num'] = $body_total['num'] - $refund_body_total['num'];
  1604. }
  1605. $result['商品清单'] = array
  1606. (
  1607. 'type' => 'list',
  1608. 'content' => $body,
  1609. 'total' => $body_total,
  1610. );
  1611. }
  1612. if ($refund_body) {
  1613. $result['退款商品'] = array
  1614. (
  1615. 'type' => 'list',
  1616. 'content' => $refund_body,
  1617. 'total' => $refund_body_total,
  1618. );
  1619. }
  1620. }
  1621. private function show_dz($info, &$result)
  1622. {
  1623. $search_option_shop_type = Dever::input('search_option_shop_type');
  1624. if ($search_option_shop_type == 2) {
  1625. # 平台门店采购单
  1626. $buy_order = Dever::db('shop/buy_order')->getDataToId(array('type' => 1, 'type_id' => $info['shop_id'], 'parent_type' => 2, 'parent_order_id' => $info['id']));
  1627. $source_order_id = array();
  1628. if ($buy_order) {
  1629. $source_order_id = array_keys($buy_order);
  1630. }
  1631. # 平台门店结算单
  1632. if ($source_order_id) {
  1633. $cash_order = Dever::db('cash/order')->getDataByOrderId(array('source_order_id' => $source_order_id));
  1634. $col = 'cash';
  1635. }
  1636. }
  1637. if (isset($cash_order) && $cash_order) {
  1638. $head = array('序号', '结算单号', '数量', '金额', '结算类型', '入账状态', '审核状态', '结算时间', '审核备注', '管理');
  1639. $body = array();
  1640. $config = Dever::db('cash/order')->config;
  1641. foreach ($cash_order as $k => $v) {
  1642. $cdate = date('Y-m-d H:i', $v['cdate']);
  1643. $fdate = $v['fdate'] ? date('Y-m-d H:i', $v['fdate']) : '';
  1644. $operdate = $v['operdate'] ? date('Y-m-d H:i', $v['operdate']) : '';
  1645. $cash = $v[$col];
  1646. $url = Dever::url('project/database/list?project=shop&table=buy_order_goods&order_id='.$v['source_order_id'].'&page_type=1', 'manage');
  1647. $v['source_order_num'] = '<a href="'.$url.'" style="color:blue">'.$v['source_order_num'].'</a>';
  1648. $m = '';
  1649. if ($v['audit'] == 1 && $v['audit_type'] == 2) {
  1650. $url = Dever::url('project/database/update?project=cash&table=order&where_id='.$v['id'].'&col=audit,desc', 'manage');
  1651. $m = '<a href="javascript:;" onclick="fastEdit($(this), \''.$url.'\', \'审核\', \'\', 1)" class="layui-btn">审核</a>';
  1652. }
  1653. $d = array
  1654. (
  1655. $k+1,
  1656. $v['order_num'],
  1657. $v['num'],
  1658. $cash,
  1659. $config['config_jstype'][$v['jstype']],
  1660. $config['config_status'][$v['status']],
  1661. $config['config_audit'][$v['audit']],
  1662. $operdate,
  1663. $v['desc'],
  1664. $m,
  1665. );
  1666. $body[] = $d;
  1667. }
  1668. $result['对账清单'] = array
  1669. (
  1670. 'type' => 'table',
  1671. 'content' => array
  1672. (
  1673. 'head' => $head,
  1674. 'body' => $body,
  1675. )
  1676. );
  1677. }
  1678. }
  1679. private function show_refund($info, &$result, $tk, $tk_process)
  1680. {
  1681. if (!$info['refund_cash']) {
  1682. $info['refund_cash'] = 0;
  1683. }
  1684. if ($info['refund_cash'] > 0 && $tk) {
  1685. $process = $tk_process[$tk['process']];
  1686. $tk['cdate'] = date('Y-m-d H:i', $tk['cdate']);
  1687. $result['退款信息'] = array
  1688. (
  1689. 'type' => 'info',
  1690. 'content' => array
  1691. (
  1692. array
  1693. (
  1694. array('退款金额', $info['refund_cash']),
  1695. array('数量', $info['num']),
  1696. array('退款进度', $process),
  1697. ),
  1698. array
  1699. (
  1700. array('申请时间', $tk['cdate']),
  1701. array('退款原因', $tk['desc']),
  1702. ),
  1703. ),
  1704. );
  1705. }
  1706. }
  1707. private function show_ps($info, &$result)
  1708. {
  1709. $info['ps_info'] = Dever::db('shop/sell_order_ps')->find(array('order_id' => $info['id']));
  1710. if ($info['ps_info']) {
  1711. $info['ps_info']['service'] = Dever::array_decode($info['ps_info']['service']);
  1712. $info['ps_info']['cdate'] = date('Y-m-d H:i', $info['ps_info']['cdate']);
  1713. if ($info['ps_info']['qs_date']) {
  1714. $info['ps_info']['qs_date'] = date('Y-m-d H:i', $info['ps_info']['qs_date']);
  1715. } else {
  1716. $info['ps_info']['qs_date'] = '无';
  1717. }
  1718. $status = Dever::db('shop/sell_order_ps')->config['status'];
  1719. $info['ps_info']['status_name'] = $status[$info['ps_info']['status']];
  1720. $service = array();
  1721. if ($info['ps_info']['service']) {
  1722. foreach ($info['ps_info']['service'] as $k => $v) {
  1723. if (isset($v['order_num']) && $v['order_num']) {
  1724. $info['ps_info']['service'][$k]['service_name'] = '商家自送';
  1725. if ($v['service_id'] > 0) {
  1726. $service_info = Dever::db('shop/service')->find($v['service_id']);
  1727. $info['ps_info']['service'][$k]['service_name'] = $service_info['name'];
  1728. }
  1729. $service[] = array
  1730. (
  1731. array('名称', $info['ps_info']['service'][$k]['service_name']),
  1732. array('单号', isset($v['order_num']) ? $v['order_num'] : ''),
  1733. );
  1734. }
  1735. }
  1736. }
  1737. $result['物流信息'] = array
  1738. (
  1739. 'type' => 'info',
  1740. 'content' => array
  1741. (
  1742. array
  1743. (
  1744. array('发货时间', $info['ps_info']['cdate']),
  1745. array('收货时间', $info['ps_info']['qs_date']),
  1746. array('查单', '<a href="https://www.kuaidi100.com/?from=openv" target="_blank">点此手动查单</a>'),
  1747. ),
  1748. ),
  1749. );
  1750. $result['物流信息']['content'] = array_merge($result['物流信息']['content'], $service);
  1751. }
  1752. }
  1753. private function show_audit($info, &$result)
  1754. {
  1755. $info['type'] = 1;
  1756. $goods = Dever::db('shop/sell_order_goods')->select(array('order_id' => $info['id'], 'status' => 1));
  1757. $shop = Dever::db('shop/info')->find($info['shop_id']);
  1758. list($data, $source) = Dever::load('mshop/lib/buy')->assign($goods, $info, $shop, true);
  1759. if ($info) {
  1760. $head = array('序号', '商品编号', '商品名称', '供货商', '订货总数量', '商品计量单位', '订货单总金额');
  1761. $body = array();
  1762. $i = 0;
  1763. if ($data) {
  1764. foreach ($data as $k => $v) {
  1765. foreach ($v as $v1) {
  1766. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v1['goods_id'], $v1['sku_id']);
  1767. if (isset($goods_info['sku'])) {
  1768. $sku = '[' . $goods_info['sku']['string'] . ']';
  1769. } else {
  1770. $sku = '';
  1771. }
  1772. $d = array
  1773. (
  1774. $i+1,
  1775. $goods_info['code'],
  1776. $goods_info['name'] . $sku,
  1777. Dever::load('mshop/lib/buy')->getSelect($source, $v1['source_id'], $v1['order_goods_id']),
  1778. $v1['num'],
  1779. $goods_info['unit'],
  1780. $v1['price'] * $v1['num'],
  1781. );
  1782. $body[] = $d;
  1783. $i++;
  1784. }
  1785. }
  1786. }
  1787. if ($goods) {
  1788. foreach ($goods as $k => $v) {
  1789. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  1790. if (isset($goods_info['sku'])) {
  1791. $sku = '[' . $goods_info['sku']['string'] . ']';
  1792. } else {
  1793. $sku = '';
  1794. }
  1795. $d = array
  1796. (
  1797. $i+1,
  1798. $goods_info['code'],
  1799. $goods_info['name'] . $sku,
  1800. Dever::load('mshop/lib/buy')->getSelect($source, false, $v['id']),
  1801. $v['num'],
  1802. $goods_info['unit'],
  1803. $v['price'] * $v['num'],
  1804. );
  1805. $body[] = $d;
  1806. $i++;
  1807. }
  1808. }
  1809. $btn = array();
  1810. $btn[] = array(
  1811. 'type' => 'click',
  1812. 'content' => 'setAudit()',
  1813. 'name' => '全部调整<script>function setAudit(){layer.confirm(\'确定进行此项操作吗?\', function(){var audit = $(\'.audit_set\').val();$(\'.audit\').each(function(){$(this).val(audit);layui.form.render();layer.closeAll()})})}</script>'
  1814. );
  1815. $result['商品拆单'] = array
  1816. (
  1817. 'type' => 'table',
  1818. 'head' => array('name' => '供货商:' . Dever::load('mshop/lib/buy')->getSelect($source, false, false), 'btn' => $btn),
  1819. 'content' => array
  1820. (
  1821. 'head' => $head,
  1822. 'body' => $body,
  1823. )
  1824. );
  1825. $url = Dever::url('lib/sell.audit_set_commit?json=1&order_id=' . $info['id'], 'shop');
  1826. $result['审核结果'] = array
  1827. (
  1828. 'type' => 'html',
  1829. 'content' => '<script>function saveAudit(){var goods = [];var audit = 1; var audit_text = $(".update_audit_text").val();$(".update_audit").each(function(){if ($(this).get(0).checked){audit = $(this).val()}});$(\'.audit\').each(function(){var v = $(this).val();var id = $(this).attr("id");goods.push(v + "_" + id);});layer.confirm(\'确定进行此项操作吗?\', function(){layui.form.render();var send = {};send.goods = goods.join(",");send.audit = audit;send.audit_text = audit_text;console.info(send);$.post("'.$url.'", send, function(t){t = JSON.parse(t);showYes(t)})})}</script><style>.layui-form-radio{padding-right: 0px;margin: 0px 0px 0 0;margin-left:40px}</style><div class="layui-form-item show_input"><div classs="layui-col-lg6"><div><label style="font-size:14px;font-weight:bold;" class="">审核状态</label><div style="display:inline" class="am-btn-group"><input update_type="checked" class="checkbox-checkall-0_update_audit update_audit update_value validate[required]" type="radio" name="update_audit[]" value="2" checked="" show_id="audit" autocomplete="off" id="form-validation-field-1"> 审核通过 &nbsp;&nbsp;<input update_type="checked" class="autoload checkbox-checkall-0_update_audit update_audit update_value validate[required]" type="radio" name="update_audit[]" value="3" autocomplete="off" id="form-validation-field-0"> 审核未通过 &nbsp;&nbsp;</div></div></div></div><div class="layui-form-item" style="display: block;"><div classs="layui-col-lg6"><div><label style="font-size:14px;font-weight:bold;" class="">审核备注</label></div><div><textarea style="height:100px;" update_type="value" class="update_value update_audit_text form-control layui-input validate[required]" name="update_desc"></textarea></div></div></div> <div style="text-align:left" class="layui-layer-btn layui-layer-btn-"><a class="layui-btn layui-btn-primary" onclick="saveAudit()">保存</a><a class="layui-layer-btn1" style="display:none">取消</a></div>',
  1830. );
  1831. }
  1832. }
  1833. # 第三方确认
  1834. public function tixian()
  1835. {
  1836. $param = array();
  1837. ksort($param);
  1838. $string = array();
  1839. foreach ($param as $k => $v) {
  1840. if (strstr($v, '&') || strstr($v, '@')) {
  1841. $v = urlencode($v);
  1842. }
  1843. $string[] = $k . '=' . $v;
  1844. }
  1845. }
  1846. # 发货
  1847. public function notice($info)
  1848. {
  1849. $config = Dever::db('shop/sell_order')->config;
  1850. $state = Dever::db('shop/sell_order')->update(array('where_id' => $info['id'], 'status' => 3, 'operdate' => time()));
  1851. # 给用户发消息
  1852. if ($info['uid'] && $info['uid'] > 0) {
  1853. $shop = Dever::db('shop/info')->one($info['shop_id']);
  1854. $msg_param['type'] = 1;//消息类型1是订单消息
  1855. $msg_param['id'] = $info['id'];
  1856. $msg_param['name'] = $shop['name'];
  1857. $msg_param = Dever::json_encode($msg_param);
  1858. if ($info['method'] == 1) {
  1859. $msg = '您有一件自提商品已完成配货,请尽快到指定门店使用取件码取货,取件码:' . $info['code'];
  1860. $name = '取货通知';
  1861. $wechat_msg = '您的商品已完成配货';
  1862. } else {
  1863. $msg = '您有一件外送商品已开始配送,收货时请将取件码提供给配送员核实货品信息,取件码:' . $info['code'];
  1864. $name = '配送通知';
  1865. $wechat_msg = '您的商品已开始配送';
  1866. }
  1867. Dever::project('message') && Dever::load('message/lib/data')->push(-1, $info['uid'], $name, $msg, 2, 1, false, $msg_param);
  1868. if (Dever::project('wechat_applet')) {
  1869. $user = Dever::db('passport/wechat')->one(array('uid' => $info['uid'], 'system_id' => 1, 'system_source' => 5));
  1870. if ($user && $user['openid']) {
  1871. $info['status_name'] = $config['status'][$info['status']];
  1872. $send = array
  1873. (
  1874. 'character_string6' => array
  1875. (
  1876. 'value' => $info['order_num'],
  1877. ),
  1878. 'phrase7' => array
  1879. (
  1880. 'value' => $info['status_name'],
  1881. ),
  1882. 'thing8' => array
  1883. (
  1884. 'value' => $info['code'],
  1885. ),
  1886. 'amount1' => array
  1887. (
  1888. 'value' => $info['price'] . '元',
  1889. ),
  1890. 'thing5' => array
  1891. (
  1892. 'value' => $wechat_msg,
  1893. ),
  1894. );
  1895. $send = Dever::json_encode($send);
  1896. Dever::load('wechat_applet/subscribe')->sendOne('order_process', 1, $user['openid'], 'pages/app/order/order?id=' . $info['id'], $send, Dever::config('base')->wechat_applet);
  1897. }
  1898. }
  1899. }
  1900. }
  1901. # 采购订单审核 手动拆单
  1902. public function audit_set_commit_api()
  1903. {
  1904. Dever::config('base')->hook = true;
  1905. //{goods: "2_4_audit_615,2_4_audit_614,-1_-1_audit_617,-1_-1_audit_616,-1_-1_audit_613", audit: "1", audit_text: "1231"}
  1906. $id = Dever::input('order_id');
  1907. $goods = Dever::input('goods');
  1908. $audit = Dever::input('audit');
  1909. $audit_text = Dever::input('audit_text');
  1910. $info = Dever::db('shop/sell_order')->one($id);
  1911. if ($audit > 1 && $info && $info['status'] == 2) {
  1912. $shop = Dever::db('shop/info')->find($info['shop_id']);
  1913. if ($audit == 2) {
  1914. Dever::db('shop/sell_order')->update(array('where_id' => $info['id'], 'audit' => $audit, 'audit_desc' => $audit_text));
  1915. # 成功
  1916. if (strstr($info['order_num'], '_')) {
  1917. $temp = explode('_', $info['order_num']);
  1918. $info['order_num'] = $temp[0];
  1919. $info['order_index'] = $temp[1];
  1920. } else {
  1921. $info['order_index'] = 0;
  1922. }
  1923. $goods = explode(',', $goods);
  1924. $data = $other = array();
  1925. foreach ($goods as $k => $v) {
  1926. list($source_type, $source_id, $name, $goods_id) = explode('_', $v);
  1927. $gv = Dever::db('shop/sell_order_goods')->find($goods_id);
  1928. if ($source_id > 0) {
  1929. $key = $source_type . '_' . $source_id;
  1930. $data[$key][] = array
  1931. (
  1932. 'area' => $shop['area'],
  1933. 'order_id' => $info['id'],
  1934. 'order_type' => 2,
  1935. 'order_num' => $info['order_num'],
  1936. 'order_index' => $info['order_index'],
  1937. 'type' => 1,
  1938. 'type_id' => $shop['id'],
  1939. 'source_type' => $source_type,
  1940. 'source_id' => $source_id,
  1941. 'order_goods_id' => $gv['id'],
  1942. 'goods_id' => $gv['goods_id'],
  1943. 'sku_id' => $gv['sku_id'],
  1944. 'price' => $gv['price'],
  1945. 'p_price' => $gv['price'],
  1946. 'num' => $gv['num'],
  1947. );
  1948. } else {
  1949. $other[] = $gv;
  1950. }
  1951. }
  1952. $this->audit_action($data, $other, $info, $shop, 1);
  1953. } else {
  1954. Dever::db('shop/sell_order')->update(array('where_id' => $info['id'], 'audit' => $audit, 'audit_desc' => $audit_text));
  1955. # 退款
  1956. $shop = Dever::db('shop/info')->find($info['shop_id']);
  1957. Dever::load('shop/lib/refund')->set('sell')->apply(2, $shop['id'], $id, false, 3, 0, '未通过审核');
  1958. }
  1959. }
  1960. return Dever::url('project/database/list&project=shop&table=sell_order&menu=shop&search_option_state=1&search_option_shop_type=2&menu_id=218', 'manage');
  1961. }
  1962. # 采购订单审核 拆单
  1963. public function audit_commit()
  1964. {
  1965. $order_id = Dever::input('order_id');
  1966. $order = Dever::db('shop/sell_order')->find($order_id);
  1967. if (!$order || ($order && $order['status'] != 2)) {
  1968. Dever::alert('当前订单状态无法拆单');
  1969. }
  1970. if ($order['shop_type'] != 2) {
  1971. Dever::alert('这不是平台店的订单');
  1972. }
  1973. $order['type'] = 2;
  1974. $goods = Dever::db('shop/sell_order_goods')->select(array('order_id' => $order_id));
  1975. $shop = Dever::db('shop/info')->find($order['shop_id']);
  1976. $data = Dever::load('mshop/lib/buy')->assign($goods, $order, $shop);
  1977. $this->audit_action($data, $goods, $order, $shop);
  1978. return 'ok';
  1979. }
  1980. private function audit_action($data, $goods, $order, $shop, $state = 2)
  1981. {
  1982. $send = array();
  1983. if (!$goods && $data) {
  1984. # 开始生成订单
  1985. $i = $order['order_index'];
  1986. foreach ($data as $k => $v) {
  1987. foreach ($v as $k1 => $v1) {
  1988. $v1['order_num'] .= '_' . $i;
  1989. $state = Dever::load('mshop/lib/buy')->createOrder($v1);
  1990. $send[$state] = $v1;
  1991. }
  1992. $i++;
  1993. }
  1994. Dever::db('shop/sell_order')->update(array('where_id' => $order['id'], 'status' => 3));
  1995. } else {
  1996. Dever::db('shop/sell_order')->update(array('where_id' => $order['id'], 'audit' => 1));
  1997. if ($goods) {
  1998. $string = array();
  1999. foreach ($goods as $k => $v) {
  2000. $info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  2001. if ($info['sku_name']) {
  2002. $info['name'] .= '('.$info['sku_name'].')';
  2003. }
  2004. $string[] = $info['name'];
  2005. }
  2006. $string = implode('、', $string);
  2007. if ($state == 1) {
  2008. Dever::alert('商品:'.$string.'未选择供货商');
  2009. } else {
  2010. Dever::alert('商品:'.$string.'库存不足或厂家未生产,请联系供货商备货,该订单进入重新审核状态');
  2011. }
  2012. Dever::alert('商品:'.$string.'库存不足或厂家未生产,请联系供货商备货,该订单进入重新审核状态');
  2013. } else {
  2014. if ($state == 1) {
  2015. Dever::alert('未选择供货商,该订单进入重新审核状态');
  2016. } else {
  2017. Dever::alert('供货商库存不足,请联系供货商备货,该订单进入重新审核状态');
  2018. }
  2019. }
  2020. }
  2021. if ($send) {
  2022. foreach ($send as $k => $v) {
  2023. Dever::load('mshop/lib/buy')->sendMsg($v['source_type'], $v['source_id'], $k);
  2024. $order_info = Dever::db('shop/buy_order')->find(array('id' => $k, 'clear' => true));
  2025. Dever::load('cash/lib/order')->up($order_info, 1, 1);
  2026. }
  2027. }
  2028. }
  2029. }