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_labours($this->quote_id); if(!empty($datas['labours'])){ $this->data = json_encode(unserialize($datas['labours'])); } } public function form() { global $database; $data = $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_labours_settings(); $config = $this->config; $validation = $this->validation; ?>
"large"); if($rate == 0)$rate=''; ?> getAll($sql1); $subresults = common_production_department::get_active_departments(); foreach($subresults as $subs){ //2nd foreach $slabour = $subs['department_name']; $sid = $subs['id']; //production department ?> 0){ foreach($subresults2 as $subs2){ //3rd foreach $slabour2 = $subs2['labour_name']; $sunits2 = $subs2['units']; $srate2 = $subs2['rate']; $sid2 = $subs2['id']; $sfieldtype = $subs2['fieldtype']; ?> 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 Rate
getAll($sql2); $subresults2 = common_production_department::get_active_subdepartments($sid); ?>