PHP Model_Storecategory::getStorecategoryByCatID Examples

Example #1

File: model_store.php Project: vietlethanh/KooKooBackEnd

 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;
 }