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 ('F225070914011','kasir','1',' MDE1D UB 1','TOKO','SMBK-E','E1D-YJAH-77-T','CC MODEL ISYANA SLEP UB 16 8K ','','0.990','1','100.00','970000','0','0','15000','970000','0','0','0','970000','TIN','T0074290','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-YJAH-77-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.990',berat_jual_asli=berat_jual_asli+'0.990',stock_jual='1',berat_akhir=berat_akhir-'0.990',berat_akhir_asli=berat_akhir_asli-'0.990',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='E1D-YJAH-77-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 ('F225070914011','2025-11-07','0.990','2025-11-07','09:14:02','PLG0074498','970000','970000','0','970000','970000','kasir','2025-11-07 09:14:01','F22507091401');
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','F225070914011','2025-11-07','09:14:02','TIN','970000','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-0002','D','2025-11-07','09:14:02','kasir','PENJUALAN','F225070914011','2417645000','970000','2418615000');
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 ('F225071014011','kasir','1',' MFH1F UB 4','TOKO','SMBK-H','H1F-YJBD-117-T','KL KOREA UB 46CM 8K ','','1.000','1','100.00','1020000','0','0','15000','1020000','0','0','0','1020000','TIN','T0074467','H1F','0','0','-','0','1015000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YJBD-117-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-11-07' AND kode_barang='H1F-YJBD-117-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 ('F225071014011','2025-11-07','1.000','2025-11-07','10:14:02','PLG0074499','1020000','1020000','0','1020000','1020000','kasir','2025-11-07 10:14:01','F22507101401');
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','F225071014011','2025-11-07','10:14:02','TIN','1020000','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','10:14:02','kasir','PENJUALAN','F225071014011','2418615000','1020000','2419635000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1020000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071014011' 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 ('F225071014012','kasir',' 1',' MED1E 5K L','TOKO','SMBK-D','D1E-YJBC-24-T','LT MODEL FINE GOLD LG 8K ','','0.540','1','100.00','540000','0','0','15000','540000','0','5000','0','545000','TIN','T0074397','D1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJBC-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='D1E-YJBC-24-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071014012','2025-11-07','0.540','2025-11-07','10:14:02','PLG0074500','540000','540000','5000','545000','545000','kasir','2025-11-07 10:14:01','F22507101401');
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','F225071014012','2025-11-07','10:14:02','TIN','545000','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-251107-0004','D','2025-11-07','10:14:02','kasir','PENJUALAN','F225071014012','2419635000','545000','2420180000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='545000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071014012' 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 ('F225071014013','kasir',' 1',' MEA1 BW ','TOKO','SMBK-A','A1E-YJXB-61-T','AT MODEL ITALY PANJANG VAR BW 8K ','','0.530','1','100.00','530000','0','0','15000','530000','0','0','0','530000','TIN','T0073641','A1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXB-61-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='A1E-YJXB-61-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071014013','2025-11-07','0.530','2025-11-07','10:14:02','PLG0074501','530000','530000','0','530000','530000','kasir','2025-11-07 10:14:01','F22507101401');
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','F225071014013','2025-11-07','10:14:02','TIN','530000','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','10:14:02','kasir','PENJUALAN','F225071014013','2420180000','530000','2420710000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='530000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225071014013' 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 ('F225071051161','kasir','1',' TEF1 UB D5','TOKO','TBK-F','F1TE-YJXB-134-T','GL OVAL MODEL C UB D52 17K ','OL','1.870','1','100.00','3347000','0','0','15000','3372000','0','13000','0','3385000','RTA','T0073714','F1TE','0','0','-','0','1790000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-YJXB-134-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.870',berat_jual_asli=berat_jual_asli+'1.870',stock_jual='1',berat_akhir=berat_akhir-'1.870',berat_akhir_asli=berat_akhir_asli-'1.870',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='F1TE-YJXB-134-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 ('F225071051161','2025-11-07','1.870','2025-11-07','10:51:16','PLG0074502','3372000','3372000','13000','3385000','3385000','kasir','2025-11-07 10:51:16','F22507105116');
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','F225071051161','2025-11-07','10:51:16','RTA','3385000','13000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251107-0006','D','2025-11-07','10:51:16','kasir','PENJUALAN','F225071051161','2420710000','3385000','2424095000');
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 ('F225071052161','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-YKXA-63-T','GL OVAL MODEL C TD D56 8K ','OL','3.190','1','100.00','3190000','0','0','15000','3206000','0','16000','0','3222000','RTA','T0074858','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-YKXA-63-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.190',berat_jual_asli=berat_jual_asli+'3.190',stock_jual='1',berat_akhir=berat_akhir-'3.190',berat_akhir_asli=berat_akhir_asli-'3.190',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='F1E-YKXA-63-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 ('F225071052161','2025-11-07','3.190','2025-11-07','10:52:16','PLG0074503','3206000','3206000','16000','3222000','3222000','kasir','2025-11-07 10:52:16','F22507105216');
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','F225071052161','2025-11-07','10:52:16','RTA','3222000','16000');
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-0007','D','2025-11-07','10:52:16','kasir','PENJUALAN','F225071052161','2424095000','3222000','2427317000');
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 ('F225071230551','kasir','1',' MEF3E KH ','TOKO','SMBK-F','F3E-YJBA-2-T','GL RANTAI HOLLOW P3 SLEP VAR KH 8K ','OL','2.200','1','100.00','2200000','0','0','15000','2222000','0','11000','0','2233000','TIN','T0074323','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-YJBA-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.200',berat_jual_asli=berat_jual_asli+'2.200',stock_jual='1',berat_akhir=berat_akhir-'2.200',berat_akhir_asli=berat_akhir_asli-'2.200',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='F3E-YJBA-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 ('F225071230551','2025-11-07','2.200','2025-11-07','12:30:56','PLG0074504','2222000','2222000','11000','2233000','2233000','kasir','2025-11-07 12:30:55','F22507123055');
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','F225071230551','2025-11-07','12:30:56','TIN','2233000','11000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251107-0008','D','2025-11-07','12:30:56','kasir','PENJUALAN','F225071230551','2427317000','2233000','2429550000');
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 ('F225071240511','kasir','1',' MFB1 LG ','TOKO','SMBK-B','B1F-YJXD-65-T','GW TOGE MODEL MATA VAR LG 8K ','OL','0.550','1','100.00','561000','0','0','15000','567000','0','5000','0','572000','RTA','T0073879','B1F','0','0','-','0','1015000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YJXD-65-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='B1F-YJXD-65-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225071240511','2025-11-07','0.550','2025-11-07','12:40:52','PLG0074505','567000','567000','5000','572000','0','kasir','2025-11-07 12:40:51','F22507124051');
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','F225071240511','2025-11-07','12:40:52','RTA','572000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251107-0001','2025-11-07','2025-11-07 12:40:51','PENJUALAN : F225071240511','898787676554','BCA','572000','572000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251107-0002','D','2025-11-07','12:40:52','BCA','PENJUALAN','F225071240511','4118465888','572000','4119037888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('898787676554','BYA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='572000' WHERE no_faktur_jual='F225071240511' 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 ('F225070132551','kasir','1',' MGF3G UB ','TOKO','SMBK-F','F3G-YJAE-64-T','GL RANTAI HOLLOW UB 8K ','OL','0.360','1','100.00','374000','0','0','15000','378000','0','5000','0','383000','TIN','T0074113','F3G','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3G-YJAE-64-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='F3G-YJAE-64-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 ('F225070132551','2025-11-07','0.360','2025-11-07','13:32:55','PLG0074506','378000','378000','5000','383000','0','kasir','2025-11-07 13:32:55','F22507013255');
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','F225070132551','2025-11-07','13:32:55','TIN','383000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251107-0002','2025-11-07','2025-11-07 13:32:55','PENJUALAN : F225070132551','12345645678','BCA','383000','383000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251107-0003','D','2025-11-07','13:32:55','BCA','PENJUALAN','F225070132551','4119037888','383000','4119420888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('12345645678','NADIA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='383000' WHERE no_faktur_jual='F225070132551' 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 ('F225070147431','kasir','1',' MDE1 CM 16','TOKO','SMBK-E','E1D-YJBI-67-T','CC POLOS CM 16 8K ','OL','1.050','1','100.00','1029000','0','0','15000','1056000','0','5000','0','1061000','TJ','T0074627','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-YJBI-67-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='E1D-YJBI-67-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 ('F225070147431','2025-11-07','1.050','2025-11-07','13:47:44','PLG0074507','1056000','1056000','5000','1061000','1061000','kasir','2025-11-07 13:47:43','F22507014743');
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','F225070147431','2025-11-07','13:47:44','TJ','1061000','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','13:47:44','kasir','PENJUALAN','F225070147431','2429550000','1061000','2430611000');
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-00004804','X-00004804','GW MODEL TOUGE HATI ARESO UB','GR','---','B1G','BELI','BELI001','257000','2025-11-07','0.360','1','kasir','2025-11-07 14:21:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1G','X-00004804','X-00004804');
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','F224150304311','RTA','1','BELI','BELI001','B1G', 'X-00004804', 'GW MODEL TOUGE HATI ARESO UB','0.390','0.360','100.00','211000','257000','713889','1040000','1','257000','257000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.360',berat_beli_asli=berat_beli_asli+'0.360',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.360',berat_akhir_asli=berat_akhir_asli+'0.360',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1G' 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','14:21:43','RTA','---','0.360','257000','257000','257000','257000','257000','kasir','2025-11-07 14:21:43','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','RENGGANIS','PLUNTURAN PULUNG','','','085785757472','kasir','2025-11-07 14:21:43');
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-0010','K','2025-11-07','14:21:43','kasir','PEMBELIAN UMUM','FB-251107-0001','2430611000','257000','2430354000');
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 ('F225070226241','kasir','1',' TEF3 X LT ','TOKO','TBK-F','F3TE-YJBH-7-T','GL X RANTAI HOLLOW P4 SLEP LT 17K ','','4.950','1','100.00','8860000','0','0','15000','8910000','0','0','0','8910000','RTA','T0074489','F3TE','0','0','-','0','1790000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YJBH-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.950',berat_jual_asli=berat_jual_asli+'4.950',stock_jual='1',berat_akhir=berat_akhir-'4.950',berat_akhir_asli=berat_akhir_asli-'4.950',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='F3TE-YJBH-7-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 ('F225070226241','2025-11-07','4.950','2025-11-07','14:26:24','PLG0074508','8910000','8910000','0','8910000','8910000','kasir','2025-11-07 14:26:24','F22507022624');
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','F225070226241','2025-11-07','14:26:24','RTA','8910000','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','14:26:24','kasir','PENJUALAN','F225070226241','2430354000','8910000','2439264000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070132551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070132551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070132551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070147431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070147431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070147431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070226241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070226241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070226241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070914011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070914011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070914011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071014011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071014011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071014011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071014012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071014012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071014012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071014013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071014013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071014013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071051161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071051161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071051161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071052161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071052161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071052161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071230551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071230551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071230551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225071240511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225071240511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225071240511';
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';
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 ('F225070303421','kasir','1',' MDA1D X LG','TOKO','SMBK-A','A1D-YIAE-50-0','AT X MODEL KLIP MATA LG 8K ','','0.970','1','100.00','951000','0','0','15000','950000','0','0','0','950000','RHM','00369501','A1D','0','0','-','1','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YIAE-50-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='A1D-YIAE-50-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 ('F225070303421','2025-11-07','0.970','2025-11-07','15:03:42','PLG0074509','950000','950000','0','950000','950000','kasir','2025-11-07 15:03:42','F22507030342');
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','F225070303421','2025-11-07','15:03:42','RHM','950000','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','15:03:42','kasir','PENJUALAN','F225070303421','2439264000','950000','2440214000');
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 ('F225070305141','kasir','1',' TEE1 X UB ','TOKO','TBK-E','E1TE-YJXB-101-T','CC X CERAMIC CLOVER GOLD UB 14 17K ','','0.570','1','100.00','1020000','0','0','15000','1026000','0','50000','0','1076000','TIN','T0073681','E1TE','0','0','-','0','1790000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-YJXB-101-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-11-07' AND kode_barang='E1TE-YJXB-101-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 ('F225070305141','2025-11-07','0.570','2025-11-07','15:05:14','PLG0074510','1026000','1026000','50000','1076000','1076000','kasir','2025-11-07 15:05:14','F22507030514');
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','F225070305141','2025-11-07','15:05:14','TIN','1076000','50000');
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','15:05:14','kasir','PENJUALAN','F225070305141','2440214000','1076000','2441290000');
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 ('F225070305351','kasir','1',' MGS1 UB ','TOKO','SMBK-S','S1G-YJCX-23-T','AS EXTENSION UB 8K ','','0.450','1','100.00','468000','0','0','15000','468000','0','0','0','468000','TIN','T0074727','S1G','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJCX-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-11-07' AND kode_barang='S1G-YJCX-23-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225070305351','2025-11-07','0.450','2025-11-07','15:05:36','PLG0074511','468000','468000','0','468000','468000','kasir','2025-11-07 15:05:35','F22507030535');
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','F225070305351','2025-11-07','15:05:36','TIN','468000','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-0014','D','2025-11-07','15:05:36','kasir','PENJUALAN','F225070305351','2441290000','468000','2441758000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070303421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070303421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070303421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070305141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070305141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070305141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225070305351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225070305351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225070305351';
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','16:03:39','SYSTEM','SALDO AWAL','SALDO AWAL','0','2441758000','2441758000');
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','16:03:39','BCA','SALDO AWAL','SALDO AWAL','0','4119420888','4119420888');
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','16:03:39','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-251108-0001','D','2025-11-08','16:03:39','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251108-0001','D','2025-11-08','16:03:39','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251108-0001','D','2025-11-08','16:03:39','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
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','F3E-YJCA-13-0','1','1.910','1.910','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YJCA-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YJCA-13-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-11-08 16:26:31' WHERE kode_barang='F3E-YJCA-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YJCA-13-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:26:31','TOKO','SMBK-F','F3E','F3E-YJCA-13-0','1','1.910','1.910','1','1.910','1.910','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-YJCA-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YJCA-13-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:26','1.910','input','2025-11-07 16:26:31');
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','PAG-YHXH-136-0','1','0.450','0.450','TOKO','SSBK-P','TOKO','SMBK-P');
DELETE FROM tm_barang WHERE kode_barang='PAG-YHXH-136-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PAG-YHXH-136-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-P',tgl_last_beli='2025-11-08 16:26:45' WHERE kode_barang='PAG-YHXH-136-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PAG-YHXH-136-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:26:45','TOKO','SMBK-P','PAG','PAG-YHXH-136-0','1','0.450','0.450','1','0.450','0.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='PAG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PAG' 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='PAG-YHXH-136-0';
DELETE FROM tm_barang_export WHERE kode_barang='PAG-YHXH-136-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:26','0.450','input','2025-11-07 16:26:44');