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-20250927-0001','1','S1G-YIBD-46-T','1','0.380','0.380','TOKO','PMBK-S','TOKO','PM-S');
DELETE FROM tm_barang WHERE kode_barang='S1G-YIBD-46-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='S1G-YIBD-46-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-S',tgl_last_beli='2025-09-27 07:18:27' WHERE kode_barang='S1G-YIBD-46-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='S1G-YIBD-46-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-09-27 07:18:27','TOKO','PM-S','S1G','S1G-YIBD-46-T','1','0.380','0.380','1','0.380','0.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='S1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='S1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='S1G-YIBD-46-T';
DELETE FROM tm_barang_export WHERE kode_barang='S1G-YIBD-46-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250927-0001','2025-09-27','07:18','0.380','admpindah','2025-09-27 07:18:27');
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 ('F325271057371','input','1',' MDE2 10K C','TOKO','PM-E','E2D-YIXF-304-0','CC WEDDING MATA CM 14 8K ','','1.620','1','100.00','1498000','0','0','15000','1500000','0','10000','0','1510000','FIT','00368400','E2D','0','0','-','0','925000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIXF-304-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.620',berat_jual_asli=berat_jual_asli+'1.620',stock_jual='1',berat_akhir=berat_akhir-'1.620',berat_akhir_asli=berat_akhir_asli-'1.620',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='E2D-YIXF-304-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 ('F325271057371','2025-09-27','1.620','2025-09-27','10:57:37','PLG0025009','1500000','1500000','10000','1510000','1510000','input','2025-09-27 10:57:37','F32527105737');
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-09-27','F325271057371','2025-09-27','10:57:37','FIT','1510000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250927-0002','D','2025-09-27','10:57:37','input','PENJUALAN','F325271057371','60123000','1510000','61633000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1510000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325271057371' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325271057372','input',' 1',' MDE1 X CM ','TOKO','PM-E','E1D-YGBD-37-0','CC X WEDDING POLOS CM 18 8K ','','1.000','1','100.00','925000','0','0','15000','925000','0','0','0','925000','FIT','00362275','E1D','0','0','-','0','925000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YGBD-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='E1D-YGBD-37-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 ('F325271057372','2025-09-27','1.000','2025-09-27','10:57:37','PLG0025010','925000','925000','0','925000','925000','input','2025-09-27 10:57:37','F32527105737');
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-09-27','F325271057372','2025-09-27','10:57:37','FIT','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,status_valid) VALUES ('KM-250927-0003','D','2025-09-27','10:57:37','input','PENJUALAN','F325271057372','61633000','925000','62558000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='925000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325271057372' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325271104101','input','1',' MEF3 YT ','TOKO','PM-F','F3E-YAAA-139-0','GL FLIK MODEL BUNGA ARESO VAR YT 8K ','','2.650','1','100.00','2504000','0','0','15000','2505000','0','0','0','2505000','SIN','00333605','F3E','0','0','-','0','945000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YAAA-139-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.650',berat_jual_asli=berat_jual_asli+'2.650',stock_jual='1',berat_akhir=berat_akhir-'2.650',berat_akhir_asli=berat_akhir_asli-'2.650',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='F3E-YAAA-139-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325271104101','2025-09-27','2.650','2025-09-27','11:04:11','PLG0025011','2505000','2505000','0','2505000','2505000','input','2025-09-27 11:04:10','F32527110410');
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-09-27','F325271104101','2025-09-27','11:04:11','SIN','2505000','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-250927-0004','D','2025-09-27','11:04:11','input','PENJUALAN','F325271104101','62558000','2505000','65063000');
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 ('F325271210121','kasir','1',' MEF3E PM ','TOKO','PM-F','F3E-YHBG-49-0','GL KREPYAK DAUN SLEP PM 8K ','','3.040','1','100.00','2873000','0','0','15000','2873000','0','0','0','2873000','SIN','00366926','F3E','0','0','-','0','945000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHBG-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.040',berat_jual_asli=berat_jual_asli+'3.040',stock_jual='1',berat_akhir=berat_akhir-'3.040',berat_akhir_asli=berat_akhir_asli-'3.040',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='F3E-YHBG-49-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 ('F325271210121','2025-09-27','3.040','2025-09-27','12:10:12','PLG0025012','2873000','2873000','0','2873000','2873000','kasir','2025-09-27 12:10:12','F32527121012');
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-09-27','F325271210121','2025-09-27','12:10:12','SIN','2873000','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-250927-0005','D','2025-09-27','12:10:12','kasir','PENJUALAN','F325271210121','65063000','2873000','67936000');
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-00017085','X-00017085','KL MILANO UB 42CM','GR','---','H1TG','BELI','BELI001','5450000','2025-09-27','4.030','1','kasir','2025-09-27 12:40:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1TG';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1TG','X-00017085','X-00017085');
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-250927-0001','F322061022481','AAT','1','BELI','BELI001','H1TG', 'X-00017085', 'KL MILANO UB 42CM','4.030','4.030','100.00','3125000','5450000','1352357','1710000','1','5450000','5450000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.030',berat_beli_asli=berat_beli_asli+'4.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.030',berat_akhir_asli=berat_akhir_asli+'4.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1TG' 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-250927-0001','2025-09-27','2025-09-27','12:40:48','AAT','---','4.030','5450000','5450000','5450000','5450000','5450000','kasir','2025-09-27 12:40:48','FB-250927-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250927-0001','MAISAROH','GESING','','','','kasir','2025-09-27 12:40:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-27' 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-250927-0006','K','2025-09-27','12:40:48','kasir','PEMBELIAN UMUM','FB-250927-0001','67936000','5450000','62486000');
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-00017086','X-00017086','GL MODEL CAPELA VAR YT 8K','GR','---','F3E','BELI','BELI001','1935000','2025-09-27','2.760','1','kasir','2025-09-27 12:41:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017086','X-00017086');
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-250927-0002','F325261247501','FIT','1','BELI','BELI001','F3E', 'X-00017086', 'GL MODEL CAPELA VAR YT 8K','2.760','2.760','100.00','2105000','1935000','701087','945000','1','1935000','1935000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.760',berat_beli_asli=berat_beli_asli+'2.760',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.760',berat_akhir_asli=berat_akhir_asli+'2.760',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-27' 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-250927-0002','2025-09-27','2025-09-27','12:41:22','FIT','---','2.760','1935000','1935000','1935000','1935000','1935000','kasir','2025-09-27 12:41:23','FB-250927-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250927-0002','RINI','KEPUH PLOSO','','','','kasir','2025-09-27 12:41:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-27' 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-250927-0007','K','2025-09-27','12:41:22','kasir','PEMBELIAN UMUM','FB-250927-0002','62486000','1935000','60551000');
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-00017087','X-00017087','CC POLOS CM 14 8K','GR','---','E1D','BELI','BELI001','1495000','2025-09-27','2.010','1','kasir','2025-09-27 12:41:52');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00017087','X-00017087');
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-250927-0003','F325260219581','FIT','1','BELI','BELI001','E1D', 'X-00017087', 'CC POLOS CM 14 8K','2.010','2.010','100.00','1625000','1495000','743781','925000','1','1495000','1495000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.010',berat_beli_asli=berat_beli_asli+'2.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.010',berat_akhir_asli=berat_akhir_asli+'2.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' 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-250927-0003','2025-09-27','2025-09-27','12:41:52','FIT','---','2.010','1495000','1495000','1495000','1495000','1495000','kasir','2025-09-27 12:41:52','FB-250927-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250927-0003','ROSIANA','KADIPATEN','','','','kasir','2025-09-27 12:41:52');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-27' 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-250927-0008','K','2025-09-27','12:41:52','kasir','PEMBELIAN UMUM','FB-250927-0003','60551000','1495000','59056000');
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-00017088','X-00017088','AT GYPSY MRICAN VAR LG 8K','GR','---','A1E','BELI','BELI001','630000','2025-09-27','0.960','1','kasir','2025-09-27 12:45:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00017088','X-00017088');
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-250927-0004','F324170821231','FIT','1','BELI','BELI001','A1E', 'X-00017088', 'AT GYPSY MRICAN VAR LG 8K','0.960','0.960','100.00','575000','630000','656250','945000','1','630000','630000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.960',berat_beli_asli=berat_beli_asli+'0.960',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.960',berat_akhir_asli=berat_akhir_asli+'0.960',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-27' 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-250927-0004','2025-09-27','2025-09-27','12:45:07','FIT','---','0.960','630000','630000','630000','630000','630000','kasir','2025-09-27 12:45:08','FB-250927-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250927-0004','ANIK','SENDANG','','','','kasir','2025-09-27 12:45:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-27' 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-250927-0009','K','2025-09-27','12:45:07','kasir','PEMBELIAN UMUM','FB-250927-0004','59056000','630000','58426000');
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 ('F325270209361','kasir','1',' MEF3E X UB','TOKO','PM-F','F3E-YIAE-244-0','GL X FANCY PLAT ARESO VAR UB 8K ','','4.950','1','100.00','4678000','0','0','15000','4678000','0','0','0','4678000','AAT','00369695','F3E','0','0','-','0','945000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIAE-244-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.950',berat_jual_asli=berat_jual_asli+'4.950',stock_jual='1',berat_akhir=berat_akhir-'4.950',berat_akhir_asli=berat_akhir_asli-'4.950',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='F3E-YIAE-244-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 ('F325270209361','2025-09-27','4.950','2025-09-27','14:09:37','PLG0025013','4678000','4678000','0','4678000','4678000','kasir','2025-09-27 14:09:36','F32527020936');
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-09-27','F325270209361','2025-09-27','14:09:37','AAT','4678000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250927-0010','D','2025-09-27','14:09:37','kasir','PENJUALAN','F325270209361','58426000','4678000','63104000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4678000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325270209361' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325270209362','kasir',' 1',' MDE1 CM 22','TOKO','PM-E','E1D-XJBD-323-0','CC WEDDING POLOS CM 22 8K ','','2.010','1','100.00','1859000','0','0','15000','1860000','0','0','0','1860000','AAT','00323615','E1D','0','0','-','0','925000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-XJBD-323-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='E1D-XJBD-323-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 ('F325270209362','2025-09-27','2.010','2025-09-27','14:09:37','PLG0025014','1860000','1860000','0','1860000','1860000','kasir','2025-09-27 14:09:36','F32527020936');
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-09-27','F325270209362','2025-09-27','14:09:37','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,status_valid) VALUES ('KM-250927-0011','D','2025-09-27','14:09:37','kasir','PENJUALAN','F325270209362','63104000','1860000','64964000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1860000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325270209362' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325270209363','kasir',' 1',' MDE2 X UB ','TOKO','PM-E','E2D-YIAC-125-0','CC X MODEL MATA UB 13 8K ','','1.470','1','100.00','1360000','0','0','15000','1360000','0','0','0','1360000','AAT','00369209','E2D','0','0','-','0','925000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIAC-125-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.470',berat_jual_asli=berat_jual_asli+'1.470',stock_jual='1',berat_akhir=berat_akhir-'1.470',berat_akhir_asli=berat_akhir_asli-'1.470',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='E2D-YIAC-125-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 ('F325270209363','2025-09-27','1.470','2025-09-27','14:09:37','PLG0025015','1360000','1360000','0','1360000','1360000','kasir','2025-09-27 14:09:36','F32527020936');
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-09-27','F325270209363','2025-09-27','14:09:37','AAT','1360000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250927-0012','D','2025-09-27','14:09:37','kasir','PENJUALAN','F325270209363','64964000','1360000','66324000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1360000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325270209363' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325270209364','kasir',' 1',' MDE2 CM 22','TOKO','PM-E','E2D-YGXA-30-0','CC MODEL MATA SLEP VAR CM 22 8K ','','1.280','1','100.00','1184000','0','0','15000','1185000','0','0','0','1185000','AAT','00359040','E2D','0','0','-','0','925000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YGXA-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='E2D-YGXA-30-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 ('F325270209364','2025-09-27','1.280','2025-09-27','14:09:37','PLG0025016','1185000','1185000','0','1185000','1185000','kasir','2025-09-27 14:09:36','F32527020936');
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-09-27','F325270209364','2025-09-27','14:09:37','AAT','1185000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250927-0013','D','2025-09-27','14:09:37','kasir','PENJUALAN','F325270209364','66324000','1185000','67509000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1185000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325270209364' LIMIT 1;
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-00017089','X-00017089','GL X RANTAI HOLLOW P4 SLEP KH 8K','GR','---','F3E','BELI','BELI001','3085000','2025-09-27','4.000','1','kasir','2025-09-27 14:31:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017089','X-00017089');
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-250927-0005','F325210904501','AAT','1','BELI','BELI001','F3E', 'X-00017089', 'GL X RANTAI HOLLOW P4 SLEP KH 8K','4.000','4.000','100.00','3320000','3085000','771250','945000','1','3085000','3085000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.000',berat_beli_asli=berat_beli_asli+'4.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.000',berat_akhir_asli=berat_akhir_asli+'4.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-27' 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-250927-0005','2025-09-27','2025-09-27','14:31:07','AAT','---','4.000','3085000','3085000','3085000','3085000','3085000','kasir','2025-09-27 14:31:08','FB-250927-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250927-0005','ALI ALVI','NAWANGAN PACITAN','','','','kasir','2025-09-27 14:31:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-27' 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-250927-0014','K','2025-09-27','14:31:07','kasir','PEMBELIAN UMUM','FB-250927-0005','67509000','3085000','64424000');
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 ('F325270257381','kasir','1',' MDE1 CM 16','TOKO','PM-E','E1D-YGAH-293-0','CC POLOS CM 16 8K ','','1.000','1','100.00','925000','0','0','15000','925000','0','0','0','925000','AAT','00361702','E1D','0','0','-','0','925000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YGAH-293-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='E1D-YGAH-293-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 ('F325270257381','2025-09-27','1.000','2025-09-27','14:57:39','PLG0025017','925000','925000','0','925000','925000','kasir','2025-09-27 14:57:38','F32527025738');
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-09-27','F325270257381','2025-09-27','14:57:39','AAT','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,status_valid) VALUES ('KM-250927-0015','D','2025-09-27','14:57:39','kasir','PENJUALAN','F325270257381','64424000','925000','65349000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='925000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325270257381' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325270257382','kasir',' 1',' MDE1 X CM ','TOKO','PM-E','E1D-XJAI-314-0','CC X WEDDING POLOS CM 26 8K ','','1.490','1','100.00','1378000','0','0','15000','1380000','0','0','0','1380000','AAT','00322333','E1D','0','0','-','0','925000');
UPDATE tm_barang SET tgl_last_jual='2025-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-XJAI-314-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.490',berat_jual_asli=berat_jual_asli+'1.490',stock_jual='1',berat_akhir=berat_akhir-'1.490',berat_akhir_asli=berat_akhir_asli-'1.490',stock_akhir='0' WHERE tanggal='2025-09-27' AND kode_barang='E1D-XJAI-314-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325270257382','2025-09-27','1.490','2025-09-27','14:57:39','PLG0025018','1380000','1380000','0','1380000','1380000','kasir','2025-09-27 14:57:38','F32527025738');
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-09-27','F325270257382','2025-09-27','14:57:39','AAT','1380000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250927-0016','D','2025-09-27','14:57:39','kasir','PENJUALAN','F325270257382','65349000','1380000','66729000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1380000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325270257382' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325270209361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325270209361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325270209361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325270209362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325270209362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325270209362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325270209363' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325270209363' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325270209363';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325270209364' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325270209364' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325270209364';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325270257381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325270257381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325270257381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325270257382' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325270257382' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325270257382';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271057371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271057371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271057371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271057372' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271057372' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271057372';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271104101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271104101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271104101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271210121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271210121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271210121';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250927-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250927-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250927-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250927-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250927-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250927-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250927-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250927-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250927-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250927-0005';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-28','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-28';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-27';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-27';
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-09-27' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-27';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-27';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-27';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-27';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-28' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-27' 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-250928-0001','D','2025-09-28','15:18:18','SYSTEM','SALDO AWAL','SALDO AWAL','0','66729000','66729000');
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-250928-0001','D','2025-09-28','15:18:18','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-250928-0001','D','2025-09-28','15:18:18','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-250928-0001','D','2025-09-28','15:18:18','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
UPDATE tp_system SET tgl_system='2025-09-28';