form11.vue 11.2 KB
<template>
  <div class="NCC-common-layout">
    <div class="NCC-common-layout-center">
      <!-- 筛选条件 -->
      <el-row class="NCC-common-search-box" :gutter="16">
        <el-form @submit.native.prevent>
          <el-col :span="6">
            <el-form-item label="品项" required>
              <el-select
                v-model="query.itemId"
                placeholder="请选择品项"
                filterable
                :style='{"width":"100%"}'>
                <el-option
                  v-for="item in itemOptions"
                  :key="item.id"
                  :label="item.xmmc"
                  :value="item.id">
                </el-option>
              </el-select>
            </el-form-item>
          </el-col>
          <el-col :span="6">
            <el-form-item label="开始时间" required>
              <el-date-picker 
                v-model="query.startTime" 
                type="datetime" 
                value-format="yyyy-MM-dd HH:mm:ss" 
                format="yyyy-MM-dd HH:mm:ss" 
                placeholder="开始时间"
              />
            </el-form-item>
          </el-col>
          <el-col :span="6">
            <el-form-item label="结束时间" required>
              <el-date-picker 
                v-model="query.endTime" 
                type="datetime" 
                value-format="yyyy-MM-dd HH:mm:ss" 
                format="yyyy-MM-dd HH:mm:ss" 
                placeholder="结束时间"
              />
            </el-form-item>
          </el-col>
          <el-col :span="6">
            <el-form-item>
              <el-button type="primary" icon="el-icon-search" @click="search()">查询</el-button>
              <el-button icon="el-icon-refresh-right" @click="reset()">重置</el-button>
            </el-form-item>
          </el-col>
        </el-form>
      </el-row>

      <!-- 统计卡片 -->
      <div class="statistics-cards" v-if="summaryData">
        <el-row :gutter="16">
          <el-col :span="6">
            <div class="statistics-card">
              <div class="card-icon">
                <i class="el-icon-shop"></i>
              </div>
              <div class="card-content">
                <div class="card-title">门店总数</div>
                <div class="card-value">{{ summaryData.totalStores || 0 }}</div>
              </div>
            </div>
          </el-col>
          <el-col :span="6">
            <div class="statistics-card">
              <div class="card-icon">
                <i class="el-icon-document"></i>
              </div>
              <div class="card-content">
                <div class="card-title">开单数合计</div>
                <div class="card-value">{{ summaryData.totalBillingCount || 0 }}</div>
              </div>
            </div>
          </el-col>
          <el-col :span="6">
            <div class="statistics-card">
              <div class="card-icon">
                <i class="el-icon-menu"></i>
              </div>
              <div class="card-content">
                <div class="card-title">项目数合计</div>
                <div class="card-value">{{ summaryData.totalProjectCount || 0 }}</div>
              </div>
            </div>
          </el-col>
          <el-col :span="6">
            <div class="statistics-card">
              <div class="card-icon">
                <i class="el-icon-money"></i>
              </div>
              <div class="card-content">
                <div class="card-title">实付金额合计</div>
                <div class="card-value">¥{{ formatMoney(summaryData.totalActualAmount) }}</div>
              </div>
            </div>
          </el-col>
        </el-row>
        <el-row :gutter="16" style="margin-top: 16px;">
          <el-col :span="6">
            <div class="statistics-card">
              <div class="card-icon">
                <i class="el-icon-delete"></i>
              </div>
              <div class="card-content">
                <div class="card-title">退款金额合计</div>
                <div class="card-value">¥{{ formatMoney(summaryData.totalRefundAmount) }}</div>
              </div>
            </div>
          </el-col>
        </el-row>
      </div>

      <!-- 数据表格 -->
      <div class="NCC-common-layout-main NCC-flex-main">
        <NCC-table v-loading="listLoading" :data="list" has-c>
          <el-table-column prop="StoreName" label="门店名称" >
            <template slot-scope="scope">
              <i class="el-icon-shop" style="margin-right: 4px; color: #409EFF;"></i>
              <span>{{ scope.row.StoreName || '无' }}</span>
            </template>
          </el-table-column>
          <el-table-column prop="BillingCount" label="开单数"  >
            <template slot-scope="scope">
              <i class="el-icon-document" style="margin-right: 4px; color: #409EFF;"></i>
              <span>{{ scope.row.BillingCount || 0 }}</span>
            </template>
          </el-table-column>
          <el-table-column prop="ProjectCount" label="项目数"  >
            <template slot-scope="scope">
              <i class="el-icon-menu" style="margin-right: 4px; color: #67C23A;"></i>
              <span>{{ scope.row.ProjectCount || 0 }}</span>
            </template>
          </el-table-column>
          <el-table-column prop="ActualAmount" label="实付金额"  >
            <template slot-scope="scope">
              <i class="el-icon-money" style="margin-right: 4px; color: #67C23A;"></i>
              <span class="amount-paid">¥{{ formatMoney(scope.row.ActualAmount) }}</span>
            </template>
          </el-table-column>
          <el-table-column prop="RefundAmount" label="退款金额"  >
            <template slot-scope="scope">
              <i class="el-icon-delete" style="margin-right: 4px; color: #F56C6C;"></i>
              <span class="amount-debt">¥{{ formatMoney(scope.row.RefundAmount) }}</span>
            </template>
          </el-table-column>
        </NCC-table>
      </div>
    </div>
  </div>
</template>

<script>
import request from '@/utils/request'

export default {
  name: 'StoreItemStatistics',
  data() {
    return {
      query: {
        itemId: undefined,
        startTime: undefined,
        endTime: undefined
      },
      itemOptions: [],
      summaryData: null,
      list: [],
      listLoading: false
    }
  },
  created() {
    this.setDefaultTimeRange()
    this.initItemOptions()
  },
  methods: {
    // 设置默认时间范围(本月1号到现在)
    setDefaultTimeRange() {
      const now = new Date()
      const firstDayOfMonth = new Date(now.getFullYear(), now.getMonth(), 1)
      
      this.query.startTime = this.formatDateTime(firstDayOfMonth.getTime())
      this.query.endTime = this.formatDateTime(now.getTime())
    },

    // 初始化品项选项
    initItemOptions() {
      request({
        url: '/api/Extend/LqXmzl',
        method: 'GET',
        data: {
          currentPage: 1,
          pageSize: 1000
        }
      }).then(res => {
        this.itemOptions = res.data.list || []
      }).catch(err => {
        console.error('获取品项列表失败:', err)
      })
    },

    // 查询数据
    search() {
      // 验证必填参数
      if (!this.query.itemId) {
        this.$message({
          type: 'warning',
          message: '请选择品项',
          duration: 1500
        })
        return
      }

      if (!this.query.startTime) {
        this.$message({
          type: 'warning',
          message: '请选择开始时间',
          duration: 1500
        })
        return
      }

      if (!this.query.endTime) {
        this.$message({
          type: 'warning',
          message: '请选择结束时间',
          duration: 1500
        })
        return
      }

      this.listLoading = true

      const params = {
        itemId: this.query.itemId,
        startTime: this.query.startTime,
        endTime: this.query.endTime
      }

      request({
        url: '/api/Extend/lqxmzl/get-item-store-statistics',
        method: 'POST',
        data: params
      }).then(res => {
        // 兼容不同的返回格式:可能是 res.data.data 或 res.data 直接是数组
        let dataList = []
        if (res.data) {
          if (Array.isArray(res.data)) {
            dataList = res.data
          } else if (res.data.data && Array.isArray(res.data.data)) {
            dataList = res.data.data
          } else if (Array.isArray(res.data.list)) {
            dataList = res.data.list
          }
        }
        
        this.list = dataList
        this.calculateSummary()
        this.listLoading = false
      }).catch(err => {
        console.error('查询失败:', err)
        this.$message({
          type: 'error',
          message: '查询失败,请重试',
          duration: 1500
        })
        this.listLoading = false
      })
    },

    // 计算汇总数据
    calculateSummary() {
      if (!this.list || this.list.length === 0) {
        this.summaryData = null
        return
      }

      const summary = {
        totalStores: this.list.length,
        totalBillingCount: this.list.reduce((sum, item) => sum + (item.BillingCount || 0), 0),
        totalProjectCount: this.list.reduce((sum, item) => sum + (item.ProjectCount || 0), 0),
        totalActualAmount: this.list.reduce((sum, item) => sum + (item.ActualAmount || 0), 0),
        totalRefundAmount: this.list.reduce((sum, item) => sum + (item.RefundAmount || 0), 0)
      }

      this.summaryData = summary
    },

    // 重置查询条件
    reset() {
      this.query = {
        itemId: undefined,
        startTime: undefined,
        endTime: undefined
      }
      this.setDefaultTimeRange()
      this.summaryData = null
      this.list = []
    },

    // 格式化金额
    formatMoney(amount) {
      if (!amount && amount !== 0) return '0.00'
      return Number(amount).toFixed(2)
    },

    // 格式化日期时间(用于API传参)
    formatDateTime(timestamp) {
      if (!timestamp) return ''
      const date = new Date(timestamp)
      const year = date.getFullYear()
      const month = String(date.getMonth() + 1).padStart(2, '0')
      const day = String(date.getDate()).padStart(2, '0')
      const hours = String(date.getHours()).padStart(2, '0')
      const minutes = String(date.getMinutes()).padStart(2, '0')
      const seconds = String(date.getSeconds()).padStart(2, '0')
      return `${year}-${month}-${day} ${hours}:${minutes}:${seconds}`
    }
  }
}
</script>

<style lang="scss" scoped>
.statistics-cards {
  margin-bottom: 20px;
}

.statistics-card {
  height: 100px;
  padding: 12px;
  border-radius: 12px;
  background: #fff;
  box-shadow: 0 2px 8px rgba(0, 0, 0, 0.1);
  display: flex;
  align-items: center;
  
  .card-icon {
    width: 60px;
    height: 60px;
    border-radius: 8px;
    background: linear-gradient(135deg, #409EFF, #67C23A);
    display: flex;
    align-items: center;
    justify-content: center;
    margin-right: 16px;
    
    i {
      font-size: 24px;
      color: #fff;
    }
  }
  
  .card-content {
    flex: 1;
    
    .card-title {
      font-size: 14px;
      color: #909399;
      margin-bottom: 8px;
    }
    
    .card-value {
      font-size: 24px;
      font-weight: bold;
      color: #303133;
    }
  }
}

.amount-paid {
  color: #67C23A;
  font-weight: 500;
}

.amount-debt {
  color: #F56C6C;
  font-weight: 500;
}
</style>