Pupulating relationship field in stand-alone edit form

31 Mar 2009

This might be unnecessary with latest version of FormHelper. Or might still be needed Please make sure you have latest version first.

I've extended capabilities of Solspace Form_Helper plugin.
Now you can easily manipulate your custom relationship fields in ExpressionEngine stand-alone edit form.
Please note that you need the Form Helper plugin, that you can obtain here. Currently only 'weblog' type of relationship is supported.

Just add anywhere in the plugin body new function:

	// ----------------------------------------
	//  Custom Relationship
	// ----------------------------------------
	
	function custom_relationship()
	{
		global $DB, $TMPL;
		
		$entry_id	= ( $TMPL->fetch_param('entry_id') ) ? $TMPL->fetch_param('entry_id'): '';
		$field_name	= ( $TMPL->fetch_param('field_name') ) ? $TMPL->fetch_param('field_name'): '';
		
		$getweblog		= $DB->query("SELECT f.field_id, f.field_related_id AS id FROM exp_weblog_fields AS f, exp_weblogs AS w WHERE f.group_id=w.field_group AND f.field_name='".$field_name."'");

		if ($getweblog->num_rows == 0) {return;}

		$values		= $DB->query("SELECT DISTINCT entry_id AS eid, title AS et FROM exp_weblog_titles WHERE weblog_id='".$getweblog->row['id']."' AND status!='closed'");

		if ($values->num_rows == 0) {return;}
		
		$selected		= $DB->query("SELECT r.rel_child_id AS id FROM exp_relationships AS r WHERE r.rel_parent_id='".$entry_id."'");

		if ($selected->num_rows == 0) {$selected->row['id']='';}

		// ----------------------------------------
		//  Parse tagdata
		// ----------------------------------------
		$output	= '';
		
		foreach($values->result as $row)

		{
			$tagdata	= $TMPL->tagdata;
			
			if ( $row['eid'] == $selected->row['id'] )
			{
				$tagdata	= $TMPL->swap_var_single('selected', 'selected', $tagdata);
				$tagdata	= $TMPL->swap_var_single('checked', 'checked', $tagdata);
			}
			else
			{
				$tagdata	= $TMPL->swap_var_single('selected', '', $tagdata);
				$tagdata	= $TMPL->swap_var_single('checked', '', $tagdata);
			}
			
			$tagdata	= $TMPL->swap_var_single('field_id', $getweblog->row['field_id'], $tagdata);
			$tagdata	= $TMPL->swap_var_single('value', $row['eid'], $tagdata);
			$tagdata	= $TMPL->swap_var_single('label', $row['et'], $tagdata);
			
			$output		.= $tagdata;
		}
		//	End parse tagdata
		
		return $output;
	}
	
	//	End custom Relationship

Usage instuctions:
{exp:form_helper:custom_relationship entry_id="{entry_id}" field_name="summaries"}{/exp:form_helper:custom_relationship}

Note that this tag requires an entry_id.

Example 1
<select name="{exp:form_helper:field_grabber field_name='summaries'}"> {exp:form_helper:custom_relationship entry_id="{entry_id}" field_name="summaries"} <option value="{value}" {selected}>{label}</option> {/exp:form_helper:custom_relationship} </select> <input type="hidden" name="{exp:form_helper:field_grabber field_name='summaries' which='format'}" value="br" />

Example 2
{exp:form_helper:custom_relationship entry_id="{entry_id}" field_name="summaries"} <input type="radio" name="{field_id}" value="{value}" {checked}>{label} {/exp:form_helper:custom_relationship} <input type="hidden" name="{exp:form_helper:field_grabber field_name='summaries' which='format'}" value="br" />

Comments

Luke 18 Aug 2009

#reply

This is great thanks!

My relationship options were very lengthy, so I added an ‘ORDER BY title’ to the end of your sql query to get an alphabeticised listing of options.
liseli sikiş 02 May 2010

#reply

Great article. I really like it. Thanks for information a lot.

Comments are closed. To get support, email .(JavaScript must be enabled to view this email address).

intoEEtive

ExpressionEngine PRO Network member

Main Menu

Reach me via:

Pupulating relationship field in stand-alone edit form

Comments

Sidebar

Using my add-on?

GET ADDON OF YOUR CHOICE — FOR FREE!

Featured EE Add-ons

Featured EE Add-ons

About