Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //include "inc/config.php";
- include "../../lib/nusoap/nusoap.php";
- include "../../inc/config.php";
- include "../../lib/prosesupdate/ProgressUpdater.php";
- $options = array(
- 'filename' => $_GET['jurusan'].'_progress.json',
- 'autoCalc' => true,
- 'totalStages' => 1
- );
- $pu = new Manticorp\ProgressUpdater($options);
- $check = $db->fetch_custom("select *,nilai_akm.id as id_akm from nilai_akm inner join jurusan on nilai_akm.kode_jurusan=jurusan.kode_jurusan where jurusan.kode_jurusan='".$_GET['jurusan']."' and nilai_akm.semester='".$_GET['sem']."' and valid=0 or valid=2");
- $jumlah_error = $check->rowCount();
- if ($jumlah_error>0) {
- $msg = "Pastikan Anda Sudah Melakukan validasi AKM dan semua data valid";
- $pu->totallyComplete($msg);
- exit();
- }
- $config = $db->fetch_single_row('config_user','id',1);
- if ($config->live=='Y') {
- $url = 'http://'.$config->url.':'.$config->port.'/ws/live.php?wsdl'; // gunakan live
- } else {
- $url = 'http://'.$config->url.':'.$config->port.'/ws/sandbox.php?wsdl'; // gunakan sandbox
- }
- //untuk coba-coba
- // $url = 'http://pddikti.uinsgd.ac.id:8082/ws/live.php?wsdl'; // gunakan live bila
- $client = new nusoap_client($url, true);
- $proxy = $client->getProxy();
- # MENDAPATKAN TOKEN
- $username = $config->username;
- $password = $config->password;
- $result = $proxy->GetToken($username, $password);
- $token = $result;
- //$token = 'acdbbc82c3b29f99e9096dab1d5eafb4';
- $id_sms = '';
- $id_mk = '';
- $sks_mk = '';
- $sks_tm = '';
- $sks_prak = '';
- $sks_prak_lap = '';
- $sks_sim = '';
- $temp_data = array();
- $sukses_count = 0;
- $sukses_msg = '';
- $error_count = 0;
- $error_msg = array();
- $data_id = array();
- $error_id = array();
- //get id npsn
- $filter_sp = "npsn='".$config->id_sp."'";
- $get_id_sp = $proxy->GetRecord($token,'satuan_pendidikan',$filter_sp);
- $id_sp = $get_id_sp['result']['id_sp'];
- $arr_data = $db->fetch_custom("select *,nilai_akm.id as id_akm from nilai_akm inner join jurusan on nilai_akm.kode_jurusan=jurusan.kode_jurusan where jurusan.kode_jurusan='".$_GET['jurusan']."' and nilai_akm.semester='".$_GET['sem']."' and status_error!=1");
- $stageOptions = array(
- 'name' => 'This AJAX process takes a long time',
- 'message' => 'But this will keep the user updated on it\'s actual progress!',
- 'totalItems' => $arr_data->rowCount(),
- );
- $pu->nextStage($stageOptions);
- $i=1;
- $insert_data_akm = array();
- foreach ($arr_data as $value) {
- $nim = $value->nim;
- $filter_npm = "nipd like '%".$nim."%'";
- $temp_npm = $proxy->GetRecord($token,'mahasiswa_pt',$filter_npm);
- //var_dump($temp_npm);
- if ($temp_npm['result']) {
- $id_reg_pd = $temp_npm['result']['id_reg_pd'];
- $stat_reg = TRUE;
- }
- if ($_GET['method']=='up') {
- $filter_akm = "id_reg_pd='".$id_reg_pd."' and id_smt='".$value->semester."'";
- $temp_akm = $proxy->GetRecord($token,'kuliah_mahasiswa',$filter_akm);
- $array_key = array('id_smt' => $value->semester, 'id_reg_pd' => $temp_akm['result']['id_reg_pd']);
- $array_data = array('id_smt' => $value->semester,
- 'id_reg_pd' => $id_reg_pd,
- 'ips' => $value->ips,
- 'sks_smt' => $value->sks_smt,
- 'ipk' => $value->ipk,
- 'sks_total' => $value->sks_total,
- 'id_stat_mhs' => $value->status_kuliah
- );
- $final_up = array('key' => $array_key, 'data' => $array_data
- );
- $up_result = $proxy->UpdateRecord($token, 'kuliah_mahasiswa', json_encode($final_up));
- if ($up_result['result']['error_desc']==NULL) {
- ++$sukses_count;
- $db->update('nilai_akm',array('status_error'=>1,'keterangan'=>''),'id',$value->id_akm);
- } else {
- ++$error_count;
- $error_msg[] = "<h4>Error $nim</h4>".$up_result['result']['error_desc'];
- $db->update('nilai_akm',array('status_error' => 2, 'keterangan'=>$up_result['result']['error_desc']),'id',$value->id_akm);
- }
- $i++;
- $pu->incrementStageItems(1, true);
- } else {
- $filter_nim = "id_reg_pd='".$id_reg_pd."' and id_smt='".$value->semester."' and soft_delete='1'";
- $check_delete = $proxy->GetRecord($token,'kuliah_mahasiswa',$filter_nim);
- if ($check_delete['result']) {
- $restore_data = array('id_reg_pd' => $check_delete['result']['id_reg_pd']);
- $restore = $proxy->RestoreRecord($token,'kuliah_mahasiswa',json_encode($restore_data));
- $array_key = array('id_smt' => $value->semester, 'id_reg_pd' => $check_delete['result']['id_reg_pd']);
- $array_data = array('id_smt' => $value->semester,
- 'id_reg_pd' => $id_reg_pd,
- 'ips' => $value->ips,
- 'sks_smt' => $value->sks_smt,
- 'ipk' => $value->ipk,
- 'sks_total' => $value->sks_total,
- 'id_stat_mhs' => $value->status_kuliah
- );
- $final_up = array('key' => $array_key, 'data' => $array_data
- );
- $temp_result = $proxy->UpdateRecord($token, 'kuliah_mahasiswa', json_encode($final_up));
- } else {
- $temp_data = array('id_smt' => $value->semester,
- 'id_reg_pd' => $id_reg_pd,
- 'ips' => $value->ips,
- 'sks_smt' => $value->sks_smt,
- 'ipk' => $value->ipk,
- 'sks_total' => $value->sks_total,
- 'id_stat_mhs' => $value->status_kuliah
- );
- $temp_result = $proxy->InsertRecord($token, 'kuliah_mahasiswa', json_encode($temp_data));
- }
- if ($temp_result['result']['error_desc']==NULL) {
- ++$sukses_count;
- $db->update('nilai_akm',array('status_error'=>1,'keterangan'=>''),'id',$value->id_akm);
- } else {
- ++$error_count;
- $error_msg[] = "<h4>Error $nim</h4>".$temp_result['result']['error_desc'];
- $db->update('nilai_akm',array('status_error' => 2, 'keterangan'=>$temp_result['result']['error_desc']),'id',$value->id_akm);
- }
- $i++;
- $pu->incrementStageItems(1, true);
- }
- }
- $msg = '';
- if ((!$sukses_count==0) || (!$error_count==0)) {
- $msg = "<div class=\"alert alert-warning \" role=\"alert\">
- <font color=\"#3c763d\">".$sukses_count." data Akm baru berhasil di Upload</font><br />
- <font color=\"#ce4844\" >".$error_count." data tidak bisa diupload </font>";
- if (!$error_count==0) {
- $msg .= "<a data-toggle=\"collapse\" href=\"#collapseExample\" aria-expanded=\"false\" aria-controls=\"collapseExample\">Detail error</a>";
- }
- //echo "<br />Total: ".$i." baris data";
- $msg .= "<div class=\"collapse\" id=\"collapseExample\">";
- $i=1;
- foreach ($error_msg as $pesan) {
- $msg .= "<div class=\"bs-callout bs-callout-danger\">".$i.". ".$pesan."</div><br />";
- $i++;
- }
- $msg .= "</div>
- </div>";
- }
- $pu->totallyComplete($msg);
- //$pu->totallyComplete();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement