Guriddo » Snipe656's Replies

Snipe656

Guriddo

Forum Replies Created

Viewing 1 replies (of 1 total)

Author

Replies

January 7, 2014 at 9:01 pm in reply to: How to disable inline editing in a cell based on data in a different cell on same row #101683

Snipe656

Participant

This ended up being the overall solution:

<br />
$(document).ready(function() {<br />
var noteIcon = &#039;<div title="Job Details" style="float:left;margin-left:5px" class="ui-pg-div ui-inline-edit"><span class="ui-icon ui-icon-note"></span></div>&#039;;<br />
<br /><br />
getColumnIndexByName = function(grid,columnName) {<br />
var cm = grid.jqGrid(&#039;getGridParam&#039;,&#039;colModel&#039;);<br />
for (var i=0,l=cm.length; i&lt;l; i++) {<br />
if (cm<i>.name===columnName) {<br />
return i; // return the index<br />
}<br />
}<br />
return -1;<br />
};<br />
<br /><br />
DoDeliveryHolds = function(grid) {<br />
var aryIDS	= $(grid).jqGrid(&#039;getDataIDs&#039;);<br />
<br /><br />
if(aryIDS.length &gt; 0) {<br />
// Add Ajax call to do toggle in database<br />
alert(aryIDS.length);<br />
}<br />
};<br />
<br /><br />
// Here we set the altRows option globallly<br />
jQuery.extend(jQuery.jgrid.defaults, {<br />
altRows:true,<br />
altclass:&#039;myAltRowClass&#039;,<br />
datatype: "json",<br />
jsonReader: {<br />
root: "ROWS",<br />
page: "PAGE",<br />
total: "TOTAL",<br />
records: "RECORDS",<br />
cell: "",<br />
id: "0"<br />
},<br />
emptyrecords: "No jobs to display.",<br />
rowList: [25,50,100],<br />
viewrecords: true,<br />
height: "auto",<br />
loadonce: true,<br />
footerrow: true,<br />
loadComplete: function (data) {<br />
var $self = $(this), i = getColumnIndexByName($self, &#039;action&#039;);<br />
<br /><br />
// nth-child need 1-based index so we use (i+1) below<br />
$("tbody &gt; tr.jqgrow &gt; td:nth-child("+(i+1)+") &gt; div:nth-child(1)",$self[0]).click(function(e) {<br />
var tr=$(e.target,$self[0].rows).closest("tr.jqgrow");<br />
<br /><br />
e.preventDefault();<br />
window.location.href = &#039;CenterView.cfm?table=ORDER_JOBS&amp;ID=&#039; + tr[0].id + &#039;&amp;backurl=%3DJobsInbox%2Ecfm%3FPICK%5FDMS%5FCENTERID%3D15&#039;;<br />
});<br />
<br />
},<br />
colNames: [ "ID", "Delivery Type", "Service Type", "Pre-Commit", "Survey Name", "Client", "Order ID", "Job Number", "Client Reference","Internal Reference", "Type", "Product Name", "Submitted For", "Sales Coordinator", "Order Date", "Requested Date", "Standard Date", "Inbox Date", "Delivery Hold", "Pre-Commit Hold", "Analyst", "&nbsp;", "Actions" ],<br />
colModel: [<br />
{ name: "id", index: "id", hidden: true, key: true },<br />
{ name: "delivery_type", index: "delivery_type", width: 70, formatter:&#039;select&#039;, stype:&#039;select&#039;, edittype:&#039;select&#039;, editoptions: { value: ":All;External Delivery:External Delivery;Internal Data Access:Internal Data Access;Internal Delivery:Internal Delivery" } },<br />
{ name: "service_type", index: "service_type", width: 65, searchoptions:{sopt:[&#039;cn&#039;,&#039;eq&#039;,&#039;bw&#039;,&#039;bn&#039;,&#039;nc&#039;,&#039;ew&#039;,&#039;en&#039;]} },<br />
{ name: "isprecommit", index: "isprecommit", width: 50, align: "center", formatter:&#039;select&#039;, stype:&#039;select&#039;, edittype:&#039;select&#039;, editoptions: { value: ":All;false:No;true:Yes" } },<br />
{ name: "survey_name", index: "survey_name", searchoptions:{sopt:[&#039;cn&#039;,&#039;eq&#039;,&#039;bw&#039;,&#039;bn&#039;,&#039;nc&#039;,&#039;ew&#039;,&#039;en&#039;]}, formatter:&#039;showlink&#039;, formatoptions:{baseLinkUrl:&#039;LinkStation.cfm&#039;, addParam: &#039;&amp;Type=JobsInboxSurvey&amp;PICK_DMS_CENTERID=15&#039;} },<br />
{ name: "corpname", index: "corpname", searchoptions:{sopt:[&#039;cn&#039;,&#039;eq&#039;,&#039;bw&#039;,&#039;bn&#039;,&#039;nc&#039;,&#039;ew&#039;,&#039;en&#039;]}, formatter:&#039;showlink&#039;, formatoptions:{baseLinkUrl:&#039;LinkStation.cfm&#039;, addParam: &#039;&amp;Type=JobsInboxClient&amp;PICK_DMS_CENTERID=15&#039;} },<br />
{ name: "orderid", index: "orderid", width: 40, formatter:&#039;showlink&#039;, formatoptions:{baseLinkUrl:&#039;LinkStation.cfm&#039;, addParam: &#039;&amp;Type=JobsInboxOrder&amp;PICK_DMS_CENTERID=15&#039;}, search:false },<br />
{ name: "jobsnumber", index: "jobsnumber", width: 60, searchoptions:{sopt:[&#039;cn&#039;,&#039;eq&#039;,&#039;bw&#039;,&#039;bn&#039;,&#039;nc&#039;,&#039;ew&#039;,&#039;en&#039;]}, formatter:&#039;showlink&#039;, formatoptions:{baseLinkUrl:&#039;CenterView.cfm&#039;, addParam: &#039;&amp;table=ORDER_JOBS&amp;backurl=%3DJobsInbox%2Ecfm%3FPICK%5FDMS%5FCENTERID%3D15&#039;} },<br />
{ name: "clientref", index: "clientref", width: 60, searchoptions:{sopt:[&#039;cn&#039;,&#039;eq&#039;,&#039;bw&#039;,&#039;bn&#039;,&#039;nc&#039;,&#039;ew&#039;,&#039;en&#039;]} },<br />
{ name: "internal_reference", index: "internal_reference", width: 33, formatter:&#039;select&#039;, stype:&#039;select&#039;, edittype:&#039;select&#039;, editoptions: { value: ":;EOM:EOM;NO GO:NO GO" } },<br />
{ name: "survey_type", index: "survey_type", width: 35, align: "center", formatter:&#039;select&#039;, stype:&#039;select&#039;, edittype:&#039;select&#039;, editoptions: { value: ":All;2D:2D;3D:3D" } },<br />
{ name: "product_name", index: "product_name", searchoptions:{sopt:[&#039;cn&#039;,&#039;eq&#039;,&#039;bw&#039;,&#039;bn&#039;,&#039;nc&#039;,&#039;ew&#039;,&#039;en&#039;]} },<br />
{ name: "submitted_for", index: "submitted_for", width: 70, searchoptions:{sopt:[&#039;cn&#039;,&#039;eq&#039;,&#039;bw&#039;,&#039;bn&#039;,&#039;nc&#039;,&#039;ew&#039;,&#039;en&#039;]} },<br />
{ name: "sales_coordinator", index: "sales_coordinator", width: 70, searchoptions:{sopt:[&#039;cn&#039;,&#039;eq&#039;,&#039;bw&#039;,&#039;bn&#039;,&#039;nc&#039;,&#039;ew&#039;,&#039;en&#039;]} },<br />
{ name: "order_date", index: "order_date", width: 50, align: "center", search:false, datefmt: &#039;mm/dd/yy&#039; },<br />
{ name: "requested_date", index: "requested_date", width: 50, align: "center", search:false, datefmt: &#039;mm/dd/yy&#039; },<br />
{ name: "dt_standard", index: "dt_standard", width: 50, align: "center", search:false, datefmt: &#039;mm/dd/yy&#039; },<br />
{ name: "inbox_date", index: "inbox_date", width: 50, align: "center", search:false, datefmt: &#039;mm/dd/yy&#039; },<br />
{ name: "isdeliveryhold", index: "isdeliveryhold", sortable: true, search: true, width: 50, align: "center", formatter:&#039;select&#039;, stype:&#039;select&#039;, editable:true, edittype:&#039;select&#039;, editoptions: { value: ":;false:No;true:Yes" } },<br />
{ name: "isprecommithold", index: "isprecommithold", sortable: true, search: true, width: 50, align: "center", formatter:&#039;select&#039;, stype:&#039;select&#039;, editable:true, edittype:&#039;select&#039;, editoptions: { value: ":;false:No;true:Yes" } },<br />
{ name: "analyst", index: "analyst", width: 115, align: "center", sortable: true, search: true, formatter:&#039;select&#039;, stype:&#039;select&#039;, editable:true, edittype:&#039;select&#039;, editoptions: { value: ":;michael-19810202:Mike Hares;sara-20061004:Sara Kathleen Lampman" } },<br />
{ name: &#039;action&#039;, index: &#039;action&#039;, sortable: false, search: false, width: 25, formatter: function() { return noteIcon; } },<br />
{ name: "act", index: "act", width: 55, align: "center", sortable: false, search:false, formatter: "actions",<br />
formatoptions: {<br />
keys: true, delbutton: false, afterSave: function() { $(this).jqGrid(&#039;setGridParam&#039;, {datatype:&#039;json&#039;}); $(this).trigger(&#039;reloadGrid&#039;, [{page:1}]); }<br />
}<br />
}<br />
],<br />
editurl: "Components/JobsInbox.cfc?method=SetJobUpdate&amp;UPDATEDBY=aaron-20040630",<br />
afterInsertRow:<br />
function(rowid, aData){<br />
if(aData.isdeliveryhold) {<br />
$(this).setCell(rowid,"isdeliveryhold","",{"background":"#FF6A6A"});<br />
}<br />
}<br />
});<br />
<br /><br />
$(&#039;#Jobs&#039;).jqGrid({<br />
url: "Components/JobsInbox.cfc?method=GetJobGrid&amp;PICK_DMS_CENTERID=15&amp;CFDateFormat=MM/DD/YY",<br />
caption: "Jobs Inbox",<br />
pager: $(&#039;#JobsPager&#039;)<br />
});<br />
$(&#039;#Jobs&#039;).jqGrid(&#039;filterToolbar&#039;, { searchOperators: false, ignoreCase: true });<br />
$(&#039;#Jobs&#039;).jqGrid(&#039;navGrid&#039;, &#039;#JobsPager&#039;, { add: false, edit: false, del: false, refresh: false });<br />
$(&#039;#Jobs&#039;).jqGrid(&#039;navButtonAdd&#039;, &#039;#JobsPager&#039;, { caption: "", buttonicon: "ui-icon-refresh", title: $.jgrid.nav.refreshtitle, onClickButton: function() { $(this).jqGrid(&#039;setGridParam&#039;, {datatype:&#039;json&#039;}); $(this).trigger(&#039;reloadGrid&#039;, [{page:1}]); } });<br />
$(&#039;#Jobs&#039;).jqGrid(&#039;navButtonAdd&#039;, &#039;#JobsPager&#039;, { caption: "Toggle Delivery Holds", buttonicon: "ui-icon-pencil", onClickButton: function() { var str = confirm("Toggle the Delivery Hold for all displayed Jobs?"); if(str) { DoDeliveryHolds($(this)); } } });<br />
<br /><br />
var orgRowActions = $.fn.fmatter.rowactions;<br />
$.fn.fmatter.rowactions = function (act) {<br />
var $tr = $(this).closest("tr.jqgrow"),<br />
rid = $tr.attr("id"),<br />
$grid = $(this).closest("table.ui-jqgrid-btable"),<br />
rowData = $grid.jqGrid("getLocalRow", rid),<br />
isNonEditable = false,<br />
result;<br />
<br /><br />
// editable property of any column<br />
if (act === "edit" &amp;&amp; rowData.isprecommit == false) {<br />
$grid.jqGrid("setColProp", "isprecommithold", {editable: false});<br />
isNonEditable = true;<br />
}<br />
result = orgRowActions.call(this, act);<br />
if (isNonEditable) {<br />
// reset the setting to original state<br />
$grid.jqGrid("setColProp", "isprecommithold", {editable: true});<br />
}<br />
return result;<br />
}<br />
<br /><br />
});<br />
<br />
<br /><br />
&lt;style type=&quot;<a class="attribute-value" target="_blank" rel="nofollow">text/css</a>"&gt;<br />
.myAltRowClass { background-color: #ECF6FC; background-image: none; }<br />
<br /><br />
/* Wrap in header cell */<br />
.ui-jqgrid .ui-jqgrid-htable th div {<br />
height:auto;<br />
overflow:hidden;<br />
padding-right:4px;<br />
padding-top:2px;<br />
position:relative;<br />
vertical-align:text-top;<br />
white-space:normal !important;<br />
}<br />
<br /><br />
/* Wrap in table cell */<br />
.ui-jqgrid tr.jqgrow td {<br />
white-space: normal !important;<br />
height:auto;<br />
vertical-align:text-top;<br />
padding-top:2px;<br />
}<br />
<br /><br />
span.cellWithoutBackground {<br />
display:block;<br />
background-image:none;<br />
margin-right:-2px;<br />
margin-left:-2px;<br />
height:14px;<br />
padding:4px;<br />
}<br />
</i>

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

154

155

156

157

158

159

$(document).ready(function() {

var noteIcon = '<div title="Job Details" style="float:left;margin-left:5px" class="ui-pg-div ui-inline-edit"></div>';

getColumnIndexByName = function(grid,columnName) {

var cm = grid.jqGrid('getGridParam','colModel');

for (var i=0,l=cm.length; i<l; i++) {

if (cm.name===columnName) {

return i; // return the index

}

return -1;

};

DoDeliveryHolds = function(grid) {

var aryIDS = $(grid).jqGrid('getDataIDs');

if(aryIDS.length > 0) {

// Add Ajax call to do toggle in database

alert(aryIDS.length);

}

};

// Here we set the altRows option globallly

jQuery.extend(jQuery.jgrid.defaults, {

altRows:true,

altclass:'myAltRowClass',

datatype: "json",

jsonReader: {

root: "ROWS",

page: "PAGE",

total: "TOTAL",

records: "RECORDS",

cell: "",

id: "0"

},

emptyrecords: "No jobs to display.",

rowList: [25,50,100],

viewrecords: true,

height: "auto",

loadonce: true,

footerrow: true,

loadComplete: function (data) {

var $self = $(this), i = getColumnIndexByName($self, 'action');

// nth-child need 1-based index so we use (i+1) below

$("tbody > tr.jqgrow > td:nth-child("+(i+1)+") > div:nth-child(1)",$self[0]).click(function(e) {

var tr=$(e.target,$self[0].rows).closest("tr.jqgrow");

e.preventDefault();

window.location.href = 'CenterView.cfm?table=ORDER_JOBS&ID=' + tr[0].id + '&backurl=%3DJobsInbox%2Ecfm%3FPICK%5FDMS%5FCENTERID%3D15';

});

},

colNames: [ "ID", "Delivery Type", "Service Type", "Pre-Commit", "Survey Name", "Client", "Order ID", "Job Number", "Client Reference","Internal Reference", "Type", "Product Name", "Submitted For", "Sales Coordinator", "Order Date", "Requested Date", "Standard Date", "Inbox Date", "Delivery Hold", "Pre-Commit Hold", "Analyst", " ", "Actions" ],

colModel: [

{ name: "id", index: "id", hidden: true, key: true },

{ name: "delivery_type", index: "delivery_type", width: 70, formatter:'select', stype:'select', edittype:'select', editoptions: { value: ":All;External Delivery:External Delivery;Internal Data Access:Internal Data Access;Internal Delivery:Internal Delivery" } },

{ name: "service_type", index: "service_type", width: 65, searchoptions:{sopt:['cn','eq','bw','bn','nc','ew','en']} },

{ name: "isprecommit", index: "isprecommit", width: 50, align: "center", formatter:'select', stype:'select', edittype:'select', editoptions: { value: ":All;false:No;true:Yes" } },

{ name: "survey_name", index: "survey_name", searchoptions:{sopt:['cn','eq','bw','bn','nc','ew','en']}, formatter:'showlink', formatoptions:{baseLinkUrl:'LinkStation.cfm', addParam: '&Type=JobsInboxSurvey&PICK_DMS_CENTERID=15'} },

{ name: "corpname", index: "corpname", searchoptions:{sopt:['cn','eq','bw','bn','nc','ew','en']}, formatter:'showlink', formatoptions:{baseLinkUrl:'LinkStation.cfm', addParam: '&Type=JobsInboxClient&PICK_DMS_CENTERID=15'} },

{ name: "orderid", index: "orderid", width: 40, formatter:'showlink', formatoptions:{baseLinkUrl:'LinkStation.cfm', addParam: '&Type=JobsInboxOrder&PICK_DMS_CENTERID=15'}, search:false },

{ name: "jobsnumber", index: "jobsnumber", width: 60, searchoptions:{sopt:['cn','eq','bw','bn','nc','ew','en']}, formatter:'showlink', formatoptions:{baseLinkUrl:'CenterView.cfm', addParam: '&table=ORDER_JOBS&backurl=%3DJobsInbox%2Ecfm%3FPICK%5FDMS%5FCENTERID%3D15'} },

{ name: "clientref", index: "clientref", width: 60, searchoptions:{sopt:['cn','eq','bw','bn','nc','ew','en']} },

{ name: "internal_reference", index: "internal_reference", width: 33, formatter:'select', stype:'select', edittype:'select', editoptions: { value: ":;EOM:EOM;NO GO:NO GO" } },

{ name: "survey_type", index: "survey_type", width: 35, align: "center", formatter:'select', stype:'select', edittype:'select', editoptions: { value: ":All;2D:2D;3D:3D" } },

{ name: "product_name", index: "product_name", searchoptions:{sopt:['cn','eq','bw','bn','nc','ew','en']} },

{ name: "submitted_for", index: "submitted_for", width: 70, searchoptions:{sopt:['cn','eq','bw','bn','nc','ew','en']} },

{ name: "sales_coordinator", index: "sales_coordinator", width: 70, searchoptions:{sopt:['cn','eq','bw','bn','nc','ew','en']} },

{ name: "order_date", index: "order_date", width: 50, align: "center", search:false, datefmt: 'mm/dd/yy' },

{ name: "requested_date", index: "requested_date", width: 50, align: "center", search:false, datefmt: 'mm/dd/yy' },

{ name: "dt_standard", index: "dt_standard", width: 50, align: "center", search:false, datefmt: 'mm/dd/yy' },

{ name: "inbox_date", index: "inbox_date", width: 50, align: "center", search:false, datefmt: 'mm/dd/yy' },

{ name: "isdeliveryhold", index: "isdeliveryhold", sortable: true, search: true, width: 50, align: "center", formatter:'select', stype:'select', editable:true, edittype:'select', editoptions: { value: ":;false:No;true:Yes" } },

{ name: "isprecommithold", index: "isprecommithold", sortable: true, search: true, width: 50, align: "center", formatter:'select', stype:'select', editable:true, edittype:'select', editoptions: { value: ":;false:No;true:Yes" } },

{ name: "analyst", index: "analyst", width: 115, align: "center", sortable: true, search: true, formatter:'select', stype:'select', editable:true, edittype:'select', editoptions: { value: ":;michael-19810202:Mike Hares;sara-20061004:Sara Kathleen Lampman" } },

{ name: 'action', index: 'action', sortable: false, search: false, width: 25, formatter: function() { return noteIcon; } },

{ name: "act", index: "act", width: 55, align: "center", sortable: false, search:false, formatter: "actions",

formatoptions: {

keys: true, delbutton: false, afterSave: function() { $(this).jqGrid('setGridParam', {datatype:'json'}); $(this).trigger('reloadGrid', [{page:1}]); }

}

],

editurl: "Components/JobsInbox.cfc?method=SetJobUpdate&UPDATEDBY=aaron-20040630",

afterInsertRow:

function(rowid, aData){

if(aData.isdeliveryhold) {

$(this).setCell(rowid,"isdeliveryhold","",{"background":"#FF6A6A"});

}

});

$('#Jobs').jqGrid({

url: "Components/JobsInbox.cfc?method=GetJobGrid&PICK_DMS_CENTERID=15&CFDateFormat=MM/DD/YY",

caption: "Jobs Inbox",

pager: $('#JobsPager')

});

$('#Jobs').jqGrid('filterToolbar', { searchOperators: false, ignoreCase: true });

$('#Jobs').jqGrid('navGrid', '#JobsPager', { add: false, edit: false, del: false, refresh: false });

$('#Jobs').jqGrid('navButtonAdd', '#JobsPager', { caption: "", buttonicon: "ui-icon-refresh", title: $.jgrid.nav.refreshtitle, onClickButton: function() { $(this).jqGrid('setGridParam', {datatype:'json'}); $(this).trigger('reloadGrid', [{page:1}]); } });

$('#Jobs').jqGrid('navButtonAdd', '#JobsPager', { caption: "Toggle Delivery Holds", buttonicon: "ui-icon-pencil", onClickButton: function() { var str = confirm("Toggle the Delivery Hold for all displayed Jobs?"); if(str) { DoDeliveryHolds($(this)); } } });

var orgRowActions = $.fn.fmatter.rowactions;

$.fn.fmatter.rowactions = function (act) {

var $tr = $(this).closest("tr.jqgrow"),

rid = $tr.attr("id"),

$grid = $(this).closest("table.ui-jqgrid-btable"),

rowData = $grid.jqGrid("getLocalRow", rid),

isNonEditable = false,

result;

// editable property of any column

if (act === "edit" && rowData.isprecommit == false) {

$grid.jqGrid("setColProp", "isprecommithold", {editable: false});

isNonEditable = true;

}

result = orgRowActions.call(this, act);

if (isNonEditable) {

// reset the setting to original state

$grid.jqGrid("setColProp", "isprecommithold", {editable: true});

}

return result;

}

});

.myAltRowClass { background-color: #ECF6FC; background-image: none; }

/* Wrap in header cell */

.ui-jqgrid .ui-jqgrid-htable th div {

height:auto;

overflow:hidden;

padding-right:4px;

padding-top:2px;

position:relative;

vertical-align:text-top;

white-space:normal !important;

}

/* Wrap in table cell */

.ui-jqgrid tr.jqgrow td {

white-space: normal !important;

height:auto;

vertical-align:text-top;

padding-top:2px;

}

span.cellWithoutBackground {

display:block;

background-image:none;

margin-right:-2px;

margin-left:-2px;

height:14px;

padding:4px;

}

Author

Replies

Viewing 1 replies (of 1 total)