Files
opensourcepos/tests/Controllers/CashupControllerTest.php
objecttothisandClaude Sonnet 5 af48fa4357 fix(tests): standardize DB bootstrap/OSPOS mocking, fix stale-prefix bug (#4771)
Adds DatabaseBootstrapTrait and OsposConfigFixtureTrait to replace
duplicated per-file setUp()/tearDown() bootstrap and OSPOS config mock
boilerplate across test classes, bringing them in line with the
ItemsControllerTest gold-standard shape.

Fixes the real root cause of tabular_helperTest's suite-order-dependent
failure: dropAllForeignKeyConstraints()/foreignKeyExists()/
dropColumnIfExists() temporarily blank the shared connection's DBPrefix
via overridePrefix() but never restored it if the query between the two
calls threw (e.g. migration_helperTest's mocked-failure tests) -
permanently corrupting prefixed table lookups for the rest of the
process. Wrapped each in try/finally. Also widens executeScript() to
accept an explicit connection so migration SQL can't silently run
against the wrong DB group.

Co-authored-by: Claude Sonnet 5 <noreply@anthropic.com>
2026-10-23 10:10:37 +04:00

132 lines
4.4 KiB
PHP

<?php
namespace Tests\Controllers;
use App\Models\Cashup;
use CodeIgniter\Test\CIUnitTestCase;
use CodeIgniter\Test\DatabaseTestTrait;
use CodeIgniter\Test\FeatureTestTrait;
use Tests\Support\DatabaseBootstrapTrait;
use Tests\Support\EmployeeFixtureTrait;
use Tests\Support\OsposConfigFixtureTrait;
class CashupControllerTest extends CIUnitTestCase
{
use DatabaseTestTrait;
use DatabaseBootstrapTrait;
use FeatureTestTrait;
use EmployeeFixtureTrait;
use OsposConfigFixtureTrait;
protected $migrate = true;
protected $migrateOnce = true;
protected $seedOnce = true;
protected $refresh = false;
protected $namespace = null;
protected function setUp(): void
{
$this->resetDatabaseOnce();
parent::setUp();
$this->injectOsposSettings([
'company' => 'Test Co',
'dateformat' => 'Y-m-d',
'timeformat' => 'H:i:s',
'number_locale' => 'en_US',
'currency_decimals' => 2,
'thousands_separator' => ',',
]);
}
protected function tearDown(): void
{
parent::tearDown();
}
protected function createCashupEmployee(): int
{
return $this->createEmployee(
first_name: 'Cashier',
last_name: 'Cashup',
email: 'cashup.' . uniqid() . '@test.com',
username: 'cashup_' . uniqid(),
grants: [
['permission_id' => 'cashups', 'menu_group' => 'home'],
],
);
}
protected function loginAs(int $personId): void
{
$this->withSession([
'person_id' => $personId,
'menu_group' => 'home',
]);
}
public function testTamperedTotalIsRecomputedServerSide(): void
{
$cashierId = $this->createCashupEmployee();
$this->loginAs($cashierId);
// Component amounts only sum to (50 - 0 - 0 + 10 + 0 + 0) = 60, but the
// client claims a total of 1000.00. The server must store 60, not 1000.
$response = $this->post('/cashups/save/-1', [
'open_date' => '2026-09-05 08:00:00',
'close_date' => '2026-09-05 16:00:00',
'open_amount_cash' => '0',
'transfer_amount_cash' => '0',
'closed_amount_cash' => '50',
'closed_amount_due' => '10',
'closed_amount_card' => '0',
'closed_amount_check' => '0',
'closed_amount_total' => '1000.00',
'open_employee_id' => '999999',
'close_employee_id' => '999999',
'description' => 'Test cashup - tampered total',
]);
$response->assertStatus(200);
$result = json_decode($response->getJSON(), true);
$this->assertTrue($result['success']);
$cashup = model(Cashup::class)->get_info($result['id']);
$this->assertEquals(60.0, (float) $cashup->closed_amount_total);
}
public function testConsistentTotalIsStoredAndOwnerIsForcedToAuthenticatedUser(): void
{
$cashierId = $this->createCashupEmployee();
$this->loginAs($cashierId);
// 100 - 20 - 5 + 15 + 40 + 25 = 155. The client also tries to attribute
// the cashup to other employees (777/888); the server must force the
// authenticated user's person_id.
$response = $this->post('/cashups/save/-1', [
'open_date' => '2026-09-05 08:00:00',
'close_date' => '2026-09-05 16:00:00',
'open_amount_cash' => '20',
'transfer_amount_cash' => '5',
'closed_amount_cash' => '100',
'closed_amount_due' => '15',
'closed_amount_card' => '40',
'closed_amount_check' => '25',
'closed_amount_total' => '155',
'open_employee_id' => '777',
'close_employee_id' => '888',
'description' => 'Test cashup - consistent total',
]);
$response->assertStatus(200);
$result = json_decode($response->getJSON(), true);
$this->assertTrue($result['success']);
$cashup = model(Cashup::class)->get_info($result['id']);
$this->assertEquals(155.0, (float) $cashup->closed_amount_total);
$this->assertEquals($cashierId, (int) $cashup->open_employee_id);
$this->assertEquals($cashierId, (int) $cashup->close_employee_id);
}
}