function open_csa_wp_delete_product()
{
if (isset($_POST['product_id'])) {
$product_id = intval(open_csa_wp_clean_input($_POST['product_id']));
if (!empty($product_id)) {
// Updating the information
global $wpdb;
$product_is_used = $wpdb->get_var($wpdb->prepare("\n\t\t\t\t\t\t\t\t\tSELECT COUNT(product_id)\n\t\t\t\t\t\t\t\t\tFROM " . OPEN_CSA_WP_TABLE_PRODUCT_ORDERS . " \n\t\t\t\t\t\t\t\t\tWHERE product_id=%d", $product_id));
if ($product_is_used > 0) {
echo 'skipped, used in orders';
} else {
if ($wpdb->delete(OPEN_CSA_WP_TABLE_PRODUCTS, array('id' => $product_id), array('%d')) === FALSE) {
echo 'error, sql request failed.';
} else {
echo 'success';
}
}
} else {
echo 'error,Empty values.';
}
} else {
echo 'error,Bad request.';
}
wp_die();
// this is required to terminate immediately and return a proper response
}
function open_csa_wp_delete_spot()
{
if (isset($_POST['spot_id'])) {
$spot_id = intval(open_csa_wp_clean_input($_POST['spot_id']));
if (!empty($spot_id)) {
global $wpdb;
$spot_is_used_in_deliveries = $wpdb->get_var($wpdb->prepare("\n\t\t\t\t\t\t\t\t\t\t\t\t\tSELECT COUNT(spot_id)\n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM " . OPEN_CSA_WP_TABLE_DELIVERIES . " \n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE spot_id=%d", $spot_id));
$spot_is_used_in_spots_to_users = $wpdb->get_var($wpdb->prepare("\n\t\t\t\t\t\t\t\t\t\t\t\t\tSELECT COUNT(spot_id)\n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM " . OPEN_CSA_WP_TABLE_SPOTS_TO_USERS . " \n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE spot_id=%d", $spot_id));
if ($spot_is_used_in_deliveries > 0) {
echo 'skipped, used in deliveries';
} else {
// deleting entries in spot to user array
if ($wpdb->delete(OPEN_CSA_WP_TABLE_SPOTS_TO_USERS, array('spot_id' => $spot_id), array('%d')) === FALSE) {
echo 'error, sql request failed.';
} else {
// deleting spot
if ($wpdb->delete(OPEN_CSA_WP_TABLE_SPOTS, array('id' => $spot_id), array('%d')) === FALSE) {
echo 'error, sql request failed.';
} else {
echo 'success';
}
echo 'success';
}
}
} else {
echo 'error,Empty values.';
}
} else {
echo 'error,Bad request.';
}
wp_die();
// this is required to terminate immediately and return a proper response
}
function open_csa_wp_become_responsible()
{
if (isset($_POST['delivery_id']) && isset($_POST['user_id'])) {
$delivery_id = intval(open_csa_wp_clean_input($_POST['delivery_id']));
$user_id = intval(open_csa_wp_clean_input($_POST['user_id']));
if (!empty($delivery_id) && !empty($user_id)) {
global $wpdb;
$user_in_charge = $wpdb->get_var($wpdb->prepare("SELECT user_in_charge FROM " . OPEN_CSA_WP_TABLE_DELIVERIES . " WHERE id=%d", $delivery_id));
if ($user_in_charge != null) {
echo 'skipped, responsible user already exists';
} else {
// Updating the information
if ($wpdb->update(OPEN_CSA_WP_TABLE_DELIVERIES, array('user_in_charge' => $user_id), array('id' => $delivery_id)) === FALSE) {
echo 'error, sql request failed';
} else {
echo 'success';
}
}
} else {
echo 'error,Empty values: ';
}
} else {
echo 'error,Bad request.';
}
wp_die();
// this is required to terminate immediately and return a proper response
}
function CsaWpPluginDeleteDelivery()
{
if (isset($_POST['delivery_id'])) {
$delivery_id = intval(open_csa_wp_clean_input($_POST['delivery_id']));
if (!empty($delivery_id)) {
// Updating the information
global $wpdb;
if ($wpdb->delete(OPEN_CSA_WP_TABLE_DELIVERIES, array('id' => $delivery_id), array('%d')) === FALSE) {
echo 'error, sql request failed.';
} else {
echo 'success';
}
} else {
echo 'error,Empty values.';
}
} else {
echo 'error,Bad request.';
}
wp_die();
// this is required to terminate immediately and return a proper response
}