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 ('F325120829091','input','1',' TAB0 DW ','TOKO','PT-B','B0TA-XDAC-38-T','GW MRICAN SLEP DW 17K ','','0.500','1','100.00','880000','0','0','15000','880000','0','0','0','880000','AAT','T0056349','B0TA','0','0','-','0','1760000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B0TA-XDAC-38-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='B0TA-XDAC-38-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 ('F325120829091','2025-11-12','0.500','2025-11-12','08:29:09','PLG0025642','880000','880000','0','880000','880000','input','2025-11-12 08:29:09','F32512082909');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F325120829091','2025-11-12','08:29:09','AAT','880000','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-251112-0002','D','2025-11-12','08:29:09','input','PENJUALAN','F325120829091','632485000','880000','633365000');
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 ('F325120837101','input','1',' MHA1 X DG ','TOKO','PM-A','A1H-YKXE-3-0','AT X BABY TINDIK DG 8K ','','0.260','1','100.00','282000','0','0','15000','282000','0','0','0','282000','SIN','00376697','A1H','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1H-YKXE-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='A1H-YKXE-3-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 ('F325120837101','2025-11-12','0.260','2025-11-12','08:37:11','PLG0025643','282000','282000','0','282000','282000','input','2025-11-12 08:37:10','F32512083710');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F325120837101','2025-11-12','08:37:11','SIN','282000','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-251112-0003','D','2025-11-12','08:37:11','input','PENJUALAN','F325120837101','633365000','282000','633647000');
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 ('F325120852571','input','1',' MEA1 5K LG','TOKO','PM-A','A1E-XBBI-155-0','AT HUGGIES KLIP MATA LG 8K ','','1.070','1','100.00','1097000','0','0','15000','1098000','0','5000','0','1103000','FIT','00282665','A1E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-XBBI-155-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='A1E-XBBI-155-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 ('F325120852571','2025-11-12','1.070','2025-11-12','08:52:57','PLG0025644','1098000','1098000','5000','1103000','1103000','input','2025-11-12 08:52:57','F32512085257');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F325120852571','2025-11-12','08:52:57','FIT','1103000','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-251112-0004','D','2025-11-12','08:52:57','input','PENJUALAN','F325120852571','633647000','1103000','634750000');
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 ('F325120902161','input','1',' TFE8 X 15 ','TOKO','PT-E','E8TF-YFBF-140-T','CC X MODEL MATA VAR 15 18K ','','1.220','1','100.00','2281000','0','0','15000','2280000','0','5000','0','2285000','SIN','T0070507','E8TF','0','0','-','1','1870000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E8TF-YFBF-140-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.220',berat_jual_asli=berat_jual_asli+'1.220',stock_jual='1',berat_akhir=berat_akhir-'1.220',berat_akhir_asli=berat_akhir_asli-'1.220',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='E8TF-YFBF-140-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 ('F325120902161','2025-11-12','1.220','2025-11-12','09:02:17','PLG0025645','2280000','2280000','5000','2285000','2285000','input','2025-11-12 09:02:16','F32512090216');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F325120902161','2025-11-12','09:02:17','SIN','2285000','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-251112-0005','D','2025-11-12','09:02:17','input','PENJUALAN','F325120902161','634750000','2285000','637035000');
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-00017440','X-00017440','GL FANCY MODEL KUPU CAT MATA VAR HW 8K','GR','---','F3E','BELI','BELI001','1315000','2025-11-12','2.080','1','kasir','2025-11-12 10:06:58');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017440','X-00017440');
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-251112-0001','F325270402042','FIT','1','BELI','BELI001','F3E', 'X-00017440', 'GL FANCY MODEL KUPU CAT MATA VAR HW 8K','2.100','2.080','100.00','1606000','1315000','632212','1035000','1','1315000','1315000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.080',berat_beli_asli=berat_beli_asli+'2.080',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.080',berat_akhir_asli=berat_akhir_asli+'2.080',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-12' 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-251112-0001','2025-11-12','2025-11-12','10:06:57','FIT','---','2.080','1315000','1315000','1315000','1315000','1315000','kasir','2025-11-12 10:06:58','FB-251112-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251112-0001','AJENG PRAMESTI','PAKIS BARU','','','081903195797','kasir','2025-11-12 10:06:58');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-12' 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-251112-0006','K','2025-11-12','10:06:57','kasir','PEMBELIAN UMUM','FB-251112-0001','637035000','1315000','635720000');
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 ('F325121029341','kasir','1',' MEF2 X PM ','TOKO','PM-F','F2E-YFAC-20-0','GL X PIPA MATA PM 54 8K ','','4.000','1','100.00','4100000','0','0','15000','4100000','0','0','0','4100000','AAT','00357135','F2E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YFAC-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.000',berat_jual_asli=berat_jual_asli+'4.000',stock_jual='1',berat_akhir=berat_akhir-'4.000',berat_akhir_asli=berat_akhir_asli-'4.000',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='F2E-YFAC-20-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 ('F325121029341','2025-11-12','4.000','2025-11-12','10:29:35','PLG0025646','4100000','4100000','0','4100000','4100000','kasir','2025-11-12 10:29:34','F32512102934');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F325121029341','2025-11-12','10:29:35','AAT','4100000','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-251112-0007','D','2025-11-12','10:29:35','kasir','PENJUALAN','F325121029341','635720000','4100000','639820000');
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 ('F325121034351','kasir','1',' MDE2 X KH ','TOKO','PM-E','E2D-YEXA-132-0','CC X MODEL MATA KH 14 8K ','','0.950','1','100.00','955000','0','0','15000','955000','0','0','0','955000','AAT','00351725','E2D','0','0','-','0','1015000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YEXA-132-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-11-12' AND kode_barang='E2D-YEXA-132-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 ('F325121034351','2025-11-12','0.950','2025-11-12','10:34:36','PLG0025647','955000','955000','0','955000','955000','kasir','2025-11-12 10:34:35','F32512103435');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F325121034351','2025-11-12','10:34:36','AAT','955000','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-251112-0008','D','2025-11-12','10:34:36','kasir','PENJUALAN','F325121034351','639820000','955000','640775000');
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 ('F325121056001','kasir','1',' MDE2 10K C','TOKO','PM-E','E2D-YEAF-172-0','CC WEDDING MATA CM 22 8K ','','2.160','1','100.00','2171000','0','0','15000','2170000','0','10000','0','2180000','SIN','00354412','E2D','0','0','-','1','1015000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YEAF-172-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='E2D-YEAF-172-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 ('F325121056001','2025-11-12','2.160','2025-11-12','10:56:01','PLG0025648','2170000','2170000','10000','2180000','2180000','kasir','2025-11-12 10:56:00','F32512105600');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F325121056001','2025-11-12','10:56:01','SIN','2180000','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-251112-0009','D','2025-11-12','10:56:01','kasir','PENJUALAN','F325121056001','640775000','2180000','642955000');
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-00017441','X-00017441','KL XX SANTA MODEL MATA VAR UB 8K','GR','---','H1E','BELI','BELI001','2100000','2025-11-12','2.540','1','kasir','2025-11-12 11:05:56');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00017441','X-00017441');
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-251112-0002','F325070843091','FIT','1','BELI','BELI001','H1E', 'X-00017441', 'KL XX SANTA MODEL MATA VAR UB 8K','2.540','2.540','100.00','2515000','2100000','826772','1035000','1','2100000','2100000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.540',berat_beli_asli=berat_beli_asli+'2.540',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.540',berat_akhir_asli=berat_akhir_asli+'2.540',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251112-0002','2025-11-12','2025-11-12','11:05:55','FIT','---','2.540','2100000','2100000','2100000','2100000','2100000','kasir','2025-11-12 11:05:56','FB-251112-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251112-0002','MB EEN','BANGSRI','','','','kasir','2025-11-12 11:05:56');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-12' 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-251112-0010','K','2025-11-12','11:05:55','kasir','PEMBELIAN UMUM','FB-251112-0002','642955000','2100000','640855000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251112-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251112-0002';
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-00017442','X-00017442','KL XX SANTA MODEL MATA VAR UB 8K','GR','---','H1E','BELI','BELI001','2100000','2025-11-12','2.540','1','kasir','2025-11-12 11:24:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00017442','X-00017442');
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-251112-0002','F325070843091','FIT','1','BELI','BELI001','H1E', 'X-00017442', 'KL XX SANTA MODEL MATA VAR UB 8K','2.540','2.540','100.00','2515000','2100000','826772','1035000','1','2100000','2100000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.540',berat_beli_asli=berat_beli_asli+'2.540',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.540',berat_akhir_asli=berat_akhir_asli+'2.540',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251112-0002','2025-11-12','2025-11-12','11:24:39','FIT','---','2.540','2100000','2100000','2100000','2100000','2100000','kasir','2025-11-12 11:24:39','FB-251112-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251112-0002','MB EEN','BANGSRI','','','','kasir','2025-11-12 11:24:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-12' 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-251112-0012','K','2025-11-12','11:24:39','kasir','PEMBELIAN UMUM','FB-251112-0002','642955000','2100000','640855000');
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-00017443','X-00017443','AT MODEL MATA VAR LG 8K','GR','---','A1E','BELI','BELI001','150000','2025-11-12','0.280','1','kasir','2025-11-12 11:25:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00017443','X-00017443');
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-251112-0003','F325141123221','AAT','1','BELI','BELI001','A1E', 'X-00017443', 'AT MODEL MATA VAR LG 8K','0.570','0.280','100.00','510000','150000','535714','1035000','1','150000','150000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.280',berat_beli_asli=berat_beli_asli+'0.280',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.280',berat_akhir_asli=berat_akhir_asli+'0.280',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251112-0003','2025-11-12','2025-11-12','11:25:13','AAT','---','0.280','150000','150000','150000','150000','150000','kasir','2025-11-12 11:25:14','FB-251112-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251112-0003','DARWANTI','BITING','','','','kasir','2025-11-12 11:25:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-12' 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-251112-0013','K','2025-11-12','11:25:13','kasir','PEMBELIAN UMUM','FB-251112-0003','640855000','150000','640705000');
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 ('F325121126131','kasir','1',' MEF3E XXX ','TOKO','PM-F','F3E-YJBB-195-0','GL XXX CASTELI SLEP UB 8K ','','1.510','1','100.00','1548000','0','0','15000','1548000','0','0','0','1548000','SIN','00374258','F3E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJBB-195-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='F3E-YJBB-195-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 ('F325121126131','2025-11-12','1.510','2025-11-12','11:26:14','PLG0025649','1548000','1548000','0','1548000','1548000','kasir','2025-11-12 11:26:13','F32512112613');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F325121126131','2025-11-12','11:26:14','SIN','1548000','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-251112-0014','D','2025-11-12','11:26:14','kasir','PENJUALAN','F325121126131','640705000','1548000','642253000');
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 ('F325121126521','kasir','1',' MDE2 X KH ','TOKO','PM-E','E2D-YBXA-189-0','CC X MODEL MATA KH 16 8K ','','0.980','1','100.00','985000','0','0','15000','985000','0','0','0','985000','SIN','00337065','E2D','0','0','-','0','1015000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YBXA-189-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-11-12' AND kode_barang='E2D-YBXA-189-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325121126521','2025-11-12','0.980','2025-11-12','11:26:53','PLG0025650','985000','985000','0','985000','985000','kasir','2025-11-12 11:26:52','F32512112652');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F325121126521','2025-11-12','11:26:53','SIN','985000','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-251112-0015','D','2025-11-12','11:26:53','kasir','PENJUALAN','F325121126521','642253000','985000','643238000');
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-00017444','X-00017444','LT X MODEL MATA YT 8K','GR','---','D2D','BELI','BELI001','522000','2025-11-12','0.620','1','kasir','2025-11-12 11:30:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2D','X-00017444','X-00017444');
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-251112-0004','F325210953091','FIT','1','BELI','BELI001','D2D', 'X-00017444', 'LT X MODEL MATA YT 8K','0.620','0.620','100.00','563000','522000','841935','1015000','1','522000','522000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.620',berat_beli_asli=berat_beli_asli+'0.620',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.620',berat_akhir_asli=berat_akhir_asli+'0.620',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2D' 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-251112-0004','2025-11-12','2025-11-12','11:30:24','FIT','---','0.620','522000','522000','522000','522000','522000','kasir','2025-11-12 11:30:24','FB-251112-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251112-0004','AYUK','GEDAWUNG KISMANTORO','','','','kasir','2025-11-12 11:30:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-12' 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-251112-0016','K','2025-11-12','11:30:24','kasir','PEMBELIAN UMUM','FB-251112-0004','643238000','522000','642716000');
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-00017445','X-00017445','CC MODEL DAUN VAR LG 14 8K','GR','---','E1E','BELI','BELI001','415000','2025-11-12','0.510','1','kasir','2025-11-12 11:31:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00017445','X-00017445');
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-251112-0005','F325050247201','SIN','1','BELI','BELI001','E1E', 'X-00017445', 'CC MODEL DAUN VAR LG 14 8K','0.510','0.510','100.00','450000','415000','813725','1035000','1','415000','415000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-251112-0005','2025-11-12','2025-11-12','11:31:45','SIN','---','0.510','415000','415000','415000','415000','415000','kasir','2025-11-12 11:31:45','FB-251112-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251112-0005','GEA','NADI BULUKERTO','','','','kasir','2025-11-12 11:31:45');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-12' 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-251112-0017','K','2025-11-12','11:31:45','kasir','PEMBELIAN UMUM','FB-251112-0005','642716000','415000','642301000');
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 ('F325121154431','kasir','1',' MEF3 X UB ','TOKO','PM-F','F3E-XIBE-270-0','GL X JEDAR INVINITY VAR UB 8K ','','1.610','1','100.00','1650000','0','0','15000','1650000','0','0','0','1650000','AAT','00318960','F3E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-XIBE-270-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='F3E-XIBE-270-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 ('F325121154431','2025-11-12','1.610','2025-11-12','11:54:44','PLG0025651','1650000','1650000','0','1650000','1650000','kasir','2025-11-12 11:54:43','F32512115443');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F325121154431','2025-11-12','11:54:44','AAT','1650000','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-251112-0018','D','2025-11-12','11:54:44','kasir','PENJUALAN','F325121154431','642301000','1650000','643951000');
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 ('F325121210561','kasir','1',' MEF1 10K Y','TOKO','PM-F','F1E-YJXF-68-0','GL ANAK OSROT BONEKA CAT VAR YT 8K ','','1.450','1','100.00','1486000','0','0','15000','1485000','0','10000','0','1495000','SIN','00372365','F1E','0','0','-','1','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YJXF-68-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='F1E-YJXF-68-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 ('F325121210561','2025-11-12','1.450','2025-11-12','12:10:56','PLG0025652','1485000','1485000','10000','1495000','1495000','kasir','2025-11-12 12:10:56','F32512121056');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F325121210561','2025-11-12','12:10:56','SIN','1495000','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-251112-0019','D','2025-11-12','12:10:56','kasir','PENJUALAN','F325121210561','643951000','1495000','645446000');
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 ('F325121213081','kasir','1',' MDE2 UB 14','TOKO','PM-E','E2D-YKXC-344-0','CC MODEL PITA MATA VAR UB 14 8K ','','0.920','1','100.00','925000','0','0','15000','925000','0','0','0','925000','SIN','00376272','E2D','0','0','-','0','1015000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YKXC-344-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.920',berat_jual_asli=berat_jual_asli+'0.920',stock_jual='1',berat_akhir=berat_akhir-'0.920',berat_akhir_asli=berat_akhir_asli-'0.920',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='E2D-YKXC-344-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 ('F325121213081','2025-11-12','0.920','2025-11-12','12:13:09','PLG0025653','925000','925000','0','925000','925000','kasir','2025-11-12 12:13:08','F32512121308');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F325121213081','2025-11-12','12:13:09','SIN','925000','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-251112-0020','D','2025-11-12','12:13:09','kasir','PENJUALAN','F325121213081','645446000','925000','646371000');
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 ('F325121247501','kasir','1',' MEF3E X UB','TOKO','PM-F','H1E-YCAX-145-0','GL X KAKI PAPERLINA UB 8K','','2.590','1','100.00','2655000','0','0','15000','2655000','0','0','0','2655000','AAT','00342885','H1E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YCAX-145-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.590',berat_jual_asli=berat_jual_asli+'2.590',stock_jual='1',berat_akhir=berat_akhir-'2.590',berat_akhir_asli=berat_akhir_asli-'2.590',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='H1E-YCAX-145-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 ('F325121247501','2025-11-12','2.590','2025-11-12','12:47:50','PLG0025654','2655000','2655000','0','2655000','2655000','kasir','2025-11-12 12:47:50','F32512124750');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F325121247501','2025-11-12','12:47:50','AAT','2655000','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-251112-0021','D','2025-11-12','12:47:50','kasir','PENJUALAN','F325121247501','646371000','2655000','649026000');
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-00017446','X-00017446','GL X KAKI TIFF VAR HW','GR','---','F3E','BELI','BELI001','2190000','2025-11-12','3.150','1','kasir','2025-11-12 13:05:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017446','X-00017446');
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-251112-0006','F325081011031','AAT','1','BELI','BELI001','F3E', 'X-00017446', 'GL X KAKI TIFF VAR HW','3.150','3.150','100.00','2085000','2190000','695238','1035000','1','2190000','2190000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.150',berat_beli_asli=berat_beli_asli+'3.150',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.150',berat_akhir_asli=berat_akhir_asli+'3.150',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-12' 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-251112-0006','2025-11-12','2025-11-12','13:05:57','AAT','---','3.150','2190000','2190000','2190000','2190000','2190000','kasir','2025-11-12 13:05:57','FB-251112-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251112-0006','DIAS','DOMAS BULUKERTO','','','','kasir','2025-11-12 13:05:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-12' 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-251112-0022','K','2025-11-12','13:05:57','kasir','PEMBELIAN UMUM','FB-251112-0006','649026000','2190000','646836000');
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-00017447','X-00017447','GL OVAL MODEL C UB D52 8K','GR','---','F1E','BELI','BELI001','1485000','2025-11-12','2.130','1','kasir','2025-11-12 13:31:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017447','X-00017447');
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-251112-0007','F324271026591','FIT','1','BELI','BELI001','F1E', 'X-00017447', 'GL OVAL MODEL C UB D52 8K','2.130','2.130','100.00','1430000','1485000','697183','1035000','1','1485000','1485000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.130',berat_beli_asli=berat_beli_asli+'2.130',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.130',berat_akhir_asli=berat_akhir_asli+'2.130',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-12' 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-251112-0007','2025-11-12','2025-11-12','13:31:42','FIT','---','2.130','1485000','1485000','1485000','1485000','1485000','kasir','2025-11-12 13:31:42','FB-251112-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251112-0007','DESTIAN','PUCUNG KISMANTORO','','','','kasir','2025-11-12 13:31:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-12' 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-251112-0023','K','2025-11-12','13:31:42','kasir','PEMBELIAN UMUM','FB-251112-0007','646836000','1485000','645351000');
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 ('F325120144421','kasir','1',' MEH1 LT 44','TOKO','PM-H','H1E-YKXC-367-0','KL SANTA LT 44CM 8K ','','1.550','1','100.00','1589000','0','0','15000','1590000','0','0','0','1590000','SIN','00376295','H1E','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YKXC-367-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='H1E-YKXC-367-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 ('F325120144421','2025-11-12','1.550','2025-11-12','13:44:42','PLG0025655','1590000','1590000','0','1590000','1590000','kasir','2025-11-12 13:44:42','F32512014442');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F325120144421','2025-11-12','13:44:42','SIN','1590000','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-251112-0024','D','2025-11-12','13:44:42','kasir','PENJUALAN','F325120144421','645351000','1590000','646941000');
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-00017448','X-00017448','AT X MODEL ARESO UB','GR','---','A1F','BELI','BELI001','615000','2025-11-12','0.900','1','kasir','2025-11-12 13:53:11');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00017448','X-00017448');
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-251112-0008','F322190241411','FIT','1','BELI','BELI001','A1F', 'X-00017448', 'AT X MODEL ARESO UB','0.920','0.900','100.00','395000','615000','683333','1055000','1','615000','615000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-12' 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-251112-0008','2025-11-12','2025-11-12','13:53:11','FIT','---','0.900','615000','615000','615000','615000','615000','kasir','2025-11-12 13:53:11','FB-251112-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251112-0008','JUWI','DAGANGAN NGAGLIK','','','','kasir','2025-11-12 13:53:11');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-12' 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-251112-0025','K','2025-11-12','13:53:11','kasir','PEMBELIAN UMUM','FB-251112-0008','646941000','615000','646326000');
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-00017449','X-00017449','GL FANCY MODEL ARESO VAR UB 8K','GR','---','F3E','BELI','BELI001','1392000','2025-11-12','1.530','1','kasir','2025-11-12 13:53:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017449','X-00017449');
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-251112-0009','F325050138541','SIN','1','BELI','BELI001','F3E', 'X-00017449', 'GL FANCY MODEL ARESO VAR UB 8K','1.530','1.530','100.00','1515000','1392000','909804','1035000','1','1392000','1392000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.530',berat_beli_asli=berat_beli_asli+'1.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.530',berat_akhir_asli=berat_akhir_asli+'1.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-12' 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-251112-0009','2025-11-12','2025-11-12','13:53:33','SIN','---','1.530','1392000','1392000','1392000','1392000','1392000','kasir','2025-11-12 13:53:34','FB-251112-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251112-0009','BETTY','KISMANTORO','','','','kasir','2025-11-12 13:53:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-12' 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-251112-0026','K','2025-11-12','13:53:33','kasir','PEMBELIAN UMUM','FB-251112-0009','646326000','1392000','644934000');
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 ('F325120243181','kasir','1',' MDA1D X UB','TOKO','PM-A','A1D-YFBX-13-0','AT X BONEKA ANAK CAT VAR UB 8K','','0.850','1','100.00','854000','0','0','15000','855000','0','0','0','855000','SIN','00358098','A1D','0','0','-','0','1015000');
UPDATE tm_barang SET tgl_last_jual='2025-11-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YFBX-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2025-11-12' AND kode_barang='A1D-YFBX-13-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 ('F325120243181','2025-11-12','0.850','2025-11-12','14:43:18','PLG0025656','855000','855000','0','855000','855000','kasir','2025-11-12 14:43:18','F32512024318');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-12','F325120243181','2025-11-12','14:43:18','SIN','855000','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-251112-0027','D','2025-11-12','14:43:18','kasir','PENJUALAN','F325120243181','644934000','855000','645789000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325120144421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325120144421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325120144421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325120243181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325120243181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325120243181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325120829091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325120829091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325120829091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325120837101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325120837101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325120837101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325120852571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325120852571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325120852571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325120902161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325120902161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325120902161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325121029341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325121029341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325121029341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325121034351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325121034351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325121034351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325121056001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325121056001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325121056001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325121126131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325121126131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325121126131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325121126521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325121126521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325121126521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325121154431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325121154431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325121154431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325121210561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325121210561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325121210561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325121213081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325121213081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325121213081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325121247501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325121247501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325121247501';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251112-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251112-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251112-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251112-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251112-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251112-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251112-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251112-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251112-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251112-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251112-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251112-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251112-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251112-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251112-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251112-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251112-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251112-0009';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-13','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-13';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-12';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-12';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-11-12' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-12';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-12';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-12';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-12';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-13' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-12' 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-251113-0001','D','2025-11-13','15:18:45','SYSTEM','SALDO AWAL','SALDO AWAL','0','645789000','645789000');
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-251113-0001','D','2025-11-13','15:18:45','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-251113-0001','D','2025-11-13','15:18:45','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-251113-0001','D','2025-11-13','15:18:45','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
UPDATE tp_system SET tgl_system='2025-11-13';