public function postAction()
{
$data = array();
try {
$auth = Zend_Auth::getInstance();
$user_id = 0;
if ($auth->hasIdentity()) {
$user_id = $auth->getIdentity()->id;
if ($this->getRequest()->isPost()) {
$d = date('Y-m-d');
$ride_id = $this->_getParam("id", "");
$mapper = new Application_Model_TableMapper();
$table_name = "riders";
$values = array("date_created" => $d, "last_updated" => $d, "active" => 1, "ride_id" => $ride_id, "user_id" => $user_id, "group_id" => 0, "rsvp" => 0, "status" => "ON TIME", "complete" => 0, "rating" => 0);
$i = $mapper->insertItem($table_name, $values);
$id = $mapper->getLastInsertId($table_name);
if ($i > 0) {
$data["success"] = true;
$data["message"] = "Rider added: {$id}";
$data["code"] = 0;
} else {
$error = array();
$error["code"] = "104";
$error["message"] = "Ride could not be added.";
$data["success"] = false;
$data["message"] = "Ride could not be added.";
$data["code"] = 104;
$data["error"] = $error;
}
} else {
$error = array();
$error["code"] = "102";
$error["message"] = "Possible security violation. Please check log(s).";
$data["success"] = false;
$data["message"] = "Bad HTTP Request Type.";
$data["code"] = 102;
$data["error"] = $error;
}
} else {
$error = array();
$error["code"] = "100";
$error["message"] = "User is not authenticated.";
$data["success"] = false;
$data["message"] = "Rider add fail.";
$data["code"] = 102;
$data["error"] = $error;
}
} catch (Exception $ex) {
$error = array();
$error["code"] = "Code: " . $ex->getCode();
$error["message"] = "Exception: " . $ex->getMessage();
$data["success"] = false;
$data["message"] = "Rider add exception.";
$data["error"] = $error;
}
$this->view->data = json_encode($data);
$this->view->layout()->disableLayout();
}
public function authenticateAction()
{
$mapper = new Application_Model_TableMapper();
$table_name = 'users';
$email = $this->_getParam('email', 'Missing User ID');
$password = $this->_getParam('password', '');
$data = array();
try {
$salt = $this->_helper->utilities->create_salt();
$hash = $this->_helper->utilities->create_hash($password, $salt);
$query = "select * from users where email='{$email}';";
$users = $mapper->getCustomSelect($query);
if (count($users) > 0) {
$user = $users[0];
$salt = $user["salt"];
$key = $user["password"];
$hash = $this->_helper->utilities->create_hash($password, $salt);
if ($key == $hash) {
$values = array('email' => $email, 'password' => $key);
if ($this->getRequest()->isPost()) {
if ($this->_process($table_name, $values)) {
$data["success"] = true;
$data["message"] = "Authentication success";
$data["code"] = 0;
$data["user"] = $user;
} else {
$data["success"] = false;
$data["message"] = "Authentication failed: Invalid user id or password.";
$data["code"] = -1;
}
} else {
$data["success"] = false;
$data["message"] = "Authentication failed: GET request detected.";
$data["code"] = -2;
}
} else {
$data["success"] = false;
$data["message"] = "Authentication failed: Password does not match user id.";
$data["code"] = -3;
}
} else {
$data["success"] = false;
$data["message"] = "Authentication failed: Could not find account associated with provided email [{$email}].";
$data["code"] = -4;
}
} catch (Exception $ex) {
$data["success"] = false;
$data["message"] = "Authentication failed: " . $ex->getMessage();
$data["code"] = $ex->getCode();
}
$this->view->data = json_encode($data);
$this->view->layout()->disableLayout();
}
public function mainAction()
{
$priority = $this->_getParam("priority");
$mapper = new Application_Model_TableMapper();
$data = array();
$query = "select * from ads ";
$query .= "where priority = {$priority};";
//$query .= " ";
//$query .= " ";
//$query .= " ";
$ads = $mapper->getCustomSelect($query);
$data["ads"] = $ads;
$this->view->data = json_encode($data);
$this->view->layout()->disableLayout();
}
public function getAction()
{
$data = array();
$selects = array();
$id = $this->_getParam('id', 0);
// addresses
$query = "select concat(id, ':', description) as 'option' ";
$query .= "from addresses ";
$query .= "where location_id = {$id};";
$mapper = new Application_Model_TableMapper();
$addresses = $mapper->getCustomSelect($query);
$selects["addresses"] = $this->_helper->utilities->arrayitize($addresses);
$data["selects"] = $selects;
$this->view->data = json_encode($data);
$this->view->layout()->disableLayout();
}
public function postAction()
{
$mapper = new Application_Model_TableMapper();
$table_name = "users";
$data = array();
try {
if ($this->getRequest()->isPost()) {
$auth = Zend_Auth::getInstance();
$user_id = 0;
if ($auth->hasIdentity()) {
$user_id = $id = $auth->getIdentity()->id;
$values = array("first_name" => $this->_getParam("first_name", ""), "last_name" => $this->_getParam("last_name", ""), "gender" => $this->_getParam("gender", ""), "skill" => $this->_getParam("skill", ""), "experience" => $this->_getParam("experience", ""), "type" => $this->_getParam("type", ""), "viewable" => $this->_getParam("viewable", ""));
$i = $mapper->updateItem($table_name, $values, $user_id);
if ($i > 0) {
$data["user"] = $mapper->getItemById($table_name, $user_id);
$data["success"] = true;
$data["message"] = "Success";
$data["code"] = 0;
} else {
$data["user"] = $mapper->getItemById($table_name, $user_id);
$data["success"] = true;
$data["message"] = "Row data is unchanged.";
$data["code"] = 0;
}
} else {
$data["success"] = false;
$data["message"] = "Authentication failed.";
$data["code"] = -3;
}
} else {
$data["success"] = false;
$data["message"] = "An illegal HTTP method has been attempted. The event has been logged with security. Please make arrangements to retain legal counsel.";
$data["code"] = -1;
}
} catch (Exception $ex) {
$data["success"] = false;
$data["message"] = "" . $ex->getMessage();
$data["code"] = $ex->getCode();
}
$this->view->data = json_encode($data);
$this->view->layout()->disableLayout();
}
public function saveAction()
{
$data = array();
try {
$auth = Zend_Auth::getInstance();
$user_id = 0;
if ($auth->hasIdentity()) {
$user_id = $id = $auth->getIdentity()->id;
if ($this->getRequest()->isPost()) {
$group_id = $this->_getParam("group_id", -1);
$name = $this->_getParam("group_name", "");
$description = $this->_getParam("group_description", "");
$deputy = $this->_getParam("group_deputy", 0);
$type = $this->_getParam("group_type", "");
$join = $this->_getParam("group_join", "");
$locked = $this->_getParam("group_locked", "");
$m = $this->_getParam("members", "");
$members = explode('|', $m);
$f = $this->_getParam("friends", "");
$friends = explode('|', $f);
$mapper = new Application_Model_TableMapper();
$table_name = "groups";
$date = date('Y-m-d');
$values = array("last_updated" => $date, "active" => 1, "name" => $name, "description" => $description, "owner" => $user_id, "deputy" => $deputy, "type" => $type, "join" => $join, "locked" => $locked);
// update main group info
$i = $mapper->updateItem($table_name, $values, $group_id);
// after update, remove members, add friends
if ($i >= 0) {
$table_name = "group_members";
$failed_add = array();
$failed_remove = array();
// delete members (remove checkbox processing)
foreach ($members as $id) {
if (!empty($id)) {
$j = $mapper->deleteItem($table_name, $id);
// if you are removing the deputy member
// update the group row
if ($id == intval($deputy)) {
$values = array("last_updated" => $date, "deputy" => 0);
$z = $mapper->updateItem("groups", $values, $group_id);
}
if ($j <= 0) {
array_push($failed_remove, $id);
}
}
}
foreach ($friends as $id) {
if (!empty($id)) {
// insert friend
$values = array("date_created" => $date, "last_updated" => $date, "active" => 1, "group_id" => $group_id, "user_id" => $id, "role" => "MEMBER");
$j = $mapper->insertItem($table_name, $values);
if ($j <= 0) {
array_push($failed_add, $id);
}
}
}
if (intval($deputy) > 0) {
// update deputy
$values = array("last_updated" => $date, "active" => 1, "group_id" => $group_id, "user_id" => intval($deputy), "role" => "DEPUTY");
$wheres = array();
$wheres[] = "group_id = {$group_id}";
$wheres[] = "user_id = " . intval($deputy);
$k = $mapper->updateSpecific($table_name, $values, $wheres);
}
if (count($failed_remove) > 0 || count($failed_add) > 0) {
$error = array();
$error["code"] = "101";
//$error["message"] = "Failed to remove: ".join($failed_remove, ",");
$error["message"] = "Failed to modify members: " . join($failed_remove, ",") . " or add friends: " . join($failed_add, ",");
$data["success"] = false;
$data["message"] = "Some members failed to remove members or add friends from/to group.";
$data["code"] = 101;
$data["error"] = $error;
} else {
$data["success"] = true;
$data["message"] = "Group and members edited successfully!";
$data["code"] = 0;
}
} else {
$error = array();
$error["code"] = "104";
$error["message"] = "Failed to edit group";
$data["success"] = false;
$data["message"] = "Failed to edit group.";
$data["code"] = 104;
$data["error"] = $error;
}
} else {
$error = array();
$error["code"] = "102";
$error["message"] = "Possible security violation. Please check log(s).";
$data["success"] = false;
$data["message"] = "Bad HTTP Request Type.";
$data["code"] = 102;
$data["error"] = $error;
}
} else {
$error = array();
$error["code"] = "100";
$error["message"] = "User is not authenticated.";
$data["success"] = false;
$data["message"] = "Friend update fail.";
$data["error"] = $error;
}
} catch (Exception $ex) {
$error = array();
$error["code"] = "Code: " . $ex->getCode();
$error["message"] = "Exception: " . $ex->getMessage();
$data["success"] = false;
$data["message"] = "Friend add exception.";
$data["error"] = $error;
}
$this->view->data = json_encode($data);
$this->view->layout()->disableLayout();
}
public function ratingAction()
{
$data = array();
try {
$auth = Zend_Auth::getInstance();
$user_id = 0;
if ($auth->hasIdentity()) {
$user_id = $auth->getIdentity()->id;
if ($this->getRequest()->isPost()) {
$id = $this->_getParam("id", "0");
$rating = $this->_getParam("rating", "");
$mapper = new Application_Model_TableMapper();
$table_name = "riders";
$values = array("rating" => $rating);
$i = $mapper->updateItem($table_name, $values, $id);
if ($i > 0) {
$data["success"] = true;
$data["message"] = "Add rating Successful: {$id}";
$data["code"] = 0;
} else {
$error = array();
$error["code"] = "104";
$error["message"] = "Could not add rating complete.";
$data["success"] = false;
$data["message"] = "Could not add rating complete.";
$data["code"] = 104;
$data["error"] = $error;
}
} else {
$error = array();
$error["code"] = "102";
$error["message"] = "Possible security violation. Please check log(s).";
$data["success"] = false;
$data["message"] = "Bad HTTP Request Type.";
$data["code"] = 102;
$data["error"] = $error;
}
} else {
$error = array();
$error["code"] = "100";
$error["message"] = "User is not authenticated.";
$data["success"] = false;
$data["message"] = "Could not add rating.";
$data["code"] = 102;
$data["error"] = $error;
}
} catch (Exception $ex) {
$error = array();
$error["code"] = "Code: " . $ex->getCode();
$error["message"] = "Exception: " . $ex->getMessage();
$data["success"] = false;
$data["message"] = "Ride add rating exception.";
$data["error"] = $error;
}
$this->view->data = json_encode($data);
$this->view->layout()->disableLayout();
}
public function postAction()
{
$data = array();
try {
$auth = Zend_Auth::getInstance();
$user_id = 0;
if ($auth->hasIdentity()) {
$user_id = $id = $auth->getIdentity()->id;
if ($this->getRequest()->isPost()) {
$friends = $this->_getParam("friends");
$ids = explode('|', $friends);
$mapper = new Application_Model_TableMapper();
$table_name = "friends";
$date = date('Y-m-d');
foreach ($ids as $id) {
$values = array("date_created" => $date, "last_updated" => $date, "active" => 1, "user_id" => $user_id, "friend_id" => $id, "clique_id" => 0);
$i = $mapper->insertItem($table_name, $values);
$failed = array();
if ($i <= 0) {
array_push($failed, $id);
}
}
if (count($failed) > 0) {
$error = array();
$error["code"] = "101";
$error["message"] = "Failed to add: " . join($failed, ",");
$data["success"] = false;
$data["message"] = "Some friends failed to add.";
$data["code"] = 101;
$data["error"] = $error;
} else {
$data["success"] = true;
$data["message"] = "Friends added successfully!";
$data["code"] = 0;
}
} else {
$error = array();
$error["code"] = "102";
$error["message"] = "Possible security violation. Please check log(s).";
$data["success"] = false;
$data["message"] = "Bad HTTP Request Type.";
$data["code"] = 102;
$data["error"] = $error;
}
} else {
$error = array();
$error["code"] = "100";
$error["message"] = "User is not authenticated.";
$data["success"] = false;
$data["message"] = "Friend update fail.";
$data["error"] = $error;
}
} catch (Exception $ex) {
$error = array();
$error["code"] = "Code: " . $ex->getCode();
$error["message"] = "Exception: " . $ex->getMessage();
$data["success"] = false;
$data["message"] = "Friend add exception.";
$data["error"] = $error;
}
$this->view->data = json_encode($data);
$this->view->layout()->disableLayout();
}
public function uploadAction()
{
$data = array();
try {
$auth = Zend_Auth::getInstance();
$user_id = 0;
if ($auth->hasIdentity()) {
$user_id = $id = $auth->getIdentity()->id;
}
if ($user_id > 0) {
$destination = realpath(APPLICATION_PATH . "/../public/users/{$user_id}/photos/");
$response = Application_Plugin_Lib::upload($destination);
if ($response["success"]) {
$data["jsonrpc"] = "2.0";
$data["result"] = null;
$data["id"] = "id";
// TODO - insert into photos table
if ($response["filedetails"] != null) {
$filedetails = $response["filedetails"];
$table_name = "photos";
$mapper = new Application_Model_TableMapper();
$date = date('Y-m-d');
$values = array("date_created" => $date, "last_updated" => $date, "active" => 1, "user_id" => intval($user_id), "ride_id" => 0, "url" => $filedetails["name"], "alt" => "", "height" => 0, "width" => 0, "description" => "");
$i = $mapper->insertItem($table_name, $values);
}
} else {
$error = array();
$error["message"] = $response["message"];
$error["code"] = $response["code"];
$data["jsonrpc"] = "2.0";
$data["error"] = $error;
$data["id"] = "id";
}
} else {
$error = array();
$error["code"] = "100";
$error["message"] = "User is not authenticated.";
$data["jsonrpc"] = "2.0";
$data["error"] = $error;
$data["id"] = "id";
}
} catch (Exception $ex) {
$error = array();
$error["code"] = $ex->getCode();
$error["message"] = $ex->getMessage();
$data["jsonrpc"] = "2.0";
$data["error"] = $error;
$data["id"] = "id";
}
$this->view->data = json_encode($data);
$this->view->layout()->disableLayout();
}
