| Line 14... |
Line 14... |
| 14 |
// | annuaire_COTISATION |
|
14 |
// | annuaire_COTISATION |
|
| 15 |
// +--------------------------------------------------------------------------------+
|
15 |
// +--------------------------------------------------------------------------------+
|
| 16 |
// | Auteur : Alexandre Granier <alexandre@tela-botanica.org> |
|
16 |
// | Auteur : Alexandre Granier <alexandre@tela-botanica.org> |
|
| 17 |
// +--------------------------------------------------------------------------------+
|
17 |
// +--------------------------------------------------------------------------------+
|
| 18 |
//
|
18 |
//
|
| 19 |
// $Id: admin_annu.php,v 1.1.1.1 2005-01-03 17:27:49 alex Exp $
|
19 |
// $Id: admin_annu.php,v 1.2 2005-03-24 08:24:39 alex Exp $
|
| Line 20... |
Line -... |
| 20 |
|
- |
|
| 21 |
include "php/lib/pack.lib.gen.php" ;
|
- |
|
| Line 22... |
Line 20... |
| 22 |
global $HTTP_HOST ;
|
20 |
|
| Line 23... |
Line 21... |
| 23 |
|
21 |
|
| 24 |
define ("URL_RECU", "http://www.tela-botanica.org/modules/client/annuaire/voir_recu_pdf.php") ;
|
- |
|
| Line 25... |
Line 22... |
| 25 |
|
22 |
global $HTTP_HOST ;
|
| 26 |
include_once ("php/auth_object_login.php") ;
|
- |
|
| 27 |
include_once ("php/auth.php") ;
|
- |
|
| 28 |
|
- |
|
| 29 |
include_once ("HTML/Table.php") ;
|
- |
|
| 30 |
|
- |
|
| 31 |
class auth_annu extends authLoginClass {
|
- |
|
| 32 |
//============================================================================
|
- |
|
| 33 |
// ENTRY dumpLoginForm ($errorMsg = '')
|
- |
|
| 34 |
//
|
- |
|
| 35 |
// Build the login form, with an error message.
|
- |
|
| 36 |
// This method calls the overloadable methods buildLoginLabel,
|
- |
|
| 37 |
// buildLoginLabel, buildMessage and buildErrorMessage (with $errorMsg as
|
- |
|
| 38 |
// argument).
|
- |
|
| 39 |
// Note that $errorMsg is supposed to be an HTML string.
|
- |
|
| 40 |
//============================================================================
|
- |
|
| 41 |
|
- |
|
| 42 |
function dumpLoginForm ($errorMsg = '') {
|
- |
|
| 43 |
|
- |
|
| 44 |
global $GS_GLOBAL, $u_id ;
|
- |
|
| 45 |
|
- |
|
| 46 |
// l'url de la page en cours
|
- |
|
| 47 |
$url = "document.php".
|
23 |
|
| 48 |
"?project=".$GS_GLOBAL['project'].
|
- |
|
| 49 |
"&locale=".$GS_GLOBAL['locale'].
|
- |
|
| 50 |
"&doc=".$GS_GLOBAL['document_row']->D_NAME.
|
- |
|
| 51 |
"&page=".$GS_GLOBAL['current_page_ndx'];
|
- |
|
| 52 |
|
- |
|
| 53 |
$prjLabel = "Administration de l'annuaire" ;
|
- |
|
| 54 |
|
- |
|
| 55 |
$loginLabel = $this->buildLoginLabel ();
|
- |
|
| 56 |
$pwdLabel = $this->buildPasswordLabel ();
|
- |
|
| 57 |
|
- |
|
| 58 |
$outputText = '';
|
- |
|
| 59 |
|
- |
|
| 60 |
//--------------------------------------------------------------------------
|
- |
|
| 61 |
// Spacing.
|
- |
|
| 62 |
|
- |
|
| 63 |
$outputText .= "\n".' <TR>';
|
- |
|
| 64 |
$outputText .= "\n".' <TD><IMG src="Local/vide.gif" alt="" width="1" height="10"></TD>';
|
- |
|
| 65 |
$outputText .= "\n".' </TR>';
|
- |
|
| 66 |
|
- |
|
| 67 |
//--------------------------------------------------------------------------
|
- |
|
| 68 |
// Message ?
|
- |
|
| 69 |
|
- |
|
| 70 |
$outputText .= $this->buildMessage ();
|
- |
|
| 71 |
|
- |
|
| 72 |
//--------------------------------------------------------------------------
|
- |
|
| 73 |
// The form itself.
|
- |
|
| 74 |
$outputText .= "<tr class=\"titlePage\"><td>Administration de l'annuaire de Tela Botanica</td></tr>\n" ;
|
- |
|
| 75 |
$outputText .= "<tr><td> </td></tr>\n" ;
|
- |
|
| 76 |
$outputText .= "<tr class=\"insTitle1\"><td>Identifiez-vous</td></tr>" ;
|
- |
|
| 77 |
$outputText .= "<tr class=\"texte_tb\"><td>Cette fonction est réservée aux administrateurs de Tela Botanica. Elle permet de visualiser
|
- |
|
| 78 |
l'ensemble des adhérents et de faire des ajouts, suppression, modifications. :" ;
|
- |
|
| 79 |
$outputText .= "<tr align=\"center\"><td>" ;
|
- |
|
| 80 |
$outputText .= "</td></tr>" ;
|
- |
|
| 81 |
$outputText .= "<tr><td> </td></tr>\n" ;
|
- |
|
| 82 |
$outputText .= "\n".' <TR>';
|
- |
|
| 83 |
$outputText .= "\n".' <TD>';
|
- |
|
| 84 |
$outputText .= "\n".' <FORM name="loginform" action="'.$this->scriptURL_.'" method="post">';
|
- |
|
| 85 |
$outputText .= "\n".' <TABLE border="0" cellpadding="0" cellspacing="5" summary="" align="center">';
|
- |
|
| 86 |
$outputText .= "\n".' <TR>';
|
- |
|
| 87 |
$outputText .= "\n".' <TD class="insLabel">'.$loginLabel.' : </TD>';
|
- |
|
| 88 |
$outputText .= "\n".' <TD class="authFormInput"><INPUT';
|
- |
|
| 89 |
$outputText .= "\n".' tabindex="1" class="insInputForm" type="text" name="auth_login" size="32" maxlength="64"></TD>';
|
- |
|
| 90 |
$outputText .= "\n".' <TD rowspan="2"><IMG src="Local/vide.gif" alt="" width="20" height="1"></TD>';
|
- |
|
| 91 |
$outputText .= "\n".' <TD rowspan="2"><INPUT class="text" tabindex="3" type="submit" value="Valider"></TD>';
|
- |
|
| 92 |
$outputText .= "\n".' </TR>';
|
- |
|
| 93 |
$outputText .= "\n";
|
- |
|
| 94 |
$outputText .= "\n".' <TR>';
|
- |
|
| 95 |
$outputText .= "\n".' <TD class="insLabel">'.$pwdLabel.' : </TD>';
|
- |
|
| 96 |
$outputText .= "\n".' <TD class="authFormInput"><INPUT';
|
- |
|
| 97 |
$outputText .= "\n".' tabindex="2" class="insInputForm" type="password" name="auth_pwd" size="20" maxlength="32"></TD>';
|
- |
|
| 98 |
$outputText .= "\n".' <TD class="authFormInput">';
|
- |
|
| 99 |
$outputText .= "\n".' </TD>';
|
- |
|
| 100 |
$outputText .= "\n".' </TR>';
|
- |
|
| 101 |
|
- |
|
| 102 |
$outputText .= $this->baseHidden ();
|
- |
|
| 103 |
$outputText .= "<input type=\"hidden\" name=\"u_id\" value=\"$u_id\">\n" ;
|
- |
|
| 104 |
$outputText .= "\n".' </TABLE>';
|
- |
|
| 105 |
|
- |
|
| 106 |
$outputText .= "\n".' </FORM>';
|
- |
|
| 107 |
$outputText .= "\n".' </TD>';
|
- |
|
| 108 |
$outputText .= "\n".' </TR>';
|
- |
|
| 109 |
|
- |
|
| 110 |
//--------------------------------------------------------------------------
|
- |
|
| 111 |
// Error message ?
|
- |
|
| 112 |
|
- |
|
| 113 |
$outputText .= $this->buildErrorMessage ($errorMsg);
|
- |
|
| 114 |
|
- |
|
| 115 |
//--------------------------------------------------------------------------
|
- |
|
| 116 |
// Spacing.
|
- |
|
| 117 |
|
- |
|
| 118 |
$outputText .= "\n".' <TR>';
|
- |
|
| 119 |
$outputText .= "\n".' <TD><IMG src="Local/vide.gif" alt="" width="1" height="10"></TD>';
|
- |
|
| 120 |
$outputText .= "\n".' </TR>';
|
- |
|
| 121 |
|
- |
|
| Line 122... |
Line 24... |
| 122 |
return $outputText;
|
24 |
define ("URL_RECU", $GLOBALS['ann_url']->protocol. '://'.$GLOBALS['ann_url']->host."/client/annuaire/voir_recu_pdf.php") ;
|
| 123 |
|
25 |
|
| Line 124... |
Line 26... |
| 124 |
}
|
26 |
include_once ("HTML/Table.php") ;
|
| 125 |
}
|
27 |
include_once 'api/formulaire/FORM_formulaire.class.php' ;
|
| 126 |
|
28 |
|
| 127 |
// admin_annu est une application cliente de gsite elle commence donc
|
- |
|
| 128 |
// dans une fonction putFrame()
|
- |
|
| 129 |
|
- |
|
| 130 |
|
29 |
// admin_annu est une application cliente de gsite elle commence donc
|
| 131 |
function putFrame()
|
- |
|
| 132 |
{
|
- |
|
| 133 |
global $u_id, $cotisation_id ;
|
- |
|
| 134 |
global $link ;
|
- |
|
| 135 |
global $GS_GLOBAL ;
|
- |
|
| 136 |
global $doc ;
|
- |
|
| 137 |
global $action ;
|
- |
|
| 138 |
|
- |
|
| 139 |
$loginObj = new auth_annu ();
|
- |
|
| 140 |
$loginObj->args_['auth_field_login'] = 'U_MAIL';
|
30 |
// dans une fonction putFrame()
|
| 141 |
|
- |
|
| 142 |
if (!gs_manageAuthWithObject ($GS_GLOBAL['mysql_db'], $GS_GLOBAL['link'], $loginObj, &$outputText)) {
|
- |
|
| 143 |
$res = $outputText ;
|
- |
|
| 144 |
} else {
|
- |
|
| Line 145... |
Line 31... |
| 145 |
|
31 |
|
| 146 |
global $u_id ;
|
- |
|
| 147 |
global $link ;
|
- |
|
| Line 148... |
Line 32... |
| 148 |
global $GS_GLOBAL ;
|
32 |
|
| 149 |
global $doc ;
|
- |
|
| Line 150... |
Line 33... |
| 150 |
global $action ;
|
33 |
function putFrame()
|
| Line 151... |
Line 34... |
| 151 |
|
34 |
{
|
| 152 |
|
35 |
global $u_id, $cotisation_id ;
|
| 153 |
if (empty($action)) $action = false ;
|
36 |
global $action ;
|
| Line 154... |
Line -... |
| 154 |
if (empty($GS_GLOBAL['doc'])) $GS_GLOBAL['doc'] = $doc ;
|
- |
|
| 155 |
if (empty($GS_GLOBAL['page'])) $GS_GLOBAL['page'] = "" ;
|
37 |
global $link ;
|
| Line 156... |
Line 38... |
| 156 |
|
38 |
|
| 157 |
$url = "document.php?project=".$GS_GLOBAL['project']."&locale=".$GS_GLOBAL['locale']."&set=" ;
|
39 |
if (empty($action)) $action = false ;
|
| 158 |
$url .= $GS_GLOBAL['set']."&doc=".$GS_GLOBAL['doc']."&page=".$GS_GLOBAL['page']."&u_id=$u_id" ;
|
40 |
|
| 159 |
|
41 |
$url = $GLOBALS['ann_url']->getURL() ;
|
| 160 |
// mise à jour si il y lieu
|
42 |
|
| 161 |
|
43 |
// mise à jour si il y lieu
|
| 162 |
if ($action == "up") {
|
44 |
|
| 163 |
upSQL() ;
|
45 |
if ($action == "up") {
|
| 164 |
}
|
46 |
upSQL() ;
|
| 165 |
|
47 |
}
|
| 166 |
|
48 |
|
| Line 167... |
Line -... |
| 167 |
// Requete de pour récupérer toutes les infos d'un usager
|
- |
|
| 168 |
|
- |
|
| 169 |
$query = "select annuaire_tela.*,annuaire_LABEL_ACT.*,annuaire_LABEL_ASS.*,gen_COUNTRY.GC_NAME" ;
|
- |
|
| 170 |
$query .= ", annuaire_LABEL_NIV.*, annuaire_LABEL_STATUT.*" ;
|
49 |
// Requete de pour récupérer toutes les infos d'un usager
|
| Line 171... |
Line 50... |
| 171 |
$query .= " from annuaire_tela,gen_COUNTRY,gen_FRENCH_DPT," ;
|
50 |
|
| Line 172... |
Line -... |
| 172 |
$query .= " annuaire_LABEL_ACT,annuaire_LABEL_ASS, annuaire_LABEL_NIV, annuaire_LABEL_STATUT" ;
|
- |
|
| 173 |
$query .= " where U_ID=$u_id" ;
|
51 |
$query = "select annuaire_tela.*,annuaire_LABEL_ACT.*,annuaire_LABEL_ASS.*,gen_COUNTRY.GC_NAME" ;
|
| 174 |
$query .= " and annuaire_tela.U_FRENCH_DPT=gen_FRENCH_DPT.GFD_ID" ;
|
- |
|
| 175 |
$query .= " and annuaire_tela.U_COUNTRY=gen_COUNTRY.GC_ID" ;
|
52 |
$query .= ", annuaire_LABEL_NIV.*, annuaire_LABEL_STATUT.*" ;
|
| 176 |
$query .= " and annuaire_tela.U_ACT=annuaire_LABEL_ACT.ID_LABEL_ACT" ;
|
53 |
$query .= " from annuaire_tela,gen_COUNTRY,gen_FRENCH_DPT," ;
|
| 177 |
$query .= " and annuaire_tela.U_ASS=annuaire_LABEL_ASS.ID_LABEL_ASS" ;
|
54 |
$query .= " annuaire_LABEL_ACT,annuaire_LABEL_ASS, annuaire_LABEL_NIV, annuaire_LABEL_STATUT" ;
|
| 178 |
$query .= " and annuaire_tela.U_NIV=annuaire_LABEL_NIV.ID_LABEL_NIV" ;
|
55 |
$query .= " where U_ID=$u_id" ;
|
| 179 |
$query .= " and annuaire_tela.U_SHOW=annuaire_LABEL_STATUT.ID_LABEL_STATUT" ;
|
56 |
//$query .= " and annuaire_tela.U_FRENCH_DPT=gen_FRENCH_DPT.GFD_ID" ;
|
| 180 |
|
57 |
$query .= " and annuaire_tela.U_COUNTRY=gen_COUNTRY.GC_ID" ;
|
| 181 |
|
58 |
$query .= " and annuaire_tela.U_ACT=annuaire_LABEL_ACT.ID_LABEL_ACT" ;
|
| 182 |
|
59 |
$query .= " and annuaire_tela.U_ASS=annuaire_LABEL_ASS.ID_LABEL_ASS" ;
|
| 183 |
|
60 |
$query .= " and annuaire_tela.U_NIV=annuaire_LABEL_NIV.ID_LABEL_NIV" ;
|
| 184 |
$result = mysql_query($query) or die("Echec de la requete sur annu_USERS:<br>".mysql_error($GS_GLOBAL['link'])) ;
|
61 |
$query .= " and annuaire_tela.U_SHOW=annuaire_LABEL_STATUT.ID_LABEL_STATUT" ;
|
| 185 |
|
62 |
|
| 186 |
$row = mysql_fetch_object($result) ;
|
63 |
$result = mysql_query($query) or die("Echec de la requete sur ".ANN_ANNUAIRE.":<br>".mysql_error().'<br>'.$query) ;
|
| 187 |
|
64 |
|
| 188 |
|
65 |
$row = mysql_fetch_object($result) ;
|
| 189 |
$res = "<tr class=\"titlePage\"><td>Edition d'un adhérent : $row->U_NAME $row->U_SURNAME</td></tr>\n" ;
|
66 |
|
| 190 |
$res .= "<tr><td> </td></tr>\n" ;
|
67 |
$res = "<h1>Edition d'un adhérent : $row->U_NAME $row->U_SURNAME</h1>\n" ;
|
| 191 |
$res .= "<tr class=\"texte_tb\"><td>".form("Nom : ", "U_NAME", $row->U_NAME)."</td></tr>\n" ;
|
68 |
$res .= "<div>".form("Nom : ", "U_NAME", $row->U_NAME)."</div>\n" ;
|
| 192 |
$res .= "<tr class=\"texte_tb\"><td>".form("Prénom : ", "U_SURNAME", $row->U_SURNAME)."</td></tr>\n" ;
|
69 |
$res .= "<div>".form("Prénom : ", "U_SURNAME", $row->U_SURNAME)."</div>\n" ;
|
| 193 |
$res .= "<tr class=\"texte_tb\"><td>".form("Adresse mail : ", "U_MAIL", $row->U_MAIL)."</td></tr>\n" ;
|
70 |
$res .= "<div>".form("Adresse mail : ", "U_MAIL", $row->U_MAIL)."</div>\n" ;
|
| 194 |
$res .= "<tr class=\"texte_tb\"><td>".form("Date d'inscription : ", "U_DATE", $row->U_DATE)."</td></tr>\n" ;
|
71 |
$res .= "<div>".form("Date d'inscription : ", "U_DATE", $row->U_DATE)."</div>\n" ;
|
| - |
|
72 |
$res .= "<div>".form("Adresse 1 : ", "U_ADDR1", $row->U_ADDR1)."</div>\n" ;
|
| 195 |
$res .= "<tr class=\"texte_tb\"><td>".form("Adresse 1 : ", "U_ADDR1", $row->U_ADDR1)."</td></tr>\n" ;
|
73 |
$res .= "<div>".form("Adresse 2 : ", "U_ADDR2", $row->U_ADDR2)."</div>\n" ;
|
| 196 |
$res .= "<tr class=\"texte_tb\"><td>".form("Adresse 2 : ", "U_ADDR2", $row->U_ADDR2)."</td></tr>\n" ;
|
74 |
$res .= "<div>".form("Région : ", "U_STATE", $row->U_STATE)."</div>\n" ;
|
| 197 |
$res .= "<tr class=\"texte_tb\"><td>".form("Région : ", "U_STATE", $row->U_STATE)."</td></tr>\n" ;
|
75 |
$res .= "<div>".form("Code postal : ", "U_ZIP_CODE", $row->U_ZIP_CODE)."</div>\n" ;
|
| 198 |
$res .= "<tr class=\"texte_tb\"><td>".form("Code postal : ", "U_ZIP_CODE", $row->U_ZIP_CODE)."</td></tr>\n" ;
|
76 |
$res .= "<div>".form("Ville : ", "U_CITY", $row->U_CITY)."</div>\n" ;
|
| Line 199... |
Line 77... |
| 199 |
$res .= "<tr class=\"texte_tb\"><td>".form("Ville : ", "U_CITY", $row->U_CITY)."</td></tr>\n" ;
|
77 |
$res .= "<div>".form("Pays : ", "U_COUNTRY", $row->U_COUNTRY)."</div>\n" ;
|
| Line 264... |
Line 142... |
| 264 |
// On incrémente le compteur de mail de 1
|
142 |
// On incrémente le compteur de mail de 1
|
| 265 |
if (!$deja_envoye) {
|
143 |
if (!$deja_envoye) {
|
| 266 |
$num_recu++ ;
|
144 |
$num_recu++ ;
|
| 267 |
mysql_query("update COMPTEUR_COTISATION set COMPTEUR=$num_recu ") ;
|
145 |
mysql_query("update COMPTEUR_COTISATION set COMPTEUR=$num_recu ") ;
|
| 268 |
}
|
146 |
}
|
| 269 |
$res .= "<tr><td> </td></tr>\n" ;
|
- |
|
| 270 |
$res .= "<tr class=\"titlePage\"><td>Le reçu a été envoyé</td></tr>\n" ;
|
147 |
$res .= "<div>Le reçu a été envoyé</div>\n" ;
|
| 271 |
}
|
148 |
}
|
| 272 |
$res .= cotisation($u_id) ;
|
149 |
$res .= cotisation($u_id) ;
|
| 273 |
$res .= suppression($u_id) ;
|
150 |
$res .= suppression($u_id) ;
|
| 274 |
}
|
- |
|
| 275 |
|
- |
|
| 276 |
return $res ;
|
151 |
return $res ;
|
| 277 |
}
|
152 |
}
|
| Line 278... |
Line 153... |
| 278 |
|
153 |
|
| Line 284... |
Line 159... |
| 284 |
|
159 |
|
| 285 |
function form($label, $field_, $value)
|
160 |
function form($label, $field_, $value)
|
| 286 |
{
|
161 |
{
|
| Line 287... |
Line 162... |
| 287 |
global $u_id, $GS_GLOBAL, $field ;
|
162 |
global $u_id, $GS_GLOBAL, $field ;
|
| 288 |
|
- |
|
| Line 289... |
Line 163... |
| 289 |
$url = "document.php?project=".$GS_GLOBAL['project']."&locale=".$GS_GLOBAL['locale']."&set=" ;
|
163 |
|
| 290 |
$url .= $GS_GLOBAL['set']."&doc=".$GS_GLOBAL['doc']."&page=".$GS_GLOBAL['page']."&u_id=$u_id" ;
|
164 |
$url = $GLOBALS['ann_url']->getURL() ;
|
| 291 |
|
165 |
|
| 292 |
if ($field != $field_) {
|
166 |
if ($field != $field_) {
|
| Line 406... |
Line 280... |
| 406 |
}
|
280 |
}
|
| 407 |
}
|
281 |
}
|
| Line 408... |
Line 282... |
| 408 |
|
282 |
|
| 409 |
function getFormInsInfo($field, $value)
|
283 |
function getFormInsInfo($field, $value)
|
| 410 |
{
|
- |
|
| Line 411... |
Line 284... |
| 411 |
global $GS_GLOBAL ;
|
284 |
{
|
| 412 |
|
285 |
|
| 413 |
$query = "select * from annuaire_$field" ;
|
286 |
$query = "select * from annuaire_$field" ;
|
| Line 434... |
Line 307... |
| 434 |
|
307 |
|
| 435 |
function cotisation($u_id)
|
308 |
function cotisation($u_id)
|
| 436 |
{
|
309 |
{
|
| Line 437... |
Line 310... |
| 437 |
global $GS_GLOBAL, $action, $IC_MONTANT, $IC_DATE, $id_cot, $IC_MC_ID ;
|
310 |
global $GS_GLOBAL, $action, $IC_MONTANT, $IC_DATE, $id_cot, $IC_MC_ID ;
|
| 438 |
|
311 |
|
| Line 439... |
Line 312... |
| 439 |
|
312 |
$res = '' ;
|
| 440 |
// un peu de javascript pour la confirmation en cas de destruction
|
313 |
// un peu de javascript pour la confirmation en cas de destruction
|
| 441 |
|
314 |
|
| Line 446... |
Line 319... |
| 446 |
} " ;
|
319 |
} " ;
|
| Line 447... |
Line 320... |
| 447 |
|
320 |
|
| 448 |
// fonction gsite pour inclure la fonction Javascript
|
321 |
// fonction gsite pour inclure la fonction Javascript
|
| Line 449... |
Line 322... |
| 449 |
// au code html
|
322 |
// au code html
|
| Line 450... |
Line 323... |
| 450 |
|
323 |
|
| 451 |
js_register("confirmLink", $outputText) ;
|
- |
|
| Line 452... |
Line 324... |
| 452 |
|
324 |
GEN_stockerCodeScript($outputText) ;
|
| 453 |
$url = "document.php?project=".$GS_GLOBAL['project']."&locale=".$GS_GLOBAL['locale']."&set=" ;
|
325 |
|
| Line 454... |
Line 326... |
| 454 |
$url .= $GS_GLOBAL['set']."&doc=".$GS_GLOBAL['doc']."&page=".$GS_GLOBAL['page']."&u_id=$u_id" ;
|
326 |
$url = $GLOBALS['ann_url']->getURL() ;
|
| Line 486... |
Line 358... |
| 486 |
// les cotisations d'un inscrit et on les affiche sous forme de
|
358 |
// les cotisations d'un inscrit et on les affiche sous forme de
|
| 487 |
// table HTML
|
359 |
// table HTML
|
| Line 488... |
Line 360... |
| 488 |
|
360 |
|
| 489 |
$query = "select * from annuaire_COTISATION, MODE_COTISATION where IC_ANNU_ID=$u_id
|
361 |
$query = "select * from annuaire_COTISATION, MODE_COTISATION where IC_ANNU_ID=$u_id
|
| 490 |
and IC_MC_ID=MC_ID" ;
|
362 |
and IC_MC_ID=MC_ID" ;
|
| 491 |
$result = mysql_query($query) or die ("Echec de la requete sur annuaire_COTISATION") ;
|
363 |
$result = mysql_query($query) or die ("Echec de la requete sur annuaire_COTISATION<br>".$query) ;
|
| 492 |
$res = "<tr><td> </td></tr>\n" ;
|
- |
|
| Line 493... |
Line 364... |
| 493 |
$res .= "<tr class=\"insTitle1\"><td><b>Etat des cotisations : </b></td></tr>" ;
|
364 |
$res = "<h1>Etat des cotisations : </h1>" ;
|
| 494 |
|
365 |
|
| Line 500... |
Line 371... |
| 500 |
// annuaire_COTISATION. Si elle est présente on affiche un formulaire
|
371 |
// annuaire_COTISATION. Si elle est présente on affiche un formulaire
|
| 501 |
// de modification
|
372 |
// de modification
|
| Line 502... |
Line 373... |
| 502 |
|
373 |
|
| Line 503... |
Line 374... |
| 503 |
if ($action == "sc") {
|
374 |
if ($action == "sc") {
|
| 504 |
|
375 |
|
| 505 |
$res .= "<tr class=\"texte_tb\"><td><form action=\"$url&action=cu\" method=\"post\"><b>Date : </b>" ;
|
376 |
$res .= "<div><form action=\"$url&action=cu\" method=\"post\"><b>Date : </b>" ;
|
| 506 |
$res .= "<input type=\"text\" size=\"9\" class=\"insInputForm\" name=\"IC_DATE\" value=\"";
|
377 |
$res .= "<input type=\"text\" size=\"9\" class=\"insInputForm\" name=\"IC_DATE\" value=\"";
|
| 507 |
$res .= $date ;
|
378 |
$res .= $date ;
|
| 508 |
$res .= "\">\n" ;
|
379 |
$res .= "\">\n" ;
|
| 509 |
$res .= "<b>Montant : </b><input type=\"text\" class=\"insInputForm\" size=\"5\" name=\"IC_MONTANT\" value=\"30\"> €\n" ;
|
380 |
$res .= "<b>Montant : </b><input type=\"text\" class=\"insInputForm\" size=\"5\" name=\"IC_MONTANT\" value=\"30\"> €\n" ;
|
| 510 |
$res .= mode_paiement(0) ;
|
381 |
$res .= mode_paiement(0) ;
|
| 511 |
$res .= "<input type=\"submit\" value=\"Valider\" class=\"texte_tb\">\n" ;
|
382 |
$res .= "<input type=\"submit\" value=\"Valider\" class=\"texte_tb\">\n" ;
|
| Line 512... |
Line 383... |
| 512 |
$res .= "<input type=\"button\" value=\"Annuler\" class=\"texte_tb\" onclick=\"javascript:window.location.href='$url';\"></form>\n" ;
|
383 |
$res .= "<input type=\"button\" value=\"Annuler\" class=\"texte_tb\" onclick=\"javascript:window.location.href='$url';\"></form>\n" ;
|
| 513 |
$res .= "</td></tr>\n" ;
|
384 |
$res .= "</div>\n" ;
|
| Line 514... |
Line 385... |
| 514 |
|
385 |
|
| 515 |
// si l'action 'sc' n'est pas active on affiche toutes les lignes
|
386 |
// si l'action 'sc' n'est pas active on affiche toutes les lignes
|
| 516 |
// de cotisation de l'inscrit
|
387 |
// de cotisation de l'inscrit
|
| 517 |
|
388 |
|
| 518 |
} else {
|
389 |
} else {
|
| 519 |
if (mysql_num_rows($result) != 0) {
|
390 |
if (mysql_num_rows($result) != 0) {
|
| 520 |
$res .= "<tr class=\"texte_tb\"><td>" ;
|
391 |
$res .= "<div>" ;
|
| Line 550... |
Line 421... |
| 550 |
"<input type=\"button\" value=\"Annuler\" class=\"texte_tb\" onclick=\"javascript:window.location.href='$url';\"></form>",
|
421 |
"<input type=\"button\" value=\"Annuler\" class=\"texte_tb\" onclick=\"javascript:window.location.href='$url';\"></form>",
|
| 551 |
" ")) ;
|
422 |
" ")) ;
|
| 552 |
}
|
423 |
}
|
| 553 |
}
|
424 |
}
|
| 554 |
$table->altRowAttributes(1, array("class" => "texte_tb2"), array("class" => "text2")) ;
|
425 |
$table->altRowAttributes(1, array("class" => "texte_tb2"), array("class" => "text2")) ;
|
| 555 |
$res .= $table->toHTML()."</td></tr>\n" ;
|
426 |
$res .= $table->toHTML()."</div>\n" ;
|
| 556 |
unset($table) ;
|
427 |
unset($table) ;
|
| 557 |
} else {
|
428 |
} else {
|
| 558 |
$res .= "<tr class=\"texte_tb\"><td>non cotisant</td></tr>\n" ;
|
429 |
$res .= "<div>non cotisant</div>\n" ;
|
| 559 |
}
|
430 |
}
|
| 560 |
$res .= "<tr><td> </td></tr>\n" ;
|
- |
|
| 561 |
$res .= "<tr><td><input type=\"button\" class=\"texte_tb\" " ;
|
431 |
$res .= "<div><input type=\"button\" class=\"texte_tb\" " ;
|
| 562 |
$res .= "value=\"Saisir une cotisation\" onclick=\"javascript:window.location.href='$url&action=sc';\"></td></tr>\n" ;
|
432 |
$res .= "value=\"Saisir une cotisation\" onclick=\"javascript:window.location.href='$url&action=sc';\"></div>\n" ;
|
| 563 |
}
|
433 |
}
|
| Line 564... |
Line 434... |
| 564 |
|
434 |
|
| 565 |
return $res ;
|
435 |
return $res ;
|
| Line 577... |
Line 447... |
| 577 |
} " ;
|
447 |
} " ;
|
| Line 578... |
Line 448... |
| 578 |
|
448 |
|
| 579 |
// fonction gsite pour inclure la fonction Javascript
|
449 |
// fonction gsite pour inclure la fonction Javascript
|
| Line 580... |
Line 450... |
| 580 |
// au code html
|
450 |
// au code html
|
| Line 581... |
Line -... |
| 581 |
|
- |
|
| 582 |
js_register("confirmLink", $outputText) ;
|
451 |
|
| Line 583... |
Line -... |
| 583 |
|
- |
|
| 584 |
$url = "document.php?project=".$GS_GLOBAL['project']."&locale=".$GS_GLOBAL['locale']."&set=" ;
|
452 |
GEN_stockerCodeScript($outputText) ;
|
| 585 |
$url .= $GS_GLOBAL['set']."&doc=".$GS_GLOBAL['doc']."&page=".$GS_GLOBAL['page']."&u_id=$u_id" ;
|
- |
|
| 586 |
|
453 |
|
| 587 |
$res = "<tr><td> </td></tr>\n" ;
|
454 |
$url = $GLOBALS['ann_url']->getURL() ;
|
| 588 |
$res .= "<tr class=\"insTitle1\"><td>Supprimer l'inscription</td></tr>\n" ;
|
455 |
|
| 589 |
$res .= "<tr><td> </td></tr>\n" ;
|
456 |
$res = "<div>Supprimer l'inscription</div>\n" ;
|
| Line 590... |
Line 457... |
| 590 |
$res .="<tr><td><form action=\"$url&action=suppr_adh\" method=\"post\">\n" ;
|
457 |
$res .="<div><form action=\"$url&action=suppr_adh\" method=\"post\">\n" ;
|
| 591 |
$res .= "<input type=\"submit\" class=\"texte_tb\" value=\"Supprimer\" " ;
|
458 |
$res .= "<input type=\"submit\" class=\"texte_tb\" value=\"Supprimer\" " ;
|
| 592 |
$res .= "onclick=\"javascript:return confirmLink(this, 'êtes-vous sûr de vouloir supprimer cet adhérent');\">\n" ;
|
459 |
$res .= "onclick=\"javascript:return confirmLink(this, 'êtes-vous sûr de vouloir supprimer cet adhérent');\">\n" ;
|
| 593 |
$res .= "</form></td></tr>\n" ;
|
460 |
$res .= "</form></div>\n" ;
|