package com.cargo.crotrol;

import org.apache.struts.action.*;
import javax.servlet.http.*;
import com.cargo.filter.Line;
import com.cargo.model.Order;
import com.cargo.db.Html;
import com.cargo.db.Orderdb;
import java.sql.ResultSet;
import java.util.Collection;
import java.util.ArrayList;
import java.util.Iterator;
import java.sql.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: MR</p>
 * @author BWM
 * @version 1.0
 */
public class PicAction extends Action {
    private ActionForward forward = new ActionForward();
    private Line line = new Line();
    private Html html = new Html();
    private Orderdb db = new Orderdb();
    private Collection coll = new ArrayList();
    private ResultSet rs;
    public ActionForward perform(ActionMapping actionMapping, ActionForm actionForm,
            HttpServletRequest request, HttpServletResponse httpServletResponse) {
        forward = line.down("id", actionMapping, request, "errors");
        if (forward != null && forward.getName().equals("errors")) {
            return forward;
        }
        String [] month = new String[12];
        float[] monthsum = new float[12];
        float sum = (float) 0;
        for (int i = 0; i < month.length; i++) {
            coll.clear();
            //查詢一個月份的定單
            coll = db.select(db.WHERE + "year(getdate())=year(time) AND month(time)=" + (i + 1));
            if (coll != null && !coll.isEmpty()) {
                Iterator it = coll.iterator();
                while (it.hasNext()) {
                    Order order = (Order) it.next();
                    //計算定單中的商品單價
                    String sql = db.SELECT + "price" + db.FROM + "tb_ware" + db.WHERE + "id='" +
                                 order.getCommodity()+"'";
                    rs = db.getRs(sql);
                    try {
                        if (rs.next()) {
                            //統計該商品的總價
                            monthsum[i] += order.getNum() * rs.getFloat(1);
                        }
                    } catch (SQLException ex) {
                        System.out.println(ex.getMessage());
                        System.out.println(sql);
                    }
                    db.close();
                }
            }
            //統計現在總銷售額
            sum += monthsum[i];
        }
        //計算百分比(1-n%)
        for (int i = 0; i < month.length; i++) {
            month[i] = new Integer((int) ((1 - monthsum[i] / sum) * 100)).toString()+"%";
        }
        Html h=new Html();
        h.Pic(month);
        request.setAttribute("sum", h.Pic(month));
        return actionMapping.findForward("success");
    }
}