Customers must confirm a contract for each order when purchasing products. Customers cannot purchase the product without confirming this agreement.
I created a checkbox for this on the checkout page. After customers confirm this, they buy the product. I save the approved contracts to the database. I can find it with the order number. So far, no problem.
On the My Account page, I created a new section (eg orders): Contracts. From here, every customer can access the contracts. However, I cannot access the contracts from this section that I have created. Because I can't get the order id.
Can I reach the order number with the current user id? I couldn't find any results for this. Or is there a different way?
<?php
class WooContractMyAccount
{
private $MyAccountContractsEndPoint = 'registered-contracts ';
public function __construct()
{
add_filter('woocommerce_account_menu_items', array($this, 'MyAccountRegistredContracts'), 10, 1);
add_action('woocommerce_account_' . $this->MyAccountContractsEndPoint . '_endpoint', array($this, 'MyAccountRegistredContractsEndPoint'), 10, 1);
add_action('init', array($this, 'WooContractInit'));
}
public function MyAccountRegistredContracts($items)
{
$items = array($this->MyAccountContractsEndPoint => __('Registered Contracts')) $items;
return $items;
}
public function WooContractInit()
{
add_rewrite_endpoint($this->MyAccountContractsEndPoint, EP_ROOT | EP_PAGES);
}
}
public function MyAccountRegistredContractsEndPoint()
{
global $wpdb;
$table = $wpdb->prefix . 'registered_contracts';
$table_contracts = $wpdb->prefix . 'contracts';
////The problem is here! ($contracts)
$contracts = $wpdb->get_results($wpdb->prepare("SELECT contracts.name,registeredcontracts.date,registeredcontracts.file FROM $table registeredcontracts
left join $table_contracts contracts ON contracts.id=registeredcontracts.contracts WHERE ref = %d", _______order id must be written_______));
?><div class="woocommerce-MyAccount-content">
<?php if (count($contracts) > 0) : ?>
<table class="woocommerce-orders-table woocommerce-MyAccount-orders shop_table shop_table_responsive my_account_orders account-orders-table">
<thead>
<tr>
<th class="woocommerce-orders-table__header">
<?php _e('Contract') ?>
</th>
<th class="woocommerce-orders-table__header">
<?php _e('Date') ?>
</th>
<th class="woocommerce-orders-table__header">
<?php _e('File') ?>
</th>
</tr>
</thead>
<tbody>
<?php foreach ($contracts as $contract) : ?>
<tr>
<td><?php _e($contract->name); ?></td>
<td><?php echo $contract->date; ?></td>
<td><a href="<?php echo CONTRACT_URL . '/' . $contract->file; ?>" target="_blank" class="woocommerce-button button"><?php _e('Download Contract'); ?></a></td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
<?php else : ?>
<p><?php _e('You do not have a registered contract. ') ?></p>
<?php endif; ?>
</div>
<?php
}
CodePudding user response:
For questions like this it can be useful to see how it is applied by default in WooCommerce, and base your answer on that
In /includes/wc-template-functions.php on line 3157 - 3186 @version 2.5.0 we find the following:
if ( ! function_exists( 'woocommerce_account_orders' ) ) {
/**
* My Account > Orders template.
*
* @param int $current_page Current page number.
*/
function woocommerce_account_orders( $current_page ) {
$current_page = empty( $current_page ) ? 1 : absint( $current_page );
$customer_orders = wc_get_orders(
apply_filters(
'woocommerce_my_account_my_orders_query',
array(
'customer' => get_current_user_id(),
'page' => $current_page,
'paginate' => true,
)
)
);
wc_get_template(
'myaccount/orders.php',
array(
'current_page' => absint( $current_page ),
'customer_orders' => $customer_orders,
'has_orders' => 0 < $customer_orders->total,
)
);
}
}
As you can see, wc_get_orders() and get_current_user_id() is used to get the orders for the current customer.
Then the results ($customer_orders
) are passed to the myaccount/orders.php template file.
In the template file, a foreach
is then used to display the orders and the necessary/desired details
<?php
foreach ( $customer_orders->orders as $customer_order ) {
$order = wc_get_order( $customer_order ); // phpcs:ignore WordPress.WP.GlobalVariablesOverride.Prohibited
// Get order ID
$order_id = $order->get_id();
So to answer your question "Can I reach the order number with the current user id?", yes this is possible and is indeed the right way to proceed