nuBuilder Forum

Code: Select all

//>>>JS
function testcase(drow){[

// Get the value of PK from cell 0
let idvtt=$('#nucell_'+drow+'_0').html(); //drow is the current row in the browse form

//sdass and sdimm are variables to determine which emails to send depending on certain values (works)
// drow is used to determine the next row to be use with the jscallback


nuRunPHPHiddenWithParams('Test_RHWP', 'param',{idvtt:idvtt,drow:drow,sdass:sdass,sdimm:sdimm},0);
}

Code: Select all

//>>>>PHP 'Test_RHWP' Procedure
function decodeEncodedString($encodedString) {
    $decodedString = base64_decode($encodedString);
    $decodedArray = json_decode($decodedString, true);
    return $decodedArray;
}

$result = decodeEncodedString('#param#');
if ($result != null) {
    // Retrieve values
    $idvtt = $result['idvtt'];
    $drow=$result['drow'];
    $sdass=$result['sdass'];
    $sdimm=$result['sdimm'];
	
// Retrive the data from a settings table that contains setting for sending email	
$setting_sql="SELECT ID_setting,vttemail_from,vttemail_fromname,vttemail_attfile,vttemail_html,vttemail_replyadd FROM tbl_vttsettings WHERE ID_setting=1";

$setting_sql_r=nuRunQuery($setting_sql);
    if(db_num_rows($setting_sql_r)<1) {
       nuDisplayError('Enregistrement introuvable!code 001'); 
    }else{
        $set_result=db_fetch_row($setting_sql_r);
        $emailfrom=$set_result[1];     // email from address
        $emailfromname=$set_result[2]; //email from name
        $emailatt=$set_result[3];      // email att file name
        $emailhtml=$set_result[4];     // email html
        $emailreply=$set_result[5];    // email reply to address
        
        
    }	
	
//Retrive data from table useing PK &idvtt

$sql_select="
		SELECT tbl_vtt.ID_vtt,
		tbl_vtt.PQ_vtt,
        tbl_vtt.AX_vtt,
        tbl_vtt.WR_vttass30,
        tbl_vtt.WR_asspd,
        tbl_vtt.WR_vttimm30,
        tbl_vtt.WR_immpd,
        tbl_vtt.DE_vttass,
        tbl_vtt.DE_vttimm,
		  datediff(tbl_vtt.DE_vttass,now()) as jrass,
		  datediff(tbl_vtt.DE_vttimm,now()) as jrimm,
		  tbl_membre.NC_membre,
		  tbl_membre.CR_membre
		
		FROM tbl_vtt
		JOIN tbl_membre ON tbl_vtt.ID_mbvtt = tbl_membre.ID_membre
		
        WHERE ID_vtt=".$idvtt;
        
    $stmt = nuRunQuery($sql_select);
    $num_rows = db_num_rows($stmt);
    //===================================
    if($num_rows>0){
    $row=db_fetch_row($stmt);
    }else{
        nuDisplayError('Enregistrement introuvable! code 002');   // end if($num_rows>0)
         } 

		 
		 
 // Retrieve the template data 
        $templateR = nuGetEmailTemplateData($template,"","vtt_reminder");
        if ($templateR == false) {
            nuDisplayError('Unknown email template! code 003');
        return;
		
		
//Set the email params

$email_params = array(
        'to' => $row[12], 					// email addresse from tbl_vtt
        'cc' => $templateR['cc'],			// cc from template
        'bcc' => $templateR['bcc'],			//bcc from template
        'body' => nl2br($templateR['body']),//body from template
        'subject' => $templateR['subject']	//subject from template
        );
        // set properties of other data needed for email fields
        nuSetProperty('ID_vtt',$row[0]);
		nuSetProperty('PQ_vtt',$row[1]);
        nuSetProperty('AX_vtt',$row[2]);
        nuSetProperty('WR_vttass30',$row[3]);
        nuSetProperty('WR_asspd',$row[4]);
        nuSetProperty('WR_vttimm30',$row[5]);
        nuSetProperty('WR_immpd',$row[6]);
        nuSetProperty('DE_vttass',$row[7]);
        nuSetProperty('DEvttimm',$row[8]);
		nuSetProperty('jrass',$row[9]);
		nuSetProperty('jrimm',$row[10]);
		nuSetProperty('NC_membre',$row[11]);
        
    foreach ($email_params as $key => $value) { // replace params value
        $email_params[$key] = nuReplaceHashVariables($value);
        
    }	
	
// Set the tag text	
$tag_text='VTT '.nuGetProperty('ID_vtt');

//>>>>>>send email
$r=nuSendEmail([
    'to' =>$email_params['to'], 				//
    'cc' => $email_params['cc'],
    'bcc' =>$email_params['bcc'],
    'body' => $email_params['body'],
    'subject' =>$email_params['subject'],
    'from'=> $emailfrom,						// from addresse setting table
    'fromname'=> $emailfromname,
    'attachments'=>[$filename=>$file],
    'html'=>$emailhtml,
    'reply_to_addresses'=>$emailreply
    
],$logOptions = [
    'tag' => $tag_text]);
    
            
} 
//if successful I update my tables 
//increment drow
$drow=$drow+1;
//use the callback to restart the function on the next row
$js = "testcase($drow);";
nuJavaScriptCallback($js);

Code: Select all

$result = nuSendEmail(
    $to,
    $fromAddress,
    $fromName,
    'body here...',
    'test subject...',
    [],
    true,
    '', // cc
    '', // bcc
    ['reply_to_address@mail.com']
);

Code: Select all

$emailData = [
    'to' => "dummy.to@example.com",
    'cc' => "dummy.cc@example.com",
    'bcc' => "dummy.bcc@example.com",
    'body' => nl2br("This is a dummy line 1\nThis is a dummy line 2"),
    'subject' => "Dummy Subject",
    'reply_to' => ["reply@example.com"],
    'priority' => 1,
    'attachments' => [],
    'html' => true
];


$emailLogOptions = [
    'table_name' => nuFormTable(), 
    'record_id' => nuRecordId(),
    'form_id' => nuFormId(),
    'tag' => 'mytag...',
    'user_id' => nuUserId(),
    'json' => '{"name": "John Doe","age": 30}' 
];

$sendResult = nuSendEmailEx($emailData, $emailLogOptions);

var_dump($sendResult);

Code: Select all

//Set up emailData 
$emailData = [
    'to' => "toemail@mail.com", //replace with to: email address
    'cc' => "ccemail@mail.com",  //replace with cc email address
    'bcc' => "bccemail@mail.com", //replace with dcc email address
    'body' => nl2br("This is a dummy line 1\nThis is a dummy line 2"), 
    'subject' => "Dummy Subject",
    'replyto' => ["replyto@mail.com"], //replace with reply to email address
    'priority' => 1,
    'attachments' => [], //files to include
    'html' => true,
    'from_email'=> "from_email@mail.com", // replace with from email address
    'from_name'=>’From name’ //replace with from name
];

// set log options
$emailLogOptions = [
    'table_name' => nuFormTable(), 
    'record_id' => nuRecordId(),
    'form_id' => nuFormId(),
    'tag' => 'mytag...',
    'user_id' => nuUserId(),
    'json' => '{"name": "John Doe","age": 30}' 
];
// Send using nuSendEmailEx
$sendResult = nuSendEmailEx($emailData, $emailLogOptions);
nuDebug($sendResult);

Code: Select all

$tag_text='tag text'; //set the text for tag_text
$file='/file_path/file_to_send';
$fimename='file name for file att';
	$email_params = [
        'to' => 'to_email@mail.com', 
        'cc' => $templateR['cc'], //load from template or text
        'bcc' => $templateR['bcc'], //load from template or text
        'body' => nl2br($templateR['body']), //load from template or text
        'subject' => $templateR['subject'], //load from template or text
        'replyto'=>$result['replytoadd'], //as text not array
        'priority' => '',
        'attachments' => '',//as text not array
        'html' => true,
        'from_email'=>from_email@mail.com,
        'from_name'=>'from_name'
        
        ];
$r=nuSendEmail([
    'to' =>$email_params['to'],
    'cc' => $email_params['cc'],
    'bcc' =>$email_params['bcc'],
    'body' => $email_params['body'],
    'subject' =>$email_params['subject'],
    'from_email'=> $email_params['from_email'],
    'from_name'=> $email_params['from_name'],
    'attachments'=>[$filename=>$file],//as array
    'html'=>$email_params['html'],
    'replyto'=>[$email_params['replyto']] //as array
    
],$logOptions = [
    'tag' => $tag_text,
    'json'=>'{"name":"me"}']);