def printWorkingHours(request, em_mail, year, month):
# user = users.get_current_user()
user = users.User(em_mail)
em_data = Employee.gql("WHERE mail = :1", user).fetch(1)
time_format = "%Y-%m-%d"
try:
bday = year + '-' + month + '-1'
endday = year + '-' + unicode(int(month) + 1) + "-1"
sdate = datetime.date.fromtimestamp(time.mktime(time.strptime(bday, time_format)))
sdate2 = datetime.date.fromtimestamp(time.mktime(time.strptime(endday, time_format)))
working_hours = WorkingHours.gql("WHERE worker = :1 AND working_date >= :2 AND working_date < :3",
user, sdate, sdate2)
template_values = {'working_hours': working_hours,
'em_data':em_data}
return render_to_response('table.html', template_values)
except:
return HttpResponse("請先選擇月份，初始畫面是所有的工讀紀錄。")
#application = webapp.WSGIApplication([('/admin/employee', MainPage),
# ('/employee/add_record', Add_Record),
# ('/employee/delete_record', Delete_Record),
# ('/employee/update_record', Update_Record),
# ('/employee/add_employee', Add_Employee),
# ('/employee/delete_employee/(.*)', Delete_Employee),
# ('/employee/update_employee/(.*)', Update_Employee),
# ('/employee/edit_employee/(.*)', Edit_Employee),
# ('/employee/show_workinghours/(.*)', Show_WorkingHours),
# ('/employee/', Personal_Record),
# ('/employee/print_workinghours/',Print_WorkingHours),
# ('/employee/show_monthrecord/', Show_Month_Record)], debug=True)
#
def addRecord(request):
bhour = int(request.POST['bhour'].split(':')[0])
ehour = int(request.POST['ehour'].split(':')[0])
bminutes = int(request.POST['bhour'].split(':')[1])
eminutes = int(request.POST['ehour'].split(':')[1])
subtotal = float((ehour-bhour) + float(eminutes-bminutes)/60)
time_format = "%Y-%m-%d"
hourly_pay = Employee.gql("WHERE mail = :1", users.get_current_user()).get().hourly_pay
working = WorkingHours()
result = WorkingHours.gql('ORDER BY id DESC').get();
working.id = result.id + 1 if result else 1
working.worker = users.get_current_user()
working.working_date = datetime.date.fromtimestamp(time.mktime(time.strptime(request.POST['date'], time_format)))
working.working_bhour = request.POST['bhour']
working.working_ehour = request.POST['ehour']
working.working_area = request.POST['area']
working.working_content = request.POST['content']
working.subtotal = subtotal
working.pay = int(subtotal * hourly_pay)
working.put()
return redirect('/employee/')
def showMonthRecord(request, em_mail, year, month):
# user = users.get_current_user()
user = users.User(em_mail)
time_format = "%Y-%m-%d"
bday = year + "-" + month + "-" + '1'
endday = year +"-" + unicode(int(month) + 1) + "-" + '1'
sdate = datetime.date.fromtimestamp(time.mktime(time.strptime(bday, time_format)))
sdate2 = datetime.date.fromtimestamp(time.mktime(time.strptime(endday, time_format)))
em_data = Employee.gql("WHERE mail = :1", user)
working_hours = WorkingHours.gql("WHERE worker = :1 AND working_date >= :2 AND working_date < :3",
user, sdate, sdate2)
total_hour = 0
total_pay = 0
for work in working_hours:
total_hour += work.subtotal
total_pay += work.pay
if user:
template_values = {'userName': users.get_current_user().nickname().split('@')[0],
'logout': users.create_logout_url('/'),
'em_data': em_data,
'working_hours': working_hours,
'total_hour': total_hour,
'total_pay': total_pay,
'select_year': year,
'select_month': month,
'em_mail': user.email()
}
return render_to_response('admin/employee/browse_employee.html', template_values)
def personalRecord(request):
user = users.get_current_user()
em_data = Employee.gql("WHERE mail = :1", user)
if not em_data.count(1):
return HttpResponse('系統找不到您的的資料。')
working_hours = WorkingHours.gql("WHERE worker = :1", user)
total_pay = 0
total_hour = 0
for work in working_hours:
total_pay += work.pay
total_hour += work.subtotal
if user:
template_values = {
'userName': users.get_current_user().nickname().split('@')[0],
'logout': users.create_logout_url('/'),
'em_data': em_data,
'working_hours': working_hours,
'total_pay': total_pay,
'total_hour': total_hour,
'em_mail': user.email()
}
return render_to_response('employee/employee.html', template_values)
def Delete_Record(request):
delete_id = request.POST['delete_id']
worker = request.POST['worker']
results = WorkingHours.gql("WHERE id = :1", int(delete_id))
for result in results:
result.delete()
return redirect('/admin/employee/show_workinghours/'+worker)
def deleteRecord(request):
delete_id = request.POST['delete_id']
q = WorkingHours.gql("WHERE id = :1", int(delete_id))
for result in q:
result.delete()
return redirect('/employee/')
def printWorkingHours(request, year, month):
user = users.get_current_user()
#user = users.User(mail)
em_data = Employee.gql("WHERE mail = :1", user).fetch(1)
time_format = "%Y-%m-%d"
try:
bday = year + '-' + month + '-1'
endday = year + '-' + unicode(int(month) + 1) + "-1"
sdate = datetime.date.fromtimestamp(time.mktime(time.strptime(bday, time_format)))
sdate2 = datetime.date.fromtimestamp(time.mktime(time.strptime(endday, time_format)))
working_hours = WorkingHours.gql("WHERE worker = :1 AND working_date >= :2 AND working_date < :3",
user, sdate, sdate2)
template_values = {'working_hours': working_hours,
'em_data':em_data}
return render_to_response('table.html', template_values)
except:
return HttpResponse("請先選擇月份，初始畫面是所有的工讀紀錄。")
def showWorkingHours(request, worker_mail):
pattern = '([\w.]+)@([\w.]+)'
regu = re.compile(pattern, re.IGNORECASE)
if not regu.search(worker_mail): return redirect('/admin/employee')
now = datetime.datetime.now()
nowy=[]
for i in range(5):
nowy.append(now.year-i)
mon=[1,2,3,4,5,6,7,8,9,10,11,12]
# user = users.User(worker_mail+'@gmail.com')
user = users.User(worker_mail)
em_query = Employee.gql("WHERE mail = :1", user)
em_data = em_query.fetch(1)
working_hours = WorkingHours.gql("WHERE worker = :1", user)
total_hour = 0
total_pay = 0
for work in working_hours:
total_hour += work.subtotal
total_pay += work.pay
template_values = {}
if users.get_current_user():
template_values['userName'] = users.get_current_user().nickname().split('@')[0]
template_values['logout'] = users.create_logout_url('/')
template_values['em_data'] = em_data
template_values['working_hours'] = working_hours
template_values['total_hour'] = total_hour
template_values['total_pay'] = total_pay
template_values['nowy'] = nowy
template_values['mon'] = mon
try:
em_mail = str(em_data.__getitem__(0).mail)
template_values['em_mail'] = worker_mail#em_mail
return render_to_response('admin/employee/browse_employee.html', template_values)
except:
return HttpResponse('找不到此人的資料。')
def employeeList(request):
employee = Employee.all()
year = datetime.date.today().year
month = datetime.date.today().month
nextMonth = (month + 1) if month < 12 else 1
time_format = "%Y-%m-%d"
bday = str(year) + "-" + str(month) + "-1"
endday = str(year) + "-" + str(nextMonth) + "-1"
sdate = datetime.date.fromtimestamp(time.mktime(time.strptime(bday, time_format)))
endate = datetime.datetime.fromtimestamp(time.mktime(time.strptime(endday, time_format)))
working_hours = WorkingHours.gql("WHERE working_date >= :1 AND working_date < :2" \
, sdate, endate)
seq1 = ()#key值陣列
seq2 = []#時數
for em in employee:
# print em.mail
seq1 += em.id,#設key id
seq2.append(0)#放初值
d = dict(zip(seq1,seq2))
for work in working_hours:
for i in employee:
if work.worker == i.mail:
d[int(i.id)] += work.subtotal
# d.values is work subtotal
personal_data = zip(d.values(),employee)
template_values = {}
if users.get_current_user():
template_values['userName'] = users.get_current_user().nickname().split('@')[0]
template_values['logout'] = users.create_logout_url('/')
template_values['personal_data'] = personal_data
return render_to_response('admin/employee/admin_employee.html', template_values)