INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-07 ','10:09:10'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-07','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-04'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-06'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-06'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-03-06' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-06'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-06'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-06'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-06'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; UPDATE tt_barang_saldo SET tanggal= '2026-03-07' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-06' 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-260307-0001','D','2026-03-07','10:14:25','TBC','SALDO AWAL','SALDO AWAL','0','20814505514','20814505514'); 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-260307-0001','D','2026-03-07','10:14:25','BCK','SALDO AWAL','SALDO AWAL','0','1967608000','1967608000'); 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-260307-0001','D','2026-03-07','10:14:25','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260307-0001','D','2026-03-07','10:14:25','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260307-0001','D','2026-03-07','10:14:25','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-260307-0001','D','2026-03-07','10:14:25','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260307-0001','D','2026-03-07','10:14:25','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260307-0001','D','2026-03-07','10:14:25','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260307-0001','D','2026-03-07','10:14:25','SHO','SALDO AWAL','SALDO AWAL','0','142865650','142865650'); 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-260307-0001','D','2026-03-07','10:14:25','KET','SALDO AWAL','SALDO AWAL','0','152646000','152646000'); 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-260307-0001','D','2026-03-07','10:14:25','BCD','SALDO AWAL','SALDO AWAL','0','1355733500','1355733500'); UPDATE tp_system SET tgl_system='2026-03-07'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-07 ','10:36:28'); UPDATE tt_service_head SET tgl_selesai='2026-03-07', status ='DONE' WHERE no_service='SV-01827'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01827'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-03-07', status ='CLOS' WHERE no_service='SV-01827'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01827'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-07 ','10:55:28'); 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-260307-0001','kasirbip','1',' PBDG-00352','TOKO','BIPPER','PBDG-XHBG-58-0','CINCIN PERAK PBDG-00352 ','','1.750','1','100.00','213000','150000','0','17000','800000','0','0','0','800000','KUR','00030906','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-XHBG-58-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.750',berat_jual_asli=berat_jual_asli+'1.750',stock_jual='1',berat_akhir=berat_akhir-'1.750',berat_akhir_asli=berat_akhir_asli-'1.750',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PBDG-XHBG-58-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-260307-0001','2026-03-07','1.750','2026-03-07','11:07:25','PLG0009808','800000','800000','0','800000','0','kasirbip','2026-03-07 11:07:24','FJ-260307-0001','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0001','2026-03-07','11:07:25','KUR','800000','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-260307-0001','2026-03-07','2026-03-07 11:07:24','PENJUALAN : FJ-260307-0001','','TBC','800000','800000','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-260307-0002','D','2026-03-07','11:07:25','TBC','PENJUALAN','FJ-260307-0001','20814505514','800000','20815305514','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='800000' WHERE no_faktur_jual='FJ-260307-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-260307-0002','kasirbip','1',' 700K-14-22','TOKO','BIPPER','PBDG-ZBAB-7-0','CINCIN SILVER 925 ','','1.630','1','100.00','167000','0','0','17000','800000','0','0','0','800000','KUR','00041528','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBAB-7-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.630',berat_jual_asli=berat_jual_asli+'1.630',stock_jual='1',berat_akhir=berat_akhir-'1.630',berat_akhir_asli=berat_akhir_asli-'1.630',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PBDG-ZBAB-7-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-260307-0002','2026-03-07','1.630','2026-03-07','11:09:41','PLG0009809','800000','800000','0','800000','0','kasirbip','2026-03-07 11:09:40','FJ-260307-0002','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0002','2026-03-07','11:09:41','KUR','800000','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-260307-0002','2026-03-07','2026-03-07 11:09:40','PENJUALAN : FJ-260307-0002','','TBC','800000','800000','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-260307-0003','D','2026-03-07','11:09:41','TBC','PENJUALAN','FJ-260307-0002','20815305514','800000','20816105514','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='800000' WHERE no_faktur_jual='FJ-260307-0002' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0002'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0001'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260307-0003','kasirbip','1',' DP-01769BI','TOKO','BIPPSN','PSPLT-ZCXC-36-0','CINCIN PALADIUM ','','4.060','1','17.00','912000','0','0','17000','1918000','0','0','0','1918000','SULIS','00042179','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZCXC-36-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.060',berat_jual_asli=berat_jual_asli+'4.060',stock_jual='1',berat_akhir=berat_akhir-'4.060',berat_akhir_asli=berat_akhir_asli-'4.060',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PSPLT-ZCXC-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260307-0003','2026-03-07','4.060','2026-03-07','11:53:28','PLG0009810','1918000','1918000','0','1918000','0','kasirbip','2026-03-07 11:53:27','FJ-260307-0003','DP-01769','950000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0003','2026-03-07','11:53:28','SULIS','1918000','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-260307-0003','2026-03-07','2026-03-07 11:53:27','PENJUALAN : FJ-260307-0003','','TBC','968000','968000','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-260307-0004','D','2026-03-07','11:53:28','TBC','PENJUALAN','FJ-260307-0003','20816105514','968000','20817073514','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='968000' WHERE no_faktur_jual='FJ-260307-0003' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-07 ','12:01:17'); UPDATE tt_service_head SET tgl_selesai='2026-03-07', status ='DONE' WHERE no_service='SV-01823'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01823'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-03-07', status ='CLOS' WHERE no_service='SV-01823'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01823'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-07 ','12:16:15'); 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-260307-0004','kasir','1',' PLDMM-0003','TOKO','MMPLD','PLDMM-ZACX-19-0','CINCIN PALADIUM PLDMM-00033 ','','3.300','1','17.00','741000','0','0','17000','1690000','0','0','0','1690000','NISA','00041233','PLDMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLDMM-ZACX-19-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.300',berat_jual_asli=berat_jual_asli+'3.300',stock_jual='1',berat_akhir=berat_akhir-'3.300',berat_akhir_asli=berat_akhir_asli-'3.300',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PLDMM-ZACX-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPLD' 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-260307-0004','2026-03-07','3.300','2026-03-07','12:52:19','PLG0009811','1690000','1690000','0','1690000','0','kasir','2026-03-07 12:52:19','FJ-260307-0004','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0004','2026-03-07','12:52:19','NISA','1690000','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-260307-0004','2026-03-07','2026-03-07 12:52:19','PENJUALAN : FJ-260307-0004','.','TBC','1690000','1690000','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-260307-0005','D','2026-03-07','12:52:19','TBC','PENJUALAN','FJ-260307-0004','20817073514','1690000','20818763514','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='1690000' WHERE no_faktur_jual='FJ-260307-0004' 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-01868','NISA','1','2PC CCN','KRUM KMBINASI ROSEGOLD GRF VIESCA DUA DUANYA RESIZE KE 15 5 DAN YG 1 KRUM FULL PUTIH','5.630','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-01868','2026-03-07','2026-03-07','12:56:15','PLG0009812','kasir','2026-03-08','kasir','2026-03-07 12:56:15','5.630','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-260307-0005','kasirbip','1',' 700K-15-22','TOKO','BIPPER','PBDG-ZBAX-41-0','CINCIN SILVER 925 ','','2.630','1','100.00','269000','0','0','17000','750000','0','0','0','750000','KUR','00041477','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBAX-41-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.630',berat_jual_asli=berat_jual_asli+'2.630',stock_jual='1',berat_akhir=berat_akhir-'2.630',berat_akhir_asli=berat_akhir_asli-'2.630',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PBDG-ZBAX-41-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-260307-0005','2026-03-07','2.630','2026-03-07','13:39:30','PLG0009813','750000','750000','0','750000','0','kasirbip','2026-03-07 13:39:29','FJ-260307-0005','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0005','2026-03-07','13:39:30','KUR','750000','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-260307-0005','2026-03-07','2026-03-07 13:39:29','PENJUALAN : FJ-260307-0005','','TBC','750000','750000','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-260307-0006','D','2026-03-07','13:39:30','TBC','PENJUALAN','FJ-260307-0005','20818763514','750000','20819513514','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='750000' WHERE no_faktur_jual='FJ-260307-0005' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0004'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-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-260307-0006','kasirbip','1',' 800K-13-00','TOKO','BIPPER','PBSD-YGBI-59-0','CINCIN SILVER 925 ','','1.400','1','100.00','29000','0','0','17000','900000','0','0','0','900000','KUR','00037695','PBSD','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGBI-59-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.400',berat_jual_asli=berat_jual_asli+'1.400',stock_jual='1',berat_akhir=berat_akhir-'1.400',berat_akhir_asli=berat_akhir_asli-'1.400',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PBSD-YGBI-59-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-260307-0006','2026-03-07','1.400','2026-03-07','14:19:48','PLG0009814','900000','900000','0','900000','0','kasirbip','2026-03-07 14:19:47','FJ-260307-0006','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0006','2026-03-07','14:19:48','KUR','900000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260307-0006','2026-03-07','2026-03-07 14:19:47','PENJUALAN : FJ-260307-0006','.','TBC','900000','900000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260307-0007','D','2026-03-07','14:19:48','TBC','PENJUALAN','FJ-260307-0006','20819513514','900000','20820413514','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='900000' WHERE no_faktur_jual='FJ-260307-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-260307-0007','kasirbip',' 1',' 700K-19-21','TOKO','BIPPER','PBDG-ZAAI-39-0','CINCIN SILVER 925 ','','4.620','1','100.00','284000','0','0','17000','850000','0','0','0','850000','KUR','00041021','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZAAI-39-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.620',berat_jual_asli=berat_jual_asli+'4.620',stock_jual='1',berat_akhir=berat_akhir-'4.620',berat_akhir_asli=berat_akhir_asli-'4.620',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PBDG-ZAAI-39-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-260307-0007','2026-03-07','4.620','2026-03-07','14:19:48','PLG0009815','850000','850000','0','850000','0','kasirbip','2026-03-07 14:19:47','FJ-260307-0006','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0007','2026-03-07','14:19:48','KUR','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-260307-0007','2026-03-07','2026-03-07 14:19:47','PENJUALAN : FJ-260307-0007','.','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-260307-0008','D','2026-03-07','14:19:48','TBC','PENJUALAN','FJ-260307-0007','20820413514','850000','20821263514','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='1750000' WHERE no_faktur_jual='FJ-260307-0007' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260307-0008','kasirbip',' 1',' 900K-13 ','TOKO','BIPCMP','BDCM-YLAH-11-0','CINCIN EMAS ','','2.120','1','83.00','5026000','0','0','17000','6250000','0','0','0','6250000','KUR','00040625','BDCM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-YLAH-11-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='2026-03-07' AND kode_barang='BDCM-YLAH-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' 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-260307-0008','2026-03-07','2.120','2026-03-07','14:19:48','PLG0009816','6250000','6250000','0','6250000','0','kasirbip','2026-03-07 14:19:47','FJ-260307-0006','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0008','2026-03-07','14:19:48','KUR','6250000','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-260307-0008','2026-03-07','2026-03-07 14:19:47','PENJUALAN : FJ-260307-0008','.','TBC','6250000','6250000','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-260307-0009','D','2026-03-07','14:19:48','TBC','PENJUALAN','FJ-260307-0008','20821263514','6250000','20827513514','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='8000000' WHERE no_faktur_jual='FJ-260307-0008' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-03-07 ','14:19:55'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0006'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0008'; 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-260307-0009','kasirbip','1',' PBDG-00148','TOKO','BIPPER','PBDG-XHXB-18-0','CINCIN PERAK PBDG-00148 ','','1.550','1','100.00','209000','150000','0','17000','800000','0','0','0','800000','MIA','00030298','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-XHXB-18-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PBDG-XHXB-18-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-260307-0009','2026-03-07','1.550','2026-03-07','14:36:44','PLG0009817','800000','800000','0','800000','0','kasirbip','2026-03-07 14:36:43','FJ-260307-0009','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0009','2026-03-07','14:36:44','MIA','800000','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-260307-0009','2026-03-07','2026-03-07 14:36:43','PENJUALAN : FJ-260307-0009','','TBC','800000','800000','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-260307-0010','D','2026-03-07','14:36:44','TBC','PENJUALAN','FJ-260307-0009','20827513514','800000','20828313514','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='800000' WHERE no_faktur_jual='FJ-260307-0009' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260307-0010','kasirbip',' 1',' 700K-14-22','TOKO','BIPPER','PBDG-ZBAX-43-0','CINCIN SILVER 925 ','','2.870','1','100.00','293000','0','0','17000','800000','0','0','0','800000','MIA','00041479','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBAX-43-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.870',berat_jual_asli=berat_jual_asli+'2.870',stock_jual='1',berat_akhir=berat_akhir-'2.870',berat_akhir_asli=berat_akhir_asli-'2.870',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PBDG-ZBAX-43-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-260307-0010','2026-03-07','2.870','2026-03-07','14:36:44','PLG0009818','800000','800000','0','800000','0','kasirbip','2026-03-07 14:36:43','FJ-260307-0009','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0010','2026-03-07','14:36:44','MIA','800000','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-260307-0010','2026-03-07','2026-03-07 14:36:43','PENJUALAN : FJ-260307-0010','','TBC','800000','800000','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-260307-0011','D','2026-03-07','14:36:44','TBC','PENJUALAN','FJ-260307-0010','20828313514','800000','20829113514','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1600000' WHERE no_faktur_jual='FJ-260307-0010' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0009'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0010'; 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-260307-0011','kasir','1',' DP-01810MM','TOKO','MMPSN','PSPRT-ZCXF-6-0','1PS CINCIN PERAK ','','3.240','1','100.00','331000','0','0','17000','850000','0','0','0','850000','ASRI','00042209','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZCXF-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.240',berat_jual_asli=berat_jual_asli+'3.240',stock_jual='1',berat_akhir=berat_akhir-'3.240',berat_akhir_asli=berat_akhir_asli-'3.240',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PSPRT-ZCXF-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260307-0011','2026-03-07','3.240','2026-03-07','15:14:48','PLG0009819','850000','850000','0','850000','0','kasir','2026-03-07 15:14:48','FJ-260307-0011','DP-01810','850000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0011','2026-03-07','15:14:48','ASRI','850000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260307-0011' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0011'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01869','SULIS','1','SEPASANG SILVER','COWO SZ 22 PUTIH GLOSY CEWE PUTIH GLOSY GRAFIR JANGAN HILANG','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-01869','2026-03-07','2026-03-07','15:23:38','PLG0009820','kasirbip','2026-04-05','kasirbip','2026-03-07 15:23:38','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-260307-0012','kasirbip','1',' DP-01761BI','TOKO','BIPPSN','PSPLT-ZCXC-39-0','CINCIN PALADIUM ','','3.190','1','17.00','717000','0','0','17000','1707000','0','0','0','1707000','SULIS','00042182','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZCXC-39-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.190',berat_jual_asli=berat_jual_asli+'3.190',stock_jual='1',berat_akhir=berat_akhir-'3.190',berat_akhir_asli=berat_akhir_asli-'3.190',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PSPLT-ZCXC-39-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-260307-0012','2026-03-07','3.190','2026-03-07','15:39:43','PLG0009821','1707000','1707000','0','1707000','0','kasirbip','2026-03-07 15:39:42','FJ-260307-0012','DP-01761','1650000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0012','2026-03-07','15:39:43','SULIS','1707000','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-260307-0011','2026-03-07','2026-03-07 15:39:42','PENJUALAN : FJ-260307-0012','.','TBC','57000','57000','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-260307-0012','D','2026-03-07','15:39:43','TBC','PENJUALAN','FJ-260307-0012','20829113514','57000','20829170514','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='57000' WHERE no_faktur_jual='FJ-260307-0012' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260307-0013','kasirbip',' 1',' DP-01762BI','TOKO','BIPPSN','PSPLT-ZCXC-33-0','CINCIN PALADIUM ','','3.190','1','17.00','717000','0','0','17000','2267000','0','0','0','2267000','SULIS','00042176','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZCXC-33-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.190',berat_jual_asli=berat_jual_asli+'3.190',stock_jual='1',berat_akhir=berat_akhir-'3.190',berat_akhir_asli=berat_akhir_asli-'3.190',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PSPLT-ZCXC-33-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-260307-0013','2026-03-07','3.190','2026-03-07','15:39:43','PLG0009822','2267000','2267000','0','2267000','0','kasirbip','2026-03-07 15:39:42','FJ-260307-0012','DP-01762','1650000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0013','2026-03-07','15:39:43','SULIS','2267000','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-260307-0012','2026-03-07','2026-03-07 15:39:42','PENJUALAN : FJ-260307-0013','.','TBC','617000','617000','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-260307-0013','D','2026-03-07','15:39:43','TBC','PENJUALAN','FJ-260307-0013','20829170514','617000','20829787514','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='674000' WHERE no_faktur_jual='FJ-260307-0013' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0013'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-07 ','16:16:08'); 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-260307-0014','kasir','1',' TFGRR75-81','TOKO','TFGLR','TFGRR-YLXC-51-0','THIFA GELANG RANTAI RG ','','3.120','1','81.00','7219000','0','0','17000','7500000','0','0','0','7500000','RISIANA','00040174','TFGRR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRR-YLXC-51-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.120',berat_jual_asli=berat_jual_asli+'3.120',stock_jual='1',berat_akhir=berat_akhir-'3.120',berat_akhir_asli=berat_akhir_asli-'3.120',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='TFGRR-YLXC-51-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-260307-0014','2026-03-07','3.120','2026-03-07','16:24:26','PLG0009823','7500000','7500000','0','7500000','0','kasir','2026-03-07 16:24:26','FJ-260307-0014','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0014','2026-03-07','16:24:26','RISIANA','7500000','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-260307-0013','2026-03-07','2026-03-07 16:24:26','PENJUALAN : FJ-260307-0014','.','TBC','7500000','7500000','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-260307-0014','D','2026-03-07','16:24:26','TBC','PENJUALAN','FJ-260307-0014','20829787514','7500000','20837287514','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='7500000' WHERE no_faktur_jual='FJ-260307-0014' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0014'; 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-260307-0015','kasirbip','1',' 700K-11-23','TOKO','BIPPER','PBDG-ZCXC-19-0','CINCIN SILVER 925 ','','1.530','1','100.00','157000','0','0','17000','800000','0','0','0','800000','KUR','00042162','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZCXC-19-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PBDG-ZCXC-19-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-260307-0015','2026-03-07','1.530','2026-03-07','16:37:20','PLG0009824','800000','800000','0','800000','0','kasirbip','2026-03-07 16:37:20','FJ-260307-0015','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0015','2026-03-07','16:37:20','KUR','800000','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-260307-0014','2026-03-07','2026-03-07 16:37:20','PENJUALAN : FJ-260307-0015','','TBC','800000','800000','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-260307-0015','D','2026-03-07','16:37:20','TBC','PENJUALAN','FJ-260307-0015','20837287514','800000','20838087514','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='800000' WHERE no_faktur_jual='FJ-260307-0015' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260307-0016','kasirbip',' 1',' 500K-18-22','TOKO','BIPPER','PBDG-ZBBG-6-0','CINCIN SILVER 925 ','','2.060','1','100.00','211000','0','0','17000','600000','0','0','0','600000','KUR','00042008','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBBG-6-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='2026-03-07' AND kode_barang='PBDG-ZBBG-6-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-260307-0016','2026-03-07','2.060','2026-03-07','16:37:20','PLG0009825','600000','600000','0','600000','0','kasirbip','2026-03-07 16:37:20','FJ-260307-0015','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0016','2026-03-07','16:37:20','KUR','600000','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-260307-0015','2026-03-07','2026-03-07 16:37:20','PENJUALAN : FJ-260307-0016','','TBC','600000','600000','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-260307-0016','D','2026-03-07','16:37:20','TBC','PENJUALAN','FJ-260307-0016','20838087514','600000','20838687514','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1400000' WHERE no_faktur_jual='FJ-260307-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-260307-0017','kasirbip','1',' 950K-14-22','TOKO','BIPPER','PBDG-ZBAA-28-0','CINCIN SILVER 925 ','','1.540','1','100.00','158000','0','0','17000','1100000','0','0','0','1100000','MIA','00041517','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBAA-28-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.540',berat_jual_asli=berat_jual_asli+'1.540',stock_jual='1',berat_akhir=berat_akhir-'1.540',berat_akhir_asli=berat_akhir_asli-'1.540',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PBDG-ZBAA-28-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-260307-0017','2026-03-07','1.540','2026-03-07','16:40:34','PLG0009826','1100000','1100000','0','1100000','0','kasirbip','2026-03-07 16:40:34','FJ-260307-0017','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0017','2026-03-07','16:40:34','MIA','1100000','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-260307-0016','2026-03-07','2026-03-07 16:40:34','PENJUALAN : FJ-260307-0017','.','TBC','1100000','1100000','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-260307-0017','D','2026-03-07','16:40:34','TBC','PENJUALAN','FJ-260307-0017','20838687514','1100000','20839787514','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1100000' WHERE no_faktur_jual='FJ-260307-0017' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0015'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0016'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0017'; UPDATE tt_service_head SET tgl_selesai='2026-03-07', status ='DONE' WHERE no_service='SV-01863'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01863'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-03-07', status ='CLOS' WHERE no_service='SV-01863'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01863'; 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-01814','SULIS','1','GOLD','WED RING','','','2.000','','75.00','1','2800000','2450000','0','750000','5650000','17 zirkon putih glosy','sz 12 grf Hanafi','font vladimir','170000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260307-0017','2026-03-07','2026-03-07 17:06:31','PESANAN : DP-01814','.','TBC','4656000','4656000'); 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-260307-0018','D','2026-03-07','17:06:31','TBC','PESANAN','DP-01814','20839787514','4656000','20844443514','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-01814','2026-03-07','2026-03-07','17:06:31','PLG0009827','SULIS','2026-04-20','kasirbip','2026-03-07 17:06:31','2.000','0','0','0','4656000','0','750000','5820000','5820000','1164000'); 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-01815','SULIS','1','PLD','WED RING','','','2.500','','10.00','1','1200000','300000','0','700000','1450000','putih doff semprot sz 13','grf Intan font vladimir','','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-260307-0018','2026-03-07','2026-03-07 17:10:30','PESANAN : DP-01815','.','TBC','1160000','1160000'); 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-260307-0019','D','2026-03-07','17:10:30','TBC','PESANAN','DP-01815','20844443514','1160000','20845603514','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-01815','2026-03-07','2026-03-07','17:10:30','PLG0009828','SULIS','2026-04-20','kasirbip','2026-03-07 17:10:30','2.500','0','0','0','1160000','0','700000','1450000','1450000','290000'); 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-260307-0018','kasirbip','1',' DP-01800BI','TOKO','BIPPSN','PSPRT-ZCXC-35-0','CINCIN PERAK ','','1.800','1','100.00','184000','0','0','17000','800000','0','0','0','800000','SULIS','00042178','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZCXC-35-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PSPRT-ZCXC-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260307-0018','2026-03-07','1.800','2026-03-07','17:11:26','PLG0009829','800000','800000','0','800000','0','kasirbip','2026-03-07 17:11:25','FJ-260307-0018','DP-01800','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('2026-03-07','FJ-260307-0018','2026-03-07','17:11:26','SULIS','800000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260307-0018' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-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-260307-0019','kasir','1',' 750K-11-91','TOKO','MMPER','PMM-ZBBG-15-0','CINCIN SILVER 925 ','','2.450','1','100.00','251000','0','0','17000','600000','0','0','0','600000','ILUNG','00042017','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZBBG-15-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.450',berat_jual_asli=berat_jual_asli+'2.450',stock_jual='1',berat_akhir=berat_akhir-'2.450',berat_akhir_asli=berat_akhir_asli-'2.450',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PMM-ZBBG-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260307-0019','2026-03-07','2.450','2026-03-07','17:35:40','PLG0009830','600000','600000','0','600000','0','kasir','2026-03-07 17:35:40','FJ-260307-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('2026-03-07','FJ-260307-0019','2026-03-07','17:35:40','ILUNG','600000','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-260307-0019','2026-03-07','2026-03-07 17:35:40','PENJUALAN : FJ-260307-0019','.','TBC','600000','600000','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-260307-0020','D','2026-03-07','17:35:40','TBC','PENJUALAN','FJ-260307-0019','20845603514','600000','20846203514','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='600000' WHERE no_faktur_jual='FJ-260307-0019' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260307-0020','kasir',' 1',' 500K-22-91','TOKO','MMPER','PMM-ZBBG-19-0','CINCIN SILVER 925 ','','2.150','1','100.00','220000','0','0','17000','600000','0','0','0','600000','ILUNG','00042021','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZBBG-19-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.150',berat_jual_asli=berat_jual_asli+'2.150',stock_jual='1',berat_akhir=berat_akhir-'2.150',berat_akhir_asli=berat_akhir_asli-'2.150',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PMM-ZBBG-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-260307-0020','2026-03-07','2.150','2026-03-07','17:35:40','PLG0009831','600000','600000','0','600000','0','kasir','2026-03-07 17:35:40','FJ-260307-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('2026-03-07','FJ-260307-0020','2026-03-07','17:35:40','ILUNG','600000','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-260307-0020','2026-03-07','2026-03-07 17:35:40','PENJUALAN : FJ-260307-0020','.','TBC','600000','600000','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-260307-0021','D','2026-03-07','17:35:40','TBC','PENJUALAN','FJ-260307-0020','20846203514','600000','20846803514','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='1200000' WHERE no_faktur_jual='FJ-260307-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-260307-0021','kasirbip','1',' 500K-20-21','TOKO','BIPPER','PBDG-YLCA-21-0','CINCIN SILVER 925 ','','2.030','1','100.00','125000','0','0','17000','450000','0','0','0','450000','KUR','00040740','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YLCA-21-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='2026-03-07' AND kode_barang='PBDG-YLCA-21-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-260307-0021','2026-03-07','2.030','2026-03-07','17:41:42','PLG0009832','450000','450000','0','450000','0','kasirbip','2026-03-07 17:41:41','FJ-260307-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('2026-03-07','FJ-260307-0021','2026-03-07','17:41:42','KUR','450000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260307-0021','2026-03-07','2026-03-07 17:41:41','PENJUALAN : FJ-260307-0021','.','TBC','450000','450000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260307-0022','D','2026-03-07','17:41:42','TBC','PENJUALAN','FJ-260307-0021','20846803514','450000','20847253514','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='450000' WHERE no_faktur_jual='FJ-260307-0021' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260307-0022','kasirbip',' 1',' TFPER-0005','TOKO','BIPPER','TFPER-YBXD-34-0','CINCIN PERAK TFPER-00051 ','','1.140','1','100.00','199000','150000','0','17000','400000','0','0','0','400000','KUR','00033913','TFPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFPER-YBXD-34-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.140',berat_jual_asli=berat_jual_asli+'1.140',stock_jual='1',berat_akhir=berat_akhir-'1.140',berat_akhir_asli=berat_akhir_asli-'1.140',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='TFPER-YBXD-34-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-260307-0022','2026-03-07','1.140','2026-03-07','17:41:42','PLG0009833','400000','400000','0','400000','0','kasirbip','2026-03-07 17:41:41','FJ-260307-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('2026-03-07','FJ-260307-0022','2026-03-07','17:41:42','KUR','400000','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-260307-0022','2026-03-07','2026-03-07 17:41:41','PENJUALAN : FJ-260307-0022','.','TBC','400000','400000','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-260307-0023','D','2026-03-07','17:41:42','TBC','PENJUALAN','FJ-260307-0022','20847253514','400000','20847653514','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-260307-0022' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0019' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0019'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0020' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0020' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0020'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0021' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0021' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0021'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0022' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0022' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0022'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01870','ILUNG','1','2PC CCN SLV','CWE : 12 GRF SYAMSUL BAHRI DAN COWO : 18 GRF FITRI AMELIA NANTI BAWA NYA KE ITC','4.600','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-01870','2026-03-07','2026-03-07','17:47:30','PLG0009834','kasir','2026-03-08','kasir','2026-03-07 17:47:30','4.600','0','0','0','0','0','0','0','0'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXD-1-0','1','2.040','2.040','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXD-1-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXD-1-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXD-1-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXD-1-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXD-1-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXD-1-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXD-1-0','1','2.040','2.040','1','2.040','2.040','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXD-1-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXD-1-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXD-2-0','1','3.010','3.010','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXD-2-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXD-2-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXD-2-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXD-2-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXD-2-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXD-2-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXD-2-0','1','3.010','3.010','1','3.010','3.010','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXD-2-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXD-2-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXD-3-0','1','3.790','3.790','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXD-3-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXD-3-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXD-3-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXD-3-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXD-3-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXD-3-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXD-3-0','1','3.790','3.790','1','3.790','3.790','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXD-3-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXD-3-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXE-2-0','1','3.070','3.070','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXE-2-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-2-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXE-2-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXE-2-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXE-2-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXE-2-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXE-2-0','1','3.070','3.070','1','3.070','3.070','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXE-2-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-2-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXE-3-0','1','1.340','1.340','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXE-3-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-3-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXE-3-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXE-3-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXE-3-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXE-3-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXE-3-0','1','1.340','1.340','1','1.340','1.340','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXE-3-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-3-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXE-4-0','1','3.610','3.610','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXE-4-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-4-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXE-4-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXE-4-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXE-4-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXE-4-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXE-4-0','1','3.610','3.610','1','3.610','3.610','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXE-4-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-4-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXE-5-0','1','1.590','1.590','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXE-5-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-5-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXE-5-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXE-5-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXE-5-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXE-5-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXE-5-0','1','1.590','1.590','1','1.590','1.590','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXE-5-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-5-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXE-6-0','1','2.410','2.410','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXE-6-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-6-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXE-6-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXE-6-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXE-6-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXE-6-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXE-6-0','1','2.410','2.410','1','2.410','2.410','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXE-6-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-6-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXE-7-0','1','2.740','2.740','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXE-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-7-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXE-7-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXE-7-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXE-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXE-7-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXE-7-0','1','2.740','2.740','1','2.740','2.740','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXE-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-7-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXE-8-0','1','4.110','4.110','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXE-8-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-8-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXE-8-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXE-8-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXE-8-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXE-8-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXE-8-0','1','4.110','4.110','1','4.110','4.110','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXE-8-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-8-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXE-9-0','1','3.180','3.180','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXE-9-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-9-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXE-9-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXE-9-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXE-9-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXE-9-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXE-9-0','1','3.180','3.180','1','3.180','3.180','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXE-9-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-9-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPLT-ZCXE-10-0','1','1.970','1.970','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZCXE-10-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZCXE-10-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZCXE-10-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZCXE-10-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPLT-ZCXE-10-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZCXE-10-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPLT','PSPLT-ZCXE-10-0','1','1.970','1.970','1','1.970','1.970','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZCXE-10-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZCXE-10-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXE-11-0','1','2.750','2.750','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXE-11-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-11-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXE-11-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXE-11-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXE-11-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXE-11-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXE-11-0','1','2.750','2.750','1','2.750','2.750','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXE-11-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-11-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXE-12-0','1','2.960','2.960','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXE-12-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-12-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXE-12-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXE-12-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXE-12-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXE-12-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXE-12-0','1','2.960','2.960','1','2.960','2.960','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXE-12-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-12-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXE-13-0','1','4.210','4.210','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXE-13-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-13-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXE-13-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXE-13-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXE-13-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXE-13-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXE-13-0','1','4.210','4.210','1','4.210','4.210','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXE-13-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXE-13-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPLT-ZCXE-14-0','1','3.690','3.690','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZCXE-14-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZCXE-14-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZCXE-14-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZCXE-14-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPLT-ZCXE-14-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZCXE-14-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPLT','PSPLT-ZCXE-14-0','1','3.690','3.690','1','3.690','3.690','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZCXE-14-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZCXE-14-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPLT-ZCXE-15-0','1','3.840','3.840','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZCXE-15-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZCXE-15-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZCXE-15-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZCXE-15-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPLT-ZCXE-15-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZCXE-15-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPLT','PSPLT-ZCXE-15-0','1','3.840','3.840','1','3.840','3.840','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZCXE-15-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZCXE-15-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXF-7-0','1','1.570','1.570','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXF-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXF-7-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXF-7-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXF-7-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXF-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXF-7-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXF-7-0','1','1.570','1.570','1','1.570','1.570','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXF-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXF-7-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXF-8-0','1','2.630','2.630','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXF-8-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXF-8-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXF-8-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXF-8-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXF-8-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXF-8-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXF-8-0','1','2.630','2.630','1','2.630','2.630','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXF-8-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXF-8-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXF-9-0','1','1.910','1.910','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXF-9-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXF-9-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXF-9-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXF-9-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXF-9-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXF-9-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXF-9-0','1','1.910','1.910','1','1.910','1.910','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXF-9-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXF-9-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXF-10-0','1','2.760','2.760','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXF-10-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXF-10-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXF-10-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXF-10-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXF-10-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXF-10-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXF-10-0','1','2.760','2.760','1','2.760','2.760','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXF-10-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXF-10-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXF-11-0','1','3.210','3.210','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXF-11-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXF-11-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXF-11-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXF-11-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXF-11-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXF-11-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXF-11-0','1','3.210','3.210','1','3.210','3.210','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXF-11-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXF-11-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPLT-ZCXF-12-0','1','1.840','1.840','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZCXF-12-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZCXF-12-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZCXF-12-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZCXF-12-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPLT-ZCXF-12-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZCXF-12-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPLT','PSPLT-ZCXF-12-0','1','1.840','1.840','1','1.840','1.840','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZCXF-12-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZCXF-12-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPLT-ZCXF-13-0','1','2.930','2.930','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZCXF-13-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZCXF-13-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZCXF-13-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZCXF-13-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPLT-ZCXF-13-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZCXF-13-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPLT','PSPLT-ZCXF-13-0','1','2.930','2.930','1','2.930','2.930','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZCXF-13-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZCXF-13-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXF-14-0','1','1.660','1.660','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXF-14-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXF-14-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXF-14-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXF-14-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXF-14-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXF-14-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXF-14-0','1','1.660','1.660','1','1.660','1.660','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXF-14-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXF-14-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXF-15-0','1','1.820','1.820','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXF-15-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXF-15-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXF-15-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXF-15-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXF-15-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXF-15-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXF-15-0','1','1.820','1.820','1','1.820','1.820','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXF-15-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXF-15-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSGT-ZCXF-16-0','1','1.500','1.500','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZCXF-16-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZCXF-16-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZCXF-16-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZCXF-16-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSGT-ZCXF-16-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZCXF-16-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSGT','PSGT-ZCXF-16-0','1','1.500','1.500','1','1.500','1.500','58.00'); DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZCXF-16-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZCXF-16-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXF-17-0','1','1.400','1.400','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXF-17-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXF-17-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXF-17-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXF-17-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXF-17-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXF-17-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXF-17-0','1','1.400','1.400','1','1.400','1.400','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXF-17-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXF-17-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPLT-ZCXF-18-0','1','3.830','3.830','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZCXF-18-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZCXF-18-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZCXF-18-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZCXF-18-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPLT-ZCXF-18-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZCXF-18-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPLT','PSPLT-ZCXF-18-0','1','3.830','3.830','1','3.830','3.830','32.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZCXF-18-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZCXF-18-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260307-0001','1','PSPRT-ZCXF-19-0','1','2.690','2.690','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZCXF-19-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXF-19-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZCXF-19-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZCXF-19-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-03-07 18:00:48' WHERE kode_barang='PSPRT-ZCXF-19-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZCXF-19-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-07 18:00:48','TOKO','BIPPSN','PSPRT','PSPRT-ZCXF-19-0','1','2.690','2.690','1','2.690','2.690','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZCXF-19-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZCXF-19-0'; UPDATE tt_beli_detail SET tgl_terima='2026-03-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260307-0001','2026-03-07','17:59','80.060','kasirbip','2026-03-07 18:00:47'); 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-260307-0023','kasir','1',' DP-01724MM','TOKO','MMPSN','PSGT-ZBBF-96-0','CINCIN EMAS ','','3.790','1','83.00','8728000','0','0','17000','10175000','0','0','0','10175000','NISA','00041995','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZBBF-96-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.790',berat_jual_asli=berat_jual_asli+'3.790',stock_jual='1',berat_akhir=berat_akhir-'3.790',berat_akhir_asli=berat_akhir_asli-'3.790',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PSGT-ZBBF-96-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260307-0023','2026-03-07','3.790','2026-03-07','18:59:52','PLG0009835','10175000','10175000','0','10175000','0','kasir','2026-03-07 18:59:51','FJ-260307-0023','DP-01724','7560000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0023','2026-03-07','18:59:52','NISA','10175000','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-260307-0023','2026-03-07','2026-03-07 18:59:51','PENJUALAN : FJ-260307-0023','.','TBC','2615000','2615000','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-260307-0024','D','2026-03-07','18:59:52','TBC','PENJUALAN','FJ-260307-0023','20847653514','2615000','20850268514','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='2615000' WHERE no_faktur_jual='FJ-260307-0023' 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-260307-0024','kasir',' 1',' DP-01725MM','TOKO','MMPSN','PSPLT-ZBBG-53-0','CINCIN PALADIUM ','','4.150','1','32.00','1754000','0','0','17000','2775000','0','0','0','2775000','NISA','00042055','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZBBG-53-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.150',berat_jual_asli=berat_jual_asli+'4.150',stock_jual='1',berat_akhir=berat_akhir-'4.150',berat_akhir_asli=berat_akhir_asli-'4.150',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PSPLT-ZBBG-53-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260307-0024','2026-03-07','4.150','2026-03-07','18:59:52','PLG0009836','2775000','2775000','0','2775000','0','kasir','2026-03-07 18:59:51','FJ-260307-0023','DP-01725','2080000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0024','2026-03-07','18:59:52','NISA','2775000','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-260307-0024','2026-03-07','2026-03-07 18:59:51','PENJUALAN : FJ-260307-0024','.','TBC','695000','695000','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-260307-0025','D','2026-03-07','18:59:52','TBC','PENJUALAN','FJ-260307-0024','20850268514','695000','20850963514','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='3310000' WHERE no_faktur_jual='FJ-260307-0024' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0023' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0023' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0023'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0024' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0024' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0024'; 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-260307-0025','kasirbip','1',' DP-01712BI','TOKO','BIPPSN','PSPLT-ZCXC-37-0','CINCIN PALADIUM ','','3.080','1','32.00','1302000','0','0','17000','2040000','0','0','0','2040000','SULIS','00042180','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZCXC-37-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.080',berat_jual_asli=berat_jual_asli+'3.080',stock_jual='1',berat_akhir=berat_akhir-'3.080',berat_akhir_asli=berat_akhir_asli-'3.080',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PSPLT-ZCXC-37-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-260307-0025','2026-03-07','3.080','2026-03-07','20:25:39','PLG0009837','2040000','2040000','0','2040000','0','kasirbip','2026-03-07 20:25:38','FJ-260307-0025','DP-01712','1150000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0025','2026-03-07','20:25:39','SULIS','2040000','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-260307-0025','2026-03-07','2026-03-07 20:25:38','PENJUALAN : FJ-260307-0025','.','TBC','890000','890000','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-260307-0026','D','2026-03-07','20:25:39','TBC','PENJUALAN','FJ-260307-0025','20850963514','890000','20851853514','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='890000' WHERE no_faktur_jual='FJ-260307-0025' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260307-0026','kasirbip','1',' 850K-13-12','TOKO','BIPPER','PBDG-YFXD-34-0','CINCIN SILVER 925 ','','1.810','1','100.00','42000','0','0','17000','950000','0','0','0','950000','MIA','00036124','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YFXD-34-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.810',berat_jual_asli=berat_jual_asli+'1.810',stock_jual='1',berat_akhir=berat_akhir-'1.810',berat_akhir_asli=berat_akhir_asli-'1.810',stock_akhir='0' WHERE tanggal='2026-03-07' AND kode_barang='PBDG-YFXD-34-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-260307-0026','2026-03-07','1.810','2026-03-07','20:30:09','PLG0009838','950000','950000','0','950000','0','kasirbip','2026-03-07 20:30:08','FJ-260307-0026','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0026','2026-03-07','20:30:09','MIA','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-260307-0026','2026-03-07','2026-03-07 20:30:08','PENJUALAN : FJ-260307-0026','.','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-260307-0027','D','2026-03-07','20:30:09','TBC','PENJUALAN','FJ-260307-0026','20851853514','950000','20852803514','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-260307-0026' 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-260307-0027','kasirbip',' 1',' 700K-13-22','TOKO','BIPPER','PBDG-ZBXF-46-0','CINCIN SILVER 925 ','','2.440','1','100.00','249000','0','0','17000','800000','0','0','0','800000','MIA','00041398','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBXF-46-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='2026-03-07' AND kode_barang='PBDG-ZBXF-46-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-260307-0027','2026-03-07','2.440','2026-03-07','20:30:09','PLG0009839','800000','800000','0','800000','0','kasirbip','2026-03-07 20:30:08','FJ-260307-0026','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-07','FJ-260307-0027','2026-03-07','20:30:09','MIA','800000','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-260307-0027','2026-03-07','2026-03-07 20:30:08','PENJUALAN : FJ-260307-0027','.','TBC','800000','800000','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-260307-0028','D','2026-03-07','20:30:09','TBC','PENJUALAN','FJ-260307-0027','20852803514','800000','20853603514','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='1750000' WHERE no_faktur_jual='FJ-260307-0027' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0025' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0025' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0025'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0026' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0026' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0026'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0027' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260307-0027' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260307-0027'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-07 ','21:07:29');