var tempcount=0;
function loadData(){
	
	var obj = new remoteObject;
	
	obj.connSessionName='remote_ConnectedToDatabase';

	var xsql="select organizeno,lpad('|-',(level-1)*4,' ')||fullname from orgorganize "
			+"connect by prior organizeno=parentorganizeno "
			+"start with organizeno="+organizeid;
	
	//初始区域
	var ts = obj.getResultTable(xsql);
	if(ts!='0'){
		alert(ts);
		return;
	}
	for(var i=0;i<obj.getResultTableRows();i++){	
		initSelect(obj.getResultTableData(i,0),obj.getResultTableData(i,1))
				
	}
	
	//加载农业技术类别

	var xsql="select o.strccode,a.strcname from agricstrc a, orgagric o "
			+"where organizeno="+organizeid
			+" and a.strccode=o.strccode "
			+"order by a.strctype ";
	
	var ts = obj.getResultTable(xsql);
	if(ts!='0'){
		alert(ts);
		return;
	}
	
	clearData();
	
	//alert(countRows(obj.getResultTableRows()));
	//return;
	
	
	//加载数据
	for(var i=0;i<countRows(obj.getResultTableRows());i++){
		var newTR=window.maintbl.insertRow(i+1);
		newTR.className="MTGridText";
		//alert(i);
		//设置标志
		rpoint=i+1;
		
		for (var j=0+(i*5);j<5+(i*5);j++){
			var newTD=newTR.insertCell(-1);
			
			if(j<obj.getResultTableRows()){
				//构造checkbox
				var chkHTML;
				chkHTML="<INPUT type=checkbox name='box' value='"+obj.getResultTableData(j,0)
					   +"' text='"+obj.getResultTableData(j,1)+"'>"+obj.getResultTableData(j,1);
				newTD.insertAdjacentHTML('AfterBegin',chkHTML);
			}
		}
		
	}
	
}

function clearData(){
	
	
	for(var i=0;i<rpoint;i++){
		window.maintbl.deleteRow(1); 
				
	}
	rpoint=0;
}

function fChange(){
	var obj = new remoteObject;
	
	obj.connSessionName='remote_ConnectedToDatabase';

		
	//加载农业技术类别

	var xsql="select o.strccode,a.strcname from agricstrc a, orgagric o "
			+"where organizeno="+window.organize.value 
			+" and a.strccode=o.strccode "
			+"order by a.strctype ";
	
	//alert(xsql);
	
	var ts = obj.getResultTable(xsql);
	if(ts!='0'){
		alert(ts);
		return;
	}
	
	clearData();
	
	//alert(countRows(obj.getResultTableRows()));
	//return;
	
	
	//加载数据
	for(var i=0;i<countRows(obj.getResultTableRows());i++){
		var newTR=window.maintbl.insertRow(i+1);
		newTR.className="MTGridText";
		//设置标志
		rpoint=i+1;
		
		for (var j=0+(i*5);j<5+(i*5);j++){
			var newTD=newTR.insertCell(-1);
			
			if(j<obj.getResultTableRows()){
				//构造checkbox
				var chkHTML;
				chkHTML="<INPUT type=checkbox name='box' value='"+obj.getResultTableData(j,0)
					   +"' text='"+obj.getResultTableData(j,1)+"'>"+obj.getResultTableData(j,1);
				newTD.insertAdjacentHTML('AfterBegin',chkHTML);
			}
		}
		
	}
}

function countRows(rows){
	if (rows==0) return;
	var rcnt=parseInt(rows/5);
	if (rows-(rcnt*5)>0) rcnt=rcnt+1;
	
	if (rcnt==0 && rows!=0)	rcnt=1;
	
	return rcnt;
}

function initSelect(value,text){
  var oOption
  oOption =document.createElement("OPTION");
  oOption.text=text;
  oOption.value=value;
  
  document.all("organize").add(oOption);
  
}

//--判断是否为联通的手机号码
function checkPhone(){
	var verphone=",130,131,132,133,153,156,155,";//联通手机
	
	if (window.phone.value==''){
		alert("请输入手机号码！");
		window.phone.focus();
		return false;  
	}
	
	var tmp=window.phone.value;
	
	if (tmp.length!=11){
		alert("您输入的手机号码有误！");
		window.phone.focus();
		return false; 
		 
	}else{
		//判断是否为联通的手机
		tmp=","+tmp.substr(0,3)+",";
		if(verphone.indexOf(tmp)<0){
			alert("对不起，您只能输入联通用户的手机号码！");
			window.phone.focus();
			return false;
		}
	}
}


//--订阅
function subscript(){

	var smsCodeList=new Array();		//栏目编号
	var smsCodeDesc=new Array();		//栏目名称
	var strcStr="";

    if (checkPhone()==false) return;
    
    if (checkVeryCode()==false) return;
    
    
    	
	/*
	  计算用户选定栏目的费用（add by zhangcj 20050701）
	  ------------------------------------------------
	*/
	var temp=" ";						
	var v_groupCnt=0;
	var v_3itemCnt=0;
	var v_6itemCnt=0;
	var v_9itemCnt=0;
	var sfee=0;
	
	//-----------------------------------------------
	
	//判断用户选择的栏目
	var aPos=0;
	for(var i=0;i<window.box.length;i++){
		if (window.box(i).checked ){
			smsCodeList[aPos]=window.box(i).value ;	//栏目编号
			smsCodeDesc[aPos]=window.box(i).getAttribute("text") ;	//栏目名称  
			
			strcStr=strcStr+"'"+window.box(i).value+"',";
			
			//计算包的数量
			var xcode=window.box(i).value;
			if(temp!=xcode.substr(0,1)){
				v_groupCnt++;
				temp=xcode.substr(0,1);
			}
			
	
			//计算子类的数量
			if (xcode.substr(0,1)=='3'){ v_3itemCnt++;	}
			if (xcode.substr(0,1)=='6'){ v_6itemCnt++;	}
			if (xcode.substr(0,1)=='9'){ v_9itemCnt++;	}
			
			//----------------------------------------------------
			aPos++; 
		}			
	}
	
	//判断用户是否选择了栏目
	if (smsCodeList.length==0){
		alert("请您选择要订阅的栏目类别");
		return;
		
	}
	
	//判断该用户选定的细类是否已经订阅过了...
	if (checkStrccodes(strcStr)){ return; }

	if(v_3itemCnt>3){
		sfee=sfee+parseInt(v_3itemCnt-3);
	}
	
	if(v_6itemCnt>3){
		sfee=sfee+parseInt(v_6itemCnt-3);
	}
	
	
	if(v_9itemCnt>3){
		sfee=sfee+parseInt(v_9itemCnt-3);
	}
	
	if (v_groupCnt==1){ sfee=sfee+3; }
	if (v_groupCnt==2){ sfee=sfee+4; }
	if (v_groupCnt==3){ sfee=sfee+5; }
	
	if (sfee>8){ sfee=8; }	//最高限价8元

	
	
	//完成订阅
	var title="";
	var sendMsg="";
	//生成确认信息
	for(i=0;i<smsCodeDesc.length ;i++){
		sendMsg=sendMsg+smsCodeDesc[i]+"、"
	}
	//修正
	//title="您确认选择订阅"+sendMsg.substr(0,sendMsg.length-1)+"等类农业信息服务吗？包月信息费总计为："+ sfee +"元/月";
	
	//暂时去掉计费信息<2005/7/14>
	title="您确认选择订阅"+sendMsg.substr(0,sendMsg.length-1)+"等类农业信息服务吗？";
	
	//sendMsg="欢迎您使用陕西联通电子农务系统的"+ sendMsg.substr(0,sendMsg.length-1) + "类农业信息服务，包月费用总计为："+ sfee +"元/月。专家咨询热线10109888，回复短信0000可取消全部订阅。";
	
	//暂时去掉计费信息<2005/7/14>
	sendMsg="欢迎您使用陕西联通电子农务系统的"+ sendMsg.substr(0,sendMsg.length-1) + "类农业信息服务，专家咨询热线10109888，回复短信0000可取消全部订阅。";
	
	
	if(confirm(title) !=  true) { return;}
	
	
	var dmlArray=new Array();
	
	var dmlArray1=new Array();
	//alert(smsCodeList.length);
	
	/*2005年11月5日，由于渭南数据库故障，故将此处屏蔽  	
	if(checkOrganize()==true){	//如果是渭南地区需要同步用户到8913数据库中
		for(var i=0;i<smsCodeList.length ;i++){
			var smsCode=smsCodeList[i];
			
			smsCode=smsCode.substr(0,1);
			 
			dmlArray1[i]="insert into sub_item(sun_item_id,item_code,mobile,type,organizeno,strcCode,receivedate) "
				+"values(seq_subitem_id.nextval,'"+smsCode +"','86"+window.phone.value + "','1', "+window.organize.value
				+", '"+smsCodeList[i]+"',sysdate)";		
		}
	
	}
	*/
	
	//10628301数据
	for(var i=0;i<smsCodeList.length ;i++){
		var smsCode=smsCodeList[i];
			
		smsCode=smsCode.substr(0,1);
			 
		dmlArray[i]="insert into UserSubscript(SmsCode,mobile,status,organizeno,strcCode,subsDate,inMode) "
				+"values('"+smsCode +"','86"+window.phone.value + "','1' "
				+", "+window.organize.value +",'"+smsCodeList[i]+"',sysdate,'在线订阅')";
		
	}

	
	//测试SQL
	/*
	for(var i=0;i<dmlArray.length ;i++){
		alert(dmlArray[i]);
	}
	*/
	
	if(dmlArray1.length>0){	//需要同步用户到8913数据库中
		var obj = new remoteObject;
		obj.connSessionName='remote_ConnectedToSMS';	//渭南连接
		var ts1=obj.executeSql(dmlArray1);   //同步执行数据库插入、删除、修改......句法
		if(ts1!='0'){
			alert(ts1);
			return;
		}
	}
	
	//写入订阅表--10628301数据库
	var objsms = new remoteObject;
	objsms.connSessionName='remote_ConnectedToDatabase';
	
	var ts1=objsms.executeSql(dmlArray);   //同步执行数据库插入、删除、修改......句法
	if(ts1!='0'){
		alert(ts1);
		return;
	}else{
		alert("订阅成功！");
		rondx="&&&&";
	}
	
	//发送短信通知用户
	sendmsgNotic(sendMsg);
	
}

//为了应对渭南特殊情况添加 add 20050606 by zhangcj
//编号：adt01
//函数功能，判断登录用户的组织机构是否属于渭南，当属于渭南地区（含渭南）时，发送信息用8913999。

function checkOrganize(){
	
	var objsms = new remoteObject;
	objsms.connSessionName='remote_ConnectedToDatabase';
	
	var xsql="select organizeno from orgorganize "
			+"connect by prior organizeno=parentorganizeno "
            +" start with organizeno=703";
			
	var ts = objsms.getResultTable(xsql);
	if(ts!='0'){
		alert(ts);
		return;
	}
	
	//构造字符串
	var trgstr=',';
		
	for(var i=0;i<objsms.getResultTableRows();i++){	
		trgstr=trgstr+objsms.getResultTableData(i,0)+","
				
	}
		
	if (trgstr.indexOf(","+window.organize.value+",")<0){//非渭南地区
		return false;
		
	}else{	
		//
		return true;  
	}
}

//短信通知用户订阅成功
function sendmsgNotic(sendMsg){
	
	var dmlArray=new Array();	
	
	//给该用户发送短信通知
	/*2005年11月5日，由于渭南数据库故障，故将此处屏蔽 
	if (checkOrganize()==true){	//渭南8913
		var obj = new remoteObject;
		obj.connSessionName='remote_ConnectedToSMS';	//渭南连接
		
		dmlArray[0]="insert into send_msg(feetype,id,feevalue,feemobile,destmobile,msgtype,servicetype,givenvalue,content)"
			+" values('1',seq_msg_id.nextval,'0','86"+window.phone.value+"','86"+window.phone.value+"',"
			+"'1','369','000000',"+"'"+sendMsg+"')";
		
	}else{	//全省10628301
		var obj = new remoteObject;
		obj.connSessionName='remote_ConnectedToDatabase';	//全省的连接
		
		dmlArray[0]="insert into Queuy_Submit(SPNumber,chargeNumber,userNumber,ServiceType,Feetype,feeValue,DataText)"
				+" values('10628301','86"+window.phone.value+"','86"+window.phone.value+"',"
				+"'369',"+1+",'00',"+"'"+ sendMsg +"')";
		
	}			
	*/
	var obj = new remoteObject;
	obj.connSessionName='remote_ConnectedToDatabase';	//全省的连接
		
	dmlArray[0]="insert into sms.Queuy_Submit(SPNumber,chargeNumber,userNumber,ServiceType,Feetype,feeValue,DataText)"
				+" values('10628301','86"+window.phone.value+"','86"+window.phone.value+"',"
				+"'QF',"+1+",'00',"+"'"+ sendMsg +"')";	
		
	var ts1=obj.executeSql(dmlArray);   //同步执行数据库插入、删除、修改......句法
	
	if(ts1!='0'){
		alert(ts1);
		return;
	}
}

function clearOption(){
	var el=document.all("introducer");
	for(var i=el.length-1;i>=0;i--){
		 el.options.remove(i);; 		
	}
	
}

//判断用户是否重复订阅？
function checkStrccodes(strcString){
	//alert(strcString);
	
	
	var objsms = new remoteObject;
	objsms.connSessionName='remote_ConnectedToDatabase';
	
	var xsql="select nvl(a.strcname,transfStrcCode(u.strccode)) "
			+" from usersubscript u,agricstrc a "
			+" where mobile='86"+window.phone.value+"' "
			+" and u.strccode in("+strcString.substr(0,strcString.length-1)+")"
			+" and a.strccode(+)=u.strccode and  u.status='1'";
	
	//alert(xsql);
			
	var ts = objsms.getResultTable(xsql);
	if(ts!='0'){
		alert(ts);
		return;
	}
	
	//构造字符串
	var tipmsg="";
	
	for(var i=0;i<objsms.getResultTableRows();i++){	
		tipmsg=tipmsg+objsms.getResultTableData(i,0)+"、"
				
	}
	
	if (tipmsg!=""){
		alert("您已经订阅过了"+tipmsg.substr(0,tipmsg.length-1)+"类信息，请在本次订阅中取消选择该细类。");
		return true;
		
	}else{
		return false;
	}
	
}

function getVeryCode(){
 if (tempcount==0){

	if (checkPhone()==false) return;
	 
	rondx=Math.random() * 10000;
	rondx=Math.floor(rondx);
	
	//将验证码发送到客户的手机上
	var msg="您的验证码为："+rondx;
		
	var obj = new remoteObject;
	obj.connSessionName='remote_ConnectedToDatabase';	//全省的连接
	
	var dmlArray=new Array();
		
	dmlArray[0]="insert into sms.Queuy_Submit(SPNumber,chargeNumber,userNumber,ServiceType,Feetype,feeValue,DataText)"
				+" values('10628301','86"+window.phone.value+"','86"+window.phone.value+"',"
				+"'QF',"+1+",'00',"+"'"+ msg +"')";
		
		
	var ts1=obj.executeSql(dmlArray);   //同步执行数据库插入、删除、修改......句法
	
	if(ts1!='0'){
		alert(ts1);
		return;
	}else{
		alert("验证码已经发送到您的手机上，请查收...");
		tempcount=1;
	}
  }else{
       alert("对不起，验证码已经发到您手机了，如果在3分钟内没有收到请刷新页面重新获取验证码！谢谢使用！");
	   return;
  }
}

function checkVeryCode(){
	if(window.vCode.value !=rondx){
		alert("你输入的验证码有误，请您仔细查看您收到的验证码！");
		return false;
	}else{
		return true;
	}
}