Bulk download

Created by: sarojsingh2021

src/main/java/com/tarento/formservice/controllers/FormsController.java

@@ -11,7 +11,11 @@ import org.apache.tomcat.util.codec.binary.Base64;
 import org.slf4j.Logger;
 import org.slf4j.LoggerFactory;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.core.io.InputStreamResource;
+import org.springframework.core.io.Resource;
+import org.springframework.http.HttpHeaders;
 import org.springframework.http.MediaType;
+import org.springframework.http.ResponseEntity;
 import org.springframework.web.bind.annotation.DeleteMapping;
 import org.springframework.web.bind.annotation.GetMapping;
 import org.springframework.web.bind.annotation.PostMapping;
@@ -36,6 +40,7 @@ import com.tarento.formservice.model.Status;
 import com.tarento.formservice.model.UserInfo;
 import com.tarento.formservice.models.Form;
 import com.tarento.formservice.models.FormDetail;
+import com.tarento.formservice.models.InstituteFormDataRequest;
 import com.tarento.formservice.service.FormsService;
 import com.tarento.formservice.utils.Constants;
 import com.tarento.formservice.utils.PathRoutes;
@@ -481,4 +486,17 @@ public class FormsController {
 		}
 		return ResponseGenerator.failureResponse(Constants.ResponseMessages.ERROR_MESSAGE);
 	}
+	
+	@GetMapping(value = PathRoutes.FormServiceApi.GET_INSTITUTE_FORM_DATA_EXCEL)
+	public ResponseEntity<Resource> getFile(@RequestBody InstituteFormDataRequest instituteFormDataRequest) {
+	    String filename = "institute.xlsx";
+	    InputStreamResource file = new InputStreamResource(formsService.getInstituteFormData(instituteFormDataRequest.getOrgId()));
+
+	    return ResponseEntity.ok()
+	        .header(HttpHeaders.CONTENT_DISPOSITION, "attachment; filename=" + filename)
+	        .contentType(MediaType.parseMediaType("application/vnd.ms-excel"))
+	        .body(file);
+	  }
+	
+	
 }

src/main/java/com/tarento/formservice/dao/InstituteCoursesDao.java

+package com.tarento.formservice.dao;
+
+import java.util.List;
+
+import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.repository.CrudRepository;
+import org.springframework.stereotype.Repository;
+
+import com.tarento.formservice.models.InstituteCourses;
+import com.tarento.formservice.models.InstitueFormExcelDto;
+
+@Repository
+public interface InstituteCoursesDao extends CrudRepository<InstituteCourses, Long>{
+	
+	@Query(value = "select distinct ic.district_name, ic.center_code, u.username,ic.degree, ic.course from institute_courses ic "
+			+ " inner join user u on (u.id = ic.profile_id) where u.org_id = :orgId" ,
+			nativeQuery=true )
+			
+	List<Object[]> findInstituteForm(Long orgId);
+
+}

src/main/java/com/tarento/formservice/model/InstituteFormDataDto.java

+package com.tarento.formservice.model;
+
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.Getter;
+import lombok.NoArgsConstructor;
+import lombok.Setter;
+
+@Data
+@Getter
+@Setter
+@NoArgsConstructor
+@AllArgsConstructor
+public class InstituteFormDataDto {
+
+	private String districtCode;
+	private String centerCode;
+	private String instituteName;
+	private String degree;
+	private String course;
+	private String formsSavedAsDraft;
+	private String formsSubmitted;
+	private String formsSubmittedTimestamp;
+}

src/main/java/com/tarento/formservice/models/InstitueFormExcelDto.java

+package com.tarento.formservice.models;
+
+import lombok.Data;
+
+@Data
+public class InstitueFormExcelDto {
+	
+	private String districtName;
+	private String centerCode;
+	private String firstName;
+
+}

src/main/java/com/tarento/formservice/models/InstituteCourses.java

+package com.tarento.formservice.models;
+
+import java.util.Date;
+
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.Id;
+import javax.persistence.Table;
+
+import lombok.AllArgsConstructor;
+import lombok.EqualsAndHashCode;
+import lombok.Getter;
+import lombok.NoArgsConstructor;
+import lombok.Setter;
+import lombok.ToString;
+
+@AllArgsConstructor
+@EqualsAndHashCode
+@Getter
+@NoArgsConstructor
+@Setter
+@ToString
+@Entity
+@Table(name = "institute_courses")
+public class InstituteCourses {
+	
+
+	@Id @GeneratedValue
+	@Column(name = "id")
+	private Long id;
+	@Column(name = "district_name")
+	private String districtName;
+	@Column(name = "center_code")
+	private String centerCode;
+	@Column(name = "degree")
+	private String degree;
+	@Column(name = "course")
+	private String course;
+	@Column(name = "applied_year")
+	private String appliedYear;
+	@Column(name = "sector")
+	private String sector;
+	@Column(name = "profile_id")
+	private Long profileId; //Fk UserProfile
+	@Column(name = "created_date")
+	private Date createdDate;
+	@Column(name = "created_by")
+	private Long createdBy;
+	@Column(name = "updated_date")
+	private Date updatedDate;
+	@Column(name = "updated_by")
+	private Long updatedBy;
+	
+}