<?php
if (!defined('ABSPATH'))
exit;
use NF_Exports_Interfaces_SingleSubmissionInterface as SingleSubmissionInterface;
/**
* Provides and stores single submission data using Custom Post Type
*
*
*/
final class NF_Exports_SingleSubmissionCPT implements SingleSubmissionInterface {
/**
* Key under which export timestamp is stored
*
* Submissions without this value set are considered `not exported`
*/
const EXPORT_TIMESTAMP_KEY = 'export_timestamp';
/**
* Key under which isRead boolean is stored
*
* `true` indicates submission is unread; `false` indicates submission has
* been read
*/
const UNREAD_KEY = 'is_unread';
/**
* Submission Id
* @var string
*/
protected $subId = '';
/**
* Status of the submission
*
* Modeled after Wordpress' post status. Such modeling is required when
* using Wordpress' custom post type, but not required in other
* database structures
*
* @var string
*/
protected $_status = '';
/**
* User Id of the submission
*
* Not sure where this is used.
* @var string
*/
protected $_user_id = '';
/**
* Form Id for the submission
* @var string
*/
protected $_form_id = '';
/**
* Submission sequence number
* @var string
*/
protected $_seq_num = '';
/**
* Submission date
* @var string
*/
protected $_sub_date = '';
/**
* Submission Modified on date
* @var string
*/
protected $_mod_date = '';
/**
* Array of field submission values using NF_Database_Models_Submission
*
*
* @var array
*/
protected $_field_values = array();
/**
* Array of non-field data stored with submission
* @var array
*/
protected $extraValues = array();
/**
*
* @param string|int $id
*/
public function __construct($id) {
$this->subId = $id;
$this->_seq_num = get_post_meta($this->subId, '_seq_num', TRUE);
$this->_form_id = get_post_meta($this->subId, '_form_id', TRUE);
$sub = get_post($this->subId);
if ($sub) {
$this->_status = $sub->post_status;
$this->_user_id = $sub->post_author;
$this->_sub_date = $sub->post_date;
$this->_mod_date = $sub->post_modified;
}
}
/**
* Get Submission ID
*
* @return int
*/
public function getId() {
return intval($this->subId);
}
/**
* @inheritDoc
* @return int
*/
public function getSeqNum() {
return intval($this->_seq_num);
}
/**
* @inheritDoc
* @param string $format
* @return string
*/
public function getSubmissionDate($format = 'm/d/Y') {
return date($format, strtotime($this->_sub_date));
}
/**
* Filter field values to return only provided keys
*
* NOTE: filter is performed on array KEYS of incoming parameter. This
* enables use of a previously generated `field labels` array, which is
* keyed off the same field keys as the submission for perfect matching
* of array columns.
*
* @param array $fieldKeys Array keyed on field keys with optional value
* @return array
*/
public function filterFieldValues($fieldKeys) {
$fieldValues = $this->getFieldValues();
$filtered = array_intersect_key($fieldValues, $fieldKeys);
return $filtered;
}
/**
* Get Field Value
*
* Returns a single submission value by field ID or field key.
*
* @param int|string $field_ref
* @return string
*/
public function getFieldValue($field_ref) {
$field_id = ( is_numeric($field_ref) ) ? $field_ref : $this->getFieldIdByKey($field_ref);
$field = '_field_' . $field_id;
if (isset($this->_field_values[$field]))
return $this->_field_values[$field];
$this->_field_values[$field] = get_post_meta($this->subId, $field, TRUE);
$this->_field_values[$field_ref] = get_post_meta($this->subId, $field, TRUE);
return WPN_Helper::htmlspecialchars($this->_field_values[$field]);
}
/**
* Get Field Values - from existing NF_Database_Models_Submission
*
* Returns all post meta
*
* @return array|mixed
*/
public function getFieldValues() {
if (!empty($this->_field_values))
return $this->_field_values;
$field_values = get_post_meta($this->subId, '');
foreach ($field_values as $field_id => $field_value) {
$this->_field_values[$field_id] = implode(', ', $field_value);
if (0 === strpos($field_id, '_field_')) {
$field_id = substr($field_id, 7);
}
if (!is_numeric($field_id))
continue;
$field = Ninja_Forms()->form()->get_field($field_id);
$key = $field->get_setting('key');
if ($key) {
$this->_field_values[$key] = implode(', ', $field_value);
}
}
return $this->_field_values;
}
public function getExtraValue($key) {
if (!isset($this->extraValues[$key]) || !$this->extraValues[$key]) {
$id = ( $this->subId ) ? $this->subId : 0;
$this->extraValues[$key] = get_post_meta($id, $key, TRUE);
}
return $this->extraValues[$key];
}
/**
* Get Field ID By Key
*
* @param $field_key
* @return mixed
*/
protected function getFieldIdByKey($field_key) {
global $wpdb;
$field_id = $wpdb->get_var("SELECT id FROM {$wpdb->prefix}nf3_fields WHERE `key` = '{$field_key}' AND `parent_id` = {$this->_form_id}");
return $field_id;
}
/**
* Set timestamp of export
*
* @param int $unixTimestamp
* @return NF_Database_Models_SingleSubmissionInterface
*/
public function setExportDatetime(int $unixTimestamp) {
update_post_meta($this->subId, self::EXPORT_TIMESTAMP_KEY, $unixTimestamp);
return $this;
}
/**
* Return bool true if submission has exported datetime set
* @return bool
*/
public function wasExported() {
$bool = false;
$test = $this->getExtraValue(self::EXPORT_TIMESTAMP_KEY);
if ($test) {
$bool = true;
}
return $bool;
}
/**
* Return bool `is submission unread?`
*
* If not set, default is false (submission has been read). Thus new
* submissions must be explicitly set as unread. Without this, all
* preexisting submissions will be marked as unread and can confuse
* existing installations.
*
* @return boolean
*/
public function isUnread() {
$default = false;
$return = $this->getExtraValue(self::UNREAD_KEY);
if (true != $return) {
$return = $default;
}
return $return;
}
/**
* Mark the submission as `unread` via post_meta
*/
public function markAsRead() {
update_post_meta($this->subId, self::UNREAD_KEY, false);
}
/**
* Mark the submission as `read` via post_meta
*/
public function markAsUnread() {
update_post_meta($this->subId, self::UNREAD_KEY, true);
}
}
في ظل التحول الرقمي المتسارع، أصبح التسويق الإلكتروني أحد أهم الأدوات التي تعتمد عليها المؤسسات والشركات لتحقيق الانتشار والوصول إلى جمهور أوسع.
في هذا الحوار التسجيلي، نسلّط الضوء على مفهوم التسويق الإلكتروني، أهميته في العصر الحديث، وكيف غيّر قواعد اللعبة في عالم المال والأعمال.
ال