123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107 |
- <?php
- class Model_apiyy extends Lin_Model
- {
- function __construct(){
- parent::__construct();
- $this->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)//无源采购
- {
- $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)//标准收货
- {
- $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)//生产订单
- {
- $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',$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"] = 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);
- $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 $res;
- }
-
- 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)//产品入库
- {
- $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"] = '';
- $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["ActualRcvTime"] = '';
- $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"] = '';
- $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)//调出
- {
- $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]["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]["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)//成品仓调出到其它外贸仓
- {
- $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 = 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;$i<count($data['lh']);$i++)
- {
- $list["0"]["SOLineDTOList"][$i]['TU'] = '条';
- $list["0"]["SOLineDTOList"][$i]['ItemCode'] = $data['lh'][$i]['sku'];//料号
- $list["0"]["SOLineDTOList"][$i]['PU'] = '条';
- $list["0"]["SOLineDTOList"][$i]['ShipTogetherFlag'] = -1;
- $list["0"]["SOLineDTOList"][$i]['DocLineNo'] = $i+1;
- $list["0"]["SOLineDTOList"][$i]['CustomerItemNo'] = '';
- $list["0"]["SOLineDTOList"][$i]['CustomerItemName'] = '';
- $list["0"]["SOLineDTOList"][$i]['FinallyPriceTC'] = $shouldmoney;
- $list["0"]["SOLineDTOList"][$i]['PubDescSeg10'] = '';
- $list["0"]["SOLineDTOList"][$i]['SOShiplineDTOList'][0]['IsMRPRequire'] = 1;
- $list["0"]["SOLineDTOList"][$i]['SOShiplineDTOList'][0]['DemandType'] = -1;
- $list["0"]["SOLineDTOList"][$i]['SOShiplineDTOList'][0]['RequireDate'] = date('m/d/Y H:i:s',$data['dtime']);
- $list["0"]["SOLineDTOList"][$i]['RecTerm'] = '';
- $list["0"]["SOLineDTOList"][$i]['FreeType'] = ($data['shouldmoney'] < 0.01)?0:-1;
- $list["0"]["SOLineDTOList"][$i]['UsableQtyOfInv'] = 0;
- $list["0"]["SOLineDTOList"][$i]['PubDescSeg3'] = '';
- $list["0"]["SOLineDTOList"][$i]['PubDescSeg4'] = '0.00';
- $list["0"]["SOLineDTOList"][$i]['PriceList'] = '';
- $list["0"]["SOLineDTOList"][$i]['TaxMoneyTC'] = 0;
- $list["0"]["SOLineDTOList"][$i]['TotalMoneyTC'] = $data['budget'];
- $list["0"]["SOLineDTOList"][$i]['TaxSchedule'] = 'YZ05';
- $list["0"]["SOLineDTOList"][$i]['DescFlexField']['PubDescSeg3'] = '';
- $list["0"]["SOLineDTOList"][$i]['OrderByQtyTU'] = $data['lh'][$i]['ts'];//条数
- $list["0"]["SOLineDTOList"][$i]['OrderByQtyPU'] = $data['lh'][$i]['ts'];//条数
- $list["0"]["SOLineDTOList"][$i]['OrderPriceTC'] = $shouldmoney;
- $list["0"]["SOLineDTOList"][$i]['Memo'] = '321321';
- }
- $list["0"]["AC"] = 'C009';//美金
- $list["0"]["SaleDepartment"] = '02';
- $list["0"]["BusinessDate"] = date('m/d/Y H:i:s',$data['dtime']);
- $list["0"]["DocumentType"] = 'SO1';
- $list["0"]["DocNo"] = $data['number'];
- $list["0"]["TC"] = 'C009';
- $list["0"]["ShipToSite"] = '';
- $list["0"]["PubDescSeg2"] = '';
- $list["0"]["SOSrcType"] = 0;
- $list["0"]["Seller"] = '201';
- $list["0"]["ConfirmTerm"] = '';
- $list["0"]["Memo"] = '';
- $list["0"]["ShipRule"] = '';
- $list = json_encode($list);
- $token = $this->setting->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 $res;
- }
-
-
- public function get_scdd($data)//数据查询
- {
- $list["0"]["OtherID"] = '123';
- $list["0"]["Org"]["Code"] = 120;
- $list["0"]["ItemMaster"]["Code"] = '#017(Old)-BW-13*4Wig-20-200%-Medium';
- $list["0"]["DocType"]["Code"] = 1;
- $list["0"]["Department"]["Code"] = 03;
- $list["0"]["ExpandLevel"] = 0;
- $list["0"]["AlternateType"] = 0;
- $list["0"]["RoutingAlternate"] = 0;
- $list["0"]["RoutingEffeDate"] = '';
- $list["0"]["ProductQty"] = 5;
- $list["0"]["ProductUOM"]["Code"] = '条';
- $list["0"]["StartDate"] = '2023-08-15';
- $list["0"]["CompleteDate"] = '2023-08-22';
- $list["0"]["MOSourceDocType"] = 0;
- $list["0"]["OwnerOrg"]["Code"] = 120;
- $list["0"]["SCVWh"]["Code"] = 02;
- $list["0"]["IsFirmed"] = 1;
- $list["0"]["IsCapacityLimit"] = false;
- $list["0"]["Priority"] = 0;
- $list["0"]["CUD"] = 0;
- $list["0"]["BOMType"] = 0;
- $list["0"]["Description"] = '测试';
- $list["0"]["MRPQty"] = 0;
- $list["0"]["MOID"] = 0;
- $list["0"]["PBUToSBURate"] = 0;
- $list["0"]["PBUToCBURate"] = 0;
- $list = json_encode($list);
- $token = $this->setting->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 _neworder($data)
- {
- $res = $this->get_order($data);
- 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);exit;
- }
- else
- {
- return array('c'=>1,'error'=>$sh['Data'][0]['m_errorMsg']);exit;
- }
- }
- else
- {
- return array('c'=>1,'error'=>$res['Data'][0]['m_errorMsg']);exit;
- }
- }
- else
- {
- return array('c'=>1,'error'=>json_encode($res));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'];
- }
- }
- }
- 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 = (isset($data['orderinfo']))?$data['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].'<br>';//入库发送日志
- $log .= $orderinfo.'-RK-J = '.json_encode($wcrk[0]).'<br>';//入库接收
- $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].'<br>';//审核发送日志
- $log .= $orderinfo.'-SH-J = '.json_encode($sh[0]).'<br>';//审核接收
- $sh = $sh[0];
- if($sh['Data'][0]['m_isSucess'] != 1)
- {
- $dbapi = 2;
- $error .= $sh['Data'][0]['m_errorMsg'].';';
- }
- }
- }
- else
- {
- $dbapi = 1;
- $error .= json_encode($wcrk);
- }
- }
- if($error != '')
- {
- 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].'<br>';//审核发送日志
- $log .= $orderinfo.'-SH-J = '.json_encode($sh[0]).'<br>';//审核接收
- $sh = $sh[0];
- if($sh['Data'][0]['m_isSucess'] != 1)
- {
- $dbapi = 2;
- $error .= $sh['Data'][0]['m_errorMsg'].';完成审核';
- }
- }
- }
- if($error != '')
- {
- 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];
- if($data['dbapi'] == 3 || $data['dbapi'] == 0)
- {
- $dc = $this->get_dc($data);
- $log .= $orderinfo.'-DC-F = '.$dc[1].'<br>';//审核发送日志
- $log .= $orderinfo.'-DC-J = '.json_encode($dc[0]).'<br>';//审核接收
- $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 != '')
- {
- return array('c'=>1,'dbapi'=>$dbapi,'scid'=>$scid,'error'=>$error);exit;
- }
- return array('c'=>0,'scid'=>$scid);exit;
- }
-
- public function _log($orderinfo,$data)
- {
- $pdtime = date('Y-m-d',time());
- $folderPath = './data/yylog/'; // 文件夹路径
- $permissions = 0777; // 权限设置
- if (!file_exists($folderPath)) {
- mkdir($folderPath, $permissions);
- echo '文件夹创建成功!';
- } else {
- echo '文件夹已存在!';
- }
- if(is_file("./data/yylog/".$pdtime.".txt"))
- {
- $myfile = fopen("./data/yylog/".$pdtime.".txt", "r") or die("Unable to open file!");
- $bc = fread($myfile,filesize("./data/yylog/".$pdtime.".txt"));
- fclose($myfile);
- $bc = json_decode($bc,true);
- $zzt = array($bc['zzt'][0],$bc['zzt'][1]);
- }
- }
-
- }
|