INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250927-0001','1','S1G-YIBD-46-T','1','0.380','TOKO','PMBK-S');
DELETE FROM tm_barang_export WHERE kode_barang='S1G-YIBD-46-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='S1G-YIBD-46-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='MG' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='MG' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='S1G' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='S1G' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PMBK-S';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PMBK-S';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='S1G-YIBD-46-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.380',berat_out_asli='0.380', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.380',berat_akhir_asli =berat_akhir_asli-'0.380' WHERE kode_barang='S1G-YIBD-46-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-250927-0001','2025-09-27','2025-09-27','07:16','0.380','input','250927');
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-20250927-0001','1','B1D-YFAI-123-0','1','1.220','1.220','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1D-YFAI-123-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1D-YFAI-123-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-09-27 07:17:16' WHERE kode_barang='B1D-YFAI-123-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1D-YFAI-123-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 ('2025-09-27 07:17:16','TOKO','SMBK-B','B1D','B1D-YFAI-123-0','1','1.220','1.220','1','1.220','1.220','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1D-YFAI-123-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1D-YFAI-123-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250927-0001','2025-09-27','07:17','1.220','input','2025-09-27 07:17:15');
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 ('F225270958251','kasir','1',' MDA1D X LG','TOKO','SMBK-A','A1D-YBBA-106-0','AT X MODEL MATA VAR LG 8K ','OL','1.070','1','100.00','974000','0','0','15000','1022000','0','5000','0','1027000','TJ','00340208','A1D','0','0','-','0','930000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YBBA-106-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='A1D-YBBA-106-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225270958251','2025-09-27','1.070','2025-09-27','09:58:25','PLG0072959','1022000','1022000','5000','1027000','1027000','kasir','2025-09-27 09:58:25','F22527095825');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-27','F225270958251','2025-09-27','09:58:25','TJ','1027000','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-250927-0002','D','2025-09-27','09:58:25','kasir','PENJUALAN','F225270958251','643239000','1027000','644266000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1027000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225270958251' 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 ('F225270958252','kasir',' 1',' MEF3E X YT','TOKO','SMBK-F','F3E-YIAE-261-0','GL X TIFF SPECTRA HITAM VAR YT 8K ','OL','1.150','1','100.00','1066000','0','0','15000','1095000','0','10000','0','1105000','TJ','00369712','F3E','0','0','-','0','948000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIAE-261-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='F3E-YIAE-261-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 ('F225270958252','2025-09-27','1.150','2025-09-27','09:58:25','PLG0072960','1095000','1095000','10000','1105000','1105000','kasir','2025-09-27 09:58:25','F22527095825');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-27','F225270958252','2025-09-27','09:58:25','TJ','1105000','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-250927-0003','D','2025-09-27','09:58:25','kasir','PENJUALAN','F225270958252','644266000','1105000','645371000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1105000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225270958252' 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 ('F225271000221','kasir','1',' MEF1 10K Y','TOKO','SMBK-F','F1E-YGXE-19-T','GL ANAK OSROT BONEKA CAT VAR YT 8K ','OL','1.090','1','100.00','1010000','0','0','15000','1037000','0','10000','0','1047000','NS','T0070799','F1E','0','0','-','0','948000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YGXE-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.090',berat_jual_asli=berat_jual_asli+'1.090',stock_jual='1',berat_akhir=berat_akhir-'1.090',berat_akhir_asli=berat_akhir_asli-'1.090',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='F1E-YGXE-19-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 ('F225271000221','2025-09-27','1.090','2025-09-27','10:00:22','PLG0072961','1037000','1037000','10000','1047000','1047000','kasir','2025-09-27 10:00:22','F22527100022');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-27','F225271000221','2025-09-27','10:00:22','NS','1047000','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-250927-0004','D','2025-09-27','10:00:22','kasir','PENJUALAN','F225271000221','645371000','1047000','646418000');
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 ('F225271004511','kasir','1',' MFB1 CM ','TOKO','SMBK-B','B1F-YIBB-3-T','GW ITALY PANJANG HATI MATA VAR CM 8K ','OL','0.980','1','100.00','925000','0','0','15000','955000','0','5000','0','960000','RTA','T0073139','B1F','0','0','-','0','968000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YIBB-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='B1F-YIBB-3-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 ('F225271004511','2025-09-27','0.980','2025-09-27','10:04:51','PLG0072962','955000','955000','5000','960000','960000','kasir','2025-09-27 10:04:51','F22527100451');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-27','F225271004511','2025-09-27','10:04:51','RTA','960000','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-250927-0005','D','2025-09-27','10:04:51','kasir','PENJUALAN','F225271004511','646418000','960000','647378000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='960000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225271004511' 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 ('F225271004512','kasir',' 1',' MFH1 UB 46','TOKO','SMBK-H','H1F-YIBD-40-T','KL KOREA UB 46CM 8K ','OL','0.970','1','100.00','936000','0','0','15000','951000','0','5000','0','956000','RTA','T0073302','H1F','0','0','-','0','968000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YIBD-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='H1F-YIBD-40-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 ('F225271004512','2025-09-27','0.970','2025-09-27','10:04:51','PLG0072963','951000','951000','5000','956000','956000','kasir','2025-09-27 10:04:51','F22527100451');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-27','F225271004512','2025-09-27','10:04:51','RTA','956000','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-250927-0006','D','2025-09-27','10:04:51','kasir','PENJUALAN','F225271004512','647378000','956000','648334000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='956000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225271004512' 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 ('F225271004513','kasir',' 1',' MDE1 LG 18','TOKO','SMBK-E','E1D-YIBD-8-T','CC MODEL DAUN VAR LG 18 8K ','OL','1.130','1','100.00','1045000','0','0','15000','1079000','0','6000','0','1085000','RTA','T0073270','E1D','0','0','-','0','930000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YIBD-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='E1D-YIBD-8-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 ('F225271004513','2025-09-27','1.130','2025-09-27','10:04:51','PLG0072964','1079000','1079000','6000','1085000','1085000','kasir','2025-09-27 10:04:51','F22527100451');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-27','F225271004513','2025-09-27','10:04:51','RTA','1085000','6000');
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-250927-0007','D','2025-09-27','10:04:51','kasir','PENJUALAN','F225271004513','648334000','1085000','649419000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1085000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225271004513' 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 ('F225271108051','kasir','1',' MDA1D X CM','TOKO','SMBK-B','B1D-YFAI-123-0','GW X PANJANG MATA CM 8K','OL','1.220','1','100.00','1135000','0','0','15000','1171000','0','6000','0','1177000','TJ','00357994','B1D','0','0','-','0','930000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-YFAI-123-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.220',berat_jual_asli=berat_jual_asli+'1.220',stock_jual='1',berat_akhir=berat_akhir-'1.220',berat_akhir_asli=berat_akhir_asli-'1.220',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='B1D-YFAI-123-0' 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 ('F225271108051','2025-09-27','1.220','2025-09-27','11:08:05','PLG0072965','1171000','1171000','6000','1177000','1177000','kasir','2025-09-27 11:08:05','F22527110805');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-27','F225271108051','2025-09-27','11:08:05','TJ','1177000','6000');
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-250927-0008','D','2025-09-27','11:08:05','kasir','PENJUALAN','F225271108051','649419000','1177000','650596000');
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 ('F225271122571','kasir','1',' MGF3 UB ','TOKO','SMBK-F','F3G-YHAB-44-T','GL RANTAI HOLLOW UB 8K ','OL','0.380','1','100.00','365000','0','0','15000','380000','0','5000','0','385000','TJ','T0072251','F3G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3G-YHAB-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='F3G-YHAB-44-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 ('F225271122571','2025-09-27','0.380','2025-09-27','11:22:57','PLG0072966','380000','380000','5000','385000','385000','kasir','2025-09-27 11:22:57','F22527112257');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-27','F225271122571','2025-09-27','11:22:57','TJ','385000','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-250927-0009','D','2025-09-27','11:22:57','kasir','PENJUALAN','F225271122571','650596000','385000','650981000');
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 ('F225271222581','kasir','1',' TDD2 LG A ','TOKO','TBK-D','D2TD-YHBG-5-T','LT MODEL HURUF MATA LG A 17K ','','1.050','1','100.00','1704000','0','0','15000','1743000','0','0','0','1743000','TIN','T0072597','D2TD','0','0','-','0','1623000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2TD-YHBG-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='D2TD-YHBG-5-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225271222581','2025-09-27','1.050','2025-09-27','12:22:59','PLG0072967','1743000','1743000','0','1743000','0','kasir','2025-09-27 12:22:58','F22527122258');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-27','F225271222581','2025-09-27','12:22:59','TIN','1743000','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-250927-0001','2025-09-27','2025-09-27 12:22:58','PENJUALAN : F225271222581','12345678','BCA','1743000','1743000','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-250927-0002','D','2025-09-27','12:22:59','BCA','PENJUALAN','F225271222581','4004725888','1743000','4006468888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('12345678','AISYAH');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225270958251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225270958251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225270958251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225270958252' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225270958252' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225270958252';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225271000221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225271000221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225271000221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225271004511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225271004511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225271004511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225271004512' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225271004512' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225271004512';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225271004513' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225271004513' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225271004513';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225271108051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225271108051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225271108051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225271122571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225271122571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225271122571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225271222581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225271222581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225271222581';
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 ('F225270117141','kasir','1',' MEE1 CM 10','TOKO','SMBK-E','E1E-YIBC-4-T','CC MODEL DAUN VAR CM 10 8K ','OL','0.720','1','100.00','667000','0','0','15000','695000','0','5000','0','700000','NS','T0073250','E1E','0','0','-','0','948000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YIBC-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='E1E-YIBC-4-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 ('F225270117141','2025-09-27','0.720','2025-09-27','13:17:14','PLG0072968','695000','695000','5000','700000','700000','kasir','2025-09-27 13:17:14','F22527011714');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-27','F225270117141','2025-09-27','13:17:14','NS','700000','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-250927-0010','D','2025-09-27','13:17:14','kasir','PENJUALAN','F225270117141','650981000','700000','651681000');
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-250927-0001','1','B1E-XBBI-121-0','1','1.000','1.000','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-XBBI-121-0' 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('2025-09-27','TOKO','BK-B','B1E','B1E-XBBI-121-0','100.00','1','1.000','1.000','1','1.000','1.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.000',berat_out_asli=berat_out_asli+'1.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-27' AND kode_barang='B1E-XBBI-121-0' 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-250927-0001','2','B1D-XHBI-213-0','1','0.960','0.960','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='B1D-XHBI-213-0' 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('2025-09-27','TOKO','BK-B','B1D','B1D-XHBI-213-0','100.00','1','0.960','0.960','1','0.960','0.960');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.960',berat_out_asli=berat_out_asli+'0.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-27' AND kode_barang='B1D-XHBI-213-0' 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-250927-0001','2025-09-27','2025-09-27','14:22','1.96','admin','2025-09-27 14:23: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-250927-0002','1','D2F-YCAH-413-0','1','0.590','0.590','TOKO','SMBK-D','TOKO','BK-D');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-D' WHERE kode_barang='D2F-YCAH-413-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-D';
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('2025-09-27','TOKO','BK-D','D2F','D2F-YCAH-413-0','100.00','1','0.590','0.590','1','0.590','0.590');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.590',berat_out_asli=berat_out_asli+'0.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-27' AND kode_barang='D2F-YCAH-413-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-D' 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-250927-0002','2','D1E-YIAE-101-0','1','0.700','0.700','TOKO','SMBK-D','TOKO','BK-D');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-D' WHERE kode_barang='D1E-YIAE-101-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-D';
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('2025-09-27','TOKO','BK-D','D1E','D1E-YIAE-101-0','100.00','1','0.700','0.700','1','0.700','0.700');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.700',berat_out_asli=berat_out_asli+'0.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-27' AND kode_barang='D1E-YIAE-101-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-D' 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-250927-0002','3','D2E-WDAD-411-0','1','1.850','1.850','TOKO','SMBK-D','TOKO','BK-D');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-D' WHERE kode_barang='D2E-WDAD-411-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-D';
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('2025-09-27','TOKO','BK-D','D2E','D2E-WDAD-411-0','100.00','1','1.850','1.850','1','1.850','1.850');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.850',berat_out_asli=berat_out_asli+'1.850',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-27' AND kode_barang='D2E-WDAD-411-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-D' 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-250927-0002','2025-09-27','2025-09-27','14:23','3.14','admin','2025-09-27 14:23:54');
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-250927-0003','1','E0C-YEBH-54-0','1','2.000','2.000','TOKO','SMBK-E','TOKO','BK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-E' WHERE kode_barang='E0C-YEBH-54-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-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('2025-09-27','TOKO','BK-E','E0C','E0C-YEBH-54-0','100.00','1','2.000','2.000','1','2.000','2.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.000',berat_out_asli=berat_out_asli+'2.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-27' AND kode_barang='E0C-YEBH-54-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-E' 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-250927-0003','2','E0C-YEBH-51-0','1','2.020','2.020','TOKO','SMBK-E','TOKO','BK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-E' WHERE kode_barang='E0C-YEBH-51-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-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('2025-09-27','TOKO','BK-E','E0C','E0C-YEBH-51-0','100.00','1','2.020','2.020','1','2.020','2.020');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.020',berat_out_asli=berat_out_asli+'2.020',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-27' AND kode_barang='E0C-YEBH-51-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-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-250927-0003','2025-09-27','2025-09-27','14:23','4.02','admin','2025-09-27 14:24:19');
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-00004679','X-00004679','GL KAKI KOREA VAR KH 8K','GR','---','F3F','BELI','BELI001','1877000','2025-09-27','2.080','1','kasir','2025-09-27 14:52:15');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00004679','X-00004679');
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-250927-0001','F225260301331','RHM','1','BELI','BELI001','F3F', 'X-00004679', 'GL KAKI KOREA VAR KH 8K','2.080','2.080','100.00','2018000','1877000','902404','968000','1','1877000','1877000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.080',berat_beli_asli=berat_beli_asli+'2.080',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.080',berat_akhir_asli=berat_akhir_asli+'2.080',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-250927-0001','2025-09-27','2025-09-27','14:52:14','RHM','---','2.080','1877000','1877000','1877000','1877000','1877000','kasir','2025-09-27 14:52:15','FB-250927-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250927-0001','ANA','BULULOR. JAMBON','','','','kasir','2025-09-27 14:52:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-27' 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-250927-0011','K','2025-09-27','14:52:14','kasir','PEMBELIAN UMUM','FB-250927-0001','651681000','1877000','649804000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250927-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250927-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225270117141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225270117141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225270117141';
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 ('F225270319471','kasir','1',' MEE2 HTM 2','TOKO','SMBK-E','E2E-YIBB-19-T','CC PIPA MODEL MATA VAR HTM 20 8K ','','0.470','1','100.00','436000','0','0','15000','447000','0','0','0','447000','TIN','T0073155','E2E','0','0','-','0','948000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YIBB-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='E2E-YIBB-19-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 ('F225270319471','2025-09-27','0.470','2025-09-27','15:19:47','PLG0072969','447000','447000','0','447000','447000','kasir','2025-09-27 15:19:47','F22527031947');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-27','F225270319471','2025-09-27','15:19:47','TIN','447000','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-250927-0012','D','2025-09-27','15:19:47','kasir','PENJUALAN','F225270319471','649804000','447000','650251000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225270319471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225270319471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225270319471';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-28','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-28';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-27';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-27';
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='2025-09-27' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-27';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-27';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-27';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-27';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-28' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-27' 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-250928-0001','D','2025-09-28','16:01:39','SYSTEM','SALDO AWAL','SALDO AWAL','0','650251000','650251000');
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-250928-0001','D','2025-09-28','16:01:39','BCA','SALDO AWAL','SALDO AWAL','0','4006468888','4006468888');
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-250928-0001','D','2025-09-28','16:01:39','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250928-0001','D','2025-09-28','16:01:39','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-250928-0001','D','2025-09-28','16:01:39','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-250928-0001','D','2025-09-28','16:01:39','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2025-09-28';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250928-0001','1','B1E-XBBI-121-0','1','1.000','TOKO','BK-B');
DELETE FROM tm_barang_export WHERE kode_barang='B1E-XBBI-121-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='B1E-XBBI-121-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='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-XBBI-121-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.000',berat_out_asli='1.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.000',berat_akhir_asli =berat_akhir_asli-'1.000' WHERE kode_barang='B1E-XBBI-121-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250928-0001','2','B1D-XHBI-213-0','1','0.960','TOKO','BK-B');
DELETE FROM tm_barang_export WHERE kode_barang='B1D-XHBI-213-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='B1D-XHBI-213-0' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='B1D' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='B1D' 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='B1D-XHBI-213-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.960',berat_out_asli='0.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.960',berat_akhir_asli =berat_akhir_asli-'0.960' WHERE kode_barang='B1D-XHBI-213-0' 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-250928-0001','2025-09-28','2025-09-28','16:40','0.960','input','250928');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250928-0002','1','D2E-WDAD-411-0','1','1.850','TOKO','BK-D');
DELETE FROM tm_barang_export WHERE kode_barang='D2E-WDAD-411-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='D2E-WDAD-411-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='D2E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-D';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-D';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='D2E-WDAD-411-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.850',berat_out_asli='1.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.850',berat_akhir_asli =berat_akhir_asli-'1.850' WHERE kode_barang='D2E-WDAD-411-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250928-0002','2','D2F-YCAH-413-0','1','0.590','TOKO','BK-D');
DELETE FROM tm_barang_export WHERE kode_barang='D2F-YCAH-413-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='D2F-YCAH-413-0' 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='D2F' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='D2F' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-D';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-D';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='D2F-YCAH-413-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.590',berat_out_asli='0.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.590',berat_akhir_asli =berat_akhir_asli-'0.590' WHERE kode_barang='D2F-YCAH-413-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250928-0002','3','D1E-YIAE-101-0','1','0.700','TOKO','BK-D');
DELETE FROM tm_barang_export WHERE kode_barang='D1E-YIAE-101-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='D1E-YIAE-101-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='D1E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-D';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-D';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='D1E-YIAE-101-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.700',berat_out_asli='0.700', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.700',berat_akhir_asli =berat_akhir_asli-'0.700' WHERE kode_barang='D1E-YIAE-101-0' 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-250928-0002','2025-09-28','2025-09-28','16:40','0.700','input','250928');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250928-0003','1','E0C-YEBH-51-0','1','2.020','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E0C-YEBH-51-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E0C-YEBH-51-0' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='MC' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MC' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='E0C' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E0C' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-E';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E0C-YEBH-51-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.020',berat_out_asli='2.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.020',berat_akhir_asli =berat_akhir_asli-'2.020' WHERE kode_barang='E0C-YEBH-51-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250928-0003','2','E0C-YEBH-54-0','1','2.000','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E0C-YEBH-54-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E0C-YEBH-54-0' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='MC' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MC' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='E0C' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E0C' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-E';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E0C-YEBH-54-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='E0C-YEBH-54-0' 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-250928-0003','2025-09-28','2025-09-28','16:40','2.000','input','250928');