PHP Decode

include_once $_PATH["LIB"]."/class.Modules.php"; class Product extends ModulePrc { function __construct($sCode=""){ global $tb,$_Site,$DB,$_PATH,$_URL, $_Page; $this->_Tables = array( "data"=>"CS_PRODUCT_DATA", "files"=>$tb["module_files"], "conf"=>$tb["module_conf"], "cate"=>$tb["module_cate"], "catefiles"=>"CS_MODULE_CATE_FILES", ); $this->_Site = &$_Site; $this->DB = &$DB; $this->getFld["langfld"]=""; $this->getFld["data"]= "*,

		".$this->DB->getDatetypeStr("reg_date")." as reg_date,
		case
		when ".$this->DB->dateIsNullCheckStr("modify_date")." then ".$this->DB->getDatetypeStr("reg_date")."
		when ".$this->DB->dateIsNullCheckStr("modify_date",false)." then ".$this->DB->getDatetypeStr("modify_date")."
		end as modify_date
		"; if($_REQUEST["dMode"] == "D"){ $this->dMode = true; }else{ $this->dMode = false; } $this->init("Product",$sCode); } function getConfig(){ unset($this->config); parent::getConfig(); } function getLangFldQuery($lang="K"){ if($lang=="K") $_cLang = ""; else $_cLang = $lang; return $this->getFld["data"]; } function getFieldLabel($fld,$lang=""){ global $_PRC_MD_LANG_TXT; if($lang=="") $lang = $GLOBALS["_Site"]->cfg["lang"]; return $_PRC_MD_LANG_TXT["PROD_LBL_FLD"][$fld][$lang]; } function getDataRow($idx,$lang="K"){ $IDX = (int)$idx; if($IDX<= 0) return null; $getFld = $this->getLangFldQuery($lang); $qry ="select ".$getFld." from ".$this->_Tables["data"]." where idx=".$IDX; $DATA = $this->DB->sql_fetch($qry); $qry ="select ".$getFld." from ".$this->_Tables["data"]." where lang = '" . $lang . "' and idx < ".$IDX. " and CgCode = '".$DATA["CgCode"]."' order by idx desc limit 0, 1"; $DATA["preData"] = $this->DB->sql_fetch($qry); $qry ="select ".$getFld." from ".$this->_Tables["data"]." where lang = '" . $lang . "' and idx > ".$IDX. " and CgCode = '".$DATA["CgCode"]."' order by idx asc limit 0, 1"; $DATA["nextData"] = $this->DB->sql_fetch($qry); return $DATA; } function getData($DATA,$lang="K",$CONT_OPT=false){ global $DB,$_URL,$_PATH; $_lang = ($lang!="K")? $lang : ""; $DATA["cateName"] = $this->getCategoryName($DATA["CgCode"]); $DATA["uploadpath"] = $this->uploadPath.getDirAsbPath($_PATH["ROOT"].$DATA["filepath"],$this->uploadPath); $DATA["uploadurl"] = $this->uploadUrl."/"; $imfiles = array("limg","pcont1_img","pcont2_img","pcont3_img","pcont4_img","pcont5_img","pcont6_img","pcont7_img"); foreach($imfiles as $fi){ if($DATA["".$fi."_name"]!="" && file_exists($DATA["uploadpath"]. $DATA["".$fi."_name"])){ $DATA["".$fi."_url"] = $DATA["uploadurl"] . $DATA["".$fi."_name"]; $DATA["".$fi."_path"] = $DATA["uploadpath"] . $DATA["".$fi."_name"]; $DATA["".$fi."_imsize"] = @getimagesize($DATA["uploadpath"] . $DATA["".$fi."_name"]); $DATA["".$fi."_alt"] = $DATA[$fi."_alt"]? $DATA[$fi."_alt"] : ""; } } $DATA["print_content"] = WebApp::getContent($DATA["content"],"E"); $DATA["print_title"] = WebApp::getContent($DATA["title"],"T"); $DATA["print_date"] = ""; $DATA["print_date_s"] =""; $DATA["print_date"] = $DATA["print_adm_date"] = $DATA["year"].""; if($DATA["month"] && $DATA["month"]!="00"){ $DATA["print_date"] .= " " .$DATA["month"]."."; $DATA["print_date_s"] .= ". " .$DATA["month"].""; $DATA["print_adm_date"] .= " " .$DATA["month"]."."; } if($DATA["pdate"]) $DATA["print_date"] = preg_replace("/|/",".",$DATA["pdate"]); $DATA["isDel"] =($DATA["isDel"]=="1")? true:false; $DATA["isShare"] =($DATA["isShare"]=="1")? true:false; if($CONT_OPT){ $MULTI_FILES = array("vimg"); foreach($MULTI_FILES as $_k=>$_fn){ $DATA[$_fn."_files"]= $this->getFiles($this->ModuleId.".".$_fn,$DATA["idx"]); $vfilesTotal = count($DATA[$_fn."_files"]); for($i=0;$i<$vfilesTotal;$i++){ $_files = &$DATA[$_fn."_files"][$i]; $_files["org_url"] = setUrlQuerystr($GLOBALS["link_href"]["action"],"mode=fv&sfld=".$_fn."&".$_files["link_vars"]) ; $_files["th_url"] =setUrlQuerystr($GLOBALS["link_href"]["action"],"mode=fth&sfld=".$_fn."&".$_files["link_vars"]) ; } } } return $DATA; } function getCategoryCodeValueList(){ if(!isset($this->categoryCodeList) || $this->categoryCodeList==null){ $categoryList = $this->_CD->getCategoryLabels($this->cateGroupCD,'sc_code'); if(count($categoryList[$this->cateGroupCD])>0){ foreach($categoryList[$this->cateGroupCD] as $_code=>$_nm){ $this->categoryCodeList[$_code] = $_nm; } } } } function getCategoryName($CODE=""){ if($CODE=="") RETURN $CODE; $this->getCategoryCodeValueList(); return $this->categoryCodeList[$CODE]; } function checkFormData($mode,$R_DATA,$errMsgType=""){ } function insertData($R_DATA,$FILES=NULL){ GLOBAL $_PATH; $DB = &$this->DB; $MULTI_FILES = array("vimg"); foreach($MULTI_FILES as $i=>$filekey){ $_fn = $MULTI_FILES[$i] ; IF(isset($R_DATA[$_fn."_info"])){ $UP_FILE[$_fn] = reArrayFilesFromOrgFiles($R_DATA[$_fn."_info"],$FILES[$_fn.""],$R_DATA[$_fn."_text"]); IF(ISSET($FILES["add_".$filekey])){ $ADD_FILES = reArrayFiles($FILES["add_".$filekey]); $add_p = $R_DATA["add_".$filekey."_to"]; foreach($ADD_FILES as $_addFiles){ $add_p++; $UP_FILE[$_fn.""][$add_p] = $_addFiles; } } } else{ $UP_FILE[$_fn.""] = reArrayFiles($FILES[$_fn.""],$R_DATA[$_fn."_text"]); } } $DATA = $this->setShareSiteFormData($R_DATA); $DATA["share_site"] = ""; $DATA["lang"] = strtoupper($R_DATA["lang"]); $DATA["CgCode"] = $R_DATA["CgCode"]; $DATA["year"] = sprintf("%04d",$R_DATA["year"]); $DATA["month"] = $R_DATA["month"]? sprintf("%02d",$R_DATA["month"]) : ""; $DATA["title"] = $R_DATA["title"]; $DATA["content_name"] = $R_DATA["content_name"]; $DATA["content"] = $R_DATA["content"]; $DATA["pcont1_name"] = $R_DATA["pcont1_name"]; $DATA["pcont1"] = $R_DATA["pcont1"]; $DATA["pcont1_dir"] = $R_DATA["pcont1_dir"]; $DATA["pcont2_name"] = $R_DATA["pcont2_name"]; $DATA["pcont2"] = $R_DATA["pcont2"]; $DATA["pcont2_dir"] = $R_DATA["pcont2_dir"]; $DATA["pcont3_name"] = $R_DATA["pcont3_name"]; $DATA["pcont3"] = $R_DATA["pcont3"]; $DATA["pcont3_dir"] = $R_DATA["pcont3_dir"]; $DATA["pcont4_name"] = $R_DATA["pcont4_name"]; $DATA["pcont4"] = $R_DATA["pcont4"]; $DATA["pcont4_dir"] = $R_DATA["pcont4_dir"]; $DATA["pcont5_name"] = $R_DATA["pcont5_name"]; $DATA["pcont5"] = $R_DATA["pcont5"]; $DATA["pcont5_dir"] = $R_DATA["pcont5_dir"]; $DATA["pcont6_name"] = $R_DATA["pcont6_name"]; $DATA["pcont6"] = $R_DATA["pcont6"]; $DATA["pcont6_dir"] = $R_DATA["pcont6_dir"]; $DATA["pcont7_name"] = $R_DATA["pcont7_name"]; $DATA["pcont7"] = $R_DATA["pcont7"]; $DATA["pcont7_dir"] = $R_DATA["pcont7_dir"]; $DATA["dev_menu_code"] = $R_DATA["dev_menu_code"]; $DATA["ser_menu_code"] = $R_DATA["ser_menu_code"]; $DATA["ser_menu_code_e"] = $R_DATA["ser_menu_code_e"]; $DATA["isUse"] = ($R_DATA["isUse"]==1)?"1":"0"; IF(ISSET($R_DATA["sortnum"])) $DATA["sortnum"] =(int)$R_DATA["sortnum"]; $DATA["reg_date"] = $DB->getNowDateTimeStr(); $DATA["reg_ip"] =$_SERVER["REMOTE_ADDR"]; $DATA["reg_user_id"] = $this->memInfo["user_id"]; $flist = array("limg"); $fileExt = Array("pdf"); $_uploadPath = $this->uploadPath; $DATA["filepath"] = getDirAsbPath($this->uploadUrl,$_PATH["ROOT"]); for($i=0; $i<count($flist);$i++){ $fname = &$flist[$i]; if ($FILES[$fname]["name"] && ( $FILES[$fname]["size"]<1 || !checkExt($FILES[$fname]["name"] ,$fileExt[$i]) ) ){ $resultArr = array("result"=>false,"resultId"=>"","errMsg"=>$FILES[$fname]["name"] ."  .
  ."); return $resultArr; } } for($fi=0; $fi<count($flist);$fi++){ $fname = &$flist[$fi]; if ($FILES[$fname]["name"] && $FILES[$fname]["size"]>0){ if(checkExt($FILES[$fname]["name"] ,$fileExt[$fi])){ $fileExt = getFileExt($FILES[$fname]["name"]); $newFileName = md5(mktime().$FILES[$fname]["name"]).".".$fileExt; $DATA[$fname."_org"] = $FILES[$fname]["name"]; $DATA[$fname."_info"] = $FILES[$fname]["type"]; $DATA[$fname."_name"] = $newFileName; $DATA[$fname."_alt"] = $R_DATA[$fname."_alt"] ; if($DATA[$fname."_name"]=="" || $saveFile<0){ unset($DATA[$fname."_org"],$DATA[$fname."_info"]); } } else{ $resultArr = array("result"=>false,"resultId"=>"","errMsg"=>"  .
  .?"); return $resultArr; } } } $LIMIT_FILE["file_size"] = $this->config["file_size"]; $LIMIT_FILE["file_total_size"] =$this->config["file_size"] * 10; $LIMIT_FILE["file_ext"] = explode(",",_CS_FILE_UPLOAD_IMG_EXT_); foreach($MULTI_FILES as $i=>$filekey){ $_fn = $MULTI_FILES[$i] ; $FILE_ERR = fileCheck($UP_FILE[$_fn],$LIMIT_FILE); if ($FILE_ERR) { $resultArr = array("result"=>false,"resultId"=>$R_DATA["idx"],"errMsg"=>$FILE_ERR); return $resultArr; exit; } } $qry = $DB->insertQuery($this->_Tables["data"],$DATA); $result = $DB->dbQuery($qry); if($result){ $this_id = $DB->getInsertId(); $FILE_DATA["idx"] = $this_id; foreach($MULTI_FILES as $i=>$filekey){ $_fn = $MULTI_FILES[$i] ; $FILE_DATA["file_info"]= $R_DATA[$_fn."_info"]; $FILE_DATA["del_file"]= $R_DATA[$_fn."_del_file"]; $FILE_DATA["del_fidx"]= $R_DATA["del_fidx"]; $FILE_DATA["file_code"] = $this->ModuleId.".".$_fn; $this->updateFileData($UP_FILE[$_fn],$FILE_DATA,$FILE_DATA["file_code"]); } } $mnRst = $this->menuConnect($DATA, "view", $_REQUEST["tmpCgCode2"], $this_id); $resultArr = array("result"=>$result,"resultId"=>$this_id,"errMsg"=>$errMsg,"toData"=>$DATA); return $resultArr; } function updateData($R_DATA,$FILES=NULL){ $DB = &$this->DB; $err_msg =""; $MULTI_FILES = array("vimg"); foreach($MULTI_FILES as $i=>$filekey){ $_fn = $MULTI_FILES[$i] ; IF(isset($R_DATA[$_fn."_info"])){ $UP_FILE[$_fn] = reArrayFilesFromOrgFiles($R_DATA[$_fn."_info"],$FILES[$_fn.""],$R_DATA[$_fn."_text"]); IF(ISSET($FILES["add_".$filekey])){ $ADD_FILES = reArrayFiles($FILES["add_".$filekey]); $add_p = $R_DATA["add_".$filekey."_to"]; foreach($ADD_FILES as $_addFiles){ $add_p++; $UP_FILE[$_fn.""][$add_p] = $_addFiles; } } } else{ $UP_FILE[$_fn.""] = reArrayFiles($FILES[$_fn.""],$R_DATA[$_fn."_text"]); } } $LIMIT_FILE["file_size"] = $this->config["file_size"]; $LIMIT_FILE["file_total_size"] =$this->config["file_size"] * 10; $LIMIT_FILE["file_ext"] = explode(",",_CS_FILE_UPLOAD_IMG_EXT_); foreach($MULTI_FILES as $i=>$filekey){ $_fn = $MULTI_FILES[$i] ; $FILE_ERR = fileCheck($UP_FILE[$_fn],$LIMIT_FILE); if ($FILE_ERR) { $resultArr = array("result"=>false,"resultId"=>$R_DATA["idx"],"errMsg"=>$FILE_ERR); return $resultArr; exit; } } $orgData = $DB->sql_fetch("select * from ".$this->_Tables["data"]." where idx='".$R_DATA["idx"]."'"); $DATA = $this->setShareSiteFormData($R_DATA,"update"); $DATA["share_site"] = ""; if(isset($R_DATA["CgCode"])) $DATA["CgCode"] = $R_DATA["CgCode"]; $DATA["lang"] = strtoupper($R_DATA["lang"]); $DATA["title"] = $R_DATA["title"]; $DATA["year"] = sprintf("%04d",$R_DATA["year"]); $DATA["month"] = $R_DATA["month"]? sprintf("%02d",$R_DATA["month"]) : ""; $DATA["content_name"] = $R_DATA["content_name"]; $DATA["content"] = $R_DATA["content"]; $DATA["pcont1_name"] = $R_DATA["pcont1_name"]; $DATA["pcont1"] = $R_DATA["pcont1"]; $DATA["pcont1_dir"] = $R_DATA["pcont1_dir"]; $DATA["pcont2_name"] = $R_DATA["pcont2_name"]; $DATA["pcont2"] = $R_DATA["pcont2"]; $DATA["pcont2_dir"] = $R_DATA["pcont2_dir"]; $DATA["pcont3_name"] = $R_DATA["pcont3_name"]; $DATA["pcont3"] = $R_DATA["pcont3"]; $DATA["pcont3_dir"] = $R_DATA["pcont3_dir"]; $DATA["pcont4_name"] = $R_DATA["pcont4_name"]; $DATA["pcont4"] = $R_DATA["pcont4"]; $DATA["pcont4_dir"] = $R_DATA["pcont4_dir"]; $DATA["pcont5_name"] = $R_DATA["pcont5_name"]; $DATA["pcont5"] = $R_DATA["pcont5"]; $DATA["pcont5_dir"] = $R_DATA["pcont5_dir"]; $DATA["pcont6_name"] = $R_DATA["pcont6_name"]; $DATA["pcont6"] = $R_DATA["pcont6"]; $DATA["pcont6_dir"] = $R_DATA["pcont6_dir"]; $DATA["pcont7_name"] = $R_DATA["pcont7_name"]; $DATA["pcont7"] = $R_DATA["pcont7"]; $DATA["pcont7_dir"] = $R_DATA["pcont7_dir"]; $DATA["dev_menu_code"] = $R_DATA["dev_menu_code"]; $DATA["ser_menu_code"] = $R_DATA["ser_menu_code"]; $DATA["ser_menu_code_e"] = $R_DATA["ser_menu_code_e"]; $DATA["isUse"] = ($R_DATA["isUse"]==1)?"1":"0"; IF(ISSET($R_DATA["sortnum"])) $DATA["sortnum"] =(int)$R_DATA["sortnum"]; $flist = array("vimg"); $fileExt = Array(array("jpg", "gif", "png")); $_uploadPath = $this->uploadPath; $DATA["filepath"] = getDirAsbPath($this->uploadUrl,$_PATH["ROOT"]); for($i=0; $i<count($flist);$i++){ $fname = &$flist[$i]; if(is_array($FILES[$fname]["name"])){ foreach($FILES[$fname]["name"] as $k => $v){ if ($v && ( $FILES[$fname]["size"][$k]<1 || !checkExt($v ,$fileExt[0]))){ $resultArr = array("result"=>false,"resultId"=>"","errMsg"=>"  .
  ."); return $resultArr; } } } } for($i=0; $i<count($flist);$i++){ $fname = &$flist[$i]; if ($orgData[$fname."_name"] && ($R_DATA["del_".$fname] ||($FILES[$fname]["name"] && $FILES[$fname]["size"]>0))){ $filePath = $_PATH["ROOT"].$orgData["filepath"]; @unlink($filePath."/".$orgData[$fname."_name"]); $DATA[$fname."_org"] = ""; $DATA[$fname."_info"] = ""; $DATA[$fname."_name"] =""; $DATA[$fname."_alt"] = "" ; } if(is_array($FILES[$fname]["name"])){ foreach($FILES[$fname]["name"] as $k => $v){ if(checkExt($v ,$fileExt[0])){ $fileExt = getFileExt($v); $newFileName = md5(mktime().$i.$v).".".$fileExt; $DATA[$fname."_org"] = $v; $DATA[$fname."_info"] = $FILES[$fname]["type"][$k]; $tmpFile["tmp_name"] = $FILES[$fname]["tmp_name"][$k]; $tmpFile["size"] = $FILES[$fname]["size"][$k]; $DATA[$fname."_name"] = $newFileName; $DATA[$fname."_alt"] = $R_DATA[$fname."_alt"] ; if($DATA[$fname."_name"]=="" || (int)($DATA[$fname."_name"])<=0 || $fname!="limg"){ unset($DATA[$fname."_org"],$DATA[$fname."_info"]); } } } } } $DATA["modify_date"] = $DB->getNowDateTimeStr(); $DATA["modify_ip"] =$_SERVER["REMOTE_ADDR"]; $DATA["modify_user_id"] = $this->memInfo["user_id"]; $qry = $DB->updateQuery($this->_Tables["data"],$DATA,"idx=".$R_DATA["idx"].""); $result = $DB->dbQuery($qry); $FILE_DATA["idx"] = $R_DATA["idx"]; $FILE_DATA["file_info"]= $R_DATA["file_info"]; $FILE_DATA["del_file"]= $R_DATA["del_file"]; $FILE_DATA["del_fidx"]= $R_DATA["del_fidx"]; foreach($MULTI_FILES as $i=>$filekey){ $_fn = $MULTI_FILES[$i] ; $FILE_DATA["file_info"]= $R_DATA[$_fn."_info"]; $FILE_DATA["del_file"]= $R_DATA[$_fn."_del_file"]; $FILE_DATA["del_fidx"]= $R_DATA["del_fidx"]; $FILE_DATA["file_code"] = $this->ModuleId.".".$_fn; $this->updateFileData($UP_FILE[$_fn],$FILE_DATA,$FILE_DATA["file_code"]); } $mnRst = $this->menuConnect($DATA, "view", $_REQUEST["tmpCgCode2"], $R_DATA["idx"]); $resultArr = array("result"=>true,"resultId"=>$R_DATA["idx"],"errMsg"=>$errMsg,"toData"=>$DATA,"orgData"=>$orgData); return $resultArr; } function menuConnect($DATA, $mType="view", $cate = array(), $idx = ""){ global $DB, $_Menu; if(is_array($cate)){ $cate = $cate[1]; } if($cate){ $param[] = "cate=" . $cate; } if($idx){ $param[] = "idx=" . $idx; } if(count($param) > 0){ $parameta = implode("&", $param); }else{ return false; } switch($DATA["lang"]){ case "E": $site_code = "eng"; $mn_code = $DATA["ser_menu_code_e"]; break; case "J": $site_code = "jpn"; break; case "C": $site_code = "chn"; break; default: $site_code = "kr"; $mn_code = $DATA["ser_menu_code"]; break; } if(trim($mn_code)){ $MEMU_DATA["mn_type"] = "P"; $MEMU_DATA["mn_module_code"] = "Product"; $MEMU_DATA["mn_module_mode"] = $mType; $MEMU_DATA["mn_module_prm"] = $parameta; $tmpFld = array(); foreach($MEMU_DATA as $k => $v){ $tmpFld[] = $k . " = '" . $v . "'"; } $field = implode(", ", $tmpFld); $tmpWhere[] = "mn_code = '" . $mn_code . "'"; $tmpWhere[] = "site_code = '" . $site_code . "'"; $where = implode(" and ", $tmpWhere); $upqry = "update CS_SITE_MENU set " . $field . " where " . $where; $DB->dbQuery($upqry); $_Menu = new Menu($site_code); $_Menu->writeMenuData($site_code,$mn_code); } return true; } function deleteData($idx,$where=""){ global $DB; if($where=="") $where = "where idx='".$idx."'"; else $where = " where ".$where; $delDatas = $DB->getRows("select * from ".$this->_Tables["data"]." ".$where); $DB->dbQuery("delete from ".$this->_Tables["data"]." where idx='".$idx."'" ); } function delStateData($R_DATA,$delState,$where=""){ global $DB; if($delState){ $DATA["isDel"] = 1; $DATA["del_date"] = $DB->getNowDateTimeStr(); $DATA["del_ip"] =$_SERVER["REMOTE_ADDR"]; $DATA["del_user_id"] =$this->memInfo["user_id"]; } else{ $DATA["isDel"] = 0; $DATA["del_date"] =""; $DATA["del_ip"] =""; $DATA["del_user_id"] = ""; $DATA["modify_date"] = $DB->getNowDateTimeStr(); $DATA["modify_ip"] =$_SERVER["REMOTE_ADDR"]; $DATA["modify_user_id"] =$this->memInfo["user_id"]; } if($where=="" && $R_DATA["idx"]){ $where = "idx='".$R_DATA["idx"]."'"; } $qry = $DB->updateQuery($this->_Tables["data"],$DATA,$where); $result = $DB->dbQuery($qry); $resultArr = array("result"=>$result,"resultId"=>$R_DATA["idx"],"errMsg"=>$errMsg); return $resultArr; } function changeState($idx, $setState){ global $DB; $DATA["isUse"] = $setState; $DATA["modify_Date"] = $DB->getNowDateTimeStr(); $DATA["modify_ip"] = $_SERVER["REMOTE_ADDR"]; $DATA["modify_user_id"] = $this->memInfo["user_id"]; $qry = $DB->updateQuery($this->_Tables["data"],$DATA,"idx='".$idx."'"); $result = $DB->dbQuery($qry); $resultArr = array("result"=>$result,"resultId"=>$idx,"errMsg"=>$errMsg); return $resultArr; } function &moveCateData($idx,$CgCode){ if ((int)$idx<=0){ return false; } $DATA["CgCode"] = $CgCode; $qry = $this->DB->updateQuery($this->_Tables["data"],$DATA," idx='".$idx."'"); if ($qry) $result =$this->DB->dbQuery($qry); return $result; } function insertCategory($R_DATA,$R_FILES=NULL,$OPT = NULL){ $FILES = $_FILES; $CATA_DATA["group"] = $this->cateGroupCD; $CATA_DATA["sc_name"] = $R_DATA["sc_name"]; $CATA_DATA["sc_name_e"] = $R_DATA["sc_name_e"]; $CATA_DATA["sc_name_j"] = $R_DATA["sc_name_j"]; $CATA_DATA["sc_name_c"] = $R_DATA["sc_name_c"]; $CATA_DATA["sc_content"] = $R_DATA["sc_content"]; $CATA_DATA["dev_menu_code"] = $R_DATA["dev_menu_code"]; $CATA_DATA["ser_menu_code"] = $R_DATA["ser_menu_code"]; $CATA_DATA["sc_content_e"] = $R_DATA["sc_content_e"]; $CATA_DATA["ser_menu_code_e"] = $R_DATA["ser_menu_code_e"]; $MAKE_CODE_LEN = $OPT["code_len"]? $OPT["code_len"] : 3; $CATA_DATA["sc_code"] = ($R_DATA["sc_code"])? $R_DATA["sc_code"] : $this->_CD->makeCateCode($this->cateGroupCD,$MAKE_CODE_LEN); $CATA_DATA["sc_use"] = ($R_DATA["sc_use"]=="Y")? "Y" : "N"; IF($R_DATA["parentKey"]){ $CATA_DATA["parent_key"] = $R_DATA["parentKey"]; } $cateArr = $this->_CD->categoryInsert($CATA_DATA,$R_FILES,$OPT["add_field"]); $err_msg =""; $MULTI_FILES = array("vimg"); foreach($MULTI_FILES as $i=>$filekey){ $_fn = $MULTI_FILES[$i] ; IF(isset($R_DATA[$_fn."_info"])){ $UP_FILE[$_fn] = reArrayFilesFromOrgFiles($R_DATA[$_fn."_info"],$FILES[$_fn.""],$R_DATA[$_fn."_text"]); IF(ISSET($FILES["add_".$filekey])){ $ADD_FILES = reArrayFiles($FILES["add_".$filekey]); $add_p = $R_DATA["add_".$filekey."_to"]; foreach($ADD_FILES as $_addFiles){ $add_p++; $UP_FILE[$_fn.""][$add_p] = $_addFiles; } } } else{ $UP_FILE[$_fn.""] = reArrayFiles($FILES[$_fn.""],$R_DATA[$_fn."_text"]); } } $LIMIT_FILE["file_size"] = $this->config["file_size"]; $LIMIT_FILE["file_total_size"] =$this->config["file_size"] * 10; $LIMIT_FILE["file_ext"] = explode(",",_CS_FILE_UPLOAD_IMG_EXT_); foreach($MULTI_FILES as $i=>$filekey){ $_fn = $MULTI_FILES[$i] ; $FILE_ERR = fileCheck($UP_FILE[$_fn],$LIMIT_FILE); if ($FILE_ERR) { $resultArr = array("result"=>false,"resultId"=>$R_DATA["idx"],"errMsg"=>$FILE_ERR); return $resultArr; exit; } } $FILE_DATA["parentIDX"]= $cateArr["sc_code"]; $FILE_DATA["file_info"]= $cateArr["file_info"]; foreach($MULTI_FILES as $i=>$filekey){ $_fn = $MULTI_FILES[$i] ; $FILE_DATA["file_code"]= $this->ModuleId.".cate.".$filekey; $FILE_DATA["file_info"]= $R_DATA[$_fn."_info"]; $FILE_DATA["del_file"]= $R_DATA[$_fn."_del_file"]; $this->updateCateFileData($UP_FILE[$_fn],$FILE_DATA,$FILE_DATA["file_code"]); } return $cateArr; } function updateCategory($R_DATA){ $DB = &$this->DB; $FILES = $_FILES; if(isset($R_DATA["idx"])) $CATA_DATA["idx"] = $R_DATA["idx"]; if(isset($R_DATA["code"])) $CATA_DATA["idx"] = $R_DATA["code"]; $err_msg =""; $MULTI_FILES = array("vimg"); foreach($MULTI_FILES as $i=>$filekey){ $_fn = $MULTI_FILES[$i] ; IF(isset($R_DATA[$_fn."_info"])){ $UP_FILE[$_fn] = reArrayFilesFromOrgFiles($R_DATA[$_fn."_info"],$FILES[$_fn.""],$R_DATA[$_fn."_text"]); IF(ISSET($FILES["add_".$filekey])){ $ADD_FILES = reArrayFiles($FILES["add_".$filekey]); $add_p = $R_DATA["add_".$filekey."_to"]; foreach($ADD_FILES as $_addFiles){ $add_p++; $UP_FILE[$_fn.""][$add_p] = $_addFiles; } } } else{ $UP_FILE[$_fn.""] = reArrayFiles($FILES[$_fn.""],$R_DATA[$_fn."_text"]); } } $LIMIT_FILE["file_size"] = $this->config["file_size"]; $LIMIT_FILE["file_total_size"] =$this->config["file_size"] * 10; $LIMIT_FILE["file_ext"] = explode(",",_CS_FILE_UPLOAD_IMG_EXT_); foreach($MULTI_FILES as $i=>$filekey){ $_fn = $MULTI_FILES[$i] ; $FILE_ERR = fileCheck($UP_FILE[$_fn],$LIMIT_FILE); if ($FILE_ERR) { $resultArr = array("result"=>false,"resultId"=>$R_DATA["idx"],"errMsg"=>$FILE_ERR); return $resultArr; exit; } } $FILE_DATA["idx"] = $R_DATA["idx"]; $FILE_DATA["parentIDX"]= $R_DATA["code"]; $FILE_DATA["file_info"]= $R_DATA["file_info"]; $FILE_DATA["del_file"]= $R_DATA["del_file"]; $FILE_DATA["del_fidx"]= $R_DATA["del_fidx"]; foreach($MULTI_FILES as $i=>$filekey){ $_fn = $MULTI_FILES[$i] ; $FILE_DATA["file_code"]= $this->ModuleId.".cate.".$filekey; $FILE_DATA["file_info"]= $R_DATA[$_fn."_info"]; $FILE_DATA["del_file"]= $R_DATA[$_fn."_del_file"]; $this->updateCateFileData($UP_FILE[$_fn],$FILE_DATA,$FILE_DATA["file_code"]); } $CATA_DATA["group"] = $this->cateGroupCD; $CATA_DATA["sc_name"] = $R_DATA["sc_name"]; $CATA_DATA["sc_name_e"] = $R_DATA["sc_name_e"]; $CATA_DATA["sc_name_j"] = $R_DATA["sc_name_j"]; $CATA_DATA["sc_name_c"] = $R_DATA["sc_name_c"]; $CATA_DATA["sc_use"] = ($R_DATA["sc_use"]=="Y")? "Y" : "N"; $CATA_DATA["sc_content"] = $R_DATA["sc_content"]; $CATA_DATA["dev_menu_code"] = $R_DATA["dev_menu_code"]; $CATA_DATA["ser_menu_code"] = $R_DATA["ser_menu_code"]; $CATA_DATA["sc_content_e"] = $R_DATA["sc_content_e"]; $CATA_DATA["ser_menu_code_e"] = $R_DATA["ser_menu_code_e"]; $result = $this->_CD->categoryUpdate($CATA_DATA); if($R_DATA["parentKey"]!=$R_DATA["o_parentKey"]){ $this->_CD->moveToParent($CATA_DATA,$R_DATA["o_parentKey"],$R_DATA["parentKey"]); } return Array("result"=>$result,"errMsg"=>"","resultId"=>$CATA_DATA["idx"]); } function deleteCategory($SC_CODE){ global $_PATH; $subCodeList = $this->_CD->getSubCateCodeList($this->cateGroupCD,$SC_CODE,"code"); $tmp = array(); if(count($subCodeList) > 0){ foreach($subCodeList as $k => $v){ $tmp[] = "'". $v["sc_code"] . "'"; } } $code = implode(",", $tmp); if($code){ $qry = "select * from " . $this->_Tables["catefiles"] . " where parentIDX in (" . $code . ")"; $fileList = $this->DB->getRows($qry); if(count($fileList) > 0){ foreach($fileList as $v){ $delFile = $_PATH["ROOT"].$v["filepath"]."/".$v["filename"]; if (file_exists($delFile)){ @unlink($delFile); } } } $qry = "delete from " . $this->_Tables["catefiles"] . " where parentIDX in (" . $code . ")"; $result = $this->DB->dbQuery($qry); } $delRst = $this->_CD->categoryDeleteFrCode($this->cateGroupCD,$SC_CODE,FALSE); return $delRst; } function updateCateFileData($UP_FILE,$R_DATA,$FILE_CODE=""){ global $DB, $_PATH; $F_DATA["Tables"] = $this->_Tables["catefiles"]; $F_DATA["file_code"] = ($FILE_CODE=="")? $this->ModuleId : $FILE_CODE; $F_DATA["parentIDX"] = $R_DATA["parentIDX"]; $F_DATA["upload_path"] = $this->uploadPath; $fi = 0; $_fnum = 1; if(COUNT($R_DATA["del_fidx"])>0){ $dfile_qry = "select * from ".$F_DATA["Tables"]." where file_code='".$F_DATA["file_code"]."' and parentIDX='".$R_DATA["idx"]."' and idx in (".@implode(",",$R_DATA["del_fidx"]).")"; $dfile_rst = $DB->dbQuery($dfile_qry); while($dfile_row = $DB->sql_fetch_array($dfile_rst)){ if($dfile_row["filename"] && is_file( $_PATH["ROOT"].$dfile_row["filepath"]."/".$dfile_row["filename"]) ) @unlink( $_PATH["ROOT"].$dfile_row["filepath"]."/".$dfile_row["filename"]); } $dfile_qry = "delete from ".$F_DATA["Tables"]." where file_code='".$F_DATA["file_code"]."' and parentIDX='".$R_DATA["idx"]."' and idx in (".@implode(",",$R_DATA["del_fidx"]).")"; $dfile_rst = $DB->dbQuery($dfile_qry); } if(count($UP_FILE)>0){ foreach($UP_FILE as $_idx => $tmpfile){ for ($fi = 0; $fi < count($UP_FILE);$fi++){ if ($R_DATA["file_info"][$_idx]){ $tmp_qry = "select * from ".$F_DATA["Tables"]." where file_code='".$F_DATA["file_code"]."' and parentIDX='".$R_DATA["parentIDX"]."' and idx='".$R_DATA["file_info"][$_idx]."'"; $tmp_row = $DB->sql_fetch($tmp_qry); $old_file = $_PATH["ROOT"].$tmp_row["filepath"]."/".$tmp_row["filename"]; $old_file_del = false; if ($R_DATA["del_file"][$_idx]){ $old_file_del = true; } if ($tmpfile["name"]!="" && !$tmpfile["error"]){ $F_DATA["num"] = $_idx; $F_DATA["idx"] = $R_DATA["file_info"][$_idx]; saveUpFiles($tmpfile,$F_DATA,"update"); $old_file_del = true; } if ($old_file_del) @unlink($old_file); $tmp_qry = "select * from ".$F_DATA["Tables"]." where file_code='".$F_DATA["file_code"]."' and parentIDX='".$R_DATA["parentIDX"]."' and idx='".$R_DATA["del_file"][$_idx]."'"; $tmp_row = $DB->sql_fetch($tmp_qry); if (!file_exists($_PATH["ROOT"].$tmp_row["filepath"]."/".$tmp_row["filename"])){ $tmp_qry = "delete from   ".$F_DATA["Tables"]." where file_code='".$F_DATA["file_code"]."' and parentIDX='".$R_DATA["parentIDX"]."' and idx='".$R_DATA["del_file"][$_idx]."'"; $DB->dbQuery($tmp_qry); } unset($FCONT_DATA); $FCONT_DATA["file_content"] = $tmpfile["file_content"]; $FCONT_DATA["num"] = $_fnum; $fcont_qry = $DB->updateQuery($F_DATA["Tables"],$FCONT_DATA,"file_code='".$F_DATA["file_code"]."' and parentIDX='".$R_DATA["parentIDX"]."' and idx='".$R_DATA["file_info"][$_idx]."'"); $DB->dbQuery($fcont_qry); $_fnum++; } else{ if ($tmpfile["name"]!="" && !$tmpfile["error"]){ $F_DATA["num"] = $_fnum; saveUpFiles($tmpfile,$F_DATA); $_fnum++; } } } } } } function getCateFiles($moduleId,$idx,$OPT=""){ $DB = $this->DB; $qry = "select * from ".$this->_Tables["catefiles"]." where file_code='".$moduleId."' and parentIDX='".$idx."' order by num asc "; $result = $DB->dbQuery($qry); while($row = $DB->sql_fetch_array($result)){ $row["size"] = filesize_human($row["filesize"]); $row["link_vars"] = "&idx=".$idx."&num=".$row["num"]; $row["file_content_org"] =$row["file_content"]; $row["file_content"] = ($row["file_content"])? $row["file_content"] : $row["b_subject"].""; $row["contents"] = $row["file_content"]; $row["isImg"] = (isImageFileType($row["img_type"]))? true:false; $get_list[] = $row; } return $get_list; } function getFirstCategory($cate=""){ $DB = $this->DB; $ModuleId = $this->ModuleId; $file_code= $ModuleId.".cate.vimg"; $qry = "SELECT *, (SELECT MAX(sc_depth) FROM " . $this->_Tables["cate"] . " WHERE SUBSTR(sc_key, 1, LENGTH(a.sc_key)) = a.sc_code) maxDepth  FROM " . $this->_Tables["cate"] . " a LEFT JOIN " . $this->_Tables["catefiles"] . " b ON a.sc_code = b.parentIDX AND b.num = '1' WHERE a.sc_depth = '1' AND a.sc_use = 'Y' AND a.sc_group = '" . $this->cateGroupCD . "' ORDER BY a.sc_step ASC"; $result = $DB->dbQuery($qry); $DATA = array(); $img = ""; $content = ""; $maxDepth = ""; while($row = $DB->sql_fetch_array($result)){ $DATA[$row["sc_code"]] = $row; if($row["sc_code"] == $cate){ $img = $row["filepath"]."/".$row["filename"]; $content = $row["sc_content"]; $maxDepth = $row["maxDepth"]; } } $rtnData["listData"] = $DATA; $rtnData["img"] = $img; $rtnData["content"] = $content; $rtnData["sc_code"] = $cate; $rtnData["maxDepth"] = $maxDepth; return $rtnData; } function getModeLink($data=array()){ if($this->sCode == "eng"){ if($this->dMode){ $link = ($data["dev_menu_code"]) ? $data["dev_menu_code"]:$data["ser_menu_code_e"]; }else{ $link = ($data["ser_menu_code_e"]) ? $data["ser_menu_code_e"]:$data["dev_menu_code"]; } }else{ if($this->dMode){ $link = ($data["dev_menu_code"]) ? $data["dev_menu_code"]:$data["ser_menu_code"]; }else{ $link = ($data["ser_menu_code"]) ? $data["ser_menu_code"]:$data["dev_menu_code"]; } } return "/".$this->site_code."/index.php?pCode=".$link; } function getCateInfo($data=array()){ $DB = $this->DB; $ModuleId = $this->ModuleId; $file_code= $ModuleId.".cate.vimg"; $cate = array(); $item = array(); $cateInfo = $data["listData"][$data["sc_code"]]; if((int)$data["maxDepth"] > 1){ $cate["cateExist"] = true; $qry = "SELECT * FROM " . $this->_Tables["cate"] . " WHERE sc_use = 'Y' AND sc_group = '" . $this->cateGroupCD . "' and sc_key like '" . $cateInfo["sc_code"] . "%' and sc_depth > 1 ORDER BY sc_step ASC"; $result = $DB->dbQuery($qry); while($row = $DB->sql_fetch_array($result)){ $tmp = array(); $tmp["cate"] = $row; $item = $this->getCateItemInfo($row["sc_code"]); if(is_array($item)){ $tmp["item"] = $item; } $cate[][$row["sc_code"]] = $tmp; } }else{ $tmp["item"] = $this->getCateItemInfo($cateInfo["sc_code"]); $cate[][$data["sc_code"]] = $tmp; } return $cate; } function getCateItemInfo($code="", $lang="K"){ $DB = $this->DB; $tmp = array(); $qry = "SELECT * FROM " . $this->_Tables["data"] . " WHERE isUse = '1' AND CgCode = '" . $code . "' AND lang='" . $lang . "' and isDel <> '1' ORDER BY sortnum ASC"; $result = $DB->dbQuery($qry); $MULTI_FILES = array("vimg"); while($row = $DB->sql_fetch_array($result)){ $tmpData = $row; foreach($MULTI_FILES as $_k=>$_fn){ $tmpData[$_fn."_files"]= $this->getFiles($this->ModuleId.".".$_fn,$tmpData["idx"]); $vfilesTotal = count($tmpData[$_fn."_files"]); for($i=0;$i<$vfilesTotal;$i++){ $_files = &$tmpData[$_fn."_files"][$i]; $_files["org_url"] = setUrlQuerystr($GLOBALS["link_href"]["action"],"mode=fv&sfld=".$_fn."&".$_files["link_vars"]) ; $_files["th_url"] =setUrlQuerystr($GLOBALS["link_href"]["action"],"mode=fth&sfld=".$_fn."&".$_files["link_vars"]) ; } } $tmp[] = $tmpData; } return $tmp; } function fileCateViewThumb($moduleId,$idx,$num,$w,$h,$opt="1",$th_Key=""){ global $_PATH,$Wapp; if($idx=="") exit; $DB = $this->DB; $DATA = $DB->sql_fetch("select * from ".$this->_Tables["catefiles"]." where idx='".$idx."'"); if ($DATA["idx"]=="") {exit;} $fileRootPath = $this->fileUploadRoot? $this->fileUploadRoot : $_PATH["ROOT"]; $ViewFileName = $fileRootPath.$DATA["filepath"]."/" . $DATA[filename]; $ViewThumbName = $fileRootPath.$DATA["filepath"]."/" . $th_Key."_". $DATA[filename]; if($DATA["img_type"]<1 || $DATA["img_type"]>3) exit; if (is_file($ViewThumbName) && $th_Key!="") { $ViewFileName = $ViewThumbName; if (is_file($ViewFileName)){ $f = fopen( $ViewFileName, "r"); $filedata = fread($f, filesize( $ViewFileName)); fclose($f); header("Content-type: " . $art["filetype"]); print $filedata; } }else{ if($opt=="1"){ view_thumb($fileRootPath.$DATA["filepath"]."/", $DATA["filename"],$w,$h,array("toName"=>$w . "_" . $DATA["filename"])); }else{ view_thumb_crop($fileRootPath.$DATA["filepath"]."/", $DATA["filename"],$w,$h,array("toName"=>$w . "_" . $DATA["filename"])); } } exit; } function fileViewThumb($moduleId,$idx,$num,$w,$h,$opt="1",$th_Key=""){ global $_PATH,$Wapp; if($idx=="" || $num=="") exit; $DB = $this->DB; $DATA = $DB->sql_fetch("select * from ".$this->_Tables["files"]." where parentIDX='".$idx."' AND num = '" . $num."'"); if ($DATA["idx"]=="") {exit;} $fileRootPath = $this->fileUploadRoot? $this->fileUploadRoot : $_PATH["ROOT"]; $ViewFileName = $fileRootPath.$DATA["filepath"]."/" . $DATA[filename]; $ViewThumbName = $fileRootPath.$DATA["filepath"]."/" .$th_Key."_". $DATA[filename]; if($DATA["img_type"]<1 || $DATA["img_type"]>3) exit; if (is_file($ViewThumbName) && $th_Key!="") { $ViewFileName = $ViewThumbName; if (is_file($ViewFileName)){ $f = fopen( $ViewFileName, "r"); $filedata = fread($f, filesize( $ViewFileName)); fclose($f); header("Content-type: " . $art["filetype"]); print $filedata; } }else{ if($opt=="1"){ view_thumb($fileRootPath.$DATA["filepath"]."/", $DATA[filename],$w,$h,array("toName"=>$w . "_" . $DATA["filename"])); }else{ view_thumb_crop($fileRootPath.$DATA["filepath"]."/", $DATA[filename],$w,$h,array("toName"=>$w . "_" . $DATA["filename"])); } } exit; } }