How to put a pull-down menu into each row in a table?

How to put a pull-down menu into each row in a table?

بواسطة - Nadyare Pérez
عدد الردود: 7

Hi! i'm doing something like a small scheduler and i have a problem. Now, i have in the table what you can see in the attached file.

The names of the pupils and then one radio for each free slot and when i select one of them, the free slot is inmediately assigned to the student.

But is a shoddy piece of work. So i want to convert these radios into a pull-down menu doing the same.

I know how to get the free slots but i don't have an idea to put them into the menu. Can anyone help me, please?

Thanks! and sorry for my horrible english.

المرفق foto.JPG
متوسط التقييمات: -
رداً على Nadyare Pérez

Re: How to put a pull-down menu into each row in a table?

بواسطة - Tim Hunt
صورة Core developers صورة Documentation writers صورة Particularly helpful Moodlers صورة Peer reviewers صورة Plugin developers
To generate a dropdown, taking advantatge of the function from weblib:
$slots = array(

    'slot1' => '10:15 - 10:30',

    'slot2' => '10:30 - 10:45',

    'slot3' => '10:45 - 11:00',

    'slot4' => '11:00 - 11:15',

    'slot5' => '11:15 - 11:30',

    'slot6' => '11:30 - 11:45',

    'slot7' => '11:45 - 12:00',

);

choose_from_menu($slots, 'slotforstudent123');


When the user submits the form for process, to get the value:
$user123slot = optional_param('slotforstudent123', '', PARAM_ALNUM);

if ($user123slot) {

    // Somthing was selected, and $user123slot will contain 'slot1 or 'slot2' or ...

}
متوسط التقييمات: -
رداً على Tim Hunt

Re: How to put a pull-down menu into each row in a table?

بواسطة - Nadyare Pérez

Thank you very much! That's very useful, but how can i get the array of slots if i don't know the slots beforehand?

I get the free slots doing:

$slots = get_records('interview_slots', 'interviewid', $interview->id, 'id');

but how can i put them into the array?

Thanks again!

متوسط التقييمات: -
رداً على Nadyare Pérez

Re: How to put a pull-down menu into each row in a table?

بواسطة - Tim Hunt
صورة Core developers صورة Documentation writers صورة Particularly helpful Moodlers صورة Peer reviewers صورة Plugin developers
You could use a for loop to copy them into an array. Or you could use the get_records_menu function which, if you select some data with two columns, returns an array already.
متوسط التقييمات: -
رداً على Tim Hunt

Re: How to put a pull-down menu into each row in a table?

بواسطة - Nadyare Pérez

I'm doing:

 if (!record_exists('interview_slots', 'student', $student->id, 'interviewid', $interview->id)) {

   $slots = get_records('interview_slots', 'interviewid', $interview->id, 'id');
              foreach ($slots as $slot) {

       $menu = get_records_menu('interview_slots','start', $slot-                                                >start, 'end', $slot->end);
    }

     $actions = choose_from_menu($menu, 'slotforstudent'); 

}

$mtable->data[] = array($picture, $name, $email, $actions);

But i'm getting what you can see in the attached file. The actions are out of the table and they are empty while they should have all the slots of the table above

What is wrong?

Thank you very much!

المرفق Dibujo.JPG
متوسط التقييمات: -
رداً على Nadyare Pérez

Re: How to put a pull-down menu into each row in a table?

بواسطة - Tim Hunt
صورة Core developers صورة Documentation writers صورة Particularly helpful Moodlers صورة Peer reviewers صورة Plugin developers
I guess my hints were too cryptic.

To start with, your code does too many separate database queries. They are expensive, so it is always best to try to get all the necessary data with one query (but not to fetch unnecessary data).

So you just need 

$slots = get_records('interview_slots', 'interviewid', $interview->id, 'start', 'id,start,end');


That gets the id, start and end time of each slot for this interview, ordered by increasing 'start'.

Then do

 

if (!empty($slots)) {

    $choices = array();

    foreach($slots as $slot) {

        $choices[$slot->id] = $slot->start . ' - ' . $slot->end;

    }

    $actions = choose_from_menu($choices, 'slotforstudent', '', 'choose', '', '0', true);

} else {

    $actions = '';

}

$mtable->data[] = array($picture, $name, $email, $actions);


choose_from_menu normally prints out the HTML for the menu immediately. You have to pass the 7th parameter ($return) as true, if you want the HTML returned for you.
متوسط التقييمات: -
رداً على Tim Hunt

Re: How to put a pull-down menu into each row in a table?

بواسطة - Nadyare Pérez
I've got itابتسامة كبير ابتسامة كبير Thank you very much!!

Now the last thing!

What can I do to convert all the slots of the pull-down menu into links?
I mean that when i select a slot for a student it take me to an action in view.php named for example assing passing like parameters the id of the chosen slot and the id of the user and they get associated.

Can you tell me what i have to change in your code to convert each slot in the menu to a link that doesn't need a submit button?

Thousands of thanks!!!
متوسط التقييمات: -
رداً على Nadyare Pérez

Re: How to put a pull-down menu into each row in a table?

بواسطة - Tim Hunt
صورة Core developers صورة Documentation writers صورة Particularly helpful Moodlers صورة Peer reviewers صورة Plugin developers
I think if you use the popup_form function, instead of choose_from_menu, but I am not so familiar with how that works.
متوسط التقييمات: -