3478 lines
139 KiB
PHP
3478 lines
139 KiB
PHP
<?php
|
||
//店管家接入类
|
||
|
||
namespace app\index\controller\wms;
|
||
|
||
use fast\Http;
|
||
use app\index\library\Wsdl;
|
||
use app\common\controller\Frontend;
|
||
use PhpOffice\PhpSpreadsheet\Spreadsheet;
|
||
use PhpOffice\PhpSpreadsheet\IOFactory;
|
||
use think\Db;
|
||
use think\db\exception\BindParamException;
|
||
use think\db\exception\DataNotFoundException;
|
||
use think\db\exception\ModelNotFoundException;
|
||
use think\exception\DbException;
|
||
use think\exception\PDOException;
|
||
use app\index\library\Webhook;
|
||
class Dianguanjia extends Frontend
|
||
{
|
||
protected $noNeedLogin = '*';
|
||
protected $noNeedRight = '*';
|
||
protected $layout = 'default';
|
||
public function _initialize()
|
||
{
|
||
parent::_initialize();
|
||
$this->redis = new \Redis();
|
||
$this->redis->connect('127.0.0.1', 6379);
|
||
$this->redis->auth('qwe2019@');
|
||
$this->redis->select(1);
|
||
$this->room_id = "46082512704@chatroom";//店管家通知群
|
||
$this->MyagentModel = new \app\common\model\dgj\Myagent;
|
||
$this->expressModel = new \app\common\model\wms\Express;
|
||
$this->StockModel = new \app\common\model\dgj\Stock1;
|
||
$this->OrdertmpModel = new \app\common\model\dgj\Ordertmp;
|
||
$this->StoreModel = new \app\common\model\wms\Store;
|
||
$this->OrderModel = new \app\common\model\wms\Order;
|
||
$this->OrderModel2 = new \app\common\model\wms\Deliveryorder;
|
||
$this->Exceptionwmsorder = new \app\common\model\wms\Exceptionwmsorder;
|
||
$this->WarehouseModel = new \app\common\model\Warehouse;
|
||
$this->RoomsModel = new \app\common\model\Rooms;
|
||
$this->Failureorder = new \app\common\model\wms\Failureorder;
|
||
$this->STORES = null;
|
||
$this->Webhook_lib = new Webhook('https://qyapi.weixin.qq.com/cgi-bin/webhook/send?key=cd417ebc-4252-4583-9b07-107e954cd0cf');
|
||
$this->cloudPlatformType = [
|
||
"dd"=>"toutiao",
|
||
"pdd"=>"pinduoduo",
|
||
"ali"=>"alibaba",
|
||
"jd"=>"jingdong"
|
||
];
|
||
$this->cloudPlatformTypeDb = [
|
||
"dd"=>"wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W",
|
||
"pdd"=>"wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W",
|
||
"ali"=>"wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W",
|
||
"jd"=>"wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W"
|
||
];
|
||
$this->Platform = [
|
||
"Taobao"=>1,
|
||
"KuaiShou"=>6,
|
||
"Alibaba"=>1,
|
||
"XiaoHongShu"=>8,
|
||
"Pinduoduo"=>4,
|
||
"TouTiao"=>5,
|
||
"WxVideo"=>7,
|
||
"Jingdong"=>3,
|
||
"Other_Heliang"=>6,
|
||
"JingdongPurchase"=>3,
|
||
"AlibabaC2M"=>1,
|
||
];
|
||
$this->pingtais = [
|
||
"1"=>"ali",
|
||
"3"=>"jd",
|
||
"6"=>"ali",
|
||
"8"=>"ali",
|
||
"4"=>"pdd",
|
||
"5"=>"dd",
|
||
"7"=>"ali",
|
||
"3"=>"jd"
|
||
];
|
||
$this->FieldType = [
|
||
"PrintState"=>"int",
|
||
"PlatformOrderId"=>"string",
|
||
"ErpState"=>"string",
|
||
"PlatformType"=>"string",
|
||
"ProductSubject"=>"string",
|
||
"ExpressWayBillCode"=>"string",
|
||
"CreateTime"=>"DateTime",
|
||
"ITEMS"=>"string",
|
||
"PrintRemark"=>"string",
|
||
"UpFxUserId"=>"int",
|
||
"SkuId"=>"int",
|
||
];
|
||
$this->TableName = [
|
||
"ExpressWayBillCode"=>"P_WaybillCode",
|
||
"UpFxUserId"=>"PathFlowNode"
|
||
];
|
||
$this->TableAlias = [
|
||
"ExpressWayBillCode"=>"w",
|
||
"UpFxUserId"=>"pfn"
|
||
];
|
||
$this->CustomQuery = [
|
||
"ExpressWayBillCode"=>"WaybillCode",
|
||
"PlatformOrderId"=>"PlatformOrderIdSearch"
|
||
];
|
||
$this->Contract = [
|
||
"ExpressWayBillCode"=>"in",
|
||
"CreateTime"=>"between",
|
||
"PrintRemarkyes"=>"like",
|
||
"PrintRemarkno"=>"=",
|
||
"UpFxUserId"=>"in",
|
||
"PlatformOrderId"=>"in"
|
||
];
|
||
}
|
||
public function updateLoginInfo(){
|
||
try {
|
||
$data = $this->request->post();
|
||
|
||
// 验证必要参数是否存在
|
||
$requiredFields = ['token', 'traceid', 'userAgent', 'cookieStr', 'secChUa'];
|
||
$missingFields = [];
|
||
foreach ($requiredFields as $field) {
|
||
if (!isset($data[$field]) || !$data[$field]) {
|
||
$missingFields[] = $field;
|
||
}
|
||
}
|
||
if (!empty($missingFields)) {
|
||
return json([
|
||
'code' => 400,
|
||
'msg' => '缺少必要参数: ' . implode(', ', $missingFields),
|
||
'data' => null
|
||
]);
|
||
}
|
||
// 检查Redis连接
|
||
if (!$this->redis) {
|
||
throw new \Exception('Redis连接失败');
|
||
}
|
||
|
||
// 设置数据
|
||
$this->redis->set("dianguanjia_token", $data['token']);
|
||
$this->redis->set("traceId", $data['traceid']);
|
||
$this->redis->set("dianguanjia_UserAgent", $data['userAgent']);
|
||
$this->redis->set("dianguanjia_cookie", $data['cookieStr']);
|
||
$this->redis->set("sec-ch-ua", html_entity_decode($data['secChUa']));
|
||
|
||
return json([
|
||
'code' => 200,
|
||
'msg' => '上传成功',
|
||
'data' => $data
|
||
]);
|
||
|
||
} catch (\Exception $e) {
|
||
return json([
|
||
'code' => 500,
|
||
'msg' => '操作失败: ' . $e->getMessage(),
|
||
'data' => null
|
||
]);
|
||
}
|
||
}
|
||
public function AgentList($pingtai=null){
|
||
$pingtais = [
|
||
"ali"=>"alibaba",
|
||
"pdd"=>"pinduoduo",
|
||
"jd"=>"jingdong",
|
||
"dd"=>"toutiao"
|
||
];
|
||
$pingtai = $pingtais[$pingtai];
|
||
$res = $this->LoadMyAgentList();
|
||
$totle = $res["Data"]["Total"];
|
||
$pageCount = ceil($totle/500);
|
||
$list = $res["Data"]["List"];
|
||
for($i=2;$i<=$pageCount;$i++){
|
||
$res = $this->LoadMyAgentList($i);
|
||
$list = array_merge($list, $res["Data"]["List"]);
|
||
}
|
||
$mobiles = [];
|
||
foreach($list as $r){
|
||
array_push($mobiles,$r["Mobile"]);
|
||
}
|
||
$dblist = $this->MyagentModel->where("Mobile","in",$mobiles)->where(["isShop"=>0])->select();
|
||
if($pingtai=="pinduoduo"){
|
||
$dblist2 = $this->MyagentModel->where(["isShop"=>1,"PlatformType"=>"Pinduoduo"])->select();
|
||
}elseif($pingtai=="toutiao"){
|
||
$dblist2 = $this->MyagentModel->where(["isShop"=>1,"PlatformType"=>"TouTiao"])->select();
|
||
}else{
|
||
$dblist2 = $this->MyagentModel->where(["isShop"=>1])->where("PlatformType not in ('Pinduoduo','TouTiao')")->select();
|
||
}
|
||
|
||
$storeids = [];
|
||
foreach ($dblist as $r){
|
||
array_push($storeids,$r["STOREID"]);
|
||
}
|
||
|
||
$lists = [];
|
||
foreach ($list as $index => $rr){
|
||
$STORENAME= "";
|
||
foreach ($dblist as $r){
|
||
if($rr["Mobile"]==$r["Mobile"]){
|
||
$storeid = $r["STOREID"];
|
||
$STORENAME = $this->getStoreName($r["STOREID"]);
|
||
}
|
||
}
|
||
foreach ($rr["DbAreas"] as $r){
|
||
if(strpos($r["DbName"],$pingtai)!==false){
|
||
$name = $rr["UserName"];
|
||
if($STORENAME){
|
||
$name.="【{$STORENAME}】";
|
||
}
|
||
$lists[$rr["FxUserId"]] = $name;
|
||
}
|
||
}
|
||
}
|
||
foreach ($dblist2 as $r){
|
||
$name = $r["UserName"];
|
||
$STORENAME = $this->getStoreName($r["STOREID"]);
|
||
if($STORENAME){
|
||
$name.="【{$STORENAME}】";
|
||
}
|
||
$lists[$r["Mobile"]."ShopId"] = $name;
|
||
}
|
||
return json($lists);
|
||
}
|
||
public function order_import(){
|
||
|
||
}
|
||
public function stock_import(){
|
||
$file = request()->file('file'); // 获取上传的文件
|
||
if ($file) {
|
||
$filePath = $file->getRealPath(); // 获取文件路径
|
||
$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($filePath); // 加载 XLSX 文件
|
||
$sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true); // 读取数据
|
||
$save_data_arr = [];
|
||
foreach($sheetData as $k => $r){
|
||
$save_data = [];
|
||
if($r["A"] && $r["H"]){
|
||
$save_data = ["SkuId"=>trim($r["A"]),"ITEMS"=>trim($r["H"])];
|
||
}
|
||
if($k>1 && $save_data){
|
||
array_push($save_data_arr,$save_data);
|
||
}
|
||
}
|
||
$changeLineCount = 0;
|
||
$insetLineCount = 0;
|
||
foreach($save_data_arr as $r){
|
||
$stock = $this->StockModel->where(["SkuId"=>$r["SkuId"]])->find();
|
||
if($stock){
|
||
$stock->ITEMS = $r["ITEMS"]?$r["ITEMS"]:null;
|
||
$stock->bind_time = time();
|
||
if($stock->ITEMS){
|
||
$stock->hasOrder = 0;
|
||
}
|
||
$stock->save();
|
||
$changeLineCount++;
|
||
}else{
|
||
$insetLineCount++;
|
||
}
|
||
}
|
||
$msg = "修改行数:{$changeLineCount},无记录行数:{$insetLineCount}";
|
||
return json(["msg"=>$msg]);
|
||
}
|
||
return json(["msg"=>"上传失败"]);
|
||
}
|
||
public function stock_multi(){
|
||
$this->request->filter(['strip_tags', 'trim']);
|
||
if ($this->request->isAjax()) {
|
||
$params = $this->request->post();
|
||
$ids = $params["ids"];
|
||
$params = explode("-",$params["params"]);
|
||
$pingtai = $params[1];
|
||
$method = $params[0];
|
||
switch($method){
|
||
case "export":
|
||
$ids = explode(",",$ids);
|
||
$skus = $this->StockModel->where("SkuId","in",$ids)->select();
|
||
foreach ($skus as $r){
|
||
$r["id"] = $r["SkuId"];
|
||
$r["AgentName"] = $this->getStoreName($r["myagent"]["STOREID"]);
|
||
if($r["ITEMS"]){
|
||
$r["status"] = "normal";
|
||
}else{
|
||
$r["status"] = "hidden";
|
||
}
|
||
}
|
||
$workers = [];
|
||
foreach ($skus as $r){
|
||
$tmp = [" ".$r['SkuId'],$r['SkuCode'],$r['Subject'],$r["AttributeValue"],$r["CargoNumber"],$r["SkuCargoNumber"],$r["AgentName"],$r["ITEMS"],$r["ImgUrl"]];
|
||
array_push($workers,$tmp);
|
||
}
|
||
$spreadsheet = new Spreadsheet();
|
||
$worksheet = $spreadsheet->getActiveSheet();
|
||
$title = 'SKU列表';
|
||
$worksheet->setTitle($title);
|
||
$worksheet->fromArray(
|
||
[
|
||
['SkuId','SkuCode','商品名称','规格属性','商品编码','SKU编码','货主','绑定明细','图片链接']
|
||
], '', 'A1' );
|
||
$worksheet->fromArray(
|
||
$workers, '', 'A2' );
|
||
$writer = IOFactory::createWriter($spreadsheet, 'Xls');
|
||
$filename= "dcsku".time();
|
||
$tempPath = '/www/wwwroot/ye4s.wms.gztbyc.com/public/file/'.$filename.'.xls';
|
||
$writer->save($tempPath);
|
||
return json(["code"=>1,"downloadurl"=>"https://ye4s.wms.gztbyc.com/file/".$filename.".xls","msg"=>"开始下载"]);
|
||
break;
|
||
}
|
||
}
|
||
return 1;
|
||
}
|
||
public function updateStocks(){
|
||
$startTime = time();
|
||
$countAli = $this->getStock1('ali');
|
||
$countDd = $this->getStock1('dd');
|
||
$countPdd = $this->getStock1('pdd');
|
||
$countJd = $this->getStock1('jd');
|
||
[$countI,$countU,$countA] = $this->updateStock();
|
||
return json([$countI,$countU,$countA,$countAli,$countDd,$countPdd,time()-$startTime]);
|
||
}
|
||
public function updateStockOnce1(){
|
||
return json($this->updateStockOnce("3502120188666114"));
|
||
}
|
||
public function updateStockOnce3(){
|
||
$Skuid = $this->redis->lpop('SkuId');
|
||
if($Skuid){
|
||
return json($this->updateStockOnce($Skuid));
|
||
}
|
||
}
|
||
public function updateStockOnce2(){
|
||
$SkuIds = $this->StockModel->where("UpFxUserId is null")->select();
|
||
foreach ($SkuIds as $SkuId){
|
||
$this->redis->lpush('SkuId',$SkuId["SkuId"]);
|
||
}
|
||
return 1;
|
||
}
|
||
public function updateStockOnce($skuid){
|
||
$countAli = $this->getStock1('ali',$skuid);
|
||
$countDd = $this->getStock1('dd',$skuid);
|
||
$countPdd = $this->getStock1('pdd',$skuid);
|
||
$countJd = $this->getStock1('jd',$skuid);
|
||
[$countI,$countU,$countA] = $this->updateStock();
|
||
}
|
||
public function getStock1($pingtai="",$skuid=""){
|
||
$params = $this->request->post();
|
||
$pageIndex = isset($params["pageIndex"])?$params["pageIndex"]:1;
|
||
$order_list = [];
|
||
$result = $this->ProductLoadList($pingtai,500,$pageIndex,$skuid);
|
||
$order_list = $result["Data"]["Rows"];
|
||
$listskus = [];
|
||
$count = 0;
|
||
foreach ($order_list as $r){
|
||
foreach ($r["Skus"] as $sku){
|
||
$tmp = [
|
||
"SkuId"=>$sku["SkuId"],
|
||
"AttributeValue"=>$sku["AttributeValue1"].$sku["AttributeValue2"],
|
||
"Subject"=>$r["Subject"],
|
||
"UpFxUserId"=>$r["UpFxUserId"],
|
||
"SkuCode"=>$sku["SkuCode"],
|
||
"ShopId"=>$r["ShopId"],
|
||
"PlatformType"=>$r["PlatformType"],
|
||
"CargoNumber"=>$r["CargoNumber"],
|
||
"ImgUrl"=>isset($sku["ImgUrl"])?$sku["ImgUrl"]:"",
|
||
"SkuId"=>$sku["SkuId"],
|
||
"SkuCargoNumber"=>$sku["CargoNumber"]
|
||
];
|
||
$count++;
|
||
$this->redis->lpush("stock_list",json_encode($tmp));
|
||
}
|
||
}
|
||
$totle = $result["Data"]["Total"];
|
||
$pageCount = ceil($totle/500);
|
||
for($i=2;$i<=$pageCount;$i++){
|
||
$result = $this->ProductLoadList($pingtai,500,$i);
|
||
$order_list = $result["Data"]["Rows"];
|
||
foreach ($order_list as $r){
|
||
foreach ($r["Skus"] as $sku){
|
||
$tmp = [
|
||
"SkuId"=>$sku["SkuId"],
|
||
"AttributeValue"=>$sku["AttributeValue1"].$sku["AttributeValue2"],
|
||
"Subject"=>$r["Subject"],
|
||
"UpFxUserId"=>$r["UpFxUserId"],
|
||
"SkuCode"=>$sku["SkuCode"],
|
||
"ShopId"=>$r["ShopId"],
|
||
"PlatformType"=>$r["PlatformType"],
|
||
"CargoNumber"=>$r["CargoNumber"],
|
||
"ImgUrl"=>isset($sku["ImgUrl"])?$sku["ImgUrl"]:"",
|
||
"SkuId"=>$sku["SkuId"],
|
||
"SkuCargoNumber"=>$sku["CargoNumber"]
|
||
];
|
||
$count++;
|
||
$this->redis->lpush("stock_list",json_encode($tmp));
|
||
}
|
||
}
|
||
}
|
||
|
||
return $count;
|
||
}
|
||
public function updateStock(){
|
||
$count =0;
|
||
$list = [];
|
||
$skuids = [];
|
||
do{
|
||
$data = $this->redis->rpop("stock_list");
|
||
if($data){
|
||
$has = true;
|
||
$data = json_decode($data,true);
|
||
array_push($list,$data);
|
||
array_push($skuids,($data["SkuId"] ?? null));
|
||
}else{
|
||
$has = false;
|
||
}
|
||
$count++;
|
||
}while($has);
|
||
$list2 = $this->StockModel->field("SkuId")->where("SkuId","in",$skuids)->select();
|
||
$updataIds = [];
|
||
foreach ($list2 as $r){
|
||
array_push($updataIds,$r["SkuId"]);
|
||
}
|
||
$insetDatas = [];
|
||
$updatetDatas = [];
|
||
foreach ($list as $r){
|
||
if(!in_array($r["SkuId"],$updataIds)){
|
||
$insetData = [
|
||
"SkuId"=>$r["SkuId"],
|
||
"SkuCode"=>$r["SkuCode"],
|
||
"UpFxUserId"=>$r["UpFxUserId"],
|
||
"Subject"=>$r["Subject"],
|
||
"ShopId"=>$r["ShopId"],
|
||
"AttributeValue"=>$r["AttributeValue"],
|
||
"ImgUrl"=>$r["ImgUrl"],
|
||
"PlatformType"=>$r["PlatformType"],
|
||
"CargoNumber"=>$r["CargoNumber"],
|
||
"SkuCargoNumber"=>$r["SkuCargoNumber"]
|
||
];
|
||
array_push($insetDatas,$insetData);
|
||
}else{
|
||
$insetData = [
|
||
"SkuId"=>$r["SkuId"],
|
||
"SkuCode"=>$r["SkuCode"],
|
||
"UpFxUserId"=>$r["UpFxUserId"],
|
||
"Subject"=>$r["Subject"],
|
||
"ShopId"=>$r["ShopId"],
|
||
"AttributeValue"=>$r["AttributeValue"],
|
||
"ImgUrl"=>$r["ImgUrl"],
|
||
"PlatformType"=>$r["PlatformType"],
|
||
"CargoNumber"=>$r["CargoNumber"],
|
||
"SkuCargoNumber"=>$r["SkuCargoNumber"]
|
||
];
|
||
array_push($updatetDatas,$insetData);
|
||
}
|
||
}
|
||
$ress = [];
|
||
$Acount = 0;
|
||
foreach ($updatetDatas as $r){
|
||
$res = $this->StockModel->update($r,["SkuId"=>$r["SkuId"]]);
|
||
$Acount++;
|
||
array_push($ress,$res);
|
||
}
|
||
foreach ($insetDatas as $r){
|
||
$res_tmp = $this->StockModel->create($r);
|
||
}
|
||
return [count($insetDatas),count($updatetDatas),$Acount];
|
||
}
|
||
public function order_create(){
|
||
$params = $this->request->post();
|
||
//return json($params["order"]);
|
||
$queryData = array_slice($params["order"], 0, 25);
|
||
$res = Wsdl::webservice($queryData,"createOrderDGJ");
|
||
$pingtai = $this->pingtais[$params["order"][17]];
|
||
if($params["order"][21]=="1"){
|
||
$pingtai = "ali";
|
||
}
|
||
$PrintRemark = null;
|
||
//print_r($res);
|
||
if($res==1){
|
||
$PrintRemark = $this->UpdatePrintRemark($pingtai,[$params["order"][18]],"核实需要发货",[["LogicOrderId"=>$params["order"][18],"DataFlag"=>0,"PlatformType"=>$params["order"][27],"ShopId"=>$params["order"][28]]]);
|
||
}else{
|
||
if($params["order"][25]=="no"){
|
||
$PrintRemark = $this->UpdatePrintRemark($pingtai,[$params["order"][18]],"待处理",[["LogicOrderId"=>$params["order"][18],"DataFlag"=>0,"PlatformType"=>$params["order"][27],"ShopId"=>$params["order"][28]]]);
|
||
}
|
||
}
|
||
return json(["code"=>1,"fin"=>intval($res)]);
|
||
}
|
||
public function orders_multi(){
|
||
$this->request->filter(['strip_tags', 'trim']);
|
||
if ($this->request->isAjax()) {
|
||
$params = $this->request->post();
|
||
$ITEMS = isset($params["action"])?$params["action"]:"";
|
||
$ids = $params["ids"];
|
||
$params = explode("-",$params["params"]);
|
||
$pingtai = $params[1];
|
||
$method = $params[0];
|
||
switch($method){
|
||
case "post":
|
||
$msg = "";
|
||
$k = "PlatformOrderId";
|
||
$r = $ids;
|
||
$op = ["PlatformOrderId"=>"in"];
|
||
$filters = [
|
||
[
|
||
'TableAlias' => isset($this->TableAlias[$k])?$this->TableAlias[$k]:'o',
|
||
'FieldType' => $this->FieldType[$k],
|
||
'TableName' => isset($this->TableName[$k])?$this->TableName[$k]:'LogicOrder',
|
||
'Name' => $k,
|
||
'Value' => $r,
|
||
'Contract' => isset($this->Contract[$k])?$this->Contract[$k]:$op[$k],
|
||
'CustomQuery'=>'PlatformOrderIdSearch'
|
||
]
|
||
];
|
||
$MultiFilters = [];
|
||
$result = $this->NewOrderList1($pingtai,$filters,$MultiFilters,10,1);
|
||
$list = [];
|
||
foreach ($result["rows"] as $r){
|
||
if($r["storeid"]>0 && $r["ITEMS"]!=""){
|
||
$r = "{$r['PlatformOrderId']},{$this->Platform[$r['PlatformType']]}";
|
||
array_push($list,$r);
|
||
}
|
||
}
|
||
$list = implode("|",$list);
|
||
$data = ["orders"=>$list,"expressName"=>"申通"];
|
||
$req = $this->Print($list,"申通");
|
||
return json(["code"=>1,"msg"=>$msg,"queryData"=>$data,"datas"=>$req]);
|
||
break;
|
||
case "sh":
|
||
$result = $this->OrdertmpModel->where("PlatformOrderId","in",$ids)->select();
|
||
$k = "PlatformOrderId";
|
||
$r = $ids;
|
||
$result1 = [];
|
||
foreach ($result as $r){
|
||
array_push($result1,json_decode($r["datas"],true));
|
||
}
|
||
$result = $this->NewOrderList2($result1);
|
||
$list = [];
|
||
$count = count($result["rows"]);
|
||
$successCount = 0;
|
||
$failCount = 0;
|
||
$unbindCount = 0;
|
||
foreach ($result["rows"] as $r){
|
||
if($ITEMS){
|
||
$r['ITEMS']=$ITEMS;
|
||
}
|
||
if($r["storeid"]>0 && $r["ITEMS"]!=""){
|
||
$info = $this->createOrder($r);
|
||
if($info){
|
||
array_push($list,$info);
|
||
}
|
||
}else{
|
||
$unbindCount ++;
|
||
}
|
||
}
|
||
$msg = "提交{$count}条数据,未绑定货主或SKU跳过条数{$unbindCount}";
|
||
return json(["code"=>1,"msg"=>$msg,"createOrderdatas"=>$list]);
|
||
break;
|
||
case "export":
|
||
$k = "PlatformOrderId";
|
||
$r = $ids;
|
||
$op = ["PlatformOrderId"=>"in"];
|
||
$filters = [
|
||
[
|
||
'TableAlias' => isset($this->TableAlias[$k])?$this->TableAlias[$k]:'o',
|
||
'FieldType' => $this->FieldType[$k],
|
||
'TableName' => isset($this->TableName[$k])?$this->TableName[$k]:'LogicOrder',
|
||
'Name' => $k,
|
||
'Value' => $r,
|
||
'Contract' => isset($this->Contract[$k])?$this->Contract[$k]:$op[$k],
|
||
'CustomQuery'=>'PlatformOrderIdSearch'
|
||
]
|
||
];
|
||
$MultiFilters = [];
|
||
$result = $this->NewOrderList1($pingtai,$filters,$MultiFilters,500,1);
|
||
$list = [];
|
||
foreach ($result["rows"] as $r){
|
||
if($r["storeid"]>0 && $r["ITEMS"]!=""){
|
||
$info = $this->splitOrder($r);
|
||
foreach ($info as $rr){
|
||
array_push($list,$rr);
|
||
}
|
||
}
|
||
}
|
||
$pingtaiName = [
|
||
"0"=>"其他平台",
|
||
"1"=>"淘宝系列",
|
||
"3"=>"京东",
|
||
"4"=>"拼多多",
|
||
"5"=>"抖音",
|
||
"6"=>"快手",
|
||
"7"=>"视频号",
|
||
"8"=>"小红书",
|
||
"9"=>"唯品会",
|
||
"10"=>"得物"
|
||
];
|
||
$workers = [];
|
||
foreach ($list as $r){
|
||
$tmp = [$r[12],$r[28],$r[25],$r[26],$r[1],$r[2],$r[6],isset($r[27][0])?$r[27][0]['ExpressName']:"",$r[24],$pingtaiName[$r[17]],"店管家".$r[18],"","","",$r[10]];
|
||
array_push($workers,$tmp);
|
||
}
|
||
$spreadsheet = new Spreadsheet();
|
||
$worksheet = $spreadsheet->getActiveSheet();
|
||
$title = 'poi测试';
|
||
$worksheet->setTitle($title);
|
||
$worksheet->fromArray(
|
||
[
|
||
['外部订单编号','平台交易单号','SKU编号(必填)','数量(必填)','收件人(必填)','电话(必填)','(必填)','快递(必填)','快递平台','平台','店铺','寄件人电话','寄件人地址','卖家留言','订单总金额','货到付款','出库单','外部编码']
|
||
], '', 'A1' );
|
||
$worksheet->fromArray(
|
||
$workers, '', 'A2' );
|
||
$writer = IOFactory::createWriter($spreadsheet, 'Xls');
|
||
$filename= "dcdd".time();
|
||
$tempPath = '/www/wwwroot/ye4s.wms.gztbyc.com/public/file/'.$filename.'.xls';
|
||
$writer->save($tempPath);
|
||
return json(["code"=>1,"downloadurl"=>"https://ye4s.wms.gztbyc.com/file/".$filename.".xls","msg"=>"开始下载"]);
|
||
break;
|
||
}
|
||
}
|
||
return 1;
|
||
}
|
||
public function orders($pingtai="ali"){
|
||
$this->request->filter(['strip_tags', 'trim']);
|
||
if ($this->request->isAjax()) {
|
||
$limit = $this->request->get("limit");
|
||
$offset = $this->request->get("offset");
|
||
$filter = json_decode($this->request->get("filter"),true);
|
||
$op = json_decode($this->request->get("op"),true);
|
||
$filters = [];
|
||
$MultiFilters = [];
|
||
foreach ($filter as $k => $r){
|
||
$tmp = [
|
||
'TableAlias' => isset($this->TableAlias[$k])?$this->TableAlias[$k]:'o',
|
||
'FieldType' => $this->FieldType[$k],
|
||
'TableName' => isset($this->TableName[$k])?$this->TableName[$k]:'LogicOrder',
|
||
'Name' => $k,
|
||
'Value' => $r,
|
||
'Contract' => isset($this->Contract[$k])?$this->Contract[$k]:($op[$k] ?? null),
|
||
'CustomQuery'=>isset($this->CustomQuery[$k])?$this->CustomQuery[$k]:''
|
||
];
|
||
if($k=="PrintRemark"){
|
||
$tmpContract="PrintRemark".$r;
|
||
$tmp["Contract"] = isset($this->Contract[$tmpContract])?$this->Contract[$tmpContract]:$op[$k];
|
||
$tmp["Value"] = $r=="no"?"":"核实需要发货";
|
||
}
|
||
if(isset($this->Contract[$k]) && $this->Contract[$k]=="between"){
|
||
$data_split = explode(" - ",$r);
|
||
$tmp["Value"] = trim($data_split[0]);
|
||
$tmp["ExtValue"] = trim($data_split[1]);
|
||
if($k=="CreateTime"){
|
||
$tmp["ExtValue"].=".999";
|
||
}
|
||
}
|
||
if($k=="UpFxUserId" && strpos($tmp['Value'],"ShopId")){
|
||
$tmp['TableName']= "LogicOrder";
|
||
$tmp['Value'] = str_replace("ShopId", "", $tmp['Value']);
|
||
$tmp['Name'] = "ShopId";
|
||
$tmp['TableAlias'] = "o";
|
||
}
|
||
if($k=="ITEMS"){
|
||
$skus = $this->StockModel->where(["ITEMS"=>$r])->select();
|
||
//$stocklist = $this->ProductLoadList1();
|
||
$skucodes = [];
|
||
foreach ($skus as $rr){
|
||
array_push($skucodes,$rr["SkuCode"]);
|
||
}
|
||
$skucodes = implode(",",$skucodes);
|
||
$tmp = [[
|
||
"TableAlias"=>"oi",
|
||
"FieldType"=>"string",
|
||
"TableName"=>"P_OrderItem",
|
||
"Name"=>"SkuCode",
|
||
"Value"=>$skucodes,
|
||
"Contract"=>"in",
|
||
"Operator"=>"OR"
|
||
]];
|
||
array_push($MultiFilters,$tmp);
|
||
}elseif($k=="SkuId"){
|
||
$tmp = [[
|
||
"TableAlias"=>"oi",
|
||
"FieldType"=>"string",
|
||
"TableName"=>"P_OrderItem",
|
||
"Name"=>"SkuId",
|
||
"Value"=>preg_replace('/\s+/', '', $r),
|
||
"Contract"=>"in",
|
||
"Operator"=>"OR"
|
||
]];
|
||
array_push($MultiFilters,$tmp);
|
||
}else{
|
||
array_push($filters,$tmp);
|
||
}
|
||
}
|
||
$pageSize = $limit;
|
||
|
||
$pageIndex = ($offset/$limit)+1;
|
||
$result = $this->NewOrderList1($pingtai,$filters,$MultiFilters,$pageSize,$pageIndex);
|
||
return json($result);
|
||
}
|
||
return $this->view->fetch();
|
||
}
|
||
public function stock($pingtai="ali"){
|
||
$this->request->filter(['strip_tags', 'trim']);
|
||
if ($this->request->isAjax()) {
|
||
$limit = $this->request->get("limit");
|
||
$offset = $this->request->get("offset");
|
||
$filter = json_decode($this->request->get("filter"),true);
|
||
$op = json_decode($this->request->get("op"),true);
|
||
$type = 0;
|
||
$query = [
|
||
|
||
];
|
||
$skuid = "";
|
||
$CargoNumber = "";
|
||
$SkuCargoNumber = "";
|
||
$status2 = "";
|
||
$SelectAgentId = "";
|
||
$status = [
|
||
"normal"=>1,
|
||
"hidden"=>2
|
||
];
|
||
$where = [];
|
||
$skuids = [];
|
||
if($filter){
|
||
|
||
$skucodes = "";
|
||
$type = isset($filter["status"])?$status[$filter["status"]]:0;
|
||
$skuid = isset($filter["SkuId"])?$filter["SkuId"]:"";
|
||
if($skuid){
|
||
$skuids = explode(",",trim($skuid));
|
||
$tmp_skus = [];
|
||
foreach ($skuids as $r){
|
||
$tmp_sku = trim($r);
|
||
array_push($tmp_skus,$tmp_sku);
|
||
}
|
||
$tmp_skus_text = implode("','",$tmp_skus);
|
||
array_push($where,"SkuId in ('{$tmp_skus_text}')");
|
||
}
|
||
$status2 = isset($filter["status2"])?$filter["status2"]:"";
|
||
$PlatformType = isset($filter["PlatformType"])?$filter["PlatformType"]:"";
|
||
if($PlatformType){
|
||
array_push($where,"stock1.PlatformType = '{$PlatformType}'");
|
||
}
|
||
$CargoNumber = isset($filter["CargoNumber"])?$filter["CargoNumber"]:"";
|
||
if($CargoNumber){
|
||
array_push($where,"CargoNumber like '%{$CargoNumber}%'");
|
||
}
|
||
$hasOrder = isset($filter["hasOrder"])?$filter["hasOrder"]:"";
|
||
if($hasOrder){
|
||
array_push($where,"hasOrder = {$hasOrder}");
|
||
}
|
||
$SkuCargoNumber = isset($filter["SkuCargoNumber"])?$filter["SkuCargoNumber"]:"";
|
||
if($SkuCargoNumber){
|
||
array_push($where,"SkuCargoNumber like '%{$SkuCargoNumber}%'");
|
||
}
|
||
$AttributeValue = isset($filter["AttributeValue"])?$filter["AttributeValue"]:"";
|
||
if($AttributeValue){
|
||
array_push($where,"AttributeValue like '%{$AttributeValue}%'");
|
||
}
|
||
$SelectAgentId = isset($filter["AgentName"])?$filter["AgentName"]:"";
|
||
if($SelectAgentId){
|
||
array_push($where,"myagent.STOREID ={$SelectAgentId}");
|
||
}
|
||
$ITEMS = isset($filter["ITEMS"])?$filter["ITEMS"]:"";
|
||
if($ITEMS){
|
||
array_push($where,"ITEMS ={$ITEMS}");
|
||
}
|
||
$bind_time = isset($filter["bind_time"])?$filter["bind_time"]:"";
|
||
if($bind_time){
|
||
$bind_time = explode("-",$bind_time);
|
||
$st = strtotime(trim($bind_time[0]."-".$bind_time[1]."-".$bind_time[2]));
|
||
$et = strtotime(trim($bind_time[3]."-".$bind_time[4]."-".$bind_time[5]));
|
||
array_push($where,"bind_time between {$st} and {$et}");
|
||
}
|
||
$create_time = isset($filter["create_time"])?$filter["create_time"]:"";
|
||
if($create_time){
|
||
$create_time = explode("-",$create_time);
|
||
$st = strtotime(trim($create_time[0]."-".$create_time[1]."-".$create_time[2]));
|
||
$et = strtotime(trim($create_time[3]."-".$create_time[4]."-".$create_time[5]));
|
||
array_push($where,"bind_time between {$st} and {$et}");
|
||
}
|
||
|
||
}
|
||
if($type==1){
|
||
array_push($where,"ITEMS is not null and ITEMS<>''");
|
||
}elseif($type==2){
|
||
array_push($where,"ITEMS is null or ITEMS=''");
|
||
}
|
||
foreach ($where as $k => $r){
|
||
$where[$k] = "({$r})";
|
||
}
|
||
$where = implode(" and ",$where);
|
||
$list = $this->StockModel
|
||
->where($where)
|
||
->with(['myagent'])
|
||
->order('create_time','desc')
|
||
->paginate($limit);
|
||
$items = $list->items();
|
||
foreach ($items as $r){
|
||
$r["id"] = $r["SkuId"];
|
||
$r["AgentName"] = $this->getStoreName($r["myagent"]["STOREID"]);
|
||
if($r["ITEMS"]){
|
||
$r["status"] = "normal";
|
||
}else{
|
||
$r["status"] = "hidden";
|
||
}
|
||
}
|
||
$result = ['total' => $list->total(), 'rows' => $items];
|
||
return json($result);
|
||
}
|
||
return $this->view->fetch();
|
||
}
|
||
public function createBc($pingtai=""){
|
||
$startTime = time();
|
||
$lastTime = $this->redis->get("ttl-".$pingtai);
|
||
$lastTime = $lastTime?$lastTime:5;
|
||
$time = $this->redis->ttl("bc-".$pingtai);
|
||
$time = $time?$time:0;
|
||
$MultiFilters = [];
|
||
$k = "ErpState";
|
||
$r = "waitsellersend";
|
||
$op = ["ErpState"=>"="];
|
||
$filters = [[
|
||
'TableAlias' => isset($this->TableAlias[$k])?$this->TableAlias[$k]:'o',
|
||
'FieldType' => $this->FieldType[$k],
|
||
'TableName' => isset($this->TableName[$k])?$this->TableName[$k]:'LogicOrder',
|
||
'Name' => $k,
|
||
'Value' => $r,
|
||
'Contract' => isset($this->Contract[$k])?$this->Contract[$k]:$op[$k],
|
||
'CustomQuery'=>isset($this->CustomQuery[$k])?$this->CustomQuery[$k]:''
|
||
]];
|
||
$order_list = [];
|
||
$skuids = [];
|
||
if($time>$lastTime+5){
|
||
return "";
|
||
}
|
||
$result = $this->NewOrderList1($pingtai,$filters,$MultiFilters,500,1);
|
||
$maxpage = ceil($result["total"]/500);
|
||
$order_list = array_merge($order_list,$result["rows"]);
|
||
for($i=2;$i<=$maxpage;$i++){
|
||
$result = $this->NewOrderList1($pingtai,$filters,$MultiFilters,500,$i);
|
||
$order_list = array_merge($order_list,$result["rows"]);
|
||
}
|
||
foreach ($order_list as $r){
|
||
foreach ($r["SubOrders"] as $rr){
|
||
array_push($skuids,$rr["SkuId"]);
|
||
}
|
||
}
|
||
$data = [];
|
||
foreach ($skuids as $r){
|
||
if(!array_key_exists($r,$data)){
|
||
$data[$r] = 1;
|
||
}else{
|
||
$data[$r] += 1;
|
||
}
|
||
}
|
||
$data2 = [];
|
||
foreach ($data as $k =>$r){
|
||
array_push($data2,["key"=>$k,"value"=>$r]);
|
||
}
|
||
usort($data2, function($a, $b) {
|
||
return $b["value"] - $a["value"];
|
||
});
|
||
$data = [];
|
||
foreach ($data2 as $i){
|
||
$data[$i["key"]] = "skuid:".$i["key"]."数量:".$i["value"];
|
||
}
|
||
$useTime = time()-$startTime;
|
||
$this->redis->setex("bc-".$pingtai,$useTime*10,json_encode($data));
|
||
$this->redis->set("ttl-".$pingtai,$useTime);
|
||
return $pingtai."1".$useTime*10;
|
||
}
|
||
public function getBc($pingtai = ""){
|
||
$res = $this->redis->get("bc-".$pingtai);
|
||
$res = json_decode($res,true);
|
||
return json($res);
|
||
}
|
||
private function createOrder($order){
|
||
$items = explode(",",$order["ITEMS"]);
|
||
$items_arr = [];
|
||
foreach($items as $r){
|
||
$skuitem = explode("|",$r);
|
||
$is_only = false;
|
||
$skuitem = implode(",",$skuitem);
|
||
array_push($items_arr,$skuitem);
|
||
}
|
||
$item = implode("|",$items_arr);
|
||
$PlatformType = $this->Platform[$order['PlatformType']];
|
||
$customerId = "0";
|
||
if($order['PlatformType'] == "Alibaba"){
|
||
//判断是否抖音分销单
|
||
$PlatformType = 1;
|
||
if(isset($order["OrderTags"][0]) && ($order["OrderTags"][0]['TagValue']=="douyin" || $order["ExtField1"]=="douyin")){
|
||
$PlatformType = 5;
|
||
$customerId = "1";
|
||
}
|
||
if(isset($order["OrderTags"][0]) && ($order["OrderTags"][0]['TagValue']=="pinduoduo" || $order["ExtField1"]=="pinduoduo")){
|
||
$PlatformType = 4;
|
||
$customerId = "1";
|
||
}
|
||
if(isset($order["OrderTags"][0]) && ($order["OrderTags"][0]['TagValue']=="kuaishou" || $order["ExtField1"]=="kuaishou")){
|
||
$PlatformType = 6;
|
||
$customerId = "1";
|
||
}
|
||
if(isset($order["OrderTags"][0]) && ($order["OrderTags"][0]['TagValue']=="xiaohongshu" || $order["ExtField1"]=="xiaohongshu")){
|
||
$PlatformType = 8;
|
||
$customerId = "1";
|
||
}
|
||
if(isset($order["OrderTags"][0]) && ($order["OrderTags"][0]['TagValue']=="jingdong" || $order["ExtField1"]=="jingdong")){
|
||
$PlatformType = 3;
|
||
$customerId = "1";
|
||
}
|
||
}
|
||
$data = [$order["storeid"],$order["ToName"],$order["ToPhone"],$order["ToProvince"],$order["ToCity"],$order["ToCounty"],$order["ToFullAddress"],0,"申通","","{$order['TotalAmount']}","0",$order["PlatformOrderId"],"Z15",0,0,$order["BuyerRemark"].$order["SellerRemark"].$order["SystemRemark"],$PlatformType,$order["LogicOrderId"],$order["ShopName"],"",$customerId,$order["PayTime"],"",$item,$order["PrintRemark"],"flag".$order["SellerRemarkFlag"],$order["PlatformType"],$order["ShopId"]];
|
||
//$data[20] = implode(",",$data);
|
||
|
||
/*$res = Wsdl::webservice($data,"createOrderDGJ");
|
||
$pingtai = $this->pingtais[$this->Platform[$order['PlatformType']]];
|
||
$PrintRemark = null;
|
||
if($res==1){
|
||
$PrintRemark = $this->UpdatePrintRemark($pingtai,[$order["LogicOrderId"]],"核实需要发货");
|
||
}else{
|
||
if($order["PrintRemark"]=="no"){
|
||
$PrintRemark = $this->UpdatePrintRemark($pingtai,[$order["PlatformOrderId"]],"wms审核失败");
|
||
}
|
||
}*/
|
||
return $data;
|
||
}
|
||
private function splitOrder($order){
|
||
$items = explode(",",$order["ITEMS"]);
|
||
$list = [];
|
||
foreach ($items as $r){
|
||
$skuitem = explode("|",$r);
|
||
$data = [$order["storeid"],$order["ToName"],$order["ToPhone"],$order["ToProvince"],$order["ToCity"],$order["ToCounty"],$order["ToFullAddress"],0,"","",$order["TotalAmount"],0,$order["PlatformOrderId"],"Z15",0,0,$order["BuyerRemark"],$this->Platform[$order["PlatformType"]],$order["ShopName"],"","",$order["PayTime"],"",$order["ITEMS"],$order["ExpressWayBillCode"],$skuitem[0],$skuitem[1],$order["WaybillCodes"],$order["LogicOrderId"]];
|
||
array_push($list,$data);
|
||
}
|
||
return $list;
|
||
//return [$order["storeid"],$order["ToName"],$order["ToPhone"],$order["ToProvince"],$order["ToCity"],$order["ToCounty"],$order["ToAddress"],0,"","",$order["TotalAmount"],0,$order["PlatformOrderId"],"Z15",0,0,$order["BuyerRemark"],$this->Platform[$order["PlatformType"]],$order["ShopName"],"","",$order["PayTime"],"",$order["ITEMS"]];
|
||
}
|
||
public function edit_stock($ids = null){
|
||
$row = $this->StockModel->where(["SkuId"=>$ids])->with(['myagent'])->find();
|
||
$row["AgentName"] = $this->getStoreName(($row["myagent"]["STOREID"] ?? null));
|
||
if (!$row) {
|
||
$this->error(__('No Results were found'));
|
||
}
|
||
if (false === $this->request->isPost()) {
|
||
$this->view->assign('row', $row);
|
||
return $this->view->fetch();
|
||
}
|
||
$params = $this->request->post('row/a');
|
||
if (empty($params)) {
|
||
$this->error(__('Parameter %s can not be empty', ''));
|
||
}
|
||
$row->ITEMS = isset($params["ITEMS"])&&$params["ITEMS"]?$params["ITEMS"]:null;
|
||
if($row->ITEMS && $row->hasOrder){
|
||
$row->hasOrder = 0;
|
||
}
|
||
unset($row->AgentName);
|
||
$row->bind_time = time();
|
||
$row->save();
|
||
$this->success();
|
||
}
|
||
public function update_edit_stock(){
|
||
$skus = $this->StockModel->where(["SkuCode"=>null])->select();
|
||
foreach ($skus as $rrrr){
|
||
$ids = $rrrr["SkuId"];
|
||
$pingtais = [
|
||
"ali",
|
||
"pdd",
|
||
"jd",
|
||
"dd"
|
||
];
|
||
$list = [];
|
||
foreach ($pingtais as $r){
|
||
$list = $this->ProductLoadList($r,1,1,$ids);
|
||
if($list["Data"]["Total"]>0){
|
||
break;
|
||
}
|
||
}
|
||
$row = null;
|
||
foreach ($list["Data"]["Rows"] as $r){
|
||
foreach ($r["Skus"] as $rr){
|
||
if($rr["SkuId"]==$ids){
|
||
$rr["id"] = $rr["SkuId"];
|
||
$rr["Subject"] = $r["Subject"];
|
||
$row = $rr;
|
||
}
|
||
}
|
||
}
|
||
if($row){
|
||
$rrrr->SkuCode = $row["SkuCode"];
|
||
$rrrr->save();
|
||
}
|
||
|
||
}
|
||
$this->success();
|
||
}
|
||
public function NewOrderListout(){
|
||
$params = $this->request->post();
|
||
$res = $this->NewOrderList1($params["pingtai"],$params["filters"],$params["MultiFilters"],$params["pageSize"],$params["pageIndex"]);
|
||
return json($res);
|
||
}
|
||
public function LoadTemplateListInOrderListout(){
|
||
$params = $this->request->post();
|
||
$res = $this->LoadTemplateListInOrderList($params["pingtai"]);
|
||
return json($res);
|
||
}
|
||
public function ExpressPrintout(){
|
||
$params = $this->request->post();
|
||
$res = [];
|
||
try {
|
||
$res = $this->ExpressPrint($params["pingtai"],$params["orderList"],$params["Template"],$params["ispdd"]);
|
||
} catch (Exception $e) {
|
||
return json($e);
|
||
}
|
||
return json($res);
|
||
}
|
||
private function setOrderTmp($list){
|
||
if($list && count($list)>0){
|
||
$newList = [];
|
||
$LogicOrderIds = [];
|
||
foreach ($list as $r){
|
||
array_push($LogicOrderIds,$r["LogicOrderId"]);
|
||
array_push($newList,["LogicOrderId"=>strval($r["LogicOrderId"]),"PlatformOrderId"=>strval($r["PlatformOrderId"]),"datas"=>json_encode($r)]);
|
||
}
|
||
$newList1 = [];
|
||
$dbList = $this->OrdertmpModel->where("LogicOrderId","in",$LogicOrderIds)->select();
|
||
Db::startTrans();
|
||
$insert_data = [];
|
||
try {
|
||
foreach ($dbList as $r){
|
||
foreach ($newList as $rr){
|
||
if($r["LogicOrderId"]==$rr["LogicOrderId"]){
|
||
array_push($newList1,$r["LogicOrderId"]);
|
||
$r->datas = $rr["datas"];
|
||
$r->save();
|
||
}
|
||
}
|
||
}
|
||
foreach ($newList as $rr){
|
||
if(!in_array($rr["LogicOrderId"],$newList1)){
|
||
$OrdertmpModel = new \app\common\model\dgj\Ordertmp;
|
||
$OrdertmpModel->save($rr);
|
||
}
|
||
}
|
||
Db::commit();
|
||
} catch (\Exception $e) {
|
||
// 发生异常时回滚事务
|
||
Db::rollback();
|
||
echo $e;
|
||
die();
|
||
}
|
||
}
|
||
}
|
||
|
||
private function NewOrderList2($list){
|
||
$orders = $this->handleOrder($list);
|
||
$lists = [];
|
||
foreach($orders as $r){
|
||
$tmp = $r["ToName"].",".$r["ToPhone"].",".$r["ToFullAddress"];
|
||
$r["ToInfo"] = $this->truncateString($tmp);
|
||
$r["ProductImgUrl"] = $r["SubOrders"][0]["ProductImgUrl"];
|
||
$r["ExpressWayBillCode"] = $r["LastWaybillCode"];
|
||
$r["CreateTime"] = $r["OrderTime"];
|
||
$r["id"] = $r["PlatformOrderId"];
|
||
$r["Remark"] = $r["PrintRemark"];
|
||
$r["UpFxUserId"] = $r["ShopName"];
|
||
$r["PrintRemark"] = strpos($r["PrintRemark"],"核实需要发货")===false?"no":"yes";
|
||
$products = [];
|
||
foreach($r["SubOrders"] as $SubOrders){
|
||
array_push($products,$SubOrders["ProductSubject"]."|".$SubOrders["CargoNumber"]."|".$SubOrders["productCargoNumber"]."|".$SubOrders["Color"]."【{$SubOrders['Count']}】");
|
||
}
|
||
$r["ProductSubject"] = implode("\n",$products);
|
||
array_push($lists,$r);
|
||
}
|
||
return ["total"=>count($lists),"rows"=>$lists];
|
||
}
|
||
private function NewOrderList1($pingtai,$filters,$MultiFilters,$pageSize,$pageIndex){
|
||
$list = $this->NewOrderList($pingtai,$filters,$MultiFilters,$pageSize,$pageIndex);
|
||
$this->setOrderTmp($list["Data"]["Rows"]);
|
||
$orders = $this->handleOrder($list["Data"]["Rows"]);
|
||
//$lists = [];
|
||
/*foreach ($orders as $r){
|
||
$res = $this->createOrder($r);
|
||
array_push($lists,$res);
|
||
}*/
|
||
//$this->noticCreateOrderErr();
|
||
$lists = [];
|
||
foreach($orders as $r){
|
||
$tmp = $r["ToName"].",".$r["ToPhone"].",".$r["ToFullAddress"];
|
||
$r["ToInfo"] = $this->truncateString($tmp);
|
||
$r["ProductImgUrl"] = $r["SubOrders"][0]["ProductImgUrl"];
|
||
$r["ExpressWayBillCode"] = $r["LastWaybillCode"];
|
||
$r["CreateTime"] = $r["OrderTime"];
|
||
$r["id"] = $r["PlatformOrderId"];
|
||
$r["Remark"] = $r["PrintRemark"];
|
||
$r["UpFxUserId"] = $r["ShopName"];
|
||
if($r["ErpRefundState"]=="REFUND_SUCCESS" || $r["ErpRefundState"]=="close"){
|
||
$this->checkHasOrderAndFlag($r["LogicOrderId"]."|".$r["ExpressWayBillCode"]);
|
||
}
|
||
if($r["ErpRefundState"]=="sended"){
|
||
$this->checkHasOrderSync($r["LogicOrderId"]."|".$r["ExpressWayBillCode"]);
|
||
}
|
||
$r["PrintRemark"] = strpos($r["PrintRemark"],"核实需要发货")===false?"no":"yes";
|
||
$products = [];
|
||
foreach($r["SubOrders"] as $SubOrders){
|
||
array_push($products,$SubOrders["ProductSubject"]."|".$SubOrders["CargoNumber"]."|".$SubOrders["productCargoNumber"]."|".$SubOrders["Color"]."【{$SubOrders['Count']}】");
|
||
}
|
||
$r["ProductSubject"] = implode("\n",$products);
|
||
array_push($lists,$r);
|
||
}
|
||
return ["total"=>$list["Data"]["Total"],"rows"=>$lists];
|
||
}
|
||
private function checkHasOrderAndFlag($orderID){
|
||
$this->redis->lpush("checkHasOrderAndFlag",$orderID);
|
||
}
|
||
private function checkHasOrderSync($orderID){
|
||
$this->redis->lpush("checkHasOrderSync",$orderID);
|
||
}
|
||
private function truncateString($string, $length = 32, $append = '...') {
|
||
if (mb_strlen($string, 'UTF-8') > $length) {
|
||
$string = mb_substr($string, 0, $length, 'UTF-8');
|
||
$string = preg_replace('/\p{C}+/u', '', $string); // Remove control characters
|
||
$string .= $append;
|
||
}
|
||
return $string;
|
||
}
|
||
private function UpdatePrintRemark($pingtai,$orderids,$text,$LogicOrderIdModels=[]){
|
||
$url = "https://fx{$pingtai}.dgjapp.com/NewOrder/UpdatePrintRemark";
|
||
$params = [
|
||
"LogicOrderIdModels"=>$LogicOrderIdModels,
|
||
"logicOrderIds"=>$orderids,
|
||
"Remark"=>$text,
|
||
"IsCustomerOrder"=>"false",
|
||
"FxPageType"=>"2"
|
||
];
|
||
$dbname="wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W";
|
||
$res = $this->sendProxyRequest($url,$params,$dbname);
|
||
return $res;
|
||
}
|
||
public function LoadAfterSaleList1($pingtai = null){
|
||
$pageSize = 10;
|
||
$pageIndex = 1;
|
||
$startTime = "2025-04-15 00:00:00";
|
||
$endTime = "2025-04-15 23:59:59.999";
|
||
$res = $this->LoadAfterSaleList($pingtai,$startTime,$endTime,$pageSize,$pageIndex);
|
||
$totle = $res["Data"]["Total"];
|
||
$pageCount = ceil($totle/$pageSize);
|
||
$list = $res["Data"]["List"];
|
||
for($i=2;$i<=$pageCount;$i++){
|
||
$res = $this->LoadAfterSaleList($pingtai,$startTime,$endTime,$pageSize,$i);
|
||
$list = array_merge($list, $res["Data"]["List"]);
|
||
}
|
||
$lists = [];
|
||
$PlatformOrderIds = [];
|
||
foreach ($list as $index => $r){
|
||
foreach ($r["Orders"] as $rr){
|
||
$tmporders = [
|
||
"PlatformOrderId"=>$rr["PlatformOrderId"],
|
||
"ApplyTime"=>strtotime($rr["ApplyTime"]),
|
||
"ReturnTrackingNo"=>$rr["ReturnTrackingNo"],
|
||
"ReturnCompanyName"=>$rr["ReturnCompanyName"],
|
||
"Reason"=>$rr["Reason"]
|
||
];
|
||
array_push($PlatformOrderIds,$rr["PlatformOrderId"]);
|
||
array_push($lists,$tmporders);
|
||
}
|
||
}
|
||
|
||
return json(["rows"=>$lists,"total"=>$totle]);
|
||
}
|
||
private function getWmsOrderBy($codes){
|
||
$orders = $OrderModel->where()->select();
|
||
}
|
||
public function getRefundOrder($pingtai=""){
|
||
$MultiFilters = [[[
|
||
"TableAlias"=>"o",
|
||
"FieldType"=>"string",
|
||
"TableName"=>"LogicOrder",
|
||
"Name"=>"PrintRemark",
|
||
"Value"=>"已取消",
|
||
"Contract"=>"not like",
|
||
"Operator"=>"AND"
|
||
]]];
|
||
$filters = [[
|
||
'TableAlias' => 'o',
|
||
'FieldType' => 'string',
|
||
'TableName' => 'LogicOrder',
|
||
'Name' => "ErpRefundState",
|
||
'Value' => "REFUND_SUCCESS",
|
||
'Contract' => "="
|
||
],[
|
||
'TableAlias' =>'o',
|
||
'FieldType' => 'string',
|
||
'TableName' => 'LogicOrder',
|
||
'Name' => "PrintRemark",
|
||
'Value' => "核实需要发货",
|
||
'Contract' => "like",
|
||
'Operator' => "AND"
|
||
]];
|
||
$result = $this->NewOrderList1($pingtai,$filters,$MultiFilters,100,1);
|
||
$rows = $result["rows"];
|
||
$PlatformOrderId = [];
|
||
$PlatformOrderId2 = [];
|
||
$rows2 = [];
|
||
foreach ($rows as $k => $r){
|
||
if($r["ErpRefundState"]=="REFUND_SUCCESS" && $r["ErpState"]=="close"){
|
||
array_push($rows2,$r);
|
||
}
|
||
}
|
||
foreach ($rows2 as $r){
|
||
array_push($PlatformOrderId,$r["PlatformOrderId"]);
|
||
$PlatformOrderId2[$r["LogicOrderId"]] = [$r["Remark"],$r["PlatformType"],$r["ShopId"]];
|
||
}
|
||
if(count($PlatformOrderId)>0){
|
||
$orderList = $this->OrderModel->where("SOURCEID","in",$PlatformOrderId)->select();
|
||
}else{
|
||
return "";
|
||
}
|
||
$lanjieSuccess = [];
|
||
$posttype = [];
|
||
$postStore = [];
|
||
$msgs = [];
|
||
foreach ($orderList as $r){
|
||
|
||
if(strpos($r["GRABNUM"],"B")!==false){//团购
|
||
if($r["POSTFLAG"]==0){
|
||
|
||
}
|
||
if($r["PLSENDFLAG"]==0){
|
||
//拦截
|
||
$this->updateInterceptorder($r["ID"],0);
|
||
}
|
||
}else{
|
||
if($r["WEIGHT"]==0){
|
||
//拦截
|
||
$this->updateInterceptorder($r["ID"],0);
|
||
}
|
||
}
|
||
$POSTNUM = $this->getPOSTNUMonList($rows,$r["SOURCEID"]);
|
||
|
||
if(count($POSTNUM)>0){
|
||
//,创建工单
|
||
if($r["STOREID"]==17001 || $r["STOREID"]==16201 || $r["STOREID"]==58300){
|
||
continue;
|
||
}
|
||
$lsnjieres = $this->createExceptionWmsOrder(12,$r["ID"],"店管家自动检测退款成功","");
|
||
|
||
foreach ($POSTNUM as $rrr){
|
||
if(array_key_exists($r["POSTCODE"], $posttype)){
|
||
array_push($posttype[$r["POSTCODE"]],$rrr);
|
||
}else{
|
||
$posttype[$r["POSTCODE"]] = [$rrr];
|
||
}
|
||
}
|
||
foreach ($POSTNUM as $rrr){
|
||
|
||
if(array_key_exists($r["STOREID"], $postStore)){
|
||
array_push($postStore[$r["STOREID"]],$rrr);
|
||
}else{
|
||
$postStore[$r["STOREID"]] = [$rrr];
|
||
}
|
||
}
|
||
if($r["POSTFLAG"]==0){
|
||
$r->POSTNUM=$POSTNUM[0];
|
||
$r->POSTFLAG = 1;
|
||
$r->SYNFLAG = 1;
|
||
$r->save();
|
||
}
|
||
if(strpos($r["GRABNUM"],"B")!==false){//团购
|
||
if($r["PRINTTIMES"]==0){
|
||
Wsdl::webservice([106300,$r["ID"]],"cancelOrderByIds");
|
||
}
|
||
}
|
||
}else{
|
||
Wsdl::webservice([106300,$r["ID"]],"cancelOrderByIds");
|
||
}
|
||
}
|
||
//通知快递拦截
|
||
foreach ($posttype as $k => $r){
|
||
$relay = $this->RoomsModel->where(["WAREHOUSEID"=>5400,"POSTCODE"=>$k,"type"=>3,"islanshow"=>0])->where("ECNOTES like '%default%'")->select();
|
||
if(!$relay){
|
||
$relay = $this->RoomsModel->where(["WAREHOUSEID"=>5400,"POSTCODE"=>$k,"type"=>3])->where("ECNOTES like '%default%'")->select();
|
||
}
|
||
if(!$relay){
|
||
$relay = $this->RoomsModel->where(["WAREHOUSEID"=>5400,"POSTCODE"=>$k,"type"=>3])->select();
|
||
}
|
||
$wQs = $this->checkQs($r);
|
||
if(count($wQs)==0){
|
||
continue;
|
||
}
|
||
foreach ($relay as $rr){
|
||
$relayMsg = $this->to($rr["room_id"],implode("\n", $wQs)."\n拦截");
|
||
array_push($msgs,$relayMsg);
|
||
}
|
||
}
|
||
//通知货主
|
||
foreach($postStore as $k =>$r){
|
||
$relay = $this->RoomsModel->where(["WAREHOUSEID"=>5400,"STOREID"=>$k,"type"=>1])->find();
|
||
$wQs = $this->checkQs($r);
|
||
if(count($wQs)==0){
|
||
continue;
|
||
}
|
||
$POSTNUMSTEXT = implode("\n",$wQs);
|
||
|
||
$str = "店铺后台申请退款自动检测:\n{$POSTNUMSTEXT}\n已退款成功,已生成工单并通知快递拦截,如需继续发货,发送快递号+取消拦截继续发货";
|
||
if($relay){
|
||
$relayMsg = $this->to($relay["room_id"],$str);
|
||
array_push($msgs,$relayMsg);
|
||
}
|
||
}
|
||
$PrintRemarks = [];
|
||
$PrintRemarksin = [];
|
||
foreach($PlatformOrderId2 as $k => $r){
|
||
$PrintRemark = $this->UpdatePrintRemark($pingtai,[strval($k)],$r[0]."|已取消",[["LogicOrderId"=>$k,"DataFlag"=>0,"PlatformType"=>$r[1],"ShopId"=>$r[2]]]);
|
||
array_push($PrintRemarks,$PrintRemark);
|
||
}
|
||
$redis = new \Redis();
|
||
$redis->connect('127.0.0.1', 6379);
|
||
$redis->auth('qwe2019@');
|
||
$redis->select(2);
|
||
foreach ($msgs as $msg){
|
||
$redis->lpush("Message",json_encode($msg));
|
||
}
|
||
return json([$rows,$orderList,$msgs,$PlatformOrderId2,$PrintRemarks]);
|
||
}
|
||
|
||
public function checkOrder1(){
|
||
$msgs = [];
|
||
$value = $this->redis->rpop("checkHasOrderAndFlag");
|
||
if($value){
|
||
if (strpos($value, '|') !== false) {
|
||
$tmp_order = explode("|",$value);
|
||
$order = $this->OrderModel->where(["SOURCEORDERCODE"=>$tmp_order[0],"FLAG"=>0])->find();
|
||
}else{
|
||
$order = $this->OrderModel->where(["SOURCEORDERCODE"=>$value,"FLAG"=>0])->find();
|
||
}
|
||
if($order){
|
||
if(strpos($order["GRABNUM"],"B")!==false){//团购
|
||
if($order["PLSENDFLAG"]==0){
|
||
//拦截
|
||
$this->updateInterceptorder($order["ID"],0);
|
||
}
|
||
}else{
|
||
if($order["WEIGHT"]==0){
|
||
//拦截
|
||
$this->updateInterceptorder($order["ID"],0);
|
||
}
|
||
}
|
||
if($tmp_order[1]){
|
||
//有快递号,发送给快递拦截
|
||
$relay = $this->RoomsModel->where(["WAREHOUSEID"=>5400,"POSTCODE"=>$order["POSTCODE"],"type"=>3])->where("ECNOTES like '%default%'")->select();
|
||
foreach ($relay as $rr){
|
||
$relayMsg = $this->to($rr["room_id"],$tmp_order[1]."\n拦截");
|
||
array_push($msgs,$relayMsg);
|
||
}
|
||
$relay = $this->RoomsModel->where(["WAREHOUSEID"=>5400,"STOREID"=>$order["STOREID"],"type"=>1])->find();
|
||
$str = "店铺后台申请退款自动检测:\n{$tmp_order[1]}\n已退款成功,已生成工单并通知快递拦截,如需继续发货,发送快递号+取消拦截继续发货";
|
||
if($relay){
|
||
$relayMsg = $this->to($relay["room_id"],$str);
|
||
array_push($msgs,$relayMsg);
|
||
}
|
||
$redis = new \Redis();
|
||
$redis->connect('127.0.0.1', 6379);
|
||
$redis->auth('qwe2019@');
|
||
$redis->select(2);
|
||
foreach ($msgs as $msg){
|
||
$redis->lpush("Message",json_encode($msg));
|
||
}
|
||
return "订单{$value}已拦截处理";
|
||
}
|
||
}else{
|
||
return "已处理";
|
||
}
|
||
}
|
||
}
|
||
public function checkOrder2(){
|
||
$value = $this->redis->rpop("checkHasOrderSync");
|
||
if($value){
|
||
if (strpos($value, '|') !== false) {
|
||
$tmp_order = explode("|",$value);
|
||
$order = $this->OrderModel->where(["SOURCEORDERCODE"=>$tmp_order[0],"FLAG"=>0])->find();
|
||
}else{
|
||
$order = $this->OrderModel->where(["SOURCEORDERCODE"=>$value,"FLAG"=>0])->find();
|
||
}
|
||
if($order){
|
||
$order->SYNFLAG = 1;
|
||
$order->save();
|
||
}
|
||
}
|
||
}
|
||
private function checkQs($arr){
|
||
return $arr;
|
||
}
|
||
//检测未打印已发货
|
||
public function getRefundOrder2($pingtai=""){
|
||
$MultiFilters = [[[
|
||
"TableAlias"=>"o",
|
||
"FieldType"=>"string",
|
||
"TableName"=>"LogicOrder",
|
||
"Name"=>"PrintRemark",
|
||
"Value"=>"已取消",
|
||
"Contract"=>"not like",
|
||
"Operator"=>"AND"
|
||
]]];
|
||
$k = "ErpState";
|
||
$r = "waitsellersend";
|
||
$op = ["ErpState"=>"="];
|
||
$filters = [[
|
||
'TableAlias' => 'o',
|
||
'FieldType' => 'string',
|
||
'TableName' => 'LogicOrder',
|
||
'Name' => "ErpState",
|
||
'Value' => "sended",
|
||
'Contract' => "="
|
||
],[
|
||
'TableAlias' => 'o',
|
||
'FieldType' => 'int',
|
||
'TableName' => 'LogicOrder',
|
||
'Name' => "PrintState",
|
||
'Value' => "0",
|
||
'Contract' => "="
|
||
],[
|
||
'TableAlias' =>'o',
|
||
'FieldType' => 'string',
|
||
'TableName' => 'LogicOrder',
|
||
'Name' => "PrintRemark",
|
||
'Value' => "核实需要发货",
|
||
'Contract' => "like",
|
||
'Operator' => "AND"
|
||
]];
|
||
$result = $this->NewOrderList1($pingtai,$filters,$MultiFilters,100,1);
|
||
$rows = $result["rows"];
|
||
$PlatformOrderId = [];
|
||
$PlatformOrderId2 = [];
|
||
foreach ($rows as $r){
|
||
array_push($PlatformOrderId,$r["PlatformOrderId"]);
|
||
$PlatformOrderId2[$r["LogicOrderId"]] = [$r["Remark"],$r["PlatformType"],$r["ShopId"]];
|
||
}
|
||
if(count($PlatformOrderId)>0){
|
||
$orderList = $this->OrderModel->where("SOURCEID","in",$PlatformOrderId)->where("SOURCECODE='Z15'")->select();
|
||
}else{
|
||
return "";
|
||
}
|
||
$lanjieSuccess = [];
|
||
$posttype = [];
|
||
$postStore = [];
|
||
$msgs = [];
|
||
foreach ($orderList as $r){
|
||
if(strpos($r["GRABNUM"],"B")!==false){//团购
|
||
if($r["PLSENDFLAG"]==0){
|
||
//拦截
|
||
$this->updateInterceptorder($r["ID"],0);
|
||
}
|
||
}else{
|
||
if($r["WEIGHT"]==0){
|
||
//拦截
|
||
$this->updateInterceptorder($r["ID"],0);
|
||
}
|
||
}
|
||
$POSTNUM = $this->getPOSTNUMonList($rows,$r["SOURCEID"]);
|
||
|
||
if(count($POSTNUM)>0){
|
||
//,创建工单
|
||
$lsnjieres = $this->createExceptionWmsOrder(12,$r["ID"],"店管家自动检测非本仓发货","");
|
||
|
||
foreach ($POSTNUM as $rrr){
|
||
if(array_key_exists($r["POSTCODE"], $posttype)){
|
||
array_push($posttype[$r["POSTCODE"]],$rrr);
|
||
}else{
|
||
$posttype[$r["POSTCODE"]] = [$rrr];
|
||
}
|
||
}
|
||
foreach ($POSTNUM as $rrr){
|
||
if(array_key_exists($r["STOREID"], $postStore)){
|
||
array_push($postStore[$r["STOREID"]],$rrr);
|
||
}else{
|
||
$postStore[$r["STOREID"]] = [$rrr];
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
//通知快递拦截
|
||
foreach ($posttype as $k => $r){
|
||
$relay = $this->RoomsModel->where(["WAREHOUSEID"=>5400,"POSTCODE"=>$k,"type"=>3])->where("ECNOTES like '%default%'")->select();
|
||
foreach ($relay as $rr){
|
||
$relayMsg = $this->to($rr["room_id"],implode("\n", $r)."\n拦截");
|
||
array_push($msgs,$relayMsg);
|
||
}
|
||
}
|
||
//通知货主
|
||
foreach($postStore as $k =>$r){
|
||
$relay = $this->RoomsModel->where(["WAREHOUSEID"=>5400,"STOREID"=>$k,"type"=>1])->find();
|
||
$POSTNUMSTEXT = implode("\n",$r);
|
||
$str = "店铺后台申请退款自动检测:\n{$POSTNUMSTEXT}\n已申请退款或已退款,已生成工单并通知快递拦截,如需继续发货,发送快递号+取消拦截继续发货";
|
||
if($relay){
|
||
$relayMsg = $this->to($relay["room_id"],$str);
|
||
array_push($msgs,$relayMsg);
|
||
}
|
||
}
|
||
foreach($PlatformOrderId2 as $k => $r){
|
||
$PrintRemark = $this->UpdatePrintRemark($pingtai,[$k],$r[0]."|已取消",[["LogicOrderId"=>$k,"DataFlag"=>0,"PlatformType"=>$r[1],"ShopId"=>$r[2]]]);
|
||
}
|
||
$redis = new \Redis();
|
||
$redis = new \Redis();
|
||
$redis->connect('127.0.0.1', 6379);
|
||
$redis->auth('qwe2019@');
|
||
$redis->select(2);
|
||
foreach ($msgs as $msg){
|
||
$redis->lpush("Message",json_encode($msg));
|
||
}
|
||
return json([$rows,$orderList,$msgs,$PlatformOrderId2]);
|
||
}
|
||
private function to($to,$text){
|
||
return [
|
||
"method"=>"sendText",
|
||
"wxid"=> $to,
|
||
"msg"=> $text,
|
||
"atid"=> '',
|
||
"pid"=> 0
|
||
];
|
||
}
|
||
private function getPOSTNUMonList($orderList,$SOURCEID){
|
||
$order = [];
|
||
foreach ($orderList as $r){
|
||
if($r["PlatformOrderId"]==$SOURCEID){
|
||
$order = $r;
|
||
}
|
||
}
|
||
$postnums = [];
|
||
if($order){
|
||
foreach ($order["WaybillCodes"] as $r){
|
||
array_push($postnums,$r["WaybillCode"]);
|
||
}
|
||
}
|
||
return $postnums;
|
||
}
|
||
private function updateInterceptorder($orders,$status){
|
||
$data = Wsdl::webservice([106300,$orders,$status],'updateInterceptorder');
|
||
|
||
}
|
||
private function createExceptionWmsOrder($status,$order,$text,$postnum,$qz=false,$isretry=false,$Push=1){
|
||
|
||
|
||
$res = $this->Exceptionwmsorder->where(["WMSORDERID"=>$order,"STATUS"=>$status])->find();
|
||
if($qz){
|
||
$res = false;
|
||
}
|
||
if(!$res){
|
||
$data = [$status,$text,"","",106300,$order];
|
||
$ress = Wsdl::webservice($data,'createExceptionWmsOrder');
|
||
if($ress==0){
|
||
if($Push==1){
|
||
$redis->lpush("createExceptionWmsOrderBack",json_encode([$postnum,$data,$ress]));
|
||
}
|
||
if(!$isretry){
|
||
$this->createExceptionWmsOrder($status,$order,$text,$postnum,$qz,true);
|
||
}
|
||
}
|
||
return $ress;
|
||
}
|
||
return $res;
|
||
}
|
||
private function LoadAfterSaleList($pingtai,$startTime,$endTime,$pageSize=15,$pageIndex=1){
|
||
$url = "https://fx{$pingtai}.dgjapp.com/AfterSale/LoadAfterSaleList";
|
||
$params = [
|
||
"PageIndex"=>$pageIndex,
|
||
"PageSize"=>$pageSize,
|
||
"SelectShopIds"=>"",
|
||
"SupplierIds"=>"",
|
||
"AgentIds"=>"",
|
||
"StartTime"=>$startTime,
|
||
"EndTime"=>$endTime,
|
||
"QueryDateType"=>"ApplyTime",
|
||
"LogicOrderIds"=>"",
|
||
"PlatformOrderIds"=>"",
|
||
"AfterSaleIds"=>"",
|
||
"ReturnTrackingNo"=>"",
|
||
"ResendTrackingNo"=>"",
|
||
"AfterSaleRemark"=>"",
|
||
"AfterSaleType"=>1,
|
||
"AfterSaleStatus"=>5,
|
||
"InterceptStatus"=>"",
|
||
"ApplyAfterSaleStatus"=>"",
|
||
"OrderPrintStatus"=>"",
|
||
"SourceFlag"=>0,
|
||
"SendState"=>0,
|
||
"PlatformType"=>"",
|
||
"PlatAfterSaleRemark"=>"",
|
||
"SellerRemarkFlag"=>"",
|
||
"SellerRemark"=>"",
|
||
"AfterSaleRemarkFlag"=>"",
|
||
"IsCustomerOrder"=>"false",
|
||
"FxPageType"=>1
|
||
];
|
||
$dbname="wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W";
|
||
$res = $this->sendProxyRequest($url,$params,$dbname);
|
||
return $res;
|
||
}
|
||
private function NewOrderList($pingtai,$filters,$MultiFilters,$pageSize=15,$pageIndex=1){
|
||
$today = new \DateTime('today');
|
||
// 设置时间为0点
|
||
$today->setTime(0, 0, 0);
|
||
|
||
// 获取45天前的日期
|
||
$interval = new \DateInterval('P45D'); // P45D表示45天
|
||
$fortyFiveDaysAgo = clone $today;
|
||
$fortyFiveDaysAgo->sub($interval);
|
||
|
||
// 格式化日期为所需的格式
|
||
$formattedDate = $fortyFiveDaysAgo->format('Y-m-d H:i:s');
|
||
$todayLastSecond = clone $today;
|
||
$todayLastSecond->setTime(23, 59, 59);
|
||
|
||
// 格式化今日最后一秒的时间
|
||
$todayLastSecondFormatted = $todayLastSecond->format('Y-m-d H:i:s');
|
||
$url = "https://fx{$pingtai}.dgjapp.com/NewOrder/List";
|
||
foreach ($filters as $r){
|
||
if($r['Name']=="PlatformOrderId"){
|
||
$arr = explode(",",$r['Value']);
|
||
$newarr = [];
|
||
foreach ($arr as $rr){
|
||
if(strpos($rr,"TB")==false && strpos($rr,"jst")==false && strpos($rr,"jjcy")==false){
|
||
array_push($newarr,$rr);
|
||
}
|
||
}
|
||
$r['Value'] = implode(",",$newarr);
|
||
}
|
||
}
|
||
$params = [
|
||
'Filters' => $filters,
|
||
'MultiFilters' => $MultiFilters,
|
||
'IsOrderDesc' => false,
|
||
'OrderByField' => 'lo.ProductCode,lo.SkuCode',
|
||
'IsPdd' => false,
|
||
'PageSize' => $pageSize,
|
||
'PageIndex' => $pageIndex,
|
||
'isFilterDangerChar' => false,
|
||
'TarType' => '',
|
||
'requestUrl' => "https://fx{$pingtai}.dgjapp.com/NewOrder/WaitOrder",
|
||
'IsCustomerOrder' => false,
|
||
'FxPageType' => 2
|
||
];
|
||
$dbname="wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W";
|
||
$res = $this->sendProxyRequest($url,$params,$dbname);
|
||
return $res;
|
||
}
|
||
private function handleOrder($rows=[]){
|
||
$skus = $this->StockModel->where("ITEMS is not null and ITEMS <>''")->select();
|
||
$MyagentBind = $this->MyagentModel->where("STOREID>0")->select();
|
||
foreach ($MyagentBind as $index => $r){
|
||
$MyagentBind[$index]["storename"] = $this->getStoreName($r["STOREID"]);
|
||
}
|
||
$order_items_onlys = $this->redis->get("order_items_onlys");
|
||
if($order_items_onlys){
|
||
$order_items_only_arr = explode("|",$order_items_onlys);
|
||
}
|
||
if (!is_array($rows)){
|
||
return [];
|
||
}
|
||
foreach ($rows as $index => $r){
|
||
$sku_text = [];
|
||
$skuIds = [];
|
||
$hasnobind = false;
|
||
foreach($r["SubOrders"] as $SubOrders){
|
||
array_push($skuIds,$SubOrders["SkuId"]);
|
||
$subsku_arr = $this->get_sku_bind($skus,$SubOrders["SkuId"],$SubOrders["Count"]);
|
||
if(count($subsku_arr)==0){
|
||
$hasnobind = true;
|
||
}
|
||
foreach ($subsku_arr as $k=>$rrr){
|
||
if(array_key_exists($k,$sku_text)){
|
||
$sku_text[$k] += $subsku_arr[$k];
|
||
}else{
|
||
$sku_text[$k] = $subsku_arr[$k];
|
||
}
|
||
}
|
||
}
|
||
$sku_text_s = [];
|
||
foreach ($sku_text as $k => $rrr){
|
||
if(in_array($k,$order_items_only_arr)){
|
||
$sku_text_s_tmp="{$k}|1";
|
||
}else{
|
||
$sku_text_s_tmp="{$k}|${rrr}";
|
||
}
|
||
array_push($sku_text_s,$sku_text_s_tmp);
|
||
}
|
||
$sku_text_s = $hasnobind?[]:$sku_text_s;
|
||
$rows[$index]["ITEMS"] = implode(",",$sku_text_s);
|
||
$rows[$index]["SkuIds"] = implode(",",$skuIds);
|
||
}
|
||
$orders = [];
|
||
foreach ($rows as $index => $r){
|
||
[$storeid,$storename] = $this->get_agent_bind($MyagentBind,$r["ShopName"],$r["ShopId"]);
|
||
if($storeid==0){
|
||
}
|
||
$rows[$index]["storeid"] = $storeid;
|
||
$rows[$index]["storename"] = $storename;
|
||
}
|
||
foreach ($rows as $r){
|
||
array_push($orders,$r);
|
||
}
|
||
return $orders;
|
||
}
|
||
|
||
private function noticSku($skuid){
|
||
$this->redis->lpush("noticSku",$skuid);
|
||
}
|
||
private function get_sku_bind($skus,$skuid,$Count){
|
||
$sku = [];
|
||
$has = false;
|
||
//print_r($order_items_only_arr);
|
||
$hasnobind = false;
|
||
foreach ($skus as $r){
|
||
|
||
if($r["SkuId"]==$skuid){
|
||
$has = true;
|
||
if(!$r["ITEMS"] || $r["ITEMS"]==""){
|
||
$hasnobind = true;
|
||
}
|
||
$ITEMS = explode(",",$r["ITEMS"]);
|
||
$ITEMS = array_filter($ITEMS);
|
||
foreach ($ITEMS as $stock_item){
|
||
$tmp = explode("|",$stock_item);
|
||
$tmp[1] = intval($tmp[1])*$Count;
|
||
$sku[$tmp[0]] = $tmp[1];
|
||
}
|
||
}
|
||
if(!$r["UpFxUserId"]){
|
||
$has = false;
|
||
}
|
||
}
|
||
if(!$has){
|
||
$item = $this->StockModel->where(["SkuId"=>$skuid])->find();
|
||
if($item){
|
||
$item->hasOrder = 1;
|
||
$item->save();
|
||
}else{
|
||
$sku_tmp = $this->redis->get("sku_{$skuid}");
|
||
if(!$sku_tmp){
|
||
$this->redis->set("sku_{$skuid}", 1, ['NX', 'EX' => 3600]);
|
||
$this->updateStockOnce($skuid);
|
||
}
|
||
}
|
||
}
|
||
if($hasnobind){
|
||
return [];
|
||
}
|
||
return $sku;
|
||
}
|
||
public function Prints(){
|
||
$params = $this->request->post();
|
||
$order = $params["orders"];
|
||
$expressName = $params["expressName"];
|
||
$res = $this->Print($order,$expressName);
|
||
return json($res);
|
||
}
|
||
public function OnlineSendBatchs(){
|
||
$params = $this->request->post();
|
||
$order = $params["orders"];
|
||
$expressName = $params["expressName"];
|
||
$res = $this->OnlineSendBatch1($order,$expressName);
|
||
return json($res);
|
||
}
|
||
private function OnlineSendBatch1($order,$expressName){
|
||
$orders_arr = explode("|",$order);
|
||
$orders_arr = array_filter($orders_arr);
|
||
$pingtaiOrder = [];
|
||
$hasError = null;
|
||
$tmp_list = [];
|
||
|
||
foreach($orders_arr as $r){
|
||
$order_item = explode(",",$r);
|
||
if(!isset($order_item[1])){
|
||
$hasError = "{$r},orders入参错误,格式为外部订单编号,平台编号|外部订单编号,平台编号,传入的值为{$order}";
|
||
break;
|
||
}
|
||
$pingtai = isset($this->pingtais[$order_item[1]])?$this->pingtais[$order_item[1]]:null;
|
||
if(isset($order_item[2])&&$order_item[2]=="1"){
|
||
$pingtai = "ali";
|
||
}
|
||
if(!$pingtai){
|
||
$pingtais = json_encode($this->pingtais);
|
||
$hasError = "{$order_item[1]}在程序中pingtais无对应键值{$pingtais}111";
|
||
break;
|
||
}
|
||
array_push($tmp_list,[$pingtai,$order_item[0]]);
|
||
if(!array_key_exists($pingtai, $pingtaiOrder)){
|
||
$pingtaiOrder[$pingtai] = [$order_item[0]];
|
||
}else{
|
||
array_push($pingtaiOrder[$pingtai],$order_item[0]);
|
||
}
|
||
}
|
||
if($hasError){
|
||
return json(["code"=>0,"msg"=>$hasError]);
|
||
}
|
||
$pingtaiOrder3 = [];
|
||
foreach ($pingtaiOrder as $key =>$r){
|
||
$pingtaiOrder2 = [];
|
||
$k = "PlatformOrderId";
|
||
$v = implode(",",$r);
|
||
$op = ["PlatformOrderId"=>"in"];
|
||
$filters = [
|
||
[
|
||
'TableAlias' => isset($this->TableAlias[$k])?$this->TableAlias[$k]:'o',
|
||
'FieldType' => $this->FieldType[$k],
|
||
'TableName' => isset($this->TableName[$k])?$this->TableName[$k]:'LogicOrder',
|
||
'Name' => $k,
|
||
'Value' => $v,
|
||
'Contract' => isset($this->Contract[$k])?$this->Contract[$k]:$op[$k],
|
||
'CustomQuery'=>'PlatformOrderIdSearch'
|
||
],
|
||
[
|
||
'TableAlias' => 'o',
|
||
'FieldType' => "string",
|
||
'TableName' => 'LogicOrder',
|
||
'Name' => "ErpState",
|
||
'Value' => "waitsellersend",
|
||
'Contract' => "="
|
||
]
|
||
];
|
||
|
||
$MultiFilters = [];
|
||
$pageSize =500;
|
||
$pageIndex = 1;
|
||
$orders_list = $this->NewOrderList1($key,$filters,$MultiFilters,$pageSize,$pageIndex);
|
||
//print_r($orders_list);
|
||
$orders_list = $orders_list["rows"];
|
||
|
||
foreach ($orders_list as $rr){
|
||
$rr["NoPrintFlag"] = "false";
|
||
$rr["PrintState"] = 1;
|
||
array_push($pingtaiOrder2,$rr);
|
||
}
|
||
$res = $this->OnlineSendBatch($key,$pingtaiOrder2,$key=="pdd");
|
||
array_push($pingtaiOrder3,[$res,$pingtaiOrder2]);
|
||
}
|
||
return $pingtaiOrder3;
|
||
}
|
||
private function Print($order,$expressName){
|
||
$orders_arr = explode("|",$order);
|
||
$orders_arr = array_filter($orders_arr);
|
||
$pingtaiOrder = [];
|
||
$hasError = null;
|
||
$tmp_list = [];
|
||
foreach($orders_arr as $r){
|
||
$order_item = explode(",",$r);
|
||
if(!isset($order_item[1])){
|
||
$hasError = "{$r},orders入参错误,格式为外部订单编号,平台编号|外部订单编号,平台编号,传入的值为{$order}";
|
||
break;
|
||
}
|
||
$pingtai = isset($this->pingtais[$order_item[1]])?$this->pingtais[$order_item[1]]:null;
|
||
if(isset($order_item[2])&&$order_item[2]=="1"){
|
||
$pingtai = "ali";
|
||
}
|
||
if(!$pingtai){
|
||
$pingtais = json_encode($this->pingtais);
|
||
$hasError = "{$order_item[1]}在程序中pingtais无对应键值{$pingtais}222";
|
||
break;
|
||
}
|
||
|
||
array_push($tmp_list,[$pingtai,$order_item[0]]);
|
||
if(!array_key_exists($pingtai, $pingtaiOrder)){
|
||
$pingtaiOrder[$pingtai] = [$order_item[0]];
|
||
}else{
|
||
array_push($pingtaiOrder[$pingtai],$order_item[0]);
|
||
}
|
||
}
|
||
if($hasError){
|
||
return json(["code"=>0,"msg"=>$hasError]);
|
||
}
|
||
$pingtaiOrder2 = [];
|
||
foreach ($pingtaiOrder as $key =>$r){
|
||
$k = "PlatformOrderId";
|
||
$v = implode(",",$r);
|
||
$op = ["PlatformOrderId"=>"in"];
|
||
$filters = [
|
||
[
|
||
'TableAlias' => isset($this->TableAlias[$k])?$this->TableAlias[$k]:'o',
|
||
'FieldType' => $this->FieldType[$k],
|
||
'TableName' => isset($this->TableName[$k])?$this->TableName[$k]:'LogicOrder',
|
||
'Name' => $k,
|
||
'Value' => $v,
|
||
'Contract' => isset($this->Contract[$k])?$this->Contract[$k]:$op[$k],
|
||
'CustomQuery'=>'PlatformOrderIdSearch'
|
||
]
|
||
];
|
||
$MultiFilters = [];
|
||
$pageSize =500;
|
||
$pageIndex = 1;
|
||
$orders_list = $this->NewOrderList1($key,$filters,$MultiFilters,$pageSize,$pageIndex);
|
||
$orders_list = $orders_list["rows"];
|
||
$TemplateList = $this->LoadTemplateListInOrderList($key);
|
||
$TemplateLists = [];
|
||
foreach ($TemplateList["Data"] as $rr){
|
||
if(strpos($rr["TemplateName"],$expressName)!==false){
|
||
array_push($TemplateLists,$rr);
|
||
}
|
||
}
|
||
if(count($TemplateLists)==0){
|
||
$hasError = "快递{$expressName}在店管家中无对应的模板,如果有,可以更改店管家中自定义模板名称包含\"{$expressName}\",再重试";
|
||
break;
|
||
}
|
||
$orderPls = [];
|
||
foreach ($orders_list as $rr){
|
||
if($rr["PlatformType"]=="Alibaba"){
|
||
if($rr["OrderTags"][0]['TagValue']=="douyin"){
|
||
$rr["PlatformType"]="TouTiao";
|
||
}elseif($rr["OrderTags"][0]['TagValue']=="pinduoduo"){
|
||
$rr["PlatformType"]="Pinduoduo";
|
||
}elseif($rr["OrderTags"][0]['TagValue']=="jingdong"){
|
||
$rr["PlatformType"]="Jingdong";
|
||
}else{
|
||
$rr["PlatformType"]="Taobao";
|
||
}
|
||
}elseif($rr["PlatformType"]=="AlibabaC2M"){
|
||
$rr["PlatformType"]="Taobao";
|
||
}
|
||
if(!array_key_exists($rr["PlatformType"],$orderPls)){
|
||
$orderPls[$rr["PlatformType"]] = ["Template"=>null,"orders"=>[$rr]];
|
||
}else{
|
||
array_push($orderPls[$rr["PlatformType"]]["orders"],$rr);
|
||
}
|
||
}
|
||
//print_r($orderPls);die();
|
||
foreach ($orderPls as $PlatformType =>$rr){
|
||
$Template = null;
|
||
foreach ($TemplateLists as $TemplateList){
|
||
if($TemplateList["TemplateTypeShort"]==$PlatformType){
|
||
$Template = $TemplateList;
|
||
$orderPls[$PlatformType]["Template"] = $TemplateList;
|
||
}
|
||
}
|
||
if(!$Template){
|
||
$hasError = "{$PlatformType}在店管家中无对应的模板,请添加模板后再重试";
|
||
break;
|
||
}
|
||
}
|
||
if($hasError){
|
||
break;
|
||
}
|
||
foreach ($orderPls as $PlatformType =>$rr){
|
||
$Template = null;
|
||
foreach ($TemplateLists as $TemplateList){
|
||
if($TemplateList["TemplateTypeShort"]==$PlatformType){
|
||
$Template = $TemplateList;
|
||
$orderPls[$PlatformType]["Template"] = $TemplateList;
|
||
}
|
||
}
|
||
if(!$Template){
|
||
$hasError = "{$PlatformType}在店管家中无对应的模板,请添加模板后再重试";
|
||
break;
|
||
}
|
||
}
|
||
$pingtaiOrder2[$key] = $orderPls;
|
||
}
|
||
if($hasError){
|
||
return json(["code"=>0,"msg"=>$hasError]);
|
||
}
|
||
$list = [];
|
||
foreach ($pingtaiOrder2 as $key=>$r){
|
||
foreach ($r as $key2 => $rr){
|
||
$orders = array_chunk($rr["orders"],10);
|
||
foreach ($orders as $orderList){
|
||
//$res = $orderList;
|
||
if($key2=="Pinduoduo"){
|
||
$res = $this->ExpressPrint($key,$orderList,$rr["Template"],true);
|
||
}else{
|
||
$res = $this->ExpressPrint($key,$orderList,$rr["Template"]);
|
||
}
|
||
$getHisSourceIds = [];
|
||
foreach ($res["Data"]["WaybillCode"] as $WaybillCode){
|
||
if($WaybillCode["IsError"]){
|
||
array_push($getHisSourceIds,$WaybillCode["OrderInfo"]["OrderInfo"]["OriginID"]);
|
||
}
|
||
}
|
||
if(count($getHisSourceIds)>0){
|
||
|
||
}
|
||
array_push($list,["Platform"=>$key2,"print_datas"=>$res]);
|
||
}
|
||
}
|
||
}
|
||
return $list;
|
||
}
|
||
private function getPddPageCode(){
|
||
$pddPageCount = $this->redis->get("PddPageCode");
|
||
if($pddPageCount){
|
||
return $pddPageCount;
|
||
}
|
||
$url = "https://fxpdd.dgjapp.com/Common/PddPageCode";
|
||
$params = [
|
||
"IsCustomerOrder"=>"false",
|
||
"FxPageType"=>2,
|
||
];
|
||
$dbname="wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W";
|
||
$res = $this->sendProxyRequest($url,$params,$dbname);
|
||
$this->redis->setex("PddPageCode",300,$res["Data"]["PddPageCode"]);
|
||
return $res["Data"]["PddPageCode"];
|
||
}
|
||
function unicode_to_chinese($str) {
|
||
$str = preg_replace('/\\\u([0-9a-fA-F]{4})/', '&#x\\1;', $str);
|
||
return mb_convert_encoding($str, 'UTF-8', 'HTML-ENTITIES');
|
||
}
|
||
private function OnlineSendBatch($pingtai,$orders,$ispdd=false){
|
||
$pddPageCode = "";
|
||
if($ispdd){
|
||
$pddPageCode = $this->getPddPageCode();
|
||
}
|
||
$url = "https://fx{$pingtai}.dgjapp.com/NewOrder/OnlineSendBatch";
|
||
$orders_list2 = [];
|
||
if(count($orders)==0){
|
||
return "";
|
||
}
|
||
foreach ($orders as $index => $r){
|
||
$item = [];
|
||
$OrderItems = [];
|
||
if($r['ReceiverIsChange']){
|
||
continue;
|
||
}
|
||
foreach ($r["SubOrders"] as $rr){
|
||
$tmp = [
|
||
"OrderItemId"=>$rr["OrderItemId"],
|
||
"OrderItemCode"=>$rr["OrderItemCode"],
|
||
"Quantity"=>"1",
|
||
"ShortTitle"=>$rr["ShortTitle"],
|
||
|
||
];
|
||
array_push($item,$tmp);
|
||
array_push($OrderItems,$rr["OrderItemId"]);
|
||
}
|
||
$tmp = [
|
||
"Id"=>$r["Id"],
|
||
"Index"=>$index+1,
|
||
"WaybillCodeId"=>"",
|
||
"LogicOrderId"=>$r["LogicOrderId"],
|
||
"OrderCode"=>$r["OrderCode"],
|
||
"PlatformOrderId"=>$r["LogicOrderId"],
|
||
"PathFlowCode"=>$r["PathFlowCode"],
|
||
"CustomerOrderId"=>$r["PlatformOrderId"],
|
||
"PlatformType"=>$r["PlatformType"],
|
||
"PlatformStatus"=>"waitsellersend",
|
||
"RefunStatus"=>"",
|
||
"FxUserId"=>$r["FxUserId"],
|
||
"BuyerRemark"=>$r["BuyerRemark"],
|
||
"SellerRemark"=>$r["SellerRemark"],
|
||
"UpFxUserId"=>$r["FxUserId"],
|
||
"IsPddCrossBorderOrder"=>$r["IsPddCrossBorderOrder"],
|
||
"IsPddCourierDoorToDoorCollect"=>$r["IsPddCourierDoorToDoorCollect"],
|
||
"ReceiverIsChange"=>$r["ReceiverIsChange"],
|
||
"PrintState"=>$r["PrintState"],
|
||
"SubOrders"=>$r["SubOrders"],
|
||
"IsOfflineOrder"=>$r["IsOfflineOrder"],
|
||
"PublishTime"=>$r["PublishTime"],
|
||
"IsSelectAllNotPrintedItem"=>1,
|
||
"WaybillCode"=>$r["LastWaybillCode"],
|
||
"ExpressCompanyCode"=>isset($r["WaybillCodes"][0])?$r["WaybillCodes"][0]["ExpressCpCode"]:"",
|
||
"weight"=>0,
|
||
"WaybillCodeUniqueKey"=>isset($r["WaybillCodes"][0])?$r["WaybillCodes"][0]["UniqueKey"]:"",
|
||
"OrderItems"=>$OrderItems,
|
||
"NoPrintFlag"=>"false",
|
||
"Items"=>$item,
|
||
"SendType"=>"0",
|
||
"DataFlag"=>$r["DataFlag"],
|
||
"Receiver"=>[
|
||
"toFullName"=>$r["ToName"],
|
||
"toMobile"=>$r["ToPhone"],
|
||
"toArea"=>$r["ToFullAddress"],
|
||
"toProvince"=>$r["ToProvince"],
|
||
"toCity"=>$r["ToCity"],
|
||
"toCounty"=>$r["ToCounty"],
|
||
"toMaskAddress"=>$r["ToAddress"],
|
||
],
|
||
"Sender"=>["CompanyName"=>""],
|
||
"Buyer"=>["BuyerWangWang"=>""]
|
||
];
|
||
array_push($orders_list2,$tmp);
|
||
}
|
||
$params = [
|
||
"Orders"=>$orders_list2,
|
||
"IsCustomerOrder"=>"false",
|
||
"FxPageType"=>"2",
|
||
"IsSendPreCheck"=>"true",
|
||
"IsContinueForStock"=>"false",
|
||
"NoLogisticsInfoModel"=>""
|
||
];
|
||
$res = "未找到订单";
|
||
if(count($orders_list2)>0){
|
||
$dbname="wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W";
|
||
$res = $this->sendProxyRequest($url,$params,$dbname,$pddPageCode);
|
||
}
|
||
return $res;
|
||
}
|
||
private function checkNoSend(){
|
||
$pingtaiOrder3 = [];
|
||
foreach ($this->pingtais as $key){
|
||
$filters = [
|
||
[
|
||
'TableAlias' => 'o',
|
||
'FieldType' => "string",
|
||
'TableName' => 'LogicOrder',
|
||
'Name' => "ErpState",
|
||
'Value' => "waitsellersend",
|
||
'Contract' => "="
|
||
],
|
||
[
|
||
'TableAlias' => 'o',
|
||
'FieldType' => "int",
|
||
'TableName' => 'LogicOrder',
|
||
'Name' => "PrintState",
|
||
'Value' => "1",
|
||
'Contract' => "="
|
||
]
|
||
];
|
||
$MultiFilters = [];
|
||
$pageSize =500;
|
||
$pageIndex = 1;
|
||
$orders_list = $this->NewOrderList1($key,$filters,$MultiFilters,$pageSize,$pageIndex);
|
||
//print_r($orders_list);
|
||
$orders_list = $orders_list["rows"];
|
||
|
||
foreach ($orders_list as $rr){
|
||
$rr["NoPrintFlag"] = "false";
|
||
$rr["PrintState"] = 1;
|
||
array_push($pingtaiOrder2,$rr);
|
||
}
|
||
$res = $this->OnlineSendBatch($key,$pingtaiOrder2,$key=="pdd");
|
||
array_push($pingtaiOrder3,[$res,$pingtaiOrder2]);
|
||
}
|
||
return $pingtaiOrder3;
|
||
}
|
||
private function ExpressPrint($pingtai,$orders,$Template,$ispdd = false,$new = false){
|
||
$pddPageCode = "";
|
||
if($ispdd){
|
||
$pddPageCode = $this->getPddPageCode();
|
||
}
|
||
$res = $this->CheckTemplateAvaliable($pingtai,$Template,$orders,$new);
|
||
//return $res;
|
||
$orders_list2 = [];
|
||
foreach ($orders as $index => $r){
|
||
$item = [];
|
||
$OrderItems = [];
|
||
foreach ($r["SubOrders"] as $rr){
|
||
$tmp = [
|
||
"OrderItemId"=>$rr["OrderItemId"],
|
||
"OrderItemCode"=>$rr["OrderItemCode"],
|
||
"Quantity"=>"1",
|
||
"ShortTitle"=>$rr["ShortTitle"],
|
||
"SkuCode"=>$rr["SkuCode"],
|
||
"ProductCode"=>$rr["ProductCode"]
|
||
];
|
||
array_push($item,$tmp);
|
||
array_push($OrderItems,$rr["OrderItemId"]);
|
||
}
|
||
$tmp = [
|
||
"WaybillCodeId"=>"",
|
||
"Index"=>$index+1,
|
||
"Id"=>$r["Id"],
|
||
"PlatformOrderId"=>$r["LogicOrderId"],
|
||
"LogicOrderId"=>$r["LogicOrderId"],
|
||
"PathFlowCode"=>$r["PathFlowCode"],
|
||
"CustomerOrderId"=>$r["PlatformOrderId"],
|
||
"ShopId"=>$r["ShopId"],
|
||
"PrintInfo"=>"",
|
||
"OrderItems"=>$OrderItems,
|
||
"Items"=>$item,
|
||
"WaybillCode"=>$new?"":$r["LastWaybillCode"],
|
||
"SellerRemark"=>$r["SellerRemark"],
|
||
"BuyerRemark"=>$r["BuyerRemark"],
|
||
"FxUserId"=>$r["FxUserId"],
|
||
"IsSelectAllNotPrintedItem"=>"1",
|
||
"SendType"=>"0",
|
||
"DataFlag"=>$r["IsCold"],
|
||
"Receiver"=>[
|
||
"toFullName"=>$r["ToName"],
|
||
"toMobile"=>$r["ToPhone"],
|
||
"toArea"=>$r["ToFullAddress"],
|
||
"toProvince"=>$r["ToProvince"],
|
||
"toCity"=>$r["ToCity"],
|
||
"toCounty"=>$r["ToCounty"],
|
||
"toMaskAddress"=>$r["ToTown"].$r["ToAddress"],
|
||
],
|
||
"Sender"=>["CompanyName"=>""],
|
||
"Buyer"=>["BuyerWangWang"=>$r["ToName"]]
|
||
];
|
||
array_push($orders_list2,$tmp);
|
||
}
|
||
$url = "https://fx{$pingtai}.dgjapp.com/NewOrder/ExpressPrint";
|
||
$Branches = "";
|
||
if(isset($res["Data"]["Balance"]) && $res["Data"]["Balance"]<$res["Data"]["PrintCount"]){
|
||
$msg = $Template["Data"]["TemplateName"]."余额不足";
|
||
$this->Webhook_lib->sendText($msg);
|
||
return $msg;
|
||
}
|
||
if(isset($res["Data"]["Branches"])){
|
||
$Branches = $res["Data"]["Branches"];
|
||
foreach ($Branches as &$r){
|
||
array_walk($r, function(&$value) {
|
||
if ($value === null) {
|
||
$value = "";
|
||
}
|
||
if ($value === false) {
|
||
$value = "false";
|
||
}
|
||
if ($value === true) {
|
||
$value = "true";
|
||
}
|
||
});
|
||
}
|
||
|
||
}
|
||
$params = [
|
||
"TemplateId"=>$Template["Id"],
|
||
"PackageCount"=>"1",
|
||
"PackageDesc"=>"",
|
||
"GoodsDesc"=>"",
|
||
"PrintMethod"=>"Normal",
|
||
"IsIgnoreWaybillRepeat"=>"true",
|
||
"PrinterName"=>"默认打印机",
|
||
"IsPreview"=>"false",
|
||
"IsContinueForStock"=>"false",
|
||
"PackageLength"=>"",
|
||
"PackageWidth"=>"",
|
||
"PackageHeight"=>"",
|
||
"ExpressSustenance"=>[
|
||
"name"=>"",
|
||
"desc"=>""
|
||
],
|
||
"Branches"=>$Branches,
|
||
"Orders"=>$orders_list2,
|
||
"RequestBatchNumber"=>"1/1/".$res["Data"]["DateNow"].$res["Data"]["DayPrintBatchNumber"],
|
||
"IsCustomerOrder"=>"false",
|
||
"FxPageType"=>"2"
|
||
];
|
||
//return $params;
|
||
$dbname="wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W";
|
||
$res = $this->sendProxyRequest($url,$params,$dbname,$pddPageCode);
|
||
return $res;
|
||
}
|
||
private function CheckTemplateAvaliable($pingtai,$Template,$orders,$isnew){
|
||
$orders_list2 = [];
|
||
//return $orders;
|
||
foreach ($orders as $r){
|
||
$item = [];
|
||
foreach ($r["SubOrders"] as $rr){
|
||
$tmp = [
|
||
"OrderItemCode"=>$rr["OrderItemCode"],
|
||
"LogicOrderItemId"=>$rr["OrderItemId"],
|
||
"Quantity"=>"1"
|
||
];
|
||
array_push($item,$tmp);
|
||
}
|
||
$tmp = [
|
||
"SourceShopId"=>$r["ShopId"],
|
||
"UpFxUserId"=>$r["FxUserId"],
|
||
"SourceFxUserId"=>$r["FxUserId"],
|
||
"LogicOrderId"=>$r["LogicOrderId"],
|
||
"PlatformOrderId"=>$r["LogicOrderId"],
|
||
"IsAllowNegativeStock"=>"false",
|
||
"SendType"=>$r["SendState"],
|
||
"DataFlag"=>$r["IsCold"],
|
||
"Items"=>$item
|
||
];
|
||
array_push($orders_list2,$tmp);
|
||
}
|
||
$url = "https://fx{$pingtai}.dgjapp.com/TemplateSet/CheckTemplateAvaliable";
|
||
$params = [
|
||
"templateId"=>$Template["Id"],
|
||
"printCount"=>count($orders_list2),
|
||
"needCheck"=>"true",
|
||
"orders"=>$orders_list2,
|
||
"isResend"=>"",
|
||
"pirntMethod"=>"Normal",
|
||
"IsContinueForStock"=>"false",
|
||
"IsCustomerOrder"=>"false",
|
||
"FxPageType"=>"2"
|
||
];
|
||
//return $params;
|
||
$dbname="wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W";
|
||
$res = $this->sendProxyRequest($url,$params,$dbname);
|
||
return $res;
|
||
}
|
||
private function LoadTemplateListInOrderList($pingtai){
|
||
$url = "https://fx{$pingtai}.dgjapp.com/TemplateSet/LoadTemplateListInOrderList";
|
||
$platform = $pingtai=="pdd"?"Pinduoduo":null;
|
||
$params = [
|
||
"IsCustomerOrder"=>"false",
|
||
"FxPageType"=>"2",
|
||
"isDefault"=>"true",
|
||
];
|
||
if($platform){
|
||
$params["platformType"] = $platform;
|
||
}
|
||
$dbname="wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W";
|
||
$res = $this->sendProxyRequest($url,$params,$dbname);
|
||
return $res;
|
||
}
|
||
private function LoadWaybillAccountDetailInfo($pingtai,$info){
|
||
$url = "https://fx{$pingtai}.dgjapp.com/TemplateSet/LoadWaybillAccountDetailInfo";
|
||
$params = [
|
||
"templateId"=>$info["Id"],
|
||
"authAccountId"=>$info["CaiNiaoAuthInfoId"],
|
||
"authSourceType"=>$info["AuthSourceType"],
|
||
"shareRelationIds"=>$info["BranchShareRelationId"],
|
||
"expressCode"=>$info["ExpressCompanyCode"],
|
||
"IsCustomerOrder"=>"false",
|
||
"FxPageType"=>"2"
|
||
];
|
||
$dbname="wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W";
|
||
$res = $this->sendProxyRequest($url,$params,$dbname);
|
||
return $res;
|
||
}
|
||
private function get_agent_bind($agents,$agentName,$shopid){
|
||
$storeid = 0;
|
||
$storename = "";
|
||
foreach ($agents as $r){
|
||
if($r["Mobile"]==$shopid){
|
||
$storename=$r["storename"];
|
||
$storeid = $r["STOREID"];
|
||
}elseif($r["UserName"]==$agentName){
|
||
$storename=$r["storename"];
|
||
$storeid = $r["STOREID"];
|
||
}
|
||
}
|
||
if($storeid==0){
|
||
|
||
}
|
||
return [$storeid,$storename];
|
||
}
|
||
public function getMyagentBind(){
|
||
$list = $this->MyagentModel->where("STOREID>0")->select();
|
||
$type = ["客户","店铺"];
|
||
$msg = [];
|
||
foreach ($list as $r){
|
||
$STORENAME = $this->getStoreName($r['STOREID']);
|
||
if($STORENAME){
|
||
array_push($msg,"账号类型:{$type[$r['isShop']]}:{$r['Mobile']}({$r['UserName']})=>{$STORENAME}");
|
||
}
|
||
}
|
||
$msgs = implode("\n",$msg);
|
||
$msg = $this->toMsg($this->room_id,$msgs);
|
||
$this->redis->select(2);
|
||
$this->redis->lpush("Message",json_encode($msg));
|
||
$this->redis->close();
|
||
}
|
||
|
||
|
||
private function getStoreName($STOREID){
|
||
if(!$this->STORES){
|
||
$this->STORES = $this->StoreModel->select();
|
||
}
|
||
$TITLE = null;
|
||
foreach ($this->STORES as $r){
|
||
if($STOREID==$r["STOREID"]){
|
||
$TITLE = $r["TITLE"];
|
||
}
|
||
}
|
||
return $TITLE;
|
||
}
|
||
public function getStoreList(){
|
||
$WAREHOUSEID = 5400;
|
||
$StoreModel = new \app\common\model\wms\Warestore;
|
||
$userStoreModel = new \app\common\model\UserStore;
|
||
$list1 = $StoreModel->with(['employees'])->where(["WAREHOUSEID"=>$WAREHOUSEID])->select();
|
||
$STOREIDS = [];
|
||
foreach ($list1 as $r){
|
||
array_push($STOREIDS,$r["STOREID"]);
|
||
}
|
||
$STORES = [];
|
||
$list = $this->MyagentModel->where("STOREID","in",$STOREIDS)->where("UpFxUserId is not null")->select();
|
||
foreach ($list as $r){
|
||
if(array_key_exists($r["STOREID"],$STORES)){
|
||
array_push($STORES[$r["STOREID"]],$r["UpFxUserId"]);
|
||
}else{
|
||
$STORES[$r["STOREID"]] = [$r["UpFxUserId"]];
|
||
}
|
||
}
|
||
$result = [];
|
||
foreach ($STORES as $k => $r){
|
||
$result[$k] = $this->getStoreName($k);
|
||
}
|
||
return json($result);
|
||
}
|
||
public function test(){
|
||
$url = "https://fxpdd.dgjapp.com/Common/PddPageCode";
|
||
$dbname = "wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W";
|
||
$params = [
|
||
"IsCustomerOrder"=>"false",
|
||
"FxPageType"=>"2"
|
||
];
|
||
$res = $this->sendProxyRequest($url,$params,$dbname);
|
||
return json($res);
|
||
}
|
||
public function getPrinteData(){
|
||
$orderids = "4256200980601390145";
|
||
$res = $this->getCainiaoPrintData($orderids);
|
||
return json($res);
|
||
}
|
||
public function LoadMyAgentList1(){//获取商家列表
|
||
$res = $this->LoadMyAgentList();
|
||
$totle = $res["Data"]["Total"];
|
||
$pageCount = ceil($totle/500);
|
||
$list = $res["Data"]["List"];
|
||
for($i=2;$i<=$pageCount;$i++){
|
||
$res = $this->LoadMyAgentList($i);
|
||
$list = array_merge($list, $res["Data"]["List"]);
|
||
}
|
||
$mobiles = [];
|
||
foreach($list as $r){
|
||
array_push($mobiles,$r["Mobile"]);
|
||
}
|
||
$dblist = $this->MyagentModel->where("Mobile","in",$mobiles)->where(["isShop"=>0])->select();
|
||
$dbmobiles = [];
|
||
foreach ($dblist as $r){
|
||
array_push($dbmobiles,$r->Mobile);
|
||
}
|
||
$addList = [];
|
||
$updateList = [];
|
||
foreach($list as $r){
|
||
if(!in_array($r["Mobile"],$dbmobiles)){
|
||
array_push($addList,$r);
|
||
}else{
|
||
array_push($updateList,$r);
|
||
}
|
||
}
|
||
foreach ($updateList as $r){
|
||
$line = $this->MyagentModel->where(["Mobile"=>$r["Mobile"]])->find();
|
||
$line->UserName = $r["UserName"];
|
||
$line->UpFxUserId = $r["UserFx"]["Id"];
|
||
$line->DbAreas = json_encode($r["DbAreas"]);
|
||
$line->save();
|
||
}
|
||
$insetData = [];
|
||
foreach ($addList as $r){
|
||
$insetData_item = [
|
||
"NickName"=>$r["NickName"],
|
||
"Mobile"=>$r["Mobile"],
|
||
"UserName"=>$r["UserName"],
|
||
"DbAreas"=>json_encode($r["DbAreas"]),
|
||
"STOREID"=>0,
|
||
"isShop"=>0,
|
||
"UpFxUserId"=>isset($r["UpFxUserId"])?$r["UpFxUserId"]:0
|
||
];
|
||
array_push($insetData,$insetData_item);
|
||
}
|
||
$Model = new \app\common\model\dgj\Myagent;
|
||
$res = $Model->saveAll($insetData);
|
||
$lists = $this->MyagentModel->where(["STOREID"=>0])->where(["isShop"=>0])->select();
|
||
print_r($lists);
|
||
if(count($lists)>0){
|
||
$text = "未绑定货主商家:\n";
|
||
foreach ($lists as $r){
|
||
$text.=$r["Mobile"]."\n";
|
||
}
|
||
$text.="发送商家绑定+商家账号+英文逗号分隔符+货主id,一行一个绑定,例子:\n商家绑定\n18000000000,18000";
|
||
$msg = $this->toMsg($this->room_id,$text);
|
||
$this->redis->select(2);
|
||
$this->redis->lpush("Message",json_encode($msg));
|
||
$this->redis->select(1);
|
||
}
|
||
|
||
$res = $this->LoadMShopList();
|
||
$totle = $res["Data"]["Total"];
|
||
$pageCount = ceil($totle/500);
|
||
$list = $res["Data"]["List"];
|
||
for($i=2;$i<=$pageCount;$i++){
|
||
$res = $this->LoadMShopList($i);
|
||
$list = array_merge($list, $res["Data"]["List"]);
|
||
}
|
||
$mobiles = [];
|
||
foreach($list as $r){
|
||
array_push($mobiles,$r["ShopId"]);
|
||
}
|
||
/*$dblist = $this->MyagentModel->where("Mobile","not in",$mobiles)->where(["isShop"=>1])->select();
|
||
foreach ($dblist as $r){
|
||
$r->delete();
|
||
}*/
|
||
$dblist = $this->MyagentModel->where("Mobile","in",$mobiles)->where(["isShop"=>1])->select();
|
||
$dbmobiles = [];
|
||
foreach ($dblist as $r){
|
||
array_push($dbmobiles,$r->Mobile);
|
||
}
|
||
$addList = [];
|
||
$updateList = [];
|
||
foreach($list as $r){
|
||
if(!in_array($r["ShopId"],$dbmobiles)){
|
||
array_push($addList,$r);
|
||
}else{
|
||
array_push($updateList,$r);
|
||
}
|
||
}
|
||
foreach ($updateList as $r){
|
||
$line = $this->MyagentModel->where(["Mobile"=>$r["ShopId"]])->find();
|
||
$line->UserName = $r["NickName"];
|
||
$line->PlatformType = $r["PlatformType"];
|
||
$line->save();
|
||
}
|
||
$insetData = [];
|
||
foreach ($addList as $r){
|
||
$insetData_item = [
|
||
"NickName"=>$r["NickName"],
|
||
"Mobile"=>$r["ShopId"],
|
||
"UserName"=>$r["NickName"],
|
||
"DbAreas"=>"",
|
||
"STOREID"=>0,
|
||
"isShop"=>1,
|
||
"PlatformType"=>$r["PlatformType"]
|
||
];
|
||
array_push($insetData,$insetData_item);
|
||
}
|
||
$Model = new \app\common\model\dgj\Myagent;
|
||
$res = $Model->saveAll($insetData);
|
||
$lists = $this->MyagentModel->where(["STOREID"=>0])->where(["isShop"=>1])->select();
|
||
if(count($lists)>0){
|
||
$text = "未绑定货主店铺:\n";
|
||
foreach ($lists as $r){
|
||
$text.=$r["Mobile"]."({$r['NickName']})\n";
|
||
}
|
||
$text.="发送商家绑定+店铺ID+英文逗号分隔符+货主id,一行一个绑定,例子:\n商家绑定\n7653846,18000";
|
||
$msg = $this->toMsg($this->room_id,$text);
|
||
$this->redis->select(2);
|
||
$this->redis->lpush("Message",json_encode($msg));
|
||
$this->redis->close();
|
||
}
|
||
$res = $this->LoadCrossBorderShopList();
|
||
$totle = $res["Data"]["Total"];
|
||
$pageCount = ceil($totle/500);
|
||
$list = $res["Data"]["List"];
|
||
for($i=2;$i<=$pageCount;$i++){
|
||
$res = $this->LoadCrossBorderShopList($i);
|
||
$list = array_merge($list, $res["Data"]["List"]);
|
||
}
|
||
$mobiles = [];
|
||
foreach($list as $r){
|
||
array_push($mobiles,$r["ShopId"]);
|
||
}
|
||
$dblist = $this->MyagentModel->where("Mobile","not in",$mobiles)->where(["isShop"=>1])->select();
|
||
/*foreach ($dblist as $r){
|
||
$r->delete();
|
||
}*/
|
||
$dblist = $this->MyagentModel->where("Mobile","in",$mobiles)->where(["isShop"=>1])->select();
|
||
$dbmobiles = [];
|
||
foreach ($dblist as $r){
|
||
array_push($dbmobiles,$r->Mobile);
|
||
}
|
||
$addList = [];
|
||
$updateList = [];
|
||
foreach($list as $r){
|
||
if(!in_array($r["ShopId"],$dbmobiles)){
|
||
array_push($addList,$r);
|
||
}else{
|
||
array_push($updateList,$r);
|
||
}
|
||
}
|
||
foreach ($updateList as $r){
|
||
$line = $this->MyagentModel->where(["Mobile"=>$r["ShopId"]])->find();
|
||
$line->UserName = $r["NickName"];
|
||
$line->PlatformType = $r["PlatformType"];
|
||
$line->save();
|
||
}
|
||
$insetData = [];
|
||
foreach ($addList as $r){
|
||
$insetData_item = [
|
||
"NickName"=>$r["NickName"],
|
||
"Mobile"=>$r["ShopId"],
|
||
"UserName"=>$r["NickName"],
|
||
"DbAreas"=>"",
|
||
"STOREID"=>0,
|
||
"isShop"=>1,
|
||
"PlatformType"=>$r["PlatformType"]
|
||
];
|
||
array_push($insetData,$insetData_item);
|
||
}
|
||
$Model = new \app\common\model\dgj\Myagent;
|
||
$res = $Model->saveAll($insetData);
|
||
$lists = $this->MyagentModel->where(["STOREID"=>0])->where(["isShop"=>1])->select();
|
||
if(count($lists)>0){
|
||
$text = "未绑定货主店铺:\n";
|
||
foreach ($lists as $r){
|
||
$text.=$r["Mobile"]."({$r['NickName']})\n";
|
||
}
|
||
$text.="发送商家绑定+店铺ID+英文逗号分隔符+货主id,一行一个绑定,例子:\n商家绑定\n7653846,18000";
|
||
$msg = $this->toMsg($this->room_id,$text);
|
||
$this->redis->select(2);
|
||
$this->redis->lpush("Message",json_encode($msg));
|
||
$this->redis->close();
|
||
}
|
||
|
||
return 1;
|
||
}
|
||
private function ProductLoadList($pingtai,$pageSize,$pageIndex=1,$skuid="",$CargoNumber="",$SkuCargoNumber="",$SelectAgentId=""){
|
||
$url = "https://fx{$pingtai}.dgjapp.com/Product/LoadList";
|
||
$params = [
|
||
"PageIndex"=>$pageIndex,
|
||
"PageSize"=>$pageSize,
|
||
"SelectShopId"=>"",
|
||
"SelectSupplierId"=>"",
|
||
"SelectAgentId"=>$SelectAgentId,
|
||
"SelectPlatformType"=>"",
|
||
"InputProductName"=>"",
|
||
"ProductType"=>"all",
|
||
"ProductStatus"=>"0",
|
||
"ProductCargoNumber"=>$CargoNumber,
|
||
"ProductSkuName"=>"",
|
||
"ProductShortTitle"=>"",
|
||
"ProductSkuShortTitle"=>"",
|
||
"IsSetShortTitle"=>"",
|
||
"IsSetSkuShortTitle"=>"",
|
||
"IsSetWeight"=>"",
|
||
"IsSkuSetWeight"=>"",
|
||
"ProductId"=>"",
|
||
"SkuId"=>$skuid,
|
||
"SkuCargoNumber"=>$SkuCargoNumber,
|
||
"IsDeleted"=>"false",
|
||
"IsRelationBaseProduct"=>"",
|
||
"IsCustomerOrder"=>"false",
|
||
"FxPageType"=>"1"
|
||
];
|
||
$dbname="wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W";
|
||
$res = $this->sendProxyRequest($url,$params,$dbname);
|
||
return $res;
|
||
}
|
||
private function LoadMyAgentList($pageIndex=1){//获取商家列表
|
||
$url = "https://fxali.dgjapp.com/Partner/LoadMyAgentList";
|
||
$params = [
|
||
"key"=>"",
|
||
"status"=>"0s",
|
||
"pageIndex"=>$pageIndex,
|
||
"pageSize"=>"100",
|
||
"IsCustomerOrder"=>"false",
|
||
"FxPageType"=>"1"
|
||
];
|
||
$dbname="wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W";
|
||
$res = $this->sendProxyRequest($url,$params,$dbname);
|
||
return $res;
|
||
}
|
||
private function LoadMShopList($pageIndex=1){//获取店铺列表
|
||
$url = "https://fxali.dgjapp.com/partner/LoadMyShopList";
|
||
$params = [
|
||
"_reqModel"=>[
|
||
"ShopId"=>"0",
|
||
"PageIndex"=>$pageIndex,
|
||
"PageSize"=>"500",
|
||
"ShopIds"=>"",
|
||
"IsWherQuery"=>"true",
|
||
"Status"=>"1"
|
||
],
|
||
"IsCustomerOrder"=>"false",
|
||
"FxPageType"=>"1"
|
||
];
|
||
$dbname="wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W";
|
||
$res = $this->sendProxyRequest($url,$params,$dbname);
|
||
return $res;
|
||
}
|
||
private function LoadCrossBorderShopList($pageIndex=1){//获取跨境店铺列表
|
||
$url = "https://fxali.dgjapp.com/partner/LoadCrossBorderShopList";
|
||
$params = [
|
||
"_reqModel"=>[
|
||
"ShopId"=>"0",
|
||
"Status"=>"0",
|
||
"PageIndex"=>$pageIndex,
|
||
"PageSize"=>"500",
|
||
"ShopIds"=>"",
|
||
"IsWherQuery"=>"true"
|
||
],
|
||
"IsCustomerOrder"=>"false",
|
||
"FxPageType"=>"1"
|
||
];
|
||
$dbname="wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W";
|
||
$traceId2 = $this->redis->get("traceId2");
|
||
$res = $this->sendProxyRequest($url,$params,$dbname);
|
||
return $res;
|
||
}
|
||
private function getKuaishouPrintDataQuery($orders,$RequestBatchNumber,$TemplateId){
|
||
$currentDateTime = new \DateTime();
|
||
$formattedDateTime = $currentDateTime->format('YmdHis');
|
||
$params = [
|
||
"TemplateId"=>$TemplateId,
|
||
"PackageCount"=>"1",
|
||
"PackageDesc"=>"",
|
||
"GoodsDesc"=>"",
|
||
"PrintMethod"=>"Normal",
|
||
"IsIgnoreWaybillRepeat"=>"true",
|
||
"PrinterName"=>"wms打印机",
|
||
"IsPreview"=>"false",
|
||
"IsContinueForStock"=>"false",
|
||
"PackageLength"=>"",
|
||
"PackageWidth"=>"",
|
||
"PackageHeight"=>"",
|
||
"ExpressSustenance"=>[
|
||
"name"=>"",
|
||
"desc"=>""
|
||
],
|
||
"Orders"=>$orders,
|
||
"RequestBatchNumber"=>"1/1/".$RequestBatchNumber,
|
||
"IsCustomerOrder"=>"false",
|
||
"FxPageType"=>"2"
|
||
];
|
||
$dbname="wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W";
|
||
$url = "https://fxali.dgjapp.com/NewOrder/ExpressPrint";
|
||
$res = $this->sendProxyRequest($url,$params,$dbname);
|
||
return $res;
|
||
}
|
||
private function sendProxyRequest($url,$data,$dbname,$pddPageCode="",$traceId2=""){
|
||
$this->redis->select(1);
|
||
$cookie = $this->redis->get("dianguanjia_cookie");
|
||
$urlEncodedString = http_build_query($data);
|
||
$token = $this->redis->get("dianguanjia_token");
|
||
$sec_ch_ua = $this->redis->get("sec-ch-ua");
|
||
$traceId = $traceId2?$traceId2:$this->redis->get("traceId");
|
||
$UserAgent = $this->redis->get("dianguanjia_UserAgent");
|
||
// 使用正则表达式匹配完整域名部分(包含可能的子域名)
|
||
preg_match('/^(?:https?:\/\/)?([^:\/\n]+)/', $url, $matches);
|
||
$query_url = $url."?token={$token}&traceId={$traceId}&dbname={$dbname}";
|
||
$headers = array(
|
||
'Content-Type: application/x-www-form-urlencoded',
|
||
'Origin:https://'.$matches[1],
|
||
'X-Requested-With:XMLHttpRequest',
|
||
'Cookie: '.$cookie,
|
||
'Sec-Fetch-Dest:empty',
|
||
'Sec-Fetch-Site:same-origin',
|
||
'Sec-Fetch-Mode:cors',
|
||
'sec-ch-ua:'.$sec_ch_ua,
|
||
'Priority:u=0',
|
||
'User-Agent:'.$UserAgent,
|
||
);
|
||
if($pddPageCode){
|
||
array_push($headers,"X-PDD-PageCode:{$pddPageCode}");
|
||
array_push($headers,"X-PDD-Pati: ");
|
||
foreach ($headers as $index => $r){
|
||
if(strpos($r,"Cookie")!==false){
|
||
$headers[$index].=";1227061-pdd-pagecode={$pddPageCode}";
|
||
}
|
||
}
|
||
}
|
||
$options = [
|
||
CURLOPT_HTTPHEADER => $headers,
|
||
CURLOPT_TIMEOUT =>30
|
||
];
|
||
$req = $this->sendRequestLocal($query_url, $urlEncodedString, $headers);
|
||
if(trim($req["msg"])==""){
|
||
//店管家过期
|
||
$msg = $this->toMsg($this->room_id,"店管家接口可能失效");
|
||
$this->redis->select(2);
|
||
$this->redis->lpush("Message",json_encode($msg));
|
||
}
|
||
$req = json_decode(($req["msg"] ?? null),true);
|
||
|
||
/*if(isset($req["Success"])&&$req["Success"]==false){
|
||
$msg = $this->toMsg($this->room_id,"店管家接口错误:".$this->unicode_to_chinese(json_encode($req))."\n--------------".$url."--------------\n".json_encode($data)."\n--------------".$url."--------------\n".json_encode($headers));
|
||
$this->redis->select(2);
|
||
$this->redis->lpush("Message",json_encode($msg));
|
||
}*/
|
||
return $req;
|
||
}
|
||
private function sendRequestLocal($query_url,$urlEncodedString,$headers){
|
||
$url = "http://file.gztbyc.com/sendRequest";
|
||
$body = [
|
||
"query_url"=>$query_url,
|
||
"urlEncodedString"=>$urlEncodedString,
|
||
"headers"=>json_encode($headers)
|
||
];
|
||
$options = [
|
||
CURLOPT_TIMEOUT =>30
|
||
];
|
||
$urlEncodedString = http_build_query($body);
|
||
$req = Http::sendRequest($url, $urlEncodedString, 'POST', $options);
|
||
return $req;
|
||
}
|
||
private function toMsg($to,$text){
|
||
return [
|
||
"method"=>"sendText",
|
||
"wxid"=> $to,
|
||
"msg"=> $text,
|
||
"atid"=> '',
|
||
"pid"=> 0
|
||
];
|
||
}
|
||
private function isBeforeGivenTime($timeString) {
|
||
// 获取当前时间
|
||
$currentTime = new \DateTime();
|
||
|
||
try {
|
||
// 解析输入的时间字符串
|
||
$givenTime = \DateTime::createFromFormat('H:i', $timeString);
|
||
|
||
if (!$givenTime) {
|
||
return false;
|
||
}
|
||
|
||
// 比较当前时间与给定时间
|
||
return $currentTime < $givenTime;
|
||
} catch (Exception $e) {
|
||
// 处理异常情况(如时间格式错误)
|
||
return false;
|
||
}
|
||
}
|
||
public function autoAudit(){
|
||
$key = 'my_lock2';
|
||
$lockValue = 'autoAudit';
|
||
$lockTimeout = 300; // 5分钟
|
||
$lockAcquired = $this->redis->set($key, $lockValue, ['NX', 'EX' => $lockTimeout]);
|
||
if (!$lockAcquired) {
|
||
return "已上锁";
|
||
}
|
||
$count = $this->redis->llen("orders_data");
|
||
if($count>0){
|
||
return "已上锁,等待处理";
|
||
}
|
||
$warehouse_list = $this->WarehouseModel->select();
|
||
$STOREARR = [];
|
||
$STORES = [];
|
||
$STOREIDS = [];
|
||
$addList = [];
|
||
$timestamp = date("Y-m-d H:i:s",strtotime("-44 days", strtotime(date("Y-m-d", time()))));
|
||
$rules = [];
|
||
foreach ($warehouse_list as $r){
|
||
if($r["dgjAutoAudit"]){
|
||
$dgjAutoAudit = json_decode($r["dgjAutoAudit"],true);
|
||
foreach ($dgjAutoAudit as $rrr){
|
||
array_push($rules,$rrr);
|
||
}
|
||
}
|
||
}
|
||
$MultiFilters = [[[
|
||
"TableAlias"=>"o",
|
||
"FieldType"=>"string",
|
||
"TableName"=>"LogicOrder",
|
||
"Name"=>"PrintRemark",
|
||
"Value"=>"核实需要发货",
|
||
"Contract"=>"not like",
|
||
"Operator"=>"AND"
|
||
]]];
|
||
foreach ($rules as $r){
|
||
if(!$this->isBeforeGivenTime($r["endTime"])){
|
||
echo $r["Title"]."不在开启时间\n";
|
||
continue;
|
||
}
|
||
if($this->isBeforeGivenTime($r["startTime"])){
|
||
echo $r["Title"]."不在开启时间\n";
|
||
continue;
|
||
}else{
|
||
echo $r["Title"]."执行\n";
|
||
}
|
||
$isNextData = $this->isBeforeGivenTime($r["startTime"]);
|
||
if (!$isNextData) {
|
||
$date = date("Y-m-d");
|
||
} else {
|
||
$date = date("Y-m-d", strtotime("-1 day"));
|
||
}
|
||
if(!isset($r["STOREID"])){
|
||
continue;
|
||
}
|
||
$dgjMyagent1 = $this->MyagentModel->where("STOREID","in",$r["STOREID"])->where(["isShop"=>0])->select();
|
||
$pingtais1 = [
|
||
"ali"=>[],
|
||
"dd"=>[],
|
||
"pdd"=>[],
|
||
"jd"=>[],
|
||
"unknow"=>[]
|
||
];
|
||
foreach ($dgjMyagent1 as $rrr){
|
||
$dbnames = json_decode($rrr["DbAreas"],true);
|
||
foreach ($dbnames as $rr){
|
||
switch($rr["DbName"]){
|
||
case "alibaba_fendan_062":
|
||
array_push($pingtais1["ali"],$rrr["UpFxUserId"]);
|
||
break;
|
||
case "pinduoduo":
|
||
array_push($pingtais1["pdd"],$rrr["UpFxUserId"]);
|
||
break;
|
||
case "toutiao":
|
||
array_push($pingtais1["dd"],$rrr["UpFxUserId"]);
|
||
break;
|
||
case "jingdong":
|
||
array_push($pingtais1["jd"],$rrr["UpFxUserId"]);
|
||
break;
|
||
default:
|
||
array_push($pingtais1["unknow"],$rrr["UpFxUserId"]);
|
||
}
|
||
}
|
||
}
|
||
foreach ($pingtais1 as $pingtai => $UpFxUserIds){
|
||
if($pingtai=="unknow" || count($UpFxUserIds)==0){
|
||
continue;
|
||
}
|
||
$filters = [[
|
||
'TableAlias' => 'o',
|
||
'FieldType' => 'DateTime',
|
||
'TableName' => 'LogicOrder',
|
||
'Name' => "CreateTime",
|
||
'Value' => $timestamp,
|
||
'Contract' => "between",
|
||
'ExtValue'=>"{$date} {$r['endTime']}:00.999"
|
||
],
|
||
[
|
||
'TableAlias' => 'o',
|
||
'FieldType' => 'int',
|
||
'TableName' => 'LogicOrder',
|
||
'Name' => "PrintState",
|
||
'Value' => 0,
|
||
'Contract' => "="
|
||
],[
|
||
'TableAlias' => 'o',
|
||
'FieldType' => 'string',
|
||
'TableName' => 'LogicOrder',
|
||
'Name' => "ErpState",
|
||
'Value' => "waitsellersend",
|
||
'Contract' => "="
|
||
],[
|
||
'TableAlias' => 'pfn',
|
||
'FieldType' => 'int',
|
||
'TableName' => 'PathFlowNode',
|
||
'Name' => "UpFxUserId",
|
||
'Value' => implode(",",$UpFxUserIds),
|
||
'Contract' => "in"
|
||
]];
|
||
if(isset($r["PlatformType"]) && $r["PlatformType"]!=""){
|
||
array_push($filters,[
|
||
'TableAlias'=>'o',
|
||
'FieldType'=>'string',
|
||
'TableName'=>'LogicOrder',
|
||
'Name'=>'PlatformType',
|
||
'Value'=>$r["PlatformType"],
|
||
'Contract'=>'in'
|
||
]);
|
||
}
|
||
if(isset($r["Address"]) && $r["Address"]!=""){
|
||
array_push($filters,[
|
||
'TableAlias'=>'o',
|
||
'FieldType'=>'string',
|
||
'TableName'=>'LogicOrder',
|
||
'Name'=>'ToShortAddress',
|
||
'Value'=>$r["Address"],
|
||
'Contract'=>'not in',
|
||
'CustomQuery'=>'CustomSearchToShortAddress'
|
||
]);
|
||
}
|
||
if(isset($r["excludeFlag"]) && $r["excludeFlag"]!=""){
|
||
array_push($filters,[
|
||
'TableAlias'=>'o',
|
||
'FieldType'=>'string',
|
||
'TableName'=>'LogicOrder',
|
||
'Name'=>'SellerRemarkFlag',
|
||
'Value'=>$r["excludeFlag"],
|
||
'Contract'=>'not like',
|
||
'CustomQuery'=>'CustomerSellerRemarkFlag'
|
||
]);
|
||
}
|
||
if(isset($r["maxCount"])&&$r["maxCount"]>0){
|
||
array_push($filters,[
|
||
'TableAlias'=>'o',
|
||
'FieldType'=>'int',
|
||
'TableName'=>'LogicOrder',
|
||
'Name'=>'ProductItemCount',
|
||
'Value'=>$r["maxCount"],
|
||
'Contract'=>'小于等于'
|
||
]);
|
||
}
|
||
$result = $this->NewOrderList1($pingtai,$filters,$MultiFilters,500,1);
|
||
$order_list = $result["rows"];
|
||
echo $pingtai."|".json_encode($filters).json_encode($result).count($order_list)."\n";
|
||
foreach ($order_list as $rr){
|
||
if($rr["ITEMS"]!=""){
|
||
$info = $this->createOrder($rr);
|
||
if($info[1] && $info[2] && $info[4]){
|
||
array_push($addList,$info);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
}
|
||
$order_list = [];
|
||
foreach ($addList as $index => $r){
|
||
array_push($order_list,$r);
|
||
}
|
||
$order_lists = [];
|
||
if(count($order_list)>0){
|
||
$order_lists = array_chunk($order_list,10);
|
||
foreach ($order_lists as $order_list_r){
|
||
$this->redis->lpush("orders_data",json_encode($order_list_r));
|
||
}
|
||
}
|
||
$this->redis->del($key);
|
||
return json([$STOREARR,count($order_lists)]);
|
||
}
|
||
public function create_data_loop(){
|
||
$key = 'create_data_loop';
|
||
$lockValue = '1';
|
||
$lockTimeout = 300; // 5分钟
|
||
$lockAcquired = $this->redis->set($key, $lockValue, ['NX', 'EX' => $lockTimeout]);
|
||
if (!$lockAcquired) {
|
||
return "已上锁";
|
||
}
|
||
$datas = $this->redis->rpop("orders_data");
|
||
$orders = json_decode($datas);
|
||
if($orders){
|
||
$url = "http://wms.gztbyc.com/dgj/CreateOrder";
|
||
$body = [
|
||
"orders"=>$orders
|
||
];
|
||
$options = [];
|
||
$urlEncodedString = http_build_query($body);
|
||
$req = Http::sendRequest($url, $urlEncodedString, 'POST', $options);
|
||
}
|
||
$this->redis->del($key);
|
||
return json($orders);
|
||
}
|
||
public function GetSyncStatus(){
|
||
$key = 'my_lock4';
|
||
$lockValue = 'GetSyncStatus';
|
||
$lockTimeout = 300; // 5分钟
|
||
$lockAcquired = $this->redis->set($key, $lockValue, ['NX', 'EX' => $lockTimeout]);
|
||
if (!$lockAcquired) {
|
||
return "已上锁";
|
||
}
|
||
$ress = [];
|
||
foreach ($this->cloudPlatformType as $k =>$r){
|
||
$url = "https://fx{$k}.dgjapp.com/NewOrder/GetSyncStatus";
|
||
$params = [
|
||
"cloudPlatformType"=>$r,
|
||
"IsCustomerOrder" => false,
|
||
"FxPageType"=>"2"
|
||
];
|
||
$dbname="wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W";
|
||
$res = $this->sendProxyRequest($url,$params,$dbname);
|
||
array_push($ress,$res);
|
||
}
|
||
$this->redis->del($key);
|
||
return json($ress);
|
||
}
|
||
public function autoAuditOnly(){
|
||
$key = 'my_lock1';
|
||
$lockValue = 'autoAudit';
|
||
$lockTimeout = 300; // 5分钟
|
||
$lockAcquired = $this->redis->set($key, $lockValue, ['NX', 'EX' => $lockTimeout]);
|
||
if (!$lockAcquired) {
|
||
return "已上锁";
|
||
}
|
||
$warehouse_list = $this->WarehouseModel->select();
|
||
$STOREARR = [];
|
||
$STORES = [];
|
||
$STOREIDS = [];
|
||
$addList = [];
|
||
$timestamp = date("Y-m-d H:i:s",strtotime("-44 days", strtotime(date("Y-m-d", time()))));
|
||
$rules = [
|
||
[
|
||
"STOREID"=>56700,
|
||
"startTime"=>"0:00",
|
||
"endTime"=>"2:00",
|
||
"excludeFlag"=>"",
|
||
"maxCount"=>1000
|
||
],
|
||
[
|
||
"STOREID"=>56700,
|
||
"startTime"=>"6:00",
|
||
"endTime"=>"9:00",
|
||
"excludeFlag"=>"",
|
||
"maxCount"=>1000
|
||
]
|
||
];
|
||
$MultiFilters = [[[
|
||
"TableAlias"=>"o",
|
||
"FieldType"=>"string",
|
||
"TableName"=>"LogicOrder",
|
||
"Name"=>"PrintRemark",
|
||
"Value"=>"核实需要发货",
|
||
"Contract"=>"not like",
|
||
"Operator"=>"AND"
|
||
]]];
|
||
foreach ($rules as $r){
|
||
if(count($addList)>=10){
|
||
break;
|
||
}
|
||
if(!$this->isBeforeGivenTime($r["endTime"])){
|
||
//echo $r["STOREID"]."closed";
|
||
continue;
|
||
}
|
||
$isNextData = $this->isBeforeGivenTime($r["startTime"]);
|
||
if (!$isNextData) {
|
||
$date = date("Y-m-d");
|
||
} else {
|
||
$date = date("Y-m-d", strtotime("-1 day"));
|
||
}
|
||
$dgjMyagent1 = $this->MyagentModel->where("STOREID","in",$r["STOREID"])->where(["isShop"=>0])->select();
|
||
$pingtais1 = [
|
||
"ali"=>[],
|
||
"dd"=>[],
|
||
"pdd"=>[],
|
||
"unknow"=>[]
|
||
];
|
||
//print_r($dgjMyagent1);
|
||
foreach ($dgjMyagent1 as $rrr){
|
||
$dbnames = json_decode($rrr["DbAreas"],true);
|
||
foreach ($dbnames as $rr){
|
||
switch($rr["DbName"]){
|
||
case "alibaba_fendan_062":
|
||
array_push($pingtais1["ali"],$rrr["UpFxUserId"]);
|
||
break;
|
||
case "pinduoduo":
|
||
array_push($pingtais1["pdd"],$rrr["UpFxUserId"]);
|
||
break;
|
||
case "toutiao":
|
||
array_push($pingtais1["dd"],$rrr["UpFxUserId"]);
|
||
break;
|
||
default:
|
||
array_push($pingtais1["unknow"],$rrr["UpFxUserId"]);
|
||
}
|
||
}
|
||
}
|
||
|
||
foreach ($pingtais1 as $pingtai => $UpFxUserIds){
|
||
if($pingtai!="dd" || count($UpFxUserIds)==0){
|
||
continue;
|
||
}
|
||
$filters = [[
|
||
'TableAlias' => 'o',
|
||
'FieldType' => 'DateTime',
|
||
'TableName' => 'LogicOrder',
|
||
'Name' => "CreateTime",
|
||
'Value' => $timestamp,
|
||
'Contract' => "between",
|
||
'ExtValue'=>"{$date} {$r['endTime']}:00.999"
|
||
],[
|
||
'TableAlias' => 'o',
|
||
'FieldType' => 'string',
|
||
'TableName' => 'LogicOrder',
|
||
'Name' => "ErpState",
|
||
'Value' => "waitsellersend",
|
||
'Contract' => "="
|
||
],[
|
||
'TableAlias' => 'pfn',
|
||
'FieldType' => 'int',
|
||
'TableName' => 'PathFlowNode',
|
||
'Name' => "UpFxUserId",
|
||
'Value' => implode(",",$UpFxUserIds),
|
||
'Contract' => "in"
|
||
]];
|
||
if($r["excludeFlag"]!=""){
|
||
array_push($filters,[
|
||
'TableAlias'=>'o',
|
||
'FieldType'=>'string',
|
||
'TableName'=>'LogicOrder',
|
||
'Name'=>'SellerRemarkFlag',
|
||
'Value'=>$r["excludeFlag"],
|
||
'Contract'=>'not like',
|
||
'CustomQuery'=>'CustomerSellerRemarkFlag'
|
||
]);
|
||
}
|
||
if($r["maxCount"]>0){
|
||
array_push($filters,[
|
||
'TableAlias'=>'o',
|
||
'FieldType'=>'int',
|
||
'TableName'=>'LogicOrder',
|
||
'Name'=>'ProductItemCount',
|
||
'Value'=>$r["maxCount"],
|
||
'Contract'=>'小于等于'
|
||
]);
|
||
}
|
||
$result = $this->NewOrderList1($pingtai,$filters,$MultiFilters,40,1);
|
||
$order_list = $result["rows"];
|
||
foreach ($order_list as $rr){
|
||
if($rr["ITEMS"]!=""){
|
||
$info = $this->createOrder($rr);
|
||
if($info[1] && $info[2] && $info[4]){
|
||
array_push($addList,$info);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
}
|
||
$order_list = [];
|
||
foreach ($addList as $index => $r){
|
||
if($index<10){
|
||
array_push($order_list,$r);
|
||
}
|
||
}
|
||
if(count($order_list)>0){
|
||
$url = "http://wms.gztbyc.com/dgj/CreateOrder";
|
||
$body = [
|
||
"orders"=>$order_list
|
||
];
|
||
$options = [];
|
||
$urlEncodedString = http_build_query($body);
|
||
$req = Http::sendRequest($url, $urlEncodedString, 'POST', $options);
|
||
}
|
||
$this->redis->del($key);
|
||
return json([$STOREARR,$addList,$order_list]);
|
||
}
|
||
private function editPostNumdgj($IDS){
|
||
$data = implode(",",$IDS);
|
||
|
||
$res = Wsdl::webservice([$data],'editPostNumdgj');
|
||
return json([$res,$IDS]);
|
||
}
|
||
private function synOrderdgj($IDS){
|
||
$data = implode(",",$IDS);
|
||
$res = Wsdl::webservice([$data],'synOrderdgj');
|
||
return json([$res,$IDS]);
|
||
}
|
||
|
||
public function autoSynOrderdgj(){
|
||
$lockkey = 'my_lock3';
|
||
$lockValue = 'autoSynOrderdgj';
|
||
$lockTimeout = 300; // 5分钟
|
||
$lockAcquired = $this->redis->set($lockkey, $lockValue, ['NX', 'EX' => $lockTimeout]);
|
||
if (!$lockAcquired) {
|
||
return "已上锁";
|
||
}
|
||
$orders = $this->OrderModel->field("ID,JDFLAG,CUSTOMERID,SOURCEID")->where(["POSTFLAG"=>1,"SYNFLAG"=>0,"SOURCECODE"=>"Z15","FLAG"=>0])->where("POSTNUM<>'null'")->limit(500)->order("CREATIONDATE")->select();
|
||
$pingtaiOrder = [];
|
||
foreach ($orders as $r){
|
||
$pingtai = isset($this->pingtais[$r["JDFLAG"]])?$this->pingtais[$r["JDFLAG"]]:null;
|
||
if($r["CUSTOMERID"]==1){
|
||
$pingtai = "ali";
|
||
}
|
||
if(!$pingtai){
|
||
continue;
|
||
}
|
||
if(!array_key_exists($pingtai, $pingtaiOrder)){
|
||
$pingtaiOrder[$pingtai] = [$r["SOURCEID"]];
|
||
}else{
|
||
array_push($pingtaiOrder[$pingtai],$r["SOURCEID"]);
|
||
}
|
||
}
|
||
$noinarr = [];
|
||
$inarr = [];
|
||
foreach ($pingtaiOrder as $key =>$r){
|
||
$v = implode(",",$r);
|
||
$filters = [
|
||
[
|
||
'TableAlias' => 'o',
|
||
'FieldType' => "string",
|
||
'TableName' => 'LogicOrder',
|
||
'Name' => "PlatformOrderId",
|
||
'Value' => $v,
|
||
'Contract' => "in",
|
||
'CustomQuery'=>'PlatformOrderIdSearch'
|
||
]
|
||
];
|
||
$MultiFilters = [];
|
||
$pageSize =500;
|
||
$pageIndex = 1;
|
||
$orders_list = $this->NewOrderList1($key,$filters,$MultiFilters,$pageSize,$pageIndex);
|
||
$orders_list = $orders_list["rows"];
|
||
foreach ($orders_list as $rr){
|
||
if($rr["ErpState"]=="sended" || $rr["ErpState"]=="success"){
|
||
array_push($inarr,$rr["PlatformOrderId"]);
|
||
}else{
|
||
array_push($noinarr,$rr["PlatformOrderId"]);
|
||
}
|
||
}
|
||
}
|
||
$IDS = [];
|
||
foreach ($orders as $r){
|
||
if(in_array($r["SOURCEID"],$noinarr)){
|
||
array_push($IDS,$r["ID"]);
|
||
}
|
||
if(in_array($r["SOURCEID"],$inarr)){
|
||
$r->SYNFLAG = 1;
|
||
$res = $r->save();
|
||
}
|
||
}
|
||
$res = "";
|
||
$this->synOrderdgj($IDS);
|
||
$this->redis->select(1);
|
||
$this->redis->del($lockkey);
|
||
return json([$noinarr,$inarr,$res]);
|
||
}
|
||
public function autoPostNumdgj2(){
|
||
$key = 'lock_autoPostNumdgj2';
|
||
$lockValue = 'autoPostNumdgj2';
|
||
$lockTimeout = 300; // 5分钟
|
||
$lockAcquired = $this->redis->set($key, $lockValue, ['NX', 'EX' => $lockTimeout]);
|
||
if (!$lockAcquired) {
|
||
return "已上锁";
|
||
}
|
||
$data = $lockAcquired = $this->redis->get("stopPost");
|
||
if($data){
|
||
$this->redis->del($key);
|
||
return "已关闭自动分配";
|
||
}
|
||
|
||
$WAREHOUSEMODEL = new \app\common\model\Warehouse;
|
||
$WAREHOUSES = $WAREHOUSEMODEL->select();
|
||
$SOURCEIDS = [];
|
||
foreach ($WAREHOUSES as $WAREHOUSE){
|
||
if($WAREHOUSE['autoPostNumdgj']==0){
|
||
continue;
|
||
}
|
||
$exclude = $WAREHOUSE["exclude_express"]?explode("|",$WAREHOUSE["exclude_express"]):[];
|
||
$where = [];
|
||
foreach ($exclude as $r){
|
||
array_push($where,'LEAVEMESSAGE not like "%'.$r.'%"');
|
||
}
|
||
$where_str = implode(" and ",$where);
|
||
$orders = $this->OrderModel->field("ID,JDFLAG,SOURCEID")->where(["WAREHOUSEID"=>$WAREHOUSE['WAREHOUSEID']])->where($where_str)->where(["POSTFLAG"=>0,"FLAG"=>0,"SOURCECODE"=>"Z15","ISLOCK"=>0])->where("LEAVEMESSAGE='' or LEAVEMESSAGE is null")->limit(500)->select();
|
||
$IDS = [];
|
||
foreach ($orders as $r){
|
||
array_push($IDS,$r["ID"]);
|
||
array_push($SOURCEIDS,$r["SOURCEID"]);
|
||
}
|
||
$ids = array_chunk($IDS,20);
|
||
foreach ($ids as $autoPostNumIds){
|
||
$this->editPostNumdgj($autoPostNumIds);
|
||
}
|
||
}
|
||
|
||
$this->redis->del($key);
|
||
if(count($SOURCEIDS)>0){
|
||
return implode("\n",$SOURCEIDS);
|
||
}else{
|
||
return "";
|
||
}
|
||
}
|
||
public function clearPostNull(){
|
||
$orders = $this->OrderModel->where(["POSTFLAG"=>1,"POSTNUM"=>"null"])->select();
|
||
$SOURCEIDS = [];
|
||
$IDS = [];
|
||
foreach ($orders as $r){
|
||
array_push($SOURCEIDS,$r["SOURCEID"]);
|
||
array_push($IDS,$r["ID"]);
|
||
$r->POSTFLAG=0;
|
||
$r->POSTNUM = null;
|
||
$r->save();
|
||
}
|
||
if(count($SOURCEIDS)>0){
|
||
$line = $this->expressModel->where("SOURCEID","in",$SOURCEIDS)->select();
|
||
foreach ($line as $r){
|
||
$r->delete();
|
||
}
|
||
}
|
||
$this->editPostNumdgj($IDS);
|
||
return json($orders);
|
||
}
|
||
public function rePOSTNUM(){
|
||
$orders = $this->OrderModel->where("POSTFLAG=1 and JDFLAG=6 and SOURCECODE='Z15' and KSKEY like '%access_token%'")->select();
|
||
$SOURCEIDS = [];
|
||
$IDS = [];
|
||
foreach ($orders as $r){
|
||
array_push($SOURCEIDS,$r["SOURCEID"]);
|
||
array_push($IDS,$r["ID"]);
|
||
$r->POSTFLAG=0;
|
||
$r->POSTNUM = null;
|
||
$r->save();
|
||
}
|
||
if(count($SOURCEIDS)>0){
|
||
$line = $this->expressModel->where("SOURCEID","in",$SOURCEIDS)->select();
|
||
foreach ($line as $r){
|
||
$r->delete();
|
||
}
|
||
}
|
||
$this->editPostNumdgj($IDS);
|
||
return json($orders);
|
||
}
|
||
public function dyparmas($data=null){
|
||
$data = urldecode($data);
|
||
$list = explode("&",$data);
|
||
$params = [];
|
||
foreach ($list as $r){
|
||
$tmp = explode("=",$r);
|
||
$params[$tmp[0]] = $tmp[1];
|
||
}
|
||
extract($params);
|
||
$signPattern = $params['access_token'].'app_key'.$params['app_key'].'method'.$params['method'].'param_json'.$params['param_json'].'timestamp'.$params['timestamp'].'v'.$params['v'].$params['access_token'];
|
||
$sign = md5("sha256", $signPattern, $params['access_token']);
|
||
return $sign;
|
||
return json($data);
|
||
}
|
||
public function rePOSTNUM2(){
|
||
$SOURCEIDS = ['4718437346297241137','4717145486612834448','4718617311697241137','4718119250729241137','4718087787997241137'];
|
||
foreach ($SOURCEIDS as $r){
|
||
$order = $this->OrderModel->where(["SOURCEID"=>$r])->find();
|
||
$PRINTID = "";
|
||
$printData = [];
|
||
if($order){
|
||
$data = $this->PrintHistoryLoadList($r);
|
||
if(isset($data["Data"]) && isset($data["Data"]["Rows"])){
|
||
try {
|
||
$PRINTID = isset($data["Data"]["Rows"][0])?$data["Data"]["Rows"][0]["ID"]:0;
|
||
if($PRINTID){
|
||
$data = $this->PrintHistoryLoadPrintData($PRINTID);
|
||
print_r($data);
|
||
$PrintDataJson = $data["Data"][0]["PrintHistoryData"]["PrintDataJson"];
|
||
$PrintData = json_decode($PrintDataJson,true);
|
||
$encryptedData = ($PrintData["PrintDataList"]["task"]["documents"][0]["contents"][0]["encryptedData"] ?? null);
|
||
$signature = $PrintData["PrintDataList"]["task"]["documents"][0]["contents"][0]["signature"];
|
||
$printData = [$encryptedData,$signature];
|
||
$order->ENCRYPTEDDATA = $encryptedData;
|
||
$order->POSTNUM = $PrintData["PrintDataList"]["task"]["documents"][0]["documentID"];
|
||
$order->TRACEPOSTNUM = $PrintData["PrintDataList"]["task"]["documents"][0]["documentID"];
|
||
//$order->VER = $PrintData["PrintDataList"]["task"]["documents"][0]["contents"][0]["ver"];
|
||
$order->POSTFLAG = 1;
|
||
$order->DAYIN = 1;
|
||
$order->SIGNATurE = $signature;
|
||
$order->save();
|
||
}
|
||
} catch (Exception $e) {
|
||
|
||
}
|
||
|
||
}
|
||
}
|
||
}
|
||
return json($printData);
|
||
}
|
||
private function PrintHistoryLoadPrintData($PRINTID){
|
||
$url = "https://fxali.dgjapp.com/PrintHistory/LoadPrintData";
|
||
$params = [
|
||
"printHistoryIds"=>[
|
||
$PRINTID
|
||
],
|
||
"IsCustomerOrder"=>"false",
|
||
"FxPageType"=>"1"
|
||
];
|
||
$dbname="wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W";
|
||
$res = $this->sendProxyRequest($url,$params,$dbname);
|
||
return $res;
|
||
}
|
||
private function PrintHistoryLoadList($SOURCEID){
|
||
$url = "https://fxali.dgjapp.com/PrintHistory/LoadList";
|
||
$params = [
|
||
"requestModel"=>[
|
||
"PrintType"=>1,
|
||
"StartDate"=>"2025-05-19+00:00:00",
|
||
"EndDate"=>"2025-05-25+23:59:59.999",
|
||
"PrintDataType"=>"0",
|
||
"TemplateName"=>"0",
|
||
"ToCountry"=>"",
|
||
"ToProvince"=>"0",
|
||
"ReciverPhone"=>"",
|
||
"PlatformOrderId"=>"",
|
||
"CustomerOrderId"=>$SOURCEID,
|
||
"PrintCount"=>"0",
|
||
"PrintCountCondition"=>"0",
|
||
"ExpressWaybillCode"=>"",
|
||
"SenderName"=>"",
|
||
"PrintBatch"=>"",
|
||
"SendType"=>"",
|
||
"OrderByField"=>"PrintDate",
|
||
"IsOrderDesc"=>"true",
|
||
"PageIndex"=>"1",
|
||
"PageSize"=>"1"
|
||
],
|
||
"Pt"=>"pinduoduo",
|
||
"IsCustomerOrder"=>"false",
|
||
"FxPageType"=>"1"
|
||
];
|
||
$dbname="wdJM8OZZiF4gKKxb82bFQlqydSPSQ9/W";
|
||
$res = $this->sendProxyRequest($url,$params,$dbname);
|
||
return $res;
|
||
}
|
||
|
||
public function stocksByStore($STOREID){
|
||
$skus = $this->StockModel->alias('stock')->field('*')->join("ye4s_dgj_myagent myagent","myagent.UpFxUserId=stock.UpFxUserId")->where(["myagent.STOREID"=>$STOREID])->where("ITEMS is not null or ITEMS <>''")->where("Subject<>'' or Subject is not null")->select();
|
||
foreach ($skus as $r){
|
||
$r["id"] = $r["SkuId"];
|
||
$r["AgentName"] = $this->getStoreName($r["myagent"]["STOREID"]);
|
||
if($r["ITEMS"]){
|
||
$r["status"] = "normal";
|
||
}else{
|
||
$r["status"] = "hidden";
|
||
}
|
||
}
|
||
$workers = [];
|
||
foreach ($skus as $r){
|
||
$tmp = [" ".$r['SkuId'],$r['SkuCode'],$r['Subject'],$r["AttributeValue"],$r["CargoNumber"],$r["SkuCargoNumber"],$r["AgentName"],$r["ITEMS"],$r["ImgUrl"]];
|
||
|
||
array_push($workers,$tmp);
|
||
}
|
||
$spreadsheet = new Spreadsheet();
|
||
$worksheet = $spreadsheet->getActiveSheet();
|
||
$title = 'SKU列表';
|
||
$worksheet->setTitle($title);
|
||
$worksheet->fromArray(
|
||
[
|
||
['SkuId','SkuCode','商品名称','规格属性','商品编码','SKU编码','货主','绑定明细','图片链接']
|
||
], '', 'A1' );
|
||
$worksheet->fromArray(
|
||
$workers, '', 'A2' );
|
||
$writer = IOFactory::createWriter($spreadsheet, 'Xls');
|
||
$filename= "dcsku".time();
|
||
$tempPath = '/www/wwwroot/ye4s.wms.gztbyc.com/public/file/'.$filename.'.xls';
|
||
$writer->save($tempPath);
|
||
return json(["code"=>1,"downloadurl"=>"https://ye4s.wms.gztbyc.com/file/".$filename.".xls","msg"=>"开始下载"]);
|
||
}
|
||
} |