query

SELECT (@cnt := @cnt + 1) AS id, s.tanggal, s.m_barang_id, IF(s.jenis = 'NotaBeli', SUM(s.jumlah), 0) as M, IF(s.jenis = 'NotaBeli', 0, SUM(s.jumlah)) as K, MIN(s.stok_sebelum) as stok
FROM m_stok_log s
INNER JOIN m_barang b ON b.id = s.m_barang_id
CROSS JOIN (SELECT @cnt := 0) AS autonumber
GROUP BY s.m_barang_id, s.tanggal
ORDER BY s.tanggal ASC