回复 8# jack
//首先判断是否在试用期间,如果是使用则免费使用
var balance=0;
var docid ="";
var Parent=createObject("com.addition.parent.Parent");
Parent.garbageCollector();
var phone=getItemValue("follow_phone");//接收号码
var outcontent=getItemValue("outcontent");//短信内容
var r="";
var userid =getWebUser().getId();
var username=getWebUser().getLoginno();
var NameOfPerson=getItemValueAsString("ContactName");
//var sql ="select * from TLK_KF_account1 where author ='"+userid+"' ";
var sql="select * from tlk_kf_Account1 where id in(select item_OpeningBankID from tlk_kf_qy where item_OrganizationCode in(select item_OrganizationCode from tlk_kf_gr where item_UserName='"+username+"'))";
println("查询TLK_KF_account1表sql-------------------------"+sql);
var sql01="select * from tlk_kf_qy where item_OrganizationCode=(select item_OrganizationCode from tlk_kf_gr where item_UserName='"+username+"')";
var doc01=queryBySQL(sql01);
if(doc01.size()>0){
for(var iter=doc01.iterator();iter.hasNext();){
var doc=iter.next();
var Status=doc.getItemValueAsString("Status");//试用,在用,注销
var RegisterDateTime=doc.getItemValueAsDate("RegisterDateTime");//注册日期
var TrialPeriod=doc.getItemValueAsDate("TrialPeriod");//试用期限
if(Status=="试用"){
println("试用期");
println("发送短信---------------------------phone="+phone+",content="+outcontent+",NameOfPerson="+NameOfPerson);
r+="/portal/jsp/sms/sms1.jsp?phone="+phone+"&content="+outcontent+"&NameOfPerson="+NameOfPerson+"&UserName=kingon&type=sms";
}else{
println("非试用期");
var list =queryBySQL(sql);
for(var iter =list.iterator();iter.hasNext();){
var doc =iter.next();
docid =doc.getId();
balance=doc.getItemValueAsDouble("balance");
break;
}
if(docid !="" && docid !=null ){
if(balance<0.1){
//提示账户余额不足
r+="/portal/jsp/pay/pay_balanceLack.jsp";
}else{
//发送短信
var request = $WEB.getParamsTable().getHttpRequest();//获取当前request
var locationId=request.getSession().getAttribute("locationId");
sql ="select * from TLK_kf_addcar where id ='"+locationId+"' ";
println("查询TLK_kf_addcar表sql------------------------------------------"+sql);
list =queryBySQL(sql);
for(var iter =list.iterator();iter.hasNext();){
var doc =iter.next();
//NameOfPerson=doc.getItemValueAsString("ContactName");
break;
}
println("发送短信---------------------------phone="+phone+",content="+outcontent+",NameOfPerson="+NameOfPerson);
r+="/portal/jsp/sms/sms1.jsp?phone="+phone+"&content="+outcontent+"&NameOfPerson="+NameOfPerson+"&UserName=kingon&type=sms";
}
}else{
//未开设账户
r+="/portal/jsp/pay/pay_noBalance.jsp";
}
}
}
}
r; |