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; }
/** * Insert or update a facebook user. * * @param array $payload */ public static function upsert($payload) { R::freeze(false); // if no session set add it if (!isset($payload['session'])) { $payload['session'] = session_id(); } // Find an existing user in db by session $user = R::findOne(USER, 'session = :session AND ip = :ip ', array(':session' => $payload['session'], ':ip' => $payload['ip'])); // if we have a payload with id set the facebook id if (isset($payload['id'])) { // change the id into fbid. $payload['fbid'] = '' . $payload['id']; unset($payload['id']); } if (isset($payload['email'])) { $emailuser = R::findOne(USER, 'email = :email ', array(':email' => $payload['email'])); if ($emailuser) { $user = $emailuser; } } if (isset($payload['fbid'])) { $fbiduser = R::findOne(USER, 'fbid = :fbid ', array(':fbid' => $payload['fbid'])); if ($fbiduser) { $user = $fbiduser; } } // the date $currentDate = new \DateTime(); if (!$user) { $user = R::xdispense(USER); $user->createdate = $currentDate->format('Y-m-d H:i:s'); } $user->import($payload); // update the lastupdated timestamp $user->lastupdate = $currentDate->format('Y-m-d H:i:s'); R::store($user); }
/** */ function populate() { // do not execute this function return; R::freeze(false); R::nuke(); $quiz = R::xdispense(QUIZ); $quiz->theme = 'starwars'; $quiz->nextaction = '/'; R::store($quiz); $question = R::xdispense(QUESTION); $question->title = "Which Star Wars Character Are You?!"; R::store($question); $question->{QUIZ} = $quiz; R::store($question); $answer = R::xdispense(ANSWER); $answer->title = 'Han Solo'; $answer->message = "You have a strong and determined personality, but beneath your tough exterior you have a loving heart and an inner bravery that will help you through the tough times. You learn from your mistakes and always stay true to yourself!"; $answer->sharemessage = "I have a strong and determined personality, but beneath my tough exterior I have a loving heart and an inner bravery that helps me through the tough times. I learn from my mistakes and always stay true to myself! Who would you be?"; $answer->image = 'A'; $answer->{QUIZ} = $quiz; $answer->{QUESTION} = $question; R::store($answer); $answer = R::xdispense(ANSWER); $answer->title = 'Luke Skywalker'; $answer->message = "You're courageous, eager for adventure and an all-round hero. Sometimes you find it hard to control your emotions, but you always have the happiness and wellbeing of others at heart!"; $answer->sharemessage = "I'm courageous, eager for adventure and an all-round hero. Sometimes I find it hard to control my emotions, but I always have the happiness and wellbeing of others at heart! Who would you be?"; $answer->image = 'B'; $answer->{QUIZ} = $quiz; $answer->{QUESTION} = $question; R::store($answer); $answer = R::xdispense(ANSWER); $answer->title = 'Princess Leia'; $answer->image = 'C'; $answer->message = "You're level-headed, courageous, and with a sharp-tongued wit surpassed only by your beauty. You've been through some tough times but always come out stronger in the end!"; $answer->sharemessage = "I'm level-headed, courageous, and with a sharp-tongued wit surpassed only by my beauty. I've been through some tough times but always come out stronger in the end! Who would you be?"; $answer->{QUIZ} = $quiz; $answer->{QUESTION} = $question; R::store($answer); $answer = R::xdispense(ANSWER); $answer->title = 'Chewbacca'; $answer->image = 'D'; $answer->message = "You may look tough, and even scary to some people, but deep down you're a big softie. You're loyal, affectionate and humble - but if you think something isn't fair you're not afraid to say so! "; $answer->sharemessage = "I may look tough, and even scary to some people, but deep down I'm a big softie. I'm loyal, affectionate and humble - but if I think something isn't fair I'm not afraid to say so! Who would you be?"; $answer->{QUIZ} = $quiz; $answer->{QUESTION} = $question; R::store($answer); $answer = R::xdispense(ANSWER); $answer->title = 'Finn'; $answer->image = 'E'; $answer->message = "Despite what life has thrown at you, you have a good heart and true empathy for other people. You are brave, intelligent and with the strength to face down whatever life throws at you!"; $answer->sharemessage = "Despite what life has thrown at me, I have a good heart and true empathy for other people. I am brave, intelligent and with the strength to face down whatever life throws at me! Who would you be?"; $answer->{QUIZ} = $quiz; $answer->{QUESTION} = $question; R::store($answer); $answer = R::xdispense(ANSWER); $answer->title = 'Rey'; $answer->image = 'F'; $answer->message = "You have a heart full of generosity and a desire to help others, often putting their needs before your own. You have a great imagination that sets you apart from the majority of others!"; $answer->sharemessage = "I have a heart full of generosity and a desire to help others, often putting their needs before my own. I have a great imagination that sets me apart from the majority of others! Who would you be?"; $answer->{QUIZ} = $quiz; $answer->{QUESTION} = $question; R::store($answer); $quiz_user = array('createdate' => '2016-02-08 19:20:37', 'name' => 'Matteo Monti Matteo Monti Matteo Monti Matteo Monti Matteo Monti', 'email' => 'mmonti@gmail.commmonti@gmail.commmonti@gmail.commmonti@gmail.commmonti@', 'gender' => 'maleorfemale', 'ip' => '151.237.238.110', 'fbid' => '1a01544915asdasdasdasdasdasd51609838e16', 'lastupdate' => '2016-02-08 19:20:37', 'city' => 'Leccooranotherlocationwhatever', 'country' => 'Leccooranotherlocationwhatever', 'latitude' => '45.85a', 'longitude' => '9.38333a'); $user = R::xdispense(USER); $user->import($quiz_user); R::store($user); R::wipe(USER); R::freeze(true); return $quiz; }
/** * @param null $contents * @return int|string */ public function create($contents = null) { $this->instance = R::xdispense($this->table); return is_null($contents) ? $this : $this->with($contents); }
public function addProduct() { $productId = $this->slim->request->params('product_id'); $token = $this->slim->request->params('token'); if (empty($token)) { header('Content-Type: application/json'); echo json_encode(['error' => 'REQUIRE_AUTHORIZE'], JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE); exit; } $account = R::findOne("account", "token = ?", [$token]); if (!$account) { header('Content-Type: application/json'); echo json_encode(['error' => 'AUTHORIZE_FAILED'], JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE); exit; } $product = R::findOne("product", "id = ?", [$productId]); if (!$product) { header('Content-Type: application/json'); echo json_encode(['error' => 'PRODUCT_NOT_FOUND'], JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE); exit; } $old = R::findOne("account_product", "account_id = ? AND product_id = ?", [$account['id'], $productId]); if ($old) { header('Content-Type: application/json'); echo json_encode(['error' => 'DUPLICATE_ITEM'], JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE); exit; } $item = R::xdispense('account_product'); $item->created_at = date('Y-m-d H:i:s'); $item->account_id = $account['id']; $item->product_id = $product['id']; R::store($item); $this->productAddStat($product['id']); header('Content-Type: application/json'); echo json_encode(['success' => true], JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE); exit; }
/** * TODO: Update to similar to updateBean * Store Data into Database * @param $data * @return int|string */ public function insertBean($data) { $bean = R::xdispense($this->tableName); if ($this->beforeInsertBean != null) { $callable = $this->beforeInsertBean; $callable($bean); } $result = $this->saveBean($bean, $data); if (!isset($result->msg)) { $result->msg = "The record has been created successfully."; $result->class = "callout-info"; $result->ok = true; } else { $result->ok = false; } if ($this->afterInsertBean != null) { $callable = $this->afterInsertBean; $callable($bean, $result); } return $result; }