/**
*
*
* @TODO Clean this up!
*/
protected static function _transformToSQLObjects($curpath, $Node, &$objects, $current = null, $extra = array())
{
if ($Node->childCount()) {
//
switch (strtolower(trim(trim($curpath) . ' ' . $Node->name()))) {
case 'accountret':
if (!isset($extra['ListID'])) {
$extra['ListID'] = $Node->getChildDataAt('AccountRet ListID');
}
if (empty($extra['FullName'])) {
$extra['FullName'] = $Node->getChildDataAt('AccountRet FullName');
}
$extra['EntityListID'] = $extra['ListID'];
$extra['EntityType'] = 'Account';
break;
case 'billingrateret':
if (!isset($extra['ListID'])) {
$extra['ListID'] = $Node->getChildDataAt('BillingRateRet ListID');
}
break;
case 'billpaymentcheckret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('BillPaymentCheckRet TxnID');
}
$extra['Txn_TxnID'] = $extra['TxnID'];
$extra['TxnType'] = 'BillPaymentCheck';
//$extra['ExchangeRate'] = $Node->getChildDataAt('BillPaymentCheckRet ExchangeRate');
//$extra['AmountInHomeCurrency'] = $Node->getChildDataAt('BillPaymentCheckRet AmountInHomeCurrency');
break;
case 'billpaymentcreditcardret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('BillPaymentCreditCardRet TxnID');
}
break;
case 'billret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('BillRet TxnID');
}
$extra['Txn_TxnID'] = $extra['TxnID'];
$extra['TxnType'] = 'Bill';
break;
case 'billret itemgrouplineret':
if (!isset($extra['ListID'])) {
$extra['TxnLineID'] = $Node->getChildDataAt('ItemGroupLineRet TxnLineID');
}
break;
case 'chargeret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('ChargeRet TxnID');
}
$extra['Txn_TxnID'] = $extra['TxnID'];
$extra['TxnType'] = 'Charge';
break;
case 'checkret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('CheckRet TxnID');
}
$extra['Txn_TxnID'] = $extra['TxnID'];
$extra['TxnType'] = 'Check';
break;
case 'checkret itemgrouplineret':
if (!isset($extra['TxnLineID'])) {
$extra['TxnLineID'] = $Node->getChildDataAt('ItemGroupLineRet TxnLineID');
}
break;
case 'companyret':
if (!isset($extra['CompanyName'])) {
$extra['CompanyName'] = $Node->getChildDataAt('CompanyRet CompanyName');
}
$extra['EntityListID'] = $extra['CompanyName'];
$extra['EntityType'] = 'Company';
break;
case 'creditcardchargeret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('CreditCardChargeRet TxnID');
}
$extra['Txn_TxnID'] = $extra['TxnID'];
$extra['TxnType'] = 'CreditCardCharge';
break;
case 'creditcardchargeret itemgrouplineret':
if (!isset($extra['TxnLineID'])) {
$extra['TxnLineID'] = $Node->getChildDataAt('ItemGroupLineRet TxnLineID');
}
break;
case 'creditcardcreditret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('CreditCardCreditRet TxnID');
}
$extra['Txn_TxnID'] = $extra['TxnID'];
$extra['TxnType'] = 'CreditCardCredit';
break;
case 'creditcardcreditret itemgrouplineret':
if (!isset($extra['TxnLineID'])) {
$extra['TxnLineID'] = $Node->getChildDataAt('ItemGroupLineRet TxnLineID');
}
break;
case 'creditmemoret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('CreditMemoRet TxnID');
}
$extra['Txn_TxnID'] = $extra['TxnID'];
$extra['TxnType'] = 'CreditMemo';
break;
case 'creditmemoret creditmemolinegroupret':
if (!isset($extra['TxnLineID'])) {
$extra['TxnLineID'] = $Node->getChildDataAt('CreditMemoLineGroupRet TxnLineID');
}
break;
case 'customerret':
if (!isset($extra['EntityListID'])) {
$extra['EntityListID'] = $Node->getChildDataAt('CustomerRet ListID');
}
$extra['EntityType'] = 'Customer';
break;
case 'dataextdefret':
if (!isset($extra['DataExtName'])) {
$extra['DataExtName'] = $Node->getChildDataAt('DataExtDefRet DataExtName');
}
if (!isset($extra['OwnerID'])) {
$extra['OwnerID'] = $Node->getChildDataAt('DataExtDefRet OwnerID');
}
break;
case 'depositret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('DepositRet TxnID');
}
$extra['Txn_TxnID'] = $extra['TxnID'];
$extra['TxnType'] = 'Deposit';
break;
case 'employeeret':
if (!isset($extra['ListID'])) {
$extra['ListID'] = $Node->getChildDataAt('EmployeeRet ListID');
}
$extra['EntityListID'] = $extra['ListID'];
$extra['EntityType'] = 'Employee';
break;
case 'estimateret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('EstimateRet TxnID');
}
$extra['Txn_TxnID'] = $extra['TxnID'];
$extra['TxnType'] = 'Estimate';
break;
case 'estimateret estimatelineret':
if (!isset($extra['Txn_TxnID'])) {
$extra['Txn_TxnID'] = $Node->getChildDataAt('EstimateLineRet TxnLineID');
}
$extra['TxnType'] = 'EstimateLine';
break;
case 'estimateret estimatelinegroupret':
if (!isset($extra['TxnLineID'])) {
$extra['TxnLineID'] = $Node->getChildDataAt('EstimateLineGroupRet TxnLineID');
}
$extra['Txn_TxnID'] = $extra['TxnLineID'];
$extra['TxnType'] = 'EstimateLineGroup';
break;
case 'estimateret estimatelinegroupret estimatelineret':
$extra['Txn_TxnID'] = $Node->getChildDataAt('EstimateLineRet TxnLineID');
$extra['TxnType'] = 'EstimateLineGroup_EstimateLine';
break;
case 'inventoryadjustmentret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('InventoryAdjustmentRet TxnID');
}
$extra['Txn_TxnID'] = $extra['TxnID'];
$extra['TxnType'] = 'InventoryAdjustment';
break;
case 'invoiceret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('InvoiceRet TxnID');
}
$extra['Txn_TxnID'] = $extra['TxnID'];
$extra['TxnType'] = 'Inventory';
break;
case 'invoiceret invoicelineret':
$extra['Txn_TxnID'] = $Node->getChildDataAt('InvoiceLineRet TxnLineID');
$extra['TxnType'] = 'InvoiceLine';
break;
case 'invoiceret invoicelinegroupret':
if (!isset($extra['TxnLineID'])) {
$extra['TxnLineID'] = $Node->getChildDataAt('InvoiceLineGroupRet TxnLineID');
}
$extra['Txn_TxnID'] = $extra['TxnLineID'];
$extra['TxnType'] = 'InvoiceLineGroup';
break;
case 'invoiceret invoicelinegroupret invoicelineret':
$extra['Txn_TxnID'] = $Node->getChildDataAt('InvoiceLineRet TxnLineID');
$extra['TxnType'] = 'InvoiceLineGroup_InvoiceLine';
break;
case 'itemgroupret':
if (!isset($extra['ListID'])) {
$extra['ListID'] = $Node->getChildDataAt('ItemGroupRet ListID');
}
$extra['EntityListID'] = $extra['ListID'];
$extra['EntityType'] = 'ItemGroup';
break;
case 'iteminventoryret':
$extra['EntityListID'] = $Node->getChildDataAt('ItemInventoryRet ListID');
$extra['EntityType'] = 'ItemInventory';
break;
case 'iteminventoryassemblyret':
if (!isset($extra['ListID'])) {
$extra['ListID'] = $Node->getChildDataAt('ItemInventoryAssemblyRet ListID');
}
$extra['EntityListID'] = $extra['ListID'];
$extra['EntityType'] = 'ItemInventoryAssembly';
break;
case 'itemnoninventoryret':
if (!isset($extra['EntityListID'])) {
$extra['EntityListID'] = $Node->getChildDataAt('ItemNonInventoryRet ListID');
}
$extra['EntityType'] = 'ItemNonInventory';
break;
case 'itemdiscountret':
if (!isset($extra['EntityListID'])) {
$extra['EntityListID'] = $Node->getChildDataAt('ItemDiscountRet ListID');
}
$extra['EntityType'] = 'ItemDiscount';
break;
case 'itemfixedassetret':
if (!isset($extra['EntityListID'])) {
$extra['EntityListID'] = $Node->getChildDataAt('ItemFixedAssetRet ListID');
}
$extra['EntityType'] = 'ItemFixedAsset';
break;
case 'itemotherchargeret':
if (!isset($extra['EntityListID'])) {
$extra['EntityListID'] = $Node->getChildDataAt('ItemOtherChargeRet ListID');
}
$extra['EntityType'] = 'ItemOtherCharge';
break;
case 'itempaymentret':
if (!isset($extra['EntityListID'])) {
$extra['EntityListID'] = $Node->getChildDataAt('ItemPaymentRet ListID');
}
$extra['EntityType'] = 'ItemPayment';
break;
case 'itemreceiptret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('ItemReceiptRet TxnID');
}
$extra['Txn_TxnID'] = $extra['TxnID'];
$extra['TxnType'] = 'ItemReceipt';
break;
case 'itemreceiptret itemreceiptlinegroupret':
if (!isset($extra['TxnLineID'])) {
$extra['TxnLineID'] = $Node->getChildDataAt('ItemReceiptLineGroupRet TxnLineID');
}
break;
case 'itemsalestaxret':
if (!isset($extra['EntityListID'])) {
$extra['EntityListID'] = $Node->getChildDataAt('ItemSalesTaxRet ListID');
}
$extra['EntityType'] = 'ItemSalesTax';
break;
case 'itemsalestaxgroupret':
if (!isset($extra['ListID'])) {
$extra['ListID'] = $Node->getChildDataAt('ItemSalesTaxGroupRet ListID');
}
$extra['EntityListID'] = $extra['ListID'];
$extra['EntityType'] = 'ItemSalesTaxGroup';
break;
case 'itemserviceret':
if (!isset($extra['EntityListID'])) {
$extra['EntityListID'] = $Node->getChildDataAt('ItemServiceRet ListID');
}
$extra['EntityType'] = 'ItemService';
break;
case 'itemsubtotalret':
if (!isset($extra['EntityListID'])) {
$extra['EntityListID'] = $Node->getChildDataAt('ItemSubtotalRet ListID');
}
$extra['EntityType'] = 'ItemSubtotal';
break;
case 'journalentryret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('JournalEntryRet TxnID');
}
$extra['Txn_TxnID'] = $extra['TxnID'];
$extra['TxnType'] = 'JournalEntry';
break;
case 'pricelevelret':
if (!isset($extra['ListID'])) {
$extra['ListID'] = $Node->getChildDataAt('PriceLevelRet ListID');
}
break;
case 'purchaseorderret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('PurchaseOrderRet TxnID');
}
$extra['Txn_TxnID'] = $extra['TxnID'];
$extra['TxnType'] = 'PurchaseOrder';
break;
case 'purchaseorderret purchaseorderlineret':
$extra['Txn_TxnID'] = $Node->getChildDataAt('PurchaseOrderLineRet TxnLineID');
$extra['TxnType'] = 'PurchaseOrderLine';
break;
case 'purchaseorderret purchaseorderlinegroupret':
if (!isset($extra['TxnLineID'])) {
$extra['TxnLineID'] = $Node->getChildDataAt('PurchaseOrderLineGroupRet TxnLineID');
}
$extra['Txn_TxnID'] = $extra['TxnLineID'];
$extra['TxnType'] = 'PurchaseOrderLineGroup';
break;
case 'purchaseorderret purchaseorderlinegroupret purchaseorderlineret':
$extra['Txn_TxnID'] = $Node->getChildDataAt('PurchaseOrderLineRet TxnLineID');
$extra['TxnType'] = 'PurchaseOrderLineGroup_PurchaseOrderLine';
break;
case 'receivepaymentret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('ReceivePaymentRet TxnID');
}
$extra['Txn_TxnID'] = $extra['TxnID'];
$extra['TxnType'] = 'ReceivePayment';
break;
case 'salesorderret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('SalesOrderRet TxnID');
}
$extra['Txn_TxnID'] = $extra['TxnID'];
$extra['TxnType'] = 'SalesOrder';
break;
case 'salesorderret salesorderlineret':
$extra['Txn_TxnID'] = $Node->getChildDataAt('SalesOrderLineRet TxnLineID');
$extra['TxnType'] = 'SalesOrderLine';
break;
case 'salesorderret salesorderlinegroupret':
$extra['TxnLineID'] = $Node->getChildDataAt('SalesOrderLineGroupRet TxnLineID');
$extra['Txn_TxnID'] = $extra['TxnLineID'];
$extra['TxnType'] = 'SalesOrderLineGroup';
break;
case 'salesorderret salesorderlinegroupret salesorderlineret':
$extra['Txn_TxnID'] = $Node->getChildDataAt('SalesOrderLineRet TxnLineID');
$extra['TxnType'] = 'SalesOrderLineGroup_SalesOrderLine';
break;
case 'salesreceiptret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('SalesReceiptRet TxnID');
}
$extra['Txn_TxnID'] = $extra['TxnID'];
$extra['TxnType'] = 'SalesReceipt';
break;
case 'salesreceiptret salesreceiptlineret':
$extra['Txn_TxnID'] = $Node->getChildDataAt('SalesReceiptLineRet TxnLineID');
$extra['TxnType'] = 'SalesReceiptLine';
break;
case 'salesreceiptret salesreceiptlinegroupret':
$extra['TxnLineID'] = $Node->getChildDataAt('SalesReceiptLineGroupRet TxnLineID');
$extra['Txn_TxnID'] = $extra['TxnLineID'];
$extra['TxnType'] = 'SalesReceiptLineGroup';
break;
case 'salesreceiptret salesreceiptlinegroupret salesreceiptlineret':
$extra['Txn_TxnID'] = $Node->getChildDataAt('SalesReceiptLineRet TxnLineID');
$extra['TxnType'] = 'SalesReceiptLineGroup_SalesReceiptLine';
break;
case 'unitofmeasuresetret':
if (!isset($extra['ListID'])) {
$extra['ListID'] = $Node->getChildDataAt('UnitOfMeasureSetRet ListID');
}
break;
case 'vendorret':
if (!isset($extra['EntityListID'])) {
$extra['EntityListID'] = $Node->getChildDataAt('VendorRet ListID');
}
$extra['EntityType'] = 'Vendor';
break;
case 'vendorcreditret':
if (!isset($extra['TxnID'])) {
$extra['TxnID'] = $Node->getChildDataAt('VendorCreditRet TxnID');
}
$extra['Txn_TxnID'] = $extra['TxnID'];
$extra['TxnType'] = 'VendorCredit';
break;
case 'vendorcreditret itemgrouplineret':
if (!isset($extra['TxnLineID'])) {
$extra['TxnLineID'] = $Node->getChildDataAt('ItemGroupLineRet TxnLineID');
}
break;
case 'workerscompcoderet':
if (!isset($extra['ListID'])) {
$extra['ListID'] = $Node->getChildDataAt('WorkersCompCodeRet ListID');
}
break;
}
foreach ($Node->children() as $Child) {
$merge = false;
$others = array();
switch ($Child->name()) {
case 'AppliedToTxnRet':
case 'BillingRatePerItemRet':
case 'CreditMemoLineRet':
case 'CreditMemoLineGroupRet':
case 'DataExtRet':
case 'AssignToObject':
case 'DefaultUnit':
case 'DepositLineRet':
case 'EstimateLineRet':
case 'EstimateLineGroupRet':
case 'ExpenseLineRet':
case 'InvoiceAdjustmentLineRet':
case 'InvoiceLineRet':
case 'InvoiceLineGroupRet':
case 'InventoryAdjustmentLineRet':
case 'ItemGroupRet':
case 'ItemGroupLine':
case 'ItemGroupLineRet':
case 'ItemInventoryAssemblyLineRet':
case 'ItemInventoryAssemblyLine':
case 'ItemLineRet':
case 'ItemSalesTaxGroupRet':
//case 'ItemSalesTaxRef':
//case 'ItemSalesTaxRef':
case 'LinkedTxn':
case 'PriceLevelPerItemRet':
case 'PurchaseOrderLineRet':
case 'PurchaseOrderLineGroupRet':
case 'RelatedUnit':
case 'SalesOrderLineRet':
case 'SalesOrderLineGroupRet':
case 'SalesReceiptLineRet':
case 'SalesReceiptLineGroupRet':
case 'Service':
case 'SubscribedServices':
case 'TaxLineInfoRet':
// * * * WARNING WARNING WARNING * * *
// The next line of code causes problems with some responses
// because it converts our associative array to turn into a
// numeric array. This causes objects to get cut into multiple
// pieces:
//
// array(
// 'account' => array( 'Name' => 'test', 'ListID' => 1234' ),
// 0 => array( account_taxlineinforet data here ),
// 1 => array( 'CashFlowClassification' => 'abc' ), // this is the other half of the Account data from the 'account' associative array key
// )
//
// Do not make a change to this code without double checking syncs
// and talking this over with Keith first please! Thanks!
//
// Previously we were using this line, but it was causing problems:
//$others = array_values($objects);
// This line of code seems to work OK
$others = $objects;
$objects = array();
$merge = true;
break;
}
QuickBooks_Server_SQL_Callbacks::_transformToSQLObjects($curpath . ' ' . $Node->name(), $Child, $objects, null, $extra);
// * * * WARNING * * *
// Please see notes above about object chunking problems which might be related to the code below
if ($merge) {
$objects = array_values($objects);
$objects = array_merge($others, $objects);
}
//
//echo '<br /> ';
//print_r($objects);
//echo '<br /><br />';
}
} else {
$map = array();
$others = array();
QuickBooks_SQL_Schema::mapToSchema(trim($curpath . ' ' . $Node->name()), QUICKBOOKS_SQL_SCHEMA_MAP_TO_SQL, $map, $others);
//Okay so if the first element is a child element that is custom mapped, it'll end up creating the object with an incorrect path.
//print('map for: {' . $curpath . ' ' . $Node->name() . "} [" . $map[0] . "]\n");
//print_r($map);
if ($map[0] and !isset($objects[$map[0]])) {
//print('creating new object: ' . $map[0] . "\n");
//print_r($objects);
$tempMap = array();
$tempOthers = array();
QuickBooks_SQL_Schema::mapToSchema(trim($curpath), QUICKBOOKS_SQL_SCHEMA_MAP_TO_SQL, $tempMap, $tempOthers);
if ($map[0] == "dataextdef_assigntoobject") {
$objects[$map[0]] = new QuickBooks_SQL_Object($map[0], trim($curpath . ' ' . $Node->name()));
} else {
$objects[$map[0]] = new QuickBooks_SQL_Object($map[0], trim($curpath));
}
// Some tables, such 'Invoice_InvoiceLine', won't have data in the SQL schema that
// directly links them back to the 'Invoice' record they're part of. Thus, we need
// to add a few schema fields, and then here we set those fields to values from the
// parent of these objects so that they get tied to the correct 'Invoice' in the
// database table 'Invoice_InvoiceLine'
$table = $objects[$map[0]]->table();
switch (strtolower($table)) {
case 'account_taxlineinfo':
$objects[$map[0]]->set('Account_ListID', $extra['ListID']);
$objects[$map[0]]->set('Account_FullName', $extra['FullName']);
break;
case 'billingrate_billingrateperitem':
$objects[$map[0]]->set('BillingRate_ListID', $extra['ListID']);
break;
case 'billpaymentcheck_appliedtotxn':
$objects[$map[0]]->set('FromTxnID', $extra['TxnID']);
break;
case 'billpaymentcreditcard_appliedtotxn':
$objects[$map[0]]->set('FromTxnID', $extra['TxnID']);
break;
case 'bill_linkedtxn':
$objects[$map[0]]->set('FromTxnID', $extra['TxnID']);
break;
case 'bill_expenseline':
$objects[$map[0]]->set('Bill_TxnID', $extra['TxnID']);
break;
case 'bill_itemline':
$objects[$map[0]]->set('Bill_TxnID', $extra['TxnID']);
break;
case 'bill_itemgroupline':
$objects[$map[0]]->set('Bill_TxnID', $extra['TxnID']);
break;
case 'bill_itemgroupline_itemline':
$objects[$map[0]]->set('Bill_TxnID', $extra['TxnID']);
$objects[$map[0]]->set('Bill_ItemGroupLine_TxnLineID', $extra['TxnLineID']);
break;
case 'check_linkedtxn':
$objects[$map[0]]->set('FromTxnID', $extra['TxnID']);
break;
case 'check_expenseline':
$objects[$map[0]]->set('Check_TxnID', $extra['TxnID']);
break;
case 'check_itemline':
$objects[$map[0]]->set('Check_TxnID', $extra['TxnID']);
break;
case 'check_itemgroupline':
$objects[$map[0]]->set('Check_TxnID', $extra['TxnID']);
break;
case 'check_itemgroupline_itemline':
$objects[$map[0]]->set('Check_TxnID', $extra['TxnID']);
$objects[$map[0]]->set('Check_ItemGroupLine_TxnLineID', $extra['TxnLineID']);
break;
case 'company_subscribedservices_service':
$objects[$map[0]]->set('Company_CompanyName', $extra['CompanyName']);
break;
case 'creditcardcharge_expenseline':
$objects[$map[0]]->set('CreditCardCharge_TxnID', $extra['TxnID']);
break;
case 'creditcardcharge_itemline':
$objects[$map[0]]->set('CreditCardCharge_TxnID', $extra['TxnID']);
break;
case 'creditcardcharge_itemgroupline':
$objects[$map[0]]->set('CreditCardCharge_TxnID', $extra['TxnID']);
break;
case 'creditcardcharge_itemgroupline_itemline':
$objects[$map[0]]->set('CreditCardCharge_TxnID', $extra['TxnID']);
$objects[$map[0]]->set('CreditCardCharge_ItemGroupLine_TxnLineID', $extra['TxnLineID']);
break;
case 'creditcardcredit_expenseline':
$objects[$map[0]]->set('CreditCardCredit_TxnID', $extra['TxnID']);
break;
case 'creditcardcredit_itemline':
$objects[$map[0]]->set('CreditCardCredit_TxnID', $extra['TxnID']);
break;
case 'creditcardcredit_itemgroupline':
$objects[$map[0]]->set('CreditCardCredit_TxnID', $extra['TxnID']);
break;
case 'creditcardcredit_itemgroupline_itemline':
$objects[$map[0]]->set('CreditCardCredit_TxnID', $extra['TxnID']);
$objects[$map[0]]->set('CreditCardCredit_ItemGroupLine_TxnLineID', $extra['TxnLineID']);
break;
case 'creditmemo_linkedtxn':
$objects[$map[0]]->set('FromTxnID', $extra['TxnID']);
break;
case 'creditmemo_creditmemoline':
$objects[$map[0]]->set('CreditMemo_TxnID', $extra['TxnID']);
break;
case 'creditmemo_creditmemolinegroup':
$objects[$map[0]]->set('CreditMemo_TxnID', $extra['TxnID']);
break;
case 'creditmemo_creditmemolinegroup_creditmemoline':
$objects[$map[0]]->set('CreditMemo_TxnID', $extra['TxnID']);
$objects[$map[0]]->set('CreditMemo_CreditMemoLineGroup_TxnLineID', $extra['TxnLineID']);
break;
case 'dataext':
if (!empty($extra['EntityType'])) {
$objects[$map[0]]->set('EntityType', $extra['EntityType']);
$objects[$map[0]]->set('Entity_ListID', $extra['EntityListID']);
} else {
$objects[$map[0]]->set('TxnType', $extra['TxnType']);
$objects[$map[0]]->set('Txn_TxnID', $extra['Txn_TxnID']);
}
break;
case 'dataextdef_assigntoobject':
if (!empty($extra['DataExtName'])) {
$objects[$map[0]]->set('DataExtDef_DataExtName', $extra['DataExtName']);
}
if (!empty($extra['OwnerID']) || isset($extra['OwnerID']) && $extra['OwnerID'] == 0) {
$objects[$map[0]]->set('DataExtDef_OwnerID', $extra['OwnerID']);
}
break;
case 'deposit_depositline':
$objects[$map[0]]->set('Deposit_TxnID', $extra['TxnID']);
break;
case 'employee_earnings':
$objects[$map[0]]->set('Employee_ListID', $extra['ListID']);
break;
case 'estimate_linkedtxn':
$objects[$map[0]]->set('FromTxnID', $extra['TxnID']);
break;
case 'estimate_estimateline':
$objects[$map[0]]->set('Estimate_TxnID', $extra['TxnID']);
break;
case 'estimate_estimatelinegroup':
$objects[$map[0]]->set('Estimate_TxnID', $extra['TxnID']);
break;
case 'estimate_estimatelinegroup_estimateline':
$objects[$map[0]]->set('Estimate_TxnID', $extra['TxnID']);
$objects[$map[0]]->set('Estimate_EstimateLineGroup_TxnLineID', $extra['TxnLineID']);
break;
case 'inventoryadjustment_inventoryadjustmentline':
$objects[$map[0]]->set('InventoryAdjustment_TxnID', $extra['TxnID']);
break;
case 'invoice_linkedtxn':
$objects[$map[0]]->set('FromTxnID', $extra['TxnID']);
break;
case 'invoice_invoiceline':
$objects[$map[0]]->set('Invoice_TxnID', $extra['TxnID']);
break;
case 'invoice_invoicelinegroup':
$objects[$map[0]]->set('Invoice_TxnID', $extra['TxnID']);
break;
case 'invoice_invoicelinegroup_invoiceline':
$objects[$map[0]]->set('Invoice_TxnID', $extra['TxnID']);
$objects[$map[0]]->set('Invoice_InvoiceLineGroup_TxnLineID', $extra['TxnLineID']);
break;
case 'itemgroup_itemgroupline':
$objects[$map[0]]->set('ItemGroup_ListID', $extra['ListID']);
break;
case 'iteminventoryassembly_iteminventoryassemblyline':
$objects[$map[0]]->set('ItemInventoryAssembly_ListID', $extra['ListID']);
break;
case 'itemreceipt_linkedtxn':
$objects[$map[0]]->set('FromTxnID', $extra['TxnID']);
break;
case 'itemreceipt_expenseline':
$objects[$map[0]]->set('ItemReceipt_TxnID', $extra['TxnID']);
break;
case 'itemreceipt_itemline':
$objects[$map[0]]->set('ItemReceipt_TxnID', $extra['TxnID']);
break;
case 'itemreceipt_itemgroupline':
$objects[$map[0]]->set('ItemReceipt_TxnID', $extra['TxnID']);
break;
case 'itemreceipt_itemgroupline_itemline':
$objects[$map[0]]->set('ItemReceipt_TxnID', $extra['TxnID']);
$objects[$map[0]]->set('ItemReceipt_ItemGroupLine_TxnLineID', $extra['TxnLineID']);
break;
case 'itemsalestaxgroup_itemsalestax':
$objects[$map[0]]->set('ItemSalesTaxGroup_ListID', $extra['ListID']);
break;
case 'journalentry_journalcreditline':
$objects[$map[0]]->set('JournalEntry_TxnID', $extra['TxnID']);
break;
case 'journalentry_journaldebitline':
$objects[$map[0]]->set('JournalEntry_TxnID', $extra['TxnID']);
break;
case 'pricelevel_pricelevelperitem':
$objects[$map[0]]->set('PriceLevel_ListID', $extra['ListID']);
break;
case 'purchaseorder_linkedtxn':
$objects[$map[0]]->set('FromTxnID', $extra['TxnID']);
break;
case 'purchaseorder_purchaseorderline':
$objects[$map[0]]->set('PurchaseOrder_TxnID', $extra['TxnID']);
break;
case 'purchaseorder_purchaseorderlinegroup':
$objects[$map[0]]->set('PurchaseOrder_TxnID', $extra['TxnID']);
break;
case 'purchaseorder_purchaseorderlinegroup_purchaseorderline':
$objects[$map[0]]->set('PurchaseOrder_TxnID', $extra['TxnID']);
$objects[$map[0]]->set('PurchaseOrder_PurchaseOrderLineGroup_TxnLineID', $extra['TxnLineID']);
break;
case 'salesorder_linkedtxn':
$objects[$map[0]]->set('FromTxnID', $extra['TxnID']);
break;
case 'salesorder_salesorderline':
$objects[$map[0]]->set('SalesOrder_TxnID', $extra['TxnID']);
break;
case 'salesorder_salesorderlinegroup':
$objects[$map[0]]->set('SalesOrder_TxnID', $extra['TxnID']);
break;
case 'salesorder_salesorderlinegroup_salesorderline':
$objects[$map[0]]->set('SalesOrder_TxnID', $extra['TxnID']);
$objects[$map[0]]->set('SalesOrder_SalesOrderLineGroup_TxnLineID', $extra['TxnLineID']);
break;
case 'salesreceipt_salesreceiptline':
$objects[$map[0]]->set('SalesReceipt_TxnID', $extra['TxnID']);
break;
case 'salesreceipt_salesreceiptlinegroup':
$objects[$map[0]]->set('SalesReceipt_TxnID', $extra['TxnID']);
break;
case 'salesreceipt_salesreceiptlinegroup_salesreceiptline':
$objects[$map[0]]->set('SalesReceipt_TxnID', $extra['TxnID']);
$objects[$map[0]]->set('SalesReceipt_SalesReceiptLineGroup_TxnLineID', $extra['TxnLineID']);
break;
case 'unitofmeasureset_relatedunit':
$objects[$map[0]]->set('UnitOfMeasureSet_ListID', $extra['ListID']);
break;
case 'unitofmeasureset_defaultunit':
$objects[$map[0]]->set('UnitOfMeasureSet_ListID', $extra['ListID']);
break;
case 'vendorcredit_linkedtxn':
$objects[$map[0]]->set('FromTxnID', $extra['TxnID']);
break;
case 'vendorcredit_expenseline':
$objects[$map[0]]->set('VendorCredit_TxnID', $extra['TxnID']);
break;
case 'vendorcredit_itemline':
$objects[$map[0]]->set('VendorCredit_TxnID', $extra['TxnID']);
break;
case 'vendorcredit_itemgroupline':
$objects[$map[0]]->set('VendorCredit_TxnID', $extra['TxnID']);
break;
case 'vendorcredit_itemgroupline_itemline':
$objects[$map[0]]->set('VendorCredit_TxnID', $extra['TxnID']);
$objects[$map[0]]->set('VendorCredit_ItemGroupLine_TxnLineID', $extra['TxnLineID']);
break;
case 'workerscompcode_ratehistory':
$objects[$map[0]]->set('WorkersCompCode_ListID', $extra['ListID']);
break;
}
}
if (isset($objects[$map[0]])) {
$tempMap = array();
$tempOthers = array();
QuickBooks_SQL_Schema::mapToSchema(trim($curpath), QUICKBOOKS_SQL_SCHEMA_MAP_TO_SQL, $tempMap, $tempOthers);
if ($map[0] == "dataextdef_assigntoobject") {
if ($objects[$map[0]]->path() != trim($curpath . ' ' . $Node->name()) and strlen(trim($curpath)) < strlen($objects[$map[0]]->path())) {
$objects[$map[0]]->changePath(trim($curpath . ' ' . $Node->name()));
}
} else {
if ($objects[$map[0]]->path() != trim($curpath) and strlen(trim($curpath)) < strlen($objects[$map[0]]->path())) {
$objects[$map[0]]->changePath(trim($curpath));
}
}
$objects[$map[0]]->set($map[1], $Node->data());
}
}
}
