SELECT (@cnt := @cnt + 1) AS id, s.tanggal, s.m_barang_id, CAST(IF(s.jenis = 'NotaBeli', SUM(s.jumlah), 0) as UNSIGNED) as masuk, CAST(IF(s.jenis = 'NotaBeli', 0, SUM(s.jumlah)) as UNSIGNED) as keluar, 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