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 ('F325070841341','input','1',' MEF1 UB D5','TOKO','PM-F','F1E-YKXC-410-0','GL OVAL MODEL C UB D56 8K ','','2.240','1','100.00','2218000','0','0','15000','2218000','0','0','0','2218000','SIN','00376339','F1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YKXC-410-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.240',berat_jual_asli=berat_jual_asli+'2.240',stock_jual='1',berat_akhir=berat_akhir-'2.240',berat_akhir_asli=berat_akhir_asli-'2.240',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='F1E-YKXC-410-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325070841341','2025-11-07','2.240','2025-11-07','08:41:35','PLG0025567','2218000','2218000','0','2218000','2218000','input','2025-11-07 08:41:34','F32507084134');
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-11-07','F325070841341','2025-11-07','08:41:35','SIN','2218000','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-251107-0002','D','2025-11-07','08:41:35','input','PENJUALAN','F325070841341','562166000','2218000','564384000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2218000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325070841341' 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 ('F325070841342','input',' 1',' MEF3E X LG','TOKO','PM-F','F3E-YKXD-99-0','GL X KREPYAK DAUN SLEP LG 8K ','','2.700','1','100.00','2673000','0','0','15000','2675000','0','0','0','2675000','SIN','00376635','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKXD-99-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.700',berat_jual_asli=berat_jual_asli+'2.700',stock_jual='1',berat_akhir=berat_akhir-'2.700',berat_akhir_asli=berat_akhir_asli-'2.700',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='F3E-YKXD-99-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325070841342','2025-11-07','2.700','2025-11-07','08:41:35','PLG0025568','2675000','2675000','0','2675000','2675000','input','2025-11-07 08:41:34','F32507084134');
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-11-07','F325070841342','2025-11-07','08:41:35','SIN','2675000','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-251107-0003','D','2025-11-07','08:41:35','input','PENJUALAN','F325070841342','564384000','2675000','567059000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2675000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325070841342' 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 ('F325070843091','input','1',' MEH1 XX UB','TOKO','PM-H','H1E-YGAH-339-0','KL XX SANTA MODEL MATA VAR UB 8K ','','2.540','1','100.00','2515000','0','0','15000','2515000','0','0','0','2515000','AAT','00361748','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YGAH-339-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.540',berat_jual_asli=berat_jual_asli+'2.540',stock_jual='1',berat_akhir=berat_akhir-'2.540',berat_akhir_asli=berat_akhir_asli-'2.540',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='H1E-YGAH-339-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325070843091','2025-11-07','2.540','2025-11-07','08:43:10','PLG0025569','2515000','2515000','0','2515000','2515000','input','2025-11-07 08:43:09','F32507084309');
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-11-07','F325070843091','2025-11-07','08:43:10','AAT','2515000','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-251107-0004','D','2025-11-07','08:43:10','input','PENJUALAN','F325070843091','567059000','2515000','569574000');
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 ('F325070941041','input','1',' MEB1 LG PE','TOKO','PM-B','B1E-YIXH-42-0','GW TUSUK MODEL MATA VAR LG PE 8K ','','0.600','1','100.00','594000','0','0','15000','595000','0','0','0','595000','FIT','00368598','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YIXH-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='B1E-YIXH-42-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325070941041','2025-11-07','0.600','2025-11-07','09:41:04','PLG0025570','595000','595000','0','595000','595000','input','2025-11-07 09:41:04','F32507094104');
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-11-07','F325070941041','2025-11-07','09:41:04','FIT','595000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251107-0005','D','2025-11-07','09:41:04','input','PENJUALAN','F325070941041','569574000','595000','570169000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='595000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325070941041' 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 ('F325070941042','input',' 1',' MDE2 X HW ','TOKO','PM-E','E2D-YJBC-102-0','CC X MODEL LISTEING MATA HW 13 8K ','','0.820','1','100.00','795000','0','0','15000','795000','0','0','0','795000','FIT','00374420','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJBC-102-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='E2D-YJBC-102-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325070941042','2025-11-07','0.820','2025-11-07','09:41:04','PLG0025571','795000','795000','0','795000','795000','input','2025-11-07 09:41:04','F32507094104');
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-11-07','F325070941042','2025-11-07','09:41:04','FIT','795000','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-251107-0006','D','2025-11-07','09:41:04','input','PENJUALAN','F325070941042','570169000','795000','570964000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='795000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325070941042' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070941041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070941041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070941041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070941042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070941042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070941042';
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 ('F325070949191','kasir','1',' MDE2 5K UB','TOKO','PM-E','E2D-XJAF-165-0','CC MODEL MATA UB 16 8K ','','1.070','1','100.00','1038000','0','0','15000','1038000','0','5000','0','1043000','AAT','00321915','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-XJAF-165-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='E2D-XJAF-165-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325070949191','2025-11-07','1.070','2025-11-07','09:49:20','PLG0025572','1038000','1038000','5000','1043000','1043000','kasir','2025-11-07 09:49:19','F32507094919');
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-11-07','F325070949191','2025-11-07','09:49:20','AAT','1043000','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-251107-0009','D','2025-11-07','09:49:20','kasir','PENJUALAN','F325070949191','569574000','1043000','570617000');
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 ('F325070950221','kasir','1',' MDE2 X HW ','TOKO','PM-E','E2D-YJBC-102-0','CC X MODEL LISTEING MATA HW 13 8K ','','0.820','1','100.00','795000','0','0','15000','795000','0','0','0','795000','FIT','00374420','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJBC-102-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='E2D-YJBC-102-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325070950221','2025-11-07','0.820','2025-11-07','09:50:22','PLG0025573','795000','795000','0','795000','795000','kasir','2025-11-07 09:50:22','F32507095022');
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-11-07','F325070950221','2025-11-07','09:50:22','FIT','795000','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-251107-0010','D','2025-11-07','09:50:22','kasir','PENJUALAN','F325070950221','570617000','795000','571412000');
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 ('F325070951301','kasir','1',' MEB1 LG PE','TOKO','PM-B','B1E-YIXH-42-0','GW TUSUK MODEL MATA VAR LG PE 8K ','','0.600','1','100.00','594000','0','0','15000','595000','0','0','0','595000','FIT','00368598','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YIXH-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='B1E-YIXH-42-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325070951301','2025-11-07','0.600','2025-11-07','09:51:30','PLG0025574','595000','595000','0','595000','595000','kasir','2025-11-07 09:51:30','F32507095130');
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-11-07','F325070951301','2025-11-07','09:51:30','FIT','595000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251107-0011','D','2025-11-07','09:51:30','kasir','PENJUALAN','F325070951301','571412000','595000','572007000');
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 ('F325071029461','kasir','1',' MEF3E X LT','TOKO','PM-F','F3E-YHBB-73-0','GL X RANTAI HOLLOW LT 8K ','','1.060','1','100.00','1049000','0','0','15000','1050000','0','0','0','1050000','FIT','00366686','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHBB-73-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='F3E-YHBB-73-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325071029461','2025-11-07','1.060','2025-11-07','10:29:46','PLG0025575','1050000','1050000','0','1050000','1050000','kasir','2025-11-07 10:29:46','F32507102946');
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-11-07','F325071029461','2025-11-07','10:29:46','FIT','1050000','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-251107-0012','D','2025-11-07','10:29:46','kasir','PENJUALAN','F325071029461','572007000','1050000','573057000');
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 ('F325071040521','kasir','1',' MDA1 UB ','TOKO','PM-A','A1D-YGXA-15-0','AT MODEL HATI MATA VAR UB 8K ','','0.830','1','100.00','805000','0','0','15000','805000','0','0','0','805000','FIT','00359025','A1D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YGXA-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='A1D-YGXA-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325071040521','2025-11-07','0.830','2025-11-07','10:40:52','PLG0025576','805000','805000','0','805000','805000','kasir','2025-11-07 10:40:52','F32507104052');
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-11-07','F325071040521','2025-11-07','10:40:52','FIT','805000','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-251107-0013','D','2025-11-07','10:40:52','kasir','PENJUALAN','F325071040521','573057000','805000','573862000');
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 ('F325071127561','kasir','1',' MEF3 UB ','TOKO','PM-F','F3E-YKXC-442-0','GL SANTA SERUT MODEL SLEP VAR UB 8K ','','2.310','1','100.00','2287000','0','0','15000','2285000','0','0','0','2285000','SIN','00376372','F3E','0','0','-','1','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKXC-442-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.310',berat_jual_asli=berat_jual_asli+'2.310',stock_jual='1',berat_akhir=berat_akhir-'2.310',berat_akhir_asli=berat_akhir_asli-'2.310',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='F3E-YKXC-442-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325071127561','2025-11-07','2.310','2025-11-07','11:27:57','PLG0025577','2285000','2285000','0','2285000','2285000','kasir','2025-11-07 11:27:56','F32507112756');
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-11-07','F325071127561','2025-11-07','11:27:57','SIN','2285000','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-251107-0014','D','2025-11-07','11:27:57','kasir','PENJUALAN','F325071127561','573862000','2285000','576147000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2285000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325071127561' 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 ('F325071127562','kasir',' 1',' MEE1 LG 12','TOKO','PM-E','E1E-YJXD-314-0','CC MODEL DAUN VAR LG 12 8K ','','0.420','1','100.00','416000','0','0','15000','415000','0','0','0','415000','SIN','00372294','E1E','0','0','-','1','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJXD-314-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='E1E-YJXD-314-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325071127562','2025-11-07','0.420','2025-11-07','11:27:57','PLG0025578','415000','415000','0','415000','415000','kasir','2025-11-07 11:27:56','F32507112756');
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-11-07','F325071127562','2025-11-07','11:27:57','SIN','415000','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-251107-0015','D','2025-11-07','11:27:57','kasir','PENJUALAN','F325071127562','576147000','415000','576562000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='415000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325071127562' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325071127561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325071127561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325071127561';
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 ('F325071132171','kasir','1',' MEF3 UB ','TOKO','PM-F','F3E-YKXC-442-0','GL SANTA SERUT MODEL SLEP VAR UB 8K ','','2.310','1','100.00','2287000','0','0','15000','2285000','0','0','0','2285000','SIN','00376372','F3E','0','0','-','1','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKXC-442-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.310',berat_jual_asli=berat_jual_asli+'2.310',stock_jual='1',berat_akhir=berat_akhir-'2.310',berat_akhir_asli=berat_akhir_asli-'2.310',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='F3E-YKXC-442-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325071132171','2025-11-07','2.310','2025-11-07','11:32:17','PLG0025579','2285000','2285000','0','2285000','2285000','kasir','2025-11-07 11:32:17','F32507113217');
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-11-07','F325071132171','2025-11-07','11:32:17','SIN','2285000','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-251107-0017','D','2025-11-07','11:32:17','kasir','PENJUALAN','F325071132171','574277000','2285000','576562000');
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 ('F325071143561','kasir','1',' MEF3 UB ','TOKO','PM-F','F3E-YIBI-125-0','GL SANTA SERUT MODEL BOTEGA VAR UB 8K ','','1.580','1','100.00','1564000','0','0','15000','1565000','0','0','0','1565000','SIN','00370996','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIBI-125-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.580',berat_jual_asli=berat_jual_asli+'1.580',stock_jual='1',berat_akhir=berat_akhir-'1.580',berat_akhir_asli=berat_akhir_asli-'1.580',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='F3E-YIBI-125-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325071143561','2025-11-07','1.580','2025-11-07','11:43:57','PLG0025580','1565000','1565000','0','1565000','1565000','kasir','2025-11-07 11:43:56','F32507114356');
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-11-07','F325071143561','2025-11-07','11:43:57','SIN','1565000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251107-0018','D','2025-11-07','11:43:57','kasir','PENJUALAN','F325071143561','576562000','1565000','578127000');
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 ('F325071144421','kasir','1',' MEE1 LG 10','TOKO','PM-E','E1E-YJCX-92-0','CC MODEL DAUN SLEP LG 10 8K ','','0.430','1','100.00','426000','0','0','15000','425000','0','0','0','425000','SIN','00375304','E1E','0','0','-','1','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJCX-92-0' 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-11-07' AND kode_barang='E1E-YJCX-92-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325071144421','2025-11-07','0.430','2025-11-07','11:44:42','PLG0025581','425000','425000','0','425000','425000','kasir','2025-11-07 11:44:42','F32507114442');
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-11-07','F325071144421','2025-11-07','11:44:42','SIN','425000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251107-0019','D','2025-11-07','11:44:42','kasir','PENJUALAN','F325071144421','578127000','425000','578552000');
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 ('F325071201021','kasir','1',' MEF3E 12K ','TOKO','PM-F','F3E-YJCX-32-0','GL MEDAN SLEP PASIR LG 8K','','2.210','1','100.00','2188000','0','0','15000','2188000','0','12000','0','2200000','AAT','00375244','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJCX-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.210',berat_jual_asli=berat_jual_asli+'2.210',stock_jual='1',berat_akhir=berat_akhir-'2.210',berat_akhir_asli=berat_akhir_asli-'2.210',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='F3E-YJCX-32-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325071201021','2025-11-07','2.210','2025-11-07','12:01:02','PLG0025582','2188000','2188000','12000','2200000','2200000','kasir','2025-11-07 12:01:02','F32507120102');
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-11-07','F325071201021','2025-11-07','12:01:02','AAT','2200000','12000');
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-251107-0020','D','2025-11-07','12:01:02','kasir','PENJUALAN','F325071201021','578552000','2200000','580752000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2200000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325071201021' 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 ('F325071201022','kasir',' 1',' MDE1 CM 16','TOKO','PM-E','E1D-YJAF-196-0','CC MODEL PIPA SLEP CM 16 8K ','','0.800','1','100.00','776000','0','0','15000','776000','0','0','0','776000','AAT','00373513','E1D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJAF-196-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='E1D-YJAF-196-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325071201022','2025-11-07','0.800','2025-11-07','12:01:02','PLG0025583','776000','776000','0','776000','776000','kasir','2025-11-07 12:01:02','F32507120102');
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-11-07','F325071201022','2025-11-07','12:01:02','AAT','776000','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-251107-0021','D','2025-11-07','12:01:02','kasir','PENJUALAN','F325071201022','580752000','776000','581528000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='776000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325071201022' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325071201021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325071201021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325071201021';
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 ('F325071205311','kasir','1',' MEF3E 12K ','TOKO','PM-F','F3E-YJCX-32-0','GL MEDAN SLEP PASIR LG 8K','','2.210','1','100.00','2188000','0','0','15000','2188000','0','12000','0','2200000','AAT','00375244','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJCX-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.210',berat_jual_asli=berat_jual_asli+'2.210',stock_jual='1',berat_akhir=berat_akhir-'2.210',berat_akhir_asli=berat_akhir_asli-'2.210',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='F3E-YJCX-32-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325071205311','2025-11-07','2.210','2025-11-07','12:05:31','PLG0025584','2188000','2188000','12000','2200000','2200000','kasir','2025-11-07 12:05:31','F32507120531');
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-11-07','F325071205311','2025-11-07','12:05:31','AAT','2200000','12000');
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-251107-0023','D','2025-11-07','12:05:31','kasir','PENJUALAN','F325071205311','579328000','2200000','581528000');
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-00017413','X-00017413','AT X ITALY SLEP VAR PM 8K','GR','---','A1F','BELI','BELI001','510000','2025-11-07','0.550','1','kasir','2025-11-07 12:52:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00017413','X-00017413');
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-251107-0001','F325110244021','AAT','1','BELI','BELI001','A1F', 'X-00017413', 'AT X ITALY SLEP VAR PM 8K','0.550','0.550','100.00','565000','510000','927273','1020000','1','510000','510000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' 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-251107-0001','2025-11-07','2025-11-07','12:52:12','AAT','---','0.550','510000','510000','510000','510000','510000','kasir','2025-11-07 12:52:13','FB-251107-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251107-0001','YUNITA','JATISRONO','','','','kasir','2025-11-07 12:52:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251107-0024','K','2025-11-07','12:52:12','kasir','PEMBELIAN UMUM','FB-251107-0001','581528000','510000','581018000');
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-00017414','X-00017414','GW TIFF MATA VAR LG 8K','GR','---','B1E','BELI','BELI001','490000','2025-11-07','0.540','1','kasir','2025-11-07 14:08:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00017414','X-00017414');
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-251107-0002','F325021024431','AAT','1','BELI','BELI001','B1E', 'X-00017414', 'GW TIFF MATA VAR LG 8K','0.540','0.540','100.00','535000','490000','907407','1000000','1','490000','490000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.540',berat_beli_asli=berat_beli_asli+'0.540',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.540',berat_akhir_asli=berat_akhir_asli+'0.540',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' 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-251107-0002','2025-11-07','2025-11-07','14:08:45','AAT','---','0.540','490000','490000','490000','490000','490000','kasir','2025-11-07 14:08:45','FB-251107-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251107-0002','LILIS ISMAWATI','NAWANGAN','','','','kasir','2025-11-07 14:08:45');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251107-0025','K','2025-11-07','14:08:45','kasir','PEMBELIAN UMUM','FB-251107-0002','581018000','490000','580528000');
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 ('F325070301521','input','1',' MEH1 UB 42','TOKO','PM-H','H1E-YJAF-171-0','KL SANTA RIBBON MATA VAR UB 42 8K ','','2.110','1','100.00','2089000','0','0','15000','2090000','0','0','0','2090000','FIT','00373488','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJAF-171-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='H1E-YJAF-171-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325070301521','2025-11-07','2.110','2025-11-07','15:01:52','PLG0025585','2090000','2090000','0','2090000','2090000','input','2025-11-07 15:01:52','F32507030152');
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-11-07','F325070301521','2025-11-07','15:01:52','FIT','2090000','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-251107-0026','D','2025-11-07','15:01:52','input','PENJUALAN','F325070301521','580528000','2090000','582618000');
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-00017415','X-00017415','KL XXX CARENDELANO HURUF UB 8K N','GR','---','H1G','BELI','BELI001','1400000','2025-11-07','2.090','1','kasir','2025-11-07 15:05:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1G','X-00017415','X-00017415');
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-251107-0003','F324100218451','FIT','1','BELI','BELI001','H1G', 'X-00017415', 'KL XXX CARENDELANO HURUF UB 8K N','2.120','2.090','100.00','1330000','1400000','669856','1030000','1','1400000','1400000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.090',berat_beli_asli=berat_beli_asli+'2.090',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.090',berat_akhir_asli=berat_akhir_asli+'2.090',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1G' 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-251107-0003','2025-11-07','2025-11-07','15:05:40','FIT','---','2.090','1400000','1400000','1400000','1400000','1400000','kasir','2025-11-07 15:05:41','FB-251107-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251107-0003','NAISA','NAWANGAN','','','','kasir','2025-11-07 15:05:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251107-0027','K','2025-11-07','15:05:40','kasir','PEMBELIAN UMUM','FB-251107-0003','582618000','1400000','581218000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070301521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070301521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070301521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070841341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070841341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070841341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070841342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070841342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070841342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070843091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070843091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070843091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070949191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070949191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070949191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070950221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070950221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070950221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070951301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070951301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070951301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325071029461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325071029461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325071029461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325071040521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325071040521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325071040521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325071127562' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325071127562' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325071127562';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325071132171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325071132171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325071132171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325071143561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325071143561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325071143561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325071144421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325071144421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325071144421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325071201022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325071201022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325071201022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325071205311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325071205311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325071205311';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251107-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251107-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251107-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251107-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251107-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251107-0003';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-08','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-08';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-07';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-07';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-11-07' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-07';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-07';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-07';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-07';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-08' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-07' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251108-0001','D','2025-11-08','15:24:47','SYSTEM','SALDO AWAL','SALDO AWAL','0','581218000','581218000');
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-251108-0001','D','2025-11-08','15:24:47','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
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-251108-0001','D','2025-11-08','15:24:47','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-251108-0001','D','2025-11-08','15:24:47','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-11-08';
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-20251108-0001','1','E2E-WIBB-158-0','1','1.090','1.090','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-WIBB-158-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-WIBB-158-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-11-08 16:27:08' WHERE kode_barang='E2E-WIBB-158-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-WIBB-158-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-11-08 16:27:08','TOKO','PM-E','E2E','E2E-WIBB-158-0','1','1.090','1.090','1','1.090','1.090','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-WIBB-158-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-WIBB-158-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-20251108-0001','1','E2D-XJBF-212-0','1','1.110','1.110','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-XJBF-212-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-XJBF-212-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-11-08 16:27:08' WHERE kode_barang='E2D-XJBF-212-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-XJBF-212-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-11-08 16:27:08','TOKO','PM-E','E2D','E2D-XJBF-212-0','1','1.110','1.110','1','1.110','1.110','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-XJBF-212-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-XJBF-212-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-20251108-0001','1','E2D-YCBE-238-0','1','1.240','1.240','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YCBE-238-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YCBE-238-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-11-08 16:27:08' WHERE kode_barang='E2D-YCBE-238-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YCBE-238-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-11-08 16:27:08','TOKO','PM-E','E2D','E2D-YCBE-238-0','1','1.240','1.240','1','1.240','1.240','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-YCBE-238-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YCBE-238-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-20251108-0001','1','E2D-YDBA-50-0','1','1.060','1.060','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YDBA-50-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YDBA-50-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-11-08 16:27:08' WHERE kode_barang='E2D-YDBA-50-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YDBA-50-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-11-08 16:27:08','TOKO','PM-E','E2D','E2D-YDBA-50-0','1','1.060','1.060','1','1.060','1.060','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-YDBA-50-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YDBA-50-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-20251108-0001','1','E2D-YFXC-113-0','1','1.150','1.150','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YFXC-113-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YFXC-113-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-11-08 16:27:08' WHERE kode_barang='E2D-YFXC-113-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YFXC-113-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-11-08 16:27:08','TOKO','PM-E','E2D','E2D-YFXC-113-0','1','1.150','1.150','1','1.150','1.150','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-YFXC-113-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YFXC-113-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-20251108-0001','1','E2D-YGXG-84-0','1','1.080','1.080','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YGXG-84-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YGXG-84-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-11-08 16:27:08' WHERE kode_barang='E2D-YGXG-84-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YGXG-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-11-08 16:27:08','TOKO','PM-E','E2D','E2D-YGXG-84-0','1','1.080','1.080','1','1.080','1.080','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-YGXG-84-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YGXG-84-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-20251108-0001','1','E2D-YHXB-191-0','1','1.270','1.270','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YHXB-191-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YHXB-191-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-11-08 16:27:08' WHERE kode_barang='E2D-YHXB-191-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YHXB-191-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-11-08 16:27:08','TOKO','PM-E','E2D','E2D-YHXB-191-0','1','1.270','1.270','1','1.270','1.270','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-YHXB-191-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YHXB-191-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-20251108-0001','1','E2D-YHAD-111-0','1','1.250','1.250','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YHAD-111-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YHAD-111-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-11-08 16:27:08' WHERE kode_barang='E2D-YHAD-111-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YHAD-111-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-11-08 16:27:08','TOKO','PM-E','E2D','E2D-YHAD-111-0','1','1.250','1.250','1','1.250','1.250','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-YHAD-111-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YHAD-111-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251108-0001','2025-11-08','16:27','9.250','admpindah','2025-11-07 16:27:08');