avail_status = $context['avail_status'];
$this->avail_edit = $context['avail_edit'];
$this->link_view = $context['link_view'];
$this->link_edit = $context['link_edit'];
$this->group_id = $context['group_id'];
$this->status = $context['status'];
$this->id = $context['id'];
$this->db_name = $context['db_name'];
$this->account_id = $context['account_id'];
$this->order = (empty($context['order'])) ? "ASC" : $context['order'];
$this->method = (empty($context['method'])) ? "email" : $context['method'];
}
public function get_data()
{
global $database;
$db_name = $this->db_name;
$account_id = $this->account_id;
$job_id = $this->id;
$status = $this->status;
$group_id = $this->group_id;
$group = ($group_id != "all") ? "AND group_id = '$group_id'" : "";
$quote_id = common_quotes::get_quote_id($job_id);
/*$get_materials = "
SELECT *
FROM $db_name"."quotes_materials
WHERE quote_id = (
SELECT quote_id
FROM jobs
WHERE id = '$job_id'
LIMIT 1
)
";
$results = $database->getAll($get_materials);
*/
$results = common_materials::get_quote_materials_job($quote_id);
//$results = common_materials::get_all_materialss();
$count = 0;
$return_results = array();
//$users = common_materials::get_materialss();
foreach($results AS $result)
{
//print $result['id']." :: ";
$id = $result['id'];
$materials = $result['materials'];
$item = stripslashes($result['item']);
$supplier = stripslashes($result['supplier']);
$quantity = $result['quantity'];
$actual = $result['actual_used'];
$price = $result['price'];
$inv_exclude = $result['inv_exclude'];
$total = $result['total'];
$total_quantity = $result['total_quantity'];
$job_flag = $result['job_flag'];
$submitter = $result['submitter'];
$date_submitted = $result['date_submitted'];
$submitter = $users[$submitter];
$date_submitted = dates::change_date_time($date_submitted);
$return_results[] = array("id" => $id,"materials" => $materials, "item" => $item, "total" => $total,
"supplier" => $supplier, "actual" => $actual, "quantity" => $quantity , "inv_exclude"=>$inv_exclude,
"price" => $price,"submitter" => $submitter,"date_submitted" => $date_submitted,"total_quantity"=>$total_quantity,"job_flag"=>$job_flag);
}
$this->final_results = $return_results;
return $this;
}
public function show()
{
global $database;
$quote_id = $this->id;
$order = $this->order;
$method = $this->method;
$results = $this->final_results;
$avail_status = $this->avail_status;
$avail_edit = $this->avail_edit;
$link_view = $this->link_view;
$link_edit = $this->link_edit;
$normalised_results = filter::sort_results($method,$order,$results);
$normalise_get = filter::normalise_get($order);
$pagination_results = filter::pagination($normalised_results,$normalise_get);
//filter::pagination_html($pagination_results);
$pagination = $pagination_results['pagination'];
$start = $pagination_results['start'];
$size = $pagination_results['size'];
$total_results = $pagination_results['total_results'];
$max_size = $pagination_results['max_size'];
$order = ($order == "ASC") ? "DESC" : "ASC";
$normalise_get = filter::normalise_get($order);
$new_normalised_results = array();
foreach($normalised_results AS $key => $value)
$new_normalised_results[] = $key;
?>
id;
$order = $this->order;
$method = $this->method;
$results = $this->final_results;
$avail_status = $this->avail_status;
$avail_edit = $this->avail_edit;
$link_view = $this->link_view;
$link_edit = $this->link_edit;
$normalised_results = filter::sort_results($method,$order,$results);
$normalise_get = filter::normalise_get($order);
$pagination_results = filter::pagination($normalised_results,$normalise_get);
//filter::pagination_html($pagination_results);
$pagination = $pagination_results['pagination'];
$start = $pagination_results['start'];
$size = $pagination_results['size'];
$total_results = $pagination_results['total_results'];
$max_size = $pagination_results['max_size'];
$order = ($order == "ASC") ? "DESC" : "ASC";
$normalise_get = filter::normalise_get($order);
$options = array("class" => "material_enter");
$new_normalised_results = array();
foreach($normalised_results AS $key => $value)
$new_normalised_results[] = $key;
?>
