<?php
/**
 * Automations
 *
 * @package     AutomatorWP\Custom_Tables\Automations
 * @author      AutomatorWP <contact@automatorwp.com>, Ruben Garcia <rubengcdev@gmail.com>
 * @since       1.0.0
 */
// Exit if accessed directly
if( !defined( 'ABSPATH' ) ) exit;

/**
 * Custom Table Labels
 *
 * @since 1.0.0
 *
 * @return array
 */
function automatorwp_automations_labels() {

    return array(
        'singular' => __( 'Automation', 'automatorwp' ),
        'plural' => __( 'Automations', 'automatorwp' ),
        'labels' => array(
            'list_menu_title' => __( 'Automations', 'automatorwp' ),
        ),
    );

}
add_filter( 'ct_automatorwp_automations_labels', 'automatorwp_automations_labels' );

/**
 * Parse query args for automations
 *
 * @since   1.0.0
 *
 * @param string $where
 * @param CT_Query $ct_query
 *
 * @return string
 */
function automatorwp_automations_query_where( $where, $ct_query ) {

    global $ct_table;

    if( $ct_table->name !== 'automatorwp_automations' ) {
        return $where;
    }

    $table_name = $ct_table->db->table_name;

    // Shorthand
    $qv = $ct_query->query_vars;

    // Status
    $where .= automatorwp_custom_table_where( $qv, 'status', 'status', 'string' );

    // Type
    $where .= automatorwp_custom_table_where( $qv, 'type', 'type', 'string' );

    // User ID
    $where .= automatorwp_custom_table_where( $qv, 'user_id', 'user_id', 'integer' );

    return $where;
}
add_filter( 'ct_query_where', 'automatorwp_automations_query_where', 10, 2 );

/**
 * Parse query args to be applied on JOIN clause
 *
 * @since   2.0.0
 *
 * @param string    $join
 * @param CT_Query  $ct_query
 *
 * @return string
 */
function automatorwp_automations_query_join( $join, $ct_query ) {

    global $ct_table;

    if( $ct_table->name !== 'automatorwp_automations' ) {
        return $join;
    }

    $table_name = $ct_table->db->table_name;
    $meta_table_name = $ct_table->meta->db->table_name;

    // Shorthand
    $qv = $ct_query->query_vars;

    // Parent post type
    if( isset( $qv['orderby'] ) && $qv['orderby'] === 'completions' ) {
        $join .= " LEFT JOIN {$meta_table_name} am ON ( am.id = {$table_name}.id AND am.meta_key = 'completions' )";
    }

    return $join;

}
add_filter( 'ct_query_join', 'automatorwp_automations_query_join', 10, 2 );

/**
 * Parse query args to be applied on ORDER BY clause
 *
 * @since   2.0.0
 *
 * @param string    $orderby
 * @param CT_Query  $ct_query
 *
 * @return string
 */
function automatorwp_automations_query_orderby( $orderby, $ct_query ) {

    global $ct_table;

    if( $ct_table->name !== 'automatorwp_automations' ) {
        return $orderby;
    }

    // Shorthand
    $qv = $ct_query->query_vars;

    // Parent post type
    if( isset( $qv['orderby'] ) && $qv['orderby'] === 'completions' ) {
        $order = 'DESC';

        if( isset( $qv['order'] ) && $qv['order'] === 'ASC' ) {
            $order = 'ASC';
        }

        $orderby = "CAST( am.meta_value AS UNSIGNED ) " . $order;
    }

    return $orderby;

}
add_filter( 'ct_query_orderby', 'automatorwp_automations_query_orderby', 10, 2 );

/**
 * Define the search fields for automations
 *
 * @since 1.0.0
 *
 * @param array $search_fields
 *
 * @return array
 */
function automatorwp_automations_search_fields( $search_fields ) {

    $search_fields[] = 'title';

    return $search_fields;

}
add_filter( 'ct_query_automatorwp_automations_search_fields', 'automatorwp_automations_search_fields' );

/**
 * Parse search query args for automations
 *
 * @since 1.3.9.7
 *
 * @param string $search
 * @param CT_Query $ct_query
 *
 * @return string
 */
function automatorwp_automations_query_search( $search, $ct_query ) {

    global $ct_table, $wpdb;

    if( $ct_table->name !== 'automatorwp_automations' ) {
        return $search;
    }

    $table_name = $ct_table->db->table_name;

    // Shorthand
    $qv = $ct_query->query_vars;

    // Check if is search and query is not filtered by an specific user
    if( isset( $qv['s'] ) && ! empty( $qv['s'] ) && ! isset( $qv['user_id'] ) ) {

        // Made a user sub-search to retrieve them
        $users = get_users( array(
            'search' => sprintf( '*%s*', $qv['s'] ),
            'search_columns' => array(
                'user_login',
                'user_email',
                'display_name',
            ),
            'fields' => 'ID',
        ) );

        if( ! empty( $users ) ) {
            $search .= " AND ( {$table_name}.user_id IN (" . implode( ',', array_map( 'absint', $users ) ) . ") )";
        }

    }

    return $search;

}
add_filter( 'ct_query_search', 'automatorwp_automations_query_search', 10, 2 );

/**
 * Define the field for automations views
 *
 * @since 1.0.0
 *
 * @param string $field_id
 *
 * @return string
 */
function automatorwp_automations_views_field( $field_id = '' ) {
    return 'status';
}
add_filter( 'ct_list_automatorwp_automations_views_field', 'automatorwp_automations_views_field' );

/**
 * Define the field labels for automations views
 *
 * @since 1.0.0
 *
 * @param array $field_labels
 *
 * @return array
 */
function automatorwp_automations_views_field_labels( $field_labels = array() ) {
    return automatorwp_get_automation_statuses();
}
add_filter( 'ct_list_automatorwp_automations_views_field_labels', 'automatorwp_automations_views_field_labels' );

/**
 * Columns for automations list view
 *
 * @since 1.0.0
 *
 * @param array $columns
 *
 * @return array
 */
function automatorwp_manage_automations_columns( $columns = array() ) {

    $columns['title']       = __( 'Title', 'automatorwp' );
    $columns['type']        = __( 'Type', 'automatorwp' );
    $columns['triggers']    = __( 'Triggers', 'automatorwp' );
    $columns['actions']     = __( 'Actions', 'automatorwp' );
    $columns['user_id']     = __( 'Author', 'automatorwp' );
    $columns['completions'] = __( 'Completions', 'automatorwp' );
    $columns['status']      = __( 'Status', 'automatorwp' );
    $columns['date']        = __( 'Date', 'automatorwp' );

    return $columns;
}
add_filter( 'manage_automatorwp_automations_columns', 'automatorwp_manage_automations_columns' );

/**
 * Sortable columns for automations list view
 *
 * @since 1.0.0
 *
 * @param array $sortable_columns
 *
 * @return array
 */
function automatorwp_manage_automations_sortable_columns( $sortable_columns ) {

    $sortable_columns['title']          = array( 'title', false );
    $sortable_columns['type']           = array( 'type', false );
    $sortable_columns['user_id']        = array( 'user_id', false );
    $sortable_columns['completions']    = array( 'completions', true );
    $sortable_columns['status']         = array( 'status', false );
    $sortable_columns['date']           = array( 'date', true );

    return $sortable_columns;

}
add_filter( 'manage_automatorwp_automations_sortable_columns', 'automatorwp_manage_automations_sortable_columns' );

/**
 * Columns rendering for automations list view
 *
 * @since  1.0.0
 *
 * @param string $column_name
 * @param integer $object_id
 */
function automatorwp_manage_automations_custom_column(  $column_name, $object_id ) {

    // Setup vars
    $automation = ct_get_object( $object_id );

    if( automatorwp_is_automation_expired( $automation ) ) {
        automatorwp_deactivate_automation( $automation->id );
        $automation->status = 'inactive';
    }

    switch( $column_name ) {
        case 'title':
            $title = ! empty( $automation->title ) ? $automation->title : __( '(No title)', 'automatorwp' ); ?>
                <strong><a href="<?php echo ct_get_edit_link( 'automatorwp_automations', $automation->id ); ?>"><?php echo esc_html( $title ); ?></a></strong>
            <?php

            break;
        case 'type':
            $types = automatorwp_get_automation_types();
            $type = isset( $types[$automation->type] ) ? $types[$automation->type]['label'] : $automation->type;
            ?>

            <span class="automatorwp-automation-type automatorwp-automation-type-<?php echo esc_attr( $automation->type ); ?>">
                <?php if ( isset( $types[$automation->type] ) ) : ?>
                        <div class="automatorwp-integration-icon cmb-tooltip">
                            <img src="<?php echo esc_attr( $types[$automation->type]['image'] ); ?>" alt="<?php echo esc_attr( $types[$automation->type]['label'] ); ?>">
                            <span class="cmb-tooltip-desc cmb-tooltip-top"><?php echo esc_html( $types[$automation->type]['label'] ); ?></span>
                        </div>
                <?php else : ?>
                    <div class="automatorwp-integration-icon cmb-tooltip">
                        <img src="<?php echo esc_attr( AUTOMATORWP_URL . 'assets/img/integration-missing.svg' ); ?>" alt="<?php echo esc_attr( __( 'Missing plugin', 'automatorwp' ) ); ?>">
                        <span class="cmb-tooltip-desc cmb-tooltip-top"><?php echo esc_html( $automation->type ); ?></span>
                    </div>
                <?php endif; ?>
                <?php echo esc_html( $type ); ?>
            </span>

            <?php

            break;
        case 'triggers':
            $triggers = automatorwp_get_automation_triggers( $automation->id );

            foreach( $triggers as $trigger ) {

                $type_args = automatorwp_get_trigger( $trigger->type );

                if( $type_args ) {
                    $integration = automatorwp_get_integration( $type_args['integration'] );

                    $integration = apply_filters( 'automatorwp_automations_column_triggers_integration', $integration, $trigger, 'trigger', $automation );

                    if( $integration ) : ?>

                        <div class="automatorwp-integration-icon cmb-tooltip">
                            <img src="<?php echo esc_attr( $integration['icon'] ); ?>" alt="<?php echo esc_attr( $integration['label'] ); ?>">
                            <span class="cmb-tooltip-desc cmb-tooltip-top"><?php echo esc_html( $integration['label'] ); ?></span>
                        </div>

                    <?php endif;
                } else { ?>

                    <div class="automatorwp-integration-icon cmb-tooltip">
                        <img src="<?php echo esc_attr( AUTOMATORWP_URL . 'assets/img/integration-missing.svg' ); ?>" alt="<?php echo esc_attr( __( 'Missing plugin', 'automatorwp' ) ); ?>">
                        <span class="cmb-tooltip-desc cmb-tooltip-top"><?php echo esc_html( $trigger->type ); ?></span>
                    </div>

                <?php }

                echo $trigger->title . '<br>';
            }

            break;
        case 'actions':
            $actions = automatorwp_get_automation_actions( $automation->id );

            foreach( $actions as $action ) {

                $type_args = automatorwp_get_action( $action->type );

                if( $type_args ) {
                    $integration = automatorwp_get_integration( $type_args['integration'] );

                    if( $action->type === 'automatorwp_anonymous_user' ) {
                        $integration['icon'] = AUTOMATORWP_URL . 'assets/img/automatorwp-anonymous.svg';
                    }

                    if( $integration ) : ?>

                        <div class="automatorwp-integration-icon cmb-tooltip">
                            <img src="<?php echo esc_attr( $integration['icon'] ); ?>" alt="<?php echo esc_attr( $integration['label'] ); ?>">
                            <span class="cmb-tooltip-desc cmb-tooltip-top"><?php echo esc_html( $integration['label'] ); ?></span>
                        </div>

                    <?php endif;

                } else { ?>

                    <div class="automatorwp-integration-icon cmb-tooltip">
                        <img src="<?php echo esc_attr( AUTOMATORWP_URL . 'assets/img/integration-missing.svg' ); ?>" alt="<?php echo esc_attr( __( 'Missing plugin', 'automatorwp' ) ); ?>">
                        <span class="cmb-tooltip-desc cmb-tooltip-top"><?php echo esc_html( $action->type ); ?></span>
                    </div>

                <?php }

                echo $action->title . '<br>';
            }

            break;
        case 'user_id':
            $user = get_userdata( $automation->user_id );

            if( $user ) {

                if( current_user_can( 'edit_users' ) ) {
                    ?>

                    <a href="<?php echo get_edit_user_link( $user->ID ); ?>"><?php echo $user->display_name . ' (' . $user->user_login . ')'; ?></a>

                    <?php
                } else {
                    echo $user->display_name;
                }

            }
            break;
        case 'completions':
            $completions = ct_get_object_meta( $automation->id, 'completions', true );

            if( empty( $completions ) ) {
                $completions = automatorwp_get_object_completion_times( $automation->id, 'automation' );
                ct_update_object_meta( $automation->id, 'completions', $completions );
            }

            $completions = absint( $completions );
            $times = absint( $automation->times );

            if( $times === 0 ) : ?>
                <span class="automatorwp-automation-completions"><?php echo $completions; ?></span>
            <?php else : ?>
                <span class="automatorwp-automation-completions <?php echo ( $completions >= $times ? 'automatorwp-automation-completions-completed' : '' ) ?>"><?php echo $completions . '/' . $times; ?></span>
            <?php endif;
            break;
        case 'status':
            $statuses = automatorwp_get_automation_statuses();
            $status = isset( $statuses[$automation->status] ) ? $statuses[$automation->status] : esc_html( $automation->status );
            ?>

            <span class="automatorwp-automation-status automatorwp-automation-status-<?php echo esc_attr( $automation->status ); ?>"><?php echo $status; ?></span>

            <?php

            // Expiration
            $now        = current_time( 'timestamp' );
            $expiration = strtotime( $automation->expiration );

            if( $expiration > 0 ) {
                $expires_text = $expiration > $now ? __( 'Expires on', 'automatorwp' ) : __( 'Expired on', 'automatorwp' );
                ?>

                <div class="automatorwp-automation-expiration">
                    <?php echo esc_html( $expires_text ); ?> <abbr title="<?php echo date( 'Y/m/d g:i:s a', $expiration ); ?>"><?php echo date( 'Y/m/d', $expiration ); ?></abbr>
                </div>

                <?php
            }

            break;
        case 'date':
            $date = strtotime( $automation->date ); ?>

            <abbr title="<?php echo date( 'Y/m/d g:i:s a', $date ); ?>"><?php echo date( 'Y/m/d', $date ); ?></abbr>

            <?php
            break;
    }
}
add_action( 'manage_automatorwp_automations_custom_column', 'automatorwp_manage_automations_custom_column', 10, 2 );

/**
 * Filters the array of row action links on the item list table.
 *
 * @since 1.4.8
 *
 * @param array $actions An array of row action links. Defaults are 'Edit' and 'Delete Permanently'.
 * @param stdClass $item The item object.
 *
 * @return array
 */
function automatorwp_automations_custom_row_actions( $actions, $item ) {

    global $ct_table;

    $primary_key = $ct_table->db->primary_key;

    // List link + object ID + action delete
    $url = $ct_table->views->list->get_link();
    $url = add_query_arg( array( $primary_key => $item->$primary_key ), $url );

    $actions['clone'] = sprintf(
        '<a href="%s" class="automatorwp-clone-automation" aria-label="%s">%s</a>',
        add_query_arg( array( 'automatorwp-action' => 'clone_automation' ), $url ),
        esc_attr( __( 'Clone', 'automatorwp' ) ),
        __( 'Clone', 'automatorwp' )
    );

    $actions['url_export'] = sprintf(
        '<a href="%s" class="automatorwp-url-export-automation" aria-label="%s">%s</a>',
        add_query_arg( array( 'automatorwp-action' => 'url_export_automation' ), $url ),
        esc_attr( __( 'Export', 'automatorwp' ) ),
        __( 'Export', 'automatorwp' )
    );

    if( isset( $actions['delete'] ) ) {

        // Remove the delete action to move it to the end
        unset( $actions['delete'] );

        // Override the delete action
        $actions['delete'] = sprintf(
            '<a href="%s" class="submitdelete" onclick="%s" aria-label="%s">%s</a>',
            ct_get_delete_link( $ct_table->name, $item->$primary_key ),
            "return confirm('" .
            esc_attr( __( "Are you sure you want to delete this automation?\\n\\nClick \\'Cancel\\' to go back, \\'OK\\' to confirm the delete.", 'automatorwp' ) ) .
            "');",
            esc_attr( __( 'Delete', 'automatorwp' ) ),
            __( 'Delete', 'automatorwp' )
        );
    }

    return $actions;

}
add_filter( 'automatorwp_automations_row_actions', 'automatorwp_automations_custom_row_actions', 10, 2 );

/**
 * Handler for the clone automation action.
 *
 * @since 1.4.8
 *
 * @param array $request Request parameters
 */
function automatorwp_action_clone_automation( $request ) {


    // Bail if automation ID not received
    if( ! isset( $request['id'] ) ) {
        return;
    }

    $automation_id = absint( $request['id'] );

    // Bail if automation ID is not correct received
    if( $automation_id === 0 ) {
        return;
    }

    $ct_table = ct_setup_table( 'automatorwp_automations' );

    $automation = ct_get_object( $automation_id );
    $edit_capability = $ct_table->cap->edit_item;
    $url = $ct_table->views->list->get_link();

    ct_reset_setup_table();

    // Check if automation exists and current user can edit it
    if( ! $automation ) {
        return;
    }

    // Check if automation exists and current user can edit it
    if( ! current_user_can( $edit_capability, $automation->id ) ) {
        return;
    }

    ct_reset_setup_table();

    $new_automation_id = automatorwp_clone_automation( $automation_id, get_current_user_id() );

    if( $new_automation_id ) {

        $redirect = ( isset( $request['redirect'] ) ? $request['redirect'] : false );

        if( $redirect ) {
            $url = $ct_table->views->edit->get_link();
            $url = add_query_arg( array( 'message' => 'automation_cloned' ), $url );
            $url = add_query_arg( array( 'id' => $new_automation_id ), $url );

            // Redirect to the new automation
            wp_redirect( $url );
            exit;
        }

        $url = add_query_arg( array( 'message' => 'automation_cloned' ), $url );
        $url = add_query_arg( array( 'new_id' => $new_automation_id ), $url );
    } else {
        $url = add_query_arg( array( 'message' => 'automation_not_cloned' ), $url );
    }

    wp_redirect( $url );
    exit;

}
add_action( 'automatorwp_action_clone_automation', 'automatorwp_action_clone_automation' );

function automatorwp_automations_admin_notices() {

    $messages = array(
        'automation_cloned' => __( 'Automation cloned successfully.', 'automatorwp' ),
        'automation_not_cloned' => __( 'Automation could not be cloned.', 'automatorwp' ),
    );

    // If the new id exists, add a link to edit it directly
    if( isset( $_GET['new_id'] ) && absint( $_GET['new_id'] ) !== 0 ) {
        $messages['automation_cloned'] = sprintf(
            __( 'Automation cloned successfully! <a href="%s">Edit the new automation</a>.', 'automatorwp' ),
            ct_get_edit_link( 'automatorwp_automations', absint( $_GET['new_id'] ) )
        );
    }

    /**
     * Filters the automations table updated messages.
     *
     * @since 1.0.0
     *
     * @param array $messages Post updated messages. For defaults @see $messages declarations above.
     */
    $messages = apply_filters( 'automatorwp_automations_messages', $messages );

    // Setup screen message
    if ( isset( $_GET['message'] ) && isset( $messages[$_GET['message']] ) ) {
        echo '<div id="message" class="updated notice is-dismissible"><p>' . esc_html( $messages[$_GET['message']] ) . '</p></div>';
    }

}
add_action( 'admin_notices', 'automatorwp_automations_admin_notices' );

/**
 * Default data when creating a new item (similar to WP auto draft) see ct_insert_object()
 *
 * @since  1.0.0
 *
 * @param array $default_data
 *
 * @return array
 */
function automatorwp_automations_default_data( $default_data = array() ) {

    // Handle the type during creation
    $types = automatorwp_get_automation_types();
    $type = ( isset( $_GET['type'] ) ? sanitize_text_field( $_GET['type'] ) : 'user' );

    if( ! isset( $types[$type] ) ) {
        $type = 'user';
    }

    $default_data['type']           = $type;
    $default_data['user_id']        = get_current_user_id();
    $default_data['sequential']     = 0;
    $default_data['times_per_user'] = 1;
    $default_data['times']          = 0;
    $default_data['status']         = 'inactive';
    $default_data['date']           = date( 'Y-m-d H:i:s', current_time( 'timestamp' ) );
    $default_data['expiration']     = '';
    $default_data['title']          = '';

    return $default_data;
}
add_filter( 'ct_automatorwp_automations_default_data', 'automatorwp_automations_default_data' );

/**
 * Turns array of date and time into a valid mysql date on update object data
 *
 * @since 1.0.0
 *
 * @param array $object_data
 * @param array $original_object_data
 *
 * @return array
 */
function automatorwp_automations_insert_automation_data( $object_data, $original_object_data ) {

    global $ct_table;

    // If not is our custom table, return
    if( $ct_table->name !== 'automatorwp_automations' ) {
        return $object_data;
    }

    // Fix date format
    if( isset( $object_data['date'] ) && ! empty( $object_data['date'] ) ) {
        // Covers CMB2 format with array( 'date' => '', 'time' => '' )
        if( is_array( $object_data['date'] ) ) {
            $object_data['date'] = implode( ' ', $object_data['date'] );
        }

        $object_data['date'] = date( 'Y-m-d H:i:s', strtotime( $object_data['date'] ) );
    }

    // Fix expiration format
    if( isset( $object_data['expiration'] ) ) {
        // Covers CMB2 format with array( 'date' => '', 'time' => '' )
        if( is_array( $object_data['expiration'] ) ) {
            $object_data['expiration'] = trim( implode( ' ', $object_data['expiration'] ) );
        }

        if( ! empty( $object_data['expiration'] ) ) {
            $now = current_time( 'timestamp' );
            $expiration = strtotime( $object_data['expiration'] );

            if( $object_data['status'] === 'active' && $expiration < $now ) {
                // Prevent to have an older expiration (which will deactivate constantly the automation)
                $object_data['expiration'] = '0000-00-00 00:00:00';
            } else {
                $object_data['expiration'] = date( 'Y-m-d H:i:s', $expiration );
            }
        } else {
            // Never expires expiration
            $object_data['expiration'] = '0000-00-00 00:00:00';
        }

    }

    // Handle sequential saving
    $object_data['sequential'] = ( isset( $_POST['sequential'] ) ? 1 : 0 );

    return $object_data;

}
add_filter( 'ct_insert_object_data', 'automatorwp_automations_insert_automation_data', 10, 2 );

/**
 * Register custom CMB2 meta boxes
 *
 * @since  1.0.0
 */
function automatorwp_automations_meta_boxes( ) {

    // Title
    automatorwp_add_meta_box(
        'automatorwp-automations-title',
        __( 'Title', 'automatorwp' ),
        'automatorwp_automations',
        array(
            'title' => array(
                'name' 	=> __( 'Title', 'automatorwp' ),
                'type' 	=> 'text',
                'classes' 	=> 'automatorwp-auto-save',
                'attributes' => array(
                    'placeholder' => __( 'Enter title here', 'automatorwp' ),
                )
            ),
        ),
        array(
            'priority' => 'core',
        )
    );

    // Save Changes
    automatorwp_add_meta_box(
        'automatorwp-automations-save-changes',
        __( 'Save Changes', 'automatorwp' ),
        'automatorwp_automations',
        array(
            'type' => array(
                'name' 	=> __( 'Type', 'automatorwp' ),
                'type' 	=> 'select',
                'options' => automatorwp_get_automation_types_labels(),
                'js_controls' => array(
                    'icon' => 'dashicons-star-filled',
                    'edit_button' => false,
                    'save_button_classes' => 'button button-primary',
                    'cancel_button_classes' => 'button automatorwp-button-danger',
                ),
                'before_row' => 'js_controls_before',
                'after_row' => 'js_controls_after',
            ),
            'times_per_user' => array(
                'name' 	=> __( 'Times per user', 'automatorwp' ),
                'desc' 	=> __( 'Maximum number of times a user can complete this automation. Set it to 0 for unlimited.', 'automatorwp' ),
                'type' 	=> 'input',
                'attributes' => array(
                    'type' => 'number',
                    'min' => '0',
                ),
                'classes' => 'automatorwp-has-tooltip',
                'after_field' => 'automatorwp_tooltip_cb',
                'js_controls' => array(
                    'icon' => 'dashicons-filter',
                    'save_button'   => __( 'Save', 'automatorwp' ),
                    'save_button_classes' => 'button button-primary',
                    'cancel_button_classes' => 'button automatorwp-button-danger',
                ),
                'before_row' => 'js_controls_before',
                'after_row' => 'js_controls_after',
            ),
            'times' => array(
                'name' 	=> __( 'Total times', 'automatorwp' ),
                'desc' 	=> __( 'Maximum number of times this automation can be completed. Set it to 0 for unlimited.', 'automatorwp' ),
                'type' 	=> 'input',
                'attributes' => array(
                    'type' => 'number',
                    'min' => '0',
                ),
                'classes' => 'automatorwp-has-tooltip',
                'after_field' => 'automatorwp_tooltip_cb',
                'js_controls' => array(
                    'icon' => 'dashicons-admin-site',
                    'save_button'   => __( 'Save', 'automatorwp' ),
                    'save_button_classes' => 'button button-primary',
                    'cancel_button_classes' => 'button automatorwp-button-danger',
                ),
                'before_row' => 'js_controls_before',
                'after_row' => 'js_controls_after',
            ),
            'user_id' => array(
                'name' 	=> __( 'Author', 'automatorwp' ),
                'type' 	=> 'select',
                'classes' 	=> 'automatorwp-user-selector',
                'options_cb' => 'automatorwp_options_cb_users',
                'display_cb' => 'automatorwp_display_cb_users',
                'js_controls' => array(
                    'icon' => 'dashicons-admin-users',
                    'save_button'   => __( 'Save', 'automatorwp' ),
                    'save_button_classes' => 'button button-primary',
                    'cancel_button_classes' => 'button automatorwp-button-danger',
                ),
                'before_row' => 'js_controls_before',
                'after_row' => 'js_controls_after',
            ),
            'status' => array(
                'name' 	=> __( 'Status', 'automatorwp' ),
                'type' 	=> 'select',
                'options_cb' => 'automatorwp_options_cb_automation_statuses',
                'js_controls' => array(
                    'icon' => 'dashicons-post-status',
                    'save_button'   => __( 'Save', 'automatorwp' ),
                    'save_button_classes' => 'button button-primary',
                    'cancel_button_classes' => 'button automatorwp-button-danger',
                ),
                'before_row' => 'js_controls_before',
                'after_row' => 'js_controls_after',
            ),
            'date' => array(
                'name' 	=> __( 'Created on', 'automatorwp' ),
                'desc' 	=> __( 'Automation will take effect based on this date. You can schedule <strong>future</strong> automations by setting this field with a future date.', 'automatorwp' )
                    . '<br>' . __( '<strong>Note:</strong> For future automations, status need to be <strong>active</strong> because setting a future date won\'t update the status automatically.', 'automatorwp' ),
                'type' 	=> 'text_datetime_timestamp',
                'date_format' => automatorwp_get_date_format( array( 'm/d/Y', 'd/m/Y' ), 'm/d/Y' ),
                'time_format' => 'H:i',
                'escape_cb' => 'automatorwp_automation_date_escape_cb',
                'display_cb' => 'automatorwp_automation_date_display_cb',
                'attributes' => array(
                    'autocomplete' => 'off'
                ),
                'classes' => 'automatorwp-has-tooltip',
                'after_field' => 'automatorwp_tooltip_cb',
                'js_controls' => array(
                    'icon' => 'dashicons-calendar',
                    'save_button'   => __( 'Save', 'automatorwp' ),
                    'save_button_classes' => 'button button-primary',
                    'cancel_button_classes' => 'button automatorwp-button-danger',
                ),
                'before_row' => 'js_controls_before',
                'after_row' => 'js_controls_after', // Handled on automatorwp_automations_publishing_actions()
            ),
            'expiration' => array(
                'name' 	=> __( 'Expires on', 'automatorwp' ),
                'desc' 	=> __( 'Automation will be automatically set to <strong>inactive</strong> after this date. You can schedule the automation deactivation by setting this field with a future date.', 'automatorwp' ),
                'type' 	=> 'text_datetime_timestamp',
                'date_format' => automatorwp_get_date_format( array( 'm/d/Y', 'd/m/Y' ), 'm/d/Y' ),
                'time_format' => 'H:i',
                'escape_cb' => 'automatorwp_automation_date_escape_cb',
                'display_cb' => 'automatorwp_automation_date_display_cb',
                'attributes' => array(
                    'autocomplete' => 'off'
                ),
                'classes' => 'automatorwp-has-tooltip',
                'after_field' => 'automatorwp_tooltip_cb',
                'js_controls' => array(
                    'icon' => 'dashicons-clock',
                    'save_button'   => __( 'Save', 'automatorwp' ),
                    'save_button_classes' => 'button button-primary',
                    'cancel_button_classes' => 'button automatorwp-button-danger',
                ),
                'before_row' => 'js_controls_before',
                //'after_row' => 'js_controls_after', // Handled on automatorwp_automations_publishing_actions()
                'after_row' => 'automatorwp_automations_publishing_actions',

            ),
        ),
        array(
            'priority' => 'default',
            'context' => 'side',
        )
    );

}
add_action( 'cmb2_admin_init', 'automatorwp_automations_meta_boxes' );

/**
 * Expiration escape callback.
 *
 * @param  string     $value        Field value.
 * @param  array      $field_args   Array of field arguments.
 * @param  CMB2_Field $field        The field object
 */
function automatorwp_automation_date_escape_cb( $value, $field_args, $field ) {

    if ( $value === '0000-00-00 00:00:00' )
        $escaped_value = '';
    else
        $escaped_value = date( automatorwp_get_date_format( array( 'm/d/Y', 'd/m/Y' ), 'm/d/Y' ) . ' H:i', strtotime( $value ) );

    return $escaped_value;

}

/**
 * Expiration display callback.
 *
 * @param  array      $field_args Array of field arguments.
 * @param  CMB2_Field $field      The field object
 */
function automatorwp_automation_date_display_cb( $field_args, $field ) {
    $value = $field->escaped_value(); ?>
    <div class="<?php echo $field->row_classes(); ?>" data-fieldtype="text_date_timestamp">
        <?php echo $value === '' ? __( 'Never Expires', 'automatorwp' ) : $value; ?>
    </div>
    <?php
}

/**
 * Publishing actions
 *
 * @since 1.0.0
 */
function automatorwp_automations_publishing_actions( $field_args, $field ) {

    global $ct_table;

    if( ! $ct_table ) {
        return;
    }

    if( $ct_table->name !== 'automatorwp_automations' ) {
        return;
    }

    // The JS controls after of the date field
    js_controls_after( $field_args, $field );

    $primary_key = $ct_table->db->primary_key;
    $object_id = isset( $_GET[$primary_key] ) ? absint( $_GET[$primary_key] ) : 0;

    $automation = ct_get_object( $object_id );

    // Bail if automation doesn't exists
    if( ! $automation ) {
        return;
    }

    $actions = array();

    $url = $ct_table->views->edit->get_link();
    $url = add_query_arg( array( $primary_key => $object_id ), $url );
    $url = add_query_arg( array( 'redirect' => true ), $url );

    $actions['clone'] = sprintf(
        '<a href="%s" class="automatorwp-clone-automation" aria-label="%s">%s</a>',
        add_query_arg( array( 'automatorwp-action' => 'clone_automation' ), $url ),
        esc_attr( __( 'Clone', 'automatorwp' ) ),
        __( 'Clone', 'automatorwp' )
    );

    $actions['url_export'] = sprintf(
        '<a href="%s" class="automatorwp-url-export-automation" aria-label="%s">%s</a>',
        add_query_arg( array( 'automatorwp-action' => 'url_export_automation' ), $url ),
        esc_attr( __( 'Export', 'automatorwp' ) ),
        __( 'Export', 'automatorwp' )
    );

    /**
     * Filters the array of edit action links on the automation edit page.
     *
     * @since 1.4.8
     *
     * @param array     $actions    An array of row action links.
     * @param stdClass  $automation The automation object.
     *
     * @return array
     */
    $actions = apply_filters( 'automatorwp_automations_edit_actions', $actions, $automation )
    ?>
    <div id="major-publishing-actions">

        <div id="automatorwp-automation-actions">
            <?php foreach( $actions as $action => $action_html ) : ?>
                <div id="automatorwp-automation-action-<?php echo esc_attr( $action ); ?>" class="automatorwp-automation-action"><?php echo $action_html; ?></div>
            <?php endforeach; ?>
        </div>

        <?php if( $automation->status === 'inactive' ) : ?>

            <div class="automatorwp-save-and-activate">
                <?php submit_button( __( 'Save &amp; Activate', 'automatorwp' ), ' primary large', 'automatorwp-save-and-activate', false ); ?>
            </div>

            <div id="publishing-action">
                <?php submit_button( __( 'Save Changes' ), 'large', 'ct-save', false ); ?>
            </div>

            <div class="clear"></div>

        <?php else : ?>

            <div id="publishing-action">
                <?php submit_button( __( 'Save Changes' ), 'primary large', 'ct-save', false ); ?>
            </div>

        <?php endif; ?>

        <div id="delete-action">
            <?php
            printf(
                '<a href="%s" class="submitdelete deletion" onclick="%s" aria-label="%s">%s</a>',
                ct_get_delete_link( $ct_table->name, $object_id ),
                "return confirm('" .
                esc_attr( __( "Are you sure you want to delete this automation?\\n\\nClick \\'Cancel\\' to go back, \\'OK\\' to confirm the delete.", 'automatorwp' ) ) .
                "');",
                esc_attr( __( 'Delete', 'automatorwp' ) ),
                __( 'Delete', 'automatorwp' )
            );
            ?>
        </div>

        <div class="clear"></div>

    </div>

    <?php
}

/**
 * Remove meta boxes
 *
 * @since  1.0.0
 */
function automatorwp_automations_remove_meta_boxes() {
    // Removes submitdiv box
    remove_meta_box( 'submitdiv', 'automatorwp_automations', 'side' );
}
add_action( 'add_meta_boxes', 'automatorwp_automations_remove_meta_boxes' );

/**
 * On delete an automation
 *
 * @since 1.0.0
 *
 * @param int $object_id
 */
function automatorwp_automations_delete_object( $object_id ) {

    global $wpdb, $ct_table;

    if( ! ( $ct_table instanceof CT_Table ) ) {
        return;
    }

    if( $ct_table->name !== 'automatorwp_automations' ) {
        return;
    }

    $logs       = AutomatorWP()->db->logs;
    $logs_meta 	= AutomatorWP()->db->logs_meta;

    // Delete all logs assigned to this action
    $wpdb->query( "DELETE l FROM {$logs} AS l WHERE l.object_id = {$object_id} AND l.type = 'automation'" );

    // Delete orphaned log metas
    $wpdb->query( "DELETE lm FROM {$logs_meta} lm LEFT JOIN {$logs} l ON l.id = lm.id WHERE l.id IS NULL" );

    // Delete all triggers
    $triggers = automatorwp_get_automation_triggers( $object_id );

    foreach( $triggers as $trigger ) {
        ct_setup_table( 'automatorwp_triggers' );

        ct_delete_object( $trigger->id );

        ct_reset_setup_table();
    }

    // Delete all actions
    $actions = automatorwp_get_automation_actions( $object_id );

    foreach( $actions as $action ) {
        ct_setup_table( 'automatorwp_actions' );

        ct_delete_object( $action->id );

        ct_reset_setup_table();
    }

}
add_action( 'delete_object', 'automatorwp_automations_delete_object' );