File manager

File manager - Edit - /home/autoph/public_html/pms_v1/functions/users.php

Back
<?php //########################################################################## function userProfileID($userID){ include '../../../cfg/conn.php'; $uPro ="SELECT `access_role` FROM `pms_employee_data` WHERE `id`='$userID'"; $quPro = mysqli_query($conn,$uPro); $emRow = mysqli_num_rows($quPro); while($acc = mysqli_fetch_array($quPro)){ $roleID = $acc['access_role']; } if($emRow >0 ){ return $roleID; }else{ return '0'; } } function getSalesGroup($grpID){ include '../../../cfg/conn.php'; $saleSQL = "SELECT * FROM pms_sales_group WHERE id='$grpID'"; $qSales=mysqli_query($conn, $saleSQL); while ($row = mysqli_fetch_array($qSales)) { $groupName = $row['group_name']; } return [$groupName]; } //########################################################################## function getEmployeeEmpInformationB($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']; $branchID = $row['branch_id']; $roleID = $row['access_role']; $compID = $row['comp_id']; $ProPic = $row['profile_pic']; } if($emRow >0 ){ return [$eMail,$mobileNo,$LastName,$FirstName,$branchID,$roleID,$compID,$ProPic]; }else{ return 'NA'; } } //########################################################################## 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']; $compCode = $row['comp_code']; } return [$compName]; } //########################################################################## function getMainDivision($mID) { include '../../../cfg/conn.php'; $querySQL = "SELECT * FROM pms_sub_group WHERE id='$mID'"; $queryResult=mysqli_query($conn, $querySQL); while ($row = mysqli_fetch_array($queryResult)) { $mainDiv = $row['sub_group_code']; $mainDivName = $row['sub_group_name']; } return [$mainDiv,$mainDivName]; } //########################################################################## function getDepartmentName() { include '../../../cfg/conn.php'; $querySQL = "SELECT * FROM pms_department_tbl WHERE id='1'"; $queryResult=mysqli_query($conn, $querySQL); while($row = mysqli_fetch_array($queryResult)){ $dptCode = $row['dept_code']; $dptName = $row['dept_name']; } return [$dptCode,$dptName]; } //########################################################################## function getAutohubGroupName($ahgID) { include '../../../cfg/conn.php'; $querySQL = "SELECT * FROM pms_group_tbl WHERE id='$ahgID'"; $queryResult=mysqli_query($conn, $querySQL); while ($row = mysqli_fetch_array($queryResult)) { $ahgName = $row['name']; $ahgCode = $row['code']; } return [$ahgName,$ahgCode]; } //########################################################################## function getCompanyNameSub($cID) { include '../../../cfg/conn.php'; $compName="NA"; $compCode="NA"; $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) { include '../../../cfg/conn.php'; $dealName="NA"; $dealCode="NA"; $querySQL = "SELECT * FROM vts_dealerships WHERE deal_id='$dID'"; $queryResult=mysqli_query($conn, $querySQL); while ($row = mysqli_fetch_array($queryResult)) { $dealName = $row['deal_name']; $dealCode = $row['deal_code']; } return [$dealName,$dealCode]; } //########################################################################## 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 getBrandID($branchID) { include '../../../cfg/conn.php'; $querySQL = "SELECT * FROM vts_dealerships WHERE deal_id='$branchID'"; $queryResult=mysqli_query($conn, $querySQL); while ($row = mysqli_fetch_array($queryResult)) { $brandID = $row['brand']; $compCode = $row['deal_code']; } return [$brandID]; } //########################################################################## function getBrandName($brandID) { include '../../../cfg/conn.php'; $querySQL = "SELECT * FROM pms_brand WHERE id='$brandID'"; $queryResult=mysqli_query($conn, $querySQL); while ($row = mysqli_fetch_array($queryResult)) { $brand = $row['brand_name']; } return [$brand]; } //########################################################################## 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 getPositionName($pID) { include '../../../cfg/conn.php'; $posName="NA"; $querySQL = "SELECT * FROM pms_positions_tbl WHERE id='$pID'"; $queryResult=mysqli_query($conn, $querySQL); while ($row = mysqli_fetch_array($queryResult)) { $posName = $row['position_name']; } return [$posName]; } //########################################################################## 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']; $ProPic = $row['profile_pic']; } if($emRow >0 ){ return [$eMail,$mobileNo,$LastName,$FirstName,$ProPic]; }else{ return 'NA'; } } //########################################################################## 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 `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; } //########################################################################## function getAutohubKRAName($kraID){ include '../../../cfg/conn.php'; $gKra ="SELECT * FROM `kra_group_detl` WHERE `id`='$kraID' "; $qgKra = mysqli_query($conn,$gKra); while($row = mysqli_fetch_array($qgKra)){ $kraName = $row['kra_name']; $kraID = $row['id']; $kraWeight = $row['weight']; } return [$kraName,$kraWeight]; } //########################################################################## function getAutohubKPIName($kpiID){ include '../../../cfg/conn.php'; $gKpi ="SELECT * FROM `kpi_company` WHERE `id`='$kpiID' "; $qggKpi = mysqli_query($conn,$gKpi); while($row = mysqli_fetch_array($qggKpi)){ $kpiName = $row['kpi_name']; $kpiID = $row['id']; $kpiWeight = $row['kpi_weight']; $kpiTarget = $row['kpi_target']; } return [$kpiName,$kpiWeight,$kpiTarget]; } //########################################################################## function getCompanyKRAName($kraID){ include '../../../cfg/conn.php'; $gKra ="SELECT * FROM `kra_comp_detl` WHERE `id`='$kraID' "; $qgKra = mysqli_query($conn,$gKra); while($row = mysqli_fetch_array($qgKra)){ $kraName = $row['kra_name']; $kraID = $row['id']; $kraWeight = $row['weight']; } return [$kraName,$kraWeight]; } //########################################################################## function getCompanyKPIName($kpiID){ include '../../../cfg/conn.php'; $gKpi ="SELECT * FROM `kpi_company` WHERE `id`='$kpiID' "; $qggKpi = mysqli_query($conn,$gKpi); while($row = mysqli_fetch_array($qggKpi)){ $kpiName = $row['kpi_name']; $kpiID = $row['id']; $kpiWeight = $row['kpi_weight']; $kpiTarget = $row['kpi_target']; } return [$kpiName,$kpiWeight,$kpiTarget]; } //########################################################################## function getBranchKRAName($kraID){ include '../../../cfg/conn.php'; $gKra ="SELECT * FROM `kra_branch_tbl` WHERE `id`='$kraID' "; $qgKra = mysqli_query($conn,$gKra); while($row = mysqli_fetch_array($qgKra)){ $kraName = $row['kra_name']; $kraID = $row['id']; $kraWeight = $row['weight']; } return [$kraName,$kraWeight]; } //########################################################################## function getBranchKPIName($kraID){ include '../../../cfg/conn.php'; $gKra ="SELECT * FROM `kpi_branch` WHERE `id`='$kraID' "; $qgKra = mysqli_query($conn,$gKra); while($row = mysqli_fetch_array($qgKra)){ $kpiName = $row['kpi_name']; $kpiWeight = $row['kpi_weight']; } return [$kpiName,$kpiWeight]; } //########################################################################## function getEmpKRAName($kraID){ include '../../../cfg/conn.php'; $gKra ="SELECT * FROM `kra_employee_tbl` WHERE `id`='$kraID' "; $qgKra = mysqli_query($conn,$gKra); while($row = mysqli_fetch_array($qgKra)){ $kraName = $row['kra_name']; } return [$kraName]; } //########################################################################## function getDivisionKraName($kraID){ include '../../../cfg/conn.php'; $gKra ="SELECT * FROM `kra_division_child_tbl` WHERE `id`='$kraID' "; $qgKra = mysqli_query($conn,$gKra); while($row = mysqli_fetch_array($qgKra)){ $kraName = $row['kra_name']; $kraWeight = $row['weight']; } return [$kraName,$kraWeight]; } //########################################################################## function getDivisionKpiName($kpiID){ include '../../../cfg/conn.php'; $gKpi ="SELECT * FROM `kpi_childdivision` WHERE `id`='$kpiID' "; $qgKpi = mysqli_query($conn,$gKpi); while($row = mysqli_fetch_array($qgKpi)){ $kpiName = $row['kpi_name']; $kpiWeight = $row['kpi_weight']; $kpiTarget = $row['kpi_target']; } return [$kpiName,$kpiTarget,$kpiWeight]; } //########################################################################## function getMainDivisionKraName($kraID){ include '../../../cfg/conn.php'; $gKra ="SELECT * FROM `kra_division_tbl` WHERE `id`='$kraID' "; $qgKra = mysqli_query($conn,$gKra); while($row = mysqli_fetch_array($qgKra)){ $kraName = $row['kra_name']; $kraWeight = $row['weight']; } return [$kraName,$kraWeight]; } //########################################################################## function getMainDivisionKpiName($kpiID){ include '../../../cfg/conn.php'; $gKpi ="SELECT * FROM `kpi_maindivision` WHERE `id`='$kpiID' "; $qgKpi = mysqli_query($conn,$gKpi); while($row = mysqli_fetch_array($qgKpi)){ $kpiName = $row['kpi_name']; $kpiWeight = $row['kpi_weight']; $kpiTarget = $row['kpi_target']; } return [$kpiName,$kpiTarget,$kpiWeight]; } //########################################################################## function getGroupKraName($kraID){ include '../../../cfg/conn.php'; $gKra ="SELECT * FROM `kra_division_tbl` WHERE `id`='$kraID' "; $qgKra = mysqli_query($conn,$gKra); while($row = mysqli_fetch_array($qgKra)){ $kraName = $row['kra_name']; $kraWeight = $row['weight']; } return [$kraName,$kraWeight]; } //########################################################################## function getGroupKpiName($kpiID){ include '../../../cfg/conn.php'; $gKpi ="SELECT * FROM `kpi_maindivision` WHERE `id`='$kpiID' "; $qgKpi = mysqli_query($conn,$gKpi); while($row = mysqli_fetch_array($qgKpi)){ $kpiName = $row['kpi_name']; $kpiWeight = $row['kpi_weight']; $kpiTarget = $row['kpi_target']; } return [$kpiName,$kpiTarget,$kpiWeight]; } //########################################################################## function getDeptKraName($kraID){ include '../../../cfg/conn.php'; $gKra ="SELECT * FROM `kra_department_tbl` WHERE `id`='$kraID' "; $qgKra = mysqli_query($conn,$gKra); while($row = mysqli_fetch_array($qgKra)){ $kraName = $row['kra_name']; $kraWeight = $row['weight']; } return [$kraName,$kraWeight]; } //########################################################################## function getDeptKpiData($kpiID){ include '../../../cfg/conn.php'; $gKpi ="SELECT * FROM `kpi_department` WHERE `id`='$kpiID' "; $qgKpi = mysqli_query($conn,$gKpi); while($row = mysqli_fetch_array($qgKpi)){ $kpiName = $row['kpi_name']; $kpiWeight = $row['kpi_weight']; $kpiTarget = $row['kpi_target']; } return [$kpiName,$kpiTarget,$kpiWeight]; } //########################################################################## function getPositionKRAName($kraID){ include '../../../cfg/conn.php'; $gKra ="SELECT * FROM `kra_position_tbl` WHERE `id`='$kraID'"; $qgKra = mysqli_query($conn,$gKra); while($row = mysqli_fetch_array($qgKra)){ $kraName = $row['kra_name']; $kraID = $row['id']; $kraWeight = $row['weight']; } return [$kraName,$kraWeight]; } //########################################################################## function getPositionKPIName($kpiID){ include '../../../cfg/conn.php'; $gKpi ="SELECT * FROM `kpi_position` WHERE `id`='$kpiID'"; $qggKpi = mysqli_query($conn,$gKpi); while($row = mysqli_fetch_array($qggKpi)){ $kpiName = $row['kpi_name']; $kpiID = $row['id']; $kpiWeight = $row['kpi_weight']; $kpiTarget = $row['kpi_target']; } return [$kpiName,$kpiWeight,$kpiTarget]; } //########################################################################## function getEmployeeKRAName($kraID){ include '../../../cfg/conn.php'; $kraName=''; $kraWeight=''; $gKra ="SELECT * FROM `kra_employee_tbl` WHERE `id`=$kraID"; $qgKra = mysqli_query($conn,$gKra); while($row = mysqli_fetch_array($qgKra)){ $kraName = $row['kra_name']; $kraWeight = $row['weight']; } return [$kraName,$kraWeight]; } //########################################################################## function getEmployeeKPIName($kpiID){ include '../../../cfg/conn.php'; $gKpi ="SELECT * FROM `kpi_employee` WHERE `id`='$kpiID'"; $qggKpi = mysqli_query($conn,$gKpi); while($row = mysqli_fetch_array($qggKpi)){ $kpiName = $row['kpi_name']; $kpiID = $row['id']; $kpiWeight = $row['kpi_weight']; $kpiTarget = $row['kpi_target']; } return [$kpiName,$kpiWeight,$kpiTarget]; } //########################################################################## function getMARDataByPosKRAID($kraID,$pcpID,$posKraWeight,$marMotnh){ $ClrPosKraWeight = explode("%",$posKraWeight); $myPosKRAWeight=$ClrPosKraWeight[0]; include '../../../cfg/conn.php'; $gKpi ="SELECT AVG(`mar_numerical_rating`) AS 'PosKRAmarNR' FROM `mar_emp_data` WHERE `pcp_id`='$pcpID' AND `kra_id`='$kraID' AND `mar_month_data`='$marMotnh' AND `deleted`=0 LIMIT 1"; $qggKpi = mysqli_query($conn,$gKpi); while($row = mysqli_fetch_array($qggKpi)){ $PosKRAmarNR = $row['PosKRAmarNR']; } $myKraWP = ($myPosKRAWeight / 100) * $PosKRAmarNR; return [$myKraWP,$PosKRAmarNR]; } //########################################################################## function getPCPTargetAndWeight($marPCPid,$marKRAid,$pckKPIid){ //$clrWeight = explode("%",$kraWeight); //$weight=$clrWeight[0]; include '../../../cfg/conn.php'; $gKpi ="SELECT `pcp_weight` AS 'pcpWeight',`pcp_target` AS 'pcp_target' FROM `pcp_employee_data` WHERE `pcp_header_id`='$marPCPid' AND `pcp_kra_id`='$marKRAid' AND `pcp_kpi_id`='$pckKPIid' LIMIT 1"; $qggKpi = mysqli_query($conn,$gKpi); $cleanTarget=0; while($row = mysqli_fetch_array($qggKpi)){ $pcpWeight = $row['pcpWeight']; $pcpTarget = $row['pcp_target']; } if(preg_match("/%/",$pcpTarget)){ $per="%"; $cleanTar = explode("%",$pcpTarget); $cleanTarget = $cleanTar[0]; }else{ $per=""; $cleanTarget = $pcpTarget; } $gKpi ="SELECT AVG(`mar_numerical_rating`) AS 'myNumericalRating', `mar_variance_desc`,AVG(`mar_actual`) AS 'marActual',AVG(`my_score`) AS 'marScore' FROM `mar_emp_data` WHERE `pcp_id`='$marPCPid' AND `kra_id`='$marKRAid' AND `kpi_id`='$pckKPIid' LIMIT 1"; $qggKpi = mysqli_query($conn,$gKpi); while($row = mysqli_fetch_array($qggKpi)){ $marActual = $row['marActual']; $marScore = $row['marScore']; $xVarianceDesc = $row['mar_variance_desc']; } $xScore = number_format((($marActual / $cleanTarget) * 100),2,'.'); $xVariance = number_format(($marActual-$cleanTarget),2,'.') ." " .$xVarianceDesc; $myScore = number_format($xScore,2,'.','')."%"; $marActualData = number_format($marActual,2,'.','')."".$per; $gType ="SELECT `type` FROM `kpi_position` WHERE `id`='$pckKPIid'"; $qType = mysqli_query($conn,$gType); $kpiType=''; while($typ = mysqli_fetch_array($qType)){ $kpiType = $typ['type']; } $kpiNR=""; if($kpiType ==='QTY'){ //gps_quantity $kType = "SELECT `to_numeric` FROM `gps_quantity` WHERE '$xScore' BETWEEN `from_percentage` AND `to_percentage` "; $qKtype = mysqli_query($conn,$kType); while($kTy = mysqli_fetch_array($qKtype)){ $kpiNR = number_format(($kTy['to_numeric']),3,'.',''); } }else{ //gps_quality $kType = "SELECT `to_numeric` FROM `gps_quality` WHERE '$xScore' BETWEEN `from_percentage` AND `to_percentage` "; $qKtype = mysqli_query($conn,$kType); while($kTy = mysqli_fetch_array($qKtype)){ $kpiNR = number_format(($kTy['to_numeric']),3,'.',''); } } $kpiWP =""; $kpiClnWeight = explode("%",$pcpWeight); $kpiCleanWeight =$kpiClnWeight[0]; $kpiWP = number_format(($kpiNR * ($kpiCleanWeight/100)),3,'.',''); $perCentile = 0; $perCentile = (($kpiWP) * 100); return [$pcpWeight,$pcpTarget,$marActualData,$myScore,$xVariance,$kpiNR,$kpiWP,$perCentile]; } //########################################################################## function getEmpKPIName($kpiID){ $kpiTarget=0; $kpiName=''; include '../../../cfg/conn.php'; $gKra ="SELECT * FROM `kpi_employee` WHERE `kra_id`='$kpiID' "; $qgKra = mysqli_query($conn,$gKra); while($row = mysqli_fetch_array($qgKra)){ $kpiName = $row['kpi_name']; $kpiTarget = $row['kpi_target']; } return [$kpiName,$kpiTarget]; } //########################################################################## //########################################################################## // 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 //########################################################################## //########################################################################## // ITEXMO SEND SMS API - PHP - CURL METHOD // Visit www.itexmo.com/developers.php for more info about this API //########################################################################## function itexmoA($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 //########################################################################## ?>

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