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(); }