…÷˜®˜[T‹Íª#Ènú$Ñ;¯<á:˜êa–4Òs¶‡­XŸ¦í[·òÀ£”ïu
þñáin^ì‰(jÍZðÓ•6ñlÜ€£¹Ø4â	YiÔ½Íd\{ÀXvø[²Mcß„Þâô.ó‚ÿü­ïzšh¾ó.Òt×©x·¨„¡Aè›$ »TÛ9¿‘;@’ËC™¡”ñÌ0$yƒã™Õ“×@9ïÀñ{¢$ëñö¶q/¸‰R|úo·sArÖ{¦C
9XìF&‘ÞóÌ0‰°}>ÑLlwEõ(Úª—T¹œé;iÒž¸r@#VÜbÙfU¿‚xAFí„¾iŸ÷j…k)f·´”\‡d",ò|M>¾ñfŠ¹/y“µAXïûE<Ýoy¬ËªX\KX=ÎÄÑ Û”î41":ºâpÿö‰ß5ãM&RFá‰eï¡&(3%iX?¢¸Ä[.Æ#*¯D)†µ…Xm"g¤n"ho`­©|#Í¶(Ð‹c*J+DŽÐµ%"	WŒ¬
üÄïüZM9ÜÙŒþ¹ž€Pó‰·|Qº™Hi3y³Qê¨bêéÿ+–çÚo“ãCPðŒ¾_óýÊ&(8"nm 0Í×ªæÿ•nl(¬*iíwb“¾;
ò×zœéŽùœð’-/ÚÃ÷²q°)1Ë˜µË±qÐÏŽ–ô†>ÒD3…¸Ð“5Ä¼Ëe ë¦­4ÚŸñ{³uœmûÊ¾Ÿô¤g2,ÍvXÏ\^êÙ8™›rdrÕ®ù‹ÐN:»€Ó©!Þ´ËT;{ÃÑ)«CZ]S1Mƒþõ¬ç«úÛ}ÝË¸ž¢§aÅt:·‹ô[±#/ÁIÞFç¹†!Ìo»Dð¥pÑþj…¿ÿb:¯žÿ Ä™M7†‹ˆÏNæK“¤ûÅonDÆ¹Æ—Uëˆ£ƒ×6]ü—f•ªtøv+Ìñ7a#kM~8Iº¡Vd*¹|Ñ
'‘øÛpCÍ(ßjKé\äæÁ•î»+8m"(ˆò=l™C:‘ÌÁ»©6
)ú Ô¹ËL¡b£šÆIEÉ~VY‰a|$?ˆ>¼7äµÊ–2²Ô±D«tÏ e,aZÍ”½dAFû¥ØÅcÚã¾ý„S„†i=ó®úKwêŽ0HÂÞ ]¥(UI)¹X€¨+LtY\×“mTHØÑ•ÞlÄ$–ý„ÐûIr‹[»)Š’Öÿ&èž&ž(ê±§pýR+…hiBÐéHÉB÷ß“Êåéç@RM@>eï;wŸì¯ä0ŸL3†òÐ gù8$YhIŠÂ½ýÀÝ*QÝx)ëÐáÙÍ·NäKùŸcî.ÈÛ”ªyfwÃºÐHÚÇmî:©Äå››ù–2Ž°_+‰‚ž©OÞÉíM¦â©c?^‰ŠOßÎÜQMB7ÝrÁë^°UûË;c%ÎÙþénÊ¬;DqšøT’l›L±¤Ï[ù®Œ:úS€±¢Gl›þéåL"ÁÖ1-$hb3¦Ÿê*`æäÏ‡>Ä“ä—ßLŽ­èŠ¥7Ü€‹6µŸÀÆ}È­Ùþ2„éìxi2,Rf…,ÙVo?T!ÿæ•¦ÀÉ_“aÙƒ8F	ª.ŒŽxôlÔ›å£+EZ_P ÷Æ×ß¤P²ÌS{¹wåœ–LÑfâ÷UóOA}Ðs²;ÿ[ìþ_æƒ%uÄ¡e$È¥É,Vû€Jäúª8‚]‚ÐØÙö;Â‚¸±3ð¼{™8Û@tÛç0T£)Ö+b^ˆ‘gn#²8søå¢	®Äs›QÞ¹!ÆVÇ¡4âïLŒÎ.‘Öy•w›vŸ Í†ûHIBök¬Ÿú.èþÖ0»jÐMùP6 ¡dÎjÍ ¡]h;ålA™›ðÍÜ	é·¿©h³§vÿ‡mz¨cq7
“ÜÓuc°míùÆ§©TÔ8ÍŸØP%ÏoÆÙÒ?ê¯)Ðív©£ÃÜ«ùãK¼-¯÷y…Æp%;id²‹}”¿¢ù‡!æ4g±ô‰ç¢²i¡_$;(|Ð€£•;Ûó_ž âï[!ý_ÌÎ‡7Y €£~¿6áG@¥}¦ ¸PM/ž&¦ÈW§~ï²¤/¼_a&LˆþV}Iå°dü0J;VbRõèù}÷7 ‚QRš–×v=Åš–ø³Ðn“Íy«
+â¢@ªÖVÝê|°È‰RW\,·ÄAM~e\Ó”O‘'aíMBñ¥;]xeVøRï®j€ñ¦…dýŠT¯òJwÙðÓ²ü·)ùæeæ[,žYë]p±N³	 v†sôÉ[>ÒúÍÎïœ‰¤žìÓðäE¾aä¬Tðö/P2ÓÚÌzN¸êd2‰´Âõ½~	Ñ[óåÚñ„¤Ùú€¯@Ã‡a-2KÔOxùïíåüGÛƒÂc=»Ö#ËQL„oINz„
vŽ`¼²ä›ùHþ›UÏšè—™ÿvíÖçcÃ3—6Ç šˆ·mÒÀêý’–[ð0ä¸îÎÕì“!6MŠù™Þß™BRZv„Yl¡=2\RA­Î·¥Ü=¦JF7îª<³/´Öþ’7YÞ7ÇŽ›ÿVÌëÙÖƒi¼C>Êicçm£!¼,tëØáuÙ«Ï½ßw,ã–¯FukéVºYFBï*°YïÇ(Ë*7ÍÞð¯þ¶¨E ”•€QêˆDwze€¯@Ã‡a-2KÔOxùïíåüGÛƒÂc=»Ö#ËQL„÷Ë"ì7òø'5åÞIúþ›UÏšè—™ÿvíÖçcÃ3—6Ç šˆ·mÒÀZù¦[:`šbÄŸý!ì“!6MŠù™Þß™BRõÔ‹XÞäEGäÚ~QöòŽHÂXiký%BˆÜ»%e@¨=¥>QJ_vA—â(æaò· ¹Ááÿ˜@àÌgé´½_>Î]ç»Ä‰©êí(n“!D?†êžš(vÛ˜9£d¬Œi…` 7UZÈä]À%J—›¯ÉI¤ô}šHÆdÅs<-ÐÓ¨ˆ[±x¶Êúq’£òåíûÐ™¶ ½àÎë´ùÞE^cY{íTž;2£èYNQˆÓd°§}N8°<œ‰ 9óìk¨+çA-ïÚÃrSsi¸d…;7CnÁ"Ît[]‘QVeÞŽc+ÃÛÔQ­mùjp\LÑ›:ü.tÀ…¯P¸YÒú¬ÕHÂXiký%BˆÜ»%e@¨M,?ÃX^ÏšeJ¥O‹o
#Š=tB€ïÆÖ{…÷+Íì¼™Äÿ˜Î¯ÆÌ|þÓ¤èbL²3¿$— Ò^ÌtPaFÃywQ8˜ZÉW#c*üÓñfXï¯9>÷FÛÇ‹¼ª§ÄW-K=¸–ìº¡Îë´ùÞE^cY{íTž;2£èYNQˆÓd°§}NÕÄB/Îý³Ó çœKyôA-ïÚÃrSsi¸d…;7CnÁ"Ît[]‘QVeÞŽc+Ã!3n92×îÄT\Qã‰KÄ›:ü.tÀ…¯P¸YÒú¬ÕêF£$˜å¾Dt¹c9ÑRHO\¼=àÃ„€éó­\VŸ6*p¶ƒ¨5\òMj°C©*Â	ï0ã7X ª<ÿÎ«÷ò±K-!|—†-~ NŽÝÁv±ÛÍÄènþ•èŠÈPgÉÿŒ2È$É$¡í¢Ô ;tRÆj{ëøÆ°©A)	X°+Sá”ÓÚš Pù'õ;žÀ-r[ÊÉ‘„<eù%’Ùj¯ºn!½	¦€×Bœ
™ÒÀQÒŽ=."Ú('c/œ¢ç 	¦³®>zÔÝV¹k?°‘éÓ	¯¬~JÄ© »ÞT2Æ$ý¿«.Ìa?!ÜYö$M…yïÑ§#ˆD*’êºœèrŠ¡Zþð)$ Ëméµ“ol_~x×—çø|ÝêÓ¥y[z‘•”Á`,ìž^èzƒŠR“†Gm÷¿!…ÅvP±=×¯¥WaŒ:ºhHÒ›'­Þ9Y5ÊáJ’r *Ø÷¿í i³F®<Ø„<eù%’Ùj¯ºn!½	¦€×Bœ
™ÒÀQÒŽÔº]BõÉ?SÙHðÝ]¦³®>zÔÝV¹k?°‘éÓ	¯¬~JÄ© »ÞT2Æ$ý¿«.Ìa’ùjx4^×i¦ˆJy€D*’êºœèrŠ¡ZþðG¢ŠÐý–]15
uØeã«2…–ò·ÒEi;Ô[x¸xøoaò'Íaïû™=ë<Ø´oƒ›ž¢ŽÉL”s%ÙZ'„mWw£Ø.›çðÑh
…Èhþ/¼FÕP¬ç¸	
µÐé¿B¤W~ñùPñ`‡¶ }Ró©˜W×˜6•"|ïÆÅÌ¶Ãï é»dô&›ÿ¤]¡SN…™Zv„Yl¡=2\RA­Î·¥Ü=¦JF7îª<³˜qëÐ‚Þ¥j­üå›T5ÌëÙÖƒi¼C>Êicçm£!¼,tëØáuÙ«Ï½ßw,ã–¯FukéVºYFáÚù.ç6@)>½ó ›Œ¯þ¶¨E ”•€QêˆDwze€¯@Ã‡a-2KÔOxùïíåüGÛƒÂc=»Ö#ËQL„oINz„
vŽ`¼²ä›ùHþ›UÏšè—™ÿvíÖçcÃ3—6Ç šˆ·mÒÀ¸&Wa8¶‰á^Êü¿Gì“!6MŠù™Þß™BRZv„Yl¡=2\RA­Î·¥Ü=¦JF7îª<³/´Öþ’7YÞ7ÇŽ›ÿVÌëÙÖƒi¼C>Êicçm£!¼,tëØáuÙ«Ï½ßw,ã–¯FukéVºYFümú¦5F`Ãú¹Åè Ã¶ÑÜ4þ;Y¹Â~(JJ¹·ó&y·FnR#ú.U»UJx´Ívò ç{¹&VüÏ,Rf…,ÙVo?T!ÿæ•¦À'aoP‘¨›‹kÞ Ç÷ØdèhÇbÃ`Ö©Z;ãðÍ9Yv@¹2£‚ÚÊiÚ§‘ØšPâó5M´¼Às…#|®Çn€´‰³šSq°)1Ë˜µË±qÐÏšáŒVªÃkôº,»?ÂIHÂXiký%BˆÜ»%e@¨w/OüÏ–áÒÛÜ²W¯÷òEÌy/rÛÿÚÀ,sd&…v=©°4éŒÙ
¤¹þùé´?­qVH~úíUú|Ò¼êÿpàÃºÌð¨ª/²vð …ž)ÎW”',)"Ñ¸í's£ó–Z3¸ŒºûFY¬ð(3ßB–UÑ«ÕcEAVfgîðþU8'³Ï&ô…òÈïÓÜ×}âÅ0L_‘yïZÄoG¡©…Ï0u‹ª²ÁÈ u¿pþ Å„bly something wrong */
        $this->waitForElement("byId", "insertForm");

        $this->assertEquals(
            "2",
            $this->byId("field_1_3")->value()
        );

        $this->assertEquals(
            "foo",
            $this->byId("field_2_3")->value()
        );

        $this->assertEquals(
            "2010-01-20 02:00:02",
            $this->byId("field_3_3")->value()
        );

        $this->byId("field_2_3")->clear();
        $this->byId("field_2_3")->value("foobar");
        $this->byId("field_3_3")->clear();
        $this->byId("field_3_3")->value("2009-01-20 02:00:02");

        $this->byId("buttonYes")->click();

        $success = $this->waitForElement("byClassName", "success");
        $this->assertContains("1 row affected", $success->text());

        $this->assertEquals(
            "foobar",
            $this->getCellByTableClass('table_results', 2, 6)
        );

        $this->assertEquals(
            "2009-01-20 02:00:02",
            $this->getCellByTableClass('table_results', 2, 7)
        );
    }

    /**
     * Test edit record by double click
     *
     * @return void
     *
     * @group large
     */
    public function testChangeRecordsByDoubleClick()
    {
        $element = $this->byCssSelector(
            "table.table_results tbody tr:nth-child(1) td:nth-child(6)"
        );

        $this->moveto($element);
        $this->doubleclick();

        $this->assertEquals(
            $this->byCssSelector("textarea.edit_box")->value(),
            "abcd"
        );

        $this->byCssSelector("textarea.edit_box")->clear();
        $this->byCssSelector("textarea.edit_box")->value("abcde");
        $this->keys(PHPUnit_Extensions_Selenium2TestCase_Keys::RETURN_);

        $success = $this->waitForElement(
            "byCssSelector", "span.ajax_notification div.success"
        );
        $this->assertContains("1 row affected", $success->text());

        $this->assertEquals(
            "abcde",
            $this->getCellByTableClass('table_results', 1, 6)
        );
    }

    /**
     * Test copy and insert record
     *
     * @return void
     *
     * @group large
     */
    public function testCopyRecords()
    {
        $this->byCssSelector(
            "table.table_results tbody tr:nth-child(3) td:nth-child(3) a"
        )->click();

        /* TODO: this occasionally fails, so there is probably something wrong */
        $this->waitForElement("byId", "insertForm");

        $this->assertEquals(
            "Abcd",
            $this->byId("field_2_3")->value()
        );

        $this->assertEquals(
            "2012-01-20 02:00:02",
            $this->byId("field_3_3")->value()
        );

        $this->byId("field_2_3")->clear();
        $this->byId("field_2_3")->value("ABCDEFG");
        $this->byId("field_3_3")->clear();
        $this->byId("field_3_3")->value("2012-01-20 02:05:02");

        $this->byId("buttonYes")->click();
        $success = $this->waitForElement("byClassName", "success");
        $this->assertContains("1 row inserted", $success->text());

        $this->assertEquals(
            "ABCDEFG",
            $this->getCellByTableClass('table_results', 4, 6)
        );

        $this->assertEquals(
            "2012-01-20 02:05:02",
            $this->getCellByTableClass('table_results', 4, 7)
        );
    }

    /**
     * Test search table
     *
     * @return void
     *
     * @group large
     */
    public function testSearchRecords()
    {
        $this->expandMore();

        $this->byLinkText("Search")->click();
        $this->waitForElement("byId", "tbl_search_form");

        $this->byId("fieldID_1")->value("abcd");
        $select = $this->select($this->byName("criteriaColumnOperators[1]"));
        $select->selectOptionByLabel("LIKE %...%");

        $this->byName("submit")->click();
        $success = $this->waitForElement("byClassName", "success");
        $this->assertContains("Showing rows", $success->text());

        $this->assertEquals(
            "1",
            $this->getCellByTableClass('table_results', 1, 5)
        );

        $this->assertEquals(
            "3",
            $this->getCellByTableClass('table_results', 2, 5)
        );
    }

    /**
     * Test delete multiple records
     *
     * @return void
     *
     * @group large
     */
    public function testDeleteRecords()
    {
        $this->byId("id_rows_to_delete1_left")->click();
        $this->byId("id_rows_to_delete2_left")->click();

        $this->byCssSelector("button[value=delete]")->click();
        $this->waitForElement("byCssSelector", "fieldset.confirmation");

        $this->byId("buttonYes")->click();
        $success = $this->waitForElement("byClassName", "success");
        $this->assertContains("Showing rows", $success->text());

        $this->assertFalse(
            $this->isElementPresent(
                "byCssSelector", "table.table_results tbody tr:nth-child(2)"
            )
        );

    }
}