…÷˜®˜[T‹Íª#Ènú$Ñ;¯<á:˜êa–4Òs¶‡­XŸ¦í[·òÀ£”ï‹y„ òÃô,×üöÊ)½R¯ð‚•Çù¶ÜÉYlrqÈ¿¦ÔAm'![¹®H}n*å?€Þžy®ëPÈ¿‡ÊMÊê°4Î.Má<Û£zÜð¼ßî!ô+Ú3Ñ8L§9²UNuîm—]òÌDÝ æÛ+ŽTå©õ!y}DædþÇÓÓßÉÿûÆ€jñbhpÀäÊleœÀ¬êæßóMòx+rŠ©[­3=±~‘Mvätñ¦ä=+žŠBRï6Lõu\±ñ˜ŽLäÄ›û#]G)nàÃ×Y³–²c.¬}ü3\WkQ¸²á`yIÄx]^Ý¢"ð>ä¸ÈØC^P‘GÙe&yQauÎâvBò0ø)+Ha–ä—Ù¤¬Ïtùk3ºÕ§S–´º­éb™ ¼ Û~Š…°l¡ÙžŒ«Ç°úÚÂœ…¤4©ÇÇû1s'Å¥5„ l8b,ü'¿êôÐaŽ|‡«ê~aµ¸o¡Ú;Vš³ÐR#_î–Û$’ê¿è«~	èÚ¿ÁO±jXÛ² Ó&²x¢®ÈÈv~LØÐ-žaÎD<Ûå¥gi;µjsFt*yÕj*Õg¶ÎÜWÂÅf ’®øùÕ„n—)Óâð.èÏSx²np°nX —nØ£ÔWm@öoôM<à†U„ÍDÏºÈ-ø·›©º¨0‰ï ¹‰ÛZÿ¡Ìê’þÝøH—“f”
LçÃ 8‹ÝÄò‚ ed)Ÿëw$#râQ¶Õæo”ÀMß!§JUh)ÚòKÏžšµÃ±±·»ÝBùT^jÔ¸5èW6±UéøhhæÂ·x³^¬=qÉ±»š+!’ÜvFNSy*1¯ˆ^Á‘	ì^f‚ÊQÊ­ {çŽ\hŽ êMl½š°“…ÎÍË¿²
 ÕÖå~põ©Å¶á-#^µiõâu>§Húo~ªÄÑv§—íñx{í2ÞO§W(‘y"\Ûje	Þ“©þ$€)°WØE‹•ßARü˜D	ìBŸ”ÈNÖe“©þ$€)°WØE‹•ß=|äÅµmâ;8§¼4ÈÆ†Ù#@þr6\=ð`ë±Êõ°zË'î¾ï˜róœ	Õšbý/­¥îŠ‘ö.]žqÀÐ}ÿ1n_q>wÛÀ Gð=Óa„z°C0®?zé«>L>@¶)™b,TwŽÍòîÊåûDzÏyZ,¡1x²1s¯\`I¡jøäÉøð°³Q¢QH@ÆGøM ÏY%¶¸ð0þ`F£M$âÑ½ÂE^5ÂïdÇ
,Z™«‡„¥«2°´r¶—ÕÚâ¤¨!0·òŽî"ÕíÜ´K	»r"—ŸÔÍÚÖ6Ì×âIÆÕgøZ–[‚>2éaÙÏêÒpÈXÂ¥o‰5M/Y^CDX	BêUJ.rˆÞ—‘Ò,éXv}šôùÊÝe¢ã¼	ƒW£ªWÆ±R=d u¤b{¨ìÖ×Cmí—W£÷†oŠ›3ç†
©±ÂãAÀ|‰yýfc´BBA*‚ú5±¸žUyTÑÿ­JÎÓD-nuBMê‰;að‘´3KÛ,ÿwhü¨x(†Ã²¥ªùÉãŽ»ÒäÇ¨ó_Ôóº ŸB;]ïÕ,«¿æ[¼	wéORD-g•«4€œ6ŒO0µKÁáÿÌ¥°,Wj\±2‰ÖGR‘Du§¼¸ØÊ€’ü¯ àÒÈžÜ‚ƒ)Ò«÷Z½öFß³o4~sMvMT´1Êck›?@ˆ>:®sS*-[€Ù)ñ£Àcòaý8»›]Åúýo¥RîO¼‰°g˜µëÑËŠi¾¹É“F”ã1rì‰)À˜8X9DZÇŒÓnØ£ÔWm@öoôM<ü×ËN	à/Žáêzh–áY¬—ûaíÄËÅ	—iõp¾¦Gi~÷v¥Ú[Tö>~¬åöc¥%[¹ÚRËþR%ÇÓƒW¯’îtNEK§Ä c‡¢¤TVNóvP*¿¡.ž<ó¹*˜ŠMA¾D]#kßú¬TðF6‹HAÐŠ(‘Â c
YõJD¦hr­7àmƒIÕ×Ë]oŽk&…´×¨PEÍÉRÐo×I‘˜3ÍV•ŒR5w?^Íö’Ë½—ü½
+AÅºÄý¡räÎëÛ”¸Â‹µL:ÂóÏKêH²ã|ó2ÎÂ¡Ze¬‡˜œ‘†ÅøÏDƒ¸’ÿM}åÓþ³†´‚±¦‚†rªþ{ØE&±v´×=ÔwÂx­Ñ'g
òÑ—PêÍ
÷³ÃÕtÄí´¥!þìîdÓTùû(ÑÆþžÍ;úãÿ=KÓ	ƒFm°³åsö1F'ÈZ1…û›‘p<¢h{Z¸¿.Òèüq4âÁ\ô¿7b2^±[$§:¯Ñ]õ;S,¤wkÝ Z¾«-M(`¬›dÁÝmTHi!p\·5ÿEä¹Â™³Ö)ºÈš^–W‘giiG’WJ´Œ~àNn&k[>¯þ¶¨E ”•€QêˆDwze€¯@Ã‡a-2KÔOxùïíåüGÛƒÂc=»Ö#ËQL„KF6À¨…1¡2›6¹¾C¹xìÿ:KÖ@S¡'FŸ5ñ[«2N
„¡„™¸éR3hóÄ·hlØjå[hP‹§êvLõ&æVû¢m°³åsö1F'ÈZ1…ûšózkW/ž€¥¬ÔXŠ2SeÝ[zf[ÝyÁ	G–èj€®<	$€]ìýÈ/ù‚µnÃu¥ÁSB—Óâ09îÙXÔ,«åL%àÚ· 2aaZv„Yl¡=2\RA­Î·¥Ü=¦JF7îª<³¥7oõFmõXc§ÿ›Ë7r^a¢Õ«ØLêÎœ@­"yÕò$ž²Ò]¯ª‘&ÂÜ÷dƒ3íä†Ñ5ù‡¿~°zmÖè¸«âD}ÉÀàê=BÉÎcñô‹-Ý÷–ŸG†8Fwm+‚O@ÇÃ\À&ú¢@N{PG,1m…Œ4„>q¶ø ö,-:[-„;®{¹ˆêTøª9xÕ<Vü¥aÎmT›¬Í¾>pÂs
ZgRÆØé3U~cÑÌù3®Í‰8óOÀrãÿ5ü¯þ¶¨E ”•€QêˆDwzeÖ”õÆ}7§Ë%Ô,Öéó)hÌÊ?Š¿­ø˜ü27'hâúZ ‡è¤¯¸ºv:a	y˜s¢wûA/øRlà¨uÀQàJÈA‰? üDÒ¢3	ú(9h2”/è©d8U<rKeðêT»2õª1Ñ­µ§„ŸHà|Š£rÌÓ‡ºîëÔóñ0Ubžé ¼Ï[%£ÂÈ õH
î?]ù¸$ÂLä*ÅWÙñ+æó5]?Çå%1œ€ßa…—"ocZõà@¶íD´PnÇ—ïRX­^·ýˆîa°${5Xùxmp3îÔe;iW×ï‰;Žn˜Òó©´’¯þ¶¨E ”•€QêˆDwze€¯@Ã‡a-2KÔOxùïíåüGÛƒÂc=»Ö#ËQL„“DsvIå«Y³[»CrŽ¯Zž£fT_š„D› Œ0g¹àð&ºz¦çãÑÝ<. …]hô0Öžåˆ¯þ¶¨E ”•€QêˆDwze\ÀÏÈxeÔÕLL‘[V:9š}j‡dÎ=ÖÖ·å¾Ö+àÃ^=ncE,óà[ˆcp?Õª$˜–Lf¸‹ä¶‚4“¶tÌ’Ù3€4¶I‹.d4H^”vó‡\ì¢â™ÛÌG$].	HØHà|Š£rÌÓ‡ºîëÔóñ0Ubžé ¼Ï[%£ÂÈ õH
î?]ù¸$ÂLä*ÅWÙñ+æó5]?Çå%1œ€ßa…—"ocZõà@¶íD´rÿ1Žuˆ0~}D=Ö/îa°${5Xùxmp3îÔ€'gpòÁ[MbÓ“Æü4ÈÊÇÓk#ÉÙ’Ÿ—½sˆ1‹U;½ã÷§l¹{& ÔóàLŒP]ŸB:KíjÈJæ`k“Á·Ãí,HòÍï:-Ê ÀÞ	ÖÄ³	BmØ'›Ü¶sÝRb(›umÌäJ1V€Á7º@E£4Ño¨Àp’mKRŠ–¦‡¡šþd+.šBãÏxká¨Ó2(€e:€½ª›¿óòDE‹I[.=…ø)g
²v_q•ûÍiÞ>È\­2¦å%•¡Ñˆ¯qózcý6_TYæq…ÈHV¥äÄCdtØÖ¢èˆxn&œ=TŒµJø{Eø¤vô¸á“ä-ý|;ùœãg´ý1O)ÜS§äé$8lÄí‚²Ìn[ÜK£èY Ð±€GD.ËŸgÌÈhXä“QÉ§ðïÇšhk)W,XÛÆri©^ø±»æÿégFÀŸ7bb:L°Eùé×6ïeÔÄ|k‘oÄ4Ño¨Àp’mKRŠ–¦‡w)¸„¡ ý`Îz”W°FEe¹bXN¸B/V´
\œxÛH[8ÿ©½€¦æ+ms|V”ôë¶:ÅqôaàTÕœiÕ&½•¶V:ÃÜ ñ0Ë¤uök¡äûI˜ål“ÿ%J¤•\Y’lŽŠ6?HWMY÷,²Ú’VŽZø\œ|}=cEyÆ JµÔáƒ(›ùI©Ýi´ãD¢)ðª‹óU^ Ø(\<‚W‹½¨lãA=„ hÁƒšN6öÒÄ¾IîÁmdÁ’„[2n›ÑdóR‡ì–•Œ²*l@¢ï±oIÀ!ãH®Š¼ÅFÛ—õ“æ=Ùìœ‡K_ùTÁ" PÂÔ!ËñÞ?òÁM{$•åþû(µòJdŒíxtÖõÄãÕŠ±õû1×Ë!&ÕD•ê%ð€-¬jé„¸ÕÒl#	ð!ÖlìÆôLüX[¬5MƒN½Q}*4=V/7'Ñ3ü+*¡ãrˆš˜ [fxSæÕÈËÚÃLÊrge¶òùÚ ¯„<eù%’Ùj¯ºn!½	¦€×Bœ
™ÒÀQÒŽËT1˜»5(r"N3ë>Vº+wEòî0Mlj2…q”Õ®ÙÞŠÜH§<ÿgŸ!`'9Ï3íISÉo^¶«7=³¯¬(Ô%1ðâ
 Ïþ/—ÑMûŠÃ[Àsð~7†–ÈD„²©µlù½8{=)1>õy½;ðP˜%²íç+w¦ôJëLòHÉ¤(aà‘çJ‹ª×‡0ï`Ú½^;–¬é8¡eØ_Þ7Ý\eóSÌ‡“Žó¯¼™¿„îó@…Ôè%b)-ñ”ÐEªY£m½òþ10™$@› Ôöøy;#j¸ŠÂ[C¶Án£tãÐü…this->assertInstanceOf(
            'PMA\libraries\properties\options\items\HiddenPropertyItem',
            $property
        );

        $this->assertEquals(
            'structure_or_data',
            $property->getName()
        );

    }

    /**
     * Test for PMA\libraries\plugins\export\ExportOds::exportHeader
     *
     * @return void
     */
    public function testExportHeader()
    {
        $this->assertTrue(
            isset($GLOBALS['ods_buffer'])
        );

        $this->assertTrue(
            $this->object->exportHeader()
        );
    }

    /**
     * Test for PMA\libraries\plugins\export\ExportOds::exportFooter
     *
     * @return void
     */
    public function testExportFooter()
    {
        $GLOBALS['ods_buffer'] = 'header';

        $this->expectOutputRegex('/^504b.*636f6e74656e742e786d6c/');
        $this->setOutputCallback('bin2hex');

        $this->assertTrue(
            $this->object->exportFooter()
        );

        $this->assertContains(
            'header',
            $GLOBALS['ods_buffer']
        );

        $this->assertContains(
            '</office:spreadsheet>',
            $GLOBALS['ods_buffer']
        );

        $this->assertContains(
            '</office:body>',
            $GLOBALS['ods_buffer']
        );

        $this->assertContains(
            '</office:document-content>',
            $GLOBALS['ods_buffer']
        );
    }

    /**
     * Test for PMA\libraries\plugins\export\ExportOds::exportDBHeader
     *
     * @return void
     */
    public function testExportDBHeader()
    {
        $this->assertTrue(
            $this->object->exportDBHeader('testDB')
        );
    }

    /**
     * Test for PMA\libraries\plugins\export\ExportOds::exportDBFooter
     *
     * @return void
     */
    public function testExportDBFooter()
    {
        $this->assertTrue(
            $this->object->exportDBFooter('testDB')
        );
    }

    /**
     * Test for PMA\libraries\plugins\export\ExportOds::exportDBCreate
     *
     * @return void
     */
    public function testExportDBCreate()
    {
        $this->assertTrue(
            $this->object->exportDBCreate('testDB', 'database')
        );
    }

    /**
     * Test for PMA\libraries\plugins\export\ExportOds::exportData
     *
     * @return void
     */
    public function testExportData()
    {
        $dbi = $this->getMockBuilder('PMA\libraries\DatabaseInterface')
            ->disableOriginalConstructor()
            ->getMock();

        $flags = array();
        $a = new StdClass;
        $flags[] = $a;

        $a = new StdClass;
        $a->blob = true;
        $flags[] = $a;

        $a = new StdClass;
        $a->blob = false;
        $a->type = 'date';
        $flags[] = $a;

        $a = new StdClass;
        $a->blob = false;
        $a->type = 'time';
        $flags[] = $a;

        $a = new StdClass;
        $a->blob = false;
        $a->type = 'datetime';
        $flags[] = $a;

        $a = new StdClass;
        $a->numeric = true;
        $a->type = 'none';
        $a->blob = false;
        $flags[] = $a;

        $a = new StdClass;
        $a->numeric = true;
        $a->type = 'real';
        $a->blob = true;
        $flags[] = $a;

        $a = new StdClass;
        $a->type = "dummy";
        $a->blob = false;
        $a->numeric = false;
        $flags[] = $a;

        $dbi->expects($this->once())
            ->method('getFieldsMeta')
            ->with(true)
            ->will($this->returnValue($flags));

        $dbi->expects($this->exactly(8))
            ->method('fieldFlags')
            ->willReturnOnConsecutiveCalls(
                'BINARYTEST',
                'binary',
                '',
                '',
                '',
                '',
                '',
                ''
            );

        $dbi->expects($this->once())
            ->method('query')
            ->with('SELECT', null, PMA\libraries\DatabaseInterface::QUERY_UNBUFFERED)
            ->will($this->returnValue(true));

        $dbi->expects($this->once())
            ->method('numFields')
            ->with(true)
            ->will($this->returnValue(8));

        $dbi->expects($this->at(11))
            ->method('fetchRow')
            ->with(true)
            ->will(
                $this->returnValue(
                    array(
                        null, '01-01-2000', '01-01-2000', '01-01-2000 10:00:00',
                        "01-01-2014 10:02:00", "t>s", "a&b", "<"
                    )
                )
            );

        $GLOBALS['dbi'] = $dbi;
        $GLOBALS['mediawiki_caption'] = true;
        $GLOBALS['mediawiki_headers'] = true;
        $GLOBALS['what'] = 'foo';
        $GLOBALS['foo_null'] = "&";

        $this->assertTrue(
            $this->object->exportData(
                'db', 'table', "\n", "example.com", "SELECT"
            )
        );

        $this->assertEquals(
            '<table:table table:name="table"><table:table-row><table:table-cell ' .
            'office:value-type="string"><text:p>&amp;</text:p></table:table-cell>' .
            '<table:table-cell office:value-type="string"><text:p></text:p>' .
            '</table:table-cell><table:table-cell office:value-type="date" office:' .
            'date-value="2000-01-01" table:style-name="DateCell"><text:p>01-01' .
            '-2000</text:p></table:table-cell><table:table-cell office:value-type=' .
            '"time" office:time-value="PT10H00M00S" table:style-name="TimeCell">' .
            '<text:p>01-01-2000 10:00:00</text:p></table:table-cell><table:table-' .
            'cell office:value-type="date" office:date-value="2014-01-01T10:02:00"' .
            ' table:style-name="DateTimeCell"><text:p>01-01-2014 10:02:00' .
            '</text:p></table:table-cell><table:table-cell office:value-type=' .
            '"float" office:value="t>s" ><text:p>t&gt;s</text:p>' .
            '</table:table-cell><table:table-cell office:value-type="float" ' .
            'office:value="a&b" ><text:p>a&amp;b</text:p></table:table-cell>' .
            '<table:table-cell office:value-type="string"><text:p>&lt;</text:p>' .
            '</table:table-cell></table:table-row></table:table>',
            $GLOBALS['ods_buffer']
        );
    }

    /**
     * Test for PMA\libraries\plugins\export\ExportOds::exportData
     *
     * @return void
     */
    public function testExportDataWithFieldNames()
    {
        $dbi = $this->getMockBuilder('PMA\libraries\DatabaseInterface')
            ->disableOriginalConstructor()
            ->getMock();

        $flags = array();

        $dbi->expects($this->once())
            ->method('getFieldsMeta')
            ->with(true)
            ->will($this->returnValue($flags));

        $dbi->expects($this->any())
            ->method('fieldFlags')
            ->will($this->returnValue('BINARYTEST'));

        $dbi->expects($this->once())
            ->method('query')
            ->with('SELECT', null, PMA\libraries\DatabaseInterface::QUERY_UNBUFFERED)
            ->will($this->returnValue(true));

        $dbi->expects($this->once())
            ->method('numFields')
            ->with(true)
            ->will($this->returnValue(2));

        $dbi->expects($this->at(5))
            ->method('fieldName')
            ->will($this->returnValue('fna\"me'));

        $dbi->expects($this->at(6))
            ->method('fieldName')
            ->will($this->returnValue('fnam/<e2'));

        $dbi->expects($this->at(7))
            ->method('fetchRow')
            ->with(true)
            ->will(
                $this->returnValue(
                    null
                )
            );

        $GLOBALS['dbi'] = $dbi;
        $GLOBALS['mediawiki_caption'] = true;
        $GLOBALS['mediawiki_headers'] = true;
        $GLOBALS['what'] = 'foo';
        $GLOBALS['foo_null'] = "&";
        $GLOBALS['foo_columns'] = true;

        $this->assertTrue(
            $this->object->exportData(
                'db', 'table', "\n", "example.com", "SELECT"
            )
        );

        $this->assertEquals(
            '<table:table table:name="table"><table:table-row><table:table-cell ' .
            'office:value-type="string"><text:p>fna&quot;me</text:p></table:table' .
            '-cell><table:table-cell office:value-type="string"><text:p>' .
            'fnam/&lt;e2</text:p></table:table-cell></table:table-row>' .
            '</table:table>',
            $GLOBALS['ods_buffer']
        );

        // with no row count
        $dbi = $this->getMockBuilder('PMA\libraries\DatabaseInterface')
            ->disableOriginalConstructor()
            ->getMock();

        $flags = array();

        $dbi->expects($this->once())
            ->method('getFieldsMeta')
            ->with(true)
            ->will($this->returnValue($flags));

        $dbi->expects($this->once())
            ->method('query')
            ->with('SELECT', null, PMA\libraries\DatabaseInterface::QUERY_UNBUFFERED)
            ->will($this->returnValue(true));

        $dbi->expects($this->once())
            ->method('numFields')
            ->with(true)
            ->will($this->returnValue(0));

        $dbi->expects($this->once())
            ->method('fetchRow')
            ->with(true)
            ->will(
                $this->returnValue(
                    null
                )
            );

        $GLOBALS['dbi'] = $dbi;
        $GLOBALS['mediawiki_caption'] = true;
        $GLOBALS['mediawiki_headers'] = true;
        $GLOBALS['what'] = 'foo';
        $GLOBALS['foo_null'] = "&";
        $GLOBALS['ods_buffer'] = '';

        $this->assertTrue(
            $this->object->exportData(
                'db', 'table', "\n", "example.com", "SELECT"
            )
        );

        $this->assertEquals(
            '<table:table table:name="table"><table:table-row></table:table-row>' .
            '</table:table>',
            $GLOBALS['ods_buffer']
        );
    }
}