PHP R::exportAll方法代码示例

 function addBeans($beans)
 {
     if (null == $beans) {
         return array();
     }
     $this->data = R::exportAll($beans);
 }

 public function index()
 {
     $perPage = 10;
     $page = @$_GET['page'] ? $_GET['page'] : 1;
     $start = ($page - 1) * $perPage;
     $items = R::find('news', ' ORDER BY sort_order LIMIT ?,?', [$start, $perPage]);
     $itemsAll = R::find('news', 'ORDER BY sort_order');
     $itemsAll = R::exportAll($items);
     $count = R::count('news');
     $maxPage = floor($count / $perPage) + ($count % $perPage == 0 ? 0 : 1);
     $this->slim->render("news/list.php", ['items' => $items, 'itemsAll' => $itemsAll, 'page' => $page, 'maxPage' => $maxPage]);
 }

 public function index()
 {
     $perPage = 10;
     $page = @$_GET['page'] ? $_GET['page'] : 1;
     $start = ($page - 1) * $perPage;
     $items = R::find('room', 'LIMIT ?,?', [$start, $perPage]);
     $count = R::count('room');
     $maxPage = floor($count / $perPage) + ($count % $perPage == 0 ? 0 : 1);
     $itemsExport = R::exportAll($items);
     $this->builds($itemsExport);
     $this->slim->render("room/list.php", ['items' => $itemsExport, 'page' => $page, 'maxPage' => $maxPage]);
 }

 public function index($roomId)
 {
     $perPage = 10;
     $page = @$_GET['page'] ? $_GET['page'] : 1;
     $start = ($page - 1) * $perPage;
     $room = R::findOne('room', 'id = ?', [$roomId]);
     $items = R::find('room_pattern', 'room_id = ? LIMIT ?,?', [$roomId, $start, $perPage]);
     $count = R::count('room_pattern', 'room_id = ?', [$roomId]);
     $maxPage = floor($count / $perPage) + ($count % $perPage == 0 ? 0 : 1);
     $itemsExport = R::exportAll($items);
     $this->builds($itemsExport);
     $this->slim->render("room/pattern/list.php", ['room' => $room, 'items' => $itemsExport, 'page' => $page, 'maxPage' => $maxPage]);
 }

 public function index()
 {
     $perPage = 10;
     $page = @$_GET['page'] ? $_GET['page'] : 1;
     $start = ($page - 1) * $perPage;
     $items = R::find('room', 'LIMIT ?,?', [$start, $perPage]);
     $count = R::count('room');
     $maxPage = floor($count / $perPage) + ($count % $perPage == 0 ? 0 : 1);
     $itemsExport = R::exportAll($items);
     $this->builds($itemsExport);
     header('Content-Type: application/json');
     echo json_encode(['items' => $itemsExport, 'page' => $page, 'maxPage' => $maxPage, 'total' => $count], JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE);
     exit;
 }

 public function sheet()
 {
     $items = R::find("account", "email IS NOT NULL");
     $itemsExport = R::exportAll($items);
     $this->builds($itemsExport);
     // var_dump($itemsExport);
     $excel = new PHPExcel();
     $excel->getProperties()->setCreator("duragres - users");
     $excel->getProperties()->setLastModifiedBy("duragres - users");
     $excel->getProperties()->setTitle("duragres - users");
     $excel->getProperties()->setSubject("duragres - users");
     $excel->getProperties()->setDescription("duragres - users, report.");
     $excel->setActiveSheetIndex(0);
     $sheet = $excel->getActiveSheet();
     $sheet->setTitle("Report");
     foreach ($itemsExport as $key => $item) {
         if ($key == 0) {
             $sheet->SetCellValue('A' . '1', "ID");
             $sheet->SetCellValue('B' . '1', "Created At");
             $sheet->SetCellValue('C' . '1', "Email");
             $sheet->SetCellValue('F' . '1', "Product Count");
         }
         $i = $key + 2;
         $bTime = @strtotime($item["created_at"]);
         $bYear = @date('Y', $bTime);
         // + 543;
         $bStr = @date('d/m/', $bTime) . $bYear;
         $bStr = !empty($item["created_at"]) ? $bStr : "";
         $sheet->SetCellValue('A' . $i, $item["id"]);
         $sheet->SetCellValue('B' . $i, $bStr);
         $sheet->SetCellValue('C' . $i, $item["email"]);
         $sheet->SetCellValue('F' . $i, $item["product_count"]);
     }
     $objWriter = PHPExcel_IOFactory::createWriter($excel, 'Excel5');
     // We'll be outputting an excel file
     header('Content-type: application/vnd.ms-excel');
     // It will be called file.xls
     header('Content-Disposition: attachment; filename="users.xls"');
     // Write file to the browser
     $objWriter->save('php://output');
     exit;
 }

 public function index()
 {
     $perPage = 999999;
     $page = @$_GET['page'] ? $_GET['page'] : 1;
     $start = ($page - 1) * $perPage;
     $where = [];
     $whereParam = [];
     if (!empty($_GET['room_id'])) {
         $where[] = "room_id = ?";
         $whereParam[] = $_GET['room_id'];
     }
     $whereString = implode("AND", $where);
     $items = R::find('room_pattern', $whereString . ' LIMIT ?,?', array_merge($whereParam, [$start, $perPage]));
     $count = R::count('room_pattern', $whereString, $whereParam);
     $maxPage = floor($count / $perPage) + ($count % $perPage == 0 ? 0 : 1);
     $itemsExport = R::exportAll($items);
     $this->builds($itemsExport);
     header('Content-Type: application/json');
     echo json_encode(['items' => $itemsExport, 'page' => $page, 'maxPage' => $maxPage, 'total' => $count], JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE);
     exit;
 }

            foreach ($board->sharedUser as $user) {
                if ($user->defaultBoard == $data->boardId) {
                    $user->defaultBoard = null;
                    R::store($user);
                }
            }
            R::trashAll($board->xownLane);
            R::trashAll($board->xownCategory);
            R::trash($board);
            R::exec('DELETE from board_user WHERE board_id = ?', [$data->boardId]);
            $jsonResponse->addAlert('success', 'Removed board ' . $board->name . '.');
            $actor = getUser();
            logAction($actor->username . ' removed board ' . $board->name, $before, null);
        }
        $jsonResponse->addBeans(getBoards());
        $jsonResponse->users = R::exportAll(getUsers());
    }
    $app->response->setBody($jsonResponse->asJson());
});
$app->post('/autoactions', function () use($app, $jsonResponse) {
    $data = json_decode($app->environment['slim.input']);
    if (validateToken(true)) {
        $board = R::load('board', $data->boardId);
        if ($board->id) {
            $autoAction = R::dispense('autoaction');
            $autoAction->triggerId = $data->triggerId;
            $autoAction->secondaryId = $data->secondaryId;
            $autoAction->actionId = $data->actionId;
            $autoAction->color = $data->color;
            $autoAction->categoryId = $data->categoryId;
            $autoAction->assigneeId = $data->assigneeId;

function getNextItemPosition($columnId)
{
    $retVal = 0;
    $column = R::load('lane', $columnId);
    if ($column->id) {
        $options = R::exportAll(getUser()->ownOption);
        if ($options[0]['tasks_order'] == 1) {
            // Tasks at top of column.
            renumberItems($columnId, 0, false);
        } else {
            try {
                $retVal = $column->countOwn('item');
            } catch (Exception $e) {
                // Ignore, just means there are no items.
            }
        }
    }
    return $retVal;
}

            R::store($user);
            addUserToBoard($data->defaultBoard, $user);
            foreach ($data->boardAccess as $board) {
                addUserToBoard($board, $user);
            }
            logAction($actor->username . ' updated user ' . $user->username, $before, $user->export());
            $jsonResponse->addAlert('success', 'User updated.');
        }
        $jsonResponse->addBeans(getUsers());
        $jsonResponse->boards = R::exportAll(getBoards());
    }
    $app->response->setBody($jsonResponse->asJson());
});
// Remove a user.
$app->post('/users/remove', function () use($app, $jsonResponse) {
    $data = json_decode($app->environment['slim.input']);
    if (validateToken(true)) {
        $user = R::load('user', $data->userId);
        $actor = getUser();
        if ($user->id == $data->userId && $actor->isAdmin) {
            $before = $user->export();
            R::trash($user);
            R::exec('DELETE from board_user WHERE user_id = ?', [$data->userId]);
            logAction($actor->username . ' removed user ' . $before['username'], $before, null);
            $jsonResponse->addAlert('success', 'Removed user ' . $user->username . '.');
        }
        $jsonResponse->addBeans(getUsers());
        $jsonResponse->boards = R::exportAll(getBoards());
    }
    $app->response->setBody($jsonResponse->asJson());
});

    if ($customer) {
        if (isset($customer->website)) {
            $customer->website = (string) $input->website;
        }
        if (isset($input->ownOptions)) {
            foreach ($input->ownOptions as $option) {
                $customerOption = \RedBeanPHP\R::dispense("options", 1);
                foreach ($option as $key => $val) {
                    $customerOption->{$key} = $val;
                }
                $customer->ownOptions[] = $customerOption;
            }
        }
        \RedBeanPHP\R::store($customer);
        $app->response()->header('Content-Type', 'application/json');
        echo json_encode(\RedBeanPHP\R::exportAll($customer));
    } else {
        $app->response()->status(404);
    }
});
// handle DELETE requests
$app->delete('/customers/:id', function ($id) use($app) {
    //\RedBeanPHP\R::dependencies(array('options'=>array('customers')));
    // retrieve specified element record
    $customer = \RedBeanPHP\R::findOne('customers', 'id = ?', array($id));
    if ($customer) {
        \RedBeanPHP\R::trashAll($customer->ownOptions);
        \RedBeanPHP\R::trash($customer);
        $app->response()->status(204);
    } else {
        $app->response()->status(404);