Subversion Repositories SmartDukaan

Rev

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

Rev 5711 Rev 5768
Line 80... Line 80...
80 
        try {
 80 
        try {
81 
            File file = new File("InventoryAge.xls");
 81 
            File file = new File("InventoryAge.xls");
82 
            BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(file));
 82 
            BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(file));
83 
            bufferedWriter.write(StringUtils.join(new String[] {
 83 
            bufferedWriter.write(StringUtils.join(new String[] {
84 
                    "Item Id",
 84 
                    "Item Id",
- 
 
 85 
                    "Category",
85 
                    "Brand",
 86 
                    "Brand",
86 
                    "Model Name",
 87 
                    "Model Name",
87 
                    "Model Number",
 88 
                    "Model Number",
88 
                    "Color",
 89 
                    "Color",
89 
                    "Fresh",
 90 
                    "Fresh",
90 
                    "1-2 week",
 91 
                    "1-2 week",
91 
                    "2-3 week",
 92 
                    "2-3 week",
92 
                    "3-4 week",
 93 
                    "3-4 week",
- 
 
 94 
                    "4+ week",
- 
 
 95 
                    "1+ week",
- 
 
 96 
                    "1+ week cost",
- 
 
 97 
                    "All",
93 
                    "4+ week"}, '\t'));
 98 
                    "All cost" }, '\t'));
94 
 
 99 
 
95 
            for (InventoryAge item : inventoryAge) {
 100 
            for (InventoryAge item : inventoryAge) {
96 
                bufferedWriter.newLine();
 101 
                bufferedWriter.newLine();
97 
 
 102 
 
98 
                bufferedWriter.write(StringUtils.join(
 103 
                bufferedWriter.write(StringUtils.join(
99 
                        new String[] {
 104 
                        new String[] {
100 
                                String.valueOf(item.getItemId()),
 105 
                                String.valueOf(item.getItemId()),
- 
 
 106 
                                item.getCategory(),
101 
                                item.getBrand(),
 107 
                                item.getBrand(),
102 
                                item.getModelName(),
 108 
                                item.getModelName(),
103 
                                item.getModelNumber(),
 109 
                                item.getModelNumber(),
104 
                                item.getColor(),
 110 
                                item.getColor(),
105 
                                String.valueOf(item.getFreshCount()),
 111 
                                String.valueOf(item.getFreshCount()),
106 
                                String.valueOf(item.getOneToTwoCount()),
 112 
                                String.valueOf(item.getOneToTwoCount()),
107 
                                String.valueOf(item.getTwoToThreeCount()),
 113 
                                String.valueOf(item.getTwoToThreeCount()),
108 
                                String.valueOf(item.getThreeToFourCount()),
 114 
                                String.valueOf(item.getThreeToFourCount()),
- 
 
 115 
                                String.valueOf(item.getFourPlusCount()),
- 
 
 116 
                                String.valueOf(item.getOnePlusCount()),
- 
 
 117 
                                String.valueOf(item.getOnePlusCost()),
- 
 
 118 
                                String.valueOf(item.getZeroPlusCount()),
109 
                                String.valueOf(item.getFourPlusCount())}, '\t'));
 119 
                                String.valueOf(item.getZeroPlusCost())}, '\t'));
110 
            }
 120 
            }
111 
 
 121 
 
112 
            bufferedWriter.close();
 122 
            bufferedWriter.close();
113 
            return file;
 123 
            return file;
114 
        } catch (Exception e) {
 124 
        } catch (Exception e) {