{"id":2462,"date":"2023-10-18T19:32:55","date_gmt":"2023-10-18T18:32:55","guid":{"rendered":"https:\/\/organicfarmer.store\/?page_id=2462"},"modified":"2023-10-18T19:34:11","modified_gmt":"2023-10-18T18:34:11","slug":"track","status":"publish","type":"page","link":"https:\/\/organicfarmer.store\/index.php\/track\/","title":{"rendered":"track"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"2462\" class=\"elementor elementor-2462\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e7be805 e-flex e-con-boxed e-con e-parent\" data-id=\"e7be805\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1b49349 elementor-widget elementor-widget-shortcode\" data-id=\"1b49349\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\">add_filter('woocommerce_shortcode_order_tracking_form', 'customize_order_tracking_form');\n\nfunction customize_order_tracking_form($output) {\n    \/\/ Check if the order ID is submitted by the user\n    if (isset($_POST['order_id']) && !empty($_POST['order_id'])) {\n        \/\/ Sanitize and retrieve the order ID entered by the customer\n        $order_id = absint($_POST['order_id']);\n\n        global $wpdb;\n\n        \/\/ Retrieve the tracking URL from the wp_woocommerce_order_itemmeta table\n        $tracking_url = $wpdb->get_var($wpdb->prepare(\n            \"SELECT meta_value FROM {$wpdb->prefix}woocommerce_order_itemmeta WHERE meta_key = 'tracking_url' AND order_item_id IN (SELECT order_item_id FROM {$wpdb->prefix}woocommerce_order_items WHERE order_id = %d)\",\n            $order_id\n        ));\n\n        if ($tracking_url) {\n            \/\/ Modify the output to display the tracking URL\n            $output .= '<p><strong>Tracking URL:<\/strong> <a href=\"' . esc_url($tracking_url) . '\" target=\"_blank\">' . esc_url($tracking_url) . '<\/a><\/p>';\n        }\n    } else {\n        \/\/ Display the order tracking form with an input field for the order ID\n        $output .= '<form method=\"post\">';\n        $output .= '<label for=\"order_id\">Enter Order ID:<\/label>';\n        $output .= '<input type=\"text\" name=\"order_id\" id=\"order_id\" \/>';\n        $output .= '<input type=\"submit\" value=\"Track Order\" \/>';\n        $output .= '<\/form>';\n    }\n\n    return $output;\n}\n<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>add_filter(&#8216;woocommerce_shortcode_order_tracking_form&#8217;, &#8216;customize_order_tracking_form&#8217;); function customize_order_tracking_form($output) { \/\/ Check if the order ID is submitted by the user if (isset($_POST[&#8216;order_id&#8217;]) &#038;&#038; !empty($_POST[&#8216;order_id&#8217;])) { \/\/ Sanitize and retrieve the order ID entered by the customer $order_id = absint($_POST[&#8216;order_id&#8217;]); global $wpdb; \/\/ Retrieve the tracking URL from the wp_woocommerce_order_itemmeta table $tracking_url = $wpdb->get_var($wpdb->prepare( &#8220;SELECT meta_value FROM {$wpdb->prefix}woocommerce_order_itemmeta WHERE meta_key [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","ast-site-content-layout":"full-width-container","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-2462","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/organicfarmer.store\/index.php\/wp-json\/wp\/v2\/pages\/2462","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/organicfarmer.store\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/organicfarmer.store\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/organicfarmer.store\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/organicfarmer.store\/index.php\/wp-json\/wp\/v2\/comments?post=2462"}],"version-history":[{"count":0,"href":"https:\/\/organicfarmer.store\/index.php\/wp-json\/wp\/v2\/pages\/2462\/revisions"}],"wp:attachment":[{"href":"https:\/\/organicfarmer.store\/index.php\/wp-json\/wp\/v2\/media?parent=2462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}