Sorry, you are not authorized to access this page.
Please contact your system support for assistance.
Thank you!
";
exit();
}
//==============================================================================================================
//VALIDATE ACCESS ==============================================================================================
//==============================================================================================================
?>
| ID |
KEY PERFORMANCE AREA (KRA) |
KEY PERFORMANCE INDICATOR (KPI) |
WEIGHT (%) |
B.MARK |
TARGET (%) / TARGET DESCRIPTION |
STRATEGY / MAJOR ACTIVITIES |
TIMELINE (FROM => TO |
RESPONSIBILITY |
|
|
|
loadOpsPlanData_Brand.php 0000644 00000007056 15025210471 0011376 0 ustar 00 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRAName = "SELECT * FROM `kra_brand` WHERE `deleted`='0' AND `id`='".$row['ops_kra']."'";
$getMyKRAName = mysqli_query($conn,$getKRAName);
while($kra = mysqli_fetch_array($getMyKRAName)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_brand` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
}
$conn->close();
}
?> saveNewOpsPlanEntry_Autohub.php 0000644 00000014523 15025210471 0012675 0 ustar 00 0){
$errorMessage = "Error: The selected KRA has already been added";
//echo '';
}else{
$sql = "INSERT INTO ops_data_autohub (
`id`,
`pms_record_id`,
`ops_title_id`,
`ops_kra`,
`ops_kpi`,
`ops_weight`,
`ops_benchmark`,
`ops_target`,
`ops_target_desc`,
`ops_strategy`,
`ops_timeline_from`,
`ops_timeline_to`,
`ops_responsibility`,
`date_created`,
`created_by`,
`kra_code`,`kra_tag`)
VALUES ('',
'$SelectedRecordID',
'$opsPlanHeaderID',
'$opsKRA',
'$activeKPI',
'$activeKPIWeight',
'$kpiBenchMark',
'$kpiOpsTargetNumber',
'$kpiOpsTargetDesc',
'$kpiOpsStrategy',
'$opsTimelineStart',
'$opsTimelineEnd',
'$opsKPIResponsibility',
'$myTimeStamp',
'$userID','$kraCode','$kraTag')";
if ($conn->query($sql) === TRUE) {
//echo '';
$errorMessage = "Success: New record has been added";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
}
$getKRAList = "SELECT * FROM `ops_data_autohub` WHERE `deleted`=0 AND `ops_title_id` ='$opsPlanHeaderID' ORDER BY `ops_kra` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRACode = "SELECT * FROM `kra_group_tbl` WHERE `deleted`='0' AND `id`='$opsKRA'";
$getMyKRACode = mysqli_query($conn,$getKRACode);
while($kra = mysqli_fetch_array($getMyKRACode)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_group` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
echo "
";
echo "| ".$errorMessage." | ";
echo "
";
}
$conn->close();
}
?> getKPIWeight_Department.php 0000644 00000001114 15025210471 0011725 0 ustar 00 close();
}
?> index.php 0000644 00000000113 15025210471 0006354 0 ustar 00 kpiLoadOnChange_subDivision.php 0000644 00000001302 15025210471 0012612 0 ustar 00 --Select KPI --";
while($row = mysqli_fetch_array($getBranch)){
echo "
";
}
$conn->close();
}
?> deleteOpsPlanHeader_Autohub.php 0000644 00000004115 15025210471 0012612 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_autohub_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> postOpsplanHeader_Company.php 0000644 00000004334 15025210471 0012377 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_company_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> loadOpsPlanData_subDivision.php 0000644 00000007111 15025210471 0012636 0 ustar 00 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRAName = "SELECT * FROM `kra_division_child_tbl` WHERE `deleted`='0' AND `id`='".$row['ops_kra']."'";
$getMyKRAName = mysqli_query($conn,$getKRAName);
while($kra = mysqli_fetch_array($getMyKRAName)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_childdivision` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
}
$conn->close();
}
?> kpiLoadOnChange_mainDivision.php 0000644 00000001301 15025210471 0012744 0 ustar 00 --Select KPI --";
while($row = mysqli_fetch_array($getBranch)){
echo "";
}
$conn->close();
}
?> saveNewOpsPlanHeader_mainDivision.php 0000644 00000004753 15025210471 0014012 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_maindivision_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> loadPMSList_mainDivision.php 0000644 00000003450 15025210471 0012120 0 ustar 00 0){
while($row = mysqli_fetch_array($getArea)){
?>
".$row['id']."";
echo "| ".$row['sub_group_code']." | ";
echo "".$row['sub_group_name']." | ";
echo "".$row['sub_group_desc']." | ";
echo "";?>
";
echo " |
";
}
}
$conn->close();
}
?> loadPMSList_subDivision.php 0000644 00000003522 15025210471 0011765 0 ustar 00 0){
while($row = mysqli_fetch_array($getArea)){
?>
".$row['id']."";
echo "| ".$row['division_code']." | ";
echo "".$row['division_name']." | ";
echo "".$row['division_desc']." | ";
echo "";?>
";
echo " |
";
}
}
$conn->close();
}
?> saveNewOpsPlanHeader_Company.php 0000644 00000004741 15025210471 0012764 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_company_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> postOpsplanHeader_subDivision.php 0000644 00000004344 15025210471 0013270 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_subdivision_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> loadPMSList_Company.php 0000644 00000003200 15025210471 0011066 0 ustar 00
".$row['comp_id']."";
echo "| ".$row['comp_code']." | ";
echo "".$row['comp_name']." | ";
echo "".$row['comp_address']." | ";
echo "";?>
";
echo " |
";
}
$conn->close();
}
?> loadOpsPlanData_Company.php 0000644 00000007066 15025210471 0011757 0 ustar 00 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRAName = "SELECT * FROM `kra_comp_detl` WHERE `deleted`='0' AND `id`='".$row['ops_kra']."'";
$getMyKRAName = mysqli_query($conn,$getKRAName);
while($kra = mysqli_fetch_array($getMyKRAName)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_company` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
}
$conn->close();
}
?> loadOpsPlanData_mainDivision.php 0000644 00000007103 15025210471 0012772 0 ustar 00 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRAName = "SELECT * FROM `kra_division_tbl` WHERE `deleted`='0' AND `id`='".$row['ops_kra']."'";
$getMyKRAName = mysqli_query($conn,$getKRAName);
while($kra = mysqli_fetch_array($getMyKRAName)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_maindivision` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
}
$conn->close();
}
?> deleteOpsPlanHeader_Company.php 0000644 00000004107 15025210471 0012612 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_area_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> saveNewOpsPlanHeader_subDivision.php 0000644 00000004751 15025210471 0013655 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_subdivision_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> saveNewOpsPlanHeader_Department.php 0000644 00000004747 15025210471 0013467 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_department_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> deleteOpsPlanData_Department.php 0000644 00000006770 15025210471 0013000 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_data_department` WHERE `deleted`=0 AND `ops_title_id` ='$opsPlanHeaderID' ORDER BY `ops_kra` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRACode = "SELECT * FROM `kra_department_tbl` WHERE `deleted`='0' AND `id`='".$row['ops_kra']."'";
$getMyKRACode = mysqli_query($conn,$getKRACode);
while($kra = mysqli_fetch_array($getMyKRACode)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_department` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
}
$conn->close();
}
?> getKPIWeight_Brand.php 0000644 00000001107 15025210471 0010652 0 ustar 00 close();
}
?> postOpsplanHeader_mainDivision.php 0000644 00000004346 15025210471 0013425 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_maindivision_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> saveNewOpsPlanEntry_Area.php 0000644 00000014507 15025210471 0012140 0 ustar 00 0){
$errorMessage = "Error: The selected KRA has already been added";
//echo '';
}else{
$sql = "INSERT INTO ops_data_area (
`id`,
`pms_record_id`,
`ops_title_id`,
`ops_kra`,
`ops_kpi`,
`ops_weight`,
`ops_benchmark`,
`ops_target`,
`ops_target_desc`,
`ops_strategy`,
`ops_timeline_from`,
`ops_timeline_to`,
`ops_responsibility`,
`date_created`,
`created_by`,
`kra_code`,`kra_tag`)
VALUES ('',
'$SelectedRecordID',
'$opsPlanHeaderID',
'$opsKRA',
'$activeKPI',
'$activeKPIWeight',
'$kpiBenchMark',
'$kpiOpsTargetNumber',
'$kpiOpsTargetDesc',
'$kpiOpsStrategy',
'$opsTimelineStart',
'$opsTimelineEnd',
'$opsKPIResponsibility',
'$myTimeStamp',
'$userID','$kraCode','$kraTag')";
if ($conn->query($sql) === TRUE) {
//echo '';
$errorMessage = "Success: New record has been added";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
}
$getKRAList = "SELECT * FROM `ops_data_area` WHERE `deleted`=0 AND `ops_title_id` ='$opsPlanHeaderID' ORDER BY `ops_kra` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRACode = "SELECT * FROM `kra_area_tbl` WHERE `deleted`='0' AND `id`='$opsKRA'";
$getMyKRACode = mysqli_query($conn,$getKRACode);
while($kra = mysqli_fetch_array($getMyKRACode)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_area` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
echo "
";
echo "| ".$errorMessage." | ";
echo "
";
}
$conn->close();
}
?> saveNewOpsPlanEntry_Brand.php 0000644 00000014505 15025210471 0012314 0 ustar 00 0){
$errorMessage = "Error: The selected KRA has already been added";
//echo '';
}else{
$sql = "INSERT INTO ops_data_brand (
`id`,
`pms_record_id`,
`ops_title_id`,
`ops_kra`,
`ops_kpi`,
`ops_weight`,
`ops_benchmark`,
`ops_target`,
`ops_target_desc`,
`ops_strategy`,
`ops_timeline_from`,
`ops_timeline_to`,
`ops_responsibility`,
`date_created`,
`created_by`,
`kra_code`,`kra_tag`)
VALUES ('',
'$SelectedRecordID',
'$opsPlanHeaderID',
'$opsKRA',
'$activeKPI',
'$activeKPIWeight',
'$kpiBenchMark',
'$kpiOpsTargetNumber',
'$kpiOpsTargetDesc',
'$kpiOpsStrategy',
'$opsTimelineStart',
'$opsTimelineEnd',
'$opsKPIResponsibility',
'$myTimeStamp',
'$userID','$kraCode','$kraTag')";
if ($conn->query($sql) === TRUE) {
//echo '';
$errorMessage = "Success: New record has been added";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
}
$getKRAList = "SELECT * FROM `ops_data_brand` WHERE `deleted`=0 AND `ops_title_id` ='$opsPlanHeaderID' ORDER BY `ops_kra` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRACode = "SELECT * FROM `kra_brand` WHERE `deleted`='0' AND `id`='$opsKRA'";
$getMyKRACode = mysqli_query($conn,$getKRACode);
while($kra = mysqli_fetch_array($getMyKRACode)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_brand` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
echo "
";
echo "| ".$errorMessage." | ";
echo "
";
}
$conn->close();
}
?> viewOpsPlanSummary_Branch.php 0000644 00000003701 15025210471 0012355 0 ustar 00 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?>
saveNewOpsPlanEntry_Department.php 0000644 00000014552 15025210471 0013373 0 ustar 00 0){
$errorMessage = "Error: The selected KRA has already been added";
//echo '';
}else{
$sql = "INSERT INTO ops_data_department(
`id`,
`pms_record_id`,
`ops_title_id`,
`ops_kra`,
`ops_kpi`,
`ops_weight`,
`ops_benchmark`,
`ops_target`,
`ops_target_desc`,
`ops_strategy`,
`ops_timeline_from`,
`ops_timeline_to`,
`ops_responsibility`,
`date_created`,
`created_by`,
`kra_code`,`kra_tag`)
VALUES ('',
'$SelectedRecordID',
'$opsPlanHeaderID',
'$opsKRA',
'$activeKPI',
'$activeKPIWeight',
'$kpiBenchMark',
'$kpiOpsTargetNumber',
'$kpiOpsTargetDesc',
'$kpiOpsStrategy',
'$opsTimelineStart',
'$opsTimelineEnd',
'$opsKPIResponsibility',
'$myTimeStamp',
'$userID','$kraCode','$kraTag')";
if ($conn->query($sql) === TRUE) {
//echo '';
$errorMessage = "Success: New record has been added";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
}
$getKRAList = "SELECT * FROM `ops_data_department` WHERE `deleted`=0 AND `ops_title_id` ='$opsPlanHeaderID' ORDER BY `ops_kra` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRACode = "SELECT * FROM `kra_department_tbl` WHERE `deleted`='0' AND `id`='$opsKRA'";
$getMyKRACode = mysqli_query($conn,$getKRACode);
while($kra = mysqli_fetch_array($getMyKRACode)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_department` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
echo "
";
echo "| ".$errorMessage." | ";
echo "
";
}
$conn->close();
}
?> kpiLoadOnChange_autohub.php 0000644 00000001272 15025210471 0011771 0 ustar 00 --Select KPI --";
while($row = mysqli_fetch_array($getBranch)){
echo "
";
}
$conn->close();
}
?> loadOpsPlanData_Branch.php 0000644 00000007065 15025210471 0011545 0 ustar 00 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRAName = "SELECT * FROM `kra_branch_tbl` WHERE `deleted`='0' AND `id`='".$row['ops_kra']."'";
$getMyKRAName = mysqli_query($conn,$getKRAName);
while($kra = mysqli_fetch_array($getMyKRAName)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_branch` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
}
$conn->close();
}
?> viewOpsPlanSummary_Area.php 0000644 00000003677 15025210471 0012044 0 ustar 00 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?>
postOpsplanHeader_Brand.php 0000644 00000004330 15025210471 0012013 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_brand_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> kpiLoadOnChange_Department.php 0000644 00000001277 15025210471 0012432 0 ustar 00 --Select KPI --";
while($row = mysqli_fetch_array($getBranch)){
echo "";
}
$conn->close();
}
?> deleteOpsPlanData_Company.php 0000644 00000006751 15025210471 0012302 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_data_company` WHERE `deleted`=0 AND `ops_title_id` ='$opsPlanHeaderID' ORDER BY `ops_kra` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRACode = "SELECT * FROM `kra_comp_tbl` WHERE `deleted`='0' AND `id`='".$row['ops_kra']."'";
$getMyKRACode = mysqli_query($conn,$getKRACode);
while($kra = mysqli_fetch_array($getMyKRACode)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_company` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
}
$conn->close();
}
?> saveNewOpsPlanEntry_Company.php 0000644 00000014525 15025210471 0012676 0 ustar 00 0){
$errorMessage = "Error: The selected KRA has already been added";
//echo '';
}else{
$sql = "INSERT INTO ops_data_company (
`id`,
`pms_record_id`,
`ops_title_id`,
`ops_kra`,
`ops_kpi`,
`ops_weight`,
`ops_benchmark`,
`ops_target`,
`ops_target_desc`,
`ops_strategy`,
`ops_timeline_from`,
`ops_timeline_to`,
`ops_responsibility`,
`date_created`,
`created_by`,
`kra_code`,`kra_tag`)
VALUES ('',
'$SelectedRecordID',
'$opsPlanHeaderID',
'$opsKRA',
'$activeKPI',
'$activeKPIWeight',
'$kpiBenchMark',
'$kpiOpsTargetNumber',
'$kpiOpsTargetDesc',
'$kpiOpsStrategy',
'$opsTimelineStart',
'$opsTimelineEnd',
'$opsKPIResponsibility',
'$myTimeStamp',
'$userID','$kraCode','$kraTag')";
if ($conn->query($sql) === TRUE) {
//echo '';
$errorMessage = "Success: New record has been added";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
}
$getKRAList = "SELECT * FROM `ops_data_company` WHERE `deleted`=0 AND `ops_title_id` ='$opsPlanHeaderID' ORDER BY `ops_kra` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRACode = "SELECT * FROM `kra_comp_detl` WHERE `deleted`='0' AND `id`='$opsKRA'";
$getMyKRACode = mysqli_query($conn,$getKRACode);
while($kra = mysqli_fetch_array($getMyKRACode)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_company` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
echo "
";
echo "| ".$errorMessage." | ";
echo "
";
}
$conn->close();
}
?> deleteOpsPlanData_subDivision.php 0000644 00000007001 15025210471 0013157 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_data_subDivision` WHERE `deleted`=0 AND `ops_title_id` ='$opsPlanHeaderID' ORDER BY `ops_kra` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRACode = "SELECT * FROM `kra_division_child_tbl` WHERE `deleted`='0' AND `id`='".$row['ops_kra']."'";
$getMyKRACode = mysqli_query($conn,$getKRACode);
while($kra = mysqli_fetch_array($getMyKRACode)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_childdivision` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
}
$conn->close();
}
?> getKPIWeight_Branch.php 0000644 00000001110 15025210471 0011013 0 ustar 00 close();
}
?> opsBranch.php 0000644 00000132063 15025210471 0007176 0 ustar 00 PMS Name id " . $_SESSION['userID'];
$uID = $_SESSION['userID'];
}
include_once("../../../cfg/conn.php");
error_reporting(0);
if(isset($_POST['grp'])){
//==============================================================================================================
//VALIDATE ACCESS ==============================================================================================
//============================================================================================================== $roleID = userProfileID($userID);
include ("../functions/users.php");
$roleID = userProfileID($uID);
$moduleID = 29;
$add =checkViewAccessM1024($roleID, $moduleID)[1];
$edit =checkViewAccessM1024($roleID, $moduleID)[2];
$delete =checkViewAccessM1024($roleID, $moduleID)[3];
$print =checkViewAccessM1024($roleID, $moduleID)[4];
$download =checkViewAccessM1024($roleID, $moduleID)[5];
echo "";
echo "";
echo "";
echo "";
echo "";
if($add == 1){$addButton = '';}else{$addButton='Disabled';}
if($edit == 1){$editButton = '';}else{$editButton='Disabled';}
if($delete == 1){$deletButton = '';}else{$deletButton='Disabled';}
if($print == 1){$printButton = '';}else{$printButton='Disabled';}
if($download == 1){$downloadButton = '';}else{$downloadButton='Disabled';}
if(checkViewAccessM1024($roleID, $moduleID)[0] == 0){
echo " 
![]()
";
echo " Access Denied
";
echo "
Sorry, you are not authorized to access this page.
Please contact your system support for assistance.
Thank you!
";
exit();
}
//==============================================================================================================
//VALIDATE ACCESS ==============================================================================================
//==============================================================================================================
?>
| REC.
| CODE |
COMPANY |
Description |
|
";
echo "
";
?>
Viewing out of total records
| NO |
YEAR |
STATUS |
DESCRIPTION |
|
|
|
|
| ID |
KEY PERFORMANCE AREA (KRA) |
KEY PERFORMANCE INDICATOR (KPI) |
WEIGHT (%) |
B.MARK |
TARGET (%) / TARGET DESCRIPTION |
STRATEGY / MAJOR ACTIVITIES |
TIMELINE (FROM => TO |
RESPONSIBILITY |
|
|
|
postOpsplanHeader_Department.php 0000644 00000004342 15025210471 0013073 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_department_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> saveNewOpsPlanHeader_Autohub.php 0000644 00000004741 15025210471 0012765 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_autohub_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> postOpsplanHeader_Branch.php 0000644 00000004332 15025210471 0012164 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_branch_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> kpiLoadOnChange_Area.php 0000644 00000001271 15025210471 0011171 0 ustar 00 --Select KPI --";
while($row = mysqli_fetch_array($getBranch)){
echo "";
}
$conn->close();
}
?> loadPMSList_Brand.php 0000644 00000003467 15025210471 0010525 0 ustar 00 0){
while($row = mysqli_fetch_array($getArea)){
?>
".$row['id']."";
echo "| ".$row['code']." | ";
echo "".$row['brand_name']." | ";
echo "".$row['brand_description']." | ";
echo "";?>
";
echo " |
";
}
}
$conn->close();
}
?> loadPMSList_Department.php 0000644 00000003453 15025210471 0011575 0 ustar 00 0){
while($row = mysqli_fetch_array($getArea)){
?>
".$row['id']."";
echo "| ".$row['dept_code']." | ";
echo "".$row['dept_name']." | ";
echo "".$row['dept_desc']." | ";
echo "";?>
";
echo " |
";
}
}
$conn->close();
}
?> viewOpsPlanSummary_Company.php 0000644 00000003702 15025210471 0012567 0 ustar 00 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?>
template/viewOpsPlanSummary_subDivision.php 0000644 00000003706 15025210471 0015276 0 ustar 00 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?>
template/deleteOpsPlanHeader_subDivision.php 0000644 00000004126 15025210471 0015316 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_subdivision_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> template/OPSPLAN_DATA_TABLE_SQL.txt 0000644 00000001642 15025210471 0012453 0 ustar 00 CREATE TABLE `pms_db`.`ops_data_brand` (`id` INT(11) NOT NULL AUTO_INCREMENT , `pms_record_id` INT(11) NOT NULL , `ops_title_id` INT(11) NOT NULL , `ops_kra` VARCHAR(200) NOT NULL , `ops_kpi` VARCHAR(200) NOT NULL , `ops_weight` VARCHAR(7) NOT NULL , `ops_benchmark` VARCHAR(7) NOT NULL , `ops_target` VARCHAR(7) NOT NULL , `ops_target_desc` VARCHAR(250) NOT NULL , `ops_strategy` LONGTEXT NOT NULL , `ops_timeline_from` VARCHAR(15) NOT NULL , `ops_timeline_to` VARCHAR(15) NOT NULL , `ops_responsibility` VARCHAR(50) NOT NULL , `date_created` VARCHAR(21) NOT NULL , `date_modified` VARCHAR(21) NOT NULL , `created_by` INT(11) NOT NULL , `deleted` INT(1) NOT NULL DEFAULT '0' , `actual_score` FLOAT(7) NOT NULL , `actual_variance` VARCHAR(7) NOT NULL , `final_score` VARCHAR(7) NOT NULL , `kra_code` VARCHAR(15) NOT NULL , `kra_tag` VARCHAR(4) NOT NULL , `last_action` VARCHAR(15) NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
template/getKPIWeight_subDivision.php 0000644 00000001117 15025210471 0013736 0 ustar 00 close();
}
?> template/kpiLoadOnChange_subDivision.php 0000644 00000001302 15025210471 0014425 0 ustar 00 --Select KPI --";
while($row = mysqli_fetch_array($getBranch)){
echo "";
}
$conn->close();
}
?> template/loadOpsPlanData_subDivision.php 0000644 00000007111 15025210471 0014451 0 ustar 00 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRAName = "SELECT * FROM `kra_division_child_tbl` WHERE `deleted`='0' AND `id`='".$row['ops_kra']."'";
$getMyKRAName = mysqli_query($conn,$getKRAName);
while($kra = mysqli_fetch_array($getMyKRAName)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_childdivision` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
}
$conn->close();
}
?> template/loadPMSList_subDivision.php 0000644 00000003522 15025210471 0013600 0 ustar 00 0){
while($row = mysqli_fetch_array($getArea)){
?>
".$row['id']."";
echo "| ".$row['division_code']." | ";
echo "".$row['division_name']." | ";
echo "".$row['division_desc']." | ";
echo "";?>
";
echo " |
";
}
}
$conn->close();
}
?> template/OPSPLAN_HEADER_TABLE_SQL.txt 0000644 00000001347 15025210471 0012674 0 ustar 00 CREATE TABLE `pms_db`.`ops_brand_level` (`id` INT(11) NOT NULL AUTO_INCREMENT , `record_id` INT(11) NOT NULL , `ops_name` VARCHAR(150) NOT NULL , `description` VARCHAR(150) NOT NULL , `coverage_year` INT(4) NOT NULL , `status` VARCHAR(6) NOT NULL , `total_kra_count` VARCHAR(7) NOT NULL , `total_kpi_count` VARCHAR(7) NOT NULL , `average_target` VARCHAR(15) NOT NULL , `actual_output` VARCHAR(15) NOT NULL , `achievement_rate` VARCHAR(15) NOT NULL , `created_by` INT(11) NOT NULL , `deleted` INT(1) NOT NULL DEFAULT '0' , `date_created` VARCHAR(21) NOT NULL , `date_modified` VARCHAR(21) NOT NULL , `last_modified_by` INT(11) NOT NULL , `date_posted` VARCHAR(21) NOT NULL , `posted_by` INT(11) NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
template/postOpsplanHeader_subDivision.php 0000644 00000004344 15025210471 0015103 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_subdivision_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> template/saveNewOpsPlanHeader_subDivision.php 0000644 00000004751 15025210471 0015470 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_subdivision_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> template/Deploy/opsDepartment.php 0000644 00000120327 15025210471 0013153 0 ustar 00 PMS Name id " . $_SESSION['userID'];
$uID = $_SESSION['userID'];
}
include_once("../../../cfg/conn.php");
error_reporting(0);
if(isset($_POST['grp'])){
?>
| REC.
| CODE |
COMPANY |
Description |
|
";
echo "
";
?>
Viewing out of total records
| NO |
YEAR |
STATUS |
DESCRIPTION |
|
|
| ID |
KEY PERFORMANCE AREA (KRA) |
KEY PERFORMANCE INDICATOR (KPI) |
WEIGHT (%) |
B.MARK |
TARGET (%) / TARGET DESCRIPTION |
STRATEGY / MAJOR ACTIVITIES |
TIMELINE (FROM => TO |
RESPONSIBILITY |
|
template/Deploy/deleteOpsPlanHeader_Department.php 0000644 00000004124 15025210471 0016355 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_department_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> template/Deploy/loadOpsPlanData_Department.php 0000644 00000007101 15025210471 0015511 0 ustar 00 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRAName = "SELECT * FROM `kra_department_tbl` WHERE `deleted`='0' AND `id`='".$row['ops_kra']."'";
$getMyKRAName = mysqli_query($conn,$getKRAName);
while($kra = mysqli_fetch_array($getMyKRAName)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_department` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
}
$conn->close();
}
?> template/Deploy/viewOpsPlanSummary_Department.php 0000644 00000003705 15025210471 0016336 0 ustar 00 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?>
template/Deploy/getKPIWeight_Department.php 0000644 00000001114 15025210471 0014774 0 ustar 00 close();
}
?> template/Deploy/saveNewOpsPlanHeader_Department.php 0000644 00000004747 15025210471 0016536 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_department_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> template/Deploy/deleteOpsPlanData_Department.php 0000644 00000006770 15025210471 0016047 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_data_department` WHERE `deleted`=0 AND `ops_title_id` ='$opsPlanHeaderID' ORDER BY `ops_kra` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRACode = "SELECT * FROM `kra_department_tbl` WHERE `deleted`='0' AND `id`='".$row['ops_kra']."'";
$getMyKRACode = mysqli_query($conn,$getKRACode);
while($kra = mysqli_fetch_array($getMyKRACode)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_department` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
}
$conn->close();
}
?> template/Deploy/saveNewOpsPlanEntry_Department.php 0000644 00000014552 15025210471 0016442 0 ustar 00 0){
$errorMessage = "Error: The selected KRA has already been added";
//echo '';
}else{
$sql = "INSERT INTO ops_data_department(
`id`,
`pms_record_id`,
`ops_title_id`,
`ops_kra`,
`ops_kpi`,
`ops_weight`,
`ops_benchmark`,
`ops_target`,
`ops_target_desc`,
`ops_strategy`,
`ops_timeline_from`,
`ops_timeline_to`,
`ops_responsibility`,
`date_created`,
`created_by`,
`kra_code`,`kra_tag`)
VALUES ('',
'$SelectedRecordID',
'$opsPlanHeaderID',
'$opsKRA',
'$activeKPI',
'$activeKPIWeight',
'$kpiBenchMark',
'$kpiOpsTargetNumber',
'$kpiOpsTargetDesc',
'$kpiOpsStrategy',
'$opsTimelineStart',
'$opsTimelineEnd',
'$opsKPIResponsibility',
'$myTimeStamp',
'$userID','$kraCode','$kraTag')";
if ($conn->query($sql) === TRUE) {
//echo '';
$errorMessage = "Success: New record has been added";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
}
$getKRAList = "SELECT * FROM `ops_data_department` WHERE `deleted`=0 AND `ops_title_id` ='$opsPlanHeaderID' ORDER BY `ops_kra` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRACode = "SELECT * FROM `kra_department_tbl` WHERE `deleted`='0' AND `id`='$opsKRA'";
$getMyKRACode = mysqli_query($conn,$getKRACode);
while($kra = mysqli_fetch_array($getMyKRACode)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_department` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
echo "
";
echo "| ".$errorMessage." | ";
echo "
";
}
$conn->close();
}
?> template/Deploy/kpiLoadOnChange_Department.php 0000644 00000001277 15025210471 0015501 0 ustar 00 --Select KPI --";
while($row = mysqli_fetch_array($getBranch)){
echo "
";
}
$conn->close();
}
?> template/Deploy/postOpsplanHeader_Department.php 0000644 00000004342 15025210471 0016142 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_department_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> template/Deploy/loadPMSList_Department.php 0000644 00000003526 15025210471 0014645 0 ustar 00 0){
while($row = mysqli_fetch_array($getArea)){
?>
".$row['id']."";
echo "| ".$row['division_code']." | ";
echo "".$row['division_name']." | ";
echo "".$row['division_desc']." | ";
echo "";?>
";
echo " |
";
}
}
$conn->close();
}
?> template/DB/OPSPLAN_DATA_TABLE_SQL.txt 0000644 00000001666 15025210471 0012746 0 ustar 00 CREATE TABLE `pms_db`.`ops_data_brand` (`id` INT(11) NOT NULL AUTO_INCREMENT , `pms_record_id` INT(11) NOT NULL , `ops_title_id` INT(11) NOT NULL , `ops_kra` VARCHAR(200) NOT NULL , `ops_kpi` VARCHAR(200) NOT NULL , `ops_weight` VARCHAR(7) NOT NULL , `ops_benchmark` VARCHAR(7) NOT NULL , `ops_target` VARCHAR(7) NOT NULL , `ops_target_desc` VARCHAR(250) NOT NULL , `ops_strategy` LONGTEXT NOT NULL , `ops_timeline_from` VARCHAR(15) NOT NULL , `ops_timeline_to` VARCHAR(15) NOT NULL , `ops_responsibility` VARCHAR(50) NOT NULL , `date_created` VARCHAR(21) NOT NULL , `date_modified` VARCHAR(21) NOT NULL , `created_by` INT(11) NOT NULL , `deleted` INT(1) NOT NULL DEFAULT '0' , `actual_score` FLOAT(7) NOT NULL , `actual_variance` VARCHAR(7) NOT NULL , `final_score` VARCHAR(7) NOT NULL , `kra_code` VARCHAR(15) NOT NULL , `kra_tag` VARCHAR(4) NOT NULL , `last_action` VARCHAR(15) NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
ops_data_subDivision template/DB/OPSPLAN_HEADER_TABLE_SQL.txt 0000644 00000001347 15025210471 0013161 0 ustar 00 CREATE TABLE `pms_db`.`ops_brand_level` (`id` INT(11) NOT NULL AUTO_INCREMENT , `record_id` INT(11) NOT NULL , `ops_name` VARCHAR(150) NOT NULL , `description` VARCHAR(150) NOT NULL , `coverage_year` INT(4) NOT NULL , `status` VARCHAR(6) NOT NULL , `total_kra_count` VARCHAR(7) NOT NULL , `total_kpi_count` VARCHAR(7) NOT NULL , `average_target` VARCHAR(15) NOT NULL , `actual_output` VARCHAR(15) NOT NULL , `achievement_rate` VARCHAR(15) NOT NULL , `created_by` INT(11) NOT NULL , `deleted` INT(1) NOT NULL DEFAULT '0' , `date_created` VARCHAR(21) NOT NULL , `date_modified` VARCHAR(21) NOT NULL , `last_modified_by` INT(11) NOT NULL , `date_posted` VARCHAR(21) NOT NULL , `posted_by` INT(11) NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
template/deleteOpsPlanData_subDivision.php 0000644 00000007001 15025210471 0014772 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_data_subDivision` WHERE `deleted`=0 AND `ops_title_id` ='$opsPlanHeaderID' ORDER BY `ops_kra` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRACode = "SELECT * FROM `kra_division_child_tbl` WHERE `deleted`='0' AND `id`='".$row['ops_kra']."'";
$getMyKRACode = mysqli_query($conn,$getKRACode);
while($kra = mysqli_fetch_array($getMyKRACode)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_childdivision` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
}
$conn->close();
}
?> template/opssubDivision.php 0000644 00000120343 15025210471 0012110 0 ustar 00 PMS Name id " . $_SESSION['userID'];
$uID = $_SESSION['userID'];
}
include_once("../../../cfg/conn.php");
error_reporting(0);
if(isset($_POST['grp'])){
?>
| REC.
| CODE |
COMPANY |
Description |
|
";
echo "
";
?>
Viewing out of total records
| NO |
YEAR |
STATUS |
DESCRIPTION |
|
|
| ID |
KEY PERFORMANCE AREA (KRA) |
KEY PERFORMANCE INDICATOR (KPI) |
WEIGHT (%) |
B.MARK |
TARGET (%) / TARGET DESCRIPTION |
STRATEGY / MAJOR ACTIVITIES |
TIMELINE (FROM => TO |
RESPONSIBILITY |
|
template/saveNewOpsPlanEntry_subDivision.php 0000644 00000014570 15025210471 0015401 0 ustar 00 0){
$errorMessage = "Error: The selected KRA has already been added";
//echo '';
}else{
$sql = "INSERT INTO ops_data_subdivision(
`id`,
`pms_record_id`,
`ops_title_id`,
`ops_kra`,
`ops_kpi`,
`ops_weight`,
`ops_benchmark`,
`ops_target`,
`ops_target_desc`,
`ops_strategy`,
`ops_timeline_from`,
`ops_timeline_to`,
`ops_responsibility`,
`date_created`,
`created_by`,
`kra_code`,`kra_tag`)
VALUES ('',
'$SelectedRecordID',
'$opsPlanHeaderID',
'$opsKRA',
'$activeKPI',
'$activeKPIWeight',
'$kpiBenchMark',
'$kpiOpsTargetNumber',
'$kpiOpsTargetDesc',
'$kpiOpsStrategy',
'$opsTimelineStart',
'$opsTimelineEnd',
'$opsKPIResponsibility',
'$myTimeStamp',
'$userID','$kraCode','$kraTag')";
if ($conn->query($sql) === TRUE) {
//echo '';
$errorMessage = "Success: New record has been added";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
}
$getKRAList = "SELECT * FROM `ops_data_subdivision` WHERE `deleted`=0 AND `ops_title_id` ='$opsPlanHeaderID' ORDER BY `ops_kra` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRACode = "SELECT * FROM `kra_division_child_tbl` WHERE `deleted`='0' AND `id`='$opsKRA'";
$getMyKRACode = mysqli_query($conn,$getKRACode);
while($kra = mysqli_fetch_array($getMyKRACode)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_childdivision` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
echo "
";
echo "| ".$errorMessage." | ";
echo "
";
}
$conn->close();
}
?> saveNewOpsPlanEntry_Branch.php 0000644 00000014523 15025210471 0012463 0 ustar 00 0){
$errorMessage = "Error: The selected KRA has already been added";
//echo '';
}else{
$sql = "INSERT INTO ops_data_branch (
`id`,
`pms_record_id`,
`ops_title_id`,
`ops_kra`,
`ops_kpi`,
`ops_weight`,
`ops_benchmark`,
`ops_target`,
`ops_target_desc`,
`ops_strategy`,
`ops_timeline_from`,
`ops_timeline_to`,
`ops_responsibility`,
`date_created`,
`created_by`,
`kra_code`,`kra_tag`)
VALUES ('',
'$SelectedRecordID',
'$opsPlanHeaderID',
'$opsKRA',
'$activeKPI',
'$activeKPIWeight',
'$kpiBenchMark',
'$kpiOpsTargetNumber',
'$kpiOpsTargetDesc',
'$kpiOpsStrategy',
'$opsTimelineStart',
'$opsTimelineEnd',
'$opsKPIResponsibility',
'$myTimeStamp',
'$userID','$kraCode','$kraTag')";
if ($conn->query($sql) === TRUE) {
//echo '';
$errorMessage = "Success: New record has been added";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
}
$getKRAList = "SELECT * FROM `ops_data_branch` WHERE `deleted`=0 AND `ops_title_id` ='$opsPlanHeaderID' ORDER BY `ops_kra` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRACode = "SELECT * FROM `kra_branch_tbl` WHERE `deleted`='0' AND `id`='$opsKRA'";
$getMyKRACode = mysqli_query($conn,$getKRACode);
while($kra = mysqli_fetch_array($getMyKRACode)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_branch` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
echo "
";
echo "| ".$errorMessage." | ";
echo "
";
}
$conn->close();
}
?> loadPMSList_Branch.php 0000644 00000003500 15025210471 0010660 0 ustar 00 0){
while($row = mysqli_fetch_array($getArea)){
?>
".$row['deal_id']."";
echo "| ".$row['deal_code']." | ";
echo "".$row['deal_name']." | ";
echo "".$row['deal_address']." | ";
echo "";?>
";
echo " |
";
}
}
$conn->close();
}
?> deleteOpsPlanData_Area.php 0000644 00000006742 15025210471 0011544 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_data_area` WHERE `deleted`=0 AND `ops_title_id` ='$opsPlanHeaderID' ORDER BY `ops_kra` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRACode = "SELECT * FROM `kra_group_tbl` WHERE `deleted`='0' AND `id`='".$row['ops_kra']."'";
$getMyKRACode = mysqli_query($conn,$getKRACode);
while($kra = mysqli_fetch_array($getMyKRACode)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_group` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
}
$conn->close();
}
?> deleteOpsPlanHeader_Brand.php 0000644 00000004111 15025210471 0012225 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_brand_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> saveNewOpsPlanEntry_mainDivision.php 0000644 00000014556 15025210471 0013725 0 ustar 00 0){
$errorMessage = "Error: The selected KRA has already been added";
//echo '';
}else{
$sql = "INSERT INTO ops_data_maindivision(
`id`,
`pms_record_id`,
`ops_title_id`,
`ops_kra`,
`ops_kpi`,
`ops_weight`,
`ops_benchmark`,
`ops_target`,
`ops_target_desc`,
`ops_strategy`,
`ops_timeline_from`,
`ops_timeline_to`,
`ops_responsibility`,
`date_created`,
`created_by`,
`kra_code`,`kra_tag`)
VALUES ('',
'$SelectedRecordID',
'$opsPlanHeaderID',
'$opsKRA',
'$activeKPI',
'$activeKPIWeight',
'$kpiBenchMark',
'$kpiOpsTargetNumber',
'$kpiOpsTargetDesc',
'$kpiOpsStrategy',
'$opsTimelineStart',
'$opsTimelineEnd',
'$opsKPIResponsibility',
'$myTimeStamp',
'$userID','$kraCode','$kraTag')";
if ($conn->query($sql) === TRUE) {
//echo '';
$errorMessage = "Success: New record has been added";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
}
$getKRAList = "SELECT * FROM `ops_data_maindivision` WHERE `deleted`=0 AND `ops_title_id` ='$opsPlanHeaderID' ORDER BY `ops_kra` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRACode = "SELECT * FROM `kra_division_tbl` WHERE `deleted`='0' AND `id`='$opsKRA'";
$getMyKRACode = mysqli_query($conn,$getKRACode);
while($kra = mysqli_fetch_array($getMyKRACode)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_maindivision` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
echo "
";
echo "| ".$errorMessage." | ";
echo "
";
}
$conn->close();
}
?> viewOpsPlanSummary_Brand.php 0000644 00000003700 15025210471 0012205 0 ustar 00 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?>
saveNewOpsPlanHeader_Branch.php 0000644 00000004737 15025210471 0012560 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_branch_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> loadOpsPlanData_Area.php 0000644 00000007061 15025210471 0011214 0 ustar 00 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRAName = "SELECT * FROM `kra_group_tbl` WHERE `deleted`='0' AND `id`='".$row['ops_kra']."'";
$getMyKRAName = mysqli_query($conn,$getKRAName);
while($kra = mysqli_fetch_array($getMyKRAName)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_group` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
}
$conn->close();
}
?> kpiLoadOnChange_Company.php 0000644 00000001245 15025210471 0011730 0 ustar 00 --Select KPI --";
while($row = mysqli_fetch_array($getBranch)){
echo "";
}
$conn->close();
}
?> opssubDivision.php 0000644 00000132210 15025210471 0010271 0 ustar 00 PMS Name id " . $_SESSION['userID'];
$uID = $_SESSION['userID'];
}
include_once("../../../cfg/conn.php");
error_reporting(0);
if(isset($_POST['grp'])){
//==============================================================================================================
//VALIDATE ACCESS ==============================================================================================
//============================================================================================================== $roleID = userProfileID($userID);
include ("../functions/users.php");
$roleID = userProfileID($uID);
$moduleID = 34;
$add =checkViewAccessM1024($roleID, $moduleID)[1];
$edit =checkViewAccessM1024($roleID, $moduleID)[2];
$delete =checkViewAccessM1024($roleID, $moduleID)[3];
$print =checkViewAccessM1024($roleID, $moduleID)[4];
$download =checkViewAccessM1024($roleID, $moduleID)[5];
echo "";
echo "";
echo "";
echo "";
echo "";
if($add == 1){$addButton = '';}else{$addButton='Disabled';}
if($edit == 1){$editButton = '';}else{$editButton='Disabled';}
if($delete == 1){$deletButton = '';}else{$deletButton='Disabled';}
if($print == 1){$printButton = '';}else{$printButton='Disabled';}
if($download == 1){$downloadButton = '';}else{$downloadButton='Disabled';}
if(checkViewAccessM1024($roleID, $moduleID)[0] == 0){
echo " ![]()
";
echo " Access Denied
";
echo "
Sorry, you are not authorized to access this page.
Please contact your system support for assistance.
Thank you!
";
exit();
}
//==============================================================================================================
//VALIDATE ACCESS ==============================================================================================
//==============================================================================================================
?>
| REC.
| CODE |
COMPANY |
Description |
|
";
echo "
";
?>
Viewing out of total records
| NO |
YEAR |
STATUS |
DESCRIPTION |
|
|
|
|
| ID |
KEY PERFORMANCE AREA (KRA) |
KEY PERFORMANCE INDICATOR (KPI) |
WEIGHT (%) |
B.MARK |
TARGET (%) / TARGET DESCRIPTION |
STRATEGY / MAJOR ACTIVITIES |
TIMELINE (FROM => TO |
RESPONSIBILITY |
|
|
|
deleteOpsPlanData_Brand.php 0000644 00000006740 15025210471 0011720 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_data_brand` WHERE `deleted`=0 AND `ops_title_id` ='$opsPlanHeaderID' ORDER BY `ops_kra` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRACode = "SELECT * FROM `kra_brand` WHERE `deleted`='0' AND `id`='".$row['ops_kra']."'";
$getMyKRACode = mysqli_query($conn,$getKRACode);
while($kra = mysqli_fetch_array($getMyKRACode)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_brand` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
}
$conn->close();
}
?> deleteOpsPlanHeader_Area.php 0000644 00000004107 15025210471 0012054 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_area_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?> viewOpsPlanSummary_Autohub.php 0000644 00000003702 15025210471 0012570 0 ustar 00 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?>
saveNewOpsPlanEntry_subDivision.php 0000644 00000014570 15025210471 0013566 0 ustar 00 0){
$errorMessage = "Error: The selected KRA has already been added";
//echo '';
}else{
$sql = "INSERT INTO ops_data_subdivision(
`id`,
`pms_record_id`,
`ops_title_id`,
`ops_kra`,
`ops_kpi`,
`ops_weight`,
`ops_benchmark`,
`ops_target`,
`ops_target_desc`,
`ops_strategy`,
`ops_timeline_from`,
`ops_timeline_to`,
`ops_responsibility`,
`date_created`,
`created_by`,
`kra_code`,`kra_tag`)
VALUES ('',
'$SelectedRecordID',
'$opsPlanHeaderID',
'$opsKRA',
'$activeKPI',
'$activeKPIWeight',
'$kpiBenchMark',
'$kpiOpsTargetNumber',
'$kpiOpsTargetDesc',
'$kpiOpsStrategy',
'$opsTimelineStart',
'$opsTimelineEnd',
'$opsKPIResponsibility',
'$myTimeStamp',
'$userID','$kraCode','$kraTag')";
if ($conn->query($sql) === TRUE) {
//echo '';
$errorMessage = "Success: New record has been added";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
}
$getKRAList = "SELECT * FROM `ops_data_subdivision` WHERE `deleted`=0 AND `ops_title_id` ='$opsPlanHeaderID' ORDER BY `ops_kra` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>
".$row['id']."";
echo "| ";
$getKRACode = "SELECT * FROM `kra_division_child_tbl` WHERE `deleted`='0' AND `id`='$opsKRA'";
$getMyKRACode = mysqli_query($conn,$getKRACode);
while($kra = mysqli_fetch_array($getMyKRACode)){
if($border !=$row['ops_kra']){
echo $kra['kra_name'];
}
}
echo" | ";
echo "";
$getKPIName = "SELECT * FROM `kpi_childdivision` WHERE `deleted`='0' AND `id`='".$row['ops_kpi']."'";
$getMyKPIName = mysqli_query($conn,$getKPIName);
while($kpi = mysqli_fetch_array($getMyKPIName)){
echo $kpi['kpi_name'];
}
echo" | ";
echo "".$row['ops_weight']." | ";
echo "".$row['ops_benchmark']." | ";
echo "".$row['ops_target']." - ".$row['ops_target_desc']." | ";
echo "".$row['ops_strategy']." | ";
echo "".$row['ops_timeline_from']." - ".$row['ops_timeline_to']." | ";
echo "".$row['ops_responsibility']." | ";
echo "
| ";
echo "
";
$border = $row['ops_kra'];
}
echo "
";
echo "| ".$errorMessage." | ";
echo "
";
}
$conn->close();
}
?> viewOpsPlanSummary_mainDivision.php 0000644 00000003707 15025210471 0013617 0 ustar 00 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?>
saveNewOpsPlanHeader_Area.php 0000644 00000004733 15025210471 0012227 0 ustar 00 query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_area_level` WHERE `deleted`=0 AND `record_id` ='$SelectedRecordID' ORDER BY `coverage_year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
?>
".$row['id']."";
echo "| ".$row['coverage_year']." | ";
echo "".$row['status']." | ";
echo "".$row['description']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
}
$conn->close();
}
?>