taskMiniclick - Tasks: task #7882, Innitialisation de la table CONFIG...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

task #7882: Innitialisation de la table CONFIG et DROIT

Submitter:  Jean-Claude Amiot <ajcsoft>
Submitted:  Tue 25 Mar 2008 02:56:02 PM UTC
 
Should Start On:  Tue 25 Mar 2008 12:00:00 AM UTC Should be Finished on:  Tue 25 Mar 2008 12:00:00 AM UTC
Category:  None Priority:  5 - Normal
Status:  Done Privacy:  Public
Percent Complete:  100% Assigned to:  ajcsoft
Open/Closed:  Open Effort:  0.00

Wed 26 Mar 2008 01:30:01 PM UTC, comment #1: 

la méthode generate_defaut_config() de la classe miniclick.class.php a été modifier pour réaliser des tests sur les champs des tables déjà définis dans la table CONFIG (éviter les doublons), des droits sont automatiquement affectés pour les administrateurs si aucun droit trouvé.

Jean-Claude Amiot <ajcsoft>
Project Administrator
Tue 25 Mar 2008 02:56:02 PM UTC, original submission:  

L'initialisation de la table CONFIG se réalise à travers un croisement de tables CONFIG et DROIT
    $sql_query = "SELECT DISTINCT "
      ." CONFIG.Colonne,Label,Type,IsKey,Value,"
      ."Defaut,Size,Afficher,Total,Wf,Read_Perm,Write_Perm "
      ." FROM CONFIG,DROIT WHERE CONFIG.Module_Id='"
      .$this->module_id."' AND DROIT.Module_Id='"
      .$this->module_id."' AND DROIT.Role_Id='".$_SESSION['role_id']
      ."' AND CONFIG.Colonne = DROIT.Colonne ORDER BY Position";
      $configs = $this->db->db_query($sql_query);
...
    if($this->db->db_num_rows($configs) == 0)
      {
        $this->generate_defaut_config();
      }

Le problème est que la table CONFIG est bien initialisée mais pas la table DROIT ce qui a pour conséquence de créer des doublons dans la table CONFIG à chaque appel du module. 

Jean-Claude Amiot <ajcsoft>
Project Administrator

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by ajcsoft (Submitted the item)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

     

     

     

    Follow 3 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2008-03-31 ajcsoft Assigned toNone ajcsoft
    2008-03-26 ajcsoft StatusNone Done
        Percent Complete0% 100%

    Back to the top

    Powered by Savane 3.10