<?
	class change_status
	{		
		public function change($table,$status_tab,$db_name = "")
		{					
			global $database;
			
		//	$database->debug = true;
					
			$submitter = $_SESSION['user']['id'];
			$page = $_GET['page'];
			$status = $_GET['status'];
						
			$current_page =  $_SERVER['QUERY_STRING'];															
			$current_date_time = date('Y-m-d G:i:s');						
																																														
			if($_POST['Submit'] == "change_status")
			{				
				$status_ref = common_ref_status::get_status($status_tab);				

				$stat_id = $_POST['stat_id'];

				$database->StartTrans();
		
				if(count($_POST['chosen']) > 0)
				{
					foreach($_POST['chosen'] AS $chosen_id)
					{
						$current_status_sql = "
						SELECT status
						FROM $db_name$table
						WHERE id = '$chosen_id'";		
						$current_status = $database->getOne($current_status_sql);
						

				

						$sql = "
						UPDATE $db_name$table
						SET 
						status = '$stat_id',
						date_submitted = '$current_date_time',
						submitter = '$submitter'				
						WHERE id = '$chosen_id'";		
						$database->query($sql);			
						

						logs::submit_logs(array("table" => $table, "action_type" => 3,"foreign_id" => $chosen_id, "description" => "Changed Status from <b>".$status_ref[$current_status]['name']."</b> to <b>".$status_ref[$stat_id]['name']."</b>"));										
					}	
				}			
		
				$results = $database->CompleteTrans();				
		
				redirect::set($current_page);			
			}
			else if($_POST['Submit'] == "delete")
			{
				$database->StartTrans();
		
				if(count($_POST['chosen']) > 0)
				{							
					foreach($_POST['chosen'] AS $chosen_id)
					{
						$sql = "
						DELETE FROM  $db_name$table
						WHERE id = '$chosen_id'";		
						$database->query($sql);			

						logs::submit_logs(array("table" => $table, "action_type" => 5,"foreign_id" => $chosen_id, "description" => "DELETED"));						
					}	
				}			
		
				$results = $database->CompleteTrans();				
		
				redirect::set("$page&status=$status");			
			}		
		}																
	}

?>