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