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 ('F326071002131','input','1',' MEA1E LG ','TOKO','PM-A','A1E-ZHBG-213-0','AT GYPSY ANAK POLOS LG 8K ','','0.480','1','100.00','502000','0','0','15000','502000','0','0','0','502000','FIT','00420879','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZHBG-213-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='A1E-ZHBG-213-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 ('F326071002131','2026-09-07','0.480','2026-09-07','10:02:14','PLG0031204','502000','502000','0','502000','502000','input','2026-09-07 10:02:13','F32607100213');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','F326071002131','2026-09-07','10:02:14','FIT','502000','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-260907-0002','D','2026-09-07','10:02:14','input','PENJUALAN','F326071002131','7260229000','502000','7260731000');
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 ('F326071031461','input','1',' MDE2 X PM ','TOKO','PM-E','E2D-ZGXG-74-0','CC X MODEL MATA PM 16 8K ','','1.050','1','100.00','1076000','0','0','15000','1078000','0','0','0','1078000','FIT','00412475','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGXG-74-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='E2D-ZGXG-74-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 ('F326071031461','2026-09-07','1.050','2026-09-07','10:31:46','PLG0031205','1078000','1078000','0','1078000','1078000','input','2026-09-07 10:31:46','F32607103146');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','F326071031461','2026-09-07','10:31:46','FIT','1078000','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-260907-0003','D','2026-09-07','10:31:46','input','PENJUALAN','F326071031461','7260731000','1078000','7261809000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071031461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071031461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071031461';
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 ('F326071035551','kasir','1',' MDE2 X PM ','TOKO','PM-E','E2D-ZGXG-74-0','CC X MODEL MATA PM 16 8K ','','1.050','1','100.00','1076000','0','0','15000','1078000','0','0','0','1078000','FIT','00412475','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGXG-74-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='E2D-ZGXG-74-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 ('F326071035551','2026-09-07','1.050','2026-09-07','10:35:55','PLG0031206','1078000','1078000','0','1078000','1078000','kasir','2026-09-07 10:35:55','F32607103555');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','F326071035551','2026-09-07','10:35:55','FIT','1078000','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-260907-0005','D','2026-09-07','10:35:55','kasir','PENJUALAN','F326071035551','7260731000','1078000','7261809000');
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 ('F326071058161','kasir','1',' MEH1 X LH ','TOKO','PM-H','H1E-ZHBE-49-0','KL X TIFF DAUN SLEP LG 8K','','2.390','1','100.00','2498000','0','0','15000','2498000','0','0','0','2498000','SIN','00420091','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHBE-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.390',berat_jual_asli=berat_jual_asli+'2.390',stock_jual='1',berat_akhir=berat_akhir-'2.390',berat_akhir_asli=berat_akhir_asli-'2.390',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='H1E-ZHBE-49-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 ('F326071058161','2026-09-07','2.390','2026-09-07','10:58:17','PLG0031207','2498000','2498000','0','2498000','2498000','kasir','2026-09-07 10:58:16','F32607105816');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','F326071058161','2026-09-07','10:58:17','SIN','2498000','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-260907-0006','D','2026-09-07','10:58:17','kasir','PENJUALAN','F326071058161','7261809000','2498000','7264307000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2498000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326071058161' 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 ('F326071058162','kasir',' 1',' MEA1 LG ','TOKO','PM-A','A1E-ZEAE-218-0','AT MODEL DAUN VAR LG 8K ','','0.810','1','100.00','846000','0','0','15000','846000','0','0','0','846000','SIN','00403696','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZEAE-218-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='A1E-ZEAE-218-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 ('F326071058162','2026-09-07','0.810','2026-09-07','10:58:17','PLG0031208','846000','846000','0','846000','846000','kasir','2026-09-07 10:58:16','F32607105816');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','F326071058162','2026-09-07','10:58:17','SIN','846000','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-260907-0007','D','2026-09-07','10:58:17','kasir','PENJUALAN','F326071058162','7264307000','846000','7265153000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='846000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326071058162' 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-00020126','X-00020126','KL SANTA UB 42CM 17K','GR','---','H1TF','BELI','BELI001','4452000','2026-09-07','3.060','1','kasir','2026-09-07 12:12:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1TF','X-00020126','X-00020126');
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-260907-0001','F324041102372','FIT','1','BELI','BELI001','H1TF', 'X-00020126', 'KL SANTA UB 42CM 17K','3.080','3.060','100.00','3326000','4452000','1454902','1950000','1','4452000','4452000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.060',berat_beli_asli=berat_beli_asli+'3.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.060',berat_akhir_asli=berat_akhir_asli+'3.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1TF' 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-260907-0001','2026-09-07','2026-09-07','12:12:30','FIT','---','3.060','4452000','4452000','4452000','4452000','4452000','kasir','2026-09-07 12:12:30','FB-260907-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260907-0001','RINI','BITING BADEGAN','','','','kasir','2026-09-07 12:12:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260907-0008','K','2026-09-07','12:12:30','kasir','PEMBELIAN UMUM','FB-260907-0001','7265153000','4452000','7260701000');
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-00020127','X-00020127','GL PAPERLINA MODEL BUNGA CLOVER VAR YT 17K','GR','---','F3TE','BELI','BELI001','3815000','2026-09-07','2.620','1','kasir','2026-09-07 12:12:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3TE','X-00020127','X-00020127');
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-260907-0002','F324070912392','FIT','2','BELI','BELI001','F3TE', 'X-00020127', 'GL PAPERLINA MODEL BUNGA CLOVER VAR YT 17K','2.620','2.620','100.00','2948000','3815000','1456107','1960000','1','3815000','3815000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.620',berat_beli_asli=berat_beli_asli+'2.620',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.620',berat_akhir_asli=berat_akhir_asli+'2.620',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3TE' 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-260907-0002','2026-09-07','2026-09-07','12:12:30','FIT','---','2.620','3815000','3815000','3815000','3815000','3815000','kasir','2026-09-07 12:12:30','FB-260907-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260907-0002','RINI','BITING BADEGAN','','','','kasir','2026-09-07 12:12:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260907-0009','K','2026-09-07','12:12:30','kasir','PEMBELIAN UMUM','FB-260907-0002','7260701000','3815000','7256886000');
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-00020128','X-00020128','LT X HURUF MATA R','GR','---','D2TE','BELI','BELI001','745000','2026-09-07','0.770','1','kasir','2026-09-07 12:12:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2TE','X-00020128','X-00020128');
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-260907-0003','F324041102371','FIT','3','BELI','BELI001','D2TE', 'X-00020128', 'LT X HURUF MATA R','0.770','0.770','100.00','824000','745000','967532','1960000','1','745000','745000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.770',berat_beli_asli=berat_beli_asli+'0.770',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.770',berat_akhir_asli=berat_akhir_asli+'0.770',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2TE' 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-260907-0003','2026-09-07','2026-09-07','12:12:30','FIT','---','0.770','745000','745000','745000','745000','745000','kasir','2026-09-07 12:12:30','FB-260907-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260907-0003','RINI','BITING BADEGAN','','','','kasir','2026-09-07 12:12:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260907-0010','K','2026-09-07','12:12:30','kasir','PEMBELIAN UMUM','FB-260907-0003','7256886000','745000','7256141000');
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-00020129','X-00020129','GW TOUGE HATI SLEP LG 8K','GR','---','B1F','BELI','BELI001','387000','2026-09-07','0.400','1','kasir','2026-09-07 12:14:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00020129','X-00020129');
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-260907-0004','F326170909281','FIT','1','BELI','BELI001','B1F', 'X-00020129', 'GW TOUGE HATI SLEP LG 8K','0.400','0.400','100.00','440000','387000','967500','1065000','1','387000','387000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.400',berat_beli_asli=berat_beli_asli+'0.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.400',berat_akhir_asli=berat_akhir_asli+'0.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1F' 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-260907-0004','2026-09-07','2026-09-07','12:14:54','FIT','---','0.400','387000','387000','387000','387000','387000','kasir','2026-09-07 12:14:55','FB-260907-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260907-0004','NIA','JERUK','','','','kasir','2026-09-07 12:14:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260907-0011','K','2026-09-07','12:14:54','kasir','PEMBELIAN UMUM','FB-260907-0004','7256141000','387000','7255754000');
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-00020130','X-00020130','CC PIPA MODEL RANTAI SLEP VAR HTM 14 8K','GR','---','E1F','BELI','BELI001','315000','2026-09-07','0.450','1','kasir','2026-09-07 12:15:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00020130','X-00020130');
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-260907-0005','F324271007461','LIS','1','BELI','BELI001','E1F', 'X-00020130', 'CC PIPA MODEL RANTAI SLEP VAR HTM 14 8K','0.450','0.450','100.00','280000','315000','700000','1065000','1','315000','315000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.450',berat_beli_asli=berat_beli_asli+'0.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.450',berat_akhir_asli=berat_akhir_asli+'0.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' 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-260907-0005','2026-09-07','2026-09-07','12:15:24','LIS','---','0.450','315000','315000','315000','315000','315000','kasir','2026-09-07 12:15:24','FB-260907-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260907-0005','YEYE','JERUK PACITAN','','','','kasir','2026-09-07 12:15:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260907-0012','K','2026-09-07','12:15:24','kasir','PEMBELIAN UMUM','FB-260907-0005','7255754000','315000','7255439000');
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-00020131','X-00020131','CC MODEL DAUN VAR CM 16 8K','GR','---','E1D','BELI','BELI001','1075000','2026-09-07','1.280','1','kasir','2026-09-07 12:31:19');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00020131','X-00020131');
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-260907-0006','F325030143402','FIT','1','BELI','BELI001','E1D', 'X-00020131', 'CC MODEL DAUN VAR CM 16 8K','1.280','1.280','100.00','1216000','1075000','839844','1025000','1','1075000','1075000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.280',berat_beli_asli=berat_beli_asli+'1.280',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.280',berat_akhir_asli=berat_akhir_asli+'1.280',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-07' 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-260907-0006','2026-09-07','2026-09-07','12:31:19','FIT','---','1.280','1075000','1075000','1075000','1075000','1075000','kasir','2026-09-07 12:31:19','FB-260907-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260907-0006','PANEN','PUH IJO','','','','kasir','2026-09-07 12:31:19');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260907-0013','K','2026-09-07','12:31:19','kasir','PEMBELIAN UMUM','FB-260907-0006','7255439000','1075000','7254364000');
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-00020132','X-00020132','CC COR T 8K','GR','---','E1D','BELI','BELI001','1495000','2026-09-07','1.700','1','kasir','2026-09-07 12:39:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00020132','X-00020132');
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-260907-0007','t0073327','FIT','1','BELI','BELI001','E1D', 'X-00020132', 'CC COR T 8K','1.700','1.700','100.00','1627000','1495000','879412','1025000','1','1495000','1495000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.700',berat_beli_asli=berat_beli_asli+'1.700',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.700',berat_akhir_asli=berat_akhir_asli+'1.700',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-07' 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-260907-0007','2026-09-07','2026-09-07','12:39:23','FIT','---','1.700','1495000','1495000','1495000','1495000','1495000','kasir','2026-09-07 12:39:23','FB-260907-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260907-0007','ELA','POHIJO SAMPUNG','','','082138135790','kasir','2026-09-07 12:39:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260907-0014','K','2026-09-07','12:39:23','kasir','PEMBELIAN UMUM','FB-260907-0007','7254364000','1495000','7252869000');
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 ('F326071251511','kasir','1',' MEE1 CM 16','TOKO','PM-E','E1D-ZIXC-35-0','CC MODEL SLEP VAR CM 16 8K ','','0.880','1','100.00','902000','0','0','15000','920000','0','0','0','920000','SIN','00421925','E1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZIXC-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='E1D-ZIXC-35-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 ('F326071251511','2026-09-07','0.880','2026-09-07','12:51:51','PLG0031209','920000','920000','0','920000','920000','kasir','2026-09-07 12:51:51','F32607125151');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','F326071251511','2026-09-07','12:51:51','SIN','920000','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-260907-0015','D','2026-09-07','12:51:51','kasir','PENJUALAN','F326071251511','7252869000','920000','7253789000');
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 ('F326071254511','kasir','1',' MDE1 X LG ','TOKO','PM-E','E1D-ZIXA-300-0','CC X MODEL SLEP LG 18 8K ','','3.000','1','100.00','3075000','0','0','15000','3075000','0','0','0','3075000','FIT','00421727','E1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZIXA-300-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='E1D-ZIXA-300-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 ('F326071254511','2026-09-07','3.000','2026-09-07','12:54:51','PLG0031210','3075000','3075000','0','3075000','3075000','kasir','2026-09-07 12:54:51','F32607125451');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','F326071254511','2026-09-07','12:54:51','FIT','3075000','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-260907-0016','D','2026-09-07','12:54:51','kasir','PENJUALAN','F326071254511','7253789000','3075000','7256864000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3075000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326071254511' 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 ('F326071254512','kasir',' 1',' MEF1 X UB ','TOKO','PM-F','F1E-YHBI-237-0','GL X SHOGUN POLOS UB 58 8K ','','9.980','1','100.00','10429000','0','0','15000','10430000','0','0','0','10430000','FIT','00367478','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YHBI-237-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'9.980',berat_jual_asli=berat_jual_asli+'9.980',stock_jual='1',berat_akhir=berat_akhir-'9.980',berat_akhir_asli=berat_akhir_asli-'9.980',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='F1E-YHBI-237-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 ('F326071254512','2026-09-07','9.980','2026-09-07','12:54:51','PLG0031211','10430000','10430000','0','10430000','10430000','kasir','2026-09-07 12:54:51','F32607125451');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','F326071254512','2026-09-07','12:54:51','FIT','10430000','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-260907-0017','D','2026-09-07','12:54:51','kasir','PENJUALAN','F326071254512','7256864000','10430000','7267294000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='10430000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326071254512' 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 ('F326070130401','kasir','1',' MEE1 LG 16','TOKO','PM-E','E1E-ZGXA-326-0','CC MODEL ISYANA SLEP LG 16 8K ','','0.510','1','100.00','533000','0','0','15000','533000','0','0','0','533000','SIN','00411850','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXA-326-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='E1E-ZGXA-326-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 ('F326070130401','2026-09-07','0.510','2026-09-07','13:30:41','PLG0031212','533000','533000','0','533000','533000','kasir','2026-09-07 13:30:40','F32607013040');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','F326070130401','2026-09-07','13:30:41','SIN','533000','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-260907-0018','D','2026-09-07','13:30:41','kasir','PENJUALAN','F326070130401','7267294000','533000','7267827000');
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 ('F326070137421','kasir','1',' MFE1 X KH ','TOKO','PM-E','E1F-ZHBF-241-0','CC X MODEL ARESO SPECTRA VAR SLEP KH 18 8K ','','0.370','1','100.00','394000','0','0','15000','395000','0','0','0','395000','SIN','00420613','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZHBF-241-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='E1F-ZHBF-241-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 ('F326070137421','2026-09-07','0.370','2026-09-07','13:37:43','PLG0031213','395000','395000','0','395000','395000','kasir','2026-09-07 13:37:42','F32607013742');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','F326070137421','2026-09-07','13:37:43','SIN','395000','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-260907-0019','D','2026-09-07','13:37:43','kasir','PENJUALAN','F326070137421','7267827000','395000','7268222000');
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 ('F326070139171','kasir','1',' MEE1 X LG ','TOKO','PM-E','E1E-ZGAG-109-0','CC X ISYANA SLEP LG 16 8K ','','0.560','1','100.00','585000','0','0','15000','585000','0','0','0','585000','LIS','00413945','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGAG-109-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='E1E-ZGAG-109-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 ('F326070139171','2026-09-07','0.560','2026-09-07','13:39:18','PLG0031214','585000','585000','0','585000','585000','kasir','2026-09-07 13:39:17','F32607013917');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','F326070139171','2026-09-07','13:39:18','LIS','585000','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-260907-0020','D','2026-09-07','13:39:18','kasir','PENJUALAN','F326070139171','7268222000','585000','7268807000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='585000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326070139171' 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 ('F326070139172','kasir',' 1',' MEE1 X LG ','TOKO','PM-E','E1E-ZGXI-343-0','CC X MODEL ISYANA SLEP LG 16 8K ','','0.450','1','100.00','470000','0','0','15000','470000','0','0','0','470000','LIS','00413062','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXI-343-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='E1E-ZGXI-343-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 ('F326070139172','2026-09-07','0.450','2026-09-07','13:39:18','PLG0031215','470000','470000','0','470000','470000','kasir','2026-09-07 13:39:17','F32607013917');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','F326070139172','2026-09-07','13:39:18','LIS','470000','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-260907-0021','D','2026-09-07','13:39:18','kasir','PENJUALAN','F326070139172','7268807000','470000','7269277000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='470000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326070139172' 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 ('F326070147591','kasir','1',' MEF2 X UB ','TOKO','PM-F','F2E-YEAD-274-0','GL X OVAL MATA UB 54 8K ','','6.860','1','100.00','7169000','0','0','15000','7170000','0','0','0','7170000','FIT','00353473','F2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YEAD-274-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.860',berat_jual_asli=berat_jual_asli+'6.860',stock_jual='1',berat_akhir=berat_akhir-'6.860',berat_akhir_asli=berat_akhir_asli-'6.860',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='F2E-YEAD-274-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 ('F326070147591','2026-09-07','6.860','2026-09-07','13:47:59','PLG0031216','7170000','7170000','0','7170000','7170000','kasir','2026-09-07 13:47:59','F32607014759');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','F326070147591','2026-09-07','13:47:59','FIT','7170000','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-260907-0022','D','2026-09-07','13:47:59','kasir','PENJUALAN','F326070147591','7269277000','7170000','7276447000');
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-00020133','X-00020133','KL NORY KH 42CM 8K','GR','---','H1E','BELI','BELI001','1670000','2026-09-07','1.720','1','kasir','2026-09-07 13:52:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020133','X-00020133');
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-260907-0008','F326030131081','LIS','1','BELI','BELI001','H1E', 'X-00020133', 'KL NORY KH 42CM 8K','1.720','1.720','100.00','1910000','1670000','970930','1045000','1','1670000','1670000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.720',berat_beli_asli=berat_beli_asli+'1.720',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.720',berat_akhir_asli=berat_akhir_asli+'1.720',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-07' 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-260907-0008','2026-09-07','2026-09-07','13:52:46','LIS','---','1.720','1670000','1670000','1670000','1670000','1670000','kasir','2026-09-07 13:52:47','FB-260907-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260907-0008','SUKATNI','NGEROTO BULUKERTO','','','','kasir','2026-09-07 13:52:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260907-0023','K','2026-09-07','13:52:46','kasir','PEMBELIAN UMUM','FB-260907-0008','7276447000','1670000','7274777000');
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 ('F326070156261','kasir','1',' MEF3E X KH','TOKO','PM-F','F3E-ZDXD-249-0','GL X RATAI HOLLOW P4 SLEP KH 8K ','','7.730','1','100.00','8078000','0','0','15000','8078000','0','0','0','8078000','LIS','00397949','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDXD-249-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'7.730',berat_jual_asli=berat_jual_asli+'7.730',stock_jual='1',berat_akhir=berat_akhir-'7.730',berat_akhir_asli=berat_akhir_asli-'7.730',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='F3E-ZDXD-249-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 ('F326070156261','2026-09-07','7.730','2026-09-07','13:56:26','PLG0031217','8078000','8078000','0','8078000','8078000','kasir','2026-09-07 13:56:26','F32607015626');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','F326070156261','2026-09-07','13:56:26','LIS','8078000','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-260907-0024','D','2026-09-07','13:56:26','kasir','PENJUALAN','F326070156261','7274777000','8078000','7282855000');
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 ('F326070206291','kasir','1',' MEA1 LG ','TOKO','PM-A','A1E-WEXA-27-0','AT KLIP MODEL SLEP LG ','','1.150','1','100.00','1202000','0','0','15000','1203000','0','0','0','1203000','LIS','00229297','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-WEXA-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='A1E-WEXA-27-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 ('F326070206291','2026-09-07','1.150','2026-09-07','14:06:29','PLG0031218','1203000','1203000','0','1203000','1203000','kasir','2026-09-07 14:06:29','F32607020629');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','F326070206291','2026-09-07','14:06:29','LIS','1203000','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-260907-0025','D','2026-09-07','14:06:29','kasir','PENJUALAN','F326070206291','7282855000','1203000','7284058000');
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-00020134','X-00020134','AT XXX MODEL SLEP UB 8K','GR','---','A1D','BELI','BELI001','540000','2026-09-07','0.580','1','kasir','2026-09-07 14:42:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00020134','X-00020134');
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-260907-0009','F325240907301','FIT','1','BELI','BELI001','A1D', 'X-00020134', 'AT XXX MODEL SLEP UB 8K','0.840','0.580','100.00','878000','540000','931034','1025000','1','540000','540000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.580',berat_beli_asli=berat_beli_asli+'0.580',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.580',berat_akhir_asli=berat_akhir_asli+'0.580',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' 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-260907-0009','2026-09-07','2026-09-07','14:42:37','FIT','---','0.580','540000','540000','540000','540000','540000','kasir','2026-09-07 14:42:38','FB-260907-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260907-0009','NOVA','BULUKERTO','','','08242151382','kasir','2026-09-07 14:42:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260907-0026','K','2026-09-07','14:42:37','kasir','PEMBELIAN UMUM','FB-260907-0009','7284058000','540000','7283518000');
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 ('F326070243551','kasir','1',' MEF3E X YT','TOKO','PM-F','F3E-ZHBF-80-0','GL X KREPYAK DAUN SLEP YT 8K ','','3.470','1','100.00','3626000','0','0','15000','3626000','0','0','0','3626000','SIN','00420452','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHBF-80-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.470',berat_jual_asli=berat_jual_asli+'3.470',stock_jual='1',berat_akhir=berat_akhir-'3.470',berat_akhir_asli=berat_akhir_asli-'3.470',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='F3E-ZHBF-80-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 ('F326070243551','2026-09-07','3.470','2026-09-07','14:43:55','PLG0031219','3626000','3626000','0','3626000','3626000','kasir','2026-09-07 14:43:55','F32607024355');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','F326070243551','2026-09-07','14:43:55','SIN','3626000','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-260907-0027','D','2026-09-07','14:43:55','kasir','PENJUALAN','F326070243551','7283518000','3626000','7287144000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260907-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260907-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260907-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260907-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260907-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260907-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260907-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260907-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260907-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260907-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260907-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260907-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260907-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260907-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260907-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260907-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260907-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260907-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070130401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070130401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070130401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070137421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070137421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070137421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070139171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070139171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070139171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070139172' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070139172' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070139172';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070147591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070147591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070147591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070156261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070156261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070156261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070206291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070206291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070206291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070243551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070243551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070243551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071002131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071002131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071002131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071035551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071035551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071035551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071058161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071058161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071058161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071058162' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071058162' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071058162';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071251511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071251511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071251511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071254511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071254511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071254511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071254512' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071254512' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071254512';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-08','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-08';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-07';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-07';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-09-07' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-07';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-07';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-07';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-07';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-08' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-07' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260908-0001','D','2026-09-08','15:10:24','SYSTEM','SALDO AWAL','SALDO AWAL','0','7287144000','7287144000');
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-260908-0001','D','2026-09-08','15:10:24','BCA','SALDO AWAL','SALDO AWAL','0','740659000','740659000');
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-260908-0001','D','2026-09-08','15:10:24','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-260908-0001','D','2026-09-08','15:10:24','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-09-08';