src/Controller/UtilitiesController.php line 2053

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Config;
  6. use App\Entity\Tune\AdvertiserAccountManager;
  7. use App\Entity\Tune\AffiliateAccountManager;
  8. use App\Entity\Tune\AffiliateInfo;
  9. use App\Entity\AffiliateTags;
  10. use App\Entity\AlertLogs;
  11. use App\Entity\MafoId\MafoAdvertisers;
  12. use App\Entity\MafoId\MafoAffiliates;
  13. use App\Entity\MafoId\MafoOffers;
  14. use App\Entity\PublisherCabinet\MafoPublisherCabinetManager;
  15. use App\Entity\SavedReport;
  16. use App\Entity\RecommendationsByObject;
  17. use App\Services\AffiliateHasofferAPI;
  18. use App\Services\Alerts;
  19. use App\Entity\MmpOffers;
  20. use App\Entity\MmpReports;
  21. use App\Entity\Tune\OfferInfo;
  22. use App\Entity\AppInfo;
  23. use App\Entity\Tune\AdvertiserInfo;
  24. use App\Entity\MafoId\MafoAffiliateMmpPartnerMapping;
  25. use App\Entity\MafoId\MafoOffersMapping;
  26. use App\Entity\SkadNetworkPostbackLogs;
  27. use App\Entity\SourceTags;
  28. use App\Entity\Tag;
  29. use App\Entity\Users;
  30. use App\Entity\UsersHierarchy;
  31. use App\Services\Aws\ElasticCache;
  32. use App\Services\Aws\S3;
  33. use App\Services\BrandHasofferAPI;
  34. use App\Services\Common;
  35. use App\Services\FinancialToolsComponents;
  36. use App\Services\HyperApis;
  37. use App\Services\ImpressionsApis;
  38. use App\Services\MachineLearning;
  39. use App\Services\Metrics24APICalls;
  40. use App\Services\MmpComponents;
  41. use App\Services\MysqlQueries;
  42. use App\Services\UsersComponents;
  43. use Doctrine\ODM\MongoDB\DocumentManager;
  44. use Doctrine\Persistence\ManagerRegistry;
  45. use Mmoreram\GearmanBundle\Service\GearmanClientInterface;
  46. use PhpOffice\PhpSpreadsheet\IOFactory;
  47. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  48. use Symfony\Component\Routing\Annotation\Route;
  49. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  50. use Symfony\Component\HttpFoundation\JsonResponse;
  51. use Symfony\Component\HttpFoundation\Request;
  53. use Symfony\Component\HttpFoundation\Response;
  54. use Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorageInterface;
  55. use Symfony\Component\Security\Core\Authentication\Token\SwitchUserToken;
  56. use Symfony\Component\Security\Core\Security;
  58. /**
  59. *
  60. * Utilities and common routes which are used throughout the project with endpoint /api/utilities/{route}
  61. *
  62. * @Route("/api/utilities", name="aff", host="%main_subdomain%")
  63. */
  64. class UtilitiesController extends AbstractController
  65. {
  67. private $commonCalls;
  68. private $doctrine;
  69. private $usersComponents;
  70. private $s3;
  71. private $mongoDbDoctrine;
  72. private $security;
  73. private $machineLearning;
  74. private HyperApis $hyperApis;
  76. public function __construct(Common $commonCalls, ManagerRegistry $doctrine, UsersComponents $usersComponents, S3 $s3, DocumentManager $mongoDbDoctrine, Security $security, MachineLearning $machineLearning, HyperApis $hyperApis)
  77. {
  78. $this->commonCalls = $commonCalls;
  79. $this->doctrine = $doctrine;
  80. $this->usersComponents = $usersComponents;
  81. $this->s3 = $s3;
  82. $this->mongoDbDoctrine = $mongoDbDoctrine;
  83. $this->machineLearning = $machineLearning;
  84. $this->security = $security;
  85. $this->hyperApis = $hyperApis;
  86. }
  88. /**
  89. * @Route("/aff-offer-cap-type", name="affiliate_offer_cap_type", methods={"GET"})
  90. */
  91. public function getAffiliateOfferCapTypeAction(Request $request)
  92. {
  94. $affOfferCapType = [];
  96. foreach (Config::AFFILIATE_OFFER_CAP_TYPE as $key => $value) {
  97. $affOfferCapType[] = [
  98. 'value' => $value,
  99. 'label' => ucwords(str_replace("_", " ", $value))
  100. ];
  101. }
  103. return new JsonResponse($affOfferCapType);
  104. }
  106. /**
  107. * @Route("/adv-managers", name="get_adv_managers", methods={"GET"})
  108. */
  109. public function getAdvertiserManagersAction(Request $request)
  110. {
  112. $tuneAccount = $request->query->get('tuneAccount');
  114. $advertiserManagers = [];
  117. $data = $this->doctrine->getRepository(AdvertiserAccountManager::class)->getAccountManagerData($tuneAccount !== null ? $tuneAccount : null);
  119. foreach ($data as $key => $value) {
  120. $advertiserManagers[$value['employeeId']] = [
  121. 'value' => $value['employeeId'],
  122. 'label' => $value['firstName'] . ' ' . $value['lastName']
  123. ];
  124. }
  126. return new JsonResponse(array_values($advertiserManagers));
  127. }
  129. /**
  130. * @Route("/aff-managers", name="get_aff_managers", methods={"GET"})
  131. */
  132. public function getAffiliateManagersAction(Request $request)
  133. {
  135. $affiliateManagers = [];
  137. $dataAffiliateAccountManagers = $this->doctrine->getRepository(AffiliateAccountManager::class)->getAffiliateAccountManagerData();
  139. $data = [];
  140. foreach ($dataAffiliateAccountManagers as $key => $value) {
  142. $tuneAccount = Config::MAFO_SYSTEM_IDENTIFIER_PRETTY[$value['tuneAccount']] ?? "";
  144. $data[$tuneAccount]['label'] = strtoupper($tuneAccount) . ' ACCOUNT MANAGERS';
  145. $data[$tuneAccount]['options'][$value['employeeId']] = [
  146. 'value' => $value['employeeId'],
  147. 'label' => $value['firstName'] . ' ' . $value['lastName'],
  148. 'tuneAccount' => $tuneAccount,
  149. 'tuneAccountRaw' => $value['tuneAccount'],
  150. 'color' => Config::MAFO_SYSTEM_IDENTIFIER_TUNE_ACCOUNTS_COLORS[$tuneAccount] ?? "#000"
  151. ];
  152. ksort($data[$tuneAccount]['options']);
  153. }
  156. $finalArr = [];
  158. foreach ($data as $key => $value) {
  159. $finalArr[] = [
  160. 'label' => $value['label'],
  161. 'options' => array_values($value['options']),
  162. ];
  163. }
  164. return new JsonResponse(array_values($finalArr));
  165. }
  167. /**
  168. * @Route("/source-tags-list", name="get_source_tags_list", methods={"GET"})
  169. */
  170. public function getSourceTagListAction()
  171. {
  173. $sourceTagsData = $this->doctrine->getRepository(SourceTags::class)->getSourceTagsByIsDeleted(0);
  174. $uniqueSourceTagNames = [];
  176. foreach ($sourceTagsData as $key => $value) {
  177. if (!in_array($value['tagName'], $uniqueSourceTagNames)) {
  178. array_push($uniqueSourceTagNames, $value['tagName']);
  179. }
  180. }
  182. $multiselectList = [];
  184. foreach ($uniqueSourceTagNames as $tagName) {
  185. $multiselectList[] = [
  186. 'value' => $tagName,
  187. 'label' => $tagName
  188. ];
  189. }
  192. return new JsonResponse($multiselectList);
  193. }
  195. /**
  196. * @Route("/affiliate-tags-list", name="get_affiliate_tags_list", methods={"GET"})
  197. */
  198. public function getAffiliateTagListAction()
  199. {
  201. $affiliateTagsData = $this->doctrine->getRepository(AffiliateTags::class)->getAffiliateTagsByIsDeleted(0);
  202. $uniqueAffiliateTagNames = [];
  204. foreach ($affiliateTagsData as $key => $value) {
  205. if (!in_array($value['tagName'], $uniqueAffiliateTagNames)) {
  206. array_push($uniqueAffiliateTagNames, $value['tagName']);
  207. }
  208. }
  210. $multiselectList = [];
  212. foreach ($uniqueAffiliateTagNames as $tagName) {
  213. $multiselectList[] = [
  214. 'value' => $tagName,
  215. 'label' => $tagName
  216. ];
  217. }
  220. return new JsonResponse($multiselectList);
  221. }
  223. /**
  224. * @Route("/cr-optimisation-cr-relationship-types", name="get_cr_optimisation_cr_relationship_types", methods={"GET"})
  225. */
  226. public function getCrOptimisationCrRelationshipTypesAction()
  227. {
  229. $crOptimisationCrRelationshipType = Config::CR_OPTIMISATION_CR_RELATIONSHIP_TYPE;
  231. $multiselectList = [];
  233. foreach ($crOptimisationCrRelationshipType as $tagName) {
  234. $multiselectList[] = [
  235. 'value' => $tagName,
  236. 'label' => ucwords(str_replace("_", " ", $tagName))
  237. ];
  238. }
  241. return new JsonResponse($multiselectList);
  242. }
  244. /**
  245. * @Route("/goal-id-optimisation-comparison-macros", name="get_goal_id_optimisation_comparison_macros", methods={"GET"})
  246. */
  247. public function getGoalIdOptimisationComparisonMacrosAction()
  248. {
  249. $multiselectList = [];
  251. foreach (Config::GOAL_ID_OPTIMISATION_OPERATOR_COMPARISON_MACROS as $tagName) {
  252. $multiselectList[] = [
  253. 'value' => $tagName,
  254. 'label' => strtoupper(str_replace("_", " ", $tagName))
  255. ];
  256. }
  259. return new JsonResponse($multiselectList);
  260. }
  262. /**
  263. * @Route("/goal-id-optimisation-rule-time-period", name="get_goal_id_optimisation_rule_time_period", methods={"GET"})
  264. */
  265. public function getGoalIdOptimisationRuleTimePeriodAction()
  266. {
  267. $multiselectList = [];
  269. foreach (Config::GOAL_ID_OPTIMISATION_RULE_TIME_PERIOD as $tagName) {
  270. $multiselectList[] = [
  271. 'value' => $tagName,
  272. 'label' => strtoupper(str_replace("_", " ", $tagName))
  273. ];
  274. }
  277. return new JsonResponse($multiselectList);
  278. }
  280. /**
  281. * @Route("/offer-category", name="get_offer_category", methods={"GET"})
  282. */
  283. public function getAllOfferCategoriesByStatus(Request $request)
  284. {
  285. $tuneAccount = $request->query->get('tuneAccount') ?? Config::MAFO_SYSTEM_IDENTIFIER_TUNE_MOBILE;
  287. $offerCategoriesData = $this->commonCalls->getOfferCategoriesListByStatusWithKeys($tuneAccount);
  288. $categoryList = [];
  289. foreach ($offerCategoriesData as $key => $value) {
  290. $categoryList[$key] = [
  291. 'label' => ucwords($value['name']),
  292. 'value' => $value['id']
  293. ];
  294. }
  295. ksort($categoryList);
  297. return new JsonResponse(array_values($categoryList));
  298. }
  300. /**
  301. * @Route("/countries", name="get_countries", methods={"GET"})
  302. */
  303. public function getCountriesAction()
  304. {
  306. $countryList = [];
  307. foreach (Config::COUNTRIES as $key => $value) {
  308. $countryList[$key] = [
  309. 'value' => $key,
  310. 'label' => $key . ' - ' . $value['name']
  311. ];
  312. }
  313. ksort($countryList);
  315. return new JsonResponse(array_values($countryList));
  316. }
  318. /**
  319. * @Route("/currencies", name="get_currencies", methods={"GET"})
  320. */
  321. public function getCurrenciesAction()
  322. {
  324. $currencyList = [];
  325. foreach (Config::CURRENCIES as $key => $value) {
  326. $currencyList[$key] = [
  327. 'value' => $key,
  328. 'label' => $key . ' - ' . $value
  329. ];
  330. }
  331. ksort($currencyList);
  333. return new JsonResponse(array_values($currencyList));
  334. }
  336. /**
  337. * @Route("/tag", name="get_tag", methods={"GET"})
  338. */
  339. public function getTagAction()
  340. {
  342. $tagsInDb = $this->doctrine->getRepository(Tag::class)->getTags(1, 1, null, null);
  343. $tagList = [];
  344. foreach ($tagsInDb as $key => $value) {
  345. $tagList[] = [
  346. 'value' => $value['tagId'],
  347. 'label' => $value['name']
  348. ];
  349. }
  350. ksort($tagList);
  352. return new JsonResponse(array_values($tagList));
  353. }
  355. /**
  356. * @Route("/advertiser-tags", name="get_advertiser_tags", methods={"GET"})
  357. */
  358. public function getAdvertiserTAgsAction(Request $request)
  359. {
  361. $tuneAccount = $request->query->get('tuneAccount');
  363. $tagsInDb = $this->doctrine->getRepository(Tag::class)->getTags(1, null, 1, null, $tuneAccount);
  364. $tagList = [];
  365. foreach ($tagsInDb as $key => $value) {
  366. $tagList[] = [
  367. 'value' => $value['tagId'],
  368. 'label' => $value['name']
  369. ];
  370. }
  371. ksort($tagList);
  373. return new JsonResponse(array_values($tagList));
  374. }
  376. /**
  377. * @Route("/offer-tags", name="get_offer_tags", methods={"GET"})
  378. */
  379. public function getOfferTagsAction()
  380. {
  382. $tagsInDb = $this->doctrine->getRepository(Tag::class)->getTags(1, 1, null, null);
  383. $tagList = [];
  384. foreach ($tagsInDb as $key => $value) {
  385. $tagList[] = [
  386. 'value' => $value['tagId'],
  387. 'label' => $value['name']
  388. ];
  389. }
  390. ksort($tagList);
  392. return new JsonResponse(array_values($tagList));
  393. }
  395. /**
  396. * @Route("/affiliate-tags", name="get_affiliate_ho_tags", methods={"GET"})
  397. */
  398. public function getAffiliateHoTagsAction(Request $request)
  399. {
  401. $tagsInDb = $this->doctrine->getRepository(Tag::class)->getTags(1, null, null, 1, null);
  403. $data = [];
  405. foreach ($tagsInDb as $key => $value) {
  406. $tuneAccount = Config::MAFO_SYSTEM_IDENTIFIER_PRETTY[$value['tuneAccount']] ?? "";
  408. $data[$tuneAccount]['label'] = strtoupper($tuneAccount) . ' ACCOUNT TAGS';
  409. $data[$tuneAccount]['options'][$value['tagId']] = [
  410. 'value' => $value['tagId'],
  411. 'label' => $value['name'],
  412. 'tuneAccount' => $tuneAccount,
  413. 'tuneAccountRaw' => $value['tuneAccount'],
  414. 'color' => Config::MAFO_SYSTEM_IDENTIFIER_TUNE_ACCOUNTS_COLORS[$value['tuneAccount']] ?? "#000"
  415. ];
  416. ksort($data[$tuneAccount]['options']);
  417. }
  418. $finalArr = [];
  420. foreach ($data as $key => $value) {
  421. $finalArr[] = [
  422. 'label' => $value['label'],
  423. 'options' => array_values($value['options']),
  424. ];
  425. }
  426. return new JsonResponse(array_values($finalArr));
  427. }
  429. /**
  430. * @Route("/app-ids", name="get_app_ids", methods={"GET"})
  431. */
  432. public function getAppIdsAction()
  433. {
  435. $appIds = $this->doctrine->getRepository(AppInfo::class)->getAppIds();
  437. $appList = [
  438. [
  439. 'value' => 'Not Found',
  440. 'label' => 'Not Found'
  441. ]
  442. ];
  443. foreach ($appIds as $key => $value) {
  444. $appList[$value['appId']] = [
  445. 'value' => $value['appId'],
  446. 'label' => $value['title']
  447. ];
  448. }
  450. return new JsonResponse(array_values($appList));
  451. }
  453. /**
  454. * @Route("/offer-blocked-from-list", name="get_offer_blocked_from_list", methods={"GET"})
  455. */
  456. public function getOfferBlockedFromList()
  457. {
  459. $offerBlockedFromList = [];
  460. foreach (Config::OFFER_AFFILIATE_BLOCK_FROM_LIST as $key => $value) {
  461. $offerBlockedFromList[] = [
  462. 'value' => $key,
  463. 'label' => $value
  464. ];
  465. }
  467. return new JsonResponse($offerBlockedFromList);
  468. }
  470. /**
  471. * @Route("/approval-control-approval-types", name="get_approval_control_approval_types", methods={"GET"})
  472. */
  473. public function getApprovalControlApprovalTypeAction()
  474. {
  476. $approvalTypes = [];
  477. foreach (Config::APPROVAL_CONTROL_APPROVAL_TYPE as $key => $value) {
  478. $approvalTypes[] = [
  479. 'value' => $key,
  480. 'label' => $value
  481. ];
  482. }
  484. return new JsonResponse($approvalTypes);
  485. }
  487. /**
  488. * @Route("/affiliate-offer-block-types", name="get_affiliate_offer_block_types", methods={"GET"})
  489. */
  490. public function getAffiliateOfferBlockTypesAction()
  491. {
  493. $blockTypes = [
  494. [
  495. 'value' => Config::AFFILIATE_OFFER_BLOCK_MACRO,
  496. 'label' => ucfirst(Config::AFFILIATE_OFFER_BLOCK_MACRO),
  497. ],
  498. [
  499. 'value' => Config::AFFILIATE_OFFER_UNBLOCK_MACRO,
  500. 'label' => ucfirst(Config::AFFILIATE_OFFER_UNBLOCK_MACRO),
  501. ]
  503. ];
  505. return new JsonResponse($blockTypes);
  506. }
  508. /**
  509. * @Route("/platform-types", name="get_platform_types", methods={"GET"})
  510. */
  511. public function getPlatformTypesAction()
  512. {
  514. $platformTypes = [
  515. [
  516. 'value' => Config::PLATFORM_IOS,
  517. 'label' => strtoupper(Config::PLATFORM_IOS)
  518. ],
  519. [
  520. 'value' => Config::PLATFORM_ANDROID,
  521. 'label' => strtoupper(Config::PLATFORM_ANDROID)
  522. ]
  523. ];
  525. return new JsonResponse($platformTypes);
  526. }
  528. /**
  529. * @Route("/mmp-tracking-system", name="get_mmp_tracking_system", methods={"GET"})
  530. */
  531. public function getMmpTrackingSystemAction()
  532. {
  534. $mmpTrackingSystem = [];
  535. foreach (Config::MMP_TRACKING_SYSTEM_PRETTY as $key => $value) {
  536. $mmpTrackingSystem[] = [
  537. 'value' => $key,
  538. 'label' => $value
  539. ];
  540. }
  543. return new JsonResponse($mmpTrackingSystem);
  544. }
  547. /**
  548. * @Route("/mmp-tracking-system-global-network-report", name="get_mmp-tracking-system-global-network-report", methods={"GET"})
  549. */
  550. public function getMmpTrackingSystemForGlobalNetworkReportAction(Request $request)
  551. {
  553. $mmpTrackingSystem = [];
  554. foreach (Config::MMP_TRACKING_SYSTEM_GLOBAL_NETWORK_REPORT_PRETTY as $key => $value) {
  555. $mmpTrackingSystem[] = [
  556. 'value' => $key,
  557. 'label' => $value
  558. ];
  559. }
  561. return new JsonResponse($mmpTrackingSystem);
  562. }
  564. /**
  565. * @Route("/app-info/{appId}", name="get_app_info", methods={"GET"})
  566. */
  567. public function geAppInfoAction(Request $request, $appId)
  568. {
  570. $appInfoData = $this->doctrine->getRepository(AppInfo::class)->getDataByAppIds([$appId]);
  572. $appInfo = [];
  573. foreach ($appInfoData as $key => $value) {
  575. $appInfo[$value['appId']] = $value;
  576. }
  578. return new JsonResponse($appInfo);
  579. }
  581. /**
  582. * @Route("/tag-attributes/{attributeType}", name="get_tag_attributes", methods={"GET"})
  583. */
  584. public function getOperatingSystemAction(Request $request, $attributeType)
  585. {
  587. $tuneAccount = $request->query->get('tuneAccount');
  589. $attributes = [];
  591. if (array_key_exists($attributeType, Config::TAG_ATTRIBUTES)) {
  592. $attributeData = $this->doctrine->getRepository(Tag::class)->getTagsByAttribute(Config::TAG_ATTRIBUTES[$attributeType], $tuneAccount);
  593. foreach ($attributeData as $key => $value) {
  594. $attributes[] = [
  595. 'value' => (string)$value['tagId'],
  596. 'label' => $value['name']
  597. ];
  598. }
  599. }
  601. return new JsonResponse($attributes);
  602. }
  604. /**
  605. * @Route("/timezones", name="get_timezone", methods={"GET"})
  606. */
  607. public function getTimezonesAction(Request $request)
  608. {
  610. $timezones = [];
  611. foreach (Config::TIMEZONES as $key => $value) {
  612. $timezones[] = [
  613. 'value' => $key,
  614. 'label' => $value
  615. ];
  616. }
  618. return new JsonResponse($timezones);
  619. }
  621. /**
  622. * @Route("/advertisers", name="get_advertisers", methods={"GET"})
  623. */
  624. public function getAdvertisersAction(Request $request)
  625. {
  627. $keyword = $request->query->get('keyword');
  628. $tuneAccount = $request->query->get('tuneAccount') ?? Config::MAFO_SYSTEM_IDENTIFIER_TUNE_MOBILE;
  631. $dataByKeyword = $this->doctrine->getRepository(AdvertiserInfo::class)->getAdvertiserByKeyword($keyword, $tuneAccount);
  632. $arr = [];
  633. foreach ($dataByKeyword as $key => $value) {
  634. $temp = [
  635. 'value' => (int)$value['advertiserId'],
  636. 'label' => $value['advertiserId'] . ' - ' . $value['company'],
  637. 'status' => $value['status']
  638. ];
  639. $arr[$value['advertiserId']] = $temp;
  640. }
  641. ksort($arr);
  642. return new JsonResponse(array_values($arr));
  643. }
  645. /**
  646. * @Route("/cohorttype", name="get_cohorttype", methods={"GET"})
  647. */
  648. public function getCohortTypeAction(Request $request)
  649. {
  650. $temp = [
  651. [
  652. 'value' => 'cohort_user_acquisition_agency',
  653. 'label' => 'User acquisition',
  654. ],
  655. [
  656. 'value' => 'cohort_retargeting_agency',
  657. 'label' => 'Retargeting',
  658. ],
  659. [
  660. 'value' => 'cohort_unified_agency',
  661. 'label' => 'Unified',
  662. ],
  663. ];
  665. $arr = [];
  667. foreach ($temp as $item) {
  668. $arr[$item['label']] = [
  669. 'value' => $item['value'],
  670. 'label' => $item['label'],
  671. ];
  672. }
  674. ksort($arr);
  675. return new JsonResponse(array_values($arr));
  676. }
  679. /**
  680. * @Route("/affiliates", name="get_affiliates", methods={"GET"})
  681. */
  682. public
  683. function getAffiliatesAction(Request $request)
  684. {
  686. $keyword = $request->query->get('keyword');
  687. $tuneAccount = $request->query->get('tuneAccount') ?? Config::MAFO_SYSTEM_IDENTIFIER_TUNE_MOBILE;
  689. $dataByKeyword = $this->doctrine->getRepository(AffiliateInfo::class)->getAffiliateByKeyword($keyword, $tuneAccount);
  691. $arr = [];
  692. foreach ($dataByKeyword as $key => $value) {
  693. $temp = [
  694. 'value' => (int)$value['affiliateId'],
  695. 'label' => $value['affiliateId'] . ' - ' . $value['company'],
  696. 'status' => $value['status']
  697. ];
  698. $arr[$value['affiliateId']] = $temp;
  699. }
  700. ksort($arr);
  701. return new JsonResponse(array_values($arr));
  702. }
  704. /**
  705. * @Route("/user", name="get_user", methods={"GET"})
  706. */
  707. public
  708. function getUerAction(Request $request, TokenStorageInterface $tokenStorage)
  709. {
  710. $roles = $this->getUser()->getRoles();
  711. // if (is_array($this->getUser()->getRoles()) && in_array(Config::ROLE_DIRECTOR, $this->getUser()->getRoles())) {
  712. // $roles = array_values(array_unique(array_merge( $this->getUser()->getRoles(), [Config::ROLE_ADMIN])));
  713. // }
  715. $token = $this->security->getToken();
  717. $loggedAsImpersonator = false;
  718. if ($token instanceof SwitchUserToken) {
  719. $loggedAsImpersonator = true;
  720. }
  722. $userData = [
  723. 'name' => $this->getUser()->getName(),
  724. 'email' => $this->getUser()->getEmail(),
  725. 'roles' => $roles,
  726. 'isAdmin' => $this->isGranted(Config::ROLE_ADMIN),
  727. 'profilePicture' => $this->getUser()->getPicture(),
  728. 'env' => $this->getParameter('kernel.environment'),
  729. 'isLoggedIntoMts' => true,
  730. 'token' => $this->getUser()->getJwtToken()
  731. ];
  733. if ($loggedAsImpersonator) {
  734. $userData['loggedInAsImpersonator'] = true;
  735. }
  737. return new JsonResponse($userData);
  738. }
  740. /**
  741. * @Route("/offers-by-advertiser/{advertiserId}", name="get_offers_by_advertiser_id", methods={"GET"})
  742. */
  743. public
  744. function getOffersByAdvertiserAction(Request $request, $advertiserId)
  745. {
  746. $offers = [];
  748. $status = $request->query->get('status') != '' ? $request->query->get('status') : [Config::ACTIVE_STATUS];
  749. $tuneAccount = $request->query->get('tuneAccount') != '' ? $request->query->get('tuneAccount') : [Config::TUNE_DEFAULT_ACCOUNT_LABEL];
  750. $search = $request->query->get('search', '');
  752. $offersByAdvertiser = $this->doctrine->getRepository(OfferInfo::class)->getOfferIdsByAdvertiserIdAndStatusArr($advertiserId, $status, $tuneAccount, $search);
  754. foreach ($offersByAdvertiser as $key => $value) {
  755. $offers[] = [
  756. 'value' => $value['offerId'],
  757. 'label' => $value['offerId'] . ' - ' . $value['name']
  758. ];
  759. }
  761. return new JsonResponse($offers);
  762. }
  764. /**
  765. * @Route("/mafo-offers-by-advertiser/{advertiserId}", name="get_mafo_offers_by_advertiser_id", methods={"GET"})
  766. */
  767. public
  768. function getMafoOffersByAdvertiserAction(Request $request, $advertiserId)
  769. {
  770. $offers = [];
  772. $status = $request->query->all('status') != '' ? [] : [Config::ACTIVE_STATUS];
  773. $search = $request->query->get('search', '');
  775. $offersByAdvertiser = $this->doctrine->getRepository(MafoOffers::class)->getOfferIdsByAdvertiserIdAndStatusArr($advertiserId, $status, $search);
  777. foreach ($offersByAdvertiser as $key => $value) {
  778. $offers[$value['systemIdentifier']]['label'] = strtoupper($value['systemIdentifier']) . ' ACCOUNT OFFERS';
  779. $offers[$value['systemIdentifier']]['options'][$value['id']] = [
  780. 'value' => $value['id'],
  781. 'label' => $value['id'] . ' - ' . $value['name'] . ' [' . $value['systemIdentifierId'] . ']',
  782. 'systemIdentifier' => $value['systemIdentifier'],
  783. 'systemIdentifierId' => $value['systemIdentifierId'],
  784. ];
  785. ksort($offers[$value['systemIdentifier']]['options']);
  786. }
  788. $finalArr = [];
  789. foreach ($offers as $key => $value) {
  790. $finalArr[] = [
  791. 'label' => $value['label'],
  792. 'options' => array_values($value['options']),
  793. ];
  794. }
  796. return new JsonResponse($finalArr);
  797. }
  799. /**
  800. * @Route("/deduction-control-activity-source", name="get_deduction_control_activity_source", methods={"GET"})
  801. */
  802. public
  803. function getDeductionControlActivitySourceAction(Request $request)
  804. {
  806. $arr = [];
  807. foreach (Config::DEDUCTION_CONTROL_ACTIVITY_SOURCE_ARRAY as $activitySource) {
  808. $arr[] = [
  809. 'value' => $activitySource,
  810. 'label' => $activitySource
  811. ];
  812. }
  814. return new JsonResponse($arr);
  815. }
  817. /**
  818. * @Route("/deduction-control-status", name="get_deduction_control_status", methods={"GET"})
  819. */
  820. public
  821. function getDeductionControlStatusAction(Request $request)
  822. {
  824. $arr = [];
  825. foreach (Config::DEDUCTION_CONTROL_STATUS as $status) {
  826. $arr[] = [
  827. 'value' => $status,
  828. 'label' => ucfirst($status)
  829. ];
  830. }
  832. return new JsonResponse($arr);
  833. }
  835. /**
  836. * @Route("/file-download", name="get_file_download", methods={"GET"})
  837. */
  838. public
  839. function getFileDownloadAction(Request $request)
  840. {
  842. $fileKey = $request->query->get('fileKey');
  843. $directory = $request->query->get('directory');
  845. echo ($this->s3->getFileFromS3($directory, $fileKey));
  846. exit;
  847. }
  850. /**
  851. * @Route("/offer-search", name="get_offer_search_empty", methods={"GET"})
  852. */
  853. public
  854. function getOfferSearchEmptyAction(Request $request)
  855. {
  856. return new JsonResponse([]);
  857. }
  859. /**
  860. * @Route("/offer-search/{keyword}", name="get_offer_search", methods={"GET"})
  861. */
  862. public
  863. function getOfferSearchBYKeywordAction(Request $request, $keyword)
  864. {
  865. $offerInfo = $this->doctrine->getRepository(OfferInfo::class)->getOffersWhereNameLike(Config::ACTIVE_STATUS, $keyword);
  867. $data = [];
  869. foreach ($offerInfo as $key => $value) {
  870. $data[] = [
  871. 'value' => $value['offerId'],
  872. 'label' => $value['offerId'] . ' - ' . $value['name'],
  873. 'skadNetworkMmp' => $value['skadNetworkMmp']
  874. ];
  875. }
  877. return new JsonResponse($data);
  878. }
  880. /**
  881. * @Route("/offer-search-by-tune-accounts/{keyword}", methods={"GET"})
  882. */
  883. public
  884. function getOfferSearchByTuneAccountsAndKeywordAction(Request $request, $keyword)
  885. {
  886. $offerInfo = $this->doctrine->getRepository(OfferInfo::class)->getOffersWhereNameLike(Config::ACTIVE_STATUS, $keyword);
  888. if (empty($offerInfo)) {
  889. $offerInfoPending = $this->doctrine->getRepository(OfferInfo::class)->getOffersWhereNameLike(Config::PENDING_STATUS, $keyword);
  890. $offerInfoPaused = $this->doctrine->getRepository(OfferInfo::class)->getOffersWhereNameLike(Config::PAUSED_STATUS, $keyword);
  892. $offerInfo = array_merge($offerInfoPending, $offerInfoPaused);
  893. }
  895. $data = [];
  896. foreach ($offerInfo as $key => $value) {
  897. $tuneAccount = Config::MAFO_SYSTEM_IDENTIFIER_PRETTY[$value['tuneAccount']] ?? "";
  898. $offerIdToDisplay = $value['offerId'];
  900. $data[$tuneAccount]['label'] = strtoupper($tuneAccount) . ' ACCOUNT OFFER IDS';
  901. $data[$tuneAccount]['options'][$value['offerId']] = [
  902. 'value' => $value['offerId'],
  903. 'label' => $offerIdToDisplay . ' - ' . $value['name'],
  904. 'tuneAccount' => $value['tuneAccount'],
  905. 'tuneAccountRaw' => $value['tuneAccount'],
  906. 'color' => Config::MAFO_SYSTEM_IDENTIFIER_TUNE_ACCOUNTS_COLORS[$tuneAccount] ?? "#000"
  907. ];
  908. ksort($data[$tuneAccount]['options']);
  909. }
  910. $finalArr = [];
  912. foreach ($data as $key => $value) {
  913. $finalArr[] = [
  914. 'label' => $value['label'],
  915. 'options' => array_values($value['options']),
  916. ];
  917. }
  919. return new JsonResponse($finalArr);
  920. }
  923. /**
  924. * @Route("/click-cap-block-period-list", name="get_click_cap_block_period_list", methods={"GET"})
  925. */
  926. public
  927. function getClickCapBlockPeriodListAction(Request $request)
  928. {
  929. $list = [];
  930. foreach (Config::CLICK_CAP_BLOCK_PERIOD_LIST as $key => $value) {
  931. $list[] = [
  932. 'value' => $key,
  933. 'label' => $value
  934. ];
  935. }
  937. return new JsonResponse($list);
  938. }
  941. /**
  942. * @Route("/skadnetwork-mmp-list", name="get_skadnetwork_mmp_list", methods={"GET"})
  943. */
  944. public
  945. function getSkadnetworkMmpListAction(Request $request)
  946. {
  947. $list = [];
  948. foreach (Config::SKADNETOWRK_MMP as $key => $value) {
  949. $list[] = [
  950. 'value' => $value,
  951. 'label' => ucfirst($value)
  952. ];
  953. }
  955. return new JsonResponse($list);
  956. }
  959. /**
  960. * @Route("/skadnetwork-enabled-offer-by-app-id/{appId}", name="get_skadnetwork_enabled-offer_by_app_id", methods={"GET"})
  961. */
  962. public
  963. function getSkadNetworkEnabledOfferByAppId(Request $request, $appId)
  964. {
  966. $offerInfo = [];
  967. if ($appId) {
  968. $offerInfo = $this->doctrine->getRepository('App\Entity\Tune\OfferInfo')->getSkadEnaledOfferInfoByAppId($appId, 1);
  969. }
  970. $offerIds = [];
  972. foreach ($offerInfo as $key => $value) {
  973. $offerIds[] = $value['offerId'];
  974. }
  976. return new JsonResponse($offerIds);
  977. }
  979. /**
  980. * @Route("/mafo-users", name="get_mafo_users", methods={"GET"})
  981. */
  982. public
  983. function getMafoUsersAction(Request $request)
  984. {
  985. $role = $request->query->get('role') !== 'undefined' ? $request->query->get('role') : false;
  987. $users = $this->doctrine->getRepository('App\Entity\Users')->getUsers();
  989. $roles = [];
  990. if ($role === Config::ROLE_SALES) {
  991. $roles = [$role, Config::ROLE_ADMIN];
  992. }
  994. $arr = [];
  995. foreach ($users as $key => $value) {
  996. if ($roles) {
  997. if (array_intersect($roles, $value['roles'])) {
  998. $arr[$value['email']] = [
  999. 'value' => $value['email'],
  1000. 'label' => $value['name'] . "[{$value['email']}]"
  1001. ];
  1002. }
  1003. } else {
  1004. $arr[$value['email']] = [
  1005. 'value' => $value['email'],
  1006. 'label' => $value['name'] . " [{$value['email']}]"
  1007. ];
  1008. }
  1009. }
  1011. ksort($arr);
  1012. return new JsonResponse(array_values($arr));
  1013. }
  1015. /**
  1016. * @Route("/mafo-users-position", name="get_mafo_users_position", methods={"GET"})
  1017. */
  1018. public
  1019. function getMafoUsersPostionAction(Request $request)
  1020. {
  1021. $users = $this->doctrine->getRepository('App\Entity\Users')->getUsers([
  1022. 'status' => ['value' => [Config::ACTIVE_STATUS], 'excludeFlag' => false]
  1023. ]);
  1025. $arr = [];
  1026. foreach ($users as $key => $value) {
  1027. if ($value['position']) {
  1028. $arr[$value['position']] = [
  1029. 'value' => $value['position'],
  1030. 'label' => $value['position']
  1031. ];
  1032. }
  1033. }
  1035. ksort($arr);
  1036. return new JsonResponse(array_values($arr));
  1037. }
  1039. /**
  1040. * @Route("/report-columns/{report}", name="get_report_columns", methods={"GET"})
  1041. */
  1042. public
  1043. function getReportColumnsAction(Request $request, $report)
  1044. {
  1045. if ($report === Config::REPORT_ADVERTISER_MACRO) {
  1046. $savedCols = Config::REPORT_ADVERTISER_COLUMNS;
  1047. $col = [];
  1048. foreach ($savedCols as $key => $value) {
  1049. $value['accessor'] = str_replace(".", Config::REPORT_ADVERTISER_ACCESSOR_SEPARATOR, $value['accessor']);
  1050. $col[] = $value;
  1051. }
  1052. return new JsonResponse($col);
  1053. } elseif (in_array($report, array_keys(Config::TABLE_COLUMNS_WITH_JSON_FILE))) {
  1054. // echo json_Encode(Config::TABLE_COLUMNS_WITH_JSON_FILE[$report]);die;
  1055. return new JsonResponse(array_values($this->commonCalls->getDataFromJsonFile(Config::TABLE_COLUMNS_WITH_JSON_FILE[$report])));
  1056. } else {
  1057. return new JsonResponse(array_values(Config::REPORT_COLUMN_MAPPING[$report]));
  1058. }
  1059. }
  1061. /**
  1062. * @Route("/table-columns/{table}", name="get_table_columns", methods={"GET"})
  1063. */
  1064. public
  1065. function getTableColumnsAction(Request $request, $table)
  1066. {
  1067. return new JsonResponse(array_values($this->commonCalls->getDataFromJsonFile(Config::TABLE_COLUMNS_WITH_JSON_FILE[$table])));
  1068. }
  1070. /**
  1071. * @Route("/skad-network-endpoints", name="get_skad_network_endpoints", methods={"GET"})
  1072. */
  1073. public
  1074. function getSkadNetworkEndpointsAction(Request $request)
  1075. {
  1076. $arr = [];
  1078. foreach (Config::SKADNETWORK_POSTBACK_ENDPOINT as $key => $value) {
  1079. $arr[] = [
  1080. 'value' => $value,
  1081. 'label' => $value
  1082. ];
  1083. }
  1085. return new JsonResponse($arr);
  1086. }
  1089. /**
  1090. * @Route("/deduction-insights-statuses", name="get_deduction_insights_status_filter", methods={"GET"})
  1091. */
  1092. public
  1093. function getDeductionInsightsStatusesAction(Request $request)
  1094. {
  1095. $data = [];
  1097. foreach (Config::DEDUCTION_INSIGHTS_STATUS_ARRAY as $value) {
  1098. $data[] = [
  1099. 'value' => $value,
  1100. 'label' => $value,
  1101. ];
  1102. }
  1104. return new JsonResponse($data);
  1105. }
  1108. /**
  1109. * @Route("/adjust-mmp-accounts", name="get_adjust_mmp_accounts", methods={"GET"})
  1110. */
  1111. public
  1112. function getAdjustMmpAccountsAction(Request $request)
  1113. {
  1114. $data = [];
  1116. foreach (array_keys(Config::MMP_ADJUST_ACCOUNT_TOKEN_MAPPING) as $value) {
  1117. $data[] = [
  1118. 'value' => $value,
  1119. 'label' => ucfirst($value) . " [" . Config::MMP_ADJUST_ACCOUNT_EMAIL_MAPPING[$value] . "]",
  1120. ];
  1121. }
  1123. return new JsonResponse($data);
  1124. }
  1127. /**
  1128. * @Route("/mmp-notification-rule-by-field", name="get_mmp_notification_rule_by_field", methods={"GET"})
  1129. */
  1130. public
  1131. function getMmpNotificationRuleByFieldAction(Request $request)
  1132. {
  1133. $data = [];
  1135. foreach (Config::MMP_NOTIFICATION_RULE_BY_FIELD_ARRAY as $key => $value) {
  1136. $data[] = [
  1137. 'value' => $key,
  1138. 'label' => $value
  1139. ];
  1140. }
  1142. return new JsonResponse($data);
  1143. }
  1145. /**
  1146. * @Route("/mmp-notification-rule-by-type", name="get_mmp_notification_rule_by_type", methods={"GET"})
  1147. */
  1148. public
  1149. function getMmpNotificationRuleByTypeAction(Request $request)
  1150. {
  1151. $data = [];
  1153. foreach (Config::MMP_NOTIFICATION_RULE_BY_TYPE_ARRAY as $key => $value) {
  1154. $data[] = [
  1155. 'value' => $key,
  1156. 'label' => $value
  1157. ];
  1158. }
  1160. return new JsonResponse($data);
  1161. }
  1163. /**
  1164. * @Route("/mmp-offer-events", name="get_mmp_offer_events", methods={"GET"})
  1165. */
  1166. public
  1167. function getMmpOfferEventsAction(Request $request)
  1168. {
  1169. // $mmpStatisticsEvents = $this->doctrine->getRepository(MmpOffers::class)->getDistinctEvents();
  1170. $mmpReportsEvents = $this->doctrine->getRepository(MmpReports::class)->getDistinctEvents();
  1172. $arr = [];
  1173. foreach ($mmpReportsEvents as $key => $value) {
  1175. $eventName = $value['mmpSource'] == (Config::MMP_TRACKING_SYSTEM_TUNE_MOBILE || $value['mmpSource'] == Config::MMP_TRACKING_SYSTEM_TUNE_WEB) ? $value['mmpOfferDefaultRevenueEventName'] : $value['event'];
  1177. $index = $value['event'] . '#' . $eventName;
  1178. $arr[$index] = [
  1179. 'value' => $value['event'],
  1180. 'label' => $eventName . " [ID: {$value['event']}]" . " [MMP: {$value['mmpSource']}]"
  1181. ];
  1182. }
  1184. return new JsonResponse(array_values($arr));
  1185. }
  1187. /**
  1188. * @Route("/mmp-offer-list", name="get_mmp_offer_list", methods={"GET"})
  1189. */
  1190. public
  1191. function getMmpOfferListAction(Request $request)
  1192. {
  1193. $data = $this->doctrine->getRepository(MmpOffers::class)->getMmpOffersDataByIsDeleted(0);
  1195. $arr = [];
  1196. foreach ($data as $key => $value) {
  1197. $arr[$value['id']] = [
  1198. 'value' => $value['id'],
  1199. 'label' => $value['id'] . ' - ' . $value['offerName']
  1200. ];
  1201. }
  1203. ksort($arr);
  1205. return new JsonResponse(array_values($arr));
  1206. }
  1209. /**
  1210. * @Route("/mmp-notification-period", name="get_mmp_notifications_period", methods={"GET"})
  1211. */
  1212. public
  1213. function getMmpNotificationsPeriodAction(Request $request)
  1214. {
  1215. $arr = [];
  1216. foreach (Config::MMP_NOTIFICATION_PERIOD_ARRAY as $key => $value) {
  1217. $arr[] = [
  1218. 'value' => $key,
  1219. 'label' => $value
  1220. ];
  1221. }
  1223. return new JsonResponse($arr);
  1224. }
  1227. /**
  1228. * @Route("/skad-postback-app-ids", name="get_skad_postback_app_ids", methods={"GET"})
  1229. */
  1230. public
  1231. function getSkadPostbacksAppIdsAction(Request $request)
  1232. {
  1233. $postbackLogsData = $this->doctrine->getRepository(SkadNetworkPostbackLogs::class)->getSkadNetworkPostbackAppIds();
  1235. $arr = [];
  1236. foreach ($postbackLogsData as $key => $value) {
  1237. if ($value['appId']) {
  1238. $arr[] = [
  1239. 'value' => $value['appId'],
  1240. 'label' => "id" . $value['appId'],
  1241. ];
  1242. }
  1243. }
  1245. return new JsonResponse($arr);
  1246. }
  1248. /**
  1249. * @Route("/skad-postback-campaign-ids", name="get_skad_postback_campaign_ids", methods={"GET"})
  1250. */
  1251. public
  1252. function getSkadPostbacksCampaignIdsAction(Request $request)
  1253. {
  1254. $postbackLogsData = $this->doctrine->getRepository(SkadNetworkPostbackLogs::class)->getSkadNetworkPostbackCampaignIds();
  1256. $arr = [];
  1257. foreach ($postbackLogsData as $key => $value) {
  1258. $arr[] = [
  1259. 'value' => (string)$value['campaignId'],
  1260. 'label' => (string)$value['campaignId'],
  1261. ];
  1262. }
  1264. return new JsonResponse($arr);
  1265. }
  1267. /**
  1268. * @Route("/organisation-chart", name="get_org_chart", methods={"GET"})
  1269. */
  1270. public
  1271. function getTestAction(Request $request)
  1272. {
  1274. $parentChildRelationship = $this->doctrine->getRepository(UsersHierarchy::class)->checkChildParentRelationship();
  1276. $usersInfo = $this->usersComponents->getUsersDataByEmailIdAsKey(true);
  1278. $organisationData = [];
  1279. foreach ($parentChildRelationship as $key => $value) {
  1280. $organisationData[] = [
  1281. 'name' => array_key_exists($value['child'], $usersInfo) ? $usersInfo[$value['child']]['name'] : '',
  1282. 'imageUrl' => array_key_exists($value['child'], $usersInfo) ? $usersInfo[$value['child']]['picture'] : '',
  1283. 'area' => array_key_exists($value['child'], $usersInfo) ? $usersInfo[$value['child']]['userInfo'] : '',
  1284. 'profileUrl' => array_key_exists($value['child'], $usersInfo) ? $usersInfo[$value['child']]['picture'] : '',
  1285. 'office' => array_key_exists($value['child'], $usersInfo) ? $usersInfo[$value['child']]['userInfo'] : '',
  1286. 'tags' => '',
  1287. 'positionName' => array_key_exists($value['child'], $usersInfo) ? ($usersInfo[$value['child']]['position'] ?? '') : '',
  1288. 'id' => $value['child'],
  1289. 'parentId' => $value['parent'] ?? '',
  1290. 'parentName' => $value['parent'] ? $usersInfo[$value['parent']]['name'] : '',
  1291. 'team' => array_key_exists($value['child'], $usersInfo) ? $usersInfo[$value['child']]['team'] : '',
  1292. 'userInfo' => array_key_exists($value['child'], $usersInfo) ? $usersInfo[$value['child']]['userInfo'] : '',
  1293. 'size' => '',
  1294. ];
  1295. }
  1297. return new JsonResponse($organisationData);
  1298. }
  1300. /**
  1301. * @Route("/revenue-control-statuses", name="get_revenue_control_statuses", methods={"GET"})
  1302. */
  1303. public
  1304. function getRevenueControlStatusesAction(Request $request)
  1305. {
  1306. $arr = [];
  1307. foreach (Config::REVENUE_CONTROL_STATUSES as $key => $value) {
  1308. $arr[] = [
  1309. 'value' => $value,
  1310. 'label' => ucfirst($value),
  1311. ];
  1312. }
  1314. return new JsonResponse($arr);
  1315. }
  1317. /**
  1318. * @Route("/payout-control-statuses", name="get_payout_control_statuses", methods={"GET"})
  1319. */
  1320. public
  1321. function getPayoutControlStatusesAction(Request $request)
  1322. {
  1323. $arr = [];
  1324. foreach (Config::PAYOUT_CONTROL_STATUSES as $key => $value) {
  1325. $arr[] = [
  1326. 'value' => $value,
  1327. 'label' => ucfirst($value),
  1328. ];
  1329. }
  1331. return new JsonResponse($arr);
  1332. }
  1334. /**
  1335. * @Route("/hyper-statuses", name="get_hyper_statuses", methods={"GET"})
  1336. */
  1337. public
  1338. function getHyperStatusesAction(Request $request)
  1339. {
  1340. $arr = [];
  1341. foreach (array_values(Config::HYPER_STATUS_MAFO_MACROS) as $key => $value) {
  1342. $arr[$value] = [
  1343. 'value' => $value,
  1344. 'label' => $value,
  1345. ];
  1346. }
  1348. return new JsonResponse(array_values($arr));
  1349. }
  1351. /**
  1352. * @Route("/affiliate-hyper-statuses", name="get_affiliate_hyper_statuses", methods={"GET"})
  1353. */
  1354. public
  1355. function getAffiliateHyperStatusesAction(Request $request)
  1356. {
  1357. $arr = [];
  1358. foreach (array_values(Config::HYPER_STATUS_AFFILIATE_MAFO_MACROS) as $key => $value) {
  1359. $arr[$value] = [
  1360. 'value' => $value,
  1361. 'label' => $value,
  1362. ];
  1363. }
  1365. return new JsonResponse(array_values($arr));
  1366. }
  1368. /**
  1369. * @Route("/oauth", name="get_oauth", methods={"GET"})
  1370. */
  1371. public
  1372. function getOauthAction(Request $request)
  1373. {
  1374. return new JsonResponse(true);
  1375. }
  1377. /**
  1378. * @Route("/revenue-total-billing-statuses", name="get_revenue_total_billing_statuses", methods={"GET"})
  1379. */
  1380. public
  1381. function getRevenueTotalBillingStatusesAction(Request $request)
  1382. {
  1383. $arr = [];
  1384. foreach (Config::REVENUE_TOTAL_BILLING_STATUSES as $key => $value) {
  1385. $arr[] = [
  1386. 'value' => $key,
  1387. 'label' => $value
  1388. ];
  1389. }
  1391. return new JsonResponse($arr);
  1392. }
  1394. /**
  1395. * @Route("/mobupps-teams", name="get_mobupps_teams_utilities", methods={"GET"})
  1396. */
  1397. public
  1398. function getMobuppsTeamUtilitiesAction(Request $request)
  1399. {
  1400. return new JsonResponse(array_values($this->usersComponents->getTeamsByTeamIdWithNonEmptyTeams()));
  1401. }
  1403. /**
  1404. * @Route("/empty-list", name="get_empty_list", methods={"GET"})
  1405. */
  1406. public
  1407. function getEmptyListAction(Request $request)
  1408. {
  1409. return new JsonResponse([]);
  1410. }
  1412. /**
  1413. * @Route("/gap-control-cost-type", name="get_gap_control_cost_type", methods={"GET"})
  1414. */
  1415. public
  1416. function getGapControlCostType(Request $request)
  1417. {
  1418. return new JsonResponse([
  1419. [
  1420. 'value' => 'gross',
  1421. 'label' => 'Gross Cost'
  1422. ],
  1423. [
  1424. 'value' => 'approved',
  1425. 'label' => 'Approved Cost'
  1426. ],
  1427. ]);
  1428. }
  1431. /**
  1432. * @Route("/log-entities", name="get_log_entities", methods={"GET"})
  1433. */
  1434. public
  1435. function getLogEntitiesAction(Request $request)
  1436. {
  1437. $arr = [];
  1438. foreach (Config::ENTITIES_TO_LOG as $key => $value) {
  1439. $arr[$value] = [
  1440. 'value' => $value,
  1441. 'label' => $value
  1442. ];
  1443. }
  1444. ksort($arr);
  1446. return new JsonResponse(array_values($arr));
  1447. }
  1449. /**
  1450. * @Route("/alert-medium", name="get_alert_mediums", methods={"GET"})
  1451. */
  1452. public
  1453. function getAlertMediumsAction(Request $request)
  1454. {
  1455. $arr = [];
  1456. foreach (Config::ALERT_MEDIUMS as $key => $value) {
  1457. $arr[$value] = [
  1458. 'value' => $value,
  1459. 'label' => strtoupper($value)
  1460. ];
  1461. }
  1462. ksort($arr);
  1464. return new JsonResponse(array_values($arr));
  1465. }
  1467. /**
  1468. * @Route("/alert-categories", name="get_alert_categories", methods={"GET"})
  1469. */
  1470. public
  1471. function getAlertCategoriesAction(Request $request)
  1472. {
  1473. $arr = [];
  1474. foreach (Config::ALERT_CATEGORIES as $key => $value) {
  1475. $arr[$value] = [
  1476. 'value' => $value,
  1477. 'label' => $value
  1478. ];
  1479. }
  1480. ksort($arr);
  1482. return new JsonResponse(array_values($arr));
  1483. }
  1485. /**
  1486. * @Route("/alert-names", name="get_alert_names", methods={"GET"})
  1487. */
  1488. public
  1489. function getAlertNameAction(Request $request)
  1490. {
  1491. $arr = [];
  1492. foreach (Config::ALERTS_LIST as $key => $value) {
  1493. $arr[] = [
  1494. 'value' => $value,
  1495. 'label' => $value
  1496. ];
  1497. }
  1498. ksort($arr);
  1500. return new JsonResponse(array_values($arr));
  1501. }
  1503. /**
  1504. * @Route("/boolean-select", name="get_boolean_select", methods={"GET"})
  1505. */
  1506. public
  1507. function getBooleanSelectAction(Request $request)
  1508. {
  1509. return new JsonResponse([
  1510. [
  1511. 'value' => true,
  1512. 'label' => 'YES',
  1513. ],
  1514. [
  1515. 'value' => false,
  1516. 'label' => 'NO',
  1517. ],
  1518. ]);
  1519. }
  1521. /**
  1522. * @Route("/site-id-select", name="get_site_id_select", methods={"GET"})
  1523. */
  1524. public
  1525. function getSiteIdSelectAction(Request $request)
  1526. {
  1527. $siteIds = $this->doctrine->getRepository(MmpReports::class)->getDistinctSiteIds();
  1529. $arr = [];
  1530. foreach ($siteIds as $siteIdRow) {
  1531. if (!empty($siteIdRow["siteId"])) {
  1532. $arr[$siteIdRow["siteId"]] = [
  1533. 'value' => $siteIdRow["siteId"],
  1534. 'label' => $siteIdRow["siteId"]
  1535. ];
  1536. }
  1537. }
  1539. ksort($arr);
  1541. return new JsonResponse(array_values($arr));
  1542. }
  1544. /**
  1545. * @Route("/alert-view/{id}", name="get_alert_view", methods={"GET"})
  1546. */
  1547. public
  1548. function getAlertViewAction(Request $request, $id)
  1549. {
  1551. $alertData = $this->doctrine->getRepository(AlertLogs::class)->findOneBy(['md5' => $id]);
  1552. $mailToName = '';
  1553. $userInfo = $this->doctrine->getRepository(Users::class)->findOneBy(['email' => $alertData->getMailTo() ?? null]);
  1554. if ($userInfo) {
  1555. $mailToName = $userInfo->getName();
  1556. }
  1558. return $this->render('/alerts/defaultAlertWithTableData.html.twig', [
  1559. 'headers' => is_string($alertData->getMailHeaderJson()) ? json_decode($alertData->getMailHeaderJson(), true) : $alertData->getMailHeaderJson(),
  1560. 'tableData' => is_string($alertData->getMailBodyJson()) ? json_decode($alertData->getMailBodyJson(), true) : $alertData->getMailBodyJson(),
  1561. 'name' => $mailToName,
  1562. 'corollary' => $alertData->getAlertForward()
  1563. ]);
  1564. }
  1566. /**
  1567. * @Route("/alert-csv-download/{id}", name="get_alert_csv_download", methods={"GET"})
  1568. */
  1569. public
  1570. function getAlertCsvDownloadAction(Request $request, $id)
  1571. {
  1573. $alertData = $this->doctrine->getRepository(\App\Entity\AlertLogs::class)->findOneBy(['md5' => $id]);
  1575. $alertName = $alertData->getAlertAction();
  1577. // var_dump($alertData);die;
  1579. $headers = is_string($alertData->getMailHeaderJson()) ? json_decode($alertData->getMailHeaderJson(), true) : $alertData->getMailHeaderJson();
  1580. $tableData = is_string($alertData->getMailBodyJson()) ? json_decode($alertData->getMailBodyJson(), true) : $alertData->getMailBodyJson();
  1582. // echo json_encode($tableData);die;
  1583. $rows = [array_column($headers, 'label')];
  1585. foreach ($tableData as $key => $value) {
  1586. $temp = [];
  1587. foreach ($headers as $k => $v) {
  1588. if (is_array($value[$k]['value'])) {
  1589. $tempArr = [];
  1590. foreach ($value[$k]['value'] as $subKey => $subValue) {
  1591. $tempArr[] = "$subKey: $subValue";
  1592. }
  1593. $temp[] = implode("\n", $tempArr);
  1594. } else {
  1595. $temp[] = $value[$k]['value'];
  1596. }
  1597. }
  1598. $rows[] = $temp;
  1599. }
  1601. $spreadsheet = new Spreadsheet();
  1602. $spreadsheet->getProperties()->setCreator('MAFO')
  1603. ->setLastModifiedBy('MAFO')
  1604. ->setTitle($alertName)
  1605. ->setSubject($alertName)
  1606. ->setDescription($alertName);
  1608. $spreadsheet->getActiveSheet()
  1609. ->fromArray(
  1610. $rows,
  1611. NULL,
  1612. 'A1'
  1613. );
  1615. header('Content-Type: application/vnd.ms-excel');
  1616. header('Content-Disposition: attachment;filename="' . $alertName . '.xls"');
  1617. header('Cache-Control: max-age=0');
  1618. $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
  1619. $writer->save('php://output');
  1620. exit;
  1621. }
  1624. /**
  1625. * @Route("/affiliate-categories", name="get_affiliate_categories", methods={"GET"})
  1626. */
  1627. public
  1628. function getAffiliateCategoriesAction(Request $request)
  1629. {
  1631. $arr = [
  1632. [
  1633. 'value' => Config::HASOFFER_AFFILIATE_CATEGORY_UNCATEGORISED_TAG_NAME,
  1634. 'label' => Config::HASOFFER_AFFILIATE_CATEGORY_UNCATEGORISED_TAG_NAME
  1635. ]
  1636. ];
  1638. foreach (Config::HASOFFER_AFFILIATE_CATEGORY_ARRAY as $key => $value) {
  1639. $arr[] = [
  1640. 'value' => $value,
  1641. 'label' => $value
  1642. ];
  1643. }
  1646. return new JsonResponse($arr);
  1647. }
  1650. /**
  1651. * @Route("/alert-frequency-types", name="get_alert_frequency_types", methods={"GET"})
  1652. */
  1653. public
  1654. function getAlertFrequencyTypesAction(Request $request)
  1655. {
  1656. $arr = [];
  1657. foreach (Config::ALERT_CONTROL_ALERT_FREQUENCY_TYPES as $type) {
  1658. $arr[] = [
  1659. 'value' => $type,
  1660. 'label' => strtoupper($type)
  1661. ];
  1662. }
  1664. return new JsonResponse($arr);
  1665. }
  1668. /**
  1669. * @Route("/global-report-exclude-zero-values", name="get_global_report_Exclude_zero_values", methods={"GET"})
  1670. */
  1671. public
  1672. function getGlobalReportExcludeZeroValuesAction(Request $request)
  1673. {
  1674. $arr = [];
  1676. $columns = $this->commonCalls->getDataFromJsonFile(Config::JSON_FILE_GLOBAL_NETWORK_REPORT);
  1678. foreach ($columns as $key => $value) {
  1679. if (in_array($value['category'], ['statistics', 'calculations'])) {
  1680. $arr[] = [
  1681. 'value' => $value['accessor'],
  1682. 'label' => 'Exclude results with zero ' . $value['header']
  1683. ];
  1684. }
  1685. }
  1687. return new JsonResponse($arr);
  1688. }
  1691. /**
  1692. * @Route("/hyper-client-list", name="get_hyper_client_list", methods={"GET"})
  1693. */
  1694. public
  1695. function getHyperClientList(Request $request, HyperApis $hyperApis)
  1696. {
  1697. $hyperData = $this->commonCalls->getHyperClientCachedListByKeys();
  1699. $clientId = $request->query->get('clientId');
  1700. if ($clientId > 0) {
  1701. $clientInfo = $hyperApis->getHyperClientByClientId($clientId);
  1702. if ($clientInfo && isset($clientInfo['Result']) && $clientInfo['Result'] == 'Ok') {
  1703. foreach ($clientInfo['ResultData']['Data'] as $key => $value) {
  1704. if ($value['ClientNumber'] == $clientId) {
  1705. $countryCode = null;
  1706. foreach (Config::COUNTRIES as $k => $v) {
  1707. if ($this->commonCalls->checkForString($value['Country'], $v['name'])) {
  1708. $countryCode = $k;
  1709. break;
  1710. }
  1711. }
  1713. $value['countryCode'] = $countryCode;
  1714. $hyperData[$clientId] = $value;
  1715. break;
  1716. }
  1717. }
  1718. }
  1719. }
  1721. $arr = [];
  1722. foreach ($hyperData as $key => $value) {
  1724. $arr[] = [
  1725. 'value' => $key,
  1726. 'label' => $value['ClientFullName'] . ' [' . $value['ClientNumber'] . ']',
  1727. 'clientFullName' => $value['ClientFullName'],
  1728. 'countryCode' => $value['countryCode'],
  1729. 'city' => $value['City'],
  1730. 'address' => $value['StreetAddress']
  1731. ];
  1732. }
  1734. return new JsonResponse($arr);
  1735. }
  1738. /**
  1739. * @Route("/hyper-publisher-list", name="get_hyper_publisher_list", methods={"GET"})
  1740. */
  1741. public
  1742. function getHyperPublisherList(Request $request, HyperApis $hyperApis)
  1743. {
  1744. $hyperPublisherData = $this->commonCalls->getHyperPublisherCachedListByKeys();
  1746. $arr = [];
  1747. foreach ($hyperPublisherData as $key => $value) {
  1748. $arr[$value['SupplierNumber']] = [
  1749. 'value' => (int) $value['SupplierNumber'],
  1750. 'label' => $value['SupplierFullName'] . ' [' . $value['SupplierNumber'] . ']'
  1751. ];
  1752. }
  1754. ksort($arr);
  1756. return new JsonResponse(array_values($arr));
  1757. }
  1759. /**
  1760. * @Route("/tune-advertisers-by-hyper-client/{clientId}", name="get_tune_advertisers_by_hyper_client", methods={"GET"})
  1761. */
  1762. public
  1763. function getTuneAdvertisersByHyperClient(Request $request, $clientId)
  1764. {
  1765. $hyperData = $this->commonCalls->getHyperClientCachedListByKeys();
  1767. $linkedAdvertisers = [];
  1768. foreach ($hyperData as $key => $value) {
  1769. $value['Io_numbers'] = str_replace("\n\r", " ", $value['Io_numbers']);
  1770. $hyperData[$key]['Io_numbers'] = explode(" ", $value['Io_numbers']);
  1771. $linkedAdvertisers = array_values(array_unique(array_merge($linkedAdvertisers, $hyperData[$key]['Io_numbers'])));
  1772. }
  1774. $unlinedAdvertisers = $this->doctrine->getRepository(AdvertiserInfo::class)->getAdvertiserListByArrToSearch([
  1775. 'advertiserId' => ['value' => $linkedAdvertisers, 'excludeFlag' => true]
  1776. ]);
  1778. $clientLinkedMutiselectList = [];
  1779. $clientLinkedMutiselectList['label'] = 'Tune Advertisers Linked With HYPER';
  1780. $clientLinkedMutiselectList['options'] = [];
  1781. if (isset($hyperData[$clientId]) && sizeof($hyperData[$clientId]['Io_numbers'])) {
  1782. $clientLinkedMutiselectList['label'] = 'Tune Advertisers Linked With HYPER Client ' . $hyperData[$clientId]['ClientFullName'];
  1783. $clientLinkedMutiselectList['options'] = [];
  1784. $clientLinkedAdvertisers = $this->doctrine->getRepository(AdvertiserInfo::class)->getAdvertiserListByArrToSearch([
  1785. 'advertiserId' => ['value' => $hyperData[$clientId]['Io_numbers'], 'excludeFlag' => false]
  1786. ]);
  1788. if ($clientLinkedAdvertisers) {
  1790. foreach ($clientLinkedAdvertisers as $key => $value) {
  1791. $clientLinkedMutiselectList['options'][] = [
  1792. 'value' => $value['advertiserId'],
  1793. 'label' => $value['advertiserId'] . " - " . $value['company'],
  1794. 'color' => "#e55353"
  1795. ];
  1796. }
  1797. }
  1798. }
  1800. $unlinkedMultiselectList = [];
  1801. $unlinkedMultiselectList['label'] = 'Tune Advertisers Unlinked In HYPER';
  1802. $unlinkedMultiselectList['options'] = [];
  1803. foreach ($unlinedAdvertisers as $key => $value) {
  1804. $unlinkedMultiselectList['options'][] = [
  1805. 'value' => $value['advertiserId'],
  1806. 'label' => $value['advertiserId'] . " - " . $value['company'],
  1807. 'color' => "#3399ff"
  1808. ];
  1809. }
  1811. $finalArr = [$clientLinkedMutiselectList, $unlinkedMultiselectList];
  1813. return new JsonResponse($finalArr);
  1814. }
  1817. /**
  1818. * @Route("/tune-accounts", methods={"GET"})
  1819. */
  1820. public
  1821. function getTuneAccountsAction(Request $request)
  1822. {
  1823. $arr = [];
  1824. foreach (Config::MAFO_SYSTEM_IDENTIFIER_TUNE_ACCOUNTS as $key => $value) {
  1825. $arr[$value] = [
  1826. 'value' => $value,
  1827. 'label' => $value === Config::MAFO_SYSTEM_IDENTIFIER_TUNE_MOBILE ? Config::MAFO_SYSTEM_IDENTIFIER_TUNE_MOBILE_PRETTY : Config::MAFO_SYSTEM_IDENTIFIER_TUNE_WEB_PRETTY,
  1828. ];
  1829. }
  1831. return new JsonResponse(array_values($arr));
  1832. }
  1834. /**
  1835. * @Route("/advertisers-by-tune-account/{keyword}", methods={"GET"})
  1836. */
  1837. public
  1838. function getTuneWebAccountAdvertisersAction(Request $request, $keyword)
  1839. {
  1841. $advertisersByTuneAccount = $this->doctrine->getRepository(AdvertiserInfo::class)->getAdvertisersByTuneAccount([Config::ACTIVE_STATUS], $keyword);
  1843. $advertiserList = [];
  1844. foreach ($advertisersByTuneAccount as $key => $value) {
  1845. $advertiserList[$value['tuneAccount']]['label'] = (Config::MAFO_SYSTEM_IDENTIFIER_PRETTY[$value['tuneAccount']] ?? "") . ' ACCOUNT';
  1846. $advertiserList[$value['tuneAccount']]['options'][$value['advertiserId']] = [
  1847. 'value' => $value['advertiserId'],
  1848. 'label' => $value['advertiserId'] . ' - ' . $value['advertiserName'],
  1849. 'tuneAccount' => $value['tuneAccount'],
  1850. 'color' => Config::MAFO_SYSTEM_IDENTIFIER_TUNE_ACCOUNTS_COLORS[$value['tuneAccount']]
  1851. ];
  1852. ksort($advertiserList[$value['tuneAccount']]['options']);
  1853. }
  1855. $data = [];
  1856. foreach ($advertiserList as $key => $value) {
  1857. $data[] = [
  1858. 'label' => $value['label'],
  1859. 'options' => array_values($value['options']),
  1860. ];
  1861. }
  1863. return new JsonResponse($data);
  1864. }
  1866. /**
  1867. * @Route("/advertisers-by-tune-account", methods={"GET"})
  1868. */
  1869. public
  1870. function getTuneMobileAccountAdvertisersAction(Request $request)
  1871. {
  1873. $advertisersByTuneAccount = $this->doctrine->getRepository(AdvertiserInfo::class)->getAdvertisersByTuneAccount([Config::ACTIVE_STATUS], null);
  1875. $advertiserList = [];
  1876. foreach ($advertisersByTuneAccount as $key => $value) {
  1877. $advertiserList[$value['tuneAccount']]['label'] = (Config::MAFO_SYSTEM_IDENTIFIER_PRETTY[$value['tuneAccount']] ?? "") . ' ACCOUNT';
  1878. $advertiserList[$value['tuneAccount']]['options'][$value['advertiserId']] = [
  1879. 'value' => $value['advertiserId'],
  1880. 'label' => $value['advertiserId'] . ' - ' . $value['advertiserName'],
  1881. 'tuneAccount' => $value['tuneAccount'],
  1882. 'color' => Config::MAFO_SYSTEM_IDENTIFIER_TUNE_ACCOUNTS_COLORS[$value['tuneAccount']]
  1883. ];
  1884. if (sizeof($advertiserList[$value['tuneAccount']]['options']) > 1200) {
  1885. continue;
  1886. }
  1887. ksort($advertiserList[$value['tuneAccount']]['options']);
  1888. }
  1890. $data = [];
  1891. foreach ($advertiserList as $key => $value) {
  1892. $data[] = [
  1893. 'label' => $value['label'],
  1894. 'options' => array_values($value['options']),
  1895. ];
  1896. }
  1898. return new JsonResponse($data);
  1899. }
  1901. /**
  1902. * @Route("/affiliates-by-tune-account/{keyword}", methods={"GET"})
  1903. */
  1904. public
  1905. function getTuneWebAccountAffiliatesAction(Request $request, $keyword)
  1906. {
  1908. $affiliatesByTuneAccount = $this->doctrine->getRepository(AffiliateInfo::class)->getAffiliatesByTuneAccount([Config::ACTIVE_STATUS], $keyword);
  1910. $affiliateList = [];
  1911. foreach ($affiliatesByTuneAccount as $key => $value) {
  1912. $affiliateList[$value['tuneAccount']]['label'] = (Config::MAFO_SYSTEM_IDENTIFIER_PRETTY[$value['tuneAccount']] ?? "") . ' ACCOUNT AFFILIATE IDS';
  1913. $affiliateList[$value['tuneAccount']]['options'][$value['affiliateId']] = [
  1914. 'value' => $value['affiliateId'],
  1915. 'label' => $value['affiliateId'] . ' - ' . $value['affiliateName'],
  1916. 'tuneAccount' => $value['tuneAccount'],
  1917. 'color' => Config::MAFO_SYSTEM_IDENTIFIER_TUNE_ACCOUNTS_COLORS[$value['tuneAccount']] ?? "#000"
  1918. ];
  1919. ksort($affiliateList[$value['tuneAccount']]['options']);
  1920. }
  1922. $data = [];
  1923. foreach ($affiliateList as $key => $value) {
  1924. $data[] = [
  1925. 'label' => $value['label'],
  1926. 'options' => array_values($value['options']),
  1927. ];
  1928. }
  1930. return new JsonResponse($data);
  1931. }
  1934. /**
  1935. * @Route("/saved-report", name="saved_report_get", methods={"GET"})
  1936. */
  1937. public
  1938. function getSavedReportAction(Request $request)
  1939. {
  1940. $reportName = $request->query->get('reportName');
  1942. $data = $this->doctrine->getRepository(SavedReport::class)->getReportByEmailIdAndReportName($this->getUser()->getEmail(), $reportName);
  1944. return new JsonResponse($data);
  1945. }
  1948. /**
  1949. * @Route("/saved-report", name="saved_report_post", methods={"POST"})
  1950. */
  1951. public
  1952. function postSavedReportAction(Request $request)
  1953. {
  1954. $payload = json_decode($request->getContent(), true);
  1956. if (
  1957. !array_key_exists($payload['reportName'], Config::TABLE_COLUMNS_WITH_JSON_FILE) ||
  1958. !is_array($payload['payload']) ||
  1959. !$payload['reportGivenName'] ||
  1960. !$payload['reportPeriod']
  1961. ) {
  1962. return new JsonResponse(false, Config::HTTP_STATUS_CODE_BAD_REQUEST);
  1963. }
  1965. $this->doctrine->getRepository(SavedReport::class)->insert(
  1966. $this->getUser()->getEmail(),
  1967. $payload['reportName'],
  1968. $payload['reportGivenName'],
  1969. $payload['reportPeriod'],
  1970. $payload['payload']
  1971. );
  1973. return new JsonResponse(true);
  1974. }
  1977. /**
  1978. * @Route("/saved-report/{id}", name="saved_report_delete", methods={"DELETE"})
  1979. */
  1980. public
  1981. function deleteSavedReportAction(Request $request, $id)
  1982. {
  1983. $recordExist = $this->doctrine->getRepository(SavedReport::class)->findOneBy([
  1984. 'id' => $id,
  1985. 'savedByEmailId' => $this->getUser()->getEmail()
  1986. ]);
  1988. if ($recordExist) {
  1989. $this->doctrine->getRepository(SavedReport::class)->updateSavedReportDataById($id, [
  1990. 'isDeleted' => 1
  1991. ]);
  1992. }
  1994. return new JsonResponse(true);
  1995. }
  1997. /**
  1998. * @Route("/recommendations", methods={"GET"})
  1999. */
  2000. public
  2001. function getRecommendationsAction(Request $request)
  2002. {
  2003. $objectType = $request->query->get('objectType');
  2004. $objectValue = $request->query->get('objectValue');
  2005. $recommendedObjectType = $request->query->get('recommendedObjectType');
  2007. $recommendedData = $this->machineLearning->getRecommendations($objectType, $objectValue, $recommendedObjectType, Config::MMP_TRACKING_SYSTEM_TUNE);
  2010. return new JsonResponse($recommendedData);
  2011. }
  2013. /**
  2014. * @Route("/new-recommendations", methods={"GET"})
  2015. */
  2016. public
  2017. function getNewRecommendationsAction(Request $request)
  2018. {
  2019. $objectType = $request->query->get('objectType');
  2020. $objectValue = $request->query->get('objectValue');
  2021. $recommendedObjectType = $request->query->get('recommendedObjectType');
  2022. $mmpSource = $request->query->get('mmpSource');
  2024. // $recommendedData = [];
  2025. // if ($objectType == Config::RECOMMENDATIONS_OBJECT_TYPE_OFFER && $recommendedObjectType == Config::RECOMMENDATIONS_OBJECT_TYPE_AFFILIATE) {
  2026. $recommendedData = $this->machineLearning->getRecommendedAffiliatesByOffer($objectValue, $objectType, $mmpSource);
  2027. // }
  2029. return new JsonResponse($recommendedData);
  2030. }
  2032. /**
  2033. * @Route("/advertiser-discount-types", methods={"GET"})
  2034. */
  2035. public
  2036. function getAdvertiserDiscountTypes(Request $request)
  2037. {
  2038. $arr = [];
  2039. foreach (Config::ADVERTISER_DISCOUNT_TYPES as $discountType) {
  2040. $arr[] = [
  2041. 'value' => $discountType,
  2042. 'label' => ucwords(str_replace("_", " ", $discountType))
  2043. ];
  2044. }
  2046. return new JsonResponse($arr);
  2047. }
  2049. /**
  2050. * @Route("/mafo-advertisers", methods={"GET"})
  2051. */
  2052. public
  2053. function getMafoAdvertisersAction(Request $request)
  2054. {
  2055. $showAssociatedAdvertisers = $request->query->get('showAssociatedAdvertisers');
  2056. $showAssociatedAdvertisers = $showAssociatedAdvertisers === '1' ? true : false;
  2058. $accountManagerIds = [];
  2059. if (!in_array(Config::ROLE_ADMIN, $this->getUser()->getRoles()) && $showAssociatedAdvertisers) {
  2060. $childUsersByUser = $this->usersComponents->getChildUsersByUser();
  2061. if (array_key_exists($this->getUser()->getEmail(), $childUsersByUser)) {
  2062. $accountManagerIds = array_values(array_unique(array_merge($accountManagerIds, [$this->getUser()->getRoles()], $childUsersByUser[$this->getUser()->getEmail()])));
  2063. }
  2064. $accountManagerIds[] = $this->getUser()->getEmail();
  2065. }
  2067. $filters = [];
  2068. if ($accountManagerIds) {
  2069. $filters['accountManagerEmail'] = $accountManagerIds;
  2070. }
  2072. $advertisers = $this->doctrine->getRepository(MafoAdvertisers::class)->getAdvertisers($filters, [], Config::REPORTS_PAGINATION_DEFAULT_CSV_PAGE_SIZE, Config::REPORTS_PAGINATION_DEFAULT_PAGE_NUMBER, Config::REPORTS_PAGINATION_DEFAULT_SORT_BY, Config::REPORTS_PAGINATION_DEFAULT_SORT_TYPE);
  2074. $arr = [];
  2075. foreach ($advertisers as $key => $value) {
  2076. $arr[] = [
  2077. 'value' => $value['id'],
  2078. 'label' => $value['id'] . ' - ' . $value['name']
  2079. ];
  2080. }
  2082. return new JsonResponse($arr);
  2083. }
  2085. /**
  2086. * @Route("/mafo-affiliates", methods={"GET"})
  2087. */
  2088. public
  2089. function getMafoAffiliatesAction(Request $request)
  2090. {
  2091. $affiliates = $this->doctrine->getRepository(MafoAffiliates::class)->getAffiliates([], [], Config::REPORTS_PAGINATION_DEFAULT_CSV_PAGE_SIZE, Config::REPORTS_PAGINATION_DEFAULT_PAGE_NUMBER, Config::REPORTS_PAGINATION_DEFAULT_SORT_BY, Config::REPORTS_PAGINATION_DEFAULT_SORT_TYPE);
  2093. $arr = [];
  2094. foreach ($affiliates as $key => $value) {
  2095. $arr[] = [
  2096. 'value' => $value['id'],
  2097. 'label' => $value['id'] . ' - ' . $value['name']
  2098. ];
  2099. }
  2101. return new JsonResponse($arr);
  2102. }
  2104. /**
  2105. * @Route("/mafo-offers", methods={"GET"})
  2106. */
  2107. public
  2108. function getMafoOffersAction(Request $request)
  2109. {
  2110. $offers = $this->doctrine->getRepository(MafoOffers::class)->getOffersList();
  2112. $arr = [];
  2113. foreach ($offers as $key => $value) {
  2114. $arr[] = [
  2115. 'value' => $value['id'],
  2116. 'label' => $value['id'] . ' - ' . $value['name']
  2117. ];
  2118. }
  2120. return new JsonResponse($arr);
  2121. }
  2123. /**
  2124. * @Route("/offer-type", name="get_offer_type", methods={"GET"})
  2125. */
  2126. public function getOfferTypeAction()
  2127. {
  2128. $offerTypes = array_map(function ($type) {
  2129. return [
  2130. 'value' => strtolower($type),
  2131. 'label' => $type
  2132. ];
  2133. }, Config::OFFER_TYPES);
  2135. return new JsonResponse($offerTypes);
  2136. }
  2137. /**
  2138. * @Route("/publisher-list", name="get_publishers_dropdown", methods={"GET"})
  2139. */
  2140. public function getPublishersDropdownAction(Request $request)
  2141. {
  2142. $mappedAffiliateId = $request->query->get('mappedAffiliateId');
  2144. if ($mappedAffiliateId) {
  2145. // Fetch publishers for the given mappedAffiliateId and not deleted
  2146. $data = $this->doctrine->getRepository(MafoPublisherCabinetManager::class)->getPublishersByAffiliateId($mappedAffiliateId);
  2147. } else {
  2148. $data = $this->doctrine->getRepository(MafoPublisherCabinetManager::class)->getAllPublishers();
  2149. }
  2151. $dropdownData = $this->commonCalls->transformToDropdownFormat($data);
  2153. return new JsonResponse($dropdownData);
  2154. }
  2155. }