sub_language.class.php 9.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. ==================================================================================
  5. @author Isaac flores paz <florespaz@bidsoftperu.com> - Added 9 july of 2009
  6. ==================================================================================
  7. */
  8. /*
  9. ==============================================================================
  10. Class SubLanguageManager
  11. ==============================================================================
  12. */
  13. class SubLanguageManager {
  14. private function __construct() {
  15. //void
  16. }
  17. /**
  18. * Get all data of dokeos folder (forum.inc.php,gradebook.inc.php,notebook.inc.php)
  19. * @param String The dokeos path folder (/var/www/my_dokeos/main/lang/spanish)
  20. * @param bool true if we only want the "subname" trad4all instead of trad4all.inc.php
  21. * @return Array All file of dokeos folder
  22. *
  23. */
  24. public static function get_all_data_of_dokeos_folder ($dokeos_path_folder,$only_main_name=false) {
  25. $content_dir=array();
  26. if (is_dir($dokeos_path_folder)) {
  27. if ($dh = opendir($dokeos_path_folder)) {
  28. while (($file = readdir($dh)) !== false) {
  29. if ($file[0]<>'.' && substr($file,-4,strlen($file))=='.php') {
  30. if ($only_main_name) {
  31. if ($file!='' && strpos($file, '.inc.php'))
  32. $content_dir[]=substr($file, 0, strpos($file, '.inc.php'));
  33. } else {
  34. $content_dir[]=$file;
  35. }
  36. }
  37. }
  38. }
  39. closedir($dh);
  40. return $content_dir;
  41. }
  42. }
  43. /**
  44. * Get all information of sub-language
  45. * @param Integer The parent id(Language father id)
  46. * @param Integer The sub language id
  47. * @return Array All information about sub-language
  48. */
  49. public static function get_all_information_of_sub_language ($parent_id,$sub_language_id) {
  50. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  51. $sql='SELECT * FROM '.$tbl_admin_languages.' WHERE parent_id="'.Database::escape_string($parent_id).'" AND id="'.Database::escape_string($sub_language_id).'"';
  52. $rs=Database::query($sql);
  53. $all_information=array();
  54. while ($row=Database::fetch_array($rs,'ASSOC')) {
  55. $all_information=$row;
  56. }
  57. return $all_information;
  58. }
  59. /**
  60. * Get all information of language
  61. * @param Integer The parent id(Language father id)
  62. * @return Array All information about language
  63. */
  64. public static function get_all_information_of_language ($parent_id) {
  65. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  66. $sql='SELECT * FROM '.$tbl_admin_languages.' WHERE id="'.Database::escape_string($parent_id).'"';
  67. $rs=Database::query($sql);
  68. $all_information=array();
  69. while ($row=Database::fetch_array($rs,'ASSOC')) {
  70. $all_information=$row;
  71. }
  72. return $all_information;
  73. }
  74. /**
  75. * Get all information of dokeos file
  76. * @param String The dokeos path file (/var/www/my_dokeos/main/lang/spanish/gradebook.inc.php)
  77. * @return Array Contains all information of dokeos file
  78. */
  79. public static function get_all_language_variable_in_file ($dokeos_path_file) {
  80. $info_file=file($dokeos_path_file);
  81. foreach ($info_file as $line) {
  82. if (substr($line,0,1)!='$') { continue; }
  83. list($var,$val) = split('=',$line,2);
  84. $var = trim($var); $val = trim($val);
  85. $res_list[$var] = $val;
  86. }
  87. return $res_list;
  88. }
  89. /**
  90. * Add file in sub-language directory and add header(tag php)
  91. * @param String The dokeos path file (/var/www/my_dokeos/main/lang/spanish/gradebook.inc.php)
  92. * @return void()
  93. */
  94. public static function add_file_in_language_directory ($dokeos_path_file) {
  95. file_put_contents($dokeos_path_file,'<?php'.PHP_EOL);
  96. }
  97. /**
  98. * Write in file of sub-language
  99. * @param String The path file (/var/www/my_dokeos/main/lang/spanish/gradebook.inc.php)
  100. * @param String The new sub-language
  101. * @param String The language variable
  102. * @return void()
  103. */
  104. public static function write_data_in_file ($path_file,$new_sub_language,$variable_sub_language) {
  105. $new_data=$variable_sub_language.'='.$new_sub_language;
  106. $g_open_file = fopen($path_file, "a");
  107. if (fwrite($g_open_file, $new_data.PHP_EOL) === false) {
  108. //not allow to write
  109. }
  110. fclose($g_open_file);
  111. }
  112. /**
  113. * Add directory for sub-language
  114. * @param String The sub-language path directory ( /var/www/my_dokeos/main/lang/spanish_corporate )
  115. * @return boolean
  116. */
  117. public static function add_directory_of_sub_language($path_sub_language) {
  118. //return @mkdir($path_sub_language, 0777) !== false;
  119. return @mkdir($path_sub_language, api_get_permissions_for_new_directories()) !== false;
  120. }
  121. /**
  122. * Delete sub-language
  123. * @param Integer The parent id
  124. * @return void()
  125. */
  126. public static function removed_sub_language ($parent_id,$sub_language_id) {
  127. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  128. $sql = 'DELETE FROM '.$tbl_admin_languages.' WHERE parent_id="'.Database::escape_string($parent_id).'" AND id="'.Database::escape_string($sub_language_id).'" ';
  129. Database::query($sql);
  130. }
  131. /**
  132. * check if language exist by id
  133. * @param Integer The language id
  134. * @return Boolean
  135. */
  136. public static function check_if_exist_language_by_id ($language_id) {
  137. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  138. $sql='SELECT count(*) as count FROM '.$tbl_admin_languages.' WHERE id="'.Database::escape_string($language_id).'"';
  139. $rs=Database::query($sql);
  140. if (Database::num_rows($rs)>0) {
  141. if (Database::result($rs,0,'count') ==1) {
  142. return true;
  143. } else {
  144. return false;
  145. }
  146. } else {
  147. return false;;
  148. }
  149. }
  150. /**
  151. * Get name of language by id
  152. * @param Integer The language id
  153. * @return String The original name of language
  154. */
  155. public static function get_name_of_language_by_id ($language_id) {
  156. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  157. $sql='SELECT original_name FROM '.$tbl_admin_languages.' WHERE id="'.Database::escape_string($language_id).'"';
  158. $rs=Database::query($sql);
  159. if (Database::num_rows($rs)>0) {
  160. return Database::result($rs,0,'original_name');
  161. } else {
  162. return '';
  163. }
  164. }
  165. /**
  166. * Verified if language is sub-language
  167. * @param Integer The language id
  168. * @return Boolean
  169. */
  170. public static function check_if_language_is_sub_language ($language_id) {
  171. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  172. $sql='SELECT count(*) AS count FROM '.$tbl_admin_languages.' WHERE id="'.Database::escape_string($language_id).'" AND NOT ISNULL(parent_id)';
  173. $rs=Database::query($sql);
  174. if (Database::num_rows($rs)>0 && Database::result($rs,'0','count')==1) {
  175. return true;
  176. } else {
  177. return false;
  178. }
  179. }
  180. /**
  181. * Verified if language is father of an sub-language
  182. * @param Integer The language id
  183. * @return Boolean
  184. */
  185. public static function check_if_language_is_father ($language_id) {
  186. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  187. $sql='SELECT count(*) AS count FROM '.$tbl_admin_languages.' WHERE parent_id="'.Database::escape_string($language_id).'" AND NOT ISNULL(parent_id);';
  188. $rs=Database::query($sql);
  189. if (Database::num_rows($rs)>0 && Database::result($rs,'0','count')==1) {
  190. return true;
  191. } else {
  192. return false;
  193. }
  194. }
  195. /**
  196. * Make unavailable the language
  197. * @param Integer The language id
  198. * @return void()
  199. */
  200. public static function make_unavailable_language ($language_id) {
  201. $tbl_admin_languages= Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  202. $sql_make_unavailable = "UPDATE $tbl_admin_languages SET available='0' WHERE id='".Database::escape_string($language_id)."'";
  203. $result = Database::query($sql_make_unavailable);
  204. }
  205. /**
  206. * Make available the language
  207. * @param Integer The language id
  208. * @return void
  209. */
  210. public static function make_available_language ($language_id) {
  211. $tbl_admin_languages= Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  212. $sql_make_available = "UPDATE $tbl_admin_languages SET available='1' WHERE id='".Database::escape_string($language_id)."'";
  213. $result = Database::query($sql_make_available);
  214. }
  215. /**
  216. * Set platform language
  217. * @param Integer The language id
  218. * @return void()
  219. */
  220. public static function set_platform_language ($language_id) {
  221. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  222. $tbl_settings_current = Database :: get_main_table(TABLE_MAIN_SETTINGS_CURRENT);
  223. $sql_update = "SELECT english_name FROM ". $tbl_admin_languages." WHERE id='".Database::escape_string($language_id)."'";
  224. $result = Database::query($sql_update);
  225. $lang=Database::fetch_array($result);
  226. $sql_update_2 = "UPDATE ".$tbl_settings_current." SET selected_value='".$lang['english_name']."' WHERE variable='platformLanguage'";
  227. $result_2 = Database::query($sql_update_2);
  228. }
  229. /**
  230. * Get parent language path (or null if no parent)
  231. * @param string Children language path
  232. * @return string Parent language path or null
  233. */
  234. public static function get_parent_language_path ($language_path) {
  235. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  236. $tbl_settings_current = Database :: get_main_table(TABLE_MAIN_SETTINGS_CURRENT);
  237. $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)."')";
  238. $result = Database::query($sql_update);
  239. if (Database::num_rows($result) == 0) {
  240. return null;
  241. }
  242. $row = Database::fetch_array($result);
  243. return $row['dokeos_folder'];
  244. }
  245. }
  246. ?>