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 ('F325190825011','input','1',' MDE2 X YT ','TOKO','PM-E','E2D-YLAE-131-0','CC X MODEL MATA YT 18 8K ','','0.980','1','100.00','1016000','0','0','15000','1016000','0','0','0','1016000','SIN','00381109','E2D','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLAE-131-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='E2D-YLAE-131-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 ('F325190825011','2025-12-19','0.980','2025-12-19','08:25:02','PLG0026305','1016000','1016000','0','1016000','1016000','input','2025-12-19 08:25:01','F32519082501');
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-12-19','F325190825011','2025-12-19','08:25:02','SIN','1016000','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-251219-0002','D','2025-12-19','08:25:02','input','PENJUALAN','F325190825011','1344811000','1016000','1345827000');
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 ('F325190825401','input','1',' MDE1 PM 16','TOKO','PM-E','E1D-YLAE-200-0','CC MODEL DAUN SLEP PM 16 8K ','','0.970','1','100.00','1006000','0','0','15000','1007000','0','0','0','1007000','SIN','00381178','E1D','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YLAE-200-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-12-19' AND kode_barang='E1D-YLAE-200-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 ('F325190825401','2025-12-19','0.970','2025-12-19','08:25:41','PLG0026306','1007000','1007000','0','1007000','1007000','input','2025-12-19 08:25:40','F32519082540');
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-12-19','F325190825401','2025-12-19','08:25:41','SIN','1007000','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-251219-0003','D','2025-12-19','08:25:41','input','PENJUALAN','F325190825401','1345827000','1007000','1346834000');
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 ('F325190848331','input','1',' MEF3E XX H','TOKO','PM-F','F3E-YLAA-47-0','GL XX SANTA BUNGA CAT SERUT HW 8K','','1.970','1','100.00','2082000','0','0','15000','2023000','0','0','0','2023000','SIN','00380629','F3E','0','0','-','1','1067000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLAA-47-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='F3E-YLAA-47-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 ('F325190848331','2025-12-19','1.970','2025-12-19','08:48:34','PLG0026307','2023000','2023000','0','2023000','2023000','input','2025-12-19 08:48:33','F32519084833');
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-12-19','F325190848331','2025-12-19','08:48:34','SIN','2023000','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-251219-0004','D','2025-12-19','08:48:34','input','PENJUALAN','F325190848331','1346834000','2023000','1348857000');
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 ('F325190912341','input','1',' MGB1 CM ','TOKO','PM-B','B1G-YIBI-181-0','GW TOGE MODEL DAISY MATA CM 8K ','','0.320','1','100.00','351000','0','0','15000','350000','0','0','0','350000','SIN','00371052','B1G','0','0','-','1','1097000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-YIBI-181-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='B1G-YIBI-181-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 ('F325190912341','2025-12-19','0.320','2025-12-19','09:12:34','PLG0026308','350000','350000','0','350000','350000','input','2025-12-19 09:12:34','F32519091234');
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-12-19','F325190912341','2025-12-19','09:12:34','SIN','350000','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-251219-0005','D','2025-12-19','09:12:34','input','PENJUALAN','F325190912341','1348857000','350000','1349207000');
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 ('F325190940141','input','1',' MGPE 10K Y','TOKO','PM-P','PEG-XHCX-371-0','CC WG WEDDING MATA YT 16 8K ','','1.810','1','100.00','1986000','0','0','15000','1985000','0','10000','0','1995000','FIT','00314988','PEG','0','0','-','1','1097000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PEG-XHCX-371-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.810',berat_jual_asli=berat_jual_asli+'1.810',stock_jual='1',berat_akhir=berat_akhir-'1.810',berat_akhir_asli=berat_akhir_asli-'1.810',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='PEG-XHCX-371-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' 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 ('F325190940141','2025-12-19','1.810','2025-12-19','09:40:14','PLG0026309','1985000','1985000','10000','1995000','1995000','input','2025-12-19 09:40:14','F32519094014');
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-12-19','F325190940141','2025-12-19','09:40:14','FIT','1995000','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-251219-0006','D','2025-12-19','09:40:14','input','PENJUALAN','F325190940141','1349207000','1995000','1351202000');
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 ('F325190940341','input','1',' MFPF HW ','TOKO','PM-P','PFF-YKBI-158-0','GL WG HARLEY MODEL DAUN VAR HW 8K ','','1.590','1','100.00','1712000','0','0','15000','1712000','0','0','0','1712000','FIT','00379124','PFF','0','0','-','0','1087000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PFF-YKBI-158-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.590',berat_jual_asli=berat_jual_asli+'1.590',stock_jual='1',berat_akhir=berat_akhir-'1.590',berat_akhir_asli=berat_akhir_asli-'1.590',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='PFF-YKBI-158-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' 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 ('F325190940341','2025-12-19','1.590','2025-12-19','09:40:35','PLG0026310','1712000','1712000','0','1712000','1712000','input','2025-12-19 09:40:34','F32519094034');
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-12-19','F325190940341','2025-12-19','09:40:35','FIT','1712000','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-251219-0007','D','2025-12-19','09:40:35','input','PENJUALAN','F325190940341','1351202000','1712000','1352914000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190940341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190940341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190940341';
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 ('F325190946431','kasir','1',' MFPF HW ','TOKO','PM-P','PFF-YKBI-158-0','GL WG HARLEY MODEL DAUN VAR HW 8K ','','1.590','1','100.00','1712000','0','0','15000','1712000','0','0','0','1712000','FIT','00379124','PFF','0','0','-','0','1087000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PFF-YKBI-158-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.590',berat_jual_asli=berat_jual_asli+'1.590',stock_jual='1',berat_akhir=berat_akhir-'1.590',berat_akhir_asli=berat_akhir_asli-'1.590',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='PFF-YKBI-158-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' 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 ('F325190946431','2025-12-19','1.590','2025-12-19','09:46:44','PLG0026311','1712000','1712000','0','1712000','1712000','kasir','2025-12-19 09:46:43','F32519094643');
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-12-19','F325190946431','2025-12-19','09:46:44','FIT','1712000','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-251219-0009','D','2025-12-19','09:46:44','kasir','PENJUALAN','F325190946431','1351202000','1712000','1352914000');
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 ('F325190957281','kasir','1',' MEA1E X LG','TOKO','PM-A','A1E-YLAF-120-0','AT X MODEL MATA VAR LG 8K ','','0.550','1','100.00','581000','0','0','15000','580000','0','0','0','580000','SIN','00381304','A1E','0','0','-','1','1067000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLAF-120-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-12-19' AND kode_barang='A1E-YLAF-120-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 ('F325190957281','2025-12-19','0.550','2025-12-19','09:57:29','PLG0026312','580000','580000','0','580000','580000','kasir','2025-12-19 09:57:28','F32519095728');
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-12-19','F325190957281','2025-12-19','09:57:29','SIN','580000','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-251219-0010','D','2025-12-19','09:57:29','kasir','PENJUALAN','F325190957281','1352914000','580000','1353494000');
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 ('F325190958121','kasir','1',' MGF3G X UB','TOKO','PM-F','F3G-YKBB-210-0','GL X BORSALINO UB 8K ','','0.350','1','100.00','384000','0','0','15000','385000','0','0','0','385000','SIN','00378359','F3G','0','0','-','0','1097000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3G-YKBB-210-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='F3G-YKBB-210-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 ('F325190958121','2025-12-19','0.350','2025-12-19','09:58:12','PLG0026313','385000','385000','0','385000','385000','kasir','2025-12-19 09:58:12','F32519095812');
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-12-19','F325190958121','2025-12-19','09:58:12','SIN','385000','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-251219-0011','D','2025-12-19','09:58:12','kasir','PENJUALAN','F325190958121','1353494000','385000','1353879000');
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 ('F325191002421','kasir','1',' MGPFG KH ','TOKO','PM-P','PFG-XKXG-3-0','GL WG HOLLOW KELINTING VAR KH 8K ','','2.030','1','100.00','2227000','0','0','15000','2228000','0','0','0','2228000','FIT','00325253','PFG','0','0','-','0','1097000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PFG-XKXG-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='PFG-XKXG-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' 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 ('F325191002421','2025-12-19','2.030','2025-12-19','10:02:43','PLG0026314','2228000','2228000','0','2228000','2228000','kasir','2025-12-19 10:02:42','F32519100242');
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-12-19','F325191002421','2025-12-19','10:02:43','FIT','2228000','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-251219-0012','D','2025-12-19','10:02:43','kasir','PENJUALAN','F325191002421','1353879000','2228000','1356107000');
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 ('F325191009021','kasir','1',' MEE2 X CM ','TOKO','PM-E','E2E-YKAG-103-0','CC X MODEL MATA CM 16 8K ','','0.710','1','100.00','750000','0','0','15000','750000','0','0','0','750000','SIN','00377679','E2E','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YKAG-103-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.710',berat_jual_asli=berat_jual_asli+'0.710',stock_jual='1',berat_akhir=berat_akhir-'0.710',berat_akhir_asli=berat_akhir_asli-'0.710',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='E2E-YKAG-103-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 ('F325191009021','2025-12-19','0.710','2025-12-19','10:09:02','PLG0026315','750000','750000','0','750000','750000','kasir','2025-12-19 10:09:02','F32519100902');
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-12-19','F325191009021','2025-12-19','10:09:02','SIN','750000','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-251219-0013','D','2025-12-19','10:09:02','kasir','PENJUALAN','F325191009021','1356107000','750000','1356857000');
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 ('F325191027421','kasir','1',' MEE2 X LG ','TOKO','PM-E','E2E-YKBD-246-0','CC X MODEL MATA LG 10 8K ','','0.470','1','100.00','497000','0','0','15000','498000','0','0','0','498000','AAT','00378655','E2E','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YKBD-246-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='E2E-YKBD-246-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 ('F325191027421','2025-12-19','0.470','2025-12-19','10:27:42','PLG0026316','498000','498000','0','498000','498000','kasir','2025-12-19 10:27:42','F32519102742');
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-12-19','F325191027421','2025-12-19','10:27:42','AAT','498000','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-251219-0014','D','2025-12-19','10:27:42','kasir','PENJUALAN','F325191027421','1356857000','498000','1357355000');
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 ('F325191120551','kasir','1',' MDE2 X 10K','TOKO','PM-E','E2D-YKAD-32-0','CC X WEDDING MATA CM 14 8K ','','1.500','1','100.00','1555000','0','0','15000','1555000','0','10000','0','1565000','FIT','00377370','E2D','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YKAD-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='E2D-YKAD-32-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 ('F325191120551','2025-12-19','1.500','2025-12-19','11:20:56','PLG0026317','1555000','1555000','10000','1565000','1565000','kasir','2025-12-19 11:20:55','F32519112055');
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-12-19','F325191120551','2025-12-19','11:20:56','FIT','1565000','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-251219-0015','D','2025-12-19','11:20:56','kasir','PENJUALAN','F325191120551','1357355000','1565000','1358920000');
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 ('F325191152511','kasir','1',' MEF1 UB 54','TOKO','PM-F','F1E-YJAE-10-0','GL OVAL PAKU SLEP UB 54 8K ','','4.870','1','100.00','5148000','0','0','15000','5148000','0','0','0','5148000','SIN','00373156','F1E','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YJAE-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.870',berat_jual_asli=berat_jual_asli+'4.870',stock_jual='1',berat_akhir=berat_akhir-'4.870',berat_akhir_asli=berat_akhir_asli-'4.870',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='F1E-YJAE-10-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 ('F325191152511','2025-12-19','4.870','2025-12-19','11:52:51','PLG0026318','5148000','5148000','0','5148000','5148000','kasir','2025-12-19 11:52:51','F32519115251');
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-12-19','F325191152511','2025-12-19','11:52:51','SIN','5148000','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-251219-0016','D','2025-12-19','11:52:51','kasir','PENJUALAN','F325191152511','1358920000','5148000','1364068000');
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 ('F325191207111','kasir','1',' TFF3 X HW ','TOKO','PT-F','F3TF-XBBF-65-T','GL X PREMIER ARESO VAR HW ','','3.850','1','100.00','7496000','0','0','15000','7400000','0','0','0','7400000','FIT','T0054364','F3TF','0','0','-','1','1947000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TF-XBBF-65-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.850',berat_jual_asli=berat_jual_asli+'3.850',stock_jual='1',berat_akhir=berat_akhir-'3.850',berat_akhir_asli=berat_akhir_asli-'3.850',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='F3TF-XBBF-65-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F325191207111','2025-12-19','3.850','2025-12-19','12:07:12','PLG0026319','7400000','7400000','0','7400000','7400000','kasir','2025-12-19 12:07:11','F32519120711');
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-12-19','F325191207111','2025-12-19','12:07:12','FIT','7400000','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-251219-0017','D','2025-12-19','12:07:12','kasir','PENJUALAN','F325191207111','1364068000','7400000','1371468000');
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 ('F325191207541','kasir','1',' TEF3 XX HW','TOKO','PT-F','F3TE-XDAB-40-T','GL XX MODEL CAPELA VAR HW 17K ','','3.120','1','100.00','6012000','0','0','15000','5995000','0','0','0','5995000','FIT','T0056310','F3TE','0','0','-','1','1927000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-XDAB-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.120',berat_jual_asli=berat_jual_asli+'3.120',stock_jual='1',berat_akhir=berat_akhir-'3.120',berat_akhir_asli=berat_akhir_asli-'3.120',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='F3TE-XDAB-40-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F325191207541','2025-12-19','3.120','2025-12-19','12:07:54','PLG0026320','5995000','5995000','0','5995000','5995000','kasir','2025-12-19 12:07:54','F32519120754');
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-12-19','F325191207541','2025-12-19','12:07:54','FIT','5995000','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-251219-0018','D','2025-12-19','12:07:54','kasir','PENJUALAN','F325191207541','1371468000','5995000','1377463000');
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 ('F325191209161','kasir','1',' MDE1 PM 12','TOKO','PM-E','E1D-YLAA-136-0','CC MODEL VERONA PM 12 8K ','','0.910','1','100.00','944000','0','0','15000','945000','0','0','0','945000','SIN','00380718','E1D','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YLAA-136-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='E1D-YLAA-136-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 ('F325191209161','2025-12-19','0.910','2025-12-19','12:09:17','PLG0026321','945000','945000','0','945000','945000','kasir','2025-12-19 12:09:16','F32519120916');
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-12-19','F325191209161','2025-12-19','12:09:17','SIN','945000','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-251219-0019','D','2025-12-19','12:09:17','kasir','PENJUALAN','F325191209161','1377463000','945000','1378408000');
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 ('F325191209501','kasir','1',' MEE2 X SB ','TOKO','PM-E','E2E-YLXH-77-0','CC X SOLITAIRE MATA SB 10 8K ','','0.730','1','100.00','772000','0','0','15000','773000','0','0','0','773000','SIN','00380199','E2E','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YLXH-77-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='E2E-YLXH-77-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 ('F325191209501','2025-12-19','0.730','2025-12-19','12:09:51','PLG0026322','773000','773000','0','773000','773000','kasir','2025-12-19 12:09:50','F32519120950');
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-12-19','F325191209501','2025-12-19','12:09:51','SIN','773000','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-251219-0020','D','2025-12-19','12:09:51','kasir','PENJUALAN','F325191209501','1378408000','773000','1379181000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191207111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191207111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191207111';
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 ('F325191214361','kasir','1',' TFF3 X HW ','TOKO','PT-F','F3TF-XBBF-65-T','GL X PREMIER ARESO VAR HW ','','3.850','1','100.00','7496000','0','0','15000','7475000','0','0','0','7475000','FIT','T0054364','F3TF','0','0','-','1','1947000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TF-XBBF-65-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.850',berat_jual_asli=berat_jual_asli+'3.850',stock_jual='1',berat_akhir=berat_akhir-'3.850',berat_akhir_asli=berat_akhir_asli-'3.850',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='F3TF-XBBF-65-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F325191214361','2025-12-19','3.850','2025-12-19','12:14:37','PLG0026323','7475000','7475000','0','7475000','7475000','kasir','2025-12-19 12:14:36','F32519121436');
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-12-19','F325191214361','2025-12-19','12:14:37','FIT','7475000','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-251219-0022','D','2025-12-19','12:14:37','kasir','PENJUALAN','F325191214361','1371781000','7475000','1379256000');
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 ('F325191253241','kasir','1',' TGB1 X CM ','TOKO','PT-B','B1TG-YJBH-65-T','GW X TUSUK MRICAN POLOS CM 17K ','','0.300','1','100.00','590000','0','0','15000','590000','0','0','0','590000','SIN','T0074547','B1TG','0','0','-','0','1967000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TG-YJBH-65-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='B1TG-YJBH-65-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F325191253241','2025-12-19','0.300','2025-12-19','12:53:25','PLG0026324','590000','590000','0','590000','590000','kasir','2025-12-19 12:53:24','F32519125324');
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-12-19','F325191253241','2025-12-19','12:53:25','SIN','590000','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-251219-0023','D','2025-12-19','12:53:25','kasir','PENJUALAN','F325191253241','1379256000','590000','1379846000');
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 ('F325191254111','kasir','1',' TEB1 7K LG','TOKO','PT-B','B1TE-XGXI-182-T','GW TUSUK MODEL MATA VAR LG PE 17K ','','1.240','1','100.00','2390000','0','0','15000','2390000','0','7000','0','2397000','SIN','T0059280','B1TE','0','0','-','0','1927000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TE-XGXI-182-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.240',berat_jual_asli=berat_jual_asli+'1.240',stock_jual='1',berat_akhir=berat_akhir-'1.240',berat_akhir_asli=berat_akhir_asli-'1.240',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='B1TE-XGXI-182-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F325191254111','2025-12-19','1.240','2025-12-19','12:54:12','PLG0026325','2390000','2390000','7000','2397000','2397000','kasir','2025-12-19 12:54:11','F32519125411');
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-12-19','F325191254111','2025-12-19','12:54:12','SIN','2397000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251219-0024','D','2025-12-19','12:54:12','kasir','PENJUALAN','F325191254111','1379846000','2397000','1382243000');
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 ('F325191254571','kasir','1',' TDE1 X UB ','TOKO','PT-E','E1TD-YLAC-29-T','CC X COR VELG MODEL C UB 17K ','','2.800','1','100.00','5340000','0','0','15000','5340000','0','0','0','5340000','SIN','T0075764','E1TD','0','0','-','0','1907000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YLAC-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.800',berat_jual_asli=berat_jual_asli+'2.800',stock_jual='1',berat_akhir=berat_akhir-'2.800',berat_akhir_asli=berat_akhir_asli-'2.800',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='E1TD-YLAC-29-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F325191254571','2025-12-19','2.800','2025-12-19','12:54:57','PLG0026326','5340000','5340000','0','5340000','5340000','kasir','2025-12-19 12:54:57','F32519125457');
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-12-19','F325191254571','2025-12-19','12:54:57','SIN','5340000','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-251219-0025','D','2025-12-19','12:54:57','kasir','PENJUALAN','F325191254571','1382243000','5340000','1387583000');
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 ('F325190107161','kasir','1',' MKPH X UB ','TOKO','PM-P','PHK-YCBH-25-T','KL X WG SANTA PANJANG UB 56CM 9K ','','3.890','1','100.00','4579000','0','0','15000','4580000','0','0','0','4580000','SIN','T0068371','PHK','0','0','-','0','1177000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PHK-YCBH-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.890',berat_jual_asli=berat_jual_asli+'3.890',stock_jual='1',berat_akhir=berat_akhir-'3.890',berat_akhir_asli=berat_akhir_asli-'3.890',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='PHK-YCBH-25-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' 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 ('F325190107161','2025-12-19','3.890','2025-12-19','13:07:16','PLG0026327','4580000','4580000','0','4580000','4580000','kasir','2025-12-19 13:07:16','F32519010716');
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-12-19','F325190107161','2025-12-19','13:07:16','SIN','4580000','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-251219-0026','D','2025-12-19','13:07:16','kasir','PENJUALAN','F325190107161','1387583000','4580000','1392163000');
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-00017717','X-00017717','GW X MODEL RIBBON SLEP LG PE 8K','GR','---','B1E','BELI','BELI001','445000','2025-12-19','0.470','1','kasir','2025-12-19 13:12:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00017717','X-00017717');
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-251219-0001','F325280212391','FIT','1','BELI','BELI001','B1E', 'X-00017717', 'GW X MODEL RIBBON SLEP LG PE 8K','0.470','0.470','100.00','480000','445000','946809','1067000','1','445000','445000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.470',berat_beli_asli=berat_beli_asli+'0.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.470',berat_akhir_asli=berat_akhir_asli+'0.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251219-0001','2025-12-19','2025-12-19','13:12:54','FIT','---','0.470','445000','445000','445000','445000','445000','kasir','2025-12-19 13:12:54','FB-251219-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251219-0001','ANGGI','KEPUH','','','085328708712','kasir','2025-12-19 13:12:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-19' 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-251219-0027','K','2025-12-19','13:12:54','kasir','PEMBELIAN UMUM','FB-251219-0001','1392163000','445000','1391718000');
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-00017718','X-00017718','AT COR 8K','GR','---','A1F','BELI','BELI001','715000','2025-12-19','1.000','1','kasir','2025-12-19 13:14:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00017718','X-00017718');
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-251219-0002','F323300848101','SIN','1','BELI','BELI001','A1F', 'X-00017718', 'AT COR 8K','1.000','1.000','100.00','457000','715000','715000','1087000','1','715000','715000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251219-0002','2025-12-19','2025-12-19','13:14:34','SIN','---','1.000','715000','715000','715000','715000','715000','kasir','2025-12-19 13:14:35','FB-251219-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251219-0002','NARMI','SANGGRONG','','','','kasir','2025-12-19 13:14:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-19' 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-251219-0028','K','2025-12-19','13:14:34','kasir','PEMBELIAN UMUM','FB-251219-0002','1391718000','715000','1391003000');
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-00017719','X-00017719','CC X MODEL MATA LG 12 8K','GR','---','E2E','BELI','BELI001','392000','2025-12-19','0.480','1','kasir','2025-12-19 13:14:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017719','X-00017719');
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-251219-0003','F325261051301','SIN','1','BELI','BELI001','E2E', 'X-00017719', 'CC X MODEL MATA LG 12 8K','0.480','0.480','100.00','418000','392000','816667','1067000','1','392000','392000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.480',berat_beli_asli=berat_beli_asli+'0.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.480',berat_akhir_asli=berat_akhir_asli+'0.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-251219-0003','2025-12-19','2025-12-19','13:14:55','SIN','---','0.480','392000','392000','392000','392000','392000','kasir','2025-12-19 13:14:55','FB-251219-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251219-0003','MELATI','SANGGRONG','','','','kasir','2025-12-19 13:14:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-19' 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-251219-0029','K','2025-12-19','13:14:55','kasir','PEMBELIAN UMUM','FB-251219-0003','1391003000','392000','1390611000');
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-00017720','X-00017720','CC SOLITAIRE MATA LG 10 8K','GR','---','E2E','BELI','BELI001','390000','2025-12-19','0.500','1','kasir','2025-12-19 13:15:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017720','X-00017720');
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-251219-0004','F325180935351','AAT','1','BELI','BELI001','E2E', 'X-00017720', 'CC SOLITAIRE MATA LG 10 8K','0.500','0.500','100.00','420000','390000','780000','1067000','1','390000','390000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-251219-0004','2025-12-19','2025-12-19','13:15:48','AAT','---','0.500','390000','390000','390000','390000','390000','kasir','2025-12-19 13:15:48','FB-251219-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251219-0004','EVA','PAGERSARI','','','','kasir','2025-12-19 13:15:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-19' 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-251219-0030','K','2025-12-19','13:15:48','kasir','PEMBELIAN UMUM','FB-251219-0004','1390611000','390000','1390221000');
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-00017721','X-00017721','GL TRIXIE SERUT MODEL SPECTRA VAR UB 8K','GR','---','F3E','BELI','BELI001','1347000','2025-12-19','2.070','1','kasir','2025-12-19 13:16:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017721','X-00017721');
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-251219-0005','F324251121332','FIT','1','BELI','BELI001','F3E', 'X-00017721', 'GL TRIXIE SERUT MODEL SPECTRA VAR UB 8K','2.070','2.070','100.00','1377000','1347000','650725','1067000','1','1347000','1347000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.070',berat_beli_asli=berat_beli_asli+'2.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.070',berat_akhir_asli=berat_akhir_asli+'2.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-19' 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-251219-0005','2025-12-19','2025-12-19','13:16:17','FIT','---','2.070','1347000','1347000','1347000','1347000','1347000','kasir','2025-12-19 13:16:18','FB-251219-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251219-0005','SHAKILA','BULUKERTO','','','082227159436','kasir','2025-12-19 13:16:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-19' 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-251219-0031','K','2025-12-19','13:16:17','kasir','PEMBELIAN UMUM','FB-251219-0005','1390221000','1347000','1388874000');
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 ('F325190135501','kasir','1',' MDB1D CM ','TOKO','PM-B','B1D-YKBB-232-0','GW PANJANG DAUN SLEP CM 8K','','1.100','1','100.00','1141000','0','0','15000','1140000','0','0','0','1140000','SIN','00378381','B1D','0','0','-','1','1047000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-YKBB-232-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='B1D-YKBB-232-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 ('F325190135501','2025-12-19','1.100','2025-12-19','13:35:51','PLG0026328','1140000','1140000','0','1140000','1140000','kasir','2025-12-19 13:35:50','F32519013550');
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-12-19','F325190135501','2025-12-19','13:35:51','SIN','1140000','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-251219-0032','D','2025-12-19','13:35:51','kasir','PENJUALAN','F325190135501','1388874000','1140000','1390014000');
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 ('F325190154451','kasir','1',' MEA1E X CM','TOKO','PM-A','A1E-YLXC-60-0','AT X MODEL ARESO SLEP MATA VAR CM 8K ','','0.690','1','100.00','729000','0','0','15000','730000','0','0','0','730000','SIN','00379376','A1E','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLXC-60-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.690',berat_jual_asli=berat_jual_asli+'0.690',stock_jual='1',berat_akhir=berat_akhir-'0.690',berat_akhir_asli=berat_akhir_asli-'0.690',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='A1E-YLXC-60-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 ('F325190154451','2025-12-19','0.690','2025-12-19','13:54:46','PLG0026329','730000','730000','0','730000','730000','kasir','2025-12-19 13:54:45','F32519015445');
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-12-19','F325190154451','2025-12-19','13:54:46','SIN','730000','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-251219-0033','D','2025-12-19','13:54:46','kasir','PENJUALAN','F325190154451','1390014000','730000','1390744000');
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 ('F325190155331','kasir','1',' MEB1E HW ','TOKO','PM-B','B1E-YKBB-228-0','GW TIFF HATI SLEP HW 8K ','','0.560','1','100.00','592000','0','0','15000','593000','0','0','0','593000','FIT','00378377','B1E','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YKBB-228-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='B1E-YKBB-228-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 ('F325190155331','2025-12-19','0.560','2025-12-19','13:55:34','PLG0026330','593000','593000','0','593000','593000','kasir','2025-12-19 13:55:33','F32519015533');
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-12-19','F325190155331','2025-12-19','13:55:34','FIT','593000','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-251219-0034','D','2025-12-19','13:55:34','kasir','PENJUALAN','F325190155331','1390744000','593000','1391337000');
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 ('F325190202011','input','1',' MEF3E UB ','TOKO','PM-F','F3E-YLXE-141-0','GL LONG LING UB 8K ','','0.950','1','100.00','1004000','0','0','15000','1005000','0','0','0','1005000','AAT','00379811','F3E','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLXE-141-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='F3E-YLXE-141-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 ('F325190202011','2025-12-19','0.950','2025-12-19','14:02:02','PLG0026331','1005000','1005000','0','1005000','1005000','input','2025-12-19 14:02:01','F32519020201');
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-12-19','F325190202011','2025-12-19','14:02:02','AAT','1005000','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-251219-0035','D','2025-12-19','14:02:02','input','PENJUALAN','F325190202011','1391337000','1005000','1392342000');
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 ('F325190229491','input','1',' MDA1D X LG','TOKO','PM-A','A1D-YJBA-89-0','AT X MODEL CAT MATA LG 8K ','','1.050','1','100.00','1089000','0','0','15000','1090000','0','5000','0','1095000','SIN','00373966','A1D','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YJBA-89-0' 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-12-19' AND kode_barang='A1D-YJBA-89-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 ('F325190229491','2025-12-19','1.050','2025-12-19','14:29:50','PLG0026332','1090000','1090000','5000','1095000','1095000','input','2025-12-19 14:29:49','F32519022949');
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-12-19','F325190229491','2025-12-19','14:29:50','SIN','1095000','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-251219-0036','D','2025-12-19','14:29:50','input','PENJUALAN','F325190229491','1392342000','1095000','1393437000');
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 ('F325190234071','input','1',' MEF3E HW ','TOKO','PM-F','F3E-YLXC-8-0','GL TIFF ARESO VAR HW 8K ','','1.760','1','100.00','1860000','0','0','15000','1860000','0','0','0','1860000','AAT','00379324','F3E','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLXC-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.760',berat_jual_asli=berat_jual_asli+'1.760',stock_jual='1',berat_akhir=berat_akhir-'1.760',berat_akhir_asli=berat_akhir_asli-'1.760',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='F3E-YLXC-8-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 ('F325190234071','2025-12-19','1.760','2025-12-19','14:34:08','PLG0026333','1860000','1860000','0','1860000','1860000','input','2025-12-19 14:34:07','F32519023407');
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-12-19','F325190234071','2025-12-19','14:34:08','AAT','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-251219-0037','D','2025-12-19','14:34:08','input','PENJUALAN','F325190234071','1393437000','1860000','1395297000');
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 ('F325190234411','input','1',' MJH2 X UB ','TOKO','PM-H','H2J-YKBD-98-0','KL X GUCCI UB 40 9K ','','1.910','1','100.00','2210000','0','0','15000','2210000','0','0','0','2210000','AAT','00378507','H2J','0','0','-','0','1167000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YKBD-98-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.910',berat_jual_asli=berat_jual_asli+'1.910',stock_jual='1',berat_akhir=berat_akhir-'1.910',berat_akhir_asli=berat_akhir_asli-'1.910',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='H2J-YKBD-98-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 ('F325190234411','2025-12-19','1.910','2025-12-19','14:34:42','PLG0026334','2210000','2210000','0','2210000','2210000','input','2025-12-19 14:34:41','F32519023441');
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-12-19','F325190234411','2025-12-19','14:34:42','AAT','2210000','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-251219-0038','D','2025-12-19','14:34:42','input','PENJUALAN','F325190234411','1395297000','2210000','1397507000');
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 ('F325190238291','input','1',' MEA1E HW ','TOKO','PM-A','A1E-YLAB-280-0','AT MODEL DAUN VAR HW 8K ','','0.680','1','100.00','719000','0','0','15000','720000','0','0','0','720000','SIN','00380824','A1E','0','0','-','0','1067000');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLAB-280-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='A1E-YLAB-280-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 ('F325190238291','2025-12-19','0.680','2025-12-19','14:38:30','PLG0026335','720000','720000','0','720000','720000','input','2025-12-19 14:38:29','F32519023829');
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-12-19','F325190238291','2025-12-19','14:38:30','SIN','720000','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-251219-0039','D','2025-12-19','14:38:30','input','PENJUALAN','F325190238291','1397507000','720000','1398227000');
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-00017722','X-00017722','GW COR 17K','GR','---','B1TE','BELI','BELI001','735000','2025-12-19','0.560','1','kasir','2025-12-19 14:59:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1TE','X-00017722','X-00017722');
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-251219-0006','F323130855581','FIT','1','BELI','BELI001','B1TE', 'X-00017722', 'GW COR 17K','0.670','0.560','100.00','523000','735000','1312500','1927000','1','735000','735000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.560',berat_beli_asli=berat_beli_asli+'0.560',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.560',berat_akhir_asli=berat_akhir_asli+'0.560',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1TE' 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-251219-0006','2025-12-19','2025-12-19','14:59:30','FIT','---','0.560','735000','735000','735000','735000','735000','kasir','2025-12-19 14:59:31','FB-251219-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251219-0006','RISHA','SLOGOHIMO','','','','kasir','2025-12-19 14:59:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-19' 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-251219-0040','K','2025-12-19','14:59:30','kasir','PEMBELIAN UMUM','FB-251219-0006','1398227000','735000','1397492000');
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-00017723','X-00017723','LT MODEL PITA MATA VAR CM 8K','GR','---','D2E','BELI','BELI001','532000','2025-12-19','0.680','1','kasir','2025-12-19 15:01:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00017723','X-00017723');
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-251219-0007','F325050213031','SIN','1','BELI','BELI001','D2E', 'X-00017723', 'LT MODEL PITA MATA VAR CM 8K','0.680','0.680','100.00','573000','532000','782353','1067000','1','532000','532000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.680',berat_beli_asli=berat_beli_asli+'0.680',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.680',berat_akhir_asli=berat_akhir_asli+'0.680',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' 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-251219-0007','2025-12-19','2025-12-19','15:01:09','SIN','---','0.680','532000','532000','532000','532000','532000','kasir','2025-12-19 15:01:10','FB-251219-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251219-0007','KHALIFAH','SIGERENG BITING','','','','kasir','2025-12-19 15:01:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-19' 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-251219-0041','K','2025-12-19','15:01:09','kasir','PEMBELIAN UMUM','FB-251219-0007','1397492000','532000','1396960000');
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-00017724','X-00017724','GL X OVAL C SLEP UB 56 8K','GR','---','F1E','BELI','BELI001','2000000','2025-12-19','2.290','1','kasir','2025-12-19 15:01:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017724','X-00017724');
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-251219-0008','F325110939282','AAT','1','BELI','BELI001','F1E', 'X-00017724', 'GL X OVAL C SLEP UB 56 8K','2.290','2.290','100.00','2301000','2000000','873362','1067000','1','2000000','2000000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.290',berat_beli_asli=berat_beli_asli+'2.290',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.290',berat_akhir_asli=berat_akhir_asli+'2.290',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-19' 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-251219-0008','2025-12-19','2025-12-19','15:01:40','AAT','---','2.290','2000000','2000000','2000000','2000000','2000000','kasir','2025-12-19 15:01:40','FB-251219-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251219-0008','NURHAYATI','JERUK PACITAN','','','','kasir','2025-12-19 15:01:40');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-19' 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-251219-0042','K','2025-12-19','15:01:40','kasir','PEMBELIAN UMUM','FB-251219-0008','1396960000','2000000','1394960000');
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-00017725','X-00017725','GL OVAL MODEL C YT D56 8K','GR','---','F1E','BELI','BELI001','2220000','2025-12-19','2.400','1','kasir','2025-12-19 15:02:22');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017725','X-00017725');
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-251219-0009','F325110939281','AAT','1','BELI','BELI001','F1E', 'X-00017725', 'GL OVAL MODEL C YT D56 8K','2.400','2.400','100.00','2412000','2220000','925000','1067000','1','2220000','2220000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.400',berat_beli_asli=berat_beli_asli+'2.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.400',berat_akhir_asli=berat_akhir_asli+'2.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-19' 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-251219-0009','2025-12-19','2025-12-19','15:02:22','AAT','---','2.400','2220000','2220000','2220000','2220000','2220000','kasir','2025-12-19 15:02:22','FB-251219-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251219-0009','NURHAYATI','JERUK PACITAN','','','','kasir','2025-12-19 15:02:22');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-19' 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-251219-0043','K','2025-12-19','15:02:22','kasir','PEMBELIAN UMUM','FB-251219-0009','1394960000','2220000','1392740000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251219-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251219-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251219-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251219-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251219-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251219-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251219-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251219-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251219-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251219-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251219-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251219-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251219-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251219-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251219-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251219-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251219-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251219-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190107161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190107161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190107161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190135501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190135501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190135501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190154451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190154451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190154451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190155331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190155331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190155331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190202011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190202011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190202011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190229491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190229491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190229491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190234071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190234071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190234071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190234411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190234411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190234411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190238291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190238291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190238291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190825011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190825011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190825011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190825401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190825401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190825401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190848331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190848331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190848331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190912341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190912341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190912341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190940141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190940141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190940141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190946431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190946431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190946431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190957281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190957281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190957281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190958121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190958121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190958121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191002421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191002421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191002421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191009021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191009021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191009021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191027421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191027421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191027421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191120551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191120551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191120551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191152511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191152511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191152511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191207541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191207541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191207541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191209161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191209161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191209161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191209501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191209501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191209501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191214361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191214361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191214361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191253241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191253241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191253241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191254111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191254111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191254111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191254571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191254571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191254571';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-20','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-19';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-19';
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-12-19' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-19';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-19';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-19';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-19';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-20' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-19' 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-251220-0001','D','2025-12-20','15:58:03','SYSTEM','SALDO AWAL','SALDO AWAL','0','1392740000','1392740000');
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-251220-0001','D','2025-12-20','15:58:03','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-251220-0001','D','2025-12-20','15:58:03','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-251220-0001','D','2025-12-20','15:58:03','BCA','SALDO AWAL','SALDO AWAL','0','705914000','705914000');
UPDATE tp_system SET tgl_system='2025-12-20';
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-20251220-0001','1','E1E-YLAI-1-T','1','0.930','0.930','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YLAI-1-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YLAI-1-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-20 17:03:47' WHERE kode_barang='E1E-YLAI-1-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YLAI-1-T' 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-12-20 17:03:47','TOKO','PM-E','E1E','E1E-YLAI-1-T','1','0.930','0.930','1','0.930','0.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-YLAI-1-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YLAI-1-T';
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-20251220-0001','1','E1E-YLAI-2-T','1','1.000','1.000','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YLAI-2-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YLAI-2-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-20 17:03:47' WHERE kode_barang='E1E-YLAI-2-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YLAI-2-T' 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-12-20 17:03:47','TOKO','PM-E','E1E','E1E-YLAI-2-T','1','1.000','1.000','1','1.000','1.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-YLAI-2-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YLAI-2-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251220-0001','2025-12-20','17:03','1.930','admpindah','2025-12-19 17:03:46');
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-20251220-0001','1','F3E-YLAI-3-T','1','1.760','1.760','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YLAI-3-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YLAI-3-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-20 17:04:04' WHERE kode_barang='F3E-YLAI-3-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YLAI-3-T' 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-12-20 17:04:04','TOKO','PM-F','F3E','F3E-YLAI-3-T','1','1.760','1.760','1','1.760','1.760','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-YLAI-3-T';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YLAI-3-T';
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-20251220-0001','1','F3E-YLAI-4-T','1','1.880','1.880','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YLAI-4-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YLAI-4-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-20 17:04:04' WHERE kode_barang='F3E-YLAI-4-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YLAI-4-T' 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-12-20 17:04:04','TOKO','PM-F','F3E','F3E-YLAI-4-T','1','1.880','1.880','1','1.880','1.880','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-YLAI-4-T';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YLAI-4-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251220-0001','2025-12-20','17:03','3.640','admpindah','2025-12-19 17:04:03');
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-20251220-0001','1','H1E-YLAI-5-T','1','1.790','1.790','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YLAI-5-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YLAI-5-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-12-20 17:04:20' WHERE kode_barang='H1E-YLAI-5-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YLAI-5-T' 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-12-20 17:04:20','TOKO','PM-H','H1E','H1E-YLAI-5-T','1','1.790','1.790','1','1.790','1.790','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YLAI-5-T';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YLAI-5-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251220-0001','2025-12-20','17:04','1.790','admpindah','2025-12-19 17:04:19');
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-20251220-0001','1','A1E-YJXB-283-0','1','0.450','0.450','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YJXB-283-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YJXB-283-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-12-20 17:23:53' WHERE kode_barang='A1E-YJXB-283-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YJXB-283-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-12-20 17:23:53','TOKO','PM-A','A1E','A1E-YJXB-283-0','1','0.450','0.450','1','0.450','0.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-YJXB-283-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YJXB-283-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-20251220-0001','1','A1E-YKXA-84-0','1','0.530','0.530','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YKXA-84-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YKXA-84-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-12-20 17:23:53' WHERE kode_barang='A1E-YKXA-84-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YKXA-84-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-20 17:23:53','TOKO','PM-A','A1E','A1E-YKXA-84-0','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-YKXA-84-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YKXA-84-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251220-0001','1','A1D-YKAG-32-0','1','1.150','1.150','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YKAG-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YKAG-32-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-12-20 17:23:53' WHERE kode_barang='A1D-YKAG-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YKAG-32-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-12-20 17:23:53','TOKO','PM-A','A1D','A1D-YKAG-32-0','1','1.150','1.150','1','1.150','1.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' 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='A1D-YKAG-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YKAG-32-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-20251220-0001','1','A1E-YKBD-242-0','1','0.570','0.570','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YKBD-242-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YKBD-242-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-12-20 17:23:53' WHERE kode_barang='A1E-YKBD-242-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YKBD-242-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-12-20 17:23:53','TOKO','PM-A','A1E','A1E-YKBD-242-0','1','0.570','0.570','1','0.570','0.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-YKBD-242-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YKBD-242-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-20251220-0001','1','A1D-YLXC-55-0','1','1.030','1.030','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YLXC-55-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YLXC-55-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-12-20 17:23:53' WHERE kode_barang='A1D-YLXC-55-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YLXC-55-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-12-20 17:23:53','TOKO','PM-A','A1D','A1D-YLXC-55-0','1','1.030','1.030','1','1.030','1.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' 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='A1D-YLXC-55-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YLXC-55-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-20251220-0001','1','A1E-YLAF-121-0','1','0.450','0.450','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YLAF-121-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YLAF-121-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-12-20 17:23:53' WHERE kode_barang='A1E-YLAF-121-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YLAF-121-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-12-20 17:23:53','TOKO','PM-A','A1E','A1E-YLAF-121-0','1','0.450','0.450','1','0.450','0.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-YLAF-121-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YLAF-121-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-20251220-0001','1','A1D-YLAF-133-0','1','1.050','1.050','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YLAF-133-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YLAF-133-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-12-20 17:23:53' WHERE kode_barang='A1D-YLAF-133-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YLAF-133-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-12-20 17:23:53','TOKO','PM-A','A1D','A1D-YLAF-133-0','1','1.050','1.050','1','1.050','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' 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='A1D-YLAF-133-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YLAF-133-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251220-0001','2025-12-20','17:23','5.230','admpindah','2025-12-19 17:23:53');
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-20251220-0001','1','E2D-YLAC-141-0','1','2.400','2.400','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YLAC-141-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YLAC-141-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-20 17:24:11' WHERE kode_barang='E2D-YLAC-141-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YLAC-141-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-12-20 17:24:11','TOKO','PM-E','E2D','E2D-YLAC-141-0','1','2.400','2.400','1','2.400','2.400','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-YLAC-141-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YLAC-141-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-20251220-0001','1','E1D-YLAE-122-0','1','1.000','1.000','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YLAE-122-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YLAE-122-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-20 17:24:11' WHERE kode_barang='E1D-YLAE-122-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YLAE-122-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-12-20 17:24:11','TOKO','PM-E','E1D','E1D-YLAE-122-0','1','1.000','1.000','1','1.000','1.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' 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='E1D-YLAE-122-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YLAE-122-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-20251220-0001','1','E1D-YLAG-202-0','1','0.930','0.930','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YLAG-202-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YLAG-202-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-12-20 17:24:11' WHERE kode_barang='E1D-YLAG-202-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YLAG-202-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-12-20 17:24:11','TOKO','PM-E','E1D','E1D-YLAG-202-0','1','0.930','0.930','1','0.930','0.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' 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='E1D-YLAG-202-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YLAG-202-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251220-0001','2025-12-20','17:24','4.330','admpindah','2025-12-19 17:24:11');
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-20251220-0001','1','F2E-YCBE-121-0','1','3.970','3.970','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-YCBE-121-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-YCBE-121-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-20 17:24:29' WHERE kode_barang='F2E-YCBE-121-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-YCBE-121-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-12-20 17:24:29','TOKO','PM-F','F2E','F2E-YCBE-121-0','1','3.970','3.970','1','3.970','3.970','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' 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='F2E-YCBE-121-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-YCBE-121-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-20251220-0001','1','F2E-YIXD-103-0','1','10.820','10.820','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-YIXD-103-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-YIXD-103-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-20 17:24:29' WHERE kode_barang='F2E-YIXD-103-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-YIXD-103-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-20 17:24:29','TOKO','PM-F','F2E','F2E-YIXD-103-0','1','10.820','10.820','1','10.820','10.820','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' 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='F2E-YIXD-103-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-YIXD-103-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251220-0001','1','F1E-YIXD-143-0','1','3.730','3.730','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YIXD-143-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YIXD-143-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-20 17:24:29' WHERE kode_barang='F1E-YIXD-143-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YIXD-143-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-12-20 17:24:29','TOKO','PM-F','F1E','F1E-YIXD-143-0','1','3.730','3.730','1','3.730','3.730','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-YIXD-143-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YIXD-143-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-20251220-0001','1','F2E-YKAE-102-0','1','5.320','5.320','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-YKAE-102-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-YKAE-102-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-20 17:24:29' WHERE kode_barang='F2E-YKAE-102-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-YKAE-102-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-12-20 17:24:29','TOKO','PM-F','F2E','F2E-YKAE-102-0','1','5.320','5.320','1','5.320','5.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' 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='F2E-YKAE-102-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-YKAE-102-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251220-0001','2025-12-20','17:24','23.840','admpindah','2025-12-19 17:24:29');
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-20251220-0001','1','H2J-YLAG-9-0','1','2.100','2.100','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-YLAG-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-YLAG-9-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-12-20 17:24:46' WHERE kode_barang='H2J-YLAG-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-YLAG-9-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-12-20 17:24:46','TOKO','PM-H','H2J','H2J-YLAG-9-0','1','2.100','2.100','1','2.100','2.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-YLAG-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-YLAG-9-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251220-0001','2025-12-20','17:24','2.100','admpindah','2025-12-19 17:24:46');
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-20251220-0001','1','PHK-YLAH-34-0','1','3.690','3.690','TOKO','PMBK-P','TOKO','PM-P');
DELETE FROM tm_barang WHERE kode_barang='PHK-YLAH-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PHK-YLAH-34-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-P',tgl_last_beli='2025-12-20 17:25:06' WHERE kode_barang='PHK-YLAH-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PHK-YLAH-34-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-12-20 17:25:06','TOKO','PM-P','PHK','PHK-YLAH-34-0','1','3.690','3.690','1','3.690','3.690','100.00');
DELETE FROM tm_dept WHERE kode_dept='PHK' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PHK' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MK' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MK' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PHK-YLAH-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='PHK-YLAH-34-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251220-0001','2025-12-20','17:24','3.690','admpindah','2025-12-19 17:25:06');