function acknowledgeEvent($id) { //$eid = $request->params('eid'); $sql = "UPDATE `events` SET event_status=2 WHERE event_id=:id"; try { //$dbT = getConnection(); $dbT = getConnt(); $stmt = $dbT->prepare($sql); //$stmt->bindParam("id", $eid) $stmt->bindParam("id", $id); $stmt->execute(); $dbT = null; $response = "UPDATE `events` SET event_status=3 WHERE event_id=" . $id . ';'; echo json_encode($response); } catch (PDOException $e) { echo '{"error":{"text":' . $e->getMessage() . '}}'; } }
function pushNotifications() { $request = Slim::getInstance()->request(); $uid = $request->params('uid'); $wfid = $request->params('wfid'); $msg = $request->params('msg'); $wine = json_decode($request->getBody()); $sql = "INSERT INTO `events` (user_id, wf_id, event_msg) VALUES (:uid, :wfid, :msg)"; try { $dbT = getConnt(); $stmt = $dbT->prepare($sql); $stmt->bindParam("uid", $uid); $stmt->bindParam("wfid", $wfid); $stmt->bindParam("msg", $msg); $stmt->execute(); $event_id = $dbT->lastInsertId(); $response = 'Event-' . $event_id . ' has been created with workflow-' . $wfid; echo json_encode($response); $dbT = null; } catch (PDOException $e) { error_log($e->getMessage(), 3, '/var/tmp/php.log'); echo '{"error":{"text":' . $e->getMessage() . '}}'; } }