Bootstrap Snippet Booking Api using HTML CSS Javascript

1
2
3
4
5
6
7
8
9
10
11
<link href="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
<script src="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/js/bootstrap.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<!------ Include the above in your HEAD tag ---------->
<div class="container">
    <div class="row">
        <h2>Booking</h2>
    </div>
</div>
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
const result = await db.orders.aggregate([
    {
        $lookup: {
            from: "customers",
            let: { customerId: "$customerId" }, // Define a variable to use in the pipeline
            pipeline: [
                {
                    $match: {
                        $expr: { $eq: ["$_id", "$$customerId"] } // Use the variable defined in $let
                    }
                },
                {
                    $match: { country: "USA" } // Additional filter based on country
                }
            ],
            as: "customerDetails"
        }
    },
    {
        $unwind: {
            path: "$customerDetails",
            preserveNullAndEmptyArrays: true // Preserve orders with no matching customer
        }
    }
]);
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
app.get("/getbooking", auth, async (req, res) => {
    try {
        let user_id = req.user.data._id;
        console.log(user_id, "iddd");
        // let result = await Booking.find({userId: new mongoose.Types.ObjectId(user_id)});
     let result = await Booking.aggregate([
            {
                $match: { userId: new mongoose.Types.ObjectId(user_id) }, // Match bookings for the specific user
            },
            {
                $lookup: {
                    from: "users", // Join with the "users" collection
                    foreignField: "_id", // User collection's _id field
                    localField: "userId", // Booking collection's userId field
                    as: "userDetails", // The resulting array containing user details
                },
            },
            {
                $unwind:{ 
                    path:"$userDetails",
                    preserveNullAndEmptyArrays: true
                }, // Convert the userDetails array to a single object
            },
            {
                $group: {
                    _id: "$userId", // Group by userId
                    user: { $first: "$userDetails" }, // Include user details
                    bookings: { $push: { _id: "$_id", userId: "$userId" , name: "$name" } }, // Group booking fields
                },
            },
            {
                $project:{
                    _id: 0,
                    user: '$user', // Include user details
                    booking:'$bookings',
                    bookingCount: {$size: '$bookings'}
                }
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

"Booking Api"
Bootstrap 4.1.1 Snippet by Arjunverma

Related: See More

Questions / Comments:

"Booking Api" Bootstrap 4.1.1 Snippet by Arjunverma

Related: See More

Questions / Comments:

"Booking Api"
Bootstrap 4.1.1 Snippet by Arjunverma