84 lines
1.8 KiB
PHP
84 lines
1.8 KiB
PHP
<?php
|
|
|
|
/**
|
|
* Heatmap Recording class.
|
|
*
|
|
* @see UserFeedback_DB
|
|
* @since 1.5.0
|
|
*
|
|
* @package UserFeedback
|
|
* @subpackage DB
|
|
*/
|
|
class UserFeedback_Heatmap_Recording extends UserFeedback_DB {
|
|
|
|
/**
|
|
* @inheritdoc
|
|
*/
|
|
protected $table_name = 'userfeedback_heatmap_recordings';
|
|
|
|
/**
|
|
* @inheritdoc
|
|
*/
|
|
protected $casts = array(
|
|
'heatmap_data' => 'string',
|
|
'interaction_type' => 'string',
|
|
);
|
|
|
|
/**
|
|
* @inheritdoc
|
|
*/
|
|
public static function find( $id ) {
|
|
return self::where(
|
|
array(
|
|
'id' => $id,
|
|
)
|
|
)->single();
|
|
}
|
|
|
|
/**
|
|
* @inheritdoc
|
|
*/
|
|
public function get_columns() {
|
|
return array( 'id', 'heatmap_id', 'heatmap_data', 'created_at', 'interaction_type' );
|
|
}
|
|
|
|
/**
|
|
* @inheritdoc
|
|
*/
|
|
public function create_table() {
|
|
global $wpdb;
|
|
|
|
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
|
|
|
|
$charset_collate = $wpdb->get_charset_collate();
|
|
$table_name = self::get_table();
|
|
|
|
$sql = "CREATE TABLE $table_name (
|
|
id bigint(20) NOT NULL AUTO_INCREMENT,
|
|
heatmap_id bigint(20) NOT NULL,
|
|
heatmap_data longtext NOT NULL,
|
|
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
interaction_type varchar(100) NOT NULL,
|
|
PRIMARY KEY (id)
|
|
) $charset_collate;";
|
|
|
|
dbDelta( $sql );
|
|
}
|
|
|
|
/**
|
|
* @inheritdoc
|
|
*/
|
|
public function get_relationship_config( $name ) {
|
|
switch ( $name ) {
|
|
case 'heatmap':
|
|
return array(
|
|
'type' => 'one',
|
|
'class' => UserFeedback_Heatmap::class,
|
|
'key' => 'heatmap_id',
|
|
);
|
|
default:
|
|
return null;
|
|
}
|
|
}
|
|
}
|