Subversion Repositories SmartDukaan

import in.shop2020.logistics.ItemText;

import java.io.BufferedInputStream;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.InputStream;

import java.util.ArrayList;

import javax.servlet.ServletOutputStream;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

	public void downloadAllProductFeeds() throws IOException{

		File file = new File("/tmp/Product-Feeds.xls");

		HSSFWorkbook hwb=new HSSFWorkbook();

		HSSFSheet sheet =  hwb.createSheet("Product Feeds");

		HSSFRow rowhead=   sheet.createRow(0);

		rowhead.createCell(0).setCellValue("Catalog Item Id");

		rowhead.createCell(1).setCellValue("Product Name");

		rowhead.createCell(2).setCellValue("Stock Linked");

		CatalogClient catalogClient = null;

		try {

			catalogClient = new CatalogClient();

		} catch (Exception e1) {

			e1.printStackTrace();

		}

		List<ProductFeedSubmit> feedSubmits = new ArrayList<ProductFeedSubmit>();

		try{

			feedSubmits = catalogClient.getClient().getAllProductFeedSubmit();

		} catch(Exception e){

			e.printStackTrace();

		}

		int i = 1;

		try{

			for(ProductFeedSubmit feedSubmit : feedSubmits){

				HSSFRow rowToAdd = sheet.createRow(i);

				rowToAdd.createCell(0).setCellValue(feedSubmit.getCatalogItemId());

				Item item = catalogClient.getClient().getItemsByCatalogId(feedSubmit.getCatalogItemId()).get(0);

				rowToAdd.createCell(1).setCellValue(item.getBrand() + " "+ item.getModelName() + " " + item.getModelNumber());

				rowToAdd.createCell(2).setCellValue(feedSubmit.isStockLinkedFeed());

				i++;

			}

		} catch(Exception e){

			e.printStackTrace();

		}

		FileOutputStream fileOut = null;

		try {

			fileOut = new FileOutputStream(file);

		} catch (FileNotFoundException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

		try {

			hwb.write(fileOut);

		} catch (IOException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

		try {

			fileOut.close();

		} catch (IOException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

		byte[] buffer = new byte[(int)file.length()];

		InputStream input = null;

		try {

			int totalBytesRead = 0;

			input = new BufferedInputStream(new FileInputStream(file));

			while(totalBytesRead < buffer.length){

				int bytesRemaining = buffer.length - totalBytesRead;

				int bytesRead = input.read(buffer, totalBytesRead, bytesRemaining); 

				if (bytesRead > 0){

					totalBytesRead = totalBytesRead + bytesRead;

				}

			}

		}

		finally {

			input.close();

			file.delete();

		}

		response.setHeader("Content-Disposition", "attachment; filename=\"Product-Feeds.xls\"");

		response.setContentType("application/octet-stream");

		ServletOutputStream sos;

		try {

			sos = response.getOutputStream();

			sos.write(buffer);

			sos.flush();

		} catch (IOException e) {

			System.out.println("Unable to stream the manifest file");

		}   

	}

    	List<Long> itemIds = new ArrayList<Long>();

            for(ItemText text : items)

            	itemIds.add(text.getItemId());