function todos_request($config, $uri)
{
switch ($_SERVER['REQUEST_METHOD']) {
case 'GET':
find_activity($config);
break;
case 'POST':
//create
create_activity($config);
break;
case 'PUT':
//update
update_activity($config, $uri[3]);
break;
case 'DELETE':
delete_activity($config, $uri[3]);
break;
case 'HEAD':
case 'OPTION':
default:
error_activity();
break;
}
}
prepare_and_execute($stmt, array($business, $title));
// Get new survey's id
$surveyIdQuery = 'SELECT MAX(id) FROM survey;';
$surveyId = select($surveyIdQuery, array(), false);
if ($surveyId != false) {
// Insert survey question rows
$questionStmt = 'INSERT INTO surveyquestion (survey,question) VALUES ';
$questionStmtParams = array();
foreach ($questions as $question) {
$questionStmt = $questionStmt . '(?,?),';
array_push($questionStmtParams, $surveyId[0]);
array_push($questionStmtParams, $question);
}
$questionStmt = rtrim($questionStmt, ',') . ';';
// Removes last comma from statement and adds semicolon to close statement
prepare_and_execute($questionStmt, $questionStmtParams);
// Get name of creator for activity
$businessNameQuery = 'SELECT name FROM business WHERE userEmail = ?';
$nameFound = false;
while (!$nameFound) {
$name = select($businessNameQuery, array($business), false);
if ($name != false) {
// Found name
$businessName = $name[0];
$nameFound = true;
}
}
create_activity($business, 'survey', json_encode(array($businessName . ' has created a new survey', $surveyId[0])));
echo '1';
}
}
// Business moved from bronze badge to silver badge
$newBadge = 'silver';
} else {
if ($curEndorseCnt < 20 && $newEndorseCnt >= 20) {
// Business moved from silver badge to gold badge
$newBadge = 'gold';
} else {
if ($curEndorseCnt < 40 && $newEndorseCnt >= 40) {
// Business moved from gold badge to platinum badge
$newBadge = 'platinum';
}
}
}
}
if ($newBadge != false) {
// Create new badge activity
// Get business's name for activity
$businessNameQuery = 'SELECT name FROM business WHERE userEmail = ?';
$nameFound = false;
while (!$nameFound) {
$name = select($businessNameQuery, array($business), false);
if ($name != false) {
// Found name
$businessName = $name[0];
$nameFound = true;
}
}
create_activity($business, 'badge', json_encode(array($businessName . ' has earned a ' . $newBadge . ' badge from endorsements', $newBadge)));
}
echo '1';
}
$business = $_GET['business'];
if (!isset($_GET['category']) || $_GET['category'] == '') {
$category = null;
} else {
$category = intval($_GET['category']);
}
$title = $_GET['title'];
$content = $_GET['content'];
// Statement to insert forum post row into database
$stmt = 'INSERT INTO forumpost (parentId,postBusiness,category,title,content,groupId,closed) VALUES (NULL,?,?,?,?,NULL,0);';
// Insert forum post row
prepare_and_execute($stmt, array($business, $category, $title, $content));
// Get new post's id
$postIdQuery = 'SELECT MAX(id) FROM forumpost;';
$postId = select($postIdQuery, array(), false);
if ($postId != false) {
// Get name of creator for activity
$businessNameQuery = 'SELECT name FROM business WHERE userEmail = ?';
$nameFound = false;
while (!$nameFound) {
$name = select($businessNameQuery, array($business), false);
if ($name != false) {
// Found name
$businessName = $name[0];
$nameFound = true;
}
}
create_activity($business, 'post', json_encode(array($businessName . ' has created a new forum post', $postId[0])));
}
echo '1';
}
$db->close();
return null;
}
}
function create_activity($title, $target, $content, $authorId)
{
$db = new MyDB();
if (!$db) {
echo $db->lastErrorMsg();
} else {
echo "Opened database successfully</br>";
}
$sql = <<<EOF
INSERT INTO Activity (title, target, content, authorId)
VALUES ('{$title}', '{$target}', '{$content}', '{$authorId}');
EOF;
$ret = $db->exec($sql);
if (!$ret) {
echo $db->lastErrorMsg();
} else {
$db->close();
header("Location: http://www.kmoving.com/user/groups/activity.php");
}
$db->close();
}
$title = $_POST["title"];
$target = $_POST["target"];
$content = $_POST["content"];
$authorId = get_authorId();
create_activity($title, $target, $content, $authorId);
fclose($fp);
} catch (PDOException $e) {
echo '0';
}
$photoIdQuery = 'SELECT MAX(id) FROM photo;';
$photoId = select($photoIdQuery, array(), false);
if ($photoId != false) {
// Get name of uploader for activity
$userNameQuery = 'SELECT name FROM business WHERE userEmail = ?';
$nameFound = false;
while (!$nameFound) {
$name = select($userNameQuery, array($_GET['user']), false);
if ($name != false) {
// Found name
$userName = $name[0];
$nameFound = true;
}
}
create_activity($_GET['user'], 'photo', json_encode(array($userName . ' has added a new photo', intval($photoId[0]))));
}
echo '1';
} else {
// File is too big
echo '0';
}
} else {
echo '0';
}
} else {
echo '0';
}
// Insert alliance row
prepare_and_execute($insertStmt, array($user, $business));
// Get name of requester for notification
$userNameQuery = 'SELECT name FROM business WHERE userEmail = ?';
$nameFound = false;
while (!$nameFound) {
$name = select($userNameQuery, array($user), false);
if ($name != false) {
// Found name
$userName = $name[0];
$nameFound = true;
}
}
$parameters = array($user);
// Get name of requestee for notification
$businessNameQuery = 'SELECT name FROM business WHERE userEmail = ?';
$nameFound = false;
while (!$nameFound) {
$name = select($userNameQuery, array($business), false);
if ($name != false) {
// Found name
$businessName = $name[0];
$nameFound = true;
}
}
// Push notification to requestee
push_notification($business, 'Alliance confirmed', $userName . ' accepted your Alliance request', 'BusinessPage', json_encode($parameters), $user);
// Create activity for new alliance
create_activity($user, 'alliance', json_encode(array($userName . ' has formed an alliance with ' . $businessName, $business)));
echo '1';
}
