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 ('F325280818061','input','1',' MDE2 X LG ','TOKO','PM-E','E2D-YIAC-182-0','CC X MODEL MATA LG 12 8K ','','1.160','1','100.00','1073000','0','0','15000','1073000','0','0','0','1073000','SIN','00369266','E2D','0','0','-','0','925000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIAC-182-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.160',berat_jual_asli=berat_jual_asli+'1.160',stock_jual='1',berat_akhir=berat_akhir-'1.160',berat_akhir_asli=berat_akhir_asli-'1.160',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='E2D-YIAC-182-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 ('F325280818061','2025-09-28','1.160','2025-09-28','08:18:06','PLG0025019','1073000','1073000','0','1073000','1073000','input','2025-09-28 08:18:06','F32528081806');
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-28','F325280818061','2025-09-28','08:18:06','SIN','1073000','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-250928-0002','D','2025-09-28','08:18:06','input','PENJUALAN','F325280818061','66729000','1073000','67802000');
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 ('F325280825281','input','1',' MEF3 HW ','TOKO','PM-F','F3E-YCBX-207-0','GL RANTAI HOLLOW CAPELA VAR HW 8K ','','2.210','1','100.00','2088000','0','0','15000','2088000','0','0','0','2088000','FIT','00344300','F3E','0','0','-','0','945000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YCBX-207-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-09-28' AND kode_barang='F3E-YCBX-207-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 ('F325280825281','2025-09-28','2.210','2025-09-28','08:25:29','PLG0025020','2088000','2088000','0','2088000','2088000','input','2025-09-28 08:25:28','F32528082528');
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-28','F325280825281','2025-09-28','08:25:29','FIT','2088000','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-250928-0003','D','2025-09-28','08:25:29','input','PENJUALAN','F325280825281','67802000','2088000','69890000');
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 ('F325280856381','input','1',' TEA1 X SG ','TOKO','PT-A','A1TE-YHBG-45-T','AT X TINDIK BABY MRICAN SG 17K ','','0.470','1','100.00','785000','0','0','15000','785000','0','0','0','785000','AAT','T0072637','A1TE','0','0','-','0','1670000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TE-YHBG-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='A1TE-YHBG-45-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F325280856381','2025-09-28','0.470','2025-09-28','08:56:38','PLG0025021','785000','785000','0','785000','785000','input','2025-09-28 08:56:38','F32528085638');
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-28','F325280856381','2025-09-28','08:56:38','AAT','785000','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-250928-0004','D','2025-09-28','08:56:38','input','PENJUALAN','F325280856381','69890000','785000','70675000');
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-00017090','X-00017090','CC TEBU DW 22','GR','---','E0TA','BELI','BELI001','2590000','2025-09-28','2.000','1','kasir','2025-09-28 09:30:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-E0TA';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E0TA','X-00017090','X-00017090');
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-250928-0001','F322071252141','AAT','1','BELI','BELI001','E0TA', 'X-00017090', 'CC TEBU DW 22','2.000','2.000','100.00','1420000','2590000','1295000','1595000','1','2590000','2590000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E0TA' 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-250928-0001','2025-09-28','2025-09-28','09:30:28','AAT','---','2.000','2590000','2590000','2590000','2590000','2590000','kasir','2025-09-28 09:30:29','FB-250928-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250928-0001','PANIYEM','JOHO','','','','kasir','2025-09-28 09:30:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-28' 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-250928-0005','K','2025-09-28','09:30:28','kasir','PEMBELIAN UMUM','FB-250928-0001','70675000','2590000','68085000');
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 ('F325280939391','kasir','1',' MEH1 UB ','TOKO','PM-H','H1E-YIBB-114-0','KL SANTA MODEL DAUN VAR UB 8K ','','2.600','1','100.00','2457000','0','0','15000','2458000','0','0','0','2458000','FIT','00370162','H1E','0','0','-','0','945000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YIBB-114-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.600',berat_jual_asli=berat_jual_asli+'2.600',stock_jual='1',berat_akhir=berat_akhir-'2.600',berat_akhir_asli=berat_akhir_asli-'2.600',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='H1E-YIBB-114-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 ('F325280939391','2025-09-28','2.600','2025-09-28','09:39:40','PLG0025022','2458000','2458000','0','2458000','2458000','kasir','2025-09-28 09:39:39','F32528093939');
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-28','F325280939391','2025-09-28','09:39:40','FIT','2458000','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-250928-0006','D','2025-09-28','09:39:40','kasir','PENJUALAN','F325280939391','68085000','2458000','70543000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2458000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325280939391' 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 ('F325280939392','kasir',' 1',' MEF1 X TD ','TOKO','PM-F','F1E-XLBG-81-0','GL X OVAL C GELOMBANG TD 54 8K ','','3.010','1','100.00','2844000','0','0','15000','2845000','0','0','0','2845000','FIT','00331605','F1E','0','0','-','0','945000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-XLBG-81-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='F1E-XLBG-81-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 ('F325280939392','2025-09-28','3.010','2025-09-28','09:39:40','PLG0025023','2845000','2845000','0','2845000','2845000','kasir','2025-09-28 09:39:39','F32528093939');
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-28','F325280939392','2025-09-28','09:39:40','FIT','2845000','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-250928-0007','D','2025-09-28','09:39:40','kasir','PENJUALAN','F325280939392','70543000','2845000','73388000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2845000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325280939392' 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 ('F325280943531','kasir','1',' MEF2 XXX K','TOKO','PM-F','F2E-YABB-209-0','GL XXX PIPA MATA KH 58 8K ','','5.950','1','100.00','5623000','0','0','15000','5623000','0','0','0','5623000','AAT','00335584','F2E','0','0','-','0','945000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YABB-209-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.950',berat_jual_asli=berat_jual_asli+'5.950',stock_jual='1',berat_akhir=berat_akhir-'5.950',berat_akhir_asli=berat_akhir_asli-'5.950',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='F2E-YABB-209-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 ('F325280943531','2025-09-28','5.950','2025-09-28','09:43:53','PLG0025024','5623000','5623000','0','5623000','5623000','kasir','2025-09-28 09:43:53','F32528094353');
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-28','F325280943531','2025-09-28','09:43:53','AAT','5623000','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-250928-0008','D','2025-09-28','09:43:53','kasir','PENJUALAN','F325280943531','73388000','5623000','79011000');
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 ('F325280954091','kasir','1',' MEE2 CM 18','TOKO','PM-E','E2E-YIBB-138-0','CC MODEL MATA VAR CM 18 8K ','','0.650','1','100.00','614000','0','0','15000','615000','0','0','0','615000','FIT','00370186','E2E','0','0','-','0','945000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YIBB-138-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-28' AND kode_barang='E2E-YIBB-138-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 ('F325280954091','2025-09-28','0.650','2025-09-28','09:54:10','PLG0025025','615000','615000','0','615000','615000','kasir','2025-09-28 09:54:09','F32528095409');
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-28','F325280954091','2025-09-28','09:54:10','FIT','615000','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-250928-0009','D','2025-09-28','09:54:10','kasir','PENJUALAN','F325280954091','79011000','615000','79626000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='615000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325280954091' 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 ('F325280954092','kasir',' 1',' MDE1 CM 24','TOKO','PM-E','E1D-XJBD-321-0','CC WEDDING POLOS CM 24 8K ','','2.030','1','100.00','1878000','0','0','15000','1878000','0','0','0','1878000','FIT','00323613','E1D','0','0','-','0','925000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-XJBD-321-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='E1D-XJBD-321-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 ('F325280954092','2025-09-28','2.030','2025-09-28','09:54:10','PLG0025026','1878000','1878000','0','1878000','1878000','kasir','2025-09-28 09:54:09','F32528095409');
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-28','F325280954092','2025-09-28','09:54:10','FIT','1878000','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-250928-0010','D','2025-09-28','09:54:10','kasir','PENJUALAN','F325280954092','79626000','1878000','81504000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1878000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325280954092' 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 ('F325281005231','kasir','1',' MEA1E X BW','TOKO','PM-A','A1E-YIAE-17-0','AT X ITALY SLEP VAR BW 8K ','','0.530','1','100.00','501000','0','0','15000','500000','0','0','0','500000','SIN','00369468','A1E','0','0','-','1','945000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YIAE-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='A1E-YIAE-17-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 ('F325281005231','2025-09-28','0.530','2025-09-28','10:05:23','PLG0025027','500000','500000','0','500000','500000','kasir','2025-09-28 10:05:23','F32528100523');
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-28','F325281005231','2025-09-28','10:05:23','SIN','500000','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-250928-0011','D','2025-09-28','10:05:23','kasir','PENJUALAN','F325281005231','81504000','500000','82004000');
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 ('F325281026231','kasir','1',' MJH3 X KH ','TOKO','PM-H','H3J-YIAE-271-0','KL X SANTA MATA VAR KH 42 9K ','','3.050','1','100.00','3187000','0','0','15000','3188000','0','0','0','3188000','AAT','00369722','H3J','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H3J-YIAE-271-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='H3J-YIAE-271-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 ('F325281026231','2025-09-28','3.050','2025-09-28','10:26:24','PLG0025028','3188000','3188000','0','3188000','3188000','kasir','2025-09-28 10:26:23','F32528102623');
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-28','F325281026231','2025-09-28','10:26:24','AAT','3188000','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-250928-0012','D','2025-09-28','10:26:24','kasir','PENJUALAN','F325281026231','82004000','3188000','85192000');
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 ('F325281059071','kasir','1',' MEF3E X LT','TOKO','PM-F','F3E-YIBD-184-0','GL X VERONICA SLEP LT 8K ','','1.020','1','100.00','964000','0','0','15000','965000','0','0','0','965000','SIN','00370605','F3E','0','0','-','0','945000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIBD-184-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='F3E-YIBD-184-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 ('F325281059071','2025-09-28','1.020','2025-09-28','10:59:08','PLG0025029','965000','965000','0','965000','965000','kasir','2025-09-28 10:59:07','F32528105907');
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-28','F325281059071','2025-09-28','10:59:08','SIN','965000','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-250928-0013','D','2025-09-28','10:59:08','kasir','PENJUALAN','F325281059071','85192000','965000','86157000');
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-00017091','X-00017091','GL SANTA SERUT MODEL PITA MATA VAR UB 8K','GR','---','F3E','BELI','BELI001','1235000','2025-09-28','1.830','1','kasir','2025-09-28 11:32:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017091','X-00017091');
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-250928-0002','F325250129412','FIT','1','BELI','BELI001','F3E', 'X-00017091', 'GL SANTA SERUT MODEL PITA MATA VAR UB 8K','1.930','1.830','100.00','1602000','1235000','674863','945000','1','1235000','1235000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.830',berat_beli_asli=berat_beli_asli+'1.830',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.830',berat_akhir_asli=berat_akhir_asli+'1.830',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-28' 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-250928-0002','2025-09-28','2025-09-28','11:32:06','FIT','---','1.830','1235000','1235000','1235000','1235000','1235000','kasir','2025-09-28 11:32:06','FB-250928-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250928-0002','FITRIA','JERUK PACITAN','','','','kasir','2025-09-28 11:32:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-28' 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-250928-0014','K','2025-09-28','11:32:06','kasir','PEMBELIAN UMUM','FB-250928-0002','86157000','1235000','84922000');
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-00017092','X-00017092','AT COR 8K','GR','---','A1F','BELI','BELI001','340000','2025-09-28','0.550','1','kasir','2025-09-28 11:33:58');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00017092','X-00017092');
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-250928-0003','F323290956221','SIN','1','BELI','BELI001','A1F', 'X-00017092', 'AT COR 8K','0.830','0.550','100.00','413000','340000','618182','965000','1','340000','340000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-28' 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-250928-0003','2025-09-28','2025-09-28','11:33:58','SIN','---','0.550','340000','340000','340000','340000','340000','kasir','2025-09-28 11:33:58','FB-250928-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250928-0003','FRIDA','POKSAWIT BADEGAN','','','','kasir','2025-09-28 11:33:58');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-28' 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-250928-0015','K','2025-09-28','11:33:58','kasir','PEMBELIAN UMUM','FB-250928-0003','84922000','340000','84582000');
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-00017093','X-00017093','AT X TINDIK BABY DW 17K','GR','---','A0TA','BELI','BELI001','680000','2025-09-28','0.500','1','kasir','2025-09-28 11:35:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-A0TA';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A0TA','X-00017093','X-00017093');
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-250928-0004','F324011020261','FIT','1','BELI','BELI001','A0TA', 'X-00017093', 'AT X TINDIK BABY DW 17K','0.500','0.500','100.00','490000','680000','1360000','1595000','1','680000','680000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A0TA' 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-250928-0004','2025-09-28','2025-09-28','11:35:09','FIT','---','0.500','680000','680000','680000','680000','680000','kasir','2025-09-28 11:35:10','FB-250928-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250928-0004','SUGENG','WATU BONANG','','','','kasir','2025-09-28 11:35:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-28' 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-250928-0016','K','2025-09-28','11:35:09','kasir','PEMBELIAN UMUM','FB-250928-0004','84582000','680000','83902000');
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-00017094','X-00017094','LT X SLOBOK BULAT HURUF BG A 17K','GR','---','D1TF','BELI','BELI001','1105000','2025-09-28','0.810','1','kasir','2025-09-28 11:35:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1TF','X-00017094','X-00017094');
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-250928-0005','F324240222541','AAT','1','BELI','BELI001','D1TF', 'X-00017094', 'LT X SLOBOK BULAT HURUF BG A 17K','0.810','0.810','100.00','940000','1105000','1364198','1690000','1','1105000','1105000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.810',berat_beli_asli=berat_beli_asli+'0.810',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.810',berat_akhir_asli=berat_akhir_asli+'0.810',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1TF' 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-250928-0005','2025-09-28','2025-09-28','11:35:48','AAT','---','0.810','1105000','1105000','1105000','1105000','1105000','kasir','2025-09-28 11:35:48','FB-250928-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250928-0005','RARA','WATUBONANG BADEGAN','','','','kasir','2025-09-28 11:35:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-28' 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-250928-0017','K','2025-09-28','11:35:48','kasir','PEMBELIAN UMUM','FB-250928-0005','83902000','1105000','82797000');
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-00017095','X-00017095','AT KLIP BANGKOK SLEP LG 8K','GR','---','A1E','BELI','BELI001','360000','2025-09-28','0.560','1','kasir','2025-09-28 11:36:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00017095','X-00017095');
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-250928-0006','F324170110081','AAT','1','BELI','BELI001','A1E', 'X-00017095', 'AT KLIP BANGKOK SLEP LG 8K','0.560','0.560','100.00','275000','360000','642857','945000','1','360000','360000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.560',berat_beli_asli=berat_beli_asli+'0.560',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.560',berat_akhir_asli=berat_akhir_asli+'0.560',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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-250928-0006','2025-09-28','2025-09-28','11:36:13','AAT','---','0.560','360000','360000','360000','360000','360000','kasir','2025-09-28 11:36:13','FB-250928-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250928-0006','AUBRI','PAGER SARI SUMBER','','','','kasir','2025-09-28 11:36:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-28' 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-250928-0018','K','2025-09-28','11:36:13','kasir','PEMBELIAN UMUM','FB-250928-0006','82797000','360000','82437000');
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-00017096','X-00017096','CC X BANGKOK SLEP BW 10','GR','---','E1E','BELI','BELI001','375000','2025-09-28','0.580','1','kasir','2025-09-28 11:39:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00017096','X-00017096');
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-250928-0007','F324180847151','AAT','1','BELI','BELI001','E1E', 'X-00017096', 'CC X BANGKOK SLEP BW 10','0.580','0.580','100.00','348000','375000','646552','945000','1','375000','375000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.580',berat_beli_asli=berat_beli_asli+'0.580',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.580',berat_akhir_asli=berat_akhir_asli+'0.580',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-250928-0007','2025-09-28','2025-09-28','11:39:48','AAT','---','0.580','375000','375000','375000','375000','375000','kasir','2025-09-28 11:39:48','FB-250928-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250928-0007','AUBREY','SUMBER SENDANG','','','','kasir','2025-09-28 11:39:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-28' 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-250928-0019','K','2025-09-28','11:39:48','kasir','PEMBELIAN UMUM','FB-250928-0007','82437000','375000','82062000');
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-00017097','X-00017097','CC MODEL CAT SLEP BM14 8K','GR','---','E1D','BELI','BELI001','675000','2025-09-28','1.000','1','kasir','2025-09-28 11:40:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00017097','X-00017097');
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-250928-0008','F325270214381','AAT','1','BELI','BELI001','E1D', 'X-00017097', 'CC MODEL CAT SLEP BM14 8K','1.000','1.000','100.00','727000','675000','675000','925000','1','675000','675000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' 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-250928-0008','2025-09-28','2025-09-28','11:40:13','AAT','---','1.000','675000','675000','675000','675000','675000','kasir','2025-09-28 11:40:13','FB-250928-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250928-0008','NUR DWI JAYANTI','BULUKERTO','','','','kasir','2025-09-28 11:40:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-28' 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-250928-0020','K','2025-09-28','11:40:13','kasir','PEMBELIAN UMUM','FB-250928-0008','82062000','675000','81387000');
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-00017098','X-00017098','AT TINDIK BABY LG 17K','GR','---','A1TE','BELI','BELI001','767000','2025-09-28','0.570','1','kasir','2025-09-28 11:41:11');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1TE','X-00017098','X-00017098');
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-250928-0009','F325080944221','FIT','1','BELI','BELI001','A1TE', 'X-00017098', 'AT TINDIK BABY LG 17K','0.570','0.570','100.00','835000','767000','1345614','1670000','1','767000','767000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.570',berat_beli_asli=berat_beli_asli+'0.570',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.570',berat_akhir_asli=berat_akhir_asli+'0.570',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-28' 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-250928-0009','2025-09-28','2025-09-28','11:41:10','FIT','---','0.570','767000','767000','767000','767000','767000','kasir','2025-09-28 11:41:11','FB-250928-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250928-0009','KEINARA','JOHO PURWANTORO','','','','kasir','2025-09-28 11:41:11');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-28' 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-250928-0021','K','2025-09-28','11:41:10','kasir','PEMBELIAN UMUM','FB-250928-0009','81387000','767000','80620000');
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-00017099','X-00017099','CC COR M 17K','GR','---','E2TE','BELI','BELI001','2405000','2025-09-28','1.980','1','kasir','2025-09-28 11:42:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00017099','X-00017099');
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-250928-0010','F323251117021','AAT','1','BELI','BELI001','E2TE', 'X-00017099', 'CC COR M 17K','198.000','1.980','100.00','1575000','2405000','1214646','1670000','1','2405000','2405000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.980',berat_beli_asli=berat_beli_asli+'1.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.980',berat_akhir_asli=berat_akhir_asli+'1.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-28' 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-250928-0010','2025-09-28','2025-09-28','11:42:35','AAT','---','1.980','2405000','2405000','2405000','2405000','2405000','kasir','2025-09-28 11:42:35','FB-250928-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250928-0010','DITA','PAKIS BARU','','','','kasir','2025-09-28 11:42:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-28' 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-250928-0022','K','2025-09-28','11:42:35','kasir','PEMBELIAN UMUM','FB-250928-0010','80620000','2405000','78215000');
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-00017100','X-00017100','LT BONEKA ANAK CAT AY','GR','---','D1F','BELI','BELI001','375000','2025-09-28','0.690','1','kasir','2025-09-28 11:44:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00017100','X-00017100');
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-250928-0011','F322011249232','FIT','1','BELI','BELI001','D1F', 'X-00017100', 'LT BONEKA ANAK CAT AY','0.710','0.690','100.00','295000','375000','543478','965000','1','375000','375000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.690',berat_beli_asli=berat_beli_asli+'0.690',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.690',berat_akhir_asli=berat_akhir_asli+'0.690',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1F' 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-250928-0011','2025-09-28','2025-09-28','11:44:48','FIT','---','0.690','375000','375000','375000','375000','375000','kasir','2025-09-28 11:44:49','FB-250928-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250928-0011','ALYA','JERUK','','','','kasir','2025-09-28 11:44:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-28' 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-250928-0023','K','2025-09-28','11:44:48','kasir','PEMBELIAN UMUM','FB-250928-0011','78215000','375000','77840000');
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-00017101','X-00017101','KL X MILANO ANAK KH 32CM','GR','---','H2J','BELI','BELI001','2205000','2025-09-28','3.050','1','kasir','2025-09-28 11:44:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00017101','X-00017101');
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-250928-0012','F322011249231','FIT','2','BELI','BELI001','H2J', 'X-00017101', 'KL X MILANO ANAK KH 32CM','3.050','3.050','100.00','1385000','2205000','722951','1045000','1','2205000','2205000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.050',berat_beli_asli=berat_beli_asli+'3.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.050',berat_akhir_asli=berat_akhir_asli+'3.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2J' 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-250928-0012','2025-09-28','2025-09-28','11:44:48','FIT','---','3.050','2205000','2205000','2205000','2205000','2205000','kasir','2025-09-28 11:44:49','FB-250928-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250928-0012','ALYA','JERUK','','','','kasir','2025-09-28 11:44:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-28' 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-250928-0024','K','2025-09-28','11:44:48','kasir','PEMBELIAN UMUM','FB-250928-0012','77840000','2205000','75635000');
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-00017102','X-00017102','CC MODEL KUPU MATA CAT VAR CM 16 8K','GR','---','E2E','BELI','BELI001','475000','2025-09-28','0.830','1','kasir','2025-09-28 11:45:07');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017102','X-00017102');
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-250928-0013','F324281109032','AAT','1','BELI','BELI001','E2E', 'X-00017102', 'CC MODEL KUPU MATA CAT VAR CM 16 8K','0.830','0.830','100.00','505000','475000','572289','945000','1','475000','475000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.830',berat_beli_asli=berat_beli_asli+'0.830',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.830',berat_akhir_asli=berat_akhir_asli+'0.830',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-250928-0013','2025-09-28','2025-09-28','11:45:07','AAT','---','0.830','475000','475000','475000','475000','475000','kasir','2025-09-28 11:45:07','FB-250928-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250928-0013','LINA','GOLOSEMPON','','','','kasir','2025-09-28 11:45:07');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-28' 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-250928-0025','K','2025-09-28','11:45:07','kasir','PEMBELIAN UMUM','FB-250928-0013','75635000','475000','75160000');
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 ('F325281207411','kasir','1',' MJH3 X UB ','TOKO','PM-H','H3J-YHAI-114-0','KL X SANTA BONEKA ANAK CAT UB 34 9K ','','2.610','1','100.00','2727000','0','0','15000','2728000','0','0','0','2728000','AAT','00366145','H3J','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H3J-YHAI-114-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.610',berat_jual_asli=berat_jual_asli+'2.610',stock_jual='1',berat_akhir=berat_akhir-'2.610',berat_akhir_asli=berat_akhir_asli-'2.610',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='H3J-YHAI-114-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 ('F325281207411','2025-09-28','2.610','2025-09-28','12:07:41','PLG0025030','2728000','2728000','0','2728000','2728000','kasir','2025-09-28 12:07:41','F32528120741');
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-28','F325281207411','2025-09-28','12:07:41','AAT','2728000','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-250928-0026','D','2025-09-28','12:07:41','kasir','PENJUALAN','F325281207411','75160000','2728000','77888000');
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 ('F325281210181','kasir','1',' MEF3 PM ','TOKO','PM-F','F3E-YHBE-39-0','GL KREPYAK MODEL SLEP VAR PM 8K ','','4.620','1','100.00','4366000','0','0','15000','4320000','0','0','0','4320000','SIN','00366849','F3E','0','0','-','1','945000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHBE-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.620',berat_jual_asli=berat_jual_asli+'4.620',stock_jual='1',berat_akhir=berat_akhir-'4.620',berat_akhir_asli=berat_akhir_asli-'4.620',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='F3E-YHBE-39-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 ('F325281210181','2025-09-28','4.620','2025-09-28','12:10:18','PLG0025031','4320000','4320000','0','4320000','4320000','kasir','2025-09-28 12:10:18','F32528121018');
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-28','F325281210181','2025-09-28','12:10:18','SIN','4320000','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-250928-0027','D','2025-09-28','12:10:18','kasir','PENJUALAN','F325281210181','77888000','4320000','82208000');
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-00017103','X-00017103','GL LEMES 8K','GR','---','F3E','BELI','BELI001','2450000','2025-09-28','3.650','1','kasir','2025-09-28 12:23:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017103','X-00017103');
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-250928-0014','F323301215541','SIN','1','BELI','BELI001','F3E', 'X-00017103', 'GL LEMES 8K','3.650','3.650','100.00','1807000','2450000','671233','945000','1','2450000','2450000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.650',berat_beli_asli=berat_beli_asli+'3.650',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.650',berat_akhir_asli=berat_akhir_asli+'3.650',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-28' 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-250928-0014','2025-09-28','2025-09-28','12:23:22','SIN','---','3.650','2450000','2450000','2450000','2450000','2450000','kasir','2025-09-28 12:23:23','FB-250928-0014');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250928-0014','HETIK','MADE SLOGOHIMO','','','','kasir','2025-09-28 12:23:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-28' 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-250928-0028','K','2025-09-28','12:23:22','kasir','PEMBELIAN UMUM','FB-250928-0014','82208000','2450000','79758000');
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-00017104','X-00017104','GW COR 8K','GR','---','B1E','BELI','BELI001','750000','2025-09-28','1.300','1','kasir','2025-09-28 13:21:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00017104','X-00017104');
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-250928-0015','F321061046061','FIT','1','BELI','BELI001','B1E', 'X-00017104', 'GW COR 8K','1.300','1.300','100.00','530000','750000','576923','945000','1','750000','750000','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-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' 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-250928-0015','2025-09-28','2025-09-28','13:21:53','FIT','---','1.300','750000','750000','750000','750000','750000','kasir','2025-09-28 13:21:54','FB-250928-0015');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250928-0015','EKA MARYUNI','SOCO SLOGOHIMO','','','','kasir','2025-09-28 13:21:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-28' 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-250928-0029','K','2025-09-28','13:21:53','kasir','PEMBELIAN UMUM','FB-250928-0015','79758000','750000','79008000');
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 ('F325280200151','kasir','1',' MEF3 UB ','TOKO','PM-F','F3E-YGBB-150-0','GL KREPYAK MODEL SLEP VAR UB 8K ','','5.140','1','100.00','4857000','0','0','15000','4858000','0','0','0','4858000','SIN','00362159','F3E','0','0','-','0','945000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YGBB-150-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.140',berat_jual_asli=berat_jual_asli+'5.140',stock_jual='1',berat_akhir=berat_akhir-'5.140',berat_akhir_asli=berat_akhir_asli-'5.140',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='F3E-YGBB-150-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 ('F325280200151','2025-09-28','5.140','2025-09-28','14:00:15','PLG0025032','4858000','4858000','0','4858000','4858000','kasir','2025-09-28 14:00:15','F32528020015');
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-28','F325280200151','2025-09-28','14:00:15','SIN','4858000','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-250928-0030','D','2025-09-28','14:00:15','kasir','PENJUALAN','F325280200151','79008000','4858000','83866000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4858000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325280200151' 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 ('F325280200152','kasir',' 1',' MDE2 CM 16','TOKO','PM-E','E2D-YIBB-133-0','CC MODEL MATA VAR CM 16 8K ','','1.070','1','100.00','990000','0','0','15000','990000','0','0','0','990000','SIN','00370181','E2D','0','0','-','0','925000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIBB-133-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='E2D-YIBB-133-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 ('F325280200152','2025-09-28','1.070','2025-09-28','14:00:15','PLG0025033','990000','990000','0','990000','990000','kasir','2025-09-28 14:00:15','F32528020015');
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-28','F325280200152','2025-09-28','14:00:15','SIN','990000','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-250928-0031','D','2025-09-28','14:00:15','kasir','PENJUALAN','F325280200152','83866000','990000','84856000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='990000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325280200152' 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 ('F325280200153','kasir',' 1',' MDE2 X PM ','TOKO','PM-E','E2D-YIBD-387-0','CC X MODEL MATA PM 14 8K ','','1.060','1','100.00','980000','0','0','15000','980000','0','0','0','980000','SIN','00370808','E2D','0','0','-','0','925000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIBD-387-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='E2D-YIBD-387-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 ('F325280200153','2025-09-28','1.060','2025-09-28','14:00:15','PLG0025034','980000','980000','0','980000','980000','kasir','2025-09-28 14:00:15','F32528020015');
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-28','F325280200153','2025-09-28','14:00:15','SIN','980000','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-250928-0032','D','2025-09-28','14:00:15','kasir','PENJUALAN','F325280200153','84856000','980000','85836000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='980000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325280200153' 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 ('F325280202101','kasir','1',' MEF3 HW ','TOKO','PM-F','F3E-YDAB-69-0','GL MODEL FANCY VAR HW 8K ','','3.400','1','100.00','3213000','0','0','15000','3213000','0','0','0','3213000','FIT','00349217','F3E','0','0','-','0','945000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YDAB-69-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.400',berat_jual_asli=berat_jual_asli+'3.400',stock_jual='1',berat_akhir=berat_akhir-'3.400',berat_akhir_asli=berat_akhir_asli-'3.400',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='F3E-YDAB-69-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 ('F325280202101','2025-09-28','3.400','2025-09-28','14:02:10','PLG0025035','3213000','3213000','0','3213000','3213000','kasir','2025-09-28 14:02:10','F32528020210');
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-28','F325280202101','2025-09-28','14:02:10','FIT','3213000','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-250928-0033','D','2025-09-28','14:02:10','kasir','PENJUALAN','F325280202101','85836000','3213000','89049000');
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-00017105','X-00017105','AT X WG HUGGIES MATA VAR UB','GR','---','PAG','BELI','BELI001','980000','2025-09-28','1.550','1','kasir','2025-09-28 14:15:11');
DELETE FROM tp_barang WHERE kode_dept = 'X-PAG';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-PAG','X-00017105','X-00017105');
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-250928-0016','F324120936491','FIT','1','BELI','BELI001','PAG', 'X-00017105', 'AT X WG HUGGIES MATA VAR UB','1.550','1.550','100.00','963000','980000','632258','961000','1','980000','980000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.550',berat_beli_asli=berat_beli_asli+'1.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.550',berat_akhir_asli=berat_akhir_asli+'1.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='PAG' 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-250928-0016','2025-09-28','2025-09-28','14:15:11','FIT','---','1.550','980000','980000','980000','980000','980000','kasir','2025-09-28 14:15:11','FB-250928-0016');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250928-0016','SIWI','BULUKERTO','','','','kasir','2025-09-28 14:15:11');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-28' 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-250928-0034','K','2025-09-28','14:15:11','kasir','PEMBELIAN UMUM','FB-250928-0016','89049000','980000','88069000');
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 ('F325280253311','kasir','1',' MJH2 X KH ','TOKO','PM-H','H2J-YHBH-91-0','KL X MILANO KH 44 9K ','','2.840','1','100.00','2968000','0','0','15000','2968000','0','0','0','2968000','AAT','00367077','H2J','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YHBH-91-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.840',berat_jual_asli=berat_jual_asli+'2.840',stock_jual='1',berat_akhir=berat_akhir-'2.840',berat_akhir_asli=berat_akhir_asli-'2.840',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='H2J-YHBH-91-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 ('F325280253311','2025-09-28','2.840','2025-09-28','14:53:32','PLG0025036','2968000','2968000','0','2968000','2968000','kasir','2025-09-28 14:53:31','F32528025331');
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-28','F325280253311','2025-09-28','14:53:32','AAT','2968000','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-250928-0035','D','2025-09-28','14:53:32','kasir','PENJUALAN','F325280253311','88069000','2968000','91037000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2968000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325280253311' 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 ('F325280253312','kasir',' 1',' MED2E LG R','TOKO','PM-D','D2E-YIXD-205-0','LT MODEL HURUF MATA LG R 8K ','','0.580','1','100.00','548000','0','0','15000','549000','0','0','0','549000','AAT','00367962','D2E','0','0','-','0','945000');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YIXD-205-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='D2E-YIXD-205-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 ('F325280253312','2025-09-28','0.580','2025-09-28','14:53:32','PLG0025037','549000','549000','0','549000','549000','kasir','2025-09-28 14:53:31','F32528025331');
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-28','F325280253312','2025-09-28','14:53:32','AAT','549000','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-250928-0036','D','2025-09-28','14:53:32','kasir','PENJUALAN','F325280253312','91037000','549000','91586000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='549000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325280253312' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325280200151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325280200151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325280200151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325280200152' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325280200152' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325280200152';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325280200153' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325280200153' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325280200153';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325280202101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325280202101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325280202101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325280253311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325280253311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325280253311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325280253312' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325280253312' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325280253312';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325280818061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325280818061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325280818061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325280825281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325280825281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325280825281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325280856381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325280856381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325280856381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325280939391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325280939391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325280939391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325280939392' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325280939392' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325280939392';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325280943531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325280943531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325280943531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325280954091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325280954091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325280954091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325280954092' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325280954092' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325280954092';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325281005231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325281005231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325281005231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325281026231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325281026231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325281026231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325281059071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325281059071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325281059071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325281207411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325281207411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325281207411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325281210181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325281210181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325281210181';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250928-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250928-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250928-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250928-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250928-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250928-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250928-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250928-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250928-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250928-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250928-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250928-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250928-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250928-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250928-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250928-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250928-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250928-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250928-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250928-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250928-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250928-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250928-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250928-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250928-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250928-0013';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250928-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250928-0014';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250928-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250928-0015';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250928-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250928-0016';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-29','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-29';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-28';
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-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-28';
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-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-28' 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-250929-0001','D','2025-09-29','15:26:03','SYSTEM','SALDO AWAL','SALDO AWAL','0','91586000','91586000');
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-250929-0001','D','2025-09-29','15:26:03','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
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-250929-0001','D','2025-09-29','15:26: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-250929-0001','D','2025-09-29','15:26:03','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-09-29';