Freelance Soft PHP Ajax Grid

PHP Ajax Grid - Demo: Seven Tables

-- Seven: Delete + Combos + Inner Join + Where Condition --
Excellent People

Constructor:

 

$gridName = AjaxGrid::create(

         "gridName",

         array(

                     new DBQueryDescriptor("city",

                                array("ID","Name", "Population","PeopleIs")),

                     new DBQueryDescriptor("peopleis",

                                array("ID","Description"),

                                DBQueryDescriptor::$INNER_JOIN,

                                'peopleis.ID = city.PeopleIs')),

         array(

                     "Actions" => new ColumnMapped($actionsFormat,

                                            array("city.ID","city.ID"),false,'5%'),

                     "Pople Is" => new ColumnComboMapped($comboFormat,

                                            "peopleis","peopleis.ID","peopleis.Description",

                                            "peopleis.ID",array("city.ID"),

                                            "peopleis.Description"),

                     "Name" => new ColumnMapped($nameFormat,

                                            array("city.Name"), true),

                     "Population" => new ColumnMapped($populationFormat,

                                            array("city.Population"), true)),

         false, <Where_Condition>);

       
Rows per page (Change) Not record yet
       
Very Good People
       
Grid by fs
Actions Pople Is Name Population
Edit
Buenos Aires
2982146
Edit
 
207041
Rows per page (Change) Record 1 to 2 of 2
       
Good People
       
Rows per page (Change) Not record yet
       
No Bad People
    1 2 3 4 5 6 7 8 Next Last
Grid by fs
Actions Pople Is Name Population
Edit
La Matanza
1266461
Edit
 
1157507
Edit
Rosario
907718
Edit
Lomas de Zamora
622013
Edit
Quilmes
559249
Edit
Almirante Brown
538918
Edit
La Plata
521936
Edit
Mar del Plata
512880
Edit
 
470809
Edit
 
469735
Rows per page (Change) Record 1 to 10 of 579
    1 2 3 4 5 6 7 8 Next Last
Bad People
       
Rows per page (Change) Not record yet
       
Very Bad People
       
Rows per page (Change) Not record yet
       
Repugnant People
       
Rows per page (Change) Not record yet