<?php // phpcs:ignore WordPress.Files.FileName.NotHyphenatedLowercase
/**
 * Email AJAX
 * Jetpack CRM - https://jetpackcrm.com
 * // phpcs:ignore Squiz.Commenting.FileComment.MissingPackageTag
 */

if ( ! defined( 'ZEROBSCRM_PATH' ) ) {
	exit( 0 );
}

// phpcs:disable WordPress.DB.PreparedSQL.NotPrepared,WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.NotPrepared,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.NamingConventions.ValidFunctionName.FunctionNameInvalid

/**
 * Stars an email thread
 */
function zeroBSCRM_star_email_thread() {

	// stars the email thread for easier finding in the "Starred" box
	check_ajax_referer( 'zbscrmjs-glob-ajax-nonce', 'sec' );

	if ( ! zeroBSCRM_permsSendEmailContacts() ) {
		wp_send_json( array( 'processed' => -1 ) );
	}

	global $wpdb, $ZBSCRM_t; // phpcs:ignore WordPress.NamingConventions.ValidVariableName.VariableNotSnakeCase
	$the_thread = ( empty( $_POST['emid'] ) ? -1 : (int) $_POST['emid'] );
	$sql        = $wpdb->prepare( 'UPDATE ' . $ZBSCRM_t['system_mail_hist'] . ' SET zbsmail_starred = 1 WHERE zbsmail_sender_thread = %d', $the_thread ); // phpcs:ignore WordPress.NamingConventions.ValidVariableName.VariableNotSnakeCase
	$wpdb->query( $sql );
	$m = array( 'message' => 'success' );
	wp_send_json( $m );
}
add_action( 'wp_ajax_zbs_email_star_thread', 'zeroBSCRM_star_email_thread' );

/**
 * Unstars an email thread
 */
function zeroBSCRM_unstar_email_thread() {

	// stars the email thread for easier finding in the "Starred" box
	check_ajax_referer( 'zbscrmjs-glob-ajax-nonce', 'sec' );

	if ( ! zeroBSCRM_permsSendEmailContacts() ) {
		wp_send_json( array( 'processed' => -1 ) );
	}

	global $wpdb, $ZBSCRM_t; // phpcs:ignore WordPress.NamingConventions.ValidVariableName.VariableNotSnakeCase
	$the_thread = ( empty( $_POST['emid'] ) ? -1 : (int) $_POST['emid'] );
	$sql        = $wpdb->prepare( 'UPDATE ' . $ZBSCRM_t['system_mail_hist'] . ' SET zbsmail_starred = 0 WHERE zbsmail_sender_thread = %d', $the_thread ); // phpcs:ignore WordPress.NamingConventions.ValidVariableName.VariableNotSnakeCase
	$wpdb->query( $sql );
	$m = array( 'message' => 'success' );
	wp_send_json( $m );
}
add_action( 'wp_ajax_zbs_email_unstar_thread', 'zeroBSCRM_unstar_email_thread' );

/**
 * Deletes an email thread
 */
function zeroBSCRM_delete_email_thread() {

	check_ajax_referer( 'zbscrmjs-glob-ajax-nonce', 'sec' );

	if ( ! zeroBSCRM_permsSendEmailContacts() ) {
		wp_send_json( array( 'processed' => -1 ) );
	}

	global $wpdb, $ZBSCRM_t; // phpcs:ignore WordPress.NamingConventions.ValidVariableName.VariableNotSnakeCase
	$the_thread = ( empty( $_POST['emid'] ) ? -1 : (int) $_POST['emid'] );
	$sql        = $wpdb->prepare( 'DELETE FROM ' . $ZBSCRM_t['system_mail_hist'] . ' WHERE zbsmail_sender_thread = %d', $the_thread ); // phpcs:ignore WordPress.NamingConventions.ValidVariableName.VariableNotSnakeCase
	$wpdb->query( $sql );
	$m = array( 'message' => 'success' );
	wp_send_json( $m );
}
add_action( 'wp_ajax_zbs_delete_email_thread', 'zeroBSCRM_delete_email_thread' );

/**
 * AJAX - Send an email against a thread in email box
 */
function zeroBSCRM_send_email_thread_ajax() {

	// check nonce
	check_ajax_referer( 'zbscrmjs-glob-ajax-nonce', 'sec' );

	// check permissions
	if ( ! zeroBSCRM_permsSendEmailContacts() ) {
		wp_send_json( array( 'processed' => -1 ) );
	}

	global $wpdb, $ZBSCRM_t; // phpcs:ignore WordPress.NamingConventions.ValidVariableName.VariableNotSnakeCase

	// retrieve thread and contact ID
	$thread_id  = ( empty( $_POST['emid'] ) ? -1 : (int) $_POST['emid'] );
	$contact_id = ( empty( $_POST['cid'] ) ? -1 : (int) $_POST['cid'] );

	// retrieve send to email
	$sql           = $wpdb->prepare( 'SELECT zbsmail_receiver_email FROM ' . $ZBSCRM_t['system_mail_hist'] . ' WHERE zbsmail_sender_thread = %d ORDER BY ID ASC LIMIT 0,1', $thread_id ); // phpcs:ignore WordPress.NamingConventions.ValidVariableName.VariableNotSnakeCase
	$send_to_email = $wpdb->get_var( $sql );

	// fallback to email on account for contact
	if ( empty( $send_to_email ) ) {
		$send_to_email = zeroBS_customerEmail( $contact_id );
	}

	// get delivery method
	$sql             = $wpdb->prepare( 'SELECT zbsmail_sender_maildelivery_key FROM ' . $ZBSCRM_t['system_mail_hist'] . ' WHERE zbsmail_sender_thread = %d ORDER BY ID ASC LIMIT 0,1', $thread_id ); // phpcs:ignore WordPress.NamingConventions.ValidVariableName.VariableNotSnakeCase
	$delivery_method = $wpdb->get_var( $sql );
	// validate still legit, else set to -1 if (empty($deliveryMethod))
	// actually, the sendmail func does this well, fallback to that

	// send
	jpcrm_send_single_email_from_box( $send_to_email, $thread_id, $delivery_method, true, false );

	// fini
	exit( 0 );
}
add_action( 'wp_ajax_zbs_email_send_thread_ui', 'zeroBSCRM_send_email_thread_ajax' );

/**
 * Loads Email Manager customer panel
 */
function zeroBSCRM_emails_customer_panel() {

	check_ajax_referer( 'zbscrmjs-glob-ajax-nonce', 'sec' );

	if ( ! zeroBSCRM_permsSendEmailContacts() ) {
		wp_send_json( array( 'processed' => -1 ) );
	}

	$contact_id = ( empty( $_POST['cid'] ) ? -1 : (int) $_POST['cid'] );
	$thread_id  = ( empty( $_POST['emid'] ) ? -1 : (int) $_POST['emid'] );

	$ret = array();

	$ret['customer'] = zeroBS_getCustomer( $contact_id, true, true, true );

	$ret['avatar'] = zeroBS_customerAvatarHTML( $contact_id );

	$ret['trans_value'] = zeroBSCRM_formatCurrency( zeroBS_customerTransactionsValue( $contact_id, $ret['customer']['transactions'] ) );
	$ret['inv_value']   = zeroBSCRM_formatCurrency( zeroBS_customerInvoicesValue( $contact_id, $ret['customer']['invoices'] ) );
	$ret['quote_value'] = zeroBSCRM_formatCurrency( zeroBS_customerQuotesValue( $contact_id, $ret['customer']['quotes'] ) );

	$ret['tasks'] = zeroBSCRM_getTaskList( $contact_id );

	$email = zeroBSCRM_get_email_history( 0, 50, $contact_id, '', -1, false, $thread_id );

	zeroBSCRM_mark_as_read( $thread_id );

	global $zbs;

	$e         = 0;
	$email_ret = array();
	foreach ( $email as $em ) {
		$email_ret[ $e ]['the_id']          = $em->ID;
		$email_ret[ $e ]['date']            = zeroBSCRM_locale_utsToDate( $em->zbsmail_created );
		$email_ret[ $e ]['zbsmail_subject'] = $em->zbsmail_subject;
		if ( $em->zbsmail_content === null ) {
			$email_ret[ $e ]['zbsmail_content'] = __( 'No content was stored for this message', 'zero-bs-crm' );
		} else {
			$email_ret[ $e ]['zbsmail_content'] = wp_kses( wpautop( $em->zbsmail_content ), $zbs->acceptable_html );
		}
		$email_ret[ $e ]['zbsmail_opened']     = $em->zbsmail_opened;
		$email_ret[ $e ]['zbsmail_lastopened'] = zeroBSCRM_locale_utsToDatetimeWP( $em->zbsmail_firstopened );
		$email_ret[ $e ]['in_or_out']          = $em->zbsmail_status;
		if ( $em->zbsmail_status === 'inbox' ) {
			$email_ret[ $e ]['avatar'] = zeroBS_customerAvatarHTML( $em->zbsmail_target_objid );
		} else {
			$email_ret[ $e ]['avatar'] = jpcrm_get_avatar( $em->zbsmail_sender_wpid, 35 );
		}
		++$e;
	}

	$ret['email'] = $email_ret;

	wp_send_json( $ret, true );
}
add_action( 'wp_ajax_zbs_email_customer_panel', 'zeroBSCRM_emails_customer_panel' );

/**
 * Mark email thread as read
 *
 * @param int $thread_id ID of thread.
 */
function zeroBSCRM_mark_as_read( $thread_id = -1 ) {
	global $wpdb, $ZBSCRM_t; // phpcs:ignore WordPress.NamingConventions.ValidVariableName.VariableNotSnakeCase
	if ( $thread_id >= 0 ) {
		$sql = $wpdb->prepare( 'UPDATE ' . $ZBSCRM_t['system_mail_hist'] . " SET zbsmail_opened = 1, zbsmail_lastopened = %d, zbsmail_firstopened = %d WHERE zbsmail_sender_thread = %d AND zbsmail_status = 'inbox' AND zbsmail_opened = 0", time(), time(), $thread_id ); // phpcs:ignore WordPress.NamingConventions.ValidVariableName.VariableNotSnakeCase
	}
	$wpdb->query( $sql );
}

/**
 * Send an email against a thread in email box
 *
 * Note, this is fired by AJAX and by main.page.php `zeroBSCRM_pages_admin_sendmail()` on first send (centralised here)
 *
 * @param string $send_to_email Email recipient.
 * @param int    $thread_id Thread ID.
 * @param string $delivery_method Delivery method.
 * @param bool   $exit_json Exit with JSON.
 * @param bool   $do_nl2br Use nl2br.
 */
function jpcrm_send_single_email_from_box( $send_to_email = '', $thread_id = -1, $delivery_method = -1, $exit_json = true, $do_nl2br = false ) {

	// check permissions
	if ( ! zeroBSCRM_permsSendEmailContacts() ) {
		if ( $exit_json ) {
			wp_send_json( array( 'processed' => -1 ) );
		} else {
			exit( 0 );
		}
	}

	// this function is used via AJAX and direct POST, so for now check for two separate nonces
	if ( ! isset( $_POST['_wpnonce'] ) || ! wp_verify_nonce( wp_unslash( $_POST['_wpnonce'] ), 'jpcrm-update-client-details' ) ) { // phpcs:ignore WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
		check_ajax_referer( 'zbscrmjs-glob-ajax-nonce', 'sec' );
	}

	// proceed
	global $zbs;

	// declare
	$result = false;

	$m = array();

	// got valid send-to email?
	if ( zeroBSCRM_validateEmail( $send_to_email ) ) {

		// build email
		$subject = '';
		if ( isset( $_POST['zbs-send-email-title'] ) ) {
			$subject = zeroBSCRM_textProcess( $_POST['zbs-send-email-title'] ); // phpcs:ignore WordPress.Security.ValidatedSanitizedInput.InputNotSanitized,WordPress.Security.ValidatedSanitizedInput.MissingUnslash
		}
		$content = '';
		if ( isset( $_POST['zbs_send_email_content'] ) ) {
			$content = zeroBSCRM_textProcess( $_POST['zbs_send_email_content'] ); // phpcs:ignore WordPress.Security.ValidatedSanitizedInput.InputNotSanitized,WordPress.Security.ValidatedSanitizedInput.MissingUnslash
		}
		if ( $do_nl2br ) {
			$content = nl2br( $content );
		}
		$contact_id = (int) zeroBS_getCustomerIDWithEmail( $send_to_email );

		// only send to existing contacts
		if ( $contact_id <= 0 ) {
			$m['message'] = __( 'No contact found under the specified email!', 'zero-bs-crm' );
			return;
		}
		$uid = get_current_user_id();

		// load templater
		$placeholder_templating = $zbs->get_templating();
		$generic_replacements   = $placeholder_templating->get_generic_replacements();

		// retrieve contact
		$contact_object = zeroBS_getCustomer( $contact_id );

		// process subject
		$subject = $placeholder_templating->replace_placeholders( array( 'global', 'contact' ), zeroBSCRM_textExpose( $subject ), $generic_replacements, array( ZBS_TYPE_CONTACT => $contact_object ) );

		// build content html
		$content = $placeholder_templating->replace_placeholders( array( 'global', 'contact' ), zeroBSCRM_textExpose( $content ), $generic_replacements, array( ZBS_TYPE_CONTACT => $contact_object ) );

		// build overall html & headers
		$email_html = jpcrm_mailTemplates_single_send_templated( true, $content, $subject, $contact_object );
		$headers    = array( 'Content-Type: text/html; charset=UTF-8' );

		// get which del method naming convention:
		$naming_convention = zeroBSCRM_getSetting( 'directmsgfrom' );
		switch ( $naming_convention ) {

			case 1: // Agent Name @ CRM Name
				$user_info = get_userdata( $uid );

				$agent_name = $user_info->first_name . ' ' . $user_info->last_name;
				if ( $agent_name === ' ' ) {
					$agent_name = $user_info->display_name;
				}

				$agent_name      = ucwords( $agent_name );
				$email_from_name = $agent_name;

				$crm_name = zeroBSCRM_mailDelivery_defaultFromname();
				if ( ! empty( $crm_name ) ) {
					$email_from_name .= ' @ ' . $crm_name;
				}

				break;
			case 2: // CRM Name
				$email_from_name = zeroBSCRM_mailDelivery_defaultFromname();

				break;
			case 3: // Mail Delivery Name
				// just pass empty and it'll default
				$email_from_name = '';

				break;
		}

		// build mail array
		$mail_array = array(
			'toEmail'  => $send_to_email,
			'toName'   => '',
			'subject'  => $subject,
			'headers'  => $headers,
			'body'     => $email_html,
			'textbody' => '',
			'thread'   => $thread_id,
			'content'  => $content, // not the full HTML just the content
			'options'  => array(
				'html' => 1,
			),
			'tracking' => array(
				// tracking :D (auto-inserted pixel + saved in history db)
				'emailTypeID'     => -999, // mike's used -999 to mean direct email
				'targetObjID'     => $contact_id,
				'senderWPID'      => $uid,
				'associatedObjID' => -999, // mike's used -999 to mean direct email (yes twice?)
			),
		);

		// if any, add
		if ( ! empty( $email_from_name ) ) {
			$mail_array['overrideSendName'] = $email_from_name;
		}

		// Sends email, including tracking
		zeroBSCRM_mailDelivery_sendMessage( $delivery_method, $mail_array ); // phpcs:ignore VariableAnalysis.CodeAnalysis.VariableAnalysis.UnusedVariable

		// Add log - temp, needs to also remember which camp + link to
		zeroBS_addUpdateContactLog(
			$contact_id,
			-1,
			-1,
			array(
				'type'           => 'Email',
				'shortdesc'      => __( 'Email Sent', 'zero-bs-crm' ),
				'longdesc'       => __( 'Email sent with the subject: ', 'zero-bs-crm' ) . $subject,
				// meta keyval for later linking
				'meta_assoc_src' => 'singlemail',
			)
		);

		// success
		$m['message'] = 'success';
		$result       = true;

	} else {

		// invalid email address
		$m['message'] = __( 'That is not a valid email. Please enter a valid email', 'zero-bs-crm' );

	}

	if ( $exit_json ) {

		wp_send_json( $m );

	}
	return $result;
}
// phpcs:enable WordPress.DB.PreparedSQL.NotPrepared,WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.NotPrepared,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.NamingConventions.ValidFunctionName.FunctionNameInvalid
