Goodup.php 40 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860
  1. <?php
  2. namespace app\youzan\logic;
  3. use app\admin\model\ActionLog;
  4. use app\admin\model\ProcessOrder;
  5. use app\txx\model\YzGood;
  6. use app\youzan\model\PlatformYouzan;
  7. use think\Exception;
  8. use think\facade\Cache;
  9. use think\facade\Db;
  10. //商品处理层
  11. class Goodup
  12. {
  13. private static $offline_result_info_id = '0024';//从有赞平台下架商品的原因编码,注意环境不同,编码可能不同,生产环境是0024,测试环境是0021
  14. //提交商品上线
  15. public static function create(array $data = [])
  16. {
  17. $isonline = [];
  18. $i = 0;
  19. Db::startTrans();
  20. try {
  21. $all_list = Db::name("platform_youzan")
  22. ->where(["platform_id" => $data['platform_id'], "is_del" => PlatformYouzan::$del_normal])
  23. ->whereIn('spuCode', array_column($data['good_data'], 'spuCode'))
  24. ->column('id,exam_status', 'spuCode');
  25. $all_nake = Db::name("good_nake")
  26. ->where(["min_num" => 1, "is_del" => 0])
  27. ->whereIn('spuCode', array_column($data['good_data'], 'spuCode'))
  28. ->column('id', 'spuCode');
  29. foreach ($data['good_data'] as $value) {
  30. // $count = Db::name("good_nake")->where(["spuCode" => $value['spuCode'], "is_del" => 0])->count();
  31. //校验是否存在起订量为1的信息
  32. if (empty($all_nake[$value['spuCode']])) {
  33. $god = Db::name("good_basic")
  34. ->field('id,good_name,good_thumb_img,chargerid')
  35. ->where(["spuCode" => $value['spuCode'], "is_del" => 0])
  36. ->find();
  37. if ($god) {
  38. $tp = [];
  39. $tp['spuCode'] = $value['spuCode'];
  40. $tp['good_name'] = $god['good_name'];
  41. $tp['good_img'] = $god['good_thumb_img'];
  42. // $tp['exam_status'] = $ist['exam_status'];
  43. $spec = Db::name("good_spec")->where(["spuCode" => $value['spuCode'], "is_del" => 0])->select()->toArray();
  44. $speclist = [];
  45. if (!empty($spec)) {
  46. foreach ($spec as $val) {
  47. $temp = [];
  48. $temp['id'] = $val['id'];
  49. $temp['spuCode'] = $val['spuCode'];
  50. $temp['spec_id'] = $val['spec_id'];
  51. $temp['spec_value_id'] = $val['spec_value_id'];
  52. $temp['is_del'] = $val['is_del'];
  53. $sp = Db::name("specs")->where(["id" => $val['spec_id']])->find();
  54. $temp['spec_name'] = isset($sp["spec_name"]) ? $sp["spec_name"] : "";
  55. $spv = Db::name("spec_value")->where(["id" => $val['spec_value_id']])->find();
  56. $temp['spec_value'] = isset($spv["spec_value"]) ? $spv["spec_value"] : "";
  57. $speclist[] = $temp;
  58. }
  59. }
  60. $tp["speclist"] = empty($speclist) ? [] : $speclist;
  61. $is_no_1[] = $tp;
  62. }
  63. }
  64. if (!empty($is_no_1)) {
  65. Db::rollback();
  66. return app_show(1010, "存在起订量不为1的商品", $is_no_1);
  67. }
  68. //校验是否存在上线
  69. $ist = isset($all_list[$value['spuCode']]) ? $all_list[$value['spuCode']] : [];
  70. if ($ist) {
  71. $god = Db::name("good_basic")
  72. ->field('id,good_name,good_thumb_img,chargerid')
  73. ->where(["spuCode" => $value['spuCode'], "is_del" => 0])
  74. ->find();
  75. if ($god) {
  76. $tp = [];
  77. $tp['spuCode'] = $value['spuCode'];
  78. $tp['good_name'] = $god['good_name'];
  79. $tp['good_img'] = $god['good_thumb_img'];
  80. $tp['exam_status'] = $ist['exam_status'];
  81. $spec = Db::name("good_spec")->where(["spuCode" => $value['spuCode'], "is_del" => 0])->select()->toArray();
  82. $speclist = [];
  83. if (!empty($spec)) {
  84. foreach ($spec as $val) {
  85. $temp = [];
  86. $temp['id'] = $val['id'];
  87. $temp['spuCode'] = $val['spuCode'];
  88. $temp['spec_id'] = $val['spec_id'];
  89. $temp['spec_value_id'] = $val['spec_value_id'];
  90. $temp['is_del'] = $val['is_del'];
  91. $sp = Db::name("specs")->where(["id" => $val['spec_id']])->find();
  92. $temp['spec_name'] = isset($sp["spec_name"]) ? $sp["spec_name"] : "";
  93. $spv = Db::name("spec_value")->where(["id" => $val['spec_value_id']])->find();
  94. $temp['spec_value'] = isset($spv["spec_value"]) ? $spv["spec_value"] : "";
  95. $speclist[] = $temp;
  96. }
  97. }
  98. $tp["speclist"] = empty($speclist) ? [] : $speclist;
  99. $isonline[] = $tp;
  100. }
  101. }
  102. if (!empty($isonline)) {
  103. Db::rollback();
  104. return app_show(1009, "存在已上线产品", $isonline);
  105. }
  106. //改变编码规则,将原来的skuCode后两位换成序列号
  107. //str_pad字符串填充
  108. $skuCode = makeNo("SN");
  109. $skuCode = substr($skuCode, 0, -2) . str_pad($i, 2, '0', STR_PAD_LEFT);
  110. $tmp = [
  111. "platform_id" => $data['platform_id'],
  112. "online_reason" => $data['online_reason'],
  113. "online_remark" => $data['online_remark'],
  114. "spuCode" => $value['spuCode'],
  115. "skuCode" => $skuCode,
  116. "exam_status" => PlatformYouzan::$exam_status_0,
  117. "is_del" => PlatformYouzan::$del_normal,
  118. "createrid" => $data['createrid'],
  119. "creater" => $data['creater'],
  120. "updaterid" => $data['createrid'],
  121. "updater" => $data['creater'],
  122. "addtime" => date("Y-m-d H:i:s"),
  123. "updatetime" => date("Y-m-d H:i:s")
  124. ];
  125. $i++;
  126. //修改状态,添加待办
  127. $create = Db::name("platform_youzan")->insert($tmp, true);
  128. if ($create > 0) {
  129. Db::name("good_platform")->insert([
  130. "spuCode" => $value['spuCode'],
  131. "skuCode" => $skuCode,
  132. 'platform_code' => $data['platform_id'],
  133. "online_reason" => $data['online_reason'],
  134. "online_remark" => $data['online_remark'],
  135. "exam_status" => 0,
  136. 'is_online' => 0,
  137. "status" => 1,
  138. "is_del" => 0,
  139. "addtime" => date("Y-m-d H:i:s"),
  140. "updatetime" => date("Y-m-d H:i:s"),
  141. "creater" => $data['creater'],
  142. "createrid" => $data['createrid'],
  143. ]);
  144. ActionLog::logAdd(['id' => $data['createrid'], 'nickname' => $data['creater']], [
  145. "order_code" => $skuCode,
  146. "status" => $tmp['exam_status'],//这里的status是之前的值
  147. "action_remark" => '',//备注
  148. "action_type" => "create"//新建create,编辑edit,更改状态status
  149. ], "YZSX", $tmp['exam_status'], $tmp);
  150. ProcessOrder::AddProcess(['id' => $data['createrid'], 'nickname' => $data['creater']], [
  151. "order_type" => 'YZSX',
  152. "order_code" => $skuCode,
  153. "order_id" => $create,
  154. "order_status" => $tmp['exam_status'],
  155. "before_status" => $tmp['exam_status'],
  156. 'holder_id' => Db::name('good_basic')->where(["spuCode" => $value['spuCode'], "is_del" => 0])->value('chargerid', 0),
  157. ]);
  158. $iso = Db::name("good")->where(["spuCode" => $value['spuCode'], "is_del" => 0])->find();
  159. if ($iso == false) {
  160. unset($value['id']);
  161. $value['addtime'] = date("Y-m-d H:i:s");
  162. $value['updatetime'] = date("Y-m-d H:i:s");
  163. } else {
  164. $value['id'] = $iso['id'];
  165. $value['updatetime'] = date("Y-m-d H:i:s");
  166. }
  167. $up = Db::name("good")->strict(false)->save($value);
  168. if (!$up) {
  169. Db::rollback();
  170. return error_show(1004, "提交失败");
  171. }
  172. } else {
  173. Db::rollback();
  174. return error_show(1004, "提交失败");
  175. }
  176. }
  177. Db::commit();
  178. return app_show(0, "提交成功");
  179. } catch (\Exception $e) {
  180. Db::rollback();
  181. return error_show(1004, $e->getMessage());
  182. }
  183. }
  184. //审核并将商品推送到有赞平台
  185. public static function youzanGoodUpOnline(int $platform_youzan_id = 0, array $data = [])
  186. {
  187. Db::startTrans();
  188. try {
  189. $db = new PlatformYouzan();
  190. $rs = $db
  191. ->field('a.id,a.platform_id,a.spuCode,a.skuCode,a.exam_status,gb.good_name,gb.weight,gb.good_img,gb.cat_id,gb.good_info_img,gb.chargerid')
  192. ->alias('a')
  193. ->where(['a.id' => $platform_youzan_id, 'a.is_del' => $db::$del_normal])
  194. ->leftJoin('good_basic gb', 'gb.spuCode=a.spuCode')
  195. ->findOrEmpty();
  196. if ($rs->isEmpty()) throw new Exception('该商品上线记录不存在');
  197. if ($rs->exam_status != $db::$exam_status_0) throw new Exception('该商品并不是待审核状态');
  198. $old_exam_status = $rs->exam_status;
  199. $userinfo = GetUserInfo($data['token']);
  200. //platform_youzan 更新信息
  201. $update_data = [
  202. 'exam_status' => $data['exam_status'],
  203. 'updaterid' => isset($userinfo['data']['id']) ? $userinfo['data']['id'] : 0,
  204. 'updater' => isset($userinfo['data']['nickname']) ? $userinfo['data']['nickname'] : '',
  205. 'updatetime' => date('Y-m-d H:i:s'),
  206. ];
  207. //good_platform 更新信息
  208. $update_good_platform_data = ['updatetime' => date('Y-m-d H:i:s')];
  209. $res = true;
  210. //审核通过
  211. if ($data['exam_status'] == $db::$exam_status_1) {
  212. // $ladder_info = Db::name('good_ladder')
  213. // ->field('id,cost_fee')
  214. // ->where('id', $data['good_ladder_id'])
  215. // ->where('is_del', 0)
  216. // ->find();
  217. //
  218. // if (empty($ladder_info)) throw new Exception('该商品阶梯记录不存在');
  219. //运费,单位分,整数
  220. $nake_info = Db::name('good_nake')
  221. // ->where(['spuCode' => $rs->spuCode, 'is_del' => 0])
  222. // ->where('min_num', '<=', $data['start_sale_num'])
  223. ->field('id,delivery_fee,cost_fee')
  224. ->where('id', $data['good_ladder_id'])
  225. ->findOrEmpty();
  226. $post_fee = isset($nake_info['delivery_fee']) ? $nake_info['delivery_fee'] : 0;
  227. $desc = explode(',', $rs->good_info_img);
  228. $desc_string = [];
  229. foreach ($desc as $value) {
  230. $desc_string[] = "<img src='$value' />";
  231. }
  232. //计算系统售价
  233. $sale_price = self::getSalePrice([
  234. 'spuCode' => $rs->spuCode,
  235. 'platform_id' => $rs->platform_id,
  236. 'min_num' => $data['start_sale_num'],
  237. ]);
  238. $update_data = array_merge($update_data, [
  239. 'yz_cat_id' => $data['yz_cat_id'],
  240. 'is_support_barter' => $data['is_support_barter'],
  241. 'sale_price' => $sale_price,
  242. 'cost_fee' => $nake_info['cost_fee'] ?? 0,
  243. 'final_price' => $data['final_price'],
  244. 'start_sale_num' => $data['start_sale_num'],
  245. 'reject_reason' => '',
  246. 'post_fee' => $post_fee,
  247. 'desc' => implode('', $desc_string),//商品描述
  248. 'good_ladder_id' => $data['good_ladder_id'],
  249. 'tags' => implode(',', $data['tags']),
  250. ]);
  251. //调有赞项目的接口,从有赞平台下线该商品
  252. $curl_data = [
  253. 'item_no' => $rs->skuCode,//商品自定义编码 skuCode
  254. 'item_type' => $data['item_type'],//0实物商品
  255. 'title' => $rs->good_name,//商品标题
  256. 'is_support_barter' => $data['is_support_barter'],//是否支持换货。1:支持;0:不支持
  257. 'desc' => implode('', $desc_string),//商品描述
  258. 'item_weight' => $rs->weight,
  259. 'category_id' => $rs->cat_id,
  260. 'auto_listing_time' => $data['auto_listing_time'],//0立即售出,传值表示定时(要大于当前时间戳)
  261. 'stock_deduct_mode' => 0,//0拍下减库存
  262. 'is_display' => 1,//1上架商品
  263. // 'quantity' => '1111111111',//库存数,库存数不管,用户自己去有赞平台调整这个数
  264. 'hide_stock' => 0,//0显示库存,1不显示库存
  265. 'origin' => $data['origin'],//系统售价
  266. 'price' => $data['final_price'],//最后售价
  267. 'uid' => isset($userinfo['data']['id']) ? $userinfo['data']['id'] : 0,
  268. 'nickname' => isset($userinfo['data']['nickname']) ? $userinfo['data']['nickname'] : '',
  269. 'good_img' => $rs->good_img,//图片集合
  270. 'post_fee' => $post_fee,//运费,单位分,整数
  271. 'sell_point' => '',//商品卖点信息
  272. 'yz_cat_id' => $data['yz_cat_id'],//有赞类目id
  273. 'start_sale_num' => $data['start_sale_num'],//商品起售数,默认为1
  274. 'tags' => implode(',', $data['tags']),//标签id,多个以,分割
  275. ];
  276. $host = config('app.yz_domain');
  277. $response = curl_request($host . 'api/yz_goodup', $curl_data);
  278. $response = json_decode($response, true);
  279. if ($response['code'] != 0) {
  280. //上架失败
  281. $res = false;
  282. $update_data = array_merge($update_data, ['exam_status' => $db::$exam_status_7, 'offline_fail_reason' => $response['message']]);
  283. // $update_good_platform_data = array_merge($update_good_platform_data,[]);
  284. } else {
  285. //上架成功
  286. $update_data = array_merge($update_data, ['exam_status' => $db::$exam_status_6, 'offline_fail_reason' => '', 'online_time' => date('Y-m-d H:i:s')]);
  287. if ($response['data']['plat_code'] != '') {
  288. $update_data['plat_code'] = $response['data']['plat_code'];
  289. $update_good_platform_data = array_merge($update_good_platform_data, ['plat_code' => $response['data']['plat_code']]);
  290. }
  291. $update_good_platform_data = array_merge($update_good_platform_data, ['exam_status' => 6, 'online_time' => date('Y-m-d H:i:s'), 'is_online' => 1]);
  292. }
  293. } else {
  294. $update_data['reject_reason'] = $data['reject_reason'];
  295. $update_good_platform_data['exam_status'] = 7;
  296. }
  297. //更新
  298. $db->where('id', $platform_youzan_id)
  299. ->where('exam_status', '=', $db::$exam_status_0)
  300. ->save($update_data);
  301. Db::name('good_platform')
  302. ->where(['is_del' => 0, 'spuCode' => $rs->spuCode, 'skuCode' => $rs->skuCode, 'platform_code' => $rs->platform_id, 'exam_status' => 0])
  303. ->update($update_good_platform_data);
  304. //添加审核记录
  305. ActionLog::logAdd([
  306. 'id' => isset($userinfo['data']['id']) ? $userinfo['data']['id'] : 0,
  307. 'nickname' => isset($userinfo['data']['nickname']) ? $userinfo['data']['nickname'] : ''
  308. ], [
  309. "order_code" => $rs->skuCode,//编号
  310. "status" => $old_exam_status,
  311. "action_remark" => '',//备注
  312. "action_type" => "status"//新建create,编辑edit,更改状态status
  313. ], 'YZSX', $update_data['exam_status'], $update_data);
  314. ProcessOrder::AddProcess([
  315. 'id' => isset($userinfo['data']['id']) ? $userinfo['data']['id'] : 0,
  316. 'nickname' => isset($userinfo['data']['nickname']) ? $userinfo['data']['nickname'] : ''
  317. ], [
  318. "order_type" => 'YZSX',
  319. "order_code" => $rs->skuCode,//咨询单详情编号
  320. "order_id" => $rs->id,
  321. "order_status" => $update_data['exam_status'],
  322. "before_status" => $old_exam_status,
  323. 'holder_id'=>$rs->chargerid,
  324. ]);
  325. if ($res) {
  326. Db::commit();
  327. return app_show(0, '操作成功');
  328. } else throw new Exception('上架失败,' . $response['message']);
  329. } catch (Exception $exception) {
  330. Db::rollback();
  331. return error_show(1005, $exception->getMessage());
  332. }
  333. }
  334. //计算系统售价
  335. private static function getSalePrice(array $data = [])
  336. {
  337. $spuCode = $data['spuCode'];
  338. $platid = $data['platform_id'];
  339. $platform = Db::name("platform")->where(["id" => $platid, "is_del" => 0])->find();
  340. $num = $data['min_num'];
  341. if ($platform['platform_type'] != 1) throw new Exception('平台为非对接平台');
  342. $good = Db::name("good_basic")->where(["spuCode" => $spuCode, "is_del" => 0])->find();
  343. if ($good == false) throw new Exception('商品数据未找到');
  344. $nakelist = Db::name("good_nake")
  345. ->where(['spuCode' => $spuCode, "is_del" => 0])
  346. ->where("min_num", "<=", $num)
  347. ->order("min_num desc")
  348. ->find();
  349. if ($nakelist == false) {
  350. $nakelist = Db::name("good_nake")->where(['spuCode' => $spuCode, "is_del" => 0])->order("min_num asc")->find();
  351. //非库存品的话,继续校验最小起订量
  352. //库存品的话,不足采购起订量的时候,取采购最小起订量
  353. if ($good['is_stock'] == 0) throw new Exception("起订量不足{$nakelist['min_num']}");
  354. }
  355. $catinfo = Db::name("cat_plat")->where(["cat_id" => $good['cat_id'], "is_del" => 0, "platform_id" => $platid])->find();
  356. if ($catinfo == false || $catinfo['sale_rate'] == 0) throw new Exception('分类未设置平台毛利率');
  357. $budget = isset($catinfo['sale_rate']) ? $catinfo['sale_rate'] / 100 : 0;
  358. $top_cat_id = made($catinfo['cat_id']);//获取所有分类
  359. $top_cat_id = isset($top_cat_id[0]['id']) ? $top_cat_id[0]['id'] : 0;//获取顶级分类id
  360. $sale_cost_fee = 0;
  361. if ($good['is_gold_price'] == 1 && $top_cat_id == 6) {
  362. // $saleprice = $good['noble_weight']*$good["cgd_gold_price"] + $nakelist['cost_fee']/(1-$budget)*$good['noble_weight']+$nakelist['mark_fee']+$nakelist['package_fee']+$nakelist['cert_fee']+$nakelist['nake_fee']+$nakelist['delivery_fee'];
  363. //系统售价=(贵金属重量*供应商采购金价 + 工艺费*贵金属重量+加标费+包装费+证书费+成本裸价+运费+其他费用)/(1-成本售价/100)
  364. $saleprice = ($good['noble_weight'] * $good["cgd_gold_price"] + $nakelist['cost_fee'] * $good['noble_weight'] + $nakelist['mark_fee'] + $nakelist['package_fee'] + $nakelist['cert_fee'] + $nakelist['nake_fee'] + $nakelist['delivery_fee'] + $nakelist['other_fee']) / (1 - $budget);
  365. //计算工艺费
  366. //销售工艺费=(( 商品重量* 供应商采购金价 + 采购成本工艺费* 商品重量+包装费+加标费+证书费+产品裸价+其他费用)/(1-成本售价/100)-(包装费+加标费+证书费+产品裸价0+运费+其他费用) )/商品重量-供应商采购金价
  367. $sale_cost_fee = (($good['noble_weight'] * $good["cgd_gold_price"] + $nakelist['cost_fee'] * $good['noble_weight'] + $nakelist['package_fee'] + $nakelist['mark_fee'] + $nakelist['cert_fee'] + $nakelist['nake_fee'] + $nakelist['other_fee'] + $nakelist['delivery_fee']) / (1 - $budget) - ($nakelist['package_fee'] + $nakelist['mark_fee'] + $nakelist['cert_fee'] + $nakelist['nake_fee'] + $nakelist['delivery_fee'] + $nakelist['other_fee'])) / $good['noble_weight'] - $good["cgd_gold_price"];
  368. } else {
  369. // $saleprice = ($nakelist['mark_fee'] + $nakelist['package_fee'] + $nakelist['cert_fee'] + $nakelist['delivery_fee'] + $nakelist['nake_fee']) / (1 - $budget);
  370. // (加标费+包装费+证书费+成本裸价+运费)/(1-成本售价/100)=系统售价
  371. // $saleprice = (加标费 + 包装费 + 证书费 + 运费 + 成本裸价+其他费用) / (1 - $budget);
  372. $saleprice = $nakelist['nake_total'] / (1 - $budget);
  373. }
  374. return round($saleprice, 2);
  375. }
  376. //有赞商品重新上线(上线失败的、下线后又重新上线的)
  377. public static function goodupOnlineAgain(int $platform_youzan_id = 0, string $token = '')
  378. {
  379. Db::startTrans();
  380. try {
  381. $db = new PlatformYouzan();
  382. $rs = $db
  383. ->field('id,spuCode,skuCode,platform_id,exam_status')
  384. ->where(['id' => $platform_youzan_id, 'is_del' => $db::$del_normal])
  385. ->whereIn('exam_status', [$db::$exam_status_7, $db::$exam_status_8])
  386. ->findOrEmpty();
  387. if ($rs->isEmpty()) return error_show(1005, '该商品上线记录不存在或不允许重新上线');
  388. $userinfo = GetUserInfo($token);
  389. $uid = isset($userinfo['data']['id']) ? $userinfo['data']['id'] : 0;
  390. $nickname = isset($userinfo['data']['nickname']) ? $userinfo['data']['nickname'] : '';
  391. $old_status = $rs->exam_status;
  392. //更新
  393. $db
  394. ->where('id', $platform_youzan_id)
  395. ->save([
  396. 'exam_status' => $db::$exam_status_0,
  397. 'updaterid' => $uid,
  398. 'updater' => $nickname,
  399. 'updatetime' => date('Y-m-d H:i:s'),
  400. ]);
  401. //更新
  402. Db::name('good_platform')
  403. ->where(['is_del' => 0, 'spuCode' => $rs->spuCode, 'skuCode' => $rs->skuCode, 'platform_code' => $rs->platform_id])
  404. ->where('exam_status', '<>', 0)
  405. ->update(['exam_status' => 0, 'updatetime' => date('Y-m-d H:i:s')]);
  406. $stn = ["order_code" => $rs->skuCode, "status" => $old_status, "action_remark" => '', "action_type" => "status"];
  407. ActionLog::logAdd(['id' => $uid, 'nickname' => $nickname], $stn, "YZSX", $db::$exam_status_0, ['id'=>$platform_youzan_id]);
  408. $process = ["order_code" => $rs->skuCode, "order_id" => $rs->id, "order_status" => $db::$exam_status_0, "order_type" => 'YZSX', "before_status" => $old_status, 'holder_id' => $uid];
  409. ProcessOrder::AddProcess(['id' => $uid, 'nickname' => $nickname], $process);
  410. Db::commit();
  411. return app_show(0, '操作成功');
  412. } catch (Exception $exception) {
  413. Db::rollback();
  414. return error_show(1005, $exception->getMessage());
  415. }
  416. }
  417. //商品上线详情
  418. public static function getYzGoodupInfo(array $param = [])
  419. {
  420. $data = Db::name('platform_youzan')
  421. ->where('id', $param['platform_youzan_id'])
  422. ->whereOr('skuCode', $param['skuCode'])
  423. ->find();
  424. if (empty($data)) return error_show(1005, '查询不到该记录');
  425. $good_data = Db::name("good_basic")
  426. ->withoutField('createrid,creater,is_del,addtime,updatetime')
  427. ->where(["is_del" => 0, "spuCode" => $data['spuCode']])
  428. ->find();
  429. if ($good_data == false) return error_show(1004, "未找到商品数据");
  430. $data = array_merge($data, $good_data);
  431. $plat = Db::name("platform")->where(["id" => $data['platform_id']])->find();
  432. // $data['skuCode'] = $data['skuCode'];
  433. $data['platform_code'] = $data['platform_id'];
  434. $data['platform_code_en'] = isset($plat['platform_code']) ? $plat['platform_code'] : "";
  435. $data['platform_name'] = isset($plat['platform_name']) ? $plat['platform_name'] : "";
  436. // $data['online_reason'] = $good_platform['online_reason'];
  437. // $data['online_time'] = $data['online_time'];
  438. // $data['online_remark'] = $good_platform['online_remark'];
  439. // $data['exam_status'] = $good_platform['exam_status'];
  440. // $data['is_online'] = $good_platform['is_online'];
  441. // $data['plat_code'] = $data['plat_code'];
  442. // $data['exclusive'] = makeExcluse($data['is_exclusive']);
  443. $unit = Db::name("unit")->where(["id" => $data['good_unit']])->find();
  444. $data['unit'] = isset($unit['unit']) ? $unit['unit'] : '';
  445. $data['cat_info'] = made($data['cat_id'], []);
  446. $data['yz_cat_info'] = made_youzan($data['yz_cat_id'], []);
  447. $spec = Db::name("good_spec")->where(["spuCode" => $data['spuCode'], "is_del" => 0])->select()->toArray();
  448. $supplier = Db::name("supplier")->where(["code" => $data['supplierNo']])->find();
  449. $data['supplierName'] = isset($supplier['name']) ? $supplier['name'] : "";
  450. // $data['noble_name'] = isset($data['noble_metal']) && $data['noble_metal'] != 0 ? $this->noble[$data['noble_metal']] : "";
  451. $company = Db::name("business")->where(["companyNo" => $data['companyNo']])->find();
  452. $data['company'] = isset($company['company']) ? $company['company'] : "";
  453. if ($data['brand_id'] != 0) {
  454. $brand = Db::name("brand")->where(["id" => $data['brand_id']])->find();
  455. $data["brand_name"] = isset($brand['brand_name']) ? $brand['brand_name'] : "";
  456. } else {
  457. $data["brand_name"] = "";
  458. $data["brand_id"] = "";
  459. }
  460. $data['origin_place_cn'] = "";
  461. $data['delivery_place_cn'] = "";
  462. if ($data['delivery_place'] !== "") {
  463. $place = ["provice_code" => "", "city_code" => "", "area_code" => ""];
  464. list($place['provice_code'], $place['city_code'], $place['area_code']) = explode(",", $data['delivery_place']);
  465. $data['delivery_place_cn'] = GetAddr(json_encode($place));
  466. }
  467. if ($data['origin_place'] !== "") {
  468. $place = ["provice_code" => "", "city_code" => "", "area_code" => ""];
  469. list($place['provice_code'], $place['city_code'], $place['area_code']) = explode(",", $data['origin_place']);
  470. $data['origin_place_cn'] = GetAddr(json_encode($place));
  471. }
  472. $excluse = makeExcluse($data['is_exclusive']);
  473. $data['exclusive'] = $excluse;
  474. $data["good_info_img"] = $data['good_info_img'] != "" ? $data['good_info_img'] : [];
  475. $data["good_img"] = $data['good_img'] != "" ? $data['good_img'] : [];
  476. $speclist = [];
  477. if (!empty($spec)) {
  478. foreach ($spec as $value) {
  479. $temp = [];
  480. $temp['id'] = $value['id'];
  481. $temp['spuCode'] = $value['spuCode'];
  482. $temp['spec_id'] = $value['spec_id'];
  483. $temp['spec_value_id'] = $value['spec_value_id'];
  484. $temp['is_del'] = $value['is_del'];
  485. $sp = Db::name("specs")->where(["id" => $value['spec_id']])->find();
  486. $temp['spec_name'] = isset($sp["spec_name"]) ? $sp["spec_name"] : "";
  487. $spv = Db::name("spec_value")->where(["id" => $value['spec_value_id']])->find();
  488. $temp['spec_value'] = isset($spv["spec_value"]) ? $spv["spec_value"] : "";
  489. $speclist[] = $temp;
  490. }
  491. }
  492. $data["speclist"] = empty($speclist) ? [] : $speclist;
  493. $ladder = Db::name("good_ladder")->where(['skuCode' => $data['skuCode'], "is_del" => 0])->select()->toArray();
  494. $data["ladderlist"] = !empty($ladder) ? $ladder : [];
  495. $nakelist = Db::name("good_nake")->where(['spuCode' => $data['spuCode'], "is_del" => 0])->select()->toArray();
  496. // $catinfo = Db::name("cat")->where(["id"=>$data['cat_id']])->find();
  497. // $cat_top_list = $data['yz_cat_info'];
  498. // $cat_top_id = isset($cat_top_list[0]['id']) ? $cat_top_list[0]['id'] : 0;
  499. // $budget = isset($catinfo['order_rate']) ? $catinfo['order_rate']/100:0;
  500. $gold_price = 0;
  501. if ($data['is_gold_price'] == 1 && $data['cost_fee'] != 0 && $data['good_price'] == 0) {
  502. $gold_price = Db::name("gold_price1")->where(["type" => $data['noble_metal'], "status" => 1, "is_del" => 0])->order("addtime desc")->value('price', 0);
  503. }
  504. $data['gold_price'] = $gold_price;
  505. $nakearry = [];
  506. if (!empty($nakelist)) {
  507. //实时金价
  508. foreach ($nakelist as $value) {
  509. $value['sale_price'] = $value['nake_total'];
  510. //计算最终售价
  511. if ($data['is_gold_price'] == 1 && $data['cost_fee'] != 0 && $data['good_price'] == 0) {
  512. //普通商品:直接用财务提交的售价字段;
  513. //贵金属( 商品重量* 最新金价 + 工艺费(财务定价提交的)* 商品重量+包装费+加标费+证书费+产品裸价+其他费用)=商品库商品直接下单的售价
  514. $value['sale_price'] = ($data['weight'] * $gold_price + $value['cost_fee'] * $data['weight'] + $value['package_fee'] + $value['mark_fee'] + $value['cert_fee'] + $value['nake_fee'] + $value['other_fee']);
  515. }
  516. $nakearry[] = $value;
  517. }
  518. }
  519. $proof = Db::name("good_proof")->where(["spuCode" => $data['spuCode'], "is_del" => 0])->order("updatetime desc")->field("id,proof_type,proof_url")->find();
  520. $data['proof'] = isset($proof) && $proof != false ? $proof : [];
  521. $data["nakelist"] = $nakearry;
  522. //补充采购员字段
  523. //成本表里的创建人,也是线上商品的采购人,为了防止混淆,给creater取个别名
  524. $temp_basic_info = Db::name('good_basic')
  525. ->field('id,createrid purchase_id,creater purchase')
  526. ->where(['spuCode' => $data['spuCode'], 'is_del' => 0])
  527. ->find();
  528. $data['purchase_id'] = $temp_basic_info['purchase_id'];
  529. $data['purchase'] = $temp_basic_info['purchase'];
  530. //补充商品详情链接字段
  531. $data['detail_url'] = YzGood::where(['is_del' => 0, 'item_no' => $data['skuCode']])
  532. ->value('detail_url', '');
  533. return app_show(0, "获取成功", $data);
  534. }
  535. //有赞商品下线
  536. public static function youzanGoodOffline(int $platform_youzan_id = 0, array $data = [])
  537. {
  538. Db::startTrans();
  539. try {
  540. $db = new PlatformYouzan();
  541. $rs = $db
  542. ->field('id,spuCode,skuCode,exam_status,platform_id')
  543. ->where(['id' => $platform_youzan_id, 'is_del' => $db::$del_normal])
  544. ->findOrEmpty();
  545. if ($rs->isEmpty()) throw new Exception('该记录不存在');
  546. if ($rs->exam_status == $db::$exam_status_8) throw new Exception('该商品已下线,无法重复下线');
  547. $userinfo = GetUserInfo($data['token']);
  548. $old_status = $rs->exam_status;
  549. $curl_data = [
  550. 'item_no' => $rs->skuCode,//商品自定义编码 skuCode
  551. 'uid' => isset($userinfo['data']['id']) ? $userinfo['data']['id'] : 0,
  552. 'nickname' => isset($userinfo['data']['nickname']) ? $userinfo['data']['nickname'] : '',
  553. ];
  554. if ($rs->exam_status == $db::$exam_status_6) {
  555. //已上线的要调用有赞接口下线
  556. //调有赞项目的接口,从有赞平台下线该商品
  557. $host = config('app.yz_domain');
  558. $response = curl_request($host . 'api/yz_goodup_offline', $curl_data);
  559. $response = json_decode($response, true);
  560. if ($response['code'] != 0) throw new Exception($response['message']);
  561. }
  562. $db::where('id', $platform_youzan_id)
  563. ->update([
  564. 'exam_status' => $db::$exam_status_8,
  565. 'offline_reason_id' => $data['offline_reason_id'],
  566. 'offline_remark' => $data['offline_remark'],
  567. 'updaterid' => isset($userinfo['data']['id']) ? $userinfo['data']['id'] : 0,
  568. 'updater' => isset($userinfo['data']['nickname']) ? $userinfo['data']['nickname'] : '',
  569. 'updatetime' => date('Y-m-d H:i:s')
  570. ]);
  571. //更新
  572. Db::name('good_platform')
  573. ->where(['is_del' => 0, 'spuCode' => $rs->spuCode, 'skuCode' => $rs->skuCode, 'platform_code' => $rs->platform_id])
  574. ->where('exam_status', '<>', 8)
  575. ->update(['exam_status' => 8, 'updatetime' => date('Y-m-d H:i:s')]);
  576. //下线记录表增加记录
  577. Db::name('good_offline_log_youzan')
  578. ->insert([
  579. 'spuCode' => $rs->spuCode,
  580. 'skuCodes' => $rs->skuCode,
  581. 'good_name' => Db::name("good_basic")->where('spuCode', $rs->spuCode)->value('good_name', ''),
  582. 'offline_reason' => $data['offline_reason_id'],
  583. 'offline_remark' => $data['offline_remark'],
  584. 'createrid' => isset($userinfo['data']['id']) ? $userinfo['data']['id'] : 0,
  585. 'creater' => isset($userinfo['data']['nickname']) ? $userinfo['data']['nickname'] : '',
  586. 'addtime' => date('Y-m-d H:i:s')
  587. ]);
  588. $stn = ["order_code" => $rs->skuCode, "status" => $old_status, "action_remark" => '', "action_type" => "status"];
  589. ActionLog::logAdd(['id' => $curl_data['uid'], ['nickname' => $curl_data['nickname']]], $stn, "YZSX", $db::$exam_status_8, $data);
  590. $process = ["order_code" => $rs->skuCode, "order_id" => $rs->id, "order_status" => $db::$exam_status_8, "order_type" => 'YZSX', "before_status" => $old_status, 'holder_id' => $curl_data['uid']];
  591. ProcessOrder::AddProcess(['id' => $curl_data['uid'], ['nickname' => $curl_data['nickname']]], $process);
  592. Db::commit();
  593. return app_show(0, '操作成功');
  594. } catch (Exception $exception) {
  595. Db::rollback();
  596. return error_show(1005, $exception->getMessage());
  597. }
  598. }
  599. //有赞下线商品列表
  600. public static function youzanOfflineList(array $data = [])
  601. {
  602. $where = [];
  603. if ($data['start_date'] != '' && $data['end_date'] != '') $where[] = ['addtime', 'between', [$data['start_date'], $data['end_date']]];
  604. if ($data['creater'] != '') $where[] = ['creater', 'like', '%' . $data['creater'] . '%'];
  605. $count = Db::name('good_offline_log_youzan')->where($where)->count('id');
  606. $list = Db::name('good_offline_log_youzan')
  607. ->field('id,spuCode,good_name,creater,addtime')
  608. ->where($where)
  609. ->order('addtime', 'desc')
  610. ->page($data['page'], $data['size'])
  611. ->select()
  612. ->toArray();
  613. return app_show(0, "获取成功", ['list' => $list, 'count' => $count]);
  614. }
  615. //有赞下线商品详情
  616. public static function youzanOfflineDetail(int $id = 0)
  617. {
  618. $res = Db::name('good_offline_log_youzan')
  619. ->alias('gol')
  620. ->field('gol.*,ri.result')
  621. ->where('gol.id', $id)
  622. ->leftJoin('result_info ri', 'ri.result_code=gol.offline_reason')
  623. ->find();
  624. $res['children_list'] = Db::name('platform_youzan')
  625. ->alias('gp')
  626. ->field('gp.id,gp.skuCode,p.platform_name,g.creater purchease,gp.creater')
  627. ->where(['gp.spuCode' => $res['spuCode']])
  628. ->whereIn('gp.skuCode', $res['skuCodes'])
  629. ->leftJoin('platform p', 'p.id=gp.platform_id')
  630. ->leftJoin('good g', 'g.spuCode=gp.spuCode')
  631. ->select()
  632. ->toArray();
  633. return app_show(0, "获取成功", $res);
  634. }
  635. //商品下架(有赞平台操作)
  636. public static function goodOffLineByYouzan(string $item_no = '')
  637. {
  638. Db::startTrans();
  639. try {
  640. Db::table('wsm_good_platform')
  641. ->where(['is_del' => 0, 'skuCode' => $item_no])
  642. ->update([
  643. 'exam_status' => 8,
  644. 'is_online' => 0,
  645. 'updatetime' => date('Y-m-d H:i:s'),
  646. ]);
  647. $good_info = Db::table('wsm_platform_youzan')
  648. ->alias('py')
  649. ->field('py.id,py.spuCode,gb.good_name')
  650. ->leftJoin('good_basic gb', 'gb.spuCode=py.spuCode')
  651. ->where(['py.is_del' => 0, 'py.exam_status' => 6, 'py.skuCode' => $item_no])
  652. ->find();
  653. if (!empty($good_info)) {
  654. //更新采销上线记录表
  655. Db::table('wsm_platform_youzan')
  656. ->where('id', $good_info['id'])
  657. ->update([
  658. 'exam_status' => 8,
  659. 'offline_remark' => '有赞平台操作下架',
  660. 'offline_reason_id' => self::$offline_result_info_id,
  661. 'updaterid' => 0,
  662. 'updater' => 'youzan',
  663. 'updatetime' => date('Y-m-d H:i:s'),
  664. ]);
  665. //下线记录
  666. Db::table('wsm_good_offline_log_youzan')
  667. ->insert([
  668. 'spuCode' => isset($good_info['spuCode']) ? $good_info['spuCode'] : '',
  669. 'skuCodes' => $item_no,
  670. 'good_name' => isset($good_info['good_name']) ? $good_info['good_name'] : '',
  671. 'offline_reason' => self::$offline_result_info_id,
  672. 'offline_remark' => '有赞平台操作下架',
  673. 'createrid' => 0,
  674. 'creater' => 'youzan',
  675. 'addtime' => date('Y-m-d H:i:s'),
  676. ]);
  677. }
  678. Db::commit();
  679. return app_show(0, '操作成功');
  680. } catch (Exception $exception) {
  681. Db::rollback();
  682. return error_show(0, '操作失败,' . $exception->getMessage());
  683. }
  684. }
  685. //商品删除(有赞平台操作)
  686. public static function goodDeleteByYouzan(string $item_no = '')
  687. {
  688. Db::startTrans();
  689. try {
  690. Db::table('wsm_good_platform')
  691. ->where(['is_del' => 0, 'skuCode' => $item_no])
  692. ->update([
  693. 'is_del' => 1,//是否删除,0未删除,1删除
  694. 'updatetime' => date('Y-m-d H:i:s'),
  695. ]);
  696. //更新采销上线记录表
  697. Db::table('wsm_platform_youzan')
  698. ->where(['is_del' => 0, 'skuCode' => $item_no])
  699. ->update([
  700. 'is_del' => 1,//是否删除,0未删除,1删除
  701. 'updaterid' => 0,
  702. 'updater' => 'youzan',
  703. 'updatetime' => date('Y-m-d H:i:s'),
  704. ]);
  705. Db::commit();
  706. return app_show(0, '操作成功');
  707. } catch (Exception $exception) {
  708. Db::rollback();
  709. return error_show(1005, '操作失败,' . $exception->getMessage());
  710. }
  711. }
  712. }