INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226260830111','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-YLAH-47-T','LT CHARM HURUF BALOK N BG 8K ','OL','0.610','1','100.00','778000','0','0','15000','785000','0','5000','0','790000','NS','T0075976','D1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YLAH-47-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='D1F-YLAH-47-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226260830111','2026-02-26','0.610','2026-02-26','08:30:12','PLG0077663','785000','785000','5000','790000','790000','kasir','2026-02-26 08:30:11','F22626083011');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226260830111','2026-02-26','08:30:12','NS','790000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260226-0002','D','2026-02-26','08:30:12','kasir','PENJUALAN','F226260830111','6470963000','790000','6471753000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226260848531','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZBAH-53-T','LT SLOBOK BALOK HURUF BG N 8K ','OL','0.620','1','100.00','790000','0','0','15000','797000','0','5000','0','802000','NS','T0077498','D1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZBAH-53-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='D1F-ZBAH-53-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226260848531','2026-02-26','0.620','2026-02-26','08:48:53','PLG0077664','797000','797000','5000','802000','802000','kasir','2026-02-26 08:48:53','F22626084853');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226260848531','2026-02-26','08:48:53','NS','802000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260226-0003','D','2026-02-26','08:48:53','kasir','PENJUALAN','F226260848531','6471753000','802000','6472555000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226260855181','kasir','1',' MDE2 CM 16','TOKO','SMBK-E','E2D-ZBAF-28-T','CC WEDDING MATA CM 16 8K ','OL','2.050','1','100.00','2532000','0','0','15000','2532000','0','10000','0','2542000','TIN','T0077407','E2D','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZBAF-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='E2D-ZBAF-28-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226260855181','2026-02-26','2.050','2026-02-26','08:55:18','PLG0077665','2532000','2532000','10000','2542000','2542000','kasir','2026-02-26 08:55:18','F22626085518');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226260855181','2026-02-26','08:55:18','TIN','2542000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260226-0004','D','2026-02-26','08:55:18','kasir','PENJUALAN','F226260855181','6472555000','2542000','6475097000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226260926211','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZBAI-5-T','GL MODEL SIEM COBRA UB 8K ','OL','0.410','1','100.00','515000','0','0','15000','520000','0','5000','0','525000','NS','T0077537','F3E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAI-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='F3E-ZBAI-5-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226260926211','2026-02-26','0.410','2026-02-26','09:26:21','PLG0077666','520000','520000','5000','525000','525000','kasir','2026-02-26 09:26:21','F22626092621');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226260926211','2026-02-26','09:26:21','NS','525000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260226-0005','D','2026-02-26','09:26:21','kasir','PENJUALAN','F226260926211','6475097000','525000','6475622000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226261008301','kasir','1',' MEH1 UB 42','TOKO','SMBK-H','H1E-ZBBA-8-0','KL MILANO UB 42 8K ','OLS YPS26','2.050','1','100.00','2573000','0','0','15000','2583000','0','148000','0','2731000','RHM','00391121','H1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBBA-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='H1E-ZBBA-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226261008301','2026-02-26','2.050','2026-02-26','10:08:30','PLG0077667','2583000','2583000','148000','2731000','2731000','kasir','2026-02-26 10:08:30','F22626100830');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226261008301','2026-02-26','10:08:30','RHM','2731000','148000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260226-0006','D','2026-02-26','10:08:30','kasir','PENJUALAN','F226261008301','6475622000','2731000','6478353000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226261009191','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YLBC-38-T','LT SLOBOK BALOK HURUF BG Y 8K ','OLS 2S83F','0.320','1','100.00','414000','0','0','15000','420000','0','90000','0','510000','RHM','T0076100','D1G','0','0','-','0','1290000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YLBC-38-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='D1G-YLBC-38-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226261009191','2026-02-26','0.320','2026-02-26','10:09:19','PLG0077668','420000','420000','90000','510000','510000','kasir','2026-02-26 10:09:19','F22626100919');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226261009191','2026-02-26','10:09:19','RHM','510000','90000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260226-0007','D','2026-02-26','10:09:19','kasir','PENJUALAN','F226261009191','6478353000','510000','6478863000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226261011481','kasir','1',' MGPH X KH ','TOKO','SMBK-P','PHG-XJBC-225-0','KL X WG NORY KH 44 8K ','OLS FNV26','2.110','1','100.00','2732000','0','0','15000','2722000','0','153000','0','2875000','RHM','00323324','PHG','0','0','-','1','1290000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PHG-XJBC-225-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='PHG-XJBC-225-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226261011481','2026-02-26','2.110','2026-02-26','10:11:49','PLG0077669','2722000','2722000','153000','2875000','2875000','kasir','2026-02-26 10:11:48','F22626101148');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226261011481','2026-02-26','10:11:49','RHM','2875000','153000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260226-0008','D','2026-02-26','10:11:49','kasir','PENJUALAN','F226261011481','6478863000','2875000','6481738000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226261113061','kasir','1',' MDE1 CM 16','TOKO','SMBK-E','E1D-ZBAI-25-T','CC MODEL SLEP VAR CM 16 8K ','OL','1.560','1','100.00','1927000','0','0','15000','1952000','0','8000','0','1960000','RTA','T0077557','E1D','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZBAI-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.560',berat_jual_asli=berat_jual_asli+'1.560',stock_jual='1',berat_akhir=berat_akhir-'1.560',berat_akhir_asli=berat_akhir_asli-'1.560',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='E1D-ZBAI-25-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226261113061','2026-02-26','1.560','2026-02-26','11:13:07','PLG0077670','1952000','1952000','8000','1960000','1960000','kasir','2026-02-26 11:13:06','F22626111306');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226261113061','2026-02-26','11:13:07','RTA','1960000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260226-0009','D','2026-02-26','11:13:07','kasir','PENJUALAN','F226261113061','6481738000','1960000','6483698000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1960000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261113061' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226261113062','kasir',' 1',' MEH1 KH 44','TOKO','SMBK-H','H1E-XCBG-37-T','KL FANCY KH 44CM 8K ','OL','4.060','1','100.00','5095000','0','0','15000','5096000','0','20000','0','5116000','RTA','T0055783','H1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-XCBG-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.060',berat_jual_asli=berat_jual_asli+'4.060',stock_jual='1',berat_akhir=berat_akhir-'4.060',berat_akhir_asli=berat_akhir_asli-'4.060',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='H1E-XCBG-37-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226261113062','2026-02-26','4.060','2026-02-26','11:13:07','PLG0077671','5096000','5096000','20000','5116000','5116000','kasir','2026-02-26 11:13:06','F22626111306');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226261113062','2026-02-26','11:13:07','RTA','5116000','20000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260226-0010','D','2026-02-26','11:13:07','kasir','PENJUALAN','F226261113062','6483698000','5116000','6488814000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5116000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261113062' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226261123211','kasir','1',' MEH1 UB 46','TOKO','SMBK-H','H1E-ZBAX-83-T','KL NORY UB 46CM 8K ','','0.970','1','100.00','1217000','0','0','15000','1213000','0','0','0','1213000','TIN','T0077198','H1E','0','0','-','1','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBAX-83-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='H1E-ZBAX-83-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226261123211','2026-02-26','0.970','2026-02-26','11:23:21','PLG0077672','1213000','1213000','0','1213000','1213000','kasir','2026-02-26 11:23:21','F22626112321');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226261123211','2026-02-26','11:23:21','TIN','1213000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260226-0011','D','2026-02-26','11:23:21','kasir','PENJUALAN','F226261123211','6488814000','1213000','6490027000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1213000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261123211' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226261123212','kasir',' 1',' MHD1 5K BG','TOKO','SMBK-D','D1H-ZABA-66-T','LT SLOBOK BOLA KRAWANG BG 8K ','','0.180','1','100.00','237000','0','0','15000','235000','0','5000','0','240000','TIN','T0076839','D1H','0','0','-','1','1315000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1H-ZABA-66-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.180',berat_jual_asli=berat_jual_asli+'0.180',stock_jual='1',berat_akhir=berat_akhir-'0.180',berat_akhir_asli=berat_akhir_asli-'0.180',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='D1H-ZABA-66-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226261123212','2026-02-26','0.180','2026-02-26','11:23:21','PLG0077673','235000','235000','5000','240000','240000','kasir','2026-02-26 11:23:21','F22626112321');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226261123212','2026-02-26','11:23:21','TIN','240000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260226-0012','D','2026-02-26','11:23:21','kasir','PENJUALAN','F226261123212','6490027000','240000','6490267000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='240000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261123212' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226261134281','kasir','1',' MED1 BW ','TOKO','SMBK-D','D1E-ZABA-63-T','LT MODEL LETTERA PLAT BW 8K ','OLS QEJYA','0.400','1','100.00','502000','0','0','15000','510000','0','70000','0','580000','RHM','T0076836','D1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZABA-63-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='D1E-ZABA-63-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226261134281','2026-02-26','0.400','2026-02-26','11:34:29','PLG0077674','510000','510000','70000','580000','580000','kasir','2026-02-26 11:34:28','F22626113428');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226261134281','2026-02-26','11:34:29','RHM','580000','70000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260226-0013','D','2026-02-26','11:34:29','kasir','PENJUALAN','F226261134281','6490267000','580000','6490847000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226261207071','kasir','1',' MEE2 X LG ','TOKO','SMBK-E','E2E-YJAC-291-0','CC X MODEL MATA LG 14 8K ','OL','0.520','1','100.00','653000','0','0','15000','655000','0','5000','0','660000','NS','00373021','E2E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJAC-291-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='E2E-YJAC-291-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226261207071','2026-02-26','0.520','2026-02-26','12:07:07','PLG0077675','655000','655000','5000','660000','660000','kasir','2026-02-26 12:07:07','F22626120707');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226261207071','2026-02-26','12:07:07','NS','660000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260226-0014','D','2026-02-26','12:07:07','kasir','PENJUALAN','F226261207071','6490847000','660000','6491507000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226261228581','kasir','1',' MEH1 LG ','TOKO','SMBK-H','H1E-ZBAF-3-T','KL TRIXIE SERUT FINE GOLD BAR LG 8K ','OL','2.700','1','100.00','3388000','0','0','15000','3402000','0','14000','0','3416000','TIN','T0077382','H1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBAF-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.700',berat_jual_asli=berat_jual_asli+'2.700',stock_jual='1',berat_akhir=berat_akhir-'2.700',berat_akhir_asli=berat_akhir_asli-'2.700',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='H1E-ZBAF-3-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226261228581','2026-02-26','2.700','2026-02-26','12:28:59','PLG0077676','3402000','3402000','14000','3416000','3416000','kasir','2026-02-26 12:28:58','F22626122858');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226261228581','2026-02-26','12:28:59','TIN','3416000','14000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260226-0015','D','2026-02-26','12:28:59','kasir','PENJUALAN','F226261228581','6491507000','3416000','6494923000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226260101541','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-ZAAE-20-T','GL OVAL MODEL C TD D54 8K ','','3.180','1','100.00','3991000','0','0','15000','3975000','0','0','0','3975000','NS','T0076582','F1E','0','0','-','1','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAAE-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.180',berat_jual_asli=berat_jual_asli+'3.180',stock_jual='1',berat_akhir=berat_akhir-'3.180',berat_akhir_asli=berat_akhir_asli-'3.180',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='F1E-ZAAE-20-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226260101541','2026-02-26','3.180','2026-02-26','13:01:54','PLG0077677','3975000','3975000','0','3975000','3975000','kasir','2026-02-26 13:01:54','F22626010154');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226260101541','2026-02-26','13:01:54','NS','3975000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260226-0016','D','2026-02-26','13:01:54','kasir','PENJUALAN','F226260101541','6494923000','3975000','6498898000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226260139551','kasir','1',' TEF3 MT ','TOKO','TBK-F','F3TE-YLAE-10-T','GL RANTE HOLLOW P4 SLEP MT 17K ','','5.580','1','100.00','12750000','0','0','15000','12555000','0','0','0','12555000','NS','T0075807','F3TE','0','0','-','1','2285000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YLAE-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.580',berat_jual_asli=berat_jual_asli+'5.580',stock_jual='1',berat_akhir=berat_akhir-'5.580',berat_akhir_asli=berat_akhir_asli-'5.580',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='F3TE-YLAE-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226260139551','2026-02-26','5.580','2026-02-26','13:39:56','PLG0077678','12555000','12555000','0','12555000','12555000','kasir','2026-02-26 13:39:55','F22626013955');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226260139551','2026-02-26','13:39:56','NS','12555000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260226-0017','D','2026-02-26','13:39:56','kasir','PENJUALAN','F226260139551','6498898000','12555000','6511453000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260101541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260101541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260101541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260139551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260139551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260139551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260830111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260830111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260830111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260848531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260848531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260848531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260855181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260855181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260855181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260926211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260926211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260926211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261008301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261008301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261008301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261009191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261009191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261009191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261011481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261011481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261011481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261113061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261113061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261113061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261113062' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261113062' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261113062';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261123211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261123211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261123211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261123212' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261123212' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261123212';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261134281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261134281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261134281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261207071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261207071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261207071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261228581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261228581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261228581';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226260311361','kasir','1',' MEF1 UB D4','TOKO','SMBK-F','F1E-ZAXG-7-T','GL ANAK PIPA MODEL KUPU VAR UB D40 8K ','','1.660','1','100.00','2083000','0','0','15000','2075000','0','0','0','2075000','TJ','T0076298','F1E','0','0','-','1','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAXG-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.660',berat_jual_asli=berat_jual_asli+'1.660',stock_jual='1',berat_akhir=berat_akhir-'1.660',berat_akhir_asli=berat_akhir_asli-'1.660',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='F1E-ZAXG-7-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226260311361','2026-02-26','1.660','2026-02-26','15:11:37','PLG0077679','2075000','2075000','0','2075000','2075000','kasir','2026-02-26 15:11:36','F22626031136');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226260311361','2026-02-26','15:11:37','TJ','2075000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260226-0018','D','2026-02-26','15:11:37','kasir','PENJUALAN','F226260311361','6511453000','2075000','6513528000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226260313191','kasir','1',' TEF1 Q30 U','TOKO','TBK-F','F1TE-XDBG-41-T','GL Q30 OVAL MODEL C UB D58 17K ','','8.860','1','100.00','20245000','0','0','15000','19935000','0','30000','0','19965000','TJ','T0056691','F1TE','0','0','-','1','2285000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-XDBG-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'8.860',berat_jual_asli=berat_jual_asli+'8.860',stock_jual='1',berat_akhir=berat_akhir-'8.860',berat_akhir_asli=berat_akhir_asli-'8.860',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='F1TE-XDBG-41-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226260313191','2026-02-26','8.860','2026-02-26','15:13:20','PLG0077680','19935000','19935000','30000','19965000','19965000','kasir','2026-02-26 15:13:19','F22626031319');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226260313191','2026-02-26','15:13:20','TJ','19965000','30000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260226-0019','D','2026-02-26','15:13:20','kasir','PENJUALAN','F226260313191','6513528000','19965000','6533493000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005131','X-00005131','GL OVAL MODEL C TD D52 8K','GR','---','F1E','BELI','BELI001','2475000','2026-02-26','2.950','1','kasir','2026-02-26 15:41:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00005131','X-00005131');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260226-0001','F225300507071','NS','1','BELI','BELI001','F1E', 'X-00005131', 'GL OVAL MODEL C TD D52 8K','3.020','2.950','100.00','2358000','2475000','838983','1250000','1','2475000','2475000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.950',berat_beli_asli=berat_beli_asli+'2.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.950',berat_akhir_asli=berat_akhir_asli+'2.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260226-0001','2026-02-26','2026-02-26','15:41:49','NS','---','2.950','2475000','2475000','2475000','2475000','2475000','kasir','2026-02-26 15:41:50','FB-260226-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260226-0001','ANGGITA','JL IMAM BONJOL','','','08813533084','kasir','2026-02-26 15:41:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-26' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260226-0020','K','2026-02-26','15:41:49','kasir','PEMBELIAN UMUM','FB-260226-0001','6533493000','2475000','6531018000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005132','X-00005132','KL POLOS 17K','GR','---','H1TG','BELI','BELI001','8980000','2026-02-26','4.900','1','kasir','2026-02-26 15:45:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1TG';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1TG','X-00005132','X-00005132');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260226-0002','F223051008501','RHM','1','BELI','BELI001','H1TG', 'X-00005132', 'KL POLOS 17K','5.020','4.900','100.00','3966000','8980000','1832653','2325000','1','8980000','8980000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.900',berat_beli_asli=berat_beli_asli+'4.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.900',berat_akhir_asli=berat_akhir_asli+'4.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1TG' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260226-0002','2026-02-26','2026-02-26','15:45:46','RHM','---','4.900','8980000','8980000','8980000','8980000','8980000','kasir','2026-02-26 15:45:46','FB-260226-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260226-0002','MB ERNA','BULU KIDUL BALONG','','','','kasir','2026-02-26 15:45:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-26' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260226-0021','K','2026-02-26','15:45:46','kasir','PEMBELIAN UMUM','FB-260226-0002','6531018000','8980000','6522038000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005133','X-00005133','LT COR M 17K','GR','---','D2TE','BELI','BELI001','1820000','2026-02-26','0.980','1','kasir','2026-02-26 15:45:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2TE','X-00005133','X-00005133');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260226-0003','F223051008502','RHM','2','BELI','BELI001','D2TE', 'X-00005133', 'LT COR M 17K','1.180','0.980','100.00','910000','1820000','1857143','2285000','1','1820000','1820000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.980',berat_beli_asli=berat_beli_asli+'0.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.980',berat_akhir_asli=berat_akhir_asli+'0.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2TE' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260226-0003','2026-02-26','2026-02-26','15:45:46','RHM','---','0.980','1820000','1820000','1820000','1820000','1820000','kasir','2026-02-26 15:45:46','FB-260226-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260226-0003','MB ERNA','BULU KIDUL BALONG','','','','kasir','2026-02-26 15:45:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-26' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260226-0022','K','2026-02-26','15:45:46','kasir','PEMBELIAN UMUM','FB-260226-0003','6522038000','1820000','6520218000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260311361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260311361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260311361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260313191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260313191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260313191';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260226-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260226-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260226-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260226-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260226-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260226-0003';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226260355341','admin','1',' TEH1 X HW ','TOKO','TBK-H','H1TE-YLAB-13-T','KL X SANTA 44 HW 17K','','5.020','1','100.00','11471000','0','0','15000','11150000','0','0','0','11150000','RHM','T0075719','H1TE','0','0','-','1','2285000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-YLAB-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.020',berat_jual_asli=berat_jual_asli+'5.020',stock_jual='1',berat_akhir=berat_akhir-'5.020',berat_akhir_asli=berat_akhir_asli-'5.020',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='H1TE-YLAB-13-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226260355341','2026-02-26','5.020','2026-02-26','15:55:35','PLG0077681','11150000','11150000','0','11150000','11150000','admin','2026-02-26 15:55:34','F22626035534');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226260355341','2026-02-26','15:55:35','RHM','11150000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260226-0023','D','2026-02-26','15:55:35','admin','PENJUALAN','F226260355341','6520218000','11150000','6531368000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='11150000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226260355341' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226260355342','admin',' 1',' TFA1 X UB ','TOKO','TBK-A','A1TF-YIXD-42-T','AT X MODEL ITALY PANJANG VAR UB 17K ','','1.030','1','100.00','2374000','0','0','15000','2320000','0','0','0','2320000','RHM','T0072894','A1TF','0','0','-','1','2305000');
UPDATE tm_barang SET tgl_last_jual='2026-02-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TF-YIXD-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-02-26' AND kode_barang='A1TF-YIXD-42-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226260355342','2026-02-26','1.030','2026-02-26','15:55:35','PLG0077682','2320000','2320000','0','2320000','2320000','admin','2026-02-26 15:55:34','F22626035534');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-26','F226260355342','2026-02-26','15:55:35','RHM','2320000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260226-0024','D','2026-02-26','15:55:35','admin','PENJUALAN','F226260355342','6531368000','2320000','6533688000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2320000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226260355342' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260355341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260355341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260355341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260355342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260355342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260355342';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005134','X-00005134','CC MODEL DAUN VAR LG 19 8K','GR','---','E1E','BELI','BELI001','485000','2026-02-26','0.500','1','kasir','2026-02-26 16:08:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00005134','X-00005134');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260226-0004','F225010935104','TIN','1','BELI','BELI001','E1E', 'X-00005134', 'CC MODEL DAUN VAR LG 19 8K','0.500','0.500','100.00','528000','485000','970000','1250000','1','485000','485000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260226-0004','2026-02-26','2026-02-26','16:08:24','TIN','---','0.500','485000','485000','485000','485000','485000','kasir','2026-02-26 16:08:25','FB-260226-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260226-0004','MM','','','','','kasir','2026-02-26 16:08:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-26' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260226-0025','K','2026-02-26','16:08:24','kasir','PEMBELIAN UMUM','FB-260226-0004','6533688000','485000','6533203000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005135','X-00005135','LT MODEL MATA VAR UB 8K','GR','---','D2G','BELI','BELI001','247000','2026-02-26','0.300','1','kasir','2026-02-26 16:09:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2G','X-00005135','X-00005135');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260226-0005','F225171207385','TIN','1','BELI','BELI001','D2G', 'X-00005135', 'LT MODEL MATA VAR UB 8K','0.300','0.300','100.00','269000','247000','823333','1290000','1','247000','247000','CUCI');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-02-26','BELI','BELI001','D2G','X-00005135','100.00','0.300','0.300','1','0.300','0.300','1');
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260226-0005','2026-02-26','2026-02-26','16:09:47','TIN','---','0.300','247000','247000','247000','247000','247000','kasir','2026-02-26 16:09:48','FB-260226-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260226-0005','MM','','','','','kasir','2026-02-26 16:09:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-26' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260226-0026','K','2026-02-26','16:09:47','kasir','PEMBELIAN UMUM','FB-260226-0005','6533203000','247000','6532956000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005136','X-00005136','LT MODEL COIN HW 8K','GR','---','D1F','BELI','BELI001','580000','2026-02-26','0.610','1','kasir','2026-02-26 16:09:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00005136','X-00005136');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260226-0006','F225031247245','TIN','2','BELI','BELI001','D1F', 'X-00005136', 'LT MODEL COIN HW 8K','0.610','0.610','100.00','631000','580000','950820','1115000','1','580000','580000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.610',berat_beli_asli=berat_beli_asli+'0.610',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.610',berat_akhir_asli=berat_akhir_asli+'0.610',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260226-0006','2026-02-26','2026-02-26','16:09:47','TIN','---','0.610','580000','580000','580000','580000','580000','kasir','2026-02-26 16:09:48','FB-260226-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260226-0006','MM','','','','','kasir','2026-02-26 16:09:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-26' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260226-0027','K','2026-02-26','16:09:47','kasir','PEMBELIAN UMUM','FB-260226-0006','6532956000','580000','6532376000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005137','X-00005137','GL RANTAI HOLLOW P3 SLEP LT 8K','GR','---','F3E','BELI','BELI001','821000','2026-02-26','0.950','1','kasir','2026-02-26 16:11:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005137','X-00005137');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260226-0007','F225101133204','TIN','1','BELI','BELI001','F3E', 'X-00005137', 'GL RANTAI HOLLOW P3 SLEP LT 8K','1.000','0.950','100.00','832000','821000','864211','1250000','1','821000','821000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.950',berat_beli_asli=berat_beli_asli+'0.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.950',berat_akhir_asli=berat_akhir_asli+'0.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260226-0007','2026-02-26','2026-02-26','16:11:37','TIN','---','0.950','821000','821000','821000','821000','821000','kasir','2026-02-26 16:11:38','FB-260226-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260226-0007','MM','','','','','kasir','2026-02-26 16:11:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-26' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260226-0028','K','2026-02-26','16:11:37','kasir','PEMBELIAN UMUM','FB-260226-0007','6532376000','821000','6531555000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005138','X-00005138','GL KAKI RANTAI HOLLOW UB 8K','GR','---','F3F','BELI','BELI001','391000','2026-02-26','0.510','1','kasir','2026-02-26 16:11:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00005138','X-00005138');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260226-0008','F225021107142','TIN','2','BELI','BELI001','F3F', 'X-00005138', 'GL KAKI RANTAI HOLLOW UB 8K','0.510','0.510','100.00','460000','391000','766667','1115000','1','391000','391000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260226-0008','2026-02-26','2026-02-26','16:11:37','TIN','---','0.510','391000','391000','391000','391000','391000','kasir','2026-02-26 16:11:38','FB-260226-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260226-0008','MM','','','','','kasir','2026-02-26 16:11:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-26' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260226-0029','K','2026-02-26','16:11:37','kasir','PEMBELIAN UMUM','FB-260226-0008','6531555000','391000','6531164000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005139','X-00005139','CC BANGKOK SLEP LG 15 8K','GR','---','E1E','BELI','BELI001','464000','2026-02-26','0.480','1','kasir','2026-02-26 16:11:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00005139','X-00005139');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260226-0009','F225081050014','TIN','3','BELI','BELI001','E1E', 'X-00005139', 'CC BANGKOK SLEP LG 15 8K','0.480','0.480','100.00','505000','464000','966667','1250000','1','464000','464000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.480',berat_beli_asli=berat_beli_asli+'0.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.480',berat_akhir_asli=berat_akhir_asli+'0.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260226-0009','2026-02-26','2026-02-26','16:11:37','TIN','---','0.480','464000','464000','464000','464000','464000','kasir','2026-02-26 16:11:38','FB-260226-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260226-0009','MM','','','','','kasir','2026-02-26 16:11:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-26' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260226-0030','K','2026-02-26','16:11:37','kasir','PEMBELIAN UMUM','FB-260226-0009','6531164000','464000','6530700000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005140','X-00005140','CC X MODEL SLEP LT 18 8K','GR','---','E1D','BELI','BELI001','778000','2026-02-26','0.900','1','kasir','2026-02-26 16:13:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00005140','X-00005140');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260226-0010','F225131218245','TIN','1','BELI','BELI001','E1D', 'X-00005140', 'CC X MODEL SLEP LT 18 8K','0.950','0.900','100.00','806000','778000','864444','1230000','1','778000','778000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260226-0010','2026-02-26','2026-02-26','16:13:16','TIN','---','0.900','778000','778000','778000','778000','778000','kasir','2026-02-26 16:13:16','FB-260226-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260226-0010','MM','','','','','kasir','2026-02-26 16:13:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-26' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260226-0031','K','2026-02-26','16:13:16','kasir','PEMBELIAN UMUM','FB-260226-0010','6530700000','778000','6529922000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005141','X-00005141','CC WEDDING MATA CM 11 8K','GR','---','E2D','BELI','BELI001','1990000','2026-02-26','2.060','1','kasir','2026-02-26 16:13:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00005141','X-00005141');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260226-0011','F225010935106','TIN','2','BELI','BELI001','E2D', 'X-00005141', 'CC WEDDING MATA CM 11 8K','2.060','2.060','100.00','2163000','1990000','966019','1230000','1','1990000','1990000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.060',berat_beli_asli=berat_beli_asli+'2.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.060',berat_akhir_asli=berat_akhir_asli+'2.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260226-0011','2026-02-26','2026-02-26','16:13:16','TIN','---','2.060','1990000','1990000','1990000','1990000','1990000','kasir','2026-02-26 16:13:16','FB-260226-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260226-0011','MM','','','','','kasir','2026-02-26 16:13:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-26' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260226-0032','K','2026-02-26','16:13:16','kasir','PEMBELIAN UMUM','FB-260226-0011','6529922000','1990000','6527932000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005142','X-00005142','AT MODEL DAISY MATA LG 8K','GR','---','A1H','BELI','BELI001','257000','2026-02-26','0.260','1','kasir','2026-02-26 16:13:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1H';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1H','X-00005142','X-00005142');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260226-0012','F225031243022','TIN','3','BELI','BELI001','A1H', 'X-00005142', 'AT MODEL DAISY MATA LG 8K','0.260','0.260','100.00','280000','257000','988462','1315000','1','257000','257000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.260',berat_beli_asli=berat_beli_asli+'0.260',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.260',berat_akhir_asli=berat_akhir_asli+'0.260',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1H' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260226-0012','2026-02-26','2026-02-26','16:13:16','TIN','---','0.260','257000','257000','257000','257000','257000','kasir','2026-02-26 16:13:16','FB-260226-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260226-0012','MM','','','','','kasir','2026-02-26 16:13:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-26' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260226-0033','K','2026-02-26','16:13:16','kasir','PEMBELIAN UMUM','FB-260226-0012','6527932000','257000','6527675000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005143','X-00005143','AT GYPSY MRICAN LG 8K','GR','---','A1E','BELI','BELI001','513000','2026-02-26','0.550','1','kasir','2026-02-26 16:13:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00005143','X-00005143');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260226-0013','F225031243024','TIN','4','BELI','BELI001','A1E', 'X-00005143', 'AT GYPSY MRICAN LG 8K','0.550','0.550','100.00','558000','513000','932727','1250000','1','513000','513000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260226-0013','2026-02-26','2026-02-26','16:13:16','TIN','---','0.550','513000','513000','513000','513000','513000','kasir','2026-02-26 16:13:16','FB-260226-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260226-0013','MM','','','','','kasir','2026-02-26 16:13:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-26' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260226-0034','K','2026-02-26','16:13:16','kasir','PEMBELIAN UMUM','FB-260226-0013','6527675000','513000','6527162000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260226-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260226-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260226-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260226-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260226-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260226-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260226-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260226-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260226-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260226-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260226-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260226-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260226-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260226-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260226-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260226-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260226-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260226-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260226-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260226-0013';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-27','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-27';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-26';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-26';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-02-26' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-26';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-26';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-26';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-26';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202601 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
UPDATE tt_barang_saldo SET tanggal= '2026-02-27' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-26' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260227-0001','D','2026-02-27','16:32:20','SYSTEM','SALDO AWAL','SALDO AWAL','0','6527162000','6527162000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260227-0001','D','2026-02-27','16:32:20','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260227-0001','D','2026-02-27','16:32:20','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260227-0001','D','2026-02-27','16:32:20','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260227-0001','D','2026-02-27','16:32:20','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260227-0001','D','2026-02-27','16:32:20','BCA','SALDO AWAL','SALDO AWAL','0','4288430888','4288430888');
UPDATE tp_system SET tgl_system='2026-02-27';