$allDataInSheet = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);
$arrayCount = count($allDataInSheet);
// Here get total count of row in that Excel sheet
for ($i = 2; $i <= $arrayCount; $i++) {
$obsref = trim($allDataInSheet[$i]["A"]);
$reportname = trim($allDataInSheet[$i]["B"]);
$replaced = preg_replace('/[^\\x00-\\x7F]+/', '', $reportname);
//echo $replaced;
$process = trim($allDataInSheet[$i]["C"]);
$process = preg_replace('/[^\\x00-\\x7F]+/', '', $process);
$subprocess = trim($allDataInSheet[$i]["D"]);
$issuerating = trim($allDataInSheet[$i]["E"]);
$observation = trim($allDataInSheet[$i]["F"]);
//echo " ".$i." \n";
$risk = trim($allDataInSheet[$i]["G"]);
$recommendation = trim($allDataInSheet[$i]["H"]);
$managecomment = trim($allDataInSheet[$i]["I"]);
$responsibleperson = trim($allDataInSheet[$i]["J"]);
$agreeddate = trim($allDataInSheet[$i]["K"]);
//echo " ".$i." \n";
$closuredate = trim($allDataInSheet[$i]["M"]);
//echo " closure date is ".$closuredate." \n";
$status = trim($allDataInSheet[$i]["L"]);
// echo " ".$i." \n";
$comments = trim($allDataInSheet[$i]["N"]);
$sqlQuery = "insert into report(ObsRef,ReportName,Process,SubProcess,IssueRating,Observation,Risk,Recommendation,ManagComment,ResponsiblePerson,AgreedDate,ClosureDate,Status,Comments,Severity,Permission) values('" . $obsref . "','" . $replaced . "','" . $process . "','" . $subprocess . "','" . $issuerating . "','" . $observation . "','" . $risk . "','" . $recommendation . "','" . $managecomment . "','" . $responsibleperson . "','" . $agreeddate . "','" . $closuredate . "','" . $status . "','" . $comments . "','High','RO')";
$insert = $db->openCloseChartq2($sqlQuery);
$msg = 'Record has been added. <div style="Padding:20px 0 0 0;"></div>';
}
echo "<div style='font: bold 18px arial,verdana;padding: 45px 0 0 500px;'>" . $msg . "</div>";
include '../session.php';
$query1 = $db->openCloseChartUser($login_name);
}
$close = 0;
$open = 0;
$count = 0;
$var = array();
$data = array();
if ($query1) {
while ($obj = mysql_fetch_object($query1)) {
$var[$count] = $obj;
if ("admin" === strtolower($login_name) || "1" === $currentUserRow["Admin"] || "1" === $currentUserRow["Auditor"]) {
$q2 = "select Status from report where ReportName = '" . $var[$count]->ReportName . "'";
} else {
$q2 = "select Status from report where ReportName = '" . $var[$count]->ReportName . "' AND (ResponsiblePerson = '" . $login_name . "' OR ResponsiblePerson2 = '" . $login_name . "' OR ResponsiblePerson3 = '" . $login_name . "' OR ResponsiblePerson4 = '" . $login_name . "' OR ResponsiblePerson5 = '" . $login_name . "') ";
}
if ($query2 = $db->openCloseChartq2($q2)) {
while ($obj1 = mysql_fetch_object($query2)) {
if ($obj1->Status == 'Close') {
$close++;
}
if ($obj1->Status == 'Open' || $obj1->Status == 'open') {
$open++;
}
}
}
$data[$count] = array('name' => $obj->ReportName, 'closed' => $close, 'opened' => $open);
$count++;
$close = 0;
$open = 0;
}
echo json_encode($data);
