Ext.define("Compass.ErpApp.Desktop.Applications.RailsDbAdmin.QueryPanel",{
  extend:"Ext.Panel",
  alias:'widget.railsdbadmin_querypanel',
  gridContainer : null,
  initComponent: function() {
    var self = this;
    var messageBox = null;

    var savedQueriesJsonStore = Ext.create('Ext.data.Store', {
      proxy: {
        type: 'ajax',
        url: '/rails_db_admin/erp_app/desktop/queries/saved_queries',
        reader: {
          type: 'json',
          root: 'data'
        }
      },
      fields:[
      {
        name:'value'
      },
      {
        name:'display'
      }
      ]
    });

    var tableGridContainer = new Ext.Panel({
      layout:'card',
      region : 'center',
      margins : '0 0 0 0',
      autoScroll:true,
      items:[]
    });

    this.gridContainer = tableGridContainer;
        
    var codeMirrorPanel = new Ext.Panel({
      height:250,
      region:'north',
      margins : '0 0 0 0',
      frame:false,
      border:false,
      autoScroll:true,
      layout:'fit',
      items:[
      {
        xtype:'codemirror',
        parser:'sql',
        sourceCode:this.initialConfig['sqlQuery'],
        disableSave:true
      }
      ]
			
    });
		
    this.tbar = {
      items:[{
        text: 'Execute',
        iconCls: 'icon-settings',
        handler: function(button) {
          var textarea = self.query('.codemirror')[0];
          var sql = textarea.getValue();
          var selected_sql = textarea.getSelection();
          var cursor_pos = textarea.getCursor().line;
          var database = self.module.getDatabase();
					
          messageBox = Ext.Msg.wait('Status', 'Executing..');

          var conn = new Ext.data.Connection();
          conn.request({
            url: '/rails_db_admin/erp_app/desktop/queries/execute_query',
            params:{
              sql:sql,
              database:database,
              cursor_pos: cursor_pos,
              selected_sql : selected_sql
            },
            method:'post',
            success: function(responseObject) {

              messageBox.hide();
              var response =  Ext.decode(responseObject.responseText);

              if(response.success)
              {
                var columns = response.columns;
                var fields = response.fields;
                var data = response.data;

                var grid = new Compass.ErpApp.Desktop.Applications.RailsDbAdmin.ReadOnlyTableDataGrid({
                  columns:columns,
                  fields:fields,
                  data:data
                });

                tableGridContainer.removeAll(true);
                tableGridContainer.add(grid);
                tableGridContainer.getLayout().setActiveItem(0);
              }
              else
              {
                Ext.Msg.alert("Error", response.exception);
              }

            },
            failure: function() {
              messageBox.hide();
              Ext.Msg.alert('Status', 'Error loading grid');
            }
          });
        }
      },
      {
        text: 'Save',
        iconCls: 'icon-save',
        handler:function(){
          var textarea = self.query('.codemirror')[0];
          var save_window = new Ext.Window({
            layout:'fit',
            width:375,
            title:'Save Query',
            height:125,
            buttonAlign:'center',
            closeAction:'hide',
            plain: true,
            items: new Ext.FormPanel({
              frame:false,
              bodyStyle:'padding:5px 5px 0',
              width: 500,
              items: [{
                xtype: 'combo',
                fieldLabel: 'Query Name',
                name: 'query_name',
                allowBlank:false,
                store:savedQueriesJsonStore,
                valueField:'value',
                displayField:'display',
                triggerAction:'all',
                forceSelection:false,
                mode:'remote'
              },
              {
                xtype: 'hidden',
                value: textarea.getValue(),
                name: 'query'
              },
              {
                xtype: 'hidden',
                value: self.module.getDatabase(),
                name: 'database'
              }]
            }),
            buttons: [{
              text: 'Save',
              handler: function(){
                var fp = this.findParentByType('window').query('.form')[0];
                if(fp.getForm().isValid()){
                  fp.getForm().submit({
                    url: '/rails_db_admin/erp_app/desktop/queries/save_query',
                    waitMsg: 'Saving Query...',
                    success: function(fp, o){
                      Ext.Msg.alert('Success', 'Saved Query');
                      var database = self.module.getDatabase();
                      self.module.queriesTreePanel().store.setProxy({
                        type: 'ajax',
                        url: '/rails_db_admin/erp_app/desktop/queries/saved_queries_tree',
                        extraParams:{
                          database:database
                        }
                      });
                      self.module.queriesTreePanel().store.load();
                      save_window.hide();
                    }
                  });
                }
              }
            },{
              text: 'Cancel',
              handler: function(){
                save_window.hide();
              }
            }]
						
          });
          save_window.show();
        }
      }]
    };

    this.items = [codeMirrorPanel, tableGridContainer];
    this.callParent(arguments);
  },

  constructor : function(config) {
    config = Ext.apply({
      title:'Query',
      layout:'border',
      autoScroll:true,
      closable: true,
      border:false
    }, config);
    this.callParent([config]);
  }
	
});