def analyseCRM_html():
if request.method == "POST":
result1 = ""
resultTuple1 = NikeHandler.analyseCRMDataBySeasonAndSex(request.form['season'],request.form['year'],request.form['region'])
resultTuple3 = NikeHandler.analyseCRMDataBySeasonAndAge(request.form['season'],request.form['year'],request.form['region'])
resultTuple2 = NikeHandler.analyseCRMDataBySeasonAndStore(request.form['season'],request.form['year'],request.form['region'])
if request.form['standard'] == 'gender':
string='<script>var pieDataSex1 = [{value: %s, color:"#F7464A", \
highlight: "#FF5A5E", label: "Female"},{value: %s, color: "#46BFBD", \
highlight: "#5AD3D1", label: "Male"}]; \
window.onload = function(){ \
var ctSex1 = document.getElementById("chart-area").getContext("2d"); \
window.myPie = new Chart(ctSex1).Pie(pieDataSex1); };</script>'
if request.form['level'] == '1':
result1 = Markup(string % (resultTuple1[0][0], resultTuple1[1][0]))
return render_template('AnalyseCRM.html', result1 = result1)
elif request.form['level'] == '2':
result1 = Markup(string % (resultTuple1[0][1], resultTuple1[1][1]))
return render_template('AnalyseCRM.html', result1 = result1)
else:
result1 = Markup(string % (resultTuple1[0][2], resultTuple1[1][2]))
return render_template('AnalyseCRM.html', result1 = result1)
elif request.form['standard'] == 'store':
string='<script>var pieDataSex1 = [{value: %s, color:"#F7464A", \
highlight: "#FF5A5E", label: "Exclusive Shop"},{value: %s, color: "#46BFBD", \
highlight: "#5AD3D1", label: "Distributor"},{value: %s, color: "#1E90FF", \
highlight: "#191970", label: "Outlet"}]; \
window.onload = function(){ \
var ctSex1 = document.getElementById("chart-area").getContext("2d"); \
window.myPie = new Chart(ctSex1).Pie(pieDataSex1); };</script>'
if request.form['level'] == '1':
result1 = Markup(string % (resultTuple2[0][0], resultTuple2[1][0],resultTuple2[2][0]))
return render_template('AnalyseCRM.html', result1 = result1)
elif request.form['level'] == '2':
result1 = Markup(string % (resultTuple2[0][1], resultTuple2[1][1],resultTuple2[2][1]))
return render_template('AnalyseCRM.html', result1 = result1)
else:
result1 = Markup(string % (resultTuple2[0][2], resultTuple2[1][2],resultTuple2[2][2]))
return render_template('AnalyseCRM.html', result1 = result1)
elif request.form['standard'] == 'age':
string='<script>var pieDataSex1 = [{value: %s, color:"#F7464A", \
highlight: "#FF5A5E", label: "0-12"},{value: %s, color: "#46BFBD", \
highlight: "#5AD3D1", label: "13-24"},{value: %s, color: "#1E90FF", \
highlight: "#191970", label: "25-36"},{value: %s, color: "#F08080", \
highlight: "#FA8072", label: "37-48"},{value: %s, color: "#808080", \
highlight: "#696969", label: "49-60"},{value: %s, color: "#66CDAA", \
highlight: "#20B2AA", label: "60~"}]; \
window.onload = function(){ \
var ctSex1 = document.getElementById("chart-area").getContext("2d"); \
window.myPie = new Chart(ctSex1).Pie(pieDataSex1); };</script>'
if request.form['level'] == '1':
result1 = Markup(string % (resultTuple3[0][0], resultTuple3[1][0],resultTuple3[2][0],
resultTuple3[3][0], resultTuple3[4][0],resultTuple3[5][0]))
return render_template('AnalyseCRM.html', result1 = result1)
elif request.form['level'] == '2':
result1 = Markup(string % (resultTuple3[0][1], resultTuple3[1][1],resultTuple3[2][1],
resultTuple3[3][1], resultTuple3[4][1],resultTuple3[5][1]))
return render_template('AnalyseCRM.html', result1 = result1)
else:
result1 = Markup(string % (resultTuple3[0][2], resultTuple3[1][2],resultTuple3[2][2],
resultTuple3[3][2], resultTuple3[4][2],resultTuple3[5][2]))
return render_template('AnalyseCRM.html', result1 = result1)
else:
return render_template('AnalyseCRM.html')
else:
return render_template('AnalyseCRM.html')
