src/Entity/PostRecord.php line 16

  1. <?php
  3. namespace App\Entity;
  5. use App\Repository\PostRecordRepository;
  6. use App\Traits\Timestamps;
  7. use Doctrine\DBAL\Types\Types;
  8. use Doctrine\ORM\Mapping as ORM;
  10. #[ORM\Entity(repositoryClass: PostRecordRepository::class)]
  11. #[ORM\InheritanceType("SINGLE_TABLE")]
  12. #[ORM\DiscriminatorColumn(name: "discr", type: "string", length: 3)]
  13. #[ORM\DiscriminatorMap(["PST"=> PostRecord::class,"STR"=> StoryRecord::class])]
  14. #[ORM\HasLifecycleCallbacks]
  16. class PostRecord
  17. {
  18.     use Timestamps;
  20.     #[ORM\Id]
  21.     #[ORM\GeneratedValue]
  22.     #[ORM\Column]
  23.     private ?int $id = null;
  25.     #[ORM\ManyToOne(inversedBy: 'postRecords',cascade: ['persist'])]
  26.     #[ORM\JoinColumn(nullable: false, onDelete: "CASCADE")]
  27.     private ?RecordSocialMedia $record = null;
  29.     #[ORM\Column(length: 255, nullable: true)]
  30.     private ?string $type = null;
  32.     #[ORM\Column(type: Types::DATETIME_MUTABLE)]
  33.     private ?\DateTimeInterface $date = null;
  35.     #[ORM\Column(type: Types::TEXT, nullable: true)]
  36.     private ?string $message = null;
  38.     #[ORM\Column(type: Types::TEXT, nullable: true)]
  39.     private ?string $link = null;
  41.     #[ORM\Column(type: Types::TEXT, nullable: true)]
  42.     private ?string $imageLink = null;
  43.     /**
  44.      * @var int|null
  45.      * page_posts_reactions on facebook
  46.      */
  47.     #[ORM\Column(nullable: true)]
  48.     private ?int $likeCount = null;
  50.     #[ORM\Column(nullable: true)]
  51.     private ?int $commentCount = null;
  53.     #[ORM\Column(nullable: true)]
  54.     private ?int $shareCount = null;
  56.     #[ORM\Column(nullable: true)]
  57.     private ?int $engagment = null;
  59.     #[ORM\Column(nullable: true)]
  60.     private ?int $reach = null;
  62.     #[ORM\Column(length: 255, nullable: true)]
  63.     private ?string $reference = null;
  65.     #[ORM\Column(nullable: true)]
  66.     private ?int $twitterQuotes = null;
  67.     //reach
  68.     #[ORM\Column(nullable: true)]
  69.     private ?int $pagePostsImpressionsOrganicUnique = null;
  70.     //reach
  71.     #[ORM\Column(nullable: true)]
  72.     private ?int $pagePostsImpressionsPaidUnique = null;
  73.     //impression (facebook , twitter)
  74.     #[ORM\Column(nullable: true)]
  75.     private ?int $pagePostsImpressionsOrganic = null;
  76.     //impression
  77.     #[ORM\Column(nullable: true)]
  78.     private ?int $pagePostImpressionsPaid = null;
  80.     #[ORM\Column(nullable: true)]
  81.     private ?int $facebookVideoViewsTotal = null;
  83.     #[ORM\Column(nullable: true)]
  84.     private ?int $facebookVideoViewscompleteTotal = null;
  86.     #[ORM\Column(nullable: true)]
  87.     private ?int $facebookVideoViewTime = null;
  89.     #[ORM\Column(nullable: true)]
  90.     private ?int $facebookReelViewsTotal = null;
  92.     #[ORM\Column(nullable: true)]
  93.     private ?int $facebookReelViewsCompleteTotal = null;
  94.     /**
  95.      * @var int|null
  96.      * page_link_video_clicks_count on facebook
  97.      */
  98.     #[ORM\Column(nullable: true)]
  99.     private ?int $pageLinkVideoClicksCount = null;
  101.     #[ORM\Column(nullable: true)]
  102.     private ?int $pagePostsImpressionsUnique = null;
  104.     #[ORM\Column(length: 255, nullable: true)]
  105.     private ?string $totalInteraction = null;
  107.     #[ORM\Column(length: 255, nullable: true)]
  108.     private ?string $pagePostsImpressions = null;
  110.     #[ORM\Column(length: 255, nullable: true)]
  111.     private ?string $tweetsUrlLinkClicks = null;
  113.     #[ORM\Column(length: 255, nullable: true)]
  114.     private ?string $tweetsUserProfileClicks = null;
  116.     #[ORM\Column(length: 255, nullable: true)]
  117.     private ?string $tweetsRetweets = null;
  119.     #[ORM\Column(length: 255, nullable: true)]
  120.     private ?string $saveCount = null;
  122.     #[ORM\Column(nullable: true)]
  123.     private ?int $profilePostVideoViewsTotal = null;
  125.     #[ORM\Column(nullable: true)]
  126.     private ?int $profilePostReplays = null;
  128.     #[ORM\Column(nullable: true)]
  129.     private ?int $profilePostPlays = null;
  131.     #[ORM\Column(nullable: true)]
  132.     private ?int $profilePostReelsViewTotalTime = null;
  133.     //for youtube
  134.     #[ORM\Column(length: 255, nullable: true)]
  135.     private ?string $channelDislikesCount = null;
  136.     //for youtube
  137.     #[ORM\Column(length: 255, nullable: true)]
  138.     private ?string $channelVideosVideoViewCount = null;
  139.     //for youtube
  140.     #[ORM\Column(length: 255, nullable: true)]
  141.     private ?string $channelShortsVideoViewCount = null;
  143.     #[ORM\Column(length: 255, nullable: true)]
  144.     private ?string $facebookVideoViews10s = null;
  146.     #[ORM\Column(length: 255, nullable: true)]
  147.     private ?string $mediaViews = null;
  149.     #[ORM\Column(length: 255, nullable: true)]
  150.     private ?string $tiktokerPostReach = null;
  152.     #[ORM\Column(length: 255, nullable: true)]
  153.     private ?string $tiktokerPostTotalTimeWatched = null;
  156.     public function getId(): ?int
  157.     {
  158.         return $this->id;
  159.     }
  161.     public function getRecord(): ?RecordSocialMedia
  162.     {
  163.         return $this->record;
  164.     }
  166.     public function setRecord(?RecordSocialMedia $record): static
  167.     {
  168.         $this->record = $record;
  170.         return $this;
  171.     }
  173.     public function getType(): ?string
  174.     {
  175.         return $this->type;
  176.     }
  178.     public function setType(?string $type): static
  179.     {
  180.         $this->type = $type;
  182.         return $this;
  183.     }
  185.     public function getDate(): ?\DateTimeInterface
  186.     {
  187.         return $this->date;
  188.     }
  190.     public function setDate(\DateTimeInterface $date): static
  191.     {
  192.         $this->date = $date;
  194.         return $this;
  195.     }
  197.     public function getMessage(): ?string
  198.     {
  199.         return $this->message;
  200.     }
  202.     public function setMessage(?string $message): static
  203.     {
  204.         $this->message = $message;
  206.         return $this;
  207.     }
  209.     public function getLink(): ?string
  210.     {
  211.         return $this->link;
  212.     }
  214.     public function setLink(?string $link): static
  215.     {
  216.         $this->link = $link;
  218.         return $this;
  219.     }
  221.     public function getImageLink(): ?string
  222.     {
  223.         return $this->imageLink;
  224.     }
  226.     public function setImageLink(?string $imageLink): static
  227.     {
  228.         $this->imageLink = $imageLink;
  230.         return $this;
  231.     }
  233.     public function getLikeCount(): ?int
  234.     {
  235.         return $this->likeCount;
  236.     }
  238.     public function setLikeCount(?int $likeCount): static
  239.     {
  240.         $this->likeCount = $likeCount;
  242.         return $this;
  243.     }
  245.     public function getCommentCount(): ?int
  246.     {
  247.         return $this->commentCount;
  248.     }
  250.     public function setCommentCount(?int $commentCount): static
  251.     {
  252.         $this->commentCount = $commentCount;
  254.         return $this;
  255.     }
  257.     public function getShareCount(): ?int
  258.     {
  259.         return $this->shareCount;
  260.     }
  262.     public function setShareCount(?int $shareCount): static
  263.     {
  264.         $this->shareCount = $shareCount;
  266.         return $this;
  267.     }
  269.     public function getEngagment(): ?int
  270.     {
  271.         return $this->engagment;
  272.     }
  274.     public function setEngagment(?int $engagment): static
  275.     {
  276.         $this->engagment = $engagment;
  278.         return $this;
  279.     }
  281.     public function getReach(): ?int
  282.     {
  283.         return $this->reach;
  284.     }
  286.     public function setReach(?int $reach): static
  287.     {
  288.         $this->reach = $reach;
  290.         return $this;
  291.     }
  293.     /**
  294.      * @return int|null
  295.      */
  296.     public function getInteractionSum(): ?int
  297.     {
  298.         return $this->likeCount + $this->commentCount + $this->shareCount + $this->saveCount;
  299.     }
  301.     public function getReference(): ?string
  302.     {
  303.         return $this->reference;
  304.     }
  306.     public function setReference(?string $reference): static
  307.     {
  308.         $this->reference = $reference;
  310.         return $this;
  311.     }
  313.     public function getTwitterQuotes(): ?int
  314.     {
  315.         return $this->twitterQuotes;
  316.     }
  318.     public function setTwitterQuotes(?int $twitterQuotes): static
  319.     {
  320.         $this->twitterQuotes = $twitterQuotes;
  322.         return $this;
  323.     }
  325.     public function getPagePostsImpressionsOrganicUnique(): ?int
  326.     {
  327.         return $this->pagePostsImpressionsOrganicUnique;
  328.     }
  330.     public function setPagePostsImpressionsOrganicUnique(?int $pagePostsImpressionsOrganicUnique): static
  331.     {
  332.         $this->pagePostsImpressionsOrganicUnique = $pagePostsImpressionsOrganicUnique;
  334.         return $this;
  335.     }
  337.     public function getPagePostsImpressionsPaidUnique(): ?int
  338.     {
  339.         return $this->pagePostsImpressionsPaidUnique;
  340.     }
  342.     public function setPagePostsImpressionsPaidUnique(?int $pagePostsImpressionsPaidUnique): static
  343.     {
  344.         $this->pagePostsImpressionsPaidUnique = $pagePostsImpressionsPaidUnique;
  346.         return $this;
  347.     }
  349.     public function getPagePostsImpressionsOrganic(): ?int
  350.     {
  351.         return $this->pagePostsImpressionsOrganic;
  352.     }
  354.     public function setPagePostsImpressionsOrganic(?int $pagePostsImpressionsOrganic): static
  355.     {
  356.         $this->pagePostsImpressionsOrganic = $pagePostsImpressionsOrganic;
  358.         return $this;
  359.     }
  361.     public function getPagePostImpressionsPaid(): ?int
  362.     {
  363.         return $this->pagePostImpressionsPaid;
  364.     }
  366.     public function setPagePostImpressionsPaid(?int $pagePostImpressionsPaid): static
  367.     {
  368.         $this->pagePostImpressionsPaid = $pagePostImpressionsPaid;
  370.         return $this;
  371.     }
  373.     public function getFacebookVideoViewsTotal(): ?int
  374.     {
  375.         return $this->facebookVideoViewsTotal;
  376.     }
  378.     public function setFacebookVideoViewsTotal(?int $facebookVideoViewsTotal): static
  379.     {
  380.         $this->facebookVideoViewsTotal = $facebookVideoViewsTotal;
  382.         return $this;
  383.     }
  385.     public function getFacebookVideoViewscompleteTotal(): ?int
  386.     {
  387.         return $this->facebookVideoViewscompleteTotal;
  388.     }
  390.     public function setFacebookVideoViewscompleteTotal(?int $facebookVideoViewscompleteTotal): static
  391.     {
  392.         $this->facebookVideoViewscompleteTotal = $facebookVideoViewscompleteTotal;
  394.         return $this;
  395.     }
  397.     public function getFacebookVideoViewTime(): ?int
  398.     {
  399.         return $this->facebookVideoViewTime;
  400.     }
  402.     public function setFacebookVideoViewTime(?int $facebookVideoViewTime): static
  403.     {
  404.         $this->facebookVideoViewTime = $facebookVideoViewTime;
  406.         return $this;
  407.     }
  409.     public function getFacebookReelViewsTotal(): ?int
  410.     {
  411.         return $this->facebookReelViewsTotal;
  412.     }
  414.     public function setFacebookReelViewsTotal(?int $facebookReelViewsTotal): static
  415.     {
  416.         $this->facebookReelViewsTotal = $facebookReelViewsTotal;
  418.         return $this;
  419.     }
  421.     public function getFacebookReelViewsCompleteTotal(): ?int
  422.     {
  423.         return $this->facebookReelViewsCompleteTotal;
  424.     }
  426.     public function setFacebookReelViewsCompleteTotal(?int $facebookReelViewsCompleteTotal): static
  427.     {
  428.         $this->facebookReelViewsCompleteTotal = $facebookReelViewsCompleteTotal;
  430.         return $this;
  431.     }
  433.     public function getPageLinkVideoClicksCount(): ?int
  434.     {
  435.         return $this->pageLinkVideoClicksCount;
  436.     }
  438.     public function setPageLinkVideoClicksCount(?int $pageLinkVideoClicksCount): static
  439.     {
  440.         $this->pageLinkVideoClicksCount = $pageLinkVideoClicksCount;
  442.         return $this;
  443.     }
  445.     public function getPagePostsImpressionsUnique(): ?int
  446.     {
  447.         return $this->pagePostsImpressionsUnique;
  448.     }
  450.     public function setPagePostsImpressionsUnique(?int $pagePostsImpressionsUnique): static
  451.     {
  452.         $this->pagePostsImpressionsUnique = $pagePostsImpressionsUnique;
  454.         return $this;
  455.     }
  456.     public function isStory(): bool
  457.     {
  458.         return $this->getType() === 'STORY';
  459.     }
  461.     public function getTotalInteraction(): ?string
  462.     {
  463.         return $this->totalInteraction;
  464.     }
  466.     public function setTotalInteraction(?string $totalInteraction): static
  467.     {
  468.         $this->totalInteraction = $totalInteraction;
  470.         return $this;
  471.     }
  473.     public function getPagePostsImpressions(): ?string
  474.     {
  475.         return $this->pagePostsImpressions;
  476.     }
  478.     public function setPagePostsImpressions(?string $pagePostsImpressions): static
  479.     {
  480.         $this->pagePostsImpressions = $pagePostsImpressions;
  482.         return $this;
  483.     }
  485.     public function getTweetsUrlLinkClicks(): ?string
  486.     {
  487.         return $this->tweetsUrlLinkClicks;
  488.     }
  490.     public function setTweetsUrlLinkClicks(?string $tweetsUrlLinkClicks): static
  491.     {
  492.         $this->tweetsUrlLinkClicks = $tweetsUrlLinkClicks;
  494.         return $this;
  495.     }
  497.     public function getTweetsUserProfileClicks(): ?string
  498.     {
  499.         return $this->tweetsUserProfileClicks;
  500.     }
  502.     public function setTweetsUserProfileClicks(?string $tweetsUserProfileClicks): static
  503.     {
  504.         $this->tweetsUserProfileClicks = $tweetsUserProfileClicks;
  506.         return $this;
  507.     }
  509.     public function getTweetsRetweets(): ?string
  510.     {
  511.         return $this->tweetsRetweets;
  512.     }
  514.     public function setTweetsRetweets(?string $tweetsRetweets): static
  515.     {
  516.         $this->tweetsRetweets = $tweetsRetweets;
  518.         return $this;
  519.     }
  521.     public function getSaveCount(): ?string
  522.     {
  523.         return $this->saveCount;
  524.     }
  526.     public function setSaveCount(?string $saveCount): static
  527.     {
  528.         $this->saveCount = $saveCount;
  530.         return $this;
  531.     }
  532.     public function getProfilePostVideoViewsTotal(): ?int
  533.     {
  534.         return $this->profilePostVideoViewsTotal;
  535.     }
  537.     public function setProfilePostVideoViewsTotal(?int $profilePostVideoViewsTotal): static
  538.     {
  539.         $this->profilePostVideoViewsTotal = $profilePostVideoViewsTotal;
  541.         return $this;
  542.     }
  544.     public function getProfilePostReplays(): ?int
  545.     {
  546.         return $this->profilePostReplays;
  547.     }
  549.     public function setProfilePostReplays(?int $profilePostReplays): static
  550.     {
  551.         $this->profilePostReplays = $profilePostReplays;
  553.         return $this;
  554.     }
  556.     public function getProfilePostPlays(): ?int
  557.     {
  558.         return $this->profilePostPlays;
  559.     }
  561.     public function setProfilePostPlays(?int $profilePostPlays): static
  562.     {
  563.         $this->profilePostPlays = $profilePostPlays;
  565.         return $this;
  566.     }
  568.     public function getProfilePostReelsViewTotalTime(): ?int
  569.     {
  570.         return $this->profilePostReelsViewTotalTime;
  571.     }
  573.     public function setProfilePostReelsViewTotalTime(?int $profilePostReelsViewTotalTime): static
  574.     {
  575.         $this->profilePostReelsViewTotalTime = $profilePostReelsViewTotalTime;
  577.         return $this;
  578.     }
  579.     public function getPagePostsImpressionsOrganicAndPaid():?int
  580.     {
  581.         return $this->getPagePostsImpressionsOrganic() + $this->getPagePostImpressionsPaid();
  582.     }
  584.     /**
  585.      * @return int|string|null
  586.      */
  587.     public function getTwitterInteractions(): int|string|null
  588.     {
  589.         return $this->getLikeCount() + $this->getTweetsUrlLinkClicks() + $this->getTweetsUserProfileClicks() + $this->getTwitterQuotes() + $this->getTweetsRetweets() + $this->getCommentCount();
  590.     }
  592.     public function getChannelDislikesCount(): ?string
  593.     {
  594.         return $this->channelDislikesCount;
  595.     }
  597.     public function setChannelDislikesCount(?string $channelDislikesCount): static
  598.     {
  599.         $this->channelDislikesCount = $channelDislikesCount;
  601.         return $this;
  602.     }
  604.     public function getChannelVideosVideoViewCount(): ?string
  605.     {
  606.         return $this->channelVideosVideoViewCount;
  607.     }
  609.     public function setChannelVideosVideoViewCount(?string $channelVideosVideoViewCount): static
  610.     {
  611.         $this->channelVideosVideoViewCount = $channelVideosVideoViewCount;
  613.         return $this;
  614.     }
  616.     public function getChannelShortsVideoViewCount(): ?string
  617.     {
  618.         return $this->channelShortsVideoViewCount;
  619.     }
  621.     public function setChannelShortsVideoViewCount(?string $channelShortsVideoViewCount): static
  622.     {
  623.         $this->channelShortsVideoViewCount = $channelShortsVideoViewCount;
  625.         return $this;
  626.     }
  627.     public function getTotalInteractionYoutube():?string
  628.     {
  629.         return  $this->channelDislikesCount + $this->likeCount + $this->commentCount;
  630.     }
  631.     public function isShort(): bool
  632.     {
  633.         return $this->getType() === 'SHORTS';
  634.     }
  636.     /**
  637.      * @return int|string|null
  638.      */
  639.     public function getTotalInteractions(): int|string|null
  640.     {
  641.         return match ($this->getRecord()->getNetwork()) {
  642.             SocialMedia::NETWORK_YOUTUBE => $this->getTotalInteractionYoutube(),
  643.             SocialMedia::NETWORK_TWITTER => $this->getTwitterInteractions(),
  644.             default => $this->getLikeCount()+ $this->getShareCount() + $this->getSaveCount()+ $this->getCommentCount()
  645.         };
  646.     }
  648.     /**
  649.      * @return int|null
  650.      */
  651.     public function getSumInstagramEngagement():?int
  652.     {
  653.         return $this->getSaveCount() + $this->getShareCount() + $this->getLikeCount() + $this->getCommentCount();
  654.     }
  656.     /**
  657.      * @return int|null
  658.      */
  659.     public function getTotalEngagement(): ?int
  660.     {
  661.         return match ($this->getRecord()->getNetwork()) {
  662.             SocialMedia::NETWORK_INSTAGRAM => $this->getSumInstagramEngagement(),
  663.             SocialMedia::NETWORK_YOUTUBE => $this->getTotalInteractionYoutube(),
  664.             SocialMedia::NETWORK_TWITTER => $this->getEngagementTwitter(),
  665.             SocialMedia::NETWORK_TIKTOK => $this->getEngagementTiktok(),
  666.             default => $this->getCommentCount() +$this->getShareCount() + $this->getLikeCount() + $this->getPageLinkVideoClicksCount()
  667.         };
  668.     }
  670.     /**
  671.      * @return int|string|null
  672.      */
  673.     public function getEngagementTwitter(): int|string|null
  674.     {
  675.       return $this->getTweetsUrlLinkClicks() + $this->getTweetsUserProfileClicks() + $this->getTweetsRetweets() + $this->getTwitterQuotes() + $this->getLikeCount() + $this->getCommentCount();
  676.     }
  678.     /**
  679.      * @return int|string|null
  680.      */
  681.     public function getTotalImpression(): int|string|null
  682.     {
  683.         return match ($this->getRecord()->getNetwork()) {
  684.             SocialMedia::NETWORK_INSTAGRAM, SocialMedia::NETWORK_YOUTUBE => $this->getPagePostsImpressions(),
  685.             default => $this->getPagePostsImpressionsOrganic() + $this->getPagePostImpressionsPaid(),
  686.         };
  687.     }
  689.     public function getFacebookVideoViews10s(): ?string
  690.     {
  691.         return $this->facebookVideoViews10s;
  692.     }
  694.     public function setFacebookVideoViews10s(?string $facebookVideoViews10s): static
  695.     {
  696.         $this->facebookVideoViews10s = $facebookVideoViews10s;
  698.         return $this;
  699.     }
  700.     public function getMediaViews(): ?string
  701.     {
  702.         return $this->mediaViews;
  703.     }
  705.     public function setMediaViews(?string $mediaViews): static
  706.     {
  707.         $this->mediaViews = $mediaViews;
  709.         return $this;
  710.     }
  712.     public function getTiktokerPostReach(): ?string
  713.     {
  714.         return $this->tiktokerPostReach;
  715.     }
  717.     public function setTiktokerPostReach(?string $tiktokerPostReach): static
  718.     {
  719.         $this->tiktokerPostReach = $tiktokerPostReach;
  721.         return $this;
  722.     }
  724.     public function getTiktokerPostTotalTimeWatched(): ?string
  725.     {
  726.         return $this->tiktokerPostTotalTimeWatched;
  727.     }
  729.     public function setTiktokerPostTotalTimeWatched(?string $tiktokerPostTotalTimeWatched): static
  730.     {
  731.         $this->tiktokerPostTotalTimeWatched = $tiktokerPostTotalTimeWatched;
  733.         return $this;
  734.     }
  736.     public function getEngagementTiktok(): ?int
  737.     {
  738.         return $this->getCommentCount() +$this->getShareCount() + $this->getLikeCount();
  739.     }
  742. }