sub_language.class.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316
  1. <?php /* For licensing terms, see /license.txt */
  2. /**
  3. * SubLanguageManager class definition file
  4. * @package chamilo.admin.sublanguage
  5. * @todo clean this lib and move to main/inc/lib
  6. */
  7. class SubLanguageManager {
  8. private function __construct() {
  9. //void
  10. }
  11. /**
  12. * Get all files of lang folder (forum.inc.php,gradebook.inc.php,notebook.inc.php)
  13. * @param String The lang path folder (/var/www/my_lms/main/lang/spanish)
  14. * @param bool true if we only want the "subname" trad4all instead of trad4all.inc.php
  15. * @return Array All file of lang folder
  16. *
  17. */
  18. public static function get_lang_folder_files_list ($path,$only_main_name=false) {
  19. $content_dir=array();
  20. if (is_dir($path)) {
  21. if ($dh = opendir($path)) {
  22. while (($file = readdir($dh)) !== false) {
  23. if ($file[0]<>'.' && substr($file,-4,strlen($file))=='.php') {
  24. if ($only_main_name) {
  25. if ($file!='' && strpos($file, '.inc.php'))
  26. $content_dir[]=substr($file, 0, strpos($file, '.inc.php'));
  27. } else {
  28. $content_dir[]=$file;
  29. }
  30. }
  31. }
  32. }
  33. closedir($dh);
  34. return $content_dir;
  35. }
  36. }
  37. /**
  38. * Get all information of sub-language
  39. * @param Integer The parent id(Language father id)
  40. * @param Integer The sub language id
  41. * @return Array All information about sub-language
  42. */
  43. public static function get_all_information_of_sub_language ($parent_id,$sub_language_id) {
  44. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  45. $sql='SELECT * FROM '.$tbl_admin_languages.' WHERE parent_id="'.Database::escape_string($parent_id).'" AND id="'.Database::escape_string($sub_language_id).'"';
  46. $rs=Database::query($sql);
  47. $all_information=array();
  48. while ($row=Database::fetch_array($rs,'ASSOC')) {
  49. $all_information=$row;
  50. }
  51. return $all_information;
  52. }
  53. /**
  54. * Get all information of language
  55. * @param Integer The parent id(Language father id)
  56. * @return Array All information about language
  57. */
  58. public static function get_all_information_of_language ($parent_id) {
  59. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  60. $sql='SELECT * FROM '.$tbl_admin_languages.' WHERE id="'.intval($parent_id).'"';
  61. $rs=Database::query($sql);
  62. $all_information=array();
  63. while ($row=Database::fetch_array($rs,'ASSOC')) {
  64. $all_information=$row;
  65. }
  66. return $all_information;
  67. }
  68. /**
  69. * Get all information of chamilo file
  70. * @param String The chamilo path file (/var/www/chamilo/main/lang/spanish/gradebook.inc.php)
  71. * @return Array Contains all information of chamilo file
  72. */
  73. public static function get_all_language_variable_in_file($system_path_file, $get_as_string_index=false) {
  74. $res_list = array();
  75. if (!is_readable($system_path_file)) {
  76. return $res_list;
  77. }
  78. $info_file=file($system_path_file);
  79. foreach ($info_file as $line) {
  80. if (substr($line,0,1)!='$') { continue; }
  81. list($var,$val) = split('=',$line,2);
  82. $var = trim($var); $val = trim($val);
  83. if ($get_as_string_index) { //remove the prefix $
  84. $var = substr($var,1);
  85. }
  86. $res_list[$var] = $val;
  87. }
  88. return $res_list;
  89. }
  90. /**
  91. * Add file in sub-language directory and add header(tag php)
  92. * @param String The chamilo path file (/var/www/chamilo/main/lang/spanish/gradebook.inc.php)
  93. * @return bool
  94. */
  95. public static function add_file_in_language_directory($system_path_file) {
  96. $return_value = false;
  97. $return_value = @file_put_contents($system_path_file,'<?php'.PHP_EOL);
  98. return $return_value;
  99. }
  100. /**
  101. * Write in file of sub-language
  102. * @param String The path file (/var/www/chamilo/main/lang/spanish/gradebook.inc.php)
  103. * @param String The new sub-language
  104. * @param String The language variable
  105. * @return void()
  106. */
  107. public static function write_data_in_file($path_file, $new_term, $new_variable) {
  108. $return_value = false;
  109. $new_data=$new_variable.'='.$new_term;
  110. $resource = @fopen($path_file, "a");
  111. if (file_exists($path_file) && $resource) {
  112. if (fwrite($resource, $new_data.PHP_EOL) === false) {
  113. //not allow to write
  114. $return_value = false;
  115. } else {
  116. $return_value = true;
  117. }
  118. fclose($resource);
  119. }
  120. return $return_value;
  121. }
  122. /**
  123. * Add directory for sub-language
  124. * @param String The sub-language directory ( e.g. 'spanish_corporate' )
  125. * @return boolean True on success, false on failure
  126. */
  127. public static function add_language_directory($sub_language_dir) {
  128. if (empty($sub_language_dir)) { return false; }
  129. $dir = api_get_path(SYS_LANG_PATH).$sub_language_dir;
  130. if (is_dir($dir)) { return true; } //even if the dir already exists, we reach the objective of having the directory there
  131. return @mkdir($dir, api_get_permissions_for_new_directories());
  132. }
  133. /**
  134. * Delete sub-language.
  135. * In order to avoid deletion of main laguages, we check the existence of a parent
  136. * @param Integer The parent id
  137. * @return bool True on success, false on error
  138. */
  139. public static function remove_sub_language ($parent_id,$sub_language_id) {
  140. if (empty($parent_id) or (intval($parent_id)!=$parent_id) or empty($sub_language_id) or (intval($sub_language_id) != $sub_language_id)) { return false; }
  141. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  142. $sql = 'SELECT dokeos_folder FROM '.$tbl_admin_languages.' WHERE parent_id = '.$parent_id.' and id = '.$sub_language_id;
  143. $res = Database::query($sql);
  144. if ($res === false or Database::num_rows($res)<1) { return false; }
  145. $row = Database::fetch_assoc($res);
  146. $res = SubLanguageManager::remove_language_directory($row['dokeos_folder']);
  147. if ($res === false) { return false; } //can't delete dir, so do not delete language record
  148. $sql = 'DELETE FROM '.$tbl_admin_languages.' WHERE id="'.Database::escape_string($sub_language_id).'" ';
  149. $res = Database::query($sql);
  150. return $res;
  151. }
  152. /**
  153. * Remove directory for sub-language
  154. * @param String The sub-language path directory ( e.g. 'spanish_corporate'' )
  155. * @return boolean True on success, false on failure
  156. */
  157. public static function remove_language_directory($sub_language_dir) {
  158. if (empty($sub_language_dir)) { return false; }
  159. $dir = api_get_path(SYS_LANG_PATH).$sub_language_dir;
  160. if (!is_dir($dir)) { return true; } //even if the dir does not exist, we reach the objective of not having the directory there
  161. $content = SubLanguageManager::get_lang_folder_files_list($dir);
  162. if (count($content)>0) {
  163. foreach ($content as $value_content) {
  164. $path_file = $dir.'/'.$value_content;
  165. unlink($path_file);
  166. }
  167. return @rmdir($dir);
  168. } else {
  169. return @rmdir($dir);
  170. }
  171. }
  172. /**
  173. * check if language exist by id
  174. * @param Integer The language id
  175. * @return Boolean
  176. */
  177. public static function check_if_exist_language_by_id ($language_id) {
  178. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  179. $sql='SELECT count(*) as count FROM '.$tbl_admin_languages.' WHERE id="'.intval($language_id).'"';
  180. $rs=Database::query($sql);
  181. if (Database::num_rows($rs)>0) {
  182. if (Database::result($rs,0,'count') ==1) {
  183. return true;
  184. } else {
  185. return false;
  186. }
  187. } else {
  188. return false;;
  189. }
  190. }
  191. /**
  192. * Get name of language by id
  193. * @param Integer The language id
  194. * @return String The original name of language
  195. */
  196. public static function get_name_of_language_by_id ($language_id) {
  197. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  198. $sql='SELECT original_name FROM '.$tbl_admin_languages.' WHERE id="'.Database::escape_string($language_id).'"';
  199. $rs=Database::query($sql);
  200. if (Database::num_rows($rs)>0) {
  201. return Database::result($rs,0,'original_name');
  202. } else {
  203. return '';
  204. }
  205. }
  206. /**
  207. * Verified if language is sub-language
  208. * @param Integer The language id
  209. * @return Boolean
  210. */
  211. public static function check_if_language_is_sub_language ($language_id) {
  212. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  213. $sql='SELECT count(*) AS count FROM '.$tbl_admin_languages.' WHERE id="'.Database::escape_string($language_id).'" AND NOT ISNULL(parent_id)';
  214. $rs=Database::query($sql);
  215. if (Database::num_rows($rs)>0 && Database::result($rs,'0','count')==1) {
  216. return true;
  217. } else {
  218. return false;
  219. }
  220. }
  221. /**
  222. * Verified if language is father of an sub-language
  223. * @param Integer The language id
  224. * @return Boolean
  225. */
  226. public static function check_if_language_is_father ($language_id) {
  227. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  228. $sql='SELECT count(*) AS count FROM '.$tbl_admin_languages.' WHERE parent_id="'.Database::escape_string($language_id).'" AND NOT ISNULL(parent_id);';
  229. $rs=Database::query($sql);
  230. if (Database::num_rows($rs)>0 && Database::result($rs,'0','count')==1) {
  231. return true;
  232. } else {
  233. return false;
  234. }
  235. }
  236. /**
  237. * Make unavailable the language
  238. * @param Integer The language id
  239. * @return void()
  240. */
  241. public static function make_unavailable_language ($language_id) {
  242. $tbl_admin_languages= Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  243. $sql_make_unavailable = "UPDATE $tbl_admin_languages SET available='0' WHERE id='".Database::escape_string($language_id)."'";
  244. $result = Database::query($sql_make_unavailable);
  245. return $result !== false; //only return false on sql error
  246. }
  247. /**
  248. * Make available the language
  249. * @param Integer The language id
  250. * @return void
  251. */
  252. public static function make_available_language ($language_id) {
  253. $tbl_admin_languages= Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  254. $sql_make_available = "UPDATE $tbl_admin_languages SET available='1' WHERE id='".Database::escape_string($language_id)."'";
  255. $result = Database::query($sql_make_available);
  256. return $result !== false; //only return false on sql error
  257. }
  258. /**
  259. * Set platform language
  260. * @param Integer The language id
  261. * @return void()
  262. */
  263. public static function set_platform_language ($language_id) {
  264. if (empty($language_id) or (intval($language_id)!=$language_id)) { return false; }
  265. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  266. $tbl_settings_current = Database :: get_main_table(TABLE_MAIN_SETTINGS_CURRENT);
  267. $sql_update = "SELECT english_name FROM ". $tbl_admin_languages." WHERE id='".Database::escape_string($language_id)."'";
  268. $result = Database::query($sql_update);
  269. $lang=Database::fetch_array($result);
  270. $sql_update_2 = "UPDATE ".$tbl_settings_current." SET selected_value='".$lang['english_name']."' WHERE variable='platformLanguage'";
  271. $result_2 = Database::query($sql_update_2);
  272. return $result_2 !== false;
  273. }
  274. /**
  275. * Get platform language ID
  276. * @return int The platform language ID
  277. */
  278. public static function get_platform_language_id () {
  279. $name = api_get_setting('platformLanguage');
  280. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  281. $sql = "SELECT id FROM ". $tbl_admin_languages." WHERE english_name ='$name'";
  282. $res = Database::query($sql);
  283. if (Database::num_rows($res)<1) { return false;}
  284. $row = Database::fetch_array($res);
  285. return $row['id'];
  286. }
  287. /*
  288. * Get parent language path (or null if no parent)
  289. * @param string Children language path
  290. * @return string Parent language path or null
  291. */
  292. public static function get_parent_language_path ($language_path) {
  293. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  294. $tbl_settings_current = Database :: get_main_table(TABLE_MAIN_SETTINGS_CURRENT);
  295. $sql_update = "SELECT dokeos_folder FROM ". $tbl_admin_languages." WHERE id=(SELECT parent_id FROM ". $tbl_admin_languages." WHERE dokeos_folder = '".Database::escape_string($language_path)."')";
  296. $result = Database::query($sql_update);
  297. if (Database::num_rows($result) == 0) {
  298. return null;
  299. }
  300. $row = Database::fetch_array($result);
  301. return $row['dokeos_folder'];
  302. }
  303. }
  304. ?>