PHP Decode

<?php ${"G\x4c\x4f\x42A\x4c\x53"}["c\x6e\x6ct\x67\x70\x75u\x73"]="\x74\x61x\x52\x61\x74e\x43o\x6cu\x6d\x6e\x4e\x61m\x65";${"G\x4c\x4fB\x41\x4cS"}["\x76\x76\x6anc\x71g\x75\x72\x65"]="\x63\x6f\x6du\x6e\x4e\x61\x6d\x65";${"\x47\x4c\x4fB\x41\x4c\x53"}["\x66k\x6a\x68\x69o\x62w"]="\x63\x6f\x6cum\x6e\x46\x6f\x72\x6d\x61t";${"\x47L\x4fBA\x4c\x53"}["\x66\x66\x6a\x77\x79\x71y\x73"]="\x69\x6ec\x6c\x75\x64\x65\x54a\x78";${"GL\x4f\x42\x41\x4cS"}["\x6c\x66\x68\x76\x6a\x67\x6c\x67\x65\x65\x6dj"]="\x77\x65e\x65\x43\x6f\x6c\x75\x6dn\x4eo\x6e\x54\x61\x78a\x62le";${"G\x4cOB\x41L\x53"}["\x6c\x6d\x61\x6e\x75j\x64y"]="\x77\x65\x65\x65\x54\x61\x78a\x62\x6ce";${"\x47\x4cOB\x41\x4c\x53"}["n\x73\x69\x6c\x6f\x74el\x72e"]="w\x65\x65\x65\x4f\x72\x69\x67\x69\x6e\x61\x6c";${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x77\x76\x6f\x69\x79\x74f\x65"]="\x77\x65\x65\x65C\x6fl\x75\x6dn";${"GL\x4f\x42\x41\x4cS"}["f\x74\x64l\x63t\x79v\x72"]="\x77\x65\x65eC\x6fl\x75\x6d\x6e\x54axa\x62\x6c\x65";${"G\x4c\x4f\x42\x41\x4c\x53"}["\x76j\x62\x66\x75\x6en\x61spf"]="\x63\x75rre\x6ec\x79R\x61t\x65";${"\x47\x4c\x4f\x42\x41L\x53"}["\x77\x7a\x61\x7a\x66\x6a\x69\x67"]="w\x65\x65e\x43\x6flumn\x46in\x61l";${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x69\x67\x70\x6c\x73\x67\x6a\x6d\x6d\x63"]="w\x65\x65eC\x6f\x6cu\x6dn\x4f\x72i\x67in\x61\x6c";${"\x47LO\x42ALS"}["\x6b\x75h\x70\x6du\x70\x77\x65\x71"]="\x6fr\x69\x67\x69\x6e\x61\x6c\x50r\x69ces\x49\x6e\x63\x6cu\x64\x65s\x54\x61x";${"G\x4cOB\x41L\x53"}["t\x6cg\x6b\x6a\x61y"]="pr\x69\x63\x65\x43o\x6c\x75m\x6e\x73";${"\x47\x4c\x4f\x42ALS"}["\x66\x7a\x6c\x73\x63x\x65f\x76\x79"]="\x6c\x6f\x63\x61\x6ce";${"G\x4cOB\x41L\x53"}["bry\x75v\x75bblm"]="\x74\x61\x78o\x6e\x6fmy\x43\x6f\x6cu\x6d\x6e";${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x68\x63fie\x6e\x6er\x75\x75\x62"]="\x6a\x6f\x69\x6e\x49\x66Co\x6c\x75mn\x73\x45\x6dp\x74y";${"\x47\x4c\x4f\x42A\x4cS"}["\x62\x6ez\x70pt\x67\x64"]="\x70\x72\x6f\x64uc\x74I\x64Co\x6c\x75mnN\x61\x6d\x65";${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x6anr\x66\x69\x69i\x6cr\x79"]="m\x69\x6e\x53\x61\x6c\x65\x51\x74y\x43\x6f\x6e\x64\x69\x74\x69\x6f\x6e";${"G\x4c\x4f\x42\x41\x4c\x53"}["\x73d\x6e\x77\x68\x66\x75s\x6f\x68l\x76"]="\x67\x6c\x6f\x62\x61\x6cM\x69nSa\x6ceQ\x74\x79";${"G\x4c\x4f\x42A\x4cS"}["\x76\x68\x76\x63\x77p\x64p\x6bx"]="m\x61\x6e\x61g\x65\x53to\x63k\x43o\x6ed\x69ti\x6f\x6e";${"\x47L\x4f\x42A\x4cS"}["\x6dbkf\x6cf\x68b"]="\x6d\x61n\x61\x67\x65S\x74\x6f\x63k\x56\x61\x6c\x75\x65";${"G\x4cO\x42A\x4cS"}["i\x7ac\x6f\x68\x74\x68sk"]="\x70\x61\x72\x65nt\x56\x69\x73i\x62i\x6c\x69t\x79";${"\x47LO\x42\x41\x4c\x53"}["ch\x66s\x74\x74\x66\x73u\x69\x6a"]="\x76\x69\x73\x69b\x69\x6ci\x74y";${"\x47\x4c\x4f\x42A\x4c\x53"}["\x68\x78\x79\x71\x66\x6d\x64\x65\x76x"]="\x74\x79\x70\x65\x73";${"\x47L\x4f\x42\x41\x4cS"}["\x65\x70\x63bw\x75sh\x67"]="a\x6c\x6c\x54\x79\x70\x65\x73";${"\x47LOBAL\x53"}["\x74h\x76iqx\x76a\x77\x6c"]="\x72\x65\x73\x75\x6c\x74";${"\x47LOB\x41LS"}["\x77m\x67\x66\x79u\x69\x68\x63tm\x69"]="\x61ttri\x62\x75\x74eC\x6f\x64\x65";${"G\x4cO\x42AL\x53"}["\x78n\x77\x72\x7a\x68\x6b\x6f\x72"]="\x61\x74\x74r\x69\x62tu\x65s";${"G\x4cOB\x41\x4cS"}["\x77\x70\x78\x66\x63k\x70"]="c\x6f\x6editi\x6fnIt\x65m";${"GL\x4f\x42ALS"}["\x61\x6ep\x6b\x72\x61"]="k\x65\x79";${"\x47\x4c\x4f\x42AL\x53"}["w\x69\x71\x68\x6eh\x6a\x63\x77\x72"]="whe\x72\x65";${"GLOBALS"}["\x70\x64b\x73x\x73y"]="\x72u\x6ce";${"G\x4cO\x42AL\x53"}["\x71\x63\x66\x68\x6c\x64"]="\x72egi\x73\x74\x72e\x64\x4bey";${"G\x4c\x4f\x42\x41\x4c\x53"}["\x72\x76\x71\x63\x6e\x6d\x76"]="\x72es";${"\x47\x4c\x4fB\x41LS"}["b\x6e\x67j\x63a\x73c\x73\x77\x66"]="\x61\x6c\x6cAt\x74\x72ib\x74ue\x73";${"\x47LOB\x41\x4c\x53"}["ql\x61\x62u\x77\x63\x69\x79"]="\x63\x6f\x6e\x64\x69\x74i\x6f\x6e\x73";${"\x47\x4c\x4f\x42\x41\x4c\x53"}["d\x69\x6a\x6d\x6a\x76"]="\x66\x6c\x61\x74\x43\x6fl\x75\x6d\x6e\x73\x32";${"\x47\x4c\x4f\x42A\x4c\x53"}["\x62\x79nlp\x76\x68\x70\x6e\x68"]="fla\x74Al\x69a\x73";${"\x47\x4cO\x42A\x4c\x53"}["\x66u\x6b\x65\x61\x6a\x75u\x6c\x69\x65"]="c\x6flu\x6dn\x73";${"\x47L\x4f\x42\x41\x4cS"}["n\x72\x79\x79\x65t\x65\x6d\x71z"]="\x63\x6f\x6c\x75\x6d\x6e";${"G\x4c\x4f\x42\x41\x4c\x53"}["\x63\x66\x77\x71cv\x74xy"]="\x66\x6c\x61t\x43o\x6c\x75\x6d\x6es";${"\x47\x4c\x4fBAL\x53"}["f\x6ffw\x78\x6aw\x62\x6fs\x77n"]="\x73\x6f\x72t\x41\x74\x74\x72i\x62u\x74\x65";${"\x47\x4c\x4fBA\x4c\x53"}["\x65\x74n\x76t\x77\x64\x6d\x74"]="c\x6f\x6ed\x69\x74\x69o\x6e";${"\x47\x4c\x4f\x42A\x4c\x53"}["\x70c\x67\x79\x70\x70"]="\x63\x6f\x6e\x64";${"G\x4cO\x42AL\x53"}["\x6ea\x76\x62d\x76\x79"]="\x63\x68\x69l\x64P\x72o\x64\x75c\x74\x73\x41\x64\x64\x65\x64";${"G\x4c\x4fB\x41\x4c\x53"}["\x78j\x6b\x62\x6c\x79\x75n\x74\x68\x73x"]="\x65\x78\x70\x6f\x72t\x41ll\x43at\x65g\x6f\x72ies";${"\x47\x4c\x4f\x42\x41\x4cS"}["\x79\x79\x78\x6e\x67\x67qd\x62j\x6b"]="s\x75\x62S\x65l\x65\x63\x74";${"\x47\x4c\x4f\x42\x41L\x53"}["\x64\x6d\x74\x77j\x6er\x75\x6a\x69\x64"]="\x6da\x69nT\x61\x62\x6c\x65";${"GL\x4f\x42A\x4c\x53"}["\x76\x7an\x77\x6fw"]="\x6ao\x69n\x4c\x65\x66\x74";${"\x47LO\x42AL\x53"}["j\x6e\x70\x71\x76emp\x71\x6b"]="m\x61i\x6e\x54a\x62l\x65A\x6c\x69\x61\x73";${"\x47\x4c\x4fB\x41L\x53"}["p\x74eg\x62\x6cn\x67\x73"]="\x6a\x6f\x69\x6e\x54\x61\x62\x6c\x65\x41l\x69\x61\x73";${"\x47\x4c\x4fBA\x4c\x53"}["yz\x6ew\x68\x73\x70\x7a\x6a\x71\x68"]="\x6a\x6fi\x6eT\x61bl\x65";${"\x47L\x4f\x42A\x4c\x53"}["ajp\x7a\x70qe\x63"]="\x70\x72\x6fd\x75\x63t\x55rlS\x75f\x66i\x78";${"GL\x4f\x42\x41LS"}["z\x6e\x66\x74\x75\x63kw\x66"]="u\x6e\x6bn\x6f\x77\x6eA\x74\x74\x72\x69\x62\x75\x74\x65\x73";${"\x47\x4c\x4f\x42\x41\x4cS"}["\x77\x6a\x74\x77\x64dsnb"]="\x76\x61l\x75\x65";${"\x47L\x4f\x42\x41\x4cS"}["k\x68\x74\x65\x64\x6a\x61\x74"]="s\x65\x6c\x65\x63\x74";class Nostress_Nscexport_Model_Mysql4_Data_Loader_Product extends Nostress_Nscexport_Model_Mysql4_Data_Loader{protected$_lastCategoryProductTableAlias=self::NCP;protected$_defaultAttributes=array("id","product_type","group_id","is_child");protected$_productFlatMandatoryColumns=array('visibility','tax_class_id');protected$_multiColumns=array("super_attributes","categories","media_gallery");protected$_staticColumns=array("currency","country_code","locale","language","shipping_method_name","shipping_cost");const VISIBILITY=4;const STOCK_STATUS=1;public function init(){parent::init();${${"\x47\x4c\x4fBALS"}["\x6b\x68\x74\x65\x64j\x61\x74"]}=$this->getSelect();$select->from(array($this->getMainTable(true)=>$this->getMainTable()),$this->getProductFlatColumns());return$this;}public function getMainTable($alias=false){$nzlkrmc="\x61\x6ci\x61\x73";return$this->getProductFlatTable(${$nzlkrmc});}public function getAllColumns(){$pfowpiqauwr="c\x6f\x6c\x75\x6d\x6es";$foakcijlv="\x63ol\x75\x6d\x6e\x73";${$pfowpiqauwr}=parent::getAllColumns();foreach($this->_productFlatMandatoryColumns as${${"\x47\x4c\x4fB\x41L\x53"}["\x77\x6a\x74\x77\x64d\x73nb"]}){${"G\x4c\x4f\x42\x41\x4c\x53"}["wsq\x6f\x68r\x76\x66c"]="\x63\x6f\x6c\x75\x6d\x6e\x73";${${"\x47\x4c\x4f\x42\x41L\x53"}["w\x73q\x6fh\x72\x76\x66\x63"]}[${${"G\x4c\x4fB\x41\x4cS"}["\x77\x6a\x74w\x64d\x73\x6e\x62"]}]=${${"\x47L\x4f\x42\x41L\x53"}["\x77j\x74w\x64\x64\x73\x6e\x62"]};}return${$foakcijlv};}protected function getProductFlatColumns(){${"\x47LO\x42\x41\x4cS"}["\x6as\x78b\x75b\x7a\x64\x6b"]="\x75n\x6b\x6e\x6f\x77\x6eA\x74\x74\x72i\x62ut\x65s";${"\x47L\x4f\x42AL\x53"}["sp\x6eb\x78\x78"]="\x63\x6fl\x75\x6d\x6es";$ofhtdvju="c\x6fl\x75mn\x73";${$ofhtdvju}=$this->getColumns($this->getMainTable(true));${${"\x47\x4cOB\x41\x4c\x53"}["\x7a\x6ef\x74\x75\x63\x6b\x77\x66"]}=$this->getUnknownAttributes();$this->checkProductAttributes(array_merge(${${"\x47\x4c\x4f\x42AL\x53"}["\x7anf\x74\x75\x63\x6b\x77\x66"]},$this->_productFlatMandatoryColumns));return array_merge(${${"\x47\x4c\x4fBAL\x53"}["\x73\x70nbxx"]},$this->prepareColumnsFromAttributes(${${"\x47LO\x42\x41L\x53"}["\x6as\x78bu\x62\x7a\x64\x6b"]}));}protected function defineColumns(){parent::defineColumns();$this->_columns[$this->getProductFlatTable(true)]=array("id"=>"e\x6et\x69\x74y\x5fid","p\x72od\x75\x63t\x5f\x74yp\x65"=>"\x74ype\x5f\x69d","\x6ea\x6de\x5fa\x6e\x64\x5fsku"=>"\x43O\x4eC\x41\x54({$this->getProductFlatTable(true)}\x2e\x6e\x61\x6de,'\x20',{$this->getProductFlatTable(true)}\x2e\x73\x6bu)");if($this->getUrlAttributeSource()==Nostress_Nscexport_Model_Config_Source_Urlsource::FLAT_CATALOG){${${"\x47\x4c\x4fB\x41L\x53"}["aj\x70zpq\x65\x63"]}=$this->getStoreConfig(Mage_Catalog_Helper_Product::XML_PATH_PRODUCT_URL_SUFFIX);$ktqxmtmq="\x70\x72\x6f\x64\x75\x63tU\x72l\x53\x75\x66\x66\x69\x78";if(!empty(${$ktqxmtmq})){${"\x47\x4cO\x42\x41L\x53"}["m\x75\x6b\x71\x74\x71\x6b\x66"]="\x66\x69\x72\x73\x74\x43h\x61\x72";${"\x47\x4cO\x42\x41L\x53"}["\x68\x64\x6auk\x74uq"]="\x66\x69\x72stChar";${${"G\x4c\x4f\x42A\x4c\x53"}["\x6d\x75\x6b\x71\x74\x71k\x66"]}=substr(${${"G\x4cOB\x41L\x53"}["aj\x70\x7ap\x71\x65\x63"]},0,1);if(${${"G\x4c\x4f\x42\x41\x4c\x53"}["\x68\x64j\x75\x6b\x74u\x71"]}!="\x2e")${${"\x47L\x4f\x42\x41\x4c\x53"}["a\x6apzp\x71\x65c"]}=".".${${"G\x4c\x4fB\x41\x4c\x53"}["\x61\x6a\x70z\x70\x71\x65c"]};}$this->_columns[$this->getProductFlatTable(true)]["\x75\x72l"]="\x43\x4f\x4e\x43\x41T('{$this->getStoreBaseUrl()}\x27,IFN\x55LL({$this->getProductFlatTable(true)}\x2e\x75r\x6c_path,\x43O\x4e\x43A\x54({$this->getProductFlatTable(true)}.\x75r\x6c_k\x65y,\x27{$productUrlSuffix}')))";}else{$this->_columns[self::CUR]=array("u\x72l"=>"\x43\x4fN\x43\x41\x54(\x27{$this->getStoreBaseUrl()}',".self::CUR."\x2e\x72\x65\x71\x75\x65s\x74_pa\x74\x68)");$this->_columns[self::EUR]=array("u\x72\x6c"=>"\x43ON\x43AT(\x27{$this->getStoreBaseUrl()}\x27,".self::EUR."\x2e\x72e\x71\x75\x65st\x5f\x70at\x68)");}$this->_columns[self::NPACD]=array(Nostress_Nscexport_Helper_Data_Loader::COLUMN_CATEGORIES_DATA=>Nostress_Nscexport_Helper_Data_Loader::GROUPED_COLUMN_ALIAS);$this->_columns[self::CISS]=array("s\x74o\x63\x6b_\x73\x74\x61tus"=>"s\x74\x6fck\x5fs\x74\x61tus");if($this->getStockStatusDependence()==Nostress_Nscexport_Model_Config_Source_Stockdependence::QTY){${"G\x4c\x4f\x42\x41\x4c\x53"}["\x71d\x72\x76p\x64\x68\x6fe\x73\x6f"]="\x63\x6f\x6e\x64\x69\x74\x69\x6f\x6e";${${"\x47L\x4f\x42\x41\x4c\x53"}["\x71d\x72\x76\x70dh\x6f\x65\x73\x6f"]}=$this->getManageStockCondition(self::CISI);$this->_columns[self::CISS]["\x73to\x63k\x5f\x73\x74a\x74us"]="\x49F(".self::CISI.".q\x74y \x3e\x200 O\x52\x20({$condition}),1,0)";}$this->_columns[self::CISI]=array("q\x74\x79"=>$this->helper()->getRoundSql(self::CISI."\x2eqty",0),"\x6dini\x6d\x75\x6d\x5f\x71\x74y\x5fa\x6c\x6co\x77\x65d\x5f\x69\x6e_sh\x6fp\x70i\x6eg\x5fc\x61\x72t"=>$this->helper()->getRoundSql($this->getMinSaleQtyCondition(self::CISI),0));$this->_columns[self::PCPF]=array("\x70\x61r\x65nt_\x73k\x75"=>"s\x6b\x75");$this->_columns[self::NCSA]=array("s\x75p\x65r_\x61\x74\x74ribu\x74\x65\x73"=>"\x73\x75p\x65\x72_a\x74\x74\x72ibut\x65\x73");$this->_columns[self::NCC]=array("cat\x65\x67orie\x73"=>"\x63a\x74egori\x65\x73");$this->_columns[self::NCMG]=array("\x6d\x65\x64\x69a_g\x61\x6c\x6ce\x72y"=>"med\x69\x61_\x67al\x6ce\x72\x79");$this->_columns[self::RRA]=array("\x72e\x76i\x65w\x73_\x63\x6f\x75nt"=>"\x72e\x76i\x65w\x73\x5f\x63\x6f\x75n\x74","re\x76\x69e\x77s_\x75r\x6c"=>"\x43ONCA\x54(\x27{$this->getStoreBaseUrl()}\x27,'{$this->getReviewUrlPrefix()}', CAST({$this->getProductFlatTable(true)}.e\x6e\x74\x69\x74\x79_id\x20A\x53 \x43\x48A\x52)) A\x53 \x72\x65views_url");$this->_columns[self::PCISS]=array("p\x61\x72\x65\x6e\x74\x5fs\x74ock_s\x74a\x74us"=>self::PCISS.".\x73\x74\x6fc\x6b_stat\x75s");$this->_columns[self::PCISI]=array("\x70a\x72\x65n\x74\x5f\x71\x74y"=>$this->helper()->getRoundSql(self::PCISI.".q\x74y",0));$this->_columns[self::NCT]=array("\x74\x61x\x5fp\x65rc\x65nt"=>"\x49FN\x55\x4c\x4c({$this->helper()->getRoundSql("tax_percent*100")},\x30)");$this->_columns[self::NEC]=array("\x74ax\x6fn\x6f\x6d\x79_\x6ea\x6de"=>"\x6e\x61\x6de","t\x61\x78\x6fn\x6fmy_\x69d"=>"id","\x74a\x78\x6f\x6eo\x6dy_\x70a\x74h"=>"pa\x74\x68","t\x61\x78\x6fn\x6fm\x79_\x69d\x73_p\x61t\x68"=>"i\x64\x73_p\x61\x74\x68","t\x61xo\x6eomy_leve\x6c"=>"\x6c\x65v\x65l","t\x61\x78o\x6e\x6fmy\x5fp\x61\x72e\x6e\x74_\x6ea\x6d\x65"=>"par\x65nt_n\x61\x6de","\x74\x61xo\x6eo\x6dy\x5f\x70\x61r\x65n\x74\x5f\x69d"=>"\x70a\x72en\x74\x5fi\x64");$this->_columns[self::NCEC]=array("taxon\x6f\x6d\x79_nam\x65"=>"\x6eame","taxo\x6eom\x79_i\x64"=>"\x69\x64","\x74\x61\x78\x6fno\x6dy\x5f\x70ath"=>"p\x61t\x68","\x74\x61\x78\x6fn\x6f\x6dy_i\x64\x73\x5fp\x61\x74h"=>"ids\x5fp\x61\x74h","t\x61x\x6f\x6e\x6f\x6dy\x5f\x6ce\x76el"=>"le\x76\x65\x6c","\x74a\x78\x6f\x6eo\x6dy\x5f\x70\x61r\x65\x6et_\x6e\x61\x6d\x65"=>"pare\x6e\x74\x5f\x6e\x61m\x65","\x74a\x78on\x6fm\x79_\x70arent\x5f\x69\x64"=>"\x70a\x72e\x6e\x74_id");$this->_columns[self::CPE]=array("upd\x61\x74\x65_\x64at\x65\x74\x69m\x65"=>"D\x41\x54E\x5fFO\x52\x4dA\x54(".self::CPE.".update\x64\x5fat,\x27{$this->getSqlTimestampFormat()}')","\x75\x70da\x74e\x5f\x64\x61t\x65"=>"\x44ATE\x5fFORMAT(".self::CPE."\x2eu\x70d\x61te\x64\x5fat,\x27{$this->getSqlTimestampFormat(self::DATE)}\x27)","update\x5ft\x69m\x65"=>"\x44AT\x45\x5fFOR\x4d\x41\x54(".self::CPE."\x2eu\x70\x64a\x74e\x64\x5fat,\x27{$this->getSqlTimestampFormat(self::TIME)}\x27)","c\x72ea\x74io\x6e\x5fd\x61t\x65\x74\x69\x6de"=>"D\x41TE_F\x4f\x52M\x41T(".self::CPE.".\x63reate\x64_a\x74,'{$this->getSqlTimestampFormat()}\x27)","cre\x61tion_d\x61te"=>"\x44ATE\x5fF\x4fRM\x41\x54(".self::CPE.".\x63re\x61\x74\x65\x64\x5fa\x74,'{$this->getSqlTimestampFormat(self::DATE)}')","cre\x61t\x69\x6f\x6e_\x74i\x6d\x65"=>"D\x41T\x45_\x46ORMA\x54(".self::CPE."\x2e\x63\x72\x65a\x74ed_\x61t,'{$this->getSqlTimestampFormat(self::TIME)}')");$this->_columns[self::NCW]=$this->getWeeeColumns();$this->_columns[self::CPR]=array("pa\x72\x65n\x74_\x69d"=>"p\x61r\x65\x6e\x74_i\x64","\x67\x72\x6fup\x5f\x69\x64"=>"I\x46N\x55\x4cL(".self::CPR."\x2e\x70ar\x65n\x74\x5fi\x64,{$this->getMainTable(true)}.\x65n\x74\x69\x74\x79\x5f\x69d)","i\x73_\x63\x68\x69\x6c\x64"=>"(".self::CPR."\x2e\x70\x61\x72e\x6et\x5f\x69\x64\x20\x49\x53 \x4e\x4fT \x4eUL\x4c)","\x69\x73\x5f\x70\x61\x72\x65n\x74"=>"(".self::CPR.".\x70arent_i\x64 I\x53 NUL\x4c)");$this->definePriceColumns();$this->dispatchDefineColumnsEvent("_pr\x6fdu\x63t");}public function joinProductFilter(){$this->joinExportCategoryProduct();}protected function joinExportCategoryProduct(){${"GL\x4fB\x41\x4c\x53"}["\x76\x72\x63v\x61s\x77\x78o\x69"]="\x61\x64\x64\x69\x74\x69o\x6e\x61\x6c\x43\x6f\x6e\x64i\x74\x69\x6f\x6e";$mffsmrwlqqkn="j\x6fin\x54\x61ble";${"\x47\x4c\x4f\x42\x41L\x53"}["o\x71\x6e\x71\x68uhf\x67"]="a\x64d\x69t\x69o\x6ea\x6c\x43\x6f\x6ed\x69ti\x6fn";${${"\x47\x4cOB\x41\x4cS"}["\x6bh\x74\x65\x64\x6a\x61t"]}=$this->getSelect();${"\x47\x4c\x4fB\x41\x4c\x53"}["\x75\x61\x61\x79\x77\x73\x72\x69"]="\x6a\x6f\x69\x6e\x54\x61\x62\x6ce\x41\x6cia\x73";${"G\x4c\x4f\x42\x41LS"}["h\x6b\x73\x75\x73\x75\x74"]="\x6da\x69nT\x61ble\x41\x6c\x69as";${"GL\x4f\x42\x41\x4c\x53"}["\x6fe\x72\x78\x77\x68py"]="\x6aoi\x6e\x54a\x62\x6ce\x41l\x69a\x73";${${"G\x4c\x4f\x42\x41L\x53"}["hk\x73usu\x74"]}=$this->getMainTable(true);${${"G\x4c\x4fB\x41\x4cS"}["\x75\x61a\x79\x77\x73\x72\x69"]}=self::NCP;$oenbxlhd="j\x6f\x69\x6e\x54ab\x6c\x65A\x6c\x69a\x73";${$mffsmrwlqqkn}=$this->getTable("\x6e\x73\x63exp\x6f\x72t/\x63\x61teg\x6fr\x79\x70\x72oduc\x74\x73");$vuxoqeij="\x6a\x6f\x69\x6eT\x61ble\x41\x6c\x69a\x73";${${"\x47L\x4fBA\x4c\x53"}["\x76\x72\x63\x76\x61swxoi"]}="";if($this->allowChildProductsExport())${${"\x47L\x4fBA\x4cS"}["o\x71\x6e\x71\x68u\x68\x66\x67"]}="\x4f\x52 {$joinTableAlias}\x2e\x70\x72\x6fd\x75ct\x5f\x69\x64=".self::CPR.".\x70\x61\x72e\x6et\x5fid\x20";$select->join(array(${$oenbxlhd}=>${${"\x47\x4c\x4f\x42\x41L\x53"}["\x79\x7a\x6e\x77\x68\x73p\x7aj\x71\x68"]}),"{$joinTableAlias}.\x70\x72\x6fd\x75\x63t\x5fi\x64\x3d{$mainTableAlias}.ent\x69\x74\x79\x5f\x69\x64\x20{$additionalCondition}",$this->getColumns(${$vuxoqeij}));$select->where(${${"\x47\x4c\x4f\x42AL\x53"}["p\x74e\x67\x62l\x6e\x67\x73"]}."\x2e\x65\x78\x70ort\x5f\x69\x64=?",$this->getExportId());$this->_lastCategoryProductTableAlias=${${"\x47\x4c\x4f\x42\x41L\x53"}["\x6fe\x72\x78w\x68\x70\x79"]};}public function joinCategoryProduct(){${"\x47L\x4f\x42\x41L\x53"}["r\x6a\x6a\x73\x6c\x70w\x75\x79"]="s\x65\x6ce\x63\x74";$pvfiddnnj="m\x61\x69nTa\x62\x6c\x65\x41\x6c\x69a\x73";${"\x47\x4cO\x42AL\x53"}["\x76\x69\x72nf\x64j\x78w"]="jo\x69\x6eT\x61\x62\x6c\x65Alia\x73";${${"\x47\x4cO\x42\x41L\x53"}["\x72jj\x73\x6c\x70\x77u\x79"]}=$this->getSelect();${$pvfiddnnj}=$this->getMainTable(true);${${"\x47L\x4f\x42ALS"}["\x70\x74\x65g\x62\x6c\x6e\x67s"]}=self::CCPI;${${"\x47\x4cO\x42\x41\x4cS"}["y\x7an\x77\x68s\x70\x7a\x6a\x71\x68"]}=$this->getTable("\x63\x61ta\x6cog/\x63a\x74e\x67ory_\x70r\x6fd\x75c\x74\x5find\x65x");$select->join(array(${${"\x47\x4c\x4f\x42A\x4c\x53"}["pt\x65\x67\x62\x6c\x6e\x67\x73"]}=>${${"\x47\x4c\x4fB\x41\x4cS"}["\x79zn\x77\x68\x73\x70\x7a\x6aq\x68"]}),"{$joinTableAlias}\x2ep\x72oduc\x74\x5f\x69\x64={$mainTableAlias}\x2e\x65\x6e\x74ity\x5fid \x41\x4e\x44\x20{$joinTableAlias}.sto\x72\x65_\x69d\x3d {$this->getStoreId()}",$this->getColumns(${${"\x47\x4c\x4fB\x41\x4c\x53"}["\x70\x74\x65\x67\x62\x6c\x6e\x67\x73"]}));$this->_lastCategoryProductTableAlias=${${"\x47\x4c\x4f\x42A\x4cS"}["\x76\x69rnfd\x6a\x78\x77"]};}public function joinProductCategoryMaxLevel(){${"G\x4c\x4fB\x41\x4cS"}["\x6f\x79zd\x69\x76\x72"]="j\x6f\x69n\x54\x61\x62l\x65A\x6c\x69\x61\x73";$ofptdxojg="\x73el\x65\x63\x74";${$ofptdxojg}=$this->getSelect();${${"\x47\x4c\x4fB\x41L\x53"}["j\x6e\x70\x71v\x65m\x70q\x6b"]}=$this->getMainTable(true);${${"\x47L\x4f\x42\x41\x4c\x53"}["\x70\x74\x65gbl\x6e\x67\x73"]}=self::NCCML;${"\x47\x4cO\x42A\x4c\x53"}["\x67u\x65c\x66xb"]="\x6ao\x69\x6eT\x61\x62l\x65";${${"\x47\x4c\x4f\x42AL\x53"}["\x79\x7a\x6e\x77h\x73\x70z\x6aq\x68"]}=$this->getTable("\x6es\x63ex\x70\x6f\x72t/\x63a\x63\x68e\x5f\x63\x61\x74\x65\x67\x6fr\x79ma\x78\x6cevel");$select->join(array(${${"\x47\x4c\x4fB\x41\x4c\x53"}["oyzdi\x76r"]}=>${${"G\x4c\x4fB\x41L\x53"}["\x67ue\x63\x66\x78\x62"]}),"{$joinTableAlias}\x2e\x70\x72\x6f\x64\x75ct_i\x64\x3d{$mainTableAlias}.\x65n\x74ity_i\x64\x20A\x4e\x44 {$joinTableAlias}\x2e\x73tor\x65\x5f\x69\x64= {$this->getStoreId()}",$this->getColumns(${${"G\x4c\x4fB\x41LS"}["p\x74e\x67\x62\x6c\x6e\x67\x73"]}));$this->_lastCategoryProductTableAlias=${${"\x47\x4c\x4f\x42\x41\x4cS"}["\x70\x74\x65\x67\x62\x6cn\x67\x73"]};}public function joinCategoryFlatWithFilteredProducts(){$gfumzdxy="j\x6f\x69n\x4ce\x66\x74";$hqtlkmhlxw="\x6aoin\x4c\x65f\x74";${"GL\x4f\x42\x41\x4c\x53"}["\x77\x6a\x66\x74\x63\x76"]="\x6a\x6f\x69\x6e\x4ce\x66\x74";${${"\x47\x4c\x4fB\x41\x4c\x53"}["wj\x66\x74\x63v"]}=false;if($this->allowChildProductsExport())${$hqtlkmhlxw}=true;return$this->_joinCategoryFlat(${$gfumzdxy});}public function joinCategoryFlat(){return$this->_joinCategoryFlat(false);}public function joinLeftCategoryFlat(){return$this->_joinCategoryFlat(true);}protected function _joinCategoryFlat($joinLeft=false){${"\x47\x4cOBA\x4cS"}["\x68ms\x69\x62s\x65\x66\x63"]="\x73\x65\x6c\x65ct";${"\x47LO\x42A\x4c\x53"}["\x6f\x6cdn\x68\x78k"]="j\x6f\x69\x6e\x54\x61b\x6c\x65\x41\x6c\x69\x61\x73";${${"\x47L\x4f\x42\x41L\x53"}["\x68\x6d\x73\x69\x62\x73e\x66\x63"]}=$this->getSelect();$utpodyxxpq="join\x54\x61\x62le\x41\x6ci\x61s";${${"\x47LO\x42\x41L\x53"}["\x6a\x6e\x70q\x76e\x6d\x70\x71k"]}=$this->_lastCategoryProductTableAlias;${$utpodyxxpq}=$this->getCategoryFlatTable(true);${${"G\x4c\x4fBAL\x53"}["\x79\x7a\x6e\x77\x68\x73p\x7a\x6aq\x68"]}=$this->getCategoryFlatTable();$rciqxqeh="\x63\x6f\x6c\x75m\x6e\x73";${$rciqxqeh}=$this->getColumns(${${"\x47\x4c\x4f\x42\x41L\x53"}["oldn\x68\x78k"]});if(!${${"G\x4c\x4f\x42ALS"}["\x76\x7a\x6e\x77o\x77"]}){${"\x47L\x4f\x42A\x4c\x53"}["\x64ih\x65oa\x68ap\x61"]="\x63\x6fl\x75\x6dn\x73";${"GL\x4fB\x41\x4cS"}["\x6f\x61\x6f\x69\x71\x74ef\x6d\x68\x62\x75"]="\x6ao\x69\x6eTa\x62\x6ceA\x6c\x69\x61s";$vrtwje="m\x61\x69\x6e\x54a\x62\x6c\x65\x41\x6c\x69\x61\x73";$select->join(array(${${"GL\x4fBA\x4c\x53"}["\x6fa\x6f\x69\x71\x74e\x66\x6d\x68b\x75"]}=>${${"\x47\x4c\x4f\x42\x41L\x53"}["y\x7an\x77\x68s\x70\x7aj\x71\x68"]}),${${"\x47\x4cOB\x41\x4cS"}["\x70teg\x62\x6c\x6egs"]}."\x2eenti\x74\x79\x5f\x69d=".${$vrtwje}."\x2e\x63\x61te\x67o\x72\x79\x5fi\x64",${${"G\x4c\x4f\x42\x41\x4cS"}["d\x69\x68\x65\x6f\x61\x68\x61\x70a"]});}else{${"G\x4c\x4f\x42\x41L\x53"}["\x78\x74sh\x69\x68\x76\x6cx"]="m\x61\x69\x6eT\x61\x62\x6ce\x41l\x69\x61\x73";${"G\x4cOBA\x4cS"}["\x6f\x6c\x69\x6bgb\x63\x6e"]="\x63\x6fl\x75\x6d\x6e\x73";$ayeczehy="\x6a\x6f\x69\x6e\x54a\x62le";$select->joinLeft(array(${${"G\x4c\x4fB\x41LS"}["pt\x65\x67\x62\x6c\x6e\x67s"]}=>${$ayeczehy}),${${"\x47\x4cOB\x41\x4c\x53"}["p\x74\x65g\x62\x6c\x6eg\x73"]}."\x2e\x65ntit\x79_\x69d\x3d".${${"G\x4c\x4f\x42\x41L\x53"}["\x78\x74\x73h\x69\x68\x76\x6c\x78"]}."\x2e\x63\x61t\x65gor\x79\x5f\x69\x64",${${"G\x4cO\x42\x41\x4c\x53"}["\x6f\x6c\x69\x6b\x67\x62\x63\x6e"]});}$this->joinCategoryPath();return$this;}public function joinAllCategoriesData(){$wxefkunyp="\x6a\x6f\x69nT\x61\x62l\x65A\x6c\x69as";$wghait="\x6da\x69\x6e\x54\x61\x62\x6ce";$tiggkrfn="\x6d\x61i\x6e\x54ab\x6ce\x41\x6c\x69\x61\x73";${${"\x47\x4cO\x42ALS"}["d\x6d\x74w\x6a\x6e\x72uj\x69\x64"]}=$this->getTable("\x63\x61tal\x6fg/\x63\x61t\x65gor\x79\x5fp\x72oduc\x74_\x69\x6ede\x78");$yricvbwc="\x6a\x6f\x69\x6e\x54\x61\x62\x6c\x65Al\x69\x61s";${"GL\x4fB\x41\x4cS"}["m\x6c\x67\x6e\x62\x75he\x73\x6b"]="j\x6fi\x6eTa\x62\x6c\x65";$gqopiwg="\x6a\x6f\x69\x6e\x54\x61\x62\x6ce";$eqvokrhoje="j\x6f\x69n\x54\x61\x62\x6c\x65\x41li\x61\x73";${${"G\x4cOB\x41LS"}["jnp\x71\x76em\x70\x71\x6b"]}=self::CCPI;${$wxefkunyp}=$this->getCategoryFlatTable(true);${${"G\x4c\x4f\x42A\x4c\x53"}["m\x6c\x67\x6e\x62\x75hes\x6b"]}=$this->getCategoryFlatTable();${${"G\x4c\x4fB\x41\x4cS"}["y\x79\x78ng\x67\x71\x64\x62\x6ak"]}=$this->getEmptySelect();$subSelect->from(array(${$tiggkrfn}=>${$wghait}),array("pr\x6fdu\x63\x74\x5fid"));$subSelect->joinLeft(array(${$yricvbwc}=>${$gqopiwg}),${${"GLO\x42\x41\x4c\x53"}["\x70\x74\x65\x67b\x6c\x6egs"]}.".\x65\x6et\x69t\x79_i\x64\x3d".${${"\x47L\x4f\x42A\x4cS"}["\x6a\x6e\x70\x71\x76\x65\x6dp\x71\x6b"]}."\x2e\x63\x61\x74\x65gory_i\x64",$this->getColumns(${${"\x47\x4c\x4f\x42\x41LS"}["\x70t\x65\x67\x62\x6cng\x73"]},null,true));$subSelect->where(${${"\x47\x4cOBAL\x53"}["\x6anp\x71\x76\x65\x6d\x70qk"]}.".\x73\x74ore\x5f\x69d=?",$this->getStoreId());$geypfkblxtf="j\x6f\x69\x6e\x54\x61\x62\x6c\x65A\x6c\x69\x61\x73";$iumuiyovppt="\x6a\x6fi\x6eTa\x62leAl\x69as";$subSelect->group("\x70\x72\x6fd\x75\x63\x74\x5fid");${${"\x47L\x4f\x42A\x4c\x53"}["\x6b\x68\x74\x65\x64j\x61t"]}=$this->getSelect();${${"\x47L\x4f\x42\x41\x4c\x53"}["jn\x70\x71v\x65\x6d\x70q\x6b"]}=$this->getMainTable(true);$sefwwdbynxb="\x6a\x6fi\x6e\x54ab\x6ce\x41l\x69\x61s";${$eqvokrhoje}=self::$this->getSubSelectTable($this->getProductCategoriesSql());${${"\x47\x4c\x4f\x42A\x4c\x53"}["\x79\x7anw\x68\x73\x70\x7a\x6a\x71\x68"]}=$this->getSubSelectTable(${${"\x47\x4cO\x42\x41\x4cS"}["\x79\x79\x78\x6e\x67\x67qd\x62j\x6b"]});$select->joinLeft(array(${$sefwwdbynxb}=>${${"GL\x4f\x42\x41\x4cS"}["y\x7a\x6e\x77h\x73\x70zj\x71\x68"]}),${$geypfkblxtf}."\x2e\x70\x72o\x64\x75c\x74\x5fid \x3d".${${"\x47\x4c\x4fB\x41\x4c\x53"}["\x6a\x6epq\x76\x65m\x70\x71\x6b"]}."\x2e\x65\x6et\x69\x74\x79\x5fid",$this->getColumns(${$iumuiyovppt}));return$this;}public function joinAllCategoriesCache(){${${"\x47L\x4fB\x41LS"}["\x78\x6ak\x62\x6cyu\x6eth\x73\x78"]}=$this->getData(self::EXPORT_ALL_CATEGORIES,"\x31");$kixgygiyicie="e\x78\x70\x6f\x72tA\x6c\x6cC\x61\x74\x65\x67\x6f\x72\x69es";if(${$kixgygiyicie}==="0")return$this;$sbrmpmqt="j\x6f\x69\x6eT\x61\x62l\x65A\x6c\x69\x61\x73";${${"G\x4c\x4fB\x41L\x53"}["\x6bh\x74\x65dj\x61\x74"]}=$this->getSelect();${${"\x47\x4c\x4f\x42A\x4c\x53"}["\x6an\x70\x71vem\x70qk"]}=$this->getMainTable(true);${$sbrmpmqt}=self::NCC;${${"\x47\x4c\x4fB\x41\x4c\x53"}["y\x7a\x6e\x77\x68\x73\x70\x7a\x6a\x71h"]}=$this->getTable("\x6e\x73c\x65x\x70\x6fr\x74/\x63\x61\x63h\x65_ca\x74\x65\x67ories");$select->joinLeft(array(${${"G\x4c\x4fB\x41\x4cS"}["\x70t\x65\x67\x62\x6c\x6e\x67\x73"]}=>${${"G\x4c\x4fB\x41L\x53"}["y\x7an\x77h\x73\x70\x7aj\x71h"]}),"{$joinTableAlias}\x2e\x70\x72o\x64\x75c\x74_\x69\x64\x20\x3d{$mainTableAlias}\x2eent\x69\x74\x79\x5f\x69d \x41\x4e\x44\x20{$joinTableAlias}\x2estor\x65\x5fid = {$this->getStoreId()}",$this->getColumns(${${"\x47\x4c\x4f\x42\x41\x4c\x53"}["pt\x65\x67blngs"]}));return$this;}public function joinCategoryMaxLevelFiltredProducts(){${"\x47\x4cOB\x41\x4c\x53"}["\x63\x6d\x75\x77\x6e\x66o\x6b"]="\x63\x68i\x6c\x64\x50\x72\x6f\x64\x75\x63\x74s\x41\x64\x64e\x64";${${"\x47\x4c\x4fB\x41\x4cS"}["\x6e\x61\x76\x62d\x76\x79"]}=false;if($this->allowChildProductsExport()){$auitskgfk="\x63h\x69l\x64P\x72\x6f\x64\x75\x63\x74\x73\x41\x64\x64\x65\x64";${$auitskgfk}=true;}$this->_joinCategoryMaxLevelFiltredProducts(${${"\x47LOB\x41\x4c\x53"}["c\x6d\x75\x77n\x66o\x6b"]});}protected function _joinCategoryMaxLevelFiltredProducts($childProductsAdded){$ohprwcvbqllh="m\x61\x69\x6eT\x61b\x6c\x65";${${"\x47\x4c\x4fB\x41\x4cS"}["\x6a\x6e\x70qv\x65\x6dpq\x6b"]}=self::NCP;${"\x47\x4c\x4fB\x41L\x53"}["\x6e\x65f\x79t\x79"]="\x6d\x61i\x6e\x54\x61\x62l\x65\x41\x6c\x69\x61s";${$ohprwcvbqllh}=$this->getTable("nscexpo\x72t/cat\x65gor\x79pr\x6f\x64uct\x73");$birjefau="\x63\x6f\x6edi\x74i\x6fn";$ipbonwlpwo="\x63o\x6edi\x74io\x6e";${$birjefau}="{$mainTableAlias}\x2eex\x70o\x72t\x5f\x69d =\x20{$this->getExportId()}";$this->joinCategoryLevel(${${"GL\x4f\x42A\x4cS"}["d\x6dtw\x6a\x6e\x72u\x6a\x69\x64"]},${${"\x47LO\x42A\x4cS"}["\x6eef\x79t\x79"]},${$ipbonwlpwo},${${"\x47\x4cO\x42\x41L\x53"}["n\x61v\x62\x64\x76\x79"]});}protected function joinCategoryLevel($mainTable,$mainTableAlias,$condition=null,$childProductsAdded){$lcjyfekc="jo\x69\x6e\x54ab\x6c\x65";$ngscoaytu="\x6ao\x69nT\x61\x62\x6ce\x41l\x69a\x73";$fgtuubopieqy="\x73\x75b\x53\x65\x6c\x65\x63t";${"G\x4c\x4f\x42\x41L\x53"}["\x62vwrl\x70\x6b\x72\x64\x77\x78"]="\x73\x75\x62\x53\x65\x6c\x65\x63\x74";${"GLOBA\x4c\x53"}["y\x6aclk\x74\x78l\x6c\x71"]="ma\x69\x6e\x54\x61\x62\x6c\x65A\x6c\x69a\x73";${$ngscoaytu}=$this->getCategoryFlatTable(true);${$lcjyfekc}=$this->getCategoryFlatTable();${$fgtuubopieqy}=$this->getEmptySelect();$cmnbidcufcrk="c\x6fnd";$subSelect->from(array(${${"GLO\x42\x41L\x53"}["j\x6ep\x71\x76\x65\x6d\x70\x71k"]}=>${${"\x47LO\x42\x41\x4cS"}["\x64\x6dtwjn\x72u\x6a\x69d"]}),array("p\x72\x6f\x64uc\x74\x5f\x69d"));$ztopwt="\x6aoin\x54\x61\x62le\x41\x6ci\x61s";${${"\x47L\x4f\x42\x41\x4c\x53"}["p\x63\x67\x79p\x70"]}=${$ztopwt}.".\x65\x6et\x69\x74\x79_id\x3d".${${"G\x4cOB\x41L\x53"}["y\x6ac\x6c\x6b\x74x\x6c\x6c\x71"]}.".cat\x65gory_id";if(isset(${${"\x47\x4c\x4fB\x41\x4c\x53"}["etnvtw\x64\x6d\x74"]})){$eulsrxvvdn="c\x6f\x6e\x64";${$eulsrxvvdn}.=" AND\x20{$condition}";}else{${"\x47\x4c\x4fB\x41\x4c\x53"}["\x66f\x63\x79\x70y"]="ma\x69\x6eT\x61b\x6c\x65\x41\x6c\x69as";$subSelect->where(${${"\x47LOBAL\x53"}["f\x66\x63y\x70\x79"]}."\x2e\x73to\x72\x65\x5fi\x64=?",$this->getStoreId());}$subSelect->joinLeft(array(${${"G\x4cO\x42A\x4c\x53"}["\x70\x74eg\x62\x6cn\x67\x73"]}=>${${"\x47\x4cO\x42\x41\x4c\x53"}["yzn\x77\x68\x73pz\x6a\x71\x68"]}),${$cmnbidcufcrk},array("\x6da\x78_\x6c\x65\x76\x65l"=>"\x4d\x41X({$joinTableAlias}\x2e\x6cevel)"));if(!$this->allowInactiveCategoriesExport())$subSelect->where("{$joinTableAlias}.\x69\x73_\x61\x63\x74i\x76\x65\x3d?",self::CATEGORY_ACTIVE);${"\x47\x4c\x4f\x42A\x4c\x53"}["\x66i\x6c\x75b\x70yz"]="\x73e\x6c\x65c\x74";$ghdrjirj="\x6a\x6f\x69\x6eTa\x62l\x65";$subSelect->group("\x70r\x6f\x64u\x63\x74_i\x64");${${"\x47LO\x42ALS"}["\x66\x69l\x75\x62\x70\x79\x7a"]}=$this->getSelect();${${"\x47\x4c\x4f\x42A\x4c\x53"}["\x6a\x6epq\x76em\x70\x71\x6b"]}=$this->getCategoryFlatTable(true);${${"GL\x4f\x42\x41\x4cS"}["\x70t\x65\x67bl\x6e\x67\x73"]}=self::NCPML;${$ghdrjirj}=$this->getSubSelectTable(${${"\x47LO\x42\x41L\x53"}["\x62\x76w\x72lp\x6b\x72\x64\x77x"]});${${"\x47L\x4f\x42\x41\x4c\x53"}["\x65\x74\x6e\x76tw\x64\x6d\x74"]}=${${"\x47\x4c\x4f\x42\x41L\x53"}["\x70\x74eg\x62\x6c\x6e\x67s"]}.".\x6d\x61x\x5fleve\x6c\x20=\x20{$mainTableAlias}\x2el\x65\x76\x65l AND {$joinTableAlias}.p\x72odu\x63t_\x69d\x20= {$this->getMainTable(true)}.\x65nt\x69\x74y_i\x64";if(${${"\x47\x4cO\x42A\x4cS"}["n\x61\x76b\x64\x76y"]}){${"\x47\x4cOB\x41\x4cS"}["\x6a\x64u\x76\x6bec\x76\x6e"]="\x63p\x72\x54\x61\x62\x6c\x65\x41\x6c\x69\x61\x73";${${"\x47\x4c\x4f\x42A\x4cS"}["\x6ad\x75\x76\x6becv\x6e"]}=self::CPR;$fxpwjsvllj="join\x54a\x62l\x65\x41lias";${"\x47LO\x42\x41\x4cS"}["\x6a\x66av\x6d\x6c"]="jo\x69nT\x61bleAl\x69\x61s";${"\x47\x4c\x4f\x42A\x4c\x53"}["\x79\x6fc\x65\x6e\x6cne"]="\x6a\x6f\x69\x6eTa\x62le";$select->joinLeft(array(${${"\x47L\x4f\x42\x41L\x53"}["\x6af\x61\x76\x6d\x6c"]}=>${${"GL\x4f\x42A\x4cS"}["y\x6f\x63\x65\x6e\x6c\x6ee"]}),${${"\x47\x4c\x4f\x42\x41\x4c\x53"}["etn\x76t\x77\x64mt"]},$this->getColumns(${$fxpwjsvllj}));}else{$lpdjxknfk="c\x6f\x6e\x64\x69\x74i\x6f\x6e";${"\x47\x4cO\x42\x41\x4c\x53"}["\x6d\x64\x74\x77bfc"]="jo\x69n\x54abl\x65Al\x69as";$opqorhxn="\x6aoi\x6e\x54\x61bl\x65\x41\x6c\x69a\x73";$select->join(array(${$opqorhxn}=>${${"\x47\x4cO\x42\x41\x4cS"}["y\x7a\x6ewh\x73p\x7aj\x71\x68"]}),${$lpdjxknfk},$this->getColumns(${${"\x47\x4cOBA\x4c\x53"}["\x6dd\x74\x77\x62\x66\x63"]}));}return$this;}public function groupByProduct(){$lvubrnrfcp="\x73\x65\x6ce\x63\x74";${$lvubrnrfcp}=$this->getSelect();$select->group($this->getMainTable(true).".e\x6e\x74it\x79_i\x64");}public function addSortAttribute(){${"\x47L\x4f\x42AL\x53"}["\x67\x6b\x65\x6a\x77\x79\x77"]="\x73o\x72t\x41\x74\x74\x72\x69bu\x74\x65";${"\x47L\x4f\x42\x41\x4c\x53"}["\x78\x79n\x71\x74\x73\x61\x63\x6c"]="s\x65\x6cec\x74";${${"G\x4cOB\x41L\x53"}["fo\x66\x77\x78j\x77\x62\x6fs\x77\x6e"]}=$this->getData(self::SORT_ATTRIBUTE);if(empty(${${"G\x4cO\x42\x41L\x53"}["\x67k\x65\x6a\x77\x79\x77"]}))return;${${"\x47\x4c\x4f\x42A\x4c\x53"}["\x78\x79\x6e\x71\x74\x73\x61cl"]}=$this->getSelect();$select->columns(array(self::SORT_ATTRIBUTE_ALIAS=>"IF(".self::CPR.".p\x61\x72e\x6e\x74_\x69\x64\x20IS\x20\x4e\x4f\x54\x20\x4e\x55L\x4c,".self::PCPF."\x2e{$sortAttribute},{$this->getMainTable(true)}.{$sortAttribute})"));}public function setProductsOrder(){$wcbuego="so\x72\x74\x41\x74\x74\x72\x69\x62\x75t\x65";${${"GLO\x42\x41\x4cS"}["\x6b\x68\x74\x65\x64ja\x74"]}=$this->getSelect();${${"G\x4c\x4f\x42\x41L\x53"}["\x66\x6ffw\x78\x6a\x77\x62\x6f\x73\x77\x6e"]}=$this->getData(self::SORT_ATTRIBUTE);if(!empty(${$wcbuego})){$select->order("IS\x4e\x55L\x4c(".self::SORT_ATTRIBUTE_ALIAS.") ".$this->getData(self::SORT_ORDER,"\x41SC"));$select->order(self::SORT_ATTRIBUTE_ALIAS." ".$this->getData(self::SORT_ORDER,"AS\x43"));}$select->order("\x67r\x6f\x75p_id");$select->order($this->getMainTable(true).".t\x79\x70\x65\x5f\x69\x64");}public function joinProductRelation(){$sdqyjvwhzwf="\x63o\x6editi\x6f\x6e";${"GL\x4fB\x41\x4cS"}["\x74\x79ws\x6a\x63\x6b"]="\x6a\x6fin\x54\x61ble";$xwiynimjr="\x63on\x64it\x69o\x6e";${"G\x4c\x4f\x42\x41LS"}["\x75\x7ar\x65\x67\x69\x75\x63\x64"]="\x6aoin\x54\x61\x62\x6ce\x41\x6c\x69\x61\x73";${${"\x47L\x4fBA\x4c\x53"}["\x75\x7a\x72\x65\x67\x69\x75c\x64"]}=self::CPR;${${"\x47\x4c\x4f\x42A\x4cS"}["\x79z\x6e\x77\x68\x73\x70\x7a\x6a\x71h"]}=$this->getTable("cat\x61log/\x70ro\x64\x75\x63t\x5f\x72e\x6c\x61tio\x6e");${$xwiynimjr}=${${"G\x4c\x4f\x42\x41L\x53"}["\x70\x74eg\x62\x6c\x6e\x67\x73"]}."\x2ech\x69\x6cd\x5fid=".self::MAIN_TABLE_SUBST."\x2ee\x6e\x74ity_i\x64 ";$this->joinMainTable(${${"G\x4cO\x42A\x4cS"}["\x70\x74e\x67\x62ln\x67\x73"]},${${"GL\x4fBA\x4c\x53"}["\x74\x79\x77\x73\x6a\x63\x6b"]},true,${$sdqyjvwhzwf});$this->addParentsCondition();return$this;}public function addParentsCondition(){if($this->parentsOnly()){$ihvxeieey="\x73\x65le\x63\x74";${$ihvxeieey}=$this->getSelect();$select->where(self::CPR."\x2e\x70\x61r\x65nt\x5f\x69\x64\x20\x49\x53 \x4eU\x4cL\x20");}}public function addAttributeFilter(){$cttqzys="\x63o\x6c\x75mns";$jkhyfpjrw="\x66\x6cat\x41\x6ci\x61\x73";$omqlydyr="\x66\x6c\x61\x74\x43\x6f\x6c\x75m\x6es2";${"\x47\x4c\x4fB\x41\x4c\x53"}["\x6d\x69ix\x62\x67\x7a\x6f"]="c\x6f\x6e\x64\x69\x74i\x6fn\x73";${$cttqzys}=$this->_columns;${$jkhyfpjrw}=$this->getProductFlatTable(true);${${"\x47\x4c\x4f\x42A\x4cS"}["\x63\x66\x77\x71\x63\x76\x74x\x79"]}=Mage::helper("n\x73ce\x78\x70\x6fr\x74/\x64at\x61\x5flo\x61\x64\x65\x72")->getProductFlatColumns($this->getStoreId());${"\x47LO\x42\x41\x4c\x53"}["e\x65\x6c\x6fr\x64g\x65zlx\x69"]="\x63o\x6c\x75\x6dn";${$omqlydyr}=array();foreach(${${"\x47L\x4f\x42\x41\x4c\x53"}["cf\x77qc\x76t\x78\x79"]} as${${"\x47\x4c\x4fB\x41\x4c\x53"}["\x65\x65\x6cordg\x65\x7alx\x69"]}){${"\x47\x4c\x4f\x42A\x4c\x53"}["\x70\x6b\x70\x62z\x66s\x64w\x6d\x63"]="\x66\x6c\x61t\x43olu\x6dns\x32";${${"\x47\x4cO\x42\x41\x4c\x53"}["p\x6b\x70\x62\x7a\x66\x73dw\x6d\x63"]}[${${"\x47\x4c\x4f\x42\x41LS"}["n\x72\x79\x79e\x74\x65\x6d\x71\x7a"]}]=${${"\x47L\x4fBA\x4c\x53"}["nry\x79e\x74em\x71\x7a"]};}${${"G\x4c\x4f\x42\x41L\x53"}["\x66uk\x65aju\x75\x6c\x69\x65"]}[${${"\x47LO\x42\x41L\x53"}["by\x6e\x6c\x70\x76\x68pn\x68"]}]=array_merge(${${"GLO\x42\x41L\x53"}["\x66\x75\x6b\x65\x61\x6a\x75\x75\x6c\x69\x65"]}[${${"\x47\x4c\x4f\x42A\x4c\x53"}["\x62yn\x6c\x70\x76\x68p\x6eh"]}],${${"GL\x4f\x42ALS"}["\x64\x69\x6amj\x76"]});${${"\x47L\x4f\x42\x41\x4c\x53"}["\x6dii\x78\x62g\x7ao"]}=$this->getConditions();if(isset(${${"GLO\x42\x41\x4c\x53"}["q\x6c\x61\x62\x75\x77c\x69y"]}[self::CONDITIONS][self::CONDITIONS])){${"G\x4c\x4f\x42\x41L\x53"}["\x6f\x78\x6d\x6e\x64\x6c\x68\x65\x68"]="r\x65\x73";$xdikdzg="\x72\x65s";${$xdikdzg}=$this->getProcessConditionsResult(${${"\x47\x4cO\x42A\x4cS"}["\x71\x6ca\x62u\x77c\x69\x79"]}[self::CONDITIONS]);${"GL\x4f\x42\x41\x4c\x53"}["\x66\x79ir\x70\x6cyb\x75\x77"]="\x61ttr\x69\x62ut\x65\x73T\x6f\x43he\x63\x6b";${"\x47\x4c\x4f\x42\x41L\x53"}["ja\x75\x79\x77v\x68"]="\x61\x74\x74\x72ib\x75\x74\x65\x73\x54\x6f\x43h\x65c\x6b";${${"\x47\x4cOB\x41\x4cS"}["b\x6e\x67j\x63\x61\x73\x63\x73wf"]}=${${"\x47L\x4f\x42\x41\x4cS"}["\x6f\x78m\x6ed\x6c\x68e\x68"]}["\x61\x74\x74rib\x75t\x65\x73"];$zwsjfmjjur="a\x6cl\x41\x74t\x72\x69b\x74\x75\x65\x73";${${"\x47\x4c\x4f\x42AL\x53"}["\x71\x6c\x61\x62\x75\x77\x63\x69\x79"]}[self::CONDITIONS]=${${"\x47\x4c\x4fBA\x4c\x53"}["\x72v\x71\x63\x6e\x6d\x76"]}["\x63\x6f\x6e\x64"];${${"GL\x4f\x42\x41\x4c\x53"}["\x66\x79\x69\x72\x70\x6cy\x62\x75\x77"]}=$this->getUnknownAttributes(${$zwsjfmjjur});$this->checkProductAttributes(${${"\x47\x4cO\x42A\x4c\x53"}["j\x61\x75\x79\x77\x76h"]});${${"\x47LO\x42A\x4c\x53"}["q\x63\x66h\x6c\x64"]}=Mage::registry("\x6e\x73\x63\x65\x78po\x72\x74_\x73\x74o\x72e");if(!empty(${${"GL\x4f\x42A\x4cS"}["q\x63fh\x6cd"]}))Mage::unregister("ns\x63export\x5fsto\x72e");Mage::register("ns\x63exp\x6fr\x74_s\x74o\x72e",$this->getStoreId());${${"\x47\x4cO\x42\x41L\x53"}["p\x64\x62\x73x\x73\x79"]}=Mage::getModel("n\x73\x63expo\x72t/rule")->initConditions(${${"\x47L\x4f\x42AL\x53"}["ql\x61b\x75wc\x69y"]}[self::CONDITIONS]);${${"G\x4c\x4f\x42A\x4c\x53"}["\x77\x69q\x68n\x68\x6ac\x77\x72"]}=$rule->getConditions()->asSqlWhere(${${"\x47\x4c\x4f\x42A\x4cS"}["f\x75\x6be\x61\x6a\x75\x75\x6cie"]});if(${${"GL\x4fB\x41LS"}["\x77\x69\x71\x68\x6e\x68\x6a\x63\x77r"]}!==false&&${${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x77i\x71h\x6ehjc\x77\x72"]}!="()"){$this->getSelect()->where(${${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x77\x69\x71h\x6e\x68j\x63w\x72"]});}}return$this;}protected function getProcessConditionsResult($condition){${"\x47LOB\x41\x4c\x53"}["\x72\x6d\x63\x79va\x65"]="a\x74\x74\x72\x69\x62tue\x73";${"\x47\x4cO\x42A\x4cS"}["w\x70cb\x6d\x6a\x76r\x6f"]="\x61\x74tr\x69b\x74\x75\x65\x73";${${"\x47L\x4fB\x41\x4c\x53"}["\x72m\x63y\x76\x61\x65"]}=array();foreach(${${"GLO\x42A\x4c\x53"}["e\x74n\x76\x74\x77dm\x74"]}[self::CONDITIONS]as${${"\x47\x4cOB\x41\x4cS"}["a\x6e\x70k\x72a"]}=>${${"\x47\x4c\x4fB\x41L\x53"}["w\x70\x78\x66\x63\x6bp"]}){${"\x47\x4cO\x42\x41\x4cS"}["\x6c\x6d\x6c\x6bp\x79\x66kf"]="\x63\x6f\x6ed\x69\x74i\x6fn\x49\x74\x65\x6d";if(isset(${${"\x47L\x4f\x42\x41\x4c\x53"}["l\x6dlkp\x79fkf"]}["co\x6e\x64i\x74\x69on\x73"])&&is_array(${${"\x47\x4c\x4fBA\x4c\x53"}["\x77p\x78\x66c\x6b\x70"]}["\x63\x6fnd\x69\x74\x69on\x73"])){${"G\x4c\x4f\x42ALS"}["\x78\x63\x68\x7a\x75\x73\x69\x78\x64"]="\x63\x6fn\x64it\x69\x6fn\x49\x74em";${"\x47\x4c\x4f\x42\x41LS"}["ml\x66\x73\x76d\x6c\x6dc\x74"]="\x63on\x64\x69\x74\x69\x6f\x6e";$rrklfguvbkni="k\x65\x79";$bjfgftxfgo="at\x74\x72\x69\x62\x74\x75e\x73";${"\x47\x4c\x4f\x42\x41\x4c\x53"}["d\x70o\x6e\x79\x72\x79"]="\x61\x74\x74\x72\x69\x62t\x75\x65\x73";${"\x47L\x4fB\x41L\x53"}["\x7a\x71\x6ceqg\x68a\x6b"]="\x72es";${${"\x47\x4cOB\x41\x4cS"}["z\x71\x6ce\x71\x67\x68\x61k"]}=$this->getProcessConditionsResult(${${"G\x4c\x4fB\x41\x4c\x53"}["x\x63\x68\x7a\x75\x73\x69\x78\x64"]});${${"G\x4c\x4f\x42\x41L\x53"}["d\x70o\x6e\x79\x72y"]}=array_merge(${$bjfgftxfgo},${${"\x47\x4cO\x42\x41\x4cS"}["\x72\x76qcn\x6d\x76"]}["a\x74\x74r\x69\x62\x75\x74\x65s"]);${${"\x47\x4c\x4f\x42\x41L\x53"}["\x78nw\x72z\x68k\x6fr"]}=array_unique(${${"\x47LOBA\x4c\x53"}["x\x6e\x77r\x7a\x68\x6b\x6fr"]});${${"G\x4cO\x42A\x4cS"}["\x6dl\x66\x73\x76\x64\x6c\x6d\x63t"]}[self::CONDITIONS][${$rrklfguvbkni}]=${${"\x47\x4cO\x42A\x4c\x53"}["\x72\x76\x71\x63\x6e\x6dv"]}["\x63\x6f\x6ed"];}else{$fotlnmehlha="\x61\x74\x74ri\x62u\x74e\x43\x6f\x64e";${${"\x47LO\x42\x41\x4cS"}["\x77\x6d\x67\x66\x79\x75\x69\x68\x63\x74\x6di"]}=${${"\x47L\x4f\x42\x41L\x53"}["\x77\x70\x78\x66\x63\x6bp"]}["a\x74\x74ri\x62\x75t\x65"];${${"\x47LOB\x41\x4c\x53"}["\x78n\x77rz\x68kor"]}[]=${$fotlnmehlha};if(strpos(${${"G\x4c\x4fBA\x4c\x53"}["\x77\x6d\x67\x66\x79u\x69h\x63\x74\x6d\x69"]},Nostress_Nscexport_Helper_Data_Feed::DUPLICATE_FLAT_CAT_COLUMN_PREFIX)!==false){${"\x47\x4c\x4fB\x41\x4c\x53"}["b\x66\x75z\x6bd\x76\x6b\x70\x74\x78o"]="ke\x79";$sjorflki="a\x74tribu\x74e\x43o\x64\x65";$kvswmdkrxrc="\x61\x74\x74\x72\x69\x62\x75\x74\x65\x43\x6f\x64e";$vuoexeeq="at\x74\x72i\x62\x75\x74\x65C\x6fd\x65";${$vuoexeeq}=str_replace(Nostress_Nscexport_Helper_Data_Feed::DUPLICATE_FLAT_CAT_COLUMN_PREFIX,"",${$sjorflki});${${"G\x4cO\x42\x41L\x53"}["\x65\x74\x6ev\x74\x77d\x6dt"]}[self::CONDITIONS][${${"GL\x4f\x42\x41\x4c\x53"}["\x62\x66\x75z\x6bd\x76\x6b\x70t\x78o"]}]["att\x72\x69\x62\x75\x74e"]=${$kvswmdkrxrc};}}}${"\x47\x4c\x4f\x42A\x4c\x53"}["\x6f\x68\x6f\x6f\x77b\x70\x71\x74\x64"]="\x63\x6f\x6ed\x69\x74\x69on";${${"G\x4c\x4f\x42A\x4cS"}["t\x68\x76i\x71\x78v\x61w\x6c"]}=array("c\x6f\x6e\x64"=>${${"\x47\x4cO\x42A\x4cS"}["o\x68\x6f\x6f\x77\x62\x70q\x74\x64"]},"\x61tt\x72ibu\x74\x65\x73"=>${${"GL\x4f\x42\x41\x4c\x53"}["\x77pc\x62\x6d\x6avro"]});return${${"G\x4cO\x42A\x4c\x53"}["\x74\x68\x76i\x71x\x76\x61\x77l"]};}protected function parentsOnly(){if($this->getCondition(Nostress_Nscexport_Helper_Data_Loader::CONDITION_PARENTS_CHILDS,0)==Nostress_Nscexport_Model_Config_Source_Parentschilds::PARENTS_ONLY)return true;else return false;}public function addTypeCondition(){$btbggw="\x61\x6c\x6cTy\x70\x65s";${"GL\x4f\x42\x41L\x53"}["ft\x69so\x6fi\x69\x79\x6c\x73"]="a\x74tr\x69\x62\x75\x74\x65";${"\x47\x4cO\x42\x41L\x53"}["\x7aj\x76\x64\x6a\x66\x64i"]="\x74\x79p\x65s";${${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x65p\x63\x62\x77\x75\x73h\x67"]}=$this->helper()->getAppProductTypes();${${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x66\x74\x69\x73\x6f\x6f\x69\x69yl\x73"]}=Mage::getModel("ca\x74a\x6c\x6fg/\x70rod\x75ct_\x74yp\x65")->getTypes();${"G\x4c\x4fBA\x4cS"}["\x67t\x6db\x67\x74\x6du"]="\x74\x79\x70\x65\x73";$khvimunkqlmp="\x74\x79\x70e\x73";${${"\x47LO\x42\x41\x4cS"}["\x68\x78\x79\x71f\x6d\x64evx"]}=$this->getCondition(Nostress_Nscexport_Helper_Data_Loader::CONDITION_TYPES,${${"\x47LOBA\x4c\x53"}["\x65\x70\x63\x62w\x75\x73\x68\x67"]});if(empty(${$khvimunkqlmp}))return$this;if(!is_array(${${"\x47\x4c\x4f\x42A\x4c\x53"}["\x68\x78\x79\x71\x66\x6dd\x65\x76\x78"]}))${${"\x47LOBALS"}["\x7a\x6a\x76\x64\x6a\x66\x64\x69"]}=explode(",",${${"\x47\x4cOBA\x4c\x53"}["hxyq\x66\x6d\x64\x65\x76x"]});if(count(${$btbggw})!=count(${${"\x47\x4cO\x42\x41\x4c\x53"}["\x67\x74m\x62\x67t\x6du"]})){$widjsvzikotj="\x73\x65l\x65\x63\x74";${$widjsvzikotj}=$this->getSelect();$lgjtpfvgkp="ty\x70\x65s";${${"\x47L\x4f\x42AL\x53"}["h\x78yq\x66\x6dde\x76x"]}="\x27".implode("',\x27",${$lgjtpfvgkp})."\x27";$select->where($this->getMainTable(true).".t\x79\x70\x65\x5fi\x64 I\x4e\x20({$types})");}return$this;}protected function joinParentProductFlat(){$rqiivwodn="j\x6f\x69\x6eT\x61\x62l\x65";if($this->parentsOnly())return$this;$rbymoprutbf="\x6a\x6fi\x6e\x54\x61\x62\x6c\x65";$pdylhyvsxt="\x63\x6f\x6edi\x74io\x6e";${"\x47\x4c\x4f\x42AL\x53"}["\x77\x68\x72\x6cem"]="jo\x69\x6e\x54a\x62l\x65\x41l\x69\x61\x73";${${"\x47L\x4f\x42A\x4c\x53"}["jn\x70\x71\x76\x65m\x70qk"]}=self::CPR;${${"\x47LO\x42A\x4cS"}["\x70\x74e\x67\x62\x6cngs"]}=self::PCPF;${"\x47L\x4fB\x41\x4c\x53"}["\x77\x65\x64ib\x6e\x6e\x62\x78"]="\x6d\x61\x69\x6e\x54\x61\x62l\x65\x41\x6ci\x61\x73";${$rbymoprutbf}=$this->getProductFlatTable();${$pdylhyvsxt}=${${"G\x4c\x4f\x42\x41LS"}["w\x68\x72le\x6d"]}.".\x65\x6et\x69\x74\x79\x5f\x69\x64\x3d".self::MAIN_TABLE_SUBST."\x2eparent\x5f\x69\x64";$this->joinTable(${${"GL\x4fB\x41L\x53"}["\x77\x65\x64\x69\x62\x6e\x6ebx"]},${${"\x47\x4c\x4f\x42\x41L\x53"}["\x70\x74eg\x62\x6c\x6e\x67\x73"]},${$rqiivwodn},true,${${"\x47\x4c\x4f\x42\x41\x4c\x53"}["et\x6e\x76\x74\x77\x64m\x74"]});return$this;}public function addVisibilityCondition(){${"\x47\x4cO\x42\x41\x4cS"}["vk\x6a\x72\x72\x67\x69"]="\x76\x69\x73\x69b\x69\x6c\x69\x74\x79";$yfdbfjknk="\x73e\x6ce\x63t";$this->joinParentProductFlat();${$yfdbfjknk}=$this->getSelect();$hqhoplrsi="p\x61\x72\x65nt\x56\x69\x73\x69\x62\x69\x6c\x69\x74\x79";$mvxkzru="w\x68ere";${"\x47LOB\x41\x4c\x53"}["\x71b\x72\x6e\x70\x73\x64"]="\x70\x61\x72\x65\x6e\x74\x56\x69\x73\x69\x62i\x6ci\x74y";${${"\x47\x4c\x4f\x42\x41\x4cS"}["\x76\x6b\x6a\x72r\x67\x69"]}=$this->getCondition(Nostress_Nscexport_Model_Profile::VISIBILITY);${${"\x47\x4c\x4f\x42ALS"}["\x71\x62rn\x70\x73\x64"]}=$this->getCondition(Nostress_Nscexport_Model_Profile::VISIBILITY_PARENT);${$mvxkzru}="";if(count(${${"\x47\x4c\x4fB\x41\x4c\x53"}["\x63\x68\x66\x73tt\x66\x73\x75\x69\x6a"]})){${${"\x47L\x4fB\x41L\x53"}["\x77\x69\x71\x68nhj\x63\x77\x72"]}.=$select->getAdapter()->quoteInto("{$this->getMainTable(true)}\x2evisibi\x6ci\x74y\x20\x49\x4e(?)",${${"\x47\x4c\x4f\x42\x41\x4cS"}["ch\x66\x73\x74\x74\x66s\x75\x69j"]});}if(!$this->parentsOnly()&&count(${$hqhoplrsi})){$piayejl="w\x68e\x72\x65";if(!empty(${$piayejl})){${"\x47L\x4f\x42\x41\x4c\x53"}["\x69\x6e\x72\x64\x78pj\x64\x76"]="\x77he\x72\x65";${${"\x47L\x4f\x42A\x4cS"}["\x69n\x72\x64\x78\x70\x6a\x64v"]}.=" OR\x20";}${${"\x47\x4c\x4fB\x41\x4c\x53"}["w\x69\x71\x68nh\x6ac\x77r"]}.=$select->getAdapter()->quoteInto(self::PCPF.".visibil\x69t\x79\x20 I\x4e(?)",${${"\x47\x4c\x4fB\x41\x4cS"}["\x69\x7a\x63\x6f\x68\x74h\x73\x6b"]});}if(!empty(${${"G\x4c\x4f\x42\x41L\x53"}["\x77\x69q\x68\x6e\x68j\x63\x77\x72"]})){$spupxgueql="whe\x72\x65";$select->where(${$spupxgueql});}}protected function getManageStockCondition($tableAlias){$gcobkangdzxm="\x6d\x61\x6e\x61\x67e\x53\x74\x6f\x63k\x43on\x64\x69tio\x6e";$yyfpxljh="\x6d\x61n\x61ge\x53\x74\x6f\x63k\x43o\x6edi\x74\x69\x6f\x6e";$yqiejavktxaj="m\x61\x6e\x61ge\x53t\x6fc\x6bV\x61\x6c\x75e";${"\x47\x4cO\x42\x41L\x53"}["\x68\x69\x61\x6es\x6d"]="\x6d\x61na\x67e\x53t\x6f\x63\x6bCon\x64it\x69\x6fn";${${"\x47\x4c\x4f\x42AL\x53"}["\x6d\x62k\x66\x6cf\x68\x62"]}=(int)Mage::getStoreConfig(Mage_CatalogInventory_Model_Stock_Item::XML_PATH_MANAGE_STOCK,$this->getStoreId());${$gcobkangdzxm}="";if(${$yqiejavktxaj})${${"G\x4cO\x42\x41\x4c\x53"}["\x68\x69an\x73m"]}="{$tableAlias}.\x75\x73e\x5f\x63onfi\x67\x5fm\x61n\x61ge\x5f\x73to\x63\x6b\x20\x3d\x20'\x30\x27\x20\x41\x4eD\x20{$tableAlias}\x2em\x61n\x61ge\x5fs\x74o\x63\x6b \x3d '0'\x20";else${$yyfpxljh}="{$tableAlias}.use\x5f\x63o\x6e\x66\x69g_\x6d\x61\x6eage\x5f\x73\x74\x6fc\x6b\x20= \x27\x31\x27\x20OR\x20({$tableAlias}.\x75se\x5f\x63\x6f\x6e\x66ig_\x6d\x61nag\x65_\x73\x74\x6f\x63k\x20\x3d '0'\x20\x41N\x44 {$tableAlias}.m\x61\x6eage_s\x74oc\x6b = '0')\x20";return${${"\x47LOB\x41\x4c\x53"}["vh\x76c\x77p\x64\x70k\x78"]};}protected function getMinSaleQtyCondition($tableAlias){${${"GL\x4fB\x41\x4c\x53"}["\x73\x64\x6e\x77\x68\x66u\x73\x6f\x68l\x76"]}=(int)Mage::getStoreConfig(Mage_CatalogInventory_Model_Stock_Item::XML_PATH_MIN_SALE_QTY,$this->getStoreId());${${"\x47\x4cOB\x41LS"}["jn\x72\x66i\x69\x69\x6c\x72\x79"]}="\x49\x46({$tableAlias}\x2e\x75s\x65_\x63onfig\x5fm\x69n_\x73a\x6ce\x5f\x71\x74y\x20= '1',\x20\x27{$globalMinSaleQty}',{$tableAlias}.m\x69n_s\x61le\x5fq\x74\x79) ";$vonoxcb="\x6d\x69n\x53a\x6c\x65\x51\x74y\x43on\x64\x69\x74\x69\x6f\x6e";return${$vonoxcb};}public function addStockCondition(){if($this->getCondition(Nostress_Nscexport_Helper_Data_Loader::CONDITION_EXPORT_OUT_OF_STOCK,0)==0){${"G\x4cOB\x41\x4c\x53"}["ek\x70\x77l\x69yc\x64g\x6c"]="cond\x69t\x69\x6f\x6e";${"G\x4c\x4f\x42A\x4c\x53"}["vb\x6c\x79\x63\x6f\x67s"]="\x6dana\x67\x65P\x61\x72e\x6e\x74\x53\x74o\x63\x6bC\x6fn\x64\x69\x74i\x6fn";$this->joinParentStock();$iefjdjb="\x63\x6fn\x64\x69\x74\x69o\x6e";${${"\x47\x4cOB\x41\x4c\x53"}["\x6b\x68\x74\x65d\x6aa\x74"]}=$this->getSelect();${${"G\x4c\x4f\x42\x41L\x53"}["\x76\x62l\x79\x63\x6f\x67\x73"]}=$this->getManageStockCondition(self::PCISI);${${"\x47\x4c\x4f\x42A\x4cS"}["v\x68vc\x77\x70\x64\x70\x6bx"]}=$this->getManageStockCondition(self::CISI);${${"\x47\x4c\x4fB\x41\x4c\x53"}["\x65\x74\x6e\x76t\x77\x64m\x74"]}="";switch($this->getStockStatusDependence()){case Nostress_Nscexport_Model_Config_Source_Stockdependence::QTY:${${"\x47L\x4f\x42\x41LS"}["ek\x70\x77l\x69y\x63\x64g\x6c"]}=self::CISI.".\x71ty \x3e\x20\x30 ";$select->where("({$condition}) \x4fR\x20({$manageStockCondition})");break;case Nostress_Nscexport_Model_Config_Source_Stockdependence::STOCK:${${"G\x4c\x4f\x42A\x4c\x53"}["\x65t\x6e\x76twd\x6dt"]}=self::CISS.".\x73t\x6f\x63k\x5f\x73t\x61\x74\x75s = ".self::STOCK_STATUS."\x20"."A\x4eD (".self::PCISS.".\x73\x74ock\x5fsta\x74\x75s =\x20".self::STOCK_STATUS." O\x52\x20".self::PCISS.".st\x6fck_st\x61\x74u\x73 \x49\x53 N\x55LL\x20)";$select->where("({$condition})");break;default:${$iefjdjb}=self::CISS."\x2es\x74\x6f\x63\x6b\x5fst\x61t\x75s\x20\x3d\x20".self::STOCK_STATUS."\x20A\x4eD\x20(".self::CISI.".q\x74\x79\x20\x3e\x200\x20\x4f\x52 {$this->getProductFlatTable(true)}.t\x79\x70e\x5f\x69\x64 \x3c> \x27\x73\x69m\x70le\x27) "."\x41N\x44\x20(".self::PCISS."\x2e\x73to\x63\x6b_\x73t\x61t\x75s \x3d\x20".self::STOCK_STATUS." O\x52 ".self::PCISS."\x2e\x73\x74\x6f\x63k\x5fsta\x74\x75\x73 IS\x20NUL\x4c \x4fR\x20({$manageParentStockCondition})) ";$select->where("({$condition})\x20\x4f\x52 ({$manageStockCondition})");break;}}return$this;}public function joinStock(){$this->joinNormalStockStatus();$this->joinNormalStockItem();}public function joinParentStock(){$this->joinParentStockStatus();$this->joinParentStockItem();}protected function joinNormalStockStatus(){$cobsxhnfdjub="\x6dain\x54\x61bl\x65\x41\x6c\x69\x61\x73";${"\x47\x4c\x4fB\x41\x4c\x53"}["n\x6fg\x79\x68\x63"]="\x70\x72\x6f\x64\x75\x63tI\x64\x43\x6fl\x75\x6d\x6eN\x61\x6d\x65";${"GL\x4f\x42\x41\x4c\x53"}["c\x6c\x65\x76\x63im\x62"]="\x6a\x6fin\x54\x61b\x6ce\x41l\x69a\x73";${$cobsxhnfdjub}=$this->getMainTable(true);${"GL\x4fBA\x4c\x53"}["lel\x73\x71\x75\x6ct\x73\x63\x72"]="\x6ao\x69\x6eTa\x62\x6c\x65A\x6c\x69as";${${"\x47\x4cOBALS"}["no\x67\x79\x68\x63"]}="e\x6e\x74it\x79_i\x64";${${"GL\x4f\x42\x41\x4c\x53"}["\x63\x6ce\x76\x63im\x62"]}=self::CISS;$this->joinStockStatus(${${"\x47\x4c\x4fBA\x4c\x53"}["\x6a\x6epq\x76\x65\x6d\x70\x71\x6b"]},${${"\x47\x4cOB\x41\x4c\x53"}["\x6c\x65\x6c\x73q\x75\x6ct\x73\x63r"]},${${"\x47L\x4f\x42\x41\x4c\x53"}["\x62\x6e\x7a\x70p\x74\x67\x64"]});}public function joinParentStockStatus(){${"\x47L\x4f\x42A\x4c\x53"}["\x6e\x63\x62zlmd\x68\x76"]="\x6da\x69\x6e\x54\x61b\x6ce\x41\x6c\x69as";${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x70\x63\x79\x77\x6ee\x72"]="p\x72\x6f\x64\x75\x63\x74\x49\x64C\x6f\x6c\x75m\x6e\x4e\x61\x6d\x65";${${"\x47\x4cO\x42\x41\x4c\x53"}["\x6e\x63\x62z\x6cm\x64\x68\x76"]}=self::CPR;${"\x47LOB\x41L\x53"}["\x6e\x72j\x69\x6a\x73\x68z\x78\x70"]="mai\x6eT\x61\x62\x6c\x65\x41\x6ci\x61\x73";${${"\x47\x4c\x4f\x42\x41\x4cS"}["b\x6ez\x70p\x74\x67d"]}="\x70\x61r\x65n\x74_id";${"\x47\x4c\x4fB\x41\x4cS"}["mo\x74\x63yo\x65\x78\x77\x64"]="\x6a\x6f\x69\x6eT\x61b\x6c\x65\x41li\x61\x73";${${"\x47\x4c\x4f\x42\x41L\x53"}["pte\x67\x62\x6cn\x67\x73"]}=self::PCISS;$this->joinStockStatus(${${"\x47L\x4f\x42A\x4c\x53"}["n\x72ji\x6as\x68\x7a\x78\x70"]},${${"\x47\x4cO\x42ALS"}["\x6d\x6f\x74\x63\x79\x6f\x65\x78\x77\x64"]},${${"GL\x4f\x42\x41\x4c\x53"}["\x70\x63\x79wner"]});}protected function joinStockStatus($mainTableAlias,$joinTableAlias,$productIdColumnName){$rrarjbxeiwr="\x6d\x61\x69n\x54ab\x6c\x65\x41li\x61s";$qhpxbcmf="\x6a\x6f\x69\x6e\x49f\x43\x6fl\x75\x6d\x6es\x45m\x70\x74\x79";$yhmnzwzkv="\x6a\x6fi\x6eT\x61\x62\x6c\x65\x41\x6c\x69\x61s";${"\x47L\x4f\x42\x41LS"}["\x67c\x67t\x68d\x72"]="j\x6f\x69nTabl\x65\x41l\x69\x61s";${$qhpxbcmf}=$this->getCondition(Nostress_Nscexport_Helper_Data_Loader::CONDITION_EXPORT_OUT_OF_STOCK,0)==0;$ukrpgpb="\x6a\x6fi\x6eT\x61\x62\x6c\x65";${${"\x47\x4cO\x42AL\x53"}["\x79\x7an\x77\x68\x73\x70\x7a\x6a\x71\x68"]}=$this->getTable("c\x61t\x61log\x69\x6e\x76e\x6e\x74o\x72\x79/\x73\x74ock_\x73ta\x74\x75\x73");${${"G\x4cO\x42ALS"}["\x65\x74nv\x74\x77\x64\x6dt"]}=${${"GLO\x42A\x4c\x53"}["\x67\x63\x67\x74\x68\x64r"]}."\x2e\x70\x72\x6fd\x75\x63t_\x69\x64=".self::MAIN_TABLE_SUBST."\x2e{$productIdColumnName}\x20A\x4e\x44\x20{$joinTableAlias}.w\x65\x62\x73\x69te_i\x64\x20\x3d{$this->getWebsiteId()} ";$this->joinTable(${$rrarjbxeiwr},${$yhmnzwzkv},${$ukrpgpb},${${"G\x4c\x4fB\x41\x4cS"}["\x68cf\x69en\x6e\x72\x75\x75\x62"]},${${"GLO\x42\x41L\x53"}["\x65t\x6e\x76\x74\x77\x64\x6d\x74"]});}protected function joinNormalStockItem(){$kpyakmb="ma\x69\x6e\x54\x61\x62l\x65\x41l\x69\x61s";${$kpyakmb}=$this->getMainTable(true);$uusfcgrto="\x70\x72\x6f\x64\x75\x63\x74\x49d\x43\x6f\x6c\x75m\x6e\x4e\x61\x6d\x65";$mtbqciq="j\x6fi\x6eT\x61b\x6ce\x41l\x69\x61\x73";${${"\x47\x4cO\x42A\x4c\x53"}["\x62\x6ez\x70pt\x67d"]}="e\x6e\x74i\x74\x79\x5fi\x64";${${"\x47\x4c\x4f\x42A\x4c\x53"}["\x70t\x65\x67\x62l\x6e\x67s"]}=self::CISI;$this->joinStockItem(${${"\x47\x4cOB\x41\x4c\x53"}["jnp\x71ve\x6dp\x71\x6b"]},${$mtbqciq},${$uusfcgrto});}public function joinParentStockItem(){${${"G\x4c\x4fB\x41\x4cS"}["\x6an\x70\x71\x76e\x6d\x70q\x6b"]}=self::CPR;$yeccydhkrfg="j\x6f\x69\x6eT\x61b\x6ceAli\x61s";${${"GL\x4fB\x41LS"}["bn\x7ap\x70\x74\x67\x64"]}="\x70ar\x65nt\x5fid";${${"\x47\x4cO\x42AL\x53"}["\x70te\x67\x62\x6c\x6e\x67s"]}=self::PCISI;$this->joinStockItem(${${"\x47\x4c\x4f\x42\x41\x4c\x53"}["j\x6e\x70\x71\x76\x65m\x70\x71\x6b"]},${$yeccydhkrfg},${${"G\x4c\x4fBA\x4c\x53"}["b\x6ezp\x70t\x67\x64"]});}protected function joinStockItem($mainTableAlias,$joinTableAlias,$productIdColumnName){${"\x47L\x4f\x42\x41L\x53"}["\x77bd\x62\x68\x65tf\x62\x6b"]="\x6a\x6f\x69n\x49\x66\x43\x6fl\x75\x6dn\x73\x45\x6dp\x74y";${${"\x47\x4c\x4fB\x41L\x53"}["hc\x66\x69e\x6e\x6er\x75\x75b"]}=$this->getCondition(Nostress_Nscexport_Helper_Data_Loader::CONDITION_EXPORT_OUT_OF_STOCK,0)==0;if($this->getStockStatusDependence()==Nostress_Nscexport_Model_Config_Source_Stockdependence::QTY)${${"\x47LOB\x41L\x53"}["\x68\x63\x66\x69e\x6e\x6er\x75\x75\x62"]}=true;${${"\x47\x4c\x4f\x42\x41L\x53"}["y\x7a\x6ew\x68\x73\x70\x7aj\x71\x68"]}=$this->getTable("c\x61\x74\x61l\x6fg\x69\x6e\x76entory/\x73t\x6f\x63\x6b_\x69t\x65m");${"\x47\x4c\x4f\x42\x41\x4c\x53"}["rw\x71vj\x78\x67\x6c"]="ma\x69\x6eT\x61\x62\x6c\x65A\x6cia\x73";${${"\x47\x4cO\x42A\x4c\x53"}["e\x74\x6e\x76\x74\x77\x64\x6d\x74"]}=${${"\x47L\x4fB\x41\x4cS"}["p\x74\x65\x67bln\x67\x73"]}."\x2eprodu\x63t_\x69d=".self::MAIN_TABLE_SUBST.".{$productIdColumnName} ";$this->joinTable(${${"G\x4c\x4f\x42\x41\x4cS"}["\x72\x77\x71\x76jxg\x6c"]},${${"\x47L\x4fBAL\x53"}["p\x74egbl\x6e\x67\x73"]},${${"G\x4c\x4f\x42AL\x53"}["yz\x6ew\x68\x73p\x7a\x6a\x71h"]},${${"\x47\x4cO\x42AL\x53"}["\x77b\x64\x62\x68\x65\x74f\x62k"]},${${"\x47L\x4f\x42\x41L\x53"}["e\x74n\x76t\x77\x64m\x74"]});}public function joinSuperAttributesCache(){$nhxpiewyffj="\x6ao\x69n\x54\x61\x62le\x41li\x61s";${$nhxpiewyffj}=self::NCSA;$qkyvgygmkxlq="\x63on\x64\x69\x74\x69\x6fn";${${"GLOBA\x4c\x53"}["yz\x6ew\x68\x73p\x7a\x6aqh"]}=$this->getTable("\x6es\x63\x65\x78po\x72t/c\x61c\x68e_su\x70e\x72a\x74tri\x62utes");${$qkyvgygmkxlq}="{$joinTableAlias}\x2ep\x72\x6f\x64\x75ct_i\x64 \x3d".self::MAIN_TABLE_SUBST.".en\x74\x69\x74\x79_\x69\x64\x20\x41\x4eD {$joinTableAlias}.st\x6f\x72e_\x69\x64\x20= {$this->getStoreId()}";$this->joinMainTable(${${"\x47\x4c\x4f\x42A\x4c\x53"}["pteg\x62\x6c\x6e\x67\x73"]},${${"G\x4c\x4f\x42\x41\x4c\x53"}["\x79\x7a\x6e\x77\x68\x73\x70\x7aj\x71h"]},false,${${"\x47\x4cO\x42\x41\x4cS"}["\x65t\x6e\x76tw\x64m\x74"]});return$this;}public function joinMediaGalleryCache(){${"\x47\x4cO\x42\x41\x4c\x53"}["\x7a\x69u\x75\x66\x6b\x78ki\x75"]="\x65xp\x6f\x72\x74\x41\x6cl\x49ma\x67\x65\x73";${"G\x4c\x4fB\x41L\x53"}["\x62\x6a\x6d\x6bj\x69\x75"]="expo\x72\x74\x41\x6cl\x49m\x61\x67e\x73";${${"\x47\x4c\x4f\x42A\x4c\x53"}["b\x6a\x6d\x6b\x6a\x69u"]}=$this->getData(self::EXPORT_ALL_IMAGES,"1");${"G\x4c\x4fBAL\x53"}["\x70\x72\x69\x62\x71\x6fg\x71bp\x74\x76"]="\x63\x6f\x6e\x64\x69\x74io\x6e";$hvmrhxnsol="jo\x69\x6e\x54a\x62\x6ceAl\x69a\x73";if(${${"\x47\x4cO\x42\x41\x4c\x53"}["ziu\x75\x66k\x78\x6b\x69\x75"]}==="\x30")return$this;${${"\x47\x4c\x4f\x42\x41\x4c\x53"}["p\x74\x65\x67\x62\x6c\x6e\x67\x73"]}=self::NCMG;${${"G\x4c\x4f\x42AL\x53"}["\x79\x7a\x6ewh\x73\x70z\x6a\x71\x68"]}=$this->getTable("\x6escexp\x6f\x72\x74/c\x61c\x68\x65\x5f\x6de\x64\x69\x61gal\x6c\x65r\x79");${${"\x47\x4c\x4f\x42A\x4c\x53"}["\x65t\x6ev\x74w\x64mt"]}="{$joinTableAlias}.\x70ro\x64\x75\x63t\x5fid \x3d".self::MAIN_TABLE_SUBST."\x2ee\x6et\x69ty\x5f\x69\x64 AND {$joinTableAlias}.s\x74\x6fr\x65\x5f\x69d\x20\x3d\x20{$this->getStoreId()}";$this->joinMainTable(${$hvmrhxnsol},${${"\x47\x4cO\x42\x41\x4c\x53"}["\x79znw\x68\x73\x70\x7a\x6a\x71\x68"]},false,${${"G\x4c\x4f\x42AL\x53"}["p\x72\x69b\x71o\x67\x71b\x70t\x76"]});return$this;}public function joinReview(){${${"G\x4c\x4f\x42\x41\x4cS"}["\x70\x74egb\x6c\x6e\x67\x73"]}=self::RRA;${"GL\x4fBA\x4c\x53"}["y\x64\x79\x78\x71c\x7a\x70"]="\x63\x6fn\x64\x69\x74i\x6fn";${${"G\x4cO\x42A\x4c\x53"}["yz\x6e\x77\x68\x73\x70zjq\x68"]}=$this->getTable("r\x65vi\x65\x77/\x72ev\x69ew\x5fag\x67r\x65ga\x74\x65");${${"G\x4c\x4fBA\x4c\x53"}["\x65\x74\x6evt\x77d\x6d\x74"]}="{$joinTableAlias}.\x65n\x74\x69\x74\x79_pk\x5fv\x61l\x75\x65\x20\x3d\x20".self::MAIN_TABLE_SUBST."\x2e\x65n\x74it\x79\x5f\x69d \x41N\x44 {$joinTableAlias}.s\x74\x6fr\x65_id \x3d\x20{$this->getStoreId()}";$this->joinMainTable(${${"\x47L\x4fB\x41\x4c\x53"}["\x70\x74\x65\x67\x62\x6cn\x67\x73"]},${${"G\x4cO\x42\x41L\x53"}["y\x7an\x77\x68\x73\x70\x7a\x6aqh"]},false,${${"\x47L\x4f\x42A\x4cS"}["\x79\x64yx\x71c\x7ap"]});return$this;}public function joinTaxonomy(){${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x6bb\x79\x6aoy\x72n"]="c\x6f\x64\x65";${"G\x4c\x4f\x42\x41\x4cS"}["\x6f\x79\x69\x66\x6br\x79\x6b\x70"]="j\x6fin\x54\x61\x62\x6c\x65";${"\x47\x4c\x4fBA\x4c\x53"}["eq\x62\x64\x77\x71p\x66gfn"]="\x6d\x61i\x6eT\x61\x62\x6c\x65Al\x69as";${"\x47\x4cOBA\x4c\x53"}["\x64\x70\x68\x6b\x69\x66\x76\x78"]="ta\x78\x6f\x6eo\x6dy\x43o\x6c\x75\x6dn";${${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x65q\x62d\x77qp\x66\x67\x66n"]}=$this->getCategoryFlatTable(true);${${"G\x4cO\x42\x41\x4c\x53"}["\x70\x74e\x67b\x6cngs"]}=self::NCEC;${${"GLOB\x41\x4c\x53"}["\x6f\x79i\x66kr\x79\x6bp"]}=$this->getTable("\x6e\x73\x63\x65xpor\x74/\x63a\x63\x68e\x5feng\x69n\x65c\x61t\x65g\x6fry");${"\x47LO\x42\x41\x4cS"}["\x65gc\x6c\x75\x64\x71"]="m\x61i\x6e\x54\x61\x62\x6ceAl\x69as";${${"G\x4c\x4f\x42\x41L\x53"}["\x64p\x68\x6b\x69\x66\x76x"]}=$this->getTaxonomyColumnName();if(!isset(${${"\x47L\x4f\x42\x41\x4cS"}["\x62\x72\x79\x75\x76\x75\x62b\x6cm"]}))return$this;${${"G\x4c\x4fBA\x4cS"}["\x66\x7a\x6c\x73cx\x65fv\x79"]}=$this->getTaxonomyLocale();${${"GL\x4f\x42AL\x53"}["\x6b\x62\x79j\x6f\x79\x72\x6e"]}=$this->getTaxonomyCode();${"\x47\x4cO\x42A\x4c\x53"}["s\x6b\x6e\x6c\x73\x6ds"]="\x6a\x6f\x69\x6e\x54\x61\x62\x6c\x65";${"G\x4cO\x42\x41L\x53"}["nm\x71\x70p\x79s\x6d"]="\x74\x61xon\x6f\x6dy\x43\x6f\x6cu\x6d\x6e";if(!isset(${${"\x47\x4cOBALS"}["fz\x6csc\x78\x65f\x76y"]}))return$this;${"\x47\x4cO\x42\x41\x4cS"}["\x6c\x6ba\x73\x6c\x77\x71\x6d\x74"]="\x63o\x6e\x64\x69\x74\x69\x6f\x6e";${"G\x4c\x4fB\x41LS"}["\x75ph\x66\x67\x6ccc\x6aq\x6c"]="\x63\x6f\x6e\x64\x69tion";${${"\x47\x4cOBAL\x53"}["\x6c\x6bas\x6c\x77q\x6dt"]}="{$joinTableAlias}\x2e\x68ash\x20= ".self::MAIN_TABLE_SUBST."\x2e{$taxonomyColumn} \x41\x4eD l\x6f\x63\x61\x6ce \x3d \x27{$locale}\x27 A\x4eD\x20t\x61\x78\x6fnom\x79_co\x64\x65\x20\x3d\x27{$code}'";if($this->joinTable(${${"GLO\x42\x41LS"}["\x65g\x63l\x75d\x71"]},${${"GL\x4fB\x41\x4c\x53"}["\x70teg\x62\x6c\x6e\x67s"]},${${"G\x4c\x4fB\x41L\x53"}["\x73\x6bn\x6c\x73m\x73"]},false,${${"GL\x4f\x42\x41\x4c\x53"}["u\x70h\x66\x67l\x63\x63\x6a\x71l"]}))$this->checkCategoryAttributes(array(${${"\x47\x4c\x4f\x42A\x4c\x53"}["\x6e\x6d\x71\x70\x70\x79\x73\x6d"]}));return$this;}public function joinProductEntity(){$nwrfygnik="\x6ao\x69nT\x61\x62\x6c\x65\x41\x6c\x69as";${${"GL\x4fBA\x4c\x53"}["\x6a\x6e\x70q\x76\x65\x6dp\x71k"]}=$this->getMainTable(true);$vovitdmv="\x6ao\x69\x6eTa\x62\x6c\x65\x41\x6ci\x61\x73";$csbyvmua="\x6ao\x69\x6eT\x61\x62\x6c\x65";$tqmelm="j\x6fi\x6eT\x61\x62\x6c\x65";${$vovitdmv}=self::CPE;$nyctva="\x6d\x61\x69n\x54\x61\x62\x6c\x65\x41li\x61\x73";${$tqmelm}=$this->getTable("c\x61t\x61\x6cog/p\x72\x6fduc\x74");${${"\x47L\x4f\x42AL\x53"}["e\x74\x6ev\x74w\x64\x6d\x74"]}="{$joinTableAlias}.ent\x69t\x79_i\x64 \x3d\x20".self::MAIN_TABLE_SUBST."\x2e\x65\x6e\x74i\x74y\x5f\x69\x64";$this->joinTable(${$nyctva},${$nwrfygnik},${$csbyvmua},false,${${"\x47\x4c\x4f\x42A\x4cS"}["\x65t\x6ev\x74\x77d\x6d\x74"]});return$this;}public function joinProductUrlRewrite(){$irfgrmeltx="\x6a\x6f\x69\x6e\x54\x61b\x6ce\x41\x6c\x69\x61s";$aomughg="\x6aoi\x6e\x54\x61\x62\x6c\x65\x41\x6c\x69\x61\x73";${"G\x4cO\x42A\x4c\x53"}["\x76\x6be\x73\x61\x75x\x62\x66ll"]="j\x6f\x69n\x54\x61\x62\x6c\x65";${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x64\x6d\x71\x65\x6a\x63"]="c\x6f\x6edi\x74i\x6fn";${$aomughg}=self::CUR;${"GLO\x42\x41L\x53"}["\x69\x69zut\x78\x74\x69\x75\x7aum"]="c\x6f\x6e\x64\x69\x74i\x6fn";${${"\x47\x4c\x4fBA\x4c\x53"}["\x76\x6b\x65\x73a\x75xb\x66\x6cl"]}=$this->getTable("\x63ore/url_\x72\x65w\x72\x69te");if($this->helper()->isMageEnterprise()){try{${"\x47\x4c\x4f\x42\x41\x4c\x53"}["h\x6a\x6e\x71\x6a\x77\x7a\x70\x67\x6f"]="\x6aoi\x6e\x54\x61\x62\x6c\x65";$uxxnmmir="\x6a\x6f\x69\x6eT\x61\x62\x6ce\x41\x6cias";${$uxxnmmir}=self::EUR;${${"\x47\x4c\x4fBA\x4c\x53"}["hj\x6e\x71\x6aw\x7a\x70\x67\x6f"]}=$this->getTable("e\x6e\x74\x65\x72\x70\x72\x69se_url\x72\x65w\x72\x69te/\x75r\x6c\x5f\x72\x65w\x72\x69te");if(empty(${${"\x47L\x4f\x42\x41L\x53"}["\x79z\x6ew\x68\x73pz\x6a\x71h"]}))${${"\x47L\x4f\x42A\x4c\x53"}["yz\x6e\x77h\x73\x70z\x6a\x71\x68"]}=$this->getTable("c\x6f\x72e/\x75\x72l_\x72\x65\x77\x72\x69\x74e");}catch(Exception$e){${"\x47LO\x42\x41\x4c\x53"}["\x73\x71\x6c\x6c\x6emk\x6ab"]="\x6aoin\x54abl\x65\x41l\x69a\x73";${"G\x4c\x4f\x42\x41\x4cS"}["\x74e\x75\x78\x72\x6ck\x71"]="\x6ao\x69n\x54\x61b\x6ce";${${"\x47LO\x42\x41\x4cS"}["\x73\x71l\x6c\x6emkj\x62"]}=self::CUR;${${"GLOBA\x4c\x53"}["\x74eu\x78\x72\x6c\x6b\x71"]}=$this->getTable("c\x6fre/\x75r\x6c_\x72ew\x72\x69\x74\x65");}}${${"\x47\x4c\x4fB\x41L\x53"}["i\x69z\x75\x74\x78t\x69\x75z\x75\x6d"]}="{$joinTableAlias}.p\x72o\x64\x75\x63t\x5fid =\x20".self::MAIN_TABLE_SUBST."\x2eenti\x74\x79_\x69\x64 ";${${"\x47\x4c\x4f\x42\x41L\x53"}["\x64\x6d\x71\x65\x6ac"]}.="\x41\x4eD\x20{$joinTableAlias}.\x73tor\x65_id\x20\x3d {$this->getStoreId()} ";${${"\x47LOBA\x4c\x53"}["et\x6e\x76\x74\x77\x64\x6d\x74"]}.="\x41\x4e\x44 {$joinTableAlias}\x2e\x63\x61t\x65gory\x5f\x69d\x20I\x53\x20\x4e\x55L\x4c\x20";$this->joinMainTable(${$irfgrmeltx},${${"\x47\x4c\x4f\x42A\x4c\x53"}["y\x7a\x6e\x77\x68s\x70\x7a\x6aq\x68"]},false,${${"G\x4c\x4f\x42\x41LS"}["\x65\x74n\x76\x74\x77d\x6d\x74"]});return$this;}public function joinWeee(){if(!$this->isWeeeEnabled())return$this;$qkjfdzxudj="\x6ao\x69\x6eTa\x62le\x41lia\x73";${$qkjfdzxudj}=self::NCW;$rfpnwwdgvd="j\x6fi\x6eT\x61\x62\x6c\x65";${$rfpnwwdgvd}=$this->getTable("n\x73ce\x78p\x6f\x72\x74/\x63\x61\x63h\x65\x5f\x77\x65ee");${${"G\x4c\x4fBA\x4c\x53"}["\x65\x74nv\x74w\x64m\x74"]}="{$joinTableAlias}.p\x72odu\x63\x74_\x69d\x20=\x20".self::MAIN_TABLE_SUBST.".\x65n\x74\x69t\x79_\x69d \x41N\x44 {$joinTableAlias}\x2ewe\x62s\x69\x74\x65\x5f\x69d\x20\x3d \x27{$this->getWebsiteId()}\x27\x20";$this->joinMainTable(${${"\x47\x4cO\x42\x41\x4c\x53"}["p\x74\x65gb\x6cn\x67\x73"]},${${"GLO\x42\x41\x4c\x53"}["y\x7a\x6e\x77\x68s\x70z\x6a\x71h"]},true,${${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x65t\x6ev\x74\x77\x64\x6dt"]});return$this;}public function joinTax(){${${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x70\x74\x65\x67bl\x6e\x67\x73"]}=self::NCT;${"\x47\x4cO\x42ALS"}["\x6e\x6b\x6eswc\x69"]="\x6a\x6f\x69n\x49\x66C\x6fl\x75\x6d\x6e\x73Em\x70ty";$tztlwsmpkuo="\x6ao\x69\x6e\x54\x61\x62\x6c\x65";${$tztlwsmpkuo}=$this->getTable("n\x73\x63\x65x\x70\x6frt/c\x61\x63he\x5f\x74\x61\x78");$icfkmurlg="\x6ao\x69\x6e\x54a\x62\x6c\x65\x41li\x61\x73";${${"G\x4c\x4fB\x41\x4c\x53"}["\x65\x74n\x76\x74w\x64m\x74"]}="{$joinTableAlias}.t\x61x\x5f\x63\x6c\x61ss_\x69d \x3d\x20".self::MAIN_TABLE_SUBST.".\x74\x61x\x5f\x63\x6c\x61ss_i\x64 AN\x44 {$joinTableAlias}\x2estore_\x69\x64\x20=\x20{$this->getStoreId()}";$eromfqyml="p\x72\x69\x63e\x43\x6f\x6cu\x6d\x6e\x73";${${"\x47L\x4f\x42\x41\x4c\x53"}["\x74l\x67k\x6a\x61\x79"]}=$this->getColumns(self::CIP);${"\x47LO\x42\x41L\x53"}["\x71\x73\x6ayz\x70\x61\x69"]="\x63o\x6e\x64\x69ti\x6fn";${${"\x47\x4cO\x42A\x4c\x53"}["\x6e\x6b\x6esw\x63\x69"]}=!empty(${$eromfqyml});$this->joinMainTable(${$icfkmurlg},${${"GL\x4f\x42\x41LS"}["\x79\x7a\x6e\x77\x68\x73\x70zj\x71\x68"]},${${"G\x4c\x4f\x42\x41\x4cS"}["\x68cf\x69e\x6e\x6e\x72u\x75\x62"]},${${"\x47\x4cO\x42A\x4c\x53"}["q\x73\x6a\x79\x7a\x70\x61\x69"]});return$this;}public function joinPrice(){${"\x47\x4cO\x42A\x4c\x53"}["\x70\x63g\x64\x67\x67\x62\x75\x63x\x6c\x6a"]="\x6ao\x69\x6eT\x61\x62\x6c\x65\x41l\x69a\x73";${"\x47\x4c\x4f\x42\x41\x4cS"}["y\x76\x75\x75y\x68p"]="co\x6ed\x69\x74i\x6fn";${"\x47L\x4fB\x41\x4cS"}["z\x64\x65\x63\x64\x66kef"]="\x6a\x6f\x69\x6eT\x61\x62le";${"\x47\x4c\x4fB\x41L\x53"}["k\x78\x67\x6d\x70\x6b\x77\x6c\x66\x6dz\x61"]="\x6ao\x69\x6e\x54\x61b\x6c\x65";${${"\x47\x4c\x4fB\x41\x4c\x53"}["\x70\x63\x67\x64g\x67b\x75\x63\x78\x6c\x6a"]}=self::CIP;$vhfdktgvdzk="\x63\x6f\x6ed\x69ti\x6fn";${${"\x47LO\x42\x41\x4c\x53"}["kxg\x6dp\x6b\x77l\x66\x6d\x7a\x61"]}=$this->getTable("\x63\x61ta\x6c\x6fgin\x64\x65\x78/p\x72i\x63\x65");$jllndxv="j\x6f\x69\x6e\x54a\x62l\x65A\x6cias";${$vhfdktgvdzk}="{$joinTableAlias}\x2ee\x6eti\x74y_id\x20\x3d ".self::MAIN_TABLE_SUBST."\x2een\x74i\x74y_id \x41\x4eD\x20{$joinTableAlias}\x2ew\x65\x62si\x74e_\x69\x64\x20= {$this->getWebsiteId()}\x20A\x4eD {$joinTableAlias}.c\x75\x73t\x6f\x6d\x65\x72_g\x72o\x75p\x5f\x69d \x3d '".self::DEF_CUSTOMER_GROUP_NOT_LOGGED_IN."\x27";$this->joinMainTable(${$jllndxv},${${"\x47\x4c\x4fBA\x4cS"}["zde\x63\x64f\x6b\x65\x66"]},false,${${"G\x4cO\x42\x41\x4c\x53"}["\x79\x76u\x75yh\x70"]});return$this;}public function joinCustomTables(){$this->dispatchJoinTableEvent($this->getMainTable(true),"_\x70ro\x64uc\x74");}protected function definePriceColumns(){$kwuddwgefhc="\x74ax\x52at\x65\x43olu\x6d\x6e\x4e\x61\x6d\x65";${${"\x47\x4c\x4f\x42\x41L\x53"}["\x6buhp\x6du\x70w\x65\x71"]}=Mage::helper("t\x61\x78")->priceIncludesTax($this->getStore());${$kwuddwgefhc}=self::NCT.".\x74\x61x\x5fperce\x6e\x74";${${"G\x4cO\x42\x41\x4c\x53"}["\x69\x67\x70\x6csg\x6a\x6dmc"]}="";${${"\x47\x4c\x4fB\x41L\x53"}["w\x7a\x61\x7a\x66\x6ai\x67"]}="";if($this->isWeeeEnabled()){${"\x47\x4cOBA\x4cS"}["v\x63\x64\x69z\x66\x66"]="\x77e\x65\x65C\x6f\x6cu\x6d\x6e\x4fri\x67i\x6e\x61\x6c";${${"G\x4c\x4f\x42A\x4c\x53"}["v\x63\x64\x69z\x66\x66"]}=self::NCW."\x2e".self::WEEE_COLUMN_TOTAL_ORIGINAL;${${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x77z\x61z\x66\x6a\x69\x67"]}=self::NCW.".".self::WEEE_COLUMN_TOTAL_FINAL;}$this->_columns[self::CIP]=array("p\x72i\x63e_fi\x6e\x61\x6c\x5fe\x78cl\x75\x64e\x5ft\x61x"=>$this->getPriceColumnFormat(self::CIP."."."mi\x6e\x5f\x70r\x69\x63e",false,${${"\x47\x4c\x4f\x42\x41L\x53"}["wza\x7a\x66\x6ai\x67"]}),"pri\x63e\x5f\x66\x69\x6eal_in\x63\x6cude\x5f\x74a\x78"=>$this->getPriceColumnFormat(self::CIP."\x2e"."mi\x6e_\x70r\x69\x63e",true,${${"G\x4c\x4f\x42\x41\x4c\x53"}["\x77\x7a\x61\x7a\x66j\x69\x67"]}),"\x70r\x69\x63\x65_orig\x69nal_ex\x63\x6cu\x64\x65\x5f\x74\x61x"=>$this->getPriceColumnFormat(self::CIP."\x2e"."\x70\x72ic\x65",false,${${"\x47L\x4f\x42A\x4cS"}["i\x67pl\x73\x67\x6a\x6d\x6d\x63"]},true),"p\x72i\x63\x65\x5f\x6fr\x69\x67\x69nal_i\x6e\x63\x6cude\x5ft\x61x"=>$this->getPriceColumnFormat(self::CIP."."."\x70r\x69ce",true,${${"\x47\x4cO\x42\x41\x4cS"}["i\x67\x70\x6cs\x67j\x6d\x6dc"]},true),"\x70r\x69c\x65_discou\x6e\x74_\x70erce\x6et"=>"R\x4fUN\x44(((".self::CIP.".\x70ric\x65 - ".self::CIP.".m\x69n_p\x72ice)*\x310\x30)/".self::CIP."\x2ep\x72ic\x65,\x30)","p\x72\x69\x63e\x5f\x64\x69scount_e\x78c\x6c\x75\x64\x65_t\x61x"=>$this->getPriceColumnFormat("(".self::CIP."."."\x70r\x69c\x65\x20-\x20".self::CIP."\x2e"."\x6din\x5f\x70ri\x63\x65)",false),"\x70\x72\x69\x63e\x5fdi\x73\x63\x6f\x75nt_i\x6e\x63\x6c\x75\x64e_\x74a\x78"=>$this->getPriceColumnFormat("(".self::CIP."\x2e"."\x70\x72\x69\x63e - ".self::CIP."."."min_\x70rice)",true),);}protected function getPriceColumnFormat($comunName,$includeTax,$weeeColumn="",$weeeOriginal=false){${"\x47LO\x42\x41\x4cS"}["\x65jg\x6f\x66\x76\x6db\x6af"]="w\x65\x65\x65T\x61\x78a\x62l\x65";${"\x47LOB\x41\x4c\x53"}["\x73\x6d\x73p\x77\x74\x78\x73"]="\x74a\x78\x52\x61\x74\x65\x43o\x6cu\x6d\x6e\x4ea\x6de";${"\x47\x4cO\x42\x41\x4c\x53"}["\x75bp\x75vv\x6d"]="\x6f\x72\x69gi\x6ea\x6cP\x72\x69c\x65s\x49\x6e\x63\x6c\x75\x64\x65\x73T\x61\x78";${${"G\x4c\x4f\x42A\x4c\x53"}["\x6b\x75hp\x6du\x70\x77\x65q"]}=Mage::helper("tax")->priceIncludesTax($this->getStore());$dlufxygyx="w\x65\x65\x65\x43\x6f\x6c\x75\x6dn\x4e\x6f\x6eT\x61\x78\x61\x62\x6ce";${${"\x47L\x4f\x42\x41\x4c\x53"}["\x76\x6abfunnas\x70\x66"]}=$this->helper()->getStoreCurrencyRate($this->getStore(),$this->getCurrency());${${"\x47LOB\x41\x4cS"}["\x73ms\x70\x77\x74\x78\x73"]}=self::NCT."\x2e\x74\x61x\x5fpe\x72cent";$rfnvcc="\x63\x75\x72\x72\x65n\x63\x79R\x61t\x65";${${"\x47LO\x42\x41\x4c\x53"}["\x65jgo\x66vm\x62j\x66"]}=$this->isWeeeTaxable();${${"\x47LOB\x41\x4c\x53"}["f\x74\x64\x6cct\x79\x76r"]}=${$dlufxygyx}="";if($this->isWeeeEnabled()&&!empty(${${"\x47\x4c\x4fBAL\x53"}["\x77v\x6fi\x79\x74\x66e"]})){$okndnub="\x77\x65ee\x43\x6fl\x75\x6dnT\x61\x78abl\x65";$eewjagmcwwtf="we\x65\x65\x43\x6f\x6c\x75\x6d\x6e";$bypwejnnsmwz="w\x65\x65\x65C\x6f\x6cu\x6dn";${"G\x4c\x4fB\x41L\x53"}["\x62\x65\x75\x74t\x6b\x6b\x67"]="\x77e\x65eC\x6fl\x75\x6d\x6e\x54\x61\x78\x61\x62l\x65";$pzpwcllfsom="w\x65e\x65\x4fr\x69\x67i\x6e\x61\x6c";$vuewpmdgwxr="\x69\x6e\x63l\x75d\x65\x54\x61\x78";${"\x47\x4c\x4fB\x41\x4c\x53"}["\x6e\x71\x76\x6bs\x6e"]="\x77\x65e\x65\x54\x61\x78\x61b\x6c\x65";${"GL\x4fBAL\x53"}["\x62\x66\x6ampm\x6es\x63\x66u"]="wee\x65\x43o\x6c\x75mn\x4e\x6fnTaxa\x62le";${"\x47\x4c\x4fB\x41\x4c\x53"}["\x64\x6bd\x66\x65\x76\x70\x65"]="\x77\x65\x65\x65\x43o\x6c\x75\x6dn";$dbtfgm="\x77\x65\x65\x65\x4fr\x69\x67\x69n\x61l";${$bypwejnnsmwz}="I\x46\x4e\x55L\x4c({$weeeColumn},0)";switch($this->getWeeeListPriceDisplayType()){case Mage_Weee_Model_Tax::DISPLAY_INCL:case Mage_Weee_Model_Tax::DISPLAY_INCL_DESCR:if(${${"\x47\x4c\x4f\x42A\x4cS"}["\x6e\x73\x69\x6c\x6ft\x65lr\x65"]}&&${${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x6cm\x61\x6euj\x64\x79"]}){${"GL\x4f\x42\x41\x4c\x53"}["\x66v\x74q\x68v\x64"]="\x77\x65e\x65Co\x6c\x75m\x6eT\x61\x78\x61b\x6c\x65";${${"G\x4cO\x42A\x4c\x53"}["\x66vt\x71\x68v\x64"]}="IF(".self::CIP."\x2e"."\x70rice\x20= ".self::CIP."."."m\x69\x6e_pr\x69ce\x20,{$weeeColumn},0)";${${"\x47LO\x42A\x4cS"}["\x6cf\x68\x76j\x67\x6c\x67\x65\x65\x6d\x6a"]}="\x49\x46(".self::CIP."\x2e"."\x70\x72\x69\x63\x65 \x3d\x20".self::CIP."."."min_p\x72ic\x65\x20,0,{$weeeColumn})";}break;case Mage_Weee_Model_Tax::DISPLAY_EXCL_DESCR_INCL:if(!${$vuewpmdgwxr})${${"\x47\x4cOBALS"}["wv\x6fiy\x74\x66e"]}="";if(${${"\x47\x4c\x4fB\x41\x4c\x53"}["\x66\x66\x6awyqy\x73"]}&&${$dbtfgm})${$eewjagmcwwtf}="IF(".self::CIP."."."\x70\x72\x69c\x65\x20\x3d ".self::CIP."."."min\x5f\x70r\x69\x63\x65 ,{$weeeColumn},0)";break;case Mage_Weee_Model_Tax::DISPLAY_EXCL:${${"G\x4c\x4f\x42A\x4cS"}["\x64k\x64f\x65\x76p\x65"]}="";if(${$pzpwcllfsom})${${"G\x4c\x4fB\x41\x4cS"}["lma\x6eu\x6ady"]}=false;break;default:break;}${"G\x4c\x4fB\x41LS"}["\x76\x74\x68x\x6b\x71s"]="\x77\x65e\x65\x43\x6f\x6c\x75\x6d\x6e\x4e\x6fnT\x61xa\x62\x6c\x65";if(${${"\x47LO\x42\x41\x4c\x53"}["\x6c\x6d\x61n\x75j\x64\x79"]}&&empty(${${"\x47\x4c\x4fBA\x4cS"}["\x62e\x75\x74\x74\x6bk\x67"]}))${$okndnub}=${${"\x47\x4cO\x42A\x4c\x53"}["\x77v\x6f\x69\x79t\x66\x65"]};if(!${${"G\x4cOB\x41LS"}["n\x71\x76\x6b\x73\x6e"]}&&empty(${${"\x47\x4c\x4fB\x41\x4cS"}["\x62\x66\x6am\x70\x6d\x6e\x73\x63\x66\x75"]}))${${"\x47\x4c\x4f\x42A\x4cS"}["\x76\x74\x68\x78k\x71\x73"]}=${${"\x47\x4cOBA\x4c\x53"}["w\x76\x6f\x69\x79\x74fe"]};}${${"\x47\x4cOBAL\x53"}["\x66\x6b\x6a\x68\x69\x6f\x62w"]}=$this->helper()->getPriceColumnFormat(${${"\x47L\x4fB\x41\x4cS"}["\x76\x76j\x6ec\x71\x67ur\x65"]},${${"\x47\x4c\x4f\x42AL\x53"}["\x63nl\x74g\x70u\x75\x73"]},${$rfnvcc},${${"\x47L\x4f\x42\x41\x4c\x53"}["\x75\x62p\x75\x76v\x6d"]},${${"\x47L\x4f\x42\x41\x4c\x53"}["\x66\x66j\x77y\x71\x79\x73"]},true,${${"\x47\x4cOB\x41L\x53"}["ftd\x6c\x63ty\x76\x72"]},${${"GLOB\x41\x4cS"}["\x6cf\x68\x76\x6ag\x6cg\x65em\x6a"]});return${${"\x47L\x4f\x42\x41\x4cS"}["f\x6b\x6ah\x69\x6f\x62w"]};}}
?>