field.unique_link.php

<?php


Class fieldUnique_link extends Field
{
    public function __construct()
    {
        parent::__construct();
        $this->_name = __('Unique Link');
        $this->_required = false;
        $this->set('required', 'no');
    }

	public function canFilter(){
		return true;
	}

	public function canImport(){
		return true;
	}

	public function canPrePopulate(){
		return true;
	}

	public function isSortable(){
		return true;
	}

	public function allowDatasourceOutputGrouping(){
		return true;
	}

	public function allowDatasourceParamOutput(){
		return true;
	}

    public function displayPublishPanel(&$wrapper, $data = NULL, $flagWithError = NULL, $fieldnamePrefix = NULL, $fieldnamePostfix = NULL)
    {
        $label = Widget::Label($this->get('label'));

        $label->appendChild(new XMLElement('a', __('Select Link'), array('style' => 'float: right;', 'onclick' => "
                document.getElementById('unique_link_" . $this->get('id') . "').select(); return false;
            ")));

        $link = str_replace('[URL]', URL, $this->get('link'));
        $link = str_replace('[CODE]', $data['code'], $link);

        $value = $data === null ? __('A link will automaticly be generated when you save this entry') : $link;

        $label->appendChild(Widget::Input('fields'.$fieldnamePrefix.'['.$this->get('element_name').']'.$fieldnamePostfix,
			$value, 'text', array('id' => 'unique_link_' . $this->get('id'),
		        'readonly' => 'readonly',
		        'style' => 'background: #eee; color: #666; border: 1px solid #ccc;')
            )
        );

        if ($flagWithError != NULL) $wrapper->appendChild(Widget::Error($label, $flagWithError));
        else $wrapper->appendChild($label);
    }

	public function buildSortingSQL(&$joins, &$where, &$sort, $order='ASC'){
		if(in_array(strtolower($order), array('random', 'rand'))) {
			$sort = 'ORDER BY RAND()';
		}
		else {
			$sort = sprintf(
				'ORDER BY (
					SELECT %s
					FROM tbl_entries_data_%d AS `ed`
					WHERE entry_id = e.id
				) %s',
				'`ed`.code',
				$this->get('id'),
				$order
			);
		}
	}

	public function buildDSRetrievalSQL($data, &$joins, &$where, $andOperation = false) {
		$field_id = $this->get('id');

		if (self::isFilterRegex($data[0])) {
			$this->buildRegexSQL($data[0], array('value', 'handle'), $joins, $where);
		}
		else if ($andOperation) {
			foreach ($data as $value) {
				$this->_key++;
				$value = $this->cleanValue($value);
				$joins .= "
					LEFT JOIN
						`tbl_entries_data_{$field_id}` AS t{$field_id}_{$this->_key}
						ON (e.id = t{$field_id}_{$this->_key}.entry_id)
				";
				$where .= "
					AND (
						t{$field_id}_{$this->_key}.code = '{$value}'
					)
				";
			}
		}

		else {
			if (!is_array($data)) $data = array($data);

			foreach ($data as &$value) {
				$value = $this->cleanValue($value);
			}

			$this->_key++;
			$data = implode("', '", $data);
			$joins .= "
				LEFT JOIN
					`tbl_entries_data_{$field_id}` AS t{$field_id}_{$this->_key}
					ON (e.id = t{$field_id}_{$this->_key}.entry_id)
			";
			$where .= "
				AND (
					t{$field_id}_{$this->_key}.code IN ('{$data}')
				)
			";
		}

		return true;
	}

	public function processRawFieldData($data, &$status, &$message=null, $simulate = false, $entry_id = null)
    {
        $status = self::__OK__;

        if (strlen(trim($data)) == 0) return array();

        $callback = Administration::instance()->getPageCallback();

        if ($callback['context']['page'] == 'new') {
            // new entry
            // Generate some random code:
            $code = sha1(time() + (rand(0, 999) / 1000));
            $data = $code;
            $timestamp = time();
        } else {
            $row = Symphony::Database()->fetchRow(0, 'SELECT * FROM `tbl_entries_data_' . $this->get('id') . '` WHERE `entry_id` = ' . $entry_id . ';');
            $timestamp = $row['timestamp'];
            $data = $row['code'];
        }

        $result = array(
            'code' => $data,
            'timestamp' => $timestamp
        );

        return $result;
    }

    /**
     * Delete an entry according to the code that's being used
     * @param  $code
     * @return void
     */
    private function deleteEntryAccordingToCode($code)
    {
        $entry_id = Symphony::Database()->fetchVar('entry_id', 0, 'SELECT `entry_id` FROM `tbl_entries_data_' . $this->get('id') . '` WHERE `code` = \'' . $code . '\';');
        EntryManager::delete($entry_id);
        // Redirect:
        redirect(URL . $_SERVER['REQUEST_URI']);
    }


    public function appendFormattedElement(&$wrapper, $data, $encode = false)
    {

        $value = $data['code'];
        $seconds_passed = time() - $data['timestamp'];
        $hours_passed = $seconds_passed / 3600;
        $hours_left = round($this->get('hours') - $hours_passed);

        $valid = $this->get('hours') - $hours_passed > 0 ? 'yes' : 'no';

        if ($valid == 'no' && $this->get('auto_delete') == 1) {
            // Delete the entry and redirect:
            $this->deleteEntryAccordingToCode($value);
        }

        $link = str_replace('[URL]', URL, $this->get('link'));
        $link = str_replace('[CODE]', $value, $link);

        $wrapper->appendChild(
            new XMLElement(
                $this->get('element_name'), $link, array('code' => $value, 'hours-left' => $hours_left, 'valid' => $valid)
            )
        );
    }

    public function commit()
    {
        if (!parent::commit()) return false;

        $id = $this->get('id');

        if ($id === false) return false;

        $fields = array();

        $fields['link'] = $this->get('link');
        $fields['hours'] = $this->get('hours');
        $fields['auto_delete'] = $this->get('auto_delete') == 'yes' ? 1 : 0;

        FieldManager::saveSettings($id, $fields);
    }

    public function prepareTableValue($data, XMLElement $link = null)
    {

        $seconds_passed = time() - $data['timestamp'];
        $hours_passed = $seconds_passed / 3600;
        $hours_left = round($this->get('hours') - $hours_passed);
        $valid = $this->get('hours') - $hours_passed > 0 ? 'yes' : 'no';

        if ($valid == 'no' && $this->get('auto_delete') == 1) {
            // Delete the entry and redirect:
            $this->deleteEntryAccordingToCode($data['code']);
        }

        if ($valid == 'yes') {
            $value = __('Link valid for') . ' ' . $hours_left . ' ' . __('hours');
        } else {
            $value = __('Link no longer valid');
        }
        if (strlen($value) == 0) $value = __('None');

        if ($link) {
            $link->setValue($value);

            return $link->generate();
        }

        return $value;
    }

    public function setFromPOST($postdata)
    {
        parent::setFromPOST($postdata);
        if ($this->get('validator') == '') $this->remove('validator');
    }

    public function displaySettingsPanel(&$wrapper, $errors = null)
    {
        parent::displaySettingsPanel($wrapper, $errors);

        $link = $this->get('link');
        $hours = $this->get('hours');
        $link = !empty($link) ? $link : '[URL]/[CODE]/';
        $hours = !empty($hours) ? $hours : 24;

        $div = new XMLElement('div', NULL, array('class' => 'group'));
        $div->appendChild(Widget::Label(__('Link (parameters: <em>[URL]</em>, <em>[CODE]</em>):'),
            Widget::Input('fields[' . $this->get('sortorder') . '][link]', (string)$link)));
        $div->appendChild(Widget::Label(__('Hours valid:'),
            Widget::Input('fields[' . $this->get('sortorder') . '][hours]', (string)$hours)));
        $wrapper->appendChild($div);

        $div = new XMLElement('div', NULL, array('class' => 'compact'));

        $label = Widget::Label();
        $label->setAttribute('class', 'meta');
        $input = Widget::Input('fields[' . $this->get('sortorder') . '][auto_delete]', 'yes', 'checkbox');
        if ($this->get('auto_delete') == 1) $input->setAttribute('checked', 'checked');

        $label->setValue($input->generate() . ' ' . __('Delete the entry when link is no longer valid'));
        $div->appendChild($label);

        $this->appendShowColumnCheckbox($div);
        $wrapper->appendChild($div);

    }

    public function createTable()
    {
        return Symphony::Database()->query(
            "CREATE TABLE IF NOT EXISTS `tbl_entries_data_" . $this->get('id') . "` (
				  `id` int(11) unsigned NOT NULL auto_increment,
				  `entry_id` int(11) unsigned NOT NULL,
				  `code` varchar(255) default NULL,
				  `timestamp` varchar(255) NOT NULL,
				  PRIMARY KEY  (`id`),
				  UNIQUE KEY `entry_id` (`entry_id`)
				) ENGINE=MyISAM;"
        );
    }


}