Guriddo » Chris's Replies

Chris

Guriddo

Forum Replies Created

Viewing 2 replies - 31 through 32 (of 32 total)

← 1 2 3

Author

Replies
April 9, 2015 at 4:06 pm in reply to: Upgrading from Triband PHP to Guiddo – any docs? #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

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

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

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

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 11 years ago by Chris.
April 9, 2015 at 1:54 pm in reply to: Upgrading from Triband PHP to Guiddo – any docs? #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.
Author

Replies

Viewing 2 replies - 31 through 32 (of 32 total)

← 1 2 3