INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-11-10 ','08:32:37');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-10','113','0','-243500000','113','0','-243500000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-10';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-09';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-09';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-11-09' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-09';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-09';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-09';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-09';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-10' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-09' 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-251110-0001','D','2025-11-10','08:33:00','BCA','SALDO AWAL','SALDO AWAL','0','1420539157','1420539157');
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-251110-0001','D','2025-11-10','08:33:00','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-11-10';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-11-10 ','08:33:19');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2025-11-10 ','08:34:52');
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-251110-0001','sales','1',' ','TOKO','BTATMT','MTAT-YCXE-35-0','AT COR KLP TDK BT SHB ','','1.970','1','100.00','3310000','0','0','0','3310000','0','0','0','3310000','2105','00023704','MTAT','202000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-YCXE-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2025-11-10' AND kode_barang='MTAT-YCXE-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMT' 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-251110-0001','2025-11-10','1.970','2025-11-10','08:52:24','PLG0017504','3310000','3310000','0','3310000','3310000','sales','2025-11-10 08:52:23','FJ-251110-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-11-10','FJ-251110-0001','2025-11-10','08:52:24','2105','3310000','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-251110-0002','D','2025-11-10','08:52:24','sales','PENJUALAN','FJ-251110-0001','227213829','3310000','230523829');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-11-10 ','09:12:33');
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-251110-0001','1','X-00008967','BELI','BELI001','AT COR KLP BT SHB','1','1.870','2763500.00' ,'0.00','2763500','','2763500','2763500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2025-11-10 09:35:37' WHERE kode_barang='X-00008967' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00008967' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00008967' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.870',berat_hancur_asli=berat_hancur_asli+'1.870', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.870',berat_akhir_asli=berat_akhir_asli-'1.870' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTAT' 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-251110-0001','2','X-00008968','BELI','BELI001','AT COR KLP BT MK','1','1.170','1345000.00' ,'0.00','1345000','','1345000','6872000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2025-11-10 09:35:37' WHERE kode_barang='X-00008968' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00008968' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00008968' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.170',berat_hancur_asli=berat_hancur_asli+'1.170', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.170',berat_akhir_asli=berat_akhir_asli-'1.170' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTAT' 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-251110-0001','3','X-00008969','BELI','BELI001','GL VG KOMB ENG MN14 17CM KKT PER SHB','1','2.970','4389500.00' ,'0.00','4389500','','4389500','12606500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2025-11-10 09:35:37' WHERE kode_barang='X-00008969' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00008969' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00008969' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.970',berat_hancur_asli=berat_hancur_asli+'2.970', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.970',berat_akhir_asli=berat_akhir_asli-'2.970' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTGL' 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-251110-0001','4','X-00008970','BELI','BELI001','KL ITALY ST BTR BL PSR 42CM KKT PER BLT SHB','1','3.020','2557500.00' ,'0.00','2557500','','2557500','19553500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2025-11-10 09:35:37' WHERE kode_barang='X-00008970' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00008970' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00008970' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'3.020',berat_hancur_asli=berat_hancur_asli+'3.020', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'3.020',berat_akhir_asli=berat_akhir_asli-'3.020' 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-251110-0001','5','X-00008971','BELI','BELI001','GL BANGKOK TMBL SHB','1','5.000','7390000.00' ,'0.00','7390000','','7390000','29501000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2025-11-10 09:35:37' WHERE kode_barang='X-00008971' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00008971' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00008971' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'5.000',berat_hancur_asli=berat_hancur_asli+'5.000', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'5.000',berat_akhir_asli=berat_akhir_asli-'5.000' 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-251110-0001','adminpusat','2025-11-10','2025-11-10','09:35:38','18445500','29501000', 'adminpusat','2025-11-10 09:35:37');
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-251110-0002','1','X-00008972','BELI','BELI001','AT TUSUK ITALY BL SLP SHB','1','0.700','402000.00' ,'0.00','402000','','402000','402000','RUSAK ADA HILANG');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2025-11-10 09:39:07' WHERE kode_barang='X-00008972' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00008972' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00008972' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.700',berat_hancur_asli=berat_hancur_asli+'0.700', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDAT' 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-251110-0002','2','X-00008973','BELI','BELI001','GL CAP HOLO 16CM KKT PER SHB','1','3.600','2070000.00' ,'0.00','2070000','','2070000','2874000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2025-11-10 09:39:07' WHERE kode_barang='X-00008973' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00008973' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00008973' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'3.600',berat_hancur_asli=berat_hancur_asli+'3.600', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'3.600',berat_akhir_asli=berat_akhir_asli-'3.600' 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-251110-0002','3','X-00008974','BELI','BELI001','AT KLP KTK BT SHB','1','1.340','1980500.00' ,'0.00','1980500','','1980500','6924500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2025-11-10 09:39:07' WHERE kode_barang='X-00008974' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00008974' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00008974' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.340',berat_hancur_asli=berat_hancur_asli+'1.340', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.340',berat_akhir_asli=berat_akhir_asli-'1.340' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTAT' 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-251110-0002','adminpusat','2025-11-10','2025-11-10','09:39:07','4452500','6924500', 'adminpusat','2025-11-10 09:39:07');
UPDATE tt_hutang_head SET byr_harus_rp='1500000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'1523000',tgl_lunas='2025-11-10',status='CLOS',total_lunas='1523000' WHERE no_hutang='PI25-01592';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'1500000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'1500000'  WHERE tanggal='2025-11-10';
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-251110-0003','D','2025-11-10','09:44:02','cashier1','HUTANG LUNAS','PI25-01592','230523829','1523000','232046829');
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-251110-0002','sales','1',' EX ','TOKO','BTCNMD','MDCN-YEXE-41-0','CN COR TDK BT MK ','','1.000','1','100.00','985000','0','0','0','985000','0','0','0','985000','2403','00024869','MDCN','138000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-YEXE-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-11-10' AND kode_barang='MDCN-YEXE-41-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-251110-0002','2025-11-10','1.000','2025-11-10','10:15:14','PLG0017505','985000','985000','0','985000','985000','sales','2025-11-10 10:15:13','FJ-251110-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-11-10','FJ-251110-0002','2025-11-10','10:15:14','2403','985000','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-251110-0004','D','2025-11-10','10:15:14','sales','PENJUALAN','FJ-251110-0002','232046829','985000','233031829');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-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-251110-0003','sales','1',' EX ','TOKO','BTATMT','MTAT-YHBH-99-0','AT KLP KTK TDK BT SHB ','','1.610','1','100.00','2705000','0','0','0','2705000','0','0','0','2705000','2401','00026013','MTAT','202000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-YHBH-99-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2025-11-10' AND kode_barang='MTAT-YHBH-99-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMT' 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-251110-0003','2025-11-10','1.610','2025-11-10','10:51:57','PLG0017506','2705000','2705000','0','2705000','2705000','sales','2025-11-10 10:51:56','FJ-251110-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-11-10','FJ-251110-0003','2025-11-10','10:51:57','2401','2705000','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-251110-0005','D','2025-11-10','10:51:57','sales','PENJUALAN','FJ-251110-0003','233031829','2705000','235736829');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-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-251110-0004','sales','1',' ','TOKO','BTGLMD','MDGL-YKXE-1-0','GL PLINTIR ANAK LC2 ','','2.320','1','100.00','2285500','0','0','0','2285500','0','0','0','2285500','2106','00026713','MDGL','138000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-YKXE-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.320',berat_jual_asli=berat_jual_asli+'2.320',stock_jual='1',berat_akhir=berat_akhir-'2.320',berat_akhir_asli=berat_akhir_asli-'2.320',stock_akhir='0' WHERE tanggal='2025-11-10' AND kode_barang='MDGL-YKXE-1-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-251110-0004','2025-11-10','2.320','2025-11-10','11:01:21','PLG0017507','2285500','2285500','0','2285500','2285500','sales','2025-11-10 11:01:21','FJ-251110-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-11-10','FJ-251110-0004','2025-11-10','11:01:21','2106','2285500','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-251110-0006','D','2025-11-10','11:01:21','sales','PENJUALAN','FJ-251110-0004','235736829','2285500','238022329','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2285500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-251110-0004' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-251110-0005','sales',' 1',' ','TOKO','BTGLMD','MDGL-YKXE-2-0','GL PLINTIR ANAK LC2 ','','2.350','1','100.00','2315000','0','0','0','2315000','0','0','0','2315000','2106','00026714','MDGL','138000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-YKXE-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.350',berat_jual_asli=berat_jual_asli+'2.350',stock_jual='1',berat_akhir=berat_akhir-'2.350',berat_akhir_asli=berat_akhir_asli-'2.350',stock_akhir='0' WHERE tanggal='2025-11-10' AND kode_barang='MDGL-YKXE-2-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-251110-0005','2025-11-10','2.350','2025-11-10','11:01:21','PLG0017508','2315000','2315000','0','2315000','2315000','sales','2025-11-10 11:01:21','FJ-251110-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-11-10','FJ-251110-0005','2025-11-10','11:01:21','2106','2315000','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-251110-0007','D','2025-11-10','11:01:21','sales','PENJUALAN','FJ-251110-0005','238022329','2315000','240337329','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2315000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-251110-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-251110-0006','sales',' 1',' ','TOKO','BTGLMD','MDGL-YKXE-3-0','GL PLINTIR ANAK LC2 ','','2.210','1','100.00','2177000','0','0','0','2177000','0','0','0','2177000','2106','00026715','MDGL','138000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-YKXE-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.210',berat_jual_asli=berat_jual_asli+'2.210',stock_jual='1',berat_akhir=berat_akhir-'2.210',berat_akhir_asli=berat_akhir_asli-'2.210',stock_akhir='0' WHERE tanggal='2025-11-10' AND kode_barang='MDGL-YKXE-3-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-251110-0006','2025-11-10','2.210','2025-11-10','11:01:21','PLG0017509','2177000','2177000','0','2177000','2177000','sales','2025-11-10 11:01:21','FJ-251110-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-11-10','FJ-251110-0006','2025-11-10','11:01:21','2106','2177000','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-251110-0008','D','2025-11-10','11:01:21','sales','PENJUALAN','FJ-251110-0006','240337329','2177000','242514329','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2177000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-251110-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-0006';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-251110-0007','sales','1',' EX ','TOKO','BTCNMT','MTCN-YEXE-125-0','CN COR TDK BT SHB ','','1.010','1','100.00','1697000','0','0','0','1697000','0','0','0','1697000','2503','00024953','MTCN','202000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-YEXE-125-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2025-11-10' AND kode_barang='MTCN-YEXE-125-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-251110-0007','2025-11-10','1.010','2025-11-10','11:12:05','PLG0017510','1697000','1697000','0','1697000','1697000','sales','2025-11-10 11:12:04','FJ-251110-0007');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-10','FJ-251110-0007','2025-11-10','11:12:05','2503','1697000','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-251110-0009','D','2025-11-10','11:12:05','sales','PENJUALAN','FJ-251110-0007','242514329','1697000','244211329');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-0007';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-251110-0008','sales','1',' EX ','TOKO','BTCNMT','MTCN-YEXE-123-0','CN COR TDK BT SHB ','','1.100','1','100.00','1848000','0','0','0','1848000','0','0','0','1848000','2503','00024951','MTCN','202000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-YEXE-123-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2025-11-10' AND kode_barang='MTCN-YEXE-123-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-251110-0008','2025-11-10','1.100','2025-11-10','11:15:41','PLG0017511','1848000','1848000','0','1848000','1848000','sales','2025-11-10 11:15:40','FJ-251110-0008');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-10','FJ-251110-0008','2025-11-10','11:15:41','2503','1848000','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-251110-0010','D','2025-11-10','11:15:41','sales','PENJUALAN','FJ-251110-0008','244211329','1848000','246059329');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-0008';
INSERT INTO tt_bayar_bunga(no_hutang,tgl_system,tgl_bayar,total_bunga,dibayar,saldo) Values ('PI24-01294','2025-11-10', '2025-11-10','1308000','93000','1137000');
UPDATE tt_hutang_head set sld_akhir_rp=sld_akhir_rp +'93000' WHERE no_hutang='PI24-01294';
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-251110-0011','D','2025-11-10','11:40:04','cashier1','HUTANG BUNGA','PI24-01294','246059329','93000','246152329');
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-00008975','X-00008975','LT COR TDK BT SMBR PTH BG3','GR','---','MTLT','BELI','BELI001','4892000','2025-11-10','3.310','1','sales','2025-11-10 11:40:46');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTLT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTLT','X-00008975','X-00008975');
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-251110-0001','FJ-251022-0002','2401','1','BELI','BELI001','MTLT', 'X-00008975', 'LT COR TDK BT SMBR PTH BG3','3.310','3.310','100.00','5859000','4892000','1477946','1','4892000','4892000','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-11-10','BELI','BELI001','MTLT','MTLT','100.00','3.310','3.310','1','3.310','3.310','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-251110-0001','2025-11-10','2025-11-10','11:40:45','2401','---','3.310','4892000','4892000','4892000','4892000','4892000','sales','2025-11-10 11:40:46','FB-251110-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251110-0001','MUTIKA','GUBENG ERLANGGA 6/17-A','','','083831110825','sales','2025-11-10 11:40:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-10' 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-251110-0012','K','2025-11-10','11:40:45','sales','PEMBELIAN UMUM','FB-251110-0001','246152329','4892000','241260329','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251110-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251110-0001';
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI25-01607','2502','1','KL RANTAI HOLLO KKT S HWT S22','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'5000000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'5000000'  WHERE tanggal='2025-11-10'
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-01607','2025-11-10','2025-11-10','12:03:02','PLG0017512','2502','90','2026-02-08','sales','2025-11-10 12:03:01','9.820','5000000','3.00','450000','5450000','0','OPEN','11.24','1','2026-02-08','0','5450000')
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-251110-0013','K','2025-11-10','12:03:02','sales','HUTANG','PI25-01607','241260329','5000000','236260329','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-251110-0009','sales','1',' EX ','TOKO','BTGLMS','MSGL-YJBX-2-0','GL BABY PLINTIR 2 BEL SHB ','','2.920','1','100.00','2876500','0','0','0','2876500','0','0','0','2876500','2503','00026319','MSGL','138000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MSGL-YJBX-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.920',berat_jual_asli=berat_jual_asli+'2.920',stock_jual='1',berat_akhir=berat_akhir-'2.920',berat_akhir_asli=berat_akhir_asli-'2.920',stock_akhir='0' WHERE tanggal='2025-11-10' AND kode_barang='MSGL-YJBX-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMS' 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-251110-0009','2025-11-10','2.920','2025-11-10','12:04:28','PLG0017513','2876500','2876500','0','2876500','2876500','sales','2025-11-10 12:04:27','FJ-251110-0009');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-10','FJ-251110-0009','2025-11-10','12:04:28','2503','2876500','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-251110-0014','D','2025-11-10','12:04:28','sales','PENJUALAN','FJ-251110-0009','236260329','2876500','239136829');
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI25-01607' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI25-01607';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-0009';
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-00008976','X-00008976','CN PIPA MT AD 3 MERAH 1','GR','---','MDCN','BELI','BELI001','483000','2025-11-10','0.840','1','sales','2025-11-10 12:24:01');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDCN','X-00008976','X-00008976');
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-251110-0002','-','2402','1','BELI','BELI001','MDCN', 'X-00008976', 'CN PIPA MT AD 3 MERAH 1','1.200','0.840','100.00','300000','483000','575000','1','483000','483000','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-11-10','BELI','BELI001','MDCN','MDCN','100.00','0.840','0.840','1','0.840','0.840','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-251110-0002','2025-11-10','2025-11-10','12:24:01','2402','---','0.840','483000','483000','483000','483000','483000','sales','2025-11-10 12:24:01','FB-251110-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251110-0002','-','-','','','','sales','2025-11-10 12:24:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-10' 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-251110-0015','K','2025-11-10','12:24:01','sales','PEMBELIAN UMUM','FB-251110-0002','239136829','483000','238653829','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251110-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251110-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-11-10 ','13:01:26');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-251110-0010','sales','1',' EX ','TOKO','BTCNMD','MDCN-YCBE-7-0','CN SESER MK ','','1.550','1','100.00','1527000','0','0','0','1527000','0','0','0','1527000','2106','00024290','MDCN','138000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-YCBE-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2025-11-10' AND kode_barang='MDCN-YCBE-7-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-251110-0010','2025-11-10','1.550','2025-11-10','13:29:26','PLG0017514','1527000','1527000','0','1527000','1527000','sales','2025-11-10 13:29:25','FJ-251110-0010');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-10','FJ-251110-0010','2025-11-10','13:29:26','2106','1527000','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-251110-0016','D','2025-11-10','13:29:26','sales','PENJUALAN','FJ-251110-0010','238653829','1527000','240180829');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-0010';
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-00008977','X-00008977','CN COR TDK BT SHB','GR','---','MTCN','BELI','BELI001','1433500','2025-11-10','0.970','1','sales','2025-11-10 13:53:10');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00008977','X-00008977');
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-251110-0003','FJ-240806-0004','2401','1','BELI','BELI001','MTCN', 'X-00008977', 'CN COR TDK BT SHB','1.020','0.970','100.00','994500','1433500','1477835','1','1433500','1433500','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-11-10','BELI','BELI001','MTCN','MTCN','100.00','0.970','0.970','1','0.970','0.970','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-251110-0003','2025-11-10','2025-11-10','13:53:09','2401','---','0.970','1433500','1433500','1433500','1433500','1433500','sales','2025-11-10 13:53:10','FB-251110-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251110-0003','IRMA','DONOKERTO 2/24','','','','sales','2025-11-10 13:53:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-10' 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-251110-0017','K','2025-11-10','13:53:09','sales','PEMBELIAN UMUM','FB-251110-0003','240180829','1433500','238747329','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251110-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251110-0003';
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-00008978','X-00008978','LT COR DOLLAR LC2','GR','---','MDLT','BELI','BELI001','1024500','2025-11-10','1.210','1','sales','2025-11-10 14:08:37');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDLT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDLT','X-00008978','X-00008978');
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-251110-0004','FJ-250326-0017','2401','1','BELI','BELI001','MDLT', 'X-00008978', 'LT COR DOLLAR LC2','1.210','1.210','100.00','905000','1024500','846694','1','1024500','1024500','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-11-10','BELI','BELI001','MDLT','MDLT','100.00','1.210','1.210','1','1.210','1.210','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-251110-0004','2025-11-10','2025-11-10','14:08:37','2401','---','1.210','1024500','1024500','1024500','1024500','1024500','sales','2025-11-10 14:08:37','FB-251110-0004','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251110-0004','ROMLAH','SIDOTOPO SKLHN G2/22','','','087762730196','sales','2025-11-10 14:08:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-10' 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-251110-0018','K','2025-11-10','14:08:37','sales','PEMBELIAN UMUM','FB-251110-0004','238747329','1024500','237722829','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251110-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251110-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-11-10 ','14:36:32');