Subversion Repositories SmartDukaan

Rev

Rev 12856 | Rev 13048 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 12856 Rev 12931
Line 3... Line 3...
3 
import in.shop2020.thrift.clients.WarehouseClient;
 3 
import in.shop2020.thrift.clients.WarehouseClient;
4 
import in.shop2020.utils.GmailUtils;
 4 
import in.shop2020.utils.GmailUtils;
5 
import in.shop2020.warehouse.InventoryAvailability;
 5 
import in.shop2020.warehouse.InventoryAvailability;
6 
import in.shop2020.warehouse.WarehouseService.Client;
 6 
import in.shop2020.warehouse.WarehouseService.Client;
7 
 
 7 
 
- 
 
 8 
import java.io.BufferedReader;
8 
import java.io.BufferedWriter;
 9 
import java.io.BufferedWriter;
9 
import java.io.File;
 10 
import java.io.File;
- 
 
 11 
import java.io.FileReader;
10 
import java.io.FileWriter;
 12 
import java.io.FileWriter;
11 
import java.io.IOException;
 13 
import java.io.IOException;
12 
import java.util.ArrayList;
 14 
import java.util.ArrayList;
13 
import java.util.Date;
 15 
import java.util.Date;
14 
import java.util.List;
 16 
import java.util.List;
Line 41... Line 43...
41 
		}
 43 
		}
42 
		inventoryAvailability.addAll(serializedInventoryAvailability);
 44 
		inventoryAvailability.addAll(serializedInventoryAvailability);
43 
		inventoryAvailability.addAll(nonSerializedInventoryAvailability);
 45 
		inventoryAvailability.addAll(nonSerializedInventoryAvailability);
44 
		try {
 46 
		try {
45 
			file = createInventoryAvailabilityFile(inventoryAvailability);
 47 
			file = createInventoryAvailabilityFile(inventoryAvailability);
- 
 
 48 
			String htmlFileName = getHtmlFileGenrator(file, "Stock Sheet - Hyderabad");
46 
			List<File> files  = new ArrayList<File>();
 49 
			List<File> files  = new ArrayList<File>();
47 
			files.add(file);
 50 
			files.add(file);
- 
 
 51 
			if(htmlFileName!=null && !htmlFileName.isEmpty()){
- 
 
 52 
				mailer.sendSSLMessage(sendTo, "Stock Sheet - Hyderabad", " ", emailFromAddress, password, files, htmlFileName);
- 
 
 53 
			}else {
48 
			mailer.sendSSLMessage(sendTo, "Stock Sheet - Hyderabad", " ", emailFromAddress, password, files);
 54 
				mailer.sendSSLMessage(sendTo, "Stock Sheet - Hyderabad", " ", emailFromAddress, password, files);
- 
 
 55 
			}
49 
		}
 56 
		}
50 
		catch(Exception e) {
 57 
		catch(Exception e) {
51 
			logger.error(e.getMessage(), e);
 58 
			logger.error(e.getMessage(), e);
52 
		}
 59 
		}
53 
	}
 60 
	}
54
61 
 
55
62 
 
56 
	private static File createInventoryAvailabilityFile(List<InventoryAvailability> inventoryAvailability) throws IOException {
 63 
	private static File createInventoryAvailabilityFile(List<InventoryAvailability> inventoryAvailability) throws IOException {
57 
		File file = new File("/tmp/SaholicInventory-Hyderabad.xls");
 64 
		File file = new File("/tmp/SaholicInventory-Hyderabad.xls");
58 
        BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(file));
 65 
		BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(file));
59 
        bufferedWriter.write(StringUtils.join(new String[] {
 66 
		bufferedWriter.write(StringUtils.join(new String[] {
60 
                "Item Id",
 67 
				"Item Id",
61 
                "Brand",
 68 
				"Brand",
62 
                "Model Name",
 69 
				"Model Name",
63 
                "Model Number",
 70 
				"Model Number",
64 
                "Color",
 71 
				"Color",
65 
                "Quantity" }, '\t'));
 72 
		"Quantity" }, '\t'));
66 
 
 73 
 
67 
        for(InventoryAvailability invAvailability : inventoryAvailability) {
 74 
		for(InventoryAvailability invAvailability : inventoryAvailability) {
68 
        	if((invAvailability.getModelNumber().equals("Q50")) || (invAvailability.getItemId() == 1457)) {
 75 
			if((invAvailability.getModelNumber().equals("Q50")) || (invAvailability.getItemId() == 1457)) {
69 
        		continue;
 76 
				continue;
70 
        	}
 77 
			}
71 
            bufferedWriter.newLine();
 78 
			bufferedWriter.newLine();
72 
            bufferedWriter.write(StringUtils.join(
 79 
			bufferedWriter.write(StringUtils.join(
73 
                    new String[] {
 80 
					new String[] {
74 
                            String.valueOf(invAvailability.getItemId()),
 81 
							String.valueOf(invAvailability.getItemId()),
75 
                            invAvailability.getBrand(),
 82 
							invAvailability.getBrand(),
76 
                            invAvailability.getModelName(),
 83 
							invAvailability.getModelName(),
77 
                            invAvailability.getModelNumber(),
 84 
							invAvailability.getModelNumber(),
78 
                            invAvailability.getColor(),
 85 
							invAvailability.getColor(),
79 
                            String.valueOf(invAvailability.getQuantity())}, '\t'));
 86 
							String.valueOf(invAvailability.getQuantity())}, '\t'));
80 
        }
 87 
		}
81 
		bufferedWriter.close();
 88 
		bufferedWriter.close();
82 
		return file;
 89 
		return file;
83 
	}
 90 
	}
- 
 
 91 
 
- 
 
 92 
	public static String getHtmlFileGenrator(File file, String tableTitle){
- 
 
 93 
 
- 
 
 94 
		String htmlFilePath = "/tmp/"+tableTitle+"-file.htm";
- 
 
 95 
		StringBuffer sb = new StringBuffer();
- 
 
 96 
		sb.append("");
- 
 
 97 
 
- 
 
 98 
		try{
- 
 
 99 
			BufferedReader br = new BufferedReader(new FileReader(file));
- 
 
 100 
			String line = "";
- 
 
 101 
 
- 
 
 102 
			sb.append("<html><table border=\"1\" align=\"center\">"
- 
 
 103 
					+ "<caption><b>" + tableTitle + "</b></caption>");
- 
 
 104 
 
- 
 
 105 
			int lineCount = 1;
- 
 
 106 
			while((line = br.readLine())!= null){
- 
 
 107 
				String[] values = line.split("\t");
- 
 
 108 
				sb.append("<tr>");
- 
 
 109 
				for(String value : values){
- 
 
 110 
					if(lineCount ==1){
- 
 
 111 
						sb.append("<td><b>"+ value.toUpperCase()+"</b></td>");
- 
 
 112 
					}else{
- 
 
 113 
						sb.append("<td>"+ value+"</td>");
- 
 
 114 
					}
- 
 
 115 
				}
- 
 
 116 
				sb.append("</tr>");
- 
 
 117 
				lineCount++;
- 
 
 118 
			}
- 
 
 119 
 
- 
 
 120 
			sb.append("</table></html>");
- 
 
 121 
 
- 
 
 122 
			BufferedWriter out = new BufferedWriter(new FileWriter(htmlFilePath));
- 
 
 123 
			out.write(sb.toString());
- 
 
 124 
			out.flush();
- 
 
 125 
			out.close();
- 
 
 126 
 
- 
 
 127 
		}
- 
 
 128 
		catch(Exception e){
- 
 
 129 
			e.printStackTrace();
- 
 
 130 
			return "";
- 
 
 131 
		}
- 
 
 132 
		return htmlFilePath;
- 
 
 133 
	}
84 
}
 134 
}
85 

            135