dy-admin-manager/src/views/businessManager/orderManager/income.vue

<template>
  <div class="m-container">
    <h2>
      <div class="squrt"></div>
      订单管理
    </h2>
    <div class="m-core">
      <div
        class="newBand"
        @click="onOrderExport"
        v-permission="{ child: 'export/orderList', parent: '/income' }"
      >
        报表导出
      </div>
      <!-- 搜索类型 -->
      <save-form
        :inline="true"
        class="searchForm"
        :model="searchForm"
        @submit="search"
        @reset="onReSet"
      >
        <el-form-item>
          <el-input
            placeholder="学生编号/姓名/手机号"
            type="text"
            clearable
            v-model.trim="searchForm.search"
          ></el-input>
        </el-form-item>
        <el-form-item>
          <el-input
            placeholder="交易流水号"
            clearable
            type="text"
            v-model.trim="searchForm.transNo"
          ></el-input>
        </el-form-item>
        <el-form-item>
          <el-input
            placeholder="订单号"
            clearable
            type="text"
            v-model.trim="searchForm.orderNo"
          ></el-input>
        </el-form-item>
        <el-form-item>
          <el-input
            placeholder="收款账户"
            clearable
            type="text"
            v-model.trim="searchForm.merNos"
          ></el-input>
        </el-form-item>
        <el-form-item>
          <el-input
            placeholder="余额支付大于等于"
            clearable
            type="number"
            @mousewheel.native.prevent
            v-model.trim="searchForm.balancePaymentAmount"
          ></el-input>
        </el-form-item>
        <el-form-item>
          <el-input
            placeholder="现金支付大于等于"
            clearable
            type="number"
            @mousewheel.native.prevent
            v-model.trim="searchForm.actualAmount"
          ></el-input>
        </el-form-item>
        <el-form-item>
          <el-input
            placeholder="余额支付小于等于"
            clearable
            type="number"
            @mousewheel.native.prevent
            v-model.trim="searchForm.lessBalancePaymentAmount"
          ></el-input>
        </el-form-item>
        <el-form-item>
          <el-input
            placeholder="现金支付小于等于"
            clearable
            type="number"
            @mousewheel.native.prevent
            v-model.trim="searchForm.lessActualAmount"
          ></el-input>
        </el-form-item>
        <el-form-item prop="organId">
          <el-select
            class="multiple"
            v-model.trim="searchForm.organId"
            filterable
            clearable
            @clear="onClear('organId')"
            placeholder="请选择分部"
          >
            <el-option
              v-for="(item, index) in selects.branchs"
              :key="index"
              :label="item.name"
              :value="item.id"
            ></el-option>
          </el-select>
        </el-form-item>
        <el-form-item>
          <el-date-picker
            v-model="searchForm.orderDate"
            style="width: 410px"
            type="daterange"
            value-format="yyyy-MM-dd"
            range-separator="至"
            :picker-options="{
              firstDayOfWeek: 1,
            }"
            start-placeholder="订单开始日期"
            end-placeholder="订单结束日期"
          ></el-date-picker>
        </el-form-item>
        <el-form-item>
          <el-select
            v-model.trim="searchForm.paymentType"
            clearable
            filterable
            @clear="onClear('paymentType')"
            placeholder="交易类型"
          >
            <el-option
              v-for="(item, index) in orderStatus"
              :key="index"
              :label="item.label"
              :value="item.value"
            ></el-option>
          </el-select>
        </el-form-item>
        <el-form-item>
          <el-select
            v-model.trim="searchForm.paymentStatus"
            clearable
            filterable
            @clear="onClear('paymentStatus')"
            placeholder="交易状态"
          >
            <el-option
              v-for="(item, index) in dealStatus"
              :key="index"
              :label="item.label"
              :value="item.value"
            ></el-option>
          </el-select>
        </el-form-item>
        <el-form-item>
          <el-button native-type="submit" type="danger">搜索</el-button>
          <el-button native-type="reset" type="primary">重置</el-button>
        </el-form-item>
      </save-form>
      <!-- 列表 -->
      <!-- totalUserBalance: 20452784.02
      totalExpectAmount: 0
      totalActualAmount: 0
      totalAdvanceAmount: 0
      totalRevenueAmount: 0 -->
      <div style="font-size: 14px; color: #f85043; padding-bottom: 10px">
        <!-- 应收总金额：{{ totalExpectAmount }}元 &nbsp;&nbsp;&nbsp;&nbsp;
        现金实收总额：{{ totalActualAmount }}元 &nbsp;&nbsp;&nbsp;&nbsp;
        余额实收总额：{{ Number((totalExpectAmount - totalActualAmount).toFixed(2)) }}元 -->
        <!-- 营收金额=2-3
        实收金额=应收总额（包含余额支付）
        预收金额=充值总额（发生消费，记负数）
        预收余额=充值总余额 -->
        营收金额：{{ totalRevenueAmount | moneyFormat }}元<i
          style="width: 10px; display: inline-block"
        ></i>
        实收金额：{{ totalActualAmount | moneyFormat }}元<i
          style="width: 10px; display: inline-block"
        ></i>
        预收金额：{{ totalAdvanceAmount | moneyFormat }}元<i
          style="width: 10px; display: inline-block"
        ></i>
        预收余额：{{ totalUserBalance | moneyFormat }}元
      </div>
      <div class="tableWrap">
        <el-table
          :data="tableList"
          :header-cell-style="{ background: '#EDEEF0', color: '#444' }"
        >
               <el-table-column
            align="center"
            prop="transNo"
            label="所属分部"
          >
            <template slot-scope="scope">
              <div>
                <copy-text>{{ scope.row.organName }}</copy-text>
              </div>
            </template>
          </el-table-column>
          <el-table-column
            align="center"
            width="180px"
            prop="transNo"
            label="交易流水号"
          >
            <template slot-scope="scope">
              <div>
                <copy-text>{{ scope.row.transNo }}</copy-text>
              </div>
            </template>
          </el-table-column>
          <el-table-column
            align="center"
            width="210px"
            prop="orderNo"
            label="订单号"
          >
            <template slot-scope="scope">
              <div>
                <copy-text>{{ scope.row.orderNo }}</copy-text>
              </div>
            </template>
          </el-table-column>
          <el-table-column
            align="center"
            width="150"
            prop="createTime"
            label="订单日期"
          >
            <template slot-scope="scope">{{
              scope.row.createTime | dateForMinFormat
            }}</template>
          </el-table-column>
          <el-table-column align="center" width="100px" label="交易类型">
            <template slot-scope="scope">{{
              scope.row.type | orderType
            }}</template>
          </el-table-column>
          <el-table-column align="center" prop="expectAmount" label="应付金额">
            <template slot-scope="scope">
              <div>
                {{ scope.row.expectAmount | moneyFormat }}
              </div>
            </template>
          </el-table-column>
          <el-table-column
            align="center"
            prop="balancePaymentAmount"
            label="余额支付"
          >
            <template slot-scope="scope">
              <div>
                {{ scope.row.balancePaymentAmount | moneyFormat }}
              </div>
            </template>
          </el-table-column>
          <el-table-column align="center" prop="actualAmount" label="现金支付">
            <template slot-scope="scope">
              <div>
                {{ scope.row.actualAmount | moneyFormat }}
              </div>
            </template>
          </el-table-column>
          <el-table-column align="center" label="学员姓名">
            <template slot-scope="scope">
              <copy-text> {{ scope.row.user.username }}</copy-text>
              <span v-if="scope.row.user.username && scope.row.user.phone"
                >/</span
              >
              <copy-text>
                {{ scope.row.user.phone }}
              </copy-text>
            </template>
          </el-table-column>
          <el-table-column
            align="center"
            prop="paymentChannel"
            label="交易方式"
          >
            <template slot-scope="scope">{{
              scope.row.paymentChannel | paymentChannelStatus
            }}</template>
          </el-table-column>
          <!-- <el-table-column align="center"
                           label="收款账户">
            <template slot-scope="scope">{{ scope.row.merNos }}</template>
          </el-table-column> -->
          <el-table-column align="center" label="交易状态">
            <template slot-scope="scope">{{
              scope.row.status | dealStatus
            }}</template>
          </el-table-column>
          <el-table-column align="center" label="备注">
            <template slot-scope="scope">{{
              scope.row.memo ? scope.row.memo : "-"
            }}</template>
          </el-table-column>
          <el-table-column align="center" width="150px" label="操作">
            <template slot-scope="scope">
              <el-button
                v-if="
                  scope.row.status != 'SUCCESS' && scope.row.actualAmount > 0
                "
                v-permission="'order/getOrderStatus'"
                @click="onGetOrderStatus(scope.row)"
                type="text"
                >查询订单状态</el-button
              >
            </template>
          </el-table-column>
        </el-table>
        <pagination
          sync
          :total.sync="pageInfo.total"
          :page.sync="pageInfo.page"
          :limit.sync="pageInfo.limit"
          :page-sizes="pageInfo.page_size"
          @pagination="getList"
        />
      </div>
    </div>
  </div>
</template>
<script>
import pagination from "@/components/Pagination/index";
import { orderQueryPage, getOrderStatus } from "@/api/orderManager";
import { getEmployeeOrgan } from "@/api/buildTeam";
import store from "@/store";
import cleanDeep from "clean-deep";
import { orderStatus, dealStatus } from "@/utils/searchArray";
import axios from "axios";
import qs from "qs";
import { getToken } from "@/utils/auth";
import load from "@/utils/loading";
import { getTimes } from "@/utils";
export default {
  components: { pagination },
  name: "income",
  data() {
    return {
      orderStatus: orderStatus,
      dealStatus: dealStatus,
      searchForm: {
        search: null,
        orderStartDate: null,
        orderEndDate: null,
        paymentStatus: "SUCCESS",
        paymentType: null,
        organId: null,
        actualAmount: null,
        balancePaymentAmount: null,
        orderNo: null,
        transNo: null,
        merNos: null,
        lessBalancePaymentAmount: null,
        lessActualAmount: null,
        orderDate: [],
      },
      tableList: [],
      organList: [],
      pageInfo: {
        // 分页规则
        limit: 10, // 限制显示条数
        page: 1, // 当前页
        total: 0, // 总条数
        page_size: [10, 20, 40, 50], // 选择限制显示条数
      },
      totalUserBalance: 0,
      totalActualAmount: 0,
      totalAdvanceAmount: 0,
      totalRevenueAmount: 0,
    };
  },
  created(){
    if (this.searchForm.orderDate?.length < 1) {
      var now = new Date();
      var startDate = new Date(
        Date.UTC(now.getFullYear(), now.getMonth(), now.getDate())
      )
        .toISOString()
        .slice(0, 10);
      //  + " 00:00:00"  + " 23:59:59"
      var endDate = new Date(
        Date.UTC(now.getFullYear(), now.getMonth(), now.getDate())
      )
        .toISOString()
        .slice(0, 10);
      this.searchForm.orderDate = [];
      this.searchForm.orderDate.push(startDate);
      this.searchForm.orderDate.push(endDate);
    }
  },
  mounted() {



    this.$store.dispatch("setBranchs");
    this.getList();
  },
  methods: {
    onClear(type) {
      if (type == "paymentType") {
        this.searchForm.paymentType = null;
      } else if (type == "paymentStatus") {
        this.searchForm.paymentStatus = null;
      } else if (type == "organId") {
        this.searchForm.organId = null;
      }
    },
    onOrderExport() {
      // 报表导出
      let url = "/api-web/export/orderList";
      let searchForm = this.searchForm;
      let data = {
        orderType: 0,
        search: searchForm.search,
        orderNo: searchForm.orderNo,
        transNo: searchForm.transNo,
        merNos: searchForm.merNos,
        actualAmount: searchForm.actualAmount,
        balancePaymentAmount: searchForm.balancePaymentAmount,
        paymentStatus: searchForm.paymentStatus,
        paymentType: searchForm.paymentType,
        organId: searchForm.organId,
        lessBalancePaymentAmount: searchForm.lessBalancePaymentAmount,
        lessActualAmount: searchForm.lessActualAmount,
      };
      if (this.searchForm.orderDate && this.searchForm.orderDate.length > 0) {
        data.orderStartDate = this.searchForm.orderDate[0];
        data.orderEndDate = this.searchForm.orderDate[1];
      } else {
        data.orderStartDate = null;
        data.orderEndDate = null;
      }
      const options = {
        method: "POST",
        headers: {
          Authorization: getToken(),
        },
        data: qs.stringify(cleanDeep(data)),
        url,
        responseType: "blob",
      };
      this.$confirm("您确定导出报表", "提示", {
        confirmButtonText: "确定",
        cancelButtonText: "取消",
        type: "warning",
      })
        .then(() => {
          load.startLoading();
          axios(options)
            .then((res) => {
              let blob = new Blob([res.data], {
                // type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8'
                type: "application/vnd.ms-excel;charset=utf-8",
                //word文档为application/msword,pdf文档为application/pdf,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8
              });
              let text = new Response(blob).text();
              text.then((res) => {
                // 判断是否报错
                if (res.indexOf("code") != -1) {
                  let json = JSON.parse(res);
                  this.$message.error(json.msg);
                } else {
                  let objectUrl = URL.createObjectURL(blob);
                  let link = document.createElement("a");
                  let nowTime = new Date();
                  let ymd =
                    nowTime.getFullYear() +
                    "" +
                    (nowTime.getMonth() + 1) +
                    "" +
                    nowTime.getDate() +
                    "" +
                    nowTime.getHours() +
                    "" +
                    nowTime.getMinutes();
                  let fname = "报表导出" + new Date().getTime()+'.xls'; //下载文件的名字
                  link.href = objectUrl;
                  link.setAttribute("download", fname);
                  document.body.appendChild(link);
                  link.click();
                }
              });

              load.endLoading();
            })
            .catch((error) => {
              this.$message.error("导出数据失败，请联系管理员");
              load.endLoading();
            });
        })
        .catch(() => {});
    },
    search() {
      this.pageInfo.page = 1;
      this.getList();
    },
    getList() {

          let { orderDate, ...rest } = this.searchForm;
      let params = {
        ...rest,
        page: this.pageInfo.page,
        rows: this.pageInfo.limit,
        ...getTimes(orderDate, ["orderStartDate", "orderEndDate"]),
      };
      // let params = JSON.parse(JSON.stringify(this.searchForm));
      // params.rows = this.pageInfo.limit;
      // params.page = this.pageInfo.page;
      // params.orderNo = params.orderNo ? params.orderNo : null;
      // params.transNo = params.transNo ? params.transNo : null;
      // params.merNos = params.merNos ? params.merNos : null;
      // params.actualAmount = params.actualAmount ? params.actualAmount : null;
      // params.balancePaymentAmount = params.balancePaymentAmount
      //   ? params.balancePaymentAmount
      //   : null;
      // if (this.orderDate && this.orderDate.length > 0) {
      //   params.orderStartDate = this.orderDate[0];
      //   params.orderEndDate = this.orderDate[1];
      // } else {
      //   params.orderStartDate = null;
      //   params.orderEndDate = null;
      // }
      orderQueryPage(cleanDeep(params)).then((res) => {
        let result = res.data;
        if (res.code == 200) {
          this.tableList = result.rows;
          this.pageInfo.total = result.total;
          this.totalUserBalance = result.totalUserBalance
            ? result.totalUserBalance
            : 0;
          this.totalActualAmount = result.totalActualAmount
            ? result.totalActualAmount
            : 0;
          this.totalAdvanceAmount = result.totalAdvanceAmount
            ? result.totalAdvanceAmount
            : 0;
          this.totalRevenueAmount = result.totalRevenueAmount
            ? result.totalRevenueAmount
            : 0;
        }
      });
    },
    onGetOrderStatus(row) {
      this.$confirm("您确定查询该订单状态", "提示", {
        confirmButtonText: "确定",
        cancelButtonText: "取消",
        type: "warning",
      })
        .then(() => {
          getOrderStatus({ id: row.id }).then((res) => {
            this.getList();
          });
        })
        .catch((err) => {});
    },
    onReSet() {
      // 重置搜索
      this.searchForm = {
        search: null,
        orderStartDate: null,
        orderEndDate: null,
        paymentStatus: null,
        paymentType: null,
        organId: null,
        actualAmount: null,
        balancePaymentAmount: null,
        orderNo: null,
        transNo: null,
        merNos: null,
        lessBalancePaymentAmount: null,
        lessActualAmount: null,
        orderDate:[]
      };
      this.getList();
    },
  },
};
</script>
<style lang="scss">
</style>