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 } }