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

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

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

revision 1.1, Wed Jun 11 12:55:19 2008 UTC revision 1.2, Tue Jul 1 07:47:42 2008 UTC
# Line 1  Line 1 
1  <?php  <?php
2  // $Id$  // $Id: storminvoiceitem.admin.inc,v 1.1 2008/06/11 12:55:19 robertogerola Exp $
3    
4  /**  /**
5   * @file   * @file
# Line 37  function storminvoiceitem_invoiceitems($ Line 37  function storminvoiceitem_invoiceitems($
37    );    );
38    
39    $where = array();    $where = array();
40    $s  = "SELECT n.*, sit.* FROM {storminvoiceitem} sit INNER JOIN {node} n ON n.nid=sit.nid WHERE n.status=1 AND n.type='storminvoiceitem' ORDER BY sit.weight";    $s  = "SELECT n.*, sit.* FROM {node} AS n INNER JOIN {storminvoiceitem} sit ON n.vid=sit.vid WHERE n.status=1 AND n.type='storminvoiceitem' ORDER BY sit.weight";
41    $where[] = 'sit.invoice_nid='. $invoice->nid;    $where[] = 'sit.invoice_nid='. $invoice->nid;
42    
43      $s = db_rewrite_sql($s);
44    $s = storminvoiceitem_access_sql($s, $where);    $s = storminvoiceitem_access_sql($s, $where);
45    $s = db_rewrite_sql($s, 'storminvoiceitem', 'nid');    $s = db_rewrite_sql($s, 'storminvoiceitem', 'nid');
46    $tablesort = tablesort_sql($header);    $tablesort = tablesort_sql($header);
Legend:
Removed from v.1.1  
changed lines
  Added in v.1.2
  ViewVC Help
Powered by ViewVC 1.1.2