check_ok.java

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

	cash_itema[i]=tk17.nextToken();

	tax_rate[i]=tk18.nextToken();
	tax_rate[i]=tax_rate[i].equals("⊙")?"0.00":tax_rate[i];

	cash_direct[i]=tk23.nextToken();
	cash_direct[i]=cash_direct[i].equals("⊙")?"":cash_direct[i];

	stock_direct[i]=tk24.nextToken();
	stock_direct[i]=stock_direct[i].equals("⊙")?"":stock_direct[i];

	cash_sum[i]=tk25.nextToken();
	cash_sum[i]=cash_sum[i].equals("⊙")?"":cash_sum[i];
	
}
String debit_mate_id="";
String loan_mate_id="";
String account_period="";

sql="select account_period from finance_account_period where start_time<='"+register_time+"' and end_time>='"+register_time+"'";
ResultSet rs=finance_db.executeQuery(sql);
if(rs.next()){
  account_period=rs.getString("account_period");
}
String[] account_period1=accountPeriod.getAccountPeriod((String)session.getAttribute("unit_db_name"));

if(account_period1[0].equals(account_period)){
	if(rowCount!=0){
	if(!debit_sum.equals("")&&Double.parseDouble(debit_sum)==Double.parseDouble(loan_sum)){
		for(int i=0;i<rowCount;i++){
			if(!debit[i].equals("")&&!validata.validata(debit[i])||!loan[i].equals("")&&!validata.validata(loan[i])){
				err_count=16;
				break;
			}
			cash_temp=i+"◇⊙";
			if(cash_tag[i].equals("1")&&cash_item[i].equals(cash_temp)&&cash_itema[i].equals(cash_temp)){
				err_count=3;
				break;
				}
			if(summary[i].equals("")){
				err_count=4;
				break;
			}
			if(file_name[i].equals("")||file_name[i].indexOf(" ")==-1){
				err_count=8;
				break;
			}

		sql="select category_name from finance_config_file_kind where file_id='"+file_name[i].substring(0,file_name[i].indexOf(" "))+"' and details_tag=0";
			rs=finance_db.executeQuery(sql);
			if(!rs.next()){
				err_count=8;
				break;
			}	

if(cash_tag[i].equals("1")&&(cash_direct[i].equals("0")&&(!cash_sum[i].equals(debit[i])||debit[i].equals(""))||(cash_direct[i].equals("1")&&(!cash_sum[i].equals(loan[i])||loan[i].equals(""))))){
				err_count=3;
				break;
				}

			sum_temp=sum[i].substring(0,sum[i].indexOf("."))+sum[i].substring(sum[i].indexOf(".")+1);

if(corr_stock_tag[i].equals("是")&&(qty[i].equals("")||stock_direct[i].equals("0")&&(!sum_temp.equals(debit[i])||debit[i].equals(""))||stock_direct[i].equals("1")&&(!sum_temp.equals(loan[i])||loan[i].equals("")))){
				err_count=9;
				break;
				}
			if(bank_tag[i].equals("1")&&settle_way[i].equals("")){
				err_count=10;
				break;
			}
			if(bank_tag[i].equals("1")&&attachment_id[i].equals("")){
				err_count=11;
				break;
			}
			if(bank_tag[i].equals("1")&&settle_time[i].equals("1800-01-01")){
				err_count=12;
				break;
			}
			if(formatter.parse(settle_time[i]).getTime()>formatter.parse(register_time).getTime()){
				err_count=13;
				break;
			}
			
		}
		if(err_count==0){
for(int i=0;i<rowCount;i++){
	StringTokenizer tk=new StringTokenizer(file_name[i]," ");
	while(tk.hasMoreTokens()){
		file_id=tk.nextToken();
		file_name1=tk.nextToken();
	}
	if(debit[i].equals("")){
		if(debit_mate_id.indexOf(file_id)==-1){
		debit_mate_id+=file_id+",";
		}
	}else{
		if(loan_mate_id.indexOf(file_id)==-1){
		loan_mate_id+=file_id+",";
		}
	}
}
debit_sum=debit_sum.substring(0,debit_sum.length()-2)+"."+debit_sum.substring(debit_sum.length()-2);
loan_sum=loan_sum.substring(0,loan_sum.length()-2)+"."+loan_sum.substring(loan_sum.length()-2);

debit_mate_id=debit_mate_id.substring(0,debit_mate_id.length()-1);
loan_mate_id=loan_mate_id.substring(0,loan_mate_id.length()-1);

sql="delete from finance_voucher where voucher_in_month_id='"+voucher_id+"' and register_time='"+register_time+"'";
finance_db.executeUpdate(sql);
sql="delete from finance_cash_table where voucher_in_month_id='"+voucher_id+"' and register_time='"+register_time+"'";
finance_db.executeUpdate(sql);

for(int i=0;i<rowCount;i++){
	StringTokenizer tk=new StringTokenizer(file_name[i]," ");
	while(tk.hasMoreTokens()){
		file_id=tk.nextToken();
		file_name1=tk.nextToken();
	}
	String[] name=getMultiNameFromID.getNameFromID((String)dbSession.getAttribute("unit_db_name"),file_id);
	if(debit[i].equals("")){
		debit[i]="0";
	}else{
		debit[i]=debit[i].substring(0,debit[i].length()-2)+"."+debit[i].substring(debit[i].length()-2);
	}
	if(loan[i].equals("")){
		loan[i]="0";
	}else{
		loan[i]=loan[i].substring(0,loan[i].length()-2)+"."+loan[i].substring(loan[i].length()-2);
	}
	if(loan_mate_id.equals("3131")||debit_mate_id.equals("3131")){
        name[2]="";
		name[3]="";
		name[4]="";
		name[5]="";	
	}
	if(debit[i].equals("0")){
	sql="insert into finance_voucher(voucher_in_month_id,details_number,chain_id,chain_name,voucher_type,debit_sum,loan_sum,attachment_amount,attachment_id,summary,debit_subtotal,loan_subtotal,product_amount,product_price,settle_way,remark,currency,currency_rate,department,project,customer,product,order_id,accountant,accountant_id,accounter,accounter_id,cashier,cashier_id,checker,checker_id,register,register_id,register_time,check_time,chain_mate_id,tax_rate,account_period,check_tag,profit_or_cost,itema_name,itemb_name,itemd_name,debit_or_loan,bank_tag,cash_tag,corr_stock_tag,settle_time,cash_direct,stock_direct,cash_sum,debit_subtotal_c,loan_subtotal_c) values('"+voucher_id+"','"+i+"','"+file_id+"','"+file_name1+"','"+voucher_type+"','"+debit_sum+"','"+loan_sum+"','"+attachment_amount+"','"+attachment_id[i]+"','"+summary[i]+"','"+debit[i]+"','"+loan[i]+"','"+qty[i]+"','"+netPrice[i]+"','"+settle_way[i]+"','"+remark[i]+"','"+currency[i]+"','"+currency_rate[i]+"','"+department[i]+"','"+project[i]+"','"+customer[i]+"','"+product[i]+"','"+order[i]+"','"+accountant+"','"+accountant_id+"','"+accounter+"','"+accounter_id+"','"+cashier+"','"+cashier_id+"','"+checker+"','"+checker_id+"','"+register+"','"+register_id+"','"+register_time+"','"+check_time+"','"+loan_mate_id+"','"+tax_rate[i]+"','"+account_period+"','1','"+name[5]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','"+name[1]+"','"+bank_tag[i]+"','"+cash_tag[i]+"','"+corr_stock_tag[i]+"','"+settle_time[i]+"','"+cash_direct[i]+"','"+stock_direct[i]+"','"+cash_sum[i]+"','0.00','"+cPrice[i]+"')";
	}else{
	sql="insert into finance_voucher(voucher_in_month_id,details_number,chain_id,chain_name,voucher_type,debit_sum,loan_sum,attachment_amount,attachment_id,summary,debit_subtotal,loan_subtotal,product_amount,product_price,settle_way,remark,currency,currency_rate,department,project,customer,product,order_id,accountant,accountant_id,accounter,accounter_id,cashier,cashier_id,checker,checker_id,register,register_id,register_time,check_time,chain_mate_id,tax_rate,account_period,check_tag,profit_or_cost,itema_name,itemb_name,itemd_name,debit_or_loan,bank_tag,cash_tag,corr_stock_tag,settle_time,cash_direct,stock_direct,cash_sum,debit_subtotal_c,loan_subtotal_c) values('"+voucher_id+"','"+i+"','"+file_id+"','"+file_name1+"','"+voucher_type+"','"+debit_sum+"','"+loan_sum+"','"+attachment_amount+"','"+attachment_id[i]+"','"+summary[i]+"','"+debit[i]+"','"+loan[i]+"','"+qty[i]+"','"+netPrice[i]+"','"+settle_way[i]+"','"+remark[i]+"','"+currency[i]+"','"+currency_rate[i]+"','"+department[i]+"','"+project[i]+"','"+customer[i]+"','"+product[i]+"','"+order[i]+"','"+accountant+"','"+accountant_id+"','"+accounter+"','"+accounter_id+"','"+cashier+"','"+cashier_id+"','"+checker+"','"+checker_id+"','"+register+"','"+register_id+"','"+register_time+"','"+check_time+"','"+debit_mate_id+"','"+tax_rate[i]+"','"+account_period+"','1','"+name[5]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','"+name[1]+"','"+bank_tag[i]+"','"+cash_tag[i]+"','"+corr_stock_tag[i]+"','"+settle_time[i]+"','"+cash_direct[i]+"','"+stock_direct[i]+"','"+cash_sum[i]+"','"+cPrice[i]+"','0.00')";
	}
	finance_db.executeUpdate(sql);
	tk=new StringTokenizer(cash_item[i],"◇");
	while(tk.hasMoreTokens()){
		details_number=tk.nextToken();
		cash_value=tk.nextToken();
	}
	tk=new StringTokenizer(cash_itema[i],"◇");
	while(tk.hasMoreTokens()){
		details_number=tk.nextToken();
		cash_valuea=tk.nextToken();
	}
	if(cash_value.equals("⊙")&&!cash_valuea.equals("⊙")){
		cash_value="0";
		if(cash_valuea.indexOf("□")!=-1){
			tk=new StringTokenizer(cash_valuea,"□");
			while(tk.hasMoreTokens()){
				tk1=new StringTokenizer(tk.nextToken(),",");
				while(tk1.hasMoreTokens()){
				sql="insert into finance_cash_table(voucher_in_month_id,details_number,debit,number_in_cash_table,loan,register_time,check_tag) values('"+voucher_id+"','"+details_number+"','"+cash_value+"','"+tk1.nextToken()+"','"+tk1.nextToken()+"','"+register_time+"','"+account_period+"','1')";
				finance_db.executeUpdate(sql);
				}
			}
		}else{
			tk1=new StringTokenizer(cash_valuea,",");
				while(tk1.hasMoreTokens()){
				sql="insert into finance_cash_table(voucher_in_month_id,details_number,debit,number_in_cash_table,loan,register_time,account_period,check_tag) values('"+voucher_id+"','"+details_number+"','"+cash_value+"','"+tk1.nextToken()+"','"+tk1.nextToken()+"','"+register_time+"','"+account_period+"','1')";
				finance_db.executeUpdate(sql);
				}
		}
	}else if(!cash_value.equals("⊙")&&cash_valuea.equals("⊙")){
		cash_valuea="0";
		if(cash_value.indexOf("□")!=-1){
			tk=new StringTokenizer(cash_value,"□");
			while(tk.hasMoreTokens()){
				tk1=new StringTokenizer(tk.nextToken(),",");
				while(tk1.hasMoreTokens()){
				sql="insert into finance_cash_table(voucher_in_month_id,details_number,loan,number_in_cash_table,debit,register_time,account_period,check_tag) values('"+voucher_id+"','"+details_number+"','"+cash_valuea+"','"+tk1.nextToken()+"','"+tk1.nextToken()+"','"+register_time+"','"+account_period+"','1')";
				finance_db.executeUpdate(sql);
				}
			}
		}else{
			tk1=new StringTokenizer(cash_value,",");
				while(tk1.hasMoreTokens()){
				sql="insert into finance_cash_table(voucher_in_month_id,details_number,loan,number_in_cash_table,debit,register_time,account_period,check_tag) values('"+voucher_id+"','"+details_number+"','"+cash_valuea+"','"+tk1.nextToken()+"','"+tk1.nextToken()+"','"+register_time+"','"+account_period+"','1')";
				finance_db.executeUpdate(sql);
				}
		}
	}
}

response.sendRedirect("finance/voucher/check_ok_a.jsp");
}else{
	response.sendRedirect("finance/voucher/check_ok_c.jsp?err_number="+err_count+"&voucher_in_month_id="+voucher_id+"&register_time="+register_time);
}
}else{
	response.sendRedirect("finance/voucher/check_ok_c.jsp?err_number=6&voucher_in_month_id="+voucher_id+"&register_time="+register_time);
}
}else{
	response.sendRedirect("finance/voucher/check_ok_c.jsp?err_number=14&voucher_in_month_id="+voucher_id+"&register_time="+register_time);
}
}else{
	response.sendRedirect("finance/voucher/check_ok_c.jsp?err_number=7&voucher_in_month_id="+voucher_id+"&register_time="+register_time);
}

}else{
	response.sendRedirect("finance/voucher/check_ok_c.jsp?err_number=15&voucher_in_month_id="+voucher_id+"&register_time="+register_time);
}
}else{
response.sendRedirect("finance/voucher/check_ok_b.jsp");
}

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