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