const express   =   require("express"),
      router    =   express.Router(),
      db        =   require("../db");



router.get('/objects/:id/category',(req,res)=>{
    let bar= 1;
    let idObj= req.params.id;
    let sql= `SELECT id_cat,title_cat,icon_cat FROM category WHERE id_cat IN
             (SELECT id_cat FROM have_cat WHERE id_object = ${idObj});
             SELECT * FROM object WHERE id_object=${idObj}`;
enter code here
        let query= db.query(sql, (err,result)=>{

        if(err){
                throw err;

        }else{
            res.render('category', {category:result[0], object:result[1], idObj:idObj, bar:bar});
        }




    });


});


module.exports= router;