/**
* Output an <img> tag of the site logo, at the size specified
* in the theme's add_theme_support() declaration.
*
* @uses Site_Logo::logo
* @uses Site_Logo::theme_size()
* @uses jetpack_has_site_logo()
* @uses jetpack_is_customize_preview()
* @uses esc_url()
* @uses home_url()
* @uses esc_attr()
* @uses wp_get_attachment_image()
* @uses apply_filters()
* @since 1.0
*/
function jetpack_the_site_logo()
{
$logo = site_logo()->logo;
$size = site_logo()->theme_size();
// Bail if no logo is set. Leave a placeholder if we're in the Customizer, though (needed for the live preview).
if (!jetpack_has_site_logo()) {
if (jetpack_is_customize_preview()) {
printf('<a href="%1$s" class="site-logo-link" style="display:none;"><img class="site-logo" data-size="%2$s" /></a>', esc_url(home_url('/')), esc_attr($size));
}
return;
}
// We have a logo. Logo is go.
$html = sprintf('<a href="%1$s" class="site-logo-link" rel="home">%2$s</a>', esc_url(home_url('/')), wp_get_attachment_image($logo['id'], $size, false, array('class' => "site-logo attachment-{$size}", 'data-size' => $size)));
echo apply_filters('jetpack_the_site_logo', $html, $logo, $size);
}
/**
* Output an <img> tag of the site logo, at the size specified
* in the theme's add_theme_support() declaration.
*
* @uses Site_Logo::logo
* @uses Site_Logo::theme_size()
* @uses jetpack_has_site_logo()
* @uses jetpack_is_customize_preview()
* @uses esc_url()
* @uses home_url()
* @uses esc_attr()
* @uses wp_get_attachment_image()
* @uses apply_filters()
* @since 1.0
*/
function jetpack_the_site_logo()
{
$logo = site_logo()->logo;
$size = site_logo()->theme_size();
$html = '';
// If no logo is set, but we're in the Customizer, leave a placeholder (needed for the live preview).
if (!jetpack_has_site_logo()) {
if (jetpack_is_customize_preview()) {
$html = sprintf('<a href="%1$s" class="site-logo-link" style="display:none;"><img class="site-logo" data-size="%2$s" /></a>', esc_url(home_url('/')), esc_attr($size));
}
} else {
$html = sprintf('<a href="%1$s" class="site-logo-link" rel="home" itemprop="url">%2$s</a>', esc_url(home_url('/')), wp_get_attachment_image($logo['id'], $size, false, array('class' => "site-logo attachment-{$size}", 'data-size' => $size, 'itemprop' => "logo")));
}
echo apply_filters('jetpack_the_site_logo', $html, $logo, $size);
}
/**
* Output an <img> tag of the site logo, at the size specified
* in the theme's add_theme_support() declaration.
*
* @uses Site_Logo::logo
* @uses Site_Logo::theme_size()
* @uses jetpack_has_site_logo()
* @uses jetpack_is_customize_preview()
* @uses esc_url()
* @uses home_url()
* @uses esc_attr()
* @uses wp_get_attachment_image()
* @uses apply_filters()
* @since 1.0
*/
function jetpack_the_site_logo()
{
$logo = site_logo()->logo;
$size = site_logo()->theme_size();
$html = '';
// If no logo is set, but we're in the Customizer, leave a placeholder (needed for the live preview).
if (!jetpack_has_site_logo()) {
if (jetpack_is_customize_preview()) {
$html = sprintf('<a href="%1$s" class="site-logo-link" style="display:none;"><img class="site-logo" data-size="%2$s" /></a>', esc_url(home_url('/')), esc_attr($size));
}
} else {
$html = sprintf('<a href="%1$s" class="site-logo-link" rel="home" itemprop="url">%2$s</a>', esc_url(home_url('/')), wp_get_attachment_image($logo['id'], $size, false, array('class' => "site-logo attachment-{$size}", 'data-size' => $size, 'itemprop' => "logo")));
}
/**
* Filter the Site Logo output.
*
* @since 3.2.0
*
* @param string $html Site Logo HTML output.
* @param array $logo Array of Site Logo details.
* @param string $size Size specified in add_theme_support declaration, or 'thumbnail' default.
*/
echo apply_filters('jetpack_the_site_logo', $html, $logo, $size);
}
* Validate and sanitize a new site logo setting.
*
* @param $input
* @return mixed 1 if checked, empty string if not checked.
*/
public function sanitize_logo_setting($input)
{
$input['id'] = absint($input['id']);
$input['url'] = esc_url_raw($input['url']);
// If the new setting doesn't point to a valid attachment, just reset the whole thing.
if (false == wp_get_attachment_image_src($input['id'])) {
$input = array('id' => (int) 0, 'sizes' => array(), 'url' => '');
}
return $input;
}
}
/**
* Allow themes and plugins to access Site_Logo methods and properties.
*
* @uses Site_Logo::instance()
* @return object Site_Logo
*/
function site_logo()
{
return Site_Logo::instance();
}
/**
* One site logo, please.
*/
site_logo();
*/
if (isset($osC_Template->rel_canonical)) {
echo $osC_Template->rel_canonical;
}
?>
<meta name="Generator" content="TomatoCart" />
</head>
<body>
<?php
if ($osC_Template->hasPageHeader()) {
?>
<div id="pageHeader">
<div class="container">
<div class="row-fluid">
<div class="span4 logo"><?php
echo site_logo();
?>
</div>
<div class="span8">
<div class="top-nav clearfix">
<ul>
<li>
<?php
if ($toC_Wishlist->hasContents()) {
$wishlists_products = $toC_Wishlist->getProducts();
echo osc_link_object(osc_href_link(FILENAME_ACCOUNT, 'wishlist', 'SSL'), $osC_Language->get('my_wishlist') . ' <span class="label label-info">' . count($wishlists_products) . '</span>');
} else {
echo osc_link_object(osc_href_link(FILENAME_ACCOUNT, 'wishlist', 'SSL'), $osC_Language->get('my_wishlist'));
}
?>
</li>
public function sync()
{
global $wp;
global $wpdb;
set_time_limit(0);
@ini_set('display_errors', '1');
@ini_set('zlib.output_compression', 'Off');
@ini_set('output_buffering', 'Off');
@ini_set('output_handler', '');
while (ob_get_level() > 1) {
@ob_end_clean();
}
if (ob_get_level() > 0) {
@ob_clean();
}
if (!in_array('woocommerce/woocommerce.php', apply_filters('active_plugins', get_option('active_plugins')))) {
$this->sendHttpHeaders('500 Config Error', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode(array('ack' => 'failed', 'message' => 'WooCommerce Deactivated'));
exit;
}
$type = $wp->query_vars['codisto-sync-route'];
if (strtolower($_SERVER['REQUEST_METHOD']) == 'get') {
if ($type == 'test' || $type == 'sync' && preg_match('/\\/sync\\/testHash\\?/', $_SERVER['REQUEST_URI'])) {
if (!$this->check_hash()) {
exit;
}
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode(array('ack' => 'ok'));
} else {
if ($type === 'settings') {
if (!$this->check_hash()) {
exit;
}
$logo_url = get_header_image();
if (function_exists('site_logo')) {
$logo = site_logo()->logo;
$logo_id = get_theme_mod('custom_logo');
$logo_id = $logo_id ? $logo_id : $logo['id'];
if ($logo_id) {
$logo_url = wp_get_attachment_image_src($logo_id, 'full');
$logo_url = $logo_url[0];
}
}
$currency = get_option('woocommerce_currency');
$dimension_unit = get_option('woocommerce_dimension_unit');
$weight_unit = get_option('woocommerce_weight_unit');
$default_location = explode(':', get_option('woocommerce_default_country'));
$country_code = isset($default_location[0]) ? $default_location[0] : '';
$state_code = isset($default_location[1]) ? $default_location[1] : '';
$response = array('ack' => 'ok', 'logo' => $logo_url, 'currency' => $currency, 'dimension_unit' => $dimension_unit, 'weight_unit' => $weight_unit, 'country_code' => $country_code, 'state_code' => $state_code);
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode($response);
exit;
} else {
if ($type === 'tax') {
if (!$this->check_hash()) {
exit;
}
$tax_enabled = true;
if (function_exists('wc_tax_enabled')) {
$tax_enabled = wc_tax_enabled();
} else {
$tax_enabled = get_option('woocommerce_calc_taxes') === 'yes';
}
if ($tax_enabled) {
$rates = $wpdb->get_results("SELECT tax_rate_country AS country, tax_rate_state AS state, tax_rate AS rate, tax_rate_name AS name, tax_rate_class AS class, tax_rate_order AS sequence, tax_rate_priority AS priority FROM `{$wpdb->prefix}woocommerce_tax_rates` ORDER BY tax_rate_order");
} else {
$rates = array();
}
$response = array('ack' => 'ok', 'tax_rates' => $rates);
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode($response);
exit;
} else {
if ($type === 'products') {
if (!$this->check_hash()) {
exit;
}
$page = isset($_GET['page']) ? (int) $_GET['page'] : 0;
$count = isset($_GET['count']) ? (int) $_GET['count'] : 0;
$product_ids = isset($_GET['product_ids']) ? json_decode(wp_unslash($_GET['product_ids'])) : null;
if (!is_null($product_ids)) {
if (!is_array($product_ids)) {
$product_ids = array($product_ids);
}
$product_ids = array_filter($product_ids, create_function('$v', 'return is_numeric($v);'));
if (!isset($_GET['count'])) {
$count = count($product_ids);
}
}
$products = $wpdb->get_results($wpdb->prepare("SELECT id AS id " . "FROM `{$wpdb->prefix}posts` AS P " . "WHERE post_type = 'product' " . "\t\tAND post_status IN ('publish', 'future', 'pending', 'private') " . "\t" . (is_array($product_ids) ? 'AND id IN (' . implode(',', $product_ids) . ')' : '') . "" . "ORDER BY ID LIMIT %d, %d", $page * $count, $count));
if (!is_array($product_ids) && $page === 0) {
$total_count = $wpdb->get_var("SELECT COUNT(*) FROM `{$wpdb->prefix}posts` WHERE post_type = 'product' AND post_status IN ('publish', 'future', 'pending', 'private')");
}
$acf_installed = function_exists('acf');
foreach ($products as $product) {
$wc_product = $this->get_product($product->id);
$categoryproduct = $wc_product->get_categories();
$product->sku = $wc_product->get_sku();
$product->name = html_entity_decode(apply_filters('woocommerce_product_title', $wc_product->post->post_title, $wc_product), ENT_COMPAT | ENT_HTML401, 'UTF-8');
$product->enabled = $wc_product->is_purchasable() && ($wc_product->managing_stock() || $wc_product->is_in_stock());
$product->price = $wc_product->get_price_excluding_tax();
$product->listprice = floatval($wc_product->get_regular_price());
$product->is_taxable = $wc_product->is_taxable();
$product->tax_class = $wc_product->get_tax_class();
$product->stock_control = $wc_product->managing_stock();
$product->stock_level = $wc_product->get_stock_quantity();
if (method_exists($wc_product, 'get_type')) {
$product->type = $wc_product->get_type();
} else {
$product->type = $wc_product->product_type;
}
$product->description = apply_filters('the_content', $wc_product->post->post_content);
$product->short_description = apply_filters('the_content', $wc_product->post->post_excerpt);
if (method_exists($wc_product, 'get_width')) {
$product->width = $wc_product->get_width();
if (!is_numeric($product->width)) {
unset($product->width);
}
$product->height = $wc_product->get_height();
if (!is_numeric($product->height)) {
unset($product->height);
}
$product->length = $wc_product->get_length();
if (!is_numeric($product->length)) {
unset($product->length);
}
} else {
$product->length = $wc_product->length;
$product->width = $wc_product->width;
$product->height = $wc_product->height;
}
$product->weight = $wc_product->get_weight();
if (!is_numeric($product->weight)) {
unset($product->weight);
}
if ($product->is_taxable && 'yes' === get_option('woocommerce_prices_include_tax')) {
$tax_rates = WC_Tax::get_shop_base_rate($product->tax_class);
$taxes = WC_Tax::calc_tax($product->listprice, $tax_rates, true);
$product->listprice = $product->listprice - array_sum($taxes);
}
if ($product->type == 'variable') {
$product->skus = array();
foreach ($wc_product->get_children() as $child_id) {
$child_product = $wc_product->get_child($child_id);
$img = wp_get_attachment_image_src($child_product->get_image_id(), 'full');
$img = $img[0];
$child_product_data = array('id' => $child_id, 'sku' => $child_product->get_sku(), 'enabled' => $wc_product->is_purchasable() && ($wc_product->managing_stock() || $wc_product->is_in_stock()), 'price' => $child_product->get_price_excluding_tax(), 'listprice' => $child_product->get_regular_price(), 'is_taxable' => $child_product->is_taxable(), 'tax_class' => $child_product->get_tax_class(), 'stock_control' => $child_product->managing_stock(), 'stock_level' => $child_product->get_stock_quantity(), 'images' => array(array('source' => $img, 'sequence' => 0)));
$attributes = array();
$termsmap = array();
$names = array();
foreach ($child_product->get_variation_attributes() as $name => $value) {
$name = preg_replace('/(pa_)?attribute_/', '', $name);
if (!isset($names[$name])) {
$names[$name] = true;
$terms = get_terms(array('taxonomy' => $name));
if ($terms) {
foreach ($terms as $term) {
$termsmap[$term->slug] = $term->name;
}
}
}
if ($value && (gettype($value) == 'string' || gettype($value) == 'integer')) {
if (array_key_exists($value, $termsmap)) {
$newvalue = $termsmap[$value];
} else {
$newvalue = $value;
}
} else {
$newvalue = '';
}
$name = wc_attribute_label($name, $child_product);
$attributes[] = array('name' => $name, 'value' => $newvalue, 'slug' => $value);
}
foreach (get_post_custom_keys($child_product->variation_id) as $attribute) {
if (!(in_array($attribute, array('_sku', '_weight', '_length', '_width', '_height', '_thumbnail_id', '_virtual', '_downloadable', '_regular_price', '_sale_price', '_sale_price_dates_from', '_sale_price_dates_to', '_price', '_download_limit', '_download_expiry', '_file_paths', '_manage_stock', '_stock_status', '_downloadable_files', '_variation_description', '_tax_class', '_tax_status', '_stock', '_default_attributes', '_product_attributes', '_file_path', '_backorders')) || substr($attribute, 0, 4) === '_wp_' || substr($attribute, 0, 13) === 'attribute_pa_')) {
$value = get_post_meta($child_product->variation_id, $attribute, false);
if (is_array($value)) {
if (count($value) === 1) {
$value = $value[0];
} else {
$value = implode(',', $value);
}
}
$attributes[] = array('name' => $attribute, 'value' => $value, 'custom' => true);
}
}
$child_product_data['attributes'] = $attributes;
$product->skus[] = $child_product_data;
}
$attrs = array();
foreach ($wc_product->get_variation_attributes() as $name => $value) {
$name = preg_replace('/(pa_)?attribute_/', '', $name);
if (!isset($names[$name])) {
$names[$name] = true;
$terms = get_terms(array('taxonomy' => $name));
if ($terms) {
foreach ($terms as $term) {
$termsmap[$term->slug] = $term->name;
}
}
}
if ($value && (gettype($value) == 'string' || gettype($value) == 'integer')) {
if (array_key_exists($value, $termsmap)) {
$newvalue = $termsmap[$value];
} else {
$newvalue = $value;
}
} else {
$newvalue = '';
}
$name = wc_attribute_label($name, $child_product);
$attrs[] = array('name' => $name, 'value' => $newvalue, 'slug' => $value);
}
$product->options = $attrs;
} else {
if ($product->type == 'grouped') {
$product->skus = array();
foreach ($wc_product->get_children() as $child_id) {
$child_product = $wc_product->get_child($child_id);
$child_product_data = array('id' => $child_id, 'price' => $child_product->get_price_excluding_tax(), 'sku' => $child_product->get_sku(), 'name' => $child_product->get_title());
$product->skus[] = $child_product_data;
}
}
}
$product->categories = array();
$product_categories = get_the_terms($product->id, 'product_cat');
if (is_array($product_categories)) {
$sequence = 0;
foreach ($product_categories as $category) {
$product->categories[] = array('category_id' => $category->term_id, 'sequence' => $sequence);
$sequence++;
}
}
$image_sequence = 1;
$product->images = array();
$imagesUsed = array();
$primaryimage_path = wp_get_attachment_image_src($wc_product->get_image_id(), 'full');
$primaryimage_path = $primaryimage_path[0];
if ($primaryimage_path) {
$product->images[] = array('source' => $primaryimage_path, 'sequence' => 0);
$imagesUsed[$primaryimage_path] = true;
foreach ($wc_product->get_gallery_attachment_ids() as $image_id) {
$image_path = wp_get_attachment_image_src($image_id, 'full');
$image_path = $image_path[0];
if (!array_key_exists($image_path, $imagesUsed)) {
$product->images[] = array('source' => $image_path, 'sequence' => $image_sequence);
$imagesUsed[$image_path] = true;
$image_sequence++;
}
}
}
$product->attributes = array();
$attributesUsed = array();
foreach ($wc_product->get_attributes() as $attribute) {
if (!$attribute['is_variation']) {
if (!array_key_exists($attribute['name'], $attributesUsed)) {
$attributesUsed[$attribute['name']] = true;
$attributeName = wc_attribute_label($attribute['name']);
if (!$attribute['is_taxonomy']) {
$product->attributes[] = array('name' => $attributeName, 'value' => $attribute['value']);
} else {
$attributeValue = implode(', ', wc_get_product_terms($product->id, $attribute['name'], array('fields' => 'names')));
$product->attributes[] = array('name' => $attributeName, 'value' => $attributeValue);
}
}
}
}
foreach (get_post_custom_keys($product->id) as $attribute) {
if (!(substr($attribute, 0, 1) === '_' || substr($attribute, 0, 3) === 'pa_')) {
if (!array_key_exists($attribute, $attributesUsed)) {
$attributesUsed[$attribute] = true;
$value = get_post_meta($product->id, $attribute, false);
if (is_array($value)) {
if (count($value) === 1) {
$value = $value[0];
} else {
$value = implode(',', $value);
}
}
$product->attributes[] = array('name' => $attribute, 'value' => $value);
}
}
}
// acf
if ($acf_installed) {
if (function_exists('get_field_objects')) {
$fields = get_field_objects($product->id);
if (is_array($fields)) {
foreach ($fields as $field) {
if ($field['type'] == 'image') {
$image_path = $field['value']['url'];
if (!array_key_exists($image_path, $imagesUsed)) {
$product->images[] = array('source' => $image_path, 'sequence' => $image_sequence);
$imagesUsed[$image_path] = true;
$image_sequence++;
}
} else {
if ($field['type'] == 'gallery') {
$gallery = $field['value'];
if (is_array($gallery)) {
foreach ($gallery as $image) {
$image_path = $image['url'];
if (!array_key_exists($image_path, $imagesUsed)) {
$product->images[] = array('source' => $image_path, 'sequence' => $image_sequence);
$imagesUsed[$image_path] = true;
$image_sequence++;
}
}
}
} else {
if (in_array($field['type'], array('textarea', 'wysiwyg', 'text', 'number', 'select', 'radio', 'checkbox', 'true_false'))) {
if (!array_key_exists($field['label'], $attributesUsed)) {
$attributesUsed[$field['label']] = true;
$value = $field['value'];
if (is_array($value)) {
if (count($value) === 1) {
$value = $value[0];
} else {
$value = implode(',', $value);
}
}
$product->attributes[] = array('name' => $field['name'], 'value' => $value);
}
}
}
}
if (!$product->description) {
if (in_array($field['type'], array('textarea', 'wysiwyg')) && $field['name'] == 'description') {
$product->description = $field['value'];
}
}
}
}
}
}
}
$response = array('ack' => 'ok', 'products' => $products);
if (isset($total_count)) {
$response['total_count'] = $total_count;
}
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode($response);
exit;
} else {
if ($type === 'categories') {
if (!$this->check_hash()) {
exit;
}
$categories = get_categories(array('taxonomy' => 'product_cat', 'orderby' => 'term_order', 'hide_empty' => 0));
$result = array();
foreach ($categories as $category) {
$result[] = array('category_id' => $category->term_id, 'name' => $category->name, 'parent_id' => $category->parent);
}
$response = array('ack' => 'ok', 'categories' => $result, 'total_count' => count($categories));
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode($response);
exit;
} else {
if ($type === 'orders') {
if (!$this->check_hash()) {
exit;
}
$page = isset($_GET['page']) ? (int) $_GET['page'] : 0;
$count = isset($_GET['count']) ? (int) $_GET['count'] : 0;
$orders = $wpdb->get_results($wpdb->prepare("SELECT (SELECT meta_value FROM `{$wpdb->prefix}postmeta` WHERE post_id = P.id AND meta_key = '_codisto_orderid') AS id, ID AS post_id, post_status AS status FROM `{$wpdb->prefix}posts` AS P WHERE post_type = 'shop_order' AND ID IN (SELECT post_id FROM `{$wpdb->prefix}postmeta` WHERE meta_key = '_codisto_orderid') ORDER BY ID LIMIT %d, %d", $page * $count, $count));
if ($page == 0) {
$total_count = $wpdb->get_var("SELECT COUNT(*) FROM `{$wpdb->prefix}posts` AS P WHERE post_type = 'shop_order' AND ID IN (SELECT post_id FROM `{$wpdb->prefix}postmeta` WHERE meta_key = '_codisto_orderid')");
}
$order_data = array();
foreach ($orders as $order) {
$ship_date = get_post_meta($order->post_id, '_date_shipped', true);
if ($ship_date) {
if (is_numeric($ship_date)) {
$ship_date = date('Y-m-d H:i:s', $ship_date);
}
$order->ship_date = $ship_date;
}
$carrier = get_post_meta($order->post_id, '_tracking_provider', true);
if ($carrier) {
if ($carrier === 'custom') {
$carrier = get_post_meta($order->post_id, '_custom_tracking_provider', true);
}
if ($carrier) {
$order->carrier = $carrier;
}
}
$tracking_number = get_post_meta($order->post_id, '_tracking_number', true);
if ($tracking_number) {
$order->track_number = $tracking_number;
}
unset($order->post_id);
$order_data[] = $order;
}
$response = array('ack' => 'ok', 'orders' => $order_data);
if (isset($total_count)) {
$response['total_count'] = $total_count;
}
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode($response);
exit;
} else {
if ($type == 'sync') {
if ($_SERVER['HTTP_X_ACTION'] === 'TEMPLATE') {
if (!$this->check_hash()) {
exit;
}
$ebayDesignDir = WP_CONTENT_DIR . '/ebay/';
$merchantid = (int) $_GET['merchantid'];
if (!$merchantid) {
$merchantid = 0;
}
$templatedb = get_temp_dir() . '/ebay-template-' . $merchantid . '.db';
$db = new PDO('sqlite:' . $templatedb);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_TIMEOUT, 60);
$db->exec('PRAGMA synchronous=0');
$db->exec('PRAGMA temp_store=2');
$db->exec('PRAGMA page_size=65536');
$db->exec('PRAGMA encoding=\'UTF-8\'');
$db->exec('PRAGMA cache_size=15000');
$db->exec('PRAGMA soft_heap_limit=67108864');
$db->exec('PRAGMA journal_mode=MEMORY');
$db->exec('BEGIN EXCLUSIVE TRANSACTION');
$db->exec('CREATE TABLE IF NOT EXISTS File(Name text NOT NULL PRIMARY KEY, Content blob NOT NULL, LastModified datetime NOT NULL, Changed bit NOT NULL DEFAULT -1)');
$db->exec('COMMIT TRANSACTION');
if (isset($_GET['markreceived'])) {
$update = $db->prepare('UPDATE File SET LastModified = ? WHERE Name = ?');
$files = $db->query('SELECT Name FROM File WHERE Changed != 0');
$files->execute();
$db->exec('BEGIN EXCLUSIVE TRANSACTION');
while ($row = $files->fetch()) {
$stat = stat(WP_CONTENT_DIR . '/ebay/' . $row['Name']);
$lastModified = strftime('%Y-%m-%d %H:%M:%S', $stat['mtime']);
$update->bindParam(1, $lastModified);
$update->bindParam(2, $row['Name']);
$update->execute();
}
$db->exec('UPDATE File SET Changed = 0');
$db->exec('COMMIT TRANSACTION');
$db = null;
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, must-revalidate', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode(array('ack' => 'ok'));
exit;
} else {
$insert = $db->prepare('INSERT OR IGNORE INTO File(Name, Content, LastModified) VALUES (?, ?, ?)');
$update = $db->prepare('UPDATE File SET Content = ?, Changed = -1 WHERE Name = ? AND LastModified != ?');
$filelist = $this->files_in_dir($ebayDesignDir);
$db->exec('BEGIN EXCLUSIVE TRANSACTION');
foreach ($filelist as $key => $name) {
try {
$fileName = $ebayDesignDir . $name;
if (!in_array($name, array('README'))) {
$content = @file_get_contents($fileName);
if ($content !== false) {
$stat = stat($fileName);
$lastModified = strftime('%Y-%m-%d %H:%M:%S', $stat['mtime']);
$update->bindParam(1, $content);
$update->bindParam(2, $name);
$update->bindParam(3, $lastModified);
$update->execute();
if ($update->rowCount() == 0) {
$insert->bindParam(1, $name);
$insert->bindParam(2, $content);
$insert->bindParam(3, $lastModified);
$insert->execute();
}
}
}
} catch (Exception $e) {
}
}
$db->exec('COMMIT TRANSACTION');
$tmpDb = wp_tempnam();
$db = new PDO('sqlite:' . $tmpDb);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->exec('PRAGMA synchronous=0');
$db->exec('PRAGMA temp_store=2');
$db->exec('PRAGMA page_size=512');
$db->exec('PRAGMA encoding=\'UTF-8\'');
$db->exec('PRAGMA cache_size=15000');
$db->exec('PRAGMA soft_heap_limit=67108864');
$db->exec('PRAGMA journal_mode=OFF');
$db->exec('ATTACH DATABASE \'' . $templatedb . '\' AS Source');
$db->exec('CREATE TABLE File AS SELECT * FROM Source.File WHERE Changed != 0');
$db->exec('DETACH DATABASE Source');
$db->exec('VACUUM');
$fileCountStmt = $db->query('SELECT COUNT(*) AS fileCount FROM File');
$fileCountStmt->execute();
$fileCountRow = $fileCountStmt->fetch();
$fileCount = $fileCountRow['fileCount'];
$db = null;
if ($fileCount == 0) {
$this->sendHttpHeaders('204 No Content', array('Cache-Control' => 'no-cache, must-revalidate', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
} else {
$headers = array('Cache-Control' => 'no-cache, must-revalidate', 'Pragma' => 'no-cache', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Content-Type' => 'application/octet-stream', 'Content-Disposition' => 'attachment; filename=' . basename($tmpDb), 'Content-Length' => filesize($tmpDb));
$this->sendHttpHeaders('200 OK', $headers);
while (ob_get_level() > 0) {
if (!@ob_end_clean()) {
break;
}
}
flush();
readfile($tmpDb);
}
unlink($tmpDb);
exit;
}
}
}
}
}
}
}
}
}
} else {
if ($type === 'createorder') {
if (!$this->check_hash()) {
exit;
}
try {
$xml = simplexml_load_string(file_get_contents('php://input'));
$ordercontent = $xml->entry->content->children('http://api.codisto.com/schemas/2009/');
$wpdb->query('SET TRANSACTION ISOLATION LEVEL SERIALIZABLE');
$wpdb->query('START TRANSACTION');
$billing_address = $ordercontent->orderaddresses->orderaddress[0];
$shipping_address = $ordercontent->orderaddresses->orderaddress[1];
$billing_first_name = $billing_last_name = '';
if (strpos($billing_address->name, ' ') !== false) {
$billing_name = explode(' ', $billing_address->name, 2);
$billing_first_name = $billing_name[0];
$billing_last_name = $billing_name[1];
} else {
$billing_first_name = (string) $billing_address->name;
}
$billing_country_code = (string) $billing_address->countrycode;
$billing_division = (string) $billing_address->division;
$billing_states = WC()->countries->get_states($billing_country_code);
if ($billing_states) {
$billing_division_match = preg_replace('/\\s+/', '', strtolower($billing_division));
foreach ($billing_states as $state_code => $state_name) {
if (preg_replace('/\\s+/', '', strtolower($state_name)) == $billing_division_match) {
$billing_division = $state_code;
break;
}
}
}
$shipping_first_name = $shipping_last_name = '';
if (strpos($shipping_address->name, ' ') !== false) {
$shipping_name = explode(' ', $shipping_address->name, 2);
$shipping_first_name = $shipping_name[0];
$shipping_last_name = $shipping_name[1];
} else {
$shipping_first_name = (string) $shipping_address->name;
}
$shipping_country_code = (string) $shipping_address->countrycode;
$shipping_division = (string) $shipping_address->division;
if ($billing_country_code === $shipping_country_code) {
$shipping_states = $billing_states;
} else {
$shipping_states = WC()->countries->get_states($shipping_country_code);
}
if ($shipping_states) {
$shipping_division_match = preg_replace('/\\s+/', '', strtolower($shipping_division));
foreach ($shipping_states as $state_code => $state_name) {
if (preg_replace('/\\s+/', '', strtolower($state_name)) == $shipping_division_match) {
$shipping_division = $state_code;
break;
}
}
}
$address_data = array('billing_first_name' => $billing_first_name, 'billing_last_name' => $billing_last_name, 'billing_company' => (string) $billing_address->companyname, 'billing_address_1' => (string) $billing_address->address1, 'billing_address_2' => (string) $billing_address->address2, 'billing_city' => (string) $billing_address->place, 'billing_postcode' => (string) $billing_address->postalcode, 'billing_state' => $billing_division, 'billing_country' => $billing_country_code, 'billing_email' => (string) $billing_address->email, 'billing_phone' => (string) $billing_address->phone, 'shipping_first_name' => $shipping_first_name, 'shipping_last_name' => $shipping_last_name, 'shipping_company' => (string) $shipping_address->companyname, 'shipping_address_1' => (string) $shipping_address->address1, 'shipping_address_2' => (string) $shipping_address->address2, 'shipping_city' => (string) $shipping_address->place, 'shipping_postcode' => (string) $shipping_address->postalcode, 'shipping_state' => $shipping_division, 'shipping_country' => $shipping_country_code, 'shipping_email' => (string) $shipping_address->email, 'shipping_phone' => (string) $shipping_address->phone);
$email = (string) $billing_address->email;
if (!$email) {
$email = (string) $shipping_address->email;
}
if ($email) {
$user = get_user_by('email', $email);
if (!$user) {
$username = (string) $ordercontent->ebayusername;
if (!$username) {
$username = current(explode('@', $email));
}
if ($username) {
$username = sanitize_user($username);
}
if (username_exists($username)) {
$counter = 1;
$newusername = $username . $counter;
while (username_exists($newusername)) {
$counter++;
$newusername = $username . $counter;
}
$username = $newusername;
}
$password = wp_generate_password();
$customer_data = apply_filters('woocommerce_new_customer_data', array('user_login' => $username, 'user_pass' => $password, 'user_email' => $email, 'role' => 'customer'));
$customer_id = wp_insert_user($customer_data);
foreach ($address_data as $key => $value) {
update_user_meta($customer_id, $key, $value);
}
do_action('woocommerce_created_customer', $customer_id, $customer_data, true);
} else {
$customer_id = $user->ID;
}
} else {
$customer_id = 0;
}
$customer_note = @count($ordercontent->instructions) ? strval($ordercontent->instructions) : '';
$order_id = $wpdb->get_var($wpdb->prepare("SELECT ID FROM `{$wpdb->prefix}posts` AS P WHERE ID IN (SELECT post_id FROM `{$wpdb->prefix}postmeta` WHERE meta_key = '_codisto_orderid' AND meta_value = %d)", (int) $ordercontent->orderid));
$shipping = 0;
$shipping_tax = 0;
$cart_discount = 0;
$cart_discount_tax = 0;
$total = (double) $ordercontent->ordertotal;
$tax = 0;
if (!$order_id) {
$new_order_data_callback = array($this, 'order_set_date');
add_filter('woocommerce_new_order_data', $new_order_data_callback, 1, 1);
$order = wc_create_order(array('customer_id' => $customer_id, 'customer_note' => $customer_note, 'created_via' => 'eBay'));
remove_filter('woocommerce_new_order_data', $new_order_data_callback);
$order_id = $order->id;
update_post_meta($order_id, '_codisto_orderid', (int) $ordercontent->orderid);
update_post_meta($order_id, '_codisto_ebayuser', (string) $ordercontent->ebayusername);
update_post_meta($order_id, '_order_currency', (string) $ordercontent->transactcurrency);
update_post_meta($order_id, '_customer_ip_address', '-');
delete_post_meta($order_id, '_prices_include_tax');
do_action('woocommerce_new_order', $order_id);
foreach ($ordercontent->orderlines->orderline as $orderline) {
if ($orderline->productcode[0] != 'FREIGHT') {
$productcode = (string) $orderline->productcode;
if ($productcode == null) {
$productcode = '';
}
$productname = (string) $orderline->productname;
if ($productname == null) {
$productname = '';
}
$product_id = $orderline->externalreference[0];
if ($product_id != null) {
$product_id = intval($product_id);
}
$variation_id = 0;
if (get_post_type($product_id) === 'product_variation') {
$variation_id = $product_id;
$product_id = wp_get_post_parent_id($variation_id);
if (!is_numeric($product_id) || $product_id === 0) {
$product_id = 0;
$variation_id = 0;
}
}
$qty = (int) $orderline->quantity[0];
$item_id = wc_add_order_item($order_id, array('order_item_name' => $productname, 'order_item_type' => 'line_item'));
wc_add_order_item_meta($item_id, '_qty', $qty);
if (!is_null($product_id) && $product_id !== 0) {
wc_add_order_item_meta($item_id, '_product_id', $product_id);
wc_add_order_item_meta($item_id, '_variation_id', $variation_id);
wc_add_order_item_meta($item_id, '_tax_class', '');
} else {
wc_add_order_item_meta($item_id, '_product_id', 0);
wc_add_order_item_meta($item_id, '_variation_id', 0);
wc_add_order_item_meta($item_id, '_tax_class', '');
}
$line_total = wc_format_decimal((double) $orderline->linetotal);
$line_total_tax = wc_format_decimal((double) $orderline->linetotalinctax - (double) $orderline->linetotal);
wc_add_order_item_meta($item_id, '_line_subtotal', $line_total);
wc_add_order_item_meta($item_id, '_line_total', $line_total);
wc_add_order_item_meta($item_id, '_line_subtotal_tax', $line_total_tax);
wc_add_order_item_meta($item_id, '_line_tax', $line_total_tax);
wc_add_order_item_meta($item_id, '_line_tax_data', array('total' => array(1 => $line_total_tax), 'subtotal' => array(1 => $line_total_tax)));
$tax += $line_total_tax;
} else {
$item_id = wc_add_order_item($order_id, array('order_item_name' => (string) $orderline->productname, 'order_item_type' => 'shipping'));
wc_add_order_item_meta($item_id, 'cost', wc_format_decimal((double) $orderline->linetotal));
$shipping += (double) $orderline->linetotal;
$shipping_tax += (double) $orderline->linetotalinctax - (double) $orderline->linetotal;
}
}
if ($ordercontent->paymentstatus == 'complete') {
$transaction_id = (string) $ordercontent->orderpayments[0]->orderpayment->transactionid;
if ($transaction_id) {
update_post_meta($order_id, '_payment_method', 'paypal');
update_post_meta($order_id, '_payment_method_title', __('PayPal', 'woocommerce'));
update_post_meta($order_id, '_transaction_id', $transaction_id);
} else {
update_post_meta($order_id, '_payment_method', 'bacs');
update_post_meta($order_id, '_payment_method_title', __('BACS', 'woocommerce'));
}
// payment_complete
add_post_meta($order_id, '_paid_date', current_time('mysql'), true);
if (!get_post_meta($order_id, '_order_stock_reduced', true)) {
$order->reduce_order_stock();
}
}
} else {
$order = wc_get_order($order_id);
foreach ($ordercontent->orderlines->orderline as $orderline) {
if ($orderline->productcode[0] != 'FREIGHT') {
$line_total = wc_format_decimal((double) $orderline->linetotal);
$line_total_tax = wc_format_decimal((double) $orderline->linetotalinctax - (double) $orderline->linetotal);
$tax += $line_total_tax;
} else {
$order->remove_order_items('shipping');
$item_id = wc_add_order_item($order_id, array('order_item_name' => (string) $orderline->productname, 'order_item_type' => 'shipping'));
wc_add_order_item_meta($item_id, 'cost', wc_format_decimal((double) $orderline->linetotal));
$shipping += (double) $orderline->linetotal;
$shipping_tax += (double) $orderline->linetotalinctax - (double) $orderline->linetotal;
}
}
if ($ordercontent->paymentstatus == 'complete') {
$transaction_id = (string) $ordercontent->orderpayments[0]->orderpayment->transactionid;
if ($transaction_id) {
update_post_meta($order_id, '_payment_method', 'paypal');
update_post_meta($order_id, '_payment_method_title', __('PayPal', 'woocommerce'));
update_post_meta($order_id, '_transaction_id', $transaction_id);
} else {
update_post_meta($order_id, '_payment_method', 'bacs');
update_post_meta($order_id, '_payment_method_title', __('BACS', 'woocommerce'));
}
// payment_complete
add_post_meta($order_id, '_paid_date', current_time('mysql'), true);
if (!get_post_meta($order_id, '_order_stock_reduced', true)) {
$order->reduce_order_stock();
}
}
}
foreach ($address_data as $key => $value) {
update_post_meta($order_id, '_' . $key, $value);
}
$order->remove_order_items('tax');
$order->add_tax(1, $tax, $shipping_tax);
$order->set_total($shipping, 'shipping');
$order->set_total($shipping_tax, 'shipping_tax');
$order->set_total($cart_discount, 'cart_discount');
$order->set_total($cart_discount_tax, 'cart_discount_tax');
$order->set_total($tax, 'tax');
$order->set_total($total, 'total');
if ($ordercontent->orderstate == 'cancelled') {
if (!$order->has_status('cancelled')) {
// update_status
$order->post_status = 'wc-cancelled';
$update_post_data = array('ID' => $order_id, 'post_status' => 'wc-cancelled', 'post_date' => current_time('mysql', 0), 'post_date_gmt' => current_time('mysql', 1));
wp_update_post($update_post_data);
$order->decrease_coupon_usage_counts();
wc_delete_shop_order_transients($order_id);
}
} else {
if ($ordercontent->orderstate == 'inprogress' || $ordercontent->orderstate == 'processing') {
if ($ordercontent->paymentstatus == 'complete') {
if (!$order->has_status('processing')) {
// update_status
$order->post_status = 'wc-processing';
$update_post_data = array('ID' => $order_id, 'post_status' => 'wc-processing', 'post_date' => current_time('mysql', 0), 'post_date_gmt' => current_time('mysql', 1));
wp_update_post($update_post_data);
}
} else {
if (!$order->has_status('pending')) {
// update_status
$order->post_status = 'wc-pending';
$update_post_data = array('ID' => $order_id, 'post_status' => 'wc-pending', 'post_date' => current_time('mysql', 0), 'post_date_gmt' => current_time('mysql', 1));
wp_update_post($update_post_data);
}
}
} else {
if ($ordercontent->orderstate == 'complete') {
if (!$order->has_status('completed')) {
// update_status
$order->post_status = 'wc-completed';
$update_post_data = array('ID' => $order_id, 'post_status' => 'wc-completed', 'post_date' => current_time('mysql', 0), 'post_date_gmt' => current_time('mysql', 1));
wp_update_post($update_post_data);
$order->record_product_sales();
$order->increase_coupon_usage_counts();
update_post_meta($order_id, '_completed_date', current_time('mysql'));
wc_delete_shop_order_transients($order_id);
}
}
}
}
$wpdb->query('COMMIT');
$response = array('ack' => 'ok', 'orderid' => $order_id);
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode($response);
exit;
} catch (Exception $e) {
$wpdb->query('ROLLBACK');
$response = array('ack' => 'failed', 'message' => $e->getMessage() . ' ' . $e->getFile() . ' ' . $e->getLine());
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode($response);
exit;
}
} else {
if ($type == 'sync') {
if ($_SERVER['HTTP_X_ACTION'] === 'TEMPLATE') {
if (!$this->check_hash()) {
exit;
}
$ebayDesignDir = WP_CONTENT_DIR . '/ebay/';
$tmpPath = wp_tempnam();
@file_put_contents($tmpPath, file_get_contents('php://input'));
$db = new PDO('sqlite:' . $tmpPath);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->exec('PRAGMA synchronous=0');
$db->exec('PRAGMA temp_store=2');
$db->exec('PRAGMA page_size=65536');
$db->exec('PRAGMA encoding=\'UTF-8\'');
$db->exec('PRAGMA cache_size=15000');
$db->exec('PRAGMA soft_heap_limit=67108864');
$db->exec('PRAGMA journal_mode=MEMORY');
$files = $db->prepare('SELECT Name, Content FROM File');
$files->execute();
$files->bindColumn(1, $name);
$files->bindColumn(2, $content);
while ($files->fetch()) {
$fileName = $ebayDesignDir . $name;
if (strpos($name, '..') === false) {
if (!file_exists($fileName)) {
$dir = dirname($fileName);
if (!is_dir($dir)) {
mkdir($dir . '/', 0755, true);
}
@file_put_contents($fileName, $content);
}
}
}
$db = null;
unlink($tmpPath);
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode(array('ack' => 'ok'));
exit;
}
} else {
if ($type == 'index/calc') {
$product_ids = array();
$quantities = array();
for ($i = 0;; $i++) {
if (!isset($_POST['PRODUCTCODE(' . $i . ')'])) {
break;
}
$productid = (int) $_POST['PRODUCTID(' . $i . ')'];
if (!$productid) {
$productcode = $_POST['PRODUCTCODE(' . $i . ')'];
$productid = wc_get_product_id_by_sku($productcode);
}
$productqty = $_POST['PRODUCTQUANTITY(' . $i . ')'];
if (!$productqty && $productqty != 0) {
$productqty = 1;
}
WC()->cart->add_to_cart($productid, $productqty);
}
WC()->customer->set_location($_POST['COUNTRYCODE'], $_POST['DIVISION'], $_POST['POSTALCODE'], $_POST['PLACE']);
WC()->customer->set_shipping_location($_POST['COUNTRYCODE'], $_POST['DIVISION'], $_POST['POSTALCODE'], $_POST['PLACE']);
WC()->cart->calculate_totals();
WC()->cart->calculate_shipping();
$response = '';
$idx = 0;
$methods = WC()->shipping()->get_shipping_methods();
foreach ($methods as $method) {
if (file_exists(plugin_dir_path(__FILE__) . 'shipping/' . $method->id)) {
include plugin_dir_path(__FILE__) . 'shipping/' . $method->id;
} else {
foreach ($method->rates as $method => $rate) {
$method_name = $rate->get_label();
if (!$method_name) {
$method_name = 'Shipping';
}
$method_cost = $rate->cost;
if (is_numeric($method_cost)) {
if (isset($rate->taxes) && is_array($rate->taxes)) {
foreach ($rate->taxes as $tax) {
if (is_numeric($tax)) {
$method_cost += $tax;
}
}
}
$response .= ($idx > 0 ? '&' : '') . 'FREIGHTNAME(' . $idx . ')=' . rawurlencode($method_name) . '&FREIGHTCHARGEINCTAX(' . $idx . ')=' . number_format((double) $method_cost, 2, '.', '');
$idx++;
}
}
}
}
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $response;
exit;
}
}
}
}
}
}
if ($repeatCount + 1 == $max_repeat) {
$menu = $menu . "</li></ul></li>";
}
$depthRound++;
} else {
if ($repeatCount != 0) {
$menu = "</li>";
}
if ($depthRound > 0) {
$menu .= "</ul></li>";
}
$menu .= "{$li}<a href=\"{$header_link}\">{$menu_img}</a>";
if ($repeatCount + 1 == $max_repeat) {
$menu = $menu . "</li>";
}
$depthRound = 0;
}
$repeatCount++;
$loop->skin_modeling("[menu]", $menu);
echo $loop->skin_echo();
$menu = "";
} while ($mysql->nextRec());
}
//footer
$footer->skin_modeling("[logo]", site_logo());
$footer->skin_modeling("[site_url]", site_url_func());
$footer->skin_modeling("[site_name]", $site_config['ad_site_name']);
$footer->skin_modeling("[status]", status_func());
$footer->skin_modeling("[/layoutskinDir/]", __URL_PATH__ . "layoutskin/" . CALLED_LAYOUTDIR);
echo $footer->skin_echo();
