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;