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,status_otorisasi,harga_skrg) VALUES ('F325130838361','input','1',' MEF1 X UB ','TOKO','PM-F','F2E-YHXH-300-0','GL X OVAL PAKU MATA UB 56 8K ','','6.080','1','100.00','5442000','0','0','15000','5440000','0','0','0','5440000','FIT','00364828','F2E','0','0','-','1','895000');
UPDATE tm_barang SET tgl_last_jual='2025-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YHXH-300-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.080',berat_jual_asli=berat_jual_asli+'6.080',stock_jual='1',berat_akhir=berat_akhir-'6.080',berat_akhir_asli=berat_akhir_asli-'6.080',stock_akhir='0' WHERE tanggal='2025-09-13' AND kode_barang='F2E-YHXH-300-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' 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 ('F325130838361','2025-09-13','6.080','2025-09-13','08:38:36','PLG0024862','5440000','5440000','0','5440000','5440000','input','2025-09-13 08:38:36','F32513083836');
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-09-13','F325130838361','2025-09-13','08:38:36','FIT','5440000','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-250913-0002','D','2025-09-13','08:38:36','input','PENJUALAN','F325130838361','-6935000','5440000','-1495000');
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,status_otorisasi,harga_skrg) VALUES ('F325130948341','input','1',' MDA1D X UB','TOKO','PM-A','A1D-YGAA-60-0','AT X HUGGIES MATA UB 8K ','','1.010','1','100.00','887000','0','0','15000','887000','0','0','0','887000','AAT','00360613','A1D','0','0','-','0','878000');
UPDATE tm_barang SET tgl_last_jual='2025-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YGAA-60-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-09-13' AND kode_barang='A1D-YGAA-60-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' 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 ('F325130948341','2025-09-13','1.010','2025-09-13','09:48:35','PLG0024863','887000','887000','0','887000','887000','input','2025-09-13 09:48:34','F32513094834');
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-09-13','F325130948341','2025-09-13','09:48:35','AAT','887000','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-250913-0003','D','2025-09-13','09:48:35','input','PENJUALAN','F325130948341','-1495000','887000','-608000');
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,status_otorisasi,harga_skrg) VALUES ('F325131030401','input','1',' MEE1 HW 17','TOKO','PM-E','E1E-YHXG-420-0','CC MODEL SLEP VAR HW 17 8K ','','0.650','1','100.00','582000','0','0','15000','582000','0','0','0','582000','FIT','00364469','E1E','0','0','-','0','895000');
UPDATE tm_barang SET tgl_last_jual='2025-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHXG-420-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2025-09-13' AND kode_barang='E1E-YHXG-420-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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 ('F325131030401','2025-09-13','0.650','2025-09-13','10:30:40','PLG0024864','582000','582000','0','582000','582000','input','2025-09-13 10:30:40','F32513103040');
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-09-13','F325131030401','2025-09-13','10:30:40','FIT','582000','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-250913-0004','D','2025-09-13','10:30:40','input','PENJUALAN','F325131030401','-608000','582000','-26000');
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-00016970','X-00016970','GL FANCY MODEL HATI CAT ARESO VAR HW 8K','GR','---','F3E','BELI','BELI001','1750000','2025-09-13','3.220','1','kasir','2025-09-13 10:53:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00016970','X-00016970');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250913-0001','F324031216251','AAT','1','BELI','BELI001','F3E', 'X-00016970', 'GL FANCY MODEL HATI CAT ARESO VAR HW 8K','3.270','3.220','100.00','1990000','1750000','543478','895000','1','1750000','1750000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.220',berat_beli_asli=berat_beli_asli+'3.220',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.220',berat_akhir_asli=berat_akhir_asli+'3.220',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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) VALUES ('FB-250913-0001','2025-09-13','2025-09-13','10:53:22','AAT','---','3.220','1750000','1750000','1750000','1750000','1750000','kasir','2025-09-13 10:53:23','FB-250913-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250913-0001','VERA','GONGGANG BULUKERTO','','','08560282560','kasir','2025-09-13 10:53:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-13' 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) VALUES ('KK-250913-0005','K','2025-09-13','10:53:22','kasir','PEMBELIAN UMUM','FB-250913-0001','-26000','1750000','-1776000');
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-00016971','X-00016971','GL FANCY ANAK MODEL BONEKA CAT VAR UB 8K','GR','---','F3E','BELI','BELI001','1035000','2025-09-13','1.930','1','kasir','2025-09-13 10:53:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00016971','X-00016971');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250913-0002','F324031209291','AAT','2','BELI','BELI001','F3E', 'X-00016971', 'GL FANCY ANAK MODEL BONEKA CAT VAR UB 8K','1.930','1.930','100.00','1195000','1035000','536269','895000','1','1035000','1035000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.930',berat_beli_asli=berat_beli_asli+'1.930',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.930',berat_akhir_asli=berat_akhir_asli+'1.930',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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) VALUES ('FB-250913-0002','2025-09-13','2025-09-13','10:53:22','AAT','---','1.930','1035000','1035000','1035000','1035000','1035000','kasir','2025-09-13 10:53:23','FB-250913-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250913-0002','VERA','GONDANG BULUKERTO','','','085602825610','kasir','2025-09-13 10:53:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-13' 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) VALUES ('KK-250913-0006','K','2025-09-13','10:53:22','kasir','PEMBELIAN UMUM','FB-250913-0002','-1776000','1035000','-2811000');
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-00016972','X-00016972','AT MODEL MATA VAR LG 8K','GR','---','A1F','BELI','BELI001','115000','2025-09-13','0.240','1','kasir','2025-09-13 10:53:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00016972','X-00016972');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250913-0003','F324260924411','AAT','3','BELI','BELI001','A1F', 'X-00016972', 'AT MODEL MATA VAR LG 8K','0.470','0.240','100.00','292000','115000','479167','912000','1','115000','115000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.240',berat_beli_asli=berat_beli_asli+'0.240',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.240',berat_akhir_asli=berat_akhir_asli+'0.240',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' 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) VALUES ('FB-250913-0003','2025-09-13','2025-09-13','10:53:22','AAT','---','0.240','115000','115000','115000','115000','115000','kasir','2025-09-13 10:53:23','FB-250913-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250913-0003','PINDI','BULUKERTO','','','','kasir','2025-09-13 10:53:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-13' 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) VALUES ('KK-250913-0007','K','2025-09-13','10:53:22','kasir','PEMBELIAN UMUM','FB-250913-0003','-2811000','115000','-2926000');
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-00016973','X-00016973','GL X OVAL C SLEP TD 56 8K','GR','---','F1E','BELI','BELI001','3425000','2025-09-13','4.760','1','kasir','2025-09-13 10:54:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00016973','X-00016973');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250913-0004','F325090911401','AAT','1','BELI','BELI001','F1E', 'X-00016973', 'GL X OVAL C SLEP TD 56 8K','4.760','4.760','100.00','3937000','3425000','719538','895000','1','3425000','3425000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.760',berat_beli_asli=berat_beli_asli+'4.760',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.760',berat_akhir_asli=berat_akhir_asli+'4.760',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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) VALUES ('FB-250913-0004','2025-09-13','2025-09-13','10:54:03','AAT','---','4.760','3425000','3425000','3425000','3425000','3425000','kasir','2025-09-13 10:54:03','FB-250913-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250913-0004','LILIS UNTARI','BUGELAN KISMANTORO','','','','kasir','2025-09-13 10:54:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-13' 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) VALUES ('KK-250913-0008','K','2025-09-13','10:54:03','kasir','PEMBELIAN UMUM','FB-250913-0004','-2926000','3425000','-6351000');
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-00016974','X-00016974','CC X MODEL MATA VAR UB 12 17K','GR','---','E2TE','BELI','BELI001','3115000','2025-09-13','2.400','1','kasir','2025-09-13 10:56:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00016974','X-00016974');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250913-0005','F325290954412','FIT','1','BELI','BELI001','E2TE', 'X-00016974', 'CC X MODEL MATA VAR UB 12 17K','2.400','2.400','100.00','3313000','3115000','1297917','1590000','1','3115000','3115000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.400',berat_beli_asli=berat_beli_asli+'2.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.400',berat_akhir_asli=berat_akhir_asli+'2.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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) VALUES ('FB-250913-0005','2025-09-13','2025-09-13','10:56:14','FIT','---','2.400','3115000','3115000','3115000','3115000','3115000','kasir','2025-09-13 10:56:14','FB-250913-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250913-0005','RURY','NAWANGAN PENGGUNG','','','081254955080','kasir','2025-09-13 10:56:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-13' 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) VALUES ('KK-250913-0009','K','2025-09-13','10:56:14','kasir','PEMBELIAN UMUM','FB-250913-0005','-6351000','3115000','-9466000');
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-00016975','X-00016975','CC X MODEL MATA UB 13','GR','---','E2TE','BELI','BELI001','2685000','2025-09-13','2.070','1','kasir','2025-09-13 10:56:15');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00016975','X-00016975');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250913-0006','F325290954411','FIT','2','BELI','BELI001','E2TE', 'X-00016975', 'CC X MODEL MATA UB 13','2.070','2.070','100.00','2857000','2685000','1297101','1590000','1','2685000','2685000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.070',berat_beli_asli=berat_beli_asli+'2.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.070',berat_akhir_asli=berat_akhir_asli+'2.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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) VALUES ('FB-250913-0006','2025-09-13','2025-09-13','10:56:14','FIT','---','2.070','2685000','2685000','2685000','2685000','2685000','kasir','2025-09-13 10:56:15','FB-250913-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250913-0006','RURY','NAWANGAN PENGGUNG','','','081254955080','kasir','2025-09-13 10:56:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-13' 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) VALUES ('KK-250913-0010','K','2025-09-13','10:56:14','kasir','PEMBELIAN UMUM','FB-250913-0006','-9466000','2685000','-12151000');
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,status_otorisasi,harga_skrg) VALUES ('F325131122171','kasir','1',' MEF3E X HW','TOKO','PM-F','F3E-YDBA-102-0','GL X RANTAI HOLLOW CD VAR HW 8K ','','3.380','1','100.00','3025000','0','0','15000','3025000','0','0','0','3025000','FIT','00350359','F3E','0','0','-','0','895000');
UPDATE tm_barang SET tgl_last_jual='2025-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YDBA-102-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.380',berat_jual_asli=berat_jual_asli+'3.380',stock_jual='1',berat_akhir=berat_akhir-'3.380',berat_akhir_asli=berat_akhir_asli-'3.380',stock_akhir='0' WHERE tanggal='2025-09-13' AND kode_barang='F3E-YDBA-102-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' 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 ('F325131122171','2025-09-13','3.380','2025-09-13','11:22:17','PLG0024865','3025000','3025000','0','3025000','3025000','kasir','2025-09-13 11:22:17','F32513112217');
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-09-13','F325131122171','2025-09-13','11:22:17','FIT','3025000','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-250913-0011','D','2025-09-13','11:22:17','kasir','PENJUALAN','F325131122171','-12151000','3025000','-9126000');
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-00016976','X-00016976','AT KLIP MODEL MATA LG','GR','---','A1TE','BELI','BELI001','1320000','2025-09-13','1.300','1','kasir','2025-09-13 13:56:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1TE','X-00016976','X-00016976');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250913-0007','F322300953031','FIT','1','BELI','BELI001','A1TE', 'X-00016976', 'AT KLIP MODEL MATA LG','1.300','1.300','100.00','917000','1320000','1015385','1590000','1','1320000','1320000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.300',berat_beli_asli=berat_beli_asli+'1.300',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.300',berat_akhir_asli=berat_akhir_asli+'1.300',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1TE' 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) VALUES ('FB-250913-0007','2025-09-13','2025-09-13','13:56:54','FIT','---','1.300','1320000','1320000','1320000','1320000','1320000','kasir','2025-09-13 13:56:55','FB-250913-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250913-0007','TATIK','SUMBER GALIH','','','','kasir','2025-09-13 13:56:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-13' 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) VALUES ('KK-250913-0012','K','2025-09-13','13:56:54','kasir','PEMBELIAN UMUM','FB-250913-0007','-9126000','1320000','-10446000');
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,status_otorisasi,harga_skrg) VALUES ('F325130221501','input','1',' MEF1 X PM ','TOKO','PM-F','F1E-YHAD-283-0','GL X BANGKOK TIMBUL SLEP PM 58 8K ','','6.000','1','100.00','5370000','0','0','15000','5310000','0','0','0','5310000','AAT','00365897','F1E','0','0','-','1','895000');
UPDATE tm_barang SET tgl_last_jual='2025-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YHAD-283-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.000',berat_jual_asli=berat_jual_asli+'6.000',stock_jual='1',berat_akhir=berat_akhir-'6.000',berat_akhir_asli=berat_akhir_asli-'6.000',stock_akhir='0' WHERE tanggal='2025-09-13' AND kode_barang='F1E-YHAD-283-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' 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 ('F325130221501','2025-09-13','6.000','2025-09-13','14:21:51','PLG0024866','5310000','5310000','0','5310000','5310000','input','2025-09-13 14:21:50','F32513022150');
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-09-13','F325130221501','2025-09-13','14:21:51','AAT','5310000','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-250913-0013','D','2025-09-13','14:21:51','input','PENJUALAN','F325130221501','-10446000','5310000','-5136000');
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-00016977','X-00016977','LT X MODEL HURUF MATA LG T','GR','---','D2F','BELI','BELI001','367000','2025-09-13','0.470','1','kasir','2025-09-13 14:32:01');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2F','X-00016977','X-00016977');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250913-0008','F325271106021','SIN','1','BELI','BELI001','D2F', 'X-00016977', 'LT X MODEL HURUF MATA LG T','0.470','0.470','100.00','396000','367000','780851','912000','1','367000','367000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.470',berat_beli_asli=berat_beli_asli+'0.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.470',berat_akhir_asli=berat_akhir_asli+'0.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2F' 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) VALUES ('FB-250913-0008','2025-09-13','2025-09-13','14:32:01','SIN','---','0.470','367000','367000','367000','367000','367000','kasir','2025-09-13 14:32:01','FB-250913-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250913-0008','TRI TARWIJI','NGROMPAK SEMEN KULON','','','','kasir','2025-09-13 14:32:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-13' 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) VALUES ('KK-250913-0014','K','2025-09-13','14:32:01','kasir','PEMBELIAN UMUM','FB-250913-0008','-5136000','367000','-5503000');
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-00016978','X-00016978','CC MODEL MATA VAR CM 16 8K','GR','---','E2D','BELI','BELI001','640000','2025-09-13','0.850','1','kasir','2025-09-13 14:32:01');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00016978','X-00016978');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250913-0009','F325191125362','SIN','2','BELI','BELI001','E2D', 'X-00016978', 'CC MODEL MATA VAR CM 16 8K','0.850','0.850','100.00','695000','640000','752941','878000','1','640000','640000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.850',berat_beli_asli=berat_beli_asli+'0.850',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.850',berat_akhir_asli=berat_akhir_asli+'0.850',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' 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) VALUES ('FB-250913-0009','2025-09-13','2025-09-13','14:32:01','SIN','---','0.850','640000','640000','640000','640000','640000','kasir','2025-09-13 14:32:01','FB-250913-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250913-0009','TRI TARWIJI','TEPUS NGROMPAK JTS','','','','kasir','2025-09-13 14:32:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-13' 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) VALUES ('KK-250913-0015','K','2025-09-13','14:32:01','kasir','PEMBELIAN UMUM','FB-250913-0009','-5503000','640000','-6143000');
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-00016979','X-00016979','GL COR T 8K','GR','---','F1E','BELI','BELI001','5285000','2025-09-13','8.020','1','kasir','2025-09-13 14:37:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00016979','X-00016979');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250913-0010','F321070947481','AAT','1','BELI','BELI001','F1E', 'X-00016979', 'GL COR T 8K','8.020','8.020','100.00','3250000','5285000','658978','895000','1','5285000','5285000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'8.020',berat_beli_asli=berat_beli_asli+'8.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'8.020',berat_akhir_asli=berat_akhir_asli+'8.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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) VALUES ('FB-250913-0010','2025-09-13','2025-09-13','14:37:48','AAT','---','8.020','5285000','5285000','5285000','5285000','5285000','kasir','2025-09-13 14:37:49','FB-250913-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250913-0010','MARTINI','SUKOMANGU','','','','kasir','2025-09-13 14:37:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-13' 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) VALUES ('KK-250913-0016','K','2025-09-13','14:37:48','kasir','PEMBELIAN UMUM','FB-250913-0010','-6143000','5285000','-11428000');
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-00016980','X-00016980','KL X PREMIER TUMBUK KH 44CM','GR','---','H1G','BELI','BELI001','1695000','2025-09-13','3.000','1','kasir','2025-09-13 14:47:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1G','X-00016980','X-00016980');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250913-0011','F322191118362','FIT','1','BELI','BELI001','H1G', 'X-00016980', 'KL X PREMIER TUMBUK KH 44CM','3.000','3.000','100.00','1338000','1695000','565000','929000','1','1695000','1695000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.000',berat_beli_asli=berat_beli_asli+'3.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.000',berat_akhir_asli=berat_akhir_asli+'3.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1G' 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) VALUES ('FB-250913-0011','2025-09-13','2025-09-13','14:47:38','FIT','---','3.000','1695000','1695000','1695000','1695000','1695000','kasir','2025-09-13 14:47:39','FB-250913-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250913-0011','MIA','BITING','','','','kasir','2025-09-13 14:47:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-13' 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) VALUES ('KK-250913-0017','K','2025-09-13','14:47:38','kasir','PEMBELIAN UMUM','FB-250913-0011','-11428000','1695000','-13123000');
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,status_otorisasi,harga_skrg) VALUES ('F325130300131','kasir','1',' MEH1 KH 34','TOKO','PM-H','H1E-YGAF-229-0','KL SANTA ANAK KH 34CM 8K ','','2.050','1','100.00','1835000','0','0','15000','1835000','0','0','0','1835000','SIN','00361055','H1E','0','0','-','0','895000');
UPDATE tm_barang SET tgl_last_jual='2025-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YGAF-229-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2025-09-13' AND kode_barang='H1E-YGAF-229-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' 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 ('F325130300131','2025-09-13','2.050','2025-09-13','15:00:13','PLG0024867','1835000','1835000','0','1835000','1835000','kasir','2025-09-13 15:00:13','F32513030013');
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-09-13','F325130300131','2025-09-13','15:00:13','SIN','1835000','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-250913-0018','D','2025-09-13','15:00:13','kasir','PENJUALAN','F325130300131','-13123000','1835000','-11288000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1835000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325130300131' 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,status_otorisasi,harga_skrg) VALUES ('F325130300132','kasir',' 1',' MED1 5K YT','TOKO','PM-D','D1E-YIXD-147-0','LT MODEL BONEKA CAT VAR YT 8K ','','0.570','1','100.00','510000','0','0','15000','510000','0','5000','0','515000','SIN','00367904','D1E','0','0','-','0','895000');
UPDATE tm_barang SET tgl_last_jual='2025-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YIXD-147-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2025-09-13' AND kode_barang='D1E-YIXD-147-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' 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 ('F325130300132','2025-09-13','0.570','2025-09-13','15:00:13','PLG0024868','510000','510000','5000','515000','515000','kasir','2025-09-13 15:00:13','F32513030013');
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-09-13','F325130300132','2025-09-13','15:00:13','SIN','515000','5000');
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-250913-0019','D','2025-09-13','15:00:13','kasir','PENJUALAN','F325130300132','-11288000','515000','-10773000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='515000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325130300132' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325130221501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325130221501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325130221501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325130300131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325130300131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325130300131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325130300132' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325130300132' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325130300132';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325130838361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325130838361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325130838361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325130948341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325130948341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325130948341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325131030401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325131030401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325131030401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325131122171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325131122171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325131122171';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250913-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250913-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250913-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250913-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250913-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250913-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250913-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250913-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250913-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250913-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250913-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250913-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250913-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250913-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250913-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250913-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250913-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250913-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250913-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250913-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250913-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250913-0011';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-14','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-14';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-13';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-13';
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-09-13' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-13';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-13';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-13';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-13';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-14' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-13' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
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-250914-0001','D','2025-09-14','15:21:03','SYSTEM','SALDO AWAL','SALDO AWAL','0','-10773000','-10773000');
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-250914-0001','D','2025-09-14','15:21:03','DLL','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-250914-0001','D','2025-09-14','15:21:03','BRI','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-250914-0001','D','2025-09-14','15:21:03','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
UPDATE tp_system SET tgl_system='2025-09-14';