proses

public function doCreateTransaksiNEW($kode_transaksi,$id_peminjam,$isbn,$batas_ambil,$tanggal_pinjam,$tanggal_kembali,$status)
    {

#####################
# MAKE TOKEN RANDOM #
#####################

        $token = random_token(5);

#########
# QUERY #
#########

        // CHECKING TRANSAKSI BERJALAN!

        $CTB = $this->conn->prepare("
            SELECT *
            FROM tbl_transaksi
            WHERE id_peminjam =:id_peminjam AND status=:stat_1 OR id_peminjam =:id_peminjam AND status=:stat_2");
        $CTB->execute(array(
            ':id_peminjam'=>$id_peminjam,
            ':stat_1'=>'wishlist',
            ':stat_2'=>'proses'
        ));
        $h_CTB = $CTB->fetch(PDO::FETCH_ASSOC);
        if($h_CTB > 0)
        {
            $message = "Gagal Melakukan Transaksi : Anda Sedang Melakukan Transaksi!";

            return $message;
        }

        $queryText = "INSERT INTO tbl_transaksi(kode_transaksi,id_peminjam,isbn,batas_ambil,tanggal_pinjam,tanggal_kembali,token,status) VALUES('$kode_transaksi',$id_peminjam, ";
        $queryBack = ",'$batas_ambil','$tanggal_pinjam','$tanggal_kembali','$token','$status')";
        $countArray = count(array_filter($isbn));
        $deleteQuery = "DELETE FROM keranjang WHERE (id_peminjam,isbn) IN (";


        // CHECKING STOCK OF BOOK IN LIB
        for ($i=0; $i < $countArray ; $i++) {
            $queryCB = $this->conn->prepare("SELECT * FROM tbl_buku WHERE isbn='" . $isbn[$i] . "'");
            $queryCB->execute();
            $bookONE = $queryCB->fetch(PDO::FETCH_ASSOC);
            $jumlah = $bookONE['stock'];
            $dipinjam = $bookONE['dipinjam'];
            $dapatD = $jumlah - $dipinjam;
            if($dapatD <= 1)
            {
                $message = 'Gagal Melakukan Transaksi : Mohon Maaf Buku Anda Yang Berjudul "'. $bookONE['nama_buku'] .'" Tidak dapat Dipinjam. Dikarenakan Stock Pada Perpustakaan Tidak Ada. Mohon Maaf Atas Ketidak Nyamanannya!';
                return $message;
            }
            else
            {
                $queryUB = "UPDATE tbl_buku SET dipinjam = dipinjam + 1 WHERE isbn='$isbn[$i]'";
                $queryUBB = $this->conn->prepare($queryUB);
                $queryUBB->execute();
            }
        }
#$$$$$$$$$$$$$$#
# POWER OF LIFE#
################
            for($i=0; $i < $countArray; $i++)
            {
                $del[$i] = "('$id_peminjam','" . $isbn[$i] . "')";
            }
################
 # COUNT ARRAY #
 ###############

        if($countArray == 1)
        {
            $query = $queryText ."'" . $isbn[0] .",'" . $queryBack;
            $query_2 = $deleteQuery . $del[0] .')';
        }
        else if($countArray == 2)
        {
            $query = $queryText ."'" . $isbn[0] . ',' .$isbn[1] .",'" . $queryBack;
            $query_2 = $deleteQuery . $del[0] . ',' . $del[1] .')';
        }
        else if($countArray == 3)
        {
            $query = $queryText ."'" . $isbn[0] . ',' . $isbn[1]  . ',' . $isbn[2] .",'" . $queryBack;
            $query_2 = $deleteQuery . $del[0] . ',' . $del[1] . ',' . $del[2] .')';
        }
        else
        {
            $message ="Jumlah Judul Hanya Boleh 1-3!";
            return $message;
        }

###########
# PROSESS #
###########
        $proses = $this->conn->prepare($query);
        $proses_2 = $this->conn->prepare($query_2);
        $proses->execute();
        $proses_2->execute();

        return true;
    }