<?
 
class common_materials_inventory
{
	 
	
	 
	public function update_inventory($context)
	{	
		global $database;
		
		$item_number = $context['item_number'];
		$item_name = addslashes($context['item_name']);
		$supplier = addslashes($context['supplier']);
		$quantity = $context['quantity'];
		 
		$id = $context['id'];
		$submitter = $_SESSION['user']['id'];
		$current_date_time = date('Y-m-d G:i:s');
		
		$db_name = DB_CLIENT;
		 
		$update_material = "
			UPDATE materials_inventory
			SET
			item_number = '$item_number',
			item_name = '$item_name',
			supplier = '$supplier',
			total_quantity = '$quantity',
			submitter = '$submitter',
			date_submitted = '$current_date_time'
			WHERE id = '$id'
			";
		$results = $database->query($update_material);	

		logs::submit_logs(array("table" => "materials_inventory", "action_type" => 2,"foreign_id" => $id, "description" => "Modified quantity $quantity"));
	}
	
	
	public function insert_inventory($context)
	{	
		global $database;
		
		$item_number = $context['item_number'];
		$item_name = addslashes($context['item_name']);
		$supplier = addslashes($context['supplier']);
		$quantity = $context['quantity'];
		 
		$submitter = $_SESSION['user']['id'];
		$current_date_time = date('Y-m-d G:i:s');
		
		$db_name = DB_CLIENT;
		 
		$insert_material = "
			INSERT INTO materials_inventory
			SET
			item_number = '$item_number',
			item_name = '$item_name',
			supplier = '$supplier',
			total_quantity = '$quantity',
			status = '1',
			creator = '$submitter',
			date_created = '$current_date_time',
			submitter = '$submitter',
			date_submitted = '$current_date_time'
			";
			$results = $database->query($insert_material);
			$item_id = $database->insert_id();
			
			logs::submit_logs(array("table" => "materials_inventory", "action_type" => 1,"foreign_id" => $item_id, "description" => "Created"));
			return $item_id;	
	}
	
	
	public function get_item_name($id)
	{
		global $database;
			
		$get_name = "
		SELECT item_name
		FROM  materials_inventory
		WHERE id = '$id'
		LIMIT 1
		";
		$item_name = $database->getOne($get_name);
			
		return $item_name;
	}
	
	
	
}