55 * @requires move.js
66 */
77
8- /* global contr */ // js/designer/init.js
9- /* global fromArray:writable */ // js/designer/move.js
108/* global themeImagePath */ // templates/javascript/variables.twig
119
1210var DesignerHistory = { } ;
11+ window . DesignerHistory = DesignerHistory ;
1312
1413var historyArray = [ ] ; // Global array to store history objects
1514var selectField = [ ] ; // Global array to store information for columns which are used in select clause
@@ -145,10 +144,10 @@ DesignerHistory.andOr = function (index) {
145144 * @return {void }
146145 */
147146DesignerHistory . historyDelete = function ( index ) {
148- var fromArrayLength = fromArray . length ;
147+ var fromArrayLength = window . fromArray . length ;
149148 for ( var k = 0 ; k < fromArrayLength ; k ++ ) {
150- if ( fromArray [ k ] === historyArray [ index ] . getTab ( ) ) {
151- fromArray . splice ( k , 1 ) ;
149+ if ( window . fromArray [ k ] === historyArray [ index ] . getTab ( ) ) {
150+ window . fromArray . splice ( k , 1 ) ;
152151 break ;
153152 }
154153 }
@@ -630,7 +629,7 @@ DesignerHistory.queryFrom = function () {
630629 var quer = '' ;
631630 var parts = [ ] ;
632631 var tArray = [ ] ;
633- tArray = fromArray ;
632+ tArray = window . fromArray ;
634633 var K = 0 ;
635634 var k ;
636635 var key ;
@@ -643,32 +642,32 @@ DesignerHistory.queryFrom = function () {
643642
644643 var historyArrayLength = historyArray . length ;
645644 for ( i = 0 ; i < historyArrayLength ; i ++ ) {
646- fromArray . push ( historyArray [ i ] . getTab ( ) ) ;
645+ window . fromArray . push ( historyArray [ i ] . getTab ( ) ) ;
647646 }
648- fromArray = DesignerHistory . unique ( fromArray ) ;
649- tabLeft = fromArray ;
647+ window . fromArray = DesignerHistory . unique ( window . fromArray ) ;
648+ tabLeft = window . fromArray ;
650649 temp = tabLeft . shift ( ) ;
651650 quer = '`' + temp + '`' ;
652651 tabUsed . push ( temp ) ;
653652
654653 // if master table (key2) matches with tab used get all keys and check if tab_left matches
655654 // after this check if master table (key2) matches with tab left then check if any foreign matches with master .
656655 for ( i = 0 ; i < 2 ; i ++ ) {
657- for ( K in contr ) {
658- for ( key in contr [ K ] ) { // contr name
659- for ( key2 in contr [ K ] [ key ] ) { // table name
656+ for ( K in window . contr ) {
657+ for ( key in window . contr [ K ] ) { // contr name
658+ for ( key2 in window . contr [ K ] [ key ] ) { // table name
660659 parts = key2 . split ( '.' ) ;
661660 if ( DesignerHistory . found ( tabUsed , parts [ 1 ] ) > 0 ) {
662- for ( key3 in contr [ K ] [ key ] [ key2 ] ) {
663- parts1 = contr [ K ] [ key ] [ key2 ] [ key3 ] [ 0 ] . split ( '.' ) ;
661+ for ( key3 in window . contr [ K ] [ key ] [ key2 ] ) {
662+ parts1 = window . contr [ K ] [ key ] [ key2 ] [ key3 ] [ 0 ] . split ( '.' ) ;
664663 if ( DesignerHistory . found ( tabLeft , parts1 [ 1 ] ) > 0 ) {
665664 if ( DesignerHistory . found ( constraintsAdded , key ) > 0 ) {
666665 query += ' AND ' + '`' + parts [ 1 ] + '`.`' + key3 + '` = ' ;
667- query += '`' + parts1 [ 1 ] + '`.`' + contr [ K ] [ key ] [ key2 ] [ key3 ] [ 1 ] + '` ' ;
666+ query += '`' + parts1 [ 1 ] + '`.`' + window . contr [ K ] [ key ] [ key2 ] [ key3 ] [ 1 ] + '` ' ;
668667 } else {
669668 query += '\n' + 'LEFT JOIN ' ;
670669 query += '`' + parts [ 1 ] + '` ON ' ;
671- query += '`' + parts1 [ 1 ] + '`.`' + contr [ K ] [ key ] [ key2 ] [ key3 ] [ 1 ] + '` = ' ;
670+ query += '`' + parts1 [ 1 ] + '`.`' + window . contr [ K ] [ key ] [ key2 ] [ key3 ] [ 1 ] + '` = ' ;
672671 query += '`' + parts [ 1 ] + '`.`' + key3 + '` ' ;
673672
674673 constraintsAdded . push ( key ) ;
@@ -685,21 +684,21 @@ DesignerHistory.queryFrom = function () {
685684 tabUsed = DesignerHistory . addArray ( tTabLeft , tabUsed ) ;
686685 tabLeft = DesignerHistory . removeArray ( tTabLeft , tabLeft ) ;
687686 tTabLeft = [ ] ;
688- for ( K in contr ) {
689- for ( key in contr [ K ] ) {
690- for ( key2 in contr [ K ] [ key ] ) { // table name
687+ for ( K in window . contr ) {
688+ for ( key in window . contr [ K ] ) {
689+ for ( key2 in window . contr [ K ] [ key ] ) { // table name
691690 parts = key2 . split ( '.' ) ;
692691 if ( DesignerHistory . found ( tabLeft , parts [ 1 ] ) > 0 ) {
693- for ( key3 in contr [ K ] [ key ] [ key2 ] ) {
694- parts1 = contr [ K ] [ key ] [ key2 ] [ key3 ] [ 0 ] . split ( '.' ) ;
692+ for ( key3 in window . contr [ K ] [ key ] [ key2 ] ) {
693+ parts1 = window . contr [ K ] [ key ] [ key2 ] [ key3 ] [ 0 ] . split ( '.' ) ;
695694 if ( DesignerHistory . found ( tabUsed , parts1 [ 1 ] ) > 0 ) {
696695 if ( DesignerHistory . found ( constraintsAdded , key ) > 0 ) {
697696 query += ' AND ' + '`' + parts [ 1 ] + '`.`' + key3 + '` = ' ;
698- query += '`' + parts1 [ 1 ] + '`.`' + contr [ K ] [ key ] [ key2 ] [ key3 ] [ 1 ] + '` ' ;
697+ query += '`' + parts1 [ 1 ] + '`.`' + window . contr [ K ] [ key ] [ key2 ] [ key3 ] [ 1 ] + '` ' ;
699698 } else {
700699 query += '\n' + 'LEFT JOIN ' ;
701700 query += '`' + parts [ 1 ] + '` ON ' ;
702- query += '`' + parts1 [ 1 ] + '`.`' + contr [ K ] [ key ] [ key2 ] [ key3 ] [ 1 ] + '` = ' ;
701+ query += '`' + parts1 [ 1 ] + '`.`' + window . contr [ K ] [ key ] [ key2 ] [ key3 ] [ 1 ] + '` = ' ;
703702 query += '`' + parts [ 1 ] + '`.`' + key3 + '` ' ;
704703
705704 constraintsAdded . push ( key ) ;
@@ -720,7 +719,7 @@ DesignerHistory.queryFrom = function () {
720719 quer += ' , `' + tabLeft [ k ] + '`' ;
721720 }
722721 query = quer + query ;
723- fromArray = tArray ;
722+ window . fromArray = tArray ;
724723 return query ;
725724} ;
726725
0 commit comments