web页，用于追踪备份状况

#!/usr/bin/python
#-*- coding: UTF-8 -*-

import MySQLdb,cgi,time,datetime

today = datetime.datetime.now()
today_0 = today.strftime('%Y-%m-%d')
today_1 = (today + datetime.timedelta(days = -1)).strftime('%Y-%m-%d')
today_2 = (today + datetime.timedelta(days = -2)).strftime('%Y-%m-%d')
today_3 = (today + datetime.timedelta(days = -3)).strftime('%Y-%m-%d')
today_4 = (today + datetime.timedelta(days = -4)).strftime('%Y-%m-%d')
today_5 = (today + datetime.timedelta(days = -5)).strftime('%Y-%m-%d')
today_6 = (today + datetime.timedelta(days = -6)).strftime('%Y-%m-%d')


header = 'Content-Type: text/html\n\n'
url = '/cgi-bin/test_web2.py'

formhtml = '''<br />
</span>
			</li>
			<li>
				rsync_backup
The Backup List: %s

Please Input Module Name:


Please enter the date(custom):

Please enter the date:
%s
'''

fradio = ' %s\n'

def showForm(who, howmany):
    friends = ''
    for i in [today_0,today_1,today_2,today_3,today_4,today_5,today_6]:
        checked = ''
        if str(i) == howmany:
            checked = 'CHECKED'
        friends = friends + fradio % (str(i), checked, str(i))
    print header + formhtml % (who, url, who, howmany, friends)

reshtml_01 = '''
rsync_backup
The Backup List: %s
Your name is: %s
The current date: %s
Click here to edit your data again.
  
				    
				    
				    
				    
				    
				    
				    
				    
				    
				    
				  
				'''
			
				reshtml_02 = '''

			
				  
				    
				    
				    
				    
				    
				    
				    
				    
				    
				    
				  
				''' 
			
				def doResults(who, howmany, today_now):
			
				    n=1
			
				    print header + reshtml_01 % (who, who, howmany, url)
			
				    db_conn=MySQLdb.connect(host='127.0.0.1',user='root',passwd='',db='test')
			
				    db_curs=db_conn.cursor()
			
				    if who == '':
			
				        db_curs.execute("SELECT id,date_ymd,s_time,e_time,mod_name,files,files_traned,filesize,filesize_traned,a_error \

			
				                         FROM bak_stat where date_ymd='%s' " % today_now )
			
				        for data in db_curs.fetchall():
			
				            if data[9] == '':
			
				                print reshtml_02 % (n,data[1],data[2],data[3],data[4], \
			
				                                    format(data[5],','),format(data[6],','),format(data[7],','),format(data[8],','),data[9])
			
				            else:
			
				                print reshtml_02 % (n,data[1],data[2],data[3],data[4],data[5],data[6],data[7],data[8],data[9])
			
				            n+=1
			
				    else:
			
				        db_curs.execute("SELECT id,date_ymd,s_time,e_time,mod_name,files,files_traned,filesize,filesize_traned,a_error \

			
				                         FROM bak_stat where mod_name='%s' " % who )
			
				        for data in db_curs.fetchall():
			
				            if data[9] == '':
			
				                print reshtml_02 % (n,data[1],data[2],data[3],data[4], \
			
				                                    format(data[5],','),format(data[6],','),format(data[7],','),format(data[8],','),data[9])
			
				            else:
			
				                print reshtml_02 % (n,data[1],data[2],data[3],data[4],data[5],data[6],data[7],data[8],data[9])
			
				            n+=1
			
				    db_curs.close()
			
				    db_conn.close()
			
				def process():
			
				    error = ''
			
				    form = cgi.FieldStorage()
			
				    
			
				    if form.has_key('person'):
			
				        who = form['person'].value
			
				    else:
			
				        who = ''
			
				    
			
				    if form.has_key('howmany'):
			
				        howmany = form['howmany'].value
			
				    else:
			
				        howmany = ''
			
				    
			
				    if form.has_key('action'):
			
				        doResults(who, howmany,howmany)
			
				    else:
			
				        showForm(who, howmany)
			
				
			
				if __name__ == '__main__':
			
				    process()
			
	 

	部分代码解释：

	#!/usr/bin/python
#-*- coding: UTF-8 -*-
编码改成UTF-8，避免中文字符不能输出。

	import MySQLdb,cgi,time,datetime
#time，datetime模块

	today = datetime.datetime.now()
today_0 = today.strftime('%Y-%m-%d')
today_1 = (today + datetime.timedelta(days = -1)).strftime('%Y-%m-%d')
today_2 = (today + datetime.timedelta(days = -2)).strftime('%Y-%m-%d')
today_3 = (today + datetime.timedelta(days = -3)).strftime('%Y-%m-%d')
today_4 = (today + datetime.timedelta(days = -4)).strftime('%Y-%m-%d')
today_5 = (today + datetime.timedelta(days = -5)).strftime('%Y-%m-%d')
today_6 = (today + datetime.timedelta(days = -6)).strftime('%Y-%m-%d')
#定义最近一周的时间

	header = 'Content-Type: text/html\n\n'
url = '/cgi-bin/test_web2.py'
#定义html头文件和url

	formhtml = '''<br />
rsync_backup
The Backup List: %sPlease Input Module Name: 
	Please enter the date(custom): 


	Please enter the date: 
%s

	'''
#定义首页
#action 处的“hidden”变量，这里的值为“edit”。决定显示哪个页面（表单页面或是结果页面）
#可以查看url路径值验证。

	fradio = ' %s\n'
def showForm(who, howmany):
    friends = ''
    for i in [today_0,today_1,today_2,today_3,today_4,today_5,today_6]:
        checked = ''
        if str(i) == howmany:
            checked = 'CHECKED'
        friends = friends + fradio % (str(i), checked, str(i))
    print header + formhtml % (who, url, who, howmany, friends)
#操作html按钮的函数
#变量fradio，用来创建单选按钮的字符串

	reshtml_01 = '''
rsync_backup
The Backup List: %s
Your name is: %s
	
The current date: %s

	Click here to edit your data again.

			
			
			
			ID号
			
			日期
			
			开始时间
			
			结束时间
			
			模块名
			
			总文件数
			
			传输文件数
			
			总文件大小
			
			传输文件大小
			
			错误备注
			
			
			
			
			
			
			
			%s
			
			%s
			
			%s
			
			%s
			
			%s
			
			%s
			
			%s
			
			%s
			
			%s
			
			%s
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
		
	





















  
    
    
    
    
    
    
    
    
    
    
  
'''
#定义一个表头
#style="border:black solid 1px;border-collapse:collapse"的作用是把边框设置为1px

	reshtml_02 = '''
  
    
    
    
    
    
    
    
    
    
    
  
'''    
#定义每一行的格式，nowrap="nowrap"的意思是，内容不自动换行。

	def doResults(who, howmany, today_now):
    n=1
    print header + reshtml_01 % (who, who, howmany, url)
#首先打印头文件和reshtml_01页面
    db_conn=MySQLdb.connect(host='127.0.0.1',user='root',passwd='',db='test')
    db_curs=db_conn.cursor()
#创建数据库连接和游标
    if who == '':
        db_curs.execute("SELECT id,date_ymd,s_time,e_time,mod_name,files,files_traned,filesize,filesize_traned,a_error \
                         FROM bak_stat where date_ymd='%s' " % today_now )
        for data in db_curs.fetchall():
            if data[9] == '':
                print reshtml_02 % (0,data[1],data[2],data[3],data[4], \
                                    format(data[5],','),format(data[6],','),format(data[7],','),format(data[8],','),data[9])
            else:
                print reshtml_02 % (0,data[1],data[2],data[3],data[4],data[5],data[6],data[7],data[8],data[9])
            n+=1
#设置一个ID编号，从1开始，统计当天的备份计数，如果读data[0],则是数据库总的计数。
    else:
        db_curs.execute("SELECT id,date_ymd,s_time,e_time,mod_name,files,files_traned,filesize,filesize_traned,a_error \
                         FROM bak_stat where mod_name='%s' " % who )
        for data in db_curs.fetchall():
            if data[9] == '':
                print reshtml_02 % (n,data[1],data[2],data[3],data[4], \
                                    format(data[5],','),format(data[6],','),format(data[7],','),format(data[8],','),data[9])
            else:
                print reshtml_02 % (n,data[1],data[2],data[3],data[4],data[5],data[6],data[7],data[8],data[9])
            n+=1
#format为格式化千分位分隔符，但是测试用的python2.7版本，因为在python2.4中，还没有加入format这个内置函数。
#data是形如 (2L, datetime.date(2010, 11, 23), datetime.timedelta(0, 36866), datetime.timedelta(0, 36866), 'mytest1', 3L, 0L, 17696256L, 0L, '') 这样的一行数组。L代表长整型。
#判断，如果who变量为空，则执行……，否则
    db_curs.close()
    db_conn.close()
def process():
    error = ''
    form = cgi.FieldStorage()
    
    if form.has_key('person'):
        who = form['person'].value
    else:
        who = ''
    if form.has_key('howmany'):
        howmany = form['howmany'].value
    else:
        howmany = ''
    if form.has_key('action'):
        doResults(who, howmany,howmany)
    else:
        showForm(who, howmany)
#重点：
#1·FieldStorage是cgi中的主要函数，它完成所有工作。
#2·form = cgi.FieldStorage()表示实例化了这个类。之后，会从浏览器读取输入的信息。
#3·被实例化后，包含一个类似字典的对象，具有一系列的键-值对，键就是通过表单传入的表单条目的名字，而值则包含相应的数据。
#4·说明，person——键，form['person'].value——值
#5·如果form.has_key('action')，action键存在，就执行doResults语句

	if __name__ == '__main__':
    process()

              
			  
			  
				
window._bd_share_config={"common":{"bdSnsKey":{},"bdText":"","bdMini":"2","bdMiniList":false,"bdPic":"","bdStyle":"0","bdSize":"16"},"share":{}};with(document)0[(getElementsByTagName('head')[0]||body).appendChild(createElement('script')).src='http://bdimg.share.baidu.com/static/api/js/share.js?v=89860593.js?cdnversion='+~(-new Date()/36e5)];
				
			  
              阅读(2396) | 评论(0) | 转发(0) |
			                
            
              0
              上一篇：利用脚本，新建一个rsync服务
              下一篇：备份程序_FAQ    
            
		给主人留下些什么吧！~~
				
				
		
        		
		
        
          评论热议
		  		 
        
           请登录后评论。
            登录 注册
          
        
       
		
        
        
            
        
      
    关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册
      Copyright  2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有 
      感谢所有关心和支持过ChinaUnix的朋友们
        16024965号-6 
      
    
  ID号日期开始时间结束时间模块名总文件数传输文件数总文件大小(byte)传输文件大小(byte)错误备注
%s%s%s%s%s%s%s%s%s%s

                                   
            
            
            
            
            
          
          		  
        
      
      
    
  
  


  	//测试字符串的长度 一个汉字算2个字节
	function mb_strlen(str)
	{
		var len=str.length;
		var totalCount=0;
		for(var i=0;i<len;i++)
		{
			var c = str.charCodeAt(i);
			if ((c >= 0x0001 && c <= 0x007e) || (0xff60<=c && c<=0xff9f)) {
				totalCount++;
			}else{
				totalCount+=2;
			}
		}
		return totalCount;
	}
	/*
	var Util = {};
	Util.calWbText = function (text, max){
		if(max === undefined)
			max = 500;
		var cLen=0;
		var matcher = text.match(/[^\x00-\xff]/g),
			wlen  = (matcher && matcher.length) || 0;
		//匹配url链接正则 http://***
		var pattern = /http:\/\/([\w-]+\.)+[\w-]+(\/*[\w-\.\/\?%&=][^\s^\u4e00-\u9fa5]*)?/gi;
		//匹配的数据存入数组
		var arrPt = new Array();
		var i = 0;
		while((result = pattern.exec(text)) != null){
			arrPt[i] = result[0];
			i++;
		}
		//替换掉原文本中的链接
		for(var j = 0;j<arrPt.length;j++){
			text = text.replace(arrPt[j],"");
		}
		//减掉链接所占的长度
		return Math.floor((max*2 - text.length - wlen)/2 - 12*i);
	};
	*/
	var allowComment = '0';
	
	//举报弹出层
	function showJuBao(url, cid){
		
			$.cover(false);
			asyncbox.open({
				id  : 'report_thickbox',
				url : url,
				title : '举报违规',
				width : 378,
				height : 240,
				scroll : 'no',
				data : {
					'cid'	 : cid,
					'idtype' : 2 ,
                                        'blogurl' : window.location.href
				},
				callback : function(action){
					if(action == 'close'){
						$.cover(false);
					}
				}
			});
	}

	$(function(){

		//创建管理员删除的弹出层
		$('#admin_article_del').click(function(){
			$.cover(false);
			asyncbox.open({
				id : 'class_thickbox',
				html : '<div class="HT_layer3_1"><ul><li class="HT_li1">操作原因：<select class="HT_sel7" id="del_type" name="del_type"><option value="广告文章">广告文章</option><option value="违规内容">违规内容</option><option value="标题不明">标题不明</option><option value="文不对题">文不对题</option></select></li><li class="HT_li1" ><input class="HT_btn4" id="admin_delete"  type="button" /></li></ul></div>',
				title : '选择类型',
				width : 300,
				height : 150,
				scroll : 'no',
				callback : function(action){
					if(action == 'close'){
						$.cover(false);
					}
				}
			});
		});
		$('#admin_delete').live('click' , function(){
			///blog/logicdel/id/3480184/url/%252Fblog%252Findex.html.html
			var type = $('#del_type').val();
			var url = '/blog/logicdel/id/96079/url/%252Fuid%252F16844903.html.html';
			window.location.href= url + '?type=' + type;
		});


		//顶  js中暂未添加&过滤 
		$('#digg').live('click' , function(){

			if(isOnLine == '' )
			{
				//showErrorMsg('登录之后才能进行此操作' , '消息提示');
				showErrorMsg('操作失败,您需要先登录!', '消息提示', 'http://account.chinaunix.net/login');
				return false;
			}

			var bid = $('#digg').attr('bid');
			var url = $('#digg').attr('url');

			var digg_str = $.cookie('digg_id');
			if(digg_str != null)
			{
				var arr= new Array(); //定义一数组

				arr = digg_str.split(","); //字符分割     
				for( i=0 ; i < arr.length ; i++ )   
				{   
					if(bid == arr[i])
					{
						showErrorMsg('已经赞过该文章', '消息提示'); 
						return false;
					}
				} 
			}
			$.ajax({
				type:"POST",
				url:url,	
				data: {
					'bid' : bid 
				},
				dataType: 'json',
				success:function(msg){
					if(msg.error == 0)
					{
						var num = parseInt($('#digg_num').html(),10);
						num += 1;
						$('#digg_num').html(num);
						$('#digg').die();

						if(digg_str == null)
						{
							$.cookie('digg_id', bid, {expires: 30 , path: '/'});
						}
						else
						{
							$.cookie('digg_id', digg_str + ',' + bid, {expires: 30 , path: '/'});
						}
						showSucceedMsg('谢谢' , '消息提示');
					}
					else if(msg.error == 1)
					{
						//showErrorMsg(msg.error_content , '消息提示'); 
						showErrorMsg('操作失败,您需要先登录!', '消息提示', 'http://account.chinaunix.net/login');
					}
					else if(msg.error == 2)
					{
						showErrorMsg(msg.error_content , '消息提示'); 
					}
				}
			});
		});
		//举报弹出层
		/*$('.box_report').live('click' , function(){
			if(isOnLine == '' )
			{
				//showErrorMsg('登录之后才能进行此操作' , '消息提示');
				showErrorMsg('操作失败,您需要先登录!', '消息提示', 'http://account.chinaunix.net/login');
				return false;
			}
			var url = $('#report_url').val();
			var cid = $(this).attr('cid');
			$.cover(false);
			asyncbox.open({
				id  : 'report_thickbox',
				url : url,
				title : '举报违规',
				width : 378,
				height : 240,
				scroll : 'no',
				data : {
					'cid'	 : cid,
					'idtype' : 2 
				},
				callback : function(action){
					if(action == 'close'){
						$.cover(false);
					}
				}
			});
		});*/


		//评论相关代码
		
		//点击回复显示评论框
		$('.Blog_a10').live('click' , function(){
			if(isOnLine == '' )
			{
				//showErrorMsg('登录之后才能进行此操作' , '消息提示');
				showErrorMsg('操作失败,您需要先登录!', '消息提示', 'http://account.chinaunix.net/login');
				return false;
			}

			if(allowComment == 1)
			{
				showErrorMsg('该博文不允许评论' , '消息提示'); 
				return false;
			}
			var tid = $(this).attr('toid');//留言作者id
			var bid = $(this).attr('bid');//blogid
			var cid = $(this).attr('cid');//留言id
			var tname = $(this).attr('tname');
                         			var tpl  = '<div class="Blog_right1_9">';
				tpl +=	 '<div class="div2">';
				tpl +=     '<textarea name="" cols="" rows="" class="Blog_ar1_1" id="rmsg">文明上网，理性发言...</textarea>';
				tpl +=	 '</div>';
				tpl +=   '<div class="div3">';
				tpl +=		'<div class="div3_2"><a href="javascript:void(0);" class="Blog_a11" id="quota_sbumit" url="/Comment/PostComment.html" tid="'+tid+'" bid="'+bid+'" cid="'+cid+'" tname="'+tname+'" ></a><a href="javascript:void(0)" id="qx_comment" class="Blog_a12"></a></div>';
				tpl +=		'<div class="div3_1"><a href="javascript:void(0);" id="mface"><span></span>表情</a></div>';
				tpl +=		'<div class="clear"></div>';
				tpl +=	 '</div>';
				tpl +=  '</div>';
                                 			$('.z_move_comment').html('');
			$(this).parents('.Blog_right1_8').find('.z_move_comment').html(tpl).show();
		});
		//引用的评论提交
		$('#quota_sbumit').live('click' , function(){

			if(isOnLine == '' )
			{
				//showErrorMsg('登录之后才能进行此操作' , '消息提示');
				showErrorMsg('操作失败,您需要先登录!', '消息提示', 'http://account.chinaunix.net/login');
				return false;
			}

			var bid   = $(this).attr('bid');
			var tid   = $(this).attr('tid');//被引用人的id
			var qid   = $(this).attr('cid');//引用的id
			var url = $(this).attr('url');
			var text = $('#rmsg').val();
			var tname = $(this).attr('tname');
			if(text == '' || text=='文明上网，理性发言...')
			{
				showErrorMsg('评论内容不能为空！' , '消息提示'); 
				return false;
			}
			else
			{
				if(mb_strlen(text) > 1000){
					showErrorMsg('评论内容不能超过500个汉字' , '消息提示'); 
					return false;
				}
			}
		    $.ajax({
		        type: "post",
			    url: url ,
			    data: {'bid': bid , 'to' : tid , 'qid' : qid , 'text': text , 'tname' : tname },
				dataType: 'json',
			    success: function(data){
				    if(data.code == 1){
						var tpl =  '<div class="Blog_right1_8">';
							tpl+=     '<div class="Blog_right_img1"><a href="' +data.info.url+ '" >' + data.info.header + '</a></div>';
							tpl+=     '<div class="Blog_right_font1">';
							tpl+=         '<p class="Blog_p5"><span><a href="' +data.info.url+ '" >' + data.info.username + '</a></span>' + data.info.dateline + '</p>';
							tpl+=         '<p class="Blog_p7"><a href="' + data.info.quota.url + '">' + data.info.quota.username + '</a>：'+ data.info.quota.content + '</p>';
							tpl+=         '<p class="Blog_p8">' + data.info.content + '</p><span class="span_text1"><a href="javascript:void(0);" class="Blog_a10" toid=' + data.info.fuid + ' bid=' + data.info.bid + ' cid=' + data.info.cid + '  tname = ' + data.info.username + ' >回复</a> | 　<a class="comment_del_mark" style="cursor:pointer" url="' + data.info.delurl + '" >删除</a>　| 　<a href="javascript:showJuBao(\'/blog/ViewReport.html\','+data.info.cid+')" class="box_report" cid="' + data.info.cid + '" >举报</a></span></div>';
							tpl+=         '<div class="z_move_comment" style="display:none"></div>';
							tpl+=	      '<div class="Blog_line1"></div></div>';
							$('#replyList .Blog_right1_8:first').before(tpl);
							$('.z_move_comment').html('').hide();
				    }
					else if(data.code == -1){
						//showErrorMsg(data.info , '消息提示'); 
						showErrorMsg('操作失败,您需要先登录!', '消息提示', 'http://account.chinaunix.net/login');
			        }
                },
			    error: function(){//请求出错处理
                        
                }
			});
		});
		//底部发表评论
		$('#submitmsg').click(function(){
			if(allowComment == 1)
			{
				showErrorMsg('该博文不允许评论' , '消息提示'); 
				return false;
			}
			var bid   = $(this).attr('bid');
			var toid  = $(this).attr('toid');
			var text = $('#reply').val();
			var url = $(this).attr('url');
			if(text == '' || text=='文明上网，理性发言...')
			{
				showErrorMsg('评论内容不能为空！' , '消息提示'); 
				return false;
			}
			else
			{
				if(mb_strlen(text) > 1000){
					showErrorMsg('评论内容不能超过500个汉字' , '消息提示'); 
					return false;
				}
			}
		    $.ajax({
		        type: "post",
			    url: url ,
			    data: {'bid': bid , 'to' : toid ,'text': text},
				dataType: 'json',
			    success: function(data){
				    if(data.code == 1)
					{
						var tpl   = '<div class="Blog_right1_8">';
							tpl  +=   '<div class="Blog_right_img1"><a href="' +data.info.url+ '" >' + data.info.header + '</a></div>';
							tpl  +=	  '<div class="Blog_right_font1">';
							tpl  +=       '<p class="Blog_p5"><span><a href="' +data.info.url+ '" >' + data.info.username + '</a></span>' + data.info.dateline + '</p>';
							tpl  +=       '<p class="Blog_p6">' + data.info.content + '</p>';
							tpl  +=		  '<div class="div1"><a href="javascript:void(0);" class="Blog_a10"  toid=' + data.info.fuid + ' bid=' + data.info.bid + ' cid=' + data.info.cid + '>回复</a> | 　<a class="comment_del_mark" style="cursor:pointer" url="' + data.info.delurl + '">删除</a>　| 　<a href="javascript:showJuBao(\'/blog/ViewReport.html\','+data.info.cid+')" class="box_report" cid="' + data.info.cid + '">举报</a></div>';
							tpl  +=		  '<div class="z_move_comment" style="display:none"></div>';
							tpl  +=    '</div><div class="Blog_line1"></div></div>';
							$('.Blog_tit3:first').after(tpl);
							$('#reply').val('文明上网，理性发言...');
					}
					else if(data.code == -1)
					{
						showErrorMsg(data.info , '消息提示'); 
			        }
                },
			    error: function(){//请求出错处理
                        
                }
		    });
			
		});
		//底部评论重置
		$('#reset_comment').click(function(){
			$('#reply').val('文明上网，理性发言...');
		});
		//取消回复
		$('#qx_comment').live('click' , function(){
			$('.z_move_comment').html('').hide();
		});


		$('#rmsg, #reply').live({
		    focus:function(){
			    if($(this).val() == '文明上网，理性发言...'){
			        $(this).val('');
			    }
			},
			blur:function(){
		        if($(this).val() == ''){
			        $(this).val('文明上网，理性发言...');
			    }
			}
		});
		//删除留言确认
		$('.comment_del_mark').live('click' , function(){
			var url = $(this).attr('url');
			asyncbox.confirm('删除留言','确认', function(action){
				if(action == 'ok')
				{
					location.href = url;
				}
			});
		});
		//删除时间确认
		$('.del_article_id').click(function(){
			var delurl = $(this).attr('delurl');
			asyncbox.confirm('删除文章','确认', function(action){
				if(action == 'ok')
				{
					location.href = delurl;
				}
			});
		});
		/*
		//字数限制
		$('#rmsg, #reply').live('keyup', function(){
			var id = $(this).attr('id');
			var left = Util.calWbText($(this).val(), 500);
			var eid = '#errmsg';
			
			if(id == 'reply') eid =  '#rerrmsg';
			if (left >= 0)
		        $(eid).html('您还可以输入<span>' + left + '</span>字');
		    else
		        $(eid).html('<font color="red">您已超出<span>' + Math.abs(left) + '</span>字 </font>');
		});
		*/
		//加载表情
	    $('#face').qqFace({id : 'facebox1', assign : 'reply', path : '/image/qqface/'});
	    $('#mface').qqFace({id : 'facebox', assign : 'rmsg', path:'/image/qqface/'});
	    
		/*
		$('#class_one_id').change(function(){
			alert(123213);
			var id = parseInt($(this).val() , 10);
			if(id == 0) return false;
			$('.hidden_son_class span').each(function( index , dom ){
				if( dom.attr('cid')  == id )
				{
				}
			});
		});
		*/
		//转载文章
		var turn_url = "/blog/viewClassPart.html";
		$('#repost_bar').click(function(){
			if(isOnLine == '' )
			{
				//showErrorMsg('登录之后才能进行此操作' , '消息提示');
				showErrorMsg('操作失败,您需要先登录!', '消息提示', 'http://account.chinaunix.net/login');
				return false;
			}
			var id = $(this).attr('bid');
			asyncbox.open({
				id  : 'turn_class_thickbox',
				url : turn_url,
				title : '转载文章',
				width : 330,
				height : 131,
				scroll : 'no',
				data : {
					'id'	 : id
				},
				callback : function(action){
					if(action == 'close'){
						$.cover(false);
					}
				}
			});
		});
		/*
	    //转发文章
	    $('#repost_bar').live('click' , function(){
			if(isOnLine == '' )
			{
				//showErrorMsg('登录之后才能进行此操作' , '消息提示');
				showErrorMsg('操作失败,您需要先登录!', '消息提示', 'http://account.chinaunix.net/login');
				return false;
			}
	    	var bid  = $(this).attr('bid');
	    	var url  = $(this).attr('url');
	    	asyncbox.confirm('转载文章','确认', function(action){
	    	  if(action == 'ok'){
	    	    $.ajax({
				type:"POST",
				url:url,	
				data: {
					'bid' : bid 
				},
				dataType: 'json',
				success:function(msg){
				  if(msg.error == 0){
				    showSucceedMsg('转发成功！', '消息提示');
				  }else if(msg.error == 1){
				    //location.href = '/index.php?r=site/login';
					showErrorMsg('操作失败,您需要先登录!', '消息提示', 'http://account.chinaunix.net/login');
				  }else{
				    showErrorMsg(msg.error_content, '消息提示');
			      }
				}
			  });
	    	  }
	    	});

		});
		*/

	});




SyntaxHighlighter.autoloader(
	'applescript			/highlight/scripts/shBrushAppleScript.js',
	'actionscript3 as3		/highlight/scripts/shBrushAS3.js',
	'bash shell				/highlight/scripts/shBrushBash.js',
	'coldfusion cf			/highlight/scripts/shBrushColdFusion.js',
	'cpp c					/highlight/scripts/shBrushCpp.js',
	'c# c-sharp csharp		/highlight/scripts/shBrushCSharp.js',
	'css					/highlight/scripts/shBrushCss.js',
	'delphi pascal			/highlight/scripts/shBrushDelphi.js',
	'diff patch pas			/highlight/scripts/shBrushDiff.js',
	'erl erlang				/highlight/scripts/shBrushErlang.js',
	'groovy					/highlight/scripts/shBrushGroovy.js',
	'java					/highlight/scripts/shBrushJava.js',
	'jfx javafx				/highlight/scripts/shBrushJavaFX.js',
	'js jscript javascript	/highlight/scripts/shBrushJScript.js',
	'perl pl				/highlight/scripts/shBrushPerl.js',
	'php					/highlight/scripts/shBrushPhp.js',
	'text plain				/highlight/scripts/shBrushPlain.js',
	'py python				/highlight/scripts/shBrushPython.js',
	'ruby rails ror rb		/highlight/scripts/shBrushRuby.js',
	'scala					/highlight/scripts/shBrushScala.js',
	'sql					/highlight/scripts/shBrushSql.js',
	'vb vbnet				/highlight/scripts/shBrushVb.js',
	'xml xhtml xslt html	/highlight/scripts/shBrushXml.js'
);
SyntaxHighlighter.all();


function code_hide(id){
	var code = document.getElementById(id).style.display;
	if(code == 'none'){
		document.getElementById(id).style.display = 'block';
	}else{
		document.getElementById(id).style.display = 'none';
	}
}



 lastScrollY=0;
 function heartBeat(){
 var diffY;
 if (document.documentElement && document.documentElement.scrollTop)
     diffY = document.documentElement.scrollTop;
 else if (document.body)
     diffY = document.body.scrollTop
 else
     {/*Netscape stuff*/}
 percent=.1*(diffY-lastScrollY);
 if(percent>0)percent=Math.ceil(percent);
 else percent=Math.floor(percent);
 document.getElementById("full").style.top=parseInt(document.getElementById("full").style.top)+percent+"px";
 lastScrollY=lastScrollY+percent;
 if(lastScrollY<200)
 {
 document.getElementById("full").style.display="none";
 }
 else
 {
 document.getElementById("full").style.display="block";
 }
 }
 var gkuan=document.body.clientWidth;
 var ks=(gkuan-960)/2-30;
 suspendcode="<div id=\"full\" style='right:-30px;POSITION:absolute;TOP:500px;z-index:100;width:26px; height:86px;cursor:pointer;'><a href=\"javascript:void(0)\" onclick=\"window.scrollTo(0,0);\"><img src=\"\/image\/top.png\" /></a></div>"
 document.write(suspendcode);
 window.setInterval("heartBeat()",1);
 
  
  



//全局错误提示弹出框
function showErrorMsg(content, title, url){
	var url = url || '';
	var title = title || '消息提示';
	var html = '';
	html += '<div class="HT_layer3_1 HT_layer3_2"><ul><li><p><span class="login_span1"></span>' + content + '</p></li>';
	if(url == '' || url.length == 0){
		html += '<li class="HT_li1"><input type="button" class="HT_btn2"  onclick=\'close_windows("error_msg")\'></li>';
	} else {
		html += '<li class="HT_li1"><input type="button" class="login_btn1" onclick="location.href=\'' + url + '\'"></li>';
	}
	html += '</ul></div>';
	$.cover(true);
	   asyncbox.open({
		 id: 'error_msg',
		 title : title,
		 html : html,
		 'callback' : function(action){
			 if(action == 'close'){
				 $.cover(false);
			 }
		 }
	});
}

//全局正确提示
function showSucceedMsg(content, title , url ){
	var url = url || '';
	var title = title || '消息提示';
	var html = '';
	html += '<div class="HT_layer3_1 HT_layer3_2"><ul><li><p><span class="login_span2"></span>' + content + '</p></li>';
	if(url == '' || url.length == 0){
		html += '<li class="HT_li1"><input type="button" class="HT_btn2"  onclick=\'close_windows("error_msg")\'></li>';
	} else {
		html += '<li class="HT_li1"><input type="button" class="HT_btn2" onclick="location.href=\'' + url + '\'"></li>';
	}
	html += '</ul></div>';
	$.cover(true);
	asyncbox.open({
		 id: 'error_msg',
		 title : title,
		 html : html,
		 'callback' : function(action){
			 if(action == 'close'){
				 $.cover(false);
			 }
		 }
	});
}

//关闭指定id的窗口
function close_windows(id){
	$.cover(false);
	$.close(id);
}


//公告
var tID;
var tn;                        // 高度
var nStopTime = 5000;        // 不同行间滚动时间隔的时间，值越小，移动越快
var nSpeed = 50;            // 滚动时，向上移动一像素间隔的时间，值越小，移动越快
var isMove = true;
var nHeight = 25;
var nS = 0;
var nNewsCount = 3;

/**
 * n 用于表示是否为第一次运行
 **/
function moveT(n)
{
    clearTimeout(tID)
    var noticev2 = document.getElementById("noticev2")
    nS = nSpeed;

    // 只在第一次调用时运行，初始化环境（有没有参数）
    if (n)
    {
        // 设置行高
        noticev2.style.lineHeight = nHeight + "px";
        // 初始化显示位置
        tn = 0;
        // 刚进入时在第一行停止时间
        nS = nStopTime;
    }

    // 判断鼠标是否指向层
    if (isMove)
    {
        // 向上移动一像素
        tn--;
        // 如果移动到最下面一行了，则移到顶行
        if (Math.abs(tn) == nNewsCount * nHeight)
        {
            tn = 0;
        }
        // 设置位置
        noticev2.style.marginTop = tn + "px";
        // 完整显示一行时，停止一段时间
        if (tn % nHeight == 0)
        {
            nS = nStopTime;
        }
    }

    tID = setTimeout("moveT()", nS);
}
moveT(1);    // 此处可以传入任何参数


//  var _gaq = _gaq || [];
//  _gaq.push(['_setAccount', 'UA-20237423-2']);
//  _gaq.push(['_setDomainName', '.chinaunix.net']);
//  _gaq.push(['_trackPageview']);
//
//  (function() {
//    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
//    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
//    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
//  })();



var _bdhmProtocol = (("https:" == document.location.protocol) ? " https://" : " http://");
document.write(unescape("%3Cscript src='" + _bdhmProtocol + "hm.baidu.com/h.js%3F0ee5e8cdc4d43389b3d1bfd76e83216b' type='text/javascript'%3E%3C/script%3E"));

function link(t){
     var href= $(t).attr('href');
     href+="?url="+encodeURIComponent(location.href);
     $(t).attr('href',href);
    //setCookie("returnOutUrl", location.href, 60, "/");
}












'''
reshtml_02 = '''












'''
def doResults(who, howmany, today_now):
    n=1
    print header + reshtml_01 % (who, who, howmany, url)
    db_conn=MySQLdb.connect(host='127.0.0.1',user='root',passwd='',db='test')
    db_curs=db_conn.cursor()
    if who == '':
        db_curs.execute("SELECT id,date_ymd,s_time,e_time,mod_name,files,files_traned,filesize,filesize_traned,a_error \
                         FROM bak_stat where date_ymd='%s' " % today_now )
        for data in db_curs.fetchall():
            if data[9] == '':
                print reshtml_02 % (n,data[1],data[2],data[3],data[4], \
                                    format(data[5],','),format(data[6],','),format(data[7],','),format(data[8],','),data[9])
            else:
                print reshtml_02 % (n,data[1],data[2],data[3],data[4],data[5],data[6],data[7],data[8],data[9])
            n+=1
    else:
        db_curs.execute("SELECT id,date_ymd,s_time,e_time,mod_name,files,files_traned,filesize,filesize_traned,a_error \
                         FROM bak_stat where mod_name='%s' " % who )
        for data in db_curs.fetchall():
            if data[9] == '':
                print reshtml_02 % (n,data[1],data[2],data[3],data[4], \
                                    format(data[5],','),format(data[6],','),format(data[7],','),format(data[8],','),data[9])
            else:
                print reshtml_02 % (n,data[1],data[2],data[3],data[4],data[5],data[6],data[7],data[8],data[9])
            n+=1
    db_curs.close()
    db_conn.close()
def process():
    error = ''
    form = cgi.FieldStorage()

    if form.has_key('person'):
        who = form['person'].value
    else:
        who = ''

    if form.has_key('howmany'):
        howmany = form['howmany'].value
    else:
        howmany = ''

    if form.has_key('action'):
        doResults(who, howmany,howmany)
    else:
        showForm(who, howmany)

if __name__ == '__main__':
    process()