<?
class form_labour
{
	public $id;
	public $db_name;
	
	public $config;
	public $validation;
	public $reasons;	
	
	public $suffix;
	public $data;
		
	public function __construct($context = array())
	{
		$this->id = $context['id'];
		$this->db_name = $context['db_name'];
	}

	public function set()
	{
		global $database;
	
	 	$id = $this->id;
		$db_name = $this->db_name;
		//get data
					
		//$sql = "SELECT labours from quotes_labour where quote_id = '$id'";
		//$datas = $database->getRow($sql);
		$datas = common_quotes::get_quote_labour($id);
		 
		if(!empty($datas['labours'])){
			$this->data =  json_encode(unserialize($datas['labours']));
		}  
		//get the labours if available
		 
		
		if($_POST['Submit'] == "Save")
		{			 
			foreach($_POST AS $name => $value)
			{
				$splitter = explode("_",$name);
				
				$post_name = $splitter[0];
				$suffix = $splitter[1];
				
				if($post_name == "labour")
				{
					$this->labour = mysql_real_escape_string($_POST['labour_'.$suffix]);
					$this->supplier = mysql_real_escape_string($_POST['supplier_'.$suffix]);
					$this->quantity = mysql_real_escape_string($_POST['quantity_'.$suffix]);
					$this->price = mysql_real_escape_string($_POST['price_'.$suffix]);
					$this->total = mysql_real_escape_string($_POST['total_'.$suffix]);
					 
				}
			}
		}
		
		$this->config['labour'] = array("id"=> $id,"value"=> $this->labour, "input_name" => "labour", "name" => "labour","rule" => "required");
		$this->config['supplier'] = array("id"=> $id,"value"=> $this->supplier, "input_name" => "supplier", "name" => "Supplier","rule" => "required");
		$this->config['quantity'] = array("id"=> $id,"value"=> $this->quantity, "input_name" => "quantity", "name" => "Quantity","rule" => "required|numeric");
		$this->config['price'] = array("id"=> $id,"value"=> $this->price, "input_name" => "price", "name" => "Price","rule" => "required|numeric");
		$this->config['total'] = array("id"=> $id,"value"=> $this->total, "input_name" => "total", "name" => "Total","rule" => "required|numeric");
		 
		//self::run_validation();
	}	

	public function run_validation()
	{
		$id = $this->id;
		
		$static_function = (($_POST['Submit'] == "")) ? "initial" : "validate";
		
		$this->validation['labour'] = validation::$static_function($this->config['labour']);	
		$this->validation['supplier'] = validation::$static_function($this->config['supplier']);	
		$this->validation['quantity'] = validation::$static_function($this->config['quantity']);	
		$this->validation['price'] = validation::$static_function($this->config['price']);	
		$this->validation['total'] = validation::$static_function($this->config['total']);	
		 
		$this->reasons = validation::formalise($this->validation);
	}
		
	public function form()
	{		
		global $database;
		$data = $this->data;
		$id = $this->id;
		
		$results = common_labours::get_sublabours(0);
		$config = $this->config;
		$validation = $this->validation;
		
		/** Kai 07/11/2012*/
		/** disable costing changes fater quote approved, only admin level user to update*/
		$display_info		= false;
		$group_id			= $_SESSION['user']['group_id'];
		$admin_groups		= array(31,42);
		if(in_array($group_id, $admin_groups)){
			$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;
// 				}
				
				/** Kai 08/02/2013*/
				$get_current_job_tasks = "
							SELECT 	project_tasks.*,project_workflow.table,project_workflow.foreign_id
							FROM	project_tasks, project_workflow
							WHERE	project_tasks.project_workflow_id = project_workflow.id
							AND		project_tasks.status=0
							AND		project_workflow.foreign_id=".$job_details[0]['id']."
							AND 	project_workflow.table = 'jobs'
							";
					
				$current_job_tasks = $database->getRow($get_current_job_tasks);
				
				if(in_array($current_job_tasks['workflow_task_id'],array(36,594,699,751,762,777))){
					$display_info = true;
					//bug::bug_array('current workflow_task_id',$current_job_tasks['workflow_task_id']);
				}else{
					$get_finished_job_tasks = "
							SELECT 	project_tasks.*,project_workflow.table,project_workflow.foreign_id
							FROM	project_tasks, project_workflow
							WHERE	project_tasks.project_workflow_id = project_workflow.id
							AND		project_tasks.status=1
							AND		project_workflow.foreign_id=".$job_details[0]['id']."
							AND 	project_workflow.table = 'jobs'
							";
					
					$finished_job_tasks = $database->getAll($get_finished_job_tasks);
					
					foreach($finished_job_tasks as $tasks){
						if(in_array($tasks['workflow_task_id'],array(36,594,699,751,762,777))){
							$display_info = true;
							//bug::bug_array('finished workflow_task_id',$current_job_tasks['workflow_task_id']);
						}
					}
				}
				//bug::bug_array('Finished job tasks',$current_job_tasks);
				/** Changes end, Kai 08/02/2013*/
			}
		}
		?>
		
	     <div class="form_wrapper"> 
	             <form>       
            <table class="tab_form" cellspacing="0"> 
				<thead>
					<th>Labour</th>
					<th>Hrs</th>
					<th>Quantity</th>
					<th>Rate</th>
					<th>Total</th>
				</thead>
				<tbody>
				<? 
				$counter = 0;
				$tag=0;
				
				foreach($results as $rs)
				{        
						$dollar_sign='$';          															 //1st
						$labour = $rs['labour_name'];
						$units = $rs['units'];
						$rate = $rs['rate'];
						$id = $rs['id'];
						$pid = $rs['parent_id'];
						$fieldtype = $rs['fieldtype'];
						$validation['input_name'] = str_replace('/','-',str_replace(' ','_',$labour)).'_labour' ;
						//$config['value'] ='';
						$options['class'] = "labourclass";
						$options['attr'] =   '';
						$options['style'] = 'width:70px;';
						if($rate == 0)$rate='';
						
						if($labour == 'Delivery' || $labour=='Installation')
						{
							$dollar_sign='';
						}
						
						if($labour == "Delivery")
						{
							 ?>
							 <tr>
								<td colspan="4" class="subtotals" ><div class="currency">Sub Total Production / Installation Labour</div></td><td class="subtotals">
								<?
								 	$validation['input_name']='inhouse_subtotal_labour';
									$options['attr'] =   array("readonly"=>"readonly");
									$options['style'] = "border:0;text-align:right;width:70px;";
									 $config['value']='';
									echo forms::input_text($config ,$validation,$options);?>
								<div class="currency" id="inhouse_subtotals"></div></td>
							 </tr>
							 
							 <?
						}
						 ?>
					<tr>
						<td class="labour_header">
													 
                             <? if($labour == 'Other')
							 	{
									$validation['input_name']='other_labour';
									$options['class'] = ""; 
									$options['style'] = "border:1;width:270px;";
									 $config['value']='';
									echo forms::input_text($config ,$validation,$options);
									
								}
								
								?> 
						</td>
						<td>
							<?
								if($fieldtype == "input_hrs")
								{
									$options['style'] = 'width:70px;;background:#fff;';
									 echo forms::input_text($config,$validation,$options);
								} 
								?>
						</td>
						<td>
							<?
								if($fieldtype == "input_sqm_rate")
								{
									$options['style'] = 'width:70px;;background:#fff;';
									 echo forms::input_text($config,$validation,$options);
								}elseif($fieldtype == "input_lm_rate")
								{
									$options['style'] = 'width:70px;;background:#fff;';
									 echo forms::input_text($config,$validation,$options);
								} 
								?>
						</td>
						<td> 
							<?
								if($labour ==  "Alternative Sub Contractor supplied price" || $labour == "Other")
								{
									$validation['input_name']='rate_'.str_replace('/','-',str_replace(' ','_',$labour)).'_labour' ;
									 $config['value']="0";
									 $options['class']="labourclass4";
									 $options['style'] = 'width:70px;;background:#fff;';
									echo forms::input_text($config,$validation,$options);
								
								}
								elseif($fieldtype == "input_rate" || $fieldtype == "input_sqm_rate"  || $fieldtype == "input_lm_rate")
								{
									$validation['input_name']='rate_'.str_replace('/','-',str_replace(' ','_',$labour)).'_labour' ;
									//$config['value']="0";
									//$options['class']="labourclass4";
									$options['style'] = 'width:70px;;background:#fff;';
									echo forms::input_text($config,$validation,$options);
								 
								}
								elseif($fieldtype=="input_hrs")
								{
								?>	
									<?  $validation['input_name']='rate_'.str_replace('/','-',str_replace(' ','_',$labour)).'_labour' ;
										$options['attr'] =   array("readonly"=>"readonly") ;
										$options['style'] = "border:0;text-align:right;width:70px;";
										$config['value']=$rate;
										echo forms::input_text($config,$validation,$options);
									?>
									<!--<div id="rate_"></div>-->
							
							<?	}
								else
								{
								}
								?>
						</td>
						
						<td>
						<?
									if($fieldtype!="")
									{
										$options['class']="l_totals";
										
										if($labour ==  "Alternative Sub Contractor supplied price" || $labour == "Other")
										{
											$options['class']="l_totals1";
										}
									
										$validation['input_name']='total_'.str_replace('/','-',str_replace(' ','_',$labour)).'_labour' ;
										$options['attr'] =   array("readonly"=>"readonly") ;
										$options['style'] = "border:0;text-align:right;width:70px; ";
										$config['value']='';
										echo forms::input_text($config ,$validation,$options);
									
									}?>
							<!--<div class="currency" id="total_">-->
							
							</div>
							<? $config['value']='';
							$validation['input_name']='totals_'.str_replace('/','-',str_replace(' ','_',$labour)).'_labour' ;
							 if($labour ==  "Alternative Sub Contractor supplied price")
							 {
							
							 	$options['class']="l_totals4";
							 }
							 else
							 {
								$options['class']="l_totals";
							 }
							 
							 $options['style'] = 'width:70px;background:#fff;';
							//echo forms::input_hidden($config ,$validation,$options);?>
						</td>
					</tr>
					<? 
					//This is the production stuff
					if($counter == 3)
					{
					 
						//$sql1 = "SELECT * FROM production_departments where   status=1";
						//$subresults = $database->getAll($sql1);
						$subresults = common_production_department::get_active_departments();	
							foreach($subresults as $subs)
							{								//2nd foreach
								  $slabour = $subs['department_name'];
								  $sid = $subs['id'];
							 
									
											//production department
									?>
									<tr>
									<td  class="labour_header">
										<? 
											//$sql2 = "SELECT * FROM production_departments_sub where production_departments_id='$sid' AND  status=1";
											//$subresults2 = $database->getAll($sql2);
											$subresults2 = common_production_department::get_active_subdepartments($sid);
											//bug::bug_array('',$subresults2);
										?>
									     <span style="font-weight:bold;font-size:13px;"></span>
									</td>
									
									<td class="labour_header">&nbsp;</td>
                                    <td class="labour_header">&nbsp;</td>
                                    <td class="labour_header">&nbsp;</td>	
                                    <td class="labour_header">&nbsp;</td>
									
									</tr>
                        
                        <? 		if(count($subresults2) > 0)
								{ 
									foreach($subresults2 as $subs2)
									{								//3rd foreach
										$slabour2 = $subs2['labour_name'];
										$sunits2 = $subs2['units'];
										$srate2 = $subs2['rate'];
										$sid2 = $subs2['id'];
										$sfieldtype = $subs2['fieldtype']; ?>
										<tr>
							
                                        <td class="sub_task"></td>
                                        <td>
                                                <? 
                                                $validation['input_name'] = str_replace('/','-',str_replace(' ','_',$slabour2)).'_labour_'.$sid ;
                                                if($sfieldtype=="input_hrs")
                                                {
                                                    $options['class'] = "labourclass";
                                                    $options['attr'] =   '';
                                                     
                                                    $options['style'] = 'width:70px;background:#fff;';
                                                     
                                                    echo forms::input_text($config,$validation,$options);
                                                    
                                                }?>
                                        </td>
                                        <td>
							
										<?  
                                        if($sfieldtype == "input_sqm_rate")
										{
                                        	$options['style'] = 'width:70px;';
                                            echo forms::input_text($config,$validation,$options);
                                        } 
                                        ?>
								 		</td>
								 		<td>$
										<?  
                                        if(  $sfieldtype == "input_sqm_rate" )
										{
                                             $options['class'] = "labourclass";
                                             $options['attr'] =   '';
                                             $options['style'] = 'width:70px;';
                                             echo forms::input_text($config,$validation,$options);
                                        }
										elseif($sfieldtype == "input_rate" && $slabour=="Cartage")
										{
                                            $options['class']="labourclass2";
                                            $options['attr'] =   '';
                                            $options['style'] = 'width:70px;';
                                            echo forms::input_text($config,$validation,$options);
                                        }
										elseif($sfieldtype == "input_rate")
										{
                                            $options['class']="labourclass3";
                                            $options['attr'] =   '';
                                            $options['style'] = 'width:70px;';
                                            echo forms::input_text($config,$validation,$options);
                                        }
										else
										{
                                  			$validation['input_name']='rate_'.str_replace('/','-',str_replace(' ','_',$slabour2)).'_labour_'.$sid ;
                                            $options['attr'] =   array("readonly"=>"readonly") ;
                                            $options['style'] = "border:0;text-align:right;width:70px;";
                                            $config['value']=$srate2;
                                            echo forms::input_text($config,$validation,$options);
										}
										?>
                                        </td>
                                        <td>
										<?
                                        if($sfieldtype == "input_rate" && $slabour2 == "Cartage")
										{
                                                $options['class']="l_totals2";
                                        }
										elseif($sfieldtype == "input_rate")
										{
                                                $options['class']="l_totals3";
                                        }
										else
										{
                                                $options['class']="l_totals";
                                        }
									 	
										$validation['input_name']='total_'.str_replace('/','-',str_replace(' ','_',$slabour2)).'_labour_'.$sid ;
										$options['attr'] =   array("readonly"=>"readonly") ;
										$options['style'] = "border:0;text-align:right;width:70px;";
										$config['value']='';
										echo forms::input_text($config ,$validation,$options);?>
                                        <div class="currency" id="stotal_"></div>
                                        <? $config['value']='';
                                        
                                            $validation['input_name']='totals_'.str_replace('/','-',str_replace(' ','_',$slabour2)).'_labour' ;
                                    
                                            if($sfieldtype == "input_rate" && $slabour2 == "Cartage")
											{
                                                $options['class']="l_totals2";
                                            }
											elseif($sfieldtype == "input_rate")
											{
                                                $options['class']="l_totals3";
                                            }
											else
											{
                                                $options['class']="l_totals";
                                            }
                                            $options['attr'] =   '';
                                            $options['style'] = 'width:70px;';
                                            //echo forms::input_hidden($config ,$validation,$options);?>
                                    </td>
                                    
                                    </tr>
                                    
                                    <?
								}											//end 3rd foreach
							}												// end if $subresults2
						?>

						<? }												//end 2nd foreach 
						
						 }  							// end if $counter
						  $counter++;
				
								 
								$subresults3 = common_labours::get_sublabours($id);
								foreach($subresults3 as $sub3){
									
										$l_name=$sub3['labour_name'];
										$d_rate=$sub3['rate'];
										$f_type=$sub3['fieldtype'];
										$i_id=$sub3['id'];

										 ?>
                                         <tr>
                                          
                                          
                                         <td  class="sub_task">
                                         	                                         </td>
                                         <td >
										<? 
                                        $validation['input_name'] = str_replace('/','-',str_replace(' ','_',$l_name)).'_labour_'.$i_id ;
                                        if($f_type=="input_hrs")
										{
                                            $options['class'] = "labourclass";
                                            $options['attr'] =   '';
                                             
                                            $options['style'] = 'width:70px;';
                                             
                                            echo forms::input_text($config,$validation,$options);
                                            
                                        }?>
										</td>
                                   		<td>
							
										<?  
                                        if($f_type == "input_sqm_rate")
										{
                                        	$options['style'] = 'width:70px;';
                                             echo forms::input_text($config,$validation,$options);
                                        } 
                                        ?>
									 	</td>
										<td>$
										<?  
                                        if(  $f_type == "input_sqm_rate" )
										{
                                            $options['class'] = "labourclass";
                                            $options['attr'] =   '';
                                            $options['style'] = 'width:70px;';
                                            echo forms::input_text($config,$validation,$options);
                                        }
										elseif($f_type == "input_rate" && $l_name=="Cartage")
										{
                                            $options['class']="labourclass2";
                                            $options['attr'] =   '';
                                            $options['style'] = 'width:70px;';
                                            echo forms::input_text($config,$validation,$options);
                                        }
										elseif($f_type == "input_rate")
										{
                                            $options['class']="labourclass3";
                                            $options['attr'] =   '';
                                            $options['style'] = 'width:70px;';
                                            echo forms::input_text($config,$validation,$options);
                                        }
										else
										{
                                        ?>
										<?  $validation['input_name']='rate_'.str_replace('/','-',str_replace(' ','_',$l_name)).'_labour_'.$i_id ;
                                            $options['attr'] =   array("readonly"=>"readonly") ;
                                            $options['style'] = "border:0;text-align:right;width:70px;";
                                            $config['value']=$d_rate;
                                            echo forms::input_text($config,$validation,$options);
                                        ?>
									<?	}
									?>
										</td>
										<td>
										<?
                                        if($f_type == "input_rate" && $l_name == "Cartage")
										{
                                            $options['class']="l_totals2";
                                        }
										elseif($f_type == "input_rate")
										{
                                            $options['class']="l_totals3";
                                        }
										else
										{
                                            $options['class']="l_totals";
                                        }
                                         	$validation['input_name']='total_'.str_replace('/','-',str_replace(' ','_',$l_name)).'_labour_'.$i_id ;
                                            $options['attr'] =   array("readonly"=>"readonly") ;
                                            $options['style'] = "border:0;text-align:right;width:70px;";
                                            $config['value']='';
                                            echo forms::input_text($config ,$validation,$options);?>
                                        <div class="currency" id="stotal_"></div>
                                        <? $config['value']='';
                                        
                                            $validation['input_name']='totals_'.str_replace('/','-',str_replace(' ','_',$l_name)).'_labour' ;
                                    
                                            if($f_type == "input_rate" && $l_name == "Cartage")
											{
                                                $options['class']="l_totals2";
                                            }
											elseif($f_type == "input_rate")
											{
                                                $options['class']="l_totals3";
                                            }
											else
											{
                                                $options['class']="l_totals";
                                            }
                                            $options['attr'] =   '';
                                            $options['style'] = 'width:70px;';
                                            //echo forms::input_hidden($config ,$validation,$options);?>
										 </td>
                                         </tr>
                                         
                                         <? if($l_name == "Cartage")
										 {
										 ?>
                                         <tr >
                                            <td colspan="4" class="subtotals" ><div class="currency">Sub Total Delivery</div></td><td  class="subtotals" >
                                            <?
                                                $validation['input_name']='delivery_subtotal_labour';
                                                $options['attr'] =   array("readonly"=>"readonly") ;
                                                $options['style'] = "border:0;text-align:right;width:70px;";
                                                $config['value']='';
                                                echo forms::input_text($config ,$validation,$options);?>
                                            <div class="currency" id="delivery_subtotals"></div>
                                            <? 	$config['value']='';
                                                $validation['input_name']='delivery_total_labour';
                                                echo forms::input_hidden($config ,$validation);?>
                                            </td>
                                         </tr>
										 
										 <?
										 }
										}	
										
										 
										//if($l_name == "Metro labour cost")
										if($l_name == "Dial before you dig")
										{
										 ?>
										 <tr  class="subototal" >
											<td colspan="4"  class="subtotals"  ><div class="currency">Sub Total External Installation</div></td><td  class="subtotals" >
											<?
											 $validation['input_name']='install_subtotal_labour';
												$options['attr'] =   array("readonly"=>"readonly") ;
												$options['style'] = "border:0;text-align:right;width:70px;";
												 $config['value']='';
												echo forms::input_text($config ,$validation,$options);?>
											<div class="currency" id="install_subtotals"></div>
											<? 	$config['value']='';
												$validation['input_name']='installation_total_labour';
												echo forms::input_hidden($config ,$validation);?>
											</td>
										 </tr>
										 
										 <?
										}
										$l_name=null;
				
				
				}										//end 1st
					?>
						<tr>
							 
							<td colspan="4" class="subtotals"><div class="currency">TOTAL COST</div></td>
							<td  class="subtotals">
							<?
								$validation['input_name']='grand_total_labour';
								$options['attr'] =   array("readonly"=>"readonly") ;
								$options['style'] = "border:0;text-align:right;width:70px;";
								$config['value']='';
								echo forms::input_text($config ,$validation,$options);
							?>
							<div id="grand_totals"></div></td>
						</tr>
						<tr>
						<td></td>
						<td> <? $config['value']=$_GET['id'];
								$validation['input_name']='quote_id';
							 	echo forms::input_hidden($config ,$validation);?>
                        </td>
						<td><!--<input class="button" id="Submit" type="submit" name="Submit" value="Save" /> --> &nbsp;
												</td>
						<td>
						 </td>
						<td>
						<? 	
								$config['value']='';
								$validation['input_name']='grandtotal_labour';
								//echo forms::input_hidden($config ,$validation);
						?>
						<div style="display:none;" id="alternative_total_labour"></div></td>
						</tr>
                        <tr>
                        <td class="submit_form">&nbsp;</td>           
                        <td class="submit_form">
                        
                        </td>
                        <td class="submit_form">&nbsp;</td>
                        <td class="submit_form">&nbsp;</td>
                        <td class="submit_form">&nbsp;</td>
                        </tr>
			</table>
							<!--  <div class="clear"></div>
				<span style="color:red">Note: This quote is accepted by the client, the ability to modify the costing has been disabled.</span>
				-->
			        </form>
        <script type="text/javascript" src="js/jquery.populate.js"></script>
				<script>
				 $(document).ready(function() {
				 
				 $('input[name!="template_name"]').keydown(function(event) {
						// Allow: backspace, delete, tab and escape
						if ( event.keyCode == 46 || event.keyCode == 8 || event.keyCode == 9 || event.keyCode == 190 || event.keyCode == 27 || 
							 // Allow: Ctrl+A
							(event.keyCode == 65 && event.ctrlKey === true) || 
							 // Allow: home, end, left, right
							(event.keyCode >= 35 && event.keyCode <= 39)) {
								 // let it happen, don't do anything
								 
								  
								 return true;
						}
						else {
							// Ensure that it is a number and stop the keypress
							if ((event.keyCode < 48 || event.keyCode > 57) && (event.keyCode < 96 || event.keyCode > 105 )) {
								event.preventDefault(); 
								 
								return false;
							}   
						}
					});
					
				 
				 <? if($data!=''){ ?>
				 $('#main_form').populate(  );
        		<? }?>


				 $("#SubmitLabour").click(function(){
				  
							    
				 var gt= $("#grand_total_labour").val();
				 if(gt==0 || gt.length==0 || gt == '$0.00'){

					dialog_fail("Cannot submit a blank labour quotation.");
					
					
					$(':text').each(function(){
            // put other rules here
					if(isNaN($(this).val()))
					{
					   $(this).css('border-color', 'red');
					    
					}
					});
					return false;
				}
				
				 
				  		/*dataString = "&page=update_labour&current_status="+$("form").serialize();
						   
						// alert(dataString);
						$.ajax({
						type: "POST",
						url: "ajax_process.php",
						data: dataString,
						dataType:  'json',
						success:  function(json) {
						 
						//window.location.href = "?page=request_details&id=" + request_id;
						//alert('success');
							if(json.status == true)
							{						
								dialog_success('Labour Costing Saved!');
							//window.location.href = "?page=setup_suggestions_scopes";
							}
							else
							{
								dialog_fail(json.reasons);
							}
						}
						});*/
						
					});	


					var in_subtotal =0;
				// $("input").keyup(function(){
				// var  class1 =  $(this).attr('class');
				// alert(class1);
				// });
				$("input").each(function() {
				 	$(this).keyup(function(){
				  		var  class1 =  $(this).attr('class');  
				 		var subtotal_id =  $(this).attr('id');
				   		 
				  		if(class1 != ''){
						if(subtotal_id.match(/^rate(=?_)/)){
				   
							 var rate =$("#"+subtotal_id).val();
							 var hrval = subtotal_id.substring(5);
							 subtotal_id = subtotal_id.substring(5);
							 var hours = $("#"+hrval).val();
					  
				  		}else{
				  
							var hours = $(this).val();
									 
							var rate = $("#rate_"+subtotal_id).text() ||   parseFloat($("#rate_"+subtotal_id).val() )  ;
							 
				 		}
				  		}else{
						//subtotal_id = subtotal_id.substring(5);
						}
				 	 
				 
				  		if(subtotal_id == "Permits-Survey_labour" ||  subtotal_id =="Alternative_Sub_Contractor_supplied_price_labour" || subtotal_id== "Other_labour"){
							var rate = $("#rate_"+subtotal_id).val();
						 
						  
							var subtotal =   parseFloat(rate);
				 		}else if( class1 == "labourclass2" || class1 == "labourclass3" || class1 == "labourclass4"){
				 
							var rate = $("#"+subtotal_id).val();
						  
						 
							var subtotal =   parseFloat(rate);
						
						}else{
				  
						   var subtotal = parseFloat(hours) * parseFloat(rate);
						   
				  		}
										  
				  $('#total_'+subtotal_id).val(num2money(subtotal));
				   in_subtotal +=   subtotal;
				    
					if(class1 == "labourclass2"){
						calculateSum('delivery_subtotal_labour', 'labourclass2');
					}else if(class1 == "labourclass3"){
						calculateSum('install_subtotal_labour', 'labourclass3');
					}else if(class1 == "labourclass4"){
						calculateSum('alternative_total_labour', 'labourclass4');
					}else if(class1==''){
					
					}else{
						calculateSum('inhouse_subtotal_labour', 'l_totals');
					}
				  
				 });
				 });
				 var gt =0;
				 function calculateSum(ele, classname) 
					{
						var sum = 0;
						//iterate through each textboxes and add the values
						$("."+classname).each(function() {

							//add only if the value is number
							  tots = this.value.replace("$","").replace(",","");
							if(!isNaN(tots) && this.value.length!=0) {
								sum += parseFloat(tots);
							}

						});
						//$("#"+ele).html(num2money(sum));
						$("#"+ele).val(num2money(sum));
						
						install_gt= parseFloat($("#install_subtotal_labour").val().replace("$","").replace(",",""));
						delivery_gt= parseFloat($("#delivery_subtotal_labour").val().replace("$","").replace(",","")) ;
						inhouse_gt= parseFloat($("#inhouse_subtotal_labour").val().replace("$","").replace(",","")) ;
						alternative_gt= parseFloat($("#alternative_total_labour").val().replace("$","").replace(",","")) ;
						 $("#installation_total_labour").val(install_gt);
						 $("#delivery_total_labour").val(delivery_gt);
						 
						 
						if(!isNaN(inhouse_gt) && isNaN(install_gt) && isNaN(delivery_gt) && isNaN(alternative_gt)) {
							gt  = inhouse_gt;
							}
						if(!isNaN(install_gt)  && isNaN(inhouse_gt) && isNaN(delivery_gt) && isNaN(alternative_gt)) {
							gt  = install_gt;
							}
						if(!isNaN(delivery_gt)  && isNaN(inhouse_gt) && isNaN(install_gt) && isNaN(alternative_gt)) {
							gt  = delivery_gt;
							}
						if(!isNaN(delivery_gt)  && !isNaN(inhouse_gt) && isNaN(install_gt) && isNaN(alternative_gt)) {
							gt  = delivery_gt + inhouse_gt;
							}
						if(!isNaN(delivery_gt)  && isNaN(inhouse_gt) && !isNaN(install_gt) && isNaN(alternative_gt)) {
							gt  = delivery_gt + install_gt;
							}
						if(isNaN(delivery_gt)  && !isNaN(inhouse_gt) && !isNaN(install_gt) && isNaN(alternative_gt)) {
							gt  = inhouse_gt + install_gt;
							}	
						if(!isNaN(delivery_gt)  && !isNaN(inhouse_gt) && !isNaN(install_gt) && isNaN(alternative_gt)) {
							gt  = inhouse_gt + install_gt + delivery_gt;
							}
						if(!isNaN(delivery_gt)  && !isNaN(inhouse_gt) && !isNaN(install_gt) && !isNaN(alternative_gt)) {
							gt  = inhouse_gt + install_gt + delivery_gt + alternative_gt;
							}
						if(!isNaN(inhouse_gt) && isNaN(install_gt) && isNaN(delivery_gt) && !isNaN(alternative_gt)) {
							gt  = inhouse_gt + alternative_gt;
							}
						if(!isNaN(install_gt)  && isNaN(inhouse_gt) && isNaN(delivery_gt) && !isNaN(alternative_gt)) {
							gt  = install_gt + alternative_gt;
							}
						if(!isNaN(delivery_gt)  && isNaN(inhouse_gt) && isNaN(install_gt) && !isNaN(alternative_gt)) {
							gt  = delivery_gt + alternative_gt;
							}
						if(!isNaN(delivery_gt)  && !isNaN(inhouse_gt) && isNaN(install_gt) && !isNaN(alternative_gt)) {
							gt  = delivery_gt + inhouse_gt + alternative_gt;
							}
						if(!isNaN(delivery_gt)  && isNaN(inhouse_gt) && !isNaN(install_gt) && !isNaN(alternative_gt)) {
							gt  = delivery_gt + install_gt + alternative_gt;
							}
						if(isNaN(delivery_gt)  && !isNaN(inhouse_gt) && !isNaN(install_gt) && !isNaN(alternative_gt)) {
							gt  = inhouse_gt + install_gt + alternative_gt;
							}	
						if(isNaN(delivery_gt)  &&  isNaN(inhouse_gt) &&  isNaN(install_gt) && !isNaN(alternative_gt)) {
							gt  =   alternative_gt;
							}
						 
							
						//compute grand metro total
						 //$("#grand_total").html(num2money(gt));
						 $("#grand_total_labour").val(num2money(gt));
						 //$("#grandtotal").val((gt));
					}  
				 
				
				 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>     
        <?
	}
	
	public function edit_submit()
	{
		global $database;

		$db_name = $this->db_name;
		
		$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');

			 		
		}				 					
	}
	
	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');
		 			  			
			$id = intval(mysql_real_escape_string($_POST['quote_id']));
			$dept_id = intval(mysql_real_escape_string($_POST['department']));
			$status_id =  intval(mysql_real_escape_string($_POST['status']));
			$install_total =  mysql_real_escape_string(str_replace(',','',str_replace('$','',$_POST['installation_total_labour'])));
			$delivery_total =  mysql_real_escape_string(str_replace(',','',str_replace('$','',$_POST['delivery_total_labour'])));
			
			$artwork_total =  str_replace(',','',str_replace('$','',$_POST['total_Artwork_labour']));
			$permit_total =  str_replace(',','',str_replace('$','',$_POST['total_Permits-Survey_labour']));
			$subcontractor_total =str_replace(',','',str_replace('$','',$_POST['total_Alternative_Sub_Contractor_supplied_price_labour']));
			/*Kai 2013-03-06 rather than substract to get labour costing, grab straight away from inpunt inhouse subtotal labour*/
			//$labour_total =  str_replace(',','',str_replace('$','',$_POST['grand_total_labour'])) - $install_total - $delivery_total - $artwork_total - $permit_total - $subcontractor_total;
			$labour_total = str_replace(',','',str_replace('$','',$_POST['inhouse_subtotal_labour']));
			$current_date_time = date('Y-m-d G:i:s');
				 

			foreach($_POST as $key => $val )
				if(preg_match('/labour/',$key))
					$posst[$key] = $val;	
		 //bug::bug_array('',$_POST);
		 
		 	foreach($_POST as $k => $v )
			{
		 		//echo '<p>'.$k.'</p>'; 
				if(preg_match('/^rate_/',$k) || preg_match('/total_/',$k))
				{}
				else
				{
			 		
					//echo '<p>'.$k.'</p>';
					$field = explode('_',$k);
		 
		 			$dept[$id]= array_pop($field);
		 			
		 			/*check if the key is artwork_labour, then assign department_id manually*/
		 			if($k=='Artwork_labour'){
		 				$id=11;
		 				$dept[$id]=11;
		 			}else{
						$id = intval(mysql_real_escape_string($_POST['quote_id']));
					}
		 			
		 			if(is_numeric($dept[$id]) && is_numeric($v))
					{
					 	$arr[] =array($dept[$id] => $v); //create an array for the factory departments (sheetmetal,vinyl,painting, etc)
					}
				}
		 	}		 		 
		  //bug::bug_array('',$arr);
			foreach($arr as $k =>$v)
				foreach($v as $j => $i)
					$jarr[] = $j; 

			$ju=array_unique($jarr);
 
			foreach($ju as $jj => $kk)
			{
				foreach($arr as $k1 =>$v1)
				{
					foreach($v1 as $j1 => $i1)
					{
						$jarr[] = $j1; 
							//echo  $j1.'=='.$kk.'=>'.$i1.'<br>';
						if($j1==$kk)
						{
							$sum[$j1] += $i1;
								 
						}	
					}
				}
			} 		   
		
			foreach($sum as $s => $m)
			{
				if($s > 40)
				{}
				else
				{
				$fac .=  "('$id','".$s."','".$m."','1','$current_date_time','$submitter','$current_date_time'),";			
				}
			//echo $m.'<br/>';
			}
			// echo $fac;
			 //die;
			$fac = substr($fac,0,-1);
											
			$database->StartTrans(); 
			 
			$labourdata = serialize($posst); 
			$sub_total = $artwork_total + $delivery_total + $install_total + $permit_total + $subcontractor_total + $labour_total;
		 			
			
			$context = array(
			
				"labourdata"  			=> $labourdata,
				"delivery_total" 		=> $delivery_total,
				"install_total"			=> $install_total,
				"labour_total"			=> $labour_total,
				"artwork_total"			=> $artwork_total,
				"permit_total"			=> $permit_total,
				"subcontractor_total"	=> $subcontractor_total,
				"dept_id"				=> $dept_id,
				"id"					=> $id
			
			);
			//common_labours::update($context);
			/** Kai 20/11/2012*/
			common_labours::update_quote_labour($context);
			logs::submit_logs(array("table" => "quotes_labour", "action_type" => 2,"foreign_id" => $id, "description" => "Modified"));									
			
			
			$context = array(
			
				"sub_total"  			=> $sub_total,
				"delivery_total" 		=> $delivery_total,
				"install_total"			=> $install_total,
				"labour_total"			=> $labour_total,
				"artwork_total"			=> $artwork_total,
				"permit_total"			=> $permit_total,
				"subcontractor_total"	=> $subcontractor_total,
				"quote_id"					=> $id
			
			);
					
			common_quotesheets::update_all($context );
			logs::submit_logs(array("table" => "quotes_sheets", "action_type" => 2,"foreign_id" => $id, "description" => "Modified"));
						
			$last_id = common_quotes_productiontime::create($id, $fac);			
			logs::submit_logs(array("table" => "quotes_production_time", "action_type" => 2,"foreign_id" => $last_id, "description" => "Modified"));

			logs::submit_logs(array("table" => "quotes", "action_type" => 10,"foreign_id" => $_POST['quote_id'], "description" => "Updated Labour Costing"));
			
			$results = $database->CompleteTrans();
		}													

		if(!$results)
		{
		 	confirmation::error_temp("Add Labour Costing ".$reasons);
		 	return false;
		}
		else
		{
		 	confirmation::success_temp("Added/Updated  Labour costing");	
		 	return true;			
		}						
	}

	public function template_assigned(){
		global $database;
		$quote_id = $_POST['quote_id'];

		$sql = "SELECT COUNT(*) AS count
				FROM template_assigned
				WHERE quote_id = $quote_id";

		$result=$database->getRow($sql);

		if($result['count'] > 0){
			$sql = "UPDATE template_assigned
				SET
				template_ids = '".$_POST['template_ids']."'
				WHERE quote_id = $quote_id";
				$result=$database->query($sql);
		}else{
			$sql = "INSERT INTO template_assigned
				SET
				template_ids = '".$_POST['template_ids']."',
				quote_id = $quote_id";
				$result=$database->query($sql);
		}

	}
}
?>