<?php
include_once 'db_functions.php';
include 'session.php';
$db = new DB_Functions();
$currentUser = $db->getSingleUserByEmail($login_session);
$currentUserRow = mysql_fetch_array($currentUser);
if ("admin" === strtolower($login_name) || "1" === $currentUserRow["Admin"] || "1" === $currentUserRow["Auditor"]) {
$query1 = $db->openCloseChart();
} else {
$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') {
//var_dump($emailadress);
//$xyz = array('aname' => $emailadress[0]["email"] );
//echo json_encode($xyz);
// $data1 = array();
// $data1[0] = array('name'=>'Raja Ali Ehsan', 'email' => '*****@*****.**');
// $data1[1] = array('name'=>'Muhammad Shoaib Hasan', 'email' => '*****@*****.**');
//echo count($data1);
// $count = count($emailadress);
//echo $data[0]["name"];
//var_dump($data);
// for ($i=0;$i<$count;$i++)
// {
//echo $i;
//$respname= $emailadress[$i]['username'];
//echo $respname;
$query1 = $db->openCloseChartUser($respname);
$close = 0;
$open = 0;
$count = 0;
$var = array();
$data = array();
if ($query1) {
while ($obj = mysql_fetch_object($query1)) {
$var[$count] = $obj;
$q2 = "select Status from report where ReportName = '" . $var[$count]->ReportName . "' AND (ResponsiblePerson = '" . $respname . "' OR ResponsiblePerson2 = '" . $respname . "' OR ResponsiblePerson3 = '" . $respname . "' OR ResponsiblePerson4 = '" . $respname . "' OR ResponsiblePerson5 = '" . $respname . "') ";
if ($query2 = $db->openCloseChartq2($q2)) {
while ($obj1 = mysql_fetch_object($query2)) {
if ($obj1->Status == 'Close') {
$close++;
}
if ($obj1->Status == 'Open' || $obj1->Status == 'open') {
