<?
class form_quote_notes
{
	public $id;

	 
	public $config;
	public $validation;
	public $reasons;
	public $sign_counter;
	public $department;
	public $status_table;
	public $status_id;
	
	public function __construct($context)
	{
		$this->id = $context['id'];
		$this->status_table = $context['status_table'];
		$this->status_id  = $context['status'];
		$this->department_id  = $context['dept_id'];
		$this->sign_counter = 0;
	}

	public function set()
	{
		global $database;
	
		  $id = $this->id;
		  $status_id = $this->status_id;
		  $department_id = $this->department_id;
		
		//$database->debug = true;
		
		$this->client_type = 1;
		
		if(!empty($id))
		{															
			$request = common_quotes::get_quotes_details($id);

			$this->sitesurvey_notes = $request['sitesurvey_notes'];
			$this->qualification_notes = $request['qualification_notes'];
			$this->production_notes = $request['production_notes'];
			$this->management_notes = $request['management_notes'];
			$this->finance_notes = $request['finance_notes'];
			$this->visualmockup_notes = $request['visualmockup_notes'];
		}
		
		if($_POST['Submit'] == "Save")
		{					
			 
			$this->sitesurvey_notes =$_POST['sitesurvey_notes'];
			$this->qualification_notes =$_POST['qualification_notes'];
			$this->production_notes =$_POST['production_notes'];
			$this->management_notes =$_POST['management_notes'];
			$this->finance_notes =$_POST['finance_notes'];
			$this->visualmockup_notes =$_POST['visualmockup_notes'];
			$this->flag =$_POST['flag'];
			$this->status = $request['status'];
			
		}


		$this->config['sitesurvey_notes'] = array("id"=> $id,"value"=> $this->sitesurvey_notes, "input_name" => "sitesurvey_notes", "name" => "Site Survey Notes","rule" => "");
		$this->config['qualification_notes'] = array("id"=> $id,"value"=> $this->qualification_notes, "input_name" => "qualification_notes", "name" => "Qualification Notes","rule" => "");
		$this->config['production_notes'] = array("id"=> $id,"value"=> $this->production_notes, "input_name" => "production_notes", "name" => "Production Notes","rule" => "");
		$this->config['management_notes'] = array("id"=> $id,"value"=> $this->management_notes, "input_name" => "management_notes", "name" => "Management Notes","rule" => "");
		$this->config['finance_notes'] = array("id"=> $id,"value"=> $this->finance_notes, "input_name" => "finance_notes", "name" => "Finance Notes","rule" => "");
		$this->config['visualmockup_notes'] = array("id"=> $id,"value"=> $this->visualmockup_notes, "input_name" => "visualmockup_notes", "name" => "Visual Art Mockup Notes","rule" => "");
		
		$this->config['status'] = array("id"=> $id,"value"=> $this->status, "input_name" => "status", "name" => "Status","rule" => "");
		
		 
		self::run_validation();
	}	

	public function run_validation()
	{				
		$static_function = (($_POST['Submit'] == "")) ? "initial" : "validate";		

		if(isset($_POST['Submit']))
		{
			 
		 
		$this->validation['sitesurvey_notes'] = validation::$static_function($this->config['sitesurvey_notes']);																				
		$this->validation['qualification_notes'] = validation::$static_function($this->config['qualification_notes']);																				
		$this->validation['production_notes'] = validation::$static_function($this->config['production_notes']);																				
		$this->validation['management_notes'] = validation::$static_function($this->config['management_notes']);																				
		$this->validation['finance_notes'] = validation::$static_function($this->config['finance_notes']);																				
		$this->validation['visualmockup_notes'] = validation::$static_function($this->config['visualmockup_notes']);																				
 		 
		}
		  
		$this->reasons = validation::formalise($this->validation);
	}
	
	public function form()
	{
		global $database;
		//$department_id = $this->department_id;
		   $id = $this->id;
		   $sql = "SELECT * FROM departments_quotes WHERE id = '$id'";
		   $result=$database->getRow($sql);
		   $department_id = $result['department_id'];
		   
		?>
        <div class="form_wrapper">
        <div id="all_notes">
			FOR BUSINESS DEVELOPMENT DEPARTMENT USE:
			 <br />
				<? 
				 $qualification_notes=nl2br( stripslashes( htmlentities( $this->qualification_notes, ENT_QUOTES, 'UTF-8' ) ) );	
				 $config['qualification_notes'] = array("value" => $qualification_notes);
				 $validation['qualification_notes'] = array("input_name" => "qualification_notes");
				 $options['attr'] = array("cols" => 100);
				 
				 ?>
				<p  style="margin-top:10px;"><div style="margin-top:10px;float:left;margin-right: 50px;">Qualification Notes:</div>  <? echo forms::input_text_area($config['qualification_notes'],$validation['qualification_notes'],$options);?>
				 </p><hr>
				 FOR INSTALLATION DEPARTMENT USE:<br />
				<? $config['sitesurvey_notes'] = array("value" => $this->sitesurvey_notes);
				 $validation['sitesurvey_notes'] = array("input_name" => "sitesurvey_notes");
				 $options['attr'] = array("cols" => 100);
				 ?>
				<p  style="margin-top:10px;"><div style="margin-top:10px;float:left;margin-right: 50px;">Site Survey Notes: </div><? echo forms::input_text_area($config['sitesurvey_notes'],$validation['sitesurvey_notes'],$options);?>
				</p>
				
				
				<hr>
				DESIGN USE:
				 <? $config['visualmockup_notes'] = array("value" => $this->visualmockup_notes);
				 $validation['visualmockup_notes'] = array("input_name" => "visualmockup_notes");
				  $options['attr'] = array("cols" => 100);
				 ?>
				<p  style="margin-top:10px;"><div style="margin-top:10px;float:left;margin-right: 10px;">Visual Art Mockup Notes:</div> <? echo forms::input_text_area($config['visualmockup_notes'],$validation['visualmockup_notes'],$options);?>
				</p>
				<hr>
				PRODUCTION USE:
				 <? $config['production_notes'] = array("value" => $this->production_notes);
				 $validation['production_notes'] = array("input_name" => "production_notes");
				  $options['attr'] = array("cols" => 100);
				 ?>
				<p  style="margin-top:10px;"><div style="margin-top:10px;float:left;margin-right: 50px;">Production Notes:</div> <? echo forms::input_text_area($config['production_notes'],$validation['production_notes'],$options);?>
				</p>
				<hr>
				FOR MANAGEMENT DEPARTMENT USE:
				 <? $config['management_notes'] = array("value" => $this->management_notes);
				 $validation['management_notes'] = array("input_name" => "management_notes");
				  $options['attr'] = array("cols" => 100);
				 ?>
				<p  style="margin-top:10px;"><div style="margin-top:10px;float:left;margin-right: 40px;">Management Notes:</div> <? echo forms::input_text_area($config['management_notes'],$validation['management_notes'],$options);?>
				</p>
				<hr>
				FOR FINANCE DEPARTMENT USE:
				 <? $config['finance_notes'] = array("value" => $this->finance_notes);
				 $validation['finance_notes'] = array("input_name" => "finance_notes");
				  $options['attr'] = array("cols" => 100);
				 ?>
				<p  style="margin-top:10px;"><div style="margin-top:10px;float:left;margin-right: 60px;">Finance Notes:</div> <? echo forms::input_text_area($config['finance_notes'],$validation['finance_notes'],$options);?>
				</p>
                <?
                $config['value']=$department_id;
				$validation['input_name']='department_id';
				echo forms::input_hidden($config ,$validation);
				$config['value']=$result['quote_id'];
				$validation['input_name']='quote_id';
				echo forms::input_hidden($config ,$validation);
				?>
				<p><input class="button" type="submit" value="Save" id="Submit" name="Submit" /></p>
			<hr>	
		</div>	
        </div>
        <?        
	}
	
	public function update_status(){
	
	global $database;
	$quote_id = mysql_real_escape_string(intval($_POST['quote_id']));	
	$reasons = "<br /><br />";					
	$reasons .= trim($this->reasons);
	$qualification_notes = mysql_real_escape_string($_POST['qualification_notes']);
	$sitesurvey_notes = mysql_real_escape_string($_POST['sitesurvey_notes']);
	$visualmockup_notes = mysql_real_escape_string($_POST['visualmockup_notes']);
	$management_notes = mysql_real_escape_string($_POST['management_notes']);
	$finance_notes = mysql_real_escape_string($_POST['finance_notes']);
	$production_notes = mysql_real_escape_string($_POST['production_notes']);
	$department_id= mysql_real_escape_string(intval($_POST['department_id']));
	 
	$submitter = $_SESSION['user']['id'];
	$current_date_time = date('Y-m-d G:i:s');
	 
	if($department_id == 1){ //business development
		if(strlen(trim($qualification_notes)) == 0){
			$reasons .= 'Qualification Notes is required';
		}
	}elseif($department_id == 2){ //installation
		if(strlen(trim($sitesurvey_notes)) == 0){
			$reasons .= 'Site Survey Notes is required';
		}
	}elseif($department_id == 3 ){ //design
		if(strlen(trim($visualmockup_notes)) == 0){
			$reasons .= 'Visual Art Mockup Notes is required';
		}
		
	}elseif($department_id == 4) { //production
		if(strlen(trim($production_notes)) == 0){
			$reasons .= 'Production Notes is required';
		}
	}elseif($department_id == 5) { //management
		if(strlen(trim($management_notes)) == 0){
			$reasons .= 'Management Notes is required';
		}
	}elseif($department_id == 6) { //finance
		if(strlen(trim($finance_notes)) == 0){
			$reasons .= 'Finance Notes is required';
		}
	}
	 
	$check_reasons = strip_tags($reasons);
								
		$results = false;		
				
		 if($check_reasons == "")
		 {
			
			 $database->StartTrans();
  

			    $sql="
  
					UPDATE quotes SET
						 qualification_notes='$qualification_notes'  ,
						 sitesurvey_notes = '$sitesurvey_notes',
						 visualmockup_notes = '$visualmockup_notes',
						 production_notes = '$production_notes',
						 management_notes = '$management_notes',
						 finance_notes = '$finance_notes'
				 	WHERE id = '$quote_id'
				";
		
			  $database->query($sql);
		
			  logs::submit_logs(array("table" => "quotes", "action_type" => 2,"foreign_id" => $id, "description" => "Modified"));
			 
			 
			 $results = $database->CompleteTrans();
		
		 }
	 
	
	 if(!$results)
		{
			confirmation::error_temp("Performing this task".$reasons,"Quote","quote_notes");
			return false;
		}
		else
		{
			confirmation::Success_temp("Performing this task","Quote","quote_notes");	
			return true;			
		}
	
	
	}
	
	
}