PageRenderTime 31ms CodeModel.GetById 14ms RepoModel.GetById 0ms app.codeStats 1ms

/modules/storecommander/ead6f6fce09/SC/lib/cat/categorypanel/cat_categorypanel_get.php

https://gitlab.com/ptisky/API_prestashop
PHP | 212 lines | 164 code | 14 blank | 34 comment | 29 complexity | b11ef69abdaec93fa615dbea134aee3c MD5 | raw file
    

  1. <?php


    2. 

  2. /**


    3. 

  3.  * Store Commander


    4. 

  4.  *


    5. 

  5.  * @category administration


    6. 

  6.  * @author Store Commander - support@storecommander.com


    7. 

  7.  * @version 2015-09-15


    8. 

  8.  * @uses Prestashop modules


    9. 

  9.  * @since 2009


    10. 

  10.  * @copyright Copyright &copy; 2009-2015, Store Commander


    11. 

  11.  * @license commercial


    12. 

  12.  * All rights reserved! Copying, duplication strictly prohibited


    13. 

  13.  *


    14. 

  14.  * *****************************************


    15. 

  15.  * *           STORE COMMANDER             *


    16. 

  16.  * *   http://www.StoreCommander.com       *


    17. 

  17.  * *            V 2015-09-15               *


    18. 

  18.  * *****************************************


    19. 

  19.  *


    20. 

  20.  * Compatibility: PS version: 1.1 to 1.6.1


    21. 

  21.  *


    22. 

  22.  **/


    23. 

  23. 


    24. 

  24. 	$id_lang=intval(Tools::getValue('id_lang'));


    25. 

  25. 	$id_product=intval(Tools::getValue('id_product'));


    26. 

  26. 	$for_mb = Tools::getValue('for_mb', 1);


    27. 

  27. 


    28. 

  28. 	function getLevelFromDB($parent_id)


    29. 

  29. 	{


    30. 

  30. 		global $id_lang, $for_mb;


    31. 

  31. 


    32. 

  32. 		if(SCMS && SCI::getSelectedShop()>0 && $for_mb==1)


    33. 

  33. 		{


    34. 

  34. 			$sql = "SELECT c.active,c.id_category,name FROM "._DB_PREFIX_."category c


    35. 

  35. 						LEFT JOIN "._DB_PREFIX_."category_lang cl ON (cl.id_category=c.id_category AND cl.id_lang=".(int)$id_lang." AND cl.id_shop=".(int)SCI::getSelectedShop().")


    36. 

  36. 						LEFT JOIN "._DB_PREFIX_."category_shop cs ON cs.id_category=c.id_category


    37. 

  37. 						WHERE c.id_parent=".(int)$parent_id."


    38. 

  38. 							 AND cs.id_shop=".(int)SCI::getSelectedShop()."


    39. 

  39. 						GROUP BY c.id_category


    40. 

  40. 						ORDER BY cs.position, cl.name";


    41. 

  41. 		}


    42. 

  42. 		elseif(version_compare(_PS_VERSION_, '1.3.0.0', '>='))


    43. 

  43. 		{


    44. 

  44. 			$sql = "SELECT c.active,c.id_category,name FROM "._DB_PREFIX_."category c


    45. 

  45. 						LEFT JOIN "._DB_PREFIX_."category_lang cl ON (cl.id_category=c.id_category AND cl.id_lang=".(int)$id_lang.")


    46. 

  46. 						WHERE c.id_parent=".(int)$parent_id."


    47. 

  47. 						GROUP BY c.id_category


    48. 

  48. 						ORDER BY cl.name";


    49. 

  49. 		}


    50. 

  50. 		else


    51. 

  51. 		{


    52. 

  52. 			$sql = "SELECT c.active,c.id_category,name FROM "._DB_PREFIX_."category c


    53. 

  53. 						LEFT JOIN "._DB_PREFIX_."category_lang cl ON (cl.id_category=c.id_category AND cl.id_lang=".(int)$id_lang.")


    54. 

  54. 						WHERE c.id_parent=".(int)$parent_id."


    55. 

  55. 						GROUP BY c.id_category


    56. 

  56. 						ORDER BY cl.name";


    57. 

  57. 		}


    58. 

  58. 		$res=Db::getInstance()->ExecuteS($sql);


    59. 

  59. 		if(!empty($res))


    60. 

  60. 		{


    61. 

  61. 			foreach($res as $k => $row){


    62. 

  62. 				$style='';


    63. 

  63. 				if (hideCategoryPosition($row['name'])=='')


    64. 

  64. 				{


    65. 

  65. 					$sql2 = "SELECT name FROM "._DB_PREFIX_."category_lang 


    66. 

  66. 										WHERE id_lang=".intval(Configuration::get('PS_LANG_DEFAULT'))." 


    67. 

  67. 											AND id_category=".$row['id_category'];


    68. 

  68. 					$res2=Db::getInstance()->getRow($sql2);


    69. 

  69. 					$style='style="background:lightblue" ';


    70. 

  70. 				}


    71. 

  71. 				$icon=($row['active']?'catalog.png':'folder_grey.png');


    72. 

  72. 				if (sc_in_array(hideCategoryPosition($row['name']),array('SC Recycle Bin', 'SC Corbeille'),"catCategorypanel_corbeille"))


    73. 

  73. 					$icon='folder_delete.png';


    74. 

  74. 				/*if (!in_array(hideCategoryPosition($row['name']),array('SC Recycle Bin', 'SC Corbeille')))


    75. 

  75. 				{*/


    76. 

  76. 					echo "<row ".($style!='' ? $style:'').


    77. 

  77. 										" id=\"".$row['id_category']."\"".($parent_id==0?' open="1"':'').">".


    78. 

  78. 										"<cell>".$row['id_category']."</cell>".


    79. 

  79. 										"<cell>0</cell>".


    80. 

  80. 										"<cell image=\"../../".$icon."\"><![CDATA[".($style==''?formatText(hideCategoryPosition($row['name'])):_l('To Translate:').' '.formatText(hideCategoryPosition($res2['name'])))."]]></cell>".


    81. 

  81. 										"<cell>3</cell>";


    82. 

  82. 					getLevelFromDB($row['id_category']);


    83. 

  83. 					echo '</row>'."\n";


    84. 

  84. 				//}


    85. 

  85. 			}


    86. 

  86. 		}


    87. 

  87. 	}


    88. 

  88. 	


    89. 

  89. 	function getLevelFromDB_PHP($id_parent)


    90. 

  90. 	{


    91. 

  91. 		global $id_lang,$for_mb,$array_cats,$array_children_cats;


    92. 

  92. 		


    93. 

  93. 		if(!empty($array_children_cats[$id_parent]))


    94. 

  94. 		{


    95. 

  95. 			ksort($array_children_cats[$id_parent]);


    96. 

  96. 			foreach($array_children_cats[$id_parent] as $k => $id)


    97. 

  97. 			{


    98. 

  98. 				$row = $array_cats[$id];


    99. 

  99. 				$style='';


    100. 

  100. 				if (hideCategoryPosition($row['name'])=='SoColissimo')


    101. 

  101. 					continue;


    102. 

  102. 				if (hideCategoryPosition($row['name'])=='')


    103. 

  103. 				{


    104. 

  104. 					$sql2 = "SELECT name FROM "._DB_PREFIX_."category_lang


    105. 

  105. 										WHERE id_lang=".intval(Configuration::get('PS_LANG_DEFAULT'))."


    106. 

  106. 											AND id_category=".$row['id_category'];


    107. 

  107. 					$res2=Db::getInstance()->getRow($sql2);


    108. 

  108. 					$style='style="background:lightblue" ';


    109. 

  109. 				}


    110. 

  110. 				


    111. 

  111. 


    112. 

  112. 				$icon=($row['active']?'catalog.png':'folder_grey.png');


    113. 

  113. 				if (sc_in_array(hideCategoryPosition($row['name']),array('SC Recycle Bin', 'SC Corbeille'),"catCategorypanel_corbeille"))


    114. 

  114. 					$icon='folder_delete.png';


    115. 

  115. 


    116. 

  116. 				/*if (!in_array(hideCategoryPosition($row['name']),array('SC Recycle Bin', 'SC Corbeille')))


    117. 

  117. 				{*/


    118. 

  118. 					echo "<row ".($style!='' ? $style:'').


    119. 

  119. 					" id=\"".$row['id_category']."\"".($row["id_parent"]==0?' open="1"':'').">".


    120. 

  120. 					"<cell>".$row['id_category']."</cell>".


    121. 

  121. 					"<cell>0</cell>".


    122. 

  122. 					"<cell image=\"../../".$icon."\"><![CDATA[".($style==''?formatText(hideCategoryPosition($row['name'])):_l('To Translate:').' '.formatText(hideCategoryPosition($res2['name'])))."]]></cell>".


    123. 

  123. 					"<cell>3</cell>";


    124. 

  124. 					getLevelFromDB_PHP($row['id_category']);


    125. 

  125. 					echo '</row>'."\n";


    126. 

  126. 				//}


    127. 

  127. 			}


    128. 

  128. 		}


    129. 

  129. 	}


    130. 

  130. 


    131. 

  131. 	//XML HEADER


    132. 

  132. 


    133. 

  133. 	//include XML Header (as response will be in xml format)


    134. 

  134. 	if ( stristr($_SERVER["HTTP_ACCEPT"],"application/xhtml+xml") ) {


    135. 

  135. 	 		header("Content-type: application/xhtml+xml"); } else {


    136. 

  136. 	 		header("Content-type: text/xml");


    137. 

  137. 	}


    138. 

  138. 	echo("<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n");


    139. 

  139. ?>


    140. 

  140. <rows parent="0">


    141. 

  141. <head>


    142. 

  142. <beforeInit>


    143. 

  143. <call command="attachHeader"><param><![CDATA[#text_filter,,#text_filter,]]></param></call>


    144. 

  144. </beforeInit>


    145. 

  145. <column id="id_category" width="40" type="ro" align="right" sort="int"><?php echo _l('ID')?></column>


    146. 

  146. <column id="used" width="50" type="ch" align="center" sort="str"><?php echo _l('Used')?></column>


    147. 

  147. <column id="name" width="250" type="tree" align="left" sort="str"><?php echo _l('Name')?></column>


    148. 

  148. <column id="default" width="50" type="ra" align="center" sort="str"><?php echo _l('Default')?></column>


    149. 

  149. </head>


    150. 

  150. <?php


    151. 

  151. 	echo '<userdata name="uisettings">'.uisettings::getSetting('cat_categorypanel').'</userdata>'."\n";


    152. 

  152. 	if (version_compare(_PS_VERSION_, '1.5.0.0', '<'))


    153. 

  153. 		echo "<row ".


    154. 

  154. 						" id=\"1\">".


    155. 

  155. 						"<cell>1</cell>".


    156. 

  156. 						"<cell>0</cell>".


    157. 

  157. 						"<cell image=\"catalog.png\"><![CDATA["._l('Home')."]]></cell>".


    158. 

  158. 						"<cell>0</cell></row>";


    159. 

  159. 	$id_root=0;


    160. 

  160. 	$ps_root = 0;//SCI::getConfigurationValue("PS_ROOT_CATEGORY");


    161. 

  161. 	$sql_root = "SELECT *


    162. 

  162. 			FROM "._DB_PREFIX_."category


    163. 

  163. 			WHERE id_parent = 0";


    164. 

  164. 	$res_root=Db::getInstance()->ExecuteS($sql_root);


    165. 

  165. 	if(!empty($res_root[0]["id_category"]))


    166. 

  166. 		$ps_root = $res_root[0]["id_category"];


    167. 

  167. 	if(!empty($ps_root))


    168. 

  168. 		$id_root = $ps_root;


    169. 

  169. 	$id_shop=SCI::getSelectedShop();


    170. 

  170. 	if (SCMS && $id_shop > 0)


    171. 

  171. 	{


    172. 

  172. 		$shop = new Shop($id_shop);


    173. 

  173. 		$categ = new Category($shop->id_category);


    174. 

  174. 		$id_root = $categ->id_parent;


    175. 

  175. 	}


    176. 

  176. /*	$sql = 'SELECT c.id_category


    177. 

  177. 					FROM `'._DB_PREFIX_.'category` c


    178. 

  178. 					WHERE c.`id_parent` = 0';


    179. 

  179. 	$res=Db::getInstance()->getRow($sql);


    180. 

  180. 	$id_category_root=$res['id_category'];*/


    181. 

  181. 	if(version_compare(_PS_VERSION_, '1.4.0.0', '>='))


    182. 

  182. 	{


    183. 

  183. 		$array_cats = array();


    184. 

  184. 		$array_children_cats = array();


    185. 

  185. 	


    186. 

  186. 		if(version_compare(_PS_VERSION_, '1.5.0.0', '>=') && !SCMS)


    187. 

  187. 		{


    188. 

  188. 			$id_shop = (int)Configuration::get('PS_SHOP_DEFAULT');


    189. 

  189. 		}


    190. 

  190. 		


    191. 

  191. 		$sql = "SELECT c.*, cl.name, c.position ".(( (SCMS && $for_mb==1) || (version_compare(_PS_VERSION_, '1.5.0.0', '>=') && !SCMS) ) && !empty($id_shop)?", cs.position":"")."


    192. 

  192. 				FROM "._DB_PREFIX_."category c


    193. 

  193. 				LEFT JOIN "._DB_PREFIX_."category_lang cl ON (cl.id_category=c.id_category AND cl.id_lang=".intval($id_lang).")


    194. 

  194. 				".(( (SCMS && $for_mb==1) || (version_compare(_PS_VERSION_, '1.5.0.0', '>=') && !SCMS) ) && !empty($id_shop)?" INNER JOIN "._DB_PREFIX_."category_shop cs ON (cs.id_category=c.id_category AND cs.id_shop=".(int)$id_shop.") ":"")."


    195. 

  195. 				GROUP BY c.id_category


    196. 

  196. 				ORDER BY c.`nleft` ASC";


    197. 

  197. 		$res=Db::getInstance()->ExecuteS($sql);


    198. 

  198. 		foreach($res as $k => $row)


    199. 

  199. 		{


    200. 

  200. 			$array_cats[$row["id_category"]]=$row;


    201. 

  201. 				


    202. 

  202. 			if(!isset($array_children_cats[$row["id_parent"]]))


    203. 

  203. 				$array_children_cats[$row["id_parent"]] = array();


    204. 

  204. 			$array_children_cats[$row["id_parent"]][str_pad($row["position"], 5, "0", STR_PAD_LEFT).str_pad($row["id_category"], 12, "0", STR_PAD_LEFT)] = $row["id_category"];


    205. 

  205. 		}


    206. 

  206. 		


    207. 

  207. 		getLevelFromDB_PHP($id_root);


    208. 

  208. 	}


    209. 

  209. 	else


    210. 

  210. 		getLevelFromDB($id_root);


    211. 

  211. ?>


    212. 

  212. </rows>


    213. 

  213.