/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param ConnectionInterface $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(ConnectionInterface $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their corresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aUser !== null) {
if ($this->aUser->isModified() || $this->aUser->isNew()) {
$affectedRows += $this->aUser->save($con);
}
$this->setUser($this->aUser);
}
if ($this->isNew() || $this->isModified()) {
// persist changes
if ($this->isNew()) {
$this->doInsert($con);
$affectedRows += 1;
} else {
$affectedRows += $this->doUpdate($con);
}
$this->resetModified();
}
if ($this->eveCharactersScheduledForDeletion !== null) {
if (!$this->eveCharactersScheduledForDeletion->isEmpty()) {
\ECP\EveCharacterQuery::create()->filterByPrimaryKeys($this->eveCharactersScheduledForDeletion->getPrimaryKeys(false))->delete($con);
$this->eveCharactersScheduledForDeletion = null;
}
}
if ($this->collEveCharacters !== null) {
foreach ($this->collEveCharacters as $referrerFK) {
if (!$referrerFK->isDeleted() && ($referrerFK->isNew() || $referrerFK->isModified())) {
$affectedRows += $referrerFK->save($con);
}
}
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
public function __construct($app)
{
$this->app = $app;
$app->group('/user', function () use($app) {
$app->get('/autocomplete', function () {
$userService = new \Core\Service\UserService();
echo json_encode($userService->getAutocomplete($_GET['s']));
});
$app->get('/check', function () {
$userAvailible = ECP\UserQuery::create()->filterByName($_GET['name'])->count() == 0;
echo json_encode((object) array('isAvailible' => $userAvailible));
});
$app->get('/status', function () {
$userService = new \Core\Service\UserService();
$isLoggedIn = $userService->isLoggedIn();
if (!$isLoggedIn) {
die(json_encode((object) array('isLoggedIn' => false)));
}
$user = $userService->getLoggedInUser();
echo json_encode((object) array('isLoggedIn' => true, 'id' => $user->id, 'username' => $user->username));
});
$app->post('/login', function () {
$p = getPost();
$user = ECP\UserQuery::create()->filterByName($p->username)->filterByPassword(sha1($p->password))->filterByConfirmationCode('')->findOne();
if (!$user) {
die(json_encode((object) array('status' => 'incorrect credentials')));
}
$_SESSION['ecp'] = (object) array('id' => $user->getId(), 'username' => $user->getName());
echo $this->getBoolStatus(true);
});
$app->post('/register', function () {
$userService = new \Core\Service\UserService();
$p = getPost();
if (strpos($p->username, '/') !== false) {
die_err('Slashes are not allowed in names!');
}
$code = generateCode();
$user = new ECP\User();
$user->setName($p->username);
$user->setPassword(sha1($p->password));
$user->setEmail($p->email);
$user->setCreated(time());
$user->setConfirmationCode($code);
$user->save();
$userService->sendRegistrationMail($user);
echo $this->getBoolStatus(true);
});
$app->post('/logout', function () {
unset($_SESSION['ecp']);
echo '{}';
});
$app->post('/recover-password', function () {
$userService = new \Core\Service\UserService();
$p = getPost();
$users = ECP\UserQuery::create()->filterByEmail($p->email)->filterByConfirmationCode('')->find();
foreach ($users as $user) {
$code = generateCode();
$user->setRecoverPasswordCode($code);
$user->save();
$userService->sendRecoverPassword($user);
}
echo $this->getBoolStatus(true);
});
$app->get('/reset-password-check', function () {
$userCount = ECP\UserQuery::create()->filterByRecoverPasswordCode($_GET['code'])->count();
echo $this->getBoolStatus($userCount != 0);
});
$app->post('/reset-password', function () {
$p = getPost();
$users = ECP\UserQuery::create()->filterByRecoverPasswordCode($p->code)->find();
$found = false;
foreach ($users as $user) {
$user->setRecoverPasswordCode('');
$user->setPassword(sha1($p->password));
$user->save();
$found = true;
}
echo $this->getBoolStatus($found);
});
$app->post('/confirm-registration', function () {
$p = getPost();
$users = ECP\UserQuery::create()->filterByConfirmationCode($p->code)->find();
$found = false;
foreach ($users as $user) {
$user->setConfirmationCode('');
$user->save();
$found = true;
}
echo $this->getBoolStatus($found);
});
});
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param ConnectionInterface $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(ConnectionInterface $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their corresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aGroup !== null) {
if ($this->aGroup->isModified() || $this->aGroup->isNew()) {
$affectedRows += $this->aGroup->save($con);
}
$this->setGroup($this->aGroup);
}
if ($this->aGroupPersonType !== null) {
if ($this->aGroupPersonType->isModified() || $this->aGroupPersonType->isNew()) {
$affectedRows += $this->aGroupPersonType->save($con);
}
$this->setGroupPersonType($this->aGroupPersonType);
}
if ($this->aGroupEvePerson !== null) {
if ($this->aGroupEvePerson->isModified() || $this->aGroupEvePerson->isNew()) {
$affectedRows += $this->aGroupEvePerson->save($con);
}
$this->setGroupEvePerson($this->aGroupEvePerson);
}
if ($this->aUser !== null) {
if ($this->aUser->isModified() || $this->aUser->isNew()) {
$affectedRows += $this->aUser->save($con);
}
$this->setUser($this->aUser);
}
if ($this->isNew() || $this->isModified()) {
// persist changes
if ($this->isNew()) {
$this->doInsert($con);
$affectedRows += 1;
} else {
$affectedRows += $this->doUpdate($con);
}
$this->resetModified();
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param ConnectionInterface $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(ConnectionInterface $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their corresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aUser !== null) {
if ($this->aUser->isModified() || $this->aUser->isNew()) {
$affectedRows += $this->aUser->save($con);
}
$this->setUser($this->aUser);
}
if ($this->aCompositionEntityRelatedByForkedid !== null) {
if ($this->aCompositionEntityRelatedByForkedid->isModified() || $this->aCompositionEntityRelatedByForkedid->isNew()) {
$affectedRows += $this->aCompositionEntityRelatedByForkedid->save($con);
}
$this->setCompositionEntityRelatedByForkedid($this->aCompositionEntityRelatedByForkedid);
}
if ($this->aRulesetEntity !== null) {
if ($this->aRulesetEntity->isModified() || $this->aRulesetEntity->isNew()) {
$affectedRows += $this->aRulesetEntity->save($con);
}
$this->setRulesetEntity($this->aRulesetEntity);
}
if ($this->isNew() || $this->isModified()) {
// persist changes
if ($this->isNew()) {
$this->doInsert($con);
$affectedRows += 1;
} else {
$affectedRows += $this->doUpdate($con);
}
$this->resetModified();
}
if ($this->compositionEntitiesRelatedByIdScheduledForDeletion !== null) {
if (!$this->compositionEntitiesRelatedByIdScheduledForDeletion->isEmpty()) {
foreach ($this->compositionEntitiesRelatedByIdScheduledForDeletion as $compositionEntityRelatedById) {
// need to save related object because we set the relation to null
$compositionEntityRelatedById->save($con);
}
$this->compositionEntitiesRelatedByIdScheduledForDeletion = null;
}
}
if ($this->collCompositionEntitiesRelatedById !== null) {
foreach ($this->collCompositionEntitiesRelatedById as $referrerFK) {
if (!$referrerFK->isDeleted() && ($referrerFK->isNew() || $referrerFK->isModified())) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->compositionRowsScheduledForDeletion !== null) {
if (!$this->compositionRowsScheduledForDeletion->isEmpty()) {
\ECP\CompositionRowQuery::create()->filterByPrimaryKeys($this->compositionRowsScheduledForDeletion->getPrimaryKeys(false))->delete($con);
$this->compositionRowsScheduledForDeletion = null;
}
}
if ($this->collCompositionRows !== null) {
foreach ($this->collCompositionRows as $referrerFK) {
if (!$referrerFK->isDeleted() && ($referrerFK->isNew() || $referrerFK->isModified())) {
$affectedRows += $referrerFK->save($con);
}
}
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
