'submission',
'plural' => 'submissions',
'ajax' => false,
)
);
}
/**
* Table columns.
*
* @since 1.0.0
* @return array
*/
public function get_columns() {
return array(
'cb' => '',
'important' => '',
'full_name' => __( 'Full Name', 'advisers-contacts' ),
'mobile' => __( 'Mobile', 'advisers-contacts' ),
'email' => __( 'Email', 'advisers-contacts' ),
'interest' => __( 'Interest', 'advisers-contacts' ),
'lead' => __( 'Lead Score', 'advisers-contacts' ),
'stage' => __( 'Stage', 'advisers-contacts' ),
'referred_by' => __( 'Referred By', 'advisers-contacts' ),
'rewarded' => __( 'Reward', 'advisers-contacts' ),
'status' => __( 'Approval', 'advisers-contacts' ),
'created_at' => __( 'Date', 'advisers-contacts' ),
);
}
/**
* Sortable columns.
*
* @since 1.0.0
* @return array
*/
protected function get_sortable_columns() {
return array(
'full_name' => array( 'full_name', false ),
'referred_by' => array( 'referred_by', false ),
'lead' => array( 'lead_score', true ),
'stage' => array( 'lead_stage', false ),
'status' => array( 'status', false ),
'created_at' => array( 'created_at', true ),
);
}
/**
* Bulk actions.
*
* @since 1.0.0
* @return array
*/
protected function get_bulk_actions() {
$stages = array();
foreach ( ADVC_Helpers::stages() as $key => $label ) {
/* translators: %s: lead stage name */
$stages[ 'stage_' . $key ] = sprintf( __( 'Stage: %s', 'advisers-contacts' ), $label );
}
return $stages + array(
'approve' => __( 'Mark Approved', 'advisers-contacts' ),
'reject' => __( 'Mark Rejected', 'advisers-contacts' ),
'rewarded' => __( 'Mark Referrer Rewarded', 'advisers-contacts' ),
'unrewarded' => __( 'Unmark Rewarded', 'advisers-contacts' ),
'important' => __( 'Mark Important', 'advisers-contacts' ),
'unimportant' => __( 'Unmark Important', 'advisers-contacts' ),
'delete' => __( 'Delete', 'advisers-contacts' ),
);
}
/**
* Checkbox column.
*
* @since 1.0.0
* @param object $item Row.
* @return string
*/
public function column_cb( $item ) {
return sprintf( '', $item->id );
}
/**
* Star toggle column.
*
* @since 1.0.0
* @param object $item Row.
* @return string
*/
public function column_important( $item ) {
$class = $item->is_important ? 'dashicons-star-filled' : 'dashicons-star-empty';
return sprintf(
'',
(int) $item->id,
esc_attr__( 'Toggle important', 'advisers-contacts' ),
esc_attr( $class )
);
}
/**
* Full name column with row actions.
*
* @since 1.0.0
* @param object $item Row.
* @return string
*/
public function column_full_name( $item ) {
$view_url = admin_url( 'admin.php?page=advc-view-submission&id=' . $item->id );
$actions = array(
'view' => sprintf( '%s', esc_url( $view_url ), esc_html__( 'View', 'advisers-contacts' ) ),
'edit' => sprintf( '%s', esc_url( $view_url . '#advc-edit' ), esc_html__( 'Edit', 'advisers-contacts' ) ),
'delete' => sprintf(
'%s',
(int) $item->id,
esc_html__( 'Delete', 'advisers-contacts' )
),
);
return sprintf(
'%s%s',
esc_url( $view_url ),
esc_html( $item->full_name ? $item->full_name : __( '(no name)', 'advisers-contacts' ) ),
$this->row_actions( $actions )
);
}
/**
* Mobile column, rendered as a WhatsApp click-to-chat link.
*
* @since 1.0.0
* @param object $item Row.
* @return string
*/
public function column_mobile( $item ) {
if ( empty( $item->mobile_number ) ) {
return '—';
}
$url = ADVC_Helpers::whatsapp_url( $item->mobile_number );
return sprintf(
' %s',
esc_url( $url ),
esc_html( $item->mobile_number )
);
}
/**
* Email column, rendered as a mailto: link.
*
* @since 1.0.0
* @param object $item Row.
* @return string
*/
public function column_email( $item ) {
if ( empty( $item->email ) ) {
return '—';
}
$url = ADVC_Helpers::mailto_url( $item->email );
return sprintf( '%s', esc_url( $url ), esc_html( $item->email ) );
}
/**
* Interest column: the company and the service the lead asked about.
*
* @since 1.3.0
* @param object $item Row.
* @return string
*/
public function column_interest( $item ) {
$extra = $item->field_data ? json_decode( $item->field_data, true ) : array();
$extra = is_array( $extra ) ? $extra : array();
$company = isset( $extra['company_name'] ) ? $extra['company_name'] : '';
$service = isset( $extra['service_interested'] ) ? $extra['service_interested'] : '';
if ( '' === $company && '' === $service && '' !== (string) $item->subject ) {
return esc_html( $item->subject );
}
if ( '' === $company && '' === $service ) {
return '—';
}
$out = '';
if ( '' !== $service ) {
$out .= '' . esc_html( $service ) . '';
}
if ( '' !== $company ) {
$out .= ( $out ? '
' : '' ) . esc_html( $company );
}
return $out;
}
/**
* Lead score column with a hot/warm/cold badge.
*
* @since 1.3.0
* @param object $item Row.
* @return string
*/
public function column_lead( $item ) {
$temps = ADVC_Helpers::temperatures();
$temp = ADVC_Helpers::temperature( $item->lead_score );
return sprintf(
'%2$s %3$d',
esc_attr( $temp ),
esc_html( $temps[ $temp ][0] ),
(int) $item->lead_score
);
}
/**
* Lead stage column.
*
* @since 1.3.0
* @param object $item Row.
* @return string
*/
public function column_stage( $item ) {
$stages = ADVC_Helpers::stages();
$label = isset( $stages[ $item->lead_stage ] ) ? $stages[ $item->lead_stage ] : $item->lead_stage;
return sprintf( '%2$s', esc_attr( $item->lead_stage ), esc_html( $label ) );
}
/**
* Stage links shown above the table, with counts.
*
* @since 1.3.0
* @return string[]
*/
protected function get_views() {
$current = isset( $_REQUEST['advc_stage'] ) ? sanitize_key( wp_unslash( $_REQUEST['advc_stage'] ) ) : ''; // phpcs:ignore WordPress.Security.NonceVerification.Recommended
$counts = ADVC_DB::get_stage_counts();
$base = admin_url( 'admin.php?page=advisers-contacts' );
$views = array();
$views['all'] = sprintf(
'%3$s (%4$d)',
esc_url( $base ),
'' === $current ? ' class="current"' : '',
esc_html__( 'All', 'advisers-contacts' ),
array_sum( $counts )
);
foreach ( ADVC_Helpers::stages() as $key => $label ) {
$views[ $key ] = sprintf(
'%3$s (%4$d)',
esc_url( add_query_arg( 'advc_stage', $key, $base ) ),
$current === $key ? ' class="current"' : '',
esc_html( $label ),
isset( $counts[ $key ] ) ? (int) $counts[ $key ] : 0
);
}
return $views;
}
/**
* Reward column: only meaningful for leads that name a referrer.
*
* @since 1.4.0
* @param object $item Row.
* @return string
*/
public function column_rewarded( $item ) {
if ( '' === (string) $item->referred_by ) {
return '—';
}
if ( $item->is_rewarded ) {
return '' . esc_html__( 'Rewarded', 'advisers-contacts' ) . '';
}
return '' . esc_html__( 'Not yet', 'advisers-contacts' ) . '';
}
/**
* Status column, rendered as a colored badge.
*
* @since 1.0.0
* @param object $item Row.
* @return string
*/
public function column_status( $item ) {
$labels = ADVC_Helpers::statuses();
$label = isset( $labels[ $item->status ] ) ? $labels[ $item->status ] : $item->status;
return sprintf( '%s', esc_attr( ADVC_Helpers::status_badge_class( $item->status ) ), esc_html( $label ) );
}
/**
* Default renderer for plain text columns.
*
* @since 1.0.0
* @param object $item Row.
* @param string $column_name Column key.
* @return string
*/
public function column_default( $item, $column_name ) {
switch ( $column_name ) {
case 'referred_by':
return $item->referred_by ? esc_html( $item->referred_by ) : '—';
case 'created_at':
return esc_html( mysql2date( get_option( 'date_format' ) . ' ' . get_option( 'time_format' ), $item->created_at ) );
default:
return '';
}
}
/**
* Extra table nav: status/referrer/date filters.
*
* @since 1.0.0
* @param string $which top|bottom.
*/
protected function extra_tablenav( $which ) {
if ( 'top' !== $which ) {
return;
}
$status = isset( $_REQUEST['advc_status'] ) ? sanitize_key( wp_unslash( $_REQUEST['advc_status'] ) ) : ''; // phpcs:ignore WordPress.Security.NonceVerification.Recommended
$referrer = isset( $_REQUEST['advc_referrer'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['advc_referrer'] ) ) : ''; // phpcs:ignore WordPress.Security.NonceVerification.Recommended
$date_from = isset( $_REQUEST['advc_date_from'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['advc_date_from'] ) ) : ''; // phpcs:ignore WordPress.Security.NonceVerification.Recommended
$date_to = isset( $_REQUEST['advc_date_to'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['advc_date_to'] ) ) : ''; // phpcs:ignore WordPress.Security.NonceVerification.Recommended
$rewarded = isset( $_REQUEST['advc_rewarded'] ) ? sanitize_key( wp_unslash( $_REQUEST['advc_rewarded'] ) ) : ''; // phpcs:ignore WordPress.Security.NonceVerification.Recommended
$stage = isset( $_REQUEST['advc_stage'] ) ? sanitize_key( wp_unslash( $_REQUEST['advc_stage'] ) ) : ''; // phpcs:ignore WordPress.Security.NonceVerification.Recommended
$temp = isset( $_REQUEST['advc_temp'] ) ? sanitize_key( wp_unslash( $_REQUEST['advc_temp'] ) ) : ''; // phpcs:ignore WordPress.Security.NonceVerification.Recommended
$referrers = ADVC_DB::get_referrer_stats();
$export_url = wp_nonce_url(
add_query_arg(
array_filter(
array(
'action' => 'advc_export_csv',
's' => isset( $_REQUEST['s'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['s'] ) ) : '', // phpcs:ignore WordPress.Security.NonceVerification.Recommended
'advc_status' => $status,
'advc_stage' => $stage,
'advc_temp' => $temp,
'advc_rewarded' => $rewarded,
'advc_referrer' => $referrer,
'advc_date_from' => $date_from,
'advc_date_to' => $date_to,
),
static function ( $value ) {
return '' !== $value;
}
),
admin_url( 'admin-post.php' )
),
'advc_export'
);
?>