src/Controller/NavigationController.php line 22

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  6. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  8. use Symfony\Component\HttpFoundation\Response;
  9. use Symfony\Component\Routing\Annotation\Route;
  11. use App\Repository\ModelRepository;
  12. use App\Repository\PriceRepository;
  13. use App\Service\PdfService;
  15. use App\Entity\Payment;
  16. use App\Entity\Client;
  18. class NavigationController extends AbstractController
  19. {
  21.     #[Route(path: '/', name: 'index')]
  22.     public function index(): Response
  23.     {
  24.         return $this->render('index.html.twig' );
  25.     }
  28.     #[Route(path: '/user', name: 'user_page')]
  29.     public function userPage( ModelRepository $modelRepository, PriceRepository $priceRepository): Response
  30.     {
  31.         $models = $modelRepository->findAll();
  32.         $price = $priceRepository->findActive();
  34.         return $this->render('client/userPage.html.twig' , ["models" => $models, "price" => $price]);
  35.     }
  37.     
  38.     #[Route(path: '/readPaymentPdf/{id}', name: 'read_payment_pdf')]
  39.     public function readPaymentPdf( PdfService $pdfService , Payment $payment): Response
  40.     {
  41.         
  42.         if( ( $this->getUser() != $payment->getClient()->getUser() ) && !$this->isGranted('ROLE_ADMIN') ){
  43.             return new Response('', 403);
  44.         }
  47.         $html = $this->render('pdf/paymentInvoice.html.twig', ['payment' => $payment]);
  48.         $pdfService->streamPdf($html);
  50.         return new Response('', 200, [
  51.             'Content-Type' => 'application/pdf',
  52.           ]);
  53.     }
  54.     
  55.     #[Route(path: '/binanceApi', name: 'binanceApi')]
  56.     public function binanceApi(): Response
  57.     {
  59.         //$connexion = new \PDO("mysql:host=chrisjz9.mysql.db/chrisjz9;dbname=chrisjz9;port=3306", "chrisjz9", "Roinfo91");
  60.         $connexion = new \PDO("mysql:host=127.0.0.1;dbname=mmi;port=3306", "root", "");
  62.         $requete = "SELECT * FROM CLIENT";
  63.         $resultats = $connexion->query($requete);
  65.         foreach ($resultats->fetchAll() as $client) {
  66.             var_dump( $client['name'] );
  67.         }
  69.         $url = "https://whattomine.com/coins/162.json?hr=70&p=0.0&fee=0.0&cost=0.1&cost_currency=USD&hcost=0.0&span_br=&span_d=24";
  71.         $ch = curl_init();
  72.         curl_setopt($ch, CURLOPT_URL, $url);
  73.         curl_setopt($ch, CURLOPT_HEADER, 0);
  74.         curl_setopt($ch, CURLOPT_HTTPHEADER, array('Accept: application/json', 'Content-Type: application/json'));
  75.         curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  76.         $response = curl_exec($ch);
  77.         curl_close($ch);
  78.         
  79.         $data = json_decode($response, true);
  80.         
  81.         if($data == null){
  82.             return new Response("no response");
  83.         }
  84.         
  85.         return new Response( floatval( substr($data['profit'], 1) ) );
  86.     }
  90.     #[Route(path: '/testApi', name: 'testApi')]
  91.     public function testApi(): Response
  92.     {
  93.         /*
  94.         $today = new \DateTime();
  95.         $text = "";
  96.         $key = "jvIkawn4EeidllU2F14lWz1NJMQJ84CqwFwF5r8eQBrx2EVe3jVoogAfJg84iv81";
  97.         $secret = "rdveQW1Vd06Q2LTGL18cluentqNTQkvV0iOAGBajHLrEaalRbDzuMZrphK45okvN";
  99.         $ch = curl_init();
  100.             
  101.             $url = "https://api.binance.com/api/v3/depth";
  102.             curl_setopt($ch, CURLOPT_URL, $url);
  103.             curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  104.             curl_setopt($ch, CURLOPT_HTTPHEADER,  array('X-MBX-APIKEY:'.$key));
  106.             $querystring = "symbol=ETH";
  107.             $signature = hash_hmac('SHA256',$querystring ,$secret);
  109.             $post = [
  110.                 'symbol' => 'ETH',
  111.                 'signature' => $signature,
  112.             ];
  113.             curl_setopt($ch, CURLOPT_POST, 1);
  114.             curl_setopt($ch, CURLOPT_POSTFIELDS, $post);
  116.             $result = curl_exec($ch);
  117.             curl_close ($ch);
  119.             var_dump($result);
  120.         */
  122.             
  123.         $url = "https://api.binance.com/api/v3/depth?symbol=BNBBTC";
  124.         
  125.         $ch = curl_init();
  126.         curl_setopt($ch, CURLOPT_URL, $url);
  127.         curl_setopt($ch, CURLOPT_HEADER, 0);
  128.         curl_setopt($ch, CURLOPT_HTTPHEADER, array('Accept: application/json', 'Content-Type: application/json'));
  129.         curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  130.         $response = curl_exec($ch);
  131.         curl_close($ch);
  133.         var_dump($response);
  135.         return new Response("-----------");
  136.     }
  139. }