<?
class list_contacts extends listing
{
	public $status;
	public $order;
	public $method;

	public $avail_edit;
	public $avail_status;
	
	public $link_view;
	public $link_edit;
		
	public $alpha;
	public $results;

	public $final_results;
			
	public function __construct($context)
	{						
		parent::set_data($context);							
					
		$this->status = $context['status'];
			
		$this->order = (empty($context['list_config']['order'])) ? "ASC" : $context['list_config']['order'];
		$this->method = (empty($context['list_config']['method'])) ? "name" : $context['list_config']['method'];													
	}
	
	public function get_data()
	{		
		global $database;
		
		$status = $this->status;
		
		$clients = common_ref_client::get_all_clients();
		$suppliers = common_ref_client::get_all_suppliers();
		$contact_types = common_ref_global_client::get_all_contact_types();
		$users = common_users::get_users();
				
		$get_clients = "
		SELECT *
		FROM contacts
		WHERE status = '$status'
		";						
		$results = $database->getAll($get_clients);
						
		$count = 0;
		
		$return_results = array();
		
		if(is_array($results))
		{		
			foreach($results AS $result)		
			{				
/*				$id = $result['id'];
				$first_name = $result['first_name'];
				$last_name = $result['last_name'];
				$company_name = $result['company_name'];
				$client_id = $result['client_id'];
				$contact_type_id = $result['contact_type_id'];

				$job_title = $result['job_title'];
				$title = $result['title'];
				$business_phone = $result['business_phone'];
				$home_phone = $result['home_phone'];
				$mobile_phone = $result['mobile_phone'];
				$fax = $result['fax'];
				$email = $result['email'];
				$status = $result['status'];
				$privacy = $result['privacy'];			
				$creator = $result['creator'];
				$date_created = $result['date_created'];
				$submitter = $result['submitter'];
				$date_submitted = $result['date_submitted'];	*/	
					
				$result['name'] = trim($result['first_name']." ".$result['last_name']);
				$result['name'] = (empty($result['name'])) ? "-" : $result['name'];
				
				if($result['name'] != "-")
				{
					$result['mobile_phone'] = (!empty($result['mobile_phone'])) ? $result['mobile_phone'] : "-";
					$result['business_phone'] = (!empty($result['business_phone'])) ? $result['business_phone'] : "-";
					$result['home_phone'] = (!empty($result['home_phone'])) ? $result['home_phone'] : "-";
	
					$result['fax'] = (!empty($result['fax'])) ? $result['fax'] : "-";
											
					$result['submitter'] = $users[$submitter];
					
					if($result['contact_type_id'] == 1)
						$result['company_name'] = $suppliers[$result['client_id']]['name'];
					else if($result['contact_type_id'] == 2)
						$result['company_name'] = $clients[$result['client_id']]['company_name'];
					else
						$result['company_name'] = (empty($company_name)) ? "-" : $company_name;
					
					$result['contact_type'] = $contact_types[$result['contact_type_id']]['name'];
					
					$return_results[] = $result;
					
/*					$return_results[] = array(
						"id" => $id,
						"name" => $name,
						"company_name" => $company_name,
						"contact_type" => $contact_type,
						"mobile_phone" => $mobile_phone,
						"business_phone" => $business_phone,
						"home_phone" => $home_phone,
						"fax" => $fax,
						"email" => $email,
						"notes" => $num_notes,
						"submitter" => $submitter,
						"date_submitted" => $date_submitted
					);*/
				}

			}
		}
				
		$this->final_results = $return_results;

		self::prepare();
		                		
		return $this;
	}
	
	public function show()
    {
		$order = $this->order;
		$method = $this->method;	
		$status = $this->status;

		$avail_edit = $this->avail_edit;
		$avail_status = $this->avail_status;
		
		$link_view = $this->link_view;
		$link_edit = $this->link_edit;
				
		$results = $this->final_results;						
				
		$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" style="margin-top:5px;" cellpadding="0" cellspacing="0">
        <thead>
        <tr>
        <?				
				
		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=name">Name</a></th>
        <th><a href="&method=company_name">Company</a></th>
        <th><a href="&method=contact_type">Contact Type</a></th>
        <th><a href="&method=email">Email</a></th>
        <th><a href="&method=business_phone">Business Phone</a></th>
        <th><a href="&method=mobile_phone">Mobile Phone</a></th>        
        <th><a href="&method=home_phone">Home Phone</a></th>        
        <th><a href="&method=fax">Fax</a></th>                
        <th><a href="&method=notes">Notes</a></th>
<!--        <th class="submitter"><a href="&method=submitter">Submitter</a></th>
        <th class="date_submitted"><a href="&method=date_submitted">Date Submitted</a></th>      -->  
        </tr>	
        </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'];
				$name = $results[$key]['name'];
				$company_name = $results[$key]['company_name'];
				$contact_type = $results[$key]['contact_type'];
	
				$email = $results[$key]['email'];
				$notes = $results[$key]['notes'];
	
				$business_phone = $results[$key]['business_phone'];
				$mobile_phone = $results[$key]['mobile_phone'];
				$home_phone = $results[$key]['home_phone'];
				$fax = $results[$key]['fax'];
	
				$submitter = $results[$key]['submitter'];		
				$date_submitted = $results[$key]['date_submitted'];		
	
				$date_submitted = dates::change_date_time($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=&id="><img src="icons/edit_small.png" height="18" border="0" alt="edit" /></a></td><?                
				}	
				?>
				<td><a href="?page=&id="></a></td>
				<td></td>    	            
				<td></td>    	                        
				<td><a href="mailto:"></a></td>
				<td></td>    	            
				<td></td>    	            
				<td></td>    	            
				<td></td>    	            
				<td><a id="notes_" class="notes" ></a></td>
<!--				<td></td>    	            
				<td></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>
			<th>&nbsp;</th>
			<th>&nbsp;</th>
			<th>&nbsp;</th>
			<th>&nbsp;</th>                                        
			<th>&nbsp;</th>
<!--			<th>&nbsp;</th>
			<th>&nbsp;</th>-->
			</tr>                    
			</tfoot>           
			<?
		}
		?>
        </table>     
        <div id="add_notes" title="Add New Note"></div>
        <div id="notes" title="Note"></div>
        
		<script type="text/javascript">
            
        $(".notes").click(function(){
            
            this_id = this.id;
            myArray = this_id.split('_'); 				
            
            id = myArray[1];
                    
            $('#notes').load("ajax_presentation.php",{id: id, table: "contacts", page: 'show_notes'}).dialog('open');		
            
            return false;
        });
    
        $('#notes').dialog({
                resizable: false,			
                autoOpen: false,
                width: 700,							
                height: 350,							
                buttons: {
                    "Close": function() { 
                        $(this).dialog("close"); 
                    },
                    "Add New Note": function() { 
                        id = $("#foreign_id").prop("value");
                        table = $("#table").prop("value");
                                                                                    
                        $('#add_notes').load("ajax_presentation.php",{id: id, table: table, page: 'add_notes'}).dialog('open');						
                    },				
                }
            });	

	$('#add_notes').dialog({
			resizable: false,			
			autoOpen: false,
			width: 400,							
			height: 300,							
			buttons: {
				"Cancel": function() { 
					$(this).dialog("close"); 
				},
				"Add": function() { 
					id = $("#foreign_id").prop("value");
					table = $("#table").prop("value");
					notes_description = $("#notes_description").prop("value");

					dataString = "id=" + id + "&table=" + table  + "&notes_description=" + notes_description + "&page=add_note";
															
					$.ajax({
						type: "POST",
						url: "ajax_process.php",
						data: dataString,
						dataType:  'json',		
						success: function(json) {
						
							if(json.status == "true")
							{
								$('#notes').load("ajax_presentation.php",{id: id, table: "contacts", page: 'show_notes'});
								$("#add_notes").dialog("close"); 
							}
							else
							{
								dialog_fail("Failed to add note!!");							
							}														
						}
					});																				
				}	
			}
		});				
		</script>                   
		<?		
	 }	
}