📋 LIS Structural Refactor — Detailed Task List

A. ملخص الـ Code Inventory

A.1 Backend (10 controllers + 8 models + 3 services + 1 listener)

A.2 Frontend (5 screens + 6 services + 5 models)

B. Schema Changes (Migrations)

B.1 New Tables (2)

Migration M1: create_lab_sample_investigations_table

Schema::create('lab_sample_investigations', function (Blueprint $t) {
    $t->id();
    $t->foreignId('company_id')->constrained()->cascadeOnDelete();
    $t->foreignId('lab_sample_id')->constrained('lab_samples')->cascadeOnDelete();
    $t->foreignId('lab_investigation_id')->constrained('lab_investigations');
    $t->foreignId('lab_request_investigation_id')->nullable()
        ->constrained('lab_request_investigations')->nullOnDelete();
    $t->foreignId('lab_request_id')->constrained('lab_requests');  // denormalized
    $t->string('status', 30)->index();
    //   pending, collected, received, in_progress, result_entered, validated,
    //   released, printed, published, deferred, rejected, cancelled,
    //   outsourced, retracted
    $t->foreignId('lab_external_lab_id')->nullable()
        ->constrained('lab_external_labs')->nullOnDelete();
    $t->timestamp('external_send_at')->nullable();
    $t->timestamp('external_received_at')->nullable();
    $t->foreignId('assigned_to_user_id')->nullable()
        ->constrained('users')->nullOnDelete();
    $t->unsignedSmallInteger('retest_count')->default(0);
    $t->timestamps();
    $t->softDeletes();
    $t->unique(['lab_sample_id', 'lab_investigation_id', 'deleted_at'],
              'lab_sample_inv_unique');
    $t->index(['company_id', 'lab_request_id', 'status']);
    $t->index(['lab_investigation_id', 'status']);
});

Migration M2: create_lab_sample_investigation_logs_table

Schema::create('lab_sample_investigation_logs', function (Blueprint $t) {
    $t->id();
    $t->foreignId('company_id')->constrained();
    $t->foreignId('lab_sample_investigation_id')->nullable()
        ->constrained('lab_sample_investigations')->nullOnDelete();
    $t->foreignId('lab_sample_id')->constrained('lab_samples');
    $t->foreignId('lab_investigation_id')->constrained('lab_investigations');
    $t->string('action', 30);
    //   created, collected, received, started, result_entered, validated,
    //   released, printed, published, deferred, cancelled, outsourced,
    //   rejected, recollected, rerun, retracted, assigned, received_back
    $t->string('from_status', 30)->nullable();
    $t->string('to_status', 30)->nullable();
    $t->string('reason_code', 30)->nullable();
    $t->text('reason_text')->nullable();
    $t->text('result_value_before')->nullable();  // for rerun
    $t->json('meta')->nullable();
    $t->foreignId('user_id')->nullable()->constrained();
    $t->string('ip_address', 45)->nullable();
    $t->string('user_agent', 255)->nullable();
    $t->timestamp('created_at')->useCurrent();
    $t->index(['lab_sample_investigation_id', 'created_at']);
    $t->index(['lab_sample_id', 'created_at']);
    $t->index(['lab_investigation_id', 'created_at']);
});

B.2 ALTER existing tables (5)

B.3 Truncate Plan (Dev only — test data)

C. Backend Tasks (٢٢ task)

Phase 1: Schema + Models (BE-1 to BE-7)

Phase 2: Writers (BE-8 to BE-16)

Phase 3: Readers + Resources (BE-17 to BE-22)

D. Frontend Tasks (٢٤ task)

Phase 4.A: Models + Services (FE-1 to FE-6)

Phase 4.B: Collection Worklist (FE-7 to FE-9)

Phase 4.C: Reception Screen (FE-10 to FE-11)

Phase 4.D: Worklist + Validation (FE-12 to FE-17)

Phase 4.E: Referrals + Other (FE-18 to FE-24)

E. Order of Execution

F. Risk Register

G. Estimated effort

H. Final Confirmation Needed