/[drupal]/contributions/modules/storm/stormnote/stormnote.admin.inc
ViewVC logotype

Diff of /contributions/modules/storm/stormnote/stormnote.admin.inc

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

revision 1.3, Wed Jun 11 12:56:42 2008 UTC revision 1.4, Tue Jul 1 07:47:42 2008 UTC
# Line 1  Line 1 
1  <?php  <?php
2  // $Id: stormnote.admin.inc,v 1.2 2008/05/20 08:11:32 robertogerola Exp $  // $Id: stormnote.admin.inc,v 1.3 2008/06/11 12:56:42 robertogerola Exp $
3    
4  /**  /**
5   * @file   * @file
# Line 67  function stormnote_list() { Line 67  function stormnote_list() {
67      ),      ),
68    );    );
69    
70    $s  = "SELECT n.title, sno.* FROM {stormnote} sno INNER JOIN {node} n ON n.vid=sno.vid WHERE n.status=1 AND n.type='stormnote' ";    $s  = "SELECT n.title, sno.* FROM {node} AS n INNER JOIN {stormnote} AS sno ON n.vid=sno.vid WHERE n.status=1 AND n.type='stormnote' ";
71    
72    if ($_SESSION['stormnote_list_filter']['organization_nid']) {    if ($_SESSION['stormnote_list_filter']['organization_nid']) {
73      $where[] = 'sno.organization_nid='. $_SESSION['stormnote_list_filter']['organization_nid'];      $where[] = 'sno.organization_nid='. $_SESSION['stormnote_list_filter']['organization_nid'];
# Line 78  function stormnote_list() { Line 78  function stormnote_list() {
78    if ($_SESSION['stormnote_list_filter']['task_nid']) {    if ($_SESSION['stormnote_list_filter']['task_nid']) {
79      $where[] = 'sno.task_nid='. $_SESSION['stormnote_list_filter']['task_nid'];      $where[] = 'sno.task_nid='. $_SESSION['stormnote_list_filter']['task_nid'];
80    }    }
81      if ($_SESSION['stormnote_list_filter']['title']) {
82        $where[] = "LOWER(n.title) LIKE LOWER('". $_SESSION['stormnote_list_filter']['title'] ."')";
83      }
84    $itemsperpage = $_SESSION['stormnote_list_filter']['itemsperpage'];    $itemsperpage = $_SESSION['stormnote_list_filter']['itemsperpage'];
85    
86    $tablesort = tablesort_sql($header);    $tablesort = tablesort_sql($header);
87    $sql = stormnote_access_sql($s, $where) . $tablesort;    $s = db_rewrite_sql($s);
88    $r = pager_query($sql, $itemsperpage, 0, NULL);    $s = stormnote_access_sql($s, $where) . $tablesort;
89      $r = pager_query($s, $itemsperpage, 0, NULL);
90    
91    $notes = array();    $notes = array();
92    while ($item = db_fetch_object($r)) {    while ($item = db_fetch_object($r)) {
# Line 98  function stormnote_list_filter() { Line 102  function stormnote_list_filter() {
102    $organization_nid = $_SESSION['stormnote_list_filter']['organization_nid'];    $organization_nid = $_SESSION['stormnote_list_filter']['organization_nid'];
103    $project_nid = $_SESSION['stormnote_list_filter']['project_nid'];    $project_nid = $_SESSION['stormnote_list_filter']['project_nid'];
104    $task_nid = $_SESSION['stormnote_list_filter']['task_nid'];    $task_nid = $_SESSION['stormnote_list_filter']['task_nid'];
105      $title = $_SESSION['stormnote_list_filter']['title'];
106    
107    $itemsperpage = $_SESSION['stormnote_list_filter']['itemsperpage'];    $itemsperpage = $_SESSION['stormnote_list_filter']['itemsperpage'];
108    if (!$itemsperpage) {    if (!$itemsperpage) {
# Line 119  function stormnote_list_filter() { Line 124  function stormnote_list_filter() {
124      '#theme' => 'storm_form_group',      '#theme' => 'storm_form_group',
125    );    );
126    
127    $s = "SELECT n.nid, n.title FROM {stormorganization} sor INNER JOIN {node} n ON sor.nid=n.nid WHERE n.status=1 AND n.type='stormorganization' ORDER BY n.title";    $s = "SELECT n.nid, n.title FROM {node} AS n INNER JOIN {stormorganization} AS sor ON sor.vid=n.vid WHERE n.status=1 AND n.type='stormorganization' ORDER BY n.title";
128      $s = db_rewrite_sql($s);
129    $r = db_query(stormorganization_access_sql($s));    $r = db_query(stormorganization_access_sql($s));
130    $organizations = array();    $organizations = array();
131    while ($organization = db_fetch_object($r)) {    while ($organization = db_fetch_object($r)) {
# Line 134  function stormnote_list_filter() { Line 140  function stormnote_list_filter() {
140      '#attributes' => array('onchange' => "stormtask_organization_project_tasks(this, 'edit-project-nid', 'edit-task-nid', true, 'All')"),      '#attributes' => array('onchange' => "stormtask_organization_project_tasks(this, 'edit-project-nid', 'edit-task-nid', true, 'All')"),
141    );    );
142    
143    $s = "SELECT n.nid, n.title FROM {stormproject} spr INNER JOIN {node} n ON spr.nid=n.nid    $s = "SELECT n.nid, n.title FROM {node} AS n INNER JOIN {stormproject} AS spr ON spr.vid=n.vid
144    WHERE n.status=1 AND spr.organization_nid=%d AND n.type='stormproject' ORDER BY n.title";    WHERE n.status=1 AND spr.organization_nid=%d AND n.type='stormproject' ORDER BY n.title";
145      $s = db_rewrite_sql($s);
146    $r = db_query(stormproject_access_sql($s), $organization_nid);    $r = db_query(stormproject_access_sql($s), $organization_nid);
147    $projects = array();    $projects = array();
148    while ($project = db_fetch_object($r)) {    while ($project = db_fetch_object($r)) {
# Line 151  function stormnote_list_filter() { Line 158  function stormnote_list_filter() {
158      '#attributes' => array('onchange' => "stormtask_project_tasks(this, 'edit-task-nid', true, 'All')"),      '#attributes' => array('onchange' => "stormtask_project_tasks(this, 'edit-task-nid', true, 'All')"),
159    );    );
160    
161    $r = db_query(stormtask_access_sql("SELECT n.nid, n.title FROM {stormtask} sta INNER JOIN {node} n ON sta.nid=n.nid WHERE status=1 AND type='stormtask' AND sta.project_nid=%d ORDER BY title "), $project_nid);    $s = "SELECT n.nid, n.title FROM {node} AS n INNER JOIN {stormtask} AS sta ON sta.nid=n.nid WHERE status=1 AND type='stormtask' AND sta.project_nid=%d ORDER BY title ";
162      $s = db_rewrite_sql($s);
163      $r = db_query(stormtask_access_sql($s), $project_nid);
164    $tasks = array();    $tasks = array();
165    while ($task = db_fetch_object($r)) {    while ($task = db_fetch_object($r)) {
166      $tasks[$task->nid] = $task->title;      $tasks[$task->nid] = $task->title;
# Line 169  function stormnote_list_filter() { Line 178  function stormnote_list_filter() {
178      '#theme' => 'storm_form_group',      '#theme' => 'storm_form_group',
179    );    );
180    
181    $form['filter']['group2']['submit'] = array(    $form['filter']['group2']['title'] = array(
182        '#type' => 'textfield',
183        '#title' => t('Title'),
184        '#default_value' => $title,
185      );
186    
187      $form['filter']['group3'] = array(
188        '#type' => 'markup',
189        '#theme' => 'storm_form_group',
190      );
191    
192      $form['filter']['group3']['submit'] = array(
193      '#type' => 'submit',      '#type' => 'submit',
194      '#value' => t('Filter'),      '#value' => t('Filter'),
195      '#submit' => array('stormnote_list_filter_filter'),      '#submit' => array('stormnote_list_filter_filter'),
196    );    );
197    
198    $form['filter']['group2']['reset'] = array(    $form['filter']['group3']['reset'] = array(
199      '#type' => 'submit',      '#type' => 'submit',
200      '#value' => t('Reset'),      '#value' => t('Reset'),
201      '#submit' => array('stormnote_list_filter_reset'),      '#submit' => array('stormnote_list_filter_reset'),
202    );    );
203    
204    $form['filter']['group2']['itemsperpage'] = array(    $form['filter']['group3']['itemsperpage'] = array(
205      '#type' => 'textfield',      '#type' => 'textfield',
206      '#title' => t('Items'),      '#title' => t('Items'),
207      '#size' => 10,      '#size' => 10,
# Line 202  function stormnote_list_filter_filter($f Line 222  function stormnote_list_filter_filter($f
222    $_SESSION['stormnote_list_filter']['organization_nid'] = $form_state['values']['organization_nid'];    $_SESSION['stormnote_list_filter']['organization_nid'] = $form_state['values']['organization_nid'];
223    $_SESSION['stormnote_list_filter']['project_nid'] = $form_state['values']['project_nid'];    $_SESSION['stormnote_list_filter']['project_nid'] = $form_state['values']['project_nid'];
224    $_SESSION['stormnote_list_filter']['task_nid'] = $form_state['values']['task_nid'];    $_SESSION['stormnote_list_filter']['task_nid'] = $form_state['values']['task_nid'];
225      $_SESSION['stormnote_list_filter']['title'] = $form_state['values']['title'];
226    $_SESSION['stormnote_list_filter']['itemsperpage'] = $form_state['values']['itemsperpage'];    $_SESSION['stormnote_list_filter']['itemsperpage'] = $form_state['values']['itemsperpage'];
227  }  }
228    
Legend:
Removed from v.1.3  
changed lines
  Added in v.1.4
  ViewVC Help
Powered by ViewVC 1.1.2