| 1 |
<?php |
| 2 |
namespace LWS\WOOREWARDS\PointsFlow\Methods; |
| 3 |
|
| 4 |
// don't call the file directly |
| 5 |
if( !defined( 'ABSPATH' ) ) exit(); |
| 6 |
|
| 7 |
/** From User Meta database table, only need a meta_key */ |
| 8 |
class MetaKey extends \LWS\WOOREWARDS\PointsFlow\ExportMethod |
| 9 |
{ |
| 10 |
/** @return (array) the json that will be send, |
| 11 |
* An array with each entries as {email, points} */ |
| 12 |
public function export($value, $arg) |
| 13 |
{ |
| 14 |
global $wpdb; |
| 15 |
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching |
| 16 |
return $wpdb->get_results($wpdb->prepare("SELECT user_email as `email`, meta_value as `points` FROM {$wpdb->usermeta} INNER JOIN {$wpdb->users} ON ID=user_id WHERE `meta_key`=%s", $value)); |
| 17 |
} |
| 18 |
|
| 19 |
/** @return (string) human readable name */ |
| 20 |
public function getTitle() |
| 21 |
{ |
| 22 |
return __("By User Meta Key", 'woorewards-lite'); |
| 23 |
} |
| 24 |
|
| 25 |
/** @return (bool) appear in method combobox */ |
| 26 |
public function isVisible() |
| 27 |
{ |
| 28 |
return __CLASS__ != get_class($this); |
| 29 |
} |
| 30 |
} |
| 31 |
|
