PHP R::getCell方法代码示例

 public function product()
 {
     $perPage = 10;
     $token = $this->slim->request->params('token');
     if (empty($token)) {
         header('Content-Type: application/json');
         echo json_encode(['error' => 'REQUIRE_AUTHORIZE'], JSON_UNESCAPED_SLASHES);
         exit;
     }
     $account = R::findOne("account", "token = ?", [$token]);
     if (!$account) {
         header('Content-Type: application/json');
         echo json_encode(['error' => 'AUTHORIZE_FAILED'], JSON_UNESCAPED_SLASHES);
         exit;
     }
     $page = @$_GET['page'] ? $_GET['page'] : 1;
     $start = ($page - 1) * $perPage;
     $where = [];
     $queryParam = [];
     $where[] = "account_product.account_id = ?";
     $queryParam[] = $account['id'];
     if (!empty($_GET['type'])) {
         $where[] = "product.type = ?";
         $queryParam[] = $_GET['type'];
     }
     if (!empty($_GET['size'])) {
         $where[] = "product.size = ?";
         $queryParam[] = $_GET['size'];
     }
     if (!empty($_GET['style'])) {
         $where[] = "product.style = ?";
         $queryParam[] = $_GET['style'];
     }
     if (!empty($_GET['company'])) {
         $where[] = "product.company = ?";
         $queryParam[] = $_GET['company'];
     }
     $where = implode(" AND ", $where);
     // $queryParam[] = $start;
     // $queryParam[] = $perPage;
     $items = R::getAll("SELECT product.* FROM account_product RIGHT JOIN product ON account_product.product_id = product.id WHERE " . $where . " LIMIT ?,?", array_merge($queryParam, [$start, $perPage]));
     $count = R::getCell("SELECT COUNT(product.id) FROM account_product RIGHT JOIN product ON account_product.product_id = product.id WHERE " . $where, $queryParam);
     $maxPage = floor($count / $perPage) + ($count % $perPage == 0 ? 0 : 1);
     //$itemsExport = R::exportAll($items);
     $itemsExport = $items;
     $this->buildProducts($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 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;
 }

 public function save()
 {
     if (!$this->emptyAttr('id')) {
         $news = R::findOne('news', 'id=?', [$this->getAttr('id')]);
         $news->updated_at = date('Y-m-d H:i:s');
     } else {
         $news = R::dispense('news');
         $news->created_at = date('Y-m-d H:i:s');
         $news->updated_at = date('Y-m-d H:i:s');
         $news->sort_order = (int) R::getCell("SELECT MAX(sort_order) FROM news") + 1;
     }
     $news->name = $this->getAttr('name');
     $oldPicture = null;
     $thumb = null;
     if (!$this->emptyAttr('picture') && $this->attr['picture']->uploaded) {
         $picture = $this->getAttr('picture');
         $picture->file_new_name_body = $this->generateName("news_picture_");
         $picture->image_resize = true;
         $picture->image_convert = 'jpeg';
         // $picture->image_x = 964;
         // $picture->image_y = 1024;
         $picture->image_y = 1024;
         $xDes = round($picture->image_src_x * $picture->image_y / $picture->image_src_y);
         if ($xDes > 964) {
             $picture->image_ratio = true;
             $picture->image_x = 964;
             $picture->image_ratio_crop = true;
         } else {
             $picture->image_ratio_x = true;
         }
         // $picture->image_ratio_y = true;
         $picture->process('upload/');
         $oldPicture = $news->picture;
         $news->picture = $picture->file_dst_name;
     }
     $oldThumb = null;
     $thumb = null;
     if (!$this->emptyAttr('thumb') && $this->attr['thumb']->uploaded) {
         $thumb = $this->getAttr('thumb');
         $thumb->file_new_name_body = $this->generateName("news_thumb_");
         $thumb->image_resize = true;
         $thumb->image_convert = 'jpeg';
         // $thumb->image_x = 460;
         // $thumb->image_y = 520;
         //$thumb->image_ratio_y = true;
         $thumb->image_y = 520;
         $xDes = round($thumb->image_src_x * $thumb->image_y / $thumb->image_src_y);
         if ($xDes > 460) {
             $thumb->image_ratio = true;
             $thumb->image_x = 460;
             $thumb->image_ratio_crop = true;
         } else {
             $thumb->image_ratio_x = true;
         }
         $thumb->process('upload/');
         $oldThumb = $news->thumb;
         $news->thumb = $thumb->file_dst_name;
     }
     $news->content = $this->getAttr('content', '');
     $news->link = $this->getAttr('link', '');
     $success = R::store($news);
     if ($success) {
         if (!is_null($oldPicture)) {
             @unlink('upload/' . $oldPicture);
         }
         if (!is_null($oldThumb)) {
             @unlink('upload/' . $oldThumb);
         }
     }
     return $success;
 }

 public function build(&$item)
 {
     $item['picture_url'] = $this->getBaseUrl() . '/upload/' . $item['picture'];
     $item['thumb_url'] = $this->getBaseUrl() . '/upload/' . $item['thumb'];
     $item['icon_1_url'] = $this->getBaseUrl() . '/icon/' . $item['icon_1'];
     $item['icon_2_url'] = $this->getBaseUrl() . '/icon/' . $item['icon_2'];
     $item['icon_3_url'] = $this->getBaseUrl() . '/icon/' . $item['icon_3'];
     $item['icon_4_url'] = $this->getBaseUrl() . '/icon/' . $item['icon_4'];
     if (!is_file('icon/' . $item['icon_1'])) {
         $item['icon_1_url'] = null;
     }
     if (!is_file('icon/' . $item['icon_2'])) {
         $item['icon_2_url'] = null;
     }
     if (!is_file('icon/' . $item['icon_3'])) {
         $item['icon_3_url'] = null;
     }
     if (!is_file('icon/' . $item['icon_4'])) {
         $item['icon_4_url'] = null;
     }
     $item['total_view'] = R::getCell('SELECT SUM(view_count) FROM product_view WHERE product_id=?', [$item['id']]) | '0';
     $item['total_add'] = R::getCell('SELECT SUM(add_count) FROM product_add WHERE product_id=?', [$item['id']]) | '0';
 }

 public function count()
 {
     if (is_null($this->sql)) {
         return R::count($this->table);
     }
     $this->sql = 'SELECT COUNT(*) FROM ' . $this->table . ' ' . $this->alias . $this->sql;
     $result = R::getCell($this->sql, $this->params);
     $this->sql = null;
     return $result;
 }