purchaseaction.java

医药供应链管理系统

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.captainli.struts.action;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Date;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Calendar;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;

import com.captainli.bean.MessageBean;
import com.captainli.bean.PurchaseBean;
import com.captainli.bean.RaidBean;
import com.captainli.dboperation.BankDA;
import com.captainli.dboperation.LoginDA;
import com.captainli.dboperation.MessageDA;
import com.captainli.dboperation.ProduitDA;
import com.captainli.dboperation.PurchaseDA;
import com.captainli.dboperation.RaidDA;
import com.captainli.dboperation.intercourseDA;
import com.captainli.struts.form.LoginForm;
import com.captainli.struts.form.PurchaseForm;

/** 
 * MyEclipse Struts
 * Creation date: 12-09-2008
 * 
 * XDoclet definition:
 * @struts.action path="/purchase" name="purchaseForm" scope="request" validate="true"
 */
public class PurchaseAction extends DispatchAction {
	/*
	 * Generated Methods
	 */

	/** 
	 * 入库
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * @throws IOException 
	 */
	public ActionForward addPur(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws IOException {
		//js乱码问题解决
		response.setContentType("text/html;UTF-8");
		response.setCharacterEncoding("UTF-8");
		//获得系统时间
		Calendar cal=Calendar.getInstance();
        SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        String p_time=sdf.format(cal.getTime());
		
        PrintWriter out = response.getWriter();
		
		PurchaseForm purchaseForm = (PurchaseForm) form;// TODO Auto-generated method stub
		PurchaseBean bean = new PurchaseBean();
		int p_id = new ProduitDA().showProId(purchaseForm.getP_p_id().trim());
		
		bean.setP_no(purchaseForm.getP_no());
		bean.setP_type(0);
		bean.setP_i_id(Integer.parseInt(purchaseForm.getP_i_id()));
		bean.setP_l_id(Integer.parseInt(purchaseForm.getP_l_id()));
		bean.setP_w_id(Integer.parseInt(purchaseForm.getP_w_id()));
		bean.setP_p_id(p_id);
		bean.setP_prodate(purchaseForm.getP_prodate());
		bean.setP_u_id(Integer.parseInt(purchaseForm.getP_u_id()));
		bean.setP_effdate(Integer.parseInt(purchaseForm.getP_effdate()));
		bean.setP_quantity(Integer.parseInt(purchaseForm.getP_quantity()));
		bean.setP_price(purchaseForm.getP_price());
		bean.setP_amount(purchaseForm.getP_amount());
		bean.setP_actual(purchaseForm.getP_actual());
		bean.setP_b_id(Integer.parseInt(purchaseForm.getP_b_id()));
		bean.setP_note(purchaseForm.getP_note());
		bean.setP_ver(Integer.parseInt(purchaseForm.getP_ver()));
		bean.setP_time(p_time);
		if(purchaseForm.getP_actual().equals(purchaseForm.getP_amount())){
			bean.setP_mongeytype(true);
		}else{
			bean.setP_mongeytype(false);
		}
		
		//入库单生成
		new PurchaseDA().addPur(bean);
		
		
		//发送消息
		MessageBean mbean = new MessageBean();
		mbean.setM_content("采购入库单据编号为："+purchaseForm.getP_no()+"需要审核！");
		mbean.setM_reciever(Integer.parseInt(purchaseForm.getP_ver()));
		mbean.setM_sender(Integer.parseInt(purchaseForm.getP_l_id()));
		mbean.setM_time(p_time);
		mbean.setM_type(false);
		new MessageDA().addMessage(mbean);
		
		out.write("<script language=javascript>window.alert('入库提交成功！');window.location.href='purchasePages/purchase_warehousing.jsp';</script>");
		out.flush();
		out.close();
		return null;
	}
	/**
	 * 入库单红冲
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 * @throws IOException
	 */
	public ActionForward purchaseHongChong(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws IOException {
		//js乱码问题解决
		response.setContentType("text/html;UTF-8");
		response.setCharacterEncoding("UTF-8");
		
		PrintWriter out = response.getWriter();
		
		int p_id = Integer.parseInt(request.getParameter("p_id"));
		PurchaseBean bean = new PurchaseDA().showByP_id(p_id);
		new PurchaseDA().updatePurHongChong(p_id);
		new BankDA().updateBankMoney(bean.getP_b_id(), bean.getP_actual());
		//删除批次表中生成的库存信息
		String p_no = new PurchaseDA().getP_no(p_id);
		new RaidDA().delHongChongRaid(p_no);
		//生成应付金额
		double i_yingfu = bean.getP_amount() - bean.getP_actual();
		//往来单位应付发生变化
		new intercourseDA().updateYingFu(bean.getP_i_id(), 0 - i_yingfu);
		
		
		out.write("<script language='javascript'>window.alert('单据冲红成功！');window.location.href='purchasePages/purchase_record_frame.jsp';</script>");
		out.flush();
		out.close();
		return null;
	}
	/**
	 * 红冲入库单据删除
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 * @throws IOException
	 */
	public ActionForward delHongChong(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws IOException {
		//js乱码问题解决
		response.setContentType("text/html;UTF-8");
		response.setCharacterEncoding("UTF-8");
		
		PrintWriter out = response.getWriter();
		
		int p_id = Integer.parseInt(request.getParameter("p_id"));
		new PurchaseDA().delPurHongChong(p_id);
		
		out.write("<script language='javascript'>window.alert('冲红单据删除成功！');window.location.href='purchasePages/purchase_recordhongchong_frame.jsp';</script>");
		out.flush();
		out.close();
		return null;
	}
	/**
	 * 清空红冲入库单据
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 * @throws IOException
	 */
	public ActionForward delAll(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws IOException {
		//js乱码问题解决
		response.setContentType("text/html;UTF-8");
		response.setCharacterEncoding("UTF-8");
		
		PrintWriter out = response.getWriter();
		
		
		new PurchaseDA().delAllHongChong();
		
		out.write("<script language='javascript'>window.alert('冲红单据清空成功！');window.location.href='purchasePages/purchase_recordhongchong_frame.jsp';</script>");
		out.flush();
		out.close();
		return null;
	}
	/**
	 * 审核通过
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 * @throws IOException
	 */
	public ActionForward purchaseYes(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws IOException {
		//js乱码问题解决
		response.setContentType("text/html;UTF-8");
		response.setCharacterEncoding("UTF-8");
		
		PrintWriter out = response.getWriter();
		int p_id = Integer.parseInt(request.getParameter("p_id"));
		//String p_no = request.getParameter("p_no");
		
		//获得入库单据数据
		PurchaseBean bean = new PurchaseDA().showByP_id(p_id);
		//修改入库单据为通过状态
		new PurchaseDA().updatePurP_type(p_id);
		//批次入录
		RaidBean raidbean = new RaidBean();
		//到期日期
		int year = Integer.parseInt(bean.getP_prodate().substring(0, 4));
		int month = Integer.parseInt(bean.getP_prodate().substring(5, 7));
		int day = Integer.parseInt(bean.getP_prodate().substring(8, 10));
		java.sql.Date datetmp = new Date(year - 1900, month - 1, day + bean.getP_effdate());
		String r_due = String.valueOf(datetmp);
		raidbean.setR_no("R-" + bean.getP_no().substring(4));
		raidbean.setR_p_id(bean.getP_p_id());
		raidbean.setR_quantity(bean.getP_quantity());
		raidbean.setR_price(bean.getP_price());
		raidbean.setR_amount(bean.getP_amount());
		raidbean.setR_time(bean.getP_time());
		raidbean.setR_prodate(bean.getP_prodate());
		raidbean.setR_due(r_due);
		raidbean.setR_w_id(bean.getP_w_id());
		raidbean.setR_i_id(bean.getP_i_id());
		raidbean.setR_b_id(bean.getP_b_id());
		new RaidDA().addRaid(raidbean);
		
		//生成应付金额
		double i_yingfu = bean.getP_amount() - bean.getP_actual();
		//往来单位应付发生变化
		new intercourseDA().updateYingFu(bean.getP_i_id(), i_yingfu);
		
		//银行帐务发生变化，扣掉实际付款金额
		new BankDA().updateBankMoney(bean.getP_b_id(), 0 - bean.getP_actual());
		
		out.write("<script language='javascript'>window.alert('审核通过！');window.opener.location.reload();window.close();</script>");
		out.flush();
		out.close();
		return null;
	}
	/**
	 * 审核拒绝
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 * @throws IOException
	 */
	public ActionForward purchaseNo(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws IOException {
		//js乱码问题解决
		response.setContentType("text/html;UTF-8");
		response.setCharacterEncoding("UTF-8");
		
		PrintWriter out = response.getWriter();
		
		int p_id = Integer.parseInt(request.getParameter("p_id"));
		//String p_no = request.getParameter("p_no");
		
		//获得入库单据数据
		PurchaseBean bean = new PurchaseDA().showByP_id(p_id);
		//修改入库单据为拒绝状态
		new PurchaseDA().updatePurP_typeFalse(p_id);
		//消息修改
		/*HttpSession session = request.getSession();
		LoginForm f = (LoginForm)session.getAttribute("users");
		int m_reciever = new LoginDA().showL_id(f);
		new MessageDA().updateMessage(m_reciever);*/
		//单据删除
		new PurchaseDA().delPurFalse(p_id);
		//发送消息
		//获得系统时间
		Calendar cal=Calendar.getInstance();
        SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        String p_time=sdf.format(cal.getTime());
		MessageBean mbean = new MessageBean();
		mbean.setM_content("采购入库单据编号为："+bean.getP_no()+"拒绝通过！");
		mbean.setM_reciever(bean.getP_l_id());
		mbean.setM_sender(bean.getP_ver());
		mbean.setM_time(p_time);
		mbean.setM_type(false);
		new MessageDA().addMessage(mbean);
		
		out.write("<script language='javascript'>window.alert('入库单据拒绝！');window.opener.location.reload();window.opener=null;window.close();</script>");
		out.flush();
		out.close();
		return null;
	}
}