INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-30 ','10:13:59');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-30 ','10:39:51');
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-251130-0001','kasir','1',' DP-01392BI','TOKO','BIPPSN','PSPLT-YKBF-31-0','CINCIN PALADIUM ','','3.090','1','6.00','451000','0','0','16750','1427000','0','0','0','1427000','NITA','00040026','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YKBF-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.090',berat_jual_asli=berat_jual_asli+'3.090',stock_jual='1',berat_akhir=berat_akhir-'3.090',berat_akhir_asli=berat_akhir_asli-'3.090',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPLT-YKBF-31-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-251130-0001','2025-11-30','3.090','2025-11-30','10:41:06','PLG0007941','1427000','1427000','0','1427000','0','kasir','2025-11-30 10:41:05','FJ-251130-0001','DP-01392','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0001','2025-11-30','10:41:06','NITA','1427000','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-251130-0002','2025-11-30','2025-11-30 10:41:05','PENJUALAN : FJ-251130-0001','.','TBC','727000','727000','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-251130-0003','D','2025-11-30','10:41:06','TBC','PENJUALAN','FJ-251130-0001','18324021614','727000','18324748614','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='727000' WHERE no_faktur_jual='FJ-251130-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-251130-0002','kasir','1',' DP-01342BI','TOKO','BIPPSN','PSPRT-YKAI-22-0','CINCIN PERAK MOISSANITE 883939834','','2.400','1','100.00','147000','0','0','16750','1200000','0','0','0','1200000','SUL','00039682','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKAI-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.400',berat_jual_asli=berat_jual_asli+'2.400',stock_jual='1',berat_akhir=berat_akhir-'2.400',berat_akhir_asli=berat_akhir_asli-'2.400',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPRT-YKAI-22-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-251130-0002','2025-11-30','2.400','2025-11-30','11:03:28','PLG0007942','1200000','1200000','0','1200000','0','kasir','2025-11-30 11:03:28','FJ-251130-0002','DP-01342','1200000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0002','2025-11-30','11:03:28','SUL','1200000','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-251130-0002' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251130-0003','kasir',' 1',' DP-01341BI','TOKO','BIPPSN','PSPRT-YKAI-18-0','CINCIN PERAK ','','3.820','1','100.00','235000','0','0','16750','700000','0','0','0','700000','SUL','00039678','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKAI-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.820',berat_jual_asli=berat_jual_asli+'3.820',stock_jual='1',berat_akhir=berat_akhir-'3.820',berat_akhir_asli=berat_akhir_asli-'3.820',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPRT-YKAI-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251130-0003','2025-11-30','3.820','2025-11-30','11:03:28','PLG0007943','700000','700000','0','700000','0','kasir','2025-11-30 11:03:28','FJ-251130-0002','DP-01341','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0003','2025-11-30','11:03:28','SUL','700000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-251130-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0003';
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-01466','NITA','1','PER','WEDDING RING','','','5.000','','92.50','1','60000','0','850000','0','850000','zircon 9 krum putih glosy','size 11 grf Fajar font vintage','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251130-0003','2025-11-30','2025-11-30 11:54:00','PESANAN : DP-01466','.','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-251130-0004','D','2025-11-30','11:54:00','TBC','PESANAN','DP-01466','18324748614','850000','18325598614','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-01466','2025-11-30','2025-11-30','11:54:00','PLG0007944','NITA','2025-12-29','kasir','2025-11-30 11:54:00','5.000','0','0','0','850000','0','0','850000','850000','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-251130-0004','kasir','1',' 700K-12-19','TOKO','BIPPER','PBDG-YKBE-94-0','CINCIN SILVER 925 ','','1.630','1','100.00','100000','0','0','16750','700000','0','0','0','700000','SUL','00039926','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-94-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='2025-11-30' AND kode_barang='PBDG-YKBE-94-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-251130-0004','2025-11-30','1.630','2025-11-30','11:57:10','PLG0007945','700000','700000','0','700000','0','kasir','2025-11-30 11:57:10','FJ-251130-0004','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0004','2025-11-30','11:57:10','SUL','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251130-0004','2025-11-30','2025-11-30 11:57:10','PENJUALAN : FJ-251130-0004','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251130-0005','D','2025-11-30','11:57:10','TBC','PENJUALAN','FJ-251130-0004','18325598614','700000','18326298614','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='700000' WHERE no_faktur_jual='FJ-251130-0004' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251130-0005','kasir',' 1',' 700K-165-1','TOKO','BIPPER','PBDG-YKBE-95-0','CINCIN SILVER 925 ','','2.210','1','100.00','136000','0','0','16750','700000','0','0','0','700000','SUL','00039927','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-95-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.210',berat_jual_asli=berat_jual_asli+'2.210',stock_jual='1',berat_akhir=berat_akhir-'2.210',berat_akhir_asli=berat_akhir_asli-'2.210',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PBDG-YKBE-95-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-251130-0005','2025-11-30','2.210','2025-11-30','11:57:10','PLG0007946','700000','700000','0','700000','0','kasir','2025-11-30 11:57:10','FJ-251130-0004','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0005','2025-11-30','11:57:10','SUL','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251130-0005','2025-11-30','2025-11-30 11:57:10','PENJUALAN : FJ-251130-0005','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251130-0006','D','2025-11-30','11:57:10','TBC','PENJUALAN','FJ-251130-0005','18326298614','700000','18326998614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1400000' WHERE no_faktur_jual='FJ-251130-0005' 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-01467','NITA','1','PER','WEDDING RING','','','5.000','','92.50','1','60000','0','700000','0','700000','krum pth doff semprot','size 23','grf Shofi font vintage','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-251130-0006','2025-11-30','2025-11-30 12:00:15','PESANAN : DP-01467','.','TBC','700000','700000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251130-0007','D','2025-11-30','12:00:15','TBC','PESANAN','DP-01467','18326998614','700000','18327698614','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-01467','2025-11-30','2025-11-30','12:00:15','PLG0007947','NITA','2025-12-29','kasir','2025-11-30 12:00:15','5.000','0','0','0','700000','0','0','700000','700000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251130-0006','kasir','1',' 700K-16-18','TOKO','BIPPER','PBDG-YKBE-88-0','CINCIN SILVER 925 ','','2.770','1','100.00','170000','0','0','16750','650000','0','0','0','650000','HELMI','00039920','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-88-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.770',berat_jual_asli=berat_jual_asli+'2.770',stock_jual='1',berat_akhir=berat_akhir-'2.770',berat_akhir_asli=berat_akhir_asli-'2.770',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PBDG-YKBE-88-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-251130-0006','2025-11-30','2.770','2025-11-30','12:11:04','PLG0007948','650000','650000','0','650000','0','kasir','2025-11-30 12:11:04','FJ-251130-0006','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0006','2025-11-30','12:11:04','HELMI','650000','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-251130-0007','2025-11-30','2025-11-30 12:11:04','PENJUALAN : FJ-251130-0006','.','TBC','650000','650000','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-251130-0008','D','2025-11-30','12:11:04','TBC','PENJUALAN','FJ-251130-0006','18327698614','650000','18328348614','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='650000' WHERE no_faktur_jual='FJ-251130-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0006';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251130-0007','kasir','1',' 500K-195-5','TOKO','MMPER','PMM-YKAD-32-0','CINCIN SILVER 925 ','','2.030','1','100.00','125000','0','0','16750','500000','0','0','0','500000','NAD','00039609','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKAD-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PMM-YKAD-32-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-251130-0007','2025-11-30','2.030','2025-11-30','12:32:14','PLG0007949','500000','500000','0','500000','0','kasir','2025-11-30 12:32:14','FJ-251130-0007','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0007','2025-11-30','12:32:14','NAD','500000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251130-0008','2025-11-30','2025-11-30 12:32:14','PENJUALAN : FJ-251130-0007','.','TBC','500000','500000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251130-0009','D','2025-11-30','12:32:14','TBC','PENJUALAN','FJ-251130-0007','18328348614','500000','18328848614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='500000' WHERE no_faktur_jual='FJ-251130-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0007';
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-251130-0008','kasir','1',' 700K-17-18','TOKO','BIPPER','PBDG-YKBE-51-0','CINCIN SILVER 925 ','','3.330','1','100.00','204000','0','0','16750','650000','0','0','0','650000','SUL','00039883','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-51-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.330',berat_jual_asli=berat_jual_asli+'3.330',stock_jual='1',berat_akhir=berat_akhir-'3.330',berat_akhir_asli=berat_akhir_asli-'3.330',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PBDG-YKBE-51-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-251130-0008','2025-11-30','3.330','2025-11-30','12:52:17','PLG0007950','650000','650000','0','650000','0','kasir','2025-11-30 12:52:17','FJ-251130-0008','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0008','2025-11-30','12:52:17','SUL','650000','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-251130-0009','2025-11-30','2025-11-30 12:52:17','PENJUALAN : FJ-251130-0008','.','TBC','650000','650000','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-251130-0010','D','2025-11-30','12:52:17','TBC','PENJUALAN','FJ-251130-0008','18328848614','650000','18329498614','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='650000' WHERE no_faktur_jual='FJ-251130-0008' 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-01468','SULIS','1','PER','WED RING','','','2.000','','925.00','1','60000','0','1000000','0','1000000','sz 22 putih glosy','font times new roman grf BN&DAF','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251130-0010','2025-11-30','2025-11-30 13:02:55','PESANAN : DP-01468','.','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-251130-0011','D','2025-11-30','13:02:55','TBC','PESANAN','DP-01468','18329498614','1000000','18330498614','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-01468','2025-11-30','2025-11-30','13:02:55','PLG0007951','SULIS','2025-12-20','kasir','2025-11-30 13:02:55','2.000','0','0','0','1000000','0','0','1000000','1000000','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-251130-0009','kasir','1',' 700K-20-18','TOKO','BIPPER','PBDG-YKBD-10-0','CINCIN SILVER 925 ','','4.150','1','100.00','255000','0','0','16750','650000','0','0','0','650000','NITA','00039782','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBD-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.150',berat_jual_asli=berat_jual_asli+'4.150',stock_jual='1',berat_akhir=berat_akhir-'4.150',berat_akhir_asli=berat_akhir_asli-'4.150',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PBDG-YKBD-10-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-251130-0009','2025-11-30','4.150','2025-11-30','13:04:38','PLG0007952','650000','650000','0','650000','0','kasir','2025-11-30 13:04:38','FJ-251130-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('2025-11-30','FJ-251130-0009','2025-11-30','13:04:38','NITA','650000','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-251130-0011','2025-11-30','2025-11-30 13:04:38','PENJUALAN : FJ-251130-0009','.','TBC','650000','650000','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-251130-0012','D','2025-11-30','13:04:38','TBC','PENJUALAN','FJ-251130-0009','18330498614','650000','18331148614','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='650000' WHERE no_faktur_jual='FJ-251130-0009' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251130-0010','kasir',' 1',' 1.050K-155','TOKO','BIPPER','PBDG-YKBE-53-0','CINCIN SILVER 925 ','','2.380','1','100.00','146000','0','0','16750','1000000','0','0','0','1000000','NITA','00039885','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-53-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.380',berat_jual_asli=berat_jual_asli+'2.380',stock_jual='1',berat_akhir=berat_akhir-'2.380',berat_akhir_asli=berat_akhir_asli-'2.380',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PBDG-YKBE-53-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-251130-0010','2025-11-30','2.380','2025-11-30','13:04:38','PLG0007953','1000000','1000000','0','1000000','0','kasir','2025-11-30 13:04:38','FJ-251130-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('2025-11-30','FJ-251130-0010','2025-11-30','13:04:38','NITA','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-251130-0012','2025-11-30','2025-11-30 13:04:38','PENJUALAN : FJ-251130-0010','.','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-251130-0013','D','2025-11-30','13:04:38','TBC','PENJUALAN','FJ-251130-0010','18331148614','1000000','18332148614','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='1650000' WHERE no_faktur_jual='FJ-251130-0010' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01520','SULIS','1','CC SILVER','SZ 16 PUTIH GLOSY FONT TIMES NEW ROMAN','3.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-01520','2025-11-30','2025-11-30','13:06:44','PLG0007954','kasir','2025-12-10','kasir','2025-11-30 13:06:44','3.000','0','0','0','0','0','0','0','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01521','SULIS','1','SEPASANG SILVER','CWE SZ 11 FONT BERKSHIRE SWASH PUTIH DOF SEMPROT KEDUANYA','4.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-01521','2025-11-30','2025-11-30','13:08:09','PLG0007955','kasir','2025-12-10','kasir','2025-11-30 13:08:09','4.000','0','0','0','0','0','0','0','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01522','NITA','1','SEPASANG SILVER','CWE 10 CWO 18 FONT VLADIMIR CROM SPT ASAL','4.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-01522','2025-11-30','2025-11-30','13:09:32','PLG0007956','kasir','2025-12-10','kasir','2025-11-30 13:09:32','4.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-30 ','13:10:04');
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-251130-0011','kasir','1',' 700K-125-1','TOKO','BIPPER','PBDG-YKBE-29-0','CINCIN SILVER 925 ','','1.610','1','100.00','99000','0','0','16750','650000','0','0','0','650000','SUL','00039861','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PBDG-YKBE-29-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-251130-0011','2025-11-30','1.610','2025-11-30','13:35:38','PLG0007957','650000','650000','0','650000','0','kasir','2025-11-30 13:35:37','FJ-251130-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('2025-11-30','FJ-251130-0011','2025-11-30','13:35:38','SUL','650000','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-251130-0013','2025-11-30','2025-11-30 13:35:37','PENJUALAN : FJ-251130-0011','.','TBC','650000','650000','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-251130-0014','D','2025-11-30','13:35:38','TBC','PENJUALAN','FJ-251130-0011','18332148614','650000','18332798614','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='650000' WHERE no_faktur_jual='FJ-251130-0011' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251130-0012','kasir',' 1',' 700K-18-19','TOKO','BIPPER','PBDG-YKBE-109-0','CINCIN SILVER 925 ','','2.660','1','100.00','164000','0','0','16750','650000','0','0','0','650000','SUL','00039941','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-109-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.660',berat_jual_asli=berat_jual_asli+'2.660',stock_jual='1',berat_akhir=berat_akhir-'2.660',berat_akhir_asli=berat_akhir_asli-'2.660',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PBDG-YKBE-109-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-251130-0012','2025-11-30','2.660','2025-11-30','13:35:38','PLG0007958','650000','650000','0','650000','0','kasir','2025-11-30 13:35:37','FJ-251130-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('2025-11-30','FJ-251130-0012','2025-11-30','13:35:38','SUL','650000','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-251130-0014','2025-11-30','2025-11-30 13:35:37','PENJUALAN : FJ-251130-0012','.','TBC','650000','650000','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-251130-0015','D','2025-11-30','13:35:38','TBC','PENJUALAN','FJ-251130-0012','18332798614','650000','18333448614','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='1300000' WHERE no_faktur_jual='FJ-251130-0012' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01523','NAD','1','CINCIN NIKAH','CINCIN WANITA RESIZE KE 5 GRF KHIRZAH CINCIN PRIA GRF RETNO KRUM FULL PUTIH SESUAI CTH','3.320','2','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-01523','2025-11-30','2025-11-30','13:45:00','PLG0007959','kasir','2025-12-01','kasir','2025-11-30 13:45:00','3.320','0','0','0','0','0','0','0','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251130-0013','kasir','1',' DP-01411MM','TOKO','MMPSN','PSPRT-YKBH-1-0','CINCIN PERAK ','','1.860','1','100.00','115000','0','0','16750','700000','0','0','0','700000','NAD','00040045','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKBH-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.860',berat_jual_asli=berat_jual_asli+'1.860',stock_jual='1',berat_akhir=berat_akhir-'1.860',berat_akhir_asli=berat_akhir_asli-'1.860',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPRT-YKBH-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-251130-0013','2025-11-30','1.860','2025-11-30','13:48:59','PLG0007960','700000','700000','0','700000','0','kasir','2025-11-30 13:48:58','FJ-251130-0013','DP-01411','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0013','2025-11-30','13:48:59','NAD','700000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-251130-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-251130-0014','kasir','1',' DP-01357BI','TOKO','BIPPSN','PSPLT-YKBF-27-0','CINCIN PALADIUM ','','3.470','1','6.00','507000','0','0','16750','1741000','0','0','0','1741000','HELMI','00040022','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YKBF-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.470',berat_jual_asli=berat_jual_asli+'3.470',stock_jual='1',berat_akhir=berat_akhir-'3.470',berat_akhir_asli=berat_akhir_asli-'3.470',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPLT-YKBF-27-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-251130-0014','2025-11-30','3.470','2025-11-30','13:50:42','PLG0007961','1741000','1741000','0','1741000','0','kasir','2025-11-30 13:50:41','FJ-251130-0014','DP-01357','875000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0014','2025-11-30','13:50:42','HELMI','1741000','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-251130-0015','2025-11-30','2025-11-30 13:50:41','PENJUALAN : FJ-251130-0014','.','TBC','866000','866000','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-251130-0016','D','2025-11-30','13:50:42','TBC','PENJUALAN','FJ-251130-0014','18333448614','866000','18334314614','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='866000' WHERE no_faktur_jual='FJ-251130-0014' 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-251130-0015','kasir','1',' 500K-18-55','TOKO','MMPER','PMM-YKAD-35-0','CINCIN SILVER 925 ','','1.990','1','100.00','122000','0','0','16750','450000','0','0','0','450000','NAD','00039612','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKAD-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.990',berat_jual_asli=berat_jual_asli+'1.990',stock_jual='1',berat_akhir=berat_akhir-'1.990',berat_akhir_asli=berat_akhir_asli-'1.990',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PMM-YKAD-35-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-251130-0015','2025-11-30','1.990','2025-11-30','14:00:04','PLG0007962','450000','450000','0','450000','0','kasir','2025-11-30 14:00:04','FJ-251130-0015','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0015','2025-11-30','14:00:04','NAD','450000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251130-0016','2025-11-30','2025-11-30 14:00:04','PENJUALAN : FJ-251130-0015','.','TBC','450000','450000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251130-0017','D','2025-11-30','14:00:04','TBC','PENJUALAN','FJ-251130-0015','18334314614','450000','18334764614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='450000' WHERE no_faktur_jual='FJ-251130-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-251130-0016','kasir',' 1',' 700K-11-00','TOKO','MMPER','PMM-YIXH-23-0','CINCIN SILVER 925 ','','1.330','1','100.00','35000','0','0','16750','650000','0','0','0','650000','NAD','00038617','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YIXH-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.330',berat_jual_asli=berat_jual_asli+'1.330',stock_jual='1',berat_akhir=berat_akhir-'1.330',berat_akhir_asli=berat_akhir_asli-'1.330',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PMM-YIXH-23-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-251130-0016','2025-11-30','1.330','2025-11-30','14:00:04','PLG0007963','650000','650000','0','650000','0','kasir','2025-11-30 14:00:04','FJ-251130-0015','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0016','2025-11-30','14:00:04','NAD','650000','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-251130-0017','2025-11-30','2025-11-30 14:00:04','PENJUALAN : FJ-251130-0016','.','TBC','650000','650000','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-251130-0018','D','2025-11-30','14:00:04','TBC','PENJUALAN','FJ-251130-0016','18334764614','650000','18335414614','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='1100000' WHERE no_faktur_jual='FJ-251130-0016' 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-251130-0017','kasir','1',' 700K-10-00','TOKO','MMPER','PMM-YFBC-41-0','CINCIN SILVER 925 ','','2.340','1','100.00','55000','0','0','16750','650000','0','0','0','650000','NIS','00036651','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBC-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.340',berat_jual_asli=berat_jual_asli+'2.340',stock_jual='1',berat_akhir=berat_akhir-'2.340',berat_akhir_asli=berat_akhir_asli-'2.340',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PMM-YFBC-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-251130-0017','2025-11-30','2.340','2025-11-30','14:02:40','PLG0007964','650000','650000','0','650000','0','kasir','2025-11-30 14:02:40','FJ-251130-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('2025-11-30','FJ-251130-0017','2025-11-30','14:02:40','NIS','650000','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-251130-0018','2025-11-30','2025-11-30 14:02:40','PENJUALAN : FJ-251130-0017','.','TBC','650000','650000','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-251130-0019','D','2025-11-30','14:02:40','TBC','PENJUALAN','FJ-251130-0017','18335414614','650000','18336064614','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='650000' WHERE no_faktur_jual='FJ-251130-0017' 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-251130-0018','kasir',' 1',' 1.0K-12-62','TOKO','MMPER','PMM-YKBF-20-0','CINCIN SILVER 925 ','','1.700','1','100.00','105000','0','0','16750','950000','0','0','0','950000','NIS','00040015','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKBF-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PMM-YKBF-20-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-251130-0018','2025-11-30','1.700','2025-11-30','14:02:40','PLG0007965','950000','950000','0','950000','0','kasir','2025-11-30 14:02:40','FJ-251130-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('2025-11-30','FJ-251130-0018','2025-11-30','14:02:40','NIS','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-251130-0019','2025-11-30','2025-11-30 14:02:40','PENJUALAN : FJ-251130-0018','.','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-251130-0020','D','2025-11-30','14:02:40','TBC','PENJUALAN','FJ-251130-0018','18336064614','950000','18337014614','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='1600000' WHERE no_faktur_jual='FJ-251130-0018' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01524','NIS','1','2PCS CINCIN SLV','CEWE RESIZE KE 11 GRF RISKI DAN COWO RESIZE KE 14 GRF AVISTA','4.040','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-01524','2025-11-30','2025-11-30','14:07:20','PLG0007966','kasir','2025-12-01','kasir','2025-11-30 14:07:20','4.040','0','0','0','0','0','0','0','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251130-0019','kasir','1',' DP-01408MM','TOKO','MMPSN','PSGT-YKBH-23-0','CINCIN EMAS ','','3.030','1','83.00','5696000','0','0','16750','7493000','0','0','0','7493000','NIS','00040067','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YKBH-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.030',berat_jual_asli=berat_jual_asli+'3.030',stock_jual='1',berat_akhir=berat_akhir-'3.030',berat_akhir_asli=berat_akhir_asli-'3.030',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSGT-YKBH-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-251130-0019','2025-11-30','3.030','2025-11-30','15:01:33','PLG0007967','7493000','7493000','0','7493000','0','kasir','2025-11-30 15:01:33','FJ-251130-0019','DP-01408','5920000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0019','2025-11-30','15:01:33','NIS','7493000','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-251130-0020','2025-11-30','2025-11-30 15:01:33','PENJUALAN : FJ-251130-0019','.','TBC','1573000','1573000','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-251130-0021','D','2025-11-30','15:01:33','TBC','PENJUALAN','FJ-251130-0019','18337014614','1573000','18338587614','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='1573000' WHERE no_faktur_jual='FJ-251130-0019' 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-251130-0020','kasir','1',' DP-01409MM','TOKO','MMPSN','PSPLT-YKBD-1-0','CINCIN PALADIUM ','','2.930','1','6.00','422000','0','0','16750','1579000','0','0','0','1579000','NAD','00039773','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YKBD-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.930',berat_jual_asli=berat_jual_asli+'2.930',stock_jual='1',berat_akhir=berat_akhir-'2.930',berat_akhir_asli=berat_akhir_asli-'2.930',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPLT-YKBD-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-251130-0020','2025-11-30','2.930','2025-11-30','15:01:59','PLG0007968','1579000','1579000','0','1579000','0','kasir','2025-11-30 15:01:58','FJ-251130-0020','DP-01409','1280000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0020','2025-11-30','15:01:59','NAD','1579000','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-251130-0021','2025-11-30','2025-11-30 15:01:58','PENJUALAN : FJ-251130-0020','.','TBC','299000','299000','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-251130-0022','D','2025-11-30','15:01:59','TBC','PENJUALAN','FJ-251130-0020','18338587614','299000','18338886614','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='299000' WHERE no_faktur_jual='FJ-251130-0020' 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-251130-0021','kasir','1',' 700K-16-19','TOKO','BIPPER','PBDG-YKBE-127-0','CINCIN SILVER 925 ','','2.360','1','100.00','145000','0','0','16750','650000','0','0','0','650000','HELMI','00039959','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-127-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.360',berat_jual_asli=berat_jual_asli+'2.360',stock_jual='1',berat_akhir=berat_akhir-'2.360',berat_akhir_asli=berat_akhir_asli-'2.360',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PBDG-YKBE-127-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-251130-0021','2025-11-30','2.360','2025-11-30','15:25:23','PLG0007969','650000','650000','0','650000','0','kasir','2025-11-30 15:25:23','FJ-251130-0021','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0021','2025-11-30','15:25:23','HELMI','650000','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-251130-0022','2025-11-30','2025-11-30 15:25:23','PENJUALAN : FJ-251130-0021','.','TBC','650000','650000','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-251130-0023','D','2025-11-30','15:25:23','TBC','PENJUALAN','FJ-251130-0021','18338886614','650000','18339536614','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='650000' WHERE no_faktur_jual='FJ-251130-0021' 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-251130-0022','kasir',' 1',' 950K-135-1','TOKO','BIPPER','PBDG-YKBE-100-0','CINCIN SILVER 925 ','','1.550','1','100.00','95000','0','0','16750','900000','0','0','0','900000','HELMI','00039932','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-100-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='2025-11-30' AND kode_barang='PBDG-YKBE-100-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-251130-0022','2025-11-30','1.550','2025-11-30','15:25:23','PLG0007970','900000','900000','0','900000','0','kasir','2025-11-30 15:25:23','FJ-251130-0021','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0022','2025-11-30','15:25:23','HELMI','900000','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-251130-0023','2025-11-30','2025-11-30 15:25:23','PENJUALAN : FJ-251130-0022','.','TBC','900000','900000','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-251130-0024','D','2025-11-30','15:25:23','TBC','PENJUALAN','FJ-251130-0022','18339536614','900000','18340436614','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='1550000' WHERE no_faktur_jual='FJ-251130-0022' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0019';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0020';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0022';
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-251130-0023','kasir','1',' 700K-14-61','TOKO','MMPER','PMM-YKBF-8-0','CINCIN SILVER 925 ','','1.650','1','100.00','101000','0','0','16750','650000','0','0','0','650000','NIS','00040003','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKBF-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.650',berat_jual_asli=berat_jual_asli+'1.650',stock_jual='1',berat_akhir=berat_akhir-'1.650',berat_akhir_asli=berat_akhir_asli-'1.650',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PMM-YKBF-8-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-251130-0023','2025-11-30','1.650','2025-11-30','15:41:15','PLG0007971','650000','650000','0','650000','0','kasir','2025-11-30 15:41:15','FJ-251130-0023','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0023','2025-11-30','15:41:15','NIS','650000','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-251130-0024','2025-11-30','2025-11-30 15:41:15','PENJUALAN : FJ-251130-0023','.','TBC','650000','650000','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-251130-0025','D','2025-11-30','15:41:15','TBC','PENJUALAN','FJ-251130-0023','18340436614','650000','18341086614','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='650000' WHERE no_faktur_jual='FJ-251130-0023' 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-01469','SULIS','1','PLD','WED RING','','','2.500','','10.00','1','2200000','300000','0','750000','1500000','5 zircon putih glosy komb rosegold glosy','sz 14.5 font brush script','grf Sultan','50000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251130-0025','2025-11-30','2025-11-30 15:43:47','PESANAN : DP-01469','.','TBC','775000','775000');
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-251130-0026','D','2025-11-30','15:43:47','TBC','PESANAN','DP-01469','18341086614','775000','18341861614','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-01469','2025-11-30','2025-11-30','15:43:47','PLG0007972','SULIS','2025-12-20','kasir','2025-11-30 15:43:47','2.500','0','0','0','775000','0','750000','1550000','1550000','775000');
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-01470','SULIS','1','PLD','WED RING','','','3.000','','10.00','1','2200000','300000','0','700000','1600000','sz 14 putih doff semprot','font brush script grf Ajeung','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251130-0026','2025-11-30','2025-11-30 15:45:15','PESANAN : DP-01470','.','TBC','800000','800000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251130-0027','D','2025-11-30','15:45:15','TBC','PESANAN','DP-01470','18341861614','800000','18342661614','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-01470','2025-11-30','2025-11-30','15:45:15','PLG0007973','SULIS','2025-12-20','kasir','2025-11-30 15:45:15','3.000','0','0','0','800000','0','700000','1600000','1600000','800000');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01525','HELMI','1','SEPASANG CC SLV','CEWE JD SIZE 11 COWO JD SIZE 15 5','5.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01525','2025-11-30','2025-11-30','15:52:32','PLG0007974','kasir','2025-12-01','kasir','2025-11-30 15:52:32','5.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-30 ','15:52:50');
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-251130-0024','kasir','1',' 700K-185-0','TOKO','MMPER','PMM-YFBX-95-0','CINCIN SILVER 925 ','','3.160','1','100.00','74000','0','0','16750','650000','0','0','0','650000','NAD','00036536','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-95-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.160',berat_jual_asli=berat_jual_asli+'3.160',stock_jual='1',berat_akhir=berat_akhir-'3.160',berat_akhir_asli=berat_akhir_asli-'3.160',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PMM-YFBX-95-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-251130-0024','2025-11-30','3.160','2025-11-30','15:53:19','PLG0007975','650000','650000','0','650000','0','kasir','2025-11-30 15:53:18','FJ-251130-0024','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0024','2025-11-30','15:53:19','NAD','650000','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-251130-0027','2025-11-30','2025-11-30 15:53:18','PENJUALAN : FJ-251130-0024','.','TBC','650000','650000','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-251130-0028','D','2025-11-30','15:53:19','TBC','PENJUALAN','FJ-251130-0024','18342661614','650000','18343311614','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='650000' WHERE no_faktur_jual='FJ-251130-0024' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01526','HELMI','1','CC SLV','SALAH KRUM HARUSNYA KOMBINASI RG YA','3.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-01526','2025-11-30','2025-11-30','15:59:07','PLG0007976','kasir','2025-12-01','kasir','2025-11-30 15:59:07','3.000','0','0','0','0','0','0','0','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251130-0025','kasir','1',' 700K-16-19','TOKO','BIPPER','PBDG-YKBE-97-0','CINCIN SILVER 925 ','','2.550','1','100.00','157000','0','0','16750','650000','0','0','0','650000','NITA','00039929','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-97-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.550',berat_jual_asli=berat_jual_asli+'2.550',stock_jual='1',berat_akhir=berat_akhir-'2.550',berat_akhir_asli=berat_akhir_asli-'2.550',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PBDG-YKBE-97-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-251130-0025','2025-11-30','2.550','2025-11-30','16:06:59','PLG0007977','650000','650000','0','650000','0','kasir','2025-11-30 16:06:59','FJ-251130-0025','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0025','2025-11-30','16:06:59','NITA','650000','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-251130-0028','2025-11-30','2025-11-30 16:06:59','PENJUALAN : FJ-251130-0025','.','TBC','650000','650000','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-251130-0029','D','2025-11-30','16:06:59','TBC','PENJUALAN','FJ-251130-0025','18343311614','650000','18343961614','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='650000' WHERE no_faktur_jual='FJ-251130-0025' 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-251130-0026','kasir',' 1',' 950K-12-19','TOKO','BIPPER','PBDG-YKBE-99-0','CINCIN SILVER 925 ','','1.690','1','100.00','104000','0','0','16750','900000','0','0','0','900000','NITA','00039931','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-99-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.690',berat_jual_asli=berat_jual_asli+'1.690',stock_jual='1',berat_akhir=berat_akhir-'1.690',berat_akhir_asli=berat_akhir_asli-'1.690',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PBDG-YKBE-99-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-251130-0026','2025-11-30','1.690','2025-11-30','16:06:59','PLG0007978','900000','900000','0','900000','0','kasir','2025-11-30 16:06:59','FJ-251130-0025','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0026','2025-11-30','16:06:59','NITA','900000','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-251130-0029','2025-11-30','2025-11-30 16:06:59','PENJUALAN : FJ-251130-0026','.','TBC','900000','900000','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-251130-0030','D','2025-11-30','16:06:59','TBC','PENJUALAN','FJ-251130-0026','18343961614','900000','18344861614','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='1550000' WHERE no_faktur_jual='FJ-251130-0026' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0023';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0024' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0024' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0024';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0025' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0025' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0025';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0026' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0026' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0026';
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-251130-0027','kasir','1',' DP-01427BI','TOKO','BIPPSN','PSPRT-YKBH-19-0','CINCIN PERAK ','','3.540','1','100.00','217000','0','0','16750','750000','0','0','0','750000','SUL','00040063','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKBH-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.540',berat_jual_asli=berat_jual_asli+'3.540',stock_jual='1',berat_akhir=berat_akhir-'3.540',berat_akhir_asli=berat_akhir_asli-'3.540',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPRT-YKBH-19-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-251130-0027','2025-11-30','3.540','2025-11-30','16:11:37','PLG0007979','750000','750000','0','750000','0','kasir','2025-11-30 16:11:37','FJ-251130-0027','DP-01427','750000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0027','2025-11-30','16:11:37','SUL','750000','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-251130-0027' 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-251130-0028','kasir','1',' DP-01260BI','TOKO','BIPPSN','PSPLT-YKXD-7-0','CINCIN PALADIUM ','','3.430','1','6.00','485000','0','0','16750','1557500','0','0','0','1557500','HELMI','00039454','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YKXD-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.430',berat_jual_asli=berat_jual_asli+'3.430',stock_jual='1',berat_akhir=berat_akhir-'3.430',berat_akhir_asli=berat_akhir_asli-'3.430',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPLT-YKXD-7-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-251130-0028','2025-11-30','3.430','2025-11-30','16:19:47','PLG0007980','1557500','1557500','0','1557500','0','kasir','2025-11-30 16:19:47','FJ-251130-0028','DP-01260','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('2025-11-30','FJ-251130-0028','2025-11-30','16:19:47','HELMI','1557500','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-251130-0030','2025-11-30','2025-11-30 16:19:47','PENJUALAN : FJ-251130-0028','.','TBC','1557500','1557500','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-251130-0031','D','2025-11-30','16:19:47','TBC','PENJUALAN','FJ-251130-0028','18344861614','1557500','18346419114','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='1557500' WHERE no_faktur_jual='FJ-251130-0028' 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-251130-0029','kasir',' 1',' DP-01259BI','TOKO','BIPPSN','PSGT-YKXF-3-0','CINCIN EMAS ','','2.910','1','83.00','5248000','0','0','16750','6925500','0','0','0','6925500','HELMI','00039480','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YKXF-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.910',berat_jual_asli=berat_jual_asli+'2.910',stock_jual='1',berat_akhir=berat_akhir-'2.910',berat_akhir_asli=berat_akhir_asli-'2.910',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSGT-YKXF-3-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-251130-0029','2025-11-30','2.910','2025-11-30','16:19:47','PLG0007981','6925500','6925500','0','6925500','0','kasir','2025-11-30 16:19:47','FJ-251130-0028','DP-01259','5688000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0029','2025-11-30','16:19:47','HELMI','6925500','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1557500' WHERE no_faktur_jual='FJ-251130-0029' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0027' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0027' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0027';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0028' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0028' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0028';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0029' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0029' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0029';
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-01471','HELMI','1','PER','WEDDING RING','','','3.000','','925.00','1','60000','0','700000','0','700000','size 18 grf Rahma','model seperti contoh','krum putih doff amplas','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251130-0031','2025-11-30','2025-11-30 16:32:50','PESANAN : DP-01471','.','TBC','700000','700000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251130-0032','D','2025-11-30','16:32:50','TBC','PESANAN','DP-01471','18346419114','700000','18347119114','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-01471','2025-11-30','2025-11-30','16:32:50','PLG0007982','HELMI','2025-12-25','kasir','2025-11-30 16:32:50','3.000','0','0','0','700000','0','0','700000','700000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01472','HELMI','1','PER','WEDDING RING','','','5.000','','925.00','1','60000','0','700000','0','700000','zirkon 1butir size 12','grf Mahizar','krum putih doff semprot','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251130-0032','2025-11-30','2025-11-30 16:36:46','PESANAN : DP-01472','.','TBC','700000','700000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251130-0033','D','2025-11-30','16:36:46','TBC','PESANAN','DP-01472','18347119114','700000','18347819114','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-01472','2025-11-30','2025-11-30','16:36:46','PLG0007983','HELMI','2025-12-25','kasir','2025-11-30 16:36:46','5.000','0','0','0','700000','0','0','700000','700000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251130-0030','kasir','1',' DP-01398BI','TOKO','BIPPSN','PSPRT-YKBG-1-0','CINCIN PERAK ','','2.500','1','100.00','153000','0','0','16750','700000','0','0','0','700000','HELMI','00040029','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKBG-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPRT-YKBG-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251130-0030','2025-11-30','2.500','2025-11-30','16:51:17','PLG0007984','700000','700000','0','700000','0','kasir','2025-11-30 16:51:16','FJ-251130-0030','DP-01398','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0030','2025-11-30','16:51:17','HELMI','700000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-251130-0030' 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-251130-0031','kasir','1',' DP-01426BI','TOKO','BIPPSN','PSPRT-YKBH-13-0','CINCIN PERAK ','','3.130','1','100.00','192000','0','0','16750','700000','0','0','0','700000','HELMI','00040057','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKBH-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.130',berat_jual_asli=berat_jual_asli+'3.130',stock_jual='1',berat_akhir=berat_akhir-'3.130',berat_akhir_asli=berat_akhir_asli-'3.130',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPRT-YKBH-13-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-251130-0031','2025-11-30','3.130','2025-11-30','17:08:49','PLG0007985','700000','700000','0','700000','0','kasir','2025-11-30 17:08:48','FJ-251130-0031','DP-01426','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0031','2025-11-30','17:08:49','HELMI','700000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-251130-0031' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0030' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0030' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0030';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0031';
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-251130-0032','kasir','1',' DP-01401BI','TOKO','BIPPSN','PSPRT-YKBG-7-0','CINCIN PERAK ','','1.630','1','100.00','100000','0','0','16750','700000','0','0','0','700000','HELMI','00040035','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKBG-7-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='2025-11-30' AND kode_barang='PSPRT-YKBG-7-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-251130-0032','2025-11-30','1.630','2025-11-30','17:27:39','PLG0007986','700000','700000','0','700000','0','kasir','2025-11-30 17:27:39','FJ-251130-0032','DP-01401','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0032','2025-11-30','17:27:39','HELMI','700000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-251130-0032' 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-251130-0033','kasir',' 1',' DP-01402BI','TOKO','BIPPSN','PSPRT-YKBE-77-0','CINCIN PERAK ','','1.950','1','100.00','120000','0','0','16750','500000','0','0','0','500000','HELMI','00039909','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKBE-77-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPRT-YKBE-77-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-251130-0033','2025-11-30','1.950','2025-11-30','17:27:39','PLG0007987','500000','500000','0','500000','0','kasir','2025-11-30 17:27:39','FJ-251130-0032','DP-01402','500000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0033','2025-11-30','17:27:39','HELMI','500000','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-251130-0033' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0033' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0033' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0033';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-30 ','17:38: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-251130-0034','kasir','1',' DP-01331MM','TOKO','MMPSN','PSPRT-YKAD-11-0','CINCIN PERAK ','','5.370','1','100.00','329000','0','0','16750','700000','0','0','0','700000','NAD','00039588','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKAD-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.370',berat_jual_asli=berat_jual_asli+'5.370',stock_jual='1',berat_akhir=berat_akhir-'5.370',berat_akhir_asli=berat_akhir_asli-'5.370',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPRT-YKAD-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-251130-0034','2025-11-30','5.370','2025-11-30','17:40:54','PLG0007988','700000','700000','0','700000','0','kasir','2025-11-30 17:40:54','FJ-251130-0034','DP-01331','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0034','2025-11-30','17:40:54','NAD','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251130-0033','2025-11-30','2025-11-30 17:40:54','PENJUALAN : FJ-251130-0034','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251130-0034','D','2025-11-30','17:40:54','TBC','PENJUALAN','FJ-251130-0034','18347819114','700000','18348519114','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='700000' WHERE no_faktur_jual='FJ-251130-0034' 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-251130-0035','kasir',' 1',' DP-01333MM','TOKO','MMPSN','PSPLT-YKAD-38-0','CINCIN PALADIUM ','','4.260','1','5.00','529000','0','0','16750','1915000','0','0','0','1915000','NAD','00039615','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YKAD-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.260',berat_jual_asli=berat_jual_asli+'4.260',stock_jual='1',berat_akhir=berat_akhir-'4.260',berat_akhir_asli=berat_akhir_asli-'4.260',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPLT-YKAD-38-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-251130-0035','2025-11-30','4.260','2025-11-30','17:40:54','PLG0007989','1915000','1915000','0','1915000','0','kasir','2025-11-30 17:40:54','FJ-251130-0034','DP-01333','1400000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0035','2025-11-30','17:40:54','NAD','1915000','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-251130-0034','2025-11-30','2025-11-30 17:40:54','PENJUALAN : FJ-251130-0035','.','TBC','515000','515000','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-251130-0035','D','2025-11-30','17:40:54','TBC','PENJUALAN','FJ-251130-0035','18348519114','515000','18349034114','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='1215000' WHERE no_faktur_jual='FJ-251130-0035' 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-251130-0036','kasir',' 1',' DP-01332MM','TOKO','MMPSN','PSGT-YKAD-37-0','CINCIN EMAS ','','3.010','1','83.00','5747000','0','0','16750','6649200','0','0','0','6649200','NAD','00039614','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YKAD-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSGT-YKAD-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-251130-0036','2025-11-30','3.010','2025-11-30','17:40:54','PLG0007990','6649200','6649200','0','6649200','0','kasir','2025-11-30 17:40:54','FJ-251130-0034','DP-01332','5224000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0036','2025-11-30','17:40:54','NAD','6649200','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1215000' WHERE no_faktur_jual='FJ-251130-0036' 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-251130-0037','kasir','1',' DP-01340BI','TOKO','BIPPSN','PSPLT-YKBX-30-0','CINCIN PALADIUM ','','3.910','1','6.00','569000','0','0','16750','1677500','0','0','0','1677500','HELMI','00039737','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YKBX-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.910',berat_jual_asli=berat_jual_asli+'3.910',stock_jual='1',berat_akhir=berat_akhir-'3.910',berat_akhir_asli=berat_akhir_asli-'3.910',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPLT-YKBX-30-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-251130-0037','2025-11-30','3.910','2025-11-30','17:42:26','PLG0007991','1677500','1677500','0','1677500','0','kasir','2025-11-30 17:42:25','FJ-251130-0037','DP-01340','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('2025-11-30','FJ-251130-0037','2025-11-30','17:42:26','HELMI','1677500','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-251130-0035','2025-11-30','2025-11-30 17:42:25','PENJUALAN : FJ-251130-0037','.','TBC','1677500','1677500','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-251130-0036','D','2025-11-30','17:42:26','TBC','PENJUALAN','FJ-251130-0037','18349034114','1677500','18350711614','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='1677500' WHERE no_faktur_jual='FJ-251130-0037' 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-251130-0038','kasir',' 1',' DP-01339BI','TOKO','BIPPSN','PSPLT-YKBX-34-0','CINCIN PALADIUM ','','2.780','1','6.00','404000','0','0','16750','1775000','0','0','0','1775000','HELMI','00039741','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YKBX-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.780',berat_jual_asli=berat_jual_asli+'2.780',stock_jual='1',berat_akhir=berat_akhir-'2.780',berat_akhir_asli=berat_akhir_asli-'2.780',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPLT-YKBX-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-251130-0038','2025-11-30','2.780','2025-11-30','17:42:26','PLG0007992','1775000','1775000','0','1775000','0','kasir','2025-11-30 17:42:25','FJ-251130-0037','DP-01339','852500');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0038','2025-11-30','17:42:26','HELMI','1775000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1677500' WHERE no_faktur_jual='FJ-251130-0038' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0034' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0034' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0034';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0035' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0035' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0035';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0036' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0036' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0036';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0037' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0037' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0037';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0038' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0038' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0038';
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-251130-0039','kasir','1',' 700K-13-00','TOKO','MMPER','PMM-YFBX-139-0','CINCIN SILVER 925 ','','2.430','1','100.00','57000','0','0','16750','650000','0','0','0','650000','NAD','00036580','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-139-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.430',berat_jual_asli=berat_jual_asli+'2.430',stock_jual='1',berat_akhir=berat_akhir-'2.430',berat_akhir_asli=berat_akhir_asli-'2.430',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PMM-YFBX-139-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-251130-0039','2025-11-30','2.430','2025-11-30','17:57:05','PLG0007993','650000','650000','0','650000','0','kasir','2025-11-30 17:57:05','FJ-251130-0039','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0039','2025-11-30','17:57:05','NAD','650000','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-251130-0036','2025-11-30','2025-11-30 17:57:05','PENJUALAN : FJ-251130-0039','.','TBC','650000','650000','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-251130-0037','D','2025-11-30','17:57:05','TBC','PENJUALAN','FJ-251130-0039','18350711614','650000','18351361614','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='650000' WHERE no_faktur_jual='FJ-251130-0039' 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-251130-0040','kasir','1',' 500K-17-00','TOKO','MMPER','PMM-YFBX-15-0','CINCIN SILVER 925 ','','3.270','1','100.00','76000','0','0','16750','450000','0','0','0','450000','NIS','00036456','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.270',berat_jual_asli=berat_jual_asli+'3.270',stock_jual='1',berat_akhir=berat_akhir-'3.270',berat_akhir_asli=berat_akhir_asli-'3.270',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PMM-YFBX-15-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-251130-0040','2025-11-30','3.270','2025-11-30','17:57:49','PLG0007994','450000','450000','0','450000','0','kasir','2025-11-30 17:57:49','FJ-251130-0040','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0040','2025-11-30','17:57:49','NIS','450000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251130-0037','2025-11-30','2025-11-30 17:57:49','PENJUALAN : FJ-251130-0040','.','TBC','450000','450000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251130-0038','D','2025-11-30','17:57:49','TBC','PENJUALAN','FJ-251130-0040','18351361614','450000','18351811614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='450000' WHERE no_faktur_jual='FJ-251130-0040' 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-251130-0041','kasir','1',' DP-01428BI','TOKO','BIPPSN','PSPRT-YKBH-18-0','CINCIN PERAK ','','1.210','1','100.00','75000','0','0','16750','750000','0','0','0','750000','HELMI','00040062','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKBH-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.210',berat_jual_asli=berat_jual_asli+'1.210',stock_jual='1',berat_akhir=berat_akhir-'1.210',berat_akhir_asli=berat_akhir_asli-'1.210',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPRT-YKBH-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251130-0041','2025-11-30','1.210','2025-11-30','18:06:27','PLG0007995','750000','750000','0','750000','0','kasir','2025-11-30 18:06:26','FJ-251130-0041','DP-01428','750000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0041','2025-11-30','18:06:27','HELMI','750000','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-251130-0041' 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-251130-0042','kasir',' 1',' DP-01429BI','TOKO','BIPPSN','PSPRT-YKBF-23-0','CINCIN PERAK ','','4.190','1','100.00','257000','0','0','16750','500000','0','0','0','500000','HELMI','00040018','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKBF-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.190',berat_jual_asli=berat_jual_asli+'4.190',stock_jual='1',berat_akhir=berat_akhir-'4.190',berat_akhir_asli=berat_akhir_asli-'4.190',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPRT-YKBF-23-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-251130-0042','2025-11-30','4.190','2025-11-30','18:06:27','PLG0007996','500000','500000','0','500000','0','kasir','2025-11-30 18:06:26','FJ-251130-0041','DP-01429','500000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0042','2025-11-30','18:06:27','HELMI','500000','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-251130-0042' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0039' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0039' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0039';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0040' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0040' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0040';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0042';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01527','NAD','1','2PCS CINCIN SLV','CEWE RESIZE KE 14 GRF FAIZ DAN COWO RESIZEKE 20 GRF LUTFI','5.700','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-01527','2025-11-30','2025-11-30','18:06:56','PLG0007997','kasir','2025-12-01','kasir','2025-11-30 18:06:56','5.700','0','0','0','0','0','0','0','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251130-0043','kasir','1',' DP-01414BI','TOKO','BIPPSN','PSPRT-YKBG-10-0','CINCIN PERAK ','','3.110','1','100.00','191000','0','0','16750','700000','0','0','0','700000','HELMI','00040038','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKBG-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.110',berat_jual_asli=berat_jual_asli+'3.110',stock_jual='1',berat_akhir=berat_akhir-'3.110',berat_akhir_asli=berat_akhir_asli-'3.110',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPRT-YKBG-10-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-251130-0043','2025-11-30','3.110','2025-11-30','18:12:09','PLG0007998','700000','700000','0','700000','0','kasir','2025-11-30 18:12:09','FJ-251130-0043','DP-01414','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0043','2025-11-30','18:12:09','HELMI','700000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-251130-0043' 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-251130-0044','kasir',' 1',' DP-01413BI','TOKO','BIPPSN','PSPRT-YKBG-8-0','CINCIN PERAK ','','1.450','1','100.00','89000','0','0','16750','850000','0','0','0','850000','HELMI','00040036','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKBG-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPRT-YKBG-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251130-0044','2025-11-30','1.450','2025-11-30','18:12:09','PLG0007999','850000','850000','0','850000','0','kasir','2025-11-30 18:12:09','FJ-251130-0043','DP-01413','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('2025-11-30','FJ-251130-0044','2025-11-30','18:12:09','HELMI','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-251130-0044' 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-251130-0045','kasir','1',' 700K-12-00','TOKO','BIPPER','PBSD-YGBI-63-0','CINCIN SILVER 925 ','','1.760','1','100.00','37000','0','0','16750','650000','0','0','0','650000','NITA','00037699','PBSD','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGBI-63-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.760',berat_jual_asli=berat_jual_asli+'1.760',stock_jual='1',berat_akhir=berat_akhir-'1.760',berat_akhir_asli=berat_akhir_asli-'1.760',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PBSD-YGBI-63-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-251130-0045','2025-11-30','1.760','2025-11-30','18:18:13','PLG0008000','650000','650000','0','650000','0','kasir','2025-11-30 18:18:13','FJ-251130-0045','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0045','2025-11-30','18:18:13','NITA','650000','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-251130-0038','2025-11-30','2025-11-30 18:18:13','PENJUALAN : FJ-251130-0045','.','TBC','650000','650000','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-251130-0039','D','2025-11-30','18:18:13','TBC','PENJUALAN','FJ-251130-0045','18351811614','650000','18352461614','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='650000' WHERE no_faktur_jual='FJ-251130-0045' 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-251130-0046','kasir',' 1',' 700K-19-18','TOKO','BIPPER','PBDG-YKBD-12-0','CINCIN SILVER 925 ','','2.610','1','100.00','161000','0','0','16750','650000','0','0','0','650000','NITA','00039784','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBD-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.610',berat_jual_asli=berat_jual_asli+'2.610',stock_jual='1',berat_akhir=berat_akhir-'2.610',berat_akhir_asli=berat_akhir_asli-'2.610',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PBDG-YKBD-12-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-251130-0046','2025-11-30','2.610','2025-11-30','18:18:13','PLG0008001','650000','650000','0','650000','0','kasir','2025-11-30 18:18:13','FJ-251130-0045','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0046','2025-11-30','18:18:13','NITA','650000','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-251130-0039','2025-11-30','2025-11-30 18:18:13','PENJUALAN : FJ-251130-0046','.','TBC','650000','650000','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-251130-0040','D','2025-11-30','18:18:13','TBC','PENJUALAN','FJ-251130-0046','18352461614','650000','18353111614','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='1300000' WHERE no_faktur_jual='FJ-251130-0046' 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-251130-0047','kasir','1',' DP-01385BI','TOKO','BIPPSN','PSPRT-YKBG-9-0','CINCIN PERAK ','','2.200','1','100.00','135000','0','0','16750','850000','0','0','0','850000','SUL','00040037','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKBG-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.200',berat_jual_asli=berat_jual_asli+'2.200',stock_jual='1',berat_akhir=berat_akhir-'2.200',berat_akhir_asli=berat_akhir_asli-'2.200',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='PSPRT-YKBG-9-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-251130-0047','2025-11-30','2.200','2025-11-30','18:20:55','PLG0008002','850000','850000','0','850000','0','kasir','2025-11-30 18:20:55','FJ-251130-0047','DP-01385','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('2025-11-30','FJ-251130-0047','2025-11-30','18:20:55','SUL','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-251130-0047' 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-251130-0048','kasir',' 1',' DP-01384BI','TOKO','BIPPSN','PSPRT-YKBE-78-0','CINCIN PERAK ','','2.100','1','100.00','129000','0','0','16750','500000','0','0','0','500000','SUL','00039910','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKBE-78-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='2025-11-30' AND kode_barang='PSPRT-YKBE-78-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-251130-0048','2025-11-30','2.100','2025-11-30','18:20:55','PLG0008003','500000','500000','0','500000','0','kasir','2025-11-30 18:20:55','FJ-251130-0047','DP-01384','500000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0048','2025-11-30','18:20:55','SUL','500000','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-251130-0048' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01528','NITA','1','WDDING RING 2 CC SILVER','CC WANITA RESIZE KE 9 CC PRIA SIZE TETAP KRUM SPT ASAL FONT BEKSHIRE SWASH','5.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01528','2025-11-30','2025-11-30','18:35:06','PLG0008004','kasir','2025-12-10','kasir','2025-11-30 18:35:06','5.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-30 ','18:37:02');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01529','NIS','1','1PCS CINCIN SLV','KRUM ULANG GRF JGN HILANG','3.280','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-01529','2025-11-30','2025-11-30','18:59:23','PLG0008005','kasir','2025-12-01','kasir','2025-11-30 18:59:23','3.280','0','0','0','0','0','0','0','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0043' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0043' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0043';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0044' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0044' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0044';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0045' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0045' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0045';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0046' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0046' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0046';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0047' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0047' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0047';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0048' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251130-0048' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251130-0048';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-01','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-31';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-30';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-30';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-11-30' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-30';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-30';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-30';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-30';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-12-01' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-30' 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-251201-0001','D','2025-12-01','20:09:16','TBC','SALDO AWAL','SALDO AWAL','0','18353111614','18353111614');
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-251201-0001','D','2025-12-01','20:09:16','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-251201-0001','D','2025-12-01','20:09:16','BCD','SALDO AWAL','SALDO AWAL','0','1342321000','1342321000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251201-0001','D','2025-12-01','20:09:16','KET','SALDO AWAL','SALDO AWAL','0','135063000','135063000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251201-0001','D','2025-12-01','20:09:16','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-251201-0001','D','2025-12-01','20:09:16','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251201-0001','D','2025-12-01','20:09:16','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-251201-0001','D','2025-12-01','20:09:16','BCK','SALDO AWAL','SALDO AWAL','0','1927708000','1927708000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251201-0001','D','2025-12-01','20:09:16','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-251201-0001','D','2025-12-01','20:09:16','SHO','SALDO AWAL','SALDO AWAL','0','141465650','141465650');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251201-0001','D','2025-12-01','20:09:16','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
UPDATE tp_system SET tgl_system='2025-12-01';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-30 ','20:19: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-251130-0049','kasir','1',' DP-01315BI','TOKO','BIPPSN','PSPLT-YKBF-25-0','CINCIN PALADIUM ','','2.050','1','6.00','300000','0','0','16750','1412500','0','0','0','1412500','HELMI','00040020','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YKBF-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2025-12-01' AND kode_barang='PSPLT-YKBF-25-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-251130-0049','2025-12-01','2.050','2025-11-30','20:20:39','PLG0008006','1412500','1412500','0','1412500','0','kasir','2025-11-30 20:20:38','FJ-251130-0049','DP-01315','762500');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-01','FJ-251130-0049','2025-11-30','20:20:39','HELMI','1412500','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-251201-0001','2025-12-01','2025-11-30 20:20:38','PENJUALAN : FJ-251130-0049','.','TBC','650000','650000','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-251201-0002','D','2025-12-01','20:20:39','TBC','PENJUALAN','FJ-251130-0049','18353111614','650000','18353761614','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='650000' WHERE no_faktur_jual='FJ-251130-0049' 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-251130-0050','kasir',' 1',' DP-01316BI','TOKO','BIPPSN','PSPLT-YKAI-6-0','CINCIN PALADIUM ','','2.640','1','5.00','320000','0','0','16750','1360000','0','0','0','1360000','HELMI','00039666','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YKAI-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.640',berat_jual_asli=berat_jual_asli+'2.640',stock_jual='1',berat_akhir=berat_akhir-'2.640',berat_akhir_asli=berat_akhir_asli-'2.640',stock_akhir='0' WHERE tanggal='2025-12-01' AND kode_barang='PSPLT-YKAI-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-251130-0050','2025-12-01','2.640','2025-11-30','20:20:39','PLG0008007','1360000','1360000','0','1360000','0','kasir','2025-11-30 20:20:38','FJ-251130-0049','DP-01316','662500');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-01','FJ-251130-0050','2025-11-30','20:20:39','HELMI','1360000','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-251201-0002','2025-12-01','2025-11-30 20:20:38','PENJUALAN : FJ-251130-0050','.','TBC','697500','697500','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-251201-0003','D','2025-12-01','20:20:39','TBC','PENJUALAN','FJ-251130-0050','18353761614','697500','18354459114','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='1347500' WHERE no_faktur_jual='FJ-251130-0050' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01530','NIS','1','1PCS CINCIN EMAS','GRF KONFIRMASI','2.100','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-01530','2025-11-30','2025-11-30','20:45:53','PLG0008008','kasir','2025-12-01','kasir','2025-11-30 20:45:53','2.100','0','0','0','0','0','0','0','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251130-0051','kasir','1',' 900K-15 ','TOKO','MMCM','CMMM-YGAG-22-0','CINCIN MAS MM ','','2.100','1','83.00','3992000','0','0','16750','5310000','0','0','0','5310000','NIS','00037285','CMMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CMMM-YGAG-22-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='2025-11-30' AND kode_barang='CMMM-YGAG-22-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMCM' 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-251130-0051','2025-11-30','2.100','2025-11-30','20:47:20','PLG0008009','5310000','5310000','0','5310000','0','kasir','2025-11-30 20:47:19','FJ-251130-0051','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','FJ-251130-0051','2025-11-30','20:47:20','NIS','5310000','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-251130-0040','2025-11-30','2025-11-30 20:47:19','PENJUALAN : FJ-251130-0051','.','TBC','5310000','5310000','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-251130-0001','D','2025-11-30','20:47:20','TBC','PENJUALAN','FJ-251130-0051','0','5310000','5310000','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='5310000' WHERE no_faktur_jual='FJ-251130-0051' LIMIT 1;