Symfony Profiler

<?php
namespace Diplix\KMGBundle\Controller;
use Diplix\KMGBundle\Entity\Accounting\CoopMember;
use Diplix\KMGBundle\Entity\Accounting\Job;
use Diplix\KMGBundle\Entity\Accounting\JobCalcItem;
use Diplix\KMGBundle\Entity\Customer;
use Diplix\KMGBundle\Entity\Dispatching\DispatchQueueItem;
use Diplix\KMGBundle\Entity\Order;
use Diplix\KMGBundle\Entity\Role;
use Diplix\KMGBundle\Entity\User;
use Diplix\KMGBundle\Helper\AesTool;
use Diplix\KMGBundle\Helper\ClientConfigProvider;
use Diplix\KMGBundle\PdfGeneration\OrderConfirmationPdf;
use Diplix\KMGBundle\Service\Notifier;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use GuzzleHttp;
use Symfony\Component\HttpKernel\Exception\AccessDeniedHttpException;
use Twig\Environment;
class IndexController extends BaseController
{
public function __construct(
protected ClientConfigProvider $ccp,
protected Environment $templating,
private readonly \Doctrine\Persistence\ManagerRegistry $managerRegistry
)
{
}
protected function tryRender($view, $params=[])
{
if ($this->templating->getLoader()->exists($view))
{
return $this->render($view,$params);
}
return new Response('Configuration incomplete. Unable to find '. $view);
}
protected function notInSync()
{
$or = $this->managerRegistry->getRepository(Order::class);
$notInSync = null;
if ($this->hasUserRole(Role::SUPER_ADMIN))
{
$notInSync = $or->findOpenNotInSyncWithTami();
}
return $notInSync;
}
protected function lastCronRun()
{
if (! ($this->hasUserRole(Role::SUPER_ADMIN) || ($this->hasUserRole(Role::DISPO)) ))
{
return null;
}
$lastRunFile = $this->getParameter('dx.temp_dir')."cron.lastrun";
if (!file_exists($lastRunFile))
{
return "(noch nie)";
}
$mt = filemtime( $lastRunFile);
if ( (date("U")-$mt) > 60*60*4)
{
return date("d.m.Y H:i",$mt);
}
return null;
}
protected function memberDashboad(Request $request)
{
return $this->tryRender( '@DiplixKMG/'. $this->getParameter('kmg.custom.pages.folder') .'/dashboard_member.html.twig' , [
"user" => $this->getCurrentUser(),
"notInSync" => $this->notInSync(),
"remoteStatusMap" => Order::$remoteStatusMap,
] );
}
protected function customerDashboard(Request $request)
{
$userRepo = $this->managerRegistry->getRepository(User::class);
$substList = $userRepo->findUsersISubstitute($this->getCurrentUser());
$rateList = [];
$c = $this->getCustomerContextFromSession();
if ( ($c !==null)&&($c->getShowRating()) )
{
$orderRepo = $this->managerRegistry->getRepository(Order::class);
$rateList = $orderRepo->findUnrated($c->getId(),null,7);
}
return $this->tryRender( '@DiplixKMG/'. $this->getParameter('kmg.custom.pages.folder') .'/dashboard.html.twig' , [
"user"=>$this->getCurrentUser(),
"substList"=>$substList,
"rateList"=>$rateList,
"remoteStatusMap" => Order::$remoteStatusMap,
"lastCronRun"=>$this->lastCronRun(),
"customerContext" => $this->getCustomerContextFromSession(),
"platformSetup"=>$this->ccp
] );
}
public function indexAction(Request $request)
{
/*
$loc = $request->getSession()->get('_locale', "nope");
$this->addFlash("info","session: " .$loc);
$this->addFlash("info","req: ".$request->getLocale());
*/
/*
if ($this->isGranted('IS_AUTHENTICATED_FULLY')) echo "FULLY";
if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED')) echo "REMEMBERED";
*/
if ($this->getCurrentUser()->getMember()!==null)
{
return $this->memberDashboad($request);
}
else
{
return $this->customerDashboard($request);
}
}
public function setupBrandingAction(Request $request,$slug)
{
$repo = $this->managerRegistry->getManager()->getRepository(Customer::class);
$customer = $repo->findOneBy(array("customSlug"=>$slug));
if (is_object($customer))
{
$sp = $this->getSessionParameters();
$sp->customTitle = $customer->getCustomTitle();
$this->saveSessionParameters();
$request->getSession()->set('_locale', $customer->getDefaultLocale());
}
return $this->redirectToRoute("sys-login");
}
protected $chkMap;
protected function fixItem( JobCalcItem $it)
{
if ($it->vat == 0.19)
{
$it->vat = 0.16;
$this->chkMap[]=[$it->name , $it->totalNet, 19, $it->vat];
}
else
if ($it->vat == 0.07)
{
$it->vat = 0.05;
$this->chkMap[]=[$it->name , $it->totalNet, 7, $it->vat];
}
}
protected function processItems($items)
{
/** @var JobCalcItem $it */
foreach ($items as $it)
{
$this->fixItem($it);
}
return $items;
}
protected function correctItemsForVat()
{
$repo = $this->managerRegistry->getRepository(Job::class);
$from = new \DateTime('2020-07-01 00:00:00');
$until = new \DateTime('2020-07-31 23:59:59');
$qb = $repo->createQueryBuilder('A');
$qb->andWhere('A.orderTime >= :from')
->setParameter('from', $from->format('Y-m-d H:i'));
$qb->andWhere('A.orderTime <= :until')
->setParameter('until',$until->format('Y-m-d H:i'));
$qb->addOrderBy('A.orderTime','DESC');
$jobs = $qb->getQuery()->getResult();
/** @var Job $job */
$jc = 0;
$changes = [];
$txt = '';
foreach ($jobs as $job)
{
$job->setMemberCalculationItems( $this->processItems($job->getMemberCalculationItems()) );
$job->setCustomerCalculationItems( $this->processItems($job->getCustomerCalculationItems()));
$changes[$job->getId()] = $this->chkMap;
$this->chkMap = [];
$txt.= sprintf('<h1>%s %s %s</h1>',$job->getId(),$job->getOrderTime()->format('d.m.Y'),$job->getOrderNumber());
$txt.= '<pre>'.print_r($changes[$job->getId()],true).'</pre>';
if (count( $changes[$job->getId()] ) > 0 ) $jc++;
}
//$repo->flush();
return new Response('<html><body>'.$txt.' '.(sprintf('Korrigierte Jobs: %d',$jc)).'</body></html>');
}
public function testAction(Request $request)
{
$this->ensureUserHasRole(Role::SUPER_ADMIN);
$tx = 'superkalifragelistigexpialigetisch';
$k1 = (AesTool::deriveKey('wurst'));
$k2 = (AesTool::deriveKey('wurst'));
echo $k1 . " ";
echo $k2 . " ";
$enc = AesTool::encrypt($tx,$k1);
$dec = AesTool::decrypt($enc,$k2);
echo $enc." ";
echo $dec." ";
echo ".... ";
$kek = AesTool::randomKey();
$wrapped = AesTool::wrapKey($k1,$kek);
$unwrapped = AesTool::unwrapKey($wrapped,$kek);
echo $k1 . " ";
echo $wrapped . " ";
echo $unwrapped." ";
return new Response("");
//
// $imap = $this->get('secit.imap')->get('kmg_dispo');
// try {
// $isConnectable = $this->get('secit.imap')->testConnection('kmg_dispo', true);
// $info = $imap->getMailboxInfo();
// var_dump($info);
// } catch (\Exception $exception) {
// echo $exception->getMessage();
// }
// return new Response('ok');
// $mn = $this->get('diplix.mobile.notifier');
// $order = $this->getDoctrine()->getManager()->find(Order::class,176);
// $member = $this->getDoctrine()->getManager()->find(CoopMember::class,2);
//
// echo "Order: ".$order->getId();
// echo "Member: ".$member->getId();
//
// $it = $mn->queue(DispatchQueueItem::create($order,$member,DispatchQueueItem::ACT_TAKE_OVER_ORDER));
// $mn->dispatchSingle($it);
// return new Response('ok');
//
//
//
//
// $fcmClient = $this->get('redjan_ym_fcm.client');
// $tokens= [
// //'cJOH-6zERkg:APA91bEb9IpuMxI3Ww3PObDIWtuNbE_KgJqU6kHGRvZW59o8OG08I08lIhn2voF9wylwY8iCWy52dmEH3Q0UU8cPz0F3i5PZeQMQxbz0roizG8sOgHa18sLFcceO79FJGcRLu_vavQSj'
// //'dPJUZXXeOL4:APA91bHAYrZsOe25tSxugiY3GntwOFUgUrjUrXC-nUotHP5dWgIxXgechitFn1yiPrOuFHm3fkgYEXSLf6tv2JFuh24z3CfwMrhrglRlBaYkwptmq4pgeFoMWXGNfVctih_TJhOl-dEw'
// 'c_STXPpzSsOX7tGYxMzrbL:APA91bHVP00ceDmZjUOKH08ZvV0kdLlOxVsuUV-ks35RW-3pyWZ_9FYyX7BTjP8fzu11PQsGg6bAtTIvFcqO7sLvXFTUMWrjrR2uSBirpZNY08W2OKIqRZOqBRFDpRDdS0JY5T7hfmdv'
// ];
//
//
//
// /*
// $notification = $fcmClient->createDeviceNotification(
// sprintf('Bestellung %s',"blahblubb"),
// 'Blah blubb blubber',
// $tokens
// );
// //$notification->setData([]);
// //$notification->setContentAvailable(true); // to silence the message
//*/
//
// $notification = $fcmClient->createDeviceNotification(
// null,null,
// $tokens
// );
// $notification->setData([
// 'click_action' => 'FLUTTER_NOTIFICATION_CLICK', // has to equal intent-filter in app
// 'code'=>Notifier::M_CONFIRMATION_REQUIRED,
// 'message'=> sprintf('Bestellung %s wurde geändert/aktualisiert.',1234556),
// 'data' => [ 'orderId'=> 164 ] ]);
// $notification->setContentAvailable(true); //
//
//
//
//
// $notification->setPriority('high');
//
//
//
//
//
// $resp = $fcmClient->sendNotification($notification);
//
// return new Response(print_r($resp,true));
/*
*
return $this->correctItemsForVat();
*/
/*
$tempPath = $this->getParameter("dx.temp_dir");
$order = $this->getDoctrine()->getManager()->getRepository("DiplixKMGBundle:Order")->findOneBy(array("id"=>60));
$pdf = new OrderConfirmationPdf();
$pdf->renderConfirmation($order);
$pdfFile = sprintf("confirm_%s_%s.pdf",$order->getOrderId(), date("Y-m-d_H_i_s"));
$pdf->Output($tempPath.$pdfFile);
return new Response($pdfFile);
*/
//
/* $xml = '<?xml version="1.0" encoding="utf-8" ?><ePay Result="2" TimeStamp="20180926161550" ClientTAID="0" ePayTAID="3533592" ><Display><Line>Zugriff verweigert.</Line><Line>Bitte 040 8900 5916 anrufen.</Line></Display><Print><Line>26.09.2018 16:15</Line><Line>Zugriff verweigert.</Line><Line>Bitte 040 8900 5916 anrufen.</Line><Line></Line><Line></Line></Print></ePay>';*/
// $root = simplexml_load_string($xml);
// $epa = $root->attributes(); // root element is the <ePay> element
// $display = "";
// foreach ( $root->{"Display"}->children() as $node)
// {
// $display .= $node->__toString() ."\n";
// }
// $print = "";
// foreach ( $root->{"Print"}->children() as $node)
// {
// $print .= $node->__toString() ."\n";
// }
//
// var_dump($display);
// var_dump($print);
//
// return new Response("");
//return $this->mapSpecialPriceList($request);
//return $this->testPdf($request);
// return $this->oneTimePriceListConversation($request);
// return $this->testGoogle($request);
}
public function switchCustomerAction(Request $request, $customerId)
{
// ensure the user is allowed to switch to the selected customer
$cid = ($this->getCurrentUser()->getCustomer()!==null ? $this->getCurrentUser()->getCustomer()->getId() : -1 );
if ($cid != $customerId)
{
if (!$this->hasUserRole(Role::GLOBAL_ORDER_ADMIN))
{
throw new AccessDeniedHttpException("You are not allowed to switch the customer context.");
}
}
$evRep = $this->managerRegistry->getManager()->getRepository(Customer::class);
$cust = $evRep->findOneBy(array("id"=>$customerId));
if (is_object($cust)) $this->managerRegistry->getManager()->detach($cust);
$this->getSessionParameters()->selectedCustomer = $cust;
$this->saveSessionParameters();
$ref = $request->headers->get("referer");
if ($request->get("referTo","")!="")
{
$ref = $request->get("referTo","");
}
return $this->redirect($ref);
}
}
//protected function oneTimePriceListConversation(Request $request)
// {
// die("disabled");
// $repo = $this->getDoctrine()->getRepository("DiplixKMGBundle:Customer");
// $all = $repo->findAll();
// $cnt = 0;
// /** @var Customer $row */
// foreach ($all as $row)
// {
// if (is_object($row->priceList))
// {
// if ($row->getPriceLists()->count() < 1 )
// {
// $row->getPriceLists()->add($row->priceList);
// $cnt++;
// }
// }
// }
// $this->getDoctrine()->getManager()->flush();
// return new Response(sprintf("%d Entries converted",$cnt));
// }
//
//protected function testPdf(Request $request)
//{
// $this->ensureUserHasRole(Role::SUPER_ADMIN);
// $tempPath = $this->getParameter("dx.temp_dir");
// $order = $this->getDoctrine()->getManager()->getRepository("DiplixKMGBundle:Order")->findOneBy(array("id"=>60));
// $pdf = new OrderConfirmationPdf();
// $pdf->renderConfirmation($order);
// $pdfFile = sprintf("confirm_%s_%s.pdf",$order->getOrderId(), date("Y-m-d_H_i_s"));
// $pdf->Output($tempPath.$pdfFile);
// return new Response($pdfFile);
//}
//
// protected function testGoogle(Request $request)
// {
// $client = new GuzzleHttp\Client();
// $url = "https://maps.googleapis.com/maps/api/distancematrix/json";
// $params = array(
// "key"=>$this->getParameter('google.maps.apikey'),
// "mode"=>"driving",
// "language"=>"de",
// "region"=>"de", // bias results to germany
// "units"=>"metric",
// "origins"=>"Lemaitrestr.14, Mannheim, Germany|Frankfurt",
// "destinations"=>"Frankfurt|Leharstr. 21, Bammental, Germany",
// );
//
// /*
// $url = "https://maps.googleapis.com/maps/api/directions/json";
// $params = array(
// "key"=>$this->getParameter('google.maps.apikey'),
// "mode"=>"driving",
// "language"=>"de",
// "region"=>"de", // bias results to germany
// "units"=>"metric",
// "origin"=>"Lemaitrestr.14, Mannheim, Germany",
// "via"=>"Frankfurt|Offenbach",
// "destination"=>"Leharstr. 21, Bammental, Germany",
// );
// */
// //print_r($params);
//
// $res = $client->get($url, array("query"=>$params, 'verify' => false)); // we do not care if the cert is valid or not
// $json = $res->getBody();
// $data = json_decode($json);
// $out = array( "status"=>$data->{"status"},
// "message"=> ( isset($data->{"error_message"}) ? $data->{"error_message"} : ""),
// );
// $out["source"] = $data;
//
// return $this->getJsonResponse($request,$out);
// }
//
// protected function mapSpecialPriceList(Request $request)
// {
// $in = "
//67308 ALBISHEIM 4
//67482 ALTDORF 4
//67317 ALTLEININGEN 4
//67122 ALTRIP 3
//67346 ANGELHOF I U. II 3
//67098 BAD DÜRKHEIM 3
//67271 BATTENBERG 4
//67259 BEINDERSHEIM 2
//67435 BENJENTAL 4
//64625 BENSHEIM 2
//67308 BIEDESHEIM 4
//67134 BIRKENHEIDE 3
//67281 BISSERSHEIM 3
//67273 BOBENHEIM am Berg 4
//67240 BOBENHEIM-ROXHEIM 2
//67482 BÖBINGEN 4
//67278 BOCKENHEIM 3
//67459 BÖHL-IGGELHEIM 4
//67281 BRUCHMÜHLE 3
//68782 BRÜHL 2
//67308 BUBENHEIM 4
//67316 CARLSBERG 4
//67273 DACKENHEIM 3
//67125 DANNSTADT-SCHAUERNHEIM 3
//67146 DEIDESHEIM 4
//67246 DIRMSTEIN 3
//69221 DOSSENHEIM 2
//67373 DUDENHOFEN 4
//67280 EBERTSHEIM 4
//67480 EDENKOBEN 4
//67483 EDESHEIM 4
//68535 EDINGEN/NECKARHAUSEN 2
//67308 EINSELTHUM 4
//67304 EISENBERG 4
//67158 ELLERSTADT 3
//69214 EPPELHEIM 2
//67167 ERPOLZHEIM 3
//67147 FORST 3
//67227 FRANKENTHAL 2
//67482 FREIMERSHEIM 4
//67251 FREINSHEIM 3
//67361 FREISBACH 4
//67159 FRIEDELSHEIM 3
//67136 FUßGÖNHEIM 2
//67229 GEROLSHEIM 3
//67377 GOMMERSHEIM 4
//67161 GÖNNHEIM 3
//67483 GROßFISCHLINGEN 4
//67229 GROßKARLBACH 3
//67259 GROßNIEDESHEIM 2
//67269 GRÜNSTADT 4
//67374 HANHOFEN 4
//67376 HARTHAUSEN 4
//67454 HAßLOCH 4
//68542 HEDDESHEIM 2
//69117 HEIDELBERG 3
//67273 HERXHEIM 3
//67258 HEßHEIM 2
//67310 HETTENLEIDELHEIM 4
//67259 HEUCHELHEIM 2
//69493 HIRSCHBERG 2
//67126 HOCHDORF-ASSENHEIM 3
//68766 HOCKENHEIM 4
//67591 HOHEN-SÜLZEN 3
//68549 ILVESHEIM 2
//67308 IMMESHEIM 3
//67316 JUNGHOF 3
//67169 KALLSTADT 3
//67304 KERZENHEIM 4
//68775 KETSCH 3
//67271 KINDENHEIM 4
//67281 KIRCHHEIM 3
//67489 KIRRWEILER 4
//67483 KLEINFISCHLINGEN 4
//67271 KLEINKARLBACH 4
//67308 KLEINMÜHLE 4
//67259 KLEINNIEDESHEIM 2
//68526 LADENBURG 2
//67245 LAMBSHEIM 2
//68623 LAMPERTHEIM 2
//67319 LAUBERHOF 4
//67229 LAUMERSHEIM 3
//67308 LAUTERSHEIM 4
//69181 LEIMEN 4
//67117 LIMBURGERHOF 2
//67098 LINDEMANNSRUHE 4
//67360 LINGENFELD 4
//67435 LOOGANLAGE 4
//67... LUDWIGSHAFEN 1
//67317 MAIHOF 4
//67487 MAIKAMMER 4
//68…. MANNHEIM 2
//67133 MAXDORF 2
//67149 MECKENHEIM 4
//67271 MERTESHEIM 4
//67591 MÖLSHEIM 3
//67590 MONSHEIM 3
//67591 MÖRSTADT 3
//67112 MUTTERSTADT 2
//69142 NECKARGEMÜND 4
//67316 NEUHOF 4
//67141 NEUHOFEN 2
//67271 NEULEININGEN 4
//67435 NEUSTADT an der Weinstraße 4
//67316 NEUWOOG 4
//67150 NIEDERKIRCHEN 3
//69226 NUSSLOCH 4
//67271 OBERSÜLZEN 4
//67283 OBRIGHEIM 4
//67591 OFFSTEIN 4
//68723 OFTERSHEIM 3
//67308 OTTERSHEIM 4
//67166 OTTERSTADT 3
//68723 PLANKSTADT 2
//67280 QUIRNHEIM 4
//69469 RITSCHWEIER 3
//67127 RÖDERSHEIM-GRONAU 3
//67354 RÖMERBERG 4
//67071 RUCHHEIM 2
//67152 RUPPERTSBERG 3
//67105 SCHIFFERSTADT 3
//69198 SCHRIESHEIM 2
//67365 SCHWEGENHEIM 4
//68723 SCHWETZINGEN 3
//64342 SEEHEIM-JUGENDHEIM 2
//67346 SPEYER 4
//67487 ST. MARTIN 4
//67311 TIEFENTHAL 4
//67482 VENNINGEN 4
//67157 WACHENHEIM a.d.Weinstr. 3
//67591 WACHENHEIM 4
//67165 WALDSEE 3
//67319 WATTENHEIM 4
//69469 WEINHEIM 2
//67366 WEINGARTEN 4
//67273 WEISENHEIM am Berg 4
//67256 WEISENHEIM am Sand 3
//67551 WORMS 3
//67308 ZELLERTAL 4
//
// ";
// $out = array();
// $ignored = array();
// foreach (explode("\n",$in) as $row)
// {
// $items = explode("\t",$row);
// if (count($items)>2)
// {
// $new = (object)array("zip"=>$items[0],"city"=>$items[1],"zone"=>$items[2]);
// $out[]=$new;
// }
// else
// {
// $ignored []= $row;
// }
// }
//
// return new Response(json_encode($out)."\n\n\n----\nIgnored:".print_r($ignored,true));
// }

src/Diplix/KMGBundle/Controller/IndexController.php line 108