PHP DBUtils::buildInsert方法代码示例

    /**
     * save data in plenty_countries_of_delivery
     * 
     * @param PlentySoapObject_GetCountriesOfDelivery $countryOfDelivery
     */
    private function saveInDatabase($countryOfDelivery)
    {
        $query = 'REPLACE INTO `plenty_countries_of_delivery` 
						' . DBUtils::buildInsert(array('country_id' => $countryOfDelivery->CountryID, 'active' => $countryOfDelivery->CountryActive, 'country_name' => $countryOfDelivery->CountryName, 'iso_code_2' => $countryOfDelivery->CountryISO2));
        $this->getLogger()->debug(__FUNCTION__ . ' save country ' . $countryOfDelivery->CountryISO2 . ' ' . $countryOfDelivery->CountryName);
        DBQuery::getInstance()->replace($query);
    }

 /**
  * save new token to db or file
  * 
  * @param string $soapUser
  * @param string $soapToken
  * @param string $soapUserId
  */
 public function saveToken($soapUser, $soapToken, $soapUserId)
 {
     if (self::SAVE_TOKEN_IN_DB === true) {
         $query = 'REPLACE INTO `plenty_soap_token` ' . DBUtils::buildInsert(array('soap_token_user' => $soapUser, 'soap_token_inserted' => 'NOW()', 'soap_token' => $soapToken, 'soap_token_user_id' => $soapUserId), array('soap_token_inserted'));
         $this->getLogger()->debug(__FUNCTION__ . ' save new token ' . $query);
         DBQuery::getInstance()->replace($query);
     } else {
         $token = array();
         if (is_file($this->dest)) {
             require $this->dest;
         }
         $token[$soapUser] = array('inserted' => strtotime('today'), 'usertoken' => $soapToken, 'userId' => $soapUserId);
         $content = '<?php' . chr(10) . chr(10);
         $content .= '// generated ' . date('r') . chr(10) . chr(10);
         $content .= '$token = ' . var_export($token, true) . ';' . chr(10);
         $content .= '?>' . chr(10);
         file_put_contents($this->dest, $content);
     }
 }

 /**
  * Save the data in the database
  * 
  * @param PlentySoapObject_SearchOrders $Item
  */
 private function saveInDatabase($Item)
 {
     $query = 'REPLACE INTO `plenty_OrderHead` ' . DBUtils::buildInsert(array('OrderID' => $Item->OrderHead->OrderID, 'Currency' => $Item->OrderHead->Currency, 'CustomerID' => $Item->OrderHead->CustomerID, 'CustomerReference' => $Item->OrderHead->CustomerReference, 'DeliveryAddressID' => $Item->OrderHead->DeliveryAddressID, 'DoneTimestamp' => $Item->OrderHead->DoneTimestamp, 'DunningLevel' => $Item->OrderHead->DunningLevel, 'EbaySellerAccount' => $Item->OrderHead->EbaySellerAccount, 'EstimatedTimeOfShipment' => $Item->OrderHead->EstimatedTimeOfShipment, 'ExchangeRatio' => $Item->OrderHead->ExchangeRatio, 'ExternalOrderID' => $Item->OrderHead->ExternalOrderID, 'Invoice' => $Item->OrderHead->Invoice, 'IsNetto' => $Item->OrderHead->IsNetto, 'LastUpdate' => $Item->OrderHead->LastUpdate, 'MethodOfPaymentID' => $Item->OrderHead->MethodOfPaymentID, 'OrderStatus' => $Item->OrderHead->OrderStatus, 'OrderTimestamp' => $Item->OrderHead->OrderTimestamp, 'OrderType' => $Item->OrderHead->OrderType, 'PackageNumber' => $Item->OrderHead->PackageNumber, 'PaidTimestamp' => $Item->OrderHead->PaidTimestamp, 'ParentOrderID' => $Item->OrderHead->ParentOrderID, 'PaymentStatus' => $Item->OrderHead->PaymentStatus, 'ReferrerID' => $Item->OrderHead->ReferrerID, 'RemoteIP' => $Item->OrderHead->RemoteIP, 'ResponsibleID' => $Item->OrderHead->ResponsibleID, 'SalesAgentID' => $Item->OrderHead->SalesAgentID, 'SellerAccount' => $Item->OrderHead->SellerAccount, 'ShippingCosts' => $Item->OrderHead->ShippingCosts, 'ShippingID' => $Item->OrderHead->ShippingID, 'ShippingMethodID' => $Item->OrderHead->ShippingMethodID, 'ShippingProfileID' => $Item->OrderHead->ShippingProfileID, 'StoreID' => $Item->OrderHead->StoreID, 'TotalBrutto' => $Item->OrderHead->TotalBrutto, 'TotalInvoice' => $Item->OrderHead->TotalInvoice, 'TotalNetto' => $Item->OrderHead->TotalNetto, 'TotalVAT' => $Item->OrderHead->TotalVAT, 'WarehouseID' => $Item->OrderHead->WarehouseID));
     $this->getLogger()->debug(__FUNCTION__ . ' ' . $query);
     DBQuery::getInstance()->replace($query);
     if (isset($Item->OrderHead->IncomingPayments)) {
         foreach ($Item->OrderHead->IncomingPayments->item as $ItemIncomingPayments) {
             $query = 'REPLACE INTO `plenty_OrderHead_IncomingPayments` ' . DBUtils::buildInsert(array('ID' => $ItemIncomingPayments->ID, 'ReferenceID' => $ItemIncomingPayments->ReferenceID, 'OrderID' => $Item->OrderHead->OrderID));
             $this->getLogger()->debug(__FUNCTION__ . ' ' . $query);
             DBQuery::getInstance()->replace($query);
         }
     }
     if (isset($Item->OrderHead->IncomingPayments)) {
         foreach ($Item->OrderHead->IncomingPayments->item as $ItemIncomingPayments) {
             $query = 'REPLACE INTO `plenty_OrderHead_IncomingPayments` ' . DBUtils::buildInsert(array('ID' => $ItemIncomingPayments->ID, 'ReferenceID' => $ItemIncomingPayments->ReferenceID, 'OrderID' => $Item->OrderHead->OrderID));
             $this->getLogger()->debug(__FUNCTION__ . ' ' . $query);
             DBQuery::getInstance()->replace($query);
         }
     }
 }

 /**
  * Save the data in the database
  *
  * @param PlentySoapObject_GetMethodOfPayments $methodOfPayment
  */
 private function saveInDatabase($methodOfPayment)
 {
     $activeCountriesOfDelivery = array();
     $activeMultishops = array();
     /*
      * parse all active countries of delivery in a string
      */
     if (is_array($methodOfPayment->ActiveCountriesOfDelivery->item)) {
         foreach ($methodOfPayment->ActiveCountriesOfDelivery->item as $countryOfDelivery) {
             $activeCountriesOfDelivery[] = $countryOfDelivery->intValue;
         }
     } elseif (is_object($methodOfPayment->ActiveCountriesOfDelivery->item)) {
         $activeCountriesOfDelivery[] = $methodOfPayment->ActiveCountriesOfDelivery->item->intValue;
     }
     /*
      * parse all active multishops in a string
      */
     if (is_array($methodOfPayment->Multishops->item)) {
         foreach ($methodOfPayment->ActiveCountriesOfDelivery->item as $multishops) {
             $activeMultishops[] = $multishops->intValue;
         }
     } elseif (is_object($methodOfPayment->Multishops->item)) {
         $activeMultishops[] = $methodOfPayment->Multishops->item->intValue;
     }
     $query = 'REPLACE INTO `plenty_method_of_payments` ' . DBUtils::buildInsert(array('method_of_payment_id' => $methodOfPayment->MethodOfPaymentID, 'method_of_payment_name' => $methodOfPayment->Name, 'active_countries' => implode(',', $activeCountriesOfDelivery), 'active_multishops' => implode(',', $activeMultishops)));
     $this->getLogger()->debug(__FUNCTION__ . ' new MOP ' . $methodOfPayment->MethodOfPaymentID . ' ' . $methodOfPayment->Name);
     DBQuery::getInstance()->replace($query);
 }

 /**
  * save the data in plenty_vat_config
  * 
  * @param PlentySoapObject_GetVatConfig $vatConfig
  * @param integer $countryId
  */
 private function saveInDatabase($vatConfig, $countryId)
 {
     $query = 'REPLACE INTO `plenty_vat_config` ' . DBUtils::buildInsert(array('country_id' => $countryId, 'vat_id' => $vatConfig->InternalVATID, 'vat_value' => $vatConfig->VATValue));
     $this->getLogger()->debug(__FUNCTION__ . ' save VAT config id:' . $vatConfig->InternalVATID . ' countryId:' . $countryId . ' ' . $vatConfig->VATValue . '%');
     DBQuery::getInstance()->replace($query);
 }

 /**
  * Save the data in the database
  *
  * @param PlentySoapObject_GetWarehouseList $warehouse
  */
 private function saveInDatabase($warehouse)
 {
     $query = 'REPLACE INTO `plenty_warehouse` ' . DBUtils::buildInsert(array('warehouse_id' => $warehouse->WarehouseID, 'warehouse_type' => $warehouse->Type, 'warehouse_name' => $warehouse->Name));
     $this->getLogger()->debug(__FUNCTION__ . ' ' . $query);
     DBQuery::getInstance()->replace($query);
 }

 /**
  * Save the data in plenty_order_status
  *
  * @param PlentySoapObject_GetOrderStatus $orderStatus
  */
 private function saveInDatabase($orderStatus)
 {
     $query = 'REPLACE INTO `plenty_order_status` ' . DBUtils::buildInsert(array('order_status' => $orderStatus->OrderStatus, 'lang' => $this->lang, 'status_name' => $orderStatus->OrderStatusName));
     $this->getLogger()->debug(__FUNCTION__ . ' save status ' . $orderStatus->OrderStatus . ' ' . $orderStatus->OrderStatusName);
     DBQuery::getInstance()->replace($query);
 }

 /**
  * Save $this->currentTimestamp in plenty_stock_last_update
  *
  */
 private function saveCurrentTimestamp2DB4TheNextRetrieval()
 {
     if ($this->warehouseId > 0) {
         $query = 'REPLACE INTO plenty_stock_last_update ' . DBUtils::buildInsert(array('warehouse_id' => $this->warehouseId, 'last_update_timestamp' => $this->currentTimestamp));
         DBQuery::getInstance()->replace($query);
         $this->getLogger()->debug(__FUNCTION__ . ' ' . $query);
     }
 }