WHERE ".TB_PREF."grn_batch.supplier_id=".TB_PREF."suppliers.supplier_id
AND ".TB_PREF."grn_batch.id = ".TB_PREF."grn_items.grn_batch_id
AND ".TB_PREF."grn_items.po_detail_item = ".TB_PREF."purch_order_details.po_detail_item
WHERE ".TB_PREF."grn_batch.supplier_id=".TB_PREF."suppliers.supplier_id
AND ".TB_PREF."grn_batch.id = ".TB_PREF."grn_items.grn_batch_id
AND ".TB_PREF."grn_items.po_detail_item = ".TB_PREF."purch_order_details.po_detail_item
- AND qty_recd-quantity_inv <>0
- AND ".TB_PREF."grn_batch.supplier_id >='" . $fromsupp . "'
- AND ".TB_PREF."grn_batch.supplier_id <='" . $tosupp . "'
- ORDER BY ".TB_PREF."grn_batch.supplier_id,
+ AND qty_recd-quantity_inv <>0 ";
+ if ($fromsupp != reserved_words::get_all_numeric())
+ $sql .= "AND ".TB_PREF."grn_batch.supplier_id ='" . $fromsupp . "' ";
+ $sql .= "ORDER BY ".TB_PREF."grn_batch.supplier_id,
".TB_PREF."grn_batch.id";
return db_query($sql, "No transactions were returned");
".TB_PREF."grn_batch.id";
return db_query($sql, "No transactions were returned");
$dec = user_price_dec();
$cols = array(0, 40, 80, 190, 250, 320, 385, 450, 515);
$dec = user_price_dec();
$cols = array(0, 40, 80, 190, 250, 320, 385, 450, 515);
$aligns = array('left', 'left', 'left', 'right', 'right', 'right', 'right', 'right');
$params = array( 0 => $comments,
$aligns = array('left', 'left', 'left', 'right', 'right', 'right', 'right', 'right');
$params = array( 0 => $comments,
- 1 => array('text' => _('Supplier'), 'from' => get_supplier_name($fromsupp),
- 'to' => get_supplier_name($tosupp)));
+ 1 => array('text' => _('Supplier'), 'from' => $from, 'to' => ''));