public function getStoresByCatID($objID, $selectField = '*') { $objCatStore = new Model_Storecategory($this->_objConnection); $arrCatStore = $objCatStore->getStorecategoryByCatID($objID); $arrStoreIDs = global_common::getArrayColumn($arrCatStore, global_mapping::StoreID); $strQueryStoreIN = global_common::convertToQueryIN($arrStoreIDs); $selectField = $selectField ? $selectField : '*'; $strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, self::TBL_SL_STORE, 'WHERE StoreID IN (' . $strQueryStoreIN . ') ')); //echo '<br>SQL:'.$strSQL; $arrResult = $this->_objConnection->selectCommand($strSQL); if (!$arrResult) { global_common::writeLog('get sl_store ByID:' . $strSQL, 1, $_mainFrame->pPage); return null; } return $arrResult; }