Example #1
0
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() . '}}';
    }
}
Example #2
0
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() . '}}';
    }
}