public static function pageHeader()
{
global $pfcore;
$gap = '
<div style="float:left; width: 50px;">
</div>';
if ($pfcore->cmsName == 'WordPress') {
$reg = new PLicense();
if ($reg->valid) {
$lic = '<div style="position:absolute; left:300px; top:60px">
<a class="button-primary" type="submit" value="" id="submit" name="submit" href="http://shoppingcartproductfeed.com/" target="_blank">Thank You For Supporting The Project</a>
</div>';
} else {
$lic = PLicenseKeyDialog::small_registration_dialog('');
}
} else {
$lic = '';
}
$providers = new PProviderList();
$output = '
<div class="postbox" style="width:98%;">
<div class="inside-export-target">
<div>
<h4>Select Merchant Type</h4>
<select id="selectFeedType" onchange="doSelectFeed();">
<option></option>' . $providers->asOptionList() . '
</select>
</div>
' . $lic . '
</div>
</div>
<div class="clear"></div>';
return $output;
}
function __construct()
{
parent::__construct();
$this->service_name = 'AggCSV';
$this->service_name_long = 'CSV Aggregate Feed';
global $pfcore;
$loadFeeds = 'loadFeeds' . $pfcore->callSuffix;
$this->{$loadFeeds}();
$this->feeds = array();
$providers = new PProviderList();
foreach ($this->feedsAll as $thisFeed) {
$thisFeed->prettyName = $providers->getPrettyNameByType($thisFeed->type);
$thisFeed->checked = false;
$thisFeed->checkedString = '';
if ($providers->getFileFormatByType($thisFeed->type) == 'csv') {
$this->feeds[] = $thisFeed;
}
}
}
function feeds_main_table()
{
global $wpdb;
$feed_table = $wpdb->prefix . 'cp_feeds';
$providerList = new PProviderList();
// Read the feeds
$sql_feeds = "SELECT f.*,description FROM {$feed_table} as f LEFT JOIN {$wpdb->term_taxonomy} on ( f.category=term_id and taxonomy='product_cat' ) ORDER BY f.id";
$list_of_feeds = $wpdb->get_results($sql_feeds, ARRAY_A);
// Find the ordering method
$reverse = false;
if (isset($_GET['order_by'])) {
$order = $_GET['order_by'];
} else {
$order = '';
}
if ($order == '') {
$order = get_option('cp_feed_order');
$reverse = get_option('cp_feed_order_reverse');
} else {
$old_order = get_option('cp_feed_order');
$reverse = get_option('cp_feed_order_reverse');
if ($old_order == $order) {
$reverse = !$reverse;
} else {
$reverse = FALSE;
}
update_option('cp_feed_order', $order);
if ($reverse) {
update_option('cp_feed_order_reverse', TRUE);
} else {
update_option('cp_feed_order_reverse', FALSE);
}
}
if (!empty($list_of_feeds)) {
// Setup the sequence array
$seq = false;
$num = false;
foreach ($list_of_feeds as $this_feed) {
$this_feed_ex = new PSavedFeed($this_feed['id']);
switch ($order) {
case 'name':
$seq[] = strtolower(stripslashes($this_feed['filename']));
break;
case 'description':
$seq[] = strtolower(stripslashes($this_feed_ex->local_category));
break;
case 'url':
$seq[] = strtolower($this_feed['url']);
break;
case 'category':
$seq[] = $this_feed['category'];
$num = true;
break;
case 'google_category':
$seq[] = $this_feed['remote_category'];
break;
case 'type':
$seq[] = $this_feed['type'];
break;
default:
$seq[] = $this_feed['id'];
$num = true;
break;
}
}
// Sort the seq array
if ($num) {
asort($seq, SORT_NUMERIC);
} else {
asort($seq, SORT_REGULAR);
}
// Reverse ?
if ($reverse) {
$t = $seq;
$c = count($t);
$tmp = array_keys($t);
$seq = false;
for ($i = $c - 1; $i >= 0; $i--) {
$seq[$tmp[$i]] = '0';
}
}
$image['down_arrow'] = '<img src="' . esc_url(plugins_url('images/down.png', __FILE__)) . '" alt="down" style=" height:12px; position:relative; top:2px; " />';
$image['up_arrow'] = '<img src="' . esc_url(plugins_url('images/up.png', __FILE__)) . '" alt="up" style=" height:12px; position:relative; top:2px; " />';
?>
<!-- <div class="table_wrapper"> -->
<table class="widefat" style="margin-top:12px;" >
<thead>
<tr>
<?php
$url = get_admin_url() . 'admin.php?page=cart-product-feed-manage-page&order_by=';
?>
<th scope="col" style="min-width: 40px;" >
<a href="<?php
echo $url . "id";
?>
">
<?php
_e('ID', 'cart-product-strings');
if ($order == 'id') {
if ($reverse) {
echo $image['up_arrow'];
} else {
echo $image['down_arrow'];
}
}
?>
</a>
</th>
<th scope="col" style="min-width: 120px;">
<a href="<?php
echo $url . "name";
?>
">
<?php
_e('Name', 'cart-product-strings');
if ($order == 'name') {
if ($reverse) {
echo $image['up_arrow'];
} else {
echo $image['down_arrow'];
}
}
?>
</a>
</th>
<th scope="col">
<a href="<?php
echo $url . "category";
?>
">
<?php
_e('Local category', 'cart-product-strings');
if ($order == 'category') {
if ($reverse) {
echo $image['up_arrow'];
} else {
echo $image['down_arrow'];
}
}
?>
</a>
</th>
<th scope="col" style="min-width: 100px;">
<a href="<?php
echo $url . "google_category";
?>
">
<?php
_e('Export category', 'cart-product-strings');
if ($order == 'google_category') {
if ($reverse) {
echo $image['up_arrow'];
} else {
echo $image['down_arrow'];
}
}
?>
</a>
</th>
<th scope="col" style="min-width: 50px;" >
<a href="<?php
echo $url . "type";
?>
">
<?php
_e('Type', 'cart-product-strings');
if ($order == 'type') {
if ($reverse) {
echo $image['up_arrow'];
} else {
echo $image['down_arrow'];
}
}
?>
</a>
</th>
<th scope="col" style="width: 120px;">
<a href="<?php
echo $url . "url";
?>
">
<?php
_e('URL', 'cart-product-strings');
if ($order == 'url') {
if ($reverse) {
echo $image['up_arrow'];
} else {
echo $image['down_arrow'];
}
}
?>
</a>
</th>
<th scope="col" style="width: 80px;"><?php
_e('Last Updated', 'cart-product-strings');
?>
</th>
<th scope="col" width="50px"><?php
//_e( 'View', 'cart-product-strings' );
?>
</th>
<th scope="col" width="50px"><?php
_e('Options', 'cart-product-strings');
?>
</th>
<th scope="col" width="50px"><?php
//_e( 'Delete', 'cart-product-strings' );
?>
</th>
<th scope="col"><?php
_e('Products', 'cart-product-strings');
?>
</th>
</tr>
</thead>
<tbody>
<?php
$alt = ' class="alternate" ';
?>
<?php
$idx = '0';
foreach (array_keys($seq) as $s) {
$this_feed = $list_of_feeds[$s];
$this_feed_ex = new PSavedFeed($this_feed['id']);
$pendcount = FALSE;
?>
<tr <?php
echo $alt;
if ($pendcount) {
echo 'style="background-color:#ffdddd"';
}
?>
>
<td><?php
echo $this_feed['id'];
?>
</td>
<td><?php
echo $this_feed['filename'];
?>
</td>
<td><small><?php
echo esc_attr(stripslashes($this_feed_ex->local_category));
?>
</small></td>
<td><?php
echo str_replace(".and.", " & ", str_replace(".in.", " > ", esc_attr(stripslashes($this_feed['remote_category']))));
?>
</td>
<td><?php
echo $providerList->getPrettyNameByType($this_feed['type']);
?>
</td>
<td><?php
echo $this_feed['url'];
?>
</td>
<?php
//$url = get_admin_url() . 'admin.php?page=??? ( edit feed ) &tab=edit&edit_id=' . $this_feed['id'];
?>
<td><?php
$ext = '.' . $providerList->getExtensionByType($this_feed['type']);
$feed_file = PFeedFolder::uploadFolder() . $this_feed['type'] . '/' . $this_feed['filename'] . $ext;
if (file_exists($feed_file)) {
echo date("d-m-Y H:i:s", filemtime($feed_file));
} else {
echo 'DNE';
}
?>
</td>
<td><a href="<?php
echo $this_feed['url'];
?>
" target="_blank" class="purple_xmlsedit"><?php
_e('View', 'cart-product-strings');
?>
</a></td>
<?php
$url_edit = get_admin_url() . 'admin.php?page=cart-product-feed-admin&action=edit&id=' . $this_feed['id'];
?>
<td><a href="<?php
echo $url_edit;
?>
" class="purple_xmlsedit"><?php
_e('Edit', 'cart-product-strings');
?>
</a></td>
<?php
$url = get_admin_url() . 'admin.php?page=cart-product-feed-manage-page&action=delete&id=' . $this_feed['id'];
?>
<td><a href="<?php
echo $url;
?>
" class="purple_xmlsedit"><?php
_e('Delete', 'cart-product-strings');
?>
</a></td>
<td><?php
echo $this_feed['product_count'];
?>
</td>
</tr>
<?php
if ($alt == '') {
$alt = ' class="alternate" ';
} else {
$alt = '';
}
$idx++;
}
?>
</tbody>
<tfoot>
<tr>
<?php
$url = get_admin_url() . 'admin.php?page=cart-product-manage-page&order_by=';
$order = '';
?>
<th scope="col" style="min-width: 40px;" >
<a href="<?php
echo $url . "id";
?>
">
<?php
_e('ID', 'cart-product-strings');
if ($order == 'id') {
if ($reverse) {
echo $image['up_arrow'];
} else {
echo $image['down_arrow'];
}
}
?>
</a>
</th>
<th scope="col" style="min-width: 120px;">
<a href="<?php
echo $url . "name";
?>
">
<?php
_e('Name', 'cart-product-strings');
if ($order == 'name') {
if ($reverse) {
echo $image['up_arrow'];
} else {
echo $image['down_arrow'];
}
}
?>
</a>
</th>
<th scope="col">
<a href="<?php
echo $url . "category";
?>
">
<?php
_e('Local Category', 'cart-product-strings');
if ($order == 'category') {
if ($reverse) {
echo $image['up_arrow'];
} else {
echo $image['down_arrow'];
}
}
?>
</a>
</th>
<th scope="col" style="min-width: 100px;">
<a href="<?php
echo $url . "google_category";
?>
">
<?php
_e('Export category', 'cart-product-strings');
if ($order == 'google_category') {
if ($reverse) {
echo $image['up_arrow'];
} else {
echo $image['down_arrow'];
}
}
?>
</a>
</th>
<th scope="col" style="min-width: 50px;" >
<a href="<?php
echo $url . "type";
?>
">
<?php
_e('Type', 'cart-product-strings');
if ($order == 'type') {
if ($reverse) {
echo $image['up_arrow'];
} else {
echo $image['down_arrow'];
}
}
?>
</a>
</th>
<th scope="col" style="width: 120px;">
<a href="<?php
echo $url . "url";
?>
">
<?php
_e('URL', 'cart-product-strings');
if ($order == 'url') {
if ($reverse) {
echo $image['up_arrow'];
} else {
echo $image['down_arrow'];
}
}
?>
</a>
</th>
<th scope="col" style="width: 80px;"><?php
_e('Last Updated', 'cart-product-strings');
?>
</th>
<th scope="col"><?php
//_e( 'View', 'cart-product-strings' );
?>
</th>
<th scope="col"><?php
_e('Options', 'cart-product-strings');
?>
</th>
<th scope="col"><?php
//_e( 'Delete', 'cart-product-strings' );
?>
</th>
<th scope="col"><?php
_e('Products', 'cart-product-strings');
?>
</th>
</tr>
</tfoot>
</table>
<input class="button-primary" type="submit" value="Update Now" id="submit" name="submit" onclick="doUpdateAllFeeds()">
<div id="update-message"> </div>
<!-- </div> -->
<?php
} else {
?>
<p><?php
_e('No feeds yet!', 'cart-product-strings');
?>
</p>
<?php
}
}
