<?php
$id = "";
$ip = "";
$userf = "";
$pwdf = "";
$buton = "Simpan";

?>
<h1 class="h3 mb-4 text-gray-800">Data Master Pembiayaan</h1>

<div class="container-fluid">

<!-- Page Heading -->
<?php
if(isset($_POST["SYNC"])) {
	ini_set('memory_limit', '512M'); // Contoh: naikkan ke 512MB
	set_time_limit(600); // Contoh: naikkan batas waktu eksekusi menjadi 300 detik

    // $sql = "delete from f_pembiayaan";
    // $result = mysqli_query($conn, $sql);

	include 'feeder_ws.php';

	token();

	$feeder_token = $_SESSION['feeder_token'];

	$sync['act']="ExportDataNilaiTransfer";
	$sync['token']=$feeder_token;
	$sync['key']=[
		"filter"=>"",
		"order"=>"",
		"limit"=>"100",
		"offset"=>"0"
	];

	$json_array = runWs($sync);
	echo $json_array;
    $jsonn = json_decode($json_array,true);

    // foreach($jsonn['data'] as $row) {
        // $tbField[0] = "Pembiayaan";
        // $tbField[1] = "nama_pembiayaan";

        // $tbIsi[0] = "'".addslashes($row['id_pembiayaan'])."'";
        // $tbIsi[1] = "'".$row['nama_pembiayaan']."'";

        // $nmField = compile_array($tbField);
        // $isiField = compile_array($tbIsi);

        // $sql = "insert into f_pembiayaan (".$nmField.") values (".$isiField.")";

        // if (mysqli_query($conn, $sql)) {
        // } else {
            // echo "Error: " . $sql . "<br>" . mysqli_error($conn);
        // }
    // }    
}

?>

                    <!-- DataTales Example -->
                    <div class="card shadow mb-4">
                        <div class="card-header py-3">
                            <h6 class="m-0 font-weight-bold text-primary">DataTables</h6>
                        </div>
                        <div class="card-body">
                            <div class="table-responsive">
                                <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                                    <thead>
                                        <tr>
                                            <th>ID</th>
                                            <th>Pembiayaan</th>
                                        </tr>
                                    </thead>
                                    <tfoot>
                                        <tr>
                                            <th>ID</th>
                                            <th>Pembiayaan</th>
                                        </tr>
                                    </tfoot>
                                    <tbody>
                                    <?php
                                    $sql = "SELECT * FROM f_pembiayaan order by Pembiayaan desc";
                                    $result = mysqli_query($conn, $sql);

                                    if(mysqli_num_rows($result) > 0) {
                                        while($row = mysqli_fetch_assoc($result)) {
                                        ?>
                                        <tr>
                                            <td><?php echo $row['Pembiayaan'];?></td>
                                            <td><?php echo $row['nama_pembiayaan'];?></td>
                                        </tr>
                                        <?php
                                        }
                                    }
                                        ?>
                                    </tbody>
                                </table>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="row">
                    <div class="col-lg-12">
                        <div class="p-5">
                            <form class="user" action="dashboard.php?TestNilai" accept-charset="utf-8" method="post">
                                <div class="form-group row">
                                    <div class="col-sm-3 mb-3 mb-sm-0">
                                        <button name="SYNC" type="submit" class="btn btn-primary btn-user btn-block">Sinkronkan</button>
                                    </div>
                                    <div class="col-sm-3">
                                        <button name="Cancel" type="submit" class="btn btn-primary btn-user btn-block">Cancel</button>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>