/[drupal]/contributions/modules/storm/stormnote/stormnote.module
ViewVC logotype

Diff of /contributions/modules/storm/stormnote/stormnote.module

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.6.4.5, Wed Jul 23 19:37:49 2008 UTC revision 1.6.4.6, Fri Aug 1 08:15:10 2008 UTC
# Line 1  Line 1 
1  <?php  <?php
2  // $Id: stormnote.module,v 1.6.4.4 2008/07/23 14:27:03 robertogerola Exp $  // $Id: stormnote.module,v 1.6.4.5 2008/07/23 19:37:49 robertogerola Exp $
3    
4  /**  /**
5   * @file   * @file
# Line 109  function stormnote_access_sql($sql, $whe Line 109  function stormnote_access_sql($sql, $whe
109    return storm_rewrite_sql($sql, $where);    return storm_rewrite_sql($sql, $where);
110  }  }
111    
112  function stormnote_storm_rewrite_where_sql($query, $primary_table='n', $account = NULL) {  function stormnote_storm_rewrite_where_sql($query, $primary_table, $account) {
113    static $conds = array();    static $conds = array();
114    
   if (!$account) {  
     global $user;  
     $account = $user;  
   }  
   
115    if ($conds[$account->uid]) {    if ($conds[$account->uid]) {
116      return $conds[$account->uid];      return $conds[$account->uid];
117    }    }
# Line 135  function stormnote_storm_rewrite_where_s Line 130  function stormnote_storm_rewrite_where_s
130      }      }
131      if (user_access('Storm note: view of user organization', $account)) {      if (user_access('Storm note: view of user organization', $account)) {
132        if ($cond) $cond .= ' OR ';        if ($cond) $cond .= ' OR ';
133        $cond .= 'sno1.organization_nid='. $account->stormorganization_nid;        $cond .= ' sno1.organization_nid='. $account->stormorganization_nid;
134      }      }
135      if ($cond) {      if ($cond) {
136        $cond = "WHEN 'stormnote' THEN (SELECT IF($cond,1,0) FROM {stormnote} sno1 WHERE sno1.vid=${primary_table}.vid) ";        $cond = " WHEN 'stormnote' THEN (SELECT IF($cond,1,0) FROM {stormnote} sno1 WHERE sno1.vid=${primary_table}.vid) ";
137      }      }
138      else {      else {
139        $cond = "WHEN 'stormnote' THEN 0 ";        $cond = " WHEN 'stormnote' THEN 0 ";
140      }      }
141    }    }
142    
# Line 343  function stormnote_update($node) { Line 338  function stormnote_update($node) {
338  }  }
339    
340  function _stormnote_beforesave(&$node) {  function _stormnote_beforesave(&$node) {
341    $s = "SELECT n.title    $s = "SELECT n.title FROM {node} n INNER JOIN {stormorganization} o ON n.nid=o.nid
         FROM {node} n INNER JOIN {stormorganization} o ON n.nid=o.nid  
342          WHERE type='stormorganization' AND n.nid=%d";          WHERE type='stormorganization' AND n.nid=%d";
343    $r = db_query($s, $node->organization_nid);    $r = db_query($s, $node->organization_nid);
344    $o = db_fetch_object($r);    $o = db_fetch_object($r);
345    $node->organization_title = $o->title;    $node->organization_title = $o->title;
346    
347    $s = "SELECT n.title    $s = "SELECT n.title FROM {node} n INNER JOIN {stormproject} p ON n.nid=p.nid
         FROM {node} n INNER JOIN {stormproject} p ON n.nid=p.nid  
348          WHERE type='stormproject' AND n.nid=%d";          WHERE type='stormproject' AND n.nid=%d";
349    $r = db_query($s, $node->project_nid);    $r = db_query($s, $node->project_nid);
350    $p = db_fetch_object($r);    $p = db_fetch_object($r);
351    $node->project_title = $p->title;    $node->project_title = $p->title;
352    
353    $s = "SELECT n.title    $s = "SELECT n.title FROM {node} n INNER JOIN {stormtask} p ON n.nid=p.nid
         FROM {node} n INNER JOIN {stormtask} p ON n.nid=p.nid  
354          WHERE type='stormtask' AND n.nid=%d";          WHERE type='stormtask' AND n.nid=%d";
355    $r = db_query($s, $node->task_nid);    $r = db_query($s, $node->task_nid);
356    $t = db_fetch_object($r);    $t = db_fetch_object($r);
Legend:
Removed from v.1.6.4.5  
changed lines
  Added in v.1.6.4.6
  ViewVC Help
Powered by ViewVC 1.1.2