Untitled

public function import_process(){
		$reader 			 = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
		$spreadsheet    = $reader->load('upload/excel/'.$this->filename.'.xlsx');
		$sheet 			 = $spreadsheet->getActiveSheet()->toArray();
		$data['sheet']  = $sheet; 
		$numrow 			 = 1;
		foreach($sheet as $row){
		  	if($numrow > 1){
				$email    		= $row['0'];
				$u_title    	= $row['1'];
				$fullname  		= $row['2'];
				$f_alamat 		= $row['3'];
				$u_company 		= $row['4'];
				$u_country  	= $row['5'];
				$u_mobileno 	= $row['6'];
				$u_position 	= $row['7'];
				$u_sourceinfo 	= $row['8'];
				$type_akun 	   = strtoupper($row['9']);
				$category 	   = $row['10'];
				if($type_akun == '') {
					$type_akun = 'REG';
				}
				$u_title_case = strtolower($u_title);
				if($u_title_case == 'bapak') {
					$gender = 'Laki-laki';
				} elseif($u_title_case == 'ibu') {
					$gender = 'Perempuan';
				} elseif($u_title_case == 'mr.' || $u_title_case == 'mr') {
					$gender = 'Laki-Laki';
				} elseif($u_title_case == 'mrs.' || $u_title_case == 'mrs') {
					$gender = 'Perempuan';
				} elseif($u_title_case == 'ms.' || $u_title_case == 'ms') {
					$gender = 'Perempuan';
				} else {
					$gender = '';
				}
				if($email != '') {
					$is_exist = $this->M_Peserta->getPesertaByEmail($email);
					if(isset($is_exist->email)) {
						if($is_exist->uniqcode == '') {
							$uniqcode 		= $this->M_Peserta->getIDPeserta($type_akun);
						} else {
							$uniqcode 		= $is_exist->uniqcode;
						}
						$user_id 		  = $is_exist->user_id;
						$dataUpdate 	  = array(
							'uniqcode'		=> $uniqcode,
							'gender'      	=> $gender,
							'title'     	=> $u_title,
							'nama'        	=> $fullname,
							'position'    	=> $u_position,
							'departemen'	=> '',
							'company' 		=> $u_company, 
							'address'   	=> $f_alamat,
							'country'     	=> $u_country,
							'mobile'    	=> $u_mobileno,
							'email'       	=> $email,
							'sourceinfo'  	=> $u_sourceinfo,
							'password'   	=> $email,
							'type_akun'   	=> $type_akun,
							'category'   	=> $category,
						);
						$uid = $this->M_Peserta->updatePeserta($dataUpdate, $user_id);
					} else {
						$uniqcode 		= $this->M_Peserta->getIDPeserta($type_akun);
						$dataInsert = array(    
							'uniqcode'	   => $uniqcode,
							'gender'      	=> $gender,
							'title'     	=> $u_title,
							'nama'        	=> $fullname,
							'position'    	=> $u_position,
							'departemen'	=> '',
							'company' 		=> $u_company, 
							'address'   	=> $f_alamat,
							'country'     	=> $u_country,
							'mobile'    	=> $u_mobileno,
							'email'       	=> $email,
							'sourceinfo'  	=> $u_sourceinfo,
							'password'   	=> $email,
							'type_akun'   	=> $type_akun,
							'category'   	=> $category,
						);
						$uid = $this->M_Peserta->insert_peserta($dataInsert);
					}
				} else {
					$uniqcode 		= $this->M_Peserta->getIDPeserta($type_akun);
					$dataInsert = array(        
						'gender'      	=> $gender,
						'title'     	=> $u_title,
						'nama'        	=> $fullname,
						'position'    	=> $u_position,
						'departemen'	=> '',
						'company' 		=> $u_company, 
						'address'   	=> $f_alamat,
						'country'     	=> $u_country,
						'mobile'    	=> $u_mobileno,
						'email'       	=> $email,
						'sourceinfo'  	=> $u_sourceinfo,
						'password'   	=> $email,
						'type_akun'   	=> $type_akun,
						'category'   	=> $category,
					);
					$uid = $this->M_Peserta->insert_peserta($dataInsert);
				}
		  	}
         $numrow++;
		}	
		redirect ("peserta_event");
   }