/**
     * Actions metabox used for primary filtering purposes
     *
     *
     * @uses CRM_User_List_Table class
     * @since 0.01
     *
     */
    function actions($wp_list_table)
    {
        ?>
    <div class="misc-pub-section">

    <?php 
        $wp_list_table->search_box('Search', 'wp_crm_text_search');
        ?>

    <?php 
        $wp_list_table->views();
        ?>

    </div>

    <div class="major-publishing-actions">
      <div class="other-action">
        <span class="wp_crm_subtle_link wp_crm_toggle" toggle="wp_crm_user_actions"><?php 
        _e('Show Actions', 'wp_crm');
        ?>
</span>
      </div>
      <div class="publishing-action">
        <?php 
        submit_button(__('Filter Results'), 'button', false, false, array('id' => 'search-submit'));
        ?>
      </div>
      <br class='clear' />
    </div>

    <div class="wp_crm_user_actions hidden">
      <ul class="wp_crm_action_list">
      <li class="wp_crm_orange_link wp_crm_export_to_csv"><?php 
        _e('Export to CSV', 'wp_crm');
        ?>
</li>
      <?php 
        if (WP_CRM_F::get_quantifiable_attributes()) {
            ?>
      <li class="wp_crm_orange_link wp_crm_visualize_results"><?php 
            _e('Visualize User Data', 'wp_crm');
            ?>
</li>
      <?php 
        }
        ?>
      <?php 
        do_action('wp_crm_user_actions');
        ?>
      </ul>
    </div>


    <?php 
    }
示例#2
0
    /**
     * Actions metabox used for primary filtering purposes
     *
     *
     * @uses CRM_User_List_Table class
     * @since 0.01
     *
     */
    static function actions($wp_list_table)
    {
        ?>
    <div class="misc-pub-section">
      <?php 
        $wp_list_table->search_box('Search', 'wp_crm_text_search');
        ?>
      <?php 
        $wp_list_table->views();
        ?>
    </div>

    <div class="major-publishing-actions">

      <div class="publishing-action">
        <?php 
        submit_button(__('Filter Results', 'wp_crm'), 'button', false, false, array('id' => 'search-submit'));
        ?>
      </div>
      <br class="clear" />
    </div>

    <div class="wp_crm_user_actions">
      <ul class="wp_crm_action_list">
        <li class="button wp_crm_export_to_csv"><?php 
        _e('Export to CSV', 'wp_crm');
        ?>
</li>
      <?php 
        if (WP_CRM_F::get_quantifiable_attributes()) {
            ?>
        <li class="button wp_crm_visualize_results"><?php 
            _e('Visualize User Data', 'wp_crm');
            ?>
</li>
      <?php 
        }
        ?>
        <?php 
        do_action('wp_crm_user_actions');
        ?>
      </ul>
    </div>

    <div id="performed_actions">
      <h3><?php 
        _e('Perfomed actions', 'wp_crm');
        ?>
</h3>
      <div class="wp_crm_quick_report_wrapper"></div>
    </div>
    <?php 
    }
示例#3
0
    /**
     * Visualize quantifiable data
     *
     * @todo There may be an issue with overlapping attributes for certain users, as unaccounted_for sometimes results in a negative number
     * @since 0.19
     *
     */
    static function visualize_results($filters)
    {
        global $wpdb;
        parse_str($filters, $filters);
        $wp_crm_search = $filters['wp_crm_search'];
        //** Get users from filter query */
        $user_ids = WP_CRM_F::user_search($wp_crm_search, array('ids_only' => 'true'));
        $quantifiable_attributes = WP_CRM_F::get_quantifiable_attributes();
        if (!$quantifiable_attributes || !$user_ids) {
            return;
        }
        $user_id_query = ' user_id = ' . implode(' OR user_id = ', $user_ids);
        foreach ($quantifiable_attributes as $attribute_slug => $attribute) {
            if (!empty($attribute['option_keys'])) {
                foreach ($attribute['option_keys'] as $short_slug => $full_meta_key) {
                    $this_count = $wpdb->get_var("SELECT count(DISTINCT(user_id)) FROM {$wpdb->usermeta} WHERE meta_key = '{$full_meta_key}' AND ({$user_id_query})");
                    if (empty($this_count)) {
                        continue;
                    }
                    $data[$attribute_slug]['counts'][$short_slug] = $this_count;
                    $data[$attribute_slug]['labels'][$short_slug] = $attribute['option_labels'][$short_slug];
                }
            } else {
                $this_count = $wpdb->get_var("SELECT count(DISTINCT(user_id)) FROM {$wpdb->usermeta} WHERE meta_key = '{$attribute_slug}' AND ({$user_id_query})");
                if (empty($this_count)) {
                    continue;
                }
                $data[$attribute_slug]['counts'][$short_slug] = $this_count;
                $data[$attribute_slug]['labels'][$short_slug] = $attribute['title'];
            }
            $data[$attribute_slug]['title'] = $attribute['title'];
            if (empty($data[$attribute_slug]['counts'])) {
                unset($data[$attribute_slug]);
            } else {
                //** Calculate "other" */
                $unaccounted_for = count($user_ids) - array_sum($data[$attribute_slug]['counts']);
                if ($unaccounted_for > 0) {
                    $data[$attribute_slug]['counts']['unaccounted_for'] = $unaccounted_for;
                    $data[$attribute_slug]['labels']['unaccounted_for'] = __('Unaccounted', 'wp_crm');
                }
            }
        }
        if (empty($data)) {
            die('<div class="wp_crm_visualize_results no_data">' . __('There is not enough quantifiable data to generate any graphs.', 'wp_crm') . '</div>');
        }
        ?>
    <div class="wp_crm_visualize_results">
      <script type="text/javascript">

        jQuery(document).ready(function() {
    <?php 
        foreach ($data as $attribute_slug => $attribute_data) {
            echo "wp_crm_attribute_{$attribute_slug}_chart();\r\n";
        }
        ?>
        });

    <?php 
        foreach ($data as $attribute_slug => $attribute_data) {
            ?>
          function wp_crm_attribute_<?php 
            echo $attribute_slug;
            ?>
_chart() {

            var data = new google.visualization.DataTable({});
            data.addColumn('string', 'Attribute');
            data.addColumn('number', 'Count');
            data.addRows(<?php 
            echo count($attribute_data['counts']);
            ?>
);

      <?php 
            $row = 0;
            foreach ($attribute_data['counts'] as $short_slug => $count) {
                ?>

              data.setValue(<?php 
                echo $row;
                ?>
, 0, '<?php 
                echo $attribute_data['labels'][$short_slug];
                ?>
');
              data.setValue(<?php 
                echo $row;
                ?>
, 1, <?php 
                echo $count;
                ?>
);
        <?php 
                $row++;
            }
            ?>

            var chart = new google.visualization.PieChart(document.getElementById('wp_crm_attribute_<?php 
            echo $attribute_slug;
            ?>
_chart'));
            chart.draw(data, {
              backgroundColor: '#F7F7F7',
              is3D: true,
              chartArea: {width: "60%", height: "90%"},
              width: 380,
              height: 310,
              legend: 'bottom'
            });
          }
    <?php 
        }
        ?>
      </script>

    <?php 
        foreach ($data as $attribute_slug => $attribute_data) {
            ?>
        <div class="wp_crm_chart_wrapper">
          <span class="wp_crm_chart_title"><?php 
            echo $attribute_data['title'];
            ?>
</span>
          <div id="wp_crm_attribute_<?php 
            echo $attribute_slug;
            ?>
_chart" class="wp_crm_visualization_graph"></div>
        </div>
    <?php 
        }
        ?>

    </div>

    <?php 
    }
示例#4
0
 /**
  * Get a value of a user.
  *
  * Ideally an attribute key should be passed, in which case the first value will be returned by default.
  * If a full meta key is passed, the value will be returned.
  * If a value of an option is passed, a boolean will be returned depending on if the option is enabled for the user.
  *
  * @since 0.1
  *
  */
 function wp_crm_get_value($meta_key, $user_id = false, $args = '')
 {
     global $current_user, $wp_crm;
     $args = wp_parse_args($args, array('return' => 'value', 'concat_char' => ', ', 'meta_key' => $meta_key, 'option_key' => ''));
     if (!$user_id) {
         $user_id = $current_user->ID;
     }
     $quantifiable_attributes = array_keys(WP_CRM_F::get_quantifiable_attributes());
     //** Check if meta key exists as key and as label */
     $attributes = $wp_crm['data_structure']['attributes'];
     $full_meta_keys = $wp_crm['data_structure']['full_meta_keys'];
     $meta_keys = $wp_crm['data_structure']['meta_keys'];
     //* If passed key is an attribute key (as intended) */
     if (is_array($attributes) && in_array($meta_key, array_keys($attributes))) {
         $args['attribute_key'] = $meta_key;
     }
     //* If passed meta_key is actually a label name */
     if (is_array($meta_keys) && in_array($meta_key, $meta_keys)) {
         $meta_value_flip = array_flip($meta_keys);
         $args['attribute_key'] = $meta_value_flip[$meta_key];
         $meta_key = $args['attribute_key'];
     }
     //* If a full meta key is passed (for pre-defined values)  */
     if (is_array($full_meta_keys) && in_array($meta_key, array_keys($full_meta_keys))) {
         $args['full_meta_key'] = $meta_key;
         $args['attribute_key'] = $full_meta_keys[$meta_key];
     }
     //** If all else fails, use the passed $meta_key (it may be a main user table key) */
     if (empty($args['attribute_key'])) {
         $args['attribute_key'] = $meta_key;
     }
     //** Get the full attribute data once we have the attribute_key */
     $attribute = WP_CRM_F::get_attribute($args['attribute_key']);
     //* Make sure we have a user object */
     if (!empty($user_id) && is_numeric($user_id)) {
         $user_object = (array) wp_crm_get_user($user_id);
     }
     //** If we have the full meta key then we can get value easily from get_user_meta() */
     if (!empty($args['full_meta_key']) && $args['full_meta_key'] != $args['attribute_key']) {
         $args['value'] = get_user_meta($user_id, $args['full_meta_key'], true);
     } else {
         //** Attribute has options, we return the label of the option */
         if (!empty($attribute['has_options'])) {
             if ($attribute['input_type'] == 'text' || $attribute['input_type'] == 'textarea' || $attribute['input_type'] == 'date') {
                 //** Try to get value by option key. */
                 $option_key = !empty($args['option_key']) ? $args['option_key'] : (is_array($attribute['option_keys']) ? key($attribute['option_keys']) : false);
                 if (!empty($option_key)) {
                     $args['value'] = get_user_meta($user_id, $args['attribute_key'] . '_option_' . $option_key, true);
                     if (!empty($args['value'])) {
                         $args['label'] = $meta_keys[$args['attribute_key'] . '_option_' . $option_key];
                         $args['return_option_label'] = true;
                         $args['value'] .= ', ' . $args['label'];
                     }
                 }
                 if (empty($args['value'])) {
                     $args['value'] = WP_CRM_F::get_first_value(!empty($user_object[$args['attribute_key']]) ? $user_object[$args['attribute_key']] : array());
                 }
             } else {
                 $options = WP_CRM_F::list_options($user_object, $args['attribute_key']);
                 if (is_array($options)) {
                     $args['value'] = implode($args['concat_char'], $options);
                 }
             }
         } else {
             $args['value'] = WP_CRM_F::get_first_value(!empty($user_object[$args['attribute_key']]) ? $user_object[$args['attribute_key']] : array());
         }
     }
     //** Check if this should be a boolean response */
     if ((empty($args['return_option_label']) || !$args['return_option_label']) && in_array($args['attribute_key'], $quantifiable_attributes)) {
         if (!empty($args['value']) && $args['value'] == 'on') {
             $args['value'] = true;
         }
     }
     switch ($args['return']) {
         case 'value':
             $result = !empty($args['value']) ? $args['value'] : '';
             break;
         case 'detail':
             $result = $args;
             break;
         default:
             $result = $args[$args['return']];
             break;
     }
     return $result;
 }