def show(request, page_num): user, email, usernum = request.user.username.split("|")[:] config['user'] = user count = 0 cursor = connection.cursor() sql = "select count(id) from task_content" cursor.execute(sql) row = cursor.fetchone() limit = 15 if not page_num: page_num = 1 else: page_num = int(page_num) start, end = 0, 0 start = (page_num - 1) * limit end = start + limit count = int(row[0] / limit) + 1 next = page_num + 1 if page_num < 2: page_num = 1 last = page_num next = 1 else: last = page_num - 1 id = 0 if end > row[0]: end = row[0] #print start, end data = {} percent_id_list = [] result = Content.objects.order_by('-id')[start:end] result = result.values() for row in result: percent_id_list.append(row['id']) if row['create_time']: row['create_time'] = time.strftime( '%Y-%m-%d %H:%M:%S', time.localtime(int(row['create_time']))) if row['deploy_time']: row['deploy_time'] = time.strftime( '%Y-%m-%d %H:%M:%S', time.localtime(int(row['deploy_time']))) if row['finish_time']: row['finish_time'] = time.strftime( '%Y-%m-%d %H:%M:%S', time.localtime(int(row['finish_time']))) if row['status'] > 100: p = Percent(int(row['id']), row['project'], row['project'], str(row['env'])) p.analyze() #print row['status'] cf_status_list = [] for cf in Configuration.objects.filter( project=row['project']).values(): if cf['status'] < 100: cf_status_list.append(cf['status']) if row['status'] < 100 and row['status'] not in cf_status_list: row['status'] = 100 try: status_str = Configuration.objects.filter( project=row['project'], status=row['status']).values()[0]['name'] except IndexError, e: status_str = "status error: %s" % row['status'] if 0 < row['status'] < 100: row['status_str'] = u"待%s审批" % status_str else: row['status_str'] = status_str #row['status_str'] = "" row['status_str'].encode('utf-8') #print row['project'], row['status'] approve_user = get_approve_user(row['project'], row['status']) #print row['id'],user,approve_user row['deploy_approve'] = 0 if user in approve_user: row['approve'] = 1 else: row['approve'] = 0 #print row['id'],row['status'],row['approve'] if row['status'] >= 100: #added deploy limit if row['approve'] == 1: row['deploy_approve'] = 1 else: row['deploy_approve'] = 0 #print row['id'], row['approve'], row['deploy_approve'] #percent query row['percent'] = {} for pj in Project.objects.filter( name=row['project'], type=row['type']).order_by('gradation').values(): row['percent'][pj['gradation']] = percent_string(pj['gradation']) row['env'] = percent_string(row['env']) data[id] = {} data[id] = row id += 1
status = "" if row['status'] == "running": status = "progress progress-striped active" elif row['status'] == "success": status = "progress progress-success" if row['percent'] == 0: result = "" else: result = """ <div class="%s"> <div class="bar" style="width: %d%%;"></div> </div> """ % (status, row['percent']) for row in Content.objects.filter(id=id).values(): pass p = Percent(id, row['project'], row['project'], str(row['env'])) p.analyze() return HttpResponse(result)
def show(request,page_num): user, email, usernum = request.user.username.split("|")[:] config['user'] = user count = 0 cursor = connection.cursor() sql = "select count(id) from task_content" cursor.execute(sql) row = cursor.fetchone() limit = 15 if not page_num: page_num = 1 else: page_num = int(page_num) start, end = 0,0 start = (page_num-1) * limit end = start + limit count = int(row[0]/limit)+1 next = page_num+1 if page_num < 2: page_num = 1 last = page_num next = 1 else: last = page_num-1 id = 0 if end > row[0]: end = row[0] #print start, end data = {} percent_id_list = [] result = Content.objects.order_by('-id')[start:end] result = result.values() for row in result: percent_id_list.append(row['id']) if row['create_time']: row['create_time'] = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(int(row['create_time']))) if row['deploy_time']: row['deploy_time'] = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(int(row['deploy_time']))) if row['finish_time']: row['finish_time'] = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(int(row['finish_time']))) if row['status'] > 100: p = Percent(int(row['id']), row['project'], row['project'], str(row['env'])) p.analyze() #print row['status'] cf_status_list = [] for cf in Configuration.objects.filter(project=row['project']).values(): if cf['status'] < 100: cf_status_list.append(cf['status']) if row['status'] < 100 and row['status'] not in cf_status_list: row['status'] = 100 try: status_str = Configuration.objects.filter(project=row['project'], status=row['status']).values()[0]['name'] except IndexError, e: status_str = "status error: %s" % row['status'] if 0 < row['status'] < 100: row['status_str'] = u"待%s审批" % status_str else: row['status_str'] = status_str #row['status_str'] = "" row['status_str'].encode('utf-8') #print row['project'], row['status'] approve_user = get_approve_user(row['project'], row['status']) #print row['id'],user,approve_user row['deploy_approve'] = 0 if user in approve_user: row['approve'] = 1 else: row['approve'] = 0 #print row['id'],row['status'],row['approve'] if row['status'] >= 100: #added deploy limit if row['approve'] == 1: row['deploy_approve'] = 1 else: row['deploy_approve'] = 0 #print row['id'], row['approve'], row['deploy_approve'] #percent query row['percent'] = {} for pj in Project.objects.filter(name=row['project'], type=row['type']).order_by('gradation').values(): row['percent'][pj['gradation']] = percent_string(pj['gradation']) row['env'] = percent_string(row['env']) data[id] = {} data[id] = row id += 1