ikan Uploader :
Directory : /var/www/html/shardahospital.org/incident/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/incident/application/models/Api_model.php |
<?php
class Api_model extends CI_Model
{
/*
* Function : getSQLStudentDetails
*/
function getSQLStudentDetails($gender)
{
$this->db->distinct();
/*$this->db->select('hostel_id,hostel_name, category_details, category_code');
$this->db->where('hostel_id', $S_HOSTELID);
$this->db->where('category_code', $S_FEE_CATEGORY);
$this->db->where('status', '1');
$this->db->where('is_deleted', '0');*/
$query = $this->db->get('SU_GRIEV_DTL_VW');
return $query->result_array();
}
/*
* 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;
}
/*
* Function : getEmpDetails
*/
function getEmpDetails($EMPLID)
{
$resultsArray = '';
if($EMPLID>0){
$tbl_name = 'PS_SU_EZONE_VW';
$post = [
'table' => $tbl_name,
'username' => 'ezone',
//'password' => 'TFsgt^I8',
'conditions' => serialize(array('EMPLID'=>$EMPLID,'HR_STATUS'=>'A')),
'num_rows' => '10'
];
$resultsArray = json_decode($this->getAPIResponse($post));
$totalRecords = count($resultsArray);
}
return $resultsArray;
}
/*
* Function : getStudentDetails
*/
function getStudentDetails($EMPLID)
{
$results = array();
$db = "(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 35.154.115.237)(PORT = 9999))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SHARDA)
)
)";
try {
$conn = ocilogon('ATTEST', 'TFsgt^I8', $db);
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$sql = "SELECT * from SU_GRIEV_DTL_VW WHERE EMPLID = '" . $EMPLID . "'";
$stid = oci_parse($conn, $sql);
if (!$stid) {
$e = oci_error($conn);
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
// Perform the logic of the query
$r = oci_execute($stid);
if (!$r) {
$e = oci_error($stid);
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$results = array();
// Fetch the results of the query
while ($row = oci_fetch_array($stid, OCI_ASSOC + OCI_RETURN_NULLS)) {
$results[] = $row;
}
return $results;
} catch (Exception $e) {
die("Connection Error");
}
}
/*
* Function : getStudentTestDetails
*
*
*/
function getStudentTestDetails($EMPLID='2020562958')
{
$results = array();
$db = "(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 35.154.115.237)(PORT = 9999))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SHARDA)
)
)";
try {
$conn = ocilogon('ATTEST', 'TFsgt^I8', $db);
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$sql = "SELECT * from SU_GRIEV_DTL_VW WHERE EMPLID = '" . $EMPLID . "'";
$stid = oci_parse($conn, $sql);
if (!$stid) {
$e = oci_error($conn);
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
// Perform the logic of the query
$r = oci_execute($stid);
if (!$r) {
$e = oci_error($stid);
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$results = array();
// Fetch the results of the query
while ($row = oci_fetch_array($stid, OCI_ASSOC + OCI_RETURN_NULLS)) {
$results[] = $row;
}
return $results;
} catch (Exception $e) {
die("Connection Error");
}
}
}
Kontol Shell Bypass