sub_language_add.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293
  1. <?php
  2. /* For licensing terms, see /dokeos_license.txt */
  3. /*
  4. ==============================================================================
  5. INIT SECTION
  6. ==============================================================================
  7. */
  8. // name of the language file that needs to be included
  9. $language_file = 'admin';
  10. $cidReset = true;
  11. require_once '../inc/global.inc.php';
  12. require_once 'sub_language.class.php';
  13. $this_section=SECTION_PLATFORM_ADMIN;
  14. api_protect_admin_script();
  15. /*
  16. ==============================================================================
  17. MAIN CODE
  18. ==============================================================================
  19. */
  20. // setting the name of the tool
  21. $tool_name = get_lang('CreateSubLanguage');
  22. // setting breadcrumbs
  23. $interbreadcrumb[] = array ('url' => 'index.php', 'name' => get_lang('PlatformAdmin'));
  24. $interbreadcrumb[] = array ('url' => 'languages.php', 'name' => get_lang('PlatformLanguages'));
  25. require_once api_get_path(LIBRARY_PATH).'text.lib.php';
  26. require_once api_get_path(LIBRARY_PATH).'formvalidator/FormValidator.class.php';
  27. /*declare functions*/
  28. /**
  29. * Add sub-language
  30. */
  31. function add_sub_language ($original_name,$english_name,$isocode,$sublanguage_available,$parent_id) {
  32. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  33. $sql='INSERT INTO '.$tbl_admin_languages.'(original_name,english_name,isocode,dokeos_folder,available,parent_id) VALUES ("'.api_htmlentities($original_name).'","'.$english_name.'","'.$isocode.'","'.$english_name.'","'.$sublanguage_available.'","'.$parent_id.'")';
  34. Database::query($sql,__FILE__,__LINE__);
  35. }
  36. /**
  37. * check if language exists
  38. */
  39. function check_if_language_exist ($original_name,$english_name,$isocode,$sublanguage_available) {
  40. $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  41. $sql_original_name='SELECT count(*) AS count_original_name FROM '.$tbl_admin_languages.' WHERE original_name="'.Database::escape_string(api_htmlentities($original_name)).'" ';
  42. $sql_english_name='SELECT count(*) AS count_english_name FROM '.$tbl_admin_languages.' WHERE english_name="'.Database::escape_string($english_name).'" ';
  43. $sql_isocode='SELECT count(*) AS count_isocode FROM '.$tbl_admin_languages.' WHERE isocode="'.Database::escape_string($isocode).'" ';
  44. $rs_original_name=Database::query($sql_original_name,__FILE__,__LINE__);
  45. $rs_english_name=Database::query($sql_english_name,__FILE__,__LINE__);
  46. $rs_isocode=Database::query($sql_isocode,__FILE__,__LINE__);
  47. $count_original_name=Database::result($rs_original_name,0,'count_original_name');
  48. $count_english_name=Database::result($rs_english_name,0,'count_english_name');
  49. $count_isocode=Database::result($rs_isocode,0,'count_isocode');
  50. $has_error=false;
  51. $message_information=array();
  52. if ($count_original_name==1) {
  53. $has_error=true;
  54. $message_information['original_name']=true;
  55. }
  56. if ($count_english_name==1) {
  57. $has_error=true;
  58. $message_information['english_name']=true;
  59. }
  60. if ($count_isocode==1) {
  61. $has_error=true;
  62. $message_information['isocode']=true;
  63. }
  64. if ($has_error===true) {
  65. $message_information['execute_add']=false;
  66. }
  67. if ($has_error===false) {
  68. $message_information['execute_add']=true;
  69. }
  70. return $message_information;
  71. }
  72. /**
  73. * get name of language by id
  74. */
  75. function get_name_of_language_by_id ($language_id) {
  76. return SubLanguageManager::get_name_of_language_by_id($language_id);
  77. }
  78. /**
  79. * check if language exist by id
  80. */
  81. function check_if_exist_language_by_id ($language_id) {
  82. return SubLanguageManager::check_if_exist_language_by_id($language_id);
  83. }
  84. /**
  85. * check if is parent of sub-language
  86. */
  87. function ckeck_if_is_parent_of_sub_language ($parent_id) {
  88. $sql='SELECT count(*) AS count FROM language WHERE parent_id="'.Database::escape_string($parent_id).'"';
  89. $rs=Database::query($sql,__FILE__,__LINE__);
  90. if (Database::num_rows($rs)>0 && Database::result($rs,0,'count')==1) {
  91. return true;
  92. } else {
  93. return false;
  94. }
  95. }
  96. /**
  97. * Get all information of sub-language
  98. */
  99. function allow_get_all_information_of_sub_language ($parent_id,$sub_language_id) {
  100. return SubLanguageManager::get_all_information_of_sub_language($parent_id,$sub_language_id);
  101. }
  102. /**
  103. * Add directory for sub-language
  104. */
  105. function add_directory_of_sub_language ($path_sub_language) {
  106. return SubLanguageManager::add_directory_of_sub_language($path_sub_language);
  107. }
  108. /**
  109. * Remove directory of sub-language
  110. */
  111. function remove_directory_of_sub_language ($path) {
  112. $content=SubLanguageManager::get_all_data_of_dokeos_folder($path);
  113. if (count($content)>0) {
  114. foreach ($content as $value_content) {
  115. $path_file=$path.'/'.$value_content;
  116. unlink($path_file);
  117. }
  118. $rs=@rmdir($path);
  119. if ($rs===true) {
  120. return true;
  121. } else {
  122. return false;
  123. }
  124. } else {
  125. $rs=@rmdir($path);
  126. if ($rs===true) {
  127. return true;
  128. } else {
  129. return false;
  130. }
  131. }
  132. }
  133. /*end declare functions*/
  134. //add data
  135. if (isset($_GET['sub_language_id']) && $_GET['sub_language_id']==strval(intval($_GET['sub_language_id']))) {
  136. $language_name=get_name_of_language_by_id($_GET['sub_language_id']);
  137. if (check_if_exist_language_by_id ($_GET['sub_language_id'])===true) {
  138. $sub_language_id=$_GET['sub_language_id'];
  139. $sub_language_id_exist=true;
  140. } else {
  141. $sub_language_id_exist=false;
  142. }
  143. }
  144. if (isset($_GET['id']) && $_GET['id']==strval(intval($_GET['id']))) {
  145. $language_name=get_name_of_language_by_id($_GET['id']);
  146. if (check_if_exist_language_by_id ($_GET['id'])===true) {
  147. $parent_id=$_GET['id'];
  148. $language_id_exist=true;
  149. } else {
  150. $language_id_exist=false;
  151. }
  152. } else {
  153. $language_name='';
  154. $language_id_exist=false;
  155. }
  156. //removed and register
  157. if ((isset($_GET['id']) && $_GET['id']==strval(intval($_GET['id']))) && (isset($_GET['sub_language_id']) && $_GET['sub_language_id']==strval(intval($_GET['sub_language_id'])))) {
  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 && isset($_GET['action']) && $_GET['action']=='deletesublanguage') {
  167. $language_name=get_lang('DeleteSubLanguage');
  168. }
  169. Display :: display_header($language_name);
  170. if (isset($_POST['SubmitAddNewLanguage'])) {
  171. $original_name=$_POST['original_name'];
  172. $english_name=$_POST['english_name'];
  173. $isocode=$_POST['isocode'];
  174. $english_name=str_replace(' ','_',$english_name);
  175. $isocode=str_replace(' ','_',$isocode);
  176. $sublanguage_available=$_POST['sub_language_is_visible'];
  177. $check_information=array();
  178. $check_information=check_if_language_exist($original_name,$english_name,$isocode,$sublanguage_available);
  179. foreach ($check_information as $index_information => $value_information) {
  180. $allow_insert_info=false;
  181. if ($index_information=='original_name') {
  182. Display::display_error_message(get_lang('AlreadyExists').' "'.get_lang('OriginalName').'" '.'('.$original_name.')');
  183. }
  184. if ($index_information=='english_name') {
  185. Display::display_error_message(get_lang('AlreadyExists').' "'.get_lang('EnglishName').'" '.'('.$english_name.')');
  186. }
  187. if ($index_information=='isocode') {
  188. Display::display_error_message(get_lang('AlreadyExists').' "'.get_lang('PlatformCharsetTitle').'" '.'('.$isocode.')');
  189. }
  190. if ($index_information=='execute_add' && $value_information===true) {
  191. $allow_insert_info=true;
  192. }
  193. }
  194. if (strlen($original_name)>0 && strlen($english_name)>0 && strlen($isocode)>0) {
  195. if ($allow_insert_info===true && $language_id_exist===true) {
  196. $english_name=str_replace(' ','_',$english_name);
  197. $isocode=str_replace(' ','_',$isocode);
  198. $str_info='<br/>'.get_lang('OriginalName').' : '.$original_name.'<br/>'.get_lang('EnglishName').' : '.$english_name.'<br/>'.get_lang('PlatformCharsetTitle').' : '.$isocode;
  199. $path=api_get_path('SYS_LANG_PATH').$english_name;
  200. $mkdir_result=add_directory_of_sub_language($path);
  201. if ($mkdir_result===true) {
  202. add_sub_language($original_name,$english_name,$isocode,$sublanguage_available,$parent_id);
  203. Display::display_confirmation_message(get_lang('TheNewSubLanguageHasBeenAdd').$str_info,false);
  204. } else {
  205. Display::display_error_message(get_lang('LanguageDirectoryNotWriteableContactAdmin'));
  206. }
  207. } else {
  208. if ($language_id_exist===false) {
  209. Display::display_error_message(get_lang('LanguageParentNotExist'));
  210. }
  211. }
  212. } else {
  213. Display::display_error_message(get_lang('FormHasErrorsPleaseComplete'));
  214. }
  215. }
  216. if (isset($_POST['SubmitAddDeleteLanguage'])) {
  217. $path=api_get_path('SYS_LANG_PATH').$english_name;
  218. if (is_dir($path)) {
  219. $rs=remove_directory_of_sub_language($path);
  220. if ($rs===true) {
  221. SubLanguageManager::removed_sub_language($parent_id,$sub_language_id);
  222. Display::display_confirmation_message(get_lang('TheSubLanguageHasBeenRemoved'));
  223. }
  224. }
  225. }
  226. // ckeck_if_is_parent_of_sub_language($parent_id)===false
  227. //
  228. if (isset($_GET['action']) && $_GET['action']=='definenewsublanguage') {
  229. $text=$language_name;
  230. $form = new FormValidator('addsublanguage', 'post', 'sub_language_add.php?id='.Security::remove_XSS($_GET['id']).'&action=definenewsublanguage');
  231. $class='add';
  232. $form->addElement('header', '', $text);
  233. $form->addElement('text', 'original_name', get_lang('OriginalName'),'class="input_titles"');
  234. $form->addRule('original_name', get_lang('ThisFieldIsRequired'), 'required');
  235. $form->addElement('text', 'english_name', get_lang('EnglishName'),'class="input_titles"');
  236. $form->addRule('english_name', get_lang('ThisFieldIsRequired'), 'required');
  237. $form->addElement('text', 'isocode', get_lang('PlatformCharsetTitle'),'class="input_titles"');
  238. $form->addRule('isocode', get_lang('ThisFieldIsRequired'), 'required');
  239. $form->addElement('checkbox', 'sub_language_is_visible', '', get_lang('Visibility'));
  240. $form->addElement('style_submit_button', 'SubmitAddNewLanguage', get_lang('CreateSubLanguage'), 'class="'.$class.'"');
  241. $form->display();
  242. } else {
  243. if (isset($_GET['action']) && $_GET['action']=='deletesublanguage') {
  244. $text=$language_name;
  245. $form = new FormValidator('deletesublanguage', 'post', 'sub_language_add.php?id='.Security::remove_XSS($_GET['id']).'&sub_language_id='.Security::remove_XSS($_GET['sub_language_id']));
  246. $class='minus';
  247. $form->addElement('header', '', $text);
  248. $form->addElement('static', '', get_lang('OriginalName'),$original_name);
  249. $form->addElement('static', '', get_lang('EnglishName'),$english_name);
  250. $form->addElement('static', '', get_lang('PlatformCharsetTitle'),$isocode);
  251. $form->addElement('style_submit_button', 'SubmitAddDeleteLanguage', get_lang('DeleteSubLanguage'), 'class="'.$class.'"');
  252. $form->display();
  253. }
  254. if (isset($_GET['action']) && $_GET['action']=='definenewsublanguage') {
  255. Display::display_normal_message(get_lang('TheSubLanguageForThisLanguageHasBeenAdd'));
  256. }
  257. }
  258. /*
  259. ==============================================================================
  260. FOOTER
  261. ==============================================================================
  262. */
  263. Display :: display_footer();
  264. ?>