Révision 6f1fe10c
| plugins/anet_epacks/front/plugin_anet_epacks.verif_contract_epack.php | ||
|---|---|---|
| 22 | 22 |
|
| 23 | 23 |
print "<div style=\"text-align:left\">"; |
| 24 | 24 |
|
| 25 |
$automatique = ""; |
|
| 26 |
$manuel = ""; |
|
| 27 |
|
|
| 25 | 28 |
$query = "SELECT FK_enduser,code FROM glpi_plugin_anet_epacks WHERE FK_contract='0' AND FK_enduser>'0'"; |
| 26 | 29 |
$result = $DB->query($query); |
| 27 | 30 |
//print $query; |
| ... | ... | |
| 41 | 44 |
|
| 42 | 45 |
if(trim($data2['name'])) {
|
| 43 | 46 |
$query3 = "UPDATE glpi_plugin_anet_epacks SET FK_contract='" . $data2['ID'] . "' WHERE FK_enduser='$enduser' AND FK_contract='0'"; |
| 44 |
print "<p>Recollement automatique pour $code -> $clientfinal -> nouvelle ref contrat: " . $data2['ID'] . "</p>";
|
|
| 47 |
$automatique .= "<p>Recollement automatique pour $code -> $clientfinal -> nouvelle ref contrat: " . $data2['ID'] . "</p>";
|
|
| 45 | 48 |
$result3 = $DB->query($query3); |
| 46 | 49 |
$data3=$DB->fetch_array($result3); |
| 47 | 50 |
} |
| 48 | 51 |
else {
|
| 49 |
print "<p><b>Vérification manuelle nécessaire</b> pour epack ref $code client final $clientfinal (ref $enduser) qui n'a aucune référence de contrat en recollement automatique (" . $data2['ID'] . ")</p>";
|
|
| 52 |
$manuel .= "<tr><td>$code</td><td>$clientfinal</td><td>$enduser</td><td>" . $data2['ID'] . "</td></tr>\n";
|
|
| 50 | 53 |
} |
| 51 | 54 |
} |
| 52 | 55 |
|
| 56 |
print "<h4>Recollage automatique :</h4>"; |
|
| 57 |
|
|
| 58 |
print $automatique; |
|
| 59 |
|
|
| 60 |
print "<h4>Recollage manuel à faire ou à vérifier :</h4>"; |
|
| 61 |
|
|
| 62 |
print "<table> |
|
| 63 |
<tr> |
|
| 64 |
<td>epack</td> |
|
| 65 |
<td>client final</td> |
|
| 66 |
<td>ref</td> |
|
| 67 |
<td>recollement auto</td> |
|
| 68 |
</tr> |
|
| 69 |
"; |
|
| 70 |
print $manuel; |
|
| 71 |
|
|
| 72 |
print "</table>"; |
|
| 73 |
|
|
| 53 | 74 |
//$query = "UPDATE `glpi_users` SET FK_entities='1' WHERE `FK_entities` = 0 AND email NOT LIKE '%ryxeo.com'"; |
| 54 | 75 |
//$result = $DB->query($query); |
| 55 | 76 |
|
Formats disponibles : Unified diff