function pp_add_order_item_meta($item_id, $cart_item) { global $woocommerce; if (!empty($cart_item['_w2p_set_option'])) { woocommerce_add_order_item_meta($item_id, '_w2p_set_option', $cart_item['_w2p_set_option']); } }
/** * After ordering, add the data to the order line items. * * @access public * @param mixed $item_id * @param mixed $cart_item * @return void * @since 8.0.0 */ public function add_order_item_meta($item_id, $cart_item) { $length = get_post_meta($cart_item['product_id'], '_length', TRUE); $width = get_post_meta($cart_item['product_id'], '_width', TRUE); $height = get_post_meta($cart_item['product_id'], '_height', TRUE); $is_volumetrik_enabled = get_post_meta($cart_item['product_id'], $this->meta, TRUE); if ($is_volumetrik_enabled == 'yes' && !empty($length) && !empty($width) && !empty($height)) { woocommerce_add_order_item_meta($item_id, __('Dimension', 'agenwebsite'), sprintf('%u x %u x %u cm', $length, $width, $height)); } }
/** * Save entered credit value by customer in order item meta * * @param int $item_id * @param array $values associative array containing item's details */ public function save_called_credit_details_in_order_item_meta($item_id, $values) { $coupon_titles = get_post_meta($values['product_id'], '_coupon_title', true); if ($this->is_coupon_amount_pick_from_product_price($coupon_titles) && isset($values['data']->price) && $values['data']->price > 0) { woocommerce_add_order_item_meta($item_id, 'sc_called_credit', $values['data']->price); } }
/** * woocommerce_add_line_tax function. * * @access public * @return void */ function woocommerce_add_line_tax() { global $woocommerce, $wpdb; check_ajax_referer('calc-totals', 'security'); $order_id = absint($_POST['order_id']); $order = new WC_Order($order_id); // Get tax rates $rates = $wpdb->get_results("SELECT tax_rate_id, tax_rate_country, tax_rate_state, tax_rate_name, tax_rate_priority FROM {$wpdb->prefix}woocommerce_tax_rates ORDER BY tax_rate_name"); $tax_codes = array(); foreach ($rates as $rate) { $code = array(); $code[] = $rate->tax_rate_country; $code[] = $rate->tax_rate_state; $code[] = $rate->tax_rate_name ? sanitize_title($rate->tax_rate_name) : 'TAX'; $code[] = absint($rate->tax_rate_priority); $tax_codes[$rate->tax_rate_id] = strtoupper(implode('-', array_filter($code))); } // Add line item $item_id = woocommerce_add_order_item($order_id, array('order_item_name' => '', 'order_item_type' => 'tax')); // Add line item meta if ($item_id) { woocommerce_add_order_item_meta($item_id, 'rate_id', ''); woocommerce_add_order_item_meta($item_id, 'label', ''); woocommerce_add_order_item_meta($item_id, 'compound', ''); woocommerce_add_order_item_meta($item_id, 'tax_amount', ''); woocommerce_add_order_item_meta($item_id, 'shipping_tax_amount', ''); } include 'admin/post-types/writepanels/order-tax-html.php'; // Quit out die; }
/** * Save sold by text in database * * @param item_id, cart_item * @return void */ function order_item_meta_2($item_id, $cart_item) { global $WCMp; if ($WCMp->vendor_caps->vendor_frontend_settings('sold_by_cart_and_checkout')) { $general_cap = isset($this->frontend_cap['sold_by_text']) ? $this->frontend_cap['sold_by_text'] : ''; if (!$general_cap) { $general_cap = 'Sold By'; } $vendor = get_wcmp_product_vendors($cart_item['product_id']); if ($vendor) { woocommerce_add_order_item_meta($item_id, $general_cap, $vendor->user_data->display_name); woocommerce_add_order_item_meta($item_id, '_vendor_id', $vendor->id); } } }
public function save_vendor_settings() { global $woocommerce; $user_id = get_current_user_id(); if (!empty($_GET['wc_pv_mark_shipped'])) { $shop_name = WCV_Vendors::get_vendor_shop_name($user_id); $order_id = $_GET['wc_pv_mark_shipped']; $shippers = (array) get_post_meta($order_id, 'wc_pv_shipped', true); $order = new WC_Order($order_id); // If not in the shippers array mark as shipped otherwise do nothing. if (!in_array($user_id, $shippers)) { $shippers[] = $user_id; $mails = $woocommerce->mailer()->get_emails(); if (!empty($mails)) { $mails['WC_Email_Notify_Shipped']->trigger($order_id, $user_id); } do_action('wcvendors_vendor_ship', $order_id, $user_id); wc_add_notice(__('Order marked shipped.', 'wcvendors'), 'success'); $order->add_order_note(apply_filters('wcvendors_vendor_shipped_note', __($shop_name . ' has marked as shipped. ', 'wcvendors')), $user_id); } elseif (false != ($key = array_search($user_id, $shippers))) { unset($shippers[$key]); // Remove user from the shippers array } update_post_meta($order_id, 'wc_pv_shipped', $shippers); return; } if (isset($_POST['update_tracking'])) { $order_id = (int) $_POST['order_id']; $product_id = (int) $_POST['product_id']; $tracking_provider = woocommerce_clean($_POST['tracking_provider']); $custom_tracking_provider = woocommerce_clean($_POST['custom_tracking_provider_name']); $custom_tracking_link = woocommerce_clean($_POST['custom_tracking_url']); $tracking_number = woocommerce_clean($_POST['tracking_number']); $date_shipped = woocommerce_clean(strtotime($_POST['date_shipped'])); $order = new WC_Order($order_id); $products = $order->get_items(); foreach ($products as $key => $value) { if ($value['product_id'] == $product_id || $value['variation_id'] == $product_id) { $order_item_id = $key; break; } } if ($order_item_id) { woocommerce_delete_order_item_meta($order_item_id, __('Tracking number', 'wcvendors')); woocommerce_add_order_item_meta($order_item_id, __('Tracking number', 'wcvendors'), $tracking_number); $message = __('Success. Your tracking number has been updated.', 'wcvendors'); wc_add_notice($message, 'success'); // Update order data update_post_meta($order_id, '_tracking_provider', $tracking_provider); update_post_meta($order_id, '_custom_tracking_provider', $custom_tracking_provider); update_post_meta($order_id, '_tracking_number', $tracking_number); update_post_meta($order_id, '_custom_tracking_link', $custom_tracking_link); update_post_meta($order_id, '_date_shipped', $date_shipped); } } if (empty($_POST['vendor_application_submit'])) { return false; } if (isset($_POST['wc-product-vendor-nonce'])) { if (!wp_verify_nonce($_POST['wc-product-vendor-nonce'], 'save-shop-settings')) { return false; } if (isset($_POST['pv_paypal'])) { if (!is_email($_POST['pv_paypal'])) { wc_add_notice(__('Your PayPal address is not a valid email address.', 'wcvendors'), 'error'); } else { update_user_meta($user_id, 'pv_paypal', $_POST['pv_paypal']); } } if (!empty($_POST['pv_shop_name'])) { $users = get_users(array('meta_key' => 'pv_shop_slug', 'meta_value' => sanitize_title($_POST['pv_shop_name']))); if (!empty($users) && $users[0]->ID != $user_id) { wc_add_notice(__('That shop name is already taken. Your shop name must be unique.', 'wcvendors'), 'error'); } else { update_user_meta($user_id, 'pv_shop_name', $_POST['pv_shop_name']); update_user_meta($user_id, 'pv_shop_slug', sanitize_title($_POST['pv_shop_name'])); } } if (isset($_POST['pv_shop_description'])) { update_user_meta($user_id, 'pv_shop_description', $_POST['pv_shop_description']); } if (isset($_POST['pv_seller_info'])) { update_user_meta($user_id, 'pv_seller_info', $_POST['pv_seller_info']); } do_action('wcvendors_shop_settings_saved', $user_id); if (!wc_notice_count()) { wc_add_notice(__('Settings saved.', 'wcvendors'), 'success'); } } }
function booking_order_box() { global $woocommerce, $wpdb; check_ajax_referer('order-item', 'security'); $meta_id_next = ''; $meta_id = ''; $meta_id = woocommerce_add_order_item_meta(absint($_POST['order_item_id']), __('Name', 'woocommerce'), __('Value', 'woocommerce')); //print_r($meta_ids); //echo $meta_id; die(); /*$meta_query = $check_query = "SELECT MAX(meta_id) AS meta_id FROM `".$wpdb->prefix."woocommerce_order_itemmeta` WHERE order_item_id ='".$_POST['order_item_id']."' "; $meta_results = $wpdb->get_results($meta_query); $meta_id = $meta_results[0]->meta_id;*/ $bookings_added = woocommerce_get_order_item_meta($_POST['order_item_id'], get_option("book.date-label"), true); if ($bookings_added == '') { //print_r("ehre".$bookings_added);die(); if ($meta_id) { $check_query = "SELECT meta_value AS product_id FROM `" . $wpdb->prefix . "woocommerce_order_itemmeta`\n\t\t\t\t\t\tWHERE meta_key ='_product_id'\n\t\t\t\t\t\tAND order_item_id ='" . $_POST['order_item_id'] . "'\n\t\t\t\t\t\t"; $results_check = $wpdb->get_results($check_query); $product_id = $results_check[0]->product_id; //print_r($product_id); $prod_id = get_post_meta($product_id, '_icl_lang_duplicate_of', true); if ($prod_id == '' && $prod_id == null) { // $duplicate_of = $cart_item['product_id']; $post_time = get_post($product_id); $id_query = "SELECT ID FROM `" . $wpdb->prefix . "posts` WHERE post_date = '" . $post_time->post_date . "' ORDER BY ID LIMIT 1"; $results_post_id = $wpdb->get_results($id_query); if (isset($results_post_id)) { $prod_id = $results_post_id[0]->ID; } else { $prod_id = $product_id; } } $cart_item_key = $_POST['order_item_id']; $product_settings = get_post_meta($prod_id, 'woocommerce_booking_settings', true); $i = 0; //echo "PROD<pre>";print_r($product_settings);echo "</pre>"; echo '<input type="hidden" id="order_item_ids" name="order_item_ids" value="' . $_POST['order_item_id'] . '"/>'; if (isset($product_settings['booking_enable_multiple_day']) && $product_settings['booking_enable_multiple_day'] == 'on' && (isset($product_settings['booking_fixed_block_enable']) && $product_settings['booking_fixed_block_enable'] == 'yes')) { $results = $this->get_fixed_blocks($prod_id); //print_r($results);die(); if (count($results) > 0) { echo '<tr data-meta_id="' . $meta_id . '"><td><input type="text" name="meta_key[' . $meta_id . ']" value="Select Period" /></td><td><select name="meta_value[' . $meta_id . ']" id="admin_block_option_' . $_POST['order_item_id'] . '">'; foreach ($results as $key => $value) { echo '<option id = ' . $value->start_day . '&' . $value->number_of_days . '&' . $value->price . ' value="' . $value->block_name . '">' . $value->block_name . '</option>'; } echo '</select></td><td width="1%"><button class="remove_order_item_meta button">×</button></td></tr>'; $meta_id_start = $meta_id + 1; $meta_id_end = $meta_id_start + 1; echo '<input type="hidden" id="meta_id_start" name="meta_id_start" value="' . $meta_id_start . '"/>'; echo '<input type="hidden" id="meta_id_end" name="meta_id_end" value="' . $meta_id_end . '"/>'; ?> <script type="text/javascript"> var order_item_id = jQuery("#order_item_ids").val(); jQuery("#admin_block_option_"+order_item_id).change(function() { //alert(); if ( jQuery("#admin_block_option_"+order_item_id).val() != "" ) { var passed_id = jQuery(this).children(":selected").attr("id"); var exploded_id = passed_id.split('&'); console.log(exploded_id); var meta_id_start = jQuery("#meta_id_start").val(); var meta_id_end = jQuery("#meta_id_end").val(); jQuery("#admin_block_option_start_day_"+order_item_id).val(exploded_id[0]); jQuery("#admin_block_option_number_of_day_"+order_item_id).val(exploded_id[1]); jQuery("#admin_block_option_price_"+order_item_id).val(exploded_id[2]); jQuery("#wapbk_admin_hidden_date_"+order_item_id).val(""); jQuery("#wapbk_admin_hidden_date_checkout_"+order_item_id).val(""); //jQuery("#show_time_slot").html(""); jQuery("#admin_booking_calender_"+ meta_id_start).datepicker("setDate"); jQuery("#admin_booking_calender_checkout_" + meta_id_end).datepicker("setDate"); } }); </script> <?php if (count($results) >= 0) { $sd = $results[0]->start_day; $nd = $results[0]->number_of_days; $pd = $results[0]->price; } echo ' <input type="hidden" id="admin_block_option_enabled_' . $_POST['order_item_id'] . '" name="admin_block_option_enabled_' . $_POST['order_item_id'] . '" value="on"/> <input type="hidden" id="admin_block_option_start_day_' . $_POST['order_item_id'] . '" name="admin_block_option_start_day_' . $_POST['order_item_id'] . '" value="' . $sd . '"/> <input type="hidden" id="admin_block_option_number_of_day_' . $_POST['order_item_id'] . '" name="admin_block_option_number_of_day_' . $_POST['order_item_id'] . '" value="' . $nd . '"/> <input type="hidden" id="admin_block_option_price_' . $_POST['order_item_id'] . '"name="admin_block_option_price_' . $_POST['order_item_id'] . '" value="' . $pd . '"/>'; } else { $number_of_fixed_price_blocks = 0; echo ' <input type="hidden" id="admin_block_option_enabled_' . $_POST['order_item_id'] . '" name="admin_block_option_enabled_' . $_POST['order_item_id'] . '" value="off"/> <input type="hidden" id="admin_block_option_start_day_' . $_POST['order_item_id'] . '" name="admin_block_option_start_day_' . $_POST['order_item_id'] . '" value=""/> <input type="hidden" id="admin_block_option_number_of_day_' . $_POST['order_item_id'] . '" name="admin_block_option_number_of_day_' . $_POST['order_item_id'] . '" value=""/> <input type="hidden" id="admin_block_option_price_' . $_POST['order_item_id'] . '" name="admin_block_option_price_' . $_POST['order_item_id'] . '" value=""/>'; } $meta_ids[$cart_item_key][$i] = $meta_id; $meta_id = $meta_id + 1; $i++; } if (isset($product_settings['booking_enable_date']) && $product_settings['booking_enable_date'] == 'on') { $saved_settings = json_decode(get_option('woocommerce_booking_global_settings')); //echo "<pre>";print_r($saved_settings);echo "</pre>"; //woocommerce_add_order_item_meta( $item_number,get_option("book.date-label"),''); //$order = new WC_Order($order_id); //$meta = $order->has_meta($item_number); if ($saved_settings == '') { $saved_settings = new stdClass(); $saved_settings->booking_date_format = 'd MM, yy'; $saved_settings->booking_time_format = '12'; $saved_settings->booking_months = '1'; } $meta_ids[$cart_item_key][$i] = $meta_id; $i++; echo '<tr data-meta_id="' . $meta_id . '"><td><input type="text" name="meta_key[' . $meta_id . ']" value="' . get_option("book.item-meta-date") . '" /></td><td><input type="text" name="meta_value[' . $meta_id . ']" value="" /></td><td width="1%"><button class="remove_order_item_meta button">×</button></td></tr>'; if ($product_settings != '') { // fetch specific booking dates $booking_dates_arr = $product_settings['booking_specific_date']; $booking_dates_str = ""; $meta_id_next = 0; //$meta_id_checkout = 0; if ($product_settings['booking_specific_booking'] == "on") { if (!empty($booking_dates_arr)) { foreach ($booking_dates_arr as $k => $v) { $booking_dates_str .= '"' . $v . '",'; } } $booking_dates_str = substr($booking_dates_str, 0, strlen($booking_dates_str) - 1); } print '<input type="hidden" name="wapbk_admin_booking_dates_' . $_POST['order_item_id'] . '" id="wapbk_admin_booking_dates_' . $_POST['order_item_id'] . '" value=\'' . $booking_dates_str . '\'>'; if (isset($saved_settings->booking_global_holidays)) { $book_global_holidays = $saved_settings->booking_global_holidays; $book_global_holidays = substr($book_global_holidays, 0, strlen($book_global_holidays)); $book_global_holidays = '"' . str_replace(',', '","', $book_global_holidays) . '"'; } else { $book_global_holidays = ''; } //echo "here";die(); print '<input type="hidden" name="wapbk_admin_booking_global_holidays_' . $_POST['order_item_id'] . '" id="wapbk_admin_booking_global_holidays_' . $_POST['order_item_id'] . '" value=\'' . $book_global_holidays . '\'>'; $booking_holidays_string = '"' . str_replace(',', '","', $product_settings['booking_product_holiday']) . '"'; print '<input type="hidden" name="wapbk_admin_booking_holidays_' . $_POST['order_item_id'] . '" id="wapbk_admin_booking_holidays_' . $_POST['order_item_id'] . '" value=\'' . $booking_holidays_string . '\'>'; //Default settings $default = "Y"; if (isset($product_settings['booking_recurring_booking']) && $product_settings['booking_recurring_booking'] == "on" || isset($product_settings['booking_specific_booking']) && $product_settings['booking_specific_booking'] == "on") { $default = "N"; } foreach ($product_settings['booking_recurring'] as $wkey => $wval) { if ($default == "Y") { print '<input type="hidden" name="wapbk_admin_' . $wkey . '_' . $_POST['order_item_id'] . '" id="wapbk_admin_' . $wkey . '_' . $_POST['order_item_id'] . '" value="on">'; } else { if ($product_settings['booking_recurring_booking'] == "on") { print '<input type="hidden" name="wapbk_admin_' . $wkey . '_' . $_POST['order_item_id'] . '" id="wapbk_admin_' . $wkey . '_' . $_POST['order_item_id'] . '" value="' . $wval . '">'; } else { print '<input type="hidden" name="wapbk_admin_' . $wkey . '_' . $_POST['order_item_id'] . '" id="wapbk_admin_' . $wkey . '_' . $_POST['order_item_id'] . '" value="">'; } } } if (isset($product_settings['booking_time_settings'])) { print '<input type="hidden" name="wapbk_admin_booking_times_' . $_POST['order_item_id'] . '" id="wapbk_admin_booking_times_' . $_POST['order_item_id'] . '" value=\'' . $product_settings['booking_time_settings'] . '\'>'; } else { print '<input type="hidden" name="wapbk_admin_booking_times_' . $_POST['order_item_id'] . '" id="wapbk_admin_booking_times_' . $_POST['order_item_id'] . '" value="">'; } if (isset($product_settings['booking_enable_multiple_day'])) { print '<input type="hidden" id="wapbk_admin_multiple_day_booking_' . $_POST['order_item_id'] . '" name="wapbk_admin_multiple_day_booking_' . $_POST['order_item_id'] . '" value="' . $product_settings['booking_enable_multiple_day'] . '"/>'; } else { print '<input type="hidden" id="wapbk_admin_multiple_day_booking_' . $_POST['order_item_id'] . '" name="wapbk_admin_multiple_day_booking_' . $_POST['order_item_id'] . '" value=""/>'; } if (isset($product_settings['booking_minimum_number_days'])) { print '<input type="hidden" name="wapbk_admin_minimumOrderDays_' . $_POST['order_item_id'] . '" id="wapbk_admin_minimumOrderDays_' . $_POST['order_item_id'] . '" value="' . $product_settings['booking_minimum_number_days'] . '">'; } else { print '<input type="hidden" name="wapbk_admin_minimumOrderDays_' . $_POST['order_item_id'] . '" id="wapbk_admin_minimumOrderDays_' . $_POST['order_item_id'] . '" value="">'; } if (isset($product_settings['booking_maximum_number_days'])) { print '<input type="hidden" name="wapbk_admin_number_of_dates_' . $_POST['order_item_id'] . '" id="wapbk_admin_number_of_dates_' . $_POST['order_item_id'] . '" value="' . $product_settings['booking_maximum_number_days'] . '">'; } else { print '<input type="hidden" name="wapbk_admin_number_of_dates_' . $_POST['order_item_id'] . '" id="wapbk_admin_number_of_dates_' . $_POST['order_item_id'] . '" value="">'; } if (isset($product_settings['booking_enable_time'])) { print '<input type="hidden" name="wapbk_admin_bookingEnableTime_' . $_POST['order_item_id'] . '" id="wapbk_admin_bookingEnableTime_' . $_POST['order_item_id'] . '" value="' . $product_settings['booking_enable_time'] . '">'; } else { print '<input type="hidden" name="wapbk_admin_bookingEnableTime_' . $_POST['order_item_id'] . '" id="wapbk_admin_bookingEnableTime_' . $_POST['order_item_id'] . '" value="">'; } if (isset($product_settings['booking_recurring_booking'])) { print '<input type="hidden" name="wapbk_admin_recurringDays_' . $_POST['order_item_id'] . '" id="wapbk_admin_recurringDays_' . $_POST['order_item_id'] . '" value="' . $product_settings['booking_recurring_booking'] . '">'; } else { print '<input type="hidden" name="wapbk_admin_recurringDays_' . $_POST['order_item_id'] . '" id="wapbk_admin_recurringDays_' . $_POST['order_item_id'] . '" value="">'; } if (isset($product_settings['booking_specific_booking'])) { print '<input type="hidden" name="wapbk_admin_specificDates_' . $_POST['order_item_id'] . '" id="wapbk_admin_specificDates_' . $_POST['order_item_id'] . '" value="' . $product_settings['booking_specific_booking'] . '">'; } else { print '<input type="hidden" name="wapbk_admin_specificDates_' . $_POST['order_item_id'] . '" id="wapbk_admin_specificDates_' . $_POST['order_item_id'] . '" value="">'; } //echo "here";die(); global $woocommerce_booking; $lockout_query = "SELECT DISTINCT start_date FROM `" . $wpdb->prefix . "booking_history`\n\t\t\t\t\t\t\t\tWHERE post_id='" . $prod_id . "'\n\t\t\t\t\t\t\t\tAND total_booking > 0\n\t\t\t\t\t\t\t\tAND available_booking = 0"; $results_lockout = $wpdb->get_results($lockout_query); //print_r($results_lockout);die(); $lockout_query = "SELECT DISTINCT start_date FROM `" . $wpdb->prefix . "booking_history`\n\t\t\t\t\tWHERE post_id='" . $prod_id . "'\n\t\t\t\t\tAND available_booking > 0"; //echo $lockout_query;die(); $results_lock = $wpdb->get_results($lockout_query); $lockout_date = ''; //print_r($results_lock);exit; foreach ($results_lock as $key => $value) { $start_date = $value->start_date; $bookings_done = $this->date_lockout($start_date, $prod_id); if ($bookings_done >= $product_settings['booking_date_lockout']) { $lockout = explode("-", $start_date); $lockout_date .= '"' . intval($lockout[2]) . "-" . intval($lockout[1]) . "-" . $lockout[0] . '",'; } } //echo $date_lockout;die(); $lockout_str = substr($lockout_date, 0, strlen($lockout_date) - 1); foreach ($results_lockout as $k => $v) { foreach ($results_lock as $key => $value) { if ($v->start_date == $value->start_date) { $date_lockout = "SELECT COUNT(start_date) FROM `" . $wpdb->prefix . "booking_history`\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE post_id='" . $prod_id . "'\n\t\t\t\t\t\t\t\t\t\t\t\tAND start_date='" . $v->start_date . "'\n\t\t\t\t\t\t\t\t\t\t\t\tAND available_booking = 0"; $results_date_lock = $wpdb->get_results($date_lockout); if ($product_settings['booking_date_lockout'] > $results_date_lock[0]->{'COUNT(start_date)'}) { unset($results_lockout[$k]); } } } } $lockout_dates_str = ""; foreach ($results_lockout as $k => $v) { $lockout_temp = $v->start_date; $lockout = explode("-", $lockout_temp); $lockout_dates_str .= '"' . intval($lockout[2]) . "-" . intval($lockout[1]) . "-" . $lockout[0] . '",'; $lockout_temp = ""; } $lockout_dates_str = substr($lockout_dates_str, 0, strlen($lockout_dates_str) - 1); $lockout_dates = $lockout_dates_str . "," . $lockout_str; print '<input type="hidden" name="wapbk_admin_lockout_days_' . $_POST['order_item_id'] . '" id="wapbk_admin_lockout_days_' . $_POST['order_item_id'] . '" value=\'' . $lockout_dates . '\'>'; $todays_date = date('Y-m-d'); //print_r($todays_date);die(); $query_date = "SELECT DATE_FORMAT(start_date,'%d-%c-%Y') as start_date,DATE_FORMAT(end_date,'%d-%c-%Y') as end_date FROM " . $wpdb->prefix . "booking_history WHERE start_date >='" . $todays_date . "' AND post_id = '" . $prod_id . "'"; //echo $query_date; $results_date = $wpdb->get_results($query_date); //print_r($results_date); $dates_new = array(); $booked_dates = array(); foreach ($results_date as $k => $v) { $start_date = $v->start_date; $end_date = $v->end_date; $dates = $woocommerce_booking->betweendays($start_date, $end_date); //print_r($dates); $dates_new = array_merge($dates, $dates_new); } // Enable the start date for the booking period for checkout foreach ($results_date as $k => $v) { $start_date = $v->start_date; //echo ($start_date); $end_date = $v->end_date; //echo ($end_date); $new_start = strtotime("+1 day", strtotime($start_date)); $new_start = date("d-m-Y", $new_start); //echo $new_start; $dates = $woocommerce_booking->betweendays($new_start, $end_date); $booked_dates = array_merge($dates, $booked_dates); } //print_r($dates); //print_r($booked_dates); $dates_new_arr = array_count_values($dates_new); $booked_dates_arr = array_count_values($booked_dates); //print_r($booking_settings); $lockout = ""; if (isset($product_settings['booking_date_lockout'])) { $lockout = $product_settings['booking_date_lockout']; } //echo "ehre".$lockout; $new_arr_str = ''; foreach ($dates_new_arr as $k => $v) { if ($v >= $lockout && $lockout != 0) { //print_r($v); //print_r($lockout); $date_temp = $k; $date = explode("-", $date_temp); $new_arr_str .= '"' . intval($date[0]) . "-" . intval($date[1]) . "-" . $date[2] . '",'; $date_temp = ""; //$new_arr_str .= '"'.$k.'",'; } } //$new_arr_str = date('d-m-Y',$new_arr_str); $new_arr_str = substr($new_arr_str, 0, strlen($new_arr_str) - 1); //print_r($new_arr_str); print "<input type='hidden' id='wapbk_admin_hidden_booked_dates_" . $_POST['order_item_id'] . "' name='wapbk_admin_hidden_booked_dates_" . $_POST['order_item_id'] . "' value='" . $new_arr_str . "'/>"; //checkout calendar booked dates $blocked_dates = array(); $booked_dates_str = ""; foreach ($booked_dates_arr as $k => $v) { if ($v >= $lockout && $lockout != 0) { $date_temp = $k; $date = explode("-", $date_temp); $date_without_zero_prefixed = intval($date[0]) . "-" . intval($date[1]) . "-" . $date[2]; $booked_dates_str .= '"' . intval($date[0]) . "-" . intval($date[1]) . "-" . $date[2] . '",'; $date_temp = ""; $blocked_dates[] = $date_without_zero_prefixed; // $new_arr_str .= '"'.$k.'",'; } } if (isset($booked_dates_str)) { $booked_dates_str = substr($booked_dates_str, 0, strlen($booked_dates_str) - 1); } else { $booked_dates_str = ""; } print "<input type='hidden' id='wapbk_admin_hidden_booked_dates_checkout_" . $_POST['order_item_id'] . "' name='wapbk_admin_hidden_booked_dates_checkout_" . $_POST['order_item_id'] . "' value='" . $booked_dates_str . "'/>"; print '<input type="hidden" id="wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '" name="wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '" />'; print '<input type="hidden" id="wapbk_admin_hidden_date_checkout_' . $_POST['order_item_id'] . '" name="wapbk_admin_hidden_date_checkout_' . $_POST['order_item_id'] . '" />'; } $method_to_show = 'check_for_time_slot_admin'; $options_checkin = $options_checkout = array(); //$options_checkin = $options_checkout = array(); $js_code = $blocked_dates_hidden_var = ''; $block_dates = array(); $block_dates = (array) apply_filters('bkap_block_dates', $prod_id, $blocked_dates); //print_r($block_dates);exit; if (isset($block_dates) && count($block_dates) > 0) { $i = 1; $bvalue = array(); $add_day = ''; $same_day = ''; foreach ($block_dates as $bkey => $bvalue) { if (isset($bvalue['dates']) && count($bvalue['dates']) > 0) { $blocked_dates_str = '"' . implode('","', $bvalue['dates']) . '"'; } else { $blocked_dates_str = ""; } /* if ( ( isset($bvalue['field_name']) && $bvalue['field_name'] == '' ) || !isset($bvalue['field_name']) ) $bvalue['field_name'] = $i; $fld_name = 'woobkap_'.str_replace(' ','_', $bvalue['field_name']);*/ $field_name = $i; if (isset($bvalue['field_name']) && $bvalue['field_name'] != '') { $field_name = $bvalue['field_name']; } $fld_name = 'woobkap_' . str_replace(' ', '_', $field_name); $fld_name_admin = $fld_name . '_' . $_POST['order_item_id']; //echo $fld_name; print "<input type='hidden' id='" . $fld_name_admin . "' name='" . $fld_name_admin . "' value='" . $blocked_dates_str . "'/>"; $i++; if (isset($bvalue['add_days_to_charge_booking'])) { $add_day = $bvalue['add_days_to_charge_booking']; } if ($add_day == '') { $add_day = 0; } print "<input type='hidden' id='add_days_" . $_POST['order_item_id'] . "' name='add_days_'" . $_POST['order_item_id'] . "' value='" . $blocked_dates_str . "'/>"; if (isset($bvalue['same_day_booking'])) { $same_day = $bvalue['same_day_booking']; } print "<input type='hidden' id='wapbk_admin_same_day_" . $_POST['order_item_id'] . "' name='wapbk_admin_same_day_" . $_POST['order_item_id'] . "' value='" . $same_day . "'/>"; } // if (!isset($bvalue['date_label'])) $bvalue['date_label'] = 'Unavailable for Booking'; if (isset($bvalue['date_label']) && $bvalue['date_label'] != '') { $date_label = $bvalue['date_label']; } else { $date_label = 'Unavailable for Booking'; } //if (isset($bvalue['add_days_to_charge_booking']) && $bvalue['add_days_to_charge_booking'] == '') $add_day = 0; $js_code = ' var ' . $fld_name_admin . ' = eval("["+jQuery("#' . $fld_name_admin . '").val()+"]"); for (i = 0; i < ' . $fld_name_admin . '.length; i++) { if( jQuery.inArray(d + "-" + (m+1) + "-" + y,' . $fld_name_admin . ') != -1 ) { //alert(); return [false, "", "' . $date_label . '"]; } } '; $js_block_date = ' var ' . $fld_name_admin . ' = eval("["+jQuery("#' . $fld_name_admin . '").val()+"]"); var date = new_end = new Date(CheckinDate); var m = date.getMonth(), d = date.getDate(), y = date.getFullYear(); //alert(count); for (var i = 1; i<= count;i++) { if( jQuery.inArray(d + "-" + (m+1) + "-" + y,' . $fld_name_admin . ') != -1 ) { jQuery("#wapbk_hidden_date_checkout").val(""); jQuery("#booking_calender_checkout").val(""); jQuery( ".single_add_to_cart_button" ).hide(); jQuery( ".quantity" ).hide(); CalculatePrice = "N"; alert("Some of the dates in the selected range are on rent. Please try another date range."); break; } new_end = new Date(ad(new_end,1)); //alert(new_end); var m = new_end.getMonth(), d = new_end.getDate(), y = new_end.getFullYear(); }'; } if (isset($product_settings['booking_enable_multiple_day']) && $product_settings['booking_enable_multiple_day'] == 'on') { //woocommerce_add_order_item_meta( $item_number,get_option("checkout.date-label"),''); $meta_id_next = $meta_id + 1; $meta_ids[$cart_item_key][$i] = $meta_id_next; echo '<tr data-meta_id="' . $meta_id_next . '"><td><input type="text" name="meta_key[' . $meta_id_next . ']" value="' . strip_tags(get_option("checkout.item-meta-date")) . '" /></td><td><input type="text" name="meta_value[' . $meta_id_next . ']" value="" /></td><td width="1%"><button class="remove_order_item_meta button">×</button></td></tr>'; $options_checkout[] = "minDate: 1"; $options_checkin[] = 'onClose: function( selectedDate, inst ) { var monthValue = inst.selectedMonth+1; var dayValue = inst.selectedDay; var yearValue = inst.selectedYear; var current_sel_dt = dayValue + "-" + monthValue + "-" + yearValue; jQuery("#wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '").val(current_sel_dt); jQuery( "tr[data-meta_id=\\"' . $meta_id_next . '\\"]" ).show(); if(jQuery("#admin_block_option_enabled_' . $_POST['order_item_id'] . '").val() == "on") { ///alert(); //jQuery("#show_time_slot").show(); var nod= parseInt(jQuery("#admin_block_option_number_of_day_' . $_POST['order_item_id'] . '").val(),10); if(jQuery("#wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '").val() != "") { var num_of_day= jQuery("#admin_block_option_number_of_day_' . $_POST['order_item_id'] . '").val(); var split = jQuery("#wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '").val().split("-"); split[1] = split[1] - 1; var minDate = new Date(split[2],split[1],split[0]); minDate.setDate(minDate.getDate() + nod ); //var kc=new Date(Date.parse(selectedDate)); //kc.setDate(kc.getDate() + nod ); //var newDate = kc.toDateString(); //newDate = new Date( Date.parse( newDate ) ); console.log(minDate); jQuery("input[name=\\"meta_value[' . $meta_id_next . ']\\"]").datepicker("setDate",minDate); //var objDate= jQuery( "#admin_booking_calender_checkout").datepicker("getDate"); //var strDate = objDate.getDate() + "-" + (objDate.getMonth() + 1) + "-" + objDate.getFullYear(); //jQuery("#wapbk_hidden_date_checkout").val(strDate); // calculate_price(); // disabled calendar //jQuery( "#booking_calender_checkout" ).prop("disabled", true); //jQuery("#show_time_slot").hide(); //jQuery(".amount").hide(); } } else { if (jQuery("#wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '").val() != "") { if(jQuery("#wapbk_admin_same_day_' . $_POST['order_item_id'] . '").val() == "on") { if (jQuery("#wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '").val() != "") { var split = jQuery("#wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '").val().split("-"); split[1] = split[1] - 1; var minDate = new Date(split[2],split[1],split[0]); minDate.setDate(minDate.getDate()); //alert(minDate); jQuery( "input[name=\\"meta_value[' . $meta_id_next . ']\\"]" ).datepicker( "option", "minDate", minDate); } } else { var split = jQuery("#wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '").val().split("-"); split[1] = split[1] - 1; var minDate = new Date(split[2],split[1],split[0]); minDate.setDate(minDate.getDate() + 1); //alert(minDate); jQuery( "input[name=\\"meta_value[' . $meta_id_next . ']\\"]" ).datepicker( "option", "minDate", minDate); } } } }'; $options_checkout[] = "onSelect: get_per_night_price"; $options_checkin[] = "onSelect: set_checkin_date"; $options_checkout[] = "beforeShowDay: check_booked_dates"; $options_checkin[] = "beforeShowDay: check_booked_dates"; } else { if (isset($product_settings['booking_enable_time']) && $product_settings['booking_enable_time'] == 'on') { $meta_id_next = $meta_id + 1; $meta_ids[$cart_item_key][$i] = $meta_id_next; //woocommerce_add_order_item_meta( $item_number,get_option('book.time-label'),''); echo '<tr data-meta_id="' . $meta_id_next . '"><td><input type="text" name="meta_key[' . $meta_id_next . ']" value="' . get_option('book.time-label') . '" /></td><td><input type="text" name="meta_value[' . $meta_id_next . ']" value="" /></td><td width="1%"><button class="remove_order_item_meta button">×</button></td></tr>'; //$meta = $order->has_meta($item_number); $options_checkin[] = "beforeShowDay: show_book"; $options_checkin[] = "onSelect: show_times"; $options_checkin[] = 'onClose: function( selectedDate, inst ) { var monthValue = inst.selectedMonth+1; var dayValue = inst.selectedDay; var yearValue = inst.selectedYear; var current_sel_dt = dayValue + "-" + monthValue + "-" + yearValue; jQuery("#wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '").val(current_sel_dt); jQuery( "tr[data-meta_id=\\"' . $meta_id_next . '\\"]" ).show(); }'; } else { $options_checkin[] = 'onClose: function( selectedDate, inst ) { var monthValue = inst.selectedMonth+1; var dayValue = inst.selectedDay; var yearValue = inst.selectedYear; var current_sel_dt = dayValue + "-" + monthValue + "-" + yearValue; jQuery("#wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '").val(current_sel_dt); }'; $options_checkin[] = "beforeShowDay: show_book"; $options_checkin[] = "onSelect: show_times"; } } $options_checkin_str = ''; if (count($options_checkin) > 0) { $options_checkin_str = implode(',', $options_checkin); } $options_checkout_str = ''; if (count($options_checkout) > 0) { $options_checkout_str = implode(',', $options_checkout); } $meta_ids_str = ''; if (count($meta_ids) > 0) { $meta_ids_str = implode(',', $meta_ids[$cart_item_key]); } echo '<input type="hidden" name="meta_ids' . $cart_item_key . '" id="meta_ids' . $cart_item_key . '" value="' . $meta_ids_str . '" />'; print ' <script type="text/javascript"> jQuery(document).ready(function() { jQuery.extend(jQuery.datepicker, { afterShow: function(event) { jQuery.datepicker._getInst(event.target).dpDiv.css("z-index", 9999); }}); var today = new Date(); jQuery(function() { jQuery( "tr[data-meta_id=\\"' . $meta_id_next . '\\"]" ).hide(); jQuery( "input[name=\\"meta_value[' . $meta_id . ']\\"]" ).datepicker({ beforeShow: avd, minDate:today, dateFormat: "' . $saved_settings->booking_date_format . '", numberOfMonths: parseInt(' . $saved_settings->booking_months . '), ' . $options_checkin_str . ' , }).focus(function (event) { jQuery.datepicker.afterShow(event); }); }); jQuery( "input[name=\\"meta_value[' . $meta_id . ']\\"]" ).wrap("<div class=\\"hasDatepicker\\"></div>"); jQuery( "input[name=\\"meta_value[' . $meta_id . ']\\"]" ).attr("id","admin_booking_calender_' . $meta_id . '"); jQuery( "input[name=\\"meta_value[' . $meta_id_next . ']\\"]" ).attr("id","admin_booking_calender_checkout_' . $meta_id_next . '"); }); '; //if (isset($product_settings['booking_enable_timeslot']) == 'on') if (isset($product_settings['booking_enable_multiple_day']) && $product_settings['booking_enable_multiple_day'] == 'on') { print 'jQuery("input[name=\\"meta_value[' . $meta_id_next . ']\\"]").datepicker({ dateFormat: "' . $saved_settings->booking_date_format . '", numberOfMonths: parseInt(' . $saved_settings->booking_months . '), ' . $options_checkout_str . ' , onClose: function( selectedDate ) { jQuery( "input[name=\\"meta_value[' . $meta_id . ']\\"]" ).datepicker( "option", "maxDate", selectedDate ); }, }).focus(function (event) { jQuery.datepicker.afterShow(event); }); jQuery( "input[name=\\"meta_value[' . $meta_id_next . ']\\"]" ).wrap("<div class=\\"hasDatepicker\\"></div>"); '; } print ' function check_booked_dates(date) { var m = date.getMonth(), d = date.getDate(), y = date.getFullYear(); var holidayDates = eval("["+jQuery("#wapbk_admin_booking_holidays_' . $_POST['order_item_id'] . '").val()+"]"); var globalHolidays = eval("["+jQuery("#wapbk_admin_booking_global_holidays_' . $_POST['order_item_id'] . '").val()+"]"); //alert(jQuery("#wapbk_admin_hidden_booked_dates_' . $_POST['order_item_id'] . '").val()); var bookedDates=eval("[" + jQuery("#wapbk_admin_hidden_booked_dates_' . $_POST['order_item_id'] . '").val() + "]"); var bookedDatesCheckout = eval("["+jQuery("#wapbk_admin_hidden_booked_dates_checkout_' . $_POST['order_item_id'] . '").val()+"]"); var block_option_start_day= jQuery("#admin_block_option_start_day_' . $_POST['order_item_id'] . '").val(); var block_option_price= jQuery("#admin_block_option_price_' . $_POST['order_item_id'] . '").val(); //alert(block_option_start_day); for (iii = 0; iii < globalHolidays.length; iii++) { if( jQuery.inArray(d + "-" + (m+1) + "-" + y,globalHolidays) != -1 ) { return [false, "", "Holiday"]; } } for (ii = 0; ii < holidayDates.length; ii++) { if( jQuery.inArray(d + "-" + (m+1) + "-" + y,holidayDates) != -1 ) { return [false, "", "Holiday"]; } } var id_booking = jQuery(this).attr("id"); //alert(id_booking); if (id_booking == "admin_booking_calender_' . $meta_id . '" || id_booking == "inline_calendar") { for (iii = 0; iii < bookedDates.length; iii++) { //alert(bookedDates); if( jQuery.inArray(d + "-" + (m+1) + "-" + y,bookedDates) != -1 ) { return [false, "", "Unavailable for Booking"]; } } } if (id_booking == "admin_booking_calender_checkout_' . $meta_id_next . '" || id_booking == "inline_calendar_checkout") { //alert(); for (iii = 0; iii < bookedDatesCheckout.length; iii++) { //alert(bookedDates); if( jQuery.inArray(d + "-" + (m+1) + "-" + y,bookedDatesCheckout) != -1 ) { return [false, "", "Unavailable for Booking"]; } } } var block_option_enabled= jQuery("#admin_block_option_enabled_' . $_POST['order_item_id'] . '").val(); if (block_option_enabled =="on") { if ( id_booking == "admin_booking_calender_' . $meta_id . '" || id_booking == "inline_calendar" ) { //alert(date.getDay()); if (block_option_start_day == date.getDay()) { return [true]; } else { return [false]; } } var bcc_date=jQuery( "input[name=\\"meta_value[' . $meta_id_next . ']\\"]").datepicker("getDate"); //alert(bcc_date); if(bcc_date != null) { var dd = bcc_date.getDate(); var mm = bcc_date.getMonth()+1; //January is 0! var yyyy = bcc_date.getFullYear(); var checkout = dd + "-" + mm + "-"+ yyyy; jQuery("#wapbk_admin_hidden_date_checkout_' . $_POST['order_item_id'] . '").val(checkout); if (id_booking == "admin_booking_calender_checkout_' . $meta_id_next . '" || id_booking == "inline_calendar_checkout"){ if (Date.parse(bcc_date) === Date.parse(date)){ return [true]; }else{ return [false]; } } } } ' . $js_code . ' return [true]; } function show_book(date) { //var date = new Date(); var m = date.getMonth(), d = date.getDate(), y = date.getFullYear(); // .html() is used when we have zip code groups enabled var deliveryDates = eval("["+jQuery("#wapbk_admin_booking_dates_' . $_POST['order_item_id'] . '").val()+"]"); var holidayDates = eval("["+jQuery("#wapbk_admin_booking_holidays_' . $_POST['order_item_id'] . '").val()+"]"); var globalHolidays = eval("["+jQuery("#wapbk_admin_booking_global_holidays_' . $_POST['order_item_id'] . '").val()+"]"); //Lockout Dates var lockoutdates = eval("["+jQuery("#wapbk_admin_lockout_days_' . $_POST['order_item_id'] . '").val()+"]"); var bookedDates = eval("["+jQuery("#wapbk_admin_hidden_booked_dates_' . $_POST['order_item_id'] . '").val()+"]"); var dt = new Date(); var today = dt.getMonth() + "-" + dt.getDate() + "-" + dt.getFullYear(); for (iii = 0; iii < lockoutdates.length; iii++) { if( jQuery.inArray(d + "-" + (m+1) + "-" + y,lockoutdates) != -1 ) { return [false, "", "Booked"]; } } for (iii = 0; iii < globalHolidays.length; iii++) { if( jQuery.inArray(d + "-" + (m+1) + "-" + y,globalHolidays) != -1 ) { return [false, "", "Holiday"]; } } for (ii = 0; ii < holidayDates.length; ii++) { if( jQuery.inArray(d + "-" + (m+1) + "-" + y,holidayDates) != -1 ) { return [false, "", "Holiday"]; } } for (i = 0; i < bookedDates.length; i++) { //alert(bookedDates); if( jQuery.inArray(d + "-" + (m+1) + "-" + y,bookedDates) != -1 ) { return [false, "", "Unavailable for Booking"]; } } for (i = 0; i < deliveryDates.length; i++) { if( jQuery.inArray(d + "-" + (m+1) + "-" + y,deliveryDates) != -1 ) { return [true]; } } var day = "booking_weekday_" + date.getDay(); var name = day+"_"+' . $_POST['order_item_id'] . '; if (jQuery("#wapbk_admin_"+name).val() == "on") { return [true]; } return [false]; } function show_times(date,inst) { var monthValue = inst.selectedMonth+1; var dayValue = inst.selectedDay; var yearValue = inst.selectedYear; var current_dt = dayValue + "-" + monthValue + "-" + yearValue; var sold_individually = jQuery("#wapbk_sold_individually_' . $_POST['order_item_id'] . '").val(); jQuery("#wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '").val(current_dt); if (jQuery("#wapbk_admin_bookingEnableTime_' . $_POST['order_item_id'] . '").val() == "on" && jQuery("#wapbk_admin_booking_times_' . $_POST['order_item_id'] . '").val() != "") { //jQuery.datepicker.formatDate("d-m-yy", new Date(yearValue, dayValue, monthValue) ); var time_slots_arr = jQuery("#wapbk_admin_booking_times_' . $_POST['order_item_id'] . '").val(); var data = { current_date: current_dt, post_id: "' . $prod_id . '", action: "' . $method_to_show . '" }; jQuery.post("' . get_admin_url() . '/admin-ajax.php", data, function(response) { jQuery( "tr[data-meta_id=\\"' . $meta_id_next . '\\"]" ).show(); var select = jQuery("<select style=\\"width:100%;\\">"); select.append(jQuery("<option>").val("Choose a Time").html("Choose an option")); //alert(response); var time_slots = response.split("|"); for (var i = 0; i <= time_slots.length; ++i) { if(time_slots[i] != "" && time_slots[i] != null) select.append(jQuery("<option>").val(time_slots[i]).html(time_slots[i])); } //response; //alert(' . $meta_id_next . '); select.val(1).attr({name: "meta_value[' . $meta_id_next . ']"}).change(function(){ }); jQuery("input[name=\\"meta_value[' . $meta_id_next . ']\\"]").replaceWith(select); //alert("Got this from the server: " + response); jQuery( "#ajax_img" ).hide(); jQuery("#show_time_slot").html(response); jQuery("#time_slot").change(function() { if ( jQuery("#time_slot").val() != "" ) { jQuery( ".single_add_to_cart_button" ).show(); if(sold_individually == "yes") { jQuery( ".quantity" ).hide(); } else { jQuery( ".quantity" ).show(); } } else if ( jQuery("#time_slot").val() == "" ) { jQuery( ".single_add_to_cart_button" ).hide(); jQuery( ".quantity" ).hide(); } }) }); } else { if ( jQuery("#wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '").val() != "" ) { var data = { current_date: current_dt, post_id: "' . $prod_id . '", action: "insert_admin_date" }; jQuery.post("' . get_admin_url() . '/admin-ajax.php", data, function(response) { jQuery( ".single_add_to_cart_button" ).show(); if(sold_individually == "yes") { jQuery( ".quantity" ).hide(); } else { jQuery( ".quantity" ).show(); } }); } else if ( jQuery("#wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '").val() == "" ) { jQuery( ".single_add_to_cart_button" ).hide(); jQuery( ".quantity" ).hide(); } } } function set_checkin_date(date,inst) { var monthValue = inst.selectedMonth+1; var dayValue = inst.selectedDay; var yearValue = inst.selectedYear; var current_dt = dayValue + "-" + monthValue + "-" + yearValue; jQuery("#wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '").val(current_dt); // Check if any date in the selected date range is unavailable if (jQuery("#wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '").val() != "" ) { var CalculatePrice = "Y"; var split = jQuery("#wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '").val().split("-"); split[1] = split[1] - 1; var CheckinDate = new Date(split[2],split[1],split[0]); var split = jQuery("#wapbk_admin_hidden_date_checkout_' . $_POST['order_item_id'] . '").val().split("-"); split[1] = split[1] - 1; var CheckoutDate = new Date(split[2],split[1],split[0]); var date = new_end = new Date(CheckinDate); var m = date.getMonth(), d = date.getDate(), y = date.getFullYear(); var bookedDates = eval("["+jQuery("#wapbk_admin_hidden_booked_dates_' . $_POST['order_item_id'] . '").val()+"]"); var holidayDates = eval("["+jQuery("#wapbk_admin_booking_holidays_' . $_POST['order_item_id'] . '").val()+"]"); var globalHolidays = eval("["+jQuery("#wapbk_admin_booking_global_holidays_' . $_POST['order_item_id'] . '").val()+"]"); var count = gd(CheckinDate, CheckoutDate, "days"); //Locked Dates for (var i = 1; i<= count;i++) { if( jQuery.inArray(d + "-" + (m+1) + "-" + y,bookedDates) != -1 ) { jQuery("#wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '").val(""); jQuery("input[name=\\"meta_value[' . $meta_id . ']\\"]").val(""); jQuery( ".single_add_to_cart_button" ).hide(); jQuery( ".quantity" ).hide(); CalculatePrice = "N"; alert("Some of the dates in the selected range are unavailable. Please try another date range."); break; } new_end = new Date(ad(new_end,1)); var m = new_end.getMonth(), d = new_end.getDate(), y = new_end.getFullYear(); } //Global Holidays var date = new_end = new Date(CheckinDate); var m = date.getMonth(), d = date.getDate(), y = date.getFullYear(); for (var i = 1; i<= count;i++) { if( jQuery.inArray(d + "-" + (m+1) + "-" + y,globalHolidays) != -1 ) { jQuery("#wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '").val(""); jQuery("input[name=\\"meta_value[' . $meta_id . ']\\"]").val(""); CalculatePrice = "N"; alert("Some of the dates in the selected range are unavailable. Please try another date range."); break; } new_end = new Date(ad(new_end,1)); var m = new_end.getMonth(), d = new_end.getDate(), y = new_end.getFullYear(); } //Product Holidays var date = new_end = new Date(CheckinDate); var m = date.getMonth(), d = date.getDate(), y = date.getFullYear(); for (var i = 1; i<= count;i++) { if( jQuery.inArray(d + "-" + (m+1) + "-" + y,holidayDates) != -1 ) { jQuery("#wapbk_admin_hidden_date_' . $_POST['order_item_id'] . '").val(""); jQuery("input[name=\\"meta_value[' . $meta_id . ']\\"]").val(""); CalculatePrice = "N"; alert("Some of the dates in the selected range are unavailable. Please try another date range."); break; } new_end = new Date(ad(new_end,1)); var m = new_end.getMonth(), d = new_end.getDate(), y = new_end.getFullYear(); } ' . $js_block_date . ' //if (CalculatePrice == "Y") calculate_price(); } } function get_per_night_price(date,inst) { var monthValue = inst.selectedMonth+1; var dayValue = inst.selectedDay; var yearValue = inst.selectedYear; var current_dt = dayValue + "-" + monthValue + "-" + yearValue; jQuery("#wapbk_admin_hidden_date_checkout_' . $_POST['order_item_id'] . '").val(current_dt); } </script> '; //echo "CHECK<pre>";print_r($a);echo "</pre>"; //return $a;*/ } //print_r($meta_ids); } } else { echo '<tr data-meta_id="' . $meta_id . '"><td><input type="text" name="meta_key[' . $meta_id . ']" value="" /><textarea name="meta_key[' . $meta_id . ']" value="" /></td><td width="1%"><button class="remove_order_item_meta button">×</button></td></tr>'; } die; }
function woocommerce_etsyi_submenu_page_callback() { global $wpdb, $oscdb, $import_cat_counter, $import_prod_counter; if (!empty($_POST)) { $oscdb = new wpdb(trim($_POST['store_user']), trim($_POST['store_pass']), trim($_POST['store_dbname']), trim($_POST['store_host'])); if ($oscdb->ready) { echo '<p>Starting...<em>(If the page stops loading or shows a timeout error, then just refresh the page and the importer will continue where it left off. If you are using a shared server and are importing a lot of products you may need to refresh several times)</p>'; // Do customer import if ($_POST['dtype']['customers'] == 1) { $country_data = $oscdb->get_results("SELECT * FROM countries", ARRAY_A); $countries_id = array(); foreach ($country_data as $cdata) { $countries_id[$cdata['countries_id']] = $cdata; } $zones = array(); $zone_data = $oscdb->get_results("SELECT zone_id, zone_code FROM zones", ARRAY_A); foreach ($zone_data as $z) { $zones[$z['zone_id']] = $z['zone_code']; } if ($customers = $oscdb->get_results("SELECT c.customers_id, c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address, ab.entry_country_id, ab.entry_lastname, ab.entry_firstname, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_state, ab.entry_zone_id FROM customers c, address_book ab WHERE c.customers_id=ab.customers_id AND c.customers_default_address_id=ab.address_book_id", ARRAY_A)) { foreach ($customers as $customer) { if (!email_exists($customer['customers_email_address'])) { $original = strtolower(preg_replace("/[^A-Za-z0-9]/", '', $customer['customers_firstname'] . $customer['customers_lastname'])); $user_name = $original; $i = 1; while ($user_id = username_exists($user_name)) { $user_name = $original . $i; $i++; } $random_password = wp_generate_password(); $user_id = wp_create_user($user_name, $random_password, $customer['customers_email_address']); $data = array('first_name' => $customer['customers_firstname'], 'last_name' => $customer['customers_lastname'], 'billing_country' => $countries_id[$customer['entry_country_id']]['countries_iso_code_2'], 'billing_first_name' => $customer['entry_firstname'], 'billing_last_name' => $customer['entry_lastname'], 'billing_address_1' => $customer['entry_street_address'], 'billing_address_2' => $customer['entry_suburb'], 'billing_city' => $customer['entry_city'], 'billing_state' => $customer['entry_state'] != '' ? $customer['entry_state'] : $zones[$customer['entry_zone_id']], 'billing_postcode' => $customer['entry_postcode'], 'billing_email' => $customer['customers_email_address'], 'billing_phone' => $customer['customers_telephone'], 'shipping_country' => $countries_id[$customer['entry_country_id']]['countries_iso_code_2'], 'shipping_first_name' => $customer['entry_firstname'], 'shipping_last_name' => $customer['entry_lastname'], 'shipping_address_1' => $customer['entry_street_address'], 'shipping_address_2' => $customer['entry_suburb'], 'shipping_city' => $customer['entry_city'], 'shipping_state' => $customer['entry_state'] != '' ? $customer['entry_state'] : $zones[$customer['entry_zone_id']], 'shipping_postcode' => $customer['entry_postcode'], 'osc_id' => $customer['customers_id']); foreach ($data as $k => $v) { update_user_meta($user_id, $k, $v); } if ($user_id > 1) { wp_update_user(array('ID' => $user_id, 'role' => 'customer')); } $import_customer_counter++; } } } } if ($_POST['dtype']['products'] == 1) { woocommerce_osc_run_cats(); // Get all categories by OSC cat ID $categories = array(); $terms = get_terms('product_cat', array('hide_empty' => 0)); foreach ($terms as $term) { $o = get_woocommerce_term_meta($term->term_id, 'osc_id', true); $categories[$o] = (int) $term->term_id; } // Import the products if ($products = $oscdb->get_results("SELECT p.*, pd.*, p2c.categories_id FROM products p, products_description pd, products_to_categories p2c WHERE p.products_id=pd.products_id AND pd.language_id=1 AND p.products_id=p2c.products_id GROUP BY p.products_id", ARRAY_A)) { foreach ($products as $product) { $existing_product = get_posts(array('post_type' => 'product', 'posts_per_page' => 1, 'post_status' => 'any', 'meta_query' => array(array('key' => 'osc_id', 'value' => $product['products_id'])))); if (empty($existing_product)) { $product_id = wp_insert_post(array('post_title' => $product['products_name'], 'post_content' => $product['products_description'], 'post_status' => 'publish', 'post_type' => 'product', 'post_author' => 1)); update_post_meta($product_id, 'osc_id', $product['products_id']); wp_set_object_terms($product_id, 'simple', 'product_type'); wp_set_object_terms($product_id, (int) $categories[$product['categories_id']], 'product_cat'); update_post_meta($product_id, '_sku', $product['products_model']); update_post_meta($product_id, '_regular_price', $product['products_price']); update_post_meta($product_id, '_price', $product['products_price']); update_post_meta($product_id, '_visibility', 'visible'); update_post_meta($product_id, '_stock_status', $product['products_status'] ? 'instock' : 'outofstock'); update_post_meta($product_id, '_manage_stock', '1'); update_post_meta($product_id, '_stock', $product['products_quantity']); $import_prod_counter++; if ($special = $oscdb->get_row("SELECT specials_new_products_price, expires_date FROM specials WHERE status=1 AND products_id='" . $product_id . "' LIMIT 1", ARRAY_A)) { update_post_meta($product_id, '_sale_price', $special['specials_new_products_price']); $special['expires_date'] = strtotime($special['expires_date']); if ($special['expires_date'] > time()) { update_post_meta($product_id, '_sale_price_dates_to', date("Y-m-d", $special['expires_date'])); update_post_meta($product_id, '_sale_price_dates_from', date("Y-m-d")); } } $attach_id = 0; if ($product['products_image'] != '') { $url = rtrim($_POST['store_url'], '/') . '/images/' . urlencode($product['products_image']); $attach_id = woocommerce_osc_import_image($url); } if ($attach_id > 0) { set_post_thumbnail($product_id, $attach_id); } // Handle attributes if ($attributes = $oscdb->get_results("SELECT po.products_options_name, pov.products_options_values_name FROM products_attributes pa, products_options po, products_options_values pov WHERE pa.products_id='" . $product['products_id'] . "' AND pov.products_options_values_id = pa.options_values_id AND pov.language_id=po.language_id AND po.language_id=1 AND pa.options_id=products_options_id", ARRAY_A)) { wp_set_object_terms($product_id, 'variable', 'product_type'); $attrib_array = array(); $attrib_combo = array(); $max_price = $product['products_price']; $min_price = $product['products_price']; foreach ($attributes as $attribute) { $slug = sanitize_title($attribute['products_options_name']); $attrib_array[$slug] = array('name' => $attribute['products_options_name'], 'value' => ltrim($attrib_array[$slug]['value'] . ' | ' . $attribute['products_options_values_name'], ' | '), 'position' => 0, 'is_visible' => 1, 'is_variation' => 1, 'is_taxonomy' => 0); $attrib_combo[$slug][] = array($attribute['products_options_values_name'], ($attribute['price_prefix'] == '-' ? '-' : '') . $attribute['options_values_price']); } // Now it gets tricky... $combos = woocommerce_osc_cartesian_product($attrib_combo); foreach ($combos as $combo) { $variation_id = wp_insert_post(array('post_title' => 'Product ' . $product_id . ' Variation', 'post_content' => '', 'post_status' => 'publish', 'post_type' => 'product_variation', 'post_author' => 1, 'post_parent' => $product_id)); $opt_price = $product['products_price']; $special_price = $special['specials_new_products_price']; foreach ($combo as $k => $v) { update_post_meta($variation_id, 'attribute_' . $k, $v[0]); $opt_price += $v[1]; $special_price += $v[1]; } update_post_meta($variation_id, '_sku', $product['products_model']); update_post_meta($variation_id, '_regular_price', $opt_price); update_post_meta($variation_id, '_price', $opt_price); update_post_meta($variation_id, '_thumbnail_id', 0); update_post_meta($variation_id, '_stock', $product['products_quantity']); if ($special) { update_post_meta($variation_id, '_sale_price', $special_price); if ($special['expires_date'] > time()) { update_post_meta($variation_id, '_sale_price_dates_to', date("Y-m-d", $special['expires_date'])); update_post_meta($variation_id, '_sale_price_dates_from', date("Y-m-d")); } } if ($opt_price > $max_price) { $max_price = $opt_price; } if ($opt_price < $min_price) { $min_price = $opt_price; } } update_post_meta($product_id, '_product_attributes', $attrib_array); update_post_meta($product_id, '_max_variation_regular_price', $max_price); update_post_meta($product_id, '_min_variation_regular_price', $min_price); update_post_meta($product_id, '_max_variation_price', $max_price); update_post_meta($product_id, '_min_variation_price', $min_price); } } } } } if ($_POST['dtype']['orders'] == 1) { $customers = $wpdb->get_results("SELECT ID FROM {$wpdb->users}", ARRAY_A); $customer_id = array(); foreach ($customers as $c) { $osc_id = get_user_meta($c['ID'], 'osc_id', true); $customer_id[$osc_id] = $c['ID']; } $product_id = array(); $products_query = $wpdb->get_results("SELECT ID FROM {$wpdb->posts} WHERE post_type='product'", ARRAY_A); foreach ($products_query as $p) { $osc_id = get_post_meta($p['ID'], 'osc_id', true); $product_id[$osc_id] = $p['ID']; } $country_data = $oscdb->get_results("SELECT * FROM countries", ARRAY_A); $countries_name = array(); foreach ($country_data as $cdata) { $countries_name[$cdata['countries_name']] = $cdata; } if ($orders = $oscdb->get_results("SELECT * FROM orders ORDER BY orders_id", ARRAY_A)) { foreach ($orders as $order) { $existing_order = get_posts(array('post_type' => 'shop_order', 'posts_per_page' => 1, 'post_status' => 'any', 'meta_query' => array(array('key' => 'osc_id', 'value' => $order['orders_id'])))); if (empty($existing_order)) { $totals = array(); if ($total_query = $oscdb->get_results("SELECT * FROM orders_total WHERE orders_id='" . $order['orders_id'] . "'", ARRAY_A)) { foreach ($total_query as $t) { $totals[$t['class']] = $t; } } $order_key = 'order_' . wp_generate_password(13); $data = array('post_type' => 'shop_order', 'post_date' => $order['date_purchased'], 'post_author' => $customer_id[$order['customers_id']], 'post_password' => $order_key, 'post_title' => 'Order – ' . date("M d, Y @ h:i A", strtotime($order['date_purchased'])), 'post_status' => 'publish'); $order_id = wp_insert_post($data); $billing_namebits = explode(' ', $order['billing_name']); $billing_firstname = $billing_namebits[0]; $billing_lastname = trim(str_replace($billing_namebits[0], '', $order['billing_name'])); $shipping_namebits = explode(' ', $order['delivery_name']); $shipping_firstname = $shipping_namebits[0]; $shipping_lastname = trim(str_replace($shipping_namebits[0], '', $order['delivery_name'])); $meta_data = array('_billing_address_1' => $order['billing_street_address'], '_billing_address_2' => $order['billing_suburb'], '_wpas_done_all' => 1, '_billing_country' => $countries_name[$order['billing_country']]['countries_iso_code_2'], '_billing_first_name' => $billing_firstname, '_billing_last_name' => $billing_lastname, '_billing_company' => $order['billing_company'], '_billing_city' => $order['billing_city'], '_billing_state' => $order['billing_state'], '_billing_postcode' => $order['billing_postcode'], '_billing_phone' => $order['customers_telephone'], '_billing_email' => $order['customers_email_address'], '_shipping_country' => $countries_name[$order['delivery_country']]['countries_iso_code_2'], '_shipping_first_name' => $shipping_firstname, '_shipping_last_name' => $shipping_lastname, '_shipping_company' => $order['delivery_company'], '_shipping_address_1' => $order['delivery_street_address'], '_shipping_address_2' => $order['delivery_suburb'], '_shipping_city' => $order['delivery_city'], '_shipping_state' => $order['delivery_state'], '_shipping_postcode' => $order['delivery_postcode'], '_shipping_method_title' => $totals['ot_shipping']['title'], '_payment_method_title' => $order['payment_method'], '_order_shipping' => $totals['ot_shipping']['value'], '_order_discount' => $totals['ot_coupon']['value'] + $totals['ot_discount']['value'], '_order_tax' => $totals['ot_tax']['value'], '_order_shipping_tax' => 0, '_order_total' => $totals['ot_total']['value'], '_order_key' => $order_key, '_customer_user' => $customer_id[$order['customers_id']], '_order_currency' => $order['currency'], '_prices_include_tax' => 'no', 'osc_id' => $order['orders_id']); foreach ($meta_data as $k => $v) { update_post_meta($order_id, $k, $v); } $order_import_counter++; if ($order_products = $oscdb->get_results("SELECT * FROM orders_products WHERE orders_id='" . $order['orders_id'] . "'", ARRAY_A)) { foreach ($order_products as $product) { $item_id = woocommerce_add_order_item($order_id, array('order_item_name' => $product['products_name'], 'order_item_type' => 'line_item')); if ($item_id) { $item_meta = array('_qty' => $product['products_quantity'], '_product_id' => $product_id[$product['products_id']], '_line_subtotal' => $product['final_price'] * $product['products_quantity'], '_line_total' => $product['final_price'] * $product['products_quantity']); foreach ($item_meta as $k => $v) { woocommerce_add_order_item_meta($item_id, $k, $v); } } } } } } } } if ($_POST['dtype']['pages'] == 1) { $page_import_counter = 0; if ($information_table = $oscdb->get_results("SHOW TABLES LIKE 'information'", ARRAY_A)) { if ($information_pages = $oscdb->get_results("SELECT * FROM information WHERE language_id=1", ARRAY_A)) { foreach ($information_pages as $information) { $existing_page = $wpdb->get_results("SELECT ID FROM {$wpdb->posts} WHERE post_type='page' AND LOWER(post_title)='" . strtolower(esc_sql($information['information_title'])) . "'", ARRAY_A); if (!$existing_page) { $existing_page = get_posts(array('post_type' => 'page', 'posts_per_page' => 1, 'post_status' => 'any', 'meta_query' => array(array('key' => 'osc_id', 'value' => $information['information_id'])))); if (!$existing_page) { $data = array('post_type' => 'page', 'post_title' => $information['information_title'], 'post_content' => $information['information_description'], 'post_status' => 'publish'); $page_id = wp_insert_post($data); update_post_meta($page_id, 'osc_id', $information['information_id']); $page_import_counter++; } } } } } else { echo '<p class="notice">The information (pages) table does not exist in this osCommerce installation.</p>'; } } $success = true; } else { echo '<p class="notice">Could not connect to the osCommerce database</p>'; } } if ($success) { echo '<h3>The oscommerce data was successfully imported</h3>'; if ($_POST['dtype']['customers'] == 1) { echo '<p><strong>Customers Imported: ' . $import_customer_counter . '</p>'; } if ($_POST['dtype']['orders'] == 1) { echo '<p><strong>Orders Imported: ' . $order_import_counter . '</p>'; } if ($_POST['dtype']['products'] == 1) { echo '<p><strong>Categories Imported: ' . $import_cat_counter . '</p>'; echo '<p><strong>Products Imported: ' . $import_prod_counter . '</p>'; } if ($_POST['dtype']['pages'] == 1) { echo '<p><strong>Pages Imported: ' . $page_import_counter . '</p>'; } } else { ?> <form action="<?php echo $_SERVER['REQUEST_URI']; ?> " method="post"> <h3>Import data from osCommerce</h3> <p> Enter your oscommerce database information (you will need remote access to your oscommerce database) </p> <p> <label>osCommerce store URL: <input type="text" name="store_url" value="<?php echo $_POST['store_url']; ?> "></label> </p> <p> <label>osCommerce Database Host: <input type="text" name="store_host" value="localhost"></label></p> <p> <label>osCommerce Database User: <input type="text" name="store_user" value="<?php echo $_POST['store_user']; ?> "></label> </p> <p> <label>osCommerce Database Password: <input type="text" name="store_pass" value="<?php echo $_POST['store_pass']; ?> "></label> </p> <p> <label>osCommerce Database Name: <input type="text" name="store_dbname" value="<?php echo $_POST['store_dbname']; ?> "></label> </p> <p> Data to Import:<br> <label><input type="checkbox" name="dtype[customers]" value="1"> Customers (passwords will not be transferred)</label> <br> <label><input type="checkbox" name="dtype[orders]" value="1"> Orders</label> <br> <label><input type="checkbox" name="dtype[products]" value="1"> Categories/Products</label> <br> <label><input type="checkbox" name="dtype[pages]" value="1"> Information Pages</label> </p> <p> <input type="submit" value="Import Data" class="button button-primary button-large"> </p> </form> <?php } }
/** * Output the form */ public function output() { global $woocommerce; $this->errors = array(); $step = 1; try { if (!empty($_POST) && !check_admin_referer('create_booking_notification')) { throw new Exception(__('Error - please try again', 'woocommerce-bookings')); } if (!empty($_POST['create_booking'])) { $customer_id = absint($_POST['customer_id']); $bookable_product_id = absint($_POST['bookable_product_id']); $create_order = isset($_POST['create_order']) ? 1 : 0; if (!$bookable_product_id) { throw new Exception(__('Please choose a bookable product', 'woocommerce-bookings')); } $step++; $product = get_product($bookable_product_id); $booking_form = new WC_Booking_Form($product); } elseif (!empty($_POST['create_booking_2'])) { $customer_id = absint($_POST['customer_id']); $bookable_product_id = absint($_POST['bookable_product_id']); $create_order = absint($_POST['create_order']); $product = get_product($bookable_product_id); $booking_form = new WC_Booking_Form($product); $booking_data = $booking_form->get_posted_data($_POST); $booking_cost = number_format($booking_form->calculate_booking_cost($_POST), 2, '.', ''); // Data to go into the booking $new_booking_data = array('product_id' => $product->id, 'resource_id' => isset($booking_data['_resource_id']) ? $booking_data['_resource_id'] : '', 'persons' => $booking_data['_persons'], 'cost' => $booking_cost, 'start_date' => $booking_data['_start_date'], 'end_date' => $booking_data['_end_date'], 'all_day' => $booking_data['_all_day'] ? 1 : 0); // Create order if ($create_order) { $order_id = $this->create_order($booking_cost, $customer_id); if (!$order_id) { throw new Exception(__('Error: Could not create order', 'woocommerce-bookings')); } $item_id = woocommerce_add_order_item($order_id, array('order_item_name' => $product->get_title(), 'order_item_type' => 'line_item')); if (!$item_id) { throw new Exception(__('Error: Could not create item', 'woocommerce-bookings')); } // Add line item meta woocommerce_add_order_item_meta($item_id, '_qty', 1); woocommerce_add_order_item_meta($item_id, '_tax_class', $product->get_tax_class()); woocommerce_add_order_item_meta($item_id, '_product_id', $product->id); woocommerce_add_order_item_meta($item_id, '_variation_id', ''); woocommerce_add_order_item_meta($item_id, '_line_subtotal', $booking_cost); woocommerce_add_order_item_meta($item_id, '_line_total', $booking_cost); woocommerce_add_order_item_meta($item_id, '_line_tax', 0); woocommerce_add_order_item_meta($item_id, '_line_subtotal_tax', 0); // We have an item id $new_booking_data['order_item_id'] = $item_id; // Add line item data foreach ($booking_data as $key => $value) { if (strpos($key, '_') !== 0) { woocommerce_add_order_item_meta($item_id, get_wc_booking_data_label($key, $product), $value); } } } // Create the booking itself $new_booking = get_wc_booking($new_booking_data); $new_booking->create($create_order ? 'unpaid' : 'pending'); wp_safe_redirect(admin_url('post.php?post=' . ($create_order ? $order_id : $new_booking->id) . '&action=edit')); exit; } } catch (Exception $e) { $this->errors[] = $e->getMessage(); } switch ($step) { case 1: include 'views/html-create-booking-page.php'; break; case 2: include 'views/html-create-booking-page-2.php'; break; } }
function tshirt_designer_add_order_item_meta($item_id, $cart_item) { //order completed page. & admin if (!empty($cart_item['tshirt_designer_front_img']) || !empty($cart_item['tshirt_designer_back_img'])) { woocommerce_add_order_item_meta($item_id, 'tshirt_designer_front_img', $cart_item['tshirt_designer_front_img']); woocommerce_add_order_item_meta($item_id, 'tshirt_designer_back_img', $cart_item['tshirt_designer_back_img']); } }
function add_order_item_meta($item_id, $values) { if ($values['sample']) { woocommerce_add_order_item_meta($item_id, 'product type', 'sample'); } }
/** * Update recurring line taxes via AJAX * @see WC_Subscriptions_Order::calculate_recurring_line_taxes() * * @since 4.4 * @return JSON object with updated tax data */ public static function ajax_update_recurring_tax() { global $wpdb; $woo_22_plus = version_compare(WOOCOMMERCE_VERSION, '2.2', '>='); check_ajax_referer('woocommerce-subscriptions', 'security'); $order_id = absint($_POST['order_id']); $country = strtoupper(esc_attr($_POST['country'])); // Step out of the way if the customer is not located in the US if ($country != 'US') { return; } $shipping = $_POST['shipping']; $line_subtotal = isset($_POST['line_subtotal']) ? esc_attr($_POST['line_subtotal']) : 0; $line_total = isset($_POST['line_total']) ? esc_attr($_POST['line_total']) : 0; // Set up WC_WooTax_Order object $order = self::get_order($order_id); // We only need to instantiate a WC_Tax object if we are using WooCommerce < 2.3 if (!$woo_22_plus) { $tax = new WC_Tax(); } $taxes = $shipping_taxes = array(); $return = array(); $item_data = array(); $type_array = array(); $product_id = ''; if (isset($_POST['order_item_id'])) { $product_id = woocommerce_get_order_item_meta($_POST['order_item_id'], '_product_id'); } elseif (isset($_POST['product_id'])) { $product_id = esc_attr($_POST['product_id']); } if (!empty($product_id) && WC_Subscriptions_Product::is_subscription($product_id)) { // Get product details $product = WC_Subscriptions::get_product($product_id); // Add product to items array $tic = get_post_meta($product->id, 'wootax_tic', true); $item_info = array('Index' => '', 'ItemID' => isset($_POST['order_item_id']) ? $_POST['order_item_id'] : $product_id, 'Qty' => 1, 'Price' => $line_subtotal > 0 ? $line_subtotal : $product->get_price(), 'Type' => 'cart'); if (!empty($tic) && $tic) { $item_info['TIC'] = $tic; } $item_data[] = $item_info; $type_array[$_POST['order_item_id']] = 'cart'; // Add shipping to items array if ($shipping > 0) { $item_data[] = array('Index' => '', 'ItemID' => WT_SHIPPING_ITEM, 'TIC' => WT_SHIPPING_TIC, 'Qty' => 1, 'Price' => $shipping, 'Type' => 'shipping'); $type_array[WT_SHIPPING_ITEM] = 'shipping'; } // Issue Lookup request $res = $order->do_lookup($item_data, $type_array, true); if (is_array($res)) { $return['recurring_shipping_tax'] = 0; $return['recurring_line_subtotal_tax'] = 0; $return['recurring_line_tax'] = 0; foreach ($res as $item) { $item_id = $item->ItemID; $item_tax = $item->TaxAmount; if ($item_id == WT_SHIPPING_ITEM) { $return['recurring_shipping_tax'] += $item_tax; } else { $return['recurring_line_subtotal_tax'] += $item_tax; $return['recurring_line_tax'] += $item_tax; } } $taxes[WT_RATE_ID] = $return['recurring_line_tax']; $shipping_taxes[WT_RATE_ID] = $return['recurring_shipping_tax']; // Get tax rates $tax_codes = array(WT_RATE_ID => apply_filters('wootax_rate_code', 'WOOTAX-RATE-DO-NOT-REMOVE')); // Remove old tax rows $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}woocommerce_order_itemmeta WHERE order_item_id IN ( SELECT order_item_id FROM {$wpdb->prefix}woocommerce_order_items WHERE order_id = %d AND order_item_type = 'recurring_tax' )", $order_id)); $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}woocommerce_order_items WHERE order_id = %d AND order_item_type = 'recurring_tax'", $order_id)); // Now merge to keep tax rows ob_start(); foreach (array_keys($taxes + $shipping_taxes) as $key) { $item = array(); $item['rate_id'] = $key; $item['name'] = $tax_codes[$key]; $item['label'] = $woo_22_plus ? WC_Tax::get_rate_label($key) : $tax->get_rate_label($key); $item['compound'] = $woo_22_plus ? WC_Tax::is_compound($key) : $tax->is_compound($key) ? 1 : 0; $item['tax_amount'] = wc_round_tax_total(isset($taxes[$key]) ? $taxes[$key] : 0); $item['shipping_tax_amount'] = wc_round_tax_total(isset($shipping_taxes[$key]) ? $shipping_taxes[$key] : 0); if (!$item['label']) { $item['label'] = WC()->countries->tax_or_vat(); } // Add line item $item_id = woocommerce_add_order_item($order_id, array('order_item_name' => $item['name'], 'order_item_type' => 'recurring_tax')); // Add line item meta if ($item_id) { woocommerce_add_order_item_meta($item_id, 'rate_id', $item['rate_id']); woocommerce_add_order_item_meta($item_id, 'label', $item['label']); woocommerce_add_order_item_meta($item_id, 'compound', $item['compound']); woocommerce_add_order_item_meta($item_id, 'tax_amount', $item['tax_amount']); woocommerce_add_order_item_meta($item_id, 'shipping_tax_amount', $item['shipping_tax_amount']); } include plugin_dir_path(WC_Subscriptions::$plugin_file) . 'templates/admin/post-types/writepanels/order-tax-html.php'; } $return['tax_row_html'] = ob_get_clean(); echo json_encode($return); } } die; }
/** * order_item_meta function. * * @param mixed $item_id * @param mixed $values */ public function order_item_meta($item_id, $values) { if (!empty($values['food'])) { $product = $values['data']; // Add summary of details to line item foreach ($values['food'] as $key => $value) { if (strpos($key, '_') !== 0) { if (is_array($value)) { foreach ($value as $data) { woocommerce_add_order_item_meta($item_id, get_takeaway_food_data_label($key, $product), $data); } } else { woocommerce_add_order_item_meta($item_id, get_takeaway_food_data_label($key, $product), $value); } } } } }
function wdm_add_values_to_order_item_meta($item_id, $values) { global $woocommerce, $wpdb; $user_custom_values = $values['wdm_user_custom_data_value']; $pdf_processing_status = 0; $pdf_processing_description = 'Waiting for execution of cron-job'; if (!empty($user_custom_values)) { woocommerce_add_order_item_meta($item_id, 'wdm_user_custom_data', $user_custom_values); woocommerce_add_order_item_meta($item_id, 'pdf_processing_status', $pdf_processing_status); woocommerce_add_order_item_meta($item_id, 'pdf_processing_description', $pdf_processing_description); } }
/** * Version 1.2 introduced a massive change to the order meta data schema. This function goes * through and upgrades the existing data on all orders to the new schema. * * The upgrade process is timeout safe as it keeps a record of the orders upgraded and only * deletes this record once all orders have been upgraded successfully. If operating on a huge * number of orders and the upgrade process times out, only the orders not already upgraded * will be upgraded in future requests that trigger this function. * * @since 1.2 */ private static function upgrade_database_to_1_2() { global $wpdb; set_transient('wc_subscriptions_is_upgrading', 'true', 60 * 2); // Get IDs only and use a direct DB query for efficiency $orders_to_upgrade = $wpdb->get_col("SELECT ID FROM {$wpdb->posts} WHERE post_type = 'shop_order' AND post_parent = 0"); $upgraded_orders = get_option('wcs_1_2_upgraded_order_ids', array()); // Transition deprecated subscription status if we aren't in the middle of updating orders if (empty($upgraded_orders)) { $wpdb->query($wpdb->prepare("UPDATE {$wpdb->usermeta} SET meta_value = replace( meta_value, 's:9:\"suspended\"', 's:7:\"on-hold\"' ) WHERE meta_key LIKE %s", '%_' . WC_Subscriptions_Manager::$users_meta_key)); $wpdb->query($wpdb->prepare("UPDATE {$wpdb->usermeta} SET meta_value = replace( meta_value, 's:6:\"failed\"', 's:9:\"cancelled\"' ) WHERE meta_key LIKE %s", '%_' . WC_Subscriptions_Manager::$users_meta_key)); } $orders_to_upgrade = array_diff($orders_to_upgrade, $upgraded_orders); // Upgrade all _sign_up_{field} order meta to new order data format foreach ($orders_to_upgrade as $order_id) { $order = new WC_Order($order_id); // Manually check if a product in an order is a subscription, we can't use WC_Subscriptions_Order::order_contains_subscription( $order ) because it relies on the new data structure $contains_subscription = false; foreach ($order->get_items() as $order_item) { if (WC_Subscriptions_Product::is_subscription(WC_Subscriptions_Order::get_items_product_id($order_item))) { $contains_subscription = true; break; } } if (!$contains_subscription) { continue; } $trial_lengths = WC_Subscriptions_Order::get_meta($order, '_order_subscription_trial_lengths', array()); $trial_length = array_pop($trial_lengths); $has_trial = !empty($trial_length) && $trial_length > 0 ? true : false; $sign_up_fee_total = WC_Subscriptions_Order::get_meta($order, '_sign_up_fee_total', 0); // Create recurring_* meta data from existing cart totals $cart_discount = $order->get_cart_discount(); update_post_meta($order_id, '_order_recurring_discount_cart', $cart_discount); $order_discount = $order->get_order_discount(); update_post_meta($order_id, '_order_recurring_discount_total', $order_discount); $order_shipping_tax = get_post_meta($order_id, '_order_shipping_tax', true); update_post_meta($order_id, '_order_recurring_shipping_tax_total', $order_shipping_tax); $order_tax = get_post_meta($order_id, '_order_tax', true); // $order->get_total_tax() includes shipping tax update_post_meta($order_id, '_order_recurring_tax_total', $order_tax); $order_total = $order->get_total(); update_post_meta($order_id, '_order_recurring_total', $order_total); // Set order totals to include sign up fee fields, if there was a sign up fee on the order and a trial period (other wise, the recurring totals are correct) if ($sign_up_fee_total > 0) { // Order totals need to be changed to be equal to sign up fee totals if ($has_trial) { $cart_discount = WC_Subscriptions_Order::get_meta($order, '_sign_up_fee_discount_cart', 0); $order_discount = WC_Subscriptions_Order::get_meta($order, '_sign_up_fee_discount_total', 0); $order_tax = WC_Subscriptions_Order::get_meta($order, '_sign_up_fee_tax_total', 0); $order_total = $sign_up_fee_total; } else { // No trial, sign up fees need to be added to order totals $cart_discount += WC_Subscriptions_Order::get_meta($order, '_sign_up_fee_discount_cart', 0); $order_discount += WC_Subscriptions_Order::get_meta($order, '_sign_up_fee_discount_total', 0); $order_tax += WC_Subscriptions_Order::get_meta($order, '_sign_up_fee_tax_total', 0); $order_total += $sign_up_fee_total; } update_post_meta($order_id, '_order_total', $order_total); update_post_meta($order_id, '_cart_discount', $cart_discount); update_post_meta($order_id, '_order_discount', $order_discount); update_post_meta($order_id, '_order_tax', $order_tax); } // Make sure we get order taxes in WC 1.x format if (false == self::$is_wc_version_2) { $order_taxes = $order->get_taxes(); } else { $order_tax_row = $wpdb->get_row($wpdb->prepare("\n\t\t\t\t\tSELECT * FROM {$wpdb->postmeta}\n\t\t\t\t\tWHERE meta_key = '_order_taxes_old'\n\t\t\t\t\tAND post_id = %s\n\t\t\t\t\t", $order_id)); $order_taxes = (array) maybe_unserialize($order_tax_row->meta_value); } // Set recurring taxes to order taxes, if using WC 2.0, this will be migrated to the new format in @see self::upgrade_to_latest_wc() update_post_meta($order_id, '_order_recurring_taxes', $order_taxes); $sign_up_fee_taxes = WC_Subscriptions_Order::get_meta($order, '_sign_up_fee_taxes', array()); // Update order taxes to include sign up fee taxes foreach ($sign_up_fee_taxes as $index => $sign_up_tax) { if ($has_trial && $sign_up_fee_total > 0) { // Order taxes need to be set to the same as the sign up fee taxes if (isset($sign_up_tax['cart_tax']) && $sign_up_tax['cart_tax'] > 0) { $order_taxes[$index]['cart_tax'] = $sign_up_tax['cart_tax']; } } elseif (!$has_trial && $sign_up_fee_total > 0) { // Sign up fee taxes need to be added to order taxes if (isset($sign_up_tax['cart_tax']) && $sign_up_tax['cart_tax'] > 0) { $order_taxes[$index]['cart_tax'] += $sign_up_tax['cart_tax']; } } } if (false == self::$is_wc_version_2) { // Doing it right: updated Subs *before* updating WooCommerce, the WooCommerce updater will take care of data migration update_post_meta($order_id, '_order_taxes', $order_taxes); } else { // Doing it wrong: updated Subs *after* updating WooCommerce, need to store in WC2.0 tax structure $index = 0; $new_order_taxes = $order->get_taxes(); foreach ($new_order_taxes as $item_id => $order_tax) { $index = $index + 1; if (!isset($order_taxes[$index]['label']) || !isset($order_taxes[$index]['cart_tax']) || !isset($order_taxes[$index]['shipping_tax'])) { continue; } // Add line item meta if ($item_id) { woocommerce_update_order_item_meta($item_id, 'compound', absint(isset($order_taxes[$index]['compound']) ? $order_taxes[$index]['compound'] : 0)); woocommerce_update_order_item_meta($item_id, 'tax_amount', woocommerce_clean($order_taxes[$index]['cart_tax'])); woocommerce_update_order_item_meta($item_id, 'shipping_tax_amount', woocommerce_clean($order_taxes[$index]['shipping_tax'])); } } } /* Upgrade each order item to use new Item Meta schema */ $order_subscription_periods = WC_Subscriptions_Order::get_meta($order_id, '_order_subscription_periods', array()); $order_subscription_intervals = WC_Subscriptions_Order::get_meta($order_id, '_order_subscription_intervals', array()); $order_subscription_lengths = WC_Subscriptions_Order::get_meta($order_id, '_order_subscription_lengths', array()); $order_subscription_trial_lengths = WC_Subscriptions_Order::get_meta($order_id, '_order_subscription_trial_lengths', array()); $order_items = $order->get_items(); foreach ($order_items as $index => $order_item) { $product_id = WC_Subscriptions_Order::get_items_product_id($order_item); $item_meta = new WC_Order_Item_Meta($order_item['item_meta']); $subscription_interval = isset($order_subscription_intervals[$product_id]) ? $order_subscription_intervals[$product_id] : 1; $subscription_length = isset($order_subscription_lengths[$product_id]) ? $order_subscription_lengths[$product_id] : 0; $subscription_trial_length = isset($order_subscription_trial_lengths[$product_id]) ? $order_subscription_trial_lengths[$product_id] : 0; $subscription_sign_up_fee = WC_Subscriptions_Order::get_meta($order, '_cart_contents_sign_up_fee_total', 0); if ($sign_up_fee_total > 0) { // Discounted price * Quantity $sign_up_fee_line_total = WC_Subscriptions_Order::get_meta($order, '_cart_contents_sign_up_fee_total', 0); $sign_up_fee_line_tax = WC_Subscriptions_Order::get_meta($order, '_sign_up_fee_tax_total', 0); // Base price * Quantity $sign_up_fee_line_subtotal = WC_Subscriptions_Order::get_meta($order, '_cart_contents_sign_up_fee_total', 0) + WC_Subscriptions_Order::get_meta($order, '_sign_up_fee_discount_cart', 0); $sign_up_fee_propotion = $sign_up_fee_line_total > 0 ? $sign_up_fee_line_subtotal / $sign_up_fee_line_total : 0; $sign_up_fee_line_subtotal_tax = WC_Subscriptions_Manager::get_amount_from_proportion(WC_Subscriptions_Order::get_meta($order, '_sign_up_fee_tax_total', 0), $sign_up_fee_propotion); if ($has_trial) { // Set line item totals equal to sign up fee totals $order_item['line_subtotal'] = $sign_up_fee_line_subtotal; $order_item['line_subtotal_tax'] = $sign_up_fee_line_subtotal_tax; $order_item['line_total'] = $sign_up_fee_line_total; $order_item['line_tax'] = $sign_up_fee_line_tax; } else { // No trial period, sign up fees need to be added to order totals $order_item['line_subtotal'] += $sign_up_fee_line_subtotal; $order_item['line_subtotal_tax'] += $sign_up_fee_line_subtotal_tax; $order_item['line_total'] += $sign_up_fee_line_total; $order_item['line_tax'] += $sign_up_fee_line_tax; } } // Upgrading with WC 1.x if (method_exists($item_meta, 'add')) { $item_meta->add('_subscription_period', $order_subscription_periods[$product_id]); $item_meta->add('_subscription_interval', $subscription_interval); $item_meta->add('_subscription_length', $subscription_length); $item_meta->add('_subscription_trial_length', $subscription_trial_length); $item_meta->add('_subscription_recurring_amount', $order_item['line_subtotal']); // WC_Subscriptions_Product::get_price() would return a price without filters applied $item_meta->add('_subscription_sign_up_fee', $subscription_sign_up_fee); // Set recurring amounts for the item $item_meta->add('_recurring_line_total', $order_item['line_total']); $item_meta->add('_recurring_line_tax', $order_item['line_tax']); $item_meta->add('_recurring_line_subtotal', $order_item['line_subtotal']); $item_meta->add('_recurring_line_subtotal_tax', $order_item['line_subtotal_tax']); $order_item['item_meta'] = $item_meta->meta; $order_items[$index] = $order_item; } else { // Ignoring all advice, upgrading 4 months after version 1.2 was released, and doing it with WC 2.0 installed woocommerce_add_order_item_meta($index, '_subscription_period', $order_subscription_periods[$product_id]); woocommerce_add_order_item_meta($index, '_subscription_interval', $subscription_interval); woocommerce_add_order_item_meta($index, '_subscription_length', $subscription_length); woocommerce_add_order_item_meta($index, '_subscription_trial_length', $subscription_trial_length); woocommerce_add_order_item_meta($index, '_subscription_trial_period', $order_subscription_periods[$product_id]); woocommerce_add_order_item_meta($index, '_subscription_recurring_amount', $order_item['line_subtotal']); woocommerce_add_order_item_meta($index, '_subscription_sign_up_fee', $subscription_sign_up_fee); // Calculated recurring amounts for the item woocommerce_add_order_item_meta($index, '_recurring_line_total', $order_item['line_total']); woocommerce_add_order_item_meta($index, '_recurring_line_tax', $order_item['line_tax']); woocommerce_add_order_item_meta($index, '_recurring_line_subtotal', $order_item['line_subtotal']); woocommerce_add_order_item_meta($index, '_recurring_line_subtotal_tax', $order_item['line_subtotal_tax']); if ($sign_up_fee_total > 0) { // Order totals have changed woocommerce_update_order_item_meta($index, '_line_subtotal', woocommerce_format_decimal($order_item['line_subtotal'])); woocommerce_update_order_item_meta($index, '_line_subtotal_tax', woocommerce_format_decimal($order_item['line_subtotal_tax'])); woocommerce_update_order_item_meta($index, '_line_total', woocommerce_format_decimal($order_item['line_total'])); woocommerce_update_order_item_meta($index, '_line_tax', woocommerce_format_decimal($order_item['line_tax'])); } } } // Save the new meta on the order items for WC 1.x (the API functions already saved the data for WC2.x) if (false == self::$is_wc_version_2) { update_post_meta($order_id, '_order_items', $order_items); } $upgraded_orders[] = $order_id; update_option('wcs_1_2_upgraded_order_ids', $upgraded_orders); } // Remove the lock on upgrading delete_transient('wc_subscriptions_is_upgrading'); }
/** * Creates a new order for renewing a subscription product based on the details of a previous order. * * No trial periods or sign up fees are applied to the renewal order. However, if the order has failed * payments and the store manager has set failed payments to be added to renewal orders, then the * orders totals will be set to include the outstanding balance. * * If the $args['new_order_role'] flag is set to 'parent', then the renewal order will supersede the existing * order. The existing order and subscription associated with it will be cancelled. A new order and * subscription will be created. * * If the $args['new_order_role'] flag is 'child', the $original_order will remain the master order for the * subscription and the new order is just for accepting a recurring payment on the subscription. * * Renewal orders have the same meta data as the original order. If the renewal order is set to be a 'child' * then any subscription related meta data will not be stored on the new order. This is to keep subscription * meta data associated only with the one master order for the subscription. * * @param WC_Order|int $order The WC_Order object or ID of the order for which the a new order should be created. * @param string $product_id The ID of the subscription product in the order which needs to be added to the new order. * @param array $args (optional) An array of name => value flags: * 'new_order_role' string A flag to indicate whether the new order should become the master order for the subscription. Accepts either 'parent' or 'child'. Defaults to 'parent' - replace the existing order. * 'checkout_renewal' bool Indicates if invoked from an interactive cart/checkout session. Default false. * 'failed_order_id' int For checkout_renewal true, indicates order id being replaced * @since 1.2 */ public static function generate_renewal_order($original_order, $product_id, $args = array()) { global $wpdb, $woocommerce; if (!is_object($original_order)) { $original_order = new WC_Order($original_order); } if (!WC_Subscriptions_Order::order_contains_subscription($original_order) || !WC_Subscriptions_Order::is_item_subscription($original_order, $product_id)) { return false; } if (self::is_renewal($original_order, array('order_role' => 'child'))) { $original_order = self::get_parent_order($original_order); } if (!is_array($args)) { _deprecated_argument(__CLASS__ . '::' . __FUNCTION__, '1.3', __('Third parameter is now an array of name => value pairs. Use array( "new_order_role" => "parent" ) instead.', WC_Subscriptions::$text_domain)); $args = array('new_order_role' => $args); } $args = wp_parse_args($args, array('new_order_role' => 'parent', 'checkout_renewal' => false)); $renewal_order_key = uniqid('order_'); // Create the new order $renewal_order_data = array('post_type' => 'shop_order', 'post_title' => sprintf(__('Subscription Renewal Order – %s', WC_Subscriptions::$text_domain), strftime(_x('%b %d, %Y @ %I:%M %p', 'Order date parsed by strftime', WC_Subscriptions::$text_domain))), 'post_status' => 'publish', 'ping_status' => 'closed', 'post_excerpt' => $original_order->customer_note, 'post_author' => 1, 'post_password' => $renewal_order_key); $create_new_order = true; if ('child' == $args['new_order_role']) { $renewal_order_data['post_parent'] = $original_order->id; } if (true === $args['checkout_renewal']) { $renewal_order_id = null; if ($woocommerce->session->order_awaiting_payment > 0) { $renewal_order_id = absint($woocommerce->session->order_awaiting_payment); } elseif (isset($args['failed_order_id'])) { $failed_order_id = $args['failed_order_id']; /* Check order is unpaid by getting its status */ $terms = wp_get_object_terms($failed_order_id, 'shop_order_status', array('fields' => 'slugs')); $order_status = isset($terms[0]) ? $terms[0] : 'pending'; /* If paying on a pending order, we are resuming */ if ($order_status == 'pending') { $renewal_order_id = $failed_order_id; } } if ($renewal_order_id) { /* Check order is unpaid by getting its status */ $terms = wp_get_object_terms($renewal_order_id, 'shop_order_status', array('fields' => 'slugs')); $order_status = isset($terms[0]) ? $terms[0] : 'pending'; // Resume the unpaid order if its pending if ($order_status == 'pending' || $order_status == 'failed') { // Update the existing order as we are resuming it $create_new_order = false; $renewal_order_data['ID'] = $renewal_order_id; wp_update_post($renewal_order_data); // Clear the old line items - we'll add these again in case they changed $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}woocommerce_order_itemmeta WHERE order_item_id IN ( SELECT order_item_id FROM {$wpdb->prefix}woocommerce_order_items WHERE order_id = %d )", $renewal_order_id)); $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}woocommerce_order_items WHERE order_id = %d", $renewal_order_id)); } } } if ($create_new_order) { $renewal_order_id = wp_insert_post($renewal_order_data); } // Set the order as pending wp_set_object_terms($renewal_order_id, 'pending', 'shop_order_status'); // Set a unique key for this order update_post_meta($renewal_order_id, '_order_key', $renewal_order_key); if (true === $args['checkout_renewal']) { $checkout_object = $woocommerce->checkout; $customer_id = $original_order->customer_user; // Save posted billing fields to both renewal and original order if ($checkout_object->checkout_fields['billing']) { foreach ($checkout_object->checkout_fields['billing'] as $key => $field) { update_post_meta($renewal_order_id, '_' . $key, $checkout_object->posted[$key]); update_post_meta($original_order->id, '_' . $key, $checkout_object->posted[$key]); // User if ($customer_id && !empty($checkout_object->posted[$key])) { update_user_meta($customer_id, $key, $checkout_object->posted[$key]); // Special fields switch ($key) { case "billing_email": if (!email_exists($checkout_object->posted[$key])) { wp_update_user(array('ID' => $customer_id, 'user_email' => $checkout_object->posted[$key])); } break; case "billing_first_name": wp_update_user(array('ID' => $customer_id, 'first_name' => $checkout_object->posted[$key])); break; case "billing_last_name": wp_update_user(array('ID' => $customer_id, 'last_name' => $checkout_object->posted[$key])); break; } } } } // Save posted shipping fields to both renewal and original order if ($checkout_object->checkout_fields['shipping'] && ($woocommerce->cart->needs_shipping() || get_option('woocommerce_require_shipping_address') == 'yes')) { foreach ($checkout_object->checkout_fields['shipping'] as $key => $field) { $postvalue = false; if ($checkout_object->posted['shiptobilling']) { if (isset($checkout_object->posted[str_replace('shipping_', 'billing_', $key)])) { $postvalue = $checkout_object->posted[str_replace('shipping_', 'billing_', $key)]; update_post_meta($renewal_order_id, '_' . $key, $postvalue); update_post_meta($original_order->id, '_' . $key, $postvalue); } } else { $postvalue = $checkout_object->posted[$key]; update_post_meta($renewal_order_id, '_' . $key, $postvalue); update_post_meta($original_order->id, '_' . $key, $postvalue); } // User if ($postvalue && $customer_id) { update_user_meta($customer_id, $key, $postvalue); } } } } $order_meta_query = "SELECT `meta_key`, `meta_value`\n\t\t\t\t\t\t\t FROM {$wpdb->postmeta}\n\t\t\t\t\t\t\t WHERE `post_id` = {$original_order->id}\n\t\t\t\t\t\t\t AND `meta_key` NOT IN ('_paid_date', '_completed_date', '_order_key', '_edit_lock', '_original_order')"; // Superseding existing order so don't carry over payment details if ('parent' == $args['new_order_role'] || true === $args['checkout_renewal']) { $order_meta_query .= " AND `meta_key` NOT IN ('_payment_method', '_payment_method_title', '_recurring_payment_method', '_recurring_payment_method_title', '_shipping_method', '_shipping_method_title', '_recurring_shipping_method', '_recurring_shipping_method_title')"; } else { $order_meta_query .= " AND `meta_key` NOT LIKE '_order_recurring_%' AND `meta_key` NOT IN ('_payment_method', '_payment_method_title', '_recurring_payment_method', '_recurring_payment_method_title', '_shipping_method', '_shipping_method_title', '_recurring_shipping_method', '_recurring_shipping_method_title')"; } // Allow extensions to add/remove order meta $order_meta_query = apply_filters('woocommerce_subscriptions_renewal_order_meta_query', $order_meta_query, $original_order->id, $renewal_order_id, $args['new_order_role']); // Carry all the required meta from the old order over to the new order $order_meta = $wpdb->get_results($order_meta_query, 'ARRAY_A'); $order_meta = apply_filters('woocommerce_subscriptions_renewal_order_meta', $order_meta, $original_order->id, $renewal_order_id, $args['new_order_role']); foreach ($order_meta as $meta_item) { add_post_meta($renewal_order_id, $meta_item['meta_key'], maybe_unserialize($meta_item['meta_value']), true); } $outstanding_balance = WC_Subscriptions_Order::get_outstanding_balance($original_order, $product_id); if (true === $args['checkout_renewal']) { $failed_payment_multiplier = 1; update_post_meta($renewal_order_id, '_order_shipping', woocommerce_format_total($woocommerce->cart->shipping_total)); update_post_meta($renewal_order_id, '_order_discount', woocommerce_format_total($woocommerce->cart->get_order_discount_total())); update_post_meta($renewal_order_id, '_cart_discount', woocommerce_format_total($woocommerce->cart->get_cart_discount_total())); update_post_meta($renewal_order_id, '_order_tax', woocommerce_format_total($woocommerce->cart->tax_total)); update_post_meta($renewal_order_id, '_order_shipping_tax', woocommerce_format_total($woocommerce->cart->shipping_tax_total)); update_post_meta($renewal_order_id, '_order_total', woocommerce_format_total($woocommerce->cart->total)); update_post_meta($renewal_order_id, '_checkout_renewal', 'yes'); } else { // If there are outstanding payment amounts, add them to the order, otherwise set the order details to the values of the recurring totals if ($outstanding_balance > 0 && 'yes' == get_option(WC_Subscriptions_Admin::$option_prefix . '_add_outstanding_balance', 'no')) { $failed_payment_multiplier = WC_Subscriptions_Order::get_failed_payment_count($original_order, $product_id); } else { $failed_payment_multiplier = 1; } // Set order totals based on recurring totals from the original order $cart_discount = $failed_payment_multiplier * get_post_meta($original_order->id, '_order_recurring_discount_cart', true); $order_discount = $failed_payment_multiplier * get_post_meta($original_order->id, '_order_recurring_discount_total', true); $order_shipping_tax = $failed_payment_multiplier * get_post_meta($original_order->id, '_order_recurring_shipping_tax_total', true); $order_shipping = $failed_payment_multiplier * get_post_meta($original_order->id, '_order_recurring_shipping_total', true); $order_tax = $failed_payment_multiplier * get_post_meta($original_order->id, '_order_recurring_tax_total', true); $order_total = $failed_payment_multiplier * get_post_meta($original_order->id, '_order_recurring_total', true); update_post_meta($renewal_order_id, '_cart_discount', $cart_discount); update_post_meta($renewal_order_id, '_order_discount', $order_discount); update_post_meta($renewal_order_id, '_order_shipping_tax', $order_shipping_tax); update_post_meta($renewal_order_id, '_order_shipping', $order_shipping); update_post_meta($renewal_order_id, '_order_tax', $order_tax); update_post_meta($renewal_order_id, '_order_total', $order_total); update_post_meta($renewal_order_id, '_shipping_method', $original_order->recurring_shipping_method); update_post_meta($renewal_order_id, '_shipping_method_title', $original_order->recurring_shipping_method_title); // Apply the recurring shipping & payment methods to child renewal orders if ('child' == $args['new_order_role']) { update_post_meta($renewal_order_id, '_payment_method', $original_order->recurring_payment_method); update_post_meta($renewal_order_id, '_payment_method_title', $original_order->recurring_payment_method_title); } } // Set order taxes based on recurring taxes from the original order $recurring_order_taxes = WC_Subscriptions_Order::get_recurring_taxes($original_order); foreach ($recurring_order_taxes as $index => $recurring_order_tax) { if (function_exists('woocommerce_update_order_item_meta')) { // WC 2.0+ $item_ids = array(); $item_ids[] = woocommerce_add_order_item($renewal_order_id, array('order_item_name' => $recurring_order_tax['name'], 'order_item_type' => 'tax')); // Also set recurring taxes on parent renewal orders if ('parent' == $args['new_order_role']) { $item_ids[] = woocommerce_add_order_item($renewal_order_id, array('order_item_name' => $recurring_order_tax['name'], 'order_item_type' => 'recurring_tax')); } // Add line item meta foreach ($item_ids as $item_id) { woocommerce_add_order_item_meta($item_id, 'compound', absint(isset($recurring_order_tax['compound']) ? $recurring_order_tax['compound'] : 0)); woocommerce_add_order_item_meta($item_id, 'tax_amount', woocommerce_clean($failed_payment_multiplier * $recurring_order_tax['tax_amount'])); woocommerce_add_order_item_meta($item_id, 'shipping_tax_amount', woocommerce_clean($failed_payment_multiplier * $recurring_order_tax['shipping_tax_amount'])); if (isset($recurring_order_tax['rate_id'])) { woocommerce_add_order_item_meta($item_id, 'rate_id', $recurring_order_tax['rate_id']); } if (isset($recurring_order_tax['label'])) { woocommerce_add_order_item_meta($item_id, 'label', $recurring_order_tax['label']); } } } else { // WC 1.x if (isset($recurring_order_tax['cart_tax']) && $recurring_order_tax['cart_tax'] > 0) { $recurring_order_taxes[$index]['cart_tax'] = $failed_payment_multiplier * $recurring_order_tax['cart_tax']; } else { $recurring_order_taxes[$index]['cart_tax'] = 0; } if (isset($recurring_order_tax['shipping_tax']) && $recurring_order_tax['shipping_tax'] > 0) { $recurring_order_taxes[$index]['shipping_tax'] = $failed_payment_multiplier * $recurring_order_tax['shipping_tax']; } else { $recurring_order_taxes[$index]['shipping_tax'] = 0; } // Inefficient but keeps WC 1.x code grouped together update_post_meta($renewal_order_id, '_order_taxes', $recurring_order_taxes); } } // Set line totals to be recurring line totals and remove the subscription/recurring related item meta from each order item $order_items = WC_Subscriptions_Order::get_recurring_items($original_order); // Allow extensions to add/remove items or item meta $order_items = apply_filters('woocommerce_subscriptions_renewal_order_items', $order_items, $original_order->id, $renewal_order_id, $product_id, $args['new_order_role']); foreach ($order_items as $item_index => $order_item) { $item_meta = new WC_Order_Item_Meta($order_item['item_meta']); // WC 2.0+ order item structure - as of WC 2.0 item_meta is stored as $key => meta pairs, not 'meta_name'/'meta_value' if (function_exists('woocommerce_add_order_item_meta')) { if ('child' == $args['new_order_role']) { $renewal_order_item_name = sprintf(__('Renewal of "%s" purchased in Order %s', WC_Subscriptions::$text_domain), $order_item['name'], $original_order->get_order_number()); } else { $renewal_order_item_name = $order_item['name']; } // Create order line item on the renewal order $recurring_item_id = woocommerce_add_order_item($renewal_order_id, array('order_item_name' => $renewal_order_item_name, 'order_item_type' => 'line_item')); // Remove recurring line items and set item totals based on recurring line totals foreach ($item_meta->meta as $meta_key => $meta) { // $meta is an array, so the item needs to be extracted from $meta[0] (just like order meta on a WC Order) $meta_value = $meta[0]; // Map line item totals based on recurring line totals switch ($meta_key) { case '_recurring_line_total': woocommerce_delete_order_item_meta($recurring_item_id, '_line_total'); woocommerce_add_order_item_meta($recurring_item_id, '_line_total', woocommerce_format_decimal($failed_payment_multiplier * $meta_value)); break; case '_recurring_line_tax': woocommerce_delete_order_item_meta($recurring_item_id, '_line_tax'); woocommerce_add_order_item_meta($recurring_item_id, '_line_tax', woocommerce_format_decimal($failed_payment_multiplier * $meta_value)); break; case '_recurring_line_subtotal': woocommerce_delete_order_item_meta($recurring_item_id, '_line_subtotal'); woocommerce_add_order_item_meta($recurring_item_id, '_line_subtotal', woocommerce_format_decimal($failed_payment_multiplier * $meta_value)); break; case '_recurring_line_subtotal_tax': woocommerce_delete_order_item_meta($recurring_item_id, '_line_subtotal_tax'); woocommerce_add_order_item_meta($recurring_item_id, '_line_subtotal_tax', woocommerce_format_decimal($failed_payment_multiplier * $meta_value)); break; default: break; } // Copy over line item meta data, with some parent/child role based exceptions for recurring amounts $copy_to_renewal_item = true; switch ($meta_key) { case '_recurring_line_total': case '_recurring_line_tax': case '_recurring_line_subtotal': case '_recurring_line_subtotal_tax': case '_subscription_recurring_amount': case '_subscription_sign_up_fee': case '_subscription_period': case '_subscription_interval': case '_subscription_length': case '_subscription_trial_period': case '_subscription_end_date': case '_subscription_expiry_date': case '_subscription_start_date': case '_subscription_status': case '_subscription_completed_payments': if ('child' == $args['new_order_role']) { $copy_to_renewal_item = false; } break; case '_subscription_trial_length': // We never want to duplicate free trials on renewal orders $copy_to_renewal_item = false; break; case '_subscription_suspension_count': // We want to reset some values for the new order // We want to reset some values for the new order case '_subscription_trial_expiry_date': case '_subscription_failed_payments': $copy_to_renewal_item = false; $meta_value = 0; break; default: break; } // Copy existing item over to new recurring order item if ($copy_to_renewal_item) { woocommerce_add_order_item_meta($recurring_item_id, $meta_key, $meta_value); } } } else { // WC 1.x order item structure foreach ($item_meta->meta as $meta_index => $meta_item) { switch ($meta_item['meta_name']) { case '_recurring_line_total': $order_items[$item_index]['line_total'] = $failed_payment_multiplier * $meta_item['meta_value']; case '_recurring_line_tax': $order_items[$item_index]['line_tax'] = $failed_payment_multiplier * $meta_item['meta_value']; case '_recurring_line_subtotal': $order_items[$item_index]['line_subtotal'] = $failed_payment_multiplier * $meta_item['meta_value']; case '_recurring_line_subtotal_tax': $order_items[$item_index]['line_subtotal_tax'] = $failed_payment_multiplier * $meta_item['meta_value']; case '_recurring_line_total': case '_recurring_line_tax': case '_recurring_line_subtotal': case '_recurring_line_subtotal_tax': case '_recurring_line_subtotal_tax': case '_subscription_recurring_amount': case '_subscription_sign_up_fee': case '_subscription_period': case '_subscription_interval': case '_subscription_length': case '_subscription_trial_length': case '_subscription_trial_period': if ('child' == $args['new_order_role']) { unset($item_meta->meta[$meta_index]); } break; case '_subscription_trial_length': // We never want to duplicate free trials on renewal orders if ('child' == $args['new_order_role']) { unset($item_meta->meta[$meta_index]); } else { $item_meta->meta[$meta_index] = 0; } break; } if ('child' == $args['new_order_role']) { $order_items[$item_index]['name'] = sprintf(__('Renewal of "%s" purchased in Order %s', WC_Subscriptions::$text_domain), $order_item['name'], $original_order->get_order_number()); } $order_items[$item_index]['item_meta'] = $item_meta->meta; } // Save the item meta on the new order update_post_meta($renewal_order_id, '_order_items', $order_items); } } // Keep a record of the original order's ID on the renewal order update_post_meta($renewal_order_id, '_original_order', $original_order->id, true); $renewal_order = new WC_Order($renewal_order_id); if ('parent' == $args['new_order_role']) { WC_Subscriptions_Manager::process_subscriptions_on_checkout($renewal_order_id); $original_order->add_order_note(sprintf(__('Order superseded by Renewal Order %s.', WC_Subscriptions::$text_domain), $renewal_order->get_order_number())); } do_action('woocommerce_subscriptions_renewal_order_created', $renewal_order, $original_order, $product_id, $args['new_order_role']); return apply_filters('woocommerce_subscriptions_renewal_order_id', $renewal_order_id, $original_order, $product_id, $args['new_order_role']); }
/** * Output the form */ public function output() { $this->errors = array(); $step = 1; try { if (!empty($_POST) && !check_admin_referer('create_booking_notification')) { throw new Exception(__('Error - please try again', 'woocommerce-bookings')); } if (!empty($_POST['create_booking'])) { $customer_id = absint($_POST['customer_id']); $bookable_product_id = absint($_POST['bookable_product_id']); $booking_order = wc_clean($_POST['booking_order']); if (!$bookable_product_id) { throw new Exception(__('Please choose a bookable product', 'woocommerce-bookings')); } if ($booking_order === 'existing') { $order_id = absint($_POST['booking_order_id']); $booking_order = $order_id; if (!$booking_order || get_post_type($booking_order) !== 'shop_order') { throw new Exception(__('Invalid order ID provided', 'woocommerce-bookings')); } } $step++; $product = get_product($bookable_product_id); $booking_form = new WC_Booking_Form($product); } elseif (!empty($_POST['create_booking_2'])) { $customer_id = absint($_POST['customer_id']); $bookable_product_id = absint($_POST['bookable_product_id']); $booking_order = wc_clean($_POST['booking_order']); $product = get_product($bookable_product_id); $booking_form = new WC_Booking_Form($product); $booking_data = $booking_form->get_posted_data($_POST); $booking_cost = ($cost = $booking_form->calculate_booking_cost($_POST)) && !is_wp_error($cost) ? number_format($cost, 2, '.', '') : 0; $create_order = false; if ('yes' === get_option('woocommerce_prices_include_tax')) { if (version_compare(WOOCOMMERCE_VERSION, '2.3', '<')) { $base_tax_rates = WC_Tax::get_shop_base_rate($product->tax_class); } else { $base_tax_rates = WC_Tax::get_base_tax_rates($product->tax_class); } $base_taxes = WC_Tax::calc_tax($booking_cost, $base_tax_rates, true); $booking_cost = round($booking_cost - array_sum($base_taxes), absint(get_option('woocommerce_price_num_decimals'))); } // Data to go into the booking $new_booking_data = array('user_id' => $customer_id, 'product_id' => $product->id, 'resource_id' => isset($booking_data['_resource_id']) ? $booking_data['_resource_id'] : '', 'persons' => $booking_data['_persons'], 'cost' => $booking_cost, 'start_date' => $booking_data['_start_date'], 'end_date' => $booking_data['_end_date'], 'all_day' => $booking_data['_all_day'] ? 1 : 0); // Create order if ($booking_order === 'new') { $create_order = true; $order_id = $this->create_order($booking_cost, $customer_id); if (!$order_id) { throw new Exception(__('Error: Could not create order', 'woocommerce-bookings')); } } elseif ($booking_order > 0) { $order_id = absint($booking_order); if (!$order_id || get_post_type($order_id) !== 'shop_order') { throw new Exception(__('Invalid order ID provided', 'woocommerce-bookings')); } $order = new WC_Order($order_id); update_post_meta($order_id, '_order_total', $order->get_total() + $booking_cost); update_post_meta($order_id, '_booking_order', '1'); } else { $order_id = 0; } if ($order_id) { $item_id = woocommerce_add_order_item($order_id, array('order_item_name' => $product->get_title(), 'order_item_type' => 'line_item')); if (!$item_id) { throw new Exception(__('Error: Could not create item', 'woocommerce-bookings')); } // Add line item meta woocommerce_add_order_item_meta($item_id, '_qty', 1); woocommerce_add_order_item_meta($item_id, '_tax_class', $product->get_tax_class()); woocommerce_add_order_item_meta($item_id, '_product_id', $product->id); woocommerce_add_order_item_meta($item_id, '_variation_id', ''); woocommerce_add_order_item_meta($item_id, '_line_subtotal', $booking_cost); woocommerce_add_order_item_meta($item_id, '_line_total', $booking_cost); woocommerce_add_order_item_meta($item_id, '_line_tax', 0); woocommerce_add_order_item_meta($item_id, '_line_subtotal_tax', 0); // We have an item id $new_booking_data['order_item_id'] = $item_id; // Add line item data foreach ($booking_data as $key => $value) { if (strpos($key, '_') !== 0) { woocommerce_add_order_item_meta($item_id, get_wc_booking_data_label($key, $product), $value); } } } // Create the booking itself $new_booking = get_wc_booking($new_booking_data); $new_booking->create($create_order ? 'unpaid' : 'pending-confirmation'); wp_safe_redirect(admin_url('post.php?post=' . ($create_order ? $order_id : $new_booking->id) . '&action=edit')); exit; } } catch (Exception $e) { $this->errors[] = $e->getMessage(); } switch ($step) { case 1: include 'views/html-create-booking-page.php'; break; case 2: include 'views/html-create-booking-page-2.php'; break; } }
/** * order_item_meta function. * * @param mixed $item_id * @param mixed $values */ public function order_item_meta($item_id, $values) { if (!empty($values['booking'])) { $product = $values['data']; // Create the new booking $new_booking_data = array('order_item_id' => $item_id, 'product_id' => $values['product_id'], 'cost' => $values['booking']['_cost'], 'start_date' => $values['booking']['_start_date'], 'end_date' => $values['booking']['_end_date'], 'all_day' => $values['booking']['_all_day']); // Check if the booking has resources if (isset($values['booking']['_resource_id'])) { $new_booking_data['resource_id'] = $values['booking']['_resource_id']; // ID of the resource } // Checks if the booking allows persons if (isset($values['booking']['_persons'])) { $new_booking_data['persons'] = $values['booking']['_persons']; // Count of persons making booking } $booking_status = 'unpaid'; // Set as pending when the booking requires confirmation if (wc_booking_requires_confirmation($values['product_id'])) { $booking_status = 'pending'; } $new_booking = get_wc_booking($new_booking_data); $new_booking->create($booking_status); // Add summary of details to line item foreach ($values['booking'] as $key => $value) { if (strpos($key, '_') !== 0) { woocommerce_add_order_item_meta($item_id, get_wc_booking_data_label($key, $product), $value); } } } }
/** * Uses the details of an order to create a pending subscription on the customers account * for a subscription product, as specified with $product_id. * * @param int|WC_Order $order The order ID or WC_Order object to create the subscription from. * @param int $product_id The ID of the subscription product on the order. * @param array $args An array of name => value pairs to customise the details of the subscription, including: * 'start_date' A MySQL formatted date/time string on which the subscription should start, in UTC timezone * 'expiry_date' A MySQL formatted date/time string on which the subscription should expire, in UTC timezone * @since 1.1 */ public static function create_pending_subscription_for_order($order, $product_id, $args = array()) { if (!is_object($order)) { $order = new WC_Order($order); } if (!WC_Subscriptions_Product::is_subscription($product_id)) { return; } $args = wp_parse_args($args, array('start_date' => '', 'expiry_date' => '')); $subscription_key = self::get_subscription_key($order->id, $product_id); // In case the subscription exists already $subscription = self::get_subscription($subscription_key); if (!empty($subscription['variation_id'])) { $product_id = $subscription['variation_id']; } elseif (!empty($subscription['product_id'])) { $product_id = $subscription['product_id']; } // Adding a new subscription so set the start date/time to now if (!empty($args['start_date'])) { if (is_numeric($args['start_date'])) { $args['start_date'] = date('Y-m-d H:i:s', $args['start_date']); } $start_date = $args['start_date']; } else { $start_date = !empty($subscription['start_date']) ? $subscription['start_date'] : gmdate('Y-m-d H:i:s'); } // Adding a new subscription so set the expiry date/time from the order date if (!empty($args['expiry_date'])) { if (is_numeric($args['expiry_date'])) { $args['expiry_date'] = date('Y-m-d H:i:s', $args['expiry_date']); } $expiration = $args['expiry_date']; } else { $expiration = !empty($subscription['expiry_date']) ? $subscription['expiry_date'] : WC_Subscriptions_Product::get_expiration_date($product_id, $start_date); } // Adding a new subscription so set the expiry date/time from the order date $trial_expiration = !empty($subscription['trial_expiry_date']) ? $subscription['trial_expiry_date'] : WC_Subscriptions_Product::get_trial_expiration_date($product_id, $start_date); $failed_payments = !empty($subscription['failed_payments']) ? $subscription['failed_payments'] : 0; $completed_payments = !empty($subscription['completed_payments']) ? $subscription['completed_payments'] : array(); $order_item_id = WC_Subscriptions_Order::get_item_id_by_subscription_key($subscription_key); // Store the subscription details in item meta woocommerce_add_order_item_meta($order_item_id, '_subscription_start_date', $start_date, true); woocommerce_add_order_item_meta($order_item_id, '_subscription_expiry_date', $expiration, true); woocommerce_add_order_item_meta($order_item_id, '_subscription_trial_expiry_date', $trial_expiration, true); woocommerce_add_order_item_meta($order_item_id, '_subscription_failed_payments', $failed_payments, true); woocommerce_add_order_item_meta($order_item_id, '_subscription_completed_payments', $completed_payments, true); woocommerce_add_order_item_meta($order_item_id, '_subscription_status', 'pending', true); woocommerce_add_order_item_meta($order_item_id, '_subscription_end_date', 0, true); woocommerce_add_order_item_meta($order_item_id, '_subscription_suspension_count', 0, true); $product = WC_Subscriptions::get_product($product_id); // Set subscription status to active and log activation $order->add_order_note(sprintf(__('Pending subscription created for "%s".', 'woocommerce-subscriptions'), $product->get_title())); do_action('pending_subscription_created_for_order', $order, $product_id); }
/** * Unassign vendor from a product */ function unassign_vendor() { global $WCMp; $product_id = $_POST['product_id']; $vendor = get_wcmp_product_vendors($product_id); $admin_id = get_current_user_id(); $_product = get_product($product_id); $orders = array(); if ($_product->is_type('variable')) { $get_children = $_product->get_children(); if (!empty($get_children)) { foreach ($get_children as $child) { $orders = array_merge($orders, $vendor->get_vendor_orders_by_product($vendor->term_id, $child)); } $orders = array_unique($orders); } } else { $orders = array_unique($vendor->get_vendor_orders_by_product($vendor->term_id, $product_id)); } foreach ($orders as $order_id) { $order = new WC_Order($order_id); $items = $order->get_items('line_item'); foreach ($items as $item_id => $item) { woocommerce_add_order_item_meta($item_id, '_vendor_id', $vendor->id); } } wp_delete_object_term_relationships($product_id, 'dc_vendor_shop'); wp_delete_object_term_relationships($product_id, 'product_shipping_class'); wp_update_post(array('ID' => $product_id, 'post_author' => $admin_id)); delete_post_meta($product_id, '_commission_per_product'); delete_post_meta($product_id, '_commission_percentage_per_product'); delete_post_meta($product_id, '_commission_fixed_with_percentage_qty'); delete_post_meta($product_id, '_commission_fixed_with_percentage'); $product_obj = wc_get_product($product_id); if ($product_obj->is_type('variable')) { $child_ids = $product_obj->get_children(); if (isset($child_ids) && !empty($child_ids)) { foreach ($child_ids as $child_id) { delete_post_meta($child_id, '_commission_fixed_with_percentage'); delete_post_meta($child_id, '_product_vendors_commission_percentage'); delete_post_meta($child_id, '_product_vendors_commission_fixed_per_trans'); delete_post_meta($child_id, '_product_vendors_commission_fixed_per_qty'); } } } die; }
/** * Add meta to orders * * @access public * @param mixed $item_id * @param mixed $values * @return void */ public function order_item_meta($item_id, $values) { if (!empty($values['addons'])) { foreach ($values['addons'] as $addon) { $name = $addon['name']; if ($addon['price'] > 0 && apply_filters('woocommerce_addons_add_price_to_name', true)) { $name .= ' (' . strip_tags(wc_price(get_frame_price_for_display($addon['price'], $values['data'], true))) . ')'; } woocommerce_add_order_item_meta($item_id, $name, $addon['value']); } } }
public function order_item_meta_2($item_id, $cart_item) { if (function_exists('woocommerce_add_order_item_meta')) { if (isset($cart_item['_gravity_form_lead']) && isset($cart_item['_gravity_form_data'])) { woocommerce_add_order_item_meta($item_id, '_gravity_forms_history', array('_gravity_form_lead' => $cart_item['_gravity_form_lead'], '_gravity_form_data' => $cart_item['_gravity_form_data'])); //Gravity forms generates errors and warnings. To prevent these from conflicting with other things, we are going to disable warnings and errors. $err_level = error_reporting(); error_reporting(0); $gravity_form_data = $cart_item['_gravity_form_data']; $form_meta = RGFormsModel::get_form_meta($gravity_form_data['id']); if (!empty($form_meta)) { $lead = $cart_item['_gravity_form_lead']; $lead['id'] = uniqid() . time() . rand(); $products = $this->get_product_fields($form_meta, $lead); $valid_products = array(); foreach ($products['products'] as $id => $product) { if (!isset($product['quantity'])) { } elseif ($product['quantity']) { $valid_products[] = $id; } } foreach ($form_meta['fields'] as $field) { if (isset($field['inputType']) && $field['inputType'] == 'hiddenproduct' || isset($field['displayOnly']) && $field['displayOnly']) { continue; } if ($field['type'] == 'product') { if (!in_array($field['id'], $valid_products)) { continue; } } $value = RGFormsModel::get_lead_field_value($lead, $field); $arr_var = is_array($value) ? implode('', $value) : '-'; if (!empty($value) && !empty($arr_var)) { try { if ($field['type'] == 'fileupload' && isset($lead[$field['id']])) { $display_value = $lead[$field['id']]; } else { $display_value = GFCommon::get_lead_field_display($field, $value, isset($lead["currency"]) ? $lead["currency"] : false, apply_filters('woocommerce_gforms_use_label_as_value', true, $value, $field, $lead, $form_meta)); $price_adjustement = false; $display_value = apply_filters("gform_entry_field_value", $display_value, $field, $lead, $form_meta); } $display_title = GFCommon::get_label($field); $display_title = apply_filters("woocommerce_gforms_order_meta_title", $display_title, $field, $lead, $form_meta, $item_id, $cart_item); $display_value = apply_filters("woocommerce_gforms_order_meta_value", $display_value, $field, $lead, $form_meta, $item_id, $cart_item); if (apply_filters('woocommerce_gforms_strip_meta_html', true, $display_value, $field, $lead, $form_meta, $item_id, $cart_item)) { if (strstr($display_value, '<li>')) { $display_value = str_replace('<li>', '', $display_value); $display_value = explode('</li>', $display_value); $display_value = trim(strip_tags(implode(', ', $display_value))); $display_value = trim($display_value, ','); } $display_value = strip_tags(wp_kses($display_value, '')); } $display_text = GFCommon::get_lead_field_display($field, $value, isset($lead["currency"]) ? $lead["currency"] : false, false); $display_value = apply_filters("woocommerce_gforms_field_display_text", $display_value, $display_text, $field, $lead, $form_meta); $hidden = $field['type'] == 'hidden'; $prefix = $hidden ? '_' : ''; woocommerce_add_order_item_meta($item_id, $prefix . $display_title, $display_value); } catch (Exception $e) { } } } } error_reporting($err_level); } } }
/** * Use views to display the Orders page * * @return html */ public function display_product_orders() { if (!WCV_Vendors::is_vendor(get_current_user_id())) { ob_start(); wc_get_template('denied.php', array(), 'wc-vendors/dashboard/', wcv_plugin_dir . 'templates/dashboard/'); return ob_get_clean(); } if (empty($_GET['orders_for_product'])) { return __('You haven\'t selected a product\'s orders to view! Please go back to the Vendor Dashboard and click Show Orders on the product you\'d like to view.', 'wcvendors'); } if (!$this->orders) { return __('No orders.', 'wcvendors'); } if (!empty($_POST['submit_comment'])) { require_once wcv_plugin_dir . 'classes/front/orders/class-submit-comment.php'; WCV_Submit_Comment::new_comment($this->orders); } if (isset($_POST['mark_shipped'])) { $order_id = (int) $_POST['order_id']; $product_id = (int) $_POST['product_id']; exit; } if (isset($_POST['update_tracking'])) { $order_id = (int) $_POST['order_id']; $product_id = (int) $_POST['product_id']; $tracking_provider = woocommerce_clean($_POST['tracking_provider']); $custom_tracking_provider = woocommerce_clean($_POST['custom_tracking_provider']); $custom_tracking_link = woocommerce_clean($_POST['custom_tracking_link']); $tracking_number = woocommerce_clean($_POST['tracking_number']); $date_shipped = woocommerce_clean(strtotime($_POST['date_shipped'])); $order = new WC_Order($order_id); $products = $order->get_items(); foreach ($products as $key => $value) { if ($value['product_id'] == $product_id || $value['variation_id'] == $product_id) { $order_item_id = $key; break; } } if ($order_item_id) { woocommerce_delete_order_item_meta($order_item_id, __('Tracking number', 'wcvendors')); woocommerce_add_order_item_meta($order_item_id, __('Tracking number', 'wcvendors'), $tracking_number); $message = __('Success. Your tracking number has been updated.', 'wcvendors'); wc_add_notice($message, 'success'); // Update order data update_post_meta($order_id, '_tracking_provider', $tracking_provider); update_post_meta($order_id, '_custom_tracking_provider', $custom_tracking_provider); update_post_meta($order_id, '_tracking_number', $tracking_number); update_post_meta($order_id, '_custom_tracking_link', $custom_tracking_link); update_post_meta($order_id, '_date_shipped', $date_shipped); } } $headers = WCV_Orders::get_headers(); $all = WCV_Orders::format_order_details($this->orders, $this->product_id); wp_enqueue_style('pv_frontend_style', wcv_assets_url . 'css/wcv-frontend.css'); wp_enqueue_script('pv_frontend_script', wcv_assets_url . 'js/front-orders.js'); // WC Shipment Tracking Providers global $WC_Shipment_Tracking; $providers = !empty($WC_Shipment_Tracking->providers) ? $WC_Shipment_Tracking->providers : false; $provider_array = array(); if ($providers) { foreach ($providers as $providerss) { foreach ($providerss as $provider => $format) { $provider_array[sanitize_title($provider)] = urlencode($format); } } } // End ob_start(); // Show the Export CSV button if ($this->can_export_csv) { wc_get_template('csv-export.php', array(), 'wc-vendors/orders/', wcv_plugin_dir . 'templates/orders/'); } wc_get_template('orders.php', array('headers' => $headers, 'body' => $all['body'], 'items' => $all['items'], 'product_id' => $all['product_id'], 'providers' => $providers, 'provider_array' => $provider_array), 'wc-vendors/orders/', wcv_plugin_dir . 'templates/orders/'); return ob_get_clean(); }
function uni_cpo_add_order_item_meta($item_id, $values, $cart_item_key) { $sEnableCalcFrontend = $values['_uni_cpo_calc_option']; if (isset($sEnableCalcFrontend)) { if (isset($values['_uni_cpo_data'])) { $sProductId = $values['product_id']; $aCustomOptions = uni_cpo_get_product_attributes($sProductId); if ($aCustomOptions) { foreach ($aCustomOptions as $aOption) { if (empty($aOption['is_visible']) || $aOption['is_taxonomy'] && !taxonomy_exists($aOption['name'])) { continue; } switch ($aOption['cpo_type']) { case 'input': if ($aOption['value']) { foreach ($aOption['value'] as $sValue) { $oTerm = get_term_by('slug', $sValue, $aOption['name']); if (!empty($values['_uni_cpo_data']['uni_cpo_' . $sValue])) { woocommerce_add_order_item_meta($item_id, $oTerm->name, $values['_uni_cpo_data']['uni_cpo_' . $sValue]); } } } break; case 'input_number': if ($aOption['value']) { foreach ($aOption['value'] as $sValue) { $oTerm = get_term_by('slug', $sValue, $aOption['name']); woocommerce_add_order_item_meta($item_id, $oTerm->name, $values['_uni_cpo_data']['uni_cpo_' . $sValue]); } } break; case 'select': $sParentTermSlug = $aOption['name']; $sFieldValue = $values['_uni_cpo_data']['uni_cpo_' . $sParentTermSlug]; $oTerm = get_term_by('slug', $sFieldValue, $sParentTermSlug); if ($sFieldValue) { woocommerce_add_order_item_meta($item_id, wc_attribute_label($aOption['name']), $oTerm->name); } break; case 'radio': $sParentTermSlug = $aOption['name']; $sFieldValue = $values['_uni_cpo_data']['uni_cpo_' . $sParentTermSlug]; $oTerm = get_term_by('slug', $sFieldValue, $sParentTermSlug); if ($sFieldValue) { woocommerce_add_order_item_meta($item_id, wc_attribute_label($aOption['name']), $oTerm->name); } break; case 'checkbox': if ($aOption['value']) { foreach ($aOption['value'] as $sValue) { $sFieldValue = $values['_uni_cpo_data']['uni_cpo_' . $sValue]; $oTerm = get_term_by('slug', $sValue, $aOption['name']); if ($sFieldValue) { woocommerce_add_order_item_meta($item_id, $oTerm->name, __('Checked', 'uni-cpo')); } } } break; case 'checkbox_multiple': if (isset($values['_uni_cpo_data']['uni_cpo_' . $aOption['name']]) && !empty($values['_uni_cpo_data']['uni_cpo_' . $aOption['name']])) { $aCheckboxedTermsName = array(); foreach ($values['_uni_cpo_data']['uni_cpo_' . $aOption['name']] as $sValue) { $oTerm = get_term_by('slug', $sValue, $aOption['name']); $aCheckboxedTermsName[] = $oTerm->name; } if (isset($aCheckboxedTermsName) && !empty($aCheckboxedTermsName)) { $sCheckboxedTermsName = implode(', ', $aCheckboxedTermsName); woocommerce_add_order_item_meta($item_id, wc_attribute_label($aOption['name']), $sCheckboxedTermsName); } } break; case 'color': $sParentTermSlug = $aOption['name']; $sFieldValue = $values['_uni_cpo_data']['uni_cpo_' . $sParentTermSlug]; if ($sFieldValue) { foreach ($aOption['value'] as $sValue) { $oTerm = get_term_by('slug', $sValue, $aOption['name']); $aTermData = get_option('uni_cpo_attr_' . $oTerm->term_id . '_data'); if ($aTermData['attr_color_code'] == $sFieldValue) { woocommerce_add_order_item_meta($item_id, wc_attribute_label($aOption['name']), $oTerm->name); } } } break; case 'color_ext': $sParentTermSlug = $aOption['name']; $sFieldValue = $values['_uni_cpo_data']['uni_cpo_' . $sParentTermSlug]; if ($sFieldValue) { foreach ($aOption['value'] as $sValue) { $oTerm = get_term_by('slug', $sValue, $aOption['name']); $aTermData = get_option('uni_cpo_attr_' . $oTerm->term_id . '_data'); woocommerce_add_order_item_meta($item_id, wc_attribute_label($aOption['name']), $sFieldValue); } } break; case 'textarea': if ($aOption['value']) { foreach ($aOption['value'] as $sValue) { $oTerm = get_term_by('slug', $sValue, $aOption['name']); woocommerce_add_order_item_meta($item_id, $oTerm->name, $values['_uni_cpo_data']['uni_cpo_' . $sValue]); } } break; } } } } } }
/** * Triggered when adding an item in the backend. * * If deposits are forced, set all meta data. */ public function ajax_add_order_item_meta($item_id, $item) { if (WC_Deposits_Product_Manager::deposits_forced($item['product_id'])) { $product = wc_get_product(absint($item['variation_id'] ? $item['variation_id'] : $item['product_id'])); woocommerce_add_order_item_meta($item_id, '_is_deposit', 'yes'); woocommerce_add_order_item_meta($item_id, '_deposit_full_amount', $item['line_total']); woocommerce_add_order_item_meta($item_id, '_deposit_full_amount_ex_tax', $item['line_total']); if ('plan' === WC_Deposits_Product_Manager::get_deposit_type($item['product_id'])) { $plan_id = current(WC_Deposits_Plans_Manager::get_plan_ids_for_product($item['product_id'])); woocommerce_add_order_item_meta($item_id, '_payment_plan', $plan_id); } else { $plan_id = 0; } // Change line item costs $deposit_amount = WC_Deposits_Product_Manager::get_deposit_amount($product, $plan_id, 'order', $item['line_total']); wc_update_order_item_meta($item_id, '_line_total', $deposit_amount); wc_update_order_item_meta($item_id, '_line_subtotal', $deposit_amount); } }
/** * Create new orders based on the parsed data */ private function process_orders() { global $wpdb; $this->imported = $this->merged = 0; // peforming a dry run? $dry_run = isset($_POST['dry_run']) && $_POST['dry_run'] ? true : false; $this->log->add('---'); $this->log->add(__('Processing orders.', WC_Customer_CSV_Import_Suite::TEXT_DOMAIN)); foreach ($this->posts as $post) { // orders with custom order order numbers can be checked for existance, otherwise there's not much we can do if (!empty($post['order_number_formatted']) && isset($this->processed_posts[$post['order_number_formatted']])) { $this->skipped++; $this->log->add(sprintf(__('> Order %s already processed. Skipping.', WC_Customer_CSV_Import_Suite::TEXT_DOMAIN), $post['order_number_formatted']), true); continue; } // see class-wc-checkout.php for reference $order_data = array('post_date' => date('Y-m-d H:i:s', $post['date']), 'post_type' => 'shop_order', 'post_title' => 'Order – ' . date('F j, Y @ h:i A', $post['date']), 'post_status' => 'publish', 'ping_status' => 'closed', 'post_excerpt' => $post['order_comments'], 'post_author' => 1, 'post_password' => uniqid('order_')); if (!$dry_run) { // track whether download permissions need to be granted $add_download_permissions = false; $order_id = wp_insert_post($order_data); if (is_wp_error($order_id)) { $this->errored++; $this->log->add(sprintf(__('> Error inserting %s: %s', WC_Customer_CSV_Import_Suite::TEXT_DOMAIN), $post['order_number_formatted'], $order_id->get_error_message()), true); } // empty update to bump up the post_modified date to today's date (otherwise it would match the post_date, which isn't quite right) wp_update_post(array('ID' => $order_id)); // set order status wp_set_object_terms($order_id, $post['status'], 'shop_order_status'); // handle special meta fields update_post_meta($order_id, '_order_key', apply_filters('woocommerce_generate_order_key', uniqid('order_'))); update_post_meta($order_id, '_order_currency', get_woocommerce_currency()); // TODO: fine to use store default? if (!SV_WC_Plugin_Compatibility::is_wc_version_gte_2_1()) { update_post_meta($order_id, '_order_taxes', array()); // pre-2.1 } update_post_meta($order_id, '_prices_include_tax', get_option('woocommerce_prices_include_tax')); // add order postmeta foreach ($post['postmeta'] as $meta) { $meta_processed = false; // we don't set the "download permissions granted" meta, we call the woocommerce function to take care of this for us if (('Download Permissions Granted' == $meta['key'] || '_download_permissions_granted' == $meta['key']) && $meta['value']) { $add_download_permissions = true; $meta_processed = true; } if (!$meta_processed) { update_post_meta($order_id, $meta['key'], $meta['value']); } // set the paying customer flag on the user meta if applicable if ('_customer_user' == $meta['key'] && $meta['value'] && in_array($post['status'], array('processing', 'completed', 'refunded'))) { update_user_meta($meta['value'], "paying_customer", 1); } } // handle order items $order_items = array(); $order_item_meta = null; foreach ($post['order_items'] as $item) { $product = null; $variation_item_meta = array(); // if there's a product_id then we've already determined during parsing that this product exists if ($item['product_id']) { $product = get_product($item['product_id']); // handle variations if (($product->is_type('variable') || $product->is_type('variation') || $product->is_type('subscription_variation')) && method_exists($product, 'get_variation_id')) { foreach ($product->get_variation_attributes() as $key => $value) { $variation_item_meta[] = array('meta_name' => esc_attr(substr($key, 10)), 'meta_value' => $value); // remove the leading 'attribute_' from the name to get 'pa_color' for instance } } } // order item $order_items[] = array('order_item_name' => $product ? $product->get_title() : __('Unknown Product', WC_Customer_CSV_Import_Suite::TEXT_DOMAIN), 'order_item_type' => 'line_item'); // standard order item meta $_order_item_meta = array('_qty' => (int) $item['qty'], '_tax_class' => '', '_product_id' => $item['product_id'], '_variation_id' => $product && method_exists($product, 'get_variation_id') ? $product->get_variation_id() : 0, '_line_subtotal' => number_format((double) $item['total'], 2, '.', ''), '_line_subtotal_tax' => 0, '_line_total' => number_format((double) $item['total'], 2, '.', ''), '_line_tax' => 0); // add any product variation meta foreach ($variation_item_meta as $meta) { $_order_item_meta[$meta['meta_name']] = $meta['meta_value']; } // include any arbitrary order item meta $_order_item_meta = array_merge($_order_item_meta, $item['meta']); $order_item_meta[] = $_order_item_meta; } foreach ($order_items as $key => $order_item) { $order_item_id = woocommerce_add_order_item($order_id, $order_item); if ($order_item_id) { foreach ($order_item_meta[$key] as $meta_key => $meta_value) { if (strpos($meta_value, ':{i')) { $meta_value = unserialize(stripslashes($meta_value)); //'a:1:{i:0;s:19:"2014-05-01 08:00:00";}'; } woocommerce_add_order_item_meta($order_item_id, $meta_key, $meta_value); } } } // create the shipping order items (WC 2.1+) foreach ($post['order_shipping'] as $order_shipping) { $shipping_order_item = array('order_item_name' => $order_shipping['title'], 'order_item_type' => 'shipping'); $shipping_order_item_id = woocommerce_add_order_item($order_id, $shipping_order_item); if ($shipping_order_item_id) { woocommerce_add_order_item_meta($shipping_order_item_id, 'method_id', $order_shipping['method_id']); woocommerce_add_order_item_meta($shipping_order_item_id, 'cost', $order_shipping['cost']); } } // create the tax order items (WC 2.1+) foreach ($post['tax_items'] as $tax_item) { $tax_order_item = array('order_item_name' => $tax_item['title'], 'order_item_type' => 'tax'); $tax_order_item_id = woocommerce_add_order_item($order_id, $tax_order_item); if ($tax_order_item_id) { woocommerce_add_order_item_meta($tax_order_item_id, 'rate_id', $tax_item['rate_id']); woocommerce_add_order_item_meta($tax_order_item_id, 'label', $tax_item['label']); woocommerce_add_order_item_meta($tax_order_item_id, 'compound', $tax_item['compound']); woocommerce_add_order_item_meta($tax_order_item_id, 'tax_amount', $tax_item['tax_amount']); woocommerce_add_order_item_meta($tax_order_item_id, 'shipping_tax_amount', $tax_item['shipping_tax_amount']); } } // Grant downloadalbe product permissions if ($add_download_permissions) { woocommerce_downloadable_product_permissions($order_id); } // add order notes $order = new WC_Order($order_id); foreach ($post['notes'] as $order_note) { $order->add_order_note($order_note); } // record the product sales $order->record_product_sales(); } // ! dry run // was an original order number provided? if (!empty($post['order_number_formatted'])) { if (!$dry_run) { // do our best to provide some custom order number functionality while also allowing 3rd party plugins to provide their own custom order number facilities do_action('woocommerce_set_order_number', $order, $post['order_number'], $post['order_number_formatted']); $order->add_order_note(sprintf(__("Original order #%s", WC_Customer_CSV_Import_Suite::TEXT_DOMAIN), $post['order_number_formatted'])); // get the order so we can display the correct order number $order = new WC_Order($order_id); } $this->processed_posts[$post['order_number_formatted']] = $post['order_number_formatted']; } $this->imported++; $this->log->add(sprintf(__('> Finished importing order %s', WC_Customer_CSV_Import_Suite::TEXT_DOMAIN), $dry_run ? "" : $order->get_order_number())); } $this->log->add(__('Finished processing orders.', WC_Customer_CSV_Import_Suite::TEXT_DOMAIN)); unset($this->posts); }
/** * create_order function. * * @access public * @return void */ public function create_order() { global $woocommerce, $wpdb; // Give plugins the opportunity to create an order themselves $order_id = apply_filters('woocommerce_create_order', null, $this); if (is_numeric($order_id)) { return $order_id; } // Create Order (send cart variable so we can record items and reduce inventory). Only create if this is a new order, not if the payment was rejected. $order_data = apply_filters('woocommerce_new_order_data', array('post_type' => 'shop_order', 'post_title' => sprintf(__('Order – %s', 'woocommerce'), strftime(_x('%b %d, %Y @ %I:%M %p', 'Order date parsed by strftime', 'woocommerce'))), 'post_status' => 'publish', 'ping_status' => 'closed', 'post_excerpt' => isset($this->posted['order_comments']) ? $this->posted['order_comments'] : '', 'post_author' => 1, 'post_password' => uniqid('order_'))); // Insert or update the post data $create_new_order = true; if ($woocommerce->session->order_awaiting_payment > 0) { $order_id = absint($woocommerce->session->order_awaiting_payment); /* Check order is unpaid by getting its status */ $terms = wp_get_object_terms($order_id, 'shop_order_status', array('fields' => 'slugs')); $order_status = isset($terms[0]) ? $terms[0] : 'pending'; // Resume the unpaid order if its pending if ($order_status == 'pending' || $order_status == 'failed') { // Update the existing order as we are resuming it $create_new_order = false; $order_data['ID'] = $order_id; wp_update_post($order_data); // Clear the old line items - we'll add these again in case they changed $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}woocommerce_order_itemmeta WHERE order_item_id IN ( SELECT order_item_id FROM {$wpdb->prefix}woocommerce_order_items WHERE order_id = %d )", $order_id)); $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}woocommerce_order_items WHERE order_id = %d", $order_id)); // Trigger an action for the resumed order do_action('woocommerce_resume_order', $order_id); } } if ($create_new_order) { $order_id = wp_insert_post($order_data); if (is_wp_error($order_id)) { throw new MyException('Error: Unable to create order. Please try again.'); } else { do_action('woocommerce_new_order', $order_id); } } // Store user data if ($this->checkout_fields['billing']) { foreach ($this->checkout_fields['billing'] as $key => $field) { update_post_meta($order_id, '_' . $key, $this->posted[$key]); // User if ($this->customer_id && !empty($this->posted[$key])) { update_user_meta($this->customer_id, $key, $this->posted[$key]); // Special fields switch ($key) { case "billing_email": if (!email_exists($this->posted[$key])) { wp_update_user(array('ID' => $this->customer_id, 'user_email' => $this->posted[$key])); } break; case "billing_first_name": wp_update_user(array('ID' => $this->customer_id, 'first_name' => $this->posted[$key])); break; case "billing_last_name": wp_update_user(array('ID' => $this->customer_id, 'last_name' => $this->posted[$key])); break; } } } } if ($this->checkout_fields['shipping'] && ($woocommerce->cart->needs_shipping() || get_option('woocommerce_require_shipping_address') == 'yes')) { foreach ($this->checkout_fields['shipping'] as $key => $field) { $postvalue = false; if ($this->posted['shiptobilling']) { if (isset($this->posted[str_replace('shipping_', 'billing_', $key)])) { $postvalue = $this->posted[str_replace('shipping_', 'billing_', $key)]; update_post_meta($order_id, '_' . $key, $postvalue); } } else { $postvalue = $this->posted[$key]; update_post_meta($order_id, '_' . $key, $postvalue); } // User if ($postvalue && $this->customer_id) { update_user_meta($this->customer_id, $key, $postvalue); } } } // Save any other user meta if ($this->customer_id) { do_action('woocommerce_checkout_update_user_meta', $this->customer_id, $this->posted); } // Store the line items to the new/resumed order foreach ($woocommerce->cart->get_cart() as $cart_item_key => $values) { $_product = $values['data']; // Add line item $item_id = woocommerce_add_order_item($order_id, array('order_item_name' => $_product->get_title(), 'order_item_type' => 'line_item')); // Add line item meta if ($item_id) { woocommerce_add_order_item_meta($item_id, '_qty', apply_filters('woocommerce_stock_amount', $values['quantity'])); woocommerce_add_order_item_meta($item_id, '_tax_class', $_product->get_tax_class()); woocommerce_add_order_item_meta($item_id, '_product_id', $values['product_id']); woocommerce_add_order_item_meta($item_id, '_variation_id', $values['variation_id']); woocommerce_add_order_item_meta($item_id, '_line_subtotal', woocommerce_format_decimal($values['line_subtotal'], 4)); woocommerce_add_order_item_meta($item_id, '_line_total', woocommerce_format_decimal($values['line_total'], 4)); woocommerce_add_order_item_meta($item_id, '_line_tax', woocommerce_format_decimal($values['line_tax'], 4)); woocommerce_add_order_item_meta($item_id, '_line_subtotal_tax', woocommerce_format_decimal($values['line_subtotal_tax'], 4)); // Store variation data in meta so admin can view it if ($values['variation'] && is_array($values['variation'])) { foreach ($values['variation'] as $key => $value) { woocommerce_add_order_item_meta($item_id, esc_attr(str_replace('attribute_', '', $key)), $value); } } // Add line item meta for backorder status if ($_product->backorders_require_notification() && $_product->is_on_backorder($values['quantity'])) { woocommerce_add_order_item_meta($item_id, apply_filters('woocommerce_backordered_item_meta_name', __('Backordered', 'woocommerce'), $cart_item_key, $order_id), $values['quantity'] - max(0, $_product->get_total_stock())); } // Allow plugins to add order item meta do_action('woocommerce_add_order_item_meta', $item_id, $values); } } // Store fees foreach ($woocommerce->cart->get_fees() as $fee) { $item_id = woocommerce_add_order_item($order_id, array('order_item_name' => $fee->name, 'order_item_type' => 'fee')); if ($fee->taxable) { woocommerce_add_order_item_meta($item_id, '_tax_class', $fee->tax_class); } else { woocommerce_add_order_item_meta($item_id, '_tax_class', '0'); } woocommerce_add_order_item_meta($item_id, '_line_total', woocommerce_format_decimal($fee->amount)); woocommerce_add_order_item_meta($item_id, '_line_tax', woocommerce_format_decimal($fee->tax)); } // Store tax rows foreach (array_keys($woocommerce->cart->taxes + $woocommerce->cart->shipping_taxes) as $key) { $item_id = woocommerce_add_order_item($order_id, array('order_item_name' => $woocommerce->cart->tax->get_rate_code($key), 'order_item_type' => 'tax')); // Add line item meta if ($item_id) { woocommerce_add_order_item_meta($item_id, 'rate_id', $key); woocommerce_add_order_item_meta($item_id, 'label', $woocommerce->cart->tax->get_rate_label($key)); woocommerce_add_order_item_meta($item_id, 'compound', absint($woocommerce->cart->tax->is_compound($key) ? 1 : 0)); woocommerce_add_order_item_meta($item_id, 'tax_amount', woocommerce_clean(isset($woocommerce->cart->taxes[$key]) ? $woocommerce->cart->taxes[$key] : 0)); woocommerce_add_order_item_meta($item_id, 'shipping_tax_amount', woocommerce_clean(isset($woocommerce->cart->shipping_taxes[$key]) ? $woocommerce->cart->shipping_taxes[$key] : 0)); } } // Store coupons if ($applied_coupons = $woocommerce->cart->get_applied_coupons()) { foreach ($applied_coupons as $code) { $item_id = woocommerce_add_order_item($order_id, array('order_item_name' => $code, 'order_item_type' => 'coupon')); // Add line item meta if ($item_id) { woocommerce_add_order_item_meta($item_id, 'discount_amount', isset($woocommerce->cart->coupon_discount_amounts[$code]) ? $woocommerce->cart->coupon_discount_amounts[$code] : 0); } } } // Store meta if ($this->shipping_method) { update_post_meta($order_id, '_shipping_method', $this->shipping_method->id); update_post_meta($order_id, '_shipping_method_title', $this->shipping_method->label); } if ($this->payment_method) { update_post_meta($order_id, '_payment_method', $this->payment_method->id); update_post_meta($order_id, '_payment_method_title', $this->payment_method->get_title()); } update_post_meta($order_id, '_order_shipping', woocommerce_format_total($woocommerce->cart->shipping_total)); update_post_meta($order_id, '_order_discount', woocommerce_format_total($woocommerce->cart->get_order_discount_total())); update_post_meta($order_id, '_cart_discount', woocommerce_format_total($woocommerce->cart->get_cart_discount_total())); update_post_meta($order_id, '_order_tax', woocommerce_clean($woocommerce->cart->tax_total)); update_post_meta($order_id, '_order_shipping_tax', woocommerce_clean($woocommerce->cart->shipping_tax_total)); update_post_meta($order_id, '_order_total', woocommerce_format_total($woocommerce->cart->total)); update_post_meta($order_id, '_order_key', apply_filters('woocommerce_generate_order_key', uniqid('order_'))); update_post_meta($order_id, '_customer_user', absint($this->customer_id)); update_post_meta($order_id, '_order_currency', get_woocommerce_currency()); update_post_meta($order_id, '_prices_include_tax', get_option('woocommerce_prices_include_tax')); update_post_meta($order_id, '_customer_ip_address', isset($_SERVER['HTTP_X_FORWARDED_FOR']) ? $_SERVER['HTTP_X_FORWARDED_FOR'] : $_SERVER['REMOTE_ADDR']); update_post_meta($order_id, '_customer_user_agent', isset($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] : ''); // Let plugins add meta do_action('woocommerce_checkout_update_order_meta', $order_id, $this->posted); // Order status wp_set_object_terms($order_id, 'pending', 'shop_order_status'); return $order_id; }
function order_item_meta($values, $order) { global $wpdb; $currency_symbol = get_woocommerce_currency_symbol(); $product_id = $values['product_id']; $quantity = $values['quantity']; $booking = $values['booking']; $order_item_id = $order->order_item_id; $order_id = $order->order_id; $global_settings = json_decode(get_option('woocommerce_booking_global_settings')); $booking_settings = get_post_meta($product_id, 'woocommerce_booking_settings', true); if (isset($booking_settings['booking_fixed_block_enable']) && isset($booking_settings['booking_partial_payment_radio']) && is_plugin_active("bkap-deposits/deposits.php")) { if (isset($global_settings->enable_rounding) && $global_settings->enable_rounding == "on") { woocommerce_add_order_item_meta($order_item_id, book_t('book.item-partial-total'), $currency_symbol . round($values['booking'][0]['Total'] * $values['quantity']), true); woocommerce_add_order_item_meta($order_item_id, book_t('book.item-partial-deposit'), $currency_symbol . round($values['booking'][0]['Deposit'] * $values['quantity']), true); woocommerce_add_order_item_meta($order_item_id, book_t('book.item-partial-remaining'), $currency_symbol . round($values['booking'][0]['Remaining'] * $values['quantity']), true); } else { woocommerce_add_order_item_meta($order_item_id, book_t('book.item-partial-total'), $currency_symbol . $values['booking'][0]['Total'] * $values['quantity'], true); woocommerce_add_order_item_meta($order_item_id, book_t('book.item-partial-deposit'), $currency_symbol . $values['booking'][0]['Deposit'] * $values['quantity'], true); woocommerce_add_order_item_meta($order_item_id, book_t('book.item-partial-remaining'), $currency_symbol . $values['booking'][0]['Remaining'] * $values['quantity'], true); } } }
// Do the same kind of update for order_taxes - move to lines // Reverse with UPDATE `wpwc_postmeta` SET meta_key = '_order_taxes' WHERE meta_key = '_order_taxes_old' $order_tax_rows = $wpdb->get_results("\r\n\tSELECT * FROM {$wpdb->postmeta}\r\n\tWHERE meta_key = '_order_taxes'\r\n"); foreach ($order_tax_rows as $order_tax_row) { $order_taxes = (array) maybe_unserialize($order_tax_row->meta_value); if ($order_taxes) { foreach ($order_taxes as $order_tax) { if (!isset($order_tax['label']) || !isset($order_tax['cart_tax']) || !isset($order_tax['shipping_tax'])) { continue; } $item_id = woocommerce_add_order_item($order_tax_row->post_id, array('order_item_name' => $order_tax['label'], 'order_item_type' => 'tax')); // Add line item meta if ($item_id) { woocommerce_add_order_item_meta($item_id, 'compound', absint(isset($order_tax['compound']) ? $order_tax['compound'] : 0)); woocommerce_add_order_item_meta($item_id, 'tax_amount', woocommerce_clean($order_tax['cart_tax'])); woocommerce_add_order_item_meta($item_id, 'shipping_tax_amount', woocommerce_clean($order_tax['shipping_tax'])); } // Delete from DB (rename) $wpdb->query($wpdb->prepare("\r\n\t\t\t\tUPDATE {$wpdb->postmeta}\r\n\t\t\t\tSET meta_key = '_order_taxes_old'\r\n\t\t\t\tWHERE meta_key = '_order_taxes'\r\n\t\t\t\tAND post_id = %d\r\n\t\t\t", $order_tax_row->post_id)); unset($tax_amount); } } } // Grab the pre 2.0 Image options and use to populate the new image options settings, // cleaning up afterwards like nice people do foreach (array('catalog', 'single', 'thumbnail') as $value) { $old_settings = array_filter(array('width' => get_option('woocommerce_' . $value . '_image_width'), 'height' => get_option('woocommerce_' . $value . '_image_height'), 'crop' => get_option('woocommerce_' . $value . '_image_crop'))); if (!empty($old_settings) && update_option('shop_' . $value . '_image_size', $old_settings)) { delete_option('woocommerce_' . $value . '_image_width'); delete_option('woocommerce_' . $value . '_image_height'); delete_option('woocommerce_' . $value . '_image_crop');
/** * Add each subscription product's details to an order so that the state of the subscription persists even when a product is changed * * @since 1.2.5 */ public static function add_order_item_meta($item_id, $values) { global $woocommerce; if (!WC_Subscriptions_Cart::cart_contains_subscription_renewal('child') && WC_Subscriptions_Product::is_subscription($values['product_id'])) { $cart_item = $values['data']; $product_id = empty($values['variation_id']) ? $values['product_id'] : $values['variation_id']; // Add subscription details so order state persists even when a product is changed $period = isset($cart_item->subscription_period) ? $cart_item->subscription_period : WC_Subscriptions_Product::get_period($product_id); $interval = isset($cart_item->subscription_period_interval) ? $cart_item->subscription_period_interval : WC_Subscriptions_Product::get_interval($product_id); $length = isset($cart_item->subscription_length) ? $cart_item->subscription_length : WC_Subscriptions_Product::get_length($product_id); $trial_length = isset($cart_item->subscription_trial_length) ? $cart_item->subscription_trial_length : WC_Subscriptions_Product::get_trial_length($product_id); $trial_period = isset($cart_item->subscription_trial_period) ? $cart_item->subscription_trial_period : WC_Subscriptions_Product::get_trial_period($product_id); $sign_up_fee = isset($cart_item->subscription_sign_up_fee) ? $cart_item->subscription_sign_up_fee : WC_Subscriptions_Product::get_sign_up_fee($product_id); woocommerce_add_order_item_meta($item_id, '_subscription_period', $period); woocommerce_add_order_item_meta($item_id, '_subscription_interval', $interval); woocommerce_add_order_item_meta($item_id, '_subscription_length', $length); woocommerce_add_order_item_meta($item_id, '_subscription_trial_length', $trial_length); woocommerce_add_order_item_meta($item_id, '_subscription_trial_period', $trial_period); woocommerce_add_order_item_meta($item_id, '_subscription_recurring_amount', $woocommerce->cart->base_recurring_prices[$product_id]); // WC_Subscriptions_Product::get_price() would return a price without filters applied woocommerce_add_order_item_meta($item_id, '_subscription_sign_up_fee', $sign_up_fee); // Calculated recurring amounts for the item woocommerce_add_order_item_meta($item_id, '_recurring_line_total', $woocommerce->cart->recurring_cart_contents[$values['product_id']]['recurring_line_total']); woocommerce_add_order_item_meta($item_id, '_recurring_line_tax', $woocommerce->cart->recurring_cart_contents[$values['product_id']]['recurring_line_tax']); woocommerce_add_order_item_meta($item_id, '_recurring_line_subtotal', $woocommerce->cart->recurring_cart_contents[$values['product_id']]['recurring_line_subtotal']); woocommerce_add_order_item_meta($item_id, '_recurring_line_subtotal_tax', $woocommerce->cart->recurring_cart_contents[$values['product_id']]['recurring_line_subtotal_tax']); // Add recurring line tax data (for WC 2.2+) $raw_tax_data = $woocommerce->cart->recurring_cart_contents[$values['product_id']]['recurring_line_tax_data']; $recurring_tax_data = array(); $recurring_tax_data['total'] = array_map('wc_format_decimal', $raw_tax_data['total']); $recurring_tax_data['subtotal'] = array_map('wc_format_decimal', $raw_tax_data['subtotal']); woocommerce_add_order_item_meta($item_id, '_recurring_line_tax_data', $recurring_tax_data); } }