package ziver.mrp.hibernate.dao;

import com.sun.jersey.core.header.FormDataContentDisposition;
import org.hibernate.Criteria;
import org.hibernate.engine.spi.SessionFactoryImplementor;
import org.hibernate.engine.spi.SessionImplementor;
import org.hibernate.internal.CriteriaImpl;
import org.hibernate.loader.criteria.CriteriaJoinWalker;
import org.hibernate.loader.criteria.CriteriaQueryTranslator;
import org.hibernate.persister.entity.OuterJoinLoadable;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import javax.ws.rs.core.Response;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.lang.reflect.Field;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.LinkedHashMap;
import java.util.Map;

/**
 * Created by Ramazan on 18.11.2016.
 */
public class Helper {
    private static final String ZIVER_DIR = "/C:/FileServer/ZiverMRP";
    private static final String ZIVER_DIR_LINUX = "/ziverFiles/tempFile";

    private static final Logger LOGGER = LoggerFactory.getLogger(Helper.class);
    public static Map<String, Response> fileMap = new LinkedHashMap<>();

    public static void criteriaToSql(Criteria criteria) {
        CriteriaImpl criteriaImpl = (CriteriaImpl) criteria;
        SessionImplementor session = criteriaImpl.getSession();
        SessionFactoryImplementor factory = session.getFactory();
        CriteriaQueryTranslator translator = new CriteriaQueryTranslator(factory, criteriaImpl, criteriaImpl.getEntityOrClassName(), CriteriaQueryTranslator.ROOT_SQL_ALIAS);
        String[] implementors = factory.getImplementors(criteriaImpl.getEntityOrClassName());

        CriteriaJoinWalker walker = new CriteriaJoinWalker((OuterJoinLoadable) factory.getEntityPersister(implementors[0]),
                translator,
                factory,
                criteriaImpl,
                criteriaImpl.getEntityOrClassName(),
                session.getLoadQueryInfluencers());

        String sql = walker.getSQLString();
        System.out.println("************** Sql Query Sistemi ********* \n ");
        System.out.println(sql);
        System.out.println("************** Sql Query Sistemi ********* \n\n\n");
    }

    public Object containesControl(Object obj, String searchingTest) throws IllegalAccessException {
        Class<?> objClass = obj.getClass();
        FilterControl:
        for (Field field : objClass.getDeclaredFields()) {
            field.setAccessible(true); // You might want to set modifier to public first.
            Object value = field.get(obj);
            if (value != null) {
                if (value.toString().trim().toLowerCase().contains(searchingTest.toLowerCase())) {
//                    System.out.println(field.getName() + "=" + value);
                    return obj;
                }

            }
        }
        return null;
    }

    public String uploadFile(InputStream uploadedInputStream, FormDataContentDisposition fileDetail, String locationName) {

        Calendar cal = Calendar.getInstance();
        SimpleDateFormat sdf = new SimpleDateFormat("dd_MM_yyyy HH:mm:ss.SS");
        String strDate = sdf.format(cal.getTime());

        // ZiverMRPConfiguration ziverMRPConfiguration = GuiceBundle.getInjector().getInstance(ZiverMRPConfiguration.class);
        // String path = ziverMRPConfiguration.getFileServer().getPath()+"/"+strDate.trim().replace(":","_").replace(" ","_").replace("/","_").replace(".","_");;
        String path = "";
        if (OSDetector.isWindows()) {
            path = ZIVER_DIR;
        } else if (OSDetector.isLinux() || OSDetector.isMac()) {
            path = ZIVER_DIR_LINUX;
        }

        if (locationName.contains("/")) {
            path = path + "_" + strDate.replace(" ", "").replace("_", "").replace(":", "") + "/" + locationName;

        } else {
            path = path + "/" + strDate.replace(" ", "").replace("_", "").replace(":", "") + "/" + locationName;
        }
        String fileLocation = path + "/" + fileDetail.getFileName();


        File file1 = new File(path);
        file1.setExecutable(true, false);
        file1.setReadable(true, false);
        file1.setWritable(true, false);
        file1.mkdirs();


        try {
            FileOutputStream out = new FileOutputStream(new File(fileLocation));
            int read = 0;
            byte[] bytes = new byte[1024];
            out = new FileOutputStream(new File(fileLocation));
            while ((read = uploadedInputStream.read(bytes)) != -1) {
                out.write(bytes, 0, read);
            }
            out.flush();
            out.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
        String output = "File successfully uploaded to : " + fileLocation;
        LOGGER.info(output);
        return fileLocation;
    }

    public Response getFileResponse(String cyriptedText) {
        // String cyriptedText = uriInfo.getQueryParameters().getFirst("cyriptedText");
        Response response = (Response) fileMap.get(cyriptedText);
        try {
            fileMap.remove(cyriptedText);
        } catch (Exception ex) {
            ex.printStackTrace();
            return Response.serverError().build();
        }
        return response;
    }

}