Changeset 982 for trunk/bureau/class/m_admin.php

Timestamp:

04/02/06 21:13:12 (7 years ago)

Author:

joe

Message:

Merge de joe-validation-comptes -> trunk, pour les expirations de comptes.

File:

• trunk/bureau/class/m_admin.php (modified) (5 diffs)

trunk/bureau/class/m_admin.php

@@ -221 +221 @@
    * @param $mail Adresse email du propriétaire du compte, permet de récupérer son mot de passe
    * @param $type Type de compte pour les quotas
+   * @param $duration integer Durée du compte en mois
    * @return boolean Retourne FALSE si une erreur s'est produite, TRUE sinon.
    *
    */
-  function add_mem($login, $pass, $nom, $prenom, $mail, $canpass=1, $type='default') {
+  function add_mem($login, $pass, $nom, $prenom, $mail, $canpass=1, $type='default', $duration=0) {
     global $err,$quota,$classes,$cuid,$mem,$L_MYSQL_DATABASE,$L_MYSQL_LOGIN;
     $err->log("admin","add_mem",$login."/".$mail);
@@ -268 +269 @@
       }
       // on le créé ensuite dans system.membres et system.local
-      $db->query("INSERT INTO membres (uid,login,pass,mail,creator,canpass,type) VALUES ('$uid','$login','$pass','$mail','$cuid','$canpass', '$type');");
+      $db->query("INSERT INTO membres (uid,login,pass,mail,creator,canpass,type,created) VALUES ('$uid','$login','$pass','$mail','$cuid','$canpass', '$type', NOW());");
       $db->query("INSERT INTO local(uid,nom,prenom) VALUES('$uid','$nom','$prenom');");
+      $this->renew_update($uid, $duration);
       exec("/usr/lib/alternc/mem_add ".$login." ".$uid);
       // Declenchons les autres classes.
@@ -316 +318 @@
    * @param $enabled integer vaut 0 ou 1, active ou désactive l'accès au bureau virtuel de ce compte.
    * @param $type string Nouveau type de compte
+   * @param $duration integer Durée du compte en mois
    * @return boolean Retourne FALSE si une erreur s'est produite, TRUE sinon.
    * 
    */
-  function update_mem($uid, $mail, $nom, $prenom, $pass, $enabled, $canpass, $type, $type='default') {
+  function update_mem($uid, $mail, $nom, $prenom, $pass, $enabled, $canpass, $type='default', $duration=0) {
     global $err,$db;
     global $cuid, $quota;
@@ -341 +344 @@
       if($_POST['reset_quotas'] == "on")
         $quota->addquotas();
+      $this->renew_update($uid, $duration);
       return true;
     }
@@ -459 +463 @@
   /* ----------------------------------------------------------------- */
   /**
+   * Renew an account
+   *
+   * Renew an account for its duration
+   *
+   * @param $uid integer the uid number of the account we want to renew
+   * @param $periods integer the number of periods we renew for
+   * @return boolean Returns FALSE if an error occurs, TRUE if not.
+   */
+  function renew_mem($uid, $periods=1) {
+    global $err,$db;
+
+    $query =
+      "UPDATE membres SET renewed = renewed + INTERVAL (duration * $periods) MONTH WHERE uid=${uid};";
+
+    if ($db->query($query)) {
+      return true;
+    } else {
+      $err->raise("admin",2);
+      return false;
+    }
+  }
+
+  /* ----------------------------------------------------------------- */
+  /**
+   * Update the duration information for an account
+   *
+   * @param $uid integer the uid number of the account we want to update
+   * @param $duration integer the new duration, in months, of the account
+   * @return boolean Returns FALSE if an error occurs, TRUE if not.
+   */
+  function renew_update($uid, $duration) {
+    global $err,$db;
+
+    if($duration == 0) {
+      if($db->query("UPDATE membres SET duration = NULL, renewed = NULL WHERE uid=$uid;"))
+        return true;
+    } else {
+      if($db->query("UPDATE membres SET duration = $duration WHERE uid=$uid") &&
+         $db->query("UPDATE membres SET renewed = NOW() WHERE uid=$uid and renewed is null;"))
+        return true;
+    }
+
+    $err->raise("admin",2);
+    return false;
+  }
+
+  /* ----------------------------------------------------------------- */
+  /**
+   *
+   * Get the expiry date for an account
+   *
+   * @param $uid integer The uid number of the account
+   * @return string The expiry date, a string as printed by MySQL
+   */
+  function renew_get_expiry($uid) {
+    global $db;
+
+    $db->query("SELECT renewed + INTERVAL duration MONTH 'expiry' FROM membres WHERE uid='$uid' ;");
+    if ($db->num_rows()) {
+      $db->next_record();
+      return $db->Record['expiry'];
+    }
+
+    return '';
+  }
+
+  /* ----------------------------------------------------------------- */
+  /**
+   *
+   * Get the expiry status for an account
+   *
+   * @param $uid integer The uid number of the account
+   * @return integer The expiry status:
+   *  0: account does not expire
+   *  1: expires in more than duration,
+   *  2: expires within the duration
+   *  3: has expired past the duration
+   */
+  function renew_get_status($uid) {
+    global $db;
+
+    $db->query(
+      "SELECT CASE" .
+      " WHEN duration IS NULL THEN 0" .
+      " WHEN renewed + INTERVAL duration MONTH <= NOW() THEN 3" .
+      " WHEN renewed <= NOW() THEN 2" .
+      " ELSE 1 END 'status' FROM membres where uid=$uid;");
+
+    if($db->num_rows()) {
+      $db->next_record();
+      return $db->Record['status'];
+    }
+
+    return 0;
+  }
+
+  /* ----------------------------------------------------------------- */
+  /**
    * Turns a common account into a super-admin account
    *