src/Controller/DefaultController.php line 33

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Service\CommonService;
  6. use App\Service\ToolService;
  7. use PhpOffice\PhpSpreadsheet\Document\Properties as DocumentProperties;
  8. use PhpOffice\PhpSpreadsheet\Reader\Security\XmlScanner;
  9. use PhpOffice\PhpSpreadsheet\Reader\Xls\Style\Border;
  10. use PhpOffice\PhpSpreadsheet\Reader\Xlsx as XlsxReader;
  11. use PhpOffice\PhpSpreadsheet\Shared\File;
  12. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  13. use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
  14. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  15. use PhpOffice\PhpSpreadsheet\Writer\Xlsx as XlsxWriter;
  16. use Pimcore\Controller\FrontendController;
  17. use Pimcore\Model\Asset;
  18. use Pimcore\Model\DataObject;
  19. use Pimcore\Model\DataObject\Category;
  20. use Pimcore\Model\DataObject\CategoryParam;
  21. use Pimcore\Model\DataObject\Product;
  22. use Symfony\Component\HttpFoundation\Request;
  23. use Symfony\Component\HttpFoundation\Response;
  24. use Symfony\Component\Routing\Annotation\Route;
  26. class DefaultController extends FrontendController
  27. {
  28.     /**
  29.      * 默认页面模板
  30.      * @param Request $request
  31.      * @return Response
  32.      */
  33.     public function defaultAction(Request $request): Response
  34.     {
  35.         $dom = $this->document;
  36.         $data = [
  37.             'title'=>$dom->getProperty('title'),
  38.             'css'=>$dom->getProperty('css'),
  39.         ];
  40.         $template = $dom->getTemplate();
  41.         return $this->render($template?:'default/default.html.twig', $data);
  42.     }
  44.     /**
  45.      * 测试用
  46.      * 打印商品pdf-模板
  47.      * @param Request $request
  48.      * @return Response
  49.      */
  50.     public function printProductAction(Request $request): Response
  51.     {
  52.         $dom = $this->document;
  53.         $id = $request->query->get('pid', $dom->getProperty('pid'));
  54.         if(!$id) {
  55.             return new Response('缺少商品id');
  56.         }
  58.         $data = CommonService::getProductInfo($id);
  59.         if(is_string($data)) {
  60.             return new Response($data);
  61.         }
  63.         $data['title'] = $dom->getProperty('title');
  64.         $data['css'] = $dom->getProperty('css');
  66.         return $this->render('default/default.html.twig', $data);
  67.     }
  69.     /**
  70.      * 生成报价单-返回文件url
  71.      * @Route("/getExcel")
  72.      * @return \Symfony\Component\HttpFoundation\JsonResponse
  73.      */
  74.     public function getQuotationExcelAction(Request $request)
  75.     {
  76.         $id = $request->query->get('id');
  77.         $qua = DataObject\Quotation::getById($id);
  78.         $res = CommonService::generateExcel($qua);
  79.         return $this->redirect($res);
  80.     }
  82.     /**
  83.      * @Route("/test0")
  84.      * @param Request $request
  85.      */
  86.     public function test0Action(Request $request)
  87.     {
  88.         $file = Asset::getByPath('/document/hepar.pptx');
  89.         var_dump(PIMCORE_WEB_ROOT.'/var/assets'.$file->getRealFullPath());
  90.         return $this->file(PIMCORE_WEB_ROOT.'/var/assets'.$file->getRealFullPath(), '22.pptx');
  91.     }
  93.     /**
  94.      * @Route("/test1")
  95.      * @param Request $request
  96.      */
  97.     public function test1Action(Request $request)
  98.     {
  99.         echo date('M');
  100.         echo '----';
  101.         return $this->json(date('M d, Y'));
  102.     }
  104.     /**
  105.      * @Route("/test3")
  106.      * @param Request $request
  107.      */
  108.     public function test3Action(Request $request)
  109.     {
  111.         $product = Product::getById(9);
  112.         $list = CommonService::getCategoryParamValues($product, false, 'zh');
  114.         return $this->json($list);
  115.     }
  117. }