INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-08-16 ','08:23:38');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-08-16','93','0','-274750000','93','0','-274750000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-07-16';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-15';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-15';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-08-15' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-15';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-15';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-15';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-15';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202507 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
UPDATE tt_barang_saldo SET tanggal= '2025-08-16' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-15' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250816-0001','D','2025-08-16','08:23:46','BCA','SALDO AWAL','SALDO AWAL','0','1282982418','1282982418');
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-250816-0001','D','2025-08-16','08:23:46','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-08-16';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-08-16 ','08:23:59');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2025-08-16 ','08:26:24');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-16 ','08:41:38');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-16 ','08:44:09');
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-250816-0001','1','X-00008684','BELI','BELI001','CN COR BT MK','1','1.110','768500.00' ,'0.00','768500','','768500','768500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2025-08-16 08:47:58' WHERE kode_barang='X-00008684' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00008684' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00008684' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.110',berat_hancur_asli=berat_hancur_asli+'1.110', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' 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-250816-0001','2','X-00008685','BELI','BELI001','KL ITALY ST VC BT 42CM KKT PER MK','1','2.760','1911000.00' ,'0.00','1911000','','1911000','3448000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2025-08-16 08:47:58' WHERE kode_barang='X-00008685' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00008685' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00008685' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.760',berat_hancur_asli=berat_hancur_asli+'2.760', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.760',berat_akhir_asli=berat_akhir_asli-'2.760' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDKL' 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-250816-0001','3','X-00008686','BELI','BELI001','GL COR KRAWANG SHB','1','5.220','6224500.00' ,'0.00','6224500','','6224500','11583500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2025-08-16 08:47:58' WHERE kode_barang='X-00008686' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00008686' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00008686' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'5.220',berat_hancur_asli=berat_hancur_asli+'5.220', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'5.220',berat_akhir_asli=berat_akhir_asli-'5.220' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTGL' 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-250816-0001','adminpusat','2025-08-16','2025-08-16','08:47:59','8904000','11583500', 'adminpusat','2025-08-16 08:47:58');
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-00008687','X-00008687','AT ITALY KUPU2 TDK BT SHB','GR','---','MTAT','BELI','BELI001','1397000','2025-08-16','1.370','1','sales','2025-08-16 09:29:16');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTAT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTAT','X-00008687','X-00008687');
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-250816-0001','FJ-220707-0017','2403','1','BELI','BELI001','MTAT', 'X-00008687', 'AT ITALY KUPU2 TDK BT SHB','1.390','1.370','100.00','965000','1397000','1019708','1','1397000','1397000','RONGSOK');
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 ('2025-08-16','BELI','BELI001','MTAT','MTAT','100.00','1.370','1.370','1','1.370','1.370','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-250816-0001','2025-08-16','2025-08-16','09:29:15','2403','---','1.370','1397000','1397000','1397000','1397000','1397000','sales','2025-08-16 09:29:16','FB-250816-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250816-0001','CHOLIFAH','KALIANYAR WETAN 4/19','','','','sales','2025-08-16 09:29:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-16' 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-250816-0002','K','2025-08-16','09:29:15','sales','PEMBELIAN UMUM','FB-250816-0001','176558927','1397000','175161927','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250816-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250816-0001';
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-00008688','X-00008688','GL CAP HOLO 16CM KKT PER SHB','GR','---','MDGL','BELI','BELI001','3718500','2025-08-16','5.370','1','sales','2025-08-16 09:43:46');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDGL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDGL','X-00008688','X-00008688');
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-250816-0002','FJ-250317-0014','2106','1','BELI','BELI001','MDGL', 'X-00008688', 'GL CAP HOLO 16CM KKT PER SHB','5.370','5.370','100.00','3934000','3718500','692458','1','3718500','3718500','MULUS');
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 ('2025-08-16','BELI','BELI001','MDGL','MDGL','100.00','5.370','5.370','1','5.370','5.370','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-250816-0002','2025-08-16','2025-08-16','09:43:45','2106','---','5.370','3718500','3718500','3718500','3718500','3718500','sales','2025-08-16 09:43:46','FB-250816-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250816-0002','LILIK','DUKUH BULAK BANTENG SKLHN 10A/4','','SBY','087862034806','sales','2025-08-16 09:43:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-16' 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-250816-0003','K','2025-08-16','09:43:45','sales','PEMBELIAN UMUM','FB-250816-0002','175161927','3718500','171443427','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250816-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250816-0002';
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-00008689','X-00008689','GL CAP HOLO 17CM SHB','GR','---','MDGL','BELI','BELI001','7278000','2025-08-16','10.510','1','sales','2025-08-16 10:26:46');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDGL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDGL','X-00008689','X-00008689');
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-250816-0003','FJ-250323-0011','2501','1','BELI','BELI001','MDGL', 'X-00008689', 'GL CAP HOLO 17CM SHB','10.510','10.510','100.00','7856500','7278000','692483','1','7278000','7278000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'10.510',berat_beli_asli=berat_beli_asli+'10.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'10.510',berat_akhir_asli=berat_akhir_asli+'10.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDGL' LIMIT 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-250816-0003','2025-08-16','2025-08-16','10:26:46','2501','---','10.510','7278000','7278000','7278000','7278000','7278000','sales','2025-08-16 10:26:46','FB-250816-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250816-0003','MISKIMA','WONOKUSUMO LOR 8/4','','','','sales','2025-08-16 10:26:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-16' 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-250816-0004','K','2025-08-16','10:26:46','sales','PEMBELIAN UMUM','FB-250816-0003','171443427','7278000','164165427','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250816-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250816-0003';
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI25-01533','2401','1','LT HURUF A BT AD 5BJ 700SHB','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'500000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'500000'  WHERE tanggal='2025-08-16'
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('PI25-01533','2025-08-16','2025-08-16','12:42:47','PLG0017076','2401','90','2025-11-14','sales','2025-08-16 12:42:47','0.680','500000','4.00','60000','560000','0','OPEN','1.93','1','2025-11-14','0','560000')
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-250816-0005','K','2025-08-16','12:42:47','sales','HUTANG','PI25-01533','164165427','500000','163665427','OPEN') 
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-250816-0001','sales','1',' ','TOKO','BTATMD','MDAT-XJAF-11-0','AT ITALY BT SHB ','','1.320','1','100.00','1063000','0','0','0','1063000','0','0','0','1063000','2402','00021190','MDAT','112500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDAT-XJAF-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.320',berat_jual_asli=berat_jual_asli+'1.320',stock_jual='1',berat_akhir=berat_akhir-'1.320',berat_akhir_asli=berat_akhir_asli-'1.320',stock_akhir='0' WHERE tanggal='2025-08-16' AND kode_barang='MDAT-XJAF-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMD' 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-250816-0001','2025-08-16','1.320','2025-08-16','12:44:13','PLG0017077','1063000','1063000','0','1063000','1063000','sales','2025-08-16 12:44:13','FJ-250816-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('2025-08-16','FJ-250816-0001','2025-08-16','12:44:13','2402','1063000','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-250816-0006','D','2025-08-16','12:44:13','sales','PENJUALAN','FJ-250816-0001','163665427','1063000','164728427');
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI25-01533' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI25-01533';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250816-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250816-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250816-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) VALUES ('FJ-250816-0002','sales','1',' EX ','TOKO','BTCNMD','MDCN-YBBH-25-0','CN COR BT MK ','','1.320','1','100.00','1063000','0','0','0','1063000','0','0','0','1063000','2105','00023381','MDCN','112500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-YBBH-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.320',berat_jual_asli=berat_jual_asli+'1.320',stock_jual='1',berat_akhir=berat_akhir-'1.320',berat_akhir_asli=berat_akhir_asli-'1.320',stock_akhir='0' WHERE tanggal='2025-08-16' AND kode_barang='MDCN-YBBH-25-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-250816-0002','2025-08-16','1.320','2025-08-16','13:00:48','PLG0017078','1063000','1063000','0','1063000','0','sales','2025-08-16 13:00:48','FJ-250816-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('2025-08-16','FJ-250816-0002','2025-08-16','13:00:48','2105','1063000','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-250816-0001','2025-08-16','2025-08-16 13:00:48','PENJUALAN : FJ-250816-0002','dana','BCA','1063000','1063000','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-250816-0002','D','2025-08-16','13:00:48','BCA','PENJUALAN','FJ-250816-0002','1282982418','1063000','1284045418','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('dana','SITI FAIZEH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1063000' WHERE no_faktur_jual='FJ-250816-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250816-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250816-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250816-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-16 ','13:07:37');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-08-16 ','13:52:37');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250816-0003','K','2025-08-16','13:53:24','BCA','PENGELUARAN','JASA PROFESIONAL PENDAFTARAN MERK (NON-MEMBER)','1284045418','1618400','1282427018');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250816-0004','K','2025-08-16','13:55:00','BCA','PENGELUARAN','PENGGANTIAN PNBP PENDAFTARAN MERK SKU SAHABATKU','1282427018','1800000','1280627018');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250816-0005','K','2025-08-16','13:55:37','BCA','PENGELUARAN','SERVICE PRINTER L120 - SN TP2K907459','1280627018','150000','1280477018');
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-250816-0006','D','2025-08-16','13:56:17','BCA','PEMASUKAN','REFUND JASA PROFESIONAL PENDAFTARAN MERK','1280477018','1618400','1282095418');
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-250816-0007','D','2025-08-16','13:56:43','BCA','PEMASUKAN','REFUND PENGGANTIAN PNBP PENDAFTARAN MERK SKU SAHABATKU','1282095418','1800000','1283895418');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250816-0008','K','2025-08-16','13:57:30','BCA','PENGELUARAN','BLOOM PAPAN BUNGA ERIK & YOVITA','1283895418','850000','1283045418');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250816-0009','K','2025-08-16','13:58:16','BCA','PENGELUARAN','BPJS KESEHATAN','1283045418','250588','1282794830');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250816-0010','K','2025-08-16','13:58:35','BCA','PENGELUARAN','TELKOM 0313716972','1282794830','383616','1282411214');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250816-0011','K','2025-08-16','13:58:47','BCA','PENGELUARAN','TELKOM 0313716832','1282411214','39516','1282371698');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250816-0012','K','2025-08-16','13:59:13','BCA','PENGELUARAN','GOOGLE WORKSPACE SAHABATKU.ID','1282371698','790631','1281581067');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250816-0013','K','2025-08-16','13:59:28','BCA','PENGELUARAN','ORBIT 0821.3781.3887','1281581067','100500','1281480567');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250816-0014','K','2025-08-16','13:59:51','BCA','PENGELUARAN','BPJS KESEHATAN','1281480567','250588','1281229979');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250816-0015','K','2025-08-16','14:00:08','BCA','PENGELUARAN','TELKOM 0313716972','1281229979','383616','1280846363');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250816-0016','K','2025-08-16','14:00:38','BCA','PENGELUARAN','TELKOM 0313716832','1280846363','39516','1280806847');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250816-0017','K','2025-08-16','14:00:52','BCA','PENGELUARAN','ORBIT 0821.3781.3887','1280806847','100995','1280705852');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250816-0018','K','2025-08-16','14:01:12','BCA','PENGELUARAN','GOOGLE WORKSPACE SAHABATKU.ID','1280705852','904921','1279800931');
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-00008690','X-00008690','AT TINDIK TDK BT SHB','GR','---','MTAT','BELI','BELI001','632000','2025-08-16','0.620','1','sales','2025-08-16 14:31:19');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTAT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTAT','X-00008690','X-00008690');
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-250816-0004','FJ-250429-0001','2105','1','BELI','BELI001','MTAT', 'X-00008690', 'AT TINDIK TDK BT SHB','0.620','0.620','100.00','877500','632000','1019355','1','632000','632000','RONGSOK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.620',berat_beli_asli=berat_beli_asli+'0.620',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.620',berat_akhir_asli=berat_akhir_asli+'0.620',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTAT' LIMIT 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-250816-0004','2025-08-16','2025-08-16','14:31:19','2105','---','0.620','632000','632000','632000','632000','632000','sales','2025-08-16 14:31:19','FB-250816-0004','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250816-0004','ANNORAH LUSIA. B','JL. SIDOTOPO SEKOLH 4/12','','','','sales','2025-08-16 14:31:19');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-16' 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-250816-0007','K','2025-08-16','14:31:19','sales','PEMBELIAN UMUM','FB-250816-0004','164728427','632000','164096427','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250816-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250816-0004';
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-250816-0003','sales','1',' ','TOKO','BTGWMT','MTGW-YFAA-58-0','GW CAP TDK BT SHB ','','0.510','1','100.00','691500','0','0','0','691500','0','0','0','691500','2105','00025078','MTGW','162500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGW-YFAA-58-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2025-08-16' AND kode_barang='MTGW-YFAA-58-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-250816-0003','2025-08-16','0.510','2025-08-16','14:35:21','PLG0017079','691500','691500','0','691500','691500','sales','2025-08-16 14:35:21','FJ-250816-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('2025-08-16','FJ-250816-0003','2025-08-16','14:35:21','2105','691500','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-250816-0008','D','2025-08-16','14:35:21','sales','PENJUALAN','FJ-250816-0003','164096427','691500','164787927');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250816-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250816-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250816-0003';
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-250816-0004','sales','1',' ','TOKO','BTCNMT','MTCN-YCXF-50-0','CN COR TDK BT SHB ','','0.950','1','100.00','1287500','0','0','0','1287500','0','0','0','1287500','2402','00023864','MTCN','162500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-YCXF-50-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2025-08-16' AND kode_barang='MTCN-YCXF-50-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-250816-0004','2025-08-16','0.950','2025-08-16','15:16:35','PLG0017080','1287500','1287500','0','1287500','1287500','sales','2025-08-16 15:16:35','FJ-250816-0004');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-08-16','FJ-250816-0004','2025-08-16','15:16:35','2402','1287500','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-250816-0009','D','2025-08-16','15:16:35','sales','PENJUALAN','FJ-250816-0004','164787927','1287500','166075427');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250816-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250816-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250816-0004';