# Mutual Fund — Selling Agent Commission

**Controller:** `App\Http\Controllers\MfSellingAgentCommissionController`  
**Model:** `App\Models\MfSellingAgentCommission`  
**Table:** `mf_selling_agent_commissions`  
**Middleware:** `jwt.auth`, `check.token`, `dynamic.permission`

Each row is mapped to one AMC (`amc_id`). Use `mf-amc-dropdown` to pick the AMC.

---

## Fields

| Column | Type | Notes |
|--------|------|--------|
| `id` | bigint | PK |
| `amc_id` | bigint | Required, `mf_amcs.id` |
| `partner_code` | varchar(32) | Optional. Defaults to the AMC `partner_code` if omitted |
| `period_month_year` | varchar(7) | Required, `YYYY-MM` |
| `total_time_weighted_aum_bdt` | decimal(18,2) | Required |
| `computed_commission_50_50_bdt` | decimal(14,2) | Optional |
| `reconciliation_status` | enum `PENDING` / `RECONCILED` | Default `PENDING` |
| `create_by` / `update_by` | int | From `users_id` |

Index/show also return nested `amc`.

## Endpoints

| Action | Method | Path | Route name |
|--------|--------|------|------------|
| List | GET | `/api/mf-selling-agent-commission/mf-selling-agent-commission-index` | `mf-selling-agent-commission-index` |
| Show | GET | `/api/mf-selling-agent-commission/mf-selling-agent-commission-show/{id}` | `mf-selling-agent-commission-show/{id}` |
| Dropdown | GET | `/api/mf-selling-agent-commission/mf-selling-agent-commission-dropdown` | `mf-selling-agent-commission-dropdown` |
| Create | POST | `/api/mf-selling-agent-commission/mf-selling-agent-commission-store` | `mf-selling-agent-commission-store` |
| Update | POST | `/api/mf-selling-agent-commission/mf-selling-agent-commission-update/{id}` | `mf-selling-agent-commission-update/{id}` |
| Delete | DELETE | `/api/mf-selling-agent-commission/mf-selling-agent-commission-delete/{id}` | `mf-selling-agent-commission-delete/{id}` |

Update is **POST**, not PUT.

## Query params

**Index:** `per_page`, `amc_id`, `reconciliation_status` (`PENDING`/`RECONCILED`), `period_month_year` (`YYYY-MM`), `q` (partner_code).

**Dropdown:** `amc_id`, `reconciliation_status` (`PENDING`/`RECONCILED`/`all`, default `all`).  
Returns `id`, `amc_id`, `partner_code`, `period_month_year`, `reconciliation_status`.

## Related docs

- cURL: `mf_selling_agent_commission_api_curl.md`
- Postman: `mf_selling_agent_commission.postman_collection.json`
