Custom icon as an output on table about tablesigniter HOT 3 CLOSED

Happy Lunar New Year.

In the TableIgniter, setOutput() allows you to transmit arrays consists of the strings and anonymous function. If the array includings anonymous function, you should be aware of these three hints down below:

1. TableIgniter will process every data fetched from the database on by one, and every time it will process the anonymous function you transferred.
2. The anonymous function must only have a single parameter, and the parameter should be according to the database. This means you can do the logical judgments you need and the preprocessing for each row of data
3. The return of the anonymous function must be a String, because the TableIgniter will combine the results into the frontend DataTables.

I made some changes to the codes you provided:

public function fetchProjectData()
{
    $table = new TablesIgniter();
    $table->setTable($this->projectModel->noticeTable())
        ->setDefaultOrder('project_name', 'ASC')
        ->setOrder([
            'project_name', 'client_name', 'pm_name',
            'start_date', 'finish_date', 'project_status', null
        ])
        ->setSearch(['project_name', 'client_name', 'pm_name', 'project_status'])
        ->setOutput([
            'project_name', 'client_name', 'pm_name', 'start_date',
            'finish_date', $this->projectStatus(), $this->projectModel->button()
        ]);
    return $table->getDatatable();
}

public function projectStatus()
{
    $closureFun = function ($row) {
        // $row should belong to the query results.
        if ($row['project_status'] == 'hold') {
            return '<span class="badge rounded-pill bg-primary">Hold</span>';
        } else {
            return '<button type="button" class="btn btn-info">Detail</button>'; 
        }
    }
    return $closureFun;
}

from tablesigniter.

Issue solved. Thank you!
I will close this thread.

from tablesigniter.

Hi

public function projectStatus()
{
$closureFun = function ($row) {
// $row should belong to the query results.
if ($row['status'] == '1')
{
return 'Hold';
} else {
return 'Detail';
}
}
return $closureFun;
}

getting syntax error, unexpected token "return"

Thanks

from tablesigniter.