import

<?php
include 'config.php';
include 'excel_reader.php';
class deleteDuplicate extends Config{
  function __construct(){
    $options = getopt(null, ["fileName:"]);
    $namaFile =$options['fileName'];
    $nameFileExcel = $namaFile;
    $excel = new PhpExcelReader;
    $excel->read("$namaFile");
    $sheet = $excel->sheets[0];
       $x = 2;
       $jumlahData = $sheet['numRows'] - 1;
       while($x <= $sheet['numRows']) {
         $bk = $sheet['cells'][$x][1];
         $ck = $sheet['cells'][$x][2];
         $dk = $sheet['cells'][$x][3];
         $p = $sheet['cells'][$x][4];
         $q = $sheet['cells'][$x][5];
         $kodeUrusan = $bk.".".$ck.".".$dk.".".$p.".".$q;
         $nama = $this->stringDetector($sheet['cells'][$x][6]);
         if(!empty($p)&& $p != "00" && $p != "0" && $p != ""){
           $dataProgramKegiatan = array(
             "bk"=> $bk,
             "ck"=> $ck,
             "dk"=> $dk,
             "p"=> $p,
             "q"=> $q,
             "nama"=> $nama,
           );
           $query = $this->sqlInsert("ref_program",$dataProgramKegiatan);
           $this->sqlQuery($query);
           echo $query.";\n";
         }else{
           $dataUrusan = array(
             "bk"=> $bk,
             "ck"=> $ck,
             "dk"=> $dk,
             "nm_urusan"=> $nama,
           );
           // $query = $this->sqlInsert("ref_urusan",$dataUrusan);
           // $this->sqlQuery($query);
           // echo $query.";\n";
         }


         // }
        $x++;
      }
  }

  function stringDetector($string){
      $string = str_replace("`","",$string);
      $string = str_replace("'","",$string);
      $string = str_replace("?","",$string);
      $string = str_replace(".","",$string);
      return $string;
  }
  function kasihNol($angka){
    if(empty($angka))$angka="00";
    return $angka;
  }
  function generateNol($angka){
    if(empty($angka))$angka="0";
    return $angka;
 }

}

$wakwaw = new deleteDuplicate();




 ?>