Guriddo » Topic: Upgrading from Triband PHP to Guiddo

Upgrading from Triband PHP to Guiddo – any docs?

Guriddo
Gurrido upgrade
Upgrading from Triband PHP to Guiddo – any docs?

Tagged: Gurrido upgrade

This topic has 9 replies, 2 voices, and was last updated 9 years, 6 months ago by guriddo.support.

Creator

Topic
April 9, 2015 at 11:29 am #123715

Chris
Participant

Hello – I have just downloaded the latest version of Guriddo 4.8 and want to upgrade from the older Triband version installed. I thought it might be a case of just replacing libraries, but the file structure seems to have changed such as where CSS is no etc and and CSS files I was using like jqgrid.css I cant find.

Can you point me towards some documentation that describes how to upgrade from the old version to the new Guriddo structure? Or the easiest way to achieve this?

I also use jqChart in my live version, so not sure how I upgrade this?

Any help my save me a lot of time – so appreciated.

Regards, Chris.
Creator

Topic

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

Author

Replies

April 9, 2015 at 1:54 pm #123716

Chris

Participant

Hello – I have managed to put this all in successfully but if you do have any documentation on how to upgrade might be worth it incase I have missed anything.

All works great though!

Cheers – Chris.

April 9, 2015 at 4:06 pm #123718

Chris

Participant

Hi – I do have a problem since the upgrade getting PDF export to work. I have looked at all the documentation and examples and still cant figure it out. In your examples you require …. /tcpdf/lang/eng.php and cant see that anywhere but sure that is not the reason.

I am assuming without touching anything it will be using your tcpdf library and settings held in /External?

The error I am getting is:

Strict Standards: Only variables should be passed by reference in /home/zipnfcuk/public_html/facilities/gridChartFramework/php/PHPSuito/jqGridExport.php on line 764

En example of the php handling the grid is:

[code][/code]
<?php
ini_set(’display_errors', ’on');
error_reporting(E_ALL);
if (!isset($_SESSION[’grid_query'])) {
session_start();
}
$_SESSION[’user_type']==3 ? $editable=false : $editable = true;
include __DIR__ . ’/../../include/jq-config.php';
$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);
$conn->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->dataType = ’json';
// Let the grid create the model
$grid->table = ’tags'; // 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_list.xls';
$grid->setGridOptions(array(
”rowNum”=>30,
”rowList”=>array(10,20,30,50),
”sortname”=>”ID”,
”sortorder”=>”ASC”,
”hoverrows”=>true,
”toppager”=>true
));
$myformat = <<<FORMATDETAILS
function MyFormatter (cellValue, options, rowdata)
{
var action_html = ‘</img>‘;
return action_html;
}
function StatusFormatter (cellValue, options, rowdata)
{
var statusString;
if(cellValue == 1){
 statusString = ”active“;
 }
else{
 statusString = ”inactive“;
 }
return statusString;
}
function LabelledFormatter (cellValue, options, rowdata)
{
var statusString;
if(cellValue == 1){
 statusString = ”Yes”;
 }
else{
 statusString = ”No”;
 }
return statusString;
}
FORMATDETAILS;
$grid->addCol(array(
”name”=>”Action”,
”editable”=>false,
”sortable”=>false,
”resizable”=>false,
”fixed”=>true,
”width”=>30,
”search”=>false,
”align”=>”center”
), ”first”);
$grid->toolbarfilter = true;
$grid->navigator = true;
$grid->setNavOptions(’navigator', array(”excel”=>true,”pdf”=>true, ”add”=>false,”edit”=>false,”del”=>$editable,”view”=>false,”cloneToTop”=>true));
$grid->setUrl(”./services/jqgrid/tag_list_grid.php”);
$grid->setSelect(”Type”, ”SELECT DISTINCT tag_types.Name, tag_types.Name FROM tags INNER JOIN tag_types ON tags.Type = tag_types.ID where tags.Company = “.$_SESSION[’company_id'], false, false, true, array(””=>”All”));
$grid->setSelect(”Origin”, ”SELECT DISTINCT tag_origins.Name, tag_origins.Name FROM tags INNER JOIN tag_origins ON tags.Origin = tag_origins.ID where tags.Company = “.$_SESSION[’company_id'], false, false, true, array(””=>”All”));
$grid->setSelect(”Location”, ”SELECT DISTINCT tag_locations.Name, tag_locations.Name FROM tags INNER JOIN tag_locations ON tags.Location = tag_locations.ID where tags.Company = “.$_SESSION[’company_id'].” ORDER by name”, false, false, true, array(””=>”All”));
$grid->setColProperty(’Action', array(’formatter'=>’js:MyFormatter'));
$grid->setColProperty(’status', array(”label”=>’Status',’formatter'=>’js:StatusFormatter',”width”=>’70′));
$grid->setColProperty(’ID', array(”width”=>’50′));
$grid->setColProperty(’TagRef', array(”label”=>’IntRef',”width”=>’50′));
$grid->setColProperty(’Latitude', array(”width”=>’50′));
$grid->setColProperty(’Longitude', array(”width”=>’50′));
$grid->setColProperty(’Type', array(”label”=>’Category',”width”=>’50′));
$grid->setColProperty(’Origin', array(”width”=>’50′));
$grid->setColProperty(’contract_renew_date', array(”label”=>’Contract Renewal'));
$grid->setColProperty(’serial_number',array(”label”=>’Serial'));
$grid->setColProperty(’contract_renew_date', array(
 ”formatter”=>’date',
 ”formatoptions”=>array(’srcformat'=>’Y-m-d',’newformat'=>’d-m-Y'),
 ”width”=>’75′
));
$grid->setColProperty(’labelled', array(”label”=>’Label',’formatter'=>’js:LabelledFormatter',”width”=>’50′));
$grid->setColProperty(’nfc_tagged', array(”label”=>’Tagged',’formatter'=>’js:LabelledFormatter',”width”=>’50′));
$grid->setJSCode($myformat);
$myStatus = array(”1″=>”Active”, ”0″=>”Inactive”);
$grid->setSelect(”status”, $myStatus , false, false, true, array(””=>”All”));
$labelYesNo = array(”1″=>”Yes”, ”0″=>”No”);
$grid->setSelect(”labelled”, $labelYesNo , false, false, true, array(””=>”All”));
$grid->setSelect(”nfc_tagged”, $labelYesNo , false, false, true, array(””=>”All”));
// End of bespoke JS function
// Enjoy
$grid->renderGrid(’#grid',’#pager',true, null, null, true,true);
$conn = null;
[\code]

This reply was modified 9 years, 6 months ago by Chris.

April 10, 2015 at 9:27 am #123721

guriddo.support

Participant

Hello,

Thank you for the posting.

In the downloaded package there are upgrade notes, so you can read them.

Can you please send us a test case or copy/paste it here without any additional tags?

We think we have found the problem, but we need to test it with your case.

Thank you

Kind Regards,

Will

Guriddo Support Team

April 10, 2015 at 10:50 am #123728

Chris

Participant

Hello – well it was not working with every single grid of mine, but works fine with the 4.7 tcpdf library. If you want to ship me or send a link for the new tcpdf library – very happy to try. Here is a simple example though:

<!--?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';      ?-->
<div id="grid_div"><!--  start of jquerygrid -->
<!--?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>
<!--end of jquerygrid  -->

<!--right panel End-->

<!--Container End-->

<!--wrapper End-->

</div>

<!--?php  ini_set('display_errors', 'on'); error_reporting(E_ALL); if (!isset($_SESSION['grid_query'])) { 	session_start(); } $_SESSION['user_type']==3 ? $editable=false : $editable = true; include __DIR__ . '/../../../include/jq-config.php'; $conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD); $conn--->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;
?>

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;

April 10, 2015 at 10:52 am #123729

Chris

Participant

By the way not sure what goes wrong with the post system, but on the hold php code it never formats OK – if you can look at a text view it will look fine I think. This is the same code I posted successfully on the query about the paging being on the left rather than the centre…

April 10, 2015 at 11:11 am #123730

Chris

Participant

Also just to add this is old code that worked fine on the latest Trirand release we are using live at the moment.

April 11, 2015 at 10:29 am #123737

guriddo.support

Participant

Hello,

To format a code you will need to switch to Text mode. Select a text and push the code button.

In visual tab this does not function correct. It is a bug in the software we use – Sorry.

We think we have isolated a problem with pdf export and hope the fix will be availabe in the next release.

Because you use a php setting witch do this:

ini_set('display_errors', 'on');
error_reporting(E_ALL);

1 2	ini_set('display_errors', 'on'); error_reporting(E_ALL);

If you comment these lines your code will work with the new tcpdf.

The problem is in our code and is common and is similar like this

The solution is described into the link

Kind Regards,
Will

This reply was modified 9 years, 6 months ago by guriddo.support.

Guriddo Support Team

April 11, 2015 at 11:03 am #123740

Chris

Participant

I am sure I took that out when trying to identify the problem, but will definitely give it a try!

Have a nice weekend.

April 14, 2015 at 7:43 am #123744

guriddo.support

Participant

Hello,

Thanks. I will let you know when we are ready with this.

Kind Regards,
Will

Guriddo Support Team

Author

Replies

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

You must be logged in to reply to this topic.

Registered Users: 12,249
Forums: 7
Topics: 10,947
Replies: 23,146
Topic Tags: 324
Empty Topic Tags: 9

4 Users Online

Users: 3 Guests, 1 Bot

Stay connected with us in your favorite flavor!

Upgrading from Triband PHP to Guiddo – any docs?

Search Forum

Recent Replies

Forum Statistics

UserOnline