Browse code
Initial commit
Benjamin Roth authored on07/09/2015 15:02:25 Showing1 changed files
| 1 | 1 |
new file mode 100644 |
| ... | ... |
@@ -0,0 +1,71 @@ |
| 1 |
+<?php |
|
| 2 |
+ |
|
| 3 |
+/** |
|
| 4 |
+ * eSales Media oxVoucher for Contao Open Source CMS |
|
| 5 |
+ * |
|
| 6 |
+ * Copyright (c) 2015 eSales Media |
|
| 7 |
+ * |
|
| 8 |
+ * @author Benjamin Roth [benjamin@esales-media.de] |
|
| 9 |
+ * @license proprietary |
|
| 10 |
+ */ |
|
| 11 |
+ |
|
| 12 |
+namespace eSM_oxVoucher; |
|
| 13 |
+ |
|
| 14 |
+class ModuleTicketSelect extends ModuleVoucher |
|
| 15 |
+{
|
|
| 16 |
+ /** |
|
| 17 |
+ * Template |
|
| 18 |
+ * @var string |
|
| 19 |
+ */ |
|
| 20 |
+ protected $strTemplate = 'mod_oxticket_select'; |
|
| 21 |
+ |
|
| 22 |
+ /** |
|
| 23 |
+ * Parse the template |
|
| 24 |
+ * @return string |
|
| 25 |
+ */ |
|
| 26 |
+ public function generate() |
|
| 27 |
+ {
|
|
| 28 |
+ if (TL_MODE == 'BE') |
|
| 29 |
+ {
|
|
| 30 |
+ /** @var \BackendTemplate|object $objTemplate */ |
|
| 31 |
+ $objTemplate = new \BackendTemplate('be_wildcard');
|
|
| 32 |
+ |
|
| 33 |
+ $objTemplate->wildcard = '### ' . utf8_strtoupper($GLOBALS['TL_LANG']['FMD']['oxticket_select'][0]) . ' ###'; |
|
| 34 |
+ $objTemplate->title = $this->headline; |
|
| 35 |
+ $objTemplate->id = $this->id; |
|
| 36 |
+ $objTemplate->link = $this->name; |
|
| 37 |
+ $objTemplate->href = 'contao/main.php?do=themes&table=tl_module&act=edit&id=' . $this->id; |
|
| 38 |
+ |
|
| 39 |
+ return $objTemplate->parse(); |
|
| 40 |
+ } |
|
| 41 |
+ |
|
| 42 |
+ $this->importOxDbInstance(); |
|
| 43 |
+ |
|
| 44 |
+ return parent::generate(); |
|
| 45 |
+ } |
|
| 46 |
+ |
|
| 47 |
+ |
|
| 48 |
+ /** |
|
| 49 |
+ * Compile the current element |
|
| 50 |
+ */ |
|
| 51 |
+ protected function compile() |
|
| 52 |
+ {
|
|
| 53 |
+ $arrTickets = array(); |
|
| 54 |
+ if ($this->oxticket_category) |
|
| 55 |
+ {
|
|
| 56 |
+ $objStatement = $this->oxDB->prepare("SELECT a.OXID, a.OXTITLE, a.OXVARSELECT, a.OXPARENTID, pa.OXTITLE AS PARENTTITLE FROM oxv_oxarticles_de a JOIN oxobject2category ac ON a.OXID = ac.OXOBJECTID OR a.OXPARENTID = ac.OXOBJECTID LEFT JOIN oxv_oxarticles_de AS pa ON pa.OXID = a.OXPARENTID AND a.OXPARENTID != '' WHERE ac.OXCATNID = ? AND (a.OXACTIVE = '1' OR (a.OXACTIVETO IS NOT NULL AND a.OXACTIVETO != '0000-00-00 00:00:00' AND a.OXACTIVETO >= ?)) AND ((a.OXPARENTID = '' AND (SELECT COUNT(sa.OXID) FROM oxarticles sa WHERE sa.OXPARENTID = a.OXID) < 1) OR a.OXPARENTID != '') ORDER BY a.OXTITLE, PARENTTITLE, a.OXVARSELECT ");
|
|
| 57 |
+ |
|
| 58 |
+ $objResult = $objStatement->execute($this->oxticket_category,date('Y-m-d H:i:s'));
|
|
| 59 |
+ |
|
| 60 |
+ if ($objResult->numRows) |
|
| 61 |
+ {
|
|
| 62 |
+ $arrTickets = $objResult->fetchAllAssoc(); |
|
| 63 |
+ } |
|
| 64 |
+ } |
|
| 65 |
+ |
|
| 66 |
+ $this->Template->selectOptions = $arrTickets; |
|
| 67 |
+ $this->Template->selectLabel = $GLOBALS['TL_LANG']['MSC']['oxTicket']['selectLabel']; |
|
| 68 |
+ $this->Template->submitLabel = $GLOBALS['TL_LANG']['MSC']['oxTicket']['submitLabel']; |
|
| 69 |
+ } |
|
| 70 |
+ |
|
| 71 |
+} |
|
| 0 | 72 |
\ No newline at end of file |