report mutasi barang jadi aoi 2

SELECT
    temp4.kode_barang,
    temp4.barang_search_key,
    temp4.nama_barang,
    temp4.satuan,
    (
        temp4.stok_akhir - temp4.Qtyin
    ) + temp4.Qtyout AS saldo_awal,
    temp4.Qtyin,
    temp4.Qtyout,
    0 AS adjustment,
    temp4.stok_akhir AS saldo_akhir,
    0 AS stock_opname,
    0 AS selisih,
    ' ' AS keterangan
FROM
    (
        SELECT
            temp3.kode_barang,
            temp3.nama_barang,
            temp3.barang_search_key,
            temp3.satuan,
            SUM (temp3.stok_akhir) AS stok_akhir,
            SUM (temp3.Qtyin) AS Qtyin,
            SUM (temp3.Qtyout) AS Qtyout,
            0 AS adjustment
        FROM
            (
                SELECT
                    temp2.product_id,
                    temp2.kode_barang,
                    temp2.nama_barang,
                    temp2.barang_search_key,
                    temp2.satuan,
                    round(stok_akhir.qty, 2) AS stok_akhir,
                    round(temp2.Qtyin, 2) AS Qtyin,
                    round(ABS(temp2.Qtyout), 2) AS Qtyout
                FROM
                    (
                        SELECT
                            mp."name" AS nama_barang,
                            mp.upc AS kode_barang,
                            mp.m_product_id AS product_id,
                            mp.
                        VALUE
                            AS barang_search_key,
                            mu. NAME AS satuan,
                            SUM (temp1.Qtyin) AS Qtyin,
                            SUM (temp1.Qtyout) AS Qtyout
                        FROM
                            (
                                SELECT
                                    mi.ad_client_id,
                                    mi.ad_org_id,
                                    ml.m_locator_id,
                                    mt.m_transaction_id,
                                    mInline.m_product_id,
                                    mt.movementtype,
                                    mInline.movementqty,
                                    mi.movementdate,
                                    CASE SUBSTRING (mt.movementtype, 2, 1)
                                WHEN '+' THEN
                                    mt.movementqty
                                ELSE
                                    0
                                END AS QtyIn,
                                CASE SUBSTRING (mt.movementtype, 2, 1)
                            WHEN '-' THEN
                                mt.movementqty
                            ELSE
                                0
                            END AS QtyOut,
                            mp.upc
                        FROM
                            m_inout AS mi
                        LEFT JOIN m_inoutline AS mInline ON mi.m_inout_id = mInline.m_inout_id
                        LEFT JOIN m_warehouse AS mw ON mi.m_warehouse_id = mw.m_warehouse_id
                        LEFT JOIN m_locator AS ml ON mw.m_warehouse_id = ml.m_warehouse_id
                        LEFT JOIN m_transaction AS mt ON mInline.m_inoutline_id = mt.m_inoutline_id
                        LEFT JOIN m_product AS mp ON mInline.m_product_id = mp.m_product_id
                        LEFT JOIN m_product_category AS mpc ON mp.m_product_category_id = mpc.m_product_category_id
                        WHERE
                            mpc.isFGkst = 'Y'
                        AND mpc.iswipkst = 'N'
                        AND mt.movementdate BETWEEN $P { DateFrom }
                        AND $P { DateTo }
                        -- $P !{ whereProductId } $P !{ whereKodeBarang }
                        ORDER BY
                            mt.movementtype
                            ) AS temp1
                        JOIN m_product AS mp ON temp1.m_product_id = mp.m_product_id
                        JOIN c_uom AS mu ON mp.c_uom_id = mu.c_uom_id
                        WHERE
                            temp1.m_locator_id = 1000105
                        GROUP BY
                            temp1.m_product_id,
                            mp."name",
                            mp.upc,
                            mu. NAME,
                            mp.m_product_id
                        ORDER BY
                            mp."name"
                    ) AS temp2
                LEFT JOIN (
                    SELECT
                        mp.m_product_id,
                        SUM (sto.qtyonhand) AS qty
                    FROM
                        m_storage sto
                    LEFT JOIN m_product mp ON sto.m_product_id = mp.m_product_id
                    WHERE
                        sto.m_product_id IN (
                            SELECT
                                m_product_id
                            FROM
                                m_product
                        )
                    AND sto.m_locator_id IN (
                        SELECT
                            m_locator_id
                        FROM
                            m_locator
                        WHERE
                            m_locator_id = 1000105
                    )
                    GROUP BY
                        mp.m_product_id
                ) AS stok_akhir ON temp2.product_id = stok_akhir.m_product_id
            ) temp3
        GROUP BY
            temp3.product_id,
            temp3.kode_barang,
            temp3.nama_barang,
            temp3.satuan,
            temp3.barang_search_key
    ) temp4
ORDER BY
    temp4.nama_barang