projects
/
order_line_extra.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Display available quantity in order line view (for customer)
[order_line_extra.git]
/
includes
/
order_lines.inc
diff --git
a/includes/order_lines.inc
b/includes/order_lines.inc
index 54b2a7faec8eb4f309827d4492f7b8afe39f0f35..5f8d922cbe8458fc0ed226acb81861ab995751d9 100644
(file)
--- a/
includes/order_lines.inc
+++ b/
includes/order_lines.inc
@@
-28,9
+28,6
@@
print_r('cacou');
}
}
}
}
-?>
-
-
function update_extra_order_details() {
if(!isset($_POST['Update']) || $_POST['Update'] != 'Update') return;
function update_extra_order_details() {
if(!isset($_POST['Update']) || $_POST['Update'] != 'Update') return;
@@
-76,6
+73,11
@@
function view_link($dummy, $order_no)
return get_customer_trans_view_str(ST_SALESORDER, $order_no);
}
return get_customer_trans_view_str(ST_SALESORDER, $order_no);
}
+function item_link($dummy, $stock_id)
+{
+ return pager_link( _($stock_id),
+ "/modules/order_line_extra/item_schedule.php?stock_id=" .$stock_id);
+}
function order_link($row)
{
function order_link($row)
{
@@
-84,12
+86,16
@@
function order_link($row)
}
function customer_link($row) {
}
function customer_link($row) {
- return pager_link(_($row['debtor_ref']), "/modules/order_line_extra/order_lines_view.php?customer_id=${row['debtor_no']}");
+ return customer_link2($row['debtor_ref'], $row['debtor_no']);
+}
+
+function customer_link2($name, $id) {
+ return pager_link(_($name), "/modules/order_line_extra/order_lines_view.php?customer_id=${id}");
}
function aggregate_comment($row) {
}
function aggregate_comment($row) {
- $comment = $row['order_comment'].$row['detail_comment'];
+ $comment = $row['order_comment'].
";".
$row['detail_comment'];
if($comment) {
$comments = array_map('trim', explode(';', $comment));
$comments = array_filter($comments);
if($comment) {
$comments = array_map('trim', explode(';', $comment));
$comments = array_filter($comments);
@@
-97,8
+103,8
@@
function aggregate_comment($row) {
if(count($comments) == 0)
return $first;
else {
if(count($comments) == 0)
return $first;
else {
- $tooltip = implode('<br>', $comments);
- return "$first <span class='before-tooltip'>more<
/span><span class='tooltip'> $tooltip</
span>";
+ $tooltip = implode('<br>
-
', $comments);
+ return "$first <span class='before-tooltip'>more<
span class='tooltip'> $tooltip</span><
span>";
}
}
return '';
}
}
return '';
@@
-127,11
+133,13
@@
$row_id = $row['id'];
";
}
";
}
-function get_order_details_extra($customer_id) {
+function get_order_details_extra($customer_id
, $location
) {
$sql = "SELECT sod.id
, so.order_no
, stk_code
$sql = "SELECT sod.id
, so.order_no
, stk_code
- , quantity - qty_sent
+ , sod.quantity - qty_sent
+ , GREATEST(0, LEAST(qoh.quantity - quantity_before, sod.quantity - qty_sent))
+ , quantity_before
, required_date
,comment
FROM ".TB_PREF."sales_order_details sod
, required_date
,comment
FROM ".TB_PREF."sales_order_details sod
@@
-140,7
+148,9
@@
function get_order_details_extra($customer_id) {
AND so.trans_type = ".ST_SALESORDER."
AND so.debtor_no = $customer_id
)
AND so.trans_type = ".ST_SALESORDER."
AND so.debtor_no = $customer_id
)
- WHERE quantity > qty_sent
+ JOIN ".TB_PREF."denorm_qoh qoh ON (stock_id = stk_code AND loc_code = '$location')
+ JOIN ".TB_PREF."denorm_order_details_queue d ON (d.id = sod.id)
+ WHERE sod.quantity > qty_sent
";
return $sql;
";
return $sql;