public function getProductPriceByProduct($objID, $selectField = '*')
{
$selectField = $selectField ? $selectField : '*';
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, self::TBL_SL_PRODUCT_PRICE, 'WHERE ProductID = \'' . $objID . '\' '));
//echo '<br>SQL:'.$strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get sl_product_price ByID:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
$objStatus = new Model_Status($this->_objConnection);
$allStatus = $objStatus->getAllStatus();
$statuses = array();
foreach ($allStatus as $key => $info) {
$statuses[$info[global_mapping::StatusID]] = $info;
unset($allStatus[$key]);
}
//print_r($statuses);
$count = count($arrResult);
for ($index = 0; $index < $count; $index++) {
//print_r($statuses[$arrResult[$index][global_mapping::TypeID]]);
if ($statuses[$arrResult[$index][global_mapping::TypeID]]) {
$pathCode = $statuses[$arrResult[$index][global_mapping::TypeID]][global_mapping::ExtraInfo];
//echo$arrResult[$index][global_mapping::ProductLink];
try {
$arrResult[$index][global_mapping::Price] = global_common::getPriceFromURL($arrResult[$index][global_mapping::ProductLink], $pathCode);
} catch (Exception $ex) {
//$arrResult[$index]
}
}
}
//print_r($arrResult);
return $arrResult;
}