break;
default:
$result = '';
$query = $db->prepare("CALL proc_smsInbound(:to, :from, :message)");
$query->bindParam(":to", $to, PDO::PARAM_STR);
$query->bindParam(":from", $from, PDO::PARAM_STR);
$query->bindParam(":message", $message, PDO::PARAM_STR);
$query->execute();
break;
}
try {
$call = $db->query($query);
if ($message == 'status') {
foreach ($call as $a) {
switch ($a["allowSMS"]) {
case '0':
$result = 'Text messages are currently turned OFF';
break;
case '1':
$result = 'Text messages are currently turned ON';
break;
}
}
}
if ($result) {
IfByPhone_Util::createSMS($from, $result);
}
} catch (PDOException $e) {
Database::logError('sms_inbound', $e);
IfByPhone_Util::createSMS(ADMIN_PHONE_NUM, 'SMS INBOUND ERROR: ' . $from . ': ' . $message);
}
$results = $conn->query("SELECT @isValid, @employee_pkID, @remotePunch, @isActive, @employee_phone");
foreach ($results as $result) {
if (!$result["@isValid"]) {
// for invalid combination
echo "<action>\n\t\t\t\t\t<app>survo</app>\n\t\t\t\t\t\t<parameters>\n\t\t\t\t\t\t\t<id>394171</id>\n\t\t\t\t\t\t</parameters>\n\t\t\t\t\t</action>";
} else {
$employee_id = $result["@employee_pkID"];
$remote = $result["@remotePunch"];
$active = $result["@isActive"];
$phone = $result["@employee_phone"];
// if the employee does not have access to this feature SURVO ID: 394181
if (!$remote || !$active) {
echo "<action>\n\t\t\t\t\t<app>survo</app>\n\t\t\t\t\t\t<parameters>\n\t\t\t\t\t\t\t<id>394181</id>\n\t\t\t\t\t\t</parameters>\n\t\t\t\t\t</action>";
} else {
// if the employee is valid, and has access, record the timeclock punch, send to survo confirming punch
$query_timeclock = "INSERT into timeclock (employee_pk_id, punchDateTime) VALUES ('" . $employee_id . "','" . $timestamp . "')";
$conn->query($query_timeclock);
echo "<action>\n\t\t\t\t<app>survo</app>\n\t\t\t\t\t<parameters>\n\t\t\t\t\t\t<id>394191</id>\n\t\t\t\t\t\t<p_t>employee_id|" . $employee_id . "</p_t>\n\t\t\t\t\t</parameters>\n\t\t\t\t</action>";
if ($employee_id == '2' || $employee_id == '355') {
$time = strToTime($timestamp);
$msg = "Time recorded: " . date('n-j-Y g:i:s A', $time);
IfByPhone_Util::createSMS($phone, $msg);
}
}
}
}
} catch (PDOException $e) {
Database::logError('tc_verify_employee', $e);
Database::sendToIvrError();
}
$conn = null;
