INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-22 ','10:45:22');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-22 ','12:18:33');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-22 ','12:44:52');
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-01433','NITA','1','PER','WEDDING RING','','','5.000','','925.00','1','60000','0','900000','0','900000','zircon 20','size 12 5 krum putih glosy','grf ARLA Penulisan kapital font berkshire swash','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251122-0001','2025-11-22','2025-11-22 12:57:25','PESANAN : DP-01433','.','TBC','900000','900000');
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-251122-0002','D','2025-11-22','12:57:25','TBC','PESANAN','DP-01433','18098748514','900000','18099648514','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-01433','2025-11-22','2025-11-22','12:57:25','PLG0007739','NITA','2025-12-22','kasir','2025-11-22 12:57:25','5.000','0','0','0','900000','0','0','900000','900000','0');
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-01434','NITA','1','PER','WEDDING RING','','','5.000','','925.00','1','60000','0','700000','0','700000','zircon 1','size 19 krum doff semprot','grf ARLA penulisan kapital font berkshire swash','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251122-0002','2025-11-22','2025-11-22 13:01:03','PESANAN : DP-01434','.','TBC','700000','700000');
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-251122-0003','D','2025-11-22','13:01:03','TBC','PESANAN','DP-01434','18099648514','700000','18100348514','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-01434','2025-11-22','2025-11-22','13:01:03','PLG0007740','NITA','2025-12-22','kasir','2025-11-22 13:01:03','5.000','0','0','0','700000','0','0','700000','700000','0');
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-01435','NITA','1','GOLD','1 CINCIN EMAS','','','2.000','','75.00','1','2180000','2100000','0','750000','4950000','zircon 21','size 29 krum rosegold glosy','','210000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251122-0003','2025-11-22','2025-11-22 13:09:17','PESANAN : DP-01435','.','TBC','4128000','4128000');
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-251122-0004','D','2025-11-22','13:09:17','TBC','PESANAN','DP-01435','18100348514','4128000','18104476514','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-01435','2025-11-22','2025-11-22','13:09:17','PLG0007741','NITA','2025-12-22','kasir','2025-11-22 13:09:17','2.000','0','0','0','4128000','0','750000','5160000','5160000','1032000');
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-01436','NITA','1','GOLD','1 CINCIN EMAS','','','2.500','','75.00','1','2180000','2100000','0','750000','6000000','zircon 16','size 29 krum pth glosy','','160000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251122-0004','2025-11-22','2025-11-22 13:13:06','PESANAN : DP-01436','.','TBC','4928000','4928000');
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-251122-0005','D','2025-11-22','13:13:06','TBC','PESANAN','DP-01436','18104476514','4928000','18109404514','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-01436','2025-11-22','2025-11-22','13:13:06','PLG0007742','NITA','2025-12-22','kasir','2025-11-22 13:13:06','2.500','0','0','0','4928000','0','750000','6160000','6160000','1232000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-22 ','13:20:36');
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 ('FJ-251122-0001','kasir','1',' 500K-155-5','TOKO','MMPER','PMM-YKAD-31-0','CINCIN SILVER 925 ','','1.850','1','100.00','114000','0','0','16750','500000','0','0','0','500000','NIS','00039608','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKAD-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2025-11-22' AND kode_barang='PMM-YKAD-31-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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 ('FJ-251122-0001','2025-11-22','1.850','2025-11-22','13:21:54','PLG0007743','500000','500000','0','500000','0','kasir','2025-11-22 13:21:54','FJ-251122-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('2025-11-22','FJ-251122-0001','2025-11-22','13:21:54','NIS','500000','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-251122-0005','2025-11-22','2025-11-22 13:21:54','PENJUALAN : FJ-251122-0001','.','TBC','500000','500000','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-251122-0006','D','2025-11-22','13:21:54','TBC','PENJUALAN','FJ-251122-0001','18109404514','500000','18109904514','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='500000' WHERE no_faktur_jual='FJ-251122-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 ('FJ-251122-0002','kasir','1',' 850K-10-00','TOKO','MMPER','PBSD-YGBI-27-0','CINCIN SILVER 925 ','','2.180','1','100.00','45000','0','0','16750','850000','0','0','0','850000','NAD','00037663','PBSD','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGBI-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2025-11-22' AND kode_barang='PBSD-YGBI-27-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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 ('FJ-251122-0002','2025-11-22','2.180','2025-11-22','13:23:03','PLG0007744','850000','850000','0','850000','0','kasir','2025-11-22 13:23:03','FJ-251122-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('2025-11-22','FJ-251122-0002','2025-11-22','13:23:03','NAD','850000','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-251122-0006','2025-11-22','2025-11-22 13:23:03','PENJUALAN : FJ-251122-0002','.','TBC','850000','850000','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-251122-0007','D','2025-11-22','13:23:03','TBC','PENJUALAN','FJ-251122-0002','18109904514','850000','18110754514','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='FJ-251122-0002' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01481','NIS','1','2PCS CINCIN SLV','CEWE RESIZE KE 16 GRF RAFIK DAN COWO GRF AISYAH KRUM KOMBI','4.030','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-251122-0007','2025-11-22','2025-11-22 13:29:48','SERVICE : SV-01481','.','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-251122-0008','D','2025-11-22','13:29:48','TBC','SERVICE','SV-01481','18110754514','100000','18110854514','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-01481','2025-11-22','2025-11-22','13:29:48','PLG0007745','kasir','2025-11-23','kasir','2025-11-22 13:29:48','4.030','0','0','0','100000','0','100000','100000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251122-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251122-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 ('FJ-251122-0003','kasir','1',' TFGKR75-89','TOKO','TFGLK','TFGKR-XAAX-4-0','THIFA GELANG KAKU RG ','','7.680','1','89.00','15051000','0','0','16750','15500000','0','0','0','15500000','FIR','00025678','TFGKR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGKR-XAAX-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'7.680',berat_jual_asli=berat_jual_asli+'7.680',stock_jual='1',berat_akhir=berat_akhir-'7.680',berat_akhir_asli=berat_akhir_asli-'7.680',stock_akhir='0' WHERE tanggal='2025-11-22' AND kode_barang='TFGKR-XAAX-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLK' 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 ('FJ-251122-0003','2025-11-22','7.680','2025-11-22','14:45:42','PLG0007746','15500000','15500000','0','15500000','0','kasir','2025-11-22 14:45:41','FJ-251122-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('2025-11-22','FJ-251122-0003','2025-11-22','14:45:42','FIR','15500000','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-251122-0008','2025-11-22','2025-11-22 14:45:41','PENJUALAN : FJ-251122-0003','.','TBC','15500000','15500000','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-251122-0009','D','2025-11-22','14:45:42','TBC','PENJUALAN','FJ-251122-0003','18110854514','15500000','18126354514','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='15500000' WHERE no_faktur_jual='FJ-251122-0003' 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 ('FJ-251122-0004','kasir',' 1',' TFGRR75-89','TOKO','TFGLR','TFGRR-XCBA-81-0','THIFA GELANG RANTAI RG ','','7.490','1','89.00','14678000','0','0','16750','15300000','0','0','0','15300000','FIR','00027690','TFGRR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRR-XCBA-81-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'7.490',berat_jual_asli=berat_jual_asli+'7.490',stock_jual='1',berat_akhir=berat_akhir-'7.490',berat_akhir_asli=berat_akhir_asli-'7.490',stock_akhir='0' WHERE tanggal='2025-11-22' AND kode_barang='TFGRR-XCBA-81-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLR' 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 ('FJ-251122-0004','2025-11-22','7.490','2025-11-22','14:45:42','PLG0007747','15300000','15300000','0','15300000','0','kasir','2025-11-22 14:45:41','FJ-251122-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('2025-11-22','FJ-251122-0004','2025-11-22','14:45:42','FIR','15300000','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-251122-0009','2025-11-22','2025-11-22 14:45:41','PENJUALAN : FJ-251122-0004','.','TBC','15300000','15300000','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-251122-0010','D','2025-11-22','14:45:42','TBC','PENJUALAN','FJ-251122-0004','18126354514','15300000','18141654514','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='30800000' WHERE no_faktur_jual='FJ-251122-0004' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-22 ','14:53:55');
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-01437','HELMI','1','PLD','WEDDING RING','','','3.000','','10.00','1','2200000','300000','0','1000000','1900000','zirkon 1butir size 14.5','grf A.Bangbang.N','krum kombinasi RG','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-251122-0010','2025-11-22','2025-11-22 14:59:30','PESANAN : DP-01437','.','TBC','875000','875000');
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-251122-0011','D','2025-11-22','14:59:30','TBC','PESANAN','DP-01437','18141654514','875000','18142529514','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-01437','2025-11-22','2025-11-22','14:59:30','PLG0007748','HELMI','2025-12-05','kasir','2025-11-22 14:59:30','3.000','0','0','0','875000','0','1000000','1900000','1900000','1025000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251122-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251122-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-22 ','15:51:17');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-22 ','16:11:10');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01482','SULIS','1','CC SLV','PASANG MATA DAN BENERIN LINGKAR CINCIN','5.000','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-01482','2025-11-22','2025-11-22','16:53:05','PLG0007749','kasir','2025-11-23','kasir','2025-11-22 16:53:05','5.000','0','0','0','0','0','0','0','0');
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-01438','HELMI','1','PLD','WEDDING RING','','','4.000','','10.00','1','2200000','300000','0','1000000','2200000','tanpa permata size 16.5','grf Eky.R.L','KRUM PUTIH GLOSY','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-251122-0011','2025-11-22','2025-11-22 17:01:09','PESANAN : DP-01438','.','TBC','1000000','1000000');
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-251122-0012','D','2025-11-22','17:01:09','TBC','PESANAN','DP-01438','18142529514','1000000','18143529514','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-01438','2025-11-22','2025-11-22','17:01:09','PLG0007750','HELMI','2025-12-05','kasir','2025-11-22 17:01:09','4.000','0','0','0','1000000','0','1000000','2200000','2200000','1200000');
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-01439','HELMI','1','PER','WEDDING RING','','','2.000','','925.00','1','60000','0','850000','0','850000','size 13 grf Dika','model spt contoh','krum putih','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-251122-0012','2025-11-22','2025-11-22 17:05:54','PESANAN : DP-01439','.','TBC','850000','850000');
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-251122-0013','D','2025-11-22','17:05:54','TBC','PESANAN','DP-01439','18143529514','850000','18144379514','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-01439','2025-11-22','2025-11-22','17:05:54','PLG0007751','HELMI','2025-12-15','kasir','2025-11-22 17:05:54','2.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-22 ','17:07:11');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01483','NIS','1','1PCS','RESIZE KE 25 GRF JGN HILANG','2.100','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-251122-0013','2025-11-22','2025-11-22 17:07:34','SERVICE : SV-01483','.','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-251122-0014','D','2025-11-22','17:07:34','TBC','SERVICE','SV-01483','18144379514','100000','18144479514','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-01483','2025-11-22','2025-11-22','17:07:34','PLG0007752','kasir','2025-11-23','kasir','2025-11-22 17:07:34','2.100','0','0','0','100000','0','100000','100000','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 ('FJ-251122-0005','kasir','1',' TFC-21481 ','TOKO','TFCBR','TFC-YIAI-1-0','CINCIN TFC-21481','','4.620','1','83.00','13037000','3492000','208','16750','15500000','0','0','0','15500000','ONLNANA','00038819','TFC','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFC-YIAI-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.620',berat_jual_asli=berat_jual_asli+'4.620',stock_jual='1',berat_akhir=berat_akhir-'4.620',berat_akhir_asli=berat_akhir_asli-'4.620',stock_akhir='0' WHERE tanggal='2025-11-22' AND kode_barang='TFC-YIAI-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCBR' 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 ('FJ-251122-0005','2025-11-22','4.620','2025-11-22','17:08:15','PLG0007753','15500000','15500000','0','15500000','0','kasir','2025-11-22 17:08:14','FJ-251122-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('2025-11-22','FJ-251122-0005','2025-11-22','17:08:15','ONLNANA','15500000','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-251122-0014','2025-11-22','2025-11-22 17:08:14','PENJUALAN : FJ-251122-0005','.','TBC','15500000','15500000','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-251122-0015','D','2025-11-22','17:08:15','TBC','PENJUALAN BERLIAN','FJ-251122-0005','18144479514','15500000','18159979514','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='15500000' WHERE no_faktur_jual='FJ-251122-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251122-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-01440','HELMI','1','PER','WEDDING RING','','','3.000','','925.00','1','60000','0','700000','0','700000','zirkon 1butir size 16','grf Fitri','krum putih doff semprot','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-251122-0015','2025-11-22','2025-11-22 17:09:22','PESANAN : DP-01440','.','TBC','700000','700000');
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-251122-0016','D','2025-11-22','17:09:22','TBC','PESANAN','DP-01440','18159979514','700000','18160679514','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-01440','2025-11-22','2025-11-22','17:09:22','PLG0007754','HELMI','2025-12-15','kasir','2025-11-22 17:09:22','3.000','0','0','0','700000','0','0','700000','700000','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01484','ONLNANA','1','TFC21481','RESIZE KE 15 CRUM TTP SAMA KOMBINASI ROSE GOLD','4.620','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-251122-0016','2025-11-22','2025-11-22 17:12:38','SERVICE : SV-01484','.','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-251122-0017','D','2025-11-22','17:12:38','TBC','SERVICE','SV-01484','18160679514','100000','18160779514','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-01484','2025-11-22','2025-11-22','17:12:38','PLG0007755','kasir','2025-11-25','kasir','2025-11-22 17:12:38','4.620','0','0','0','100000','0','100000','100000','0');
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-01441','SUL','1','PLD','WEDDING RING','','','3.000','','10.00','1','2200000','300000','0','700000','1600000','1 zircon putih doff semprot','font vladimir grf Fanny 14.02.26','size 12','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251122-0017','2025-11-22','2025-11-22 17:25:58','PESANAN : DP-01441','.','TBC','800000','800000');
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-251122-0018','D','2025-11-22','17:25:58','TBC','PESANAN','DP-01441','18160779514','800000','18161579514','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-01441','2025-11-22','2025-11-22','17:25:58','PLG0007756','SUL','2025-12-22','kasir','2025-11-22 17:25:58','3.000','0','0','0','800000','0','700000','1600000','1600000','800000');
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-01442','SUL','1','PLD','WED RING','','','3.000','','10.00','1','2200000','300000','0','700000','1600000','putih doff semprot 1 zircon','font vladimir grf Niki 14.02.26','size 11','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251122-0018','2025-11-22','2025-11-22 17:27:49','PESANAN : DP-01442','.','TBC','800000','800000');
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-251122-0019','D','2025-11-22','17:27:49','TBC','PESANAN','DP-01442','18161579514','800000','18162379514','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-01442','2025-11-22','2025-11-22','17:27:49','PLG0007757','SUL','2025-12-22','kasir','2025-11-22 17:27:49','3.000','0','0','0','800000','0','700000','1600000','1600000','800000');
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 ('FJ-251122-0006','kasir','1',' PLBDG-0009','TOKO','BIPPLD','PLBDG-YKXD-26-0','CINCIN PALADIUM PLBDG-00095 ','','4.450','1','6.00','629000','0','0','16750','2035000','0','0','0','2035000','NITA','00039473','PLBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-YKXD-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.450',berat_jual_asli=berat_jual_asli+'4.450',stock_jual='1',berat_akhir=berat_akhir-'4.450',berat_akhir_asli=berat_akhir_asli-'4.450',stock_akhir='0' WHERE tanggal='2025-11-22' AND kode_barang='PLBDG-YKXD-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' 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 ('FJ-251122-0006','2025-11-22','4.450','2025-11-22','17:52:14','PLG0007758','2035000','2035000','0','2035000','0','kasir','2025-11-22 17:52:13','FJ-251122-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('2025-11-22','FJ-251122-0006','2025-11-22','17:52:14','NITA','2035000','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-251122-0019','2025-11-22','2025-11-22 17:52:13','PENJUALAN : FJ-251122-0006','.','TBC','2035000','2035000','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-251122-0020','D','2025-11-22','17:52:14','TBC','PENJUALAN','FJ-251122-0006','18162379514','2035000','18164414514','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='2035000' WHERE no_faktur_jual='FJ-251122-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251122-0006';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01485','NITA','1','1 CINCIN PALLADIUM','RESIZE 12 5 KRUMSPT ASAL FONT YESEVA ONE PENULISAN GRF KAPITAL','5.000','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-01485','2025-11-22','2025-11-22','18:01:58','PLG0007759','kasir','2025-12-01','kasir','2025-11-22 18:01:58','5.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-22 ','18:02:35');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01486','NAD','1','2PCS','CEWE PASANG MATA COWO KRUM ULANG FULL GLOSI GRF DUA DUANYA JGN HILANG','5.800','1','150000','150000');
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-251122-0020','2025-11-22','2025-11-22 18:39:19','SERVICE : SV-01486','.','TBC','150000','150000','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-251122-0021','D','2025-11-22','18:39:19','TBC','SERVICE','SV-01486','18164414514','150000','18164564514','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-01486','2025-11-22','2025-11-22','18:39:19','PLG0007760','kasir','2025-11-23','kasir','2025-11-22 18:39:19','5.800','0','0','0','150000','0','150000','150000','0');
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-01443','HELMI','1','GOLD','WEDDING RING','','','1.500','','75.00','1','2180000','2100000','0','750000','3900000','zirkon 21butir','size 13 grf DHF','KRUM PUTIH GLOSY','210000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251122-0021','2025-11-22','2025-11-22 19:22:20','PESANAN : DP-01443','.','TBC','3288000','3288000');
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-251122-0022','D','2025-11-22','19:22:20','TBC','PESANAN','DP-01443','18164564514','3288000','18167852514','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-01443','2025-11-22','2025-11-22','19:22:20','PLG0007761','HELMI','2025-12-22','kasir','2025-11-22 19:22:20','1.500','0','0','0','3288000','0','750000','4110000','4110000','822000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-22 ','19:28:01');
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-01444','HELMI','1','PER','WEDDING RING','','','5.000','','925.00','1','60000','0','700000','0','700000','size 23 grf NDR','model ppn list','krum putih doff amplas','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-251122-0022','2025-11-22','2025-11-22 19:29:45','PESANAN : DP-01444','.','TBC','700000','700000');
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-251122-0023','D','2025-11-22','19:29:45','TBC','PESANAN','DP-01444','18167852514','700000','18168552514','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-01444','2025-11-22','2025-11-22','19:29:45','PLG0007762','HELMI','2025-12-22','kasir','2025-11-22 19:29:45','5.000','0','0','0','700000','0','0','700000','700000','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 ('FJ-251122-0007','kasir','1',' DP-01335BI','TOKO','BIPPSN','PSGT-YKAC-8-0','CINCIN EMAS ','','2.020','1','83.00','3866000','0','0','16750','4778400','0','0','0','4778400','HELMI','00039570','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YKAC-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2025-11-22' AND kode_barang='PSGT-YKAC-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-251122-0007','2025-11-22','2.020','2025-11-22','19:34:29','PLG0007763','4778400','4778400','0','4778400','0','kasir','2025-11-22 19:34:29','FJ-251122-0007','DP-01335','3318000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-22','FJ-251122-0007','2025-11-22','19:34:29','HELMI','4778400','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-251122-0023','2025-11-22','2025-11-22 19:34:29','PENJUALAN : FJ-251122-0007','.','TBC','1460400','1460400','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-251122-0024','D','2025-11-22','19:34:29','TBC','PENJUALAN','FJ-251122-0007','18168552514','1460400','18170012914','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='1460400' WHERE no_faktur_jual='FJ-251122-0007' 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 ('FJ-251122-0008','kasir',' 1',' DP-01338BI','TOKO','BIPPSN','PSPLT-YKAI-2-0','CINCIN PALADIUM ','','3.520','1','5.00','427000','0','0','16750','1580000','0','0','0','1580000','HELMI','00039662','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YKAI-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.520',berat_jual_asli=berat_jual_asli+'3.520',stock_jual='1',berat_akhir=berat_akhir-'3.520',berat_akhir_asli=berat_akhir_asli-'3.520',stock_akhir='0' WHERE tanggal='2025-11-22' AND kode_barang='PSPLT-YKAI-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-251122-0008','2025-11-22','3.520','2025-11-22','19:34:29','PLG0007764','1580000','1580000','0','1580000','0','kasir','2025-11-22 19:34:29','FJ-251122-0007','DP-01338','787500');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-22','FJ-251122-0008','2025-11-22','19:34:29','HELMI','1580000','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-251122-0024','2025-11-22','2025-11-22 19:34:29','PENJUALAN : FJ-251122-0008','.','TBC','792500','792500','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-251122-0025','D','2025-11-22','19:34:29','TBC','PENJUALAN','FJ-251122-0008','18170012914','792500','18170805414','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='2252900' WHERE no_faktur_jual='FJ-251122-0008' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251122-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251122-0008';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01487','NITA','1','CC PLD','JD SIZE 21 5 KRUM PUTIH GLOSY','3.520','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-01487','2025-11-22','2025-11-22','19:43:17','PLG0007765','kasir','2025-11-23','kasir','2025-11-22 19:43:17','3.520','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-22 ','19:43:36');
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 ('FJ-251122-0009','kasir','1',' DP-01378BI','TOKO','BIPPSN','PSPRT-YKAG-4-0','CINCIN PERAK ','','2.270','1','100.00','140000','0','0','16750','700000','0','0','0','700000','SUL','00039650','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKAG-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.270',berat_jual_asli=berat_jual_asli+'2.270',stock_jual='1',berat_akhir=berat_akhir-'2.270',berat_akhir_asli=berat_akhir_asli-'2.270',stock_akhir='0' WHERE tanggal='2025-11-22' AND kode_barang='PSPRT-YKAG-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-251122-0009','2025-11-22','2.270','2025-11-22','19:51:06','PLG0007766','700000','700000','0','700000','0','kasir','2025-11-22 19:51:05','FJ-251122-0009','DP-01378','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-22','FJ-251122-0009','2025-11-22','19:51:06','SUL','700000','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='FJ-251122-0009' 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 ('FJ-251122-0010','kasir',' 1',' DP-01379BI','TOKO','BIPPSN','PSPRT-YKAG-1-0','CINCIN PERAK ','','1.440','1','100.00','89000','0','0','16750','900000','0','0','0','900000','SUL','00039647','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKAG-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.440',berat_jual_asli=berat_jual_asli+'1.440',stock_jual='1',berat_akhir=berat_akhir-'1.440',berat_akhir_asli=berat_akhir_asli-'1.440',stock_akhir='0' WHERE tanggal='2025-11-22' AND kode_barang='PSPRT-YKAG-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-251122-0010','2025-11-22','1.440','2025-11-22','19:51:06','PLG0007767','900000','900000','0','900000','0','kasir','2025-11-22 19:51:05','FJ-251122-0009','DP-01379','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('2025-11-22','FJ-251122-0010','2025-11-22','19:51:06','SUL','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='FJ-251122-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251122-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251122-0010';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-23','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-23';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-22';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-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='2025-11-22' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-22';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-22';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-22';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-22';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-23' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-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-251123-0001','D','2025-11-23','20:04:27','TBC','SALDO AWAL','SALDO AWAL','0','18170805414','18170805414');
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-251123-0001','D','2025-11-23','20:04:27','BCD','SALDO AWAL','SALDO AWAL','0','1342321000','1342321000');
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-251123-0001','D','2025-11-23','20:04:27','KET','SALDO AWAL','SALDO AWAL','0','135063000','135063000');
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-251123-0001','D','2025-11-23','20:04:27','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000');
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-251123-0001','D','2025-11-23','20:04:27','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
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-251123-0001','D','2025-11-23','20:04:27','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
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-251123-0001','D','2025-11-23','20:04:27','BCK','SALDO AWAL','SALDO AWAL','0','1927708000','1927708000');
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-251123-0001','D','2025-11-23','20:04:27','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000');
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-251123-0001','D','2025-11-23','20:04:27','TOP','SALDO AWAL','SALDO AWAL','0','253907000','253907000');
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-251123-0001','D','2025-11-23','20:04:27','SHO','SALDO AWAL','SALDO AWAL','0','141465650','141465650');
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-251123-0001','D','2025-11-23','20:04:27','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
UPDATE tp_system SET tgl_system='2025-11-23';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-22 ','21:17:46');
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 ('FJ-251122-0011','kasir','1',' DP-01348BI','TOKO','BIPPSN','PSPRT-YKBX-18-0','CINCIN PERAK ','','3.700','1','100.00','227000','0','0','16750','700000','0','0','0','700000','SUL','00039725','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKBX-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.700',berat_jual_asli=berat_jual_asli+'3.700',stock_jual='1',berat_akhir=berat_akhir-'3.700',berat_akhir_asli=berat_akhir_asli-'3.700',stock_akhir='0' WHERE tanggal='2025-11-23' AND kode_barang='PSPRT-YKBX-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-251122-0011','2025-11-23','3.700','2025-11-22','21:20:22','PLG0007768','700000','700000','0','700000','0','kasir','2025-11-22 21:20:22','FJ-251122-0011','DP-01348','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-23','FJ-251122-0011','2025-11-22','21:20:22','SUL','700000','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='FJ-251122-0011' 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 ('FJ-251122-0012','kasir',' 1',' DP-01347BI','TOKO','BIPPSN','PSPRT-YKBX-17-0','CINCIN PERAK ','','2.610','1','100.00','161000','0','0','16750','800000','0','0','0','800000','SUL','00039724','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKBX-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.610',berat_jual_asli=berat_jual_asli+'2.610',stock_jual='1',berat_akhir=berat_akhir-'2.610',berat_akhir_asli=berat_akhir_asli-'2.610',stock_akhir='0' WHERE tanggal='2025-11-23' AND kode_barang='PSPRT-YKBX-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-251122-0012','2025-11-23','2.610','2025-11-22','21:20:22','PLG0007769','800000','800000','0','800000','0','kasir','2025-11-22 21:20:22','FJ-251122-0011','DP-01347','800000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-23','FJ-251122-0012','2025-11-22','21:20:22','SUL','800000','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='FJ-251122-0012' 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 ('FJ-251122-0013','kasir','1',' DP-01356BI','TOKO','BIPPSN','PSGT-YKBX-35-0','CINCIN EMAS ','','2.070','1','83.00','3856000','0','0','16750','4674400','0','0','0','4674400','SUL','00039742','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YKBX-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2025-11-23' AND kode_barang='PSGT-YKBX-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-251122-0013','2025-11-23','2.070','2025-11-22','21:24:51','PLG0007770','4674400','4674400','0','4674400','0','kasir','2025-11-22 21:24:51','FJ-251122-0013','DP-01356','3632000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-23','FJ-251122-0013','2025-11-22','21:24:51','SUL','4674400','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-251123-0001','2025-11-23','2025-11-22 21:24:51','PENJUALAN : FJ-251122-0013','.','TBC','1042400','1042400','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-251123-0002','D','2025-11-23','21:24:51','TBC','PENJUALAN','FJ-251122-0013','18170805414','1042400','18171847814','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='1042400' WHERE no_faktur_jual='FJ-251122-0013' 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 ('FJ-251122-0014','kasir',' 1',' DP-01355BI','TOKO','BIPPSN','PSGT-YKBA-2-0','CINCIN EMAS ','','1.520','1','83.00','2832000','0','0','16750','3768400','0','0','0','3768400','SUL','00039748','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YKBA-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2025-11-23' AND kode_barang='PSGT-YKBA-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-251122-0014','2025-11-23','1.520','2025-11-22','21:24:51','PLG0007771','3768400','3768400','0','3768400','0','kasir','2025-11-22 21:24:51','FJ-251122-0013','DP-01355','2948000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-23','FJ-251122-0014','2025-11-22','21:24:51','SUL','3768400','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-251123-0002','2025-11-23','2025-11-22 21:24:51','PENJUALAN : FJ-251122-0014','.','TBC','820400','820400','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-251123-0003','D','2025-11-23','21:24:51','TBC','PENJUALAN','FJ-251122-0014','18171847814','820400','18172668214','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='1862800' WHERE no_faktur_jual='FJ-251122-0014' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251122-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251122-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251122-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251122-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251122-0014';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-22 ','21:46:00');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01488','SUL','1','CC SILVER','JADI SZ 9','1.000','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-01488','2025-11-23','2025-11-23','21:55:37','PLG0007772','kasir','2025-11-30','kasir','2025-11-22 21:55:37','1.000','0','0','0','0','0','0','0','0');