Import mahasiswa dari file excel

<?php include "./bootstrap.php"; use \UniversitySDK\Entities\SPMBStudent; class ImportStudentFromExcel{ function localToDbDate($var){ $date = str_replace('/', '-', $var); return date('Y-m-d', strtotime($date)); } function logStatus($t){ $f = fopen(__DIR__.'/InsertStudentFromExcel-live.log','a+'); if($f){ $now = new \DateTime(); $now->setTimezone(new \DateTimeZone('Asia/Jakarta')); $time = $now->format('Y-m-d H:i:s'); $text = $time.': '.$t."\n"; echo $text; fwrite($f,$text); fclose($f); } } private function findNationality($nationalityText){ $nationalityText = strtolower(trim($nationalityText)); foreach($this->nationalities as $rl){ if(strtolower($rl->name) == $nationalityText){ return $rl; } } return NULL; } function findReligion($religionText){ $religionText = strtolower($religionText); foreach($this->religions as $rl){ if(strtolower($rl->name) == $religionText){ return $rl; } } return NULL; } public function getDataSources(){ return [ [ 'file'=>'/1. Udah registrasi dari 295- S2 MPI-edit1.csv', 'progID'=>1039 ], [ 'file'=>'/2. Udah registrasi dari 295- S2 HES-edit1.csv', 'progID'=>1036 ], [ 'file'=>'/3. Udah registrasi dari 295- S2 IAT-edit1.csv', 'progID'=>1038 ], [ 'file'=>'/4. Udah registrasi dari 295- S2 PBA-edit1.csv', 'progID'=>1041 ], [ 'file'=>'/5. Udah registrasi dari 295- S2 PGMI-edit1.csv', 'progID'=>1042 ], [ 'file'=>'/6. Udah registrasi dari 295- S2 PAI-edit1.csv', 'progID'=>1040 ], [ 'file'=>'/7. Udah registrasi dari 295- S2 AFI-edit1.csv', 'progID'=>1034 ], [ 'file'=>'/8. Udah registrasi dari 295- S2 ES-edit1.csv', 'progID'=>1035 ], [ 'file'=>'/9. Udah registrasi dari 295- S2 HKI-edit1.csv', 'progID'=>1037 ], [ 'file'=>'/10. Udah registrasi dari 295- S2 TBI-edit1.csv', 'progID'=>1043 ], [ 'file'=>'/home/aldo/Downloads/Yang registrasi untuk siakad/S3 edit 1/1. Yang registrasi dari 295- S3 MPI Edit1.csv', 'progID'=>1044 ], [ 'file'=>'/home/aldo/Downloads/Yang registrasi untuk siakad/S3 edit 1/2. Yang registrasi dari 295- S3 SI Edit1.csv', 'progID'=>1045 ] ]; } public function run(){ $this->admin = new \UniversitySDK\Admin; //$this->admin->setHost('http://university'); $ret = $this->admin->login(1001,'[email protected]', 'J9iFt>L,(n7d@4d'); if(!$ret){ echo 'failed to login'; return FALSE; } $this->religions = $this->admin->getAllReligions(); //get all nationalities $this->nationalities = $this->admin->getAllNationalities(); $srcs = $this->getDataSources(); foreach($srcs as $src){ $programID = $src['progID'];// $csvPath = $src['file']; $row = 1; if (($handle = fopen($csvPath, "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { if($row==1){ $row++; continue; } $std = new SPMBStudent(); $std->UniversityID = 1001; $std->unitid = $programID; $std->ProgramID = $programID; //$std->fakultas = 1001; //$std->kode_prodi_sia = ; $std->no_ident = trim($data[5]); $std->nim = trim($data[3]); $std->nama = trim($data[2]); $std->email = trim($data[1]); if(empty($std->email)){ $std->email = $std->nim .'@universitas.ac.id'; } $std->tmpt_lahir = strtoupper(trim($data[6])); $std->tgl_lahir = trim($this->localToDbDate($data[7])); $sex = 'P'; if(trim($data[4])=='Laki - laki'){ $sex = 'L'; } $std->sex = $sex; $std->blood = ''; $now = new \DateTime(); $now->setTimezone(new \DateTimeZone('Asia/Jakarta')); $time = $now->format('Y-m-d H:i:s'); $std->reg_date = $time; //all using area id //Kelurahan/Desa Tempat Tinggal 10 $std->dsn = trim($data[10]); //Kecamatan Tempat Tinggal 11 $kec = trim($data[11]); $kec = str_replace(['kec'],'',strtolower($kec)); if($kec=='campurdarat'){ $kec = 'campur darat'; } if($kec=='pucanglaban'){ $kec = 'pucang laban'; } $subdistrict = $this->admin->findSubDistrict($kec); if($subdistrict==NULL){ $this->logStatus('Can not find kec:'.$kec); }else{ $std->kec = $subdistrict->ID; } //Kabupaten Tempat Tinggal 12 $kab = str_replace(['kabupaten','kota'],'',strtolower(trim($data[12]))); //exceptions if($kab=='kediri'){ $kab = 'Kota Kediri'; } $city = $this->admin->findCity($kab); if($city==NULL){ $this->logStatus('Can not find kab:'.$kab); }else{ $std->kab = $city->ID; } //Provinsi Tempat Tinggal 13 $prop = trim($data[13]); if($prop=='JAWATIMUR'){ $prop = 'JAWA TIMUR'; } $prov = $this->admin->findProvince($prop); if($prov==NULL){ $this->logStatus('Can not find prop:'.$prop); }else{ $std->prov = $prov->ID; } $std->kpos = '-'; $std->no_hp = '-'; $neg = trim($data[9]); $neg = str_replace('WNI','Indonesia',$neg); $nationality = $this->findNationality($neg); if($nationality==NULL){ $this->logStatus('negara tidak ditemukan: '.$neg); $std->negara = 'ID'; }else{ //var_dump($nationality); $std->negara = $nationality->code; } $ag = trim($data[8]); $rel = $this->findReligion($ag); if($rel==NULL){ $this->logStatus('agama tidak ditemukan: '.$ag); $std->id_agama = 1; }else{ //var_dump($rel) $std->id_agama = $rel->ID; } $std->ayah = trim($data[15]); $std->status = 1; $std->tahun = 2019; $std->jalur = 5;//spmb mandiri $std->ibu = trim($data[14]); $std->id_pendaftaran = ''; $std->alamat = ''; $std->nik_ayah = ''; $std->nik_ibu = ''; $std->tgl_ayah = ''; $std->tgl_ibu = ''; $std->pekerjaan = ''; $std->alamatortu = ''; $std->kotaortu = '';//code from feeder $std->propinsiortu = ''; $std->kodeposortu = ''; $std->wali = ''; $std->alamatwali = ''; $std->alamatwali = ''; $std->hp_ortu = ''; $std->pend_ibu = ''; $std->pend_bpk = ''; $std->kerja_ibu = ''; $std->kerja_bpk = ''; $std->gaji_ibu =''; $std->gaji_bpk = ''; $std->gaji_wali = ''; $std->pend_wali = ''; $std->kerja_wali = ''; $this->logStatus('registering: '.$std->nim); $ret2 = $this->admin->registerSPMBStudent($std); if(isset($ret2->error)){ $this->logStatus('Error Student: '.$std->nim.' '.$std->nama.' '.$ret2->error->message); } if(isset($ret2->status)){ if($ret2->status==0){ $this->logStatus('Error Student: '.$std->nim.' '.$std->nama.' '.$ret2->message); }else{ $this->logStatus('done: '.$ret2->status); //return TRUE; } } $row++; } fclose($handle); } } } } $r = new ImportStudentFromExcel(); $r->run();