INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','B1E-ZJXF-279-0','1','0.600','0.600','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZJXF-279-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZJXF-279-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-10-13 08:05:47' WHERE kode_barang='B1E-ZJXF-279-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZJXF-279-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 08:05:47','TOKO','PM-B','B1E','B1E-ZJXF-279-0','1','0.600','0.600','1','0.600','0.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZJXF-279-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZJXF-279-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','B1E-ZJXF-284-0','1','1.010','1.010','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZJXF-284-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZJXF-284-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-10-13 08:05:47' WHERE kode_barang='B1E-ZJXF-284-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZJXF-284-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 08:05:47','TOKO','PM-B','B1E','B1E-ZJXF-284-0','1','1.010','1.010','1','1.010','1.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZJXF-284-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZJXF-284-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','B1E-ZJXH-53-0','1','0.720','0.720','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZJXH-53-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZJXH-53-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-10-13 08:05:47' WHERE kode_barang='B1E-ZJXH-53-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZJXH-53-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 08:05:47','TOKO','PM-B','B1E','B1E-ZJXH-53-0','1','0.720','0.720','1','0.720','0.720','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZJXH-53-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZJXH-53-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261013-0001','2026-10-13','08:05','2.330','admpindah','2026-10-13 08:05:46');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','E1E-ZJXF-314-0','1','0.420','0.420','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZJXF-314-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZJXF-314-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-13 08:06:23' WHERE kode_barang='E1E-ZJXF-314-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZJXF-314-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 08:06:23','TOKO','PM-E','E1E','E1E-ZJXF-314-0','1','0.420','0.420','1','0.420','0.420','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZJXF-314-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZJXF-314-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','E1E-ZJXH-154-0','1','0.660','0.660','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZJXH-154-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZJXH-154-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-13 08:06:23' WHERE kode_barang='E1E-ZJXH-154-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZJXH-154-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 08:06:23','TOKO','PM-E','E1E','E1E-ZJXH-154-0','1','0.660','0.660','1','0.660','0.660','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZJXH-154-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZJXH-154-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261013-0001','2026-10-13','08:06','1.080','admpindah','2026-10-13 08:06:22');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','F1E-ZJXG-161-0','1','3.030','3.030','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZJXG-161-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZJXG-161-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-13 08:06:43' WHERE kode_barang='F1E-ZJXG-161-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZJXG-161-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 08:06:43','TOKO','PM-F','F1E','F1E-ZJXG-161-0','1','3.030','3.030','1','3.030','3.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZJXG-161-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZJXG-161-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','F1E-ZJXG-166-0','1','5.030','5.030','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZJXG-166-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZJXG-166-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-13 08:06:43' WHERE kode_barang='F1E-ZJXG-166-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZJXG-166-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 08:06:43','TOKO','PM-F','F1E','F1E-ZJXG-166-0','1','5.030','5.030','1','5.030','5.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZJXG-166-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZJXG-166-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261013-0001','2026-10-13','08:06','8.060','admpindah','2026-10-13 08:06:43');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','H1E-ZJXG-221-0','1','2.010','2.010','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZJXG-221-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZJXG-221-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-13 08:07:24' WHERE kode_barang='H1E-ZJXG-221-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZJXG-221-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 08:07:24','TOKO','PM-H','H1E','H1E-ZJXG-221-0','1','2.010','2.010','1','2.010','2.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZJXG-221-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZJXG-221-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','H1E-ZJXG-229-0','1','2.050','2.050','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZJXG-229-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZJXG-229-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-13 08:07:24' WHERE kode_barang='H1E-ZJXG-229-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZJXG-229-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 08:07:24','TOKO','PM-H','H1E','H1E-ZJXG-229-0','1','2.050','2.050','1','2.050','2.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZJXG-229-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZJXG-229-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261013-0001','2026-10-13','08:06','4.060','admpindah','2026-10-13 08:07:23');
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 ('F326130823161','input','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZFXI-186-0','CC X WEDDING POLOS CM 14 8K','','1.030','1','100.00','1054000','0','0','15000','1055000','0','0','0','1055000','FIT','00408253','E1D','0','0','-','0','1023000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFXI-186-0' 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-10-13' AND kode_barang='E1D-ZFXI-186-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326130823161','2026-10-13','1.030','2026-10-13','08:23:16','PLG0031832','1055000','1055000','0','1055000','1055000','input','2026-10-13 08:23:16','F32613082316');
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-10-13','F326130823161','2026-10-13','08:23:16','FIT','1055000','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-261013-0002','D','2026-10-13','08:23:16','input','PENJUALAN','F326130823161','7838435000','1055000','7839490000');
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 ('F326130913371','input','1',' MEE1E PM 1','TOKO','PM-E','E1E-ZHBE-301-0','CC MODEL SLEP PM 12 8K ','','0.500','1','100.00','521000','0','0','15000','522000','0','0','0','522000','AAT','00420343','E1E','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBE-301-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='E1E-ZHBE-301-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326130913371','2026-10-13','0.500','2026-10-13','09:13:38','PLG0031833','522000','522000','0','522000','522000','input','2026-10-13 09:13:37','F32613091337');
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-10-13','F326130913371','2026-10-13','09:13:38','AAT','522000','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-261013-0003','D','2026-10-13','09:13:38','input','PENJUALAN','F326130913371','7839490000','522000','7840012000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='522000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326130913371' 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 ('F326130913372','input',' 1',' MEE2 KH 18','TOKO','PM-E','E2E-ZJXE-373-0','CC MODEL SNAKE MATA KH 18 8K ','','0.520','1','100.00','542000','0','0','15000','543000','0','0','0','543000','AAT','00427864','E2E','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZJXE-373-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-10-13' AND kode_barang='E2E-ZJXE-373-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326130913372','2026-10-13','0.520','2026-10-13','09:13:38','PLG0031834','543000','543000','0','543000','543000','input','2026-10-13 09:13:37','F32613091337');
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-10-13','F326130913372','2026-10-13','09:13:38','AAT','543000','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-261013-0004','D','2026-10-13','09:13:38','input','PENJUALAN','F326130913372','7840012000','543000','7840555000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='543000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326130913372' 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 ('F326130913373','input',' 1',' MEE1E LG 1','TOKO','PM-E','E1E-ZFBC-43-0','CC MODEL ISYANA SLEP LG 12 8K ','','0.570','1','100.00','595000','0','0','15000','595000','0','0','0','595000','AAT','00409917','E1E','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBC-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='E1E-ZFBC-43-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326130913373','2026-10-13','0.570','2026-10-13','09:13:38','PLG0031835','595000','595000','0','595000','595000','input','2026-10-13 09:13:37','F32613091337');
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-10-13','F326130913373','2026-10-13','09:13:38','AAT','595000','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-261013-0005','D','2026-10-13','09:13:38','input','PENJUALAN','F326130913373','7840555000','595000','7841150000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='595000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326130913373' 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 ('F326130913374','input',' 1',' MEF3E X UB','TOKO','PM-F','F3E-ZHXH-119-0','GL X SANTA MATA VAR SERUT UB 8K ','','1.500','1','100.00','1564000','0','0','15000','1565000','0','0','0','1565000','AAT','00417848','F3E','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHXH-119-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='F3E-ZHXH-119-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326130913374','2026-10-13','1.500','2026-10-13','09:13:38','PLG0031836','1565000','1565000','0','1565000','1565000','input','2026-10-13 09:13:37','F32613091337');
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-10-13','F326130913374','2026-10-13','09:13:38','AAT','1565000','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-261013-0006','D','2026-10-13','09:13:38','input','PENJUALAN','F326130913374','7841150000','1565000','7842715000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1565000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326130913374' 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 ('F326130918121','input','1',' MEF1 X TD ','TOKO','PM-F','F1E-ZIBE-84-0','GL X OVAL GELOMBANG C SLEP TD 56 8K ','','3.000','1','100.00','3129000','0','0','15000','3130000','0','0','0','3130000','FIT','00425459','F1E','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZIBE-84-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='F1E-ZIBE-84-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326130918121','2026-10-13','3.000','2026-10-13','09:18:13','PLG0031837','3130000','3130000','0','3130000','3130000','input','2026-10-13 09:18:12','F32613091812');
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-10-13','F326130918121','2026-10-13','09:18:13','FIT','3130000','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-261013-0007','D','2026-10-13','09:18:13','input','PENJUALAN','F326130918121','7842715000','3130000','7845845000');
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 ('F326131007451','input','1',' MEH1 UB ','TOKO','PM-H','H1E-ZJXA-88-0','KL TRIXIE MODEL KUPU MATA VAR UB 8K ','','1.440','1','100.00','1502000','0','0','15000','1488000','0','0','0','1488000','LIS','00426721','H1E','0','0','-','1','1053000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZJXA-88-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.440',berat_jual_asli=berat_jual_asli+'1.440',stock_jual='1',berat_akhir=berat_akhir-'1.440',berat_akhir_asli=berat_akhir_asli-'1.440',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='H1E-ZJXA-88-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326131007451','2026-10-13','1.440','2026-10-13','10:07:46','PLG0031838','1488000','1488000','0','1488000','1488000','input','2026-10-13 10:07:45','F32613100745');
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-10-13','F326131007451','2026-10-13','10:07:46','LIS','1488000','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-261013-0008','D','2026-10-13','10:07:46','input','PENJUALAN','F326131007451','7845845000','1488000','7847333000');
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 ('F326131014391','input','1',' MEE2 X UB ','TOKO','PM-E','E2E-ZIBE-207-0','CC X MODEL MATA UB 14 8K ','','0.500','1','100.00','521000','0','0','15000','521000','0','0','0','521000','LIS','00425582','E2E','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZIBE-207-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='E2E-ZIBE-207-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326131014391','2026-10-13','0.500','2026-10-13','10:14:39','PLG0031839','521000','521000','0','521000','521000','input','2026-10-13 10:14:39','F32613101439');
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-10-13','F326131014391','2026-10-13','10:14:39','LIS','521000','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-261013-0009','D','2026-10-13','10:14:39','input','PENJUALAN','F326131014391','7847333000','521000','7847854000');
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 ('F326131024201','input','1',' MDE2 X BM ','TOKO','PM-E','E2D-ZCXB-54-0','CC X MODEL MATA HITAM BM 16 8K ','','0.930','1','100.00','951000','0','0','15000','951000','0','0','0','951000','FIT','00391477','E2D','0','0','-','0','1023000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCXB-54-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='E2D-ZCXB-54-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326131024201','2026-10-13','0.930','2026-10-13','10:24:20','PLG0031840','951000','951000','0','951000','951000','input','2026-10-13 10:24:20','F32613102420');
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-10-13','F326131024201','2026-10-13','10:24:20','FIT','951000','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-261013-0010','D','2026-10-13','10:24:20','input','PENJUALAN','F326131024201','7847854000','951000','7848805000');
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 ('F326131033131','input','1',' MEF1 X PM ','TOKO','PM-F','F1E-ZIBE-74-0','GL X BANGKOK HOLLOW LASER PM 58 8K ','','4.970','1','100.00','5184000','0','0','15000','5185000','0','0','0','5185000','AAT','00425449','F1E','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZIBE-74-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.970',berat_jual_asli=berat_jual_asli+'4.970',stock_jual='1',berat_akhir=berat_akhir-'4.970',berat_akhir_asli=berat_akhir_asli-'4.970',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='F1E-ZIBE-74-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326131033131','2026-10-13','4.970','2026-10-13','10:33:14','PLG0031841','5185000','5185000','0','5185000','5185000','input','2026-10-13 10:33:13','F32613103313');
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-10-13','F326131033131','2026-10-13','10:33:14','AAT','5185000','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-261013-0011','D','2026-10-13','10:33:14','input','PENJUALAN','F326131033131','7848805000','5185000','7853990000');
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-00020511','X-00020511','CC X MODEL SPECTRA SLEP KH 14 8K','GR','---','E1F','BELI','BELI001','332000','2026-10-13','0.350','1','kasir','2026-10-13 10:41:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00020511','X-00020511');
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-261013-0001','F326011224411','AAT','1','BELI','BELI001','E1F', 'X-00020511', 'CC X MODEL SPECTRA SLEP KH 14 8K','0.350','0.350','100.00','370000','332000','948571','1063000','1','332000','332000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.350',berat_beli_asli=berat_beli_asli+'0.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.350',berat_akhir_asli=berat_akhir_asli+'0.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' 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-261013-0001','2026-10-13','2026-10-13','10:41:14','AAT','---','0.350','332000','332000','332000','332000','332000','kasir','2026-10-13 10:41:14','FB-261013-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0001','AYUK','SLOGOHIMO','','','','kasir','2026-10-13 10:41:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0012','K','2026-10-13','10:41:14','kasir','PEMBELIAN UMUM','FB-261013-0001','7853990000','332000','7853658000');
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-00020512','X-00020512','AT X DAISY MATA LG 8K','GR','---','A1D','BELI','BELI001','727000','2026-10-13','1.010','1','kasir','2026-10-13 10:41:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00020512','X-00020512');
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-261013-0002','F326311051221','FIT','1','BELI','BELI001','A1D', 'X-00020512', 'AT X DAISY MATA LG 8K','1.010','1.010','100.00','1100000','727000','719802','1023000','1','727000','727000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.010',berat_beli_asli=berat_beli_asli+'1.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.010',berat_akhir_asli=berat_akhir_asli+'1.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' 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-261013-0002','2026-10-13','2026-10-13','10:41:41','FIT','---','1.010','727000','727000','727000','727000','727000','kasir','2026-10-13 10:41:41','FB-261013-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0002','SARTINI','BITING BADEGAN','','','','kasir','2026-10-13 10:41:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0013','K','2026-10-13','10:41:41','kasir','PEMBELIAN UMUM','FB-261013-0002','7853658000','727000','7852931000');
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-00020513','X-00020513','GL RANTAI HOLLOW P3 POLOS UB 8K','GR','---','F3E','BELI','BELI001','1143000','2026-10-13','1.180','1','kasir','2026-10-13 10:42:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020513','X-00020513');
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-261013-0003','F326280830161','FIT','1','BELI','BELI001','F3E', 'X-00020513', 'GL RANTAI HOLLOW P3 POLOS UB 8K','1.180','1.180','100.00','1333000','1143000','968644','1053000','1','1143000','1143000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.180',berat_beli_asli=berat_beli_asli+'1.180',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.180',berat_akhir_asli=berat_akhir_asli+'1.180',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-13' 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-261013-0003','2026-10-13','2026-10-13','10:42:13','FIT','---','1.180','1143000','1143000','1143000','1143000','1143000','kasir','2026-10-13 10:42:13','FB-261013-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0003','WAHYU','NGAGLIK BULUKERTO','','','088215591518','kasir','2026-10-13 10:42:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0014','K','2026-10-13','10:42:13','kasir','PEMBELIAN UMUM','FB-261013-0003','7852931000','1143000','7851788000');
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-00020514','X-00020514','KL KADAR 8K','GR','---','H1E','BELI','BELI001','1540000','2026-10-13','2.150','1','kasir','2026-10-13 10:43:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020514','X-00020514');
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-261013-0004','F323070851101','LIS','1','BELI','BELI001','H1E', 'X-00020514', 'KL KADAR 8K','2.150','2.150','100.00','1050000','1540000','716279','1053000','1','1540000','1540000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.150',berat_beli_asli=berat_beli_asli+'2.150',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.150',berat_akhir_asli=berat_akhir_asli+'2.150',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' 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-261013-0004','2026-10-13','2026-10-13','10:43:17','LIS','---','2.150','1540000','1540000','1540000','1540000','1540000','kasir','2026-10-13 10:43:18','FB-261013-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0004','CALISTA','PURWANTORO','','','','kasir','2026-10-13 10:43:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0015','K','2026-10-13','10:43:17','kasir','PEMBELIAN UMUM','FB-261013-0004','7851788000','1540000','7850248000');
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-00020515','X-00020515','LT COR M 8K','GR','---','D2E','BELI','BELI001','300000','2026-10-13','0.500','1','kasir','2026-10-13 10:44:22');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00020515','X-00020515');
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-261013-0005','F323070851102','LIS','1','BELI','BELI001','D2E', 'X-00020515', 'LT COR M 8K','0.500','0.500','100.00','245000','300000','600000','1053000','1','300000','300000','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-10-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' 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-261013-0005','2026-10-13','2026-10-13','10:44:21','LIS','---','0.500','300000','300000','300000','300000','300000','kasir','2026-10-13 10:44:22','FB-261013-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0005','CALISTA','PURWANTORO','','','','kasir','2026-10-13 10:44:22');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0016','K','2026-10-13','10:44:21','kasir','PEMBELIAN UMUM','FB-261013-0005','7850248000','300000','7849948000');
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-00020516','X-00020516','GL COR T 8K','GR','---','F1E','BELI','BELI001','2080000','2026-10-13','2.850','1','kasir','2026-10-13 10:46:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020516','X-00020516');
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-261013-0006','F323281137581','SIN','1','BELI','BELI001','F1E', 'X-00020516', 'GL COR T 8K','2.850','2.850','100.00','1397000','2080000','729825','1053000','1','2080000','2080000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.850',berat_beli_asli=berat_beli_asli+'2.850',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.850',berat_akhir_asli=berat_akhir_asli+'2.850',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-13' 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-261013-0006','2026-10-13','2026-10-13','10:46:25','SIN','---','2.850','2080000','2080000','2080000','2080000','2080000','kasir','2026-10-13 10:46:25','FB-261013-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0006','ANISA','TERBIS KISMANTORO','','','','kasir','2026-10-13 10:46:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0017','K','2026-10-13','10:46:25','kasir','PEMBELIAN UMUM','FB-261013-0006','7849948000','2080000','7847868000');
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-00020517','X-00020517','GL XXX PIPA MATA PM 54 8K','GR','---','F2E','BELI','BELI001','3820000','2026-10-13','4.000','1','kasir','2026-10-13 10:46:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00020517','X-00020517');
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-261013-0007','F326261135211','SIN','1','BELI','BELI001','F2E', 'X-00020517', 'GL XXX PIPA MATA PM 54 8K','4.000','4.000','100.00','4020000','3820000','955000','1053000','1','3820000','3820000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.000',berat_beli_asli=berat_beli_asli+'4.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.000',berat_akhir_asli=berat_akhir_asli+'4.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2E' 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-261013-0007','2026-10-13','2026-10-13','10:46:44','SIN','---','4.000','3820000','3820000','3820000','3820000','3820000','kasir','2026-10-13 10:46:44','FB-261013-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0007','TRI MARYUTI','TEMON PAGERUKIR','','','','kasir','2026-10-13 10:46:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0018','K','2026-10-13','10:46:44','kasir','PEMBELIAN UMUM','FB-261013-0007','7847868000','3820000','7844048000');
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-00020518','X-00020518','CC MODEL MATA VAR LG 13 8K','GR','---','E2E','BELI','BELI001','485000','2026-10-13','0.500','1','kasir','2026-10-13 10:47:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020518','X-00020518');
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-261013-0008','F325180923251','FIT','1','BELI','BELI001','E2E', 'X-00020518', 'CC MODEL MATA VAR LG 13 8K','0.500','0.500','100.00','530000','485000','970000','1053000','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-10-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-261013-0008','2026-10-13','2026-10-13','10:47:02','FIT','---','0.500','485000','485000','485000','485000','485000','kasir','2026-10-13 10:47:02','FB-261013-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0008','PIPIN','WATU BONANG','','','','kasir','2026-10-13 10:47:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0019','K','2026-10-13','10:47:02','kasir','PEMBELIAN UMUM','FB-261013-0008','7844048000','485000','7843563000');
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-00020519','X-00020519','CC X MODEL DAUN SLEP LG 16 8K','GR','---','E1E','BELI','BELI001','450000','2026-10-13','0.460','1','kasir','2026-10-13 10:47:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020519','X-00020519');
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-261013-0009','F326190900021','SIN','1','BELI','BELI001','E1E', 'X-00020519', 'CC X MODEL DAUN SLEP LG 16 8K','0.460','0.460','100.00','488000','450000','978261','1053000','1','450000','450000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.460',berat_beli_asli=berat_beli_asli+'0.460',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.460',berat_akhir_asli=berat_akhir_asli+'0.460',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-13' 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-261013-0009','2026-10-13','2026-10-13','10:47:33','SIN','---','0.460','450000','450000','450000','450000','450000','kasir','2026-10-13 10:47:34','FB-261013-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0009','ANIK','NGROTO KISMANTORO','','','','kasir','2026-10-13 10:47:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0020','K','2026-10-13','10:47:33','kasir','PEMBELIAN UMUM','FB-261013-0009','7843563000','450000','7843113000');
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 ('F326131058101','kasir','1',' MEF1 HW 40','TOKO','PM-F','F1E-ZIBH-413-0','GL BANGKOK ANAK C HW 40 8K ','','1.780','1','100.00','1857000','0','0','15000','1858000','0','0','0','1858000','LIS','00426392','F1E','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZIBH-413-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.780',berat_jual_asli=berat_jual_asli+'1.780',stock_jual='1',berat_akhir=berat_akhir-'1.780',berat_akhir_asli=berat_akhir_asli-'1.780',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='F1E-ZIBH-413-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326131058101','2026-10-13','1.780','2026-10-13','10:58:11','PLG0031842','1858000','1858000','0','1858000','1858000','kasir','2026-10-13 10:58:10','F32613105810');
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-10-13','F326131058101','2026-10-13','10:58:11','LIS','1858000','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-261013-0021','D','2026-10-13','10:58:11','kasir','PENJUALAN','F326131058101','7843113000','1858000','7844971000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1858000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326131058101' 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 ('F326131058102','kasir',' 1',' MEE2 X 5K ','TOKO','PM-E','E2E-ZCBD-129-0','CC X BONEKA NAK CAT MATA LG 8K ','','0.520','1','100.00','542000','0','0','15000','542000','0','5000','0','547000','LIS','00396609','E2E','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCBD-129-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-10-13' AND kode_barang='E2E-ZCBD-129-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326131058102','2026-10-13','0.520','2026-10-13','10:58:11','PLG0031843','542000','542000','5000','547000','547000','kasir','2026-10-13 10:58:10','F32613105810');
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-10-13','F326131058102','2026-10-13','10:58:11','LIS','547000','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-261013-0022','D','2026-10-13','10:58:11','kasir','PENJUALAN','F326131058102','7844971000','547000','7845518000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='547000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326131058102' 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 ('F326131059191','kasir','1',' MGB1G X LG','TOKO','PM-B','B1G-ZIAX-200-0','GW X MODEL TAUGE MRICAN SLEP LG 8K ','','0.310','1','100.00','336000','0','0','15000','335000','0','0','0','335000','SIN','00423004','B1G','0','0','-','1','1083000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZIAX-200-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='B1G-ZIAX-200-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' 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 ('F326131059191','2026-10-13','0.310','2026-10-13','10:59:19','PLG0031844','335000','335000','0','335000','335000','kasir','2026-10-13 10:59:19','F32613105919');
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-10-13','F326131059191','2026-10-13','10:59:19','SIN','335000','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-261013-0023','D','2026-10-13','10:59:19','kasir','PENJUALAN','F326131059191','7845518000','335000','7845853000');
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 ('F326131100431','kasir','1',' MDA1D X UB','TOKO','PM-A','A1D-ZIBH-3-0','AT X ITALY SLEP VAR UB 8K ','','1.060','1','100.00','1084000','0','0','15000','1085000','0','0','0','1085000','AAT','00425982','A1D','0','0','-','0','1023000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZIBH-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='A1D-ZIBH-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326131100431','2026-10-13','1.060','2026-10-13','11:00:43','PLG0031845','1085000','1085000','0','1085000','1085000','kasir','2026-10-13 11:00:43','F32613110043');
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-10-13','F326131100431','2026-10-13','11:00:43','AAT','1085000','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-261013-0024','D','2026-10-13','11:00:43','kasir','PENJUALAN','F326131100431','7845853000','1085000','7846938000');
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 ('F326131109311','kasir','1',' MDE2 CM 14','TOKO','PM-E','E2D-ZJXE-364-0','CC WEDDING MATA CM 14 8K ','','0.860','1','100.00','880000','0','0','15000','880000','0','0','0','880000','FIT','00427855','E2D','0','0','-','0','1023000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZJXE-364-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='E2D-ZJXE-364-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326131109311','2026-10-13','0.860','2026-10-13','11:09:32','PLG0031846','880000','880000','0','880000','880000','kasir','2026-10-13 11:09:31','F32613110931');
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-10-13','F326131109311','2026-10-13','11:09:32','FIT','880000','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-261013-0025','D','2026-10-13','11:09:32','kasir','PENJUALAN','F326131109311','7846938000','880000','7847818000');
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 ('F326131118211','kasir','1',' MDE2 X UB ','TOKO','PM-E','E2D-ZCAI-355-0','CC X MODEL MATA UB 10 8K ','','1.280','1','100.00','1309000','0','0','15000','1310000','0','0','0','1310000','AAT','00395753','E2D','0','0','-','0','1023000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAI-355-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='E2D-ZCAI-355-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326131118211','2026-10-13','1.280','2026-10-13','11:18:22','PLG0031847','1310000','1310000','0','1310000','1310000','kasir','2026-10-13 11:18:21','F32613111821');
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-10-13','F326131118211','2026-10-13','11:18:22','AAT','1310000','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-261013-0026','D','2026-10-13','11:18:22','kasir','PENJUALAN','F326131118211','7847818000','1310000','7849128000');
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-00020520','X-00020520','CC COR M 8K','GR','---','E2E','BELI','BELI001','1425000','2026-10-13','1.980','1','kasir','2026-10-13 11:22:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020520','X-00020520');
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-261013-0010','F323040946462','FIT','1','BELI','BELI001','E2E', 'X-00020520', 'CC COR M 8K','2.000','1.980','100.00','890000','1425000','719697','1053000','1','1425000','1425000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.980',berat_beli_asli=berat_beli_asli+'1.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.980',berat_akhir_asli=berat_akhir_asli+'1.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-261013-0010','2026-10-13','2026-10-13','11:22:23','FIT','---','1.980','1425000','1425000','1425000','1425000','1425000','kasir','2026-10-13 11:22:24','FB-261013-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0010','AMEL','JATISRONO','','','','kasir','2026-10-13 11:22:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0027','K','2026-10-13','11:22:23','kasir','PEMBELIAN UMUM','FB-261013-0010','7849128000','1425000','7847703000');
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-00020521','X-00020521','AT BABY TINDIK CM 8K','GR','---','A1G','BELI','BELI001','265000','2026-10-13','0.270','1','kasir','2026-10-13 11:23:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1G','X-00020521','X-00020521');
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-261013-0011','F326291110061','SIN','1','BELI','BELI001','A1G', 'X-00020521', 'AT BABY TINDIK CM 8K','0.270','0.270','100.00','310000','265000','981481','1083000','1','265000','265000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.270',berat_beli_asli=berat_beli_asli+'0.270',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.270',berat_akhir_asli=berat_akhir_asli+'0.270',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1G' 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-261013-0011','2026-10-13','2026-10-13','11:23:54','SIN','---','0.270','265000','265000','265000','265000','265000','kasir','2026-10-13 11:23:54','FB-261013-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0011','MELIN','BULUKERTO','','','','kasir','2026-10-13 11:23:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0028','K','2026-10-13','11:23:54','kasir','PEMBELIAN UMUM','FB-261013-0011','7847703000','265000','7847438000');
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 ('F326131155301','kasir','1',' TEB1 X LG ','TOKO','PT-B','B1TE-YIXE-6-T','GW X TUSUK MODEL MATA VAR LG 17K ','','0.550','1','100.00','1061000','0','0','15000','1060000','0','0','0','1060000','FIT','T0072976','B1TE','0','0','-','1','1940000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TE-YIXE-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='B1TE-YIXE-6-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-B' 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 ('F326131155301','2026-10-13','0.550','2026-10-13','11:55:31','PLG0031848','1060000','1060000','0','1060000','1060000','kasir','2026-10-13 11:55:30','F32613115530');
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-10-13','F326131155301','2026-10-13','11:55:31','FIT','1060000','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-261013-0029','D','2026-10-13','11:55:31','kasir','PENJUALAN','F326131155301','7847438000','1060000','7848498000');
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 ('F326131158101','kasir','1',' TEE1 KH 12','TOKO','PT-E','E1TE-ZJAX-56-T','CC MODEL BUNGA CLOVER SLEP KH 12 17K ','','0.460','1','100.00','892000','0','0','15000','888000','0','0','0','888000','FIT','T0086294','E1TE','0','0','-','1','1940000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-ZJAX-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='E1TE-ZJAX-56-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326131158101','2026-10-13','0.460','2026-10-13','11:58:10','PLG0031849','888000','888000','0','888000','888000','kasir','2026-10-13 11:58:10','F32613115810');
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-10-13','F326131158101','2026-10-13','11:58:10','FIT','888000','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-261013-0030','D','2026-10-13','11:58:10','kasir','PENJUALAN','F326131158101','7848498000','888000','7849386000');
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-00020522','X-00020522','CC MODEL HATI MATA VAR YT 20 8K','GR','---','E2E','BELI','BELI001','735000','2026-10-13','0.760','1','kasir','2026-10-13 12:12:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020522','X-00020522');
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-261013-0012','F325190207531','AAT','1','BELI','BELI001','E2E', 'X-00020522', 'CC MODEL HATI MATA VAR YT 20 8K','0.760','0.760','100.00','810000','735000','967105','1053000','1','735000','735000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.760',berat_beli_asli=berat_beli_asli+'0.760',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.760',berat_akhir_asli=berat_akhir_asli+'0.760',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-261013-0012','2026-10-13','2026-10-13','12:12:53','AAT','---','0.760','735000','735000','735000','735000','735000','kasir','2026-10-13 12:12:54','FB-261013-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0012','SHEILA','GONDANG PURWANTORO','','','','kasir','2026-10-13 12:12:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0031','K','2026-10-13','12:12:53','kasir','PEMBELIAN UMUM','FB-261013-0012','7849386000','735000','7848651000');
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 ('F326130110221','kasir','1',' TEE1 KH 12','TOKO','PT-E','E1TE-ZJAX-57-T','CC MODEL BUNGA CLOVER SLEP KH 12 17K ','OLW','0.460','1','100.00','892000','0','0','15000','893000','0','7000','0','900000','SIN','T0086295','E1TE','0','0','-','0','1940000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-ZJAX-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='E1TE-ZJAX-57-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326130110221','2026-10-13','0.460','2026-10-13','13:10:22','PLG0031850','893000','893000','7000','900000','900000','kasir','2026-10-13 13:10:22','F32613011022');
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-10-13','F326130110221','2026-10-13','13:10:22','SIN','900000','7000');
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-261013-0032','D','2026-10-13','13:10:22','kasir','PENJUALAN','F326130110221','7848651000','900000','7849551000');
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 ('F326130117301','kasir','1',' TEE2 KH 14','TOKO','PT-E','E2TE-ZJAX-54-T','CC MODEL SNAKE MATA VAR KH 14 17K ','','0.650','1','100.00','1261000','0','0','15000','1255000','0','0','0','1255000','AAT','T0086292','E2TE','0','0','-','1','1940000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-ZJAX-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='E2TE-ZJAX-54-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326130117301','2026-10-13','0.650','2026-10-13','13:17:31','PLG0031851','1255000','1255000','0','1255000','1255000','kasir','2026-10-13 13:17:30','F32613011730');
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-10-13','F326130117301','2026-10-13','13:17:31','AAT','1255000','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-261013-0033','D','2026-10-13','13:17:31','kasir','PENJUALAN','F326130117301','7849551000','1255000','7850806000');
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-00020523','X-00020523','GL X OVAL C SLEP UB 58 8K','GR','---','F1E','BELI','BELI001','2232000','2026-10-13','2.280','1','kasir','2026-10-13 13:42:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020523','X-00020523');
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-261013-0013','F326230958401','SIN','1','BELI','BELI001','F1E', 'X-00020523', 'GL X OVAL C SLEP UB 58 8K','2.280','2.280','100.00','2401000','2232000','978947','1053000','1','2232000','2232000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.280',berat_beli_asli=berat_beli_asli+'2.280',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.280',berat_akhir_asli=berat_akhir_asli+'2.280',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-13' 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-261013-0013','2026-10-13','2026-10-13','13:42:03','SIN','---','2.280','2232000','2232000','2232000','2232000','2232000','kasir','2026-10-13 13:42:04','FB-261013-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0013','YANTI','SAMBIREJO','','','','kasir','2026-10-13 13:42:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0034','K','2026-10-13','13:42:03','kasir','PEMBELIAN UMUM','FB-261013-0013','7850806000','2232000','7848574000');
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 ('F326130215581','input','1',' MEE2 KH 12','TOKO','PM-E','E2E-ZJXE-380-0','CC MODEL SNAKE MATA KH 12 8K ','','0.500','1','100.00','521000','0','0','15000','521000','0','0','0','521000','SIN','00427871','E2E','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZJXE-380-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='E2E-ZJXE-380-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326130215581','2026-10-13','0.500','2026-10-13','14:15:59','PLG0031852','521000','521000','0','521000','521000','input','2026-10-13 14:15:58','F32613021558');
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-10-13','F326130215581','2026-10-13','14:15:59','SIN','521000','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-261013-0035','D','2026-10-13','14:15:59','input','PENJUALAN','F326130215581','7848574000','521000','7849095000');
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 ('F326130216471','input','1',' MEE1 LG 16','TOKO','PM-E','E1E-ZGXA-320-0','CC MODEL ISYANA SLEP LG 16 8K','','0.560','1','100.00','584000','0','0','15000','584000','0','0','0','584000','LIS','00411844','E1E','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXA-320-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='E1E-ZGXA-320-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326130216471','2026-10-13','0.560','2026-10-13','14:16:48','PLG0031853','584000','584000','0','584000','584000','input','2026-10-13 14:16:47','F32613021647');
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-10-13','F326130216471','2026-10-13','14:16:48','LIS','584000','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-261013-0036','D','2026-10-13','14:16:48','input','PENJUALAN','F326130216471','7849095000','584000','7849679000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='584000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326130216471' 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 ('F326130216472','input',' 1',' MEE2 KH 16','TOKO','PM-E','E2E-ZJXE-375-0','CC MODEL SNAKE MATA KH 16 8K ','','0.500','1','100.00','521000','0','0','15000','521000','0','0','0','521000','LIS','00427866','E2E','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZJXE-375-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='E2E-ZJXE-375-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326130216472','2026-10-13','0.500','2026-10-13','14:16:48','PLG0031854','521000','521000','0','521000','521000','input','2026-10-13 14:16:47','F32613021647');
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-10-13','F326130216472','2026-10-13','14:16:48','LIS','521000','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-261013-0037','D','2026-10-13','14:16:48','input','PENJUALAN','F326130216472','7849679000','521000','7850200000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='521000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326130216472' 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 ('F326130217271','input','1',' MFE2 KH 16','TOKO','PM-E','E2F-ZIAE-283-0','CC MODEL PAKU MATA VAR KH 16 8K ','','0.400','1','100.00','425000','0','0','15000','425000','0','0','0','425000','LIS','00423819','E2F','0','0','-','0','1063000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZIAE-283-0' 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-10-13' AND kode_barang='E2F-ZIAE-283-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326130217271','2026-10-13','0.400','2026-10-13','14:17:28','PLG0031855','425000','425000','0','425000','425000','input','2026-10-13 14:17:27','F32613021727');
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-10-13','F326130217271','2026-10-13','14:17:28','LIS','425000','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-261013-0038','D','2026-10-13','14:17:28','input','PENJUALAN','F326130217271','7850200000','425000','7850625000');
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 ('F326130222431','input','1',' MFE2 KH 10','TOKO','PM-E','E2F-ZJXA-101-0','CC MODEL MATA VAR KH 10 8K ','','0.350','1','100.00','372000','0','0','15000','372000','0','0','0','372000','SIN','00426734','E2F','0','0','-','0','1063000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZJXA-101-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='E2F-ZJXA-101-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326130222431','2026-10-13','0.350','2026-10-13','14:22:44','PLG0031856','372000','372000','0','372000','372000','input','2026-10-13 14:22:43','F32613022243');
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-10-13','F326130222431','2026-10-13','14:22:44','SIN','372000','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-261013-0039','D','2026-10-13','14:22:44','input','PENJUALAN','F326130222431','7850625000','372000','7850997000');
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 ('F326130235171','input','1',' MEE2 UB 16','TOKO','PM-E','E2E-ZIAE-291-0','CC MODEL PAKU MATA VAR UB 16 8K ','','0.500','1','100.00','521000','0','0','15000','521000','0','0','0','521000','LIS','00423827','E2E','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZIAE-291-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='E2E-ZIAE-291-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326130235171','2026-10-13','0.500','2026-10-13','14:35:18','PLG0031857','521000','521000','0','521000','521000','input','2026-10-13 14:35:17','F32613023517');
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-10-13','F326130235171','2026-10-13','14:35:18','LIS','521000','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-261013-0040','D','2026-10-13','14:35:18','input','PENJUALAN','F326130235171','7850997000','521000','7851518000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='521000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326130235171' 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 ('F326130235172','input',' 1',' MEE2 KH 16','TOKO','PM-E','E2E-ZJXE-374-0','CC MODEL SNAKE MATA KH 16 8K ','','0.510','1','100.00','532000','0','0','15000','532000','0','0','0','532000','LIS','00427865','E2E','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZJXE-374-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='E2E-ZJXE-374-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326130235172','2026-10-13','0.510','2026-10-13','14:35:18','PLG0031858','532000','532000','0','532000','532000','input','2026-10-13 14:35:17','F32613023517');
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-10-13','F326130235172','2026-10-13','14:35:18','LIS','532000','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-261013-0041','D','2026-10-13','14:35:18','input','PENJUALAN','F326130235172','7851518000','532000','7852050000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='532000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326130235172' LIMIT 1;
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-00020524','X-00020524','GL MODEL FLIK PITA VAR HW 8K','GR','---','F3E','BELI','BELI001','1562000','2026-10-13','1.990','1','kasir','2026-10-13 14:59:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020524','X-00020524');
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-261013-0014','F325050205371','FIT','1','BELI','BELI001','F3E', 'X-00020524', 'GL MODEL FLIK PITA VAR HW 8K','1.990','1.990','100.00','1663000','1562000','784925','1053000','1','1562000','1562000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.990',berat_beli_asli=berat_beli_asli+'1.990',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.990',berat_akhir_asli=berat_akhir_asli+'1.990',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-13' 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-261013-0014','2026-10-13','2026-10-13','14:59:18','FIT','---','1.990','1562000','1562000','1562000','1562000','1562000','kasir','2026-10-13 14:59:18','FB-261013-0014');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0014','CIKA','SUKOMANGU','','','','kasir','2026-10-13 14:59:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-13' 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-261013-0042','K','2026-10-13','14:59:18','kasir','PEMBELIAN UMUM','FB-261013-0014','7852050000','1562000','7850488000');
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 ('F326130305311','kasir','1',' MEF3E X HW','TOKO','PM-F','F3E-ZHCA-25-0','GL X CASTELI SLEP HW 8K ','','0.970','1','100.00','1012000','0','0','15000','1011000','0','0','0','1011000','LIS','00421313','F3E','0','0','-','1','1053000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHCA-25-0' 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-10-13' AND kode_barang='F3E-ZHCA-25-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326130305311','2026-10-13','0.970','2026-10-13','15:05:31','PLG0031859','1011000','1011000','0','1011000','1011000','kasir','2026-10-13 15:05:31','F32613030531');
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-10-13','F326130305311','2026-10-13','15:05:31','LIS','1011000','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-261013-0043','D','2026-10-13','15:05:31','kasir','PENJUALAN','F326130305311','7850488000','1011000','7851499000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1011000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326130305311' 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 ('F326130305312','kasir',' 1',' MEE1 LG 16','TOKO','PM-E','E1E-ZGXA-322-0','CC MODEL ISYANA SLEP LG 16 8K','','0.550','1','100.00','574000','0','0','15000','574000','0','0','0','574000','LIS','00411846','E1E','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXA-322-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='E1E-ZGXA-322-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326130305312','2026-10-13','0.550','2026-10-13','15:05:31','PLG0031860','574000','574000','0','574000','574000','kasir','2026-10-13 15:05:31','F32613030531');
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-10-13','F326130305312','2026-10-13','15:05:31','LIS','574000','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-261013-0044','D','2026-10-13','15:05:31','kasir','PENJUALAN','F326130305312','7851499000','574000','7852073000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='574000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326130305312' LIMIT 1;
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0013';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130110221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130110221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130110221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130117301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130117301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130117301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130215581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130215581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130215581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130216471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130216471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130216471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130216472' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130216472' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130216472';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130217271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130217271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130217271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130222431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130222431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130222431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130235171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130235171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130235171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130235172' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130235172' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130235172';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130305311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130305311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130305311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130305312' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130305312' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130305312';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130823161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130823161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130823161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130913371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130913371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130913371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130913372' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130913372' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130913372';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130913373' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130913373' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130913373';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130913374' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130913374' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130913374';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326130918121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326130918121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326130918121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131007451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131007451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131007451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131014391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131014391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131014391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131024201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131024201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131024201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131033131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131033131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131033131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131058101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131058101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131058101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131058102' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131058102' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131058102';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131059191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131059191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131059191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131100431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131100431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131100431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131109311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131109311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131109311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131118211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131118211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131118211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131155301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131155301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131155301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326131158101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326131158101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326131158101';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-14','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-13';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-13';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-13';
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-10-13' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-13';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-13';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-13';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-13';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09';
UPDATE tt_barang_saldo SET tanggal= '2026-10-14' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-13' 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-261014-0001','D','2026-10-14','15:19:48','SYSTEM','SALDO AWAL','SALDO AWAL','0','7852073000','7852073000');
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-261014-0001','D','2026-10-14','15:19:48','BCA','SALDO AWAL','SALDO AWAL','0','743627000','743627000');
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-261014-0001','D','2026-10-14','15:19:48','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-261014-0001','D','2026-10-14','15:19:48','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-10-14';