//
// Source code recreated from a .class file by IntelliJ IDEA
// (powered by FernFlower decompiler)
//

package com.hxzkoa.services;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

@Service
public class HelmetService {
	@PersistenceContext
	private EntityManager em;

	public HelmetService() {
	}

	@Transactional
	public void offhat(String tagid, String state) {
		Query query = null;
		String sql = null;
		sql = "UPDATE tb_person SET baoliu29=:state WHERE p_tagid=:tagid";
		query = this.em.createNativeQuery(sql);
		query.setParameter("tagid", tagid);
		query.setParameter("state", state);
		query.executeUpdate();
	}

	@Transactional
	public void smash(String tagid, String state) {
		Query query = null;
		String sql = null;
		sql = "UPDATE tb_person SET baoliu25=:state WHERE p_tagid=:tagid";
		query = this.em.createNativeQuery(sql);
		query.setParameter("tagid", tagid);
		query.setParameter("state", state);
		query.executeUpdate();
	}

	@Transactional
	public void stopmoving(String tagid, String state) {
		Query query = null;
		String sql = null;
		sql = "UPDATE tb_person SET baoliu26=:state WHERE p_tagid=:tagid";
		query = this.em.createNativeQuery(sql);
		query.setParameter("tagid", tagid);
		query.setParameter("state", state);
		query.executeUpdate();
	}

	@Transactional
	public void high(String tagid, String state) {
		Query query = null;
		String sql = null;
		sql = "UPDATE tb_person SET baoliu27=:state WHERE p_tagid=:tagid";
		query = this.em.createNativeQuery(sql);
		query.setParameter("tagid", tagid);
		query.setParameter("state", state);
		query.executeUpdate();
	}

	@Transactional
	public void nearele(String tagid, String state) {
		Query query = null;
		String sql = null;
		sql = "UPDATE tb_person SET baoliu28=:state WHERE p_tagid=:tagid";
		query = this.em.createNativeQuery(sql);
		query.setParameter("tagid", tagid);
		query.setParameter("state", state);
		query.executeUpdate();
	}

	@Transactional
	public void video(String tagid, String name) {
		Query query = null;
		String sql = null;
		sql = "UPDATE tb_person SET baoliu30=:name WHERE p_tagid=:tagid";
		query = this.em.createNativeQuery(sql);
		query.setParameter("tagid", tagid);
		query.setParameter("name", name);
		query.executeUpdate();
	}

	@Transactional
	public void audio(String tagid, String name) {
		Query query = null;
		String sql = null;
		sql = "UPDATE tb_person SET baoliu31=:name WHERE p_tagid=:tagid";
		query = this.em.createNativeQuery(sql);
		query.setParameter("tagid", tagid);
		query.setParameter("name", name);
		query.executeUpdate();
	}

	@Transactional
	public void image(String tagid, String name) {
		Query query = null;
		String sql = null;
		sql = "UPDATE tb_person SET baoliu34=:name WHERE p_tagid=:tagid";
		query = this.em.createNativeQuery(sql);
		query.setParameter("tagid", tagid);
		query.setParameter("name", name);
		query.executeUpdate();
	}

	@Transactional
	public void setgps(String tagid, String lon, String lat) {
		Query query = null;
		String sql = null;
		sql = "UPDATE tb_gps SET gsp_jingdu=:lon,gps_weidu=:lat WHERE tagid=:tagid";
		query = this.em.createNativeQuery(sql);
		query.setParameter("tagid", tagid);
		query.setParameter("lon", lon);
		query.setParameter("lat", lat);
		query.executeUpdate();
	}

	@Transactional
	public void guanbi(String tagid, String type) {
		Query query = null;
		String sql = null;
		sql = "UPDATE tb_person SET " + type + "='' WHERE p_tagid=:tagid";
		query = this.em.createNativeQuery(sql);
		query.setParameter("tagid", tagid);
		query.executeUpdate();
	}

	@Transactional
	public String removefile(String tagid, String type) {
		Query query = null;
		String sql = null;
		sql = "SELECT " + type + " from tb_person WHERE p_tagid=:tagid";
		query = this.em.createNativeQuery(sql);
		query.setParameter("tagid", tagid);
		Object person = query.getSingleResult();
		return person.toString();
	}
}