stellacheng-chm
diff --git a/api/controllers/BookController.js b/api/controllers/BookController.js
@@ -7,62 +7,334 @@
 
 module.exports = {
 
-    booksearch: async function (req, res) {
-        var models = await Book.find().sort([{id:'DESC'}]);
-        return res.view('book/booksearch', { book: models});
+    userbooksearch: async function (req, res) {
+        var models = await Book.find().sort([{ id: 'DESC' }]);
+        return res.view('book/userbooksearch', { book: models });
     },
 
-    bookresult: async function(req, res){
-        const qCatrgory=req.query.category || "";
+    userbookresult: async function (req, res) {
+        const qCatrgory = req.query.category || "";
         const qBookname = req.query.bookname;
         const qAuthor = req.query.author;
-        const qPublisher = req.query.publisher;
-        const qISBN = req.query.ISBN;
+        const qNo = req.query.no;
+        // const qPublisher = req.query.publisher;
+        // const qISBN = req.query.ISBN;
 
         var models = await Book.find({
-            where:{
-
-            category:{contains:qCatrgory},
-            bookname:{contains:qBookname},
-            author:{contains:qAuthor},
-            publisher:{contains:qPublisher},
-            ISBN:{contains:qISBN},
+            where: {
+                category: { contains: qCatrgory },
+                no: { contains: qNo },
+                category: { contains: qCatrgory },
+                bookname: { contains: qBookname },
+                author: { contains: qAuthor },
             }
-
-        }).sort([{id:'DESC'}]);
 
-        return res.view('book/bookresult', {book:models});
+        }).sort([{ id: 'DESC' }]);
+
+        if (models.length == 0) {
+            return res.redirect('/item/useritemnotfound');
+        }
+
+        return res.view('book/userbookresult', { book: models });
+
+    },
+
+    userbookdetail: async function (req, res) {
+
+        var model = await Book.findOne(req.params.id);
+
+        if (!model) return res.notFound();
+
+        return res.view('book/userbookdetail', { book: model });
+
+    },
+
+    userbookdetail2: async function (req, res) {
+
+        var model = await Book.findOne(req.params.id);
+
+        if (!model) return res.notFound();
+
+        return res.view('book/userbookdetail2', { book: model });
+
+    },
+
+    userbookreturn: async function (req, res) {
+
+        var model = await Book.findOne(req.params.id);
+
+        if (!model) return res.notFound();
+
+        return res.view('book/userbookreturn', { book: model });
+
+    },
+
+    userbookreserve: async function (req, res) {
+
+        var model = await Book.findOne(req.params.id);
+
+        if (!model) return res.notFound();
+
+        return res.view('book/userbookreserve', { book: model });
+
+    },
+
+
+
+    vistorbooksearch: async function (req, res) {
+        var models = await Book.find().sort([{ id: 'DESC' }])
+        return res.view('book/vistorbooksearch', { book: models });
+    },
+
+    vistorbookresult: async function (req, res) {
+        const qCatrgory = req.query.category || "";
+        const qBookname = req.query.bookname;
+        const qAuthor = req.query.author;
+        const qNo = req.query.no;
+        // const qPublisher = req.query.publisher;
+        // const qISBN = req.query.ISBN;
+
+        var models = await Book.find({
+            where: {
+                category: { contains: qCatrgory },
+                no: { contains: qNo },
+                category: { contains: qCatrgory },
+                bookname: { contains: qBookname },
+                author: { contains: qAuthor },
+            }
+
+        }).sort([{ id: 'DESC' }]);
+
+        if (models.length == 0) {
+            return res.redirect('/item/visitoritemnotfound');
+        }
+
+        return res.view('book/vistorbookresult', { book: models });
 
     },
 
-    vbooksearch: async function (req, res) {
-        var models = await Book.find().sort([{id:'DESC'}])
-        return res.view('book/vbooksearch', { book: models});
+
+
+    vistorbookdetail: async function (req, res) {
+
+        var model = await Book.findOne(req.params.id);
+
+        if (!model) return res.notFound();
+
+        return res.view('book/vistorbookdetail', { book: model });
+
     },
 
-    vbookresult: async function(req, res){
-        const qCatrgory=req.query.category || "";
+    adminbooksearch: async function (req, res) {
+        var models = await Book.find().sort([{ id: 'DESC' }]);
+
+        return res.view('book/adminbooksearch', { book: models });
+    },
+
+    adminbookresult: async function (req, res) {
+        const qCatrgory = req.query.category || "";
         const qBookname = req.query.bookname;
         const qAuthor = req.query.author;
-        const qPublisher = req.query.publisher;
-        const qISBN = req.query.ISBN;
+        const qNo = req.query.no;
+        // const qPublisher = req.query.publisher;
+        // const qISBN = req.query.ISBN;
 
         var models = await Book.find({
-            where:{
-
-            category:{contains:qCatrgory},
-            bookname:{contains:qBookname},
-            author:{contains:qAuthor},
-            publisher:{contains:qPublisher},
-            ISBN:{contains:qISBN},
+            where: {
+                category: { contains: qCatrgory },
+                no: { contains: qNo },
+                category: { contains: qCatrgory },
+                bookname: { contains: qBookname },
+                author: { contains: qAuthor },
+            }
+
+        }).sort([{ id: 'DESC' }]);
+
+        if (models.length == 0) {
+            return res.redirect('/item/adminitemnotfound');
+        }
+
+        return res.view('book/adminbookresult', { book: models });
+
+    },
+
+    adminbookdetail: async function (req, res) {
+
+        var model = await Book.findOne(req.params.id);
+
+        if (!model) return res.notFound();
+
+        return res.view('book/adminbookdetail', { book: model });
+
+    },
+
+    adminbookedit: async function (req, res) {
+        var models = await Book.find().sort([{ id: 'DESC' }]);
+
+        return res.view('book/adminbookedit', { book: models });
+    },
+
+    // action - adminupdate
+    adminbookupdate: async function (req, res) {
+
+        if (req.method == "GET") {
+
+            var model = await Book.findOne(req.params.id);
+
+            if (!model) return res.notFound();
+
+            return res.view('book/adminbookupdate', { book: model });
+
+        } else {
+
+            if (!req.body.Book)
+                return res.badRequest("Form-data not received.");
+
+            var models = await Book.update(req.params.id).set({
+                bookname: req.body.Book.bookname,
+                author: req.body.Book.author,
+                category: req.body.Book.category,
+                location: req.body.Book.location,
+                year: req.body.Book.year,
+                no: req.body.Book.no,
+            }).fetch();
+            if (models.length == 0) return res.notFound();
+
+            return res.redirect("/book/adminbookedit");
+
+        }
+    },
+
+    // action - delete 
+    adminbookdelete: async function (req, res) {
+
+        if (req.method == "GET") return res.forbidden();
+
+        var models = await Book.destroy(req.params.id).fetch();
+
+        if (models.length == 0) return res.notFound();
+
+        if (req.wantsJSON) {
+            return res.json({ message: "該書本已被刪除", url: '/book/adminbookedit' });
+        } else {
+
+            return res.redirect("/book/adminbookedit");
+        }
+
+    },
+
+    import_xlsx: async function (req, res) {
+
+        if (req.method == 'GET')
+            return res.view('book/import_xlsx');
+
+        req.file('file').upload({ maxBytes: 10000000 }, async function whenDone(err, uploadedFiles) {
+            if (err) { return res.serverError(err); }
+            if (uploadedFiles.length === 0) { return res.badRequest('No file was uploaded'); }
+
+            var XLSX = require('xlsx');
+            var workbook = XLSX.readFile(uploadedFiles[0].fd);
+            var ws = workbook.Sheets[workbook.SheetNames[0]];
+            var data = XLSX.utils.sheet_to_json(ws);
+            console.log(data);
+            var models = await Book.createEach(data).fetch();
+            if (models.length == 0) {
+                return res.badRequest("No data imported.");
             }
-
-        }).sort([{id:'DESC'}]);
+            return res.redirect("/book/adminbookedit");
+        });
+    },
+
+    borrow: async function (req, res) {
+        return res.view('book/borrow');
+    },
+
+    return: async function (req, res) {
+        return res.view('book/return');
+    },
 
-        return res.view('book/vbookresult', {book:models});
+    print: async function (req, res) {
+        var models = await Book.find().sort([{ id: 'DESC' }]);
+        return res.view('book/print', { book: models });
 
     },
-
+
+    useraddremark: async function (req, res) {
+        var model = await Book.findOne(req.params.id);
+        if (req.method == "GET") {
+            return res.view('book/useraddremark', { book: model })
+        } else {
+
+            var userremarks = req.body.remarks;
+
+            await Item.create(
+                {
+                    message: "書籍(" + model.bookname + ")新增備註: " + userremarks,
+                });
+
+
+            var models = await Book.update(req.params.id).set({
+                remarks: userremarks,
+            }).fetch();
+            if (models.length == 0) return res.notFound();
+
+            return res.redirect('/book/userbookreturn/' + model.id)
+        }
+    },
+
+    uploadphoto: async function (req, res) {
+        var model = await Book.findOne(req.params.id);
+
+        if (req.method == 'GET')
+            return res.view('book/uploadphoto', { book: model });
+
+        await Book.update({ id: model.id }, {
+            avatar: req.body.Book.avatar
+        });
+
+        return res.redirect('/book/adminbookedit');
+    },
+
+    export_xlsx: async function(req, res) {
+
+        var models = await Book.find();
+
+        var XLSX = require('xlsx');
+        var wb = XLSX.utils.book_new();
+
+        var ws = XLSX.utils.json_to_sheet(models.map(model => {
+            return {
+                no: model.no,
+                bookname: model.bookname,
+                category: model.category,
+                author: model.author,
+                year: model.year,
+                location: model.location,
+                remarks:model.remarks,
+                // borrowinfo: model.borrowinfo,
+                // returninfo: model.returninfo,
+                // ISBN: model.ISBN,                
+                // QRcode:model.??
+            }
+        }));
+        XLSX.utils.book_append_sheet(wb, ws, "圖書");
+
+        res.set("Content-disposition", "attachment; filename=book.xlsx");
+        return res.end(XLSX.write(wb, { type: "buffer", bookType: "xlsx" }));
+    },
+
+
+
+
+
+
+
+
+
+
+
+
+
 
 };