function session_validate($session_type)
{
require_once '../classes/db.class.php';
$conn = new db();
$dbcon = $conn->dbConnect();
$i = 0;
$sql = "SELECT team_id FROM amz_teams";
$result = $conn->runsql($sql, $dbcon);
while ($result_row = mysqli_fetch_object($result)) {
$user_team_id[] = $result_row->team_id;
$i++;
}
if ($session_type == "sda") {
define("USER_ID", $_SESSION['sda_id'], TRUE);
define("USER_NAME", $_SESSION['sda_name'], TRUE);
define("USER_FIRST_NAME", $_SESSION['sda_first_name'], TRUE);
define("USER_MAIL", $_SESSION['sda_mail'], TRUE);
define("USER_TEAMS", json_encode($_SESSION['team_id']), TRUE);
define("USER_TOT_TEAMS", $_SESSION['sda_team_count'], TRUE);
} elseif ($session_type == "manager") {
define("USER_ID", $_SESSION['manager_id'], TRUE);
define("USER_NAME", $_SESSION['manager_name'], TRUE);
define("USER_FIRST_NAME", $_SESSION['manager_first_name'], TRUE);
define("USER_MAIL", $_SESSION['manager_mail'], TRUE);
define("USER_TEAMS", json_encode($_SESSION['team_id']), TRUE);
define("USER_TOT_TEAMS", $_SESSION['manager_team_count'], TRUE);
} elseif ($session_type == "admin") {
define("USER_ID", $_SESSION['admin_id'], TRUE);
define("USER_NAME", $_SESSION['admin_name'], TRUE);
define("USER_FIRST_NAME", $_SESSION['admin_first_name'], TRUE);
define("USER_MAIL", $_SESSION['admin_mail'], TRUE);
define("USER_TEAMS", json_encode($user_team_id), TRUE);
define("USER_TOT_TEAMS", $i, TRUE);
} else {
header("location:../");
}
}
require_once '../classes/db.class.php';
$conn = new db();
$host_name = $_SERVER['REMOTE_ADDR'];
//gethostbyaddr($_SERVER['REMOTE_ADDR']);
$dbcon = $conn->dbConnect();
session_start();
$fail_msg = $success_msg = '';
//print_r($_POST);
if (isset($_GET) && $_POST['uname'] != "") {
$uname = $_POST['uname'];
$team = explode(",", $_POST['teams']);
$team_count = sizeof($team);
$gepassword = gen_md5_password(8);
$password = md5($gepassword);
$query = "SELECT * FROM amz_login WHERE user_name='{$uname}'";
$result = $conn->runsql($query, $dbcon);
if (mysqli_num_rows($result)) {
$result_row = mysqli_fetch_object($result);
if ($result_row->user_deletion == '0') {
$fail_msg = "Username already exist!";
} else {
if ($result_row->user_deletion == '1') {
$user_mail = $uname . "@amazon.com";
$query_update_user = "******";
$result_update = $conn->runsql($query_update_user, $dbcon);
if ($result_update) {
$success_msg = "User request sent.";
$query_insert_user_teams = "SELECT user_id FROM amz_login WHERE user_name='{$uname}'";
$result_insert_user_teams = $conn->runsql($query_insert_user_teams, $dbcon);
$result_row_insert_user_teams = mysqli_fetch_object($result_insert_user_teams);
$user_id = $result_row_insert_user_teams->user_id;
$year = $_POST['year'];
if ($year == "") {
?>
<div style="text-align: center;">Select the year!</div>
<?php
die;
}
$month_array = array(1 => "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
?>
<table width="100%" class="my_table">
<tr class="tbl_header">
<td colspan="25" align="center">Bandwidth Utilization</td>
</tr>
<?php
$query_1 = "SELECT team_id,team_name FROM amz_teams ORDER BY team_name ASC";
$result_1 = $conn->runsql($query_1, $dbcon);
if (mysqli_num_rows($result_1)) {
while ($result_row_1 = mysqli_fetch_object($result_1)) {
?>
<tr class="head_row" style="background-color: #EBEBEB;" onclick="view_report_2_get_full_info(<?php
echo $result_row_1->team_id;
?>
);" id="master_row_<?php
echo $result_row_1->team_id;
?>
">
<td colspan="25">
<?php
echo $result_row_1->team_name;
?>
</td>
<?php
require_once '../classes/db.class.php';
$conn = new db();
$dbcon = $conn->dbConnect();
if (isset($_GET['action'])) {
$id = $_POST['id'];
$sql1 = "DELETE FROM user_tasks WHERE task_id = '{$id}'";
$result1 = $conn->runsql($sql1, $dbcon);
if ($result1) {
echo "<font color='green'>Task deleted Successfully</font>";
} else {
echo "<font color='red'>Something went wrong!</font>";
}
}
<?php
//
session_start();
include_once '../sda/data_page.php';
require_once '../classes/db.class.php';
$conn = new db();
$dbcon = $conn->dbConnect();
$rows = array();
//flag is not needed
$flag = true;
$table = array();
$table['cols'] = array(array('label' => 'Weekly Task', 'type' => 'string'), array('label' => 'Percentage', 'type' => 'number'));
$rows = array();
$query_2 = "SELECT time,count,wu FROM user_tasks limit 1,10";
$result_2 = $conn->runsql($query_2, $dbcon);
while ($result_row_2 = mysqli_fetch_object($result_2)) {
$temp = array();
// the following line will be used to slice the Pie chart
$temp[] = array('v' => (string) $result_row_2->count);
// Values of each slice
$temp[] = array('v' => (int) $result_row_2->wu);
$rows[] = array('c' => $temp);
}
$table['rows'] = $rows;
print_r($table);
$jsonTable = json_encode($table);
//echo $jsonTable;
?>
<html>
require_once _BACK_TO_PRE_ . DB_CLASS . DB_CLASS_FILE;
$conn = new db();
$dbcon = $conn->dbConnect();
$editing_id = $_POST['editing_id'];
$p_team = $_POST['p_team'];
$a_team = $_POST['a_team'];
$p_team_array = explode(",", $p_team);
$a_team_array = explode(",", $a_team);
if (array_diff($p_team_array, $a_team_array)) {
$result[0] = "F";
$result[1] = "Parent team should be present in available team!";
echo json_encode($result);
exit;
}
$query_p_team = "DELETE FROM amz_pteam_info WHERE user_id='{$editing_id}'";
$result_p_team = $conn->runsql($query_p_team, $dbcon);
if ($result_p_team) {
for ($i = 0; $i < sizeof($p_team_array); $i++) {
$query_p_team_insert = "INSERT INTO amz_pteam_info(user_id,team_id,start_date) VALUES ('{$editing_id}','{$p_team_array[$i]}',now())";
$conn->runsql($query_p_team_insert, $dbcon);
}
}
$query_a_team = "DELETE FROM amz_user_info WHERE user_id='{$editing_id}'";
$result_a_team = $conn->runsql($query_a_team, $dbcon);
if ($result_a_team) {
for ($i = 0; $i < sizeof($a_team_array); $i++) {
$query_a_team_insert = "INSERT INTO amz_user_info(user_id,team_id) VALUES ('{$editing_id}','{$a_team_array[$i]}')";
$conn->runsql($query_a_team_insert, $dbcon);
}
}
if ($result_a_team && $result_p_team) {
function get_teams($user_id, $team_array)
{
require_once '../classes/db.class.php';
$conn = new db();
$dbcon = $conn->dbConnect();
$teams = "";
$query = "SELECT team_id FROM amz_user_info WHERE user_id='{$user_id}' AND status='1'";
$result = $conn->runsql($query, $dbcon);
$i = 1;
if (mysqli_num_rows($result)) {
while ($result_row = mysqli_fetch_object($result)) {
$teams .= $team_array[$result_row->team_id] . ", ";
}
return rtrim($teams, ", ");
} else {
return "No teams available";
}
}
//include_once './data_page.php';
//print_r($_GET);
//print_r($_SESSION);
die("<center>Under maintenance!");
require_once '../classes/db.class.php';
$conn = new db();
$dbcon = $conn->dbConnect();
session_start();
$edited_by = $_SESSION['admin_id'];
$subject = $_GET['subject'];
$edit_item = $_GET['val'];
switch ($subject) {
case "team":
//echo "team edit".$edit_item;
$query_team_edit_select = "SELECT team_id,team_name FROM amz_teams WHERE team_id='{$edit_item}'";
$result_1 = $conn->runsql($query_team_edit_select, $dbcon);
$result_row_1 = mysqli_fetch_object($result_1);
?>
<form >
<div class="row">
<div class="small-12 columns"><center><span id="final_msg"></span></center></div>
<div class="small-12 columns">
<div class="row">
<div class="small-3 columns"><label class="left inline">Team name: </label></div>
<div class="row collapse">
<div class="small-7 columns">
<input type="text" placeholder="Team name" value="<?php
echo $result_row_1->team_name;
?>
<?php
require_once '../classes/db.class.php';
$conn = new db();
$dbcon = $conn->dbConnect();
session_start();
$fail_msg = $success_msg = '';
if (isset($_GET) && $_POST['uname'] != "" && $_POST['pass'] != "") {
$uname = $_POST['uname'];
$pass = $_POST['pass'];
$i = 0;
$uname = mysqli_real_escape_string($dbcon, $uname);
$pass = mysqli_real_escape_string($dbcon, $pass);
$pass = md5($pass);
$query = "SELECT * FROM amz_login WHERE user_name='{$uname}' AND user_deletion='0'";
$result = $conn->runsql($query, $dbcon);
if (mysqli_num_rows($result)) {
$result_row = mysqli_fetch_object($result);
if ($result_row->password == $pass) {
if (!$result_row->user_activation) {
$fail_msg = "<font color='red'>Your request not yet validated!</font>";
} elseif (!$result_row->user_status) {
$fail_msg = "<font color='red'>Your account was blocked!</font>";
} else {
if ($result_row->user_type == 1) {
$success_msg = 'U';
$_SESSION['session_type'] = "user";
$_SESSION['user_name'] = $uname;
//user's name
$_SESSION['user_id'] = $result_row->user_id;
//auto_incremented id
<tr id="data_header" align="center">
<td >S.No.</td>
<td>Team</td>
<td>Time</td>
<td>Count</td>
<td>Work units</td>
</tr></thead>
<?php
$i = 1;
$tot_time = "";
$tot_count = 0;
$secs = 0;
$tot_work_units = 0.0;
if ($team == "") {
$query_unique_team_query = "SELECT DISTINCT team_id FROM user_tasks_ot WHERE " . $where_1 . " ORDER BY team_id ASC";
$result_unique_team = $conn->runsql($query_unique_team_query, $dbcon);
while ($result_row = mysqli_fetch_object($result_unique_team)) {
$unique_team = $result_row->team_id;
$query = "SELECT time,count,wu FROM user_tasks_ot WHERE team_id='{$unique_team}' AND " . $where_1;
$result = $conn->runsql($query, $dbcon);
while ($result_row = mysqli_fetch_object($result)) {
$tot_count += $result_row->count;
$secs += strtotime($result_row->time) - strtotime("00:00:00");
$tot_work_units += $result_row->wu;
}
echo $i % 2 == 0 ? "<tr id='data_row_even' align=center>" : "<tr id='data_row_odd' align=center>";
?>
<td><?php
echo $i++;
?>
</td>
$task_query = " task_id IN ({$task}) AND ";
$subtitle = "and task(s)";
} else {
$task_query = "";
}
$where_1 = "team_id='{$team}' AND date BETWEEN '{$date_from}' AND '{$date_to}'";
if ($user != "null") {
$where_1 .= " AND user_id IN ({$user}) ";
$subtitle .= " and user(s)";
}
$output['result_status'] = "S";
$output['title'] = "Report between {$date_from} and {$date_to}";
$task_list = $actual_list = $target_list = $user_wu_tot = $daily_target_temp = $daily_target_temp_in_wu = $daily_target_temp_in_wu_in_per = $wu_avg = $tot_wu = $tot_time = "";
$max = 100;
$query_1 = "SELECT task_id,task_name,about_chart FROM amz_tasks WHERE team_id='{$team}' AND {$task_query} about_chart != 0 ORDER BY `task_name` ASC";
$result_1 = $conn->runsql($query_1, $dbcon);
while ($result_row_1 = mysqli_fetch_object($result_1)) {
if ($result_row_1->about_chart == 1) {
$task_id = $result_row_1->task_id;
$tot_count = $tot_count_ot = 0;
$secs = $secs_ot = 0;
$tot_work_units = $tot_work_units_ot = 0.0;
$query_2 = "SELECT time,count,wu FROM user_tasks WHERE tasks_id='{$task_id}' AND " . $where_1;
$result_2 = $conn->runsql($query_2, $dbcon);
while ($result_row_2 = mysqli_fetch_object($result_2)) {
$tot_count += $result_row_2->count;
$secs += strtotime($result_row_2->time) - strtotime("00:00:00");
$tot_work_units += $result_row_2->wu;
}
$query_ot = "SELECT time,count,wu FROM user_tasks_ot WHERE tasks_id='{$task_id}' AND " . $where_1 . " AND ot_status='1'";
$result_ot = $conn->runsql($query_ot, $dbcon);
<th>Feb</th>
<th>Mar</th>
<th>Apr</th>
<th>May</th>
<th>Jun</th>
<th>Jul</th>
<th>Aug</th>
<th>Sep</th>
<th>Oct</th>
<th>Nov</th>
<th>Dec</th>
</tr>
<?php
$sql = "SELECT DISTINCT sub_task_id FROM amz_dc_units WHERE month like '%{$years}%' AND task_id='{$task_id}'";
$result = $conn->runsql($sql, $dbcon);
if (mysqli_num_rows($result)) {
while ($result_row = mysqli_fetch_object($result)) {
$sub_task = $result_row->sub_task_id;
echo "<tr><td>";
echo "<b>" . $sub_task_array[$sub_task] . "</b>";
echo "</td>";
for ($i = 2; $i < 7; $i++) {
?>
<tr><td></td><td align="center"><?php
echo $i;
?>
</td>
<?php
for ($months = 1; $months <= 12; $months++) {
echo "<td>";
<tr class="tbl_header">
<td>Users\Month</td>
<?php
for ($i = 1; $i < sizeof($month_array); $i++) {
echo "<td>" . substr($month_array[$i], 0, 3) . " Act</td>";
echo "<td>" . substr($month_array[$i], 0, 3) . " Fcst</td>";
}
?>
<td>Avg Act</td>
</tr>
<?php
$secs = $secs_ot = 0;
$wu = $wu_ot = 0.0;
$daily_target = 0;
$query_1 = "SELECT team_id,team_name FROM amz_teams WHERE team_id='{$team}' ORDER BY team_name ASC";
$result_1 = $conn->runsql($query_1, $dbcon);
if (mysqli_num_rows($result_1)) {
while ($result_row_1 = mysqli_fetch_object($result_1)) {
$tr_color_decide_check = 0;
$team_id = $result_row_1->team_id;
$query_get_users = "SELECT DISTINCT user_id FROM amz_user_info WHERE team_id='{$team_id}'";
$result_get_users = $conn->runsql($query_get_users, $dbcon);
if (mysqli_num_rows($result_get_users)) {
while ($result_row_get_users = mysqli_fetch_object($result_get_users)) {
$user_id = $result_row_get_users->user_id;
$tr_txt = $tr_color_decide_check % 2 == 0 ? "even" : "odd";
echo "<tr class='project_{$tr_txt}'><td>" . $user_array[$user_id] . "</td>";
$tr_color_decide_check++;
$avg_act = $avg_fcst = $count = 0;
$size = sizeof($month_array);
for ($i = 1; $i < $size; $i++) {
<?php
require_once '../classes/db.class.php';
$conn = new db();
$dbcon = $conn->dbConnect();
if (isset($_GET['action'])) {
//print_r($_POST);
$id = $_POST['id'];
$status_tmp = $_POST['status'];
$status = $status_tmp == 'A' ? " user_activation='1', user_status='1' " : " user_deletion='1' ";
$sql1 = "UPDATE amz_login SET {$status} WHERE user_id='{$id}'";
$result1 = $conn->runsql($sql1, $dbcon);
if ($result1) {
echo "<font color='green'>User updation complete!</font>";
$query_getemail = "SELECT user_mail FROM amz_login where user_id='{$id}'";
$result_1 = $conn->runsql($query_getemail, $dbcon);
$user_mail = mysqli_fetch_object($result_1);
$address = $user_mail->user_mail;
$body = "Your account is activated! Please login and change your password!";
date_default_timezone_set('America/Toronto');
require_once '../includes/class.phpmailer.php';
$mail = new PHPMailer();
$mail->IsSMTP();
// $mail->Host = "smtp.amazon.com";
$mail->SMTPDebug = false;
$mail->SMTPAuth = true;
// $mail->SMTPSecure = "ssl";
$mail->Host = "smtp.amazon.com";
$mail->Port = 25;
$mail->Username = "******";
// $mail->Password = "******";
<a href="#" class="close">×</a>
</div>-->
</td>
</tr>
<tr>
<td width="50%">Field</td>
<td>Value</td>
</tr>
<tr>
<td>Parent team:</td>
<td>
<?php
$parent_teams = array();
$query_parent_team = "SELECT team_id FROM amz_pteam_info WHERE user_id='{$user_id}'";
$result_parent_team = $conn->runsql($query_parent_team, $dbcon);
while ($result_row_parent_team = mysqli_fetch_object($result_parent_team)) {
$parent_teams[] = $result_row_parent_team->team_id;
}
?>
<select id="p_team" multiple="multiple" placeholder=" -- Parent team --" class="teams">
<?php
$teams = json_decode(USER_TEAMS);
foreach ($teams as $key => $value) {
?>
<option value="<?php
echo $value;
?>
" <?php
if (in_array($value, $parent_teams)) {
echo "Selected";
<?php
require_once '../classes/db.class.php';
$conn = new db();
$dbcon = $conn->dbConnect();
$team_id = $team_name = $task_id = $task_name = $user_id = $user_name = $sub_task_name = $sub_task_id = $task_desc_id = $task_desc_name = $user_type_id = $user_type_name = $build = $build_name = $release = $release_name = array();
//$team_id=$team_name=$task_id=$task_name=$user_id=$user_name=$sub_task_id=$sub_task_name=$task_desc_id=$task_desc_name=array();
$audit_task = $audit_task_name = $imapct_array = $audit_task_array = array();
$query_1 = "SELECT team_id,team_name FROM amz_teams";
$result = $conn->runsql($query_1, $dbcon);
if (mysqli_num_rows($result)) {
while ($result_row = mysqli_fetch_object($result)) {
$team_id[] = $result_row->team_id;
$team_name[] = $result_row->team_name;
}
}
$team_array = array_combine($team_id, $team_name);
$query_2 = "SELECT task_id,task_name FROM amz_tasks";
$result = $conn->runsql($query_2, $dbcon);
if (mysqli_num_rows($result)) {
while ($result_row = mysqli_fetch_object($result)) {
$task_id[] = $result_row->task_id;
$task_name[] = $result_row->task_name;
}
}
$task_array = array_combine($task_id, $task_name);
$query_3 = "SELECT user_id,user_name FROM amz_login";
$result = $conn->runsql($query_3, $dbcon);
if (mysqli_num_rows($result)) {
while ($result_row = mysqli_fetch_object($result)) {
$user_id[] = $result_row->user_id;
<?php
//include_once '../includes/session_admin.php';
require_once '../classes/db.class.php';
$conn = new db();
$dbcon = $conn->dbConnect();
session_start();
if ($_POST['task_id'] != "" && $_POST['status'] != "") {
$task_id = $_POST['task_id'];
$status = $_POST['status'];
$cmds = $_POST['cmds'];
$user_id = $_SESSION['admin_id'];
$query_update_ot_status = "UPDATE user_tasks_ot SET ot_status={$status},act_by='{$user_id}',admin_cmds='{$cmds}' WHERE task_id='{$task_id}'";
$result_update_ot_status = $conn->runsql($query_update_ot_status, $dbcon);
if ($result_update_ot_status) {
echo "OT status updated!";
} else {
echo "OT updation failed!";
}
} else {
echo "Internal error occured! Try again laater.";
}
<?php
require_once '../includes/define.php';
require_once _BACK_TO_PRE_ . DB_CLASS . DB_CLASS_FILE;
require_once _BACK_TO_PRE_ . _INCLUDE . SESSION_FILE;
$conn = new db();
$dbcon = $conn->dbConnect();
$date = $_POST['date'];
$team = $_POST['team'];
$user = $_POST['user'];
$audit = $_POST['audit'];
$task = $_POST['task'];
$misses = $_POST['misses'];
$impact = $_POST['impact'];
$comments = $_POST['comments'];
$good_catches = $_POST['good_catches'];
$added_by = USER_ID;
$query_add_cf = "INSERT INTO amz_audits(date,team,user,task,audit,misses,impact,comments,good_catches,created_by) VALUES ('{$date}','{$team}','{$user}','{$task}','{$audit}','{$misses}','{$impact}','{$comments}','{$good_catches}','{$added_by}')";
$result_add_cf = $conn->runsql($query_add_cf, $dbcon);
if ($result_add_cf) {
$result[0] = "S";
$result[1] = "Added succssfully";
} else {
$result[0] = "F";
$result[1] = "Internal error occured! Try again later!";
}
echo json_encode($result);
//print_r($result);
<?php
require_once '../classes/db.class.php';
$conn = new db();
$dbcon = $conn->dbConnect();
session_start();
$edited_by = $_SESSION['admin_id'];
$subject = $_GET['action'];
switch ($subject) {
case "team":
$edit_id = $_POST['id'];
$query_delete = "UPDATE amz_teams SET team_deletion='1',last_modify=now() WHERE team_id='{$edit_id}'";
$result_update = $conn->runsql($query_delete, $dbcon);
break;
case "task":
$edit_id = $_POST['id'];
$query_delete = "UPDATE amz_tasks SET deletion='1',last_modified_by='{$edited_by}' WHERE task_id='{$edit_id}'";
$result_update = $conn->runsql($query_delete, $dbcon);
break;
case "subtask":
$edit_id = $_POST['id'];
$query_delete = "UPDATE amz_sub_tasks SET deletion='1',last_modify_by='{$edited_by}' WHERE sub_task_id='{$edit_id}'";
$result_update = $conn->runsql($query_delete, $dbcon);
break;
case "taskdes":
$edit_id = $_POST['id'];
$query_delete = "UPDATE amz_task_desc SET deletion='1' WHERE tdi_no='{$edit_id}'";
$result_update = $conn->runsql($query_delete, $dbcon);
break;
default:
echo "Internal server error!";
<th>Apr</th>
<th>May</th>
<th>Jun</th>
<th>Jul</th>
<th>Aug</th>
<th>Sep</th>
<th>Oct</th>
<th>Nov</th>
<th>Dec</th>
<?php
}
?>
</tr>
<?php
$query_load_teams = "SELECT team_name,team_id FROM amz_teams WHERE team_id IN({$team_text}) ORDER BY team_name ASC";
$result_load_teams = $conn->runsql($query_load_teams, $dbcon);
if (mysqli_num_rows($result_load_teams)) {
while ($result_row_load_teams = mysqli_fetch_object($result_load_teams)) {
$team_id = $result_row_load_teams->team_id;
$query_load_tasks = "SELECT task_name,task_id,device_count FROM amz_tasks WHERE team_id={$team_id} ORDER BY have_st DESC, task_name Asc";
$result_load_tasks = $conn->runsql($query_load_tasks, $dbcon);
if (mysqli_num_rows($result_load_tasks)) {
while ($result_row_load_tasks = mysqli_fetch_object($result_load_tasks)) {
$task_id = $result_row_load_tasks->task_id;
$query_load_sub_tasks = "SELECT sub_task_name,sub_task_id FROM amz_sub_tasks WHERE task_id={$task_id} ORDER BY sub_task_name ASC";
$result_load_sub_tasks = $conn->runsql($query_load_sub_tasks, $dbcon);
?>
<tr>
<td rowspan="<?php
echo mysqli_num_rows($result_load_sub_tasks) + 1;
?>
<?php
//include_once '../includes/session_admin.php';
require_once '../classes/db.class.php';
$conn = new db();
$dbcon = $conn->dbConnect();
$query_get_tasks = "select user_id,user_name FROM amz_login WHERE user_type='1' ORDER BY user_name ASC";
$result_get_tasks = $conn->runsql($query_get_tasks, $dbcon);
echo '<option value="">-- Select All--</option>';
if (mysqli_num_rows($result_get_tasks)) {
while ($result_tasks = mysqli_fetch_object($result_get_tasks)) {
?>
<option value="<?php
echo $result_tasks->user_id;
?>
"><?php
echo $result_tasks->user_name;
?>
</option>
<?php
}
}
<?php
require_once '../classes/db.class.php';
$conn = new db();
$dbcon = $conn->dbConnect();
session_start();
$edited_by = $_SESSION['sda_id'];
$subject = $_GET['action'];
switch ($subject) {
case "team":
$edit_id = $_POST['id'];
$edit_value = mysqli_real_escape_string($dbcon, $_POST['value']);
$query_update_team = "UPDATE amz_teams SET team_name='{$edit_value}',last_modify=now() WHERE team_id='{$edit_id}'";
$result_update = $conn->runsql($query_update_team, $dbcon);
break;
case "task":
// print_r($_POST);
$edit_id = $_POST['id'];
$edit_value = mysqli_real_escape_string($dbcon, $_POST['value']);
$have_cf = $_POST['have_cf'];
$auto_cf = $_POST['auto_cf'];
$have_st = $_POST['have_st'];
$have_td = $_POST['have_td'];
$op = $_POST['op'];
$tdi_type = $have_td == 1 ? '1' : '0';
$query_update_team = "UPDATE amz_tasks SET task_name='{$edit_value}',cf_avail='{$have_cf}',auto_cf='{$auto_cf}',have_st='{$have_st}',have_tdi='{$have_td}',tdi_type='{$tdi_type}',op_type='{$op}',last_modified_by='{$edited_by}' WHERE task_id='{$edit_id}'";
$result_update = $conn->runsql($query_update_team, $dbcon);
break;
case "subtask":
$edit_id = $_POST['id'];
$edit_value = mysqli_real_escape_string($dbcon, $_POST['value']);
<?php
require_once '../classes/db.class.php';
include '../includes/time_calc.php';
$conn = new db();
$dbcon = $conn->dbConnect();
$query = "SELECT month FROM amz_dt_manage WHERE con_fac_updation=0";
$result = $conn->runsql($query, $dbcon);
while ($result_row = mysqli_fetch_object($result)) {
$month = $result_row->month;
$query_1 = "SELECT team_id FROM amz_teams WHERE team_deletion='0' AND status='1'";
$result_1 = $conn->runsql($query_1, $dbcon);
while ($result_row_1 = mysqli_fetch_object($result_1)) {
$team = $result_row_1->team_id;
$query_2 = "SELECT task_id,have_complexity,about_cf,device_count FROM amz_tasks WHERE deletion='0' AND have_st='1' AND status='1' AND team_id='{$team}'";
//AND about_cf='1'
$result_2 = $conn->runsql($query_2, $dbcon);
while ($result_row_2 = mysqli_fetch_object($result_2)) {
$task = $result_row_2->task_id;
if (!$result_row_2->have_complexity) {
$query_3 = "SELECT sub_task_id,about_cf FROM amz_sub_tasks WHERE deletion='0' AND task_status='1' AND task_id='{$task}'";
//AND about_cf='1'
$result_3 = $conn->runsql($query_3, $dbcon);
while ($result_row_3 = mysqli_fetch_object($result_3)) {
$sub_task = $result_row_3->sub_task_id;
$about_cf = $result_row_3->about_cf;
$cf_updated = $about_cf == 1 ? 0 : 1;
if ($about_cf == "") {
$about_cf = 'NULL';
}
$query_check_exist = "SELECT * FROM amz_daily_target WHERE month_from='{$month}' AND team='{$team}' AND task='{$task}' AND sub_task='{$sub_task}'";
<?php
require_once '../classes/db.class.php';
$conn = new db();
$dbcon = $conn->dbConnect();
session_start();
$fail_msg = $success_msg = '';
if (isset($_GET)) {
$uid = $_SESSION['admin_id'];
$uname = $_SESSION['admin_name'];
$old_password = md5($_POST['oldpass']);
$new_password = $_POST['newpass'];
$confirm_password = $_POST['confirmpass'];
$query = "SELECT password FROM amz_login WHERE user_name='{$uname}'";
$result = $conn->runsql($query, $dbcon);
if (mysqli_num_rows($result)) {
list($password) = mysqli_fetch_array($result);
}
if ($password != $old_password) {
$fail_msg = "Incorrect old password";
} else {
if ($new_password != $confirm_password) {
$fail_msg = "Old and New password Mismatch";
} else {
$new_password = md5($new_password);
$query_update_user = "******";
$result_update = $conn->runsql($query_update_user, $dbcon);
if ($result_update) {
$success_msg = "Password updated successfully";
} else {
$fail_msg = "Password Failed! Pls try later.";
$conn = new db();
$dbcon = $conn->dbConnect();
session_start();
$team = $_POST['team'];
$task = $_POST['task'];
$stask = $_POST['stask'];
$td = $_POST['td'];
$added_by = $_SESSION['admin_id'];
if ($team == "" || $task == "" || $stask == "" || $td == "") {
$result[0] = "F";
$result[1] = "Fill the all details!";
echo json_encode($result);
exit;
}
$query_check = "SELECT task_info FROM amz_task_desc WHERE task_info='{$td}' AND task_id='{$task}'";
$result_check = $conn->runsql($query_check, $dbcon);
if (mysqli_num_rows($result_check)) {
$result[0] = "F";
$result[1] = "Task description already exist!";
echo json_encode($result);
exit;
}
$query_add_cf = "INSERT INTO amz_task_desc(task_id,task_info,added_by,status,deletion,create_date,maintain_date) VALUES ('{$task}','{$td}','{$added_by}',1,0,now(),now())";
$result_add_cf = $conn->runsql($query_add_cf, $dbcon);
if ($result_add_cf) {
$result[0] = "S";
$result[1] = "Task description added succssfully";
} else {
$result[0] = "F";
$result[1] = "An error occured!";
}
if ($s_task != "") {
$where_4 = " AND sub_task_id='{$s_task}' ";
}
if ($task_desc != "") {
$where_5 = " AND task_desc='{$task_desc}' ";
}
if ($user != "") {
$where_6 = " AND user_id='{$user}' ";
}
$where_final = $where_1 . $where_2 . $where_3 . $where_4 . $where_5 . $where_6 . $where_7;
//$user_id = $_SESSION['user_id'];
$date_from = $_POST['date_from'];
$date_to = $_POST['date_to'];
$query_check_ot_status = "SELECT * FROM user_tasks_ot WHERE ot_status IS NULL";
$file_name = $title = "Report_between_" . $date_from . "_and_" . $date_to;
$result_check_ot_status = $conn->runsql($query_check_ot_status, $dbcon);
if (mysqli_num_rows($result_check_ot_status)) {
?>
<div data-alert class="alert-box info radius">
<center>Still some entries not validated yet!</center>
<a href="#" class="close">×</a>
</div>
<?php
}
$query = "SELECT * FROM user_tasks_ot WHERE " . $where_final . " ORDER BY date DESC";
// AND ".$where;
?>
<!--<div class="row" style="width: 99%">
<div class="small-6 columns"><h5>Report Between <?php
echo $date_from;
?>
<?php
session_start();
//include_once '../includes/session_admin.php';
require_once '../classes/db.class.php';
$conn = new db();
$dbcon = $conn->dbConnect();
if (!empty($_SESSION['team_id'])) {
echo '<option value=""> -- Select Team --</option>';
$team_id = $_SESSION['team_id'];
$lenght = sizeof($team_id);
for ($i = 0; $i < $lenght; $i++) {
$query_get_teamss = "select team_id,team_name FROM amz_teams WHERE status='1' AND team_deletion='0' AND team_id='{$team_id[$i]}' ORDER BY team_name ASC";
$result_get_teams = $conn->runsql($query_get_teamss, $dbcon);
$result_teams = mysqli_fetch_object($result_get_teams);
?>
<option value="<?php
echo $result_teams->team_id;
?>
"><?php
echo $result_teams->team_name;
?>
</option>
<?php
}
} else {
echo '<option value="" disabled=""> -- No tasks available --</option>';
}
//goto test1;
echo "Setting up the environment<br>";
//$setup_q_1="UPDATE `amz_dt_manage` SET `wu_updation`=0";
//$conn->runsql($setup_q_1, $dbcon);
//$setup_q_2="UPDATE `amz_daily_target` SET `wu_status`=0";
//$conn->runsql($setup_q_2, $dbcon);
//$setup_q_3="UPDATE `user_tasks` SET `cf`=NULL,`wu`=NULL,`wu_status`=0";
//$conn->runsql($setup_q_3, $dbcon);
//$setup_q_4="UPDATE `user_tasks_ot` SET `cf`=NULL,`wu`=NULL,`wu_status`=0";
//$conn->runsql($setup_q_4, $dbcon);
echo "Start<br>";
//die();
//test1:
//Select con. fac completed months
$query_3 = "SELECT * FROM amz_dt_manage WHERE cf_updation='1' AND wu_updation='0' AND con_fac_updation=1";
$result_3 = $conn->runsql($query_3, $dbcon);
while ($result_row_3 = mysqli_fetch_object($result_3)) {
echo "Step 1 started...<br>";
$month = $result_row_3->month;
echo $setup_q_2 = "UPDATE `amz_daily_target` SET `wu_status`=0 WHERE month_from='{$month}'";
$conn->runsql($setup_q_2, $dbcon);
$month_modiified_struct_call_1 = date("Y-m", strtotime($month));
echo $setup_q_3 = "UPDATE `user_tasks` SET `cf`=NULL,`wu`=NULL,`wu_status`=0 WHERE date LIKE '%{$month_modiified_struct_call_1}%'";
$conn->runsql($setup_q_3, $dbcon);
echo $setup_q_4 = "UPDATE `user_tasks_ot` SET `cf`=NULL,`wu`=NULL,`wu_status`=0 WHERE date LIKE '%{$month_modiified_struct_call_1}%'";
$conn->runsql($setup_q_4, $dbcon);
//continue;
// Updating the non- CF entries
$query_4 = "SELECT s_no,team,task,sub_task FROM amz_daily_target WHERE month_from='{$month}' AND about_cf IS NULL AND cf_updated=1";
$result_4 = $conn->runsql($query_4, $dbcon);
while ($result_row_4 = mysqli_fetch_object($result_4)) {
<?php
include_once './data_page.php';
require_once '../classes/db.class.php';
require_once '../includes/time_calc.php';
$conn = new db();
$dbcon = $conn->dbConnect();
$id = $_GET['val'];
$query = "SELECT * FROM user_tasks_ot WHERE task_id='{$id}'";
// AND ".$where;
$result = $conn->runsql($query, $dbcon);
$result_row = mysqli_fetch_object($result);
//print_r($result_row);
?>
<div class="Table">
<div class="Heading"><div class="Cell">Field</div><div class="Cell">Value</div></div>
<div class="Row_odd"><div class="Cell">Date</div><div class="Cell"><?php
echo $result_row->date;
?>
</div></div>
<div class="Row_even"><div class="Cell">User</div><div class="Cell"><?php
echo $user_array[$result_row->user_id];
?>
</div></div>
<div class="Row_odd"><div class="Cell">Team</div><div class="Cell"><?php
echo $team_array[$result_row->team_id];
?>
</div></div>
<div class="Row_even"><div class="Cell">Task</div><div class="Cell"><?php
echo $task_array[$result_row->tasks_id];
?>
<pre>
<?php
require_once '../classes/db.class.php';
include '../includes/time_calc.php';
$conn = new db();
$dbcon = $conn->dbConnect();
$query_0 = "UPDATE user_tasks SET work_type=0";
$result_0 = $conn->runsql($query_0, $dbcon);
if (!$result_0) {
echo "<br>Failed query: " . $query_0;
} else {
echo " Setting up the environment... Pass!<br><br>";
}
$query_0 = "UPDATE user_tasks_ot SET work_type=0";
$result_0 = $conn->runsql($query_0, $dbcon);
if (!$result_0) {
echo "<br>Failed query: " . $query_0;
} else {
echo " Setting up the environment... Pass!<br><br>";
}
$query_1 = "SELECT sub_task_id,sub_task_name FROM amz_sub_tasks WHERE about_cf IS NULL ";
//AND
$result_1 = $conn->runsql($query_1, $dbcon);
while ($result_row_1 = mysqli_fetch_object($result_1)) {
$non_work_entry = $result_row_1->sub_task_id;
echo "<br>" . $result_row_1->sub_task_name;
$query_2 = "UPDATE user_tasks SET work_type=1 WHERE sub_task_id='{$non_work_entry}'";
$result_2 = $conn->runsql($query_2, $dbcon);
if (!$result_2) {
echo "<br>Failed query: " . $query_2;
} else {
