<?php
/**
 * Abandon Cart Lite AUtomated Reminder emails.
 *
 * It will send the automatic reminder emails to the customers.
 *
 * @author  Tyche Softwares
 * @package Abandoned-Cart-Lite-for-WooCommerce/Cron
 */

if ( ! class_exists( 'Wcal_Cron' ) ) {

	/**
	 * It will send the automatic reminder emails to the customers
	 *
	 * @since 1.3
	 */
	class Wcal_Cron {

		/**
		 * It will send the reminder emails to the cutomers.
		 * It will also replace the merge code to its original data.
		 * it will also check if guest id is valid, and check if the order is placed before sending the reminder email.
		 *
		 * @globals mixed $wpdb
		 * @globals mixed $woocommerce
		 * @since 1.3
		 */
		public function wcal_send_email_notification() {
			global $wpdb, $woocommerce;

			if ( 'on' === get_option( 'wcal_enable_cart_emails', '' ) ) {
				// Grab the cart abandoned cut-off time from database.
				$cart_settings = get_option( 'ac_lite_cart_abandoned_time', 10 );

				if ( '' === $cart_settings ) {
					$cart_settings = 10;
				}

				$cart_abandon_cut_off_time = $cart_settings * 60;
				// Fetch all active templates present in the system.
				$query        = "SELECT wpet . * FROM `" . $wpdb->prefix . "ac_email_templates_lite` AS wpet WHERE wpet.is_active = '1' ORDER BY `day_or_hour` DESC, `frequency` ASC"; // phpcs:ignore
				$results      = $wpdb->get_results( $query ); // phpcs:ignore
				$hour_seconds = 3600;   // 60 * 60
				$day_seconds  = 86400; // 24 * 60 * 60

				// Find the template which is last in the sequence.
				$last_email_template = wcal_common::wcal_get_last_email_template();
				if ( is_array( $last_email_template ) && count( $last_email_template ) > 0 ) {
					reset( $last_email_template );
					$last_template_id = key( $last_email_template );
				} else {
					$last_template_id = 0;
				}

				$utm = get_option( 'wcal_add_utm_to_links', '' );
				if ( '' !== $utm && strlen( $utm ) > 0 && '?' !== substr( $utm, 0, 1 ) ) {
					$utm = "?$utm";
				}

				$wcal_include_tax         = get_option( 'woocommerce_prices_include_tax', '' );
				$wcal_include_tax_setting = get_option( 'woocommerce_calc_taxes', '' );

				foreach ( $results as $key => $value ) {
					$wc_email_template = $value;
					if ( 'Minutes' === $value->day_or_hour ) {
						$time_to_send_template_after = intval( $value->frequency ) * 60;
					} elseif ( 'Days' === $value->day_or_hour ) {
						$time_to_send_template_after = intval( $value->frequency ) * $day_seconds;
					} elseif ( 'Hours' === $value->day_or_hour ) {
						$time_to_send_template_after = intval( $value->frequency ) * $hour_seconds;
					}

					if ( ! isset( $time_to_send_template_after ) ) {
						continue;
					}

					$carts = $this->wcal_get_carts( $time_to_send_template_after, $cart_abandon_cut_off_time, $value->id );

					$email_frequency        = $value->frequency;
					$email_body_template    = $value->body;
					$template_email_subject = stripslashes( $value->subject );
					$template_email_subject = convert_smilies( $template_email_subject );
					$wcal_from_name         = get_option( 'wcal_from_name' );
					$wcal_from_email        = get_option( 'wcal_from_email' );
					$wcal_reply_email       = get_option( 'wcal_reply_email' );
					if ( class_exists( 'WP_Better_Emails' ) ) {
						$headers  = 'From: ' . $wcal_from_name . ' <' . $wcal_from_email . '>' . "\r\n";
						$headers .= 'Content-Type: text/html' . "\r\n";
						$headers .= 'Reply-To:  ' . $wcal_reply_email . ' ' . "\r\n";
					} else {
						$headers  = 'From: ' . $wcal_from_name . ' <' . $wcal_from_email . '>' . "\r\n";
						$headers .= 'Content-Type: text/html' . "\r\n";
						$headers .= 'Reply-To:  ' . $wcal_reply_email . ' ' . "\r\n";
					}
					$template_id             = $value->id;
					$is_wc_template          = $value->is_wc_template;
					$wc_template_header_text = '' !== $value->wc_email_header ? $value->wc_email_header : __( 'Abandoned cart reminder', 'woocommerce-abandoned-cart' );
					$wc_template_header      = stripslashes( $wc_template_header_text );
					if ( '' !== $email_body_template ) {
						foreach ( $carts as $key => $value ) {

							$wcal_is_guest_id_correct = $this->wcal_get_is_guest_valid( $value->user_id, $value->user_type );
							if ( true === $wcal_is_guest_id_correct ) {

								if ( 'GUEST' === $value->user_type && $value->user_id > 0 ) {
									$value->user_login = '';

									$results_guest = $wpdb->get_results( // phpcs:ignore
										$wpdb->prepare(
											'SELECT billing_first_name, billing_last_name, email_id FROM `' . $wpdb->prefix . 'ac_guest_abandoned_cart_history_lite` WHERE id = %d',
											$value->user_id
										)
									);
									if ( count( $results_guest ) > 0 && isset( $results_guest[0]->email_id ) && '' !== $results_guest[0]->email_id ) {
										$value->user_email = $results_guest[0]->email_id;
									} else {
										continue;
									}
								} else {
									if ( isset( $value->user_id ) ) {
										$user_id = $value->user_id;
									}
									$key                = 'billing_email';
									$single             = true;
									$user_billing_email = get_user_meta( $user_id, $key, $single );
									if ( isset( $user_billing_email ) && '' !== $user_billing_email ) {
										$value->user_email = $user_billing_email;
									}
								}
								if ( isset( $value->abandoned_cart_info ) ) {
									$cart_info_db_field = json_decode( $value->abandoned_cart_info );
								}
								$cart = new stdClass();
								if ( ! empty( $cart_info_db_field->cart ) ) {
									$cart = $cart_info_db_field->cart;
								}
								if ( count( get_object_vars( $cart ) ) > 0 && isset( $value->user_id ) && $value->user_id > 0 && isset( $value->id ) ) {
									$cart_update_time = $value->abandoned_cart_time;
									$new_user         = $this->wcal_check_sent_history( $value->user_id, $cart_update_time, $template_id, $value->id );
									if ( true === $new_user ) {

										/**
										 * When there are 3 templates and for cart id 1 all template time has been reached. BUt all templates
										 * are deactivated.
										 * If we activate all 3 template then at a 1 time all 3 email templates send to the users.
										 * So below function check that after first email is sent time and then from that time it will send the
										 * 2nd template time.  ( It will not consider the cart abadoned time in this case. )
										 */
										$wcal_check_cart_needed_for_multiple_template = $this->wcal_remove_cart_for_mutiple_templates( $value->id, $time_to_send_template_after, $template_id );

										/**
										 * When we click on the place order button, we check if the order is placed after the
										 * cut off time. And if yes then if the status of the order is pending or falied then
										 * we keep it as the abandonoed and we need to send reminder emails. So in below function
										 * we first check if any order is placed with todays date then we do not send the
										 * reminder email. But what if placed order status is pending or falied? So this
										 * condition will not call that function andthe reminder email will be sent.
										 */

										// Check if any further orders have come from the user. If yes and the order status is Pending or Failed, email will be sent.
										$wcal_check_cart_status = self::wcal_get_cart_status( $time_to_send_template_after, $cart_update_time, $value->user_id, $value->user_type, $value->id, $value->user_email );

										if ( false === $wcal_check_cart_needed_for_multiple_template && (int) $template_id === (int) $last_template_id ) {
											$wpdb->update( // phpcs:ignore
												$wpdb->prefix . 'ac_abandoned_cart_history_lite',
												array(
													'email_reminder_status' => 'complete',
												),
												array(
													'id' => $value->id,
												)
											);
										}

										if ( false === $wcal_check_cart_needed_for_multiple_template && false === $wcal_check_cart_status ) {

											$cart_info_db          = $value->abandoned_cart_info;
											$email_subject         = $template_email_subject;
											$email_body            = $email_body_template;
											$wcal_check_cart_total = $this->wcal_check_cart_total( $cart, $value->id );
											if ( true === $wcal_check_cart_total ) {
												if ( 'GUEST' === $value->user_type ) {
													if ( isset( $results_guest[0]->billing_first_name ) ) {
														$email_body    = str_ireplace( '{{customer.firstname}}', apply_filters( 'wcal_abandoned_cart_email_content_customer.firstname', $results_guest[0]->billing_first_name, false, $value ), $email_body );
														$email_subject = str_ireplace( '{{customer.firstname}}', apply_filters( 'wcal_abandoned_cart_email_content_customer.firstname', $results_guest[0]->billing_first_name, false, $value ), $email_subject );
													}
													if ( isset( $results_guest[0]->billing_last_name ) ) {
														$email_body = str_ireplace( '{{customer.lastname}}', apply_filters( 'wcal_abandoned_cart_email_content_customer.lastname', $results_guest[0]->billing_last_name, false, $value ), $email_body );
													}
													if ( isset( $results_guest[0]->billing_first_name ) && isset( $results_guest[0]->billing_last_name ) ) {
														$email_body = str_ireplace( '{{customer.fullname}}', apply_filters( 'wcal_abandoned_cart_email_content_customer.fullname', $results_guest[0]->billing_first_name . ' ' . $results_guest[0]->billing_last_name, false, $value ), $email_body );
													} elseif ( isset( $results_guest[0]->billing_first_name ) ) {
														$email_body = str_ireplace( '{{customer.fullname}}', apply_filters( 'wcal_abandoned_cart_email_content_customer.fullname', $results_guest[0]->billing_first_name, false, $value ), $email_body );
													} elseif ( isset( $results_guest[0]->billing_last_name ) ) {
														$email_body = str_ireplace( '{{customer.fullname}}', apply_filters( 'wcal_abandoned_cart_email_content_customer.fullname', $results_guest[0]->billing_last_name, false, $value ), $email_body );
													}
												} else {
													$user_first_name      = '';
													$user_first_name_temp = get_user_meta( $value->user_id, 'billing_first_name', true );
													if ( isset( $user_first_name_temp ) && '' === $user_first_name_temp ) {
														$user_data = get_userdata( $user_id );
														if ( isset( $user_data->first_name ) ) {
															$user_first_name = $user_data->first_name;
														} else {
															$user_first_name = '';
														}
													} else {
														$user_first_name = $user_first_name_temp;
													}
													$email_body          = str_ireplace( '{{customer.firstname}}', apply_filters( 'wcal_abandoned_cart_email_content_customer.firstname', $user_first_name, false, $value ), $email_body );
													$email_subject       = str_ireplace( '{{customer.firstname}}', apply_filters( 'wcal_abandoned_cart_email_content_customer.firstname', $user_first_name, false, $value ), $email_subject );
													$user_last_name      = '';
													$user_last_name_temp = get_user_meta( $value->user_id, 'billing_last_name', true );
													if ( isset( $user_last_name_temp ) && '' === $user_last_name_temp ) {
														$user_data = get_userdata( $user_id );
														if ( isset( $user_data->last_name ) ) {
															$user_last_name = $user_data->last_name;
														} else {
															$user_last_name = '';
														}
													} else {
														$user_last_name = $user_last_name_temp;
													}
													$email_body = str_ireplace( '{{customer.lastname}}', apply_filters( 'wcal_abandoned_cart_email_content_customer.lastname', $user_last_name, false, $value ), $email_body );
													$email_body = str_ireplace( '{{customer.fullname}}', apply_filters( 'wcal_abandoned_cart_email_content_customer.fullname', $user_first_name . ' ' . $user_last_name, false, $value ), $email_body );
												}
												$order_date = '';
												if ( $cart_update_time > 0 ) {
													$date_format = date_i18n( get_option( 'date_format' ), $cart_update_time );
													$time_format = date_i18n( get_option( 'time_format' ), $cart_update_time );
													$order_date  = $date_format . ' ' . $time_format;
												}
												$email_body = str_ireplace( '{{cart.abandoned_date}}', apply_filters( 'wcal_abandoned_cart_email_content_cart.abandoned_date', $order_date, false, $value ), $email_body );

												$crypt_key = wcal_get_crypt_key( $value->user_email );
												$wpdb->query( // phpcs:ignore
													$wpdb->prepare(
														"INSERT INTO `" . $wpdb->prefix . "ac_sent_history_lite` ( template_id, abandoned_order_id, sent_time, sent_email_id, encrypt_key ) VALUES ( %s, %s, '" . current_time( 'mysql' ) . "', %s, %s )", // phpcs:ignore
														$template_id,
														$value->id,
														$value->user_email,
														$crypt_key
													)
												);

												$results_sent = $wpdb->get_results( // phpcs:ignore
													$wpdb->prepare(
														'SELECT * FROM `' . $wpdb->prefix . 'ac_sent_history_lite` WHERE template_id = %s AND abandoned_order_id = %s ORDER BY id DESC LIMIT 1',
														$template_id,
														$value->id
													)
												);
												if ( count( $results_sent ) > 0 ) {
													$email_sent_id = $results_sent[0]->id;
												} else {
													$email_sent_id = '';
												}

												if ( $email_sent_id > 0 ) {

													if ( version_compare( $woocommerce->version, '2.3.0', '<' ) ) {
														$cart_page_link = $woocommerce->cart->get_cart_url();
													} else {
														$cart_page_id   = wc_get_page_id( 'cart' );
														$cart_page_link = $cart_page_id ? get_permalink( $cart_page_id ) : '';
													}
													$cart_page_link  = apply_filters( 'wcal_cart_link_email_before_encoding', $cart_page_link, $value->id );
													$encoding_cart   = $email_sent_id . '&url=' . $cart_page_link . $utm;
													$validate_cart   = wcal_common::wcal_encrypt_validate( $encoding_cart, $crypt_key );
													$cart_link_track = get_option( 'siteurl' ) . '/?wcal_action=track_links&user_email=' . $value->user_email . '&validate=' . $validate_cart;

													list( $email_body , $coupon_code_to_apply ) = wcal_common::wcal_check_and_replace_email_tag( $email_body, $wc_email_template );
													if ( '' !== $coupon_code_to_apply ) {
														$encypted_coupon_code = wcal_common::wcal_encrypt_validate( $coupon_code_to_apply, $crypt_key );
														$cart_link_track     .= '&c=' . $encypted_coupon_code;
													}
													$email_body           = str_ireplace( '{{cart.link}}', apply_filters( 'wcal_abandoned_cart_email_content_cart.link', $cart_link_track, false, $value ), $email_body );
													$validate_unsubscribe = wcal_common::wcal_encrypt_validate( $email_sent_id, $crypt_key );
													if ( count( $results_sent ) > 0 && isset( $results_sent[0]->sent_email_id ) ) {
														$email_sent_id_address = $results_sent[0]->sent_email_id;
													}
													$encrypt_email_sent_id_address = hash( 'sha256', $email_sent_id_address );
													$plugins_url                   = get_option( 'siteurl' ) . '/?wcal_track_unsubscribe=wcal_unsubscribe&user_email=' . $value->user_email . '&validate=' . $validate_unsubscribe . '&track_email_id=' . $encrypt_email_sent_id_address;
													$unsubscribe_link_track        = $plugins_url;
													$email_body                    = str_ireplace( '{{cart.unsubscribe}}', apply_filters( 'wcal_abandoned_cart_email_content_cart.unsubscribe', $unsubscribe_link_track, false, $value ), $email_body );
													$var                           = '';
													if ( preg_match( '{{products.cart}}', $email_body, $matched ) ) {
														$img_header           = __( 'Item', 'woocommerce-abandoned-cart' );
														$product_name_header  = __( 'Name', 'woocommerce-abandoned-cart' );
														$qty_header           = __( 'Quantity', 'woocommerce-abandoned-cart' );
														$price_header         = __( 'Price', 'woocommerce-abandoned-cart' );
														$line_subtotal_header = __( 'Line Subtotal', 'woocommerce-abandoned-cart' );

														$table_custom_style = '';
														$table_custom_style = apply_filters( 'wcal_add_table_style_email', $table_custom_style );
														if ( class_exists( 'WP_Better_Emails' ) ) {

															$var = '<table width = 100% style="margin-right: auto; margin-left:auto;' . $table_custom_style . '">
                                                                <tr> <td colspan="5"> <h3 style="text-align:center">' . __( 'Your Shopping Cart', 'woocommerce-abandoned-cart' ) . '</h3> </td></tr>
                                                                <tr>
																<th>' . apply_filters( 'wcal_reminder_email_img_header', $img_header ) . '</th>
                                                                <th>' . apply_filters( 'wcal_reminder_email_product_header', $product_name_header ) . '</th>
                                                                <th>' . apply_filters( 'wcal_reminder_email_qty_header', $qty_header ) . '</th>
                                                                <th>' . apply_filters( 'wcal_reminder_email_price_header', $price_header ) . '</th>
                                                                <th>' . apply_filters( 'wcal_reminder_email_line_subtotal_header', $line_subtotal_header ) . '</th>
                                                                </tr>';
														} else {

															$var = '<table border="0" cellpadding="10" cellspacing="0" class="templateDataTable" style="margin-right: auto; margin-left:auto;' . $table_custom_style . '">
                                                            <tr> <td colspan="5"> <h3 style="text-align:center">' . __( 'Your Shopping Cart', 'woocommerce-abandoned-cart' ) . '</h3> </td></tr>
                                                                <tr>
																<th>' . apply_filters( 'wcal_reminder_email_img_header', $img_header ) . '</th>
                                                                <th>' . apply_filters( 'wcal_reminder_email_product_header', $product_name_header ) . '</th>
                                                                <th>' . apply_filters( 'wcal_reminder_email_qty_header', $qty_header ) . '</th>
                                                                <th>' . apply_filters( 'wcal_reminder_email_price_header', $price_header ) . '</th>
                                                                <th>' . apply_filters( 'wcal_reminder_email_line_subtotal_header', $line_subtotal_header ) . '</th>
                                                                </tr>';
														}
														$cart_details              = $cart_info_db_field->cart;
														$cart_total                = 0;
														$item_subtotal             = 0;
														$item_total                = 0;
														$sub_line_prod_name        = '';
                                                        $line_subtotal_tax         = 0;
                                                        $line_subtotal_tax_display = 0;
														foreach ( $cart_details as $k => $v ) {
															$quantity_total = $v->quantity;
															$product_id     = $v->product_id;
															$product        = wc_get_product( $product_id );
															if ( $product ) {
																$prod_name          = get_post( $product_id );
																$product_link_track = get_permalink( $product_id );
																$product_name       = $prod_name->post_title;
																if ( '' === $sub_line_prod_name ) {
																	$sub_line_prod_name = $product_name;
																}
																if ( '' !== $product->get_sku() ) {
																	$wcap_sku      = '<br>' . __( 'SKU: ', 'woocommerce-abandoned-cart' ) . $product->get_sku() . '<br>';
																	$wcap_sku      = apply_filters( 'wcal_email_sku', $wcap_sku, $product_id );
																	$product_name .= $wcap_sku;
																}

																$show_taxes = apply_filters( 'wcal_show_taxes', true );
																// Item subtotal is calculated as product total including taxes.
																if ( isset( $wcal_include_tax ) && 'no' === $wcal_include_tax && isset( $wcal_include_tax_setting ) && 'yes' === $wcal_include_tax_setting ) {
																	$item_subtotal      = $v->line_total; // Tax is excluded, it should not be displayed here.
																	$line_subtotal_tax += $v->line_tax;
																} elseif ( isset( $wcal_include_tax ) && 'yes' === $wcal_include_tax && isset( $wcal_include_tax_setting ) && 'yes' === $wcal_include_tax_setting ) {

																	// Item subtotal is calculated as product total including taxes.
																	if ( $v->line_tax > 0 ) {
																		$line_subtotal_tax_display += $v->line_tax;
																		// Calculate the product price.
																		$item_subtotal = $v->line_subtotal + $v->line_subtotal_tax;
																	} else {
																		$item_subtotal              = $v->line_total;
																		$line_subtotal_tax_display += $v->line_tax;
																	}
																} else {

																	if ( $v->line_subtotal_tax > 0 ) {
																		$item_subtotal = $v->line_subtotal + $v->line_subtotal_tax;
																	} else {
																		$item_subtotal = $v->line_total;
																	}
																}
																// Line total.
																$item_total         = $item_subtotal;
																$item_subtotal      = $item_subtotal / $quantity_total;
																$item_total_display = wc_price( $item_total );
																$item_subtotal      = wc_price( $item_subtotal );

																$image_id  = isset( $v->variation_id ) && $v->variation_id > 0 ? $v->variation_id : $v->product_id;
																$image_url = wp_get_attachment_url( get_post_thumbnail_id( $image_id ) );
																if ( ! $image_url && isset( $v->variation_id ) && (int) $image_id === (int) $v->variation_id ) {
																	$image_url = wp_get_attachment_url( get_post_thumbnail_id( $v->product_id ) );
																}
																if ( strpos( $image_url, '/' ) === 0 ) {
																	$image_url = get_option( 'siteurl' ) . $image_url;
																}
																if ( isset( $v->variation_id ) && $v->variation_id > 0 ) {
																	$variation_id = $v->variation_id;
																	$variation    = wc_get_product( $variation_id );
																	$name         = false !== $variation ? $variation->get_formatted_name() : '';
																	$explode_all  = '' !== $name ? explode( '&ndash;', $name ) : array();
																	if ( version_compare( $woocommerce->version, '3.0.0', '>=' ) ) {
																		$wcap_sku = '';
																		if ( false !== $variation && '' !== $variation->get_sku() ) {
																			$wcap_sku = '<br>' . __( 'SKU: ', 'woocommerce-abandoned-cart' ) . $variation->get_sku() . '<br>';
																			$wcap_sku = apply_filters( 'wcal_email_sku', $wcap_sku, $variation_id );
																		}
																		$wcap_get_formatted_variation = false !== $variation ? wc_get_formatted_variation( $variation, true ) : '';

																		$add_product_name = $product_name . ' - ' . $wcap_sku . $wcap_get_formatted_variation;

																		$pro_name_variation = (array) $add_product_name;
																	} else {
																		$pro_name_variation = count( $explode_all ) > 0 ? array_slice( $explode_all, 1, -1 ) : array();
																	}
																	$product_name_with_variable = '';
																	$explode_many_varaition     = array();
																	if ( is_array( $pro_name_variation ) && count( $pro_name_variation ) > 0 ) {
																		foreach ( $pro_name_variation as $pro_name_variation_key => $pro_name_variation_value ) {
																			$explode_many_varaition = explode( ',', $pro_name_variation_value );
																			if ( ! empty( $explode_many_varaition ) ) {
																				foreach ( $explode_many_varaition as $explode_many_varaition_key => $explode_many_varaition_value ) {
																					$product_name_with_variable = $product_name_with_variable . html_entity_decode( $explode_many_varaition_value, ENT_QUOTES | ENT_SUBSTITUTE | ENT_HTML401 ) . '<br>';
																				}
																			} else {
																				$product_name_with_variable = $product_name_with_variable . html_entity_decode( $explode_many_varaition_value, ENT_QUOTES | ENT_SUBSTITUTE | ENT_HTML401 ) . '<br>';
																			}
																		}
																	}
																	$product_name = $product_name_with_variable;
																}
																$image_col     = '<a href="' . $cart_link_track . '"> <img src="' . $image_url . '" alt="" height="42" width="42" /> </a>';
																$prod_col      = '<a href="' . $cart_link_track . '">' . $product_name . '</a>';
																$product_name  = apply_filters( 'wcal_reminder_email_after_product_name', $product_name, $v );
																$var          .= '<tr align="center">
																	<td> ' . apply_filters( 'wcal_reminder_email_image_value', $image_col ) . '</td>
																	<td> ' . apply_filters( 'wcal_reminder_email_prod_value', $prod_col ) . '</td>
                                                                    <td> ' . apply_filters( 'wcal_reminder_email_qty_value', $quantity_total ) . '</td>
                                                                    <td> ' . apply_filters( 'wcal_reminder_email_price_value', $item_subtotal ) . '</td>
                                                                    <td> ' . apply_filters( 'wcal_reminder_email_line_subtotal_value', $item_total_display ) . '</td>
                                                                </tr>';
																$cart_total   += $item_total;
																$item_subtotal = 0;
																$item_total    = 0;
																$p_exists      = true;
															} else {
																$cart_total    = 0;
																$item_subtotal = 0;
																$item_total    = 0;
																$p_exists      = false;
															}
														}

														if ( $p_exists ) {
															// Calculate the cart total.
															if ( isset( $wcal_include_tax ) && 'no' === $wcal_include_tax && isset( $wcal_include_tax_setting ) && 'yes' === $wcal_include_tax_setting ) {
																if ( $show_taxes ) {
																	$formatted_tax = wc_price( $line_subtotal_tax );
																	$var          .= '<tr><td style="text-align: right;" colspan="4">' . esc_html__( 'Tax:', 'woocommerce-ac' ) . '</td><td>' . $formatted_tax . '</td></tr>';
																	$cart_total   += $line_subtotal_tax;
																}
															}
															$cart_total = wc_price( $cart_total );
															$cart_total = apply_filters( 'wcal_reminder_email_cart_total', $cart_total );
															if ( isset( $wcal_include_tax ) && 'yes' === $wcal_include_tax && isset( $wcal_include_tax_setting ) && 'yes' === $wcal_include_tax_setting ) {
																if ( $show_taxes ) {
																	$cart_total = $cart_total . ' (' . __( 'includes Tax: ', 'woocommerce-ac' ) . $line_subtotal_tax_display . ')';
																}
															}
															$cart_total_title = __( 'Cart Total:', 'woocommerce-abandoned-cart' );
															$var             .= '<tr align="center">
                                                                <td> </td>
                                                                <td> </td>
                                                                <td> </td>
                                                                <td>' . apply_filters( 'wcal_reminder_email_cart_total_title', $cart_total_title ) . '</td>
                                                                <td> ' . $cart_total . '</td>
                                                            </tr>';
															$var             .= '</table>';
															$email_body       = str_ireplace( '{{products.cart}}', apply_filters( 'wcal_abandoned_cart_email_content_products.cart', $var, false, $value ), $email_body );

															$email_subject = str_ireplace( '{{product.name}}', apply_filters( 'wcal_abandoned_cart_email_content_product.name', $sub_line_prod_name, false, $value ), $email_subject );
														} else {
															$email_body    = str_ireplace( '{{products.cart}}', apply_filters( 'wcal_abandoned_cart_email_content_products.cart', __( 'Product no longer exists', 'woocommerce-abandoned-cart' ), false, $value ), $email_body );
															$email_subject = str_ireplace( '{{product.name}}', apply_filters( 'wcal_abandoned_cart_email_content_product.name', $sub_line_prod_name, false, $value ), $email_subject );
														}
													}

													$user_email       = $value->user_email;
													$email_body_final = stripslashes( $email_body );
													$email_body_final = convert_smilies( $email_body_final );
													if ( isset( $is_wc_template ) && '1' === $is_wc_template ) {
														ob_start();

														wc_get_template( 'emails/email-header.php', array( 'email_heading' => $wc_template_header ) );
														$email_body_template_header = ob_get_clean();

														ob_start();

														wc_get_template( 'emails/email-footer.php' );
														$email_body_template_footer = ob_get_clean();

														$site_title                 = get_bloginfo( 'name' );
														$email_body_template_footer = str_ireplace( '{site_title}', $site_title, $email_body_template_footer );

														$final_email_body = $email_body_template_header . $email_body_final . $email_body_template_footer;

														wc_mail( $user_email, $email_subject, $final_email_body, $headers );

													} else {
														$email_subject = wp_specialchars_decode( $email_subject );
														wp_mail( $user_email, $email_subject, $email_body_final, $headers );
													}
												}
											}
										}
									}
								}
							}
						}
					}
				}
			}
		}

		/**
		 * This function will check if the user type is Guest and the id is greater than 63000000
		 * Then conider that as a correct guest user, if is not then do not send the emails
		 *
		 * @param string|int $wcal_user_id User id.
		 * @param string     $wcal_user_type User Type.
		 * @return boolean true | false.
		 * @since 4.4
		 */
		public static function wcal_get_is_guest_valid( $wcal_user_id, $wcal_user_type ) {

			if ( 'REGISTERED' === $wcal_user_type ) {
				return true;
			}

			if ( 'GUEST' === $wcal_user_type && $wcal_user_id >= 63000000 ) {
				return true;
			}

			// It indicates that the user type is guest but the id for them is wrong.
			return false;
		}

		/**
		 * It will check the cart total.
		 *
		 * @param array|object $cart Cart details.
		 * @param int          $cart_id - Abandoned Cart ID.
		 * @return boolean true | false
		 * @since 4.3
		 */
		public function wcal_check_cart_total( $cart, $cart_id ) {
			$cart_total_check = false;
			foreach ( $cart as $k => $v ) {
				if ( $v->line_total > 0 ) {
					$cart_total_check = true;
				}
			}
			return apply_filters( 'wcal_check_cart_total', $cart_total_check, $cart_id );
		}

		/**
		 * Get all carts which have the creation time earlier than the one that is passed.
		 *
		 * @param string|timestamp $template_to_send_after_time Template time.
		 * @param string|timestamp $cart_abandon_cut_off_time Cutoff time.
		 * @param int              $template_id - Email Template ID.
		 * @globals mixed $wpdb
		 * @return array | object $results
		 * @since 1.3
		 */
		public function wcal_get_carts( $template_to_send_after_time, $cart_abandon_cut_off_time, $template_id ) {
			global $wpdb;
			$cart_time = current_time( 'timestamp' ) - $template_to_send_after_time - $cart_abandon_cut_off_time; // phpcs:ignore

			$wcal_template_time          = get_option( 'wcal_template_' . $template_id . '_time' );
			$wcal_add_template_condition = '';
			if ( $wcal_template_time > 0 ) {
				$wcal_add_template_condition = ' AND abandoned_cart_time > ' . $wcal_template_time;
			}
			$cart_ignored = 0;
			$unsubscribe  = 0;
			// phpcs:disable
			$results = $wpdb->get_results(
				$wpdb->prepare(
					'SELECT wpac . * , wpu.user_login, wpu.user_email
					FROM `' . $wpdb->prefix . 'ac_abandoned_cart_history_lite` AS wpac
					LEFT JOIN ' . $wpdb->base_prefix . "users AS wpu ON wpac.user_id = wpu.id
					WHERE cart_ignored = %s AND unsubscribe_link = %s AND abandoned_cart_time < %s
					AND email_reminder_status <> 'complete'
					$wcal_add_template_condition
					ORDER BY `id` ASC ",
					$cart_ignored,
					$unsubscribe,
					$cart_time
				)
			);
			return $results;// phpcs:enable
		}

		/**
		 * It will update the abandoned cart staus if the order has been placed before sending the reminder emails.
		 *
		 * @param string|timestamp $time_to_send_template_after Template time.
		 * @param string|timestamp $wcal_cart_time Abandoned time.
		 * @param string|int       $wcal_user_id User id.
		 * @param string           $wcal_user_type User type.
		 * @param string|int       $wcal_cart_id Abandoned cart id.
		 * @param string           $wcal_user_email User Email.
		 * @globals mixed $wpdb
		 * @return boolean true | false
		 * @since 4.3
		 */
		public static function wcal_get_cart_status( $time_to_send_template_after, $wcal_cart_time, $wcal_user_id, $wcal_user_type, $wcal_cart_id, $wcal_user_email ) {
			global $wpdb;

			$order_id         = 0;
			$wcal_cart_status = false;
			if ( wcal_is_hpos_enabled() ) { // HPOS usage is enabled.
				$get_order = wc_get_orders(
					array(
						'limit'      => 1,
						'meta_query' => array( // phpcs:ignore
							array(
								'key'     => 'wcal_abandoned_cart_id',
								'value'   => $wcal_cart_id,
								'compare' => 'EQUAL',
							),
						),
					)
				);
				if ( ! empty( $get_order ) ) {
					$order = $get_order[0];
				}
			} else { // Traditional CPT-based orders are in use.

				$results_wcal_check_if_cart_is_present_in_post_meta = $wpdb->get_var( // phpcS:ignore
					$wpdb->prepare(
						"SELECT post_id FROM `" . $wpdb->prefix . "postmeta` WHERE meta_key = 'wcal_abandoned_cart_id' AND meta_value = %d LIMIT 1", // phpcs:ignore
						$wcal_cart_id
					)
				);

				if ( is_array( $results_wcal_check_if_cart_is_present_in_post_meta ) && $results_wcal_check_if_cart_is_present_in_post_meta > 0 ) {
					$order_id = $results_wcal_check_if_cart_is_present_in_post_meta;
					$order    = wc_get_order( $order_id );
				}
			}
			if ( ! isset( $order ) ) { // check for an order for the same date & email address.
				$args      = array(
					'customer' => $wcal_user_email,
					'limit'    => 1,
				);
				$order_obj = wc_get_orders( $args );
				if ( ! empty( $order_obj ) ) {
					$order = $order_obj[0];
				}
			}

			if ( isset( $order ) && is_object( $order ) ) {

				$order_data = $order->get_data();

				$order_status = $order_data['status'];
				$order_id     = $order_data['id'];
				if ( 'cancelled' !== $order_status && 'failed' !== $order_status && 'pending' !== $order_status && 'checkout-draft' !== $order_status ) { // checkout-draft - WC Blocks.

					$order_date      = $order_data['date_created']->date( 'Y-m-d' );
					$order_date_time = $order_data['date_created']->date( 'Y-m-d H:i:s' );

					$order_details = array(
						'id'                => $order_id,
						'status'            => $order_status,
						'date_created'      => $order_date,
						'date_time_created' => $order_date_time,
					);

					$wcal_cart_status = self::wcal_update_abandoned_cart_status_for_placed_orders( $time_to_send_template_after, $wcal_cart_time, $wcal_user_id, $wcal_user_type, $wcal_cart_id, $wcal_user_email, $order_details );
				}
			}
			return $wcal_cart_status;
		}

		/**
		 * It will update the Guest users abandoned cart staus if the order has been placed before sending the reminder emails.
		 *
		 * @param string|timestamp $time_to_send_template_after Template time.
		 * @param string|timestamp $wcal_cart_time Cart cutoff time.
		 * @param string|int       $wcal_user_id User ID.
		 * @param string           $wcal_user_type - User Type.
		 * @param string|int       $wcal_cart_id Abandoned cart id.
		 * @param string           $wcal_user_email - User email.
		 * @param array            $order_details - WC Order Details.
		 * @globals mixed $wpdb
		 * @return int 0|1
		 * @since 4.3
		 */
		public static function wcal_update_abandoned_cart_status_for_placed_orders( $time_to_send_template_after, $wcal_cart_time, $wcal_user_id, $wcal_user_type, $wcal_cart_id, $wcal_user_email, $order_details ) {

			$updated_value = self::wcal_update_cart_status( $wcal_cart_id, $wcal_cart_time, $time_to_send_template_after, $wcal_user_email, $order_details );
			if ( 1 === $updated_value ) {
				return true;
			}

			return false;
		}

		/**
		 * It will update the Guest users abandoned cart staus if the order has been placed before sending the reminder emails.
		 *
		 * @param string|int       $cart_id Abandoned cart id.
		 * @param string|timestamp $wcal_cart_time Abandoned time.
		 * @param string|timestamp $time_to_send_template_after Template time.
		 * @param string           $wcal_user_email User Email.
		 * @param array            $order_details - Order Details.
		 * @globals mixed $wpdb
		 * @return int 0|1
		 * @since 4.3
		 */
		public static function wcal_update_cart_status( $cart_id, $wcal_cart_time, $time_to_send_template_after, $wcal_user_email, $order_details ) {
			global $wpdb;

			$todays_date     = date( 'Y-m-d' ); // phpcs:ignore
			$order_date      = $order_details['date_created'];
			$order_date_time = $order_details['date_time_created'];
			$order_status    = $order_details['status'];

			$order_date_str = strtotime( $order_date );

			// Retreive the cart status.
			$cart_ignored_status = $wpdb->get_col( // phpcs:ignore
				$wpdb->prepare(
					'SELECT cart_ignored FROM `' . $wpdb->prefix . 'ac_abandoned_cart_history_lite` WHERE id = %d', // phpcs:ignore
					$cart_id
				)
			);
			if ( strtotime( $order_date_time ) > $wcal_cart_time ) {
				// Mark the cart as ignored.
				$wpdb->update( // phpcs:ignore
					$wpdb->prefix . 'ac_abandoned_cart_history_lite',
					array(
						'cart_ignored' => '1',
					),
					array(
						'id' => $cart_id,
					)
				);
				return 1;
			} elseif ( $order_date_str >= strtotime( $todays_date ) ) {
				// In some case the cart is recovered but it is not marked as the recovered. So here we check if any record is found for that cart id if yes then update the record respectively.
				$wcal_check_email_sent_to_cart = self::wcal_get_cart_sent_data( $cart_id );

				if ( 0 !== $wcal_check_email_sent_to_cart && ! in_array( $order_status, array( 'wc-pending', 'wc-failed' ), true ) ) {

					$wcal_results = $wpdb->get_results( // phpcs:ignore
						$wpdb->prepare(
							'SELECT `post_id` FROM `' . $wpdb->prefix . 'postmeta` WHERE meta_value = %s AND meta_key = %s ',
							$cart_id,
							'wcal_recover_order_placed'
						)
					);

					if ( count( $wcal_results ) > 0 ) {

						$order_id = $wcal_results[0]->post_id;
						try {
							if ( 'wc-cancelled' !== $order_status && 'wc-refunded' !== $order_status && 'wc-trash' !== $order_status ) {
								$wpdb->update( // phpcs:ignore
									$wpdb->prefix . 'ac_abandoned_cart_history_lite',
									array(
										'cart_ignored'   => '1',
										'recovered_cart' => $order_id,
									),
									array(
										'id' => $cart_id,
									)
								);
							}
						} catch ( Exception $e ) { // phpcs:ignore
						}
					} else { // Since there's an order placed today for the same user, mark this cart as ignored.
						$wpdb->update( // phpcs:ignore
							$wpdb->prefix . 'ac_abandoned_cart_history_lite',
							array(
								'cart_ignored' => '1',
							),
							array(
								'id' => $cart_id,
							)
						);
					}
				} elseif ( in_array( $order_status, array( 'wc-pending', 'wc-failed' ), true ) ) {
					return 0; // Return 0 as we want to send reminders for unpaid order status.
				} elseif ( '1' !== $cart_ignored_status[0] ) {
					$wpdb->update( // phpcs:ignore
						$wpdb->prefix . 'ac_abandoned_cart_history_lite',
						array(
							'cart_ignored' => '1',
						),
						array(
							'id' => $cart_id,
						)
					);
				}
				return 1;
			} elseif ( 'wc-pending' === $order_status || 'wc-failed' === $order_status ) { // Send the reminders.
				return 0;
			}
			return 0;
		}

		/**
		 * It will check that for abandoned cart remider email has been sent.
		 *
		 * @param string|int $wcal_cart_id Abandoned cart id.
		 * @return int|0     $wcal_sent_id Email sent id.
		 * @globals mixed $wpdb
		 * @since 4.3
		 */
		public static function wcal_get_cart_sent_data( $wcal_cart_id ) {
			global $wpdb;

			$wcal_results = $wpdb->get_results( // phpcs:ignore
				$wpdb->prepare(
					"SELECT id FROM `" . $wpdb->prefix . "ac_sent_history_lite` WHERE abandoned_order_id = %d ORDER BY 'id' DESC LIMIT 1 ", // phpcs:ignore
					$wcal_cart_id
				)
			);

			if ( count( $wcal_results ) > 0 ) {
				$wcal_sent_id = $wcal_results[0]->id;
				return $wcal_sent_id;
			}
			return 0;
		}

		/**
		 * If none of the email has been sent for some time then from the time where it send the first email template it will consider
		 * the time and further email will sent from first email sent time. So all template will not sent at the same time.
		 *
		 * @param string|int       $wcal_cart_id Abandoned cart id.
		 * @param string|timestamp $time_to_send_template_after Template time.
		 * @param string|int       $template_id Template id.
		 * @return boolean true | false
		 * @globals mixed $wpdb
		 * @since 3.1
		 */
		public static function wcal_remove_cart_for_mutiple_templates( $wcal_cart_id, $time_to_send_template_after, $template_id ) {
			global $wpdb;

			$wcal_get_last_email_sent_time_results_list = $wpdb->get_results( // phpcs:ignore
				"SELECT * FROM `" . $wpdb->prefix . "ac_sent_history_lite` WHERE abandoned_order_id = $wcal_cart_id ORDER BY `sent_time` DESC LIMIT 1" // phpcs:ignore
			);

			if ( count( $wcal_get_last_email_sent_time_results_list ) > 0 ) {
				$last_template_send_time   = strtotime( $wcal_get_last_email_sent_time_results_list[0]->sent_time );
				$second_template_send_time = $last_template_send_time + $time_to_send_template_after;
				$current_time_test         = current_time( 'timestamp' ); // phpcs:ignore
				if ( $second_template_send_time > $current_time_test ) {
					return true;
				}
			}

			return false;
		}

		/**
		 * It will check if the reminder email has been sent to the abandoned cart.
		 *
		 * @param string|int       $user_id User id.
		 * @param string|timestamp $cart_update_time Abandoned cart time.
		 * @param string|int       $template_id Template id.
		 * @param string|int       $id Abandoned cart id.
		 * @globals mixed $wpdb
		 * @return boolean true|false
		 * @since 1.3
		 */
		public function wcal_check_sent_history( $user_id, $cart_update_time, $template_id, $id ) {
			global $wpdb;

			$results = $wpdb->get_results( // phpcs:ignore
				$wpdb->prepare(
					"SELECT wpcs . * , wpac . abandoned_cart_time , wpac . user_id FROM `" . $wpdb->prefix . "ac_sent_history_lite` AS wpcs LEFT JOIN " . $wpdb->prefix . "ac_abandoned_cart_history_lite AS wpac ON wpcs.abandoned_order_id =  wpac.id WHERE template_id = %s AND wpcs.abandoned_order_id = %d ORDER BY 'id' DESC LIMIT 1", // phpcs:ignore
					$template_id,
					$id
				)
			);
			if ( count( $results ) === 0 ) {
				return true;
			} elseif ( $results[0]->abandoned_cart_time < $cart_update_time ) {
				return true;
			} else {
				return false;
			}
		}
	}
}
$wcal_cron = new Wcal_Cron();
