/**
  * Get document content
  *
  * @param \PhpOffice\PhpPowerpoint\PhpPowerpoint $PhpPowerpoint
  * @param string $writerName
  * @return \PhpOffice\PhpPowerpoint\Tests\XmlDocument
  */
 public static function getDocument(PhpPowerpoint $phpPowerpoint, $writerName = 'PowerPoint2007')
 {
     self::$file = tempnam(sys_get_temp_dir(), 'PhpPowerpoint');
     if (!is_dir(sys_get_temp_dir() . '/PhpPowerpoint_Unit_Test/')) {
         mkdir(sys_get_temp_dir() . '/PhpPowerpoint_Unit_Test/');
     }
     $xmlWriter = IOFactory::createWriter($phpPowerpoint, $writerName);
     $xmlWriter->save(self::$file);
     $zip = new \ZipArchive();
     $res = $zip->open(self::$file);
     if ($res === true) {
         $zip->extractTo(sys_get_temp_dir() . '/PhpPowerpoint_Unit_Test/');
         $zip->close();
     }
     return new XmlDocument(sys_get_temp_dir() . '/PhpPowerpoint_Unit_Test/');
 }
/**
 * Write documents
 *
 * @param \PhpOffice\PhpPowerPoint\PhpPowerPoint $phpPowerPoint
 * @param string $filename
 * @param array $writers
 */
function write($phpPowerPoint, $filename, $writers)
{
    $result = '';
    // Write documents
    foreach ($writers as $writer => $extension) {
        $result .= date('H:i:s') . " Write to {$writer} format";
        if (!is_null($extension)) {
            $xmlWriter = IOFactory::createWriter($phpPowerPoint, $writer);
            $xmlWriter->save(__DIR__ . "/{$filename}.{$extension}");
            rename(__DIR__ . "/{$filename}.{$extension}", __DIR__ . "/results/{$filename}.{$extension}");
        } else {
            $result .= ' ... NOT DONE!';
        }
        $result .= EOL;
    }
    $result .= getEndingNotes($writers);
    return $result;
}
 /**
  * @Route("/api/v1/campaigns/{campaignId}/presentations/final-plan-outcome", name="_create_final_output")
  * @Method("GET")
  *
  * @ApiDoc(
  *      description="Generates the powerpoint presentation for the Final Plan step.",
  *      section="Z_DISABLED",
  *      statusCodes={
  *          200 = "OK. File has been sent as attachment.",
  *          403 = "Invalid API KEY",
  *          500 = {"Header x-wsse does not exist", "Request failed. Final outcome PPTX could not be generated."}
  *      },
  *      requirements={
  *          {"name"="campaignId", "dataType"="string", "description"="Campaign ID for selected campaign."}
  *      }
  * )
  */
 public function createFinalOutputAction($campaignId)
 {
     require_once $this->get('kernel')->getRootDir() . '/../vendor/phpoffice/phppowerpoint/src/PhpPowerpoint/Autoloader.php';
     \PhpOffice\PhpPowerpoint\Autoloader::register();
     // Retrieve campaign data:
     $campaign = $this->getDoctrine()->getRepository('CampaignBundle:Campaign')->find($campaignId);
     // Create a new document instance:
     $finalOutcomeBuilder = new \PhpOffice\PhpPowerpoint\PhpPowerpoint();
     // Set layout information:
     $documentLayout = $finalOutcomeBuilder->getLayout();
     $documentLayout->setDocumentLayout($documentLayout::LAYOUT_SCREEN_16X9);
     #
     #1st slide:
     #
     $currentSlide = $finalOutcomeBuilder->getActiveSlide();
     //Layout:
     $currentSlide->setSlideLayout(Layout::BLANK);
     // Set background color:
     $this->setSlideBackgroundColor($currentSlide);
     // Placeholder for product image:
     $imagePlaceholder = $currentSlide->createRichTextShape();
     $imagePlaceholder->setOffsetX(676)->setOffsetY(215)->setHeight(100)->setWidth(250);
     // Add outline content:
     $imagePlaceholder->createTextRun('Insert product or brand image here')->getFont()->setName('Arial')->setSize(18)->setColor(new Color(Color::COLOR_WHITE));
     // Add logos:
     // Initiative logo:
     $initiativeLogo = $currentSlide->createDrawingShape();
     $initiativeLogo->setPath($this->get('kernel')->getRootDir() . self::INITIATIVE_LOGO_BLUE)->setOffsetX(812)->setoffsetY(487)->setHeight(21)->setWidth(103);
     // Separating line:
     $separateLine = $currentSlide->createLineShape(786, 476, 786, 524);
     $separateLine->getBorder()->setColor(new Color('43BBEF'));
     //Content (first slide):
     //Left hand text:
     $campaignInfoShape = $currentSlide->createRichTextShape();
     $campaignInfoShape->setHeight(133)->setWidth(500)->setOffsetX(0)->setOffsetY(282);
     // Set fill:
     $fill = new Fill();
     $fill->setFillType(Fill::FILL_SOLID)->setStartColor(new Color('43BBEF'));
     $campaignInfoShape->setFill($fill);
     //Text:
     $firstP = $campaignInfoShape->getActiveParagraph();
     $firstP->createTextRun($campaign->getName())->getFont()->setName('KG Second Chances Sketch')->setSize(32)->setColor(new Color(Color::COLOR_WHITE));
     $secondP = $campaignInfoShape->createParagraph();
     $secondP->createTextRun('Planning Cycle - ' . $campaign->getBrand()->getName())->getFont()->setName('KG Second Chances Sketch')->setSize(18)->setColor(new Color(Color::COLOR_WHITE));
     $thirdP = $campaignInfoShape->createParagraph();
     $thirdP->createTextRun($campaign->getCountry()->getName())->getFont()->setName('KG Second Chances Sketch')->setSize(29)->setColor(new Color(Color::COLOR_WHITE));
     #
     #2nd slide:
     #
     $currentSlide = $finalOutcomeBuilder->createSlide()->setSlideLayout('black');
     //Layout:
     $currentSlide->setSlideLayout(Layout::BLANK);
     // Set background color:
     $this->setSlideBackgroundColor($currentSlide);
     // Placeholder for portrait image:
     $portraitPlaceholder = $currentSlide->createRichTextShape();
     $portraitPlaceholder->setOffsetX(676)->setOffsetY(215)->setHeight(100)->setWidth(250);
     // Add outline content:
     $portraitPlaceholder->createTextRun('Insert portrait here')->getFont()->setName('Arial')->setSize(18)->setColor(new Color(Color::COLOR_WHITE));
     //Content:
     // Determine circle:
     $determineCircle = $currentSlide->createDrawingShape();
     $determineCircle->setPath($this->get('kernel')->getRootDir() . self::GALLERY_DIRECTORY . '/circle_determine_tasks.png')->setOffsetX(19)->setoffsetY(0)->setHeight(402)->setWidth(520);
     #
     #3rd slide:
     #
     $currentSlide = $finalOutcomeBuilder->createSlide();
     //Layout:
     $currentSlide->setSlideLayout(Layout::BLANK);
     // Add title coordinates:
     $titleShape = $currentSlide->createRichTextShape();
     $titleShape->setOffsetX(50)->setOffsetY(50)->setHeight(94)->setWidth(880);
     // Add title content:
     $titleShape->createTextRun('JTBD Simplified')->getFont()->setName('KG Second Chances Sketch')->setSize(30)->setColor(new Color('43BBEF'));
     // Add logos:
     // Initiative logo:
     $initiativeLogo = $currentSlide->createDrawingShape();
     $initiativeLogo->setPath($this->get('kernel')->getRootDir() . self::INITIATIVE_LOGO_BLUE)->setOffsetX(812)->setoffsetY(487)->setHeight(21)->setWidth(103);
     // Separating line:
     $separateLine = $currentSlide->createLineShape(786, 476, 786, 524);
     $separateLine->getBorder()->setColor(new Color('43BBEF'));
     //Content:
     //Brief outline:
     $outlineShape = $currentSlide->createRichTextShape();
     $outlineShape->setOffsetX(46)->setOffsetY(100)->setHeight(219)->setWidth(823);
     // Add outline content:
     $outlineShape->createTextRun('What you really asked us:')->getFont()->setName('DINbek Bold')->setSize(16)->setColor(new Color('43BBEF'));
     $outlineShape->createBreak();
     $outlineShape->createTextRun($campaign->getBriefOutline() ? $campaign->getBriefOutline() : 'Brief outline for the campaign here.')->getFont()->setName('DINbek Bold')->setSize(14)->setColor(new Color('676363'));
     //Circles content:
     // Retrieve info from database:
     $lightDataId = $campaign->getLightdata();
     $lightDataEntity = $this->getDoctrine()->getRepository('LightdataBundle:Lightdata')->findOneById($lightDataId);
     //Three circles:
     //1st Circle:
     $budgetCircle = $currentSlide->createDrawingShape();
     $budgetCircle->setPath($this->get('kernel')->getRootDir() . self::GALLERY_DIRECTORY . '/jtbd_budget.png')->setOffsetX(48)->setoffsetY(193)->setHeight(289)->setWidth(293);
     //Budget circle content:
     if (!empty($lightDataEntity)) {
         $campaignBudget = $lightDataEntity->getSetup()->getBudget() ? number_format($lightDataEntity->getSetup()->getBudget() / 1000, 0) . 'm' : 'BUDGET';
         $campaignBudgetCurrency = $lightDataEntity->getSetup()->getBudgetCurrency() ? $lightDataEntity->getSetup()->getBudgetCurrency() : 'CURRENCY';
         $campaignStartDate = $lightDataEntity->getSetup()->getStartDate() ? date('M Y', $lightDataEntity->getSetup()->getStartDate()->getTimestamp()) : 'START DATE';
         //Campaign period:
         if ($lightDataEntity->getSetup()->getNbperiods()) {
             $campaignPeriodInDays = $lightDataEntity->getSetup()->getNbperiods() * 7;
             $endDate = $lightDataEntity->getSetup()->getStartDate();
             $endDate->modify('+' . $campaignPeriodInDays . ' day');
         }
         // End of campaign period If.
     } else {
         $campaignBudget = 'BUDGET';
         $campaignBudgetCurrency = 'CURRENCY';
         $campaignStartDate = 'START DATE';
         $endDate = FALSE;
     }
     // End of content IF.
     $campaignEndDate = $endDate ? date('M Y', $endDate->getTimestamp()) : 'END DATE';
     // Input content in paragraphs:
     $budgetCircleText = $currentSlide->createRichTextShape();
     $budgetCircleText->setOffsetX(100)->setOffsetY(300)->setHeight(100)->setWidth(230);
     $firstP = $budgetCircleText->getActiveParagraph();
     $firstP->createTextRun('  ')->getFont()->setName('KG Second Chances Solid')->setSize(14)->setColor(new Color(Color::COLOR_WHITE));
     $secondP = $budgetCircleText->createParagraph();
     $secondP->createTextRun($campaignBudget . ' ' . $campaignBudgetCurrency)->getFont()->setName('KG Second Chances Solid')->setSize(14)->setColor(new Color(Color::COLOR_WHITE));
     $thirdP = $budgetCircleText->createParagraph();
     $thirdP->createTextRun($campaignStartDate . ' - ' . $campaignEndDate)->getFont()->setName('KG Second Chances Solid')->setSize(14)->setColor(new Color(Color::COLOR_WHITE));
     //2nd circle:
     $goalsCircle = $currentSlide->createDrawingShape();
     $goalsCircle->setPath($this->get('kernel')->getRootDir() . self::GALLERY_DIRECTORY . '/jtbd_goals_pressure_test.png')->setOffsetX(333)->setoffsetY(194)->setHeight(289)->setWidth(293);
     //Goals circle content:
     $brandShare = $campaign->getMmoBrandshare() ? $campaign->getMmoBrandshare() * 100 . ' BPS' : 'SHARE';
     $penetration = $campaign->getMmoPenetration() ? $campaign->getMmoPenetration() * 100 . ' BPS' : 'PENETRATION';
     //Input content in paragraphs:
     $goalsCircleText = $currentSlide->createRichTextShape();
     $goalsCircleText->setOffsetX(370)->setOffsetY(300)->setHeight(100)->setWidth(240);
     $firstP = $goalsCircleText->getActiveParagraph();
     $firstP->createTextRun('Brand share: ' . $brandShare)->getFont()->setName('KG Second Chances Solid')->setSize(14)->setColor(new Color(Color::COLOR_WHITE));
     $secondP = $goalsCircleText->createParagraph();
     $secondP->createTextRun('Penetration: ' . $penetration)->getFont()->setName('KG Second Chances Solid')->setSize(14)->setColor(new Color(Color::COLOR_WHITE));
     $thirdP = $goalsCircleText->createParagraph();
     $thirdP->createTextRun('% of Target needed: ')->getFont()->setName('KG Second Chances Solid')->setSize(14)->setColor(new Color(Color::COLOR_WHITE));
     //3rd circle:
     $coverageCircle = $currentSlide->createDrawingShape();
     $coverageCircle->setPath($this->get('kernel')->getRootDir() . self::GALLERY_DIRECTORY . '/jtbd_coverage_pressure_test.png')->setOffsetX(619)->setoffsetY(193)->setHeight(289)->setWidth(293);
     //Coverage circle content:
     // //Input content in paragraphs:
     // $coverageCircleText = $currentSlide->createRichTextShape();
     // $coverageCircleText->setOffsetX(680)
     //               ->setOffsetY(300)
     //               ->setHeight(100)
     //               ->setWidth(200);
     //  $firstP = $coverageCircleText->getActiveParagraph();
     //  $firstP->createTextRun('SOV/SOM: ')
     //          ->getFont()->setName('KG Second Chances Solid')
     //                     ->setSize(14)
     //                     ->setColor(new Color(Color::COLOR_WHITE));
     //  $secondP = $coverageCircleText->createParagraph();
     //  $secondP->createTextRun('Video GRPs: ')
     //          ->getFont()->setName('KG Second Chances Solid')
     //                     ->setSize(14)
     //                     ->setColor(new Color(Color::COLOR_WHITE));
     //  $thirdP = $coverageCircleText->createParagraph();
     //  $thirdP->createTextRun('Weeks: ')
     //          ->getFont()->setName('KG Second Chances Solid')
     //                     ->setSize(14)
     //                     ->setColor(new Color(Color::COLOR_WHITE));
     #
     #4th slide:
     #
     $currentSlide = $finalOutcomeBuilder->createSlide();
     //Layout:
     $currentSlide->setSlideLayout(Layout::BLANK);
     // Add title coordinates:
     $titleShape = $currentSlide->createRichTextShape();
     $titleShape->setOffsetX(50)->setOffsetY(50)->setHeight(94)->setWidth(880);
     // Add title content:
     $titleShape->createTextRun('Market summary')->getFont()->setName('KG Second Chances Sketch')->setSize(30)->setColor(new Color('43BBEF'));
     // Placeholder 1st text:
     $firstTextPlaceholder = $currentSlide->createRichTextShape();
     $firstTextPlaceholder->setOffsetX(150)->setOffsetY(200)->setHeight(400)->setWidth(300);
     // Add outline content:
     $firstTextPlaceholder->createTextRun('Insert text here')->getFont()->setName('Arial')->setSize(18)->setColor(new Color(Color::COLOR_BLACK));
     // Placeholder 2nd text:
     $secondTextPlaceholder = $currentSlide->createRichTextShape();
     $secondTextPlaceholder->setOffsetX(500)->setOffsetY(200)->setHeight(400)->setWidth(300);
     // Add outline content:
     $secondTextPlaceholder->createTextRun('Insert text here')->getFont()->setName('Arial')->setSize(18)->setColor(new Color(Color::COLOR_BLACK));
     // Add logos:
     // Initiative logo:
     $initiativeLogo = $currentSlide->createDrawingShape();
     $initiativeLogo->setPath($this->get('kernel')->getRootDir() . self::INITIATIVE_LOGO_BLUE)->setOffsetX(812)->setoffsetY(487)->setHeight(21)->setWidth(103);
     // Separating line:
     $separateLine = $currentSlide->createLineShape(786, 476, 786, 524);
     $separateLine->getBorder()->setColor(new Color('43BBEF'));
     #
     #5th slide:
     #
     $currentSlide = $finalOutcomeBuilder->createSlide();
     //Layout:
     $currentSlide->setSlideLayout(Layout::BLANK);
     // Add title coordinates:
     $titleShape = $currentSlide->createRichTextShape();
     $titleShape->setOffsetX(50)->setOffsetY(50)->setHeight(94)->setWidth(880);
     // Add title content:
     $titleShape->createTextRun('Strategic Clarity')->getFont()->setName('KG Second Chances Sketch')->setSize(30)->setColor(new Color('43BBEF'));
     // Add logos:
     // Initiative logo:
     $initiativeLogo = $currentSlide->createDrawingShape();
     $initiativeLogo->setPath($this->get('kernel')->getRootDir() . self::INITIATIVE_LOGO_BLUE)->setOffsetX(812)->setoffsetY(487)->setHeight(21)->setWidth(103);
     // Separating line:
     $separateLine = $currentSlide->createLineShape(786, 476, 786, 524);
     $separateLine->getBorder()->setColor(new Color('43BBEF'));
     #
     #6th slide:
     #
     $currentSlide = $finalOutcomeBuilder->createSlide();
     //Layout:
     $currentSlide->setSlideLayout(Layout::BLANK);
     // Add title coordinates:
     $titleShape = $currentSlide->createRichTextShape();
     $titleShape->setOffsetX(50)->setOffsetY(50)->setHeight(94)->setWidth(880);
     // Add title content:
     $titleShape->createTextRun('We need communications to deliver')->getFont()->setName('KG Second Chances Sketch')->setSize(30)->setColor(new Color('43BBEF'));
     // Placeholder for copy:
     $copyPlaceholder = $currentSlide->createRichTextShape();
     $copyPlaceholder->setOffsetX(100)->setOffsetY(150)->setHeight(400)->setWidth(300);
     // Add copy default text:
     $copyPlaceholder->createTextRun('Copy goes here')->getFont()->setName('Arial')->setSize(18)->setColor(new Color(Color::COLOR_BLACK));
     // Add logos:
     // Initiative logo:
     $initiativeLogo = $currentSlide->createDrawingShape();
     $initiativeLogo->setPath($this->get('kernel')->getRootDir() . self::INITIATIVE_LOGO_BLUE)->setOffsetX(812)->setoffsetY(487)->setHeight(21)->setWidth(103);
     // Separating line:
     $separateLine = $currentSlide->createLineShape(786, 476, 786, 524);
     $separateLine->getBorder()->setColor(new Color('43BBEF'));
     //Content:
     //Communication graph:
     //Chart database data:
     $taskName = $this->getDoctrine()->getRepository('TaskBundle:Taskname')->findOneById(TaskType::TYPE_COMM_TASKS);
     $taskQuery = $this->getDoctrine()->getRepository('TaskBundle:Task')->createQueryBuilder('t')->where('t.campaign = :campaign AND t.taskname = :taskName')->setParameter('campaign', $campaign)->setParameter('taskName', $taskName)->getQuery();
     $task = $taskQuery->getOneOrNullResult();
     $fileType = $this->getDoctrine()->getRepository('CampaignBundle:Filetype')->findOneById(11);
     $fileQuery = $this->getDoctrine()->getRepository('FileBundle:File')->createQueryBuilder('f')->where('f.task = :task AND f.fileType = :fileType')->orderBy('f.updatedAt', 'DESC')->setMaxResults(1)->setParameter('task', $task)->setParameter('fileType', $fileType)->getQuery();
     $file = $fileQuery->getOneOrNullResult();
     // Check if file to be inserted exists:
     if (!empty($file)) {
         $commGraph = $currentSlide->createDrawingShape();
         // $commGraph->setPath($this->get('kernel')->getRootDir() . self::GALLERY_DIRECTORY . '/graph_communications.png')
         $commGraph->setPath($file->getPath())->setOffsetX(389)->setOffsetY(115)->setHeight(221)->setWidth(521);
     }
     // End of "Notice and talk about graph" IF.
     #
     #7th slide:
     #
     $currentSlide = $finalOutcomeBuilder->createSlide();
     //Layout:
     $currentSlide->setSlideLayout(Layout::BLANK);
     // Set background color:
     $this->setSlideBackgroundColor($currentSlide);
     // Placeholder for portrait image:
     $portraitPlaceholder = $currentSlide->createRichTextShape();
     $portraitPlaceholder->setOffsetX(676)->setOffsetY(215)->setHeight(100)->setWidth(250);
     // Add outline content:
     $portraitPlaceholder->createTextRun('Insert portrait here')->getFont()->setName('Arial')->setSize(18)->setColor(new Color(Color::COLOR_WHITE));
     //Content:
     // Determine circle:
     $determineCircle = $currentSlide->createDrawingShape();
     $determineCircle->setPath($this->get('kernel')->getRootDir() . self::GALLERY_DIRECTORY . '/circle_design_tasks.png')->setOffsetX(19)->setoffsetY(5)->setHeight(402)->setWidth(535);
     #
     #8th slide:
     #
     $currentSlide = $finalOutcomeBuilder->createSlide();
     //Layout:
     $currentSlide->setSlideLayout(Layout::BLANK);
     // Set background color:
     $this->setSlideBackgroundColor($currentSlide);
     // Add title coordinates:
     $titleShape = $currentSlide->createRichTextShape();
     $titleShape->setOffsetX(50)->setOffsetY(50)->setHeight(94)->setWidth(880);
     // Add title content:
     $titleShape->createTextRun('Real Lives: Their values and lifestyle')->getFont()->setName('KG Second Chances Sketch')->setSize(24)->setColor(new Color('43BBEF'));
     // Add logos:
     // Initiative logo:
     $initiativeLogo = $currentSlide->createDrawingShape();
     $initiativeLogo->setPath($this->get('kernel')->getRootDir() . self::INITIATIVE_LOGO_BLUE)->setOffsetX(812)->setoffsetY(487)->setHeight(21)->setWidth(103);
     // Separating line:
     $separateLine = $currentSlide->createLineShape(786, 476, 786, 524);
     $separateLine->getBorder()->setColor(new Color('43BBEF'));
     //Content
     //Real Lives image 01:
     //Image database data:
     $taskName = $this->getDoctrine()->getRepository('TaskBundle:Taskname')->findOneById(TaskType::TYPE_REAL_LIVES);
     $taskQuery = $this->getDoctrine()->getRepository('TaskBundle:Task')->createQueryBuilder('t')->where('t.campaign = :campaign AND t.taskname = :taskName')->setParameter('campaign', $campaign)->setParameter('taskName', $taskName)->getQuery();
     $task = $taskQuery->getOneOrNullResult();
     $fileType = $this->getDoctrine()->getRepository('CampaignBundle:Filetype')->findOneById(18);
     $fileQuery = $this->getDoctrine()->getRepository('FileBundle:File')->createQueryBuilder('f')->where('f.task = :task AND f.fileType = :fileType')->orderBy('f.updatedAt', 'DESC')->setMaxResults(1)->setParameter('task', $task)->setParameter('fileType', $fileType)->getQuery();
     $file = $fileQuery->getOneOrNullResult();
     // Check if file to be inserted exists:
     if (!empty($file)) {
         $realLivesImage = $currentSlide->createDrawingShape();
         // $commGraph->setPath($this->get('kernel')->getRootDir() . self::GALLERY_DIRECTORY . '/graph_communications.png')
         $realLivesImage->setPath($file->getPath())->setOffsetX(50)->setOffsetY(115)->setHeight(221)->setWidth(521);
     }
     // End of "Real Lives image 01" IF.
     #
     #9th slide:
     #
     $currentSlide = $finalOutcomeBuilder->createSlide();
     //Layout:
     $currentSlide->setSlideLayout(Layout::BLANK);
     // Set background color:
     $this->setSlideBackgroundColor($currentSlide);
     // Add title coordinates:
     $titleShape = $currentSlide->createRichTextShape();
     $titleShape->setOffsetX(50)->setOffsetY(50)->setHeight(94)->setWidth(880);
     // Add title content:
     $titleShape->createTextRun('Real Lives: The brand in their lives')->getFont()->setName('KG Second Chances Sketch')->setSize(24)->setColor(new Color('43BBEF'));
     // Add logos:
     // Initiative logo:
     $initiativeLogo = $currentSlide->createDrawingShape();
     $initiativeLogo->setPath($this->get('kernel')->getRootDir() . self::INITIATIVE_LOGO_BLUE)->setOffsetX(812)->setoffsetY(487)->setHeight(21)->setWidth(103);
     // Separating line:
     $separateLine = $currentSlide->createLineShape(786, 476, 786, 524);
     $separateLine->getBorder()->setColor(new Color('43BBEF'));
     //Content
     //Real Lives image 02:
     //Image database data:
     $taskName = $this->getDoctrine()->getRepository('TaskBundle:Taskname')->findOneById(TaskType::TYPE_REAL_LIVES);
     $taskQuery = $this->getDoctrine()->getRepository('TaskBundle:Task')->createQueryBuilder('t')->where('t.campaign = :campaign AND t.taskname = :taskName')->setParameter('campaign', $campaign)->setParameter('taskName', $taskName)->getQuery();
     $task = $taskQuery->getOneOrNullResult();
     $fileType = $this->getDoctrine()->getRepository('CampaignBundle:Filetype')->findOneById(19);
     $fileQuery = $this->getDoctrine()->getRepository('FileBundle:File')->createQueryBuilder('f')->where('f.task = :task AND f.fileType = :fileType')->orderBy('f.updatedAt', 'DESC')->setMaxResults(1)->setParameter('task', $task)->setParameter('fileType', $fileType)->getQuery();
     $file = $fileQuery->getOneOrNullResult();
     // Check if file to be inserted exists:
     if (!empty($file)) {
         $realLivesImage = $currentSlide->createDrawingShape();
         // $commGraph->setPath($this->get('kernel')->getRootDir() . self::GALLERY_DIRECTORY . '/graph_communications.png')
         $realLivesImage->setPath($file->getPath())->setOffsetX(50)->setOffsetY(115)->setHeight(221)->setWidth(521);
     }
     // End of "Real Lives image 01" IF.
     #
     #10th slide:
     #
     $currentSlide = $finalOutcomeBuilder->createSlide();
     //Layout:
     $currentSlide->setSlideLayout(Layout::BLANK);
     // Set background color:
     $this->setSlideBackgroundColor($currentSlide);
     // Add title coordinates:
     $titleShape = $currentSlide->createRichTextShape();
     $titleShape->setOffsetX(0)->setOffsetY(70)->setHeight(35)->setWidth(958);
     $titleShape->getActiveParagraph()->getAlignment()->setHorizontal(Alignment::HORIZONTAL_CENTER);
     // Add title content:
     $titleShape->createTextRun('The idea')->getFont()->setName('KG Second Chances Sketch')->setSize(30)->setColor(new Color(Color::COLOR_WHITE));
     // Add logos:
     // Initiative logo:
     $initiativeLogo = $currentSlide->createDrawingShape();
     $initiativeLogo->setPath($this->get('kernel')->getRootDir() . self::INITIATIVE_LOGO_BLUE)->setOffsetX(812)->setoffsetY(487)->setHeight(21)->setWidth(103);
     // Separating line:
     $separateLine = $currentSlide->createLineShape(786, 476, 786, 524);
     $separateLine->getBorder()->setColor(new Color('43BBEF'));
     //Content:
     //Content values:
     $ideaTitle = $campaign->getCampaignideatitle() ? $campaign->getCampaignideatitle() : 'Idea title';
     $ideaDescription = $campaign->getCampaignidea() ? $campaign->getCampaignidea() : 'Idea description';
     //Idea title coordinates
     $ideaTitleShape = $currentSlide->createRichTextShape();
     $ideaTitleShape->setOffsetX(0)->setOffsetY(140)->setHeight(35)->setWidth(958);
     $ideaTitleShape->getActiveParagraph()->getAlignment()->setHorizontal(Alignment::HORIZONTAL_CENTER);
     //Idea title content:
     $ideaTitleShape->createTextRun($ideaTitle)->getFont()->setName('Arial')->setSize(18)->setColor(new Color('43BBEF'));
     //Idea description coordinates:
     $ideaDescriptionShape = $currentSlide->createRichTextShape();
     $ideaDescriptionShape->setOffsetX(55)->setOffsetY(200)->setHeight(219)->setWidth(850);
     //Idea description content:
     $ideaDescriptionShape->createTextRun($ideaDescription)->getFont()->setName('Arial')->setSize(16)->setColor(new Color(Color::COLOR_WHITE));
     #
     #11th slide:
     #
     $currentSlide = $finalOutcomeBuilder->createSlide();
     //Layout:
     $currentSlide->setSlideLayout(Layout::BLANK);
     // Add title coordinates:
     $titleShape = $currentSlide->createRichTextShape();
     $titleShape->setOffsetX(50)->setOffsetY(50)->setHeight(94)->setWidth(880);
     // Add title content:
     $titleShape->createTextRun('The fundamental channels')->getFont()->setName('KG Second Chances Sketch')->setSize(30)->setColor(new Color('43BBEF'));
     // Text placeholder:
     $textPlaceholder = $currentSlide->createRichTextShape();
     $textPlaceholder->setOffsetX(600)->setOffsetY(200)->setHeight(400)->setWidth(300);
     // Text placeholder default content:
     $textPlaceholder->createTextRun('Insert text here')->getFont()->setName('Arial')->setSize(18)->setColor(new Color(Color::COLOR_BLACK));
     // Add logos:
     // Initiative logo:
     $initiativeLogo = $currentSlide->createDrawingShape();
     $initiativeLogo->setPath($this->get('kernel')->getRootDir() . self::INITIATIVE_LOGO_BLUE)->setOffsetX(812)->setoffsetY(487)->setHeight(21)->setWidth(103);
     // Separating line:
     $separateLine = $currentSlide->createLineShape(786, 476, 786, 524);
     $separateLine->getBorder()->setColor(new Color('43BBEF'));
     //Content
     //Channels graph (Touchpoint shortlist):
     //Chart database data:
     $taskName = $this->getDoctrine()->getRepository('TaskBundle:Taskname')->findOneById(TaskType::TYPE_TOUCHPOINT_SHORT);
     $taskQuery = $this->getDoctrine()->getRepository('TaskBundle:Task')->createQueryBuilder('t')->where('t.campaign = :campaign AND t.taskname = :taskName')->setParameter('campaign', $campaign)->setParameter('taskName', $taskName)->getQuery();
     $task = $taskQuery->getSingleResult();
     $fileType = $this->getDoctrine()->getRepository('CampaignBundle:Filetype')->findOneById(11);
     $fileQuery = $this->getDoctrine()->getRepository('FileBundle:File')->createQueryBuilder('f')->where('f.task = :task AND f.fileType = :fileType')->orderBy('f.updatedAt', 'DESC')->setMaxResults(1)->setParameter('task', $task)->setParameter('fileType', $fileType)->getQuery();
     $file = $fileQuery->getOneOrNullResult();
     // Check if file to be inserted exists:
     if (!empty($file)) {
         $channelsGraph = $currentSlide->createDrawingShape();
         // $channelsGraph->setPath($this->get('kernel')->getRootDir() . self::GALLERY_DIRECTORY . '/graph_fundamental_channels.png')
         $channelsGraph->setPath($file->getPath())->setOffsetX(50)->setoffsetY(120)->setHeight(347)->setWidth(544);
     }
     // End of "Touchpoint shortlist graph" IF.
     #
     #12th slide:
     #
     $currentSlide = $finalOutcomeBuilder->createSlide();
     //Layout:
     $currentSlide->setSlideLayout(Layout::BLANK);
     // Add title coordinates:
     $titleShape = $currentSlide->createRichTextShape();
     $titleShape->setOffsetX(50)->setOffsetY(50)->setHeight(94)->setWidth(880);
     // Add title content:
     $titleShape->createTextRun('Budget allocation')->getFont()->setName('KG Second Chances Sketch')->setSize(30)->setColor(new Color('43BBEF'));
     // Add logos:
     // Initiative logo:
     $initiativeLogo = $currentSlide->createDrawingShape();
     $initiativeLogo->setPath($this->get('kernel')->getRootDir() . self::INITIATIVE_LOGO_BLUE)->setOffsetX(812)->setoffsetY(487)->setHeight(21)->setWidth(103);
     // Separating line:
     $separateLine = $currentSlide->createLineShape(786, 476, 786, 524);
     $separateLine->getBorder()->setColor(new Color('43BBEF'));
     //Content
     //Optimal Budget Allocation graph:
     //Chart database data:
     $taskName = $this->getDoctrine()->getRepository('TaskBundle:Taskname')->findOneById(TaskType::TYPE_BUDGET_ALLOC);
     $taskQuery = $this->getDoctrine()->getRepository('TaskBundle:Task')->createQueryBuilder('t')->where('t.campaign = :campaign AND t.taskname = :taskName')->setParameter('campaign', $campaign)->setParameter('taskName', $taskName)->getQuery();
     $task = $taskQuery->getSingleResult();
     $fileType = $this->getDoctrine()->getRepository('CampaignBundle:Filetype')->findOneById(2);
     $fileQuery = $this->getDoctrine()->getRepository('FileBundle:File')->createQueryBuilder('f')->where('f.task = :task AND f.fileType = :fileType')->orderBy('f.updatedAt', 'DESC')->setMaxResults(1)->setParameter('task', $task)->setParameter('fileType', $fileType)->getQuery();
     $file = $fileQuery->getOneOrNullResult();
     // Check if file to be inserted exists:
     if (!empty($file)) {
         $optimalBudgetGraph = $currentSlide->createDrawingShape();
         // $optimalBudgetGraph->setPath($this->get('kernel')->getRootDir() . self::GALLERY_DIRECTORY . '/graph_optimal_budget_allocation.png')
         $optimalBudgetGraph->setPath($file->getPath())->setOffsetX(250)->setoffsetY(120)->setHeight(347)->setWidth(544);
     }
     // End of "Optimal budget allocation graph" IF.
     //Video neutral image:
     //Chart database data:
     $taskName = $this->getDoctrine()->getRepository('TaskBundle:Taskname')->findOneById(TaskType::TYPE_BUDGET_ALLOC);
     $taskQuery = $this->getDoctrine()->getRepository('TaskBundle:Task')->createQueryBuilder('t')->where('t.campaign = :campaign AND t.taskname = :taskName')->setParameter('campaign', $campaign)->setParameter('taskName', $taskName)->getQuery();
     $task = $taskQuery->getSingleResult();
     $fileType = $this->getDoctrine()->getRepository('CampaignBundle:Filetype')->findOneById(17);
     $fileQuery = $this->getDoctrine()->getRepository('FileBundle:File')->createQueryBuilder('f')->where('f.task = :task AND f.fileType = :fileType')->orderBy('f.updatedAt', 'DESC')->setMaxResults(1)->setParameter('task', $task)->setParameter('fileType', $fileType)->getQuery();
     $file = $fileQuery->getOneOrNullResult();
     // Check if file to be inserted exists:
     if (!empty($file)) {
         $optimalBudgetGraph = $currentSlide->createDrawingShape();
         // $optimalBudgetGraph->setPath($this->get('kernel')->getRootDir() . self::GALLERY_DIRECTORY . '/graph_optimal_budget_allocation.png')
         $optimalBudgetGraph->setPath($file->getPath())->setOffsetX(50)->setoffsetY(120)->setHeight(347)->setWidth(544);
     }
     // End of "Video neutral image" IF.
     #
     #13th slide:
     #
     $currentSlide = $finalOutcomeBuilder->createSlide();
     //Layout:
     $currentSlide->setSlideLayout(Layout::BLANK);
     // Set background color:
     $this->setSlideBackgroundColor($currentSlide);
     // Add title coordinates:
     $titleShape = $currentSlide->createRichTextShape();
     $titleShape->setOffsetX(50)->setOffsetY(50)->setHeight(94)->setWidth(880);
     // Add title content:
     $titleShape->createTextRun('The Brand Experience')->getFont()->setName('KG Second Chances Sketch')->setSize(30)->setColor(new Color('43BBEF'));
     // Add logos:
     // Initiative logo:
     $initiativeLogo = $currentSlide->createDrawingShape();
     $initiativeLogo->setPath($this->get('kernel')->getRootDir() . self::INITIATIVE_LOGO_BLUE)->setOffsetX(812)->setoffsetY(487)->setHeight(21)->setWidth(103);
     // Separating line:
     $separateLine = $currentSlide->createLineShape(786, 476, 786, 524);
     $separateLine->getBorder()->setColor(new Color('43BBEF'));
     #
     #14th slide:
     #
     $currentSlide = $finalOutcomeBuilder->createSlide();
     //Layout:
     $currentSlide->setSlideLayout(Layout::BLANK);
     // Add title coordinates:
     $titleShape = $currentSlide->createRichTextShape();
     $titleShape->setOffsetX(50)->setOffsetY(50)->setHeight(94)->setWidth(880);
     // Add title content:
     $titleShape->createTextRun('Scorecard slide - Please insert custom title')->getFont()->setName('KG Second Chances Sketch')->setSize(20)->setColor(new Color('43BBEF'));
     // Add logos:
     // Initiative logo:
     $initiativeLogo = $currentSlide->createDrawingShape();
     $initiativeLogo->setPath($this->get('kernel')->getRootDir() . self::INITIATIVE_LOGO_BLUE)->setOffsetX(812)->setoffsetY(487)->setHeight(21)->setWidth(103);
     // Separating line:
     $separateLine = $currentSlide->createLineShape(786, 476, 786, 524);
     $separateLine->getBorder()->setColor(new Color('43BBEF'));
     #
     #15th slide:
     #
     $currentSlide = $finalOutcomeBuilder->createSlide();
     //Layout:
     $currentSlide->setSlideLayout(Layout::BLANK);
     // Set background color:
     $this->setSlideBackgroundColor($currentSlide);
     // Placeholder for portrait image:
     $portraitPlaceholder = $currentSlide->createRichTextShape();
     $portraitPlaceholder->setOffsetX(676)->setOffsetY(215)->setHeight(100)->setWidth(250);
     // Add outline content:
     $portraitPlaceholder->createTextRun('Insert portrait here')->getFont()->setName('Arial')->setSize(18)->setColor(new Color(Color::COLOR_WHITE));
     //Content:
     // Determine circle:
     $determineCircle = $currentSlide->createDrawingShape();
     $determineCircle->setPath($this->get('kernel')->getRootDir() . self::GALLERY_DIRECTORY . '/circle_deliver_tasks.png')->setOffsetX(19)->setoffsetY(0)->setHeight(402)->setWidth(520);
     #
     #16th slide:
     #
     $currentSlide = $finalOutcomeBuilder->createSlide();
     //Layout:
     $currentSlide->setSlideLayout(Layout::BLANK);
     // Add title coordinates:
     $titleShape = $currentSlide->createRichTextShape();
     $titleShape->setOffsetX(50)->setOffsetY(50)->setHeight(94)->setWidth(880);
     // Add title content:
     $titleShape->createTextRun('Optimized laydown of touchpoints')->getFont()->setName('KG Second Chances Sketch')->setSize(30)->setColor(new Color('43BBEF'));
     // Add logos:
     // Initiative logo:
     $initiativeLogo = $currentSlide->createDrawingShape();
     $initiativeLogo->setPath($this->get('kernel')->getRootDir() . self::INITIATIVE_LOGO_BLUE)->setOffsetX(812)->setoffsetY(487)->setHeight(21)->setWidth(103);
     // Separating line:
     $separateLine = $currentSlide->createLineShape(786, 476, 786, 524);
     $separateLine->getBorder()->setColor(new Color('43BBEF'));
     //Content
     //Optimal Budget graph:
     //Chart database data:
     $taskName = $this->getDoctrine()->getRepository('TaskBundle:Taskname')->findOneById(TaskType::TYPE_PHASING);
     $taskQuery = $this->getDoctrine()->getRepository('TaskBundle:Task')->createQueryBuilder('t')->where('t.campaign = :campaign AND t.taskname = :taskName')->setParameter('campaign', $campaign)->setParameter('taskName', $taskName)->getQuery();
     $task = $taskQuery->getSingleResult();
     $fileType = $this->getDoctrine()->getRepository('CampaignBundle:Filetype')->findOneById(11);
     $fileQuery = $this->getDoctrine()->getRepository('FileBundle:File')->createQueryBuilder('f')->where('f.task = :task AND f.fileType = :fileType')->orderBy('f.updatedAt', 'DESC')->setMaxResults(1)->setParameter('task', $task)->setParameter('fileType', $fileType)->getQuery();
     $file = $fileQuery->getOneOrNullResult();
     // Check if file to be inserted exists:
     if (!empty($file)) {
         $optimalBudgetGraph = $currentSlide->createDrawingShape();
         // $optimalBudgetGraph->setPath($this->get('kernel')->getRootDir() . self::GALLERY_DIRECTORY . '/graph_visualization.png')
         $optimalBudgetGraph->setPath($file->getPath())->setOffsetX(50)->setoffsetY(120)->setHeight(347)->setWidth(544);
     }
     // End of "Video neutral image" IF.
     #
     #17th slide:
     #
     $currentSlide = $finalOutcomeBuilder->createSlide();
     //Layout:
     $currentSlide->setSlideLayout(Layout::BLANK);
     // Add title coordinates:
     $titleShape = $currentSlide->createRichTextShape();
     $titleShape->setOffsetX(50)->setOffsetY(50)->setHeight(94)->setWidth(880);
     // Add title content:
     $titleShape->createTextRun('Detailed In-market plan')->getFont()->setName('KG Second Chances Sketch')->setSize(30)->setColor(new Color('43BBEF'));
     // Add logos:
     // Initiative logo:
     $initiativeLogo = $currentSlide->createDrawingShape();
     $initiativeLogo->setPath($this->get('kernel')->getRootDir() . self::INITIATIVE_LOGO_BLUE)->setOffsetX(812)->setoffsetY(487)->setHeight(21)->setWidth(103);
     // Separating line:
     $separateLine = $currentSlide->createLineShape(786, 476, 786, 524);
     $separateLine->getBorder()->setColor(new Color('43BBEF'));
     #
     #18th slide:
     #
     $currentSlide = $finalOutcomeBuilder->createSlide();
     //Layout:
     $currentSlide->setSlideLayout(Layout::BLANK);
     // Add logos:
     // Initiative logo:
     $initiativeLogo = $currentSlide->createDrawingShape();
     $initiativeLogo->setPath($this->get('kernel')->getRootDir() . self::INITIATIVE_LOGO_BLUE)->setOffsetX(812)->setoffsetY(487)->setHeight(21)->setWidth(103);
     // Separating line:
     $separateLine = $currentSlide->createLineShape(786, 476, 786, 524);
     $separateLine->getBorder()->setColor(new Color('43BBEF'));
     // Generate the document:
     $finalOutcomePPTXName = 'final_outcome_' . $campaign->getId() . '.pptx';
     $finalOutcomePath = $this->get('kernel')->getRootDir() . '/../web/uploads/presentations/' . $finalOutcomePPTXName;
     $writerPPTX = \PhpOffice\PhpPowerpoint\IOFactory::createWriter($finalOutcomeBuilder, 'PowerPoint2007');
     $writerPPTX->save($finalOutcomePath);
     if (file_exists($finalOutcomePath)) {
         // File was created.
         // Send document back to client:
         $response = new Response(file_get_contents($finalOutcomePath));
         $disposition = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, $finalOutcomePPTXName);
         $response->headers->set('Content-Disposition', $disposition);
         $response->headers->set('Content-Type', 'application/octet-stream');
         $response->headers->set('Content-Length', filesize($finalOutcomePath));
         unlink($finalOutcomePath);
         // Delete generated PPTX from server directory.
         return $response;
     } else {
         // File was not created.
         // Send error message back to client:
         $response = new Response();
         $response->setStatusCode(500)->headers->set('Content-Type', 'application/json');
         $response->setContent(json_encode(array('success' => FALSE, 'message' => 'Request failed. Final outcome PPTX could not be generated.')));
         return $response;
     }
     // End of send file IF.
 }
 /**
  * Write documents
  *
  * @param \PhpOffice\PhpWord\PhpWord $phpWord
  * @param string $filename
  * @param array $writers
  */
 function write($phpPowerPoint, $filename, $writers)
 {
     $result = '';
     // Write documents
     foreach ($writers as $writer => $extension) {
         $result .= date('H:i:s') . " Write to {$writer} format";
         $dir = date('Y-m-d');
         if (!file_exists(public_path() . '/presentation/' . $dir)) {
             mkdir(public_path() . "/presentation/" . $dir, 0777);
         }
         if (!is_null($extension)) {
             $xmlWriter = IOFactory::createWriter($phpPowerPoint, $writer);
             $xmlWriter->save(public_path('presentation/' . $dir) . "/{$filename}.{$extension}");
             //                rename(public_path('presentation/'.$dir) . "/{$filename}.{$extension}", public_path() . "/results/{$filename}.{$extension}");
         } else {
             $result .= ' ... NOT DONE!';
         }
         $result .= EOL;
     }
     $result .= $this->getEndingNotes($writers);
     return $result;
 }
Example #5
0
 public function generate()
 {
     $charts = $this->getCharts(true);
     if (count($charts) > 0) {
         require_once APPPATH . 'libraries/vendor/phppowerpoint/src/PhpPowerpoint/Autoloader.php';
         \PhpOffice\PhpPowerpoint\Autoloader::register();
         $objPHPPowerPoint = new \PhpOffice\PhpPowerpoint\PhpPowerpoint();
         //            $im = new \Imagick();
         //            $svg = file_get_contents($charts[0]['path']);
         //            pre($svg,1);
         // Create slide
         $currentSlide = $objPHPPowerPoint->getActiveSlide();
         //pre($charts[0]['path']);
         // Create a shape (drawing)
         $shape = $currentSlide->createDrawingShape();
         pre($shape, 1);
         $shape->setName('PHPPowerPoint logo');
         $shape->setDescription('PHPPowerPoint logo');
         //->setPath($charts[0]['path'])
         $shape->setPath('D:\\workspace\\tmeditor\\webroot\\temp\\charts\\4\\3cc39970d9d5ac46ce18ef0d575c2914.png');
         $shape->setHeight(600);
         $shape->setOffsetX(20);
         $shape->setOffsetY(20);
         /*
         $shape->getShadow()->setVisible(true)
             ->setDirection(45)
             ->setDistance(10);
         
         // Create a shape (text)
         $shape = $currentSlide->createRichTextShape()
             ->setHeight(300)
             ->setWidth(600)
             ->setOffsetX(170)
             ->setOffsetY(180);
         $shape->getActiveParagraph()->getAlignment()->setHorizontal(\PhpOffice\PhpPowerpoint\Style\Alignment::HORIZONTAL_CENTER);
         $textRun = $shape->createTextRun('Thank you for using PHPPowerPoint!');
         $textRun->getFont()->setBold(true)
             ->setSize(60)
             ->setColor(new \PhpOffice\PhpPowerpoint\Style\Color('FFE06B20'));
         */
         $oWriterPPTX = \PhpOffice\PhpPowerpoint\IOFactory::createWriter($objPHPPowerPoint, 'PowerPoint2007');
         $oWriterPPTX->save($this->getUserChartsDir() . "\\sample.pptx");
         //pre($charts,1);
     }
 }
$objPHPPowerPoint = new PhpPowerpoint();
// Set properties
echo date('H:i:s') . ' Set properties' . EOL;
$objPHPPowerPoint->getProperties()->setCreator('PHPOffice')->setLastModifiedBy('PHPPowerPoint Team')->setTitle('Sample 03 Title')->setSubject('Sample 03 Subject')->setDescription('Sample 03 Description')->setKeywords('office 2007 openxml libreoffice odt php')->setCategory('Sample Category');
// Create slide
echo date('H:i:s') . ' Create slide' . EOL;
$currentSlide = $objPHPPowerPoint->getActiveSlide();
// Create a shape (drawing)
echo date('H:i:s') . ' Create a shape (drawing)' . EOL;
$shape = $currentSlide->createDrawingShape();
$shape->setName('PHPPowerPoint logo')->setDescription('PHPPowerPoint logo')->setPath('./resources/phppowerpoint_logo.gif')->setHeight(36)->setOffsetX(10)->setOffsetY(10);
$shape->getShadow()->setVisible(true)->setDirection(45)->setDistance(10);
// Create a shape (text)
echo date('H:i:s') . ' Create a shape (rich text)' . EOL;
$shape = $currentSlide->createRichTextShape()->setHeight(300)->setWidth(600)->setOffsetX(170)->setOffsetY(180);
$shape->getActiveParagraph()->getAlignment()->setHorizontal(Alignment::HORIZONTAL_CENTER);
$textRun = $shape->createTextRun('Thank you for using PHPPowerPoint!');
$textRun->getFont()->setBold(true)->setSize(60)->setColor(new Color('FFE06B20'));
// Save serialized file
$basename = basename(__FILE__, '.php');
echo date('H:i:s') . ' Write to serialized format' . EOL;
$objWriter = IOFactory::createWriter($objPHPPowerPoint, 'Serialized');
$objWriter->save('results/' . basename(__FILE__, '.php') . '.phppt');
// Read from serialized file
echo date('H:i:s') . ' Read from serialized format' . EOL;
$objPHPPowerPointLoaded = IOFactory::load('results/' . basename(__FILE__, '.php') . '.phppt');
// Save file
echo write($objPHPPowerPointLoaded, basename(__FILE__, '.php'), $writers);
if (!CLI) {
    include_once 'Sample_Footer.php';
}
 /**
  * Test load class exception
  *
  * @expectedException \Exception
  * @expectedExceptionMessage Could not automatically determine \PhpOffice\PhpPowerpoint\Reader\ReaderInterface for file.
  */
 public function testLoadException()
 {
     IOFactory::load(PHPPOWERPOINT_TESTS_BASE_DIR . DIRECTORY_SEPARATOR . 'resources' . DIRECTORY_SEPARATOR . 'images' . DIRECTORY_SEPARATOR . 'PHPPowerPointLogo.png');
 }
        $this->append('<dl>');
        $this->append('<dt>HashCode</dt><dd>' . $oShape->getHashCode() . '</dd>');
        $this->append('<dt>Offset X</dt><dd>' . $oShape->getOffsetX() . '</dd>');
        $this->append('<dt>Offset Y</dt><dd>' . $oShape->getOffsetY() . '</dd>');
        $this->append('<dt>Height</dt><dd>' . $oShape->getHeight() . '</dd>');
        $this->append('<dt>Width</dt><dd>' . $oShape->getWidth() . '</dd>');
        $this->append('<dt>Rotation</dt><dd>' . $oShape->getRotation() . '°</dd>');
        $this->append('<dt>Hyperlink</dt><dd>' . ucfirst(var_export($oShape->hasHyperlink(), true)) . '</dd>');
        $this->append('<dt>Fill</dt><dd>@Todo</dd>');
        $this->append('<dt>Border</dt><dd>@Todo</dd>');
        if ($oShape instanceof MemoryDrawing) {
            ob_start();
            call_user_func($oShape->getRenderingFunction(), $oShape->getImageResource());
            $sShapeImgContents = ob_get_contents();
            ob_end_clean();
            $this->append('<dt>Mime-Type</dt><dd>' . $oShape->getMimeType() . '</dd>');
            $this->append('<dt>Image</dt><dd><img src="data:' . $oShape->getMimeType() . ';base64,' . base64_encode($sShapeImgContents) . '"></dd>');
        } else {
            // Add another shape
        }
        $this->append('</dl>');
        $this->append('</div>');
    }
}
$pptReader = PhpOffice\PhpPowerpoint\IOFactory::createReader('PowerPoint97');
$oPHPPowerPoint = $pptReader->load('resources/Sample_12.ppt');
$oTree = new PhpPptTree($oPHPPowerPoint);
echo $oTree->display();
if (!CLI) {
    include_once 'Sample_Footer.php';
}