Subversion Repositories SmartDukaan

Rev

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

Rev 5711 Rev 6284
Line 94... Line 94...
94 
                    + ".xls");
 94 
                    + ".xls");
95 
            BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(
 95 
            BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(
96 
                    file));
 96 
                    file));
97 
            bufferedWriter.write(StringUtils.join(new String[] { "Order Id",
 97 
            bufferedWriter.write(StringUtils.join(new String[] { "Order Id",
98 
                    "Customer Name", "Customer City", "Invoice Number",
 98 
                    "Customer Name", "Customer City", "Invoice Number",
99 
                    "Billing Date", "Unit Price", "Quantity", "Net Amount",
 99 
                    "Billing Date", "Item Id", "Color", "Unit Price", "Quantity", "Net Amount",
100 
                    "VAT", "Total Amount", "Brand", "Model Number", "Status" },
 100 
                    "VAT", "Total Amount", "Brand", "Model Number", "Status" },
101 
                    '\t'));
 101 
                    '\t'));
102 
 
 102 
 
103 
            for (Order order : orders) {
 103 
            for (Order order : orders) {
104 
                if (order.getWarehouse_id() != 7) {
 104 
                if (order.getWarehouse_id() != 7) {
Line 119... Line 119...
119 
                                order.getCustomer_name(),
 119 
                                order.getCustomer_name(),
120 
                                order.getCustomer_city(),
 120 
                                order.getCustomer_city(),
121 
                                order.getInvoice_number(),
 121 
                                order.getInvoice_number(),
122 
                                sdf.format(new Date(order
 122 
                                sdf.format(new Date(order
123 
                                        .getBilling_timestamp())),
 123 
                                        .getBilling_timestamp())),
- 
 
 124 
                                String.valueOf(lineitem.getItem_id()),
- 
 
 125 
                                lineitem.getColor(),
124 
                                String.valueOf(lineitem.getUnit_price()),
 126 
                                String.valueOf(lineitem.getUnit_price()),
125 
                                String.valueOf(lineitem.getQuantity()),
 127 
                                String.valueOf(lineitem.getQuantity()),
126 
                                String.valueOf(order.getTotal_amount() * 100
 128 
                                String.valueOf(order.getTotal_amount() * 100
127 
                                        / (100 + vatFactor)),
 129 
                                        / (100 + vatFactor)),
128 
                                String.valueOf(order.getTotal_amount()
 130 
                                String.valueOf(order.getTotal_amount()