<?php
/**********************************************************************
    Copyright (C) FrontAccounting, LLC.
	Released under the terms of the GNU General Public License, GPL, 
	as published by the Free Software Foundation, either version 3 
	of the License, or (at your option) any later version.
    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
    See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
$path_to_root = "../..";

include_once($path_to_root . "/includes/db_pager.inc");
include_once($path_to_root . "/includes/session.inc");
include_once($path_to_root . "/sales/includes/sales_ui.inc");
include_once($path_to_root . "/reporting/includes/reporting.inc");

include_once("config.php");
include_once("includes/order_lines.inc");
include_once("includes/splitter.inc");
include_once("includes/bulk_updater.inc");
include_once("includes/picking.inc");

$page_security = 'SA_ORDERLINEX_EDIT';
add_access_extensions();

$_SESSION['page_title'] = _($help_context = "Edit lines extra parameters");

function get_parameter($param) {
	$value = null;
	if(!isset($_POST[$param])) {
		if(isset($_GET[$param])) {
			$value = $_GET[$param];
			$_POST[$param] = $value;
		}
	}
	else $value = $_POST[$param];
	return $value;
}

// Process POST
filter_data($_POST);
update_extra_order_details();
split_order_details();
bulk_update_order_details();
pick_order_details();
unpick_order_details();

process_picking_flag();


$js = "";
if ($use_popup_windows)
	$js .= get_js_open_window(900, 600);
if ($use_date_picker)
	$js .= get_js_date_picker();
page($_SESSION['page_title'], false, false, "", $js);

//---------------------------------------------------------------------------------------------

div_start('order_line_view');
start_form();

start_table(TABLESTYLE_NOBORDER);
start_row();

$order_id = get_parameter('order_id');
text_cells_ex(_('Order #'), 'order_id', 10, null, $order_id,
		null, null, null, true );

if(!isset($_POST['customer_id'])) {
	if(isset($_GET['customer_id'])) {
		$customer_id = $_GET['customer_id'];
		$_POST['customer_id'] = $customer_id;
	}
else {
	$customer_id = null;

}

}
else {
	$customer_id = $_POST['customer_id'];
}
	if($order_id) {
		// find the customer owing the order
		$result = db_query("SELECT debtor_no FROM ".TB_PREF."sales_orders WHERE order_no = $order_id AND trans_type =".ST_SALESORDER );
		if($result && $row=db_fetch($result)) $customer_id= $row['debtor_no'];
	}
customer_list_cells(_("Select a customer: "), 'customer_id', $customer_id, true, true);

if($customer_id != null) {
	if(!isset($_POST['item_like'])) {
		if(isset($_GET['item_like'])) {
			$item_like = $_GET['item_like'];
			$_POST['item_like'] = $item_like;
		}
		else $item_like = null;
	}
	else $item_like = $_POST['item_like'];
	text_cells_ex('Filter Item', 'item_like', 50, null, $item_like,
			null, null, null, true );

}


//submit_cells('SearchOrders', _("Search"),'',_('Select documents'), 'default');

end_row();

end_table(1);

//---------------------------------------------------------------------------------------------
//	Orders inquiry table
//
if($customer_id) {
	// Display all item for one customer
	$sql = get_order_details_extra($customer_id, 'DEF', $item_like, $order_id);
	$cols = array(
		'detail_id' => 'skip'
		,	_("Order #") => array('fun'=>'edit_link', 'ord' => '')
		,_("Item Code") => array('ord' => '', 'fun' => 'item_link')
		,_("Quantity") => array('ord' => '', 'type' => 'qty', 'dec' => 0)
		,_("Available") => array('fun' => 'available_quantity', 'dec' => 0, 'ord' => '')
		,_("Before") => 'skip'
		,_("QOH") => 'skip'
		,_("To Pick") => array('type' => 'qty', 'ord' => '', 'dec' => 0)
		,_("Priority") => array('type' => 'time', 'ord' => '')
		,_("Hold Until") => array('fun' => 'input_hold_until_date_details', 'ord' => '')
		,_("Require By") => array('fun' => 'input_required_date_details', 'ord' => '')
		,_("Expiry Date") => array('fun' => 'input_expiry_date_details', 'ord' => '')
		,_("Comment") => array('fun' => 'input_comment_details', 'ord' => '')
		,_("Reference") => array( 'ord' => '')
		,'<input id="checkAll" type="checkbox">' => array('fun' => 'input_check_details')
	);
}
else {
	// Display all customers
	$sql = get_order_summary('DEF');
	$cols = array(
	'customer id' => 'skip',
	'branch code ' => 'skip',
_("Customer") => array('ord' => '', 'fun' => 'customer_link'),
_("Branch") => array('ord' => ''),
_("Delivery Date") => array('ord' => '', 'type' => 'date'),
_("Quantity") => array('ord' => '', 'type' => 'qty', 'dec' => 0),
_("Amount") => array('ord' => '', 'type' => 'amount'),
_("Avail. Q") => array('ord' => '', 'type' => 'qty', 'dec' => 0),
_("Avail. A") => array('ord' => '', 'type' => 'amount', 'dec' => 0),
_("Held. Q") => array('ord' => '', 'type' => 'qty', 'dec' => 0),
_("required date") => array('ord' => '', 'type' => 'date'),
_("Comments") => array('ord' => '', 'fun' => 'aggregate_comment'),
_("comment 2 ") =>  'skip',
_("Q to Pick") => array('ord' => '', 'type' => 'qty', 'dec' => 0),
_("A to Pick") => array('ord' => '', 'type' => 'amount'),
_("Pick")=> array('insert'=>true, 'fun'=>'pick_checkbox'),
	);
}


$table =& new_db_pager('orders_tbl', $sql, $cols);

$table->width = "80%";

display_db_pager($table);

function display_split_area() {
qty_cells('Before', 'start_offset', -5);
date_cells('Start', 'start_date', null, null, 0, 0, 1001);
date_cells('End', 'end_date', null, null, 0, 0, 1001);
qty_cells('After', 'end_offset', 2);
qty_cells('Max', 'max_quantity', 6);
submit_cells('Split', 'Split');

}

function display_bulk_area()  {
date_cells('Priority', 'bulk[priority_date]', null, null, 0, 0, 1001);
qty_cells(null, 'bulk[priority_time]', '12:00:00');
date_cells('Hold', 'bulk[hold_until_date]', null, null, 0, 0, 1001);
date_cells('Required', 'bulk[required_date]', null, null, 0, 0, 1001);
date_cells('Expiry', 'bulk[expiry_date]', null, null, 0, 0, 1001);
text_cells('Comment', 'bulk[comment]');
submit_cells('Bulk', 'Bulk');
}

function display_pick_area() {
submit_cells('Pick', 'Pick');
submit_cells('Unpick', 'Unpick');
}


if($customer_id !== null) {
start_table(TABLESTYLE_NOBORDER);
display_split_area();
end_table();
start_table(TABLESTYLE_NOBORDER);
display_bulk_area();
end_table();
start_table(TABLESTYLE_NOBORDER);
display_pick_area();
end_table();
}


br(1);
submit_center_first('Update', _("Update"), '', 'default', false);
submit_center_last('Cancel', _("Cancel"), '', 'cancel', false);

end_form();
div_end();
end_page();
?>
<style>
span.tooltip{ display:none;}
span.tooltip {
      position: absolute;
			right: -0px;
			top: 20px;
      width: 200px;
      color: rgb(113, 157, 171);
      background: rgb(255, 255, 255);
      border: 1px solid rgb(113, 157, 171);
}

:hover > span.tooltip, span.tooltip:hover {
	display: inline;
}
span.before-tooltip {
	color: #800;
	font-style: italic;
	position: relative;
}

input:disabled + a {
	display: none;
	
}

</style>
<script src="http://code.jquery.com/jquery-1.9.1.js"></script>
<script text="text/javascript">

var inserts = {
	'#checkAll': function (e) {
		e.onchange = function()  {
			$('.check_detail').prop('checked', e.checked)
			$('.check_detail').trigger('change');
		}
	}
	,'tr': function(e) {
			// find if there is a check detail box on link all input to it
			var tr = $(e);
			var check = tr.find('.check_detail');
			if(check.length != 1) return;
			check = check[0];
			var jcheck = $(check);
			var inputs = tr.find('input');
			inputs.each(function(index, input) {
				if(input === check) return;
				$(input).prop('disabled', true)
			})

			check.onchange = function() {
				inputs.each(function(index, input) {
					var on = jcheck.prop('checked')
					if(input == check) return;
					$(input).prop('disabled', !on);
				})
			};
		}
	}
Behaviour.register(inserts);
</script>