oa/shares/js/plug-in/jquery.table.shoppingcart.js

/*
 * @author f1jee @date 2009-04-09 功能 :增加表格行 parm:array---表格数据,tid,表格-css
 * modifed by f1jee 2010-02-18 
 * id,countid--行计数
 */
;
( function($) {
	$.fn.addRow = function(arg) {	
	    var $table=$(this);
		var tid =$table.attr("id");
		//alert(tid);
		$tbodyObj = $("<tbody></tbody>");
		$trObj = $("<tr></tr>");		
		$tdObj = $("<th width=\"20px\">序</th>");			
		$trObj.append($tdObj);
		var array = arg.colmuns;		
		for ( var i = 0; i < array.length; i++) {
			var css = array[i].css;
			var title = array[i].title;
			$tdObj = $("<th></th>");
			$tdObj.html(title);
			//$tdObj.resizable();
			//alert(title);
			$trObj.append($tdObj);
		}
		$addButton=$("<input type=\"button\" value=\"+\"  class=\"jq-table-add\">");		
		var showDelBtn=arg.showDelBtn;
			if (showDelBtn ==null)
			{
			showDelBtn=true;
			}
		if 	(showDelBtn==true)
		//this.before($addButton);
		$addButton.click( function() {
	        //alert(arg.count)  
			//appendTr(arg,tid);
		});
		$tdObj = $("<th width=\"40px\">操作</th>");			
		$trObj.append($tdObj);
		$tbodyObj.append($trObj);		
		this.append($tbodyObj);		
		var data = arg.data;
		var array = arg.colmuns;		
		var countid = arg.count;        	    
		
		$countObj = $("#" + countid);
		for (one in data) {
			count = Number($countObj.val()) + 1;
			// alert(count);
			$countObj.val(count.toString());
			$tbodyObj = $("<tbody></tbody>");
			$tbodyObj.attr("id", "tbody" + count.toString());
			this.append($tbodyObj);
			$trObj = $("<tr></tr>");
			$tbodyObj.append($trObj);
			//alert("<td class='"+tid+"td-first'></td>");
			$tdObj = $("<td class='"+tid+"td-first'></td>");			
			$tdObj.html(count.toString());
			$trObj.append($tdObj);			
			for ( var i = 0; i < array.length; i++) {
				var type = array[i].type;
				var name = array[i].id;
				var value = "";
				for (key in data[one]) {
					if (name == key) {
						value = data[one][key];
						break;
					}
				}
				// alert(value);
				var copy_ = array[i].copy;
				var css = array[i].css;
				var title = array[i].title;
				var f_name = array[i].f_name;
				var format_ = array[i].format_;
				$tdObj = $("<td></td>");
				$trObj.append($tdObj);
				id = name + count.toString();
				if (type == "label") {
				    $inputObject = $("<div id='" + id + "'"+">"+value+"</div>");					
					$tdObj.append($inputObject);
					// alert(css);
					if (css != null) {
						$inputObject.css(css);
					}
				}
				if (type == "text") {
					$inputObject = $("<input name=\"" + id + "\""
                    		+ " value=\""				
							+ value + "\"" 
							+" required=\"true\""
							+" validType=\""+format_+"\""
							+ " id=\"" + id + "\""
							+ " onchange=\"checkItem('" + id + "','" + format_
							+ "');\"" + ">");
					$tdObj.append($inputObject);
					$div=$("<div>"+value+"</div>")
					$tdObj.append($div);
					$inputObject.hide();
				   $tdObj.mouseover(function(){
					  //$childs=$(this).children();
					  //$editor=$($childs[0]);										
					  //$editor.show();					
					  //$div=$($childs[1]);
					  //$div.hide();
				   });
                    $tdObj.mouseout(function(){
				      //$childs=$(this).children();
					  //$editor=$($childs[0]);					
					  //$editor.hide();
					  //$div=$($childs[1]);
					  //$div.text($editor.val());
					  //$div.show();
			    	});
					//alert($tdObj.width());
					//$inputObject.width($tdObj.width());
					// alert(css);
					if (css != null) {
						$inputObject.css(css);
					}
					//$inputObject.width($tdObj.width()+"px");
				}
				if (type == "combox-value") {
					id = name + count.toString();
					$selectObject=$("#" + copy_);					
					//$options = $("#" + copy_ + " option");					
					//$options.val(value);
					//$options_ = $("#" + copy_ + " option:selected");					
					$selectObject.val(value);					
					$options_ = $("#" + copy_ + " option:selected");		
                    //alert($options_.text());					
					$inputObject = $("<div id='" + id + "'"+">"+$options_.text()+"</div>");					
					$tdObj.append($inputObject);
					if (css != null) {
						$inputObject.css(css);
					}
					
				}
				if (type == "combox") {
					id = name + count.toString();
					$selectObject = $("<select name=\"" + id + "\"" + " id=\""
							+ id + "\"" + "></select>");
					$options_ = $("#" + copy_ + " option");
					$options_.clone().appendTo($selectObject);
					// alert(value);
					$selectObject.val(value);
					$tdObj.append($selectObject);
					if (css != null) {
						$selectObject.css(css);
					}
					//$selectObject.width($tdObj.width()+"px");
					//$selectObject.height($tdObj.height()+"px");
					$selectObject.hide();
					$a=$("#"+id+" option:selected");
					$div=$("<div>"+$a.text()+"</div>")
					$tdObj.append($div);
					$tdObj.dblclick(function(){
					  $childs=$(this).children();
					  $editor=$($childs[0]);										
					  $editor.show();					
					  $div=$($childs[1]);
					  $div.hide();
				   });
                    $selectObject.change(function(){					  
				      //$childs=$(this).children();
					  //$editor=$($childs[0]);					
					  //$editor.hide();
					  //$div=$($childs[1]);				
                      //alert("========================"+$editor.attr("id"));					  
					  //$a=$("#"+$editor.attr("id")+" option:selected");
					  //alert("#"+$editor.attr("id")+" option:selected");					  
					  //$div.text($a.text());					  
					  //$div.show();
					  //alert("=========");
					  $a=$("#"+$(this).attr("id")+" option:selected");
					  $next=$(this).next();
					  $next.text($a.text());
					  $(this).hide();
					  $next.show();					  
					  //refreshTdEditor(tid);
			    	});
				}
			}
			$tdObj = $("<td></td>");
			$trObj.append($tdObj);
			// 操作
			$btn_del = $("<input type=\"button\" name=\"delBtn\" id=\"delBtn"
					+ count.toString() + "\" value=\"\" class=\"jq-table-x\">");
			// alert($btn_del.attr("id"));
			$btn_del.click( function() {
				// alert($(this).attr("id"));
					//var btnId = $(this).attr("id");
					//var id = btnId.substring(6, 7);
					// alert(id);
					//$("#tbody" + id).remove();
					//刷新序号							
					$(this).parent().parent().parent().remove();                    
					var tid=$table.attr("id");
					//alert("#"+tid +" .td-first");
					var $a=$("."+tid+"td-first");					
					//alert($table.attr("id"));
                      var i=0;					
					 $a.each(function(){					 
					 i++;
					 $(this).html(i);
					 });
					 alert("hi");
                    for(var i=0;i<$a.length;i++)        
		           {		
	               //var $aa=$a[i];
		           //$aa.html("a");
		           //alert($a[i].html());			        				   
		           //$a[i].append("<div>a</div>");		
		           }
				});
			// $btn_del = $("<input type=\"button\" name=\"delBtn\" value=\"删除\"
			// onclick=\"test();\">");
			// alert("<input type=\"button\" name=\"delBtn\" value=\"删除\"
			// onclick=\"delRow('"+ $tbodyObj.attr("id") + "');\">");						
			var showDelBtn=arg.showDelBtn;
			if (showDelBtn ==null)
			{
			showDelBtn=true;
			}						
			if (showDelBtn!=false){
			$tdObj.append($btn_del);
			}			
			 var i=0;					
					 $("."+tid+"td-first").each(function(){					 
					 i++;
					 $(this).html(i);
					 });
		}		
	
	    function refreshTdEditor(tid) {
		var $table=$("#"+tid);
		var $tds=$("#"+tid +" tr td");
		for(var i=0;i<$tds.length;i++){
		   alert(i);
		 }
		}		   
	
	    function appendTr(arg,tid) {        
		var array = arg.colmuns;		
		var countid = arg.count;	        	    		
		var $table=$("#"+tid);
		$countObj = $("#" + countid);		
			count = Number($countObj.val()) + 1;
			// alert(count);
			$countObj.val(count.toString());
			$tbodyObj = $("<tbody></tbody>");
			$tbodyObj.attr("id", "tbody" + count.toString());
			$table.append($tbodyObj);
			$trObj = $("<tr></tr>");
			$tbodyObj.append($trObj);
			//alert("<td class='"+tid+"td-first'></td>");
			$tdObj = $("<td class='"+tid+"td-first'></td>");
			$tdObj.html(count.toString());
			$trObj.append($tdObj);			
			for ( var i = 0; i < array.length; i++) {
				var type = array[i].type;
				var name = array[i].id;
				var value = "";				
				// alert(value);
				var copy_ = array[i].copy;
				var css = array[i].css;
				var title = array[i].title;
				var f_name = array[i].f_name;
				var format_ = array[i].format_;
				$tdObj = $("<td></td>");				  				
				$trObj.append($tdObj);
				id = name + count.toString();
				if (type == "label") {
				    $inputObject = $("<div id='" + id + "'"+">"+value+"</div>");					
					$tdObj.append($inputObject);
					// alert(css);
					if (css != null) {
						$inputObject.css(css);
					}
				}
				if (type == "text") {
					$inputObject = $("<input type1=\"hidden\" name=\"" + id + "\""
                    		+ " value=\""				
							+ value + "\"" 
							+" required=\"true\""
							+" validType=\""+format_+"\""
							+ " id=\"" + id + "\""
							+ " onchange=\"checkItem('" + id + "','" + format_
							+ "');\"" + ">");
					$tdObj.append($inputObject);
					$div=$("<div>"+value+"</div>")
					$tdObj.append($div);
					$inputObject.hide();
				   $tdObj.mouseover(function(){
					 // $childs=$(this).children();
					 // $editor=$($childs[0]);										
					 // $editor.show();					
					 // $div=$($childs[1]);
					 // $div.hide();
				   });
                    $tdObj.mouseout(function(){
				     // $childs=$(this).children();
					 // $editor=$($childs[0]);					
					 // $editor.hide();
					 // $div=$($childs[1]);
					 // $div.text($editor.val());
					 // $div.show();
			    	});
					// alert(css);
					if (css != null) {
						$inputObject.css(css);
					}					
					// alert(css);
					if (css != null) {
						$inputObject.css(css);
					}
					//$inputObject.width($tdObj.width()+"px");
                    //$inputObject.height($tdObj.height()+"px");
				}
				if (type == "combox-value") {
					id = name + count.toString();
					$options_ = $("#" + copy_ + " option");					
					$options_.val(value);
					$inputObject = $("<div id='" + id + "'"+">"+$options_.text()+"</div>");					
					$tdObj.append($inputObject);
					if (css != null) {
						$inputObject.css(css);
					}
				}
				if (type == "combox") {
					id = name + count.toString();
					$selectObject = $("<select name=\"" + id + "\"" + " id=\""
							+ id + "\"" + "></select>");
					$options_ = $("#" + copy_ + " option");
					$options_.clone().appendTo($selectObject);
					//alert(value);
					$selectObject.val(value);
					$tdObj.append($selectObject);
					$div=$("<div>"+value+"</div>")
					$tdObj.append($div);
					$selectObject.hide();
					if (css != null) {
						$selectObject.css(css);
					}										
					//$selectObject.width($tdObj.width()+"px");
					//$selectObject.height($tdObj.height()+"px");
					$tdObj.dblclick(function(){
					  $childs=$(this).children();
					  $editor=$($childs[0]);										
					  $editor.show();					
					  $div=$($childs[1]);
					  $div.hide();
				   });
                    $selectObject.change(function(){					  
				      //$childs=$(this).children();
					  //$editor=$($childs[0]);					
					  //$editor.hide();
					  //$div=$($childs[1]);				
                      //alert("========================"+$editor.attr("id"));					  
					  //$a=$("#"+$editor.attr("id")+" option:selected");
					  //alert("#"+$editor.attr("id")+" option:selected");					  
					  //$div.text($a.text());					  
					  //$div.show();
					  //alert("=========");
					  $a=$("#"+$(this).attr("id")+" option:selected");
					  $next=$(this).next();
					  $next.text($a.text());
					  $(this).hide();
					  $next.show();					  
					  //refreshTdEditor(tid);
			    	});
				}
			}
			$tdObj = $("<td></td>");
			$trObj.append($tdObj);
			// 操作
			$btn_del = $("<input type=\"button\" name=\"delBtn\" id=\"delBtn"
					+ count.toString() + "\" value=\"删除\">");
			// alert($btn_del.attr("id"));
			$btn_del.click( function() {
				// alert($(this).attr("id"));
					//var btnId = $(this).attr("id");
					//var id = btnId.substring(6, 7);
					// alert(id);
					//$("#tbody" + id).remove();
					//刷新序号							
					$(this).parent().parent().parent().remove();                    
					var tid=$table.attr("id");
					//alert("#"+tid +" .td-first");
					var $a=$("."+tid+"td-first");					
					//alert($table.attr("id"));
                      var i=0;					
					 $a.each(function(){					 
					 i++;
					 $(this).html(i);
					 });
					 alert("hi");
                    for(var i=0;i<$a.length;i++)        
		           {		
	               //var $aa=$a[i];
		           //$aa.html("a");
		           //alert($a[i].html());			        				   
		           //$a[i].append("<div>a</div>");		
		           }
				});
			// $btn_del = $("<input type=\"button\" name=\"delBtn\" value=\"删除\"
			// onclick=\"test();\">");
			// alert("<input type=\"button\" name=\"delBtn\" value=\"删除\"
			// onclick=\"delRow('"+ $tbodyObj.attr("id") + "');\">");						
			var showDelBtn=arg.showDelBtn;
			if (showDelBtn ==null)
			{
			showDelBtn=true;
			}						
			if (showDelBtn!=false){
			$tdObj.append($btn_del);
			}			
			 var i=0;					
					 $("."+tid+"td-first").each(function(){					 
					 i++;
					 $(this).html(i);
					 });
				
	}
	//alert(arg.msgRender);
	//if $(arg.msgRender) 
	//$(arg.msgRender).hide();
	return this;
	}
	
	$.fn.addTr = function(arg) {
	//alert("=============");
        var $table=$(this);
		var tid =$table.attr("id");	
        var array = arg.colmuns;		
		var data= arg.data;
		var countid = arg.count;	        	    		
		$countObj = $("#" + countid);		
			count = Number($countObj.val()) + 1;
			// alert(count);
			$countObj.val(count.toString());
			$tbodyObj = $("<tbody></tbody>");
			$tbodyObj.attr("id", "tbody" + count.toString());
			$table.append($tbodyObj);
			$trObj = $("<tr></tr>");
			$tbodyObj.append($trObj);
			//alert("<td class='"+tid+"td-first'></td>");
			$tdObj = $("<td class='"+tid+"td-first'></td>");
			$tdObj.html(count.toString());
			$trObj.append($tdObj);			
			for ( var i = 0; i < array.length; i++) {
				var type = array[i].type;
				var name = array[i].id;
				var value = data[i];				
				// alert(value);
				var copy_ = array[i].copy;
				var css = array[i].css;
				var title = array[i].title;
				var f_name = array[i].f_name;
				var format_ = array[i].format_;
				$tdObj = $("<td></td>");				  				
				$trObj.append($tdObj);
				id = name + count.toString();
				if (type == "label") {
				    $inputObject = $("<div id='" + id + "'"+">"+value+"</div>");					
					$tdObj.append($inputObject);
					// alert(css);
					if (css != null) {
						$inputObject.css(css);
					}
				}
				if (type == "text") {
					$inputObject = $("<input type1=\"hidden\" name=\"" + id + "\""
                    		+ " value=\""				
							+ value + "\"" 
							+" required=\"true\""
							+" validType=\""+format_+"\""
							+ " id=\"" + id + "\""
							+ " onchange=\"checkItem('" + id + "','" + format_
							+ "');\"" + ">");
					$tdObj.append($inputObject);
					$div=$("<div>"+value+"</div>")
					$tdObj.append($div);
					$inputObject.hide();
				   $tdObj.mouseover(function(){
					  //$childs=$(this).children();
					  //$editor=$($childs[0]);										
					  //$editor.show();					
					  //$div=$($childs[1]);
					  //$div.hide();
				   });
                    $tdObj.mouseout(function(){
				      //$childs=$(this).children();
					  //$editor=$($childs[0]);					
					  //$editor.hide();
					  //$div=$($childs[1]);
					  //$div.text($editor.val());
					  //$div.show();
			    	});
					// alert(css);
					if (css != null) {
						$inputObject.css(css);
					}					
					// alert(css);
					if (css != null) {
						$inputObject.css(css);
					}
					$inputObject.width($tdObj.width()+"px");
                    $inputObject.height($tdObj.height()+"px");
				}
				if (type == "combox-value") {
					id = name + count.toString();
					$options_ = $("#" + copy_ + " option");					
					$options_.val(value);
					$inputObject = $("<div id='" + id + "'"+">"+$options_.text()+"</div>");					
					$tdObj.append($inputObject);
					if (css != null) {
						$inputObject.css(css);
					}
				}
				if (type == "combox") {
					id = name + count.toString();
					
					$inputObject = $("<input type1=\"hidden\" name=\"" + id + "\""
                    		+ " value=\""				
							+ value.id_ + "\"" 
							+" required=\"true\""
							+" validType=\""+format_+"\""
							+ " id=\"" + id + "\""							
							+ ">");
					$tdObj.append($inputObject);
					$div=$("<div>"+value.title_+"</div>")
					$tdObj.append($div);
					$inputObject.hide();															
				}
			}
			$tdObj = $("<td></td>");
			$trObj.append($tdObj);
			// 操作
			$btn_del = $("<input type=\"button\" name=\"delBtn\" id=\"delBtn"
					+ count.toString() + "\" value=\"\" class=\"jq-table-x\">");
			// alert($btn_del.attr("id"));
			$btn_del.click( function() {
				// alert($(this).attr("id"));
					//var btnId = $(this).attr("id");
					//var id = btnId.substring(6, 7);
					// alert(id);
					//$("#tbody" + id).remove();
					//刷新序号							
					$tr=$(this).parent().parent();					
                    $tds=$tr.children();
					$td=$($tds[0]);
					var index_del=$td.html();
					$(this).parent().parent().parent().remove();										
					var tid=$table.attr("id");
					//alert("#"+tid +" .td-first");
					var $a=$("."+tid+"td-first");					
					//alert($table.attr("id"));
                      var i=0;					
					 $a.each(function(){					 
					 i++;
					 $(this).html(i);
					 });
					 //alert("hi");
					 alert(index_del);
					var count=$.cookie("dishCount");
					for(var i=index_del;i<count;i++){                           					
					var next=Number(i)+1;
					//alert(next);
					$.cookie("id"+i,$.cookie("id"+next));
					$.cookie("title"+i,$.cookie("title"+next));
					$.cookie("price"+i,$.cookie("price"+next));				
				  }	
				   count=count-1;
				   //alert("count=================================="+count)
				   $.cookie("dishCount",count)
				  
                    for(var i=0;i<$a.length;i++)        
		           {		
	               //var $aa=$a[i];
		           //$aa.html("a");
		           //alert($a[i].html());			        				   
		           //$a[i].append("<div>a</div>");		
		           }
				});
			// $btn_del = $("<input type=\"button\" name=\"delBtn\" value=\"删除\"
			// onclick=\"test();\">");
			// alert("<input type=\"button\" name=\"delBtn\" value=\"删除\"
			// onclick=\"delRow('"+ $tbodyObj.attr("id") + "');\">");						
			var showDelBtn=arg.showDelBtn;
			if (showDelBtn ==null)
			{
			showDelBtn=true;
			}						
			if (showDelBtn!=false){
			$tdObj.append($btn_del);
			}			
			 var i=0;					
					 $("."+tid+"td-first").each(function(){					 
					 i++;
					 $(this).html(i);
					 });
	
	}		
	/**
	暂不实现
	*/
	$.fn.addHeader = function(arg) {
		table = document.getElementById(tid);
		tbodyObj = document.createElement("tbody");
		table.appendChild(tbodyObj);
		trObj = document.createElement("TR");
		tbodyObj.appendChild(trObj);
		for ( var i = 0; i < array.length; i++) {
			thObj = document.createElement("TH");
			thObj.innerHTML = array[i][0];
			trObj.appendChild(thObj);
		}
		thObj = document.createElement("TH");
		thObj.innerHTML = "操作";
		trObj.appendChild(thObj);

	}
	
	/**
	数据求和方法
	*/
	$.fn.sumRow = function(arg) {
	$trs=$("#tableData tr");	
	var rows=1;
	var result=0;	
	//alert("============"+$trs.length);
	var arrForCount=new Array($trs.length-1);
	var arrForValue=new Array($trs.length-1);
	var arrForPercent=new Array($trs.length-1);	
	for ( var i = 0; i < arrForCount.length; i++) {		   
	arrForCount[i]=1;
	}			
	for ( var i = 0; i < arrForPercent.length; i++) {		   
	arrForPercent[i]=1;
	}
	var array = arg.colmuns;   
    var indexSum=arg.index;
	var edit= arg.edit; 	
	//alert(edit);
	// init arrForCount
	for ( var i = 0; i < array.length; i++) {		   
          var index =array[i].index;
	      var type=array[i].type;			   
		   if (type=="count")
		   {
		   var index =array[i].index;
	       $a=$("#tableData tr td:nth-child("+index+") :nth-child(1)");
           //alert($a.length);
           for(var j=0;j<$a.length;j++){ 
		   $input =$($a[j]);
		   if (edit==true) {arrForCount[j]=$input.val();}else {arrForCount[j]=$input.text();}
		   }
         }
		  if (type=="percent")
		   {
		   var index =array[i].index;
	       $a=$("#tableData tr td:nth-child("+index+") :nth-child(1)");
           //alert($a.length);
           for(var j=0;j<$a.length;j++){ 
           $input =$($a[j]);
		   if (edit==true) {arrForPercent[j]=$input.val();}else {arrForPercent[j]=$input.text();}
           arrForPercent[j]=arrForPercent[j]*0.01;           
		   }
         }
		  if (type=="value")
		   {
		   var index =array[i].index;
	       $a=$("#tableData tr td:nth-child("+index+") :nth-child(1)");
		   $result=$("#tableData tr td:nth-child("+indexSum+") :nth-child(1)");
		   //$resultDiv=$("#tableData tr td:nth-child("+indexSum+") :nth-child(2)");
           //alert($a.length);
           for(var j=0;j<$a.length;j++){ 
           $input =$($a[j]);
           arrForValue[j]=$input.val();          
		   
		   if (edit==true) {
		   arrForValue[j]=$input.val();
            $($result[j]).val(arrForCount[j]*arrForValue[j]*arrForPercent[j]);   
			$next=$($result[j]).next();
		    $next.text($($result[j]).val());
		   }else {
		   arrForValue[j]=$input.text();
		   $($result[j]).text(arrForCount[j]*arrForValue[j]*arrForPercent[j]);   
		   //$($resultDiv[j]).text(arrForCount[j]*arrForValue[j]*arrForPercent[j]);   		   
		   }
		    //result=result+arrForCount[j]*arrForValue[j]*arrForPercent[j];       	    
			
			
		   }
         }
		 
		}
    // init arrForPencent
	//for ( var i = 0; i < array.length; i++) {
	//	   var index =array[i].index;
	//	   var type=array[i].type;		    						 			
	//	}
    // init arrForValue
	//for ( var i = 0; i < array.length; i++) {
		  // var index =array[i].index;
		   //var type=array[i].type;		   	      		 			
		//}
		//alert(arrForValue.length);
	//for ( var i = 0; i < arrForValue.length; i++) {		
       //alert(arrForCount[i]);
	    //alert(arrForValue[i]);
		//alert("arrForPercent"+arrForPercent[i]);
		// alert("arrForCount"+arrForCount[i]);
		// alert("arrForValue"+arrForValue[i]);       
	//}
	//alert(result);
	//alert(arg.render);	
	//$(arg.render).html(result.toFixed(2));	   
	}
	
	
	/**
	数据求和方法
	*/
	$.fn.sum = function(arg) {
	$trs=$("#tableData tr");	
	var rows=1;
	var result=0;	
	//alert("============"+$trs.length);
	var arrForCount=new Array($trs.length-1);
	var arrForValue=new Array($trs.length-1);
	var arrForPercent=new Array($trs.length-1);
	
	for ( var i = 0; i < arrForCount.length; i++) {		   
	arrForCount[i]=1;
	}			
	for ( var i = 0; i < arrForPercent.length; i++) {		   
	arrForPercent[i]=1;
	}
	var array = arg.colmuns;   
    var edit= arg.edit; 	
	//alert(edit);
	// init arrForCount
	for ( var i = 0; i < array.length; i++) {		   
          var index =array[i].index;
	      var type=array[i].type;			   
		   if (type=="count")
		   {
		   var index =array[i].index;
	       $a=$("#tableData tr td:nth-child("+index+") :nth-child(1)");
           //alert($a.length);
           for(var j=0;j<$a.length;j++){ 
		   $input =$($a[j]);
		   if (edit==true) {arrForCount[j]=$input.val();}else {arrForCount[j]=$input.text();}
		   }
         }
		  if (type=="percent")
		   {
		   var index =array[i].index;
	       $a=$("#tableData tr td:nth-child("+index+") :nth-child(1)");
           //alert($a.length);
           for(var j=0;j<$a.length;j++){ 
           $input =$($a[j]);
		   if (edit==true) {arrForPercent[j]=$input.val();}else {arrForPercent[j]=$input.text();}
           arrForPercent[j]=arrForPercent[j]*0.01;           
		   }
         }
		  if (type=="value")
		   {
		   var index =array[i].index;
	       $a=$("#tableData tr td:nth-child("+index+") :nth-child(1)");
           //alert($a.length);
           for(var j=0;j<$a.length;j++){ 
           $input =$($a[j]);
           arrForValue[j]=$input.val();           
		   if (edit==true) {arrForValue[j]=$input.val();}else {arrForValue[j]=$input.text();}
		  result=result+arrForCount[j]*arrForValue[j]*arrForPercent[j];       	    
		   }
         }
		 
		}
    // init arrForPencent
	//for ( var i = 0; i < array.length; i++) {
	//	   var index =array[i].index;
	//	   var type=array[i].type;		    						 			
	//	}
    // init arrForValue
	//for ( var i = 0; i < array.length; i++) {
		  // var index =array[i].index;
		   //var type=array[i].type;		   	      		 			
		//}
		//alert(arrForValue.length);
	//for ( var i = 0; i < arrForValue.length; i++) {		
       //alert(arrForCount[i]);
	    //alert(arrForValue[i]);
		//alert("arrForPercent"+arrForPercent[i]);
		// alert("arrForCount"+arrForCount[i]);
		// alert("arrForValue"+arrForValue[i]);       
	//}
	//alert(result);
	//alert(arg.render);
	
	$(arg.render).html(result.toFixed(2));	   
	}
	
	
	
	/**
	数据求和方法
	*/
	$.fn.sumForRow = function(arg) {
	$trs=$("#tableData tr");	
	var rows=1;
	var result=0;	
	//alert("============"+$trs.length);
	var arrForCount=new Array($trs.length-1);
	var arrForValue=new Array($trs.length-1);
	var arrForPercent=new Array($trs.length-1);
	
	for ( var i = 0; i < arrForCount.length; i++) {		   
	arrForCount[i]=1;
	}			
	for ( var i = 0; i < arrForPercent.length; i++) {		   
	arrForPercent[i]=1;
	}
	var array = arg.colmuns;   
    var edit= arg.edit; 	
	//alert(edit);
	// init arrForCount
	for ( var i = 0; i < array.length; i++) {		   
          var index =array[i].index;
	      var type=array[i].type;			   
		   if (type=="count")
		   {
		   var index =array[i].index;
	       $a=$("#tableData tr td:nth-child("+index+") :nth-child(1)");
           //alert($a.length);
           for(var j=0;j<$a.length;j++){ 
		   $input =$($a[j]);
		   if (edit==true) {arrForCount[j]=$input.val();}else {arrForCount[j]=$input.text();}
		   }
         }		 			
		}
    // init arrForPencent
	for ( var i = 0; i < array.length; i++) {
		   var index =array[i].index;
		   var type=array[i].type;		    
			 if (type=="percent")
		   {
		   var index =array[i].index;
	       $a=$("#tableData tr td:nth-child("+index+") :nth-child(1)");
           //alert($a.length);
           for(var j=0;j<$a.length;j++){ 
           $input =$($a[j]);
		   if (edit==true) {arrForPercent[j]=$input.val();}else {arrForPercent[j]=$input.text();}
           arrForPercent[j]=arrForPercent[j]*0.01;           
		   }
         }			 			
		}
    // init arrForValue
	for ( var i = 0; i < array.length; i++) {
		   var index =array[i].index;
		   var type=array[i].type;		   
	       if (type=="value")
		   {
		   var index =array[i].index;
	       $a=$("#tableData tr td:nth-child("+index+") :nth-child(1)");
           //alert($a.length);
           for(var j=0;j<$a.length;j++){ 
           $input =$($a[j]);
           arrForValue[j]=$input.val();           
		   if (edit==true) {arrForValue[j]=$input.val();}else {arrForValue[j]=$input.text();}
		   }
         }		 			
		}
		//alert(arrForValue.length);
	for ( var i = 0; i < arrForValue.length; i++) {		
       //alert(arrForCount[i]);
	    //alert(arrForValue[i]);
		//alert("arrForPercent"+arrForPercent[i]);
		// alert("arrForCount"+arrForCount[i]);
		// alert("arrForValue"+arrForValue[i]);
       result=result+arrForCount[i]*arrForValue[i]*arrForPercent[i];       	   
	}
	//alert(result);
	//alert(arg.render);
	
	$(arg.render).html(result.toFixed(2));	   
	}
	
	
	
	/**
	合并单元格的方法
	*/
	$.fn.join = function(arg) {		
	var $table=$(this);	
	var tid =$table.attr("id");	    
	$tbody=$("#"+tid+" tbody:nth-child(1)");
    $trs=$tbody.children();
	//alert("==="+$trs.length);
	var tr=$trs[0];
	$tds=$(tr).children();
	//alert($tds.length);	
	$trObj = $("<tr></tr>");			
	var array = arg.colmuns;     	
	var k=0;	
	for (var i=0;i<array.length;i++){
	var index=array[i].index;
	var count=array[i].count;
	var title=array[i].title;
    for (var j=0;j<$tds.length;j++){
	 if (j<k) continue;
     if  (j==index) 
	 {
	 $tdObj = $("<th colspan=\""+count+"\">"+title+"</th>");	 	 
	 $trObj.append($tdObj);
	 k=k+count;
	 }
	 if (j<index) 	 
	 {k++;
	 //获得单元格
	 $td=$($tds[j]);	 
	 //删除单元格
	 $tdObj = $("<th rowspan=\"2\">"+$td.text()+"</th>");	 	 	
	 //alert($td.width());
	 $tdObj.width($td.width());
	 $td.remove();
	 $trObj.append($tdObj);}      	 
	 if (i<(array.length-1))
	 {
	 var index_=array[i+1].index;
	 if (j>=(index+count) && j<index_) 	 
	 {
	 k++;
	 //获得单元格
	 $td=$($tds[j]);	 
	 //删除单元格
	 $tdObj = $("<th rowspan=\"2\">"+$td.text()+"</th>");	 	 	 
	 //alert($td.width());
	 $tdObj.width($td.width());
	 $td.remove();
	 $trObj.append($tdObj);
	 }
     }
   	 else
	 {
	 if (j>=(index+count)) 	 
	 {
	 k++;
	 //获得单元格
	 $td=$($tds[j]);	 
	 //删除单元格
	 $tdObj = $("<th rowspan=\"2\">"+$td.text()+"</th>");	 	 	 
	 $tdObj.width($td.width());//alert($td.width());
	 $td.remove();
	 $trObj.append($tdObj);
	 }
	  }
	 }
	}
	$tbody.prepend($trObj);
	}
})(jQuery);