Dari data 30 hari terakhir

stok masuk

SELECT produk_id,produk_nama,unit_af, sum(unit_in) as 'sum_unit_in',sum(unit_ot) as 'sum_unit_ot', SUM(unit_in) - SUM(unit_ot) AS sum_unit_netto,unit_in / 30 as 'avg_perhari' FROM rek_persediaan_produk where transaksi_jenis in ('467','967') and produk_id='1149' and cabang_id in ('49') and dtime>='2026-02-28'

Array
(
    [produk_id] => 1149
    [produk_nama] => KERTAS-A4
    [unit_af] => 518
    [sum_unit_in] => 500
    [sum_unit_ot] => 0
    [sum_unit_netto] => 500
    [avg_perhari] => 16.6667
)

penjualan

SELECT produk_id,produk_nama,sum(unit_in) as 'sum_unit_in',sum(unit_ot) as 'sum_unit_ot', SUM(unit_ot) - SUM(unit_in) AS sum_unit_netto, (SUM(unit_ot) - SUM(unit_in)) / 30 as 'avg_perhari' FROM rek_persediaan_produk where transaksi_jenis in ('582','982') and produk_id='1149' and cabang_id in ('49') and dtime>='2026-02-28'

Array
(
    [produk_id] => 1149
    [produk_nama] => KERTAS-A4
    [sum_unit_in] => 33
    [sum_unit_ot] => 319
    [sum_unit_netto] => 286
    [avg_perhari] => 9.5333
)

stok sekarang

SELECT produk_id,produk_nama,persediaan_st FROM produk_cache where produk_id='1149' and cabang_id in ('49')

Array
(
    [produk_id] => 1149
    [produk_nama] => KERTAS-A4
    [persediaan_st] => 443
)