package com.cargo.crotrol;

import java.util.ArrayList;
import java.util.Collection;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.cargo.db.Areadb;
import com.cargo.filter.Line;
import org.apache.struts.action.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: MR</p>
 * @author BWM
 * @version 1.0
 */
public class AreaAction extends Action {
    private ActionErrors errors = new ActionErrors();
    private Areadb db = new Areadb();
    private int t;
    private Line line = new Line();
    private ActionForward forward = new ActionForward();
    //總體Action
    public ActionForward perform(ActionMapping actionMapping,
                                 ActionForm actionForm,
                                 HttpServletRequest request,
                                 HttpServletResponse httpServletResponse) {
        /**@todo: complete the business logic here, this is just a skeleton.*/
        AreaForm form = (AreaForm) actionForm;
        String action = actionMapping.getParameter();
        forward = line.down("id", actionMapping, request, "errors");
        if (forward!=null&&forward.getName().equals("errors")) {
            return forward;
        }
        if ("".equalsIgnoreCase(action)) {
            forward = actionMapping.findForward("errors");
        } else if ("view".equalsIgnoreCase(action)) {
            forward = View(actionMapping, form, request, httpServletResponse);
        } else if ("del".equalsIgnoreCase(action)) {
            forward = Del(actionMapping, form, request, httpServletResponse);
        } else if ("add".equalsIgnoreCase(action)) {
            forward = Add(actionMapping, form, request, httpServletResponse);
        } else if ("edit".equalsIgnoreCase(action)) {
            forward = Edit(actionMapping, form, request, httpServletResponse);
        } else if ("save".equalsIgnoreCase(action)) {
            forward = Save(actionMapping, form, request, httpServletResponse);
        } else {
            forward = actionMapping.findForward("errors");
        }
        return forward;
    }

    //刪除Action
    private ActionForward Del(ActionMapping mapping, AreaForm actionForm,
                              HttpServletRequest request,
                              HttpServletResponse httpServletResponse) {
        String id = request.getParameter("areadel").toString();
        t = db.delete(db.DELETE + "tb_area" + db.WHERE + "id=" + id);
        if (t <= 0) {
            errors.clear();
            errors.add("deletefail", new ActionError("error.delete.fail"));
            saveErrors(request, errors);
        }
        return mapping.findForward("success");
    }

    //添加Action
    private ActionForward Add(ActionMapping mapping, AreaForm actionForm,
                              HttpServletRequest request,
                              HttpServletResponse httpServletResponse) {
        t=db.getRowCount("tb_area where name='"+actionForm.getArea().getName()+"'");
        if(t>0){
            errors.clear();
            errors.add("insertfail", new ActionError("error.area.ifre"));
            saveErrors(request, errors);
            return (new ActionForward(mapping.getInput()));
        }
        t = db.insert(actionForm.getArea());
        if (t <= 0) {
            errors.clear();
            errors.add("insertfail", new ActionError("error.insert.fail"));
            saveErrors(request, errors);
            return (new ActionForward(mapping.getInput()));
        }
        return mapping.findForward("success");
    }

    private ActionForward Edit(ActionMapping mapping, AreaForm form,
                               HttpServletRequest request,
                               HttpServletResponse httpServletResponse) {
        Collection coll = new ArrayList();
        String id = request.getParameter("areaedit").toString();
        coll = db.select(db.WHERE + "id=" + id);
        if (coll == null || coll.isEmpty()) {
            errors.clear();
            errors.add("nodata", new ActionError("error.data.null"));
            saveErrors(request, errors);
        }
        request.setAttribute("Area", coll);
        return mapping.findForward("success");
    }

    private ActionForward Save(ActionMapping mapping, AreaForm form,
                               HttpServletRequest request,
                               HttpServletResponse httpServletResponse) {
        t = db.update(form.getArea());
        if (t <= 0) {
            errors.clear();
            errors.add("updatefail", new ActionError("error.update.fail"));
            saveErrors(request, errors);
            return (new ActionForward(mapping.getInput()));
        }
        return mapping.findForward("success");
    }

    //查看Action
    private ActionForward View(ActionMapping mapping, AreaForm form,
                               HttpServletRequest request,
                               HttpServletResponse response) {
        Collection coll = new ArrayList();
        coll = db.select();
        if (coll == null || coll.isEmpty()) {
            errors.clear();
            errors.add("nodata", new ActionError("error.data.null"));
            saveErrors(request, errors);
        }
        request.setAttribute("Area", coll);
        return mapping.findForward("success");
    }
}