报表

zhangzeli

2021-11-26 dda6070f6c238223b1395f765b61fc377c8a0622

报表

 src/api/open.js

@@ -201,3 +201,8 @@
export const getByDate = (params) => {
    return getRequest('/addOil/getByDate', params)
}

// 根据车辆燃油费用维修费用
export const getInfo = (params) => {
    return getRequest('/car/getInfo', params)
}

 src/views/your/car-manage/carManage.vue

@@ -82,12 +82,12 @@
        </FormItem>
        <FormItem label="驾驶人" prop="userId">
          <Select v-model="carForm.userId" filterable>
            <Option v-for="item in userList" :value="item.id">{{ item.nickname }}</Option>
            <Option v-for="item in userList" :value="item.id" :key="item.id">{{ item.nickname }}</Option>
          </Select>
        </FormItem>
        <FormItem label="跟车人" prop="followUserId">
          <Select v-model="carForm.followUserId" filterable>
            <Option v-for="item in userList" :value="item.id">{{ item.nickname }}</Option>
            <Option v-for="item in userList" :value="item.id" :key="item.id">{{ item.nickname }}</Option>
          </Select>
        </FormItem>
      </Form>

 src/views/your/carCost-manage/carCostManage.less

New file
@@ -0,0 +1,13 @@
.permModal {
    .ivu-modal-body {
        max-height: 560px;
        overflow: auto;
    }
}

.depModal {
    .ivu-modal-body {
        max-height: 500px;
        overflow: auto;
    }
}

 src/views/your/carCost-manage/carCostManage.vue

New file
@@ -0,0 +1,904 @@
<style lang="less">
  @import "@/styles/table-common.less";
  @import "@/styles/drawer-common.less";
  @import "src/views/your/carCost-manage/carCostManage.less";
</style>
<template>
  <div class="search">
    <Card>
      <Row class="operation">
        <Button @click="init" icon="md-refresh">刷新</Button>
        <Button type="dashed" @click="openTip = !openTip">{{
          openTip ? "关闭提示" : "开启提示"
          }}</Button>
        <Date-picker v-model="value" @on-change="getDataList"
                     value-format="yyyy-MM-dd" type="daterange" placement="bottom-end" placeholder="请选择日期" style="width: 240px;padding-left: 20px">
        </Date-picker>
        <Dropdown @on-click="handleDropdown" style="padding-left: 20px">
          <Button>
            导出数据
            <Icon type="md-arrow-dropdown" />
          </Button>
          <DropdownMenu slot="list">
            <DropdownItem name="exportAll">导出所选日期数据</DropdownItem>
          </DropdownMenu>
        </Dropdown>
      </Row>
      <Alert show-icon v-show="openTip">
        已选择
        <span class="select-count">{{ selectList.length }}</span> 项
        <a class="select-clear" @click="clearSelectAll">清空</a>
      </Alert>
      <Table
              :loading="loading"
              border
              :columns="columns"
              :data="data"
              ref="table"
              sortable="custom"
              @on-sort-change="changeSort"
              @on-selection-change="changeSelect"
      ></Table>
      <Row type="flex" justify="end" class="page">
        <Page
                :current="searchForm.pageNumber"
                :total="total"
                :page-size="searchForm.pageSize"
                @on-change="changePage"
                @on-page-size-change="changePageSize"
                :page-size-opts="[10, 20, 50]"
                size="small"
                show-total
                show-elevator
                show-sizer
                v-show="this.page"
        ></Page>
      </Row>
    </Card>

    <!-- 编辑 -->
    <Modal
            :title="modalTitle"
            v-model="roleModalVisible"
            :mask-closable="false"
            :width="500"
    >
    </Modal>
    <!-- 菜单权限 -->
    <Drawer
            :title="modalTitle"
            v-model="permModalVisible"
            :mask-closable="false"
            :width="500"
            draggable
    >
      <div :style="{ maxHeight: maxHeight }" class="drawer-content">
        <div style="position: relative">
          <Tree
                  ref="tree"
                  :data="permData"
                  show-checkbox
                  :render="renderContent"
                  :check-strictly="true"
          ></Tree>
          <Spin size="large" fix v-if="treeLoading"></Spin>
        </div>
      </div>
      <div class="drawer-footer br">
        <Button
                type="primary"
                :loading="submitPermLoading"
                @click="submitPermEdit"
        >提交</Button
        >
        <Button @click="selectTreeAll">全选/反选</Button>
        <Select
                v-model="openLevel"
                @on-change="changeOpen"
                style="width: 110px"
                transfer
        >
          <Option value="0">展开所有</Option>
          <Option value="1">收合所有</Option>
          <Option value="2">仅展开一级</Option>
          <Option value="3">仅展开两级</Option>
        </Select>
        <Button type="text" @click="cancelPermEdit">取消</Button>
      </div>
    </Drawer>
    <!-- 数据权限 -->
    <Modal
            :title="modalTitle"
            v-model="carModalVisible"
            :mask-closable="false"
            :width="500"
            class="depModal"
    >
      <Form :label-width="85" ref="removeForm" :model="removeForm">
        <FormItem label="移除原因" prop="removeReason">
          <Input v-model="removeForm.removeReason"/>
        </FormItem>
      </Form>
      <div v-show="dataType == 1" style="margin-top: 15px">
        <div style="position: relative">
          <Tree
                  ref="depTree"
                  :data="depData"
                  :load-data="loadData"
                  @on-toggle-expand="expandCheckDep"
                  multiple
                  style="margin-top: 15px"
          ></Tree>
          <Spin size="large" fix v-if="depTreeLoading"></Spin>
        </div>
      </div>
      <div slot="footer">
        <Button type="text" @click="depModalVisible = false">取消</Button>
        <Button
                type="primary"
                :loading="submitDepLoading"
                @click="submitRemove"
        >提交</Button
        >
      </div>
    </Modal>
    <Modal
            v-model="exportModalVisible"
            :title="exportTitle"
            :loading="loadingExport"
            @on-ok="exportCustomData"
    >
      <Form ref="exportForm" :label-width="100">
        <FormItem label="导出文件名">
          <Input v-model="filename" />
        </FormItem>
      </Form>
    </Modal>
  </div>
</template>

<script>
  import {
    getAllPermissionList,
    setDefaultRole,
    editRolePerm,
    initDepartment,
    loadDepartment,
    editRoleDep,
  } from "@/api/index";

  import {
    getAll,
    getAddOilList,
    addOil,
    deleteAddOil,
    getCarList,
    editCar,
    deleteCar,
    getByDate,
    getOilExcel
  } from "@/api/open";
  import util from "@/libs/util.js";
  import excel from "@/libs/excel.js";
  import XLSX from 'xlsx';
  import {exportColumn} from "./exportColumn";
  export default {
    name: "car-manage",
    data() {
      return {
        maxHeight: 510,
        openTip: true,
        openLevel: "0",
        loading: true,
        treeLoading: true,
        depTreeLoading: true,
        submitPermLoading: false,
        submitDepLoading: false,
        searchKey: "",
        sortColumn: "createTime",
        sortType: "desc",
        modalType: 0,
        roleModalVisible: false,
        page: true,
        carModalVisible: false,
        exportModalVisible: false,
        loadingExport: true,
        permModalVisible: false,
        depModalVisible: false,
        modalTitle: "",
        searchForm: {
          // 搜索框初始化对象
          pageNumber: 1, // 当前页数
          pageSize: 10, // 页面大小
          sort: "createTime", // 默认排序字段
          order: "desc", // 默认排序方式
          key: "",
        },
        addOilForm: {
          status : 0
        },
        removeForm: {
          status : 1
        },
        addOilFormValidate: {
          name: [
            { required: true, message: "角色名称不能为空", trigger: "change" },
          ],
        },
        submitLoading: false,
        selectList: [],
        columns: [
          {
            type: "selection",
            width: 60,
            align: "center",
          },
          {
            type: "index",
            width: 60,
            align: "center",
          },
          {
            title: "车牌号",
            key: "carNo",
            width: 100,
          },
          {
            title: "加油卡号",
            key: "addOilCode",
            width: 120,
            sortable: true,
            align: "center",
          },
          {
            title: "加油日期",
            key: "addDate",
            width: 120,
            sortable: true,
            align: "center",
          },
          {
            title: "加油量(升)",
            key: "amount",
            width: 130,
            sortable: true,
            align: "center",
            render: (h, params) => {
              return h("div",params.row.amount==0 ? '':params.row.amount);
            }
          },
          {
            title: "含税金额(元)",
            key: "money",
            width: 140,
            sortable: true,
            align: "center",
            render: (h, params) => {
              return h("div",params.row.money==0 ? '':params.row.money);
            }
          },
          {
            title: "过路过桥费(元)",
            key: "",
            width: 150,
            sortable: true,
            align: "center",
          },
          {
            title: "年审费(元)",
            key: "",
            width: 130,
            sortable: true,
            align: "center",
          },
          {
            title: "洗车停车费(元)",
            key: "",
            width: 150,
            sortable: true,
            align: "center",
          },
          {
            title: "保险费含(车船税)",
            key: "",
            width: 170,
            sortable: true,
            align: "center",
          },
        ],
        data: [],
        chooseColumns: [],
        total: 0,
        permData: [],
        exportColumns: exportColumn,
        filename: "加油数据",
        exportTitle: "确认导出",
        editRolePermId: "",
        selectAllFlag: false,
        depData: [],
        dataType: 0,
        editDepartments: [],
        buyYear:'',
        carList:[],
        value:[]
      };
    },
    methods: {
      change1(e){
        this.addDate = e;
      },
      init() {
        this.getDataList();
        // 获取所有菜单权限树
        this.getPermList();
        this.getAllCar();
      },
      renderContent(h, { root, node, data }) {
        let icon = "";
        if (data.level == 0) {
          icon = "ios-navigate";
        } else if (data.level == 1) {
          icon = "md-list-box";
        } else if (data.level == 2) {
          icon = "md-list";
        } else if (data.level == 3) {
          icon = "md-radio-button-on";
        } else {
          icon = "md-radio-button-off";
        }
        return h(
                "span",
                {
                  style: {
                    display: "inline-block",
                    cursor: "pointer",
                  },
                  on: {
                    click: () => {
                      if (data.status == -1) {
                        return;
                      }
                      data.checked = !data.checked;
                    },
                  },
                },
                [
                  h("span", [
                    h("Icon", {
                      props: {
                        type: icon,
                        size: "16",
                      },
                      style: {
                        "margin-right": "8px",
                        "margin-bottom": "3px",
                      },
                    }),
                    h("span", data.title),
                  ]),
                ]
        );
      },
      handleDropdown(name) {
        if (name == "refresh") {
          this.getDataList();
        } else if (name == "exportData") {
          if (this.selectList.length <= 0) {
            this.$Message.warning("您还未选择要导出的数据");
            return;
          }
          this.exportType = "part";
          this.exportModalVisible = true;
          this.exportTitle =
                  "确认导出数据";
        } else if (name == "exportAll") {
          this.exportType = "all";
          this.exportModalVisible = true;
          this.exportTitle = "确认导出全部数据";
          getOilExcel(this.searchForm).then((res) => {
            if (res.success) {
              this.exportData = res.result;
            }
          });
        } else if (name == "importData") {
          this.importModalVisible = true;
        }
      },
      //导出数据
      exportCustomData() {
        if (this.filename == "") {
          this.filename = "加油数据";
        }
        // 判断勾选导出列
        let exportColumns = [];
        this.exportColumns.forEach((e) => {
          exportColumns.push(e);
        });
        this.exportModalVisible = false;
        let title = [];
        let key = [];
        exportColumns.forEach((e) => {
          title.push(e.title);
          key.push(e.key);
        });
        console.log(this.exportData)
        const params = {
          title: title,
          key: key,
          data: this.exportData,
          autoWidth: true,
          filename: this.filename,
        };
        this.exportData.forEach((i) => {
          console.log(i);

          i.amount = i.amount == 0 ? '': i.amount ;
          i.unitPrice = i.unitPrice == 0 ? '' : i.unitPrice;
          i.money = i.money == 0 ? '' : i.money;
          i.mileage = i.mileage == 0 ? '' : i.mileage;
        });
        excel.export_array_to_excel(params);
      },
      changePage(v) {
        this.searchForm.pageNumber = v;
        this.getDataList();
        this.clearSelectAll();
      },
      changePageSize(v) {
        this.searchForm.pageSize = v;
        this.getDataList();
      },
      changeSort(e) {
        this.searchForm.sort = e.key;
        this.searchForm.order = e.order;
        if (e.order == "normal") {
          this.searchForm.order = "";
        }
        this.getDataList();
      },
      selectDate(dateData) {
        let date = new Date (dateData)
        let y = date . getFullYear()
        let m = date . getMonth() + 1
        m=m<10?('0'+m):m
        let d = date.getDate()
        d = d< 10?('0'+ d):d
        const time = y + '-' + m + '-' + d;
        return time
      },
      getDataList() {
        this.loading = true;
        if (this.value[0]!="" && this.value[1]!=""){
          this.searchForm.beginTime = this.selectDate(this.value[0]);
          this.searchForm.endTime = this.selectDate(this.value[1]);
          this.page=false;
        }else{
          this.searchForm.beginTime = "";
          this.searchForm.endTime = "";
        }
        getOilExcel(this.searchForm).then((res) => {
          this.loading = false;
          if (res.success) {
            this.data = res.result;
            this.total = res.result.length;
          }
        });
      },
      getPermList() {
        this.treeLoading = true;
        getAllPermissionList().then((res) => {
          if (res.success) {
            this.deleteDisableNode(res.result);
            this.permData = res.result;
            this.treeLoading = false;
          }
          this.treeLoading = false;
        });
      },
      // 递归标记禁用节点
      deleteDisableNode(permData) {
        let that = this;
        permData.forEach(function (e) {
          if (e.status == -1) {
            e.title = "[已禁用] " + e.title;
            e.disabled = true;
          }
          if (e.children && e.children.length > 0) {
            that.deleteDisableNode(e.children);
          }
        });
      },
      carRole() {
        this.roleModalVisible = false;
      },
      submitAddOil() {
        this.addOilForm.addDate = this.addDate;
        this.$refs.addOilForm.validate((valid) => {
          if (valid) {
            if (this.modalType == 0) {
              // 添加
              this.submitLoading = true;
              addOil(this.addOilForm).then((res) => {
                this.submitLoading = false;
                if (res.success) {
                  this.$Message.success("操作成功");
                  this.getDataList();
                  this.roleModalVisible = false;
                }
              });
            } else {
              this.submitLoading = true;
              addOil(this.addOilForm).then((res) => {
                this.submitLoading = false;
                if (res.success) {
                  this.$Message.success("操作成功");
                  this.getDataList();
                  this.roleModalVisible = false;
                }
              });
            }
          }
        });
      },
      submitRemove(){
        this.$refs.removeForm.validate((valid) => {
          if (valid) {
            this.submitLoading = true;
            editCar(this.removeForm).then((res) => {
              this.submitLoading = false;
              if (res.success) {
                this.$Message.success("操作成功");
                this.getDataList();
                this.carModalVisible = false;
              }
            });
          }
        });
      },
      addOil() {
        this.modalType = 0;
        this.modalTitle = "添加加油记录";
        this.$refs.addOilForm.resetFields();
        delete this.addOilForm.id;
        this.roleModalVisible = true;
      },
      edit(v) {
        this.getAllCar();
        this.addDate = v.addDate;
        this.modalType = 1;
        this.modalTitle = "编辑加油信息";
        this.$refs.addOilForm.resetFields();
        // 转换null为""
        for (let attr in v) {
          if (v[attr] == null) {
            v[attr] = "";
          }
        }
        let str = JSON.stringify(v);
        let roleInfo = JSON.parse(str);

        this.addOilForm = roleInfo;
        this.roleModalVisible = true;
      },
      removeCar(v) {
        this.dataType = 0;
        this.modalTitle = "移除车辆";
        this.$refs.addOilForm.resetFields();
        // 转换null为""
        for (let attr in v) {
          if (v[attr] == null) {
            v[attr] = "";
          }
        }
        let str = JSON.stringify(v);
        let roleInfo = JSON.parse(str);
        roleInfo.status=1
        console.log(roleInfo);
        this.removeForm = roleInfo;
        this.carModalVisible = true;

      },
      getAllCar(){
        getAll().then((res) => {
          if(res.success){
            this.carList = res.result;
            console.log(this.carList);
          }
        });
      },
      remove(v) {
        this.$Modal.confirm({
          title: "确认删除",
          content: "您确认要删除吗 ",
          loading: true,
          onOk: () => {
            deleteAddOil({ ids: v.id }).then((res) => {
              this.$Modal.remove();
              if (res.success) {
                this.clearSelectAll();
                this.$Message.success("删除成功");
                this.getDataList();
              }
            });
          },
        });
      },
      setDefault(v) {
        this.loading = true;
        let params = {
          id: v.id,
          isDefault: true,
        };
        setDefaultRole(params).then((res) => {
          this.loading = false;
          if (res.success) {
            this.$Message.success("操作成功");
            this.getDataList();
          }
        });
      },
      cancelDefault(v) {
        this.loading = true;
        let params = {
          id: v.id,
          isDefault: false,
        };
        setDefaultRole(params).then((res) => {
          this.loading = false;
          if (res.success) {
            this.$Message.success("操作成功");
            this.getDataList();
          }
        });
      },
      clearSelectAll() {
        this.$refs.table.selectAll(false);
      },
      changeSelect(e) {
        this.selectList = e;
      },
      delAll() {
        if (this.selectList.length <= 0) {
          this.$Message.warning("您还未选择要删除的数据");
          return;
        }
        this.$Modal.confirm({
          title: "确认删除",
          content: "您确认要删除所选的 " + this.selectList.length + " 条数据?",
          loading: true,
          onOk: () => {
            let ids = "";
            this.selectList.forEach(function (e) {
              ids += e.id + ",";
            });
            ids = ids.substring(0, ids.length - 1);
            deleteCar({ ids: ids }).then((res) => {
              this.$Modal.remove();
              if (res.success) {
                this.$Message.success("删除成功");
                this.clearSelectAll();
                this.getDataList();
              }
            });
          },
        });
      },
      editPerm(v) {
        this.editRolePermId = v.id;
        this.modalTitle = "分配 " + v.name + " 的菜单权限";
        // 匹配勾选
        let rolePerms = v.permissions;
        if (this.treeLoading) {
          this.$Message.warning("菜单权限数据加载中，请稍后点击查看");
          return;
        }
        // 递归判断子节点
        this.checkPermTree(this.permData, rolePerms);
        this.permModalVisible = true;
      },
      // 递归判断子节点
      checkPermTree(permData, rolePerms) {
        let that = this;
        permData.forEach(function (p) {
          if (that.hasPerm(p, rolePerms) && p.status != -1) {
            p.checked = true;
          } else {
            p.checked = false;
          }
          if (p.children && p.children.length > 0) {
            that.checkPermTree(p.children, rolePerms);
          }
        });
      },
      // 判断角色拥有的权限节点勾选
      hasPerm(p, rolePerms) {
        let flag = false;
        for (let i = 0; i < rolePerms.length; i++) {
          if (p.id == rolePerms[i].permissionId) {
            flag = true;
            break;
          }
        }
        if (flag) {
          return true;
        }
        return false;
      },
      // 全选反选
      selectTreeAll() {
        this.selectAllFlag = !this.selectAllFlag;
        let select = this.selectAllFlag;
        this.selectedTreeAll(this.permData, select);
      },
      // 递归全选节点
      selectedTreeAll(permData, select) {
        let that = this;
        permData.forEach(function (e) {
          e.checked = select;
          if (e.children && e.children.length > 0) {
            that.selectedTreeAll(e.children, select);
          }
        });
      },
      submitPermEdit() {
        this.submitPermLoading = true;
        let permIds = "";
        let selectedNodes = this.$refs.tree.getCheckedNodes();
        selectedNodes.forEach(function (e) {
          permIds += e.id + ",";
        });
        permIds = permIds.substring(0, permIds.length - 1);
        editRolePerm({
          roleId: this.editRolePermId,
          permIds: permIds,
        }).then((res) => {
          this.submitPermLoading = false;
          if (res.success) {
            this.$Message.success("操作成功");
            // 标记重新获取菜单数据
            this.$store.commit("setAdded", false);
            util.initRouter(this);
            this.getDataList();
            this.permModalVisible = false;
          }
        });
      },
      cancelPermEdit() {
        this.permModalVisible = false;
      },
      loadData(item, callback) {
        loadDepartment(item.id, { openDataFilter: false }).then((res) => {
          if (res.success) {
            res.result.forEach(function (e) {
              e.selected = false;
              if (e.isParent) {
                e.loading = false;
                e.children = [];
              }
              if (e.status == -1) {
                e.title = "[已禁用] " + e.title;
                e.disabled = true;
              }
            });
            callback(res.result);
          }
        });
      },
      expandCheckDep(v) {
        // 判断展开子节点
        this.checkDepTree(v.children, this.editDepartments);
      },
      // 判断子节点
      checkDepTree(depData, roleDepIds) {
        let that = this;
        depData.forEach(function (p) {
          if (that.hasDepPerm(p, roleDepIds)) {
            p.selected = true;
          } else {
            p.selected = false;
          }
        });
      },
      // 判断角色拥有的权限节点勾选
      hasDepPerm(p, roleDepIds) {
        let flag = false;
        for (let i = 0; i < roleDepIds.length; i++) {
          if (p.id == roleDepIds[i].departmentId) {
            flag = true;
            break;
          }
        }
        if (flag) {
          return true;
        }
        return false;
      },
      submitDepEdit() {
        let depIds = "";
        if (this.dataType == 1) {
          let selectedNodes = this.$refs.depTree.getSelectedNodes();
          selectedNodes.forEach(function (e) {
            depIds += e.id + ",";
          });
          depIds = depIds.substring(0, depIds.length - 1);
        }
        this.submitDepLoading = true;
        editRoleDep({
          roleId: this.editRolePermId,
          dataType: this.dataType,
          depIds: depIds,
        }).then((res) => {
          this.submitDepLoading = false;
          if (res.success) {
            this.$Message.success("操作成功");
            this.getDataList();
            this.depModalVisible = false;
          }
        });
      },
      changeOpen(v) {
        if (v == "0") {
          this.permData.forEach((e) => {
            e.expand = true;
            if (e.children && e.children.length > 0) {
              e.children.forEach((c) => {
                c.expand = true;
                if (c.children && c.children.length > 0) {
                  c.children.forEach(function (b) {
                    b.expand = true;
                  });
                }
              });
            }
          });
        } else if (v == "1") {
          this.permData.forEach((e) => {
            e.expand = false;
            if (e.children && e.children.length > 0) {
              e.children.forEach((c) => {
                c.expand = false;
                if (c.children && c.children.length > 0) {
                  c.children.forEach(function (b) {
                    b.expand = false;
                  });
                }
              });
            }
          });
        } else if (v == "2") {
          this.permData.forEach((e) => {
            e.expand = true;
            if (e.children && e.children.length > 0) {
              e.children.forEach((c) => {
                c.expand = false;
                if (c.children && c.children.length > 0) {
                  c.children.forEach(function (b) {
                    b.expand = false;
                  });
                }
              });
            }
          });
        } else if (v == "3") {
          this.permData.forEach((e) => {
            e.expand = true;
            if (e.children && e.children.length > 0) {
              e.children.forEach((c) => {
                c.expand = true;
                if (c.children && c.children.length > 0) {
                  c.children.forEach(function (b) {
                    b.expand = false;
                  });
                }
              });
            }
          });
        }
      },
    },
    mounted() {
      this.maxHeight = Number(document.documentElement.clientHeight - 121) + "px";
      this.init();
    },
  };
</script>

 src/views/your/carCost-manage/exportColumn.js

New file
@@ -0,0 +1,63 @@
export const exportColumn = [
  {
    title: "车牌号",
    key: "carNo",
    width: 100,
  },
  {
    title: "加油卡号",
    key: "addOilCode",
    width: 120,
    sortable: true,
    align: "center",
  },
  {
    title: "加油日期",
    key: "addDate",
    width: 120,
    sortable: true,
    align: "center",
  },
  {
    title: "加油量(升)",
    key: "amount",
    width: 130,
    sortable: true,
    align: "center",
  },
  {
    title: "含税金额(元)",
    key: "money",
    width: 140,
    sortable: true,
    align: "center",
  },
  {
    title: "过路过桥费(元)",
    key: "",
    width: 150,
    sortable: true,
    align: "center",
  },
  {
    title: "年审费(元)",
    key: "",
    width: 130,
    sortable: true,
    align: "center",
  },
  {
    title: "洗车停车费(元)",
    key: "",
    width: 150,
    sortable: true,
    align: "center",
  },
  {
    title: "保险费含(车船税)",
    key: "",
    width: 170,
    sortable: true,
    align: "center",
  },
]

 src/views/your/carRepairCost-manage/carRepairCostManage.less

New file
@@ -0,0 +1,13 @@
.permModal {
    .ivu-modal-body {
        max-height: 560px;
        overflow: auto;
    }
}

.depModal {
    .ivu-modal-body {
        max-height: 500px;
        overflow: auto;
    }
}

 src/views/your/carRepairCost-manage/carRepairCostManage.vue

New file
@@ -0,0 +1,933 @@
<style lang="less">
  @import "@/styles/table-common.less";
  @import "@/styles/drawer-common.less";
  @import "src/views/your/carCost-manage/carCostManage.less";
</style>
<template>
  <div class="search">
    <Card>
      <Row class="operation">
        <Button @click="init" icon="md-refresh">刷新</Button>
        <Button type="dashed" @click="openTip = !openTip">{{
          openTip ? "关闭提示" : "开启提示"
          }}</Button>
        <Date-picker v-model="value" @on-change="getDataList"
                     value-format="yyyy-MM-dd" type="daterange" placement="bottom-end" placeholder="请选择日期" style="width: 240px;padding-left: 20px">
        </Date-picker>
        <Dropdown @on-click="handleDropdown" style="padding-left: 20px">
          <Button>
            导出数据
            <Icon type="md-arrow-dropdown" />
          </Button>
          <DropdownMenu slot="list">
            <DropdownItem name="exportAll">导出所选日期数据</DropdownItem>
          </DropdownMenu>
        </Dropdown>
      </Row>
      <Alert show-icon v-show="openTip">
        已选择
        <span class="select-count">{{ selectList.length }}</span> 项
        <a class="select-clear" @click="clearSelectAll">清空</a>
      </Alert>
      <Table
              :loading="loading"
              border
              :columns="columns"
              :data="data"
              ref="table"
              sortable="custom"
              @on-sort-change="changeSort"
              @on-selection-change="changeSelect"
      ></Table>
      <Row type="flex" justify="end" class="page">
        <Page
                :current="searchForm.pageNumber"
                :total="total"
                :page-size="searchForm.pageSize"
                @on-change="changePage"
                @on-page-size-change="changePageSize"
                :page-size-opts="[10, 20, 50]"
                size="small"
                show-total
                show-elevator
                show-sizer
                v-show="this.page"
        ></Page>
      </Row>
    </Card>

    <!-- 编辑 -->
    <Modal
            :title="modalTitle"
            v-model="roleModalVisible"
            :mask-closable="false"
            :width="500"
    >
    </Modal>
    <!-- 菜单权限 -->
    <Drawer
            :title="modalTitle"
            v-model="permModalVisible"
            :mask-closable="false"
            :width="500"
            draggable
    >
      <div :style="{ maxHeight: maxHeight }" class="drawer-content">
        <div style="position: relative">
          <Tree
                  ref="tree"
                  :data="permData"
                  show-checkbox
                  :render="renderContent"
                  :check-strictly="true"
          ></Tree>
          <Spin size="large" fix v-if="treeLoading"></Spin>
        </div>
      </div>
      <div class="drawer-footer br">
        <Button
                type="primary"
                :loading="submitPermLoading"
                @click="submitPermEdit"
        >提交</Button
        >
        <Button @click="selectTreeAll">全选/反选</Button>
        <Select
                v-model="openLevel"
                @on-change="changeOpen"
                style="width: 110px"
                transfer
        >
          <Option value="0">展开所有</Option>
          <Option value="1">收合所有</Option>
          <Option value="2">仅展开一级</Option>
          <Option value="3">仅展开两级</Option>
        </Select>
        <Button type="text" @click="cancelPermEdit">取消</Button>
      </div>
    </Drawer>
    <!-- 数据权限 -->
    <Modal
            :title="modalTitle"
            v-model="carModalVisible"
            :mask-closable="false"
            :width="500"
            class="depModal"
    >
      <Form :label-width="85" ref="removeForm" :model="removeForm">
        <FormItem label="移除原因" prop="removeReason">
          <Input v-model="removeForm.removeReason"/>
        </FormItem>
      </Form>
      <div v-show="dataType == 1" style="margin-top: 15px">
        <div style="position: relative">
          <Tree
                  ref="depTree"
                  :data="depData"
                  :load-data="loadData"
                  @on-toggle-expand="expandCheckDep"
                  multiple
                  style="margin-top: 15px"
          ></Tree>
          <Spin size="large" fix v-if="depTreeLoading"></Spin>
        </div>
      </div>
      <div slot="footer">
        <Button type="text" @click="depModalVisible = false">取消</Button>
        <Button
                type="primary"
                :loading="submitDepLoading"
                @click="submitRemove"
        >提交</Button
        >
      </div>
    </Modal>
    <Modal
            v-model="exportModalVisible"
            :title="exportTitle"
            :loading="loadingExport"
            @on-ok="exportCustomData"
    >
      <Form ref="exportForm" :label-width="100">
        <FormItem label="导出文件名">
          <Input v-model="filename" />
        </FormItem>
      </Form>
    </Modal>
  </div>
</template>

<script>
  import {
    getAllPermissionList,
    setDefaultRole,
    editRolePerm,
    initDepartment,
    loadDepartment,
    editRoleDep,
  } from "@/api/index";

  import {
    getAll,
    getAddOilList,
    addOil,
    deleteAddOil,
    getCarList,
    editCar,
    deleteCar,
    getByDate,
    getOilExcel,
    getInfo
  } from "@/api/open";
  import util from "@/libs/util.js";
  import excel from "@/libs/excel.js";
  import XLSX from 'xlsx';
  import {exportColumn} from "./exportColumn";
  export default {
    name: "car-manage",
    data() {
      return {
        maxHeight: 510,
        openTip: true,
        openLevel: "0",
        loading: true,
        treeLoading: true,
        depTreeLoading: true,
        submitPermLoading: false,
        submitDepLoading: false,
        searchKey: "",
        sortColumn: "createTime",
        sortType: "desc",
        modalType: 0,
        roleModalVisible: false,
        page: true,
        carModalVisible: false,
        exportModalVisible: false,
        loadingExport: true,
        permModalVisible: false,
        depModalVisible: false,
        modalTitle: "",
        searchForm: {
          // 搜索框初始化对象
          pageNumber: 1, // 当前页数
          pageSize: 10, // 页面大小
          sort: "createTime", // 默认排序字段
          order: "desc", // 默认排序方式
          key: "",
        },
        addOilForm: {
          status : 0
        },
        removeForm: {
          status : 1
        },
        addOilFormValidate: {
          name: [
            { required: true, message: "角色名称不能为空", trigger: "change" },
          ],
        },
        submitLoading: false,
        selectList: [],
        columns: [
          {
            type: "selection",
            width: 60,
            align: "center",
          },
          {
            type: "index",
            width: 60,
            align: "center",
          },
          {
            title: "车牌号",
            key: "carNo",
            width: 100,
            align: "center",
          },
          {
            title: "开始使用日期",
            key: "buyYear",
            width: 150,
            sortable: true,
            align: "center",
          },
          {
            title: "使用年限",
            key: "usefulLife",
            width: 140,
            sortable: true,
            align: "center",
            render: (h, params) => {
              return h("div",1);
            }
          },
          {
            title: "本期行使里程(KM)",
            key: "mileage",
            width: 180,
            sortable: true,
            align: "center",
          },
          {
            title: "累计行使里程(KM)",
            key: "allMileage",
            width: 180,
            sortable: true,
            align: "center",
          },
          {
            title: '维修费用',
            align: 'center',
            children: [
              {
                title: '本期维修次数',
                key: 'building',
                align: 'center',
                width: 180,
                sortable: true
              },
              {
                title: '本期维修金额(元)',
                key: 'door',
                align: 'center',
                width: 180
              },
              {
                title: '累计维修次数',
                key: 'door',
                align: 'center',
                width: 180
              },
              {
                title: '累计维修金额(元)',
                key: 'door',
                align: 'center',
                width: 180
              }
            ]
          },
          {
            title: '燃油费用',
            align: 'center',
            children: [
              {
                title: '本期加油量(升)',
                key: 'amount',
                align: 'center',
                width: 180,
                sortable: true
              },
              {
                title: '本期加油金额(元)',
                key: 'money',
                align: 'center',
                width: 180
              },
              {
                title: '累计加油量(升)',
                key: 'allAmount',
                align: 'center',
                width: 180
              },
              {
                title: '累计加油金额(元)',
                key: 'allMoney',
                align: 'center',
                width: 180
              }
            ]
          }
        ],
        data: [],
        chooseColumns: [],
        total: 0,
        permData: [],
        exportColumns: exportColumn,
        filename: "车俩维修、燃油费用统计",
        exportTitle: "确认导出",
        editRolePermId: "",
        selectAllFlag: false,
        depData: [],
        dataType: 0,
        editDepartments: [],
        buyYear:'',
        carList:[],
        value:[]
      };
    },
    methods: {
      change1(e){
        this.addDate = e;
      },
      init() {
        this.getDataList();
        // 获取所有菜单权限树
        this.getPermList();
        this.getAllCar();
      },
      renderContent(h, { root, node, data }) {
        let icon = "";
        if (data.level == 0) {
          icon = "ios-navigate";
        } else if (data.level == 1) {
          icon = "md-list-box";
        } else if (data.level == 2) {
          icon = "md-list";
        } else if (data.level == 3) {
          icon = "md-radio-button-on";
        } else {
          icon = "md-radio-button-off";
        }
        return h(
          "span",
          {
            style: {
              display: "inline-block",
              cursor: "pointer",
            },
            on: {
              click: () => {
                if (data.status == -1) {
                  return;
                }
                data.checked = !data.checked;
              },
            },
          },
          [
            h("span", [
              h("Icon", {
                props: {
                  type: icon,
                  size: "16",
                },
                style: {
                  "margin-right": "8px",
                  "margin-bottom": "3px",
                },
              }),
              h("span", data.title),
            ]),
          ]
        );
      },
      handleDropdown(name) {
        if (name == "refresh") {
          this.getDataList();
        } else if (name == "exportData") {
          if (this.selectList.length <= 0) {
            this.$Message.warning("您还未选择要导出的数据");
            return;
          }
          this.exportType = "part";
          this.exportModalVisible = true;
          this.exportTitle =
                  "确认导出数据";
        } else if (name == "exportAll") {
          this.exportType = "all";
          this.exportModalVisible = true;
          this.exportTitle = "确认导出全部数据";
          getInfo(this.searchForm).then((res) => {
            if (res.success) {
              this.exportData = res.result;
            }
          });
        } else if (name == "importData") {
          this.importModalVisible = true;
        }
      },
      //导出数据
      exportCustomData() {
        if (this.filename == "") {
          this.filename = "车辆维修、燃油费用统计";
        }
        // 判断勾选导出列
        let exportColumns = [];
        this.exportColumns.forEach((e) => {
          exportColumns.push(e);
        });
        this.exportModalVisible = false;
        let title = [];
        let key = [];
        exportColumns.forEach((e) => {
          title.push(e.title);
          key.push(e.key);
        });
        console.log(this.exportData)
        const params = {
          title: title,
          key: key,
          data: this.exportData,
          autoWidth: true,
          filename: this.filename,
        };
        this.exportData.forEach((i) => {
          console.log(i);
          i.usefulLife=1;
        });
        excel.export_array_to_excel(params);
      },
      changePage(v) {
        this.searchForm.pageNumber = v;
        this.getDataList();
        this.clearSelectAll();
      },
      changePageSize(v) {
        this.searchForm.pageSize = v;
        this.getDataList();
      },
      changeSort(e) {
        this.searchForm.sort = e.key;
        this.searchForm.order = e.order;
        if (e.order == "normal") {
          this.searchForm.order = "";
        }
        this.getDataList();
      },
      selectDate(dateData) {
        let date = new Date (dateData)
        let y = date . getFullYear()
        let m = date . getMonth() + 1
        m=m<10?('0'+m):m
        let d = date.getDate()
        d = d< 10?('0'+ d):d
        const time = y + '-' + m + '-' + d;
        return time
      },
      getDataList() {
        this.loading = true;
        if (this.value[0]!="" && this.value[1]!=""){
          this.searchForm.beginTime = this.selectDate(this.value[0]);
          this.searchForm.endTime = this.selectDate(this.value[1]);
          this.page=false;
        }else{
          this.searchForm.beginTime = "";
          this.searchForm.endTime = "";
        }
        getInfo(this.searchForm).then((res) => {
          this.loading = false;
          if (res.success) {
            this.data = res.result;
            this.total = res.result.length;
          }
        });
      },
      getPermList() {
        this.treeLoading = true;
        getAllPermissionList().then((res) => {
          if (res.success) {
            this.deleteDisableNode(res.result);
            this.permData = res.result;
            this.treeLoading = false;
          }
          this.treeLoading = false;
        });
      },
      // 递归标记禁用节点
      deleteDisableNode(permData) {
        let that = this;
        permData.forEach(function (e) {
          if (e.status == -1) {
            e.title = "[已禁用] " + e.title;
            e.disabled = true;
          }
          if (e.children && e.children.length > 0) {
            that.deleteDisableNode(e.children);
          }
        });
      },
      carRole() {
        this.roleModalVisible = false;
      },
      submitAddOil() {
        this.addOilForm.addDate = this.addDate;
        this.$refs.addOilForm.validate((valid) => {
          if (valid) {
            if (this.modalType == 0) {
              // 添加
              this.submitLoading = true;
              addOil(this.addOilForm).then((res) => {
                this.submitLoading = false;
                if (res.success) {
                  this.$Message.success("操作成功");
                  this.getDataList();
                  this.roleModalVisible = false;
                }
              });
            } else {
              this.submitLoading = true;
              addOil(this.addOilForm).then((res) => {
                this.submitLoading = false;
                if (res.success) {
                  this.$Message.success("操作成功");
                  this.getDataList();
                  this.roleModalVisible = false;
                }
              });
            }
          }
        });
      },
      submitRemove(){
        this.$refs.removeForm.validate((valid) => {
          if (valid) {
            this.submitLoading = true;
            editCar(this.removeForm).then((res) => {
              this.submitLoading = false;
              if (res.success) {
                this.$Message.success("操作成功");
                this.getDataList();
                this.carModalVisible = false;
              }
            });
          }
        });
      },
      addOil() {
        this.modalType = 0;
        this.modalTitle = "添加加油记录";
        this.$refs.addOilForm.resetFields();
        delete this.addOilForm.id;
        this.roleModalVisible = true;
      },
      edit(v) {
        this.getAllCar();
        this.addDate = v.addDate;
        this.modalType = 1;
        this.modalTitle = "编辑加油信息";
        this.$refs.addOilForm.resetFields();
        // 转换null为""
        for (let attr in v) {
          if (v[attr] == null) {
            v[attr] = "";
          }
        }
        let str = JSON.stringify(v);
        let roleInfo = JSON.parse(str);

        this.addOilForm = roleInfo;
        this.roleModalVisible = true;
      },
      removeCar(v) {
        this.dataType = 0;
        this.modalTitle = "移除车辆";
        this.$refs.addOilForm.resetFields();
        // 转换null为""
        for (let attr in v) {
          if (v[attr] == null) {
            v[attr] = "";
          }
        }
        let str = JSON.stringify(v);
        let roleInfo = JSON.parse(str);
        roleInfo.status=1
        console.log(roleInfo);
        this.removeForm = roleInfo;
        this.carModalVisible = true;

      },
      getAllCar(){
        getAll().then((res) => {
          if(res.success){
            this.carList = res.result;
            console.log(this.carList);
          }
        });
      },
      remove(v) {
        this.$Modal.confirm({
          title: "确认删除",
          content: "您确认要删除吗 ",
          loading: true,
          onOk: () => {
            deleteAddOil({ ids: v.id }).then((res) => {
              this.$Modal.remove();
              if (res.success) {
                this.clearSelectAll();
                this.$Message.success("删除成功");
                this.getDataList();
              }
            });
          },
        });
      },
      setDefault(v) {
        this.loading = true;
        let params = {
          id: v.id,
          isDefault: true,
        };
        setDefaultRole(params).then((res) => {
          this.loading = false;
          if (res.success) {
            this.$Message.success("操作成功");
            this.getDataList();
          }
        });
      },
      cancelDefault(v) {
        this.loading = true;
        let params = {
          id: v.id,
          isDefault: false,
        };
        setDefaultRole(params).then((res) => {
          this.loading = false;
          if (res.success) {
            this.$Message.success("操作成功");
            this.getDataList();
          }
        });
      },
      clearSelectAll() {
        this.$refs.table.selectAll(false);
      },
      changeSelect(e) {
        this.selectList = e;
      },
      delAll() {
        if (this.selectList.length <= 0) {
          this.$Message.warning("您还未选择要删除的数据");
          return;
        }
        this.$Modal.confirm({
          title: "确认删除",
          content: "您确认要删除所选的 " + this.selectList.length + " 条数据?",
          loading: true,
          onOk: () => {
            let ids = "";
            this.selectList.forEach(function (e) {
              ids += e.id + ",";
            });
            ids = ids.substring(0, ids.length - 1);
            deleteCar({ ids: ids }).then((res) => {
              this.$Modal.remove();
              if (res.success) {
                this.$Message.success("删除成功");
                this.clearSelectAll();
                this.getDataList();
              }
            });
          },
        });
      },
      editPerm(v) {
        this.editRolePermId = v.id;
        this.modalTitle = "分配 " + v.name + " 的菜单权限";
        // 匹配勾选
        let rolePerms = v.permissions;
        if (this.treeLoading) {
          this.$Message.warning("菜单权限数据加载中，请稍后点击查看");
          return;
        }
        // 递归判断子节点
        this.checkPermTree(this.permData, rolePerms);
        this.permModalVisible = true;
      },
      // 递归判断子节点
      checkPermTree(permData, rolePerms) {
        let that = this;
        permData.forEach(function (p) {
          if (that.hasPerm(p, rolePerms) && p.status != -1) {
            p.checked = true;
          } else {
            p.checked = false;
          }
          if (p.children && p.children.length > 0) {
            that.checkPermTree(p.children, rolePerms);
          }
        });
      },
      // 判断角色拥有的权限节点勾选
      hasPerm(p, rolePerms) {
        let flag = false;
        for (let i = 0; i < rolePerms.length; i++) {
          if (p.id == rolePerms[i].permissionId) {
            flag = true;
            break;
          }
        }
        if (flag) {
          return true;
        }
        return false;
      },
      // 全选反选
      selectTreeAll() {
        this.selectAllFlag = !this.selectAllFlag;
        let select = this.selectAllFlag;
        this.selectedTreeAll(this.permData, select);
      },
      // 递归全选节点
      selectedTreeAll(permData, select) {
        let that = this;
        permData.forEach(function (e) {
          e.checked = select;
          if (e.children && e.children.length > 0) {
            that.selectedTreeAll(e.children, select);
          }
        });
      },
      submitPermEdit() {
        this.submitPermLoading = true;
        let permIds = "";
        let selectedNodes = this.$refs.tree.getCheckedNodes();
        selectedNodes.forEach(function (e) {
          permIds += e.id + ",";
        });
        permIds = permIds.substring(0, permIds.length - 1);
        editRolePerm({
          roleId: this.editRolePermId,
          permIds: permIds,
        }).then((res) => {
          this.submitPermLoading = false;
          if (res.success) {
            this.$Message.success("操作成功");
            // 标记重新获取菜单数据
            this.$store.commit("setAdded", false);
            util.initRouter(this);
            this.getDataList();
            this.permModalVisible = false;
          }
        });
      },
      cancelPermEdit() {
        this.permModalVisible = false;
      },
      loadData(item, callback) {
        loadDepartment(item.id, { openDataFilter: false }).then((res) => {
          if (res.success) {
            res.result.forEach(function (e) {
              e.selected = false;
              if (e.isParent) {
                e.loading = false;
                e.children = [];
              }
              if (e.status == -1) {
                e.title = "[已禁用] " + e.title;
                e.disabled = true;
              }
            });
            callback(res.result);
          }
        });
      },
      expandCheckDep(v) {
        // 判断展开子节点
        this.checkDepTree(v.children, this.editDepartments);
      },
      // 判断子节点
      checkDepTree(depData, roleDepIds) {
        let that = this;
        depData.forEach(function (p) {
          if (that.hasDepPerm(p, roleDepIds)) {
            p.selected = true;
          } else {
            p.selected = false;
          }
        });
      },
      // 判断角色拥有的权限节点勾选
      hasDepPerm(p, roleDepIds) {
        let flag = false;
        for (let i = 0; i < roleDepIds.length; i++) {
          if (p.id == roleDepIds[i].departmentId) {
            flag = true;
            break;
          }
        }
        if (flag) {
          return true;
        }
        return false;
      },
      submitDepEdit() {
        let depIds = "";
        if (this.dataType == 1) {
          let selectedNodes = this.$refs.depTree.getSelectedNodes();
          selectedNodes.forEach(function (e) {
            depIds += e.id + ",";
          });
          depIds = depIds.substring(0, depIds.length - 1);
        }
        this.submitDepLoading = true;
        editRoleDep({
          roleId: this.editRolePermId,
          dataType: this.dataType,
          depIds: depIds,
        }).then((res) => {
          this.submitDepLoading = false;
          if (res.success) {
            this.$Message.success("操作成功");
            this.getDataList();
            this.depModalVisible = false;
          }
        });
      },
      changeOpen(v) {
        if (v == "0") {
          this.permData.forEach((e) => {
            e.expand = true;
            if (e.children && e.children.length > 0) {
              e.children.forEach((c) => {
                c.expand = true;
                if (c.children && c.children.length > 0) {
                  c.children.forEach(function (b) {
                    b.expand = true;
                  });
                }
              });
            }
          });
        } else if (v == "1") {
          this.permData.forEach((e) => {
            e.expand = false;
            if (e.children && e.children.length > 0) {
              e.children.forEach((c) => {
                c.expand = false;
                if (c.children && c.children.length > 0) {
                  c.children.forEach(function (b) {
                    b.expand = false;
                  });
                }
              });
            }
          });
        } else if (v == "2") {
          this.permData.forEach((e) => {
            e.expand = true;
            if (e.children && e.children.length > 0) {
              e.children.forEach((c) => {
                c.expand = false;
                if (c.children && c.children.length > 0) {
                  c.children.forEach(function (b) {
                    b.expand = false;
                  });
                }
              });
            }
          });
        } else if (v == "3") {
          this.permData.forEach((e) => {
            e.expand = true;
            if (e.children && e.children.length > 0) {
              e.children.forEach((c) => {
                c.expand = true;
                if (c.children && c.children.length > 0) {
                  c.children.forEach(function (b) {
                    b.expand = false;
                  });
                }
              });
            }
          });
        }
      },
    },
    mounted() {
      this.maxHeight = Number(document.documentElement.clientHeight - 121) + "px";
      this.init();
    },
  };
</script>

 src/views/your/carRepairCost-manage/exportColumn.js

New file
@@ -0,0 +1,84 @@
export const exportColumn = [
  {
    title: "车牌号",
    key: "carNo",
    width: 100,
  },
  {
    title: "开始使用日期",
    key: "buyYear",
    width: 150,
    sortable: true,
    align: "center",
  },
  {
    title: "使用年限",
    key: "usefulLife",
    width: 140,
    sortable: true,
    align: "center",
  },
  {
    title: "本期行使里程(KM)",
    key: "mileage",
    width: 180,
    sortable: true,
  },
  {
    title: "累计行使里程(KM)",
    key: "allMileage",
    width: 180,
    sortable: true,
    align: "center",
  },
  {
    title: '本期维修次数',
    key: 'building',
    align: 'center',
    width: 180,
    sortable: true
  },
  {
    title: '本期维修金额(元)',
    key: 'door',
    align: 'center',
    width: 180
  },
  {
    title: '累计维修次数',
    key: 'door',
    align: 'center',
    width: 180
  },
  {
    title: '累计维修金额(元)',
    key: 'door',
    align: 'center',
    width: 180
  },
  {
    title: '本期加油量(升)',
    key: 'amount',
    align: 'center',
    width: 180,
    sortable: true
  },
  {
    title: '本期加油金额(元)',
    key: 'money',
    align: 'center',
    width: 180
  },
  {
    title: '累计加油量(升)',
    key: 'allAmount',
    align: 'center',
    width: 180
  },
  {
    title: '累计加油金额(元)',
    key: 'allMoney',
    align: 'center',
    width: 180
  }
]

 src/views/your/suggest-manage/suggestManage.vue

@@ -66,7 +66,7 @@
      >
        <FormItem label="车辆" prop="carId">
            <Select v-model="addOilForm.carId" filterable>
              <Option v-for="item in carList" :value="item.id">{{ item.carNo }}</Option>
              <Option v-for="item in carList" :value="item.id" :key="item.id">{{ item.carNo }}</Option>
            </Select>
        </FormItem>
        <Form-item label="加油日期" prop="addDate">