INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-11-15 ','10:33:41'); 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-261115-0001','sby','1',' DP-04684SB','TOKO','SBYPSN','PSPRT-ZKXI-5-0','CINCIN PERAK ','','1.680','1','100.00','172000','0','0','17800','1050000','0','0','0','1050000','VAN','00049187','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZKXI-5-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.680',berat_jual_asli=berat_jual_asli+'1.680',stock_jual='1',berat_akhir=berat_akhir-'1.680',berat_akhir_asli=berat_akhir_asli-'1.680',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='PSPRT-ZKXI-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-261115-0001','2026-11-15','1.680','2026-11-15','10:36:39','PLG0018982','1050000','1050000','0','1050000','0','sby','2026-11-15 10:36:38','FJ-261115-0001','DP-04684','1050000'); 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-11-15','FJ-261115-0001','2026-11-15','10:36:39','VAN','1050000','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-261115-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-261115-0002','sby',' 1',' DP-04686SB','TOKO','SBYPSN','PSPRT-ZKXF-44-0','CINCIN PERAK ','','3.400','1','100.00','347000','0','0','17800','900000','0','0','0','900000','VAN','00049095','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZKXF-44-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.400',berat_jual_asli=berat_jual_asli+'3.400',stock_jual='1',berat_akhir=berat_akhir-'3.400',berat_akhir_asli=berat_akhir_asli-'3.400',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='PSPRT-ZKXF-44-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-261115-0002','2026-11-15','3.400','2026-11-15','10:36:39','PLG0018983','900000','900000','0','900000','0','sby','2026-11-15 10:36:38','FJ-261115-0001','DP-04686','900000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-15','FJ-261115-0002','2026-11-15','10:36:39','VAN','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-261115-0002' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-15 ','10:48:57'); 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-261115-0003','kasirbip','1',' DP-04793BI','TOKO','BIPPSN','PSPLT-ZKAA-34-0','CINCIN PALADIUM ','','4.820','1','17.00','1082000','0','0','17800','2587000','0','0','0','2587000','SULIS','00049334','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZKAA-34-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.820',berat_jual_asli=berat_jual_asli+'4.820',stock_jual='1',berat_akhir=berat_akhir-'4.820',berat_akhir_asli=berat_akhir_asli-'4.820',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='PSPLT-ZKAA-34-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-261115-0003','2026-11-15','4.820','2026-11-15','10:53:07','PLG0018984','2587000','2587000','0','2587000','0','kasirbip','2026-11-15 10:53:07','FJ-261115-0003','DP-04793','2260000'); 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-11-15','FJ-261115-0003','2026-11-15','10:53:07','SULIS','2587000','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-261115-0001','2026-11-15','2026-11-15 10:53:07','PENJUALAN : FJ-261115-0003','.','TBC','327000','327000','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-261115-0002','D','2026-11-15','10:53:07','TBC','PENJUALAN','FJ-261115-0003','31026265964','327000','31026592964','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='327000' WHERE no_faktur_jual='FJ-261115-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-261115-0004','kasirbip',' 1',' DP-04794BI','TOKO','BIPPSN','PSPLT-ZKAX-2-0','CINCIN PALADIUM ','','3.680','1','17.00','827000','0','0','17800','2268000','0','0','0','2268000','SULIS','00049268','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZKAX-2-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.680',berat_jual_asli=berat_jual_asli+'3.680',stock_jual='1',berat_akhir=berat_akhir-'3.680',berat_akhir_asli=berat_akhir_asli-'3.680',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='PSPLT-ZKAX-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-261115-0004','2026-11-15','3.680','2026-11-15','10:53:07','PLG0018985','2268000','2268000','0','2268000','0','kasirbip','2026-11-15 10:53:07','FJ-261115-0003','DP-04794','1904000'); 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-11-15','FJ-261115-0004','2026-11-15','10:53:07','SULIS','2268000','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-261115-0002','2026-11-15','2026-11-15 10:53:07','PENJUALAN : FJ-261115-0004','.','TBC','364000','364000','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-261115-0003','D','2026-11-15','10:53:07','TBC','PENJUALAN','FJ-261115-0004','31026592964','364000','31026956964','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='691000' WHERE no_faktur_jual='FJ-261115-0004' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0002'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0004'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-15 ','11:10:29'); 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-05231','SAL','1','GOLD','WED RING','','','3.500','','37.50','1','2250000','1300000','0','800000','5350000','sz 19 rosegold doff amplas sekeliling tanpa mata','font berkshire swash grf Ester 12.12.26','lebar dibuat 3.5mm','','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0003','2026-11-15','2026-11-15 11:53:05','PESANAN : DP-05231','.','TBC','4000000','4000000'); 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-261115-0004','D','2026-11-15','11:53:05','TBC','PESANAN','DP-05231','31026956964','4000000','31030956964','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-05231','2026-11-15','2026-11-15','11:53:05','PLG0018986','SAL','2026-12-09','kasirbip','2026-11-15 11:53:05','3.500','0','0','0','4000000','0','800000','5350000','5350000','1350000'); 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-05232','SAL','1','GOLD','WED RING','','','2.500','','37.50','1','2250000','1300000','0','750000','4000000','sz 15.5 rosegold glossy 1 zirkon','font berkshire swash grf Rudi 12.12.26','model dibuat persis seperti contoh','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0004','2026-11-15','2026-11-15 11:55:39','PESANAN : DP-05232','.','TBC','3000000','3000000'); 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-261115-0005','D','2026-11-15','11:55:39','TBC','PESANAN','DP-05232','31030956964','3000000','31033956964','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-05232','2026-11-15','2026-11-15','11:55:39','PLG0018987','SAL','2026-12-09','kasirbip','2026-11-15 11:55:39','2.500','0','0','0','3000000','0','750000','4000000','4000000','1000000'); 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-05233','MIL','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','1000000','0','1000000','sz cwe 18 crom putih glosy','grf Aziz 10.01.2027 font comic','','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-261115-0005','2026-11-15','2026-11-15 12:08:43','PESANAN : DP-05233','.','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-261115-0006','D','2026-11-15','12:08:43','TBC','PESANAN','DP-05233','31033956964','1000000','31034956964','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-05233','2026-11-15','2026-11-15','12:08:43','PLG0018988','MIL','2026-12-18','kasirbip','2026-11-15 12:08:43','3.000','0','0','0','1000000','0','0','1000000','1000000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-15 ','12:09:04'); 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-05234','MIL','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','850000','0','850000','sz cwo 15 crom putih glosy doff semprot','grf Annisa 10.01.2027 font comic','','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-261115-0006','2026-11-15','2026-11-15 12:11:29','PESANAN : DP-05234','.','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-261115-0007','D','2026-11-15','12:11:29','TBC','PESANAN','DP-05234','31034956964','850000','31035806964','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-05234','2026-11-15','2026-11-15','12:11:29','PLG0018989','MIL','2026-12-18','kasirbip','2026-11-15 12:11:29','3.000','0','0','0','850000','0','0','850000','850000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-11-15 ','12:28:07'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-05235','DEW','1','GOLD','WEDRING','','','3.000','','75.00','1','2250000','2200000','0','900000','7500000','sz cwe 23','gfr Vintage : Tiyan & Fara 22.05.27','zircon 10','0','0','100000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0007','2026-11-15','2026-11-15 12:35:23','PESANAN : DP-05235','-','TBC','6080000','6080000'); 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-261115-0008','D','2026-11-15','12:35:23','TBC','PESANAN','DP-05235','31035806964','6080000','31041886964','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-05235','2026-11-15','2026-11-15','12:35:23','PLG0018990','DEW','2026-12-09','jogja','2026-11-15 12:35:23','3.000','0','0','0','6080000','0','900000','7600000','7600000','1520000'); 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-05236','DEW','1','PLD','WEDRING','','','2.500','','10.00','1','1200000','350000','0','750000','1625000','sz cwo 16','grf Vintage : Fara & Tiyan 22.05.27','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0008','2026-11-15','2026-11-15 12:37:56','PESANAN : DP-05236','-','TBC','1300000','1300000'); 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-261115-0009','D','2026-11-15','12:37:56','TBC','PESANAN','DP-05236','31041886964','1300000','31043186964','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-05236','2026-11-15','2026-11-15','12:37:56','PLG0018991','DEW','2026-12-09','jogja','2026-11-15 12:37:56','2.500','0','0','0','1300000','0','750000','1625000','1625000','325000'); 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-261115-0005','kasirbip','1',' 750K-145-2','TOKO','BIPPER','PBDG-ZEBI-14-0','CINCIN SILVER 925 ','','1.280','1','100.00','131000','0','0','17800','850000','0','0','0','850000','SULIS','00043840','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZEBI-14-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='PBDG-ZEBI-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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-261115-0005','2026-11-15','1.280','2026-11-15','12:39:06','PLG0018992','850000','850000','0','850000','0','kasirbip','2026-11-15 12:39:05','FJ-261115-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-11-15','FJ-261115-0005','2026-11-15','12:39:06','SULIS','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-261115-0009','2026-11-15','2026-11-15 12:39:05','PENJUALAN : FJ-261115-0005','.','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-261115-0010','D','2026-11-15','12:39:06','TBC','PENJUALAN','FJ-261115-0005','31043186964','850000','31044036964','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-261115-0005' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-11-15 ','12:46:32'); 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-261115-0006','sby','1',' DP-04995SB','TOKO','SBYPSN','PSPRT-ZKAX-32-0','CINCIN PERAK CP07 ','','4.840','1','100.00','494000','0','0','17800','1700000','0','0','0','1700000','VAN','00049298','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZKAX-32-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.840',berat_jual_asli=berat_jual_asli+'4.840',stock_jual='1',berat_akhir=berat_akhir-'4.840',berat_akhir_asli=berat_akhir_asli-'4.840',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='PSPRT-ZKAX-32-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-261115-0006','2026-11-15','4.840','2026-11-15','12:47:44','PLG0018993','1700000','1700000','0','1700000','0','sby','2026-11-15 12:47:43','FJ-261115-0006','DP-04995','1700000'); 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-11-15','FJ-261115-0006','2026-11-15','12:47:44','VAN','1700000','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-261115-0006' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261115-0007','sby','1',' DP-04651SB','TOKO','SBYPSN','PSPLT-ZKAX-31-0','CINCIN PALADIUM ','','3.590','1','32.00','1517000','0','0','17800','2725000','0','0','0','2725000','VAN','00049297','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZKAX-31-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.590',berat_jual_asli=berat_jual_asli+'3.590',stock_jual='1',berat_akhir=berat_akhir-'3.590',berat_akhir_asli=berat_akhir_asli-'3.590',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='PSPLT-ZKAX-31-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-261115-0007','2026-11-15','3.590','2026-11-15','13:03:37','PLG0018994','2725000','2725000','0','2725000','0','sby','2026-11-15 13:03:36','FJ-261115-0007','DP-04651','2000000'); 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-11-15','FJ-261115-0007','2026-11-15','13:03:37','VAN','2725000','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-261115-0010','2026-11-15','2026-11-15 13:03:36','PENJUALAN : FJ-261115-0007','','TBC','725000','725000','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-261115-0011','D','2026-11-15','13:03:37','TBC','PENJUALAN','FJ-261115-0007','31044036964','725000','31044761964','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='725000' WHERE no_faktur_jual='FJ-261115-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-261115-0008','sby',' 1',' DP-04652SB','TOKO','SBYPSN','PSPLT-ZKAX-34-0','CINCIN PALADIUM ','','2.600','1','32.00','1099000','0','0','17800','2190000','0','0','0','2190000','VAN','00049300','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZKAX-34-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.600',berat_jual_asli=berat_jual_asli+'2.600',stock_jual='1',berat_akhir=berat_akhir-'2.600',berat_akhir_asli=berat_akhir_asli-'2.600',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='PSPLT-ZKAX-34-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-261115-0008','2026-11-15','2.600','2026-11-15','13:03:37','PLG0018995','2190000','2190000','0','2190000','0','sby','2026-11-15 13:03:36','FJ-261115-0007','DP-04652','1500000'); 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-11-15','FJ-261115-0008','2026-11-15','13:03:37','VAN','2190000','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-261115-0011','2026-11-15','2026-11-15 13:03:36','PENJUALAN : FJ-261115-0008','','TBC','690000','690000','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-261115-0012','D','2026-11-15','13:03:37','TBC','PENJUALAN','FJ-261115-0008','31044761964','690000','31045451964','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='1415000' WHERE no_faktur_jual='FJ-261115-0008' 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-261115-0009','sby','1',' 850K-155-0','TOKO','SBYPER','PSBY-ZIXD-71-0','CINCIN SILVER 925 ','','2.270','1','100.00','232000','0','0','17800','950000','0','0','0','950000','ARA','00046934','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZIXD-71-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='2026-11-15' AND kode_barang='PSBY-ZIXD-71-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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-261115-0009','2026-11-15','2.270','2026-11-15','13:07:43','PLG0018996','950000','950000','0','950000','0','sby','2026-11-15 13:07:43','FJ-261115-0009','','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-11-15','FJ-261115-0009','2026-11-15','13:07:43','ARA','950000','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-261115-0012','2026-11-15','2026-11-15 13:07:43','PENJUALAN : FJ-261115-0009','','TBC','950000','950000','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-261115-0013','D','2026-11-15','13:07:43','TBC','PENJUALAN','FJ-261115-0009','31045451964','950000','31046401964','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='950000' WHERE no_faktur_jual='FJ-261115-0009' LIMIT 1; 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-05237','ARA','1','GOLD','WEDDING RING WANITA','','','3.000','','75.00','1','2250000','2100000','','850000','7150000','PERMATA 5 (custom permata di bagian ulir tengah)','SIZE 12 / GRF: VERDEA','FONT:BERKSHIRE FINISHING : PUTIH GLOSSY','50000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0013','2026-11-15','2026-11-15 13:19:47','PESANAN : DP-05237','-','TBC','5000000','5000000'); 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-261115-0014','D','2026-11-15','13:19:47','TBC','PESANAN','DP-05237','31046401964','5000000','31051401964','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-05237','2026-11-15','2026-11-15','13:19:47','PLG0018997','ARA','2026-11-25','sby','2026-11-15 13:19:47','3.000','0','0','0','5000000','0','850000','7200000','7200000','2200000'); 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-05238','SULIS','1','GOLD','WED RING','','','3.000','','50.00','1','2250000','1600000','0','700000','5500000','1 zircon rosegold glosy sz 17','font vintage rotter grf Noviani .... Yayat','berat akhir kalo lebih jgn terlalu jauh','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0014','2026-11-15','2026-11-15 13:46:57','PESANAN : DP-05238','.','TBC','4400000','4400000'); 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-261115-0015','D','2026-11-15','13:46:57','TBC','PESANAN','DP-05238','31051401964','4400000','31055801964','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-05238','2026-11-15','2026-11-15','13:46:57','PLG0018998','SULIS','2026-11-29','kasirbip','2026-11-15 13:46:57','3.000','0','0','0','4400000','0','700000','5500000','5500000','1100000'); INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02322','SULIS','1','CC PLD','SZ 18 PUTIH DOFF AMPLASS FONT VINTAGE ROTTER','2.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-02322','2026-11-15','2026-11-15','13:48:49','PLG0018999','kasirbip','2026-11-29','kasirbip','2026-11-15 13:48:49','2.000','0','0','0','0','0','0','0','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-15 ','13:49:07'); 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-261115-0010','kasirbip','1',' PLBDG-0017','TOKO','BIPPLD','PLBDG-ZKXD-21-0','CINCIN PALADIUM YL01 PLBDG-00173 ','','2.080','1','17.00','467000','0','0','17800','1228000','0','0','0','1228000','SULIS','00048979','PLBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-ZKXD-21-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='PLBDG-ZKXD-21-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-261115-0010','2026-11-15','2.080','2026-11-15','13:49:53','PLG0019000','1228000','1228000','0','1228000','0','kasirbip','2026-11-15 13:49:52','FJ-261115-0010','','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-11-15','FJ-261115-0010','2026-11-15','13:49:53','SULIS','1228000','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-261115-0015','2026-11-15','2026-11-15 13:49:52','PENJUALAN : FJ-261115-0010','.','TBC','1228000','1228000','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-261115-0016','D','2026-11-15','13:49:53','TBC','PENJUALAN','FJ-261115-0010','31055801964','1228000','31057029964','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='1228000' WHERE no_faktur_jual='FJ-261115-0010' LIMIT 1; 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-05239','SAL','1','GOLD','WED RING','','','2.000','','37.50','1','2250000','1300000','0','900000','3500000','sz 13.5 putih glossy 9 zirkon','font berkshire swash grf Paisal ...','','90000','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0016','2026-11-15','2026-11-15 13:53:18','PESANAN : DP-05239','.','TBC','2872000','2872000'); 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-261115-0017','D','2026-11-15','13:53:18','TBC','PESANAN','DP-05239','31057029964','2872000','31059901964','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-05239','2026-11-15','2026-11-15','13:53:18','PLG0019001','SAL','2026-12-15','kasirbip','2026-11-15 13:53:18','2.000','0','0','0','2872000','0','900000','3590000','3590000','718000'); 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-05240','PUT','1','PER','WEDDRING','','','2.500','','925.00','1','100000','0','950000','0','950000','sz cwe 14.5 crom putih glosy','grf Pirman .... Puji font Brush','','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-261115-0017','2026-11-15','2026-11-15 13:53:33','PESANAN : DP-05240','.','TBC','950000','950000'); 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-261115-0018','D','2026-11-15','13:53:33','TBC','PESANAN','DP-05240','31059901964','950000','31060851964','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-05240','2026-11-15','2026-11-15','13:53:33','PLG0019002','PUT','2026-12-17','kasirbip','2026-11-15 13:53:33','2.500','0','0','0','950000','0','0','950000','950000','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-05241','SAL','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','800000','1850000','sz 24 putih doff semprot','font berkshire swash grf Aliya ...','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0018','2026-11-15','2026-11-15 13:54:24','PESANAN : DP-05241','.','TBC','1480000','1480000'); 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-261115-0019','D','2026-11-15','13:54:24','TBC','PESANAN','DP-05241','31060851964','1480000','31062331964','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-05241','2026-11-15','2026-11-15','13:54:24','PLG0019003','SAL','2026-12-15','kasirbip','2026-11-15 13:54:24','3.000','0','0','0','1480000','0','800000','1850000','1850000','370000'); 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-05242','PUT','1','PER','WEDDRING','','','4.000','','925.00','1','100000','0','950000','0','950000','sz cwo 21 crom putih doff semprot','grf Puji ... Pirman font Brush','','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-261115-0019','2026-11-15','2026-11-15 13:55:01','PESANAN : DP-05242','.','TBC','950000','950000'); 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-261115-0020','D','2026-11-15','13:55:01','TBC','PESANAN','DP-05242','31062331964','950000','31063281964','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-05242','2026-11-15','2026-11-15','13:55:01','PLG0019004','PUT','2026-12-17','kasirbip','2026-11-15 13:55:01','4.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-15 ','14:07:22'); 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-05243','ELLA','1','PLD','WEDDING RING','','','3.000','','925.00','1','1200000','0','0','0','950000','size 17.5 grf Nilna ?? Dicky','crom putih doff semprot','zircone 1 butir','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-261115-0020','2026-11-15','2026-11-15 14:09:56','PESANAN : DP-05243','0','TBC','950000','950000'); 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-261115-0021','D','2026-11-15','14:09:56','TBC','PESANAN','DP-05243','31063281964','950000','31064231964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','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-05243','2026-11-15','2026-11-15','14:09:56','PLG0019005','ELLA','2026-12-11','kasir','2026-11-15 14:09:56','3.000','0','0','0','950000','0','0','950000','950000','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-05244','ELLA','1','PLD','WEDDING RING','','','3.000','','925.00','1','1200000','0','0','0','950000','size 17.5 grf Nilna ?? Dicky','crom putih doff semprot','zircone 1 butir','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-261115-0021','2026-11-15','2026-11-15 14:10:00','PESANAN : DP-05244','0','TBC','950000','950000'); 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-261115-0022','D','2026-11-15','14:10:00','TBC','PESANAN','DP-05244','31064231964','950000','31065181964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','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-05244','2026-11-15','2026-11-15','14:10:00','PLG0019006','ELLA','2026-12-11','kasir','2026-11-15 14:10:00','3.000','0','0','0','950000','0','0','950000','950000','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-05245','DEW','1','PLD','WEDRING','','','2.500','','10.00','1','1200000','350000','0','800000','1675000','sz cwe 7 zircon 3','gf berksbire : Ozan...Ina','','30000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0022','2026-11-15','2026-11-15 14:12:36','PESANAN : DP-05245','-','TBC','1364000','1364000'); 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-261115-0023','D','2026-11-15','14:12:36','TBC','PESANAN','DP-05245','31065181964','1364000','31066545964','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-05245','2026-11-15','2026-11-15','14:12:36','PLG0019007','DEW','2026-12-10','jogja','2026-11-15 14:12:36','2.500','0','0','0','1364000','0','800000','1705000','1705000','341000'); 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-05246','ELLA','1','GOLD','WEDDING RING','','','2.500','','75.00','1','2250000','2100000','0','800000','6050000','size 12.5 grf Aroh ( font vintage )','crom putih glosy','zircone 15 butir','0','0','150000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0023','2026-11-15','2026-11-15 14:14:52','PESANAN : DP-05246','0','TBC','4960000','4960000'); 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-261115-0024','D','2026-11-15','14:14:52','TBC','PESANAN','DP-05246','31066545964','4960000','31071505964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','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-05246','2026-11-15','2026-11-15','14:14:52','PLG0019008','ELLA','2026-12-11','kasir','2026-11-15 14:14:52','2.500','0','0','0','4960000','0','800000','6200000','6200000','1240000'); 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-05247','DEW','1','PLD','WEDRING','','','4.000','','10.00','1','1200000','350000','0','800000','2200000','sz cwo 12','gf berksbhire : Ina & Ozan','dibikin 4 mili','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-261115-0024','2026-11-15','2026-11-15 14:15:58','PESANAN : DP-05247','-','TBC','1760000','1760000'); 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-261115-0025','D','2026-11-15','14:15:58','TBC','PESANAN','DP-05247','31071505964','1760000','31073265964','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-05247','2026-11-15','2026-11-15','14:15:58','PLG0019009','DEW','2026-12-10','jogja','2026-11-15 14:15:58','4.000','0','0','0','1760000','0','800000','2200000','2200000','440000'); 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-05248','ELLA','1','PLD','WEDDING RING','','','3.500','','10.00','1','1200000','350000','0','800000','2025000','size 18 grf Fauzan ( font vintage)','crom putih full glosy','zircone 1 butir di tengah','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-261115-0025','2026-11-15','2026-11-15 14:17:44','PESANAN : DP-05248','0','TBC','1620000','1620000'); 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-261115-0026','D','2026-11-15','14:17:44','TBC','PESANAN','DP-05248','31073265964','1620000','31074885964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','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-05248','2026-11-15','2026-11-15','14:17:44','PLG0019010','ELLA','2026-12-11','kasir','2026-11-15 14:17:44','3.500','0','0','0','1620000','0','800000','2025000','2025000','405000'); 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-05249','MIL','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','850000','0','850000','sz cwo 19 crom putih glosy doff semprot','EXSPRESS 100.000','','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-261115-0026','2026-11-15','2026-11-15 14:18:33','PESANAN : DP-05249','.','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-261115-0027','D','2026-11-15','14:18:33','TBC','PESANAN','DP-05249','31074885964','850000','31075735964','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-05249','2026-11-15','2026-11-15','14:18:33','PLG0019011','MIL','2026-11-27','kasirbip','2026-11-15 14:18:33','3.000','0','0','0','850000','0','0','850000','850000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-15 ','14:21:19'); DELETE FROM tm_berlian WHERE kode_barang='LXCM-ZKXB-52-0'; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('LXCM-ZKXB-52-0','00048870','00048870','CINCIN EMAS ','CINCIN EMAS','','','1357000','1357000',' 480000','480000','kasir','2026-11-15 14:22:41'); UPDATE tm_barang SET nama_barang='CINCIN EMAS' ,nama_atribut='' ,kode_intern='900K-85 ', kadar_cetak='375.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='LXCM-ZKXB-52-0' 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-261115-0011','kasirbip','1',' 900K-85 ','TOKO','DUCM','LXCM-ZKXB-52-0','CINCIN EMAS','','1.340','1','45.00','1385000','0','0','17800','2642000','0','0','0','2642000','MIL','00048870','LXCM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXCM-ZKXB-52-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-11-15' AND kode_barang='LXCM-ZKXB-52-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUCM' 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-261115-0011','2026-11-15','1.340','2026-11-15','14:24:03','PLG0019012','2642000','2642000','0','2642000','0','kasirbip','2026-11-15 14:24:02','FJ-261115-0011','','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-11-15','FJ-261115-0011','2026-11-15','14:24:03','MIL','2642000','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-261115-0027','2026-11-15','2026-11-15 14:24:02','PENJUALAN : FJ-261115-0011','.','TBC','2642000','2642000','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-261115-0028','D','2026-11-15','14:24:03','TBC','PENJUALAN','FJ-261115-0011','31075735964','2642000','31078377964','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='2642000' WHERE no_faktur_jual='FJ-261115-0011' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0006'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0009'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0011'; 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-05250','SULIS','1','PLD','WED RING','','','3.500','','25.00','1','1200000','550000','0','700000','2625000','sz 19 putih glosy','font vladimir grf Nabila','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0028','2026-11-15','2026-11-15 14:30:19','PESANAN : DP-05250','.','TBC','2100000','2100000'); 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-261115-0029','D','2026-11-15','14:30:19','TBC','PESANAN','DP-05250','31078377964','2100000','31080477964','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-05250','2026-11-15','2026-11-15','14:30:19','PLG0019013','SULIS','2026-12-14','kasirbip','2026-11-15 14:30:19','3.500','0','0','0','2100000','0','700000','2625000','2625000','525000'); 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-05251','SULIS','1','GOLD','WED RING','','','1.300','','50.00','1','2250000','1600000','0','750000','2830000','sz 10 putih doff semprot 1 zircon','font vladimir grf Arif','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0029','2026-11-15','2026-11-15 14:31:57','PESANAN : DP-05251','.','TBC','2260000','2260000'); 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-261115-0030','D','2026-11-15','14:31:57','TBC','PESANAN','DP-05251','31080477964','2260000','31082737964','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-05251','2026-11-15','2026-11-15','14:31:57','PLG0019014','SULIS','2026-12-14','kasirbip','2026-11-15 14:31:57','1.300','0','0','0','2260000','0','750000','2830000','2830000','570000'); 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-05252','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','850000','0','850000','sz 21 putih doff semprot setengah lingkaran ccn','font berkshire swash grf Anisa','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0030','2026-11-15','2026-11-15 14:48:12','PESANAN : DP-05252','.','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-261115-0031','D','2026-11-15','14:48:12','TBC','PESANAN','DP-05252','31082737964','850000','31083587964','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-05252','2026-11-15','2026-11-15','14:48:12','PLG0019015','SAL','2026-12-15','kasirbip','2026-11-15 14:48:12','2.000','0','0','0','850000','0','0','850000','850000','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-05253','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1300000','0','1300000','sz 14 putih glossy 35 zirkon','font berkshire swash grf Arif','model persis seperti contoh','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0031','2026-11-15','2026-11-15 14:49:51','PESANAN : DP-05253','.','TBC','1300000','1300000'); 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-261115-0032','D','2026-11-15','14:49:51','TBC','PESANAN','DP-05253','31083587964','1300000','31084887964','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-05253','2026-11-15','2026-11-15','14:49:51','PLG0019016','SAL','2026-12-15','kasirbip','2026-11-15 14:49:51','2.000','0','0','0','1300000','0','0','1300000','1300000','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-05254','KUR','1','PER','CINCIN KAWIN','','','3.000','','0.00','1','100000','0','900000','0','900000','size 21 grf FONT ARAB DI WA','putih dof amplas YL10','','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-261115-0032','2026-11-15','2026-11-15 15:25:49','PESANAN : DP-05254','.','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-261115-0033','D','2026-11-15','15:25:49','TBC','PESANAN','DP-05254','31084887964','900000','31085787964','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-05254','2026-11-15','2026-11-15','15:25:49','PLG0019017','KUR','2026-12-15','kasirbip','2026-11-15 15:25:49','3.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-05255','DIL','1','PER','WEDD RING PRIA','','','4.000','','925.00','1','100000','0','900000','0','900000','SIZE 27 GRF: J & R (BERKSHIRE)','PUTIH GLOSSY MIX DOFF','','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-261115-0033','2026-11-15','2026-11-15 15:28:29','PESANAN : DP-05255','-','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-261115-0034','D','2026-11-15','15:28:29','TBC','PESANAN','DP-05255','31085787964','900000','31086687964','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-05255','2026-11-15','2026-11-15','15:28:29','PLG0019018','DIL','2026-12-10','sby','2026-11-15 15:28:29','4.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-05256','DIL','1','PER','WEDD RING WANITA','','','2.000','','925.00','1','100000','0','900000','0','900000','PERMATA 1 BUTIR','SIZE 23.5 GRF: R & J (BERKSHIRE)','PUTIH GLOSSY MIX DOFF','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-261115-0034','2026-11-15','2026-11-15 15:30:38','PESANAN : DP-05256','-','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-261115-0035','D','2026-11-15','15:30:38','TBC','PESANAN','DP-05256','31086687964','900000','31087587964','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-05256','2026-11-15','2026-11-15','15:30:38','PLG0019019','DIL','2026-12-10','sby','2026-11-15 15:30:38','2.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-05257','KUR','1','PER','CINCIN KAWIN','','','2.000','','925.00','1','100000','0','950000','0','950000','size 14.5 grf font arab di wa','putih kilat 18 sirkon','','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-261115-0035','2026-11-15','2026-11-15 15:31:53','PESANAN : DP-05257','.','TBC','950000','950000'); 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-261115-0036','D','2026-11-15','15:31:53','TBC','PESANAN','DP-05257','31087587964','950000','31088537964','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-05257','2026-11-15','2026-11-15','15:31:53','PLG0019020','KUR','2026-12-15','kasirbip','2026-11-15 15:31:53','2.000','0','0','0','950000','0','0','950000','950000','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-05258','PUT','1','PER','WEDDRING','','','2.000','','925.00','1','100000','0','1000000','0','1000000','sz 5.5 crom putih glosy','tanpa grafir','','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-261115-0036','2026-11-15','2026-11-15 15:34:11','PESANAN : DP-05258','.','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-261115-0037','D','2026-11-15','15:34:11','TBC','PESANAN','DP-05258','31088537964','1000000','31089537964','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-05258','2026-11-15','2026-11-15','15:34:11','PLG0019021','PUT','2026-12-17','kasirbip','2026-11-15 15:34:11','2.000','0','0','0','1000000','0','0','1000000','1000000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-15 ','15:49:01'); 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-261115-0012','kasirbip','1',' 750K-115-0','TOKO','DUPERBDG','LXPER-ZJAI-53-0','CINCIN SILVER 925 ','','1.550','1','100.00','159000','0','0','17800','850000','0','0','0','850000','MIL','00048297','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZJAI-53-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='LXPER-ZJAI-53-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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-261115-0012','2026-11-15','1.550','2026-11-15','15:50:54','PLG0019022','850000','850000','0','850000','0','kasirbip','2026-11-15 15:50:54','FJ-261115-0012','','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-11-15','FJ-261115-0012','2026-11-15','15:50:54','MIL','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-261115-0037','2026-11-15','2026-11-15 15:50:54','PENJUALAN : FJ-261115-0012','.','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-261115-0038','D','2026-11-15','15:50:54','TBC','PENJUALAN','FJ-261115-0012','31089537964','850000','31090387964','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-261115-0012' LIMIT 1; 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-11-15', status ='CLOS' WHERE no_service='SV-02311'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02311'; 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-261115-0013','kasirbip','1',' DP-04720BI','TOKO','BIPPSN','PSPLT-ZKAC-6-0','CINCIN PALADIUM ','','2.890','1','32.00','1221000','0','0','17800','2339500','0','0','0','2339500','SULIS','00049383','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZKAC-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.890',berat_jual_asli=berat_jual_asli+'2.890',stock_jual='1',berat_akhir=berat_akhir-'2.890',berat_akhir_asli=berat_akhir_asli-'2.890',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='PSPLT-ZKAC-6-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-261115-0013','2026-11-15','2.890','2026-11-15','16:00:17','PLG0019023','2339500','2339500','0','2339500','0','kasirbip','2026-11-15 16:00:16','FJ-261115-0013','DP-04720','1920000'); 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-11-15','FJ-261115-0013','2026-11-15','16:00:17','SULIS','2339500','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-261115-0038','2026-11-15','2026-11-15 16:00:16','PENJUALAN : FJ-261115-0013','.','TBC','419500','419500','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-261115-0039','D','2026-11-15','16:00:17','TBC','PENJUALAN','FJ-261115-0013','31090387964','419500','31090807464','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='419500' WHERE no_faktur_jual='FJ-261115-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-261115-0014','kasirbip',' 1',' DP-04721BI','TOKO','BIPPSN','PSGT-ZKAA-36-0','CINCIN EMAS ','','2.100','1','45.00','2203000','0','0','17800','3690000','0','0','0','3690000','SULIS','00049336','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZKAA-36-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='PSGT-ZKAA-36-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-261115-0014','2026-11-15','2.100','2026-11-15','16:00:17','PLG0019024','3690000','3690000','0','3690000','0','kasirbip','2026-11-15 16:00:16','FJ-261115-0013','DP-04721','3400000'); 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-11-15','FJ-261115-0014','2026-11-15','16:00:17','SULIS','3690000','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-261115-0039','2026-11-15','2026-11-15 16:00:16','PENJUALAN : FJ-261115-0014','.','TBC','290000','290000','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-261115-0040','D','2026-11-15','16:00:17','TBC','PENJUALAN','FJ-261115-0014','31090807464','290000','31091097464','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='709500' WHERE no_faktur_jual='FJ-261115-0014' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0014'; 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-05259','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','900000','0','900000','sz 17.5 putih doff semprot 1 zirkon','font berkshire swash grf R ... R 26.12.26','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0040','2026-11-15','2026-11-15 16:15:19','PESANAN : DP-05259','.','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-261115-0041','D','2026-11-15','16:15:19','TBC','PESANAN','DP-05259','31091097464','900000','31091997464','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-05259','2026-11-15','2026-11-15','16:15:19','PLG0019025','SAL','2026-12-14','kasirbip','2026-11-15 16:15:19','2.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-05260','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1100000','0','1100000','sz 10 putih glossy 23 zirkon','font berkshire swash grf R ... R 26.12.26','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0041','2026-11-15','2026-11-15 16:17:19','PESANAN : DP-05260','.','TBC','1100000','1100000'); 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-261115-0042','D','2026-11-15','16:17:19','TBC','PESANAN','DP-05260','31091997464','1100000','31093097464','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-05260','2026-11-15','2026-11-15','16:17:19','PLG0019026','SAL','2026-12-14','kasirbip','2026-11-15 16:17:19','2.000','0','0','0','1100000','0','0','1100000','1100000','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-261115-0015','kasirbip','1',' DP-04376DU','TOKO','DUPSN','PSPRT-ZJBX-78-0','CINCIN PERAK ','','1.870','1','100.00','191000','0','0','17800','850000','0','0','0','850000','PUT','00048411','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBX-78-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.870',berat_jual_asli=berat_jual_asli+'1.870',stock_jual='1',berat_akhir=berat_akhir-'1.870',berat_akhir_asli=berat_akhir_asli-'1.870',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='PSPRT-ZJBX-78-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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-261115-0015','2026-11-15','1.870','2026-11-15','16:19:25','PLG0019027','850000','850000','0','850000','0','kasirbip','2026-11-15 16:19:24','FJ-261115-0015','DP-04376','850000'); 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-11-15','FJ-261115-0015','2026-11-15','16:19:25','PUT','850000','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-261115-0015' 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-261115-0016','kasirbip',' 1',' DP-04377DU','TOKO','DUPSN','PSPRT-ZJBA-23-0','CINCIN PERAK ','','2.250','1','100.00','230000','0','0','17800','850000','0','0','0','850000','PUT','00048453','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBA-23-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.250',berat_jual_asli=berat_jual_asli+'2.250',stock_jual='1',berat_akhir=berat_akhir-'2.250',berat_akhir_asli=berat_akhir_asli-'2.250',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='PSPRT-ZJBA-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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-261115-0016','2026-11-15','2.250','2026-11-15','16:19:25','PLG0019028','850000','850000','0','850000','0','kasirbip','2026-11-15 16:19:24','FJ-261115-0015','DP-04377','850000'); 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-11-15','FJ-261115-0016','2026-11-15','16:19:25','PUT','850000','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-261115-0016' LIMIT 1; 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-05261','ALIKA','1','GOLD','WEDDING RING','','','2.800','','375.00','1','2250000','1300000','0','900000','4540000','size 9 grf Anggi','crom putih glosy','zircone 11 btr','0','0','110000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0042','2026-11-15','2026-11-15 16:33:39','PESANAN : DP-05261','.','TBC','3720000','3720000'); 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-261115-0043','D','2026-11-15','16:33:39','TBC','PESANAN','DP-05261','31093097464','3720000','31096817464','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-05261','2026-11-15','2026-11-15','16:33:39','PLG0019029','ALIKA','2026-11-26','kasir','2026-11-15 16:33:39','2.800','0','0','0','3720000','0','900000','4650000','4650000','930000'); 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-05262','VAN','1','GOLD','WEDDRING WANITA','','','2.500','','50.00','1','2250000','1600000','0','850000','4850000','SIZE: 10.5 PERMATA 7','GRF: Fauzi(infinity)Hanifah FONT: VINTAGE','FINISHING: ROSE GOLD GLOSSY','70000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0043','2026-11-15','2026-11-15 16:34:21','PESANAN : DP-05262','-','TBC','3400000','3400000'); 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-261115-0044','D','2026-11-15','16:34:21','TBC','PESANAN','DP-05262','31096817464','3400000','31100217464','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-05262','2026-11-15','2026-11-15','16:34:21','PLG0019030','VAN','2026-12-09','sby','2026-11-15 16:34:21','2.500','0','0','0','3400000','0','850000','4920000','4920000','1520000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-11-15 ','16:35:30'); 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-261115-0017','kasir','1',' 800K-19-13','TOKO','MMPER','PMM-ZKXG-41-0','CINCIN SILVER 925 YL10 ','','4.650','1','100.00','475000','0','0','17800','950000','0','0','0','950000','ALIKA','00049170','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZKXG-41-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.650',berat_jual_asli=berat_jual_asli+'4.650',stock_jual='1',berat_akhir=berat_akhir-'4.650',berat_akhir_asli=berat_akhir_asli-'4.650',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='PMM-ZKXG-41-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-261115-0017','2026-11-15','4.650','2026-11-15','16:37:28','PLG0019031','950000','950000','0','950000','0','kasir','2026-11-15 16:37:27','FJ-261115-0017','','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-11-15','FJ-261115-0017','2026-11-15','16:37:28','ALIKA','950000','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-261115-0044','2026-11-15','2026-11-15 16:37:27','PENJUALAN : FJ-261115-0017','0','TBC','950000','950000','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-261115-0045','D','2026-11-15','16:37:28','TBC','PENJUALAN','FJ-261115-0017','31100217464','950000','31101167464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='950000' WHERE no_faktur_jual='FJ-261115-0017' LIMIT 1; 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-05263','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','600000','0','600000','SIZE: 19','GRF: Hanifah (infinity) Fauzi FONT: VINTAGE','FINISHING: PUTH DOFF MIX GLOSSY','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-261115-0045','2026-11-15','2026-11-15 16:38:21','PESANAN : DP-05263','-','TBC','600000','600000'); 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-261115-0046','D','2026-11-15','16:38:21','TBC','PESANAN','DP-05263','31101167464','600000','31101767464','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-05263','2026-11-15','2026-11-15','16:38:21','PLG0019032','VAN','2026-12-09','sby','2026-11-15 16:38:21','3.000','0','0','0','600000','0','0','600000','600000','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-261115-0018','kasirbip','1',' 950K-105-3','TOKO','BIPPER','PBDG-ZKXI-44-0','CINCIN SILVER 925 ','','1.630','1','100.00','167000','0','0','17800','1000000','0','0','0','1000000','KUR','00049226','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZKXI-44-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.630',berat_jual_asli=berat_jual_asli+'1.630',stock_jual='1',berat_akhir=berat_akhir-'1.630',berat_akhir_asli=berat_akhir_asli-'1.630',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='PBDG-ZKXI-44-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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-261115-0018','2026-11-15','1.630','2026-11-15','16:43:13','PLG0019033','1000000','1000000','0','1000000','0','kasirbip','2026-11-15 16:43:13','FJ-261115-0018','','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-11-15','FJ-261115-0018','2026-11-15','16:43:13','KUR','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-261115-0046','2026-11-15','2026-11-15 16:43:13','PENJUALAN : FJ-261115-0018','.','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-261115-0047','D','2026-11-15','16:43:13','TBC','PENJUALAN','FJ-261115-0018','31101767464','1000000','31102767464','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='FJ-261115-0018' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0015'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0016'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0017'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0018'; 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-05264','KUR','1','PER','WED RING','','','2.000','','925.00','1','100000','0','650000','0','650000','sz 15 putih doff amplas','font berkshire swash grf Eka','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0047','2026-11-15','2026-11-15 17:15:52','PESANAN : DP-05264','.','TBC','650000','650000'); 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-261115-0048','D','2026-11-15','17:15:52','TBC','PESANAN','DP-05264','31102767464','650000','31103417464','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-05264','2026-11-15','2026-11-15','17:15:52','PLG0019034','KUR','2026-12-05','kasirbip','2026-11-15 17:15:52','2.000','0','0','0','650000','0','0','650000','650000','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-05265','KUR','1','PER','WED RING','','','2.000','','925.00','1','100000','0','650000','0','650000','sz 14 putih doff amplas YL01','font berkshire swash grf Rima','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0048','2026-11-15','2026-11-15 17:16:50','PESANAN : DP-05265','.','TBC','650000','650000'); 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-261115-0049','D','2026-11-15','17:16:50','TBC','PESANAN','DP-05265','31103417464','650000','31104067464','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-05265','2026-11-15','2026-11-15','17:16:50','PLG0019035','KUR','2026-12-05','kasirbip','2026-11-15 17:16:50','2.000','0','0','0','650000','0','0','650000','650000','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-05266','VAN','1','PER','WEDDRING PRIA','','','2.000','','925.00','1','100000','0','950000','0','950000','SIZE: 8','GRF: Afandi?? FONT: YESEVA','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-261115-0049','2026-11-15','2026-11-15 17:31:35','PESANAN : DP-05266','-','TBC','950000','950000'); 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-261115-0050','D','2026-11-15','17:31:35','TBC','PESANAN','DP-05266','31104067464','950000','31105017464','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-05266','2026-11-15','2026-11-15','17:31:35','PLG0019036','VAN','2026-12-09','sby','2026-11-15 17:31:35','2.000','0','0','0','950000','0','0','950000','950000','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-05267','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','850000','0','850000','SIZE: 19','GRF: Putri?? FONT: YESEVA','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-261115-0050','2026-11-15','2026-11-15 17:33:38','PESANAN : DP-05267','-','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-261115-0051','D','2026-11-15','17:33:38','TBC','PESANAN','DP-05267','31105017464','850000','31105867464','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-05267','2026-11-15','2026-11-15','17:33:38','PLG0019037','VAN','2026-12-09','sby','2026-11-15 17:33:38','3.000','0','0','0','850000','0','0','850000','850000','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-05268','DIL','1','PLD','WEDD RING PRIA','','','4.000','','25.00','1','1200000','550000','0','750000','2950000','PERMATA 1 BUTIR','SIZE 20 GRF: Nonikca F.T (VINTAGE)','PUTIH GLOSSY MIX DOFF','10000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0051','2026-11-15','2026-11-15 17:38:02','PESANAN : DP-05268','-','TBC','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,jenis_trx) VALUES ('KM-261115-0052','D','2026-11-15','17:38:02','TBC','PESANAN','DP-05268','31105867464','2000000','31107867464','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-05268','2026-11-15','2026-11-15','17:38:02','PLG0019038','DIL','2026-12-08','sby','2026-11-15 17:38:02','4.000','0','0','0','2000000','0','750000','2960000','2960000','960000'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261115-0001','1','PSPRT-ZKAC-87-0','1','3.570','3.570','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKAC-87-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAC-87-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKAC-87-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAC-87-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-11-15 17:56:28' WHERE kode_barang='PSPRT-ZKAC-87-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKAC-87-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-15 17:56:28','TOKO','JOGPSN','PSPRT','PSPRT-ZKAC-87-0','1','3.570','','1','3.570','','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZKAC-87-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAC-87-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-15' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261115-0001','1','PSPLT-ZKAC-15-0','1','3.870','3.870','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKAC-15-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAC-15-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKAC-15-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAC-15-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-11-15 17:56:28' WHERE kode_barang='PSPLT-ZKAC-15-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKAC-15-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-15 17:56:28','TOKO','JOGPSN','PSPLT','PSPLT-ZKAC-15-0','1','3.870','','1','3.870','','32.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZKAC-15-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAC-15-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-15' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261115-0001','1','PSGT-ZKAC-16-0','1','1.510','1.510','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZKAC-16-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZKAC-16-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZKAC-16-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZKAC-16-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-11-15 17:56:28' WHERE kode_barang='PSGT-ZKAC-16-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZKAC-16-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-15 17:56:28','TOKO','JOGPSN','PSGT','PSGT-ZKAC-16-0','1','1.510','','1','1.510','','45.00'); DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZKAC-16-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKAC-16-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-15' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261115-0001','1','PSPLT-ZKAC-17-0','1','1.480','1.480','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKAC-17-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAC-17-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKAC-17-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAC-17-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-11-15 17:56:28' WHERE kode_barang='PSPLT-ZKAC-17-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKAC-17-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-15 17:56:28','TOKO','JOGPSN','PSPLT','PSPLT-ZKAC-17-0','1','1.480','','1','1.480','','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZKAC-17-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAC-17-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-15' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261115-0001','1','PSPRT-ZKAC-88-0','1','4.720','4.720','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKAC-88-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAC-88-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKAC-88-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAC-88-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-11-15 17:56:28' WHERE kode_barang='PSPRT-ZKAC-88-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKAC-88-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-15 17:56:28','TOKO','JOGPSN','PSPRT','PSPRT-ZKAC-88-0','1','4.720','','1','4.720','','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZKAC-88-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAC-88-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-15' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261115-0001','1','PSPLT-ZKAC-14-0','1','2.850','2.850','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKAC-14-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAC-14-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKAC-14-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAC-14-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-11-15 17:56:28' WHERE kode_barang='PSPLT-ZKAC-14-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKAC-14-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-15 17:56:28','TOKO','JOGPSN','PSPLT','PSPLT-ZKAC-14-0','1','2.850','','1','2.850','','32.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZKAC-14-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAC-14-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-15' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261115-0001','1','PSPLT-ZKAC-89-0','1','3.920','3.920','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKAC-89-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAC-89-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKAC-89-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAC-89-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-11-15 17:56:28' WHERE kode_barang='PSPLT-ZKAC-89-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKAC-89-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-15 17:56:28','TOKO','JOGPSN','PSPLT','PSPLT-ZKAC-89-0','1','3.920','','1','3.920','','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZKAC-89-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAC-89-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-15' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261115-0001','2026-11-15','17:54','21.920','jogja','2026-11-15 17:56:27'); 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-05269','ADL','1','GOLD','WEDRING','','','2.500','','50.00','1','2250000','1600000','0','900000','4900000','sz cwe 8.5','gfr Vintage : Ganang...Dita','zircon 15','0','0','150000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0052','2026-11-15','2026-11-15 19:20:11','PESANAN : DP-05269','-','TBC','4040000','4040000'); 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-261115-0053','D','2026-11-15','19:20:11','TBC','PESANAN','DP-05269','31107867464','4040000','31111907464','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-05269','2026-11-15','2026-11-15','19:20:11','PLG0019039','ADL','2026-12-10','jogja','2026-11-15 19:20:11','2.500','0','0','0','4040000','0','900000','5050000','5050000','1010000'); 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-05270','ADL','1','PLD','WEDRING','','','3.500','','10.00','1','1200000','350000','0','800000','2025000','sz cwo 22','gfr Vintage : Ganang...Dita','white','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-261115-0053','2026-11-15','2026-11-15 19:24:38','PESANAN : DP-05270','-','TBC','1620000','1620000'); 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-261115-0054','D','2026-11-15','19:24:38','TBC','PESANAN','DP-05270','31111907464','1620000','31113527464','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-05270','2026-11-15','2026-11-15','19:24:38','PLG0019040','ADL','2026-12-10','jogja','2026-11-15 19:24:38','3.500','0','0','0','1620000','0','800000','2025000','2025000','405000'); 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-05271','SAL','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','800000','1850000','sz 20.5 putih doff semprot','font vladimir grf Keysa','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0054','2026-11-15','2026-11-15 19:25:42','PESANAN : DP-05271','.','TBC','1480000','1480000'); 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-261115-0055','D','2026-11-15','19:25:42','TBC','PESANAN','DP-05271','31113527464','1480000','31115007464','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-05271','2026-11-15','2026-11-15','19:25:42','PLG0019041','SAL','2026-12-16','kasirbip','2026-11-15 19:25:42','3.000','0','0','0','1480000','0','800000','1850000','1850000','370000'); 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-05272','ASRI','1','PLD','WEDDING RING','','','5.000','','25.00','1','1200000','550000','0','800000','3550000','size 20.5 grf Aurel','crom putih doff semprot','express 100k','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-261115-0055','2026-11-15','2026-11-15 19:28:56','PESANAN : DP-05272','.','TBC','1775000','1775000'); 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-261115-0056','D','2026-11-15','19:28:56','TBC','PESANAN','DP-05272','31115007464','1775000','31116782464','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-05272','2026-11-15','2026-11-15','19:28:56','PLG0019042','ASRI','2026-12-03','kasir','2026-11-15 19:28:56','5.000','0','0','0','1775000','0','800000','3550000','3550000','1775000'); 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-11-15', status ='CLOS' WHERE no_service='SV-02317'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02317'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-15 ','19:39:24'); 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-05273','DEW','1','GOLD','WEDRING','','','3.000','','50.00','1','2250000','1600000','0','800000','5600000','sz cwe 14 zircon 30','gf vintage : Oyim..','warna gold','30000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0056','2026-11-15','2026-11-15 19:46:45','PESANAN : DP-05273','-','TBC','4504000','4504000'); 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-261115-0057','D','2026-11-15','19:46:45','TBC','PESANAN','DP-05273','31116782464','4504000','31121286464','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-05273','2026-11-15','2026-11-15','19:46:45','PLG0019043','DEW','2026-11-24','jogja','2026-11-15 19:46:45','3.000','0','0','0','4504000','0','800000','5630000','5630000','1126000'); 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-05274','SULIS','1','GOLD','WED RING','','','3.500','','50.00','1','2250000','1600000','0','900000','6500000','sz 9 putih glossy 26 zirkon','font berkshire swash grf Dandy','berat akhir jika lebih jgn terlalu jauh','260000','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0057','2026-11-15','2026-11-15 19:51:15','PESANAN : DP-05274','.','TBC','5400000','5400000'); 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-261115-0058','D','2026-11-15','19:51:15','TBC','PESANAN','DP-05274','31121286464','5400000','31126686464','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-05274','2026-11-15','2026-11-15','19:51:15','PLG0019044','SULIS','2026-12-14','kasirbip','2026-11-15 19:51:15','3.500','0','0','0','5400000','0','900000','6760000','6760000','1360000'); 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-05275','DEW','1','PLD','WEDRING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz cwo 17.5','gf vintage : Amelia','dibikin 3 mili','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-261115-0058','2026-11-15','2026-11-15 19:52:16','PESANAN : DP-05275','-','TBC','1446000','1446000'); 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-261115-0059','D','2026-11-15','19:52:16','TBC','PESANAN','DP-05275','31126686464','1446000','31128132464','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-05275','2026-11-15','2026-11-15','19:52:16','PLG0019045','DEW','2026-11-24','jogja','2026-11-15 19:52:16','3.000','0','0','0','1446000','0','750000','1800000','1800000','354000'); 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-05276','SULIS','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz 21 putih doff semprot','font berkshire swash grf Santika','matok berat jika lebih jgn terlalu jauh','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0059','2026-11-15','2026-11-15 19:53:54','PESANAN : DP-05276','.','TBC','1450000','1450000'); 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-261115-0060','D','2026-11-15','19:53:54','TBC','PESANAN','DP-05276','31128132464','1450000','31129582464','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-05276','2026-11-15','2026-11-15','19:53:54','PLG0019046','SULIS','2026-12-14','kasirbip','2026-11-15 19:53:54','3.000','0','0','0','1450000','0','750000','1800000','1800000','350000'); 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-261115-0019','kasirbip','1',' DP-04937BI','TOKO','BIPPSN','PSPRT-ZKAC-5-0','CINCIN PERAK SR01 YL01 ','','3.040','1','100.00','311000','0','0','17800','950000','0','0','0','950000','SULIS','00049382','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZKAC-5-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.040',berat_jual_asli=berat_jual_asli+'3.040',stock_jual='1',berat_akhir=berat_akhir-'3.040',berat_akhir_asli=berat_akhir_asli-'3.040',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='PSPRT-ZKAC-5-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-261115-0019','2026-11-15','3.040','2026-11-15','20:03:12','PLG0019047','950000','950000','0','950000','0','kasirbip','2026-11-15 20:03:12','FJ-261115-0019','DP-04937','950000'); 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-11-15','FJ-261115-0019','2026-11-15','20:03:12','SULIS','950000','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-261115-0019' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0019' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0019'; 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-05277','ARA','1','PLD','WEDDING RING WANITA','','','2.500','','50.00','1','1200000','1000000','0','750000','3250000','PERMATA 1','SIZE : 155 / GRF : Bryan','FONT : VLADINIR / FINISHING : PUTIH GLOSY MIX DOFF','10000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0060','2026-11-15','2026-11-15 20:12:01','PESANAN : DP-05277','-','TBC','2200000','2200000'); 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-261115-0061','D','2026-11-15','20:12:01','TBC','PESANAN','DP-05277','31129582464','2200000','31131782464','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-05277','2026-11-15','2026-11-15','20:12:01','PLG0019048','ARA','2026-12-09','sby','2026-11-15 20:12:01','2.500','0','0','0','2200000','0','750000','3260000','3260000','1060000'); 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-05278','ARA','1','PLD','WEDDING RING PRIA','','','4.000','','25.00','1','1200000','550000','0','700000','2900000','SIZE : 18.5','GRF : Estherina / FONT : VLADINIR','FINISHING : PUTIH GLOSSY MIX DOFF','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-261115-0061','2026-11-15','2026-11-15 20:15:59','PESANAN : DP-05278','-','TBC','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,jenis_trx) VALUES ('KM-261115-0062','D','2026-11-15','20:15:59','TBC','PESANAN','DP-05278','31131782464','2000000','31133782464','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-05278','2026-11-15','2026-11-15','20:15:59','PLG0019049','ARA','2026-12-09','sby','2026-11-15 20:15:59','4.000','0','0','0','2000000','0','700000','2900000','2900000','900000'); 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-261115-0020','sby','1',' DP-04595SB','TOKO','SBYPSN','PSPLT-ZKXE-28-0','CINCIN PALADIUM ','','3.810','1','17.00','856000','0','0','17800','2144000','0','0','0','2144000','DIL','00049048','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZKXE-28-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.810',berat_jual_asli=berat_jual_asli+'3.810',stock_jual='1',berat_akhir=berat_akhir-'3.810',berat_akhir_asli=berat_akhir_asli-'3.810',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='PSPLT-ZKXE-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-261115-0020','2026-11-15','3.810','2026-11-15','20:20:45','PLG0019050','2144000','2144000','0','2144000','0','sby','2026-11-15 20:20:45','FJ-261115-0020','DP-04595','1700000'); 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-11-15','FJ-261115-0020','2026-11-15','20:20:45','DIL','2144000','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-261115-0062','2026-11-15','2026-11-15 20:20:45','PENJUALAN : FJ-261115-0020','','TBC','444000','444000','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-261115-0063','D','2026-11-15','20:20:45','TBC','PENJUALAN','FJ-261115-0020','31133782464','444000','31134226464','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='444000' WHERE no_faktur_jual='FJ-261115-0020' LIMIT 1; 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-05279','ALIKA','1','GOLD','WEDDING RING','','','2.500','','375.00','1','2250000','1300000','0','850000','4100000','size 13 grf ? Davis ?','crom list tengah rosegold','zircone 8 btr','0','0','80000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0063','2026-11-15','2026-11-15 20:39:15','PESANAN : DP-05279','.','TBC','3328000','3328000'); 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-261115-0064','D','2026-11-15','20:39:15','TBC','PESANAN','DP-05279','31134226464','3328000','31137554464','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-05279','2026-11-15','2026-11-15','20:39:15','PLG0019051','ALIKA','2026-12-11','kasir','2026-11-15 20:39:15','2.500','0','0','0','3328000','0','850000','4180000','4180000','852000'); 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-05280','ALIKA','1','PER','WEDDING RING','','','3.500','','925.00','1','100000','0','0','0','1150000','size 19 tanpa permata','grf ? Rani ?','CROM KOMBINASI ROSEGOLD','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0064','2026-11-15','2026-11-15 20:45:43','PESANAN : DP-05280','0','TBC','1150000','1150000'); 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-261115-0065','D','2026-11-15','20:45:43','TBC','PESANAN','DP-05280','31137554464','1150000','31138704464','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','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-05280','2026-11-15','2026-11-15','20:45:43','PLG0019052','ALIKA','2026-12-11','kasir','2026-11-15 20:45:43','3.500','0','0','0','1150000','0','0','1150000','1150000','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-05281','KUR','1','PER','CINCIN KAWIN','','','2.000','','925.00','1','100000','0','950000','0','950000','size 10 grf Sansan','putih kilat sirkon8','font brush script','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-261115-0065','2026-11-15','2026-11-15 20:57:45','PESANAN : DP-05281','.','TBC','950000','950000'); 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-261115-0066','D','2026-11-15','20:57:45','TBC','PESANAN','DP-05281','31138704464','950000','31139654464','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-05281','2026-11-15','2026-11-15','20:57:45','PLG0019053','KUR','2026-12-06','kasirbip','2026-11-15 20:57:45','2.000','0','0','0','950000','0','0','950000','950000','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-05282','KUR','1','PER','CINCIN KAWIN','','','3.000','','925.00','1','100000','0','850000','0','850000','size 15.5 grf vicky','putih dof semprot','font brush script','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-261115-0066','2026-11-15','2026-11-15 21:01:29','PESANAN : DP-05282','.','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-261115-0067','D','2026-11-15','21:01:29','TBC','PESANAN','DP-05282','31139654464','850000','31140504464','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-05282','2026-11-15','2026-11-15','21:01:29','PLG0019054','KUR','2026-12-06','kasirbip','2026-11-15 21:01:29','3.000','0','0','0','850000','0','0','850000','850000','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-05283','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1200000','0','1200000','1 zircon cwe sz 12 putih glosy grf 19.12.26 Toni','cwo putih glosy sz 17 grf 19.12.26 Intan','ccn pria ganti model 350.000 font vladimir','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0067','2026-11-15','2026-11-15 21:04:22','PESANAN : DP-05283','.','TBC','1200000','1200000'); 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-261115-0068','D','2026-11-15','21:04:22','TBC','PESANAN','DP-05283','31140504464','1200000','31141704464','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-05283','2026-11-15','2026-11-15','21:04:22','PLG0019055','SULIS','2026-12-03','kasirbip','2026-11-15 21:04:22','2.000','0','0','0','1200000','0','0','1200000','1200000','0'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0020' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261115-0020' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261115-0020'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-16','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-16'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-15'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-15'; 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-11-15' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-15'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-15'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-15'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-15'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-16' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-15' 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-261116-0001','D','2026-11-16','21:47:25','TBC','SALDO AWAL','SALDO AWAL','0','31141704464','31141704464'); 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-261116-0001','D','2026-11-16','21:47:25','BCD','SALDO AWAL','SALDO AWAL','0','1468857500','1468857500'); 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-261116-0001','D','2026-11-16','21:47:25','KET','SALDO AWAL','SALDO AWAL','0','148641000','148641000'); 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-261116-0001','D','2026-11-16','21:47:25','BCK','SALDO AWAL','SALDO AWAL','0','2043408000','2043408000'); 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-261116-0001','D','2026-11-16','21:47:25','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-261116-0001','D','2026-11-16','21:47:25','','SALDO AWAL','SALDO AWAL','0','250000','250000'); 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-261116-0001','D','2026-11-16','21:47:25','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-261116-0001','D','2026-11-16','21:47:25','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000'); 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-261116-0001','D','2026-11-16','21:47:25','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000'); 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-261116-0001','D','2026-11-16','21:47:25','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-261116-0001','D','2026-11-16','21:47:25','TMR','SALDO AWAL','SALDO AWAL','0','32261000','32261000'); 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-261116-0001','D','2026-11-16','21:47:25','SHO','SALDO AWAL','SALDO AWAL','0','145535650','145535650'); UPDATE tp_system SET tgl_system='2026-11-16'; 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-05284','ARA','1','PLD','WEDDING RING PRIA','','','4.000','','10.00','1','1200000','350000','0','800000','2200000','PERMATA 1','SIZE 13 / GRF : Angga & Arina','FONT : BERKSHIRE / FINISHING : PUTIH GLOSY MIX DOFF','10000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261115-0068','2026-11-15','2026-11-15 22:04:41','PESANAN : DP-05284','-','TBC','1500000','1500000'); 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-261115-0001','D','2026-11-15','22:04:41','TBC','PESANAN','DP-05284','0','1500000','1500000','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-05284','2026-11-15','2026-11-15','22:04:41','PLG0019056','ARA','2026-12-09','sby','2026-11-15 22:04:41','4.000','0','0','0','1500000','0','800000','2210000','2210000','710000');