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;
	
	@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 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();
	}
	
}