<?php
	require_once('pdoconfig.php');
    include('../_mail_fire.php');
	$catid=$_REQUEST['catid'];
	$act=$_REQUEST['act'];
	$fee=trim($_REQUEST['fee']);
	
	$crs_name=$_REQUEST['crsname'];
	$time=$_REQUEST['time'];
	$user=$_REQUEST['user'];
	
	$action1=$_REQUEST['action'];
	//if($active=='on'){ $aa1=1;}else{ $aa1=0;}


/*if($category=='' || strlen($category)>50)
{
   die("Something went wrong! <br> <a href='category_master.php'>Continue</a>");   
}*/

       if($act == "add")
		{
		$sql="insert into aa_booking_course set crs_id=?, time=?,fees=?,user_id=?,active=?"; 
			$arr=array($crs_name,$time,$fee,$user,$action1);
			$res=$action->insertp($sql,$arr);
	            if($res>0)
	            {
	            ?>
			    <script>
			        alert("Data Save successfully");
			        window.location.href="booking.php";				    
			    </script>
			    <?php
		    }
	    }
	    else if($act == "edit")
		{
		   // echo "update aa_booking_course set crs_id='$crs_name', time='$time',fee='$fee',user_id='$user',active='$action1' where booking_id='$catid'";
		   
		$sql="update aa_booking_course set crs_id=?, time=?,fees=?,user_id=?,active=? where booking_id=?";
		 	$arr=array($crs_name,$time,$fee,$user,$action1,$catid);
		 	$res=$action->updatep($sql,$arr);				

	            if($res>0)
	            {
	                $enq_id=$res;
	                if($action1==1 ||$action1 ==2)
	                {
	                 $sql="select * from aa_user_master where usr_id=$user";
	                $res=$action->select($sql);
	                foreach ($res as $id=>$row){
	                    $email=$row['email'];
	                }

	                
	                $mailtype='approve';
			    	$mailsubject="Tarang course booking status";
				    $mailtoken=$enq_id;
				    $mailto=$email;
				    mail_reg($mailto,$mailsubject,$mailtype,$mailtoken);

	                }
	            ?>
			    <script>
			        alert("Data update successfully");
			        window.location.href="booking.php";				    
			    </script>
			    <?php
		    }			
	    }
	    
	    else if($act == "del")
		{
			$sql="delete from aa_booking_course where booking_id=?"; 
			$arr=array($catid);
			
			$res=$action->deletep($sql,$arr);
				

	            if($res)
	            {
	            ?>
			    <script>
			        alert("Data delete successfully");
			        window.location.href="booking.php";				    
			    </script>
			    <?php
		    }			
	    }
	    
		
?>