window.location.replace(localStorage.login_source ?? '/login.php?#=2');";
}
if (sanitize_input($_COOKIE['SubcriptionType']) == 1) {
header('Location: pos_main.php');
}
$employeeid = sanitize_input($_COOKIE['employeeid']);
$getUserDetails = $conn->prepare("
SELECT
a.UserType,
a.LocationCode,
a.EmployeeID,
b.UserID
FROM tblemployee a
LEFT JOIN tbluseraccount b ON a.EmployeeID = b.EmployeeID
WHERE a.EmployeeID = ?");
$getUserDetails->execute([$_COOKIE['employeeid']]);
$userDetails = $getUserDetails->fetch();
$getAccesses = $conn->prepare("
SELECT
-- GROUP_CONCAT(b.AccessName Separator ',') as allowedAccesses
a.*
FROM tbluseraccess a
LEFT JOIN tbluseraccesschild b ON a.AccessID = b.AccessID
WHERE b.UserID = ?
AND a.AccessType = ?
group by a.AccessID
ORDER BY a.AccessID ASC");
$getAccesses->execute([$userDetails['UserID'], 'Dashboard']);
$dashboards = $getAccesses->fetchAll();
$getAccesses->execute([$userDetails['UserID'], 'Registry']);
$registries = $getAccesses->fetchAll();
$getAccesses->execute([$userDetails['UserID'], 'Modules']);
$modules = $getAccesses->fetchAll();
$getAccesses->execute([$userDetails['UserID'], 'Reports']);
$reports = $getAccesses->fetchAll();
$useracount = $conn->prepare("SELECT
COUNT(a.AccessName) as xcnt,a.AccessName
FROM tbluseraccess a
LEFT JOIN tbluseraccesschild b ON a.AccessID = b.AccessID
WHERE b.UserID = ? and a.AccessType <>?
ORDER BY a.AccessID ASC");
$useracount->execute([$userDetails['UserID'], 'POS']);
$useracount = $useracount->Fetch();
if ($useracount['xcnt'] == 1) {
if ($useracount['AccessName'] == "Point of Sale") {
header('Location: pos_main.php');
}
}
$getLocations = $conn->prepare("
SELECT
a.LocationCode,
b.LocationName
FROM tblemployee_location a
INNER JOIN tbllocation b ON a.LocationCode = b.LocationCode
WHERE a.EmployeeID = ?
AND b.isActive = 1
group by a.LocationCode
ORDER BY b.Flag DESC, b.LocationCode ASC");
$getLocations->execute([ $employeeid ]);
$locations = $getLocations->fetchAll(PDO::FETCH_ASSOC);
?>
ESSSE