<?
class list_labour
{
	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 $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->id = $context['id'];

		$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;

		$account_id = $this->account_id;

		$status = $this->status;
		$id = $this->id;
		$group_id = $this->group_id;
			
		$group = ($group_id != "all") ?  "AND group_id = '$group_id'" : "";		
														
		  /*$get_labour = "
		SELECT *
		FROM $db_name"."labours
		WHERE status = '$status'  
		";
		$results = $database->getAll($get_labour);		
		*/
		$results = common_labours::get_labours($id);
		 
	/*	$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();

		//$users = common_labour::get_labours();
												
		foreach($results AS $result)					
		{							
			$id = $result['id'];
			$labour_name = $result['name'];
			$rate = $result['rate'];
			$units = $result['units'];
			$fieldtype = $result['fieldtype'];
			 
			$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,"labour_name" => $labour_name, "rate" => $rate, "fieldtype" =>$fieldtype, "units" => $units ,"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;

		$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=labour_name">Labour Name</a></th>        
               
        <th><a href="&method=labour_name">Rate</a></th>        
        <th class="date_submitted"><a href="&method=date_submitted">Last Modified</a></th>                                                				
        <th class="date_submitted"> </th>                                                				
        </thead>
		<tbody>
		<?
		
		$count = 0;
												
		if(count($results) > 0)
		{	
			?><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'];
				$labour_name = $results[$key]['labour_name'];
				$rate = $results[$key]['rate'];
				$fieldtype = $results[$key]['fieldtype'];
				 
				$status = $results[$key]['status'];
				$submitter = $results[$key]['submitter'];
				$date_submitted = $results[$key]['date_submitted'];
				//$subresults = common_labours::get_all_sublabours($id);
				
				
				?><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=&id="><img src="icons/edit_small.png" border="0" alt="edit" /></a></td>
					<?                		
				}
	
				?>
                <td><a class="sub" href="javascript:void(0);" id="" name=""></a></td>
				 
				<td id="subrate_"></td>    
				 
				<td></td>					
				<td><img src="icons/minus_small.png"><?
					$validation['input_name'] = 'fieldtype_'.$id;
					$config['value'] =$fieldtype;
					echo forms::input_hidden($config,$validation,$options); ?></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>
		
		<script>
		 $(document).ready(function() {
				 
			$("a.sub").click(function(){
				 
				//$(".tab_form").show();
				var id = $(this).attr('id');
				var task = $(this).text();
				var rate = $("td#subrate_"+id).text();
				var field = $("#fieldtype_"+id).val();
				$("#labour_name").val(task);
				$("#rate").val(rate);
				$("#lid").val(id);
				$("#fieldtype").val(field);
				
				//window.location.href="?page=setup_labours&id="+id;

			});	 
			});
			
		
		</script>
		<?			
	 }
}