# coding=utf-8
from bgutils.ftpUtil import ftpUtil
from bgutils.mysqlUtil import mysqlUtil
from matplotlib import pyplot as plt
import seaborn as sns


class drawpic:
    def draw(self,myname,mycode):
        mutil= mysqlUtil()
        ftputil=ftpUtil()
        # SELECT * FROM test.wc_goods_name where word!='' order by acount desc;
        SQL = '''select  * from wc_goods_name where word!="" and collector="'''+ \
              myname +'''" order by acount desc limit 10 '''
        # 调用 mysqlconn 类的 query() 方法
        df_data = mutil.query(sql=SQL)
        # df_data.to_csv
        # 使用seaborn库绘图
        sns.set_style('whitegrid', {'font.sans-serif':['simhei', 'Arial']})
        # 设置中文字体
        #plt.rcParams['font.sans-serif'] = font
        # 设置正常显示负号
        plt.rcParams['axes.unicode_minus']=False

        count = df_data['acount']
        index = df_data['word']
        sns.barplot(x=count, y=index)
        plt.xticks(rotation=70)
        plt.xlabel('数量')
        plt.ylabel('商品名称')
        plt.title(myname+'同学的商品名称统计')
        # plt.show()
        idxproject= "22002"  #22001是项目编号，长度5位
        idxpic="04" #04是图片在该项目中的顺序号，长度2位
        filepath=mycode+"_"+idxpic +".jpg" #生成的文件以学号+序号+后缀组成
        plt.savefig(filepath)
        ftputil.putfile_stud(filepath, idxproject,mycode,idxpic);


if __name__ == "__main__":
    draw=drawpic();
    myname="myname" #请将引号中的myname替换为本人姓名,如：张三
    mycode="mycode" #请将引号中的mycode替换为本人学号，如:2019001001
    draw.draw(myname,mycode);