INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-03 ','08:32:06');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-03','122','0','-160900000','122','0','-160900000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-03';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-02';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-02';
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-09-02' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-02';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-02';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-02';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-02';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-03' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-02' 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-260903-0001','D','2026-09-03','08:32:17','','SALDO AWAL','SALDO AWAL','0','0','0');
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-260903-0001','D','2026-09-03','08:32:17','BCA','SALDO AWAL','SALDO AWAL','0','2052763713','2052763713');
UPDATE tp_system SET tgl_system='2026-09-03';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-03 ','08:39:26');
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260903-0001','1','X-00009778','BELI','BELI001','GL CAP HOLO 17CM KKT PER SHB','1','4.870','4648000.00' ,'0.00','4648000','','4648000','4648000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-03 08:39:53' WHERE kode_barang='X-00009778' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009778' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009778' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'4.870',berat_hancur_asli=berat_hancur_asli+'4.870', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'4.870',berat_akhir_asli=berat_akhir_asli-'4.870' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDGL' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260903-0001','2','X-00009779','BELI','BELI001','GL CAP HOLO 17CM KKT PER SHB','1','3.760','2632000.00' ,'0.00','2632000','','2632000','11928000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-03 08:39:53' WHERE kode_barang='X-00009779' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009779' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009779' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'3.760',berat_hancur_asli=berat_hancur_asli+'3.760', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'3.760',berat_akhir_asli=berat_akhir_asli-'3.760' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDGL' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260903-0001','3','X-00009780','BELI','BELI001','CN COR BT SHB','1','0.880','1424500.00' ,'0.00','1424500','','1424500','15984500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-03 08:39:53' WHERE kode_barang='X-00009780' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009780' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009780' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.880',berat_hancur_asli=berat_hancur_asli+'0.880', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260903-0001','4','X-00009781','BELI','BELI001','LT COR FORTUNE LC2','1','8.870','8466000.00' ,'0.00','8466000','','8466000','25875000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-03 08:39:53' WHERE kode_barang='X-00009781' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009781' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009781' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'8.870',berat_hancur_asli=berat_hancur_asli+'8.870', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'8.870',berat_akhir_asli=berat_akhir_asli-'8.870' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDLT' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_head(no_waste,sales_id,tgl_system,tgl_waste,jam_Waste,jml_beli_waste_rp,jml_jual_waste_rp,input_by,input_date) VALUES ('BS-260903-0001','adminpusat','2026-09-03','2026-09-03','08:39:54','17170500','25875000', 'adminpusat','2026-09-03 08:39:53');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-03 ','08:46:28');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-03 ','09:35:06');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-09-03 ','09:56:27');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-03 ','10:12:40');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260903-0001','sales','1',' EX ','TOKO','BTCNMD','MDCN-ZDAX-45-0','CN COR EROPA SHB ','','3.400','1','100.00','3774000','0','0','0','3774000','0','0','0','3774000','2501','00029075','MDCN','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZDAX-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.400',berat_jual_asli=berat_jual_asli+'3.400',stock_jual='1',berat_akhir=berat_akhir-'3.400',berat_akhir_asli=berat_akhir_asli-'3.400',stock_akhir='0' WHERE tanggal='2026-09-03' AND kode_barang='MDCN-ZDAX-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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) VALUES ('FJ-260903-0001','2026-09-03','3.400','2026-09-03','10:16:23','PLG0019409','3774000','3774000','0','3774000','3774000','sales','2026-09-03 10:16:21','FJ-260903-0001');
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-09-03','FJ-260903-0001','2026-09-03','10:16:23','2501','3774000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260903-0002','D','2026-09-03','10:16:23','sales','PENJUALAN','FJ-260903-0001','110292110','3774000','114066110');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260903-0001';
INSERT INTO tm_credit_card(id_card,nama_customer,no_ktp,alamat1,alamat2,kota,no_telp,tgl_daftar,tgl_valid_until,tgl_last_gesek) VALUES ('6019005047541532','BCA','', ' ' , ' ' , ' ' ,'','2026-09-03 10:21:48','','2026-09-03 10:21:48');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260903-0002','sales','1',' EX ','TOKO','BTCNMT','MTCN-ZFAE-17-0','CN COR TDK BT SMBR PTH BG3 ','','1.860','1','100.00','3422500','0','0','0','3422500','0','0','0','3422500','2103','00030276','MTCN','221000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZFAE-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.860',berat_jual_asli=berat_jual_asli+'1.860',stock_jual='1',berat_akhir=berat_akhir-'1.860',berat_akhir_asli=berat_akhir_asli-'1.860',stock_akhir='0' WHERE tanggal='2026-09-03' AND kode_barang='MTCN-ZFAE-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMT' 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) VALUES ('FJ-260903-0002','2026-09-03','1.860','2026-09-03','10:21:54','PLG0019410','3422500','3422500','0','3422500','22500','sales','2026-09-03 10:21:52','FJ-260903-0002');
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-09-03','FJ-260903-0002','2026-09-03','10:21:54','2103','3422500','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260903-0003','D','2026-09-03','10:21:54','sales','PENJUALAN','FJ-260903-0002','114066110','22500','114088610','OPEN');
INSERT INTO tt_debet(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,debet_rp,debet_fee_rp) VALUES ('DC-260903-0001','2026-09-03','2026-09-03 10:21:52','PENJUALAN : FJ-260903-0002','6019005047541532','BCA','3400000','3400000','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-260903-0002','D','2026-09-03','10:21:54','BCA','PENJUALAN','FJ-260903-0002','2052763713','3400000','2056163713','DEBET');
UPDATE tt_jual_head SET dibayar_rp='22500',debet_rp='3400000',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260903-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260903-0002';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260903-0003','sales','1',' ','TOKO','BTCNMD','MDCN-ZBXF-145-0','CN COR TDK BT SHB ','','2.000','1','100.00','2220000','0','0','0','2220000','0','0','0','2220000','2602','00027791','MDCN','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZBXF-145-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-09-03' AND kode_barang='MDCN-ZBXF-145-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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) VALUES ('FJ-260903-0003','2026-09-03','2.000','2026-09-03','10:28:41','PLG0019411','2220000','2220000','0','2220000','2220000','sales','2026-09-03 10:28:41','FJ-260903-0003');
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-09-03','FJ-260903-0003','2026-09-03','10:28:41','2602','2220000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260903-0004','D','2026-09-03','10:28:41','sales','PENJUALAN','FJ-260903-0003','114088610','2220000','116308610');
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01847','2402','1','CN COR DAUN SSN MT','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'1000000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'1000000'  WHERE tanggal='2026-09-03'
INSERT INTO tt_hutang_head (no_hutang,tgl_system,tgl_hutang,jam_hutang,kode_customer,sales_id,lama_hari,tgl_jth_tmp,input_by,input_date,berat,jml_awal_rp,bunga_persen,bunga_rp,jml_akhir_rp,sld_akhir_rp,status,berat_plus,qty,tgl_lunas,byr_harus_rp,kembali_rp)VALUES('PI26-01847','2026-09-03','2026-09-03','10:30:44','PLG0019412','2402','90','2026-12-02','sales','2026-09-03 10:30:43','1.250','1000000','3.00','90000','1090000','0','OPEN','11.92','1','2026-12-02','0','1090000')
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260903-0005','K','2026-09-03','10:30:44','sales','HUTANG','PI26-01847','116308610','1000000','115308610','OPEN') 
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260903-0003';
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01847' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01847';
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01848','2402','1','LT COR FORTUNE CAT LC2 SRT 1LBR','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'2000000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'2000000'  WHERE tanggal='2026-09-03'
INSERT INTO tt_hutang_head (no_hutang,tgl_system,tgl_hutang,jam_hutang,kode_customer,sales_id,lama_hari,tgl_jth_tmp,input_by,input_date,berat,jml_awal_rp,bunga_persen,bunga_rp,jml_akhir_rp,sld_akhir_rp,status,berat_plus,qty,tgl_lunas,byr_harus_rp,kembali_rp)VALUES('PI26-01848','2026-09-03','2026-09-03','10:49:10','PLG0019413','2402','90','2026-12-02','sales','2026-09-03 10:49:10','5.040','2000000','3.00','180000','2180000','0','OPEN','16.21','1','2026-12-02','0','2180000')
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260903-0006','K','2026-09-03','10:49:10','sales','HUTANG','PI26-01848','115308610','2000000','113308610','OPEN') 
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01848' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01848';
UPDATE tt_titip_detail SET harga_jual ='1720500' ,ongkos_detail ='0',berat ='1.55',jml_Detail_rp ='1720500' WHERE no_titip= 'TU-260829-0001' AND no_urut*1 ='1'
DELETE FROM tt_jual_detail WHERE kode_barang='MSKL-ZBBX-109-0' LIMIT 1
DELETE FROM tt_jual_detail WHERE kode_barcode='00028657' LIMIT 1
INSERT INTO tm_barang SELECT * FROM tm_barang_titip WHERE kode_barcode='00028657' LIMIT 1
DELETE FROM tm_barang_titip WHERE kode_barcode='00028657' LIMIT 1
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli ) VALUES ('2026-09-03','TOKO','BTKLMS','MSKL','MSKL-ZBBX-109-0','0','1','1.55','1.54', '1','1.55','1.54');
UPDATE tt_barang_saldo SET stock_out= stock_out+'1' ,berat_out=berat_out+'1.55',berat_out_asli=berat_out_asli+'1.54', stock_akhir=stock_akhir-'1',berat_akhir =berat_akhir-'1.55',berat_akhir_asli =berat_akhir_asli-'1.54' WHERE tanggal='2026-09-03' AND kode_barang='MSKL-ZBBX-109-0' AND kode_lokasi_gudang='TITIP' AND kode_lokasi_toko='TITIP' AND stock_akhir*1 > 0 LIMIT 1;
INSERT INTO tt_jual_detail (no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,harga_beli,harga_jual,ongkos_detail,dpp_detail,sales_id,kode_barcode,kode_dept,berlian_usd,berlian_rp,ongkos_berlian,diskon,harga_atribut) VALUES ('FT-260903-0004', 'cashier1', '1','MR ','TOKO','BTKLMS', 'MSKL-ZBBX-109-0','KL ANK KOREA 33CM KKT PER UBS ','MR )','1.55','1','1720500', '1720500', '0','1720500','2501','00028657','MSKL','0','0','0','0','117000')
UPDATE tt_barang_saldo SET stock_jual= stock_jual+ '1' ,berat_jual=berat_jual+'1.55',berat_jual_asli=berat_jual_asli+'1.54', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.55',berat_akhir_asli =berat_akhir_asli-'1.54' WHERE tanggal='2026-09-03' AND kode_barang='MSKL-ZBBX-109-0' AND kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko = 'BTKLMS' AND stock_akhir*1 > 0
UPDATE tm_barang SET tgl_last_jual='2026-09-03 12:11:17', stock_on_hand=0 WHERE kode_barang='MSKL-ZBBX-109-0'
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,debet_rp,card_rp,transfer_rp,input_by,input_date,no_faktur_group,no_faktur_titip,status_valid) VALUES ('FT-260903-0004','2026-09-03','1.55', '2026-09-03','12:11:17','PLG0019390','1720500','1720500', '0','1720500','1337500','0','','0','cashier1','2026-09-03 12:11:17','FT-260903-0004','TU-260829-0001','OPEN')
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-09-03','FT-260903-0004','2026-09-03','12:11:17','2501', '1720500','0')
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260903-0007','D','2026-09-03','12:11:17','cashier1','AMBIL TITIPAN','TU-260829-0001','113308610','1337500','114646110','DONE') 
UPDATE tt_jual_head SET dibayar_rp='1337500',debet_rp='0',card_rp='',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FT-260903-0004' LIMIT 1
UPDATE tt_titip_head SET Tgl_ambil='2026-09-03',  dibayar_rp = dibayar_rp + '1337500', card_rp = card_rp + '0', debet_rp = debet_rp + '0', transfer_rp = transfer_rp + '0',card_fee_rp = card_fee_rp + '0', sld_akhir_rp = sld_akhir_rp - '1337500 + 0 + 0 + 0', status ='CLOS'  WHERE no_titip ='TU-260829-0001'
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-03 ','12:11:36');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FT-260903-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FT-260903-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FT-260903-0004';
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='TU-260829-0001' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-03 ','12:29:59');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-03 ','12:59:59');
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) VALUES ('FJ-260903-0005','sales','1',' EX ','TOKO','BTGWMT','MTGW-ZBBC-13-0','GW COR DB MHL SHB ','','2.390','1','100.00','4398000','0','0','0','4398000','0','0','0','4398000','2403','00028755','MTGW','221000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGW-ZBBC-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.390',berat_jual_asli=berat_jual_asli+'2.390',stock_jual='1',berat_akhir=berat_akhir-'2.390',berat_akhir_asli=berat_akhir_asli-'2.390',stock_akhir='0' WHERE tanggal='2026-09-03' AND kode_barang='MTGW-ZBBC-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGWMT' 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) VALUES ('FJ-260903-0005','2026-09-03','2.390','2026-09-03','13:11:38','PLG0019414','4398000','4398000','0','4398000','0','sales','2026-09-03 13:11:38','FJ-260903-0005');
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-09-03','FJ-260903-0005','2026-09-03','13:11:38','2403','4398000','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-260903-0001','2026-09-03','2026-09-03 13:11:38','PENJUALAN : FJ-260903-0005','bca','BCA','4398000','4398000','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-260903-0003','D','2026-09-03','13:11:38','BCA','PENJUALAN','FJ-260903-0005','2056163713','4398000','2060561713','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','AMIR SYARIFUDDIN');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='4398000' WHERE no_faktur_jual='FJ-260903-0005' 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) VALUES ('FJ-260903-0006','sales',' 1',' EX ','TOKO','BTGLMT','MTGL-ZEXD-29-0','GL PIPA TDK BT SHB ','','10.720','1','100.00','19725000','0','0','0','19725000','0','0','0','19725000','2403','00029397','MTGL','221000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGL-ZEXD-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'10.720',berat_jual_asli=berat_jual_asli+'10.720',stock_jual='1',berat_akhir=berat_akhir-'10.720',berat_akhir_asli=berat_akhir_asli-'10.720',stock_akhir='0' WHERE tanggal='2026-09-03' AND kode_barang='MTGL-ZEXD-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMT' 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) VALUES ('FJ-260903-0006','2026-09-03','10.720','2026-09-03','13:11:38','PLG0019415','19725000','19725000','0','19725000','0','sales','2026-09-03 13:11:38','FJ-260903-0005');
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-09-03','FJ-260903-0006','2026-09-03','13:11:38','2403','19725000','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-260903-0002','2026-09-03','2026-09-03 13:11:38','PENJUALAN : FJ-260903-0006','bca','BCA','19725000','19725000','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-260903-0004','D','2026-09-03','13:11:38','BCA','PENJUALAN','FJ-260903-0006','2060561713','19725000','2080286713','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','AMIR SYARIFUDDIN');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='19725000' WHERE no_faktur_jual='FJ-260903-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) VALUES ('FJ-260903-0007','sales',' 1',' EX ','TOKO','BTGLMD','MDGL-ZFXH-9-0','GL BANGKOK TMBL UBS ','','8.230','1','100.00','9135500','0','0','0','9135500','0','0','0','9135500','2403','00030044','MDGL','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZFXH-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'8.230',berat_jual_asli=berat_jual_asli+'8.230',stock_jual='1',berat_akhir=berat_akhir-'8.230',berat_akhir_asli=berat_akhir_asli-'8.230',stock_akhir='0' WHERE tanggal='2026-09-03' AND kode_barang='MDGL-ZFXH-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' 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) VALUES ('FJ-260903-0007','2026-09-03','8.230','2026-09-03','13:11:38','PLG0019416','9135500','9135500','0','9135500','0','sales','2026-09-03 13:11:38','FJ-260903-0005');
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-09-03','FJ-260903-0007','2026-09-03','13:11:38','2403','9135500','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-260903-0003','2026-09-03','2026-09-03 13:11:38','PENJUALAN : FJ-260903-0007','bca','BCA','9135500','9135500','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-260903-0005','D','2026-09-03','13:11:38','BCA','PENJUALAN','FJ-260903-0007','2080286713','9135500','2089422213','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','AMIR SYARIFUDDIN');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='9135500' WHERE no_faktur_jual='FJ-260903-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) VALUES ('FJ-260903-0008','sales',' 1',' EX ','TOKO','BTGLMD','MDGL-ZFXH-7-0','GL BANGKOK TMBL UBS ','','8.000','1','100.00','8880000','0','0','0','8880000','0','0','0','8880000','2403','00030042','MDGL','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZFXH-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'8.000',berat_jual_asli=berat_jual_asli+'8.000',stock_jual='1',berat_akhir=berat_akhir-'8.000',berat_akhir_asli=berat_akhir_asli-'8.000',stock_akhir='0' WHERE tanggal='2026-09-03' AND kode_barang='MDGL-ZFXH-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' 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) VALUES ('FJ-260903-0008','2026-09-03','8.000','2026-09-03','13:11:38','PLG0019417','8880000','8880000','0','8880000','0','sales','2026-09-03 13:11:38','FJ-260903-0005');
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-09-03','FJ-260903-0008','2026-09-03','13:11:38','2403','8880000','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-260903-0004','2026-09-03','2026-09-03 13:11:38','PENJUALAN : FJ-260903-0008','bca','BCA','8880000','8880000','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-260903-0006','D','2026-09-03','13:11:38','BCA','PENJUALAN','FJ-260903-0008','2089422213','8880000','2098302213','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','AMIR SYARIFUDDIN');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='8880000' WHERE no_faktur_jual='FJ-260903-0008' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260903-0009','sales',' 1',' EX ','TOKO','BTGLMD','MDGL-ZFXH-8-0','GL BANGKOK TMBL UBS ','','7.960','1','100.00','8836000','0','0','0','8836000','0','0','0','8836000','2403','00030043','MDGL','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZFXH-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'7.960',berat_jual_asli=berat_jual_asli+'7.960',stock_jual='1',berat_akhir=berat_akhir-'7.960',berat_akhir_asli=berat_akhir_asli-'7.960',stock_akhir='0' WHERE tanggal='2026-09-03' AND kode_barang='MDGL-ZFXH-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' 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) VALUES ('FJ-260903-0009','2026-09-03','7.960','2026-09-03','13:11:38','PLG0019418','8836000','8836000','0','8836000','0','sales','2026-09-03 13:11:38','FJ-260903-0005');
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-09-03','FJ-260903-0009','2026-09-03','13:11:38','2403','8836000','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-260903-0005','2026-09-03','2026-09-03 13:11:38','PENJUALAN : FJ-260903-0009','bca','BCA','8836000','8836000','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-260903-0007','D','2026-09-03','13:11:38','BCA','PENJUALAN','FJ-260903-0009','2098302213','8836000','2107138213','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','AMIR SYARIFUDDIN');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='8836000' WHERE no_faktur_jual='FJ-260903-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) VALUES ('FJ-260903-0010','sales',' 1',' EX ','TOKO','BTKLMD','MDKL-ZEAI-60-0','KL SATELIT PJG 60CM KKT PER UBS ','','16.030','1','100.00','17793500','0','0','0','17793500','0','0','0','17793500','2403','00029702','MDKL','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDKL-ZEAI-60-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'16.030',berat_jual_asli=berat_jual_asli+'16.030',stock_jual='1',berat_akhir=berat_akhir-'16.030',berat_akhir_asli=berat_akhir_asli-'16.030',stock_akhir='0' WHERE tanggal='2026-09-03' AND kode_barang='MDKL-ZEAI-60-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMD' 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) VALUES ('FJ-260903-0010','2026-09-03','16.030','2026-09-03','13:11:38','PLG0019419','17793500','17793500','0','17793500','0','sales','2026-09-03 13:11:38','FJ-260903-0005');
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-09-03','FJ-260903-0010','2026-09-03','13:11:38','2403','17793500','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-260903-0006','2026-09-03','2026-09-03 13:11:38','PENJUALAN : FJ-260903-0010','bca','BCA','17793500','17793500','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-260903-0008','D','2026-09-03','13:11:38','BCA','PENJUALAN','FJ-260903-0010','2107138213','17793500','2124931713','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','AMIR SYARIFUDDIN');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='17793500' WHERE no_faktur_jual='FJ-260903-0010' 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) VALUES ('FJ-260903-0011','sales',' 1',' EX ','TOKO','BTLTMD','MDLT-ZHBI-36-0','LT COR DOLLAR LC2 ','','2.310','1','100.00','2564500','0','0','0','2564500','0','0','0','2564500','2403','00031208','MDLT','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDLT-ZHBI-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.310',berat_jual_asli=berat_jual_asli+'2.310',stock_jual='1',berat_akhir=berat_akhir-'2.310',berat_akhir_asli=berat_akhir_asli-'2.310',stock_akhir='0' WHERE tanggal='2026-09-03' AND kode_barang='MDLT-ZHBI-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTLTMD' 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) VALUES ('FJ-260903-0011','2026-09-03','2.310','2026-09-03','13:11:38','PLG0019420','2564500','2564500','0','2564500','0','sales','2026-09-03 13:11:38','FJ-260903-0005');
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-09-03','FJ-260903-0011','2026-09-03','13:11:38','2403','2564500','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-260903-0007','2026-09-03','2026-09-03 13:11:38','PENJUALAN : FJ-260903-0011','bca','BCA','2564500','2564500','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-260903-0009','D','2026-09-03','13:11:38','BCA','PENJUALAN','FJ-260903-0011','2124931713','2564500','2127496213','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','AMIR SYARIFUDDIN');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2564500' WHERE no_faktur_jual='FJ-260903-0011' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260903-0012','sales',' 1',' EX ','TOKO','BTCNMT','MTCN-ZFAE-37-0','CN CAP PLT TDK BT MK ','','1.900','1','100.00','3496000','0','0','0','3496000','0','0','0','3496000','2403','00030296','MTCN','221000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZFAE-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2026-09-03' AND kode_barang='MTCN-ZFAE-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMT' 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) VALUES ('FJ-260903-0012','2026-09-03','1.900','2026-09-03','13:11:38','PLG0019421','3496000','3496000','0','3496000','0','sales','2026-09-03 13:11:38','FJ-260903-0005');
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-09-03','FJ-260903-0012','2026-09-03','13:11:38','2403','3496000','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-260903-0008','2026-09-03','2026-09-03 13:11:38','PENJUALAN : FJ-260903-0012','bca','BCA','3496000','3496000','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-260903-0010','D','2026-09-03','13:11:38','BCA','PENJUALAN','FJ-260903-0012','2127496213','3496000','2130992213','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','AMIR SYARIFUDDIN');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3496000' WHERE no_faktur_jual='FJ-260903-0012' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009782','X-00009782','KL FANCY ANAK VAR CAT 35CM KKT PER UBS','GR','---','MDKL','BELI','BELI001','1551000','2026-09-03','1.890','1','sales','2026-09-03 13:15:16');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDKL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDKL','X-00009782','X-00009782');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260903-0001','FJ-221130-0012','2402','1','BELI','BELI001','MDKL', 'X-00009782', 'KL FANCY ANAK VAR CAT 35CM KKT PER UBS','1.970','1.890','100.00','879000','1551000','820635','1','1551000','1551000','RUSAK BIASA');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-03','BELI','BELI001','MDKL','MDKL','100.00','1.890','1.890','1','1.890','1.890','1');
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260903-0001','2026-09-03','2026-09-03','13:15:15','2402','---','1.890','1551000','1551000','1551000','1551000','1551000','sales','2026-09-03 13:15:16','FB-260903-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260903-0001','HARISATUL MAULA','SRENGGANAN DLM 2/4','','','081330027593','sales','2026-09-03 13:15:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-03' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260903-0008','K','2026-09-03','13:15:15','sales','PEMBELIAN UMUM','FB-260903-0001','114646110','1551000','113095110','OPEN');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260903-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260903-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260903-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260903-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260903-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260903-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260903-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260903-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260903-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260903-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260903-0001';
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01849','2502','1','KL RT HOLO KKT PER UBS8K SRT 1LBR','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'1000000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'1000000'  WHERE tanggal='2026-09-03'
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01849','2502','2','LT HURUF S BT AD PNH LG375 SRT 1LBR','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'1000000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'1000000'  WHERE tanggal='2026-09-03'
INSERT INTO tt_hutang_head (no_hutang,tgl_system,tgl_hutang,jam_hutang,kode_customer,sales_id,lama_hari,tgl_jth_tmp,input_by,input_date,berat,jml_awal_rp,bunga_persen,bunga_rp,jml_akhir_rp,sld_akhir_rp,status,berat_plus,qty,tgl_lunas,byr_harus_rp,kembali_rp)VALUES('PI26-01849','2026-09-03','2026-09-03','13:33:42','PLG0019422','2502','90','2026-12-02','sales','2026-09-03 13:33:41','3.090','1000000','3.00','90000','1090000','0','OPEN','9.38','2','2026-12-02','0','1090000')
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260903-0009','K','2026-09-03','13:33:42','sales','HUTANG','PI26-01849','113095110','1000000','112095110','OPEN') 
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01849' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01849';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-03 ','14:21:13');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-09-03 ','14:22:37');
UPDATE tm_barang SET stock_on_hand='1' WHERE kode_barang='MSKL-ZBBX-109-0' AND kode_lokasi_toko='BTKLMS' LIMIT 1;
UPDATE tt_jual_sales SET jml_jual_rp =jml_jual_rp-'1720500',ongkos_rp=ongkos_rp-'0' WHERE no_faktur_jual ='FT-260903-0004';
UPDATE tt_jual_head SET status_return = 'CLOS' WHERE no_faktur_jual ='FT-260903-0004';
UPDATE tt_barang_tukar SET status='CLOS' WHERE no_faktur_group='FT-260903-0004';
UPDATE tt_voucher_customer SET status='OPEN' WHERE no_voucher='-'
UPDATE tt_barang_saldo SET stock_jual=stock_jual-1, berat_jual = berat_jual-'1.55',berat_jual_asli = berat_jual_asli-'1.54', stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.55',berat_akhir_asli=berat_akhir_asli+'1.54' WHERE tanggal ='2026-09-03' AND kode_lokasi_toko ='BTKLMS' AND kode_barang='MSKL-ZBBX-109-0' AND stock_jual*1 > 0 LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260903-0010','K','2026-09-03','14:25:12','cashier1','BATAL PENJUALAN','BJ-260903-0001','112095110','1337500','110757610');
INSERT INTO tt_jual_retur_detail(no_retur_jual,no_urut,no_faktur_jual,kode_barang,nama_barang,berat,harga,ongkos,jml_detail,kode_lokasi_toko,kode_dept,kadar,sales_id,alasan,harga_atribut) VALUES ('BJ-260903-0001','1','FT-260903-0004','MSKL-ZBBX-109-0','KL ANK KOREA 33CM KKT PER UBS ','1.55','1720500.00','0','1720500','BTKLMS','MSKL','100.00','cashier1','RETUR BARANG','117000');
DELETE FROM tt_jual_head WHERE no_faktur_jual ='FT-260903-0004' LIMIT 1;
DELETE FROM tt_jual_detail WHERE no_faktur_jual ='FT-260903-0004' LIMIT 1;
DELETE FROM tt_jual_sales WHERE no_faktur_jual ='FT-260903-0004' LIMIT 1;
INSERT INTO tt_jual_retur_head(no_retur_jual,tgl_system,tgl_retur_jual,kode_customer,dpp_netto_rp,jml_retur_rp,input_by,input_date)VALUES('BJ-260903-0001','2026-09-03','2026-09-03','PLG0019390','1720500','1720500','cashier1','2026-09-03 14:25:12');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-09-03 ','14:33:12');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-03 ','15:05:19');
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) VALUES ('FJ-260903-0005','cashier1','1',' MR ','TOKO','BTKLMS','MSKL-ZBBX-109-0','KL ANK KOREA 33CM KKT PER UBS ','MR','1.550','1','100.00','1720500','0','0','0','1837500','117000','0','0','1837500','2501','00028657','MSKL','155500','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) VALUES ('FJ-260903-0005','cashier1','1',' MR ','TOKO','BTKLMS','MSKL-ZBBX-109-0','KL ANK KOREA 33CM KKT PER UBS ','MR','1.550','1','100.00','1720500','0','0','0','1837500','117000','0','0','1837500','2501','00028657','MSKL','155500','0','-','0');
UPDATE tt_hutang_head SET byr_harus_rp='5000000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'5110000',tgl_lunas='2026-09-03',status='CLOS',total_lunas='5110000' WHERE no_hutang='PI26-01828';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'2',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'5000000',qty_akhir=qty_akhir-'2',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'5000000'  WHERE tanggal='2026-09-03';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'5000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'5000000'  WHERE tanggal='2026-09-03';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'5000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'5000000'  WHERE tanggal='2026-09-03';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260903-0011','D','2026-09-03','15:15:39','cashier1','HUTANG LUNAS','PI26-01828','110757610','5110000','115867610');
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) VALUES ('FJ-260903-0005','cashier1','1',' MR ','TOKO','BTKLMS','MSKL-ZBBX-109-0','KL ANK KOREA 33CM KKT PER UBS ','MR','1.550','1','100.00','1720500','0','0','0','1837500','117000','0','0','1837500','2501','00028657','MSKL','155500','0','-','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-09-03 ','15:34:00');
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) VALUES ('FJ-260903-0005','Nagatech','1',' MR ','TOKO','BTKLMS','MSKL-ZBBX-109-0','KL ANK KOREA 33CM KKT PER UBS ','MR','1.550','1','100.00','1720500','0','0','0','1837500','117000','0','0','1837500','2501','00028657','MSKL','155500','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) VALUES ('FJ-260903-0005','Nagatech','1',' MR ','TOKO','BTKLMS','MSKL-ZBBX-109-0','KL ANK KOREA 33CM KKT PER UBS ','MR','1.550','1','100.00','1720500','0','0','0','1837500','117000','0','0','1837500','001','00028657','MSKL','155500','0','-','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-03 ','15:48:11');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-03 ','16:03:34');