<?php
 function getSupplierProductDetails($idSupplierProduct){ global $VALUES, $db, $DBTSuppliersProducts; if (!$idSupplierProduct) return; if ($VALUES['suppliersServicesDetails'][$idSupplierProduct]) return $VALUES['suppliersServicesDetails'][$idSupplierProduct]; $getSupplierProductSQL="SELECT productName, category, serviceCode, destinationCountryCode, destinationCityId FROM `$DBTSuppliersProducts` WHERE id='".$idSupplierProduct."'"; $getSupplierProductArr=$db->GetRow($getSupplierProductSQL); if (!is_array($getSupplierProductArr)) { writeLog("Supplier service details could not be retrieved. SQL: ".$getSupplierProductSQL, 'events', 10); return; } $VALUES['suppliersServicesDetails'][$idSupplierProduct]['productName']=$getSupplierProductArr['productName']; $VALUES['suppliersServicesDetails'][$idSupplierProduct]['serviceCode']=$getSupplierProductArr['serviceCode']; $VALUES['suppliersServicesDetails'][$idSupplierProduct]['destinationCountryCode']=$getSupplierProductArr['destinationCountryCode']; $VALUES['suppliersServicesDetails'][$idSupplierProduct]['destinationCityId']=$getSupplierProductArr['destinationCityId']; $VALUES['suppliersServicesDetails'][$idSupplierProduct]['category']=$getSupplierProductArr['category']; return $VALUES['suppliersServicesDetails'][$idSupplierProduct]; } 