.-.-.-.-.-

<?php

// No direct access
defined( '_JEXEC' ) or die;
// Подключаем библиотеку controlleradmin Joomla.
jimport('joomla.application.component.controlleradmin');

/**
 * Controller for list current element
 * @author Aleks.Denezh
 */
class PollControllerAnswers extends JControllerAdmin
{

/**
	 * Class constructor
	 * @param array $config
	 */
	function __construct( $config = array() )
	{
		parent::__construct( $config );
	}

/**
	 * Method to get current model
	 * @param String $name (model name)
	 * @param String $prefix (model prefox)
	 * @param Array $config
	 * @return model for current element
	 */
	public function getModel( $name = 'Answer', $prefix = 'PollModel', $config = array( 'ignore_request' => true ) )
	{
		return parent::getModel( $name, $prefix, $config );
	}

/**
	 * Method to save the submitted ordering values for records via AJAX.
	 * @return    void
	 */
	public function saveOrderAjax()
	{
		$pks = $this->input->post->get( 'cid', array(), 'array' );
		$order = $this->input->post->get( 'order', array(), 'array' );

// Sanitize the input
		JArrayHelper::toInteger( $pks );
		JArrayHelper::toInteger( $order );

// Get the model
		$model = $this->getModel();

// Save the ordering
		$return = $model->saveorder( $pks, $order );

if ( $return ) {
			echo '1';
		}

// Close the application
		JFactory::getApplication()->close();
	}
	
	
	
	public function export()
	{
		require_once getcwd().'/components/com_poll/PHPExcel/PHPExcel.php';
		$objPHPExcel = new PHPExcel();
		// устанавливаем метаданные
		$objPHPExcel->getProperties()->setCreator("PHP")
						->setLastModifiedBy("Kirdin Yuri")
						->setTitle("Export")
						->setSubject("Export")
						->setDescription("Export")
						->setKeywords("Export")
						->setCategory("Export");
		$objPHPExcel->getActiveSheet()->setTitle('Export');
		
		$row=1;
		$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow(0,$row, 'id');
		$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow(1,$row, 'date');
		$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow(2,$row, 'code');
		$row++;
		
		// Get the input
		$input = JFactory::getApplication()->input;
		$pks = $input->post->get('cid', array(), 'array');

$db = JFactory::getDbo();
		foreach ($pks as $item)
		{
			$list = $db->setQuery( 'SELECT * FROM #__pollanswers where id='.$item)->loadAssoc();
			if (count($list)<>0)
			{
				$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow(0,$row, $list['id']);
				$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow(1,$row, $list['date']);
				$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow(2,$row, $list['code']);
				
				$list2 = $db->setQuery( 'SELECT * FROM #__pollanswer where ans_id='.$list['id'].' order by que_id')->loadObjectList();
				$ansn=3;
				foreach($list2 as $str)
				{
					$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow($ansn,$row, $str->que_id.": ".$str->value);
					$ansn++;
				}
				$row++;
			}
		}
		
		require_once getcwd().'/components/com_poll/PHPExcel/PHPExcel/IOFactory.php';
		$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
		$objWriter->save('poll_export.xlsx');

// Redirect to the list screen.
		$this->setRedirect(JRoute::_('index.php?option=com_poll&view=answers', false));

}
	
	
		public function exportall()
	{
		require_once getcwd().'/components/com_poll/PHPExcel/PHPExcel.php';
		$objPHPExcel = new PHPExcel();
		// устанавливаем метаданные
		$objPHPExcel->getProperties()->setCreator("PHP")
						->setLastModifiedBy("Kirdin Yuri")
						->setTitle("Export")
						->setSubject("Export")
						->setDescription("Export")
						->setKeywords("Export")
						->setCategory("Export");
		$objPHPExcel->getActiveSheet()->setTitle('Export');
		
		$row=1;
		$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow(0,$row, 'id');
		$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow(1,$row, 'date');
		$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow(2,$row, 'code');
		$row++;

$db = JFactory::getDbo();
		$list = $db->setQuery( 'SELECT * FROM #__pollanswers order by id desc')->loadAssocList();
					
		if (count($list)<>0)
		{
			foreach ($list as $item)
			{

$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow(0,$row, $item['id']);
				$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow(1,$row, $item['date']);
				$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow(2,$row, $item['code']);
				
				$list2 = $db->setQuery( 'SELECT * FROM #__pollanswer where ans_id='.$item['id'].' order by que_id')->loadObjectList();
				$ansn=3;
				foreach($list2 as $str)
				{
					$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow($ansn,$row, $str->que_id.": ".$str->value);
					$ansn++;
				}
				$row++;
			}
		}
		
		require_once getcwd().'/components/com_poll/PHPExcel/PHPExcel/IOFactory.php';
		$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
		$objWriter->save('poll_export.xlsx');

// Redirect to the list screen.
		$this->setRedirect(JRoute::_('index.php?option=com_poll&view=answers', false));

}
	
	
}

/var/www/iplanru/data/www/./i-plan.ru/administrator/components/com_poll/controllers/answers.php