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 ('F225110903571','kasir','1',' MDE2 CM 12','TOKO','SMBK-E','E2D-YIXH-41-T','CC WEDDING MATA CM 12 8K ','','1.070','1','100.00','974000','0','0','15000','1060000','0','0','0','1060000','TJ','T0073050','E2D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIXH-41-T' 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-10-11' AND kode_barang='E2D-YIXH-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 ('F225110903571','2025-10-11','1.070','2025-10-11','09:03:58','PLG0073527','1060000','1060000','0','1060000','1060000','kasir','2025-10-11 09:03:57','F22511090357');
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-10-11','F225110903571','2025-10-11','09:03:58','TJ','1060000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251011-0002','D','2025-10-11','09:03:58','kasir','PENJUALAN','F225110903571','1297082000','1060000','1298142000');
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 ('F225110917241','kasir','1',' TEB1 X CM ','TOKO','TBK-B','B1TE-YIXE-23-T','GW X TUSUK DAISY MATA CM PE 17K ','','0.510','1','100.00','836000','0','0','15000','916000','0','0','0','916000','TJ','T0072993','B1TE','0','0','-','0','1640000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TE-YIXE-23-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='2025-10-11' AND kode_barang='B1TE-YIXE-23-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225110917241','2025-10-11','0.510','2025-10-11','09:17:24','PLG0073528','916000','916000','0','916000','916000','kasir','2025-10-11 09:17:24','F22511091724');
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-10-11','F225110917241','2025-10-11','09:17:24','TJ','916000','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-251011-0003','D','2025-10-11','09:17:24','kasir','PENJUALAN','F225110917241','1298142000','916000','1299058000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110917241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110917241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110917241';
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 ('F225110920151','kasir','1',' MDE2 CM 18','TOKO','SMBK-E','E2D-YIBB-61-T','CC MODEL MATA VAR CM 18 8K ','','0.910','1','100.00','828000','0','0','15000','901000','0','0','0','901000','TJ','T0073197','E2D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIBB-61-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='E2D-YIBB-61-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 ('F225110920151','2025-10-11','0.910','2025-10-11','09:20:15','PLG0073529','901000','901000','0','901000','901000','kasir','2025-10-11 09:20:15','F22511092015');
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-10-11','F225110920151','2025-10-11','09:20:15','TJ','901000','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-251011-0004','D','2025-10-11','09:20:15','kasir','PENJUALAN','F225110920151','1299058000','901000','1299959000');
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 ('F225110931281','kasir','1',' MEH1 X KH ','TOKO','SMBK-H','H1E-YGXD-87-0','KL X NORY ANAK KH 34 8K ','','2.050','1','100.00','1900000','0','0','15000','2071000','0','0','0','2071000','TIN','00359403','H1E','0','0','-','0','1010000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YGXD-87-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='H1E-YGXD-87-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 ('F225110931281','2025-10-11','2.050','2025-10-11','09:31:29','PLG0073530','2071000','2071000','0','2071000','2071000','kasir','2025-10-11 09:31:28','F22511093128');
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-10-11','F225110931281','2025-10-11','09:31:29','TIN','2071000','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-251011-0005','D','2025-10-11','09:31:29','kasir','PENJUALAN','F225110931281','1299959000','2071000','1302030000');
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 ('F225110936461','kasir','1',' MEF1 X PM ','TOKO','SMBK-F','F1E-YIAB-124-0','GL X BANGKOK NEO SLEP PM 56 8K ','','3.960','1','100.00','3671000','0','0','15000','4000000','0','0','0','4000000','TJ','00368901','F1E','0','0','-','0','1010000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YIAB-124-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.960',berat_jual_asli=berat_jual_asli+'3.960',stock_jual='1',berat_akhir=berat_akhir-'3.960',berat_akhir_asli=berat_akhir_asli-'3.960',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='F1E-YIAB-124-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 ('F225110936461','2025-10-11','3.960','2025-10-11','09:36:46','PLG0073531','4000000','4000000','0','4000000','4000000','kasir','2025-10-11 09:36:46','F22511093646');
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-10-11','F225110936461','2025-10-11','09:36:46','TJ','4000000','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-251011-0006','D','2025-10-11','09:36:46','kasir','PENJUALAN','F225110936461','1302030000','4000000','1306030000');
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 ('F225110947111','kasir','1',' TDE2 10K C','TOKO','TBK-E','E2TD-YEBA-75-T','CC WEDDING MATA CM 16 17K ','','1.800','1','100.00','2921000','0','0','15000','3195000','0','10000','0','3205000','RHM','T0069496','E2TD','0','0','-','0','1623000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YEBA-75-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='E2TD-YEBA-75-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225110947111','2025-10-11','1.800','2025-10-11','09:47:12','PLG0073532','3195000','3195000','10000','3205000','3205000','kasir','2025-10-11 09:47:11','F22511094711');
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-10-11','F225110947111','2025-10-11','09:47:12','RHM','3205000','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-251011-0007','D','2025-10-11','09:47:12','kasir','PENJUALAN','F225110947111','1306030000','3205000','1309235000');
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 ('F225110951181','kasir','1',' MFF3 20K B','TOKO','SMBK-F','F3F-YICX-19-T','GL MODEL PASIR VAR BG 8K','ol','2.010','1','100.00','1946000','0','0','15000','2070000','0','20000','0','2090000','RTA','T0073431','F3F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YICX-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='F3F-YICX-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 ('F225110951181','2025-10-11','2.010','2025-10-11','09:51:18','PLG0073533','2070000','2070000','20000','2090000','2090000','kasir','2025-10-11 09:51:18','F22511095118');
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-10-11','F225110951181','2025-10-11','09:51:18','RTA','2090000','20000');
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-251011-0008','D','2025-10-11','09:51:18','kasir','PENJUALAN','F225110951181','1309235000','2090000','1311325000');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251011-0001','1','E1D-YJXA-69-T','1','1.050','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YJXA-69-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E1D-YJXA-69-T' 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='E1D' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E1D' 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='E1D-YJXA-69-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='E1D-YJXA-69-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-251011-0001','2025-10-11','2025-10-11','10:07','1.050','input','251011');
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 ('F225111017501','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-YIBB-2-T','GL CAPELA MODEL HATI ARESO VAR HW 8K ','','3.320','1','100.00','3078000','0','0','15000','3353000','0','0','0','3353000','TIN','T0073138','F3E','0','0','-','0','1010000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIBB-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.320',berat_jual_asli=berat_jual_asli+'3.320',stock_jual='1',berat_akhir=berat_akhir-'3.320',berat_akhir_asli=berat_akhir_asli-'3.320',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='F3E-YIBB-2-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225111017501','2025-10-11','3.320','2025-10-11','10:17:51','PLG0073534','3353000','3353000','0','3353000','3353000','kasir','2025-10-11 10:17:50','F22511101750');
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-10-11','F225111017501','2025-10-11','10:17:51','TIN','3353000','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-251011-0009','D','2025-10-11','10:17:51','kasir','PENJUALAN','F225111017501','1311325000','3353000','1314678000');
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 ('F225111048251','kasir','1',' TDE1 LG 18','TOKO','TBK-E','E1TD-YHBF-22-T','CC MODEL DAUN SLEP VAR LG 18 17K ','ol','0.960','1','100.00','1558000','0','0','15000','1733000','0','7000','0','1740000','TIN','T0072585','E1TD','0','0','-','0','1623000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YHBF-22-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='2025-10-11' AND kode_barang='E1TD-YHBF-22-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225111048251','2025-10-11','0.960','2025-10-11','10:48:25','PLG0073535','1733000','1733000','7000','1740000','1740000','kasir','2025-10-11 10:48:25','F22511104825');
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-10-11','F225111048251','2025-10-11','10:48:25','TIN','1740000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251011-0010','D','2025-10-11','10:48:25','kasir','PENJUALAN','F225111048251','1314678000','1740000','1316418000');
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 ('F225111148011','kasir','1',' MEF3 YT ','TOKO','SMBK-F','F3E-YJXF-71-T','GL MODEL LADY G YT 8K ','','4.990','1','100.00','4875000','0','0','15000','4965000','0','0','0','4965000','RTA','T0073969','F3E','0','0','-','0','1010000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJXF-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.990',berat_jual_asli=berat_jual_asli+'4.990',stock_jual='1',berat_akhir=berat_akhir-'4.990',berat_akhir_asli=berat_akhir_asli-'4.990',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='F3E-YJXF-71-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225111148011','2025-10-11','4.990','2025-10-11','11:48:01','PLG0073536','4965000','4965000','0','4965000','4965000','kasir','2025-10-11 11:48:01','F22511114801');
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-10-11','F225111148011','2025-10-11','11:48:01','RTA','4965000','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-251011-0011','D','2025-10-11','11:48:01','kasir','PENJUALAN','F225111148011','1316418000','4965000','1321383000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4965000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111148011' 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 ('F225111148012','kasir',' 1',' MFF1 UB D5','TOKO','SMBK-F','F1F-YCCX-9-T','GL OVAL MODEL BOTEGA VAR UB D54 8K ','','6.140','1','100.00','5796000','0','0','15000','6232000','0','0','0','6232000','RTA','T0068410','F1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1F-YCCX-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.140',berat_jual_asli=berat_jual_asli+'6.140',stock_jual='1',berat_akhir=berat_akhir-'6.140',berat_akhir_asli=berat_akhir_asli-'6.140',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='F1F-YCCX-9-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 ('F225111148012','2025-10-11','6.140','2025-10-11','11:48:01','PLG0073537','6232000','6232000','0','6232000','6232000','kasir','2025-10-11 11:48:01','F22511114801');
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-10-11','F225111148012','2025-10-11','11:48:01','RTA','6232000','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-251011-0012','D','2025-10-11','11:48:01','kasir','PENJUALAN','F225111148012','1321383000','6232000','1327615000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='6232000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111148012' 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 ('F225111215401','kasir','1',' TFF3 UB ','TOKO','TBK-F','F3TF-YIXE-35-T','GL KOREA UB 17K ','','0.430','1','100.00','713000','0','0','15000','781000','0','0','0','781000','TIN','T0073005','F3TF','0','0','-','0','1657000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TF-YIXE-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='F3TF-YIXE-35-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225111215401','2025-10-11','0.430','2025-10-11','12:15:41','PLG0073538','781000','781000','0','781000','781000','kasir','2025-10-11 12:15:40','F22511121540');
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-10-11','F225111215401','2025-10-11','12:15:41','TIN','781000','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-251011-0013','D','2025-10-11','12:15:41','kasir','PENJUALAN','F225111215401','1327615000','781000','1328396000');
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 ('F225111240571','kasir','1',' MEB1 CM ','TOKO','SMBK-B','B1E-YJXD-78-T','GW SUMPING MODEL DAUN VAR CM 8K ','OL','0.660','1','100.00','643000','0','0','15000','677000','0','5000','0','682000','TIN','T0073892','B1E','0','0','-','0','1010000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJXD-78-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='B1E-YJXD-78-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 ('F225111240571','2025-10-11','0.660','2025-10-11','12:40:58','PLG0073539','677000','677000','5000','682000','682000','kasir','2025-10-11 12:40:57','F22511124057');
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-10-11','F225111240571','2025-10-11','12:40:58','TIN','682000','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-251011-0014','D','2025-10-11','12:40:58','kasir','PENJUALAN','F225111240571','1328396000','682000','1329078000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='682000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111240571' 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 ('F225111240572','kasir',' 1',' MDE1 BW 23','TOKO','SMBK-E','E1D-YBXD-6-T','CC BANGKOK SLEP VAR BW 23 8K ','OL','1.000','1','100.00','910000','0','0','15000','1020000','0','5000','0','1025000','TIN','T0066508','E1D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YBXD-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='E1D-YBXD-6-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 ('F225111240572','2025-10-11','1.000','2025-10-11','12:40:58','PLG0073540','1020000','1020000','5000','1025000','1025000','kasir','2025-10-11 12:40:57','F22511124057');
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-10-11','F225111240572','2025-10-11','12:40:58','TIN','1025000','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-251011-0015','D','2025-10-11','12:40:58','kasir','PENJUALAN','F225111240572','1329078000','1025000','1330103000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1025000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111240572' 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 ('F225111240573','kasir',' 1',' MJH2 KH 42','TOKO','SMBK-H','H2J-YIBX-22-T','KL SIEM COBRA KH 42CM 9K ','OL','1.330','1','100.00','1346000','0','0','15000','1489000','0','7000','0','1496000','TIN','T0073120','H2J','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YIBX-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.330',berat_jual_asli=berat_jual_asli+'1.330',stock_jual='1',berat_akhir=berat_akhir-'1.330',berat_akhir_asli=berat_akhir_asli-'1.330',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='H2J-YIBX-22-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225111240573','2025-10-11','1.330','2025-10-11','12:40:58','PLG0073541','1489000','1489000','7000','1496000','1496000','kasir','2025-10-11 12:40:57','F22511124057');
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-10-11','F225111240573','2025-10-11','12:40:58','TIN','1496000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251011-0016','D','2025-10-11','12:40:58','kasir','PENJUALAN','F225111240573','1330103000','1496000','1331599000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1496000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111240573' 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 ('F225111240574','kasir',' 1',' MFH1 UB 40','TOKO','SMBK-H','H1F-YHXE-51-T','KL MILANO UB 40CM 8K ','OL','3.100','1','100.00','2926000','0','0','15000','3224000','0','16000','0','3240000','TIN','T0071840','H1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YHXE-51-T' 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='2025-10-11' AND kode_barang='H1F-YHXE-51-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 ('F225111240574','2025-10-11','3.100','2025-10-11','12:40:58','PLG0073542','3224000','3224000','16000','3240000','3240000','kasir','2025-10-11 12:40:57','F22511124057');
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-10-11','F225111240574','2025-10-11','12:40:58','TIN','3240000','16000');
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-251011-0017','D','2025-10-11','12:40:58','kasir','PENJUALAN','F225111240574','1331599000','3240000','1334839000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3240000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111240574' 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 ('F225110102561','kasir','1',' MDE2 8K CM','TOKO','SMBK-E','E2D-YJXA-56-T','CC MODEL SOLITAIRE MATA CM 14 8K ','OL','1.060','1','100.00','986000','0','0','15000','1079000','0','8000','0','1087000','TIN','T0073548','E2D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJXA-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='E2D-YJXA-56-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 ('F225110102561','2025-10-11','1.060','2025-10-11','13:02:57','PLG0073543','1079000','1079000','8000','1087000','1087000','kasir','2025-10-11 13:02:56','F22511010256');
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-10-11','F225110102561','2025-10-11','13:02:57','TIN','1087000','8000');
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-251011-0018','D','2025-10-11','13:02:57','kasir','PENJUALAN','F225110102561','1334839000','1087000','1335926000');
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 ('F225110220121','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YJXB-168-0','CC X SOLITAIRE MATA CM 14 8K ','','1.100','1','100.00','1050000','0','0','15000','1089000','0','5000','0','1094000','TJ','00371752','E2D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJXB-168-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='E2D-YJXB-168-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 ('F225110220121','2025-10-11','1.100','2025-10-11','14:20:13','PLG0073544','1089000','1089000','5000','1094000','1094000','kasir','2025-10-11 14:20:12','F22511022012');
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-10-11','F225110220121','2025-10-11','14:20:13','TJ','1094000','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-251011-0019','D','2025-10-11','14:20:13','kasir','PENJUALAN','F225110220121','1335926000','1094000','1337020000');
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 ('F225110253561','kasir','1',' MEE2 HW 13','TOKO','SMBK-E','E2E-YHXG-96-T','CC MODEL MATA VAR HW 13 8K ','','0.570','1','100.00','528000','0','0','15000','576000','0','0','0','576000','TJ','T0072083','E2E','0','0','-','0','1010000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YHXG-96-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='E2E-YHXG-96-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 ('F225110253561','2025-10-11','0.570','2025-10-11','14:53:57','PLG0073545','576000','576000','0','576000','576000','kasir','2025-10-11 14:53:56','F22511025356');
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-10-11','F225110253561','2025-10-11','14:53:57','TJ','576000','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-251011-0020','D','2025-10-11','14:53:57','kasir','PENJUALAN','F225110253561','1337020000','576000','1337596000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='576000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110253561' 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 ('F225110253562','kasir',' 1',' MDA1D X LG','TOKO','SMBK-A','A1D-YHAI-143-0','AT X HUGGIES KLIP MATA LG 8K ','','1.230','1','100.00','1119000','0','0','15000','1218000','0','0','0','1218000','TJ','00366174','A1D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YHAI-143-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.230',berat_jual_asli=berat_jual_asli+'1.230',stock_jual='1',berat_akhir=berat_akhir-'1.230',berat_akhir_asli=berat_akhir_asli-'1.230',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='A1D-YHAI-143-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 ('F225110253562','2025-10-11','1.230','2025-10-11','14:53:57','PLG0073546','1218000','1218000','0','1218000','1218000','kasir','2025-10-11 14:53:56','F22511025356');
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-10-11','F225110253562','2025-10-11','14:53:57','TJ','1218000','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-251011-0021','D','2025-10-11','14:53:57','kasir','PENJUALAN','F225110253562','1337596000','1218000','1338814000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1218000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110253562' 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 ('F225110328001','kasir','1',' TDE2 10K C','TOKO','TBK-E','E2TD-YJXC-12-T','CC WEDDING MATA CM 18 17K ','','2.010','1','100.00','3262000','0','0','15000','3568000','0','10000','0','3578000','TJ','T0073733','E2TD','0','0','-','0','1623000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YJXC-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='E2TD-YJXC-12-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225110328001','2025-10-11','2.010','2025-10-11','15:28:00','PLG0073547','3568000','3568000','10000','3578000','3578000','kasir','2025-10-11 15:28:00','F22511032800');
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-10-11','F225110328001','2025-10-11','15:28:00','TJ','3578000','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-251011-0022','D','2025-10-11','15:28:00','kasir','PENJUALAN','F225110328001','1338814000','3578000','1342392000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3578000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110328001' 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 ('F225110328002','kasir',' 1',' TEE2 CM 20','TOKO','TBK-E','E2TE-WFAC-11-T','CC WEDDING MATA CM 20 ','','2.000','1','100.00','3280000','0','0','15000','3590000','0','0','0','3590000','TJ','T0045141','E2TE','0','0','-','0','1640000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-WFAC-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='E2TE-WFAC-11-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225110328002','2025-10-11','2.000','2025-10-11','15:28:00','PLG0073548','3590000','3590000','0','3590000','3590000','kasir','2025-10-11 15:28:00','F22511032800');
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-10-11','F225110328002','2025-10-11','15:28:00','TJ','3590000','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-251011-0023','D','2025-10-11','15:28:00','kasir','PENJUALAN','F225110328002','1342392000','3590000','1345982000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3590000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110328002' 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 ('F225110329071','kasir','1',' TFA1 X UB ','TOKO','TBK-A','A1TF-XDAB-4-T','AT X MODEL ITALY PANJANG VAR UB 17K ','','1.330','1','100.00','2204000','0','0','15000','2414000','0','0','0','2414000','RTA','T0056274','A1TF','0','0','-','0','1657000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TF-XDAB-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.330',berat_jual_asli=berat_jual_asli+'1.330',stock_jual='1',berat_akhir=berat_akhir-'1.330',berat_akhir_asli=berat_akhir_asli-'1.330',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='A1TF-XDAB-4-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 ('F225110329071','2025-10-11','1.330','2025-10-11','15:29:07','PLG0073549','2414000','2414000','0','2414000','2414000','kasir','2025-10-11 15:29:07','F22511032907');
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-10-11','F225110329071','2025-10-11','15:29:07','RTA','2414000','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-251011-0024','D','2025-10-11','15:29:07','kasir','PENJUALAN','F225110329071','1345982000','2414000','1348396000');
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 ('F225110331451','kasir','1',' MDE2 X YT ','TOKO','SMBK-E','E2D-YIAC-344-0','CC X SOLITAIRE MATA YT 15 8K ','','1.000','1','100.00','910000','0','0','15000','990000','0','5000','0','995000','TIN','00369428','E2D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIAC-344-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='E2D-YIAC-344-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 ('F225110331451','2025-10-11','1.000','2025-10-11','15:31:46','PLG0073550','990000','990000','5000','995000','995000','kasir','2025-10-11 15:31:45','F22511033145');
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-10-11','F225110331451','2025-10-11','15:31:46','TIN','995000','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-251011-0025','D','2025-10-11','15:31:46','kasir','PENJUALAN','F225110331451','1348396000','995000','1349391000');
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 ('F225110346371','kasir','1',' MEE2 HTM 1','TOKO','SMBK-E','E2E-YJXB-23-T','CC PIPA MODEL MATA HTM 16 8K ','OL','0.580','1','100.00','567000','0','0','15000','592000','0','5000','0','597000','TIN','T0073603','E2E','0','0','-','0','1010000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXB-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='E2E-YJXB-23-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 ('F225110346371','2025-10-11','0.580','2025-10-11','15:46:37','PLG0073551','592000','592000','5000','597000','597000','kasir','2025-10-11 15:46:37','F22511034637');
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-10-11','F225110346371','2025-10-11','15:46:37','TIN','597000','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-251011-0026','D','2025-10-11','15:46:37','kasir','PENJUALAN','F225110346371','1349391000','597000','1349988000');
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 ('F225110347181','kasir','1',' MEE2 X YT ','TOKO','SMBK-E','E2E-YJXD-58-0','CC X MODEL MATA YT 16 8K ','OL','0.550','1','100.00','537000','0','0','15000','561000','0','5000','0','566000','TIN','00372038','E2E','0','0','-','0','1010000');
UPDATE tm_barang SET tgl_last_jual='2025-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXD-58-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-10-11' AND kode_barang='E2E-YJXD-58-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 ('F225110347181','2025-10-11','0.550','2025-10-11','15:47:19','PLG0073552','561000','561000','5000','566000','566000','kasir','2025-10-11 15:47:18','F22511034718');
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-10-11','F225110347181','2025-10-11','15:47:19','TIN','566000','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-251011-0027','D','2025-10-11','15:47:19','kasir','PENJUALAN','F225110347181','1349988000','566000','1350554000');
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-00004732','X-00004732','GL COR T 17K','GR','---','F1TE','BELI','BELI001','4164000','2025-10-11','3.040','1','kasir','2025-10-11 15:54:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1TE','X-00004732','X-00004732');
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-251011-0001','F221150309171','RTA','1','BELI','BELI001','F1TE', 'X-00004732', 'GL COR T 17K','3.100','3.040','100.00','2170000','4164000','1369737','1640000','1','4164000','4164000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.040',berat_beli_asli=berat_beli_asli+'3.040',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.040',berat_akhir_asli=berat_akhir_asli+'3.040',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1TE' 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-251011-0001','2025-10-11','2025-10-11','15:54:38','RTA','---','3.040','4164000','4164000','4164000','4164000','4164000','kasir','2025-10-11 15:54:38','FB-251011-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251011-0001','SAKILA','KRADINAN','','','','kasir','2025-10-11 15:54:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-11' 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-251011-0028','K','2025-10-11','15:54:38','kasir','PEMBELIAN UMUM','FB-251011-0001','1350554000','4164000','1346390000');
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-00004733','X-00004733','KL SANTA ANAK MODEL BONEKA CAT VAR UB 8K','GR','---','H1E','BELI','BELI001','1687000','2025-10-11','2.410','1','kasir','2025-10-11 15:55:15');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00004733','X-00004733');
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-251011-0002','F225200834221','TIN','1','BELI','BELI001','H1E', 'X-00004733', 'KL SANTA ANAK MODEL BONEKA CAT VAR UB 8K','2.520','2.410','100.00','1731000','1687000','700000','1010000','1','1687000','1687000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.410',berat_beli_asli=berat_beli_asli+'2.410',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.410',berat_akhir_asli=berat_akhir_asli+'2.410',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-11' 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-251011-0002','2025-10-11','2025-10-11','15:55:14','TIN','---','2.410','1687000','1687000','1687000','1687000','1687000','kasir','2025-10-11 15:55:15','FB-251011-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251011-0002','AISYAH','TRISONO BBD','','','089524083894','kasir','2025-10-11 15:55:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-11' 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-251011-0029','K','2025-10-11','15:55:14','kasir','PEMBELIAN UMUM','FB-251011-0002','1346390000','1687000','1344703000');
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-00004734','X-00004734','KL ANAK MILANO UB 34CM 8K','GR','---','H1F','BELI','BELI001','1413000','2025-10-11','1.950','1','kasir','2025-10-11 15:55:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1F','X-00004734','X-00004734');
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-251011-0003','F225120912331','TIN','1','BELI','BELI001','H1F', 'X-00004734', 'KL ANAK MILANO UB 34CM 8K','2.010','1.950','100.00','1707000','1413000','724615','1005000','1','1413000','1413000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.950',berat_beli_asli=berat_beli_asli+'1.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.950',berat_akhir_asli=berat_akhir_asli+'1.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1F' 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-251011-0003','2025-10-11','2025-10-11','15:55:43','TIN','---','1.950','1413000','1413000','1413000','1413000','1413000','kasir','2025-10-11 15:55:43','FB-251011-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251011-0003','AFIKA','LEMBAH BABADAN','','','089505737211','kasir','2025-10-11 15:55:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-11' 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-251011-0030','K','2025-10-11','15:55:43','kasir','PEMBELIAN UMUM','FB-251011-0003','1344703000','1413000','1343290000');
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-00004735','X-00004735','CC DGP 17K','GR','---','E0TA','BELI','BELI001','3800000','2025-10-11','2.850','1','kasir','2025-10-11 15:56:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-E0TA';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E0TA','X-00004735','X-00004735');
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-251011-0004','F223130925533','RTA','1','BELI','BELI001','E0TA', 'X-00004735', 'CC DGP 17K','3.000','2.850','100.00','2295000','3800000','1333333','1555000','1','3800000','3800000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.850',berat_beli_asli=berat_beli_asli+'2.850',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.850',berat_akhir_asli=berat_akhir_asli+'2.850',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E0TA' 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-251011-0004','2025-10-11','2025-10-11','15:56:48','RTA','---','2.850','3800000','3800000','3800000','3800000','3800000','kasir','2025-10-11 15:56:49','FB-251011-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251011-0004','BU SUMINAH','KUNTI BUNGKAL','','','','kasir','2025-10-11 15:56:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-11' 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-251011-0031','K','2025-10-11','15:56:48','kasir','PEMBELIAN UMUM','FB-251011-0004','1343290000','3800000','1339490000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110102561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110102561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110102561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110220121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110220121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110220121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110253561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110253561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110253561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110253562' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110253562' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110253562';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110328001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110328001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110328001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110328002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110328002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110328002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110329071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110329071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110329071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110331451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110331451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110331451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110346371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110346371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110346371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110347181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110347181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110347181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110903571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110903571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110903571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110920151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110920151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110920151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110931281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110931281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110931281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110936461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110936461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110936461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110947111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110947111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110947111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110951181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110951181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110951181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111017501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111017501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111017501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111048251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111048251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111048251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111148011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111148011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111148011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111148012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111148012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111148012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111215401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111215401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111215401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111240571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111240571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111240571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111240572' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111240572' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111240572';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111240573' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111240573' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111240573';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111240574' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111240574' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111240574';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251011-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251011-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251011-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251011-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251011-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251011-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251011-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251011-0004';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-12','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-11';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-11';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-11';
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-10-11' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-11';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-11';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-11';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-11';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-12' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-11' 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-251012-0001','D','2025-10-12','16:36:20','SYSTEM','SALDO AWAL','SALDO AWAL','0','1339490000','1339490000');
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-251012-0001','D','2025-10-12','16:36:20','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251012-0001','D','2025-10-12','16:36:20','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251012-0001','D','2025-10-12','16:36:20','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251012-0001','D','2025-10-12','16:36:20','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251012-0001','D','2025-10-12','16:36:20','BCA','SALDO AWAL','SALDO AWAL','0','4051228888','4051228888');
UPDATE tp_system SET tgl_system='2025-10-12';
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-20251012-0001','1','A1E-YJAA-103-0','1','0.700','0.700','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YJAA-103-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YJAA-103-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2025-10-12 16:47:32' WHERE kode_barang='A1E-YJAA-103-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YJAA-103-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-10-12 16:47:32','TOKO','SMBK-A','A1E','A1E-YJAA-103-0','1','0.700','0.700','1','0.700','0.700','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' 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='A1E-YJAA-103-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YJAA-103-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-20251012-0001','1','A1E-YJAA-104-0','1','0.520','0.520','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YJAA-104-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YJAA-104-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2025-10-12 16:47:32' WHERE kode_barang='A1E-YJAA-104-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YJAA-104-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-10-12 16:47:32','TOKO','SMBK-A','A1E','A1E-YJAA-104-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' 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='A1E-YJAA-104-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YJAA-104-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251012-0001','2025-10-12','16:47','1.220','input','2025-10-11 16:47:32');
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-20251012-0001','1','B1E-YJAA-1-0','1','0.550','0.550','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-YJAA-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-YJAA-1-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-10-12 16:47:48' WHERE kode_barang='B1E-YJAA-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-YJAA-1-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-10-12 16:47:48','TOKO','SMBK-B','B1E','B1E-YJAA-1-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-YJAA-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-YJAA-1-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-20251012-0001','1','B1E-YJAA-8-0','1','0.550','0.550','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-YJAA-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-YJAA-8-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-10-12 16:47:48' WHERE kode_barang='B1E-YJAA-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-YJAA-8-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-10-12 16:47:48','TOKO','SMBK-B','B1E','B1E-YJAA-8-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-YJAA-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-YJAA-8-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251012-0001','2025-10-12','16:47','1.100','input','2025-10-11 16:47:48');
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-20251012-0001','1','D2D-YJAA-18-0','1','0.850','0.850','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D2D-YJAA-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2D-YJAA-18-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-10-12 16:48:03' WHERE kode_barang='D2D-YJAA-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2D-YJAA-18-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-10-12 16:48:03','TOKO','SMBK-D','D2D','D2D-YJAA-18-0','1','0.850','0.850','1','0.850','0.850','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2D' 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='D2D-YJAA-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2D-YJAA-18-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-20251012-0001','1','D1E-YJAA-25-0','1','0.480','0.480','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-YJAA-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-YJAA-25-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-10-12 16:48:03' WHERE kode_barang='D1E-YJAA-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-YJAA-25-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-10-12 16:48:03','TOKO','SMBK-D','D1E','D1E-YJAA-25-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' 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='D1E-YJAA-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-YJAA-25-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251012-0001','2025-10-12','16:47','1.330','input','2025-10-11 16:48:02');
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-20251012-0001','1','E2D-YJAA-33-0','1','1.640','1.640','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YJAA-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YJAA-33-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-10-12 16:48:18' WHERE kode_barang='E2D-YJAA-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YJAA-33-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-10-12 16:48:18','TOKO','SMBK-E','E2D','E2D-YJAA-33-0','1','1.640','1.640','1','1.640','1.640','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' 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='E2D-YJAA-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YJAA-33-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-20251012-0001','1','E2D-YJAA-36-0','1','1.810','1.810','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YJAA-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YJAA-36-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-10-12 16:48:18' WHERE kode_barang='E2D-YJAA-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YJAA-36-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-10-12 16:48:18','TOKO','SMBK-E','E2D','E2D-YJAA-36-0','1','1.810','1.810','1','1.810','1.810','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' 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='E2D-YJAA-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YJAA-36-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-20251012-0001','1','E2D-YJAA-37-0','1','1.020','1.020','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YJAA-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YJAA-37-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-10-12 16:48:18' WHERE kode_barang='E2D-YJAA-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YJAA-37-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-10-12 16:48:18','TOKO','SMBK-E','E2D','E2D-YJAA-37-0','1','1.020','1.020','1','1.020','1.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' 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='E2D-YJAA-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YJAA-37-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-20251012-0001','1','E2E-YJAA-43-0','1','0.790','0.790','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YJAA-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YJAA-43-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-10-12 16:48:18' WHERE kode_barang='E2E-YJAA-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YJAA-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 ('2025-10-12 16:48:18','TOKO','SMBK-E','E2E','E2E-YJAA-43-0','1','0.790','0.790','1','0.790','0.790','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' 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='E2E-YJAA-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YJAA-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-20251012-0001','1','E2E-YJAA-46-0','1','0.460','0.460','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YJAA-46-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YJAA-46-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-10-12 16:48:18' WHERE kode_barang='E2E-YJAA-46-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YJAA-46-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-10-12 16:48:18','TOKO','SMBK-E','E2E','E2E-YJAA-46-0','1','0.460','0.460','1','0.460','0.460','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' 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='E2E-YJAA-46-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YJAA-46-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-20251012-0001','1','E2E-YJAA-48-0','1','0.500','0.500','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YJAA-48-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YJAA-48-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-10-12 16:48:18' WHERE kode_barang='E2E-YJAA-48-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YJAA-48-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-10-12 16:48:18','TOKO','SMBK-E','E2E','E2E-YJAA-48-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' 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='E2E-YJAA-48-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YJAA-48-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-20251012-0001','1','E2D-YJAA-53-0','1','2.020','2.020','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YJAA-53-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YJAA-53-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-10-12 16:48:18' WHERE kode_barang='E2D-YJAA-53-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YJAA-53-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-12 16:48:18','TOKO','SMBK-E','E2D','E2D-YJAA-53-0','1','2.020','2.020','1','2.020','2.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' 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='E2D-YJAA-53-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YJAA-53-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-20251012-0001','1','E1E-YJAA-60-0','1','0.730','0.730','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YJAA-60-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YJAA-60-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-10-12 16:48:18' WHERE kode_barang='E1E-YJAA-60-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YJAA-60-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-10-12 16:48:18','TOKO','SMBK-E','E1E','E1E-YJAA-60-0','1','0.730','0.730','1','0.730','0.730','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-YJAA-60-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YJAA-60-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-20251012-0001','1','E1G-YJAA-84-0','1','0.330','0.330','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1G-YJAA-84-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1G-YJAA-84-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-10-12 16:48:18' WHERE kode_barang='E1G-YJAA-84-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1G-YJAA-84-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-10-12 16:48:18','TOKO','SMBK-E','E1G','E1G-YJAA-84-0','1','0.330','0.330','1','0.330','0.330','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1G-YJAA-84-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1G-YJAA-84-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251012-0001','2025-10-12','16:48','9.300','input','2025-10-11 16:48:17');
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-20251012-0001','1','F3E-YJAA-161-0','1','1.030','1.030','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YJAA-161-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YJAA-161-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-10-12 16:48:35' WHERE kode_barang='F3E-YJAA-161-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YJAA-161-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-12 16:48:35','TOKO','SMBK-F','F3E','F3E-YJAA-161-0','1','1.030','1.030','1','1.030','1.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' 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='F3E-YJAA-161-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YJAA-161-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251012-0001','1','F3E-YJAA-162-0','1','2.080','2.080','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YJAA-162-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YJAA-162-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-10-12 16:48:35' WHERE kode_barang='F3E-YJAA-162-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YJAA-162-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-10-12 16:48:35','TOKO','SMBK-F','F3E','F3E-YJAA-162-0','1','2.080','2.080','1','2.080','2.080','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' 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='F3E-YJAA-162-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YJAA-162-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251012-0001','2025-10-12','16:48','3.110','input','2025-10-11 16:48:34');
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-20251012-0001','1','H1E-YJAA-192-0','1','1.850','1.850','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YJAA-192-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YJAA-192-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-10-12 16:48:49' WHERE kode_barang='H1E-YJAA-192-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YJAA-192-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-10-12 16:48:49','TOKO','SMBK-H','H1E','H1E-YJAA-192-0','1','1.850','1.850','1','1.850','1.850','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YJAA-192-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YJAA-192-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251012-0001','2025-10-12','16:48','1.850','input','2025-10-11 16:48:49');