public function add_update_space($space) { $util = new utilities(); $plan = $util->get_cobot_plan('Virtual', $space['id']); $default_plan_id = ""; if ($plan) { $default_plan_id = $plan->id; } $sql = "SELECT * FROM cobot_spaces where id = '" . $space['id'] . "'"; error_log($sql); $query = $this->db->query($sql); $spaces = $query->result(); error_log(count($spaces)); try { if (count($spaces) <= 0) { $sql = "INSERT INTO cobot_spaces"; $sql .= "(id, image, capacity, lat, lon, address_1, address_2, rate, name, description, main_area_id, default_plan_id) " . "VALUES " . "(\"" . $space['id'] . "\", \"" . $space['imgName'] . "\", " . $space['capacity'] . ", \"" . $space['lat'] . "\", \"" . $space['long'] . "\", \"" . $space['address_1'] . "\", \"" . $space['address_2'] . "\", " . $space['rate'] . ", \"" . $space['name'] . "\", \"" . $space['description'] . "\", \"" . $space['main_area_id'] . "\", \"" . $default_plan_id . "\") "; error_log($sql); if ($this->db->query($sql) === TRUE) { error_log("Cobot space created successfully"); $this->setup_webhook_subscriptions($space['id']); } else { error_log("Error: " . $sql . "<br>" . $this->db->error); } } else { $sql = "UPDATE cobot_spaces SET image = \"" . $space['imgName'] . "\", capacity = " . $space['capacity'] . ", lat = \"" . $space['lat'] . "\", lon = \"" . $space['long'] . "\", address_1 = \"" . $space['address_1'] . "\", address_2 = \"" . $space['address_2'] . "\", rate = " . $space['rate'] . ", name = \"" . $space['name'] . "\", description = \"" . $space['description'] . "\", main_area_id = \"" . $space['main_area_id'] . "\", default_plan_id = \"" . $default_plan_id . "\" WHERE id='" . $space['id'] . "'"; error_log($sql); $this->db->query($sql); $sql = "DELETE from cobot_resources where space_id = '" . $space['id'] . "'"; error_log($sql); $this->db->query($sql); } } catch (Exception $e) { error_log('Caught exception: ', $e->getMessage(), "\n"); } }