Guriddo » sagana's Replies

sagana

Guriddo

Forum Replies Created

Viewing 15 replies - 16 through 30 (of 59 total)

← 1 2 3 4 →

Author

Replies

March 20, 2018 at 1:32 pm in reply to: Trigger ajax call from change in inline edit dropdown #126784

sagana

Participant

Hi will
Many thanks for your prompt reply. Unfortunately dropping your code in (or inserting the js:) does not seem to be firing in as much as no alert box pops up.
Any other ideas please.

February 26, 2018 at 11:40 am in reply to: Refresh entire page before reload grid #126693

sagana

Participant

Hi Will, basically we need to intercept the process before a grid reload. beforeRequest does this but only on the first creation of the grid and we need to do it any time the grid is to be refreshed, reloaded, searched etc. Is there a method we can invoke to do this. Many thanks.

January 29, 2018 at 1:21 pm in reply to: Get reload grid reset search dialog to empty search criteria #126608

sagana

Participant

Quite right, many thanks.

January 26, 2018 at 10:43 am in reply to: datepicker in jqgrid #126604

sagana

Participant

Hi Will

I am confused as to what I should be setting the various elements to. I have:

$grid->setColProperty("activeAfter", array("label"=>"Active after", "width"=>30, "hidden"=>true, "searchoptions"=>array("searchhidden"=>true, "sopt"=>array("ge")), "formatter"=>"date", "sorttype"=>"date", "formatoptions"=>array( "srcformat"=>'Y-m-d', "newformat"=>'d/m/Y')));

and

// Set the datepicker. Note that the script automatically
// converts the user date set in the jqGrid 
$grid-&gt;setDatepicker(&#039;activeBefore&#039;, array(&quot;showOn&quot;=&gt;&quot;focus&quot;,&quot;altFormat&quot;=&gt;&quot;Y-m-d&quot;), true, true);
$grid-&gt;setDatepicker(&#039;activeAfter&#039;, array(&quot;showOn&quot;=&gt;&quot;focus&quot;,&quot;altFormat&quot;=&gt;&quot;Y-m-d&quot;), true, true);
$grid-&gt;setDatepicker(&#039;FinishedAt&#039;, array(&quot;showOn&quot;=&gt;&quot;focus&quot;,&quot;altFormat&quot;=&gt;&quot;Y-m-d&quot;), true, true);
//$grid-&gt;datearray = array(&#039;CreatedAt&#039;);
// Finally set the database setting for the date

$grid-&gt;setUserTime(&quot;Y-m-d H:i:s&quot;);
$grid-&gt;SetUserDate(&quot;Y-m-d H:i:s&quot;);
$grid-&gt;setDbDate(&quot;Y-m-d H:i:s&quot;);
$grid-&gt;setDbTime(&quot;Y-m-d H:i:s&quot;);

$grid-&gt;datearray = array(&#039;activeBefore&#039;,&#039;activeAfter&#039;,&#039;FinishedAt&#039;);

// Set the datepicker. Note that the script automatically

// converts the user date set in the jqGrid

$grid->setDatepicker('activeBefore', array("showOn"=>"focus","altFormat"=>"Y-m-d"), true, true);

$grid->setDatepicker('activeAfter', array("showOn"=>"focus","altFormat"=>"Y-m-d"), true, true);

$grid->setDatepicker('FinishedAt', array("showOn"=>"focus","altFormat"=>"Y-m-d"), true, true);

//$grid->datearray = array('CreatedAt');

// Finally set the database setting for the date

$grid->setUserTime("Y-m-d H:i:s");

$grid->SetUserDate("Y-m-d H:i:s");

$grid->setDbDate("Y-m-d H:i:s");

$grid->setDbTime("Y-m-d H:i:s");

$grid->datearray = array('activeBefore','activeAfter','FinishedAt');

Selecting 10th May 2017 in the data picker in the search dialog displays 10/5/2017 in the search dialog. Checking the $_REQUEST after the search gives

[filters] => {"groupOp":"AND","rules":[{"field":"activeAfter","op":"ge","data":"10/05/2017"}]}

How do I get this to be 2017-05-10 at this point.

Many thanks

January 26, 2018 at 10:29 am in reply to: Get reload grid reset search dialog to empty search criteria #126602

sagana

Participant

Thank you for your prompt response.
I already have recreateFilter set to true as in

$grid-&gt;navigator=true;

$grid-&gt;setNavOptions(&#039;navigator&#039;,array(   
    &quot;refresh&quot;=&gt;true,
    &quot;excel&quot;=&gt;false,
    &quot;add&quot;=&gt;false,
    &quot;edit&quot;=&gt;false,
    &quot;del&quot;=&gt;false,
    &quot;view&quot;=&gt;false,
    &quot;multipleSearch&quot;=&gt;true,
    &quot;multipleGroup&quot;=&gt;true,
    &quot;recreateFilter&quot;=&gt;true
    )); 

$grid-&gt;setNavOptions(&#039;search&#039;,array(
    &quot;drag&quot;=&gt;false,
    &quot;caption&quot;=&gt;translator_get_text(&quot;Search...&quot;,&quot;UserUI_Candidate&quot;),
    &quot;Find&quot;=&gt;translator_get_text(&quot;Search&quot;,&quot;UserUI_Candidate&quot;),
    &quot;Reset&quot;=&gt;translator_get_text(&quot;Show All&quot;,&quot;UserUI_Candidate&quot;),
    &quot;addrule&quot;=&gt;translator_get_text(&quot;Add search criteria&quot;,&quot;UserUI_Candidate&quot;),
    &quot;delrule&quot;=&gt;translator_get_text(&quot;Remove search criteria&quot;,&quot;UserUI_Candidate&quot;),
    &quot;closeOnEscape&quot;=&gt;true,
    &quot;searchOnEnter&quot;=&gt;true,
    &quot;closeAfterSearch&quot;=&gt;true 
    )
);

$grid->navigator=true;

$grid->setNavOptions('navigator',array(

"refresh"=>true,

"excel"=>false,

"add"=>false,

"edit"=>false,

"del"=>false,

"view"=>false,

"multipleSearch"=>true,

"multipleGroup"=>true,

"recreateFilter"=>true

));

$grid->setNavOptions('search',array(

"drag"=>false,

"caption"=>translator_get_text("Search...","UserUI_Candidate"),

"Find"=>translator_get_text("Search","UserUI_Candidate"),

"Reset"=>translator_get_text("Show All","UserUI_Candidate"),

"addrule"=>translator_get_text("Add search criteria","UserUI_Candidate"),

"delrule"=>translator_get_text("Remove search criteria","UserUI_Candidate"),

"closeOnEscape"=>true,

"searchOnEnter"=>true,

"closeAfterSearch"=>true

)

);

but it appears the filters are not being cleared.

Regards
Murray

January 16, 2018 at 4:22 pm in reply to: Keep search dialog permanently visible #126580

sagana

Participant

We would like the ability to have the search dialog across the top above the grid and have it permanently visible. I know we can put search/filter boxes in the toolbar but these would not work with the hidden fields on which we search. We could do this using javascript but are interested in building it in the php code we use to build the grid.

January 15, 2018 at 11:00 am in reply to: Capture sql string used to create filtered grid #126574

sagana

Participant

Thank you Tony, that works well.

January 11, 2018 at 1:32 pm in reply to: sortableRows after Drag and Drop #126570

sagana

Participant

Hi Tony

Thank you for the response. Just to clarify; are you saying this ability to drag, drop and sort is only available between containers but not in jqGrid or should code like the following work with between grids. ie. using the something like the following

$sort = &lt;&lt;&lt; SORTABLE
$( function() {
    $( &quot;#fixedorderlist, #randomorderlist&quot; ).sortable({
      connectWith: &quot;.connectedSortable&quot;
    }).disableSelection();
  } );

SORTABLE;
$grid-&gt;setJSCode($sort);

$sort = <<< SORTABLE

$( function() {

$( "#fixedorderlist, #randomorderlist" ).sortable({

connectWith: ".connectedSortable"

}).disableSelection();

} );

SORTABLE;

$grid->setJSCode($sort);

instead of

$dragdropf = &lt;&lt;&lt; DRAGF
jQuery(&#039;#fixedorderlist&#039;).jqGrid(&#039;gridDnD&#039;,
     {connectWith:&#039;#randomorderlist&#039;, ...........

$dragdropf = <<< DRAGF

jQuery('#fixedorderlist').jqGrid('gridDnD',

{connectWith:'#randomorderlist', ...........

January 9, 2018 at 1:42 pm in reply to: sortableRows after Drag and Drop #126565

sagana

Participant

Hi Tony

In grid B I have tried, without success

$dragdropf = &lt;&lt;&lt; DRAGF
jQuery(&#039;#B&#039;).jqGrid(&#039;gridDnD&#039;,
     {connectWith:&#039;#C&#039;,
         ondrop: function(evt, obj, data){
             data.droppedon=evt.target.id;
             data.testid={$id};
             $.ajax({
                method: &quot;POST&quot;,
                url: &quot;ajaxAddLink.php&quot;,
                data: data,
                success: (function(){
                    $(&#039;#C&#039;).trigger( &#039;reloadGrid&#039; );
                    $(&#039;#B&#039;).trigger( &#039;reloadGrid&#039; );
                })
            })
        }        
    }
);
DRAGF;
$grid-&gt;setJSCode($dragdropf); 

$grid-&gt;callGridMethod(&#039;#B&#039;,&#039;sortableRows&#039;);

$dragdropf = <<< DRAGF

jQuery('#B').jqGrid('gridDnD',

{connectWith:'#C',

ondrop: function(evt, obj, data){

data.droppedon=evt.target.id;

data.testid={$id};

$.ajax({

method: "POST",

url: "ajaxAddLink.php",

data: data,

success: (function(){

$('#C').trigger( 'reloadGrid' );

$('#B').trigger( 'reloadGrid' );

})

}

);

DRAGF;

$grid->setJSCode($dragdropf);

$grid->callGridMethod('#B','sortableRows');

It does the same thing of allowing drag from A to B, A to C, B to C and C to B but not allow reordering the rows in B.

Regards
Murray

January 4, 2018 at 6:43 pm in reply to: Save to database ondrop #126544

sagana

Participant

Resolved by using

$dragdropf = &lt;&lt;&lt; DRAGF
jQuery(&#039;#fixedorderlist&#039;).jqGrid(&#039;gridDnD&#039;,{connectWith:&#039;#randomorderlist&#039;,
     ondrop: function(evt, obj, data){
      $.ajax({
          method: &quot;POST&quot;,
          url: &quot;ajaxAddLink.php&quot;,
          data: data
      })
    }
});
DRAGF;
$grid-&gt;setJSCode($dragdropf);

$dragdropf = <<< DRAGF

jQuery('#fixedorderlist').jqGrid('gridDnD',{connectWith:'#randomorderlist',

ondrop: function(evt, obj, data){

$.ajax({

method: "POST",

url: "ajaxAddLink.php",

data: data

})

}

});

DRAGF;

$grid->setJSCode($dragdropf);

January 4, 2018 at 3:41 pm in reply to: setAfterCrudAction not happening #126537

sagana

Participant

Hi Will, thank you for your time on this. I have got it working by using

“cellEdit”=>true, “cellsubmit”=>”remote”, “cellurl”=>”……….php”,

with

$beforesubmit = &lt;&lt;&lt;BEFORESUBMIT
function( rowId, name, val, iRow, iCol ) {
    var cid = $(this).jqGrid(&#039;getCell&#039;, rowId, &#039;CYOTestQuestionID&#039;); 
    return  { candid : cid};
}
BEFORESUBMIT;
$grid-&gt;setGridEvent(&quot;beforeSubmitCell&quot;,$beforesubmit);

$beforesubmit = <<<BEFORESUBMIT

function( rowId, name, val, iRow, iCol ) {

var cid = $(this).jqGrid('getCell', rowId, 'CYOTestQuestionID');

return { candid : cid};

}

BEFORESUBMIT;

$grid->setGridEvent("beforeSubmitCell",$beforesubmit);

January 2, 2018 at 11:12 am in reply to: setAfterCrudAction not happening #126533

sagana

Participant

Hi Will, Compliments of the Season to you. The beforeSubmitCell works well to get the relevant values, however it appears the setAfterCrudAction function is not happening. I have debug on and only see the SELECT statements, no UPDATE.

// Change some property of the field(s) 
$grid-&gt;setColProperty(&quot;CYOQuestionID&quot;, array(&quot;label&quot;=&gt;&quot;QID&quot;, &quot;width&quot;=&gt;30, &quot;sortable&quot;=&gt;true)); 
$grid-&gt;setColProperty(&quot;CYOTestQuestionID&quot;, array(&quot;label&quot;=&gt;&quot;ID&quot;, &quot;width&quot;=&gt;30, &quot;sortable&quot;=&gt;true));
$grid-&gt;setColProperty(&quot;Title&quot;, array(&quot;label&quot;=&gt;&quot;Title&quot;, &quot;width&quot;=&gt;150, &quot;editable&quot;=&gt;false, &quot;sortable&quot;=&gt;true));
$grid-&gt;setColProperty(&quot;CuratorReference&quot;, array(&quot;label&quot;=&gt;&quot;Curator&quot;, &quot;width&quot;=&gt;120, &quot;editable&quot;=&gt;true, &quot;sortable&quot;=&gt;true));
$grid-&gt;setColProperty(&quot;Category&quot;, array(&quot;label&quot;=&gt;&quot;Category&quot;, &quot;width&quot;=&gt;50, &quot;editable&quot;=&gt;true, &quot;sortable&quot;=&gt;true));
$grid-&gt;setColProperty(&quot;TestType&quot;, array(&quot;label&quot;=&gt;&quot;Type&quot;, &quot;width&quot;=&gt;70, &quot;editable&quot;=&gt;true, &quot;edittype&quot;=&gt;&quot;select&quot;, &quot;editoptions&quot;=&gt;array(&quot;value&quot;=&gt;&quot;{$types}&quot;), &quot;search&quot;=&gt;false, &quot;sortable&quot;=&gt;true));
$grid-&gt;setColProperty(&quot;SubTest1&quot;, array(&quot;label&quot;=&gt;&quot;Subtest 1&quot;, &quot;width&quot;=&gt;60, &quot;editable&quot;=&gt;true, &quot;edittype&quot;=&gt;&quot;select&quot;, &quot;editoptions&quot;=&gt;array(&quot;value&quot;=&gt;&quot;{$subtest1}&quot;), &quot;search&quot;=&gt;false, &quot;sortable&quot;=&gt;true)); 
$grid-&gt;setColProperty(&quot;SubTest2&quot;, array(&quot;label&quot;=&gt;&quot;Subtest 2&quot;, &quot;width&quot;=&gt;60, &quot;editable&quot;=&gt;true, &quot;edittype&quot;=&gt;&quot;select&quot;, &quot;editoptions&quot;=&gt;array(&quot;value&quot;=&gt;&quot;{$subtest2}&quot;), &quot;search&quot;=&gt;false, &quot;sortable&quot;=&gt;true));
$grid-&gt;setColProperty(&quot;TestTypeID&quot;, array(&quot;label&quot;=&gt;&quot;Test Type&quot;, &quot;hidden&quot;=&gt;true, &quot;width&quot;=&gt;30, &quot;stype&quot;=&gt;&quot;select&quot;, &quot;searchoptions&quot;=&gt;array(&quot;searchhidden&quot;=&gt;true, &quot;sopt&quot;=&gt;array(&quot;eq&quot;),&quot;value&quot;=&gt;&quot;{$types}&quot;)));
$grid-&gt;setColProperty(&quot;SubTestID&quot;, array(&quot;label&quot;=&gt;&quot;SubTest 1&quot;, &quot;hidden&quot;=&gt;true, &quot;width&quot;=&gt;30, &quot;stype&quot;=&gt;&quot;select&quot;, &quot;searchoptions&quot;=&gt;array(&quot;searchhidden&quot;=&gt;true, &quot;sopt&quot;=&gt;array(&quot;eq&quot;),&quot;value&quot;=&gt;&quot;{$subtest1}&quot;)));
$grid-&gt;setColProperty(&quot;SubTest2ID&quot;, array(&quot;label&quot;=&gt;&quot;SubTest 2&quot;, &quot;hidden&quot;=&gt;true, &quot;width&quot;=&gt;30, &quot;stype&quot;=&gt;&quot;select&quot;, &quot;searchoptions&quot;=&gt;array(&quot;searchhidden&quot;=&gt;true, &quot;sopt&quot;=&gt;array(&quot;eq&quot;),&quot;value&quot;=&gt;&quot;{$subtest2}&quot;)));
$grid-&gt;setColProperty(&quot;tact&quot;, array(&quot;label&quot;=&gt;&quot;Actions&quot;, &quot;width&quot;=&gt;50, &quot;editable&quot;=&gt;false, &quot;search&quot;=&gt;false));

$loadevent = &lt;&lt;&lt;LOADCOMPLETE
function(rowid){
    var ids = jQuery(&quot;#qtlist&quot;).getDataIDs();
    for(var i=0;i&lt;ids.length;i++){
            var rowd = $(&quot;#qtlist&quot;).getRowData(ids<em class="d4pbbc-italic"></em>);
            var cl = ids<em class="d4pbbc-italic"></em>;
            st = &#039;&lt;img src=&quot;../instance/resources/default/images/view_12x12.png&quot; title=&quot;Show question&quot; onclick=&quot;javascript:showQuestion(&#039;+cl+&#039;)&quot; &gt;&lt;/ids&gt;&#039;; 
            jQuery(&quot;#qtlist&quot;).setRowData(ids<em class="d4pbbc-italic"></em>,{tact:st}); 
    }
}
LOADCOMPLETE;

$grid-&gt;setGridEvent(&quot;loadComplete&quot;,$loadevent); 

$beforesubmit = &lt;&lt;&lt;BEFORESUBMIT
function( rowId, name, val, iRow, iCol ) {
    var cid = $(this).jqGrid(&#039;getCell&#039;, rowId, &#039;CYOTestQuestionID&#039;);
    return  { CYOTestQuestionID : cid};
}
BEFORESUBMIT;
$grid-&gt;setGridEvent(&quot;beforeSubmitCell&quot;,$beforesubmit); 

// This command is executed after edit 
$id =  jqGridUtils::GetParam(&#039;id&#039;); 
$cid = jqGridUtils::GetParam(&#039;CYOTestQuestionID&#039;);
$tType = jqGridUtils::GetParam(&#039;TestType&#039;);

$grid-&gt;setAfterCrudAction(&#039;edit&#039;, &quot;UPDATE tr_cyotestquestion SET TestTypeID = ? WHERE CYOTestQuestionID = ?&quot;,array($tType,$cid));

// Change some property of the field(s)

$grid->setColProperty("CYOQuestionID", array("label"=>"QID", "width"=>30, "sortable"=>true));

$grid->setColProperty("CYOTestQuestionID", array("label"=>"ID", "width"=>30, "sortable"=>true));

$grid->setColProperty("Title", array("label"=>"Title", "width"=>150, "editable"=>false, "sortable"=>true));

$grid->setColProperty("CuratorReference", array("label"=>"Curator", "width"=>120, "editable"=>true, "sortable"=>true));

$grid->setColProperty("Category", array("label"=>"Category", "width"=>50, "editable"=>true, "sortable"=>true));

$grid->setColProperty("TestType", array("label"=>"Type", "width"=>70, "editable"=>true, "edittype"=>"select", "editoptions"=>array("value"=>"{$types}"), "search"=>false, "sortable"=>true));

$grid->setColProperty("SubTest1", array("label"=>"Subtest 1", "width"=>60, "editable"=>true, "edittype"=>"select", "editoptions"=>array("value"=>"{$subtest1}"), "search"=>false, "sortable"=>true));

$grid->setColProperty("SubTest2", array("label"=>"Subtest 2", "width"=>60, "editable"=>true, "edittype"=>"select", "editoptions"=>array("value"=>"{$subtest2}"), "search"=>false, "sortable"=>true));

$grid->setColProperty("TestTypeID", array("label"=>"Test Type", "hidden"=>true, "width"=>30, "stype"=>"select", "searchoptions"=>array("searchhidden"=>true, "sopt"=>array("eq"),"value"=>"{$types}")));

$grid->setColProperty("SubTestID", array("label"=>"SubTest 1", "hidden"=>true, "width"=>30, "stype"=>"select", "searchoptions"=>array("searchhidden"=>true, "sopt"=>array("eq"),"value"=>"{$subtest1}")));

$grid->setColProperty("SubTest2ID", array("label"=>"SubTest 2", "hidden"=>true, "width"=>30, "stype"=>"select", "searchoptions"=>array("searchhidden"=>true, "sopt"=>array("eq"),"value"=>"{$subtest2}")));

$grid->setColProperty("tact", array("label"=>"Actions", "width"=>50, "editable"=>false, "search"=>false));

$loadevent = <<<LOADCOMPLETE

function(rowid){

var ids = jQuery("#qtlist").getDataIDs();

for(var i=0;i<ids.length;i++){

var rowd = $("#qtlist").getRowData(ids);

var cl = ids;

st = '<img src="../instance/resources/default/images/view_12x12.png" title="Show question" onclick="javascript:showQuestion('+cl+')" ></ids>';

jQuery("#qtlist").setRowData(ids,{tact:st});

}

LOADCOMPLETE;

$grid->setGridEvent("loadComplete",$loadevent);

$beforesubmit = <<<BEFORESUBMIT

function( rowId, name, val, iRow, iCol ) {

var cid = $(this).jqGrid('getCell', rowId, 'CYOTestQuestionID');

return { CYOTestQuestionID : cid};

}

BEFORESUBMIT;

$grid->setGridEvent("beforeSubmitCell",$beforesubmit);

// This command is executed after edit

$id = jqGridUtils::GetParam('id');

$cid = jqGridUtils::GetParam('CYOTestQuestionID');

$tType = jqGridUtils::GetParam('TestType');

$grid->setAfterCrudAction('edit', "UPDATE tr_cyotestquestion SET TestTypeID = ? WHERE CYOTestQuestionID = ?",array($tType,$cid));

$tType and $cid do contain the correct numbers at this stage. I cannot see how this differs from the examples in the documentation.

Regards
Murray

December 22, 2017 at 2:18 pm in reply to: setAfterCrudAction not happening #126531

sagana

Participant

Is there any way to get data from other columns in a row in which a cell is edited in addition to the rowid and the value of the newly edited cell ?

December 21, 2017 at 4:28 pm in reply to: setAfterCrudAction not happening #126526

sagana

Participant

This is the complete code

&lt;?php
include_once &#039;../includes/jq-config.php&#039;;

// include the jqGrid Class
require_once &quot;../javascript/Guriddo/php/PHPSuito/jqGrid.php&quot;;
// include the PDO driver class
require_once &quot;../javascript/Guriddo/php/PHPSuito/DBdrivers/jqGridPdo.php&quot;;

if(!isset($TestID) ) {
    $TestID = jqGridUtils::GetParam(&#039;id&#039;,&#039;&#039;);
} 
$id = $TestID;
if(!isset($sTypes) ) {
    $sTypes = jqGridUtils::GetParam(&#039;types&#039;,&#039;&#039;);
}
$types = $sTypes;
if(!isset($sSubtest1) ) {
    $sSubtest1 = jqGridUtils::GetParam(&#039;subtest1&#039;,&#039;&#039;);
}
$subtest1 = $sSubtest1;
if(!isset($sSubtest2) ) {
    $sSubtest2 = jqGridUtils::GetParam(&#039;subtest2&#039;,&#039;&#039;);
}
$subtest2 = $sSubtest2;

// Connection to the server
$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);

// Create the jqGrid instance
$grid = new jqGridRender($conn);

// enable debugging
$grid-&gt;debug = true; 

 // the actual query for the grid data
 $grid-&gt;SelectCommand = &quot;SELECT
  tr_cyoquestion.CYOQuestionID,
  tr_cyotestquestion.CYOTestQuestionID,
  tr_cyoquestion.Title,
  tr_cyoquestion.CuratorReference,
  tr_cyocategory.Title AS Category,
  tr_cyotestquestion.TestTypeID,
  tr_cyotestquestion.SubTestID,
  tr_cyotestquestion.SubTest2ID,
  testtype.Name as TestType,
  (SELECT
      subtest.Name AS Name1
    FROM
      subtesttype
      INNER JOIN subtest ON subtesttype.SubTestTypeID =
        subtest.SubTestTypeID
      INNER JOIN test ON test.SubTestTypeID = subtesttype.SubTestTypeID 
      where test.TestID = tr_cyotestquestion.TestID
      and subtest.TestSubTestID = tr_cyotestquestion.SubTestID) as SubTest1,
  (SELECT
      subtest.Name AS Name1
    FROM
      subtesttype
      INNER JOIN subtest ON subtesttype.SubTestTypeID =
        subtest.SubTestTypeID
      INNER JOIN test ON test.SubTestTypeID = subtesttype.SubTestTypeID 
      where test.TestID = tr_cyotestquestion.TestID
      and subtest.TestSubTestID = tr_cyotestquestion.SubTest2ID) as SubTest2
FROM
  tr_cyotestquestion
  INNER JOIN tr_cyoquestion ON tr_cyotestquestion.CYOQuestionID = tr_cyoquestion.CYOQuestionID
  LEFT JOIN tr_cyoquestioncategory ON tr_cyoquestion.CYOQuestionID = tr_cyoquestioncategory.CYOQuestionID
  LEFT JOIN tr_cyocategory ON tr_cyoquestioncategory.CYOCategoryID = tr_cyocategory.CYOCategoryID
  INNER JOIN testtype ON tr_cyotestquestion.TestTypeID = testtype.TestTypeID
WHERE
  tr_cyotestquestion.FixedOrder IS NULL and
  tr_cyotestquestion.TestID = &quot;.$id;

// set the ouput format to json
$grid-&gt;dataType = &#039;json&#039;;

// Let the grid create the model
$grid-&gt;setColModel(null);

// Set the url from where we obtain the data
$grid-&gt;setUrl(&#039;getTestQuestions.php?id=&#039;.$TestID);

// Set some grid options
$grid-&gt;setGridOptions(array(
    &quot;caption&quot;=&gt;&quot;Random Order questions for Test &quot;.$id,
    &quot;rowNum&quot;=&gt;500,
    &quot;sortname&quot;=&gt;&quot;Title&quot;,
    &quot;altRows&quot;=&gt;true,
    &quot;rowList&quot;=&gt;array(500,1000),
    &quot;cellEdit&quot;=&gt;true,
    &quot;height&quot;=&gt;200,
    &quot;width&quot;=&gt;950
    )); 

$grid-&gt;addCol(array(&quot;name&quot;=&gt;&quot;tact&quot;),&quot;last&quot;); 

// Change some property of the field(s)
$grid-&gt;setColProperty(&quot;CYOQuestionID&quot;, array(&quot;label&quot;=&gt;&quot;QID&quot;, &quot;width&quot;=&gt;30, &quot;sortable&quot;=&gt;true));
$grid-&gt;setColProperty(&quot;CYOTestQuestionID&quot;, array(&quot;label&quot;=&gt;&quot;ID&quot;, &quot;width&quot;=&gt;30, &quot;sortable&quot;=&gt;true));
$grid-&gt;setColProperty(&quot;Title&quot;, array(&quot;label&quot;=&gt;&quot;Title&quot;, &quot;width&quot;=&gt;150, &quot;editable&quot;=&gt;false, &quot;sortable&quot;=&gt;true));
$grid-&gt;setColProperty(&quot;CuratorReference&quot;, array(&quot;label&quot;=&gt;&quot;Curator&quot;, &quot;width&quot;=&gt;120, &quot;editable&quot;=&gt;true, &quot;sortable&quot;=&gt;true));
$grid-&gt;setColProperty(&quot;Category&quot;, array(&quot;label&quot;=&gt;&quot;Category&quot;, &quot;width&quot;=&gt;50, &quot;editable&quot;=&gt;true, &quot;sortable&quot;=&gt;true));
$grid-&gt;setColProperty(&quot;TestType&quot;, array(&quot;label&quot;=&gt;&quot;Type&quot;, &quot;width&quot;=&gt;70, &quot;editable&quot;=&gt;true, &quot;edittype&quot;=&gt;&quot;select&quot;, &quot;editoptions&quot;=&gt;array(&quot;value&quot;=&gt;&quot;{$types}&quot;), &quot;search&quot;=&gt;false, &quot;sortable&quot;=&gt;true));
$grid-&gt;setColProperty(&quot;SubTest1&quot;, array(&quot;label&quot;=&gt;&quot;Subtest 1&quot;, &quot;width&quot;=&gt;60, &quot;editable&quot;=&gt;true, &quot;edittype&quot;=&gt;&quot;select&quot;, &quot;editoptions&quot;=&gt;array(&quot;value&quot;=&gt;&quot;{$subtest1}&quot;), &quot;search&quot;=&gt;false, &quot;sortable&quot;=&gt;true)); 
$grid-&gt;setColProperty(&quot;SubTest2&quot;, array(&quot;label&quot;=&gt;&quot;Subtest 2&quot;, &quot;width&quot;=&gt;60, &quot;editable&quot;=&gt;true, &quot;edittype&quot;=&gt;&quot;select&quot;, &quot;editoptions&quot;=&gt;array(&quot;value&quot;=&gt;&quot;{$subtest2}&quot;), &quot;search&quot;=&gt;false, &quot;sortable&quot;=&gt;true));
$grid-&gt;setColProperty(&quot;TestTypeID&quot;, array(&quot;label&quot;=&gt;&quot;Test Type&quot;, &quot;hidden&quot;=&gt;true, &quot;width&quot;=&gt;30, &quot;stype&quot;=&gt;&quot;select&quot;, &quot;searchoptions&quot;=&gt;array(&quot;searchhidden&quot;=&gt;true, &quot;sopt&quot;=&gt;array(&quot;eq&quot;),&quot;value&quot;=&gt;&quot;{$types}&quot;)));
$grid-&gt;setColProperty(&quot;SubTestID&quot;, array(&quot;label&quot;=&gt;&quot;SubTest 1&quot;, &quot;hidden&quot;=&gt;true, &quot;width&quot;=&gt;30, &quot;stype&quot;=&gt;&quot;select&quot;, &quot;searchoptions&quot;=&gt;array(&quot;searchhidden&quot;=&gt;true, &quot;sopt&quot;=&gt;array(&quot;eq&quot;),&quot;value&quot;=&gt;&quot;{$subtest1}&quot;)));
$grid-&gt;setColProperty(&quot;SubTest2ID&quot;, array(&quot;label&quot;=&gt;&quot;SubTest 2&quot;, &quot;hidden&quot;=&gt;true, &quot;width&quot;=&gt;30, &quot;stype&quot;=&gt;&quot;select&quot;, &quot;searchoptions&quot;=&gt;array(&quot;searchhidden&quot;=&gt;true, &quot;sopt&quot;=&gt;array(&quot;eq&quot;),&quot;value&quot;=&gt;&quot;{$subtest2}&quot;)));
$grid-&gt;setColProperty(&quot;tact&quot;, array(&quot;label&quot;=&gt;&quot;Actions&quot;, &quot;width&quot;=&gt;50, &quot;editable&quot;=&gt;false, &quot;search&quot;=&gt;false));

$loadevent = &lt;&lt;&lt;LOADCOMPLETE
function(rowid){
    var ids = jQuery(&quot;#qtlist&quot;).getDataIDs();
    for(var i=0;i&lt;ids.length;i++){
            var rowd = $(&quot;#qtlist&quot;).getRowData(ids<em class="d4pbbc-italic"></em>);
            var cl = ids<em class="d4pbbc-italic"></em>;
            st = &#039;&lt;img src=&quot;../instance/resources/default/images/view_12x12.png&quot; title=&quot;Show question&quot; onclick=&quot;javascript:showQuestion(&#039;+cl+&#039;)&quot; &gt;&lt;/ids&gt;&#039;; 
            jQuery(&quot;#qtlist&quot;).setRowData(ids<em class="d4pbbc-italic"></em>,{tact:st}); 
    }
}
LOADCOMPLETE;

$grid-&gt;setGridEvent(&quot;loadComplete&quot;,$loadevent); 

// This command is executed after edit
$cid = jqGridUtils::GetParam(&#039;CYOTestQuestionID&#039;);
$tType = jqGridUtils::GetParam(&#039;TestType&#039;);
$grid-&gt;setAfterCrudAction(&#039;edit&#039;, &quot;update tr_cyotestquestion set TestTypeID = ? WHERE CYOTestQuestionID=?&quot;,array($tType,$cid));
 
$dragdrop = &lt;&lt;&lt; DRAG
jQuery(&#039;#qavlist&#039;).jqGrid(&#039;gridDnD&#039;,{connectWith:&#039;#qavlist,#qtlist,#qfolist&#039;});
DRAG;
$grid-&gt;setJSCode($dragdrop); 

// Enable navigator
$grid-&gt;navigator = true;
// Disable some actions
$grid-&gt;setNavOptions(&#039;navigator&#039;, array(&quot;excel&quot;=&gt;true,&quot;add&quot;=&gt;false,&quot;edit&quot;=&gt;false,&quot;del&quot;=&gt;false,&quot;view&quot;=&gt;false));  

// Run the script
$grid-&gt;renderGrid(&#039;#qtlist&#039;,&#039;#qtpager&#039;,true, null, null,true,true,true);
$conn = null;

?&gt;

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

<?php

include_once '../includes/jq-config.php';

// include the jqGrid Class

require_once "../javascript/Guriddo/php/PHPSuito/jqGrid.php";

// include the PDO driver class

require_once "../javascript/Guriddo/php/PHPSuito/DBdrivers/jqGridPdo.php";

if(!isset($TestID) ) {

$TestID = jqGridUtils::GetParam('id','');

}

$id = $TestID;

if(!isset($sTypes) ) {

$sTypes = jqGridUtils::GetParam('types','');

}

$types = $sTypes;

if(!isset($sSubtest1) ) {

$sSubtest1 = jqGridUtils::GetParam('subtest1','');

}

$subtest1 = $sSubtest1;

if(!isset($sSubtest2) ) {

$sSubtest2 = jqGridUtils::GetParam('subtest2','');

}

$subtest2 = $sSubtest2;

// Connection to the server

$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);

// Create the jqGrid instance

$grid = new jqGridRender($conn);

// enable debugging

$grid->debug = true;

// the actual query for the grid data

$grid->SelectCommand = "SELECT

tr_cyoquestion.CYOQuestionID,

tr_cyotestquestion.CYOTestQuestionID,

tr_cyoquestion.Title,

tr_cyoquestion.CuratorReference,

tr_cyocategory.Title AS Category,

tr_cyotestquestion.TestTypeID,

tr_cyotestquestion.SubTestID,

tr_cyotestquestion.SubTest2ID,

testtype.Name as TestType,

(SELECT

subtest.Name AS Name1

FROM

subtesttype

INNER JOIN subtest ON subtesttype.SubTestTypeID =

subtest.SubTestTypeID

INNER JOIN test ON test.SubTestTypeID = subtesttype.SubTestTypeID

where test.TestID = tr_cyotestquestion.TestID

and subtest.TestSubTestID = tr_cyotestquestion.SubTestID) as SubTest1,

(SELECT

subtest.Name AS Name1

FROM

subtesttype

INNER JOIN subtest ON subtesttype.SubTestTypeID =

subtest.SubTestTypeID

INNER JOIN test ON test.SubTestTypeID = subtesttype.SubTestTypeID

where test.TestID = tr_cyotestquestion.TestID

and subtest.TestSubTestID = tr_cyotestquestion.SubTest2ID) as SubTest2

FROM

tr_cyotestquestion

INNER JOIN tr_cyoquestion ON tr_cyotestquestion.CYOQuestionID = tr_cyoquestion.CYOQuestionID

LEFT JOIN tr_cyoquestioncategory ON tr_cyoquestion.CYOQuestionID = tr_cyoquestioncategory.CYOQuestionID

LEFT JOIN tr_cyocategory ON tr_cyoquestioncategory.CYOCategoryID = tr_cyocategory.CYOCategoryID

INNER JOIN testtype ON tr_cyotestquestion.TestTypeID = testtype.TestTypeID

WHERE

tr_cyotestquestion.FixedOrder IS NULL and

tr_cyotestquestion.TestID = ".$id;

// set the ouput format to json

$grid->dataType = 'json';

// Let the grid create the model

$grid->setColModel(null);

// Set the url from where we obtain the data

$grid->setUrl('getTestQuestions.php?id='.$TestID);

// Set some grid options

$grid->setGridOptions(array(

"caption"=>"Random Order questions for Test ".$id,

"rowNum"=>500,

"sortname"=>"Title",

"altRows"=>true,

"rowList"=>array(500,1000),

"cellEdit"=>true,

"height"=>200,

"width"=>950

));

$grid->addCol(array("name"=>"tact"),"last");