X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Forder_lines.inc;h=891da684cd16f4e064109f87f0ac69bcaa64502b;hb=e83dd263203cb4f16aec72e084825198b5e12259;hp=138af425876d53c9c9c86122b442d488addbdc40;hpb=9601714fd65ecd2b2786234336a2d732f7526869;p=order_line_extra.git

diff --git a/includes/order_lines.inc b/includes/order_lines.inc
index 138af42..891da68 100644
--- a/includes/order_lines.inc
+++ b/includes/order_lines.inc
@@ -1,27 +1,207 @@
 <?php
+include_once($path_to_root."/includes/ui/ui_input.inc");
+/* This utility function remove beginning <td> and </td> from a string
+ * generated by the above *_cell function.
+ * This is usefull to use the result of the function within a pager
+ * which already include the <td>...</td>
+ * However, for function which doesn't return a string
+ * but echo, we need to capture the output of the echo first.
+ */
+function start_extract_cell() {
+	// We need 
+	ob_start();
+}
+
+function end_extract_cell() {
+	$content = ob_get_contents();
+	ob_end_clean();
+	return extract_cell($content);
+}
+
+function extract_cell($td) {
+	if(preg_match('/\s*<td>(.*)<\/td>\s*/s', $td, $matches)) {
+		return $matches[1];
+	}
+	else {
+print_r('cacou');
+		return $td;
+	}
+}
+
+
+function update_extra_order_details() {
+	if(!isset($_POST['Update']) || $_POST['Update'] != 'Update')  return;
+
+begin_transaction();
+	// update in database all field
+	foreach($_POST['detail'] as $detail_id => $values) {
+		$set = array();
+		if($comment = $values['comment'])  array_push($set, " comment='$comment' ");
+		if(isset($values['required_date'])) {
+			$required_date = trim($values['required_date']);
+			if($required_date == "")  {
+				array_push($set," required_date = NULL");
+			} else {
+				$date = date2sql($required_date);
+				array_push($set," required_date='$date' ");
+			}
+		}
+
+		if(!empty($set))  {
+			$sql = "UPDATE ".TB_PREF."sales_order_details  SET ".implode($set,', ')."  WHERE id = $detail_id ";
+			
+			if(!db_query($sql)) {
+				display_error('Problem while updating order details. Try again');
+				cancel_transaction();
+				return;
+			}
+		}
+	
+	}
+
+	display_notification('Order details updated');
+
+}
+
+function compute_input_name($row, $field) {
+	$row_id = $row['id'];
+	return "detail[$row_id][$field]";
+}
+
 function view_link($dummy, $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)
 {
   return pager_link( _("Sales Order"),
 	"/sales/sales_order_entry.php?NewQuoteToSalesOrder=" .$row['order_no'], ICON_DOC);
 }
 
-function get_order_details_extra($customer_id) {
-	$sql = "SELECT so.order_no
+function customer_link($row) {
+	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) {
+	$comment =  $row['order_comment'].";".$row['detail_comment'];
+	if($comment) {
+		$comments = array_map('trim', explode(';', $comment));
+		$comments = array_filter($comments);
+		$first = array_shift($comments);
+		if(count($comments) == 0)
+			return $first;
+		else {
+			$tooltip = implode('<br> - ', $comments);
+			return "$first <span class='before-tooltip'>more<span class='tooltip'>&nbsp$tooltip</span><span>";
+		}
+	}
+	return '';
+}
+
+function available_quantity($row, $available) {
+	$quantity = $row['quantity'];
+	$class = '';
+	if($available== 0) $class = 'limited';
+	else if($quantity > $available)  $class = 'partial';
+
+	return "<span class='$class'>$available<span>";
+}
+
+function input_date_details($row, $date) {
+$row_id = $row['id'];
+	$name = compute_input_name($row, 'required_date');
+
+$_POST[$name] = sql2date($date);
+
+	start_extract_cell();
+		date_cells (null, $name, 'title', null, 0,0,1001);
+	return end_extract_cell();
+
+
+	return "
+<input type='text' value='$date' name='$name'>
+";
+}
+
+function input_comment_details($row, $comment) {
+$row_id = $row['id'];
+	return "
+<input type='text' value='$comment' name='detail[$row_id][comment]'>
+";
+}
+
+function get_order_details_extra($customer_id, $location) {
+	$sql = "SELECT sod.id
+	, so.order_no
 	, stk_code
-	, quantity - qty_sent
+	, sod.quantity - qty_sent quantity
+	, GREATEST(0, LEAST(qoh.quantity  - quantity_before, sod.quantity - qty_sent))
+	, quantity_before
 	, required_date
-	, comment
+	,comment
 	FROM ".TB_PREF."sales_order_details sod
 	JOIN ".TB_PREF."sales_orders so ON (so.order_no = sod.order_no
 		AND so.trans_type = sod.trans_type
+		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')
+	LEFT JOIN ".TB_PREF."denorm_order_details_queue  d ON (d.id = sod.id)
+	WHERE sod.quantity > qty_sent
+	";
+
+	return $sql;
+}
+
+function get_order_summary($location) {
+/*
+	$sub = "SELECT debtor_no, debtor_ref, branch_ref, stk_code
+	, min(delivery_date)
+	, sum(sod.quantity - qty_sent) as quantity
+	, sum((sod.quantity - qty_sent)*unit_price*(1-discount_percent/100)) as amount
+	, min(required_date)
+	, group_concat(distinct comments separator ';') as order_comment
+	, group_concat(distinct comment separator ';') as detail_comment
+	, max(quantity_before) as quantity_before
+	FROM ".TB_PREF."sales_order_details sod
+	JOIN ".TB_PREF."sales_orders so ON (so.order_no = sod.order_no
+		AND so.trans_type = sod.trans_type
+		AND so.trans_type = ".ST_SALESORDER."
+	)
+	NATURAL JOIN ".TB_PREF."debtors_master
+	NATURAL JOIN ".TB_PREF."cust_branch
+	JOIN ".TB_PREF."denorm_order_details_queue  d ON (d.id = sod.id)
+	WHERE sod.quantity > qty_sent AND ".ST_SALESORDER."
+	GROUP BY debtor_no, branch_code, stk_code
+	";
+*/
+
+	$sub = TB_PREF."order_summary_view";
+
+	$sql = "SELECT debtor_no, debtor_ref, branch_ref
+	, `min(delivery_date)`
+	, sum(sub.quantity) as quantity
+	, sum(sub.amount) as amount
+	, sum(greatest(least(sub.quantity, qoh.quantity - quantity_before), 0))
+	, sum(sub.amount*greatest(least(sub.quantity, qoh.quantity - quantity_before), 0)/sub.quantity)
+	,  min(`min(required_date)`)
+	, group_concat(distinct order_comment separator ';') as order_comment
+	, group_concat(distinct detail_comment separator ';') as detail_comment
+				FROM $sub sub
+				LEFT JOIN ".TB_PREF."denorm_qoh qoh ON (stock_id = stk_code AND loc_code = '$location')
+				GROUP BY debtor_no, debtor_ref
 	";
 
 	return $sql;