/** * This callback gets called when we fetch a customer by name * * This callback is attached to the API method $API->getCustomerByName(...) in * the docs/example_api_client_canadian.php script. * * @param string $method * @param string $action The action type of method being executed (CustomerQuery) * @param mixed $ID The primary key of the customer you tried to fetch * @param string $err If an error occurs, you should pass back the error message here * @param string $qbxml The raw qbXML response from QuickBooks * @param QuickBooks_API_Iterator * @param resource $resource * @return void */ function _quickbooks_ca_customer_getbyname_callback($method, $action, $ID, &$err, $qbxml, $Iterator, $resource) { global $dsn; global $user; if (is_object($Iterator) and $Iterator->count() > 0) { // We found a record matching this name, let's build a mapping of the // primary key in QuickBooks to the primary key in our own application // // The primary key in QuickBooks for anything transaction related // (invoices, sales receipts, payments, etc.) is "TxnID", while the // primary key in QuickBooks for anything non-transaction related // (customers, sales tax codes, items, vendors, etc.) is "ListID" // Fetch the first item from the Iterator $Customer = $Iterator->next(); // Build your own mapping... // mysql_query("INSERT INTO my_mapping_table ( qbType, qbListID_or_TxnID, application_primary_key ) VALUES ( 'Customer', '" . mysql_real_escape_string($Customer->getListID()) . "', " . (int) $ID . " ) "); // ... or use the built-in mapping methods QuickBooks_Utilities::createMapping($dsn, $user, QUICKBOOKS_OBJECT_CUSTOMER, $Customer->getListID(), $ID, $Customer->getEditSequence()); } else { // No customer with that name was found } }
<?php require_once '/home/library_php/QuickBooks.php'; $dsn = 'mysql://*****:*****@localhost/quickbooks'; $user = '******'; QuickBooks_Utilities::createMapping($dsn, $user, QUICKBOOKS_OBJECT_CUSTOMER, '1234-1234', 15); print "\n"; print "\n"; print 'App ID: ' . QuickBooks_Utilities::fetchApplicationID($dsn, $user, QUICKBOOKS_OBJECT_CUSTOMER, '1234-1234'); print "\n"; print "\n"; print 'QB ID: ' . QuickBooks_Utilities::fetchQuickbooksID($dsn, $user, QUICKBOOKS_OBJECT_CUSTOMER, 15); print "\n"; print "\n";