def get(self, year, weeks, team_id=None):
dt = datetime(year, 1, 1) + timedelta(weeks=weeks - 1)
beg_time = dt - timedelta(days=dt.weekday())
end_time = (dt + timedelta(days=6 - dt.weekday())).replace(hour=23, minute=59, second=59)
if team_id:
result = Report.select(
_filters=[Report.create_time.between(beg_time, end_time), Report.team_id == team_id])
else:
result = Report.select(
_filters=[Report.create_time.between(beg_time, end_time),ReportTeam.is_del!=True],_joins=ReportTeam)
return self.succ(result)
def get(self, year, weeks, team_id=None):
dt = datetime(year, 1, 1) + timedelta(weeks=weeks - 1)
beg_time = dt - timedelta(days=dt.weekday())
end_time = (dt + timedelta(days=6 - dt.weekday())).replace(hour=23, minute=59, second=59)
if team_id:
result = Report.select(_filters=[Report.create_time.between(beg_time, end_time), Report.team_id == team_id])
else:
result = Report.select(
_filters=[Report.create_time.between(beg_time, end_time), ReportTeam.is_del != True], _joins=ReportTeam
)
return self.succ(result)
def post(self):
submit = self.request()
if not submit.__contains__("create_time"):
submit["create_time"] = datetime.now()
else:
submit["create_time"] = datetime.strptime(submit["create_time"], "%Y-%m-%d")
beg_time = (submit["create_time"] - timedelta(days=submit["create_time"].weekday())).replace(hour=0, minute=0,
second=0)
end_time = (submit["create_time"] + timedelta(days=6 - submit["create_time"].weekday())).replace(hour=23,
minute=59,
second=59)
if Report.query.filter(Report.create_time.between(beg_time, end_time)) \
.filter(Report.team_id == submit["team_id"]).count():
raise ExceptionEx("本周计划已添加")
Report.add(submit)
return self.succ()
def post(self):
submit = self.request()
if not submit.__contains__("create_time"):
submit["create_time"] = datetime.now()
else:
submit["create_time"] = datetime.strptime(submit["create_time"], "%Y-%m-%d")
beg_time = (submit["create_time"] - timedelta(days=submit["create_time"].weekday())).replace(
hour=0, minute=0, second=0
)
end_time = (submit["create_time"] + timedelta(days=6 - submit["create_time"].weekday())).replace(
hour=23, minute=59, second=59
)
if (
Report.query.filter(Report.create_time.between(beg_time, end_time))
.filter(Report.team_id == submit["team_id"])
.count()
):
raise ExceptionEx("本周计划已添加")
Report.add(submit)
return self.succ()
def put(self, rid):
submit = self.request()
submit["id"] = rid
Report.edit(submit)
return self.succ()
def delete(self, rid):
Report.delete(rid)
return self.succ()
beg_time = (submit["create_time"] - timedelta(days=submit["create_time"].weekday())).replace(
hour=0, minute=0, second=0
)
end_time = (submit["create_time"] + timedelta(days=6 - submit["create_time"].weekday())).replace(
hour=23, minute=59, second=59
)
if (
Report.query.filter(Report.create_time.between(beg_time, end_time))
.filter(Report.team_id == submit["team_id"])
.count()
):
raise ExceptionEx("本周计划已添加")
Report.add(submit)
return self.succ()
def delete(self, rid):
Report.delete(rid)
return self.succ()
def put(self, rid):
submit = self.request()
submit["id"] = rid
Report.edit(submit)
return self.succ()
if __name__ == "__main__":
Report.add({"create_time": ""})
def put(self, rid):
submit = self.request()
submit["id"] = rid
Report.edit(submit)
return self.succ()
def delete(self, rid):
Report.delete(rid)
return self.succ()
submit["create_time"] = datetime.now()
else:
submit["create_time"] = datetime.strptime(submit["create_time"], "%Y-%m-%d")
beg_time = (submit["create_time"] - timedelta(days=submit["create_time"].weekday())).replace(hour=0, minute=0,
second=0)
end_time = (submit["create_time"] + timedelta(days=6 - submit["create_time"].weekday())).replace(hour=23,
minute=59,
second=59)
if Report.query.filter(Report.create_time.between(beg_time, end_time)) \
.filter(Report.team_id == submit["team_id"]).count():
raise ExceptionEx("本周计划已添加")
Report.add(submit)
return self.succ()
def delete(self, rid):
Report.delete(rid)
return self.succ()
def put(self, rid):
submit = self.request()
submit["id"] = rid
Report.edit(submit)
return self.succ()
if __name__ == "__main__":
Report.add({"create_time": ""})
