function lead_management_admin_screen()
{
global $wpdb;
Inbound_Compatibility::inbound_compatibilities_mode();
// Load only our scripts
if (isset($_REQUEST['testthis'])) {
test_query();
}
// Maybe make this an option some time
$per_page = 60;
$paged = empty($_REQUEST['paged']) ? 1 : intval($_REQUEST['paged']);
$orderbys = array('Date First Created' => 'date', 'Date Last Modified' => 'modified', 'Alphabetical Sort' => 'title', 'Status' => 'post_status');
$orderbys_flip = array_flip($orderbys);
// Sorting
$orderby = '';
if (isset($_REQUEST['orderby'])) {
$orderby = $_REQUEST['orderby'];
}
$order = "";
if (isset($_REQUEST['order'])) {
$order = strtoupper($_REQUEST['order']);
}
$_POST = stripslashes_deep($_POST);
$_REQUEST = stripslashes_deep($_REQUEST);
$posts = array();
if (isset($_REQUEST['num'])) {
$num = intval($_REQUEST['num']);
} else {
$num = 0;
}
if (isset($_REQUEST['what'])) {
$what = htmlentities($_REQUEST['what']);
} else {
$what = "";
}
if (isset($_REQUEST['on'])) {
$on = htmlentities($_REQUEST['on']);
} else {
$on = "";
}
$message = '';
// Deal with any update messages we might have:
if (isset($_REQUEST['done'])) {
switch ($_REQUEST['done']) {
case 'add':
$message = sprintf(__("Added %d posts to the list “{$what}”.", 'leads'), $num);
break;
case 'remove':
$message = sprintf(_("Removed %d posts from the list “{$what}”.", 'leads'), $num);
break;
case 'tag':
$message = sprintf(__("Tagged %d posts with “{$what}” on {$on}.", 'leads'), $num);
break;
case 'untag':
$message = sprintf(__("Untagged %d posts with “{$what}”.", 'leads'), $num);
break;
case 'delete_leads':
$message = sprintf(__("%d leads permanently deleted", 'leads'), $num);
break;
}
}
if (!empty($message)) {
echo "<div id='message' class='updated fade'><p><strong>" . $message . "</strong></p></div>";
echo '<style type="text/css">
#display-lead-count, .starter-text, #filters{display:none !important;}
</style>';
}
$filter = "";
// default
// Create the hidden input which passes our current filter to the action script.
if (!empty($_REQUEST['wplead_list_category'])) {
$filter = '<input id="hidden-cat" type="hidden" name="cat_two" value="' . urlencode(implode(',', $_REQUEST['wplead_list_category'])) . '" />';
}
if (isset($_REQUEST['s']) && !empty($_REQUEST['s'])) {
$filter = '<input type="hidden" name="s" value="' . urlencode($_REQUEST['s']) . '" />';
}
if (isset($_REQUEST['t']) && !empty($_REQUEST['t'])) {
$filter = '<input type="hidden" name="t" value="' . urlencode($_REQUEST['t']) . '" />';
}
echo '<div class="wrap">
<h2>' . __('Lead Management - Bulk Update Leads', 'leads') . '</h2>';
if (empty($_REQUEST['wplead_list_category']) && empty($_REQUEST['s']) && empty($_REQUEST['t'])) {
echo '<p class="starter-text">' . __('To get started, select the lead criteria below to see all matching leads.', 'leads') . '</p>';
}
$page_output = isset($_REQUEST['paged']) ? $_REQUEST['paged'] : '1';
echo "<div id='paged-current'>" . $page_output . "</div>";
// Filtering
echo '
<div id="filters" class="inbound-lead-filters">
<form id="lead-management-form" method="get" action="edit.php">
<input type="hidden" name="page" value="lead_management" />
<input type="hidden" name="post_type" value="wp-lead" />
';
// Category drop-down
echo '<div id="top-filters"><div id="inbound-lead-lists-dropdown">
<label for="cat">' . __('Select Lead List(s):', 'leads') . '</label>';
//wp_lead_lists_dropdown();
lead_select_taxonomy_dropdown('wplead_list_category');
echo '</div>';
if (isset($_REQUEST['relation'])) {
$relation = $_REQUEST['relation'];
} else {
$relation = 'AND';
}
echo '
<div id="and-or-params">
<label for="orderby">' . __('Match:', 'leads') . '</label>
<select name="relation" id="relation">
<option value="AND"' . ($relation == 'AND' ? ' selected="selected"' : '') . '>' . __('(ONLY) Leads that are in <u>ALL</u> of the selected lists', 'leads') . '</option>
<option value="OR"' . ($relation == 'OR' ? ' selected="selected"' : '') . '>' . __('(ANY) Leads in at least 1 of the selected Lists', 'leads') . '</option>
</select>
</div></div>';
// Sorting
echo '<div id="bottom-filters">
<div class="filter" id="lead-sort-by">
<label for="orderby">' . __('Sort by:', 'leads') . '</label>
<select name="orderby" id="orderby">
';
foreach ($orderbys as $title => $value) {
$selected = $orderby == $value ? ' selected="selected"' : '';
echo "<option value='{$value}'{$selected}>{$title}</option>\n";
}
echo '
</select>
<select name="order" id="order">
<option value="asc"' . ($order == 'ASC' ? ' selected="selected"' : '') . '>Asc.</option>
<option value="desc"' . ($order == 'DESC' ? ' selected="selected"' : '') . '>Desc.</option>
</select>
</div>
';
if (isset($_REQUEST['s'])) {
$s = $_REQUEST['s'];
} else {
$s = '';
}
// ...then the keyword search.
echo '
<div class="filter" style="display:none;">
<label for="s">' . __('Keyword:', 'leads') . '</label>
<input type="text" name="s" id="s" value="' . htmlentities($s) . '" title="' . __('Use % for wildcards.', 'leads') . '" />
</div>
';
if (isset($_REQUEST['t'])) {
$t = $_REQUEST['t'];
} else {
$t = '';
}
// ...then the tag filter.
echo '
<div class="filter" id="lead-tag-filter">
<label for="s">Tag:</label>
<input type="text" name="t" id="t" value="' . htmlentities($t) . '" title="\'foo, bar\': posts tagged with \'foo\' or \'bar\'. \'foo+bar\': posts tagged with both \'foo\' and \'bar\'" />
</div>
';
echo '
<div class="filter">
<input type="submit" class="button-primary" value="' . __('Search Leads', 'leads') . '" name="submit" />
</div>';
echo '</div>
</form>';
// Fetch our posts.
if (!empty($_REQUEST['wplead_list_category']) || !empty($_REQUEST['s']) || !empty($_REQUEST['t']) || !empty($_REQUEST['on'])) {
// A cat has been given; fetch posts that are in that category.
$q = "paged={$paged}&posts_per_page={$per_page}&orderby={$orderby}&order={$order}&post_type=wp-lead";
if (!empty($_REQUEST['wplead_list_category'])) {
$cat = $_REQUEST['wplead_list_category'];
$prefix = '';
$final_cats = "";
foreach ($cat as $key => $value) {
$final_cats .= $prefix . $value;
$prefix = ', ';
}
}
//print_r($final_cats); exit;
// A keyword has been given; get posts whose content contains that keyword.
if (!empty($_REQUEST['s'])) {
$q .= "&s=" . urlencode($_REQUEST['s']);
}
// A tag has been given; get posts tagged with that tag.
if (!empty($_REQUEST['t'])) {
$t = preg_replace('#[^a-z0-9\\-\\,\\+]*#i', '', $_REQUEST['t']);
$q .= "&tag={$t}";
}
//$query = new WP_Query;
//$posts = $query->query($q);
$args = array('post_type' => 'wp-lead', 'order' => $order, 'orderby' => $orderby, 'posts_per_page' => $per_page);
// if finished show results
if (isset($_REQUEST['on'])) {
$on_val = explode(",", $on);
$prefix = '';
$final_on = "";
foreach ($on_val as $key => $value) {
$final_on .= $prefix . $value;
$prefix = ', ';
}
$args['post__in'] = $on_val;
$args['order'] = 'DESC';
$args['orderby'] = 'date';
//$args['posts_per_page'] = -1;
}
if (isset($_REQUEST['wplead_list_category']) && $_REQUEST['wplead_list_category'][0] != "all") {
/*$args['tax_query'] = array(
'relation' => 'AND',
array(
'taxonomy' => 'wplead_list_category',
'field' => 'id',
'terms' => array( $final_cats ),
)
); */
/* Dynamic tax query */
$tax_query = array('relation' => $relation);
$taxonomy_array = $_REQUEST['wplead_list_category'];
foreach ($taxonomy_array as $taxonomy_array_value) {
$tax_query[] = array('taxonomy' => 'wplead_list_category', 'field' => 'id', 'terms' => array($taxonomy_array_value));
}
$args['tax_query'] = $tax_query;
}
// echo "<pre>";
/* print_r($args);
echo "<br><br>";
print_r($arg_s); exit;*/
// Add tag to query
if (isset($_REQUEST['t']) && $_REQUEST['t'] != "") {
$args['tag'] = $_REQUEST['t'];
}
if (isset($_REQUEST['paged']) && $_REQUEST['paged'] != "1") {
$args['paged'] = $paged;
}
$query = new WP_Query($args);
$posts = $query->posts;
// print_r($posts); exit;
// Pagination
$pagination = '';
if ($query->max_num_pages > 1) {
$current = preg_replace('/&?paged=[0-9]+/i', '', strip_tags($_SERVER['REQUEST_URI']));
// I'll happily take suggestions on a better way to do this, but it's 3am so
$pagination .= "<div class='tablenav-pages'>";
if ($paged > 1) {
$prev = $paged - 1;
$pagination .= "<a class='prev page-numbers' href='{$current}&paged={$prev}'>« " . __('Previous', 'leads') . "</a>";
}
for ($i = 1; $i <= $query->max_num_pages; $i++) {
if ($i == $paged) {
$pagination .= "<span class='page-numbers current'>{$i}</span>";
} else {
$pagination .= "<a class='page-numbers' href='{$current}&paged={$i}'>{$i}</a>";
}
}
if ($paged < $query->max_num_pages) {
$next = $paged + 1;
$pagination .= "<a class='next page-numbers' href='{$current}&paged={$next}'>" . __('Next', 'leads') . " »</a>";
}
$pagination .= "</div>";
}
echo $pagination;
}
echo "</div>";
// tablenav
//lead_dropdown_generator();
// No posts have been fetched, let's tell the user:
if (empty($_REQUEST['wplead_list_category']) && empty($_REQUEST['s']) && empty($_REQUEST['t']) && !isset($_REQUEST['on'])) {
echo '';
// List all leads?
} else {
// Criteria were given, but no posts were matched.
if (empty($posts)) {
echo '
<p>' . __('No posts matched that criteria, sorry! Try again with something different.', 'leads') . '</p>
';
} else {
$all_cats = isset($_REQUEST['wplead_list_category']) ? $_REQUEST['wplead_list_category'] : 0;
$prefix = "";
$name = "";
if (isset($_REQUEST['wplead_list_category']) && $_REQUEST['wplead_list_category'][0] != 'all') {
foreach ($all_cats as $key => $value) {
$term = get_term($_REQUEST['wplead_list_category'][$key], 'wplead_list_category');
$name .= $prefix . $term->name;
$prefix = ' <span>and</span> ';
}
} else {
$name = __("Total", 'leads');
}
echo '
<form method="post" id="man-table" action="' . admin_url('admin.php') . '">
<input type="hidden" name="action" value="lead_action" />
<div id="posts">
<table class="widefat" id="lead-manage-table">';
if (!isset($_REQUEST['on'])) {
echo '<caption style="margin-top:0px;">' . sprintf('<h2 class="found-text"><strong><span id="lead-total-found">%s</span></strong> Leads Found in <strong>%s</strong></h2><strong>Additional Search Criteria:</strong> tagged with <strong><u>%s</u></strong>, %s ordered by <strong><u>%s</u></strong> %s.', $query->found_posts, !empty($_REQUEST['wplead_list_category']) ? $name : __('any category', 'leads'), !empty($_REQUEST['t']) ? htmlentities($_REQUEST['t']) : __('any tag', 'leads'), !empty($_REQUEST['s']) ? __('containing the string', 'leads') . ' <strong>' . htmlentities($_REQUEST['s']) . '</strong>, ' : '', strtolower($orderbys_flip[$orderby]), $order == 'asc' ? 'ascending' : 'descending');
} else {
echo '<caption style="margin-top:0px;">';
}
echo '<div><input type="search" class="light-table-filter" data-table="widefat" placeholder="Filter Results Below" /><span id="search-icon"></span>
<span style="float:right;margin-top: 19px;margin-right: 3px;" id="display-lead-count">
<i class="lead-spinner"></i><span id="lead-count-text">' . __('Grabbing Matching Leads', 'leads') . '</span></span></div>
</caption>
<thead>
<tr>
<th class="checkbox-header no-sort" scope="col"><input type="checkbox" id="toggle" title="Select all posts" /></th>
<th class="count-sort-header" scope="col">#</th>
<th scope="col">' . __('Date', 'leads') . '</th>
<th scope="col">' . __('Email', 'leads') . '</th>
<th scope="col">' . __('Current Lists', 'leads') . '</th>
<th scope="col">' . __('Current Tags', 'leads') . '</th>
<th scope="col" class="no-sort">' . __('View', 'leads') . '</th>
<th scope="col">' . __('ID', 'leads') . '</th>
</tr>
</thead>
<tbody id="the-list">
';
$loop_count = 1;
$i = 0;
foreach ((array) $posts as $post) {
//$categories = wp_get_post_categories($post->ID);
$terms = wp_get_post_terms($post->ID, 'wplead_list_category', 'id');
$cats = '';
$lead_ID = $post->ID;
foreach ($terms as $term) {
$term_link = get_term_link($term, 'wplead_list_category');
if (is_wp_error($term_link)) {
continue;
}
//We successfully got a link. Print it out.
$cats .= '<span class="list-pill">' . $term->name . ' <i title="Remove This lead from the ' . $term->name . ' list" class="remove-from-list" data-lead-id="' . $lead_ID . '" data-list-id="' . $term->term_id . '"></i></span> ';
}
$_tags = wp_get_post_terms($post->ID, 'lead-tags', 'id');
$tags = '';
foreach ($_tags as $tag) {
$tags .= "<a title='Click to Edit Lead Tag Name' target='_blank' href='" . admin_url('edit-tags.php?action=edit&taxonomy=lead-tags&tag_ID=' . $tag->term_id . '&post_type=wp-lead') . "'>{$tag->name}</a>, ";
}
$tags = substr($tags, 0, strlen($tags) - 2);
if (empty($tags)) {
$tags = 'No Tags';
}
echo '
<tr' . ($i++ % 2 == 0 ? ' class="alternate"' : '') . '>
<td><input class="lead-select-checkbox" type="checkbox" name="ids[]" value="' . $post->ID . '" /></td>
<td class="count-sort"><span>' . $loop_count . '</span></td>
<td>
';
if ('0000-00-00 00:00:00' == $post->post_date) {
_e('Unpublished');
} else {
echo date(__('Y/m/d'), strtotime($post->post_date));
}
echo '</td>
<td><span class="lead-email">' . $post->post_title . '</span></td>
<td class="list-column-row">' . $cats . '</td>
<td>' . $tags . '</td>
<td><a class="thickbox" href="post.php?action=edit&post=' . $post->ID . '&small_lead_preview=true&TB_iframe=true&width=1345&height=244">View</a></td>
<td>' . $post->ID . '</td>
</tr>
';
$loop_count++;
}
echo '
</tbody>
</table>
';
// Now, our actions.
echo '
<div id="all-actions" class="tablenav">
<div id="inbound-lead-management"><span class="lead-actions-title">' . __('What do you want to do with the selected leads?', 'leads') . '</span>
<div id="controls">';
lead_management_drop_down();
echo '
</div>
' . $filter . '
<div id="lead-action-triggers">
<div class="action" id="lead-export">
<input type="submit" class="manage-remove button-primary button" name="export_leads" value="' . __('Export Leads as CSV', 'leads') . '" title="Exports selected leads into a CSV format." />
</div>
<div class="action" id="lead-update-lists">
<label for="lead-update-lists" >Choose List:</label>';
lead_select_taxonomy_dropdown('wplead_list_category', 'single', '_action');
echo '<input type="submit" class="button-primary button" name="add" value="' . __('Add to', 'leads') . '" title="Add the selected posts to this category." />
<input type="submit" class="manage-remove button-primary button" name="remove" value="' . __('Remove from', 'leads') . '" title="Remove the selected posts from this category." />
</div>
<div class="action" id="lead-update-tags">
<label for="lead-update-tags">Tags:</label>
<input type="text" id="inbound-lead-tags-input" name="tags" placeholder="' . __('Separate multiple tags with commas. ', 'leads') . '" title="Separate multiple tags with commas." />
<input type="submit" name="replace_tags" class="manage-tag-replace button-primary button" value="' . __('Replace', 'leads') . '" title="Replace the selected leads\' current tags with these ones. Warning this will delete current tags and replace them" />
<input type="submit" name="tag" class="manage-tag-add button-primary button" value="' . __('Add', 'leads') . '" title="Add tags to the selected leads without altering the leads\' existing tags." />
<input type="submit" name="untag" class="manage-remove button-primary button" value="' . __('Remove', 'leads') . '" title="Remove these tags from the selected leads." />
</div>
<div class="action" id="lead-update-meta">
<label for="lead-update-meta">Meta:</label>
<input type="text" name="meta_val" title="Separate multiple tags with commas." />
<input type="submit" name="replace_meta" value="' . __('Replace', 'leads') . '" title="Replace the selected posts\' current meta values with these ones." />
<input type="submit" name="meta" value="' . __('Add', 'leads') . '" title="Add these meta values to the selected posts without altering the posts\' existing tags." />
<input type="submit" name="unmeta" value="' . __('Remove', 'leads') . '" title="Remove these meta values from the selected posts." />
</div>
<div class="action" id="lead-delete">
<label for="lead-delete" id="del-label"><span style="color:red;">Delete Selected Leads (Warning! There is no UNDO):</span></label>
<input type="submit" class="manage-remove button-primary button" name="delete_leads" value="' . __('Permanently Delete Selected Leads', 'leads') . '" title="This will delete the selected leads from your database. There is no undo." />
</div>
</div>
' . $pagination . '
</div>
';
wp_nonce_field('lead_management-edit');
echo '
</form>
</div>
';
}
}
}
$tests = array(new ousearch_search('a and'), new ousearch_search('23dfbsdg3456 and'), new ousearch_search('and 23dfbsdg3456'), new ousearch_search('virulent attack'), new ousearch_search('regiment moved'), new ousearch_search('adjutant galloping'), new ousearch_search('adjutant galloping -Napoleon'), new ousearch_search('adjutant galloping -"where Napoleon was standing"'), new ousearch_search('about an hour'), new ousearch_search('"about an hour"'), new ousearch_search('about french hour were an'), new ousearch_search('and'), new ousearch_search('"a and"'), new ousearch_search('"and maidens"'), new ousearch_search('"the time"'), $sh);
//$tests=array(new ousearch_search('"a and"'));
$results = array();
foreach ($tests as $test) {
$blankresult = new StdClass();
$blankresult->time = 0.0;
$blankresult->count = 0;
$results[] = $blankresult;
}
// Test loop
define('OUSEARCH_TESTLOOPS', 3);
print '<h1>Running tests ' . OUSEARCH_TESTLOOPS . ' times</h1>';
flush();
for ($i = 0; $i < OUSEARCH_TESTLOOPS; $i++) {
$last = $i === OUSEARCH_TESTLOOPS - 1 ? true : false;
if (!$last) {
print '<h2>Test loop ' . $i;
flush();
}
for ($pos = 0; $pos < count($tests); $pos++) {
test_query($tests[$pos], $results[$pos], $last);
if (!$last) {
print '.';
flush();
}
}
if (!$last) {
print '</h2>';
}
}
print_footer();
