Guriddo » Topic: Save to database ondrop

Save to database ondrop

Guriddo
Save to database ondrop

This topic has 2 replies, 2 voices, and was last updated 8 years, 3 months ago by tony.

Creator

Topic

January 4, 2018 at 3:49 pm #126538

Participant

I have a page with three grids. I can drag from the top on to the other two. I am trying to get the record dropped into the second grid ‘#qfolist’ to insert a record into the relevant table in the database. In order to do this I am trying to see what data is held in getdata in the function associated with ondrop (which according what I have read should hold the data from the dropped row. Once I have that I will pass it to some php url to do the actual insert. However the code with the ondrop does not seem to be fired. Is my syntax correct please.


&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);

// Set the url from where we obtain the data
$grid-&gt;setUrl(&#039;getTestQuestionsFO.php?id=&#039;.$TestID.&#039;&amp;types=&#039;.$sTypes.&#039;&amp;subtest1=&#039;.$sSubtest1.&#039;&amp;subtest2=&#039;.$sSubtest2); 
// 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 Name2
    FROM
      subtesttype
      INNER JOIN subtest ON subtesttype.SubTestTypeID =
        subtest.SubTestTypeID
      INNER JOIN test ON test.SubTest2TypeID = 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 NOT 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(); 

// Set some grid options
$grid-&gt;setGridOptions(array(
    &quot;caption&quot;=&gt;&quot;Fixed 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;cellsubmit&quot;=&gt;&quot;remote&quot;,
    &quot;cellurl&quot;=&gt;&quot;ajaxUpdateCYOQuestion.php&quot;,
    &quot;height&quot;=&gt;200,
    &quot;width&quot;=&gt;950
    ));

$grid-&gt;addCol(array(&quot;name&quot;=&gt;&quot;fact&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;key&quot;=&gt;true, &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;fact&quot;, array(&quot;label&quot;=&gt;&quot;Actions&quot;, &quot;width&quot;=&gt;50, &quot;search&quot;=&gt;false)); 

//$grid-&gt;setSubGrid(&quot;getQuestionTextFO.php&quot;, array(&#039;Question&#039;), array(860),  array(&#039;left&#039;));

$loadevent = &lt;&lt;&lt;LOADCOMPLETE
function(rowid){
    var ids = jQuery(&quot;#qfolist&quot;).getDataIDs();
    for(var i=0;i&lt;ids.length;i++){
            var rowd = $(&quot;#qfolist&quot;).getRowData(ids<em class="d4pbbc-italic"></em>);
            var cl = ids<em class="d4pbbc-italic"></em>;
            sh = &#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;#qfolist&quot;).setRowData(ids<em class="d4pbbc-italic"></em>,{fact:sh}); 
    }
}
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  { candid : cid};
}
BEFORESUBMIT;
$grid-&gt;setGridEvent(&quot;beforeSubmitCell&quot;,$beforesubmit); 

$grid-&gt;callGridMethod(&#039;#qavlist&#039;,&#039;gridDnD&#039;, array(array(&quot;connectWith&quot;=&gt;&quot;#qavlist,#qfolist,#qtlist&quot;)));

$grid-&gt;callGridMethod(&#039;#qfolist&#039;,&#039;gridDnD&#039;, array(array(&quot;ondrop&quot;=&gt;&quot;function (ev, ui, getdata) { var acceptId = \$(ui.draggable).attr(&#039;id&#039;);}&quot;)));

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

// 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;#qfolist&#039;,&#039;#qfopager&#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

145

146

147

148

149

150

151

152

153

<?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);

// Set the url from where we obtain the data

$grid->setUrl('getTestQuestionsFO.php?id='.$TestID.'&types='.$sTypes.'&subtest1='.$sSubtest1.'&subtest2='.$sSubtest2);

// 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 Name2

FROM

subtesttype

INNER JOIN subtest ON subtesttype.SubTestTypeID =

subtest.SubTestTypeID

INNER JOIN test ON test.SubTest2TypeID = 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 NOT NULL and

tr_cyotestquestion.TestID = ".$id;

// set the ouput format to json

$grid->dataType = 'json';

// Let the grid create the model

$grid->setColModel();

// Set some grid options

$grid->setGridOptions(array(

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

"rowNum"=>500,

"sortname"=>"Title",

"altRows"=>true,

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

"cellEdit"=>true,

"cellsubmit"=>"remote",

"cellurl"=>"ajaxUpdateCYOQuestion.php",

"height"=>200,

"width"=>950

));

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

// Change some property of the field(s)

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

$grid->setColProperty("CYOTestQuestionID", array("label"=>"ID", "key"=>true, "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("fact", array("label"=>"Actions", "width"=>50, "search"=>false));

//$grid->setSubGrid("getQuestionTextFO.php", array('Question'), array(860), array('left'));

$loadevent = <<<LOADCOMPLETE

function(rowid){

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

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

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

var cl = ids;

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

jQuery("#qfolist").setRowData(ids,{fact:sh});

}

LOADCOMPLETE;

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

$beforesubmit = <<<BEFORESUBMIT

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

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

return { candid : cid};

}

BEFORESUBMIT;

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

$grid->callGridMethod('#qavlist','gridDnD', array(array("connectWith"=>"#qavlist,#qfolist,#qtlist")));

$grid->callGridMethod('#qfolist','gridDnD', array(array("ondrop"=>"function (ev, ui, getdata) { var acceptId = \$(ui.draggable).attr('id');}")));

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

// Enable navigator

$grid->navigator = true;

// Disable some actions

$grid->setNavOptions('navigator', array("excel"=>true,"add"=>false,"edit"=>false,"del"=>false,"view"=>false));

// Run the script

$grid->renderGrid('#qfolist','#qfopager',true, null,null,true,true,true);

$conn = null;

Creator

Topic

Viewing 2 replies - 1 through 2 (of 2 total)

Author

Replies

January 4, 2018 at 6:43 pm #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 8, 2018 at 1:42 pm #126555

Save to database ondrop

Search Forum

Recent Replies

Forum Statistics

UserOnline