<?php
/**
 * This program is free software: you can redistribute it and/or modify it under the
 * terms of the GNU General Public License as published by the Free Software Foundation,
 * either version 3 of the License, or (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
 * without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 * See the GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License along with this program.
 * If not, see https://www.gnu.org/licenses/.
 */

/**
 * Clase genérica para todo lo relacionado con Senders
 */
class CorreosOficialSenders {

	public static function getSenderById( $sender_id ) {

		global $wpdb;

		$sender = $wpdb->get_row(
			$wpdb->prepare("SELECT * FROM {$wpdb->prefix}correos_oficial_senders WHERE id=%d", $sender_id), ARRAY_A);
  
		if ($sender['correos_code'] != 0) {
			$resultCorreosRow = $wpdb->get_row(
				$wpdb->prepare("SELECT * FROM {$wpdb->prefix}correos_oficial_codes WHERE id=%d", $sender['correos_code']), ARRAY_A);

			$sender['correos_code'] = $resultCorreosRow['CorreosCustomer'];
		}
  
		if ($sender['cex_code'] != 0) {
			$resultCEXRow = $wpdb->get_row(
				$wpdb->prepare("SELECT * FROM {$wpdb->prefix}correos_oficial_codes WHERE id=%d", $sender['cex_code']), ARRAY_A);
			
			$sender['cex_code'] = $resultCEXRow['CEXCustomer'];
		}
  
		return $sender;
	}
}