<?php
 require_once('pdoconfig.php');


$mailtype=$_REQUEST['mailtype'];
$token=$_REQUEST['tokenid'];

    


if($mailtype=='register')
{
 	
   	 $stmt ="select * from aa_user_master where usr_id='$token'"; 
    
    $result=$action->select($stmt);
foreach($result as $id=>$row)
	$name=$row['name'];

    
?>
<div style="width:95%;float:left;padding:15px;border:1px solid#787878;">
<p>Dear <strong> <?=$name;?>,</strong><br /><br/></p>

<p>We'd like to thank you for registering with us. Tarang portal allows you to try different courses with expert trainers & support.</p>
<p>If you have any questions or concerns, please do not hesitate to email us. We're here to help you.</p>

<p><br/><br/><b>Thanking You</b> <br/><br/><br/>

Tarang Global School of Performing Arts, <br/>
45-A, Sector 12-A, Dwarka, <br/>
Delhi 110078 Phone: +91-9582226359 <br/>
Email: <a href="mailto:info@tarangglobal.com">info@tarangglobal.com</a><br/>
<a href="www.tarangglobal.com">www.tarangglobal.com</a><br/>
</p>
</div>

<?php } 

if($mailtype=='forgot')
{
 	
   	 $stmt ="select * from aa_user_master where usr_id='$token'"; 
    
    $result=$action->select($stmt);
    foreach($result as $id=>$row)
    {
	$name=$row['name'];
    $pass=$row['pass'];
    $email=$row['email'];
    
?>
<div style="width:95%;float:left;padding:15px;border:1px solid#787878;">

<p>Dear<strong> <?=$name;?>,</strong><br /><br/></p>
<p>We have received a request of forget password. </p>
<p><br>
Your Password for your name <?=$row['email'];?>  is : <?=$pass;?></p>

<p><br/><br/><b>Thanking You</b> <br/><br/><br/>

Tarang Global School of Performing Arts, <br/>
45-A, Sector 12-A, Dwarka, <br/>
Delhi 110078 Phone: +91-9582226359 <br/>
Email: <a href="mailto:info@tarangglobal.com">info@tarangglobal.com</a><br/>
<a href="www.tarangglobal.com">www.tarangglobal.com</a><br/>
</p>
</div>
<?php } }

if($mailtype=='join')
{

   	 $stmt ="select * from aa_booking_course,aa_course_master,aa_user_master where 1=1
			and aa_booking_course.crs_id=aa_course_master.crs_id
			and aa_booking_course.user_id=aa_user_master.usr_id
            and aa_booking_course.booking_id='$token'"; 
    
    $result=$action->select($stmt);
    foreach($result as $id=>$row)
    {
        $name=$row['name'];
        $active=$row['active'];
        $crs_name=$row['crs_name'];
    }
?>
<div style="width:95%;float:left;padding:15px;border:1px solid#787878;">
    
<p>Dear <strong><?=$name;?></strong><br /><br/><p>

<p>Thank you for showing interest in our course <B><?=$crs_name;?></B> at Trang Global.</p>
<p>Tarang team will revert you soon.</p>

<p><br/><br/><b>Thanking You</b> <br/><br/><br/>

Tarang Global School of Performing Arts, <br/>
45-A, Sector 12-A, Dwarka, <br/>
Delhi 110078 Phone: +91-9582226359 <br/>
Email: <a href="mailto:info@tarangglobal.com">info@tarangglobal.com</a><br/>
<a href="www.tarangglobal.com">www.tarangglobal.com</a><br/>
</p>


</div>

<?php  }

if($mailtype=='approve')
{
 	
   	 $stmt ="select * from aa_booking_course,aa_course_master,aa_user_master where 1=1
			and aa_booking_course.crs_id=aa_course_master.crs_id
			and aa_booking_course.user_id=aa_user_master.usr_id
			and aa_booking_course.user_id='$token'"; 
    
    $result=$action->select($stmt);
    foreach($result as $id=>$row)
    {
        $name=$row['name'];
        $active=$row['active'];
        $crs_name=$row['crs_name'];

        if($active==1){ 
                $act="approved";
        }
        else if($active==2)
        {
            $act="canceled";
        }
        else
        {
            $act="pending";
        }
    }
?>
<div style="width:95%;float:left;padding:15px;border:1px solid#787878;">

<p>Dear<strong> <?=$name;?>,</strong><br/><br/></p>


<p>Thank you for showing interest in our course <b><?=$crs_name;?></b>, it is <?=$act;?> with Trang Global.</p>
<p>We have approved your request, course related information is on following link</p>

<p><br/><br/><a href="http://www.tarangglobal.com/sign-in/">Your dashboard Link (use email as user name and password to login)</a></p>


<p><br/><br/><b>Thanking You</b> <br/><br/><br/>

Tarang Global School of Performing Arts, <br/>
45-A, Sector 12-A, Dwarka, <br/>
Delhi 110078 Phone: +91-9582226359 <br/>
Email: <a href="mailto:info@tarangglobal.com">info@tarangglobal.com</a><br/>
<a href="www.tarangglobal.com">www.tarangglobal.com</a><br/>
</p>
</div>
<?php }

if($mailtype=='studio')
{
$sql="SELECT *, (select GROUP_CONCAT(crs_name) from aa_studio_master where std_id in (std_actid)) purpose FROM aa_booking_studio, aa_user_master where aa_booking_studio.user_id= aa_user_master.usr_id and aa_booking_studio.std_bookid=$token";
 $result=$action->select($sql);
    foreach($result as $id=>$row)
    {
	$name=$row['name'];
	$sname=$row['purpose']."+";
    $bdate=$row['from_date']." to ".$row['to_date'];
    }
?>
<div style="width:95%;float:left;padding:15px;border:1px solid#787878;">
<p>Dear<strong> <?=$name;?>,</strong><br/><br/></p>

<p>We'd like to thank you for considering Tarang global to serve you. We have received the request to book studio for <?=$sname;?>:</p>
<p><br/>Date:<?=$bdate;?>
<p><br/><br/>We shall confirm you on status of your booking soon. If you have any questions or concerns, please do not hesitate to call or email us. We're here to help you. </p>

<p><br/><br/><b>Thanking You</b> <br/><br/><br/>

Tarang Global School of Performing Arts, <br/>
45-A, Sector 12-A, Dwarka, <br/>
Delhi 110078 Phone: +91-9582226359 <br/>
Email: <a href="mailto:info@tarangglobal.com">info@tarangglobal.com</a><br/>
<a href="www.tarangglobal.com">www.tarangglobal.com</a><br/>
</p>
</div>

<?php  }

if($mailtype=='inquiry')
{
 	
   	$stmt ="SELECT * FROM aa_enquiry where  enq_id='$token'"; 
    $result=$action->select($stmt);
    foreach($result as $id=>$row)
    {
        $date=$row['date'];
        $name=$row['name'];
        $email=$row['email'];
        $phone=$row['phone'];
        $subject=$row['subject'];
        $enquiry=$row['enquiry'];
    } 
?>
<div style="width:95%;float:left;padding:15px;border:1px solid#787878;">

<p>Dear<strong> <?=$name;?>,</strong><br/><br/></p>

<p>We'd like to thank you for considering Tarang global to serve you. We have received the query as below:</p>
<p>

<br/><b>Date:<?=$date;?></b> 
<br/><b>Subject:<?=$subject;?></b> 
<br/><b>Enquiry:<?=$enquiry;?></b> 
<br/><b>Email:<?=$email;?> </b>

<br/></p>

<p>We shall soon contact you on contact details provided by you. Our customers are our priority, but in case for some reason we are not able to connect you, please do not hesitate to call us. We're here to serveyou.</p>

<p><br/><br/><b>Thanking You</b> <br/><br/><br/>

Tarang Global School of Performing Arts, <br/>
45-A, Sector 12-A, Dwarka, <br/>
Delhi 110078 Phone: +91-9582226359 <br/>
Email: <a href="mailto:info@tarangglobal.com">info@tarangglobal.com</a><br/>
<a href="www.tarangglobal.com">www.tarangglobal.com</a><br/>
</p>
</div>
<?php  }
if($mailtype=='studio_update')
{
    
    $sqlstd ="SELECT *, (select GROUP_CONCAT(crs_name) from aa_studio_master where std_id in (std_actid)) purpose FROM aa_booking_studio, aa_user_master 
    where aa_booking_studio.user_id= aa_user_master.usr_id and aa_booking_studio.std_bookid='$token'"; 
    $result=$action->select($sqlstd);
    foreach($result as $id=>$row)
    {
        
        $name=$row['name'];
        $bdate=$row['from_date']." to ".$row['to_date'];
        $subject=$row['purpose'];
        $remarks=$row['remarks'];
    }
?>
<div style="width:95%;float:left;padding:15px;border:1px solid#787878;">

<p>Dear<strong> <?=$name;?>,</strong><br/><br/></p>

<p>We'd like to thank you for considering Tarang global to serve you. We have received the request to update your studio booking as below:</p><br/>
<b>Updated Status</b><br/>

<br/><b>Date:<?=$bdate;?></b> 
<br/><b>Purpose:<?=$subject;?></b> 
<br/><b>Remarks:<?=$remarks;?></b> 

<p>We shall confirm you on status of your booking soon. If you have any questions or concerns, please do not hesitate to call or email us. We're here to help you.</p>

<p><br/><br/><b>Thanking You</b> <br/><br/><br/>

Tarang Global School of Performing Arts, <br/>
45-A, Sector 12-A, Dwarka, <br/>
Delhi 110078 Phone: +91-9582226359 <br/>
Email: <a href="mailto:info@tarangglobal.com">info@tarangglobal.com</a><br/>
<a href="www.tarangglobal.com">www.tarangglobal.com</a><br/>
</p>
</div>
<?php  }
?>