function getEventUpdatedTicketsWithStatus($eventID, $since) {
global $woocommerce;
global $wpdb;
$table_name = $wpdb->prefix . 'fooevents_check_in';
$postmeta_table_name = $wpdb->prefix . 'postmeta';
$ticketsArray = array();
$ticketStatusOptions = array();
$eventID = sanitize_text_field($eventID);
$since = sanitize_text_field($since);
$tickets = $wpdb->get_results("
SELECT ".$table_name.".*, p1.meta_value AS ticketId, p2.meta_value AS name, p3.meta_value AS variation FROM ".$table_name."
LEFT JOIN ".$postmeta_table_name." AS p1 ON
".$table_name.".tid = p1.post_id AND
p1.meta_key = 'WooCommerceEventsTicketID'
LEFT JOIN ".$postmeta_table_name." AS p2 ON
".$table_name.".tid = p2.post_id AND
p2.meta_key = 'fooevents_custom_option_1'
LEFT JOIN ".$postmeta_table_name." AS p3 ON
".$table_name.".tid = p3.post_id AND
p3.meta_key = 'WooCommerceEventsVariationID'
WHERE
eid = ".$eventID." AND
checkin >= ".$since."
ORDER BY ".$table_name.".`updated` DESC
");
foreach ( $tickets as $ticket ) {
$ticketsArray[] = array(
'wooCommerceEventsTicketID' => $ticket->ticketId,
'status' => $ticket->status,
'time' => (int)$ticket->checkin,
'name' => $ticket->name,
'variation' => (int)$ticket->variation,
);
}
return $ticketsArray;
}
function updateCoupon($ticketID, $add) {
global $woocommerce;
global $wpdb;
$table_name = $wpdb->prefix . 'wc_order_coupon_lookup';
$postmeta_table_name = $wpdb->prefix . 'postmeta';
$order_items_table_name = $wpdb->prefix . 'woocommerce_order_items';
if($add == 1) {
$wpdb->get_results("INSERT INTO ".$table_name." (`order_id`, `coupon_id`, `date_created`, `discount_amount`) VALUES ((SELECT `meta_value` FROM ".$postmeta_table_name." WHERE `meta_key` = 'WooCommerceEventsOrderID' AND `post_id` = (SELECT `post_id` FROM ".$postmeta_table_name." WHERE `meta_key` = 'WooCommerceEventsTicketID' AND `meta_value` = ".$ticketID.")), '11033', Now(), '0')");
$result = $wpdb->get_results("INSERT INTO ".$order_items_table_name." (`order_item_id`, `order_item_name`, `order_item_type`, `order_id`) VALUES (NULL, 'ceremony', 'coupon',(SELECT `meta_value` FROM ".$postmeta_table_name." WHERE `meta_key` = 'WooCommerceEventsOrderID' AND `post_id` = (SELECT `post_id` FROM ".$postmeta_table_name." WHERE `meta_key` = 'WooCommerceEventsTicketID' AND `meta_value` = ".$ticketID.")))");
} else {
$wpdb->get_results("DELETE FROM ".$table_name." WHERE `coupon_id` = '11033' AND `order_id` = ((SELECT `meta_value` FROM ".$postmeta_table_name." WHERE `meta_key` = 'WooCommerceEventsOrderID' AND `post_id` = (SELECT `post_id` FROM ".$postmeta_table_name." WHERE `meta_key` = 'WooCommerceEventsTicketID' AND `meta_value` = ".$ticketID.")))");
$result = $wpdb->get_results("DELETE FROM ".$order_items_table_name." WHERE `order_item_type` = 'coupon' AND `order_id` = (SELECT `meta_value` FROM ".$postmeta_table_name." WHERE `meta_key` = 'WooCommerceEventsOrderID' AND `post_id` = (SELECT `post_id` FROM ".$postmeta_table_name." WHERE `meta_key` = 'WooCommerceEventsTicketID' AND `meta_value` = ".$ticketID."))");
}
return "$result";
}
/**
- Update ticket ID with the provided status
-
@param type $ticketID */ function checkin($ticketID) { $status = "Checked In";
global $wpdb; $table_name = $wpdb->prefix . 'fooevents_check_in';
$events_query = new WP_Query( array('post_type' => array('event_magic_tickets'), 'meta_query' => array( array( 'key' => 'WooCommerceEventsTicketID', 'value' => $ticketID ) )) ); $ticket = $events_query->get_posts(); $ticket = $ticket[0];
$eventID = get_post_meta($ticket->ID, 'WooCommerceEventsProductID', true);
$timestamp = current_time('timestamp');
$statusChanged = false;
$currentStatus = get_post_meta($ticket->ID, 'WooCommerceEventsStatus', true); $result['oldStatus'] = $currentStatus;
if ( $currentStatus != $status ) { $statusChanged = true; update_post_meta( $ticket->ID, 'WooCommerceEventsStatus', strip_tags( $status )); }$wpdb->insert($table_name, array( 'tid' => $ticket->ID, 'eid' => $eventID, 'day' => 1, 'uid' => get_current_user_id(), 'status' => $status, 'checkin' => $timestamp ));
$result['response'] = $statusChanged ? 'Status updated' : 'Status unchanged'; return $result; }
-
public function fooevents_callback_get_check_in(WP_REST_Request $request) {
$authorize_result = $this->fooevents_is_authorized_user($request->get_headers());
if ( $authorize_result && is_object($authorize_result) && is_a($authorize_result, 'WP_User') ) {
error_reporting(0);
ini_set('display_errors', 0);
set_time_limit(0);
$memory_limit = ini_get('memory_limit');
ini_set('memory_limit', '-1');
$eventID = $request->get_param("param2");
$since = $request->get_param("param3");
echo json_encode(getEventUpdatedTicketsWithStatus($eventID, $since));
ini_set('memory_limit', $memory_limit);
} else {
echo json_encode($authorize_result);
}
exit();
}
/**
* Update ticket coupon
*/
public function fooevents_callback_update_coupon(WP_REST_Request $request) {
$authorize_result = $this->fooevents_is_authorized_user($request->get_headers());
if ( $authorize_result && is_object($authorize_result) && is_a($authorize_result, 'WP_User') ) {
error_reporting(0);
ini_set('display_errors', 0);
$ticketID = $request->get_param("id");
$add = $request->get_param("add");
if ( !empty($ticketID) ) {
$output['message'] = updateCoupon($ticketID, $add);
} else {
$output['message'] = 'All fields are required.';
}
echo json_encode($output);
} else {
echo json_encode($authorize_result);
}
exit();
}
/**
-
Update ticket status */ public function fooevents_callback_checkin(WP_REST_Request $request) { $authorize_result = $this->fooevents_is_authorized_user($request->get_headers());
if ( $authorize_result && is_object($authorize_result) && is_a($authorize_result, 'WP_User') ) { error_reporting(0); ini_set('display_errors', 0); $ticketID = $request->get_param("id"); $status = $request->get_param("param3"); $output = checkin($ticketID); echo json_encode($output); } else { echo json_encode($authorize_result); } exit();
}
$rest_api_endpoints = array('login_status',
'get_all_data',
'get_list_of_events',
'get_tickets_in_event',
'get_updated_tickets_in_event',
'get_single_ticket',
'update_ticket_status',
'update_ticket_status_m',
'update_ticket_status_multiday',
'get_check_in',
'update_coupon',
'checkin'
);
<? if (isset($_SERVER['HTTP_ORIGIN']) && $_SERVER['HTTP_ORIGIN'] == 'https://bider01.github.io') {
header("Access-Control-Allow-Origin: https://bider01.github.io");
if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_METHOD']))
header("Access-Control-Allow-Methods: GET, POST, OPTIONS");
if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS']))
header("Access-Control-Allow-Headers: {$_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS']}");
exit(0);
}
} ?>
ng build --output-path docs --base-href /ticket-reports/
##A fooevents.phphoz hozzá kell adni
//RESTAPIHelperOwn
require_once($this->Config->classPath.'ownrestapihelper.php');
$this->RESTAPIHelperOwn = new FooEvents_REST_API_Helper_Own();