/**

const STATUS_ACTIVE = 'active';

const STATUS_INACTIVE = 'inactive';

const STATUS_TRASH = 'trash';

const STATUS_EXPIRED = 'expired';

const STATUS_SCHEDULED = 'scheduled';

/**

const TYPE_CODE = 'code';

const TYPE_AUTOMATIC = 'automatic';

/**

const APPLIES_TO_ALL_COURSES_AND_BUNDLES = 'all_courses_and_bundles';

const APPLIES_TO_ALL_COURSES = 'all_courses';

const APPLIES_TO_ALL_BUNDLES = 'all_bundles';

const APPLIES_TO_SPECIFIC_COURSES = 'specific_courses';

const APPLIES_TO_SPECIFIC_BUNDLES = 'specific_bundles';

const APPLIES_TO_SPECIFIC_CATEGORY = 'specific_category';

const APPLIES_TO_ALL_MEMBERSHIP_PLANS = 'all_membership_plans';

const APPLIES_TO_SPECIFIC_MEMBERSHIP_PLANS = 'specific_membership_plans';

/**

const REQUIREMENT_NO_MINIMUM = 'no_minimum';

const REQUIREMENT_MINIMUM_PURCHASE = 'minimum_purchase';

const REQUIREMENT_MINIMUM_QUANTITY = 'minimum_quantity';

/**

const DISCOUNT_TYPE_FLAT = 'flat';

const DISCOUNT_TYPE_PERCENTAGE = 'percentage';

/**

private $table_name = 'tutor_coupons';

/**

private $coupon_usage_table = 'tutor_coupon_usages';

/**

private $coupon_applies_to_table = 'tutor_coupon_applications';

/**

private $fillable_fields = array(

'coupon_status',

'coupon_type',

'coupon_code',

'coupon_title',

'coupon_description',

'discount_type',

'discount_amount',

'applies_to',

'applies_to_items',

'total_usage_limit',

'per_user_usage_limit',

'purchase_requirement',

'purchase_requirement_value',

'start_date_gmt',

'expire_date_gmt',

);

/**

private $required_fields = array(

'coupon_status',

'coupon_type',

'coupon_title',

'discount_type',

'discount_amount',

'applies_to',

'start_date_gmt',

);

/**

public function __construct() {

global $wpdb;

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

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

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

}

/**

public function get_table_name() {

return $this->table_name;

}

/**

public function get_fillable_fields() {

return $this->fillable_fields;

}

/**

public function get_required_fields() {

return $this->required_fields;

}

/**

public static function get_coupon_status() {

return array(

self::STATUS_ACTIVE => __( 'Active', 'tutor' ),

self::STATUS_INACTIVE => __( 'Inactive', 'tutor' ),

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

self::STATUS_EXPIRED => __( 'Expired', 'tutor' ),

self::STATUS_SCHEDULED => __( 'Scheduled', 'tutor' ),

);

}

/**

public static function get_course_bundle_applies_to( $only_keys = false ) {

$list = array(

self::APPLIES_TO_ALL_COURSES_AND_BUNDLES => __( 'All courses and bundles', 'tutor' ),

self::APPLIES_TO_ALL_COURSES => __( 'All courses', 'tutor' ),

self::APPLIES_TO_ALL_BUNDLES => __( 'All bundles', 'tutor' ),

self::APPLIES_TO_SPECIFIC_COURSES => __( 'Specific courses', 'tutor' ),

self::APPLIES_TO_SPECIFIC_BUNDLES => __( 'Specific bundles', 'tutor' ),

self::APPLIES_TO_SPECIFIC_CATEGORY => __( 'Specific category', 'tutor' ),

);

return $only_keys ? array_keys( $list ) : $list;

}

/**

public static function get_coupon_applies_to( $only_keys = false ) {

$list = self::get_course_bundle_applies_to();

$list = apply_filters( 'tutor_coupon_applies_to', $list );

return $only_keys ? array_keys( $list ) : $list;

}

/**

public static function get_coupon_applies_to_label( $key ) {

$applies_to = self::get_coupon_applies_to();

return isset( $applies_to[ $key ] ) ? $applies_to[ $key ] : '';

}

/**

public static function get_coupon_purchase_requirements() {

return array(

self::REQUIREMENT_NO_MINIMUM => __( 'no_minimum', 'tutor' ),

self::REQUIREMENT_MINIMUM_PURCHASE => __( 'minimum_purchase', 'tutor' ),

self::REQUIREMENT_MINIMUM_QUANTITY => __( 'minimum_quantity', 'tutor' ),

);

}

/**

public static function get_coupon_type() {

return array(

self::TYPE_CODE => __( 'Code', 'tutor' ),

self::TYPE_AUTOMATIC => __( 'Automatic', 'tutor' ),

);

}

/**

private function get_searchable_fields() {

return array(

'id',

'coupon_status',

'coupon_code',

'coupon_title',

);

}

/**

public function create_coupon( array $data ) {

try {

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

} catch ( \Throwable $th ) {

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

}

}

/**

public function insert_applies_to( string $applies_to, array $applies_to_ids, $coupon_code ) {

$specific_applies = array(

self::APPLIES_TO_SPECIFIC_BUNDLES,

self::APPLIES_TO_SPECIFIC_COURSES,

self::APPLIES_TO_SPECIFIC_CATEGORY,

self::APPLIES_TO_SPECIFIC_MEMBERSHIP_PLANS,

);

if ( in_array( $applies_to, $specific_applies, true ) ) {

$data = array();

foreach ( $applies_to_ids as $id ) {

$data[] = array(

'coupon_code' => $coupon_code,

'reference_id' => $id,

);

}

if ( count( $data ) ) {

return QueryHelper::insert_multiple_rows( $this->coupon_applies_to_table, $data );

}

}

}

/**

public function delete_applies_to( $coupon_code ) {

return QueryHelper::delete( $this->coupon_applies_to_table, array( 'coupon_code' => $coupon_code ) );

}

/**

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

$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 {

$response = QueryHelper::get_all_with_search( $this->table_name, $where, $search_clause, $order_by, $limit, $offset, $order );

// Add coupon usage count.

foreach ( $response['results'] as $result ) {

$result->usage_count = $this->get_coupon_usage_count( $result->coupon_code );

}

return $response;

} catch ( \Throwable $th ) {

// Log with error, line & file name.

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

return $response;

}

}

/**

public function update_coupon( $coupon_id, array $data ) {

$coupon_ids = is_array( $coupon_id ) ? $coupon_id : array( $coupon_id );

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

try {

QueryHelper::update_where_in(

$this->table_name,

$data,

$coupon_ids

);

return true;

} catch ( \Throwable $th ) {

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

return false;

}

}

/**

public function delete_coupon( $coupon_id ) {

$coupon_ids = is_array( $coupon_id ) ? $coupon_id : array( $coupon_id );

try {

QueryHelper::bulk_delete_by_ids(

$this->table_name,

$coupon_ids

);

return true;

} catch ( \Throwable $th ) {

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

return false;

}

}

/**

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

$search_clause = array();

if ( '' !== $search_term ) {

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

$search_clause[ $column ] = $search_term;

}

}

return QueryHelper::get_count( $this->table_name, $where, $search_clause, '*' );

}

/**

public function get_coupon_usage_count( $coupon_code ) {

return QueryHelper::get_count(

$this->coupon_usage_table,

array( 'coupon_code' => $coupon_code ),

array(),

'*'

);

}

/**

public function get_user_usage_count( $coupon_code, $user_id ) {

return QueryHelper::get_count(

$this->coupon_usage_table,

array(

'coupon_code' => $coupon_code,

'user_id' => $user_id,

),

array(),

'*'

);

}

/**

public function get_coupon_by_id( $coupon_id ) {

$coupon_data = QueryHelper::get_row(

$this->table_name,

array( 'id' => $coupon_id ),

'id'

);

if ( ! $coupon_data ) {

return false;

}

return $this->process_coupon_data( $coupon_data );

}

/**

public function get_coupon_by_code( $coupon_code ) {

$coupon_data = QueryHelper::get_row(

$this->table_name,

array( 'coupon_code' => $coupon_code ),

'id'

);

if ( ! $coupon_data ) {

return false;

}

return $this->process_coupon_data( $coupon_data );

}

/**

public function get_automatic_coupons() {

$coupons = $this->get_coupons(

array(

'coupon_type' => self::TYPE_AUTOMATIC,

'coupon_status' => self::STATUS_ACTIVE,

),

'',

1000,

0

);

if ( empty( $coupons['results'] ) ) {

return array();

}

return $coupons['results'];

}

/**

private function process_coupon_data( $coupon_data ) {

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

$coupon_data->usage_limit_status = ! empty( $coupon_data->total_usage_limit ) ? true : false;

$coupon_data->total_usage_limit = (int) $coupon_data->total_usage_limit;

$coupon_data->is_one_use_per_user = ! empty( $coupon_data->per_user_usage_limit ) ? true : false;

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

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

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

$coupon_data->courses = array();

$coupon_data->categories = array();

if ( 'specific_courses' === $coupon_data->applies_to || 'specific_bundles' === $coupon_data->applies_to ) {

$coupon_data->courses = $this->get_coupon_courses_by_code( $coupon_data->coupon_code );

}

if ( 'specific_category' === $coupon_data->applies_to ) {

$coupon_data->categories = $this->get_coupon_categories_by_code( $coupon_data->coupon_code );

}

return $coupon_data;

}

/**

public function get_coupon_courses_by_code( $coupon_code ) {

global $wpdb;

$primary_table = "{$wpdb->prefix}tutor_coupon_applications AS ca";

$joining_tables = array(

array(

'type' => 'LEFT',

'table' => "{$wpdb->prefix}posts AS p",

'on' => 'p.ID = ca.reference_id',

),

);

$where = array( 'ca.coupon_code' => $coupon_code );

$select_columns = array( 'ca.reference_id AS id', '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'];

if ( tutor()->has_pro ) {

$bundle_model = new \TutorPro\CourseBundle\Models\BundleModel();

}

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

foreach ( $courses as &$course ) {

if ( tutor()->has_pro && 'course-bundle' === $course->type ) {

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

}

$course_prices = tutor_utils()->get_raw_course_price( $course->id );

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

$course->price = $course_prices->regular_price;

$course->sale_price = $course_prices->sale_price;

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

}

}

unset( $course );

return ! empty( $courses ) ? $courses : array();

}

/**

public function get_coupon_categories_by_code( $coupon_code ) {

global $wpdb;

$table = "{$wpdb->prefix}tutor_coupon_applications";

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

$categories = QueryHelper::get_all( $table, $where, 'reference_id' );

$response = array();

foreach ( $categories as $category ) {

$category_data = get_term_by( 'id', $category->reference_id, 'course-category' );

if ( $category_data ) {

// Fetch the thumbnail_id from the wp_termmeta table.

$thumbnail_id = get_term_meta( $category_data->term_id, 'thumbnail_id', true );

// If the thumbnail ID is retrieved, get the image URL.

if ( $thumbnail_id ) {

$image = wp_get_attachment_url( $thumbnail_id );

} else {

$image = ''; // Or set a default image URL if needed.

}

$final_data = new \stdClass();

$final_data->id = $category_data->term_id;

$final_data->title = $category_data->name;

$final_data->number_of_courses = $category_data->count;

$final_data->image = $image;

$response[] = $final_data;

}

}

return $response;

}

/**

public function get_coupon( array $where ) {

return QueryHelper::get_row(

$this->table_name,

$where,

'id'

);

}

/**

private function get_automatic_coupon_for_checkout() {

$args = array(

'coupon_type' => self::TYPE_AUTOMATIC,

'coupon_status' => self::STATUS_ACTIVE,

'applies_to' => $this->get_course_bundle_applies_to( true ),

);

$args = apply_filters( 'tutor_automatic_coupon_args_for_checkout', $args );

return $this->get_coupon( $args );

}

/**

public function get_coupon_details_for_checkout( $coupon_code = '' ) {

$coupon = null;

if ( empty( $coupon_code ) ) {

$coupon = $this->get_automatic_coupon_for_checkout();

} else {

$coupon = $this->get_coupon(

array(

'coupon_code' => $coupon_code,

'coupon_status' => self::STATUS_ACTIVE,

)

);

}

return $coupon;

}

/**

public function deduct_coupon_discount( $regular_price, $discount_type, $discount_value ) {

$deducted_price = $regular_price;

if ( self::DISCOUNT_TYPE_PERCENTAGE === $discount_type ) {

$deducted_price = $regular_price - ( $regular_price * ( $discount_value / 100 ) );

} else {

$deducted_price = $regular_price - $discount_value;

}

return tutor_get_locale_price( max( 0, $deducted_price ) );

}

/**

public static function set_apply_coupon_error( $error ) {

global $tutor_coupon_apply_err_msg;

$tutor_coupon_apply_err_msg = $error;

}

/**

public function is_coupon_valid( object $coupon ): bool {

if ( self::STATUS_INACTIVE === $coupon->coupon_status || self::STATUS_TRASH === $coupon->coupon_status ) {

self::set_apply_coupon_error( $this->get_coupon_failed_error_msg( 'invalid' ) );

return false;

}

return self::STATUS_ACTIVE === $coupon->coupon_status && $this->has_coupon_validity( $coupon ) && $this->has_user_usage_limit( $coupon, get_current_user_id() );

}

/**

public function is_coupon_applicable( object $coupon, int $object_id, string $order_type ): bool {

$is_applicable = false;

$is_membership_plan = false;

if ( OrderModel::TYPE_SUBSCRIPTION === $order_type ) {

$plan_info = apply_filters( 'tutor_get_plan_info', null, $object_id );

$is_membership_plan = $plan_info && isset( $plan_info->is_membership_plan ) && $plan_info->is_membership_plan;

if ( ! $is_membership_plan ) {

$object_id = apply_filters( 'tutor_subscription_course_by_plan', $object_id );

}

}

$course_post_type = tutor()->course_post_type;

$bundle_post_type = 'course-bundle';

$object_type = get_post_type( $object_id );

$applies_to = $coupon->applies_to;

$applications = $this->get_coupon_applications( $coupon->coupon_code );

/**

if ( OrderModel::TYPE_SINGLE_ORDER === $order_type || ( OrderModel::TYPE_SUBSCRIPTION === $order_type && ! $is_membership_plan ) ) {

switch ( $applies_to ) {

case self::APPLIES_TO_ALL_COURSES_AND_BUNDLES:

$is_applicable = true;

break;

case self::APPLIES_TO_ALL_COURSES:

case self::APPLIES_TO_SPECIFIC_COURSES:

if ( self::APPLIES_TO_ALL_COURSES === $applies_to ) {

$is_applicable = $object_type === $course_post_type;

} else {

$is_applicable = in_array( $object_id, $applications );

}

break;

case self::APPLIES_TO_ALL_BUNDLES:

case self::APPLIES_TO_SPECIFIC_BUNDLES:

if ( self::APPLIES_TO_ALL_BUNDLES === $applies_to ) {

$is_applicable = $object_type === $bundle_post_type;

} else {

$is_applicable = in_array( $object_id, $applications );

}

break;

case self::APPLIES_TO_SPECIFIC_CATEGORY:

$course_categories = wp_get_post_terms( $object_id, CourseModel::COURSE_CATEGORY );

if ( ! is_wp_error( $course_categories ) ) {

$term_ids = array_column( $course_categories, 'term_id' );

$is_applicable = count( array_intersect( $applications, $term_ids ) );

}

break;

}

}

if ( ! $is_applicable ) {

self::set_apply_coupon_error( $this->get_coupon_failed_error_msg( 'specific_applicable', str_replace( '_', ' ', $applies_to ) ) );

}

return apply_filters( 'tutor_coupon_is_applicable', $is_applicable, $coupon, $object_id, $applications, $is_membership_plan );

}

/**

public function is_coupon_requirement_meet( $item_id, object $coupon, $order_type = OrderModel::TYPE_SINGLE_ORDER ) {

$is_meet_requirement = true;

$item_ids = is_array( $item_id ) ? $item_id : array( $item_id );

$total_price = 0;

$min_amount = $coupon->purchase_requirement_value;

$regular_price_item_count = 0;

foreach ( $item_ids as $item_id ) {

$course_price = tutor_utils()->get_raw_course_price( $item_id );

if ( OrderModel::TYPE_SINGLE_ORDER !== $order_type ) {

$plan_info = apply_filters( 'tutor_get_plan_info', null, $item_id );

if ( $plan_info ) {

$course_price->regular_price = $plan_info->regular_price;

$course_price->sale_price = $plan_info->in_sale_price ? $plan_info->sale_price : 0;

}

}

$total_price += $course_price->sale_price ? $course_price->sale_price : $course_price->regular_price;

if ( ! $course_price->sale_price ) {

$regular_price_item_count++;

}

}

if ( self::REQUIREMENT_MINIMUM_QUANTITY === $coupon->purchase_requirement ) {

$min_quantity = $coupon->purchase_requirement_value;

$is_meet_requirement = count( $item_ids ) >= $min_quantity;

if ( ! $is_meet_requirement ) {

self::set_apply_coupon_error( $this->get_coupon_failed_error_msg( 'minimum_quantity', $min_quantity ) );

}

} elseif ( self::REQUIREMENT_MINIMUM_PURCHASE === $coupon->purchase_requirement && $total_price < $min_amount ) {

$is_meet_requirement = false;