#Gocha#

<?php

// This file is part of Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle.  If not, see <http://www.gnu.org/licenses/>.

/** Configurable Reports
  * A Moodle block for creating customizable reports
  * @package blocks
  * @author: Juan leyva <http://www.twitter.com/jleyvadelgado>
  * @date: 2009
  */

require_once($CFG->dirroot.'/blocks/configurable_reports/plugin.class.php');

class plugin_puserfield extends plugin_base{
	
	function init(){
		$this->form = true;
		$this->unique = true;
		$this->fullname = get_string('puserfield','block_configurable_reports');
		$this->reporttypes = array('courses','sql','users','timeline','categories');
	}
	
	function summary($data){
		global $DB;
		
		if(strpos($data->field,'profile_') === 0){
			$name = $DB->get_field('user_info_field','name',array('shortname' => str_replace('profile_','', $data->field)));
			return $name .' = '.$data->value;
		}	
		return $data->field.' = '.$data->value;
	}
	
	function execute($userid, $context, $data){
		global $DB, $CFG;
		
		if(!$user = $DB->get_record('user',array('id' => $userid)))
			return false;
		
		if(strpos($data->field,'profile_') === 0){			
			if($profiledata = $DB->get_records_sql("SELECT d.*, f.shortname, f.datatype FROM {user_info_data} d ,{user_info_field} f 
							WHERE f.id = d.fieldid AND d.userid = ?", array($userid))){
				foreach($profiledata as $p){					
					$user->{'profile_'.$p->shortname} = $p->data;
				}
			}
		}
		
		if(isset($user->{$data->field}) && $user->{$data->field} == $data->value)
			return true;
		
		return false;
		
	}
	
}