# -*- coding: utf-8 -*-
import csv
from datetime import datetime
import pandas as pd
import matplotlib.pyplot as plt
import matplotlib as mpl
import numpy as np
#### Import Code Files #####
import test_connect_mysql
cursor = test_connect_mysql.cursor
mydb = test_connect_mysql.mydb
to_date = datetime.now()
year_check = str(datetime.date(to_date))[0:4]
#print(year_check)
cursor.execute("SELECT plaza, SUM(no_tag) AS t_no_tag, SUM(barcode) AS t_barcode \
FROM error_bar_tag WHERE date_format(date_in, '%Y')= '" + year_check + "' \
GROUP BY plaza \
");
rows = cursor.fetchall()
#str(rows)[0:300]
cursor.close
mydb.close
df = pd.DataFrame( [[ij for ij in i] for i in rows] )
df.rename(columns={0:'plaza', 1:'t_no_tag', 2:'t_barcode'}, inplace=True);
df = df.sort_values(['plaza'], ascending=[1]);
#print(df)
# Make a fake dataset #########################################
height = df['t_no_tag']
bars = df['plaza']
y_pos = np.arange(len(bars))
plt.bar(y_pos, height, color='red', align='center', width=0.4)
plt.xticks(y_pos, bars)
ax = plt.gca()
ax.set_title(u'ผลรวมไม่อ่าน Tag ของ Plaza ปี ' + year_check,fontname='Tahoma',fontsize='13')
ax.set_xlabel(u'Plaza',fontname='Tahoma',fontsize='10')
ax.xaxis.set_label_coords(1.05, -0.05)
plt.tick_params(axis='x',rotation=90 ,labelsize=9, length=10)
plt.plot(y_pos, height,c='b')
plt.show()
