public static function features_search_area()
{
global $wpdb;
?>
<div class="icon32 icon32-compare-product" id="icon32-compare-product"><br></div>
<h2><?php
_e('Categories & Features', 'woo_cp');
?>
<a href="admin.php?page=woo-compare-features&act=add-new" class="add-new-h2"><?php
_e('Add New', 'woo_cp');
?>
</a></h2>
<div style="clear:both;height:12px"></div>
<form method="get" action="admin.php?page=woo-compare-features" name="compare_search_features">
<input type="hidden" name="page" value="woo-compare-features" />
<input type="hidden" name="tab" value="features" />
<?php
$s_feature = '';
if (isset($_REQUEST['s_feature']) && trim($_REQUEST['s_feature']) != '') {
$s_feature = trim(stripslashes($_REQUEST['s_feature']));
}
?>
<table class="form-table" style="width:535px;">
<tbody>
<tr valign="top">
<th class="titledesc" scope="rpw" style="padding-left:0;"><input type="text" name="s_feature" id="s_feature" value="<?php
echo $s_feature;
?>
" style="min-width:300px" /></th>
<td class="forminp search_features_td" style="padding-right:0; text-align:right;"><input type="submit" id="search_features" name="" value="<?php
_e('Search Features', 'woo_cp');
?>
" class="button"></td>
</tr>
</tbody>
</table>
<?php
if (isset($_REQUEST['s_feature'])) {
$p = 1;
$rows = 25;
if (isset($_REQUEST['pp'])) {
$p = $_REQUEST['pp'];
}
if (isset($_REQUEST['rows'])) {
$rows = $_REQUEST['rows'];
}
$start = ($p - 1) * $rows;
$end = $start + $rows;
$div = 5;
$keyword = trim(stripslashes($_REQUEST['s_feature']));
$link = add_query_arg(array('pp' => '', 'rows' => $rows, 's_feature' => $keyword));
$character = 'latin1';
if ($wpdb->has_cap('collation')) {
if (!empty($wpdb->charset)) {
$character = "{$wpdb->charset}";
}
}
$where = "LOWER( CONVERT( field_name USING " . $character . ") ) LIKE '%" . strtolower(trim($_REQUEST['s_feature'])) . "%'";
$total = WC_Compare_Data::get_count($where);
if ($end > $total) {
$end = $total;
}
$items = WC_Compare_Data::get_results($where, 'field_name ASC', $start . ',' . $rows);
$innerPage = WC_Compare_Functions::printPage($link, $total, $p, $div, $rows, false);
?>
<h3><?php
_e('Found', 'woo_cp');
?>
<?php
echo $total;
?>
<?php
_e('feature(s)', 'woo_cp');
?>
</h3>
<?php
if ($total > 0) {
?>
<table cellspacing="0" class="widefat post fixed" style="width:535px;">
<thead>
<tr>
<th class="manage-column" scope="col"><?php
_e('Feature Name', 'woo_cp');
?>
</th>
<th width="90" class="manage-column" scope="col" style="text-align:right"><?php
_e('Type', 'woo_cp');
?>
</th>
<th width="100" class="manage-column" scope="col" style="text-align:right"></th>
</tr>
</thead>
<tbody>
<?php
foreach ($items as $field_data) {
?>
<tr>
<td><?php
echo stripslashes($field_data->field_name);
?>
</td>
<td align="right"><?php
echo WC_Compare_Fields_Class::$default_types[$field_data->field_type]['name'];
?>
</td>
<td align="right"><a href="admin.php?page=woo-compare-features&act=field-edit&field_id=<?php
echo $field_data->id;
?>
" class="c_field_edit" title="<?php
_e('Edit', 'woo_cp');
?>
" ><?php
_e('Edit', 'woo_cp');
?>
</a> | <a href="admin.php?page=woo-compare-features&act=field-delete&field_id=<?php
echo $field_data->id;
?>
" class="c_field_delete" onclick="javascript:return confirmation('<?php
_e('Are you sure you want to delete', 'woo_cp');
?>
#<?php
echo htmlspecialchars($field_data->field_name);
?>
');" title="<?php
_e('Delete', 'woo_cp');
?>
" ><?php
_e('Delete', 'woo_cp');
?>
</a></td>
</tr>
<?php
}
?>
</tbody>
<tfoot>
<tr>
<th class="manage-column column-title" colspan="3" style="padding:2px 7px">
<div class="tablenav">
<span class="search_item_title"><?php
_e('Show', 'woo_cp');
?>
:</span>
<select name="rows" class="number_items">
<?php
$number_items_array = array('15' => '15', '25' => '25', '50' => '50', '75' => '75', '100' => '100', '200' => '200', '1000000' => 'All');
foreach ($number_items_array as $key => $value) {
if ($key == $rows) {
echo "<option selected='selected' value='{$key}'>{$value}</option>";
} else {
echo "<option value='{$key}'>{$value}</option>";
}
}
?>
</select>
<input type="submit" class="button" value="<?php
_e('Go', 'woo_cp');
?>
" name="" id="search_items" />
<div class="tablenav-pages"><span class="displaying-num"><?php
_e('Displaying', 'woo_cp');
?>
<?php
echo $start + 1;
?>
- <?php
echo $end;
?>
<?php
_e('of', 'woo_cp');
?>
<?php
echo $total;
?>
</span><?php
echo $innerPage;
?>
</div>
</div>
</th>
</tr>
</tfoot>
</table>
<?php
}
}
?>
</form>
<?php
}
