INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260317-0001','1','F2E-ZAAE-43-0','1','4.950','4.950','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-ZAAE-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZAAE-43-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-03-17 07:59:32' WHERE kode_barang='F2E-ZAAE-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZAAE-43-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-17 07:59:32','TOKO','SMBK-F','F2E','F2E-ZAAE-43-0','1','4.950','4.950','1','4.950','4.950','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F2E-ZAAE-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZAAE-43-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260317-0001','1','F2E-ZCXG-164-0','1','4.050','4.050','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-ZCXG-164-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZCXG-164-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-03-17 07:59:32' WHERE kode_barang='F2E-ZCXG-164-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZCXG-164-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-17 07:59:32','TOKO','SMBK-F','F2E','F2E-ZCXG-164-0','1','4.050','4.050','1','4.050','4.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F2E-ZCXG-164-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZCXG-164-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260317-0001','2026-03-17','07:59','9.000','input','2026-03-17 07:59:32');
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 ('F226170812331','admin','1',' MEA1 LG ','TOKO','SMBK-A','A1E-ZCXG-8-T','AT GYPSY MATA VAR LG 8K ','OLS VJ8R','0.520','1','100.00','621000','0','0','15000','629000','0','43000','0','672000','TIN','T0077879','A1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZCXG-8-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-03-17' AND kode_barang='A1E-ZCXG-8-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 ('F226170812331','2026-03-17','0.520','2026-03-17','08:12:34','PLG0078244','629000','629000','43000','672000','672000','admin','2026-03-17 08:12:33','F22617081233');
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-03-17','F226170812331','2026-03-17','08:12:34','TIN','672000','43000');
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-260317-0002','D','2026-03-17','08:12:34','admin','PENJUALAN','F226170812331','7278397000','672000','7279069000');
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 ('F226170840361','admin','1',' MHB1 LG ','TOKO','SMBK-B','B1H-ZCXG-67-T','GW TUSUK MRICAN POLOS LG 8K ','OL','0.250','1','100.00','314000','0','0','15000','318000','0','5000','0','323000','RTA','T0077938','B1H','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZCXG-67-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='B1H-ZCXG-67-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226170840361','2026-03-17','0.250','2026-03-17','08:40:37','PLG0078245','318000','318000','5000','323000','323000','admin','2026-03-17 08:40:36','F22617084036');
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-03-17','F226170840361','2026-03-17','08:40:37','RTA','323000','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-260317-0003','D','2026-03-17','08:40:37','admin','PENJUALAN','F226170840361','7279069000','323000','7279392000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='323000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170840361' 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 ('F226170840362','admin',' 1',' MHB1 LG ','TOKO','SMBK-B','B1H-ZCXG-65-T','GW TUSUK MRICAN POLOS LG 8K ','OL','0.260','1','100.00','326000','0','0','15000','330000','0','5000','0','335000','RTA','T0077936','B1H','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZCXG-65-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-03-17' AND kode_barang='B1H-ZCXG-65-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226170840362','2026-03-17','0.260','2026-03-17','08:40:37','PLG0078246','330000','330000','5000','335000','335000','admin','2026-03-17 08:40:36','F22617084036');
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-03-17','F226170840362','2026-03-17','08:40:37','RTA','335000','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-260317-0004','D','2026-03-17','08:40:37','admin','PENJUALAN','F226170840362','7279392000','335000','7279727000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='335000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170840362' 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 ('F226170840363','admin',' 1',' MED1 UB ','TOKO','SMBK-D','D1E-ZCXF-7-T','LT SLOBOK BAMBU BUNGA VAR UB 8K ','OL','0.550','1','100.00','657000','0','0','15000','666000','0','5000','0','671000','RTA','T0077829','D1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZCXF-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='D1E-ZCXF-7-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226170840363','2026-03-17','0.550','2026-03-17','08:40:37','PLG0078247','666000','666000','5000','671000','671000','admin','2026-03-17 08:40:36','F22617084036');
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-03-17','F226170840363','2026-03-17','08:40:37','RTA','671000','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-260317-0005','D','2026-03-17','08:40:37','admin','PENJUALAN','F226170840363','7279727000','671000','7280398000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='671000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170840363' 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 ('F226170840364','admin',' 1',' MED1E X YT','TOKO','SMBK-D','D1E-ZCXG-318-0','LT X MODEL SPECTRA HITAM YT 8K ','OL','0.510','1','100.00','609000','0','0','15000','617000','0','5000','0','622000','RTA','00392754','D1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZCXG-318-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='D1E-ZCXG-318-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226170840364','2026-03-17','0.510','2026-03-17','08:40:37','PLG0078248','617000','617000','5000','622000','622000','admin','2026-03-17 08:40:36','F22617084036');
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-03-17','F226170840364','2026-03-17','08:40:37','RTA','622000','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-260317-0006','D','2026-03-17','08:40:37','admin','PENJUALAN','F226170840364','7280398000','622000','7281020000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='622000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170840364' 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 ('F226170840365','admin',' 1',' MEE1 CM 12','TOKO','SMBK-E','E1E-ZCAX-9-T','CC MODEL SLEP VAR CM 12 8K ','OL','0.400','1','100.00','478000','0','0','15000','485000','0','5000','0','490000','RTA','T0077950','E1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAX-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='E1E-ZCAX-9-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 ('F226170840365','2026-03-17','0.400','2026-03-17','08:40:37','PLG0078249','485000','485000','5000','490000','490000','admin','2026-03-17 08:40:36','F22617084036');
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-03-17','F226170840365','2026-03-17','08:40:37','RTA','490000','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-260317-0007','D','2026-03-17','08:40:37','admin','PENJUALAN','F226170840365','7281020000','490000','7281510000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='490000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170840365' 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 ('F226170840366','admin',' 1',' MEE1 LG 16','TOKO','SMBK-E','E1E-ZCXG-48-T','CC MODEL DAUN SLEP VAR LG 16 8K ','OL','0.400','1','100.00','478000','0','0','15000','485000','0','5000','0','490000','RTA','T0077919','E1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCXG-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='E1E-ZCXG-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 ('F226170840366','2026-03-17','0.400','2026-03-17','08:40:37','PLG0078250','485000','485000','5000','490000','490000','admin','2026-03-17 08:40:36','F22617084036');
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-03-17','F226170840366','2026-03-17','08:40:37','RTA','490000','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-260317-0008','D','2026-03-17','08:40:37','admin','PENJUALAN','F226170840366','7281510000','490000','7282000000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='490000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170840366' 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 ('F226170840367','admin',' 1',' MEE1 LG 14','TOKO','SMBK-E','E1E-ZCXG-47-T','CC MODEL DAUN SLEP VAR LG 14 8K ','OL','0.400','1','100.00','478000','0','0','15000','485000','0','5000','0','490000','RTA','T0077918','E1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCXG-47-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='E1E-ZCXG-47-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 ('F226170840367','2026-03-17','0.400','2026-03-17','08:40:37','PLG0078251','485000','485000','5000','490000','490000','admin','2026-03-17 08:40:36','F22617084036');
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-03-17','F226170840367','2026-03-17','08:40:37','RTA','490000','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-260317-0009','D','2026-03-17','08:40:37','admin','PENJUALAN','F226170840367','7282000000','490000','7282490000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='490000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170840367' 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 ('F226170840368','admin',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZCAX-14-T','CC MODEL BUNGA CAT VAR CM 12 8K ','OL','0.420','1','100.00','502000','0','0','15000','508000','0','5000','0','513000','RTA','T0077955','E1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAX-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='E1E-ZCAX-14-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 ('F226170840368','2026-03-17','0.420','2026-03-17','08:40:37','PLG0078252','508000','508000','5000','513000','513000','admin','2026-03-17 08:40:36','F22617084036');
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-03-17','F226170840368','2026-03-17','08:40:37','RTA','513000','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-260317-0010','D','2026-03-17','08:40:37','admin','PENJUALAN','F226170840368','7282490000','513000','7283003000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='513000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170840368' 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 ('F226170840369','admin',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZCAX-12-T','CC MODEL BUNGA CAT VAR CM 10 8K ','OL','0.420','1','100.00','502000','0','0','15000','508000','0','5000','0','513000','RTA','T0077953','E1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAX-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='E1E-ZCAX-12-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 ('F226170840369','2026-03-17','0.420','2026-03-17','08:40:37','PLG0078253','508000','508000','5000','513000','513000','admin','2026-03-17 08:40:36','F22617084036');
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-03-17','F226170840369','2026-03-17','08:40:37','RTA','513000','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-260317-0011','D','2026-03-17','08:40:37','admin','PENJUALAN','F226170840369','7283003000','513000','7283516000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='513000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170840369' 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 ('F226170842481','admin','1',' MEB1 BW ','TOKO','SMBK-B','B1E-ZAXG-21-T','GW TUSUK BUNGA PASIR 2C BW 8K ','OL','0.460','1','100.00','550000','0','0','15000','557000','0','5000','0','562000','RTA','T0076312','B1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZAXG-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='B1E-ZAXG-21-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226170842481','2026-03-17','0.460','2026-03-17','08:42:49','PLG0078254','557000','557000','5000','562000','562000','admin','2026-03-17 08:42:48','F22617084248');
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-03-17','F226170842481','2026-03-17','08:42:49','RTA','562000','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-260317-0012','D','2026-03-17','08:42:49','admin','PENJUALAN','F226170842481','7283516000','562000','7284078000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='562000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170842481' 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 ('F226170842482','admin',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZCAX-16-T','CC MODEL BUNGA CAT VAR CM 14 8K ','OL','0.450','1','100.00','538000','0','0','15000','545000','0','5000','0','550000','RTA','T0077957','E1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAX-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='E1E-ZCAX-16-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 ('F226170842482','2026-03-17','0.450','2026-03-17','08:42:49','PLG0078255','545000','545000','5000','550000','550000','admin','2026-03-17 08:42:48','F22617084248');
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-03-17','F226170842482','2026-03-17','08:42:49','RTA','550000','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-260317-0013','D','2026-03-17','08:42:49','admin','PENJUALAN','F226170842482','7284078000','550000','7284628000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='550000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170842482' 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 ('F226170842483','admin',' 1',' MEF3 XUB ','TOKO','SMBK-F','F3E-ZCXG-272-0','GL X JEDAR UB 8K ','OL','0.520','1','100.00','621000','0','0','15000','630000','0','5000','0','635000','RTA','00392708','F3E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCXG-272-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='F3E-ZCXG-272-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 ('F226170842483','2026-03-17','0.520','2026-03-17','08:42:49','PLG0078256','630000','630000','5000','635000','635000','admin','2026-03-17 08:42:48','F22617084248');
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-03-17','F226170842483','2026-03-17','08:42:49','RTA','635000','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-260317-0014','D','2026-03-17','08:42:49','admin','PENJUALAN','F226170842483','7284628000','635000','7285263000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='635000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170842483' 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 ('F226170842484','admin',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZBAX-49-T','GL MODEL FLIK BINTANG VAR HW 8K ','OL','1.820','1','100.00','2175000','0','0','15000','2193000','0','9000','0','2202000','RTA','T0077164','F3E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAX-49-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.820',berat_jual_asli=berat_jual_asli+'1.820',stock_jual='1',berat_akhir=berat_akhir-'1.820',berat_akhir_asli=berat_akhir_asli-'1.820',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='F3E-ZBAX-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 ('F226170842484','2026-03-17','1.820','2026-03-17','08:42:49','PLG0078257','2193000','2193000','9000','2202000','2202000','admin','2026-03-17 08:42:48','F22617084248');
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-03-17','F226170842484','2026-03-17','08:42:49','RTA','2202000','9000');
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-260317-0015','D','2026-03-17','08:42:49','admin','PENJUALAN','F226170842484','7285263000','2202000','7287465000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2202000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170842484' 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 ('F226170842485','admin',' 1',' MED1 5K LG','TOKO','SMBK-D','D1E-ZCXG-19-T','LT MODEL APEL CAT VAR LG 8K ','OL','0.520','1','100.00','621000','0','0','15000','630000','0','5000','0','635000','RTA','T0077890','D1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZCXG-19-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-03-17' AND kode_barang='D1E-ZCXG-19-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226170842485','2026-03-17','0.520','2026-03-17','08:42:49','PLG0078258','630000','630000','5000','635000','635000','admin','2026-03-17 08:42:48','F22617084248');
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-03-17','F226170842485','2026-03-17','08:42:49','RTA','635000','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-260317-0016','D','2026-03-17','08:42:49','admin','PENJUALAN','F226170842485','7287465000','635000','7288100000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='635000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170842485' 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 ('F226170851361','admin','1',' MEA1 LG ','TOKO','SMBK-A','A1E-ZCXG-7-T','AT GYPSY MATA VAR LG 8K ','OLS VJ8R','0.510','1','100.00','609000','0','0','15000','617000','0','80000','0','697000','NS','T0077878','A1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZCXG-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='A1E-ZCXG-7-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 ('F226170851361','2026-03-17','0.510','2026-03-17','08:51:37','PLG0078259','617000','617000','80000','697000','697000','admin','2026-03-17 08:51:36','F22617085136');
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-03-17','F226170851361','2026-03-17','08:51:37','NS','697000','80000');
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-260317-0017','D','2026-03-17','08:51:37','admin','PENJUALAN','F226170851361','7288100000','697000','7288797000');
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-260317-0001','1','H1E-ZCAB-4-T','1','1.980','1.980','TOKO','SMBK-H','TOKO','BK-H');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-H' WHERE kode_barang='H1E-ZCAB-4-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-H';
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-03-17','TOKO','BK-H','H1E','H1E-ZCAB-4-T','100.00','1','1.980','1.980','1','1.980','1.980');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.980',berat_out_asli=berat_out_asli+'1.980',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='H1E-ZCAB-4-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-H' 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-260317-0001','2026-03-17','2026-03-17','09:31','1.98','admin','2026-03-17 09:32:20');
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-260317-0002','1','B1F-YICX-31-T','1','1.040','1.040','TOKO','SMBK-B','TOKO','BK-B');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-B' WHERE kode_barang='B1F-YICX-31-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-B';
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-03-17','TOKO','BK-B','B1F','B1F-YICX-31-T','100.00','1','1.040','1.040','1','1.040','1.040');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.040',berat_out_asli=berat_out_asli+'1.040',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='B1F-YICX-31-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-B' 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-260317-0002','2','B1E-ZCXF-5-T','1','0.710','0.710','TOKO','SMBK-B','TOKO','BK-B');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-B' WHERE kode_barang='B1E-ZCXF-5-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-B';
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-03-17','TOKO','BK-B','B1E','B1E-ZCXF-5-T','100.00','1','0.710','0.710','1','0.710','0.710');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.710',berat_out_asli=berat_out_asli+'0.710',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='B1E-ZCXF-5-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-B' 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-260317-0002','3','B1F-XJAB-242-T','1','0.770','0.770','TOKO','SMBK-B','TOKO','BK-B');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-B' WHERE kode_barang='B1F-XJAB-242-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-B';
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-03-17','TOKO','BK-B','B1F','B1F-XJAB-242-T','100.00','1','0.770','0.770','1','0.770','0.770');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.770',berat_out_asli=berat_out_asli+'0.770',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='B1F-XJAB-242-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-B' 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-260317-0002','2026-03-17','2026-03-17','09:32','2.52','admin','2026-03-17 09:34:23');
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-260317-0003','1','F3E-ZBAI-97-T','1','1.050','1.050','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-ZBAI-97-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-03-17','TOKO','BK-F','F3E','F3E-ZBAI-97-T','100.00','1','1.050','1.050','1','1.050','1.050');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.050',berat_out_asli=berat_out_asli+'1.050',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-ZBAI-97-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','2','F3E-ZBAC-25-T','1','1.200','1.200','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-ZBAC-25-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-03-17','TOKO','BK-F','F3E','F3E-ZBAC-25-T','100.00','1','1.200','1.200','1','1.200','1.200');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.200',berat_out_asli=berat_out_asli+'1.200',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-ZBAC-25-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','3','F3E-YHXE-37-T','1','2.330','2.330','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-YHXE-37-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-03-17','TOKO','BK-F','F3E','F3E-YHXE-37-T','100.00','1','2.330','2.330','1','2.330','2.330');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.330',berat_out_asli=berat_out_asli+'2.330',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-YHXE-37-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','4','F3E-YJCX-13-T','1','1.500','1.500','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-YJCX-13-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-03-17','TOKO','BK-F','F3E','F3E-YJCX-13-T','100.00','1','1.500','1.500','1','1.500','1.500');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.500',berat_out_asli=berat_out_asli+'1.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-YJCX-13-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','5','F3G-YJAE-63-T','1','0.350','0.350','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='F3G-YJAE-63-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-03-17','TOKO','BK-F','F3G','F3G-YJAE-63-T','100.00','1','0.350','0.350','1','0.350','0.350');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.350',berat_out_asli=berat_out_asli+'0.350',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3G-YJAE-63-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','6','F3E-YEXC-45-T','1','2.560','2.560','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-YEXC-45-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-03-17','TOKO','BK-F','F3E','F3E-YEXC-45-T','100.00','1','2.560','2.560','1','2.560','2.560');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.560',berat_out_asli=berat_out_asli+'2.560',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-YEXC-45-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','7','F3G-YJAE-61-T','1','0.370','0.370','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='F3G-YJAE-61-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-03-17','TOKO','BK-F','F3G','F3G-YJAE-61-T','100.00','1','0.370','0.370','1','0.370','0.370');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.370',berat_out_asli=berat_out_asli+'0.370',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3G-YJAE-61-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','8','F3E-YHAB-52-T','1','1.930','1.930','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-YHAB-52-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-03-17','TOKO','BK-F','F3E','F3E-YHAB-52-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-03-17' AND kode_barang='F3E-YHAB-52-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','9','F3E-YLXD-37-T','1','2.750','2.750','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-YLXD-37-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-03-17','TOKO','BK-F','F3E','F3E-YLXD-37-T','100.00','1','2.750','2.750','1','2.750','2.750');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.750',berat_out_asli=berat_out_asli+'2.750',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-YLXD-37-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','10','F3E-YHAC-47-0','1','3.510','3.510','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-YHAC-47-0' 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-03-17','TOKO','BK-F','F3E','F3E-YHAC-47-0','100.00','1','3.510','3.510','1','3.510','3.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.510',berat_out_asli=berat_out_asli+'3.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-YHAC-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','11','F3E-YHAC-52-0','1','3.720','3.720','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-YHAC-52-0' 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-03-17','TOKO','BK-F','F3E','F3E-YHAC-52-0','100.00','1','3.720','3.720','1','3.720','3.720');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.720',berat_out_asli=berat_out_asli+'3.720',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-YHAC-52-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','12','F3E-YEXA-60-T','1','2.600','2.600','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-YEXA-60-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-03-17','TOKO','BK-F','F3E','F3E-YEXA-60-T','100.00','1','2.600','2.600','1','2.600','2.600');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.600',berat_out_asli=berat_out_asli+'2.600',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-YEXA-60-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','13','F3E-YEBD-253-0','1','1.900','1.900','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-YEBD-253-0' 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-03-17','TOKO','BK-F','F3E','F3E-YEBD-253-0','100.00','1','1.900','1.900','1','1.900','1.900');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.900',berat_out_asli=berat_out_asli+'1.900',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-YEBD-253-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','14','F3E-YHXE-42-T','1','3.050','3.050','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-YHXE-42-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-03-17','TOKO','BK-F','F3E','F3E-YHXE-42-T','100.00','1','3.050','3.050','1','3.050','3.050');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.050',berat_out_asli=berat_out_asli+'3.050',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-YHXE-42-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','15','F3E-YKBI-20-T','1','2.170','2.170','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-YKBI-20-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-03-17','TOKO','BK-F','F3E','F3E-YKBI-20-T','100.00','1','2.170','2.170','1','2.170','2.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.170',berat_out_asli=berat_out_asli+'2.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-YKBI-20-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','16','F3F-YLAH-4-T','1','0.510','0.510','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='F3F-YLAH-4-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-03-17','TOKO','BK-F','F3F','F3F-YLAH-4-T','100.00','1','0.510','0.510','1','0.510','0.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.510',berat_out_asli=berat_out_asli+'0.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3F-YLAH-4-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','17','F3E-ZBAI-10-T','1','1.500','1.500','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-ZBAI-10-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-03-17','TOKO','BK-F','F3E','F3E-ZBAI-10-T','100.00','1','1.500','1.500','1','1.500','1.500');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.500',berat_out_asli=berat_out_asli+'1.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-ZBAI-10-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','18','F3E-ZBAI-12-T','1','1.700','1.700','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-ZBAI-12-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-03-17','TOKO','BK-F','F3E','F3E-ZBAI-12-T','100.00','1','1.700','1.700','1','1.700','1.700');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.700',berat_out_asli=berat_out_asli+'1.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-ZBAI-12-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','19','F3E-YLXE-40-T','1','1.930','1.930','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-YLXE-40-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-03-17','TOKO','BK-F','F3E','F3E-YLXE-40-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-03-17' AND kode_barang='F3E-YLXE-40-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','20','F3F-YJCA-16-T','1','2.050','2.050','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='F3F-YJCA-16-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-03-17','TOKO','BK-F','F3F','F3F-YJCA-16-T','100.00','1','2.050','2.050','1','2.050','2.050');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.050',berat_out_asli=berat_out_asli+'2.050',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3F-YJCA-16-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','21','F3E-YLAE-17-T','1','1.360','1.360','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-YLAE-17-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-03-17','TOKO','BK-F','F3E','F3E-YLAE-17-T','100.00','1','1.360','1.360','1','1.360','1.360');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.360',berat_out_asli=berat_out_asli+'1.360',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-YLAE-17-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','22','F3E-YLXE-7-T','1','1.720','1.720','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-YLXE-7-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-03-17','TOKO','BK-F','F3E','F3E-YLXE-7-T','100.00','1','1.720','1.720','1','1.720','1.720');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.720',berat_out_asli=berat_out_asli+'1.720',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-YLXE-7-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','23','F3E-ZBAD-2-T','1','2.490','2.490','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-ZBAD-2-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-03-17','TOKO','BK-F','F3E','F3E-ZBAD-2-T','100.00','1','2.490','2.490','1','2.490','2.490');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.490',berat_out_asli=berat_out_asli+'2.490',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-ZBAD-2-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','24','F3E-YLAE-19-T','1','2.510','2.510','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-YLAE-19-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-03-17','TOKO','BK-F','F3E','F3E-YLAE-19-T','100.00','1','2.510','2.510','1','2.510','2.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.510',berat_out_asli=berat_out_asli+'2.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-YLAE-19-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','25','F3E-ZACA-23-T','1','1.700','1.700','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-ZACA-23-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-03-17','TOKO','BK-F','F3E','F3E-ZACA-23-T','100.00','1','1.700','1.700','1','1.700','1.700');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.700',berat_out_asli=berat_out_asli+'1.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-ZACA-23-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','26','F3E-ZBAH-23-T','1','2.030','2.030','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-ZBAH-23-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-03-17','TOKO','BK-F','F3E','F3E-ZBAH-23-T','100.00','1','2.030','2.030','1','2.030','2.030');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.030',berat_out_asli=berat_out_asli+'2.030',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-ZBAH-23-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' 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-260317-0003','27','F3E-YLBX-17-T','1','5.260','5.260','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-YLBX-17-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-03-17','TOKO','BK-F','F3E','F3E-YLBX-17-T','100.00','1','5.260','5.260','1','5.260','5.260');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.260',berat_out_asli=berat_out_asli+'5.260',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3E-YLBX-17-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-260317-0003','2026-03-17','2026-03-17','09:34','55.75','admin','2026-03-17 09:39:44');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0001','1','B1F-XJAB-242-T','1','0.770','TOKO','BK-B');
DELETE FROM tm_barang_export WHERE kode_barang='B1F-XJAB-242-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='B1F-XJAB-242-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='MF' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MF' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='B1F' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='B1F' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-B';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-B';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='B1F-XJAB-242-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.770',berat_out_asli='0.770', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.770',berat_akhir_asli =berat_akhir_asli-'0.770' WHERE kode_barang='B1F-XJAB-242-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0001','2','B1F-YICX-31-T','1','1.040','TOKO','BK-B');
DELETE FROM tm_barang_export WHERE kode_barang='B1F-YICX-31-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='B1F-YICX-31-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='MF' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MF' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='B1F' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='B1F' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-B';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-B';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='B1F-YICX-31-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.040',berat_out_asli='1.040', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.040',berat_akhir_asli =berat_akhir_asli-'1.040' WHERE kode_barang='B1F-YICX-31-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0001','3','B1E-ZCXF-5-T','1','0.710','TOKO','BK-B');
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZCXF-5-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='B1E-ZCXF-5-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='B1E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-B';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-B';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='B1E-ZCXF-5-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.710',berat_out_asli='0.710', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.710',berat_akhir_asli =berat_akhir_asli-'0.710' WHERE kode_barang='B1E-ZCXF-5-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-260317-0001','2026-03-17','2026-03-17','09:47','0.710','input','260317');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','1','F3E-YEXA-60-T','1','2.600','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YEXA-60-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YEXA-60-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-YEXA-60-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.600',berat_out_asli='2.600', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.600',berat_akhir_asli =berat_akhir_asli-'2.600' WHERE kode_barang='F3E-YEXA-60-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','2','F3E-YEXC-45-T','1','2.560','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YEXC-45-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YEXC-45-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-YEXC-45-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.560',berat_out_asli='2.560', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.560',berat_akhir_asli =berat_akhir_asli-'2.560' WHERE kode_barang='F3E-YEXC-45-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','3','F3E-YLAE-17-T','1','1.360','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YLAE-17-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YLAE-17-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-YLAE-17-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.360',berat_out_asli='1.360', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.360',berat_akhir_asli =berat_akhir_asli-'1.360' WHERE kode_barang='F3E-YLAE-17-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','4','F3E-YEBD-253-0','1','1.900','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YEBD-253-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YEBD-253-0' 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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-YEBD-253-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.900',berat_out_asli='1.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.900',berat_akhir_asli =berat_akhir_asli-'1.900' WHERE kode_barang='F3E-YEBD-253-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','5','F3E-YHXE-37-T','1','2.330','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YHXE-37-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YHXE-37-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-YHXE-37-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.330',berat_out_asli='2.330', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.330',berat_akhir_asli =berat_akhir_asli-'2.330' WHERE kode_barang='F3E-YHXE-37-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','6','F3E-YHXE-42-T','1','3.050','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YHXE-42-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YHXE-42-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-YHXE-42-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.050',berat_out_asli='3.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.050',berat_akhir_asli =berat_akhir_asli-'3.050' WHERE kode_barang='F3E-YHXE-42-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','7','F3E-YLAE-19-T','1','2.510','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YLAE-19-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YLAE-19-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-YLAE-19-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.510',berat_out_asli='2.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.510',berat_akhir_asli =berat_akhir_asli-'2.510' WHERE kode_barang='F3E-YLAE-19-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','8','F3E-YHAB-52-T','1','1.930','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YHAB-52-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YHAB-52-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-YHAB-52-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.930',berat_out_asli='1.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.930',berat_akhir_asli =berat_akhir_asli-'1.930' WHERE kode_barang='F3E-YHAB-52-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','9','F3E-YHAC-47-0','1','3.510','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YHAC-47-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YHAC-47-0' 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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-YHAC-47-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.510',berat_out_asli='3.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.510',berat_akhir_asli =berat_akhir_asli-'3.510' WHERE kode_barang='F3E-YHAC-47-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','10','F3E-YHAC-52-0','1','3.720','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YHAC-52-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YHAC-52-0' 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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-YHAC-52-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.720',berat_out_asli='3.720', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.720',berat_akhir_asli =berat_akhir_asli-'3.720' WHERE kode_barang='F3E-YHAC-52-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','11','F3G-YJAE-61-T','1','0.370','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3G-YJAE-61-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3G-YJAE-61-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='MG' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MG' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='F3G' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3G' 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='F3G-YJAE-61-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.370',berat_out_asli='0.370', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.370',berat_akhir_asli =berat_akhir_asli-'0.370' WHERE kode_barang='F3G-YJAE-61-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','12','F3G-YJAE-63-T','1','0.350','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3G-YJAE-63-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3G-YJAE-63-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='MG' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MG' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='F3G' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3G' 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='F3G-YJAE-63-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.350',berat_out_asli='0.350', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.350',berat_akhir_asli =berat_akhir_asli-'0.350' WHERE kode_barang='F3G-YJAE-63-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','13','F3E-YJCX-13-T','1','1.500','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YJCX-13-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YJCX-13-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-YJCX-13-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.500',berat_out_asli='1.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.500',berat_akhir_asli =berat_akhir_asli-'1.500' WHERE kode_barang='F3E-YJCX-13-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','14','F3F-YJCA-16-T','1','2.050','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3F-YJCA-16-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3F-YJCA-16-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='MF' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MF' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='F3F' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3F' 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='F3F-YJCA-16-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.050',berat_out_asli='2.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.050',berat_akhir_asli =berat_akhir_asli-'2.050' WHERE kode_barang='F3F-YJCA-16-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','15','F3E-YKBI-20-T','1','2.170','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YKBI-20-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YKBI-20-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-YKBI-20-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.170',berat_out_asli='2.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.170',berat_akhir_asli =berat_akhir_asli-'2.170' WHERE kode_barang='F3E-YKBI-20-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','16','F3E-YLXD-37-T','1','2.750','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YLXD-37-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YLXD-37-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-YLXD-37-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.750',berat_out_asli='2.750', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.750',berat_akhir_asli =berat_akhir_asli-'2.750' WHERE kode_barang='F3E-YLXD-37-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','17','F3E-YLXE-7-T','1','1.720','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YLXE-7-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YLXE-7-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-YLXE-7-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.720',berat_out_asli='1.720', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.720',berat_akhir_asli =berat_akhir_asli-'1.720' WHERE kode_barang='F3E-YLXE-7-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','18','F3E-YLXE-40-T','1','1.930','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YLXE-40-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YLXE-40-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-YLXE-40-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.930',berat_out_asli='1.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.930',berat_akhir_asli =berat_akhir_asli-'1.930' WHERE kode_barang='F3E-YLXE-40-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','19','F3F-YLAH-4-T','1','0.510','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3F-YLAH-4-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3F-YLAH-4-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='MF' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MF' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='F3F' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3F' 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='F3F-YLAH-4-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.510',berat_out_asli='0.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.510',berat_akhir_asli =berat_akhir_asli-'0.510' WHERE kode_barang='F3F-YLAH-4-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','20','F3E-YLBX-17-T','1','5.260','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YLBX-17-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YLBX-17-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-YLBX-17-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.260',berat_out_asli='5.260', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.260',berat_akhir_asli =berat_akhir_asli-'5.260' WHERE kode_barang='F3E-YLBX-17-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','21','F3E-ZACA-23-T','1','1.700','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZACA-23-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-ZACA-23-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-ZACA-23-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.700',berat_out_asli='1.700', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.700',berat_akhir_asli =berat_akhir_asli-'1.700' WHERE kode_barang='F3E-ZACA-23-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','22','F3E-ZBAC-25-T','1','1.200','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZBAC-25-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-ZBAC-25-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-ZBAC-25-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.200',berat_out_asli='1.200', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.200',berat_akhir_asli =berat_akhir_asli-'1.200' WHERE kode_barang='F3E-ZBAC-25-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','23','F3E-ZBAD-2-T','1','2.490','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZBAD-2-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-ZBAD-2-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-ZBAD-2-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.490',berat_out_asli='2.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.490',berat_akhir_asli =berat_akhir_asli-'2.490' WHERE kode_barang='F3E-ZBAD-2-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','24','F3E-ZBAH-23-T','1','2.030','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZBAH-23-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-ZBAH-23-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-ZBAH-23-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.030',berat_out_asli='2.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.030',berat_akhir_asli =berat_akhir_asli-'2.030' WHERE kode_barang='F3E-ZBAH-23-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','25','F3E-ZBAI-10-T','1','1.500','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZBAI-10-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-ZBAI-10-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-ZBAI-10-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.500',berat_out_asli='1.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.500',berat_akhir_asli =berat_akhir_asli-'1.500' WHERE kode_barang='F3E-ZBAI-10-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','26','F3E-ZBAI-12-T','1','1.700','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZBAI-12-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-ZBAI-12-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-ZBAI-12-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.700',berat_out_asli='1.700', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.700',berat_akhir_asli =berat_akhir_asli-'1.700' WHERE kode_barang='F3E-ZBAI-12-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0002','27','F3E-ZBAI-97-T','1','1.050','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZBAI-97-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-ZBAI-97-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='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' 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='F3E-ZBAI-97-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='F3E-ZBAI-97-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-260317-0002','2026-03-17','2026-03-17','09:47','1.050','input','260317');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260317-0003','1','H1E-ZCAB-4-T','1','1.980','TOKO','BK-H');
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZCAB-4-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='H1E-ZCAB-4-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='H1E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-H';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-H';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='H1E-ZCAB-4-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.980',berat_out_asli='1.980', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.980',berat_akhir_asli =berat_akhir_asli-'1.980' WHERE kode_barang='H1E-ZCAB-4-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-260317-0003','2026-03-17','2026-03-17','09:47','1.980','input','260317');
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 ('F226170954231','kasir','1',' MDE1 X HW ','TOKO','SMBK-E','E1D-ZCAD-236-0','CC X MODEL SLEP HW 15 8K ','OL','0.620','1','100.00','728000','0','0','15000','735000','0','5000','0','740000','RTA','00394369','E1D','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCAD-236-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='E1D-ZCAD-236-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 ('F226170954231','2026-03-17','0.620','2026-03-17','09:54:24','PLG0078260','735000','735000','5000','740000','740000','kasir','2026-03-17 09:54:23','F22617095423');
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-03-17','F226170954231','2026-03-17','09:54:24','RTA','740000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260317-0019','D','2026-03-17','09:54:24','kasir','PENJUALAN','F226170954231','7288100000','740000','7288840000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170954231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170954231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170954231';
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 ('F226170958301','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-ZCXG-4-T','AT TINDIK BABY LG 8K ','OL','0.460','1','100.00','550000','0','0','15000','557000','0','5000','0','562000','NS','T0077875','A1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZCXG-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='A1E-ZCXG-4-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 ('F226170958301','2026-03-17','0.460','2026-03-17','09:58:30','PLG0078261','557000','557000','5000','562000','562000','kasir','2026-03-17 09:58:30','F22617095830');
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-03-17','F226170958301','2026-03-17','09:58:30','NS','562000','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-260317-0020','D','2026-03-17','09:58:30','kasir','PENJUALAN','F226170958301','7288840000','562000','7289402000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='562000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170958301' 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 ('F226170958302','kasir',' 1',' MDB1 UB PE','TOKO','SMBK-B','B1D-ZCAC-8-T','GW TUSUK MODEL HATI VAR UB PE 8K ','OL','0.960','1','100.00','1128000','0','0','15000','1143000','0','5000','0','1148000','NS','T0078121','B1D','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZCAC-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='B1D-ZCAC-8-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226170958302','2026-03-17','0.960','2026-03-17','09:58:30','PLG0078262','1143000','1143000','5000','1148000','1148000','kasir','2026-03-17 09:58:30','F22617095830');
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-03-17','F226170958302','2026-03-17','09:58:30','NS','1148000','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-260317-0021','D','2026-03-17','09:58:30','kasir','PENJUALAN','F226170958302','7289402000','1148000','7290550000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1148000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170958302' 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 ('F226171010231','kasir','1',' MEF2 X PM ','TOKO','SMBK-F','F2E-YKXH-74-0','GL X PIPA MATA PM 58 8K ','','7.080','1','100.00','8461000','0','0','15000','8461000','0','0','0','8461000','RHM','00376857','F2E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YKXH-74-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'7.080',berat_jual_asli=berat_jual_asli+'7.080',stock_jual='1',berat_akhir=berat_akhir-'7.080',berat_akhir_asli=berat_akhir_asli-'7.080',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='F2E-YKXH-74-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 ('F226171010231','2026-03-17','7.080','2026-03-17','10:10:23','PLG0078263','8461000','8461000','0','8461000','8461000','kasir','2026-03-17 10:10:23','F22617101023');
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-03-17','F226171010231','2026-03-17','10:10:23','RHM','8461000','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-260317-0022','D','2026-03-17','10:10:23','kasir','PENJUALAN','F226171010231','7290550000','8461000','7299011000');
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 ('F226171027091','kasir','1',' MEE1 X LG ','TOKO','SMBK-E','E1E-ZBBE-98-0','CC X MODEL DAUN SLEP LG 18 8K ','','0.490','1','100.00','586000','0','0','15000','586000','0','0','0','586000','TIN','00391244','E1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZBBE-98-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.490',berat_jual_asli=berat_jual_asli+'0.490',stock_jual='1',berat_akhir=berat_akhir-'0.490',berat_akhir_asli=berat_akhir_asli-'0.490',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='E1E-ZBBE-98-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 ('F226171027091','2026-03-17','0.490','2026-03-17','10:27:10','PLG0078264','586000','586000','0','586000','586000','kasir','2026-03-17 10:27:09','F22617102709');
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-03-17','F226171027091','2026-03-17','10:27:10','TIN','586000','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-260317-0023','D','2026-03-17','10:27:10','kasir','PENJUALAN','F226171027091','7299011000','586000','7299597000');
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 ('F226171029291','kasir','1',' MEE1 CM 16','TOKO','SMBK-E','E1E-ZCXE-25-T','CC PIPA KUKU MACAN SLEP CM 16 8K ','','0.600','1','100.00','717000','0','0','15000','717000','0','0','0','717000','RHM','T0077701','E1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCXE-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='E1E-ZCXE-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 ('F226171029291','2026-03-17','0.600','2026-03-17','10:29:30','PLG0078265','717000','717000','0','717000','717000','kasir','2026-03-17 10:29:29','F22617102929');
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-03-17','F226171029291','2026-03-17','10:29:30','RHM','717000','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-260317-0024','D','2026-03-17','10:29:30','kasir','PENJUALAN','F226171029291','7299597000','717000','7300314000');
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 ('F226171124451','kasir','1',' MFE1 5K BG','TOKO','SMBK-E','E1F-YJBA-29-T','CC MODEL SLEP PASIR BG 13 8K ','','0.410','1','100.00','498000','0','0','15000','498000','0','5000','0','503000','RHM','T0074350','E1F','0','0','-','0','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-YJBA-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='E1F-YJBA-29-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 ('F226171124451','2026-03-17','0.410','2026-03-17','11:24:46','PLG0078266','498000','498000','5000','503000','503000','kasir','2026-03-17 11:24:45','F22617112445');
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-03-17','F226171124451','2026-03-17','11:24:46','RHM','503000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260317-0025','D','2026-03-17','11:24:46','kasir','PENJUALAN','F226171124451','7300314000','503000','7300817000');
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 ('F226171131181','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZACX-96-T','LT SLOBOK MODEL HATI PASIR BG 8K ','','0.550','1','100.00','668000','0','0','15000','668000','0','5000','0','673000','RHM','T0077010','D1F','0','0','-','0','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZACX-96-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='D1F-ZACX-96-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226171131181','2026-03-17','0.550','2026-03-17','11:31:18','PLG0078267','668000','668000','5000','673000','673000','kasir','2026-03-17 11:31:18','F22617113118');
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-03-17','F226171131181','2026-03-17','11:31:18','RHM','673000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260317-0026','D','2026-03-17','11:31:18','kasir','PENJUALAN','F226171131181','7300817000','673000','7301490000');
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 ('F226171152041','kasir','1',' MEF1 UB D6','TOKO','SMBK-F','F1E-ZCAA-51-T','GL OVAL MODEL C UB D65 8K ','','2.540','1','100.00','3035000','0','0','15000','3035000','0','0','0','3035000','TIN','T0078050','F1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCAA-51-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.540',berat_jual_asli=berat_jual_asli+'2.540',stock_jual='1',berat_akhir=berat_akhir-'2.540',berat_akhir_asli=berat_akhir_asli-'2.540',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='F1E-ZCAA-51-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 ('F226171152041','2026-03-17','2.540','2026-03-17','11:52:04','PLG0078268','3035000','3035000','0','3035000','0','kasir','2026-03-17 11:52:04','F22617115204');
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-03-17','F226171152041','2026-03-17','11:52:04','TIN','3035000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260317-0001','2026-03-17','2026-03-17 11:52:04','PENJUALAN : F226171152041','123456734567','BCA','3035000','3035000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260317-0002','D','2026-03-17','11:52:04','BCA','PENJUALAN','F226171152041','4307441888','3035000','4310476888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('123456734567','WIDIA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3035000' WHERE no_faktur_jual='F226171152041' 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 ('F226171209041','kasir','1',' MGE1 LG 12','TOKO','SMBK-E','E1G-ZCXF-41-T','CC MODEL HATI VAR LG 12 8K ','OL','0.310','1','100.00','383000','0','0','15000','388000','0','5000','0','393000','TIN','T0077863','E1G','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZCXF-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='E1G-ZCXF-41-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 ('F226171209041','2026-03-17','0.310','2026-03-17','12:09:04','PLG0078269','388000','388000','5000','393000','393000','kasir','2026-03-17 12:09:04','F22617120904');
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-03-17','F226171209041','2026-03-17','12:09:04','TIN','393000','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-260317-0027','D','2026-03-17','12:09:04','kasir','PENJUALAN','F226171209041','7301490000','393000','7301883000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='393000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226171209041' 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 ('F226171209042','kasir',' 1',' MGE1 LG 14','TOKO','SMBK-E','E1G-ZCXF-42-T','CC MODEL HATI VAR LG 14 8K ','OL','0.310','1','100.00','383000','0','0','15000','388000','0','5000','0','393000','TIN','T0077864','E1G','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZCXF-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='E1G-ZCXF-42-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 ('F226171209042','2026-03-17','0.310','2026-03-17','12:09:04','PLG0078270','388000','388000','5000','393000','393000','kasir','2026-03-17 12:09:04','F22617120904');
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-03-17','F226171209042','2026-03-17','12:09:04','TIN','393000','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-260317-0028','D','2026-03-17','12:09:04','kasir','PENJUALAN','F226171209042','7301883000','393000','7302276000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='393000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226171209042' 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 ('F226171209043','kasir',' 1',' MIF4I X KH','TOKO','SMBK-F','F4I-ZCAD-126-0','GL X KAKI JEDAR KH 9K ','OL','0.900','1','100.00','1147000','0','0','15000','1161000','0','5000','0','1166000','TIN','00394254','F4I','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4I-ZCAD-126-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='F4I-ZCAD-126-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 ('F226171209043','2026-03-17','0.900','2026-03-17','12:09:04','PLG0078271','1161000','1161000','5000','1166000','1166000','kasir','2026-03-17 12:09:04','F22617120904');
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-03-17','F226171209043','2026-03-17','12:09:04','TIN','1166000','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-260317-0029','D','2026-03-17','12:09:04','kasir','PENJUALAN','F226171209043','7302276000','1166000','7303442000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1166000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226171209043' 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 ('F226171226511','kasir','1',' MJH3 X UB ','TOKO','SMBK-H','H3J-YLXF-305-0','KL X SANTA MATA VAR UB 42 9K ','','3.100','1','100.00','4014000','0','0','15000','4015000','0','15000','0','4030000','NS','00380121','H3J','0','0','-','0','1295000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H3J-YLXF-305-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.100',berat_jual_asli=berat_jual_asli+'3.100',stock_jual='1',berat_akhir=berat_akhir-'3.100',berat_akhir_asli=berat_akhir_asli-'3.100',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='H3J-YLXF-305-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226171226511','2026-03-17','3.100','2026-03-17','12:26:52','PLG0078272','4015000','4015000','15000','4030000','4030000','kasir','2026-03-17 12:26:51','F22617122651');
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-03-17','F226171226511','2026-03-17','12:26:52','NS','4030000','15000');
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-260317-0030','D','2026-03-17','12:26:52','kasir','PENJUALAN','F226171226511','7303442000','4030000','7307472000');
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 ('F226171257101','kasir','1',' MJH3 X UB ','TOKO','SMBK-H','H3J-YEXA-62-T','KL X SANTA MODEL BUNGA KRAWANG VAR UB 9K','OL','4.740','1','100.00','6138000','0','0','15000','6162000','0','24000','0','6186000','RTA','T0069115','H3J','0','0','-','0','1295000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H3J-YEXA-62-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.740',berat_jual_asli=berat_jual_asli+'4.740',stock_jual='1',berat_akhir=berat_akhir-'4.740',berat_akhir_asli=berat_akhir_asli-'4.740',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='H3J-YEXA-62-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 ('F226171257101','2026-03-17','4.740','2026-03-17','12:57:10','PLG0078273','6162000','6162000','24000','6186000','6186000','kasir','2026-03-17 12:57:10','F22617125710');
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-03-17','F226171257101','2026-03-17','12:57:10','RTA','6186000','24000');
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-260317-0031','D','2026-03-17','12:57:10','kasir','PENJUALAN','F226171257101','7307472000','6186000','7313658000');
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 ('F226170123411','kasir','1',' MEF3 10K Y','TOKO','SMBK-F','F3E-YLBC-10-T','GL TRIXIE BUNGA CLOVER VAR YT 8K ','','1.110','1','100.00','1326000','0','0','15000','1326000','0','10000','0','1336000','NS','T0076072','F3E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLBC-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.110',berat_jual_asli=berat_jual_asli+'1.110',stock_jual='1',berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='F3E-YLBC-10-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 ('F226170123411','2026-03-17','1.110','2026-03-17','13:23:42','PLG0078274','1326000','1326000','10000','1336000','1336000','kasir','2026-03-17 13:23:41','F22617012341');
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-03-17','F226170123411','2026-03-17','13:23:42','NS','1336000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260317-0032','D','2026-03-17','13:23:42','kasir','PENJUALAN','F226170123411','7313658000','1336000','7314994000');
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 ('F226170141351','kasir','1',' MEH1 HW ','TOKO','SMBK-H','H1E-ZBAF-1-T','KL SANTA MODEL HATI POLOS HW 8K ','OL','1.990','1','100.00','2378000','0','0','15000','2388000','0','10000','0','2398000','NS','T0077380','H1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBAF-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.990',berat_jual_asli=berat_jual_asli+'1.990',stock_jual='1',berat_akhir=berat_akhir-'1.990',berat_akhir_asli=berat_akhir_asli-'1.990',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='H1E-ZBAF-1-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 ('F226170141351','2026-03-17','1.990','2026-03-17','13:41:36','PLG0078275','2388000','2388000','10000','2398000','2398000','kasir','2026-03-17 13:41:35','F22617014135');
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-03-17','F226170141351','2026-03-17','13:41:36','NS','2398000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260317-0033','D','2026-03-17','13:41:36','kasir','PENJUALAN','F226170141351','7314994000','2398000','7317392000');
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 ('F226170205391','kasir','1',' MEH1 UB 40','TOKO','SMBK-H','H1E-ZBAG-13-T','KL MILANO UB 40CM 8K ','','3.000','1','100.00','3585000','0','0','15000','3530000','0','0','0','3530000','RTA','T0077455','H1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBAG-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='H1E-ZBAG-13-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 ('F226170205391','2026-03-17','3.000','2026-03-17','14:05:40','PLG0078276','3530000','3530000','0','3530000','3530000','kasir','2026-03-17 14:05:39','F22617020539');
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-03-17','F226170205391','2026-03-17','14:05:40','RTA','3530000','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-260317-0034','D','2026-03-17','14:05:40','kasir','PENJUALAN','F226170205391','7317392000','3530000','7320922000');
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 ('F226170251321','kasir','1',' TDA1 X LG ','TOKO','TBK-A','A1TD-YLAA-10-T','AT X COR MODEL BK SLEP LG 17K','','1.080','1','100.00','2311000','0','0','15000','2311000','0','0','0','2311000','NS','T0075668','A1TD','0','0','-','0','2140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TD-YLAA-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='A1TD-YLAA-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 ('F226170251321','2026-03-17','1.080','2026-03-17','14:51:32','PLG0078277','2311000','2311000','0','2311000','2311000','kasir','2026-03-17 14:51:32','F22617025132');
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-03-17','F226170251321','2026-03-17','14:51:32','NS','2311000','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-260317-0035','D','2026-03-17','14:51:32','kasir','PENJUALAN','F226170251321','7320922000','2311000','7323233000');
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 ('F226170252151','kasir','1',' MEE1 CM 16','TOKO','SMBK-E','E1E-ZACX-82-T','CC MODEL DAUN VAR CM 16 8K ','','0.750','1','100.00','896000','0','0','15000','896000','0','0','0','896000','NS','T0076996','E1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZACX-82-T' 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-03-17' AND kode_barang='E1E-ZACX-82-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 ('F226170252151','2026-03-17','0.750','2026-03-17','14:52:15','PLG0078278','896000','896000','0','896000','896000','kasir','2026-03-17 14:52:15','F22617025215');
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-03-17','F226170252151','2026-03-17','14:52:15','NS','896000','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-260317-0036','D','2026-03-17','14:52:15','kasir','PENJUALAN','F226170252151','7323233000','896000','7324129000');
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 ('F226170303151','kasir','1',' MIF4I X UB','TOKO','SMBK-F','F4I-ZABD-28-0','GL X RANTAI HOLLOW UB 9K ','','5.080','1','100.00','6477000','0','0','15000','6477000','0','0','0','6477000','TIN','00386844','F4I','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4I-ZABD-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.080',berat_jual_asli=berat_jual_asli+'5.080',stock_jual='1',berat_akhir=berat_akhir-'5.080',berat_akhir_asli=berat_akhir_asli-'5.080',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='F4I-ZABD-28-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 ('F226170303151','2026-03-17','5.080','2026-03-17','15:03:15','PLG0078279','6477000','6477000','0','6477000','6477000','kasir','2026-03-17 15:03:15','F22617030315');
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-03-17','F226170303151','2026-03-17','15:03:15','TIN','6477000','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-260317-0037','D','2026-03-17','15:03:15','kasir','PENJUALAN','F226170303151','7324129000','6477000','7330606000');
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 ('F226170411251','kasir','1',' MEF1 10K P','TOKO','SMBK-F','F1E-ZCAB-15-T','GL ANAK BANGKOK HOLLOW LASER PM D42 8K ','','1.930','1','100.00','2306000','0','0','15000','2306000','0','10000','0','2316000','NS','T0078086','F1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCAB-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='F1E-ZCAB-15-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 ('F226170411251','2026-03-17','1.930','2026-03-17','16:11:25','PLG0078280','2306000','2306000','10000','2316000','2316000','kasir','2026-03-17 16:11:25','F22617041125');
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-03-17','F226170411251','2026-03-17','16:11:25','NS','2316000','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-260317-0038','D','2026-03-17','16:11:25','kasir','PENJUALAN','F226170411251','7330606000','2316000','7332922000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2316000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170411251' 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 ('F226170411252','kasir',' 1',' MEA1 UB ','TOKO','SMBK-A','A1E-ZBAF-37-T','AT JERSY SLEP UB 8K ','','0.400','1','100.00','478000','0','0','15000','478000','0','0','0','478000','NS','T0077416','A1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZBAF-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='A1E-ZBAF-37-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 ('F226170411252','2026-03-17','0.400','2026-03-17','16:11:25','PLG0078281','478000','478000','0','478000','478000','kasir','2026-03-17 16:11:25','F22617041125');
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-03-17','F226170411252','2026-03-17','16:11:25','NS','478000','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-260317-0039','D','2026-03-17','16:11:25','kasir','PENJUALAN','F226170411252','7332922000','478000','7333400000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='478000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170411252' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005195','X-00005195','AT ANAK MODEL BONEKA CAT MATA VAR LG 8K','GR','---','A1E','BELI','BELI001','535000','2026-03-17','0.560','1','kasir','2026-03-17 16:20:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00005195','X-00005195');
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-260317-0001','F225170206522','NS','1','BELI','BELI001','A1E', 'X-00005195', 'AT ANAK MODEL BONEKA CAT MATA VAR LG 8K','0.560','0.560','100.00','596000','535000','955357','1195000','1','535000','535000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.560',berat_beli_asli=berat_beli_asli+'0.560',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.560',berat_akhir_asli=berat_akhir_asli+'0.560',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260317-0001','2026-03-17','2026-03-17','16:20:34','NS','---','0.560','535000','535000','535000','535000','535000','kasir','2026-03-17 16:20:34','FB-260317-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260317-0001','AFRA','DAGANGAN MADIUN','','','','kasir','2026-03-17 16:20:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-17' 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-260317-0040','K','2026-03-17','16:20:34','kasir','PEMBELIAN UMUM','FB-260317-0001','7333400000','535000','7332865000');
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-00005196','X-00005196','GW X MODEL MATA CM PE 8K','GR','---','B1D','BELI','BELI001','770000','2026-03-17','0.940','1','kasir','2026-03-17 16:21:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1D','X-00005196','X-00005196');
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-260317-0002','F224180211271','NS','1','BELI','BELI001','B1D', 'X-00005196', 'GW X MODEL MATA CM PE 8K','1.140','0.940','100.00','723000','770000','819149','1175000','1','770000','770000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.940',berat_beli_asli=berat_beli_asli+'0.940',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.940',berat_akhir_asli=berat_akhir_asli+'0.940',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1D' 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-260317-0002','2026-03-17','2026-03-17','16:21:34','NS','---','0.940','770000','770000','770000','770000','770000','kasir','2026-03-17 16:21:35','FB-260317-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260317-0002','MOHAMMAD SYAHRONI','SAMBIT 03/01','','','085838680189','kasir','2026-03-17 16:21:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-17' 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-260317-0041','K','2026-03-17','16:21:34','kasir','PEMBELIAN UMUM','FB-260317-0002','7332865000','770000','7332095000');
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-00005197','X-00005197','KL SANTA KH 42 8K','GR','---','H1E','BELI','BELI001','1430000','2026-03-17','1.500','1','kasir','2026-03-17 16:21:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00005197','X-00005197');
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-260317-0003','F225150802371','NS','2','BELI','BELI001','H1E', 'X-00005197', 'KL SANTA KH 42 8K','1.500','1.500','100.00','1590000','1430000','953333','1195000','1','1430000','1430000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.500',berat_beli_asli=berat_beli_asli+'1.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.500',berat_akhir_asli=berat_akhir_asli+'1.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260317-0003','2026-03-17','2026-03-17','16:21:34','NS','---','1.500','1430000','1430000','1430000','1430000','1430000','kasir','2026-03-17 16:21:35','FB-260317-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260317-0003','RIMA','KARANGTALOK BBDN','','','085730493170','kasir','2026-03-17 16:21:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-17' 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-260317-0042','K','2026-03-17','16:21:34','kasir','PEMBELIAN UMUM','FB-260317-0003','7332095000','1430000','7330665000');
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-00005198','X-00005198','CC X MODEL MATA CM 14 8K','GR','---','E2D','BELI','BELI001','972000','2026-03-17','1.220','1','kasir','2026-03-17 16:21:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00005198','X-00005198');
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-260317-0004','F225210300332','NS','3','BELI','BELI001','E2D', 'X-00005198', 'CC X MODEL MATA CM 14 8K','1.220','1.220','100.00','1057000','972000','796721','1175000','1','972000','972000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.220',berat_beli_asli=berat_beli_asli+'1.220',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.220',berat_akhir_asli=berat_akhir_asli+'1.220',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260317-0004','2026-03-17','2026-03-17','16:21:34','NS','---','1.220','972000','972000','972000','972000','972000','kasir','2026-03-17 16:21:35','FB-260317-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260317-0004','VIVI NUR AINI','GLONGGONG DOLOPO','','','085646386061','kasir','2026-03-17 16:21:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-17' 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-260317-0043','K','2026-03-17','16:21:34','kasir','PEMBELIAN UMUM','FB-260317-0004','7330665000','972000','7329693000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170123411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170123411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170123411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170141351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170141351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170141351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170205391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170205391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170205391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170251321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170251321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170251321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170252151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170252151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170252151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170303151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170303151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170303151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170411251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170411251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170411251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170411252' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170411252' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170411252';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170812331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170812331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170812331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170840361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170840361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170840361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170840362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170840362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170840362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170840363' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170840363' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170840363';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170840364' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170840364' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170840364';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170840365' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170840365' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170840365';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170840366' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170840366' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170840366';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170840367' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170840367' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170840367';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170840368' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170840368' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170840368';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170840369' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170840369' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170840369';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170842481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170842481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170842481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170842482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170842482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170842482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170842483' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170842483' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170842483';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170842484' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170842484' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170842484';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170842485' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170842485' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170842485';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170958301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170958301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170958301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170958302' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170958302' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170958302';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226171010231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226171010231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226171010231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226171027091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226171027091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226171027091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226171029291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226171029291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226171029291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226171124451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226171124451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226171124451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226171131181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226171131181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226171131181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226171152041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226171152041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226171152041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226171209041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226171209041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226171209041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226171209042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226171209042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226171209042';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226171209043' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226171209043' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226171209043';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226171226511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226171226511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226171226511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226171257101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226171257101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226171257101';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260317-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260317-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260317-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260317-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260317-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260317-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260317-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260317-0004';
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 ('F226170448351','kasir','1',' MEE1 LG 12','TOKO','SMBK-E','E1E-ZCXG-45-T','CC MODEL DAUN SLEP VAR LG 12 8K ','','0.460','1','100.00','550000','0','0','15000','550000','0','0','0','550000','RTA','T0077916','E1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCXG-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='E1E-ZCXG-45-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 ('F226170448351','2026-03-17','0.460','2026-03-17','16:48:35','PLG0078282','550000','550000','0','550000','550000','kasir','2026-03-17 16:48:35','F22617044835');
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-03-17','F226170448351','2026-03-17','16:48:35','RTA','550000','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-260317-0044','D','2026-03-17','16:48:35','kasir','PENJUALAN','F226170448351','7329693000','550000','7330243000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='550000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170448351' 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 ('F226170448352','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZCXE-75-T','GL SANTA SERUT MODEL VAR HW 8K ','','1.850','1','100.00','2211000','0','0','15000','2211000','0','0','0','2211000','RTA','T0077751','F3E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCXE-75-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='F3E-ZCXE-75-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 ('F226170448352','2026-03-17','1.850','2026-03-17','16:48:35','PLG0078283','2211000','2211000','0','2211000','2211000','kasir','2026-03-17 16:48:35','F22617044835');
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-03-17','F226170448352','2026-03-17','16:48:35','RTA','2211000','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-260317-0045','D','2026-03-17','16:48:35','kasir','PENJUALAN','F226170448352','7330243000','2211000','7332454000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2211000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226170448352' 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 ('F226170455511','kasir','1',' MDE1 X YT ','TOKO','SMBK-E','E1D-ZABH-258-0','CC X MODEL CAT HITAM YT 12 8K ','','1.170','1','100.00','1375000','0','0','15000','1375000','0','5000','0','1380000','NS','00387116','E1D','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZABH-258-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.170',berat_jual_asli=berat_jual_asli+'1.170',stock_jual='1',berat_akhir=berat_akhir-'1.170',berat_akhir_asli=berat_akhir_asli-'1.170',stock_akhir='0' WHERE tanggal='2026-03-17' AND kode_barang='E1D-ZABH-258-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 ('F226170455511','2026-03-17','1.170','2026-03-17','16:55:52','PLG0078284','1375000','1375000','5000','1380000','1380000','kasir','2026-03-17 16:55:51','F22617045551');
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-03-17','F226170455511','2026-03-17','16:55:52','NS','1380000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260317-0046','D','2026-03-17','16:55:52','kasir','PENJUALAN','F226170455511','7332454000','1380000','7333834000');
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-260317-0004','1','A1TD-YLBF-1-T','1','1.950','1.950','TOKO','TBK-A','TOKO','PTBK-A');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PTBK-A' WHERE kode_barang='A1TD-YLBF-1-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-A';
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-03-17','TOKO','PTBK-A','A1TD','A1TD-YLBF-1-T','100.00','1','1.950','1.950','1','1.950','1.950');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.950',berat_out_asli=berat_out_asli+'1.950',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='A1TD-YLBF-1-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-A' 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-260317-0004','2','A1TF-XDCX-10-T','1','1.450','1.450','TOKO','TBK-A','TOKO','PTBK-A');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PTBK-A' WHERE kode_barang='A1TF-XDCX-10-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-A';
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-03-17','TOKO','PTBK-A','A1TF','A1TF-XDCX-10-T','100.00','1','1.450','1.450','1','1.450','1.450');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.450',berat_out_asli=berat_out_asli+'1.450',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='A1TF-XDCX-10-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-A' 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-260317-0004','3','A1TD-YFBF-44-T','1','1.500','1.500','TOKO','TBK-A','TOKO','PTBK-A');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PTBK-A' WHERE kode_barang='A1TD-YFBF-44-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-A';
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-03-17','TOKO','PTBK-A','A1TD','A1TD-YFBF-44-T','100.00','1','1.500','1.500','1','1.500','1.500');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.500',berat_out_asli=berat_out_asli+'1.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='A1TD-YFBF-44-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-A' 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-260317-0004','2026-03-17','2026-03-17','17:03','4.9','admin','2026-03-17 17:04:22');
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-260317-0005','1','E0TA-VJAX-9-T','1','2.950','2.950','TOKO','TBK-E','TOKO','PTBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PTBK-E' WHERE kode_barang='E0TA-VJAX-9-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-E';
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-03-17','TOKO','PTBK-E','E0TA','E0TA-VJAX-9-T','100.00','1','2.950','2.950','1','2.950','2.950');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.950',berat_out_asli=berat_out_asli+'2.950',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='E0TA-VJAX-9-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-E' 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-260317-0005','2026-03-17','2026-03-17','17:04','2.95','admin','2026-03-17 17:05:05');
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-260317-0006','1','F3TE-YJBH-6-T','1','3.030','3.030','TOKO','TBK-F','TOKO','PTBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PTBK-F' WHERE kode_barang='F3TE-YJBH-6-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-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-03-17','TOKO','PTBK-F','F3TE','F3TE-YJBH-6-T','100.00','1','3.030','3.030','1','3.030','3.030');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.030',berat_out_asli=berat_out_asli+'3.030',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3TE-YJBH-6-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-F' 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-260317-0006','2','F3TG-XLAI-105-T','1','2.730','2.730','TOKO','TBK-F','TOKO','PTBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PTBK-F' WHERE kode_barang='F3TG-XLAI-105-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-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-03-17','TOKO','PTBK-F','F3TG','F3TG-XLAI-105-T','100.00','1','2.730','2.730','1','2.730','2.730');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.730',berat_out_asli=berat_out_asli+'2.730',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F3TG-XLAI-105-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-F' 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-260317-0006','3','F1TE-XBBI-74-T','1','2.160','2.160','TOKO','TBK-F','TOKO','PTBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PTBK-F' WHERE kode_barang='F1TE-XBBI-74-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-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-03-17','TOKO','PTBK-F','F1TE','F1TE-XBBI-74-T','100.00','1','2.160','2.160','1','2.160','2.160');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.160',berat_out_asli=berat_out_asli+'2.160',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-17' AND kode_barang='F1TE-XBBI-74-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-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-260317-0006','2026-03-17','2026-03-17','17:05','7.92','admin','2026-03-17 17:05:28');
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-00005199','X-00005199','CC WEDDING MATA CM 14 8K','GR','---','E2D','BELI','BELI001','1508000','2026-03-17','1.910','1','kasir','2026-03-17 17:08:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00005199','X-00005199');
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-260317-0005','F225121157052','NS','1','BELI','BELI001','E2D', 'X-00005199', 'CC WEDDING MATA CM 14 8K','2.020','1.910','100.00','1638000','1508000','789529','1175000','1','1508000','1508000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.910',berat_beli_asli=berat_beli_asli+'1.910',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.910',berat_akhir_asli=berat_akhir_asli+'1.910',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260317-0005','2026-03-17','2026-03-17','17:08:36','NS','---','1.910','1508000','1508000','1508000','1508000','1508000','kasir','2026-03-17 17:08:37','FB-260317-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260317-0005','AYUNDA','KLEDUNG 2/3 NGREJO BANJAR PACITAN','','','082230061879','kasir','2026-03-17 17:08:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-17' 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-260317-0047','K','2026-03-17','17:08:36','kasir','PEMBELIAN UMUM','FB-260317-0005','7333834000','1508000','7332326000');
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-00005200','X-00005200','CC WEDDING MATA CM 12 8K','GR','---','E2D','BELI','BELI001','1477000','2026-03-17','1.870','1','kasir','2026-03-17 17:08:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00005200','X-00005200');
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-260317-0006','F225121157051','NS','2','BELI','BELI001','E2D', 'X-00005200', 'CC WEDDING MATA CM 12 8K','1.980','1.870','100.00','1606000','1477000','789840','1175000','1','1477000','1477000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.870',berat_beli_asli=berat_beli_asli+'1.870',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.870',berat_akhir_asli=berat_akhir_asli+'1.870',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260317-0006','2026-03-17','2026-03-17','17:08:36','NS','---','1.870','1477000','1477000','1477000','1477000','1477000','kasir','2026-03-17 17:08:37','FB-260317-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260317-0006','AYUNDA','KLEDUNG 2/3 NGREJO BANJAR PACITAN','','','082230061879','kasir','2026-03-17 17:08:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-17' 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-260317-0048','K','2026-03-17','17:08:36','kasir','PEMBELIAN UMUM','FB-260317-0006','7332326000','1477000','7330849000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170448351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170448351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170448351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170448352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170448352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170448352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226170455511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226170455511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226170455511';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260317-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260317-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260317-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260317-0006';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-18','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-15';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-17';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-17';
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-03-17' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-17';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-17';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-17';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-17';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-18' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-17' 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-260318-0001','D','2026-03-18','17:29:16','SYSTEM','SALDO AWAL','SALDO AWAL','0','7330849000','7330849000');
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-260318-0001','D','2026-03-18','17:29:16','BCA','SALDO AWAL','SALDO AWAL','0','4310476888','4310476888');
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-260318-0001','D','2026-03-18','17:29:16','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-260318-0001','D','2026-03-18','17:29:16','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-260318-0001','D','2026-03-18','17:29:16','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-260318-0001','D','2026-03-18','17:29:16','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2026-03-18';