<?php
/**
 * Get a package
 *
 * @param  stdClass $package
 * @return WC_Paid_Listings_Package
 */
function wc_paid_listings_get_package( $package ) {
	return new WC_Paid_Listings_Package( $package );
}

/**
 * Approve a listing
 *
 * @param  int $listing_id
 * @param  int $user_id
 * @param  int $user_package_id
 * @param  int $package_id
 * @return void
 */
function wc_paid_listings_approve_listing_with_package( $listing_id, $user_id, $user_package_id, $package_id = null ) {
	if ( wc_paid_listings_package_is_valid( $user_id, $user_package_id ) ) {
		$resumed_post_status = get_post_meta( $listing_id, '_post_status_before_package_pause', true );
		if ( ! empty( $resumed_post_status ) ) {
			$listing = array(
				'ID'          => $listing_id,
				'post_status' => $resumed_post_status,
			);
			delete_post_meta( $listing_id, '_post_status_before_package_pause' );
		} else {
			$listing = array(
				'ID' => $listing_id,
			);

			if ( 'job_listing' === get_post_type( $listing_id ) ) {
				if ( ! class_exists( 'WP_Job_Manager_Form' ) ) {
					include_once JOB_MANAGER_PLUGIN_DIR . '/includes/abstracts/abstract-wp-job-manager-form.php';
					include_once JOB_MANAGER_PLUGIN_DIR . '/includes/forms/class-wp-job-manager-form-submit-job.php';
				}

				if ( method_exists( 'WP_Job_Manager_Form_Submit_Job', 'apply_scheduled_date' ) ) {
					$job_schedule_listing_date = get_post_meta( $listing_id, '_job_schedule_listing', true );
					WP_Job_Manager_Form_Submit_Job::apply_scheduled_date( $listing, $job_schedule_listing_date );
				} else {
					$listing['post_date']     = current_time( 'mysql' );
					$listing['post_date_gmt'] = current_time( 'mysql', 1 );
				}

				$listing['post_status'] = get_option( 'job_manager_submission_requires_approval' ) ? 'pending' : 'publish';
				delete_post_meta( $listing_id, '_job_expires' );
			} elseif ( 'resume' === get_post_type( $listing_id ) ) {
				$listing['post_status'] = get_option( 'resume_manager_submission_requires_approval' ) ? 'pending' : 'publish';
			}
		}

		update_post_meta( $listing_id, '_user_package_id', $user_package_id );

		if ( null !== $package_id ) {
			update_post_meta( $listing_id, '_package_id', $package_id );
		}

		wp_update_post( $listing );

		/**
		 * Checks to see whether or not a particular job listing affects the package count.
		 *
		 * @since 2.7.3
		 *
		 * @param bool $job_listing_affects_package_count True if it affects package count.
		 * @param int  $listing_id                        Post ID.
		 */
		if ( apply_filters( 'job_manager_job_listing_affects_package_count', true, $listing_id ) ) {
			wc_paid_listings_increase_package_count( $user_id, $user_package_id );
		}
	}
}

/**
 * Approve a job listing
 *
 * @param  int $job_id
 * @param  int $user_id
 * @param  int $user_package_id
 * @return void
 */
function wc_paid_listings_approve_job_listing_with_package( $job_id, $user_id, $user_package_id ) {
	wc_paid_listings_approve_listing_with_package( $job_id, $user_id, $user_package_id );
}

/**
 * Approve a resume
 *
 * @param  int $resume_id
 * @param  int $user_id
 * @param  int $user_package_id
 * @return void
 */
function wc_paid_listings_approve_resume_with_package( $resume_id, $user_id, $user_package_id ) {
	wc_paid_listings_approve_listing_with_package( $resume_id, $user_id, $user_package_id );
}

/**
 * See if a package is valid for use
 *
 * @param int $user_id
 * @param int $package_id
 * @return bool
 */
function wc_paid_listings_package_is_valid( $user_id, $package_id ) {
	global $wpdb;

	$package = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}wcpl_user_packages WHERE user_id = %d AND id = %d;", $user_id, $package_id ) );

	if ( ! $package ) {
		return false;
	}

	if ( $package->package_count >= $package->package_limit && $package->package_limit != 0 ) {
		return false;
	}

	return true;
}

/**
 * Increase job count for package
 *
 * @param  int $user_id
 * @param  int $package_id
 * @return int affected rows
 */
function wc_paid_listings_increase_package_count( $user_id, $package_id ) {
	global $wpdb;

	$packages = wc_paid_listings_get_user_packages( $user_id, '', true );

	if ( isset( $packages[ $package_id ] ) ) {
		$new_count = $packages[ $package_id ]->package_count + 1;
	} else {
		$new_count = 1;
	}

	return $wpdb->update(
		"{$wpdb->prefix}wcpl_user_packages",
		array(
			'package_count' => $new_count,
		),
		array(
			'user_id' => $user_id,
			'id'      => $package_id,
		),
		array( '%d' ),
		array( '%d', '%d' )
	);
}

/**
 * Decrease job count for package
 *
 * @param  int $user_id
 * @param  int $package_id
 * @return int affected rows
 */
function wc_paid_listings_decrease_package_count( $user_id, $package_id ) {
	global $wpdb;

	$packages = wc_paid_listings_get_user_packages( $user_id, '', true );

	if ( isset( $packages[ $package_id ] ) ) {
		$new_count = $packages[ $package_id ]->package_count - 1;
	} else {
		$new_count = 0;
	}

	return $wpdb->update(
		"{$wpdb->prefix}wcpl_user_packages",
		array(
			'package_count' => max( 0, $new_count ),
		),
		array(
			'user_id' => $user_id,
			'id'      => $package_id,
		),
		array( '%d' ),
		array( '%d', '%d' )
	);
}

/**
 * Renew paid listings.
 *
 * @param int  $product_id Product ID that was bought for this renewal.
 * @param int  $user_package_id User package id.
 * @param int  $job_id Job listing ID.
 * @param bool $is_listing_subscription Whether the product is a subscription that is linked to the listing.
 *
 * @return void
 */
function wc_paid_listings_handle_listing_renewal( $product_id, $user_package_id, $job_id, $is_listing_subscription = false ) {
	if ( ! class_exists( 'WP_Job_Manager_Helper_Renewals' ) ) {
		return;
	}

	if ( $is_listing_subscription || WP_Job_Manager_Helper_Renewals::job_can_be_renewed( $job_id ) ) {
		WP_Job_Manager_Helper_Renewals::renew_job_listing( get_post( $job_id ) );

		update_post_meta( $job_id, '_user_package_id', $user_package_id );
		update_post_meta( $job_id, '_package_id', $product_id );
		delete_post_meta( $job_id, '_renewal_pending_product_id', $product_id );
		update_post_meta( $job_id, '_renewal_completed_product_id', $product_id );

		/**
		 * This filter is documented in wc_paid_listings_approve_listing_with_package.
		 */
		if ( apply_filters( 'job_manager_job_listing_affects_package_count', true, $job_id ) ) {
			wc_paid_listings_increase_package_count( get_current_user_id(), $user_package_id );
		}
	}
}