======================= Submited QC Order, ====================
================================================================
 ~/eSmartFactory/qcOrderMultiplePatameter/list/PO-S
  => db.EvolveQCOrder.aggregate([
            {
                "$lookup": {
                    "from": "EvolveItem",
                    "localField": "EvolveItem_ID",
                    "foreignField": "_id",
                    "as": "EvolveItem_ID",

                }
            },
            {
                $unwind: {
                    path: "$EvolveItem_ID",
                    preserveNullAndEmptyArrays: true
                }
            },

            {
                "$lookup": {
                    "from": "EvolveSupplier",
                    "localField": "EvolveSupplier_ID",
                    "foreignField": "_id",
                    "as": "EvolveSupplier_ID",

                }
            },
            {
                $unwind: {
                    path: "$EvolveSupplier_ID",
                    preserveNullAndEmptyArrays: true
                }
            },

            {
                "$lookup": {
                    "from": "EvolveQCTemplete",
                    "localField": "EvolveQCTemplete_ID",
                    "foreignField": "_id",
                    "as": "EvolveQCTemplete_ID",

                }
            },
            {
                $unwind: {
                    path: "$EvolveQCTemplete_ID",
                    preserveNullAndEmptyArrays: true
                }
            },
            { $unwind: '$EvolveQCOrder_InventoryDetails' },
            {
                "$lookup": {
                    "from": "EvolveLocation",
                    "localField": "EvolveQCOrder_InventoryDetails.EvolveLocation_ID",
                    "foreignField": "_id",
                    "as": "EvolveQCOrder_InventoryDetails.EvolveLocation_ID",

                }
            },
            {
                $unwind: {
                    path: "$EvolveQCOrder_InventoryDetails.EvolveLocation_ID",
                    preserveNullAndEmptyArrays: true
                }
            },
            {
                "$lookup": {
                    "from": "EvolveLocation",
                    "localField": "EvolveQCOrder_InventoryDetails.EvolveRejectedQtyTransferredLocation_ID",
                    "foreignField": "_id",
                    "as": "EvolveQCOrder_InventoryDetails.EvolveRejectedQtyTransferredLocation_ID",

                }
            },
            {
                $unwind: {
                    path: "$EvolveQCOrder_InventoryDetails.EvolveRejectedQtyTransferredLocation_ID",
                    preserveNullAndEmptyArrays: true
                }
            },
            {
              $match:{"$and":[{"$or":[{"EvolveQCOrder_Type":{"$regex":"^PO$","$options":"i"}}]},{"$or":[{"EvolveQCOrder_DOAStatus":{"$regex":"^S$","$options":"i"}},{"EvolveQCOrder_DOAStatus": {"$regex":"^A$","$options":"i"}}]},{"$or":[{"EvolveQCOrder_Status":{"$regex":"^PERFORMED$","$options":"i"}}]},{"$or":[{"$expr":{"$eq":["$EvolveUnit_ID",{"$toObjectId":"62de23659b90475655e4df50"}]}}]}]}
            },
            {
                $group: {
                    _id: "$_id",
                    EvolveQCOrder_Number: { $first: "$EvolveQCOrder_Number" },
                    EvolveQCOrder_RefQcNumber: { $first: "$EvolveQCOrder_RefQcNumber" },
                    EvolveQCOrder_Type: { $first: "$EvolveQCOrder_Type" },
                    EvolvePoRecieve_InvoiceNumber: { $first: "$EvolvePoRecieve_InvoiceNumber" },
                    EvolveItem_ID: { $first: "$EvolveItem_ID" },
                    EvolveProduct_Line: { $first: "$EvolveProduct_Line" },
                    EvolveSupplier_ID: { $first: "$EvolveSupplier_ID" },
                    EvolveSupplier_Code: { $first: "$EvolveSupplier_Code" },
                    EvolveQCOrder_GrnNumber: { $first: "$EvolveQCOrder_GrnNumber" },
                    EvolveQCTemplete_ID: { $first: "$EvolveQCTemplete_ID" },
                    EvolveQCOrder_RecordedDetails: { $first: "$EvolveQCOrder_RecordedDetails" },
                    EvolveQCOrder_RecordedDetails: { $push: "$EvolveQCOrder_RecordedDetails" },
                    EvolveQCOrder_DOAStatus: { $first: "$EvolveQCOrder_DOAStatus" },
                    EvolveQCOrder_Status: { $first: "$EvolveQCOrder_Status" },
                    EvolveQCOrder_PerformedBy: { $first: "$EvolveQCOrder_PerformedBy" },
                    EvolveUnit_ID: { $first: "$EvolveUnit_ID" },
                    EvolveQCOrder_Remark: { $first: "$EvolveQCOrder_Remark" },
                    EvolveQCOrder_IsAccepted: { $first: "$EvolveQCOrder_IsAccepted" },
                    EvolveQCOrder_IsLabAccepted: { $first: "$EvolveQCOrder_IsLabAccepted" },
                    EvolveQCOrder_InspectionQty: { $first: "$EvolveQCOrder_InspectionQty" },
                    EvolveQCOrder_ISReworkOrder: { $first: "$EvolveQCOrder_ISReworkOrder" },
                    EvolveQCOrder_InventoryDetails: { $first: "$EvolveQCOrder_InventoryDetails" },
                    EvolveQCOrder_InventoryDetails: { $push: "$EvolveQCOrder_InventoryDetails" },
                    createdAt: { $first: "$createdAt" }
                }
            },
            {
                $sort: {
                    _id:
                        -1
                }
            },
            {
                $facet: {
                    result: [],
                    totalCount: [{
                        $count: 'count'
                    }]
                }
            }
            ]);
 -------------------- End ---------------------------------------