File manager

File manager - Edit - /home/autoph/public_html/ltms-upload/plugins/dropzone/min/user_BAK.php.tar

Back
home/autoph/public_html/pms_v1/functions/user_BAK.php��0000644��00000020172�15025237751�0016670 0��ustar�00��<?php //error_reporting(0); //########################################################################## function userProfileID($userID){ include '../../../cfg/conn.php'; $uPro ="SELECT * FROM `pms_employee_data` WHERE `id`='$userID'"; $quPro = mysqli_query($conn,$uPro); while($acc = mysqli_fetch_array($quPro)){ $roleID = $acc['access_role']; } return $roleID; } //########################################################################## function getUserData($userID){ include '../../../cfg/conn.php'; $uPro ="SELECT * FROM `pms_employee_data` WHERE `id`='$userID'"; $quPro = mysqli_query($conn,$uPro); while($acc = mysqli_fetch_array($quPro)){ $branchID = $acc['branch_id']; $roleID = $acc['access_role']; $firstName = $acc['first_name']; $lastName = $acc['last_name']; $compID = $acc['comp_id']; } return [$branchID,$roleID,$firstName,$lastName]; } //########################################################################## function getCompanyName($cID) { include '../../cfg/conn.php'; $querySQL = "SELECT * FROM vts_company WHERE comp_id='$cID'"; $queryResult=mysqli_query($conn, $querySQL); while ($row = mysqli_fetch_array($queryResult)) { $compName = $row['comp_name']; } return $compName; } //########################################################################## function getCompanyNameSub($cID) { include '../../../cfg/conn.php'; $querySQL = "SELECT * FROM vts_company WHERE comp_id='$cID'"; $queryResult=mysqli_query($conn, $querySQL); while ($row = mysqli_fetch_array($queryResult)) { $compName = $row['comp_name']; $compCode = $row['comp_code']; } return [$compName,$compCode]; } //########################################################################## function getDealerNameSub($dID) { $compName = ''; $compCode = ''; include '../../../cfg/conn.php'; $querySQL = "SELECT * FROM vts_dealerships WHERE deal_id='$dID'"; $queryResult=mysqli_query($conn, $querySQL); while ($row = mysqli_fetch_array($queryResult)) { $compName = $row['deal_name']; $compCode = $row['deal_code']; } return [$compName,$compCode]; } //########################################################################## function getDealerID($dCode) { include '../../../cfg/conn.php'; $querySQL = "SELECT * FROM vts_dealerships WHERE deal_code='$dCode'"; $queryResult=mysqli_query($conn, $querySQL); while ($row = mysqli_fetch_array($queryResult)) { $dID = $row['deal_id']; $dName= $row['deal_name']; } return [$dID,$dName]; } //########################################################################## function getCompanyID($cCode) { include '../../../cfg/conn.php'; $querySQL = "SELECT * FROM vts_company WHERE comp_code='$cCode'"; $queryResult=mysqli_query($conn, $querySQL); while ($row = mysqli_fetch_array($queryResult)) { $cID = $row['comp_id']; $cName= $row['comp_name']; } return [$cID,$cName]; } //########################################################################## function getEmployeeEmpInformation($userID) { include '../../../cfg/conn.php'; $emSQL = "SELECT * FROM pms_employee_data WHERE id='$userID'"; $QueryemSQL=mysqli_query($conn, $emSQL); $emRow = mysqli_num_rows($QueryemSQL); while ($row = mysqli_fetch_array($QueryemSQL)) { $eMail = $row['e-mail']; $mobileNo = $row['mobile_no']; $FirstName = $row['first_name']; $LastName = $row['last_name']; } if($emRow >0 ){ return [$eMail,$mobileNo,$LastName,$FirstName]; }else{ return 'NA'; } } //########################################################################## function getBrandName($bID) { include '../../../cfg/conn.php'; $querySQL = "SELECT * FROM pms_brand WHERE id='$bID'"; $queryResult=mysqli_query($conn, $querySQL); while ($row = mysqli_fetch_array($queryResult)) { $brandName = $row['brand_name']; $brandCode = $row['code']; } return [$brandName,$brandCode]; } //########################################################################## function getSalesGroup($grpID) { $gCode=''; $gName=''; include '../../../cfg/conn.php'; $querySQL = "SELECT * FROM pms_sales_group WHERE id='$grpID'"; $queryResult=mysqli_query($conn, $querySQL); while ($row = mysqli_fetch_array($queryResult)) { $gCode = $row['group_code']; $gName= $row['group_name']; } return [$gCode,$gName]; } //########################################################################## function checkViewAccessM1024($roleID, $moduleID){ include '../../../cfg/conn.php'; $viewAccess = 0; $canAdd = 0; $canEdit = 0; $canDelete = 0; $download = 0; $print = 0; $chkAccess ="SELECT `can_view`,`can_add`, `can_edit`,`can_delete`,`print`,`download` FROM `user_profile_data` WHERE `profile_id`='$roleID' AND `deleted`=0 AND `module_id`='$moduleID'"; $qAccess = mysqli_query($conn,$chkAccess); while($row = mysqli_fetch_array($qAccess)){ $viewAccess = $row['can_view']; $canAdd = $row['can_add']; $canEdit = $row['can_edit']; $canDelete = $row['can_delete']; $print = $row['print']; $download = $row['download']; } return [$viewAccess,$canAdd,$canEdit,$canDelete,$print,$download]; } //########################################################################## function RemoveSpecialChar($str) { // Using str_replace() function // to replace the word $res = str_replace( array( '\'', '"','&', '$', '','!','?','\\', ',' , ';', '<', '>' ), '', $str); // Returning the result return $res; } //########################################################################## function sanitize($str) { // Using str_replace() function // to replace the word $res = str_replace( array( '\'', '"','&', '$', '','!','?','\\', ',' , ';', '<', '>' ), '', $str); // Returning the result return $res; } //########################################################################## // ITEXMO SEND SMS API - PHP - CURL METHOD // Visit www.itexmo.com/developers.php for more info about this API //########################################################################## function itexmoAA($number,$message){ $SendToNumber = $number; try { $ch = curl_init(); $itexmo = array( 'Email' => 'aendaya@autohubgroup.com', 'Password' => 'JRE@jre0911', 'ApiCode' => 'PR-AUTOH172111_IE74I', 'SenderId'=> 'AUTOHUB GRP', 'Recipients' => [$SendToNumber], 'Message' => $message ); curl_setopt($ch, CURLOPT_URL,"https://api.itexmo.com/api/broadcast"); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($itexmo)); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $response = curl_exec($ch); //return curl_exec ($ch); curl_close ($ch); return $response; }catch (Exception $ex){ return $ex->getMessage(); } } //########################################################################## // ITEXMO SEND SMS API - PHP - CURL METHOD // Visit www.itexmo.com/developers.php for more info about this API //########################################################################## //########################################################################## function getEmpKRAName($kraID){ include '../../../cfg/conn.php'; $gKra ="SELECT * FROM `kra_employee_tbl` WHERE `id`='$kraID' AND `deleted`=0"; $qgKra = mysqli_query($conn,$gKra); while($row = mysqli_fetch_array($qgKra)){ $kraName = $row['kra_name']; } return [$kraName]; } //########################################################################## function getEmpKPIName($kpiID){ $kpiTarget=0; $kpiName=''; include '../../../cfg/conn.php'; $gKra ="SELECT * FROM `kpi_employee` WHERE `kra_id`='$kpiID' AND `deleted`=0"; $qgKra = mysqli_query($conn,$gKra); while($row = mysqli_fetch_array($qgKra)){ $kpiName = $row['kpi_name']; $kpiTarget = $row['kpi_target']; } return [$kpiName,$kpiTarget]; } //########################################################################## ?> ��

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings