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

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

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

revision 1.3, Mon Jun 23 16:46:35 2008 UTC revision 1.4, Tue Jul 1 07:47:42 2008 UTC
# Line 1  Line 1 
1  <?php  <?php
2  // $Id: stormexpense.module,v 1.2 2008/06/18 15:24:26 robertogerola Exp $  // $Id: stormexpense.module,v 1.3 2008/06/23 16:46:35 robertogerola Exp $
3    
4  /**  /**
5   * @file   * @file
# Line 261  function stormexpense_form(&$node) { Line 261  function stormexpense_form(&$node) {
261      '#weight' => -49,      '#weight' => -49,
262    );    );
263    
264    $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
265      ON sor.nid=n.nid WHERE n.status=1 AND n.type='stormorganization' ORDER BY n.title";
266      $s = db_rewrite_sql($s);
267    $r = db_query(stormorganization_access_sql($s));    $r = db_query(stormorganization_access_sql($s));
268    $organizations = array();    $organizations = array();
269    while ($organization = db_fetch_object($r)) {    while ($organization = db_fetch_object($r)) {
# Line 277  function stormexpense_form(&$node) { Line 279  function stormexpense_form(&$node) {
279      '#attributes' => array('onchange' => "stormticket_organization_project_task_tickets(this, 'edit-project-nid', 'edit-task-nid', 'edit-ticket-nid', true, '-')"),      '#attributes' => array('onchange' => "stormticket_organization_project_task_tickets(this, 'edit-project-nid', 'edit-task-nid', 'edit-ticket-nid', true, '-')"),
280    );    );
281    
282    $s = "SELECT n.nid, n.title FROM {stormproject} spr INNER JOIN {node} n ON spr.nid=n.nid WHERE spr.organization_nid=%d AND n.status=1 AND n.type='stormproject' ORDER BY n.title";    $s = "SELECT n.nid, n.title FROM {node} AS n INNER JOIN {stormproject} AS spr ON spr.vid=n.vid
283      WHERE spr.organization_nid=%d AND n.status=1 AND n.type='stormproject' ORDER BY n.title";
284      $s = db_rewrite_sql($s);
285    $r = db_query(stormproject_access_sql($s), $node->organization_nid);    $r = db_query(stormproject_access_sql($s), $node->organization_nid);
286    $projects = array();    $projects = array();
287    while ($project = db_fetch_object($r)) {    while ($project = db_fetch_object($r)) {
# Line 306  function stormexpense_form(&$node) { Line 310  function stormexpense_form(&$node) {
310    );    );
311    
312    $tickets = array();    $tickets = array();
313    $r = db_query(stormticket_access_sql("SELECT n.nid, n.title FROM {stormticket} stt INNER JOIN {node} n ON stt.nid=n.nid WHERE n.status=1 AND n.type='stormticket' AND stt.organization_nid=%d AND stt.project_nid=%d AND stt.task_nid=%d ORDER BY n.title"),    $s = "SELECT n.nid, n.title FROM {node} AS n INNER JOIN {stormticket} AS stt ON stt.vid=n.vid WHERE n.status=1 AND n.type='stormticket'
314    $node->organization_nid, $node->project_nid, $node->task_nid);    AND stt.organization_nid=%d AND stt.project_nid=%d AND stt.task_nid=%d ORDER BY n.title";
315      $r = db_query(stormticket_access_sql($s), $node->organization_nid, $node->project_nid, $node->task_nid);
316    while ($ticket = db_fetch_object($r)) {    while ($ticket = db_fetch_object($r)) {
317      $tickets[$ticket->nid] = $ticket->title;      $tickets[$ticket->nid] = $ticket->title;
318    }    }
# Line 432  function _stormexpense_beforesave(&$node Line 437  function _stormexpense_beforesave(&$node
437    }    }
438    
439    $s = "SELECT n.title    $s = "SELECT n.title
440          FROM {node} n INNER JOIN {stormorganization} o ON n.nid=o.nid          FROM {node} AS n INNER JOIN {stormorganization} AS o ON n.nid=o.nid
441          WHERE type='stormorganization' AND n.nid=%d";          WHERE type='stormorganization' AND n.nid=%d";
442    $r = db_query($s, $node->organization_nid);    $r = db_query($s, $node->organization_nid);
443    $o = db_fetch_object($r);    $o = db_fetch_object($r);
# Line 445  function _stormexpense_beforesave(&$node Line 450  function _stormexpense_beforesave(&$node
450    $p = db_fetch_object($r);    $p = db_fetch_object($r);
451    $node->project_title = $p->title;    $node->project_title = $p->title;
452    
453    $s = "SELECT title, stepno FROM {node} n INNER JOIN {stormtask} t ON n.nid=t.nid WHERE n.type='stormtask' AND n.nid=%d";    $s = "SELECT title, stepno FROM {node} AS n INNER JOIN {stormtask} AS t ON n.vid=t.vid WHERE n.type='stormtask' AND n.nid=%d";
454    $r = db_query($s, $node->task_nid);    $r = db_query($s, $node->task_nid);
455    $ta = db_fetch_object($r);    $ta = db_fetch_object($r);
456    $node->task_title = $ta->title;    $node->task_title = $ta->title;
457    $node->task_stepno = $ta->stepno;    $node->task_stepno = $ta->stepno;
458    
459    $s = "SELECT title FROM {node} n INNER JOIN {stormticket} t ON n.nid=t.nid WHERE n.type='stormticket' AND n.nid=%d";    $s = "SELECT title FROM {node} AS n INNER JOIN {stormticket} AS t ON n.vid=t.vid WHERE n.type='stormticket' AND n.nid=%d";
460    $r = db_query($s, $node->ticket_nid);    $r = db_query($s, $node->ticket_nid);
461    $ti = db_fetch_object($r);    $ti = db_fetch_object($r);
462    $node->ticket_title = $ti->title;    $node->ticket_title = $ti->title;
Legend:
Removed from v.1.3  
changed lines
  Added in v.1.4
  ViewVC Help
Powered by ViewVC 1.1.2