PHP R::findOrCreate方法代码示例

 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;
 }

 public function editUser(Request $request, Response $response, array $args)
 {
     $username = strtolower($args['username']);
     if (empty($username)) {
         $this->flash->addMessage('flash', 'No user specified');
         return $response->withRedirect($this->router->pathFor('profile'));
     }
     $id = $this->authenticator->getIdentity();
     // restrict access to own profile or Admin user
     if ($username != strtolower($id['name'])) {
         if (strtolower($id['name']) != 'admin') {
             $this->flash->addMessage('flash', 'Access Denied');
             return $response->withRedirect($this->router->pathFor('profile'));
         }
     }
     if ($username != 'new') {
         $user = R::findOrCreate('users', ['name' => $username]);
     } else {
         $user = R::dispense('users');
     }
     if ($request->isPost()) {
         $data = $request->getParams();
         //$username = $request->getParam('username');
         $user->import($data, 'fullname,shortdial,longdial,colour,mobile,home');
         $user->name = $request->getParam('username');
         $password = $request->getParam('password');
         if (!empty($password)) {
             $pass = password_hash($password, PASSWORD_DEFAULT);
             $user->hash = $pass;
         }
         $id = R::store($user);
         $this->flash->addMessage('flash', "{$user->name} updated");
         return $response->withRedirect($this->router->pathFor('edituser', ['username' => $username]));
         //            $member = 'INSERT INTO `users` (`name`, `fullname`, `password`, `hash`, `colour`, `shortdial`, `longdial`, `mobile`, `home`, `ins_mf`, `ins_win`, `health_mf`, `health_win`, `life_mf`, `life_win`, `wealth_mf`, `wealth_win`, `uk_shift`, `atss`) VALUES '
         //                . "($username, $fullname, :pass, '', 'FAD2F5', $shortdial, $longdial, '', '', '1', '0', '0', '1', '0', '0', '0', '1', '0', '0');
         //                ";
     }
     $this->view->render($response, 'user.twig', $user->export());
     return $response;
 }

 public function editUser(Request $request, Response $response, array $args)
 {
     $username = strtolower($args['username']);
     if (empty($username)) {
         $this->flash->addMessage('flash', 'No user specified');
         return $response->withRedirect($request->getUri()->getBaseUrl() . $this->router->pathFor('profile'));
     }
     $id = $this->authenticator->getIdentity();
     // restrict access to own profile or Admin user
     if ($username != strtolower($id['name'])) {
         if (strtolower($id['name']) != 'admin') {
             $this->flash->addMessage('flash', 'Access Denied');
             return $response->withRedirect($request->getUri()->getBaseUrl() . $this->router->pathFor('profile'));
         }
     }
     if ($username != 'new') {
         $user = R::findOrCreate('users', ['name' => $username]);
     } else {
         $user = R::dispense('users');
     }
     if ($request->isPost()) {
         $data = $request->getParams();
         //$username = $request->getParam('username');
         $user->import($data, 'fullname,colour,mobile,home');
         $user->name = $request->getParam('username');
         $password = $request->getParam('password');
         if (!empty($password)) {
             $pass = password_hash($password, PASSWORD_DEFAULT);
             $user->hash = $pass;
         }
         $id = R::store($user);
         $this->flash->addMessage('flash', "{$user->name} updated");
         return $response->withRedirect($request->getUri()->getBaseUrl() . $this->router->pathFor('edituser', ['username' => $username]));
     }
     $this->view->render($response, 'user.twig', $user->export());
     return $response;
 }

 /**
  * find or create new pair
  *
  * @param \RedBeanPHP\OODBBean $currencyFrom
  * @param \RedBeanPHP\OODBBean $currencyTo
  *
  * @return \RedBeanPHP\OODBBean
  */
 protected static function getPairFromDb($currencyFrom, $currencyTo)
 {
     return RedBean::findOrCreate('pair', ['currency_from_id' => $currencyFrom->id, 'currency_to_id' => $currencyTo->id]);
 }

 public function change(Request $request, Response $response, array $args)
 {
     $this->logger->info("Oncall Change page action dispatched");
     $rota = strtolower($args['rota']);
     $display = 6;
     $name = $request->getParam('name', '');
     $prev = $request->getParam('prev', 0);
     $day = $request->getParam('day');
     $month = $request->getParam('month');
     $monthObj = \DateTime::createFromFormat('!m', $month);
     $monthName = $monthObj->format('F');
     $year = $request->getParam('year');
     $title = "Please select who is oncall for - {$day} {$monthName} {$year}";
     if (!empty($name)) {
         $rotaUser = R::findOne('users', ' name = :username ', ['username' => $name]);
         if (empty($rotaUser)) {
             $this->flash->addMessage('flash', "{$name} not found");
             return $response->withRedirect($this->router->pathFor('oncall', ['rota' => $rota]));
         }
         $oldDay = (int) $day;
         $oldMonth = (int) $month;
         $oldYear = (int) $year;
         $whatDay = 8 - date('w', mktime(0, 0, 0, $oldMonth, $oldDay, $oldYear));
         if ($whatDay == 8 || $request->getParam('allweek') == null) {
             $whatDay = 1;
         }
         for ($x = 0; $x < $whatDay; $x++) {
             $day = date('j', mktime(0, 0, 0, $oldMonth, $oldDay + $x, $oldYear));
             $month = date('n', mktime(0, 0, 0, $oldMonth, $oldDay + $x, $oldYear));
             $year = date('Y', mktime(0, 0, 0, $oldMonth, $oldDay + $x, $oldYear));
             $rotaDay = R::findOrCreate($rota, ['day' => $day, 'month' => $month, 'year' => $year]);
             $rotaDay->name = $rotaUser;
             $id = $this->authenticator->getIdentity();
             $whoUser = R::load('users', $id['id']);
             $rotaDay->who = $whoUser;
             $rotaDay->stamp = date("Y-m-d H:i:s");
             R::store($rotaDay);
         }
         $this->flash->addMessage('flash', "Rota updated");
         return $response->withRedirect($this->router->pathFor('oncall', ['rota' => $rota]));
     }
     $rotaBean = R::findOne('rotas', ' name = :name ', [':name' => $rota]);
     if (empty($rotaBean)) {
         $this->flash->addMessage('flash', "sorry {$rota} not found");
         return $response->withRedirect($this->router->pathFor('homepage'));
     }
     $userlist = [];
     $users = $rotaBean->sharedUsersList;
     foreach ($users as $user) {
         $userlist[] = ['colour' => $user['colour'], 'linkday' => '<a href="?name=' . $user['name'] . "&day={$day}&month={$month}&year={$year}\">" . $user['fullname'] . "</a>", 'linkweek' => '<a href="?name=' . $user['name'] . "&day={$day}&month={$month}&year={$year}&allweek=Y\">" . $user['fullname'] . "</a>"];
     }
     $this->view->render($response, 'change.twig', ['rota' => $rota, 'title' => $title, 'userlist' => $userlist]);
     return $response;
 }

 public function saveToRepo($download, $sha256)
 {
     if (!isset($download['package'])) {
         print_r($download);
         print_r($sha256);
         exit;
     }
     $package = $download['package'];
     $data = R::findOrCreate("repo", array("name" => $package['name'], "project" => substr($package['name'], 0, strpos($package['name'], '/'))));
     $versions = array_values($package['versions']);
     $version = $versions[0];
     $table_package = R::dispense("repo");
     $table_package->id = $data->id;
     $table_package->description = $package['description'];
     $table_package->type = $package['type'];
     $table_package->time = strtotime($package['time']);
     //        $table_package->keywords = implode(',',$version['keywords']);
     $table_package->download_total = $package['downloads']['total'];
     $table_package->download_monthly = $package['downloads']['monthly'];
     $table_package->favers = $package['favers'];
     $table_package->sha256 = $sha256;
     R::store($table_package);
 }

 public function doDownLoad($limit_array)
 {
     $output = new ConsoleOutput();
     //        $bar = new ProgressBar($output,count($limit_array));
     //        $bar->start();
     //        $bar->setBarWidth(100);
     $i = 0;
     $count = count($limit_array);
     //        $bar->setFormat('debug');
     foreach ($limit_array as $file => $data) {
         //            $package = $this->repository_path."/packages/".$file.".json";
         $versions = $this->repository_path . "/download/" . $file . ".json";
         //            $package = json_decode(file_get_contents($package),true);
         $download = json_decode(file_get_contents($download), true);
         if (!$download) {
             $i++;
             $output->writeln($i . '/' . $count . ' skip');
             continue;
             //                $bar->advance();
         }
         $i++;
         $versions = array_values($download['package']['versions']);
         if (!isset($versions[0]['require'])) {
             $output->writeln($i . '/' . $count . ' skip');
             continue;
         }
         $output->writeln($i . '/' . $count);
         $package_name = strtolower($download['package']['name']);
         $project_name = substr($package_name, 0, strpos($package_name, '/'));
         //            echo strpos($package_name,'/').' '.$package_name."\r\n";exit;
         if (isset($versions[0]['require'])) {
             foreach ($versions[0]['require'] as $k => $v) {
                 R::findOrCreate("CpmRequire", array("package" => $package_name, "project" => $project_name, "require" => strtolower($k), "version" => strtolower($v)));
             }
         }
         if (isset($versions[0]['require-dev'])) {
             foreach ($versions[0]['require-dev'] as $k => $v) {
                 R::findOrCreate("CpmRequireDev", array("package" => $package_name, "project" => $project_name, "require" => strtolower($k), "version" => strtolower($v)));
             }
         }
         if (isset($versions[0]['keywords'])) {
             foreach ($versions[0]['keywords'] as $v) {
                 R::findOrCreate("CpmKeyword", array("package" => $package_name, "project" => $project_name, "keyword" => strtolower($v)));
             }
         }
     }
     //        $bar->finish();
     $output->writeln('');
 }

 /**
  * @param string    $side       'buy' or 'sell'
  * @param string    $pair       Name of Instrument
  * @param float     $price      execution price
  * @param int       $expiry     UTC timestamp format of order expiry e.g. now()+3600 (for 1 hour)
  * @param float     $stopLoss   Price of stopLoss
  * @param float     $takeProfit Price of takeProfit
  * @param int       $risk       Risk percent of account 1 = 1%
  */
 public function placeLimitOrder($side, $pair, $price, $expiry, $stopLoss, $takeProfit = NULL, $risk = 1)
 {
     //order options?
     $orderOptions = FALSE;
     //TODO calculate units based on risk
     // find how many pips risked
     //$stopSize = (abs($price-$stopLoss))/$this->oandaWrap->instrument_pip($pair);
     //        $stopSize = abs($this->oandaWrap->calc_pips($pair,$price,$stopLoss));
     // find risk amount of account
     //$size = $this->oandaWrap->nav_size_percent($pair,$risk);
     //$units = $size / $stopSize;
     //$units = $this->oandaWrap->nav_size_percent_per_pip($pair,$risk/$stopSize);
     $data = $this->oandaWrap->account($this->accountId);
     $accountBalance = $data->balance;
     $accountCurrency = $data->accountCurrency;
     $loss = $accountBalance * ($risk / 100);
     // the quote is 2nd half of pair vs home price
     // if they are the same, conversion = 1
     $split = $this->oandaWrap->instrument_split($pair);
     if ($split[1] == $accountCurrency) {
         $quotePrice = 1;
     } else {
         // get valid pair string and get price
         $conPair = $this->oandaWrap->instrument_name($accountCurrency, $split[1]);
         $quote = $this->oandaWrap->price($conPair);
         $reverse = strpos($conPair, $accountCurrency) > strpos($conPair, '_') ? FALSE : TRUE;
         $quotePrice = $reverse ? $quote->ask : 1 / $quote->ask;
     }
     $units = round($loss / (abs($price - $stopLoss) * $quotePrice));
     /* @var \StdClass Oanda Order Object*/
     $order = $this->oandaWrap->order_open($side, $units, $pair, 'marketIfTouched', $price, $expiry, $orderOptions);
     if (isset($order->code)) {
         echo $order->message;
         return $order->message;
     }
     // create and save order
     $currOrder = R::findOrCreate('orders', ['oandaoid' => $order->orderOpened->id, 'instrument' => $order->instrument]);
     $currOrder->units = $order->orderOpened->units;
     $currOrder->side = $order->orderOpened->side;
     //$currOrder->type = $order->type;
     $currOrder->time = $order->time;
     $currOrder->expiry = $order->orderOpened->expiry;
     $currOrder->price = $order->price;
     if (empty($currOrder->account)) {
         $account = R::findOne('accounts', ' accountid = ?', [$this->accountId]);
         if (!empty($account)) {
             $currOrder->account = $account;
         }
     }
     // apply stop loss
     $sOrder = $this->oandaWrap->order_set_stop($currOrder['oandaoid'], $stopLoss);
     $currOrder->stopLoss = $stopLoss;
     // apply takeprofit if set
     if (!empty($takeProfit)) {
         $tOrder = $this->oandaWrap->order_set_tp($currOrder['oandaoid'], $takeProfit);
         $currOrder->takeProfit = $order->takeProfit;
     }
     R::store($currOrder);
 }