<option value="">Aucun</option> <?php buildOptionsMandataires($_SESSION['values']['box_Mandataire']); ?> </select> </td> </tr> <tr> <td> <!--Locataire--> <label for="txt_Locataire">Locataire</label><br /> <select class="input" name="box_Locataire" id="box_Locataire" onchange="addOption();" data-placeholder="Sélectionner un locataire" class="chzn-select" tabindex="2"> <option value=""></option> <option value="">Aucun</option> <?php buildOptionsPersonnes($_SESSION['values']['box_Locataire']); ?> </select> </td> <td> <!--Facturer--> <label for="box_Facturer">Facturer<span class="red">*</span></label><br /> <select class="input" name="box_Facturer" id="box_Facturer" onchange="validate(this.value, this.id);"> </select><br/> <span id="box_FacturerFailed" class="<?php echo $_SESSION['errors']['Facturer']; ?> red"> Veuillez choisir une personne à facturer. </span> </td>
Filtre : <select id="slt_filter" onchange="javascript:filter(this.value);"> <option value="all">Tout</option> <option value="cantine">Cantine</option> <option value="etal">Place et Etal</option> <option value="amarrage">Amarrage</option> </select><br/><br/> <label for="box_search"><?php echo $label; ?> </label> <select name="box_search" id="box_search" data-placeholder="Sélectionner un compte" class="chzn-select" tabindex="2" style="width:450px;"> <option value=""></option> <?php buildOptionsPersonnes($_GET['form']); ?> </select> <button onclick="filter_byclient();">Filtrer par client</button> <br/><br/> <div id="list_validation" style="height:600px;"></div> <div id="dialog-form" title="Rejeter la facture"> <p class="validateTips">Le commentaire est obligatoire.</p> <form> <fieldset>
<?php include_once 'config.php'; $id = $_GET["id"]; $output = '<table id="tblconjoint" class="tblform" style="width:100%;">' . ' <thead>' . ' <tr>' . ' <th>Conjoint</th>' . ' </tr>' . ' </thead>' . ' <tbody>' . ' <tr>' . ' <td><label>Sélectionner un conjoint</label><br />' . '<select name="box_conjoint" id="box_conjoint" onchange="validate(this.value, this.id);addOption();" data-placeholder="Affecter à vide pour supprimer le conjoint" class="chzn-select" tabindex="2">' . '<option value=""></option>'; $output .= buildOptionsPersonnes(); $output .= '</select> <button onclick=affect_conjoint();>Affecter</button>' . '</td>' . ' </tr>' . ' <tr>' . ' <td><label>Conjoint actuel</label><br/>'; $output .= find_conjoint($id); $output .= '</td>' . ' </tr>' . ' </tbody>' . '</table><br/>'; print $output; // functions //////////// function buildOptionsPersonnes() { $mysqli = new mysqli(DBSERVER, DBUSER, DBPWD, DB); $query = "SELECT `clientid`, `clientnom`, `clientprenom`, `clientdatenaissance` FROM `clients` WHERE `clientstatus`='1' ORDER BY `clientnom`"; $result = $mysqli->query($query); while ($row = $result->fetch_array(MYSQLI_ASSOC)) { $output .= '<option value="' . $row['clientid'] . '">' . strtoupper($row['clientnom']) . " " . strtoupper($row['clientprenom']) . " - " . date("d/m/Y", strtotime($row['clientdatenaissance'])) . '</option>'; } $mysqli->close(); return $output; } function find_conjoint($id) { $mysqli = new mysqli(DBSERVER, DBUSER, DBPWD, DB); $conjointid = find_conjointid($id); $query = "SELECT `clientid`, `clientnom`, `clientprenom`, `clientdatenaissance`,`clientid` FROM `clients` WHERE `clientid`='{$conjointid}'"; $result = $mysqli->query($query); $row = $result->fetch_array(MYSQLI_ASSOC); if ($result->num_rows > 0) { $output = "<a href='clients.php?hideerrors=1&edit=" . $row['clientid'] . "'>" . strtoupper($row['clientnom']) . " " . strtoupper($row['clientprenom']) . " - " . date("d/m/Y", strtotime($row['clientdatenaissance'])) . "</a>";