INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-08 ','10:53:21');
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,keterangan) VALUES ('FE-260808-0001','kasir','1',' GBRE-01295','TOKO','GBR','GBRE-ZEBH-11-0','GELANG GBRE-01295 ','','3.800','1','103.00','15754000','5006000','277','18100','20000000','0','0','0','20000000','ONLBARRY','00043816','GBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='GBRE-ZEBH-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.800',berat_jual_asli=berat_jual_asli+'3.800',stock_jual='1',berat_akhir=berat_akhir-'3.800',berat_akhir_asli=berat_akhir_asli-'3.800',stock_akhir='0' WHERE tanggal='2026-08-08' AND kode_barang='GBRE-ZEBH-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='GBR' 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,no_persekot,dp_pesanan) VALUES ('FE-260808-0001','2026-08-08','3.800','2026-08-08','11:22:45','PLG0029253','20000000','20000000','0','20000000','0','kasir','2026-08-08 11:22:44','FE-260808-0001','','POTONG');
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-08-08','FE-260808-0001','2026-08-08','11:22:45','ONLBARRY','20000000','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-260808-0001','2026-08-08','2026-08-08 11:22:44','PENJUALAN : FE-260808-0001','.','TBC','20000000','20000000','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-260808-0002','D','2026-08-08','11:22:45','TBC','PENJUALAN BERLIAN','FE-260808-0001','105672563495','20000000','105692563495','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='20000000' WHERE no_faktur_jual='FE-260808-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260808-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260808-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260808-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,keterangan) VALUES ('FE-260808-0002','kasir','1',' DP-03075 ','TOKO','PSN','PSPRE-ZHXF-45-0','CINCIN PERAK ','','4.000','1','100.00','408000','0','0','18100','900000','0','0','0','900000','NANA','00045958','PSPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRE-ZHXF-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.000',berat_jual_asli=berat_jual_asli+'4.000',stock_jual='1',berat_akhir=berat_akhir-'4.000',berat_akhir_asli=berat_akhir_asli-'4.000',stock_akhir='0' WHERE tanggal='2026-08-08' AND kode_barang='PSPRE-ZHXF-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PSN' 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,no_persekot,dp_pesanan) VALUES ('FE-260808-0002','2026-08-08','4.000','2026-08-08','12:07:24','PLG0029254','900000','900000','0','900000','0','kasir','2026-08-08 12:07:23','FE-260808-0002','DP-03075','900000');
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-08-08','FE-260808-0002','2026-08-08','12:07:24','NANA','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FE-260808-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,keterangan) VALUES ('FE-260808-0003','kasir',' 1',' DP-03074 ','TOKO','PSN','PSPRE-ZHXD-21-0','CINCIN PERAK ','','2.650','1','100.00','271000','0','0','18100','1100000','0','0','0','1100000','NANA','00045860','PSPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRE-ZHXD-21-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.650',berat_jual_asli=berat_jual_asli+'2.650',stock_jual='1',berat_akhir=berat_akhir-'2.650',berat_akhir_asli=berat_akhir_asli-'2.650',stock_akhir='0' WHERE tanggal='2026-08-08' AND kode_barang='PSPRE-ZHXD-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PSN' 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,no_persekot,dp_pesanan) VALUES ('FE-260808-0003','2026-08-08','2.650','2026-08-08','12:07:24','PLG0029255','1100000','1100000','0','1100000','0','kasir','2026-08-08 12:07:23','FE-260808-0002','DP-03074','1100000');
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-08-08','FE-260808-0003','2026-08-08','12:07:24','NANA','1100000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FE-260808-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260808-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260808-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260808-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260808-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260808-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260808-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,keterangan) VALUES ('FE-260808-0004','kasir','1',' GLRRE75-85','TOKO','GLR','GLRR-ZEAA-37-0','GELANG RANTAI ROSE GOLD ','','4.550','1','85.00','9390000','0','0','18100','9500000','0','0','0','9500000','FAISAL','00043429','GLRR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='GLRR-ZEAA-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.550',berat_jual_asli=berat_jual_asli+'4.550',stock_jual='1',berat_akhir=berat_akhir-'4.550',berat_akhir_asli=berat_akhir_asli-'4.550',stock_akhir='0' WHERE tanggal='2026-08-08' AND kode_barang='GLRR-ZEAA-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='GLR' 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,no_persekot,dp_pesanan) VALUES ('FE-260808-0004','2026-08-08','4.550','2026-08-08','12:24:01','PLG0029256','9500000','9500000','0','9500000','0','kasir','2026-08-08 12:24:01','FE-260808-0004','','POTONG');
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-08-08','FE-260808-0004','2026-08-08','12:24:01','FAISAL','9500000','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-260808-0002','2026-08-08','2026-08-08 12:24:01','PENJUALAN : FE-260808-0004','.','TBC','9500000','9500000','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-260808-0003','D','2026-08-08','12:24:01','TBC','PENJUALAN','FE-260808-0004','105692563495','9500000','105702063495','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='9500000' WHERE no_faktur_jual='FE-260808-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260808-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260808-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260808-0004';
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03085','NANA','1','GOLD','WEDDING RING','','','3.000','','50.00','1','2310000','1800000','0','950000','6350000','size 9.5 grf Calvin ?? Bella','zirkonia 1 butir tengah besar sesuai cnth','zirkon kanan 6 kiri 6 crum putih glosy','0','200000','120000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260808-0003','2026-08-08','2026-08-08 13:00:25','PESANAN : DP-03085','.','TBC','3335000','3335000');
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-260808-0004','D','2026-08-08','13:00:25','TBC','PESANAN','DP-03085','105702063495','3335000','105705398495','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03085','2026-08-08','2026-08-08','13:00:25','PLG0029257','NANA','2026-08-29','kasir','2026-08-08 13:00:25','3.000','0','0','0','3335000','0','950000','6670000','6670000','3335000');
UPDATE tm_credit_card SET nama_customer='.',no_ktp='.',alamat1=' . ' ,alamat2=' . ' ,kota= ' . ' ,no_telp='.',tgl_valid_until='.',tgl_last_gesek='2026-08-08 13:08:16' WHERE id_card = '.';
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,keterangan) VALUES ('FE-260808-0005','kasir','1',' ABRE-01734','TOKO','ABR','ABRE-ZBXB-7-0','ANTING ABRE-01734 ','','5.770','1','75.00','15917000','4170500','230','18100','20500000','0','0','0','20500000','BARY','00041276','ABRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='ABRE-ZBXB-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.770',berat_jual_asli=berat_jual_asli+'5.770',stock_jual='1',berat_akhir=berat_akhir-'5.770',berat_akhir_asli=berat_akhir_asli-'5.770',stock_akhir='0' WHERE tanggal='2026-08-08' AND kode_barang='ABRE-ZBXB-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='ABR' 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,no_persekot,dp_pesanan) VALUES ('FE-260808-0005','2026-08-08','5.770','2026-08-08','13:08:18','PLG0029258','20500000','20500000','0','20500000','0','kasir','2026-08-08 13:08:17','FE-260808-0005','','POTONG');
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-08-08','FE-260808-0005','2026-08-08','13:08:18','BARY','20500000','0');
INSERT INTO tt_card(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,card_rp,card_fee_rp) VALUES ('CC-260808-0001','2026-08-08','2026-08-08 13:08:17','PENJUALAN : FE-260808-0005','.','BCK','20500000','20500000','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-260808-0002','D','2026-08-08','13:08:18','BCK','PENJUALAN BERLIAN','FE-260808-0005','16717892978.088','20500000','16738392978.088','CARD');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='20500000',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FE-260808-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260808-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260808-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260808-0005';
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03086','NANAONL','1','DM','WEDDING RING','','','2.500','','75.00','1','2310000','2200000','0','850000','6350000','size 9 kode lx038 EXPRES 200.000','rd 1/0.05ct dan rd 2/0.02ct','model sesuai cnth putih doff semprot','0','1750000','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260808-0004','2026-08-08','2026-08-08 14:10:50','PESANAN : DP-03086','.','TBC','3850000','3850000');
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-260808-0005','D','2026-08-08','14:10:50','TBC','PESANAN','DP-03086','105705398495','3850000','105709248495','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03086','2026-08-08','2026-08-08','14:10:50','PLG0029259','NANAONL','2026-08-19','kasir','2026-08-08 14:10:50','2.500','0','0','0','3850000','0','850000','8100000','8100000','4250000');
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-260808-0002','D','2026-08-08','14:49:43','kasir','KAS BESAR','AMBIL CASH BUAT BB','3157240','12500000','15657240');
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-00009363','X-00009363','CBRE-05975 GIA 7348829264','GR','---','CBRE','BELI','BELI001','14000000','2026-08-08','2.540','1','kasir','2026-08-08 14:50:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-CBRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBRE','X-00009363','X-00009363');
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 ('BE-260808-0001','FE-260510-0007','BARY','1','BELI','BELI001','CBRE', 'X-00009363', 'CBRE-05975 GIA 7348829264','2.540','2.540','75.00','17500000','14000000','5511811','1','14000000','14000000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.540',berat_beli_asli=berat_beli_asli+'2.540',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.540',berat_akhir_asli=berat_akhir_asli+'2.540',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CBRE' 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,type_bayar) VALUES ('BE-260808-0001','2026-08-08','2026-08-08','14:50:54','BARY','---','2.540','14000000','14000000','14000000','14000000','14000000','kasir','2026-08-08 14:50:54','BE-260808-0001','OPEN','CASH');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260808-0001','ZIYA','JAKARTA','','','0','kasir','2026-08-08 14:50:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-08' 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-260808-0003','K','2026-08-08','14:50:54','kasir','PEMBELIAN UMUM','BE-260808-0001','15657240','14000000','1657240','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260808-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260808-0001';
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-00009364','X-00009364','LOGAM MULIA','GR','---','LM','BELI','BELI001','61250000','2026-08-08','25.000','1','kasir','2026-08-08 15:39:07');
DELETE FROM tp_barang WHERE kode_dept = 'X-LM';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-LM','X-00009364','X-00009364');
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 ('BE-260808-0002','-','NANA','1','BELI','BELI001','LM', 'X-00009364', 'LOGAM MULIA','25.000','25.000','99.90','70000000','61250000','2450000','1','61250000','61250000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'25.000',berat_beli_asli=berat_beli_asli+'25.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'25.000',berat_akhir_asli=berat_akhir_asli+'25.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='LM' 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,type_bayar) VALUES ('BE-260808-0002','2026-08-08','2026-08-08','15:39:06','NANA','---','25.000','61250000','61250000','61250000','61250000','61250000','kasir','2026-08-08 15:39:07','BE-260808-0002','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260808-0002','DIAN','JKT','','JKT','','kasir','2026-08-08 15:39:07');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260808-0005','2026-08-08','2026-08-08 15:39:07','PEMBELIAN UMUM : BE-260808-0002','.','MANDIRI','61250000','61250000');
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 ('KK-260808-0002','K','2026-08-08','15:39:06','MANDIRI','PEMBELIAN UMUM','BE-260808-0002','295387450','61250000','234137450','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
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-00009365','X-00009365','LOGAM MULIA','GR','---','LM','BELI','BELI001','61250000','2026-08-08','25.000','1','kasir','2026-08-08 15:40:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-LM';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-LM','X-00009365','X-00009365');
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 ('BE-260808-0003','-','NANA','1','BELI','BELI001','LM', 'X-00009365', 'LOGAM MULIA','25.000','25.000','99.90','70000000','61250000','2450000','1','61250000','61250000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'25.000',berat_beli_asli=berat_beli_asli+'25.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'25.000',berat_akhir_asli=berat_akhir_asli+'25.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='LM' 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,type_bayar) VALUES ('BE-260808-0003','2026-08-08','2026-08-08','15:40:33','NANA','---','25.000','61250000','61250000','61250000','61250000','61250000','kasir','2026-08-08 15:40:34','BE-260808-0003','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260808-0003','DIAN','JKT','','JKT','','kasir','2026-08-08 15:40:34');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260808-0006','2026-08-08','2026-08-08 15:40:34','PEMBELIAN UMUM : BE-260808-0003','.','MANDIRI','61250000','61250000');
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 ('KK-260808-0003','K','2026-08-08','15:40:33','MANDIRI','PEMBELIAN UMUM','BE-260808-0003','234137450','61250000','172887450','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
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-00009366','X-00009366','LOGAM MULIA','GR','---','LM','BELI','BELI001','61250000','2026-08-08','25.000','1','kasir','2026-08-08 15:41:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-LM';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-LM','X-00009366','X-00009366');
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 ('BE-260808-0004','-','NANA','1','BELI','BELI001','LM', 'X-00009366', 'LOGAM MULIA','25.000','25.000','99.90','70000000','61250000','2450000','1','61250000','61250000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'25.000',berat_beli_asli=berat_beli_asli+'25.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'25.000',berat_akhir_asli=berat_akhir_asli+'25.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='LM' 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,type_bayar) VALUES ('BE-260808-0004','2026-08-08','2026-08-08','15:41:23','NANA','---','25.000','61250000','61250000','61250000','61250000','61250000','kasir','2026-08-08 15:41:24','BE-260808-0004','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260808-0004','DIAN','JKT','','JKT','','kasir','2026-08-08 15:41:24');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260808-0007','2026-08-08','2026-08-08 15:41:24','PEMBELIAN UMUM : BE-260808-0004','.','MANDIRI','61250000','61250000');
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 ('KK-260808-0004','K','2026-08-08','15:41:23','MANDIRI','PEMBELIAN UMUM','BE-260808-0004','172887450','61250000','111637450','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260808-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260808-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260808-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260808-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260808-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260808-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-08 ','15:55:34');
UPDATE tm_barang SET stock_on_hand='1' WHERE kode_barang='GBRE-ZEBH-11-0' AND kode_lokasi_toko='GBR' LIMIT 1;
UPDATE tt_jual_sales SET jml_jual_rp =jml_jual_rp-'20000000',ongkos_rp=ongkos_rp-'0' WHERE no_faktur_jual ='FE-260808-0001';
UPDATE tt_jual_head SET status_return = 'CLOS' WHERE no_faktur_jual ='FE-260808-0001';
UPDATE tt_barang_tukar SET status='CLOS' WHERE no_faktur_group='FE-260808-0001';
UPDATE tt_voucher_customer SET status='OPEN' WHERE no_voucher='-'
UPDATE tt_barang_saldo SET stock_jual=stock_jual-1, berat_jual = berat_jual-'3.8',berat_jual_asli = berat_jual_asli-'3.8', stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'3.8',berat_akhir_asli=berat_akhir_asli+'3.8' WHERE tanggal ='2026-08-08' AND kode_lokasi_toko ='GBR' AND kode_barang='GBRE-ZEBH-11-0' AND stock_jual*1 > 0 LIMIT 1;
INSERT INTO tt_jual_retur_detail(no_retur_jual,no_urut,no_faktur_jual,kode_barang,nama_barang,berat,harga,ongkos,jml_detail,kode_lokasi_toko,kode_dept,kadar,sales_id,alasan,harga_atribut) VALUES ('BJ-260808-0001','1','FE-260808-0001','GBRE-ZEBH-11-0','GELANG GBRE-01295 ','3.8','20000000.00','0','20000000','GBR','GBRE','103.00','kasir','SALAH INPUT','0');
DELETE FROM tt_jual_head WHERE no_faktur_jual ='FE-260808-0001' LIMIT 1;
DELETE FROM tt_jual_detail WHERE no_faktur_jual ='FE-260808-0001' LIMIT 1;
DELETE FROM tt_jual_sales WHERE no_faktur_jual ='FE-260808-0001' LIMIT 1;
INSERT INTO tt_jual_retur_head(no_retur_jual,tgl_system,tgl_retur_jual,kode_customer,dpp_netto_rp,jml_retur_rp,input_by,input_date)VALUES('BJ-260808-0001','2026-08-08','2026-08-08','PLG0029253','20000000','20000000','kasir','2026-08-08 16:01:51');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-08 ','16:03:07');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03087','NANA','1','GOLD','WEDDING RING','','','2.500','','50.00','1','2310000','1800000','0','850000','5350000','size 16.5 grf Romeo pakai zirkon 1 mata','model sesuai cnth putih doff semprot','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260808-0008','2026-08-08','2026-08-08 17:58:10','PESANAN : DP-03087','.','TBC','2675000','2675000');
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-260808-0006','D','2026-08-08','17:58:10','TBC','PESANAN','DP-03087','105709248495','2675000','105711923495','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03087','2026-08-08','2026-08-08','17:58:10','PLG0029260','NANA','2026-08-29','kasir','2026-08-08 17:58:10','2.500','0','0','0','2675000','0','850000','5350000','5350000','2675000');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03088','NANA','1','PLD','WEDDING RING','','','4.000','','10.00','1','1200000','350000','0','850000','2250000','size 175 grf Shaprilla pakai 1 mata zirkon','model sesuai cnth putih doff semprot','lebar sesuai cnth','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260808-0009','2026-08-08','2026-08-08 18:02:39','PESANAN : DP-03088','.','TBC','125000','125000');
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-260808-0007','D','2026-08-08','18:02:39','TBC','PESANAN','DP-03088','105711923495','125000','105712048495','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03088','2026-08-08','2026-08-08','18:02:39','PLG0029261','NANA','2026-08-29','kasir','2026-08-08 18:02:39','4.000','1000000','0','0','125000','0','850000','2250000','2250000','1125000');
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-260808-0004','D','2026-08-08','18:02:39','kasir','PESANAN','DP-03088','1657240','1000000','2657240');
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,keterangan) VALUES ('FE-260808-0006','kasir','1',' CBRE-06361','TOKO','CBR','CBRE-ZGBI-10-0','CBRE-06361 GIA 2464967889 ','','2.830','1','75.00','20490000','13575000','750','18100','22000000','0','0','0','22000000','NANA','00045711','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZGBI-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.830',berat_jual_asli=berat_jual_asli+'2.830',stock_jual='1',berat_akhir=berat_akhir-'2.830',berat_akhir_asli=berat_akhir_asli-'2.830',stock_akhir='0' WHERE tanggal='2026-08-08' AND kode_barang='CBRE-ZGBI-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' 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,no_persekot,dp_pesanan) VALUES ('FE-260808-0006','2026-08-08','2.830','2026-08-08','19:20:12','PLG0029262','22000000','22000000','0','22000000','0','kasir','2026-08-08 19:20:12','FE-260808-0006','','POTONG');
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-08-08','FE-260808-0006','2026-08-08','19:20:12','NANA','22000000','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-260808-0010','2026-08-08','2026-08-08 19:20:12','PENJUALAN : FE-260808-0006','.','TBC','22000000','22000000','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-260808-0008','D','2026-08-08','19:20:12','TBC','PENJUALAN BERLIAN','FE-260808-0006','105712048495','22000000','105734048495','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='22000000' WHERE no_faktur_jual='FE-260808-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260808-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260808-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260808-0006';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-08 ','20:02:29');
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,keterangan) VALUES ('FE-260808-0007','kasir','1',' CBRE-07045','TOKO','CBR','CBRE-ZGBI-14-0','CINCIN CBRE-07045 ','','3.220','1','75.00','16840000','9560500','528','18100','18500000','0','0','0','18500000','NANA','00045715','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZGBI-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.220',berat_jual_asli=berat_jual_asli+'3.220',stock_jual='1',berat_akhir=berat_akhir-'3.220',berat_akhir_asli=berat_akhir_asli-'3.220',stock_akhir='0' WHERE tanggal='2026-08-08' AND kode_barang='CBRE-ZGBI-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' 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,no_persekot,dp_pesanan) VALUES ('FE-260808-0007','2026-08-08','3.220','2026-08-08','20:03:19','PLG0029263','18500000','18500000','0','18500000','0','kasir','2026-08-08 20:03:19','FE-260808-0007','','POTONG');
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-08-08','FE-260808-0007','2026-08-08','20:03:19','NANA','18500000','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-260808-0011','2026-08-08','2026-08-08 20:03:19','PENJUALAN : FE-260808-0007','.','TBC','18500000','18500000','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-260808-0009','D','2026-08-08','20:03:19','TBC','PENJUALAN BERLIAN','FE-260808-0007','105734048495','18500000','105752548495','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='18500000' WHERE no_faktur_jual='FE-260808-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260808-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260808-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260808-0007';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-08 ','20:10:36');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-09','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-09';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-08';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-08';
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-08-08' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-08';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-08';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-08';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-08';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-09' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-08' 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-260809-0001','D','2026-08-09','20:31:27','TBC','SALDO AWAL','SALDO AWAL','0','105752548495','105752548495');
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-260809-0001','D','2026-08-09','20:31:27','MANDIRI','SALDO AWAL','SALDO AWAL','0','111637450','111637450');
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-260809-0001','D','2026-08-09','20:31:27','BCK','SALDO AWAL','SALDO AWAL','0','16738392978.088','16738392978.088');
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-260809-0001','D','2026-08-09','20:31:27','BCD','SALDO AWAL','SALDO AWAL','0','15150321700','15150321700');
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-260809-0001','D','2026-08-09','20:31:27','DPE','SALDO AWAL','SALDO AWAL','0','228362000','228362000');
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-260809-0001','D','2026-08-09','20:31:27','','SALDO AWAL','SALDO AWAL','0','16885500','16885500');
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-260809-0001','D','2026-08-09','20:31:27','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250');
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-260809-0001','D','2026-08-09','20:31:27','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581');
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-260809-0001','D','2026-08-09','20:31:27','6000000','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-260809-0001','D','2026-08-09','20:31:27','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000');
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-260809-0001','D','2026-08-09','20:31:27','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000');
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-260809-0001','D','2026-08-09','20:31:27','BCA','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-260809-0001','D','2026-08-09','20:31:27','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092');
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-260809-0001','D','2026-08-09','20:31:27','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000');
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-260809-0001','D','2026-08-09','20:31:27','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000');
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-260809-0001','D','2026-08-09','20:31:27','3450000','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-260809-0001','D','2026-08-09','20:31:27','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000');
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-260809-0001','D','2026-08-09','20:31:27','4000000','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-260809-0001','D','2026-08-09','20:31:27','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000');
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-260809-0001','D','2026-08-09','20:31:27','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000');
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-260809-0001','D','2026-08-09','20:31:27','BNI','SALDO AWAL','SALDO AWAL','0','84527900','84527900');
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-260809-0001','D','2026-08-09','20:31:27','SHO','SALDO AWAL','SALDO AWAL','0','2758505684','2758505684');
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-260809-0001','D','2026-08-09','20:31:27','TMR','SALDO AWAL','SALDO AWAL','0','8831983779','8831983779');
UPDATE tp_system SET tgl_system='2026-08-09';