<?php

require_once($path_to_root.'/'.'sales/includes/sales_db.inc');
function process_picking_flag() {
	$id = find_submit('_chgpck', false);
	if ($id != -1 && isset($_POST['pick'])) {
		$id = str_replace("_update", "", $id);
		change_pck_flag($id, isset($_POST['pick'][$id]));
	}
}

function change_pck_flag($id, $value=null)
{
display_warning("value $value");
	if($value === null) $value = true;
display_warning("value $value");
	global	$Ajax;

	$picker = new Picker();
	list($debtor_no, $branch_code) = explode('_', $id);

	// insert or remove pick order form pick table initial_quantity 
	if($picker->picked($debtor_no, $branch_code)) {
		$picker->deleteAllForBranch($debtor_no, $branch_code);
	}
	else {
		$picker->insertAllForBranch($debtor_no, $branch_code);
	}
	$Ajax->activate('order_line_view');
}


class Picker {
	function picked($debtor_no, $branch_code) {
		$sql = "SELECT *
						FROM ".TB_PREF."sales_orders so
						NATURAL JOIN ".TB_PREF."sales_order_details sod
						JOIN ".TB_PREF."topick p on (sod.id = p.detail_id)
						WHERE debtor_no = $debtor_no AND branch_code = $branch_code
						";

		return db_num_rows(db_query($sql)) > 0;

	}
	function insertAllForBranch($debtor_no, $branch_code) {
		$this->deleteAllForBranch($debtor_no, $branch_code);
		$pick_location = OrderXtraConfig::$default_location;
		$sql = "SELECT  d.stock_id
										,sod.id AS detail_id
										, d.quantity AS quantity
										,IF(".OrderXtraConfig::sql_held_condition().", d.quantity, 0) held
										,qoh.quantity AS qoh
										,quantity_before
										,order_id
						FROM ".TB_PREF."sales_order_details sod
						NATURAL JOIN ".TB_PREF."sales_orders so
						JOIN ".TB_PREF."denorm_order_details_queue d ON (sod.id = d.id)
						JOIN ".TB_PREF."denorm_qoh qoh ON (qoh.stock_id = sod.stk_code AND loc_code = '$pick_location')
						WHERE debtor_no = $debtor_no AND branch_code = $branch_code
						";
			display_warning("$sql");
		$result = db_query($sql, $sql);
			display_warning("B $result");
		while($row=db_fetch($result)) {
			foreach($row as $key => $value) { $$key = $value; }
			$available = min($quantity, max($qoh-$quantity_before-$held,0 ));
			$booked = $quantity - $available;

		$sku	= $stock_id;
		$item_link = "/modules/order_line_extra/item_schedule.php?stock_id=$sku";
		$order_link = "/sales/sales_order_entry.php?OrderNumber=$order_id";
		$base = substr($sku, 0, 8);
		$variation = substr($sku, 9);
		$branch = get_cust_branch($debtor_no, $branch_code);
		$location = $branch['branch_ref'];

		$sql = "INSERT INTO ".TB_PREF."topick  SET
			order_id = $order_id,
			order_link = '$order_link',
			location = '$location',
			sku	= '$sku',
			base = '$base',
			variation = '$variation',
			item_link = '$item_link',
			quantity = -{$quantity},
			detail_id = $detail_id,
			type = 'order'";
		db_query($sql, 'There was a problem inserting the picking information.');

		# add booked quantity. Insert them as picked so they won't have to be picked
		$sql = "INSERT INTO ".TB_PREF."topick  SET
			order_id = $order_id,
			order_link = '$order_link',
			location = '$location',
			sku	= '$sku',
			item_link = '$item_link',
			base = '$base',
			variation = '$variation',
			quantity = $booked,
			detail_id = $detail_id,
			type = 'booked'";
		db_query($sql, 'There was a problem inserting the picking information.');

		}
			display_warning("E");
	}

	function deleteAllForBranch($debtor_no, $branch_code) {
		display_warning("deleting for $debtor_no $branch_code");
		$sql = "DELETE ".TB_PREF."topick p
						FROM ".TB_PREF."topick p
						JOIN ".TB_PREF."sales_order_details sod on (sod.id = p.detail_id)
						NATURAL JOIN ".TB_PREF."sales_orders so
						WHERE debtor_no = $debtor_no AND branch_code = $branch_code
						";
		db_query($sql);
	}

}