<?
class list_materials
{
	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 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;
		$quote_id = $this->id;
		$status = $this->status;
		$group_id = $this->group_id;
			
		$group = ($group_id != "all") ?  "AND group_id = '$group_id'" : "";		
														
	  	/*$get_materials = "
			SELECT *
			FROM $db_name"."quotes_materials
			WHERE quote_id = '$quote_id'  
			";*/
		//$results = $database->getAll($get_materials);		
		 
		$results = common_materials::get_quote_materials($quote_id);
		//$results = common_materials::get_all_materialss();
		
		$count = 0;
		
		$return_results = array();

		//$users = common_materials::get_materialss();
												
		foreach($results AS $result)
		{
			//print $result['id']." :: ";	
			$id = $result['id'];
			$item = $result['item'];
			$materials = $result['materials'];
			$supplier = $result['supplier'];
			$quantity = $result['quantity'];
			$inv_exclude = $result['inv_exclude'];
			 
			$price = $result['price'];
			$total = $result['total'];
			 
			$submitter = $result['submitter'];
			$date_submitted = $result['date_submitted'];

			$submitter = $users[$submitter];
			$date_submitted = dates::change_date_time($date_submitted);
			
			$return_results[] = array("id" => $id, "item" => $item ,"materials" => $materials, "total" => $total,
				"supplier" => $supplier, "quantity" => $quantity ,"price" => $price, "inv_exclude"=>$inv_exclude,
				"submitter" => $submitter,"date_submitted" => $date_submitted);
		}	

		$this->final_results = $return_results;
		                		
		return $this;				
	}
	
	public function show()
    {		
		global $database;
		
		$quote_id = $this->id;
	
		$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;					

    	/** Kai 03/20/2013*/
		/** disable costing changes fater quote approved, only admin level user to update*/
		$display_info		= false;
		$group_id			= $_SESSION['user']['group_id'];
		$user_id			= $_SESSION['user']['id'];
		$admin_groups		= array(31,42,43);
		
		/*user is the manager if Estimating & Purchasing, allow editing*/
		if(in_array($group_id, $admin_groups)||$user_id==58){
			$display_info = false;
		}else{
			$get_job_details 	= "SELECT * FROM jobs WHERE status <>53  AND quote_id =".$this->id;
			$job_details 		= $database->getAll($get_job_details);
			/** Kai 15/11/2012*/
			if(empty($job_details)){
					$display_info=false;
			}else{
				/** this query is to get job with id and direction states that Decision will go to Production in order to make sure that quote can be edit before production*/
				$get_job_decisions	= "SELECT * FROM project_workflow WHERE foreign_id = ".$job_details[0]['id']." AND project_workflow.table = 'jobs' AND direction = 'yes'";
				$job_decisions 		= $database->getAll($get_job_decisions);
					
				/** this array includes workflow ids that leds to the productions, which means after this stage, quote is not able to edit*/
				$decisions			= array(35,373,419,433);
				if(!empty($job_decisions)){
					/** no more edit after decisions above have been decided*/
					foreach($job_decisions as $jd){
						if(in_array($jd['workflow_id'],$decisions))
							$display_info = true;
					}
				}else{
					$display_info = false;
				}
			}
		}
        ?>
		<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&&!$display_info)
		{
			?>	
	        <th class="icon">Edit</th>                           
			<?
		}
		?>
            <th><a href="&method=item">Code</a></th>
            <th><a href="&method=materials">Material Description</a></th>        
            <th><a href="&method=supplier">Supplier</a></th> 
            <th><a href="&method=inv_exclude">Inventory</a></th>         
            <th><a href="&method=quantity">Quantity</a></th>        
            <th><a href="&method=price">Price</a></th>              
            <th><a href="&method=total">Total</a></th>        
                        <th class="icon">Del</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'];
				$item  = $results[$key]['item'];
				$materials  = $results[$key]['materials'];
				$supplier = $results[$key]['supplier'];
				$quantity = $results[$key]['quantity'];
				$price = $results[$key]['price'];
				$inv_exclude = $results[$key]['inv_exclude'];
				$total = $results[$key]['total'];
				$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&&!$display_info)
				{					
					?>
					<td><a href="?page=&id=&material_id="><img src="icons/edit_small.png" border="0" alt="edit" /></a></td>
					<?                		
				}
	
				?>
                <td class="item"></td>
                <td class="materials"><a href="" class="mats" ></a></td>
				<td class="materials"></td>
				<td class="materials">Yes</td>
				<td class="materials"></td>    
				<td class="materials">$0.00</td>    
				<td class="materials">$0.00</td>
								<td><img src="images/minus_small.png" width="18"  class="delete_rowlist" id="img_"></td>
				 
				</tr>
				<? 
				 $gtotal += $total;
			}
			
			?>
			</tbody>
			<tfoot>
			<tr>
            <?
			if($avail_status)
			{
				?><th>&nbsp;</th><?
			}
							
			if($avail_edit&&!$display_info)
			{					
				?><th>&nbsp;</th><?
			}			
			?>
			<th>&nbsp;</th>
            <th>&nbsp;</th>
			<th>&nbsp;</th>
			<th>&nbsp;</th>
			<th>&nbsp;</th>
			<th>&nbsp;</th>           
			<th>&nbsp;<div id="material_grand_total">$0.00</div></th>
			            <th>&nbsp;</th>
              
			</tr>
			</tfoot>         
			<?
		}
		?>
		</table>
		<?			
	 }
}