<?
class common_quotesheets
{
 
      public function update_materials($materials_total,$id)
	  {
	  	global $database;
		
		$sql = "
		UPDATE quotes_sheets
		SET 
			materials_total = '$materials_total'
		WHERE quote_id ='$id'
		";
		$database->query($sql);	
	  
	  }
	    
	  public function update_all($context=array() )
	  {
	  	global $database;
		$submitter = $_SESSION['user']['id'];
		$current_date_time = date('Y-m-d G:i:s');
		
		$sub_total = $context['sub_total'];
		$delivery_total = $context['delivery_total'];
		$install_total = $context['install_total'];
		$labour_total = $context['labour_total'];
		$artwork_total = $context['artwork_total'];
		$permit_total = $context['permit_total'];
		$subcontractor_total = $context['subcontractor_total'];
		$quote_id = $context['quote_id'];
		
		$sql = "
		UPDATE quotes_sheets
		SET
			delivery_total = '$delivery_total',
			install_total = '$install_total',
			labour_total = '$labour_total',
			artwork_total = '$artwork_total',
			permit_total = '$permit_total',
			subcontractor_cost = '$subcontractor_total',
			sub_total = '$sub_total',
			submitter = '$submitter',
			date_submitted = '$current_date_time'
		WHERE quote_id = '$quote_id'
		
		";
		
		$database->query($sql);
	  
	  }
	  
	  
	  public function get_total_sales($id)
	  {
	  	global $database;
		
		$sql = "
		SELECT * 
		FROM quotes_sheets
		WHERE quote_id ='$id'
		";
		$results=$database->getRow($sql);	
		return $results;
	  
	  }
	  
	  
	  public function update_sheet($context)
	  {
	  	global $database;
		
		$mark_up_rate = $context['mark_up_rate'];
		$mark_up = $context['mark_up'];
		$gst = $context['gst'];
		$total_sales_price = $context['total_sales_price'];
		$quote_id = $context['quote_id'];
		
		
		$sql = "
		UPDATE quotes_sheets
		SET  
			mark_up_rate = '$mark_up_rate',
			mark_up = '$mark_up',
			gst = '$gst',
			total_sales_price= '$total_sales_price'
		WHERE quote_id = '$quote_id'
		";
				 
		$results=$database->query($sql);	
		
		return $results;
	  
	  }
	  
	  
	  
	   public function update_materials_sheet($total,$id)
	  {
	  	global $database;
		
		$mark_up_rate = $context['mark_up_rate'];
		$mark_up = $context['mark_up'];
		$gst = $context['gst'];
		$total_sales_price = $context['total_sales_price'];
		$quote_id = $context['quote_id'];
		
		
		$sql = "
		UPDATE quotes_sheets
		SET 
			materials_total = '$total'
		WHERE quote_id ='$id'
		";
			$database->query($sql);	
		
		return $results;
	  
	  }
	  
	  
	   
	  
	  
	  
}