I need help with Adding a Column in Purchases datagridview. I read the instruction manual and I got the process but when I add the new columns look like they don't docent appear in the datagridview.

I did the changes in Index.php and the changes in the Purchases.php too.

PHP CODE::::::::::::::::::

PURCHASES.PHP>>>>>>
$this->load->library('datatables');
if ($warehouse_id) {
$this->datatables
->select("id, DATE_FORMAT(date, '%Y-%m-%d %T') as date, reference_no, container_number, port_of_loading, port_of_discharge,
supplier, status, grand_total, paid, (grand_total-paid) as balance, payment_status, attachment")
->from('purchases')
->where('warehouse_id', $warehouse_id);

} else {
$this->datatables
->select("id, DATE_FORMAT(date, '%Y-%m-%d %T') as date, reference_no, container_number, port_of_loading, port_of_discharge,
supplier, status, grand_total, paid, (grand_total-paid) as balance, payment_status, attachment")
->from('purchases');
}

INDEX.PHP>>>>>>

<thead>
<tr class="active">
<th style="min-width:30px; width: 30px; text-align: center;">
<input class="checkbox checkft" type="checkbox" name="check"/>
</th>
<th><?= lang('date'); ?></th>
<th><?= lang('ref_no'); ?></th>

<th><?= lang('Container_Number'); ?></th>

<th><?= lang('port_of_loading'); ?></th>
<th><?= lang('port_of_discharge'); ?></th>


<th><?= lang('supplier'); ?></th>
<th><?= lang('purchase_status'); ?></th>
<th><?= lang('grand_total'); ?></th>
<th><?= lang('paid'); ?></th>
<th><?= lang('balance'); ?></th>
<th><?= lang('payment_status'); ?></th>
<th style="min-width:30px; width: 30px; text-align: center;"><i class="fa fa-chain"></i></th>
<th style="width:100px;"><?= lang('actions'); ?></th>
</tr>
</thead>



///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

<tfoot class="dtFilter">
<tr class="active">
<th style="min-width:30px; width: 30px; text-align: center;">
<input class="checkbox checkft" type="checkbox" name="check"/>
</th>
<th></th>
<th></th>
<th></th>
<th></th>
<th></th>
<th></th>


<th></th>
<th><?= lang('grand_total'); ?></th>
<th><?= lang('paid'); ?></th>
<th><?= lang('balance'); ?></th>
<th></th>
<th style="min-width:30px; width: 30px; text-align: center;"><i class="fa fa-chain"></i></th>
<th style="width:100px; text-align: center;"><?= lang('actions'); ?></th>
</tr>
</tfoot>


I don't know what is missing. can you help me please. I will appreciate it'