// routes/admin/category.js
import express from 'express'
const categoryRouter = express.Router()
import category from '../../controllers/admin/category.js'

categoryRouter.get('/',async (req,res)=>{
    if(req.session.user){
        category.getItem(req,res)
    }else{
        res.redirect('/login')
    }
})

categoryRouter.post('/',async (req,res)=>{
    if(req.session.user){
        category.postItem(req,res)
    }else{
        res.redirect('/login')
    }
})

categoryRouter.get('/edit/:id',async (req,res)=>{
    if(req.session.user){
        category.editItem(req,res)
    }else{
        res.redirect('/login')
    }
})

categoryRouter.post('/edit/:id',async (req,res)=>{
    if(req.session.user){
        category.updateItem(req,res)
    }else{
        res.redirect('/login')
    }
})

categoryRouter.get('/delete/:id',async (req,res)=>{
    if(req.session.user){
        category.deleteItem(req,res)
    }else{
        res.redirect('/login')
    }
})

categoryRouter.post('/paginate',async (req,res)=>{
    if(req.session.user){
        category.paginateItem(req,res)
    }else{
        res.redirect('/login')
    }
})

export default categoryRouter

 

// controllers/admin/category.js
import config from "../../config.js"
import categorydb from '../../models/category.js'

class Category{
    async getItem(req,res){
        this.config = await config()
        this.config.pageTitle = 'ទំព័រ​ប្រភេទ​ទំនិញ'
        this.config.route = '/admin/category'
        this.config.type = 'category'

        this.config.count = await categorydb.count(req)
        this.config.items = await categorydb.getItem(req,this.config.maxPosts)

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

    async postItem(req,res){
        await categorydb.postItem(req)
        res.redirect('/admin/category')
    }

    async editItem(req,res){
        this.config = await config()
        this.config.pageTitle = 'ទំព័រ​កែប្រែ​ប្រភេទ​ទំនិញ'
        this.config.route = '/admin/category'
        this.config.type = 'category'

        this.config.count = await categorydb.count(req)
        this.config.item = await categorydb.editItem(req)
        this.config.items = await categorydb.getItem(req,this.config.maxPosts)

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

    async updateItem(req,res){
        if(req.session.user.role === 'Admin'){
            await categorydb.updateItem(req)
        }

        res.redirect('/admin/category')
    }

    async deleteItem(req,res){
        if(req.session.user.role === 'Admin'){
            await categorydb.deleteItem(req)
        }

        res.redirect('/admin/category')
    }

    async paginateItem(req,res){
        this.config = await config()
        this.config.route = '/admin/category'
        this.config.type = 'category'

        this.config.items = await categorydb.paginateItem(req,this.config.maxPosts)

        res.json(this.config)
    }
}

export default new Category()

 

// models/category.js

class Category{
    async count(req){
        return await req.mydb.collection('categories').countDocuments()
    }

    async postItem(req){
        const id = Date.now() + Math.round(Math.random() * 1E9).toString()
 
        let newCategory = {
            id: id, 
            title: req.body.title,
            thumb: req.body.thumb,
            postdate: req.body.datetime
        }
 
        await req.mydb.collection("categories").insertOne(newCategory)
    }

    async getItem(req,amount){
        return await req.mydb.collection("categories").find().sort({date:-1,_id:-1}).limit(amount).toArray()
    }

    async editItem(req){
        return await req.mydb.collection('categories').findOne({id:req.params.id})
    }

    async updateItem(req){
        let myquery = {id: req.params.id}
        let newvalue = {$set: {
            title: req.body.title,
            thumb: req.body.thumb,
            postdate: req.body.datetime
        }}
 
        await req.mydb.collection("categories").updateOne(myquery,newvalue)
    }

    async deleteItem(req){
        await req.mydb.collection("categories").deleteOne({id:req.params.id})
    }

    async paginateItem(req,amount){
        const page = req.body.page
        return await req.mydb.collection("categories").find().skip(amount*page).sort({date:-1,_id:-1}).limit(amount).toArray()
    }
}

export default new Category()

 

//static/scripts/paginate.js

let page = 0

function paginate(route){
    $('.pagination img').attr('src', '/images/loading.gif')
    page += 1
    
    $.post(`${route}/paginate`,{page:page},function(data, status){
        appendItem(data.items,route,data)
    })
}

function appendItem(items, route,data){
    let html = ''
    
    if(items){
        for(let item of items){
            html += `<li>`
                html += `<div class='thumb'>`
                    html += `<a href="/${data.type}/${item.id}"><img src="${item.thumb}"/></a>`
                html += `</div>`
                html += `<div class="title">`
                    html += `<a href="/${data.type}/${item.id}">${item.title}</a>`
                    html += `<div>${new Date(item.postdate).toLocaleDateString('it-IT')}</div>`
                html += `</div>`
                html += `<div class="edit">`
                    html += `<a href="${route}/edit/${item.id}"><img src="/images/edit.png"/></a>`
                    html += `<a href="${route}/delete/${item.id}"><img src="/images/delete.png"/></a>`
                html += `</div>` 
            html += `</li>`
        }
    }
    $('.list').append(html)

    if(route === '/admin/user'){
        $('.Footer .list li').css({'grid-template-columns':'13% auto 25%'})
        $('.Footer .list li .thumb').css({'padding-top':'100%'})
        $('.Footer .list li .thumb img').css({'border-radius':'50%'})
    }

    $('.pagination img').attr('src', '/images/load-more.png')
}

 

Heroku: https://khmerweb-sale.herokuapp.com/login