Man, I just had this project given to me - expand on this they say.
This is an example of ONE function:
<?php
//500+ lines of pure wonder.
function page_content_vc($content) {
global $_DBH, $_TPL, $_SET;
$_SET['ignoreTimezone'] = true;
lu_CheckUpdateLogin();
if($_SESSION['dash']['VC']['switch'] == 'unmanned' || $_SESSION['dash']['VC']['switch'] == 'touchscreen') {
if($content['page_name'] != 'vc') {
header('Location: /vc/');
die();
}
}
if($_GET['l']) {
unset($_SESSION['dash']['VC']);
if($loc_id = lu_GetFieldValue('ID', 'Location', $_GET['l'])) {
if(lu_CheckPermissions('vc', $loc_id)) {
$timezone = lu_GetFieldValue('Time Zone', 'Location', $loc_id, 'ID');
if(strlen($timezone) > 0) {
$_SESSION['time_zone'] = $timezone;
}
$_SESSION['dash']['VC']['loc_ID'] = $loc_id;
header('Location: /vc/');
die();
}
}
}
if($_SESSION['dash']['VC']['loc_ID']) {
$timezone = lu_GetFieldValue('Time Zone', 'Location', $_SESSION['dash']['VC']['loc_ID'], 'ID');
if(strlen($timezone) > 0) {
$_SESSION['time_zone'] = $timezone;
}
$loc_id = $_SESSION['dash']['VC']['loc_ID'];
$org_id = lu_GetFieldValue('record_ID', 'Location', $loc_id);
$_TPL->assign('loc_id', $loc_id);
$location_name = lu_GetFieldValue('Location Name', 'Location', $loc_id);
$_TPL->assign('LocationName', $location_name);
$customer_name = lu_GetFieldValue('Customer Name', 'Organisation', $org_id);
$_TPL->assign('CustomerName', $customer_name);
$enable_visitor_snap = lu_GetFieldValue('VisitorSnap', 'Location', $loc_id);
$_TPL->assign('EnableVisitorSnap', $enable_visitor_snap);
$lacps = explode("\n", lu_GetFieldValue('Location Access Control Point', 'Location', $loc_id));
array_walk($lacps, 'trim_value');
if(count($lacps) > 0) {
if(count($lacps) == 1) {
$_SESSION['dash']['VC']['lacp'] = $lacps[0];
}
else {
if($_GET['changeLACP'] && in_array($_GET['changeLACP'], $lacps)) {
$_SESSION['dash']['VC']['lacp'] = $_GET['changeLACP'];
header('Location: /vc/');
die();
}
else if(!in_array($_SESSION['dash']['VC']['lacp'], $lacps)) {
$_SESSION['dash']['VC']['lacp'] = $lacps[0];
}
$_TPL->assign('LACP_array', $lacps);
}
$_TPL->assign('current_LACP', $_SESSION['dash']['VC']['lacp']);
$_TPL->assign('showContractorSearch', true);
/*
if($contractorStaff = lu_GetTableRow('ContractorStaff', $org_id, 'record_ID', 'record_Inactive != "checked"')) {
foreach($contractorStaff['rows'] as $contractor) {
$lacp_rights = lu_OrganiseCustomDataFunctionMultiselect($contractor[lu_GetFieldName('Location Access Rights', 'ContractorStaff')]);
if(in_array($_SESSION['dash']['VC']['lacp'], $lacp_rights)) {
$_TPL->assign('showContractorSearch', true);
}
}
}
*/
}
$selectedOptions = explode(',', lu_GetFieldValue('Included Fields', 'Location', $_SESSION['dash']['VC']['loc_ID']));
$newOptions = array();
foreach($selectedOptions as $selOption) {
$so_array = explode('|', $selOption, 2);
if(count($so_array) > 1) {
$newOptions[$so_array[0]] = $so_array[1];
}
else {
$newOptions[$so_array[0]] = "Both";
}
}
if($newOptions[lu_GetFieldName('Expected Length of Visit', 'Visitor')]) {
$alert = false;
if($visitors = lu_OrganiseVisitors(
lu_GetTableRow('Visitor', 'checked',
lu_GetFieldName('Checked In', 'Visitor'),
lu_GetFieldName('Location for Visit', 'Visitor').'="'.$_SESSION['dash']['VC']['loc_ID'].'"
AND '.lu_GetFieldName('Checked Out', 'Visitor').' != "checked"'), false, true, true)) {
foreach($visitors['rows'] as $key => $visitor) {
if($visitor['expected'] && $visitor['expected'] + (60*30) < time()) {
$alert = true;
}
}
}
if($alert == true) {
$_TPL->assign('showAlert', 'red');
}
else {
//$_TPL->assign('showAlert', 'green');
}
}
$_TPL->assign('switch', $_SESSION['dash']['VC']['switch']);
if($_SESSION['dash']['VC']['switch'] == 'touchscreen') {
$_TPL->assign('VC_unmanned', true);
}
if($_GET['check'] == 'in') {
if($_SESSION['dash']['VC']['switch'] == 'touchscreen') {
lu_CheckInTouchScreen();
}
else {
lu_CheckIn();
}
}
else if($_GET['check'] == 'out') {
if($_SESSION['dash']['VC']['switch'] == 'touchscreen') {
lu_CheckOutTouchScreen();
}
else {
lu_CheckOut();
}
}
else if($_GET['switch'] == 'unmanned') {
$_SESSION['dash']['VC']['switch'] = 'unmanned';
if($_GET['printing'] == true && (lu_GetFieldValue('Printing', 'Location', $_SESSION['dash']['VC']['loc_ID']) != "No" && lu_GetFieldValue('Printing', 'Location', $_SESSION['dash']['VC']['loc_ID']) != "")) {
$_SESSION['dash']['VC']['printing'] = true;
}
else {
$_SESSION['dash']['VC']['printing'] = false;
}
header('Location: /vc/');
die();
}
else if($_GET['switch'] == 'touchscreen') {
$_SESSION['dash']['VC']['switch'] = 'touchscreen';
if($_GET['printing'] == true && (lu_GetFieldValue('Printing', 'Location', $_SESSION['dash']['VC']['loc_ID']) != "No" && lu_GetFieldValue('Printing', 'Location', $_SESSION['dash']['VC']['loc_ID']) != "")) {
$_SESSION['dash']['VC']['printing'] = true;
}
else {
$_SESSION['dash']['VC']['printing'] = false;
}
header('Location: /vc/');
die();
}
else if($_GET['switch'] == 'manned') {
if($_POST['password']) {
if(md5($_POST['password']) == $_SESSION['dash']['password']) {
unset($_SESSION['dash']['VC']['switch']);
//setcookie('email', "", time() - 3600);
//setcookie('location', "", time() - 3600);
header('Location: /vc/');
die();
}
else {
$_TPL->assign('switchLoginError', 'Incorrect Password');
}
}
$_TPL->assign('switchLogin', 'true');
}
else if($_GET['m'] == 'visitor') {
lu_ModifyVisitorVC();
}
else if($_GET['m'] == 'enote') {
lu_ModifyEnoteVC();
}
else if($_GET['m'] == 'medical') {
lu_ModifyMedicalVC();
}
else if($_GET['print'] == 'label' && $_GET['v']) {
lu_PrintLabelVC();
}
else {
unset($_SESSION['dash']['VC']['checkin']);
unset($_SESSION['dash']['VC']['checkout']);
$_TPL->assign('icon', 'GroupCheckin');
if($_SESSION['dash']['VC']['switch'] != 'unmanned' && $_SESSION['dash']['VC']['switch'] != 'touchscreen') {
$staff_ids = array();
if($staffs = lu_GetTableRow('Staff', $_SESSION['dash']['VC']['loc_ID'], 'record_ID')) {
foreach($staffs['rows'] as $staff) {
$staff_ids[] = $staff['ID'];
}
}
if($_GET['view'] == "tomorrow") {
$dateStart = date('Y-m-d', mktime(0, 0, 0, date("m") , date("d")+1, date("Y")));
$dateEnd = date('Y-m-d', mktime(0, 0, 0, date("m") , date("d")+1, date("Y")));
}
else if($_GET['view'] == "month") {
$dateStart = date('Y-m-d', mktime(0, 0, 0, date("m"), date("d"), date("Y")));
$dateEnd = date('Y-m-d', mktime(0, 0, 0, date("m"), date("d")+30, date("Y")));
}
else if($_GET['view'] == "week") {
$dateStart = date('Y-m-d', mktime(0, 0, 0, date("m"), date("d"), date("Y")));
$dateEnd = date('Y-m-d', mktime(0, 0, 0, date("m"), date("d")+7, date("Y")));
}
else {
$dateStart = date('Y-m-d');
$dateEnd = date('Y-m-d');
}
if(lu_GetFieldValue('Enable Survey', 'Location', $_SESSION['dash']['VC']['loc_ID']) == 'checked'
&& lu_GetFieldValue('Add Survey', 'Location', $_SESSION['dash']['VC']['loc_ID']) == 'checked') {
$_TPL->assign('enableSurvey', true);
}
//lu_GetFieldName('Checked In', 'Visitor')
//!= "checked"
//date('d/m/Y'), lu_GetFieldName('Date of Visit', 'Visitor')
if($visitors = lu_OrganiseVisitors(lu_GetTableRow('Visitor', $_SESSION['dash']['VC']['loc_ID'], lu_GetFieldName('Location for Visit', 'Visitor'), lu_GetFieldName('Checked In', 'Visitor').' != "checked" AND '.lu_GetFieldName('Checked Out', 'Visitor').' != "checked" AND '.lu_GetFieldName('Date of Visit', 'Visitor').' >= "'.$dateStart.'" AND '.lu_GetFieldName('Date of Visit', 'Visitor').' <= "'.$dateEnd.'"'))) {
foreach($visitors['days'] as $day => $visitors_day) {
foreach($visitors_day['rows'] as $key => $visitor) {
$visitors['days'][$day]['rows'][$key]['visiting'] = lu_GetTableRow('Staff', $visitor['record_ID'], 'ID');
$visitors['days'][$day]['rows'][$key]['visiting']['notify'] = $_DBH->getRow('SELECT * FROM lu_notification WHERE ent_ID = "'.$visitor['record_ID'].'"');
}
}
//array_dump($visitors);
$_TPL->assign('visitors', $visitors);
}
if($_GET['conGroup']) {
if($_GET['action'] == 'add') {
$_SESSION['dash']['VC']['conGroup'][$_GET['conGroup']] = $_GET['conGroup'];
}
else {
unset($_SESSION['dash']['VC']['conGroup'][$_GET['conGroup']]);
}
}
if(count($_SESSION['dash']['VC']['conGroup']) > 0) {
if($conGroupResult = lu_GetTableRow('ContractorStaff', '1', '1', ' ID IN ('.implode(',', $_SESSION['dash']['VC']['conGroup']).')')) {
if($_POST['_submit'] == 'Check-In Group >>') {
$form = lu_GetForm('VisitorStandard');
$standarddata = array();
foreach($form['items'] as $key=>$item) {
$standarddata[$key] = $_POST[lu_GetFieldName($item['name'], 'Visitor')];
}
foreach($conGroupResult['rows'] as $conStaff) {
$data = $standarddata;
foreach($form['items'] as $key=>$item) {
if($key != 'ID' && $key != 'record_ID' && $conStaff[lu_GetFieldName(lu_GetNameField($key, 'Visitor'), 'ContractorStaff')]) {
$data[$key] = $conStaff[lu_GetFieldName(lu_GetNameField($key, 'Visitor'), 'ContractorStaff')];
}
}
$data['record_ID'] = $data[lu_GetFieldName('Visiting', 'Visitor')];
$data[lu_GetFieldName('Date of Visit', 'Visitor')] = date('Y-m-d');
$data[lu_GetFieldName('Time of Visit', 'Visitor')] = date('H:i');
$data[lu_GetFieldName('Checked In', 'Visitor')] = 'checked';
$data[lu_GetFieldName('Location for Visit', 'Visitor')] = $_SESSION['dash']['VC']['loc_ID'];
$data[lu_GetFieldName('ConStaff ID', 'Visitor')] = $conStaff['ID'];
$data[lu_GetFieldName('From', 'Visitor')] = lu_GetFieldValue('Legal Name', 'Contractor', $conStaff[lu_GetFieldName('Contractor', 'ContractorStaff')]);
$id = lu_UpdateData($form, $data);
lu_VisitorCheckIn($id);
//array_dump($data);
//array_dump($id);
}
unset($_SESSION['dash']['VC']['conGroup']);
header('Location: /vc/');
die();
}
if(count($conGroupResult['rows'])) {
foreach($conGroupResult['rows'] as $key => $cstaff) {
$conGroupResult['rows'][$key]['contractor'] = lu_GetTableRow('Contractor', $cstaff[lu_GetFieldName('Contractor', 'ContractorStaff')], 'ID');
}
$_TPL->assign('conGroupResult', $conGroupResult);
}
$conGroupForm = lu_GetForm('VisitorConGroup');
$conGroupForm = lu_OrganiseVisitorForm($conGroupForm, $_SESSION['dash']['VC']['loc_ID'], 'Contractor');
$secure_options_array = lu_GetSecureOptions($org_id);
if($secure_options_array[$_SESSION['dash']['VC']['loc_ID']]) {
$conGroupForm['items'][lu_GetFieldName('Secure Area', 'Visitor')]['options']['values'] = $secure_options_array[$_SESSION['dash']['VC']['loc_ID']];
$conGroupForm['items'][lu_GetFieldName('Secure Area', 'Visitor')]['name'] = 'Secure Area';
}
else {
unset($conGroupForm['items'][lu_GetFieldName('Secure Area', 'Visitor')]);
}
if($secure_options_array) {
$form['items'][lu_GetFieldName('Secure Area', 'Visitor')]['options']['values'] = $secure_options_array;
$form['items'][lu_GetFieldName('Secure Area', 'Visitor')]['name'] = 'Secure Area';
}
else {
unset($form['items'][lu_GetFieldName('Secure Area', 'Visitor')]);
}
$_TPL->assign('conGroupForm', $conGroupForm);
$_TPL->assign('hideFormCancel', true);
}
}
if($_GET['searchVisitors']) {
$_TPL->assign('searchVisitorsQuery', $_GET['searchVisitors']);
$where = '';
if($_GET['searchVisitorsIn'] == 'Yes') {
$where .= ' AND '.lu_GetFieldName('Checked In', 'Visitor').' = "checked"';
$_TPL->assign('searchVisitorsIn', 'Yes');
}
else {
$where .= ' AND '.lu_GetFieldName('Checked In', 'Visitor').' != "checked"';
$_TPL->assign('searchVisitorsIn', 'No');
}
if($_GET['searchVisitorsOut'] == 'Yes') {
$where = '';
$where .= ' AND '.lu_GetFieldName('Checked Out', 'Visitor').' = "checked"';
$_TPL->assign('searchVisitorsOut', 'Yes');
}
else {
$where .= ' AND '.lu_GetFieldName('Checked Out', 'Visitor').' != "checked"';
$_TPL->assign('searchVisitorsOut', 'No');
}
if($searchVisitors = lu_OrganiseVisitors(lu_GetTableRow('Visitor', $_GET['searchVisitors'], '#search#', lu_GetFieldName('Location for Visit', 'Visitor').'="'.$_SESSION['dash']['VC']['loc_ID'].'"'.$where))) {
foreach($searchVisitors['rows'] as $key => $visitor) {
$searchVisitors['rows'][$key]['visiting'] = lu_GetTableRow('Staff', $visitor['record_ID'], 'ID');
}
$_TPL->assign('searchVisitors', $searchVisitors);
}
else {
$_TPL->assign('searchVisitorsNotFound', true);
}
}
else if($_GET['searchStaff']) {
if($_POST['staff_id']) {
if(lu_CheckPermissions('staff', $_POST['staff_id'])) {
$_DBH->query('UPDATE '.lu_GetTableName('Staff').' SET '.lu_GetFieldName('Current Location', 'Staff').' = "'.$_POST['current_location'].'" WHERE ID="'.$_POST['staff_id'].'"');
}
}
$locations = lu_GetTableRow('Location', $org_id, 'record_ID');
if(count($locations['rows']) > 1) {
$_TPL->assign('staffLocations', $locations);
}
$loc_ids = array();
foreach($locations['rows'] as $location) {
$loc_ids[] = $location['ID'];
}
// array_dump($locations);
// array_dump($_POST);
$_TPL->assign('searchStaffQuery', $_GET['searchStaff']);
$where = ' AND record_Inactive != "checked"';
if($_GET['searchStaffIn'] == 'Yes' && $_GET['searchStaffOut'] != 'Yes') {
$where .= ' AND ('.lu_GetFieldName('Staff Status', 'Staff').' = "" OR '.lu_GetFieldName('Staff Status', 'Staff').' = "On-Site")'.
$_TPL->assign('searchStaffIn', 'Yes');
$_TPL->assign('searchStaffOut', 'No');
}
else if($_GET['searchStaffOut'] == 'Yes' && $_GET['searchStaffIn'] != 'Yes') {
$where .= ' AND ('.lu_GetFieldName('Staff Status', 'Staff').' != "" AND '.lu_GetFieldName('Staff Status', 'Staff').' != "On-Site")'.
$_TPL->assign('searchStaffOut', 'Yes');
$_TPL->assign('searchStaffIn', 'No');
}
else {
$_TPL->assign('searchStaffOut', 'Yes');
$_TPL->assign('searchStaffIn', 'Yes');
}
if($searchStaffs = lu_GetTableRow('Staff', $_GET['searchStaff'], '#search#', 'record_ID IN ('.implode(',', $loc_ids).')'.$where, lu_GetFieldName('First Name', 'Staff').','.lu_GetFieldName('Surname', 'Staff'))) {
$_TPL->assign('searchStaffs', $searchStaffs);
}
else {
$_TPL->assign('searchStaffNotFound', true);
}
}
else if($_GET['searchContractor']) {
$_TPL->assign('searchContractorQuery', $_GET['searchContractor']);
//$where = ' AND '.lu_GetTableName('ContractorStaff').'.record_Inactive != "checked"';
$where = ' ';
if($_GET['searchContractorIn'] == 'Yes' && $_GET['searchContractorOut'] != 'Yes') {
$where .= ' AND ('.lu_GetFieldName('Onsite Status', 'ContractorStaff').' = "Onsite")';
$_TPL->assign('searchContractorIn', 'Yes');
$_TPL->assign('searchContractorOut', 'No');
}
else if($_GET['searchContractorOut'] == 'Yes' && $_GET['searchContractorIn'] != 'Yes') {
$where .= ' AND ('.lu_GetFieldName('Onsite Status', 'ContractorStaff').' != "Onsite")'.
$_TPL->assign('searchContractorOut', 'Yes');
$_TPL->assign('searchContractorIn', 'No');
}
else {
$_TPL->assign('searchContractorOut', 'Yes');
$_TPL->assign('searchContractorIn', 'Yes');
}
$join = 'LEFT JOIN '.lu_GetTableName('Contractor').' ON '.lu_GetTableName('Contractor').'.ID = '.lu_GetTableName('ContractorStaff').'.'.lu_GetFieldName('Contractor', 'ContractorStaff');
$extrasearch = array (
lu_GetTableName('Contractor').'.'.lu_GetFieldName('Legal Name', 'Contractor')
);
if($searchContractorResult = lu_GetTableRow('ContractorStaff', $_GET['searchContractor'], '#search#', lu_GetTableName('ContractorStaff').'.record_ID = "'.$org_id.'" '.$where, lu_GetFieldName('First Name', 'ContractorStaff').','.lu_GetFieldName('Surname', 'ContractorStaff'), $join, $extrasearch)) {
/*
foreach($searchContractorResult['rows'] as $key=>$contractor) {
$lacp_rights = lu_OrganiseCustomDataFunctionMultiselect($contractor[lu_GetFieldName('Location Access Rights', 'ContractorStaff')]);
if(!in_array($_SESSION['dash']['VC']['lacp'], $lacp_rights)) {
unset($searchContractorResult['rows'][$key]);
}
}
*/
if(count($searchContractorResult['rows'])) {
foreach($searchContractorResult['rows'] as $key => $cstaff) {
/*
if($cstaff[lu_GetFieldName('Onsite_Status', 'Contractor')] == 'Onsite')) {
if($visitor['rows'][0][lu_GetFieldName('ConStaff ID', 'Visitor')]) {
$_DBH->query('UPDATE '.lu_GetTableName('ContractorStaff').' SET '.lu_GetFieldName('Onsite Status', 'ContractorStaff').' = "" WHERE ID="'.$visitor['rows'][0][lu_GetFieldName('ConStaff ID', 'Visitor')].'"');
}
}
*/
if($cstaff[lu_GetFieldName('SACN Expiry Date', 'ContractorStaff')] != '0000-00-00') {
if(strtotime($cstaff[lu_GetFieldName('SACN Expiry Date', 'ContractorStaff')]) < time()) {
$searchContractorResult['rows'][$key]['sacn_expiry'] = true;
}
else {
$searchContractorResult['rows'][$key]['sacn_expiry'] = false;
}
}
else {
$searchContractorResult['rows'][$key]['sacn_expiry'] = false;
}
if($cstaff[lu_GetFieldName('Induction Valid Until', 'ContractorStaff')] != '0000-00-00') {
if(strtotime($cstaff[lu_GetFieldName('Induction Valid Until', 'ContractorStaff')]) < time()) {
$searchContractorResult['rows'][$key]['induction_expiry'] = true;
}
else {
$searchContractorResult['rows'][$key]['induction_expiry'] = false;
}
}
else {
$searchContractorResult['rows'][$key]['induction_expiry'] = false;
}
$searchContractorResult['rows'][$key]['contractor'] = lu_GetTableRow('Contractor', $cstaff[lu_GetFieldName('Contractor', 'ContractorStaff')], 'ID');
}
$_TPL->assign('searchContractorResult', $searchContractorResult);
}
else {
$_TPL->assign('searchContractorNotFound', true);
}
}
else {
$_TPL->assign('searchContractorNotFound', true);
}
}
$occupancy = array();
$occupancy['staffNumber'] = $_DBH->getOne('SELECT count(*) FROM '.lu_GetTableName('Staff').' WHERE record_ID = "'.$_SESSION['dash']['VC']['loc_ID'].'" AND record_Inactive != "checked" AND '.lu_GetFieldName('Ignore Counts', 'Staff').' != "checked"');
$occupancy['staffNumberOnsite']= $_DBH->getOne(
'SELECT count(*) FROM '.lu_GetTableName('Staff').' WHERE
(
(record_ID = "'.$_SESSION['dash']['VC']['loc_ID'].'"
AND
('.lu_GetFieldName('Staff Status', 'Staff').' = "" OR '.lu_GetFieldName('Staff Status', 'Staff').' = "On-Site"))
OR '.lu_GetFieldName('Current Location', 'Staff').' = "'.$_SESSION['dash']['VC']['loc_ID'].'")
AND record_Inactive != "checked"
AND '.lu_GetFieldName('Ignore Counts', 'Staff').' != "checked"');
$occupancy['visitorsOnsite'] = $_DBH->getOne('SELECT count(*) FROM '.lu_GetTableName('Visitor').' WHERE '.lu_GetFieldName('Location for Visit', 'Visitor').' = "'.$_SESSION['dash']['VC']['loc_ID'].'" AND '.lu_GetFieldName('Checked In', 'Visitor').' = "checked" AND '.lu_GetFieldName('Checked Out', 'Visitor').' != "checked"');
$_TPL->assign('occupancy', $occupancy);
if($enotes = lu_GetTableRow('Enote', $org_id, 'record_ID', lu_GetFieldName('Note Emailed', 'Enote').' = "0000-00-00" AND '.lu_GetFieldName('Note Passed On', 'Enote').' != "Yes"')) {
$_TPL->assign('EnoteNotice', true);
}
if($medical = lu_GetTableRow('MedicalRoom', $_SESSION['dash']['VC']['loc_ID'], 'record_ID', 'record_Inactive != "Yes"')) {
$_TPL->assign('MedicalNotice', true);
}
if(lu_GetFieldValue('Printing', 'Location', $_SESSION['dash']['VC']['loc_ID']) != "No" && lu_GetFieldValue('Printing', 'Location', $_SESSION['dash']['VC']['loc_ID']) != "") {
$_TPL->assign('UnmannedPrinting', true);
}
}
else {
if($_SESSION['dash']['VC']['printing'] == true) {
$_TPL->assign('UnmannedPrinting', true);
}
}
// enable if contractor check-in buttons should be enabled
if(lu_GetFieldValue('Enable Contractor Check In', 'Location', $_SESSION['dash']['VC']['loc_ID']) == "checked") {
$_TPL->assign('ContractorCheckin', true);
}
}
if($_SESSION['dash']['entity_id'] && $_GET['fixupCon'] == 'true') {
$conStaffs = lu_GetTableRow('ContractorStaff', $_SESSION['dash']['ModifyConStaffs']['org_ID'], 'record_ID', '', lu_GetFieldName('First Name', 'ContractorStaff').','.lu_GetFieldName('Surname', 'ContractorStaff'));
foreach($conStaffs['rows'] as $key => $cstaff) {
if($cstaff[lu_GetFieldName('Site Access Card Number', 'ContractorStaff')] && $cstaff[lu_GetFieldName('Site Access Card Type', 'ContractorStaff')]) {
echo $cstaff['ID'].' ';
$_DBH->query('UPDATE '.lu_GetTableName('Visitor').' SET '.lu_GetFieldName('Site Access Card Number', 'Visitor').' = "'.$cstaff[lu_GetFieldName('Site Access Card Number', 'ContractorStaff')].'", '.lu_GetFieldName('Site Access Card Type', 'Visitor').' = "'.$cstaff[lu_GetFieldName('Site Access Card Type', 'ContractorStaff')].'" WHERE '.lu_GetFieldName('ConStaff ID', 'Visitor').'="'.$cstaff['ID'].'"');
}
}
}
}
else {
if($_SESSION['dash']['staffs']) {
foreach($_SESSION['dash']['staffs']['rows'] as $staff) {
if($staff[lu_GetFieldName('Reception Manager', 'Staff')] == 'checked') {
$loc_id = $staff['record_ID'];
unset($_SESSION['dash']['VC']);
if($loc_id = lu_GetFieldValue('ID', 'Location', $loc_id)) {
$_SESSION['dash']['VC']['loc_ID'] = $loc_id;
header('Location: /vc/');
die();
}
}
}
}
$_TPL->assign('mode', 'public');
}
$content['page_content'] = $_TPL->fetch('modules/vc.htm');
return $content;
}
?>
die();die();die();die();die();
This question will probably be closed - i just need some support from my coding brothers and sisters. *SOB*
