$condition = " work_time = 24 ";
} else {
$condition = "status = " . $status;
}
$srs = mysqli_query($db_handle, "SELECT * FROM service_request WHERE " . $condition . " ORDER BY 'date' DESC; ");
while ($srsrow = mysqli_fetch_array($srs)) {
$id = $srsrow['id'];
$skill = mysqli_query($db_handle, "SELECT a.name, a.id FROM skill_name AS a JOIN skills AS b WHERE b.user_id = '{$id}'\n AND b.status = 'open' AND b.type = 'client' AND a.id = b.skill_id ;");
?>
<div class="list-group countRequest">
<p style="font-size:16px;padding-left: 2em;">
<a class="list-group-item" style="background-color:<?php
echo headerColor($srsrow['priority']);
?>
;border-color:<?php
echo headerColor($srsrow['priority']);
?>
;">
Client Name <span style="padding-left: 5em"><?php
echo $srsrow['name'];
?>
</span>
<span style="padding-left: 3em">ID : <?php
echo $srsrow['id'];
?>
</span>
<span style="padding-left: 3em">Creation Date : <?php
echo $srsrow['created_time'];
?>
</span></a>
<a class="list-group-item "> Mobile <span style="padding-left: 6em"><?php
<?php
session_start();
if (!isset($_SESSION['user_id'])) {
header('Location: index.php');
}
require_once "../components/dbConnection.php";
if (isset($_POST['sr_id'])) {
$sr_id = $_POST['sr_id'];
$srs = mysqli_query($db_handle, "SELECT * FROM service_request WHERE id = '{$sr_id}' ; ");
while ($srsrow = mysqli_fetch_array($srs)) {
$id = $srsrow['id'];
$skill = mysqli_query($db_handle, "SELECT a.name, a.id FROM skill_name AS a JOIN skills AS b WHERE b.user_id = '{$id}'\n AND b.status = 'open' AND b.type = 'client' AND a.id = b.skill_id ;");
$color = headerColor($srsrow['priority']);
$data .= "<div class='list-group'>\n\t <p style='font-size:16px;padding-left: 2em;'>\n\t <a class='list-group-item' style='background-color:" . $color . ";border-color:" . $color . ";'> \n Client Name <span style='padding-left: 5em'>" . strtoupper($srsrow['name']) . "</span>\n <span style='padding-left: 3em'> ID : " . $id . " </span>\n <span style='padding-left: 3em'> Creation Date : " . $srsrow['created_time'] . " </span></a>\n\t <a class='list-group-item'> Mobile <span style='padding-left: 6em'>" . $srsrow['mobile'] . "</span>\n <span style='padding-left: 3em'> Working Time : " . $srsrow['work_time'] . " Hours</span></a>\n\t <a class='list-group-item'> Address <span style='padding-left: 7em'>" . $srsrow['address'] . "</span></a>\n\t <a class='list-group-item'> Timings <span style='padding-left: 6em'>" . $srsrow['timings'] . "</span>\n <span style='padding-left: 3em'>Salary Criteria : " . $srsrow['min_salary'] . "-" . $srsrow['max_salary'] . " K </span></a>\n\t <a class='list-group-item'> Requirements <span style='padding-left: 5em'>" . $srsrow['requirements'] . "</span>\n <span style='padding-left: 3em'>Gender : " . $srsrow['gender'] . "</a>\n\t <a class='list-group-item'> Remarks <span style='padding-left: 7em'>" . $srsrow['remarks'] . "</span></a>\n\t <a class='list-group-item'> Worker Area <span style='padding-left: 5em'>" . $srsrow['worker_area'] . "</span></a>\n\t <a class='list-group-item'> Picked Date <span style='padding-left: 7em'>" . $srsrow['last_updated'] . "</span></a> \n\t <a class='list-group-item'> Skills <span style='padding-left: 7em'>";
while ($skillrow = mysqli_fetch_array($skill)) {
$data = $data . $skillrow['name'] . ", ";
}
$data = $data . "</span>\n </a>";
$meeting = mysqli_query($db_handle, "SELECT * FROM meetings WHERE match_id = '{$id}' ORDER BY meeting_time DESC LIMIT 0 , 1; ");
$meetingRow = mysqli_fetch_array($meeting);
if (mysqli_num_rows($meeting) != 0) {
$data = $data . " \n <a class='list-group-item'> Meeting Time <span style='padding-left: 5em'>" . $meetingRow['meeting_time'] . "</span></a>\n <a class='list-group-item'> Remarks <span style='padding-left: 7em'>" . $meetingRow['remarks'] . "</span></a>";
}
if ($srsrow['done_worker_id'] != 0) {
$worker = mysqli_query($db_handle, "SELECT b.* FROM service_request as a join workers as b WHERE a.id = '{$id}' AND a.done_worker_id = b.id ;");
$workerrow = mysqli_fetch_array($worker);
$data = $data . " \n <a class='list-group-item'> Done with worker <span style='padding-left: 4em'>" . strtoupper($workerrow['first_name']) . " " . strtoupper($workerrow['last_name']) . "</span></a>\n <a class='list-group-item'> Mobile No. <span style='padding-left: 7em'>" . $workerrow['phone'] . "</span></a>\n <a class='list-group-item'> Fixed Salary <span style='padding-left: 7em'>" . $srsrow['fixed_salary'] . "</span></a>";
$doneDate = mysqli_query($db_handle, "SELECT * FROM updates WHERE request_id = '{$id}' AND new_status = 'done' AND user_id = '{$user_id}'\n \t\t\t\t\t\t\t\t\t\t\t\t\t\t\tORDER BY update_time DESC LIMIT 0 , 1 ;");
$doneDaterow = mysqli_fetch_array($doneDate);
$data = $data . "\n \t\t <a class='list-group-item'> Done Date <span style='padding-left: 7em'>" . $doneDaterow['update_time'] . "</span></a>";
function fullmetagame($event)
{
$decks = $event->getDecks();
$players = array();
foreach ($decks as $deck) {
$info = array("player" => $deck->playername, "deckname" => $deck->name, "archetype" => $deck->archetype, "medal" => $deck->medal, "id" => $deck->id);
$arr = deckInfo($deck);
$info["colors"] = $arr[1];
if ($info['medal'] == "dot") {
$info['medal'] = "z";
}
$players[] = $info;
}
$db = Database::getConnection();
$succ = $db->query("CREATE TEMPORARY TABLE meta(\n\t\tplayer VARCHAR(40), deckname VARCHAR(40), archetype VARCHAR(20),\n\t\tcolors VARCHAR(10), medal VARCHAR(10), id BIGINT UNSIGNED,\n srtordr TINYINT UNSIGNED DEFAULT 0)");
$succ or die($db->error);
$stmt = $db->prepare("INSERT INTO meta(player, deckname, archetype,\tcolors, medal, id)\n VALUES(?, ?, ?, ?, ?, ?)");
for ($ndx = 0; $ndx < sizeof($players); $ndx++) {
$stmt->bind_param("sssssd", $players[$ndx]['player'], $players[$ndx]['deckname'], $players[$ndx]['archetype'], $players[$ndx]['colors'], $players[$ndx]['medal'], $players[$ndx]['id']);
$stmt->execute() or die($stmt->error);
}
$stmt->close();
$result = $db->query("SELECT colors, COUNT(player) AS cnt FROM meta GROUP BY(colors)");
$stmt = $db->prepare("UPDATE meta SET srtordr = ? WHERE colors = ?");
while ($row = $result->fetch_assoc()) {
$stmt->bind_param("ds", $row['cnt'], $row['colors']);
$stmt->execute() or die($stmt->error);
}
$stmt->close();
$result->close();
$result = $db->query("SELECT player, deckname, archetype, colors, medal, id, srtordr\n\t\tFROM meta ORDER BY srtordr DESC, colors, medal, player");
$color = "orange";
echo "<table style=\"border-width: 0px;\" align=\"center\">";
$hg = headerColor();
echo "<tr style=\"background-color: {$hg}\">";
echo "<td colspan=5 align=\"center\"><b>Metagame Breakdown</td></tr>\n";
while ($row = $result->fetch_assoc()) {
if ($row['colors'] != $color) {
$bg = rowColor();
$color = $row['colors'];
echo "<tr style=\"background-color: {$bg};\"><td>";
echo "<img src=\"/images/rename/{$color}.gif\"> </td>\n";
echo "<td colspan=4 align=\"left\"><i>{$row['srtordr']} Players ";
#echo "<img src=\"/images/rename/$color.gif\">\n";
echo "</td></tr>\n";
}
echo "<tr style=\"background-color: {$bg};\"><td></td>\n";
echo "<td align=\"left\">";
if ($row['medal'] != "z") {
echo "<img src=\"/images/{$row['medal']}.gif\"> ";
}
echo "</td>\n<td align=\"left\">";
echo "<a href=\"profile.php?player={$row['player']}\">";
echo "{$row['player']}</a></td>\n";
echo "<td align=\"left\">";
echo "<a href=\"deck.php?mode=view&id={$row['id']}\">";
echo "{$row['deckname']}</a></td>\n";
echo "<td align=\"right\">{$row['archetype']}</td></tr>\n";
}
$result->close();
echo "</table>\n";
}
if ($gender != 'any') {
$condition = " gender = '{$gender}' ";
} else {
$condition = " work_time = 0 ";
}
}
}
}
}
$request = mysqli_query($db_handle, "SELECT * FROM service_request WHERE " . $condition . " ;");
if (mysqli_num_rows($request) != 0) {
while ($requestRow = mysqli_fetch_array($request)) {
$id = $requestRow['id'];
$cem_id = $requestRow['cem_id'];
$me_id = $requestRow['me_id'];
$color = headerColor($requestRow['priority']);
$skill = mysqli_query($db_handle, "SELECT a.name, a.id FROM skill_name AS a JOIN skills AS b WHERE b.user_id = '{$id}'\n AND b.status = 'open' AND b.type = 'client' AND a.id = b.skill_id ;");
$data .= "<div class='list-group'>\n\t \t <p style='font-size:16px;padding-left: 2em;'>\n\t <a class='list-group-item' style='background-color:" . $color . ";border-color:" . $color . ";'>\n\t \tClient Name <span style='padding-left: 5em'>" . strtoupper($requestRow['name']) . "</span>\n\t <span style='padding-left: 3em'> ID : " . $id . " </span>\n\t <span style='padding-left: 3em'> Creation Date : " . $requestRow['created_time'] . " </span></a>\n\t <a class='list-group-item'> Mobile <span style='padding-left: 6em'>" . $requestRow['mobile'] . "</span>\n <span style='padding-left: 3em'> Working Time : " . $requestRow['work_time'] . " Hours</span></a>\n\t <a class='list-group-item'> Address <span style='padding-left: 7em'>" . $requestRow['address'] . "</span></a>\n\t <a class='list-group-item'> Timings <span style='padding-left: 6em'>" . $requestRow['timings'] . "</span>\n <span style='padding-left: 3em'>Salary Criteria : " . $requestRow['min_salary'] . "-" . $requestRow['max_salary'] . " K </span></a>\n\t <a class='list-group-item'> Requirements <span style='padding-left: 5em'>" . $requestRow['requirements'] . "</span>\n <span style='padding-left: 3em'>Gender : " . $requestRow['gender'] . "</a>\n\t <a class='list-group-item'> Remarks <span style='padding-left: 7em'>" . $requestRow['remarks'] . "</span></a>\n\t <a class='list-group-item'> Worker Area <span style='padding-left: 5em'>" . $requestRow['worker_area'] . "</span></a>\n\t <a class='list-group-item'> Picked Date <span style='padding-left: 7em'>" . $requestRow['last_updated'] . "</span></a> \n\t <a class='list-group-item'> Skills <span style='padding-left: 7em'>";
while ($skillrow = mysqli_fetch_array($skill)) {
$data = $data . $skillrow['name'] . ", ";
}
$data = $data . "</span>\n </a>";
if ($cem_id != 0) {
$cem = mysqli_query($db_handle, "SELECT * FROM user WHERE id = '{$cem_id}' ; ");
$cemRow = mysqli_fetch_array($cem);
$pickDate = mysqli_query($db_handle, "SELECT * FROM updates WHERE request_id = '{$id}' AND new_status = 'picked' \n AND user_id = '{$cem_id}' ORDER BY update_time DESC LIMIT 0 , 1 ;");
$pickDateRow = mysqli_fetch_array($pickDate);
$data = $data . "\n \t\t\t <a class='list-group-item ''> Picked By CEM <span style='padding-left: 5em'>" . strtoupper($cemRow['first_name']) . " " . strtoupper($cemRow['last_name']) . "</span></a>\n \t <a class='list-group-item '> Mobile <span style='padding-left: 8em'>" . $cemRow['phone'] . "</span></a>\n \t \t\t <a class='list-group-item'>Picked Date <span style='margin-left: 5em;''>" . $pickDateRow['update_time'] . "</span></a>";
}
if ($me_id != 0) {
$me = mysqli_query($db_handle, "SELECT * FROM user WHERE id = '{$me_id}' ; ");
function matchTable($player, $limit = 0)
{
if (!isset($_POST['format'])) {
$_POST['format'] = "%";
}
if (!isset($_POST['series'])) {
$_POST['series'] = "%";
}
if (!isset($_POST['season'])) {
$_POST['season'] = "%";
}
if (!isset($_POST['opp'])) {
$_POST['opp'] = "%";
}
$matches = $player->getFilteredMatches($_POST['format'], $_POST['series'], $_POST['season'], $_POST['opp']);
$hc = headerColor();
echo "<table style=\"border-width: 0px\" width=600>\n";
echo "<tr style=\"background-color: {$hc};\"><td><b>Event</td><td align=\"center\"><b>Round</td>";
echo "<td><b>Opponent</td>\n";
echo "<td><b>Deck</td>\n";
echo "<td align=\"center\"><b>Rating</td>\n";
echo "<td align=\"center\"><b>Result</td></tr>\n";
$oldname = "";
foreach ($matches as $match) {
$rnd = $match->round;
if ($match->timing == 2 && $match->type == "Single Elimination") {
$rnd = "T" . pow(2, $match->rounds + 1 - $match->round);
}
$opp = $match->otherPlayer($player->name);
$res = "Draw";
$color = "#FF9900";
if ($match->playerWon($player->name)) {
$res = "Win";
$color = "#009900";
}
if ($match->playerLost($player->name)) {
$res = "Loss";
$color = "#FF0000";
}
$opponent = new Player($opp);
$event = $match->getEvent();
$oppRating = $opponent->getRating("Composite", $event->start);
$oppDeck = $opponent->getDeckEvent($event->name);
$deckStr = "No Deck Found";
if (!is_null($oppDeck)) {
$deckStr = "<a href=\"deck.php?mode=view&id={$oppDeck->id}\">" . "{$oppDeck->name}</a>";
}
if ($oldname != $event->name) {
$bg = rowColor();
echo "<tr style=\"background-color: {$bg}\"><td>{$event->name}</td>";
} else {
echo "<tr style=\"background-color: {$bg};\"><td></td>\n";
}
$oldname = $event->name;
echo "<td align=\"center\">{$rnd}</td>\n";
echo "<td><a href=\"profile.php?player={$opp}\">{$opp}</a></td>\n";
echo "<td>{$deckStr}</td>\n";
echo "<td align=\"center\">{$oppRating}</td>\n";
echo "<td align=\"center\"><b><font color=\"{$color}\">{$res}</font>";
echo "</td></tr>\n";
}
echo "</table>";
}
