pmd/scripts/move.js

   1 /* vim: set expandtab sw=4 ts=4 sts=4: */
   2 /**
   3  * @version $Id$
   4  * @package phpMyAdmin-Designer
   5  */
   6
   7 /**
   8  * init
   9  */
  10 var dx, dy, dy2;
  11 var cur_click;
  12 // update in Main()
  13 var sm_x = 2, sm_y = 2;
  14 var sm_s           = 0;
  15 var sm_add         = 10;
  16 var s_left         = 0;
  17 var s_right        = 0;
  18 var ON_relation    = 0;
  19 var ON_grid        = 0;
  20 var ON_display_field = 0;
  21 // relation_style: 0 - angular 1 - direct
  22 var ON_angular_direct = 1;
  23 var click_field    = 0;
  24 var link_relation  = "";
  25 var id_hint;
  26 var canvas_width   = 0;
  27 var canvas_height  = 0;
  28 var osn_tab_width  = 0;
  29 var osn_tab_height = 0;
  30 var height_field   = 7;
  31 var Glob_X, Glob_Y;
  32 var timeoutID;
  33 var layer_menu_cur_click = 0;
  34 var step = 10;
  35 var old_class;
  36 var from_array = [];
  37 var downer;
  38
  39 //------------------------------------------------------------------------------
  40 //------------------------------------------------------------------------------
  41 //------------------------------------------------------------------------------
  42
  43
  44 //window.captureEvents(Event.MOUSEDOWN | Event.MOUSEUP);
  45 //---CROSS
  46 document.onmousedown = MouseDown;
  47 document.onmouseup   = MouseUp;
  48 document.onmousemove = MouseMove;
  49
  50 var isIE = document.all && !window.opera;
  51 var isNN = !document.all && document.getElementById;
  52 var isN4 = document.layers;
  53
  54 if (isIE) {
  55     window.onscroll = General_scroll;
  56     document.onselectstart = function () {return false;};
  57 }
  58
  59 //document.onmouseup = function(){General_scroll_end();}
  60 function MouseDown(e)
  61 {
  62     var offsetx, offsety;
  63     if (cur_click != null) {
  64         offsetx = isIE ? event.clientX + document.body.scrollLeft : e.pageX;
  65         offsety = isIE ? event.clientY + document.body.scrollTop : e.pageY;
  66         dx = offsetx - parseInt(cur_click.style.left);
  67         dy = offsety - parseInt(cur_click.style.top);
  68         //alert(" dx = " + dx + " dy = " +dy);
  69         document.getElementById("canvas").style.visibility = 'hidden';
  70         /*
  71         var left = parseInt(cur_click.style.left);
  72         var top  = parseInt(cur_click.style.top);
  73         dx = e.pageX - left;
  74         dy = e.pageY - top;
  75
  76         alert(" dx = " + dx + " dy = " +dy);
  77         */
  78         cur_click.style.zIndex = 2;
  79     }
  80     if (layer_menu_cur_click) {
  81         offsetx = isIE ? event.clientX + document.body.scrollLeft : e.pageX;
  82         dx = offsetx - parseInt(document.getElementById("layer_menu").style.width);
  83     }
  84 }
  85
  86 function MouseMove(e)
  87 {
  88     //Glob_X = e.pageX;
  89     //Glob_Y = e.pageY;
  90     Glob_X = isIE ? event.clientX + document.body.scrollLeft : e.pageX;
  91     Glob_Y = isIE ? event.clientY + document.body.scrollTop : e.pageY;
  92
  93     //mouseX = (bw.ns4||bw.ns6)? e.pageX: bw.ie&&bw.win&&!bw.ie4? (event.clientX-2)+document.body.scrollLeft : event.clientX+document.body.scrollLeft;
  94     //mouseY = (bw.ns4||bw.ns6)? e.pageY: bw.ie&&bw.win&&!bw.ie4? (event.clientY-2)+document.body.scrollTop : event.clientY+document.body.scrollTop;
  95
  96     //window.status = "X = "+ Glob_X + " Y = "+ Glob_Y;
  97
  98     if (cur_click != null) {
  99         var mGx = Glob_X - dx;
 100         var mGy = Glob_Y - dy;
 101         mGx = mGx > 0 ? mGx : 0;
 102         mGy = mGy > 0 ? mGy : 0;
 103
 104         if (ON_grid) {
 105             mGx = mGx % step < step / 2 ? mGx - mGx % step : mGx - mGx % step + step;
 106             mGy = mGy % step < step / 2 ? mGy - mGy % step : mGy - mGy % step + step;
 107         }
 108
 109         cur_click.style.left = mGx + 'px';
 110         cur_click.style.top  = mGy + 'px';
 111     }
 112
 113     if (ON_relation || ON_display_field) {
 114         document.getElementById('hint').style.left = (Glob_X + 20) + 'px';
 115         document.getElementById('hint').style.top  = (Glob_Y + 20) + 'px';
 116     }
 117
 118     if (layer_menu_cur_click) {
 119         document.getElementById("layer_menu").style.width = ((Glob_X - dx) >= 150 ? Glob_X - dx : 150) + 'px';
 120         //document.getElementById("layer_menu").style.height = Glob_Y - dy>=200?Glob_Y - dy:200;
 121         //document.getElementById("id_scroll_tab").style.height = Glob_Y - dy2;
 122     }
 123 }
 124
 125 function MouseUp(e)
 126 {
 127     if (cur_click != null) {
 128         document.getElementById("canvas").style.visibility = 'visible';
 129         Re_load();
 130         cur_click.style.zIndex = 1;
 131         cur_click = null;
 132     }
 133     layer_menu_cur_click = 0;
 134     //window.releaseEvents(Event.MOUSEMOVE);
 135 }
 136 //------------------------------------------------------------------------------
 137 //------------------------------------------------------------------------------
 138 //------------------------------------------------------------------------------
 139
 140
 141 //function ToInt(s)
 142 //{
 143 //    return s.substring(0,s.length-2)*1; //re = /(\d+)\w*/; newstr = str.replace(re, "$1");
 144 //}
 145
 146 function Canvas_pos()
 147 {
 148     canvas_width  = document.getElementById('canvas').width  = osn_tab_width  - 3;
 149     canvas_height = document.getElementById('canvas').height = osn_tab_height - 3;
 150
 151     if (isIE) {
 152         document.getElementById('canvas').style.width  = ((osn_tab_width  - 3)?(osn_tab_width  - 3):0) + 'px';
 153         document.getElementById('canvas').style.height = ((osn_tab_height - 3)?(osn_tab_height - 3):0) + 'px';
 154     }
 155 }
 156
 157 function Osn_tab_pos()
 158 {
 159     osn_tab_width  = parseInt(document.getElementById('osn_tab').style.width);
 160     osn_tab_height = parseInt(document.getElementById('osn_tab').style.height);
 161 }
 162
 163
 164 function Main()
 165 {
 166     //alert( document.getElementById('osn_tab').offsetTop);
 167     //---CROSS
 168     if (isIE) {
 169         document.getElementById('top_menu').style.position = 'absolute';
 170         document.getElementById('layer_menu').style.position = 'absolute';
 171     }
 172
 173     document.getElementById("layer_menu").style.top = -1000 + 'px'; //fast scroll
 174     sm_x += document.getElementById('osn_tab').offsetLeft;
 175     sm_y += document.getElementById('osn_tab').offsetTop;
 176     Osn_tab_pos();
 177     Canvas_pos();
 178     Small_tab_refresh();
 179     Re_load();
 180     id_hint = document.getElementById('hint');
 181     if (isIE) {
 182         General_scroll();
 183     }
 184 }
 185
 186
 187 //-------------------------------- new -----------------------------------------
 188 function Rezize_osn_tab()
 189 {
 190     var max_X = 0;
 191     var max_Y = 0;
 192     for (key in j_tabs) {
 193         var k_x = parseInt(document.getElementById(key).style.left) + document.getElementById(key).offsetWidth;
 194         var k_y = parseInt(document.getElementById(key).style.top) + document.getElementById(key).offsetHeight;
 195         max_X = max_X < k_x ? k_x : max_X;
 196         max_Y = max_Y < k_y ? k_y : max_Y;
 197     }
 198
 199     osn_tab_width  = max_X + 50;
 200     osn_tab_height = max_Y + 50;
 201     Canvas_pos();
 202     document.getElementById('osn_tab').style.width = osn_tab_width + 'px';
 203     document.getElementById('osn_tab').style.height = osn_tab_height + 'px';
 204 }
 205 //------------------------------------------------------------------------------
 206
 207 /**
 208  * refreshes display, must be called after state changes
 209  */
 210 function Re_load()
 211 {
 212     Rezize_osn_tab();
 213     var n;
 214     var x1;
 215     var x2;
 216     var a = new Array();
 217     Clear();
 218     for (K in contr)
 219         for (key in contr[K])                     // contr name
 220             for (key2 in contr[K][key])           // table name
 221                 for (key3 in contr[K][key][key2]) // field name
 222                 {
 223                     if (!document.getElementById("check_vis_" + key2).checked ||
 224                         !document.getElementById("check_vis_" + contr[K][key][key2][key3][0]).checked) {
 225                         // if hide
 226                         continue;
 227                     }
 228                     var x1_left  = document.getElementById(key2).offsetLeft+1;
 229                     var x1_right = x1_left + document.getElementById(key2).offsetWidth;
 230                     var x2_left  = document.getElementById(contr[K][key][key2][key3][0]).offsetLeft;
 231                     var x2_right = x2_left + document.getElementById(contr[K][key][key2][key3][0]).offsetWidth;
 232                     a[0] = Math.abs(x1_left - x2_left);
 233                     a[1] = Math.abs(x1_left - x2_right);
 234                     a[2] = Math.abs(x1_right - x2_left);
 235                     a[3] = Math.abs(x1_right - x2_right);
 236                     n = s_left = s_right = 0;
 237                     for (var i = 1; i < 4; i++) {
 238                         if (a[n] > a[i]) {
 239                             n = i;
 240                         }
 241                     }
 242                     if (n == 1) {
 243                         x1 = x1_left - sm_s;
 244                         x2 = x2_right + sm_s;
 245                         if (x1 < x2) {
 246                             n = 0;
 247                         }
 248                     }
 249                     if (n == 2) {
 250                         x1 = x1_right + sm_s;
 251                         x2 = x2_left - sm_s;
 252                         if (x1 > x2) {
 253                             n = 0;
 254                         }
 255                     }
 256                     if (n == 3) {
 257                         x1 = x1_right + sm_s;
 258                         x2 = x2_right + sm_s;
 259                         s_right = 1;
 260                     }
 261                     if (n == 0) {
 262                         x1 = x1_left - sm_s;
 263                         x2 = x2_left - sm_s;
 264                         s_left = 1;
 265                     }
 266                     //alert(key2 + "." + key3);
 267
 268                     var row_offset_top = 0;
 269                     //alert('id_tbody_' + key2);
 270                     //alert(document.getElementById('id_hide_tbody_' + key2));
 271                     var tab_hide_button = document.getElementById('id_hide_tbody_' + key2);
 272
 273                     //alert(tab_hide_button.innerHTML);
 274                     if (tab_hide_button.innerHTML == 'v') {
 275                         row_offset_top = document.getElementById(key2 + "." + key3).offsetTop;
 276                     }
 277
 278                     var y1 = document.getElementById(key2).offsetTop
 279                          + row_offset_top
 280                          + height_field;
 281                     //alert(1);
 282
 283                     row_offset_top = 0;
 284                     var tab_hide_button = document.getElementById('id_hide_tbody_' + contr[K][key][key2][key3][0]);
 285                     if (tab_hide_button.innerHTML == 'v') {
 286                         row_offset_top = document.getElementById(contr[K][key][key2][key3][0]
 287                             + '.' + contr[K][key][key2][key3][1]).offsetTop;
 288                     }
 289
 290                     var y2 =
 291                           document.getElementById(contr[K][key][key2][key3][0]).offsetTop
 292                         + row_offset_top
 293                         + height_field;
 294
 295                     //alert(y1 + ' - ' + key2 + "." + key3);
 296                     Line0(x1 - sm_x, y1 - sm_y, x2 - sm_x, y2 - sm_y, getColorByTarget( contr[K][key][key2][key3][0]+'.'+contr[K][key][key2][key3][1] ) );
 297                 }
 298 }
 299
 300 /**
 301  * draws a line from x1:y1 to x2:y2 with color
 302  */
 303 function Line(x1, y1, x2, y2, color_line)
 304 {
 305     var canvas = document.getElementById("canvas");
 306     var ctx    = canvas.getContext("2d");
 307     ctx.strokeStyle = color_line;
 308     ctx.lineWidth = 1;
 309     ctx.beginPath();
 310     ctx.moveTo(x1, y1);
 311     ctx.lineTo(x2, y2);
 312     ctx.stroke();
 313 }
 314
 315 /**
 316  * draws a relation/constraint line, whether angular or not
 317  */
 318 function Line0(x1, y1, x2, y2, color_line)
 319 {
 320     Circle(x1, y1, 3, 3, color_line);
 321     Rect(x2 - 1, y2 - 2, 4, 4, color_line);
 322
 323     if (ON_angular_direct) {
 324         Line2(x1, y1, x2, y2, color_line);
 325     } else {
 326         Line3(x1, y1, x2, y2, color_line);
 327     }
 328 }
 329
 330 /**
 331  * draws a angualr relation/constraint line
 332  */
 333 function Line2(x1, y1, x2, y2, color_line)
 334 {
 335     var x1_ = x1;
 336     var x2_ = x2;
 337
 338     if (s_right) {
 339         x1_ += sm_add;
 340         x2_ += sm_add;
 341     } else if (s_left) {
 342         x1_ -= sm_add;
 343         x2_ -= sm_add;
 344     } else if (x1 < x2) {
 345         x1_ += sm_add;
 346         x2_ -= sm_add;
 347     } else {
 348         x1_ -= sm_add;
 349         x2_ += sm_add;
 350     }
 351
 352     Line(x1, y1, x1_, y1, color_line);
 353     Line(x2, y2, x2_, y2, color_line);
 354     Line(x1_, y1, x2_, y2, color_line);
 355 }
 356
 357 /**
 358  * draws a relation/constraint line
 359  */
 360 function Line3(x1, y1, x2, y2, color_line)
 361 {
 362     var x1_ = x1;
 363     var x2_ = x2;
 364
 365     if (s_right) {
 366         if (x1 < x2) {
 367             x1_ += x2 - x1 + sm_add;
 368             x2_ += sm_add;
 369         } else {
 370             x2_ += x1 - x2 + sm_add;
 371             x1_ += sm_add;
 372         }
 373
 374         Line(x1, y1, x1_, y1, color_line);
 375         Line(x2, y2, x2_, y2, color_line);
 376         Line(x1_, y1, x2_, y2, color_line);
 377         return;
 378     }
 379     if (s_left) {
 380         if (x1 < x2) {
 381             x2_ -= x2 - x1 + sm_add;
 382             x1_ -= sm_add;
 383         } else {
 384             x1_ -= x1 - x2 + sm_add;
 385             x2_ -= sm_add;
 386         }
 387
 388         Line(x1, y1, x1_, y1, color_line);
 389         Line(x2, y2, x2_, y2, color_line);
 390         Line(x1_, y1, x2_, y2, color_line);
 391         return;
 392     }
 393
 394     var x_s = (x1 + x2) / 2;
 395     Line(x1, y1, x_s, y1, color_line);
 396     Line(x_s, y2, x2, y2, color_line);
 397     Line(x_s, y1, x_s, y2, color_line);
 398 }
 399
 400 function Circle(x, y, r, w, color)
 401 {
 402     var ctx = document.getElementById('canvas').getContext('2d');
 403     ctx.beginPath();
 404     ctx.moveTo(x, y);
 405     ctx.lineWidth = w;
 406     ctx.strokeStyle = color;
 407     ctx.arc(x, y, r, 0, 2 * Math.PI, true);
 408     ctx.stroke();
 409 }
 410
 411 function Clear()
 412 {
 413     var canvas = document.getElementById("canvas");
 414     var ctx    = canvas.getContext("2d");
 415     ctx.clearRect(0, 0, canvas_width, canvas_height);
 416 }
 417
 418 function Rect(x1, y1, w, h, color)
 419 {
 420     var ctx = document.getElementById('canvas').getContext('2d');
 421     ctx.fillStyle = color;
 422     ctx.fillRect(x1, y1, w, h);
 423 }
 424
 425 //------------------------------ SAVE ------------------------------------------
 426 function Save(url) // (del?) no for pdf
 427 {
 428     for (key in j_tabs) {
 429         document.getElementById('t_x_' + key + '_').value = parseInt(document.getElementById(key).style.left);
 430         document.getElementById('t_y_' + key + '_').value = parseInt(document.getElementById(key).style.top);
 431         document.getElementById('t_v_' + key + '_').value = document.getElementById('id_tbody_' + key).style.display == 'none' ? 0 : 1;
 432         document.getElementById('t_h_' + key + '_').value = document.getElementById('check_vis_' + key).checked ? 1 : 0;
 433     }
 434     document.form1.action = url;
 435     document.form1.submit();
 436 }
 437
 438 function Get_url_pos()
 439 {
 440     var poststr = '';
 441     for (key in j_tabs) {
 442         poststr += '&t_x[' + key + ']=' + parseInt(document.getElementById(key).style.left);
 443         poststr += '&t_y[' + key + ']=' + parseInt(document.getElementById(key).style.top);
 444         poststr += '&t_v[' + key + ']=' + (document.getElementById('id_tbody_' + key).style.display == 'none' ? 0 : 1);
 445         poststr += '&t_h[' + key + ']=' + (document.getElementById('check_vis_' + key).checked ? 1 : 0);
 446     }
 447     return poststr;
 448 }
 449
 450 function Save2()
 451 {
 452     var poststr = 'IS_AJAX=1&server='+server+'&db=' + db + '&token=' + token + '&die_save_pos=1';
 453     poststr += Get_url_pos();
 454     makeRequest('pmd_save_pos.php', poststr);
 455 }
 456
 457 function Grid()
 458 {
 459     if (!ON_grid) {
 460         ON_grid = 1;
 461         document.getElementById('grid_button').className = 'M_butt_Selected_down';
 462     } else {
 463         document.getElementById('grid_button').className = 'M_butt';
 464         ON_grid = 0;
 465     }
 466 }
 467
 468 function Angular_direct()
 469 {
 470     if (ON_angular_direct) {
 471         ON_angular_direct = 0;
 472         document.getElementById('angular_direct_button').className = 'M_butt_Selected_down';
 473     } else {
 474         ON_angular_direct = 1;
 475         document.getElementById('angular_direct_button').className = 'M_butt';
 476     }
 477     Re_load();
 478 }
 479 //++++++++++++++++++++++++++++++ RELATION ++++++++++++++++++++++++++++++++++++++
 480 function Start_relation()
 481 {
 482     if (ON_display_field) {
 483         return;
 484     }
 485
 486     if (!ON_relation) {
 487         document.getElementById('foreign_relation').style.display = '';
 488         ON_relation = 1;
 489         document.getElementById('hint').innerHTML = PMA_messages['strSelectReferencedKey'];
 490         document.getElementById('hint').style.visibility = "visible";
 491         document.getElementById('rel_button').className = 'M_butt_Selected_down';
 492     } else {
 493         document.getElementById('hint').innerHTML = "";
 494         document.getElementById('hint').style.visibility = "hidden";
 495         document.getElementById('rel_button').className = 'M_butt';
 496         click_field = 0;
 497         ON_relation = 0;
 498     }
 499 }
 500
 501 function Click_field(T, f, PK) // table field
 502 {
 503     if (ON_relation) {
 504         if (!click_field) {
 505             //.style.display=='none'        .style.visibility = "hidden"
 506             if (!PK) {
 507                 alert(PMA_messages['strPleaseSelectPrimaryOrUniqueKey']);
 508                 return;// 0;
 509             }//PK
 510             if (j_tabs[db + '.' + T] != '1') {
 511                 document.getElementById('foreign_relation').style.display = 'none';
 512             }
 513             click_field = 1;
 514             link_relation = "T1=" + T + "&F1=" + f;
 515             document.getElementById('hint').innerHTML = PMA_messages['strSelectForeignKey'];
 516         } else {
 517             Start_relation(); // hidden hint...
 518             if (j_tabs[db + '.' + T] != '1' || !PK) {
 519                 document.getElementById('foreign_relation').style.display = 'none';
 520             }
 521             var left = Glob_X - (document.getElementById('layer_new_relation').offsetWidth>>1);
 522             document.getElementById('layer_new_relation').style.left = left + 'px';
 523             var top = Glob_Y - document.getElementById('layer_new_relation').offsetHeight - 10;
 524             document.getElementById('layer_new_relation').style.top  = top + 'px';
 525             document.getElementById('layer_new_relation').style.visibility = "visible";
 526             link_relation += '&T2=' + T + '&F2=' + f;
 527         }
 528     }
 529
 530     if (ON_display_field) {
 531         // if is display field
 532         if (display_field[T] == f) {
 533             //alert(T);
 534             //s = '';for(k in display_field)s += k + ' = ' + display_field[k] + ',';alert(s);
 535             old_class = 'tab_field';
 536             //display_field.splice(T, 1);
 537             delete display_field[T];
 538             //s = '';for(k in display_field)s += k + ' = ' + display_field[k] + ', ';alert(s);
 539             //n = 0;for(k in display_field)n++;alert(n);
 540         } else {
 541             old_class = 'tab_field_3';
 542             if (display_field[T]) {
 543                 document.getElementById('id_tr_' + T + '.' + display_field[T]).className = 'tab_field';
 544                 //display_field.splice(T, 1);
 545                 delete display_field[T];
 546             }
 547             display_field[T] = f;
 548         }
 549         ON_display_field = 0;
 550         document.getElementById('hint').innerHTML = "";
 551         document.getElementById('hint').style.visibility = "hidden";
 552         document.getElementById('display_field_button').className = 'M_butt';
 553         makeRequest('pmd_display_field.php', 'T=' + T + '&F=' + f + '&server=' + server + '&db=' + db + '&token=' + token);
 554     }
 555 }
 556
 557 function New_relation()
 558 {
 559     document.getElementById('layer_new_relation').style.visibility = 'hidden';
 560     link_relation += '&server=' + server + '&db=' + db + '&token=' + token + '&die_save_pos=0';
 561     link_relation += '&on_delete=' + document.getElementById('on_delete').value + '&on_update=' + document.getElementById('on_update').value;
 562     link_relation += Get_url_pos();
 563
 564     //alert(link_relation);
 565     makeRequest('pmd_relation_new.php', link_relation);
 566 }
 567
 568 //-------------------------- create tables -------------------------------------
 569
 570 function Start_table_new()
 571 {
 572     window.location.href = 'db_operations.php?server=' + server + '&db=' + db + '&token=' + token;
 573 }
 574
 575 function Start_tab_upd(table)
 576 {
 577     window.location.href = 'tbl_structure.php?server=' + server + '&db=' + db + '&token=' + token + '&table=' + table;
 578 }
 579 //--------------------------- hide tables --------------------------------------
 580
 581 function Small_tab_all(id_this) // max/min all tables
 582 {
 583     if (id_this.alt == "v") {
 584         for (key in j_tabs) {
 585             if (document.getElementById('id_hide_tbody_'+key).innerHTML == "v") {
 586                 Small_tab(key, 0);
 587             }
 588         }
 589         id_this.alt = ">";
 590         id_this.src = "pmd/images/rightarrow1.png";
 591     } else {
 592         for (key in j_tabs) {
 593             if (document.getElementById('id_hide_tbody_'+key).innerHTML != "v") {
 594                 Small_tab(key, 0);
 595             }
 596         }
 597         id_this.alt = "v";
 598         id_this.src = "pmd/images/downarrow1.png";
 599     }
 600     Re_load();
 601 }
 602
 603 function Small_tab_invert() // invert max/min all tables
 604 {
 605     for (key in j_tabs) {
 606         Small_tab(key, 0);
 607     }
 608     Re_load();
 609 }
 610
 611 function Small_tab_refresh()
 612 {
 613      for (key in j_tabs) {
 614          if(document.getElementById('id_hide_tbody_'+key).innerHTML != "v") {
 615              Small_tab(key, 0);
 616              Small_tab(key, 0);
 617          }
 618      }
 619 }
 620
 621 function Small_tab(t, re_load)
 622 {
 623     var id      = document.getElementById('id_tbody_' + t);
 624     var id_this = document.getElementById('id_hide_tbody_' + t);
 625     var id_t    = document.getElementById(t);
 626     id_t.style.width = id_t.offsetWidth + 'px';
 627     if (id_this.innerHTML == "v") {
 628         //---CROSS
 629         id.style.display = 'none';
 630         id_this.innerHTML = '>';
 631     } else {
 632         id.style.display = '';
 633         id_this.innerHTML = 'v';
 634     }
 635     if (re_load) {
 636         Re_load();
 637     }
 638 }
 639 //------------------------------------------------------------------------------
 640 function Select_tab(t)
 641 {
 642     var id_zag = document.getElementById('id_zag_' + t);
 643     if (id_zag.className != 'tab_zag_3') {
 644         document.getElementById('id_zag_' + t).className = 'tab_zag_2';
 645     } else {
 646         document.getElementById('id_zag_' + t).className = 'tab_zag';
 647     }
 648     //----------
 649     var id_t = document.getElementById(t);
 650     window.scrollTo(parseInt(id_t.style.left) - 300, parseInt(id_t.style.top) - 300);
 651     setTimeout(function(){document.getElementById('id_zag_' + t).className = 'tab_zag';}, 800);
 652 }
 653 //------------------------------------------------------------------------------
 654
 655 function Canvas_click(id)
 656 {
 657     var n = 0;
 658     var relation_name = 0;
 659     var selected = 0;
 660     var a = new Array();
 661     var Key0, Key1, Key2, Key3, Key, x1, x2;
 662     Clear();
 663     for (K in contr)
 664         for (key in contr[K])
 665             for (key2 in contr[K][key])
 666                 for (key3 in contr[K][key][key2]) {
 667                     if (!document.getElementById("check_vis_"+key2).checked ||
 668                         !document.getElementById("check_vis_"+contr[K][key][key2][key3][0]).checked) continue; // if hide
 669                     var x1_left  = document.getElementById(key2).offsetLeft + 1;//document.getElementById(key2+"."+key3).offsetLeft;
 670                     var x1_right = x1_left + document.getElementById(key2).offsetWidth;
 671                     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
 672                     var x2_right = x2_left + document.getElementById(contr[K][key][key2][key3][0]).offsetWidth;
 673                     a[0] = Math.abs(x1_left - x2_left);
 674                     a[1] = Math.abs(x1_left - x2_right);
 675                     a[2] = Math.abs(x1_right - x2_left);
 676                     a[3] = Math.abs(x1_right - x2_right);
 677                     n = s_left = s_right = 0;
 678                     for (var i = 1; i < 4; i++) {
 679                         if (a[n] > a[i]) {
 680                             n = i;
 681                         }
 682                     }
 683                     if (n == 1) {
 684                         x1 = x1_left - sm_s;
 685                         x2 = x2_right + sm_s;
 686                         if (x1 < x2) {
 687                             n = 0;
 688                         }
 689                     }
 690                     if (n == 2) {
 691                         x1 = x1_right + sm_s;
 692                         x2 = x2_left - sm_s;
 693                         if (x1 > x2) {
 694                             n = 0;
 695                         }
 696                     }
 697                     if (n == 3) {
 698                         x1 = x1_right + sm_s;
 699                         x2 = x2_right + sm_s;
 700                         s_right = 1;
 701                     }
 702                     if (n == 0) {
 703                         x1 = x1_left - sm_s;
 704                         x2 = x2_left - sm_s;
 705                         s_left    = 1;
 706                     }
 707
 708                     var y1 = document.getElementById(key2).offsetTop + document.getElementById(key2+"."+key3).offsetTop + height_field;
 709                     var y2 = document.getElementById(contr[K][key][key2][key3][0]).offsetTop +
 710                                      document.getElementById(contr[K][key][key2][key3][0]+"."+contr[K][key][key2][key3][1]).offsetTop + height_field;
 711                     if (!selected && Glob_X > x1 - 10 && Glob_X < x1 + 10 && Glob_Y > y1 - 7 && Glob_Y < y1 + 7) {
 712                         Line0(x1 - sm_x, y1 - sm_y, x2 - sm_x, y2 - sm_y, "rgba(255,0,0,1)");
 713                         selected = 1; // Rect(x1-sm_x,y1-sm_y,10,10,"rgba(0,255,0,1)");
 714                         relation_name = key; //
 715                         Key0 = contr[K][key][key2][key3][0];
 716                         Key1 = contr[K][key][key2][key3][1];
 717                         Key2 = key2; Key3 = key3;
 718                         Key = K;
 719                     } else {
 720                         Line0(x1 - sm_x, y1 - sm_y, x2 - sm_x, y2 - sm_y, getColorByTarget( contr[K][key][key2][key3][0]+'.'+contr[K][key][key2][key3][1] ));
 721                     }
 722                 }
 723     if (selected) {
 724         // select relations
 725         //alert(Key0+' - '+Key1+' - '+Key2+' - '+Key3);
 726         var left = Glob_X - (document.getElementById('layer_upd_relation').offsetWidth>>1);
 727         document.getElementById('layer_upd_relation').style.left = left + 'px';
 728         var top = Glob_Y - document.getElementById('layer_upd_relation').offsetHeight - 10;
 729         document.getElementById('layer_upd_relation').style.top = top + 'px';
 730         document.getElementById('layer_upd_relation').style.visibility = 'visible';
 731         link_relation = 'T1=' + Key0 + '&F1=' + Key1 + '&T2=' + Key2 + '&F2=' + Key3 + '&K=' + Key;
 732     }
 733 }
 734
 735 function Upd_relation()
 736 {
 737     document.getElementById('layer_upd_relation').style.visibility = 'hidden';
 738     link_relation += '&server=' + server + '&db=' + db + '&token=' + token + '&die_save_pos=0';
 739     link_relation += Get_url_pos();
 740     makeRequest('pmd_relation_upd.php', link_relation);
 741 }
 742
 743 function VisibleTab(id, t_n)
 744 {
 745     if (id.checked) {
 746         document.getElementById(t_n).style.visibility = 'visible';
 747     } else {
 748         document.getElementById(t_n).style.visibility = 'hidden';
 749     }
 750     Re_load();
 751 }
 752
 753 function Hide_tab_all(id_this) // max/min all tables
 754 {
 755     if (id_this.alt == 'v') {
 756         id_this.alt = '>';
 757         id_this.src = "pmd/images/rightarrow1.png";
 758     } else {
 759         id_this.alt = 'v';
 760         id_this.src = "pmd/images/downarrow1.png";
 761     }
 762     var E = document.form1;
 763     for (i = 0; i < E.elements.length; i++) {
 764         if (E.elements[i].type == "checkbox" && E.elements[i].id.substring(0, 10) == 'check_vis_') {
 765             if (id_this.alt == 'v') {
 766                 E.elements[i].checked = true;
 767                 document.getElementById(E.elements[i].value).style.visibility = 'visible';
 768             } else {
 769                 E.elements[i].checked = false;
 770                 document.getElementById(E.elements[i].value).style.visibility = 'hidden';
 771             }
 772         }
 773     }
 774     Re_load();
 775 }
 776
 777 function in_array_k(x, m)
 778 {
 779     var b = 0;
 780     for (u in m) {
 781         if (x == u) {
 782             b=1;
 783             break;
 784         }
 785     }
 786     return b;
 787 }
 788
 789 function No_have_constr(id_this)
 790 {
 791     var a = new Array();
 792     for (K in contr)
 793         for (key in contr[K])                     // contr name
 794             for (key2 in contr[K][key])           // table name
 795                 for (key3 in contr[K][key][key2]) // field name
 796                     a[key2] = a[contr[K][key][key2][key3][0]] = 1; // exist constr
 797
 798
 799     if (id_this.alt == 'v') {
 800         id_this.alt = '>';
 801         id_this.src = "pmd/images/rightarrow2.png";
 802     } else {
 803         id_this.alt = 'v';
 804         id_this.src = "pmd/images/downarrow2.png";
 805     }
 806     var E = document.form1;
 807     for (i = 0; i < E.elements.length; i++) {
 808         if (E.elements[i].type == "checkbox" && E.elements[i].id.substring(0, 10) == 'check_vis_')
 809         {
 810             if (!in_array_k(E.elements[i].value, a))
 811             if (id_this.alt == 'v') {
 812                 E.elements[i].checked = true;
 813                 document.getElementById(E.elements[i].value).style.visibility = 'visible';
 814             } else {
 815                 E.elements[i].checked = false;
 816                 document.getElementById(E.elements[i].value).style.visibility = 'hidden';
 817             }
 818         }
 819     }
 820 }
 821
 822 function Help()
 823 {
 824     var WinHelp = window.open("pmd_help.php", "wind1", "top=200,left=400,width=300,height=200,resizable=yes,scrollbars=yes,menubar=no");
 825 }
 826
 827 function PDF_save()
 828 {
 829     // var WinPDF =
 830     // window.open("pmd_pdf.php?token="+token+"&db="+db,"wind1", "top=200,left=200,width=200,height=100,resizable=yes,scrollbars=yes,menubar=no");
 831     Save('pmd_pdf.php?server=' + server + '&token=' + token + '&db=' + db);
 832 }
 833
 834 function General_scroll()
 835 {
 836     /*
 837     if (!document.getElementById('show_relation_olways').checked) {
 838         document.getElementById("canvas").style.visibility = 'hidden';
 839         clearTimeout(timeoutID);
 840         timeoutID = setTimeout(General_scroll_end, 500);
 841     }
 842     */
 843     //if (timeoutID)
 844     clearTimeout(timeoutID);
 845     timeoutID = setTimeout
 846     (
 847         function()
 848         {
 849             document.getElementById('top_menu').style.left = document.body.scrollLeft + 'px';
 850             document.getElementById('top_menu').style.top  = document.body.scrollTop + 'px';
 851             document.getElementById('layer_menu').style.left = document.body.scrollLeft + 'px';
 852             document.getElementById('layer_menu').style.top  = (document.body.scrollTop + document.getElementById('top_menu').offsetHeight) + 'px';
 853         }
 854         ,200
 855     );
 856 }
 857
 858 /*
 859 function General_scroll_end()
 860 {
 861     document.getElementById('layer_menu').style.left = document.body.scrollLeft;
 862     document.getElementById('layer_menu').style.top  = document.body.scrollTop + document.getElementById('top_menu').offsetHeight;
 863     if (isIE) {
 864         document.getElementById('layer_menu').style.left = document.body.scrollLeft;
 865         document.getElementById('layer_menu').style.top  = document.body.scrollTop + document.getElementById('top_menu').offsetHeight;
 866     }
 867     document.getElementById("canvas").style.visibility = 'visible';
 868 }
 869 */
 870
 871 function Show_left_menu(id_this) // max/min all tables
 872 {
 873     if (id_this.alt == "v") {
 874         document.getElementById("layer_menu").style.top = document.getElementById('top_menu').offsetHeight + 'px';
 875         document.getElementById("layer_menu").style.visibility = 'visible';
 876         id_this.alt = ">";
 877         id_this.src = "pmd/images/uparrow2_m.png";
 878         if (isIE) {
 879             General_scroll();
 880         }
 881     } else {
 882         document.getElementById("layer_menu").style.top = -1000 + 'px'; //fast scroll
 883         document.getElementById("layer_menu").style.visibility = 'hidden';
 884         id_this.alt = "v";
 885         id_this.src = "pmd/images/downarrow2_m.png";
 886     }
 887 }
 888 //------------------------------------------------------------------------------
 889 function Top_menu_right(id_this)
 890 {
 891     if (id_this.alt == ">") {
 892         document.getElementById('top_menu').style.marginLeft = document.getElementById('top_menu').offsetWidth + 'px'; // = 350
 893         id_this.alt = "<";
 894         id_this.src = "pmd/images/2leftarrow_m.png";
 895     } else {
 896         document.getElementById('top_menu').style.marginLeft = 0;
 897         id_this.alt = ">";
 898         id_this.src = "pmd/images/2rightarrow_m.png";
 899     }
 900 }
 901 //------------------------------------------------------------------------------
 902 function Start_display_field()
 903 {
 904     if (ON_relation) {
 905         return;
 906     }
 907     if (!ON_display_field) {
 908         ON_display_field = 1;
 909         document.getElementById('hint').innerHTML = PMA_messages['strChangeDisplay'];
 910         document.getElementById('hint').style.visibility = "visible";
 911         document.getElementById('display_field_button').className = 'M_butt_Selected_down';//'#FFEE99';gray #AAAAAA
 912
 913         if (isIE) { // correct for IE
 914             document.getElementById('display_field_button').className = 'M_butt_Selected_down_IE';
 915         }
 916     } else {
 917         document.getElementById('hint').innerHTML = "";
 918         document.getElementById('hint').style.visibility = "hidden";
 919         document.getElementById('display_field_button').className = 'M_butt';
 920         ON_display_field = 0;
 921     }
 922 }
 923 //------------------------------------------------------------------------------
 924 var TargetColors = new Array();
 925 function getColorByTarget( target )
 926 {
 927   var color = '';  //"rgba(0,100,150,1)";
 928
 929   for (i in TargetColors)
 930    if (TargetColors[i][0]==target) {
 931     color = TargetColors[i][1];
 932     break;
 933    }
 934
 935
 936   if (color.length==0)
 937   {
 938    var i = TargetColors.length+1;
 939    var d = i % 6;
 940    var j = (i - d) / 6;
 941    j = j % 4;
 942    j++;
 943    var color_case = new Array(
 944                         new Array(1, 0, 0),
 945                         new Array(0, 1, 0),
 946                         new Array(0, 0, 1),
 947                         new Array(1, 1, 0),
 948                         new Array(1, 0, 1),
 949                         new Array(0, 1, 1)
 950                         );
 951     var a = color_case[d][0];
 952     var b = color_case[d][1];
 953     var c = color_case[d][2];
 954     e = (1 - (j - 1) / 6);
 955
 956     var r = Math.round(a * 200 * e);
 957     var g = Math.round(b * 200 * e);
 958     var b = Math.round(c * 200 * e);
 959     var color = "rgba("+r+","+g+","+b+",1)";
 960
 961     TargetColors.push( new Array(target, color) );
 962
 963
 964   }
 965
 966   return color;
 967 }
 968
 969 function Click_option(id_this,column_name,table_name)
 970 {
 971     var left = Glob_X - (document.getElementById(id_this).offsetWidth>>1);
 972     document.getElementById(id_this).style.left = left + 'px';
 973     // var top = Glob_Y - document.getElementById(id_this).offsetHeight - 10;
 974     document.getElementById(id_this).style.top  = (screen.height / 4) + 'px';
 975     document.getElementById(id_this).style.visibility = "visible";
 976     document.getElementById('option_col_name').innerHTML = '<strong>Options For "' +column_name+ '" column</strong>';
 977     col_name = column_name;
 978     tab_name = table_name;
 979 }
 980
 981 function Close_option()
 982 {
 983     document.getElementById('pmd_optionse').style.visibility = "hidden";
 984 }
 985
 986 function Select_all(id_this,owner)
 987 {
 988     var parent= document.form1;
 989     downer =owner;
 990     var i;
 991     var tab = [];
 992     for(i = 0; i < parent.elements.length; i++) {
 993         if (parent.elements[i].type == "checkbox" && parent.elements[i].id.substring(0,(9 + id_this.length)) == 'select_' + id_this + '._') {
 994             if(document.getElementById('select_all_' + id_this).checked == true) {
 995                 parent.elements[i].checked = true;
 996                 parent.elements[i].disabled = true;
 997                 var temp = '`' + id_this.substring(owner.length +1) + '`.*';
 998            }
 999            else {
1000                parent.elements[i].checked = false;
1001                parent.elements[i].disabled = false;
1002            }
1003         }
1004     }
1005     if(document.getElementById('select_all_' + id_this).checked == true) {
1006         select_field.push('`' + id_this.substring(owner.length +1) + '`.*');
1007         tab = id_this.split(".");
1008         from_array.push(tab[1]);
1009     }
1010     else {
1011         for (i =0; i < select_field.length; i++) {
1012             if (select_field[i] == ('`' + id_this.substring(owner.length +1) + '`.*')) {
1013                 select_field.splice(i,1);
1014             }
1015         }
1016         for(k =0 ;k < from_array.length;k++){
1017             if(from_array[k] == id_this){
1018                 from_array.splice(k,1);
1019                 break;
1020             }
1021         }
1022     }
1023     Re_load();
1024 }
1025
1026 function Table_onover(id_this,val,buil)
1027 {
1028     if(!val) {
1029         document.getElementById("id_zag_" + id_this).className="tab_zag_2";
1030         if(buil) {
1031             document.getElementById("id_zag_" + id_this + "_2").className="tab_zag_2";
1032         }
1033     }
1034     else {
1035         document.getElementById("id_zag_" + id_this).className="tab_zag";
1036         if(buil) {
1037             document.getElementById("id_zag_" + id_this + "_2").className="tab_zag";
1038         }
1039     }
1040 }
1041
1042 /* This function stores selected column information in select_field[]
1043  * In case column is checked it add else it deletes
1044  *
1045  */
1046 function store_column(id_this,owner,col) {
1047     var i = 0;
1048     var k = 0;
1049     if (document.getElementById('select_' + owner + '.' + id_this + '._' + col).checked == true) {
1050         select_field.push('`' + id_this + '`.`' + col +'`');
1051         from_array.push(id_this);
1052     }
1053     else {
1054         for(i; i < select_field.length ;i++) {
1055             if (select_field[i] == ('`' + id_this + '`.`' + col +'`')) {
1056                 select_field.splice(i,1);
1057                 break;
1058             }
1059         }
1060         for(k =0 ;k < from_array.length;k++){
1061             if(from_array[k] == id_this){
1062                 from_array.splice(k,1);
1063                             break;
1064             }
1065         }
1066      }
1067 }
1068
1069 /**
1070  * This function builds object and adds them to history_array
1071  * first it does a few checks on each object, then makes an object(where,rename,groupby,aggregate,orderby)
1072  * then a new history object is made and finally all these history objects are addded to history_array[]
1073  *
1074  * @uses        where()
1075  * @uses        history()
1076  * @uses        aggregate()
1077  * @uses        rename()
1078  * @uses        panel()
1079  * @uses        display()
1080 **/
1081
1082 function add_object() {
1083     var rel = document.getElementById('rel_opt');
1084     var sum = 0;
1085     var init = history_array.length;
1086     if (rel.value != '--') {
1087         if (document.getElementById('Query').value == "") {
1088             document.getElementById('hint').innerHTML = "value/subQuery is empty" ;
1089             document.getElementById('hint').style.visibility = "visible";
1090             return;
1091         }
1092         var p = document.getElementById('Query');
1093         var where_obj = new where(rel.value,p.value);//make where object
1094         history_array.push(new history(col_name,where_obj,tab_name,h_tabs[downer + '.' + tab_name],"Where"));
1095         sum = sum + 1;
1096         rel.value = '--';
1097         p.value = "";
1098     }
1099     if (document.getElementById('new_name').value !="") {
1100         var rename_obj = new rename(document.getElementById('new_name').value);//make Rename object
1101         history_array.push(new history(col_name,rename_obj,tab_name,h_tabs[downer + '.' + tab_name],"Rename"));
1102         sum = sum + 1;
1103         document.getElementById('new_name').value = "" ;
1104     }
1105         if (document.getElementById('operator').value != '---') {
1106         var aggregate_obj = new aggregate(document.getElementById('operator').value) ;
1107         history_array.push(new history(col_name,aggregate_obj,tab_name,h_tabs[downer + '.' + tab_name],"Aggregate"));
1108         sum = sum + 1;
1109         document.getElementById('operator').value = '---';
1110                 //make aggregate operator
1111     }
1112     if (document.getElementById('groupby').checked == true ) {
1113         history_array.push(new history(col_name,'GroupBy',tab_name,h_tabs[downer + '.' +tab_name],"GroupBy"));
1114         sum = sum + 1;
1115         document.getElementById('groupby').checked = false;
1116         //make groupby
1117     }
1118     if (document.getElementById('h_rel_opt').value != '--') {
1119         if (document.getElementById('having').value == "") {
1120             document.getElementById('hint').innerHTML = "value/subQuery is empty" ;
1121             document.getElementById('hint').style.visibility = "visible";
1122            return;
1123         }
1124         var p = document.getElementById('having');
1125         var where_obj = new having(document.getElementById('h_rel_opt').value,p.value,document.getElementById('h_operator').value);//make where object
1126         history_array.push(new history(col_name,where_obj,tab_name,h_tabs[downer + '.' + tab_name],"Having"));
1127         sum = sum + 1;
1128         document.getElementById('h_rel_opt').value = '--';
1129         document.getElementById('h_operator').value = '---';
1130         p.value = ""; //make having
1131     }
1132     if (document.getElementById('orderby').checked == true) {
1133         history_array.push(new history(col_name,'OrderBy',tab_name,h_tabs[downer + '.' + tab_name],"OrderBy"));
1134         sum = sum + 1;
1135         document.getElementById('orderby').checked = false;
1136                 //make orderby
1137     }
1138     document.getElementById('hint').innerHTML = sum + "object created" ;
1139     document.getElementById('hint').style.visibility = "visible";
1140         //output sum new objects created
1141     var existingDiv = document.getElementById('ab');
1142     existingDiv.innerHTML = display(init,history_array.length);
1143     Close_option();
1144     panel(0);
1145 }