app.js

//jshint esversion:6
require('dotenv').config();
const express = require('express');
const bodyParser = require('body-parser');
const session = require('express-session');
const md5 = require('md5');
const mongoose = require("mongoose");
const passport = require('passport');
const localStrategy = require('passport-local').Strategy;
const bcrypt = require('bcrypt');
const { Console } = require('console');
const { verify } = require('crypto');
const stripe = require("stripe")(process.env.STRIPE_PRIVATE_KEY)
const nodemailer = require("nodemailer");
const needle = require('needle');
const { get } = require('http');
const app = express();

//OpenAI setup
const { Configuration, OpenAIApi } = require("openai");
const configuration = new Configuration({
    apiKey: process.env.GPT_KEY,
});
const openai = new OpenAIApi(configuration);

//middleware
app.use(session({
    secret: toString(process.env.MYSECRET),
    resave: false,
    saveUninitialized: true
}));
app.use(express.urlencoded({ extended: false }));
app.use(bodyParser.json());
app.use(express.json());
// app.use(bodyParser.urlencoded({ extended: true }));
const PORT = process.env.PORT || 80;
const GPTkey = process.env.GPT_KEY;
app.use(express.static("public"));
app.set('view engine', 'ejs');

let usersId = 10000;
let productId = 720000;
let bulkOrderId = 10;
let adminPassKeyHash = md5((process.env.ADMIN_PLAIN));

//Twilio Client Initialisation
const accountSid = process.env.TWILIO_ACCOUNT_SID;
const authToken = process.env.TWILIO_AUTH_TOKEN;
const client = require('twilio')(accountSid, authToken);

// NodeMailer Initialisation
let transporter = nodemailer.createTransport({
    host: "smtp.gmail.com",
    port: 465,
    secure: true,
    auth: {
        user: process.env.EMAIL_ID,
        pass: process.env.EMAIL_KEY
    },
});

//Mongoose initialisations
mongoose.set('strictQuery', true);
const dbURL = process.env.DBURL;
mongoose.connect(dbURL);
const ProductSchema = new mongoose.Schema({
    ProductId: Number,
    Variety: String,
    ProductName: String,
    Description: String,
    cost: Number,
    imageURL: String,
    SellerName: String,
    SellerAddress: String,
    link: String,
    Mobile: Number,
    emailId: String,
    Quantity: Number,
    OtherName: String
});
const NewProduct = mongoose.model('NewProduct', ProductSchema);

const UserSchema = new mongoose.Schema({
    usersId: Number,
    userName: String,
    age: Number,
    status: String,
    Location: String,
    Occupation: String,
    mobileNo: Number,
    emailId: String,
    password: String
});
const User = mongoose.model('User', UserSchema);

const DeviceSchema = new mongoose.Schema({
    userId: Number,
    deviceName: String,
    Location: String,
    deviceType: String,
    Link: String
});
const Device = mongoose.model('Device', DeviceSchema);

const PaymentSchema = new mongoose.Schema({
    SellerName: String,
    SellerEmail: String,
    SellerMobile: Number,
    BuyerName: String,
    BuyerEmail: String,
    BuyerMobile: Number,
    SellerNotifiedStatus: String,
    ProductId: Number,
    ProductName: String,
    cost: Number,
    Quantity: Number
});
const Payment = mongoose.model("Payment", PaymentSchema);

const costOfComponentSchema = new mongoose.Schema({
    esp32: Number,
    esp8266: Number,
    moisture: Number,
    temperature: Number,
    solar: Number,
    jumpers: Number,
    serviceCharge: Number
});
const costOfComponent = mongoose.model('costOfComponent', costOfComponentSchema);

const BulkOrderSchema = new mongoose.Schema({
    OrderId: Number,
    SellerId: Number,
    BuyerId: Number,
    Status: String,
    ProductId: Number,
    BidAmount: Number,
    MarketPrice: Number,
    Quantity: Number
});
const BulkOrder = mongoose.model("BulkOrder", BulkOrderSchema);

//For server side Caching of Advices by Open Ai
const CropAdviseSchema = new mongoose.Schema({
    location: String,
    Advice: String
});
const CropAdvice = mongoose.model("CropAdvice", CropAdviseSchema);

const FraudReportSchema = new mongoose.Schema({
    ItemId: Number,
    ReporterID: Number,
    Description: String,
    Status: String
});
const FraudReport = mongoose.model("FraudReport", FraudReportSchema);

//Testing Purpose
const DummySchema = new mongoose.Schema({
    item: Number,
    name: String
});
const Dummy = mongoose.model("Dummy", DummySchema);

// Structures for adding new elements as per their Schemas

// var newEntry = new NewProduct({
//     ProductId: 225, ProductName: "String",Variety: "Normal", Description: "ajlfsdkj asodijf;masd lj aosdjf asdjf jjw oirj", cost: 500, imageURL: "String", SellerName: "String", SellerAddress: "String", Mobile: 9515306769, emailId:"sanjaykumarkonakandla@gmail.com", Quantity:25
// });
// newEntry.save();

// var newDevice = new Device({
//     userId: req.user.usersId,
//     deviceName: req.user.userName,
//     Location: req.user.Location,
//     deviceType: req.user.deviceType,
//     Link: "https://thingspeak.com/channels/2065077/charts/1?bgcolor=%23ffffff&color=%23d62020&dynamic=true&results=60&type=line&update=15",
// });
// newDevice.save();

//         "https://thingspeak.com/channels/2065077/charts/2?bgcolor=%23ffffff&color=%23d62020&dynamic=true&results=60&type=line&update=15",
//         "https://thingspeak.com/channels/2065077/charts/3?bgcolor=%23ffffff&color=%23d62020&dynamic=true&results=60&type=line&update=15",
//         "https://thingspeak.com/channels/2065077/charts/4?bgcolor=%23ffffff&color=%23d62020&dynamic=true&results=60&type=line&update=15"

// const SampleTransaction = new Payment({
//     SellerName: "Sanjay Kumar",
//     SellerEmail: "sanjaykumarkonakandla@gmail.com",
//     SellerMobile: 9515306769,
//     BuyerName: "Durga Prasad",
//     BuyerEmail: "dpakurathi1616@gmail.com",
//     BuyerMobile: 7893924278,
//     SellerNotifiedStatus: "No",
//     ProductId: 7200016,
//     ProductName: "Apple",
//     cost: 40,
//     Quantity: 5
// });
// SampleTransaction.save();

// var costEntry = new costOfComponent({
//     esp32: 450,
//     esp8266: 320,
//     moisture: 90,
//     temperature: 70,
//     solar: 210,
//     jumpers: 2,
//     serviceCharge: 200
// });
// costEntry.save();

// Updating Ids with the last ID's so that Id's will not get repeated even if the server is restarted.
async function updateIds() {
    try {
        let LastProduct = await NewProduct.findOne({}).sort({ field: 'asc', _id: -1 }).limit(1);
        let LastUser = await User.findOne({}).sort({ field: 'asc', _id: -1 }).limit(1);
        let LastBulk = await BulkOrder.findOne({}).sort({ field: 'asc', _id: -1 }).limit(1);
        // console.log(LastProduct.ProductId);
        // console.log(LastUser.usersId);
        if (LastProduct != null)
            productId = LastProduct.ProductId;
        if (LastUser != null)
            usersId = LastUser.usersId;
        if (LastBulk != null)
            bulkOrderId = LastBulk.OrderId;
    }
    catch (err) {
        console.log(err);
    }
}
updateIds();

// Passport.js initialisations
app.use(passport.initialize());
app.use(passport.session());

//Serialising user
passport.serializeUser(function (user, done) {
    done(null, user.id);
});

//Deserialising user
passport.deserializeUser(async (id, done) => {
    const USER = await User.findById(id);
    done(null, USER);
});

passport.use(new localStrategy({
    usernameField: 'emailId',
    passwordField: 'password'
},
    function (username, password, done) {
        async function executer1() {
            let user = [];
            try {
                user = await User.findOne({ emailId: username });
            }
            catch (err) {
                return done(err);
            }
            function executer2(user) {
                // if (err) return done(err);
                if (!user) return done(null, false, { message: "Incorrect username" });
                if (user.status == "Blocked") {
                    return done(null, false, { message: "User Blocked." });
                }
                bcrypt.compare(password, user.password, function (err, res) {
                    if (err) return done(err);
                    if (res === false) return done(null, false, { message: "Incorrect password" });
                    return done(null, user);
                });
            }
            executer2(user);
        }
        executer1();
    }
));

// Checking whether the user is logged in or not
function isLoggedIn(req, res, next) {
    if (req.isAuthenticated()) return next();
    res.redirect('/login');
}

//Checking whether the user is Admin or Not
function isAdmin(req, res, next) {
    if (req.isAuthenticated() && req.user.usersId == process.env.ADMIN_ID) return next();
    res.redirect('/market');
}

// Checking whether the user is logged out or not
function isLoggedOut(req, res, next) {
    if (!req.isAuthenticated()) return next();
    res.redirect('/market');
}

//Get routes Start
app.get("/", function (req, res) {
    // res.sendFile(__dirname + "/index.html");
    let temp = "Login👤";
    if (req.isAuthenticated()) {
        // console.log(req.user.userName);
        temp = req.user.userName
    }
    res.render("index", { name: temp });
});

app.get("/login", isLoggedOut, function (req, res) {
    res.render("login", { error: req.query.error });
});

app.get("/userRegister", function (req, res) {
    res.render("getMobile", { error: req.query.error })
    // res.render("register", {});
});

app.get("/market", isLoggedIn, function (req, res) {
    async function getCheapCosts() {
        let data = await NewProduct.aggregate([
            {
                $group: {
                    _id: "$ProductName",
                    minPrice: { $min: '$cost' }
                }
            }
        ]).sort({ _id: 1 });
        const myData = data.reduce((acc, item) => {
            acc[item._id] = item.minPrice;
            return acc;
        }, {});
        // console.log(myData.Apple);
        res.render("marketIntro", { bestDeals: myData });
    }
    getCheapCosts();
});

app.get("/market/:productName", isLoggedIn, function (req, res) {
    // console.log(req.params);
    // console.log(req.query);
    let myProductData = [];
    async function getParticularProduct() {
        let pictures = ["Products", "Products1", "Products2"];
        if (req.query.sort == "PriceLowToHigh")
            myProductData = await NewProduct.find({ ProductName: req.params.productName }).sort({ 'cost': 1 });
        else if (req.query.sort == "PriceHighToLow")
            myProductData = await NewProduct.find({ ProductName: req.params.productName }).sort({ 'cost': -1 });
        else if (req.query.sort == "LatestFirst")
            myProductData = await NewProduct.find({ ProductName: req.params.productName }).sort({ 'ProductId': -1 });
        else if (req.query.sort == "OldestFirst")
            myProductData = await NewProduct.find({ ProductName: req.params.productName }).sort({ 'ProductId': 1 });
        else
            myProductData = await NewProduct.find({ ProductName: req.params.productName });
        // res.send(myProductData);
        // console.log(myProductData);
        res.render("mainMarket", {
            productList: myProductData,
            sortingKey: req.query.sort,
            myPictures: pictures
        });
    }
    getParticularProduct();
});

app.get("/logout", isLoggedIn, function (req, res) {
    req.logout(req.user, err => {
        if (err) return next(err);
        res.redirect("/");
    });
});

app.get("/newProduct", isLoggedIn, function (req, res) {
    async function sendResponse() {
        let userSensors = await Device.find({ userId: req.user.usersId, deviceType: "Trendline" });
        res.render("productEntry", { sensors: userSensors });
    }
    sendResponse();
});

app.get("/myProducts", isLoggedIn, function (req, res) {
    async function getMyProducts() {
        let pictures = ["Products", "Products1", "Products2"];
        let myProductData = await NewProduct.find({ Mobile: req.user.mobileNo }).sort({ 'ProductName': 1 });
        // res.send(myProductData);
        // console.log(myProductData);
        res.render("customerProductsView", {
            name: req.user.userName,
            productList: myProductData,
            myPictures: pictures
        });
    }
    getMyProducts();
});

app.get("/productDetail/:pID", isLoggedIn, function (req, res) {
    // console.log(req.params.SellerMobile);
    // console.log(req.params.pID);
    async function getSellerDetails() {
        let mySellerData = await NewProduct.findOne({ ProductId: req.params.pID });
        if (mySellerData != null) {
            res.render("productDetails", {
                name: req.user.userName,
                sellerData: mySellerData
            });
        }
        else
            res.redirect("/messageRoute?Message=Sorry Product already SOLD out.");
    }
    getSellerDetails();
});

app.get("/messageRoute", function (req, res) {
    res.render("message", { redirectTo: "/market", myMessage: req.query.Message });
});

app.get("/IOT", isLoggedIn, function (req, res) {
    async function getDeviceData() {
        let realTime = await Device.find({ userId: req.user.usersId, deviceType: "Realtime" });
        let trendLine = await Device.find({ userId: req.user.usersId, deviceType: "Trendline" });
        // console.log(devicesInfo);
        if (realTime != null && trendLine != null)
            res.render("agriIOT", { realtimeDevices: realTime, trendlineDevices: trendLine });
        else if (trendLine == null)
            res.render("agriIOT", { realtimeDevices: realTime, trendlineDevices: [] });
        else if (realTime == null)
            res.render("agriIOT", { realtimeDevices: [], trendlineDevices: trendLine });
        else
            res.render("agriIOT", { realtimeDevices: [], trendlineDevices: [] });
    }
    getDeviceData();
});

app.get("/success", isLoggedIn, function (req, res) {
    let mySellerData = "";
    async function insertPayment() {
        // console.log(req.query.Pid);
        mySellerData = await NewProduct.findOne({ ProductId: req.query.Pid });
        // console.log(mySellerData);
        if (mySellerData != null) {
            const MyTransaction = new Payment({
                SellerName: mySellerData.SellerName,
                SellerEmail: mySellerData.emailId,
                SellerMobile: mySellerData.Mobile,
                BuyerName: req.user.userName,
                BuyerEmail: req.user.emailId,
                BuyerMobile: req.user.mobileNo,
                SellerNotifiedStatus: "No",
                ProductId: mySellerData.ProductId,
                ProductName: mySellerData.ProductName,
                cost: mySellerData.cost,
                Quantity: req.query.quant,
            });
            // console.log(MyTransaction);
            MyTransaction.save();
        }
        else
            res.send("Sorry :( product already SOLD. Please refresh the market page.");
    }
    async function reduceStock() {
        let oldData = await NewProduct.findOne({ ProductId: req.query.Pid });
        let newQuant = oldData.Quantity - req.query.quant;
        await NewProduct.updateOne({ ProductId: req.query.Pid }, { Quantity: newQuant });
        let updated = await NewProduct.findOne({ ProductId: req.query.Pid });
        // console.log(updated);
        if (updated.Quantity <= 0) {
            await NewProduct.deleteOne({ ProductId: req.query.Pid });
        }
    }
    async function notifySeller() {
        mySellerData = await NewProduct.findOne({ ProductId: req.query.Pid });
        let info = await transporter.sendMail({
            from: `"Manager of Sales" <${process.env.EMAIL_ID}>`,
            to: mySellerData.emailId,
            subject: `✅ You received order for Product with Product Id : ${mySellerData.ProductId}`,
            html: `
                <div style="display: flex; justify-content: center;">
                    <table style="max-width: 600px; background-color: rgb(244, 255, 241); margin: 0 auto;" width="100%"
                        cellpadding="0" cellspacing="0">
                        <tr>
                            <td style="background-color: #00a033; text-align: center;">
                                <img style="max-width: 100%;" src="https://i.ibb.co/rZnQ8Hn/agri1.jpg" alt="">
                            </td>
                        </tr>
                        <tr style="text-align: center;">
                            <td>
                                <img style="height: 50px;margin-top:30px;" src="https://s11.gifyu.com/images/croppedTitle.gif">
                            </td>
                        </tr>
                        <tr>
                            <td style="padding: 20px; text-align: center; font-size: 24px; font-weight: bold; color: #015f11;">
                                You received an order for your product.</td>
                        </tr>
                        <tr>
                            <td style="padding: 20px; text-align: justify; font-size: 16px; color: #3d5d36;">
                                <h4>Hello dear ${mySellerData.SellerName},</h4>
                                <p>Greetings of the day,
                                    <br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; This email is to inform you that you have received
                                    an order for ${mySellerData.ProductName}(s) with a quantity
                                    requirement of ${req.query.quant} Kg(s). <br>Payment for the same has been processed. You can find
                                    more details in this email
                                    or you can visit our Fruitful app to know more.
                                </p>
                            </td>
                        </tr>
                        <tr>
                            <td style="padding: 20px; text-align: justify; font-size: 16px; color: #3d5d36;">
                                Here are the details for your order. To know more please visit our portal.
                                <table style="margin: 10px; margin-left: 20px;">
                                    <tr>
                                        <td>
                                            Customer Name
                                        </td>
                                        <td>
                                            :
                                        </td>
                                        <td>
                                            ${req.user.userName}
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            Customer Email
                                        </td>
                                        <td>
                                            :
                                        </td>
                                        <td>
                                            ${req.user.emailId}
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            Customer Mobile.no
                                        </td>
                                        <td>
                                            :
                                        </td>
                                        <td>
                                            ${req.user.mobileNo}
                                        </td>
                                    </tr>
                                </table>
                            </td>
                        </tr>
                        <tr>
                            <td style="padding: 20px; text-align: center;">
                                <a href=${process.env.SERVER_URL}
                                    style="display: inline-block; background-color: #66cc33; color: #ffffff; padding: 10px 20px; text-decoration: none; border-radius: 5px;">Visit
                                    Now</a>
                            </td>
                        </tr>
                        <tr>
                            <td
                                style="background-color: #3d5d36; text-align: center; padding: 6px; color: #ffffff; font-size: 14px;">
                                &copy; 2023 FruitFul Technologies. All rights reserved.
                            </td>
                        </tr>
                    </table>
                </div>
            `,
        });
        // console.log(info.messageId);
    }
    async function notifyUser() {
        mySellerData = await NewProduct.findOne({ ProductId: req.query.Pid });
        let info = await transporter.sendMail({
            from: `"Manager of Sales" <${process.env.EMAIL_ID}>`,
            to: req.user.emailId,
            subject: `✅ Your order for Product ${mySellerData.ProductName} is successful`,
            html: `<div style="display: flex; justify-content: center;">
                    <table style="max-width: 600px; background-color: rgb(244, 255, 241); margin: 0 auto;" width="100%" cellpadding="0"
                        cellspacing="0">
                        <tr>
                            <td style="background-color: #00a033; text-align: center;">
                                <img style="max-width: 100%;" src="https://i.ibb.co/rZnQ8Hn/agri1.jpg" alt="">
                            </td>
                        </tr>
                        <tr style="text-align: center;">
                            <td>
                                <img style="height: 50px;margin-top:30px;" src="https://s11.gifyu.com/images/croppedTitle.gif" draggable="false">
                            </td>
                        </tr>
                        <tr>
                            <td style="padding: 10px; text-align: center; font-size: 24px; font-weight: bold; color: #015f11;">
                                Thanks for ordering ${mySellerData.ProductName}.</td>
                        </tr>
                        <tr>
                            <td style="padding: 20px;padding-top: 0; text-align: justify; font-size: 16px; color: #3d5d36;">
                                <h4>Hello dear ${req.user.userName},</h4>
                                <p>Greetings of the day,
                                    <br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; We have received your order for ${mySellerData.ProductName}. Payment for the same is successful. 
                                    You will get the delivery details by the seller soon.
                                    <br>
                                    <br>
                                    With Regards,<br>
                                    Fruitful.
                                </p>
                            </td>
                        </tr>
                        
                        <tr>
                            <td style="background-color: #3d5d36; text-align: center; padding: 6px; color: #ffffff; font-size: 14px;">
                                &copy; 2023 FruitFul Technologies. All rights reserved.
                            </td>
                        </tr>
                    </table>
                </div>
                `,
        });
        // console.log(info.messageId);
    }
    reduceStock();
    insertPayment();
    notifySeller();
    notifyUser();

    res.render("message", { redirectTo: "/market", myMessage: "Your payment is successful." });
});

app.get("/cancel", isLoggedIn, function (req, res) {
    res.render("message", { redirectTo: "/market", myMessage: "Your payment is cancelled." });
});

app.get("/success-iot", isLoggedIn, function (req, res) {
    async function notifyAdmin() {
        let info = await transporter.sendMail({
            from: `"Manager of Sales" <${process.env.EMAIL_ID}>`,
            to: process.env.EMAIL_ID,
            subject: `${req.user.userName} is requesting for IOT kit.`,
            html: `<div style="display: flex; justify-content: center;">
                    <table style="max-width: 600px; background-color: rgb(244, 255, 241); margin: 0 auto;" width="100%" cellpadding="0"
                        cellspacing="0">
                        <tr>
                            <td style="background-color: #00a033; text-align: center;">
                                <img style="max-width: 100%;" src="https://i.ibb.co/rZnQ8Hn/agri1.jpg" alt="">
                            </td>
                        </tr>
                        <tr style="text-align: center;">
                            <td>
                                <img style="height: 50px;margin-top:30px;" src="https://s11.gifyu.com/images/croppedTitle.gif" draggable="false">
                            </td>
                        </tr>
                        <tr>
                            <td style="padding: 10px; text-align: center; font-size: 24px; font-weight: bold; color: #015f11;">
                                IOT kit request has been generated.</td>
                        </tr>
                        <tr>
                            <td style="padding: 20px;padding-top: 0; text-align: justify; font-size: 16px; color: #3d5d36;">
                                <h4>Hello dear admin,</h4>
                                <p>Greetings of the day,
                                    <br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; We received an order from ${req.user.userName} for
                                    IOT kit for his farm. He has paid an amount of total ₹${req.query.amount}/-. Please contact the customer and
                                    follow up the procedure as quickly as possible. Below are the details of the payment for your reference.
                                    <br>Payment for the same has been successfully processed.
                                </p>
                            </td>
                        </tr>
                        <tr>
                            <td style="padding: 20px;padding-top: 0; text-align: justify; font-size: 16px; color: #3d5d36;">
                                Here are the details for the order.
                                <table style="margin: 10px; margin-left: 20px;">
                                    <tr>
                                        <td>
                                            Customer Name
                                        </td>
                                        <td>
                                            :
                                        </td>
                                        <td>
                                            ${req.user.userName}
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            Customer Mobile.no
                                        </td>
                                        <td>
                                            :
                                        </td>
                                        <td>
                                            ${req.user.mobileNo}
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            Amount paid
                                        </td>
                                        <td>
                                            :
                                        </td>
                                        <td>
                                            ₹${req.query.amount}/-
                                        </td>
                                    </tr>
                                </table>
                            </td>
                        </tr>
                        <tr>
                            <td style="background-color: #3d5d36; text-align: center; padding: 6px; color: #ffffff; font-size: 14px;">
                                &copy; 2023 FruitFul Technologies. All rights reserved.
                            </td>
                        </tr>
                    </table>
                </div>
                `,
        });
        // console.log(info.messageId);
    }
    async function notifyUser() {
        let info = await transporter.sendMail({
            from: `"Manager of Sales" <${process.env.EMAIL_ID}>`,
            to: req.user.emailId,
            subject: `✅Your request for IOT kit is successful.`,
            html: `<div style="display: flex; justify-content: center;">
                    <table style="max-width: 600px; background-color: rgb(244, 255, 241); margin: 0 auto;" width="100%" cellpadding="0"
                        cellspacing="0">
                        <tr>
                            <td style="background-color: #00a033; text-align: center;">
                                <img style="max-width: 100%;" src="https://i.ibb.co/rZnQ8Hn/agri1.jpg" alt="">
                            </td>
                        </tr>
                        <tr style="text-align: center;">
                            <td>
                                <img style="height: 50px;margin-top:30px;" src="https://s11.gifyu.com/images/croppedTitle.gif" draggable="false">
                            </td>
                        </tr>
                        <tr>
                            <td style="padding: 10px; text-align: center; font-size: 24px; font-weight: bold; color: #015f11;">
                                Thanks for your IOT-kit order.</td>
                        </tr>
                        <tr>
                            <td style="padding: 20px;padding-top: 0; text-align: justify; font-size: 16px; color: #3d5d36;">
                                <h4>Hello dear ${req.user.userName},</h4>
                                <p>Greetings of the day,
                                    <br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; We have received your order for
                                    IOT kit. Payment for ₹${req.query.amount}/- is successful. Our execution team will contact you soon.
                                    <br>
                                    <br>
                                    With Regards,<br>
                                    Fruitful.
                                </p>
                            </td>
                        </tr>
                        
                        <tr>
                            <td style="background-color: #3d5d36; text-align: center; padding: 6px; color: #ffffff; font-size: 14px;">
                                &copy; 2023 FruitFul Technologies. All rights reserved.
                            </td>
                        </tr>
                    </table>
                </div>
                `,
        });
        // console.log(info.messageId);
    }
    notifyAdmin();
    notifyUser();
    res.render("message", { redirectTo: "/market", myMessage: "Your payment is successful and our admin will contact you soon." });
});

app.get("/ordersReceived", isLoggedIn, function (req, res) {
    let receivedOrders = "";
    async function getUserOrders() {
        let pictures = ["Products", "Products1", "Products2"];
        receivedOrders = await Payment.find({ SellerMobile: req.user.mobileNo, SellerNotifiedStatus: "No" }).sort({ _id: -1 });
        // res.send(receivedOrders);
        // console.log(receivedOrders);
        res.render("receivedOrders", {
            name: req.user.userName,
            productList: receivedOrders,
            myPictures: pictures
        });
    }
    getUserOrders();
});

app.get("/myOrders", isLoggedIn, function (req, res) {
    let myOrders = "";
    async function getMyOrders() {
        let pictures = ["Products", "Products1", "Products2"];
        myOrders = await Payment.find({ BuyerMobile: req.user.mobileNo }).sort({ _id: -1 });
        // res.send(myOrders);
        // console.log(myOrders);
        res.render("myOrders", {
            name: req.user.userName,
            productList: myOrders,
            myPictures: pictures
        });
    }
    getMyOrders();
});

app.get("/admin/:passKeyHash", isLoggedIn, function (req, res) {
    // console.log(parseInt(process.env.ADMIN_ID));
    // console.log((req.user.usersId));
    // console.log(((process.env.ADMIN_EMAIL)));
    // console.log((req.user.emailId));

    if (parseInt(process.env.ADMIN_ID) == (req.user.usersId) && (process.env.ADMIN_EMAIL) == (req.user.emailId)) {
        // console.log(md5((process.env.ADMIN_PLAIN)));
        // console.log(req.params.passKeyHash);
        if (req.params.passKeyHash == adminPassKeyHash) {
            // console.log(req.params.passKeyHash);
            // console.log("Admin accessed - Now");
            res.render("adminMainPage", { passKeyHash: adminPassKeyHash });
        }
        else {
            console.log(`Admin used password = ${req.params.passKeyHash} and failed to login`);
            res.send(`Wrong Passkey ${req.params.passKeyHash}`);
        }
    }
    else {
        async function notifyAdmin() {
            let info = await transporter.sendMail({
                from: `"Manager of Sales" <${process.env.EMAIL_ID}>`,
                to: process.env.EMAIL_ID,
                subject: `🛑🛑 Someone trying to get into the Admin portal.`,
                html: `
                        <div style="display: flex; justify-content: center;">
                            <table style="max-width: 600px; background-color: rgb(244, 255, 241); margin: 0 auto;" width="100%"
                                cellpadding="0" cellspacing="0">
                                <tr style="text-align: center;">
                                    <td>
                                        <img style="height: 60px; border-radius: 12px; margin-top: 4px;" src="https://s12.gifyu.com/images/croppedAlert.gif">
                                    </td>
                                </tr>
                                <tr>
                                    <td style="background-color: #00ff08; text-align: center;">
                                        <img style="max-width: 100%;" src="https://i.ibb.co/rZnQ8Hn/agri1.jpg" alt="">
                                    </td>
                                </tr>
                                <tr>
                                    <td style="padding: 20px; text-align: center; font-size: 24px; font-weight: bold;background-color: red; color: #ffffff;">
                                        Someone tried accessing Admin portal</td>
                                </tr>
                                <tr>
                                    <td style="padding: 20px; text-align: justify; font-size: 16px; color: #3d5d36;">
                                        <h4>Hello dear Admin,</h4>
                                        <p>Greetings of the day,
                                            <br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; There is an alert for you. An Intruder tried accessing accessing admin portal.
                                            Credentials used are:
                                        <table style="margin-left: 20px;">
                                            <tr>
                                                <td>
                                                    Hash Key used
                                                </td>
                                                <td>
                                                    :
                                                </td>
                                                <td>
                                                    ${req.params.passKeyHash}
                                                </td>
                                            </tr>
                                            <tr>
                                                <td>
                                                    Name of user
                                                </td>
                                                <td>
                                                    :
                                                </td>
                                                <td>
                                                    ${req.user.userName}
                                                </td>
                                            </tr>
                                            <tr>
                                                <td>
                                                    User id
                                                </td>
                                                <td>
                                                    :
                                                </td>
                                                <td>
                                                    ${(req.user.usersId)}
                                                </td>
                                            </tr>
                                        </table>
                                        </p>
                                    </td>
                                </tr>
                                <tr>
                                    <td style="padding: 20px; text-align: center;">
                                        <a href=${process.env.SERVER_URL}
                                            style="display: inline-block; background-color: red; color: #ffffff; padding: 10px 20px; text-decoration: none; border-radius: 5px;">Visit
                                            Now</a>
                                    </td>
                                </tr>
                                <tr>
                                    <td
                                        style="background-color: #3d5d36; text-align: center; padding: 6px; color: #ffffff; font-size: 14px;">
                                        &copy; 2023 FruitFul Technologies. All rights reserved.
                                    </td>
                                </tr>
                            </table>
                        </div>
                        `,
            });
            // console.log(info.messageId);
        }
        notifyAdmin();
        // console.log(`Intruder trying to access admin portal with \n\tkeyHash used = ${req.params.passKeyHash} \n\tName = ${req.user.userName} \n\tUser id = ${(req.user.usersId)}`);
        res.send(`Cannot GET /admin/:${req.params.passKeyHash}`);
    }
});

app.get(`/admin/${adminPassKeyHash}/SeeUserData`, isLoggedIn, isAdmin, function (req, res) {
    async function sendAllUsers() {
        let data = await User.find({});
        res.render("allUserData", { type: "All our users", userData: data });
    }
    sendAllUsers();
});

app.get(`/admin/${adminPassKeyHash}/LinkIOT`, isLoggedIn, isAdmin, function (req, res) {
    res.render("linkIOT", { passKeyHash: adminPassKeyHash });
});

app.get(`/admin/${adminPassKeyHash}/updateIotCosts`, isLoggedIn, isAdmin, function (req, res) {
    async function getOldData() {
        let data = await costOfComponent.findOne({});
        // console.log(data);
        res.render("updateIotCosts", { passKeyHash: adminPassKeyHash, oldData: data });
    }
    getOldData();
});

app.get(`/admin/${adminPassKeyHash}/UnBlockUser`, isLoggedIn, isAdmin, function (req, res) {
    res.render("blockUnBlockUser", { work: "Un Block", nextRoute: "UnBlockUser", passKeyHash: adminPassKeyHash });
});

app.get(`/admin/${adminPassKeyHash}/BlockUser`, isLoggedIn, isAdmin, function (req, res) {
    res.render("blockUnBlockUser", { work: "Block", nextRoute: "BlockUser", passKeyHash: adminPassKeyHash });
});

app.get(`/admin/${adminPassKeyHash}/BlockedUsers`, isLoggedIn, isAdmin, function (req, res) {
    async function sendBlockedUsers() {
        let data = await User.find({ status: "Blocked" });
        res.render("allUserData", { type: "Blocked Users", userData: data });
    }
    sendBlockedUsers();
});

app.get("/i-Smart", isLoggedIn, function (req, res) {
    res.render("i-smart", { name: req.user.userName });
});

app.get("/weatherData", isLoggedIn, function (req, res) {
    res.render("weatherForm", {});
});

app.get("/caluclatePrice", isLoggedIn, function (req, res) {
    async function getServicePrices() {
        let data = await costOfComponent.findOne({});
        // console.log(data);
        res.render("iotCostCaluclator", {
            name: req.user.userName,
            costList: data
        });
    }
    getServicePrices();

});

app.get("/CropAdvisory", isLoggedIn, function (req, res) {
    let location = req.user.Location;
    // console.log(location);
    res.render("CropAdvisoryForm", { userLocation: location });
});

app.get("/AnalyzeSensorData", isLoggedIn, function (req, res) {
    async function getDeviceData() {
        let trendLine = await Device.find({ userId: req.user.usersId, deviceType: "Trendline" });
        // console.log(devicesInfo);
        res.render("analyzeSensorData", { trendlineDevices: trendLine });
    }
    getDeviceData();
});

app.get("/BulkRequests", isLoggedIn, function (req, res) {
    async function processBulkOrders() {
        let pictures = ["Products", "Products1", "Products2"];
        let finalProductList = await BulkOrder.find({ SellerId: req.user.usersId });
        finalProductList = JSON.stringify(finalProductList);
        finalProductList = JSON.parse(finalProductList);
        for (let i = 0; i < finalProductList.length; i++) {
            if (finalProductList[i].Status == "Pending") {
                let productDetails = await NewProduct.findOne({ ProductId: finalProductList[i].ProductId });
                let buyerDetails = await User.findOne({ usersId: finalProductList[i].BuyerId });
                finalProductList[i]["MarketQuantity"] = productDetails.Quantity;
                finalProductList[i]["ProductName"] = productDetails.ProductName;
                finalProductList[i]["OtherName"] = productDetails.OtherName;
                finalProductList[i]["Variety"] = productDetails.Variety;
                finalProductList[i]["BuyerName"] = buyerDetails.userName;
                finalProductList[i]["BuyerEmail"] = buyerDetails.emailId;
                finalProductList[i]["BuyerMobile"] = buyerDetails.mobileNo;
            }
        }
        // console.log(finalProductList);
        res.render("bulkRequests", { name: req.user.userName, productList: finalProductList, myPictures: pictures });
    }
    processBulkOrders();
});

app.get("/ReportIssue", isLoggedIn, function (req, res) {
    // console.log(req.query);
    async function checkPrevReports() {
        let prevReports = await FraudReport.find({ ReporterID: req.user.usersId });
        if (prevReports.length <= 10) {
            res.render("issueReportForm", { ItemId: req.query.ItemId });
        }
        else {
            res.render("message", { redirectTo: "/market", myMessage: "Sorry, your limit exceeded. Directly email us your issue." });
        }
    }
    checkPrevReports();

})
//Get routes end

//Post routes start
app.post("/userRegister", function (req, res) {
    // console.log(req.body);
    async function verifyEmail() {
        let presence = await User.exists({ emailId: req.body.emailId });
        if (!presence) {
            usersId = usersId + 1;
            bcrypt.genSalt(10, function (err, salt) {
                if (err) return next(err);
                bcrypt.hash(req.body.password, salt, function (err, hash) {
                    if (err) return next(err);
                    var newEntry = new User({
                        usersId: usersId, userName: req.body.userName, age: req.body.age, status: "Active", Location: req.body.Location, Occupation: req.body.Location, Occupation: req.body.Occupation, mobileNo: req.body.mobileNo, emailId: req.body.emailId, password: hash
                    });
                    newEntry.save();
                    res.redirect("/login");
                })
            })
        }
        else {
            res.render("message", { redirectTo: "/market", myMessage: "User already exists" });
        }
    }
    verifyEmail();

});

app.post("/login", passport.authenticate("local", {
    successRedirect: "/market",
    failureRedirect: "/login?error=true"
}));

// app.post('/login', function (req, res, next) {
//     console.log(req.url);
//     passport.authenticate('local', function (err, user, info) {
//         console.log("authenticate");
//         console.log(err);
//         console.log(user);
//         console.log(info);
//     })(req, res, next);
// });


app.post("/newProduct", isLoggedIn, function (req, res) {
    // console.log(req.body);
    productId = productId + 1;
    var newEntry = new NewProduct({
        ProductId: productId, ProductName: req.body.CropName, Variety: req.body.Variety, Description: req.body.Description, cost: parseFloat(req.body.Cost), imageURL: "String", SellerName: req.user.userName, SellerAddress: req.body.Location, link: req.body.deviceUsed, Mobile: req.user.mobileNo, emailId: req.user.emailId, Quantity: req.body.Quantity, OtherName: req.body.OtherName
    });
    newEntry.save();
    // console.log(newEntry);

    res.render("message", { redirectTo: "/market", myMessage: "Product added successfully." });
});


app.post("/myProducts", isLoggedIn, function (req, res) {
    // console.log(req.body);
    // console.log(Object.keys(req.body));
    let deletingProducts = Object.keys(req.body);

    async function deleteGivenProducts() {
        for (var i = 0; i < deletingProducts.length; i++) {
            let doc = await NewProduct.deleteOne({ ProductId: parseInt(deletingProducts[i]) });
            // console.log(doc);
        }
    };
    deleteGivenProducts();
    res.render("message", { redirectTo: "/market", myMessage: "Successfully deleted from the market." });
});

app.post("/sendOtp", function (req, res) {
    // console.log(req.body.mobile);
    var userMobile = req.body.mobile;
    userMobile = "+91" + userMobile;
    // console.log(userMobile);
    async function checkMobileExists() {
        let presence = await User.exists({ mobileNo: req.body.mobile });
        if (!presence) {
            client.verify.v2.services('VA5a2288a3067c06fa0f1257c6eaa9223a')
                .verifications
                .create({ to: userMobile, channel: 'sms' })
                .then(verification => {
                    // console.log(verification.status)
                    res.render("verifyMobile", { error: req.query.error, mobile: req.body.mobile });
                });
        }
        else {
            res.render("message", { redirectTo: "/market", myMessage: "User already exists" });
        }
    }
    checkMobileExists();
});

app.post("/verifyOtp", function (req, res) {
    // console.log(req.body);
    var userMobile = req.body.mobile;
    var otp = req.body.otp;
    let verified = false;
    client.verify.v2.services('VA5a2288a3067c06fa0f1257c6eaa9223a')
        .verificationChecks
        .create({ to: "+91" + userMobile, code: otp })
        .then(verification_check => {
            // console.log(verification_check.status);
            if (verification_check.status == "approved") {
                res.render("register", { mobile: userMobile });
            }
            else {
                res.render("verifyMobile", { error: true, mobile: userMobile });
            }
        });
});


app.post("/create-checkout-session", isLoggedIn, async (req, res) => {
    async function checkMatch() {
        let mySellerData = await NewProduct.findOne({ ProductId: req.body.ProductId });
        if (mySellerData.Mobile == req.user.mobileNo) {
            // console.log(mySellerData.Mobile);
            // console.log(req.user.mobileNo);
            res.render("message", { redirectTo: "/market", myMessage: "😅 You are the seller of this product." });
        }
        else {
            try {
                let amount = parseInt(req.body.cost);
                let quantity = req.body.quantity;
                const session = await stripe.checkout.sessions.create({
                    payment_method_types: ["card"],
                    mode: "payment",
                    customer_email: req.body.emailId,
                    line_items: [{
                        price_data: {
                            currency: "inr",
                            product_data: {
                                name: req.body.ProductName + ` (${req.body.quantity} Kg)`,
                            },
                            unit_amount: amount * 100 * quantity,
                        },
                        quantity: 1,
                    }],
                    success_url: `${process.env.SERVER_URL}/success?Pid=${req.body.ProductId}&quant=${req.body.quantity}`,
                    cancel_url: `${process.env.SERVER_URL}/cancel`,
                })
                // console.log(session);
                res.redirect(session.url);
            } catch (e) {
                res.status(500).json({ error: e.message })
            }
        }
    }
    checkMatch();
});

app.get("/bulkRequestForm/:pId", isLoggedIn, function (req, res) {
    async function execute() {
        let productData = await NewProduct.findOne({ ProductId: req.params.pId });
        let sellerData = await User.findOne({ mobileNo: productData.Mobile });
        // console.log(sellerData);
        res.render("bulkOrderForm", { productData: productData, sellerData: sellerData });
    }
    execute();
});

app.post("/ordersReceived", isLoggedIn, function (req, res) {
    let completedProducts = Object.keys(req.body);
    // console.log(Object.keys(req.body));

    async function updateReceivedOrders() {
        for (var i = 0; i < completedProducts.length; i++) {
            let doc = await Payment.updateOne({ _id: completedProducts[i] }, { SellerNotifiedStatus: "Yes" });
            // console.log(doc);
            // console.log();
        }
        res.render("message", { redirectTo: "/market", myMessage: "Marked as completed. 😌" });
    };
    updateReceivedOrders();
});

app.post(`/admin/${adminPassKeyHash}/LinkIOT`, isLoggedIn, isAdmin, function (req, res) {
    // console.log(req.body);
    async function linkExecuter() {
        let presence = await User.exists({ usersId: req.body.userId });
        let userInfo = await User.findOne({ usersId: req.body.userId });
        if (presence) {
            var newDevice = new Device({
                userId: req.body.userId,
                deviceName: req.body.deviceName,
                Location: req.body.Location,
                deviceType: req.body.deviceType,
                Link: req.body.Link
            });
            newDevice.save();
            async function notifyCustomer() {
                let info = await transporter.sendMail({
                    from: `"Manager of Sales" <${process.env.EMAIL_ID}>`,
                    to: userInfo.emailId,
                    subject: `✅ New ${req.body.deviceType} Device added to your account.`,
                    html: `
                        <div style="display: flex; justify-content: center;">
                            <table style="max-width: 600px; background-color: rgb(244, 255, 241); margin: 0 auto;" width="100%" cellpadding="0" cellspacing="0">
                                <tr>
                                    <td style="background-color: #00a033; text-align: center;">
                                        <img style="max-width: 100%;" src="https://i.ibb.co/rZnQ8Hn/agri1.jpg" alt="">
                                    </td>
                                </tr>
                                <tr style="text-align: center;">
                                    <td>
                                        <img style="height: 50px;margin-top:30px;" src="https://s11.gifyu.com/images/croppedTitle.gif">
                                    </td>
                                </tr>
                                <tr>
                                    <td style="padding: 20px; text-align: center; font-size: 24px; font-weight: bold; color: #015f11;">
                                        A new IOT device is added to your account</td>
                                </tr>
                                <tr>
                                    <td style="padding: 20px; text-align: justify; font-size: 16px; color: #3d5d36;">
                                        <h4>Hello dear ${userInfo.userName},</h4>
                                        <p>Greetings of the day,
                                            <br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; This email is to inform you that a new IOT device is linked
                                            to your account. You can access it in
                                            our protal also from now on. Please visit the portal for more details.
                                        </p>
                                    </td>
                                </tr>
                                <tr>
                                    <td style="padding: 20px; text-align: center;">
                                        <a href=${process.env.SERVER_URL}
                                            style="display: inline-block; background-color: #66cc33; color: #ffffff; padding: 10px 20px; text-decoration: none; border-radius: 5px;">Visit
                                            Now</a>
                                    </td>
                                </tr>
                                <tr>
                                    <td style="background-color: #3d5d36; text-align: center; padding: 6px; color: #ffffff; font-size: 14px;">
                                        &copy; 2023 FruitFul Technologies. All rights reserved.
                                    </td>
                                </tr>
                            </table>
                        </div>
                        `,
                });
                // console.log(info.messageId);
            }
            notifyCustomer();
            res.render("message", { redirectTo: `/admin/${adminPassKeyHash}/`, myMessage: "IOT device Linked" });

        }
        else {
            res.render("message", { redirectTo: `/admin/${adminPassKeyHash}/`, myMessage: "User id is not matching with any user." });
        }
    }
    linkExecuter();
});

app.post(`/admin/${adminPassKeyHash}/updateIotCosts`, isLoggedIn, isAdmin, function (req, res) {
    async function updateCosts() {
        await costOfComponent.deleteMany({});
        var costEntry = new costOfComponent({
            esp32: req.body.esp32,
            esp8266: req.body.esp8266,
            moisture: req.body.moisture,
            temperature: req.body.temperature,
            solar: req.body.solar,
            jumpers: req.body.jumpers,
            serviceCharge: req.body.serviceCharge
        });
        costEntry.save();
        // console.log(req.body);
        res.render("message", { redirectTo: `/admin/${adminPassKeyHash}/`, myMessage: "IOT components prices updated successfully." });
    }
    updateCosts();
});

app.post(`/admin/${adminPassKeyHash}/BlockUser`, isLoggedIn, isAdmin, function (req, res) {
    // console.log(req.body.userId);
    async function blockGivenUser() {
        let existance = await User.exists({ usersId: req.body.userId });
        let user = await User.findOne({ usersId: req.body.userId });
        // console.log(user);
        if (!existance) {
            res.render("message", { redirectTo: `/admin/${adminPassKeyHash}/`, myMessage: "User does not exist." });
        }
        else if (user.status == "Blocked") {
            res.render("message", { redirectTo: `/admin/${adminPassKeyHash}/`, myMessage: "User is already blocked." });
        }
        else if (user.usersId == req.user.usersId) {
            res.render("message", { redirectTo: `/admin/${adminPassKeyHash}/`, myMessage: "😁 You cannot block yourself." });
        }
        else {
            await User.updateOne({ usersId: req.body.userId }, { status: "Blocked" });
            res.render("message", { redirectTo: `/admin/${adminPassKeyHash}/`, myMessage: "User blocked successfully." });
        }
    }

    blockGivenUser();
});

app.post(`/admin/${adminPassKeyHash}/UnBlockUser`, isLoggedIn, isAdmin, function (req, res) {
    // console.log(req.body.userId);
    async function unBlockGivenUser() {
        let existance = await User.exists({ usersId: req.body.userId });
        let user = await User.findOne({ usersId: req.body.userId });
        // console.log(user);
        if (!existance) {
            res.render("message", { redirectTo: `/admin/${adminPassKeyHash}/`, myMessage: "User does not exist." });
        }
        else if (user.status == "Active") {
            res.render("message", { redirectTo: `/admin/${adminPassKeyHash}/`, myMessage: "User is already active." });
        }
        else {
            await User.updateOne({ usersId: req.body.userId }, { status: "Active" });
            res.render("message", { redirectTo: `/admin/${adminPassKeyHash}/`, myMessage: "Unblocked user successfully." });
        }
    }

    unBlockGivenUser();
});

app.post("/weatherData", isLoggedIn, function (req, res) {
    needle.get(`api.openweathermap.org/data/2.5/weather?q=${req.body.city}&units=metric&APPID=${process.env.WEATHER_API_KEY}`, function (error, response) {
        if (!error && response.statusCode == 200) {
            // console.log(response.body);
            res.render("weatherStatus", { name: req.user.userName, myWeatherData: response.body });
        }
        else
            res.render("message", { redirectTo: `/i-smart`, myMessage: "Sorry, City not found." });
    });
    // console.log(req.body.city);
});


app.post("/checkout-for-iot", isLoggedIn, async (req, res) => {
    async function startPayment() {
        try {
            let amount = parseInt(req.body.cost);
            const session = await stripe.checkout.sessions.create({
                payment_method_types: ["card"],
                mode: "payment",
                line_items: [{
                    price_data: {
                        currency: "inr",
                        product_data: {
                            name: "IOT kit for Agriculture",
                        },
                        unit_amount: amount * 100,
                    },
                    quantity: 1,
                }],
                success_url: `${process.env.SERVER_URL}/success-iot?amount=${amount}`,
                cancel_url: `${process.env.SERVER_URL}/cancel`,
            })
            // console.log(session);
            res.redirect(session.url);
        } catch (e) {
            res.status(500).json({ error: e.message })
        }
    }
    startPayment();
});

app.post("/CropAdvisory", isLoggedIn, function (req, res) {

    //Standardising the user input
    let location = req.body.city;
    location = location.toLowerCase();
    location = location.charAt(0).toUpperCase() + location.slice(1);
    // console.log(location);

    // Ask OpenAI for the suggestion
    async function getCompletion() {
        const response = await openai.createCompletion({
            model: "text-davinci-003",
            prompt: `Write an essay about 5 profitable crops that I can grow for next season if I'm Staying in ${location}.  60 words only.`,
            max_tokens: 250,
            temperature: 0,
        });

        var myNewCropAdvice = new CropAdvice({
            location: location,
            Advice: response.data.choices[0].text
        });
        myNewCropAdvice.save();

        // console.log(response.data.choices[0].text);
        res.render("CropAdvisory", {
            crops: response.data.choices[0].text,
            name: req.user.userName
        });
    }

    // Check Whether we already have data for that location
    async function checkCachedData() {
        let advice = await CropAdvice.findOne({ location: location });
        if (advice == null) {
            getCompletion();
        }
        else {
            // console.log(advice);
            res.render("CropAdvisory", {
                crops: advice.Advice,
                name: req.user.userName
            });
        }
    }
    checkCachedData();

});

app.post("/analyzeSensorData", isLoggedIn, function (req, res) {
    async function executeMyCode() {
        await Device.deleteMany({ userId: req.user.usersId, deviceType: "Trendline" });
        for (var i = 0; i < req.body.links.length; i++) {
            var newDevice = new Device({
                userId: req.user.usersId,
                deviceName: req.body.deviceNames[i],
                Location: req.user.Location,
                deviceType: "Trendline",
                Link: req.body.links[i]
            });
            newDevice.save();
        }
        res.render("message", { redirectTo: "/IOT", myMessage: "Your configuration updated successfully." });
    }
    executeMyCode();

    // console.log(req.body.links[0]);
});

app.post("/sendBulkRequest", isLoggedIn, function (req, res) {
    // console.log(req.body);
    async function notifySeller() {
        let productData = await NewProduct.findOne({ ProductId: req.body.ProductId });
        let mySellerData = await User.findOne({ mobileNo: productData.Mobile });
        let info = await transporter.sendMail({
            from: `"Manager of Sales" <${process.env.EMAIL_ID}>`,
            to: mySellerData.emailId,
            subject: `✅ You received a BULK order for Product with Product Id : ${req.body.ProductId}`,
            html: `
                <div style="display: flex; justify-content: center;">
                    <table style="max-width: 600px; background-color: rgb(244, 255, 241); margin: 0 auto;" width="100%"
                        cellpadding="0" cellspacing="0">
                        <tr>
                            <td style="background-color: #00a033; text-align: center;">
                                <img style="max-width: 100%;" src="https://i.ibb.co/rZnQ8Hn/agri1.jpg" alt="">
                            </td>
                        </tr>
                        <tr style="text-align: center;">
                            <td>
                                <img style="height: 50px;margin-top:30px;" src="https://s11.gifyu.com/images/croppedTitle.gif">
                            </td>
                        </tr>
                        <tr>
                            <td style="padding: 20px; text-align: center; font-size: 24px; font-weight: bold; color: #015f11;">
                                You received a bulk order for your product.</td>
                        </tr>
                        <tr>
                            <td style="padding: 20px; text-align: justify; font-size: 16px; color: #3d5d36;">
                                <h4>Hello dear ${mySellerData.userName},</h4>
                                <p>Greetings of the day,
                                    <br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; This email is to inform you that you have received
                                    a bulk order for ${productData.ProductName}(s) at ₹${req.body.BidAmount}/- for ${req.body.Quantity} KGs.You can visit our Fruitful app to know more.
                                </p>
                            </td>
                        </tr>
                        <tr>
                            <td style="padding: 20px; text-align: justify; font-size: 16px; color: #3d5d36;">
                                Here are the details for your order. To know more please visit our portal.
                                <table style="margin: 10px; margin-left: 20px;">
                                    <tr>
                                        <td>
                                            Customer Name
                                        </td>
                                        <td>
                                            :
                                        </td>
                                        <td>
                                            ${req.user.userName}
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            Customer Email
                                        </td>
                                        <td>
                                            :
                                        </td>
                                        <td>
                                            ${req.user.emailId}
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            Customer Mobile.no
                                        </td>
                                        <td>
                                            :
                                        </td>
                                        <td>
                                            ${req.user.mobileNo}
                                        </td>
                                    </tr>
                                </table>
                            </td>
                        </tr>
                        <tr>
                            <td style="padding: 20px; text-align: center;">
                                <a href=${process.env.SERVER_URL}
                                    style="display: inline-block; background-color: #66cc33; color: #ffffff; padding: 10px 20px; text-decoration: none; border-radius: 5px;">Visit
                                    Now</a>
                            </td>
                        </tr>
                        <tr>
                            <td
                                style="background-color: #3d5d36; text-align: center; padding: 6px; color: #ffffff; font-size: 14px;">
                                &copy; 2023 FruitFul Technologies. All rights reserved.
                            </td>
                        </tr>
                    </table>
                </div>
            `,
        });
    }


    async function getDetails(req) {
        let productData = await NewProduct.findOne({ ProductId: req.body.ProductId });
        let sellerData = await User.findOne({ mobileNo: productData.Mobile });
        // console.log("Req Data", req.body);
        if (sellerData.usersId == req.user.usersId) {
            res.render("message", { redirectTo: "/market", myMessage: "😅 You are the seller of this product." });
        }
        else {
            bulkOrderId += 1;
            var newBulkOrder = new BulkOrder({
                OrderId: bulkOrderId,
                SellerId: sellerData.usersId,
                BuyerId: req.user.usersId,
                Status: "Pending",
                ProductId: productData.ProductId,
                BidAmount: req.body.BidAmount,
                MarketPrice: productData.cost,
                Quantity: req.body.Quantity
            })
            newBulkOrder.save();
            notifySeller();
            res.render("message", { redirectTo: "/market", myMessage: "Your bulk order request is successfully sent to seller." });
        }
    }
    getDetails(req);
});
app.post("/BulkRequests", isLoggedIn, function (req, res) {
    // console.log(req.body);
    // console.log(Object.keys(req.body));
    let approvingProducts = Object.keys(req.body);

    async function approveGivenProducts() {
        for (var i = 0; i < approvingProducts.length; i++) {
            await BulkOrder.updateOne({ OrderId: parseInt(approvingProducts[i]) }, { Status: "Approved" });
        }
    };
    approveGivenProducts();
    res.render("message", { redirectTo: "/BulkRequests", myMessage: "Successfully Approved the selected requests." });
});

app.post("/ClearBulkRequests", isLoggedIn, function (req, res) {
    async function deletePendingRequests() {
        await BulkOrder.deleteMany({ SellerId: req.user.usersId, Status: "Pending" });
        res.render("message", { redirectTo: "/BulkRequests", myMessage: "Cleared all pending requests." });
    }
    deletePendingRequests();
});

app.post("/reportIssue", isLoggedIn, function (req, res) {
    async function notifyAdmin() {
        let info = await transporter.sendMail({
            from: `"Manager of Sales" <${process.env.EMAIL_ID}>`,
            to: process.env.EMAIL_ID,
            subject: `New Issue Report by ${req.user.userName}`,
            html: `
                        <div style="display: flex; justify-content: center;">
                            <table style="max-width: 600px; background-color: rgb(244, 255, 241); margin: 0 auto;" width="100%"
                                cellpadding="0" cellspacing="0">
                                <tr>
                                    <td style="background-color: #00ff08; text-align: center;">
                                        <img style="max-width: 100%;" src="https://i.ibb.co/rZnQ8Hn/agri1.jpg" alt="">
                                    </td>
                                </tr>
                                <tr>
                                    <td style="padding: 20px; text-align: justify; font-size: 16px; color: #3d5d36;">
                                        <h4>Hello dear Admin,</h4>
                                        <p>Greetings of the day, ${req.user.userName} is having an issue with item with id ${req.query.ItemId}. 
                                        Kindly verify that item, its seller details and his activity in the website. <strong>Resolve The Issue</strong>
                                        as soon as possible and acknowledge the same to ${req.user.userName}.
                                            <br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
                                        <table style="margin-left: 20px;">
                                            <tr>
                                                <td>
                                                    Item Id
                                                </td>
                                                <td>
                                                    :
                                                </td>
                                                <td>
                                                    ${req.query.ItemId}
                                                </td>
                                            </tr>
                                            <tr>
                                                <td>
                                                    Reporter Id
                                                </td>
                                                <td>
                                                    :
                                                </td>
                                                <td>
                                                    ${req.user.usersId}
                                                </td>
                                            </tr>
                                            <tr>
                                                <td>
                                                    Description
                                                </td>
                                                <td>
                                                    :
                                                </td>
                                                <td>
                                                    ${req.body.Description}
                                                </td>
                                            </tr>
                                        </table>
                                        </p>
                                    </td>
                                </tr>
                                <tr>
                                    <td style="padding: 20px; text-align: center;">
                                        <a href=${process.env.SERVER_URL}
                                            style="display: inline-block; background-color: #66cc33; color: #ffffff; padding: 10px 20px; text-decoration: none; border-radius: 5px;">Visit
                                            Now</a>
                                    </td>
                                </tr>
                                <tr>
                                    <td
                                        style="background-color: #3d5d36; text-align: center; padding: 6px; color: #ffffff; font-size: 14px;">
                                        &copy; 2023 FruitFul Technologies. All rights reserved.
                                    </td>
                                </tr>
                                
                            </table>
                        </div>
                        `,
        });
        // console.log(info.messageId);
    }
    var myFraudReport = new FraudReport({
        ItemId: req.query.ItemId,
        ReporterID: req.user.usersId,
        Description: req.body.Description,
        Status: "Open"
    });
    // console.log(req.query);
    // console.log(req.body);
    myFraudReport.save();
    notifyAdmin();
    res.render("message", { redirectTo: "/market", myMessage: "Ticket has been Raised. Thank you" });
});
//Post routes end

// App listening to port 80 or port specified in ENV variables
app.listen(PORT, function () {
    console.log("App is running on port : " + PORT);
});