package com.hxzkoa.services;

import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;

import org.springframework.stereotype.Service;

import com.hxzkoa.json.User;
import com.hxzkoa.json.tb_user;

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

	public tb_user login(String username) {
		String sql = null;
		Query query = null;
		sql = "SELECT username,password,superuser,deleteq,alertq,deleteall,justlook,fenceq FROM tb_user WHERE username=:username";
		query = this.em.createNativeQuery(sql);
		query.setParameter("username", username);
		List resultList = query.getResultList();
		tb_user user = new tb_user();
		if (resultList.size() > 0) {
			Object[] obj = (Object[]) resultList.get(0);
			user.setUsername(obj[0] == null ? "" : obj[0].toString());
			user.setPassword(obj[1] == null ? "" : obj[1].toString());
			user.setSuperuser(obj[2] == null ? "" : obj[2].toString());
			user.setDeleteq(obj[3] == null ? "" : obj[3].toString());
			user.setAlertq(obj[4] == null ? "" : obj[4].toString());
			user.setDeleteall(obj[5] == null ? "" : obj[5].toString());
			user.setJustlook(obj[6] == null ? "" : obj[6].toString());
			user.setFenceq(obj[7] == null ? "" : obj[7].toString());
		}
		return user;
	}
}