mirror of
https://github.com/opensourcepos/opensourcepos.git
synced 2026-10-28 19:18:58 -04:00
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>
132 lines
4.4 KiB
PHP
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);
|
|
}
|
|
}
|