Pereiti prie turinio

XML išgliaudymas

BigBug

Sukūrė BigBug
Programuotojų kampas

 Dalintis Sekėjai 0

Rekomenduojami pranešimai

BigBug

BigBug 202

Sukurta
Sukurta

XML failas atrodo taip:

 

<?xml version="1.0" encoding="UTF-8"?>
<GetOrdersResponse xmlns="urn:ebay:apis:eBLBaseComponents">
 <Timestamp>2013-08-29T09:38:22.868Z</Timestamp>
 <Ack>Success</Ack>
 <Version>837</Version>
 <Build>E837_CORE_APIXO_16317239_R1</Build>
 <PaginationResult>
   <TotalNumberOfPages>1</TotalNumberOfPages>
   <TotalNumberOfEntries>1</TotalNumberOfEntries>
 </PaginationResult>
 <HasMoreOrders>false</HasMoreOrders>
 <OrderArray>
   <Order>
     <OrderID>001</OrderID>
     <OrderStatus>Completed</OrderStatus>
     <AdjustmentAmount currencyID="USD">0.0</AdjustmentAmount>
     <AmountPaid currencyID="USD">79.97</AmountPaid>
     <AmountSaved currencyID="USD">0.0</AmountSaved>
     <CheckoutStatus>
       <eBayPaymentStatus>NoPaymentFailure</eBayPaymentStatus>
       <LastModifiedTime>2013-08-28T23:27:21.000Z</LastModifiedTime>
       <PaymentMethod>PayPal</PaymentMethod>
       <Status>Complete</Status>
       <IntegratedMerchantCreditCardEnabled>false</IntegratedMerchantCreditCardEnabled>
     </CheckoutStatus>
     <ShippingDetails>
       <SalesTax>
         <SalesTaxPercent>0.0</SalesTaxPercent>
         <SalesTaxState>
         </SalesTaxState>
         <ShippingIncludedInTax>false</ShippingIncludedInTax>
         <SalesTaxAmount currencyID="USD">0.0</SalesTaxAmount>
       </SalesTax>
       <InternationalShippingServiceOption>
         <ShippingService>StandardInternational</ShippingService>
         <ShippingServiceCostcurrencyID="USD">5.99</ShippingServiceCost>
         <ShippingServicePriority>1</ShippingServicePriority>
         <ShipToLocation>Worldwide</ShipToLocation>
       </InternationalShippingServiceOption>
       <SellingManagerSalesRecordNumber>131</SellingManagerSalesRecordNumber>
       <GetItFast>false</GetItFast>
     </ShippingDetails>
     <CreatingUserRole>Seller</CreatingUserRole>
     <CreatedTime>2013-08-28T07:24:15.000Z</CreatedTime>
     <PaymentMethods>PayPal</PaymentMethods>
     <SellerEmail>[email protected]</SellerEmail>
     <ShippingAddress>
       <Name>Name1</Name>
       <Street1>Street1</Street1>
       <Street2> Street2</Street2>
       <CityName> CityName </CityName>
       <StateOrProvince> StateOrProvince </StateOrProvince>
       <Country> Country </Country>
       <CountryName> CountryName </CountryName>
       <Phone>9999</Phone>
       <PostalCode>99</PostalCode>
       <AddressID>123</AddressID>
       <AddressOwner>eBay</AddressOwner>
       <ExternalAddressID>
       </ExternalAddressID>
     </ShippingAddress>
     <ShippingServiceSelected>
       <ShippingService>StandardInternational</ShippingService>
       <ShippingServiceCostcurrencyID="USD">5.99</ShippingServiceCost>
     </ShippingServiceSelected>
     <Subtotal currencyID="USD">73.98</Subtotal>
     <Total currencyID="USD">79.97</Total>
     <TransactionArray>
       <Transaction>
         <Buyer>
           <Email>[email protected]</Email>
         </Buyer>
         <ShippingDetails>
           <SellingManagerSalesRecordNumber>127</SellingManagerSalesRecordNumber>
         </ShippingDetails>
         <CreatedDate>2013-08-28T00:56:29.000Z</CreatedDate>
         <Item>
           <ItemID>1111</ItemID>
           <Site>US</Site>
           <Title>Title</Title>
           <ConditionID>1500</ConditionID>
           <ConditionDisplayName>New without tags</ConditionDisplayName>
         </Item>
         <QuantityPurchased>1</QuantityPurchased>
         <Status>
           <PaymentHoldStatus>PaymentHold</PaymentHoldStatus>
         </Status>
         <TransactionID>11111</TransactionID>
         <TransactionPricecurrencyID="USD">48.99</TransactionPrice>
         <TransactionSiteID>US</TransactionSiteID>
         <Platform>eBay</Platform>
         <Taxes>
           <TotalTaxAmount currencyID="USD">0.0</TotalTaxAmount>
           <TaxDetails>
             <Imposition>SalesTax</Imposition>
             <TaxDescription>SalesTax</TaxDescription>
             <TaxAmount currencyID="USD">0.0</TaxAmount>
             <TaxOnSubtotalAmountcurrencyID="USD">0.0</TaxOnSubtotalAmount>
             <TaxOnShippingAmountcurrencyID="USD">0.0</TaxOnShippingAmount>
             <TaxOnHandlingAmountcurrencyID="USD">0.0</TaxOnHandlingAmount>
           </TaxDetails>
           <TaxDetails>
             <Imposition>WasteRecyclingFee</Imposition>
             <TaxDescription>ElectronicWasteRecyclingFee</TaxDescription>
             <TaxAmount currencyID="USD">0.0</TaxAmount>
           </TaxDetails>
         </Taxes>
         <ActualShippingCostcurrencyID="USD">0.0</ActualShippingCost>
         <ActualHandlingCostcurrencyID="USD">0.0</ActualHandlingCost>
         <OrderLineItemID>111150228853-1074937731001</OrderLineItemID>
         <InvoiceSentTime>2013-08-28T07:24:16.000Z</InvoiceSentTime>
       </Transaction>
       <Transaction>
         <Buyer>
           <Email>[email protected]</Email>
         </Buyer>
         <ShippingDetails>
           <SellingManagerSalesRecordNumber>128</SellingManagerSalesRecordNumber>
         </ShippingDetails>
         <CreatedDate>2013-08-28T00:56:54.000Z</CreatedDate>
         <Item>
           <ItemID>1111</ItemID>
           <Site>US</Site>
           <Title>title</Title>
           <ConditionID>1500</ConditionID>
           <ConditionDisplayName>New without tags</ConditionDisplayName>
         </Item>
         <QuantityPurchased>1</QuantityPurchased>
         <Status>
           <PaymentHoldStatus>PaymentHold</PaymentHoldStatus>
         </Status>
         <TransactionID>111111</TransactionID>
         <TransactionPricecurrencyID="USD">24.99</TransactionPrice>
         <TransactionSiteID>US</TransactionSiteID>
         <Platform>eBay</Platform>
         <Taxes>
           <TotalTaxAmount currencyID="USD">0.0</TotalTaxAmount>
           <TaxDetails>
             <Imposition>SalesTax</Imposition>
             <TaxDescription>SalesTax</TaxDescription>
             <TaxAmount currencyID="USD">0.0</TaxAmount>
             <TaxOnSubtotalAmountcurrencyID="USD">0.0</TaxOnSubtotalAmount>
             <TaxOnShippingAmountcurrencyID="USD">0.0</TaxOnShippingAmount>
             <TaxOnHandlingAmountcurrencyID="USD">0.0</TaxOnHandlingAmount>
           </TaxDetails>
           <TaxDetails>
             <Imposition>WasteRecyclingFee</Imposition>
             <TaxDescription>ElectronicWasteRecyclingFee</TaxDescription>
             <TaxAmount currencyID="USD">0.0</TaxAmount>
           </TaxDetails>
         </Taxes>
         <ActualShippingCostcurrencyID="USD">0.0</ActualShippingCost>
         <ActualHandlingCostcurrencyID="USD">0.0</ActualHandlingCost>
         <OrderLineItemID>111150229859-1074937844001</OrderLineItemID>
         <InvoiceSentTime>2013-08-28T07:24:16.000Z</InvoiceSentTime>
       </Transaction>
     </TransactionArray>
     <BuyerUserID>buyer</BuyerUserID>
     <PaidTime>2013-08-28T23:25:12.000Z</PaidTime>
     <IntegratedMerchantCreditCardEnabled>false</IntegratedMerchantCreditCardEnabled>
     <EIASToken>aaaaaa</EIASToken>
     <PaymentHoldStatus>PaymentHold</PaymentHoldStatus>
     <PaymentHoldDetails>
       <ExpectedReleaseDate>2013-09-18T07:00:00.000Z</ExpectedReleaseDate>
       <RequiredSellerActionArray>
         <RequiredSellerAction>MarkAsShipped</RequiredSellerAction>
       </RequiredSellerActionArray>
       <NumOfReqSellerActions>1</NumOfReqSellerActions>
     </PaymentHoldDetails>
     <IsMultiLegShipping>false</IsMultiLegShipping>
     <OrderAck>false</OrderAck>
   </Order>
 </OrderArray>
 <OrdersPerPage>100</OrdersPerPage>
 <PageNumber>1</PageNumber>
 <ReturnedOrderCountActual>1</ReturnedOrderCountActual>
</GetOrdersResponse>

 

Mano kodas atrodo taip:

$dataXML = new SimpleXMLElement($response);
foreach ( $dataXML->OrderArray as $XML ) {
$OrderID = $XML->Order->OrderID;
$AmountPaid = $XML->Order->AmountPaid;
$ShippingServiceCost = $XML->Order->ShippingServiceCost;
$CreatedTime = $XML->Order->CreatedTime;
$Name = $XML->Order->ShippingAddress->Name;
$Street1 = $XML->Order->ShippingAddress->Street1;
$Street2 = $XML->Order->ShippingAddress->Street2;
$CityName = $XML->Order->ShippingAddress->CityName;
$StateOrProvince = $XML->Order->ShippingAddress->StateOrProvince;
$Country = $XML->Order->ShippingAddress->Country;
$CountryName = $XML->Order->ShippingAddress->CountryName;
$Phone = $XML->Order->ShippingAddress->Phone;
$PostalCode = $XML->Order->ShippingAddress->PostalCode;
$ShippingServiceCost = $XML->Order->ShippingServiceSelected->ShippingServiceCost;




	$sk = count($dataXML->OrderArray->Order->TransactionArray->Transaction);
	echo $sk;
	while ($sk != 0) {
	   $sk--;

	$Email = $dataXML->OrderArray->Order->TransactionArray->Transaction[$sk]->Buyer->Email;
	$ItemID = $dataXML->OrderArray->Order->TransactionArray->Transaction[$sk]->Item->ItemID;
	$TransactionID = $dataXML->OrderArray->Order->TransactionArray->Transaction[$sk]->TransactionID;
	$TransactionPrice = $dataXML->OrderArray->Order->TransactionArray->Transaction[$sk]->TransactionPrice;

	}

	$BuyerUserID = $XML->Order->BuyerUserID;
}

 

KAip geriausiai išgliaudyti duotą XML failą ? Mano duotas kodo fragmentas pritaikytas, kai bus vienas orderis ir gali būti nupirktos kelios prekės.

 

Bet man nepatinka, tas count() gavimas ir poto while() ciklas. Manau, būtų galima padaryti geriau, bet po kolkas nieko geriau ir neišmislyjau.

 

 

Ideas are welcome :)

Nuoroda į pranešimą
Dalintis kituose puslapiuose
apieviska

apieviska 551

Atrašyta
Atrašyta (redaguota)

Nelabai supratau ko tau reikia, bet palei koda speju kazkas tokio:

 

$transactions = $dataXML->OrderArray->Order->TransactionArray->Transaction;
$parsed_transactions = array();

foreach ($transactions as $transaction) {
$parsed_transactions[] = array(
	'email' => (string) $transaction->Buyer->Email,
	'item_id' => (string) $transaction->Item->ItemID,
	'transaction_id' => (string) $transaction->TransactionID,
	'transaction_price' => (string) $transaction->TransactionPrice
	;
);
}

Redagavo apieviska
Nuoroda į pranešimą
Dalintis kituose puslapiuose

Prisijunkite prie diskusijos

Jūs galite rašyti dabar, o registruotis vėliau. Jeigu turite paskyrą, prisijunkite dabar, kad rašytumėte iš savo paskyros.

Svečias
Parašykite atsakymą...

×   Įdėta kaip raiškusis tekstas.   Atkurti formatavimą

  Only 75 emoji are allowed.

×   Nuorodos turinys įdėtas automatiškai.   Rodyti kaip įprastą nuorodą

×   Jūsų anksčiau įrašytas turinys buvo atkurtas.   Išvalyti redaktorių

×   You cannot paste images directly. Upload or insert images from URL.

Įkraunama...
×
 Dalintis
Sekėjai 0
Eiti į temų sąrašą

  • Dabar naršo   0 narių

    Nei vienas registruotas narys šiuo metu nežiūri šio puslapio.

  • Prisijunk prie bendruomenės dabar!

    Uždarbis.lt nariai domisi verslo, IT ir asmeninio tobulėjimo temomis, kartu sprendžia problemas, dalinasi žiniomis ir idėjomis, sutinka būsimus verslo partnerius ir dalyvauja gyvuose susitikimuose.

    Užsiregistruok dabar ir galėsi:

    ✔️ Dalyvauti diskusijose;

    ✔️ Kurti naujas temas;

    ✔️ Rašyti atsakymus;

    ✔️ Vertinti kitų žmonių pranešimus;

    ✔️ Susisiekti su bet kuriuo nariu asmeniškai;

    ✔️ Naudotis tamsia dizaino versija;

    ir dar daugiau.

    Registracija trunka ~30 sek. ir yra visiškai nemokama.

  • Naujausios temos

  • Karštos temos

×
×
  • Pasirinkite naujai kuriamo turinio tipą...