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 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 deleteEmployee(request):
q = Employee.gql("WHERE id = :1", int(request.POST['id']))
for result in q:
result.delete()
return redirect('/admin/employee')
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 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 editEmployee(request):
q = Employee.gql("WHERE id = :1", int(request.POST['id']))
results = q.fetch(10)
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['employee'] = results
return render_to_response('admin/employee/update_employee.html', template_values)
def updateEmployee(request):
q = Employee.gql("WHERE id = :1", int(request.POST['id']))
results = q.fetch(10)
for data in results:
data.name = request.POST['new_name']
# data.mail = users.User(self.request.get('new_mail')+'@gmail.com')
data.hourly_pay = int(request.POST['new_pay'])
db.put(results)
return redirect('/admin/employee')
def addEmployee(request):
result = Employee.gql('ORDER BY id DESC').get()
employee = Employee()
employee.id = (result.id + 1) if result else 0
employee.name = request.POST['name']
employee.mail = users.User(request.POST['mail'])
employee.hourly_pay = int(request.POST['hourly_pay'])
employee.put()
#self.response.out.write(self.request.get('mail'))
return redirect('/admin/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('找不到此人的資料。')
