Exemple #1
2
 public function __invoke(Request $req, Response $res, callable $next)
 {
     $res = $next($req, $res);
     $identity = $this->authService->getIdentity();
     if (!$identity) {
         return $res;
     }
     try {
         $user = R::findOne('user', 'mail = ?', [$identity->mail]);
         if (!$user) {
             $user = R::dispense('user');
             $user->uid = $identity->uid;
             $user->mail = $identity->mail;
             $user->display_name = $identity->displayName;
             $user->office_name = $identity->officeName;
             $user->authentication_source = $identity->authenticationSource;
             $user->password = '';
             $user->created = time();
             $user->role = 'school';
             $this->logger->info(sprintf('User %s imported from sso.sch.gr to database', $identity->mail));
         }
         $user->last_login = time();
         $user_id = R::store($user);
         $identityClass = get_class($identity);
         $newIdentity = new $identityClass($user_id, $user->uid, $user->mail, $user->display_name, $user->office_name, $user->authentication_source);
         $this->authService->getStorage()->write($newIdentity);
     } catch (\Exception $e) {
         $this->authService->clearIdentity();
         $this->flash->addMessage('danger', 'A problem occured storing user in database. <a href="%s" title="SSO logout">SSO Logout</a>');
         $this->logger->error('Problem inserting user form CAS in database', $identity->toArray());
         $this->logger->debug('Exception', [$e->getMessage(), $e->getTraceAsString()]);
         return $res->withRedirect($this->userErrorRedirectUrl);
     }
     return $res;
 }
Exemple #2
1
 public function save()
 {
     if (!$this->emptyAttr('id')) {
         $menu = R::findOne('menu', 'id=?', [$this->getAttr('id')]);
     } else {
         $menu = R::dispense('menu');
     }
     $menu->name = $this->getAttr('name');
     $oldPicture = null;
     if (!$this->emptyAttr('picture') && $this->attr['picture']->uploaded) {
         $picture = $this->getAttr('picture');
         $picture->file_new_name_body = $this->generateName("menu_picture_");
         // $picture->image_resize = true;
         $picture->image_convert = 'jpeg';
         // $picture->image_x = 964;
         // $picture->image_y = 1024;
         // $picture->image_ratio_y = true;
         $picture->process('upload/');
         $oldPicture = $menu->picture;
         $menu->picture = $picture->file_dst_name;
     }
     $success = R::store($menu);
     if ($success) {
         if (!is_null($oldPicture)) {
             @unlink('upload/' . $oldPicture);
         }
     }
     return $success;
 }
 public function crawlUrl()
 {
     $currentUrl = ['url' => $this->currentUrl, 'depth' => $this->currentDepth];
     do {
         $this->setCurrentUrl($currentUrl);
         if (!($doc = parent::crawlUrl())) {
             continue;
         }
         $username = $doc['.vcard-username']->text();
         $user = R::findOne('github', ' username = ? ', [$username]);
         //$user = R::find('github', " username=$username ");
         if (empty($user)) {
             $user = R::dispense('github');
             $now = time();
             $user->avatar = $doc['.vcard-avatar .avatar']->attr('src');
             $user->fullname = $doc['.vcard-fullname']->text();
             $user->username = $username;
             $user->email = $doc['.email']->text();
             $user->worksFor = $doc['.vcard-detail[itemprop=worksFor]']->text();
             $user->homeLocation = $doc['.vcard-detail[itemprop=homeLocation]']->text();
             $user->blogUrl = $doc['.vcard-detail[itemprop=url]']->text();
             $user->joinDate = $doc['.join-date']->attr('datetime');
             $user->url = $this->currentUrl;
             $user->createdAt = $now;
             $user->updatedAt = $now;
             if (R::store($user)) {
                 echo '存储用户', $username, '成功', PHP_EOL;
             } else {
                 echo '存储用户', $username, '失败', PHP_EOL;
             }
         } else {
             echo '用户', $username, '已经被存储过了', PHP_EOL;
         }
     } while ($currentUrl = $this->nextUrl());
 }
Exemple #4
0
 public function createSchool(array $data)
 {
     $school = $this->importSchool(R::dispense('school'), $data);
     $school->created = time();
     R::store($school);
     return $this->exportSchool($school);
 }
 public function add_view()
 {
     $id = $this->slim->request->post()['id'];
     $item = R::load('ecatalog', $id);
     $item->view_count += 1;
     R::store($item);
     echo '555';
     exit;
 }
Exemple #6
0
 /**
  * @param Set $linkedSet
  * @returns $this
  */
 public function link(Set $linkedSet)
 {
     $bean = $this->getBean();
     if ($bean === null) {
         $bean = $this->newBean();
     }
     $bean->{$this->_('linkedSetId')} = $linkedSet->getBean()->getID();
     R::store($bean);
     return $this;
 }
Exemple #7
0
 public function setOptions($options)
 {
     $bean = $this->getBean();
     if ($bean === null) {
         $bean = $this->newBean();
     }
     $bean->{$this->_('options')} = implode(',', $options);
     R::store($bean);
     return $this;
 }
Exemple #8
0
function store()
{
    $email = R::dispense('email');
    foreach (\app\run('input', 'keys', 'post') as $key) {
        $element = str_replace('-', '_', $key);
        $email->{$element} = \app\run('input', 'post', $key);
    }
    R::store($email);
    return null;
}
Exemple #9
0
 public function updateAssetForSchool($school_id, array $assetData, $assetId)
 {
     $asset = R::findOne('schoolasset', ' id = ? AND school_id = ? ', [$assetId, $school_id]);
     if (!$asset) {
         throw new InvalidArgumentException('No school asset found');
     }
     $asset = $this->importSchoolAsset($asset, $assetData, $school_id);
     R::store($asset);
     return $this->exportSchoolAsset($asset);
 }
Exemple #10
0
 public function makeUnique()
 {
     $items = R::find($this->table, 'ORDER BY sort_order');
     // $items = R::exportAll($items);
     $i = 0;
     foreach ($items as $key => $item) {
         $i++;
         $item->sort_order = $i;
         R::store($item);
     }
 }
Exemple #11
0
 public function testGetDetailsCustom()
 {
     $details = R::dispense('detail');
     $details->desc = 'A test blog.';
     $details->image = 'some url';
     R::store($details);
     $response = $this->details->getDetails(new RequestMock(), new ResponseMock(), null);
     $this->assertEquals('success', $response->status);
     $this->assertEquals('SMPLog', $response->data[0]['name']);
     $this->assertEquals('A test blog.', $response->data[0]['desc']);
 }
Exemple #12
0
 public static function storeForm($form)
 {
     $data = DataBase::processForm($form);
     foreach ($data as $table => $value) {
         try {
             $saved = parent::store($value);
         } catch (\Exception $e) {
             return $e;
         }
     }
 }
Exemple #13
0
 private function persist($teacher, array $data)
 {
     $teacher->school_id = $data['school_id'];
     $teacher->name = $data['name'];
     $teacher->surname = $data['surname'];
     $teacher->telephone = $data['telephone'];
     $teacher->email = $data['email'];
     $teacher->branch_id = $data['branch_id'];
     $teacher->is_principle = isset($data['is_principle']);
     $teacher->is_responsible = isset($data['is_responsible']);
     R::store($teacher);
 }
Exemple #14
0
 public function save()
 {
     $account = R::dispense('account');
     $account->created_at = date('Y-m-d H:i:s');
     $account->email = empty($this->attr['email']) ? null : $this->attr['email'];
     $account->token = bin2hex(openssl_random_pseudo_bytes(16));
     if (R::store($account)) {
         return $account;
     } else {
         return false;
     }
 }
Exemple #15
0
 public static function checkIn($number)
 {
     $bean = R::findOne('record', ' number = :number AND isnull(`in`) ', ['number' => $number]);
     if ($bean === null) {
         return null;
     }
     $bean->in = time();
     $bean->checkInBy = App::user()->id;
     $record = new Record($number, $bean);
     R::store($bean);
     return $record;
 }
Exemple #16
0
 private function persistSoftware($software, array $data)
 {
     if (!isset($data['lab_id']) || empty($data['lab_id'])) {
         $data['lab_id'] = null;
     }
     $software->softwarecategory_id = $data['softwarecategory_id'];
     $software->school_id = $data['school_id'];
     $software->lab_id = $data['lab_id'];
     $software->title = $data['title'];
     $software->vendor = $data['vendor'];
     $software->url = $data['url'];
     R::store($software);
 }
Exemple #17
0
 /**
  * Update a user.
  * @param Array $data
  * ['name','fullname','password']
  * @return string
  * @throws \Exception
  */
 public function updateUser($data)
 {
     if (empty($data['name'])) {
         throw new \Exception('need a user name to update');
     }
     $user = R::findOne('user', ' name = ? ', [$data['name']]);
     if (!empty($user)) {
         $user->name = $data['name'];
         $user->fullname = $data['fullname'];
         if (!empty($data['password'])) {
             $user->hash = password_hash($data['password'], PASSWORD_DEFAULT);
         }
         R::store($user);
     }
 }
 public function edit(Request $request, Response $response, array $args)
 {
     $uid = $args['uid'];
     if (empty($uid)) {
         $this->flash->addMessage('flash', 'No record specified');
         return $response->withRedirect($request->getUri()->getBaseUrl() . $this->router->pathFor('accounts'));
     }
     $id = $this->authenticator->getIdentity();
     $user = R::load('users', $id['id']);
     if ($uid != 'new') {
         $account = R::load('accounts', $uid);
         if ($account->id == 0) {
             $this->flash->addMessage('flash', 'No record found');
             return $response->withRedirect($request->getUri()->getBaseUrl() . $this->router->pathFor('accounts'));
         }
         // restrict access to own profile or Admin role
         if ($account->users->id != $id['id']) {
             if (strtolower($id['role']) != 'admin') {
                 $this->flash->addMessage('flash', 'Access Denied');
                 return $response->withRedirect($request->getUri()->getBaseUrl() . $this->router->pathFor('accounts'));
             }
         }
     } else {
         $account = R::dispense('accounts');
     }
     if ($request->isPost()) {
         $data = $request->getParams();
         $account->import($data, 'apikey,accountid,servertype');
         $account->users = $user;
         $account->lasttid = 0;
         $oandaInfo = FALSE;
         // verify and get account balance
         try {
             $oandaInfo = new Broker_Oanda($account['servertype'], $account['apikey'], $account['accountid'], 0);
         } catch (\Exception $e) {
             $viewData['flash'] = 'Account Details Invalid';
         }
         if ($oandaInfo != FALSE) {
             $aid = R::store($account);
             $oandaInfo->updateAccount();
             $this->flash->addMessage('flash', "account updated");
             return $response->withRedirect($request->getUri()->getBaseUrl() . $this->router->pathFor('editaccount', ['uid' => $aid]));
         }
     }
     $viewData['account'] = $account;
     $this->view->render($response, 'account.twig', $viewData);
     return $response;
 }
Exemple #19
0
 public function save($employerId)
 {
     if (!$this->emptyAttr('id')) {
         $item = R::findOne('employer_history', 'id=?', [$this->getAttr('id')]);
     } else {
         $item = R::dispense('employer_history');
         $item->employer_id = $employerId;
     }
     $item->term_at = $this->getAttr('term_at', '');
     $item->contract_no = $this->getAttr('contract_no', '');
     $item->contract_description = $this->getAttr('contract_description', '');
     $item->repair_1 = $this->getAttr('repair_1', '');
     $item->repair_2 = $this->getAttr('repair_2', '');
     $item->repair_3 = $this->getAttr('repair_3', '');
     return R::store($item);
 }
 public function testDB()
 {
     $app = new Application();
     $app->register(new RedBeanServiceProvider(), array('db.options' => array('dsn' => 'sqlite:' . __DIR__ . '/test.sqlite')));
     $app['db'];
     //db init
     $post = R::dispense('post');
     $post->text = 'Hello World';
     $id = R::store($post);
     //Create or Update
     $fetchedPost = R::load('post', $id);
     //Retrieve
     $this->assertSame($post->text, $fetchedPost->text);
     $this->assertTrue(file_exists(__DIR__ . '/test.sqlite'));
     unlink(__DIR__ . '/test.sqlite');
 }
Exemple #21
0
 public function testGetPost()
 {
     $request = new RequestMock();
     $response = $this->posts->getPost($request, new ResponseMock(), null);
     $this->assertEquals('failure', $response->status);
     $this->assertEquals('No post found for slug .', $response->alerts[0]['text']);
     $post = R::dispense('post');
     $post->title = 'test';
     $post->slug = 'test';
     R::store($post);
     $request = new RequestMock('test');
     $this->posts = new Posts(new ContainerMock());
     $response = $this->posts->getPost($request, new ResponseMock(), null);
     $this->assertEquals('success', $response->status);
     $this->assertEquals('test', $response->data[0]['title']);
 }
Exemple #22
0
 public function save()
 {
     if (!$this->emptyAttr('id')) {
         $item = R::findOne('room_pattern', 'id=?', [$this->getAttr('id')]);
         $item->updated_at = date('Y-m-d H:i:s');
     } else {
         $item = R::xdispense('room_pattern');
         $item->created_at = date('Y-m-d H:i:s');
         $item->updated_at = date('Y-m-d H:i:s');
     }
     $item->room_id = $this->getAttr('room_id');
     $item->name = $this->getAttr('name');
     $item->width = $this->getAttr('width');
     $item->height = $this->getAttr('height');
     $item->tileWidth = $this->getAttr('tile_width');
     $item->tileHeight = $this->getAttr('tile_height');
     $item->tileSizeUnit = $this->getAttr('tile_size_unit');
     $item->product_use = ',' . implode(',', $this->getAttr('product_use')) . ',';
     if (!$this->emptyAttr('picture') && $this->attr['picture']->uploaded) {
         $picture = $this->getAttr('picture');
         $picture->file_new_name_body = $this->generateName("pattern_picture_");
         $picture->image_convert = 'jpeg';
         $picture->process('upload/');
         $this->pushDeleteWhenSuccess('upload/' . $item->picture);
         $this->pushDeleteWhenFailed('upload/' . $picture->file_dst_name);
         $item->picture = $picture->file_dst_name;
     }
     if (!$this->emptyAttr('thumb') && $this->attr['thumb']->uploaded) {
         $thumb = $this->getAttr('thumb');
         $thumb->file_new_name_body = $this->generateName("pattern_thumb_");
         $thumb->image_convert = 'jpeg';
         $thumb->image_resize = true;
         $thumb->image_x = 150;
         $thumb->image_y = 150;
         $thumb->process('upload/');
         $this->pushDeleteWhenSuccess('upload/' . $item->thumb);
         $this->pushDeleteWhenFailed('upload/' . $thumb->file_dst_name);
         $item->thumb = $thumb->file_dst_name;
     }
     $success = R::store($item);
     if ($success) {
         $this->handlerSuccess();
     } else {
         $this->handlerFailed();
     }
     return $success;
 }
Exemple #23
0
 public function getDetails($request, $response, $args)
 {
     $details = R::load('detail', 1);
     if (!$details->id) {
         $details->name = 'SMPLog';
         $details->description = 'A blog published by SMPLog.';
         $details->image = '';
         R::store($details);
     }
     if (empty($details->name)) {
         $details->name = 'SMPLog';
         R::store($details);
     }
     $this->apiJson->setSuccess();
     $this->apiJson->addData($details->export());
     return $this->jsonResponse($response);
 }
Exemple #24
0
 public function save()
 {
     if (!$this->emptyAttr('id')) {
         $user = R::findOne('user', 'id=?', [$this->getAttr('id')]);
     } else {
         $user = R::dispense('user');
         $user->level = 2;
     }
     $user->username = $this->getAttr('username');
     $user->password = $this->getAttr('password');
     $user->email = $this->getAttr('email', '');
     $user->first_name = $this->getAttr('first_name', '');
     $user->last_name = $this->getAttr('last_name', '');
     $user->tel_number = $this->getAttr('tel_number', '');
     $user->branch = $this->getAttr('branch', '');
     return R::store($user);
 }
Exemple #25
0
 public function save()
 {
     if (!$this->emptyAttr('id')) {
         $ecatalog = R::findOne('ecatalog', 'id=?', [$this->getAttr('id')]);
         $ecatalog->updated_at = date('Y-m-d H:i:s');
     } else {
         $ecatalog = R::dispense('ecatalog');
         $ecatalog->created_at = date('Y-m-d H:i:s');
         $ecatalog->updated_at = date('Y-m-d H:i:s');
         $ecatalog->sort_order = (int) R::getCell("SELECT MAX(sort_order) FROM ecatalog") + 1;
     }
     $ecatalog->name = $this->getAttr('name');
     $ecatalog->is_new = $this->getAttr('is_new');
     if (!$this->emptyAttr('pdf') && is_uploaded_file($this->attr['pdf']['tmp_name'])) {
         $pdf = $this->getAttr('pdf');
         $pdf_path = $this->generateName('ecatalog_pdf_') . '.pdf';
         $cover_path = $this->generateName('ecatalog_cover_') . '.jpeg';
         $im = new \Imagick($pdf['tmp_name'] . '[0]');
         $im->setImageBackgroundColor('white');
         // $im = $im->flattenImages();
         $im = $im->mergeImageLayers(\Imagick::LAYERMETHOD_FLATTEN);
         $im->setImageFormat('jpeg');
         if ($im->getImageColorspace() == \Imagick::COLORSPACE_CMYK) {
             $im->setImageColorspace(\Imagick::COLORSPACE_SRGB);
         }
         $im->thumbnailImage(512, 0);
         $im->writeImage('upload/' . $cover_path);
         $im->clear();
         $im->destroy();
         move_uploaded_file($pdf['tmp_name'], 'upload/' . $pdf_path);
         $this->pushDeleteWhenSuccess('upload/' . $ecatalog->pdf_path);
         $this->pushDeleteWhenSuccess('upload/' . $ecatalog->cover_path);
         $this->pushDeleteWhenFailed('upload/' . $pdf_path);
         $this->pushDeleteWhenFailed('upload/' . $cover_path);
         $ecatalog->pdf_path = $pdf_path;
         $ecatalog->cover_path = $cover_path;
     }
     $success = R::store($ecatalog);
     if ($success) {
         $this->handlerSuccess();
     } else {
         $this->handlerFailed();
     }
     return $success;
 }
Exemple #26
0
 public function save($userId)
 {
     if (!$this->emptyAttr('id')) {
         $item = R::findOne('employee', 'id=?', [$this->getAttr('id')]);
     } else {
         $item = R::dispense('employee');
         $item->user_id = $userId;
     }
     $item->first_name = $this->getAttr('first_name', '');
     $item->last_name = $this->getAttr('last_name', '');
     $item->tel_number = $this->getAttr('tel_number', '');
     $item->passport_id = $this->getAttr('passport_id');
     $item->passport_expiry = $this->getAttr('passport_expiry');
     $item->visa_expiry = $this->getAttr('visa_expiry');
     $item->report_expiry = $this->getAttr('report_expiry');
     $item->update_time = date("Y-m-d H:i:s");
     return R::store($item);
 }
Exemple #27
0
 public function save()
 {
     foreach ($this->_bean->getProperties() as $prop => &$propValue) {
         if (substr($prop, 0, 3) === 'own') {
             $propsToUpdate = [];
             foreach ($propValue as $subValue) {
                 if ($subValue instanceof BaseModel) {
                     $subValue = $subValue->getBean();
                     $propsToUpdate[] = $subValue;
                 }
             }
             $this->__set($prop, $propsToUpdate);
         }
     }
     if ($this->_timestamps) {
         $this->_bean->{'updated_at'} = Carbon::now();
     }
     R::store($this->_bean);
 }
Exemple #28
0
 public function save()
 {
     if (!$this->emptyAttr('id')) {
         $item = R::findOne('room', 'id=?', [$this->getAttr('id')]);
         $item->updated_at = date('Y-m-d H:i:s');
     } else {
         $item = R::dispense('room');
         $item->created_at = date('Y-m-d H:i:s');
         $item->updated_at = date('Y-m-d H:i:s');
     }
     $item->name = $this->getAttr('name');
     $success = R::store($item);
     if ($success) {
         $this->handlerSuccess();
     } else {
         $this->handlerFailed();
     }
     return $success;
 }
Exemple #29
-1
 public function editRota(Request $request, Response $response, array $args)
 {
     $id = $this->authenticator->getIdentity();
     if (strtolower($id['name']) != 'admin') {
         $this->flash->addMessage('flash', 'Access Denied');
         return $response->withRedirect($this->router->pathFor('homepage'));
     }
     $name = $args['name'];
     if (empty($name)) {
         $this->flash->addMessage('flash', 'No rota specified');
         return $response->withRedirect($this->router->pathFor('rotas'));
     }
     if ($name != 'new') {
         $rota = R::findOrCreate('rotas', ['name' => $name]);
     } else {
         $rota = R::dispense('rotas');
     }
     if ($request->isPost()) {
         $data = $request->getParams();
         //$username = $request->getParam('username');
         $rota->import($data, 'name,fullname,title,comment');
         $rota->sharedUsersList = [];
         foreach ($data['users'] as $checkUserID) {
             $rotaUser = R::load('users', $checkUserID);
             $rota->sharedUsersList[] = $rotaUser;
         }
         $id = R::store($rota);
         try {
             $fieldtest = R::inspect($rota->name);
         } catch (\Exception $e) {
             //thaw for creation
             R::freeze(['users']);
             $rotaUser = R::load('users', 1);
             $rotaDay = R::findOrCreate($rota->name, ['day' => 29, 'month' => 2, 'year' => 2015]);
             $rotaUser = R::load('users', 1);
             $rotaDay->name = $rotaUser;
             $rotaDay->who = $rotaUser;
             $rotaDay->stamp = date("Y-m-d H:i:s");
             R::store($rotaDay);
             R::freeze(true);
         }
         $this->flash->addMessage('flash', "{$rota->name} updated");
         return $response->withRedirect($this->router->pathFor('rotas'));
     }
     $userList = R::findAll('users');
     $data = $rota->export();
     $data['userList'] = $userList;
     $users = [];
     $userRota = $rota->sharedUsersList;
     foreach ($userRota as $userCheck) {
         $users[$userCheck->id] = 'checked';
     }
     $data['userCheck'] = $users;
     $this->view->render($response, 'rota.twig', $data);
     return $response;
 }
Exemple #30
-2
 public function setCheckedValue($checkedValue)
 {
     if ($this->bean === null) {
         $this->newBean();
     }
     $bean = $this->bean;
     $bean->{$this->_('checkedValue')} = $checkedValue;
     R::store($bean);
     return $this;
 }