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:  854:  855:  856:  857:  858:  859:  860:  861:  862:  863:  864:  865:  866:  867:  868:  869:  870:  871:  872:  873:  874:  875:  876:  877:  878:  879:  880:  881:  882:  883:  884:  885:  886:  887:  888:  889:  890:  891:  892:  893:  894:  895:  896:  897:  898:  899:  900:  901:  902:  903:  904:  905:  906:  907:  908:  909:  910:  911:  912:  913:  914:  915:  916:  917:  918:  919:  920:  921:  922:  923:  924:  925:  926:  927:  928:  929:  930:  931:  932:  933:  934:  935:  936:  937:  938:  939:  940:  941:  942:  943:  944:  945:  946:  947:  948:  949:  950:  951:  952:  953:  954:  955:  956:  957:  958:  959:  960:  961:  962:  963:  964:  965:  966:  967:  968:  969:  970:  971:  972:  973:  974:  975:  976:  977:  978:  979:  980:  981:  982:  983:  984:  985:  986:  987:  988:  989:  990:  991:  992:  993:  994:  995:  996:  997:  998:  999: 1000: 1001: 1002: 1003: 1004: 1005: 1006: 1007: 1008: 1009: 1010: 1011: 1012: 1013: 1014: 1015: 1016: 1017: 1018: 1019: 1020: 1021: 1022: 1023: 1024: 1025: 1026: 1027: 1028: 1029: 1030: 1031: 1032: 1033: 1034: 1035: 1036: 1037: 1038: 1039: 1040: 1041: 1042: 1043: 1044: 1045: 1046: 1047: 1048: 1049: 1050: 1051: 1052: 1053: 1054: 1055: 1056: 1057: 1058: 1059: 1060: 1061: 1062: 1063: 1064: 1065: 1066: 1067: 1068: 1069: 1070: 1071: 1072: 1073: 1074: 1075: 1076: 1077: 1078: 1079: 1080: 1081: 1082: 1083: 1084: 1085: 1086: 1087: 1088: 1089: 1090: 1091: 1092: 1093: 1094: 1095: 1096: 1097: 1098: 1099: 1100: 1101: 1102: 1103: 1104: 1105: 1106: 1107: 1108: 1109: 1110: 1111: 1112: 1113: 1114: 1115: 1116: 1117: 1118: 1119: 1120: 1121: 1122: 1123: 1124: 1125: 1126: 1127: 1128: 1129: 1130: 1131: 1132: 1133: 1134: 1135: 1136: 1137: 1138: 1139: 1140: 1141: 1142: 1143: 1144: 1145: 1146: 1147: 1148: 1149: 1150: 1151: 1152: 1153: 1154: 1155: 1156: 1157: 1158: 1159: 1160: 1161: 1162: 1163: 1164: 1165: 1166: 1167: 1168: 1169: 1170: 1171: 1172: 1173: 1174: 1175: 1176: 1177: 1178: 1179: 1180: 1181: 1182: 1183: 1184: 1185: 1186: 1187: 1188: 1189: 1190: 1191: 1192: 1193: 1194: 

<?php
/**
 * Report Template
 * @package     InboundPro
 * @subpackage  ReportTemplate
 */

if (!class_exists('Inbound_Mailer_Stats_Report')) {

    class Inbound_Mailer_Stats_Report extends Inbound_Reporting_Templates {

        static $range;
        static $page;
        static $offset;
        static $limit;
        static $total_events;
        static $total_pages;
        static $graph_data;
        static $top_variations;
        static $start_date;
        static $end_date;
        static $past_start_date;
        static $past_end_date;
        static $possible_actions;
        static $job_id;
        static $events = array();


        /**
         *  Load & display the template report
         *
         */
        public static function load_template() {
            self::load_data();

            self::display_header();
            self::print_css();
            parent::display_filters();
            self::display_chart();
            self::display_top_email_variations();
            self::display_all_events();
            parent::js_lead_table_sort();
            die();
        }

        /**
         * Shows report header
         */
        public static function display_header() {

            $title = get_the_title(intval($_REQUEST['email_id']));
            $permalink = get_the_permalink(intval($_REQUEST['email_id']));
            $default_gravatar = INBOUND_PRO_URLPATH . 'assets/images/gravatar-unknown.png';

            ?>
            <head>
                <script type="text/javascript" src="<?php echo INBOUND_PRO_URLPATH ;?>assets/libraries/echarts/echarts.min.js"  /></script>
            </head>
            <aside class="profile-card">
                <header>
                    <h1><?php _e('Email Report Stats' , 'inbound-pro'); ?></h1>
                    <h2><?php echo $title; ?></h2>
                    <h3><a href="<?php echo $permalink; ?>" target="_self"><?php echo $permalink; ?></a></h3>
                </header>
            </aside>
            <?php
        }

        /*
         * Displays the email event stat data on a chart
         **/
        public static function display_chart() {

            self::$graph_data['current']= self::prepare_chart_data(self::$start_date, self::$end_date , 'current', intval($_REQUEST['email_id']));

            /* loop through  */
            ?>
            <div id="graph-container" style='height:350px;'></div>
            <script type="text/javascript">
                // based on prepared DOM, initialize echarts instance
                var myChart = echarts.init(document.getElementById('graph-container'));

                // specify chart configuration item and data
                var option = {
                    title: {
                        text: ''
                    },
                    tooltip : {
                        trigger: 'axis'
                    },
                    legend: {
                        data:['<?php echo sprintf( __('%s past %s days','inbound-pro') , self::$possible_actions[$_REQUEST['event_name']], self::$range ); ?>']
                    },
                    toolbox: {
                        show : true,
                        feature : {
                            mark : {show: true},
                            dataView : {show: true, readOnly: false},
                            magicType : {show: true, type: ['line', 'bar', 'stack', 'tiled']},
                            restore : {show: true},
                            saveAsImage : {show: true}
                        }
                    },
                    calculable : true,
                    grid: {
                        left: '3%',
                        right: '4%',
                        bottom: '3%',
                        containLabel: true
                    },
                    xAxis : [
                        {
                            type : 'category',
                            boundaryGap : false,
                            data : <?php echo json_encode(self::$graph_data['current']['dates']); ?>

                        }
                    ],
                    yAxis : [
                        {
                            type : 'value'
                        }
                    ],
                    series : [

                        {
                            name:'<?php echo sprintf( __('%s over the past %s days','inbound-pro') , self::$possible_actions[$_REQUEST['event_name']], self::$range ); ?>',
                            type:'line',//55ddff , 55ff77
                            itemStyle: {normal: {color:'#55ddff', label:{show:false}}},
                            areaStyle: {normal: {color:'#55ddff', label:{show:true}}},
                            data:<?php echo json_encode(self::$graph_data['current']['actions_counted']); ?>

                        }
                    ]

                };
                // use configuration item and data specified to show chart
                myChart.setOption(option);
            </script>
            <?php
        }

        /**
         * Displays a list of the email's variation action stats
         */
        public static function display_top_email_variations() {
            $email = get_post(intval($_REQUEST['email_id']));

            /* if there are no stored actions for this variation, output a message and exit */
            if(empty(self::$top_variations)){
                ?>
                <div class="flexbox-container email-variation-stats-container">
                    <div>
                        <h3><?php echo sprintf(__('No %s Logged For This Email', 'inbound-pro'), self::$possible_actions[$_REQUEST['event_name']]); ?></h3>
                    </div>
                </div>
                <?php
                return;
            }

            ?>
            <div class="flexbox-container email-variation-stats-container">
                <div>
                    <table class="email-variation-stats">
                        <thead>
                        <tr>
                            <th scope="col" class="">
                                <span><?php _e('Email Variation' , 'inbound-pro'); ?></span>
                            </th>
                            <th scope="col" class="">
                                <span><?php echo sprintf(__('Total %s For This Variation', 'inbound-pro'), self::$possible_actions[$_REQUEST['event_name']]); ?></span>
                            </th>
                        </tr>
                        </thead>
                        <tbody id="">

                        <?php
                        $variation_letters = array(
                         'A', 'B', 'C', 'D', 'E', 'F',
                         'G', 'H', 'I', 'J', 'K', 'L',
                         'M', 'N', 'O', 'P', 'Q', 'R',
                         'S', 'T', 'U', 'V', 'W', 'X',
                         'Y', 'Z');

                        $i = 0;
                        foreach(self::$top_variations as $variant_id => $action_count){
                            //if($i >= 10){break;}//uncomment to make this a top 10 list
                            ?>
                            <tr id="" class="">
                                <td class="">
                                    <span class="top-count-num">
                                        <a href="<?php echo admin_url('post.php?post=' . intval($_REQUEST['email_id']) . '&inbvid=' . $variant_id . '&action=edit'); ?>" target="_self">
                                            <?php echo $variation_letters[$variant_id]; ?>
                                        </a>
                                    </span>
                                </td>
                                <td class="">
                                    <?php
                                    echo $action_count;
                                    ?>
                                </td>
                            </tr>
                            <?php
                            $i++;
                        }
                        ?>
                        </tbody>
                    </table>

                </div>
            </div>
            <?php
        }

        /**
         * Displays a sortable list of all leads that have had an interaction with the given email
         */
        public static function display_all_events(){

            /*exit if there's no lead data to show or if the lead table isn't supposed to show*/
            if(empty(self::$events) || $_REQUEST['display_lead_table'] !== 'true'){
                return;
            }

            /* array to store tokens and urls into memory to save database calls */
            $url_array = array();

            $variation_letters = array(
             'A', 'B', 'C', 'D', 'E', 'F',
             'G', 'H', 'I', 'J', 'K', 'L',
             'M', 'N', 'O', 'P', 'Q', 'R',
             'S', 'T', 'U', 'V', 'W', 'X',
             'Y', 'Z');

            ?>
            <div class="flexbox-container lead-action-data-list">
                <div>
                    <table>
                        <thead>
                            <tr>
                                <th><?php _e('Avatar', 'inbound-pro'); ?></th>
                                <th class="sort-lead-report-by" sort-by="report-name-field-header">
                                    <?php _e('Lead Name', 'inbound-pro'); ?>
                                </th>
                                <?php
                                 if ( $_REQUEST['event_name'] == 'sparkpost_click' ) {
                                 ?>
                                     <th class="sort-lead-report-by" sort-by="report-email-variation-header">
                                         <?php _e('URL', 'inbound-pro'); ?>
                                     </th>
                                 <?php
                                 }
                                 ?>
                                 <?php
                                 if ( $_REQUEST['event_name'] == 'sparkpost_rejected' ) {
                                 ?>
                                     <th class="sort-lead-report-by" sort-by="report-email-variation-header">
                                         <?php _e('Reason', 'inbound-pro'); ?>
                                     </th>
                                 <?php
                                 }
                                 ?>
                                 <?php
                                 if ( $_REQUEST['event_name'] == 'inbound_unsubscribe' ) {
                                 ?>
                                     <th class="sort-lead-report-by" sort-by="report-email-variation-header">
                                         <?php _e('Message', 'inbound-pro'); ?>
                                     </th>
                                 <?php
                                 }
                                 ?>
                                <th class="sort-lead-report-by" sort-by="report-email-variation-header">
                                    <?php echo sprintf(__('Email Variation %s', 'inbound-pro'), self::$possible_actions['singular_form'][$_REQUEST['event_name']]); ?>
                                </th>
                                <th class="sort-lead-report-by" sort-by="report-date-header" sort-order="0">
                                    <?php echo sprintf(__('Email %s On', 'inbound-pro'), self::$possible_actions['singular_form'][$_REQUEST['event_name']]); ?>
                                    <i class="fa fa-caret-up lead-report-sort-indicater" aria-hidden="true" style="padding-left:4px"></i>
                                </th>
                            </tr>
                        </thead>
                        <tbody id="the-list">
                            <?php
                            $logged_event = array();
                            $action_number = 0;
                            foreach(self::$events as $index => $event){

                                /*if a lead has been sent the same email variation more than once, skip*/
                                if(isset($logged_event[$event['variation_id']][$event['lead_id']])){
                                    continue;
                                }
                                $logged_event[$event['variation_id']][$event['lead_id']] = 1;

                                $lead = get_post($event['lead_id']);

                                $lead_exists = ($lead) ? true : false;

                                if($lead_exists){
                                    $lead_first_name = get_post_meta($lead->ID, 'wpleads_first_name', true);
                                    $lead_last_name = get_post_meta($lead->ID, 'wpleads_last_name', true);

                                    $lead_name = trim($lead_first_name . ' ' . $lead_last_name);

                                }else{
                                    $lead_name = __('Lead Deleted', 'inbound-pro');
                                }

                                ?>
                            <tr class="lead-table-data-report-row" data-name-field="<?php echo $lead_name; ?>" data-email-variation="<?php echo $event['variation_id']; ?>" data-date-number="<?php echo $action_number;?>">
                                <td class="lead-avatar">
                                    <?php $gravatar = ($lead_exists) ? Leads_Post_Type::get_gravatar($event['lead_id']) : $default_gravatar;
                                    echo '<img class="lead-grav-img " width="40" height="40" src="' . $gravatar . '">'; ?>
                                </td>
                                <td class="lead-name">
                                    <a href="<?php echo admin_url('post.php?post=' . $event['lead_id'] . '&action=edit&small_lead_preview=true&tb_hide_nav=true'); ?>"><?php echo $lead_name; ?></a>
                                </td>
                                <?php
                                if ( $_REQUEST['event_name'] == 'sparkpost_click' ) {
                                    $event_details = json_decode($event['event_details'] , true);

                                    $tracking_endpoint = apply_filters( 'inbound_event_endpoint', 'inbound' );

                                    if (strstr($event_details['target_link_url'] , '?token')) {
                                        $args['url'] = $event_details['target_link_url'];
                                        $args['label'] =__('Unsubscribe' , 'inbound-pro');

                                    } else if (strstr($event_details['target_link_url'], $tracking_endpoint)) {
                                        $token = end(explode('/', $event_details['target_link_url']));
                                        $args = Inbound_API::get_args_from_token($token);
                                        $args['url'] = ($args['url']) ? $args['url'] : '#'.$token;
                                        $args['label'] = ($args['url']) ? $args['url'] : sprintf(__('No URL for token %s' , 'inbound-pro') , $token);
                                    } else {
                                        $args['url'] = $event_details['target_link_url'];
                                        $args['label'] = $event_details['target_link_url'];
                                    }
                                    ?>
                                    <td class="clicked-url">
                                        <?php
                                        if (strstr($args['url'],':')) {
                                            echo '<a href="'.$args['url'].'" target="_blank">'.$args['label'].'</a>';
                                        } else {
                                            echo $args['label'];
                                        }
                                        ?>
                                    </td>
                                    <?php
                                }
                                ?>
                                <?php
                                if ( $_REQUEST['event_name'] == 'sparkpost_rejected' ) {
                                    $event_details = json_decode($event['event_details'] , true);

                                    ?>
                                    <td class="clicked-url">
                                      <?php echo (isset($event_details['description'])) ? $event_details['description'] : __('no reason supplied' , 'inbound-pro'); ?>
                                    </td>
                                    <?php
                                }
                                ?>
                                <?php
                                if ( $_REQUEST['event_name'] == 'inbound_unsubscribe' ) {
                                    $event_details = json_decode($event['event_details'] , true);

                                    ?>
                                    <td class="unsubscribe-message">
                                      <?php echo (isset($event_details['comments'])) ? sanitize_text_field($event_details['comments']) : __('...' , 'inbound-pro'); ?>
                                    </td>
                                    <?php
                                }
                                ?>
                                <td class="email-variation"><?php echo $variation_letters[$event['variation_id']]; ?></td>
                                <td class="datestamp">
                                    <p class="mod-date" >
                                        <em> <?php echo date("F j, Y, g:i a" , strtotime($event['datetime'])); ?></em>
                                    </p>
                                </td>
                            </tr>
                            <?php
                                $action_number++;
                            }   ?>
                        </tbody>
                        <tfoot>
                            <tr>
                                <th><?php _e('Avatar', 'inbound-pro'); ?></th>
                                <th class="sort-lead-report-by" sort-by="report-name-field-header">
                                    <?php _e('Lead Name', 'inbound-pro'); ?>
                                </th>
                                <?php
                                 if ( $_REQUEST['event_name'] == 'sparkpost_click' ) {
                                 ?>
                                     <th class="sort-lead-report-by" sort-by="report-email-variation-header">
                                         <?php _e('URL', 'inbound-pro'); ?>
                                     </th>
                                 <?php
                                 }
                                 ?>
                                <?php
                                 if ( $_REQUEST['event_name'] == 'sparkpost_rejected' ) {
                                 ?>
                                     <th class="sort-lead-report-by" sort-by="report-email-variation-header">
                                         <?php _e('Reason', 'inbound-pro'); ?>
                                     </th>
                                 <?php
                                 }

                                 if ( $_REQUEST['event_name'] == 'inbound_unsubscribe' ) {
                                 ?>
                                     <th class="sort-lead-report-by" sort-by="report-email-variation-header">
                                         <?php _e('Message', 'inbound-pro'); ?>
                                     </th>
                                 <?php
                                 }
                                 ?>
                                <th class="sort-lead-report-by" sort-by="report-email-variation-header">
                                    <?php echo sprintf(__('Email Variation %s', 'inbound-pro'), self::$possible_actions['singular_form'][$_REQUEST['event_name']]); ?>
                                </th>
                                <th class="sort-lead-report-by" sort-by="report-date-header">
                                    <?php echo sprintf(__('Email %s On', 'inbound-pro'), self::$possible_actions['singular_form'][$_REQUEST['event_name']]); ?>
                                    <i class="fa fa-caret-up lead-report-sort-indicater" aria-hidden="true" style="padding-left:4px"></i>
                                </th>
                            </tr>
                        </tfoot>
                    </table>
                    <select id="limit-select">
                            <option value="50" <?php selected(self::$limit , '50'); ?>>50 <?php _e('per page' , 'inbound-pro'); ?></option>
                            <option value="100" <?php selected(self::$limit , '100'); ?>>100 <?php _e('per page' , 'inbound-pro'); ?></option>
                            <option value="300" <?php selected(self::$limit , '300'); ?>>300 <?php _e('per page' , 'inbound-pro'); ?></option>
                            <option value="500" <?php selected(self::$limit , '500'); ?>>500 <?php _e('per page' , 'inbound-pro'); ?></option>
                    </select>
                    <script type="text/javascript">
                        /**
                         *  reloads the report template with an updated limit value
                         */
                        function reload_limit(name, value) {
                            var str = location.search;
                            if (new RegExp("[&?]"+name+"([=&].+)?$").test(str)) {
                                str = str.replace(new RegExp("(?:[&?])"+name+"[^&]*", "g"), "")
                            }
                            str += "&";
                            str += name + "=" + value;
                            str = "?" + str.slice(1);
                            // there is an official order for the query and the hash if you didn't know.
                            location.assign(location.origin + location.pathname + str + location.hash)
                        };

                        /* on page load */
                        (function() {
                            var limit_select = document.getElementById('limit-select');

                            limit_select.onchange = function() {
                                var elem = (typeof this.selectedIndex === "undefined" ? window.event.srcElement : this);
                                var value = elem.value || elem.options[elem.selectedIndex].value;

                                reload_limit('limit' , value);
                            }
                        })();
                    </script>
                    <div class="pagination">

                        <?php
                        $url = basename($_SERVER['REQUEST_URI']);
                        parse_str($url , $report_args);

                        $report_args = array('action' => $report_args['index_php?action']) + $report_args;
                        unset($report_args['index_php?action']);
                        unset($report_args['index_php?class']);
                        unset($report_args['tb_hide_nav']);
                        unset($report_args['TB_iframe']);
                        if( self::$page > 1 ){
                            $report_args['page_number'] = self::$page - 1;
                            $link = add_query_arg( $report_args , admin_url( 'index.php' ) );
                            echo '<a href="' . $link . '" >&laquo;</a>';
                        }

                        for ($i=0;$i<self::$total_pages;$i++) {
                            $page_num = $i +1;
                            $report_args['page_number'] = $page_num;
                            $link = add_query_arg( $report_args , admin_url('index.php') );

                            echo '<a href="' . $link . '" ' . (self::$page == $page_num ? 'class="active"' : '' ) . '>' . $page_num . '</a>';
                        }

                        if( self::$offset  < self::$total_events ){
                            $report_args['page_number'] = self::$page + 1;
                            $link = add_query_arg( $report_args , admin_url( 'index.php' ) );
                            echo '<a href="' . $link . '">&raquo;</a>';
                        }
                        ?>

                    </div>
                </div>
            </div>


            <?php


        }

        /**
         * Print Report CSS rules into the document
         */
        public static function print_css() {

            ?>
            <style type="text/css">
                body {
                    font-family: sans-serif;
                    color: #444;
                }
                table {
                    border-spacing: 0;
                    margin-bottom: 1rem;
                    border-radius: 0;
                    font-size: 9px;
                    width:100%;
                }

                th {
                    background-color: #f1f1f1;
                    color:#000;
                    -webkit-user-select: none;
                    -moz-user-select: none;
                    -user-select: none;
                }

                th,
                td {
                    min-width: 70px;
                    padding: 10px 5px;
                    text-align:center;
                }

                tbody tr:nth-child(even) {
                    background-color: #f1f1f1;
                }

                #search {
                    margin-bottom: 10px;
                }

                #page-navigation {
                    display: flex;
                    margin-top: 5px;
                }

                #page-navigation p {
                    margin-left: 5px;
                    margin-right: 5px;
                }

                #page-navigation button {
                    background-color: #42b983;
                    border-color: #42b983;
                    color: rgba(255, 255, 255, 0.66);
                }

                .lead-grav-img {
                    background: #FCFDFE;
                    border: 1px solid #E0E0E0;
                    -moz-border-radius:  0px;
                    border-radius: 0px;
                }
                a {
                    color:#1585cf;
                    text-decoration:none;
                }

                .fa-sort-desc {
                    position:relative;
                    top:-2px;
                    left:2px;
                }

                /* header */
                @import url(http://fonts.googleapis.com/css?family=Lato:300,400);
                @-webkit-keyframes pulsate {
                    0% {
                        -webkit-transform: scale(0.6, 0.6);
                        transform: scale(0.6, 0.6);
                        opacity: 0.0;
                    }
                    50% {
                        opacity: 1.0;
                    }
                    100% {
                        -webkit-transform: scale(1, 1);
                        transform: scale(1, 1);
                        opacity: 0.0;
                    }
                }
                @keyframes pulsate {
                    0% {
                        -webkit-transform: scale(0.6, 0.6);
                        transform: scale(0.6, 0.6);
                        opacity: 0.0;
                    }
                    50% {
                        opacity: 1.0;
                    }
                    100% {
                        -webkit-transform: scale(1, 1);
                        transform: scale(1, 1);
                        opacity: 0.0;
                    }
                }
                body {
                    background-repeat: repeat, no-repeat;
                    background-size: auto, 100% 100%;
                    background-attachment: fixed;
                    margin:0px;

                }

                .profile-card {
                    height: 125px;
                    position: relative;
                    background-position: 50% 50%;
                    background-repeat: no-repeat;
                    background-size: cover;
                    background-color:#1a1d23;
                    color: #ecf0f1;
                    font-family: "Lato", "Helvetica Neue",Helvetica,Arial,sans-serif;
                    font-size: 16px;
                    line-height: 1.5;
                    font-weight: 300;
                    width: 100%;
                    margin-bottom:21px;
                }
                .profile-card header {
                    width: 100%;
                    height: 100%;
                    text-align: center;
                    /* FF3.6+ */
                    background: -webkit-gradient(linear, left bottom, right top, color-stop(0%, rgba(0, 0, 0, 0.9)), color-stop(100%, transparent));
                    /* Chrome,Safari4+ */
                    background: -webkit-linear-gradient(45deg, rgba(0, 0, 0, 0.9) 0%, transparent 100%);
                    /* Chrome10+,Safari5.1+ */
                    /* Opera 11.10+ */
                    /* IE10+ */
                    background: linear-gradient(45deg, rgba(0, 0, 0, 0.9) 0%, transparent 100%);
                    /* W3C */
                    filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#cc000000', endColorstr='#00000000',GradientType=1 );
                    /* IE6-9 fallback on horizontal gradient */
                }
                .profile-card header .profile-img-link {
                    position: relative;
                }
                .profile-card header .profile-img-link:before {
                    content: "";
                    border: 15px solid rgba(255, 255, 255, 0.3);
                    border-radius: 50%;
                    height: 90px;
                    width: 90px;
                    position: absolute;
                    left: 0;
                    bottom: 3px;
                    -webkit-animation: pulsate 1.6s ease-out;
                    animation: pulsate 1.6s ease-out;
                    -webkit-animation-iteration-count: infinite;
                    animation-iteration-count: infinite;
                    opacity: 0.0;
                    z-index: 99;
                }
                .profile-card header img {
                    position: relative;
                    border-radius: 50%;
                    height: 90px;
                    width: 90px;
                    padding: 0;
                    margin: 0;
                    border: 15px solid transparent;
                    margin-top: 12px;
                    z-index: 9999;
                    -webkit-transition: all .3s ease-out;
                    transition: all .3s ease-out;
                }
                .profile-card header a:hover img {
                    -webkit-transform: scale(1.06, 1.06);
                    transform: scale(1.06, 1.06);
                }
                .profile-card header a:hover:before {
                    -webkit-animation: none;
                    animation: none;
                }
                .profile-card header h1 {
                    text-align: center;
                    font-size: 28px;
                    opacity: 0.9;
                    margin-top: 0px;
                    margin-bottom: 3px;
                    padding-top:10px;
                }
                .profile-card header h2 {
                    font-size: 18px;
                    margin-top: 0;
                    opacity: 0.9;
                    margin-top: 0px;
                    margin-bottom: 3px;
                }
                .profile-card header h3 {
                    font-size: 14px;
                    margin-top: 0;
                    opacity: 0.9;
                    margin-top: 0px;
                    margin-bottom: 3px;
                }
                .profile-card .profile-bio {
                    position: absolute;
                    bottom: 0;
                }
                .profile-card .profile-bio p {
                    margin: 24px;
                    text-align: center;
                    opacity: 0.9;
                }
                .profile-card .profile-social-links {
                    position: relative;
                    background-color: white;
                    margin: 0 auto;
                    text-align: center;
                    padding: 6px 0;
                }
                .profile-card .profile-social-links li {
                    display: inline-block;
                    padding: 3px 5px 0;
                }
                .profile-card .profile-social-links li img {
                    height: 28px;
                    opacity: 0.8;
                    -webkit-transition: all .2s ease-out;
                    transition: all .2s ease-out;
                }
                .profile-card .profile-social-links li a:hover img {
                    opacity: 1;
                    -webkit-transform: scale(1.1, 1.1);
                    transform: scale(1.1, 1.1);
                }
                .profile-card .profile-social-links:after {
                    bottom: 100%;
                    left: 50%;
                    border: solid transparent;
                    content: " ";
                    height: 0;
                    width: 0;
                    position: absolute;
                    pointer-events: none;
                    border-color: rgba(255, 255, 255, 0);
                    border-bottom-color: #ffffff;
                    border-width: 10px;
                    margin-left: -10px;
                }

                .fa-pencil-square-o {
                    font-size:21px;
                }

                .fa-hourglass-half {
                    cursor:default;
                    color: lightgrey;
                }

                .flexbox-container {
                    display: -ms-flex;
                    display: -webkit-flex;
                    display: flex;
                }

                .flexbox-container > div {
                    width: 100%;
                    padding: 10px;
                }

                .flexbox-container > div:first-child {
                    margin-right: 20px;
                }

                hr {
                    margin-top:10px;
                    margin-left:10px;
                    margin-right:10px;
                    pacity:.2;
                }

                .visitors-stream-view {
                    margin-left:10px;
                    margin-right:10px;
                    margin-bottom:44px;
                }

                #graph-container {
                    margin-top:10px;
                    margin-left:auto;
                    margin-right:auto;
                }

                .email-variation-stats td, {
                    height:40px;
                }

                .pagination {
                    display: inline-block;
                    padding: 0;
                    margin: 8px 0;
                }

                .pagination a {
                    color: black;
                    float: left;
                    padding: 8px 16px;
                    text-decoration: none;
                }


                .pagination a.active {
                    background-color: #1585cf;
                    color: white;
                }

                .pagination a:hover:not(.active) {background-color: #ddd;}

                #limit-select {
                    height:30px;
                    text-align:right;
                    width:100%;
                }
            </style>
            <link rel='stylesheet' id='fontawesome-css'  href='<?php echo INBOUNDNOW_SHARED_URLPATH ;?>assets/fonts/fontawesome/css/font-awesome.min.css?ver=4.6.1' type='text/css' media='all' />
            <?php
        }

        /**
         * Load event data into static variables
         *
         **/
        public static function load_data() {
            global $wpdb;

            self::$range =  (isset($_REQUEST['range'])) ? intval($_REQUEST['range']) : 30;
            self::$page = (isset($_GET['page_number'])) ? (int) $_GET['page_number'] : 1;
            self::$limit = (isset($_GET['limit'])) ? (int) $_GET['limit'] : 50;
            self::$offset = (self::$page>1) ? (int) self::$page * self::$limit  : self::$limit;
            $dates = Inbound_Reporting_Templates::prepare_range( self::$range );
            self::$start_date = $dates['start_date'];
            self::$end_date = $dates['end_date'];
            self::$past_start_date = $dates['past_start_date'];
            self::$past_end_date = $dates['past_end_date'];
            self::$job_id = (isset($_REQUEST['job_id']) && $_REQUEST['job_id']) ? $wpdb->esc_like($_REQUEST['job_id']) : "%_%";

            /* get "current" email stats for the selected action */
            $params = array(
                'email_id' => intval($_REQUEST['email_id']),
                'event_name' => sanitize_text_field($_REQUEST['event_name']),
                'event_name_2' => (isset($_REQUEST['event_name_2'])) ? sanitize_text_field($_REQUEST['event_name_2']) : false,
                'job_id' => self::$job_id,
                'start_date' => self::$start_date,
                'end_date' => self::$end_date,
                'limit' => self::$limit,
                'offset' => self::$offset,
            );
            self::$events = self::get_email_event_stats($params);


            /* get "current" email stats for the selected action */
            $params = array(
                'email_id' => intval($_REQUEST['email_id']),
                'job_id' => self::$job_id,
                'event_name' => sanitize_text_field($_REQUEST['event_name']),
                'event_name_2' => (isset($_REQUEST['event_name_2'])) ? sanitize_text_field($_REQUEST['event_name_2']) : false,
                'start_date' => self::$start_date,
                'end_date' => self::$end_date
            );
            self::$graph_data['current'] = self::get_email_event_stats($params , true);

            /* calculate total events for pagination */
            self::$total_events = count(self::$graph_data['current']);

            /* get the action stats for the selected email's variations */
            $params = array(
                'email_id' => intval($_REQUEST['email_id']),
                'job_id' => self::$job_id,
                'event_name' => sanitize_text_field($_REQUEST['event_name']),
            );
            self::$top_variations = self::get_top_email_variants($params);


            /* calculate total pages */
            self::$total_pages = self::$total_events / self::$limit;
            self::$total_pages = (self::$total_pages > 1) ? ceil(self::$total_pages) : 1;


            /* make labels for the possible events to query data for - for UI purposes */
            $params = array(
                'sparkpost_delivery' => __('Sends', 'inbound-pro'),
                'sparkpost_open' => __('Opens', 'inbound-pro'),
                'unopened' => __('Unopened Emails', 'inbound-pro'),
                'sparkpost_click' => __('Clicks', 'inbound-pro'),
                'sparkpost_bounce' => __('Bounces', 'inbound-pro'),
                'sparkpost_rejected' => __('Rejects', 'inbound-pro'),
                'inbound_unsubscribe' => __('Unsubscribes', 'inbound-pro'),
                'inbound_mute' => __('Mutes', 'inbound-pro'),
                'singular_form' => array(
                    'sparkpost_delivery' => __('Sent', 'inbound-pro'),
                    'sparkpost_open' => __('Opened', 'inbound-pro'),
                    'unopened' => __('Unopened', 'inbound-pro'),
                    'sparkpost_click' => __('Clicked', 'inbound-pro'),
                    'sparkpost_bounce' => __('Bounced', 'inbound-pro'),
                    'sparkpost_rejected' => __('Rejected', 'inbound-pro'),
                    'inbound_unsubscribe' => __('Unsubscribed', 'inbound-pro'),
                    'inbound_mute' => __('Muted', 'inbound-pro'),
                ),
                'lead_table' => array(
                    'sparkpost_delivery' => __('been sent an', 'inbound-pro'),
                    'sparkpost_open' => __('opened an', 'inbound-pro'),
                    'unopened' => __('not opened an', 'inbound-pro'),
                    'sparkpost_click' => __('clicked an', 'inbound-pro'),
                    'sparkpost_bounce' => __('bounced an', 'inbound-pro'),
                    'sparkpost_rejected' => __('rejected an', 'inbound-pro'),
                    'inbound_unsubscribe' => __('unsubscribed from an', 'inbound-pro'),
                    'inbound_mute' => __('muted an', 'inbound-pro'),
                ),
            );
            self::$possible_actions = $params;

        }

        /**
         * Formats the email action data into a form echarts can use
         */
        public static function prepare_chart_data( $start_date, $end_date, $period = 'current' ) {
            /* prepare empty dates */
            $dates = Inbound_Reporting_Templates::get_days_from_range($start_date,$end_date);

            /**if the graph to display is a type that maintains a running total, and adds or subtracts from that total**/
            if(isset($_REQUEST['standing_total_graph']) && $_REQUEST['standing_total_graph'] == true){
                /* create new temporary arrays with different structures */
                $temp = array();
                $temp_2 = array();
                $logged_ids = array();
                foreach (self::$graph_data[$period] as $key => $data) {
                    /*if the present data item should be removed from the running total*/
                    if(isset($data['item_to_remove'])){
                        if(!isset($logged_ids[$data['variation_id']]['removals'][$data['lead_id']])){
                            $logged_ids[$data['variation_id']]['removals'][$data['lead_id']] = 1;
                            $temp_2[substr($data['datetime'], 0, 10)][] = $data['id'];
                        }
                    }else{
                        if(!isset($logged_ids[$data['variation_id']]['additions'][$data['lead_id']])){
                            $logged_ids[$data['variation_id']]['additions'][$data['lead_id']] = 1;
                            $temp[substr($data['datetime'], 0, 10)][] = $data['id'];
                        }
                    }
                }
                $past_count = 0;
                $actions_array = array();
                $formatted = array();

                foreach ($dates as $index => $date) {

                    if (isset($temp[$date])) {
                        $formatted[$date]['date'] = $date;
                        $past_count += count($temp[$date]);
                        $actions_array[$index] = $past_count;
                    } else {
                        $formatted[$date]['date'] = $date;
                        $actions_array[$index] = $past_count;
                    }

                    if(isset($temp_2[$date])){
                        $remove_count = count($temp_2[$date]);
                        if($remove_count > $past_count){
                            $actions_array[$index] = 0;
                            $past_count = 0;
                        }else{
                            $actions_array[$index] -= $remove_count;
                            $past_count -= $remove_count;
                        }
                    }
                }

            }else{
                /* create new temporary array with different structure */
                $temp = array();
                $logged_ids = array();
                foreach (self::$graph_data[$period] as $key => $data) {
                    if(!isset($logged_ids[$data['variation_id']][$data['lead_id']])){
                        $logged_ids[$data['variation_id']][$data['lead_id']] = 1;
                        $temp[substr($data['datetime'], 0, 10)][] = $data['lead_id'];
                    }
                }

                $actions_array = array();
                $formatted = array();
                foreach ($dates as $index => $date) {
                    if (isset($temp[$date])) {
                        $formatted[$date]['date'] = $date;
                        $actions_array[] = count($temp[$date]);
                    } else {
                        $formatted[$date]['date'] = $date;
                        $actions_array[] = 0;
                    }
                }

            }

            return array( 'dates' => array_keys($formatted), 'actions_counted' => array_values($actions_array) );

        }

        /*
         * Gets the event stats for the email variations of the selected email
         * @params array(event_name, email_id)
         */
        public static function get_top_email_variants($args){
            global $wpdb;

            $events = array();  //for calculating unopened emails

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

            /* to find out how many unopens there are we first have to query the opens,
             * then subtract those from the sent foreach variation */
            if($args['event_name'] == 'unopened'){
                $results = $wpdb->get_results(
                    $wpdb->prepare(
                        "SELECT `variation_id`, `lead_id` AS `lead_id` from {$table_name} " .
                        "WHERE `event_name` = 'sparkpost_open' " .
                        "AND `email_id` = '%d'".
                        "AND `job_id` LIKE '%s'"
                        , $args['email_id'] , $args['job_id']
                    ), ARRAY_A
                );

                /* make a list of all the variations a lead has opened */
                foreach($results as $key => $value){
                    $events[$value['lead_id']][$value['variation_id']] = 1;
                }

                /* change the event_name to get the sent */
                $args['event_name'] = 'sparkpost_delivery';
            }

            $results = $wpdb->get_results(
                $wpdb->prepare(
                    "SELECT `variation_id`, `lead_id` AS `lead_id` from {$table_name} " .
                    "WHERE `event_name` = '%s' " .
                    "AND `email_id` = '%d' " .
                    "AND `job_id` LIKE '%s' " .
                    "ORDER BY `datetime` ASC"
                    , $args['event_name'], $args['email_id'], $args['job_id']
                ), ARRAY_A
            );

            $variant_count = array();
            $logged_ids = array();

            /* count the number times a variation shows up in the results  */
            foreach($results as $key => $value){

                /* only log the unique times an action occured to a lead.
                 * If an email is sent to the same lead 3 times, still only 1 person is reached */
                if(!isset($logged_ids[$value['variation_id']][$value['lead_id']])){
                    $logged_ids[$value['variation_id']][$value['lead_id']] = 1;

                    if(!isset($events[$value['lead_id']][$value['variation_id']])){
                        @$variant_count[$value['variation_id']] += 1;
                    }
                }
            }

            /*sort the variations by value, greatest to smallest*/
            arsort($variant_count);

            return $variant_count;

        }

        /*
         * Gets email action stats for the selected email
         * @params: array(email_id, event_name, start_date, end_date)
         **/
        public static function get_email_event_stats($args , $ignore_limit = false){
            global $wpdb;

            /*change the event name to deliveries in order to get the unopened*/
            if($args['event_name'] == 'unopened'){
                $args['event_name'] = 'sparkpost_delivery';
            }

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

            /* look for distinct lead id unsubscribes if unsubscribe event */
            $query = "SELECT * from {$table_name} ";

            if($args['event_name'] == 'inbound_unsubscribe'){
                    $query = "SELECT distinct lead_id, email_id, datetime,event_details,variation_id  from (SELECT lead_id,email_id, datetime, event_details, variation_id from {$table_name} ";
                    $query .=   " WHERE `email_id` = '%d'" .
                                " AND `event_name` = '%s'" .
                                " AND `job_id` LIKE '%s'" .
                                " AND datetime >= '%s' AND datetime <= '%s'" .
                                " ORDER BY {$table_name} . `datetime` " .
                                " ) as filter GROUP BY lead_id, email_id,event_details,datetime,variation_id";
            } else {
                    $query = "SELECT * from {$table_name} ";
                    $query .=   " WHERE `email_id` = '%d'" .
                                " AND `event_name` = '%s'" .
                                " AND `job_id` LIKE '%s'" .
                                " AND datetime >= '%s' AND datetime <= '%s'" .
                                " ORDER BY {$table_name} . `datetime` " .
                                "";
            }

            /* add limit and offset if present */
            if (isset(self::$offset) && !$ignore_limit) {
                $query_pagination .= "  LIMIT ".self::$limit." OFFSET ".self::$offset."  ";
            }

            /* *
            error_log(sprintf(
                $query.$query_pagination,
                $args['email_id'], $args['event_name'], $args['job_id'], $args['start_date'], $args['end_date'], $args['end_date']
            ));
            /* */

           /* *
           echo sprintf(

               $query.$query_pagination,
               $args['email_id'], $args['event_name'], $args['job_id'], $args['start_date'], $args['end_date'], $args['end_date']
           );
           /**/

            $results = $wpdb->get_results(
                $wpdb->prepare(
                    $query.$query_pagination,
                    $args['email_id'], $args['event_name'], $args['job_id'], $args['start_date'], $args['end_date'], $args['end_date']
                ), ARRAY_A
            );

            //echo $query.$query_pagination;
            //print_r($results);exit;


            /*if a second event is being queried for*/
            if($args['event_name_2'] != false && !empty($args['event_name_2'])){
                $two_events['event_one'] = $results;

                $query = "SELECT * from {$table_name} " .
                        " WHERE `email_id` = %d" .
                        " AND `job_id` = %s" .
                        " AND `event_name` = %s" .
                        " AND datetime >= %s AND datetime <= %s" .
                        " ORDER BY {$table_name} . `datetime` ASC";

                $results = $wpdb->get_results(
                    $wpdb->prepare(
                        $query.$query_pagination,
                        $args['email_id'], $args['job_id'], $args['event_name_2'], $args['start_date'], $args['end_date']
                    ), ARRAY_A
                );

                $two_events['event_two'] = $results;

                return self::process_multiple_events($two_events, sanitize_text_field($_REQUEST['event_action']));
            }

            return $results;
        }

        /**
         * Processes multiple streams of lead data to return a single time line to display
         *
         */
        public static function process_multiple_events($event_array, $array_action){

            if($array_action === 'merge'){
                return array_merge($event_array['event_one'], $event_array['event_two']);
            }

            if($array_action === 'remove_opens'){
                foreach($event_array['event_two'] as $key => $data){
                    $event_array['event_two'][$key]['item_to_remove'] = 1;
                }
                return array_merge($event_array['event_one'], $event_array['event_two']);
            }

        }


    }

    new Inbound_Mailer_Stats_Report;
}