perbaikan

<?php
/*
diperbaiki dgn menambahkan echo
oleh gbison( https://www.facebook.com/gbison?ref=tn_tnmn )
*/
if($save == 1) {
    $f = explode("/",$from_date);
    $from_date = $f[2]."-".$f[1]."-".$f[0];

    $t = explode("/",$to_date);
    $to_date = $t[2]."-".$t[1]."-".$t[0];

    $arrival_date=date("Y-m-d",strtotime($from_date));
    $depature_date= date("Y-m-d",strtotime($to_date));
    $d=date("d");
    $m=date("m");
    $y=date("y");
    $today=$y."-".$m."-".$d;
    $today=date("Y-m-d",strtotime($today));

    //end of the serial code genration

    //darimana sumber group??

    //if($group == "1") {
    if(intval($group)== 1) {
        $insgroup = "insert into tbl_group(nama_group) values('".
        mysql_real_escape_string($txtCust)." ".
        mysql_real_escape_string($last_name)."')";

        $g = mysql_query($insgroup) or die(mysql_error());

        $grp = ",'".mysql_insert_id()."'";
    } else {
        $grp = ",'0'";
    }

    echo "<br>memasukkan ke grup ".mysql_insert_id();
    $cnt = count($checkbox);

    if($cnt >= 1)
    {
        $t = "";
        for($r = 0;$r < $cnt; $r++) {

            $result = mysql_query("select max(cust_id) from tbl_customer")
                or die(mysql_error());
            $row = mysql_fetch_array($result);
            if($row[0]==0){
                $cust_id = 1;
            } else {
                $cust_id = $row[0]+1;
            }

            $t .= $cust_id.':';
            $sql1 = "insert into tbl_customer values";
            $sql1 .= "('".$cust_id."',
                     '".mysql_real_escape_string($txtCust)."',
                     '".mysql_real_escape_string($last_name)."',
                     '".mysql_real_escape_string($idcardnya)."',
                     '".mysql_real_escape_string($idcard1)."',
                     '".mysql_real_escape_string($txtAddress)."',
                     '".mysql_real_escape_string($city)."',
                     '".mysql_real_escape_string($country)."',
                     '$txtPhone',
                     '".mysql_real_escape_string($email)."',
                     '$txtAdults',
                     '$txtChild',
                     '".mysql_real_escape_string($agen)."',
                     '".mysql_real_escape_string($segment)."',
                     '".mysql_real_escape_string($kurs)."',
                     '".mysql_real_escape_string($company)."',
                     '".mysql_real_escape_string($source)."',
                     'RSN : ".mysql_real_escape_string($_SESSION["user"])."',
                     '".$birthday."'$grp,'')";

            echo "<br>Memasukkan data customer ";
            // $cust_id++;
            $query1 = mysql_query($sql1)
                or die(mysql_error());

            $inslog = "INSERT INTO log_hms(user,deskripsi,date,bill) values(
                '".$_SESSION['user']."',
                'reservation, guest name ".$txtCust." ".$last_name."',
                '".date("Y-m-d G:i:s",time())."',
                '-')";
            echo "<br>Membuat log";
            //echo $inslog;
            $qinslog = mysql_query($inslog)
                or die(mysql_error());
        }
    }
    //echo $t;
    $sq = substr($sql1,0,-1);
    // echo $sql1;

    if (mysql_error())
    {
        print mysql_error();
        print "<br />";
        exit();
    }

    $to_date2=date("m-d-Y",strtotime($to_date1));
    $from_date2=date("m-d-Y",strtotime($from_date1));
    $day_diff = getDateDifference($from_date2, $to_date2, 'd');

    $re = explode(":",$t);

    // lets start the transaction
    mysql_query("BEGIN");
    /*
        Bila ada error maka akan STOP
    */
    for($i=0;$i<$cnt;$i++)
    {
        //code for genrating the serial number for the table
        $result = mysql_query("select max(booking_code) from tbl_room_booked")
            or die(mysql_error());
        $row = mysql_fetch_array($result);
        if($row[0]==0)
        {   $book_id=1;  }
        else
        { $book_id=$row[0]+1; }
        //end of the serial code genration

        $bed = 1;

        $biaya = explode("-",$checkbox[$i]);
        //print_r($biaya);
        $r=mysql_query("select * from tbl_room where room_id='".$biaya[0]."'")
            or die(mysql_error());
        $room=mysql_fetch_array( $r);

        if(isset($bed)){
            if($bed=='1'){
                $charger = $harga[1];
            }
            else{
                $charger = $harga[1];
            }
        }
        else{
            $charger = $harga[1];
        }

        if($diskon[$i] != "0") {
            $diskonnya = ($diskon[$i]/100) * $harga[$i];

            $harganya = $harga[$i] - $diskonnya;

            $ins = "INSERT INTO tbl_discount
            (cust_id,diskon,persen,officer)
            VALUES
            ('".$re[$i]."','".$diskonnya."','".$diskon[$i]."',
            '".$_SESSION["user"]."')";

            $qins = mysql_query($ins) or die(mysql_error());
            echo "<br>Memasukkan jumlah diskon =$diskonnya";
        } else {
            $harganya = $harga[$i];
        }

        $sql2="insert into tbl_room_booked values('$book_id',
            '".$re[$i]."',
            '".$room["room_type_id"]."',
            '".$room["room_id"]."',
            '".$charger."',
            '$arrival_date',
            '$depature_date',
            '$today',
            '$bed',
            '".$harganya."',
            '')";

        //echo $sql2."<BR>";
        $query2 = mysql_query($sql2) or die(mysql_error());
        echo "<br>Memasukkan room book $book_id";
        $tbl_name="book_".$room["room_no"];

        $fromex = explode("-",$arrival_date);
        $from = $fromex[0]."-".$fromex[1]."-".$fromex[2];

        $toex = explode("-",$depature_date);
        $to = $toex[0]."-".$toex[1]."-".$toex[2];
        $cek = 1;

        for($j= strtotime($from);$j<=strtotime($to);$j = $j + 86400)
        {
            $cek = "select sr_no from ".$tbl_name." where date_duration = '".date('Y-m-d',$j)."'";

            $qcek = mysql_query($cek);
            $ju = mysql_num_rows($qcek);

            if($ju > 0)
            {
                $sql3 = "update ".$tbl_name." set status = 'R' where date_duration = '".date('Y-m-d',$j)."'";
                echo "<br>melakukan update $tbl_name ";
            }
            else
            {
                //code for genrating the serial number for the table
                $result = mysql_query("select max(sr_no) from $tbl_name") or
                    die(mysql_error());
                $row = mysql_fetch_array($result);
                if($row[0]==0) {
                    $sr_no=1;
                } else {
                    $sr_no = $row[0]+1;
                }
                //end of the serial code genration
                $sql3="insert into ".$tbl_name." values('$sr_no','".$room["room_no"]."','".date("Y-m-d",$j)."','R')";
                echo "<br>melakukan update $tbl_name ";
                //echo $query3;
            }

            $query3 = mysql_query($sql3) or
                die(mysql_error());
            echo "<br>menjalankan query";
            if($query3 != 1) {
                $cek = 0;
            }
        }
    }

    //  echo $query1."-".$query2."-".$query3;
    //$query2 = 0;
    if($query1 == 1 && $query2 == 1) {
        mysql_query("COMMIT");
        echo '<script language="javascript">alert("Reservation Success.");</script>';
        echo '<script language="javascript">
            window.location.href="sub_home.php?module=advance_payment_direct&cust_id='.$cust_id.'";
            </script>';
    } else {
        mysql_query("ROLLBACK");
        echo "<br>ROLLBACK ";
    }

    if($notfound == 1)
    {
        $ambilnegara = "select countrynm from tbl_country where country_id='".$country."'";
        $querynegara = mysql_query($ambilnegara);
        $data = mysql_fetch_array($querynegara);

        $in = "insert into tbl_city(city,country) values('".$city."','".$data["countrynm"]."')";
        $qu = mysql_query($in) or die(mysql_error());
        echo "<br>Memasukkan table city ";
    }
}