ajax_service.php

<?php
/**
 * Created by PhpStorm.
 * User: Tyemill
 * Date: 4/13/14
 * Time: 1:47 PM
 */
// ============================== authentication ===============================
//if (session_status() == PHP_SESSION_NONE) {
//    session_start();
//}
//session_regenerate_id();
//if(!isset($_SESSION['user_email'])) {    // if there is no valid session
//    header("Location: index.php?notice=login_first");
//}
    require_once "session_inc.php";
// ============================== authentication ===============================
    require_once "dbconnect.php";
    $root_url = "http://depts.washington.edu/";

if (isset($_GET['trigger']) && isset($_GET['type'])) {
    try {
        $dbq = db_connect();

        $trigger = $_GET['trigger'];
        $type = $_GET['type'];
        $sql = null;

        switch ($type) {
            case "project_artifact" :
                // service for projectArtifact
                $sql = "SELECT a.artifactID AS id, a.artifactTitle AS Title
                        FROM projectArtifact pa
                        join artifact a on a.artifactID = pa.artifactID
                        where pa.projectID = " . $trigger;
                break;
            case "persona_scenario":
                $sql = "select s.scenarioID as id, s.scenarioTitle as Title from personaScenario ps
                        join scenario s on ps.scenarioID = s.scenarioID
                        join personae p on ps.personaID = p.personaeID
                        where p.personaeID = " . $trigger;
                break;
            case "persona_user":
                $sql = "SELECT u.userID as id, CONCAT(u.firstName, ' ', u.lastName) as Title FROM userPersonae up
                        join userProfile u on u.userID = up.userID
                        join personae p on p.personaeID = up.personaeID
                        where up.personaeID = " . $trigger;
                break;
        }

        if ($sql) {
//            $result = $dbq->query($sql);

            $query = $dbq->prepare($sql);
            $query->execute();
            $rows = array();
            while($r = $query->fetch(PDO::FETCH_ASSOC)) {
                $rows[] = $r;
            }
            print json_encode($rows);

//            print_r($result);
        } else {
            echo("error found");
        }
    }
    catch(PDOException $e){
        // Report errors
        // printf ($e->getMessage());
    }



//    echo("Trigger is " . $trigger . "; type is " . $type);
} elseif (isset($_GET['email'])) {
    try {
        $dbq = db_connect();


        $email = $_GET['email'];
        $urpID = $_GET['urpID'];
        $sendEmail = $_GET['sendEmail'];

        $first_query = "SELECT * FROM userRatingProgress urp
                             join userProfile up on urp.userID = up.userID
                             where urp.`userRatingProgressID` = " . $urpID . "
                             and up.email = '" . (string)$email . "'";
        $flag = $dbq->query($first_query)->fetchColumn();
//        $flag->execute();
//        echo($flag);

        if ($flag) {
            $query = $dbq->prepare("SELECT * FROM userRatingProgress urp
                                    join projectArtifact pa on urp.projectArtifactID = pa.projectArtifactID
                                    join userProfile upro on upro.userID = urp.userID
                                    where urp.`userRatingProgressID` = " . $urpID);
            $query->execute();
            $result = $query->fetch(PDO::FETCH_ASSOC);
            if ($result) {
                $project = $result['projectID'];
                $language = $result['preferredLanguage'];
                $artifact = $result['artifactID'];
                $persona = $result['personaID'];
                $scenario = $result['scenarioID'];
                $userName = $result['firstName'] . " " . $result['lastName'];

                $targetURL = "/tedsrate/teds/rater.php?selLanguage=" . $language . "&selProject=" . $project . "&selArtifact=" . $artifact . "&selScenario=" . $scenario . "&selPersona=" . $persona . "&urpId=" . $urpID;

                $email_flag = false;
                $email_message = "Invalid email! Please try again!";
                // sending email function
                if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
                    $to  = (string)$email;

                    // subject
                    $subject = 'You are invited: please help us fill out this evaluation form -- TEDS';

                    // message
                    $message = '
                                <html>
                                <head>
                                  <title>You are invited: please help us fill out this evaluation form -- TEDS</title>
                                </head>
                                <body>
                                  <p>Dear ' . $userName . ', </p>
                                  <p>Please help us make better web! Here is the link to access the TEDS evaluation form for you:</p>
                                  <p><a href="' . $root_url . $targetURL . '" target="blank"><b>Link</b></a></p>
                                  <br />
                                  <br />
                                  <p>Your help is greatly appreciated!</p>
                                  <p>Sincerely,</p>
                                  <p><a href="https://www.washington.edu/" target="blank">University of Washington</a></p>
                                  <p><a href="https://ischool.uw.edu/" target="blank">Information School</a></p>
                                </body>
                                </html>
                                ';

                    // To send HTML mail, the Content-type header must be set
                    $headers  = 'MIME-Version: 1.0' . "\r\n";
                    $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

                    // Additional headers
                    $headers .= 'To: ' . $result['firstName'] . ' <' . $email . '>' . "\r\n";
                    $headers .= 'From: TEDS Eval <' . $root_url . '>' . "\r\n";
                    $headers .= 'Cc: gaodl@uw.edu' . "\r\n";
                    $headers .= 'Bcc: gdlshallowshade@gmail.com' . "\r\n";

                    // Mail it
                    mail($to, $subject, $message, $headers);
                    // modify message
                    $email_flag = true;
                    $email_message = "Url sent successfully to " . $email;
                }

                //
                $final_url = $root_url . $targetURL;
                $final_result = [];
                array_push($final_result,$email_flag, $email_message, $final_url);
                print json_encode($final_result);
            }
        }
    }
    catch (PDOException $e){
        // Report errors
         printf ($e->getMessage());
    }
}