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