aklump/loft_data_grids

PHP Classes to allow data placement in a grid structure and exporting in various data formats.

Tuesday, January 30, 2018
by aklump
Repository
1 Watchers
6 Stars
5,738 Installations

HTML
0 Dependents
0 Suggesters
2 Forks
2 Open issues
48 Versions
12 % Grown

The README.md

Loft Data Grids

, _(*1)

There will be no new features added to this project. I suggest using the Symfony Serializer Component instead for similar functionality. The project will not receive ongoing support., _(*2)

Summary

This package is a PHP object-oriented solution for modelling data in two (rows + columns) or three dimensions (rows + columns + pages). It can be thought of like a spreadsheet., _(*3)

It allows a single data class ExportData to be used to organize your data in a grid, with various output styles Exporter so you can easily get a .csv file or a .xlsx file, among many others., _(*4)

See the code for more documentation., _(*5)

Install with Composer

Require this package:, _(*6)

composer require aklump/loft_data_grids:^0.7

Usage

Let's build a two-layer data grid. (Layers are called pages.) The first page will contain names and ages of three people. The second page will contain vehicle information. It can be pictured in two tables:, _(*7)

Page 0 , _(*8)

Name	Age
Adam	39
Brandon	37
Charlie	7

Page 1 , _(*9)

Color	Make
Black	Honda
White	BMW

In Code

$data_grid = new \AKlump\LoftDataGrids\ExportData();

// By default we're on page 0, row 0.
$data_grid->add('Name', 'Adam')->add('Age', 39)->next();
$data_grid->add('Name', 'Brandon')->add('Age', 37)->next();
$data_grid->add('Name', 'Charlie')->add('Age', 7)->next();

// Switch to page 1; we'll be placed on row 0.
$data_grid->setPage(1);
$data_grid->add('Color', 'Black')->add('Make', 'Honda')->next();
$data_grid->add('Color', 'White')->add('Make', 'BMW')->next();

Accessing data from the object

Think of pointer as a row in a table., _(*10)

$value = $data_grid->setPage(0)->setPointer(0)->getValue('Name') // $value === 'Adam'
$value = $data_grid->getValue('Name') // $value === 'Adam'
$value = $data_grid->setPointer(2)->getValue('Name') // $value === 'Charlie'
$value = $data_grid->setPointer(0)->get() // $value === array('Name' => 'Adam', 'Age' => 39)
$value = $data_grid->setPage(1)->setPointer(1)->getValue('Color') // $value === 'White'

Exporting data to other formats

We can export both pages in CSV like this:, _(*11)

$exporter = new \AKlump\LoftDataGrids\CSVExporter($data_grid);

$csv_string = $exporter->export();
// "Name","Age"
// "Adam","39"
// "Brandon","37"
// "Charlie","7"

$csv_string = $exporter->export(1);
// "Color","Make"
// "Black","Honda"
// "White","BMW"

Or to get it as JSON..., _(*12)

$exporter = new \AKlump\LoftDataGrids\JSONExporter($data_grid);
$json_string = $exporter->export();

(This has been formatted for easier-reading; the actual JSON is minified.), _(*13)

[
  [
    {
      "Name": "Adam",
      "Age": 39
    },
    {
      "Name": "Brandon",
      "Age": 37
    },
    {
      "Name": "Charlie",
      "Age": 7
    }
  ],
  [
    {
      "Color": "Black",
      "Make": "Honda"
    },
    {
      "Color": "White",
      "Make": "BMW"
    }
  ]
]

Or any of the other exporter classes., _(*14)

Saving to File

$exporter = new \AKlump\LoftDataGrids\XLSXExporter($data_grid, 'users');
$exporter->saveFile();

Exporters: objects as values

Exporters can handle objects if they implement the objectHandler method.
Exporters can handle \DateTime objects if they set a value for 'dateFormat'.

Testing

Run the PhpUnit tests with ./bin/run_unit_tests.sh

The Versions

30/01 2018

dev-master

9999999-dev http://github.com/aklump/loft_data_grids

PHP Classes to allow data placement in a grid structure and exporting in various data formats.

library loft_data_grids

PHP Classes to allow data placement in a grid structure and exporting in various data formats.

aklump/loft_data_grids

The README.md

Loft Data Grids

Summary

Install with Composer

Usage

In Code

Accessing data from the object

Exporting data to other formats

Saving to File

Exporters: objects as values

Testing

The Versions

dev-master

The Requires

by Aaron Klump

0.4.31

The Requires

by Aaron Klump

0.4.30

The Requires

by Aaron Klump

0.4.29

The Requires

by Aaron Klump

0.4.28

The Requires

by Aaron Klump

0.4.27

The Requires

by Aaron Klump

0.4.26

The Requires

by Aaron Klump

0.4.25

The Requires

by Aaron Klump

0.4.23

The Requires

by Aaron Klump

0.4.22

The Requires

by Aaron Klump

0.4.21

The Requires

by Aaron Klump

0.4.20

The Requires

by Aaron Klump

0.4.19

The Requires

by Aaron Klump

0.4.18

The Requires

by Aaron Klump

0.4.17

The Requires

by Aaron Klump

0.4.16

The Requires

by Aaron Klump

0.4.15

The Requires

by Aaron Klump

0.4.14

The Requires

by Aaron Klump

0.4.13

The Requires

The Development Requires

by Aaron Klump

0.4.12

The Requires

The Development Requires

by Aaron Klump

0.4.11

The Requires

The Development Requires