package controllers;

import com.fasterxml.jackson.databind.JsonNode;
import com.fasterxml.jackson.databind.node.ObjectNode;
import models.User;
import play.db.jpa.JPA;
import play.db.jpa.Transactional;
import play.libs.Json;
import play.mvc.Result;

import javax.persistence.NoResultException;
import javax.persistence.TypedQuery;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.ParameterExpression;
import javax.persistence.criteria.Root;

import static play.libs.Json.toJson;
import static play.mvc.Results.ok;

/**
 * Created by Silzzz88 on 3/14/2017.
 */
public class UserController {
    @Transactional(readOnly = true)
    public Result listUsers(String vUserId, String vPass) {
        CriteriaBuilder cb = JPA.em().getCriteriaBuilder();
        CriteriaQuery<User> cq = cb.createQuery(User.class);
        Root<User> root = cq.from(User.class);
        ParameterExpression<String> pUserId = cb.parameter(String.class);
        //ParameterExpression<String> pPass = cb.parameter(String.class);
        CriteriaQuery<User> all = cq.select(root).where(cb.equal(root.get("USER_ID"), pUserId));
//        CriteriaQuery<User> all = cq.select(root).where(
//                cb.or(cb.equal(root.get("USER_ID"), pUserId), cb.equal(root.get("USER_PASSWORD"), pPass)));
        TypedQuery<User> query = JPA.em().createQuery(all);
        query.setParameter(pUserId, vUserId);
        //query.setParameter(pPass, vPass);


        String nama_user, pass_md;

        try{
            User results = query.getSingleResult();
            nama_user = results.USER_NAME;
            pass_md = results.PASSWORD_MD5;
            ObjectNode result = Json.newObject();
            result.put("exampleField1", "foobar");
            result.put("exampleField2", "Hello world!");

            if (pass_md.equals(utils.EncryptPass.encodeMd5(vUserId, vPass))) {
                return ok (result);
            }
            else {
                return ok("Password Anda Salah...!");
            }
        } catch(NoResultException e) {
            return ok("User tidak terdaftar...!");
        }

        //TypedQuery<User> allQuery = JPA.em().createQuery(all);

        //results[0];
        //JsonNode jsonNodes = toJson(query.getResultList());
        //return ok(jsonNodes);
        //return ok(utils.EncryptPass.encodeMd5(vUserId, vPass));
        //return ok(results.PASSWORD_MD5);
    }
}