用路由器建设网站,小程序怎么找出来,免费的进销存软件哪个简单好用,网站备案变更开发准备
上一节我们实现了回收金提现的功能#xff0c;并且成功展示了当前账户的支出列表#xff0c;但是我们的提现相关的记录并没有很好的给用户做出展示#xff0c;用户只知道当前账户提现扣款#xff0c;并不知道回收金的去向#xff0c;这一节我们就要实现回收金记…开发准备
上一节我们实现了回收金提现的功能并且成功展示了当前账户的支出列表但是我们的提现相关的记录并没有很好的给用户做出展示用户只知道当前账户提现扣款并不知道回收金的去向这一节我们就要实现回收金记录的查询添加、查询、展示
功能分析
要实现这些功能我们需要新建一张表根据当前用户绑定的信息去填充对应的信息把提现的银行卡提现状态提现时间提现金额都先添加到表里在用户进入提现记录页面之后通过userid去查询当前用户的记录然后在列表里进行展示
代码实现
首先我们创建对应的提现记录表
{objectTypeName: withdrawal_record,fields: [{fieldName: id, fieldType: Integer, notNull: true, belongPrimaryKey: true},{fieldName: user_id, fieldType: Integer, notNull: true, defaultValue: 0},{fieldName: bank_name, fieldType: String},{fieldName: bank_num, fieldType: String},{fieldName: creat_time, fieldType: String},{fieldName: type_str, fieldType: String},{fieldName: money, fieldType: Double}],indexes: [{indexName: field1Index, indexList: [{fieldName:id,sortType:ASC}]}],permissions: [{role: World, rights: [Read, Upsert, Delete]},{role: Authenticated, rights: [Read, Upsert, Delete]},{role: Creator, rights: [Read, Upsert, Delete]},{role: Administrator, rights: [Read, Upsert, Delete]}]
}我们生成对应的实体和db类之后在提现成功的提交记录里把我们表需要的信息添加进去 let recordnew withdrawal_record()record.idMath.floor(Math.random() * 1000000)record.user_idthis.user!.user_idrecord.bank_namethis.bankList[0].bank_namerecord.bank_numthis.bankList[0].bank_cardrecord.creat_timethis.year-this.month-this.day this.timerecord.type_str0record.moneythis.moneyNumlet status await databaseZone.upsert(record);添加完成之后我们新建一个提现记录展示页面
Entry
Component
struct WithdrawalRecordPage {State user: User|nullnullbuild() {Column() {CommonTopBar({ title: 提现记录, alpha: 0, titleAlignment: TextAlign.Center ,backButton:true})}.backgroundColor(#F1F3F5).height(100%).width(100%)}
}首先进行数据的查询 State user: User|nullnullState withdrawalRecordList:WithdrawalRecord[][]async aboutToAppear(): Promisevoid {const value await StorageUtils.getAll(user);if (value ! ) {this.user JSON.parse(value)}let databaseZone cloudDatabase.zone(default);let condition new cloudDatabase.DatabaseQuery(withdrawal_record);condition.equalTo(user_id, this.user?.user_id)let listData await databaseZone.query(condition);let json JSON.stringify(listData)let data: WithdrawalRecord[] JSON.parse(json)if (data.length0) {this.withdrawalRecordListdata}}然后把我们查询到的数据展示到列表组件中 List({space:10}){ForEach(this.withdrawalRecordList,(item:WithdrawalRecord,index:number){ListItem(){Column({space:10}){Row(){Text(item.type_str0?提现成功:提现中).fontColor(item.type_str0?Color.Green:Color.Black).fontSize(16).fontWeight(FontWeight.Bold)Text(¥item.money).fontSize(16).fontWeight(FontWeight.Bold).fontColor(Color.Black)}.width(100%).justifyContent(FlexAlign.SpaceBetween)Row(){Text(item.bank_name (item.bank_num)).fontColor(Color.Black).fontSize(14).fontWeight(FontWeight.Bold)Text(item.creat_time).fontSize(14).fontWeight(FontWeight.Bold).fontColor(Color.Grey)}.width(100%).justifyContent(FlexAlign.SpaceBetween)}.padding(10).width(100%).borderRadius(10).backgroundColor(Color.White)}})}.padding(10)现在让我们运行代码查看效果
