How to include checkbox in Table Pager

Please state the context, function and the file you are trying to modify along with an intended screenshot of what you want to achieve.

There are:

includes/db_pager.inc
includes/ui/db_pager_view.inc

besides being called by various files both in the core and in the extensions.

Thanks,

I m trying to have a new look for ..\gl\inquiry\journal_inquiry.php with which  I want to add a new checkbox column at the beginning
of the displayed table.

When selecting checkbox's , it will popup a set of control buttons who will allow us to Export the selected rows.

It is a some kind of additional control to add for List inquiry web pages used in different locations of FA.

Kalido

Wouldn't you want to submit your code?

Attached your screenshot here for self-sufficiency.

Hi Joe,

Controlling the checkboxes in the tables rows are ok now ( learned how to do it from : bank_account_reconcile.php ),

but still I failed to control the top checkbox in their column header.

The idea is to use it as : check all / uncheck all / checked (whenever one of the rows checkboxes is checked)

AND whenever the header is being checked a tiny icon menu will  show up ( and this tiny menu will disappear when unchecked ).

Any suggestion ?

Regards,
Kalido

Thanks for your reply.

Khaled

Hi,

to resolve the checkboxes select/deselect in the rows, I did the following :

- I added a temporary field column "sel_chk" to the $sql used in journal_inquiry ( based on adding join the existing "gl_trans" to temporary table containing [ clone of gl_trans.counter & sel_chk]

- I controlled their previous selection  within the $sql pagination by adding a $_session var for the journal_inquiry page & by adding a conditional check in db_pager_view.inc

- I imitate the selection checkboxes as in : /gl/bank_account_reconcile.php and it works ok for the rows.

Now for doing the check ALL case in the deader i m freezed:

- I cannot adopt the JAVASCRIPT approach as in the links because it deals with the seen page only, and when paginating it flashes away all the checkboxes ( I tried as described )

- I tried to call a php function through AJAX ( it looks a good approach ) but i failed because it seems that in this JAVA / AJAX / PHP connection, JAVSCRIPT establish a new connection tunnel for the communication and in this case it couldn't recognize all of the server original environment and and the relations were lost.

it is really a difficult exercise.

khaled

currently, it works fine when clicking and staying in any table page

but when changing the page still there is a problem to be resolved.

//-------------------------------------------------------------------------------------------------------------------------
//               the bellow sequence is very important for controlling the checkboxes relation header / rows
//-------------------------------------------------------------------------------------------------------------------------
          
$id = find_submit('_rec_');      // check if a row was clicked

if (!check_value('chkbx')) { update_all('0') ;  }   // always clear all the rows checkboxes whenever the header is not marked

if ( check_value('chkbx')==1 && $id == -1) { update_all('1') ;  }  // when we are sure that the header is
                                                                                                                      //  clicked and not one of the rows was clicked
       
if ($id != -1)                                  // when a row is clicked => toggle its mark & update the "sel_chk" field to (0 || 1 )
        {
            $chkbox_value = check_value("rec_".$id) ? '1' : '0';
            update_gl_trans_sel_chk_value($id,$chkbox_value);
        }

//--------------------------------------------------------------------------------------------------------------------------
//               the above sequence is very important for controlling the checkboxes relation header / rows
//--------------------------------------------------------------------------------------------------------------------------

I m sure now that things are on the right track.

- the goods is I didn't use javascripts until now except of the standard ((( JsHttpRequest.request("_XXXX_update", this.form); )))

- the bads is that I was obliged to control the header checkbox through modifications in db_pager_view.inc file:

related to   :    $labels[0]   <==>  $table->columns->headers[0]   ( table header )

thanks for your support

Khaled