/**
* WP eCommerce edit and add product category page functions
*
* These are the main WPSC Admin functions
*
* @package wp-e-commerce
* @since 3.7
*/
function wpsc_ajax_set_category_order()
{
global $wpdb;
$sort_order = $_POST['sort_order'];
$parent_id = $_POST['parent_id'];
$result = true;
foreach ($sort_order as $key => $value) {
if (!wpsc_update_meta($value, 'sort_order', $key, 'wpsc_category')) {
$result = false;
}
}
}
/**
* WP eCommerce edit and add product category page functions
*
* These are the main WPSC Admin functions
*
* @package wp-e-commerce
* @since 3.7
*/
function wpsc_ajax_set_category_order()
{
global $wpdb;
$sort_order = $_POST['sort_order'];
$parent_id = $_POST['parent_id'];
$result = true;
foreach ($sort_order as $key => $value) {
if (empty($value)) {
continue;
}
$value = preg_replace('/[^0-9]/', '', $value);
if (!wpsc_update_meta($value, 'sort_order', $key, 'wpsc_category')) {
$result = false;
}
}
}
/**
* setOrderMeta - add some details about the transaction that came from authorize.net
*/
function setOrderMeta()
{
$meta_key = '_wpsc_auth_net_status';
$type = 'wpsc_purchase_log';
wpsc_update_meta($this->purchase_id, $meta_key, $this->metaOrder, $type);
}
function wpsc_update_files()
{
global $wpdb, $user_ID;
$product_files = $wpdb->get_results("SELECT * FROM " . WPSC_TABLE_PRODUCT_FILES . "");
$wpsc_update = WPSC_Update::get_instance();
foreach ($product_files as $product_file) {
$wpsc_update->check_timeout();
$variation_post_ids = array();
if (!empty($product_file->product_id)) {
$product_post_id = (int) $wpdb->get_var($wpdb->prepare("SELECT `post_id` FROM `{$wpdb->postmeta}` WHERE meta_key = %s AND `meta_value` = %d LIMIT 1", '_wpsc_original_id', $product_file->product_id));
} else {
$product_post_id = (int) $wpdb->get_var("SELECT `id` FROM " . WPSC_TABLE_PRODUCT_LIST . " WHERE file=" . $product_file->id);
$product_post_id = (int) $wpdb->get_var($wpdb->prepare("SELECT `post_id` FROM `{$wpdb->postmeta}` WHERE meta_key = %s AND `meta_value` = %d LIMIT 1", '_wpsc_original_id', $product_post_id));
}
$variation_items = $wpdb->get_col("SELECT `id` FROM " . WPSC_TABLE_VARIATION_PROPERTIES . " WHERE `file` = '{$product_file->id}'");
if (count($variation_items) > 0) {
$variation_post_ids = $wpdb->get_col("SELECT `post_id` FROM `{$wpdb->postmeta}` WHERE meta_key = '_wpsc_original_variation_id' AND `meta_value` IN(" . implode(", ", $variation_items) . ")");
}
$attachment_template = array('post_mime_type' => $product_file->mimetype, 'post_title' => $product_file->filename, 'post_name' => $product_file->idhash, 'post_content' => '', 'post_parent' => $product_post_id, 'post_type' => "wpsc-product-file", 'post_status' => 'inherit');
$file_id = wpsc_get_meta($product_file->id, '_new_file_id', 'wpsc_files');
if ($file_id == null && count($variation_post_ids) == 0) {
$file_data = $attachment_template;
$file_data['post_parent'] = $product_post_id;
$new_file_id = wp_insert_post($file_data);
wpsc_update_meta($product_file->id, '_new_file_id', $new_file_id, 'wpsc_files');
}
if (count($variation_post_ids) > 0) {
foreach ($variation_post_ids as $variation_post_id) {
$old_file_id = get_product_meta($variation_post_id, 'old_file_id', true);
if ($old_file_id == null) {
$file_data = $attachment_template;
$file_data['post_parent'] = $variation_post_id;
$new_file_id = wp_insert_post($file_data);
update_product_meta($variation_post_id, 'old_file_id', $product_file->id, 'wpsc_files');
}
}
}
if (!empty($product_file->preview)) {
$preview_template = array('post_mime_type' => $product_file->preview_mimetype, 'post_title' => $product_file->preview, 'post_name' => $product_file->filename, 'post_content' => '', 'post_parent' => $new_file_id, 'post_type' => "wpsc-product-preview", 'post_status' => 'inherit');
wp_insert_post($preview_template);
}
}
$download_ids = $wpdb->get_col("SELECT `id` FROM " . WPSC_TABLE_DOWNLOAD_STATUS . "");
foreach ($download_ids as $download_id) {
if (wpsc_get_meta($download_id, '_is_legacy', 'wpsc_downloads') !== 'false') {
wpsc_update_meta($download_id, '_is_legacy', 'true', 'wpsc_downloads');
}
}
}
/**
* sets a property for a country, well know properties are not allowed to be set using this function,
* but arbitrary properties can be set (and accessed later with get)
*
*
* @access public
*
* @since 3.8.14
*
* @return self, to support method chaining
*/
public function set($property, $value = '')
{
if (is_array($property)) {
foreach ($property as $key => $value) {
$this->set($key, $value);
}
} else {
$key = $property;
$property_name = '_' . $key;
if (property_exists($this, $property_name)) {
$value = $this->{$property_name};
_wpsc_doing_it_wrong(__FUNCTION__, __('Using set to change a well-known WPSC_Country property is deprecated as of version 3.8.14. Use the class constructor and specify all properties together to perform and insert or an update.', 'wpsc'), '3.8.14');
if (defined('WPSC_LOAD_DEPRECATED') && WPSC_LOAD_DEPRECATED) {
$country_array = $this->as_array();
$country_array[$key] = $value;
$this->_save_country_data($country_array);
}
} else {
wpsc_update_meta($this->_id, $key, $value, __CLASS__);
}
}
return $this;
}
/**
* save to database method
* @access public
*
* @param integer purchase log id
*/
function save_to_db($purchase_log_id)
{
global $wpdb, $wpsc_shipping_modules;
$method = $this->cart->selected_shipping_method;
$shipping = 0;
if (!empty($method) && method_exists($wpsc_shipping_modules[$method], "get_item_shipping")) {
$shipping = $wpsc_shipping_modules[$this->cart->selected_shipping_method]->get_item_shipping($this);
}
if ($this->cart->has_total_shipping_discount()) {
$shipping = 0;
}
$shipping = apply_filters('wpsc_item_shipping_amount_db', $shipping, $this);
//initialize tax variables
$tax = 0;
$tax_rate = 0;
//wpec_taxes - calculate product tax and add to total price
$wpec_taxes_controller = new wpec_taxes_controller();
if ($wpec_taxes_controller->wpec_taxes_isincluded() && $wpec_taxes_controller->wpec_taxes_isenabled()) {
$taxes = $wpec_taxes_controller->wpec_taxes_calculate_included_tax($this);
$tax_rate = $taxes['rate'];
$tax = $taxes['tax'];
}
$wpdb->insert(WPSC_TABLE_CART_CONTENTS, array('prodid' => $this->product_id, 'name' => $this->get_title(), 'purchaseid' => $purchase_log_id, 'price' => $this->unit_price, 'pnp' => $shipping, 'tax_charged' => $tax, 'gst' => $tax_rate, 'quantity' => $this->quantity, 'donation' => $this->is_donation, 'no_shipping' => 0, 'custom_message' => $this->custom_message, 'files' => serialize($this->custom_file), 'meta' => NULL), array('%d', '%s', '%d', '%f', '%f', '%f', '%f', '%s', '%d', '%d', '%s', '%s', '%s'));
$cart_id = $wpdb->get_var("SELECT " . $wpdb->insert_id . " AS `id` FROM `" . WPSC_TABLE_CART_CONTENTS . "` LIMIT 1");
wpsc_update_cartmeta($cart_id, 'sku', $this->sku);
$downloads = get_option('max_downloads');
if ($this->is_downloadable == true) {
$product_files = (array) get_posts(array('post_type' => 'wpsc-product-file', 'post_parent' => $this->product_id, 'numberposts' => -1, 'post_status' => 'inherit'));
foreach ($product_files as $file) {
// if the file is downloadable, check that the file is real
$unique_id = sha1(uniqid(mt_rand(), true));
$wpdb->insert(WPSC_TABLE_DOWNLOAD_STATUS, array('product_id' => $this->product_id, 'fileid' => $file->ID, 'purchid' => $purchase_log_id, 'cartid' => $cart_id, 'uniqueid' => $unique_id, 'downloads' => $downloads, 'active' => 0, 'datetime' => date('Y-m-d H:i:s')), array('%d', '%d', '%d', '%d', '%s', '%s', '%d', '%s'));
$download_id = $wpdb->get_var("SELECT " . $wpdb->insert_id . " AS `id` FROM `" . WPSC_TABLE_DOWNLOAD_STATUS . "` LIMIT 1");
wpsc_update_meta($download_id, '_is_legacy', 'false', 'wpsc_downloads');
}
}
do_action('wpsc_save_cart_item', $cart_id, $this->product_id);
}
/**
* Update meta field for a category
*
* @param int $cat_id Category ID.
* @param string $meta_key The meta key to retrieve.
* @param string $meta_value The value to be stored.
* @return mixed True if updated
*/
function wpsc_update_categorymeta($cat_id, $meta_key, $meta_value)
{
return wpsc_update_meta($cat_id, $meta_key, $meta_value, 'wpsc_category');
}
/**
* Generate and store all the attendees information for a new order.
*
* @param int $id
* @param string $status (unused)
* @param string $old_status (unused)
* @param $purchase_log
*/
public function generate_tickets($id, $status, $old_status, $purchase_log)
{
if (empty($purchase_log)) {
return;
}
// Do not generate tickets until payment has been accepted/job dispatched
$complete = $purchase_log->is_accepted_payment() || $purchase_log->is_job_dispatched();
apply_filters('wpectickets_order_is_complete', $complete, $purchase_log);
if (!$complete) {
return;
}
// Bail if we already generated the info for this order
$done = wpsc_get_meta($id, $this->order_done, 'tribe_tickets');
if (!empty($done)) {
return;
}
$has_tickets = false;
// Get the items purchased in this order
$order_items = $purchase_log->get_cart_contents();
// Bail if the order is empty
if (empty($order_items)) {
return;
}
// Iterate over each product
foreach ((array) $order_items as $item) {
$order_attendee_id = 0;
$product_id = $item->prodid;
// Get the event this tickets is for
$event_id = get_post_meta($product_id, $this->event_key, true);
$optout = (bool) wpsc_get_cart_item_meta($item->purchaseid, self::ATTENDEE_OPTOUT_KEY, true);
if (!empty($event_id)) {
$has_tickets = true;
// Iterate over all the amount of tickets purchased (for this product)
$quantity = intval($item->quantity);
for ($i = 0; $i < $quantity; $i++) {
$attendee = array('post_status' => 'publish', 'post_title' => $id . ' | ' . $item->name . ' | ' . ($i + 1), 'post_type' => self::ATTENDEE_OBJECT, 'ping_status' => 'closed');
// Insert individual ticket purchased
$attendee_id = wp_insert_post($attendee);
update_post_meta($attendee_id, self::ATTENDEE_PRODUCT_KEY, $product_id);
update_post_meta($attendee_id, self::ATTENDEE_ORDER_KEY, $id);
update_post_meta($attendee_id, self::ATTENDEE_EVENT_KEY, $event_id);
update_post_meta($attendee_id, $this->security_code, $this->generate_security_code($id, $attendee_id));
update_post_meta($attendee_id, self::ATTENDEE_OPTOUT_KEY, $optout);
/**
* WPEC specific action fired when a WPEC-driven attendee ticket for an event is generated
*
* @param $attendee_id ID of attendee ticket
* @param $event_id ID of event
* @param $order_id WPEC order ID
* @param $product_id WPEC product ID
*/
do_action('event_tickets_wpec_attendee_created', $attendee_id, $event_id, $product_id);
/**
* Action fired when an attendee ticket is generated
*
* @param $attendee_id ID of attendee ticket
* @param $purchase_log WPEC purchase log object
* @param $product_id Product ID attendee is "purchasing"
* @param $order_attendee_id Attendee # for order
* @param $event_id The Event which this ticket belongs
*/
do_action('event_tickets_wpec_ticket_created', $attendee_id, $purchase_log, $product_id, $order_attendee_id, $event_id);
$this->record_attendee_user_id($attendee_id);
$order_attendee_id++;
}
}
}
if ($has_tickets) {
wpsc_update_meta($id, $this->order_done, '1', 'tribe_tickets');
// Send the email to the user
do_action('wpectickets-send-tickets-email', $purchase_log);
}
}
/**
* Generate and store all the attendees information for a new order.
* @param $purchase_log_object
*/
public function generate_tickets($id, $status, $old_status, $purchase_log)
{
if (empty($purchase_log)) {
return;
}
// Do not generate tickets until payment has been accepted/job dispatched
$complete = $purchase_log->is_accepted_payment() || $purchase_log->is_job_dispatched();
apply_filters('wpectickets_order_is_complete', $complete, $purchase_log);
if (!$complete) {
return;
}
// Bail if we already generated the info for this order
$done = wpsc_get_meta($id, $this->order_done, 'tribe_tickets');
if (!empty($done)) {
return;
}
$has_tickets = false;
// Get the items purchased in this order
$order_items = $purchase_log->get_cart_contents();
// Bail if the order is empty
if (empty($order_items)) {
return;
}
// Iterate over each product
foreach ((array) $order_items as $item) {
$product_id = $item->prodid;
// Get the event this tickets is for
$event_id = get_post_meta($product_id, $this->event_key, true);
if (!empty($event_id)) {
$has_tickets = true;
// Iterate over all the amount of tickets purchased (for this product)
$quantity = intval($item->quantity);
for ($i = 0; $i < $quantity; $i++) {
$attendee = array('post_status' => 'publish', 'post_title' => $id . ' | ' . $item->name . ' | ' . ($i + 1), 'post_type' => self::ATTENDEE_OBJECT, 'ping_status' => 'closed');
// Insert individual ticket purchased
$attendee_id = wp_insert_post($attendee);
update_post_meta($attendee_id, self::ATTENDEE_PRODUCT_KEY, $product_id);
update_post_meta($attendee_id, self::ATTENDEE_ORDER_KEY, $id);
update_post_meta($attendee_id, self::ATTENDEE_EVENT_KEY, $event_id);
update_post_meta($attendee_id, $this->security_code, $this->generate_security_code($id, $attendee_id));
}
}
}
if ($has_tickets) {
wpsc_update_meta($id, $this->order_done, '1', 'tribe_tickets');
// Send the email to the user
do_action('wpectickets-send-tickets-email', $purchase_log);
}
}
function wpsc_st_save_ip_address($purchase_log_object, $session_id, $display_to_screen)
{
if ($session_id) {
$purchase_id = wpsc_st_get_purchase_id($session_id);
if ($purchase_id) {
wpsc_update_meta($purchase_id, 'ip_address', wpsc_st_capture_ip_address(), 'purchase_log');
}
}
}
/**
* save to database method
* @access public
*
* @param integer purchase log id
*/
function save_to_db($purchase_log_id)
{
global $wpdb, $wpsc_shipping_modules;
$method = $this->cart->selected_shipping_method;
$shipping = 0;
if (!empty($method) && method_exists($wpsc_shipping_modules[$method], "get_item_shipping")) {
$shipping = $wpsc_shipping_modules[$this->cart->selected_shipping_method]->get_item_shipping($this);
}
if ($this->cart->has_total_shipping_discount()) {
$shipping = 0;
}
//initialize tax variables
$tax = 0;
$tax_rate = 0;
//wpec_taxes - calculate product tax and add to total price
$wpec_taxes_controller = new wpec_taxes_controller();
if ($wpec_taxes_controller->wpec_taxes_isincluded() && $wpec_taxes_controller->wpec_taxes_isenabled()) {
$taxes = $wpec_taxes_controller->wpec_taxes_calculate_included_tax($this);
$tax_rate = $taxes['rate'];
$tax = $taxes['tax'];
}
$wpdb->query($wpdb->prepare("INSERT INTO `" . WPSC_TABLE_CART_CONTENTS . "` (\n `prodid`, `name`, `purchaseid`, `price`, `pnp`,\n `tax_charged`, `gst`, `quantity`, `donation`,\n `no_shipping`, `custom_message`, `files`, `meta`\n ) VALUES ('%d', '%s', '%d', '%s', '%s', '%s', '%s', '%s', '%d', '0', '%s', '%s', NULL)", $this->product_id, $this->product_name, $purchase_log_id, $this->unit_price, (double) $shipping, (double) $tax, (double) $tax_rate, $this->quantity, $this->is_donation, $this->custom_message, serialize($this->custom_file)));
$cart_id = $wpdb->get_var("SELECT LAST_INSERT_ID() AS `id` FROM `" . WPSC_TABLE_CART_CONTENTS . "` LIMIT 1");
wpsc_update_cartmeta($cart_id, 'sku', $this->sku);
$downloads = get_option('max_downloads');
if ($this->is_downloadable == true) {
$product_files = (array) get_posts(array('post_type' => 'wpsc-product-file', 'post_parent' => $this->product_id, 'numberposts' => -1, 'post_status' => 'inherit'));
foreach ($product_files as $file) {
// if the file is downloadable, check that the file is real
$unique_id = sha1(uniqid(mt_rand(), true));
$wpdb->query("INSERT INTO `" . WPSC_TABLE_DOWNLOAD_STATUS . "` (\n `product_id` , `fileid` ,\n `purchid` , `cartid`,\n `uniqueid`, `downloads`,\n `active` , `datetime`\n ) VALUES (\n '{$this->product_id}', '{$file->ID}',\n '{$purchase_log_id}', '{$cart_id}',\n '{$unique_id}', '{$downloads}',\n '0', NOW()\n );");
$download_id = $wpdb->get_var("SELECT LAST_INSERT_ID() AS `id` FROM `" . WPSC_TABLE_DOWNLOAD_STATUS . "` LIMIT 1");
wpsc_update_meta($download_id, '_is_legacy', 'false', 'wpsc_downloads');
}
}
do_action('wpsc_save_cart_item', $cart_id, $this->product_id);
}
/**
* Pushes sales data back to Baikonur
*
* Only pushes once. Accounts for annoying potential edge case of status-switching admins
*
* @param WPSC_Purchase_Log object $purchase_log Purchase Log object
* @return void
*/
public static function push_sales_data($purchase_log_id, $current_status, $old_status, $purchase_log)
{
$purchase_log = new WPSC_Purchase_Log($purchase_log_id);
$id = absint($purchase_log->get('id'));
//Also checking is_order_received, as that's what Manual Payments do.
if ($purchase_log->is_transaction_completed() || $purchase_log->is_order_received()) {
$pushed_to_sass = wpsc_get_meta($id, '_pushed_to_wpeconomy', 'purchase_log');
if (empty($pushed_to_saas)) {
$data = $purchase_log->get_data();
$cart_contents = $purchase_log->get_cart_contents();
//We want to push sales data - but naturally, IDs will differ, even names could potentially.
//So we add the slug to the object we POST
foreach ($cart_contents as $key => $cart_item) {
$slug = get_post_field('post_name', $cart_item->prodid);
$cart_contents[$key]->slug = $slug;
}
$args = array('body' => array('data' => json_encode($data), 'cart_contents' => json_encode($cart_contents)));
$request = wp_remote_post('http://www.wpeconomy.org/?sales_data=true', $args);
$response = wp_remote_retrieve_response_code($request);
//For some reason, if the site is down, we want the ability to ensure we can grab the sale later.
$success = 200 === $response;
wpsc_update_meta($id, '_pushed_to_wpeconomy', $success, 'purchase_log');
}
}
}