.Hello,
We updated jqGrid PHP from version 4.4.2 to version 5.0.0. Everything went well except exports doesn’t work anymore. PDF and Excel exports contains only header rows and nothing more. Here is a brief example:
$conn = new \jqGridArray();
$grid = new \jqGridRender($conn);
$data = $this->constructExportData($data);
$grid->ExportCommand = "SELECT * FROM data";
$grid->setColModel();
$grid->renderGrid('#grid', '#pager', true, null, null, true, true);
Br, Antti
Hello,
We can not reproduce the problem. To demonstrate that it is working we have prepared your example. Here is the demo.
All the exports working fine.
Not sure, but in your data you have one array more. This should look something like:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 |
$data = array (0 =>array ( 'Id' => '369', 'Name' => 'Test user', 'CompanyId' => '0', 'CompanyName' => 'Test Company', 'CostCenterId' => '0', 'CostCenterName' => NULL, 'SubprojectId' => '1787', 'SubProjectName' => 'Test subproject name', 'SubProjectNamePart' => 'Osaprojekti', 'BillabilityTypeId' => '0', 'ProjectId' => '4178', 'ProjectName' => 'Test project name', 'AccountId' => '4916', 'AccountName' => 'Test account name', 'A1_InvoicedHours' => '0.00', 'B1_HoursInvoicedPrice' => '10.50', 'B2_HoursPriceListPrice' => '0.00', 'C1_InvoiceableItems' => '0.00', 'C2_InvoiceableMaterials' => '0.00', 'D1_InvoiceableItemsPrice' => '0.00', 'D2_InvoiceableItemsPrice' => '0.00', 'E_Sales' => '0.00', 'F1_MaterialSales' => '3.00', 'F2_MaterialSales' => '3.00', 'G_TravelInvoiceSales' => '0.00', 'A2_Hours' => '0.00', 'H_HourCost' => '0.00', 'I1_MaterialPurchases' => '0.00', 'I2_MaterialPurchases' => '0.00', 'J_TravelInvoicePurchases' => '0.00', 'K1_Profitability' => '10.50', 'K1_Profitability' => '10.50', 'K2_Profitability' => '13.50', 'K2_Profitability' => '13.50', 'L1_ProfitabilityPercent' => '100.00', 'L1_ProfitabilityPercent' => '100.00', 'L2_ProfitabilityPercent' => '100.00', 'L2_ProfitabilityPercent' => '100.00', 'M1_AverageHourlyRate' => NULL, 'M1_AverageHourlyRate' => NULL, 'M2_AverageHourlyRateInvoicedHours' => NULL, 'M2_AverageHourlyRateInvoicedHours' => NULL, 'N_TargetPrice' => '0.00', ), ); |
Kind Regards,
Will
Guriddo Support Team
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top
