INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-21 ','10:19:19');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-21 ','10:58:34');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-21 ','10:59:06');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251220-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251220-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251220-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251220-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251220-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251220-0019';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-21','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-20';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-20';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-20';
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-12-20' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-20';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-20';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-20';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-20';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-21' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-20' 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-251221-0001','D','2025-12-21','10:59:37','TBC','SALDO AWAL','SALDO AWAL','0','18764795614','18764795614');
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-251221-0001','D','2025-12-21','10:59:37','BCK','SALDO AWAL','SALDO AWAL','0','1940208000','1940208000');
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-251221-0001','D','2025-12-21','10:59:37','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-251221-0001','D','2025-12-21','10:59:37','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-251221-0001','D','2025-12-21','10:59:37','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-251221-0001','D','2025-12-21','10:59:37','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-251221-0001','D','2025-12-21','10:59:37','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-251221-0001','D','2025-12-21','10:59:37','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-251221-0001','D','2025-12-21','10:59:37','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-251221-0001','D','2025-12-21','10:59:37','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-251221-0001','D','2025-12-21','10:59:37','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
UPDATE tp_system SET tgl_system='2025-12-21';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-21 ','10:59:48');
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-251221-0001','kasir','1',' DP-01441BI','TOKO','BIPPSN','PSPLT-YLAE-7-0','CINCIN PALADIUM ','','2.440','1','6.00','371000','0','0','16800','1432000','0','0','0','1432000','SUL','00040567','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YLAE-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.440',berat_jual_asli=berat_jual_asli+'2.440',stock_jual='1',berat_akhir=berat_akhir-'2.440',berat_akhir_asli=berat_akhir_asli-'2.440',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PSPLT-YLAE-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-251221-0001','2025-12-21','2.440','2025-12-21','11:00:47','PLG0008392','1432000','1432000','0','1432000','0','kasir','2025-12-21 11:00:46','FJ-251221-0001','DP-01441','800000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-21','FJ-251221-0001','2025-12-21','11:00:47','SUL','1432000','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-251221-0001','2025-12-21','2025-12-21 11:00:46','PENJUALAN : FJ-251221-0001','.','TBC','632000','632000','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-251221-0002','D','2025-12-21','11:00:47','TBC','PENJUALAN','FJ-251221-0001','18764795614','632000','18765427614','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='632000' WHERE no_faktur_jual='FJ-251221-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-251221-0002','kasir',' 1',' DP-01442BI','TOKO','BIPPSN','PSPLT-YLAG-4-0','CINCIN PALADIUM ','','2.260','1','6.00','345000','0','0','16800','1378000','0','0','0','1378000','SUL','00040613','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YLAG-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.260',berat_jual_asli=berat_jual_asli+'2.260',stock_jual='1',berat_akhir=berat_akhir-'2.260',berat_akhir_asli=berat_akhir_asli-'2.260',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PSPLT-YLAG-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251221-0002','2025-12-21','2.260','2025-12-21','11:00:47','PLG0008393','1378000','1378000','0','1378000','0','kasir','2025-12-21 11:00:46','FJ-251221-0001','DP-01442','800000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-21','FJ-251221-0002','2025-12-21','11:00:47','SUL','1378000','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-251221-0002','2025-12-21','2025-12-21 11:00:46','PENJUALAN : FJ-251221-0002','.','TBC','578000','578000','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-251221-0003','D','2025-12-21','11:00:47','TBC','PENJUALAN','FJ-251221-0002','18765427614','578000','18766005614','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='1210000' WHERE no_faktur_jual='FJ-251221-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-21 ','11:01:40');
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-251221-0003','kasir','1',' DP-01435BI','TOKO','BIPPSN','PSGT-YLAH-2-0','CINCIN EMAS ','','1.770','1','83.00','3456000','0','0','16800','4677000','0','0','0','4677000','NITA','00040616','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YLAH-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.770',berat_jual_asli=berat_jual_asli+'1.770',stock_jual='1',berat_akhir=berat_akhir-'1.770',berat_akhir_asli=berat_akhir_asli-'1.770',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PSGT-YLAH-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251221-0003','2025-12-21','1.770','2025-12-21','11:30:59','PLG0008394','4677000','4677000','0','4677000','0','kasir','2025-12-21 11:30:59','FJ-251221-0003','DP-01435','4128000');
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-21','FJ-251221-0003','2025-12-21','11:30:59','NITA','4677000','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-251221-0003','2025-12-21','2025-12-21 11:30:59','PENJUALAN : FJ-251221-0003','.','TBC','549000','549000','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-251221-0004','D','2025-12-21','11:30:59','TBC','PENJUALAN','FJ-251221-0003','18766005614','549000','18766554614','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='549000' WHERE no_faktur_jual='FJ-251221-0003' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251221-0004','kasir',' 1',' DP-01436BI','TOKO','BIPPSN','PSGT-YLAH-3-0','CINCIN EMAS ','','2.330','1','83.00','4550000','0','0','16800','5803000','0','0','0','5803000','NITA','00040617','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YLAH-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.330',berat_jual_asli=berat_jual_asli+'2.330',stock_jual='1',berat_akhir=berat_akhir-'2.330',berat_akhir_asli=berat_akhir_asli-'2.330',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PSGT-YLAH-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-251221-0004','2025-12-21','2.330','2025-12-21','11:30:59','PLG0008395','5803000','5803000','0','5803000','0','kasir','2025-12-21 11:30:59','FJ-251221-0003','DP-01436','4928000');
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-21','FJ-251221-0004','2025-12-21','11:30:59','NITA','5803000','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-251221-0004','2025-12-21','2025-12-21 11:30:59','PENJUALAN : FJ-251221-0004','.','TBC','875000','875000','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-251221-0005','D','2025-12-21','11:30:59','TBC','PENJUALAN','FJ-251221-0004','18766554614','875000','18767429614','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='1424000' WHERE no_faktur_jual='FJ-251221-0004' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-21 ','11:35:34');
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-251221-0005','kasir','1',' CBRT-00347','TOKO','TFCBR','CBRT-YKBD-31-0','CINCIN CBRT-00347 ','','2.120','1','75.00','7397000','3051000','182','16800','8700000','0','0','0','8700000','ONLNANA','00039803','CBRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRT-YKBD-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.120',berat_jual_asli=berat_jual_asli+'2.120',stock_jual='1',berat_akhir=berat_akhir-'2.120',berat_akhir_asli=berat_akhir_asli-'2.120',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='CBRT-YKBD-31-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCBR' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251221-0005','2025-12-21','2.120','2025-12-21','11:37:08','PLG0008396','8700000','8700000','0','8700000','0','kasir','2025-12-21 11:37:08','FJ-251221-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-21','FJ-251221-0005','2025-12-21','11:37:08','ONLNANA','8700000','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-251221-0005','2025-12-21','2025-12-21 11:37:08','PENJUALAN : FJ-251221-0005','.','TBC','8700000','8700000','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-251221-0006','D','2025-12-21','11:37:08','TBC','PENJUALAN BERLIAN','FJ-251221-0005','18767429614','8700000','18776129614','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='8700000' WHERE no_faktur_jual='FJ-251221-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0005';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251221-0006','kasir','1',' 800K-115-2','TOKO','BIPPER','PBDG-YLAA-20-0','CINCIN SILVER 925 ','','2.420','1','100.00','149000','0','0','16800','599000','0','0','0','599000','HELMI','00040555','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YLAA-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.420',berat_jual_asli=berat_jual_asli+'2.420',stock_jual='1',berat_akhir=berat_akhir-'2.420',berat_akhir_asli=berat_akhir_asli-'2.420',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PBDG-YLAA-20-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-251221-0006','2025-12-21','2.420','2025-12-21','12:12:28','PLG0008397','599000','599000','0','599000','0','kasir','2025-12-21 12:12:28','FJ-251221-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-12-21','FJ-251221-0006','2025-12-21','12:12:28','HELMI','599000','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-251221-0006','2025-12-21','2025-12-21 12:12:28','PENJUALAN : FJ-251221-0006','.','TBC','599000','599000','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-251221-0007','D','2025-12-21','12:12:28','TBC','PENJUALAN','FJ-251221-0006','18776129614','599000','18776728614','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='599000' WHERE no_faktur_jual='FJ-251221-0006' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251221-0007','kasir',' 1',' 700K-21-20','TOKO','BIPPER','PBDG-YLXD-106-0','CINCIN SILVER 925 ','','3.720','1','100.00','228000','0','0','16800','700000','0','0','0','700000','HELMI','00040286','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YLXD-106-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.720',berat_jual_asli=berat_jual_asli+'3.720',stock_jual='1',berat_akhir=berat_akhir-'3.720',berat_akhir_asli=berat_akhir_asli-'3.720',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PBDG-YLXD-106-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-251221-0007','2025-12-21','3.720','2025-12-21','12:12:28','PLG0008398','700000','700000','0','700000','0','kasir','2025-12-21 12:12:28','FJ-251221-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-12-21','FJ-251221-0007','2025-12-21','12:12:28','HELMI','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-251221-0007','2025-12-21','2025-12-21 12:12:28','PENJUALAN : FJ-251221-0007','.','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-251221-0008','D','2025-12-21','12:12:28','TBC','PENJUALAN','FJ-251221-0007','18776728614','700000','18777428614','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='1299000' WHERE no_faktur_jual='FJ-251221-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0007';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01602','NITA','1','1 CINCIN SILVER','RESIZE KE SIZE 32 KRUM PTIH DOFF AMPLAS UKIRNAMA TETAP ADA','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-01602','2025-12-21','2025-12-21','12:26:23','PLG0008399','kasir','2026-01-06','kasir','2025-12-21 12:26:23','5.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-21 ','13:53:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-21 ','13:53:26');
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-251221-0008','kasir','1',' 700K-18-00','TOKO','MMPER','PBSD-YGBD-19-0','CINCIN SILVER 925 ','','2.130','1','100.00','44000','0','0','16800','700000','0','0','0','700000','NIS','00037481','PBSD','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGBD-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PBSD-YGBD-19-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-251221-0008','2025-12-21','2.130','2025-12-21','14:00:50','PLG0008400','700000','700000','0','700000','0','kasir','2025-12-21 14:00:49','FJ-251221-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-12-21','FJ-251221-0008','2025-12-21','14:00:50','NIS','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-251221-0008','2025-12-21','2025-12-21 14:00:49','PENJUALAN : FJ-251221-0008','.','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-251221-0009','D','2025-12-21','14:00:50','TBC','PENJUALAN','FJ-251221-0008','18777428614','700000','18778128614','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-251221-0008' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251221-0009','kasir','1',' 700K-17-00','TOKO','MMPER','PBSD-YGBH-17-0','CINCIN SILVER 925 ','','2.070','1','100.00','43000','0','0','16800','700000','0','0','0','700000','NAD','00037599','PBSD','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGBH-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PBSD-YGBH-17-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-251221-0009','2025-12-21','2.070','2025-12-21','14:01:33','PLG0008401','700000','700000','0','700000','0','kasir','2025-12-21 14:01:33','FJ-251221-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-12-21','FJ-251221-0009','2025-12-21','14:01:33','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-251221-0009','2025-12-21','2025-12-21 14:01:33','PENJUALAN : FJ-251221-0009','.','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-251221-0010','D','2025-12-21','14:01:33','TBC','PENJUALAN','FJ-251221-0009','18778128614','700000','18778828614','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-251221-0009' 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-01603','NAD','1','1PC CCN SLV','KRUM ULANG GRF JOJO','2.070','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-01603','2025-12-21','2025-12-21','14:04:33','PLG0008402','kasir','2025-12-22','kasir','2025-12-21 14:04:33','2.070','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-01604','SULIS','1','SEPASANG SILVER','CWE SZ 10 PUTIH GLOSY CWO PUTIH DOFF AMPLASS FONT BERKSHIRE SWASH','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-01604','2025-12-21','2025-12-21','14:19:27','PLG0008403','kasir','2025-12-31','kasir','2025-12-21 14:19:27','4.000','0','0','0','0','0','0','0','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01519','SULIS','1','PER','WED RING','','','4.000','','925.00','1','60000','0','700000','0','700000','1 zircon putih doff semprot','sz 17 grf SYIFA','font comic sans','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251221-0010','2025-12-21','2025-12-21 14:34:14','PESANAN : DP-01519','.','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-251221-0011','D','2025-12-21','14:34:14','TBC','PESANAN','DP-01519','18778828614','700000','18779528614','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-01519','2025-12-21','2025-12-21','14:34:14','PLG0008404','SULIS','2026-01-16','kasir','2025-12-21 14:34:14','4.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-251221-0010','kasir','1',' 950K-14-19','TOKO','BIPPER','PBDG-YLXB-16-0','CINCIN SILVER 925 ','','2.030','1','100.00','125000','0','0','16800','950000','0','0','0','950000','SUL','00040088','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YLXB-16-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-12-21' AND kode_barang='PBDG-YLXB-16-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-251221-0010','2025-12-21','2.030','2025-12-21','14:35:12','PLG0008405','950000','950000','0','950000','0','kasir','2025-12-21 14:35:12','FJ-251221-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-21','FJ-251221-0010','2025-12-21','14:35:12','SUL','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-251221-0011','2025-12-21','2025-12-21 14:35:12','PENJUALAN : FJ-251221-0010','.','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-251221-0012','D','2025-12-21','14:35:12','TBC','PENJUALAN','FJ-251221-0010','18779528614','950000','18780478614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='950000' WHERE no_faktur_jual='FJ-251221-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-01605','SULIS','1','1 SILVER','SZ 11 FONT COMIC SANS CROM PUTIH GLOSY GRF PUTRRA','2.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01605','2025-12-21','2025-12-21','14:36:49','PLG0008406','kasir','2025-12-31','kasir','2025-12-21 14:36:49','2.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-21 ','14:37: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-251221-0011','kasir','1',' DP-01446BI','TOKO','BIPPSN','PSPRT-YLXA-3-0','CINCIN PERAK ','','4.730','1','100.00','290000','0','0','16800','700000','0','0','0','700000','NITA','00040071','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YLXA-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.730',berat_jual_asli=berat_jual_asli+'4.730',stock_jual='1',berat_akhir=berat_akhir-'4.730',berat_akhir_asli=berat_akhir_asli-'4.730',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PSPRT-YLXA-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-251221-0011','2025-12-21','4.730','2025-12-21','14:59:09','PLG0008407','700000','700000','0','700000','0','kasir','2025-12-21 14:59:08','FJ-251221-0011','DP-01446','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-12-21','FJ-251221-0011','2025-12-21','14:59:09','NITA','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-251221-0012','2025-12-21','2025-12-21 14:59:08','PENJUALAN : FJ-251221-0011','.','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-251221-0013','D','2025-12-21','14:59:09','TBC','PENJUALAN','FJ-251221-0011','18780478614','700000','18781178614','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-251221-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-251221-0012','kasir',' 1',' DP-01445BI','TOKO','BIPPSN','PSPLT-YLAE-6-0','CINCIN PALADIUM ','','2.310','1','6.00','351000','0','0','16800','1823000','0','0','0','1823000','NITA','00040566','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YLAE-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.310',berat_jual_asli=berat_jual_asli+'2.310',stock_jual='1',berat_akhir=berat_akhir-'2.310',berat_akhir_asli=berat_akhir_asli-'2.310',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PSPLT-YLAE-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-251221-0012','2025-12-21','2.310','2025-12-21','14:59:09','PLG0008408','1823000','1823000','0','1823000','0','kasir','2025-12-21 14:59:08','FJ-251221-0011','DP-01445','1015000');
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-21','FJ-251221-0012','2025-12-21','14:59:09','NITA','1823000','0');
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-251221-0012' 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-01520','HELMI','1','PER','WEDDING RING','','','3.000','','925.00','1','60000','0','950000','0','950000','size 12 grf Akbar ?? Hilfi','model spt contoh','krum putih glosy','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251221-0013','2025-12-21','2025-12-21 15:28:34','PESANAN : DP-01520','.','TBC','950000','950000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251221-0014','D','2025-12-21','15:28:34','TBC','PESANAN','DP-01520','18781178614','950000','18782128614','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-01520','2025-12-21','2025-12-21','15:28:34','PLG0008409','HELMI','2026-01-21','kasir','2025-12-21 15:28:34','3.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01521','HELMI','1','PER','WEDDING RING','','','5.000','','925.00','1','60000','0','700000','0','700000','size 19 grf Hilfi & Akbar','model seperti contoh','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-251221-0014','2025-12-21','2025-12-21 15:31:59','PESANAN : DP-01521','.','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-251221-0015','D','2025-12-21','15:31:59','TBC','PESANAN','DP-01521','18782128614','700000','18782828614','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-01521','2025-12-21','2025-12-21','15:31:59','PLG0008410','HELMI','2026-01-21','kasir','2025-12-21 15:31:59','5.000','0','0','0','700000','0','0','700000','700000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-21 ','15:41:25');
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-01522','HELMI','1','PLD','WEDDING RING','','','2.000','','10.00','1','2300000','300000','0','750000','1350000','zirkon estimasi 19butir','size 12 grf T.Belmiro.R','model spt contoh krum putih lebar 3mm','190000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251221-0015','2025-12-21','2025-12-21 15:41:52','PESANAN : DP-01522','.','TBC','770000','770000');
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-251221-0016','D','2025-12-21','15:41:52','TBC','PESANAN','DP-01522','18782828614','770000','18783598614','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-01522','2025-12-21','2025-12-21','15:41:52','PLG0008411','HELMI','2026-01-22','kasir','2025-12-21 15:41:52','2.000','0','0','0','770000','0','750000','1540000','1540000','770000');
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-01523','HELMI','1','PLD','WEDDING RING','','','4.000','','10.00','1','2300000','300000','0','700000','1900000','size 19 lebar 4mm','grf Dhea Ardania','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-251221-0016','2025-12-21','2025-12-21 15:45:42','PESANAN : DP-01523','.','TBC','950000','950000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251221-0017','D','2025-12-21','15:45:42','TBC','PESANAN','DP-01523','18783598614','950000','18784548614','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-01523','2025-12-21','2025-12-21','15:45:42','PLG0008412','HELMI','2026-01-22','kasir','2025-12-21 15:45:42','4.000','0','0','0','950000','0','700000','1900000','1900000','950000');
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-251221-0013','kasir','1',' ABRT-00249','TOKO','TFABR','ABRT-WGXE-23-0','ANTING ABRT-00249','','2.640','1','83.00','11311000','4773500','284','16800','14000000','0','0','0','14000000','ONLILUNG','00022763','ABRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='ABRT-WGXE-23-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-21' AND kode_barang='ABRT-WGXE-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFABR' 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-251221-0013','2025-12-21','2.640','2025-12-21','15:46:01','PLG0008413','14000000','14000000','0','14000000','0','kasir','2025-12-21 15:46:00','FJ-251221-0013','','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-12-21','FJ-251221-0013','2025-12-21','15:46:01','ONLILUNG','14000000','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-251221-0017','2025-12-21','2025-12-21 15:46:00','PENJUALAN : FJ-251221-0013','','TBC','14000000','14000000','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-251221-0018','D','2025-12-21','15:46:01','TBC','PENJUALAN BERLIAN','FJ-251221-0013','18784548614','14000000','18798548614','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='14000000' WHERE no_faktur_jual='FJ-251221-0013' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0013';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-21 ','16:18:35');
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-251221-0014','kasir','1',' DP-01469BI','TOKO','BIPPSN','PSPLT-YLAH-22-0','CINCIN PALADIUM ','','2.510','1','6.00','383000','0','0','16800','1553000','0','0','0','1553000','SUL','00040636','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YLAH-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.510',berat_jual_asli=berat_jual_asli+'2.510',stock_jual='1',berat_akhir=berat_akhir-'2.510',berat_akhir_asli=berat_akhir_asli-'2.510',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PSPLT-YLAH-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-251221-0014','2025-12-21','2.510','2025-12-21','16:20:37','PLG0008414','1553000','1553000','0','1553000','0','kasir','2025-12-21 16:20:37','FJ-251221-0014','DP-01469','775000');
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-21','FJ-251221-0014','2025-12-21','16:20:37','SUL','1553000','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-251221-0018','2025-12-21','2025-12-21 16:20:37','PENJUALAN : FJ-251221-0014','.','TBC','778000','778000','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-251221-0019','D','2025-12-21','16:20:37','TBC','PENJUALAN','FJ-251221-0014','18798548614','778000','18799326614','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='778000' WHERE no_faktur_jual='FJ-251221-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-251221-0015','kasir',' 1',' DP-01470BI','TOKO','BIPPSN','PSPLT-YLXH-7-0','CINCIN PALADIUM ','','2.080','1','6.00','308000','0','0','16800','1324000','0','0','0','1324000','SUL','00040374','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YLXH-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PSPLT-YLXH-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-251221-0015','2025-12-21','2.080','2025-12-21','16:20:37','PLG0008415','1324000','1324000','0','1324000','0','kasir','2025-12-21 16:20:37','FJ-251221-0014','DP-01470','800000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-21','FJ-251221-0015','2025-12-21','16:20:37','SUL','1324000','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-251221-0019','2025-12-21','2025-12-21 16:20:37','PENJUALAN : FJ-251221-0015','.','TBC','524000','524000','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-251221-0020','D','2025-12-21','16:20:37','TBC','PENJUALAN','FJ-251221-0015','18799326614','524000','18799850614','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='1302000' WHERE no_faktur_jual='FJ-251221-0015' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0015';
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-251221-0016','kasir','1',' 850K-15-20','TOKO','BIPPER','PBDG-YLXD-146-0','CINCIN SILVER 925 ','','1.440','1','100.00','89000','0','0','16800','850000','0','0','0','850000','SUL','00040326','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YLXD-146-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.440',berat_jual_asli=berat_jual_asli+'1.440',stock_jual='1',berat_akhir=berat_akhir-'1.440',berat_akhir_asli=berat_akhir_asli-'1.440',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PBDG-YLXD-146-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-251221-0016','2025-12-21','1.440','2025-12-21','16:27:29','PLG0008416','850000','850000','0','850000','0','kasir','2025-12-21 16:27:29','FJ-251221-0016','','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-12-21','FJ-251221-0016','2025-12-21','16:27:29','SUL','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251221-0020','2025-12-21','2025-12-21 16:27:29','PENJUALAN : FJ-251221-0016','.','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251221-0021','D','2025-12-21','16:27:29','TBC','PENJUALAN','FJ-251221-0016','18799850614','850000','18800700614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-251221-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-251221-0017','kasir',' 1',' 700K-215-1','TOKO','BIPPER','PBDG-YKXD-20-0','CINCIN SILVER 925 ','','1.730','1','100.00','107000','0','0','16800','700000','0','0','0','700000','SUL','00039467','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKXD-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.730',berat_jual_asli=berat_jual_asli+'1.730',stock_jual='1',berat_akhir=berat_akhir-'1.730',berat_akhir_asli=berat_akhir_asli-'1.730',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PBDG-YKXD-20-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-251221-0017','2025-12-21','1.730','2025-12-21','16:27:29','PLG0008417','700000','700000','0','700000','0','kasir','2025-12-21 16:27:29','FJ-251221-0016','','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-12-21','FJ-251221-0017','2025-12-21','16:27:29','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-251221-0021','2025-12-21','2025-12-21 16:27:29','PENJUALAN : FJ-251221-0017','.','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-251221-0022','D','2025-12-21','16:27:29','TBC','PENJUALAN','FJ-251221-0017','18800700614','700000','18801400614','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-251221-0017' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0017';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-21 ','16:44:58');
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-251221-0018','kasir','1',' TFC-21488 ','TOKO','TFCBR','TFC-YLXE-9-0','TFC-21488 GIA 1403636174 ','','2.120','1','75.00','8476000','4032000','240','16800','11300000','0','0','0','11300000','ILU','00040344','TFC','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFC-YLXE-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.120',berat_jual_asli=berat_jual_asli+'2.120',stock_jual='1',berat_akhir=berat_akhir-'2.120',berat_akhir_asli=berat_akhir_asli-'2.120',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='TFC-YLXE-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCBR' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251221-0018','2025-12-21','2.120','2025-12-21','16:54:34','PLG0008418','11300000','11300000','0','11300000','0','kasir','2025-12-21 16:54:33','FJ-251221-0018','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-21','FJ-251221-0018','2025-12-21','16:54:34','ILU','11300000','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-251221-0022','2025-12-21','2025-12-21 16:54:33','PENJUALAN : FJ-251221-0018','','TBC','11300000','11300000','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-251221-0023','D','2025-12-21','16:54:34','TBC','PENJUALAN BERLIAN','FJ-251221-0018','18801400614','11300000','18812700614','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='11300000' WHERE no_faktur_jual='FJ-251221-0018' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0018';
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-251221-0019','kasir','1',' 700K-165-1','TOKO','BIPPER','PBDG-YKBE-96-0','CINCIN SILVER 925 ','','2.160','1','100.00','133000','0','0','16800','700000','0','0','0','700000','NITA','00039928','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-96-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PBDG-YKBE-96-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-251221-0019','2025-12-21','2.160','2025-12-21','17:40:10','PLG0008419','700000','700000','0','700000','0','kasir','2025-12-21 17:40:10','FJ-251221-0019','','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-12-21','FJ-251221-0019','2025-12-21','17:40:10','NITA','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-251221-0023','2025-12-21','2025-12-21 17:40:10','PENJUALAN : FJ-251221-0019','.','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-251221-0024','D','2025-12-21','17:40:10','TBC','PENJUALAN','FJ-251221-0019','18812700614','700000','18813400614','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-251221-0019' 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-01606','NITA','1','SEOASANG SILVER','SIZE TETAP KEDUAANYA CC WANITA PTH GLOSY CC PRIA PTH GLOSY FONT ARIAL GRF RASIV','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-01606','2025-12-21','2025-12-21','17:47:43','PLG0008420','kasir','2025-12-31','kasir','2025-12-21 17:47:43','5.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-251221-0020','kasir','1',' 500K-19-55','TOKO','MMPER','PMM-YKAD-36-0','CINCIN SILVER 925 ','','2.060','1','100.00','127000','0','0','16800','500000','0','0','0','500000','NAD','00039613','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKAD-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PMM-YKAD-36-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-251221-0020','2025-12-21','2.060','2025-12-21','17:49:32','PLG0008421','500000','500000','0','500000','0','kasir','2025-12-21 17:49:32','FJ-251221-0020','','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-12-21','FJ-251221-0020','2025-12-21','17:49:32','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-251221-0024','2025-12-21','2025-12-21 17:49:32','PENJUALAN : FJ-251221-0020','.','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-251221-0025','D','2025-12-21','17:49:32','TBC','PENJUALAN','FJ-251221-0020','18813400614','500000','18813900614','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-251221-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-251221-0021','kasir','1',' 700K-12-53','TOKO','MMPER','PMM-YKAD-19-0','CINCIN SILVER 925 ','','1.210','1','100.00','75000','0','0','16800','299000','0','0','0','299000','NIS','00039596','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKAD-19-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-12-21' AND kode_barang='PMM-YKAD-19-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-251221-0021','2025-12-21','1.210','2025-12-21','17:50:03','PLG0008422','299000','299000','0','299000','0','kasir','2025-12-21 17:50:03','FJ-251221-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-12-21','FJ-251221-0021','2025-12-21','17:50:03','NIS','299000','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-251221-0025','2025-12-21','2025-12-21 17:50:03','PENJUALAN : FJ-251221-0021','.','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-251221-0026','D','2025-12-21','17:50:03','TBC','PENJUALAN','FJ-251221-0021','18813900614','299000','18814199614','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-251221-0021' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-21 ','17:50:49');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0019';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0020';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0021';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01607','NITA','1','1 CINCIN SILVER','RESIZE KE 17 KRUM DOFF SEMPOT FONT VINTAGE','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-01607','2025-12-21','2025-12-21','17:52:12','PLG0008423','kasir','2025-12-31','kasir','2025-12-21 17:52:12','5.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-21 ','18:02:06');
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-01524','NITA','1','PER','WEDDING RING','','','5.000','','92.50','1','60000','0','950000','0','950000','zircon 17','size 14 krum putih glosy','grf Robby & Anisa font berkshire swash','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251221-0026','2025-12-21','2025-12-21 18:07:10','PESANAN : DP-01524','.','TBC','950000','950000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251221-0027','D','2025-12-21','18:07:10','TBC','PESANAN','DP-01524','18814199614','950000','18815149614','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-01524','2025-12-21','2025-12-21','18:07:10','PLG0008424','NITA','2026-01-21','kasir','2025-12-21 18:07:10','5.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01525','NITA','1','PER','WEDDING RING','','','5.000','','92.50','1','60000','0','700000','0','700000','krum putih doff amplas','size 17 grf Robby & Anisa font berkshire swash','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251221-0027','2025-12-21','2025-12-21 18:12:02','PESANAN : DP-01525','.','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-251221-0028','D','2025-12-21','18:12:02','TBC','PESANAN','DP-01525','18815149614','700000','18815849614','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-01525','2025-12-21','2025-12-21','18:12:02','PLG0008425','NITA','2026-01-21','kasir','2025-12-21 18:12:02','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-251221-0022','kasir','1',' DP-01388BI','TOKO','BIPPSN','PSPLT-YKBH-6-0','CINCIN PALADIUM ','','3.350','1','6.00','492000','0','0','16800','1805000','0','0','0','1805000','HELMI','00040050','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YKBH-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.350',berat_jual_asli=berat_jual_asli+'3.350',stock_jual='1',berat_akhir=berat_akhir-'3.350',berat_akhir_asli=berat_akhir_asli-'3.350',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PSPLT-YKBH-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-251221-0022','2025-12-21','3.350','2025-12-21','18:16:36','PLG0008426','1805000','1805000','0','1805000','0','kasir','2025-12-21 18:16:36','FJ-251221-0022','DP-01388','1000000');
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-21','FJ-251221-0022','2025-12-21','18:16:36','HELMI','1805000','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-251221-0028','2025-12-21','2025-12-21 18:16:36','PENJUALAN : FJ-251221-0022','.','TBC','1805000','1805000','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-251221-0029','D','2025-12-21','18:16:36','TBC','PENJUALAN','FJ-251221-0022','18815849614','1805000','18817654614','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='1805000' WHERE no_faktur_jual='FJ-251221-0022' 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-251221-0023','kasir',' 1',' DP-01387BI','TOKO','BIPPSN','PSGT-YLXB-38-0','CINCIN EMAS ','','3.390','1','83.00','6472000','0','0','16800','8269000','0','0','0','8269000','HELMI','00040110','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YLXB-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.390',berat_jual_asli=berat_jual_asli+'3.390',stock_jual='1',berat_akhir=berat_akhir-'3.390',berat_akhir_asli=berat_akhir_asli-'3.390',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PSGT-YLXB-38-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-251221-0023','2025-12-21','3.390','2025-12-21','18:16:36','PLG0008427','8269000','8269000','0','8269000','0','kasir','2025-12-21 18:16:36','FJ-251221-0022','DP-01387','5960000');
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-21','FJ-251221-0023','2025-12-21','18:16:36','HELMI','8269000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1805000' WHERE no_faktur_jual='FJ-251221-0023' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0023';
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-251221-0024','kasir','1',' 700K-18-17','TOKO','BIPPER','PBDG-YJBH-22-0','CINCIN SILVER 925 ','','2.000','1','100.00','123000','0','0','16800','700000','0','0','0','700000','NITA','00039330','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YJBH-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='PBDG-YJBH-22-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-251221-0024','2025-12-21','2.000','2025-12-21','18:36:32','PLG0008428','700000','700000','0','700000','0','kasir','2025-12-21 18:36:32','FJ-251221-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-12-21','FJ-251221-0024','2025-12-21','18:36:32','NITA','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-251221-0029','2025-12-21','2025-12-21 18:36:32','PENJUALAN : FJ-251221-0024','.','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-251221-0030','D','2025-12-21','18:36:32','TBC','PENJUALAN','FJ-251221-0024','18817654614','700000','18818354614','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-251221-0024' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0024' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0024' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0024';
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-01526','HELMI','1','GOLD','WEDDING RING','','','1.800','','75.00','1','2310000','2100000','0','750000','4530000','zirkon 13butir','size 8 grf Aji ??','krum putih glosy','130000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251221-0030','2025-12-21','2025-12-21 18:50:54','PESANAN : DP-01526','.','TBC','3700000','3700000');
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-251221-0031','D','2025-12-21','18:50:54','TBC','PESANAN','DP-01526','18818354614','3700000','18822054614','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-01526','2025-12-21','2025-12-21','18:50:54','PLG0008429','HELMI','2026-01-13','kasir','2025-12-21 18:50:54','1.800','0','0','0','3700000','0','750000','4660000','4660000','960000');
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-01527','HELMI','1','PER','WEDDING RING','','','3.000','','925.00','1','60000','0','500000','0','500000','size 17.5 grf Maulidina ??','model ppn list tipis','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-251221-0031','2025-12-21','2025-12-21 18:55:02','PESANAN : DP-01527','.','TBC','500000','500000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251221-0032','D','2025-12-21','18:55:02','TBC','PESANAN','DP-01527','18822054614','500000','18822554614','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-01527','2025-12-21','2025-12-21','18:55:02','PLG0008430','HELMI','2026-01-13','kasir','2025-12-21 18:55:02','3.000','0','0','0','500000','0','0','500000','500000','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-251221-0025','kasir','1',' TFGRR75-82','TOKO','TFGLR','TFGRR-YLXD-11-0','THIFA GELANG RANTAI RG ','','2.160','1','82.00','4174000','0','0','16800','4350000','0','0','0','4350000','FIR','00040191','TFGRR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRR-YLXD-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2025-12-21' AND kode_barang='TFGRR-YLXD-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLR' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251221-0025','2025-12-21','2.160','2025-12-21','19:31:21','PLG0008431','4350000','4350000','0','4350000','0','kasir','2025-12-21 19:31:20','FJ-251221-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-12-21','FJ-251221-0025','2025-12-21','19:31:21','FIR','4350000','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-251221-0032','2025-12-21','2025-12-21 19:31:20','PENJUALAN : FJ-251221-0025','.','TBC','4350000','4350000','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-251221-0033','D','2025-12-21','19:31:21','TBC','PENJUALAN','FJ-251221-0025','18822554614','4350000','18826904614','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='4350000' WHERE no_faktur_jual='FJ-251221-0025' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0025' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251221-0025' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251221-0025';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01608','NAD','1','CINCIN SILVER','GRF RIFKY KRUM PUTIH SESUAI CTH','2.450','1','','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-01608','2025-12-21','2025-12-21','19:35:02','PLG0008432','kasir','2025-12-22','kasir','2025-12-21 19:35:02','2.450','0','0','0','0','0','0','0','0');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-22','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-21';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-21';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-21';
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-12-21' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-21';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-21';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-21';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-21';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-22' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-21' 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-251222-0001','D','2025-12-22','20:09:03','TBC','SALDO AWAL','SALDO AWAL','0','18826904614','18826904614');
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-251222-0001','D','2025-12-22','20:09:03','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251222-0001','D','2025-12-22','20:09:03','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-251222-0001','D','2025-12-22','20:09:03','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-251222-0001','D','2025-12-22','20:09:03','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-251222-0001','D','2025-12-22','20:09:03','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-251222-0001','D','2025-12-22','20:09:03','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-251222-0001','D','2025-12-22','20:09:03','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-251222-0001','D','2025-12-22','20:09:03','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-251222-0001','D','2025-12-22','20:09:03','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-251222-0001','D','2025-12-22','20:09:03','BCK','SALDO AWAL','SALDO AWAL','0','1940208000','1940208000');
UPDATE tp_system SET tgl_system='2025-12-22';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-21 ','21:10:50');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01609','HELMI','1','CC SLV','JD SIZE 11 GRF MENYUSUL','2.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01609','2025-12-22','2025-12-22','21:16:44','PLG0008433','kasir','2025-12-23','kasir','2025-12-21 21:16:44','2.000','0','0','0','0','0','0','0','0');