1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
| <template>
<div>
<el-form ref="ruleFormRef"
:model="ruleForm"
:rules="rules"
label-width="120px"
class="demo-ruleForm">
<el-form-item prop="email"
label="電子郵件">
<el-input v-model="ruleForm.email" />
</el-form-item>
<el-form-item label="密碼"
prop="password">
<el-input v-model="ruleForm.password"
type="password"
autocomplete="off" />
</el-form-item>
<el-form-item label="確認密碼"
prop="checkPass">
<el-input v-model="ruleForm.checkPass"
type="password"
autocomplete="off" />
</el-form-item>
<!---->
<el-form-item>
<el-button @click="resetForm(ruleFormRef)">
重置
</el-button>
<el-button type="primary"
@click="submitForm(ruleFormRef)">
送出
</el-button>
</el-form-item>
</el-form>
</div>
</template>
<script setup lang="ts">
// @ts-ignore
import { ref, onMounted } from 'vue';
// eslint-disable-next-line @typescript-eslint/no-unused-vars
import type { ElForm } from 'element-plus'
// @ts-ignore
import { ruleFormType } from '../types/forms.ts'
//找不到 ‘element-plus’ 不得使用命名空間 ‘FormInstance’ 作為類型
type FormInstance = InstanceType<typeof ElForm>
const ruleFormRef = ref<FormInstance>()
const ruleForm = ref<ruleFormType>({
email : '',
password : '',
checkPass: '',
verification:''
})
//驗證密碼
const validatePassword = (_rule: any, value: any, callback: any) => {
if (value === '') {
//如果空值時驗證
callback(new Error('請輸入密碼'))
} else {
//如果密碼不等於空
if (ruleForm.value.checkPass !== '') {
if (!ruleFormRef.value) return
ruleForm.value.validateField('checkPass', () => null)
}
callback()
}
}
// 檢查密碼是否兩次相同
const checkPassword= (_rule: any, value: any, callback: any) => {
if (value === '') {
callback(new Error('請再輸入一次密碼'))
} else if (value !== ruleForm.value.password) {
callback(new Error('兩次密碼不相同！'))
} else {
callback()
}
}
//驗證規則
type FormRules = InstanceType<typeof ElForm>
const rules = ref<FormRules>({
email: [
{
required: true,
message : '請輸入電子信箱',
trigger : 'blur',
},
{
type : 'email',
message: '電子信箱格式不符',
trigger: [
'blur',
'change'
],
},
],
password : [{ validator: validatePassword, trigger: 'blur' }],
checkPass: [{ validator: checkPassword, trigger: 'blur' }],
})
const submitForm = async (formEl: FormInstance | undefined) => {
if (!formEl) return
await formEl.validate((valid, fields) => {
if (valid) {
console.log('submit!')
} else {
console.log('驗證', fields)
}
})
}
const resetForm = (formEl: FormInstance | undefined) => {
if (!formEl) return
formEl.resetFields()
}
onMounted(() => {
});
</script>
|
LEFT JOIN 會返回左側資料表中所有資料列，就算沒有符合連接條件，而右側資料表中如果沒有匹配的資料值就會顯示為 NULL。