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