| Server IP : 101.255.104.117 / Your IP : 101.255.104.117 Web Server : Apache/2.4.34 (Win32) OpenSSL/1.0.2o PHP/5.6.38 System : Windows NT DESKTOP-5B8S0D4 6.2 build 9200 (Windows 8 Professional Edition) i586 User : user ( 0) PHP Version : 5.6.38 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : D:/xampp182/htdocs/wablast/ |
Upload File : |
<?php
$id = "";
$ip = "";
$userf = "";
$pwdf = "";
$buton = "Simpan";
?>
<h1 class="h3 mb-4 text-gray-800">List Mahasiswa Maret 2023</h1>
<div class="container-fluid">
<!-- Page Heading -->
<?php
if(isset($_GET["sync2"])) {
$sql = "update imp_mhs set del = 1 where id = ".$_GET["sync2"];
$result = mysqli_query($conn, $sql);
}
if(isset($_GET["sync"])) {
include 'feeder_ws.php';
token();
$sql = "SELECT * FROM imp_mhs where id = ".$_GET["sync"]." order by id desc";
$result = mysqli_query($conn, $sql);
if(mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
$npm = $row['npm'];
$f1 = $row['nm'];
$f2 = "P";
$f3 = $row['tmplahir'];
$f4 = $row['tgl'];
if(strtoupper($row['Agama']) == "ISLAM") $f5 = 1;
if(strtoupper($row['Agama']) == "KRISTEN") $f5 = 2;
if(strtoupper($row['Agama']) == "KATOLIK") $f5 = 3;
if(strtoupper($row['Agama']) == "HINDU") $f5 = 4;
if(strtoupper($row['Agama']) == "BUDHA") $f5 = 5;
// $f5 = $row['Agama'];//Agama
$f6 = $row['ktp'];
$f7 = substr($row['npm'],0,10);
$f8 = "ID";
$f9 = $row['jln'];
$f10 = $row['jln'];
$f11 = $row['rt'];
$f12 = $row['rw'];
$f13 = $row['kel'];
$f14 = $row['kdpos'];
$f15 = "016301";
$f16 = "10";
$f17 = "13"; //
$f18 = "0";
$f19 = $row['hp'];
$f20 = $row['email'];
$f21 = "0";
$f22 = "0";
$f23 = $row['nikayah'];
$f24 = $row['ayah'];
$f25 = "2023-03-10";
$f26 = "0";
$f27 = "0";
$f28 = "0";
$f29 = $row['nikibu'];
$f30 = $row['ibu'];
$f31 = "2023-03-10";
$f32 = "0";
$f33 = "0";
$f34 = "0";
$f35 = "0";
$f36 = "";
$f37 = "2023-03-10";
$f38 = "0";
$f39 = "0";
$f40 = "0";
$f41 = "0";
$f42 = "0";
$f43 = "0";
}
}
$feeder_token = $_SESSION['feeder_token'];
$sync['act']="InsertBiodataMahasiswa";
$sync['token']=$feeder_token;
$sync['record']=[
"nama_mahasiswa"=>$f1,
"jenis_kelamin"=>$f2,
"tempat_lahir"=>$f3,
"tanggal_lahir"=>$f4,
"id_agama"=>$f5,
"nik"=>$f6,
"nisn"=>$f7,
"kewarganegaraan"=>$f8,
"jalan"=>$f9,
"dusun"=>$f10,
"rt"=>$f11,
"rw"=>$f12,
"kelurahan"=>$f13,
"kode_pos"=>$f14,
"id_wilayah"=>$f15,
"id_jenis_tinggal"=>$f16,
"id_alat_transportasi"=>$f17,
"telepon"=>$f18,
"handphone"=>$f19,
"email"=>$f20,
"penerima_kps"=>$f21,
"nomor_kps"=>$f22,
"nik_ayah"=>$f23,
"nama_ayah"=>$f24,
"tanggal_lahir_ayah"=>$f25,
"id_pendidikan_ayah"=>$f26,
"id_pekerjaan_ayah"=>$f27,
"id_penghasilan_ayah"=>$f28,
"nik_ibu"=>$f29,
"nama_ibu_kandung"=>$f30,
"tanggal_lahir_ibu"=>$f31,
"id_pendidikan_ibu"=>$f32,
"id_pekerjaan_ibu"=>$f33,
"id_penghasilan_ibu"=>$f34,
"npwp"=>$f35,
"nama_wali"=>$f36,
"tanggal_lahir_wali"=>$f37,
"id_pendidikan_wali"=>$f38,
"id_pekerjaan_wali"=>$f39,
"id_penghasilan_wali"=>$f40,
"id_kebutuhan_khusus_mahasiswa"=>$f41,
"id_kebutuhan_khusus_ayah"=>$f42,
"id_kebutuhan_khusus_ibu"=>$f43
];
$json_array = runWs($sync);
$jsonn = json_decode($json_array,true);
echo "<div class='card-body'>".$json_array." | <a href='dashboard.php?mhs23'>refresh</a></div>";
foreach($jsonn['data'] as $row) {
$sql = "update imp_mhs set status = '".$json_array."', del = 1 where id = ".$_GET["sync"];
$result = mysqli_query($conn, $sql);
}
// echo "<script>window.alert('".$f1." sudah Insert ke Neo Feeder');</script>";
/*
// $ff1 = $idMhs_feeder;
$ff1 = "b1f02560-ccc1-4a50-880b-fc81bc3ff939";
$ff2 = $npm;
$ff3 = "2"; //2 pindahan;1 baru
$ff4 = "12"; //12 mandiri
$ff5 = "202201";
$ff6 = "2022-09-12";
$ff7 = "8415170d-2153-4bb7-98b5-a16f7765c831";
$ff8 = "51824a53-1fb0-4d16-a534-23999aca90e0"; //kebidanan
// $ff8 = "e8586ff4-3870-4f71-abe3-ccbc54e66818"; //profesi
$ff9 = "null";
$ff10 = "103";
$ff11 = $ff7; //stikes
$ff12 = "STIKES BHAKTI PERTIWI INDONESIA"; //stikes
$ff13 = "639f998e-1ad1-4841-b307-9e58c76f08a9"; //d3 kebidanan
$ff14 = "D3 KEBIDANAN";
$ff15 = "1";
$ff16 = "16000000";
$sync['act']="InsertRiwayatPendidikanMahasiswa";
$sync['token']=$feeder_token;
$sync['record']=[
"id_mahasiswa"=>$ff1,
"nim"=>$ff2,
"id_jenis_daftar"=>$ff3,
"id_jalur_daftar"=>$ff4,
"id_periode_masuk"=>$ff5,
"tanggal_daftar"=>$ff6,
"id_perguruan_tinggi"=>$ff7,
"id_prodi"=>$ff8,
"id_bidang_minat"=>$ff9,
"sks_diakui"=>$ff10,
"id_perguruan_tinggi_asal"=>$ff11,
"nama_perguruan_tinggi_asal"=>$ff12,
"id_prodi_asal"=>$ff13,
"nama_prodi_asal"=>$ff14,
"id_pembiayaan"=>$ff15,
"biaya_masuk"=>$ff16
];
$json_array = runWs($sync);
$jsonn = json_decode($json_array,true);
echo $json_array."<br>";
*/
}
if(isset($_POST["SYNCx"])) {
// $sql = "delete from f_mhs";
// $result = mysqli_query($conn, $sql);
include 'feeder_ws.php';
token();
$feeder_token = $_SESSION['feeder_token'];
$json_array = runWs($sync);
$jsonn = json_decode($json_array,true);
}
?>
<!-- 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>NPM</th>
<th>Nama</th>
<th>Tempat Lahir</th>
<th>Tanggal Lahir</th>
<th>Nama Ibu</th>
<!--th>Sync</th>
<th>Upd</th-->
</tr>
</thead>
<tfoot>
<tr>
<th>NPM</th>
<th>Nama</th>
<th>Tempat Lahir</th>
<th>Tanggal Lahir</th>
<th>Nama Ibu</th>
<!--th>Sync</th>
<th>Upd</th-->
</tr>
</tfoot>
<tbody>
<?php
$sql = "SELECT * FROM imp_mhs where npm <> '' and del = 0 order by id desc";
$result = mysqli_query($conn, $sql);
if(mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
?>
<tr>
<td><?php echo $row['npm'];?></td>
<td><a href="dashboard.php?mhs23&idm=<?php echo $row['id'];?>"><?php echo $row['nm'];?></a></td>
<td><?php echo $row['tmplahir'];?></td>
<td><?php echo $row['tgl'];?></td>
<td><?php echo $row['nmibu'];?></td>
<!--td>
<a class="btn btn-primary btn-info" href="dashboard.php?mhs23&sync=<?php echo $row['ID'];?>"><i class="fas fa-sign-in-alt"></i></a>
</td>
<td>
<a class="btn btn-primary btn-info" href="dashboard.php?mhs23&sync2=<?php echo $row['ID'];?>"><i class="fas fa-sign-out-alt"></i></a>
</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?mhs" 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-->