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-05-30'

Array
(
    [produk_id] => 
    [produk_nama] => 
    [unit_af] => 
    [sum_unit_in] => 
    [sum_unit_ot] => 
    [sum_unit_netto] => 
    [avg_perhari] => 
)

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-05-30'

Array
(
    [produk_id] => 1149
    [produk_nama] => KERTAS-A4
    [sum_unit_in] => 24
    [sum_unit_ot] => 247
    [sum_unit_netto] => 223
    [avg_perhari] => 7.4333
)

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] => 391
)