def home(): departments = DepartmentModel.fetch_all() all_employees = EmployeesModel.fetch_all() male = 0 female = 0 others = 0 for each in all_employees: if each.gender == 'm': male += 1 elif each.gender == 'f': female += 1 else: others += 1 pie_chart = pygal.Pie() pie_chart.title = 'Comparing Company Employees by Gender' pie_chart.add('Male', male) pie_chart.add('Female', female) pie_chart.add('Others', others) graph = pie_chart.render_data_uri() line_chart = pygal.Bar() line_chart.title = 'Salary cost per Department' for each_dept in departments: line_chart.add(each_dept.name, DepartmentModel.fetch_total_payroll_by_id(each_dept.id)) bar_graph = line_chart.render_data_uri() # print(graph) # print(departments) # print(departments) return render_template('index.html', idara=departments, graph=graph, bar_graph=bar_graph)
def home(): departments = DepartmentModel.fetch_all() #creating a pie chart in the home page all_employees = EmployeesModel.fetch_all() male = 0 female = 0 others = 0 for each in all_employees: if each.gender == 'male': male += 1 elif each.gender == 'female': female += 1 else: others += 1 pie_chart = pygal.Pie() # instantiating the pie class pie_chart.title = 'Analysing Company Employees By Gender' pie_chart.add('Male', male) pie_chart.add('Female', female) pie_chart.add('Others', others) chart=pie_chart.render_data_uri() # creating a bar graph in the home page line_chart = pygal.Bar() # instantiating the bar graph class line_chart.title = 'Salary Cost Per Department' #loop over departments for each_dept in departments: line_chart.add(each_dept.name, DepartmentModel.fetch_total_payroll_by_id(each_dept.id)) bar_graph = line_chart.render_data_uri() return render_template('index.html',idara = departments, chart=chart, bar_graph=bar_graph)