require 'config/globalconfig.php'; $_SESSION[global_common::SES_C_CUR_PAGE] = "post_article.php"; include_once 'include/_permission.inc'; include_once 'include/_header.inc'; include_once 'class/model_articletype.php'; include_once 'class/model_article.php'; include_once 'class/model_comment.php'; include_once 'class/model_user.php'; 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;
* This file was automatically generated By Code Smith * Modifications will be overwritten when code smith is run * * PLEASE DO NOT MAKE MODIFICATIONS TO THIS FILE * Date Created 5/6/2012 * */ /// <summary> /// Implementations of sldistricts represent a District /// /// </summary> chdir(".."); /* TODO: Add code here */ require 'config/globalconfig.php'; include_once 'class/model_district.php'; $objDistrict = new Model_District($objConnection); if ($_pgR["act"] == model_District::ACT_ADD) { if (global_common::isCLogin()) { //get user info //$c_userInfo = $_SESSION[consts::SES_C_USERINFO]; //if ($objMenu->getMenuByName($_pgR['name'])) { // echo global_common::convertToXML($arrHeader, array("rs",'info'), array(0,global_common::STRING_NAME_EXIST), array(0,1)); // return; //} $districID = $_pgR[global_mapping::DistrictD]; $districID = global_editor::rteSafe(html_entity_decode($districID, ENT_COMPAT, 'UTF-8')); $districtName = $_pgR['DistrictName']; $districtName = global_editor::rteSafe(html_entity_decode($districtName, ENT_COMPAT, 'UTF-8')); $cityID = $_pgR['CityID']; $cityID = global_editor::rteSafe(html_entity_decode($cityID, ENT_COMPAT, 'UTF-8')); $status = $_pgR['Status'];
<?php /* TODO: Add code here */ require 'config/globalconfig.php'; include_once 'class/model_store.php'; include_once 'class/model_articletype.php'; include_once 'class/model_storecategory.php'; include_once 'class/model_city.php'; include_once 'class/model_district.php'; $objArticleType = new Model_ArticleType($objConnection); $objCity = new Model_City($objConnection); $objDistrict = new Model_District($objConnection); $objStore = new Model_Store($objConnection); $objStoreCategory = new Model_Storecategory($objConnection); $folder = global_common::FOLDER_FILES_OTHER . '/Foody/'; $fileCat = $folder . 'All_Foody_Categories.txt'; if ($_pgR["act"] == "import") { echo $fileCat; echo '<br>'; $jsonCats = global_common::readFromFile($fileCat); $rootCats = json_decode($jsonCats, true); $cats = $rootCats['allCategories']; //print_r($cats); $createdBy = 11111; $updatedBy = 11111; foreach ($cats as $cat) { //print_r($cat); //return; $catName = $cat['Name']; $checkExisted = $objArticleType->getArticleTypeByName($catName); //print_r($checkExisted); ;
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; }