collection="collectionList" field="actionname,icon,iconcolor,description,limited_time,limited_time_ring,need_vibison,timeup_continue,in_interval_time,in_interval_ring,need_in_vibison,out_interval_time,out_interval_ring,need_out_vibison,create_date,user_id{_id,nickname}">
<view v-if="error">{{error.message}}</view>
<view v-else-if="data">
<uni-list>
<uni-list-item v-for="(item, index) in data" :key="index" showArrow :clickable="true" @click="handleItemClick(item._id)">
<!-- 通过header插槽定义列表左侧图片 -->
<template v-slot:header>
<uv-icon :name="item.icon" :color="item.iconcolor" size="28"></uv-icon>
</template>
<!-- 通过body插槽定义布局 -->
<template v-slot:body>
<view class="main">
<text class="title">{{item.actionname}}</text>
<view class="info">
<text class="author">{{item.user_id[0]?item.user_id[0].nickname:''}}</text>
<uni-dateformat class="last_modify_date" :date="item.create_date"
format="yyyy-MM-dd" :threshold="[60000, 2592000000]" />
</view>
</view>
</template>       
  </uni-list-item>  
</uni-list>  
</view>
<uni-load-more :status="loading?'loading':(hasMore ? 'more' : 'noMore')"></uni-load-more>
</unicloud-db>
<uni-fab ref="fab" horizontal="right" vertical="bottom" :pop-menu="false" @fabClick="fabClick" />
</view>
</template>  
<script>
const db = uniCloud.database()
export default {
data() {
return {
collectionList: "kungfu-actions-diy,uni-id-users",
loadMore: {
contentdown: '',
contentrefresh: '',
contentnomore: ''
},
// sWhere:'',  
    // sWhere:"user_id=='65f98a10a7c432936b30e275'",  
    //sWhere:"hall_numb==2 || user_id=='65f98a10a7c432936b30e275'",  
    sWhere:"'hall_numb'==1 ||'icon'=='moments' || 'user_id'=='65f98a10a7c432936b30e275'",  
           //"'hall_numb'==0||'user_id'=='65f98a10a7c432936b30e275'"  
           //"'hall_numb'==0||'user_id'=='65f98a10a7c432936b30e275'"  
  }  
},  
onPullDownRefresh() {  
  this.$refs.udb.loadData({  
    clear: true  
  }, () => {  
    uni.stopPullDownRefresh()  
  })  
},  
onReachBottom() {  
  this.$refs.udb.loadMore()  
},  
onLoad() {  
    //this.sWhere = '"user_id"=="'+uniCloud.getCurrentUserInfo().uid+'"';  
    //this.sWhere = "'user_id'=='"+uniCloud.getCurrentUserInfo().uid+"'";  
    console.log("onLoad",this.sWhere);  
    this.$nextTick(() => {  
                  this.$refs.udb.loadData()  
                  console.log("loadData",this.$refs.udb.$data)  
                })  
},    
methods: {  
  handleItemClick(id) {  
    uni.navigateTo({  
      url: './detail?id=' + id  
    })  
  },  
  fabClick() {  
    // 打开新增页面  
    uni.navigateTo({  
      url: './addAction',  
      events: {  
        // 监听新增数据成功后, 刷新当前页面数据  
        refreshData: () => {  
          this.$refs.udb.loadData({  
            clear: true  
          })  
        }  
      }  
    })  
  }  
}  
}
</script>  
<style>
.main {
justify-content: space-between;
flex: 1;
}  
.title {  
    font-weight: bold;  
    font-size: 32rpx !important;  
    text-align: left;  
}  
.info {  
    flex-direction: row;  
    justify-content: space-between;  
}  
.author,  
.last_modify_date {  
    font-size: 14px;  
    color: #999999;  
}  
</style>
            
            
            
            
1 个回复
systhinker (作者)
我自己找到原因了,联表查询的外联字段不能放在where语句中