前后端项目-part03

5.4.4 机构名称

5.4.4.1 创建实体类Company

package com.zx.system.entity;

import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.ToString;
import lombok.experimental.Accessors;

import java.util.Date;

@Data
@NoArgsConstructor
@AllArgsConstructor
@ToString
@Accessors(chain = true)
@TableName("tb_company")
public class Company {
   
    private Integer id;
    private String name;//名称
    private String orgType;//c机构 p个人
    private String phone;//联系方式
    private String linkname;//联系人名称
    private String handPhotos;//手持证件照
    private String address;//机构地址
    private String logo;//机构logo
    private String email;//邮箱
    private String promiseLetter;//承诺书
    private String trademarkPic;//商标注册证
    private String intro;//简介
    private String briefIntro;
    private String mainCategory;//主营类目
    private String identityPic;//身份证照片
    private String workType;//工具性质
    private String businessPic;//营业执照
    private Date businessTerm;//营业执照有效期
    private String businessRegistNo;//营业执照注册号
    private String eduCertImg;//教育资质/学历证书照片
    private String eduCertTerm;//教育资质证书有效期
    private String eduCertNo;//教育资质/学历编号
    private String approvalStatus;//审核状态
    private String approvalComment;//审批意见
    private String approvalPeople;//审批人
    private Date approvalDate;//审批日期
    private Integer approvalNums;//审核次数
    private String remark;//备注
    private Date createDate;
    private Date changeDate;
    private Integer tenantId;//租户ID
    private String idCard;//身份证号
    private String teacherCertImg;//教师资格证照片
    private String teacherCertNo;//教师资格证号码
    private Integer status;//状态
    private String majorCertImg;//专业证件照片
    private String majorCertNo;//专业证件号码
    private String workExperience;//教学工作经历
    private String workResults;//教学工作成果
    private String title;//机构名称
}

5.4.4.2 创建实体类CompanyMapper

package com.zx.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zx.system.entity.Company;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface CompanyMapper extends BaseMapper<Company> {
   
}

5.4.4.3 创建实体类CompanyService

package com.zx.system.service;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.zx.system.entity.Company;
import com.zx.system.mapper.CompanyMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class CompanyService extends ServiceImpl<CompanyMapper, Company> {
   
    @Autowired
    private CompanyMapper companyMapper;

    public List<Company> selectAll(){
   
        QueryWrapper qw = new QueryWrapper();
        qw.select("id","name","org_type","phone","linkname");//查询指定列
        qw.eq("status",1);//1正常0停用
        qw.orderByDesc("create_date");//倒序
        return companyMapper.selectList(qw);
    }

}

5.4.4.4 创建实体类CompanyController

package com.zx.system.controller;

import com.zx.system.entity.Company;
import com.zx.system.service.CompanyService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.CrossOrigin;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
@CrossOrigin
@RequestMapping("/system/company")
public class CompanyController {
   
    @Autowired
    private CompanyService companyService;

    @GetMapping("/selectAll")
    public List<Company> selectAll(){
   
        return companyService.selectAll();
    }
}

5.4.4.5 后端测试

5.4.4.6 修改basic.js

// 课程管理CRUD
import axios from '../axios.js'

//获取分类信息
const zx_basic = 'http://localhost:9999/basic'

//去后台,获取所有分类的三级树
export const AllCategory = async ()=>{
   
	const res = await axios.get(zx_basic+"/category/getTree")
	return res
}

//去后台,获取一级分类
export const Level1Category = async ()=>{
   
	const res = await axios.get(zx_basic+"/category/level1Category")
	return res
}

//根据字典编号,获取字典信息
export const GetDict = async (code)=>{
   
	const res = await axios.get(zx_basic+"/dictionary/getDicItems/"+code)
	return res
}

//去后台//获取所有机构信息
const zx_system = 'http://localhost:8888/system'
export const GetCompany = async ()=>{
   
	const res = await axios.get(zx_system+"/company/selectAll")
	return res
}

5.4.4.7 修改course.vue

<template>
	<el-card shadow="always">
		<h3><el-icon><ElementPlus /></el-icon>课程管理</h3>
	
		<el-row style="padding:10px;" gutter="3">
			<el-col span="8">
				<el-button type="primary" size="small" @click="toAdd">
					<el-icon><CirclePlus /></el-icon>&nbsp;新增
				</el-button>
				<el-button v-if="multipleSelection.length" type="danger" size="small" @click="handlerMuchDel">删除多条</el-button>
			</el-col>
			<el-col span="16">
				<el-input size="small" v-model="searchName" placeholder="按课程名称搜索">
					<template #append><el-icon><Search/></el-icon></template>
				</el-input>
			</el-col>
		</el-row>
		
		<el-table :data="filterData" @selection-change="handleSelectionChange" border>
			<el-table-column prop="id" type="selection" width="55"></el-table-column>
			<el-table-column prop="planNum" label="计划数量" heder-align="center"></el-table-column>
			<el-table-column prop="companyName" label="公司名称" heder-align="center" ></el-table-column>
			<el-table-column prop="name" label="课程名称" heder-align="center"></el-table-column>
			<el-table-column prop="tags" label="课程标签" heder-align="center" ></el-table-column>
			<el-table-column prop="mtName" label="大分类名称" heder-align="center" ></el-table-column>
			<el-table-column prop="stName" label="小分类名称" heder-align="center" ></el-table-column>
			<el-table-column prop="grade" label="课程等级" heder-align="center" ></el-table-column>
			<el-table-column prop="teachmode" label="教学模式" heder-align="center" ></el-table-column>
			<el-table-column prop