ryxeo-glpi-git / plugins / anet_epacks / front / plugin_anet_epacks.verif_contract_epack.php @ 8c2a3d1e
Historique | Voir | Annoter | Télécharger (2,72 ko)
1 | e8a2f7fa | Eric Seigne | <?php
|
---|---|---|---|
2 | /*
|
||
3 | * recherche les contrats qui ne sont pas raccrochés aux epacks
|
||
4 | * dans la table glpi_plugin_anet_epacks on a un FK_contract qui doit faire référence au bon contrat.
|
||
5 | * pour mettre à jour on cherche donc les FK_enduser dans glpi_plugin_anet_epacks WHERE FK_contract=0
|
||
6 | * ensuite on cherche si ce FK_enduser existe dans glpi_contracts FK_entities
|
||
7 | * si c'est le cas on met à jour glpi_plugin_anet_epacks
|
||
8 | *
|
||
9 | */
|
||
10 | |||
11 | if(!defined('GLPI_ROOT')){ |
||
12 | define('GLPI_ROOT', '../../..'); |
||
13 | } |
||
14 | include_once (GLPI_ROOT . "/inc/includes.php"); |
||
15 | |||
16 | checkRight("config","w"); |
||
17 | global $DB; |
||
18 | |||
19 | commonHeader("anet_epacks",$_SERVER['PHP_SELF'],"config","plugins"); |
||
20 | |||
21 | print "<h3>Recollage automatique des epacks <-> contrats</h3>\n"; |
||
22 | |||
23 | print "<div style=\"text-align:left\">"; |
||
24 | |||
25 | 6f1fe10c | Eric Seigne | $automatique = ""; |
26 | $manuel = ""; |
||
27 | |||
28 | 8c2a3d1e | Eric Seigne | $query = "SELECT FK_enduser,code FROM glpi_plugin_anet_epacks WHERE (FK_contract='0' OR FK_contract='-1') AND FK_enduser>'0'"; |
29 | e8a2f7fa | Eric Seigne | $result = $DB->query($query); |
30 | //print $query;
|
||
31 | while($data=$DB->fetch_array($result)) { |
||
32 | $enduser=$data[0]; |
||
33 | $code=$data[1]; |
||
34 | |||
35 | $query1 = "SELECT * FROM glpi_entities WHERE ID='" . $enduser . "'"; |
||
36 | $result1 = $DB->query($query1); |
||
37 | $data1=$DB->fetch_array($result1); |
||
38 | $clientfinal = $data1['completename']; |
||
39 | |||
40 | 8c2a3d1e | Eric Seigne | //order by pour prendre le dernier contrat ... si on recolle automatiquement et qu'il y a un ancien contrat il faut recoller avecle plus recent
|
41 | $query2 = "SELECT *,(TO_DAYS(begin_date) + (duration*30)) AS endDay FROM glpi_contracts WHERE FK_entities='" . $enduser . "' AND (TO_DAYS(begin_date) + (duration*30)) > TO_DAYS(NOW()) AND deleted='0' ORDER BY begin_date DESC LIMIT 1"; |
||
42 | //print "<pre>$query2</pre>";
|
||
43 | e8a2f7fa | Eric Seigne | $result2 = $DB->query($query2); |
44 | $data2=$DB->fetch_array($result2); |
||
45 | 8c2a3d1e | Eric Seigne | if(trim($data2['name']) != "") { |
46 | $query3 = "UPDATE glpi_plugin_anet_epacks SET FK_contract='" . $data2['ID'] . "' WHERE FK_enduser='$enduser'"; |
||
47 | //$query3 = "UPDATE glpi_plugin_anet_epacks SET FK_contract='-1' WHERE FK_enduser='$enduser'";
|
||
48 | 6f1fe10c | Eric Seigne | $automatique .= "<p>Recollement automatique pour $code -> $clientfinal -> nouvelle ref contrat: " . $data2['ID'] . "</p>"; |
49 | 8c2a3d1e | Eric Seigne | //print $query3;
|
50 | e8a2f7fa | Eric Seigne | $result3 = $DB->query($query3); |
51 | $data3=$DB->fetch_array($result3); |
||
52 | } |
||
53 | else {
|
||
54 | 8c2a3d1e | Eric Seigne | if(is_array($data2)) { |
55 | $manuel .= "<tr><td>$code</td><td>$clientfinal</td><td>$enduser</td><td>" . $data2['ID'] . "</td></tr>\n"; |
||
56 | } |
||
57 | e8a2f7fa | Eric Seigne | } |
58 | } |
||
59 | |||
60 | 6f1fe10c | Eric Seigne | print "<h4>Recollage automatique :</h4>"; |
61 | |||
62 | print $automatique; |
||
63 | |||
64 | print "<h4>Recollage manuel à faire ou à vérifier :</h4>"; |
||
65 | |||
66 | print "<table> |
||
67 | <tr>
|
||
68 | <td>epack</td>
|
||
69 | <td>client final</td>
|
||
70 | <td>ref</td>
|
||
71 | <td>recollement auto</td>
|
||
72 | </tr>
|
||
73 | ";
|
||
74 | print $manuel; |
||
75 | |||
76 | print "</table>"; |
||
77 | |||
78 | e8a2f7fa | Eric Seigne | //$query = "UPDATE `glpi_users` SET FK_entities='1' WHERE `FK_entities` = 0 AND email NOT LIKE '%ryxeo.com'";
|
79 | //$result = $DB->query($query);
|
||
80 | |||
81 | commonFooter(); |
||
82 | ?> |