Welcome, Guest

Call function within fly page for each pivot item

Page:
1

TOPIC:

Call function within fly page for each pivot item 28 Feb 2019 12:13 #15677

dyvel
Topic Author
Offline
Elite Member
Posts: 200
Thank you received: 11

I have 2 tables, teams and students.
Then 2 pivot tables, turnups and teamstudents

On my teams item page, I’m listing the pivot table teamstudents. All of this is working.
Now I would like a button next to each student, and when clicked it should add data to the turnups table.

I’m a bit stuck here

My button looks like this

<td>
			<?php echo JDom::_('html.link', array(
			 'commandAcl' => array('core.edit.own', 'core.edit'),
			 'content' => 'Turnup',
			 'num' => $rel->id,
			 'task' => 'team.turnup'
			));?>
		</td>

Controller -> team.php

protected function turnup($data = array(), $key = id) {
		

	}

Model -> team.php

public function turnup($data) {
			
		
	}

I have tried to create a send mail in controller and model function, but nothing happens, so I’m guessing the functions are never really called. What I’m I missing?

Any help is appreciated.

Please Log in or Create an account to join the conversation.

Last edit: by dyvel.

Call function within fly page for each pivot item 14 Mar 2019 21:00 #15679

admin Offline Administrator Chef Posts: 3711 Thank you received: 986	Did you got sorted out ? since then ? Coding is now a piece of cake
	Please Log in or Create an account to join the conversation.

Call function within fly page for each pivot item 02 Apr 2019 07:23 #15695

dyvel
Topic Author
Offline
Elite Member
Posts: 200
Thank you received: 11

admin wrote: Did you got sorted out ? since then ?

Almost, but not completely.
I have made my button look like this:

<a href="/index.php?option=com_cphdans&task=team.registerturnup&team=<?php echo $this->item->id; ?>&id=<?php echo $rel->id; ?>

This will trigger my team controller where I have a function called registerTurnup. This works.
But, my main issue now, is I'm redirected to a page without content instead of staying on the same page as the button.

I have tried a redirect back, but can't get HTTP_REFERER value in my controller function, so not sure how to solve that....

This is my function as of now:

$data = new stdClass();
		$data->student = JRequest::getInt('id',0);
		$data->team = JRequest::getInt('team',0);
		$data->date = date("Y-m-d H:i:s", strtotime("now"));
		
		$db 	= JFactory::getDbo();
		$sql = 'SELECT id FROM #__cphdans_turnups WHERE team = '.$data->team.' && student = '.$data->student.' && DATE(`date`) = CURDATE()';
		$db->setQuery($sql);
		
		// Brug loadResult() hvis der kun forventes en værdi
		$result =  $db->loadResult();
		
		if (!$result) { // insert timestamp			
			$result = JFactory::getDbo()->insertObject('#__cphdans_turnups', $data);
		}
		
		// TODO - GET THIS RIGHT...............................................................................................................
		
		// redirect user back to referring url
		$url = $_SERVER['HTTP_REFERER'];
		$this->setRedirect('/timeregistrering/team/team/391-hold-1'); // should be $url, but it is empty...
		
		// TODO - GET THIS RIGHT...............................................................................................................

Please Log in or Create an account to join the conversation.

Call function within fly page for each pivot item 02 Apr 2019 07:29 #15696

dyvel
Topic Author
Offline
Elite Member
Posts: 200
Thank you received: 11

BTW, the notification mail for your answer landed in my spam folder. Looked at the message headers and found this: Arc-Authentication-Results: ⁨i=1; mx.google.com; spf=softfail (google.com: domain of transitioning This email address is being protected from spambots. You need JavaScript enabled to view it. does not designate 2a01:7e00::f03c:91ff:febb:96e4 as permitted sender) smtp.mailfrom=support@j-cook.pro⁩

Looks like you need to add that IPV6 in your SPF DNS record

The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

Call function within fly page for each pivot item 09 Apr 2019 23:42 #15711

Nicolas Offline Premium Member Posts: 83 Thank you received: 12	Hi Dyvel why do not you do it in ajax if you have to stay on the same page? you make a call to your controller.yourTask to load or save datas. it's more fluid for the user and your server.
	Please Log in or Create an account to join the conversation. Last edit: by Nicolas.

Call function within fly page for each pivot item 09 Apr 2019 23:58 #15712

Nicolas Offline Premium Member Posts: 83 Thank you received: 12	A note appart, you're using the deprecated JRequest::getInt(); where you should be using $input = JFactory::getApplication()->input; $country_id = $input->getInt('country_id', 0); The following user(s) said Thank You: dyvel
	Please Log in or Create an account to join the conversation. Last edit: by Nicolas.

Call function within fly page for each pivot item 10 Apr 2019 05:59 #15713

dyvel Topic Author Offline Elite Member Posts: 200 Thank you received: 11	Nicolas wrote: Hi Dyvel why do not you do it in ajax if you have to stay on the same page? you make a call to your controller.yourTask to load or save datas. it's more fluid for the user and your server. Hi Nicolas AJAX would be a better solution, I agree. But I'm not sure how I should do it with AJAX.
	Please Log in or Create an account to join the conversation.

Call function within fly page for each pivot item 10 Apr 2019 08:27 #15715

Nicolas
Offline
Premium Member
Posts: 83
Thank you received: 12

Hi
For your buton you can try something like

<a id="yourId" class="btn btn-info btn-default"><i class="icon-joomla icon-joomla"></i> <?php echo JText::_('IF_YOU_NEED_A_TEXT'); ?></a>

And i don't know how you wanna take your datas and how you wanna use these, but your can call an ajax.post like :

jQuery.ajax({
     url:'index.php?option=com_component&task=controller.task',
     type: "POST",
     data: {
           '<?php echo JSession::getFormToken()?>': =1,
           'student': yourStudentValue,
           'team': yourTeamValue
     },
     success: function(data){
          //Do something on sucess ans reload same page
          location.reload();
     }
})

hope this help

Nicolas

The following user(s) said Thank You: dyvel

Please Log in or Create an account to join the conversation.

Last edit: by Nicolas.

Call function within fly page for each pivot item 23 Apr 2019 07:09 #15723

dyvel
Topic Author
Offline
Elite Member
Posts: 200
Thank you received: 11

Hi Nicolas

Your post really helped me getting ajax posting to work. Thanks.
For reference, I ended up with this:

<script>
	function registerTurnup(student) {
				
		jQuery.ajax({
			url:'/index.php?option=com_cphdans&task=team.registerturnup',
			type: "POST",
			data: {
				'id': student,
				'team': <?php echo $this->item->id; ?>
			},
			success: function(data){
				location.reload();
			}
		})
		
	}
</script>

And my button:

<a onclick="registerTurnup(<?php echo $rel->id; ?>)" class="uk-button uk-button-primary uk-align-right uk-margin-bottom-remove"><?php echo JText::_('CPHDANS_FIELD_TURNUP'); ?></a>

Please Log in or Create an account to join the conversation.

Call function within fly page for each pivot item 23 Apr 2019 12:49 #15725

Nicolas Offline Premium Member Posts: 83 Thank you received: 12	Hi Dyvel if everything works well it's great. Thank you for sharing I hope it will help other cooks
	Please Log in or Create an account to join the conversation.

Page:
1

Forum

Support forum

Coding inside your component

Call function within fly page for each pivot item

Time to create page: 0.077 seconds

“

”

Excellent Tool ! This tool will save you a lot of time writing the same old structure. I've used others but this is really nice for a quick start. Makes a 3 hour task a 15 minute one. Thanks for this extension
dickrundell (JED)

TOPIC:

Call function within fly page for each pivot item 28 Feb 2019 12:13 #15677

Call function within fly page for each pivot item 14 Mar 2019 21:00 #15679

Call function within fly page for each pivot item 02 Apr 2019 07:23 #15695

Call function within fly page for each pivot item 02 Apr 2019 07:29 #15696

Call function within fly page for each pivot item 09 Apr 2019 23:42 #15711

Call function within fly page for each pivot item 09 Apr 2019 23:58 #15712

Call function within fly page for each pivot item 10 Apr 2019 05:59 #15713

Call function within fly page for each pivot item 10 Apr 2019 08:27 #15715

Call function within fly page for each pivot item 23 Apr 2019 07:09 #15723

Call function within fly page for each pivot item 23 Apr 2019 12:49 #15725

Get Started

Newsletter