id = $context['id']; $this->db_name = $context['db_name']; } public function set() { global $database; $id = $this->id; $db_name = $this->db_name; //get data $this->quote_id = common_quotes::get_quote_id($id); /*$sql = " SELECT actual_labour AS labours FROM quotes_labour WHERE quote_id = ( SELECT quote_id FROM jobs WHERE id = '$id' LIMIT 1 ) "; $datas = $database->getRow($sql);*/ ////$datas = common_labours::get_actual_install($this->quote_id); //if(!empty($datas['labours'])){ //$this->data = json_encode(unserialize($datas['labours'])); //} $datas_quote = common_labours::get_actual_labours( $this->quote_id); $datas = common_labours::get_actual_install( $this->quote_id); //bug::bug_array('',$datas); $array1=array(); $array2=array(); if(!empty($datas['labours'])){ //$this->data = json_encode(unserialize($datas['labours'])); $array1= unserialize($datas['labours']); } if(!empty($datas_quote['labours'])){ //$this->datas_quote = json_encode(unserialize($datas_quote['labours'])); $array2=unserialize($datas_quote['labours']); } if(!empty($array1) || !empty($array2)) { $data_merge = array_merge($array1,$array2); //bug::bug_array('',$data_merge); $this->data = json_encode($data_merge); } } /** * load form and populate data * @since 05/11/2012 * @author Kai * */ public function form() { global $database; $data = $this->data; //bug::bug_array('',$this->data); $id = $this->id; /*$sql = "SELECT * FROM quotes_labour_settings WHERE parent_id=0 AND labour_name <> 'Delivery' AND labour_name <> 'Installation' AND labour_name <> 'Alternative Sub Contractor supplied price' AND status=1"; $results = $database->getAll($sql); */ $results = common_labours::get_installation_labours_settings(); $config = $this->config; $validation = $this->validation; //bug::bug_array('',$results); $ischild = common_jobs::get_parent_job_id($_GET['id']); ?>
"large"); if($rate == 0)$rate=''; ?> getAll($sql3); $subresults3 = common_labours::get_labours_settings($id); //bug::bug_array('',$subresults3); foreach($subresults3 as $sub3): $l_name=$sub3['labour_name']; $d_rate=$sub3['rate']; $f_type=$sub3['fieldtype']; $i_id=$sub3['id']; ?>
Labour Quoted Actual
$ "readonly") ; $validation['input_name'] = str_replace('/','-',str_replace(' ','_',$labour)); if($isChild) $config['value'] = common_jobs::get_job_installation_estimated(51,$this->id); if ($labour == 'Installation'){ $validation['input_name']='total_Installation_labour_labour_12'; //$config['value']= common_quotes::get_quote_install($this->quote_id); }else if ($labour=='Alternative Sub Contractor supplied price'){ $validation['input_name']='total_Alternative_Sub_Contractor_supplied_price_labour'; //$config['value']= common_quotes::get_quote_install($this->quote_id); } echo forms::input_text($config,$validation,$options,true); $config['value']=''; //} ?> $ id); $hourly_rate = common_job_trackings::get_installation_hourly_rate(); $config['value']=$sum_time*$hourly_rate; } //if($isChild) $config['value'] = common_jobs::get_job_installation_actual(51,$this->id); echo forms::input_text($config,$validation,$options,true); $config['value'] = ''; //} ?>
$ id); $validation['input_name'] = str_replace('/','-',str_replace(' ','_',$l_name)).'_labour_'.$i_id ; //if($isChild) $validation['input_name']='install_estimated_'.$i_id; $options['style'] = 'width:70px;'; $options['attr'] = array("readonly"=>"readonly") ; echo forms::input_text($config,$validation,$options,true); ?> $ id); $validation['input_name'] = str_replace('/','-',str_replace(' ','_',$l_name)).'_actual_'.$i_id ; //if($isChild) $validation['input_name']='install_actual_'.$i_id; if($f_type=="input_rate"){ $options['class'] = "labourclass"; $options['attr'] = ''; $options['style'] = 'width:70px;'; echo forms::input_text($config,$validation,$options,true); }?>
Total