/home/edulekha/crm.edulekha.com/modules/goals/views/table.php
<?php
defined('BASEPATH') or exit('No direct script access allowed');
$aColumns = [
'subject',
'CONCAT(firstname," ", lastname)',
'achievement',
'start_date',
'end_date',
'goal_type',
];
$sIndexColumn = 'id';
$sTable = db_prefix() . 'goals';
$join = ['LEFT JOIN ' . db_prefix() . 'staff ON ' . db_prefix() . 'staff.staffid = ' . db_prefix() . 'goals.staff_id'];
$result = data_tables_init($aColumns, $sIndexColumn, $sTable, $join, [], ['id']);
$output = $result['output'];
$rResult = $result['rResult'];
foreach ($rResult as $aRow) {
$row = [];
for ($i = 0; $i < count($aColumns); $i++) {
$_data = $aRow[$aColumns[$i]];
if ($aColumns[$i] == 'subject') {
$_data = '<a href="' . admin_url('goals/goal/' . $aRow['id']) . '" class="tw-font-medium">' . e($_data) . '</a>';
$_data .= '<div class="row-options">';
$_data .= '<a href="' . admin_url('goals/goal/' . $aRow['id']) . '">' . _l('view') . '</a>';
if (staff_can('delete', 'goals')) {
$_data .= ' | <a href="' . admin_url('goals/delete/' . $aRow['id']) . '" class="text-danger _delete">' . _l('delete') . '</a>';
}
$_data .= '</div>';
} elseif ($aColumns[$i] == 'start_date' || $aColumns[$i] == 'end_date') {
$_data = e(_d($_data));
} elseif ($aColumns[$i] == 'goal_type') {
$_data = e(format_goal_type($_data));
}
$row[] = $_data;
}
ob_start();
$achievement = $this->ci->goals_model->calculate_goal_achievement($aRow['id']);
$percent = $achievement['percent'];
$progress_bar_percent = $achievement['progress_bar_percent']; ?>
<input type="hidden" value="<?php
echo $progress_bar_percent; ?>" name="percent">
<div class="goal-progress" data-reverse="true">
<strong class="goal-percent"><?php
echo $percent; ?>%</strong>
</div>
<?php
$progress = ob_get_contents();
ob_end_clean();
$row[] = $progress;
$row['DT_RowClass'] = 'has-row-options';
$output['aaData'][] = $row;
}