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-00004774','X-00004774','AT X MODEL ARESO MATA VAR CM 8K','GR','---','A1E','BELI','BELI001','680000','2025-10-25','0.700','1','kasir','2025-10-25 07:57:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00004774','X-00004774');
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-251025-0001','F225220211241','TIN','1','BELI','BELI001','A1E', 'X-00004774', 'AT X MODEL ARESO MATA VAR CM 8K','0.700','0.700','100.00','760000','680000','971429','1060000','1','680000','680000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.700',berat_beli_asli=berat_beli_asli+'0.700',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.700',berat_akhir_asli=berat_akhir_asli+'0.700',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' 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-251025-0001','2025-10-25','2025-10-25','07:57:20','TIN','---','0.700','680000','680000','680000','680000','680000','kasir','2025-10-25 07:57:21','FB-251025-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0001','WAHYU','PONOROGO','','','','kasir','2025-10-25 07:57:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' 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-251025-0002','K','2025-10-25','07:57:20','kasir','PEMBELIAN UMUM','FB-251025-0001','1867651000','680000','1866971000');
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 ('F225250836111','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-YIBB-35-T','GL OVAL MODEL C TD D52 8K ','OL','4.590','1','100.00','4819000','0','0','15000','4912000','0','23000','0','4935000','RTA','T0073171','F1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YIBB-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.590',berat_jual_asli=berat_jual_asli+'4.590',stock_jual='1',berat_akhir=berat_akhir-'4.590',berat_akhir_asli=berat_akhir_asli-'4.590',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='F1E-YIBB-35-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225250836111','2025-10-25','4.590','2025-10-25','08:36:12','PLG0074021','4912000','4912000','23000','4935000','4935000','kasir','2025-10-25 08:36:11','F22525083611');
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-10-25','F225250836111','2025-10-25','08:36:12','RTA','4935000','23000');
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-251025-0003','D','2025-10-25','08:36:12','kasir','PENJUALAN','F225250836111','1866971000','4935000','1871906000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4935000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250836111' 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 ('F225250836112','kasir',' 1',' MEF1 TD D6','TOKO','SMBK-F','F1E-YHBE-22-T','GL OVAL MODEL C TD D60 8K ','OL','5.140','1','100.00','5397000','0','0','15000','5500000','0','26000','0','5526000','RTA','T0072507','F1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YHBE-22-T' 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-10-25' AND kode_barang='F1E-YHBE-22-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225250836112','2025-10-25','5.140','2025-10-25','08:36:12','PLG0074022','5500000','5500000','26000','5526000','5526000','kasir','2025-10-25 08:36:11','F22525083611');
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-10-25','F225250836112','2025-10-25','08:36:12','RTA','5526000','26000');
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-251025-0004','D','2025-10-25','08:36:12','kasir','PENJUALAN','F225250836112','1871906000','5526000','1877432000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5526000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250836112' 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 ('F225250905141','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-YCBF-95-T','GL MODEL FANCY VAR UB 8K ','','1.930','1','100.00','2026000','0','0','15000','2046000','0','0','0','2046000','TJ','T0068270','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YCBF-95-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='F3E-YCBF-95-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225250905141','2025-10-25','1.930','2025-10-25','09:05:14','PLG0074023','2046000','2046000','0','2046000','2046000','kasir','2025-10-25 09:05:14','F22525090514');
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-10-25','F225250905141','2025-10-25','09:05:14','TJ','2046000','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-251025-0005','D','2025-10-25','09:05:14','kasir','PENJUALAN','F225250905141','1877432000','2046000','1879478000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2046000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250905141' 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 ('F225250905142','kasir',' 1',' MDE1D PM 1','TOKO','SMBK-E','E1D-YJAH-25-T','CC MODEL DAUN SLEP PM 16 8K ','','0.980','1','100.00','1009000','0','0','15000','1020000','0','0','0','1020000','TJ','T0074238','E1D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJAH-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E1D-YJAH-25-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225250905142','2025-10-25','0.980','2025-10-25','09:05:14','PLG0074024','1020000','1020000','0','1020000','1020000','kasir','2025-10-25 09:05:14','F22525090514');
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-10-25','F225250905142','2025-10-25','09:05:14','TJ','1020000','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-251025-0006','D','2025-10-25','09:05:14','kasir','PENJUALAN','F225250905142','1879478000','1020000','1880498000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1020000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250905142' 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 ('F225250921161','kasir','1',' MEE2 X CM ','TOKO','SMBK-E','E2E-YFBA-140-0','CC X MODEL SOLITAIRE CM 8 8K ','','0.660','1','100.00','693000','0','0','15000','700000','0','0','0','700000','RHM','00358414','E2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YFBA-140-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E2E-YFBA-140-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225250921161','2025-10-25','0.660','2025-10-25','09:21:17','PLG0074025','700000','700000','0','700000','700000','kasir','2025-10-25 09:21:16','F22525092116');
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-10-25','F225250921161','2025-10-25','09:21:17','RHM','700000','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-251025-0007','D','2025-10-25','09:21:17','kasir','PENJUALAN','F225250921161','1880498000','700000','1881198000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='700000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250921161' 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 ('F225250921162','kasir',' 1',' MDE1 CM 10','TOKO','SMBK-E','E1D-YJXA-68-T','CC MODEL DAUN VAR CM 10 8K ','','1.030','1','100.00','1061000','0','0','15000','1071000','0','0','0','1071000','RHM','T0073560','E1D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJXA-68-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E1D-YJXA-68-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225250921162','2025-10-25','1.030','2025-10-25','09:21:17','PLG0074026','1071000','1071000','0','1071000','1071000','kasir','2025-10-25 09:21:16','F22525092116');
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-10-25','F225250921162','2025-10-25','09:21:17','RHM','1071000','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-251025-0008','D','2025-10-25','09:21:17','kasir','PENJUALAN','F225250921162','1881198000','1071000','1882269000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1071000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250921162' 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 ('F225251025491','kasir','1',' MDA1D X LG','TOKO','SMBK-A','A1D-YIBC-282-0','AT X DAISY MATA LG 8K ','OL','1.010','1','100.00','1040000','0','0','15000','1071000','0','10000','0','1081000','TJ','00370253','A1D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YIBC-282-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-10-25' AND kode_barang='A1D-YIBC-282-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251025491','2025-10-25','1.010','2025-10-25','10:25:49','PLG0074027','1071000','1071000','10000','1081000','1081000','kasir','2025-10-25 10:25:49','F22525102549');
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-10-25','F225251025491','2025-10-25','10:25:49','TJ','1081000','10000');
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-251025-0009','D','2025-10-25','10:25:49','kasir','PENJUALAN','F225251025491','1882269000','1081000','1883350000');
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 ('F225251026381','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YHBI-107-0','CC X MODEL MATA CM 14 8K ','','0.900','1','100.00','927000','0','0','15000','936000','0','0','0','936000','TIN','00367348','E2D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YHBI-107-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E2D-YHBI-107-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251026381','2025-10-25','0.900','2025-10-25','10:26:38','PLG0074028','936000','936000','0','936000','936000','kasir','2025-10-25 10:26:38','F22525102638');
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-10-25','F225251026381','2025-10-25','10:26:38','TIN','936000','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-251025-0010','D','2025-10-25','10:26:38','kasir','PENJUALAN','F225251026381','1883350000','936000','1884286000');
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 ('F225251035521','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YJXB-76-T','LT SLOBOK BOLA KRAWANG BG 8K ','','0.300','1','100.00','327000','0','0','15000','330000','0','5000','0','335000','RTA','T0073656','D1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJXB-76-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='D1G-YJXB-76-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251035521','2025-10-25','0.300','2025-10-25','10:35:53','PLG0074029','330000','330000','5000','335000','335000','kasir','2025-10-25 10:35:52','F22525103552');
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-10-25','F225251035521','2025-10-25','10:35:53','RTA','335000','5000');
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-251025-0011','D','2025-10-25','10:35:53','kasir','PENJUALAN','F225251035521','1884286000','335000','1884621000');
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 ('F225251058011','kasir','1',' MFE1 LG ','TOKO','SMBK-E','E1F-YBAE-216-T','CC OSROT BABY PLAT GRAFIR LG 8K ','','0.530','1','100.00','567000','0','0','15000','572000','0','0','0','572000','TIN','T0067070','E1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-YBAE-216-T' 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-10-25' AND kode_barang='E1F-YBAE-216-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251058011','2025-10-25','0.530','2025-10-25','10:58:01','PLG0074030','572000','572000','0','572000','572000','kasir','2025-10-25 10:58:01','F22525105801');
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-10-25','F225251058011','2025-10-25','10:58:01','TIN','572000','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-251025-0012','D','2025-10-25','10:58:01','kasir','PENJUALAN','F225251058011','1884621000','572000','1885193000');
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 ('F225251109321','kasir','1',' MDA1D 5K L','TOKO','SMBK-A','A1D-YJAH-43-T','AT BANGKOK SLEP LG 8K ','OL','0.990','1','100.00','1020000','0','0','15000','1060000','0','5000','0','1065000','RTA','T0074256','A1D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YJAH-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.990',berat_jual_asli=berat_jual_asli+'0.990',stock_jual='1',berat_akhir=berat_akhir-'0.990',berat_akhir_asli=berat_akhir_asli-'0.990',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='A1D-YJAH-43-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251109321','2025-10-25','0.990','2025-10-25','11:09:33','PLG0074031','1060000','1060000','5000','1065000','1065000','kasir','2025-10-25 11:09:32','F22525110932');
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-10-25','F225251109321','2025-10-25','11:09:33','RTA','1065000','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-251025-0013','D','2025-10-25','11:09:33','kasir','PENJUALAN','F225251109321','1885193000','1065000','1886258000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1065000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251109321' 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 ('F225251109322','kasir',' 1',' MEA1E LG ','TOKO','SMBK-A','A1E-YJAH-46-T','AT BANGKOK SLEP LG 8K ','OL','0.520','1','100.00','546000','0','0','15000','560000','0','5000','0','565000','RTA','T0074259','A1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJAH-46-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='A1E-YJAH-46-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251109322','2025-10-25','0.520','2025-10-25','11:09:33','PLG0074032','560000','560000','5000','565000','565000','kasir','2025-10-25 11:09:32','F22525110932');
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-10-25','F225251109322','2025-10-25','11:09:33','RTA','565000','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-251025-0014','D','2025-10-25','11:09:33','kasir','PENJUALAN','F225251109322','1886258000','565000','1886823000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='565000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251109322' 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 ('F225251131441','kasir','1',' MEE1 X UB ','TOKO','SMBK-E','E1E-YJBC-168-0','CC X MODEL SLEP UB 14 8K ','','0.440','1','100.00','466000','0','0','15000','466000','0','0','0','466000','TIN','00374486','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJBC-168-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.440',berat_jual_asli=berat_jual_asli+'0.440',stock_jual='1',berat_akhir=berat_akhir-'0.440',berat_akhir_asli=berat_akhir_asli-'0.440',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E1E-YJBC-168-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251131441','2025-10-25','0.440','2025-10-25','11:31:44','PLG0074033','466000','466000','0','466000','466000','kasir','2025-10-25 11:31:44','F22525113144');
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-10-25','F225251131441','2025-10-25','11:31:44','TIN','466000','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-251025-0015','D','2025-10-25','11:31:44','kasir','PENJUALAN','F225251131441','1886823000','466000','1887289000');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1H-YJBE-1-T','T0074474','MHH1 42CM UB ','KL LONGLING SLEP UB 42CM 8K ','','GR','---','MH','H1H','TOKO','01-SEM','2231500','2025-10-25','2231500','2.010','100.00','8','0','1110000.00','1','0.04', 'input','2025-10-25 11:40:32','2.010','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1H' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1H','H1H-YJBE-1-T','T0074474');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-25','H1H-YJBE-1-T','H1H','TOKO','01-SEM','100.00','2.010','2.010','1','2.010','2.010','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1H-YJBE-2-T','T0074475','MHH1 42CM UB ','KL LONGLING SLEP UB 42CM 8K ','','GR','---','MH','H1H','TOKO','01-SEM','2220000','2025-10-25','2220000','2.000','100.00','8','','1110000.00','1','0.04', 'input','2025-10-25 11:40:56','2.000','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1H' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1H','H1H-YJBE-2-T','T0074475');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-25','H1H-YJBE-2-T','H1H','TOKO','01-SEM','100.00','2.000','2.000','1','2.000','2.000','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 ('F225251146501','kasir','1',' MGS1G 5K U','TOKO','SMBK-S','S1G-YJBC-53-T','AS EXTANTION UB 8K ','OL','0.320','1','100.00','354000','0','0','15000','357000','0','5000','0','362000','TIN','T0074426','S1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJBC-53-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='S1G-YJBC-53-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225251146501','2025-10-25','0.320','2025-10-25','11:46:51','PLG0074034','357000','357000','5000','362000','362000','kasir','2025-10-25 11:46:50','F22525114650');
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-10-25','F225251146501','2025-10-25','11:46:51','TIN','362000','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-251025-0016','D','2025-10-25','11:46:51','kasir','PENJUALAN','F225251146501','1887289000','362000','1887651000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='362000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251146501' 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 ('F225251146502','kasir',' 1',' MGS1G 5K U','TOKO','SMBK-S','S1G-YJBC-51-T','AS EXTANTION UB 8K ','OL','0.330','1','100.00','365000','0','0','15000','368000','0','5000','0','373000','TIN','T0074424','S1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJBC-51-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='S1G-YJBC-51-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225251146502','2025-10-25','0.330','2025-10-25','11:46:51','PLG0074035','368000','368000','5000','373000','373000','kasir','2025-10-25 11:46:50','F22525114650');
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-10-25','F225251146502','2025-10-25','11:46:51','TIN','373000','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-251025-0017','D','2025-10-25','11:46:51','kasir','PENJUALAN','F225251146502','1887651000','373000','1888024000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='373000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251146502' 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 ('F225251146503','kasir',' 1',' MGS1G 5K U','TOKO','SMBK-S','S1G-YJBC-52-T','AS EXTANTION UB 8K ','OL','0.330','1','100.00','365000','0','0','15000','368000','0','5000','0','373000','TIN','T0074425','S1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJBC-52-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='S1G-YJBC-52-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225251146503','2025-10-25','0.330','2025-10-25','11:46:51','PLG0074036','368000','368000','5000','373000','373000','kasir','2025-10-25 11:46:50','F22525114650');
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-10-25','F225251146503','2025-10-25','11:46:51','TIN','373000','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-251025-0018','D','2025-10-25','11:46:51','kasir','PENJUALAN','F225251146503','1888024000','373000','1888397000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='373000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251146503' 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 ('F225251146504','kasir',' 1',' MGS1G 5K U','TOKO','SMBK-S','S1G-YJBC-55-T','AS EXTANTION UB 8K ','OL','0.330','1','100.00','365000','0','0','15000','368000','0','5000','0','373000','TIN','T0074428','S1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJBC-55-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='S1G-YJBC-55-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225251146504','2025-10-25','0.330','2025-10-25','11:46:51','PLG0074037','368000','368000','5000','373000','373000','kasir','2025-10-25 11:46:50','F22525114650');
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-10-25','F225251146504','2025-10-25','11:46:51','TIN','373000','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-251025-0019','D','2025-10-25','11:46:51','kasir','PENJUALAN','F225251146504','1888397000','373000','1888770000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='373000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251146504' 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 ('F225251146505','kasir',' 1',' MGS1G 5K U','TOKO','SMBK-S','S1G-YJBC-57-T','AS EXTANTION UB 8K ','OL','0.340','1','100.00','376000','0','0','15000','379000','0','5000','0','384000','TIN','T0074430','S1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJBC-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.340',berat_jual_asli=berat_jual_asli+'0.340',stock_jual='1',berat_akhir=berat_akhir-'0.340',berat_akhir_asli=berat_akhir_asli-'0.340',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='S1G-YJBC-57-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225251146505','2025-10-25','0.340','2025-10-25','11:46:51','PLG0074038','379000','379000','5000','384000','384000','kasir','2025-10-25 11:46:50','F22525114650');
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-10-25','F225251146505','2025-10-25','11:46:51','TIN','384000','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-251025-0020','D','2025-10-25','11:46:51','kasir','PENJUALAN','F225251146505','1888770000','384000','1889154000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='384000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251146505' 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 ('F225251146506','kasir',' 1',' MGS1G 5K U','TOKO','SMBK-S','S1G-YJBC-49-T','AS EXTANTION UB 8K ','OL','0.340','1','100.00','376000','0','0','15000','379000','0','5000','0','384000','TIN','T0074422','S1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJBC-49-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.340',berat_jual_asli=berat_jual_asli+'0.340',stock_jual='1',berat_akhir=berat_akhir-'0.340',berat_akhir_asli=berat_akhir_asli-'0.340',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='S1G-YJBC-49-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225251146506','2025-10-25','0.340','2025-10-25','11:46:51','PLG0074039','379000','379000','5000','384000','384000','kasir','2025-10-25 11:46:50','F22525114650');
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-10-25','F225251146506','2025-10-25','11:46:51','TIN','384000','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-251025-0021','D','2025-10-25','11:46:51','kasir','PENJUALAN','F225251146506','1889154000','384000','1889538000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='384000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251146506' 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 ('F225251146507','kasir',' 1',' MGS1G 5K U','TOKO','SMBK-S','S1G-YJBC-58-T','AS EXTANTION UB 8K ','OL','0.340','1','100.00','376000','0','0','15000','379000','0','5000','0','384000','TIN','T0074431','S1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJBC-58-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.340',berat_jual_asli=berat_jual_asli+'0.340',stock_jual='1',berat_akhir=berat_akhir-'0.340',berat_akhir_asli=berat_akhir_asli-'0.340',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='S1G-YJBC-58-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225251146507','2025-10-25','0.340','2025-10-25','11:46:51','PLG0074040','379000','379000','5000','384000','384000','kasir','2025-10-25 11:46:50','F22525114650');
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-10-25','F225251146507','2025-10-25','11:46:51','TIN','384000','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-251025-0022','D','2025-10-25','11:46:51','kasir','PENJUALAN','F225251146507','1889538000','384000','1889922000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='384000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251146507' 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 ('F225251146508','kasir',' 1',' MGS1G 5K U','TOKO','SMBK-S','S1G-YJBC-54-T','AS EXTANTION UB 8K ','OL','0.340','1','100.00','376000','0','0','15000','379000','0','5000','0','384000','TIN','T0074427','S1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJBC-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.340',berat_jual_asli=berat_jual_asli+'0.340',stock_jual='1',berat_akhir=berat_akhir-'0.340',berat_akhir_asli=berat_akhir_asli-'0.340',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='S1G-YJBC-54-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225251146508','2025-10-25','0.340','2025-10-25','11:46:51','PLG0074041','379000','379000','5000','384000','384000','kasir','2025-10-25 11:46:50','F22525114650');
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-10-25','F225251146508','2025-10-25','11:46:51','TIN','384000','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-251025-0023','D','2025-10-25','11:46:51','kasir','PENJUALAN','F225251146508','1889922000','384000','1890306000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='384000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251146508' 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 ('F225251146509','kasir',' 1',' MGS1G 5K U','TOKO','SMBK-S','S1G-YJBC-56-T','AS EXTANTION UB 8K ','OL','0.340','1','100.00','376000','0','0','15000','379000','0','5000','0','384000','TIN','T0074429','S1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJBC-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.340',berat_jual_asli=berat_jual_asli+'0.340',stock_jual='1',berat_akhir=berat_akhir-'0.340',berat_akhir_asli=berat_akhir_asli-'0.340',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='S1G-YJBC-56-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225251146509','2025-10-25','0.340','2025-10-25','11:46:51','PLG0074042','379000','379000','5000','384000','384000','kasir','2025-10-25 11:46:50','F22525114650');
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-10-25','F225251146509','2025-10-25','11:46:51','TIN','384000','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-251025-0024','D','2025-10-25','11:46:51','kasir','PENJUALAN','F225251146509','1890306000','384000','1890690000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='384000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251146509' 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 ('F225251149051','kasir','1',' MGS1G 5K U','TOKO','SMBK-S','S1G-YJBC-50-T','AS EXTANTION UB 8K ','OL','0.340','1','100.00','376000','0','0','15000','379000','0','5000','0','384000','TIN','T0074423','S1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJBC-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.340',berat_jual_asli=berat_jual_asli+'0.340',stock_jual='1',berat_akhir=berat_akhir-'0.340',berat_akhir_asli=berat_akhir_asli-'0.340',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='S1G-YJBC-50-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225251149051','2025-10-25','0.340','2025-10-25','11:49:06','PLG0074043','379000','379000','5000','384000','384000','kasir','2025-10-25 11:49:05','F22525114905');
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-10-25','F225251149051','2025-10-25','11:49:06','TIN','384000','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-251025-0025','D','2025-10-25','11:49:06','kasir','PENJUALAN','F225251149051','1890690000','384000','1891074000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='384000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251149051' 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 ('F225251149052','kasir',' 1',' MGS1G 5K U','TOKO','SMBK-S','S1G-YJBC-48-T','AS EXTANTION UB 8K ','OL','0.360','1','100.00','398000','0','0','15000','401000','0','5000','0','406000','TIN','T0074421','S1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YJBC-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='S1G-YJBC-48-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225251149052','2025-10-25','0.360','2025-10-25','11:49:06','PLG0074044','401000','401000','5000','406000','406000','kasir','2025-10-25 11:49:05','F22525114905');
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-10-25','F225251149052','2025-10-25','11:49:06','TIN','406000','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-251025-0026','D','2025-10-25','11:49:06','kasir','PENJUALAN','F225251149052','1891074000','406000','1891480000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='406000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251149052' 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 ('F225251150521','kasir','1',' MDE1 X CM ','TOKO','SMBK-E','E1D-YJBA-147-0','CC X MODEL SLEP CM 18 8K ','OL','1.610','1','100.00','1658000','0','0','15000','1723000','0','8000','0','1731000','TIN','00374024','E1D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJBA-147-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E1D-YJBA-147-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251150521','2025-10-25','1.610','2025-10-25','11:50:52','PLG0074045','1723000','1723000','8000','1731000','1731000','kasir','2025-10-25 11:50:52','F22525115052');
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-10-25','F225251150521','2025-10-25','11:50:52','TIN','1731000','8000');
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-251025-0027','D','2025-10-25','11:50:52','kasir','PENJUALAN','F225251150521','1891480000','1731000','1893211000');
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 ('F225251159491','kasir','1',' MEF1E UB 5','TOKO','SMBK-F','F1E-YJBA-51-T','GL OVAL MODEL PITA MATA UB 56 8K ','OL','2.530','1','100.00','2656000','0','0','15000','2694000','0','13000','0','2707000','TJ','T0074372','F1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YJBA-51-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.530',berat_jual_asli=berat_jual_asli+'2.530',stock_jual='1',berat_akhir=berat_akhir-'2.530',berat_akhir_asli=berat_akhir_asli-'2.530',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='F1E-YJBA-51-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251159491','2025-10-25','2.530','2025-10-25','11:59:50','PLG0074046','2694000','2694000','13000','2707000','2707000','kasir','2025-10-25 11:59:49','F22525115949');
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-10-25','F225251159491','2025-10-25','11:59:50','TJ','2707000','13000');
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-251025-0028','D','2025-10-25','11:59:50','kasir','PENJUALAN','F225251159491','1893211000','2707000','1895918000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2707000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251159491' 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 ('F225251159492','kasir',' 1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YJAC-301-0','CC X MODEL MATA CM 16 8K ','OL','1.000','1','100.00','1030000','0','0','15000','1065000','0','5000','0','1070000','TJ','00373031','E2D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJAC-301-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E2D-YJAC-301-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251159492','2025-10-25','1.000','2025-10-25','11:59:50','PLG0074047','1065000','1065000','5000','1070000','1070000','kasir','2025-10-25 11:59:49','F22525115949');
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-10-25','F225251159492','2025-10-25','11:59:50','TJ','1070000','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-251025-0029','D','2025-10-25','11:59:50','kasir','PENJUALAN','F225251159492','1895918000','1070000','1896988000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1070000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251159492' LIMIT 1;
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJBE-3-T','T0074476','MEH1 12K HW 42 ','KL SANTA VAR MODEL MATA HW 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2353500','2025-10-25','2353500','2.220','100.00','8','0','1060000.00','1','0.04', 'input','2025-10-25 12:00:46','2.220','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJBE-3-T','T0074476');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-25','H1E-YJBE-3-T','H1E','TOKO','01-SEM','100.00','2.220','2.220','1','2.220','2.220','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251025-0001','1','H1E-YJBE-3-T','1','2.22','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJBE-3-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-25','TOKO','SMBK-H','H1E','H1E-YJBE-3-T' , '1','2.22','2.22', '1','2.22','2.22','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.22',berat_out_asli=berat_out_asli+'2.22',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJBE-3-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251025-0001','2','H1H-YJBE-1-T','1','2.01','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1H-YJBE-1-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-25','TOKO','SMBK-H','H1H','H1H-YJBE-1-T' , '1','2.01','2.01', '1','2.01','2.01','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.01',berat_out_asli=berat_out_asli+'2.01',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1H-YJBE-1-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251025-0001','3','H1H-YJBE-2-T','1','2','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1H-YJBE-2-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-25','TOKO','SMBK-H','H1H','H1H-YJBE-2-T' , '1','2','2', '1','2','2','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2',berat_out_asli=berat_out_asli+'2',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1H-YJBE-2-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-251025-0001','2025-10-25','2025-10-25','12:01','6.23','input','2025-10-25 12:01:58');
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 ('F225251202041','kasir','1',' MDE1D LT 1','TOKO','SMBK-E','E1D-YJBC-12-T','CC MODEL DAUN SLEP LT 17 8K ','OL','1.050','1','100.00','1097000','0','0','15000','1124000','0','5000','0','1129000','TIN','T0074385','E1D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJBC-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E1D-YJBC-12-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251202041','2025-10-25','1.050','2025-10-25','12:02:04','PLG0074048','1124000','1124000','5000','1129000','1129000','kasir','2025-10-25 12:02:04','F22525120204');
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-10-25','F225251202041','2025-10-25','12:02:04','TIN','1129000','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-251025-0030','D','2025-10-25','12:02:04','kasir','PENJUALAN','F225251202041','1896988000','1129000','1898117000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1129000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251202041' 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 ('F225251202042','kasir',' 1',' MEH1E UB 3','TOKO','SMBK-H','H1E-YJBC-13-T','KL TIFF PITA DUBAI SERUT UB 39 8K ','OL','2.630','1','100.00','2801000','0','0','15000','2814000','0','13000','0','2827000','TIN','T0074386','H1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJBC-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.630',berat_jual_asli=berat_jual_asli+'2.630',stock_jual='1',berat_akhir=berat_akhir-'2.630',berat_akhir_asli=berat_akhir_asli-'2.630',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='H1E-YJBC-13-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251202042','2025-10-25','2.630','2025-10-25','12:02:04','PLG0074049','2814000','2814000','13000','2827000','2827000','kasir','2025-10-25 12:02:04','F22525120204');
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-10-25','F225251202042','2025-10-25','12:02:04','TIN','2827000','13000');
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-251025-0031','D','2025-10-25','12:02:04','kasir','PENJUALAN','F225251202042','1898117000','2827000','1900944000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2827000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251202042' 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 ('F225251205161','kasir','1',' MEF3E X KH','TOKO','SMBK-F','F3E-XIBE-280-0','GL X TRIXIE HURUF MATA KH N 8K ','OLS 0H8VJ','1.380','1','100.00','1449000','0','0','15000','1463000','0','130000','0','1593000','TJ','00318970','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-XIBE-280-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.380',berat_jual_asli=berat_jual_asli+'1.380',stock_jual='1',berat_akhir=berat_akhir-'1.380',berat_akhir_asli=berat_akhir_asli-'1.380',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='F3E-XIBE-280-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251205161','2025-10-25','1.380','2025-10-25','12:05:17','PLG0074050','1463000','1463000','130000','1593000','1593000','kasir','2025-10-25 12:05:16','F22525120516');
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-10-25','F225251205161','2025-10-25','12:05:17','TJ','1593000','130000');
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-251025-0032','D','2025-10-25','12:05:17','kasir','PENJUALAN','F225251205161','1900944000','1593000','1902537000');
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 ('F225251209441','kasir','1',' MFH1 UB 32','TOKO','SMBK-H','H1F-YIXH-67-T','KL ANAK MILANO UB 32CM 8K ','OL','2.050','1','100.00','2193000','0','0','15000','2235000','0','10000','0','2245000','RTA','T0073076','H1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YIXH-67-T' 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-10-25' AND kode_barang='H1F-YIXH-67-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251209441','2025-10-25','2.050','2025-10-25','12:09:44','PLG0074051','2235000','2235000','10000','2245000','2245000','kasir','2025-10-25 12:09:44','F22525120944');
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-10-25','F225251209441','2025-10-25','12:09:44','RTA','2245000','10000');
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-251025-0033','D','2025-10-25','12:09:44','kasir','PENJUALAN','F225251209441','1902537000','2245000','1904782000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2245000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251209441' 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 ('F225251209442','kasir',' 1',' MED1E LG ','TOKO','SMBK-D','D1E-YJAE-8-T','LT MODEL APEL CAT HITAM LG 8K ','OL','0.500','1','100.00','525000','0','0','15000','538000','0','5000','0','543000','RTA','T0074057','D1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJAE-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='D1E-YJAE-8-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251209442','2025-10-25','0.500','2025-10-25','12:09:44','PLG0074052','538000','538000','5000','543000','543000','kasir','2025-10-25 12:09:44','F22525120944');
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-10-25','F225251209442','2025-10-25','12:09:44','RTA','543000','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-251025-0034','D','2025-10-25','12:09:44','kasir','PENJUALAN','F225251209442','1904782000','543000','1905325000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='543000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251209442' 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 ('F225251209443','kasir',' 1',' MEF1E UB 5','TOKO','SMBK-F','F1E-YJBC-21-T','GL OVAL PAKU MATA UB 52 8K ','OL','2.220','1','100.00','2364000','0','0','15000','2376000','0','11000','0','2387000','RTA','T0074394','F1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YJBC-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.220',berat_jual_asli=berat_jual_asli+'2.220',stock_jual='1',berat_akhir=berat_akhir-'2.220',berat_akhir_asli=berat_akhir_asli-'2.220',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='F1E-YJBC-21-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251209443','2025-10-25','2.220','2025-10-25','12:09:44','PLG0074053','2376000','2376000','11000','2387000','2387000','kasir','2025-10-25 12:09:44','F22525120944');
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-10-25','F225251209443','2025-10-25','12:09:44','RTA','2387000','11000');
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-251025-0035','D','2025-10-25','12:09:44','kasir','PENJUALAN','F225251209443','1905325000','2387000','1907712000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2387000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251209443' LIMIT 1;
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-YJBE-4-T','T0074477','MDE2 HW 13 ','CC COR MODEL PAKU MATA HW 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1082000','2025-10-25','1082000','1.040','100.00','8','0','1040000.00','1','0.04', 'input','2025-10-25 12:18:50','1.040','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-YJBE-4-T','T0074477');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-25','E2D-YJBE-4-T','E2D','TOKO','01-SEM','100.00','1.040','1.040','1','1.040','1.040','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-YJBE-5-T','T0074478','MDE2 HW 13 ','CC COR MODEL PAKU MATA HW 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1082000','2025-10-25','1082000','1.040','100.00','8','','1040000.00','1','0.04', 'input','2025-10-25 12:19:35','1.040','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-YJBE-5-T','T0074478');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-25','E2D-YJBE-5-T','E2D','TOKO','01-SEM','100.00','1.040','1.040','1','1.040','1.040','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-YJBE-6-T','T0074479','MDE2 HW 15 ','CC COR MODEL PAKU MATA HW 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1061000','2025-10-25','1061000','1.020','100.00','8','','1040000.00','1','0.04', 'input','2025-10-25 12:20:50','1.020','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-YJBE-6-T','T0074479');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-25','E2D-YJBE-6-T','E2D','TOKO','01-SEM','100.00','1.020','1.020','1','1.020','1.020','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 ('F225251221281','kasir','1',' MEF3E LT ','TOKO','SMBK-F','F3E-YJBD-90-T','GL FANY POLOS LT 8K ','OL','1.030','1','100.00','1092000','0','0','15000','1097000','0','5000','0','1102000','TJ','T0074440','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJBD-90-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='F3E-YJBD-90-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251221281','2025-10-25','1.030','2025-10-25','12:21:29','PLG0074054','1097000','1097000','5000','1102000','1102000','kasir','2025-10-25 12:21:28','F22525122128');
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-10-25','F225251221281','2025-10-25','12:21:29','TJ','1102000','5000');
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-251025-0036','D','2025-10-25','12:21:29','kasir','PENJUALAN','F225251221281','1907712000','1102000','1908814000');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-YJBE-7-T','T0074480','MDE2 HW 15 ','CC COR MODEL PAKU MATA HW 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1123500','2025-10-25','1123500','1.080','100.00','8','','1040000.00','1','0.04', 'input','2025-10-25 12:21:35','1.080','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-YJBE-7-T','T0074480');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-25','E2D-YJBE-7-T','E2D','TOKO','01-SEM','100.00','1.080','1.080','1','1.080','1.080','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 ('F225251221491','kasir','1',' MEH1 X HW ','TOKO','SMBK-H','H1E-YJBA-228-0','KL X RANTAI HOLLOW CD VAR HW 8K ','OL','1.970','1','100.00','2068000','0','0','15000','2098000','0','10000','0','2108000','TJ','00374105','H1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJBA-228-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='H1E-YJBA-228-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251221491','2025-10-25','1.970','2025-10-25','12:21:50','PLG0074055','2098000','2098000','10000','2108000','2108000','kasir','2025-10-25 12:21:49','F22525122149');
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-10-25','F225251221491','2025-10-25','12:21:50','TJ','2108000','10000');
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-251025-0037','D','2025-10-25','12:21:50','kasir','PENJUALAN','F225251221491','1908814000','2108000','1910922000');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-YJBE-8-T','T0074481','MDE2 HW 17 ','CC COR MODEL PAKU MATA HW 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1165000','2025-10-25','1165000','1.120','100.00','8','','1040000.00','1','0.04', 'input','2025-10-25 12:23:37','1.120','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-YJBE-8-T','T0074481');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-25','E2D-YJBE-8-T','E2D','TOKO','01-SEM','100.00','1.120','1.120','1','1.120','1.120','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-YJBE-9-T','T0074482','MDE2 HW 17 ','CC COR MODEL PAKU MATA HW 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1123500','2025-10-25','1123500','1.080','100.00','8','','1040000.00','1','0.04', 'input','2025-10-25 12:25:45','1.080','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-YJBE-9-T','T0074482');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-25','E2D-YJBE-9-T','E2D','TOKO','01-SEM','100.00','1.080','1.080','1','1.080','1.080','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251025-0002','1','E2D-YJBE-4-T','1','1.04','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-YJBE-4-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-25','TOKO','SMBK-E','E2D','E2D-YJBE-4-T' , '1','1.04','1.04', '1','1.04','1.04','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.04',berat_out_asli=berat_out_asli+'1.04',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-YJBE-4-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251025-0002','2','E2D-YJBE-5-T','1','1.04','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-YJBE-5-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-25','TOKO','SMBK-E','E2D','E2D-YJBE-5-T' , '1','1.04','1.04', '1','1.04','1.04','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.04',berat_out_asli=berat_out_asli+'1.04',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-YJBE-5-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251025-0002','3','E2D-YJBE-6-T','1','1.02','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-YJBE-6-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-25','TOKO','SMBK-E','E2D','E2D-YJBE-6-T' , '1','1.02','1.02', '1','1.02','1.02','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.02',berat_out_asli=berat_out_asli+'1.02',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-YJBE-6-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251025-0002','4','E2D-YJBE-7-T','1','1.08','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-YJBE-7-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-25','TOKO','SMBK-E','E2D','E2D-YJBE-7-T' , '1','1.08','1.08', '1','1.08','1.08','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.08',berat_out_asli=berat_out_asli+'1.08',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-YJBE-7-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251025-0002','5','E2D-YJBE-8-T','1','1.12','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-YJBE-8-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-25','TOKO','SMBK-E','E2D','E2D-YJBE-8-T' , '1','1.12','1.12', '1','1.12','1.12','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.12',berat_out_asli=berat_out_asli+'1.12',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-YJBE-8-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251025-0002','6','E2D-YJBE-9-T','1','1.08','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-YJBE-9-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-25','TOKO','SMBK-E','E2D','E2D-YJBE-9-T' , '1','1.08','1.08', '1','1.08','1.08','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.08',berat_out_asli=berat_out_asli+'1.08',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-YJBE-9-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-251025-0002','2025-10-25','2025-10-25','12:27','6.38','input','2025-10-25 12:27:37');
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 ('F225251235581','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YHAC-194-T','LT SLOBOK BOLA KRAWANG BG 8K ','','0.390','1','100.00','425000','0','0','15000','429000','0','5000','0','434000','TJ','T0072334','D1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YHAC-194-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.390',berat_jual_asli=berat_jual_asli+'0.390',stock_jual='1',berat_akhir=berat_akhir-'0.390',berat_akhir_asli=berat_akhir_asli-'0.390',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='D1G-YHAC-194-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251235581','2025-10-25','0.390','2025-10-25','12:35:59','PLG0074056','429000','429000','5000','434000','434000','kasir','2025-10-25 12:35:58','F22525123558');
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-10-25','F225251235581','2025-10-25','12:35:59','TJ','434000','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-251025-0038','D','2025-10-25','12:35:59','kasir','PENJUALAN','F225251235581','1910922000','434000','1911356000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='434000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251235581' 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 ('F225251235582','kasir',' 1',' MEH1 UB 45','TOKO','SMBK-H','H1E-YHXF-55-T','KL RANTAI HOLLOW UB 45CM 8K ','','0.860','1','100.00','903000','0','0','15000','912000','0','0','0','912000','TJ','T0071947','H1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YHXF-55-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='H1E-YHXF-55-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251235582','2025-10-25','0.860','2025-10-25','12:35:59','PLG0074057','912000','912000','0','912000','912000','kasir','2025-10-25 12:35:58','F22525123558');
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-10-25','F225251235582','2025-10-25','12:35:59','TJ','912000','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-251025-0039','D','2025-10-25','12:35:59','kasir','PENJUALAN','F225251235582','1911356000','912000','1912268000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='912000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251235582' 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 ('F225251258281','kasir','1',' MHH1 42CM ','TOKO','SMBK-H','H1H-YJBE-2-T','KL LONGLING SLEP UB 42CM 8K ','OL','2.000','1','100.00','2220000','0','0','15000','2250000','0','10000','0','2260000','RTA','T0074475','H1H','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1H-YJBE-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='H1H-YJBE-2-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251258281','2025-10-25','2.000','2025-10-25','12:58:28','PLG0074058','2250000','2250000','10000','2260000','2260000','kasir','2025-10-25 12:58:28','F22525125828');
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-10-25','F225251258281','2025-10-25','12:58:28','RTA','2260000','10000');
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-251025-0040','D','2025-10-25','12:58:28','kasir','PENJUALAN','F225251258281','1912268000','2260000','1914528000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2260000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251258281' 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 ('F225251258282','kasir',' 1',' MEA1E CM ','TOKO','SMBK-A','A1E-YJAH-48-T','AT JYPSY CM 8K','OL','0.450','1','100.00','472000','0','0','15000','482000','0','5000','0','487000','RTA','T0074261','A1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJAH-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='A1E-YJAH-48-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225251258282','2025-10-25','0.450','2025-10-25','12:58:28','PLG0074059','482000','482000','5000','487000','487000','kasir','2025-10-25 12:58:28','F22525125828');
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-10-25','F225251258282','2025-10-25','12:58:28','RTA','487000','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-251025-0041','D','2025-10-25','12:58:28','kasir','PENJUALAN','F225251258282','1914528000','487000','1915015000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='487000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251258282' 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 ('F225250142451','kasir','1',' MHA1 HK ','TOKO','SMBK-A','A1H-YIBB-45-T','AT TINDIK BABY HK 8K ','','0.240','1','100.00','266000','0','0','15000','268000','0','0','0','268000','TIN','T0073181','A1H','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1H-YIBB-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.240',berat_jual_asli=berat_jual_asli+'0.240',stock_jual='1',berat_akhir=berat_akhir-'0.240',berat_akhir_asli=berat_akhir_asli-'0.240',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='A1H-YIBB-45-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225250142451','2025-10-25','0.240','2025-10-25','13:42:45','PLG0074060','268000','268000','0','268000','268000','kasir','2025-10-25 13:42:45','F22525014245');
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-10-25','F225250142451','2025-10-25','13:42:45','TIN','268000','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-251025-0042','D','2025-10-25','13:42:45','kasir','PENJUALAN','F225250142451','1915015000','268000','1915283000');
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 ('F225250228071','kasir','1',' MDE2 HW 17','TOKO','SMBK-E','E2D-YJBE-8-T','CC COR MODEL PAKU MATA HW 8K ','OL','1.120','1','100.00','1165000','0','0','15000','1187000','0','6000','0','1193000','RTA','T0074481','E2D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJBE-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E2D-YJBE-8-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225250228071','2025-10-25','1.120','2025-10-25','14:28:07','PLG0074061','1187000','1187000','6000','1193000','1193000','kasir','2025-10-25 14:28:07','F22525022807');
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-10-25','F225250228071','2025-10-25','14:28:07','RTA','1193000','6000');
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-251025-0043','D','2025-10-25','14:28:07','kasir','PENJUALAN','F225250228071','1915283000','1193000','1916476000');
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 ('F225250259111','kasir','1',' MFF3F 10K ','TOKO','SMBK-F','F3F-YJAH-59-T','GL TIFF MODEL SLEP BG 8K ','','2.120','1','100.00','2268000','0','0','15000','2290000','0','10000','0','2300000','TJ','T0074272','F3F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YJAH-59-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.120',berat_jual_asli=berat_jual_asli+'2.120',stock_jual='1',berat_akhir=berat_akhir-'2.120',berat_akhir_asli=berat_akhir_asli-'2.120',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='F3F-YJAH-59-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225250259111','2025-10-25','2.120','2025-10-25','14:59:11','PLG0074062','2290000','2290000','10000','2300000','2300000','kasir','2025-10-25 14:59:11','F22525025911');
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-10-25','F225250259111','2025-10-25','14:59:11','TJ','2300000','10000');
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-251025-0044','D','2025-10-25','14:59:11','kasir','PENJUALAN','F225250259111','1916476000','2300000','1918776000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250142451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250142451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250142451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250228071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250228071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250228071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250259111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250259111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250259111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250836111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250836111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250836111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250836112' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250836112' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250836112';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250905141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250905141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250905141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250905142' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250905142' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250905142';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250921161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250921161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250921161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250921162' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250921162' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250921162';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251025491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251025491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251025491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251026381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251026381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251026381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251035521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251035521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251035521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251058011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251058011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251058011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251109321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251109321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251109321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251109322' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251109322' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251109322';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251131441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251131441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251131441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251146501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251146501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251146501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251146502' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251146502' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251146502';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251146503' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251146503' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251146503';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251146504' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251146504' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251146504';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251146505' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251146505' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251146505';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251146506' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251146506' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251146506';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251146507' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251146507' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251146507';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251146508' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251146508' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251146508';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251146509' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251146509' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251146509';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251149051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251149051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251149051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251149052' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251149052' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251149052';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251150521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251150521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251150521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251159491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251159491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251159491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251159492' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251159492' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251159492';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251202041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251202041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251202041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251202042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251202042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251202042';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251205161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251205161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251205161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251209441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251209441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251209441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251209442' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251209442' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251209442';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251209443' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251209443' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251209443';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251221281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251221281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251221281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251221491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251221491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251221491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251235581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251235581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251235581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251235582' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251235582' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251235582';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251258281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251258281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251258281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251258282' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251258282' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251258282';
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 ('F225250346171','kasir','1',' MDA1D X LG','TOKO','SMBK-A','A1D-YJAC-15-0','AT X MODEL MATA VAR LG 8K ','','1.120','1','100.00','1154000','0','0','15000','1160000','0','0','0','1160000','TIN','00372745','A1D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YJAC-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='A1D-YJAC-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225250346171','2025-10-25','1.120','2025-10-25','15:46:18','PLG0074063','1160000','1160000','0','1160000','1160000','kasir','2025-10-25 15:46:17','F22525034617');
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-10-25','F225250346171','2025-10-25','15:46:18','TIN','1160000','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-251025-0045','D','2025-10-25','15:46:18','kasir','PENJUALAN','F225250346171','1918776000','1160000','1919936000');
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 ('F225250348571','kasir','1',' MDA1D X OR','TOKO','SMBK-A','A1D-YIBC-303-0','AT X CLIP BANGKOK SLEP OR 8K ','','1.500','1','100.00','1545000','0','0','15000','1553000','0','0','0','1553000','RTA','00370274','A1D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YIBC-303-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='A1D-YIBC-303-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225250348571','2025-10-25','1.500','2025-10-25','15:48:58','PLG0074064','1553000','1553000','0','1553000','1553000','kasir','2025-10-25 15:48:57','F22525034857');
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-10-25','F225250348571','2025-10-25','15:48:58','RTA','1553000','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-251025-0046','D','2025-10-25','15:48:58','kasir','PENJUALAN','F225250348571','1919936000','1553000','1921489000');
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 ('F225250350421','kasir','1',' TDE2 X YT ','TOKO','TBK-E','E2TD-YJXB-104-T','CC X MODEL DAUN MATA VAR YT 13 17K ','','0.970','1','100.00','1790000','0','0','15000','1819000','0','0','0','1819000','TJ','T0073684','E2TD','0','0','-','0','1845000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YJXB-104-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E2TD-YJXB-104-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225250350421','2025-10-25','0.970','2025-10-25','15:50:43','PLG0074065','1819000','1819000','0','1819000','1819000','kasir','2025-10-25 15:50:42','F22525035042');
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-10-25','F225250350421','2025-10-25','15:50:43','TJ','1819000','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-251025-0047','D','2025-10-25','15:50:43','kasir','PENJUALAN','F225250350421','1921489000','1819000','1923308000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250350421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250350421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250350421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250346171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250346171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250346171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250348571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250348571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250348571';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0001';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00004775','X-00004775','CC X MODEL MATA VAR UB 12 17K','GR','---','E2TD','BELI','BELI001','2075000','2025-10-25','1.420','1','kasir','2025-10-25 16:06:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TD';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TD','X-00004775','X-00004775');
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-251025-0002','F225100257531','TJ','1','BELI','BELI001','E2TD', 'X-00004775', 'CC X MODEL MATA VAR UB 12 17K','1.420','1.420','100.00','2255000','2075000','1461268','1845000','1','2075000','2075000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.420',berat_beli_asli=berat_beli_asli+'1.420',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.420',berat_akhir_asli=berat_akhir_asli+'1.420',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TD' 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-251025-0002','2025-10-25','2025-10-25','16:06:47','TJ','---','1.420','2075000','2075000','2075000','2075000','2075000','kasir','2025-10-25 16:06:48','FB-251025-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0002','ERIKA','NGRAYUN','','','083139077666','kasir','2025-10-25 16:06:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' 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-251025-0048','K','2025-10-25','16:06:47','kasir','PEMBELIAN UMUM','FB-251025-0002','1923308000','2075000','1921233000');
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-00004776','X-00004776','CC MODEL DAUN SLEP HW 17 8K','GR','---','E1E','BELI','BELI001','690000','2025-10-25','0.670','1','kasir','2025-10-25 16:07:05');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00004776','X-00004776');
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-251025-0003','F225240250071','TJ','1','BELI','BELI001','E1E', 'X-00004776', 'CC MODEL DAUN SLEP HW 17 8K','0.670','0.670','100.00','710000','690000','1029851','1060000','1','690000','690000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.670',berat_beli_asli=berat_beli_asli+'0.670',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.670',berat_akhir_asli=berat_akhir_asli+'0.670',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' 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-251025-0003','2025-10-25','2025-10-25','16:07:04','TJ','---','0.670','690000','690000','690000','690000','690000','kasir','2025-10-25 16:07:05','FB-251025-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0003','HENI','YOSUDARSO GG3','','','','kasir','2025-10-25 16:07:05');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' 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-251025-0049','K','2025-10-25','16:07:04','kasir','PEMBELIAN UMUM','FB-251025-0003','1921233000','690000','1920543000');
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-00004777','X-00004777','GL TRIXIE MODEL BUNGA CLOVER VAR YT 8K','GR','---','F3E','BELI','BELI001','977000','2025-10-25','1.410','1','kasir','2025-10-25 16:08:00');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00004777','X-00004777');
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-251025-0004','F225221144063','RTA','1','BELI','BELI001','F3E', 'X-00004777', 'GL TRIXIE MODEL BUNGA CLOVER VAR YT 8K','1.410','1.410','100.00','1062000','977000','692908','1060000','1','977000','977000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.410',berat_beli_asli=berat_beli_asli+'1.410',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.410',berat_akhir_asli=berat_akhir_asli+'1.410',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' 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-251025-0004','2025-10-25','2025-10-25','16:08:00','RTA','---','1.410','977000','977000','977000','977000','977000','kasir','2025-10-25 16:08:00','FB-251025-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0004','AYU','SUKOSARI BABADAN','','','083866446903','kasir','2025-10-25 16:08:00');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' 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-251025-0050','K','2025-10-25','16:08:00','kasir','PEMBELIAN UMUM','FB-251025-0004','1920543000','977000','1919566000');
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-00004778','X-00004778','CC X MODEL GELOMBANG CAT HITAM HW 17 8K','GR','---','E1E','BELI','BELI001','510000','2025-10-25','0.680','1','kasir','2025-10-25 16:08:00');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00004778','X-00004778');
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-251025-0005','F225221144064','RTA','2','BELI','BELI001','E1E', 'X-00004778', 'CC X MODEL GELOMBANG CAT HITAM HW 17 8K','0.710','0.680','100.00','513000','510000','750000','1060000','1','510000','510000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.680',berat_beli_asli=berat_beli_asli+'0.680',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.680',berat_akhir_asli=berat_akhir_asli+'0.680',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' 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-251025-0005','2025-10-25','2025-10-25','16:08:00','RTA','---','0.680','510000','510000','510000','510000','510000','kasir','2025-10-25 16:08:00','FB-251025-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0005','AYU','SUKOSARI BABADAN','','','083866446903','kasir','2025-10-25 16:08:00');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' 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-251025-0051','K','2025-10-25','16:08:00','kasir','PEMBELIAN UMUM','FB-251025-0005','1919566000','510000','1919056000');
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-00004779','X-00004779','GW X MODEL TAUGE MATA HK 8K','GR','---','B1F','BELI','BELI001','270000','2025-10-25','0.400','1','kasir','2025-10-25 16:08:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00004779','X-00004779');
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-251025-0006','F225171155441','TIN','1','BELI','BELI001','B1F', 'X-00004779', 'GW X MODEL TAUGE MATA HK 8K','0.400','0.400','100.00','294000','270000','675000','1085000','1','270000','270000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.400',berat_beli_asli=berat_beli_asli+'0.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.400',berat_akhir_asli=berat_akhir_asli+'0.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1F' 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-251025-0006','2025-10-25','2025-10-25','16:08:17','TIN','---','0.400','270000','270000','270000','270000','270000','kasir','2025-10-25 16:08:17','FB-251025-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0006','NANA','NGABAR','','','','kasir','2025-10-25 16:08:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' 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-251025-0052','K','2025-10-25','16:08:17','kasir','PEMBELIAN UMUM','FB-251025-0006','1919056000','270000','1918786000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0006';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-26','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-25';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-25';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-25';
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-10-25' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-25';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-25';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-25';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-25';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-26' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-25' 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-251026-0001','D','2025-10-26','16:28:55','SYSTEM','SALDO AWAL','SALDO AWAL','0','1918786000','1918786000');
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-251026-0001','D','2025-10-26','16:28:55','BCA','SALDO AWAL','SALDO AWAL','0','4082693888','4082693888');
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-251026-0001','D','2025-10-26','16:28:55','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
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-251026-0001','D','2025-10-26','16:28:55','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-251026-0001','D','2025-10-26','16:28:55','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-251026-0001','D','2025-10-26','16:28:55','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2025-10-26';