⌛ 🔗 Add WooCommerce Shop Order as query source for the Loop Grid (Duplicate)

[manthankanani]

Prerequisites

• I have searched for similar feature requests in both open and closed discussions and cannot find an existing request.
• I have verified that the feature is still missing from the latest stable versions of Elementor or Elementor Pro.

What problem is your feature request going to solve? Please describe..

In my previous project client don't want my-account page. and he wanted only one order-list page only. So we needed to create custom signin, signup, forgot password, reset password, redirections method and all.
We can resolve it by multiple way.

with custom loop grid there is no option for shop_order in CPT widget selection.
If you choose query_id method then again your selection is wrong because in newer WooCommerce stores order data in new table and native method of post_storage is almost deprecated so query_id method will no longer work.

Describe the solution you'd like.

1. By creating any page with my-order slug
2. put loop-grid
3. Right now there is no option for shop_order but there is only option for Post, Taxonomy, Product and Product Taxonomy
4. If there is a any option like shop_order then we can make the page as we required.
5. One more thing is alternatively we can redirect my-account page to my-order and that's it.
6. I know the redirecting is not best use case but woo commerce allow us to create endpoint for all their page.
7. we can use it and make everything we need.
8. same way we can create custom shop_order page as we required as well.
9. For login and signup I've created custom action_after_submit like authentication. but new feature is appreciated

Describe alternatives you've considered.

alternatively i've used this following structure as given below

add_action( 'elementor/query/wc_orders', '__wc_orders' );
function __wc_orders($query){
        $query->set('query_type', 'my_query');
        $query->set('query_result', 'wc_orders');
        $query->set('post_type', 'shop_order');
        $query->set('post_status', 'any');
        $query->set('meta_key', '_customer_user');
        $query->set('meta_value', get_current_user_id());
	return $query;
    }

The above code has some limitations, when the orders are not synced then complete data would not provide.
because at that time the post type will stay like "shop_order_placehold" and order status sale like draft.
So i've enabled woocommerce legacy order storage feature and doing with it is not good idea.

on the order side how i'm modifying the required data is

add_filter( 'the_posts',  'wc_orders', 10, 2 );
function wc_orders($posts, $query){
        if($query->get('query_type') == 'my_query' && $query->get('query_result') == 'wc_orders') {
            $newPost = [];
            foreach($posts as $p){
                      $order = wc_get_order($p->ID);
                      $p->order = $order;
                      $order_data = $order->get_data();
                      $p->order_data = $order_data;
                      $newPost[] = $p;
             }
             return $newPost;
        }
        return $posts;
}

for custom login from directly from the form I'm using the following action base

add_action( 'elementor_pro/forms/actions/register', '__register_actions' );
function __register_actions($form_actions_registrar){
          $form_actions_registrar->register(new Elementor_Authentication());
}

// disabling recaptcha verification from wordfence
add_filter( 'wordfence_ls_require_captcha', 'disable_wordfence_recaptcha' );
function disable_wordfence_recaptcha( $enabled ) {
	if((isset($_REQUEST['action']) && $_REQUEST['action'] === 'elementor_pro_forms_send_form') || (is_checkout() && !is_user_logged_in())) {
		return false; 
	}
	return $enabled;
}

class Elementor_Authentication extends Action_Base {

	public function get_name() {
		return 'authentication';
	}

        public function get_label() {
		return esc_html__( 'Authentication', 'elementor-pro' );
	}

	public function register_settings_section( $widget ) {

		$widget->start_controls_section(
			'section_authentication',
			[
				'label' => esc_html__( 'Authentication', 'elementor-pro' ),
				'condition' => [
					'submit_actions' => $this->get_name(),
				],
			]
		);

                $widget->add_control(
			'auth_method',
			[
				'label' => esc_html__( 'Authentication Type', 'elementor-pro' ),
				'type' => \Elementor\Controls_Manager::SELECT,
				'options' => [
					'no' 				=> esc_html__( 'Do Nothing', 'elementor-pro' ),
					'signin' 			=> esc_html__( 'Signin', 'elementor-pro' ),
					'signup' 			=> esc_html__( 'Signup', 'elementor-pro' ),
					'reset-password' 	=> esc_html__( 'Reset Password', 'elementor-pro' ),
					'update-password' 	=> esc_html__( 'Update Password', 'elementor-pro' ),
				],
				'default' => 'no',
			]
		);

		$widget->add_control(
			'role_type',
			[
				'label' => esc_html__( 'Role Type', 'elementor-pro' ),
				'type' => Controls_Manager::SELECT,
				'options' => self::controls_options('role'),
				'condition' => [
					'auth_method' => 'signup',
				]
			]
		);
		
		$widget->add_control(
			'email_field',
			[
				'label' => esc_html__( 'Email Field', 'elementor-pro' ),
				'type' => Controls_Manager::TEXT,
				'ai' => [
					'active' => false,
				],
				'render_type' => 'none',
				'dynamic' => [
					'active' => true,
				],
				'conditions' => [
					'terms' => [
						[
							'name' => 'auth_method',
							'operator' => 'in',
							'value' => [
								'signup',
								'signin',
								'reset-password',
							],
						],
					],
				],
			]
		);

		$widget->add_control(
			'password_field',
			[
				'label' => esc_html__( 'Password Field', 'elementor-pro' ),
				'type' => Controls_Manager::TEXT,
				'ai' => [
					'active' => false,
				],
				'render_type' => 'none',
				'dynamic' => [
					'active' => true,
				],
				'conditions' => [
					'terms' => [
						[
							'name' => 'auth_method',
							'operator' => 'in',
							'value' => [
								'signup',
								'signin',
								'update-password'
							],
						],
					],
				],
			]
		);

		$widget->add_control(
			'fullname_field',
			[
				'label' => esc_html__( 'Fullname Field', 'elementor-pro' ),
				'type' => Controls_Manager::TEXT,
				'ai' => [
					'active' => false,
				],
				'render_type' => 'none',
				'dynamic' => [
					'active' => true,
				],
				'condition' => [
					'auth_method' => 'signup',
				]
			]
		);

		$widget->add_control(
			'lost_password_link_field',
			[
				'label' => esc_html__( 'Reset Password Link', 'elementor-pro' ),
				'type' => Controls_Manager::URL,
				'ai' => [
					'active' => false,
				],
				'render_type' => 'none',
				'dynamic' => [
					'active' => true,
				],
				'condition' => [
					'auth_method' => 'reset-password',
				]
			]
		);

		$widget->add_control(
			'confirm_password_field',
			[
				'label' => esc_html__( 'Confirm Password Field', 'elementor-pro' ),
				'type' => Controls_Manager::TEXT,
				'ai' => [
					'active' => false,
				],
				'render_type' => 'none',
				'dynamic' => [
					'active' => true,
				],
				'condition' => [
					'auth_method' => 'update-password',
				]
			]
		);

		$widget->add_control(
			'reset_key_field',
			[
				'label' => esc_html__( 'Reset Key Field', 'elementor-pro' ),
				'type' => Controls_Manager::TEXT,
				'ai' => [
					'active' => false,
				],
				'render_type' => 'none',
				'dynamic' => [
					'active' => true,
				],
				'condition' => [
					'auth_method' => 'update-password',
				]
			]
		);

		$widget->add_control(
			'reset_login_field',
			[
				'label' => esc_html__( 'Reset Login Field', 'elementor-pro' ),
				'type' => Controls_Manager::TEXT,
				'ai' => [
					'active' => false,
				],
				'render_type' => 'none',
				'dynamic' => [
					'active' => true,
				],
				'condition' => [
					'auth_method' => 'update-password',
				]
			]
		);

		$widget->end_controls_section();
	}

	public function controls_options($type){
		if(!function_exists('get_editable_roles')) {
			require_once ABSPATH . 'wp-admin/includes/user.php';
		}
		$editable_roles = get_editable_roles();

		$resultArray = [];
		foreach ($editable_roles as $role => $details) {
			$role_id = esc_attr($role);
			$role_name = translate_user_role($details['name']);
			$resultArray[$role_id] = $role_name;
		}
		return $resultArray;
	}

	public function on_export( $element ) {
		unset(
			$element['auth_method'],
			$element['role_type'],
			$element['email_field'],
			$element['password_field'],
			$element['fullname_field'],
			$element['lost_password_link_field'],
			$element['confirm_password_field'],
			$element['reset_key_field'],
			$element['reset_login_field'],
		);

		return $element;
	}

	public function run( $record, $ajax_handler ) {
		$settings = $record->get( 'form_settings' );

		$fields = [
			'auth_method' 				=> 'no',
			'role_type' 				=> 'subscriber',
			'fullname_field'			=> '',
			'email_field' 				=> '',
			'password_field' 			=> '',
			'confirm_password_field' 	=> '',
			'reset_key_field' 			=> '',
			'reset_login_field' 		=> '',
		];
		foreach ( $fields as $key => $default ) {
			$setting = trim( $settings[ $key ] );
			$setting = $record->replace_setting_shortcodes( $setting );
			if ( ! empty( $setting ) ) {
				$fields[ $key ] = $setting;
			}
		}

		if(empty($fields['auth_method']) || $fields['auth_method'] == "no") {
			return;
		}

		if(in_array($fields['auth_method'], ['signin', 'signup', 'reset-password'])){
			if(empty($fields['email_field']) || !is_email($fields['email_field'])) {
				$message = "Enter a valid email address";
				$ajax_handler->add_error_message($message);
				throw new \Exception( $message );
			}
		}

		if(in_array($fields['auth_method'], ['signin', 'signup'])){
			$pass_strength = strlen($fields['password_field']);
			if($pass_strength > 72 || $pass_strength < 8){
				$message = "Enter a valid password";
				$ajax_handler->add_error_message($message);
				throw new \Exception( $message );
			}
		}

		if($fields['auth_method'] == 'signin'){
			$creds = array(
				'user_login'    => $fields['email_field'],
				'user_password' => $fields['password_field'],
				'remember'      => true
			);
			$user = wp_signon( $creds, false );
			if(is_wp_error($user)) {
				$message = $user->get_error_message();
				$ajax_handler->add_error_message($message);
				throw new \Exception( $message );
			}
		} elseif($fields['auth_method'] == 'signup'){
			if(empty($fields['fullname_field'])){
				$message = "Enter a valid Fullname";
				$ajax_handler->add_error_message($message);
				throw new \Exception( $message );
			}
			
			$name_parts = explode(' ', $fields['fullname_field']);
			$first_name = isset($name_parts[0]) ? $name_parts[0] : '';
        	$last_name = isset($name_parts[1]) ? $name_parts[1] : '';

			$username = sanitize_user(current(explode('@', $fields['email_field'])));

			$suffix = 1;
			$original_username = $username;
			while (username_exists($username)) {
				$username = $original_username . $suffix;
				$suffix++;
			}

			$user_id = wp_create_user($username, $fields['password_field'], $fields['email_field']);
			if (is_wp_error($user_id)) {
				$message = $user_id->get_error_message();
				$ajax_handler->add_error_message($message);
				throw new \Exception( $message );
			}
			
			$user = new WP_User($user_id);
			$user->set_role($fields['role_type']);

			wp_update_user([
				'ID' => $user_id,
				'first_name' => $first_name,
				'last_name' => $last_name,
			]);

			wp_set_current_user($user_id);
			wp_set_auth_cookie($user_id);
			do_action('wp_login', $username, get_userdata($user_id));
		} elseif($fields['auth_method'] == 'reset-password'){
			$lost_password_base_url = $settings["lost_password_link_field"]["url"] ?? site_url();

			$email = $fields['email_field'];
			$user = get_user_by('email', $email);

			if($user){
				$reset_key = get_password_reset_key($user);
				if (is_wp_error($reset_key)) {
					$message = "Something went wrong while generating reset key";
					$ajax_handler->add_error_message($message);
					throw new \Exception( $message );
				} else {
					$to = $user->user_email;
					$subject = 'Reset Password Link';
					$from = 'Your Store Name <noreply@storename.com>';
					$reset_link = add_query_arg(array(
						"action" => "rf",
						"key" => $reset_key,
						"login" => rawurlencode($user->user_login)
					), $lost_password_base_url);
					$content = 'Dear "'.$email.'", <br /><br />
       					We have received a request to reset your password. If you did not make this request, you can safely ignore this message. <br /><br />
       					For Accessing your account - Please reset your password by clicking on the below link: <br />
						<a href="'.$reset_link.'" style="color: #D4AB4C; font-weight: 600;">here</a>.';
	
					// wp_email($to, $subject, $content,  'From: '.$from);
				}
			} else {
				// If you're registered user, you will receive an email on your inbox, reset your password before it expires
			}
		} elseif($fields['auth_method'] == 'update-password'){
			if($fields['password_field'] !== $fields['confirm_password_field']){
				$message = "Password doesn't match";
				$ajax_handler->add_error_message($message);
				throw new \Exception( $message );
			}
			if(empty($fields['reset_key_field'])){
				$message = "Invalid request";
				$ajax_handler->add_error_message($message);
				throw new \Exception( $message );
			}
			if(empty($fields['reset_login_field'])){
				$message = "Invalid request";
				$ajax_handler->add_error_message($message);
				throw new \Exception( $message );
			}

			$user = check_password_reset_key($fields['reset_key_field'], $fields['reset_login_field']);
			if (is_wp_error($user)) {
				$message = "Invalid request";
				$ajax_handler->add_error_message($message);
				throw new \Exception( $message );
			} else {
				wp_set_password($fields['password_field'], $user->ID);
			}
		}
	}
}

Additional context

Right now elementor is providing template selection only for dashboard screen but alternatively we can provide it for all my-account endpoint.
Feature List:-

1. Order is also a custom post type, so add it in page creation as well
2. Order single page is also requirement
3. Woocommerce custom endpoint is also a best option so by using it we can create custom template not only for dashboard but all of the menus are falling under my-account (Order list, order single page, download section, address selection, account detail modification)
4. separate login, signup page or custom template for auth module of woocommerce too.

Agreement

• I agree that my request may be closed without action if it doesn't meet all the requirements.