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 ('F325010858301','input','1',' MIH2 XX KH','TOKO','PM-H','H2I-YJXA-332-0','KL XX SANTA ANAK KH 34 9K ','','1.510','1','100.00','1616000','0','0','15000','1615000','0','0','0','1615000','SIN','00371577','H2I','0','0','-','1','1080000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YJXA-332-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='H2I-YJXA-332-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 ('F325010858301','2025-11-01','1.510','2025-11-01','08:58:31','PLG0025475','1615000','1615000','0','1615000','1615000','input','2025-11-01 08:58:30','F32501085830');
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-01','F325010858301','2025-11-01','08:58:31','SIN','1615000','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-251101-0002','D','2025-11-01','08:58:31','input','PENJUALAN','F325010858301','483534000','1615000','485149000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1615000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325010858301' 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 ('F325010858302','input',' 1',' MEH1 X UB ','TOKO','PM-H','H1E-YGAX-79-0','KL X TIFF SPECTRA HITAM VAR UB 42 8K ','','2.150','1','100.00','2128000','0','0','15000','2130000','0','0','0','2130000','SIN','00360473','H1E','0','0','-','0','990000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YGAX-79-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.150',berat_jual_asli=berat_jual_asli+'2.150',stock_jual='1',berat_akhir=berat_akhir-'2.150',berat_akhir_asli=berat_akhir_asli-'2.150',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='H1E-YGAX-79-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 ('F325010858302','2025-11-01','2.150','2025-11-01','08:58:31','PLG0025476','2130000','2130000','0','2130000','2130000','input','2025-11-01 08:58:30','F32501085830');
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-01','F325010858302','2025-11-01','08:58:31','SIN','2130000','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-251101-0003','D','2025-11-01','08:58:31','input','PENJUALAN','F325010858302','485149000','2130000','487279000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2130000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325010858302' 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 ('F325010858581','input','1',' MDE1 CM 14','TOKO','PM-E','E1D-YJAF-189-0','CC MODEL SLEP CM 14 8K ','','0.920','1','100.00','892000','0','0','15000','893000','0','0','0','893000','AAT','00373506','E1D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJAF-189-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.920',berat_jual_asli=berat_jual_asli+'0.920',stock_jual='1',berat_akhir=berat_akhir-'0.920',berat_akhir_asli=berat_akhir_asli-'0.920',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='E1D-YJAF-189-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 ('F325010858581','2025-11-01','0.920','2025-11-01','08:58:59','PLG0025477','893000','893000','0','893000','893000','input','2025-11-01 08:58:58','F32501085858');
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-01','F325010858581','2025-11-01','08:58:59','AAT','893000','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-251101-0004','D','2025-11-01','08:58:59','input','PENJUALAN','F325010858581','487279000','893000','488172000');
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 ('F325010902231','input','1',' MEF2 10K C','TOKO','PM-F','F2E-YJXF-31-0','GL OVAL MODEL DAUN MATA VAR CM D55 8K ','','2.450','1','100.00','2425000','0','0','15000','2425000','0','10000','0','2435000','FIT','00372328','F2E','0','0','-','0','990000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YJXF-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.450',berat_jual_asli=berat_jual_asli+'2.450',stock_jual='1',berat_akhir=berat_akhir-'2.450',berat_akhir_asli=berat_akhir_asli-'2.450',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='F2E-YJXF-31-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 ('F325010902231','2025-11-01','2.450','2025-11-01','09:02:24','PLG0025478','2425000','2425000','10000','2435000','2435000','input','2025-11-01 09:02:23','F32501090223');
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-01','F325010902231','2025-11-01','09:02:24','FIT','2435000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251101-0005','D','2025-11-01','09:02:24','input','PENJUALAN','F325010902231','488172000','2435000','490607000');
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 ('F325010902451','input','1',' MEF1 PM 54','TOKO','PM-F','F1E-YJAH-41-0','GL OVAL DAUN SLEP PM 54 8K ','','2.990','1','100.00','2960000','0','0','15000','2960000','0','0','0','2960000','FIT','00373736','F1E','0','0','-','0','990000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YJAH-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.990',berat_jual_asli=berat_jual_asli+'2.990',stock_jual='1',berat_akhir=berat_akhir-'2.990',berat_akhir_asli=berat_akhir_asli-'2.990',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='F1E-YJAH-41-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 ('F325010902451','2025-11-01','2.990','2025-11-01','09:02:45','PLG0025479','2960000','2960000','0','2960000','2960000','input','2025-11-01 09:02:45','F32501090245');
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-01','F325010902451','2025-11-01','09:02:45','FIT','2960000','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-251101-0006','D','2025-11-01','09:02:45','input','PENJUALAN','F325010902451','490607000','2960000','493567000');
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 ('F325010933351','input','1',' MJH2 X UB ','TOKO','PM-H','H2J-YJAC-109-0','KL X GUCCI UB 42 9K ','','3.000','1','100.00','3270000','0','0','15000','3270000','0','0','0','3270000','AAT','00372839','H2J','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YJAC-109-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='H2J-YJAC-109-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 ('F325010933351','2025-11-01','3.000','2025-11-01','09:33:35','PLG0025480','3270000','3270000','0','3270000','3270000','input','2025-11-01 09:33:35','F32501093335');
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-01','F325010933351','2025-11-01','09:33:35','AAT','3270000','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-251101-0007','D','2025-11-01','09:33:35','input','PENJUALAN','F325010933351','493567000','3270000','496837000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3270000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325010933351' 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 ('F325010933352','input',' 1',' MEF3E X HW','TOKO','PM-F','F3E-YJBB-169-0','GL X CASTELI SLEP HW 8K ','','1.340','1','100.00','1327000','0','0','15000','1327000','0','0','0','1327000','AAT','00374232','F3E','0','0','-','0','990000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJBB-169-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.340',berat_jual_asli=berat_jual_asli+'1.340',stock_jual='1',berat_akhir=berat_akhir-'1.340',berat_akhir_asli=berat_akhir_asli-'1.340',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='F3E-YJBB-169-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 ('F325010933352','2025-11-01','1.340','2025-11-01','09:33:35','PLG0025481','1327000','1327000','0','1327000','1327000','input','2025-11-01 09:33:35','F32501093335');
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-01','F325010933352','2025-11-01','09:33:35','AAT','1327000','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-251101-0008','D','2025-11-01','09:33:35','input','PENJUALAN','F325010933352','496837000','1327000','498164000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1327000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325010933352' 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 ('F325010933353','input',' 1',' MDE2 X UB ','TOKO','PM-E','E2D-YJBC-96-0','CC X MODEL LISTEING MATA UB 10 8K ','','1.300','1','100.00','1261000','0','0','15000','1261000','0','0','0','1261000','AAT','00374414','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJBC-96-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.300',berat_jual_asli=berat_jual_asli+'1.300',stock_jual='1',berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='E2D-YJBC-96-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 ('F325010933353','2025-11-01','1.300','2025-11-01','09:33:35','PLG0025482','1261000','1261000','0','1261000','1261000','input','2025-11-01 09:33:35','F32501093335');
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-01','F325010933353','2025-11-01','09:33:35','AAT','1261000','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-251101-0009','D','2025-11-01','09:33:35','input','PENJUALAN','F325010933353','498164000','1261000','499425000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1261000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325010933353' 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 ('F325010953241','input','1',' MED2 5K CM','TOKO','PM-D','D2E-YIBB-127-0','LT MODEL HATI MATA VAR CM 8K ','','0.500','1','100.00','495000','0','0','15000','495000','0','5000','0','500000','SIN','00370175','D2E','0','0','-','0','990000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YIBB-127-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='D2E-YIBB-127-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325010953241','2025-11-01','0.500','2025-11-01','09:53:24','PLG0025483','495000','495000','5000','500000','500000','input','2025-11-01 09:53:24','F32501095324');
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-01','F325010953241','2025-11-01','09:53:24','SIN','500000','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-251101-0010','D','2025-11-01','09:53:24','input','PENJUALAN','F325010953241','499425000','500000','499925000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='500000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325010953241' 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 ('F325010953242','input',' 1',' MEH1 KH 42','TOKO','PM-H','H1E-YJAF-4-0','KL SANTA KH 42 8K ','','1.550','1','100.00','1534000','0','0','15000','1535000','0','0','0','1535000','SIN','00373321','H1E','0','0','-','0','990000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJAF-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='H1E-YJAF-4-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 ('F325010953242','2025-11-01','1.550','2025-11-01','09:53:24','PLG0025484','1535000','1535000','0','1535000','1535000','input','2025-11-01 09:53:24','F32501095324');
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-01','F325010953242','2025-11-01','09:53:24','SIN','1535000','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-251101-0011','D','2025-11-01','09:53:24','input','PENJUALAN','F325010953242','499925000','1535000','501460000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1535000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325010953242' 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 ('F325010959421','input','1',' MEA1E X BW','TOKO','PM-A','A1E-YGAA-46-0','AT X MODEL MATA VAR BW 8K ','','0.550','1','100.00','544000','0','0','15000','545000','0','0','0','545000','FIT','00360599','A1E','0','0','-','0','990000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YGAA-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='A1E-YGAA-46-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 ('F325010959421','2025-11-01','0.550','2025-11-01','09:59:42','PLG0025485','545000','545000','0','545000','545000','input','2025-11-01 09:59:42','F32501095942');
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-01','F325010959421','2025-11-01','09:59:42','FIT','545000','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-251101-0012','D','2025-11-01','09:59:42','input','PENJUALAN','F325010959421','501460000','545000','502005000');
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 ('F325011021251','input','1',' MEF1 TD D4','TOKO','PM-F','F1E-YDAE-18-0','GL ANAK BANGKOK MODEL C TD D42 8K ','','1.980','1','100.00','1960000','0','0','15000','1960000','0','0','0','1960000','SIN','00349487','F1E','0','0','-','0','990000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YDAE-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='F1E-YDAE-18-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 ('F325011021251','2025-11-01','1.980','2025-11-01','10:21:26','PLG0025486','1960000','1960000','0','1960000','1960000','input','2025-11-01 10:21:25','F32501102125');
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-01','F325011021251','2025-11-01','10:21:26','SIN','1960000','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-251101-0013','D','2025-11-01','10:21:26','input','PENJUALAN','F325011021251','502005000','1960000','503965000');
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 ('F325011100041','input','1',' MEA1 5K LG','TOKO','PM-A','A1E-YJAH-53-0','AT BONEKA ANAK MATA CAT LG 8K ','','0.510','1','100.00','505000','0','0','15000','505000','0','5000','0','510000','SIN','00373748','A1E','0','0','-','0','990000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJAH-53-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='A1E-YJAH-53-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 ('F325011100041','2025-11-01','0.510','2025-11-01','11:00:05','PLG0025487','505000','505000','5000','510000','510000','input','2025-11-01 11:00:04','F32501110004');
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-01','F325011100041','2025-11-01','11:00:05','SIN','510000','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-251101-0014','D','2025-11-01','11:00:05','input','PENJUALAN','F325011100041','503965000','510000','504475000');
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 ('F325011132361','input','1',' MEF3E UB ','TOKO','PM-F','F3E-YJAE-7-0','GL SANTA ARESO SERUT VAR UB 8K ','','2.010','1','100.00','1990000','0','0','15000','1990000','0','0','0','1990000','SIN','00373153','F3E','0','0','-','0','990000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJAE-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='F3E-YJAE-7-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 ('F325011132361','2025-11-01','2.010','2025-11-01','11:32:36','PLG0025488','1990000','1990000','0','1990000','1990000','input','2025-11-01 11:32:36','F32501113236');
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-01','F325011132361','2025-11-01','11:32:36','SIN','1990000','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-251101-0015','D','2025-11-01','11:32:36','input','PENJUALAN','F325011132361','504475000','1990000','506465000');
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 ('F325011229121','input','1',' MFB1 UB ','TOKO','PM-B','B1F-YIBB-126-0','GW MODEL TOGE HATI ARESO UB 8K ','','0.400','1','100.00','404000','0','0','15000','405000','0','0','0','405000','SIN','00370174','B1F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YIBB-126-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='B1F-YIBB-126-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 ('F325011229121','2025-11-01','0.400','2025-11-01','12:29:12','PLG0025489','405000','405000','0','405000','405000','input','2025-11-01 12:29:12','F32501122912');
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-01','F325011229121','2025-11-01','12:29:12','SIN','405000','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-251101-0016','D','2025-11-01','12:29:12','input','PENJUALAN','F325011229121','506465000','405000','506870000');
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 ('F325010126551','input','1',' MEF3E X HW','TOKO','PM-F','F3E-XAXE-285-0','GL X TIFF BONEKA ANAK CAT HW 8K ','','1.880','1','100.00','1861000','0','0','15000','1860000','0','0','0','1860000','SIN','00273246','F3E','0','0','-','1','990000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-XAXE-285-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.880',berat_jual_asli=berat_jual_asli+'1.880',stock_jual='1',berat_akhir=berat_akhir-'1.880',berat_akhir_asli=berat_akhir_asli-'1.880',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='F3E-XAXE-285-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 ('F325010126551','2025-11-01','1.880','2025-11-01','13:26:55','PLG0025490','1860000','1860000','0','1860000','1860000','input','2025-11-01 13:26:55','F32501012655');
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-01','F325010126551','2025-11-01','13:26:55','SIN','1860000','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-251101-0017','D','2025-11-01','13:26:55','input','PENJUALAN','F325010126551','506870000','1860000','508730000');
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-00017371','X-00017371','GL KREPYAK MODEL DAUN VAR LG 8K','GR','---','F3E','BELI','BELI001','4865000','2025-11-01','5.290','1','kasir','2025-11-01 13:53:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017371','X-00017371');
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-251101-0001','F325090129571','FIT','1','BELI','BELI001','F3E', 'X-00017371', 'GL KREPYAK MODEL DAUN VAR LG 8K','5.290','5.290','100.00','5315000','4865000','919660','990000','1','4865000','4865000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.290',berat_beli_asli=berat_beli_asli+'5.290',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.290',berat_akhir_asli=berat_akhir_asli+'5.290',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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-251101-0001','2025-11-01','2025-11-01','13:53:45','FIT','---','5.290','4865000','4865000','4865000','4865000','4865000','kasir','2025-11-01 13:53:45','FB-251101-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251101-0001','ENI','BULUKERTO','','','','kasir','2025-11-01 13:53:45');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-01' 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-251101-0018','K','2025-11-01','13:53:45','kasir','PEMBELIAN UMUM','FB-251101-0001','508730000','4865000','503865000');
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-00017372','X-00017372','AT X GYPSY MATA VAR ANAK LG 8K','GR','---','A1E','BELI','BELI001','425000','2025-11-01','0.550','1','kasir','2025-11-01 13:54:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00017372','X-00017372');
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-251101-0002','F325191004221','SIN','1','BELI','BELI001','A1E', 'X-00017372', 'AT X GYPSY MATA VAR ANAK LG 8K','0.550','0.550','100.00','458000','425000','772727','990000','1','425000','425000','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-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251101-0002','2025-11-01','2025-11-01','13:54:37','SIN','---','0.550','425000','425000','425000','425000','425000','kasir','2025-11-01 13:54:38','FB-251101-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251101-0002','VIOLA','WATU BONANG','','','','kasir','2025-11-01 13:54:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-01' 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-251101-0019','K','2025-11-01','13:54:37','kasir','PEMBELIAN UMUM','FB-251101-0002','503865000','425000','503440000');
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 ('F325010157381','kasir','1',' MFF3F X UB','TOKO','PM-F','F3F-YHBH-139-0','GL X JEDAR SLEP UB 8K ','','0.520','1','100.00','525000','0','0','15000','525000','0','0','0','525000','SIN','00367125','F3F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YHBH-139-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='F3F-YHBH-139-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 ('F325010157381','2025-11-01','0.520','2025-11-01','13:57:39','PLG0025491','525000','525000','0','525000','525000','kasir','2025-11-01 13:57:38','F32501015738');
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-01','F325010157381','2025-11-01','13:57:39','SIN','525000','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-251101-0020','D','2025-11-01','13:57:39','kasir','PENJUALAN','F325010157381','503440000','525000','503965000');
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-00017373','X-00017373','GL BANGKOK C ANAK SLEP TD 36 8K','GR','---','F1E','BELI','BELI001','1375000','2025-11-01','2.000','1','kasir','2025-11-01 14:00:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017373','X-00017373');
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-251101-0003','F325031058141','SIN','1','BELI','BELI001','F1E', 'X-00017373', 'GL BANGKOK C ANAK SLEP TD 36 8K','2.000','2.000','100.00','1620000','1375000','687500','990000','1','1375000','1375000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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-251101-0003','2025-11-01','2025-11-01','14:00:16','SIN','---','2.000','1375000','1375000','1375000','1375000','1375000','kasir','2025-11-01 14:00:17','FB-251101-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251101-0003','JENAIRA','JERUK','','','','kasir','2025-11-01 14:00:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-01' 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-251101-0021','K','2025-11-01','14:00:16','kasir','PEMBELIAN UMUM','FB-251101-0003','503965000','1375000','502590000');
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-00017374','X-00017374','CC X MODEL MATA BM 16 8K','GR','---','E2D','BELI','BELI001','837000','2025-11-01','1.100','1','kasir','2025-11-01 14:00:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017374','X-00017374');
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-251101-0004','F325261150261','FIT','1','BELI','BELI001','E2D', 'X-00017374', 'CC X MODEL MATA BM 16 8K','1.100','1.100','100.00','900000','837000','760909','980000','1','837000','837000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.100',berat_beli_asli=berat_beli_asli+'1.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.100',berat_akhir_asli=berat_akhir_asli+'1.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251101-0004','2025-11-01','2025-11-01','14:00:45','FIT','---','1.100','837000','837000','837000','837000','837000','kasir','2025-11-01 14:00:45','FB-251101-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251101-0004','DIAN','BITING PURWANTORO','','','','kasir','2025-11-01 14:00:45');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-01' 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-251101-0022','K','2025-11-01','14:00:45','kasir','PEMBELIAN UMUM','FB-251101-0004','502590000','837000','501753000');
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 ('F325010234151','input','1',' MEB1 5K LG','TOKO','PM-B','B1E-YJBC-267-0','GW MODEL BONEKA ANAK TAUGE CAT LG 8K ','','0.500','1','100.00','495000','0','0','15000','495000','0','5000','0','500000','AAT','00374585','B1E','0','0','-','0','990000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJBC-267-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='B1E-YJBC-267-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 ('F325010234151','2025-11-01','0.500','2025-11-01','14:34:15','PLG0025492','495000','495000','5000','500000','500000','input','2025-11-01 14:34:15','F32501023415');
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-01','F325010234151','2025-11-01','14:34:15','AAT','500000','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-251101-0023','D','2025-11-01','14:34:15','input','PENJUALAN','F325010234151','501753000','500000','502253000');
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 ('F325010258061','input','1',' MED1E X LG','TOKO','PM-D','D1E-YJBA-121-0','LT X MODEL CAT HITAM LG 8K ','','0.510','1','100.00','505000','0','0','15000','505000','0','5000','0','510000','SIN','00373998','D1E','0','0','-','0','990000');
UPDATE tm_barang SET tgl_last_jual='2025-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJBA-121-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2025-11-01' AND kode_barang='D1E-YJBA-121-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325010258061','2025-11-01','0.510','2025-11-01','14:58:07','PLG0025493','505000','505000','5000','510000','510000','input','2025-11-01 14:58:06','F32501025806');
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-01','F325010258061','2025-11-01','14:58:07','SIN','510000','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-251101-0024','D','2025-11-01','14:58:07','input','PENJUALAN','F325010258061','502253000','510000','502763000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325010126551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325010126551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325010126551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325010157381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325010157381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325010157381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325010234151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325010234151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325010234151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325010258061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325010258061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325010258061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325010858301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325010858301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325010858301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325010858302' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325010858302' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325010858302';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325010858581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325010858581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325010858581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325010902231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325010902231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325010902231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325010902451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325010902451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325010902451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325010933351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325010933351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325010933351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325010933352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325010933352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325010933352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325010933353' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325010933353' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325010933353';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325010953241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325010953241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325010953241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325010953242' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325010953242' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325010953242';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325010959421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325010959421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325010959421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325011021251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325011021251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325011021251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325011100041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325011100041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325011100041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325011132361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325011132361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325011132361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325011229121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325011229121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325011229121';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251101-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251101-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251101-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251101-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251101-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251101-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251101-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251101-0004';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-02','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-02';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-01';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-01';
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-01' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-01';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-01';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-01';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-01';
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-02' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-01' 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-251102-0001','D','2025-11-02','15:27:19','SYSTEM','SALDO AWAL','SALDO AWAL','0','502763000','502763000');
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-251102-0001','D','2025-11-02','15:27:19','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-251102-0001','D','2025-11-02','15:27:19','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-251102-0001','D','2025-11-02','15:27:19','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-11-02';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251102-0001','1','E2D-YHBI-65-0','1','2.030','2.030','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YHBI-65-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YHBI-65-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-11-02 16:48:32' WHERE kode_barang='E2D-YHBI-65-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YHBI-65-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-02 16:48:32','TOKO','PM-E','E2D','E2D-YHBI-65-0','1','2.030','2.030','1','2.030','2.030','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-YHBI-65-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YHBI-65-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-20251102-0001','1','E2D-YIBD-307-0','1','2.070','2.070','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YIBD-307-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YIBD-307-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-11-02 16:48:32' WHERE kode_barang='E2D-YIBD-307-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YIBD-307-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-02 16:48:32','TOKO','PM-E','E2D','E2D-YIBD-307-0','1','2.070','2.070','1','2.070','2.070','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-YIBD-307-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YIBD-307-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251102-0001','2025-11-02','16:48','4.100','admpindah','2025-11-01 16:48:32');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251102-0001','1','F1E-YKXA-124-0','1','3.050','3.050','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YKXA-124-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YKXA-124-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-11-02 16:48:47' WHERE kode_barang='F1E-YKXA-124-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YKXA-124-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-02 16:48:47','TOKO','PM-F','F1E','F1E-YKXA-124-0','1','3.050','3.050','1','3.050','3.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' 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='F1E-YKXA-124-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YKXA-124-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251102-0001','2025-11-02','16:48','3.050','admpindah','2025-11-01 16:48:46');