<?php
class TestimonialsAdmin extends Testimonials
{
	public $insert_submit_name = 'sub';
	public $edit_submit_name = 'sub';
	public $fields;

	function __Construct()
	{
		parent::__Construct();
	}

	public function _delete($id)
	{
		Database::ado_execute_query("DELETE FROM $this->db_table WHERE id='$id' LIMIT 1");
	}
	
	function set_fields($form_type, $db_default=FALSE, $db_fields='')
	{
		// db_default var if true sets default field vals to db val
		// form type of edit means that form has not yet been submitted
		switch($form_type)
		{
			case 'insert':
				$submitname = $this->insert_submit_name;
				$submitvalue = "e n t e r   t e s t i m o n i a l";
				break;
			case 'edit':
				$submitname = $this->edit_submit_name;
				$submitvalue = "s u b m i t   c h a n g e s";
				break;
		} // switch
		$this->fields = array(
			'enter_date' => array(
				'type' => array(
					'tag' => 'input_hidden'
				)
			),
			'text' => array(
				'label' => 'Text',
				'label_css' => 'black_11_bold',
				'type' => array(
					'tag'=> 'textarea',
					'cols' => 40,
					'rows' => 10
				)
			),
			'person' => array(
				'label' => 'Person',
				'label_css' => 'black_11_bold',
				'type' => array(
					'tag'=> 'input_text',
					'input_size' => 20,
					'char_max' => 50
				),
				'validation' => array('required')
			),
			'place' => array(
				'label' => 'Place',
				'label_css' => 'black_11_bold',
				'type' => array(
					'tag'=> 'input_text',
					'input_size' => 30,
					'char_max' => 100
				),
			),
			'status' => array(
				'label' => 'Web Status',
				'label_css' => 'black_11_bold',
				'type' => array(
					'tag' => 'select',
					'options' => array('active'=>'active','inactive'=>'inactive'),
					'top_option' => array(),
				),
				'validation' => array('required'),
				'default' => 'inactive'
			),
			$submitname => array(
				'type' => array(
					'tag'=> 'input_submit',
				),
				'input_css' => 'blue_submit',
				'default' => $submitvalue,
			)
		);
		if($db_default)
		{
			foreach($this->fields as $fieldName=>$fieldInfo)
			{
				$exclude_fields = array();
				if(!in_array($fieldName, $exclude_fields) && $fieldInfo['type']['tag'] != 'input_submit' && $fieldInfo['type']['tag'] != 'input_hidden')
				{
					$default = $db_fields[$fieldName];
					$this->fields[$fieldName]['default'] = $default;
				}
			}
		}
	}

	function _insert($TestimonialForm)
	{
		$ins = "INSERT INTO $this->db_table (";
		$i = 0;
		$ins_val = " VALUES(";
		foreach($TestimonialForm->fields as $field_name => $field_info)
		{
			++$i;
			if($field_name != $this->insert_submit_name)
			{
				$ins .= $field_name.',';
				switch($field_name)
				{
					case 'enter_date': $ins_val .= 'NOW(),'; break;
					default: $ins_val .= "'".trim(addslashes($field_info['value']))."',";			
				}
			}
		}
		$ins = substr($ins, 0, strlen($ins)-1) . ')';
		$ins_val = substr($ins_val, 0, strlen($ins_val)-1) . ')';
		$insert = $ins.$ins_val;
		//echo $insert;
		if(!$t_id = Database::ado_execute_query($insert, 'TestimonialAdmin::_insert'))
		{
			return(FALSE);
		}
		else
		{
			Utilities::notify(Config::$tech_email, 'Testimonial Inserted', $t_id);
			return($t_id);
		}
	}

	function _update($TestimonialForm, $testimonial_id)
	{
		$upd = "UPDATE $this->db_table SET";
		$i = 0;
		foreach($TestimonialForm->fields as $field_name => $field_info)
		{
			++$i;
			if($field_info['type']['tag'] != 'input_submit' && $field_info['type']['tag'] != 'input_hidden')
			{
				switch($field_name)
				{
					default: $upd .= " $field_name='".trim(addslashes($field_info['value']))."',";			
				}
			}
		}
		$upd = substr($upd, 0, strlen($upd)-1) . " WHERE id='".$testimonial_id."' LIMIT 1";
		//echo $upd;
		$affected_rows = Database::ado_execute_query($upd, 'TestimonialAdmin::_update');
		if($affected_rows === FALSE)
		{
			return(FALSE);
		}
		else
		{
			Utilities::notify(Config::$tech_email, 'Testimonial Updated', $upd);
			return(TRUE);
		}
	} // update	
}
?>