function clientorder_update($id, $close = false) { $clientorder_clientorder = new ClientorderCalc(); $components_clientorder = new ComponentClientorder(); $component = new ClientorderComponents(); if (close == true) { $query = ' UPDATE ' . $clientorder_clientorder->table_name . ' SET status="closed" WHERE clientorder_id="' . $id . '" AND deleted=0 '; $this->db->query($query, true, ""); } else { $query = ' SELECT id FROM ' . $clientorder_clientorder->table_name . ' WHERE clientorder_id="' . $id . '" AND deleted=0 '; $result = $this->db->query($query, true, ""); if ($result != false) { while ($data = $this->db->fetchByAssoc($result)) { $clientorder_clientorder->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_clientorder->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_clientorder->table_name . ' WHERE component_id="' . $data['id'] . '" AND deleted=0 '; $result_components_clientorder = $this->db->query($query, true, ""); if ($result_components_clientorder != false) { while ($data = $this->db->fetchByAssoc($result)) { $components_clientorder->mark_deleted($data['id']); } } } } } }