public function checkProductAvailibiltyOrderItems($arrobjProducts, $arrmixOrderItems) { $arrstrProductIds = array(); $arrintItems = array(); foreach ($arrobjProducts as $objProduct) { $arrstrProductIds[] = '\'' . $objProduct->getProductNumber() . '\''; $arrintItems[$objProduct->getProductNumber()] = $arrmixOrderItems[$objProduct->getId()]; } $strQueryString = ' SELECT Id, Quantity_Available__c FROM CustomProduct__C WHERE Id IN ( ' . implode(',', $arrstrProductIds) . ' )'; try { $arrmixTempProducts = $this->m_objSforcePartnerClient->query($strQueryString); } catch (\Exception $e) { echo 'Unable to fetch records from Salesforce'; return; } $objQueryResult = new QueryResult($arrmixTempProducts); $this->arrmixProducts = array(); $boolIsProductAvailable = true; for ($objQueryResult->rewind(); $objQueryResult->pointer < $objQueryResult->size; $objQueryResult->next()) { $arrmixRecords = $objQueryResult->current(); if ($arrmixRecords->fields->Quantity_Available__c < $arrintItems[$arrmixRecords->Id]) { $boolIsProductAvailable = false; break; } } $this->output[] = 'Checked Product Avalaibility'; return $boolIsProductAvailable; }
private function getSFProducts() { $strQueryString = 'SELECT Id, Name, Catagory_Id__c, Color_Code__c, Discount__c, List_Price__c, Product_Code__c, Product_Description__c, Product_Image_Url__c, Quantity_Available__c, Size__c FROM CustomProduct__C'; try { $arrmixTempProducts = $this->m_objSforcePartnerClient->query($strQueryString); } catch (\Exception $e) { echo 'Unable to fetch records from Salesforce'; } $objQueryResult = new QueryResult($arrmixTempProducts); $this->arrmixProducts = array(); for ($objQueryResult->rewind(); $objQueryResult->pointer < $objQueryResult->size; $objQueryResult->next()) { $arrmixRecords = $objQueryResult->current(); $this->arrmixProducts[$arrmixRecords->Id]['product_number'] = $arrmixRecords->Id; $this->arrmixProducts[$arrmixRecords->Id]['name'] = $arrmixRecords->fields->Name; $this->arrmixProducts[$arrmixRecords->Id]['category'] = $arrmixRecords->fields->Catagory_Id__c; $this->arrmixProducts[$arrmixRecords->Id]['link'] = $arrmixRecords->fields->Product_Image_Url__c; $this->arrmixProducts[$arrmixRecords->Id]['list_price'] = $arrmixRecords->fields->List_Price__c; $this->arrmixProducts[$arrmixRecords->Id]['description'] = $arrmixRecords->fields->Product_Description__c; $this->arrmixProducts[$arrmixRecords->Id]['color'] = $arrmixRecords->fields->Color_Code__c; $this->arrmixProducts[$arrmixRecords->Id]['size'] = $arrmixRecords->fields->Size__c; $this->arrmixProducts[$arrmixRecords->Id]['quantity_available'] = $arrmixRecords->fields->Quantity_Available__c; $this->arrmixProducts[$arrmixRecords->Id]['discount'] = $arrmixRecords->fields->Discount__c; } }