function estimate_update($id, $close = false)
{
$estimate_estimate = new EstimateCalc();
$components_estimate = new ComponentEstimate();
$component = new EstimateComponents();
if (close == true) {
$query = ' UPDATE ' . $estimate_estimate->table_name . ' SET status="closed" WHERE estimate_id="' . $id . '" AND deleted=0 ';
$this->db->query($query, true, "");
} else {
$query = ' SELECT id FROM ' . $estimate_estimate->table_name . ' WHERE estimate_id="' . $id . '" AND deleted=0 ';
$result = $this->db->query($query, true, "");
if ($result != false) {
while ($data = $this->db->fetchByAssoc($result)) {
$estimate_estimate->mark_deleted($data['id']);
}
}
}
$query = ' SELECT id FROM ' . $component->table_name . ' WHERE parent_id="' . $id . '" AND deleted=0 ';
$result = $this->db->query($query, true, "");
if ($result != false) {
if (close == true) {
$query = ' UPDATE ' . $component->table_name . ' SET status="closed" WHERE parent_id="' . $id . '" AND deleted=0 ';
$this->db->query($query, true, "");
}
while ($data = $this->db->fetchByAssoc($result)) {
if (close == true) {
$query = ' UPDATE ' . $components_estimate->table_name . ' SET status="closed" WHERE component_id="' . $data['id'] . '" AND deleted=0 ';
$this->db->query($query, true, "");
} else {
$component->mark_deleted($data['id']);
$query = ' SELECT id FROM ' . $components_estimate->table_name . ' WHERE component_id="' . $data['id'] . '" AND deleted=0 ';
$result_components_estimate = $this->db->query($query, true, "");
if ($result_components_estimate != false) {
while ($data = $this->db->fetchByAssoc($result)) {
$components_estimate->mark_deleted($data['id']);
}
}
}
}
}
}
