Asli

SELECT
    resMember.strnama_dealer,
    resMember.strkode_dealer,
    resMember.strnama_upline,
    a.intid_dealer,
    resCabang.strnama_cabang,
    resUnit.strnama_unit,
    a.intid_unit,
    a.intid_jpenjualan,
    a.inttotal_omset,

IF (
    a.intid_jpenjualan = 1,
    SUM(a.inttotal_omset),
    '0'
) AS omset_awal,

IF (
    a.intid_jpenjualan != 8
    AND a.intid_jpenjualan != 10
    AND a.intid_jpenjualan != 11
    AND a.intid_jpenjualan != 12,
    SUM(a.inttotal_omset),
    '0'
) AS omset_unit,
 a.intid_week,
 a.datetgl
FROM
    nota a
LEFT JOIN (
    SELECT
        strnama_dealer,
        strkode_dealer,
        strnama_upline,
        intid_dealer
    FROM
        member
) resMember ON resMember.intid_dealer = a.intid_dealer
LEFT JOIN (
    SELECT
        intid_unit,
        strnama_unit
    FROM
        unit
) resUnit ON resUnit.intid_unit = a.intid_unit
LEFT JOIN (
    SELECT
        intid_cabang,
        strnama_cabang
    FROM
        cabang
) resCabang ON resCabang.intid_cabang = a.intid_cabang,
 `week` b
WHERE
    a.intid_week = b.intid_week
    AND a.intid_week in (
        SELECT intid_week FROM week
        WHERE
        intbulan='03'
        AND inttahun='2014'
    )
    AND YEAR(a.datetgl)='2014'
AND a.intid_unit = resUnit.intid_unit
AND a.is_dp = 0
GROUP BY
    resMember.strnama_dealer,
    resMember.strkode_dealer,
    resMember.strnama_upline,
    resMember.intid_dealer
ORDER BY
    resCabang.strnama_cabang ASC