export interface ruleFormType {
    email: string,
    password: string,
    checkPass?: string,
    verification?: string,
}

import { ref, onMounted,watchEffect } from 'vue'
import { ruleFormType } from '../types/forms.ts'
import type { ElForm } from 'element-plus'
    //找不到 ‘element-plus’ 不得使用命名空間 ‘FormInstance’ 作為類型
    type FormInstance = InstanceType<typeof ElForm>
    const ruleFormRef = ref<FormInstance>()
    //定義表單
    const ruleForm = ref<ruleFormType>({
        email    : '',
        password : '',
        checkPass: '',
        verification:''
    })
    //驗證規則
    const rules = ref<FormRules<ruleFormType>>({
        email: [
            {
                required: true,
                message : '請輸入電子信箱',
                trigger : 'blur',
            },
            {
                type   : 'email',
                message: '電子信箱格式不符',
                trigger: [
                    'blur',
                    'change'
                ],
            },
        ],
        password : [{ validator: validatePassword, trigger: 'blur' }],
        checkPass: [{ validator: checkPassword, trigger: 'blur' }],
    })

<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>

SELECT table_column1, table_column2...
FROM table_name1
CROSS JOIN table_name2;
//or
SELECT table_column1, table_column2...
FROM table_name1, table_name2;
//or
SELECT table_column1, table_column2...
FROM table_name1
JOIN table_name2;

SELECT customers.Name, orders.Order_No
FROM customers
CROSS JOIN orders;

DELETE FROM table_name WHERE some_column=some_value;

DELETE FROM `customers` WHERE C_Id=4;

SELECT table_column1, table_column2...
FROM table_name1
FULL JOIN table_name2 
ON table_name1.column_name=table_name2.column_name;

SELECT customers.C_Id,customers.Name,customers.Address,customers.Phone,customers.Salary,orders.Order_No,orders.Product,orders.Product,orders.Quantity
FROM `customers`
RIGHT JOIN `orders`
ON customers.C_Id =orders.C_Id

CREATE INDEX index_name ON table_name (column_name);

CREATE INDEX index_name ON table_name (column_name1, column_name2...);

ALTER TABLE table_name DROP INDEX index_name;

SELECT table_column1, table_column2...
FROM table_name1
INNER JOIN table_name2 
ON table_name1.column_name=table_name2.column_name;
//or
SELECT table_column1, table_column2...
FROM table_name1
INNER JOIN table_name2 
USING (column_name);

SELECT customers.C_Id,customers.Name,customers.Address,customers.Phone,customers.Salary,orders.Order_No,orders.Product,orders.Product,orders.Quantity
FROM `customers`
INNER JOIN `orders`
ON customers.C_Id =orders.C_Id

SELECT table_column1, table_column2...
FROM table_name1
NATURAL JOIN table_name2;

SELECT customers.C_Id,customers.Name,customers.Address,customers.Phone,customers.Salary,orders.Order_No,orders.Product,orders.Product,orders.Quantity FROM `customers` NATURAL JOIN `orders`;

INSERT INTO table_name (column1, column2, column3...)
VALUES (value1, value2, value3...);
//or
INSERT INTO table_name
VALUES (value1, value2, value3...);

INSERT INTO customers (C_Id, Name, City, Address, Phone)
VALUES (3, '李三', '高雄縣', 'ZZ路300號', '07-12345678');
or
INSERT INTO customers
VALUES (3, '李三', '高雄縣', 'ZZ路300號', '07-12345678');

SELECT column_name(s) FROM table_name1
INTERSECT
SELECT column_name(s) FROM table_name2;

SELECT P_Name FROM `products_taiwan`
INTERSECT
SELECT P_Name FROM `products_china`;

SELECT table_column1, table_column2...
FROM table_name1
LEFT JOIN table_name2 
ON table_name1.column_name=table_name2.column_name;

SELECT customers.C_Id,customers.Name,customers.Address,customers.Phone,customers.Salary,orders.Order_No,orders.Product,orders.Product,orders.Quantity
FROM `customers`
LEFT JOIN `orders`
ON customers.C_Id =orders.C_Id

SELECT table_column1, table_column2, table_column3...
FROM table_name
WHERE column_name LIKE pattern;

SELECT * FROM `customers` WHERE City LIKE '台北%';

SELECT * FROM `customers` WHERE City NOT LIKE '台北%';