Hi there,
I have a search that I am doing for item records. I am wanting to return the values for quantityOnHand and quantityOnOrder.
This search works and results are displayed for all products that have a value in the quantityOnHand field. If there isn't a value in the quantityOnHand field, it fails.
Here is my code:
<?php
require_once 'PHPtoolkit.php';
require_once 'login_info.php';
global $myNSclient;
$itemId = $_GET["itemId"];
$id = 'customsearch1670';
$searchItem = array('savedSearchScriptId' => $id);
$searchAdvanced = new nsComplexObject('ItemSearchAdvanced');
$searchAdvanced->setFields($searchItem);
$search = new nsComplexObject('ItemSearch');
$textnumberfield = new nsComplexObject('SearchStringField');
$textnumberfield->setFields(array('operator'=>'contains','searchValue'=>$itemId));
$transearchobject = new nsComplexObject('ItemSearchBasic');
$transearchobject->setFields(array('itemId'=>$textnumberfield));
$search->setFields(array('basic'=>$transearchobject));
$searchAdvanced->setFields(array('criteria'=>$search));
$searchResponse = $myNSclient->search($searchAdvanced);
?>
<?php if(isset($searchResponse) && count($searchResponse->searchRowList) > 0): ?>
<?php foreach ( $searchResponse->searchRowList as $transaction ): ?>
<?php echo round($transaction->getField('basic')->getField('quantityOnHand')->getField('searchValue')); ?>
<?php echo round($transaction->getField('basic')->getField('quantityOnOrder')->getField('searchValue')); ?>
<?php endforeach; ?>
<?php else: ?>
<?php endif; ?>
A successful result would look like this:
http://ekenamil.nextmp.net/ns/lookup-inventory.php?itemId=CM30AT
One that doesn't contain a value for the quantityOnHand, that fails is here:
http://ekenamil.nextmp.net/ns/lookup-inventory.php?itemId=CM09MA
Thank you,
james