register_ok.java

ERO系统.针对生产型、分销型、服务型企业等不同的行业特点

/*
 *this file is part of nseer erp
 *Copyright (C)2006-2010 Nseer(Beijing) Technology co.LTD/http://www.nseer.com 
 *
 *This program is free software; you can redistribute it and/or
 *modify it under the terms of the GNU General Public License
 *as published by the Free Software Foundation; either
 *version 2 of the License, or (at your option) any later version.
 */
package crm.retail;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import javax.servlet.*;
import java.sql.* ;
import java.util.* ;
import java.io.*;
import include.nseer_db.*;
import java.text.*;
import include.nseer_cookie.*;
import include.get_rate_from_ID.getRateFromID;
import include.get_name_from_ID.getNameFromID;
import validata.ValidataNumber;
import stock.getLength;

public class register_ok extends HttpServlet{
ServletContext application;
HttpSession session;
nseer_db_backup1 erp_db = null;

public synchronized void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException{
HttpSession dbSession=request.getSession();
JspFactory _jspxFactory=JspFactory.getDefaultFactory();
PageContext pageContext = _jspxFactory.getPageContext(this,request,response,"",true,8192,true);
ServletContext dbApplication=dbSession.getServletContext();

try{
HttpSession session=request.getSession();
nseer_db_backup1 crm_db = new nseer_db_backup1(dbApplication);
nseer_db_backup1 stock_db = new nseer_db_backup1(dbApplication);
nseer_db_backup1 crm_db1 = new nseer_db_backup1(dbApplication);
counter count= new  counter(dbApplication);
getRateFromID   getRateFromID= new getRateFromID();
getNameFromID  getNameFromID= new  getNameFromID();
ValidataNumber  validata= new  ValidataNumber();
getLength  length= new getLength();

if(crm_db.conn((String)dbSession.getAttribute("unit_db_name"))&&stock_db.conn((String)dbSession.getAttribute("unit_db_name"))&&crm_db1.conn((String)dbSession.getAttribute("unit_db_name"))){

String funder=(String)session.getAttribute("realeditorc");
String funder_ID=(String)session.getAttribute("human_IDD");
String order_ID=request.getParameter("order_ID") ;

java.util.Date  now  =  new  java.util.Date();
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String time=formatter.format(now);
String[] serial_number=request.getParameterValues("serial_number") ;
String[] amount_number=request.getParameterValues("amount_number") ;
String sql1a="select * from crm_order_retail_temp where order_ID='"+order_ID+"'";//在临时表读记录
ResultSet rs1a=crm_db.executeQuery(sql1a);
String stock_ID="";
if(rs1a.next()){
stock_ID=rs1a.getString("stock_ID");
}
int p=0;
int j=1;
String sql2a="select * from crm_order_retail_details_temp where order_ID='"+order_ID+"'";//在临时表读记录
ResultSet rs2a=crm_db.executeQuery(sql2a);
while(rs2a.next()){
double serial_number_tag1=getRateFromID.getRateFromID((String)dbSession.getAttribute("unit_db_name"),"design_file","product_ID",rs2a.getString("product_ID"),"serial_number_tag");
String calculate_bonus_sn_tag=getNameFromID.getNameFromID((String)dbSession.getAttribute("unit_db_name"),"design_file","product_ID",rs2a.getString("product_ID"),"calculate_bonus_sn_tag");
	if(serial_number_tag1==1||serial_number_tag1==2){

StringTokenizer tokenTO1 = new StringTokenizer(serial_number[j-1],", ");   
	double cost_price_sum66=0.0d;
	while(tokenTO1.hasMoreTokens()) {
		String sql66="select * from  stock_balance_details_details where serial_number='"+tokenTO1.nextToken()+"' and stock_ID='"+stock_ID+"' and product_ID='"+rs2a.getString("product_ID")+"'";
		ResultSet rs66=stock_db.executeQuery(sql66);
		if(!rs66.next()){
			p++;
			}
		
		}
	}
j++;
}
if(p==0){
String time1="";
java.util.Date now1 = new java.util.Date();
SimpleDateFormat formatter1 = new SimpleDateFormat("yyyyMMdd");
time1=formatter1.format(now1);
String order_ID1=NseerId.getId(getClass().getResource("").toString(),(String)dbSession.getAttribute("unit_db_name"));
String sql1="select * from crm_order_retail_temp where order_ID='"+order_ID+"'";//在临时表读记录
		String sale_bonus_type="";
		String bonus_cost_for_profit_type="";
String sql_hr2="select * from hr_config_public_char where kind='零售绩效计算方式'"; 
   ResultSet rs_hr2=crm_db.executeQuery(sql_hr2);
if(rs_hr2.next()){ 
	sale_bonus_type=rs_hr2.getString("type_name");
	bonus_cost_for_profit_type=rs_hr2.getString("bonus_cost_for_profit_type");
}
ResultSet rs1=crm_db.executeQuery(sql1);
String customer_ID="";
String sales_ID="";
String stock_name="";
if(rs1.next()){
customer_ID=rs1.getString("customer_ID");
sales_ID=rs1.getString("sales_ID");
stock_name=rs1.getString("stock_name");
String type="零售非会员";
	if(!customer_ID.equals("01050000000000000000")){
		type="零售会员";
	}
	String sql3 = "insert into crm_order(order_ID,chain_ID,chain_name,hr_file_ID,hr_file_name,customer_ID,customer_name,register_time,accomplish_time,sales_name,sales_ID,register,type,remark,check_tag,excel_tag,order_type,bonus_calculate_type) values ('"+order_ID1+"','"+rs1.getString("chain_ID")+"','"+rs1.getString("chain_name")+"','"+rs1.getString("hr_chain_ID")+"','"+rs1.getString("hr_chain_name")+"','"+rs1.getString("customer_ID")+"','"+rs1.getString("customer_name")+"','"+rs1.getString("register_time")+"','"+rs1.getString("register_time")+"','"+rs1.getString("sales_name")+"','"+rs1.getString("sales_ID")+"','"+rs1.getString("register")+"','"+type+"','"+rs1.getString("remark")+"','0','2','零售','"+sale_bonus_type+"')" ;
	crm_db.executeUpdate(sql3) ;

}
String id="";
String sqlb="select id from crm_order where order_ID='"+order_ID1+"'";
rs1=crm_db.executeQuery(sqlb);
	if(rs1.next()){
		id=rs1.getString("id");
	}
String sql2="select * from crm_order_retail_details_temp where order_ID='"+order_ID+"'";//在临时表读记录
ResultSet rs2=crm_db.executeQuery(sql2);
int i=1;
double sale_price_sum=0.0d;
double cost_price_sum=0.0d;
double real_cost_price_sum=0.0d;
int pay_amount_sum=0;
double retail_sale_bonus_sum=0.00d;
double retail_profit_bonus_sum=0.00d;
while(rs2.next()){
	
	double subtotal=rs2.getDouble("list_price")*(1-rs2.getDouble("off_discount")/100)*rs2.getDouble("amount");
	double cost_price_after_discount_sum=rs2.getDouble("cost_price")*rs2.getDouble("amount");
	double real_cost_price_after_discount_sum=rs2.getDouble("real_cost_price")*rs2.getDouble("amount");
	sale_price_sum+=subtotal;
	cost_price_sum+=cost_price_after_discount_sum;
	real_cost_price_sum+=real_cost_price_after_discount_sum;
	pay_amount_sum+=rs2.getDouble("amount");
	double retail_sale_bonus_subtotal=getRateFromID.getRateFromID((String)dbSession.getAttribute("unit_db_name"),"design_file","product_ID",rs2.getString("product_ID"),"retail_sale_bonus_rate")*subtotal/100;
double retail_profit_bonus_subtotal=0.0d;
double serial_number_tag1=getRateFromID.getRateFromID((String)dbSession.getAttribute("unit_db_name"),"design_file","product_ID",rs2.getString("product_ID"),"serial_number_tag");

String calculate_bonus_sn_tag=getNameFromID.getNameFromID((String)dbSession.getAttribute("unit_db_name"),"design_file","product_ID",rs2.getString("product_ID"),"calculate_bonus_sn_tag");
	if(serial_number_tag1==1&&calculate_bonus_sn_tag.equals("是")){

StringTokenizer tokenTO1 = new StringTokenizer(serial_number[i-1],", ");   
	double cost_price_sum66=0.0d;
	while(tokenTO1.hasMoreTokens()) {
		String sql66="select * from  stock_balance_details_details where serial_number='"+tokenTO1.nextToken()+"' and stock_ID='"+stock_ID+"' and product_ID='"+rs2.getString("product_ID")+"'";
		ResultSet rs66=stock_db.executeQuery(sql66);
		if(rs66.next()){
			cost_price_sum66+=rs66.getDouble("cost_price");
			}
		
		}
retail_profit_bonus_subtotal=getRateFromID.getRateFromID((String)dbSession.getAttribute("unit_db_name"),"design_file","product_ID",rs2.getString("product_ID"),"retail_profit_bonus_rate")*(subtotal-cost_price_sum66)/100;

}else{
	if(bonus_cost_for_profit_type.equals("按计划成本单价")){