/**
* Hook which gets called when the Web Connector authenticates to the server
*
* @param string $requestID Not applicable to this hook
* @param string $user The username of the user who connected
* @param string $hook The name of the hook which connected
* @param string $err If an error occurs, you should return an error message here
* @param array $hook_data An array of hook data
* @param array $callback_config An array of callback configuration params
* @return boolean
*/
public static function onAuthenticate($requestID, $user, $hook, &$err, $hook_data, $callback_config)
{
// $requestID, $user, $hook, &$err, $hook_data, $callback_config
// Driver instance
$Driver = QuickBooks_Driver_Singleton::getInstance();
// Map instance
$Map = new QuickBooks_Map_Qbxml($Driver);
// Mode (read-onlyl, write-only, read/write)
$mode = $callback_config['mode'];
// How often recurring events happen
$run_every = $callback_config['recur'];
// $map parameter
$sql_map = $callback_config['map'];
// Which things do you want to query? (QuickBooks => SQL database)
/*
$sql_query = array();
foreach (QuickBooks_Utilities::listActions('*QUERY*') as $action)
{
$sql_query[$action] = QuickBooks_Utilities::priorityForAction($action);
}
$sql_query = QuickBooks_Callbacks_SQL_Callbacks::_filterActions($sql_query, $callback_config['_only_query'], $callback_config['_dont_query'], QUICKBOOKS_QUERY);
*/
//$start = microtime(true);
//$_start = microtime(true);
$sql_import = array();
$tmp = QuickBooks_Utilities::listActions('*IMPORT*');
//print('0.01 [' . (microtime(true) - $start) . ']' . "\n\n");
foreach ($tmp as $action) {
$sql_import[$action] = QuickBooks_Utilities::priorityForAction($action);
}
//print('0.02 [' . (microtime(true) - $start) . ']' . "\n\n");
$sql_import = QuickBooks_Callbacks_SQL_Callbacks::_filterActions($sql_import, $callback_config['_only_import'], $callback_config['_dont_import'], QUICKBOOKS_IMPORT);
//print('0.03 [' . (microtime(true) - $start) . ']' . "\n\n");
//print('0.1 [' . (microtime(true) - $start) . ']' . "\n\n");
// Which things you want to *add* to QuickBooks (SQL => QuickBooks (adds only!))
// @todo These should be changed to use QuickBooks_Utilities::listActions('*ADD*')
$sql_add = array();
foreach (QuickBooks_Utilities::listActions('*ADD*') as $action) {
$sql_add[$action] = QuickBooks_Utilities::priorityForAction($action);
}
$sql_add = QuickBooks_Callbacks_SQL_Callbacks::_filterActions($sql_add, $callback_config['_only_add'], $callback_config['_dont_add'], QUICKBOOKS_ADD);
//print('0.2 [' . (microtime(true) - $start) . ']' . "\n\n");
// Which things you want to *modify* in QuickBooks (SQL => QuickBooks (modifys only!))
// @todo These should be changed to use QuickBooks_Utilities::listActions('*MOD*')
$sql_mod = array();
foreach (QuickBooks_Utilities::listActions('*MOD*') as $action) {
$sql_mod[$action] = QuickBooks_Utilities::priorityForAction($action);
}
$sql_mod = QuickBooks_Callbacks_SQL_Callbacks::_filterActions($sql_mod, $callback_config['_only_modify'], $callback_config['_dont_modify'], QUICKBOOKS_MOD);
//print('0.3 [' . (microtime(true) - $start) . ']' . "\n\n");
// Which things you want to *audit* in QuickBooks (QuickBooks => SQL)
$sql_audit = array();
foreach (QuickBooks_Utilities::listActions('*AUDIT*') as $action) {
$sql_audit[$action] = QuickBooks_Utilities::priorityForAction($action);
}
//print('1 [' . (microtime(true) - $start) . ']' . "\n\n"); $start = microtime(true);
// Queueing class
//$Queue = new QuickBooks_Queue($dsn_or_conn);
// List of all actions we're performing
$actions = array();
if ($mode == QuickBooks_WebConnector_Server_SQL::MODE_READONLY or $mode == QuickBooks_WebConnector_Server_SQL::MODE_READWRITE) {
//print_r($sql_query);
//print_r($sql_map);
// Register recurring events for things you want to query
//foreach ($sql_query as $action => $priority)
foreach ($sql_import as $action => $priority) {
//$Driver->log('Registering recurring event for: ' . $action, null, QUICKBOOKS_LOG_DEBUG);
// Make sure that there are handlers registered for this recurring action
if (!isset($sql_map[$action])) {
//trigger_error('No registered handler for: ' . $action);
continue;
}
//$Queue->recurring($run_every, $action, md5(__FILE__), $priority, null, $user);
$Driver->recurEnqueue($user, $run_every, $action, md5(__FILE__), true, $priority);
$actions[] = $action;
}
if (in_array(QUICKBOOKS_QUERY_DELETEDLISTS, $callback_config['_only_misc'])) {
// Also grab any deleted records
$Driver->queueEnqueue($user, QUICKBOOKS_QUERY_DELETEDLISTS, 1, true, 0);
}
if (in_array(QUICKBOOKS_QUERY_DELETEDTXNS, $callback_config['_only_misc'])) {
$Driver->queueEnqueue($user, QUICKBOOKS_QUERY_DELETEDTXNS, 1, true, 0);
}
if (in_array(QUICKBOOKS_DERIVE_INVENTORYLEVELS, $callback_config['_only_misc'])) {
// Update inventory levels
$Driver->queueEnqueue($user, QUICKBOOKS_DERIVE_INVENTORYLEVELS, 1, true, 0);
}
if (in_array(QUICKBOOKS_DERIVE_INVENTORYASSEMBLYLEVELS, $callback_config['_only_misc'])) {
// Update inventory assembly levels
$Driver->queueEnqueue($user, QUICKBOOKS_DERIVE_INVENTORYASSEMBLYLEVELS, 1, true, 0);
}
}
//print('2 [' . (microtime(true) - $start) . ']' . "\n\n"); $start = microtime(true);
/*
// Queue up the audit requests
// Audit requests pull in just the calculated TotalAmount and the
// TimeModified timestamp from transactions, and store these in
// the qbsql_audit_* fields so we can tell if there are transactions
// in QuickBooks that don't match up correctly to what's in the SQL
// database.
foreach ($sql_audit as $action => $priority)
{
if (!isset($sql_map[$action]))
{
continue;
}
$Driver->queueEnqueue($user, $action, 1, true, $priority);
}
*/
// Searching the tables can take a long time, you could potentially
// have 10 or 15 seconds between when we search for new customers, and
// when we search for new invoices. What we don't want to have happen
// is that we search for new customers to be queued up, then a new
// customer and invoice gets added, then we search for invoices to be
// queued up, queue up the invoice, but the customer it depends on
// didn't get queued up yet... results in an error!
//
// We avoid this by keeping track of when NOW is, and only queueing up
// things that are older than NOW()
$NOW = date('Y-m-d H:i:s');
// Limit to max adds by time per auth
$time_limit = 15;
// 60 *second* limit
$time_start = time();
// When we started
// Objects that need to be *ADDED* to QuickBooks
if ($mode == QuickBooks_WebConnector_Server_SQL::MODE_WRITEONLY or $mode == QuickBooks_WebConnector_Server_SQL::MODE_READWRITE) {
$mark_as_queued = false;
$map = $Map->adds($sql_add, $mark_as_queued);
//$Driver->log('ADDS: ' . print_r($map, true));
// Go through each action in the returned map
foreach ($map as $action => $list) {
//$Driver->log('Now doing: ' . $action . ', ' . print_r($list, true));
//$__start = microtime(true);
// Go through each ID for each action
$counter = 0;
foreach ($list as $ID => $priority) {
$counter++;
if (time() - $time_start > $time_limit) {
//print('HIT LIMIT SO WE\'RE BREAKING OUT OF HERE [' . $action . '] [ ' . $counter . ' of ' . count($list) . ']!' . "\n");
break 2;
}
// Queue it up to be added to QuickBooks
$Driver->queueEnqueue($user, $action, $ID, true, $priority);
}
//print('now ' . $action . ' [' . (microtime(true) - $__start) . ']' . "\n");
}
}
//print('3 [' . (microtime(true) - $start) . ']' . "\n\n"); $start = microtime(true);
// Objects that need to be *MODIFIED* within QuickBooks
if ($mode == QuickBooks_WebConnector_Server_SQL::MODE_WRITEONLY or $mode == QuickBooks_WebConnector_Server_SQL::MODE_READWRITE) {
// Check if any objects need to be pushed back to QuickBooks
foreach ($sql_mod as $action => $priority) {
$object = QuickBooks_Utilities::actionToObject($action);
$table_and_field = array();
// Convert to table and primary key, select qbsql id
QuickBooks_SQL_Schema::mapPrimaryKey($object, QUICKBOOKS_SQL_SCHEMA_MAP_TO_SQL, $table_and_field);
//$Driver->log('Searching table: ' . print_r($table_and_field, true) . ' for MODIFIED records.', null, QUICKBOOKS_LOG_DEBUG);
// If we managed to map a table, we need to search that table for changed records
if (!empty($table_and_field[0]) and !empty($table_and_field[1])) {
// For MODs:
// - Do not sync if to_delete = 1
// - Do not sync if to_skip = 1
// - Do not sync if an error occurred on this record
$sql = "\n\t\t\t\t\t\tSELECT \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_ID . ", \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_ERROR_NUMBER . "\n\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_PREFIX_SQL . $table_and_field[0] . " \n\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_DISCOVER . " IS NOT NULL AND \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_RESYNC . " IS NOT NULL AND\n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_MODIFY . " > " . QUICKBOOKS_DRIVER_SQL_FIELD_RESYNC . " AND\n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_TO_DELETE . " != 1 AND \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_FLAG_DELETED . " != 1 AND \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_TO_VOID . " != 1 AND \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_TO_SKIP . " != 1 AND \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_MODIFY . " <= '" . $NOW . "' ";
$errnum = 0;
$errmsg = '';
$res = $Driver->query($sql, $errnum, $errmsg);
while ($arr = $Driver->fetch($res)) {
if (strlen($arr[QUICKBOOKS_DRIVER_SQL_FIELD_ERROR_NUMBER])) {
// Do not sync this record until the error is resolved
continue;
}
// Queue up this MOD request
$Driver->queueEnqueue($user, $action, $arr[QUICKBOOKS_DRIVER_SQL_FIELD_ID], true, $priority);
$actions[] = $action;
// Mark the record as enqueued - let's wait until the hashing is in for this
//$Driver->query(..., $errnum, $errmsg);
}
}
}
}
//print('4 [' . (microtime(true) - $start) . ']' . "\n\n"); $start = microtime(true);
if ($mode == QuickBooks_WebConnector_Server_SQL::MODE_WRITEONLY or $mode == QuickBooks_WebConnector_Server_SQL::MODE_READWRITE) {
// Check if any *voided* objects need to be voided in QuickBooks
foreach ($sql_add as $action => $priority) {
$object = QuickBooks_Utilities::actionToObject($action);
$dependency = null;
if ($object == QUICKBOOKS_OBJECT_BILL) {
// Bill VOID dependency is PurchaseOrderMod because we want to be able to manually close POs (but need to VOID the bills first)
$dependency = QUICKBOOKS_MOD_PURCHASEORDER;
}
$priority = QuickBooks_Utilities::priorityForAction(QUICKBOOKS_VOID_TRANSACTION, $dependency);
$table_and_field = array();
// Convert to table and primary key, select qbsql id
QuickBooks_SQL_Schema::mapPrimaryKey($object, QUICKBOOKS_SQL_SCHEMA_MAP_TO_SQL, $table_and_field);
//$Driver->log('Searching table: ' . print_r($table_and_field, true) . ' for VOIDED records.', null, QUICKBOOKS_LOG_DEBUG);
if (!empty($table_and_field[0])) {
$sql = "\n\t\t\t\t\t\tSELECT \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_ID . "\n\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_PREFIX_SQL . $table_and_field[0] . " \n\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_DISCOVER . " IS NOT NULL AND \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_TO_DELETE . " != 1 AND \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_FLAG_DELETED . " != 1 AND \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_TO_VOID . " = 1 AND \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_FLAG_VOIDED . " != 1 AND \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_MODIFY . " <= '" . $NOW . "' ";
$errnum = 0;
$errmsg = '';
$res = $Driver->query($sql, $errnum, $errmsg);
$extra = array('object' => $object);
while ($arr = $Driver->fetch($res)) {
$Driver->queueEnqueue($user, QUICKBOOKS_VOID_TRANSACTION, $arr[QUICKBOOKS_DRIVER_SQL_FIELD_ID], true, $priority, $extra);
}
}
}
}
//print('5 [' . (microtime(true) - $start) . ']' . "\n\n"); $start = microtime(true);
if ($mode == QuickBooks_WebConnector_Server_SQL::MODE_WRITEONLY or $mode == QuickBooks_WebConnector_Server_SQL::MODE_READWRITE) {
// Check if any *deleted* objects need to be deleted from QuickBooks
foreach ($sql_add as $action => $priority) {
break;
$priority = 1000 - $priority;
$object = QuickBooks_Utilities::actionToObject($action);
$table_and_field = array();
// Convert to table and primary key, select qbsql id
QuickBooks_SQL_Schema::mapPrimaryKey($object, QUICKBOOKS_SQL_SCHEMA_MAP_TO_SQL, $table_and_field);
// Delete if it's marked for deletion and it hasn't been deleted already
if (!empty($table_and_field[0])) {
$sql = "\n\t\t\t\t\t\tSELECT \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_ID . "\n\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_PREFIX_SQL . $table_and_field[0] . " \n\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t " . QUICKBOOKS_DRIVER_SQL_FIELD_TO_DELETE . " = 1 AND \n\t\t\t\t\t\t\t " . QUICKBOOKS_DRIVER_SQL_FIELD_FLAG_DELETED . " != 1 AND \n\t\t\t\t\t\t\t " . QUICKBOOKS_DRIVER_SQL_FIELD_MODIFY . " <= '" . $NOW . "' ";
$errnum = 0;
$errmsg = '';
$res = $Driver->query($sql, $errnum, $errmsg);
$key = QuickBooks_Utilities::keyForAction($action);
if ($key == 'ListID') {
$useAction = 'ListDel';
} else {
$useAction = 'TxnDel';
}
$extra['objectType'] = $object;
while ($arr = $Driver->fetch($res)) {
$Driver->queueEnqueue($user, $useAction, $extra['objectType'] . $arr[QUICKBOOKS_DRIVER_SQL_FIELD_ID], true, $priority, $extra);
}
}
}
}
//print('6 [' . (microtime(true) - $start) . ']' . "\n\n"); $start = microtime(true);
/*
// This makes sure that timestamps are set up for every action we're doing (fixes a bug where timestamps never get recorded on initial sync without iterator)
foreach ($actions as $action)
{
$module = __CLASS__;
$key_curr = QuickBooks_Callbacks_SQL_Callbacks::_keySyncCurr($action);
$key_prev = QuickBooks_Callbacks_SQL_Callbacks::_keySyncPrev($action);
$type = null;
$opts = null;
$curr_sync_datetime = $Driver->configRead($user, $module, $key_curr, $type, $opts); // last sync started...
$prev_sync_datetime = $Driver->configRead($user, $module, $key_prev, $type, $opts); // last sync started...
$datetime = QuickBooks_Utilities::datetime('1983-01-02');
if (!$curr_sync_datetime)
{
$Driver->configWrite($user, $module, $key_curr, $datetime, null);
}
if (!$prev_sync_datetime)
{
$Driver->configWrite($user, $module, $key_prev, $datetime, null);
}
}
*/
//print("\n\n" . 'here [ ' . (microtime(true) - $_start) . ']' . "\n\n\n");
return true;
}
/**
* ReceiveResponseXML() method for the QuickBooks Web Connector - Receive and handle a resonse form QuickBooks
*
* The stdClass object passed as a parameter will have the following members:
* - ->ticket The QuickBooks Web Connector ticket
* - ->response An XML response message
* - ->hresult Error code
* - ->message Error message
*
* The sole data member of the returned object should be an integer.
* - The data member should be -1 if an error occured and QBWC should call ->getLastError()
* - Should be an integer 0 <= x < 100 to indicate success *and* that the application should continue to call ->sendRequestXML() at least one more time (more queued items still in the queue, the integer represents the percentage complete the total batch job is)
* - Should be 100 to indicate success *and* that the queue has been exhausted
*
* The following user-defined hooks are invoked:
* - QUICKBOOKS_HANDLERS_HOOK_RECEIVERESPONSEXML
*
* @param stdClass $obj
* @return QuickBooks_Result_ReceiveResponseXML
*/
public function receiveResponseXML($obj)
{
$this->_driver->log('receiveResponseXML()', $obj->ticket, QUICKBOOKS_LOG_VERBOSE);
if ($this->_driver->authCheck($obj->ticket)) {
$user = $this->_driver->authResolve($obj->ticket);
$hookdata = array('username' => $user, 'ticket' => $obj->ticket);
$hookerr = '';
$this->_callHook($obj->ticket, QUICKBOOKS_HANDLERS_HOOK_RECEIVERESPONSEXML, null, null, null, null, $hookerr, null, array(), $hookdata);
$this->_driver->log('Incoming XML response: ' . $obj->response, $obj->ticket, QUICKBOOKS_LOG_DEBUG);
// Check if we got a error message...
if (strlen($obj->message) or $this->_extractStatusCode($obj->response)) {
if ($requestID = $this->_extractRequestID($obj->response)) {
$errnum = $this->_extractStatusCode($obj->response);
//$action = current(explode('|', $requestID));
//$ident = next(explode('|', $requestID));
$action = '';
$ident = '';
$this->_parseRequestID($requestID, $action, $ident);
// Fetch the request that was processed and EXPERIENCED AN ERROR!
$extra = '';
if ($current = $this->_driver->queueFetch($user, $action, $ident, QUICKBOOKS_STATUS_PROCESSING)) {
if ($current['extra']) {
$extra = unserialize($current['extra']);
}
}
if ($obj->message) {
$errmsg = $obj->message;
} else {
if ($status = $this->_extractStatusMessage($obj->response)) {
$errmsg = $status;
}
}
$errerr = '';
$continue = $this->_handleError($obj->ticket, $errnum, $errmsg, $requestID, $action, $ident, $extra, $errerr, $obj->response, array());
// $errnum, $errmsg, $requestID, $action, $ident, $extra, &$err, $xml, $qb_identifiers = array()
if ($errerr) {
// The error handler returned an error too...
$this->_driver->log('An error occured while handling quickbooks error ' . $errnum . ': ' . $errmsg . ': ' . $errerr, $obj->ticket, QUICKBOOKS_LOG_NORMAL);
}
} else {
$errerr = '';
$continue = $this->_handleError($obj->ticket, $obj->hresult, $obj->message, null, null, null, null, $errerr, $obj->response, array());
if ($errerr) {
// The error handler returned an error too...
$this->_driver->log('An error occured while handling generic error ' . $obj->hresult . ': ' . $obj->message . ': ' . $errerr, $obj->ticket, QUICKBOOKS_LOG_NORMAL);
}
}
// Calculate the percentage done
$progress = $this->_calculateProgress($obj->ticket);
if (!$continue) {
$progress = -1;
}
$this->_driver->log('Transaction error at ' . $progress . '% complete... ', $obj->ticket, QUICKBOOKS_LOG_VERBOSE);
return new QuickBooks_Result_ReceiveResponseXML($progress);
}
$action = null;
$ident = null;
$requestID = null;
if ($requestID = $this->_extractRequestID($obj->response)) {
//$action = current(explode('|', $requestID));
//$ident = end(explode('|', $requestID));
$action = '';
$ident = '';
$this->_parseRequestID($requestID, $action, $ident);
// Fetch the request that's being processed
$extra = '';
if ($current = $this->_driver->queueFetch($user, $action, $ident, QUICKBOOKS_STATUS_PROCESSING)) {
if ($current['extra']) {
$extra = unserialize($current['extra']);
}
}
// Update the status to success (no error occured)
$this->_driver->queueStatus($obj->ticket, $action, $ident, QUICKBOOKS_STATUS_SUCCESS);
}
// Extract ListID, TxnID, etc. from the response
$identifiers = $this->_extractIdentifiers($obj->response);
//$this->_driver->log(var_export($identifiers, true), $obj->ticket, QUICKBOOKS_LOG_VERBOSE);
// Auto-map $ident unique identifier from web application to the QuickBooks ListID or TxnID
if ($this->_config['map_application_identifiers']) {
$adds = QuickBooks_Utilities::listActions('*Add*');
$mods = QuickBooks_Utilities::listActions('*Mod*');
$qbkey = QuickBooks_Utilities::keyForAction($action);
$type = QuickBooks_Utilities::actionToObject($action);
$EditSequence = '';
if (isset($identifiers['EditSequence'])) {
$EditSequence = $identifiers['EditSequence'];
}
if (in_array($action, $adds) and isset($identifiers[$qbkey]) and $type) {
// Try to map the $ident to the QuickBooks identifier
$this->_driver->identMap($user, $type, $ident, $identifiers[$qbkey], $EditSequence);
} else {
if (in_array($action, $mods) and isset($identifiers[$qbkey]) and $type) {
// Try to map the $ident to the QuickBooks identifier
$this->_driver->identMap($user, $type, $ident, $identifiers[$qbkey], $EditSequence);
}
}
}
$err = null;
$last_action_time = $this->_driver->queueActionLast($user, $action);
$last_actionident_time = $this->_driver->queueActionIdentLast($user, $action, $ident);
$this->_callMappedFunction(1, $user, $action, $ident, $extra, $err, $last_action_time, $last_actionident_time, $obj->response, $identifiers);
// Calculate the percentage done
$progress = $this->_calculateProgress($obj->ticket);
if ($err) {
$errerr = '';
$continue = $this->_handleError($obj->ticket, QUICKBOOKS_ERROR_HANDLER, $err, $requestID, $action, $ident, $extra, $errerr, $obj->response, $identifiers);
if (!$continue) {
$progress = -1;
}
}
$this->_driver->log($progress . '% complete... ', $obj->ticket, QUICKBOOKS_LOG_VERBOSE);
return new QuickBooks_Result_ReceiveResponseXML($progress);
}
return new QuickBooks_Result_ReceiveResponseXML(-1);
}
/**
* Hook which gets called when the Web Connector authenticates to the server
*
* @param string $requestID Not applicable to this hook
* @param string $user The username of the user who connected
* @param string $hook The name of the hook which connected
* @param string $err If an error occurs, you should return an error message here
* @param array $hook_data An array of hook data
* @param array $callback_config An array of callback configuration params
* @return boolean
*/
public static function onAuthenticate($requestID, $user, $hook, &$err, $hook_data, $callback_config)
{
// $requestID, $user, $hook, &$err, $hook_data, $callback_config
// Driver instance
$Driver = QuickBooks_Driver_Singleton::getInstance();
// Mode (read-onlyl, write-only, read/write)
$mode = $callback_config['mode'];
// How often recurring events happen
$run_every = $callback_config['recur'];
// $map parameter
$sql_map = $callback_config['map'];
//print_r($callback_config);
//exit;
// Which things do you want to query? (QuickBooks => SQL database)
$sql_query = array();
foreach (QuickBooks_Utilities::listActions('*QUERY*') as $action) {
$sql_query[$action] = QuickBooks_Utilities::priorityForAction($action);
}
$sql_query = QuickBooks_Server_SQL_Callbacks::_filterActions($sql_query, $callback_config['_only_query'], $callback_config['_dont_query'], QUICKBOOKS_QUERY);
// Which things you want to *add* to QuickBooks (SQL => QuickBooks (adds only!))
// @todo These should be changed to use QuickBooks_Utilities::listActions('*ADD*')
foreach (QuickBooks_Utilities::listActions('*ADD*') as $action) {
$sql_add[$action] = QuickBooks_Utilities::priorityForAction($action);
}
$sql_add = QuickBooks_Server_SQL_Callbacks::_filterActions($sql_add, $callback_config['_only_add'], $callback_config['_dont_add'], QUICKBOOKS_ADD);
// Which things you want to *modify* in QuickBooks (SQL => QuickBooks (modifys only!))
// @todo These should be changed to use QuickBooks_Utilities::listActions('*MOD*')
foreach (QuickBooks_Utilities::listActions('*MOD*') as $action) {
$sql_mod[$action] = QuickBooks_Utilities::priorityForAction($action);
}
$sql_mod = QuickBooks_Server_SQL_Callbacks::_filterActions($sql_mod, $callback_config['_only_modify'], $callback_config['_dont_modify'], QUICKBOOKS_MOD);
// Queueing class
//$Queue = new QuickBooks_Queue($dsn_or_conn);
if ($mode == QUICKBOOKS_SERVER_SQL_MODE_READONLY or $mode == QUICKBOOKS_SERVER_SQL_MODE_READWRITE) {
//print_r($sql_query);
//print_r($sql_map);
// Register recurring events for things you want to query
foreach ($sql_query as $action => $priority) {
// Make sure that there are handlers registered for this recurring action
if (!isset($sql_map[$action])) {
//trigger_error('No registered handler for: ' . $action);
continue;
}
//$Queue->recurring($run_every, $action, md5(__FILE__), $priority, null, $user);
$Driver->recurEnqueue($user, $run_every, $action, md5(__FILE__), true, $priority);
}
}
// Objects that need to be *ADDED* to QuickBooks
if ($mode == QUICKBOOKS_SERVER_SQL_MODE_WRITEONLY or $mode == QUICKBOOKS_SERVER_SQL_MODE_READWRITE) {
// Check if any objects need to be pushed back to QuickBooks
foreach ($sql_add as $action => $priority) {
$object = QuickBooks_Utilities::actionToObject($action);
$table_and_field = array();
// Convert to table and primary key, select qbsql id
QuickBooks_SQL_Schema::mapPrimaryKey($object, QUICKBOOKS_SQL_SCHEMA_MAP_TO_SQL, $table_and_field);
//print_r($table_and_field);
if (!empty($table_and_field[0]) and !empty($table_and_field[1])) {
$sql = "\n\t\t\t\t\t\tSELECT \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_ID . "\n\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_PREFIX_SQL . $table_and_field[0] . " \n\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t " . QUICKBOOKS_DRIVER_SQL_FIELD_MODIFY . " IS NOT NULL AND \n\t\t\t\t\t\t\t " . QUICKBOOKS_DRIVER_SQL_FIELD_RESYNC . " IS NULL AND \n\t\t\t\t\t\t\t " . QUICKBOOKS_DRIVER_SQL_FIELD_TO_SKIP . " != 1 ";
$errnum = 0;
$errmsg = '';
$res = $Driver->query($sql, $errnum, $errmsg);
while ($arr = $Driver->fetch($res)) {
$Driver->queueEnqueue($user, $action, $arr[QUICKBOOKS_DRIVER_SQL_FIELD_ID], true, $priority);
}
}
}
}
// Objects that need to be *MODIFIED* within QuickBooks
if ($mode == QUICKBOOKS_SERVER_SQL_MODE_WRITEONLY or $mode == QUICKBOOKS_SERVER_SQL_MODE_READWRITE) {
// Check if any objects need to be pushed back to QuickBooks
foreach ($sql_mod as $action => $priority) {
$object = QuickBooks_Utilities::actionToObject($action);
$table_and_field = array();
// Convert to table and primary key, select qbsql id
QuickBooks_SQL_Schema::mapPrimaryKey($object, QUICKBOOKS_SQL_SCHEMA_MAP_TO_SQL, $table_and_field);
$Driver->log('Searching table: ' . QUICKBOOKS_DRIVER_SQL_PREFIX_SQL . $table_and_field[0] . ' for MODIFIED records.', null, QUICKBOOKS_LOG_DEBUG);
// If we managed to map a table, we need to search that table for changed records
if (!empty($table_and_field[0]) and !empty($table_and_field[1])) {
$sql = "\n\t\t\t\t\t\tSELECT \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_ID . "\n\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_PREFIX_SQL . $table_and_field[0] . " \n\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_DISCOVER . " IS NOT NULL AND \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_RESYNC . " IS NOT NULL AND\n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_MODIFY . " > " . QUICKBOOKS_DRIVER_SQL_FIELD_RESYNC . " AND\n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_TO_DELETE . " != 1 AND \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_TO_SKIP . " != 1 ";
$errnum = 0;
$errmsg = '';
$res = $Driver->query($sql, $errnum, $errmsg);
while ($arr = $Driver->fetch($res)) {
$Driver->queueEnqueue($user, $action, $arr[QUICKBOOKS_DRIVER_SQL_FIELD_ID], true, $priority);
}
}
}
}
if ($mode == QUICKBOOKS_SERVER_SQL_MODE_WRITEONLY or $mode == QUICKBOOKS_SERVER_SQL_MODE_READWRITE) {
// Check if any *deleted* objects need to be deleted from QuickBooks
foreach ($sql_add as $action => $priority) {
$priority = 1000 - $priority;
$object = QuickBooks_Utilities::actionToObject($action);
$table_and_field = array();
// Convert to table and primary key, select qbsql id
QuickBooks_SQL_Schema::mapPrimaryKey($object, QUICKBOOKS_SQL_SCHEMA_MAP_TO_SQL, $table_and_field);
if (!empty($table_and_field[0])) {
$sql = "\n\t\t\t\t\t\tSELECT \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_FIELD_ID . "\n\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t" . QUICKBOOKS_DRIVER_SQL_PREFIX_SQL . $table_and_field[0] . " \n\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t " . QUICKBOOKS_DRIVER_SQL_FIELD_TO_DELETE . " = 1 ";
$errnum = 0;
$errmsg = '';
$res = $Driver->query($sql, $errnum, $errmsg);
$key = QuickBooks_Utilities::keyForAction($action);
if ($key == 'ListID') {
$useAction = 'ListDel';
} else {
$useAction = 'TxnDel';
}
$extra['objectType'] = $object;
while ($arr = $Driver->fetch($res)) {
$Driver->queueEnqueue($user, $useAction, $extra['objectType'] . $arr[QUICKBOOKS_DRIVER_SQL_FIELD_ID], true, $priority, $extra);
}
}
}
}
return true;
}
