Jump to content

set checkbox value inside a table


ngrmm
 Share

Recommended Posts

I have a page with a table. Each table row has a page-reference field and a checkbox.
The Page sends emails to all users (page-refrence->email-field) and change the value of the checkbox in a row to 1.

It works with this:

<?php

	// event ID fron url query
	$eventID = $input->get('eventID','int');

	// get event-page
	$event = $pages->get($eventID);

	// config
	$fromEmail = $event->event_mail_from;
	$fromName = $event->event_mail_from_name;
	$emailSubject = $event->event_subject;

	// email html body
	ob_start();
	include('./_inc/emailbody.inc');
	$emailBody = ob_get_clean();

	// make event-page editable
	$event->of(false); 

	// loop through table and send out emails
	foreach($event->event_clients_list as $event_table_row) {
		
		// get client page
		$clientPage = $event_table_row->client_name;
      
      	// get client email
		$clientEmail = $clientPage->email;
		
		// if client isn't invited yet (checkbox not checked)
		if($event_table_row->client_invited == '') {

			// send email
			$m = new WireMail();
			$m->to($clientEmail);
			$m->from($fromEmail, $fromName);
			$m->subject($emailSubject);
			$m->bodyHTML($emailBody);
			$m->send();

			// mark client as invited
			$event_table_row->client_invited = 1;
			$event->save('event_clients_list');	
		}
	}
?>

But i have to use a variable in my emailbody.inc which i'm able to get in the table-loop.
So i do the including of the body inside my loop. But this doesn't work anymore. Page sends out the emails but is unable to change the value of the checkbox.
I get no errors!
I'm using ProTable

<?php

	// event ID fron url query
	$eventID = $input->get('eventID','int');

	// get event-page
	$event = $pages->get($eventID);

	// config
	$fromEmail = $event->event_mail_from;
	$fromName = $event->event_mail_from_name;
	$emailSubject = $event->event_subject;

	// loop through table and send out emails
	foreach($event->event_clients_list as $event_table_row) {
		
		// get client page
		$clientPage = $event_table_row->client_name;
      
      	// get client email
		$clientEmail = $clientPage->email;

		// email html body
		ob_start();
		include('./_inc/emailbody.inc');
		$emailBody = ob_get_clean();

		// make event-page editable
		$event->of(false); 
  
		// if client isn't invited yet (checkbox not checked)
		if($event_table_row->client_invited == '') {

			// send email
			$m = new WireMail();
			$m->to($clientEmail);
			$m->from($fromEmail, $fromName);
			$m->subject($emailSubject);
			$m->bodyHTML($emailBody);
			$m->send();

			// mark client as invited
			$event_table_row->client_invited = 1;
			$event->save('event_clients_list');	
		}
	}
?>

 

Link to comment
Share on other sites

Got it working by using two loops. One for sending out emails and the other for changing the value.
 

	
	
	// loop through table and send out emails
	foreach($event->event_clients_list as $event_table_row) {
		
		// get client page
		$clientPage = $event_table_row->client_name;
      
      	// get client email
		$clientEmail = $clientPage->email;

		// email html body
		ob_start();
		include('./_inc/emailbody.inc');
		$emailBody = ob_get_clean();

		if($event_table_row->client_invited == '') {

			// send email
			$m = new WireMail();
			$m->to($clientEmail);
			$m->from($fromEmail, $fromName);
			$m->subject($emailSubject);
			$m->bodyHTML($emailBody);
			$m->send();		

		}
	}

	// make event-page editable
	$event->of(false); 
	
	// loop through table and change value
	foreach($event->event_clients_list as $event_table_row) {

		// if client isn't invited yet (checkbox not checked)
		if($event_table_row->client_invited == '') {
			$event_table_row->client_invited = 1;
			$event->save('event_clients_list');	
		}
		
	}

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Similar Content

    • By Saleena Jhon
      Hello There, I have saw a post that was covering event-calendar with php, ajax and js. That was showing a monthly overview when I click on a "month" button or when I switch the month. And show the events on one particular date when I pick a day. Also, most events are kind of exhibitions and so they have a start date and an end date much later, and occur on each day in-between as well. So on the template I put two date picking fileds date_start and date_end. Is there an elegant way to select the events using the API? If yes, kindly help me out.
      Thanks in Advance
      Regards: 
       
    • By opalepatrick
      I am working on my first Process Module. I am creating forms. Fairly straightforward. However, I really can't work out how to create multiple fieldsets?
      $fieldset = $this->modules->get('InputfieldFieldset'); $fieldset->label = 'Customer Source'; $field = $this->modules->get('InputfieldPage'); $field->inputfield = 'InputfieldSelect'; $field->findPagesSelector = 'parent_id=1449, include=hidden'; $field->labelFieldName = 'yff-lead'; $field->name = 'yfflead'; $field->columnWidth = 16; $fieldset->add($field); $field = $this->modules->get('InputfieldPage'); $field->inputfield = 'InputfieldSelect'; $field->findPagesSelector = 'parent_id=1452, include=hidden'; $field->labelFieldName = 'customer-type'; $field->name = 'customertype'; $field->columnWidth = 16; $fieldset->add($field); //Rinse and Repeat $fieldset->label = 'Contacts'; $field = $this->modules->get('InputfieldPage'); $field->inputfield = 'InputfieldSelect'; $field->findPagesSelector = 'parent_id=1538, include=hidden'; $field->labelFieldName = 'salutation'; $field->name = 'salutation'; $field->columnWidth = 16; $fieldset->add($field); I can create the first fieldset (Customer Source) but then get into trouble as the second fieldset overwrites the first. I understand why, but trying to use the open and close fieldset routine has flummoxed me. Any help appreciated.
    • By VeiJari
      Hello forum, we're trying to use Processwire as our REST-API. We are having problems with our API login to Processwire from frontend. It gives us 403 error.
      We have installed ProcessWire to subdirectory (/api/*) and our frontend is static JS files at root ( / ). Apache access logs gives 404 to our POST-request, but browser devtools shows 403 for our POST /api/login request. 
      Processwire backend panel works. We also have a GET endpoint for the API that returns 200 with correct payload.  So we're wondering why does our GET works but POST doesn't?
      Does this have something to do with Processwire .htaccess, or is this because of our webhost? What should we check first? Any help would be appreciated.
    • By rjgamer
      Hi,
      is there a hook after the current (active) page got created? Or which method got called in the Page class after the Constructor of the current page got initialized?
      Thanks.
       
    • By killedfriendz
      I am very sorry for asking this but i totally do not understand how to set values of checbox using API. 
      I have checbox field on my page with name "order_status". 
      So i've tried few ways to make it checked but it still doesn't work:
       
      $userPage->order_status->value = 1; $userPage->order_status->add(1); $userPage->order_status->add(true); Could you please tell me how to do it?
×
×
  • Create New...