当前位置:编程学习 > > 正文

vue加element ui开发项目(Vue+ElementUI之Tree的使用方法)

时间:2022-01-26 01:37:40类别:编程学习

vue加element ui开发项目

Vue+ElementUI之Tree的使用方法

Vue+ElementUI之Tree的使用,供大家参考,具体内容如下

vue加element ui开发项目(Vue+ElementUI之Tree的使用方法)

前端代码

  • <template>
        <li>
            <el-dialog title="终端通讯录" :visible.sync="isOpen" class="el-dialog-mini">
                <li class="forms-menu-con">
                    <!-- 
                        check-on-click-node:设置是否在选汉字的时候,复选框也选中
                        props:定义节点和自己提供字段的匹配(例:名称对应数据库查询出来的name属性)
                        data:Tree中的数据,其中字段可以自定义,可以多添加业务字段,再点击的时候调用函数获取该值
                        node-key:唯一,意味着选中节点的时候使用哪个字段作为唯一标识
                        render-content:内容渲染,如果想要在树菜单上添加图标等样式使用这个属性,配置一个渲染函数即可
                        check-change:当复选框状态改变时候,触发次函数,这个主要用来做单选操作,和业务处理使用
                        show-checkbox:显示复选框
                        highlight-current:高亮显示选中节点
                        check-strictly:在显示复选框的情况下,是否严格的遵循父子不互相关联的做法,默认为 false
                     -->
                    <el-tree :data="treeData" :props="treeProps" :check-strictly="true" node-key="id" ref="treeForm" :render-content="renderContent" @check-change="handleClick" show-checkbox highlight-current class="addtree" style="height:275px;">
                    </el-tree>
                    <el-col class="form-search colum-center">
                        <el-button @click="submit">
                            <i class="ump-save" style="font-size:15px;"></i>确 定
                        </el-button>
                        <el-button @click="close">
                            <i class="ump-quxiao3" style="font-size:16px;"></i>关 闭
                        </el-button>
                    </el-col>
                </li>
            </el-dialog>
        </li>
    </template>
    
    <script>
    export default {
        data() {
            return {
                isOpen: false,
                ifonlyTerminal: 1,
                treeData: [],
                treeProps: {
                    label: 'label',
                    children: 'kids',
                    disabled: this.disabledFn
                }
            }
        },
        methods: {
            disabledFn(data, node) {
                return data.nodeType == 0;
            },
            handleClick(data, checked, node) {
                let $this = this;
                if (checked) {
                    console.log(data);
                    /** 该节点作用为永远单选*/
                    //$this.$refs.treeForm.setCheckedNodes([data]);
    
        /** 该节点作用为多选*/
                    $this.$refs.treeForm.setChecked([data]);
                }
            },
            renderContent(h, {
                node,
                data,
                store
            }) {
                return ( 
                    <span class = "custom-tree-node" >
                    <span >
                    <i class = {data.icon} ></i>
                      { data.label } 
                    </span>
                    </span>
                );
            },
            open(selections,ifonlyTerminal) {
                let $this = this;
                $this.treeData=[];
                $this.ifonlyTerminal=ifonlyTerminal;
                $this.$httpclient.get("/reminder/getTerminalContacts", {
                    ifonlyTerminal: $this.ifonlyTerminal
                }, function (res) {
                    if (res.success == true) {
                        $this.treeData = res.data;
                        $this.$refs.treeForm.setCheckedKeys(selections);
                    } else {
                        $this.$message({
                            message: '初始化失败,网络走丢啦...',
                            type: 'error'
                        });
                    }
                });
                this.isOpen = true;
            },
            submit() {
                let selectionNode = this.$refs.treeForm.getCheckedNodes();
                let list=[];
                for(let i=0;i<selectionNode.length;i++){
                    let item=selectionNode[i];
                    list.push({
                        id:item.id,
                        terminalName:item.label,
                        terminalNum:item.terminalNum,
                        serialNum:item.serialNum,
                        terminalType:item.terminalType
                    });
                }
                console.log(list);
                this.$parent.setTerminals(list);
                this.close();
            },
            close() {
                this.isOpen = false;
            }
        }
    }
    </script>
    
  • 引用组件

  • <template>
        <li>
            <el-dialog title="添加预约会议" :visible.sync="addModelOpen" class="el-dialog-large dialogClass">
                <li class="forms-menu mar-10">
                    <li class="forms-menu-tit">
                        <span>
                            <i class="ump-caidan flt-l" style="color:#2681ec;font-size:20px;margin-top:-3px;"></i>
                            基本信息
                        </span>
                    </li>
    
                    <li class="forms-menu-con par-T10">
                        <el-row>
                            <el-form :model="addForm" :rules="rules" ref="addForm" :inline="true" label-position="right">
                                <li class="el-colum-xs12 block">
                                    <li class="form-group el-display">
                                        <el-form-item label="主题" prop="title" style="width:1050px;">
                                            <el-input v-model="addForm.title" placeholder="请输入主题"></el-input>
                                        </el-form-item>
                                    </li>
                                </li>
    
                                <li class="el-colum-xs12">
                                    <li class="form-group el-display">
                                        <el-form-item label="开始时间" prop="startTime" style="margin-top:20px;width:700px;">
                                            <el-date-picker :picker-options="startTimeValid"  @change="newValid" v-model="addForm.startTime" type="datetime" format="yyyy-MM-dd hh:mm" value-format="yyyy-MM-dd hh:mm" placeholder="选择会议开始时间"></el-date-picker>
                                        </el-form-item>
                                    </li>
                                </li>
    
                                <li class="el-colum-xs12" style="margin-top:20px;">
                                    <li class="form-group">
                                        <el-form-item label="会议时长" prop="meetTime">
                                            <el-select v-model="addForm.meetTimeHour" placeholder="请选择" style="width:100px;">
                                                <el-option label="0" value="0"></el-option>
                                                <el-option label="1" value="1"></el-option>
                                                <el-option label="2" value="2"></el-option>
                                                <el-option label="3" value="3"></el-option>
                                                <el-option label="4" value="4"></el-option>
                                                <el-option label="5" value="5"></el-option>
                                                <el-option label="6" value="6"></el-option>
                                            </el-select>
                                            <span style="margin:0px 10px">小时</span>
                                            <el-select v-model="addForm.meetTimeMin" placeholder="请选择" style="width:100px;">
                                                <el-option label="0" value="0"></el-option>
                                                <el-option label="10" value="10"></el-option>
                                                <el-option label="20" value="20"></el-option>
                                                <el-option label="30" value="30"></el-option>
                                                <el-option label="45" value="45"></el-option>
                                                <el-option label="50" value="50"></el-option>
                                            </el-select>
                                            <span style="margin:0px 10px">分钟</span>
                                        </el-form-item>
                                    </li>
                                </li>
    
                                <li class="el-colum-xs12" style="margin-top:20px;">
                                    <li class="form-group">
                                        <el-form-item label="会议详情" prop="meetDetails" style="width:700px;">
                                            <el-input type="textarea" :rows="3" v-model="addForm.meetDetails" placeholder="请输入会议概要信息..."></el-input>
                                        </el-form-item>
                                    </li>
                                </li>
    
                                <li class="el-colum-xs12 block" style="margin-top:20px;">
                                    <li class="form-group el-display">
                                        <el-form-item label="参会人员" prop="noselect" style="width:700px;">
                                            <el-input v-model="terminalNum" placeholder="请输入手机号、终端号、终端序列号点击『确定』按钮添加"></el-input>
                                            <li class="form-search" style="display: inline">
                                                <el-button @click="addTerminal"><i class="el-icon-document-checked" style="font-size:16px;margin-top:6px;"></i>确 定</el-button>
                                                <el-button @click="openContactsModel"><i class="el-icon-plus" style="font-size:16px;margin-top:6px"></i>从通讯录添加/取消</el-button>
                                            </li>
                                            <el-checkbox-group v-model="ifonlyTerminal">
                                                <el-checkbox label="A">仅终端 <span style="color:#44b5ff">(本次选择结果,将只包含终端,不包含用户)</span></el-checkbox>
                                            </el-checkbox-group>
                                        </el-form-item>
                                        <el-form-item label="已选终端/用户" prop="terminals" style="width:700px;">
                                            <el-input type="textarea" class="textarea" v-model="terminalsInfo" readonly="readonly"></el-input>
                                        </el-form-item>
    
                                    </li>
                                </li>
    
                                <!-- <li class="el-colum-xs12 block" style="margin-top:20px;">
                                    <li class="form-group el-display">
                                        <el-form-item label="参会人员" prop="name" style="width:700px;">
                                            <el-input v-model="terminalNum" placeholder="请输入手机号、终端号、终端序列号点击『确定』按钮添加"></el-input>
                                            <li class="form-search" style="display: inline">
                                                <el-button @click="addTerminal"><i class="el-icon-document-checked" style="font-size:16px;margin-top:6px;"></i>确 定</el-button>
                                                <el-button @click="openContactsModel"><i class="el-icon-plus" style="font-size:16px;margin-top:6px"></i>从通讯录添加/取消</el-button>
                                            </li>
                                            <el-checkbox-group v-model="ifonlyTerminal">
                                                <el-checkbox label="A">仅终端 <span style="color:#44b5ff">(本次选择结果,将只包含终端,不包含用户)</span></el-checkbox>
                                            </el-checkbox-group>
                                            <el-input type="textarea" class="textarea" v-model="terminalsInfo"></el-input>
                                        </el-form-item>
                                    </li>
                                </li> -->
    
                                <li class="el-colum-xs12 block" style="margin-top:20px;">
                                    <li class="form-group">
                                        <el-form-item label="会议设置" prop="sex">
                                            <el-checkbox-group v-model="ifAutoRecord">
                                                <el-checkbox label="A"> <span style="color:#44b5ff">会议开始时自动呼叫参会终端</span></el-checkbox><br>
                                            </el-checkbox-group>
                                            <el-checkbox-group v-model="ifAutoCall">
                                                <el-checkbox label="B"> <span style="color:#44b5ff">自动录制</span></el-checkbox>
                                            </el-checkbox-group>
                                        </el-form-item>
                                    </li>
                                </li>
    
                                <li class="el-colum-xs12 block" style="margin-top:20px;">
                                    <li class="form-group">
                                        <el-form-item label="选择云会议室" prop="meetRoomId">
                                            <el-form-item label="" style="width:200px;">
                                                <el-select v-model="addForm.meetRoomId" placeholder="请选择会议室">
                                                    <el-option v-for=" item in meetRooms" :key="item.id" :label="item.roomName" :value="item.id"></el-option>
                                                </el-select>
                                            </el-form-item>
    
                                        </el-form-item>
                                    </li>
                                </li>
                                <li class="el-colum-xs12 block" style="margin-top:20px;">
                                    <li class="form-group">
                                        <el-col class="form-search colum-center">
                                            <el-button @click="submit" :disabled="isDisabled">
                                                <i class="ump-save" style="font-size:15px;"></i>保存
                                            </el-button>
                                            <el-button @click="close">
                                                <i class="ump-quxiao3" style="font-size:16px;"></i>关 闭
                                            </el-button>
                                            <br /><br />
                                        </el-col>
                                    </li>
                                </li>
                            </el-form>
                        </el-row>
                    </li>
                </li>
            </el-dialog>
    
            <contacts ref="contactsModel"></contacts>
    
        </li>
    </template>
    
    <style>
    .dialogClass .el-dialog {
        height: 690px;
        top: 50%;
        margin-top: -369px !important;
    }
    
    .dialogClass .el-dialog .el-dialog__body {
        height: 670px;
    }
    </style>
    
    <script>
    import dateUtil from '@/common/util.js'
    import contacts from "@/components/meet/reminder/contacts";
    
    export default {
        components: {
            contacts
        },
        data() {
            let $this = this;
            let meetTimeTimeValid = function (rule, value, callback) {
                if (($this.addForm.meetTimeHour + $this.addForm.meetTimeMin) == 0) {
                    callback(new Error('请选择会议时长'));
                }
                callback();
            }
    
            let terminalsValid = function (rule, value, callback) {
                if ($this.addForm.terminals.length == 0) {
                    callback(new Error('请选择参会终端/用户'));
                }
                callback();
            }
            return {
                addModelOpen: false,
                terminalNum: "",
                ifonlyTerminal: false,
                terminalsInfo: "",
                ifAutoRecord: false,
                ifAutoCall: false,
                isDisabled: false,
                meetRooms: [],
                addForm: {
                    title: "",
                    meetRoomId: "",
                    startTime: "",
                    roomNum: "",
                    meetTimeHour: "0",
                    meetTimeMin: "20",
                    endTime: "",
                    meetDetails: "",
                    ifAutoRecord: "",
                    ifAutoCall: "",
                    meetPassWord: "",
                    controlPassWord: "",
                    terminals: []
                },
                rules: {
                    title: [{
                        required: true,
                        message: '请输入会议主题',
                        trigger: 'blur'
                    }],
                    meetRoomId: [{
                        required: true,
                        message: '请选择云会议室',
                        trigger: 'blur'
                    }],
                    startTime: [{
                        required: true,
                        message: '请选择开始时间',
                        trigger: 'blur'
                    }],
                    meetDetails: [{
                        required: true,
                        message: '请输入会议详情',
                        trigger: 'blur'
                    }],
                    meetTime: [{
                        validator: meetTimeTimeValid,
                        trigger: 'change'
                    }],
                    terminals: [{
                        validator: terminalsValid,
                        trigger: 'change'
                    }]
                },
                startTimeValid: {
                    disabledDate: (time) => {
                        return time.getTime() <= Date.now();
                    }
                }
            }
        },
        mounted() {
            console.log("欢迎使用应急平台-预约会议...");
        },
        methods: {
            open() {
                let $this = this;
                $this.$httpclient.get("/reminder/getMeetRooms", {}, function (res) {
                    if (res.success == true) {
                        $this.meetRooms = res.data;
                    } else {
                        $this.$message({
                            message: '云会议室没找到,网络走丢啦...',
                            type: 'warning'
                        });
                    }
                });
                this.addModelOpen = true;
            },
            close() {
                this.addModelOpen = false;
            },
            newValid(){
                this.$refs["addForm"].validateField('startTime');
            },
            submit() {
                let $this = this;
                $this.btnStatus = true;
                $this.$refs.addForm.validate((valid) => {
                    if (valid && $this.btnStatus) {
                        $this.addForm.ifAutoRecord = $this.ifAutoRecord ? 1 : 0;
                        $this.addForm.ifAutoCall = $this.ifAutoCall ? 1 : 0;
                        for (let i = 0; i < $this.meetRooms.length; i++) {
                            let item = $this.meetRooms[i];
                            if (item.id == $this.addForm.meetRoomId) {
                                $this.addForm.roomNum = item.roomNum;
                            }
                        }
                        $this.$httpclient.post("/reminder", $this.addForm, function (res) {
                            $this.btnStatus = false;
                            if (res.success == true) {
                                $this.$parent.search();
                                $this.close();
                            } else {
                                $this.$message({
                                    message: '[网络忙],' + res.errorMsg,
                                    type: 'error'
                                });
                            }
                        });
                    } else {
                        $this.btnStatus = false;
                        return false;
                    }
                });
            },
            openContactsModel() {
                let list = [];
                for (let i = 0; i < this.addForm.terminals.length; i++) {
                    let item = this.addForm.terminals[i];
                    list.push(item.id);
                }
                this.$refs.contactsModel.open(list, this.ifonlyTerminal ? 1 : 0);
            },
            /** 
             *  这个函数 组件端会用到,如果想修改函数名称
       *  则将调用组件中  *this.$parent.setTerminals(list);*这行代码修改即可完成替换.
       *  也可以有其他方式,例如父容器给子容器传递函数等等.. 
       *  本人还是喜欢使用这样的方式,毕竟能少些俩行代码,哈哈~~
       */
            setTerminals(terminals) {
                this.addForm.terminals = terminals;
                let terminalsInfo = "";
                for (let i = 0; i < terminals.length; i++) {
                    let terminal = terminals[i];
                    terminalsInfo += "『[" + terminal.terminalName + "]-[" + terminal.terminalNum + "]』";
                }
                this.terminalsInfo = terminalsInfo;
            },
            addTerminal() {
                let $this = this;
                let terminals = $this.addForm.terminals;
    
                let flag = true;
                for (let i = 0; i < terminals.length; i++) {
                    let item = terminals[i];
                    if (item.terminalNum == $this.terminalNum || item.serialNum == $this.terminalNum) {
                        flag = false;
                        $this.terminalNum = "";
                        $this.$message({
                            message: '当前终端已选择,不用再次添加..',
                            type: 'warning'
                        });
                        break;
                    }
                }
    
                if (flag) {
                    $this.$httpclient.get('/terminal/getTerminal', {
                        terminalNum: $this.terminalNum
                    }, function (res) {
                        if (res.success == true) {
                            let terminal = res.data;
                            terminals.push(terminal);
                            $this.terminalsInfo += "『[" + terminal.terminalName + "]-[" + terminal.terminalNum + "]』";
                            $this.terminalNum = "";
                        } else {
                            $this.$message({
                                message: '当前终端未找到,请认真查看你是否输入正确..',
                                type: 'warning'
                            });
                        }
                    });
                }
    
            }
        }
    }
    </script>
    
  • 返回Json数据格式

  • {
     "success": true,
     "errorCode": null,
     "errorMsg": null,
     "data": [{
      "label": "\u6E56\u5317\u7701\u8003\u8BD5\u9662",
      "id": "17",
      "parentId": "17",
      "nodeType": 0,
      "icon": null,
      "kids": [{
       "label": "\u9662\u529E\u516C\u5BA4",
       "id": "23",
       "parentId": "17",
       "nodeType": 0,
       "icon": null,
       "kids": [{
        "label": "\u9662\u529E\u516C\u5BA4\u4E00\u5904",
        "id": "24",
        "parentId": "23",
        "nodeType": 0,
        "icon": null,
        "kids": null
       }, {
        "label": "\u9662\u529E\u516C\u5BA4\u4E8C\u5904",
        "id": "25",
        "parentId": "23",
        "nodeType": 0,
        "icon": null,
        "kids": null
       }]
      }]
     }, {
      "label": "\u6E56\u5317\u77012020\u5E74\u9AD8\u8003\u5E94\u6025\u673A\u6784",
      "id": "18",
      "parentId": "18",
      "nodeType": 0,
      "icon": null,
      "kids": [{
       "label": "\u4E2D\u5FC3\u94F6\u884C",
       "id": "A06E0C6FFB29198EE053437CA8C07A48",
       "parentId": "18",
       "nodeType": 1,
       "icon": "el-icon-monitor",
       "kids": null,
       "terminalType": 0,
       "terminalNum": "769025",
       "serialNum": "7D1846124E640764"
      }, {
       "label": "\u6B66\u6C49\u5E02\u4E00\u4E2D\u8003\u70B9\u5E94\u6025\u529E",
       "id": "20",
       "parentId": "18",
       "nodeType": 0,
       "icon": null,
       "kids": [{
        "label": "\u6B66\u6C49\u4E00\u4E2D\u5E94\u6025\u6307\u6325\u4E2D\u5FC3",
        "id": "22",
        "parentId": "20",
        "nodeType": 0,
        "icon": null,
        "kids": null
       }]
      }, {
       "label": "\u6B66\u6C49\u4E8C\u4E2D\u8003\u70B9\u5E94\u6025\u529E",
       "id": "21",
       "parentId": "18",
       "nodeType": 0,
       "icon": null,
       "kids": null
      }]
     }, {
      "label": "2020\u5E74\u7814\u7A76\u751F\u8003\u8BD5\u5E94\u6025\u673A\u6784",
      "id": "19",
      "parentId": "19",
      "nodeType": 0,
      "icon": null,
      "kids": [{
       "label": "\u738B\u7269\u6D41",
       "id": "A0BA62D5108D1565E053437CA8C0C74B",
       "parentId": "19",
       "nodeType": 1,
       "icon": "el-icon-user",
       "kids": null,
       "terminalType": 1,
       "terminalNum": "15010330199",
       "serialNum": "15010330199"
      }, {
       "label": "\u6B66\u6C49\u8003\u533A",
       "id": "27",
       "parentId": "19",
       "nodeType": 0,
       "icon": null,
       "kids": [{
        "label": "\u6B66\u6C49\u4E00\u533A\u5E94\u6025\u529E",
        "id": "28",
        "parentId": "27",
        "nodeType": 0,
        "icon": null,
        "kids": null
       }, {
        "label": "\u6B66\u6C49\u4E8C\u533A\u5E94\u6025\u529E",
        "id": "41",
        "parentId": "27",
        "nodeType": 0,
        "icon": null,
        "kids": null
       }]
      }]
     }, {
      "label": "\u6E56\u5317\u77012019\u5E74\u9AD8\u8003\u5E94\u6025",
      "id": "26",
      "parentId": "26",
      "nodeType": 0,
      "icon": null,
      "kids": null
     }]
    }
    
  • 后台代码

  • package com.itechhero.app.module.edu.meet.reminder.service;
    
    import com.github.pagehelper.PageHelper;
    import com.itechhero.app.module.edu.common.model.TreeBean;
    import com.itechhero.app.module.edu.meet.reminder.mapper.MeetReminderMapper;
    import com.itechhero.app.module.edu.meet.reminder.mapper.ReminderTerminalLinkMapper;
    import com.itechhero.app.module.edu.meet.reminder.model.MeetReminder;
    import com.itechhero.app.module.edu.meet.reminder.model.ReminderTerminalLink;
    import com.itechhero.app.module.edu.meet.reminder.model.TerminalTreeBean;
    import com.itechhero.app.module.edu.terminal.mapper.TerminalMapper;
    import com.itechhero.app.module.edu.terminal.model.Terminal;
    import com.itechhero.app.module.edu.utils.exceptions.ReqException;
    import com.itechhero.app.module.edu.utils.req.CMap;
    import com.itechhero.app.module.edu.utils.req.PageData;
    import com.itechhero.app.module.edu.utils.req.ResBean;
    import com.itechhero.app.module.edu.xylink.api.reminder.ReminderApi;
    import com.itechhero.app.module.edu.xylink.util.Result;
    import lombok.extern.slf4j.Slf4j;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.springframework.transaction.annotation.Transactional;
    
    import java.util.ArrayList;
    import java.util.List;
    import java.util.Map;
    
    
    /**
     * 预约会议业务类
     * 作者: 吴 波
     * 时间: 2020-03-09 17:28
     * 笔名: 那年秋天的茄子^^
     */
    @Slf4j
    @Service
    @Transactional
    public class MeetReminderService {
    
    
        @Autowired
        private MeetReminderMapper meetReminderMapper;
    
        @Autowired
        private TerminalMapper terminalMapper;
    
        @Autowired
        private ReminderTerminalLinkMapper reminderTerminalLinkmapper;
    
        /**
         * 获取通讯终端树
         * 作者: 吴 波
         * 时间: 2020-03-14 10:32
         * 笔名: 那年秋天的茄子^^
         */
        public ResBean getContacts(Integer ifonlyTerminal) {
            List<TreeBean> root = this.meetReminderMapper.getRootContacts();
            getKidContacts(root, ifonlyTerminal);
            return ResBean.success(root);
        }
    
        /**
         * 获取终端通讯录子节点
         * 作者: 吴 波
         * 时间: 2020-03-14 11:07
         * 笔名: 那年秋天的茄子^^
         */
        private void getKidContacts(List<TreeBean> root, Integer ifonlyTerminal) {
            log.info("\n{}", root);
            for (TreeBean treeBean : root) {
                List<TreeBean> kidsContacts = new ArrayList<>();
    
                /*终端*/
                List<TerminalTreeBean> terminalContacts = this.terminalMapper.getTerminalKidsForTree(treeBean.getId(), ifonlyTerminal);
                if (terminalContacts != null && terminalContacts.size() != 0) {
                    kidsContacts.addAll(terminalContacts);
                }
    
                /*部门*/
                List<TreeBean> orgKidsContacts = this.meetReminderMapper.getKidsContacts(treeBean.getId());
                if (orgKidsContacts != null && orgKidsContacts.size() != 0) {
                    kidsContacts.addAll(orgKidsContacts);
                }
    
                if (kidsContacts.size() != 0) {
                    treeBean.setKids(kidsContacts);
                }
    
                getKidContacts(kidsContacts, ifonlyTerminal);
            }
    
    
        }
    
        /**
         * 获取已选中的终端
         * 作者: 吴 波
         * 时间: 2020-03-14 21:36
         * 笔名: 那年秋天的茄子^^
         */
        public ResBean getTerminals(CMap param) {
            List<CMap> list=this.reminderTerminalLinkmapper.getTerminals(param);
            log.info("\n[获取到预约会议呼叫的终端设备]\n{}",list);
            return ResBean.success(list);
        }
    }
    
  • Mapper.xml

  • <!-- 获取通讯录 -->
        <select id="getRootContacts" resultType="com.itechhero.app.module.edu.common.model.TreeBean">
            select
                   ID||'' AS "id",
                   YJJGMC AS "label",
                   FBMID||'' as "parentId",
                   0 as "nodeType" -- 为了前端判断是否能选中用的
            FROM YJ_ZB_ZBJG
            WHERE 1=1 AND ID=FBMID
        </select>
    
        <!-- 获取通讯录子节点 -->
        <select id="getKidsContacts" resultType="com.itechhero.app.module.edu.common.model.TreeBean">
            select
                ID||'' AS "id",
                YJJGMC AS "label",
                FBMID||'' as "parentId",
                0 as "nodeType"
            FROM YJ_ZB_ZBJG
            WHERE 1=1
              AND ID||'' != #{parentId}
              AND FBMID||'' = #{parentId}
        </select>
    
        <!-- 获取终端通讯录TREE -->
        <select id="getTerminalKidsForTree" resultType="com.itechhero.app.module.edu.meet.reminder.model.TerminalTreeBean">
            SELECT
                   ID as "id",
                   TERMINAL_NAME as "label",
                   TERMINAL_TYPE,
                   TERMINAL_NUM,
                   SERIAL_NUM,
                   ORG_ID||'' as "parentId",
                   1 as "nodeType",
                   case TERMINAL_TYPE              -- 为前端设定图标使用(为了方便直接写数据库,介意前端判断)
                       when 0 then 'el-icon-monitor'
                       else 'el-icon-user' end as  "icon"
            FROM YJ_TERMINAL
            where 1=1
            and ORG_ID||'' =#{parentId}
            <if test="ifonlyTerminal==1">
                and TERMINAL_TYPE = 0
            </if>
    
    </select>
    
  • 以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持开心学习网。

    标签:
    上一篇下一篇

    猜您喜欢

    热门推荐