OwlCyberSecurity - MANAGER

Edit File: internal-hooks.php

<?php
/**
 * Confirm to trash ticket type
 */
add_action( 'wp_ajax_trash_post_before', 'trash_post_before' );
function trash_post_before() {

$btn_action = sanitize_text_field( $_POST[ 'btn_action' ] );

if ( isset( $btn_action ) ) {

if ( $btn_action == 'trash' ) {
            $post_id = absint( $_POST[ 'trash_id' ] );
            $ticket_type = new TC_Ticket( $post_id );//$99 = id of the ticket type
            $sold_tickets = tc_get_tickets_count_sold( $ticket_type->id );
            $resp = $sold_tickets;
            echo json_encode( $resp );
            die;
        } elseif ( $btn_action == 'multi_trash' ) {
            $ids = tc_sanitize_array2( $_POST[ 'multi_trash_id' ] );

foreach ( $ids as $id ) {
                $ticket_type = new TC_Ticket( $id );//$99 = id of the ticket type
                $sold_tickets = tc_get_tickets_count_sold( $ticket_type->id );
                $resp = $sold_tickets;
                if ( $resp > 0 ) {
                    echo json_encode( $resp );
                    die;
                }
            }
        }
    }
}

/**
 * Populate All Users table header
 */
add_action( 'manage_users_columns', 'tc_modify_user_columns' );
function tc_modify_user_columns( $column_headers ) {
    $column_headers[ 'tc_number_of_orders' ] = __( 'Ticket Orders', 'tc' );
    return $column_headers;
}

/**
 *  Display the total number of users' committed orders
 */
add_action( 'manage_users_custom_column', 'tc_add_number_of_orders_value', 10, 3 );
function tc_add_number_of_orders_value( $value, $column_name, $user_id ) {

if ( 'tc_number_of_orders' == $column_name ) {

global $wpdb;

if ( user_can( $user_id, 'manage_options' ) && $user_id != 0 ) {
            $value = '-';

} else {
            $user_id = (int) $user_id;
            $where = "WHERE {$wpdb->postmeta}.meta_key = '_customer_user' AND {$wpdb->postmeta}.meta_value = $user_id AND {$wpdb->posts}.post_type = 'shop_order'";
            $count = $wpdb->get_var( "SELECT COUNT(*) FROM {$wpdb->posts} INNER JOIN {$wpdb->postmeta} ON {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id {$where}" );
            $value = "<a href='" . esc_url( admin_url( 'edit.php?s&post_type=shop_order&_customer_user=' . $user_id ) ) . "'>" . (int) $count . "</a>";
        }
    }
    return $value;
}

add_action( 'edit_user_profile', 'tc_show_extra_profile_fields_order_history' );
function tc_show_extra_profile_fields_order_history( $user ) {
    ?>
    <h3><?php _e( 'Ticket Order History', 'tc' ); ?><a name="tc_order_history"></a></h3>
    <table class="form-table">
        <tr>
            <th></th>
            <td>
                <?php
                $user_orders = TC_Orders::get_user_orders( $user->ID );

if ( count( $user_orders ) == 0 ) {
                    _e( 'No Orders Found', 'tc' );

} else {
                    ?>
                    <table cellspacing="0" class="widefat shadow-table" cellpadding="10">
                        <tr>
                            <td><?php _e( 'Order ID', 'tc' ); ?></td>
                            <td><?php _e( 'Status', 'tc' ); ?></td>
                            <td><?php _e( 'Date', 'tc' ); ?></td>
                            <td><?php _e( 'Total', 'tc' ); ?></td>
                            <td><?php _e( 'Details', 'tc' ); ?></td>
                        </tr>
                        <?php
                        $style = '';
                        foreach ( $user_orders as $user_order ) {
                            $style = ( ' class="alternate"' == $style ) ? '' : ' class="alternate"';
                            $order = new TC_Order( $user_order->ID );
                            ?>
                            <tr <?php echo tc_sanitize_string($style ); ?>>
                                <td>
                                    <?php echo esc_html( $order->details->post_title ); ?>
                                </td>
                                <td>
                                    <?php
                                    $post_status = $order->details->post_status;
                                    $init_post_status = $post_status;

$tc_order_status_color = array(
                                        'order_fraud' => 'tc_order_fraud',
                                        'order_received' => 'tc_order_recieved',
                                        'order_paid' => 'tc_order_paid',
                                        'order_cancelled' => 'tc_order_cancelled',
                                        'order_refunded' => 'tc_order_fraud'
                                    );

$color = isset( $tc_order_status_color[ $post_status ] ) ? $tc_order_status_color[ $post_status ] : 'tc_order_recieved';

if ( 'order_fraud' == $post_status ) {
                                        $post_status = __( 'Held for Review', 'tc' );
                                    }

$post_status = ucwords( str_replace( '_', ' ', $post_status ) );
                                    echo sprintf( __( '%1$s %2$s %3$s', 'tc' ), '<span class="' . esc_attr( apply_filters( 'tc_order_history_color', $color, $init_post_status ) ) . '">', esc_html( __( ucwords( $post_status ), 'tc' ) ), '</span>' );
                                    ?>
                                </td>
                                <td>
                                    <?php
                                    echo tc_format_date( $order->details->tc_order_date, true );
                                    ?>
                                </td>
                                <td>
                                    <?php
                                    echo tc_esc_html( apply_filters( 'tc_cart_currency_and_format', $order->details->tc_payment_info[ 'total' ] ) );
                                    ?>
                                </td>
                                <td>
                                    <?php
                                    $order_status_url = admin_url( 'post.php?post=' . (int) $order->details->ID . '&action=edit' );
                                    ?>
                                    <a href="<?php echo esc_url( $order_status_url ); ?>"><?php _e( 'Order Details', 'tc' ); ?></a>
                                </td>
                            </tr>
                            <?php
                        } ?>
                    </table>
                    <?php
                } ?>
            </td>
        </tr>
    </table>
    <?php
}

add_action( 'tc_cart_col_title_before_total_price', 'tc_cart_col_title_before_total_price' );
function tc_is_disabled_fee_column() {

$tc_general_settings = get_option( 'tc_general_setting', false );
    $use_global_fees = isset( $tc_general_settings[ 'use_global_fees' ] ) ? $tc_general_settings[ 'use_global_fees' ] : 'no';
    $show_fees = isset( $tc_general_settings[ 'show_fees' ] ) ? $tc_general_settings[ 'show_fees' ] : 'yes';

$disabled = true;

if ( $use_global_fees == 'yes' ) {
        $global_fee_type = $tc_general_settings[ 'global_fee_type' ];
        $global_fee_scope = $tc_general_settings[ 'global_fee_scope' ];

if ( empty( $global_fee_scope ) || $global_fee_scope == '' || $global_fee_scope == 'ticket' ) {
            $global_fee_scope = 'ticket';
            $disabled = false;
        }

if ( $global_fee_scope == 'order' && $global_fee_type == 'fixed' ) {
            $disabled = true;
        }
    } else {
        if ( $show_fees == 'no' ) {
            $disabled = true;
        } else {
            $disabled = false;
        }
    }

if ( $show_fees == 'no' ) {
        $disabled = true;
    }

if ( $disabled ) {
        add_filter( 'tc_cart_table_colspan', 'tc_cart_table_colspan_modify', 10, 1 );
    }

return $disabled;
}

function tc_cart_table_colspan_modify( $colspan ) {
    return $colspan - 1;
}

function tc_cart_col_title_before_total_price() {

$tc_general_settings = get_option( 'tc_general_setting', false );
    $fees_label = isset( $tc_general_settings[ 'fees_label' ] ) ? $tc_general_settings[ 'fees_label' ] : 'FEES';
    $use_global_fees = isset( $tc_general_settings[ 'use_global_fees' ] ) ? $tc_general_settings[ 'use_global_fees' ] : 'no';
    $disabled = tc_is_disabled_fee_column();

if ( ! isset( $tc_general_settings[ 'show_fees' ] ) || ( isset( $tc_general_settings[ 'show_fees' ] ) && $tc_general_settings[ 'show_fees' ] == 'yes' ) ) {
        if ( ! $disabled ) {
            ?>
            <th><?php echo esc_html( $fees_label ); ?></th>
            <?php
        }
    }
}

add_action( 'tc_cart_col_value_before_total_price', 'tc_cart_col_value_before_total_price', 10, 3 );
function tc_cart_col_value_before_total_price( $ticket_type, $ordered_count, $ticket_price ) {

global $total_fees;

$tc_general_settings = get_option( 'tc_general_setting', false );

if ( ! isset( $total_fees ) || ! is_numeric( $total_fees ) ) {
        $total_fees = 0;
    }

$ticket = new TC_Ticket( $ticket_type );
    $fee_type = $ticket->details->ticket_fee_type;
    $fee = $ticket->details->ticket_fee;

if ( $fee == '' || ! isset( $fee ) ) {
        $fee = 0;
    } else {
        if ( $fee_type == 'fixed' ) {
            $fee = round( ( $ordered_count * $fee ), 2 );
        } else {
            $fee = round( ( ( $ticket_price * $ordered_count ) / 100 ) * $fee, 2 );
        }
    }

$use_global_fees = isset( $tc_general_settings[ 'use_global_fees' ] ) ? $tc_general_settings[ 'use_global_fees' ] : 'no';

if ( $use_global_fees == 'yes' ) {
        $global_fee_type = $tc_general_settings[ 'global_fee_type' ];
        $global_fee_value = $tc_general_settings[ 'global_fee_value' ];
        $global_fee_scope = $tc_general_settings[ 'global_fee_scope' ];

if ( empty( $global_fee_scope ) || $global_fee_scope == '' ) {
            $global_fee_scope = 'ticket';
        }

if ( $global_fee_value == '' || ! isset( $global_fee_value ) ) {
            $fee = 0;
        } else {
            if ( $global_fee_type == 'fixed' ) {
                $fee = apply_filters( 'tc_global_fixed_fee_value', round( ( $ordered_count * $global_fee_value ), 2 ), $ordered_count, $global_fee_value );
            } else {
                $fee = apply_filters( 'tc_global_percentage_fee_value', round( ( ( $ticket_price * $ordered_count ) / 100 ) * $global_fee_value, 2 ), $ticket_price, $ordered_count, $global_fee_value );
            }
        }
    }

$total_fees = apply_filters( 'tc_total_fees_value', $total_fees + $fee, $use_global_fees, isset( $global_fee_scope ) ? $global_fee_scope : 'ticket', $ordered_count, isset( $global_fee_value ) ? $global_fee_value : 0, $ticket_price, isset( $global_fee_type ) ? $global_fee_type : 'percentage' );

tc_session_start();

$disabled = tc_is_disabled_fee_column();

$_SESSION[ 'tc_total_fees' ] = $total_fees;

$tc_general_settings = get_option( 'tc_general_setting', false );
    if ( ! isset( $tc_general_settings[ 'show_fees' ] ) || ( isset( $tc_general_settings[ 'show_fees' ] ) && $tc_general_settings[ 'show_fees' ] == 'yes' ) ) {
        if ( ! $disabled ) {
            ?>
            <td class="ticket-fee" class="ticket_fee"><?php echo tc_esc_html( apply_filters( 'tc_cart_currency_and_format', $fee ) ); ?></td>
            <?php
        }
    }
}

add_filter( 'tc_total_fees_value', 'tc_total_fees_value_modify', 10, 7 );
function tc_total_fees_value_modify( $total_fees, $use_global_fees, $global_fee_scope, $ordered_count, $global_fee_value, $ticket_price, $global_fee_type ) {
    if ( $use_global_fees == 'yes' && $global_fee_scope == 'order' && $global_fee_type == 'fixed' ) {
        $total_fees = $global_fee_value;
    }
    return $total_fees;
}

function tc_modify_global_fixed_fee_value( $value, $ordered_count, $global_fee_value ) {
    return $global_fee_value;
}

function tc_global_percentage_fee_value( $value, $ticket_price, $ordered_count, $global_fee_value ) {
    return $value;
}

/**
 * Render total price in cart page.
 */
add_action( 'tc_cart_col_value_before_total_price_total', 'tc_cart_col_value_before_total_price_total', 11, 1 );
function tc_cart_col_value_before_total_price_total( $total ) {

global $total_fees;

$tc_general_settings = get_option( 'tc_general_setting', false );
    $fees_label = isset( $tc_general_settings[ 'fees_label' ] ) ? $tc_general_settings[ 'fees_label' ] : 'FEES';

do_action( 'tc_cart_col_value_before_total_price_fees' );
    add_filter( 'tc_cart_total', 'tc_cart_total_with_fees', 10, 1 );

if ( ! function_exists( 'tc_cart_total_with_fees' ) ) {

function tc_cart_total_with_fees( $total_price ) {
            global $total_fees;
            return $total_price + apply_filters( 'tc_discounted_fees_total', $total_fees );
        }
    }

if ( ! isset( $tc_general_settings[ 'show_fees' ] ) || ( isset( $tc_general_settings[ 'show_fees' ] ) && 'yes' == $tc_general_settings[ 'show_fees' ] ) ) : ?>
        <div>
            <span class="total_item_title"><?php echo esc_html( $fees_label ); ?>:</span><span class="total_item_amount"><?php echo tc_esc_html( apply_filters( 'tc_cart_currency_and_format', $total_fees ) ); ?></span>
        </div>
    <?php endif;
}

/**
 * Render the total price with tax in cart page.
 */
add_action( 'tc_cart_col_value_before_total_price_total', 'tc_cart_tax', 12, 1 );
function tc_cart_tax( $total ) {

global $tc, $total_fees, $tax_value;

$tc_general_settings = get_option( 'tc_general_setting', false );
    $tax_inclusive = tc_is_tax_inclusive();
    $total_cart = round( $total + $total_fees, 2 );

$tax_value = ( $tax_inclusive )
        ? round( $total_cart - ( $total_cart / ( ( $tc->get_tax_value() / 100 ) + 1 ) ), 2 )
        : round( $total_cart * ( $tc->get_tax_value() / 100 ), 2 );

$tax_label = isset( $tc_general_settings[ 'tax_label' ] ) ? $tc_general_settings[ 'tax_label' ] : 'TAX';

tc_session_start();

$_SESSION[ 'tc_tax_value' ] = $tax_value;
    $_SESSION[ 'cart_info' ][ 'total' ] = $tax_inclusive ? $total_cart : ( $total_cart + $tax_value );

add_filter( 'tc_cart_total', 'tc_cart_total_with_tax', 10, 1 );
    if ( ! function_exists( 'tc_cart_total_with_tax' ) ) {

function tc_cart_total_with_tax( $total_price ) {

$tax_inclusive = tc_is_tax_inclusive();

global $tax_value;

tc_session_start();

$_SESSION[ 'tc_cart_total' ] = $tax_inclusive ? $total_price : ( $total_price + $tax_value );
            return $tax_inclusive ? $total_price : ( $total_price + $tax_value );
        }
    }

do_action( 'tc_cart_col_value_before_total_price_tax' );

if ( ! isset( $tc_general_settings[ 'show_tax_rate' ] ) || ( isset( $tc_general_settings[ 'show_tax_rate' ] ) && 'yes' == $tc_general_settings[ 'show_tax_rate' ] ) ) : ?>
        <div>
            <span class="total_item_title"><?php echo esc_html( $tax_label ); ?>:</span><span class="total_item_amount"><?php echo tc_esc_html( apply_filters( 'tc_cart_currency_and_format', $tax_value ) ); ?></span>
        </div>
    <?php endif;
}

add_filter( 'tc_discounted_total', 'tc_discounted_total', 10, 1 );
function tc_discounted_total( $total ) {

tc_session_start();

$tax_value = isset( $_SESSION[ 'tc_tax_value' ] ) ? (float) $_SESSION[ 'tc_tax_value' ] : 0;
    $total_fees = isset( $_SESSION[ 'tc_total_fees' ] ) ? (float) $_SESSION[ 'tc_total_fees' ] : 0;

return ( tc_is_tax_inclusive() )
        ? round( $total + $total_fees, 2 )
        : round( $total + $total_fees + $tax_value, 2 );
}

add_filter( 'tc_event_date_time_element', 'tc_event_date_time_element', 10, 1 );
function tc_event_date_time_element( $date ) {
    return date_i18n( get_option( 'date_format' ) . ' ' . get_option( 'time_format' ), strtotime( $date ), false );
}

add_filter( 'tc_checkins_date_checked', 'tc_checkins_date_checked', 10, 1 );
function tc_checkins_date_checked( $date ) {
    return tc_format_date( $date );
}

add_filter( 'tc_checkins_status', 'tc_checkins_status', 10, 1 );
function tc_checkins_status( $status ) {

if ( 'Pass' == $status ) {
        $status = '<span class="status_green">' . esc_html( $status ) . '</span>';

} elseif ( 'Fail' == $status ) {
        $status = '<span class="status_red">' . esc_html( $status ) . '</span>';
    }

return $status;
}

add_filter( 'tc_checkins_api_key_id', 'tc_checkins_api_key_id', 10, 1 );
function tc_checkins_api_key_id( $api_key_id ) {
    $api_key = new TC_API_Key( $api_key_id );
    return '<a href="' . esc_url( admin_url( 'edit.php?post_type=tc_events&page=tc_settings&tab=api&action=edit&ID=' . (int) $api_key_id ) ) . '">' . esc_html( $api_key->details->api_key_name ) . '</a>';;
}

/**
 * Assign Order Status Colors
 */
add_filter( 'tc_order_field_value', 'tc_order_field_value', 10, 5 );
function tc_order_field_value( $order_id, $value, $meta_key, $field_type, $field_id = false ) {

global $tc;

if ( $field_type == 'order_status' ) {

$new_value = str_replace( '_', ' ', $value );

switch ( $value ) {

case 'order_refunded':
            case 'order_fraud':
                $color = "tc_order_fraud";
                break;

case 'order_received':
                $color = "tc_order_recieved";
                break;

case 'order_paid':
                $color = "tc_order_paid";
                break;

case 'order_cancelled':
                $color = "tc_order_cancelled";
                break;

default:
                $color = "black";
        }

$note = '';
        $notes = TC_Order::get_order_notes( $order_id );

if ( isset( $notes ) && isset( $notes[ 'tc_order_notes' ] ) && count( $notes[ 'tc_order_notes' ] ) > 0 ) {
            $note_text = isset( $notes[ 'tc_order_notes' ][ 0 ] ) ? wp_kses_post( $notes[ 'tc_order_notes' ][ 0 ][ 'created_at' ] . '' . $notes[ 'tc_order_notes' ][ 0 ][ 'note' ] ) : '';
            $note = '<i class="fa fa-flag" title="' . esc_attr( $note_text ) . '" alt="' . esc_attr( $note_text ) . '" aria-hidden="true"></i>';
        }

return sprintf( __( '%1$s %2$s %3$s', 'tc' ), '<span class="' . esc_attr( $color ) . '">', __( ucwords( $new_value ), 'tc' ), $note . '</span>' );

} else if ( $field_id == 'order_date' ) {
        return tc_format_date( $value );

} else if ( $field_id == 'customer' ) {

$order = new TC_Order( $order_id );
        $author_id = $order->details->post_author;

return ( ! user_can( $author_id, 'manage_options' ) && $author_id != 0 )
            ? '<a href="' . esc_url( admin_url( 'user-edit.php?user_id=' . (int) $author_id ) ) . '">' . sanitize_text_field( $value[ 'buyer_data' ][ 'first_name_post_meta' ] . ' ' . $value[ 'buyer_data' ][ 'last_name_post_meta' ] ) . '</a>'
            : ( isset( $value[ 'buyer_data' ] ) ? sanitize_text_field( $value[ 'buyer_data' ][ 'first_name_post_meta' ] . ' ' . $value[ 'buyer_data' ][ 'last_name_post_meta' ] ) : __( 'N/A', 'tc' ) );

} elseif ( $field_id == 'parent_event' ) {

$events = $tc->get_cart_events( $value );

foreach ( $events as $event_id ) {

$event = new TC_Event( $event_id );

if ( isset( $event->details->ID ) ) {
                echo '<a href="post.php?post=' . (int) $event->details->ID . '&action=edit">' . esc_html( $event->details->post_title ) . '</a> x ' . (int) $tc->get_cart_event_tickets( $value, $event->details->ID ) . '<br />';

} else {
                _e( 'N/A', 'tc' );
            }
        }

} elseif ( $field_id == 'gateway' && isset( $value[ 'gateway' ] ) ) {
        return $value[ 'gateway' ];

} elseif ( $field_id == 'gateway_admin_name' && isset( $value[ 'gateway_admin_name' ] ) ) {
        return $value[ 'gateway_admin_name' ];

} elseif ( $field_id == 'discount' ) {

$discounts = new TC_Discounts();
        $discount_total = $discounts->get_discount_total_by_order( $order_id );

if ( isset( $value[ 'coupon_code' ] ) ) {
            $discount_object = get_page_by_title( $value[ 'coupon_code' ], OBJECT, 'tc_discounts' );

} else {
            $discount_total = 0;
        }

return ( $discount_total > 0 )
            ? tc_sanitize_string( apply_filters( 'tc_cart_currency_and_format', $discount_total ) ) . '<br />' . __( 'Code: ', 'tc' ) . '<a href="edit.php?post_type=tc_events&page=tc_discount_codes&action=edit&ID=' . (int) $discount_object->ID . '">' . esc_html( $value[ 'coupon_code' ] ) . '</a>'
            : '-';

} elseif ( $field_id == 'total' && isset( $value[ 'total' ] ) ) {
        return tc_sanitize_string( apply_filters( 'tc_cart_currency_and_format', $value[ 'total' ] ) );

} elseif ( $field_id == 'subtotal' && isset( $value[ 'subtotal' ] ) ) {
        return tc_sanitize_string( apply_filters( 'tc_cart_currency_and_format', $value[ 'subtotal' ] ) );

} elseif ( $field_id == 'fees_total' && isset( $value[ 'fees_total' ] ) ) {
        return tc_sanitize_string( apply_filters( 'tc_cart_currency_and_format', $value[ 'fees_total' ] ) );

} elseif ( $field_id == 'tax_total' && isset( $value[ 'tax_total' ] ) ) {
        return tc_sanitize_string( apply_filters( 'tc_cart_currency_and_format', $value[ 'tax_total' ] ) );

} else {
        return $value;
    }
}

/**
 * Add additional fields to events admin
 */
add_filter( 'tc_event_fields', 'my_custom_events_admin_fields' );
function my_custom_events_admin_fields( $event_fields ) {

$event_fields[] = array(
        'field_name' => 'event_shortcode',
        'field_title' => __( 'Shortcode', 'tc' ),
        'field_type' => 'read-only',
        'table_visibility' => true,
        'show_in_post_type' => false
    );

if ( current_user_can( apply_filters( 'tc_event_activation_capability', 'edit_others_tc_events' ) ) || current_user_can( 'manage_options' ) ) {
        $event_fields[] = array(
            'field_name' => 'event_active',
            'field_title' => __( 'Active', 'tc' ),
            'field_type' => 'read-only',
            'table_visibility' => true,
            'table_edit_invisible' => true,
            'show_in_post_type' => false
        );
    }

return $event_fields;
}

add_filter( 'tc_event_object_details', 'my_custom_tc_event_object_details' );
function my_custom_tc_event_object_details( $object_details ) {
    $object_details->event_shortcode = '[event id="' . (int) $object_details->ID . '"]';
    $event_status = get_post_status( $object_details->ID );
    $on = $event_status == 'publish' ? 'tc-on' : '';
    $object_details->event_active = '<div class="tc-control ' . $on . '" event_id="' . esc_attr( $object_details->ID ) . '"><div class="tc-toggle"></div></div>';
    return $object_details;
}

/**
 * Add custom fields to tickets admin
 */
add_filter( 'tc_ticket_fields', 'my_custom_tickets_admin_fields' );
function my_custom_tickets_admin_fields( $ticket_fields ) {

$ticket_fields[] = array(
        'field_name' => 'ticket_shortcode',
        'field_title' => __( 'Shortcode', 'tc' ),
        'field_type' => 'read-only',
        'table_visibility' => true,
        'post_field_type' => 'read-only'
    );

return $ticket_fields;
}

add_filter( 'tc_ticket_object_details', 'my_custom_tc_ticket_object_details' );
function my_custom_tc_ticket_object_details( $object_details ) {
    $object_details->ticket_shortcode = '[ticket id="' . (int) $object_details->ID . '"]';

global $wpdb;
    $sold_records = $wpdb->get_results( $wpdb->prepare( "SELECT COUNT(*) as cnt, p.post_parent FROM {$wpdb->posts} p, {$wpdb->postmeta} pm WHERE p.ID = pm.post_id AND pm.meta_key = 'ticket_type_id' AND pm.meta_value = %d GROUP BY p.post_parent", $object_details->ID ) );
    $sold_count = 0;
    foreach ( $sold_records as $sold_record ) {
        if ( get_post_status( $sold_record->post_parent ) == 'order_paid' ) {
            $sold_count = $sold_count + $sold_record->cnt;
        }
    }

$ticket_status = get_post_status( $object_details->ID );
    $on = $ticket_status == 'publish' ? 'tc-on' : '';
    $object_details->ticket_active = '<div class="tc-control ' . $on . '" ticket_id="' . esc_attr( $object_details->ID ) . '"><div class="tc-toggle"></div></div>';

$object_details->quantity_sold = $sold_count;
    return $object_details;
}

add_filter( 'tc_ticket_instance_field_value', 'tc_ticket_instance_field_value', 10, 5 );
function tc_ticket_instance_field_value( $value = false, $field_value = false, $post_field_type = false, $col_field_id = false, $field_id = false ) {//$value, $post_field_type, $var_name
    if ( $field_id == 'order' ) {

$parent_post = get_post_ancestors( $value );
        $parent_post = isset( $parent_post[ 0 ] ) ? $parent_post[ 0 ] : 0;

$order = new TC_Order( $parent_post );

$order_found = false;

if ( get_post_type( $order->details->ID ) == 'tc_orders' ) {
            $order_found = true;
        }

$order_found = apply_filters( 'tc_order_found', $order_found, $order->details->ID );

if ( $order_found ) {

if ( current_user_can( 'manage_orders_cap' ) ) {
                $value = tc_esc_html( apply_filters( 'tc_ticket_instance_order_admin_url', '<a target="_blank" href="' . esc_url( admin_url( 'post.php?post=' . $order->details->ID . '&action=edit' ) ) . '">' . esc_html( $order->details->post_title ) . '</a>', $parent_post, $order->details->post_title ) );
            } else {
                $value = $order->details->post_title;
            }
        } else {
            $value = __( 'N/A', 'tc' );
        }
    }

if ( $field_id == 'event' ) {
        $value = tc_get_ticket_instance_event( false, false, $value );
    }

if ( $field_id == 'ticket_code' ) {
        $value = $field_value;
    }

if ( $field_id == 'ticket_type_id' ) {
        $ticket_type = new TC_Ticket( $field_value );
        $value = apply_filters( 'tc_checkout_owner_info_ticket_title', isset( $ticket_type->details->post_title ) ? $ticket_type->details->post_title : __( 'N/A', 'tc' ), $field_value, array(), $value );
    }

if ( $field_id == 'ticket' ) {
        $value = '<a target="_blank" href="' . esc_url( admin_url( 'edit.php?post_type=tc_tickets_instances&tc_preview&ticket_instance_id=' . $field_value ) ) . '">' . __( 'View', 'tc' ) . '</a> | <a target="_top" href="' . esc_url( admin_url( 'edit.php?post_type=tc_tickets_instances&tc_download&ticket_instance_id=' . $field_value ) ) . '">' . __( 'Download', 'tc' ) . '</a>';
    }

if ( $field_id == 'checkins' ) {
        $ticket_instance = new TC_Ticket_Instance( $field_value );
        $checkins_pass = $ticket_instance->get_number_of_checkins( 'pass' );
        $checkins_fail = $ticket_instance->get_number_of_checkins( 'fail' );
        $value = '<a href="' . admin_url( 'post.php?post=' . $field_value . '&action=edit' ) . '">';
        $value .= '<span class="' .  ( $checkins_pass > 0 ? 'status_green' : '' ) . '">' . (int) $checkins_pass . '</span>';

if ( $checkins_fail > 0 ) {
            $value .= ' | <span class="status_red">' . (int) $checkins_fail . '</span>';
        }

$value .= __( ' Details', 'tc' );
        $value .= '</a>';
    }

if ( $field_id == 'owner_name' ) {
        $owner_name = get_post_meta( $value, 'first_name', true ) . ' ' . get_post_meta( $value, 'last_name', true );
        if ( trim( $owner_name ) == '' ) {
            $parent_post = get_post_ancestors( $value );
            $parent_post = isset( $parent_post[ 0 ] ) ? $parent_post[ 0 ] : 0;
            $order = new TC_Order( $parent_post );
            $buyer_full_name = isset( $order->details->tc_cart_info[ 'buyer_data' ] ) ? ( isset( $order->details->tc_cart_info[ 'buyer_data' ][ 'first_name_post_meta' ] ) ? $order->details->tc_cart_info[ 'buyer_data' ][ 'first_name_post_meta' ] : '' ) . ' ' . ( isset( $order->details->tc_cart_info[ 'buyer_data' ][ 'last_name_post_meta' ] ) ? $order->details->tc_cart_info[ 'buyer_data' ][ 'last_name_post_meta' ] : '' ) : __( 'N/A', 'tc' );

if ( trim( $buyer_full_name ) !== '' ) {
                $value = apply_filters( 'tc_ticket_buyer_name_element', $buyer_full_name, $parent_post );
                $value = trim( $value );
                if ( empty( $value ) ) {
                    $value = '-';
                }

} else {
                $value = apply_filters( 'tc_ticket_buyer_name_element', '-', $parent_post );
                $value = trim( $value );
                if ( empty( $value ) ) {
                    $value = '-';
                }
            }

} else {
            $value = $owner_name;
        }
    }

return apply_filters( 'tc_column_value', $value, $field_id );
}

/**
 * Render API Key Table Values
 */
add_filter( 'tc_api_key_field_value', 'tc_api_key_field_value', 10, 3 );
function tc_api_key_field_value( $value, $post_field_type, $var_name ) {

if ( 'event_name' == $var_name ) {

$values = (array) $value;

// Searching through Multidimensional Array
        if ( is_array( $is_array = reset( $values ) ) && in_array( 'all', $is_array ) ) {
            $value = __( 'All Events', 'tc' );

} elseif ( ! is_array( reset( $values ) ) && in_array( 'all', $values ) ) {
            $value = __( 'All Events', 'tc' );

} else {

$values = is_array( $is_array = reset( $values ) ) ? $is_array : $values;

$temp = '';
            foreach ( $values as &$value ) {

$event_obj = new TC_Event( $value );
                $event_object = $event_obj->details;
                $temp .= $event_object->post_title . '<br>';
            }
            $value = $temp;
        }

} elseif ( 'api_username' == $var_name ) {

if ( '' == trim( $value ) ) {
            $value = __( 'Administrator', 'tc' );

} else {

$users = get_users( [
                'blog_id' => (int) $GLOBALS[ 'blog_id' ],
                'search' => $value
            ] );

$user = ( isset( $users[ 0 ] ) ) ? $users[ 0 ] : $users;
            $value = isset( $user )
                ? '<a target="_blank" href="' . esc_url( admin_url( 'user-edit.php?user_id=' . @$user->ID ) ) . '">' . esc_html( @$user->user_login . ' ' . ( isset( $user->display_name ) && '' != $user->display_name ? '(' . $user->display_name . ')' : '' ) ) . '</a>'
                : __( 'Wrong user. API will be available to the administrators only.', 'tc' );
        }
    }

return $value;
}

add_filter( 'tc_ticket_field_value', 'tc_ticket_field_value', 10, 3 );
function tc_ticket_field_value( $value, $post_field_type, $var_name ) {

$quantity_available = 0;

if ( $var_name == 'event_name' ) {
        $event_obj = new TC_Event( $value );
        $event_object = $event_obj->details;
        $value = $event_object->post_title;
    }

if ( $var_name == 'quantity_available' ) {
        $quantity_available = $value;
        if ( $value == 0 || $value == '' ) {
            $value = __( 'Unlimited', 'tc' );
        }
    }

if ( $var_name == 'min_tickets_per_order' ) {
        if ( $value == 0 || $value == '' ) {
            $value = __( 'No minimum', 'tc' );
        }
    }

if ( $var_name == 'max_tickets_per_order' ) {
        if ( $value == 0 || $value == '' ) {
            $value = __( 'No maximum', 'tc' );
        }
    }

if ( $var_name == 'ticket_fee' ) {
        if ( $value == 0 || $value == '' ) {
            $value = __( '-', 'tc' );
        } else {
            $value = $value;
        }
    }

if ( $var_name == 'ticket_fee_type' ) {
        if ( $value == 'fixed' ) {
            $value = 'Fixed';
        } else {
            $value = 'Percentage';
        }
    }

return $value;
}

add_filter( 'tc_discount_field_value', 'tc_discount_values', 10, 3 );
function tc_discount_values( $value, $post_field_type, $var_name ) {
    global $tc_last_discount_code;

switch ( $var_name ) {

case 'post_title':
            $tc_last_discount_code = $value;
            break;

case 'usage_limit':
        case 'discount_per_user':
            $value = ( ! $value ) ? __( 'Unlimited', 'tc' ) : $value;
            break;

case 'discount_availability':
        case 'discount_on_user_roles':

if ( $value ) {
                $values = ! is_array( $value ) ? explode( ',', $value ) : $value;

$value_combined = '';
                foreach ( array_filter( $values ) as $val ) {

if ( 'discount_availability' == $var_name ) {

$ticket_obj = new TC_Ticket( $val );
                        $event_obj = new TC_Event( $ticket_obj->details->event_name );
                        $event_details = ( $event_obj->id ) ? ' (' . $event_obj->details->post_title . ')' : '';
                        $value_combined .= $ticket_obj->details->post_title . $event_details . '<br />';

} else {
                        $value_combined .= ucfirst( $val ) . '<br />';
                    }
                }

$value = $value_combined;

} else {
                $value = __( 'All', 'tc' );
            }
            break;

case 'discount_type':

if ( 1 == $value ) {
                $value = __( 'Fixed Amount (per item)', 'tc' );

} elseif ( 2 == $value ) {
                $value = __( 'Percentage (%)', 'tc' );

} else {
                $value = __( 'Fixed Amount (per order)', 'tc' );
            }
            break;

case 'discount_on_returning_customer':
            $value = ( 'yes' == $value ) ? __( 'Yes', 'tc' ) : __( 'No', 'tc' );
            break;
    }
    return $value;
}
?>