sub_language_add.php 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * This script allows for the addition of sub-languages
  5. * @package chamilo.admin
  6. */
  7. $cidReset = true;
  8. require_once __DIR__.'/../inc/global.inc.php';
  9. $this_section = SECTION_PLATFORM_ADMIN;
  10. api_protect_admin_script();
  11. /**
  12. * MAIN CODE
  13. */
  14. // setting the name of the tool
  15. $tool_name = get_lang('CreateSubLanguage');
  16. // setting breadcrumbs
  17. $interbreadcrumb[] = array('url' => 'index.php', 'name' => get_lang('PlatformAdmin'));
  18. $interbreadcrumb[] = array('url' => 'languages.php', 'name' => get_lang('PlatformLanguages'));
  19. /**
  20. * Add sub-language
  21. * @param string Original language name (Occitan, Wallon, Vlaams)
  22. * @param string English language name (occitan, wallon, flanders)
  23. * @param string ISO code (fr_FR, ...)
  24. * @param int Whether the sublanguage is published (0=unpublished, 1=published)
  25. * @param int ID del idioma padre
  26. * @return false|string New sub language ID or false on error
  27. */
  28. function add_sub_language($original_name, $english_name, $isocode, $sublanguage_available, $parent_id)
  29. {
  30. $tbl_admin_languages = Database::get_main_table(TABLE_MAIN_LANGUAGE);
  31. $original_name = Database::escape_string($original_name);
  32. $english_name = Database::escape_string($english_name);
  33. $isocode = Database::escape_string($isocode);
  34. $sublanguage_available = Database::escape_string($sublanguage_available);
  35. $parent_id = intval($parent_id);
  36. $sql = 'INSERT INTO '.$tbl_admin_languages.'(original_name,english_name,isocode,dokeos_folder,available,parent_id)
  37. VALUES ("' . $original_name.'","'.$english_name.'","'.$isocode.'","'.$english_name.'","'.$sublanguage_available.'","'.$parent_id.'")';
  38. $res = Database::query($sql);
  39. if ($res === false) {
  40. return false;
  41. }
  42. return Database::insert_id();
  43. }
  44. /**
  45. * Check if language exists
  46. * @param string Original language name (Occitan, Wallon, Vlaams)
  47. * @param string English language name (occitan, wallon, flanders)
  48. * @param string ISO code (fr_FR, ...)
  49. * @param int Whether the sublanguage is published (0=unpublished, 1=published)
  50. * @return array Array describing the number of items found that match the
  51. * current language insert attempt (original_name => true,
  52. * english_name => true, isocode => true,
  53. * execute_add => true/false). If execute_add is true, then we
  54. * can proceed.
  55. * @todo This function is not transaction-safe and should probably be included
  56. * inside the add_sub_language function.
  57. */
  58. function check_if_language_exist($original_name, $english_name, $isocode, $sublanguage_available)
  59. {
  60. $tbl_admin_languages = Database::get_main_table(TABLE_MAIN_LANGUAGE);
  61. $sql_original_name = 'SELECT count(*) AS count_original_name FROM '.$tbl_admin_languages.'
  62. WHERE original_name="'.Database::escape_string($original_name).'" ';
  63. $sql_english_name = 'SELECT count(*) AS count_english_name FROM '.$tbl_admin_languages.'
  64. WHERE english_name="'.Database::escape_string($english_name).'" ';
  65. $rs_original_name = Database::query($sql_original_name);
  66. $rs_english_name = Database::query($sql_english_name);
  67. $count_original_name = Database::result($rs_original_name, 0, 'count_original_name');
  68. $count_english_name = Database::result($rs_english_name, 0, 'count_english_name');
  69. $has_error = false;
  70. $message_information = array();
  71. if ($count_original_name == 1) {
  72. $has_error = true;
  73. $message_information['original_name'] = true;
  74. }
  75. if ($count_english_name == 1) {
  76. $has_error = true;
  77. $message_information['english_name'] = true;
  78. }
  79. $iso_list = api_get_platform_isocodes();
  80. $iso_list = array_values($iso_list);
  81. if (!in_array($isocode, $iso_list)) {
  82. $has_error = true;
  83. $message_information['isocode'] = true;
  84. }
  85. if ($has_error === true) {
  86. $message_information['execute_add'] = false;
  87. }
  88. if ($has_error === false) {
  89. $message_information['execute_add'] = true;
  90. }
  91. return $message_information;
  92. }
  93. /**
  94. * Check if language exist, given its ID. This is just a wrapper for the
  95. * SubLanguageManager::check_if_exist_language_by_id() method and should not exist
  96. * @param int Language ID
  97. * @return bool
  98. * @todo deprecate this function and use the static method directly
  99. */
  100. function check_if_exist_language_by_id($language_id)
  101. {
  102. return SubLanguageManager::check_if_exist_language_by_id($language_id);
  103. }
  104. /**
  105. * Check if the given language is a parent of any sub-language
  106. * @param int Language ID of the presumed parent
  107. * @return bool True if this language has children, false otherwise
  108. */
  109. function ckeck_if_is_parent_of_sub_language($parent_id)
  110. {
  111. $sql = 'SELECT count(*) AS count FROM language WHERE parent_id= '.intval($parent_id);
  112. $rs = Database::query($sql);
  113. if (Database::num_rows($rs) > 0 && Database::result($rs, 0, 'count') == 1) {
  114. return true;
  115. } else {
  116. return false;
  117. }
  118. }
  119. /**
  120. * Get all information of sub-language
  121. * @param int Parent language ID
  122. * @param int Child language ID
  123. * @return array
  124. */
  125. function allow_get_all_information_of_sub_language($parent_id, $sub_language_id)
  126. {
  127. return SubLanguageManager::get_all_information_of_sub_language($parent_id, $sub_language_id);
  128. }
  129. /*end declare functions*/
  130. //add data
  131. if (isset($_GET['sub_language_id']) && $_GET['sub_language_id'] == strval(intval($_GET['sub_language_id']))) {
  132. $language_name = SubLanguageManager::get_name_of_language_by_id($_GET['sub_language_id']);
  133. if (check_if_exist_language_by_id($_GET['sub_language_id']) === true) {
  134. $sub_language_id = $_GET['sub_language_id'];
  135. $sub_language_id_exist = true;
  136. } else {
  137. $sub_language_id_exist = false;
  138. }
  139. }
  140. $language_details = array();
  141. $language_name = '';
  142. if (isset($_GET['id']) && $_GET['id'] == strval(intval($_GET['id']))) {
  143. $language_details = SubLanguageManager::get_all_information_of_language($_GET['id']);
  144. $language_name = $language_details['original_name'];
  145. if (check_if_exist_language_by_id($_GET['id']) === true) {
  146. $parent_id = $_GET['id'];
  147. $language_id_exist = true;
  148. } else {
  149. $language_id_exist = false;
  150. }
  151. } else {
  152. $language_id_exist = false;
  153. }
  154. //removed and register
  155. if ((isset($_GET['id']) && $_GET['id'] == strval(intval($_GET['id']))) &&
  156. (isset($_GET['sub_language_id']) && $_GET['sub_language_id'] == strval(intval($_GET['sub_language_id'])))
  157. ) {
  158. if (check_if_exist_language_by_id($_GET['id']) === true && check_if_exist_language_by_id($_GET['sub_language_id']) === true) {
  159. $get_all_information = allow_get_all_information_of_sub_language($_GET['id'], $_GET['sub_language_id']);
  160. $original_name = $get_all_information['original_name'];
  161. $english_name = $get_all_information['english_name'];
  162. $isocode = $get_all_information['isocode'];
  163. }
  164. }
  165. $language_name = get_lang('CreateSubLanguageForLanguage').' ( '.strtolower($language_name).' )';
  166. if (ckeck_if_is_parent_of_sub_language($parent_id) === true &&
  167. isset($_GET['action']) && $_GET['action'] == 'deletesublanguage'
  168. ) {
  169. $language_name = get_lang('DeleteSubLanguage');
  170. }
  171. $msg = '';
  172. if (isset($_POST['SubmitAddNewLanguage'])) {
  173. $original_name = $_POST['original_name'];
  174. $english_name = $_POST['english_name'];
  175. $isocode = $_POST['isocode'];
  176. $english_name = str_replace(' ', '_', $english_name);
  177. $isocode = str_replace(' ', '_', $isocode);
  178. $sublanguage_available = $_POST['sub_language_is_visible'];
  179. $check_information = array();
  180. $check_information = check_if_language_exist($original_name, $english_name, $isocode, $sublanguage_available);
  181. foreach ($check_information as $index_information => $value_information) {
  182. $allow_insert_info = false;
  183. if ($index_information == 'original_name') {
  184. $msg .= Display::return_message(
  185. get_lang('AlreadyExists').' "'.get_lang('OriginalName').'" '.'('.$original_name.')',
  186. 'error'
  187. );
  188. }
  189. if ($index_information == 'english_name') {
  190. $msg .= Display::return_message(
  191. get_lang('AlreadyExists').' "'.get_lang('EnglishName').'" '.'('.$english_name.')',
  192. 'error'
  193. );
  194. }
  195. if ($index_information == 'isocode') {
  196. $msg .= Display::return_message(get_lang('CodeDoesNotExists').': '.$isocode.'', 'error');
  197. }
  198. if ($index_information == 'execute_add' && $value_information === true) {
  199. $allow_insert_info = true;
  200. }
  201. }
  202. if (strlen($original_name) > 0 && strlen($english_name) > 0 && strlen($isocode) > 0) {
  203. if ($allow_insert_info === true && $language_id_exist === true) {
  204. $english_name = str_replace(' ', '_', $english_name);
  205. //Fixes BT#1636
  206. $english_name = api_strtolower($english_name);
  207. $isocode = str_replace(' ', '_', $isocode);
  208. $str_info = '<br/>'.get_lang('OriginalName').' : '.$original_name.'<br/>'.get_lang('EnglishName').' : '.$english_name.'<br/>'.get_lang('PlatformCharsetTitle').' : '.$isocode;
  209. $mkdir_result = SubLanguageManager::add_language_directory($english_name);
  210. if ($mkdir_result) {
  211. $sl_id = add_sub_language($original_name, $english_name, $isocode, $sublanguage_available, $parent_id);
  212. if ($sl_id === false) {
  213. SubLanguageManager::remove_language_directory($english_name);
  214. $msg .= Display::return_message(get_lang('LanguageDirectoryNotWriteableContactAdmin'), 'error');
  215. } else {
  216. Display::addFlash(
  217. Display::return_message(get_lang('TheNewSubLanguageHasBeenAdded').$str_info, null, false)
  218. );
  219. unset($interbreadcrumb);
  220. $_GET['sub_language_id'] = $_REQUEST['sub_language_id'] = $sl_id;
  221. require 'sub_language.php';
  222. exit();
  223. }
  224. } else {
  225. $msg .= Display::return_message(get_lang('LanguageDirectoryNotWriteableContactAdmin'), 'error');
  226. }
  227. } else {
  228. if ($language_id_exist === false) {
  229. $msg .= Display::return_message(get_lang('LanguageParentNotExist'), 'error');
  230. }
  231. }
  232. } else {
  233. $msg .= Display::return_message(get_lang('FormHasErrorsPleaseComplete'), 'error');
  234. }
  235. }
  236. Display:: display_header($language_name);
  237. echo $msg;
  238. if (isset($_POST['SubmitAddDeleteLanguage'])) {
  239. $rs = SubLanguageManager::remove_sub_language($_GET['id'], $_GET['sub_language_id']);
  240. if ($rs === true) {
  241. echo Display::return_message(get_lang('TheSubLanguageHasBeenRemoved'), 'confirm');
  242. } else {
  243. echo Display::return_message(get_lang('TheSubLanguageHasNotBeenRemoved'), 'error');
  244. }
  245. }
  246. // ckeck_if_is_parent_of_sub_language($parent_id)===false
  247. if (isset($_GET['action']) && $_GET['action'] == 'definenewsublanguage') {
  248. $text = $language_name;
  249. $form = new FormValidator(
  250. 'addsublanguage',
  251. 'post',
  252. 'sub_language_add.php?id='.Security::remove_XSS($_GET['id']).'&action=definenewsublanguage'
  253. );
  254. $class = 'add';
  255. $form->addElement('header', '', $text);
  256. $form->addElement('text', 'original_name', get_lang('OriginalName'), 'class="input_titles"');
  257. $form->addRule('original_name', get_lang('ThisFieldIsRequired'), 'required');
  258. $form->addElement('text', 'english_name', get_lang('EnglishName'), 'class="input_titles"');
  259. $form->addRule('english_name', get_lang('ThisFieldIsRequired'), 'required');
  260. $form->addElement('text', 'isocode', get_lang('ISOCode'), 'class="input_titles"');
  261. $form->addRule('isocode', get_lang('ThisFieldIsRequired'), 'required');
  262. $form->addElement('static', null, '&nbsp;', '<i>en, es, fr</i>');
  263. $form->addElement('checkbox', 'sub_language_is_visible', '', get_lang('Visibility'));
  264. $form->addButtonCreate(get_lang('CreateSubLanguage'), 'SubmitAddNewLanguage');
  265. //$values['original_name'] = $language_details['original_name'].'...'; -> cannot be used because of quickform filtering (freeze)
  266. $values['english_name'] = $language_details['english_name'].'2';
  267. $values['isocode'] = $language_details['isocode'];
  268. $form->setDefaults($values);
  269. $form->display();
  270. } else {
  271. if (isset($_GET['action']) && $_GET['action'] == 'deletesublanguage') {
  272. $text = $language_name;
  273. $form = new FormValidator(
  274. 'deletesublanguage',
  275. 'post',
  276. 'sub_language_add.php?id='.Security::remove_XSS($_GET['id']).'&sub_language_id='.Security::remove_XSS($_GET['sub_language_id'])
  277. );
  278. $class = 'minus';
  279. $form->addElement('header', '', $text);
  280. $form->addElement('static', '', get_lang('OriginalName'), $original_name);
  281. $form->addElement('static', '', get_lang('EnglishName'), $english_name);
  282. $form->addElement('static', '', get_lang('PlatformCharsetTitle'), $isocode);
  283. $form->addButtonCreate(get_lang('DeleteSubLanguage'), 'SubmitAddDeleteLanguage');
  284. $form->display();
  285. }
  286. if (isset($_GET['action']) && $_GET['action'] == 'definenewsublanguage') {
  287. echo Display::return_message(get_lang('TheSubLanguageForThisLanguageHasBeenAdded'));
  288. }
  289. }
  290. /**
  291. * Footer
  292. */
  293. Display:: display_footer();