service inquiry sales

Table = m_inquiry_sales, sl_summary_amount, sl_summary_qty dan sl_sales_order

1. getInquirySalesListAdvanced  --> Input :     - ouBusinessUnitOrBranchId
                            - salesmanId
                            - brandId
                            - dateFrom
                            - dateTo
                            - ctgrProductId
                            - keyProduct (productName / productCode)
                            - customerId
                            - subCategoryId
                            - tenantId

                    Output :    result : [
                                summaryAmountList {
                                            - id
                                            - tenantId
                                            - currency
                                            - totalAmount
                                            - createDatetime
                                            - createUserId
                                            - updateDatetime
                                            - updateUserId
                                            - version
                                },
                                summaryQtyList {
                                            - id
                                            - tenantId
                                            - ctgrProducName
                                            - subCtrgProductName
                                            - brandName
                                            - productName
                                            - totalQty
                                            - createDatetime
                                            - createUserId
                                            - updateDatetime
                                            - updateUserId
                                            - version
                                }
                                detailSalesOrderList {
                                            - id
                                            - tenantId
                                            - salesOrderDate
                                            - salesOrderNo
                                            - customerName
                                            - salesmanName
                                            - brandName
                                            - productName
                                            - qtySalesOrder
                                            - nettAmount
                                            - createDatetime
                                            - createUserId
                                            - updateDatetime
                                            - updateUserId
                                            - version
                                }
                            ]

2. downloadInquirySalesListAdvanced
                --> Input :     - ouBusinessUnitOrBranchId
                            - salesmanId
                            - brandId
                            - dateFrom
                            - dateTo
                            - ctgrProductId
                            - keyProduct (productName / productCode)
                            - customerId
                            - subCategoryId

                    Output :    result : [
                                summaryAmountList {
                                            - id
                                            - tenantId
                                            - currency
                                            - totalAmount
                                            - createDatetime
                                            - createUserId
                                            - updateDatetime
                                            - updateUserId
                                            - version
                                },
                                summaryQtyList {
                                            - id
                                            - tenantId
                                            - ctgrProducName
                                            - subCtrgProductName
                                            - brandName
                                            - productName
                                            - totalQty
                                            - createDatetime
                                            - createUserId
                                            - updateDatetime
                                            - updateUserId
                                            - version
                                }
                                detailSalesOrderList {
                                            - id
                                            - tenantId
                                            - salesOrderDate
                                            - salesOrderNo
                                            - customerName
                                            - salesmanName
                                            - brandName
                                            - productName
                                            - qtySalesOrder
                                            - nettAmount
                                            - createDatetime
                                            - createUserId
                                            - updateDatetime
                                            - updateUserId
                                            - version
                                }
                            ]