<?
	class common_inventory
	{						
		public function get_all_inventory_by_status($status)
		{			
			global $database;

			$get_inventory = "
			SELECT *
			FROM materials_inventory
			WHERE status = '$status'
			ORDER BY item_number ASC
			";
			$results = $database->getAll($get_inventory);
			
			return $results;			
		}

		public function get_all_inventory_with_stock_take($status)
		{
			global $database;
		
			$get_inventory = "
			SELECT m.*, s.prove_by, s.real_quantity, s.submitter as stock_submitter, s.date_submitted as stock_submit_date, s.id as take_id
			FROM materials_inventory m
			LEFT JOIN  stock_take s ON m.id = s.item_no AND s.prove_by =0
			WHERE m.status = '$status'
			ORDER BY m.item_number ASC
			";
			$results = $database->getAll($get_inventory);
				
			return $results;
		}

		public function get_material($id)
		{			
			global $database;

			$get_material = "
			SELECT *
			FROM materials_inventory
			WHERE id = '$id'
			LIMIT 1
			";
			$results = $database->getRow($get_material);
			
			return $results;			
		}
		
		public function get_item_number($id)
		{			
			global $database;

			$get_item_number = "
			SELECT item_number
			FROM materials_inventory
			WHERE id = '$id'
			LIMIT 1
			";
			$results = $database->getOne($get_item_number);
			
			return $results;			
		}

		public function get_status($id)
		{
			global $database;
		
			$sql = "
			SELECT status
			FROM materials_inventory
			WHERE id = '$id'
			";
			return $database->getOne($sql);
		}
																						
	}

?>