INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260407-0001','1','F1E-YLAH-9-T','1','2.590','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YLAH-9-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F1E-YLAH-9-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='ME' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='ME' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-F';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-F';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='F1E-YLAH-9-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.590',berat_out_asli='2.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.590',berat_akhir_asli =berat_akhir_asli-'2.590' WHERE kode_barang='F1E-YLAH-9-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260407-0001','2026-04-07','2026-04-07','08:05','2.590','input','260407');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260407-0002','1','A1TD-ZDXF-30-T','1','0.980','TOKO','PTBK-A');
DELETE FROM tm_barang_export WHERE kode_barang='A1TD-ZDXF-30-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='A1TD-ZDXF-30-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TD' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='A1TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='A1TD' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-A';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-A';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='A1TD-ZDXF-30-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.980',berat_out_asli='0.980', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.980',berat_akhir_asli =berat_akhir_asli-'0.980' WHERE kode_barang='A1TD-ZDXF-30-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260407-0002','2','A1TD-ZDXF-31-T','1','1.050','TOKO','PTBK-A');
DELETE FROM tm_barang_export WHERE kode_barang='A1TD-ZDXF-31-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='A1TD-ZDXF-31-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TD' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='A1TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='A1TD' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-A';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-A';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='A1TD-ZDXF-31-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.050',berat_out_asli='1.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.050',berat_akhir_asli =berat_akhir_asli-'1.050' WHERE kode_barang='A1TD-ZDXF-31-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260407-0002','2026-04-07','2026-04-07','08:06','1.050','input','260407');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260407-0003','1','D1TE-ZDXF-32-T','1','0.430','TOKO','PTBK-D');
DELETE FROM tm_barang_export WHERE kode_barang='D1TE-ZDXF-32-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='D1TE-ZDXF-32-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='D1TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='D1TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-D';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-D';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='D1TE-ZDXF-32-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.430',berat_out_asli='0.430', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.430',berat_akhir_asli =berat_akhir_asli-'0.430' WHERE kode_barang='D1TE-ZDXF-32-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260407-0003','2026-04-07','2026-04-07','08:06','0.430','input','260407');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260407-0004','1','E1TE-ZDXF-33-T','1','0.650','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E1TE-ZDXF-33-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E1TE-ZDXF-33-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='E1TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E1TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-E';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E1TE-ZDXF-33-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.650',berat_out_asli='0.650', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.650',berat_akhir_asli =berat_akhir_asli-'0.650' WHERE kode_barang='E1TE-ZDXF-33-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260407-0004','2','E1TD-ZDXF-34-T','1','1.050','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E1TD-ZDXF-34-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E1TD-ZDXF-34-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TD' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='E1TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E1TD' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-E';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E1TD-ZDXF-34-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.050',berat_out_asli='1.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.050',berat_akhir_asli =berat_akhir_asli-'1.050' WHERE kode_barang='E1TD-ZDXF-34-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260407-0004','2026-04-07','2026-04-07','08:06','1.050','input','260407');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260407-0005','1','H1TE-ZDXF-35-T','1','2.130','TOKO','PTBK-H');
DELETE FROM tm_barang_export WHERE kode_barang='H1TE-ZDXF-35-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='H1TE-ZDXF-35-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='H1TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='H1TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-H';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-H';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='H1TE-ZDXF-35-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.130',berat_out_asli='2.130', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.130',berat_akhir_asli =berat_akhir_asli-'2.130' WHERE kode_barang='H1TE-ZDXF-35-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260407-0005','2','H1TE-ZDXF-36-T','1','4.100','TOKO','PTBK-H');
DELETE FROM tm_barang_export WHERE kode_barang='H1TE-ZDXF-36-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='H1TE-ZDXF-36-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='H1TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='H1TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-H';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-H';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='H1TE-ZDXF-36-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.100',berat_out_asli='4.100', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.100',berat_akhir_asli =berat_akhir_asli-'4.100' WHERE kode_barang='H1TE-ZDXF-36-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260407-0005','3','H1TE-ZDXF-37-T','1','3.070','TOKO','PTBK-H');
DELETE FROM tm_barang_export WHERE kode_barang='H1TE-ZDXF-37-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='H1TE-ZDXF-37-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='H1TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='H1TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-H';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-H';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='H1TE-ZDXF-37-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.070',berat_out_asli='3.070', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.070',berat_akhir_asli =berat_akhir_asli-'3.070' WHERE kode_barang='H1TE-ZDXF-37-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260407-0005','2026-04-07','2026-04-07','08:06','3.070','input','260407');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0001','1','F3E-YLXB-11-T','1','5.270','5.270','TOKO','SMBK-F','TOKO','BK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-F' WHERE kode_barang='F3E-YLXB-11-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-07','TOKO','BK-F','F3E','F3E-YLXB-11-T','100.00','1','5.270','5.270','1','5.270','5.270');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.270',berat_out_asli=berat_out_asli+'5.270',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-07' AND kode_barang='F3E-YLXB-11-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260407-0001','2026-04-07','2026-04-07','08:18','5.27','admin','2026-04-07 08:19:19');
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 ('F226070944051','kasir','1',' MFE1 5K BG','TOKO','SMBK-E','E1F-YJBA-25-T','CC MODEL SLEP PASIR BG 11 8K ','','0.380','1','100.00','448000','0','0','15000','448000','0','5000','0','453000','RTA','T0074346','E1F','0','0','-','0','1180000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-YJBA-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='E1F-YJBA-25-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070944051','2026-04-07','0.380','2026-04-07','09:44:05','PLG0078880','448000','448000','5000','453000','453000','kasir','2026-04-07 09:44:05','F22607094405');
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-04-07','F226070944051','2026-04-07','09:44:05','RTA','453000','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-260407-0002','D','2026-04-07','09:44:05','kasir','PENJUALAN','F226070944051','8192027000','453000','8192480000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='453000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070944051' 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 ('F226070944052','kasir',' 1',' MEH1 KH 42','TOKO','SMBK-H','H1E-ZCBX-22-T','KL SIEM COBRA KH 42CM 8K ','','1.260','1','100.00','1462000','0','0','15000','1462000','0','0','0','1462000','RTA','T0078232','H1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCBX-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.260',berat_jual_asli=berat_jual_asli+'1.260',stock_jual='1',berat_akhir=berat_akhir-'1.260',berat_akhir_asli=berat_akhir_asli-'1.260',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='H1E-ZCBX-22-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070944052','2026-04-07','1.260','2026-04-07','09:44:05','PLG0078881','1462000','1462000','0','1462000','1462000','kasir','2026-04-07 09:44:05','F22607094405');
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-04-07','F226070944052','2026-04-07','09:44:05','RTA','1462000','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-260407-0003','D','2026-04-07','09:44:05','kasir','PENJUALAN','F226070944052','8192480000','1462000','8193942000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1462000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070944052' 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 ('F226070947251','kasir','1',' TDE2 X CM ','TOKO','TBK-E','E2TD-YIXD-65-T','CC X MODEL MATA VAR CM 14 17K ','OL H','1.310','1','100.00','2725000','0','0','15000','2732000','0','13000','0','2745000','NS','T0072917','E2TD','0','0','-','0','2080000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YIXD-65-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.310',berat_jual_asli=berat_jual_asli+'1.310',stock_jual='1',berat_akhir=berat_akhir-'1.310',berat_akhir_asli=berat_akhir_asli-'1.310',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='E2TD-YIXD-65-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226070947251','2026-04-07','1.310','2026-04-07','09:47:25','PLG0078882','2732000','2732000','13000','2745000','2745000','kasir','2026-04-07 09:47:25','F22607094725');
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-04-07','F226070947251','2026-04-07','09:47:25','NS','2745000','13000');
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-260407-0004','D','2026-04-07','09:47:25','kasir','PENJUALAN','F226070947251','8193942000','2745000','8196687000');
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 ('F226070948001','kasir','1',' TFD1 X BG ','TOKO','TBK-D','D1TF-VDAI-164-T','LT X SLOBOK BULAT HURUF BG T ','OL H','0.860','1','100.00','1823000','0','0','15000','1833000','0','10000','0','1843000','NS','T0032934','D1TF','0','0','-','0','2120000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1TF-VDAI-164-T' 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-04-07' AND kode_barang='D1TF-VDAI-164-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070948001','2026-04-07','0.860','2026-04-07','09:48:00','PLG0078883','1833000','1833000','10000','1843000','1843000','kasir','2026-04-07 09:48:00','F22607094800');
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-04-07','F226070948001','2026-04-07','09:48:00','NS','1843000','10000');
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-260407-0005','D','2026-04-07','09:48:00','kasir','PENJUALAN','F226070948001','8196687000','1843000','8198530000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1843000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070948001' 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 ('F226070948002','kasir',' 1',' TFD1 X BG ','TOKO','TBK-D','D1TF-ZCBC-8-T','LT X SLOBOK BULAT HURUF BG A 17K ','OL H','0.820','1','100.00','1738000','0','0','15000','1748000','0','10000','0','1758000','NS','T0078243','D1TF','0','0','-','0','2120000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1TF-ZCBC-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='D1TF-ZCBC-8-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070948002','2026-04-07','0.820','2026-04-07','09:48:00','PLG0078884','1748000','1748000','10000','1758000','1758000','kasir','2026-04-07 09:48:00','F22607094800');
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-04-07','F226070948002','2026-04-07','09:48:00','NS','1758000','10000');
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-260407-0006','D','2026-04-07','09:48:00','kasir','PENJUALAN','F226070948002','8198530000','1758000','8200288000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1758000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070948002' 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 ('F226070950191','kasir','1',' MGE1 LG 16','TOKO','SMBK-E','E1G-ZCXE-113-T','CC MODEL KUPU POLOS LG 16 8K ','OL H','0.360','1','100.00','432000','0','0','15000','434000','0','8000','0','442000','NS','T0077789','E1G','0','0','-','0','1200000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZCXE-113-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='E1G-ZCXE-113-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070950191','2026-04-07','0.360','2026-04-07','09:50:19','PLG0078885','434000','434000','8000','442000','442000','kasir','2026-04-07 09:50:19','F22607095019');
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-04-07','F226070950191','2026-04-07','09:50:19','NS','442000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260407-0007','D','2026-04-07','09:50:19','kasir','PENJUALAN','F226070950191','8200288000','442000','8200730000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='442000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070950191' 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 ('F226070950192','kasir',' 1',' MEE1 5K UB','TOKO','SMBK-E','E1E-ZCXG-55-T','CC BANGKOK PASIR UB 13 8K ','OL H','0.610','1','100.00','708000','0','0','15000','712000','0','10000','0','722000','NS','T0077926','E1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCXG-55-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='E1E-ZCXG-55-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070950192','2026-04-07','0.610','2026-04-07','09:50:19','PLG0078886','712000','712000','10000','722000','722000','kasir','2026-04-07 09:50:19','F22607095019');
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-04-07','F226070950192','2026-04-07','09:50:19','NS','722000','10000');
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-260407-0008','D','2026-04-07','09:50:19','kasir','PENJUALAN','F226070950192','8200730000','722000','8201452000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='722000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070950192' 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 ('F226070950193','kasir',' 1',' MGE1 LG 14','TOKO','SMBK-E','E1G-ZCXF-48-T','CC MODEL KUPU VAR LG 14 8K ','OL H','0.350','1','100.00','420000','0','0','15000','422000','0','8000','0','430000','NS','T0077870','E1G','0','0','-','0','1200000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZCXF-48-T' 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-04-07' AND kode_barang='E1G-ZCXF-48-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070950193','2026-04-07','0.350','2026-04-07','09:50:19','PLG0078887','422000','422000','8000','430000','430000','kasir','2026-04-07 09:50:19','F22607095019');
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-04-07','F226070950193','2026-04-07','09:50:19','NS','430000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260407-0009','D','2026-04-07','09:50:19','kasir','PENJUALAN','F226070950193','8201452000','430000','8201882000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='430000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070950193' 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 ('F226070950194','kasir',' 1',' MGE1 LG 14','TOKO','SMBK-E','E1G-ZCXE-104-T','CC MODEL BUNGA SLEP LG 14 8K ','OL H','0.320','1','100.00','384000','0','0','15000','386000','0','8000','0','394000','NS','T0077780','E1G','0','0','-','0','1200000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZCXE-104-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='E1G-ZCXE-104-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070950194','2026-04-07','0.320','2026-04-07','09:50:19','PLG0078888','386000','386000','8000','394000','394000','kasir','2026-04-07 09:50:19','F22607095019');
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-04-07','F226070950194','2026-04-07','09:50:19','NS','394000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260407-0010','D','2026-04-07','09:50:19','kasir','PENJUALAN','F226070950194','8201882000','394000','8202276000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='394000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070950194' 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 ('F226070950195','kasir',' 1',' MEF3 14K L','TOKO','SMBK-F','F3E-ZCBG-1-T','GL MODEL MEDAN PASIR VAR LG 8K ','OL H','2.680','1','100.00','3109000','0','0','15000','3123000','0','27000','0','3150000','NS','T0078317','F3E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCBG-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.680',berat_jual_asli=berat_jual_asli+'2.680',stock_jual='1',berat_akhir=berat_akhir-'2.680',berat_akhir_asli=berat_akhir_asli-'2.680',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='F3E-ZCBG-1-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070950195','2026-04-07','2.680','2026-04-07','09:50:19','PLG0078889','3123000','3123000','27000','3150000','3150000','kasir','2026-04-07 09:50:19','F22607095019');
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-04-07','F226070950195','2026-04-07','09:50:19','NS','3150000','27000');
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-260407-0011','D','2026-04-07','09:50:19','kasir','PENJUALAN','F226070950195','8202276000','3150000','8205426000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3150000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070950195' 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 ('F226070950196','kasir',' 1',' MEF3E X LG','TOKO','SMBK-F','F3E-ZCBE-249-0','GL X PAJERO SLEP LG 8K ','OL H','2.500','1','100.00','2900000','0','0','15000','2913000','0','25000','0','2938000','NS','00396711','F3E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCBE-249-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='F3E-ZCBE-249-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070950196','2026-04-07','2.500','2026-04-07','09:50:19','PLG0078890','2913000','2913000','25000','2938000','2938000','kasir','2026-04-07 09:50:19','F22607095019');
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-04-07','F226070950196','2026-04-07','09:50:19','NS','2938000','25000');
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-260407-0012','D','2026-04-07','09:50:19','kasir','PENJUALAN','F226070950196','8205426000','2938000','8208364000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2938000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070950196' 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 ('F226070950197','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZDXF-71-T','GL RANTAI HOLLOW DOUBLE HW 8K ','OL H','1.520','1','100.00','1763000','0','0','15000','1771000','0','15000','0','1786000','NS','T0078533','F3E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDXF-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='F3E-ZDXF-71-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070950197','2026-04-07','1.520','2026-04-07','09:50:19','PLG0078891','1771000','1771000','15000','1786000','1786000','kasir','2026-04-07 09:50:19','F22607095019');
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-04-07','F226070950197','2026-04-07','09:50:19','NS','1786000','15000');
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-260407-0013','D','2026-04-07','09:50:19','kasir','PENJUALAN','F226070950197','8208364000','1786000','8210150000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1786000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070950197' 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 ('F226070950198','kasir',' 1',' MFF3 UB ','TOKO','SMBK-F','F3F-YLAH-2-T','GL KAKI RANTE HOLLOW UB 8K ','OL H','0.500','1','100.00','590000','0','0','15000','593000','0','10000','0','603000','NS','T0075931','F3F','0','0','-','0','1180000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YLAH-2-T' 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-04-07' AND kode_barang='F3F-YLAH-2-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070950198','2026-04-07','0.500','2026-04-07','09:50:19','PLG0078892','593000','593000','10000','603000','603000','kasir','2026-04-07 09:50:19','F22607095019');
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-04-07','F226070950198','2026-04-07','09:50:19','NS','603000','10000');
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-260407-0014','D','2026-04-07','09:50:19','kasir','PENJUALAN','F226070950198','8210150000','603000','8210753000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='603000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070950198' 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 ('F226070951371','kasir','1',' MEH1 10K H','TOKO','SMBK-H','H1E-ZDXF-57-T','KL SANTA MODEL HATI PASIR HW 8K ','OL H','1.920','1','100.00','2227000','0','0','15000','2237000','0','19000','0','2256000','NS','T0078519','H1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDXF-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.920',berat_jual_asli=berat_jual_asli+'1.920',stock_jual='1',berat_akhir=berat_akhir-'1.920',berat_akhir_asli=berat_akhir_asli-'1.920',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='H1E-ZDXF-57-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070951371','2026-04-07','1.920','2026-04-07','09:51:37','PLG0078893','2237000','2237000','19000','2256000','2256000','kasir','2026-04-07 09:51:37','F22607095137');
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-04-07','F226070951371','2026-04-07','09:51:37','NS','2256000','19000');
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-260407-0015','D','2026-04-07','09:51:37','kasir','PENJUALAN','F226070951371','8210753000','2256000','8213009000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2256000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070951371' 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 ('F226070951372','kasir',' 1',' MEH1 10K H','TOKO','SMBK-H','H1E-ZDXF-56-T','KL SANTA MODEL HATI PASIR HW 8K ','OL H','1.940','1','100.00','2250000','0','0','15000','2261000','0','19000','0','2280000','NS','T0078518','H1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDXF-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.940',berat_jual_asli=berat_jual_asli+'1.940',stock_jual='1',berat_akhir=berat_akhir-'1.940',berat_akhir_asli=berat_akhir_asli-'1.940',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='H1E-ZDXF-56-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070951372','2026-04-07','1.940','2026-04-07','09:51:37','PLG0078894','2261000','2261000','19000','2280000','2280000','kasir','2026-04-07 09:51:37','F22607095137');
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-04-07','F226070951372','2026-04-07','09:51:37','NS','2280000','19000');
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-260407-0016','D','2026-04-07','09:51:37','kasir','PENJUALAN','F226070951372','8213009000','2280000','8215289000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2280000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070951372' 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 ('F226070951373','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZDXF-50-T','GL MODEL FANCY VAR HW 8K ','OL H','0.770','1','100.00','893000','0','0','15000','900000','0','10000','0','910000','NS','T0078512','F3E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDXF-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='F3E-ZDXF-50-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070951373','2026-04-07','0.770','2026-04-07','09:51:37','PLG0078895','900000','900000','10000','910000','910000','kasir','2026-04-07 09:51:37','F22607095137');
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-04-07','F226070951373','2026-04-07','09:51:37','NS','910000','10000');
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-260407-0017','D','2026-04-07','09:51:37','kasir','PENJUALAN','F226070951373','8215289000','910000','8216199000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='910000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070951373' 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 ('F226070951374','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZDXF-49-T','GL MODEL FANCY VAR HW 8K ','OL H','0.770','1','100.00','893000','0','0','15000','900000','0','10000','0','910000','NS','T0078511','F3E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDXF-49-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='F3E-ZDXF-49-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070951374','2026-04-07','0.770','2026-04-07','09:51:37','PLG0078896','900000','900000','10000','910000','910000','kasir','2026-04-07 09:51:37','F22607095137');
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-04-07','F226070951374','2026-04-07','09:51:37','NS','910000','10000');
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-260407-0018','D','2026-04-07','09:51:37','kasir','PENJUALAN','F226070951374','8216199000','910000','8217109000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='910000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070951374' 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 ('F226071000331','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-ZCBF-2-T','GL OVAL MODEL C TD D56 8K ','OL H','3.340','1','100.00','3874000','0','0','15000','3892000','0','33000','0','3925000','NS','T0078287','F1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCBF-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.340',berat_jual_asli=berat_jual_asli+'3.340',stock_jual='1',berat_akhir=berat_akhir-'3.340',berat_akhir_asli=berat_akhir_asli-'3.340',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='F1E-ZCBF-2-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226071000331','2026-04-07','3.340','2026-04-07','10:00:34','PLG0078897','3892000','3892000','33000','3925000','3925000','kasir','2026-04-07 10:00:33','F22607100033');
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-04-07','F226071000331','2026-04-07','10:00:34','NS','3925000','33000');
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-260407-0019','D','2026-04-07','10:00:34','kasir','PENJUALAN','F226071000331','8217109000','3925000','8221034000');
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 ('F226071119451','kasir','1',' TEE1 X CM ','TOKO','TBK-E','E1TE-WFBX-89-T','CC X WEDDING SLEP CM 14 ','ol','1.530','1','100.00','3213000','0','0','15000','3225000','0','11000','0','3236000','NS','T0045435','E1TE','0','0','-','0','2100000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-WFBX-89-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='E1TE-WFBX-89-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226071119451','2026-04-07','1.530','2026-04-07','11:19:46','PLG0078898','3225000','3225000','11000','3236000','3236000','kasir','2026-04-07 11:19:45','F22607111945');
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-04-07','F226071119451','2026-04-07','11:19:46','NS','3236000','11000');
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-260407-0020','D','2026-04-07','11:19:46','kasir','PENJUALAN','F226071119451','8221034000','3236000','8224270000');
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 ('F226071130551','kasir','1',' MDE1 CM 18','TOKO','SMBK-E','E1D-ZBAD-75-T','CC MODEL SLEP VAR CM 18 8K ','ol','0.850','1','100.00','969000','0','0','15000','978000','0','5000','0','983000','RTA','T0077364','E1D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZBAD-75-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='E1D-ZBAD-75-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226071130551','2026-04-07','0.850','2026-04-07','11:30:56','PLG0078899','978000','978000','5000','983000','983000','kasir','2026-04-07 11:30:55','F22607113055');
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-04-07','F226071130551','2026-04-07','11:30:56','RTA','983000','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-260407-0021','D','2026-04-07','11:30:56','kasir','PENJUALAN','F226071130551','8224270000','983000','8225253000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='983000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226071130551' 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 ('F226071130552','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZCAC-1-T','GL MODEL FLIK HATI VAR HW 8K ','ol','1.360','1','100.00','1578000','0','0','15000','1584000','0','7000','0','1591000','RTA','T0078114','F3E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAC-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.360',berat_jual_asli=berat_jual_asli+'1.360',stock_jual='1',berat_akhir=berat_akhir-'1.360',berat_akhir_asli=berat_akhir_asli-'1.360',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='F3E-ZCAC-1-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226071130552','2026-04-07','1.360','2026-04-07','11:30:56','PLG0078900','1584000','1584000','7000','1591000','1591000','kasir','2026-04-07 11:30:55','F22607113055');
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-04-07','F226071130552','2026-04-07','11:30:56','RTA','1591000','7000');
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-260407-0022','D','2026-04-07','11:30:56','kasir','PENJUALAN','F226071130552','8225253000','1591000','8226844000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1591000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226071130552' 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 ('F226071238141','kasir','1',' MDA1D X LG','TOKO','SMBK-A','A1D-ZBXE-77-0','AT X BANGKOK KLIP SLEP LG 8K ','','1.050','1','100.00','1197000','0','0','15000','1197000','0','0','0','1197000','RTA','00388345','A1D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZBXE-77-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='A1D-ZBXE-77-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226071238141','2026-04-07','1.050','2026-04-07','12:38:15','PLG0078901','1197000','1197000','0','1197000','1197000','kasir','2026-04-07 12:38:14','F22607123814');
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-04-07','F226071238141','2026-04-07','12:38:15','RTA','1197000','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-260407-0023','D','2026-04-07','12:38:15','kasir','PENJUALAN','F226071238141','8226844000','1197000','8228041000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1197000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226071238141' 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 ('F226071238142','kasir',' 1',' MDA1 CM ','TOKO','SMBK-A','A1D-YLXC-57-T','AT COR MODEL KLIP MATA CM 8K ','','1.270','1','100.00','1448000','0','0','15000','1448000','0','0','0','1448000','RTA','T0075466','A1D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YLXC-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.270',berat_jual_asli=berat_jual_asli+'1.270',stock_jual='1',berat_akhir=berat_akhir-'1.270',berat_akhir_asli=berat_akhir_asli-'1.270',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='A1D-YLXC-57-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226071238142','2026-04-07','1.270','2026-04-07','12:38:15','PLG0078902','1448000','1448000','0','1448000','1448000','kasir','2026-04-07 12:38:14','F22607123814');
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-04-07','F226071238142','2026-04-07','12:38:15','RTA','1448000','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-260407-0024','D','2026-04-07','12:38:15','kasir','PENJUALAN','F226071238142','8228041000','1448000','8229489000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1448000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226071238142' LIMIT 1;
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZDXG-1-T','T0078541','MEE1 CM 10 ','CC MODEL DAUN SLEP VAR CM 10 8K ','','GR','---','ME','E1E','TOKO','01-SEM','870000','2026-04-07','870000','0.750','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 13:12:34','0.750','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZDXG-1-T','T0078541');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1E-ZDXG-1-T','E1E','TOKO','01-SEM','100.00','0.750','0.750','1','0.750','0.750','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZDXG-2-T','T0078542','MEE1 CM 12 ','CC MODEL DAUN SLEP VAR CM 12 8K ','','GR','---','ME','E1E','TOKO','01-SEM','882000','2026-04-07','882000','0.760','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 13:12:51','0.760','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZDXG-2-T','T0078542');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1E-ZDXG-2-T','E1E','TOKO','01-SEM','100.00','0.760','0.760','1','0.760','0.760','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZDXG-3-T','T0078543','MEE1 CM 12 ','CC MODEL DAUN SLEP VAR CM 12 8K ','','GR','---','ME','E1E','TOKO','01-SEM','870000','2026-04-07','870000','0.750','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 13:13:02','0.750','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZDXG-3-T','T0078543');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1E-ZDXG-3-T','E1E','TOKO','01-SEM','100.00','0.750','0.750','1','0.750','0.750','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZDXG-4-T','T0078544','MEE1 CM 14 ','CC MODEL DAUN SLEP VAR CM 14 8K ','','GR','---','ME','E1E','TOKO','01-SEM','893500','2026-04-07','893500','0.770','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 13:13:16','0.770','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZDXG-4-T','T0078544');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1E-ZDXG-4-T','E1E','TOKO','01-SEM','100.00','0.770','0.770','1','0.770','0.770','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZDXG-5-T','T0078545','MEE1 CM 14 ','CC MODEL DAUN SLEP VAR CM 14 8K ','','GR','---','ME','E1E','TOKO','01-SEM','882000','2026-04-07','882000','0.760','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 13:13:28','0.760','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZDXG-5-T','T0078545');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1E-ZDXG-5-T','E1E','TOKO','01-SEM','100.00','0.760','0.760','1','0.760','0.760','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZDXG-6-T','T0078546','MEE1 CM 12 ','CC MODEL AUREL POLOS CM 12 8K ','','GR','---','ME','E1E','TOKO','01-SEM','592000','2026-04-07','592000','0.510','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 13:14:39','0.510','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZDXG-6-T','T0078546');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1E-ZDXG-6-T','E1E','TOKO','01-SEM','100.00','0.510','0.510','1','0.510','0.510','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZDXG-7-T','T0078547','MEE1 CM 12 ','CC MODEL AUREL POLOS CM 12 8K ','','GR','---','ME','E1E','TOKO','01-SEM','557000','2026-04-07','557000','0.480','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 13:14:56','0.480','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZDXG-7-T','T0078547');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1E-ZDXG-7-T','E1E','TOKO','01-SEM','100.00','0.480','0.480','1','0.480','0.480','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2E-ZDXG-8-T','T0078548','MEE2 CM 14 ','CC MODEL AUREL MATA CM 14 8K ','','GR','---','ME','E2E','TOKO','01-SEM','661500','2026-04-07','661500','0.570','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 13:15:44','0.570','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2E','E2E-ZDXG-8-T','T0078548');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E2E-ZDXG-8-T','E2E','TOKO','01-SEM','100.00','0.570','0.570','1','0.570','0.570','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2E-ZDXG-9-T','T0078549','MEE2 CM 14 ','CC MODEL AUREL MATA CM 14 8K ','','GR','---','ME','E2E','TOKO','01-SEM','708000','2026-04-07','708000','0.610','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 13:15:55','0.610','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2E','E2E-ZDXG-9-T','T0078549');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E2E-ZDXG-9-T','E2E','TOKO','01-SEM','100.00','0.610','0.610','1','0.610','0.610','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2E-ZDXG-10-T','T0078550','MEE2 CM 12 ','CC MODEL AUREL MATA CM 12 8K ','','GR','---','ME','E2E','TOKO','01-SEM','696000','2026-04-07','696000','0.600','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 13:16:19','0.600','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2E','E2E-ZDXG-10-T','T0078550');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E2E-ZDXG-10-T','E2E','TOKO','01-SEM','100.00','0.600','0.600','1','0.600','0.600','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2E-ZDXG-11-T','T0078551','MEE2 CM 12 ','CC MODEL AUREL MATA CM 12 8K ','','GR','---','ME','E2E','TOKO','01-SEM','673000','2026-04-07','673000','0.580','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 13:16:29','0.580','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2E','E2E-ZDXG-11-T','T0078551');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E2E-ZDXG-11-T','E2E','TOKO','01-SEM','100.00','0.580','0.580','1','0.580','0.580','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2E-ZDXG-12-T','T0078552','MEE2 CM 16 ','CC MODEL AUREL MATA CM 16 8K ','','GR','---','ME','E2E','TOKO','01-SEM','754000','2026-04-07','754000','0.650','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 13:16:40','0.650','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2E','E2E-ZDXG-12-T','T0078552');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E2E-ZDXG-12-T','E2E','TOKO','01-SEM','100.00','0.650','0.650','1','0.650','0.650','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2E-ZDXG-13-T','T0078553','MEE2 CM 16 ','CC MODEL AUREL MATA CM 16 8K ','','GR','---','ME','E2E','TOKO','01-SEM','777500','2026-04-07','777500','0.670','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 13:16:48','0.670','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2E','E2E-ZDXG-13-T','T0078553');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E2E-ZDXG-13-T','E2E','TOKO','01-SEM','100.00','0.670','0.670','1','0.670','0.670','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2E-ZDXG-14-T','T0078554','MEE2 CM 12 ','CC MODEL PITA MATA CM 12 8K ','','GR','---','ME','E2E','TOKO','01-SEM','476000','2026-04-07','476000','0.410','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 13:17:35','0.410','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2E','E2E-ZDXG-14-T','T0078554');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E2E-ZDXG-14-T','E2E','TOKO','01-SEM','100.00','0.410','0.410','1','0.410','0.410','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2E-ZDXG-15-T','T0078555','MEE2 CM 10 ','CC MODEL PITA MATA CM 10 8K ','','GR','---','ME','E2E','TOKO','01-SEM','487500','2026-04-07','487500','0.420','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 13:17:51','0.420','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2E','E2E-ZDXG-15-T','T0078555');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E2E-ZDXG-15-T','E2E','TOKO','01-SEM','100.00','0.420','0.420','1','0.420','0.420','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2E-ZDXG-16-T','T0078556','MEE2 CM 14 ','CC MODEL PITA MATA CM 14 8K ','','GR','---','ME','E2E','TOKO','01-SEM','487500','2026-04-07','487500','0.420','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 13:18:12','0.420','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2E','E2E-ZDXG-16-T','T0078556');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E2E-ZDXG-16-T','E2E','TOKO','01-SEM','100.00','0.420','0.420','1','0.420','0.420','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZDXG-17-T','T0078557','MDE2 10K CM 16 ','CC MODEL SOLITAIRE MATA CM 16 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1254000','2026-04-07','1254000','1.100','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:20:06','1.100','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZDXG-17-T','T0078557');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E2D-ZDXG-17-T','E2D','TOKO','01-SEM','100.00','1.100','1.100','1','1.100','1.100','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZDXG-18-T','T0078558','MDE2 10K CM 12 ','CC MODEL SOLITAIRE MATA CM 12 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1197000','2026-04-07','1197000','1.050','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:20:24','1.050','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZDXG-18-T','T0078558');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E2D-ZDXG-18-T','E2D','TOKO','01-SEM','100.00','1.050','1.050','1','1.050','1.050','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZDXG-19-T','T0078559','MDE2 10K CM 10 ','CC MODEL SOLITAIRE MATA CM 10 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1106000','2026-04-07','1106000','0.970','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:20:45','0.970','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZDXG-19-T','T0078559');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E2D-ZDXG-19-T','E2D','TOKO','01-SEM','100.00','0.970','0.970','1','0.970','0.970','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZDXG-20-T','T0078560','MDE2 10K CM 14 ','CC MODEL SOLITAIRE MATA CM 14 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1208500','2026-04-07','1208500','1.060','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:20:58','1.060','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZDXG-20-T','T0078560');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E2D-ZDXG-20-T','E2D','TOKO','01-SEM','100.00','1.060','1.060','1','1.060','1.060','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZDXG-21-T','T0078561','MDE2 10K CM 18 ','CC MODEL SOLITAIRE MATA CM 18 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1265500','2026-04-07','1265500','1.110','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:21:10','1.110','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZDXG-21-T','T0078561');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E2D-ZDXG-21-T','E2D','TOKO','01-SEM','100.00','1.110','1.110','1','1.110','1.110','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZDXG-22-T','T0078562','MDE2 5K CM 16 ','CC MODEL BUNGA MATA VAR CM 16 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1288500','2026-04-07','1288500','1.130','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:22:14','1.130','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZDXG-22-T','T0078562');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E2D-ZDXG-22-T','E2D','TOKO','01-SEM','100.00','1.130','1.130','1','1.130','1.130','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZDXG-23-T','T0078563','MDE2 5K CM 12 ','CC MODEL BUNGA MATA VAR CM 12 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1220000','2026-04-07','1220000','1.070','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:22:26','1.070','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZDXG-23-T','T0078563');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E2D-ZDXG-23-T','E2D','TOKO','01-SEM','100.00','1.070','1.070','1','1.070','1.070','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZDXG-24-T','T0078564','MDE2 5K CM 14 ','CC MODEL BUNGA MATA VAR CM 14 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1254000','2026-04-07','1254000','1.100','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:22:40','1.100','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZDXG-24-T','T0078564');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E2D-ZDXG-24-T','E2D','TOKO','01-SEM','100.00','1.100','1.100','1','1.100','1.100','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1D-ZDXG-25-T','T0078565','MDE1 CM 16 ','CC POLOS CM 16 8K ','','GR','---','MD','E1D','TOKO','01-SEM','1174500','2026-04-07','1174500','1.030','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:23:16','1.030','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1D','E1D-ZDXG-25-T','T0078565');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1D-ZDXG-25-T','E1D','TOKO','01-SEM','100.00','1.030','1.030','1','1.030','1.030','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1D-ZDXG-26-T','T0078566','MDE1 CM 18 ','CC POLOS CM 18 8K ','','GR','---','MD','E1D','TOKO','01-SEM','1174500','2026-04-07','1174500','1.030','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:23:31','1.030','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1D','E1D-ZDXG-26-T','T0078566');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1D-ZDXG-26-T','E1D','TOKO','01-SEM','100.00','1.030','1.030','1','1.030','1.030','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1D-ZDXG-27-T','T0078567','MDE1 CM 14 ','CC POLOS CM 14 8K ','','GR','---','MD','E1D','TOKO','01-SEM','1140000','2026-04-07','1140000','1.000','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:23:43','1.000','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1D','E1D-ZDXG-27-T','T0078567');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1D-ZDXG-27-T','E1D','TOKO','01-SEM','100.00','1.000','1.000','1','1.000','1.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1D-ZDXG-28-T','T0078568','MDE1 CM 20 ','CC POLOS CM 20 8K ','','GR','---','MD','E1D','TOKO','01-SEM','1140000','2026-04-07','1140000','1.000','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:23:53','1.000','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1D','E1D-ZDXG-28-T','T0078568');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1D-ZDXG-28-T','E1D','TOKO','01-SEM','100.00','1.000','1.000','1','1.000','1.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1D-ZDXG-29-T','T0078569','MDE1 CM 22 ','CC POLOS CM 22 8K ','','GR','---','MD','E1D','TOKO','01-SEM','1106000','2026-04-07','1106000','0.970','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:24:05','0.970','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1D','E1D-ZDXG-29-T','T0078569');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1D-ZDXG-29-T','E1D','TOKO','01-SEM','100.00','0.970','0.970','1','0.970','0.970','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1D-ZDXG-30-T','T0078570','MDE1 CM 14 ','CC MODEL C CM 14 8K ','','GR','---','MD','E1D','TOKO','01-SEM','1197000','2026-04-07','1197000','1.050','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:24:28','1.050','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1D','E1D-ZDXG-30-T','T0078570');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1D-ZDXG-30-T','E1D','TOKO','01-SEM','100.00','1.050','1.050','1','1.050','1.050','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1D-ZDXG-31-T','T0078571','MDE1 CM 16 ','CC MODEL C CM 16 8K ','','GR','---','MD','E1D','TOKO','01-SEM','1094500','2026-04-07','1094500','0.960','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:24:38','0.960','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1D','E1D-ZDXG-31-T','T0078571');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1D-ZDXG-31-T','E1D','TOKO','01-SEM','100.00','0.960','0.960','1','0.960','0.960','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1D-ZDXG-32-T','T0078572','MDE1 CM 18 ','CC MODEL C CM 18 8K ','','GR','---','MD','E1D','TOKO','01-SEM','1117500','2026-04-07','1117500','0.980','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:24:48','0.980','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1D','E1D-ZDXG-32-T','T0078572');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1D-ZDXG-32-T','E1D','TOKO','01-SEM','100.00','0.980','0.980','1','0.980','0.980','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1D-ZDXG-33-T','T0078573','MDE1 CM 20 ','CC MODEL C CM 20 8K ','','GR','---','MD','E1D','TOKO','01-SEM','1197000','2026-04-07','1197000','1.050','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:25:00','1.050','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1D','E1D-ZDXG-33-T','T0078573');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1D-ZDXG-33-T','E1D','TOKO','01-SEM','100.00','1.050','1.050','1','1.050','1.050','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1D-ZDXG-34-T','T0078574','MDE1 CM 12 ','CC MODEL C CM 12 8K ','','GR','---','MD','E1D','TOKO','01-SEM','1083000','2026-04-07','1083000','0.950','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:25:10','0.950','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1D','E1D-ZDXG-34-T','T0078574');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1D-ZDXG-34-T','E1D','TOKO','01-SEM','100.00','0.950','0.950','1','0.950','0.950','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','1','E1D-ZDXG-25-T','1','1.03','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1D-ZDXG-25-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E1D','E1D-ZDXG-25-T' , '1','1.03','1.03', '1','1.03','1.03','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.03',berat_out_asli=berat_out_asli+'1.03',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1D-ZDXG-25-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','2','E1D-ZDXG-26-T','1','1.03','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1D-ZDXG-26-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E1D','E1D-ZDXG-26-T' , '1','1.03','1.03', '1','1.03','1.03','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.03',berat_out_asli=berat_out_asli+'1.03',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1D-ZDXG-26-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','3','E1D-ZDXG-27-T','1','1','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1D-ZDXG-27-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E1D','E1D-ZDXG-27-T' , '1','1','1', '1','1','1','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1',berat_out_asli=berat_out_asli+'1',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1D-ZDXG-27-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','4','E1D-ZDXG-28-T','1','1','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1D-ZDXG-28-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E1D','E1D-ZDXG-28-T' , '1','1','1', '1','1','1','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1',berat_out_asli=berat_out_asli+'1',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1D-ZDXG-28-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','5','E1D-ZDXG-29-T','1','0.97','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1D-ZDXG-29-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E1D','E1D-ZDXG-29-T' , '1','0.97','0.97', '1','0.97','0.97','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.97',berat_out_asli=berat_out_asli+'0.97',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1D-ZDXG-29-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','6','E1D-ZDXG-30-T','1','1.05','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1D-ZDXG-30-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E1D','E1D-ZDXG-30-T' , '1','1.05','1.05', '1','1.05','1.05','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.05',berat_out_asli=berat_out_asli+'1.05',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1D-ZDXG-30-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','7','E1D-ZDXG-31-T','1','0.96','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1D-ZDXG-31-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E1D','E1D-ZDXG-31-T' , '1','0.96','0.96', '1','0.96','0.96','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.96',berat_out_asli=berat_out_asli+'0.96',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1D-ZDXG-31-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','8','E1D-ZDXG-32-T','1','0.98','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1D-ZDXG-32-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E1D','E1D-ZDXG-32-T' , '1','0.98','0.98', '1','0.98','0.98','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.98',berat_out_asli=berat_out_asli+'0.98',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1D-ZDXG-32-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','9','E1D-ZDXG-33-T','1','1.05','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1D-ZDXG-33-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E1D','E1D-ZDXG-33-T' , '1','1.05','1.05', '1','1.05','1.05','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.05',berat_out_asli=berat_out_asli+'1.05',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1D-ZDXG-33-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','10','E1D-ZDXG-34-T','1','0.95','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1D-ZDXG-34-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E1D','E1D-ZDXG-34-T' , '1','0.95','0.95', '1','0.95','0.95','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.95',berat_out_asli=berat_out_asli+'0.95',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1D-ZDXG-34-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','11','E1E-ZDXG-1-T','1','0.75','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZDXG-1-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E1E','E1E-ZDXG-1-T' , '1','0.75','0.75', '1','0.75','0.75','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.75',berat_out_asli=berat_out_asli+'0.75',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZDXG-1-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','12','E1E-ZDXG-2-T','1','0.76','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZDXG-2-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E1E','E1E-ZDXG-2-T' , '1','0.76','0.76', '1','0.76','0.76','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.76',berat_out_asli=berat_out_asli+'0.76',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZDXG-2-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','13','E1E-ZDXG-3-T','1','0.75','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZDXG-3-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E1E','E1E-ZDXG-3-T' , '1','0.75','0.75', '1','0.75','0.75','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.75',berat_out_asli=berat_out_asli+'0.75',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZDXG-3-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','14','E1E-ZDXG-4-T','1','0.77','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZDXG-4-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E1E','E1E-ZDXG-4-T' , '1','0.77','0.77', '1','0.77','0.77','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.77',berat_out_asli=berat_out_asli+'0.77',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZDXG-4-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','15','E1E-ZDXG-5-T','1','0.76','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZDXG-5-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E1E','E1E-ZDXG-5-T' , '1','0.76','0.76', '1','0.76','0.76','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.76',berat_out_asli=berat_out_asli+'0.76',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZDXG-5-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','16','E1E-ZDXG-6-T','1','0.51','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZDXG-6-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E1E','E1E-ZDXG-6-T' , '1','0.51','0.51', '1','0.51','0.51','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.51',berat_out_asli=berat_out_asli+'0.51',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZDXG-6-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','17','E1E-ZDXG-7-T','1','0.48','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZDXG-7-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E1E','E1E-ZDXG-7-T' , '1','0.48','0.48', '1','0.48','0.48','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.48',berat_out_asli=berat_out_asli+'0.48',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZDXG-7-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','18','E2D-ZDXG-17-T','1','1.1','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-ZDXG-17-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E2D','E2D-ZDXG-17-T' , '1','1.1','1.1', '1','1.1','1.1','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.1',berat_out_asli=berat_out_asli+'1.1',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZDXG-17-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','19','E2D-ZDXG-18-T','1','1.05','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-ZDXG-18-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E2D','E2D-ZDXG-18-T' , '1','1.05','1.05', '1','1.05','1.05','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.05',berat_out_asli=berat_out_asli+'1.05',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZDXG-18-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','20','E2D-ZDXG-19-T','1','0.97','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-ZDXG-19-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E2D','E2D-ZDXG-19-T' , '1','0.97','0.97', '1','0.97','0.97','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.97',berat_out_asli=berat_out_asli+'0.97',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZDXG-19-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','21','E2D-ZDXG-20-T','1','1.06','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-ZDXG-20-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E2D','E2D-ZDXG-20-T' , '1','1.06','1.06', '1','1.06','1.06','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.06',berat_out_asli=berat_out_asli+'1.06',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZDXG-20-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','22','E2D-ZDXG-21-T','1','1.11','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-ZDXG-21-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E2D','E2D-ZDXG-21-T' , '1','1.11','1.11', '1','1.11','1.11','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.11',berat_out_asli=berat_out_asli+'1.11',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZDXG-21-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','23','E2D-ZDXG-22-T','1','1.13','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-ZDXG-22-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E2D','E2D-ZDXG-22-T' , '1','1.13','1.13', '1','1.13','1.13','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.13',berat_out_asli=berat_out_asli+'1.13',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZDXG-22-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','24','E2D-ZDXG-23-T','1','1.07','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-ZDXG-23-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E2D','E2D-ZDXG-23-T' , '1','1.07','1.07', '1','1.07','1.07','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.07',berat_out_asli=berat_out_asli+'1.07',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZDXG-23-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','25','E2D-ZDXG-24-T','1','1.1','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-ZDXG-24-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E2D','E2D-ZDXG-24-T' , '1','1.1','1.1', '1','1.1','1.1','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.1',berat_out_asli=berat_out_asli+'1.1',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZDXG-24-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','26','E2E-ZDXG-10-T','1','0.6','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2E-ZDXG-10-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E2E','E2E-ZDXG-10-T' , '1','0.6','0.6', '1','0.6','0.6','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.6',berat_out_asli=berat_out_asli+'0.6',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2E-ZDXG-10-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','27','E2E-ZDXG-11-T','1','0.58','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2E-ZDXG-11-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E2E','E2E-ZDXG-11-T' , '1','0.58','0.58', '1','0.58','0.58','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.58',berat_out_asli=berat_out_asli+'0.58',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2E-ZDXG-11-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','28','E2E-ZDXG-12-T','1','0.65','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2E-ZDXG-12-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E2E','E2E-ZDXG-12-T' , '1','0.65','0.65', '1','0.65','0.65','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.65',berat_out_asli=berat_out_asli+'0.65',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2E-ZDXG-12-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','29','E2E-ZDXG-13-T','1','0.67','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2E-ZDXG-13-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E2E','E2E-ZDXG-13-T' , '1','0.67','0.67', '1','0.67','0.67','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.67',berat_out_asli=berat_out_asli+'0.67',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2E-ZDXG-13-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','30','E2E-ZDXG-14-T','1','0.41','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2E-ZDXG-14-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E2E','E2E-ZDXG-14-T' , '1','0.41','0.41', '1','0.41','0.41','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.41',berat_out_asli=berat_out_asli+'0.41',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2E-ZDXG-14-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','31','E2E-ZDXG-15-T','1','0.42','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2E-ZDXG-15-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E2E','E2E-ZDXG-15-T' , '1','0.42','0.42', '1','0.42','0.42','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.42',berat_out_asli=berat_out_asli+'0.42',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2E-ZDXG-15-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','32','E2E-ZDXG-16-T','1','0.42','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2E-ZDXG-16-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E2E','E2E-ZDXG-16-T' , '1','0.42','0.42', '1','0.42','0.42','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.42',berat_out_asli=berat_out_asli+'0.42',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2E-ZDXG-16-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','33','E2E-ZDXG-8-T','1','0.57','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2E-ZDXG-8-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E2E','E2E-ZDXG-8-T' , '1','0.57','0.57', '1','0.57','0.57','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.57',berat_out_asli=berat_out_asli+'0.57',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2E-ZDXG-8-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0002','34','E2E-ZDXG-9-T','1','0.61','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2E-ZDXG-9-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-E','E2E','E2E-ZDXG-9-T' , '1','0.61','0.61', '1','0.61','0.61','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.61',berat_out_asli=berat_out_asli+'0.61',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2E-ZDXG-9-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260407-0002','2026-04-07','2026-04-07','13:26','28.32','input','2026-04-07 13:26:12');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('A1D-ZDXG-35-T','T0078575','MDA1 CM ','AT KLIP MODEL DAUN VAR CM 8K ','','GR','---','MD','A1D','TOKO','01-SEM','1140000','2026-04-07','1140000','1.000','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:36:31','1.000','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1D','A1D-ZDXG-35-T','T0078575');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','A1D-ZDXG-35-T','A1D','TOKO','01-SEM','100.00','1.000','1.000','1','1.000','1.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('A1D-ZDXG-36-T','T0078576','MDA1 CM ','AT KLIP MODEL DAUN VAR CM 8K ','','GR','---','MD','A1D','TOKO','01-SEM','1117500','2026-04-07','1117500','0.980','100.00','8','0','1140000.00','1','0.04', 'input','2026-04-07 13:36:38','0.980','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1D','A1D-ZDXG-36-T','T0078576');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','A1D-ZDXG-36-T','A1D','TOKO','01-SEM','100.00','0.980','0.980','1','0.980','0.980','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('A1E-ZDXG-37-T','T0078577','MEA1 CM ','AT MODEL HATI ARESO CM 8K ','','GR','---','ME','A1E','TOKO','01-SEM','754000','2026-04-07','754000','0.650','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 13:37:47','0.650','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1E','A1E-ZDXG-37-T','T0078577');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','A1E-ZDXG-37-T','A1E','TOKO','01-SEM','100.00','0.650','0.650','1','0.650','0.650','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('A1E-ZDXG-38-T','T0078578','MEA1 CM ','AT MODEL HATI ARESO CM 8K ','','GR','---','ME','A1E','TOKO','01-SEM','847000','2026-04-07','847000','0.730','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 13:37:55','0.730','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1E','A1E-ZDXG-38-T','T0078578');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','A1E-ZDXG-38-T','A1E','TOKO','01-SEM','100.00','0.730','0.730','1','0.730','0.730','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('A1H-ZDXG-39-T','T0078579','MHA1 CM ','AT TINDIK BABY CM 8K ','','GR','---','MH','A1H','TOKO','01-SEM','317500','2026-04-07','317500','0.260','100.00','8','0','1220000.00','1','0.04', 'input','2026-04-07 13:38:27','0.260','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1H' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1H','A1H-ZDXG-39-T','T0078579');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','A1H-ZDXG-39-T','A1H','TOKO','01-SEM','100.00','0.260','0.260','1','0.260','0.260','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('A1H-ZDXG-40-T','T0078580','MHA1 CM ','AT TINDIK BABY CM 8K ','','GR','---','MH','A1H','TOKO','01-SEM','317500','2026-04-07','317500','0.260','100.00','8','0','1220000.00','1','0.04', 'input','2026-04-07 13:38:50','0.260','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1H' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1H','A1H-ZDXG-40-T','T0078580');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','A1H-ZDXG-40-T','A1H','TOKO','01-SEM','100.00','0.260','0.260','1','0.260','0.260','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('A1H-ZDXG-41-T','T0078581','MHA1 CM ','AT TINDIK BABY CM 8K ','','GR','---','MH','A1H','TOKO','01-SEM','305000','2026-04-07','305000','0.250','100.00','8','0','1220000.00','1','0.04', 'input','2026-04-07 13:38:58','0.250','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1H' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1H','A1H-ZDXG-41-T','T0078581');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','A1H-ZDXG-41-T','A1H','TOKO','01-SEM','100.00','0.250','0.250','1','0.250','0.250','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('A1H-ZDXG-42-T','T0078582','MHA1 CM ','AT TINDIK BABY CM 8K ','','GR','---','MH','A1H','TOKO','01-SEM','305000','2026-04-07','305000','0.250','100.00','8','0','1220000.00','1','0.04', 'input','2026-04-07 13:39:05','0.250','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1H' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1H','A1H-ZDXG-42-T','T0078582');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','A1H-ZDXG-42-T','A1H','TOKO','01-SEM','100.00','0.250','0.250','1','0.250','0.250','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0003','1','A1D-ZDXG-35-T','1','1','0','TOKO','01-SEM','TOKO','SMBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-A' WHERE kode_barang = 'A1D-ZDXG-35-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-A','A1D','A1D-ZDXG-35-T' , '1','1','1', '1','1','1','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1',berat_out_asli=berat_out_asli+'1',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1D-ZDXG-35-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0003','2','A1D-ZDXG-36-T','1','0.98','0','TOKO','01-SEM','TOKO','SMBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-A' WHERE kode_barang = 'A1D-ZDXG-36-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-A','A1D','A1D-ZDXG-36-T' , '1','0.98','0.98', '1','0.98','0.98','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.98',berat_out_asli=berat_out_asli+'0.98',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1D-ZDXG-36-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0003','3','A1E-ZDXG-37-T','1','0.65','0','TOKO','01-SEM','TOKO','SMBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-A' WHERE kode_barang = 'A1E-ZDXG-37-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-A','A1E','A1E-ZDXG-37-T' , '1','0.65','0.65', '1','0.65','0.65','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.65',berat_out_asli=berat_out_asli+'0.65',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1E-ZDXG-37-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0003','4','A1E-ZDXG-38-T','1','0.73','0','TOKO','01-SEM','TOKO','SMBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-A' WHERE kode_barang = 'A1E-ZDXG-38-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-A','A1E','A1E-ZDXG-38-T' , '1','0.73','0.73', '1','0.73','0.73','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.73',berat_out_asli=berat_out_asli+'0.73',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1E-ZDXG-38-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0003','5','A1H-ZDXG-39-T','1','0.26','0','TOKO','01-SEM','TOKO','SMBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-A' WHERE kode_barang = 'A1H-ZDXG-39-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-A','A1H','A1H-ZDXG-39-T' , '1','0.26','0.26', '1','0.26','0.26','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.26',berat_out_asli=berat_out_asli+'0.26',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1H-ZDXG-39-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0003','6','A1H-ZDXG-40-T','1','0.26','0','TOKO','01-SEM','TOKO','SMBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-A' WHERE kode_barang = 'A1H-ZDXG-40-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-A','A1H','A1H-ZDXG-40-T' , '1','0.26','0.26', '1','0.26','0.26','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.26',berat_out_asli=berat_out_asli+'0.26',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1H-ZDXG-40-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0003','7','A1H-ZDXG-41-T','1','0.25','0','TOKO','01-SEM','TOKO','SMBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-A' WHERE kode_barang = 'A1H-ZDXG-41-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-A','A1H','A1H-ZDXG-41-T' , '1','0.25','0.25', '1','0.25','0.25','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.25',berat_out_asli=berat_out_asli+'0.25',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1H-ZDXG-41-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0003','8','A1H-ZDXG-42-T','1','0.25','0','TOKO','01-SEM','TOKO','SMBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-A' WHERE kode_barang = 'A1H-ZDXG-42-T' AND kode_lokasi_toko = '01-SEM';
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-04-07','TOKO','SMBK-A','A1H','A1H-ZDXG-42-T' , '1','0.25','0.25', '1','0.25','0.25','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.25',berat_out_asli=berat_out_asli+'0.25',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1H-ZDXG-42-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260407-0003','2026-04-07','2026-04-07','13:41','4.38','input','2026-04-07 13:41:28');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-ZDXG-43-T','T0078583','MEF3 HW ','GL MODEL FANCY VAR HW 8K ','','GR','---','ME','F3E','TOKO','01-SEM','812000','2026-04-07','812000','0.700','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 14:01:12','0.700','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZDXG-43-T','T0078583');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','F3E-ZDXG-43-T','F3E','TOKO','01-SEM','100.00','0.700','0.700','1','0.700','0.700','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-ZDXG-44-T','T0078584','MEF3 HW ','GL MODEL FANCY VAR HW 8K ','','GR','---','ME','F3E','TOKO','01-SEM','858500','2026-04-07','858500','0.740','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 14:01:20','0.740','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZDXG-44-T','T0078584');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','F3E-ZDXG-44-T','F3E','TOKO','01-SEM','100.00','0.740','0.740','1','0.740','0.740','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-ZDXG-45-T','T0078585','MEF3 HW ','GL MODEL FANCY VAR HW 8K ','','GR','---','ME','F3E','TOKO','01-SEM','858500','2026-04-07','858500','0.740','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 14:01:34','0.740','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZDXG-45-T','T0078585');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','F3E-ZDXG-45-T','F3E','TOKO','01-SEM','100.00','0.740','0.740','1','0.740','0.740','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-ZDXG-46-T','T0078586','MEH1 HW ','KL SANTA MODEL HATI PASIR HW 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2250500','2026-04-07','2250500','1.940','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 14:02:49','1.940','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-ZDXG-46-T','T0078586');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','H1E-ZDXG-46-T','H1E','TOKO','01-SEM','100.00','1.940','1.940','1','1.940','1.940','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-ZDXG-47-T','T0078587','MEH1 HW ','KL SANTA MODEL HATI PASIR HW 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2239000','2026-04-07','2239000','1.930','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 14:02:55','1.930','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-ZDXG-47-T','T0078587');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','H1E-ZDXG-47-T','H1E','TOKO','01-SEM','100.00','1.930','1.930','1','1.930','1.930','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZDXG-48-T','T0078588','MEE1 5K HW 15 ','CC MODEL SLEP VAR HW 15 8K ','','GR','---','ME','E1E','TOKO','01-SEM','835500','2026-04-07','835500','0.720','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 14:03:53','0.720','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZDXG-48-T','T0078588');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1E-ZDXG-48-T','E1E','TOKO','01-SEM','100.00','0.720','0.720','1','0.720','0.720','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZDXG-49-T','T0078589','MEE1 5K HW 17 ','CC MODEL SLEP VAR HW 17 8K ','','GR','---','ME','E1E','TOKO','01-SEM','858500','2026-04-07','858500','0.740','100.00','8','0','1160000.00','1','0.04', 'input','2026-04-07 14:04:44','0.740','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZDXG-49-T','T0078589');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','E1E-ZDXG-49-T','E1E','TOKO','01-SEM','100.00','0.740','0.740','1','0.740','0.740','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1F-ZDXG-50-T','T0078590','MFD1 5K BG ','LT MODEL BUNGA PASIR BG 8K ','','GR','---','MF','D1F','TOKO','01-SEM','1192000','2026-04-07','1192000','1.010','100.00','8','0','1180000.00','1','0.04', 'input','2026-04-07 14:05:26','1.010','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1F','D1F-ZDXG-50-T','T0078590');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','D1F-ZDXG-50-T','D1F','TOKO','01-SEM','100.00','1.010','1.010','1','1.010','1.010','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1F-ZDXG-51-T','T0078591','MFD1 5K BG ','LT MODEL BUNGA PASIR BG 8K ','','GR','---','MF','D1F','TOKO','01-SEM','1145000','2026-04-07','1145000','0.970','100.00','8','0','1180000.00','1','0.04', 'input','2026-04-07 14:05:38','0.970','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1F','D1F-ZDXG-51-T','T0078591');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','D1F-ZDXG-51-T','D1F','TOKO','01-SEM','100.00','0.970','0.970','1','0.970','0.970','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1F-ZDXG-52-T','T0078592','MFD1 5K BG ','LT MODEL BUNGA PASIR BG 8K ','','GR','---','MF','D1F','TOKO','01-SEM','1156500','2026-04-07','1156500','0.980','100.00','8','0','1180000.00','1','0.04', 'input','2026-04-07 14:05:44','0.980','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1F','D1F-ZDXG-52-T','T0078592');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-07','D1F-ZDXG-52-T','D1F','TOKO','01-SEM','100.00','0.980','0.980','1','0.980','0.980','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0004','1','F3E-ZDXG-43-T','1','0.700','0.700','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-F' WHERE kode_barang='F3E-ZDXG-43-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-07','TOKO','SMBK-F','F3E','F3E-ZDXG-43-T','100.00','1','0.700','0.700','1','0.700','0.700');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.700',berat_out_asli=berat_out_asli+'0.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-07' AND kode_barang='F3E-ZDXG-43-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0004','2','F3E-ZDXG-44-T','1','0.740','0.740','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-F' WHERE kode_barang='F3E-ZDXG-44-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-07','TOKO','SMBK-F','F3E','F3E-ZDXG-44-T','100.00','1','0.740','0.740','1','0.740','0.740');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.740',berat_out_asli=berat_out_asli+'0.740',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-07' AND kode_barang='F3E-ZDXG-44-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0004','3','F3E-ZDXG-45-T','1','0.740','0.740','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-F' WHERE kode_barang='F3E-ZDXG-45-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-07','TOKO','SMBK-F','F3E','F3E-ZDXG-45-T','100.00','1','0.740','0.740','1','0.740','0.740');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.740',berat_out_asli=berat_out_asli+'0.740',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-07' AND kode_barang='F3E-ZDXG-45-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260407-0004','2026-04-07','2026-04-07','14:06','2.18','input','2026-04-07 14:06:31');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0005','1','H1E-ZDXG-46-T','1','1.940','1.940','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-H' WHERE kode_barang='H1E-ZDXG-46-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-07','TOKO','SMBK-H','H1E','H1E-ZDXG-46-T','100.00','1','1.940','1.940','1','1.940','1.940');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.940',berat_out_asli=berat_out_asli+'1.940',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-07' AND kode_barang='H1E-ZDXG-46-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0005','2','H1E-ZDXG-47-T','1','1.930','1.930','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-H' WHERE kode_barang='H1E-ZDXG-47-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-07','TOKO','SMBK-H','H1E','H1E-ZDXG-47-T','100.00','1','1.930','1.930','1','1.930','1.930');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.930',berat_out_asli=berat_out_asli+'1.930',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-07' AND kode_barang='H1E-ZDXG-47-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260407-0005','2026-04-07','2026-04-07','14:06','3.87','input','2026-04-07 14:07:10');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0006','1','E1E-ZDXG-48-T','1','0.720','0.720','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-E' WHERE kode_barang='E1E-ZDXG-48-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-07','TOKO','SMBK-E','E1E','E1E-ZDXG-48-T','100.00','1','0.720','0.720','1','0.720','0.720');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.720',berat_out_asli=berat_out_asli+'0.720',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-07' AND kode_barang='E1E-ZDXG-48-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0006','2','E1E-ZDXG-49-T','1','0.740','0.740','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-E' WHERE kode_barang='E1E-ZDXG-49-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-07','TOKO','SMBK-E','E1E','E1E-ZDXG-49-T','100.00','1','0.740','0.740','1','0.740','0.740');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.740',berat_out_asli=berat_out_asli+'0.740',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-07' AND kode_barang='E1E-ZDXG-49-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260407-0006','2026-04-07','2026-04-07','14:07','1.46','input','2026-04-07 14:07:37');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0007','1','D1F-ZDXG-50-T','1','1.010','1.010','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-D' WHERE kode_barang='D1F-ZDXG-50-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-07','TOKO','SMBK-D','D1F','D1F-ZDXG-50-T','100.00','1','1.010','1.010','1','1.010','1.010');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.010',berat_out_asli=berat_out_asli+'1.010',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-07' AND kode_barang='D1F-ZDXG-50-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0007','2','D1F-ZDXG-51-T','1','0.970','0.970','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-D' WHERE kode_barang='D1F-ZDXG-51-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-07','TOKO','SMBK-D','D1F','D1F-ZDXG-51-T','100.00','1','0.970','0.970','1','0.970','0.970');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.970',berat_out_asli=berat_out_asli+'0.970',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-07' AND kode_barang='D1F-ZDXG-51-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260407-0007','3','D1F-ZDXG-52-T','1','0.980','0.980','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-D' WHERE kode_barang='D1F-ZDXG-52-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-07','TOKO','SMBK-D','D1F','D1F-ZDXG-52-T','100.00','1','0.980','0.980','1','0.980','0.980');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.980',berat_out_asli=berat_out_asli+'0.980',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-07' AND kode_barang='D1F-ZDXG-52-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260407-0007','2026-04-07','2026-04-07','14:07','2.96','input','2026-04-07 14:08:14');
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 ('F226070230001','kasir','1',' TFH1 X HW ','TOKO','TBK-H','H1TF-YJXB-120-T','KL X SANTA ANAK HW 32CM 17K ','','2.110','1','100.00','4473000','0','0','15000','4473000','0','0','0','4473000','RTA','T0073700','H1TF','0','0','-','0','2120000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TF-YJXB-120-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='H1TF-YJXB-120-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070230001','2026-04-07','2.110','2026-04-07','14:30:00','PLG0078903','4473000','4473000','0','4473000','4473000','kasir','2026-04-07 14:30:00','F22607023000');
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-04-07','F226070230001','2026-04-07','14:30:00','RTA','4473000','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-260407-0025','D','2026-04-07','14:30:00','kasir','PENJUALAN','F226070230001','8229489000','4473000','8233962000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4473000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070230001' 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 ('F226070230002','kasir',' 1',' TAA0 X DG ','TOKO','TBK-A','A0TA-YLBF-10-T','AT X JERSY MRICAN DG 17K ','','0.560','1','100.00','1120000','0','0','15000','1120000','0','0','0','1120000','RTA','T0076180','A0TA','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A0TA-YLBF-10-T' 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-04-07' AND kode_barang='A0TA-YLBF-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070230002','2026-04-07','0.560','2026-04-07','14:30:00','PLG0078904','1120000','1120000','0','1120000','1120000','kasir','2026-04-07 14:30:00','F22607023000');
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-04-07','F226070230002','2026-04-07','14:30:00','RTA','1120000','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-260407-0026','D','2026-04-07','14:30:00','kasir','PENJUALAN','F226070230002','8233962000','1120000','8235082000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1120000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070230002' 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 ('F226070230003','kasir',' 1',' TED1 X UB ','TOKO','TBK-D','D1TE-ZDXD-131-T','LT X HATI ARESO UB 17K ','','0.520','1','100.00','1092000','0','0','15000','1092000','0','0','0','1092000','RTA','T0078418','D1TE','0','0','-','0','2100000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1TE-ZDXD-131-T' 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-04-07' AND kode_barang='D1TE-ZDXD-131-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070230003','2026-04-07','0.520','2026-04-07','14:30:00','PLG0078905','1092000','1092000','0','1092000','1092000','kasir','2026-04-07 14:30:00','F22607023000');
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-04-07','F226070230003','2026-04-07','14:30:00','RTA','1092000','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-260407-0027','D','2026-04-07','14:30:00','kasir','PENJUALAN','F226070230003','8235082000','1092000','8236174000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1092000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226070230003' 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 ('F226070245041','kasir','1',' THB1 X CM ','TOKO','TBK-B','B1TG-ZCBC-7-T','GW X TUSUK DEASY MATA CM 17K ','ol','0.260','1','100.00','556000','0','0','15000','565000','0','7000','0','572000','RTA','T0078242','B1TG','0','0','-','0','2140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TG-ZCBC-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='B1TG-ZCBC-7-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226070245041','2026-04-07','0.260','2026-04-07','14:45:04','PLG0078906','565000','565000','7000','572000','572000','kasir','2026-04-07 14:45:04','F22607024504');
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-04-07','F226070245041','2026-04-07','14:45:04','RTA','572000','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-260407-0028','D','2026-04-07','14:45:04','kasir','PENJUALAN','F226070245041','8236174000','572000','8236746000');
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 ('F226070256251','kasir','1',' MEE2 X CM ','TOKO','SMBK-E','E2E-ZAXI-397-0','CC X MODEL MATA CM 12 8K ','','0.750','1','100.00','870000','0','0','15000','870000','0','0','0','870000','RTA','00384774','E2E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZAXI-397-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='E2E-ZAXI-397-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070256251','2026-04-07','0.750','2026-04-07','14:56:25','PLG0078907','870000','870000','0','870000','870000','kasir','2026-04-07 14:56:25','F22607025625');
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-04-07','F226070256251','2026-04-07','14:56:25','RTA','870000','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-260407-0029','D','2026-04-07','14:56:25','kasir','PENJUALAN','F226070256251','8236746000','870000','8237616000');
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 ('F226070259271','kasir','1',' MDE1 HW 13','TOKO','SMBK-E','E1E-ZCAA-22-T','CC MODEL SLEP VAR HW 13 8K ','','0.660','1','100.00','766000','0','0','15000','752000','0','0','0','752000','RTA','T0078021','E1E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAA-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='E1E-ZCAA-22-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226070259271','2026-04-07','0.660','2026-04-07','14:59:27','PLG0078908','752000','752000','0','752000','752000','kasir','2026-04-07 14:59:27','F22607025927');
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-04-07','F226070259271','2026-04-07','14:59:27','RTA','752000','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-260407-0030','D','2026-04-07','14:59:27','kasir','PENJUALAN','F226070259271','8237616000','752000','8238368000');
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-00005255','X-00005255','KL MILANO UB 40CM 17K','GR','---','H1TG','BELI','BELI001','3840000','2026-04-07','2.030','1','kasir','2026-04-07 15:31:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1TG';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1TG','X-00005255','X-00005255');
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-260407-0001','F226270319361','RTA','1','BELI','BELI001','H1TG', 'X-00005255', 'KL MILANO UB 40CM 17K','2.030','2.030','100.00','4696000','3840000','1891626','2140000','1','3840000','3840000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.030',berat_beli_asli=berat_beli_asli+'2.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.030',berat_akhir_asli=berat_akhir_asli+'2.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1TG' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260407-0001','2026-04-07','2026-04-07','15:31:23','RTA','---','2.030','3840000','3840000','3840000','3840000','3840000','kasir','2026-04-07 15:31:23','FB-260407-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260407-0001','APRITA','JL BATORO KATONG GG5 NO.9','','','0895376645555','kasir','2026-04-07 15:31:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-07' 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-260407-0031','K','2026-04-07','15:31:23','kasir','PEMBELIAN UMUM','FB-260407-0001','8238368000','3840000','8234528000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260407-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260407-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070230001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070230001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070230001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070230002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070230002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070230002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070230003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070230003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070230003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070245041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070245041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070245041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070256251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070256251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070256251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070259271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070259271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070259271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070944051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070944051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070944051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070944052' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070944052' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070944052';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070947251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070947251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070947251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070948001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070948001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070948001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070948002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070948002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070948002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070950191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070950191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070950191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070950192' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070950192' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070950192';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070950193' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070950193' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070950193';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070950194' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070950194' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070950194';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070950195' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070950195' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070950195';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070950196' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070950196' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070950196';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070950197' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070950197' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070950197';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070950198' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070950198' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070950198';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070951371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070951371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070951371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070951372' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070951372' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070951372';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070951373' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070951373' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070951373';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226070951374' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226070951374' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226070951374';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071000331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071000331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071000331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071119451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071119451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071119451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071130551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071130551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071130551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071130552' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071130552' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071130552';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071238141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071238141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071238141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226071238142' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226071238142' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226071238142';
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-00005256','X-00005256','CC COR M 17K','GR','---','E2TF','BELI','BELI001','3315000','2026-04-07','1.950','1','admin','2026-04-07 15:46:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TF','X-00005256','X-00005256');
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-260407-0002','F223271055541','NS','1','BELI','BELI001','E2TF', 'X-00005256', 'CC COR M 17K','2.080','1.950','100.00','1776000','3315000','1700000','2120000','1','3315000','3315000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.950',berat_beli_asli=berat_beli_asli+'1.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.950',berat_akhir_asli=berat_akhir_asli+'1.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TF' 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-260407-0002','2026-04-07','2026-04-07','15:46:47','NS','---','1.950','3315000','3315000','3315000','3315000','3315000','admin','2026-04-07 15:46:48','FB-260407-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260407-0002','','','','','','admin','2026-04-07 15:46:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-07' 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-260407-0032','K','2026-04-07','15:46:47','admin','PEMBELIAN UMUM','FB-260407-0002','8234528000','3315000','8231213000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260407-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260407-0002';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-08','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-08';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-07';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-07';
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-04-07' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-07';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-07';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-07';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-07';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-08' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-07' 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-260408-0001','D','2026-04-08','16:27:43','SYSTEM','SALDO AWAL','SALDO AWAL','0','8231213000','8231213000');
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-260408-0001','D','2026-04-08','16:27:43','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260408-0001','D','2026-04-08','16:27:43','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260408-0001','D','2026-04-08','16:27:43','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-260408-0001','D','2026-04-08','16:27:43','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260408-0001','D','2026-04-08','16:27:43','BCA','SALDO AWAL','SALDO AWAL','0','4340466888','4340466888');
UPDATE tp_system SET tgl_system='2026-04-08';