102 lines
4.5 KiB
PHP
Executable File
102 lines
4.5 KiB
PHP
Executable File
<div id="div_ente_requete">
|
|
|
|
<form id="frm_requete_perso" name="frm_requete_perso" method="post">
|
|
<table class="table table-responsive table-condensed" style='font-size:10pt;'>
|
|
<tbody>
|
|
<thead>
|
|
<tr>
|
|
<th style='text-align:center' width="30%">Entrez les paramètres<?= _("Paramètres") ?> </th>
|
|
<th style='text-align:center' width="15%"> Types </th>
|
|
<th > <?= _("Valeurs") ?> </th>
|
|
</tr>
|
|
</thead>
|
|
|
|
|
|
<?php foreach ($paramrequetes as $paramrequete):
|
|
$parametre = $this->nettoyer($paramrequete['parametre']);
|
|
$libelle = $this->nettoyer($paramrequete['libelle']);
|
|
$typeDonnee = $paramrequete['typeDonnee'];
|
|
|
|
$typeDate = (substr($typeDonnee,0,3)=="dat");
|
|
|
|
$tab_numeric = array("bigint", "decimal", "int", "smallint", "tinyint", "float");
|
|
$typeNumeric = in_array($typeDonnee, $tab_numeric);
|
|
|
|
//highlight_string("<?php\n\$datas =\n" . var_export($paramrequete['parametre'] , true) . ";\n>");
|
|
|
|
?>
|
|
<tr valign="top">
|
|
<td align='center'> <INPUT style='font-size:10pt; text-align:center;' class="form-control" TYPE="text" value="<?= $libelle ?>" disabled ></td>
|
|
<td align='center'> <INPUT style='font-size:10pt; text-align:center;' class="form-control" TYPE="text" value="<?= $typeDonnee ?>" disabled ></td>
|
|
|
|
<td>
|
|
<?php if($typeDate): ?>
|
|
<INPUT style='font-size:10pt;' class="form-control datepicker" TYPE="text" id="<?= $parametre ?>" NAME="<?= $parametre ?>" Value="<?= date('Y-m-d') ?>" required AUTOCOMPLETE="OFF" >
|
|
<?php elseif($paramrequete['parametre']=='p_garant'): ?>
|
|
<select class="form-select " data-live-search="true" id="codeGcAssureur" NAME="codeGcAssureur" required AUTOCOMPLETE="OFF" onChange="javascript:filtrespolicegarant()"style='font-size:10pt;'>
|
|
<?php
|
|
foreach ($garants as $garant):
|
|
echo '<option value="'. $garant['code'] .'" >'.$garant['libelle'].'</option>';
|
|
//$_SESSION['garantStat']=$garant['code'];
|
|
?>
|
|
<?php endforeach;
|
|
?>
|
|
</SELECT>
|
|
<!-- <INPUT style='font-size:10pt;' class="form-control" TYPE="number" id="<?= $parametre ?>" NAME="<?= $parametre ?>" Value="0">-->
|
|
<?php elseif($paramrequete['parametre']=='p_idPolice'): ?>
|
|
<div id="div_policegarant">
|
|
<SELECT style="font-size:10pt;" class="form-control selectpicker" data-live-search="true" id="idPolice" NAME="idPolice">
|
|
<?php liste_options($polices,$_SESSION['idPoliceStat'],true);
|
|
// $_SESSION['idPoliceStat']=$police['code'];
|
|
?>
|
|
</SELECT>
|
|
</div>
|
|
<!-- <INPUT style='font-size:10pt;' class="form-control" TYPE="number" id="<?= $parametre ?>" NAME="<?= $parametre ?>" Value="0"> -->
|
|
<?php else: ?>
|
|
|
|
<INPUT style='font-size:10pt;' class="form-control" TYPE="text" id="<?= $parametre ?>" NAME="<?= $parametre ?>" Value="0" required AUTOCOMPLETE="OFF">
|
|
<?php endif; ?>
|
|
|
|
<td>
|
|
</td>
|
|
</td>
|
|
</tr>
|
|
|
|
|
|
<?php endforeach; ?>
|
|
|
|
|
|
<?php
|
|
//highlight_string("<?php\n\$datas =\n" . var_export($_SESSION , true) . ";\n>");
|
|
$codeRequete = $_SESSION['codeRequete'];
|
|
if($codeRequete == 'vitalis0029'|| $codeRequete == 'vitalis0042'|| $codeRequete == 'vitalis0043' || $codeRequete == 'vitalis0058' ){
|
|
?>
|
|
<tr>
|
|
<td colspan="3"> <button style='font-size:10pt;' type="button" class="form-control btn btn-info" onclick="javascript:executer_etat_persopdf();"> <?= _("Executer") ?> </button> </td>
|
|
</tr>
|
|
<?php
|
|
}else{
|
|
?>
|
|
<tr>
|
|
<td colspan="3"> <input style='text-align:center; font-size:11pt; background-color:green;color:white;' class="form-control" type="text" value="<?= _("Pour ne pas dégrader les performances, il est préférable de limiter le nombre de colonnes de vos requétes à 10 miximum!") ?>" disabled > </td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td colspan="3"> <button style='font-size:10pt;' type="button" class="form-control btn btn-primary" onclick="javascript:executer_etat_perso();"> <?= _("Exporter vers Excel...") ?> </button> </td>
|
|
</tr>
|
|
<tr>
|
|
<td colspan="3"> <button style='font-size:10pt;' type="button" class="form-control btn btn-danger" onclick="javascript:executer_etat_persopdf();"> <?= _("Exporter vers Pdf...") ?> </button> </td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
</form>
|
|
<div id="div_detail_requete">
|
|
</div>
|
|
|
|
<div id="div_export_a">
|
|
</div>
|
|
</div>
|