ramazancesur

import java.lang.annotation.ElementType;
import java.lang.annotation.Retention;
import java.lang.annotation.RetentionPolicy;
import java.lang.annotation.Target;

/**
 * Created by Ramazan on 13.3.2017.
 */
@Retention(RetentionPolicy.RUNTIME)

ramazancesur

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;

ramazancesur

    public List<IHastaBasvuruRaporPojo> getAllHastaBirimRapor() {
        TypedQuery<Object[]> query = getEntityManager().createQuery(
                "SELECT  concat( hastaBasvuru.hasta.kimlik.ad,' ',hastaBasvuru.hasta.kimlik.soyad) as hastaAdiSoyadi, " +
                        "hastaBasvuru.hasta.kimlik.kimlikNo as tcKimlikNo, " +
                        "hastaBasvuru.kodu as kodu, hastaBasvuru.aciklama as aciklama, hastaBasvuru.gonderenPersonel as gonderenPersonel, " +
                        "hastaBirimKayit.birim.ad as birimAdi,concat(hastaBirimKayit.personel.kimlik.ad ,' ',hastaBirimKayit.personel.kimlik.soyad) " +
                        "as personelAdiSoyadi,hastaBirimKayit.takipNumarasi as takipNumarasi " +
                        " FROM " + HastaBirimKayitImpl.class.getSimpleName() + " hastaBirimKayit " +
                        "INNER JOIN hastaBirimKayit.hastaBasvuru hastaBasvuru", Object[].class);

ramazancesur

/*

        <!-- Jasper Report ile alakalı işlemler için gerekli kütüphaneler -->

        <!-- https://mvnrepository.com/artifact/ar.com.fdvs/DynamicJasper -->
        <dependency>
            <groupId>ar.com.fdvs</groupId>
            <artifactId>DynamicJasper</artifactId>
            <version>5.0.9</version>

ramazancesur

 @JsonFormat(shape = JsonFormat.Shape.OBJECT)
    public enum MhrsIstisnaTipi {
        TARIH_ARALIGI(1, "Tarih Aralığı"),
        PERIYODIK(2, "Periyodik");

        private final Integer id;
        private final String name;

        private MhrsIstisnaTipi(Integer id, String name) {
            this.id = id;

ramazancesur

package com.mebitech.util.util.control;

import javassist.*;

import java.io.*;
import java.lang.reflect.Method;
import java.util.HashMap;
import java.util.Map;

/**

ramazancesur

package org.demo.util;

import java.util.Collection;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import javax.persistence.EntityManager;
import javax.persistence.Query;
import javax.persistence.TypedQuery;

ramazancesur

// ReportManager


import net.sf.dynamicreports.jasper.builder.JasperReportBuilder;
import net.sf.dynamicreports.report.builder.DynamicReports;
import net.sf.dynamicreports.report.builder.expression.AbstractComplexExpression;
import net.sf.dynamicreports.report.builder.style.ConditionalStyleBuilder;
import net.sf.dynamicreports.report.builder.style.StyleBuilder;
import net.sf.dynamicreports.report.constant.HorizontalAlignment;
import net.sf.dynamicreports.report.constant.SplitType;

ramazancesur

/*
 <!-- Jasper Report -->

        <!-- https://mvnrepository.com/artifact/ar.com.fdvs/DynamicJasper -->
        <dependency>
            <groupId>ar.com.fdvs</groupId>
            <artifactId>DynamicJasper</artifactId>
            <version>5.0.9</version>
        </dependency>

ramazancesur

/*
Navicat MySQL Data Transfer

Source Server         : Localhost
Source Server Version : 50140
Source Host           : localhost:3306
Source Database       : il_ilce_semt_mah_pk

Target Server Type    : MYSQL
Target Server Version : 50140