<?php
include "config.php";
$id_boat=$_GET['id_boat'];
$price_q=  mysql_query("select PRICE,PRICE_C from tb_boat where ID_BOAT=$id_boat");
$price_h=  mysql_fetch_array($price_q);
$boat_Name=$_GET['boatName'];
$trip_route=$_GET['tripRoute'];
$trip_method=$_GET['tripMethod'];
$depart_Date=$_GET['departDate'];
$return_Date=$_GET['returnDate'];
$adults=$_GET['Adults'];
$children=$_GET['Children'];
$hotel_name=$_GET['hotel'];
$hotel_room=$_GET['room'];
$nama_CP=$_GET['name'];
$email2=$_GET['email'];
$phone=$_GET['phone'];
$special_req=$_GET['spec_req'];
$total_p = $adults+$children;
$a=1;
$i=0;
$abcd="";
//tb_passanger + GROUP


$Status="0";

// Num Book
$date_book1= explode("/", $depart_Date);
$date_book2= explode("/", $return_Date);
$angka="123456789";
$count_db=  mysql_query("Select COUNT(ID_BOOK) from tb_booking");
$count_db_hs=  mysql_fetch_array($count_db);
$count=$count_db_hs[0]+1;
$num_book= "GBT".$date_book1[0].$date_book2[0].$date_book1[2].substr(str_shuffle($angka), 0,4).$count;

//Total Price
$ad_price=$price_h[0]*$adults;
$ch_price=$price_h[1]*$children;
$total_P=$ad_price+ $ch_price;

//date Depart & Return
$tglDepart=$date_book1[0];
$blnDepart=$date_book1[1];
$thDepart=$date_book1[2];
$date_Desave=$thDepart."-".$blnDepart."-".$tglDepart; // Tanggal Depart Save To DB

$tglReturn=$date_book2[0];
$blnReturn=$date_book2[1];
$thReturn=$date_book2[2];
$date_Resave=$thReturn."-".$blnReturn."-".$tglReturn; // Tanggal Return Save To DB


//query save

$query=mysql_query("SELECT GROUP_P FROM tb_passanger order by GROUP_P DESC limit 1 ");
        $hc=  mysql_fetch_array($query);
        $group=$hc[0]+1;
$id_book=  mysql_query("select ID_BOOK from tb_booking order by ID_BOOK DESC limit 1 ");
$id_book_hsl=  mysql_fetch_array($id_book);
$id_booking=$id_book_hsl[0]+1;
        for($x=1;$x<=$total_p;$x++)
        {
             $nama[$x]=$_GET['nP'.$x];
           $cek=mysql_query("Insert into tb_passanger (ID,ID_BOOK,GROUP_P,NAMA_P) values ('','$id_booking','$group','$nama[$x]')");
                $a++;
        };


$query="insert into tb_booking (ID_BOOK,NUMBER_BOOK,GROUP_P,ID_BOAT,METHOD,ROUTE,DEPART_DATE,RETURN_DATE,ADULTS,CHILDREN,HOTEL,HOTEL_ROOM,NAME,EMAIL,PHONE,SPECIAL_REQ,CH_PRICE,AD_PRICE,TOTAL_PRICE,Status) values ('','$num_book','$group','$id_boat','$trip_method','$trip_route','$date_Desave','$date_Resave','$adults','$children','$hotel_name','$hotel_room','$nama_CP','$email2','$phone','$special_req','$ch_price','$ad_price','$total_P','$Status')";
$save=  mysql_query($query);


 $email_cek=mysql_query("select*from tb_booking order by ID_BOOK desc LIMIT 1");
    $email_cek_hasil=  mysql_fetch_array($email_cek);
    echo $email_cek_hasil[2];
    $isi_email=  mysql_query("SELECT
        tb_booking.NUMBER_BOOK,
        tb_boat.NAMA_BOAT,
        tb_booking.METHOD,
        tb_booking.ROUTE,
        tb_booking.DEPART_DATE,
        tb_booking.RETURN_DATE,
        tb_booking.ADULTS,
        tb_booking.CHILDREN,
        tb_booking.HOTEL,
        tb_booking.HOTEL_ROOM,
        tb_booking.PHONE,
        tb_booking.SPECIAL_REQ,
        tb_booking.TOTAL_PRICE,
        tb_booking.STATUS
        FROM tb_passanger INNER JOIN tb_booking
        ON tb_passanger.ID_BOOK=tb_booking.ID_BOOK
        INNER JOIN
        tb_boat
        ON tb_booking.ID_BOAT=tb_boat.ID_BOAT
        WHERE tb_booking.GROUP_P=$email_cek_hasil[2]");
    $isi_email_hasil=  mysql_fetch_array($isi_email);
    $nama_P=  mysql_query("SELECT
                        tb_passanger.NAMA_P
                        FROM tb_passanger INNER JOIN tb_booking
                        ON tb_passanger.ID_BOOK=tb_booking.ID_BOOK
                        WHERE tb_passanger.GROUP_P=$email_cek_hasil[2]");
    while($nama_P_hasil=  mysql_fetch_array($nama_P))
            {
              $nama_P_hasil[0];
              }

if($save)
{
    /* echo "<script>alert('Thanks For Your Booking We will Confirm your booking as fast as we can , we will send you an email later.');location.href='index.php';</script>";*/
    //query untuk isi email



date_default_timezone_set("Asia/Singapore");
include('phpmailer/class.phpmailer.php');
        include('phpmailer/class.smtp.php');
        $mail = new PHPMailer();
            $mail->Host     = "ssl://smtp.gmail.com";
            $mail->Mailer   = "smtp";
            $mail->SMTPAuth = true;
        //email from
            $mail->Username = "emailtestdps@gmail.com";
            $mail->Password = "emailtest123";
            $webmaster_email= "emailtestdps@gmail.com";
        //email to
            $email = "gilibudgetcontact@gmail.com";
            $name = "Gili Budget";
        //email from
            $mail->From = $webmaster_email;
            $mail->FromName = "Gili Budget Ticket Contact System";
            $mail->AddAddress($email2,$nama_CP);
            $mail->AddReplyTo($email,"Gili Budget Ticket");
            $mail->WordWrap = 50;
            $mail->IsHTML(true);
            $mail->Subject = "Booking Confirmation";
            $body = "
                            <font face='Verdana, Geneva, sans-serif' size='2'>New Booking From, <b>$email2</b></font><br><br>
                            <font face='Verdana, Geneva, sans-serif' size='2'>
                                Email Received On ".date("d-m-Y")." ".date("h:i:a")."
                            </font>
                            <br><br>
                            <font face='Verdana, Geneva, sans-serif' size='2'>
                            <b>The Message Is : </b> <br><br>
                            <table border='1'>
                                <tr>
                                    <td bgcolor='#D4D4D4'>Booking Number :</td>
                                    <td>$isi_email_hasil[0]</td>
                                </tr>
                                <tr>
                                    <td background='#D4D4D4'>Passanger Name :</td>
                                    <td>""</td>
                                </tr>";

            // loop your code here
            while($isi_email_hasil){
                //your code here, append $body user $body .= 'value'
                $body .= "<tr>
                           <td background='#D4D4D4'>Boat Name :</td>
                            <td>$isi_email_hasil[1]</td>
                        </tr>
            }


            $body .= "</table>
                            </font>
                            <br><br>
                            <font face='Verdana, Geneva, sans-serif' size='2'>
                            Thanks.
                            </font>
                            <br>
                            <font face='Verdana, Geneva, sans-serif' size='2'>
                            Gili Budget Ticket
                            </font>
                            <br><br><br>
                            <font face='Verdana, Geneva, sans-serif' size='1' color='#FF0000'>
                            NOTE:
                            </font>
                            <br>
                            <font face='Verdana, Geneva, sans-serif' size='1'>
                            This Email was send from our system , do not reply this email.
                            </font>
                            <br>
                            <br>
                        ";

            $mail->Body = $body;
            $mail->AltBody = "This is the body when user views in plain text format";
            if(!$mail->Send())
            {
               echo "Mailer Error: " . $mail->ErrorInfo;
            }
            else
            {
             /* echo "<script> alert('Message has been sent successfully');location.href='index.php';sem</script>"; */
            }


}
else
{

    /*echo "<script>alert('Something Wrong With The Data , Try Again Later');location.href='index.php';</script>";*/
}
?>