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 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