antis-ncc-admin/src/views/statisticsList/form7.vue

<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="门店">
              <el-select v-model="query.storeId" placeholder="请选择门店" clearable filterable>
                <el-option v-for="store in storeOptions" :key="store.id" :label="store.dm" :value="store.id" />
              </el-select>
            </el-form-item>
          </el-col>
          <el-col :span="6">
            <el-form-item label="部门">
              <el-select v-model="query.departmentId" placeholder="请选择部门" clearable filterable>
                <el-option v-for="dept in departmentOptions" :key="dept.id" :label="dept.fullName" :value="dept.id" />
              </el-select>
            </el-form-item>
          </el-col>
          <el-col :span="6">
            <el-form-item label="开始时间">
              <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="结束时间">
              <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="NCC-common-layout-main NCC-flex-main">
        <NCC-table 
          v-loading="listLoading" 
          :data="list" 
          has-c
          show-summary
          :summary-method="getSummaries"
        >
          <el-table-column prop="employeeName" label="员工姓名"  />
          <el-table-column prop="storeName" label="门店名称"  />
          <el-table-column prop="departmentName" label="部门名称"  />
          <el-table-column prop="inviteCount" label="邀请数"  >
            <template slot-scope="scope">
              <span class="clickable-cell" @click="handleInviteClick(scope.row)">
                {{ scope.row.inviteCount || 0 }}
              </span>
            </template>
          </el-table-column>
          <el-table-column prop="appointmentCount" label="预约数"  >
            <template slot-scope="scope">
              <span class="clickable-cell" @click="handleAppointmentClick(scope.row)">
                {{ scope.row.appointmentCount || 0 }}
              </span>
            </template>
          </el-table-column>
          <el-table-column prop="到店人数" label="到店人数"  >
            <template slot-scope="scope">
              <span class="clickable-cell" @click="handleVisitClick(scope.row)">
                {{ scope.row.visitCount || 0 }}
              </span>
            </template>
          </el-table-column>
          <el-table-column prop="billingCount" label="开单数"  >
            <template slot-scope="scope">
              <span class="clickable-cell" @click="handleBillingClick(scope.row)">
                {{ scope.row.billingCount || 0 }}
              </span>
            </template>
          </el-table-column>
          <el-table-column prop="billingAmount" label="开单金额"  >
            <template slot-scope="scope">
              <span class="amount-value">¥{{ formatMoney(scope.row.billingAmount) }}</span>
            </template>
          </el-table-column>
          <el-table-column prop="consumeAmount" label="消耗金额"  >
            <template slot-scope="scope">
              <span class="amount-paid">¥{{ formatMoney(scope.row.consumeAmount) }}</span>
            </template>
          </el-table-column>
          <el-table-column prop="refundAmount" label="退款金额"  >
            <template slot-scope="scope">
              <span class="amount-paid">¥{{ formatMoney(scope.row.refundAmount) }}</span>
            </template>
          </el-table-column>
          <el-table-column  label="个人业绩"  >
            <template slot-scope="scope">
              <span class="amount-paid">¥{{ formatMoney(scope.row.billingAmount - scope.row.refundAmount) }}</span>
            </template>
          </el-table-column>
          <el-table-column prop="headCount" label="人头数"  >
            <template slot-scope="scope">
              {{ scope.row.headCount || 0 }}
            </template>
          </el-table-column>
          <el-table-column prop="personCount" label="人次"  >
            <template slot-scope="scope">
              {{ scope.row.personCount || 0 }}
            </template>
          </el-table-column>
          <el-table-column prop="projectCount" label="项目数"  >
            <template slot-scope="scope">
              {{ scope.row.projectCount || 0 }}
            </template>
          </el-table-column>
          <el-table-column prop="laborCost" label="手工费"  >
            <template slot-scope="scope">
              {{ scope.row.laborCost || 0 }}
            </template>
          </el-table-column>
        </NCC-table>
        <!-- 分页组件 -->
        <pagination 
          v-show="total > 0" 
          :total="total" 
          :page.sync="query.currentPage"
          :limit.sync="query.pageSize" 
          @pagination="search" 
        />
      </div>
    </div>
  </div>
</template>
<script>
import request from '@/utils/request'
import Pagination from '@/components/Pagination'
export default {
  name: 'StoreOverallStatistics',
  components: {
    Pagination
  },
  data() {
    return {
      query: {
        storeId: undefined,
        departmentId: undefined,
        startTime: undefined,
        endTime: undefined,
        currentPage: 1,
        pageSize: 20
      },
      storeOptions: [],
      departmentOptions: [],
      list: [],
      total: 0,
      listLoading: false
    }
  },
  created() {
    if (sessionStorage.getItem('isshaixuan') === 'false') {
      this.setDefaultTimeRange()
    } else{
      this.restoreQueryParams()
    }
    this.initStoreOptions()
    this.initDepartmentOptions()
    this.search()
  },
  methods: {
    // 保存筛选条件到 sessionStorage
    saveQueryParams() {
      try {
        const paramsToSave = {
          storeId: this.query.storeId,
          departmentId: this.query.departmentId,
          startTime: this.query.startTime,
          endTime: this.query.endTime,
          currentPage: this.query.currentPage,
          pageSize: this.query.pageSize
        }
        sessionStorage.setItem('form7_query_params', JSON.stringify(paramsToSave))
        sessionStorage.setItem('isshaixuan', true)
      } catch (err) {
        console.error('保存筛选条件失败:', err)
      }
    },
    // 从 sessionStorage 恢复筛选条件
    restoreQueryParams() {
      try {
        const savedParams = sessionStorage.getItem('form7_query_params')
        if (savedParams) {
          const params = JSON.parse(savedParams)
          // 恢复筛选条件
          this.query.storeId = params.storeId || undefined
          this.query.departmentId = params.departmentId || undefined
          this.query.startTime = params.startTime || undefined
          this.query.endTime = params.endTime || undefined
          this.query.currentPage = params.currentPage || 1
          this.query.pageSize = params.pageSize || 20
          
          // 如果没有时间范围，设置默认值
          if (!this.query.startTime || !this.query.endTime) {
            this.setDefaultTimeRange()
          }
          sessionStorage.setItem('isshaixuan', false)
        } else {
          // 没有保存的条件，设置默认时间范围
          this.setDefaultTimeRange()
        }
      } catch (err) {
        console.error('恢复筛选条件失败:', err)
        // 出错时设置默认时间范围
        this.setDefaultTimeRange()
      }
    },
    // 设置默认时间范围（本月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())
    },
    // 初始化门店选项
    initStoreOptions() {
      request({
        url: '/api/Extend/LqMdxx',
        method: 'GET',
        data: {
          currentPage: 1,
          pageSize: 1000
        }
      }).then(res => {
        this.storeOptions = res.data.list || []
      }).catch(err => {
        console.error('获取门店列表失败:', err)
      })
    },
    // 初始化部门选项
    initDepartmentOptions() {
      request({
        url: '/api/permission/Organize/96240625-934F-490B-8AA6-0BC775B18468/Department',
        method: 'GET'
      }).then(res => {
        // 将树形结构扁平化
        this.departmentOptions = res.data.list.map(item => ({
          id: item.id,
          fullName: item.fullName
        }))
      }).catch(err => {
        console.error('获取部门列表失败:', err)
      })
    },
    // 查询数据
    search() {
      this.listLoading = true
      // 保存当前筛选条件
      // this.saveQueryParams()
      const params = {
        currentPage: this.query.currentPage,
        pageSize: this.query.pageSize
      }
      if (this.query.storeId) {
        params.StoreId = this.query.storeId
      }
      if (this.query.departmentId) {
        params.DepartmentId = this.query.departmentId
      }
      if (this.query.startTime) {
        params.StartTime = this.query.startTime
      }
      if (this.query.endTime) {
        params.EndTime = this.query.endTime
      }
      request({
        url: '/api/Extend/lqkdkdjlb/get-health-coach-statistics',
        method: 'GET',
        data: params
      }).then(res => {
        if (res.data && res.data.list) {
          this.list = res.data.list
          this.total = (res.data.pagination && res.data.pagination.totalCount) || 0
        } else {
          this.list = []
          this.total = 0
        }
        this.listLoading = false
      }).catch(err => {
        console.error('查询失败:', err)
        this.$message({
          type: 'error',
          message: '查询失败，请重试',
          duration: 1500
        })
        this.listLoading = false
      })
    },
    // 重置查询条件
    reset() {
      this.query = {
        storeId: undefined,
        departmentId: undefined,
        startTime: undefined,
        endTime: undefined,
        currentPage: 1,
        pageSize: 20
      }
      this.setDefaultTimeRange()
      // 清除保存的筛选条件
      try {
        sessionStorage.removeItem('form7_query_params')
      } catch (err) {
        console.error('清除保存的筛选条件失败:', err)
      }
      this.list = []
      this.total = 0
      this.search()
    },
    // 格式化金额
    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}`
    },
    // 将时间字符串转换为时间戳（毫秒）
    getTimestamp(timeStr) {
      if (!timeStr) return ''
      // 手动解析 yyyy-MM-dd HH:mm:ss 格式，避免时区问题
      const parts = timeStr.match(/(\d{4})-(\d{2})-(\d{2})\s+(\d{2}):(\d{2}):(\d{2})/)
      if (!parts) {
        // 如果格式不匹配，尝试使用 Date 解析
        return new Date(timeStr).getTime()
      }
      // 创建本地时间的 Date 对象
      const year = parseInt(parts[1], 10)
      const month = parseInt(parts[2], 10) - 1 // 月份从0开始
      const day = parseInt(parts[3], 10)
      const hours = parseInt(parts[4], 10)
      const minutes = parseInt(parts[5], 10)
      const seconds = parseInt(parts[6], 10)
      return new Date(year, month, day, hours, minutes, seconds).getTime()
    },
    // 处理邀请数点击事件
    handleInviteClick(row) {
      if (row && row.employeeId) {
        this.saveQueryParams()
        this.$router.push({
          path: '/lqYaoyjl',
          query: {
            employeeId: row.employeeId,
            storeId: row.storeId || '',
            startTime: this.getTimestamp(this.query.startTime),
            endTime: this.getTimestamp(this.query.endTime),
          }
        })
      } else {
        this.$message({
          type: 'warning',
          message: '无法获取健康师ID',
          duration: 1500
        })
      }
    },
    // 处理预约数点击事件
    handleAppointmentClick(row) {
      if (row && row.employeeId) {
        this.saveQueryParams()
        this.$router.push({
          path: '/lqYyjl',
          query: {
            employeeId: row.employeeId,
            storeId: row.storeId || '',
            startTime: this.getTimestamp(this.query.startTime),
            endTime: this.getTimestamp(this.query.endTime),
          }
        })
      } else {
        this.$message({
          type: 'warning',
          message: '无法获取健康师ID',
          duration: 1500
        })
      }
    },
    // 处理到店人数点击事件
    handleVisitClick(row) {
      if (row && row.employeeId) {
        this.saveQueryParams()
        this.$router.push({
          path: '/lqYyjl',
          query: {
            employeeId: row.employeeId,
            storeId: row.storeId || '',
            startTime: this.getTimestamp(this.query.startTime),
            endTime: this.getTimestamp(this.query.endTime),
            type:'已确认'
          }
        })
      } else {
        this.$message({
          type: 'warning',
          message: '无法获取健康师ID',
          duration: 1500
        })
      }
    },
    // 处理开单数点击事件
    handleBillingClick(row) {
      if (row && row.employeeId) {
        this.saveQueryParams()
        this.$router.push({
          path: '/lqKdKdjlb',
          query: {
            employeeId: row.employeeId,
            storeId: row.storeId || '',
            startTime: this.getTimestamp(this.query.startTime),
            endTime: this.getTimestamp(this.query.endTime),
          }
        })
      } else {
        this.$message({
          type: 'warning',
          message: '无法获取健康师ID',
          duration: 1500
        })
      }
    },
    // 计算合计
    getSummaries(param) {
      const { columns, data } = param
      const sums = []
      
      // 预先计算总开单金额和总退款金额，用于计算个人业绩合计
      const totalBillingAmount = data.reduce((prev, curr) => {
        return prev + (Number(curr.billingAmount) || 0)
      }, 0)
      const totalRefundAmount = data.reduce((prev, curr) => {
        return prev + (Number(curr.refundAmount) || 0)
      }, 0)
      
      columns.forEach((column, index) => {
        if (index === 2) {
          sums[index] = '合计'
          return
        }
        
        const prop = column.property
        const label = column.label
        
        // 处理个人业绩列（没有 prop，通过 label 判断）
        if (!prop && label === '个人业绩') {
          const totalPersonalPerformance = totalBillingAmount - totalRefundAmount
          sums[index] = `¥${this.formatMoney(totalPersonalPerformance)}`
          return
        }
        
        if (!prop) {
          sums[index] = ''
          return
        }
        
        // 需要合计的数值字段
        if (['inviteCount', 'appointmentCount', 'visitCount', 'billingCount', 
             'headCount', 'personCount', 'projectCount', 'laborCost'].includes(prop)) {
          const total = data.reduce((prev, curr) => {
            const value = Number(curr[prop]) || 0
            return prev + value
          }, 0)
          sums[index] = total
        } 
        // 金额字段需要格式化
        else if (['billingAmount', 'consumeAmount', 'refundAmount'].includes(prop)) {
          const total = data.reduce((prev, curr) => {
            const value = Number(curr[prop]) || 0
            return prev + value
          }, 0)
          sums[index] = `¥${this.formatMoney(total)}`
        } 
        // 其他列（员工姓名、门店名称、部门名称）不显示合计
        else {
          sums[index] = ''
        }
      })
      
      return sums 
    }
  }
}
</script>
<style lang="scss" scoped>
.amount-value {
  color: #409EFF;
  font-weight: 500;
}
.amount-paid {
  color: #67C23A;
  font-weight: 500;
}
.clickable-cell {
  color: #409EFF;
  cursor: pointer;
  text-decoration: none;
  transition: all 0.3s;
  &:hover {
    color: #66b1ff;
    text-decoration: underline;
  }
  &:active {
    color: #3a8ee6;
  }
}
</style>