INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-01-11 ','11:02:46');
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-00009001','X-00009001','GBRE00314','GR','---','GBRE','BELI','BELI001','28800000','2026-01-11','10.980','1','kasir','2026-01-11 11:25:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-GBRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-GBRE','X-00009001','X-00009001');
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-260111-0001','FE-221124-0013','BARY','1','BELI','BELI001','GBRE', 'X-00009001', 'GBRE00314','10.980','10.980','75.00','36000000','28800000','2622951','1','28800000','28800000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'10.980',berat_beli_asli=berat_beli_asli+'10.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'10.980',berat_akhir_asli=berat_akhir_asli+'10.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-11' 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-260111-0001','2026-01-11','2026-01-11','11:25:29','BARY','---','10.980','28800000','28800000','28800000','28800000','28800000','kasir','2026-01-11 11:25:30','BE-260111-0001','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260111-0001','ADE HILDA','JKT','JKT','','082320072283','kasir','2026-01-11 11:25:30');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260111-0001','2026-01-11','2026-01-11 11:25:30','PEMBELIAN UMUM : BE-260111-0001','-','TBC','28800000','28800000');
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-260111-0002','K','2026-01-11','11:25:29','TBC','PEMBELIAN UMUM','BE-260111-0001','94388673685','28800000','94359873685','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260111-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260111-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-260111-0001','kasir','1',' CKBE-01014','TOKO','CKB','CKBE-XJXB-24-0','CINCIN KAWIN CKBE-01014','','2.410','1','83.00','6210000','563000','33','16875','8400000','0','0','0','8400000','FAISAL','00031580','CKBE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKBE-XJXB-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.410',berat_jual_asli=berat_jual_asli+'2.410',stock_jual='1',berat_akhir=berat_akhir-'2.410',berat_akhir_asli=berat_akhir_asli-'2.410',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='CKBE-XJXB-24-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CKB' 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-260111-0001','2026-01-11','2.410','2026-01-11','11:52:57','PLG0027735','8400000','8400000','0','8400000','0','kasir','2026-01-11 11:52:56','FE-260111-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-01-11','FE-260111-0001','2026-01-11','11:52:57','FAISAL','8400000','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-260111-0002','2026-01-11','2026-01-11 11:52:56','PENJUALAN : FE-260111-0001','.','TBC','8400000','8400000','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-260111-0003','D','2026-01-11','11:52:57','TBC','PENJUALAN BERLIAN','FE-260111-0001','94359873685','8400000','94368273685','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='8400000' WHERE no_faktur_jual='FE-260111-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,keterangan) VALUES ('FE-260111-0002','kasir',' 1',' 700K-23-76','TOKO','PERAK','CKPRE-YHXE-26-0','CINCIN SILVER 925 ','','3.380','1','100.00','87000','0','0','16875','700000','0','0','0','700000','FAISAL','00037876','CKPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-YHXE-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.380',berat_jual_asli=berat_jual_asli+'3.380',stock_jual='1',berat_akhir=berat_akhir-'3.380',berat_akhir_asli=berat_akhir_asli-'3.380',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='CKPRE-YHXE-26-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-260111-0002','2026-01-11','3.380','2026-01-11','11:52:57','PLG0027736','700000','700000','0','700000','0','kasir','2026-01-11 11:52:56','FE-260111-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-01-11','FE-260111-0002','2026-01-11','11:52:57','FAISAL','700000','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-260111-0003','2026-01-11','2026-01-11 11:52:56','PENJUALAN : FE-260111-0002','.','TBC','700000','700000','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-260111-0004','D','2026-01-11','11:52:57','TBC','PENJUALAN','FE-260111-0002','94368273685','700000','94368973685','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='9100000' WHERE no_faktur_jual='FE-260111-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260111-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260111-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260111-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260111-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260111-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260111-0002';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-07962','FAISAL','1','SLV DAN CKB01014','KEDUANYA GRF LISA NANANG HURUF BESAR SEMUA CKB TETEP WARNA ROSE GOLD FULL DAN SLV CRUM PUTIH DOFF SEMPROT SETENGAH','5.790','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-07962','2026-01-11','2026-01-11','11:58:52','PLG0027737','kasir','2026-01-13','kasir','2026-01-11 11:58:52','5.790','0','0','0','0','0','0','0','0');
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-260111-0003','kasir','1',' CBR0926 ','TOKO','CBR','CBRE-YKBD-34-0','CINCIN CBR0926 ','','5.730','1','75.00','15589000','3780000','224','16875','17500000','0','0','0','17500000','ILUNG','00039806','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-YKBD-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.730',berat_jual_asli=berat_jual_asli+'5.730',stock_jual='1',berat_akhir=berat_akhir-'5.730',berat_akhir_asli=berat_akhir_asli-'5.730',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='CBRE-YKBD-34-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-260111-0003','2026-01-11','5.730','2026-01-11','12:11:53','PLG0027738','17500000','17500000','0','17500000','0','kasir','2026-01-11 12:11:52','FE-260111-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-01-11','FE-260111-0003','2026-01-11','12:11:53','ILUNG','17500000','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-260111-0004','2026-01-11','2026-01-11 12:11:52','PENJUALAN : FE-260111-0003','','TBC','17500000','17500000','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-260111-0005','D','2026-01-11','12:11:53','TBC','PENJUALAN BERLIAN','FE-260111-0003','94368973685','17500000','94386473685','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='17500000' WHERE no_faktur_jual='FE-260111-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260111-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260111-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260111-0003';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-07963','ILU','1','CBR0926','JD NO 18 CROM KOMBINASI HARGA KONFIRMASI','5.730','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-07963','2026-01-11','2026-01-11','12:21:50','PLG0027739','kasir','2026-01-13','kasir','2026-01-11 12:21:50','5.730','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-01-11 ','12:32:47');
UPDATE tt_service_head SET tgl_selesai='2026-01-11',  status ='DONE' WHERE no_service='SV-07943';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-07943';
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-01-11',  status ='CLOS' WHERE no_service='SV-07943';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-07943';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-07964','ILU','1','ABRE01531','CROM ULANG PUTIH','3.470','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-07964','2026-01-11','2026-01-11','12:35:07','PLG0027740','kasir','2026-01-13','kasir','2026-01-11 12:35:07','3.470','0','0','0','0','0','0','0','0');
UPDATE tm_credit_card SET nama_customer='-',no_ktp='-',alamat1=' - ' ,alamat2=' - ' ,kota= ' - ' ,no_telp='-',tgl_valid_until='-',tgl_last_gesek='2026-01-11 13:58:47' 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-260111-0004','kasir','1',' CBRE-03965','TOKO','CBR','CBRE-YLXE-28-0','CINCIN CBRE-03965 ','','2.260','1','75.00','6796000','2079000','123','16875','8000000','0','0','0','8000000','BARY','00040363','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-YLXE-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.260',berat_jual_asli=berat_jual_asli+'2.260',stock_jual='1',berat_akhir=berat_akhir-'2.260',berat_akhir_asli=berat_akhir_asli-'2.260',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='CBRE-YLXE-28-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-260111-0004','2026-01-11','2.260','2026-01-11','13:58:51','PLG0027741','8000000','8000000','0','8000000','0','kasir','2026-01-11 13:58:49','FE-260111-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-01-11','FE-260111-0004','2026-01-11','13:58:51','BARY','8000000','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-260111-0001','2026-01-11','2026-01-11 13:58:49','PENJUALAN : FE-260111-0004','','BCK','8000000','8000000','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-260111-0002','D','2026-01-11','13:58:51','BCK','PENJUALAN BERLIAN','FE-260111-0004','16290407978.088','8000000','16298407978.088','CARD');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='8000000',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FE-260111-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260111-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260111-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260111-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-00009002','X-00009002','CBRE03117','GR','---','CBRE','BELI','BELI001','2195000','2026-01-11','1.110','1','kasir','2026-01-11 14:08:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-CBRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBRE','X-00009002','X-00009002');
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-260111-0002','FE-220228-0015','BARY','1','BELI','BELI001','CBRE', 'X-00009002', 'CBRE03117','1.110','1.110','75.00','2900000','2195000','1977477','1','2195000','2195000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.110',berat_beli_asli=berat_beli_asli+'1.110',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.110',berat_akhir_asli=berat_akhir_asli+'1.110',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-11' 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-260111-0002','2026-01-11','2026-01-11','14:08:40','BARY','---','1.110','2195000','2195000','2195000','2195000','2195000','kasir','2026-01-11 14:08:41','BE-260111-0002','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260111-0002','DIAH','JAKARTA','-','JAKARTA','085216137026','kasir','2026-01-11 14:08:41');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260111-0005','2026-01-11','2026-01-11 14:08:41','PEMBELIAN UMUM : BE-260111-0002','-','TBC','2195000','2195000');
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-260111-0006','K','2026-01-11','14:08:40','TBC','PEMBELIAN UMUM','BE-260111-0002','94386473685','2195000','94384278685','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260111-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260111-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,keterangan) VALUES ('FE-260111-0005','kasir','1',' ABRE-02022','TOKO','ABR','ABRE-YFAX-6-0','GIWANG ABRE-02022','','1.340','1','83.00','4816000','1497500','89','16875','6000000','0','0','0','6000000','ONLILUNG','00036242','ABRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='ABRE-YFAX-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.340',berat_jual_asli=berat_jual_asli+'1.340',stock_jual='1',berat_akhir=berat_akhir-'1.340',berat_akhir_asli=berat_akhir_asli-'1.340',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='ABRE-YFAX-6-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-260111-0005','2026-01-11','1.340','2026-01-11','14:52:09','PLG0027742','6000000','6000000','0','6000000','0','kasir','2026-01-11 14:52:08','FE-260111-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-01-11','FE-260111-0005','2026-01-11','14:52:09','ONLILUNG','6000000','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-260111-0006','2026-01-11','2026-01-11 14:52:08','PENJUALAN : FE-260111-0005','','TBC','6000000','6000000','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-260111-0007','D','2026-01-11','14:52:09','TBC','PENJUALAN BERLIAN','FE-260111-0005','94384278685','6000000','94390278685','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='6000000' WHERE no_faktur_jual='FE-260111-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260111-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260111-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260111-0005';
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-260111-0006','kasir','1',' ABRE-02072','TOKO','ABR','ABRE-YHAE-11-0','GIWANG ABRE-02072','','1.200','1','103.00','5802000','2285000','135','16875','7100000','0','0','0','7100000','NANA','00038053','ABRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='ABRE-YHAE-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='ABRE-YHAE-11-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-260111-0006','2026-01-11','1.200','2026-01-11','15:08:18','PLG0027743','7100000','7100000','0','7100000','0','kasir','2026-01-11 15:08:18','FE-260111-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-01-11','FE-260111-0006','2026-01-11','15:08:18','NANA','7100000','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-260111-0007','2026-01-11','2026-01-11 15:08:18','PENJUALAN : FE-260111-0006','','TBC','7100000','7100000','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-260111-0008','D','2026-01-11','15:08:18','TBC','PENJUALAN BERLIAN','FE-260111-0006','94390278685','7100000','94397378685','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='7100000' WHERE no_faktur_jual='FE-260111-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260111-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260111-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260111-0006';
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-00009003','X-00009003','ABRE00098','GR','---','ABR','BELI','BELI001','3976000','2026-01-11','1.830','1','kasir','2026-01-11 15:13:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-ABR';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-ABR','X-00009003','X-00009003');
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-260111-0003','','NANA','1','BELI','BELI001','ABR', 'X-00009003', 'ABRE00098','1.830','1.830','75.00','4970000','3976000','2172678','1','3976000','3976000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.830',berat_beli_asli=berat_beli_asli+'1.830',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.830',berat_akhir_asli=berat_akhir_asli+'1.830',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='ABR' 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-260111-0003','2026-01-11','2026-01-11','15:13:45','NANA','---','1.830','3976000','3976000','3976000','3976000','3976000','kasir','2026-01-11 15:13:45','BE-260111-0003','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260111-0003','FARINA','JKT','','JKT','0','kasir','2026-01-11 15:13:45');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260111-0008','2026-01-11','2026-01-11 15:13:45','PEMBELIAN UMUM : BE-260111-0003','-','TBC','3976000','3976000');
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-260111-0009','K','2026-01-11','15:13:45','TBC','PEMBELIAN UMUM','BE-260111-0003','94397378685','3976000','94393402685','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-00009004','X-00009004','LBRE00024','GR','---','LBR','BELI','BELI001','3600000','2026-01-11','1.140','1','kasir','2026-01-11 15:15:32');
DELETE FROM tp_barang WHERE kode_dept = 'X-LBR';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-LBR','X-00009004','X-00009004');
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-260111-0004','-','NANA','1','BELI','BELI001','LBR', 'X-00009004', 'LBRE00024','1.140','1.140','75.00','4500000','3600000','3157895','1','3600000','3600000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.140',berat_beli_asli=berat_beli_asli+'1.140',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.140',berat_akhir_asli=berat_akhir_asli+'1.140',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='LBR' 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-260111-0004','2026-01-11','2026-01-11','15:15:31','NANA','---','1.140','3600000','3600000','3600000','3600000','3600000','kasir','2026-01-11 15:15:32','BE-260111-0004','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260111-0004','FARINA','JKT','','JKT','0','kasir','2026-01-11 15:15:32');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260111-0009','2026-01-11','2026-01-11 15:15:32','PEMBELIAN UMUM : BE-260111-0004','-','TBC','3600000','3600000');
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-260111-0010','K','2026-01-11','15:15:31','TBC','PEMBELIAN UMUM','BE-260111-0004','94393402685','3600000','94389802685','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260111-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260111-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260111-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260111-0004';
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-260111-0007','kasir','1',' 1.0K-19-84','TOKO','PERAK','CKPRE-YJXF-10-0','CINCIN SILVER 925 ','','4.030','1','100.00','104000','0','0','16875','1000000','0','0','0','1000000','NANA','00039016','CKPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-YJXF-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.030',berat_jual_asli=berat_jual_asli+'4.030',stock_jual='1',berat_akhir=berat_akhir-'4.030',berat_akhir_asli=berat_akhir_asli-'4.030',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='CKPRE-YJXF-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-260111-0007','2026-01-11','4.030','2026-01-11','16:35:59','PLG0027744','1000000','1000000','0','1000000','0','kasir','2026-01-11 16:35:59','FE-260111-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-01-11','FE-260111-0007','2026-01-11','16:35:59','NANA','1000000','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-260111-0010','2026-01-11','2026-01-11 16:35:59','PENJUALAN : FE-260111-0007','','TBC','1000000','1000000','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-260111-0011','D','2026-01-11','16:35:59','TBC','PENJUALAN','FE-260111-0007','94389802685','1000000','94390802685','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='1000000' WHERE no_faktur_jual='FE-260111-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260111-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260111-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260111-0007';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-07965','NANA','1','CINCIN SILVER','JD NO 20 GRF A N 10 01 2026 CROM PUTIH DOF SEMPROT','4.030','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-07965','2026-01-11','2026-01-11','16:38:23','PLG0027745','kasir','2026-01-13','kasir','2026-01-11 16:38:23','4.030','0','0','0','0','0','0','0','0');
UPDATE tt_service_head SET tgl_selesai='2026-01-11',  status ='DONE' WHERE no_service='SV-07951';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-07951';
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-01-11',  status ='CLOS' WHERE no_service='SV-07951';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-07951';
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-00009005','X-00009005','GIWANG ABRE-01754','GR','---','ABRE','BELI','BELI001','1625000','2026-01-11','1.190','1','kasir','2026-01-11 16:58:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-ABRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-ABRE','X-00009005','X-00009005');
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-260111-0005','FE-240221-0008','BARY','1','BELI','BELI001','ABRE', 'X-00009005', 'GIWANG ABRE-01754','2.360','1.190','75.00','6500000','1625000','1365546','1','1625000','1625000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.190',berat_beli_asli=berat_beli_asli+'1.190',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.190',berat_akhir_asli=berat_akhir_asli+'1.190',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-11' 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-260111-0005','2026-01-11','2026-01-11','16:58:34','BARY','---','1.190','1625000','1625000','1625000','1625000','1625000','kasir','2026-01-11 16:58:35','BE-260111-0005','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260111-0005','RAHAYU','JKT','','','0','kasir','2026-01-11 16:58:35');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260111-0011','2026-01-11','2026-01-11 16:58:35','PEMBELIAN UMUM : BE-260111-0005','-','TBC','1625000','1625000');
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-260111-0012','K','2026-01-11','16:58:34','TBC','PEMBELIAN UMUM','BE-260111-0005','94390802685','1625000','94389177685','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','');
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-260111-0002','D','2026-01-11','18:07:13','kasir','TAMBAH KAS','SV07943','3624540','500000','4124540');
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-260111-0003','K','2026-01-11','18:10:07','kasir','BELANJA','AIR GALON TOKO','4124540','25000','4099540');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260111-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260111-0005';
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-00009006','X-00009006','NEC0248','GR','---','CBR','BELI','BELI001','2595000','2026-01-11','2.310','1','kasir','2026-01-11 19:27:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-CBR';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBR','X-00009006','X-00009006');
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-260111-0006','','FAISAL','1','BELI','BELI001','CBR', 'X-00009006', 'NEC0248','2.820','2.310','75.00','3850000','2595000','1123377','1','2595000','2595000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.310',berat_beli_asli=berat_beli_asli+'2.310',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.310',berat_akhir_asli=berat_akhir_asli+'2.310',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CBR' 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-260111-0006','2026-01-11','2026-01-11','19:27:34','FAISAL','---','2.310','2595000','2595000','2595000','2595000','2595000','kasir','2026-01-11 19:27:35','BE-260111-0006','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260111-0006','PUTTY','JKT','','JKT','0','kasir','2026-01-11 19:27:35');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260111-0012','2026-01-11','2026-01-11 19:27:35','PEMBELIAN UMUM : BE-260111-0006','-','TBC','2595000','2595000');
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-260111-0013','K','2026-01-11','19:27:34','TBC','PEMBELIAN UMUM','BE-260111-0006','94389177685','2595000','94386582685','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260111-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260111-0006';
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-260111-0008','kasir','1',' CKPDE-0006','TOKO','CKPDE','CKPDE-YLAA-5-0','CINCIN KAWIN CKPDE-00065 ','','4.790','1','6.00','709000','0','0','16875','2137000','0','0','0','2137000','NANA','00040540','CKPDE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPDE-YLAA-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.790',berat_jual_asli=berat_jual_asli+'4.790',stock_jual='1',berat_akhir=berat_akhir-'4.790',berat_akhir_asli=berat_akhir_asli-'4.790',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='CKPDE-YLAA-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CKPDE' 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-260111-0008','2026-01-11','4.790','2026-01-11','19:33:52','PLG0027746','2137000','2137000','0','2137000','0','kasir','2026-01-11 19:33:51','FE-260111-0008','','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-01-11','FE-260111-0008','2026-01-11','19:33:52','NANA','2137000','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-260111-0013','2026-01-11','2026-01-11 19:33:51','PENJUALAN : FE-260111-0008','.','TBC','2137000','2137000','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-260111-0014','D','2026-01-11','19:33:52','TBC','PENJUALAN','FE-260111-0008','94386582685','2137000','94388719685','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='2137000' WHERE no_faktur_jual='FE-260111-0008' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260111-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260111-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260111-0008';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-07966','NANA','1','PLD','RESIZE NAIK 1 NOMOR GRF RIZAQ FIRDA HURUF BESAR SEMUA CRUM PUTIH DOFF AMPLAS','4.790','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-07966','2026-01-11','2026-01-11','19:35:36','PLG0027747','kasir','2026-01-13','kasir','2026-01-11 19:35:36','4.790','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-01-12','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-11';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-11';
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-11' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-11';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-11';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-11';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-11';
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-12' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-11' 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-260112-0001','D','2026-01-12','20:10:08','TBC','SALDO AWAL','SALDO AWAL','0','94388719685','94388719685');
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-260112-0001','D','2026-01-12','20:10:08','BCK','SALDO AWAL','SALDO AWAL','0','16298407978.088','16298407978.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-260112-0001','D','2026-01-12','20:10:08','TMR','SALDO AWAL','SALDO AWAL','0','8432183779','8432183779');
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-260112-0001','D','2026-01-12','20:10:08','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900');
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-260112-0001','D','2026-01-12','20:10:08','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-260112-0001','D','2026-01-12','20:10:08','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-260112-0001','D','2026-01-12','20:10:08','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-260112-0001','D','2026-01-12','20:10:08','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-260112-0001','D','2026-01-12','20:10:08','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-260112-0001','D','2026-01-12','20:10:08','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-260112-0001','D','2026-01-12','20:10:08','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-260112-0001','D','2026-01-12','20:10:08','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-260112-0001','D','2026-01-12','20:10:08','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-260112-0001','D','2026-01-12','20:10:08','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-260112-0001','D','2026-01-12','20:10:08','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-260112-0001','D','2026-01-12','20:10:08','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-260112-0001','D','2026-01-12','20:10:08','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450');
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-260112-0001','D','2026-01-12','20:10:08','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-260112-0001','D','2026-01-12','20:10:08','SHO','SALDO AWAL','SALDO AWAL','0','2741005684','2741005684');
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-260112-0001','D','2026-01-12','20:10:08','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-260112-0001','D','2026-01-12','20:10:08','','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-260112-0001','D','2026-01-12','20:10:08','BCD','SALDO AWAL','SALDO AWAL','0','14935321700','14935321700');
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-260112-0001','D','2026-01-12','20:10:08','DPE','SALDO AWAL','SALDO AWAL','0','223548800','223548800');
UPDATE tp_system SET tgl_system='2026-01-12';