SQL Statement - Query a set of records with the most recent date

I'm writing a View in Oracle 9 database, and I'm stumped. What I'm trying to solve is this: A_WPD_ADDRESS_HISTORY contains a FK called WPD_PLAN_CHECK_S, and this view holds multiple addresses for...

How to Submit Form Given Specific Json Response

I'm new to Json, so please excuse the newb question. I have a form in which I'm conducting an Ajax post to submit address information to a backend script for validation. Here's the form: <form...

left join gives more results

I have this query: SELECT wc.city, wc.country_id, wc.latitude, wc.longitude FROM world_cities wc -- left join states s on wc.country_id = s.country_id where wc.city = 'rosemount' With that I...

How can I optimize this stored procedure?

I need some help optimizing this procedure: DELIMITER $$ CREATE DEFINER=`ryan`@`%` PROCEDURE `GetCitiesInRadius`( cityID numeric (15), `range` numeric (15) ) BEGIN DECLARE lat1 ...

Rails nested attributes not found / not permitted

I've been trying to enter nested attributes into my database but I can't manage to get it working. I have these parameters: def domain_register_whois_contact_parameters ...

Woocommerce select email address destination only for new order notification(admin) through form checkout it's possible?

Scenery: 1 store and 2 locations. I already have select field form (checkout) where the customer select which store is closest to your location, eg: city A or city B. Now I need that the new order...

Filtering JSON Data based on Min and Max Price

I'm not sure how to filter my JSON data according to price (specified in my JSON data - price) I have two drop down lists, one for min price and the other for max price. The data from my json...

export mysql query array using fputcsv

I am trying to export the results of a sql query to CSV using fputcsv however keep getting the error "fputcsv() expects parameter 2 to be array, string given". I followed the answer given here -...

Solution for AssertionError: invalid dtype determination in get_concat_dtype when concatenating operation on list of Dataframes

I have a list of Dataframes that I am attempting to combine using the concatenation function. dataframe_lists = [df1, df2, df3] result = pd.concat(dataframe_lists, keys = ['one', 'two','three'],...

Download .xls file containing hebrew text

I have data in hebrew in my database and want to export that data as excell file on button click using php in wordpress. On downloading and opening the file the hebrew text display like מפרץ...

Woocommerce - Conditionally fill some address fields

I wish to fill in some shipping address fields (like street, neighborhood and number) automatically after a selection. For example: If somebody selects "01 Store - São Paulo", it automatically...

when updating user email is blank in wordpress

Please can anyone help, When I update the user from word press admin section user email field is showing blank after the successfully update. I do not understand why this is happening. Please...

WooCommerce Shipping Calculator (shipping-calculator.php) - PHP Override - Zip Code Only

In need of some suggestions here. I'm attempting to edit my shipping calculator (not checkout calculator as based on...

How to get a list of shipping methods without a (filled)shopping cart

Is it possible to get a list of available shipping-methods based on only a total amount and/or country code? I quess it is possible by building my own SQL query, but I was wondering if it is also...

Remove country field woocommerce

Is any possibility to remove the country field from the checkoput page and add a city dropdown selector field. I'm using WC City Select plugin but it's not working. What should I do?

WooCommerce Country Selection on Registration

I'm currently trying to add the default country searcher from WooCommerce to the registration page, while a default list of countries is possible with the following code...

username auto-generated by billing complete name in WooCommerce registration

So I've added various custom fields to the registration page of my WooCommerce webshop as following: /* ---------------------- Registration page ----------------------- */ //Add extra fields in...

How to get all cart session from all customer woocommerce

i want get all session across customer. I try WC()->cart->get_cart(); but only return for current user cart. i try with get direct from database, but still return cart from current user. global...

How to output a variable string when a dropdown box value is selected

So I don't know if the title is worded correctly, but essentially what I'm trying to do is when something is selected in a drop-down, it runs a function that then selects its description and...

Sync additional Billing registration fields with default Wordpress fields in WooCommerce

I Have added the below codes into Woocommerce user registration form to get the Billing Details on the registration page. Now what is happening when a new user register, the first and last name...

Display shipping options conditionally in multiple packages

So I am using a plugin to create multiple packages for my products, as each class has different shipping options. e.g a belt is delivered by post and a washing machine is delivered by van I am...

Edit woocommerce shipping calculator

I have added custom cities to Woocommerce checkout and each city represents a rate. However, I would like to have a dropdown of cities in the shipping calculator as I have done with the checkout...

PHP Memory Limit on creation of CSV from db - How to reduce memory that PHP uses?

Am running a db query here, and using mysqli with MYSQLI_USE_RESULT in order to execute the query faster. But there is php manipulation of data needed here, so it's not as simple as just writing...

Wordpress woocommerce Perfect Money Payment Gateway Plugin

Hi Everyone this is an old woocommerce Perfect Money gateway source code Other Payment Gateway's Working Fine on My Website But When I Will Try Perfect Money am Getting...

Get the value of a custom checkout field in woocommerce 3

In Woocommerce checkout, I am adding a custom checkout field and here is my code: add_action( 'woocommerce_before_order_notes', 'shipping_add_select_checkout_field' ); function...

Woocommerce mySQL Query - List All Orders, Users and Purchased Items

I have a fully working mySQL query which pulls all of the orders, users, addresses and items purchased from Woocommerce, however it only lists the products individually, and I would like to add...

Add a custom Settings tab to Woocommerce Settings for Customer list content

I've managed to put this together even though I do not fully understand it all. The goal is to have a custom tab called "Customer List" and in that tab (WooCommerce Settings -> Customer List) show...

Trying to get shipping fields with a new custome field created

I am trying to get the array for all the shipping forms with a new custom element that I already added. This code is not working: $newObj = new WC_Checkout(); $shipping_fields =...

Restriction on city dropdown on checkout of woocommerce

down to the city checkout field on Woocommerce using the following code: function change_city_to_dropdown( $fields ) { include('citynames.php'); $city_args = wp_parse_args( 'citydelivery' ,...

How to add functionality so woocommerce orders are visible to a driver user-role in the same city?

I have a WordPress Woo-commerce store with the Pro version of the delivery drivers for woo-commerce plugin (https://wordpress.org/plugins/delivery-drivers-for-woocommerce/). Everything works fine...