Code:

/** @var CategoriesItem $category */
$category = $application->recallObject('c', null, array('skip_autoload' => true));
$category->Clear();

// Set date from virtual.
$category->SetDBFieldsFromHash(array(
	'CreatedOn_date' => 1732023005,
	'CreatedOn_time' => 1732023005,
));
$category->UpdateFormattersMasterFields();
$test_result = $category->GetDBField('CreatedOn') == 1732023005 && $category->GetDBField('CreatedOn_date') == 1732023005 && $category->GetDBField('CreatedOn_time') == 1732023005;
echo 'Test 1: ' . ($test_result ? 'OK' : 'FAILED') . '<br/>' . PHP_EOL;

// Clear date from virtual.
$category->SetDBFieldsFromHash(array(
	'CreatedOn_date' => null,
	'CreatedOn_time' => null,
));
$category->UpdateFormattersMasterFields();
$test_result = $category->GetDBField('CreatedOn') === null && $category->GetDBField('CreatedOn_date') === null && $category->GetDBField('CreatedOn_time') === null;
echo 'Test 2: ' . ($test_result ? 'OK' : 'FAILED') . '<br/>' . PHP_EOL;

// Set date from combined.
$category->SetDBFieldsFromHash(array(
	'CreatedOn' => 1732023005,
	'CreatedOn_date' => 123,
	'CreatedOn_time' => 123,
	'CreatedOn_combined' => 1,
));
$category->UpdateFormattersMasterFields();
$test_result = $category->GetDBField('CreatedOn') == 1732023005 && $category->GetDBField('CreatedOn_date') == 123 && $category->GetDBField('CreatedOn_time') == 123;
echo 'Test 3: ' . ($test_result ? 'OK' : 'FAILED') . '<br/>' . PHP_EOL;

// Clear date from combined.
$category->SetDBFieldsFromHash(array(
	'CreatedOn' => null,
	'CreatedOn_date' => 456,
	'CreatedOn_time' => 456,
	'CreatedOn_combined' => 1,
));
$category->UpdateFormattersMasterFields();
$test_result = $category->GetDBField('CreatedOn') === null && $category->GetDBField('CreatedOn_date') == 456 && $category->GetDBField('CreatedOn_time') == 456;
echo 'Test 4: ' . ($test_result ? 'OK' : 'FAILED') . '<br/>' . PHP_EOL;

// Set date directly.
$category->SetDBFieldsFromHash(array(
	'CreatedOn' => 1732023005,
));
$category->UpdateFormattersSubFields(array('CreatedOn'));
$test_result = $category->GetDBField('CreatedOn') == 1732023005 && $category->GetDBField('CreatedOn_date') == 1732023005 && $category->GetDBField('CreatedOn_time') == 1732023005;
echo 'Test 5: ' . ($test_result ? 'OK' : 'FAILED') . '<br/>' . PHP_EOL;

// Clear date directly.
$category->SetDBFieldsFromHash(array(
	'CreatedOn' => null,
));
$category->UpdateFormattersSubFields(array('CreatedOn'));
$test_result = $category->GetDBField('CreatedOn') === null && $category->GetDBField('CreatedOn_date') === null && $category->GetDBField('CreatedOn_time') === null;
echo 'Test 6: ' . ($test_result ? 'OK' : 'FAILED') . '<br/>' . PHP_EOL;

Part 1

1. in the IDE replace the $application->Run(); line in the /index.php with the above-shown code and save changes
2. open the /index.php in the Web Browser
3. confirm, that all tests pass

Part 2 - e-mail log

1. login to Admin Console
2. go to the Logs & Reports → E-mail Log section
3. delete all the records in that grid
4. go to the User Management → Mailings section
5. switch to the Email Queue tab
6. delete all the records in that grid
7. go to the User Management → Users section
8. create a user in the Active status
9. use the Decline toolbar button on the above-created user
10. go to the User Management → Mailings section
11. switch to the Email Queue tab
12. confirm, that 1 record, representing the USER.DENY e-mail, is shown in the grid
13. press the Process Queue toolbar button
14. confirm, that no records are shown in the grid
15. go to the Logs & Reports → E-mail Log section
16. confirm, that 1 record representing the USER.DENY e-mail, is shown in the grid AND that record has a non-empty value in the Sent On column

Part 3 - orders

• go to Admin Console
  1. go to the Website & Content → Structure & Data → Products section
  2. switch to the Products tab
  3. add a new tangible product with Price=$10.00 and Status=Active
  4. go to the Configuration → E-commerce → Shipping section
  5. add new custom shipping, that will:
     • on the General tab: have ShippingType=handling,BaseFee=5
     • on the Shipping Zones tab: use single zone to cover for all countries
     • on the Brackets tab: have single infinity bracket
  6. go to the Configuration → E-commerce → Payment Types section
  7. set the Check/MO payment type as primary
• go to Front-End
  1. place an order using the above-created product/shipping type and primary payment type (use any fake address for testing)
• go to Admin Console
  1. go to the E-commerce → Orders section
  2. switch to the Pending tab
  3. select the sales order, that was just submitted on the Front-End
  4. press the Approve toolbar button
  5. switch to the To Ship tab
  6. select the sales order, that was just approved
  7. press the Ship toolbar button
  8. switch to the Processed tab
  9. open the sales order, that was just shipped for editing
  10. go to the Shipping tab
  11. confirm, that the Shipping Date/Time is populated
  12. close the editing window
  13. select the sales order, that was just shipped
  14. press the Clone toolbar button
  15. switch to the Incomplete tab
  16. open the sales order, that was just cloned for editing
  17. go to the Shipping tab
  18. confirm, that the Shipping Date/Time is empty

Part 4 - session logging

1. login to Admin Console
2. go to the Configuration → Website → Advanced section
3. enable the Track database changes to change log system setting
4. save changes
5. re-login to the Admin Console for Active session log record to be created
6. re-login to the Admin Console for the above-created session log record to be marked as Logged Out
7. go to the Logs & Reports → Session Log section
8. confirm, that above made re-login actions caused a Logged Out session log record to be created with both Session Start and Session End dates to be populated