| 1 |
<?php |
<?php |
| 2 |
// $Id: storminvoiceitem.module,v 1.3 2008/06/18 08:13:53 robertogerola Exp $ |
// $Id: storminvoiceitem.module,v 1.4 2008/06/23 16:46:35 robertogerola Exp $ |
| 3 |
|
|
| 4 |
/** |
/** |
| 5 |
* @file |
* @file |
| 315 |
} |
} |
| 316 |
|
|
| 317 |
function storminvoiceitem_getitems($invoice_nid) { |
function storminvoiceitem_getitems($invoice_nid) { |
| 318 |
$r = db_query("SELECT n.*, sit.* FROM {node} n INNER JOIN {storminvoiceitem} sit ON n.nid=sit.nid WHERE |
$s = "SELECT n.*, sit.* FROM {node} AS n INNER JOIN {storminvoiceitem} AS sit ON n.vid=sit.vid WHERE |
| 319 |
n.status=1 AND n.type='storminvoiceitem' AND sit.invoice_nid = %d", $invoice_nid); |
n.status=1 AND n.type='storminvoiceitem' AND sit.invoice_nid = %d"; |
| 320 |
|
$s = db_rewrite_sql($s); |
| 321 |
|
$r = db_query($s, $invoice_nid); |
| 322 |
|
|
| 323 |
$items = array(); |
$items = array(); |
| 324 |
while ($i = db_fetch_object($r)) { |
while ($i = db_fetch_object($r)) { |
| 325 |
$items[] = $i; |
$items[] = $i; |