$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>"; }