include_once 'class/model_city.php'; include_once 'class/model_district.php'; include_once 'class/model_partner.php'; $objPartner = new Model_Partner($objConnection); $objArticle = new Model_Article($objConnection); $objArticleType = new Model_ArticleType($objConnection); $objCity = new Model_City($objConnection); $objDistrict = new Model_District($objConnection); $intMode = 0; //add mode $parentTypes = $objArticleType->getAllArticleType(0, null, 'ParentID=0', 'Level'); $allTypes = $objArticleType->getAllArticleType(0, null, 'ParentID=' . $parentTypes[0][global_mapping::ArticleTypeID], 'Level'); $allCities = $objCity->getAllCity(); //echo 'get city:'; //echo($allCities); $allDistricts = $objDistrict->getAllDistrict(); $currentPartner = $objPartner->getPartnerByUserID($_SESSION[global_common::SES_C_USERINFO][global_mapping::UserID]); if ($_pgR["aid"]) { //reset partner info $currentPartner = null; $articleID = $_pgR["aid"]; $article = $objArticle->getArticleByID($articleID); $intMode = 1; //edit mode $createBy = $article[global_mapping::CreatedBy]; $currentUserID = $_SESSION[global_common::SES_C_USERINFO][global_mapping::UserID]; if ($createBy != $currentUserID) { global_common::redirectByScript("index.php"); return; } //print_r($article[global_mapping::ArticleID]);
public function getStoreByIDs($arrIDs) { $arrIDs = global_common::splitString($arrIDs); $strQueryIN = global_common::convertToQueryIN($arrIDs); if ($strQueryIN) { $strQueryIN = global_mapping::StoreID . ' IN (' . $strQueryIN . ')'; } else { $strQueryIN = '1=1'; } $whereClause = 'WHERE ' . $strQueryIN; $strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array('*', self::TBL_SL_STORE, $whereClause . ' ' . ' limit 0,' . self::NUM_PER_PAGE)); //echo $strSQL; $arrResult = $this->_objConnection->selectCommand($strSQL); if (!$arrResult) { global_common::writeLog('get getProductByIDs:' . $strSQL, 1, $_mainFrame->pPage); return null; } $objCity = new Model_City($this->_objConnection); $objDistrict = new Model_District($this->_objConnection); $tempVarCities = $objCity->getAllCity(); $allCities = null; foreach ($tempVarCities as $key => $info) { $allCities[$info[global_mapping::CityID]] = $info; unset($tempVarCities[$key]); } $tempDistricts = $objDistrict->getAllDistrict(); $allDistricts = null; foreach ($tempDistricts as $key => $info) { $allDistricts[$info[global_mapping::DistrictID]] = $info; unset($tempDistricts[$key]); } // print_r($allDistricts); // return; $count = count($arrResult); $objArticle = new Model_Article($this->_objConnection); for ($i = 0; $i < $count; $i++) { //echo $arrResult; //print_r( $allCities); //$arrResult[$i][global_mapping::CityID] = $allCities[$arrResult[$i][global_mapping::CityID]]; $arrResult[$i][global_mapping::CityName] = $allCities[$arrResult[$i][global_mapping::CityID]][global_mapping::CityName]; // print_r($arrResult[$i]); //return; // print_r($allCities[$arrResult[$i][global_mapping::CityID]]); //break; $arrResult[$i][global_mapping::DistrictName] = $allDistricts[$arrResult[$i][global_mapping::DistrictID]][global_mapping::DistrictName]; $arrResult[$i][global_mapping::Latitude] = global_common::convertToDecimal($arrResult[$i][global_mapping::Latitude]); $arrResult[$i][global_mapping::Longitude] = global_common::convertToDecimal($arrResult[$i][global_mapping::Longitude]); $arrArticle = $objArticle->getArticleByStoreID($arrResult[$i][global_mapping::StoreID]); $shortDescription = global_common::formatPlanText($arrArticle[0][global_mapping::Content]); $arrResult[$i][global_mapping::Content] = global_common::cutString2($shortDescription, 0, 16); // print_r($arrResult[$i]); //echo $arrResult[$i][global_mapping::DistrictID]; //echo $allDistricts[$arrResult[$i][global_mapping::DistrictID]][global_mapping::DistrictName]; //print_r($allDistricts); //return ; } //print_r($stores); return $arrResult; }