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

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

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

revision 1.7, Tue May 20 08:13:19 2008 UTC revision 1.8, Tue Jul 1 07:47:43 2008 UTC
# Line 1  Line 1 
1  <?php  <?php
2  // $Id: stormticket.admin.inc,v 1.6 2008/05/16 12:58:25 robertogerola Exp $  // $Id: stormticket.admin.inc,v 1.7 2008/05/20 08:13:19 robertogerola Exp $
3    
4  /**  /**
5   * @file   * @file
# Line 75  function stormticket_list() { Line 75  function stormticket_list() {
75    );    );
76    
77    $where = array();    $where = array();
78    $s  = "SELECT n.*, sti.* FROM {stormticket} sti INNER JOIN {node} n ON n.nid=sti.nid WHERE n.status=1 AND n.type='stormticket' ";    $s = "SELECT n.*, sti.* FROM  {node} AS n INNER JOIN {stormticket} AS sti ON n.vid=sti.vid WHERE n.status=1 AND n.type='stormticket' ";
79    if ($_SESSION['stormticket_list_filter']['organization_nid']) {    if ($_SESSION['stormticket_list_filter']['organization_nid']) {
80      $where[] = 'sti.organization_nid='. $_SESSION['stormticket_list_filter']['organization_nid'];      $where[] = 'sti.organization_nid='. $_SESSION['stormticket_list_filter']['organization_nid'];
81    }    }
# Line 97  function stormticket_list() { Line 97  function stormticket_list() {
97    }    }
98    $itemsperpage = $_SESSION['stormticket_list_filter']['itemsperpage'];    $itemsperpage = $_SESSION['stormticket_list_filter']['itemsperpage'];
99    
100      $s = db_rewrite_sql($s);
101    $s = stormticket_access_sql($s, $where);    $s = stormticket_access_sql($s, $where);
102    $s = db_rewrite_sql($s, 'stormticket', 'nid');    $s = db_rewrite_sql($s, 'stormticket', 'nid');
103    
# Line 148  function stormticket_list_filter() { Line 149  function stormticket_list_filter() {
149      '#theme' => 'storm_form_group',      '#theme' => 'storm_form_group',
150    );    );
151    
152    $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";
153      $s = db_rewrite_sql($s);
154    $r = db_query(stormorganization_access_sql($s));    $r = db_query(stormorganization_access_sql($s));
155    $organizations = array();    $organizations = array();
156    while ($organization = db_fetch_object($r)) {    while ($organization = db_fetch_object($r)) {
# Line 163  function stormticket_list_filter() { Line 165  function stormticket_list_filter() {
165      '#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')"),
166    );    );
167    
168    $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
169    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";
170    $r = db_query(stormproject_access_sql($s), $organization_nid);    $r = db_query(stormproject_access_sql($s), $organization_nid);
171    $projects = array();    $projects = array();
# Line 180  function stormticket_list_filter() { Line 182  function stormticket_list_filter() {
182      '#attributes' => array('onchange' => "stormtask_project_tasks(this, 'edit-task-nid', true, 'All')"),      '#attributes' => array('onchange' => "stormtask_project_tasks(this, 'edit-task-nid', true, 'All')"),
183    );    );
184    
185    $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);    $r = db_query(stormtask_access_sql("SELECT n.nid, n.title FROM {node} AS n INNER JOIN {stormtask} AS sta
186      ON sta.vid=n.vid WHERE status=1 AND type='stormtask' AND sta.project_nid=%d ORDER BY title "), $project_nid);
187    $tasks = array();    $tasks = array();
188    while ($task = db_fetch_object($r)) {    while ($task = db_fetch_object($r)) {
189      $tasks[$task->nid] = $task->title;      $tasks[$task->nid] = $task->title;
# Line 257  function stormticket_list_filter_reset($ Line 260  function stormticket_list_filter_reset($
260  function _stormticket_task_tickets_js($organization_nid=0, $project_nid=0, $task_nid=0) {  function _stormticket_task_tickets_js($organization_nid=0, $project_nid=0, $task_nid=0) {
261    $tickets = array();    $tickets = array();
262    
263    $r = db_query(stormticket_access_sql("SELECT n.nid, n.title FROM {stormticket} sti INNER JOIN {node} n    $s = "SELECT n.nid, n.title FROM {node} n INNER JOIN {stormticket} sti
264    ON n.nid=sti.nid WHERE n.status=1 AND n.type='stormticket' AND sti.organization_nid=%d AND sti.project_nid=%d    ON n.vid=sti.vid WHERE n.status=1 AND n.type='stormticket' AND sti.organization_nid=%d AND sti.project_nid=%d
265    AND sti.task_nid=%d ORDER BY n.title"), $organization_nid, $project_nid, $task_nid);    AND sti.task_nid=%d ORDER BY n.title";
266      $s = db_rewrite_sql($s);
267    
268      $r = db_query(stormticket_access_sql($r), $organization_nid, $project_nid, $task_nid);
269    while ($item = db_fetch_object($r)) {    while ($item = db_fetch_object($r)) {
270      $nid = $item->nid;      $nid = $item->nid;
271      $tickets[$nid] = $item->title;      $tickets[$nid] = $item->title;
Legend:
Removed from v.1.7  
changed lines
  Added in v.1.8
  ViewVC Help
Powered by ViewVC 1.1.2