function RenderGrid(Grid $Grid) { $Rows = array(); $HeaderCaptions = array(); $Grid->GetDataset()->Open(); foreach ($Grid->GetExportColumns() as $Column) { $HeaderCaptions[] = $Column->GetCaption(); } while ($Grid->GetDataset()->Next()) { $Row = array(); $rowValues = $Grid->GetDataset()->GetFieldValues(); $cellStyles = $this->GetStylesForColumn($Grid, $rowValues); foreach ($Grid->GetExportColumns() as $column) { $columnName = $Grid->GetColumnName($column); $cell['Value'] = $this->RenderViewColumn($column, $rowValues); $cell['Align'] = $column->GetAlign(); $cellStyle = new StyleBuilder(); $cellStyle->Add('width', $column->GetFixedWidth()); if (!$column->GetWordWrap()) { $cellStyle->Add('white-space', 'nowrap'); } $cellStyle->AddStyleString(ArrayUtils::GetArrayValueDef($cellStyles, $columnName)); $cell['Style'] = $cellStyle->GetStyleString(); $Row[] = $cell; } $Rows[] = $Row; } $this->DisplayTemplate('export/pdf_grid.tpl', array(), array('TableHeader' => $this->CreateTableHeaderData($Grid), 'Rows' => $Rows)); }
public function GetRowStylesByColumn($rowValues) { $result = array(); $cellCssStyles = array(); $rowCssStyle = ''; $this->OnCustomDrawCell->Fire(array($rowValues, &$cellCssStyles, &$rowCssStyle)); $cellCssStyles_Simple = $this->GetStylesForColumn($this, $rowValues); $cellCssStyles = array_merge($cellCssStyles_Simple, $cellCssStyles); foreach ($this->GetViewBands() as $band) { foreach ($band->GetColumns() as $column) { $columnName = $this->GetColumnName($column); if (array_key_exists($columnName, $cellCssStyles)) { $styleBuilder = new StyleBuilder(); $styleBuilder->AddStyleString($rowCssStyle); $styleBuilder->AddStyleString($cellCssStyles[$columnName]); $result[$columnName] = $styleBuilder->GetStyleString(); } else { $result[$columnName] = $rowCssStyle; } } } return $result; }
function RenderGrid(Grid $Grid) { /* $Rows = array(); $RowPrimaryKeys = array(); $AfterRows = array(); $rowCssStyles = array(); $rowColumnsChars = array(); $rowColumnsCssStyles = array(); $bandHeadColumnsStyles = array(); $columnsNames = array(); $exportColumns = $Grid->GetExportColumns(); foreach($exportColumns as $Column) { $headColumnsStyleBuilder = new StyleBuilder(); if ($Column->GetFixedWidth() != null) $headColumnsStyleBuilder->Add('width', $Column->GetFixedWidth()); $headColumnsStyles[] = $headColumnsStyleBuilder->GetStyleString(); $columnsNames[] = $Column->GetName(); } $Grid->GetDataset()->Open(); $recordCount = 0; while($Grid->GetDataset()->Next()) { $show = true; $Grid->BeforeShowRecord->Fire(array(&$show)); if (!$show) continue; $Row = array(); $AfterRowControls = ''; $rowValues = $Grid->GetDataset()->GetFieldValues(); $rowCssStyle = ''; $cellCssStyles = array(); $Grid->OnCustomDrawCell->Fire(array($rowValues, &$cellCssStyles, &$rowCssStyle)); $cellCssStyles_Simple = $this->GetStylesForColumn($Grid, $rowValues); $cellCssStyles = array_merge($cellCssStyles_Simple, $cellCssStyles); $currentRowColumnsCssStyles = array(); $columnsChars = array(); for($i = 0; $i < count($bands); $i++) { $band = $bands[$i]; foreach($band->GetColumns() as $Column) { $columnName = $Grid->GetDataset()->IsLookupField($Column->GetName()) ? $Grid->GetDataset()->IsLookupFieldNameByDisplayFieldName($Column->GetName()) : $Column->GetName(); if (array_key_exists($columnName, $cellCssStyles)) { $styleBuilder = new StyleBuilder(); $styleBuilder->AddStyleString($rowCssStyle); $styleBuilder->AddStyleString($cellCssStyles[$columnName]); $currentRowColumnsCssStyles[] = $styleBuilder->GetStyleString(); } else $currentRowColumnsCssStyles[] = $rowCssStyle; if ($Column->GetFixedWidth() != null) $currentRowColumnsCssStyles[count($currentRowColumnsCssStyles) - 1] .= sprintf('width: %s;', $Column->GetFixedWidth()); if (!$Column->GetWordWrap()) $currentRowColumnsCssStyles[count($currentRowColumnsCssStyles) - 1] .= sprintf('white-space: nowrap;', $Column->GetFixedWidth()); $columnRenderResult = ''; $customRenderColumnHandled = false; $Grid->OnCustomRenderColumn->Fire(array($columnName, $Column->GetData(), $rowValues, &$columnRenderResult, &$customRenderColumnHandled)); $columnRenderResult = $customRenderColumnHandled ? $Grid->GetPage()->RenderText($columnRenderResult) : $this->Render($Column); $Row[] = $columnRenderResult; $columnsChars[] = ($Column->IsDataColumn() ? 'data' : 'misc'); $afterRow = $Column->GetAfterRowControl(); if (isset($afterRow)) $AfterRowControls .= $this->Render($afterRow); } if ($i < (count($bands) - 1)) $currentRowColumnsCssStyles[count($currentRowColumnsCssStyles) - 1] .= ($Grid->GetPage()->GetPageDirection() == 'rtl' ? 'border-left: ' : 'border-right: ' ). 'solid 2px' . ' #000000;'; } $recordCount++; if ($Grid->GetAllowDeleteSelected()) $RowPrimaryKeys[] = $Grid->GetDataset()->GetPrimaryKeyValues(); $Rows[] = $Row; $AfterRows[] = $AfterRowControls; $rowCssStyles[] = $rowCssStyle; $rowColumnsCssStyles[] = $currentRowColumnsCssStyles; $rowColumnsChars[] = $columnsChars; } */ $Rows = array(); $HeaderCaptions = array(); $Grid->GetDataset()->Open(); foreach ($Grid->GetExportColumns() as $Column) { $HeaderCaptions[] = $Column->GetCaption(); } while ($Grid->GetDataset()->Next()) { $Row = array(); $rowValues = $Grid->GetDataset()->GetFieldValues(); $cellStyles = $this->GetStylesForColumn($Grid, $rowValues); foreach ($Grid->GetExportColumns() as $column) { $columnName = $Grid->GetDataset()->IsLookupField($column->GetName()) ? $Grid->GetDataset()->IsLookupFieldNameByDisplayFieldName($column->GetName()) : $column->GetName(); $cell['Value'] = $this->RenderViewColumn($column, $rowValues); $cell['Align'] = $column->GetAlign(); $cellStyle = new StyleBuilder(); $cellStyle->Add('width', $column->GetFixedWidth()); if (!$column->GetWordWrap()) { $cellStyle->Add('white-space', 'nowrap'); } $cellStyle->AddStyleString(ArrayUtils::GetArrayValueDef($cellStyles, $columnName)); $cell['Style'] = $cellStyle->GetStyleString(); $Row[] = $cell; } $Rows[] = $Row; } $this->DisplayTemplate('export/pdf_grid.tpl', array(), array('TableHeader' => $this->CreateTableHeaderData($Grid), 'Rows' => $Rows)); }