<?
class list_department_actions
{
	public $status;
	public $order;
	public $method;
	
	public $group_id;

	public $avail_status;
	public $avail_edit;

	public $link_view;
	public $link_edit;
		
	public $db_name;
	public $account_id;
	public $department_id;
			
	public function __construct($context)
	{
		$this->avail_status = $context['avail_status'];
		$this->avail_edit = $context['avail_edit'];

		$this->link_view = $context['link_view'];
		$this->link_edit = $context['link_edit'];
					
		$this->group_id = $context['group_id'];					
		$this->status = $context['status'];
		$this->department_id = $context['department_id'];
		$this->status_table = $context['status_table'];

		$this->db_name = $context['db_name'];
		$this->account_id = $context['account_id'];

		$this->order = (empty($context['order'])) ? "ASC" : $context['order'];
		$this->method = (empty($context['method'])) ? "email" : $context['method'];													
	}
	
	public function get_data()
	{
		global $database;

		$db_name = $this->db_name;
		 $department_id = $this->department_id;

		$account_id = $this->account_id;

		$status = $this->status;
		$group_id = $this->group_id;
			
		$group = ($group_id != "all") ?  "AND group_id = '$group_id'" : "";		
		
		$results = array();
														
		   $get_department = "
		SELECT *
		FROM $db_name"."actions
		WHERE department_id = '$department_id'  ORDER by id ASC
		";
		$results = $database->getAll($get_department);		
		 
		
	/*	$get_company = "
		SELECT 
			id,
			company_name
		FROM companies
		";
		$companies = $database->getAll($get_company);
		
		$company_name = array();
		foreach($companies AS $company)
		{
			$company_name[$company['id']]= $company['company_name'];
		}
		
	 	$get_location = "
		SELECT 
			id,
			CONCAT(address,', ',suburb,', ',state,', ',post_code,', ',country) AS 'address'
		FROM companies_locations
		";
		$locations = $database->getAll($get_location);
		
		$location_address = array();
		foreach($locations AS $location)
		{
			$location_address[$location['id']]= $location['address'];
		}
		
	*/
		
		$count = 0;
		
		$return_results = array();
												
		foreach($results AS $result)					
		{							
			$id = $result['id'];
			$action_name = $result['action_name'];
			$department_id = $result['department_id'];
			$department2_id = $result['department2_id'];
			 
			$status = $result['status'];
			 
			$submitter = $result['submitter'];
			$date_submitted = $result['date_submitted'];
		 
			
			//$name = $first_name." ".$last_name;
									
			$group = common_ref_global_client::get_group($group_id);
			
			$company_id = common_users::get_user_company($id);
			$company = $company_name[$company_id];
			$location_id = common_users::get_user_location($id);
			$location = $location_address[$location_id];

			$submitter = $users[$submitter];
			$date_submitted = dates::change_date_time($date_submitted);
			
			$return_results[] = array("id" => $id,"action_name" =>$action_name, "department2_id" => $department2_id, "department_id" => $department_id,"status" => $status,"submitter" => $submitter,"date_submitted" => $date_submitted);
		}	

		$this->final_results = $return_results;
		                		
		return $this;				
	}
	
	public function show()
    {		
		global $database;
	
		$order = $this->order;
		$method = $this->method;	
		
		$results = $this->final_results;
		$status_table = $this->status_table;

		$avail_status = $this->avail_status;
		$avail_edit = $this->avail_edit;

		$link_view = $this->link_view;							
		$link_edit = $this->link_edit;	
										

		$normalised_results = filter::sort_results($method,$order,$results);						
		$normalise_get = filter::normalise_get($order);								
					
		$pagination_results = filter::pagination($normalised_results,$normalise_get);
//		filter::pagination_html($pagination_results);
				
		$pagination = $pagination_results['pagination'];
		$start = $pagination_results['start'];
		$size = $pagination_results['size'];
		$total_results = $pagination_results['total_results'];
		$max_size = $pagination_results['max_size'];
								
		$order = ($order == "ASC") ? "DESC" : "ASC";					
		$normalise_get = filter::normalise_get($order);		
		
		$new_normalised_results = array();		
		
		foreach($normalised_results AS $key => $value)					
			$new_normalised_results[] = $key;					
												
        ?>
		<table id="the-table" class="table_list" cellpadding="0" cellspacing="0">
        <thead>
        <?		
		if(!$avail_status)
		{
			?>
			<th class="icon"><input type="checkbox" name="all_check_box" id="all_check_box" /></th>            	        
			<?            		
		}
		
		if($avail_edit)
		{
			?>	
	        <th class="icon">Edit</th>                           
			<?
		}
		?>
        <th><a href="&method=department_name">Action Name</a></th>
        <th><a href="&method=department_name">Go To Department</a></th>
        <th><a href="&method=department_name">Status</a></th>
        
        <th class="date_submitted"><a href="&method=date_submitted">Last Modified</a></th>              
        <th class="icons">&nbsp;</th>                                  				
        </thead>
		<tbody>
		<?
		
		$count = 0;
												
		if(count($results) > 0)
		{	
		asort($results);
			?><tbody><?
										
			for($i = $start; $i < $max_size; $i++)
			{	
				  $key = $new_normalised_results[$i];
				
				$mod = $count%2;
				$class = ($mod == 0) ? "odd" : "even";
				$count++;
						
				$id = $results[$key]['id'];
				$action_name = $results[$key]['action_name'];
				$department_id = $results[$key]['department_id'];
				$status = $results[$key]['status'];
				 $department2_id = $results[$key]['department2_id'];
				 $destination_dept = common_department::department_name($department2_id);
				 
				 $status_name = common_ref_status::get_status_name($status_table,$status);
				$submitter = $results[$key]['submitter'];
				$date_submitted = $results[$key]['date_submitted'];
	
				?><tr id="row_" class=""><?

				if(!$avail_status)
				{
					?><td><input id="checkbox_" class="input_clickable" type="checkbox" name="chosen[]" value="" /></td><?				
				}
								
				if($avail_edit)
				{					
					?>
					<td><a href="?page=&department_id=&id="><img src="icons/edit_small.png" border="0" alt="edit" /></a></td>
					<?                		
				}
	
				?>
                <td><a href="?page=&department_id=&id="></a></td>
				 <td></td>
				<td></td>    
                 
				<td></td>					
				<td><img src="/icons/cross_small.png" /></td>					
				</tr>
				<?	
			}
			
			?>
			</tbody>
			<tfoot>
			<tr>
            <?
				if($avail_status)
				{
					?><th>&nbsp;</th><?
				}
								
				if($avail_edit)
				{					
					?><th>&nbsp;</th><?
				}			
			?>
			<th>&nbsp;</th>
			<th>&nbsp;</th>    
			<th>&nbsp;</th>    
			<th>&nbsp;</th>                
			</tr>
			</tfoot>         
			<?
		}
		?>
		</table>
		<?			
	 }
}