📄 move.js
字号:
}//+++++++++++++++++++++++++++++++++++++++++++++++++++++ RELATION ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++function Start_relation(){ if(ON_display_field) return; if(!ON_relation ) { document.getElementById('InnoDB_relation').style.display = ''; ON_relation = 1; document.getElementById('hint').innerHTML = LangSelectReferencedKey; document.getElementById('hint').style.visibility = "visible"; document.getElementById('rel_button').className = 'M_butt_Selected_down';//'#FFEE99';gray #AAAAAA if(isIE) { // correct for IE document.getElementById('rel_button').className = 'M_butt_Selected_down_IE'; } } else { document.getElementById('hint').innerHTML = ""; document.getElementById('hint').style.visibility = "hidden"; document.getElementById('rel_button').className = 'M_butt'; click_field = 0; ON_relation = 0; }}function Click_field(T,f,PK) // table field{ if (ON_relation) { if(!click_field) {//.style.display=='none' .style.visibility = "hidden" if(!PK) { alert(LangPleaseSelectPrimaryOrUniqueKey); return 0; }//PK if(j_tabs[db+'.'+T]!='INNODB') document.getElementById('InnoDB_relation').style.display='none'; click_field = 1; link_relation = "T1=" + T + "&F1=" + f; document.getElementById('hint').innerHTML = LangSelectForeignKey; } else { Start_relation(); // hidden hint... if(j_tabs[db+'.'+T]!='INNODB' || !PK ) document.getElementById('InnoDB_relation').style.display='none'; document.getElementById('layer_new_relation').style.left = Glob_X - (document.getElementById('layer_new_relation').offsetWidth>>1); document.getElementById('layer_new_relation').style.top = Glob_Y - document.getElementById('layer_new_relation').offsetHeight - 10; document.getElementById('layer_new_relation').style.visibility = "visible"; link_relation += '&T2=' + T + '&F2=' + f; } } if(ON_display_field) { if(display_field[T] == f) // if is display field { //alert(T); //s = '';for(k in display_field)s += k + ' = ' + display_field[k] + ',';alert(s); old_class = 'tab_field'; //display_field.splice(T, 1); delete display_field[T]; //s = '';for(k in display_field)s += k + ' = ' + display_field[k] + ', ';alert(s); //n = 0;for(k in display_field)n++;alert(n); } else { old_class = 'tab_field_3'; if(display_field[T]) { document.getElementById('_|_tr_' + T + '.' + display_field[T]).className = 'tab_field'; //display_field.splice(T, 1); delete display_field[T]; } display_field[T] = f; } ON_display_field = 0; document.getElementById('hint').innerHTML = ""; document.getElementById('hint').style.visibility = "hidden"; document.getElementById('display_field_button').className = 'M_butt'; makeRequest('pmd_display_field.php', 'T=' + T + '&F=' + f + '&db=' + db + '&token=' + token ); }}function New_relation(){ document.getElementById('layer_new_relation').style.visibility = 'hidden'; link_relation += '&db=' + db + '&token=' + token + '&die_save_pos=0'; link_relation += '&on_delete=' + document.getElementById('on_delete').value + '&on_update=' + document.getElementById('on_update').value; link_relation += Get_url_pos(); //alert(link_relation); makeRequest('pmd_relation_new.php', link_relation);}//----------------------------------------------------- create tables -----------------------------------------------------function Start_table_new(){ window.location.href='db_operations.php?db='+db+'&token='+token;}function Start_tab_upd(table){ window.location.href='tbl_structure.php?db='+db+'&token='+token+'&table='+table;}//----------------------------------------------------- hide tables -----------------------------------------------------function Small_tab_all(id_this) // max/min all tables{ if(isIE) { alert(LangIEnotSupport); return; } if(id_this.alt=="v") { for (key in j_tabs) if(document.getElementById('_|_hide_tbody_'+key).innerHTML=="v") Small_tab(key,0); id_this.alt = ">"; id_this.src="pmd/images/rightarrow1.png"; } else { for (key in j_tabs) if(document.getElementById('_|_hide_tbody_'+key).innerHTML!="v") Small_tab(key,0); id_this.alt = "v"; id_this.src="pmd/images/downarrow1.png"; } Re_load();}function Small_tab_invert() // invert max/min all tables{ if(isIE) { alert(LangIEnotSupport); return; } for (key in j_tabs) Small_tab(key,0); Re_load();}function Small_tab_refresh() { for (key in j_tabs) if(document.getElementById('_|_hide_tbody_'+key).innerHTML!="v") { Small_tab(key,0); Small_tab(key,0); }}function Small_tab(t,re_load) { var id = document.getElementById('_|_tbody_'+t); var id_this = document.getElementById('_|_hide_tbody_'+t); var id_t = document.getElementById(t); id_t.style.width = id_t.offsetWidth; if(id_this.innerHTML=="v") { //---CROSS if(isIE) return; //IE not supported id.style.display = 'none'; id_this.innerHTML = '>'; } else { id.style.display = ''; id_this.innerHTML = 'v'; } if(re_load) Re_load();}//-----------------------------------------------------------------------------------------------------------------function Select_tab(t){ var id_zag = document.getElementById('_|_zag_'+t); if(id_zag.className != 'tab_zag_3') document.getElementById('_|_zag_'+t).className = 'tab_zag_2'; else document.getElementById('_|_zag_'+t).className = 'tab_zag'; //---------- var id_t = document.getElementById(t); window.scrollTo( parseInt(id_t.style.left)-300, parseInt(id_t.style.top)-300 ); setTimeout(function(){document.getElementById('_|_zag_'+t).className = 'tab_zag';},800);}//-----------------------------------------------------------------------------------------------------------------function Canvas_click(id){ var n,relation_name,selected = 0; var a = new Array(); var Key0,Key1,Key2,Key3,Key; Clear(); for (K in contr) for (key in contr[K]) for (key2 in contr[K][key]) for (key3 in contr[K][key][key2]) { if(!document.getElementById("check_vis_"+key2).checked || !document.getElementById("check_vis_"+contr[K][key][key2][key3][0]).checked) continue; // if hide var x1_left = document.getElementById(key2).offsetLeft + 1;//document.getElementById(key2+"."+key3).offsetLeft; var x1_right = x1_left + document.getElementById(key2).offsetWidth; var x2_left = document.getElementById(contr[K][key][key2][key3][0]).offsetLeft;//+document.getElementById(contr[K][key2][key3][0]+"."+contr[K][key2][key3][1]).offsetLeft var x2_right = x2_left + document.getElementById(contr[K][key][key2][key3][0]).offsetWidth; a[0] = Math.abs( x1_left - x2_left ); a[1] = Math.abs(x1_left - x2_right); a[2] = Math.abs( x1_right - x2_left ); a[3] = Math.abs(x1_right - x2_right); n = s_left = s_right = 0; for(var i=1;i<4;i++) if(a[n]>a[i])n=i; if(n==1){ x1 = x1_left-sm_s; x2 = x2_right+sm_s; if(x1<x2)n=0;} if(n==2){ x1 = x1_right+sm_s; x2 = x2_left-sm_s; if(x1>x2)n=0;} if(n==3){ x1 = x1_right+sm_s; x2 = x2_right+sm_s; s_right = 1; } if(n==0){ x1 = x1_left-sm_s; x2 = x2_left-sm_s; s_left = 1; } var y1 = document.getElementById(key2).offsetTop + document.getElementById(key2+"."+key3).offsetTop + height_field; var y2 = document.getElementById(contr[K][key][key2][key3][0]).offsetTop + document.getElementById(contr[K][key][key2][key3][0]+"."+contr[K][key][key2][key3][1]).offsetTop + height_field; if( !selected && Glob_X > x1-10 && Glob_X < x1+10 && Glob_Y > y1-7 && Glob_Y < y1+7) { Line0(x1-sm_x,y1-sm_y,x2-sm_x,y2-sm_y,"rgba(255,0,0,1)"); selected = 1; // Rect(x1-sm_x,y1-sm_y,10,10,"rgba(0,255,0,1)"); relation_name = key; // Key0=contr[K][key][key2][key3][0]; Key1=contr[K][key][key2][key3][1]; Key2 = key2; Key3 = key3; Key = K; } else Line0(x1-sm_x,y1-sm_y,x2-sm_x,y2-sm_y,"rgba(0,100,150,1)"); } if( selected ) // select relations { //alert(Key0+' - '+Key1+' - '+Key2+' - '+Key3); document.getElementById('layer_upd_relation').style.left = Glob_X - (document.getElementById('layer_upd_relation').offsetWidth>>1); document.getElementById('layer_upd_relation').style.top = Glob_Y - document.getElementById('layer_upd_relation').offsetHeight-10; document.getElementById('layer_upd_relation').style.visibility = 'visible'; link_relation = 'T1='+Key0+'&F1='+Key1+'&T2='+Key2+'&F2='+Key3+'&K='+Key; }}function Upd_relation(){ document.getElementById('layer_upd_relation').style.visibility = 'hidden'; link_relation += '&db=' + db + '&token=' + token + '&die_save_pos=0'; link_relation += Get_url_pos(); makeRequest('pmd_relation_upd.php', link_relation);}function VisibleTab(id,t_n){ if(id.checked)document.getElementById(t_n).style.visibility = 'visible'; else document.getElementById(t_n).style.visibility = 'hidden'; Re_load();}function Hide_tab_all(id_this) // max/min all tables{ if(id_this.alt == 'v') { id_this.alt='>';id_this.src="pmd/images/rightarrow1.png"; } else { id_this.alt='v';id_this.src="pmd/images/downarrow1.png"; } var E = document.form1; for (i=0;i<E.elements.length;i++) if(E.elements[i].type=="checkbox" && E.elements[i].id.substring( 0 , 10) == 'check_vis_') { if(id_this.alt == 'v') { E.elements[i].checked = true; document.getElementById(E.elements[i].value).style.visibility = 'visible';} else { E.elements[i].checked = false; document.getElementById(E.elements[i].value).style.visibility = 'hidden';} } Re_load();}function in_array_k(x,m){ var b=0; for (u in m) if(x == u){ b=1; break; } return b;}function No_have_constr(id_this) { var a = new Array(); for (K in contr) for (key in contr[K]) // contr name for (key2 in contr[K][key]) // table name for (key3 in contr[K][key][key2]) // field name a[key2]=a[contr[K][key][key2][key3][0]]=1; // exist constr if(id_this.alt == 'v') { id_this.alt='>';id_this.src="pmd/images/rightarrow2.png"; } else { id_this.alt='v';id_this.src="pmd/images/downarrow2.png"; } var E = document.form1; for (i=0;i<E.elements.length;i++) if(E.elements[i].type=="checkbox" && E.elements[i].id.substring(0, 10) == 'check_vis_') { if(!in_array_k(E.elements[i].value,a)) if(id_this.alt == 'v') { E.elements[i].checked = true; document.getElementById(E.elements[i].value).style.visibility = 'visible';} else { E.elements[i].checked = false; document.getElementById(E.elements[i].value).style.visibility = 'hidden';} }}function Help(){ var WinHelp = window.open("pmd_help.php","wind1", "top=200,left=400,width=300,height=200,resizable=yes,scrollbars=yes,menubar=no");}function PDF_save(){ // var WinPDF = // window.open("pmd_pdf.php?token="+token+"&db="+db,"wind1", "top=200,left=200,width=200,height=100,resizable=yes,scrollbars=yes,menubar=no"); Save('pmd_pdf.php?token='+token+'&db='+db);}function General_scroll(){ /* if(!document.getElementById('show_relation_olways').checked) { document.getElementById("canvas").style.visibility = 'hidden'; clearTimeout(timeoutID); timeoutID = setTimeout(General_scroll_end,500); }*/ //if(timeoutID) clearTimeout(timeoutID); timeoutID = setTimeout ( function() { document.getElementById('top_menu').style.left = document.body.scrollLeft; document.getElementById('top_menu').style.top = document.body.scrollTop; document.getElementById('layer_menu').style.left = document.body.scrollLeft; document.getElementById('layer_menu').style.top = document.body.scrollTop + document.getElementById('top_menu').offsetHeight; } ,200 );} /*function General_scroll_end(){ // document.getElementById('layer_menu').style.left = document.body.scrollLeft;// document.getElementById('layer_menu').style.top = document.body.scrollTop + document.getElementById('top_menu').offsetHeight; //if(isIE) //{ // document.getElementById('layer_menu').style.left = document.body.scrollLeft; // document.getElementById('layer_menu').style.top = document.body.scrollTop + document.getElementById('top_menu').offsetHeight; //} document.getElementById("canvas").style.visibility = 'visible';}*/function Show_left_menu(id_this) // max/min all tables{ if(id_this.alt=="v") { document.getElementById("layer_menu").style.top = document.getElementById('top_menu').offsetHeight; document.getElementById("layer_menu").style.visibility = 'visible'; id_this.alt = ">"; id_this.src="pmd/images/uparrow2_m.png"; if(isIE) General_scroll(); } else { document.getElementById("layer_menu").style.top = -1000; //fast scroll document.getElementById("layer_menu").style.visibility = 'hidden'; id_this.alt = "v"; id_this.src="pmd/images/downarrow2_m.png"; }}//----------------------------------------------------------------------------------------function Top_menu_right(id_this){ if(id_this.alt==">") { document.getElementById('top_menu').style.marginLeft = document.getElementById('top_menu').offsetWidth; // = 350 id_this.alt = "<"; id_this.src="pmd/images/2leftarrow_m.png"; } else { document.getElementById('top_menu').style.marginLeft = 0; id_this.alt = ">"; id_this.src="pmd/images/2rightarrow_m.png"; } }//----------------------------------------------------------------------------------------function Start_display_field(){ if( ON_relation ) return; if( !ON_display_field ) { ON_display_field = 1; document.getElementById('hint').innerHTML = LangChangeDisplay; document.getElementById('hint').style.visibility = "visible"; document.getElementById('display_field_button').className = 'M_butt_Selected_down';//'#FFEE99';gray #AAAAAA if(isIE) { // correct for IE document.getElementById('display_field_button').className = 'M_butt_Selected_down_IE'; } } else { document.getElementById('hint').innerHTML = ""; document.getElementById('hint').style.visibility = "hidden"; document.getElementById('display_field_button').className = 'M_butt'; ON_display_field = 0; }}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -