load->database(); $this->table = 'apiyy'; $this->load_table('apiyy'); } public function get_number($number) { return $this->find("number = '$number'"); } public function get_cjkh($data)//创建客户 { $list["0"]["OtherID"] = $data['id'];//客户ID $list["0"]["Code"] = $data['id'];//客户编码 $list["0"]["Name"] = $data['name'];//客户名称 $list["0"]["ShortName"] = $data['name'];//客户简称 $list["0"]["TradeCategory"] = 0; $list["0"]["State"] = 0; $list["0"]["IsHoldRelease"] = false; $list["0"]["IsMISC"] = false; $list["0"]["RegisterCapital"] = 0; $list["0"]["Turnover"] = 0; $list["0"]["EmployeeCount"] = 0; $list["0"]["SaleType"] = 0; $list["0"]["Bargain"] = 0; $list["0"]["IsTaxPrice"] = true; $list["0"]["PriceListID"] = 0; $list["0"]["IsPriceListModify"] = true; $list["0"]["IsHaveContract"] = false; $list["0"]["SupplySource"] = 0; $list["0"]["DemandTransType"] = 0; $list["0"]["IsShipmentModify"] = true; $list["0"]["TransitLeadTime"] = 0; $list["0"]["IsRecTermModify"] = true; $list["0"]["IsDeposit"] = true; $list["0"]["IsPreReceival"] = false; $list["0"]["PreRcvRate"] = 0; $list["0"]["IsPreRcvRateModify"] = false; $list["0"]["IsSalesDiscount"] = true; $list["0"]["QualityPledge"] = 0; $list["0"]["IsARCfmModify"] = true; $list["0"]["IsBillByBalance"] = true; $list["0"]["InvoiceVerificationOrder"] = 0; $list["0"]["VerificationMode"] = 0; $list["0"]["IsByAccountAge"] = true; $list["0"]["IsPost"] = true; $list["0"]["CheckAccountPeriod"] = 0; $list["0"]["IsCreditCheck"] = true; $list["0"]["CustomerSiteDTOs"]["0"]["Code"] = $data['id']; $list["0"]["CustomerSiteDTOs"]["0"]["SrcRowID"] = 0; $list["0"]["CustomerSiteDTOs"]["0"]["OperateType"] = 0; $list["0"]["CustomerSiteDTOs"]["0"]["IsShipTo"] = true; $list["0"]["CustomerSiteDTOs"]["0"]["IsDefaultShipTo"] = true; $list["0"]["CustomerSiteDTOs"]["0"]["IsBillTo"] = true; $list["0"]["CustomerSiteDTOs"]["0"]["IsDefaultBillTo"] = true; $list["0"]["CustomerSiteDTOs"]["0"]["IsClaim"] = true; $list["0"]["CustomerSiteDTOs"]["0"]["IsDefaultClaim"] = true; $list["0"]["CustomerSiteDTOs"]["0"]["IsPayment"] = true; $list["0"]["CustomerSiteDTOs"]["0"]["IsDefaultPayment"] = true; $list["0"]["CustomerSiteDTOs"]["0"]["IsContrast"] = true; $list["0"]["CustomerSiteDTOs"]["0"]["IsDefaultContrast"] = true; $list["0"]["CustomerSiteDTOs"]["0"]["PriceListID"] = 0; $list["0"]["CustomerSiteDTOs"]["0"]["IsPriceListModify"] = true; $list["0"]["CustomerSiteDTOs"]["0"]["SupplySource"] = 0; $list["0"]["CustomerSiteDTOs"]["0"]["DemandTransType"] = 0; $list["0"]["CustomerSiteDTOs"]["0"]["IsShippmentRuleEditable"] = true; $list["0"]["CustomerSiteDTOs"]["0"]["ShipmentMode"] = 0; $list["0"]["CustomerSiteDTOs"]["0"]["TransitLeadTime"] = 0; $list["0"]["CustomerSiteDTOs"]["0"]["ShippingHavenID"] = 0; $list["0"]["CustomerSiteDTOs"]["0"]["TargetHavenID"] = 0; $list["0"]["CustomerSiteDTOs"]["0"]["IsPaymentTermEditable"] = true; $list["0"]["CustomerSiteDTOs"]["0"]["IsSalesDiscount"] = true; $list["0"]["CustomerSiteDTOs"]["0"]["NeedDeposit"] = true; $list["0"]["CustomerSiteDTOs"]["0"]["IsPrePayment"] = true; $list["0"]["CustomerSiteDTOs"]["0"]["IsPostBankCheckList"] = true; $list["0"]["CustomerSiteDTOs"]["0"]["InvoiceVerificationOrder"] = 0; $list["0"]["CustomerSiteDTOs"]["0"]["VerificationMode"] = 0; $list["0"]["CustomerSiteDTOs"]["0"]["BankCheckPeriod"] = 0; $list["0"]["CustomerSiteDTOs"]["0"]["QualityGuaranteeType"] = 0; $list["0"]["RecervalTerm"]["Code"] = 'YZ01'; $list["0"]["ARConfirmTerm"]["Code"] = 'YZ01'; $list["0"]["ShippmentRule"]["Code"] = '01'; $list = json_encode($list); $token = $this->setting->get_yytoken_130(); $url = 'http://172.31.105.167/U9C/webapi/Customer/Create'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return $res; } public function get_cjlp($data)//创建料品 { $list["0"]["Code"] = $data['jm'];//料号,SKU $list["0"]["Code1"] = ''; $list["0"]["Name"] = $data['zh'];//产品名称 $list["0"]["MainItemCategory"]["Code"] = $data['bm']; $list["0"]["Org"]["Code"] = 001; $list["0"]["OtherID"] = 1; $list["0"]["PurchaseInfo"]["BudgetControlType"] = -1; $list["0"]["PurchaseInfo"]["PriceSource"] = 2; $list["0"]["PurchaseInfo"]["InquireRule"] = -1; $list["0"]["PurchaseInfo"]["InquireFixedPeriod"] = 0; $list["0"]["PurchaseInfo"]["StatisticPeriod"] = -1; $list["0"]["PurchaseInfo"]["IsPUTradePathModify"] = true; $list["0"]["PurchaseInfo"]["IsPURtnTradePathModify"] = true; $list["0"]["InventoryUOM"]["Code"] = '条'; $list["0"]["InventorySecondUOM"]["Code"] = ''; $list["0"]["IsDualUOM"] = false; $list["0"]["InventoryInfo"]["InventoryPlanningMethod"] = 4; $list["0"]["InventoryInfo"]["InventoryPlanTime"] = -1; $list["0"]["InventoryInfo"]["TurnOverRate"] = 1; $list["0"]["InventoryInfo"]["ReserveMode"] = -1; $list["0"]["InventoryInfo"]["SupplyMethod"] = -1; $list["0"]["DescFlexField"]["PrivateDescSeg1"] = 01; $list["0"]["DescFlexField"]["PubDescSeg5"] = 01; $list["0"]["Description"] = $data['title']; $list["0"]["ItemForm"] = 2001; $list["0"]["ItemFormAttribute"] = 10; $list["0"]["IsInventoryEnable"] = true; $list["0"]["IsPurchaseEnable"] = true; $list["0"]["IsSalesEnable"] = true; $list["0"]["IsBuildEnable"] = true; $list["0"]["IsOutsideOperationEnable"] = true; $list["0"]["IsMRPEnable"] = true; $list["0"]["IsBOMEnable"] = true; $list["0"]["IsCostCalByGrade"] = false; $list["0"]["IsCostCalByPotency"] = false; $list["0"]["IsGradeControl"] = false; $list["0"]["StandardGrade"] = -1; $list["0"]["StartGrade"] = -1; $list["0"]["EndGrade"] = -1; $list["0"]["IsPotencyControl"] = false; $list["0"]["StandardPotency"] = -1; $list["0"]["StartPotency"] = -1; $list["0"]["EndPotency"] = -1; $list = json_encode($list); $token = $this->setting->get_yytoken_130(); $url = 'http://172.31.105.167/U9C/webapi/ItemMaster/Create'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); if(isset($res['Data'][0])) { $this->get_lpxf($data); } return $res; } public function get_lpxf($data)//传递料品 { $list["0"]["EntityFullName"] = 'UFIDA.U9.CBO.SCM.Item.ItemMaster'; $list["0"]["EntityCode"] = $data['jm'];//料号,SKU $list["0"]["FromOrgCode"] = "130"; $list["0"]["ToOrgCodeList"] = array(101,120,110); $list["0"]["OtherID"] = ""; $list["0"]["ContextDTO"]["EntCode"] = "001"; $list["0"]["ContextDTO"]["OrgCode"] = "130"; $list["0"]["ContextDTO"]["UserCode"] = "xk"; $list["0"]["ContextDTO"]["UserPwd"] = ""; $list = json_encode($list); $token = $this->setting->get_yytoken_130(); $url = 'http://172.31.105.167/U9C/webapi/ControlObjSend/ControlObjSend'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return $res; } public function get_cg($data)//无源采购 { $time = time(); if($time > 1717171200 && $time < 1717257599) { $time = time()-24*3600; } $list["0"]["BusinessDate"] = date("Y-m-d H:i:s",$time); $list["0"]["DocumentType"] = "PO01"; $list["0"]["POLineDTOList"][0]["ItemInfo"]['m_code'] = $data['sku'];//料号 $list["0"]["POLineDTOList"][0]["SupplierConfirmQtyTU"] = $data['ts'];//数量 $list["0"]["POLineDTOList"][0]["ReqQtyTU"] = $data['ts']; //$list["0"]["POLineDTOList"][0]["FinallyPriceTC"] = '';//价格 $list["0"]["POLineDTOList"][0]["SupplierConfirmQtyTBU"] = 0; //$list["0"]["POLineDTOList"][0]["DescFlexField"]['PubDescSeg3'] = 75; $list["0"]["POLineDTOList"][0]["ReqQtyTBU"] = 0; $list["0"]["POLineDTOList"][0]["POLineID"] = 0; $list["0"]["POLineDTOList"][0]["IsPresent"] = false; $list["0"]['BizType'] = 0; $list["0"]['DocNo'] = ""; $list["0"]['OtherID'] = ""; $list["0"]['DescFlexField'] = (object)array(); $list["0"]['Supplier']['Code'] = $data['purchase']; $list["0"]['IsPriceIncludeTax'] = false; $list = json_encode($list); $token = $this->setting->get_yytoken_130(); $url = 'http://172.31.105.167/U9C/webapi/PurchaseOrder/Create'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return $res; } //https://openapi.yyu9c.com/doc.html#/U9C%20OPENAPI/Receivement/Receivement_CreateRcvBySrcPO public function get_bzsh($data)//标准收货 { $time = time(); if($time > 1717171200 && $time < 1717257599) { $time = time()-24*3600; } $list["0"]["potorcvDTOS"][0]["BusinessDate"] = date("Y-m-d H:i:s",$time); $list["0"]["potorcvDTOS"][0]["Amount1"] = $data['ts'];//收货数量 $list["0"]["potorcvDTOS"][0]["Amount2"] = 0;//收货数量 $list["0"]["potorcvDTOS"][0]["PONo"] = $data['od'];//订单号 $list["0"]["potorcvDTOS"][0]["POLineNo"] = 10; $list["0"]["potorcvDTOS"][0]["POShipLineNo"] = 0; $list["0"]["potorcvDTOS"][0]["POShipLineKey"] = 0; $list["0"]["potorcvDTOS"][0]["DescFlexField"] = (object)array(); $list["0"]["potorcvDTOS"][0]["Memo"] = $data['title']; /** 库位 $list["0"]["potorcvDTOS"][0]["rlInfo"]['RcvLineLocations'][0]['BinCode'] = ""; $list["0"]["potorcvDTOS"][0]["rlInfo"]['RcvLineLocations'][0]['LocationQtyTU'] = 0; $list["0"]["potorcvDTOS"][0]["rlInfo"]['RcvLineLocations'][0]['LocationNo'] = 0; $list["0"]["potorcvDTOS"][0]["rlInfo"]['RcvLineLocations'][0]['TallyTime'] = ""; **/ $list["0"]["potorcvDTOS"][0]["rlInfo"]["Wh"]['m_iD'] = 0; $list["0"]["potorcvDTOS"][0]["rlInfo"]["Wh"]['m_code'] = 13001;//许昌仓 $list["0"]["potorcvDTOS"][0]["rlInfo"]["Wh"]['m_name'] = ""; $list["0"]["potorcvDTOS"][0]["rlInfo"]["Wh"]['sysState'] = 0; $list["0"]["potorcvDTOS"][0]["rlInfo"]["StorageType"] = 4; $list["0"]["SplitBy"] = array(); $list["0"]["IsApproved"] = false; $list["0"]["DocStatus"] = 3; $list["0"]["OtherID"] = ""; $list = json_encode($list); $token = $this->setting->get_yytoken_130(); $url = 'http://172.31.105.167/U9C/webapi/Receivement/CreateRcvBySrcPO'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return $res; } public function get_sc($data)//生产订单 { $time = time(); if($time > 1717171200 && $time < 1717257599) { $time = time()-24*3600; } $list["0"]["OtherID"] = ''; $list["0"]["Org"]['Code'] = "120"; $list["0"]["ItemMaster"]["Code"] = $data['sku']; $list["0"]["DocType"]["Code"] = $data['djlx']; $list["0"]["Department"]["Code"] = "12008"; $list["0"]["ExpandLevel"] = 0; $list["0"]["AlternateType"] = 0; $list["0"]["RoutingAlternate"] = 0; $list["0"]["RoutingEffeDate"] = ''; $list["0"]["ProductQty"] = $data['ts']; $list["0"]["ProductUOM"]["Code"] = '条'; $list["0"]["StartDate"] = date('Y-m-d',$time); $list["0"]["CompleteDate"] = date('Y-m-d',$time);//$data['time'] $list["0"]["MOSourceDocType"] = 0; $list["0"]["OwnerOrg"]["Code"] = "120"; $list["0"]["SCVWh"]["Code"] = $data['drck']; $list["0"]["DemandCode"] = -1; $list["0"]["IsFirmed"] = false; $list["0"]["IsCapacityLimit"] = false; $list["0"]["Priority"] = 0; $list["0"]["CUD"] = 0; $list["0"]["BOMType"] = 0; $list["0"]["Description"] = $data['title']; $list["0"]["MRPQty"] = 0; $list["0"]["MOID"] = 0; $list["0"]["PBUToSBURate"] = 0; $list["0"]["PBUToCBURate"] = 0; $list["0"]["DescFlexField"]["PubDescSeg2"] = $data['yyid']; $list["0"]["DescFlexField"]["PubDescSeg4"] = $data['number']; $list["0"]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks']; $list = json_encode($list); $token = $this->setting->get_yytoken_120(); $url = 'http://172.31.105.167/U9C/webapi/MODoc/Create'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return $res; } public function get_chd($data)//出货单一次出整个订单 { $list[0]["SrcDocType"] = 1; $list[0]["SrcDocNo"] = $data['number']; $list[0]["SrcDocLineNo"] = $data['i']; $list[0]["SrcDocSubLineNo"] = 10; $list[0]["WH"] = 1002309200047445; $list[0]["CurShipQty1"] = $data['ts']; $list[0]["SOIsConsign"] = false; $list[0]["OptionalSplitTerm"] = array(); $list[0]["DescFlexField"] = (object)array(); $list[0]["LineDescFlexField"] = (object)array(); //$list[0]["ShipDate"] = date("Y-m-d",$data['librarytime']+24*3600); //$list[0]["ShipConfirmDate"] = date("Y-m-d",time()); $list[0]["DocStatus"] = 0; $list = json_encode($list); $token = $this->setting->get_yytoken_130(); $url = 'http://172.31.105.167/U9C/webapi/Ship/CreateBySrcDoc'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return array($res,$list); } public function get_chd_zdd($data)//出货单一次出整个订单 { for($i=0;$isetting->get_yytoken_130(); $url = 'http://172.31.105.167/U9C/webapi/Ship/CreateBySrcDoc'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return array($res,$list); } public function get_chd_cs($data)//出货单 { $list["0"]["SrcDocType"] = 1; $list["0"]["SrcDocNo"] = $data['number']; $list["0"]["SrcDocLineNo"] = 1; $list["0"]["SrcDocSubLineNo"] = 10; $list["0"]["WH"] = 1002309200047445; $list["0"]["CurShipQty1"] = $data['ts']; $list["0"]["SOIsConsign"] = false; $list["0"]["OptionalSplitTerm"] = array(); $list["0"]["DescFlexField"] = (object)array(); $list["0"]["LineDescFlexField"] = (object)array(); //$list["0"]["ShipDate"] = date("Y-m-d",$data['librarytime']+24*3600); $list["0"]["ShipConfirmDate"] = date("Y-m-d",$data['librarytime']); $list["0"]["DocStatus"] = 0; $list = json_encode($list); return $list; } public function get_cprk($data)//产品入库 { $time = time(); if($time > 1717171200 && $time < 1717257599) { $time = time()-24*3600; } $list["0"]["DocNo"] = ''; $list["0"]["CompleteList"]["0"]["MOKey"]["OtherID"] = ''; $list["0"]["CompleteList"]["0"]["MOKey"]["ID"] = 0; $list["0"]["CompleteList"]["0"]["MOKey"]["DocNo"] = $data['rkcode']; $list["0"]["CompleteList"]["0"]["MOKey"]["OrgID"] = 0; $list["0"]["CompleteList"]["0"]["MOKey"]["IsSuccess"] = 1; $list["0"]["CompleteList"]["0"]["MOKey"]["ErrorInfo"] = ''; $list["0"]["CompleteList"]["0"]["MOKey"]["CUD"] = 0; $list["0"]["CompleteList"]["0"]["Wh"]["Code"] = 02; $list["0"]["CompleteList"]["0"]["LineNum"] = 0; $list["0"]["CompleteList"]["0"]["StorageType"] = 4; $list["0"]["CompleteList"]["0"]["Grade"] = 0; $list["0"]["CompleteList"]["0"]["Element"] = 0; $list["0"]["CompleteList"]["0"]["CompleteQty"] = $data['ts']; $list["0"]["CompleteList"]["0"]["CompleteQtyByWhUOM"] = $data['ts']; $list["0"]["CompleteList"]["0"]["CompleteQtyByCostUOM"] = $data['ts']; $list["0"]["CompleteList"]["0"]["CUD"] = 0; $list["0"]["CompleteList"]["0"]["OwnerOrg"]["Code"] = 120; $list["0"]["CompleteList"]["0"]["OutputType"] = 0; $list["0"]["CompleteList"]["0"]["Item"]["Code"] = $data['jm']; $list["0"]["CompleteList"]["0"]["ScrapQty"] = 0; $list["0"]["CompleteList"]["0"]["ScrapQtyByCostUOM"] = 0; $list["0"]["CompleteList"]["0"]["PUToPBURate"] = 0; $list["0"]["CompleteList"]["0"]["CUToCBURate"] = 0; $list["0"]["CompleteList"]["0"]["PBUToCBURate"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["ID"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["DocType"]["Code"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["BusinessDate"] = ''; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["DocNo"] = ''; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["MOSrcDocType"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocOrg"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDoc"]["ID"] = $data['rkid']; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDoc"]["EntityType"] = 'UFIDA.U9.MO.MO.MO'; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocVer"] = ''; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocLine"]["ID"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocLine"]["EntityType"] = ''; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocSubline"]["ID"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocSubline"]["EntityType"] = ''; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocNo"] = $data['rkid']; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocLineNo"] = ''; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocSublineNo"] = 10; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocID"] = $data['rkid']; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocLineID"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocType"] = ''; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["DocDate"] = date("Y-m-d",$time); //$list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["ActualRcvTime"] = date("Y-m-d",time()); $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvOrg"]["Code"] = 120; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["Org"]["Code"] = 120; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["Direction"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["DocState"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvDep"]["ID"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvDep"]["Code"] = ''; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvDep"]["Name"] = ''; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvPerson"]["ID"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvPerson"]["Code"] = ''; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvPerson"]["Name"] = ''; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["OtherID"] = ''; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["ProductUOM"]["Code"] = '条'; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["ProductBaseUOM"]["Code"] = '条'; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["StoreUOM"]["Code"] = '条'; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["StoreBaseUOM"]["Code"] = '条'; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["CoUOM"]["Code"] = '条'; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["CostBaseUOM"]["Code"] = '条'; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["OperationState"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["OutputType"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["Item"]["Code"] = $data['jm']; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["OwnerOrg"]["Code"] = 120; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["PUToPBURate"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["SUToSBURate"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["PBUToSBURate"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["CUToCBURate"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["PBUToCBURate"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["Grade"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["Element"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["Wh"]["Code"] = 02; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["StorageType"] = 4; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvValiddate"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvQtyByProductUOM"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvQtyByWhUOM"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvQtyByCostUom"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvOrg"]["Code"] = 001; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["PerformingOrg"]["Code"] = 001; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["CUD"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["LineNum"] = 0; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["MO"]["Code"] = $data['rkcode']; $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["ID"] = 0; $list["0"]["DescFlexField"]["PubDescSeg2"] = $data['kh']; $list["0"]["DescFlexField"]["PubDescSeg4"] = $data['number']; $list["0"]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks']; $list["0"]["DocType"]["Code"] = 0; $list["0"]["BusinessDate"] = date("Y-m-d H:i:s",$time); $list["0"]["OtherID"] = ''; $list["0"]["Direction"] = 0; $list["0"]["IsOffLine"] = 1; $list["0"]["DocState"] = 0; $list["0"]["Remark"] = time(); $list["0"]["RcvPerson"]["Code"] = 'ERP'; $list = json_encode($list); $token = $this->setting->get_yytoken_120(); $url = 'http://172.31.105.167/U9C/webapi/RcvRptDoc/Create'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return array($res,$list); } public function get_dc($data)//调出 { $time = time(); if($time > 1717171200 && $time < 1717257599) { $time = time()-24*3600; } $list["0"]["OtherID"] = $data['number']; $list["0"]["TransOutDocType_Code"] = 'TransOut001'; $list["0"]["BusinessDate"] = date('Y-m-d',$time); $list["0"]["TransferDirection"] = 0; //$list["0"]["DescFlexField"] = (object)array(); //$list["0"]["DescFlexField"]["PubDescSeg2"] = $data['kh']; //$list["0"]["DescFlexField"]["PubDescSeg4"] = $data['number']; //$list["0"]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks']; $list["0"]["TransOutLines"][0]['ItemInfo']['ItemCode'] = $data['jm']; $list["0"]["TransOutLines"][0]["TransOutWh_Code"] = $data['drck']; $list["0"]["TransOutLines"][0]["StoreUOM_Code"] = "条"; $list["0"]["TransOutLines"][0]["StoreUOMQty"] = $data['ts'];; $list["0"]["TransOutLines"][0]["StorageType"] = 4; $list["0"]["TransOutLines"][0]["LotInfo_Code"] = ""; $list["0"]["TransOutLines"][0]["TransOutOwnerOrg_Code"] = "120"; //$list["0"]["TransOutLines"][0]["DescFlexField"] = (object)array(); $list["0"]["TransOutLines"][0]["DescFlexField"]["PubDescSeg2"] = $data['kh']; $list["0"]["TransOutLines"][0]["DescFlexField"]["PubDescSeg4"] = $data['number']; $list["0"]["TransOutLines"][0]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks']; $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInWh_Code'] = "13001"; $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StorageType'] = 4; $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInOrg_Code'] = "130"; $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransOutOwnerOrg_Code'] = "120"; $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StoreUOMQty'] = $data['ts']; $list["0"]["TransOutLines"][0]["TransOutBins"][0]['BinInfo_Code'] = ""; $list["0"]["TransOutLines"][0]["TransOutBins"][0]['StoreUOMQty'] = 1; $list = json_encode($list); $token = $this->setting->get_yytoken_120(); $url = 'http://172.31.105.167/U9C/webapi/TransferOut/Create'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return array($res,$list); } public function get_dc_cs($data)//调出 { $list["0"]["OtherID"] = $data['number']; $list["0"]["TransOutDocType_Code"] = 'TransOut001'; $list["0"]["BusinessDate"] = date('Y-m-d',time()); $list["0"]["TransferDirection"] = 0; //$list["0"]["DescFlexField"] = (object)array(); //$list["0"]["DescFlexField"]["PubDescSeg2"] = $data['kh']; //$list["0"]["DescFlexField"]["PubDescSeg4"] = $data['number']; //$list["0"]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks']; $list["0"]["TransOutLines"][0]['ItemInfo']['ItemCode'] = $data['jm']; $list["0"]["TransOutLines"][0]["TransOutWh_Code"] = $data['drck']; $list["0"]["TransOutLines"][0]["StoreUOM_Code"] = "条"; $list["0"]["TransOutLines"][0]["StoreUOMQty"] = $data['ts'];; $list["0"]["TransOutLines"][0]["StorageType"] = 4; $list["0"]["TransOutLines"][0]["LotInfo_Code"] = ""; $list["0"]["TransOutLines"][0]["TransOutOwnerOrg_Code"] = "120"; //$list["0"]["TransOutLines"][0]["DescFlexField"] = (object)array(); $list["0"]["TransOutLines"][0]["DescFlexField"]["PubDescSeg2"] = $data['kh']; $list["0"]["TransOutLines"][0]["DescFlexField"]["PubDescSeg4"] = $data['number']; $list["0"]["TransOutLines"][0]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks']; $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInWh_Code'] = "13001"; $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StorageType'] = 4; $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInOrg_Code'] = "130"; $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransOutOwnerOrg_Code'] = "120"; $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StoreUOMQty'] = $data['ts']; $list["0"]["TransOutLines"][0]["TransOutBins"][0]['BinInfo_Code'] = ""; $list["0"]["TransOutLines"][0]["TransOutBins"][0]['StoreUOMQty'] = 1; $list = json_encode($list); return $list; } public function get_cpdc($data)//成品仓调出到其它外贸仓 { $time = time(); if($time > 1717171200 && $time < 1717257599) { $time = time()-24*3600; } $list["0"]["OtherID"] = $data['number']; $list["0"]["TransOutDocType_Code"] = 'TransOut002'; $list["0"]["BusinessDate"] = date('Y-m-d',$time); $list["0"]["TransferDirection"] = 0; $list["0"]["DescFlexField"] = (object)array(); $list["0"]["TransOutLines"][0]['ItemInfo']['ItemCode'] = $data['jm']; $list["0"]["TransOutLines"][0]["TransOutWh_Code"] = $data['dccbm'];//调出仓编码 $list["0"]["TransOutLines"][0]["StoreUOM_Code"] = "条"; $list["0"]["TransOutLines"][0]["StoreUOMQty"] = $data['ts']; $list["0"]["TransOutLines"][0]["StorageType"] = 4; $list["0"]["TransOutLines"][0]["LotInfo_Code"] = ""; $list["0"]["TransOutLines"][0]["TransOutOwnerOrg_Code"] = "130"; $list["0"]["TransOutLines"][0]["DescFlexField"] = (object)array(); $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInWh_Code'] = $data['drcbm'];//调入仓编码 $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StorageType'] = 4; $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInOrg_Code'] = "130"; $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransOutOwnerOrg_Code'] = "130"; $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StoreUOMQty'] = $data['ts']; $list["0"]["TransOutLines"][0]["TransOutBins"][0]['BinInfo_Code'] = ""; $list["0"]["TransOutLines"][0]["TransOutBins"][0]['StoreUOMQty'] = 1; $list = json_encode($list); $token = $this->setting->get_yytoken_130(); $url = 'http://172.31.105.167/U9C/webapi/TransferOut/Create'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return $res; } public function get_order_sh($data,$url1,$url2,$qs)//订单 提交-》审核 { if($qs == 120) { $token = $this->setting->get_yytoken_120(); } else { $token = $this->setting->get_yytoken_130(); } $list["0"]["Code"] = $data['number']; $list = json_encode($list); $url = 'http://172.31.105.167/U9C/webapi/'.$url1; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); //提交结束 审核开始 $url = 'http://172.31.105.167/U9C/webapi/'.$url2; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return $res; } public function get_wcrk_sh($data)//入库审核 { $list["0"]["DocNo"] = $data['co']; //$list["0"]["OtherID"] = $data['co']; $list = json_encode($list); $token = $this->setting->get_yytoken_120(); $url = 'http://172.31.105.167/U9C/webapi/RcvRptDoc/Approve'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return array($res,$list); } public function get_order($data)//订单 标准销售 { $shouldmoney = ($data['shouldmoney'] > 0)?sprintf("%01.2f",$data['shouldmoney']/count($data['lh'])):$data['shouldmoney']; $list["0"]["OrderBy"] = $data['yyid']; for($i=0;$isetting->get_yytoken_130(); $url = 'http://172.31.105.167/U9C/webapi/SO/Create'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return array($res,$list); } public function get_order_cs($data)//订单 标准销售 { $shouldmoney = ($data['shouldmoney'] > 0)?sprintf("%01.2f",$data['shouldmoney']/count($data['lh'])):$data['shouldmoney']; $list["0"]["OrderBy"] = $data['yyid']; for($i=0;$isetting->get_yytoken_101(); $url = 'http://172.31.105.167/U9C/webapi/Customer/Create'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return $res; } public function get_cxkc($data)//查询库存 { $list["SqlString"] = 'select distinct a.id id,a.ItemInfo_ItemID itemid,a.ItemInfo_ItemCode itemcode,a.ItemInfo_ItemName itemname,c.Code1 code,a.SysVersion sysversion,c.specs specs,d.code itemflcode,d1.name itemflname,a.LotInfo_LotCode lotcode,e.code unitcode,e1.name unitname,SUM(a.StoreMainQty) kc_qty,SUM(a.StoreQtyCU) f_qty,SUM(a.StoreQty) qty,a.CreatedOn createdon,a.ModifiedOn modifiedon,a.Wh whid,b.code whcode,b1.Name whname,a.BinInfo_Code bincode,a.BinInfo_Name binname from InvTrans_WhQoh as a left join CBO_Wh as b on a.Wh=b.id left join CBO_Wh_Trl b1 on a.Wh=b1.ID left join CBO_ItemMaster as c on a.ItemInfo_ItemCode=c.Code left join CBO_Category as d on c.MainItemCategory=d.id left join CBO_Category_Trl as d1 on c.MainItemCategory=d1.id left join Base_UOM as e on a.StoreMainUOM = e.id left join Base_UOM_Trl as e1 on a.StoreMainUOM=e1.id GROUP BY a.id,a.ItemInfo_ItemID,a.ItemInfo_ItemCode,a.ItemInfo_ItemName,c.Code1,a.SysVersion,c.specs,d.code,d1.name,a.LotInfo_LotCode,e.code,e1.name,a.CreatedOn,a.ModifiedOn,a.Wh,b.code,b1.Name,a.BinInfo_Code,a.BinInfo_Name'; $list = json_encode($list); $token = $this->setting->get_yytoken_101(); $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return $res; } public function get_cxck($data)//查询所有仓库 { $list["SqlString"] = "select a.id,a.code,c.name,a.org,b.name org_name from CBO_Wh a left join CBO_Wh_trl c on c.id=a.id left join Base_Organization_trl b on a.org=b.id"; $list = json_encode($list); $token = $this->setting->get_yytoken_101(); $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return $res; } public function get_cxrksh($data)//查询入库审核 { $list["SqlString"] = "select docno,DescFlexField_PubDescSeg4 xukai_no,DocState from Complete_RcvRptDoc where docno = '".$data."' order by CreatedOn desc"; $list = json_encode($list); $token = $this->setting->get_yytoken_101(); $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return $res; } public function _cxscdd($data) { $list["SqlString"] = "select DocNo,DescFlexField_PubDescSeg4 from MO_MO where DescFlexField_PubDescSeg4='".$data."' order by CreatedOn desc ";//查询生产订单 $list = json_encode($list); $token = $this->setting->get_yytoken_101(); $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return $res; } public function _cxxsdd($data) { $list["SqlString"] = "select DocNo,DescFlexField_PubDescSeg4 from SM_SO where DocNo='".$data."' order by CreatedOn desc ";//销售订单 $list = json_encode($list); $token = $this->setting->get_yytoken_101(); $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return $res; } public function _cxchd($data) { $list["SqlString"] = "select top 1 a.docno,b.SrcDocNo from SM_Ship a left join SM_ShipLine b on a.id=b.Ship where b.SrcDocNo='".$data."'";//出货单 $list = json_encode($list); $token = $this->setting->get_yytoken_101(); $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return $res; } public function get_cxdc($data)//查询调出 { $list["SqlString"] = "select top 50 a.docno ruku_danhao,d.DescFlexField_PubDescSeg4 erp_danhao,a.CreatedBy,a.createdon,a.DocState,b.mo,d.docno mo_no,e.docno dianchu_danhao from Complete_RcvRptDoc a left join Complete_RcvRptDocLine b on b.RcvRptDoc=a.id left join CBO_ItemMaster c on b.item=c.id left join MO_MO d on b.mo=d.id left join InvDoc_TransferOut e on e.DescFlexField_PubDescSeg4=d.DescFlexField_PubDescSeg4 where (d.DescFlexField_PubDescSeg4 = '".$data."') order by a.createdon";//and (a.createdon >'2023-12-26' and a.createdon >'2023-12-27') $list = json_encode($list); $token = $this->setting->get_yytoken_101(); $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql'; $header[] = "Content-Type: application/json"; $header[] = "Token: ".$token; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $list); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $res = curl_exec($ch); $res = json_decode($res,true); return $res; } public function _neworder($data) { $fh = $this->get_order($data); $res = $fh[0]; $fs = $fh[1]; $fh = json_encode($res); if(isset($res['Data'][0])) { if($res['Data'][0]['m_isSucess'] == 1) { sleep(1); $sh = $this->get_order_sh($data,'SO/Submit','SO/Approve',130); if($sh['Data'][0]['m_isSucess'] == 1) { return array('c'=>0,'fs'=>$fs,'fh'=>$fh);exit; } else { return array('c'=>1,'error'=>$sh['Data'][0]['m_errorMsg'],'fs'=>$fs,'fh'=>$fh);exit; } } else if ($res['Data'][0]['m_isSucess'] != 1 && stripos($res['Data'][0]['m_errorMsg'],'单号已存在') !== false) { return array('c'=>0,'fs'=>$fs,'fh'=>$fh);exit; } else { return array('c'=>1,'error'=>$res['Data'][0]['m_errorMsg'],'fs'=>$fs,'fh'=>$fh);exit; } } else { return array('c'=>1,'error'=>json_encode($res),'fs'=>$fs,'fh'=>$fh);exit; } } public function _peihuo($data,$kh,$number,$num,$djlx = 1000) { if(stripos($data['features'],'-126-') !== false) { $drck = '12003';//进入发条库 } else if(stripos($data['features'],'-127-') !== false) { $drck = '12004';//进入发块库 } else { $drck = '12006';//其它进入完成库 } $error = '';$scid = ''; $lh = $this->get_cjlp(array('jm'=>$data['jm'],'title'=>$data['title'],'zh'=>$data['pm'],'bm'=>$data['bm'])); if(isset($lh['Data'][0])) { if($lh['Data'][0]['m_isSucess'] != 1) { if($lh['Data'][0]['m_errorMsg'] != '料号 已存在,请重新输入!') { $lc = 1; $error .= $lh['Data'][0]['m_errorMsg'].';料号:'.$data['jm'].'编码:'.$data['bm']; } } } else { $lc = 1; $error .= json_encode($lh); } if($error != '') { return array('c'=>1,'lc'=>1,'error'=>$error,'number'=>$data['number']);exit; } if($data['type'] == 0) { $sc = $this->apiyy->get_sc(array('sku'=>$data['jm'],'title'=>$data['title'],'ts'=>$num,'yyid'=>$kh,'number'=>$number,'shipremarks'=>$data['shipremarks'],'djlx'=>$djlx,'time'=>time(),'drck'=>$drck)); if(isset($sc['Data'][0])) { if($sc['Data'][0]['m_isSucess'] != 1) { $lc = 2; $error .= $sc['Data'][0]['m_errorMsg']; } else { $scid .= $sc['Data'][0]['m_iD'].'~'.$sc['Data'][0]['m_code'].'~'.$drck; } } else { $lc = 2; $error .= json_encode($sc); } } else { $sc = $this->apiyy->get_cg(array('orderinfo'=>$number,'purchase'=>$data['purchase'],'sku'=>$data['jm'],'ts'=>$num)); if(isset($sc['Data'][0])) { if($sc['Data'][0]['IsSucess'] != 1) { $lc = 2; $error .= $sc['Data'][0]['ErrorMsg'].' - '.$data['jm']; } else { $scid .= $sc['Data'][0]['ID'].'~'.$sc['Data'][0]['Code']."~13001"; } } else { $lc = 2; $error .= json_encode($sc); } } if($error != '') { return array('c'=>1,'lc'=>$lc,'error'=>$error,'number'=>$data['number']);exit; } return array('c'=>0,'scid'=>$scid);exit; } public function _newrk($data) { $log = ''; $dbapi = 0;$error = '';$scid = $data['scid']; $orderinfo = $data['number']; if($data['dbapi'] == 1 || $data['dbapi'] == 0) { $xydc = array(); $sc = explode('~',$data['scid']); $data['rkid'] = $sc[0]; $data['rkcode'] = $sc[1]; $wcrk = $this->get_cprk($data); $log .= $orderinfo.'-RK-F = '.$wcrk[1].'\n';//入库发送日志 $log .= $orderinfo.'-RK-J = '.json_encode($wcrk[0]).'\n';//入库接收 $wcrk = $wcrk[0]; if(isset($wcrk['Data'][0])) { if($wcrk['Data'][0]['m_isSucess'] != 1) { $dbapi = 1; $error .= $wcrk['Data'][0]['m_errorMsg'].';完成入库'; } else { $scid .= '~'.$wcrk['Data'][0]['m_code']; $data['co'] = $wcrk['Data'][0]['m_code']; sleep(1); $sh = $this->get_wcrk_sh($data); $log .= $orderinfo.'-SH-F = '.$sh[1].'\n';//审核发送日志 $log .= $orderinfo.'-SH-J = '.json_encode($sh[0]).'\n';//审核接收 $sh = $sh[0]; if($sh['Data'][0]['m_isSucess'] != 1) { $cxsh = $this->get_cxrksh($data['co']); if(isset($cxsh['Data'][0]['docstate'])) { if($cxsh['Data'][0]['docstate'] != 2) { $dbapi = 1; $error .= $data['co'].' - '.$sh['Data'][0]['m_errorMsg'].';完成审核'; } } else { $dbapi = 1; $error .= $data['co'].' - '.$sh['Data'][0]['m_errorMsg'].';完成审核'; } } } } else { $dbapi = 1; $error .= json_encode($wcrk); } } if($error != '') { $this->_log($orderinfo,$log); return array('c'=>1,'dbapi'=>$dbapi,'scid'=>$scid,'error'=>$error);exit; } if($data['dbapi'] == 2) { $sc = explode('~',$scid); $sc = array_reverse($sc); $rkd = ''; foreach ($sc as $v) { if(stripos($v,'CPRK-') !== false) { $rkd = $v; continue; } } if($rkd == '') { $dbapi = 2; $error .= 'ERP未找到入库单;完成审核'; } else { $data['co'] = $rkd; $sh = $this->get_wcrk_sh($data); $log .= $orderinfo.'-SH-F = '.$sh[1].'\n';//审核发送日志 $log .= $orderinfo.'-SH-J = '.json_encode($sh[0]).'\n';//审核接收 $sh = $sh[0]; if($sh['Data'][0]['m_isSucess'] != 1) { $cxsh = $this->get_cxrksh($data['co']); if(isset($cxsh['Data'][0]['docstate'])) { if($cxsh['Data'][0]['docstate'] != 2) { $dbapi = 2; $error .= $data['co'].' - '.$sh['Data'][0]['m_errorMsg'].';完成审核'; } } else { $dbapi = 2; $error .= $data['co'].' - '.$sh['Data'][0]['m_errorMsg'].';完成审核'; } } } } if($error != '') { $this->_log($orderinfo,$log); return array('c'=>1,'dbapi'=>$dbapi,'scid'=>$scid,'error'=>$error);exit; } $sc = explode('~',$scid); $data['scid'] = $sc[0]; $data['sccode'] = $sc[1]; $data['drck'] = $sc[2]; $dc = $this->get_dc($data); $log .= $orderinfo.'-DC-F = '.$dc[1].'\n';//审核发送日志 $log .= $orderinfo.'-DC-J = '.json_encode($dc[0]).'\n';//审核接收 $dc = $dc[0]; if(isset($dc['Data'][0])) { if($dc['Data'][0]['IsSucess'] != 1) { $dbapi = 3; $error .= $dc['Data'][0]['ErrorMsg'].';调出'; } else { $scid .= '~'.$dc['Data'][0]['Code']; } } else { $dbapi = 3; $error .= json_encode($dc); } if($error != '') { $this->_log($orderinfo,$log); return array('c'=>1,'dbapi'=>$dbapi,'scid'=>$scid,'error'=>$error);exit; } $cxdc = $this->get_cxdc($data['number']); if(!isset($cxdc['Data'][0])) { return array('c'=>1,'dbapi'=>$dbapi,'scid'=>$scid,'error'=>$data['number'].'调出验证未通过');exit; } $this->_log($orderinfo,$log); return array('c'=>0,'scid'=>$scid);exit; } public function _log($orderinfo,$data) { $pdtime = date('Y-m-d',time()); $folderPath = './data/yylog/'.$pdtime; // 文件夹路径 $permissions = 0777; // 权限设置 file_exists($folderPath); if(!is_file("./data/yylog/".$orderinfo.".txt")) { $myfile = fopen("./data/yylog/RK-".$orderinfo.".txt", "w") or die("Unable to open file!"); fwrite($myfile, $data); fclose($myfile); } else { $myfile = fopen("./data/yylog/RK-".$orderinfo.".txt", "a+") or die("Unable to open file!"); fwrite($myfile, $data); fclose($myfile); } } }