Text area driver

gistfile1.aw

<?php

/*
 * Import Driver
 *
 * Each field should have a specific class for import-export functions.
 * When none is found, the default fallback is this class.
 */

class ImportDriver_textarea {

    protected $type;
    protected $field;

    /**
     * Constructor
     * @return void
     */
    public function ImportDriver_textarea()
    {
        $this->type = 'textarea';
    }

    /**
     * Set a reference to the field object.
     * @param  $field   The field
     * @return void
     */
    public function setField($field)
    {
        $this->field = $field;
    }

    /**
     * Get the type of the driver
     * @return string
     */
    public function getType()
    {
        return $this->type;
    }

    /**
     * Process the data so it can be imported into the entry.
     * @param  $value       The value to import
     * @param  $entry_id    If a duplicate is found, an entry ID will be provided.
     * @return The data returned by the field object
     */
    public function import($value, $entry_id = null)
    {
        $data = $this->field->processRawFieldData(trim($value), $this->field->__OK__, false, $entry_id);
        return $data;
    }

    /**
     * Process the data so it can be exported to a CSV
     * @param  $data    The data as provided by the entry
     * @param  $entry_id    The ID of the entry that is exported
     * @return string   A string representation of the data to import into the CSV file
     */
    public function export($data, $entry_id = null)
    {
        if(isset($data['value']))
        {
            if(!is_array($data['value']))
            {
                return '';
            } else {
                return trim(implode(array_filter($data['value'])));
            }
        } else {
            return '';
        }
    }

    /**
     * Scan the database for a specific value
     * @param  $value       The value to scan for
     * @return null|string  The ID of the entry found, or null if no match is found.
     */
    public function scanDatabase($value)
    {
        $result = Symphony::Database()->fetch('DESCRIBE `tbl_entries_data_' . $this->field->get('id') . '`;');
        foreach ($result as $tableColumn)
        {
            if ($tableColumn['Field'] == 'value') {
                $searchResult = Symphony::Database()->fetchVar('entry_id', 0, 'SELECT `entry_id` FROM `tbl_entries_data_' . $this->field->get('id') . '` WHERE `value` = \'' . addslashes(trim($value)) . '\'');
                if ($searchResult != false) {
                    return $searchResult;
                } else {
                    return null;
                }
            }
        }
    }

}