/**

const ORDER_INCOMPLETE = 'incomplete';

const ORDER_COMPLETED = 'completed';

const ORDER_CANCELLED = 'cancelled';

const ORDER_TRASH = 'trash';

const ORDER_PENDING = 'pending';

/**

const PAYMENT_PAID = 'paid';

const PAYMENT_FAILED = 'failed';

const PAYMENT_UNPAID = 'unpaid';

const PAYMENT_REFUNDED = 'refunded';

const PAYMENT_PARTIALLY_REFUNDED = 'partially-refunded';

const PAYMENT_PENDING = 'pending';

/**

const PAYMENT_METHOD_MANUAL = 'manual';

const PAYMENT_METHOD_FREE = 'free';

/**

const META_KEY_HISTORY = 'history';

const META_KEY_REFUND = 'refund';

const META_KEY_ORDER_ID = 'tutor_order_id_';

const META_KEY_BILLING_ADDRESS = 'billing_address';

/**

const META_ENROLLMENT_FEE = 'plan_enrollment_fee';

const META_TRIAL_FEE = 'plan_trial_fee';

const META_PLAN_INFO = 'plan_info';

const META_IS_PLAN_TRIAL_ORDER = 'is_plan_trial_order';

const META_IS_RESUBSCRIPTION_ORDER = 'is_resubscription_order';

/**

const TAX_TYPE_EXCLUSIVE = 'exclusive';

const TAX_TYPE_INCLUSIVE = 'inclusive';

/**

const TYPE_SINGLE_ORDER = 'single_order';

const TYPE_SUBSCRIPTION = 'subscription';

const TYPE_RENEWAL = 'renewal';

/**

const TRANSIENT_ORDER_BADGE_COUNT = 'tutor_order_badge_count';

/**

const ORDER_PLACEMENT_SUCCESS = 'success';

/**

const ORDER_PLACEMENT_FAILED = 'failed';

/**

private $table_name = 'tutor_orders';

/**

private $order_item_table = 'tutor_order_items';

/**

private $order_items_fillable_fields = array(

'order_id',

'item_id',

'regular_price',

'sale_price',

'discount_price',

'coupon_code',

);

/**

public function __construct() {

global $wpdb;

$this->table_name = $wpdb->prefix . $this->table_name;

$this->order_item_table = $wpdb->prefix . $this->order_item_table;

}

/**

public function get_table_name() {

return $this->table_name;

}

/**

public function get_row( $where = array() ) {

return QueryHelper::get_row( $this->table_name, $where, 'id' );

}

/**

public function get_recalculated_order_tax_data( $order ) {

$tax_type = Tax::get_tax_type();

$tax_rate = Tax::get_user_tax_rate( $order->user_id );

$order = self::get_order( $order );

$order_data = array(

'tax_type' => null,

'tax_rate' => null,

'tax_amount' => null,

);

if ( ! Tax::should_calculate_tax()

|| ! $tax_rate

|| ! $order

|| ! $order->pre_tax_price ) {

return $order_data;

}

$order_data['tax_type'] = $tax_type;

$order_data['tax_rate'] = $tax_rate;

if ( ! Tax::is_tax_included_in_price() ) {

// For exclusive tax type.

$tax_amount = Tax::calculate_tax( $order->pre_tax_price, $tax_rate );

$total_price = $order->pre_tax_price + $tax_amount;

$order_data['tax_amount'] = $tax_amount;

$order_data['total_price'] = $total_price;

$order_data['net_payment'] = $total_price;

} else {

// For inclusive tax type.

$tax_amount = Tax::calculate_tax( $order->total_price, $tax_rate );

$order_data['tax_amount'] = $tax_amount;

$order_data['pre_tax_price'] = $order->total_price - $tax_amount;

}

return $order_data;

}

/**

public function get_order_item_display_price( $item ) {

$display_price = is_numeric( $item->sale_price )

? $item->sale_price

: ( is_numeric( $item->discount_price ) ? $item->discount_price : $item->regular_price );

return $display_price;

}

/**

public function has_order_item_sale_price( $item ) {

return is_numeric( $item->sale_price ) || is_numeric( $item->discount_price );

}

/**

public static function get_order_status() {

return array(

self::ORDER_INCOMPLETE => __( 'Incomplete', 'tutor' ),

self::ORDER_COMPLETED => __( 'Completed', 'tutor' ),

self::ORDER_CANCELLED => __( 'Cancelled', 'tutor' ),

self::ORDER_TRASH => __( 'Trash', 'tutor' ),

self::ORDER_PENDING => __( 'Pending', 'tutor' ),

);

}

/**

public static function get_order_type_list() {

return array(

self::TYPE_SINGLE_ORDER => __( 'Single Order', 'tutor' ),

self::TYPE_SUBSCRIPTION => __( 'Subscription', 'tutor' ),

self::TYPE_RENEWAL => __( 'Renewal', 'tutor' ),

);

}

/**

public static function get_payment_status() {

return array(

self::PAYMENT_PAID => __( 'Paid', 'tutor' ),

self::PAYMENT_UNPAID => __( 'Unpaid', 'tutor' ),

self::PAYMENT_FAILED => __( 'Failed', 'tutor' ),

self::PAYMENT_REFUNDED => __( 'Refunded', 'tutor' ),

self::PAYMENT_PARTIALLY_REFUNDED => __( 'Partially Refunded', 'tutor' ),

self::PAYMENT_PENDING => __( 'Pending', 'tutor' ),

);

}

/**

public function get_order_items_fillable_fields() {

return $this->order_items_fillable_fields;

}

/**

private function get_searchable_fields() {

return array(

'o.id',

'o.transaction_id',

'o.coupon_code',

'o.payment_method',

'o.order_status',

'o.payment_status',

'u.display_name',

'u.user_login',

'u.user_email',

);

}

/**

public function create_order( array $data ) {

$order_items = $data['items'] ?? null;

unset( $data['items'] );

global $wpdb;

// Start transaction.

$wpdb->query( 'START TRANSACTION' );

try {

$order_id = QueryHelper::insert( $this->table_name, $data );

if ( $order_id ) {

if ( $order_items ) {

$insert = $this->insert_order_items( $order_id, $order_items );

if ( $insert ) {

$wpdb->query( 'COMMIT' );

return $order_id;

} else {

$wpdb->query( 'ROLLBACK' );

throw new \Exception( __( 'Failed to insert order items', 'tutor' ) );

}

} else {

$wpdb->query( 'COMMIT' );

return $order_id;

}

}

} catch ( \Throwable $th ) {

throw new \Exception( $th->getMessage() );

}

}

/**

public function insert_order_items( int $order_id, array $items ): bool {

// Check if item is multi dimensional.

if ( ! isset( $items[0] ) ) {

$items = array( $items );

}

// Set order id on each item.

foreach ( $items as $item ) {

$item['order_id'] = $order_id;

$meta_data = $item['meta_data'] ?? null;

try {

unset( $item['meta_data'] );

$insert = QueryHelper::insert(

$this->order_item_table,

$item,

);

if ( $insert ) {

if ( ! empty( $meta_data ) ) {

foreach ( $meta_data as $meta ) {

( new OrderItemMetaModel() )->add_meta( $insert, $meta['meta_key'], maybe_serialize( $meta['meta_value'] ) );

}

}

}

} catch ( \Throwable $th ) {

return false;

}

}

return true;

}

/**

public function get_order_by_id( $order_id ) {

$order_data = QueryHelper::get_row(

$this->table_name,

array( 'id' => $order_id ),

'id'

);

if ( ! $order_data ) {

return false;

}

$user_info = get_userdata( $order_data->user_id );

$student = new \stdClass();

$student->id = (int) $user_info->ID ?? 0;

$student->name = $user_info->data->display_name ?? '';

$student->email = $user_info->data->user_email ?? '';

$student->phone = get_user_meta( $order_data->user_id, 'phone_number', true );

$student->billing_address = $this->get_order_billing_address( $order_id, $order_data->user_id );

$student->image = get_avatar_url( $order_data->user_id );

$order_data->student = $student;

$order_data->items = $this->get_order_items_by_id( $order_id );

$order_data->subtotal_price = (float) $order_data->subtotal_price;

$order_data->total_price = (float) $order_data->total_price;

$order_data->net_payment = (float) $order_data->net_payment;

$order_data->discount_amount = (float) $order_data->discount_amount;

$order_data->coupon_amount = (float) $order_data->coupon_amount;

$order_data->tax_rate = (float) $order_data->tax_rate;

$order_data->tax_amount = (float) $order_data->tax_amount;

$order_data->payment_method_readable = Ecommerce::get_payment_method_label( $order_data->payment_method );

$order_data->created_at_readable = DateTimeHelper::get_gmt_to_user_timezone_date( $order_data->created_at_gmt );

$order_data->updated_at_readable = empty( $order_data->updated_at_gmt ) ? '' : DateTimeHelper::get_gmt_to_user_timezone_date( $order_data->updated_at_gmt );

$order_data->created_by = get_userdata( $order_data->created_by )->display_name ?? '';

$order_data->updated_by = get_userdata( $order_data->updated_by )->display_name ?? '';

$order_activities_model = new OrderActivitiesModel();

$order_data->activities = $order_activities_model->get_order_activities( $order_id );

$order_data->refunds = $this->get_order_refunds( $order_id );

$enrollment_ids = $this->get_enrollment_ids( $order_id );

if ( tutor_utils()->count( $enrollment_ids ) ) {

$order_data->enrollment = EnrollmentModel::get_enrolment_by_enrol_id( $enrollment_ids[0] );

}

unset( $student->billing_address->id );

unset( $student->billing_address->user_id );

return apply_filters( 'tutor_order_details', $order_data );

}

/**

public static function get_order( $order ) {

if ( is_numeric( $order ) ) {

$order = ( new self() )->get_order_by_id( $order );

}

return $order;

}

/**

public static function is_subscription_order( $order ) {

$order = self::get_order( $order );

return $order && self::TYPE_SUBSCRIPTION === $order->order_type;

}

/**

public static function is_single_order( $order ) {

$order = self::get_order( $order );

return $order && self::TYPE_SINGLE_ORDER === $order->order_type;

}

/**

public function mark_as_paid( $order_id, $note = '', $trigger_hooks = true ) {

if ( $trigger_hooks ) {

do_action( 'tutor_before_order_mark_as_paid', $order_id );

}

$data = array(

'payment_status' => self::PAYMENT_PAID,

'order_status' => self::ORDER_COMPLETED,

'note' => $note,

);

$response = $this->update_order( $order_id, $data );

if ( ! $response ) {

return false;

}

if ( $trigger_hooks ) {

do_action( 'tutor_order_payment_status_changed', $order_id, self::PAYMENT_UNPAID, self::PAYMENT_PAID );

$order = $this->get_order_by_id( $order_id );

$discount_amount = $this->calculate_discount_amount( $order->discount_type, $order->discount_amount, $order->subtotal_price );

do_action( 'tutor_after_order_mark_as_paid', $order, $discount_amount );

}

return true;

}

/**

public function get_order_items_by_id( $order_id ) {

$cache_key = 'tutor_get_order_items_by_id_' . $order_id;

$cached = TutorCache::get( $cache_key );

if ( $cached ) {

return $cached;

}

$primary_table = 'tutor_order_items AS oi';

$joining_tables = array(

array(

'type' => 'LEFT',

'table' => 'posts AS p',

'on' => 'p.ID = oi.item_id',

),

);

$where = array( 'order_id' => $order_id );

$select_columns = array( 'oi.id AS primary_id', 'oi.item_id AS id', 'oi.regular_price', 'oi.sale_price', 'oi.discount_price', 'oi.coupon_code', 'p.post_title AS title', 'p.post_type AS type' );

$courses_data = QueryHelper::get_joined_data( $primary_table, $joining_tables, $select_columns, $where, array(), 'id', 0, 0 );

$courses = $courses_data['results'];

$bundle_model = tutor()->has_pro ? new \TutorPro\CourseBundle\Models\BundleModel() : null;

if ( ! empty( $courses_data['total_count'] ) ) {

foreach ( $courses as &$course ) {

if ( is_object( $bundle_model ) && tutor()->bundle_post_type === $course->type ) {

$course->total_courses = count( $bundle_model->get_bundle_course_ids( $course->id ) );

}

$course->id = (int) $course->id;

$course->regular_price = (float) $course->regular_price;

$course->image = get_the_post_thumbnail_url( $course->id );

// Add meta items.

$order_item_meta = new OrderItemMetaModel();

$course->item_meta_list = apply_filters( 'tutor_order_item_meta', $order_item_meta->get_meta( $course->primary_id, null, false ) );

}

}

unset( $course );

$result = ! empty( $courses ) ? $courses : array();

TutorCache::set( $cache_key, $result );

return $result;

}

/**

public static function get_order_billing_address( $order_id, $user_id ) {

$billing_address = OrderMetaModel::get_meta_value( $order_id, self::META_KEY_BILLING_ADDRESS, true );

/**

if ( false === $billing_address ) {

$billing_address = ( new BillingController( false ) )->get_billing_info( $user_id );

} else {

$billing_address = json_decode( $billing_address );

}

$data = (object) array(

'first_name' => $billing_address->billing_first_name ?? '',

'last_name' => $billing_address->billing_last_name ?? '',

'full_name' => trim( ( $billing_address->billing_first_name ?? '' ) . ' ' . ( $billing_address->billing_last_name ?? '' ) ),

'email' => $billing_address->billing_email ?? '',

'phone' => $billing_address->billing_phone ?? '',

'address' => $billing_address->billing_address ?? '',

'country' => $billing_address->billing_country ?? '',

'state' => $billing_address->billing_state ?? '',

'city' => $billing_address->billing_city ?? '',

'zip_code' => $billing_address->billing_zip_code ?? '',

);

return $data;

}

/**

public function get_order_refunds( $order_id ) {

global $wpdb;

$meta_keys = array(

OrderActivitiesModel::META_KEY_REFUND,

OrderActivitiesModel::META_KEY_PARTIALLY_REFUND,

);

// Retrieve order refunds for the given order ID from the 'tutor_ordermeta' table.

$order_refunds = QueryHelper::get_all(

"{$wpdb->prefix}tutor_ordermeta",

array(

'order_id' => $order_id,

'meta_key' => $meta_keys,

),

'created_at_gmt',

1000,

'ASC'

);

if ( empty( $order_refunds ) ) {

return array();

}

$response = array();

foreach ( $order_refunds as $refund ) {

$parsed_meta_value = json_decode( $refund->meta_value );

$values = new \stdClass();

$values->id = (int) $refund->id;

foreach ( $parsed_meta_value as $key => $value ) {

$values->$key = $value;

}

$values->date = $refund->created_at_gmt;

$response[] = $values;

}

// Custom comparison function for sorting by date.

usort(

$response,

function ( $a, $b ) {

$date_a = strtotime( $a->date );

$date_b = strtotime( $b->date );

return $date_b - $date_a;

}

);

return $response;

}

/**

public function update_order( $order_id, array $data, array $order_items = array() ) {

$order_id = is_array( $order_id ) ? $order_id : array( $order_id );

$order_id = QueryHelper::prepare_in_clause( $order_id );

try {

QueryHelper::update_where_in(

$this->table_name,

$data,

$order_id

);

if ( ! empty( $order_items ) ) {

$this->update_order_items( $order_id, $order_items );

}

return true;

} catch ( \Throwable $th ) {

error_log( $th->getMessage() . ' in ' . $th->getFile() . ' at line ' . $th->getLine() );

return false;

}

}

/**

public function get_enrollment_ids( $order_id ) {

global $wpdb;

$enrollment_ids = array();

$enrollments = $wpdb->get_results(

$wpdb->prepare(

"SELECT * FROM {$wpdb->postmeta}

AND meta_value LIKE %d",

EnrollmentModel::ENROLLMENT_ORDER_ID_META,

$order_id

)

);

if ( $enrollments ) {

$enrollment_ids = array_column( $enrollments, 'post_id' );

}

return $enrollment_ids;

}

/**

public function delete_order( $order_id ) {

global $wpdb;

$order_ids = is_array( $order_id ) ? $order_id : array( intval( $order_id ) );

try {

$wpdb->query( 'START TRANSACTION' );

foreach ( $order_ids as $order_id ) {

// Delete enrollments if exist.

$enrollment_ids = $this->get_enrollment_ids( $order_id );

if ( $enrollment_ids ) {

QueryHelper::bulk_delete_by_ids( $wpdb->posts, $enrollment_ids );

// After enrollment delete, delete the course progress.

foreach ( $enrollment_ids as $enrollment_id ) {

$course_id = get_post_field( 'post_parent', $enrollment_id );

$student_id = get_post_field( 'post_author', $enrollment_id );

if ( $course_id && $student_id ) {

tutor_utils()->delete_course_progress( $course_id, $student_id );

}

}

}

// Delete earnings.

QueryHelper::delete(

$wpdb->prefix . 'tutor_earnings',

array(

'order_id' => $order_id,

'process_by' => Earnings::PROCESS_BY_TUTOR,

)

);

// Now delete order.

QueryHelper::delete( $this->table_name, array( 'id' => $order_id ) );

}

$wpdb->query( 'COMMIT' );

return true;

} catch ( \Throwable $th ) {

$wpdb->query( 'ROLLBACK' );

return false;

}

}

/**

public function get_orders( array $where = array(), $search_term = '', int $limit = 10, int $offset = 0, string $order_by = 'o.id', string $order = 'desc' ) {

global $wpdb;

$primary_table = "{$this->table_name} o";

$joining_tables = array(

array(

'type' => 'LEFT',

'table' => "{$wpdb->users} u",

'on' => 'o.user_id = u.ID',

),

);

$select_columns = array( 'o.*', 'u.user_login' );

$search_clause = array();

if ( '' !== $search_term ) {

foreach ( $this->get_searchable_fields() as $column ) {

$search_clause[ $column ] = $search_term;

}

}

$response = array(

'results' => array(),

'total_count' => 0,

);

try {

return QueryHelper::get_joined_data( $primary_table, $joining_tables, $select_columns, $where, $search_clause, $order_by, $limit, $offset, $order );

} catch ( \Throwable $th ) {

// Log with error, line & file name.

error_log( $th->getMessage() . ' in ' . $th->getFile() . ' at line ' . $th->getLine() );

return $response;

}

}

/**

public function get_order_count( $where = array(), string $search_term = '' ) {

global $wpdb;

$search_clause = array();

if ( '' !== $search_term ) {

foreach ( $this->get_searchable_fields() as $column ) {

$search_clause[ $column ] = $search_term;

}

}

$join_table = array(

array(

'type' => 'INNER',

'table' => "{$wpdb->users} u",

'on' => 'o.user_id = u.ID',