12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817 |
- <?php
- namespace app\admin\controller;
- use app\admin\model\DataGroup as DataGroupModel;
- use app\admin\model\GoodLog;
- use app\admin\model\GoodStockInfo;
- use app\admin\model\ProcessOrder;
- use think\Exception;
- use think\facade\Db;
- use think\App;
- use app\admin\model\ActionLog;
- use think\facade\Validate;
- class Reorder extends Base
- {
- public function __construct(App $app)
- {
- parent::__construct($app);
- }
-
- public function create()
- {
- $ordeCode = isset($this->post['orderCode']) && $this->post['orderCode'] != '' ? trim($this->post['orderCode']) : "";
- if ($ordeCode == '') return json_show(1004, "参数orderCode 不能为空");
- $order = Db::name("sale")->where(["orderCode" => $ordeCode, "is_del" => 0])->findOrEmpty();
- if (empty($order)) return json_show(1005, "未找到订单数据");
- $retrun = Db::name("sale_return")
- ->where(["orderCode" => $ordeCode, "is_del" => 0, "status" => [1, 9, 8, 10, 11, 12]])
- ->count('id');
- if ($retrun > 0) return json_show(1005, "存在未完成退货订单数据");
- if ($order['order_type'] == 3 || $order['order_type'] == 4) {
- $goon = Db::name("good_zixun")
- ->where(["spuCode" => $order['good_code'], "is_del" => 0])
- ->findOrEmpty();
- } else {
- $goon = Db::name('good_platform')
- ->alias('a')
- ->join('good b', 'b.spuCode=a.spuCode', 'left')
- ->where(['a.skuCode' => $order['skuCode']])
- ->field("b.creater,b.createrid,b.supplierNo")
- ->findOrEmpty();
- }
- if (empty($goon)) return json_show(1005, "未找到商品数据");
- $userCommon = \app\admin\common\User::getIns();
- $tmp = $userCommon->handle('sInfo', ['code' => $goon['supplierNo']]);
- if (!isset($tmp['code']) || $tmp['code'] != 0) return json_show($tmp['code'], $tmp['message'], $tmp['data']);
- $supplier = $tmp['data'];
- if (empty($supplier)) return json_show(1005, "未找到商品供应商数据");
- $errorCode = isset($this->post['errorCode']) && $this->post['errorCode'] != '' ? trim($this->post['errorCode']) : "";
- if ($errorCode == '') return json_show(1004, "参数errorCode 不能为空");
- $error = Db::name('result_info')
- ->field('id')
- ->where(["result_code" => $errorCode, "is_del" => 0])
- ->findOrEmpty();
- if (empty($error)) return json_show(1005, "未找到退货原因数据");
- $remark = isset($this->post['remark']) && $this->post['remark'] != '' ? trim($this->post['remark']) : "";
- $thnum = isset($this->post['thnum']) && $this->post['thnum'] != '' ? intval($this->post['thnum']) : "";
- $is_addr = 0;
- $rm = $this->uid;
- $ri = $this->uname;
- $returnadr = isset($this->post['returnAddr']) && !empty($this->post['returnAddr']) ? $this->post['returnAddr'] : "";
- if ($returnadr != '') {
- $thnum = array_sum(array_column($returnadr, "return_num"));
- $is_addr = 1;
- }
- $returnCode = makeNo("RN");
- Db::startTrans();
- try {
- $date = date('Y-m-d H:i:s');
- $in = [
- "returnCode" => $returnCode,
- "orderCode" => $ordeCode,
- "good_code" => $order['good_code'],
- "good_name" => $order['good_name'],
- "apply_id" => $rm,
- "apply_name" => $ri,
- "cgderid" => $goon['createrid'],
- "cgder" => $goon['creater'],
- "person" => $supplier['person'] ?? '',
- "person_id" => $supplier['personid'] ?? 0,
- "error_code" => $errorCode,
- "num" => $thnum,
- "total_fee" => round($order['sale_price'] * $thnum, 2),
- "good_price" => $order['sale_price'],
- "platform_id" => $order['platform_id'],
- "remark" => $remark,
- "order_type" => $order['order_type'],
- "is_addr" => $is_addr,
- "status" => $order['is_stock'] == 1 ? (Db::name('order_out_child')->where(['is_del' => 0, 'orderCode' => $ordeCode])->value('id', 0) ? 11 : 4) : 1,
- "is_del" => 0,
- "addtime" => $date,
- "updatetime" => $date,
- 'supplierNo' => $goon['supplierNo'],
- 'supplierName' => $supplier['name'],
- 'companyNo' => $order['supplierNo'],
- 'companyName' => $order['supplierName'],
- 'customer_code' => $order['customer_code'],
- 'customer_name' => $order['customerName'],
- ];
- $create = Db::name("sale_return")->insertGetId($in);
- if ($create > 0) {
- $stn = ["order_code" => $returnCode, "status" => 0, "action_remark" => '', "action_type" => "create"];
- ActionLog::logAdd(['id' => $this->uid, 'nickname' => $this->uname], $stn, "XSTHD", $in['status'], $in);
- $process = ["order_code" => $returnCode, "order_id" => $create, "order_status" => $in['status'], "order_type" => 'XSTHD', "before_status" => 0, 'holder_id' => $in['apply_id']];
- ProcessOrder::AddProcess(['id' => $this->uid, 'nickname' => $this->uname], $process);
-
- Db::execute("UPDATE `wsm_standing_book` SET `returnGoodCode`=CONCAT(IFNULL(`returnGoodCode`,''),',{$returnCode}'),`updatetime`='" . $date . "' WHERE `orderCode`='{$ordeCode}'");
-
- if ($in['status'] == 4 && $order['is_stock'] == 1) {
-
- $out_send_num = Db::name('order_out')
- ->where(['is_del' => 0, 'orderCode' => $ordeCode, 'status' => [0, 1]])
- ->sum('send_num');
- $order['wsend_num'] -= $out_send_num;
- if ($order['wsend_num'] < $thnum) throw new Exception("销售单未发货数量不足退货");
- $lor = $order['status'];
- $order['wsend_num'] -= $thnum;
- $order['send_num'] += $thnum;
- $order['status'] = $order['wsend_num'] == 0 ? 2 : ($order['send_num'] == 0 ? 0 : 1);
- $order['send_status'] = $order['wsend_num'] == 0 ? 3 : ($order['send_num'] == 0 ? 1 : 2);
- $order['th_num'] += $thnum;
- if ($order['th_num'] == $order['send_num'] && $order['wsend_num'] == 0) {
- $order['status'] = 3;
- }
- $order['th_fee'] += round($thnum * $order['sale_price'], 2);
- $order['updatetime'] = $date;
- $uap = Db::name("sale")->save($order);
- if ($uap == false) throw new Exception('销售单订单更新失败');
- ActionLog::logAdd(['id' => $this->uid, 'nickname' => $this->uname], [
- "order_code" => $order["orderCode"],
- "status" => $lor,
- "action_remark" => '',
- "action_type" => "status"
- ], "XSQRD", $order['status'], $order);
- ProcessOrder::AddProcess(['id' => $this->uid, 'nickname' => $this->uname], [
- "order_type" => 'XSQRD',
- "order_code" => $order["orderCode"],
- "order_id" => $order["id"],
- "order_status" => $order['status'], "before_status" => $lor
- ]);
- }
- Db::commit();
- return json_show(0, "退货单新建成功", ["returnCode" => $returnCode]);
- }
- Db::rollback();
- return json_show(1005, "退货单新建失败");
- } catch (\Exception $e) {
- Db::rollback();
- return json_show(1005, $e->getMessage());
- }
- }
-
- public function list()
- {
- $page = isset($this->post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) : "1";
- $size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) : "10";
- $where = [['sr.is_del', "=", 0]];
- $bkcode = isset($this->post['returnCode']) && $this->post['returnCode'] != "" ? trim($this->post['returnCode']) : "";
- if ($bkcode != "") {
- $where[] = ['sr.returnCode', "like", "%{$bkcode}%"];
- }
- $status = isset($this->post['status']) && $this->post['status'] !== "" ? intval($this->post['status']) : "";
- if ($status !== "") {
- $where[] = ['sr.status', "=", $status];
- }
- $orderCode = isset($this->post['orderCode']) && $this->post['orderCode'] != "" ? trim($this->post['orderCode']) : "";
- if ($orderCode != "") {
- $where[] = ['sr.orderCode', "like", "%{$orderCode}%"];
- }
- $apply_name = isset($this->post['apply_name']) && $this->post['apply_name'] != "" ? trim($this->post['apply_name']) : "";
- if ($apply_name != "") {
- $where[] = ['sr.apply_name', "like", "%{$apply_name}%"];
- }
- $start = isset($this->post['start']) && $this->post['start'] != '' ? $this->post['start'] : "";
- if ($start !== "") {
- $where[] = ['sr.addtime', ">=", $start . ' 00:00:00'];
- }
- $end = isset($this->post['end']) && $this->post['end'] != '' ? $this->post['end'] : "";
- if ($end !== "") {
- $where[] = ['sr.addtime', "<=", $end . ' 23:59:59'];
- }
-
- $good_code = isset($this->post['good_code']) && $this->post['good_code'] != "" ? trim($this->post['good_code']) : "";
- if ($good_code != "") {
- $where[] = ['sr.good_code', "like", "%{$good_code}%"];
- }
-
- $skuCode = isset($this->post['skuCode']) && $this->post['skuCode'] != "" ? trim($this->post['skuCode']) : "";
- if ($skuCode != "") {
- $where[] = ['b.skuCode', "like", "%{$skuCode}%"];
- }
- $relaComNo = isset($this->post['relaComNo']) && $this->post['relaComNo'] != "" ? trim($this->post['relaComNo']) : "";
- if ($relaComNo != "") $where[] = ['sr.companyNo', '=', $relaComNo];
- $supplierNo = isset($this->post['supplierNo']) && $this->post['supplierNo'] != "" ? trim($this->post['supplierNo']) : "";
- if ($supplierNo !== "") $where[] = ['sr.supplierNo', "like", '%' . $supplierNo . '%'];
- $companyNo = isset($this->post['companyNo']) && $this->post['companyNo'] != "" ? trim($this->post['companyNo']) : "";
- if ($companyNo !== "") $where[] = ['sr.companyNo', "like", '%' . $companyNo . '%'];
- $customer_code = isset($this->post['customer_code']) && $this->post['customer_code'] != "" ? trim($this->post['customer_code']) : "";
- if ($customer_code !== "") $where[] = ['sr.customer_code', "like", '%' . $customer_code . '%'];
- $order_source = $order_source = isset($this->post['order_source']) && $this->post['order_source'] != "" ? trim($this->post['order_source']) : "";
- if ($order_source !== "") $where[] = ['b.order_source', "=", $order_source];
- $condition = [];
-
- if ($this->level == 2) {
- $role = $this->checkDataShare();
- $hand = resign_hand_user($this->uid, 0);
- if (!empty($role[DataGroupModel::$type_全部])) {
- $arr = array_unique(array_merge($hand, $role[DataGroupModel::$type_全部]));
- $condition[] = ["sr.apply_id", "in", $arr];
- $condition[] = ["sr.cgderid", "in", $hand];
- $condition[] = ["sr.person_id", "in", $hand];
- }
- }
-
- if ($this->level == 3) $where[] = ['b.is_stock', '<>', 1];
- if (in_array($this->roleid, config('app.wsm_cgder_role'))) {
- $where[] = ["b.order_type", "=", 1];
- }
- $company_name = isset($this->post['company_name']) && $this->post['company_name'] !== "" ? trim($this->post['company_name']) : "";
- if ($company_name !== "") $where[] = ["sr.apply_id", 'in', get_company_item_user_by_name($company_name)];
- $count = Db::name("sale_return")
- ->alias('sr')
- ->leftJoin("sale b", "b.orderCode=sr.orderCode AND b.is_del=0")
- ->leftJoin('result_info c', 'c.result_code=sr.error_code')
- ->where($where)
- ->where(function ($query) use ($condition) {
- $query->whereOr($condition);
- })
- ->count('sr.id');
- $total = ceil($count / $size);
- $page = $total >= $page ? $page : $total;
- $list = Db::name("sale_return")
- ->alias('sr')
- ->field('sr.*,b.skuCode,b.sale_price,b.good_num total_num,b.order_source,c.result error_msg')
- ->leftJoin("sale b", "b.orderCode=sr.orderCode AND b.is_del=0")
- ->leftJoin('result_info c', 'c.result_code=sr.error_code')
- ->where($where)
- ->where(function ($query) use ($condition) {
- $query->whereOr($condition);
- })
- ->order("sr.addtime desc")
- ->page($page, $size)
- ->select()
- ->toArray();
-
- $all_createrid = array_column($list, 'apply_id');
- $item = get_company_name_by_uid($all_createrid);
-
- $supp_account = checkHasAccountBySupplierNos(array_unique(array_column($list,'supplierNo')));
- $data = [];
- foreach ($list as $value) {
- $value['return_total'] = $value['sale_price'] * $value['num'];
- $value['company_name'] = $item[$value['apply_id']] ?? '';
-
- $value['has_account'] = (int)isset($supp_account[$value['supplierNo']]);
- $data[] = $value;
- }
- return json_show(0, "获取成功", ["count" => $count, 'list' => $data]);
- }
- public function info()
- {
- $code = isset($this->post['returnCode']) && $this->post['returnCode'] !== "" ? trim($this->post['returnCode']) : "";
- if ($code == "") {
- return json_show(1004, "参数returnCode不能为空");
- }
- $info = Db::name("sale_return")->where(["returnCode" => $code, "is_del" => 0])->find();
- if (empty($info)) {
- return json_show(1004, "未找到退货数据");
- }
- $orderinfo = Db::name("sale")->where(["orderCode" => $info["orderCode"]])->find();
- if ($orderinfo['order_type'] == 3 || $orderinfo['order_type'] == 4) {
- $goon = Db::name("good_zixun")
- ->field('cat_id,0 is_stock')
- ->where(["spuCode" => $orderinfo['good_code'], "is_del" => 0])
- ->findOrEmpty();
- } else {
- $goon = Db::name('good_platform')
- ->field('b.cat_id,b.is_stock')
- ->alias('a')
- ->leftJoin('good b', 'b.spuCode=a.spuCode')
- ->where(['a.skuCode' => $orderinfo['skuCode']])
- ->findOrEmpty();
- }
- if ($goon == false) {
- return json_show(1003, "未找到商品数据");
- }
- $int = isset($goon['cat_id']) && $goon['cat_id'] != 0 ? made($goon['cat_id']) : [];
- $info['is_stock'] = isset($goon['is_stock']) ? $goon['is_stock'] : '0';
- $info['good_code'] = isset($orderinfo['good_code']) ? $orderinfo['good_code'] : '';
- $info['send_type'] = isset($orderinfo['send_type']) ? $orderinfo['send_type'] : '';
- $info['skuCode'] = isset($orderinfo['skuCode']) ? $orderinfo['skuCode'] : '';
- $info['good_name'] = isset($orderinfo['good_name']) ? $orderinfo['good_name'] : '';
- $info['good_num'] = isset($orderinfo['good_num']) ? $orderinfo['good_num'] : '';
- $info['sale_price'] = isset($orderinfo['sale_price']) ? $orderinfo['sale_price'] : '0';
- $info['origin_price'] = isset($orderinfo['origin_price']) ? $orderinfo['origin_price'] : '0';
- $info['return_total'] = $info['sale_price'] * $info['num'];
- $info['send_num'] = isset($orderinfo['send_num']) ? $orderinfo['send_num'] : '0';
- $info['wsend_num'] = isset($orderinfo['wsend_num']) ? $orderinfo['wsend_num'] : '0';
- $info['send_status'] = isset($orderinfo['send_status']) ? $orderinfo['send_status'] : '';
- $info['total_price'] = isset($orderinfo['total_price']) ? $orderinfo['total_price'] : '0';
- $info['post_fee'] = isset($orderinfo['post_fee']) ? $orderinfo['post_fee'] : '0';
- if ($info['return_wsm'] != "") {
- $wsmcode = Db::name("warehouse_info")
- ->alias("a")
- ->where(["a.wsm_code" => $info['return_wsm']])
- ->field("a.name as wsm_name,a.supplierNo,a.supplierName")
- ->findOrEmpty();
- $info['wsm_name'] = isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name'] : "";
- $info['wsm_supplier'] = $wsmcode['supplierName'];
- $info['wsm_supplierNo'] = $wsmcode['supplierNo'] ?? '';
- }
- $info['platform_name'] = '';
- $info['platform_id'] = $orderinfo['platform_id'];
- if ($orderinfo['platform_id'] != 0) {
- $plat = Db::name("platform")->field('platform_name')->where(['id' => $orderinfo['platform_id']])->find();
- $info['platform_name'] = isset($plat['platform_name']) ? $plat['platform_name'] : "";
- }
- $info['cgd_wsend'] = "";
- $info['cgd_send'] = "";
- $info['cgd_total'] = "";
- if ($orderinfo['order_type'] == 2) {
- $cgd = Db::name("purchease_order")->where(["bkcode" => $info["orderCode"], "order_type" => 2])->find();
- $info['cgd_wsend'] = isset($cgd['wsend_num']) ? $cgd['wsend_num'] : 0;
- $info['cgd_send'] = isset($cgd['send_num']) ? $cgd['send_num'] : 0;
- $info['cgd_total'] = isset($cgd['good_num']) ? $cgd['good_num'] : 0;
- }
- $info['error_msg'] = '';
- if ($info['error_code'] != '') {
- $error = Db::name("result_info")->where(["result_code" => $info['error_code']])->find();
- $info['error_msg'] = isset($error['result']) ? $error['result'] : "";
- }
- $wsm_return = Db::name("sale_returninfo")->where(["returnCode" => $info["returnCode"], "is_del" => 0])->select()->toArray();
- $all_wsm_code = array_column($wsm_return, 'wsm_code');
- $all_wsmcode_info = Db::name("warehouse_info")
- ->where(["wsm_code" => $all_wsm_code])
- ->column("name,supplierNo,supplierName", 'wsm_code');
- $wsm = [];
- if (!empty($wsm_return)) {
- foreach ($wsm_return as $value) {
- $value['wsm_name'] = "";
- $value['wsm_supplier'] = "";
- $value['wsm_supplierNo'] = "";
- if ($value['wsm_code'] != "") {
- $value['wsm_name'] = $all_wsmcode_info[$value['wsm_code']]['name'] ?? '';
- $value['wsm_supplier'] = $all_wsmcode_info[$value['wsm_code']]['supplierName'] ?? '';
- $value['wsm_supplierNo'] = $all_wsmcode_info[$value['wsm_code']]['supplierNo'] ?? '';
- }
- $orderwsm = Db::name("sale_info")->where(["orderCode" => $info["orderCode"], "wsm_code" => $value["wsm_code"]])->find();
- $value["wsm_total"] = isset($orderwsm["num"]) ? $orderwsm["num"] : 0;
- $send = Db::name("order_out")->where(["wsm_code" => $value['wsm_code'], 'orderCode' => $info['orderCode']])->sum("send_num");
- $value['wsm_send'] = $send ?? 0;
- $value['wsm_wsend'] = $value['wsm_total'] - $value['wsm_send'];
- $wsm[] = $value;
- }
- }
- $info['wsminfo'] = $wsm;
- $addr = Db::name("sale_returnaddr")
- ->alias('a')
- ->field('a.*,b.addr,b.addr_code,b.contactor,b.mobile,b.post_fee,b.arrive_time,b.customer_code,b.receipt_quantity,b.orderCode')
- ->leftJoin('order_addr b', 'b.id=a.addrid')
- ->where(["a.returnCode" => $info["returnCode"], "a.is_del" => 0])
- ->select()
- ->toArray();
- $addrinfo = [];
- if (!empty($addr)) {
- $userCommon = \app\admin\common\User::getIns();
- $customer_name = $userCommon->handle('getCodeAndName', ['code' => array_unique(array_column($addr, 'customer_code'))]);
- foreach ($addr as $value) {
- $value['addr'] = isset($value['addr']) ? $value['addr'] : "";
- $value['addr_code'] = isset($value['addr_code']) ? $value['addr_code'] : "";
- $value['contactor'] = isset($value['contactor']) ? $value['contactor'] : "";
- $value['mobile'] = isset($value['mobile']) ? $value['mobile'] : "";
- $value['post_fee'] = isset($value['post_fee']) ? $value['post_fee'] : "";
- $value['addive_time'] = isset($value['addive_time']) ? $value['addive_time'] : "";
- $value['customer_code'] = isset($value['customer_code']) ? $value['customer_code'] : "";
- $value['receipt_quantity'] = isset($value['receipt_quantity']) ? $value['receipt_quantity'] : "";
- $send = Db::name("order_out")->where(['addrid' => $value['addrid'], 'orderCode' => $value['orderCode'], "is_del" => 0])->where("status", ">=", 2)->sum("send_num");
- $value['addr_send'] = $send ?? 0;
- $value['addr_wsend'] = $value['receipt_quantity'] - $value['addr_send'];
- $value['customer_name'] = $customer_name['data'][$value['customer_code']] ?? '';
- $addrinfo[] = $value;
- }
- }
- $info['addrinfo'] = $addrinfo;
- $info['can'] = $int;
- return json_show(0, "获取成功", $info);
- }
-
- public function delete()
- {
- $code = isset($this->post['returnCode']) && $this->post['returnCode'] !== "" ? trim($this->post['returnCode']) : "";
- if ($code == "") {
- return json_show(1004, "参数returnCode不能为空");
- }
- $info = Db::name("sale_return")->where(["returnCode" => $code, "is_del" => 0])->find();
- if (empty($info)) {
- return json_show(1004, "未找到退货数据");
- }
- $info["is_del"] = 1;
- $info["updatetime"] = date("Y-m-d H:i:s");
- $del = Db::name("sale_return")->save($info);
- if ($del) {
- $ste = ["order_code" => $code, "status" => 0, "action_remark" => '', "action_type" => "delete"];
- ActionLog::logAdd(['id' => $this->uid, 'nickname' => $this->uname], $ste, "XSTHD", 0, $ste);
- $process = ["order_code" => $code, "order_id" => $info['id'], "order_status" => 0, "order_type" => "XSTHD"];
- ProcessOrder::workdel($process);
- return json_show(0, "删除成功");
- } else {
- return json_show(1004, "删除失败");
- }
- }
-
- public function exam()
- {
- $param = $this->request->only(['returnCode', 'status', 'remark' => '', 'return_wsm' => ''], 'post', 'trim');
- $val = Validate::rule([
- 'returnCode|退货单编号' => 'require',
- 'status|状态' => 'require|in:5,9,8,10,4,11',
- 'remark|备注' => 'requireIf:status,5|requireIf:status,8|requireIf:status,10',
- ]);
- if ($val->check($param) == false) return json_show(1004, $val->getError());
- $code = $param['returnCode'];
- $status = $param['status'];
- $remark = $param['remark'];
- $info = Db::name("sale_return")->where(["returnCode" => $code, "is_del" => 0])->findOrEmpty();
- if (empty($info)) return json_show(1004, "未找到退货数据");
- switch ($info['status']) {
- case 1:
- if (in_array($param['status'], [5, 9]) == false) return json_show(1004, '选项错误');
- break;
- case 9:
- if (in_array($param['status'], [4, 8]) == false) return json_show(1004, '选项错误');
- break;
- case 8:
- if (in_array($param['status'], [11, 10]) == false) return json_show(1004, '选项错误');
- break;
- case 10:
- if (in_array($param['status'], [4, 8]) == false) return json_show(1004, '选项错误');
- break;
- }
-
- if (in_array($info['status'], [9, 10]) && ($this->level == 2) && ($this->uid != $info['person_id'])) return json_show(1004, '您不是供应商负责人,此时无权操作');
- if ($param['status'] == 10) $info['loop_total'] += 1;
- $var = $info['status'];
- $orderinfo = Db::name("sale")->where(["orderCode" => $info["orderCode"]])->findOrEmpty();
- if (empty($orderinfo)) return json_show(1004, "未找到订单数据");
- if ($status == 4) {
- if ($info['is_addr'] == 1) {
- $addr = Db::name("sale_returnaddr")
- ->where(['returnCode' => $info['returnCode'], "is_del" => 0])
- ->select()
- ->toArray();
- if (empty($addr)) return json_show(1004, "未找到发货单地址数据");
- }
- }
- if ($info['status'] == 9 && $param['status'] == 4) $info['is_th'] = 1;
- Db::startTrans();
- try {
- $date = date("Y-m-d H:i:s");
- $userCommon = \app\admin\common\User::getIns();
- $temp = $info['status'];
- $info['status'] = $status;
- $remark != "" ? $info['remark'] = $remark : "";
- $info["updatetime"] = $date;
- $up = Db::name("sale_return")->save($info);
- if ($up) {
-
- if ($info['status'] == 2) $process = ["order_code" => $code, "order_id" => $info['id'], "order_status" => $status, "order_type" => "XSTHD", 'before_status' => $temp, 'wait_id' => $info['person_id'], 'wait_name' => $info['person']];
- else $process = ["order_code" => $code, "order_id" => $info['id'], "order_status" => $status, "order_type" => "XSTHD", 'before_status' => $temp, 'holder_id' => $info['apply_id']];
- ProcessOrder::AddProcess(['id' => $this->uid, 'nickname' => $this->uname], $process);
- $ste = ["order_code" => $code, "status" => $temp, "action_remark" => '', "action_type" => "status"];
- ActionLog::logAdd(['id' => $this->uid, 'nickname' => $this->uname], $ste, "XSTHD", $status, $info);
- if ($status == 4) {
- if ($orderinfo['wsend_num'] < $info['num']) throw new Exception('销售单未发货数量不足退货');
- $lor = $orderinfo['status'];
- $orderinfo['wsend_num'] -= $info['num'];
- $orderinfo['send_num'] += $info['num'];
- $orderinfo['status'] = $orderinfo['wsend_num'] == 0 ? 2 : ($orderinfo['send_num'] == 0 ? 0 : 1);
- $orderinfo['send_status'] = $orderinfo['wsend_num'] == 0 ? 3 : ($orderinfo['send_num'] == 0 ? 1 : 2);
- if ($orderinfo['is_stock'] == 1) {
- $orderinfo['th_num'] += $info['num'];
- if ($orderinfo['th_num'] == $orderinfo['send_num'] && $orderinfo['wsend_num'] == 0) {
- $orderinfo['status'] = 3;
- }
- $orderinfo['th_fee'] += round($info['num'] * $orderinfo['sale_price'], 2);
- $orderinfo['updatetime'] = $date;
- $uap = Db::name("sale")->save($orderinfo);
- if ($uap == false) throw new Exception('销售单订单更新失败');
- } else {
- if ($info['is_th'] == 1) {
- $orderinfo['th_num'] += $info['num'];
- if ($orderinfo['th_num'] == $orderinfo['send_num'] && $orderinfo['wsend_num'] == 0) {
- $orderinfo['status'] = 3;
- }
- $orderinfo['th_fee'] += round($info['num'] * $orderinfo['sale_price'], 2);
- $orderinfo['updatetime'] = $date;
- $uap = Db::name("sale")->save($orderinfo);
- if ($uap == false) throw new Exception('销售单订单更新失败');
- $ordernum = Db::name("order_num")
- ->where(['orderCode' => $orderinfo['orderCode']])
- ->findOrEmpty();
- if (empty($ordernum)) throw new Exception('未找到关联采购单');
- $ordernum['send_num'] -= $info['num'];
- $orderup = Db::name("order_num")->save($ordernum);
- if ($orderup == false) throw new Exception('关联数据更新失败');
- $cgd = Db::name("purchease_order")
- ->where(["cgdNo" => $ordernum['cgdNo'], "is_del" => 0])
- ->findOrEmpty();
- if ($cgd == false) throw new Exception('未找到采购单数据');
- if ($info['is_all'] == 1 && $cgd['send_status'] != 1) throw new Exception('采购单已入库无法全部退货');
- $lor = $cgd['status'];
- if ($cgd['wsend_num'] < $info['num']) {
- $cgd['send_num'] += $cgd['wsend_num'] == 0 ? 0 : ($info['num'] - $cgd['wsend_num']);
- $cgd['wsend_num'] = 0;
- } else {
- $cgd['wsend_num'] -= $info['num'];
- $cgd['send_num'] += $info['num'];
- }
- $cgd['status'] = $cgd['wsend_num'] == 0 ? 2 : ($cgd['send_num'] == 0 ? 0 : 1);
- $cgd['send_status'] = $cgd['wsend_num'] == 0 ? 3 : ($cgd['send_num'] == 0 ? 1 : 2);
- $cgd['th_num'] += $info['num'];
- if ($cgd['th_num'] == $cgd['send_num'] && $cgd['wsend_num'] == 0) {
- $cgd['status'] = 4;
- }
- $cgd['th_fee'] += round($info['num'] * $cgd['good_price'], 2);
- $cgd['updatetime'] = $date;
- $cgdup = Db::name("purchease_order")->save($cgd);
- if ($cgdup == false) throw new Exception('采购单数据更新失败');
- $stock = Db::name("good_stock")
- ->where(['is_del' => 0, "spuCode" => $info['good_code'], 'wsm_code' => $cgd['wsm_code']])
- ->findOrEmpty();
- if (empty($stock)) throw new Exception('商品仓库未找到');
- if ($stock['wait_in_stock'] < $info['num']) {
- $stock['wait_in_stock'] = 0;
- if ($stock['usable_stock'] > $info['num'] - $stock['wait_in_stock']) {
- $stock['usable_stock'] -= $info['num'] - $stock['wait_in_stock'];
- } else {
- $stock['usable_stock'] = 0;
- $stock['wait_out_stock'] -= $info['num'] - $stock['wait_in_stock'] - $stock['usable_stock'];
- }
- $stock['total_stock'] = $stock['usable_stock'] + $stock['wait_out_stock'];
- } else {
- $stock['wait_in_stock'] -= $info['num'];
- }
- $stock['updatetime'] = $date;
- $st_up = Db::name("good_stock")->save($stock);
- if ($st_up == false) throw new Exception('可售商品入库失败');
- } else {
- $orderinfo['th_num'] += $info['num'];
- if ($orderinfo['th_num'] == $orderinfo['send_num'] && $orderinfo['wsend_num'] == 0) {
- $orderinfo['status'] = 3;
- }
- $orderinfo['th_fee'] += round($info['num'] * $orderinfo['sale_price'], 2);
- $orderinfo['updatetime'] = $date;
- $uap = Db::name("sale")->save($orderinfo);
- if ($uap == false) throw new Exception('销售单订单更新失败');
- $ordernum = Db::name("order_num")
- ->where(['orderCode' => $orderinfo['orderCode']])
- ->findOrEmpty();
- if (empty($ordernum)) throw new Exception('未找到关联采购单');
- $ordernum['send_num'] -= $info['num'];
- $ordernum['wsend_num'] = $info['num'];
- $orderup = Db::name("order_num")->save($ordernum);
- if ($orderup == false) throw new Exception('关联数据更新失败');
- $cgd = Db::name("purchease_order")
- ->where(["cgdNo" => $ordernum['cgdNo'], "is_del" => 0])
- ->findOrEmpty();
- if (empty($cgd)) throw new Exception('未找到采购单数据');
- $stock = Db::name("good_stock")
- ->where(['is_del' => 0, "spuCode" => $orderinfo['good_code'], 'wsm_code' => $cgd['wsm_code']])
- ->findOrEmpty();
- if (empty($stock)) throw new Exception('商品仓库未找到');
- if ($info['is_all'] == 1) {
- if ($stock['wait_in_stock'] < $info['num']) throw new Exception('商品可用库存不足退回数量');
- else $stock['wait_in_stock'] -= $info['num'];
- } else {
- if ($stock['usable_stock'] + $stock['wait_out_stock'] < $info['num']) throw new Exception('商品可用库存不足退回数量');
- else {
- if ($stock['usable_stock'] > $info['num']) {
- $stock['usable_stock'] -= $info['num'];
- } else {
- $stock['usable_stock'] = 0;
- $stock['wait_out_stock'] -= $info['num'] - $stock['usable_stock'];
- }
- $stock['total_stock'] = $stock['usable_stock'] + $stock['wait_out_stock'];
- }
- }
- $stock['updatetime'] = $date;
- $st_up = Db::name("good_stock")->save($stock);
- if ($st_up == false) throw new Exception('可售商品入库失败');
- }
- }
- ActionLog::logAdd(['id' => $this->uid, 'nickname' => $this->uname], [
- "order_code" => $orderinfo["orderCode"],
- "status" => $lor,
- "action_remark" => '',
- "action_type" => "status"
- ], "XSQRD", $orderinfo['status'], $orderinfo);
- ProcessOrder::AddProcess(['id' => $this->uid, 'nickname' => $this->uname], [
- "order_type" => 'XSQRD',
- "order_code" => $orderinfo["orderCode"],
- "order_id" => $orderinfo["id"],
- "order_status" => $orderinfo['status'], "before_status" => $lor
- ]);
-
- $holder = $userCommon->handle('sInfo', ['code' => $cgd['supplierNo']]);
- if (!isset($holder['code']) || $holder['code'] != 0) throw new Exception($holder['message']);
- $holder_id = $holder['data']['personid'];
- if (in_array($cgd['status'], [4])) {
- if ($orderinfo['is_stock'] == 1) {
-
- $uid = Db::name('user_role')
- ->where([
- ['is_del', '=', 0],
- ['roleid', 'in', [31, 41]],
- ['status', '=', 1]
- ])->column('uid');
- ProcessOrder::AddProcess(['id' => $this->uid, 'nickname' => $this->uname], [
- "order_type" => 'CGD',
- "order_code" => $cgd['cgdNo'],
- "order_id" => $cgd["id"],
- "order_status" => $cgd['status'],
- "before_status" => $lor,
- 'holder_id' => $holder_id,
- 'handle_user_list' => implode(',', $uid),
- ]);
- } else {
-
- ProcessOrder::AddProcess(['id' => $this->uid, 'nickname' => $this->uname], [
- "order_type" => 'CGD',
- "order_code" => $cgd['cgdNo'],
- "order_id" => $cgd["id"],
- "order_status" => $cgd['status'],
- "before_status" => $lor,
- 'holder_id' => $holder_id,
- 'handle_user_list' => $orderinfo['cgderid'],
- ]);
- }
- }
-
- }
- }
- Db::commit();
- return json_show(0, "更新成功");
- } catch (Exception $e) {
- Db::rollback();
- return json_show(1004, $e->getMessage() . '|' . $e->getFile() . ':' . $e->getLine());
- }
- }
- public function zxcreate()
- {
- $ordeCode = isset($this->post['orderCode']) && $this->post['orderCode'] != '' ? trim($this->post['orderCode']) : "";
- if ($ordeCode == '') {
- return json_show(1004, "参数orderCode 不能为空");
- }
- $order = Db::name("sale")->where(["orderCode" => $ordeCode, "is_del" => 0])->find();
- if (empty($order)) {
- return json_show(1005, "未找到订单数据");
- }
- $errorCode = isset($this->post['errorCode']) && $this->post['errorCode'] != '' ? trim($this->post['errorCode']) : "";
- if ($errorCode == '') {
- return json_show(1004, "参数errorCode 不能为空");
- }
- $error = Db::name('result_info')->where(["result_code" => $errorCode, "is_del" => 0])->find();
- if (empty($error)) {
- return json_show(1005, "未找到退货原因数据");
- }
- $remark = isset($this->post['remark']) && $this->post['remark'] != '' ? trim($this->post['remark']) : "";
- $rm = $this->uid;
- $ri = $this->uname;
- $num = isset($this->post['num']) && $this->post['num'] != '' ? intval($this->post['num']) : "";
- if ($num == '') {
- return json_show(1005, "参数num不能为空");
- }
- if ($order['wsend_num'] < $num) {
- return json_show(1002, "仓库未发货数量不足退货");
- }
- if ($order['order_type'] == 3 || $order['order_type'] == 4) $goon = Db::name("good_zixun")->field('supplierNo')->where(["spuCode" => $order['good_code'], "is_del" => 0])->findOrEmpty();
- else $goon = Db::name('good_basic')
- ->where(['spuCode' => $order['good_code']])->findOrEmpty();
- if (empty($goon)) return json_show(1004, '该商品不存在');
- $userCommon = \app\admin\common\User::getIns();
- $names = $userCommon->handle('getCodeAndName', ['code' => [$order['supplierNo'], $order['customer_code'], $goon['supplierNo']]]);
- $returnCode = makeNo("RS");
- Db::startTrans();
- try {
- $in = [
- "returnCode" => $returnCode,
- "orderCode" => $ordeCode,
- "good_code" => $order['good_code'],
- "good_name" => $order['good_name'],
- "apply_id" => $rm,
- "apply_name" => $ri,
- "error_code" => $errorCode,
- "num" => $num,
- "remark" => $remark,
- "order_type" => 2,
- "status" => 0,
- "is_del" => 0,
- "addtime" => date("Y-m-d H:i:s"),
- "updatetime" => date("Y-m-d H:i:s"),
- 'supplierNo' => $goon['supplierNo'],
- 'supplierName' => $names['data'][$goon['supplierNo']] ?? '',
- 'companyNo' => $order['supplierNo'],
- 'companyName' => $names['data'][$order['supplierNo']] ?? '',
- 'customer_code' => $order['customer_code'],
- 'customer_name' => $names['data'][$order['customer_code']] ?? '',
- ];
- $create = Db::name("sale_return")->insert($in, true);
- if ($create > 0) {
- $process = ["order_code" => $returnCode, "order_id" => $create, "order_status" => 0, "order_type" => 'XSTHD', "before_status" => 0, 'holder_id' => $in['apply_id']];
- ProcessOrder::AddProcess(['id' => $this->uid, 'nickname' => $this->uname], $process);
- $ste = ["order_code" => $returnCode, "status" => 0, "action_remark" => '',
- "action_type" => "create"];
- ActionLog::logAdd(['id' => $this->uid, 'nickname' => $this->uname], $ste, "XSTHD", 3, $in);
-
- Db::execute("UPDATE `wsm_standing_book` SET `returnGoodCode`=CONCAT(IFNULL(`returnGoodCode`,''),',{$returnCode}'),`updatetime`='" . date('Y-m-d H:i:s') . "' WHERE `orderCode`='{$ordeCode}'");
- if ($order['send_type'] == 1) {
- $wsend = Db::name("order_out")->where(['orderCode' => $ordeCode, "status" => 1, "order_type" => 2])->select();
-
- if (!empty($wsend)) {
- foreach ($wsend as $value) {
- $tt = $value['status'];
- $value['status'] = 0;
- $value['updatetime'] = date("Y-m-d H:i:s");
- $up = Db::name("order_out")->save($value);
- if ($up) {
- $process = ["order_code" => $value['outCode'], "order_id" => $value['id'], "order_status" => 0, "order_type" => 'CKD', "before_status" => $tt, 'holder_id' => $value['apply_id']];
- ProcessOrder::AddProcess(['id' => $this->uid, 'nickname' => $this->uname], $process);
- $ste = ["order_code" => $value['outCode'], "status" => $tt, "action_remark" => '', "action_type" => "status"];
- ActionLog::logAdd(['id' => $this->uid, 'nickname' => $this->uname], $ste, "CKD", 0, $value);
- } else {
- Db::rollback();
- return json_show(1005, "退货单新建失败");
- }
- }
- }
- }
- Db::commit();
- return json_show(0, "退货单新建成功");
- }
- Db::rollback();
- return json_show(1005, "退货单新建失败");
- } catch (\Exception $e) {
- Db::rollback();
- return json_show(1005, $e->getMessage());
- }
- }
-
- public function allReturn()
- {
- $orderCode = isset($this->post['orderCode']) && $this->post['orderCode'] != '' ? trim($this->post['orderCode']) : "";
- if ($orderCode == '') {
- return json_show(1004, "参数orderCode 不能为空");
- }
- $order = Db::name("sale")->where(["orderCode" => $orderCode, "is_del" => 0])->find();
- if (empty($order)) {
- return json_show(1005, "未找到订单数据");
- }
- if ($order['wsend_num'] != $order['good_num']) {
- return json_show(1005, "订单未发货数量与总数不等,无法全退");
- }
- $retrun = Db::name("sale_return")->where(["orderCode" => $orderCode, "is_del" => 0, "status" => [1, 9, 8, 10, 11, 12]])->count('id');
- if ($retrun > 0) {
- return json_show(1005, "存在退货订单数据");
- }
- if ($order['order_type'] == 3 || $order['order_type'] == 4) {
- $goon = Db::name("good_zixun")
- ->where(["spuCode" => $order['good_code'], "is_del" => 0])
- ->findOrEmpty();
- } else {
- $goon = Db::name('good_platform')
- ->alias('a')
- ->join('good b', 'b.spuCode=a.spuCode', 'left')
- ->where(['a.skuCode' => $order['skuCode']])
- ->field("b.creater,b.createrid,b.supplierNo")
- ->findOrEmpty();
- }
- if (empty($goon)) {
- return json_show(1005, "未找到商品数据");
- }
- $userCommon = \app\admin\common\User::getIns();
- $tmp = $userCommon->handle('sInfo', ['code' => $goon['supplierNo']]);
- $supplier = $tmp['data'];
- if (empty($supplier)) return json_show(1005, "未找到商品供应商数据");
- $errorCode = isset($this->post['errorCode']) && $this->post['errorCode'] != '' ? trim($this->post['errorCode']) : "";
- if ($errorCode == '') return json_show(1004, "参数errorCode 不能为空");
- $error = Db::name('result_info')->where(["result_code" => $errorCode, "is_del" => 0])->find();
- if (empty($error)) return json_show(1005, "未找到退货原因数据");
- $remark = isset($this->post['remark']) && $this->post['remark'] != '' ? trim($this->post['remark']) : "";
- $addr = Db::name("order_addr")->where([["orderCode", "=", $orderCode], ["is_del", "=", 0]])->select()->toArray();
- if ($order['is_stock'] == 0) {
- $ordernum = Db::name("order_num")->where(['orderCode' => $orderCode])->findOrEmpty();
- if (empty($ordernum)) return json_show(1005, '未找到关联采购单');
- $cgd = Db::name("purchease_order")->where(["cgdNo" => $ordernum['cgdNo'], "is_del" => 0])->findOrEmpty();
- if (empty($cgd)) return json_show(1005, '未找到采购单数据');
- }
- if ($order['is_stock'] == 0 && $cgd['send_status'] != 1) return json_show(1005, '采购单已发起入库');
- $returnCode = makeNo("RN");
- Db::startTrans();
- try {
- $in = [
- "returnCode" => $returnCode,
- "orderCode" => $orderCode,
- "good_code" => $order['good_code'],
- "good_name" => $order['good_name'],
- "apply_id" => $this->uid,
- "apply_name" => $this->uname,
- "cgderid" => $goon['createrid'],
- "cgder" => $goon['creater'],
- "person" => $supplier['person'] ?? '',
- "person_id" => $supplier['personid'] ?? 0,
- "error_code" => $errorCode,
- "num" => $order['wsend_num'],
- "total_fee" => round($order['sale_price'] * $order['wsend_num'], 2),
- "good_price" => $order['sale_price'],
- "platform_id" => $order['platform_id'],
- "remark" => $remark,
- "order_type" => $order['order_type'],
- "is_addr" => count($addr) > 0 ? 1 : 0,
- "status" => $order['is_stock'] == 1 ? (Db::name('order_out_child')->where(['is_del' => 0, 'orderCode' => $orderCode])->value('id', 0) ? 11 : 4) : 1,
- "is_all" => 1,
- "addtime" => date("Y-m-d H:i:s"),
- "updatetime" => date("Y-m-d H:i:s"),
- 'supplierNo' => $supplier['code'],
- 'supplierName' => $supplier['name'],
- 'companyNo' => $order['supplierNo'],
- 'companyName' => $order['supplierName'],
- 'customer_code' => $order['customer_code'],
- 'customer_name' => $order['customerName']
- ];
- $create = Db::name("sale_return")->insert($in, true);
- if ($create > 0) {
- $stn = ["order_code" => $returnCode, "status" => 0, "action_remark" => '', "action_type" => "create"];
- ActionLog::logAdd(["id" => $this->uid, "nickname" => $this->uname], $stn, "XSTHD", $in['status'], $in);
- $process = ["order_code" => $returnCode, "order_id" => $create, "order_status" => $in['status'], "order_type" => 'XSTHD', "before_status" => 0, 'holder_id' => $in['apply_id']];
- ProcessOrder::AddProcess(["id" => $this->uid, "nickname" => $this->uname], $process);
-
- Db::execute("UPDATE `wsm_standing_book` SET `returnGoodCode`=CONCAT(IFNULL(`returnGoodCode`,''),',{$returnCode}'),`updatetime`='" . date('Y-m-d H:i:s') . "' WHERE `orderCode`='{$orderCode}'");
- if ($in['status'] == 4 && $order['is_stock'] == 1) {
- $lor = $order['status'];
- $thnum = $order['wsend_num'];
- $order['send_num'] += $thnum;
- $order['th_num'] += $thnum;
- $order['wsend_num'] = 0;
- $order['status'] = 3;
- $order['send_status'] = 3;
- $order['th_fee'] += round($thnum * $order['sale_price'], 2);
- $order['updatetime'] = date("Y-m-d H:i:s");
- $uap = Db::name("sale")->save($order);
- if ($uap == false) throw new Exception('销售单订单更新失败');
- ActionLog::logAdd(["id" => $this->uid, "nickname" => $this->uname], [
- "order_code" => $order["orderCode"],
- "status" => $lor,
- "action_remark" => '',
- "action_type" => "status"
- ], "XSQRD", $order['status'], $order);
- ProcessOrder::AddProcess(["id" => $this->uid, "nickname" => $this->uname], [
- "order_type" => 'XSQRD',
- "order_code" => $order["orderCode"],
- "order_id" => $order["id"],
- "order_status" => $order['status'],
- "before_status" => $lor,
- 'holder_id=' => $order['apply_id']
- ]);
- }
- Db::commit();
- return json_show(0, "退货单新建成功", ["returnCode" => $returnCode]);
- }
- Db::rollback();
- return json_show(1005, "退货单新建失败");
- } catch (\Exception $e) {
- Db::rollback();
- return json_show(1005, $e->getMessage());
- }
- }
-
- public function export()
- {
- $param = $this->request->only([
- 'returnCode' => '',
- 'status' => '',
- 'orderCode' => '',
- 'apply_name' => '',
- 'start' => '',
- 'end' => '',
- 'good_code' => '',
- 'skuCode' => '',
- 'relaComNo' => '',
- 'order_source' => '',
- 'supplierNo' => '',
- 'customer_code' => '',
- 'companyNo' => '',
- 'company_name' => '',
- ], 'post', 'trim');
- $where = [['sr.is_del', "=", 0]];
- if (!empty($param['returnCode'])) $where[] = ['sr.returnCode', "in", $param['returnCode']];
- if ($param['status'] !== "") $where[] = ['sr.status', "=", $param['status']];
- if ($param['orderCode'] != "") $where[] = ['sr.orderCode', "like", "%{$param['orderCode']}%"];
- if ($param['apply_name'] != "") $where[] = ['sr.apply_name', "like", "%{$param['apply_name']}%"];
- if ($param['start'] !== "") $where[] = ['sr.addtime', ">=", $param['start'] . ' 00:00:00'];
- if ($param['end'] !== "") $where[] = ['sr.addtime', "<=", $param['end'] . ' 23:59:59'];
- if ($param['good_code'] != "") $where[] = ['sr.good_code', "like", "%{$param['good_code']}%"];
- if ($param['skuCode'] != "") $where[] = ['b.skuCode', "like", "%{$param['skuCode']}%"];
- if ($param['relaComNo'] != "") $where[] = ['a.supplierNo', '=', $param['relaComNo']];
- if ($param['company_name'] !== "") $where[] = ["sr.apply_id", 'in', get_company_item_user_by_name($param['company_name'])];
- if ($param['order_source'] !== "") $where[] = ["b.order_source", '=', $param['order_source']];
- if ($param['supplierNo'] != "") $where[] = ['a.supplierNo', 'like', '%' . $param['supplierNo'] . '%'];
- if ($param['customer_code'] != "") $where[] = ['a.customer_code', "like", '%' . $param['customer_code'] . '%'];
- if ($param['companyNo'] != "") $where[] = ['a.companyNo', "like", '%' . $param['companyNo'] . '%'];
- $condition = [];
-
- if ($this->level == 2) {
- $role = $this->checkDataShare();
- $hand = resign_hand_user($this->uid, 0);
- if (!empty($role[DataGroupModel::$type_全部])) {
- $arr = array_unique(array_merge($hand, $role[DataGroupModel::$type_全部]));
- $condition[] = ["sr.apply_id", "in", $arr];
- $condition[] = ["sr.cgderid", "in", $hand];
- $condition[] = ["sr.person_id", "in", $hand];
- }
- }
-
- if ($this->level == 3) $where[] = ['b.is_stock', '<>', 1];
- if (in_array($this->roleid, config('app.wsm_cgder_role'))) $where[] = ["b.order_type", "=", 1];
- $list = Db::name("sale_return")
- ->alias('sr')
- ->field('sr.returnCode 退货单编号,sr.orderCode 销售订单编号,sr.apply_id,sr.apply_name 申请人,"" 申请人部门,sr.cgder 采购员,sr.person 供应商负责人,c.result 错误原因,sr.good_code 商品成本编码,b.skuCode 上线商品编码,sr.good_name 商品名称,sr.good_price 单价,sr.num 退货数量,sr.total_fee 退货金额,d.platform_name 平台,sr.remark 备注,sr.order_type 退货单类型,sr.status 状态,sr.is_all 是否全退货,sr.is_th 供应商是否同意退货,sr.is_addr,e.addr_code,e.addr 发货地址,sr.return_wsm 退货仓库,sr.loop_total 循环次数')
- ->leftJoin("sale b", "b.orderCode=sr.orderCode AND b.is_del=0")
- ->leftJoin("result_info c", "c.result_code=sr.error_code")
- ->leftJoin("platform d", "d.id=sr.platform_id")
- ->leftJoin("order_addr e", "e.id=sr.is_addr")
- ->where($where)
- ->where(function ($query) use ($condition) {
- $query->whereOr($condition);
- })
- ->order("sr.addtime desc")
- ->select()
- ->toArray();
- $all_createrid = array_column($list, 'apply_id');
- $item = get_company_name_by_uid($all_createrid);
- $order_type = [1 => '直接下单', 2 => '咨询', 3 => '项目', 4 => '平台', 5 => '有赞', 6 => '售后补换货', 7 => '报备转单', 8 => '支付渠道'];
- $bool = [0 => '否', 1 => '是'];
- $status = [1 => '待业务审批', 4 => '退货完成', 5 => '业务驳回', 9 => '待供应商审核', 8 => '供应商已驳回待采购审核', 10 => '业务公司修改待供应商确认', 11 => '待设置退货工单', 12 => '待库管发货'];
- foreach ($list as &$value) {
- $value['申请人部门'] = $item[$value['apply_id']] ?? '';
- $value['是否全退货'] = $bool[$value['是否全退货']] ?? '';
- $value['供应商是否同意退货'] = $bool[$value['供应商是否同意退货']] ?? '';
- $value['退货单类型'] = $order_type[$value['退货单类型']] ?? '';
- $value['状态'] = $status[$value['状态']] ?? '';
- if ($value['is_addr'] == 0) $value['发货地址'] = '无地址';
- else $value['发货地址'] = GetAddr($value['addr_code']) . $value['发货地址'];
- unset($value['apply_id']);
- unset($value['good_price']);
- unset($value['addr_code']);
- unset($value['is_addr']);
- }
- if (empty($list)) $list[] = ['没有相关可导出的数据'];
- excelSave('退货单' . date('YmdHis'), array_keys($list[0]), $list);
- }
- }
|