let arr1 = [
    { id: "abdc1234", date: "2023-10-17" },
    { id: "abdc1235", date: "2023-10-18" }
];

let arr2 = [
    { id: "abdc1234", name: "lara" },
    { id: "abdc1235", name: "sara" }
];

let arr3 = arr1.map((item, i) => Object.assign({}, item, arr2[i]));
console.log(arr3);


[
{
  "id": "abdc1234",
  "date": "2023-10-17",
  "name": "lara"
}, 
{
  "id": "abdc1235",
  "date": "2023-10-18",
  "name": "sara"
}]

let arr1 = [
    { id: "abdc1234", date: "2023-10-17" },
    { id: "abdc1235", date: "2023-10-18" }
];

let arr2 = [
    { id: "abdc1234", name: "lara" },
    { id: "abdc1235", name: "sara" }
];

let merged = [];

for(let i=0; i<arr1.length; i++) {
  merged.push({
   ...arr1[i], 
   ...(arr2.find((itmInner) => itmInner.id === arr1[i].id))}
  );
}


console.log(merged);

[
{
  "id": "abdc1234",
  "date": "2023-10-17",
  "name": "lara"
},
{
  "id": "abdc1235",
  "date": "2023-10-18",
  "name": "sara"
}]

let arr1 = [
    { id: "abdc1234", date: "2023-10-17" },
    { id: "abdc1235", date: "2023-10-18" }
];

let arr2 = [
    { id: "abdc1234", name: "lara" },
    { id: "abdc1235", name: "sara" }
];
let merged = [];

for(let i=0; i<arr1.length; i++) {
  merged.push({
   ...arr1[i], 
   ...arr2[i]
  });
}

console.log(merged)
[
{
  "id": "abdc1234",
  "date": "2023-10-17",
  "name": "lara"
},
{
  "id": "abdc1235",
  "date": "2023-10-18",
  "name": "sara"
}]

const mongoose = require('mongoose')
const bcrypt = require('bcryptjs')
const moment = require('moment')
moment().format();
const timezone = -(new Date().getTimezoneOffset() / 60) + 8;
const time = moment(Date.now() + (timezone * 60 * 60 * 1000)).format('YYYY-MM-DDT HH:mm').toString();
//console.log('timezone', timezone)

const userSchema = mongoose.Schema(
    {
        username: {
            type: String,
            required: [true, "請輸入使用者2~30字符"],
            trim: true,
            match: [
                /^.{2,30}$/,
                'Please add a valid name 2~30字符',
            ],  
        },
        email: {
            type: String,
            required: true,
             match: [
                /^\w+([\.-]?\w+)*@\w+([\.-]?\w+)*(\.\w{2,3})+$/,
                'Please add a valid email',
            ],
        },
        password: {
            type: String,
            required: [true],
            trim: true,
        },
        created:
        {
            type: String,
            default: time
        }, 
        token: {
            type: String,
        }    
    },
    
)
//findByEmail 函式
userSchema.statics.findByEmail =async (email) =>{
    //查找User 是否有該email
    const user = await User.findOne({ email }) 
    //如果有
    if (user) { throw new Error('已經有該用戶！') }
     return user
}

const User = mongoose.model('User', userSchema);

module.exports = User;

//verifyToken
const verifyToken = (req, res, next) =>
{
   const bearerHeader = req.headers.authorization;
    if (typeof bearerHeader !== 'undefined') {
        const bearer = bearerHeader.split(' '); 
        const bearerToken = bearer[1]; 
        req.token = bearerToken; 
        next(); 
    }
    else {
        req.send({result:'令牌無效!'})
    }
}
module.exports = verifyToken;

const express = require('express')
const verifyToken = require('../middleware/token')
const User = require('../models/userModel')
const jwt = require('jsonwebtoken')
const bcrypt = require('bcryptjs')
const router = express.Router()

//註冊
router.post('/register', async(req, res) =>
{ 
    try {
        /* 	
        #swagger.summary='註冊',
        #swagger.description = '' */
        /*	#swagger.parameters['body'] = {
            in: 'body',
            description: '',
            required: true,
            schema: { $ref: "#/definitions/AddUser" }
    } */

    /* #swagger.security = [{
            "apiKeyAuth": []
    }] */
        const data = new User(req.body); 
        //註冊時,Email使用 findByEmail 函式驗證
        const email = await User.findByEmail(req.body.email)
        data.password = bcrypt.hashSync(req.body.password, 12);
       
        const token = jwt.sign({  _id: data._id ,username: data.username,email: data.email}, 'RESTFULAPI',{expiresIn: "24h"}).toString();
        let userArr = {
            username: data.username,
            email: data.email,
            password: data.password,
            created: data.created,
            token:token
        }
   
    const user = await User.create(userArr);     
    res.status(200).json(user); 
    }
    catch (error) {
        res.status(500).json({message: error.message})
    }
})


//登入
router.post('/login',async (req, res) =>{ 
    const { email, password } = req.body;
    try {
         /* 
    #swagger.summary='登入',
    #swagger.description = '' */

    /*	#swagger.parameters['body'] = {
            in: 'body',
            description: '',
            required: true,
            schema: { $ref: "#/definitions/Login" }
    } */

    /* #swagger.security = [{
            "apiKeyAuth": []
    }] */
      let user = await User.findOne({email});
      if (!user)
        return res.status(400).json({message: "用戶不存在"});

      const isMatch = await bcrypt.compare(password, user.password);
      if (!isMatch)
        return res.status(400).json({message: "密碼錯誤 ！"});

      const payload = {
        user: {id: user.id}
      };

      jwt.sign(payload,user.email,{expiresIn: 3600},(err, token) => {
          if (err) throw err;
          res.status(200).json({token});
        }
      );
    }
    catch (e) {
        console.error(e);
        res.status(500).json({
            message: "伺服器錯誤!"
        });
    }
})


//users驗證
router.delete('/users/:id', verifyToken,async(req, res) =>{
    try {
        /* 	
        #swagger.tags = ['以下請先登入'],
        #swagger.summary='刪除使用者',
        #swagger.description = '' */
        const {id} = req.params;
        const user = await User.findByIdAndDelete(id);
        if(!user){
            return res.status(404).json({message: `沒有發現任何使用者  ${id}`})
        }
        res.status(200).json(user );
        
    } catch (error) {
        res.status(500).json({message: error.message})
    }
})


router.post("/welcome", verifyToken, (req, res) =>
{
     /* 	
     #swagger.tags = ['以下請先登入'],
        #swagger.summary='歡迎畫面',
        #swagger.description = '' */
    console.log('req.body', req.body)
    res.status(200).send("Welcome 🙌 ");
});

module.exports = router;

nvm use 16.14.0
npm install cookie-session --save

var cookieSession = require('cookie-session')
var express = require('express')

var app = express()

app.use(cookieSession({
  name: 'session',
  keys: [/* secret keys */],

  // Cookie Options
  maxAge: 24 * 60 * 60 * 1000 // 24 hours
}))

npm install bcryptjs --save

const bcrypt = require('bcrypt');
const saltRounds = 10;
const myPlaintextPassword = 's0/\/\P4$$w0rD';
const someOtherPlaintextPassword = 'not_bacon';

bcrypt.genSalt(saltRounds, function(err, salt) {
    bcrypt.hash(myPlaintextPassword, salt, function(err, hash) {
        // Store hash in your password DB.
    });
});

bcrypt.hash(myPlaintextPassword, saltRounds, function(err, hash) {
    // Store hash in your password DB.
});

// Load hash from your password DB.
bcrypt.compare(myPlaintextPassword, hash, function(err, result) {
    // result == true
});
bcrypt.compare(someOtherPlaintextPassword, hash, function(err, result) {
    // result == false
});

npm install @fortawesome/fontawesome-free  --save

npm install vue-i18n@next --save

//en-US.json
{
    "nav_menu":{
        "home":"Home",
        "login":"Login"
    }
}
//zh-TW.json
{
    "nav_menu":{
        "home":"首頁",
        "login":"登入"
    }
}

import { createI18n } from 'vue-i18n'
import zh from '../lang/zh-TW.json'
import en from '../lang/en-US.json'

type MessageSchema = typeof zh

const i18n = createI18n<[MessageSchema], 'zh-TW' | 'en-US'>({
  legacy: false, // 要把 legacy 設為 false，才可以使用 Composition API
  locale: 'zh-TW',
  fallbackLocale: 'zh-TW',
  globalInjection: true,
  messages: {
    'zh-TW': zh,
    'en-US': en
  }
})

export default i18n

//引入plugins/i18n
import i18n from './plugins/i18n' 

const app = createApp(App)
//使用use i18n
app.use(i18n) 
app.mount('#app')

<template>
<div>
    <div>切換語言：</div> 
      <select @change="changeLang">
        <option value="zh-TW">中文</option>
        <option value="en-US">English</option>
      </select>
    </div>
    <p>
      {{ $t('nav_menu.home') }} 
    </p>
</div>
</template>

<script setup lang="ts">
    //載入vue-i18n
    import { useI18n } from 'vue-i18n'
    const { locale } = useI18n()
    //改變語系切換
    const changeLang = (e) => {
        locale.value = e.target.value
    }
</script>

import { defineStore } from 'pinia';
import { ref, computed } from 'vue';
import { useI18n } from "vue-i18n";
import { homeMenuType } from "../types/all";

export interface homeMenuType{
    name?: string |null |any,
    id?: string |null |any,
   link: string | null | any,
}

//useNavbarStore 
export const useNavbarStore = defineStore('navbar', () => {
    const { locale } = useI18n();
    const i18n = useI18n();

    const i18nPlatform = computed(() => i18n.t("nav_menu.home"))
    const i18nCompany = computed(() => i18n.t("nav_menu.login"))

    const homeMenu=ref<homeMenuType[]>([
        { name: i18nPlatform, id: '001', link: '/index' },
        { name: i18nCompany, id: '002', link: '/aboutus' }
    ])

   
    const changeLang = (e: any) => {
        console.log(e)
        locale.value = e.target.value
        console.log(locale.value)
    }
    watch(locale, newlocale => {
        localStorage.setItem("locale", newlocale);
    });

    return {
        homeMenu, changeLang
    }
})

<template>
    <div>
        <div>
            切換語言：
            <select @change="changeLang">
                <option value="zh-TW">
                    中文
                </option>
                <option value="en-US">
                    English
                </option>
            </select>
        </div>
        <ul>
            <li v-for="(item, id) in homeMenu"
                :key="id">
                {{ item.name }}
            </li>
        </ul>
        <router-view />
    </div>
</template>

<script setup lang="ts">
    //載入pinia storeToRefs
    import { storeToRefs } from 'pinia';
    import { useNavbarStore } from './stores/nav';
      //宣告store = useNavbarStore()
    const store = useNavbarStore();
       //解構
    const { homeMenu } = storeToRefs(store);
    const { changeLang } = store;
</script>

<style lang="scss" scoped>
ul{
    display: flex;
    li  {
    display : flex;
    padding:10px;

    }
}
.logo {
  height: 6em;
  padding: 1.5em;
  will-change: filter;
  transition: filter 300ms;
}
.logo:hover {
  filter: drop-shadow(0 0 2em #646cffaa);
}
.logo.vue:hover {
  filter: drop-shadow(0 0 2em #42b883aa);
}
</style>

CREATE TABLE customer (
  C_Id INT NOT NULL CHECK (C_Id>0),
  Name VARCHAR(50) NOT NULL,
  Address VARCHAR(255),
  Phone VARCHAR(20)
);
CREATE TABLE customer (
  C_Id INT NOT NULL,
  Name VARCHAR(50) NOT NULL,
  Address VARCHAR(255),
  Phone VARCHAR(20),
  CHECK (C_Id>0)
);

CREATE TABLE customer (
  C_Id INT NOT NULL,
  Name VARCHAR(50) NOT NULL,
  Address VARCHAR(255),
  Phone VARCHAR(20),
  CONSTRAINT chk_Customer CHECK (C_Id>0 AND Name!='XXX')
);

ALTER TABLE customer ADD CHECK (C_Id>0);

ALTER TABLE customer
ADD CONSTRAINT chk_Customer CHECK (C_Id>0 AND Name!='XXX');

ALTER TABLE customer DROP CONSTRAINT chk_Customer;

CREATE TABLE customer (
  C_Id INT NOT NULL,
  Name VARCHAR(50) NOT NULL,
  Address VARCHAR(255) DEFAULT '未知',
  Phone VARCHAR(20)
);

ALTER TABLE customer ALTER COLUMN Address SET DEFAULT '未知';

ALTER TABLE customer ADD DEFAULT '未知' FOR Address;

ALTER TABLE customer ALTER COLUMN Address DROP DEFAULT;

ALTER TABLE table_name DROP constrain_name;

ALTER TABLE table_name MODIFY column_name DEFAULT NULL;