public function getByUser($email)
{
$roadScope = new QueryScope("roadrout");
$roadScope->setFields(array("*"));
$roadCond = new QueryCondition("roadrout");
$roadCond->setConditions(array(new QueryConditionMember("driverid", $email, "=")));
$this->addQueryScope($roadScope);
$this->addQueryCondition($roadCond);
return $this->select()->fetchAll(PDO::FETCH_CLASS, 'Entity\\Roadrout');
}
public function updateCar(Car $car)
{
if ($this->validate($car)) {
$carScope = new QueryScope("car");
$carScope->setFields(array("brand", "model", "color", "seats", "fuelrate"));
$carScope->setValues(array($car->brand, $car->model, $car->color, $car->seats, $car->fuelrate));
$carCond = new QueryCondition("car");
$carCond->setConditions(array(new QueryConditionMember("regnumber", $car->regnumber, "=")));
$this->addQueryScope($carScope);
$this->addQueryCondition($carCond);
return $this->update();
}
return false;
}
public function updateUser(User $user)
{
if ($this->validate($user)) {
$userScope = new QueryScope("user");
$userScope->setFields(array("username", "surname", "birthday", "gendor", "phone", "userpassword"));
$userScope->setValues(array($user->username, $user->surname, $user->birthday, $user->gendor, $user->phone, $user->userpassword));
$userCond = new QueryCondition("user");
$userCond->setConditions(array(new QueryConditionMember("email", $user->email, "=")));
$this->addQueryScope($userScope);
$this->addQueryCondition($userCond);
return $this->update();
}
return false;
}
