Class: RailsDbAdmin::ErpApp::Desktop::ReportsController

Inherits:
QueriesController show all
Defined in:
app/controllers/rails_db_admin/erp_app/desktop/reports_controller.rb

Instance Method Summary collapse

Methods inherited from QueriesController

#delete_query, #execute_query, #open_and_execute_query, #save_query, #saved_queries, #saved_queries_tree, #select_top_fifty

Methods inherited from BaseController

#databases, #setup_table_grid, #table_data, #tables

Instance Method Details

#create ⇒ Object 



14
15
16
17
18
19
20
21
22
23
24
 
# File 'app/controllers/rails_db_admin/erp_app/desktop/reports_controller.rb', line 14

def create
  name = params[:name]
  internal_identifier = params[:internal_identifier]

  report = Report.new(:name => name, :internal_identifier => internal_identifier)
  if report.save
    render :json => {:success => true}
  else
    render :json => {:success => false, :msg => 'Error creating report'}
  end
end

#delete ⇒ Object 



58
59
60
61
62
63
64
65
66
 
# File 'app/controllers/rails_db_admin/erp_app/desktop/reports_controller.rb', line 58

def delete
  id  = params[:id]

  if Report.find(id).destroy
    render :json => {:success => true}
  else
    render :json => {:success => false}
  end
end

#edit ⇒ Object 



26
27
28
29
30
31
32
33
34
35
36
37
38
39
 
# File 'app/controllers/rails_db_admin/erp_app/desktop/reports_controller.rb', line 26

def edit
  id  = params[:id]

  report = Report.find(id)

  if report
    render :json => {:success => true, :report =>
        {:title => report.name, :id => report.id, :query => report.query,
         :internalIdentifier => report.internal_identifier, :template => report.template}
    }
  else
    render :json => {:success => false}
  end
end

#index ⇒ Object 



6
7
8
9
10
11
12
 
# File 'app/controllers/rails_db_admin/erp_app/desktop/reports_controller.rb', line 6

def index
  reports = Report.all.collect{ |report|{:text => report.name, :id => report.id,
                                         :uniqueName => report.internal_identifier,
                                         :iconCls => 'icon-document', :leaf => true} }

  render :json => reports
end

#open_query ⇒ Object 



68
69
70
71
72
73
 
# File 'app/controllers/rails_db_admin/erp_app/desktop/reports_controller.rb', line 68

def open_query
  query_name = params[:query_name]
  query = @query_support.get_query(query_name)

  render :json => {:success => true, :query => query}
end

#save ⇒ Object 



41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
 
# File 'app/controllers/rails_db_admin/erp_app/desktop/reports_controller.rb', line 41

def save
  id  = params[:id]
  query = params[:query]
  template = params[:template]

  report = Report.find(id)

  report.query = query
  report.template = template

  if report.save
    render :json => {:success => true}
  else
    render :json => {:success => false}
  end
end