<!DOCTYPE html>
<html> 
<body> 
<?php
echo '<link rel='.'"'.'stylesheet'.'"'. 'type='.'"'.'text/css'.'"'. 'href='.'"'.'https://amjaysinglestoretest.myappts.ca/src/assets/ext/bootstrap/css/bootstrap.min.css?52FX8'.'"'.'>'; 
echo '<link rel='.'"'.'stylesheet'.'"'. 'type='.'"'.'text/css'.'"'. 'href='.'"'.'https://amjaysinglestoretest.myappts.ca/src/assets/ext/jquery-ui/jquery-ui.min.css?52FX8'.'"'.'>'; 
echo '<link rel='.'"'.'stylesheet'.'"'.'type='.'"'.'text/css'.'"'. 'href='.'"'.'https://amjaysinglestoretest.myappts.ca/src/assets/ext/jquery-qtip/jquery.qtip.min.css?52FX8'.'"'.'>'; 
echo '<link rel='.'"'.'stylesheet'.'"'. 'type='.'"'.'text/css'.'"'. 'href='.'"'.'https://amjaysinglestoretest.myappts.ca/src/assets/ext/trumbowyg/ui/trumbowyg.min.css?52FX8'.'"'.'>'; 
echo '<link rel='.'"'.'stylesheet'.'"'. 'type='.'"'.'text/css'.'"'. 'href='.'"'.'https://amjaysinglestoretest.myappts.ca/src/assets/css/backend.css?52FX8'.'"'.'>'; 
echo '<link rel='.'"'.'stylesheet'.'"'. 'type='.'"'.'text/css'.'"'. 'href='.'"'.'https://amjaysinglestoretest.myappts.ca/src/assets/css/general.css?52FX8'.'"'.'>'; 
echo '<link rel='.'"'.'stylesheet'.'"'. 'type='.'"'.'text/css'.'"'. 'href='.'"'.'https://amjaysinglestoretest.myappts.ca/src/assets/js/popup.js?52FX8'.'"'.'>'; 
require('config.php');
$linkID = new PDO('mysql:host='.Config::DB_HOST.';dbname='.Config::DB_NAME, Config::DB_USERNAME, Config::DB_PASSWORD);
$linkID->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // Setting ERRMODE
$q = intval($_GET['q']);

$result = $linkID->query("SELECT * FROM millie_service WHERE service='".$q."'")->fetchAll(PDO::FETCH_ASSOC);
echo $result[0]['service']; 
if($result[0]['service'] == null){

?>
    <div id="form-group">
<label for="email_header">Email Subject Line: (for reminders sent out 1 day before appt)</label><a href="https://myappts.org/images/header.png" target="_blank"><image src="info-icon.png" width="20" height="20"></a><br>
<textarea id="email_header" name="email_header" style="width: 1223px; height: 70px;"></textarea><br>
</div> 

<div id="form-group">
<label for="email_description">Email Body: (for reminders sent out 1 day before appt)</label><a href="https://myappts.org/images/description.png" target="_blank"><image src="info-icon.png" width="20" height="20"></a><br>
<textarea id="email_description" name="email_description" style="width: 1223px; height: 70px;"></textarea><br>
</div>

    <div id="form-group">
<label for="email_header_one">Email Subject Line: (for reminders sent out 1 day after appt was booked)</label><a href="https://myappts.org/images/header.png" target="_blank"><image src="info-icon.png" width="20" height="20"></a><br>
<textarea id="email_header_one" name="email_header_one" style="width: 1223px; height: 70px;"></textarea><br>
</div> 

<div id="form-group">
<label for="email_description_one">Email Body: (for reminders sent out 1 day after appt was booked)</label><a href="https://myappts.org/images/description.png" target="_blank"><image src="info-icon.png" width="20" height="20"></a><br>
<textarea id="email_description_one" name="email_description_one" style="width: 1223px; height: 70px;"></textarea><br>
</div>

    <div id="form-group">
<label for="text_message">Text Message(for reminders sent out 1 day before appt) </label><br> 
<textarea id="text_message" name="text_message" style="width: 1223px; height: 70px;"></textarea><br>
</div> 

 <div id="form-group">
<label for="text_message_one">Text Message(for reminders sent out 1 after appt was booked) </label><br> 
<textarea id="text_message_one" name="text_message_one" style="width: 1223px; height: 70px;"></textarea><br>
</div> 

<div id="form-group">
<image src="https://myappts.org/images/1.png" width="20" height="20"><label for="email_form">Form 1 - Link:</label><br>
<textarea id="email_form" name="email_form" style="width: 1223px; height: 70px;"></textarea><br> 
</div> 

<div id="form-group">
<image src="https://myappts.org/images/1.png" width="20" height="20"><label for="email_form_name">Form 1 - Name </label><br>
<textarea id="email_form_name" name="email_form_name" style="width: 1223px; height: 70px;"></textarea><br>  
</div> 

<div id="form-group">
<image src="https://myappts.org/images/1.png" width="20" height="20"><label for="email_form_description">Form 1 - Description</label><br>
<textarea id="email_form_description" name="email_form_description" style="width: 1223px; height: 70px;"></textarea><br>  
 </div>
 
<div id="form-group">
<image src="https://myappts.org/images/2.png" width="20" height="20"><label for="email_form2">Form 2 - Link</label><br>
<textarea id="email_form2" name="email_form2" style="width: 1223px; height: 70px;"></textarea><br>
</div> 

<div id="form-group">
<image src="https://myappts.org/images/2.png" width="20" height="20"><label for="email_header">Form 2 - Name</label><br>
<textarea id="email_form2_name" name="email_form2_name" style="width: 1223px; height: 70px;"></textarea><br>
</div> 

<div id="form-group">
<image src="https://myappts.org/images/2.png" width="20" height="20"><label for="email_header">Form 2 - Description</label><br>
<textarea id="email_form2_description" name="email_form2_description" style="width: 1223px; height: 70px;"></textarea><br>
 </div>
 
 <div id="form-group">
<image src="https://myappts.org/images/3.png" width="20" height="20"><label for="email_header">Form 3 - Link</label><br>
<textarea id="email_form3" name="email_form3" style="width: 1223px; height: 70px;"></textarea><br>
 </div>
 
 <div id="form-group">
<image src="https://myappts.org/images/3.png" width="20" height="20"><label for="email_header">Form 3 - Name</label><br>
<textarea id="email_form3_name" name="email_form3_name" style="width: 1223px; height: 70px;"></textarea><br>  
 </div>
 
 <div id="form-group">
<image src="https://myappts.org/images/3.png" width="20" height="20"><label for="email_header">Form 3 - Description</label><br>
<textarea id="email_form3_description" name="email_form3_description" style="width: 1223px; height: 70px;"></textarea><br>  
</div> 
<label for="reminder_on_off">Turn Reminders for this service off/on for reminders sent out 1 day before appt </label>
<select id="reminder_on_off" name="reminder_on_off">
<option value="OFF" name="reminder_on_off">OFF</option>
<option value="ON" name="reminder_on_off">ON</option>

</select><br><br>

<label for="reminder_on_off_one">Turn Reminders for this service off/on for reminders sent out 1 day after appt was booked </label>
<select id="reminder_on_off_one" name="reminder_on_off_one">
<option value="OFF" name="OFF">OFF</option>
<option value="ON" name="ON">ON</option>

</select><br><br>

<strong><h3>Reminders After Appointment (reminders sent out 1 day after appointment)</h3></strong><br><br> 
   <div id="form-group">
<label for="email_header_two">Email Subject Line: (reminders sent out 1 day after appointment)</label><a href="https://myappts.org/images/header.png" target="_blank"><image src="info-icon.png" width="20" height="20"></a><br>
<textarea id="email_header_two" name="email_header_two" style="width: 1223px; height: 70px;"></textarea><br>
</div> 

<div id="form-group">
<label for="email_description_two">Email Body: (for reminders sent out 1 day after appointment)</label><a href="https://myappts.org/images/description.png" target="_blank"><image src="info-icon.png" width="20" height="20"></a><br>
<textarea id="email_description_two" name="email_description_two" style="width: 1223px; height: 70px;"></textarea><br>
</div>

 <div id="form-group">
<label for="text_message_two">Text Message(for reminders sent out 1 day after appointment) </label><br> 
<textarea id="text_message_two" name="text_message_two" style="width: 1223px; height: 70px;"></textarea><br>
</div> 

<div id="form-group">
<image src="https://myappts.org/images/1.png" width="20" height="20"><label for="email_form_after">Form 1 - Link: (for reminders sent out 1 day after appointment)</label><br>
<textarea id="email_form_after" name="email_form_after" style="width: 1223px; height: 70px;"></textarea><br> 
</div> 

<div id="form-group">
<image src="https://myappts.org/images/1.png" width="20" height="20"><label for="email_form_after_name">Form 1 - Name: (for reminders sent out 1 day after appointment)</label><br>
<textarea id="email_form_after_name" name="email_form_after_name" style="width: 1223px; height: 70px;"></textarea><br>  
</div> 

<div id="form-group">
<image src="https://myappts.org/images/1.png" width="20" height="20"><label for="email_form_after_description">Form 1 - Description: (for reminders sent out 1 day after appointment)</label><br>
<textarea id="email_form_after_description" name="email_form_after_description" style="width: 1223px; height: 70px;"></textarea><br>  
 </div>
 
<div id="form-group">
<image src="https://myappts.org/images/2.png" width="20" height="20"><label for="email_form2_after">Form 2 - Link (for reminders sent out 1 day after appointment)</label><br>
<textarea id="email_form2_after" name="email_form2_after" style="width: 1223px; height: 70px;"></textarea><br>
</div> 

<div id="form-group">
<image src="https://myappts.org/images/2.png" width="20" height="20"><label for="email_form2_after_name">Form 2 - Name (for reminders sent out 1 day after appointment)</label><br>
<textarea id="email_form2_after_name" name="email_form2_after_name" style="width: 1223px; height: 70px;"></textarea><br>
</div> 

<div id="form-group">
<image src="https://myappts.org/images/2.png" width="20" height="20"><label for="email_form2_after_description">Form 2 - Description</label><br>
<textarea id="email_form2_after_description" name="email_form2_after_description" style="width: 1223px; height: 70px;"></textarea><br>
 </div>
 
 <div id="form-group">
<image src="https://myappts.org/images/3.png" width="20" height="20"><label for="email_form3_after">Form 3 - Link</label><br>
<textarea id="email_form3_after" name="email_form3_after" style="width: 1223px; height: 70px;"></textarea><br>
 </div>
 
 <div id="form-group">
<image src="https://myappts.org/images/3.png" width="20" height="20"><label for="email_form3_after_name">Form 3 - Name</label><br>
<textarea id="email_form3_after_name" name="email_form3_after_name" style="width: 1223px; height: 70px;"></textarea><br>  
 </div>
 
 <div id="form-group">
<image src="https://myappts.org/images/3.png" width="20" height="20"><label for="email_form3_after_description">Form 3 - Description</label><br>
<textarea id="email_form3_after_description" name="email_form3_after_description" style="width: 1223px; height: 70px;"></textarea><br>  
</div> 

<label for="reminder_on_off_two">Turn Reminders for this service off/on for reminders sent out 1 day after appt</label>
<select id="reminder_on_off_two" name="reminder_on_off_two">
    <option value="OFF" name="OFF">OFF</option>

<option value="ON" name="ON">ON</option>
</select><br><br>
<input type="submit" id="reminder_submit" name="reminder_submit"> 

<?php
}else{

foreach($result as $p){
    
    ?>
<strong><h3>Reminders Before Appointment (reminders sent out 1 day before appointment and 1 day after appointment was booked)</h3></strong><br><br> 
   <div id="form-group">
<label for="email_header">Email Subject Line: (for reminders sent out 1 day before appt)</label><a href="https://myappts.org/images/header.png" target="_blank"><image src="info-icon.png" width="20" height="20"></a><br>
<textarea id="email_header" name="email_header" style="width: 1223px; height: 70px;"><?php echo $p['email_header'] ?></textarea><br>
</div> 

<div id="form-group">
<label for="email_description">Email Body: (for reminders sent out 1 day before appt)</label><a href="https://myappts.org/images/description.png" target="_blank"><image src="info-icon.png" width="20" height="20"></a><br>
<textarea id="email_description" name="email_description" style="width: 1223px; height: 70px;"><?php echo $p['email_description'] ?></textarea><br>
</div>

    <div id="form-group">
<label for="email_header_one">Email Subject Line: (for reminders sent out 1 day after appt was booked)</label><a href="https://myappts.org/images/header.png" target="_blank"><image src="info-icon.png" width="20" height="20"></a><br>
<textarea id="email_header_one" name="email_header_one" style="width: 1223px; height: 70px;"><?php echo $p['email_header2'] ?></textarea><br>
</div> 

<div id="form-group">
<label for="email_description_one">Email Body: (for reminders sent out 1 day after appt was booked)</label><a href="https://myappts.org/images/description.png" target="_blank"><image src="info-icon.png" width="20" height="20"></a><br>
<textarea id="email_description_one" name="email_description_one" style="width: 1223px; height: 70px;"><?php echo $p['email_description2'] ?></textarea><br>
</div>

    <div id="form-group">
<label for="text_message">Text Message(for reminders sent out 1 day before appt) </label><br> 
<textarea id="text_message" name="text_message" style="width: 1223px; height: 70px;"><?php echo $p['text_message'] ?></textarea><br>
</div> 

 <div id="form-group">
<label for="text_message_one">Text Message(for reminders sent out 1 after appt was booked) </label><br> 
<textarea id="text_message_one" name="text_message_one" style="width: 1223px; height: 70px;"><?php echo $p['text_message_one'] ?></textarea><br>
</div> 

<div id="form-group">
<image src="https://myappts.org/images/1.png" width="20" height="20"><label for="email_form">Form 1 - Link:</label><br>
<textarea id="email_form" name="email_form" style="width: 1223px; height: 70px;"><?php echo $p['email_form'] ?></textarea><br> 
</div> 

<div id="form-group">
<image src="https://myappts.org/images/1.png" width="20" height="20"><label for="email_form_name">Form 1 - Name: </label><br>
<textarea id="email_form_name" name="email_form_name" style="width: 1223px; height: 70px;"><?php echo $p['email_form_name'] ?></textarea><br>  
</div> 

<div id="form-group">
<image src="https://myappts.org/images/1.png" width="20" height="20"><label for="email_form_description">Form 1 - Description:</label><br>
<textarea id="email_form_description" name="email_form_description" style="width: 1223px; height: 70px;"><?php echo $p['email_form_description'] ?></textarea><br>  
 </div>
 
<div id="form-group">
<image src="https://myappts.org/images/2.png" width="20" height="20"><label for="email_form2">Form 2 - Link</label><br>
<textarea id="email_form2" name="email_form2" style="width: 1223px; height: 70px;"><?php echo $p['email_form_two'] ?></textarea><br>
</div> 

<div id="form-group">
<image src="https://myappts.org/images/2.png" width="20" height="20"><label for="email_header">Form 2 - Name</label><br>
<textarea id="email_form2_name" name="email_form2_name" style="width: 1223px; height: 70px;"><?php echo $p['email_form_two_name'] ?></textarea><br>
</div> 

<div id="form-group">
<image src="https://myappts.org/images/2.png" width="20" height="20"><label for="email_header">Form 2 - Description</label><br>
<textarea id="email_form2_description" name="email_form2_description" style="width: 1223px; height: 70px;"><?php echo $p['email_form_two_description'] ?></textarea><br>
 </div>
 
 <div id="form-group">
<image src="https://myappts.org/images/3.png" width="20" height="20"><label for="email_header">Form 3 - Link</label><br>
<textarea id="email_form3" name="email_form3" style="width: 1223px; height: 70px;"><?php echo $p['email_form_three'] ?></textarea><br>
 </div>
 
 <div id="form-group">
<image src="https://myappts.org/images/3.png" width="20" height="20"><label for="email_header">Form 3 - Name</label><br>
<textarea id="email_form3_name" name="email_form3_name" style="width: 1223px; height: 70px;"><?php echo $p['email_form_three_name'] ?></textarea><br>  
 </div>
 
 <div id="form-group">
<image src="https://myappts.org/images/3.png" width="20" height="20"><label for="email_header">Form 3 - Description</label><br>
<textarea id="email_form3_description" name="email_form3_description" style="width: 1223px; height: 70px;"><?php echo $p['email_form_three_description'] ?></textarea><br>  
</div> 
<label for="reminder_on_off">Turn Reminders for this service off/on for reminders sent out 1 day before appt</label>
<select id="reminder_on_off" name="reminder_on_off">
<?php
if($p['send_reminder'] == "ON"){
?>
<option value="ON" name="ON" selected>ON</option>
<option value="OFF" name="OFF">OFF</option>

<?php
}else{
?>
<option value="ON" name="ON" >ON</option>
<option value="OFF" name="OFF" selected>OFF</option>
<?php
}
?>
</select><br><br>


<label for="reminder_on_off_one">Turn Reminders for this service off/on for reminders sent out 1 day after appt was booked</label>
<select id="reminder_on_off_one" name="reminder_on_off_one">
<?php
if($p['send_reminder2'] == "ON"){
?>
<option value="ON" name="ON" selected>ON</option>
<option value="OFF" name="OFF">OFF</option>

<?php
}else{
?>
<option value="ON" name="ON" >ON</option>
<option value="OFF" name="OFF" selected>OFF</option>
<?php
}
?>
</select><br>



<strong><h3>Reminders After Appointment (reminders sent out 1 day after appointment)</h3></strong><br><br> 
   <div id="form-group">
<label for="email_header_two">Email Subject Line: (reminders sent out 1 day after appointment)</label><a href="https://myappts.org/images/header.png" target="_blank"><image src="info-icon.png" width="20" height="20"></a><br>
<textarea id="email_header_two" name="email_header_two" style="width: 1223px; height: 70px;"><?php echo $p['email_header3'] ?></textarea><br>
</div> 

<div id="form-group">
<label for="email_description_two">Email Body: (for reminders sent out 1 day after appointment)</label><a href="https://myappts.org/images/description.png" target="_blank"><image src="info-icon.png" width="20" height="20"></a><br>
<textarea id="email_description_two" name="email_description_two" style="width: 1223px; height: 70px;"><?php echo $p['email_description3'] ?></textarea><br>
</div>

 <div id="form-group">
<label for="text_message_two">Text Message(for reminders sent out 1 day after appointment) </label><br> 
<textarea id="text_message_two" name="text_message_two" style="width: 1223px; height: 70px;"><?php echo $p['text_message_two'] ?></textarea><br>
</div> 

<div id="form-group">
<image src="https://myappts.org/images/1.png" width="20" height="20"><label for="email_form_after">Form 1 - Link: (for reminders sent out 1 day after appointment)</label><br>
<textarea id="email_form_after" name="email_form_after" style="width: 1223px; height: 70px;"><?php echo $p['email_form_after'] ?></textarea><br> 
</div> 

<div id="form-group">
<image src="https://myappts.org/images/1.png" width="20" height="20"><label for="email_form_after_name">Form 1 - Name: (for reminders sent out 1 day after appointment)</label><br>
<textarea id="email_form_after_name" name="email_form_after_name" style="width: 1223px; height: 70px;"><?php echo $p['email_form_after_name'] ?></textarea><br>  
</div> 

<div id="form-group">
<image src="https://myappts.org/images/1.png" width="20" height="20"><label for="email_form_after_description">Form 1 - Description: (for reminders sent out 1 day after appointment)</label><br>
<textarea id="email_form_after_description" name="email_form_after_description" style="width: 1223px; height: 70px;"><?php echo $p['email_form_after_description'] ?></textarea><br>  
 </div>
 
<div id="form-group">
<image src="https://myappts.org/images/2.png" width="20" height="20"><label for="email_form2_after">Form 2 - Link (for reminders sent out 1 day after appointment)</label><br>
<textarea id="email_form2_after" name="email_form2_after" style="width: 1223px; height: 70px;"><?php echo $p['email_form2_after'] ?></textarea><br>
</div> 

<div id="form-group">
<image src="https://myappts.org/images/2.png" width="20" height="20"><label for="email_form2_after_name">Form 2 - Name (for reminders sent out 1 day after appointment)</label><br>
<textarea id="email_form2_after_name" name="email_form2_after_name" style="width: 1223px; height: 70px;"><?php echo $p['email_form2_after_name'] ?></textarea><br>
</div> 

<div id="form-group">
<image src="https://myappts.org/images/2.png" width="20" height="20"><label for="email_form2_after_description">Form 2 - Description</label><br>
<textarea id="email_form2_after_description" name="email_form2_after_description" style="width: 1223px; height: 70px;"><?php echo $p['email_form2_after_description'] ?></textarea><br>
 </div>
 
 <div id="form-group">
<image src="https://myappts.org/images/3.png" width="20" height="20"><label for="email_form3_after">Form 3 - Link</label><br>
<textarea id="email_form3_after" name="email_form3_after" style="width: 1223px; height: 70px;"><?php echo $p['email_form3_after'] ?></textarea><br>
 </div>
 
 <div id="form-group">
<image src="https://myappts.org/images/3.png" width="20" height="20"><label for="email_form3_after_name">Form 3 - Name</label><br>
<textarea id="email_form3_after_name" name="email_form3_after_name" style="width: 1223px; height: 70px;"><?php echo $p['email_form3_after_name'] ?></textarea><br>  
 </div>
 
 <div id="form-group">
<image src="https://myappts.org/images/3.png" width="20" height="20"><label for="email_form3_after_description">Form 3 - Description</label><br>
<textarea id="email_form3_after_description" name="email_form3_after_description" style="width: 1223px; height: 70px;"><?php echo $p['email_form_three_description'] ?></textarea><br>  
</div> 
<label for="reminder_on_off_two">Turn Reminders for this service off/on for reminders sent out 1 day after appt</label>
<select id="reminder_on_off_two" name="reminder_on_off_two">
<?php
if($p['send_reminder3'] == "ON"){
?>
<option value="ON" name="ON" selected>ON</option>
<option value="OFF" name="OFF">OFF</option>

<?php
}else{
?>
<option value="ON" name="ON" >ON</option>
<option value="OFF" name="OFF" selected>OFF</option>
<?php
}
?>
</select><br><br>
<input type="submit" id="reminder_submit" name="reminder_submit"> 

<?php
}
}
?>
</body>
</html>