Guriddo » Topic: pager_left width is not set correctly

pager_left width is not set correctly

Guriddo
pager left
pager_left width is not set correctly

Tagged: pager left

This topic has 10 replies, 3 voices, and was last updated 11 years ago by guriddo.support.

Creator

Topic
March 8, 2010 at 10:35 pm #75703

tjones1105
Participant

Hello,

I'm having a weird issue. The pager, id=”pager_left” has a style assigned with a width of “66px;”.
Creator

Topic

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

Author

Replies

March 9, 2010 at 2:07 am #93205

tjones1105

Participant

I figured it out. It's because of the first column width and it being hidden.

tom

April 9, 2015 at 10:55 pm #123720

Chris

Participant

I actually have this happening on my grids since upgrading to 4.8! But although it is happening on some that have a hidden column it is happening on others that do not have a hidden column.

Is there an answer to this?

April 10, 2015 at 9:30 am #123722

guriddo.support

Participant

Hello,

Just for the case – can you please post a simple test case which demonstrates the problem.

We look seriously on every bug connected with the grid.

Thank you.

Kind Regards,

Will

Guriddo Support Team

April 10, 2015 at 10:36 am #123726

Chris

Participant

Here are two pictures – the first with the paging in the centre of the pager bottom bar and second with the paging to the left. The effect is the icons for pdf export overlap the paging buttons. When you go to click on the PDF export you get the paging instead. The reason for this is the td#pager_left html tag as a style added to it of style=”width: xxxpx”. When it is working OK there is no style added – so not sure what determines there the style width is added or not?

Picture of wrong paging position

Picture of correct paging position

Here is very simple example code of the origin grid display that is not working properly…

&lt;?php 
$mode = &#039;&#039;;
$type = &#039;&#039;;
$query = &quot;&quot;;
// Create tag query initial select statement fro all conditions
$report_name = &quot;Admin: Origins&quot;; // Set heading description
include &#039;include/tag_header.php&#039;;  
   ?&gt;       
           &lt;div id=&quot;grid_div&quot;&gt; &lt;!--  start of jquerygrid --&gt;   
           &lt;?php 
           
           $_SESSION[&#039;query_type&#039;]=&quot;origin_list&quot;;
           $_SESSION[&#039;grid_query&#039;]=&#039;SELECT *
           FROM tag_origins 
           where company_id = &#039;.$_SESSION[&#039;company_id&#039;];
         //  $_SESSION[&#039;grid_query&#039;] = &quot;select ID, Name, Type, Location, GPS_long, GPS_lat, status from tags where Company = &quot;.$_SESSION[&#039;company_id&#039;].$com_list;
           include (&#039;./services/jqgrid/admin/origin_list_grid.php&#039;);
           ?&gt;           
            &lt;/div&gt;   &lt;!--end of jquerygrid  --&gt;                           
    
&lt;/form&gt;
    
&lt;/div&gt;&lt;!--right panel End--&gt;
  
&lt;/div&gt;&lt;!--Container End--&gt;
&lt;/div&gt;&lt;!--wrapper End--&gt;
&lt;/body&gt;
&lt;/html&gt;

<?php

$mode = '';

$type = '';

$query = "";

// Create tag query initial select statement fro all conditions

$report_name = "Admin: Origins"; // Set heading description

include 'include/tag_header.php';

<?php

$_SESSION['query_type']="origin_list";

$_SESSION['grid_query']='SELECT *

FROM tag_origins

where company_id = '.$_SESSION['company_id'];

// $_SESSION['grid_query'] = "select ID, Name, Type, Location, GPS_long, GPS_lat, status from tags where Company = ".$_SESSION['company_id'].$com_list;

include ('./services/jqgrid/admin/origin_list_grid.php');

</div>

</form>

</div>

</div>

</div>

</body>

</html>


&lt;!--?php  ini_set(&#039;display_errors&#039;, &#039;on&#039;); error_reporting(E_ALL); if (!isset($_SESSION[&#039;grid_query&#039;])) { 	session_start(); } $_SESSION[&#039;user_type&#039;]==3 ? $editable=false : $editable = true; include __DIR__ . &#039;/../../../include/jq-config.php&#039;; $conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD); $conn---&gt;query(&quot;SET NAMES utf8&quot;);
// Create the jqGrid instance
$conn-&gt;setAttribute( PDO::ATTR_EMULATE_PREPARES, false );
$conn-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$grid = new jqGridRender($conn);
// Set the SQL Data source
$grid-&gt;SelectCommand = $_SESSION[&#039;grid_query&#039;];
// passed by calling page
// set the ouput format to json
$grid-&gt;serialKey = true;
$grid-&gt;setPrimaryKeyId(&#039;ID&#039;);
$grid-&gt;dataType = &#039;json&#039;;
// Let the grid create the model
$grid-&gt;table = &#039;tag_origins&#039;; // define the tabel used for deleting
$grid-&gt;setColModel();
$grid-&gt;setUserDate(&quot;d-m-Y&quot;);
// set labels in the header

/* Below will differ based on the type of report being executed*/
/* To be included so can set right columns settings for the query*/

$grid-&gt;exportfile = &#039;ZipNFC_tag_origins.xls&#039;;
$grid-&gt;setGridOptions(array(
&quot;rowNum&quot;=&gt;30,
&quot;rowList&quot;=&gt;array(10,20,30,50),
&quot;sortname&quot;=&gt;&quot;Name&quot;,
&quot;sortorder&quot;=&gt;&quot;ASC&quot;,
&quot;hoverrows&quot;=&gt;true,
&quot;toppager&quot;=&gt;true
));

$grid-&gt;toolbarfilter = true;
$grid-&gt;navigator = true;
$grid-&gt;setNavOptions(&#039;navigator&#039;, array(&quot;excel&quot;=&gt;true,&quot;pdf&quot;=&gt;true, &quot;add&quot;=&gt;$editable,&quot;edit&quot;=&gt;$editable,&quot;del&quot;=&gt;false,&quot;view&quot;=&gt;true,&quot;cloneToTop&quot;=&gt;true));
$grid-&gt;setUrl(&quot;./services/jqgrid/admin/origin_list_grid.php&quot;);
$grid-&gt;setColProperty(&#039;ID&#039;, array(&quot;hidden&quot;=&gt;true));
$grid-&gt;setColProperty(
&#039;company_id&#039;, array(&quot;hidden&quot;=&gt;true,
&quot;editoptions&quot;=&gt;array(&quot;defaultValue&quot;=&gt;$_SESSION[&#039;company_id&#039;])));

// End of bespoke JS function
// Enjoy
$grid-&gt;renderGrid(&#039;#grid&#039;,&#039;#pager&#039;,true, null, null, true,true);
$conn = null;
?&gt;

query("SET NAMES utf8");

// Create the jqGrid instance

$conn->setAttribute( PDO::ATTR_EMULATE_PREPARES, false );

$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$grid = new jqGridRender($conn);

// Set the SQL Data source

$grid->SelectCommand = $_SESSION['grid_query'];

// passed by calling page

// set the ouput format to json

$grid->serialKey = true;

$grid->setPrimaryKeyId('ID');

$grid->dataType = 'json';

// Let the grid create the model

$grid->table = 'tag_origins'; // define the tabel used for deleting

$grid->setColModel();

$grid->setUserDate("d-m-Y");

// set labels in the header

/* Below will differ based on the type of report being executed*/

/* To be included so can set right columns settings for the query*/

$grid->exportfile = 'ZipNFC_tag_origins.xls';

$grid->setGridOptions(array(

"rowNum"=>30,

"rowList"=>array(10,20,30,50),

"sortname"=>"Name",

"sortorder"=>"ASC",

"hoverrows"=>true,

"toppager"=>true

));

$grid->toolbarfilter = true;

$grid->navigator = true;

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

$grid->setUrl("./services/jqgrid/admin/origin_list_grid.php");

$grid->setColProperty('ID', array("hidden"=>true));

$grid->setColProperty(

'company_id', array("hidden"=>true,

"editoptions"=>array("defaultValue"=>$_SESSION['company_id'])));

// End of bespoke JS function

// Enjoy

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

$conn = null;

This reply was modified 11 years ago by Chris.

April 10, 2015 at 1:41 pm #123731

Chris

Participant

Just for information this is old code that has been working perfectly on the last Trirand release that we use on our live systems…

This reply was modified 11 years ago by Chris.

April 11, 2015 at 10:19 am #123735

guriddo.support

Participant

Hello,

Sorry, but this example we can not reproduce the problem.

Usually this problem is happen if the parameter – pagerpos is set to left.

In this case the grid set the width of the column on which the pager buttons are set.

By example if the pagerpos is set to left we calculate the width of the left column

This of course is a problem.

We have put this in our bug list. Hope It will be fixed in the next release.

Thanks for reporting and have a nice weekends.

Kind Regards,

Will

This reply was modified 11 years ago by guriddo.support.

Guriddo Support Team

April 11, 2015 at 11:01 am #123739

Chris

Participant

Hello – Can you please point me in the right direction as to how I set pagerpos? I have tried to find in the docs, but cant find that parameter.

Happy to try this until you fix it.

As I said the latest Trirand release I use in live works perfectly with the exact same code I am using on your 4.8 release…

Have a nice weekend.

April 14, 2015 at 7:55 am #123746

guriddo.support

Participant

Hello,

Look here

See pagerpos parameter. The values can be center, left, right and it is a grid option (setGridOptions method).

Kind Regards,

Will

Guriddo Support Team

April 14, 2015 at 11:35 am #123749

Chris

Participant

Hello – unfortunately I have tried that, but the pager is ignoring it and still moving to left and being overwritten by the pdf export etc. I implemented by changing as follows:

$grid-&gt;setGridOptions(array(
&quot;rowNum&quot;=&gt;30,
&quot;rowList&quot;=&gt;array(10,20,30,50),
&quot;sortname&quot;=&gt;&quot;Name&quot;,
&quot;sortorder&quot;=&gt;&quot;ASC&quot;,
&quot;hoverrows&quot;=&gt;true,
&quot;toppager&quot;=&gt;true,
&quot;pagerpos&quot;=&gt;center
));

$grid->setGridOptions(array(

"rowNum"=>30,

"rowList"=>array(10,20,30,50),

"sortname"=>"Name",

"sortorder"=>"ASC",

"hoverrows"=>true,

"toppager"=>true,

"pagerpos"=>center

));

I can not use your latest version live as it messes up about 80% of my grids, so will probably wait not until this gets fixed. I am happy of the latest Trirand release as long as my license does not give up!

April 14, 2015 at 12:33 pm #123750

guriddo.support

Participant

Hello,

Because we can not reproduce the problem, can you please prepare a separate example files which demostates the problem and send it to support at guriddo dot net.

pager_left width is not set correctly

Search Forum

Recent Replies

Forum Statistics

UserOnline