private function getSqlSignUp()
{
$tblName = "user";
$attributes = array("firstName", "lastName", "class", "email", "password", "imgLink", "aboutMe", "experience");
$values = array($this->firstName, $this->lastName, $this->class, $this->email, $this->password, $this->imgLink, $this->aboutMe, $this->experience);
return Request::insert($tblName, $attributes, $values);
}
private function getSqlAdd()
{
$tblName = "question";
$attributes = array("text", "firstVariant", "secondVariant", "thirdVariant", "correctVariant");
$values = array($this->text, $this->firstVariant, $this->secondVariant, $this->thirdVariant, $this->correctVariant);
return Request::insert($tblName, $attributes, $values);
}
/**
* @test
*/
public function moveRequestsToFollower()
{
$user2 = $this->getUser("test2");
$this->isTrue($user2->isProtected());
$user1 = $this->getUser("test1");
$user3 = $this->getUser("test3");
$request = new Request();
$request->insert(array("user_id" => $user1->id, "request_id" => $user2->id, "created_at" => now()));
$request->insert(array("user_id" => $user3->id, "request_id" => $user2->id, "created_at" => now()));
$this->isTrue(Request::isRequested($user1->id, $user2->id));
$this->isTrue(Request::isRequested($user3->id, $user2->id));
$this->isFalse(Follower::isFollowed($user1->id, $user2->id));
$this->isFalse(Follower::isFollowed($user3->id, $user2->id));
$user2->private_flag = false;
$this->getLogic("user")->updateSettings($user2);
$this->isFalse($user2->isProtected());
$this->isFalse(Request::isRequested($user1->id, $user2->id));
$this->isFalse(Request::isRequested($user3->id, $user2->id));
$this->isTrue(Follower::isFollowed($user1->id, $user2->id));
$this->isTrue(Follower::isFollowed($user3->id, $user2->id));
$this->clear("Request");
$this->clear("Follower");
}
function generateRequest($dbusercat)
{
// require ("../include/mailMessage_".$_SESSION['userLang'].".php");
// require ("../catalogov2.0/cart_".$_SESSION['userLang'].".php");
require "mailMessage_" . $_SESSION['userLang'] . ".php";
require "cart_" . $_SESSION['userLang'] . ".php";
include_once "globals.php";
// Today
$dbcadastro = $GLOBALS["dbusercat"];
$today = date("Y-m-d H:i:s");
$messageItem = "\t";
setlocale(LC_MONETARY, 'bra');
// Serching user
$objUser = new User($dbusercat);
$objUser->selectByUserId($this->userId);
// Generating Request
$objReq = new Request($this->bd);
$reqIp = $_SERVER['REMOTE_ADDR'];
$sql = "SELECT COUNTRY_NAME FROM ipToCountry WHERE IP_FROM <= inet_aton('{$reqIp}') AND IP_TO >= inet_aton('{$reqIp}')";
$dbcadastro->query($sql) or $dbcadastro->error($sql);
$row = $dbcadastro->fetchRow();
$reqCountry = $row[COUNTRY_NAME];
$objReq->fill($this->userId, $today, 0, 0, 0, 0, $this->operator, $this->addressId, $reqIp, $reqCountry);
if (!($reqId = $objReq->insert())) {
echo "Problema inserindo o request!";
return false;
}
// Generating Request Itens
$nItensReq = 0;
for ($i = 0; $i < $this->nItens; $i++) {
$carItem = $this->cart[$i]["Id"];
$objItemCart = new Cart($this->bd);
$objItemCart->search($carItem);
$price = $objItemCart->price;
$userType = $objUser->getTypeOfUser();
if ($price == 0 or $price > 0 and $userType != 2) {
//Searching the scene
$sql = "SELECT * FROM Scene WHERE SceneId='" . $objItemCart->sceneId . "'";
$this->bd->query($sql) or $this->bd->error($sql);
$itens = $this->bd->numRows();
if ($itens == 0) {
echo "Erro nas Cenas";
return false;
}
$row = $this->bd->fetchRow();
$this->bd->freeResult($results);
// Setting email message
//$price = money_format('%10.2n', $objItemCart->price);
$messageItem .= sprintf("\n%-8d%s\t\t%s", $i + 1, $strMessageSatellite, $row["Satellite"]);
$messageItem .= sprintf("\n%-9s%s\t%s\t\t\t\t%s\t\tR\$%7.2f", " ", $strInstrument, $row["Sensor"], $objItemCart->media, $objItemCart->price);
$messageItem .= sprintf("\n%-9s%s/%s\t%s/%s", " ", $strMessagePath, $strMessageRow, $row["Path"], $row["Row"]);
$messageItem .= sprintf("\n%-9s%s\t\t\t%s\n", " ", $strDate, $row["Date"]);
$reqTot += $objItemCart->price;
// Generate Request Item
if (!$objItemCart->generateReqItem($reqId, $userType)) {
echo "<br>Problema ao gerar item de pedido a partir do Carrinho</br>";
return false;
}
// Removing from cart
if (!$objItemCart->removeId()) {
echo "<br>Problema ao remover pedido do Carrinho</br>";
return false;
}
$nItensReq++;
}
}
$this->nItens -= $nItensReq;
if ($reqTot) {
$messageItem .= sprintf("%s\n\t\t\t\t\t\t\t\t%s\tR\$%7.2f\n\n", str_repeat("-", 98), $strTotal, $this->total);
} else {
$messageItem .= sprintf("%s\n\n", str_repeat("-", 98));
}
// Generating E-mail
$message = sprintf($mailMsgReq1, $objUser->fullname, $reqId);
if ($reqTot) {
$message .= " " . $mailMsgReq2;
}
$message .= $mailMsgReq3 . str_repeat("-", 98);
$message .= $messageItem;
$message .= $mailMsgAtus;
if (!mail($objUser->email, $mailSubReq . $reqId, $message, $mailSender)) {
echo "Problema ao enviar o e-mail";
return false;
}
// Returnind Request Number
return $reqId;
}
<?php
require_once 'Request.php';
require_once 'check_cookie.php';
require_once 'show_list.php';
if (check_cookie($_SERVER['PHP_SELF'], null)) {
if (!empty($_POST)) {
$req = new Request();
$req->uid = $_COOKIE['uid'];
$req->name = $_POST['name'];
// Remove '-' from phone number.
$req->phone = str_replace('-', '', $_POST['phone']);
$req->description = $_POST['description'];
// Force date into correct format.
$req->deadline = parse_date($_POST);
$req->insert();
header('Location: index.php?conf=true');
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Job Request Form</title>
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
<link rel="stylesheet" type="text/css" href="style.css" />
<script type="text/javascript" src="jquery-1.7.min.js"></script>
<script type="text/javascript" src="validator.js"></script>
<script type="text/javascript" src="validate_request.js"></script>
</head>
<body onload="loadEventHandlers();">
<?php
function createGroup()
{
$results = array();
$results['pageTitle'] = " Add an activity | Dating website";
if ($_POST) {
$group = new Group($_POST);
$group->icon_link = DEFAULT_IMAGE_LOCATION;
$group->status = "pending";
$arr = explode(",", $_POST['blah']);
$group->per2Id = $arr[0];
$group->per3Id = $arr[1];
if ($arr[0] != $arr[1]) {
if ($group1 = Group::getByMembers($group->adminId, $arr[0], $arr[1])) {
$results['successMessage'] = "failed adding group already exists";
require TEMPLATE_PATH . "/home.php";
} else {
if ($group->insert()) {
$results['successMessage'] = "Added group successfully.";
$request = new Request();
$request->type = "accept";
$request->sentById = $group->id;
$request->status = "pending";
$request->sentToId = $group->per2Id;
if ($request->insert()) {
$results['requestMessage'] = "a request has been sent successfully";
}
$request1 = new Request();
$request1->type = "accept";
$request1->sentById = $group->id;
$request1->status = "pending";
$request1->sentToId = $group->per3Id;
if ($request1->insert()) {
$results['requestMessage1'] = "a request has been sent successfully";
}
//header('Location: ' . $_SERVER['HTTP_REFERER']);
require TEMPLATE_PATH . "/home.php";
} else {
$results['successMessage'] = "failed adding group .";
require TEMPLATE_PATH . "/home.php";
//echo "fail";
}
}
} else {
$results['successMessage'] = "failed adding group same persons selected.";
require TEMPLATE_PATH . "/home.php";
}
} else {
require TEMPLATE_PATH . "/home.php";
}
}
$households = $query->query($action->sql);
if (count($households)) {
$response = $households;
} else {
$response = array();
}
break;
case 'REMOVE':
break;
case 'EDIT':
break;
case 'ADD':
$action = new Household();
$action->create((array) $request['info']);
$insert = new Request();
$request['info']->hid = $insert->insert($action->sql);
// Now that I have HID, I need to add current user to member list of hhold, and then return the HoseHold with member list.
$ident = new Identity();
$query = new Request();
$name = $query->query($ident->getname($request['info']['id'])->sql);
$response = (array) $request['info'];
break;
default:
# code...
break;
}
echo json_encode($response);
});
$app->post('/members', function () use($app) {
$request = (array) json_decode($app->request->getBody());
switch ($request['action']) {
