INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-01-05 ','08:26:19');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-05','111','0','-247850000','111','0','-247850000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-05';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-04';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-04';
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-01-04' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-04';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-04';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-04';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-04';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202600 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
UPDATE tt_barang_saldo SET tanggal= '2026-01-05' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-04' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
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-260105-0001','D','2026-01-05','08:26:30','','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-260105-0001','D','2026-01-05','08:26:30','BCA','SALDO AWAL','SALDO AWAL','0','1543713385','1543713385');
UPDATE tp_system SET tgl_system='2026-01-05';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-01-05 ','08:26:45');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-01-05 ','08:31:58');
UPDATE tt_hutang_head SET byr_harus_rp='500000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'520000',tgl_lunas='2026-01-05',status='CLOS',total_lunas='520000' WHERE no_hutang='PI25-01621';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'500000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'500000'  WHERE tanggal='2026-01-05';
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-260105-0002','D','2026-01-05','09:48:44','cashier1','HUTANG LUNAS','PI25-01621','98307576','520000','98827576');
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-00009119','X-00009119','KL FANCY POCO 42CM KKT S UBS','GR','---','MDKL','BELI','BELI001','2923000','2026-01-05','3.730','1','sales','2026-01-05 09:59:15');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDKL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDKL','X-00009119','X-00009119');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260105-0001','FJ-251207-0004','2103','1','BELI','BELI001','MDKL', 'X-00009119', 'KL FANCY POCO 42CM KKT S UBS','3.730','3.730','100.00','3786000','2923000','783646','1','2923000','2923000','RUSAK BIASA');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-05','BELI','BELI001','MDKL','MDKL','100.00','3.730','3.730','1','3.730','3.730','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,status_valid) VALUES ('FB-260105-0001','2026-01-05','2026-01-05','09:59:14','2103','---','3.730','2923000','2923000','2923000','2923000','2923000','sales','2026-01-05 09:59:15','FB-260105-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260105-0001','NOVEL','KALIMAS HILIR 2/33','','','','sales','2026-01-05 09:59:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-05' 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,status_valid) VALUES ('KK-260105-0003','K','2026-01-05','09:59:14','sales','PEMBELIAN UMUM','FB-260105-0001','98827576','2923000','95904576','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260105-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260105-0001';
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,potong_rp) VALUES ('FJ-260105-0001','sales','1',' EX ','TOKO','BTCNMD','MDCN-YKXD-104-0','CN COR BT SHB ','','0.920','1','100.00','975500','0','0','0','975500','0','0','0','975500','2103','00026610','MDCN','148500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-01-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-YKXD-104-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.920',berat_jual_asli=berat_jual_asli+'0.920',stock_jual='1',berat_akhir=berat_akhir-'0.920',berat_akhir_asli=berat_akhir_asli-'0.920',stock_akhir='0' WHERE tanggal='2026-01-05' AND kode_barang='MDCN-YKXD-104-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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 ('FJ-260105-0001','2026-01-05','0.920','2026-01-05','10:19:21','PLG0017832','975500','975500','0','975500','975500','sales','2026-01-05 10:19:21','FJ-260105-0001');
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-01-05','FJ-260105-0001','2026-01-05','10:19:21','2103','975500','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-260105-0004','D','2026-01-05','10:19:21','sales','PENJUALAN','FJ-260105-0001','95904576','975500','96880076','OPEN');
UPDATE tt_jual_head SET dibayar_rp='975500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260105-0001' 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,potong_rp) VALUES ('FJ-260105-0002','sales',' 1',' ','TOKO','BTCNMD','MDCN-YKXD-62-0','CN COR BT SHB ','','0.880','1','100.00','933000','0','0','0','933000','0','0','0','933000','2103','00026568','MDCN','148500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-01-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-YKXD-62-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-01-05' AND kode_barang='MDCN-YKXD-62-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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 ('FJ-260105-0002','2026-01-05','0.880','2026-01-05','10:19:21','PLG0017833','933000','933000','0','933000','933000','sales','2026-01-05 10:19:21','FJ-260105-0001');
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-01-05','FJ-260105-0002','2026-01-05','10:19:21','2103','933000','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-260105-0005','D','2026-01-05','10:19:21','sales','PENJUALAN','FJ-260105-0002','96880076','933000','97813076','OPEN');
UPDATE tt_jual_head SET dibayar_rp='933000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260105-0002' 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,potong_rp) VALUES ('FJ-260105-0003','sales',' 1',' ','TOKO','BTCNMD','MDCN-YKXD-74-0','CN COR BT MK ','','0.770','1','100.00','816500','0','0','0','816500','0','0','0','816500','2103','00026580','MDCN','148500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-01-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-YKXD-74-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2026-01-05' AND kode_barang='MDCN-YKXD-74-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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 ('FJ-260105-0003','2026-01-05','0.770','2026-01-05','10:19:21','PLG0017834','816500','816500','0','816500','816500','sales','2026-01-05 10:19:21','FJ-260105-0001');
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-01-05','FJ-260105-0003','2026-01-05','10:19:21','2103','816500','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-260105-0006','D','2026-01-05','10:19:21','sales','PENJUALAN','FJ-260105-0003','97813076','816500','98629576','OPEN');
UPDATE tt_jual_head SET dibayar_rp='816500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260105-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260105-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260105-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260105-0003';
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,potong_rp) VALUES ('FJ-260105-0004','sales','1',' EX ','TOKO','BTKLMD','MDKL-YJAG-70-0','KL FANCY DB 42CM KKT PER SHB ','','2.870','1','100.00','3042500','0','0','0','3042500','0','0','0','3042500','2401','00026229','MDKL','148500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-01-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDKL-YJAG-70-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.870',berat_jual_asli=berat_jual_asli+'2.870',stock_jual='1',berat_akhir=berat_akhir-'2.870',berat_akhir_asli=berat_akhir_asli-'2.870',stock_akhir='0' WHERE tanggal='2026-01-05' AND kode_barang='MDKL-YJAG-70-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMD' 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 ('FJ-260105-0004','2026-01-05','2.870','2026-01-05','10:27:00','PLG0017835','3042500','3042500','0','3042500','0','sales','2026-01-05 10:26:59','FJ-260105-0004');
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-01-05','FJ-260105-0004','2026-01-05','10:27:00','2401','3042500','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260105-0001','2026-01-05','2026-01-05 10:26:59','PENJUALAN : FJ-260105-0004','bri','BCA','3042500','3042500','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260105-0002','D','2026-01-05','10:27:00','BCA','PENJUALAN','FJ-260105-0004','1543713385','3042500','1546755885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bri','LUTHFIYAH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3042500' WHERE no_faktur_jual='FJ-260105-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260105-0004';
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-00009120','X-00009120','CN COR BT UBS','GR','---','MDCN','BELI','BELI001','1841000','2026-01-05','2.020','1','sales','2026-01-05 10:42:33');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDCN','X-00009120','X-00009120');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260105-0002','FJ-251016-0004','2502','1','BELI','BELI001','MDCN', 'X-00009120', 'CN COR BT UBS','2.020','2.020','100.00','2000000','1841000','911386','1','1841000','1841000','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-05','BELI','BELI001','MDCN','MDCN','100.00','2.020','2.020','1','2.020','2.020','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,status_valid) VALUES ('FB-260105-0002','2026-01-05','2026-01-05','10:42:33','2502','---','2.020','1841000','1841000','1841000','1841000','1841000','sales','2026-01-05 10:42:33','FB-260105-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260105-0002','INAYAH','KARANG TEMBOK 1/21','','','','sales','2026-01-05 10:42:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-05' 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,status_valid) VALUES ('KK-260105-0007','K','2026-01-05','10:42:33','sales','PEMBELIAN UMUM','FB-260105-0002','98629576','1841000','96788576','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260105-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260105-0002';
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,potong_rp) VALUES ('FJ-260105-0005','sales','1',' EX ','TOKO','BTKLMD','MDKL-YKXE-99-0','KL FANCY DB PJG 64CM KKT S SHB ','','9.950','1','100.00','10547000','0','0','0','10547000','0','0','0','10547000','2106','00026811','MDKL','148500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-01-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDKL-YKXE-99-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'9.950',berat_jual_asli=berat_jual_asli+'9.950',stock_jual='1',berat_akhir=berat_akhir-'9.950',berat_akhir_asli=berat_akhir_asli-'9.950',stock_akhir='0' WHERE tanggal='2026-01-05' AND kode_barang='MDKL-YKXE-99-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMD' 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 ('FJ-260105-0005','2026-01-05','9.950','2026-01-05','11:33:59','PLG0017836','10547000','10547000','0','10547000','10547000','sales','2026-01-05 11:33:59','FJ-260105-0005');
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-01-05','FJ-260105-0005','2026-01-05','11:33:59','2106','10547000','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-260105-0008','D','2026-01-05','11:33:59','sales','PENJUALAN','FJ-260105-0005','96788576','10547000','107335576');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260105-0005';
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-260105-0009','K','2026-01-05','11:36:07','cashier1','PENGELUARAN','BELI AIR MINUM 3 GALON CLUB','107335576','51000','107284576');
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,potong_rp) VALUES ('FJ-260105-0006','sales','1',' ','TOKO','BTCNMD','MDCN-YKXD-83-0','CN COR BT MK ','','0.930','1','100.00','986000','0','0','0','986000','0','0','0','986000','2403','00026589','MDCN','148500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-01-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-YKXD-83-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2026-01-05' AND kode_barang='MDCN-YKXD-83-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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 ('FJ-260105-0006','2026-01-05','0.930','2026-01-05','11:38:23','PLG0017837','986000','986000','0','986000','986000','sales','2026-01-05 11:38:23','FJ-260105-0006');
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-01-05','FJ-260105-0006','2026-01-05','11:38:23','2403','986000','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-260105-0010','D','2026-01-05','11:38:23','sales','PENJUALAN','FJ-260105-0006','107284576','986000','108270576','OPEN');
UPDATE tt_jual_head SET dibayar_rp='986000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260105-0006' 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,potong_rp) VALUES ('FJ-260105-0007','sales',' 1',' EX ','TOKO','BTCNMD','MDCN-YKXD-99-0','CN COR BT MK ','','0.810','1','100.00','859000','0','0','0','859000','0','0','0','859000','2403','00026605','MDCN','148500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-01-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-YKXD-99-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-01-05' AND kode_barang='MDCN-YKXD-99-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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 ('FJ-260105-0007','2026-01-05','0.810','2026-01-05','11:38:23','PLG0017838','859000','859000','0','859000','859000','sales','2026-01-05 11:38:23','FJ-260105-0006');
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-01-05','FJ-260105-0007','2026-01-05','11:38:23','2403','859000','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-260105-0011','D','2026-01-05','11:38:23','sales','PENJUALAN','FJ-260105-0007','108270576','859000','109129576','OPEN');
UPDATE tt_jual_head SET dibayar_rp='859000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260105-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260105-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260105-0007';
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,potong_rp) VALUES ('FJ-260105-0008','sales','1',' EX ','TOKO','BTATMT','MTAT-YLCX-45-0','AT COR KLP TDK BT SHB ','','1.160','1','100.00','2117000','0','0','0','2117000','0','0','0','2117000','2106','00027068','MTAT','219000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-01-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-YLCX-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.160',berat_jual_asli=berat_jual_asli+'1.160',stock_jual='1',berat_akhir=berat_akhir-'1.160',berat_akhir_asli=berat_akhir_asli-'1.160',stock_akhir='0' WHERE tanggal='2026-01-05' AND kode_barang='MTAT-YLCX-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMT' 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 ('FJ-260105-0008','2026-01-05','1.160','2026-01-05','11:42:04','PLG0017839','2117000','2117000','0','2117000','2117000','sales','2026-01-05 11:42:04','FJ-260105-0008');
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-01-05','FJ-260105-0008','2026-01-05','11:42:04','2106','2117000','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-260105-0012','D','2026-01-05','11:42:04','sales','PENJUALAN','FJ-260105-0008','109129576','2117000','111246576');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260105-0008';
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,potong_rp) VALUES ('FJ-260105-0009','sales','1',' EX ','TOKO','BTKLMD','MDKL-YJAG-69-0','KL FANCY BL SLP 42CM KKT PER SHB ','','2.500','1','100.00','2650000','0','0','0','2650000','0','0','0','2650000','2403','00026228','MDKL','148500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-01-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDKL-YJAG-69-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2026-01-05' AND kode_barang='MDKL-YJAG-69-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMD' 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 ('FJ-260105-0009','2026-01-05','2.500','2026-01-05','11:51:17','PLG0017840','2650000','2650000','0','2650000','2650000','sales','2026-01-05 11:51:16','FJ-260105-0009');
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-01-05','FJ-260105-0009','2026-01-05','11:51:17','2403','2650000','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-260105-0013','D','2026-01-05','11:51:17','sales','PENJUALAN','FJ-260105-0009','111246576','2650000','113896576');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260105-0009';
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,potong_rp) VALUES ('FJ-260105-0010','sales','1',' ','TOKO','BTKLMT','MTKL-YGAE-83-0','KL CASTELI 43CM KKT S SHB ','','2.500','1','100.00','4562500','0','0','0','4562500','0','0','0','4562500','2502','00025805','MTKL','219000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-01-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTKL-YGAE-83-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2026-01-05' AND kode_barang='MTKL-YGAE-83-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMT' 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 ('FJ-260105-0010','2026-01-05','2.500','2026-01-05','14:36:06','PLG0017841','4562500','4562500','0','4562500','4562500','sales','2026-01-05 14:36:05','FJ-260105-0010');
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-01-05','FJ-260105-0010','2026-01-05','14:36:06','2502','4562500','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-260105-0014','D','2026-01-05','14:36:06','sales','PENJUALAN','FJ-260105-0010','113896576','4562500','118459076');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260105-0010';
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-00009121','X-00009121','CN COR ANAK TDK BT MK','GR','---','MTCN','BELI','BELI001','1220500','2026-01-05','0.760','1','sales','2026-01-05 14:38:09');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00009121','X-00009121');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260105-0003','FJ-241202-0003','2502','1','BELI','BELI001','MTCN', 'X-00009121', 'CN COR ANAK TDK BT MK','0.760','0.760','100.00','802000','1220500','1605921','1','1220500','1220500','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.760',berat_beli_asli=berat_beli_asli+'0.760',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.760',berat_akhir_asli=berat_akhir_asli+'0.760',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTCN' 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,status_valid) VALUES ('FB-260105-0003','2026-01-05','2026-01-05','14:38:08','2502','---','0.760','1220500','1220500','1220500','1220500','1220500','sales','2026-01-05 14:38:09','FB-260105-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260105-0003','NOVI','HANGTUAH 4/10','','','','sales','2026-01-05 14:38:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-05' 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,status_valid) VALUES ('KK-260105-0015','K','2026-01-05','14:38:08','sales','PEMBELIAN UMUM','FB-260105-0003','118459076','1220500','117238576','OPEN');
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-00009122','X-00009122','KL FANCY ANAK CAT 33CM KKT S MK','GR','---','MDKL','BELI','BELI001','1669000','2026-01-05','2.130','1','sales','2026-01-05 14:38:09');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDKL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDKL','X-00009122','X-00009122');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260105-0004','FJ-241106-0005','2502','2','BELI','BELI001','MDKL', 'X-00009122', 'KL FANCY ANAK CAT 33CM KKT S MK','2.180','2.130','100.00','1461000','1669000','783568','1','1669000','1669000','RUSAK BIASA');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.130',berat_beli_asli=berat_beli_asli+'2.130',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.130',berat_akhir_asli=berat_akhir_asli+'2.130',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDKL' 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,status_valid) VALUES ('FB-260105-0004','2026-01-05','2026-01-05','14:38:08','2502','---','2.130','1669000','1669000','1669000','1669000','1669000','sales','2026-01-05 14:38:09','FB-260105-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260105-0004','NOVI','HANG TUAH 4/10','','','','sales','2026-01-05 14:38:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-05' 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,status_valid) VALUES ('KK-260105-0016','K','2026-01-05','14:38:08','sales','PEMBELIAN UMUM','FB-260105-0004','117238576','1669000','115569576','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260105-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260105-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260105-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260105-0004';
UPDATE tm_credit_card SET nama_customer='BCA',no_ktp='',alamat1=' ' ,alamat2=' ' ,kota= ' ' ,no_telp='',tgl_valid_until='',tgl_last_gesek='2026-01-05 15:00:17' WHERE id_card = '5379413123114883';
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,potong_rp) VALUES ('FJ-260105-0011','sales','1',' PM ','TOKO','BTGLMD','MDGL-YCAC-45-0','GL ANAK ITALY ST SRT VAR CAT MN4 15CM KKT PER BLT UBS ','PM','2.540','1','100.00','2692500','0','0','0','2819500','127000','0','0','2819500','2401','00024122','MDGL','148500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-01-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-YCAC-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.540',berat_jual_asli=berat_jual_asli+'2.540',stock_jual='1',berat_akhir=berat_akhir-'2.540',berat_akhir_asli=berat_akhir_asli-'2.540',stock_akhir='0' WHERE tanggal='2026-01-05' AND kode_barang='MDGL-YCAC-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' 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 ('FJ-260105-0011','2026-01-05','2.540','2026-01-05','15:01:04','PLG0017842','2819500','2819500','0','2819500','2000000','sales','2026-01-05 15:01:02','FJ-260105-0011');
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-01-05','FJ-260105-0011','2026-01-05','15:01:04','2401','2819500','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-260105-0017','D','2026-01-05','15:01:04','sales','PENJUALAN','FJ-260105-0011','115569576','2000000','117569576','OPEN');
INSERT INTO tt_debet(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,debet_rp,debet_fee_rp) VALUES ('DC-260105-0001','2026-01-05','2026-01-05 15:01:02','PENJUALAN : FJ-260105-0011','5379413123114883','BCA','819500','819500','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260105-0003','D','2026-01-05','15:01:04','BCA','PENJUALAN','FJ-260105-0011','1546755885','819500','1547575385','DEBET');
UPDATE tt_jual_head SET dibayar_rp='2000000',debet_rp='819500',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260105-0011' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260105-0011';
UPDATE tm_credit_card SET nama_customer='BCA',no_ktp='',alamat1=' ' ,alamat2=' ' ,kota= ' ' ,no_telp='',tgl_valid_until='',tgl_last_gesek='2026-01-05 15:05:24' WHERE id_card = '5379413123114883';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-01-05 ','15:06:04');
UPDATE tm_credit_card SET nama_customer='BCA',no_ktp='',alamat1=' ' ,alamat2=' ' ,kota= ' ' ,no_telp='',tgl_valid_until='',tgl_last_gesek='2026-01-05 15:07:01' WHERE id_card = '5379413123114883';
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,potong_rp) VALUES ('FJ-260105-0012','sales','1',' ','TOKO','BTATMD','MDAT-YCAC-11-0','AT COR KLP TDK BT UBS ','','0.810','1','100.00','859000','0','0','0','859000','0','0','0','859000','2501','00024088','MDAT','148500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-01-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDAT-YCAC-11-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-01-05' AND kode_barang='MDAT-YCAC-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMD' 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 ('FJ-260105-0012','2026-01-05','0.810','2026-01-05','15:07:04','PLG0017843','859000','859000','0','859000','0','sales','2026-01-05 15:07:03','FJ-260105-0012');
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-01-05','FJ-260105-0012','2026-01-05','15:07:04','2501','859000','0');
INSERT INTO tt_debet(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,debet_rp,debet_fee_rp) VALUES ('DC-260105-0002','2026-01-05','2026-01-05 15:07:03','PENJUALAN : FJ-260105-0012','5379413123114883','BCA','859000','859000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260105-0004','D','2026-01-05','15:07:04','BCA','PENJUALAN','FJ-260105-0012','1547575385','859000','1548434385','DEBET');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='859000',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260105-0012' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260105-0012';
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-260105-0018','D','2026-01-05','15:08:23','cashier1','PEMASUKAN','POS MOKA','117569576','22500','117592076');
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,potong_rp) VALUES ('FJ-260105-0013','sales','1',' EX ','TOKO','BTCNMT','MTCN-YEXE-128-0','CN COR TDK BT SHB ','','3.600','1','100.00','6570000','0','0','0','6570000','0','0','0','6570000','2503','00024956','MTCN','219000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-01-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-YEXE-128-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.600',berat_jual_asli=berat_jual_asli+'3.600',stock_jual='1',berat_akhir=berat_akhir-'3.600',berat_akhir_asli=berat_akhir_asli-'3.600',stock_akhir='0' WHERE tanggal='2026-01-05' AND kode_barang='MTCN-YEXE-128-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMT' 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 ('FJ-260105-0013','2026-01-05','3.600','2026-01-05','15:48:53','PLG0017844','6570000','6570000','0','6570000','6570000','sales','2026-01-05 15:48:52','FJ-260105-0013');
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-01-05','FJ-260105-0013','2026-01-05','15:48:53','2503','6570000','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-260105-0019','D','2026-01-05','15:48:53','sales','PENJUALAN','FJ-260105-0013','117592076','6570000','124162076');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260105-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260105-0013';