<?php
$InvoiceService = new QuickBooks_IPP_Service_Invoice();
$ItemService = new QuickBooks_IPP_Service_Item();
$invoices = $InvoiceService->query($Context, $realm, "SELECT *, Line.* FROM Invoice STARTPOSITION 1 MAXRESULTS 5");
//print_r($customers);
foreach ($invoices as $Invoice) {
$num_lines = $Invoice->countLine();
// How many line items are there?
for ($i = 0; $i < $num_lines; $i++) {
$Line = $Invoice->getLine($i);
// Let's find out what item this uses
if ($Line->getDetailType() == 'SalesItemLineDetail') {
$Detail = $Line->getSalesItemLineDetail();
$item_id = $Detail->getItemRef();
print 'Item id is: ' . $item_id . "\n";
$items = $ItemService->query($Context, $realm, "SELECT * FROM Item WHERE Id = '" . QuickBooks_IPP_IDS::usableIDType($item_id) . "' ");
print ' That item is named: ' . $items[0]->getName() . "\n";
}
}
print "\n\n\n";
}
/*
print("\n\n\n\n");
print('Request [' . $IPP->lastRequest() . ']');
print("\n\n\n\n");
print('Response [' . $IPP->lastResponse() . ']');
print("\n\n\n\n");
*/
?>
</pre>
<?php
require_once dirname(__FILE__) . '/config.php';
require_once dirname(__FILE__) . '/views/header.tpl.php';
?>
<pre>
<?php
$ItemService = new QuickBooks_IPP_Service_Item();
// Get the existing item
$items = $ItemService->query($Context, $realm, "SELECT * FROM Item WHERE Id = '2' ");
$Item = $items[0];
// Update the name of the item
$Item->setName($Item->getName() . ' ' . mt_rand(0, 1000));
if ($resp = $ItemService->update($Context, $realm, $Item->getId(), $Item)) {
print 'Updated the item name to ' . $Item->getName();
} else {
print 'ERROR!';
print $ItemService->lastError($Context);
}
/*
print('<br><br><br><br>');
print("\n\n\n\n\n\n\n\n");
print('Request [' . $IPP->lastRequest() . ']');
print("\n\n\n\n");
print('Response [' . $IPP->lastResponse() . ']');
print("\n\n\n\n\n\n\n\n\n");
*/
?>
