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");
}
}
