sub_language.class.php 12 KB

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