function foxyshop_subscription_template($id)
{
global $product, $foxyshop_settings;
$original_product = $product;
$template_id = get_posts(array('post_type' => 'foxyshop_product', 'p' => $id));
foreach ($template_id as $the_template_id) {
$product = foxyshop_setup_product($the_template_id);
if ($product['quantity_min'] == 0) {
$product['quantity_min'] = 1;
}
if (!$product['category']) {
$product['category'] = "DEFAULT";
}
if (!$product['weight']) {
$product['weight'] = "0";
}
$product = apply_filters("foxyshop_template_transaction_product_array", $product);
$xml = "<transaction_template>\n";
$xml .= "\t<custom_fields />\n";
$xml .= "\t<discounts />\n";
$xml .= "\t<transaction_details>\n";
$xml .= "\t<transaction_detail>\n";
$xml .= "\t\t<product_name><![CDATA[" . $product['name'] . "]]></product_name>\n";
$xml .= "\t\t<product_price><![CDATA[" . $product['price'] . "]]></product_price>\n";
$xml .= "\t\t<product_quantity><![CDATA[" . $product['quantity_min'] . "]]></product_quantity>\n";
$xml .= "\t\t<product_weight><![CDATA[" . $product['weight'] . "]]></product_weight>\n";
$xml .= "\t\t<product_code><![CDATA[" . $product['code'] . "]]></product_code>\n";
$xml .= "\t\t<image><![CDATA[" . foxyshop_get_main_image() . "]]></image>\n";
$xml .= "\t\t<url><![CDATA[" . $product['url'] . "]]></url>\n";
$xml .= "\t\t<category_code><![CDATA[" . $product['category'] . "]]></category_code>\n";
$xml .= "\t\t<transaction_detail_options />\n";
$xml .= "\t</transaction_detail>\n";
$xml .= "\t</transaction_details>\n";
$xml .= "</transaction_template>";
$xml = apply_filters("foxyshop_template_transaction_xml", $xml, $product);
}
$product = $original_product;
return $xml;
}
function foxyshop_google_products_page()
{
global $foxyshop_settings, $product;
$local_products = array();
$google_icon = "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAABh0RVh0U29mdHdhcmUAQWRvYmUgRmlyZXdvcmtzT7MfTgAAABZ0RVh0Q3JlYXRpb24gVGltZQAwNy8xNS8xMMjfMS0AAAQRdEVYdFhNTDpjb20uYWRvYmUueG1wADw/eHBhY2tldCBiZWdpbj0iICAgIiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+Cjx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDQuMS1jMDM0IDQ2LjI3Mjk3NiwgU2F0IEphbiAyNyAyMDA3IDIyOjM3OjM3ICAgICAgICAiPgogICA8cmRmOlJERiB4bWxuczpyZGY9Imh0dHA6Ly93d3cudzMub3JnLzE5OTkvMDIvMjItcmRmLXN5bnRheC1ucyMiPgogICAgICA8cmRmOkRlc2NyaXB0aW9uIHJkZjphYm91dD0iIgogICAgICAgICAgICB4bWxuczp4YXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iPgogICAgICAgICA8eGFwOkNyZWF0b3JUb29sPkFkb2JlIEZpcmV3b3JrcyBDUzM8L3hhcDpDcmVhdG9yVG9vbD4KICAgICAgICAgPHhhcDpDcmVhdGVEYXRlPjIwMTAtMDctMTVUMTk6MDU6MDFaPC94YXA6Q3JlYXRlRGF0ZT4KICAgICAgICAgPHhhcDpNb2RpZnlEYXRlPjIwMTAtMDctMTVUMTk6MTg6MDBaPC94YXA6TW9kaWZ5RGF0ZT4KICAgICAgPC9yZGY6RGVzY3JpcHRpb24+CiAgICAgIDxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSIiCiAgICAgICAgICAgIHhtbG5zOmRjPSJodHRwOi8vcHVybC5vcmcvZGMvZWxlbWVudHMvMS4xLyI+CiAgICAgICAgIDxkYzpmb3JtYXQ+aW1hZ2UvcG5nPC9kYzpmb3JtYXQ+CiAgICAgIDwvcmRmOkRlc2NyaXB0aW9uPgogICA8L3JkZjpSREY+CjwveDp4bXBtZXRhPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDBS8igAAAJlSURBVDiNfY9PSFRhFMV/33uvcRzfzKijmQr5jyzFciGFldlGiRCCoAIhqFy0CdpE0Sao3Ei1CtdBuAjDhdBSQiw3SaM5IBpkJTlRaprydJznvO+2sNRJ68CBy733nHuuisfjLVNf4k+fReciI1+TWCa0HLA5VhIAwHOcBR48sMyVlSC/IUohhhHLTCTOWfPz80+GZndFuqdCaAxYg/GYoqd2L1UFGQA50tCwRGfnHz3aMHBs+9DP7OxuKxAI7P64Ksx5gqDWNzx49CZJ75Wi9Yv19SF97x5bEwQcB0+pWsu2bUIBF9GarXg37WwKEgm0UmlzXzJJ1vKyYZimSWNFELSXRncttRl5eJj56hKGT1cxfLqKlXAmIoLyPCyA5v1hmitt+t4vbogayrI36ktHRni+bxpPvPXGBQiuMna7z3LNoqard+srcjlTk8v3pSSLiRSNFUEenysn5DfpmuyifeIhIpL2gmuxe7TMX6jybg7KxeOlXD+RT1mub3NBu7S/a6cj1rF5+S9E1iKovBsD8kNnbTT7r1VysiJIa38r3Z+6dxRuGKQiGOgUWzk05eBql5qcGsJWGDT/pSq79VLOHy3nVHUO4UyT4rCPPaH1V+LLcdoG2uib7vtnAhWb/CoHywsBEOcDOB/AXUAVnwXTj6tdml40MfhtcGeDufiE5Cz1IrOv06f+AozqO6isUqKzUQ73HN5u4EUw9HgHMvMKRNKZ+IYeuw+Soi6/DtuyQdhGQ7tLo6Jlu8FvE3E+A+BpL02oRKFEvTWUyOVkyoztaGL4Uf4CojNREmuJNHGGlzHk077WXxkiNLGzmnadAAAAAElFTkSuQmCC";
$debug_querystring = isset($_GET['debug']) ? "&debug=1" : "";
?>
<?php
if (!$foxyshop_settings['google_product_auth']) {
?>
<div class="wrap">
<div class="icon32" id="icon-tools"><br></div>
<h2>Google Products Management - Authentication Required</h2>
<table class="widefat" style="margin-top: 14px;">
<thead>
<tr>
<th><img src="<?php
echo $google_icon;
?>
" alt="" /><?php
_e("Google Authentication Required", 'foxyshop');
?>
</th>
</tr>
</thead>
<tbody>
<tr>
<td>
<p>To view and manage your Google Products you need to log in to your Google Account. Your username and password are not saved withing FoxyShop, but are passed directly to Google for authentication. If authenticated, Google will issue an auth key that will be stored with your store settings. This auth key will expire after two weeks at which point you will need to authenticate again.</p>
<form onsubmit="return false;" autocomplete="off" style="display: block; margin-bottom: 10px;">
<div class="foxyshop_field_control">
<label for="Email"><?php
echo __('Email');
?>
</label>
<input type="text" id="Email" name="Email" value="" />
</div>
<div class="foxyshop_field_control">
<label for="Passwd"><?php
echo __('Password');
?>
</label>
<input type="password" id="Passwd" name="Passwd" value="" />
</div>
<div style="clear: both; height: 4px;"></div>
<button class="button-primary" id="authnow">Authenticate Now</button>
</form>
<div id="error" style="color: red; margin-top: 10px; font-weight: bold; display: none;"></div>
<script type="text/javascript">
jQuery(document).ready(function($){
$("#authnow").click(function() {
var data = {
action: 'foxyshop_set_google_auth',
security: '<?php
echo wp_create_nonce("foxyshop-ajax-set-google-auth");
?>
',
Email: $("#Email").val(),
Passwd: $("#Passwd").val()
};
$("#error").hide();
$.post(ajaxurl, data, function(response) {
if (!response) {
$("#error").text("Error: No Response").show();
} else if (response == "Error") {
$("#error").text("Error: Login Failed. Please try again.").show();
} else if (response == "Success") {
$("#error").hide();
location.reload();
} else {
$("#error").text("Error: " + response).show();
}
});
});
});
</script>
</td>
</tr>
</tbody>
</table>
<?php
} else {
?>
<div class="wrap">
<div class="icon32" id="icon-tools"><br></div>
<h2>Google Products Management <a class="<?php
if (version_compare(get_bloginfo('version'), '3.2', "<")) {
echo "button ";
}
?>
add-new-h2" href="edit.php?post_type=foxyshop_product&page=foxyshop_google_products_page&foxyshop_google_products_update=1&googleprodlogout=1&_wpnonce=<?php
echo wp_create_nonce('gp1');
?>
">De-Authenticate</a></h2>
<?php
//Display Confirmations and Errors
if (isset($_GET['error'])) {
echo '<div class="error"><p><strong>Error!</strong><br /><ul style="margin: 0 10px;">';
$error_list = explode("||", $_GET['error']);
foreach ($error_list as $the_error) {
if ($the_error) {
echo "<li style=\"list-style: disc inside none;\">{$the_error}</li>\n";
}
}
echo '</ul></p></div>';
} elseif (isset($_GET['success'])) {
echo '<div class="updated"><p>' . __('Operation completed successfully.') . '</p></div>';
}
//Get All Local Product ID's
$args = array('post_type' => 'foxyshop_product', 'post_status' => 'publish', 'numberposts' => "-1", "orderby" => "id", "order" => "ASC", "meta_key" => "_google_product_category", "meta_compare" => "!=", "meta_value" => "");
$product_list = get_posts($args);
foreach ($product_list as $single_product) {
$local_products[] = $single_product->ID;
}
//Get Feed
$header_array = array("Authorization: GoogleLogin auth=" . $foxyshop_settings['google_product_auth']);
$url = "https://content.googleapis.com/content/v1/" . $foxyshop_settings['google_product_merchant_id'] . "/items/products/schema?performance.start=" . date("Y-m-d", strtotime("-30 days")) . "&max-results=250&performance.end=" . date("Y-m-d", strtotime("now"));
if (isset($_GET['nextlink'])) {
$url = $_GET['nextlink'];
}
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HTTPHEADER, $header_array);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 10);
curl_setopt($ch, CURLOPT_TIMEOUT, 10);
$response = trim(curl_exec($ch));
$xml = preg_replace("/(<\\/?)(\\w+):([^>]*>)/", "\$1\$2\$3", $response);
$xml = simplexml_load_string($xml, NULL, LIBXML_NOCDATA);
//Check For Next Link
$nextlink = "";
foreach ($xml->link as $link) {
$thisone = 0;
foreach ($link->attributes() as $a => $b) {
if ($a == "rel" && $b == "next") {
$thisone = 1;
}
if ($thisone && $a == "href") {
$nextlink = $b;
}
}
}
//Token Has Expired, Remove and Restart Authentication
if ((string) $xml->BODY->H1 == "Token invalid" || (string) $xml->BODY->H1 == "Token expired") {
$foxyshop_settings['google_product_auth'] = "";
update_option("foxyshop_settings", $foxyshop_settings);
$local_products = array();
echo '<div class="updated"><p>' . __('Authentication Failed. It appears that your authentication has expired. This happens every two weeks. Please login again.') . '</p></div>';
echo '<p><a href="edit.php?post_type=foxyshop_product&page=foxyshop_google_products_page" class="button">Login Now</a></p>';
} else {
?>
<form action="edit.php?post_type=foxyshop_product&page=foxyshop_google_products_page&foxyshop_manage_google_feed=1" method="post">
<table cellpadding="0" cellspacing="0" border="0" class="wp-list-table widefat foxyshop-list-table" id="product_feed_view" style="margin-top: 14px;">
<thead>
<tr>
<th id="cb" class="manage-column column-cb check-column" scope="col"><input type="checkbox"></th>
<th class="column-id"><span><?php
_e('ID', 'foxyshop');
?>
</span><span class="sorting-indicator"></span></th>
<th><span><?php
_e('Name', 'foxyshop');
?>
</span><span class="sorting-indicator"></span></th>
<th><span><?php
_e('Image', 'foxyshop');
?>
</span><span class="sorting-indicator"></span></th>
<th><span><?php
_e('Expiration', 'foxyshop');
?>
</span><span class="sorting-indicator"></span></th>
<th><span><?php
_e('Performance', 'foxyshop');
?>
</span><span class="sorting-indicator"></span></th>
</tr>
</thead>
<tfoot>
<tr>
<th class="manage-column column-cb check-column" style="" scope="col"><input type="checkbox"></th>
<th><?php
_e('ID', 'foxyshop');
?>
</th>
<th><?php
_e('Name', 'foxyshop');
?>
</th>
<th><?php
_e('Image', 'foxyshop');
?>
</th>
<th><?php
_e('Expiration', 'foxyshop');
?>
</th>
<th><?php
_e('Performance', 'foxyshop');
?>
</th>
</tr>
</tfoot>
<tbody>
<?php
if (count($xml->entry) == 0) {
echo '<tr class="no-items"><td colspan="6" class="colspanchange">No entries found.</td></tr>';
}
foreach ($xml->entry as $entry) {
$expiration_date = (string) $entry->scexpiration_date;
$expiration_date = substr($expiration_date, 0, strpos($expiration_date, "T"));
$clicks = 0;
foreach ($entry->scperformance->scdatapoint as $scdatapoint) {
$clicks += $scdatapoint->attributes()->clicks;
}
$google_product_id = (string) $entry->scid;
if (in_array($google_product_id, $local_products)) {
$local_products = array_diff($local_products, array($google_product_id));
$unmatched_text = "";
} else {
$unmatched_text = "<br /><em>" . __('Unmatched!', 'foxyshop') . "</em>\n";
}
echo '<tr>' . "\n";
echo '<th class="check-column" scope="row"><input type="checkbox" value="' . $google_product_id . '" name="post[]"></th>' . "\n";
echo '<td><strong>' . $google_product_id . '</strong>' . $unmatched_text . '</td>' . "\n";
if ($unmatched_text == "") {
echo '<td><strong><a href="post.php?post=' . $google_product_id . '&action=edit">' . (string) $entry->title . '</a></strong>';
echo '<div class="row-actions">';
echo '<span><a href="edit.php?foxyshop_manage_google_feed=1&editid=' . $google_product_id . $debug_querystring . '&_wpnonce=' . wp_create_nonce("manage-the-google-feed-settings") . '" class="update_google_product" rel="' . $google_product_id . '">' . __('Renew/Update', 'foxyshop') . '</a> | </span>';
echo '<span class="delete"><a href="edit.php?foxyshop_manage_google_feed=1&deleteid=' . $google_product_id . $debug_querystring . '&_wpnonce=' . wp_create_nonce("manage-the-google-feed-settings") . '" class="delete_google_product" rel="' . $google_product_id . '">' . __('Delete', 'foxyshop') . '</a></span>';
echo '</div>';
echo '</td>' . "\n";
} else {
echo '<td><strong><a href="#" onclick="return false;">' . (string) $entry->title . '</a></strong>';
echo '<div class="row-actions">';
echo '<span class="delete"><a href="edit.php?foxyshop_manage_google_feed=1&deleteid=' . $google_product_id . $debug_querystring . '&_wpnonce=' . wp_create_nonce("manage-the-google-feed-settings") . '" class="delete_google_product" rel="' . $google_product_id . '">' . __('Delete', 'foxyshop') . '</a></span>';
echo '</div>';
echo '</td>' . "\n";
}
if ((string) $entry->scimage_link) {
echo '<td><img src="' . (string) $entry->scimage_link . '" class="productfeedimage" /></td>' . "\n";
} else {
echo '<td> </td>' . "\n";
}
echo '<td>' . $expiration_date . '</td>' . "\n";
echo '<td>' . $clicks . ' Click' . ($clicks != 1 ? 's' : '') . '</td>' . "\n";
echo '</tr>' . "\n";
}
?>
</tbody>
</table>
<div style="padding-top: 10px;">
<button type="submit" class="button" name="update_checked_google_products" value="1" id="update_checked_google_products">Update/Renew Checked <?php
echo FOXYSHOP_PRODUCT_NAME_PLURAL;
?>
</button>
<button type="submit" class="button" name="delete_checked_google_products" value="1" id="delete_checked_google_products">Delete Checked <?php
echo FOXYSHOP_PRODUCT_NAME_PLURAL;
?>
</button>
<?php
if ($nextlink) {
echo '<a href="edit.php?post_type=foxyshop_product&page=foxyshop_google_products_page&nextlink=' . urlencode($nextlink) . '" class="button" style="float: right;">Next Page</a>';
}
?>
</div>
<input type="hidden" name="foxyshop_run_the_xml" value="1" />
<?php
wp_nonce_field('manage-the-google-feed-settings');
?>
<?php
if (isset($_GET['debug'])) {
echo '<input type="hidden" name="debug" value="1" />';
}
?>
</form>
<?php
}
//Display All Unmatched Products
$meta_query = array('relation' => 'OR', array('key' => '_google_product_category', 'value' => "", 'compare' => '!='));
$args = array('post_type' => 'foxyshop_product', 'post_status' => 'publish', 'numberposts' => "100", "orderby" => "id", "order" => "ASC", "meta_query" => $meta_query);
$product_list = get_posts($args);
if ($product_list) {
?>
<h2 style="padding: 100px 0 0 0;">Available, Unmatched <?php
echo FOXYSHOP_PRODUCT_NAME_PLURAL;
?>
to Add</h2>
<p style="margin: 0;">In order to appear in this list, <?php
echo strtolower(FOXYSHOP_PRODUCT_NAME_PLURAL);
?>
must have a "Google Product Category" attribute.</p>
<form action="edit.php?post_type=foxyshop_product&page=foxyshop_google_products_page&foxyshop_manage_google_feed=1" method="post">
<table cellpadding="0" cellspacing="0" border="0" class="wp-list-table widefat foxyshop-list-table" id="available_product_view" style="margin-top: 14px;">
<thead>
<tr>
<th id="cb" class="manage-column column-cb check-column" scope="col"><input type="checkbox"></th>
<th class="column-id"><span><?php
_e('ID');
?>
</span><span class="sorting-indicator"></span></th>
<th><span><?php
_e('Name', 'foxyshop');
?>
</span><span class="sorting-indicator"></span></th>
<th><span><?php
_e('Code', 'foxyshop');
?>
</span><span class="sorting-indicator"></span></th>
<th><span><?php
_e('Image', 'foxyshop');
?>
</span><span class="sorting-indicator"></span></th>
<th><span><?php
_e('Price', 'foxyshop');
?>
</span><span class="sorting-indicator"></span></th>
<th><span><?php
_e('Date', 'foxyshop');
?>
</span><span class="sorting-indicator"></span></th>
</tr>
</thead>
<tfoot>
<tr>
<th class="manage-column column-cb check-column" style="" scope="col"><input type="checkbox"></th>
<th><?php
_e('ID', 'foxyshop');
?>
</th>
<th><?php
_e('Name', 'foxyshop');
?>
</th>
<th><?php
_e('Code', 'foxyshop');
?>
</th>
<th><?php
_e('Image', 'foxyshop');
?>
</th>
<th><?php
_e('Price', 'foxyshop');
?>
</th>
<th><?php
_e('Data', 'foxyshop');
?>
</th>
</tr>
</tfoot>
<tbody>
<?php
$none_available = 1;
foreach ($product_list as $single_product) {
$product = foxyshop_setup_product($single_product);
$google_product_listed = (int) get_post_meta($product['id'], '_google_product_listed', TRUE);
if ($google_product_listed > strtotime("now") && !isset($_GET['debug'])) {
continue;
}
$none_available = 0;
if (!isset($google_product_id)) {
$google_product_id = "";
}
$salestartdate = get_post_meta($product['id'], '_salestartdate', TRUE);
$saleenddate = get_post_meta($product['id'], '_saleenddate', TRUE);
if ($salestartdate == '999999999999999999') {
$salestartdate = 0;
}
if ($saleenddate == '999999999999999999') {
$saleenddate = 0;
}
$originalprice = $product['originalprice'];
$saleprice = get_post_meta($product['id'], '_saleprice', true);
if ($saleprice > 0) {
$beginningOK = strtotime("now") > $salestartdate;
$endingOK = strtotime("now") < $saleenddate + 86400 || $saleenddate == 0;
if ($beginningOK && $endingOK || $salestartdate == 0 && $saleenddate == 0) {
$pricewrite = '<span style="text-decoration: line-through; margin-right: 10px;">' . foxyshop_currency($originalprice) . '</span><span style="color: red;">' . foxyshop_currency($saleprice) . '</span>';
} else {
$pricewrite = foxyshop_currency($originalprice);
}
} else {
$pricewrite = foxyshop_currency($originalprice);
}
echo '<tr>' . "\n";
echo '<th class="check-column" scope="row"><input type="checkbox" value="' . $product['id'] . '" name="post[]"></th>' . "\n";
echo '<td><strong>' . $product['id'] . '</strong></td>' . "\n";
echo '<td><strong><a href="post.php?post=' . $product['id'] . '&action=edit">' . $product['name'] . '</a></strong>';
echo '<div class="row-actions">';
echo '<span><a href="edit.php?foxyshop_manage_google_feed=1&addid=' . $product['id'] . $debug_querystring . '&_wpnonce=' . wp_create_nonce("manage-the-google-feed-settings") . '" class="insert_google_product" rel="' . $google_product_id . '">' . __('Add To Google Products Feed', 'foxyshop') . '</a></span>';
echo '</div>';
echo '</td>' . "\n";
echo '<td>' . $product['code'] . '</td>' . "\n";
echo '<td><img src="' . foxyshop_get_main_image() . '" class="productfeedimage" /></td>' . "\n";
echo '<td>' . $pricewrite . '</td>' . "\n";
echo '<td>' . Date("Y-m-d", strtotime($single_product->post_date)) . '</td>' . "\n";
echo '</tr>' . "\n";
}
if ($none_available) {
echo '<tr><td colspan="7"><em>No ' . FOXYSHOP_PRODUCT_NAME_PLURAL . ' Available.</em></td></tr>' . "\n";
}
?>
</tbody>
</table>
<input type="hidden" name="foxyshop_run_the_xml" value="1" />
<?php
wp_nonce_field('manage-the-google-feed-settings');
?>
<?php
if (isset($_GET['debug'])) {
echo '<input type="hidden" name="debug" value="1" />';
}
?>
<div style="padding-top: 10px;">
<button type="submit" class="button" name="add_checked_google_products" value="1" id="add_checked_google_products">Add Checked <?php
echo FOXYSHOP_PRODUCT_NAME_PLURAL;
?>
to Google</button>
</div>
</form>
<?php
}
?>
<?php
}
?>
<br /><br /><br /><br /><br /><br />
<table class="widefat">
<thead>
<tr>
<th><img src="<?php
echo $google_icon;
?>
" alt="" /><?php
_e("Create Manual Export File");
?>
</th>
</tr>
</thead>
<tbody>
<tr>
<td>
<p>If you would like to <a href="http://www.google.com/merchants" target="_blank">submit your products to Google</a>, you may do so by creating a product feed using this tool. Make sure that you check the option that <a href="http://www.google.com/support/merchants/bin/answer.py?answer=160037" target="_blank">enables double quotes.</a> You also need to make sure that the '_google_product_category' custom field is filled out for each product.</p>
<form action="edit.php" method="get">
<input type="hidden" name="post_type" value="foxyshop_product">
<input type="hidden" name="create_google_product_feed" value="1">
<p>
<a href="#" onclick="jQuery('#db_export_settings').show(); jQuery(this).hide(); return false;">Export just part of your product database</a>
<div id="db_export_settings" style="display: none;">
<label for="records_per_page">How May Records Per Page?</label><input type="text" id="records_per_page" name="records_per_page" value="-1"> (-1 for all)<br>
<label for="records_page">Which Page To Export?</label><input type="text" id="records_page" name="records_page" value="1">
</div>
<button type="submit" name="submitnow" id="submitnow" value="1" class="button-primary">Create Google Product Feed</button>
<button type="submit" name="amazon_version" id="amazon_version" value="1" class="button-primary">Create Amazon Product Ads Feed</button>
</p>
</form>
</td>
</tr>
</tbody>
</table>
</div>
<script type="text/javascript" src="<?php
echo FOXYSHOP_DIR;
?>
/js/jquery.tablesorter.js"></script>
<script type="text/javascript">
jQuery(document).ready(function($){
$("#product_feed_view").tablesorter({
'cssDesc': 'asc sorted',
'cssAsc': 'desc sorted',
'headers': { 0: { sorter: false} }
});
});
</script>
<?php
}
function foxyshop_custom_sort()
{
global $wpdb, $product;
$parentID = 0;
$success = "";
//Reset Order
if (isset($_GET['upgrade_menu_order'])) {
foxyshop_upgrade_menu_order();
}
if (isset($_POST['submit_new_product_order'])) {
if (check_admin_referer('update-foxyshop-sorting-options')) {
$success = foxyshop_update_order();
}
} elseif (isset($_POST['revert_product_order'])) {
if (check_admin_referer('update-foxyshop-sorting-options')) {
$success = foxyshop_revert_order();
}
}
?>
<div class="wrap">
<div class="icon32" id="icon-tools"><br></div>
<h2><?php
echo sprintf(__('Custom %s Order'), FOXYSHOP_PRODUCT_NAME_SINGULAR);
?>
</h2>
<?php
if ($success) {
echo $success;
}
?>
<?php
$product_categories = get_terms('foxyshop_categories', 'hide_empty=0&hierarchical=0&orderby=name&order=ASC');
$categoryID = 0;
if (isset($_REQUEST['categoryID'])) {
$categoryID = $_REQUEST['categoryID'];
}
if ($product_categories) {
echo '<p>' . sprintf(__("Select a category from the drop down to order the %s in that category.", 'foxyshop'), strtolower(FOXYSHOP_PRODUCT_NAME_PLURAL)) . "</p>\n";
echo '<form name="form_product_category_order" method="post" action="edit.php?post_type=foxyshop_product&page=foxyshop_custom_sort">';
echo '<select name="categoryID" id="categoryID">' . "\n";
echo '<option value="0"' . ($categoryID == 0 ? ' selected="selected"' : '') . '>' . __('All', 'foxyshop') . ' ' . FOXYSHOP_PRODUCT_NAME_PLURAL . '</option>' . "\n";
foreach ($product_categories as $cat) {
echo '<option value="' . esc_attr($cat->term_id) . '"' . ($categoryID == $cat->term_id ? ' selected="selected"' : '') . '>' . esc_html($cat->name) . ' (' . $cat->count . ')' . '</option>' . "\n";
}
echo '</select>' . "\n";
echo '<input type="submit" name="btnSubPages" class="button" id="btnSubPages" value="' . __('Select Category', 'foxyshop') . '" /></form>';
} else {
$categoryID = 0;
}
if ($categoryID >= 0) {
if ($categoryID > 0) {
$term = get_term_by('id', $categoryID, "foxyshop_categories");
$current_category_name = $term->name;
$args = array('post_type' => 'foxyshop_product', 'foxyshop_categories' => $term->slug, 'posts_per_page' => -1, 'orderby' => "meta_value_num", "meta_key" => "_foxyshop_menu_order_" . $categoryID, 'order' => "ASC", 'post__not_in' => foxyshop_hide_children_array($categoryID));
} else {
$current_category_name = __("All", 'foxyshop') . ' ' . FOXYSHOP_PRODUCT_NAME_PLURAL;
$args = array('post_type' => 'foxyshop_product', 'numberposts' => -1, 'orderby' => "menu_order", 'order' => "ASC");
}
$product_list = get_posts($args);
if ($product_list) {
echo '<h3>' . $current_category_name . '</h3>' . "\n";
echo '<p>' . sprintf(__('Drag %s to the preferred order and then click the Save button at the bottom of the page.', 'foxyshop'), strtolower(FOXYSHOP_PRODUCT_NAME_PLURAL)) . '</p>';
echo '<form name="form_product_order" method="post" action="">' . "\n";
echo '<ul id="foxyshop_product_order_list" class="foxyshop_sort_list">' . "\n";
foreach ($product_list as $prod) {
$product = foxyshop_setup_product($prod);
if ($categoryID == 0) {
$current_count = $prod->menu_order;
} else {
$current_count = (int) get_post_meta($prod->ID, "_foxyshop_menu_order_" . $categoryID, true);
}
echo '<li id="id_' . $prod->ID . '" class="lineitem">';
echo '<img src="' . foxyshop_get_main_image() . '" />';
echo '<h4>' . $prod->post_title . '</h4>' . "\n";
echo foxyshop_price();
echo '<div class="counter">' . ($current_count + 1) . '</div>';
echo '<div style="clear: both; height: 1px;"></div>' . "\n";
echo '</li>' . "\n";
}
echo '</ul>' . "\n";
?>
<div style="width: 90%; height: 100px;">
<input type="submit" name="submit_new_product_order" id="submit_new_product_order" class="button-primary" value="<?php
_e('Save Custom Order', 'foxyshop');
?>
" onclick="javascript:orderPages(); return true;" /> <strong id="updateText"></strong>
<input type="submit" name="revert_product_order" id="revert_product_order" class="button" style="float: right;" value="<?php
_e('Revert To Original', 'foxyshop');
?>
" onclick="javascript:orderPages(); return true;" />
</div>
<input type="hidden" id="foxyshop_product_order_value" name="foxyshop_product_order_value" />
<input type="hidden" id="hdnParentID" name="hdnParentID" value="<?php
echo $parentID;
?>
" />
<input type="hidden" id="categoryID" name="categoryID" value="<?php
echo $categoryID;
?>
" />
<?php
wp_nonce_field('update-foxyshop-sorting-options');
?>
</form>
<?php
} else {
echo '<p><em>' . sprintf(__('No %s Found For This Category.', 'foxyshop'), FOXYSHOP_PRODUCT_NAME_PLURAL) . '</em></p>';
echo '<p><a href="edit.php?post_type=foxyshop_product&page=foxyshop_custom_sort&upgrade_menu_order=1&categoryID=' . $categoryID . '">Missing products? Click here.</a></p>';
}
}
?>
</div>
<script type="text/javascript">
function foxyshop_custom_order_load_event(){
jQuery("#foxyshop_product_order_list").sortable({
placeholder: "sortable-placeholder",
revert: false,
tolerance: "pointer",
update: function() {
var counter = 1;
jQuery("#foxyshop_product_order_list li").each(function() {
jQuery(this).find('.counter').html(counter);
counter++;
});
}
});
};
addLoadEvent(foxyshop_custom_order_load_event);
function orderPages() {
jQuery("#updateText").html("<?php
echo sprintf(__('Updating %s Order...', 'foxyshop'), FOXYSHOP_PRODUCT_NAME_SINGULAR);
?>
");
jQuery("#foxyshop_product_order_value").val(jQuery("#foxyshop_product_order_list").sortable("toArray"));
}
</script>
<?php
}
