<?
class common_stock_take{						
	public function createStockTake($item_no,$real_quantity,$system_quantity, $prove_by=0){			
		global $database;
		
		$db_name = DB_CLIENT;
		$submitter = $_SESSION['user']['id'];
		$current_date_time = date('Y-m-d G:i:s');
		
		$order_date = dates::change_to_sql($order_date);
		$delivery_date = dates::change_to_sql($delivery_date);
		if($prove_by==0){
			$sql = "
			INSERT INTO $db_name"."stock_take
			(item_no,real_quantity,system_quantity,submitter, date_submitted)
			VALUES 
			('$item_no', '$real_quantity', '$system_quantity', '$submitter','$current_date_time')";
		}else{
			$sql = "
			INSERT INTO $db_name"."stock_take
			(item_no,real_quantity,system_quantity,submitter, date_submitted,prove_by,date_proved)
			VALUES
			('$item_no', '$real_quantity', '$system_quantity', '$submitter','$current_date_time', '$prove_by', '$current_date_time')";
		}
		
		$result=$database->query($sql);
		$lastid = $database->insert_ID();
		
		return $lastid;
	}

	public function updateStockTake($id,$real_quantity){
		global $database;
		
		$db_name = DB_CLIENT;
		$submitter = $_SESSION['user']['id'];
		$current_date_time = date('Y-m-d G:i:s');
		
		$update  = "
		UPDATE $db_name"."stock_take
		SET
		real_quantity='$real_quantity',
		submitter='$submitter', 
		date_submitted='$current_date_time'
		WHERE id = '$id'
		";
		$database->query($update);
	}
	
	public function approveStockTakeWithQuantity($id,$item_no,$quantity){
		global $database;
		
		$db_name = DB_CLIENT;
		$submitter = $_SESSION['user']['id'];
		$current_date_time = date('Y-m-d G:i:s');
		
		$update  = "
		UPDATE $db_name"."stock_take
		SET
		approve_quantity='$quantity',
		prove_by='$submitter',
		date_proved='$current_date_time'
		WHERE id = '$id'
		";
		$database->query($update);
		
		$update  = "
		UPDATE $db_name"."materials_inventory
		SET
		total_quantity='$quantity',
		submitter='$submitter',
		date_submitted='$current_date_time'
		WHERE id = '$item_no'
		";
		$database->query($update);

		logs::submit_logs(array("table" => "materials_inventory", "action_type" => 2,"foreign_id" => $item_no, "description" => "Approved quantity x $quantity"));
	}
}

?>