function deleteRecord($idValue)
{
$sql = "contactDelete";
$sqlValues = $idValue;
GlobalCrud::delete($sql, $sqlValues);
header("Location:./?content=43");
}
function deleteRecord($idValue)
{
$sql = "batchDelete";
$sqlValues = $idValue;
GlobalCrud::delete($sql, $sqlValues);
}
$sqlValuesContactUpdate = array($clientid, $poc, $email, $phone, $updatedDate, $description, $designation, $contactId);
GlobalCrud::update($sqlContactUpdate, $sqlValuesContactUpdate);
}
}
header("Location:../?content=7");
}
} else {
$sql = "clientSelectById";
$sqlValues = array($id);
$data = GlobalCrud::selectById($sql, $sqlValues);
$name = $data['name'];
$address = $data['address'];
$description = $data['description'];
$sqlContact = "contactSelectById";
$sqlValuesContact = array($id);
$dataContact = GlobalCrud::getAllRecordsBasedOnId($sqlContact, $sqlValuesContact);
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<link href="css/bootstrap.min.css" rel="stylesheet">
<script src="js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$data = GlobalCrud::getData('supportSelect');
// file name for download
$filename = "support_" . date('Ymd') . ".xls";
header("Content-Disposition: attachment; filename=\"{$filename}\"");
header("Content-Type: application/vnd.ms-excel");
echo 'Trainee Name' . "\t";
echo 'Employee Name' . "\t";
echo 'Start Date' . "\t";
echo 'End Date' . "\t";
echo 'Allotted Time' . "\t";
echo 'End Client' . "\t";
echo 'Technology Used' . "\t";
echo 'Status' . "\t";
echo 'Description' . "\n";
foreach ($data as $row) {
echo $row['trainee_name'] . "\t";
echo $row['employee_name'] . "\t";
echo $row['start_date'] . "\t";
echo $row['end_date'] . "\t";
echo $row['allotted_time'] . "\t";
echo $row['end_client'] . "\t";
echo $row['technology_used'] . "\t";
echo $row['status'] . "\t";
echo $row['description'] . "\n";
}
exit;
<th>Client Name</th>
<th>Category</th>
<th>Assisted By</th>
</tr>
</thead>
<tbody>
<?php
error_reporting(0);
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$count = 0;
$data = GlobalCrud::getData('paymentPendingSelect');
foreach ($data as $row) {
echo '<tr>';
echo '<td>' . $row['name'] . '</td>';
echo '<td>' . $row['client'] . '</td>';
echo '<td>' . $row['category'] . '</td>';
echo '<td>' . $row['assistedBy'] . '</td>';
echo '</tr>';
$count++;
}
?>
</tbody>
</table>
</div>
<h3>Batch</h3>
<div class='B' id="none" data-panel_type="none">
}
*/
if (empty($date)) {
$valid = false;
}
// update data
if ($valid) {
$sql = "interviewUpdate";
$sqlValuesForUpdate = array($traineeid, $assistedby, $clientid, $interviewer, $time, $status, $updatedDate, $description, $date, $id);
GlobalCrud::update($sql, $sqlValuesForUpdate);
header("Location:../?content=22");
}
} else {
$sql = "interviewSelectById";
$sqlValues = array($id);
$data = GlobalCrud::selectById($sql, $sqlValues);
$traineeid = $data['trainee_id'];
$assistedby = $data['assisted_by'];
$clientid = $data['client_id'];
$interviewer = $data['interviewer'];
$time = $data['time'];
$status = $data['status'];
//$created_date = $data['created_date'];
//$updated_date = $data['updated_date'];
$description = $data['description'];
$date = $data['date'];
}
?>
<!DOCTYPE html>
if (!empty($_POST)) {
// keep track post values
$name = $_POST['name'];
$createdDate = date("Y/m/d");
// $updatedDate = $_POST['updatedDate'];
$description = $_POST['description'];
// validate input
$valid = true;
if (empty($name)) {
$valid = false;
}
// insert data
if ($valid) {
$sql = "technologyInsert";
$sqlValues = array($name, $createdDate, $description);
GlobalCrud::setData($sql, $sqlValues);
header("Location:../?content=1");
} else {
header("Location:../?content=2");
}
}
/*
* if ( !empty($_GET)) {
* echo "<script type='text/javascript'>alert('get');</script>";
* }
*/
?>
<!DOCTYPE html>
<html lang="en">
<tr>
<th>End Client</th>
<th>Question</th>
<th>Answers</th>
<!--<th>Description</th> -->
<th data-sort-ignore="true">Actions</th>
</tr>
</thead>
<tbody>
<?php
//header("Cache-Control: no-cache");
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
//$delete = "questionDelete";
$data = GlobalCrud::getData('questionSelect');
$count = 0;
foreach ($data as $row) {
echo '<tr>';
echo '<td>' . $row['interview_name'] . '</td>';
echo '<td>' . $row['question'] . '</td>';
echo '<td>' . $row['answers'] . '</td>';
//echo '<td>'. $row['description'] . '</td>';
echo '<td nowrap="nowrap">';
echo '<a href="#" data-toggle="tooltip" title="' . $row['description'] . '"> <i class="fa fa-caret-square-o-up"></i></a>';
echo '<a href="?content=36&id=' . $row['id'] . '"> <i class="fa fa-pencil-square"></i></a>';
//echo '<a href="?content=34&id='.$row['id'].'" onclick="return confirm(\'Are you sure you want to delete?\')" > <i class="fa fa-trash"></i></a>';//'?content=16&id='.$row['id'].'
echo '<a href="#" onClick=delFromHome(' . $row['id'] . ',"questionDelete") > <i class="fa fa-trash"></i></a>';
echo '</td>';
echo '</tr>';
$count++;
<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$data = GlobalCrud::getData('technologySelect');
// file name for download
$filename = "technology_" . date('Ymd') . ".xls";
header("Content-Disposition: attachment; filename=\"{$filename}\"");
header("Content-Type: application/vnd.ms-excel");
echo 'Name' . "\t";
echo 'Description' . "\n";
foreach ($data as $row) {
echo $row['name'] . "\t";
echo $row['description'] . "\n";
}
exit;
if (empty($assignedto)) {
$valid = false;
}*/
/* if (empty($estimatedtime)) {
$valid = false;
}
*/
$toEmail = $_POST['employeeEmail'];
$subject = "Regarding Newly Created Task";
$body = "Hi,\n \n\t\t\tAssigned To: " . $employeeName . "\n" . "Time Line: " . $estimatedtime . "\n" . "Description: " . $description . "\n";
// insert data
if ($valid) {
$sql = "todoInsert";
$sqlValues = array($category, $status, $assignedto, $estimatedtime, $createdDate, $description);
GlobalCrud::setData($sql, $sqlValues);
GlobalCrud::sendEmail($toEmail, $subject, $body);
header("Location:../?content=19");
} else {
header("Location:../?content=20");
}
}
/*if ( !empty($_GET)) {
echo "<script type='text/javascript'>alert('get');</script>";
}*/
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<th>End Client</th>
<th>Date</th>
<th>Time</th>
<th>Status</th>
<!-- <th>Description</th>-->
<th data-sort-ignore="true">Actions</th>
</tr>
</thead>
<tbody>
<?php
header("Cache-Control: no-cache");
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$data = GlobalCrud::getData('interviewSelect');
$dataInclude = GlobalCrud::getData('interviewSelectInclude');
$count = 0;
$countCheck = 0;
foreach ($data as $row) {
echo '<tr>';
echo '<td>' . $row['employee_name'] . '</td>';
echo '<td>' . $row['trainee_name'] . '</td>';
echo '<td>' . $row['technology'] . '</td>';
echo '<td>' . $row['client_name'] . '</td>';
echo '<td>' . $row['interviewer'] . '</td>';
echo '<td>' . $row['date'] . '</td>';
echo '<td>' . $row['time'] . '</td>';
echo '<td>' . $row['status'] . '</td>';
// echo '<td>'. $row['description'] . '</td>';
echo '<td>';
echo '<a href="#" data-toggle="tooltip" title="' . $row['description'] . '"> <i class="fa fa-caret-square-o-up"></i></a>';
// insert data
if ($valid) {
$sql = "supportTrackerInsert";
$sqlValues = array($supportby,$supportto,$date,$hours,$description);
GlobalCrud::setData($sql,$sqlValues);
header("Location:../?content=47");
}
else{
header("Location:../?content=47");
}
} */
// $delete="employeeDelete";
$data = GlobalCrud::getData('supportTrackerSelect');
foreach ($data as $row) {
echo '<tr>';
echo '<td>' . $row['employee_name'] . '</td>';
echo '<td>' . $row['trainee_name'] . '</td>';
echo '<td>' . $row['date'] . '</td>';
echo '<td>' . $row['hours'] . '</td>';
echo '<td>' . $row['description'] . '</td>';
echo '<td nowrap="nowrap">';
/* echo '<a href="#" data-toggle="tooltip" title="'. $row['description'] . '"> <i class="fa fa-caret-square-o-up"></i></a>';
echo '<a href="?content=48&id='.$row['id'].'"> <i class="fa fa-pencil-square"></i></a>';
echo '<a href="?content=47&id='.$row['id'].'" onclick="return confirm(\'Are you sure you want to delete?\')" > <i class="fa fa-trash"></i></a>';//'?content=16&id='.$row['id'].'
*/
// echo '<a href="#" onClick=delFromHome('.$row['id'].',"employeeDelete") > <i class="fa fa-trash"></i></a>';//'?content=16&id='.$row['id'].'
echo '<a href="#" data-toggle="tooltip" title="' . $row['description'] . '"> <i class="fa fa-caret-square-o-up"></i></a>';
echo '<a href="?content=48&id=' . $row['id'] . '"> <i class="fa fa-pencil-square"></i></a>';
$temDate1 = date_sub($dateT1, date_interval_create_from_date_string('2 year'));
$temDate2 = date_sub($dateT2, date_interval_create_from_date_string('1 year'));
} elseif (date('m') >= 4) {
// 2015-04-01 to 2016-03-31
$temDate1 = date_sub($dateT1, date_interval_create_from_date_string('1 year'));
$temDate2 = date_sub($dateT2, date_interval_create_from_date_string('0 year'));
}
$date1 = date_format($temDate1, 'Y-m-d');
$date2 = date_format($temDate2, 'Y-m-d');
// echo "last year ".$date1 ." to ".$date2;
$dataBatch = GlobalCrud::getAllRecordsBasedOnId('batchdashboardYear', array($date1, $date2));
$dataSupport = GlobalCrud::getAllRecordsBasedOnId('supportdashboardYear', array($date1, $date2));
$dataInterview = GlobalCrud::getAllRecordsBasedOnId('interviewdashboardYear', array($date1, $date2));
$dataSupportTran = GlobalCrud::getAllRecordsBasedOnId('closeTrasactionSupportYear', array($date1, $date2));
$dataClientTran = GlobalCrud::getAllRecordsBasedOnId('closeTrasactionClientYear', array($date1, $date2));
$dataInterviewTran = GlobalCrud::getAllRecordsBasedOnId('closeTrasactionInterviewYear', array($date1, $date2));
$dropdown = 'Last Year Details From :' . $date1 . " to " . $date2;
}
}
?>
<!DOCTYPE html>
<html>
<head profile="http://www.w3.org/2005/10/profile">
<title>Usk Tool</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="./css/bootstrap.min.css" rel="stylesheet">
<link href=".css/asterisk.css" rel="stylesheet" type="text/css" />
<link href="./css/fa/css/font-awesome.min.css" rel="stylesheet"
<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$data = GlobalCrud::getData('contactSelect');
date_default_timezone_set("Asia/Kolkata");
// file name for download
$filename = "contact_" . date('Ymd') . ".xls";
header("Content-Disposition: attachment; filename=\"{$filename}\"");
header("Content-Type: application/vnd.ms-excel");
echo ' Client Name' . "\t";
echo 'poc' . "\t";
echo 'Email' . "\t";
echo 'phone' . "\t";
echo 'Description' . "\n";
foreach ($data as $row) {
echo $row['client_id'] . "\t";
echo $row['poc'] . "\t";
echo $row['email'] . "\t";
echo $row['phone'] . "\t";
echo $row['description'] . "\n";
}
exit;
<th>Status</th>
<!-- <th>Description</th>
-->
<th data-sort-ignore="true">Action</th>
</tr>
</thead>
<tbody>
<?php
// header("Cache-Control: no-cache");
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$delete = "supportDelete";
$data = GlobalCrud::getData('supportSelect');
$data2 = GlobalCrud::getData('supportGroupByTraineeId');
$array_value = array();
$count = 0;
$beforeValue = 0;
foreach ($data2 as $row) {
//array_push($array, $var)
$array_value[$row['trainee_id']] = $row['totalCount'];
}
foreach ($data as $row) {
$end_dateTd = '<td>' . $row['end_date'] . '</td>';
if ($row['end_date'] == '0000-00-00') {
$end_dateTd = '<td></td>';
}
/*if ($row ['trainee_id'] == $beforeValue) {
echo '<tr class="RowToClick' . $row ['trainee_id'] . '" id="hide">';
echo '<td></td>';
<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$data = GlobalCrud::getData('employeeSelect');
// file name for download
$filename = "employee_" . date('Ymd') . ".xls";
header("Content-Disposition: attachment; filename=\"{$filename}\"");
header("Content-Type: application/vnd.ms-excel");
echo 'Name' . "\t";
echo 'Phone' . "\t";
echo 'Email' . "\t";
echo 'Role' . "\t";
echo 'Base Salary' . "\t";
echo 'Description' . "\n";
foreach ($data as $row) {
echo $row['name'] . "\t";
echo $row['phone'] . "\t";
echo $row['email'] . "\t";
echo $row['role'] . "\t";
echo $row['base_salary'] . "\t";
echo $row['description'] . "\n";
}
exit;
<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$data = GlobalCrud::getData('clientSelect');
// file name for download
$filename = "client_" . date('Ymd') . ".xls";
header("Content-Disposition: attachment; filename=\"{$filename}\"");
header("Content-Type: application/vnd.ms-excel");
echo ' Name' . "\t";
echo 'Address' . "\t";
echo 'Description' . "\n";
foreach ($data as $row) {
echo $row['name'] . "\t";
echo $row['address'] . "\t";
echo $row['description'] . "\n";
}
exit;
<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$data = GlobalCrud::getData('batchSelect');
date_default_timezone_set("Asia/Kolkata");
$dateValue1 = date('Y-M-d');
// file name for download
$filename = "batch_" . $dateValue1 . ".xls";
header("Content-Disposition: attachment; filename=\"{$filename}\"");
header("Content-Type: application/vnd.ms-excel");
echo 'Technology Name' . "\t";
echo 'Trainer Name' . "\t";
echo 'Start Date' . "\t";
echo 'End Date' . "\t";
echo 'Time' . "\t";
echo 'Duration' . "\t";
echo 'Status' . "\t";
echo 'Description' . "\n";
foreach ($data as $row) {
echo $row['technology_name'] . "\t";
echo $row['trainer_name'] . "\t";
echo $row['start_date'] . "\t";
echo $row['end_date'] . "\t";
echo $row['time'] . "\t";
echo $row['duration'] . "\t";
echo $row['status'] . "\t";
echo $row['description'] . "\n";
}
exit;
<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$data = GlobalCrud::getData('courseSelect');
// file name for download
$filename = "course_" . date('Ymd') . ".xls";
header("Content-Disposition: attachment; filename=\"{$filename}\"");
header("Content-Type: application/vnd.ms-excel");
echo ' Technology Name' . "\t";
echo 'Name' . "\t";
echo 'Estimated Hours' . "\t";
echo 'Description' . "\n";
foreach ($data as $row) {
echo $row['technology_name'] . "\t";
echo $row['name'] . "\t";
echo $row['est_hrs'] . "\t";
echo $row['description'] . "\n";
}
exit;
<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$data = GlobalCrud::getData('trainerSelect');
date_default_timezone_set("Asia/Kolkata");
// file name for download
$filename = "trainer_" . date('Ymd') . ".xls";
header("Content-Disposition: attachment; filename=\"{$filename}\"");
header("Content-Type: application/vnd.ms-excel");
echo 'Name' . "\t";
echo 'Technology Name' . "\t";
echo 'Phone' . "\t";
echo 'Email' . "\t";
echo 'Description' . "\n";
foreach ($data as $row) {
echo $row['name'] . "\t";
echo $row['technology_name'] . "\t";
echo $row['phone'] . "\t";
echo $row['email'] . "\t";
echo $row['description'] . "\t";
}
exit;
<th>Category</th>
<th>Status</th>
<th>Employee Name</th>
<th>Estimated Time</th>
<th data-sort-ignore="true">Actions</th>
</tr>
</thead>
<tbody>
<?php
header("Cache-Control: no-cache");
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$delete = "todoDelete";
$data = GlobalCrud::getData('todoSelect');
$count = 0;
foreach ($data as $row) {
echo '<tr id="' . $row['id'] . '">';
echo '<td>' . $row['category'] . '</td>';
echo '<td>' . $row['status'] . '</td>';
echo '<td>' . $row['employee_name'] . '</td>';
echo '<td>' . $row['estimated_time'] . '</td>';
echo '<td nowrap="nowrap">';
echo '<a href="#" data-toggle="tooltip" title="' . $row['description'] . '"> <i class="fa fa-caret-square-o-up"></i></a>';
echo '<a href="?content=21&id=' . $row['id'] . '"> <i class="fa fa-pencil-square"></i></a>';
echo '<a href="#" onClick=delFromHome(' . $row['id'] . ',"todoDelete") > <i class="fa fa-trash"></i></a>';
// '?content=16&id='.$row['id'].'
// echo '<a href="?content=19&id='.$row['id'].'" onclick="return deleteRecordById('.$row['id'].')" > <i class="fa fa-trash"></i></a>';//'?content=16&id='.$row['id'].'
echo '</td>';
echo '</tr>';
<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$data = GlobalCrud::getData('interviewSelect');
date_default_timezone_set("Asia/Kolkata");
// file name for download
$filename = "interview_" . date('Ymd') . ".xls";
header("Content-Disposition: attachment; filename=\"{$filename}\"");
header("Content-Type: application/vnd.ms-excel");
echo 'Employee Name' . "\t";
echo 'Trainee Name' . "\t";
echo 'Client Name' . "\t";
echo 'Interviewer' . "\t";
echo 'Date' . "\t";
echo 'Time' . "\t";
echo 'Status' . "\t";
echo 'Description' . "\n";
foreach ($data as $row) {
echo $row['employee_name'] . "\t";
echo $row['trainee_name'] . "\t";
echo $row['client_name'] . "\t";
echo $row['interviewer'] . "\t";
echo $row['date'] . "\t";
echo $row['time'] . "\t";
echo $row['status'] . "\t";
echo $row['description'] . "\n";
}
exit;
<th>Email</th>
<th>Phone</th>
<th>Role</th>
<th data-sort-ignore="true">Action</th>
</tr>
</thead>
<tbody>
<?php
header("Cache-Control:no-cache");
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$delete = "userDelete";
$count = 0;
$data = GlobalCrud::getData('userSelect');
foreach ($data as $row) {
echo '<tr>';
echo '<td>' . $row['username'] . '</td>';
echo '<td>' . $row['firstname'] . '</td>';
echo '<td>' . $row['lastname'] . '</td>';
echo '<td>' . $row['email'] . '</td>';
echo '<td>' . $row['phoneno'] . '</td>';
echo '<td>' . $row['role'] . '</td>';
echo '<td nowrap="nowrap">';
echo '<a href="#" data-toggle="tooltip" title="' . $row['description'] . '"> <i class="fa fa-caret-square-o-up"></i></a>';
echo '<a href="?content=46&id=' . $row['id'] . '"> <i class="fa fa-pencil-square"></i></a>';
//echo '<a href="?content=1&id='.$row['id'].'" onclick="return confirm(\'Are you sure you want to delete?\')" > <i class="fa fa-trash"></i></a>';//'?content=16&id='.$row['id'].'
echo '<a href="#" onClick=delFromHome(' . $row['id'] . ',"userDelete") > <i class="fa fa-trash"></i></a>';
//'?content=16&id='.$row['id'].'
echo '</td>';
