<?
class common_attachments
{

      public function get_job_attachments($id)
	  {
	  	global $database;
		
		$sql ="
				SELECT id, filename, filetype  FROM attachments WHERE txn_id = '$id' AND txn_type='jobs' AND status ='1'
			";
                    
		$results= $database->getAll($sql);	
	  
	  	return $results;
	  }
	  
	  
	  public function get_quote_attachments($id)
	  {
	  	global $database;
		
		$sql ="
				SELECT id, filename, filetype  FROM attachments WHERE txn_id = '$id' AND txn_type='quotes' AND status ='1'
			";
                    
					$results= $database->getAll($sql);	
	  
	  	return $results;
	  }
	  
	  
	  
	  public function remove_image($id )
	  {
	  	global $database;
		
		 $sql = "
			DELETE FROM attachments WHERE id = '$id'
		";
		
		$result=$database->query($sql);
		return $result;
	  }
	  
	  
	  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'];
		$id = $context['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 = '$sumitter',
			date_submitted = '$current_date_time'
			WHERE quote_id = '$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;
	  
	  }
	  
	  
	  
}