| [ Index ] |
|
Code source de vtiger CRM 5.0.2 |
1 {*<!-- 2 /********************************************************************************* 3 ** The contents of this file are subject to the vtiger CRM Public License Version 1.0 4 * ("License"); You may not use this file except in compliance with the License 5 * The Original Code is: vtiger CRM Open Source 6 * The Initial Developer of the Original Code is vtiger. 7 * Portions created by vtiger are Copyright (C) vtiger. 8 * All Rights Reserved. 9 * 10 ********************************************************************************/ 11 -->*} 12 13 14 <script language="JavaScript" type="text/javascript" src="include/js/menu.js"></script> 15 <script language="JavaScript" type="text/javascript" src="include/js/general.js"></script> 16 17 <form name="Migration" method="POST" action="index.php" enctype="multipart/form-data"> 18 <input type="hidden" name="module" value="Migration"> 19 <input type="hidden" name="action" value="MigrationCheck"> 20 <input type="hidden" name="migration_option" value=""> 21 <input type="hidden" name="parenttab" value="Settings"> 22 <input type="hidden" id="getmysqlpath" name="getmysqlpath" value="{$GET_MYSQL_PATH}"> 23 24 <table width="100%" border="0" cellpadding="0" cellspacing="0" height="100%" class="small"> 25 <tr> 26 <td class="showPanelBg" valign="top" width="95%" style="padding-left:20px; "><br /> 27 <span class="lvtHeaderText"> {$MOD.LBL_SETTINGS} > {$MOD.LBL_UPGRADE_VTIGER}</span> 28 <span class="lvtHeaderText" align="right"> 29 30 {if $502_PATCH eq 'apply'} 31 <a style="color:red;" href="index.php?module=Migration&action=502DBChanges&parenttab=Settings">Click here to apply the 5.0.2 Database changes from 5.0.0/5.0.1</a> 32 {/if} 33 </span> 34 <hr noshade="noshade" size="1" /> 35 </td> 36 <td width="5%" class="showPanelBg"> </td> 37 </tr> 38 <tr> 39 <td width="98%" style="padding-left:20px;" valign="top"> 40 <!-- module Select Table --> 41 <table width="95%" border="0" cellspacing="0" cellpadding="0" align="center" class="mailClient"> 42 <tr> 43 <td class="mailClientBg" width="7"></td> 44 <td class="mailClientBg" style="padding-left:10px;padding-top:10px;vertical-align:top;"> 45 <table width="100%" border="0" cellpadding="5" cellspacing="0" class="small"> 46 <tr> 47 <td width="10%"><img src="{$IMAGE_PATH}migrate.gif" align="absmiddle"/></td> 48 <td width="90%"> 49 <span class="genHeaderBig">{$MOD.LBL_UPGRADE_VTIGER}</span><br /> 50 ({$MOD.LBL_UPGRADE_FROM_VTIGER_423}) 51 </td> 52 </tr> 53 <tr> 54 <td colspan="2" class="hdrNameBg"> 55 <span class="genHeaderGray">{$MOD.LBL_STEP} 1 : </span> 56 <span class="genHeaderSmall">{$MOD.LBL_SELECT_SOURCE}</span><br /> 57 {$MOD.LBL_STEP1_DESC}<br /><br /> 58 </td> 59 </tr> 60 <tr bgcolor="#FFFFFF"> 61 <td align="right" valign="top"> 62 <input type="radio" name="radio" id="db_details" value="db_details" onclick="fnChangeMigrate()" "{$DB_DETAILS_CHECKED}" /> 63 </td> 64 <td> 65 <b>{$MOD.LBL_RADIO_BUTTON1_TEXT}</b><br /><br /> 66 <b>{$MOD.LBL_NOTE_TITLE}</b> {$MOD.LBL_RADIO_BUTTON1_DESC} 67 </td> 68 </tr> 69 <tr><td colspan="2" bgcolor="#FFFFFF" height="10"></td></tr> 70 <tr bgcolor="#FFFFFF"> 71 <td align="right" valign="top"> 72 <input type="radio" name="radio" id="dump_details" value="dump_details" onclick="fnChangeMigrate()" "{$DUMP_DETAILS_CHECKED}"/> 73 </td> 74 <td> 75 <b>{$MOD.LBL_RADIO_BUTTON2_TEXT}</b><br /><br /> 76 <b>{$MOD.LBL_NOTE_TITLE}</b> {$MOD.LBL_RADIO_BUTTON2_DESC} 77 </td> 78 </tr> 79 <tr><td colspan="2" bgcolor="#FFFFFF" height="10"></td></tr> 80 <tr bgcolor="#FFFFFF"> 81 <td align="right" valign="top"> 82 <input type="radio" name="radio" id="alter_db_details" value="alter_db_details" onclick="fnChangeMigrate()" "{$ALTER_DB_DETAILS_CHECKED}"/> 83 </td> 84 <td> 85 <b>{$MOD.LBL_RADIO_BUTTON3_TEXT}</b><br /><br /><b>{$MOD.LBL_NOTE_TITLE}</b> {$MOD.LBL_RADIO_BUTTON3_DESC} 86 </td> 87 </tr> 88 <tr><td colspan="2" bgcolor="#FFFFFF" height="10"></td></tr> 89 90 <tr><td colspan="2" height="10"></td></tr> 91 <tr> 92 <td colspan="2" class="hdrNameBg"> 93 94 95 <!-- OPTION 1 --> 96 <div id="mnuTab" style="display:{$SHOW_DB_DETAILS}"> 97 <table width="100%" border="0" cellpadding="5" cellspacing="0" class="small"> 98 <tr > 99 <td colspan="2"> 100 <span class="genHeaderGray">{$MOD.LBL_STEP} 2 : </span> 101 <span class="genHeaderSmall">{$MOD.LBL_HOST_DB_ACCESS_DETAILS}</span><br /><br /> 102 </td> 103 </tr> 104 <tr> 105 <td width="30%" align="right">{$MOD.LBL_SOURCE_HOST_NAME}</td> 106 <td width="70%"><input type="text" name="old_host_name" class="importBox" value="{$OLD_HOST_NAME}" /></td> 107 </tr> 108 <tr> 109 <td align="right">{$MOD.LBL_SOURCE_MYSQL_PORT_NO}</td> 110 <td><input type="text" name="old_port_no" class="importBox" value="{$OLD_PORT_NO}" /></td> 111 </tr> 112 <tr> 113 <td align="right">{$MOD.LBL_SOURCE_MYSQL_USER_NAME}</td> 114 <td><input type="text" name="old_mysql_username" class="importBox" value="{$OLD_MYSQL_USERNAME}" /></td> 115 </tr> 116 <tr> 117 <td align="right">{$MOD.LBL_SOURCE_MYSQL_PASSWORD}</td> 118 <td><input type="text" name="old_mysql_password" class="importBox" value="{$OLD_MYSQL_PASSWORD}" /></td> 119 </tr> 120 <tr> 121 <td align="right">{$MOD.LBL_SOURCE_DB_NAME}</td> 122 <td><input type="text" name="old_dbname" class="importBox" value="{$OLD_DBNAME}" /></td> 123 </tr> 124 </table> 125 </div> 126 127 <!-- OPTION 2 --> 128 <div id="mnuTab1" style="display:{$SHOW_DUMP_DETAILS}"> 129 <table width="100%" border="0" cellpadding="5" cellspacing="0" class="small"> 130 <tr > 131 <td colspan="2"> 132 <span class="genHeaderGray">{$MOD.LBL_STEP} 2 : </span> 133 <span class="genHeaderSmall">{$MOD.LBL_LOCATE_DB_DUMP_FILE}</span><br /><br /> 134 </td> 135 </tr> 136 <tr> 137 <td width="10%"> </td> 138 <td width="90%"> 139 {$MOD.LBL_DUMP_FILE_LOCATION} 140 <input type="file" name="old_dump_filename" class="txtBox" /> 141 </td> 142 </tr> 143 <tr><td colspan="2" height="10"></td></tr> 144 <tr bgcolor="#FFFFFF"> 145 <td align="right" valign="top"><b>{$MOD.LBL_NOTE_TITLE}</b></td> 146 <td>{$MOD.LBL_NOTES_DUMP_PROCESS}</td> 147 </tr> 148 </table> 149 </div> 150 151 152 <!-- OPTION 3 --> 153 <div id="mnuTab2" style="display:{$SHOW_ALTER_DB_DETAILS}"> 154 <table width="100%" border="0" cellpadding="5" cellspacing="0" class="small"> 155 <tr> 156 <td colspan="3"> 157 <span class="genHeaderGray">{$MOD.LBL_STEP} 2 : </span> 158 <span class="genHeaderSmall">{$MOD.LBL_HOST_DB_ACCESS_DETAILS}</span><br /><br /> 159 </td> 160 </tr> 161 <tr> 162 <td width="5%"> </td> 163 <td width="20%" align="right">{$MOD.LBL_MYSQL_HOST_NAME_IP}</td> 164 <td width="75%"><input type="text" name="alter_old_host_name" class="importBox" value="{$ALTER_OLD_HOST_NAME}" /></td> 165 </tr> 166 <tr> 167 <td> </td> 168 <td align="right">{$MOD.LBL_MYSQL_PORT}</td> 169 <td><input type="text" name="alter_old_port_no" class="importBox" value="{$ALTER_OLD_PORT_NO}" /></td> 170 </tr> 171 <tr> 172 <td> </td> 173 <td align="right">{$MOD.LBL_MYSQL_USER_NAME}</td> 174 <td><input type="text" name="alter_old_mysql_username" class="importBox" value="{$ALTER_OLD_MYSQL_USERNAME}" /></td> 175 </tr> 176 <tr> 177 <td> </td> 178 <td align="right">{$MOD.LBL_MYSQL_PASSWORD}</td> 179 <td><input type="text" name="alter_old_mysql_password" class="importBox" value="{$ALTER_OLD_MYSQL_PASSWORD}" /></td> 180 </tr> 181 <tr> 182 <td> </td> 183 <td align="right">{$MOD.LBL_DB_NAME}</td> 184 <td><input type="text" name="alter_old_dbname" class="importBox" value="{$ALTER_OLD_DBNAME}" /></td> 185 </tr> 186 <tr><td colspan="3" height="10"></td></tr> 187 <tr bgcolor="#FFFFFF"> 188 <td align="right" valign="top"><b>{$MOD.LBL_NOTE_TITLE}</b></td> 189 <td width="90%" colspan="2"> 190 191 {$MOD.LBL_RADIO_BUTTON3_PROCESS} 192 </td> 193 </tr> 194 195 </table> 196 </div> 197 198 199 </td> 200 </tr> 201 202 <!-- this if condition is added to display the text box to get the mysql server path --> 203 {if $GET_MYSQL_PATH eq 1} 204 <tr><td colspan="2" height="10"></td></tr> 205 <tr> 206 <td colspan="2" class="hdrNameBg"> 207 <!-- OPTION 3 --> 208 <div id="mnuTab3" style="width:100%; display:{$SHOW_MYSQL_PATH}"> 209 <table width="100%" border="0" cellpadding="5" cellspacing="0" class="small"> 210 <tr> 211 <td colspan="2" > 212 <span class="genHeaderGray">{$MOD.LBL_STEP} 3 : </span> 213 <span class="genHeaderSmall">{$MOD.LBL_ENTER_MYSQL_SERVER_PATH}</span><br>{$MOD.LBL_SERVER_PATH_DESC}<br /><br /> 214 </td> 215 </tr> 216 <tr> 217 <td align="right" width="30%">{$MOD.LBL_MYSQL_SERVER_PATH}</td> 218 <td width="70%"> 219 <input type="text" name="server_mysql_path" class="txtBox" value="{$SERVER_MYSQL_PATH}" /> 220 </td> 221 </tr> 222 </table> 223 </div> 224 225 226 </td> 227 </tr> 228 {/if} 229 <tr> 230 <td colspan="2" style="padding:10px;" align="center"> 231 <input type="submit" name="migrate" value=" {$MOD.LBL_MIGRATE_BUTTON} " class="crmbutton small save" onclick="return validate_migration(Migration);"/> 232 <input type="submit" name="cancel" value=" {$MOD.LBL_CANCEL_BUTTON} " class="crmbutton small cancel" onclick="this.form.module.value='Settings';this.form.action.value='index';"/> 233 </td> 234 </tr> 235 </table> 236 </td> 237 <td class="mailClientBg" width="8"></td> 238 </tr> 239 </table> 240 <br /> 241 </td> 242 <td> </td> 243 </tr> 244 </table> 245 <!-- END --> 246 </form> 247 248 <script language="javascript" type="text/javascript"> 249 //function to show and hide the db_details or dump_details details based on the radio option selected 250 function fnChangeMigrate() 251 {ldelim} 252 var opt_one = document.getElementById('db_details').checked; 253 var opt_two = document.getElementById('dump_details').checked; 254 var opt_three = document.getElementById('alter_db_details').checked; 255 if(opt_one) 256 {ldelim} 257 document.getElementById('mnuTab').style.display = 'block'; 258 document.getElementById('mnuTab1').style.display = 'none'; 259 document.getElementById('mnuTab2').style.display = 'none'; 260 {rdelim} 261 else if(opt_two) 262 {ldelim} 263 document.getElementById('mnuTab').style.display = 'none'; 264 document.getElementById('mnuTab1').style.display = 'block'; 265 document.getElementById('mnuTab2').style.display = 'none'; 266 {rdelim} 267 else 268 {ldelim} 269 document.getElementById('mnuTab').style.display = 'none'; 270 document.getElementById('mnuTab1').style.display = 'none'; 271 document.getElementById('mnuTab2').style.display = 'block'; 272 {rdelim} 273 274 //show/hide MySQL server path 275 if(document.getElementById('getmysqlpath').value == 1 && document.getElementById('mnuTab2').style.display == 'none') 276 {ldelim} 277 //show MySQL server path 278 document.getElementById('mnuTab3').style.display = 'block'; 279 {rdelim} 280 else 281 {ldelim} 282 //hide MySQL server path 283 document.getElementById('mnuTab3').style.display = 'none'; 284 {rdelim} 285 {rdelim} 286 287 //function to validate the input values based on the radio option selected 288 function validate_migration(formname) 289 {ldelim} 290 291 var error = false; 292 var mig_option = ''; 293 294 if(document.getElementById("db_details").checked == true) 295 {ldelim} 296 formname.migration_option.value = 'db_details'; 297 //check whether the user entered the valid Source MySQL database details when db details selected 298 if(trim(formname.old_host_name.value) == '') 299 {ldelim} 300 error_msg = "Please enter the Source Host Name"; 301 error = true; 302 {rdelim} 303 else if(trim(formname.old_port_no.value) == '') 304 {ldelim} 305 error_msg = "Please enter the Source MySql Port Number"; 306 error = true; 307 {rdelim} 308 else if(trim(formname.old_mysql_username.value) == '') 309 {ldelim} 310 error_msg = "Please enter the Source MySql User Name"; 311 error = true; 312 {rdelim} 313 else if(trim(formname.old_dbname.value) == '') 314 {ldelim} 315 error_msg = "Please enter the Source Database Name"; 316 error = true; 317 {rdelim} 318 {rdelim} 319 else if(document.getElementById("dump_details").checked == true) 320 {ldelim} 321 formname.migration_option.value = 'dump_details'; 322 //check whether the user entered the MySQL File when dump file details selected 323 if(trim(formname.old_dump_filename.value) == '') 324 {ldelim} 325 error_msg = "Please enter the Valid MySQL Dump File"; 326 error = true; 327 {rdelim} 328 {rdelim} 329 else if(document.getElementById("alter_db_details").checked == true) 330 {ldelim} 331 formname.migration_option.value = 'alter_db_details'; 332 //check whether the user entered the valid Source MySQL database details when db details selected 333 if(trim(formname.alter_old_host_name.value) == '') 334 {ldelim} 335 error_msg = "Please enter the Host Name"; 336 error = true; 337 {rdelim} 338 else if(trim(formname.alter_old_port_no.value) == '') 339 {ldelim} 340 error_msg = "Please enter the MySql Port Number"; 341 error = true; 342 {rdelim} 343 else if(trim(formname.alter_old_mysql_username.value) == '') 344 {ldelim} 345 error_msg = "Please enter the MySql User Name"; 346 error = true; 347 {rdelim} 348 else if(trim(formname.alter_old_dbname.value) == '') 349 {ldelim} 350 error_msg = "Please enter the Database Name"; 351 error = true; 352 {rdelim} 353 {rdelim} 354 else 355 {ldelim} 356 formname.migration_option.value = ''; 357 error_msg = "Please select any one option"; 358 error = true; 359 {rdelim} 360 361 //this is added to check whether the getmysql path is true and the user has entered the path or not 362 if(error != true) 363 {ldelim} 364 if(document.getElementById("getmysqlpath").value == 1 && trim(formname.server_mysql_path.value) == '' && document.getElementById("alter_db_details").checked != true) 365 {ldelim} 366 //alert(document.getElementById("getmysqlpath").value+" Enter the mysql path"); 367 error_msg = "Please enter the Correct MySQL Path"; 368 error = true; 369 {rdelim} 370 else 371 {ldelim} 372 //alert(document.getElementById("getmysqlpath").value+" MySQL path found"); 373 error = false; 374 {rdelim} 375 {rdelim} 376 377 //if there is any error then alert the user and return false; 378 if(error == true) 379 {ldelim} 380 alert(error_msg); 381 return false; 382 {rdelim} 383 else 384 {ldelim} 385 return true; 386 {rdelim} 387 {rdelim} 388 </script> 389
titre
Description
Corps
titre
Description
Corps
titre
Description
Corps
titre
Corps
| Généré le : Sun Feb 25 10:22:19 2007 | par Balluche grâce à PHPXref 0.7 |