Révision 2fa8920c plugins/anet_epacks/front/plugin_anet_epacks.view_endcontract.php
| plugins/anet_epacks/front/plugin_anet_epacks.view_endcontract.php | ||
|---|---|---|
| 44 | 44 |
for($i = 0; $i < $DB->numrows($result); $i++) {
|
| 45 | 45 |
$data=$DB->fetch_array($result); |
| 46 | 46 |
|
| 47 |
$query2="SELECT g.name as clientderyxeo FROM glpi_plugin_anet_epacks AS e LEFT JOIN glpi_entities AS g ON FK_clientderyxeo=g.ID |
|
| 47 |
$query2="SELECT code,g.id as clientderyxeoid,g.name as clientderyxeo FROM glpi_plugin_anet_epacks AS e LEFT JOIN glpi_entities AS g ON FK_clientderyxeo=g.ID
|
|
| 48 | 48 |
LEFT JOIN glpi_contracts AS c ON FK_contract=c.ID |
| 49 | 49 |
WHERE FK_contract= '" . $data['ID'] . "'"; |
| 50 |
//print $query2 . "<br />" . "<br />"; |
|
| 51 |
//$DB->query($query) or die($DB->error()); |
|
| 50 |
// print $query2 . "<br />" . "<br />"; |
|
| 52 | 51 |
$epacks = ""; |
| 53 | 52 |
$result2 = $DB->query($query2); |
| 54 | 53 |
for($j = 0; $j < $DB->numrows($result2); $j++) {
|
| ... | ... | |
| 79 | 78 |
<td>" . $data['duration'] . "</td> |
| 80 | 79 |
<td>" . $epacks . "</td>\n"; |
| 81 | 80 |
print " <td> |
| 82 |
<a href=\"plugin_anet_epacks.generate_odt_courrier_end_contract.form.php?clientid=" . $data['FK_entities'] . "&cid=" . $data['ID'] . "&niveau=courrier_endcontract\">Courrier de fin de maintenance</a><br /> |
|
| 83 |
</td> |
|
| 81 |
<a href=\"plugin_anet_epacks.generate_odt_courrier_end_contract.form.php?clientid=" . $data['FK_entities'] . "&cid=" . $data['ID'] . "&clientderyxeoid=" . $data2['clientderyxeoid'] . "&datefin=" . $data['endcontract'] . "&niveau=courrier_endcontract\">Courrier d'information</a> de fin de maintenance à venir.</td> |
|
| 84 | 82 |
</tr>\n"; |
| 85 | 83 |
} |
| 86 | 84 |
|
Formats disponibles : Unified diff