//routes/admin/user.js
import express from 'express'
const routeUser = express.Router()

routeUser.get('/',async function(req,res){
    if(req.session.user){
        const module = await import('../../controllers/admin/user/read.js')
        module.default(req,res)
    }else{
        res.redirect('/admin/login')
    }
})

routeUser.post('/',async function(req,res){
    if(req.session.user){
        const module = await import('../../controllers/admin/user/create.js')
        module.default(req,res)
    }else{
        res.redirect('/admin/login')
    }
})

routeUser.get('/edit/:id',async function(req,res){
    if(req.session.user){
        const module = await import('../../controllers/admin/user/read.js')
        module.default(req,res)
    }else{
        res.redirect('/admin/login')
    }
})

routeUser.post('/edit/:id',async function(req,res){
    if(req.session.user){
        const module = await import('../../controllers/admin/user/update.js')
        module.default(req,res)
    }else{
        res.redirect('/admin/login')
    }
})

export default routeUser

 

//controllers/admin/user/read.js
import settings from '../../../settings.js'
import read from '../../../models/user/read.js'
import count from '../../../models/count.js'

let mySettings = JSON.parse(JSON.stringify(settings))

export default async (req,res)=>{
    mySettings.pageTitle = 'ទំព័រ​អ្នក​ប្រើប្រាស់'
    mySettings.route = '/admin/user'

    if(req.params.id){
        mySettings.item = await read(req,mySettings.dItemLimit,req.params.id)
        const date = mySettings.item.date.toLocaleDateString('fr-CA')
        const time = mySettings.item.date.toLocaleTimeString('it-IT')
        mySettings.item.date = date + 'T' +  time
        req.session.password = mySettings.item.password
    }

    mySettings.items = await read(req,mySettings.dItemLimit)
    mySettings.count = await count(req,'users')

    res.render('base',{data:mySettings})
}

 

//models/user/read.js

export default async (req,amount=10,id=false)=>{
    if(id){
        return await req.mydb.collection("users").findOne({id:id})
    }else if(req.body.page){
        const page = req.body.page
        return await req.mydb.collection("users")
            .find().skip(amount*page).sort({date:-1,_id:-1}).limit(amount).toArray()
    }else{
        return await req.mydb.collection("users")
            .find().sort({date:-1,_id:-1}).limit(amount).toArray()
    }
}

 

//controllers/admin/user/update.js
import settings from '../../../settings.js'
import read from '../../../models/user/read.js'
import update from '../../../models/user/update.js'

let mySettings = JSON.parse(JSON.stringify(settings))

export default async (req,res)=>{
    let item = await read(req,mySettings.dItemLimit,req.params.id)
    if((req.session.user.role === 'Admin')||(req.session.user.id === item.id)){
        await update(req)
    }
    res.redirect('/admin/user')
}

 

//models/user/update.js
import bcrypt from 'bcryptjs'

export default async (req)=>{
    const myquery = {id:req.params.id}

    if(req.body.password !== req.session.password){
        var hashPassword = bcrypt.hashSync(req.body.password, 12)
    }else{
        var hashPassword = req.body.password
    }
    
    let newvalue = {$set: {
        title: req.body.title,
        info: req.body.content,
        thumb: req.body.thumb,
        video: req.body.entries,
        role: req.body.category,
        date: new Date(req.body.datetime),
        email: req.body.email,
        password: hashPassword,
    }}
 
    await req.mydb.collection("users").updateOne(myquery,newvalue)
}

 

<!--views/admin/post.ejs-->
<link rel='stylesheet' href='/styles/admin/post.css' />
<script src="/scripts/ckeditor/ckeditor.js"></script>
<script src="/scripts/admin/video.js"></script>

<section class='Main'>
    <div class='content'>
        
        <% if(data.item){ %>
        <form action='/admin/user/edit/<%= data.item.id %>' method='post' >
            <input type='text' name='title' value='<%= data.item.title %>' placeholder='ចំណងជើង' required />
            <textarea name="content" id="editor" ><%= data.item.content %></textarea>
            <div class='wrapper'>
                <select name='category' class='category' >
                    <option>Author</option>
                    <option>Editor</option>
                    <option>Admin</option>
                </select>
                <script>$(".category").val("<%= data.item.role %>").change()</script>
                <input type='text' name='thumb' value='<%= data.item.thumb %>' 
                    required placeholder="តំណរ​ភ្ជាប់​រូប​តំណាង" />
                <input type='datetime-local' value='<%= data.item.date %>' name='datetime' 
                    required />
                <input type='submit' value='ចុះ​ផ្សាយ' />
                <input type="email" name="email" value="<%= data.item.email %>" 
                    required placeholder="Email" />
                <input type="password" name="password" value="<%= data.item.password %>" 
                    required />
                <input type="text" disabled />
                <button disabled></button>
                <div></div> 
            </div>
            <input name='entries' value='<%- data.item.video %>' type='hidden' />
        </form>
        <% }else{ %>
        <form action='/admin/user' method='post' >
            <input type='text' name='title' placeholder='ឈ្មោះ​អ្នក​ប្រើប្រាស់' required />
            <textarea name="content" id="editor" ></textarea>
            <div class='wrapper'>
                <select name='category'>
                    <option>Author</option>
                    <option>Editor</option>
                    <option>Admin</option>
                </select>
                <input type='text' name='thumb' required placeholder="តំណរ​ភ្ជាប់​រូប​តំណាង" />
                <input type='datetime-local' value='' name='datetime' required />
                <input type='submit' value='ចុះ​ផ្សាយ' />
                <input type="email" name="email" required placeholder="Email" />
                <input type="password" name="password" required />
                <input type="text" disabled />
                <button></button>
                <div></div> 
            </div>
            <input name='entries' value='' type='hidden' />
        </form>
        <% } %>
 
        <div class='form'>
            <select name='type'>
                <option>YouTube</option>
                <option>YouTubePlaylist</option>
                <option>Facebook</option>
                <option>OK</option>
                <option>Dailymotion</option>
                <option>Vimeo</option>
            </select>
            <input name='id' type='text' placeholder="អត្តសញ្ញាណវីដេអូ" required />
            <select name='ending'>
                <option>ចប់​</option>
                <option>មិន​ទាន់ចប់</option>
                <option>~ ចប់</option>
            </select>
            <input onclick='genJson()' type="button" value="បញ្ចូល​វីដេអូ" />
        </div>
 
        <table class='viddata'></table>
        
        <% if(data.item){ %>
            <script>
                var entries = JSON.parse('<%- data.item.video %>')
            </script>
        <% }else{ %>
            <script>
                var entries = ''
            </script>
        <% } %>
        <% delete data.item %>

        <script>
        if(entries.length > 0){
            let html = ``
            for(let v in entries){
                episode += 1
                html += `<tr>`
                html += `<td title="Delete" onClick="deleteRow(event)" class="episode">${episode}</td>`
                html += `<td class="td${episode}">${entries[v].type}</td>`
                html += `<td class="td${episode}">${entries[v].id}</td>`
                html += `<td class="td${episode}">${entries[v].ending}</td>`
                html += `</tr>`
            }
 
            if($('.viddata').html() === ''){
                $('.viddata').append('<tr>')
                $('.viddata').append('<th>ភាគ/លុប</th>')
                $('.viddata').append('<th>ប្រភេទ​</th>')
                $('.viddata').append('<th>អត្តសញ្ញាណ​</th>')
                $('.viddata').append('<th>ចប់ឬ​នៅ?</th>')
                $('.viddata').append('</tr>')
            }
 
            $('.viddata').append(`${html}`)
 
        }
        </script>
 
        <script src="/scripts/ckeditor/config.js"></script>
    </div>
</section>

 

GitHub: https://github.com/Sokhavuth/Blog_

Vercel: https://khmerweb-blog.vercel.app/