记录自己一些东西，自己前端的js接触比较少,比较烂

记录一下在中移做的党建活动的一些遇到的问题：

1.选择框的选择问题:

采用了隐藏域去获取选择的id

<input type="hidden" name="checkedVoterIds" value="${votingActivity.checkedVoterIds}"/>
<input type="hidden" name="checkedCandidateIds" value="${votingActivity.checkedCandidateIds}"/>

记录自己一些东西，自己前端的js接触比较少,比较烂

votingActivity.onCandidateLoadJoinGridSuccess = function(votingActivityId){
        var rows = $('#candidateActivityJoin_grid').datagrid('getRows');
        var checkedIds = $("#votingActivityDetail_form [name='checkedCandidateIds']").val();
        var ids = checkedIds.split(",");
        for (var i=0;i<rows.length;i++) {
            for (var j=0;j<ids.length;j++) {
                if (rows[i].candidateId == ids[j]) {
               var checkbox = $('#candidateActivityJoin_grid').datagrid('getCheckBox',i).attr('checked',true);
               if(votingActivity.mode == "edit" && status != 0){
                  checkbox.attr("disabled",true);
               }
                }
            }
        }
}

votingActivity.onCandidateJoinGridCheck = function(index,row){
   var checkedIds = $("#votingActivityDetail_form [name='checkedCandidateIds']").val();
   var candidateId = row.candidateId+",";
   $("#votingActivityDetail_form [name='checkedCandidateIds']").val(checkedIds+candidateId);
}
votingActivity.onCandidateJoinGridUnCheck = function(index,row){
   var checkedIds = "," + $("#votingActivityDetail_form [name='checkedCandidateIds']").val();
   var candidateId = "," + row.candidateId + ",";
   var regexp  = "/" +candidateId + "/g"
    checkedIds = checkedIds.replace(eval(regexp), ",");
    if(checkedIds.length>0 && checkedIds.substring(0, 1) == ","){
        checkedIds = checkedIds.substring(1,checkedIds.length)
    }
   $("#votingActivityDetail_form [name='checkedCandidateIds']").val(checkedIds);
}

votingActivity.onCandidateJoinGridCheckAll = function(index,row){
    var checkedIds = $("#votingActivityDetail_form [name='checkedCandidateIds']").val();
    var rows = $('#candidateActivityJoin_grid').datagrid('getRows');
    for (var i=0;i<rows.length;i++) {
        var candidateId = "," +rows[i].candidateId+",";
        var regexp  = "/"+candidateId+"/g";
        checkedIds = checkedIds.replace(eval(regexp ), ",");
        checkedIds += rows[i].candidateId+",";
    }
    $("#votingActivityDetail_form [name='checkedCandidateIds']").val(checkedIds);
}


votingActivity.onCandidateJoinGridUnCheckAll = function(index,row){
   var checkedIds = ","+$("#votingActivityDetail_form [name='checkedCandidateIds']").val();
   var rows = $('#candidateActivityJoin_grid').datagrid('getRows');
   for (var i=0;i<rows.length;i++) {
      var candidateId = "," +rows[i].candidateId+",";
      var regexp  = "/"+candidateId+"/g";
      checkedIds = checkedIds.replace(eval(regexp ), ",");
   }
   if(checkedIds.length>0 && checkedIds.substring(0, 1) == ","){
      checkedIds = checkedIds.substring(1,checkedIds.length)
   }
   $("#votingActivityDetail_form [name='checkedCandidateIds']").val(checkedIds);
}

2.还有 select group_concat (DISTINCT VOTER_ID) checkedVoterIds from voter

group_concat 长度 mysql数据要修改的问题

①.group_concat 有个最大长度，超过的话会被截取掉

　　select @@global.group_concat_max_len;

　　show variables like "group_concat_max_len";

②.在MySQL配置文件中my.conf或my.ini中添加:

　　#[mysqld]
　　group_concat_max_len=102400

③.重启mysql服务

记录自己一些东西，自己前端的js接触比较少,比较烂

相关推荐