def bar_3d(self,search_result,y_legend,column_text,org,time):
#定义chart
chart = openFlashChart.template(u''+time+'年'+org+'公司费用统计柱状图')
chart.set_y_legend(y_legend, style = '{font-size: 12px}')#设置y轴
#横坐标
x_labels = []
for row in search_result:
x_labels.append(row[0])
chart.set_x_axis(colour = '#736AFF', three_d = 5, labels = x_axis_labels(labels = x_labels))
row_num = len(search_result)#共多少条记录
column_num = len(search_result[0])#每条记录有几列
#取值
mymax = 0
for column_i in range(1,column_num):
plot = Bar_3d()
values = []
for row in search_result:
if int(row[column_i]) > mymax:
mymax = int(row[column_i])
values.append(bar_3d_value(int(row[column_i]), colorArr[column_i-1]))
plot.set_values(values=values)
plot.set_colour(colorArr[column_i-1])
plot['on-show'] = dict([['type','pop-up'],['cascade',1],['delay',0.5]])#api中没有on-show 手动加上
plot['text'] = column_text[column_i-1]
chart.add_element(plot)
values = []
chart.set_y_axis(min = 0, max = mymax)
return chart.encode()
def bar_3d(self, search_result, y_legend, column_text, org, time):
#定义chart
chart = openFlashChart.template(u'' + time + '年' + org + '公司费用统计柱状图')
chart.set_y_legend(y_legend, style='{font-size: 12px}') #设置y轴
#横坐标
x_labels = []
for row in search_result:
x_labels.append(row[0])
chart.set_x_axis(colour='#736AFF',
three_d=5,
labels=x_axis_labels(labels=x_labels))
row_num = len(search_result) #共多少条记录
column_num = len(search_result[0]) #每条记录有几列
#取值
mymax = 0
for column_i in range(1, column_num):
plot = Bar_3d()
values = []
for row in search_result:
if int(row[column_i]) > mymax:
mymax = int(row[column_i])
values.append(
bar_3d_value(int(row[column_i]), colorArr[column_i - 1]))
plot.set_values(values=values)
plot.set_colour(colorArr[column_i - 1])
plot['on-show'] = dict([['type', 'pop-up'], ['cascade', 1],
['delay', 0.5]]) #api中没有on-show 手动加上
plot['text'] = column_text[column_i - 1]
chart.add_element(plot)
values = []
chart.set_y_axis(min=0, max=mymax)
return chart.encode()
def bar_3d(self):
plot = Bar_3d(values = range(-8, 8, 2) + [bar_3d_value(5, '#333333', 'Special:<br>Top = #top#<br>Bottom = #bottom#')])
plot.set_colour('#D54C78')
chart = openFlashChart.template("Bar_3d chart")
chart.set_y_axis(min = -8, max = 8)
chart.set_x_axis(colour = '#909090', three_d = 5, labels = list('qp#m^fur'))
chart.add_element(plot)
return chart.encode()
def bar_3d(self):
plot = Bar_3d(values=range(-8, 8, 2) + [
bar_3d_value(5, '#333333',
'Special:<br>Top = #top#<br>Bottom = #bottom#')
])
plot.set_colour('#D54C78')
chart = openFlashChart.template("Bar_3d chart")
chart.set_y_axis(min=-8, max=8)
chart.set_x_axis(colour='#909090', three_d=5, labels=list('qp#m^fur'))
chart.add_element(plot)
return chart.encode()
