public function get_exceptions() { global $wpdb; $table = appointments_get_table('exceptions'); return $wpdb->get_results($wpdb->prepare("SELECT * FROM {$table} WHERE worker = %d", $this->ID)); }
/** * Delete a service * * @param int $service_id * * @return bool|false|int */ function appointments_delete_service($service_id) { global $wpdb; if (!appointments_get_service($service_id)) { return false; } $table = appointments_get_table('services'); $service_id = absint($service_id); $result = $wpdb->query($wpdb->prepare("DELETE FROM {$table} WHERE ID = %d", $service_id)); // Remove the service from all workers $table = appointments_get_table('workers'); $wpdb->query($wpdb->prepare("UPDATE {$table} SET services_provided = REPLACE( services_provided,':%d:','' )", $service_id)); if ($result) { appointments_delete_service_cache($service_id); return true; } return false; }
/** * Delete an appointment forever * * @param $app_id * * @return bool|false|int */ function appointments_delete_appointment($app_id) { global $wpdb; $app = appointments_get_appointment($app_id); if (!$app) { return false; } $table = appointments_get_table('appointments'); $result = $wpdb->query($wpdb->prepare("DELETE FROM {$table} WHERE ID = %d", $app_id)); appointments_clear_appointment_cache($app_id); return (bool) $result; }