how to get order date in Hook?

[hogava]

hi,

This Hook runing when we accept order, Now I need to get order date from tblorders table (database) when i accept order, How can i do it?

<?php
add_hook('AcceptOrder', 1, function($vars) {
    // Perform hook code here...
});

thanks

[Kian]

AcceptOrder returns the ID of the order that you can use to retreive the date like follows.

<?php

use WHMCS\Database\Capsule;

add_hook('AcceptOrder', 1, function($vars)
{
	$OrderDate = Capsule::table('tblorders')->where('id', $vars['orderid'])->value('date');
});

 

[hogava]

please help about insert new value to order & show value in WHMCS admin panel.

[Kian]

Insert what and where?

p.s. Interacting with the Database