def get(self, begin_time, end_time):
result = {}
release = pd.read_json(json.dumps(Release.between(begin_time, end_time))).set_index("release_time")
for name, g in release.groupby("release_type"):
result[name] = {}
ids = g.resample("m", how="count").id
for ix in ids.index:
date = time.format(ix.to_datetime(), "%Y-%m-%d")
result[name][date] = ids[ix]
return self.succ(result)
def export(submit):
# 固定资产编号 入库时间 申请人 名称 状态 详细
_export = []
for stockopt in Stock.search(submit):
_dict = {}
stock = stockopt["stock"]
_dict["名称"] = stock["category"]["name"]
_dict["规格"] = stock["spec"]["name"]
_dict["入库时间"] = time.format(stock["stock_in_time"], "%Y-%m-%d")
_dict["固定资产编号"] = stock["no"]
_export.append(_dict)
return _export
def __to_dict(self, cols=[]):
_dict = {}
for c in self.__table__.columns:
attr = getattr(self, c.name, None)
if isinstance(attr, datetime):
_dict[c.name] = time.format(attr, "%Y-%m-%d %H:%M")
else:
_dict[c.name] = attr
for c in cols:
_dict[c] = getattr(self, c, None)
return _dict
def __to_dict(self, cols=[]):
_dict = {}
for c in self.__table__.columns:
attr = getattr(self, c.name, None)
if isinstance(attr, datetime):
_dict[c.name] = time.format(attr, "%Y-%m-%d %H:%M")
else:
_dict[c.name] = attr
for c in cols:
_dict[c] = getattr(self, c, None)
return _dict
def export(submit):
# 固定资产编号 入库时间 申请人 名称 状态 详细
_export = []
for stockopt in Stock.search(submit):
_dict = {}
stock = stockopt["stock"]
_dict["名称"] = stock["category"]["name"]
_dict["规格"] = stock["spec"]["name"]
_dict["入库时间"] = time.format(stock["stock_in_time"], "%Y-%m-%d")
_dict["固定资产编号"] = stock["no"]
_export.append(_dict)
return _export
def get(self, begin_time, end_time):
result = {}
release = pd.read_json(
json.dumps(Release.between(begin_time, end_time))) \
.set_index("release_time")
for name, g in release.groupby("release_type"):
result[name] = {}
ids = g.resample("m", how="count").id
for ix in ids.index:
date = time.format(ix.to_datetime(), "%Y-%m-%d")
result[name][date] = ids[ix]
return self.succ(result)
def export(submit):
# 申请人 申请部门 申请时间 物品 规格 数量 总价 审批人
_export = []
for purchase in Purchase.search(submit):
for g in purchase["goods"]:
_dict = collections.OrderedDict()
_dict["采购编号"] = str(purchase["id"])
_dict["总价"] = g["amount"] * g["price"]
_dict["数量"] = g["amount"]
_dict["规格"] = str(g["spec"]["name"])
_dict["物品"] = str(g["category"]["name"])
_dict["申请时间"] = time.format(purchase["apply_time"], "%Y-%m-%d")
_dict["申请部门"] = str(purchase["apply_businessCategory"])
_dict["申请人"] = str(purchase["apply_uid"])
_export.append(_dict)
return _export
def export(submit):
# 申请人 申请部门 申请时间 物品 规格 数量 总价 审批人
_export = []
for purchase in Purchase.search(submit):
for g in purchase["goods"]:
_dict = collections.OrderedDict()
_dict["采购编号"] = str(purchase["id"])
_dict["总价"] = g["amount"] * g["price"]
_dict["数量"] = g["amount"]
_dict["规格"] = str(g["spec"]["name"])
_dict["物品"] = str(g["category"]["name"])
_dict["申请时间"] = time.format(purchase["apply_time"], "%Y-%m-%d")
_dict["申请部门"] = str(purchase["apply_businessCategory"])
_dict["申请人"] = str(purchase["apply_uid"])
_export.append(_dict)
return _export
