<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>';