2. PHPRunner Tips and Tricks
  3. Guide 82 – PivotGrid and editing your data.
This topic is locked

Guide 82 – PivotGrid and editing your data.

 		5/29/2024 1:13:02 PM
PHPRunner Tips and Tricks
fhumanes author

img alt
As you know, regular users of this blog, I had already published an article on the PivotGrid solution using the DevExtreme library .

On this occasion, this example has the following characteristics that differentiate it from the previous one:

  • The data model on which it is based is much simpler, so that compression is easier.
  • It uses a Rest API to access the data. Which is the standard way used with all JavaScript front-ends (React, Angular, Vue.js, etc.)
  • It allows us, from the Pivot visualization itself, to update the base records.

A developer has asked me to be able to implement a treasury control system or “CashFlow” and it can be used for many other details such as evaluating company budgets, etc.

Objetive

Define a PivotGrid, very powerful in its definition and representation and be able to update the base information from the same graphical interface.

DEMO: https://fhumanes.com/devextreme_php/

img alt

If you are interested in this topic, continue reading the article at this link .
fhumanes author 5/29/2024

Technical Solution

As I have indicated, the information representation solution has used the DevExtreme library, the version of JQuery.

To define the ApiRest to serve the data and for the updates I have used the Slim 4 framework , which for many PHP developers is the best solution for the development of this type of Api. Starting from these examples, I think that developing others is quite simple, as long as you have a minimum of PHP knowledge. It is a very light framework and is included in the “Custom Files” part of the PHPRunner project.

In this article I explained the operation of this framework and the characteristics of this Api.

You will see that in the application I have given an example of DataGrid and another of PivotGrid, I have done this because when in the PivotGrid we click on a cell, a popup window opens with a DataGrid of the set of records that form the grouping on which we have clicked .

Having the 2 solutions we will be able to see all the characteristics that we can apply to the popup window.
fhumanes author 6/11/2024

Hello,

I do not understand the people who destroy the data set of the demos and do not notify it.

What they do, in my case, is to generate problems to other colleagues who will not be able to analyze whether the example serves or not.

I have restored the example data.

Greetings,
fernando
fhumanes author 6/14/2024

Hello ,

Sorry, I have seen that in the update that I passed to Hostinguer I had not changed the data server url and had it "localhost".

It is already changed and if you detect any problem, you can inform me in my email account: fernandohumanes@gmail.com

Greetings,
fernando