# -*- coding: utf-8 -*-
# author:chenke
from method import select
from method import week
values = select()
max1 = 0
for i in xrange(len(values)):
max2 = max(week(values[i][2]))
max1 = max(max1, max2)
print range(max1)
# -*- coding: utf-8 -*-
# author:chenke
from xlwt import *
import xlwt
from method import select
from method import week
from method import show
from method import lesson
import os
# 选取最大周数
values = select()
max1 = 0
for i in xrange(len(values)):
max2 = max(week(values[i][3]))
max1 = max(max1, max2)
print max1
for inputs in xrange(1, max1 + 1):
# 打开excel
w = Workbook()
ws = w.add_sheet(u'值班')
# 第一列宽
first_col = ws.col(0)
first_col.width = 256 * 2
# 第二列宽
second_col = ws.col(1)
second_col.width = 256 * 11
# 星期一到星期五列宽
for i in xrange(5):
C1=[]
C2=[]
C3=[]
D1=[]
D2=[]
D3=[]
E1=[]
E2=[]
E3=[]
# 分发数据到对应数组
values = select()
for i in xrange(len(values)):
for wek in week(values[i][3]):
if wek == inputs:
if lesson(values[i][4]) == u'1' or lesson(values[i][4]) == u'2' or lesson(values[i][4]) == u'3' or lesson(values[i][4]) == u'4' or lesson(values[i][4]) == u'5':
if values[i][4].find(u'一')!=-1:
print 1
A1.append(values[i][1]+u'\n')
elif values[i][4].find(u'二')!=-1:
print 2
B1.append(values[i][1]+u'\n')
elif values[i][4].find(u'三')!=-1:
print 3
C1.append(values[i][1]+u'\n')
elif values[i][4].find(u'四')!=-1:
D1.append(values[i][1]+u'\n')
print 4
elif values[i][4].find(u'五')!=-1:
B1 = []
B3 = []
C1 = []
C3 = []
D1 = []
D3 = []
E1 = []
E3 = []
# 分发数据到对应数组
values = select()
for i in xrange(len(values)):
for wek in week(values[i][2]):
if wek == inputs:
if lesson(values[i][3]) == u'1' or lesson(
values[i][3]) == u'2' or lesson(
values[i][3]) == u'3' or lesson(
values[i][3]) == u'4' or lesson(
values[i][3]) == u'5':
if values[i][3].find(u'一') != -1:
print 1
A1.append(values[i][1][0:len(values[i][1]) - 4] +
u'楼' + u'\n')
elif values[i][3].find(u'二') != -1:
print 2
B1.append(values[i][1][0:len(values[i][1]) - 4] +
u'楼' + u'\n')
elif values[i][3].find(u'三') != -1: