register1_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 portal.design;
import include.alarm.CheckRows;
import include.get_name_from_ID.getNameFromID;
import include.nseer_cookie.Divide1;
import include.nseer_cookie.Email;
import include.nseer_cookie.GetWorkflow;
import include.nseer_cookie.NseerId;
import include.nseer_cookie.counter;
import include.nseer_cookie.exchange;
import include.nseer_db.nseer_db_backup1;
import include.operateDB.CdefineUpdate;
import include.tree_index.businessComment;

import java.io.IOException;
import java.sql.ResultSet;
import java.util.Iterator;
import java.util.List;
import java.util.StringTokenizer;

import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import javax.servlet.jsp.JspFactory;
import javax.servlet.jsp.PageContext;

public class register1_ok extends HttpServlet{
ServletContext application;
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();
		counter count=new counter(dbApplication);
		businessComment demo=new businessComment();
		               demo.setPath(request);
		Email mail=new Email();
getNameFromID getNameFromID = new getNameFromID();
nseer_db_backup1 crm_db = new nseer_db_backup1(dbApplication);
nseer_db_backup1 hr_db = new nseer_db_backup1(dbApplication);
if(crm_db.conn((String)dbSession.getAttribute("unit_db_name"))&&hr_db.conn((String)dbSession.getAttribute("unit_db_name"))){
String sales_name="";
String sales_ID=request.getParameter("sales_ID");
String fileKind_chain=request.getParameter("fileKind_chain");
String chain_id=Divide1.getId(fileKind_chain);
String chain_name=Divide1.getName(fileKind_chain);
String sql2="select id from crm_config_file_kind where chain_ID='"+chain_id+"'";
ResultSet rs2=crm_db.executeQuery(sql2) ;
if(!sales_ID.equals("")){
	sql2="select id from hr_file where human_ID='"+sales_ID+"' and human_major_first_kind_name='销售'";
	rs2=crm_db.executeQuery(sql2) ;
}
if(!sales_ID.equals("")){
	sales_name=getNameFromID.getNameFromID((String)dbSession.getAttribute("unit_db_name"),"hr_file","human_ID",sales_ID,"human_name");
}
String customer_ID=NseerId.getId("crm/file",(String)dbSession.getAttribute("unit_db_name"));
String customer_name=request.getParameter("customer_name") ;
String customer_address=request.getParameter("customer_address") ;
String type=request.getParameter("type") ;
String customer_class=request.getParameter("class1") ;
String gather_sum_limit2=request.getParameter("gather_sum_limit") ;
StringTokenizer tokenTO4 = new StringTokenizer(gather_sum_limit2,",");        
String gather_sum_limit="";
            while(tokenTO4.hasMoreTokens()) {
                String gather_sum_limit1 = tokenTO4.nextToken();
		gather_sum_limit +=gather_sum_limit1;
		}
String gather_period_limit=request.getParameter("gather_period_limit") ;
String contact_period_limit=request.getParameter("contact_period_limit") ;
String used_customer_name=request.getParameter("used_customer_name") ;
String customer_bank=request.getParameter("customer_bank") ;
String customer_account=request.getParameter("customer_account") ;
String customer_web=request.getParameter("customer_web") ;
String customer_tel1=request.getParameter("customer_tel1") ;
String customer_tel2=request.getParameter("customer_tel2") ;
String customer_fax=request.getParameter("customer_fax") ;
String customer_postcode=request.getParameter("customer_postcode") ;
String contact_person1=request.getParameter("contact_person1") ;
String contact_person1_department=request.getParameter("contact_person1_department") ;
String contact_person1_duty=request.getParameter("contact_person1_duty") ;
String contact_person1_sex = request.getParameter("contact_person1_sex") ;
String contact_person1_office_tel=request.getParameter("contact_person1_office_tel") ;
String contact_person1_home_tel=request.getParameter("contact_person1_home_tel") ;
String contact_person1_mobile=request.getParameter("contact_person1_mobile") ;
String contact_person1_email=request.getParameter("contact_person1_email") ;
String contact_person2=request.getParameter("contact_person2") ;
String contact_person2_department=request.getParameter("contact_person2_department") ;
String contact_person2_duty=request.getParameter("contact_person2_duty") ;
String contact_person2_sex = request.getParameter("contact_person2_sex") ;
String contact_person2_office_tel=request.getParameter("contact_person2_office_tel") ;
String contact_person2_home_tel=request.getParameter("contact_person2_home_tel") ;
String contact_person2_mobile=request.getParameter("contact_person2_mobile") ;
String contact_person2_email=request.getParameter("contact_person2_email") ;
String register=request.getParameter("register") ;
String register_time=request.getParameter("register_time") ;
String bodyc = new String(request.getParameter("invoice_info").getBytes("UTF-8"),"UTF-8");
String invoice_info=exchange.toHtml(bodyc);
String bodya = new String(request.getParameter("demand").getBytes("UTF-8"),"UTF-8");
String demand=exchange.toHtml(bodya);
String bodyb = new String(request.getParameter("remark").getBytes("UTF-8"),"UTF-8");
String remark=exchange.toHtml(bodyb);
try{
  String sqll="select id from crm_file where customer_ID='"+customer_ID+"' and customer_name='"+customer_name+"'";
	ResultSet rset=crm_db.executeQuery(sqll) ;
if(rset.next()){
				response.sendRedirect("portal/design/register1_ok_a.jsp");//用户时候登陆过
   }else{

	String sql = "insert into crm_file(customer_ID,customer_name,customer_address,customer_class,type,customer_bank,customer_account,customer_web,customer_tel1,customer_tel2,customer_fax,customer_postcode,used_customer_name,gather_sum_limit,gather_period_limit,contact_period_limit,contact_person1,contact_person1_department,contact_person1_duty,contact_person1_sex,contact_person1_office_tel,contact_person1_home_tel,contact_person1_mobile,contact_person1_email,contact_person2,contact_person2_department,contact_person2_duty,contact_person2_sex,contact_person2_office_tel,contact_person2_home_tel,contact_person2_mobile,contact_person2_email,register,register_time,invoice_info,demand,remark,check_tag,modify_tag,excel_tag,sales_name,sales_ID,chain_id,chain_name) values ('"+customer_ID+"','"+customer_name+"','"+customer_address+"','"+customer_class+"','"+type+"','"+customer_bank+"','"+customer_account+"','"+customer_web+"','"+customer_tel1+"','"+customer_tel2+"','"+customer_fax+"','"+customer_postcode+"','"+used_customer_name+"','"+gather_sum_limit+"','"+gather_period_limit+"','"+contact_period_limit+"','"+contact_person1+"','"+contact_person1_department+"','"+contact_person1_duty+"','"+contact_person1_sex+"','"+contact_person1_office_tel+"','"+contact_person1_home_tel+"','"+contact_person1_mobile+"','"+contact_person1_email+"','"+contact_person2+"','"+contact_person2_department+"','"+contact_person2_duty+"','"+contact_person2_sex+"','"+contact_person2_office_tel+"','"+contact_person2_home_tel+"','"+contact_person2_mobile+"','"+contact_person2_email+"','"+register+"','"+register_time+"','"+invoice_info+"','"+demand+"','"+remark+"','0','0','1','"+sales_name+"','"+sales_ID+"','"+chain_id+"','"+chain_name+"')" ;
	crm_db.executeUpdate(sql) ;
	String[] email_box={contact_person1_email};

	mail.send(email_box,"smtp.sina.com.cn","[e-mail]","123456",demo.getLang("erp","注册信息"),"欢迎您注册成为我们的客户，您的档案编号是:"+customer_ID);
	
	CdefineUpdate CdefineUpdate=new CdefineUpdate();
	sql=CdefineUpdate.update("crm_file","customer_ID",customer_ID,request);
	crm_db.executeUpdate(sql) ;
	/*****************************************************/
	
    sql="update crm_config_file_kind set delete_tag='1' where file_id='"+chain_id+"'";
	crm_db.executeUpdate(sql);//delete_tag为1说明分类被使用	


List rsList = GetWorkflow.getList(crm_db, "crm_config_workflow", "01");
	if(rsList.size()==0){
		sql="update crm_file set check_tag='1' where customer_ID='"+customer_ID+"'";
		crm_db.executeUpdate(sql) ;
		if(!sales_ID.equals("")){
	sales_name=getNameFromID.getNameFromID((String)dbSession.getAttribute("unit_db_name"),"hr_file","human_ID",sales_ID,"human_name");
	String sql1="select personal_work_amount from hr_file where human_ID='"+sales_ID+"'";
	ResultSet rs1=hr_db.executeQuery(sql1) ;
	if(rs1.next()){
		int personal_work_amount=rs1.getInt("personal_work_amount")+1;
		String sql3="update hr_file set personal_work_amount='"+personal_work_amount+"' where human_ID='"+sales_ID+"'";
		hr_db.executeUpdate(sql3) ;
	}

}
if(type.equals("合作伙伴")){
	List rsList1 = GetWorkflow.getList(crm_db, "ecommerce_config_workflow", "02");
	sql="delete from ecommerce_workflow where object_ID='"+customer_ID+"'";
	crm_db.executeUpdate(sql);
	if(rsList1.size()==0){
		String sql1="update crm_file set excel_tag='3' where customer_ID='"+customer_ID+"'";
		crm_db.executeUpdate(sql1) ;
	}else{
		Iterator ite1=rsList1.iterator();
		while(ite1.hasNext()){
			String[] elem1=(String[])ite1.next();
			sql = "insert into ecommerce_workflow(config_id,object_ID,describe1,describe2) values ('"+elem1[0]+"','"+customer_ID+"','"+elem1[1]+"','"+elem1[2]+"')" ;
			crm_db.executeUpdate(sql) ;
		}
	}
}
	}else{
		Iterator ite=rsList.iterator();
		while(ite.hasNext()){
		String[] elem=(String[])ite.next();
		sql = "insert into crm_workflow(config_id,object_ID,describe1,describe2) values ('"+elem[0]+"','"+customer_ID+"','"+elem[1]+"','"+elem[2]+"')" ;
		crm_db.executeUpdate(sql) ;
		}
	}
CheckRows add=new CheckRows();
add.addRowCount((String)dbSession.getAttribute("unit_db_name"),"crm_file");
response.sendRedirect("portal/design/register1_choose_attachment.jsp?customer_ID="+customer_ID+"");

}
	
}
catch (Exception ex){
ex.printStackTrace();
}

crm_db.commit();
hr_db.commit();
crm_db.close();
	hr_db.close();
}else{
	response.sendRedirect("error_conn.htm");
}
}catch(Exception ex){
	ex.printStackTrace();
}
}
}