<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++;
<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('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;
<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
date_default_timezone_set("Asia/Kolkata");
$data = GlobalCrud::getData('technologySelect');
if (!empty($_POST)) {
// keep track post values
$technologyid = $_POST['technologyid'];
$name = $_POST['name'];
$esthrs = $_POST['esthrs'];
$createdDate = date("Y/m/d");
$description = $_POST['description'];
// validate input
$valid = true;
if (empty($technologyid)) {
$valid = false;
}
// insert data
if ($valid) {
$sql = "courseInsert";
$sqlValues = array($technologyid, $name, $esthrs, $createdDate, $description);
GlobalCrud::setData($sql, $sqlValues);
header("Location:../?content=25");
} else {
header("Location:../?content=26");
}
}
/*if ( !empty($_GET)) {
echo "<script type='text/javascript'>alert('get');</script>";
<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$traineeData = GlobalCrud::getData('traineeSelect');
$employeeData = GlobalCrud::getData('employeeSelect');
$clientData = GlobalCrud::getData('clientSelect');
$timeConstants = explode(',', GlobalCrud::getConstants("timeConstants"));
$interviewconstants = explode(',', GlobalCrud::getConstants("interviewconstants"));
date_default_timezone_set("Asia/Kolkata");
$id = null;
if (!empty($_GET['id'])) {
$id = $_REQUEST['id'];
}
if (null == $id) {
header("Location: index.php?content=22");
}
if (!empty($_POST)) {
//traineeid assistedby clientid interviewer time status date description
$traineeid = $_POST['traineeid'];
$assistedby = $_POST['assistedby'];
$clientid = $_POST['clientid'];
$interviewer = $_POST['interviewer'];
$time = $_POST['time'];
$status = $_POST['status'];
//$created_date = $_POST['created_date'];
$updatedDate = date("Y/m/d");
$description = $_POST['description'];
$date = $_POST['date'];
// validate input
<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$endClientData = GlobalCrud::getData('interviewSelect');
date_default_timezone_set("Asia/Kolkata");
if (!empty($_POST)) {
// keep track post values
$interviewid = $_POST['interviewid'];
$question = $_POST['question'];
$answers = $_POST['answers'];
$createdDate = date("Y/m/d");
//$updated_date = $_POST['updated_date'];
$description = $_POST['description'];
// validate input
$valid = true;
if (empty($interviewid)) {
$valid = false;
}
if (empty($question)) {
$valid = false;
}
// insert data
if ($valid) {
$sql = "questionInsert";
$sqlValues = array($interviewid, $question, $answers, $createdDate, $description);
GlobalCrud::setData($sql, $sqlValues);
header("Location:../?content=34");
} else {
header("Location:../?content=35");
<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$selecteddataClient = GlobalCrud::getData('clientSelect');
date_default_timezone_set("Asia/Kolkata");
$id = null;
if (!empty($_GET['id'])) {
$id = $_REQUEST['id'];
}
if (null == $id) {
header("Location: index.php?content=43");
}
if (!empty($_POST)) {
$clientid = $_POST['clientid'];
$poc = $_POST['poc'];
$email = $_POST['email'];
$phone = $_POST['phone'];
//$createdDate = $_POST['createdDate'];
$updatedDate = date("Y/m/d");
$description = $_POST['description'];
// validate input
$valid = true;
if (empty($clientid)) {
$valid = false;
}
if (empty($poc)) {
$valid = false;
}
if (empty($email)) {
<?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;
// 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>';
<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>';
<?php
error_reporting(0);
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
date_default_timezone_set("Asia/Kolkata");
$dropdown = '';
$dataPayment = GlobalCrud::getData('paymentPendingSelect');
$dataBatch = GlobalCrud::getAllRecordsBasedOnId('batchdashboardWithOutDate', array('0', '0'));
$dataSupport = GlobalCrud::getAllRecordsBasedOnId('supportdashboardWithOutDate', array('0', '0'));
$dataInterview = GlobalCrud::getAllRecordsBasedOnId('interviewdashboardWithOutDate', array('0', '0'));
/* $dataSupportTran = GlobalCrud::getAllRecordsBasedOnId ( 'closeTrasactionSupport', array (
'0',
'0'
) );
$dataClientTran = GlobalCrud::getAllRecordsBasedOnId ( 'closeTrasactionClient', array (
'0',
'0'
) );
$dataInterviewTran = GlobalCrud::getAllRecordsBasedOnId ( 'closeTrasactionInterview', array (
'0',
'0'
) ); */
if ($_GET['content'] == 50) {
$dataBatch = GlobalCrud::getAllRecordsBasedOnId('batchdashboard', array('1', '1'));
$dataSupport = GlobalCrud::getAllRecordsBasedOnId('supportdashboard', array('1', '1'));
$dataInterview = GlobalCrud::getAllRecordsBasedOnId('interviewdashboard', array('1', '1'));
$dataSupportTran = GlobalCrud::getAllRecordsBasedOnId('closeTrasactionSupport', array('1', '1'));
$dataClientTran = GlobalCrud::getAllRecordsBasedOnId('closeTrasactionClient', array('1', '1'));
$dataInterviewTran = GlobalCrud::getAllRecordsBasedOnId('closeTrasactionInterview', array('1', '1'));
<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$selecteddataTechnology = GlobalCrud::getData('technologySelect');
$selecteddataClient = GlobalCrud::getData('clientSelect');
$selecteddataBatch = GlobalCrud::getData('batchSelect');
$constants = explode(',', GlobalCrud::getConstants("timezoneConstants"));
$feeStatusConstants = explode(',', GlobalCrud::getConstants("feeStatusConstant"));
$id = null;
date_default_timezone_set("Asia/Kolkata");
if (!empty($_GET['id'])) {
$id = $_REQUEST['id'];
}
if (null == $id) {
header("Location: index.php?content=37");
}
if (!empty($_POST)) {
$name = $_POST['name'];
$email = $_POST['email'];
$alternatephone = $_POST['alternatephone'];
$clientid = $_POST['clientid'];
$skypeid = $_POST['skypeid'];
$timezone = $_POST['timezone'];
$batchid = $_POST['batchid'];
//$createdDate = $_POST['createdDate'];
$updatedDate = date("Y/m/d");
$description = $_POST['description'];
$phone = $_POST['phone'];
$feeStatus = $_POST['feeStatus'];
<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
date_default_timezone_set("Asia/Kolkata");
$selecteddataTechnology = GlobalCrud::getData('technologySelect');
$selecteddataTrainer = GlobalCrud::getData('trainerSelect');
$constants = explode(',', GlobalCrud::getConstants("timeConstants"));
$supportConstants = explode(',', GlobalCrud::getConstants("supportConstants"));
$id = null;
if (!empty($_GET['id'])) {
$id = $_REQUEST['id'];
}
if (null == $id) {
header("Location: index.php?content=10");
}
if (!empty($_POST)) {
$technologyid = $_POST['technologyid'];
$trainerid = $_POST['trainerid'];
$startdate = $_POST['startdate'];
$enddate = $_POST['enddate'];
$duration = $_POST['duration'];
$status = $_POST['status'];
$updatedDate = date("Y/m/d");
$description = $_POST['description'];
$time = $_POST['time'];
// validate input
$valid = true;
if (empty($technologyid)) {
$valid = false;
<?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;
<th>Client id</th>
<th>Poc</th>
<th>Email</th>
<th>Phone</th>
<!-- <th>Created Date</th>
<th>Updated Date</th> -->
<th>Description</th>
<th data-sort-ignore="true">Action</th>
</tr>
</thead>
<tbody>
<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/layout/connection/GlobalCrud.php";
include_once $path;
$data = GlobalCrud::getData('contactSelect');
foreach ($data as $row) {
echo '<tr>';
echo '<td>' . $row['client_id'] . '</td>';
echo '<td>' . $row['poc'] . '</td>';
echo '<td>' . $row['email'] . '</td>';
echo '<td>' . $row['phone'] . '</td>';
//echo '<td>'. $row['created_date'] . '</td>';
//echo '<td>'. $row['updated_date'] . '</td>';
echo '<td>' . $row['description'] . '</td>';
echo '<td>';
echo '<a href="?content=45&id=' . $row['id'] . '"><i class="icon-edit"></i></a>';
echo '<a href="?content=43&id=' . $row['id'] . '" onclick="return confirm(\'Are you sure you want to delete?\')" ><i class="icon-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('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>';
