<?
class form_quote_sheet
{
public $id;

	 

	public $config;
	public $validation;
	public $reasons;
	public $sign_counter;
	public $department;
	public $status_table;
	public $status_id;
	public $qid;
	
	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;
		
		//$database->debug = true;
		
		$this->client_type = 1;
		
		if(!empty($id))
		{															
			$request = common_quotes::get_quotes_details($id);
			 //bug::bug_array('',$request);
			$this->company_id = $request['client_id'];
			$this->client_id = $request['client_id'];
			$this->qid = $request['id'];
			
			$this->company_name = common_clients::get_client_name($request['client_id']);
									
			$this->primary_location_id = $request['primary_location_id'];
			$this->location_id = $request['primary_location_id'];
			
			$location_details = common_ref_client::get_client_location($this->primary_location_id);			
														
			$this->address = $location_details['address'];
			$this->suburb = $location_details['suburb'];
			$this->state = $location_details['state'];
			$this->post_code = $location_details['post_code'];

			$this->first_name = $request['first_name'];
			$this->last_name = $request['last_name'];
			$this->phone = $request['phone'];
			$this->email = $request['email'];
			$this->job_tag = $request['job_tag'];			
			$this->job_number = $request['job_number'];
			$this->job_name = $request['job_name'];
			$this->description = $request['description'];
			$this->phone = $request['phone'];
			$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'];
			$this->flag = $request['flag'];
			$this->status = $request['dqstatus'];
			 
/*			$this->jobtypes= unserialize($request['jobtype']);
			
			if(is_array($this->jobtypes))
			{
				foreach($this->jobtypes as $k )
				{
					$newk = explode('=>',$k);
					
					$this->$newk[0] = $newk[1];
					$this->config{$newk[0]} = array("id"=> $id,"value"=> $newk[1], "input_name" => $newk[0], "name" => $newk[0],"rule" => "");		
				}
			}	*/		 
		}		
		
		if($_POST['Submit'] == "Save")
		{					
			  
			$this->address = $this->address;
			$this->post_code = $this->post_code;
			$this->state = $this->state;
			$this->suburb = $this->suburb;
			$this->country = $this->country;	
			$this->phone = $this->phone;
						
			$this->first_name = $_POST['first_name'];
			$this->last_name = $_POST['last_name'];
			$this->email = $_POST['email'];					

			$this->client_id = $_POST['client_id'];
			$this->location_id = $_POST['location_id'];
			$this->primary_location_id = $this->primary_location_id;				
					
			$this->job_number = $this->job_number;
			$this->job_tag = $this->job_tag;
			$this->description = $this->description;
			$this->job_type = $_POST['jobtype'];
			$this->company = $this->company;
			$this->sitesurvey_notes =$this->sitesurvey_notes;
			$this->qualification_notes =$this->qualification_notes;
			$this->production_notes =$this->production_notes;
			$this->management_notes =$this->management_notes;
			$this->finance_notes =$this->finance_notes;
			$this->visualmockup_notes =$this->visualmockup_notes;
			$this->flag =$this->flag;
			$this->status = $request['status'];
			
			foreach($_POST as $post => $pp){
					if (preg_match("/jobtype/i", $post)) {
						//echo $post;
						$this->$post = $pp;
					}  
				}
			foreach($_POST as $sign => $ss){
					if (preg_match("/signtype/i", $sign)) {
						//echo $post;
						$this->$sign = $ss;
					}  
				}
			 if($this->sign_counter > 0){
				$this->reasons .= "Required at least one";
				}		
		}
		 

		/* 
		$this->config['address'] = array("id"=> $id,"value"=> $this->address, "input_name" => "address", "name" => "Address","rule" => "required");
		$this->config['post_code'] = array("id"=> $id,"value"=> $this->post_code, "input_name" => "post_code", "name" => "Post Code","rule" => "required|integer|exact_length[4]");
		$this->config['state'] = array("id"=> $id,"value"=> $this->state, "input_name" => "state", "name" => "State","rule" => "required");
		$this->config['suburb'] = array("id"=> $id,"value"=> $this->suburb, "input_name" => "suburb", "name" => "Suburb","rule" => "required");
		
		$this->config['first_name'] = array("id"=> $id,"value"=> $this->first_name, "input_name" => "first_name", "name" => "First Name","rule" => "required");
		$this->config['last_name'] = array("id"=> $id,"value"=> $this->last_name, "input_name" => "last_name", "name" => "Last Name","rule" => "required");		
		$this->config['phone'] = array("id"=> $id,"value"=> $this->phone, "input_name" => "phone", "name" => "Phone","rule" => "required");				
		$this->config['email'] = array("id"=> $id,"value"=> $this->email, "input_name" => "email", "name" => "Email","rule" => "valid_email");		
	
		
		$this->config['location_id'] = array("id"=> $id,"value"=> $this->location_id, "input_name" => "location_id", "name" => "Address","rule" => "required");			
		
		$this->config['job_number'] = array("id"=> $id,"value"=> $this->job_number, "input_name" => "job_number", "name" => "Job Number","rule" => "required");
		$this->config['description'] = array("id"=> $id,"value"=> $this->description, "input_name" => "description", "name" => "Description","rule" => "required");
		$this->config['jobtype_id'] = array("id"=> $id,"value"=> $this->jobtype_id, "input_name" => "jobtype_id", "name" => "Job Type ID","rule" => "");
		*/
		$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['client_id'] = array("id"=> $id,"value"=> $this->client_id, "input_name" => "client_id", "name" => "Client","rule" => "required"); 
		$this->config['status'] = array("id"=> $id,"value"=> $this->status, "input_name" => "status", "name" => "Status","rule" => "");
		
		foreach($_POST as $post => $pp){
					if (preg_match("/jobtype/i", $post)) {
						//echo $post;
					 	$this->config{$post} = array("id"=> $id,"value"=> $pp, "input_name" => $post, "name" => $post,"rule" => "");
		
					}
				}
		foreach($_POST as $sign => $ss){
					if (preg_match("/signtype/i", $sign)) {
						//echo $post;
					 	$this->config{$sign} = array("id"=> $id,"value"=> $ss, "input_name" => $sign, "name" => $sign,"rule" => "required");
		
					}  
				}
		 
			
		self::run_validation();
	}	

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

		/*if(isset($_POST['Submit']))
		{
			if($this->create_new_client == 1)
			{
				if($this->client_type == 1)
					$this->validation['new_company_name'] = validation::$static_function($this->config['new_company_name']);								

				
				$this->validation['location_id'] = validation::initial($this->config['location_id']);										
			}
			else
			{				
				$this->validation['new_company_name'] = validation::initial($this->config['new_company_name']);																													
				$this->validation['client_id'] = validation::$static_function($this->config['client_id']);														
				$this->validation['location_id'] = validation::$static_function($this->config['location_id']);										
			}
		}
		else
		{
			$this->validation['new_company_name'] = validation::$static_function($this->config['new_company_name']);																					
			$this->validation['client_id'] = validation::$static_function($this->config['client_id']);										
			$this->validation['location_id'] = validation::$static_function($this->config['location_id']);										
		}
		*/
		$this->validation['job_number'] = validation::$static_function($this->config['job_number']);						
		$this->validation['description'] = validation::$static_function($this->config['description']);																				
		$this->validation['client_id'] = validation::initial($this->config['client_id']);										
		$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->validation['address'] = validation::$static_function($this->config['address']);										
		$this->validation['post_code'] = validation::$static_function($this->config['post_code']);										
		$this->validation['state'] = validation::$static_function($this->config['state']);										
		$this->validation['suburb'] = validation::$static_function($this->config['suburb']);		
			
		$this->validation['first_name'] = validation::$static_function($this->config['first_name']);										
		$this->validation['last_name'] = validation::$static_function($this->config['last_name']);										
		$this->validation['phone'] = validation::$static_function($this->config['phone']);										
		$this->validation['email'] = validation::$static_function($this->config['email']);		
		*/		 
		foreach($_POST as $post => $pp){
					if (preg_match("/jobtype/i", $post)) {
						//echo $post;
						$this->validation{$post} = validation::$static_function($this->config{$post});
					}  
				}
		foreach($_POST as $sign => $ss){
					 
					if (preg_match("/signtype/i", $sign)) {
						//echo $post;
						$this->sign_counter++;
						$this->validation{$sign} = validation::$static_function($this->config{$sign});
					}  
				}
		 																		
																						
		$this->validation['jobtype_id'] = validation::$static_function($this->config['jobtype_id']);
		$this->validation['status'] = validation::$static_function($this->config['status']);																				
		 
		$this->reasons = validation::formalise($this->validation);
	}
	
	public function view()
	{
		global $database;

		$id = $this->id;
		$qid = $this->qid;
		$flag = $this->flag;
		$status_table = $this->status_table;
		$status_id = $this->status;
		$department_id = $this->department_id;
		$location_id = $this->location_id;
		$primary_location_id = $this->primary_location_id;
		$client_id = $this->client_id;
		$qualification_notes = $this->qualification_notes;

		$company_name = $this->company_name;
		$job_number = $this->job_number;
		$company_id = $this->company_id;
		 
		$address = $this->address;
		$suburb = $this->suburb;
		$state = $this->state;
		$post_code = $this->post_code;

		$job_name = $this->job_name;
		$description = $this->description;

		$description = nl2br( stripslashes( htmlentities( $description, ENT_QUOTES, 'UTF-8' ) ) );	

		$phone = $this->phone;
		$fax = $this->fax;
		 
		$jobtypes=$this->jobtypes;
		 						 
		 
		$options = array("class" => "medium");
									
		?>	
        	
        <div class="form_wrapper">	                                                        
			
			 <?
			 	 //$sql = "
						//SELECT * FROM quotes_sheets 
						//WHERE quote_id = '$id'
						//";
						
				 
				//$results = $database->getRow($sql);
				$results = common_quotesheets::get_total_sales($id);  
					 
					
				$text_options = array("class" => "medium");
				$text_options_smalls = array("class" => "smalls");
				$text_options_small = array("class" => "small");
				$text_area_options = array("class" => "medium");
				$select_options = array("class" => "medium form");
				$text_options_small_readonly['class'] =   "small";
				$text_options_medium_readonly['class'] =   "medium";
				$text_options_small_readonlys['class'] =   "smalls";
				$text_options_small_readonly['attr'] =    array("readonly"=>"readonly");
				$text_options_small_readonly['style'] =   "border:0; text-align:right;background:#efefef;";
				
				$text_options_smalls_readonly['attr'] =    array("readonly"=>"readonly");
				$text_options_smalls_readonly['style'] =   "border:0; text-align:right;background:#efefef;";
				$text_options_smalls_readonly['class'] = "smalls";
			 
			 
             ?>
   
             		 <div id="defalut_sheet">		
                    <table class="tab_form" cellspacing="0" border="1">   
                    <tr>
                    	<td>Number of Sites</td>
                        <td>
                          <?	
                                    $config['value']='1';
                                    $validation['input_name']='site_number';
                                    echo forms::input_text($config,$validation,$text_options_small ); 
                                ?><input type="button" class="button" id="calculate" name="calculate" value="Calculate" />
                        </td>
                    </tr>
                    <tr>
                    	<td class="table_header"><h2>Costing Component</h2></td>
                    	<td class="table_header">Cost</td>
					</tr>
                   
                    <tr><td>Artwork</td> <td>$
								<?	
                                    $config['value']=number_format($results['artwork_total'],2);
                                    $validation['input_name']='artwork_total';
                                    echo forms::input_text($config,$validation,$text_options_smalls_readonly); 
                                ?>
                    </td></tr>
                    <tr><td>Permits/Survey</td> <td>$
								<?	
                                    $config['value']=number_format($results['permit_total'],2);
                                    $validation['input_name']='permit_total';
                                    echo forms::input_text($config,$validation,$text_options_smalls_readonly); 
                    			?>
                    </td></tr>
                    <tr><td>Labour (inc. Metro Install In House Labour)</td> <td>$
								<?	
                                    $config['value']=number_format($results['labour_total'],2);
                                    $validation['input_name']='labour_total';
                                    echo forms::input_text($config,$validation,$text_options_smalls_readonly); 
                    			?>
                    </td></tr>
                    <tr><td>Material</td> <td>$
								<?	//get values from quotes_materials table
									//$sql = "SELECT SUM(total) as total FROM quotes_materials WHERE quote_id = '$id'";
									//$materials = $database->getRow($sql);
									$materials = common_materials::get_total($id);
                                    $config['value']=number_format($materials,2);
                                    $validation['input_name']='materials_total';
                                    echo forms::input_text($config,$validation,$text_options_smalls_readonly); 
                    			?>
								
                    </td></tr>
                    <tr><td>Delivery</td> <td>$
								<?	
                                    $config['value']=number_format($results['delivery_total'],2);
                                    $validation['input_name']='delivery_total';
                                    echo forms::input_text($config,$validation,$text_options_smalls_readonly); 
                    			?>
                    </td></tr>
                    <tr><td>External Installation</td> <td>$
								<?	
                                    $config['value']=number_format($results['install_total'],2);
                                    $validation['input_name']='install_total';
                                    echo forms::input_text($config,$validation,$text_options_smalls_readonly); 
                    			?>
					</td></tr>
                    <tr><td>Alternate Sub Contractor installation Cost</td> <td>$
								<?	
                                    $config['value']=number_format($results['subcontractor_cost'],2);
                                    $validation['input_name']='subcontractor_cost';
                                    echo forms::input_text($config,$validation,$text_options_smalls_readonly); 
                    			?>
					</td></tr>
                    <tr>
                    	<td>&nbsp;</td>
                        <td>&nbsp;</td>
                    </tr>
                    <tr><td class="table_header"><h2>Sub Total</h2></td> <td class="table_header subtotal">$
								<?	
                                    $config['value']=number_format($results['sub_total']+$materials,2);
                                    $validation['input_name']='sub_total';
									$text_options_small_readonly['style'] =   "border:0; text-align:right;background:#fed5b9;width:120px";
                                    echo forms::input_text($config,$validation,$text_options_small_readonly); 
                    			?>
								 
                    </td></tr>
                    <tr><td><span class="mark">Mark Up</span> <?	
                                    $config['value']=$results['mark_up_rate'] ;
                                    $validation['input_name']='mark_up_rate';
									$text_options_small_readonly['style'] =   "border:0; text-align:right;background:#efefef;";
									 
                                    echo forms::input_text($config,$validation,$text_options_smalls); 
                    				?></td> <td>$
								<?	
                                    $config['value']=number_format($results['mark_up'],0);
                                    $validation['input_name']='mark_up';
                                    echo forms::input_text($config,$validation,$text_options_smalls_readonly); 
                    			?>
					</td></tr>
                    <tr><td>Plus GST</td> <td  class="gst">$
								<?	
                                    $config['value']=number_format($results['gst'],2);
                                    $validation['input_name']='gst';
                                    echo forms::input_text($config,$validation,$text_options_smalls_readonly); 
                    			?>
					</td></tr>
                   <tr>
                    	<td>&nbsp;</td>
                        <td>&nbsp;</td>
                    </tr>                    
                    <tr><td  class="table_header"><h2>Total Sales Price</h2></td> <td  class="table_header">$
								<?	
                                    $config['value']=ceil($results['total_sales_price']);
                                    $validation['input_name']='total_sales_price';
									$text_options_small_readonly['style'] =   "border:0; text-align:right;background:#fed5b9;font-weight:bold;width:120px;";
                                    echo forms::input_text($config,$validation,$text_options_small_readonly); 
                    			?>
					</td></tr>
                    <tr><td>&nbsp;</td><td>&nbsp;</td></tr>
                    <tr>
                    	<td class="submit_form">&nbsp;</td>            
                        <td class="submit_form">
                            <input class="button" type="submit" name="Submit" id="Submit" value="Save" />
                        </td>
                    </tr>
                    </table>
                    
                    <script type="text/javascript">
						$(function() {
							
							var artwork_total= $("#artwork_total").val();
							var permit_total= $("#permit_total").val();
							var labour_total= $("#labour_total").val();
							var materials_total= $("#materials_total").val();
							var delivery_total= $("#delivery_total").val();
							var install_total= $("#install_total").val();
							var subcontractor_cost= $("#subcontractor_cost").val();
							var sub_total= $("#sub_total").val();
							var mark_up= $("#mark_up").val();
							var gst= $("#gst").val();
							var total_sales_price= $("#total_sales_price").val();
							
							
							$("#calculate").click(function(){
							
								var num=$("#site_number").val();
								 
								
								$("#artwork_total").val(num2money(artwork_total.replace(",","") * num));
								$("#permit_total").val(num2money(permit_total.replace(",","") * num));
								$("#labour_total").val(num2money(labour_total.replace(",","") * num));
								$("#materials_total").val(num2money(materials_total.replace(",","") * num));
								$("#delivery_total").val(num2money( delivery_total.replace(",","") * num));
								$("#install_total").val(num2money(install_total.replace(",","") * num));
								$("#subcontractor_cost").val(num2money(subcontractor_cost.replace(",","") * num));
								$("#sub_total").val(num2money(sub_total.replace(",","") * num));
								//$("#mark_up").val(num2money(mark_up.replace(",","") * num));
								$("#mark_up").val('0.00');
								$("#gst").val('0.00');
								$("#mark_up_rate").val('0.00');
								$(".mark").css('color','red');
								$("#total_sales_price").val(num2money(sub_total.replace(",","") * num));
							
							});
							
							 
							
							$("#mark_up_rate").keyup(function(){
								var markup_rate = $("#mark_up_rate").val();
								var sub_total = $("#sub_total").val().replace(/,/g,"");
								var total = $("#total_sales_price").val();
								var gst = $("#gst").val();
								if(markup_rate != ''){
								var markup= parseFloat(sub_total) * parseFloat(markup_rate);
								$(".mark").css('color','#000');
								gst = 0.1 * markup ;//10% of markup
								$("#mark_up").val(num2money(Math.ceil(markup)));
								$("#gst").val(num2money(gst));
								total = gst + markup;
								$("#total_sales_price").val(num2money(Math.ceil(total)));
								}else{
								$("#mark_up").val(0);
								$("#gst").val(0);
								$("#total_sales_price").val(num2money(Math.ceil(total_sales_price)));
								}
								
							});
							
							function num2money(n_value) {
								// validate input
								if (isNaN(Number(n_value)))
								return '';
		
								// save the sign
								var b_negative = Boolean(n_value < 0);
								n_value = Math.abs(n_value);
		
								// round to 1/100 precision, add ending zeroes if needed
								var s_result = String(Math.round(n_value * 1e2) % 1e2 + '00').substring(0, 2);
		
								// separate all orders
								var b_first = true;
								var s_subresult;
								while (n_value >= 1) {
								s_subresult = (n_value >= 1e3 ? '00' : '') + Math.floor(n_value % 1e3);
								s_result = s_subresult.slice(-3) + (b_first ? '.' : ',') + s_result;
								b_first = false;
								n_value = n_value / 1e3;
								}
								// add at least one integer digit
								if (b_first)
								s_result = '0.' + s_result;
		
								// apply formatting and return
								return b_negative
								? '(' + s_result + ')'
								: '' + s_result;
							}	
						});
                    </script>
                    
             </div>											 				
        </div>		 
		<?							
	}
	 
	
	
	public function new_submit()
	{
		global $database;

		$db_name = $this->db_name;
		$id = $this->id;
		$reasons = "<br /><br />";					
		$reasons .= trim($this->reasons);
		
		$check_reasons = strip_tags($reasons);
		 
		$results = false;
		
		$sql_string = "";
		 
		if($check_reasons == "")
		{							
			$submitter = $_SESSION['user']['id'];
			$current_date_time = date('Y-m-d G:i:s');

			 
		 
			$mark_up_rate = mysql_real_escape_string($_POST['mark_up_rate']);
			$mark_up = mysql_real_escape_string(str_replace(',','',$_POST['mark_up']));
			$gst = mysql_real_escape_string(str_replace(',','',$_POST['gst']));
			$total_sales_price = mysql_real_escape_string(str_replace(',','',$_POST['total_sales_price']));
	 
			
			 
				$database->StartTrans(); 
				
			 	/*$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 = '$id'
						";
				 
				  $database->query($sql);*/
				  $context = array(
				  			"mark_up_rate" => $mark_up_rate,
							"mark_up" => $mark_up,
							"gst"	=> $gst,
							"total_sales_price" => $total_sales_price,
							"quote_id" => $id	
				  
				 			 );
				common_quotesheets::update_sheet($context); 
				logs::submit_logs(array("table" => "quotes_sheets", "action_type" => 2,"foreign_id" => $id, "description" => "Modified"));	

				//logs::submit_logs(array("table" => "quotes", "action_type" => 10,"foreign_id" => $id, "description" => "Update Quote Sheet"));
						 
				$results = $database->CompleteTrans();
				
 
		}													

		 if(!$results)
		{
			confirmation::error_temp("Updated Quotation".$reasons,"Quotation","quote");
			return false;
		}
		else
		{
			confirmation::Success_temp("Updated Quotation","Quotation","quote");	
			return true;			
		}						
	}
	
	
	
	
	public function update_status(){
	
	 global $database;
	$quote_id = mysql_real_escape_string($_POST['quote_id']);	
	$qid = mysql_real_escape_string($_POST['qid']);	
	$reasons = "<br /><br />";					
	$reasons .= trim($this->reasons);
	$qualification_notes = $this->qualification_notes;
	$sitesurvey_notes = $this->sitesurvey_notes;
	$visualmockup_notes = $this->visualmockup_notes;
	$flag = $this->flag;
	$job_tag = $this->job_tag;
	
	$status = explode(':',$_POST['status']);
	$department_id= $status[1];
	$status_id= $status[2];
	$submitter = $_SESSION['user']['id'];
	$current_date_time = date('Y-m-d G:i:s');
	
	$jobtypes = $this->jobtypes;
	$sitesurvey = false;
	$visual = false;
	
	 
	switch($status[0]){
		
		case 1: //Action ID
			$notes = strlen(trim($qualification_notes));
			 
			if(!$notes){
				$reasons .= 'Qualification Notes is required. <br />Click <a href="?page=quote_notes&id='.$quote_id.'">here</a> to fill out appropriate Notes.';
			}
		break;
		case 16:
			$notes = strlen(trim($sitesurvey_notes));
			if(!$notes){
				$reasons .= 'Site Survey Notes is required. <br />Click <a href="?page=quote_notes&id='.$quote_id.'">here</a> to fill out appropriate Notes.';
			}
		break;
		case 19:
			$notes = strlen(trim($visualmockup_notes));
			if(!$notes){
				$reasons .= 'Visual Art Mockup Notes is required. <br />Click <a href="?page=quote_notes&id='.$quote_id.'">here</a> to fill out appropriate Notes.';
			}
		break;
		 
		
	}
	
	 
	$check_reasons = strip_tags($reasons);
								
		$results = false;		
				
		 if($check_reasons == "")
		 {
			
			$database->StartTrans();
  			 
			if($status[2]==31  ) { //status=31, Deposit of Invoice Completed, triggers this quote to become a job
				//print_r($_POST);
			
			
						$action=2;
						//add to jobs table, this request is now a job!!!
					  	$sql ="
								INSERT INTO jobs   (SELECT * FROM quotes WHERE id = '$qid')
								  
						";
						 $database->query($sql);
						  logs::submit_logs(array("table" => "jobs", "action_type" => 1,"foreign_id" => $qid, "description" => "Created"));
					
						 //update request to tag it as job
					 	$update = "
									UPDATE quotes SET job_tag='1' WHERE id='$qid'
									";
						$database->query($update);			
						 logs::submit_logs(array("table" => "quotes", "action_type" => 2,"foreign_id" => $qid, "description" => "Modified"));
					 	
						
						 $sql="
	  
								UPDATE departments_quotes set action_id =2 where id='$quote_id'  
							";
			 
		
			 			$database->query($sql);
		
						logs::submit_logs(array("table" => "departments_quotes", "action_type" => 2,"foreign_id" => $id, "description" => "Modified"));
			 
						
						 $sql = "
							INSERT INTO departments_jobs
							SET 
							department_id='$department_id',
							job_id='$qid',
							`user_id` = '$submitter', 
							status='$status_id',
							action_id='2',
							`date_submitted` = '$current_date_time'
						";
			
			$database->query($sql); 
			 logs::submit_logs(array("table" => "departments_jobs", "action_type" => 1,"foreign_id" => $qid, "description" => "Created"));
					
			
			}else{
				 if($status[0] == 6){
				  	$quote_id2 = $quote_id + 1;
					$sql="
	  
						UPDATE departments_quotes set action_id =1 where id='$quote_id'  or id = '$quote_id2'
					";
  
				  
			  	}else{
				  	$sql="
	  
						UPDATE departments_quotes set action_id =1 where id='$quote_id'  
					";
			 	}
		
			 	$database->query($sql);
		
			 	logs::submit_logs(array("table" => "departments_quotes", "action_type" => 2,"foreign_id" => $id, "description" => "Modified"));
			
				foreach($jobtypes as $k ){
					$newk = explode('=>',$k);
					//echo $newk[0];
					if($newk[0] == 'signtype_2'){
						$sitesurvey = true;
						$department_id = 2; //Installation department (table department)
						$status_id = 9; //Pending Site Survey (table clients_requests_status
					}
					if($newk[0] == 'signtype_1'){
						$visual = true;
						$department_id = 3; //Design department (table department)
						$status_id = 10; //Pending Visual Art Mockup (table clients_requests_status
					}
				}
				
				
				
				
				$sql = "
					INSERT INTO departments_quotes
					SET 
					department_id='$department_id',
					quote_id='$qid',
					`user_id` = '$submitter', 
					status='$status_id',
					`date_submitted` = '$current_date_time'
				";
			
				$database->query($sql); 
				$new_id = $database->insert_id();
				
				if($sitesurvey && $flag==0){
				
					//update the flag
					$sql = "
						UPDATE quotes SET flag ='1' 
						WHERE id = '$qid'
					";
					$database->query($sql); 	
				
					logs::submit_logs(array("table" => "departments_quotes", "action_type" => 1,"foreign_id" => $qid, "description" => "Created"));
					
					logs::submit_logs(array("table" => "departments_quotes", "action_type" => 2,"foreign_id" => $qid, "description" => "Modified"));
					
					logs::submit_logs(array("table" => "quotes", "action_type" => 2,"foreign_id" => $qid, "description" => "Modified"));
				
				
				}
			
			}
			 
//			logs::submit_logs(array("table" => "quotes", "action_type" => 10,"foreign_id" => $qid, "description" => "Update Quote Sheet"));
			
			$results = $database->CompleteTrans();
		
		 }
	 
	
	 if(!$results)
		{
			confirmation::error_temp("Performing this task".$reasons,"Request","quote");
			return false;
		}
		else
		{
			confirmation::Success_temp("Edit a Client Request","Request","quote");	
			return true;			
		}
	
	
	}
	
	
	
}