Examples with DatatableUpdateProperties io.clownfish.clownfish.jdbc.DatatableUpdateProperties used on opensource projects

Example 1 with DatatableUpdateProperties

use of io.clownfish.clownfish.jdbc.DatatableUpdateProperties in project Clownfish by rawdog71.

the class DatabaseUtil method manageTableUpdate.

private boolean manageTableUpdate(Connection con, DatabaseMetaData dmd, String tablename, HashMap<String, DatatableUpdateProperties> datatableproperties, HashMap<String, ArrayList> dbtables, HashMap<String, Object> dbvalues) {
    Statement stmt = null;
    try {
        TableFieldStructure tfs = getTableFieldsList(dmd, tablename, "");
        DatatableUpdateProperties dtup = datatableproperties.get(tablename);
        StringBuilder sql_update_values = new StringBuilder();
        dtup.getValuelist().stream().map((dtuv) -> {
            sql_update_values.append(dtuv.getField());
            return dtuv;
        }).forEach((dtuv) -> {
            sql_update_values.append(" = ");
            String fieldType = getFieldType(tfs.getTableFieldsList(), dtuv.getField());
            if (null != fieldType) {
                if ((fieldType.compareToIgnoreCase("string") == 0) || (fieldType.compareToIgnoreCase("date") == 0)) {
                    sql_update_values.append("'");
                }
                sql_update_values.append(dtuv.getValue());
                if ((fieldType.compareToIgnoreCase("string") == 0) || (fieldType.compareToIgnoreCase("date") == 0)) {
                    sql_update_values.append("'");
                }
                sql_update_values.append(", ");
            }
        });
        sql_update_values.delete(sql_update_values.length() - 2, sql_update_values.length());
        StringBuilder sql_update = new StringBuilder();
        sql_update.append("UPDATE ");
        sql_update.append(tablename);
        sql_update.append(" SET ");
        sql_update.append(sql_update_values);
        StringBuilder sql_condition = new StringBuilder();
        if (null != dtup) {
            sql_condition = buildCondition(dtup.getConditionlist(), tfs.getTableFieldsList());
        }
        sql_update.append(sql_condition);
        stmt = con.createStatement();
        int count = stmt.executeUpdate(sql_update.toString());
        boolean ok = false;
        if (count > 0) {
            ok = true;
        }
        return ok;
    } catch (SQLException ex) {
        LOGGER.error(ex.getMessage());
        return false;
    } finally {
        if (null != stmt) {
            try {
                stmt.close();
            } catch (SQLException ex) {
                LOGGER.error(ex.getMessage());
            }
        }
    }
}

Example 2 with DatatableUpdateProperties

use of io.clownfish.clownfish.jdbc.DatatableUpdateProperties in project Clownfish by rawdog71.

the class ClownfishUtil method getDatatableupdateproperties.

/*
        getDatatableupdateproperties
        Setzt die Properties für ein DB UPDATE Aufruf
    */
public HashMap<String, DatatableUpdateProperties> getDatatableupdateproperties(List<JsonFormParameter> postmap) {
    HashMap<String, DatatableUpdateProperties> datatableupdateproperties = new HashMap<>();
    if (postmap != null) {
        postmap.stream().map((jfp) -> {
            // Datenbank UPDATE Parameter
            if (jfp.getName().compareToIgnoreCase("db$tableupdate") == 0) {
                DatatableUpdateProperties dtup = new DatatableUpdateProperties();
                dtup.setTablename(jfp.getValue());
                datatableupdateproperties.put(jfp.getValue(), dtup);
            }
            return jfp;
        }).filter((jfp) -> (jfp.getName().startsWith("db$tableupdate$"))).forEach((jfp) -> {
            String rest = jfp.getName().substring(15);
            String[] values = rest.split("\\$");
            if (values[1].compareToIgnoreCase("condition") == 0) {
                DatatableCondition dtc = new DatatableCondition();
                dtc.setField(values[2]);
                dtc.setOperand(values[3]);
                dtc.setValue(jfp.getValue());
                datatableupdateproperties.get(values[0]).getConditionlist().add(dtc);
            } else {
                DatatableNewValue dtnv = new DatatableNewValue();
                dtnv.setField(values[1]);
                dtnv.setValue(jfp.getValue());
                datatableupdateproperties.get(values[0]).getValuelist().add(dtnv);
            }
        });
    }
    return datatableupdateproperties;
}

Example 3 with DatatableUpdateProperties

use of io.clownfish.clownfish.jdbc.DatatableUpdateProperties in project Clownfish by rawdog71.

the class Clownfish method makeResponse.

/**
 * makeResponse
 *
 * @param name
 * @param postmap
 * @param urlParams
 * @param makestatic
 * @return
 * @throws io.clownfish.clownfish.exceptions.PageNotFoundException
 */
@Async
public Future<ClownfishResponse> makeResponse(String name, List<JsonFormParameter> postmap, List urlParams, boolean makestatic) throws PageNotFoundException {
    ClownfishResponse cfresponse = new ClownfishResponse();
    try {
        List<CfSitedatasource> sitedatasourcelist = null;
        // Freemarker Template
        freemarker.template.Template fmTemplate = null;
        Map fmRoot = null;
        // Velocity Template
        org.apache.velocity.VelocityContext velContext = null;
        org.apache.velocity.Template velTemplate = null;
        // fetch parameter list
        Map parametermap = clownfishutil.getParametermap(postmap);
        // manage urlParams
        clownfishutil.addUrlParams(parametermap, urlParams);
        preview = false;
        if (parametermap.containsKey("preview")) {
            // check mode for display (preview or productive)
            if (parametermap.get("preview").toString().compareToIgnoreCase("true") == 0) {
                preview = true;
            }
        }
        if (parametermap.containsKey("modus")) {
            // check mode for display (staging or dev)
            if (parametermap.get("modus").toString().compareToIgnoreCase("dev") == 0) {
                modus = DEVELOPMENT;
            }
        }
        // fetch site by name or aliasname
        CfSite cfsite = null;
        try {
            cfsite = cfsiteService.findByName(name);
        } catch (Exception ex) {
            try {
                cfsite = cfsiteService.findByAliaspath(name);
            } catch (Exception e1) {
                throw new PageNotFoundException("PageNotFound Exception: " + name);
            }
        }
        // Site has not job flag
        if (!cfsite.isJob()) {
            // increment site hitcounter
            if ((!preview) && (modus == STAGING)) {
                long hitcounter = cfsite.getHitcounter().longValue();
                cfsite.setHitcounter(BigInteger.valueOf(hitcounter + 1));
                cfsiteService.edit(cfsite);
            }
            // Site has static flag
            if ((cfsite.isStaticsite()) && (!makestatic) && (!preview)) {
                if ((cfsite.getContenttype() != null)) {
                    if (!cfsite.getContenttype().isEmpty()) {
                        this.contenttype = cfsite.getContenttype();
                    }
                }
                if ((cfsite.getCharacterencoding() != null)) {
                    if (!cfsite.getCharacterencoding().isEmpty()) {
                        this.characterencoding = cfsite.getCharacterencoding();
                    }
                }
                if ((cfsite.getLocale() != null)) {
                    if (!cfsite.getLocale().isEmpty()) {
                        this.locale = cfsite.getLocale();
                    }
                }
                cfresponse = getStaticSite(name);
                if (0 == cfresponse.getErrorcode()) {
                    return new AsyncResult<>(cfresponse);
                } else {
                    Future<ClownfishResponse> cfStaticResponse = makeResponse(name, postmap, urlParams, true);
                    try {
                        String aliasname = cfsite.getAliaspath();
                        StaticSiteUtil.generateStaticSite(name, aliasname, cfStaticResponse.get().getOutput(), cfassetService, folderUtil);
                        return makeResponse(name, postmap, urlParams, false);
                    } catch (InterruptedException | ExecutionException ex) {
                        LOGGER.error(ex.getMessage());
                        return makeResponse(name, postmap, urlParams, false);
                    }
                }
            } else {
                if ((cfsite.getContenttype() != null)) {
                    if (!cfsite.getContenttype().isEmpty()) {
                        this.contenttype = cfsite.getContenttype();
                    }
                }
                if ((cfsite.getCharacterencoding() != null)) {
                    if (!cfsite.getCharacterencoding().isEmpty()) {
                        this.characterencoding = cfsite.getCharacterencoding();
                    }
                }
                if ((cfsite.getLocale() != null)) {
                    if (!cfsite.getLocale().isEmpty()) {
                        this.locale = cfsite.getLocale();
                    }
                }
                try {
                    CfTemplate cftemplate = cftemplateService.findById(cfsite.getTemplateref().longValue());
                    // fetch the dependend template
                    boolean isScripted = false;
                    switch(cftemplate.getScriptlanguage()) {
                        case // FREEMARKER
                        0:
                            fmRoot = new LinkedHashMap();
                            freemarkerTemplateloader.setModus(modus);
                            freemarkerCfg = new freemarker.template.Configuration();
                            freemarkerCfg.setDefaultEncoding("UTF-8");
                            freemarkerCfg.setTemplateLoader(freemarkerTemplateloader);
                            freemarkerCfg.setLocalizedLookup(false);
                            freemarkerCfg.setLocale(Locale.GERMANY);
                            fmTemplate = freemarkerCfg.getTemplate(cftemplate.getName());
                            isScripted = true;
                            break;
                        case // VELOCITY
                        1:
                            velContext = new org.apache.velocity.VelocityContext();
                            velTemplate = new org.apache.velocity.Template();
                            org.apache.velocity.runtime.RuntimeServices runtimeServices = org.apache.velocity.runtime.RuntimeSingleton.getRuntimeServices();
                            String templateContent;
                            if (DEVELOPMENT == modus) {
                                templateContent = cftemplate.getContent();
                            } else {
                                long currentTemplateVersion;
                                try {
                                    currentTemplateVersion = cftemplateversionService.findMaxVersion(cftemplate.getId());
                                } catch (NullPointerException ex) {
                                    currentTemplateVersion = 0;
                                }
                                templateContent = templateUtil.getVersion(cftemplate.getId(), currentTemplateVersion);
                            }
                            templateContent = templateUtil.fetchIncludes(templateContent, modus);
                            StringReader reader = new StringReader(templateContent);
                            velTemplate.setRuntimeServices(runtimeServices);
                            velTemplate.setData(runtimeServices.parse(reader, velTemplate));
                            velTemplate.initDocument();
                            isScripted = true;
                            break;
                        default:
                            break;
                    }
                    String gzip = propertyUtil.getPropertySwitch("html_gzip", cfsite.getGzip());
                    if (gzip.compareToIgnoreCase("on") == 0) {
                        gzipswitch.setGzipon(true);
                    }
                    String htmlcompression = propertyUtil.getPropertySwitch("html_compression", cfsite.getHtmlcompression());
                    HtmlCompressor htmlcompressor = new HtmlCompressor();
                    htmlcompressor.setRemoveSurroundingSpaces(HtmlCompressor.BLOCK_TAGS_MAX);
                    htmlcompressor.setPreserveLineBreaks(false);
                    Writer out = new StringWriter();
                    // fetch the dependend stylesheet, if available
                    String cfstylesheet = "";
                    if (cfsite.getStylesheetref() != null) {
                        cfstylesheet = ((CfStylesheet) cfstylesheetService.findById(cfsite.getStylesheetref().longValue())).getContent();
                        if (htmlcompression.compareToIgnoreCase("on") == 0) {
                            htmlcompressor.setCompressCss(true);
                            cfstylesheet = htmlcompressor.compress(cfstylesheet);
                        }
                    }
                    // fetch the dependend javascript, if available
                    String cfjavascript = "";
                    if (cfsite.getJavascriptref() != null) {
                        cfjavascript = ((CfJavascript) cfjavascriptService.findById(cfsite.getJavascriptref().longValue())).getContent();
                        if (htmlcompression.compareToIgnoreCase("on") == 0) {
                            htmlcompressor.setCompressJavaScript(true);
                            cfjavascript = htmlcompressor.compress(cfjavascript);
                        }
                    }
                    if (!cftemplate.isLayout()) {
                        // NORMAL Template
                        // fetch the dependend content
                        List<CfSitecontent> sitecontentlist = new ArrayList<>();
                        sitecontentlist.addAll(cfsitecontentService.findBySiteref(cfsite.getId()));
                        sitecontentmap = siteutil.getSitecontentmapList(sitecontentlist);
                        // fetch the dependend datalists, if available
                        sitecontentmap = siteutil.getSitelist_list(cfsite, sitecontentmap);
                        // fetch the site assetlibraries
                        sitecontentmap = siteutil.getSiteAssetlibrary(cfsite, sitecontentmap);
                        // fetch the site keywordlibraries
                        sitecontentmap = siteutil.getSiteKeywordlibrary(cfsite, sitecontentmap);
                    } else {
                        // LAYOUT Template
                        // Fetch the dependent content
                        List<CfLayoutcontent> layoutcontentlist = cflayoutcontentService.findBySiteref(cfsite.getId());
                        List<CfLayoutcontent> contentlist = layoutcontentlist.stream().filter(lc -> lc.getCfLayoutcontentPK().getContenttype().compareToIgnoreCase("C") == 0).collect(Collectors.toList());
                        List<CfClasscontent> classcontentlist = new ArrayList<>();
                        for (CfLayoutcontent layoutcontent : contentlist) {
                            if (preview) {
                                if (layoutcontent.getPreview_contentref().longValue() > 0) {
                                    classcontentlist.add(cfclasscontentService.findById(layoutcontent.getPreview_contentref().longValue()));
                                }
                            } else {
                                if ((null != layoutcontent.getContentref()) && (layoutcontent.getContentref().longValue() > 0)) {
                                    classcontentlist.add(cfclasscontentService.findById(layoutcontent.getContentref().longValue()));
                                }
                            }
                        }
                        sitecontentmap = siteutil.getClasscontentmapList(classcontentlist);
                        // fetch the dependend datalists, if available
                        contentlist = layoutcontentlist.stream().filter(lc -> lc.getCfLayoutcontentPK().getContenttype().compareToIgnoreCase("DL") == 0).collect(Collectors.toList());
                        List<CfList> sitelist = new ArrayList<>();
                        for (CfLayoutcontent layoutcontent : contentlist) {
                            if (preview) {
                                if (layoutcontent.getPreview_contentref().longValue() > 0) {
                                    sitelist.add(cflistService.findById(layoutcontent.getPreview_contentref().longValue()));
                                }
                            } else {
                                if ((null != layoutcontent.getContentref()) && (layoutcontent.getContentref().longValue() > 0)) {
                                    sitelist.add(cflistService.findById(layoutcontent.getContentref().longValue()));
                                }
                            }
                        }
                        sitecontentmap = siteutil.getSitelist_list(sitelist, sitecontentmap);
                        // fetch the dependend assetlibraries, if available
                        contentlist = layoutcontentlist.stream().filter(lc -> lc.getCfLayoutcontentPK().getContenttype().compareToIgnoreCase("AL") == 0).collect(Collectors.toList());
                        List<CfAssetlist> assetlibrary_list = new ArrayList<>();
                        for (CfLayoutcontent layoutcontent : contentlist) {
                            if (preview) {
                                if (layoutcontent.getPreview_contentref().longValue() > 0) {
                                    assetlibrary_list.add(cfassetlistService.findById(layoutcontent.getPreview_contentref().longValue()));
                                }
                            } else {
                                if ((null != layoutcontent.getContentref()) && (layoutcontent.getContentref().longValue() > 0)) {
                                    assetlibrary_list.add(cfassetlistService.findById(layoutcontent.getContentref().longValue()));
                                }
                            }
                        }
                        sitecontentmap = siteutil.getAssetlibrary(assetlibrary_list, sitecontentmap);
                        // fetch the site keywordlibraries
                        contentlist = layoutcontentlist.stream().filter(lc -> lc.getCfLayoutcontentPK().getContenttype().compareToIgnoreCase("KL") == 0).collect(Collectors.toList());
                        List<CfKeywordlist> keywordlibrary_list = new ArrayList<>();
                        for (CfLayoutcontent layoutcontent : contentlist) {
                            if (preview) {
                                if (layoutcontent.getPreview_contentref().longValue() > 0) {
                                    keywordlibrary_list.add(cfkeywordlistService.findById(layoutcontent.getPreview_contentref().longValue()));
                                }
                            } else {
                                if ((null != layoutcontent.getContentref()) && (layoutcontent.getContentref().longValue() > 0)) {
                                    keywordlibrary_list.add(cfkeywordlistService.findById(layoutcontent.getContentref().longValue()));
                                }
                            }
                        }
                        sitecontentmap = siteutil.getSiteKeywordlibrary(keywordlibrary_list, sitecontentmap);
                    }
                    // manage parameters
                    HashMap<String, DatatableProperties> datatableproperties = clownfishutil.getDatatableproperties(postmap);
                    EmailProperties emailproperties = clownfishutil.getEmailproperties(postmap);
                    HashMap<String, DatatableNewProperties> datatablenewproperties = clownfishutil.getDatatablenewproperties(postmap);
                    HashMap<String, DatatableDeleteProperties> datatabledeleteproperties = clownfishutil.getDatatabledeleteproperties(postmap);
                    HashMap<String, DatatableUpdateProperties> datatableupdateproperties = clownfishutil.getDatatableupdateproperties(postmap);
                    manageSessionVariables(postmap);
                    writeSessionVariables(parametermap);
                    // fetch the dependend datasources
                    sitedatasourcelist = new ArrayList<>();
                    sitedatasourcelist.addAll(cfsitedatasourceService.findBySiteref(cfsite.getId()));
                    HashMap<String, HashMap> dbexport = databaseUtil.getDbexport(sitedatasourcelist, datatableproperties, datatablenewproperties, datatabledeleteproperties, datatableupdateproperties);
                    sitecontentmap.put("db", dbexport);
                    // Put meta info to sitecontentmap
                    metainfomap.put("title", cfsite.getTitle());
                    metainfomap.put("description", cfsite.getDescription());
                    metainfomap.put("name", cfsite.getName());
                    metainfomap.put("encoding", cfsite.getCharacterencoding());
                    metainfomap.put("contenttype", cfsite.getContenttype());
                    metainfomap.put("locale", cfsite.getLocale());
                    metainfomap.put("alias", cfsite.getAliaspath());
                    // instantiate Template Beans
                    networkbean = new NetworkTemplateBean();
                    webservicebean = new WebServiceTemplateBean();
                    emailbean = new EmailTemplateBean();
                    emailbean.init(propertyUtil.getPropertymap(), mailUtil, propertyUtil);
                    // send a mail, if email properties are set
                    if (emailproperties != null) {
                        try {
                            sendRespondMail(emailproperties.getSendto(), emailproperties.getSubject(), emailproperties.getBody());
                        } catch (Exception ex) {
                            LOGGER.error(ex.getMessage());
                        }
                    }
                    if (sapSupport) {
                        List<CfSitesaprfc> sitesaprfclist = new ArrayList<>();
                        sitesaprfclist.addAll(cfsitesaprfcService.findBySiteref(cfsite.getId()));
                        sapbean = new SAPTemplateBean();
                        sapbean.init(sapc, sitesaprfclist, rpytableread, postmap);
                    }
                    databasebean = new DatabaseTemplateBean();
                    importbean = new ImportTemplateBean();
                    pdfbean = new PDFTemplateBean();
                    pdfbean.init(pdfUtil);
                    if (!sitedatasourcelist.isEmpty()) {
                        databasebean.init(sitedatasourcelist, cfdatasourceService);
                        importbean.init(sitedatasourcelist, cfdatasourceService);
                    }
                    externalclassproviderbean = new ExternalClassProvider(cfclassCompiler);
                    if (isScripted) {
                        // NORMAL Template
                        switch(cftemplate.getScriptlanguage()) {
                            case // FREEMARKER
                            0:
                                if (null != fmRoot) {
                                    fmRoot.put("css", cfstylesheet);
                                    fmRoot.put("js", cfjavascript);
                                    fmRoot.put("sitecontent", sitecontentmap);
                                    fmRoot.put("metainfo", metainfomap);
                                    fmRoot.put("property", propertyUtil.getPropertymap());
                                    fmRoot.put("emailBean", emailbean);
                                    if (sapSupport) {
                                        fmRoot.put("sapBean", sapbean);
                                    }
                                    fmRoot.put("databaseBean", databasebean);
                                    fmRoot.put("importBean", importbean);
                                    fmRoot.put("networkBean", networkbean);
                                    fmRoot.put("webserviceBean", webservicebean);
                                    fmRoot.put("pdfBean", pdfbean);
                                    fmRoot.put("classBean", externalclassproviderbean);
                                    fmRoot.put("parameter", parametermap);
                                    if (!searchmetadata.isEmpty()) {
                                        fmRoot.put("searchmetadata", searchmetadata);
                                    }
                                    if (!searchcontentmap.isEmpty()) {
                                        fmRoot.put("searchcontentlist", searchcontentmap);
                                    }
                                    if (!searchassetmap.isEmpty()) {
                                        fmRoot.put("searchassetlist", searchassetmap);
                                    }
                                    if (!searchassetmetadatamap.isEmpty()) {
                                        fmRoot.put("searchassetmetadatalist", searchassetmetadatamap);
                                    }
                                    if (!searchclasscontentmap.isEmpty()) {
                                        fmRoot.put("searchclasscontentlist", searchclasscontentmap);
                                    }
                                    for (Class<?> tpbc : beanUtil.getLoadabletemplatebeans()) {
                                        Constructor<?> ctor;
                                        try {
                                            ctor = tpbc.getConstructor();
                                            Object object = ctor.newInstance();
                                            fmRoot.put(tpbc.getName().replaceAll("\\.", "_"), object);
                                        } catch (NoSuchMethodException | SecurityException | InstantiationException | IllegalAccessException | IllegalArgumentException | InvocationTargetException ex) {
                                            LOGGER.error(ex.getMessage());
                                        }
                                    }
                                    /*
                                        for (Class<?> c : classpathUtil.getClass_set()) {
                                            Constructor<?> ctor;
                                            try {
                                                if (!Modifier.isInterface(c.getModifiers()) && !Modifier.isAbstract(c.getModifiers()) && !Modifier.isFinal(c.getModifiers()))
                                                {
                                                    ctor = c.getConstructor();
                                                    Object object = ctor.newInstance();
                                                    fmRoot.put(c.getName().replaceAll("\\.", "_"), object);
                                                }
                                            } catch (NoClassDefFoundError | NoSuchMethodException | SecurityException | InstantiationException | IllegalAccessException | IllegalArgumentException | InvocationTargetException ex) {
                                                if (ex instanceof NoSuchMethodException || ex instanceof IllegalAccessException || ex instanceof InvocationTargetException || ex instanceof NoClassDefFoundError)
                                                    continue;

                                                LOGGER.error(ex.getMessage());
                                            }
                                        }
                                        */
                                    Map finalFmRoot = fmRoot;
                                    cfclassCompiler.getClassMethodMap().forEach((k, v) -> {
                                        Constructor<?> ctor;
                                        try {
                                            ctor = k.getConstructor();
                                            Object object = ctor.newInstance();
                                            finalFmRoot.put(k.getName().replaceAll("\\.", "_"), object);
                                        } catch (NoSuchMethodException | SecurityException | InstantiationException | IllegalAccessException | IllegalArgumentException | InvocationTargetException ex) {
                                            LOGGER.error(ex.getMessage());
                                        }
                                    });
                                    try {
                                        if (null != fmTemplate) {
                                            if (cftemplate.isLayout()) {
                                                String output = manageLayout(cfsite, cftemplate.getName(), cftemplate.getContent(), cfstylesheet, cfjavascript, parametermap);
                                                output = interpretscript(output, cftemplate, cfstylesheet, cfjavascript, parametermap);
                                                out.write(output);
                                            } else {
                                                freemarker.core.Environment env = fmTemplate.createProcessingEnvironment(fmRoot, out);
                                                env.process();
                                            }
                                        }
                                    } catch (freemarker.template.TemplateException ex) {
                                        LOGGER.error(ex.getMessage());
                                    }
                                }
                                break;
                            case // VELOCITY
                            1:
                                if (null != velContext) {
                                    velContext.put("css", cfstylesheet);
                                    velContext.put("js", cfjavascript);
                                    velContext.put("sitecontent", sitecontentmap);
                                    velContext.put("metainfo", metainfomap);
                                    velContext.put("emailBean", emailbean);
                                    if (sapSupport) {
                                        velContext.put("sapBean", sapbean);
                                    }
                                    velContext.put("databaseBean", databasebean);
                                    velContext.put("importBean", importbean);
                                    velContext.put("networkBean", networkbean);
                                    velContext.put("webserviceBean", webservicebean);
                                    velContext.put("pdfBean", pdfbean);
                                    velContext.put("classBean", externalclassproviderbean);
                                    velContext.put("parameter", parametermap);
                                    velContext.put("property", propertyUtil.getPropertymap());
                                    if (!searchmetadata.isEmpty()) {
                                        velContext.put("searchmetadata", searchmetadata);
                                    }
                                    if (!searchcontentmap.isEmpty()) {
                                        velContext.put("searchcontentlist", searchcontentmap);
                                    }
                                    if (!searchassetmap.isEmpty()) {
                                        velContext.put("searchassetlist", searchassetmap);
                                    }
                                    if (!searchassetmetadatamap.isEmpty()) {
                                        velContext.put("searchassetmetadatalist", searchassetmetadatamap);
                                    }
                                    if (!searchclasscontentmap.isEmpty()) {
                                        velContext.put("searchclasscontentlist", searchclasscontentmap);
                                    }
                                    for (Class tpbc : beanUtil.getLoadabletemplatebeans()) {
                                        Constructor<?> ctor;
                                        try {
                                            ctor = tpbc.getConstructor();
                                            Object object = ctor.newInstance(new Object[] {});
                                            velContext.put(tpbc.getName().replaceAll("\\.", "_"), object);
                                        } catch (NoSuchMethodException | SecurityException | InstantiationException | IllegalAccessException | IllegalArgumentException | InvocationTargetException ex) {
                                            LOGGER.error(ex.getMessage());
                                        }
                                    }
                                    /*
                                        for (Class<?> c : classpathUtil.getClass_set()) {
                                            Constructor<?> ctor;
                                            try {
                                                if (!Modifier.isInterface(c.getModifiers()) && !Modifier.isAbstract(c.getModifiers()) && !Modifier.isFinal(c.getModifiers()))
                                                {
                                                    ctor = c.getConstructor();
                                                    Object object = ctor.newInstance();
                                                    velContext.put(c.getName().replaceAll("\\.", "_"), object);
                                                }
                                            } catch (NoClassDefFoundError | NoSuchMethodException | SecurityException | InstantiationException | IllegalAccessException | IllegalArgumentException | InvocationTargetException ex) {
                                                if (ex instanceof NoSuchMethodException || ex instanceof IllegalAccessException || ex instanceof InvocationTargetException || ex instanceof NoClassDefFoundError)
                                                    continue;

                                                LOGGER.error(ex.getMessage());
                                            }
                                        }
                                        */
                                    org.apache.velocity.VelocityContext finalvelContext = velContext;
                                    cfclassCompiler.getClassMethodMap().forEach((k, v) -> {
                                        Constructor<?> ctor;
                                        try {
                                            ctor = k.getConstructor();
                                            Object object = ctor.newInstance();
                                            finalvelContext.put(k.getName().replaceAll("\\.", "_"), object);
                                        } catch (NoSuchMethodException | SecurityException | InstantiationException | IllegalAccessException | IllegalArgumentException | InvocationTargetException ex) {
                                            LOGGER.error(ex.getMessage());
                                        }
                                    });
                                    if (null != velTemplate) {
                                        if (cftemplate.isLayout()) {
                                            String output = manageLayout(cfsite, cftemplate.getName(), cftemplate.getContent(), cfstylesheet, cfjavascript, parametermap);
                                            output = interpretscript(output, cftemplate, cfstylesheet, cfjavascript, parametermap);
                                            out.write(output);
                                        } else {
                                            velTemplate.merge(velContext, out);
                                        }
                                    }
                                }
                                break;
                            // HTML
                            default:
                        }
                    } else {
                        // LAYOUT Template
                        if (cftemplate.isLayout()) {
                            String output = manageLayout(cfsite, cftemplate.getName(), cftemplate.getContent(), cfstylesheet, cfjavascript, parametermap);
                            out.write(output);
                            out.flush();
                            out.close();
                        } else {
                            out.write(cftemplate.getContent());
                            out.flush();
                            out.close();
                        }
                    }
                    if (htmlcompression.compareToIgnoreCase("on") == 0) {
                        htmlcompressor.setCompressCss(false);
                        htmlcompressor.setCompressJavaScript(false);
                        cfresponse.setErrorcode(0);
                        cfresponse.setOutput(htmlcompressor.compress(out.toString()));
                        // LOGGER.info("END makeResponse: " + name);
                        return new AsyncResult<>(cfresponse);
                    } else {
                        cfresponse.setErrorcode(0);
                        cfresponse.setOutput(out.toString());
                        // LOGGER.info("END makeResponse: " + name);
                        return new AsyncResult<>(cfresponse);
                    }
                } catch (NoResultException ex) {
                    LOGGER.info("Exception: " + ex);
                    cfresponse.setErrorcode(1);
                    cfresponse.setOutput("No template");
                    // LOGGER.info("END makeResponse: " + name);
                    return new AsyncResult<>(cfresponse);
                }
            }
        } else {
            cfresponse.setErrorcode(2);
            cfresponse.setOutput("Only for Job calling");
            return new AsyncResult<>(cfresponse);
        }
    } catch (IOException | org.apache.velocity.runtime.parser.ParseException ex) {
        cfresponse.setErrorcode(1);
        cfresponse.setOutput(ex.getMessage());
        // LOGGER.info("END makeResponse: " + name);
        return new AsyncResult<>(cfresponse);
    }
}