Project: Advanced Account Search Backed by Apex

An advancedAccountSearch component that:

1. Reactively searches Accounts by name as the user types, using @wire and a cacheable=true Apex method.
2. Displays results using a wrapper class combining the Account with its open Opportunity count.
3. Lets the user select multiple results and bulk-update their status in a single Apex call.

This is Module 6's Account/Contact project taken further — the search and aggregation logic genuinely needs Apex this time, per Lesson 1's decision checklist.

public with sharing class AccountSearchController {
    @AuraEnabled(cacheable=true)
    public static List<AccountResult> search(String searchTerm) {
        List<AccountResult> results = new List<AccountResult>();
        for (Account acc : [
            SELECT Id, Name, (SELECT Id FROM Opportunities WHERE IsClosed = false)
            FROM Account
            WHERE Name LIKE :('%' + searchTerm + '%')
            WITH SECURITY_ENFORCED
            LIMIT 25
        ]) {
            results.add(new AccountResult(acc.Id, acc.Name, acc.Opportunities.size()));
        }
        return results;
    }

    @AuraEnabled
    public static void bulkUpdateStatus(List<Id> accountIds, String status) {
        if (accountIds == null || accountIds.isEmpty()) {
            throw new AuraHandledException('Select at least one account.');
        }
        List<Account> accounts = [SELECT Id, Status__c FROM Account WHERE Id IN :accountIds WITH SECURITY_ENFORCED];
        for (Account acc : accounts) {
            acc.Status__c = status;
        }
        update accounts;
    }
}

public class AccountResult {
    @AuraEnabled public Id accountId;
    @AuraEnabled public String accountName;
    @AuraEnabled public Integer openOpportunityCount;

    public AccountResult(Id accountId, String accountName, Integer openOpportunityCount) {
        this.accountId = accountId;
        this.accountName = accountName;
        this.openOpportunityCount = openOpportunityCount;
    }
}

import { LightningElement, wire } from 'lwc';
import search from '@salesforce/apex/AccountSearchController.search';
import bulkUpdateStatus from '@salesforce/apex/AccountSearchController.bulkUpdateStatus';
import { refreshApex } from '@salesforce/apex';

export default class AdvancedAccountSearch extends LightningElement {
    searchTerm = '';
    selectedIds = [];
    wiredResults;

    @wire(search, { searchTerm: '$searchTerm' })
    wiredSearch(result) {
        this.wiredResults = result;
    }

    get results() {
        return this.wiredResults?.data ?? [];
    }

    get error() {
        return this.wiredResults?.error?.body?.message;
    }

    handleSearchTermChange(event) {
        this.searchTerm = event.target.value;
    }

    async handleBulkActivate() {
        try {
            await bulkUpdateStatus({ accountIds: this.selectedIds, status: 'Active' });
            await refreshApex(this.wiredResults);
        } catch (error) {
            this.error = error.body?.message ?? 'An unexpected error occurred.';
        }
    }
}

The '$searchTerm' reactive parameter (Lesson 3) re-runs the search automatically as the user types; the wrapper class (Lesson 4) keeps the result shape clean; AuraHandledException (Lesson 5) surfaces a real validation message; and bulkUpdateStatus (Lesson 6) updates every selected Account in one transaction rather than one call per row.