<?xml version="1.0" encoding="utf-8"?> <install version="1.5" type="plugin" group="k2" method="upgrade"> <name>LoadCSV K2 Plugin</name> <author>HardKiffeur</author> <creationDate>3 Aout, 2012</creationDate> <copyright>Copyright (c) 2012 hardkiffeur. All rights reserved.</copyright> <authorEmail>[email protected]</authorEmail> <authorUrl>www.hardkiffeur.com</authorUrl> <version>1</version> <license>http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL</license> <description>An K2 plugin to extend item, category forms in K2 with a CSV loading for Table outputing in front into item with data.</description> <files> <filename plugin="loadcsv">loadcsv.php</filename> </files> <!-- Standard plugin parameters for Joomla! 1.5 --> <params> <param name="mycsvfile" type="filelist" default="" label="Select a csv file" description="" directory="csv" filter="" exclude="" stripext="" /> </params> <!-- Standard plugin parameters for Joomla! 1.6+ --> <config> <fields name="params"> <fieldset name="basic"> <field name="mycsvfile" type="filelist" default="" label="Select a csv file" description="" directory="csv" filter="" exclude="" stripext="" /> </fieldset> </fields> </config> <!-- K2 plugin parameters which extend K2 backend forms are defined here. We use the same syntax as Joomla! 1.5 only, yet they are compatible with Joomla! 1.7 as well. These parameters are parsed by K2 only and we decided to just make things easier for developers, instead of opting for double parameters in 'params' and 'fields' blocks. --> <params group="item-content"> <param name="mycsvfile" type="filelist" default="" label="Select a csv file" description="" directory="csv" filter="" exclude="" stripext="" /> </params> </install>

<files> <folder>csv</folder> </files>

 <?php /** * @version 1 * @package csv loader (K2 plugin) * @author Hardkiffeur http://hardkiffeur.com * @copyright Copyright (c) 2012 Hardkiffeur. All rights reserved. * @license GNU/GPL license: http://www.gnu.org/copyleft/gpl.html */ // no direct access defined('_JEXEC') or die ('Restricted access'); /** * Load a csv K2 Plugin, to render a tabla from csv entered in backend K2 forms to table full of data information in the frontend. */ // Load the K2 Plugin API JLoader::register('K2Plugin', JPATH_ADMINISTRATOR.DS.'components'.DS.'com_k2'.DS.'lib'.DS.'k2plugin.php'); // Initiate class to hold plugin events class plgK2Loadcsv extends K2Plugin { // Some params var $pluginName = 'LoadCSV'; var $pluginNameHumanReadable = 'Load CSV data K2 Plugin'; function plgK2Loadcsv( & $subject, $params) { parent::__construct($subject, $params); } /** * Below we list all available FRONTEND events, to trigger K2 plugins. * Watch the different prefix "onK2" instead of just "on" as used in Joomla! already. * Most functions are empty to showcase what is available to trigger and output. A few are used to actually output some code for example reasons. */ function onK2PrepareContent( &$item, &$params, $limitstart) { $mainframe = &JFactory::getApplication(); //$item->text = 'It works! '.$item->text; } function onK2AfterDisplay( &$item, &$params, $limitstart) { $mainframe = &JFactory::getApplication(); return ''; } function onK2BeforeDisplay( &$item, &$params, $limitstart) { $mainframe = &JFactory::getApplication(); return ''; } function onK2AfterDisplayTitle( &$item, &$params, $limitstart) { $mainframe = &JFactory::getApplication(); return ''; } function onK2BeforeDisplayContent( &$item, &$params, $limitstart) { $mainframe = &JFactory::getApplication(); return ''; } // Event to display (in the frontend) the YouTube URL as entered in the item form function onK2AfterDisplayContent( &$item, &$params, $limitstart) { $mainframe = &JFactory::getApplication(); // Get the K2 plugin params (the stuff you see when you edit the plugin in the plugin manager) $plugin = &JPluginHelper::getPlugin('k2', $this->pluginName); $pluginParams = new JParameter($plugin->params); // Get the output of the K2 plugin fields (the data entered by your site maintainers) $plugins = new K2Parameter($item->plugins, '', $this->pluginName); $mycsvfile = $plugins->get('mycsvfile_item'); // Check if we have a value entered if ( empty($mcsvfile)) return; // Output $output = ' <?php echo "<table>\n"; $row = 0; $handle = fopen("$mycsvfile", "r"); while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { if ($row == 0) { // this is the first line of the csv file // it usually contains titles of columns $num = count($data); echo "<thead>\n<tr>"; $row++; for ($c=0; $c < $num; $c++) { echo "<th>" . $data[$c] . "</th>"; } echo "</tr>\n</thead>\n\n<tbody>"; } else { // this handles the rest of the lines of the csv file $num = count($data); echo "<tr>"; $row++; for ($c=0; $c < $num; $c++) { echo "<td>" . $data[$c] . "</td>"; } echo "</tr>\n"; } } fclose($handle); echo "</tbody>\n</table>"; ?> '; return $output; } } // END CLASS