<?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') {