Symfony Profiler

<?php
namespace App\Controller;
//use App\Config;
//use App\Controller\MongoClient;
//use App\Entity\Tune\AffiliateInfo;
//use App\Entity\AffiliateOfferBlock;
//use App\Entity\Alerts;
//use App\Entity\AppInfo;
//use App\Entity\AppsflyerWatcher;
//use App\Entity\Employees;
//use App\Entity\HoAffiliateMmpPartnerMapping;
//use App\Entity\HyperAffiliateData;
//use App\Entity\MmpAdvertisers;
//use App\Entity\MmpMobileApps;
//use App\Entity\MmpNotifications;
//use App\Entity\MmpPartnerRules;
//use App\Entity\MmpPartners;
//use App\Entity\MmpReports;
//use App\Entity\Tune\OfferInfo;
//use App\Entity\OfferTagRelationship;
//use App\Entity\PayoutControl;
//use App\Entity\PayoutControlAffiliateHyperData;
//use App\Entity\PayoutTotal;
//use App\Entity\RevenueControl;
//use App\Entity\RevenueControlAdvertiserHyperData;
//use App\Entity\RevenueTotal;
//use App\Entity\SkadNetworkPostbackLogs;
//use App\Entity\OfferScheduledChangesLogs;
//use App\Entity\UsersHierarchy;
use App\Config;
use App\Entity\Tune\AdvertiserInfo;
use App\Entity\Tune\AffiliateInfo;
use App\Entity\AffiliateRating;
use App\Entity\AppInfo;
use App\Entity\AppsflyerDatalocker;
use App\Entity\Employees;
use App\Entity\HyperClientInfo;
use App\Entity\MafoId\MafoAdvertisers;
use App\Entity\MafoId\MafoAdvertisersMapping;
use App\Entity\MafoId\MafoAffiliatesMapping;
use App\Entity\MmpFraudReports;
use App\Entity\MmpMobileApps;
use App\Entity\MmpReports;
use App\Entity\ObjectMappingWithTuneWebAccount;
use App\Entity\Tune\OfferInfo;
use App\Entity\OfferTagRelationship;
use App\Entity\RecommendationsByObject;
use App\Entity\Tag;
use App\Entity\UsersHierarchy;
use App\Entity\HoAffiliateMmpPartnerMapping;
use App\Entity\MafoId\MafoAffiliateMmpPartnerMapping;
use App\Services\AdjustAPI;
use App\Services\AffiliateHasofferAPI;
use App\Services\Alerts;
use App\Services\AppsflyerAPI;
use App\Services\Aws\ElasticCache;
use App\Services\Aws\S3;
use App\Services\BrandHasofferAPI;
use App\Services\Common;
use App\Services\FinancialToolsComponents;
use App\Services\HyperApis;
use App\Services\ImpressionsApis;
use App\Services\Integrations\CjAPI;
use App\Services\Mailer;
use App\Services\Metrics24APICalls;
use App\Services\MmpComponents;
use App\Services\MysqlQueries;
use App\Services\Scraper;
use App\Services\UsersComponents;
use Doctrine\Persistence\ManagerRegistry;
use Exception;
use Mmoreram\GearmanBundle\Service\GearmanClientInterface;
use MongoClient;
use MongoDB\Client as Mongo;
use Ramsey\Uuid\Uuid;
use Symfony\Component\HttpKernel\KernelInterface;
use Symfony\Component\Mailer\Exception\TransportExceptionInterface;
use Symfony\Component\Mailer\Header\MetadataHeader;
use Symfony\Component\Mailer\MailerInterface;
use Symfony\Component\Mercure\Authorization;
use Symfony\Component\Mercure\Discovery;
use Symfony\Component\Mercure\HubInterface;
use Symfony\Component\Mercure\Update;
use Symfony\Component\Mime\Email;
use Symfony\Component\Mime\Part\DataPart;
use Symfony\Component\Mime\Part\File;
use Symfony\Component\Routing\Annotation\Route;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Symfony\Component\HttpFoundation\JsonResponse;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\Security\Http\Authentication\AuthenticationUtils;
use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
use App\Services\NewAdjustAPI;
use Symfony\Contracts\HttpClient\HttpClientInterface;
use Twig\Environment;
//use Ramsey\Uuid\Uuid;
class DefaultController extends AbstractController
{
private $commonCalls;
private $doctrine;
private $brandHasofferApi;
private $tuneApi;
private $projectDir;
private $mmpComponents;
private $financialToolsComponents;
private $gearmanClientInterface;
private $alerts;
private $rootPath;
private $afApi;
private $s3;
private AdjustAPI $adjustApi;
private $showLoginForm;
public function __construct(GearmanClientInterface $gearmanClientInterface, Common $commonCalls, ManagerRegistry $doctrine, BrandHasofferApi $brandHasofferApi, string $projectDir, MmpComponents $mmpComponents, Alerts $alerts, ParameterBagInterface $params, AppsflyerAPI $afApi, AdjustAPI $adjustApi, FinancialToolsComponents $financialToolsComponents, S3 $s3)
{
$this->commonCalls = $commonCalls;
$this->doctrine = $doctrine;
$this->brandHasofferApi = $brandHasofferApi;
$this->tuneApi = $brandHasofferApi;
$this->projectDir = $projectDir;
$this->mmpComponents = $mmpComponents;
$this->financialToolsComponents = $financialToolsComponents;
$this->gearmanClientInterface = $gearmanClientInterface;
$this->alerts = $alerts;
$this->rootPath = $params->get('kernel.project_dir');
$this->afApi = $afApi;
$this->s3 = $s3;
$this->adjustApi = $adjustApi;
}
// /**
// * @Route("/", name="agent_homepage", host="%agents_subdomain%")
// */
// public function indexAgentAction(Request $request)
// {
// return $this->render('base_agent.html.twig', [
// 'template' => '/templates/dashboard.html.twig',
// ]);
// }
/**
* @Route("/", name="mafo_publisher_homepage", host="%publishers_subdomain%")
*/
public function indexPublisherAction(Request $request)
{
return $this->render('base_mafo_publisher_cabinet.html.twig', [
'template' => '/base_mafo_publisher_cabinet.html.twig',
]);
}
/**
* @Route("/", name="mafo_advertiser_homepage", host="%advertisers_subdomain%")
*/
public function indexAdvertiserAction(Request $request)
{
return $this->render('base_mafo_advertiser_cabinet.html.twig', [
'template' => '/base_mafo_advertiser_cabinet.html.twig',
]);
}
/**
* @Route("/", name="homepage", host="%main_subdomain%")
*/
public function indexAction(Request $request)
{
return $this->render('base.html.twig', [
'template' => '/templates/dashboard.html.twig',
]);
}
/**
* @Route("/login", name="mafo_form_login", host="%main_subdomain%")
*/
public function mafoFormLoginAction(AuthenticationUtils $authenticationUtils, Request $request)
{
// $authenticationUtils = $authenticationUtils->get('security.authentication_utils');
// get the login error if there is one
$error = $authenticationUtils->getLastAuthenticationError();
// last username entered by the user
$lastUsername = $authenticationUtils->getLastUsername();
return $this->render('/form_login.html.twig', [
'last_username' => $lastUsername,
'error' => $error,
'errorFromParam' => $request->query->get('error'),
'show_login_form' => $_ENV['APP_ENV'] === 'dev'
]);
}
/**
* @Route("/test", name="test_", host="%main_subdomain%")
* @throws TransportExceptionInterface
*/
public function testAction(Request $request, HyperApis $hyper)
{
$temp = <<<EOT
[{"id":1096,"advertiserId":781,"advertiserName":"\u041e\u041e\u041e \u041c\u0435\u0434\u0438\u0430\u043d\u0430 \u0411\u0438 \u042d\u0439\u0447 Okkam","systemIdentifiers":"tune_mobile:6695","hyperStatus":"Hyper Error: Order Items not found.","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":0,"toBeApprovedRevenue":0,"totalApprovedRevenue":0,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":0,"totalApprovedCost":0,"totalProfit":0,"totalApprovedProfit":0,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":0,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"December"},"monthYear":"2025-12","month":"December","year":"2025","periodPretty":"2025 December","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":null,"mafoCalculatedCost":null,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":1095,"advertiserId":584,"advertiserName":"Median BH Okkam_AVito_Travel CTV","systemIdentifiers":"tune_mobile:7084","hyperStatus":"Hyper Error: Order Items not found.","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":0,"toBeApprovedRevenue":0,"totalApprovedRevenue":0,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":0,"totalApprovedCost":0,"totalProfit":0,"totalApprovedProfit":0,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":0,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"December"},"monthYear":"2025-12","month":"December","year":"2025","periodPretty":"2025 December","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":null,"mafoCalculatedCost":null,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":1094,"advertiserId":707,"advertiserName":"Lamoda Zorka","systemIdentifiers":"tune_mobile:7590|tune_mobile:7565","hyperStatus":"Hyper Error: Order Items not found.","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":0,"toBeApprovedRevenue":0,"totalApprovedRevenue":0,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":0,"totalApprovedCost":0,"totalProfit":0,"totalApprovedProfit":0,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":0,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"December"},"monthYear":"2025-12","month":"December","year":"2025","periodPretty":"2025 December","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":null,"mafoCalculatedCost":null,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":1093,"advertiserId":587,"advertiserName":"Secret Kitchen","systemIdentifiers":"tune_mobile:7461","hyperStatus":"Hyper Error: Wrong Client IO","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":0,"toBeApprovedRevenue":0,"totalApprovedRevenue":0,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":0,"totalApprovedCost":0,"totalProfit":0,"totalApprovedProfit":0,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":0,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"December"},"monthYear":"2025-12","month":"December","year":"2025","periodPretty":"2025 December","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":null,"mafoCalculatedCost":null,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":1092,"advertiserId":130,"advertiserName":"Banki.ru\/ \u041e\u041e\u041e \u0418\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u043e\u0435 \u0430\u0433\u0435\u043d\u0442\u0441\u0442\u0432\u043e \"\u0411\u0430\u043d\u043a\u0438.\u0440\u0443","systemIdentifiers":"tune_mobile:5072","hyperStatus":"Hyper Error: Order Items not found.","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":0,"toBeApprovedRevenue":0,"totalApprovedRevenue":0,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":0,"totalApprovedCost":0,"totalProfit":0,"totalApprovedProfit":0,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":0,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"December"},"monthYear":"2025-12","month":"December","year":"2025","periodPretty":"2025 December","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":471,"mafoCalculatedCost":307,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":1091,"advertiserId":121,"advertiserName":"\u041e\u041e\u041e \"\u0412\u041f.\u0420\u0423 Mig\u0441redit","systemIdentifiers":"tune_mobile:7588","hyperStatus":"Hyper Error: Order Items not found.","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":0,"toBeApprovedRevenue":0,"totalApprovedRevenue":0,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":0,"totalApprovedCost":0,"totalProfit":0,"totalApprovedProfit":0,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":0,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"December"},"monthYear":"2025-12","month":"December","year":"2025","periodPretty":"2025 December","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":993,"mafoCalculatedCost":496.5,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":1090,"advertiserId":739,"advertiserName":"MJCom","systemIdentifiers":"tune_mobile:7583|tune_mobile:7483|tune_mobile:7589|tune_mobile:7591","hyperStatus":"Hyper Error: Order Items not found.","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":0,"toBeApprovedRevenue":0,"totalApprovedRevenue":0,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":0,"totalApprovedCost":0,"totalProfit":0,"totalApprovedProfit":0,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":0,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"December"},"monthYear":"2025-12","month":"December","year":"2025","periodPretty":"2025 December","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":1760,"mafoCalculatedCost":880,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":1089,"advertiserId":583,"advertiserName":"Zaimer ","systemIdentifiers":"tune_mobile:4258","hyperStatus":"Hyper Error: Order Items not found.","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":0,"toBeApprovedRevenue":0,"totalApprovedRevenue":0,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":0,"totalApprovedCost":0,"totalProfit":0,"totalApprovedProfit":0,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":0,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"December"},"monthYear":"2025-12","month":"December","year":"2025","periodPretty":"2025 December","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":54,"mafoCalculatedCost":54,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":1088,"advertiserId":645,"advertiserName":"MTS - KION 40 % CTV ","systemIdentifiers":"tune_mobile:5726","hyperStatus":"Hyper Error: Wrong Client IO","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":0,"toBeApprovedRevenue":0,"totalApprovedRevenue":0,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":0,"totalApprovedCost":0,"totalProfit":0,"totalApprovedProfit":0,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":0,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"December"},"monthYear":"2025-12","month":"December","year":"2025","periodPretty":"2025 December","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":6271.02,"mafoCalculatedCost":3377.4,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":859,"advertiserId":666,"advertiserName":"EvaMobi \/\/ Baltbet \/\/ in-app","systemIdentifiers":"tune_mobile:7554","hyperStatus":"Hyper Error: Wrong Client IO","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":180,"toBeApprovedRevenue":180,"totalApprovedRevenue":180,"overrideRevenue":1,"overriddenRevenue":180,"overrideCost":null,"overriddenCost":null,"totalCost":140,"totalApprovedCost":140,"totalProfit":40,"totalApprovedProfit":40,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":22.22,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":"W","period":{"year":"2025","month":"November"},"monthYear":"2025-11","month":"November","year":"2025","periodPretty":"2025 November","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":null,"mafoCalculatedCost":null,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":850,"advertiserId":586,"advertiserName":"Gradient","systemIdentifiers":"tune_mobile:7553|tune_mobile:7530|tune_mobile:7529|tune_mobile:7528|tune_mobile:7446","hyperStatus":"Hyper Error: Order Items not found.","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":388.85,"toBeApprovedRevenue":388.85,"totalApprovedRevenue":388.85,"overrideRevenue":1,"overriddenRevenue":388.85,"overrideCost":null,"overriddenCost":null,"totalCost":102,"totalApprovedCost":102,"totalProfit":286.85,"totalApprovedProfit":286.85,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":73.77,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":"388.85","period":{"year":"2025","month":"November"},"monthYear":"2025-11","month":"November","year":"2025","periodPretty":"2025 November","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":null,"mafoCalculatedCost":null,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":849,"advertiserId":781,"advertiserName":"\u041e\u041e\u041e \u041c\u0435\u0434\u0438\u0430\u043d\u0430 \u0411\u0438 \u042d\u0439\u0447 Okkam","systemIdentifiers":"tune_mobile:6695","hyperStatus":"Hyper Error: Order Items not found.","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":2688.82,"toBeApprovedRevenue":2688.82,"totalApprovedRevenue":2688.82,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":600,"totalApprovedCost":600,"totalProfit":2088.82,"totalApprovedProfit":2088.82,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":77.69,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"November"},"monthYear":"2025-11","month":"November","year":"2025","periodPretty":"2025 November","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":null,"mafoCalculatedCost":null,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":838,"advertiserId":707,"advertiserName":"Lamoda Zorka","systemIdentifiers":"tune_mobile:7590|tune_mobile:7565","hyperStatus":"Hyper Error: Order Items not found.","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":6093.3,"toBeApprovedRevenue":6093.3,"totalApprovedRevenue":6093.3,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":3808,"totalApprovedCost":3808,"totalProfit":2285.3,"totalApprovedProfit":2285.3,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":37.51,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"November"},"monthYear":"2025-11","month":"November","year":"2025","periodPretty":"2025 November","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":null,"mafoCalculatedCost":null,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":837,"advertiserId":121,"advertiserName":"\u041e\u041e\u041e \"\u0412\u041f.\u0420\u0423 Mig\u0441redit","systemIdentifiers":"tune_mobile:7588","hyperStatus":"Hyper Error: Order Items not found.","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":637.11,"toBeApprovedRevenue":637.11,"totalApprovedRevenue":637.11,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":298.5,"totalApprovedCost":298.5,"totalProfit":338.61,"totalApprovedProfit":338.61,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":53.15,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"November"},"monthYear":"2025-11","month":"November","year":"2025","periodPretty":"2025 November","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":1233,"mafoCalculatedCost":616.5,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":836,"advertiserId":739,"advertiserName":"MJCom","systemIdentifiers":"tune_mobile:7591|tune_mobile:7589|tune_mobile:7583|tune_mobile:7483","hyperStatus":"Hyper Error: Order Items not found.","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":680.69,"toBeApprovedRevenue":680.69,"totalApprovedRevenue":680.69,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":448,"totalApprovedCost":448,"totalProfit":232.69,"totalApprovedProfit":232.69,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":34.18,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"November"},"monthYear":"2025-11","month":"November","year":"2025","periodPretty":"2025 November","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":825,"mafoCalculatedCost":460,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":835,"advertiserId":584,"advertiserName":"Median BH Okkam_AVito_Travel CTV","systemIdentifiers":"tune_mobile:7084","hyperStatus":"Hyper Error: Order Items not found.","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":2613.55,"toBeApprovedRevenue":2613.55,"totalApprovedRevenue":2613.55,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":1512,"totalApprovedCost":1512,"totalProfit":1101.55,"totalApprovedProfit":1101.55,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":42.15,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"November"},"monthYear":"2025-11","month":"November","year":"2025","periodPretty":"2025 November","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":null,"mafoCalculatedCost":null,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":535,"advertiserId":739,"advertiserName":"MJCom","systemIdentifiers":"tune_mobile:7589|tune_mobile:7483|tune_mobile:7583|tune_mobile:7591","hyperStatus":"Hyper Error: Order Items not found.","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":984.13,"toBeApprovedRevenue":984.13,"totalApprovedRevenue":984.13,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":549,"totalApprovedCost":549,"totalProfit":435.13,"totalApprovedProfit":435.13,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":44.21,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"October"},"monthYear":"2025-10","month":"October","year":"2025","periodPretty":"2025 October","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":null,"mafoCalculatedCost":null,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":521,"advertiserId":587,"advertiserName":"Secret Kitchen","systemIdentifiers":"tune_mobile:7461","hyperStatus":"Hyper Error: Wrong Client IO","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":0,"toBeApprovedRevenue":0,"totalApprovedRevenue":0,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":0,"totalApprovedCost":0,"totalProfit":0,"totalApprovedProfit":0,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":0,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"October"},"monthYear":"2025-10","month":"October","year":"2025","periodPretty":"2025 October","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":null,"mafoCalculatedCost":null,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":520,"advertiserId":645,"advertiserName":"MTS - KION 40 % CTV ","systemIdentifiers":"tune_mobile:5726","hyperStatus":"Hyper Error: Wrong Client IO","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":0,"toBeApprovedRevenue":0,"totalApprovedRevenue":0,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":0,"totalApprovedCost":0,"totalProfit":0,"totalApprovedProfit":0,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":0,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"October"},"monthYear":"2025-10","month":"October","year":"2025","periodPretty":"2025 October","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":19203,"mafoCalculatedCost":12679,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":519,"advertiserId":130,"advertiserName":"Banki.ru\/ \u041e\u041e\u041e \u0418\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u043e\u0435 \u0430\u0433\u0435\u043d\u0442\u0441\u0442\u0432\u043e \"\u0411\u0430\u043d\u043a\u0438.\u0440\u0443","systemIdentifiers":"tune_mobile:5072","hyperStatus":"Hyper Error: Order Items not found.","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":0,"toBeApprovedRevenue":0,"totalApprovedRevenue":0,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":0,"totalApprovedCost":0,"totalProfit":0,"totalApprovedProfit":0,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":0,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"October"},"monthYear":"2025-10","month":"October","year":"2025","periodPretty":"2025 October","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":584,"mafoCalculatedCost":414,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":518,"advertiserId":583,"advertiserName":"Zaimer ","systemIdentifiers":"tune_mobile:4258","hyperStatus":"Hyper Error: Order Items not found.","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":0,"toBeApprovedRevenue":0,"totalApprovedRevenue":0,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":0,"totalApprovedCost":0,"totalProfit":0,"totalApprovedProfit":0,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":0,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"October"},"monthYear":"2025-10","month":"October","year":"2025","periodPretty":"2025 October","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":8,"mafoCalculatedCost":8,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":514,"advertiserId":587,"advertiserName":"Secret Kitchen","systemIdentifiers":"tune_mobile:7461","hyperStatus":"Hyper Error: Wrong Client IO","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":482.26,"toBeApprovedRevenue":482.26,"totalApprovedRevenue":482.26,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":279,"totalApprovedCost":279,"totalProfit":203.26,"totalApprovedProfit":203.26,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":42.15,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"November"},"monthYear":"2025-11","month":"November","year":"2025","periodPretty":"2025 November","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":null,"mafoCalculatedCost":null,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":513,"advertiserId":645,"advertiserName":"MTS - KION 40 % CTV ","systemIdentifiers":"tune_mobile:5726","hyperStatus":"Hyper Error: Wrong Client IO","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":6611.57,"toBeApprovedRevenue":6611.57,"totalApprovedRevenue":6611.57,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":3860.5,"totalApprovedCost":3860.5,"totalProfit":2751.07,"totalApprovedProfit":2751.07,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":41.61,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"November"},"monthYear":"2025-11","month":"November","year":"2025","periodPretty":"2025 November","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":3259.2,"mafoCalculatedCost":2019.4,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":512,"advertiserId":130,"advertiserName":"Banki.ru\/ \u041e\u041e\u041e \u0418\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u043e\u0435 \u0430\u0433\u0435\u043d\u0442\u0441\u0442\u0432\u043e \"\u0411\u0430\u043d\u043a\u0438.\u0440\u0443","systemIdentifiers":"tune_mobile:5072","hyperStatus":"Hyper Error: Order Items not found.","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":2202.85,"toBeApprovedRevenue":2202.85,"totalApprovedRevenue":2202.85,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":708,"totalApprovedCost":708,"totalProfit":1494.85,"totalApprovedProfit":1494.85,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":67.86,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"November"},"monthYear":"2025-11","month":"November","year":"2025","periodPretty":"2025 November","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":1348,"mafoCalculatedCost":900,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true},{"id":511,"advertiserId":583,"advertiserName":"Zaimer ","systemIdentifiers":"tune_mobile:4258","hyperStatus":"Hyper Error: Order Items not found.","billingStatusId":1,"billingStatus":"Approved For Billing","billingStatusPretty":"Approved For Billing","advertiserDiscountType":"no_discount","advertiserDiscountValue":null,"totalRevenue":2494.28,"toBeApprovedRevenue":2494.28,"totalApprovedRevenue":2494.28,"overrideRevenue":null,"overriddenRevenue":null,"overrideCost":null,"overriddenCost":null,"totalCost":1710,"totalApprovedCost":1710,"totalProfit":784.28,"totalApprovedProfit":784.28,"totalDeduction":0,"approvedDeductionFromDeductionControl":null,"totalDeductionFromDeductionControl":null,"totalApprovedDeduction":0,"overriddenDeduction":null,"overrideDeduction":null,"totalApprovedProfitPercentage":31.44,"advertiserManagerEmail":"maksim@mobupps.com","advertiserManagerName":"Maksim Nalivaiko","requiresBillingStatusUpdate":false,"revisionComment":null,"period":{"year":"2025","month":"November"},"monthYear":"2025-11","month":"November","year":"2025","periodPretty":"2025 November","fileKey":null,"linkToFile":null,"approvedByEmail":"bella@mobupps.com","approvedByName":"Bella Katsir","setBillingStatusEnabled":true,"mafoCalculatedRevenue":15,"mafoCalculatedCost":15,"comments":[],"advertiserManagerTeamName":"Russia Team","addedByEmail":null,"addedByName":null,"canEdit":true,"billingStatusButtonTooltip":"Set Billing Status","canEditEditForm":true}]
EOT;
$sum = 0;
$data = json_decode($temp, true);
foreach ($data as $key => $value) {
if ($value['month'] === 'November') {
$sum += $value['totalRevenue'];
}
}
echo $sum;
die;
echo $temp;
die;
// echo json_decode($temp, true);
die;
// $this->mafoFinancialToolsComponents->updateAdvertiserHyperData();
die;
}
private function migrateMmpMobileAppsAdvertiserId()
{
$mmpMobileApps = $this->doctrine->getRepository(MmpMobileApps::class)->getMmpMobileAppsForAdvertiserMigration();
foreach ($mmpMobileApps as $mmpMobileApp) {
if ($mmpMobileApp['advertiserId']) {
$checkMafoAdvertiserMappingExists = $this->doctrine->getRepository(MafoAdvertisersMapping::class)->findOneBy([
'systemIdentifier' => Config::MAFO_SYSTEM_IDENTIFIER_TUNE_MOBILE,
'systemIdentifierId' => $mmpMobileApp['advertiserId']
]);
if ($checkMafoAdvertiserMappingExists) {
$this->doctrine->getRepository(MmpMobileApps::class)->updateMmpMobileAppsById($mmpMobileApp['id'], [
'mafoAdvertiserId' => $checkMafoAdvertiserMappingExists->getMafoAdvertiserId()->getId()
]);
}
}
}
}
private function processCohortCsv()
{
ini_set('memory_limit', '256M');
$fileDirectory = $this->rootPath . '/public/temp';
$files = scandir($fileDirectory);
foreach ($files as $file) {
if (!$this->commonCalls->checkForString($file, 'cohort')) {
continue;
}
$filePath = $fileDirectory . '/' . $file;
// $fileData = file_get_contents($filePath);
$file = fopen($filePath, 'r');
$data = [];
while (($line = fgetcsv($file)) !== FALSE) {
//$line is an array of the csv elements
$data[] = $line;
if (sizeof($data) > 100) {
break;
}
}
fclose($file);
$dataHeaders = $data[0];
unset($data[0]);
echo json_encode($data);
die;
}
}
/**
* @Route("/advertiser-list", name="advertiser_list", host="%main_subdomain%")
*/
public
function getAdvertiserListAction(Request $request)
{
$advertiserData = $this->commonCalls->getAdvertisersListByStatusWithKeys();
$response = [];
foreach ($advertiserData as $key => $value) {
$response[$value['id']] = [
'value' => $value['id'],
'label' => $value['id'] . ' - ' . $value['name']
];
}
ksort($response);
header('Access-Control-Allow-Origin: *');
return new JsonResponse(array_values($response));
}
/**
* @Route("/affiliate-list", name="affiliate_list", host="%main_subdomain%")
*/
public
function getAffiliateListAction(Request $request)
{
$advertiserData = $this->commonCalls->getAffiliateListByStatusWithKeys();
$response = [];
foreach ($advertiserData as $key => $value) {
$response[$value['id']] = [
'value' => $value['id'],
'label' => $value['id'] . ' - ' . $value['name']
];
}
ksort($response);
header('Access-Control-Allow-Origin: *');
return new JsonResponse(array_values($response));
}
/**
* @Route("/oauth", name="oauth", host="%main_subdomain%")
*/
public
function oauthAction()
{
return new JsonResponse(true);
}
/**
* @Route("/appsflyer/skadnetwork", name="appsflyer_skadnetwork", host="%main_subdomain%")
*/
public
function appsflyerSkadnetworkAction(Request $request)
{
if ($_SERVER['REQUEST_METHOD'] === Config::HTTP_METHOD_POST) {
$payload = json_decode($request->getContent(), true);
} else if ($_SERVER['REQUEST_METHOD'] === Config::HTTP_METHOD_GET) {
$payload['transaction-id'] = $request->query->get('transaction-id');
}
if (isset($payload['transaction-id'])) {
$data = $this->doctrine->getRepository(SkadNetworkPostbackLogs::class)->findOneBy([
'transactionId' => $payload['transaction-id']
]);
if ($data) {
$this->doctrine->getRepository(SkadNetworkPostbackLogs::class)->updateSkadNetworkPostbackLogs($data->getId(), [
'isPostbackAcknowledgedFromAppsflyer' => true
]);
}
}
return new JsonResponse(true);
}
/**
* Serve the SPA for any front-end route so React Router can handle it client-side
* This should be placed LAST in your routing to act as a catch-all
*
* @Route("/{reactRouting}", name="spa_catch_all", requirements={"reactRouting"="^(?!api|!admin|_wdt|_profiler).*"}, methods={"GET"}, priority=-1, host="%main_subdomain%")
*/
public function spaCatchAll(): Response
{
if (!$this->getUser()) {
return $this->redirectToRoute('mafo_form_login');
}
return $this->render('base.html.twig', [
'template' => '/templates/dashboard.html.twig',
]);
}
/**
* Serve the SPA for any front-end route so React Router can handle it client-side
* This should be placed LAST in your routing to act as a catch-al
*
* @Route("/{reactRouting}", name="spa_catch_all_advertiser", requirements={"reactRouting"="^(?!api|!admin|_wdt|_profiler).*"}, methods={"GET"}, priority=-1, host="%advertisers_subdomain%")
*/
public function spaCatchAllAdvertiser(): Response
{
if (!$this->getUser()) {
return $this->redirectToRoute('client_advertiser_login');
}
return $this->render('base_mafo_advertiser_cabinet.html.twig', [
'template' => '/base_mafo_advertiser_cabinet.html.twig',
]);
}
/**
* Serve the SPA for any front-end route so React Router can handle it client-side
* This should be placed LAST in your routing to act as a catch-al
*
* @Route("/{reactRouting}", name="spa_catch_all_publisher_cabinet", requirements={"reactRouting"="^(?!api|!admin|_wdt|_profiler).*"}, methods={"GET"}, priority=-1, host="%publishers_subdomain%")
*/
public function spaCatchAllPublisherCabinet(): Response
{
if (!$this->getUser()) {
return $this->redirectToRoute('client_publisher_login');
}
return $this->render('base_mafo_publisher_cabinet.html.twig', [
'template' => '/base_mafo_publisher_cabinet.html.twig'
]);
}
}

src/Controller/DefaultController.php line 172