index.vue

<template>
  <div class="app-container">
    <el-form :model="queryParams" ref="queryForm" :inline="true" v-show="showSearch" label-width="100px">
      <el-form-item label="投入台账名称" prop="investmentName">
        <el-input
          v-model="queryParams.investmentName"
          placeholder="请输入投入台账名称"
          clearable
          size="small"
          @keyup.enter.native="handleQuery"
        />
      </el-form-item>
      <el-form-item label="投入年度" prop="investmentYear">
        <el-date-picker
          v-model="queryParams.investmentYear"
          type="year"
          value-format="yyyy"
          size="small"
          clearable
          @keyup.enter.native="handleQuery"
          placeholder="选择年度">
        </el-date-picker>
      </el-form-item>
      <el-form-item label="投入类型" prop="investmentType">
        <el-select v-model="queryParams.investmentType" placeholder="请选择投入类型" clearable size="small">
          <el-option
            v-for="dict in investmentOptions"
            :key="dict.dictValue"
            :label="dict.dictLabel"
            :value="dict.dictValue"
          ></el-option>
        </el-select>
      </el-form-item>
      <el-form-item label="创建时间">
        <el-date-picker
          v-model="dateRange"
          size="small"
          style="width: 240px"
          value-format="yyyy-MM-dd"
          type="daterange"
          range-separator="-"
          start-placeholder="开始日期"
          end-placeholder="结束日期"
        ></el-date-picker>
      </el-form-item>
      <el-form-item>
        <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button>
        <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button>
      </el-form-item>
    </el-form>

    <el-row :gutter="10" class="mb8">
      <el-col :span="1.5">
        <el-button
          type="primary"
          plain
          icon="el-icon-plus"
          size="mini"
          @click="handleAdd"
        >新增</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button
          type="warning"
          plain
          icon="el-icon-download"
          size="mini"
		      :loading="exportLoading"
          @click="handleExport"
        >导出</el-button>
      </el-col>
      <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar>
    </el-row>

    <el-table v-loading="loading" :data="investmentList">
      <el-table-column label="投入台账名称" align="center" prop="investmentName" width="300px"/>
      <el-table-column label="投入年度" align="center" prop="investmentYear" />
      <el-table-column label="投入资金" align="center" prop="investmentFunds" />
      <el-table-column label="投入类型" align="center" prop="investmentType" :formatter="investmentFormat"  />
      <el-table-column label="同期收入" align="center" prop="income" >
        <template slot-scope="scope">
          <span v-if="scope.row.income != null && scope.row.income != ''">{{scope.row.income}}</span>
          <span v-else>-</span>
        </template>
      </el-table-column>
      <el-table-column label="提取方式" align="center" prop="drawType" :formatter="drawFormat"  />
      <el-table-column label="创建时间" align="center" prop="createTime" />
      <el-table-column label="操作" align="center" class-name="small-padding fixed-width">
        <template slot-scope="scope">
          <el-button
            size="mini"
            type="text"
            icon="el-icon-edit"
            @click="handleUpdate(scope.row)"
          >修改</el-button>
        </template>
      </el-table-column>
    </el-table>

    <pagination
      v-show="total>0"
      :total="total"
      :page.sync="queryParams.pageNum"
      :limit.sync="queryParams.pageSize"
      @pagination="getList"
    />

    <!-- 添加或修改投入台账对话框 -->
    <el-dialog :title="title" :visible.sync="open" width="800px" append-to-body>
      <el-form ref="form" :model="form" :rules="rules" label-width="120px">
        <el-row>
          <el-col :span="23">
            <el-form-item label="投入台账名称" prop="investmentName">
              <el-input v-model="form.investmentName" placeholder="请输入投入台账名称" />
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="11">
            <el-form-item label="投入年度" prop="investmentYear">
              <el-date-picker
                v-model="form.investmentYear"
                type="year"
                value-format="yyyy"
                placeholder="选择年度"
                style="width: 100%">
              </el-date-picker>
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="投入资金" prop="investmentFunds">
              <el-input v-model="form.investmentFunds" placeholder="请输入投入资金" />
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="11">
            <el-form-item label="投入类型" prop="investmentType">
              <el-select v-model="form.investmentType" placeholder="请选择投入类型" filterable clearable style="width: 100%">
                <el-option
                  v-for="dict in investmentOptions"
                  :key="dict.dictValue"
                  :label="dict.dictLabel"
                  :value="dict.dictValue"
                ></el-option>
              </el-select>
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="同期收入" prop="income">
              <el-input v-model="form.income" placeholder="请输入同期收入" />
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="11">
            <el-form-item label="提取方式" prop="drawType">
              <el-select v-model="form.drawType" placeholder="请选择提取方式" filterable clearable style="width: 100%">
                <el-option
                  v-for="dict in drawOptions"
                  :key="dict.dictValue"
                  :label="dict.dictLabel"
                  :value="dict.dictValue"
                ></el-option>
              </el-select>
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="时间单位" prop="timeUnit" v-if="form.drawType == '1'">
              <el-select v-model="form.timeUnit" placeholder="请选择提取时间单位" filterable clearable style="width: 100%">
                <el-option
                  v-for="dict in timeOptions"
                  :key="dict.dictValue"
                  :label="dict.dictLabel"
                  :value="dict.dictValue"
                ></el-option>
              </el-select>
            </el-form-item>
            <el-form-item label="项目名称" prop="projectName" v-if="form.drawType == '2'">
              <el-input v-model="form.projectName" placeholder="请输入项目名称" />
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="23">
            <el-form-item label="评价" prop="evaluate">
              <el-input type="textarea" v-model="form.evaluate" placeholder="请输入评价" />
            </el-form-item>
          </el-col>
        </el-row>
      </el-form>
      <div slot="footer" class="dialog-footer">
        <el-button type="primary" @click="submitForm">确 定</el-button>
        <el-button @click="cancel">取 消</el-button>
      </div>
    </el-dialog>
  </div>
</template>

<script>
import { listInvestment, getInvestment, delInvestment, addInvestment, updateInvestment, exportInvestment } from "@/api/safetyManagement/investment";

export default {
  name: "Investment",
  components: {
  },
  data() {
    return {
      // 遮罩层
      loading: true,
      // 导出遮罩层
      exportLoading: false,
      // 选中数组
      ids: [],
      // 非单个禁用
      single: true,
      // 非多个禁用
      multiple: true,
      // 显示搜索条件
      showSearch: true,
      // 总条数
      total: 0,
      // 投入台账表格数据
      investmentList: [],
      // 日期范围
      dateRange: [],
      investmentOptions: [],
      drawOptions: [],
      timeOptions: [],
      // 弹出层标题
      title: "",
      // 是否显示弹出层
      open: false,
      // 查询参数
      queryParams: {
        pageNum: 1,
        pageSize: 10,
        investmentName: null,
        investmentYear: null,
        investmentFunds: null,
        investmentType: null,
        income: null,
        drawType: null,
        evaluate: null,
      },
      // 表单参数
      form: {},
      // 表单校验
      rules: {
        investmentName: [
          { required: true, message: "请输入投入台账名称", trigger: "blur" }
        ],
        investmentYear: [
          { required: true, message: "请选择投入年度", trigger: "blur" }
        ],
        investmentFunds: [
          { required: true, message: "投入资金数字总共不超过11位，小数点不超过2位", validator: this.investmentFundsValidate }
        ],
        income: [
          { required: true, message: "同期收入数字总共不超过11位，小数点不超过2位", validator: this.incomeValidate }
        ],
        investmentType: [
          { required: true, message: "请选择投入类型", trigger: "blur" }
        ],
        drawType: [
          { required: true, message: "请选择提取方式", trigger: "blur" }
        ],
      }
    };
  },
  created() {
    this.getList();
    this.getDicts("t_investment_type").then(response => {
      this.investmentOptions = response.data;
    });
    this.getDicts("t_draw_type").then(response => {
      this.drawOptions = response.data;
    });
    this.getDicts("t_time_unit").then(response => {
      this.timeOptions = response.data;
    });
  },
  methods: {
    investmentFundsValidate(rule, value, callback){
      let reg = /^([1-9]\d*\.?\d{0,2}|0\.\d{1,2}|0)$/;
      if(value != '' && value != null){
        if(value.replace(".","").length > 11){
          console.log(value,"value");
          callback(new Error('数字不能超过11位'));
        }
        if(reg.test(value)){
          callback();
        }else{
          callback(new Error('请输入正确投入资金(小数点不超过2位)'));
        }
      }else{
        callback(new Error('请输入投入资金(小数点不超过2位)'));
      }
    },
    incomeValidate(rule, value, callback){
      let reg = /^([1-9]\d*\.?\d{0,2}|0\.\d{1,2}|0)$/;
      if(value != '' && value != null){
        if(value.replace(".","").length > 11){
          console.log(value,"value");
          callback(new Error('数字不能超过11位'));
        }
        if(reg.test(value)){
          callback();
        }else{
          callback(new Error('请输入正确同期收入(小数点不超过2位)'));
        }
      }else{
        callback();
      }
    },
    // 投入类型
    investmentFormat(row, column) {
      return this.selectDictLabel(this.investmentOptions, row.investmentType);
    },
    // 提取方式
    drawFormat(row, column) {
      return this.selectDictLabel(this.drawOptions, row.drawType);
    },
    /** 查询投入台账列表 */
    getList() {
      this.loading = true;
      listInvestment(this.addDateRange(this.queryParams, this.dateRange)).then(response => {
        this.investmentList = response.rows;
        this.total = response.total;
        this.loading = false;
      });
    },
    // 取消按钮
    cancel() {
      this.open = false;
      this.reset();
    },
    // 表单重置
    reset() {
      this.form = {
        id: null,
        investmentName: null,
        investmentYear: null,
        investmentFunds: null,
        investmentType: null,
        income: null,
        timeUnit: null,
        projectName: null,
        drawType: null,
        evaluate: null,
        createTime: null,
        updateTime: null
      };
      this.resetForm("form");
    },
    /** 搜索按钮操作 */
    handleQuery() {
      this.queryParams.pageNum = 1;
      this.getList();
    },
    /** 重置按钮操作 */
    resetQuery() {
      this.dateRange = [];
      this.resetForm("queryForm");
      this.handleQuery();
    },
    /** 新增按钮操作 */
    handleAdd() {
      this.reset();
      this.open = true;
      this.title = "添加投入台账";
    },
    /** 修改按钮操作 */
    handleUpdate(row) {
      this.reset();
      const id = row.id || this.ids
      getInvestment(id).then(response => {
        this.form = response.data;
        console.log("this.form",this.form)
        // investmentYear投入年度数据库中为year类型，类中为short
        this.form.investmentYear = "'" + this.form.investmentYear + "'";
        this.open = true;
        this.title = "修改投入台账";
      });
    },
    /** 提交按钮 */
    submitForm() {
      this.$refs["form"].validate(valid => {
        console.log("this.form", this.form)
        if (valid) {
          // income同期收入，数值类型
          if(this.form.income == ''){
            this.form.income = null;
          }
          if(this.form.investmentType == '1'){
            this.form.projectName = null;
          } else if(this.form.investmentType == '2'){
            this.form.timeUnit = null;
          }
          // investmentYear投入年度数据库中为year类型，类中为short
          this.form.investmentYear = eval(this.form.investmentYear);
          if (this.form.id != null) {
            updateInvestment(this.form).then(response => {
              this.msgSuccess("修改成功");
              this.open = false;
              this.getList();
            });
          } else {
            addInvestment(this.form).then(response => {
              this.msgSuccess("新增成功");
              this.open = false;
              this.getList();
            });
          }
        }
      });
    },
    /** 导出按钮操作 */
    handleExport() {
      const queryParams = this.queryParams;
      this.$confirm('是否确认导出所有投入台账数据项?', "警告", {
          confirmButtonText: "确定",
          cancelButtonText: "取消",
          type: "warning"
        }).then(() => {
          this.exportLoading = true;
          return exportInvestment(queryParams);
        }).then(response => {
          this.download(response.msg);
          this.exportLoading = false;
        }).catch(() => {});
    }
  }
};
</script>