js table rootpath

最新推荐文章于 2024-10-15 16:29:04 发布

spencer_tseng

最新推荐文章于 2024-10-15 16:29:04 发布

阅读量683

点赞数

CC 4.0 BY-SA版权

分类专栏： js-flex

本文链接：https://blog.youkuaiyun.com/spencer_tseng/article/details/78196404

js-flex 专栏收录该内容

103 篇文章

订阅专栏

本文介绍如何利用jqGrid插件实现网页表格的数据编辑功能，包括输入框和文本区域的设置，以及通过JavaScript处理表格数据并发送到后端进行批量更新。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

			jqgrid({
				gridTableId : "#gridTable2",
				gridPagerId : "#gridPager2",
				postData :filter,
				multiselect:false,
				isReportStyle:true,
				sortname: 'xhId',
				gridComplete:nowGridComplete,
				//选择当前的
				loadComplete: function loadComplete(data)
				{
					setLoadData(data.rows);
					$('.ui-jqgrid-labels.jqg-third-row-header').css({height:'56px'});
				    $('.ui-state-default.ui-jqgrid-hdiv').css({height:'43px'});
				      var zyxxobj=$('#zyxxlist option');
				      for(var i=0;i<zyxxobj.length;i++){
		        	   if(zyxxobj[i].text==filter.title){
		        	      $("#zyxxlist").get(0).options[i].selected = true;
		        	   }
		        	}
				    
					//vertical-align: middle;
				    $("#gridTable2").rowspan(0);//第一列合并
					$("#gridTable2").rowspan(1);//第二列合并
// 					$("td[rowspan]").css({"vertical-align": "middle"});
					$("td").css({"vertical-align": "middle"});
					
					
					var table2 = document.getElementById("gridTable2");
					var row = null;
					var cell = null;
					var value = "";
					var text = null;
					var textArea = null;
					for (var i = 1; i < table2.rows.length; i++)
					{
						row = table2.rows[i];
						
						for (var j = 7; j < row.cells.length; j++)
						{
							cell = row.cells[j];
							value = cell.innerHTML;
							
							
							if (j == 7)
							{
// 								<input type="text" value="入门狗" size="10" Maxlength="15">
								text = document.createElement("input");
								text.type = "text";
								text.value = value ? value : "";
// 								text.onkeyup = function()
// 								{
// 									value = value.replace(/[^\d\.]/g, '');
// 								}
								
								
								text.onblur = function()
								{
									this.value = this.value.replace(/[^\d\.]/g, "");
									
									if (this.value == null || this.value == "")
									{
										alert("必填项不能为空。");
										this.focus();
									}
								}

								cell.innerHTML = "";
								cell.appendChild(text);
							}
							else if (j == 8)
							{
// 								<textarea row="3" col="4">入门狗的博客园</textarea>
								textArea = document.createElement("textarea");
								textArea.value = value ? value : "";
								textArea.setAttribute("class", "textarea_8");
								
								cell.innerHTML = "";
								cell.appendChild(textArea);
							}
						}
					}
					
					$(".textarea_8").css({"width": "270px"});
					$("#gridTable2").append("<tr role='row' class='ui-widget-content jqgrow ui-row-ltr ui-priority-secondary'><td colspan='3' role='gridcell' style='text-align:left;vertical-align: middle;' title='是否推荐”义务教育管理标准化学校”最值得宣传的学校'>是否推荐”义务教育管理标准化学校”最值得宣传的学校</td><td colspan='5' role='gridcell' style='text-align:left;vertical-align: middle;'><input width='30px' type='radio' name='isRecommend' value='1'>推荐 <input width='30px' type='radio' name='isRecommend' value='0'>不推荐</td></tr>");
					
// 					<tr role="row" id="20170928100000102964" tabindex="-1" class="ui-widget-content jqgrow ui-row-ltr ui-priority-secondary">
// 						<td role="gridcell" style="text-align: left; display: none;" title="一、平等对待每位学生" aria-describedby="gridTable2_yjmc">一、平等对待每位学生</td>
// 						<td role="gridcell" style="text-align: left; display: none;" title="（三）满足需要关注学生的需求" aria-describedby="gridTable2_ejmc">（三）满足需要关注学生的需求</td>
// 						<td role="gridcell" style="text-align:left;display:none;" title="20170928100000102964" aria-describedby="gridTable2_sysId">20170928100000102964</td>
// 						<td role="gridcell" style="text-align:left;" title="10" aria-describedby="gridTable2_xhId">10</td>
// 						<td role="gridcell" style="text-align:left;" title="一视同仁关心外来进城务工随迁子女入学，建立留守儿童关爱机制，积极与社会团体开展关爱活动。" aria-describedby="gridTable2_jtglyq">一视同仁关心外来进城务工随迁子女入学，建立留守儿童关爱机制，积极与社会团体开展关爱活动。</td>
// 						<td role="gridcell" style="text-align:left;" title="2" aria-describedby="gridTable2_fz">2</td>
// 						<td role="gridcell" style="text-align:left;" title="2" aria-describedby="gridTable2_xxzpdf">2</td>
// 						<td role="gridcell" style="text-align:left;" title="2" aria-describedby="gridTable2_xsqhcdf"><input type="text"></td>
// 						<td role="gridcell" style="text-align:left;" title="2" aria-describedby="gridTable2_sqspgdf"><input type="text"></td>
// 					</tr>

//					<input type='radio' name='isRecommend' value='1'>推荐 <input type='radio' name='isRecommend' value='0'>不推荐
// 					<input type="radio" name="isRecommend" value="1">推荐 <input type="radio" name="isRecommend" value="0">不推荐
				}
			});
			
			
// 			function keyPress(ob)
// 			{
// 				if (!ob.value.match(/^[\+\-]?\d*?\.?\d*?$/))
// 				{
// 					ob.value = ob.t_value;
// 				}
// 				else
// 				{
// 					ob.t_value = ob.value;
// 				}
				
// 				if (ob.value.match(/^(?:[\+\-]?\d+(?:\.\d+)?)?$/))
// 				{
// 					ob.o_value = ob.value;
// 				}
// 			}
			
// 			function keyUp(ob)
// 			{
// 				if (!ob.value.match(/^[\+\-]?\d*?\.?\d*?$/))
// 				{
// 					ob.value = ob.t_value;
// 				}
// 				else
// 				{
// 					ob.t_value = ob.value;
// 				}
				
// 				if (ob.value.match(/^(?:[\+\-]?\d+(?:\.\d+)?)?$/))
// 				{
// 					ob.o_value = ob.value;
// 				}
// 			}
			
// 			function onBlur(ob)
// 			{
// 				if (!ob.value.match(/^(?:[\+\-]?\d+(?:\.\d+)?|\.\d*?)?$/))
// 					ob.value=ob.o_value;
// 				else
// 				{
// 					if (ob.value.match(/^\.\d+$/))
// 						ob.value=0+ob.value;
					
// 					if (ob.value.match(/^\.$/))
// 						ob.value=0;ob.o_value=ob.value;
// 				}
// 			}
			
			var errorMsg = "";
			
			/**
			 * 保存
			 * 
			 * @author ZengWenFeng
			 * @date 2017.10.10
			 */
			function batchUpdate(event)
			{
// 				$("input:radio:checked").val();
// 				$("input[type='radio']:checked").val();
// 				$("input[name='rd']:checked").val();
				var isRecommend = $("input[name='isRecommend']:checked").val();
// 				alert(isRecommend);
				if (isRecommend == null || isRecommend == undefined || isRecommend == "")
				{
					$("#title").text("是否推荐必选。");
// 					alert("是否推荐必选。");
					$("input[name='isRecommend']").focus();
					return;
				}
				
				var table2 = document.getElementById("gridTable2");
				var tableData = getTableData(table2);
				
				
				$("#title").text(tableData);
// 				alert(tableData);
				
				if (errorMsg != null && errorMsg.length > 0)
				{
// 					alert(errorMsg);
					$("#title").text(errorMsg);
					return;
				}
				
				var obj = new Object();
				obj.tableData = JSON.stringify(tableData);
				obj.isRecommend = isRecommend;
				
				$.ajax(
				{
					type:"post",
					url: getRootPath() + "/modules/eva/xxpsy/batchUpdate",
					data:obj,
					dataType:"json",
					success: function(data)
					{
						if (data.code == 200)
						{
							showGritter("", data.message);//消息提示
						}
						else if (data.code == 500)
						{
							showGritter("", data.message);//消息提示
						}
					}
				});
			}
			
			//提取表格的值,JSON格式  
			function getTableData(table)
			{
				var tableData = new Array();
				
// 				alert("行数：" + table.rows.length);

				// 遍历除头一行和最后一行的数据
				for (var i = 1; i < table.rows.length - 1; i++)
				{
					tableData.push(getRowData(table.rows[i], i));
				}

				return tableData;
			}
			
			//提取指定行的数据，JSON格式  
			function getRowData(row, i)
			{
				var rowData = {};
				
				var value5 = "";
				var value7 = "";
				
				for (var j = 2; j < row.cells.length; j++)
				{
// 					var name = row.parentNode.rows[0].cells[j].getAttribute("id");
					var name = row.cells[j].getAttribute("aria-describedby");
					name = name.substring(name.indexOf("_") + 1);
					
					if (name)
					{
						var cell = row.cells[j];
						
						var value = "";
						
						if (j == 7 || j == 8)
						{
// 							debugger;
							var obj = cell.children[0];
							value = obj.value;
// 							value = cell.children[0].value;
							
							if (!value)
							{
								value = obj.innerHTML;
							}
						}
						else
						{
							value = cell.getAttribute("value");
							
							if (!value)
							{
								value = cell.innerHTML;
							}
						}
						
						rowData[name] = value;
						
						if (j == 5)
						{
							value5 = value;
						}
						
						if (j == 7)
						{
							value7 = value;
						}
					}
				}
				
				if (value7 > value5)
				{
					errorMsg = errorMsg + "第" + i + "行【评分】数值大于【分值】数值。" + "\n";
				}
				
				return rowData;
			}
			
			
			/**
			 * 
			 * @author ZengWenFeng
			 * @date 2017.10.10
			 * @return 根目录路径
			 */
			function getRootPath()
			{    
				var curWwwPath = window.document.location.href;    
				var pathName = window.document.location.pathname;    
				var pos = curWwwPath.indexOf(pathName);    
				var localhostPaht = curWwwPath.substring(0,pos);    
				var projectName = pathName.substring(0, pathName.substr(1).indexOf('/') + 1);
				
				return (localhostPaht + projectName);
			}

	@ResponseBody
	@RequestMapping(value = "/batchUpdate", method = RequestMethod.POST)
	public Message batchUpdate(HttpServletRequest request, HttpServletResponse response, @ModelAttribute RepBaseFilter filter) 
	{
		// 获取客户端对象
		String str = request.getParameter("tableData");
		String isRecommend = request.getParameter("isRecommend");
		
		System.out.println(str);
		System.out.println(isRecommend);
		
		// 将JSONObject转换Java对象
		JSONArray arr = new JSONArray(str);