check_ok.java

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

			String sql444="select * from stock_balance_details_details where serial_number='"+serial_number+"' and stock_name='"+reason+"' and product_ID='"+product_ID[i]+"'";
			ResultSet rs444=stock_db.executeQuery(sql444);

			if(rs444.next()){
				String sql555="delete from stock_balance_details_details where serial_number='"+serial_number+"' and stock_name='"+reason+"' and product_ID='"+product_ID[i]+"'";
		stock_db.executeUpdate(sql555);
			}else{

			String sql100="insert into stock_balance_details_details(product_ID,product_name,cost_price,subtotal,stock_ID,stock_name,serial_number,register_time) values('"+product_ID[i]+"','"+product_name[i]+"','"+cost_price[i]+"','"+subtotal+"','','"+reason+"','"+serial_number+"','"+time+"')";
			stock_db.executeUpdate(sql100);
			}

		}
		
		}
	}
	}else{
		if(!serial_number_group[i].equals("")){
	StringTokenizer tokenTO2 = new StringTokenizer(serial_number_group[i],", ");
	StringTokenizer tokenTO3 = new StringTokenizer(amount_number_group[i],", ");
	while(tokenTO2.hasMoreTokens()&&tokenTO3.hasMoreTokens()) {
		String serial_number=tokenTO2.nextToken();
		String amount_number=tokenTO3.nextToken();
		String sqla10="select * from stock_balance_details_details where serial_number='"+serial_number+"' and stock_ID='"+stock_ID[i]+"' and product_ID='"+product_ID[i]+"'";
		ResultSet rsa10=stock_db.executeQuery(sqla10);
		double cost_price_details=0.0d;
		double subtotal_details=0.0d;
		if(rsa10.next()){
			cost_price_details=rsa10.getDouble("cost_price");
			subtotal_details=rsa10.getDouble("cost_price")*Double.parseDouble(amount_number);
			double balance_amount=rsa10.getDouble("amount")-Double.parseDouble(amount_number);
		String sql10="update stock_balance_details_details set amount='"+balance_amount+"' where serial_number='"+serial_number+"' and stock_ID='"+stock_ID[i]+"' and product_ID='"+product_ID[i]+"'";
		stock_db.executeUpdate(sql10);
		}
		if(!reason.equals("生产入库")&&!reason.equals("委外入库")&&!reason.equals("采购入库")&&!reason.equals("生产领料")&&!reason.equals("销售出库")){
			String sql444="select * from stock_balance_details_details where serial_number='"+serial_number+"' and stock_name='"+reason+"' and product_ID='"+product_ID[i]+"'";
			ResultSet rs444=stock_db.executeQuery(sql444);

			if(rs444.next()){
				double balance_amount1=rs444.getDouble("amount")-Double.parseDouble(amount_number);
				String sql555="update stock_balance_details_details set amount='"+balance_amount1+"' where serial_number='"+serial_number+"' and stock_name='"+reason+"' and product_ID='"+product_ID[i]+"'";
		stock_db.executeUpdate(sql555);
			}else{

			String sql100="insert into stock_balance_details_details(product_ID,product_name,cost_price,subtotal,stock_ID,stock_name,serial_number,register_time,amount) values('"+product_ID[i]+"','"+product_name[i]+"','"+cost_price_details+"','"+subtotal_details+"','','"+reason+"','"+serial_number+"','"+time+"','"+amount_number+"')";
			stock_db.executeUpdate(sql100);
			}

		}
		
	



		
		}
	}
	}
	String sql2="select * from stock_balance_details where product_ID='"+product_ID[i]+"' and stock_ID='"+stock_ID[i]+"'"; 
	ResultSet rs2=stock_db.executeQuery(sql2);
	if(rs2.next()){
		double cost_price2=rs2.getDouble("cost_price");
		double amount2=rs2.getDouble("amount")-Double.parseDouble(amount[i]);
		double subtotal2=rs2.getDouble("subtotal")-Double.parseDouble(cost_price[i])*Double.parseDouble(amount[i]);
		if(amount2!=0){
		cost_price2=subtotal2/amount2;
		}
		String sql3="update stock_balance_details set amount='"+amount2+"',subtotal='"+subtotal2+"',cost_price='"+cost_price2+"' where id='"+rs2.getString("id")+"'";
		//out.println(sql3);
		stock_db.executeUpdate(sql3);
	}else{
		double amount2=0-Double.parseDouble(amount[i]);
		String sql10="insert into stock_balance_details(chain_id,chain_name,product_ID,product_name,amount,cost_price,subtotal,stock_ID,stock_name,nick_name) values('"+chain_id+"','"+chain_name+"','"+product_ID[i]+"','"+product_name[i]+"','"+amount2+"','"+cost_price[i]+"','"+subtotal+"','"+stock_ID[i]+"','"+stock_name[i]+"','"+nick_name[i]+"')";
		stock_db.executeUpdate(sql10);
	}
	if(!reason.equals("生产入库")&&!reason.equals("委外入库")&&!reason.equals("采购入库")&&!reason.equals("生产领料")&&!reason.equals("销售出库")){
		String sql222="select * from stock_balance_details where product_ID='"+product_ID[i]+"' and stock_name='"+reason+"' "; 
	ResultSet rs222=stock_db.executeQuery(sql222);
	if(rs222.next()){
		double cost_price222=rs222.getDouble("cost_price");
		double amount222=rs222.getDouble("amount")+Double.parseDouble(amount[i]);
		double subtotal222=rs222.getDouble("subtotal")+Double.parseDouble(cost_price[i])*Double.parseDouble(amount[i]);
		if(amount222!=0){
		cost_price222=subtotal222/amount222;
		}
		String sql333="update stock_balance_details set amount='"+amount222+"',subtotal='"+subtotal222+"',cost_price='"+cost_price222+"' where id='"+rs222.getString("id")+"'";
		//out.println(sql3);
		stock_db.executeUpdate(sql333);
	}else{
		String[] aaa=FileKind.getKind((String)dbSession.getAttribute("unit_db_name"),"design_file","product_ID",product_ID[i]);

		String sql10="insert into stock_balance_details(chain_id,chain_name,product_ID,product_name,amount,cost_price,subtotal,stock_ID,stock_name) values('"+aaa[0]+"','"+aaa[1]+"','"+product_ID[i]+"','"+product_name[i]+"','"+amount[i]+"','"+cost_price[i]+"','"+subtotal+"','','"+reason+"')";
		stock_db.executeUpdate(sql10);
	}

	}
	double amount333=0.0d;
	double cost_price_sum333=0.0d;

	String sql333="select * from stock_balance_details where product_ID='"+product_ID[i]+"'";
	ResultSet rs333=stock_db.executeQuery(sql333);
	while(rs333.next()){amount333+=rs333.getDouble("amount");
	                     cost_price_sum333+=rs333.getDouble("subtotal");
	}
	double cost_price333=0.0d;

		
		if(amount333!=0){
		cost_price333=cost_price_sum333/amount333;
		}
String sql5="select * from stock_balance where product_ID='"+product_ID[i]+"'"; 
	ResultSet rs5=stock_db.executeQuery(sql5);
	if(rs5.next()){
		
		String sql6a="update stock_balance set amount='"+amount333+"',cost_price_sum='"+cost_price_sum333+"',cost_price='"+cost_price333+"',address_group='"+address_group+"' where id='"+rs5.getString("id")+"'";
		stock_db.executeUpdate(sql6a);
	}else{
		String sql7="insert into stock_balance(chain_id,chain_name,product_ID,product_name,amount,cost_price,cost_price_sum,address_group) values('"+chain_id+"','"+chain_name+"','"+product_ID[i]+"','"+product_name[i]+"','"+amount333+"','"+cost_price333+"','"+cost_price_sum333+"','"+address_group+"')";
		stock_db.executeUpdate(sql7);
	}
String sql11="select * from stock_pre_paying where pay_ID='"+pay_ID+"' and product_ID='"+product_ID[i]+"' and stock_ID='"+stock_ID[i]+"'";
	ResultSet rs11=stock_db.executeQuery(sql11);
	if(rs11.next()){
		double amount1=Double.parseDouble(amount[i])+rs11.getDouble("paid_amount");
		double subtotal5=rs11.getDouble("paid_subtotal")+Double.parseDouble(cost_price[i])*Double.parseDouble(amount[i]);
		if(rs11.getDouble("amount")==amount1){
			String sql="update stock_pre_paying set paid_amount='"+amount1+"',unpay_amount='0',paid_subtotal='"+subtotal5+"',pay_tag='1',pay_check_tag='0' where pay_ID='"+pay_ID+"' and product_ID='"+product_ID[i]+"' and stock_ID='"+stock_ID[i]+"'";
			stock_db.executeUpdate(sql);
		}else{
			double amount5=rs11.getDouble("amount")-amount1;
			String sql12="update stock_pre_paying set paid_amount='"+amount1+"',unpay_amount='"+amount5+"',paid_subtotal='"+subtotal5+"',pay_check_tag='0' where pay_ID='"+pay_ID+"' and product_ID='"+product_ID[i]+"' and stock_ID='"+stock_ID[i]+"'";
			
			stock_db.executeUpdate(sql12);
		}
	}
	double amount6=0.0;
String sql20="select * from stock_pay_details where pay_ID='"+pay_ID+"' and product_ID='"+product_ID[i]+"'"; 
	ResultSet rs20=stock_db.executeQuery(sql20);
	if(rs20.next()){
		amount6=rs20.getDouble("paid_amount")+Double.parseDouble(amount[i]);
		double subtotal6=rs20.getDouble("paid_subtotal")+Double.parseDouble(cost_price[i])*Double.parseDouble(amount[i]);
		String sql21="update stock_pay_details set paid_amount='"+amount6+"',paid_subtotal='"+subtotal6+"' where pay_ID='"+pay_ID+"' and product_ID='"+product_ID[i]+"'";
		stock_db.executeUpdate(sql21);
	}
	if(reason.equals("销售出库")){
		String sql19="update crm_order_details set paid_amount='"+amount6+"' where order_ID='"+reasonexact+"' and product_ID='"+product_ID[i]+"'";
		stock_db.executeUpdate(sql19);
		String sql23="select * from crm_order where order_ID='"+reasonexact+"'";
		ResultSet rs23=stock_db.executeQuery(sql23);
		if(rs23.next()){
		double paid_amount_sum=rs23.getDouble("paid_amount_sum")+Double.parseDouble(amount[i]);
		String sql24="update crm_order set paid_amount_sum='"+paid_amount_sum+"' where order_ID='"+reasonexact+"'";
		stock_db.executeUpdate(sql24);
		}
		}
	}
	}
if(flag){
String cost_calculate_type="";
	String sqlc1="select * from design_file where product_ID='"+product_ID[i]+"'";
	ResultSet rsc1=stock_db.executeQuery(sqlc1);
	if(rsc1.next()){
		cost_calculate_type=rsc1.getString("cost_calculate_type");
	}	
}
	}
//**************************
if(flag){
String sql18="select * from stock_pay where pay_ID='"+pay_ID+"'"; 
	ResultSet rs18=stock_db.executeQuery(sql18);
	if(rs18.next()){
		double amount5=rs18.getDouble("paid_amount")+amount4;
		double subtotal5=rs18.getDouble("paid_cost_price_sum")+cost_price_sum;
		double cost_price5=subtotal5/amount5;
		String sql19="update stock_pay set paid_amount='"+amount5+"',paid_cost_price_sum='"+subtotal5+"',cost_price='"+cost_price5+"',checker='"+checker+"',check_time='"+check_time+"' where pay_ID='"+pay_ID+"'";
		stock_db.executeUpdate(sql19);
	}
	String sql16="select * from stock_pre_paying where pay_ID='"+pay_ID+"' and pay_tag!='1'";
	ResultSet rs16=stock_db.executeQuery(sql16);
	if(!rs16.next()){
		String sql17="update stock_pay set finish_time='"+time+"',pay_tag='2' where pay_ID='"+pay_ID+"'";
		stock_db.executeUpdate(sql17);
		if(reason.equals("销售出库")){
		String sql19="update crm_order set pay_tag='3' where order_ID='"+reasonexact+"'";
		stock_db.executeUpdate(sql19);
		String sql23="select * from crm_order where gather_tag='3' and logistics_tag='3' and receive_tag='3' and invoice_tag='3' and pay_tag='3' and check_tag='1' and order_ID='"+reasonexact+"'";
		ResultSet rs23=stock_db.executeQuery(sql23);
		if(rs23.next()){
		String sql24="update crm_order set order_tag='2',order_status='完成',accomplish_time='"+check_time+"' where order_ID='"+reasonexact+"'";
		stock_db.executeUpdate(sql24);
		}
		}
		if(reason.equals("内部调出")){
		String sql19="update stock_transfer_pay set transfer_pay_tag='1',pay_tag='2' where pay_ID='"+reasonexact+"'";
		stock_db.executeUpdate(sql19);
			}
		if(reason.equals("销售赊货")){
		String sql19a="update stock_apply_pay set pay_tag='2' where pay_ID='"+reasonexact+"'";
		stock_db.executeUpdate(sql19a);
			}
response.sendRedirect("stock/pay/check_ok.jsp?finished_tag=0");
}else{
response.sendRedirect("stock/pay/check_ok.jsp?finished_tag=1");
}
}else{
response.sendRedirect("stock/pay/check_ok.jsp?finished_tag=6");
}

}else{
response.sendRedirect("stock/pay/check_ok.jsp?finished_tag=2");
}
}else{
response.sendRedirect("stock/pay/check_ok.jsp?finished_tag=3");
}
}else{
response.sendRedirect("stock/pay/check_ok.jsp?finished_tag=4");
}
}else{
response.sendRedirect("stock/pay/check_ok.jsp?finished_tag=5");
}
stock_db.commit();
stock_db.close();
}else{
	response.sendRedirect("error_conn.htm");
}
}
catch (Exception ex){
ex.printStackTrace();
}
}
}