1:   2:   3:   4:   5:   6:   7:   8:   9:  10:  11:  12:  13:  14:  15:  16:  17:  18:  19:  20:  21:  22:  23:  24:  25:  26:  27:  28:  29:  30:  31:  32:  33:  34:  35:  36:  37:  38:  39:  40:  41:  42:  43:  44:  45:  46:  47:  48:  49:  50:  51:  52:  53:  54:  55:  56:  57:  58:  59:  60:  61:  62:  63:  64:  65:  66:  67:  68:  69:  70:  71:  72:  73:  74:  75:  76:  77:  78:  79:  80:  81:  82:  83:  84:  85:  86:  87:  88:  89:  90:  91:  92:  93:  94:  95:  96:  97:  98:  99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 239: 240: 241: 242: 243: 244: 245: 246: 247: 248: 249: 250: 251: 252: 253: 254: 255: 256: 257: 258: 259: 260: 261: 262: 263: 264: 265: 266: 267: 268: 269: 270: 271: 272: 273: 274: 275: 276: 277: 278: 279: 280: 281: 282: 283: 284: 285: 286: 287: 288: 289: 290: 291: 292: 293: 294: 295: 296: 297: 298: 299: 300: 301: 302: 303: 304: 305: 306: 307: 308: 309: 310: 311: 312: 313: 314: 315: 316: 317: 318: 319: 320: 321: 322: 323: 324: 325: 326: 327: 328: 329: 330: 331: 332: 333: 334: 335: 336: 337: 338: 339: 340: 341: 342: 343: 344: 345: 346: 347: 348: 349: 350: 351: 352: 353: 354: 355: 356: 357: 358: 359: 360: 361: 362: 363: 364: 365: 366: 367: 368: 369: 370: 371: 372: 373: 374: 375: 376: 377: 378: 379: 380: 381: 382: 383: 384: 385: 386: 387: 388: 389: 390: 391: 392: 393: 394: 395: 396: 397: 398: 399: 400: 401: 402: 403: 404: 405: 406: 407: 408: 409: 410: 411: 412: 413: 414: 415: 416: 417: 418: 419: 420: 421: 422: 423: 424: 425: 426: 427: 428: 429: 430: 431: 432: 433: 434: 435: 436: 437: 438: 439: 440: 441: 442: 443: 444: 445: 446: 447: 448: 449: 450: 451: 452: 453: 454: 455: 456: 457: 458: 459: 460: 461: 462: 463: 464: 465: 466: 467: 468: 469: 470: 471: 472: 473: 474: 475: 476: 477: 478: 479: 480: 481: 482: 483: 484: 485: 486: 487: 488: 489: 490: 491: 492: 493: 494: 495: 496: 497: 498: 499: 500: 501: 502: 503: 504: 505: 506: 507: 508: 509: 510: 511: 512: 513: 514: 515: 516: 517: 518: 519: 520: 521: 522: 523: 524: 525: 526: 527: 528: 529: 530: 531: 532: 533: 534: 535: 536: 537: 538: 539: 540: 541: 542: 543: 544: 545: 546: 547: 548: 549: 550: 551: 552: 553: 554: 555: 556: 557: 558: 559: 560: 561: 562: 563: 564: 565: 566: 567: 568: 569: 570: 571: 572: 573: 574: 575: 576: 577: 578: 579: 580: 581: 582: 583: 584: 585: 586: 587: 588: 589: 590: 591: 592: 593: 594: 595: 596: 597: 598: 599: 600: 601: 602: 603: 604: 605: 606: 607: 608: 609: 610: 611: 612: 613: 614: 615: 616: 617: 618: 619: 620: 621: 622: 623: 624: 625: 626: 627: 628: 629: 630: 631: 632: 633: 634: 635: 636: 637: 638: 639: 640: 641: 642: 643: 644: 645: 646: 647: 648: 649: 650: 651: 652: 653: 654: 655: 656: 657: 658: 659: 660: 661: 662: 663: 664: 665: 666: 667: 668: 669: 670: 671: 672: 673: 674: 675: 676: 677: 678: 679: 680: 681: 682: 683: 684: 685: 686: 687: 688: 689: 690: 691: 692: 693: 694: 695: 696: 697: 698: 699: 700: 701: 702: 703: 704: 705: 706: 707: 708: 709: 710: 711: 712: 713: 714: 715: 716: 717: 718: 719: 720: 721: 722: 723: 724: 725: 726: 727: 728: 729: 730: 731: 732: 733: 734: 735: 736: 737: 738: 739: 740: 741: 742: 743: 744: 745: 746: 747: 748: 749: 750: 751: 752: 753: 754: 755: 756: 757: 758: 759: 760: 761: 762: 763: 764: 765: 766: 767: 768: 769: 770: 771: 772: 773: 774: 775: 776: 777: 778: 779: 780: 781: 782: 783: 784: 785: 786: 787: 788: 789: 790: 791: 792: 793: 794: 795: 796: 797: 798: 799: 800: 801: 802: 803: 804: 805: 806: 807: 808: 809: 810: 811: 812: 813: 814: 815: 816: 817: 818: 819: 820: 821: 822: 823: 824: 825: 826: 827: 828: 829: 830: 831: 832: 833: 834: 835: 836: 837: 838: 839: 840: 841: 842: 843: 844: 845: 846: 847: 848: 849: 850: 851: 852: 853: 

<?php

/**
 * Class Inbound_Mailer_Post_Type registers the `inbound-email` CPT and expands UI features of the CPT listing screen
 *
 * @package Mailer
 * @subpackage  Management
 */

class Inbound_Mailer_Post_Type {

    static $stats; /* cachable/cached array of statistical data */
    static $range; /* range in days to report statistics on */
    static $automated_report; /* Tells whether to load combined or last send automated stats */

    function __construct() {
        self::load_hooks();
    }

    public static function load_hooks() {

        add_action('admin_init', array( __CLASS__ , 'rebuild_permalinks' ) );
        add_action('admin_enqueue_scripts', array( __CLASS__ ,  'check_if_scheduled_emails_sent' ) );
        add_action('init', array( __CLASS__ , 'register_post_type' ) , 1    );
        add_action('init', array( __CLASS__ , 'register_tag_taxonomy' ) , 1 );
        add_action('init', array( __CLASS__ , 'register_post_status' ) , 11 );

        /* Load Admin Only Hooks */
        if (is_admin()) {

            /* load range */
            add_action('current_screen', array( __CLASS__ , 'load_screen_options' ) );

            /* control priority of post status */
            add_filter( 'views_edit-inbound-email' , array( __CLASS__ , 'filter_post_status_priority' ));

            /* Adds support for newly added post status */
            add_action( 'admin_footer-post.php' , array( __CLASS__ , 'add_post_status' ) );

            /* Register Columns */
            add_filter( 'manage_inbound-email_posts_columns' , array( __CLASS__ , 'register_columns') );

            /* Prepare Column Data */
            add_action( "manage_posts_custom_column", array( __CLASS__ , 'prepare_column_data' ) , 10, 2 );

            /* setup column sorting */
            add_filter( "manage_edit-inbound-email_sortable_columns", array( __CLASS__ , 'define_sortable_columns' ));
            add_action( 'posts_clauses', array( __CLASS__ , 'process_column_sorting' ) , 1 , 2 );

            /* Filter Row Actions */
            add_filter( 'post_row_actions' , array( __CLASS__ , 'filter_row_actions' ) , 10 , 2 );

            /* Add Category Filter */
            add_action( 'restrict_manage_posts' , array( __CLASS__ ,'add_category_taxonomy_filter' ));

            /* Remove 'tags' & 'categories' from menu */
            add_filter( 'admin_footer' , array( __CLASS__ , 'apply_js' ) );

            /* Cache statistics data */
            add_filter( 'admin_footer' , array( __CLASS__ , 'cache_data' ) );

            /* Enqueue scripts */
            add_action( 'admin_enqueue_scripts' , array( __CLASS__ , 'enqueue_email_list_scripts') );

            /* add property to screen options */
            add_filter( 'screen_settings',array( __CLASS__ , 'add_screen_option_field'), 10, 2 );

            /* save screen options */
            add_filter( 'init', array( __CLASS__, 'set_screen_option'), 1 );
        }
    }

    /**
     * Load range
     */
    public static function load_screen_options() {
        $screen = get_current_screen();

        if ($screen->id != 'edit-inbound-email') {
            return;
        }

        self::$range = get_user_option(
            'inbound_mailer_screen_option_range',
            get_current_user_id()
        );

        self::$automated_report = get_user_option(
            'inbound_mailer_screen_option_automated_email_report',
            get_current_user_id()
        );
    }

    /**
     *  Rebuilds permalinks after activation
     */
    public static function rebuild_permalinks() {
        $activation_check = get_option('inbound_email_activate_rewrite_check',0);

        if ($activation_check) {
            global $wp_rewrite;
            $wp_rewrite->flush_rules();
            update_option( 'inbound_email_activate_rewrite_check', '0');
        }
    }

    /**
     *  Registers inbound-email post type
     */
    public static function register_post_type() {

        if ( post_type_exists( 'inbound-email' ) ) {
            return;
        }

        $email_path = apply_filters( 'inbound_email_preview_path' , 'mail' );

        $labels = array(
            'name' => __('Emails', 'inbound-email' ),
            'singular_name' => __('Email Campaigns', 'inbound-email' ),
            'add_new' => __('Add New', 'inbound-email' ),
            'add_new_item' => __('Add New Campaign' , 'inbound-email' ),
            'edit_item' => __('Edit Email ' , 'inbound-email' ),
            'new_item' => __('New Campaign' , 'inbound-email' ),
            'view_item' => __('View Email' , 'inbound-email' ),
            'search_items' => __('Search Email Campaigns' , 'inbound-email' ),
            'not_found' =>  __('Nothing found' , 'inbound-email' ),
            'not_found_in_trash' => __('Nothing found in Trash' , 'inbound-email' ),
            'parent_item_colon' => ''
        );

        $args = array(
            'labels' => $labels,
            'public' => true,
            'publicly_queryable' => true,
            'show_ui' => true,
            'query_var' => true,
            'menu_icon' => '',
            'rewrite' => array("slug" => $email_path),
            'capability_type' => 'post',
            'hierarchical' => false,
            'menu_position' => 34,
            'show_in_nav_menus' => false,
            'supports' => array()
        );

        register_post_type( 'inbound-email' , $args );

    }

    /**
     *  Register Tag Taxonomy
     */
    public static function register_tag_taxonomy() {

        register_taxonomy('inbound_email_tag','inbound-email', array(
            'hierarchical' => false,
            'label' => __( 'Tags' , 'inbound-email' ),
            'singular_label' => __( 'Tag' , 'inbound-email' ),
            'show_ui' => true,
            'show_in_nav_menus' => false,
            'query_var' => true,
            "rewrite" => false,
            'add_new_item' => __('Tag email' , 'inbound-pro' )
        ));

    }

    /**
     *      Register Columns
     */
    public static function register_columns( $cols ) {

        self::$stats = get_transient( 'inbound-email-stats-cache');
        if (!is_array(self::$stats)) {
            self::$stats = array();
        }

        $cols = array(
            "cb" => "<input type=\"checkbox\" />",
            "inbound_email_thumbnail" => __( 'Preview' , 'inbound-email' ),
            "title" => __( 'Title' , 'inbound-email' ),
            "inbound_email_type" => __( 'type' , 'inbound-email' ),
            "inbound_email_status" => __( 'status' , 'inbound-email' ),
            "inbound_email_stats" =>sprintf( __( 'statistics ( last %s days )' , 'inbound-email' ) , self::$range )

        );

        return $cols;

    }


    /**
     *      Prepare Column Data
     */
    public static function prepare_column_data( $column , $post_id ) {
        global $post, $Inbound_Mailer_Variations;

        if ($post->post_type !='inbound-email') {
            return $column;
        }

        switch ($column) {

            case "ID":
                echo $post->ID;
                break;
            case "inbound_email_thumbnail":
                $permalink = get_permalink($post->ID);
                $local = array('127.0.0.1', "::1");
                $template = $Inbound_Mailer_Variations->get_current_template($post->ID);
                $thumbnail = Inbound_Mailer_Metaboxes::get_template_thumbnail($template);
                $preview_thumbail = false;
                if(!in_array($_SERVER['REMOTE_ADDR'], $local) ){
                    $preview_thumbail = 'http://s.wordpress.com/mshots/v1/' . urlencode(esc_url($permalink)) . '?w=140';
                    $is_localhost = 'false';
                } else {
                    $is_localhost = 'true';
                }

                echo "<a title='". __('Click to Preview' , 'inbound-pro' ) ."' class='thickbox' href='".add_query_arg( array( 'TB_iframe' => 'true' , 'width'=>640 , 'height' => 763 ) , $permalink )."' target='_blank'>";
                echo "<img src='".$thumbnail."' class='preview-thumbnail' data-default-thumbnail='".$thumbnail."' data-is-localhost='".$is_localhost."'  data-preview-thumbnail='".$preview_thumbail."'  style='width:140px;height:140px;' title='".__('Click to Preview' , 'inbound-pro') ."'>";

                echo "</a>";
                break;
            case "inbound_email_type":
                $email_type = Inbound_Mailer_Metaboxes::get_email_type($post->ID);
                echo $email_type;
                break;
            case "inbound_email_status":
                echo $post->post_status;
                break;
            case "inbound_email_stats":

                /* if automated email and 'Last Send' selected then discover the last job id */
                $job_id = "0";
                if ($post->post_status == 'automated' && self::$automated_report == 'last_send') {
                    $job_id = self::get_last_job_id($post->ID);
                }
                ?>
                <div class="email-stats-container" style="background-color:#ffffff;">
                    <table class="email-stats-table">
                        <tr>
                            <td>
                                <div class="td-col-sends" data-email-id="<?php echo $post->ID; ?>" data-email-status="<?php echo $post->post_status; ?>">
                                    <img src="<?php echo INBOUND_EMAIL_URLPATH; ?>assets/images/ajax_progress.gif" class="col-ajax-spinner" style="margin-top:3px;">
                                    <a href="<?php echo admin_url('/index.php?action=inbound_generate_report&class=Inbound_Mailer_Stats_Report&range='.self::$range.'&email_id=' . $post->ID . '&job_id=' . $job_id . '&event_name=sparkpost_delivery&show_graph=false&display_lead_table=true&title=Logs&tb_hide_nav=true&TB_iframe=true&width=1000&height=600'); ?>" class="thickbox inbound-thickbox email-report-link" style=""></a>
                                </div>
                            </td>
                            <td>
                                <div class="email-square" style="width: 10px;height: 10px; border-radius: 2px;margin-top:5px;   background: green;"></div>
                            </td>
                            <td>
                                <?php echo __( 'Sends' ,'inbound-pro' ); ?>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                <div class="td-col-opens" data-email-id="<?php echo $post->ID; ?>" data-email-status="<?php echo $post->post_status; ?>">
                                    <img src="<?php echo INBOUND_EMAIL_URLPATH; ?>assets/images/ajax_progress.gif" class="col-ajax-spinner" style="margin-top:3px;">
                                    <a href="<?php echo admin_url('/index.php?action=inbound_generate_report&class=Inbound_Mailer_Stats_Report&range='.self::$range.'&email_id=' . $post->ID . '&job_id=' . $job_id . '&event_name=sparkpost_open&show_graph=false&display_lead_table=true&title=Logs&tb_hide_nav=true&TB_iframe=true&width=1000&height=600'); ?>" class="thickbox inbound-thickbox email-report-link" style=""></a>
                                </div>
                            </td>
                            <td>
                                <div class="email-square" style="width: 10px;height: 10px; border-radius: 2px;margin-top:5px;   background: cornflowerblue;"></div>
                            </td>
                            <td>
                                <?php echo __( 'Opens' ,'inbound-pro' ); ?>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                <div class="td-col-clicks" data-email-id="<?php echo $post->ID; ?>" data-email-status="<?php echo $post->post_status; ?>">
                                    <img src="<?php echo INBOUND_EMAIL_URLPATH; ?>assets/images/ajax_progress.gif" class="col-ajax-spinner" style="margin-top:3px;">
                                    <a href="<?php echo admin_url('/index.php?action=inbound_generate_report&class=Inbound_Mailer_Stats_Report&range='.self::$range.'&email_id=' . $post->ID . '&job_id=' . $job_id . '&event_name=sparkpost_click&show_graph=false&display_lead_table=true&title=Logs&tb_hide_nav=true&TB_iframe=true&width=1000&height=600'); ?>" class="thickbox inbound-thickbox email-report-link" style=""></a>
                                </div>
                            </td>
                            <td>
                                <div class="email-square" style="width: 10px;height: 10px; border-radius: 2px;margin-top:5px;   background: violet;"></div>
                            </td>
                            <td>
                                <?php echo __( 'Clicks' ,'inbound-pro' ); ?>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                <div class="td-col-unsubs" data-email-id="<?php echo $post->ID; ?>" data-email-status="<?php echo $post->post_status; ?>">
                                    <img src="<?php echo INBOUND_EMAIL_URLPATH; ?>assets/images/ajax_progress.gif" class="col-ajax-spinner" style="margin-top:3px;">
                                    <a href="<?php echo admin_url('/index.php?action=inbound_generate_report&class=Inbound_Mailer_Stats_Report&range='.self::$range.'&email_id=' . $post->ID . '&job_id=' . $job_id . '&event_name=inbound_unsubscribe&show_graph=false&display_lead_table=true&title=Logs&tb_hide_nav=true&TB_iframe=true&width=1000&height=600'); ?>" class="thickbox inbound-thickbox email-report-link" style=""></a>
                                </div>
                            </td>
                            <td>
                                <div class="email-square" style="width: 10px;height: 10px; border-radius: 2px;margin-top:5px;   background: #000;"></div>
                            </td>
                            <td>
                                <?php echo __( 'Unsubscribes' ,'inbound-pro' ); ?>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                <div class="td-col-mutes" data-email-id="<?php echo $post->ID; ?>" data-email-status="<?php echo $post->post_status; ?>">
                                    <img src="<?php echo INBOUND_EMAIL_URLPATH; ?>assets/images/ajax_progress.gif" class="col-ajax-spinner" style="margin-top:3px;">
                                    <a href="<?php echo admin_url('/index.php?action=inbound_generate_report&class=Inbound_Mailer_Stats_Report&range='.self::$range.'&email_id=' . $post->ID . '&job_id=' . $job_id . '&event_name=inbound_mute&show_graph=false&display_lead_table=true&title=Logs&tb_hide_nav=true&TB_iframe=true&width=1000&height=600'); ?>" class="thickbox inbound-thickbox email-report-link" style=""></a>
                                </div>
                            </td>
                            <td>
                                <div class="email-square" style="width: 10px;height: 10px; border-radius: 2px;margin-top:5px;   background: #000;"></div>
                            </td>
                            <td>
                                <?php echo __( 'Mutes' ,'inbound-pro' ); ?>
                            </td>
                        </tr>
                    </table>
                </div>

                <?php
                break;

        }
    }


    public static function check_if_scheduled_emails_sent() {
        $screen = get_current_screen();


        if (isset($screen) && $screen->id == 'edit-inbound-email' ) {
            $emails = get_posts( array(
                'post_type' => 'inbound-email',
                'post_status' => 'scheduled',
                'posts_per_page' => -1
            ));

            if (!$emails) {
                return;
            }

            /* if scheduled email's send time is here then mark sent and refresh */
            $updated = false;
            foreach ($emails as $email) {
                $settings = Inbound_Email_Meta::get_settings($email->ID);
                $wordpress_date_time =  date_i18n('Y-m-d G:i:s');
                $today = new DateTime($wordpress_date_time);
                $schedule_date = new DateTime($settings['send_datetime']);
                $interval = $today->diff($schedule_date);

                if ( $interval->format('%R') == '-' ) {
                    $args = array(
                        'ID' => $email->ID,
                        'post_status' => 'sent',
                    );

                    wp_update_post( $args );

                    $updated = true;
                }
            }

            /* if any email's statuses were updated then refresh page */
            if ($updated) {
                header('Location: ' . admin_url('edit.php?post_type=inbound-email'));
                exit;
            }

        }
    }

    /**
     * Defines sortable columns
     * @param $columns
     * @return mixed
     */
    public static function define_sortable_columns($columns) {

        $columns['inbound_email_type'] = 'inbound_email_type';
        $columns['inbound_email_status'] = 'inbound_email_status';

        return $columns;
    }

    public static function process_column_sorting(  $pieces, $query ) {

        global $wpdb, $table_prefix;

        if (!isset($_GET['post_type']) || $_GET['post_type'] != 'inbound-email') {
            return $pieces;
        }

        if ( $query->is_main_query() && ( $orderby = $query->get( 'orderby' ) ) ) {
            $order = strtoupper( $query->get( 'order' ) );

            if ( ! in_array( $order, array( 'ASC', 'DESC' ) ) ) {
                $order = 'ASC';
            }

            switch( $orderby ) {

                case 'inbound_email_type':

                    $pieces[ 'orderby' ] = " {$wpdb->posts}.post_status ";

                    break;


            }
        } else {
            $pieces[ 'orderby' ] = " post_modified  DESC , " . $pieces[ 'orderby' ];
        }


        return $pieces;
    }

    /**
     *  Registers all post status types related to the inbound-email cpt
     *  @adds post_status unsent
     *  @adds post_status sent
     *  @adds post_status sending
     *  @adds post_status scheduled
     *  @adds post_status automated
     */
    public static function register_post_status() {

        /* unsent */
        register_post_status( 'unsent', array(
            'label' => __( 'Unsent', 'inbound-email' ),
            'public' => true,
            'show_in_admin_all_list' => true,
            'show_in_admin_status_list' => true,
            'label_count' => _n_noop( 'Unsent <span class="count">(%s)</span>', 'Unsent <span class="count">(%s)</span>' )
        ));


        /* sent */
        register_post_status( 'sent', array(
            'label' => __( 'Sent', 'inbound-email' ),
            'public' => !is_admin(),
            'show_in_admin_all_list' => false,
            'show_in_admin_status_list' => true,
            'label_count' => _n_noop( 'Sent <span class="count">(%s)</span>', 'Sent <span class="count">(%s)</span>' )
        ));


        /* cancelled */
        register_post_status( 'cancelled', array(
            'label' => __( 'Cancelled', 'inbound-email' ),
            'public' => !is_admin(),
            'show_in_admin_all_list' => false,
            'show_in_admin_status_list' => true,
            'label_count' => _n_noop( 'Cancelled <span class="count">(%s)</span>', 'Cancelled <span class="count">(%s)</span>' )
        ));

        /* automated */
        register_post_status( 'sending', array(
            'label' => __( 'Sending', 'inbound-email' ),
            'public' => true,
            'show_in_admin_all_list' => false,
            'show_in_admin_status_list' => true,
            'label_count' => _n_noop( 'Sending <span class="count">(%s)</span>', 'Sending <span class="count">(%s)</span>' )
        ));

        /* scheduled */
        register_post_status( 'scheduled', array(
            'label' => __( 'Scheduled', 'inbound-email' ),
            'public' => !is_admin(),
            'show_in_admin_all_list' => true,
            'show_in_admin_status_list' => true,
            'label_count' => _n_noop( 'Scheduled <span class="count">(%s)</span>', 'Scheduled <span class="count">(%s)</span>' )
        ));

        /* automated */
        register_post_status( 'automated', array(
            'label' => __( 'Automated', 'inbound-pro' ),
            'public' => !is_admin(),
            'show_in_admin_all_list' => false,
            'show_in_admin_status_list' => true,
            'label_count' => _n_noop( 'Automated <span class="count">(%s)</span>', 'Automated <span class="count">(%s)</span>' )
        ));

        /* direct_email */
        $public = (current_user_can('administrator') && !is_admin()) ? true : false;
        register_post_status( 'direct_email', array(
            'label' => __( 'Direct Emails', 'inbound-pro' ),
            'public' => $public,
            'show_in_admin_all_list' => false,
            'show_in_admin_status_list' => true,
            'label_count' => _n_noop( 'Direct Emails <span class="count">(%s)</span>', 'Direct Emails <span class="count">(%s)</span>' )
        ));
    }

    /**
     *  Adds dropdown support for added post status
     */
    public static function add_post_status() {
        global $post;

        if($post->post_type == 'inbound-email'){

            $statuses = array(
                'automated' => __( 'Automated' , 'inbound-pro' ) ,
                'unsent' => __( 'Unsent' , 'inbound-pro' ) ,
                'sent' => __( 'Sent' , 'inbound-pro' ) ,
                'cancelled' => __( 'Cancelled' , 'inbound-pro' ) ,
                'scheduled' => __( 'Scheduled' , 'inbound-pro'),
                'sending' => __( 'Sending' , 'inbound-pro'),
                'direct_email' => __( 'Direct Emails' , 'inbound-pro' ) ,
            );

            echo '<script type="text/javascript">';
            echo 'jQuery(document).ready(function(){';
            foreach ( $statuses as $status => $label ) {

                $complete = '';
                $this_label = '';

                if ( $post->post_status == $status ) {
                    $complete = ' selected=\"selected\"';
                }

                echo '
                    jQuery("select#post_status").append("<option value=\"'.$status.'\" '.$complete.'>'.$label.'</option>");
                ';
            }
            echo '});';
            echo '</script>';
        }
    }

    /**
     * Hooked into 'screen_settings'. Adds the field to the settings area
     *
     * @access public
     * @return string The settings fields
     */

    public static function add_screen_option_field($rv, $screen) {

        $screen = get_current_screen();

        $whitelist = array('edit-inbound-email','inbound-email');
        if (!$screen || !in_array( $screen->id , $whitelist ) ) {
            return $rv;
        }

        self::$range = (self::$range) ? self::$range : 90;
        self::$automated_report = (self::$automated_report) ? self::$automated_report : 'combine';

        $rv .= '<fieldset class="">';

        $rv .= '<legend>' . __('Email Statistics' , 'inbound-pro') . '</legend>';

        $rv .=  __('Reporting range in days' , 'inbound-pro' ). ': ';

        /* Select screen option range */
        $rv .= '<select  name="inbound_mailer_screen_option_range" class="" id="" style="width:100px;" >';

        $ranges = array(1,7,30,90,365);

        foreach ($ranges as $range) {
            $rv .= '<option value="'.$range.'" '. ( self::$range==$range ? 'selected="true"' : '' ).'">'.$range.' ' . __('days','inbound-pro') .'</option>';
        }

        $rv .= '</select></fieldset>';

        /* set automated emails to show combined report or last send */
        $rv .=  __('Automated email reporting' , 'inbound-pro' ). ': ';

        $rv .= '<label><input type="radio"  name="inbound_mailer_screen_option_automated_email_report" value="0" '. checked( 'combine'  , self::$automated_report , false ) .'>'.__('Combined Sends','inbound-pro').'</label>';
        $rv .= '<label><input type="radio"  name="inbound_mailer_screen_option_automated_email_report" value="last_send" '. checked( 'last_send' , self::$automated_report , false ) .'>'.__('Last Send','inbound-pro').'</label>';

        $rv .= '</fieldset>';

        return $rv;

    }

    /**
     * Listen for updated screen option and save.
     *
     */
    public static function set_screen_option() {

        /* return if flag screen option not present */
        if (isset($_POST['inbound_mailer_screen_option_range'])) {
            /* update range on email listing screen */
            $response = update_user_option(
                get_current_user_id(),
                'inbound_mailer_screen_option_range',
                intval($_POST['inbound_mailer_screen_option_range'])
            );

            /* clear transient statistics cache */
            delete_transient('inbound-email-stats-cache');

        }


        if (isset($_POST['inbound_mailer_screen_option_automated_email_report'])) {
            /* update setting that controls how to report automated email statistics */
            $response = update_user_option(
                get_current_user_id(),
                'inbound_mailer_screen_option_automated_email_report',
                sanitize_text_field($_POST['inbound_mailer_screen_option_automated_email_report'])
            );

            /* clear transient statistics cache */
            delete_transient('inbound-email-stats-cache');
        }

    }

    /**
     *  Add admin js that removes menu items
     */
    public static function apply_js() {
        global $post;

        if (!isset($post) || $post->post_type!='inbound-email') {
            return;
        }
        ?>
        <script type='text/javascript'>

            jQuery( document ).ready( function() {
                var i = 0;
                jQuery('#menu-posts-inbound-email li').each( function() {
                    if ( i==3  ) {
                        jQuery(this).hide();
                    }
                    i++;
                });

                /* hide visibility toggle */
                jQuery('.misc-pub-visibility').hide();

                /* hide scheduling toggle */
                jQuery('.misc-pub-curtime').hide();

                /* Add post status to quick edit */
                (function($){
                    jQuery( "select[name=_status]" ).each(
                        function () {
                            var value = $( this ).val();

                            jQuery("option[value=pending]", this).after("<option value='sent'>Sent</option>");
                            jQuery("option[value=pending]", this).after("<option value='unsent'>Unsent</option>");
                            jQuery("option[value=pending]", this).after("<option value='automted'>Automated</option>");

                        }
                    );
                })(jQuery);

                jQuery('.preview-thumbnail').mouseout(function () {
                    jQuery(this).attr('src', jQuery(this).attr('data-default-thumbnail'));
                });

                jQuery('.preview-thumbnail').mouseover(function () {
                    if (jQuery(this).attr('data-is-localhost')=='false') {
                        jQuery(this).attr('src', jQuery(this).attr('data-preview-thumbnail'));
                    }
                });

            });

        </script>
        <?php
    }

    /**
     *      Define Row Actions
     */
    public static function filter_row_actions( $actions , $post ) {

        if ($post->post_type=='inbound-email') {
            //unset($actions['inline hide-if-no-js']);
            $actions['clear'] = '';
        }

        return $actions;

    }


    /**
     * rebuild priority of post status links
     * @param ARRAY $links
     * @return ARRAY $new_links
     */
    public static function filter_post_status_priority( $links ) {
        //$new_links['all'] = $links['unsent'];
        $new_links = array();

        if (isset($links['draft'])) {
            $new_links['draft'] =  $links['draft'];
        }
        if (isset($links['pending'])) {
            $new_links['pending'] =  $links['pending'];
        }
        if (isset($links['sending'])) {
            $new_links['sending'] =  $links['sending'];
        }
        if (isset($links['sent'])) {
            $new_links['sent'] =  $links['sent'];
        }
        if (isset($links['unsent'])) {
            $new_links['unsent'] =  $links['unsent'];
        }
        if (isset($links['automated'])) {
            $new_links['automated'] =  $links['automated'];
        }
        if (isset($links['scheduled'])) {
            $new_links['scheduled'] =  $links['scheduled'];
        }
        if (isset($links['direct_email'])) {
            $new_links['direct_email'] =  $links['direct_email'];
        }
        if (isset($links['trash'])) {
            $new_links['trash'] =  $links['trash'];
        }

        return $new_links;
    }

    /**
     *      Adds ability to filter email templates by custom post type
     */
    public static function add_category_taxonomy_filter() {
        global $post_type;

        if ($post_type === "inbound-email") {
            $post_types = get_post_types( array( '_builtin' => false ) );
            if ( in_array( $post_type, $post_types ) ) {
                $filters = get_object_taxonomies( $post_type );

                foreach ( $filters as $tax_slug ) {
                    $tax_obj = get_taxonomy( $tax_slug );
                    (isset($_GET[$tax_slug])) ? $current = sanitize_text_field($_GET[$tax_slug]) : $current = 0;
                    wp_dropdown_categories( array(
                        'show_option_all' => __('Show All '.$tax_obj->label ),
                        'taxonomy'      => $tax_slug,
                        'name'          => $tax_obj->name,
                        'orderby'       => 'name',
                        'selected'      => $current,
                        'hierarchical'      => $tax_obj->hierarchical,
                        'show_count'        => false,
                        'hide_empty'        => true
                    ) );
                }
            }
        }
    }


    /**
     *      Clears stats of all CTAs
     */
    public static function clear_all_inbound_email_stats() {
        $ctas = get_posts( array(
            'post_type' => 'inbound-email',
            'posts_per_page' => -1
        ));


        foreach ($ctas as $cta) {
            Inbound_Mailer_Post_Type::clear_inbound_email_stats( $cta->ID );
        }
    }

    /**
     *  Tells the 'email-templates' menu item to sit as a submenu in the 'inbound-email' parent menu
     */
    public static function set_email_template_menu_location() {
        return 'inbound-email';
    }

    /**
     *  Tells the 'email-templates' label to be 'Templates' instead of 'Email Templates'
     */
    public static function set_email_template_labels( $labels ) {
        $labels['name'] = __('Templates', 'inbound-emails');
        $labels['singular_name'] = __('Templates', 'inbound-emails');

        return $labels;
    }

    /**
     * Get last job id for automated email given an email id
     * @param  INT $email_id
     * @return INT last job id related to email recorded in inbound_events table
     */
    public static function get_last_job_id($email_id) {
        global $wpdb;

        $table_name = $wpdb->prefix . "inbound_events";

        $query = 'SELECT DISTINCT( job_id ) FROM '.$table_name . " WHERE email_id = '".$email_id."'  ORDER BY job_id DESC LIMIT 1";

        $job_ids = $wpdb->get_results( $query , ARRAY_A );

        return (isset($job_ids[0])) ? $job_ids[0]['job_id'] : 0;
    }


    /**
     *  Get Automation Emails
     *  @param STRING $return_type OBEJCT or ARRAY
     */
    public static function get_automation_emails_as( $return_type = 'OBJECT' ) {

        //self::register_post_type();
        self::register_post_status();

        $emails = get_posts( array(
            'numberposts' => -1 ,
            'post_status' => 'automated',
            'post_type' => 'inbound-email'
        ));

        //print_r($emails);

        if ( $return_type == 'OBJECT' ) {
            return $emails;
        }

        $array = array();
        foreach ( $emails as $email ) {
            $array[ $email->ID ] = $email->post_title;
        }

        return $array;
    }

    public static function cache_data() {
        if (!get_transient('inbound-email-stats-cache')) {

        }
    }

    /**
     * Enqueues scripts for the email list page
     */
    public static function enqueue_email_list_scripts(){

        wp_enqueue_style('thickbox-css', '/wp-includes/js/thickbox/thickbox.css');

    }

}

/* Load Post Type Pre Init */
new Inbound_Mailer_Post_Type();