ikan Uploader :
Directory : /var/www/html/shardahospital.org/uploads/
Upload File : |
| Current File : /var/www/html/shardahospital.org/uploads/tableCron.php |
<?php
error_reporting(E_ALL);
define('DB_SERVER','shardauniversity.cluster-c8m5zlhotfbm.ap-south-1.rds.amazonaws.com');
define('DB_USERNAME','campus_user');
define('DB_PASSWORD' ,"sPV@bM2hhR6&");
define('DB_DATABASE', 'sharda_campus_db');
define('COMPANY', "ShardaTech pvt ltd.");
//exit('Sorry Try Again!!!!!');
/* Connect to MySQL and select the database. */
$conn = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
if (!$conn) {
mysqli_connect_error();
}
mysqli_set_charset($conn, "utf8");
$tbl_name = 'PS_S_PRD_CRS_QP_VW ';
if(!empty($tbl_name))
{
$post = [
'table' => $tbl_name,
'username' => 'ATTEST',
'password' => 'TFsgt^I8',
'num_rows' => '4000'
];
$resultsArray = '';
$resultsArray = json_decode(getAPIResponse($post));
echo 'Total Count =>'.count($resultsArray);
echo '<br/>';
echo count($resultsArray);
print_r($resultsArray); die;
// Get School List
$sql = "select id,school_code from campus_school_master where `is_deleted` = '0' AND `status` = '1'";
$result = mysqli_query($conn, $sql);
$schoolArray = array();
while($row = mysqli_fetch_array($result))
{
$schoolArray[$row['school_code']] = $row['id'];
}
// Get Department List
$sql = "select id,department_code from campus_department_master where `is_deleted` = '0' AND `status` = '1'";
$result = mysqli_query($conn, $sql);
$departmentArray = array();
while($row = mysqli_fetch_array($result))
{
$departmentArray[$row['department_code']] = $row['id'];
}
$i=0;
$k=0;
$t=0;
foreach($resultsArray as $row){
//print_r($row); die;
$sql = "select id,employee_id,email_id from tbl_employee_master where employee_id ='".$row->EMPLID."' AND `is_deleted` = '0' AND `status` = '1'";
$result = mysqli_query($conn, $sql);
$numrow = mysqli_num_rows($result);
// School Array
$schoolnArray = array('SUSMR'=>'SUMSR','SHSHL'=>'SHSHL','SUSDS'=>'SUSDS','SUSAH'=>'SUSAH','SHSUN'=>'SHSUN','SUSET'=>'SUSET','SUSON'=>'SUSNR','SUSBS'=>'SUSBS','SUSOL'=>'SUSOL','SUBSR'=>'SUBSR','SUSAP'=>'SUSAP','SUSLG'=>'SUSLG','SUSAC'=>'SUSAC','SUEDU'=>'SUSED','SUPHA'=>'SUPHA','STECH'=>'STECH','SUSAS'=>'SUSAS');
$school_id = $schoolArray[$schoolnArray[$row->SCHOOL]];
$department_id = $departmentArray[$row->DEPTID];
$k++;
try {
if($numrow>0)
{
$custom1 = str_replace("'","\'",$row->NAME1);
$full_name = str_replace("'","\'",$row->NAME);
$PHONE = str_replace(array("/","-",),"",$row->PHONE);
//if($department_id>0 && $school_id>0){
mysqli_query($conn,"UPDATE tbl_employee_master SET `employee_id`='".$row->EMPLID."', `full_name`='".$full_name."', `gender`='".$row->GENDER1."', `dob`='".$row->BIRTHDATE."', `school_id`='".$school_id."',`school`='".$row->SCHOOL."',`department_id`='".$department_id."',`department_code`='".$row->DEPTID."',`hr_status`='".$row->HR_STATUS."', `custom`='".$custom1."', `phone`='".$PHONE."', `last_modifiedon`='".date('Y-m-d h:i:s')."' WHERE email_id='".$row->EMAILID."'");
$t++;
//}
} else {
$custom1 = str_replace("'","\'",$row->NAME1);
$full_name = str_replace("'","\'",$row->NAME);
$PHONE = str_replace(array("/","-",),"",$row->PHONE);
mysqli_query($conn,"INSERT INTO tbl_employee_master SET `employee_id`='".$row->EMPLID."', `full_name`='".$full_name."', `gender`='".$row->GENDER1."', `dob`='".$row->BIRTHDATE."',`school_id`='".$school_id."',`school`='".$row->SCHOOL."',`department_id`='".$department_id."',`department_code`='".$row->DEPTID."',`hr_status`='".$row->HR_STATUS."', `custom`='".$custom1."', `phone`='".$PHONE."', `status`='1', `is_deleted`='0', `createdon`='".date('Y-m-d h:i:s')."',email_id='".$row->EMAILID."'");
$i++;
}
} catch (TableAException $e){
print_r($e); die;
} catch (Exception $e) {
print_r($e); die;
}
}
echo 'Total Insert =>'.$i.' and Total Update=>'.$t.'<br/> Total=>'.$k;
exit();
} else {
echo 'Invalid Request';
exit;
}
/*
* Function : getschoolID
* Description : send request and get response in JSON format
* Date: 19 Oct 2020
* Created By: Amit Verma
*/
function getSchoolID($school_code,$conn)
{
if(!empty($school_code)){
$sql = "select id,school_name from tbl_schools where school_code ='".$school_code."' AND `is_deleted` = '0' AND `status` = '1'";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_row($result);
print_r($row); die;
return $row['id'];
}
}
/*
* Function : getDepartmentID
* Description : send request and get response in JSON format
* Date: 19 Oct 2020
* Created By: Amit Verma
*/
function getDepartmentID($department_code,$conn)
{
if(!empty($department_code)){
$sql = "select id,department_name from tbl_departments where department_code ='".$department_code."' AND `is_deleted` = '0' AND `status` = '1'";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_row($result);
return $row['id'];
}
}
/*
* Function : getAPIResponse
* Description : send request and get response in JSON format
* Date: 19 Oct 2020
* Created By: Amit Verma
*/
function getAPIResponse($post)
{
$url = 'https://slotbooking.sharda.ac.in/mentorapi/getCommonDetails';
if (!empty($url) && !empty($post)) {
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($post));
$response = curl_exec($ch);
}
return $response;
}
?>
Kontol Shell Bypass