This page shows a "semidonut" chart that does not actually exist in An圜hart. It is important because if there is no information in the filters, the rest of the panels come out empty or give an error. In this case I have made that in the event that the conditions do not give any record, the conditions are not taken into account and all are displayed. In the event "Before SQL Query" these values are calculated and stored in session variables to be used in both "snnipet" to create the header of the "grid"Īnother aspect that I have also changed is the operation of the general search box. I want to highlight how, part of the header of the "grid" is variable depending on the call. The rest of the applications that are not shown are grouped into an item called "Rest". The graph does not report all the applications, it only informs us of the 6 main ones (the number is defined in an application parameter set in the "After application initialized" event). The panel names can be customized using the syntax, referring to the fields of the filter or master table. As this set of pages shows the data of the selection and compares it with the previous call, the SQL of this table is built dynamically. This helps me so that the rest of the information is dependent on the filter of (2) that already has the key of (1) and that of (2). As it is filtered, the data in the panel table only appears once (2). What I have done is that the panel (2) depends on (1), but in the panel (2) I have made a "JOIN" between the tables of the panel (1) and the panel (2). As you know, in PHPRunner it can only be made dependent on a filter panel, then. We see that the data is dependent on 2 filter panels. It will help me to explain some characteristics that you will be able to see in code. I show one of the pages of the application. The interface and data is in Spanish, but I insist that the objective is not the data, but how the graphs are built and have examples for when we make ours. Election results are public and more or less, everyone understands them, and, in one way or another, we have all participated in electoral processes. The objective of the example is not to show the Elections data, but to have a series of (real) examples that serve to analyze and learn how to exploit the potential of An圜hart. These Municipalities are in turn divided into Districts. The provinces are divided into administrative units that are the Municipalities. Spain is divided into 17 Autonomous Communities and these have one or more provinces. To do the example I have used the data that I have from the Elections of the Community of Madrid.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |