query

SELECT
    a.intid_dealer,
    a.intid_cabang,
    a.intid_jpenjualan,
    a.intid_unit,
    a.intid_week,
    a.datetgl,
    a.inttotal_omset,

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

IF (
    (a.intid_jpenjualan != 8) && (a.intid_jpenjualan != 10) && (a.intid_jpenjualan != 11) && (a.intid_jpenjualan != 12),
    SUM(a.inttotal_omset),
    '0'
) AS omset_unit
FROM
    nota a,
    `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'
GROUP BY
    a.intid_unit