INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-22 ','10:02:14');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-22 ','10:05:31');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-22 ','10:53:42');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08312','FAISAL','1','CKS','PASANG MATA ZIRKON DAN CROM PUTIH','2.140','1','100000','100000');
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-260822-0001','2026-08-22','2026-08-22 11:21:18','SERVICE : SV-08312','-','TBC','100000','100000','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-260822-0002','D','2026-08-22','11:21:18','TBC','SERVICE','SV-08312','106036773495','100000','106036873495','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','-');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-08312','2026-08-22','2026-08-22','11:21:18','PLG0029357','kasir','2026-08-25','kasir','2026-08-22 11:21:18','2.140','0','0','0','100000','0','100000','100000','0');
UPDATE tt_service_head SET tgl_selesai='2026-08-22',  status ='DONE' WHERE no_service='SV-08309';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-08309';
UPDATE tt_service_head SET tgl_selesai='2026-08-22',  status ='DONE' WHERE no_service='SV-08307';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-08307';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-08-22',  status ='CLOS' WHERE no_service='SV-08307';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-08307';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-08-22',  status ='CLOS' WHERE no_service='SV-08309';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-08309';
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-260822-0002','D','2026-08-22','12:05:39','kasir','REPARASI','SV08307','6635240','400000','7035240');
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-00009380','X-00009380','GIWANG ABRE-02028','GR','---','ABRE','BELI','BELI001','8320000','2026-08-22','1.760','1','kasir','2026-08-22 12:30:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-ABRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-ABRE','X-00009380','X-00009380');
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-260822-0001','FE-260222-0001','BARY','1','BELI','BELI001','ABRE', 'X-00009380', 'GIWANG ABRE-02028','1.760','1.760','75.00','10400000','8320000','4727273','1','8320000','8320000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.760',berat_beli_asli=berat_beli_asli+'1.760',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.760',berat_akhir_asli=berat_akhir_asli+'1.760',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='ABRE' 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-260822-0001','2026-08-22','2026-08-22','12:30:46','BARY','---','1.760','8320000','8320000','8320000','8320000','8320000','kasir','2026-08-22 12:30:46','BE-260822-0001','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260822-0001','AINI FATMAWATI','JKT','','','0','kasir','2026-08-22 12:30:46');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260822-0002','2026-08-22','2026-08-22 12:30:46','PEMBELIAN UMUM : BE-260822-0001','-','TBC','8320000','8320000');
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-260822-0003','K','2026-08-22','12:30:46','TBC','PEMBELIAN UMUM','BE-260822-0001','106036873495','8320000','106028553495','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-22 ','12:30:54');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260822-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260822-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-00009381','X-00009381','CINCIN CBRE-06087','GR','---','CBRE','BELI','BELI001','16250000','2026-08-22','6.240','1','kasir','2026-08-22 13:43:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-CBRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBRE','X-00009381','X-00009381');
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-260822-0002','FE-240606-0007','BARY','1','BELI','BELI001','CBRE', 'X-00009381', 'CINCIN CBRE-06087','6.240','6.240','75.00','20500000','16250000','2604167','1','16250000','16250000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'6.240',berat_beli_asli=berat_beli_asli+'6.240',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'6.240',berat_akhir_asli=berat_akhir_asli+'6.240',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-22' 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-260822-0002','2026-08-22','2026-08-22','13:43:58','BARY','---','6.240','16250000','16250000','16250000','16250000','16250000','kasir','2026-08-22 13:43:59','BE-260822-0002','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260822-0002','PUTRI RETNO','-','','','-','kasir','2026-08-22 13:43:59');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260822-0003','2026-08-22','2026-08-22 13:43:59','PEMBELIAN UMUM : BE-260822-0002','-','TBC','16250000','16250000');
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-260822-0004','K','2026-08-22','13:43:58','TBC','PEMBELIAN UMUM','BE-260822-0002','106028553495','16250000','106012303495','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-00009382','X-00009382','GBRE-00681 GIA 5778 8369 8377','GR','---','GBRE','BELI','BELI001','23200000','2026-08-22','7.540','1','kasir','2026-08-22 13:45:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-GBRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-GBRE','X-00009382','X-00009382');
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-260822-0003','FE-240606-0006','BARY','1','BELI','BELI001','GBRE', 'X-00009382', 'GBRE-00681 GIA 5778 8369 8377','7.540','7.540','75.00','29000000','23200000','3076923','1','23200000','23200000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'7.540',berat_beli_asli=berat_beli_asli+'7.540',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'7.540',berat_akhir_asli=berat_akhir_asli+'7.540',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='GBRE' 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-260822-0003','2026-08-22','2026-08-22','13:45:17','BARY','---','7.540','23200000','23200000','23200000','23200000','23200000','kasir','2026-08-22 13:45:17','BE-260822-0003','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260822-0003','PUTRI RETNO','-','','','-','kasir','2026-08-22 13:45:17');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260822-0004','2026-08-22','2026-08-22 13:45:17','PEMBELIAN UMUM : BE-260822-0003','-','TBC','23200000','23200000');
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-260822-0005','K','2026-08-22','13:45:17','TBC','PEMBELIAN UMUM','BE-260822-0003','106012303495','23200000','105989103495','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260822-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260822-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260822-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260822-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-260822-0001','kasir','1',' GLRRE75-83','TOKO','GLR','GLRR-XIXF-16-0','GELANG RANTAI ROSE GOLD ','','5.340','1','83.00','10744000','0','0','18000','11200000','0','0','0','11200000','FAISAL','00031136','GLRR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='GLRR-XIXF-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.340',berat_jual_asli=berat_jual_asli+'5.340',stock_jual='1',berat_akhir=berat_akhir-'5.340',berat_akhir_asli=berat_akhir_asli-'5.340',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='GLRR-XIXF-16-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-260822-0001','2026-08-22','5.340','2026-08-22','13:50:34','PLG0029358','11200000','11200000','0','11200000','11200000','kasir','2026-08-22 13:50:34','FE-260822-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-22','FE-260822-0001','2026-08-22','13:50:34','FAISAL','11200000','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-260822-0003','D','2026-08-22','13:50:34','kasir','PENJUALAN','FE-260822-0001','7035240','11200000','18235240');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260822-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260822-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260822-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-260822-0002','kasir','1',' CBRE-06353','TOKO','CBR','CBRE-ZGXH-14-0','CBRE-06353 GIA 1498018633 ','','1.620','1','75.00','10633000','6750000','375','18000','13600000','0','0','0','13600000','BARY','00045059','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZGXH-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.620',berat_jual_asli=berat_jual_asli+'1.620',stock_jual='1',berat_akhir=berat_akhir-'1.620',berat_akhir_asli=berat_akhir_asli-'1.620',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='CBRE-ZGXH-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-260822-0002','2026-08-22','1.620','2026-08-22','15:41:16','PLG0029359','13600000','13600000','0','13600000','0','kasir','2026-08-22 15:41:16','FE-260822-0002','','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-22','FE-260822-0002','2026-08-22','15:41:16','BARY','13600000','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-260822-0005','2026-08-22','2026-08-22 15:41:16','PENJUALAN : FE-260822-0002','','TBC','13600000','13600000','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-260822-0006','D','2026-08-22','15:41:16','TBC','PENJUALAN BERLIAN','FE-260822-0002','105989103495','13600000','106002703495','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='13600000' WHERE no_faktur_jual='FE-260822-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-260822-0003','kasir','1',' CMPE75-85%','TOKO','CMP','CMP-YHAE-96-0','CINCIN MAS PUTIH ','','0.670','1','85.00','1395000','0','0','18000','1400000','0','0','0','1400000','ILU','00038138','CMP','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CMP-YHAE-96-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='CMP-YHAE-96-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CMP' 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-260822-0003','2026-08-22','0.670','2026-08-22','15:42:01','PLG0029360','1400000','1400000','0','1400000','0','kasir','2026-08-22 15:42:01','FE-260822-0003','','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-22','FE-260822-0003','2026-08-22','15:42:01','ILU','1400000','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-260822-0006','2026-08-22','2026-08-22 15:42:01','PENJUALAN : FE-260822-0003','','TBC','1400000','1400000','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-260822-0007','D','2026-08-22','15:42:01','TBC','PENJUALAN','FE-260822-0003','106002703495','1400000','106004103495','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='1400000' WHERE no_faktur_jual='FE-260822-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260822-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260822-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260822-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260822-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260822-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260822-0003';
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-260822-0004','K','2026-08-22','18:17:33','kasir','KAS BESAR','UANG PARKIR MITA','18235240','50000','18185240');
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-260822-0005','K','2026-08-22','18:17:48','kasir','KIRIM PAKET','JNE MEDAN','18185240','69000','18116240');
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-260822-0006','K','2026-08-22','18:18:05','kasir','KIRIM PAKET','JNE MEDAN','18116240','60000','18056240');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08313','NANA','1','CINCIN NIKAH SILVER','CROM KUNING SEMUA NYA','5.470','1','100000','100000');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-08313','2026-08-22','2026-08-22','18:43:16','PLG0029361','kasir','2026-08-25','kasir','2026-08-22 18:43:16','5.470','0','0','0','0','0','100000','100000','100000');
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-260822-0004','kasir','1',' 700K-14-80','TOKO','PERAK','CKPRE-YHBH-28-0','CINCIN SILVER 925 ','','1.430','1','100.00','146000','0','0','18000','450000','0','0','0','450000','NANA','00038340','CKPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-YHBH-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.430',berat_jual_asli=berat_jual_asli+'1.430',stock_jual='1',berat_akhir=berat_akhir-'1.430',berat_akhir_asli=berat_akhir_asli-'1.430',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='CKPRE-YHBH-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PERAK' 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-260822-0004','2026-08-22','1.430','2026-08-22','19:27:15','PLG0029362','450000','450000','0','450000','0','kasir','2026-08-22 19:27:15','FE-260822-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-22','FE-260822-0004','2026-08-22','19:27:15','NANA','450000','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-260822-0007','2026-08-22','2026-08-22 19:27:15','PENJUALAN : FE-260822-0004','..','TBC','450000','450000','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-260822-0008','D','2026-08-22','19:27:15','TBC','PENJUALAN','FE-260822-0004','106004103495','450000','106004553495','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='450000' WHERE no_faktur_jual='FE-260822-0004' 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-260822-0005','kasir',' 1',' 500K-175-1','TOKO','PERAK','CKPRE-ZEBE-10-0','CINCIN SILVER 925 YL-01','','2.030','1','100.00','208000','0','0','18000','400000','0','0','0','400000','NANA','00043771','CKPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-ZEBE-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-08-22' AND kode_barang='CKPRE-ZEBE-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PERAK' 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-260822-0005','2026-08-22','2.030','2026-08-22','19:27:15','PLG0029363','400000','400000','0','400000','0','kasir','2026-08-22 19:27:15','FE-260822-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-22','FE-260822-0005','2026-08-22','19:27:15','NANA','400000','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-260822-0008','2026-08-22','2026-08-22 19:27:15','PENJUALAN : FE-260822-0005','..','TBC','400000','400000','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-260822-0009','D','2026-08-22','19:27:15','TBC','PENJUALAN','FE-260822-0005','106004553495','400000','106004953495','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='850000' WHERE no_faktur_jual='FE-260822-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260822-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260822-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260822-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260822-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260822-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260822-0005';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08314','NANA','1','PERAK','CWE GRF RIZKY KAHARUDIN CRUM PUTIH GLOSY CWO RESIZE KE 14 GRF MALIKA HALDA CRUM PUTIH DOFF AMPLAS','3.460','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-08314','2026-08-22','2026-08-22','19:30:44','PLG0029364','kasir','2026-08-25','kasir','2026-08-22 19:30:44','3.460','0','0','0','0','0','0','0','0');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-23','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-23';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-22';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-22';
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-22' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-22';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-22';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-22';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-22';
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-23' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-22' 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-260823-0001','D','2026-08-23','20:10:27','TBC','SALDO AWAL','SALDO AWAL','0','106004953495','106004953495');
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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10: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-260823-0001','D','2026-08-23','20:10:27','TMR','SALDO AWAL','SALDO AWAL','0','8897983779','8897983779');
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-260823-0001','D','2026-08-23','20:10:27','BCD','SALDO AWAL','SALDO AWAL','0','15157321700','15157321700');
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-260823-0001','D','2026-08-23','20:10:27','BCK','SALDO AWAL','SALDO AWAL','0','16768392978.088','16768392978.088');
UPDATE tp_system SET tgl_system='2026-08-23';