Guriddo » wexwell's Replies

wexwell

Guriddo

Forum Replies Created

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

Author

Replies

September 23, 2014 at 9:53 pm in reply to: can only click bottom row in grid as sub grid #102287

wexwell

Participant

Evidently the grid will not track row numbers as ID’s independently, even after turning row numbers on this would not work. I had to add the following code to make it work; key:true.

{name:"date",width:28, key:true},

1	{name:"date",width:28, key:true},

September 20, 2014 at 12:03 am in reply to: filter dropdown from another dropdown #102283

wexwell

Participant

bump – I still have not been able to find a working example if anybody has any suggestions.

September 9, 2014 at 4:46 pm in reply to: How to Paginate please #102248

wexwell

Participant

This is what you are returning with your code;

"total": 91,<br />
Â  "per_page": 10,<br />
Â  "current_page": 1,<br />
Â  "last_page": 10,<br />
Â  "from": 1,<br />
Â  "to": 10,<br />
Â  "data": [

"total": 91,

Â "per_page": 10,

Â "current_page": 1,

Â "last_page": 10,

Â "from": 1,

Â "to": 10,

Â "data": [

If you would have actually compared to what I was sending you would have noticed your parameters are not set correctly for pagination to work.Â One example – total is the total number of pages (the way I set it), you are setting it to the total number of records. The parameter I am setting (note – I didn’t simply name my own I set them according to the documentation) for the current page is simply ‘page’, you are using current_page. If you analyze and adapt what I posted, or read the documentation on naming conventions, you should have no problem getting it to work.

September 8, 2014 at 8:18 pm in reply to: Cannot get search icon to appear… #102245

wexwell

Participant

you’re welcome…

September 8, 2014 at 7:43 pm in reply to: Search toolbar hide by default #102244

wexwell

Participant

I over complicated this response and ended up simply wasting time when the solution was exactly as you stated. Code is posted below;

Â Â Â Â Â Â Â Â Â

Â Â  Â Â Â  Â Â Â  Â $('#grid').jqGrid('navButtonAdd', '#pager', {<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  caption: "",<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  title: "Toggle Search Toolbar",<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  buttonicon: 'ui-icon-search',<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  onClickButton: function () {<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  this.toggleToolbar();<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  if ($.isFunction(this.p._complete)) {<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  if ($('.ui-search-toolbar', this.grid.hDiv).is(':visible'))<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â Â Â  Â Â Â  Â {<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â Â Â  Â Â Â  Â Â Â  Â <br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  $('.ui-search-toolbar', this.grid.fhDiv).show();<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  } else {<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  $('.ui-search-toolbar', this.grid.fhDiv).hide();<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  }<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  this.p._complete.call(this);<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  fixPositionsOfFrozenDivs.call(this);<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  }<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  }<br />
Â Â Â Â Â Â Â Â Â Â Â  });<br />
Â Â  Â Â Â  Â Â Â  Â $('.ui-search-toolbar').hide();

Â Â Â Â Â Â Â Â Â $('#grid').jqGrid('navButtonAdd', '#pager', {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â caption: "",

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â title: "Toggle Search Toolbar",

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â buttonicon: 'ui-icon-search',

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â onClickButton: function () {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this.toggleToolbar();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ($.isFunction(this.p._complete)) {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ($('.ui-search-toolbar', this.grid.hDiv).is(':visible'))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â $('.ui-search-toolbar', this.grid.fhDiv).show();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â } else {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â $('.ui-search-toolbar', this.grid.fhDiv).hide();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this.p._complete.call(this);

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â fixPositionsOfFrozenDivs.call(this);

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â });

Â Â Â Â Â Â Â Â Â $('.ui-search-toolbar').hide();

September 5, 2014 at 10:22 pm in reply to: Cannot get search icon to appear… #102224

wexwell

Participant

Fixed, FINALLY!Â I had to locate the nav bar inside of the closing }); as noted below…

Â Â Â

 jQuery(document).ready(function()<br />
Â Â  Â Â Â  Â { jQuery("#grid").jqGrid({<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â url: "getinfo.php",<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â datatype: "json",<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â mtype: 'POST',<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â autowidth: true,<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â height: 330,<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â colNames: ["Name", "Num", "Field", "Pad", "API", "Legal", "County, State",<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â Â Â  Â "Lease", "Unit CA PA", "Status", "Updated", "Wildlife Stips", "Notes"],<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â colModel: [<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â Â Â  Â { name: "well_name", width: 48,sortable: true, search:true},<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â Â Â  Â { name: "well_num", width: 18,sortable: true},<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â Â Â  Â { name: "field", width: 48,sortable: true, search:true},<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â Â Â  Â ...<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â ],<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â rowNum:10,<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â rowList:[10,25,50,10000],<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â pager : '#pager',<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â sortname: 'field',<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â viewrecords: true,<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â rownumbers: true,<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â gridview: true,<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â sortorder: "asc",<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â caption:"Master Well List Maintenance"<br />
Â Â  Â Â Â  Â Â Â  Â  });<br />
Â Â  Â Â Â  Â Â Â  Â jQuery("#grid").jqGrid('navGrid','#pager',<br />
Â Â  Â Â Â  Â Â Â  Â {<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â view: true,<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â del: false,<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â add: true,<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â edit: true,<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â search: true,<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â refresh: true<br />
Â Â  Â Â Â  Â Â Â  Â },<br />
Â Â  Â Â Â  Â Â Â  Â { /*prmEdit*/ },<br />
Â Â  Â Â Â  Â Â Â  Â { /*prmAdd*/ },<br />
Â Â  Â Â Â  Â Â Â  Â { /*prmDel*/ } ,<br />
Â Â  Â Â Â  Â Â Â  Â {<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â /*prmSearch*/<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â multipleSearch:true<br />
Â Â  Â Â Â  Â Â Â  Â },<br />
Â Â  Â Â Â  Â Â Â  Â { /*prmView*/ }<br />
Â Â  Â Â Â  Â Â Â  Â );<br />
Â Â  Â Â Â  Â });

jQuery(document).ready(function()

Â Â Â Â Â Â { jQuery("#grid").jqGrid({

Â Â Â Â Â Â Â Â Â Â Â Â url: "getinfo.php",

Â Â Â Â Â Â Â Â Â Â Â Â datatype: "json",

Â Â Â Â Â Â Â Â Â Â Â Â mtype: 'POST',

Â Â Â Â Â Â Â Â Â Â Â Â autowidth: true,

Â Â Â Â Â Â Â Â Â Â Â Â height: 330,

Â Â Â Â Â Â Â Â Â Â Â Â colNames: ["Name", "Num", "Field", "Pad", "API", "Legal", "County, State",

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â "Lease", "Unit CA PA", "Status", "Updated", "Wildlife Stips", "Notes"],

Â Â Â Â Â Â Â Â Â Â Â Â colModel: [

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â { name: "well_name", width: 48,sortable: true, search:true},

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â { name: "well_num", width: 18,sortable: true},

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â { name: "field", width: 48,sortable: true, search:true},

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â ...

Â Â Â Â Â Â Â Â Â Â Â Â ],

Â Â Â Â Â Â Â Â Â Â Â Â rowNum:10,

Â Â Â Â Â Â Â Â Â Â Â Â rowList:[10,25,50,10000],

Â Â Â Â Â Â Â Â Â Â Â Â pager : '#pager',

Â Â Â Â Â Â Â Â Â Â Â Â sortname: 'field',

Â Â Â Â Â Â Â Â Â Â Â Â viewrecords: true,

Â Â Â Â Â Â Â Â Â Â Â Â rownumbers: true,

Â Â Â Â Â Â Â Â Â Â Â Â gridview: true,

Â Â Â Â Â Â Â Â Â Â Â Â sortorder: "asc",

Â Â Â Â Â Â Â Â Â Â Â Â caption:"Master Well List Maintenance"

Â Â Â Â Â Â Â Â Â });

Â Â Â Â Â Â Â Â Â jQuery("#grid").jqGrid('navGrid','#pager',

Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â view: true,

Â Â Â Â Â Â Â Â Â Â Â Â del: false,

Â Â Â Â Â Â Â Â Â Â Â Â add: true,

Â Â Â Â Â Â Â Â Â Â Â Â edit: true,

Â Â Â Â Â Â Â Â Â Â Â Â search: true,

Â Â Â Â Â Â Â Â Â Â Â Â refresh: true

Â Â Â Â Â Â Â Â Â },

Â Â Â Â Â Â Â Â Â { /*prmEdit*/ },

Â Â Â Â Â Â Â Â Â { /*prmAdd*/ },

Â Â Â Â Â Â Â Â Â { /*prmDel*/ } ,

Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â /*prmSearch*/

Â Â Â Â Â Â Â Â Â Â Â Â multipleSearch:true

Â Â Â Â Â Â Â Â Â },

Â Â Â Â Â Â Â Â Â { /*prmView*/ }

Â Â Â Â Â Â Â Â Â );

Â Â Â Â Â Â });

Â

September 5, 2014 at 5:30 pm in reply to: How to Paginate please #102222

wexwell

Participant

Mine works fine and this is what I am sending back (and how I am sending it). I doubt my queries will do much good, I’m using mssql.

$page = $_POST;<br />
$rows = $_POST;<br />
<br />
$data=$rowcnt;<br />
$data=$page;<br />
$data=$rowcnt/$rows;<br />
$data=$result; //this is the data set from the query<br />
echo json_encode($data);

$page = $_POST;

$rows = $_POST;

$data=$rowcnt;

$data=$page;

$data=$rowcnt/$rows;

$data=$result; //this is the data set from the query

echo json_encode($data);

Author

Replies

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