Kursbokning

Kursens benämning:
Kursdatum: 3 september 2025
Plats: Karlstad


Sender = ('p.holmgren@sumab.se'); $mail->From = 'p.holmgren@saffleutvecklingsmodell.se'; $mail->addReplyTo = $_POST['field7']; $mail->FromName = 'Sumab Website'; $mail->addAddress('b.holmgren@sumab.se'); $mail->addCC('z.holmgren@sumab.se'); $mail->addCC($coursedetails['courseleaderEmail']); $mail->addBCC('dev@hqtdevelopment.co.uk'); $mail->WordWrap = 350; $mail->isHTML(true); $mail->Subject = utf8_decode('Kursanmälan'); $mail->Body = utf8_decode('

Kursens benämning: '.$coursetitle['coursetitle'].'
Kursdatum: '.formatdate($coursedetails['datefrom']).'
Plats: '.displaydata($coursedetails['location']).'


Förnamn: '.cleansedata($_POST['field1']).'
Efternamn: '.cleansedata($_POST['field16']).'
Adress 1: '.cleansedata($_POST['field2']).'
Adress 2: '.cleansedata($_POST['field3']).'
Postnummer/Ort: '.cleansedata($_POST['field4']).'
Epost-adress: '.cleansedata($_POST['field7']).'
Telefon: '.cleansedata($_POST['field8']).'
Mobiltelefon: '.cleansedata($_POST['field9']).'


Företag/Org: '.cleansedata($_POST['field10']).'
Faktureringsadress: '.cleansedata($_POST['field11']).'
Postnummer/Ort: '.cleansedata($_POST['field12']).'
Referenskod för fakturering: '.cleansedata($_POST['field13']).'
'); if(!$mail->send()) { echo 'Message could not be sent.'; echo 'Mailer Error: ' . $mail->ErrorInfo; exit; } $mail->Sender = ('p.holmgren@sumab.se'); $mail->From = 'p.holmgren@saffleutvecklingsmodell.se'; $mail->addReplyTo = 'p.holmgren@sumab.se'; $mail->FromName = utf8_decode('Säffle UtvecklingsModell'); $mail->addAddress($_POST['field7']); $mail->addCC('z.holmgren@sumab.se'); $mail->addCC('b.holmgren@sumab.se'); $mail->addCC($coursedetails['courseleaderEmail']); $mail->addBCC('dev@hqtdevelopment.co.uk'); $mail->WordWrap = 350; $mail->isHTML(true); $coursetitledetails = getcoursetitle($coursedetails['calendar']); $calendarheader = '

'.$_POST['field1'].'

'; $coursetext = $coursetitledetails['courseEmailTextCourseInfo']; $courseleaderName = $coursedetails['courseleaderName']; $courseleaderEmail = $coursedetails['courseleaderEmail']; $coursetext = str_replace("##COURSEDATEFROM##",formatdate3($coursedetails['datefrom']),$coursetext); $coursetext = str_replace("##COURSEDAY2##",formatdate3($coursedetails['day2']),$coursetext); $coursetext = str_replace("##COURSEDAY3##",formatdate3($coursedetails['day3']),$coursetext); $coursetext = str_replace("##COURSELOCATION##",$coursedetails['location'],$coursetext); $coursetext = str_replace("##COURSEADDRESS##",$coursedetails['address'],$coursetext); $coursetext = str_replace("##COURSEDAY2DAYMONTH##",date("d/m", strtotime($coursedetails['day2'])),$coursetext); //$coursetext = str_replace("##PARTICIPANTTABLE##",$participanttable,$coursetext); $coursetext = str_replace("##COURSELEADER##",$courseleaderName,$coursetext); //$coursetext = str_replace("##COURSELEADEREMAIL##",$courseleaderEmail,$coursetext); $calendarfooter = ''; $mail->Subject = utf8_decode($coursetitledetails['courseEmailTitleCourseInfo']); $mail->Body = utf8_decode($calendarheader.$coursetext.$calendarfooter); if(!$mail->send()) { echo 'Message could not be sent.'; echo 'Mailer Error: ' . $mail->ErrorInfo; exit; } $value = ''; if($coursedetails['calendar']=='1'){$value = '5900';} if($coursedetails['calendar']=='2'){$value = '3400';} if($coursedetails['calendar']=='3'){$value = '3900';} if($coursedetails['calendar']=='4'){$value = '3400';} if($coursedetails['calendar']=='5'){$value = '3400';} if($coursedetails['calendar']=='6'){$value = '2900';} if($coursedetails['calendar']=='8'){$value = '3400';} if($coursedetails['calendar']=='9'){$value = '3400';} $bookingdetails = array( "bookingName" => $_POST['field1'], "bookingLName" => $_POST['field16'], "bookingAddress1" => $_POST['field2'], "bookingAddress2" => $_POST['field3'], "bookingOrt" => $_POST['field4'], "bookingEmail" => $_POST['field7'], "bookingTel" => $_POST['field8'], "bookingMobile" => $_POST['field9'], "bookingOrg" => $_POST['field10'], "bookingAdd" => $_POST['field11'], "bookingOrt" => $_POST['field12'], "bookingRef" => $_POST['field13'], "Minkundnyckel" => "", "bookingCourseID" => $_GET['event'], "bookingCoursedate" => $coursedetails['datefrom'], "bookingLocation" => $coursedetails['location'], "bookingFood" => $_POST['field15'], "bookingCoursetitle" => $coursetitle['coursetitle'], "bookingValue" => $value, "invoice" => $_POST['invoice'], "utredningsanalys" => $_POST['utredningsanalys'], "utbildningshjalpmedel" => $_POST['utbildningshjalpmedel'] ); addbooking($bookingdetails); $mail = new PHPMailer; //if invoice now send email if($_POST['invoice']=='1'){ $invoicedetails = "Please invoice the following booking:

".$_POST['field1']." ".$_POST['field16']."

".$coursetitle['coursetitle']." - ".formatdate3($coursedetails['datefrom']); $mail->Sender = ('p.holmgren@sumab.se'); $mail->Subject = "Invoice required"; $mail->Body = $invoicedetails; $mail->From = 'p.holmgren@saffleutvecklingsmodell.se'; $mail->addReplyTo = 'p.holmgren@sumab.se'; $mail->FromName = utf8_decode('Säffle UtvecklingsModell'); $mail->addAddress("ekonomi@sumab.se"); $mail->WordWrap = 350; $mail->isHTML(true); $mail->send(); } if($_POST['utredningsanalys']=='1'){//create account $password = generatepassword(); $result = $mysqli->query("INSERT INTO examiner SET examinerFName='".cleansedata($_POST['field1'])."', examinerLName='".cleansedata($_POST['field16'])."', examinerEmail='".cleansedata($_POST['field7'])."', examinerTel='".cleansedata($_POST['field8'])."', examinerPassword = '".md5($password)."', examinerAddress1 = '".cleansedata($_POST['field2'])."', examinerAddress2 = '".cleansedata($_POST['field3'])."', examinerOrt = '".cleansedata($_POST['field4'])."', examinerCreateDate = now(), examinerOrg = '".cleansedata($_POST['field10'])."', examinerAddress3 = '".cleansedata($_POST['field11'])."', examinerOrt2 = '".cleansedata($_POST['field12'])."', examinerReference = '".cleansedata($_POST['field13'])."', examinerMobiletel = '".cleansedata($_POST['field9'])."' ") or die($mysqli->error.__LINE__); $body = "

Tack för din registrering av Utredningsanalys.

Vi har skapat ditt konto och inloggningsuppgifter ser du nedan:

Användarnamn: ".$_POST['field7']."
Lösenord: ".$password."

För att logga in klicka på länken nedan.

https://admin.sumab.se/clients

Säffle UtvecklingsModell AB
Gräsdalsgatan 4,
653 43 Karlstad.		 Bengt och Birgit Holmgren
Årets Företagare i Säffle 1992!
www.saffleutvecklingsmodell.se		 Tel 0533-164 20
b.holmgren@sumab.se
"; $mail = new PHPMailer; $mail->Sender = ('p.holmgren@sumab.se'); $mail->Subject = utf8_decode("Utredningsanalys"); $mail->Body = utf8_decode($body); $mail->From = 'p.holmgren@saffleutvecklingsmodell.se'; $mail->addReplyTo = 'p.holmgren@sumab.se'; $mail->FromName = utf8_decode('Säffle UtvecklingsModell'); $mail->addAddress($_POST['field7']); $mail->addCC($courseleaderEmail); $mail->addCC('z.holmgren@sumab.se'); $mail->addCC('b.holmgren@sumab.se'); $mail->addCC('p.holmgren@sumab.se'); $mail->addCC('ekonomi@sumab.se'); $mail->addBCC('dev@hqtdevelopment.co.uk'); $mail->WordWrap = 350; $mail->isHTML(true); $mail->send(); } if($_POST['utbildningshjalpmedel']=='1'){ $mail->Sender = ('p.holmgren@sumab.se'); $mail->From = 'p.holmgren@saffleutvecklingsmodell.se'; $mail->addReplyTo = $_POST['field7']; $mail->FromName = 'Sumab Website'; $mail->addAddress('p.holmgren@sumab.se'); $mail->addCC('z.holmgren@sumab.se'); $mail->addBCC('dev@hqtdevelopment.co.uk'); $mail->WordWrap = 350; $mail->isHTML(true); $mail->Subject = utf8_decode('Inkludera Utbildningshjälpmedel'); if($_POST['invoice']=='1'){$invoice = "Få fakturan med en gång";} else{$invoice = "Få fakturan efter kursen";} if($_POST['utredningsanalys']=='1'){ $utredningsanalys = 'Yes'; }else{ $utredningsanalys = 'No'; } if($_POST['utbildningshjalpmedel']=='1'){ $utbildningshjalpmedel = 'Yes'; }else{ $utbildningshjalpmedel = 'No'; } $mail->Body = utf8_decode('

Kursens benämning: '.$coursetitle['coursetitle'].'
Kursdatum: '.formatdate($coursedetails['datefrom']).'
Plats: '.displaydata($coursedetails['location']).'


Förnamn: '.cleansedata($_POST['field1']).'
Efternamn: '.cleansedata($_POST['field16']).'
Adress 1: '.cleansedata($_POST['field2']).'
Adress 2: '.cleansedata($_POST['field3']).'
Postnummer/Ort: '.cleansedata($_POST['field4']).'
Epost-adress: '.cleansedata($_POST['field7']).'
Telefon: '.cleansedata($_POST['field8']).'
Mobiltelefon: '.cleansedata($_POST['field9']).'


Företag/Org: '.cleansedata($_POST['field10']).'
Faktureringsadress: '.cleansedata($_POST['field11']).'
Postnummer/Ort: '.cleansedata($_POST['field12']).'
Referenskod för fakturering: '.cleansedata($_POST['field13']).'
Allergier eller andra önskemål: '.cleansedata($_POST['field15']).'
'.$invoice.'
Inkludera ITPA Utredningsanalys, 950kr per år: '.$utredningsanalys.'
Inkludera Utbildningshjälpmedel. '.$utbildningshjalpmedel.'
'); if(!$mail->send()) { echo 'Message could not be sent.'; echo 'Mailer Error: ' . $mail->ErrorInfo; exit; } } //send booking email if required $datetime1 = new DateTime(date("Y-m-d")); $datetime2 = new DateTime($coursedetails['datefrom']); $interval = $datetime1->diff($datetime2); $intervalI = $interval->format('%a'); if($intervalI<10){ $datefrom = $coursedetails['datefrom']; $location = $coursedetails['location']; $address = $coursedetails['address']; $courseleaderName = $coursedetails['courseleaderName']; $courseleaderEmail = $coursedetails['courseleaderEmail']; $stmtI = $mysqli -> prepare("SELECT bookingName, bookingAddress1,bookingEmail, bookingOrt, bookingLName FROM bookings WHERE bookingCourseid = ? AND bookingWaitingList = '0' ORDER BY bookingLName ASC, bookingName ASC"); $stmtI -> bind_param('i', $_GET['event']); $stmtI -> execute(); $stmtI->bind_result($bookingName, $bookingAddress1,$bookingEmail, $bookingAddress3, $bookingName1); $result = $stmtI->store_result(); $participants = array(); while ($stmtI->fetch()) { $participants[] = array($bookingName, $bookingAddress1,$bookingEmail, $bookingAddress3, $bookingName1); } $participanttable = ""; foreach ($participants as &$value) { $participanttable .=" ";} $participanttable .="
".$value[0]." ".$value[4]." ".$value[1]." ".$value[3]." ".$value[2]."
"; $calendarheader = '

'; $calendarfooter = ''; $coursetext = $coursetitledetails['courseEmailTextDeltagarforteckning']; $coursetext = str_replace("##COURSEDATEFROM##",formatdate3($coursedetails['datefrom']),$coursetext); $coursetext = str_replace("##COURSEDAY2##",formatdate3($coursedetails['day2']),$coursetext); $coursetext = str_replace("##COURSEDAY3##",formatdate3($coursedetails['day3']),$coursetext); $coursetext = str_replace("##COURSELOCATION##",$coursedetails['location'],$coursetext); $coursetext = str_replace("##COURSEADDRESS##",$coursedetails['address'],$coursetext); $coursetext = str_replace("##COURSEDAY2DAYMONTH##",date("d/m", strtotime($coursedetails['day2'])),$coursetext); $coursetext = str_replace("##PARTICIPANTTABLE##",$participanttable,$coursetext); $coursetext = str_replace("##COURSELEADER##",$courseleaderName,$coursetext); $coursetext = str_replace("##COURSELEADEREMAIL##",$courseleaderEmail,$coursetext); mail("dave@highqualitytechnology.co.uk","sumab",$courseleaderName." - ".$coursedetails['courseleaderEmail']); //add attachments if($coursedetails['calendar']=='1'){ $mail->addAttachment("/var/www/vhosts/sumab.se/httpdocs/admin/ITPA-3-ahorarkopior.pdf");} if($coursedetails['calendar']=='2'){ } if($coursedetails['calendar']=='3'){ $mail->addAttachment("/var/www/vhosts/sumab.se/httpdocs/admin/LOGOS_certifieringskurs_handouts.pdf");} if($coursedetails['calendar']=='4'){ } if($coursedetails['calendar']=='7'){ $mail->addAttachment("/var/www/vhosts/sumab.se/httpdocs/admin/Nyanlandas-Larande-RichardWieland-ahorkopia.pdf");} $mail->Sender = ('p.holmgren@sumab.se'); $mail->Body = $body; $mail->Subject = utf8_decode($coursetitledetails['courseEmailTitleDeltagarforteckning']); $mail->Body = utf8_decode($calendarheader.$coursetext.$calendarfooter); $mail->From = 'p.holmgren@saffleutvecklingsmodell.se'; $mail->addReplyTo = $courseleaderEmail; $mail->FromName = utf8_decode('Säffle UtvecklingsModell'); $mail->addAddress($_POST['field7']); $mail->addCC($courseleaderEmail); $mail->addCC('z.holmgren@sumab.se'); $mail->addCC('b.holmgren@sumab.se'); $mail->addCC('p.holmgren@sumab.se'); $mail->addBCC('dev@hqtdevelopment.co.uk'); $mail->WordWrap = 350; $mail->isHTML(true); if(!$mail->send()) { echo 'Message could not be sent.'; echo 'Mailer Error: ' . $mail->ErrorInfo; exit; } } //check number of bookings if full $stmtI = $mysqli -> prepare("SELECT bookingName FROM bookings WHERE bookingCourseid = ?"); $stmtI -> bind_param('i', $_GET['event']); $stmtI -> execute(); $stmtI->bind_result($bookingName); $result = $stmtI->store_result(); $numberofrows = $stmtI->num_rows; if($numberofrows >= $coursedetails['numberofplaces']){ $body = "The following course is now full

".$coursetitle['coursetitle'] ." - ".formatdate3($coursedetails['datefrom']).' - '.$coursedetails['location'].' '.$coursedetails['address']; $mail = new PHPMailer; $mail->Body = $body; $mail->Subject = utf8_decode('Course Full'); $mail->Sender = ('p.holmgren@sumab.se'); $mail->From = 'p.holmgren@saffleutvecklingsmodell.se'; $mail->addReplyTo = $courseleaderEmail; $mail->FromName = utf8_decode('Säffle UtvecklingsModell'); $mail->addAddress('z.holmgren@sumab.se'); $mail->addBCC('dev@hqtdevelopment.co.uk'); $mail->WordWrap = 350; $mail->isHTML(true); if(!$mail->send()) { echo 'Message could not be sent.'; echo 'Mailer Error: ' . $mail->ErrorInfo; exit; } } $transactiontotal = 0; if($coursedetails['calendar']=='1'){$transactiontotal = $transactiontotal+5900; } if($coursedetails['calendar']=='2'){$transactiontotal = $transactiontotal+3400; } if($coursedetails['calendar']=='3'){$transactiontotal = $transactiontotal+3900; } if($coursedetails['calendar']=='4'){$transactiontotal = $transactiontotal+3400; } if($coursedetails['calendar']=='5'){$transactiontotal = $transactiontotal+3400; } if($coursedetails['calendar']=='7'){$transactiontotal = $transactiontotal+2900; } if($coursedetails['calendar']=='8'){$transactiontotal = $transactiontotal+3400; } if($coursedetails['calendar']=='9'){$transactiontotal = $transactiontotal+3400; } if($_POST['utredningsanalys']=='1'){ $transactiontotal = $transactiontotal+995; } $transactionid = getlastbookingid(); echo "Tack"; ?>




Få fakturan med en gång
Få fakturan efter kursen
Vänligen bekräfta att vi får spara och kontakta er via den epostadress ni uppgivit.