Default page

Viewing : list.php

<div class="d-flex justify-content-between align-items-sm-center flex-column flex-sm-row mb-3">
    <div class="me-4 mb-3 mb-sm-0">
        <h1 class="mb-0"><?=$title?></h1>
    </div>
</div>

<div class="row">
    <div class="col-12 mb-4">
        <div class="card border-start-lg border-start-primary h-100 card card-header-actions">
            <div class="card-header">
                <div id="export"></div>
                <div class="card-tools">
                    <a class="btn btn-primary btn-sm" href="<?=base_url('pembayaran/sync')?>">Sycn</a>
                    <a class="btn btn-primary btn-sm" onclick="edit('0')">Tambah</a>                    
                </div>
            </div>                                               
            <div class="card-body">
                <table id="myTable" class="table table-striped table-bordered" style="width:100%">
                    <thead>
                        <tr>
                            <th>No</th>
                            <th>Nama</th>
                            <th>Frek</th>
                            <th>Cicilan</th>
                            <th>Aksi</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php
                            $no =1;
                            foreach ($table as $k) {
                                echo '
                                <tr>
                                    <td>'.$no++.'</td>
                                    <td>'.$k->nama.'</td>
                                    <td>'.frek($k->frek).'</td>
                                    <td>'.cicilan($k->cicilan).'</td>
                                    <td align="center">
                                        <a class="btn btn-sm btn-warning" onclick="edit(`'.dc($k->id_pembayaran).'`)">Edit</a>
                                        <a class="btn btn-sm btn-danger" onclick="hapus(`pembayaran/delete/'.dc($k->id_pembayaran).'`)">Hapus</a>
                                        <a class="btn btn-sm btn-primary" href="'.base_url('tagihan/list/').dc($k->id_pembayaran).'">Tagihan</a>
                                        <a class="btn btn-sm btn-success" onclick="auth(`'.dc($k->id_pembayaran).'`)">Auth Mhs</a>
                                    </td>
                                </tr>
                                ';
                            }
                        ?>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

<div class="modal fade" id="add" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg" role="document">
        <div class="modal-content">
            <form method="post" id="form_<?=$title?>">
                <div class="modal-header">
                    <h5 class="modal-title">Form <?=$title?></h5>
                    <button class="btn-close" type="button" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <input type="text" name="data_id" class="d-none" id="data_id">
                    <?php
                        echo csrf_field();
                        $c['options'] = ['Ya', 'Tidak'];
                        $c['value'] = [1,2];
                        $f['options'] = ['Perbulan', 'Pertahun', 'Persemester', 'Perjenjang', '1x'];
                        $f['value'] = [1,2,3,4,5];

                        echo form_text('nama');
                        echo form_select('cicilan', $c);
                        echo form_select('frekuensi', $f);
                    ?>
                </div>
                <div class="modal-footer"><button class="btn btn-primary" type="submit">Save</button></div>
            </form>
        </div>
    </div>
</div>
<div class="modal fade" id="auth" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg" role="document">
        <div class="modal-content">
            <form method="post" id="form_<?=$title?>" method="post" action="<?=base_url('pembayaran/authMhs')?>">
                <div class="modal-header">
                    <h5 class="modal-title">Form Auth Pembayaran</h5>
                    <button class="btn-close" type="button" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <input type="text" name="id_auth_pembayaran" class="d-none" id="id_auth_pembayaran">
                    <?php
                        echo csrf_field();
                        for($i=1; $i < 10; $i++){
                    ?>

                    <div class="form-group row" id="tag_nama<?=$i?>">
                        <label for="nama" class="col-sm-3 col-form-label"><?=jur($i)?></label>
                        <div class="col-sm-8">
                          <input type="text" name="jumlah[]" class="form-control" id="auth<?=$i?>">
                          <input type="text" name="jurusan[]" class="d-none" value="<?=$i?>">

                        </div>
                    </div>
                    <?php
                        }
                    ?>
                </div>
                <div class="modal-footer"><button class="btn btn-primary" type="submit">Save</button></div>
            </form>
        </div>
    </div>
</div>

<script type="text/javascript">
    $(document).ready(function(){
        var table = $('#myTable').DataTable({
            dom: 'Bfrtip', 
            buttons: [
                
                // Tombol Excel
                {
                    extend: 'excelHtml5',
                    exportOptions: {
                        columns: ':not(:last-child)' // Pengecualian kolom terakhir
                    },
                    className: 'btn btn-primary btn-sm',
                },
                
                // Tombol PDF
                {
                    extend: 'pdfHtml5',
                    exportOptions: {
                        columns: ':not(:last-child)' // Pengecualian kolom terakhir
                    },
                    className: 'btn btn-primary btn-sm',
                },
                // Tombol Print (Sering juga ditambahkan pengecualian untuk kolom yang tidak terlihat)
                {
                    extend: 'print',
                    exportOptions: {
                        columns: ':visible:not(:last-child)' // Pengecualian kolom terakhir & kolom tersembunyi
                    },
                    className: 'btn btn-primary btn-sm',
                }
            ]
        });

        table.buttons().container().appendTo('#export');

        $('.show_pass').on('click', function() {
            var currentType = $('.password_form').attr('type'); 

            if (currentType === 'text') {
                $('.password_form').attr('type', 'password');
            } else {
                $('.password_form').attr('type', 'text');
            }
        });
    })

    function edit(id){
        $('#data_id').val(id);
        if(id != 0){
            $.ajax({
                url : '<?=base_url()?>/pembayaran/get/' + id,
                dataType : 'JSON',
                success : function(d){
                    $('#form_<?=$title?>').attr('action', '<?=base_url('pembayaran/edit')?>');
                    $('#form_nama').val(d.nama);
                    $('#form_cicilan').val(d.cicilan);
                    $('#form_frekuensi').val(d.frek);                    
                }
            })
        }else{
            $('#form_<?=$title?>').attr('action', '<?=base_url('pembayaran/add')?>');
        }

        $('#add').modal('show');
    }

    function auth(id){
        $('#id_auth_pembayaran').val(id);
        for(let i =1; i<10; i++){
            $('#auth'+ i ).val(0);
        }
        $.ajax({
            url : '<?=base_url()?>/pembayaran/getAuthMhs/' + id,
            dataType : 'JSON',
            success : function(d){

                $.each(d, function(index, item) {
                    console.log(item);
                    // 3. Tambahkan baris ke dalam tbody
                    $('#auth'+item.jurusan).val(item.jumlah);
                })                    
            }
        })
        $('#auth').modal('show');
    }

</script>