======================= Close Work Order, ====================
================================================================
 ~/eSmartFactory/workOrderDetail/list/closed
 => db.EvolveWorkOrder.aggregate([
    {
        $unwind: {
            path: "$EvolveItem_ID",
            preserveNullAndEmptyArrays: true
        }
    },
    {
        "$lookup": {
            "from": "EvolveSalesOrder",
            "localField": "EvolveSalesOrder_ID",
            "foreignField": "_id",
            "as": "EvolveSalesOrder_ID",

        }
    },
    {
        $unwind: {
            path: "$EvolveSalesOrder_ID",
            preserveNullAndEmptyArrays: true
        }
    },
    {
        "$lookup": {
            "from": "EvolveCustomer",
            "localField": "EvolveSalesOrder_ID.EvolveCustomer_ID",
            "foreignField": "_id",
            "as": "EvolveSalesOrder_ID.EvolveCustomer_ID",

        }
    },
    {
        $unwind: {
            path: "$EvolveSalesOrder_ID.EvolveCustomer_ID",
            preserveNullAndEmptyArrays: true
        }
    },



    {
        "$lookup": {
            "from": "EvolveUom",
            "localField": "EvolveUom_ID",
            "foreignField": "_id",
            "as": "EvolveUom_ID",

        }
    },
    {
        $unwind: {
            path: "$EvolveUom_ID",
            preserveNullAndEmptyArrays: true
        }
    },
    {
        "$lookup": {
            "from": "EvolveMachine",
            "localField": "EvolveMachine_ID",
            "foreignField": "_id",
            "as": "EvolveMachine_ID",

        }
    },
    {
        $unwind: {
            path: "$EvolveMachine_ID",
            preserveNullAndEmptyArrays: true
        }
    },
    {
        "$lookup": {
            "from": "EvolveDepartment",
            "localField": "EvolveSection_ID",
            "foreignField": "_id",
            "as": "EvolveSection_ID",

        }
    },
    {
        $unwind: {
            path: "$EvolveSection_ID",
            preserveNullAndEmptyArrays: true
        }
    },
    {
        $addFields: {
            EvolveWorkOrder_QtyRemain : { $subtract :["$EvolveWorkOrder_Qty","$EvolveWorkOrder_QtyCompleted"] },
        }
    },
    {
        $sort: {
            _id:
                -1
        }
    },
])
 
 -------------------- End ---------------------------------------