$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">
<th>Phone</th>
<th>Email</th>
<!-- <th>Created Date</th>
<th>Updated Date</th>
<th>Description</th>-->
<th data-sort-ignore="true">Actions</th>
</tr>
</thead>
<tbody>
<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$data = null;
if (isset($_GET['technology'])) {
$data = GlobalCrud::getAllRecordsBasedOnId('trainerSelectByTechnologyId', array($_GET['technology']));
} else {
$data = GlobalCrud::getData('trainerSelect');
}
$count = 0;
foreach ($data as $row) {
$emailTd = '<td></td>';
if (!empty($row['email'])) {
$emailTd = '<td> <i class="fa fa-envelope"></i> ' . $row['email'] . '</td>';
}
$phoneTd = '<td></td>';
if (!empty($row['phone'])) {
$phoneTd = '<td> <i class="fa fa-phone"></i> ' . $row['phone'] . '</td>';
}
echo '<tr>';
echo '<td>' . $row['name'] . '</td>';
$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"
<th>Skype Id</th>
<th>Tz</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 = "traineeDelete";
$data = null;
if (isset($_GET['BatchId'])) {
$data = GlobalCrud::getAllRecordsBasedOnId('traineeSelectByBatchId', array($_GET['BatchId']));
} else {
$data = GlobalCrud::getData('traineeSelect');
}
$count = 0;
foreach ($data as $row) {
$emailTd = '<td></td>';
if (!empty($row['email'])) {
$emailTd = '<td> <i class="fa fa-envelope"></i> <a href="mailto:tsreenath1985@gmail.com">' . $row['email'] . '</a></td>';
}
$batchTd = '<td></td>';
if (!empty($row['batch_id'])) {
$batchTd = '<td> ' . $row['batch_id'] . '</td>';
}
$phoneTd = '<td></td>';
if (!empty($row['phone'])) {