# bysAdmin

**Repository Path**: milan22/bys-admin

## Basic Information

- **Project Name**: bysAdmin
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-02-21
- **Last Updated**: 2025-02-21

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 记录一些问题

#### 依次导入三个专业 excel 后 存在重复行 专科中存在重复项

```sql
# 查看所有重复项
select del_flag,update_by,update_time,is_parent,version,grad_level_dict,parent_code,prof_code,title,sort_order,parent_title,level,due_time from gq_professional_code group by del_flag,update_by,update_time,is_parent,version,grad_level_dict,parent_code,prof_code,title,sort_order,parent_title,level,due_time having count(*) > 1;

# 删除上面查出来的重复数据
delete from gq_professional_code where id in (select id from (select id from gq_professional_code group by del_flag,update_by,update_time,is_parent,version,grad_level_dict,parent_code,prof_code,title,sort_order,parent_title,level,due_time having count(*) > 1) as a);
```

#### 前端 困难帮扶台账中 根据就业状态拿到就业类别的时候 暂时是写死了时间 2023

```js
// addHelper.vue
// const version = new Date().getFullYear(); // 这里的version要传递年份
// TODO 这里是一个坑 必须写死2023
// 从cookie中拿到tableName
// let version = Cookies.get('tableName');
// if(!version){
//     version = 2023;
// }
// if(typeof version === 'string'){
//     version = parseInt(version);
// }
const version = 2023;
let res = await getEmploymentCategory({
    version,
    dictMatch: this.addHelpResultsForm.employmentStatus
});
```