116 lines
3.6 KiB
PHP
116 lines
3.6 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/functions.php');
|
|
include('log_entry.php');
|
|
|
|
$data = "<thead>
|
|
|
|
<tr>";
|
|
$data .= "<td>
|
|
Activities
|
|
</td>
|
|
";
|
|
for ($m = 4; $m <= 15; $m++) {
|
|
|
|
$data .= "<td>";
|
|
|
|
$monthNum = $m;
|
|
$dateObj = DateTime::createFromFormat('!m', $monthNum);
|
|
$monthName = $dateObj->format('F');
|
|
$data .= $monthName;
|
|
|
|
|
|
$data .= "</td>";
|
|
}
|
|
|
|
$data .= "<td>
|
|
Annual Target
|
|
</td>
|
|
</tr>
|
|
|
|
</thead>
|
|
<tbody id='main_table_data'>";
|
|
|
|
$act=$_POST['act'];
|
|
$act_name=getTableFieldValue('program_master','program_name','program_id',$act);
|
|
error_log('aaacc '.$act);
|
|
if ($act!='' && $act!=null) {
|
|
|
|
|
|
|
|
$data .= "<tr>
|
|
<td colspan='14'>
|
|
<h4 style='color: red;'>" . $act_name . "</h4>
|
|
</td>
|
|
</tr>";
|
|
|
|
$sql_program = "select * from activity_key_parameter_master where status='Active' and activity='" . $act . "' ";
|
|
|
|
$result_act = mysqli_query($conn, $sql_program);
|
|
|
|
while ($row_act = mysqli_fetch_assoc($result_act)) {
|
|
|
|
$data .= "<tr>
|
|
|
|
<td>" . $row_act['key_param_name'] . "
|
|
</td>
|
|
|
|
";
|
|
for ($m = 4; $m <= 15; $m++) {
|
|
|
|
$data .= " <td>";
|
|
|
|
$monthNum = $m;
|
|
$key = $act . '_' . $row_act['key_param_id'] . '_' . $m;
|
|
// echo $key;
|
|
|
|
$data .= "<label for='" . $key . "'>Achievement</label><input width='20%' class='" . $m . '_month' . "' type='number' id='" . $key . "' name='" . $key . "' oninput='monthly_sum(`" . $m . '_month' . "`); total_consolidate(" . $act . ' ,' . $row_act['key_param_id'] . ") ' /><br>
|
|
|
|
</td>";
|
|
}
|
|
|
|
$data .= "<td>";
|
|
|
|
$monthNum = $m;
|
|
$key1 = $act . '_' . $row_act['key_param_id'] . '_act_total';
|
|
// echo $key;
|
|
|
|
$data .= "<label for='" . $key . "'>Annual Target</label><input readonly width='20%' type='number' id='" . $key1 . "' name='" . $key1 . "' /><br>
|
|
|
|
|
|
</td>
|
|
</tr>";
|
|
}
|
|
}
|
|
|
|
|
|
|
|
$data .= "<tr>
|
|
<td>
|
|
Total Achievement
|
|
</td>";
|
|
|
|
for ($m = 4; $m <= 15; $m++) {
|
|
|
|
$data .= " <td>";
|
|
|
|
$monthNum = $m;
|
|
$key = $m . '_month';
|
|
// echo $key;
|
|
|
|
$data .= " <input width='20%' readonly type='number' id='" . $key . "' name='" . $key . "' /><br>
|
|
|
|
|
|
</td>";
|
|
}
|
|
|
|
$data .= " <td>
|
|
<label>Annual Achievement</label>
|
|
<div width='20%' id='yearly_sum'>
|
|
</div>
|
|
|
|
</td>
|
|
</tr>
|
|
</tbody>";
|
|
echo $data;
|