Chinaunix首页 | 论坛 | 博客

努力搬砖！jonas.blog.chinaunix.net

首页　| 　博文目录　| 　关于我

howge

  • 博客访问： 352793
  • 博文数量： 26
  • 博客积分： 495
  • 博客等级： 下士
  • 技术积分： 562
  • 用 户 组： 普通用户
  • 注册时间： 2010-04-26 13:50
文章分类

全部博文（26）

文章存档

2015年（9）

2014年（6）

2013年（7）

2012年（2）

2011年（2）

我的朋友
最近访客
推荐博文
相关博文
python 生成html文件

分类： Python/Ruby

2012-06-25 18:38:55

这次要写一个脚本，做一个web汇报页面，利用到的PyH这个库，这个库用来生成html文件，wiki在这里，很简单的一个库，弄清关系以后很好使用，我只了解最基本的html，其中还有一部分CSS是朋友代劳，目前已经基本实现了，脚本应该可以优化，老大催的紧，先搞出结果再说包含2部分，先贴下css的，很简单的小文件，common.css(实在懒得看这玩意)

点击(此处)折叠或打开

  1. tr{ white-space:0;}
  2. .table0{border:none;width:100%;}
  3. .table0_td{padding:0 0px 0px 0;}
  4. .table1 {border-collapse:collapse;width:100%;}
  5. .table1 td{ height:30px; border:#333333 solid 1px;text-align:center;width:25%}
python脚本WeekReport.py 

点击(此处)折叠或打开

  1. #!/usr/bin/python
  2. #coding:utf-8
  3. from pyh import *
  4. import MySQLdb
  5. import datetime

  7. class Getdata:
  8.     def __init__(self):
  9.         self.conn=MySQLdb.connect(host='urhost',db='urdb',user='user',passwd='urpass')
  10.         self.cur=self.conn.cursor()

  12.     def getdata(self):
  13.         D={} #main 字典
  14.         d={} #临时字典
  15.         now=datetime.date.today()
  16.         delta=datetime.timedelta(days=7)
  17.         lastnow=now-delta

  19.         load='''
  20.         select a.f_name as project,c.avgload,c.f_date from t_project a,t_department b,
  21.         (select f_project_id,(sum(f_avg_load)/count(*)) as avgload,f_date from t_load_daily where f_date=date_add(curdate(),interval -7 day) group by f_project_id,f_date order by f_date) c
  22.         where c.f_project_id=a.f_pro_id and a.f_depart_id=b.f_depart_id union all select a.f_name as project,c.avgload,c.f_date from t_project a,t_department b,(select f_project_id,(sum(f_avg_load)/count(*)) as avgload,f_date from t_load_daily where f_date=date(now()) group by f_project_id,f_date order by f_date) c
  23.         where c.f_project_id=a.f_pro_id and a.f_depart_id=b.f_depart_id
  24.         '''
  25.         idc='''
  26.         select b.f_name as project,c.num,c.f_date from t_department a,t_project b,
  27.         (select f_depart_id,f_project_id,sum(f_flow_num) as num ,f_date from t_flows where f_type=3 and f_date=date(now()) group by f_project_id,f_date) c
  28.         where c.f_depart_id=a.f_depart_id and c.f_project_id=b.f_pro_id union all select b.f_name as project,c.num,c.f_date from t_department a,t_project b,(select f_depart_id,f_project_id,sum(f_flow_num) as num ,f_date from t_flows where f_type=3 and f_date=date_add(curdate(),interval -7 day)
  29.         group by f_project_id,f_date) c where c.f_depart_id=a.f_depart_id and c.f_project_id=b.f_pro_id;
  30.         '''

  32.         cdn='''
  33.         select b.f_name as project,c.num,c.f_date from t_department a,t_project b,
  34.         (select f_depart_id,f_project_id,sum(f_flow_num) as num ,f_date from t_flows where f_type=2 and f_date=date_add(curdate(),interval -7 day)
  35.         group by f_project_id,f_date) c where c.f_depart_id=a.f_depart_id and c.f_project_id=b.f_pro_id union all select b.f_name as project,c.num,c.f_date from t_department a,t_project b,(select f_depart_id,f_project_id,sum(f_flow_num) as num ,f_date from t_flows where f_type=2 and f_date=date(now()) group by f_project_id,f_date) c
  36.         where c.f_depart_id=a.f_depart_id and c.f_project_id=b.f_pro_id
  37.         '''
  38.         dau='''
  39.         select f_name,num,date from t_project a,
  40.         (select f_project_id as id ,sum(f_num) as num,f_date as date from t_dau where f_date=date(now()) group by f_project_id) b
  41.         where a.f_pro_id=b.id union all select f_name,num,date from t_project a,
  42.         (select f_project_id as id ,sum(f_num) as num,f_date as date from t_dau where f_date=date_add(curdate(),interval -7 day)
  43.         group by f_project_id) b where a.f_pro_id=b.id
  44.         '''
  45.         srvsum='''
  46.         select f_name,num,date from t_project a,
  47.         (select f_project_id as id,sum(f_costing_num) as num,f_date as date from t_costing_daily where f_costing_type=1 and f_date=date_add(curdate(),interval -7 day) group by f_project_id) b where a.f_pro_id=b.id
  48.         union all select f_name,num,date from t_project a,(select f_project_id as id,sum(f_costing_num) as num,f_date as date from t_costing_daily where f_costing_type=1 and f_date=date(now()) group by f_project_id) b where a.f_pro_id=b.id
  49.         '''
  50.         self.cur.execute(srvsum)
  51.         rows=self.cur.fetchall()

  53.         for row in rows:
  54.             try:
  55.                 d[row[0]]=d[row[0]]+row[1::] # 数据合并汇总
  56.             except KeyError,e:
  57.                 d[row[0]]=row[1::]

  59.         for k,v in d.items():
  60.             a=[]
  61.             m=list(v)
  62.             if now in v:
  63.                 a.append(m[m.index(now)-1])
  64.             else:
  65.                 a.append(0)
  66.             if lastnow in v:
  67.                 a.append(m[m.index(lastnow)-1])
  68.             else:
  69.                 a.append(0)
  70.             D[k]={'num':a}
  71.         ###
  72.         d={} ##置空字典
  73.         self.cur.execute(load)
  74.         rows=self.cur.fetchall()
  75.         for row in rows:
  76.             try:
  77.                 d[row[0]]=d[row[0]]+row[1::] # 数据合并汇总
  78.             except KeyError,e:
  79.                 d[row[0]]=row[1::]
  80.         for k,v in d.items():
  81.             a=[]
  82.             m=list(v)
  83.             if now in v:
  84.                 a.append(m[m.index(now)-1])
  85.             else:
  86.                 a.append(0)
  87.             if lastnow in v:
  88.                 a.append(m[m.index(lastnow)-1])
  89.             else:
  90.                 a.append(0)
  91.             D[k]['load']=a

  93.         ####
  94.         d={}
  95.         self.cur.execute(cdn)
  96.         rows=self.cur.fetchall()
  97.         for row in rows:
  98.             try:
  99.                 d[row[0]]=d[row[0]]+row[1::] # 数据合并汇总
  100.             except KeyError,e:
  101.                 d[row[0]]=row[1::]
  102.         for k,v in d.items():
  103.             a=[]
  104.             m=list(v)
  105.             if now in v:
  106.                 a.append(m[m.index(now)-1])
  107.             else:
  108.                 a.append(0)
  109.             if lastnow in v:
  110.                 a.append(m[m.index(lastnow)-1])
  111.             else:
  112.                 a.append(0)
  113.             D[k]['cdn']=a

  115.         ####
  116.         d={}
  117.         self.cur.execute(idc)
  118.         rows=self.cur.fetchall()
  119.         for row in rows:
  120.             try:
  121.                 d[row[0]]=d[row[0]]+row[1::] # 数据合并汇总
  122.             except KeyError,e:
  123.                 d[row[0]]=row[1::]
  124.         for k,v in d.items():
  125.             a=[]
  126.             m=list(v)
  127.             if now in v:
  128.                 a.append(m[m.index(now)-1])
  129.             else:
  130.                 a.append(0)
  131.             if lastnow in v:
  132.                 a.append(m[m.index(lastnow)-1])
  133.             else:
  134.                 a.append(0)
  135.             D[k]['idc']=a

  137.         ####
  138.         d={}
  139.         self.cur.execute(dau)
  140.         rows=self.cur.fetchall()
  141.         for row in rows:
  142.             try:
  143.                 d[row[0]]=d[row[0]]+row[1::] # 数据合并汇总
  144.             except KeyError,e:
  145.                 d[row[0]]=row[1::]
  146.         for k,v in d.items():
  147.             a=[]
  148.             m=list(v)
  149.             if now in v:
  150.                 a.append(m[m.index(now)-1])
  151.             else:
  152.                 a.append(0)
  153.             if lastnow in v:
  154.                 a.append(m[m.index(lastnow)-1])
  155.             else:
  156.                 a.append(0)
  157.             D[k]['dau']=a

  159.         return D







  167. class ToHtml:
  168.     '''
  169.        此类主要用来生成html文件

  171.     '''

  173.     def str3tocoma(self,num):#每三个数字加一个逗号
  174.         e = list(str(num))
  175.         if len(e)<=3:
  176.            return num
  177.         else:
  178.            for i in range(len(e))[::-3][1:]:
  179.                e.insert(i+1,",")
  180.            return "".join(e)

  182.     def Gentable(self,pro,data):
  183.         def k(x,y):
  184.             try:
  185.                return float(x-y)/float(y)
  186.             except ZeroDivisionError:
  187.                return 0
  188.         t=table(caption='%s' % pro,border="1",cl="table1",cellpadding="0",cellspacing="0")
  189.         t<<tr(td('%s' % pro,bgColor='#0099ff')+td('当前数据')+td('上周同比数据')+td('上周同比百分比'))
  190.         if data.has_key('dau'):
  191.             N=k(data.get('dau')[0],data.get('dau')[1])
  192.             if N>0.3:
  193.                 t<<tr(td('DAU')+td(self.str3tocoma(data.get('dau')[0]))+td(self.str3tocoma(data.get('dau')[1]))+td("%5.2F%%" % (N*100),bgColor='#ff0000'))
  194.             elif N<0:
  195.                 t<<tr(td('DAU')+td(self.str3tocoma(data.get('dau')[0]))+td(self.str3tocoma(data.get('dau')[1]))+td("%5.2f%%" % (N*100),bgColor='#00ff00'))
  196.             else:
  197.                 t<<tr(td('DAU')+td(self.str3tocoma(data.get('dau')[0]))+td(self.str3tocoma(data.get('dau')[1]))+td("%5.2f%%" % (N*100)))
  198.                 
  199.         else:
  200.             t<<tr(td('DAU')+td(0)+td(0)+td(0))
  201.         if data.has_key('load'):
  202.             N=k(data.get('load')[0],data.get('load')[1])
  203.             if N>0.2:
  204.                 t<<tr(td('负载')+td(data.get('load')[0])+td(data.get('load')[1])+td("%5.2F%%" % (N*100),bgColor='#ff0000'))
  205.             elif N<0:
  206.                 t<<tr(td('负载')+td(data.get('load')[0])+td(data.get('load')[1])+td("%5.2F%%" % (N*100),bgColor='#00ff00'))
  207.             else:
  208.                 t<<tr(td('负载')+td(self.str3tocoma(data.get('load')[0]))+td(self.str3tocoma(data.get('load')[1]))+td("%5.2F%%" % (N*100)))
  209.         else:
  210.             t<<tr(td('负载')+td(0)+td(0)+td(0))
  211.         if data.has_key('num'):
  212.             N=k(data.get('num')[0],data.get('num')[1])
  213.             if N>0.2:
  214.                 t<<tr(td('服务器数量')+td(data.get('num')[0])+td(data.get('num')[1])+td("%5.2F%%" % (N*100),bgColor='#ff0000'))
  215.             elif N<0:
  216.                 t<<tr(td('服务器数量')+td(data.get('num')[0])+td(data.get('num')[1])+td("%5.2F%%" % (N*100),bgColor='#00ff00'))
  217.             else:
  218.                 t<<tr(td('服务器数量')+td(data.get('num')[0])+td(data.get('num')[1])+td("%5.2F%%" % (N*100)))
  219.         else:
  220.             t<<tr(td('服务器数量')+td(0)+td(0)+td(0))
  221.         if data.has_key('cdn'):
  222.             N=k(data.get('num')[0],data.get('num')[1])
  223.             if N>0.3:
  224.                 t<<tr(td('CDN流量')+td(data.get('cdn')[0])+td(data.get('cdn')[0])+td("%5.2F%%" % (N*100),bgColor='#ff0000'))
  225.             elif N<0:
  226.                 t<<tr(td('CDN流量')+td(data.get('cdn')[0])+td(data.get('cdn')[0])+td("%5.2F%%" % (N*100),bgColor='#00ff00'))
  227.             else:
  228.                 t<<tr(td('CDN流量')+td(data.get('cdn')[0])+td(data.get('cdn')[0])+td("%5.2F%%" % (N*100)))
  229.         else:
  230.             t<<tr(td('CDN流量')+td(0)+td(0)+td(0))
  231.         if data.has_key('idc'):
  232.             N=k(data.get('num')[0],data.get('num')[1])
  233.             if N>0.3:
  234.                 t<<tr(td('IDC流量')+td(data.get('idc')[0])+td(data.get('idc')[0])+td("%5.2F%%" % (N*100),bgColor='#ff0000'))
  235.             elif N<0:
  236.                 t<<tr(td('IDC流量')+td(data.get('idc')[0])+td(data.get('idc')[0])+td("%5.2F%%" % (N*100),bgColor='#00ff00'))
  237.             else:
  238.                 t<<tr(td('IDC流量')+td(data.get('idc')[0])+td(data.get('idc')[0])+td("%5.2F%%" % (N*100)))
  239.         else:
  240.             t<<tr(td('IDC流量')+td(0)+td(0)+td(0))
  241.         return t


  244.     def Tohtml(self,tables):
  245.         page=PyH('本周报告')
  246.         page.addCSS('common.css')
  247.         page<<h1('本周报告',align='center')
  248.         tab=table(cellpadding="0",cellspacing="0",cl="table0")
  249.         for t in range(0,len(tables),2):
  250.             tab<<tr(td(tables[t-1],cl="table0_td")+td(tables[t],cl="table0_td"))
  251.         page<<tab
  252.         page.printOut()

  254. if __name__=="__main__":
  255.     I=Getdata()
  256.     d=I.getdata()
  257.     tabrows=[]
  258.     h=ToHtml()
  259.     for k,v in d.items():
  260.         t=h.Gentable(k,v)
  261.         tabrows.append(t)
  262.     h.Tohtml(tabrows)
最后插入图片一张：


阅读(17141) | 评论(0) | 转发(2) |
0

上一篇：判断8位数字是不是日期-just for fun

下一篇：Extjs 3.4 动态树及权限

给主人留下些什么吧！~~
关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6