how can I make a single field dependent?

mf

Hello!

I have a selection in the editor and you can select your own name and save something in a table. Is it possible to make the select field know what user saved something? so you cannot select your own name a second time for a new row?

I have some code, not sure if that is the best way but I end up in a loop and want to know if there is something to prevent it.

this is the server side PHP script name user_dynamic.php

<?php
require_once 'dbconfig.php';

    //$week = $_REQUEST['values']['lunch.week'];
    $week = 13;
    $stmt = $db_con->prepare("SELECT users FROM lunch WHERE (week = :week)");
    $stmt->execute(array(":week"=>$week));

    $stmt1 = $db_con->prepare("SELECT id FROM users");
    $stmt1->execute();

    $data = array();
    $count = 1;
    while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        $data[$count++] = $row['users'];
    }  

    $data1 = array();
    $count = 1;
    while($row1 = $stmt1->fetch(PDO::FETCH_ASSOC)){
        $data1[$count++] = $row1['id'];
    }  

   $notFound = array_diff($data1, $data);

   if(!empty($notFound)):  
        foreach($notFound as $id => $user):
            $id = $notFound[$id];
            $ids = $ids . "," . $id;
        endforeach;
    endif; 
    $ids = substr($ids,1);
    $stmt = $db_con->prepare("SELECT id as value, concat(first_name,' ',last_name) as label FROM users WHERE id IN(". $ids . ")");
    $stmt->execute();
    $contacts=$stmt->fetchAll();

    echo json_encode( [
        'options' => [
            'lunch.users' => $contacts
        ]
    ] );
?>  

And this is partly the javascript (it was too long)

$(document).ready(function() {

    var lunchEditor = new $.fn.dataTable.Editor( {
        //ajax: "php/table.lunch.php",
        ajax: {
            url: 'php/table.lunch.php',
            data: function ( d ) {
                var selected = weekTable.row( { selected: true } );

                if ( selected.any() ) {
                    d.week = selected.data().id;
                }
            }
        },
        table: "#lunch",
        fields: [ {
                label: "User:",
                name:  "lunch.users",
                type: "select"
              },{
                label:     "Monday:",
                name:      "lunch.monday",
                type:      "checkbox",
                separator: "|",
                options:   [
                    { label: '', value: 1 }
                ],
                unselectedValue: 0
             },{
                label: "Tuesday:",
                name:  "lunch.tuesday",
                type:      "checkbox",
                separator: "|",
                options:   [
                    { label: '', value: 1 }
                ],
                unselectedValue: 0
            },{
                label: "Wednesday:",
                name:  "lunch.wednesday",
                type:      "checkbox",
                separator: "|",
                options:   [
                    { label: '', value: 1 }
                ],
                unselectedValue: 0
            },{
                label: "Thursday:",
                name:  "lunch.thursday",
                type:      "checkbox",
                separator: "|",
                options:   [
                    { label: '', value: 1 }
                ],
                unselectedValue: 0
            },{
                label: "Friday:",
                name:  "lunch.friday",
                type:      "checkbox",
                separator: "|",
                options:   [
                    { label: '', value: 1 }
                ],
                unselectedValue: 0
            },{
                label: "Signature:",
                name:  "lunch.sig",
                type:  "sig"
            }
        ]
    } );

  
    lunchEditor.dependent( 'lunch.users', 'users_dynamic.php' ); 
  
} );

Its not a public site so I can't show it in action

Thanks!!

mf

never mind I solved it by adding a second select field in editor (lunch.week) and make it dependent on that