vendredi 12 août 2016

jqgrid checkbox can not retain as checked after sorting or searching

Can any body help me to sort out my problem?

The problem is: as I have checked some checkbox and than searching using text box or sorting the column, the checked checkbox can not reatin as checked.

Here is my code snippet:

<script type="text/javascript">

// PREPARE VARIABLE FOR TABLE DATA FILLUP

` var mydata = [

$qry = "SELECT * FROM tblRawVideo WHERE gameID = '$gameArray[0]' $where AND skipClip != 'skip' order by sequence, camera";
$result = @mysql_query($qry);
$num = mysql_numrows($result);                              
if($result) {
    $i=0;
    while ($i < $num) {
        $sequence = mysql_result($result,$i,"sequence");
        $odk = mysql_result($result,$i,"odk");
        $down = mysql_result($result,$i,"down");
        $distance = mysql_result($result,$i,"distance");
        $hash = mysql_result($result,$i,"hash");
        $yardLine = mysql_result($result,$i,"yardLine");
        $playType = mysql_result($result,$i,"playType");
        $resultCol = mysql_result($result,$i,"result");
        $gainLoss = mysql_result($result,$i,"gainLoss");
        $offenseForm = mysql_result($result,$i,"offenseForm");
        $personnel = mysql_result($result,$i,"personnel");
        $playCall = mysql_result($result,$i,"playCall");
        $playDirection = mysql_result($result,$i,"playDirection");
        $defenseFront = mysql_result($result,$i,"defenseFront");
        $coverage = mysql_result($result,$i,"coverage");
        $blitz = mysql_result($result,$i,"blitz");
        $quarter = mysql_result($result,$i,"quarter");
        $athleteIDs = mysql_result($result,$i,"athleteIDs");
        $videoID = mysql_result($result,$i,"videoID");
        $fileName = mysql_result($result,$i,"fileName");

        echo "{";
        echo "sequence:'$sequence',";
        echo "odk:'$odk',";
        echo "down:'$down',";
        echo "distance:'$distance',";
        echo "hash:'$hash',";
        echo "yardLine:'$yardLine',";
        echo "playType:'$playType',";
        echo "resultCol:'$resultCol',";
        echo "gainLoss:'$gainLoss',";
        echo "offenseForm:'$offenseForm',";
        echo "personnel:'$personnel',";
        echo "playCall:'$playCall',";
        echo "playDirection:'$playDirection',";
        echo "defenseFront:'$defenseFront',";
        echo "coverage:'$coverage',";
        echo "blitz:'$blitz',";
        echo "quarter:'$quarter',";
        $athleteIDs = explode(",",$athleteIDs);
        if( in_array($athleteID, $athleteIDs) ){
            echo "coach:'Yes',";
        }else{
            echo "coach:'No',";
        }
        echo "videoID:'$videoID',";
        echo "fileName:'$fileName'";
        echo "},";
        $i++;
    }
} else {
    echo $qry;
    echo "Query Failed 2";
}
mysql_free_result($result); ?>

];

$(document).ready(function () {

var selector = '.button-gametype .gametype';

//TO LOAD THE DATA IN TABLE
if(mydata != "")
{
    $("#savebtn").show();
    $("#example1").show();
    $("#jqGrid").jqGrid({
        datatype: "local",
        data: mydata,
        height: 250,
        width: 961,
        colModel: [
            { label : "Clip",
                //sorttype: 'integer',
                name: 'videoID', 
                key: true, 
                width: 75 ,
                colmenu : true,
                coloptions : {sorting:true, columns: true, filtering: true, seraching:true, grouping:false, freeze : true},
                searchoptions : {
                    searchOperMenu : false,
                    sopt : ['eq','gt','lt','ge','le']
                },
                formatter: formatLink
            },

            { label: 'ODK', name: 'odk', width: 75 },
            { label: 'Down', name: 'down', width: 75 },
            { label: 'Dist', name: 'distance', width: 75 },
            { label: 'Hash', name: 'hash', width: 75 },
            { label: 'Yard', name: 'yardLine', width: 75 },
            { label: 'Play Typ', name: 'playType', width: 75 },
            { label: 'Result', name: 'resultCol', width: 75 },
            { label: 'Gn/Ls', name: 'gainLoss', width: 75 },
            { label: 'Off.Form', name: 'offenseForm', width: 75 },
            { label: 'Pesonnal', name: 'personnel', width: 75 },
            { label: 'Play Call', name: 'playCall', width: 75 },
            { label: 'Play Dir', name: 'playDirection', width: 75 },
            { label: 'Def Form', name: 'defenseFront', width: 75 },
            { label: 'Coverage', name: 'coverage', width: 75 },
            { label: 'Blitz', name: 'blitz', width: 75 },
            { label: 'Quarter', name: 'quarter', width: 75 },
            { label : "Coach", name: 'coach', width: 75, formatter: formatLink1 },
        ],
        viewrecords: true, // show the current page, data rang and total records on the toolbar
        <!--sortable: true,-->
        colMenu : true,
        shrinkToFit : false,
        multiselect: true,
        caption: "Game Film Search Tool",
    });
    $('#jqGrid').jqGrid('filterToolbar',{
        stringResult: true,
        //searchOnEnter: false,
        searchOperators : true
    });
}
else{
    $("#example1").hide();
    <?php if(isset($_GET['ID']))
    {
        ?>$("#savemsg").text("No Record Found");
        $("#savemsg").show(); <?php
    } ?>
}

});

// AS SELECT CHECKBOX FROM TABLE function getSelectedRows() {

var grid = $("#jqGrid");
var rowKey = grid.getGridParam("selrow");

if (!rowKey)
    alert("No rows are selected");
else {
    var selectedIDs = grid.getGridParam("selarrrow");
    var result = "";
    for (var i = 0; i < selectedIDs.length; i++) {
        result += selectedIDs[i] + ",";
    }

    var reelName = prompt("Please enter a title", "Title");
    if (reelName != null) {
        //alert("Saving " + reelName + " with these clips" + result);
        var gameid = $(".schoolid_chk").val();
        var result = result.slice(0,-1);
        $.ajax({
            data:{'reelName':reelName,'result': result},
            type: 'POST',
            dataType:'html',
            url: 'saveReelHeaderAndDetail.php',
            success:function(data){
                    $('#savemsg').text(data);
                    $('#savemsg').show();
            },
        });
    }
}                

}




Aucun commentaire:

Enregistrer un commentaire