Replace enter pada BD2

 

contoh 

di satu row ada inputan 2 line kayak gini 

NASABAH JANJI BAYAR TANGGAL 28 FEBRUARI 2020 SEBESAR RP. 4,600.000-

PIC: AWAN SENJA FADLY ARIF 

cara bikin jadi 1 line gimana ya?

query nya :

REPLACE(COLUMNAME,CHAR(10),'')

Codeigniter Upload Txt to DataBase Oracle

 

Controller

if($this->input->post('uploadter')){

$filename=$_FILES['userfile']['tmp_name'];

$fileop  = fopen($filename, 'r');

$baris = 1;

while (!feof($fileop) ) {

$line_of_text = fgets($fileop);

$parts = explode('|', $line_of_text);

$datedate = date('Ymd', strtotime($this->input->post('uploadter')));

$nom = $this->m_sintak->no_max('TABLE');

$nodata=$nom->MAX+1;

$data = array(

'NODATA' => $nodata, 

'FLAGDETAIL' => isset($parts[0])?$parts[0]:'',

'KODEISIN' => isset($parts[1])?$parts[1]:'',

'NAMASSB' => isset($parts[2])?$parts[2]:'',

'KATEGORIPENGUKURAN' => isset($parts[3])?$parts[3]:'',

'NOMINALNILAIPAR' => isset($parts[4])?$parts[4]*1000000:'',

'TGLPEMBELIAN' => isset($parts[5])?$parts[5]:'',

'TGLINPUT' => date('m/d/Y'),

'KODEBANK' => $this->session->userdata("cdgrop")

);

if(($baris==1) && ($parts[4]!=$datedate)) { //baris kesatu

echo "<script>alert(' Gagal Upload, Tanggal Data tidak sesuai dengan Tanggal Header File '); location.href=('');</script>";

break; 

}

else if((isset($parts[1])) && ($parts[1]!="") && ($baris>1)) { //dimulai dari baris kedua

$ins = $this->m_sintak->add_data_ora('TABLE',$data);

$upd = $this->m_sintak->update_date_add('TABLE',$nodata,$this->input->post('uploadter')); 

}

$baris++;

}

fclose($fileop);

if($ins&&$upd)

{ echo "<script>alert(' Upload Data Berhasil '); location.href=('');</script>"; }

else

{ echo "<script>alert(' Upload Data Gagal '); location.href=('');</script>"; }

}

Model

   public function add_data_ora($tabel,$data){

       $this->data31->insert($tabel, $data);

       return TRUE;

    }

   public function update_date_add($tabel,$nodata,$tgldata){

      $data = "UPDATE $tabel set TGLDATA=TO_DATE('$tgldata','MM/DD/YYYY') WHERE NODATA='$nodata'";

  return $this->data31->query($data);

}

View

<?php

echo form_open_multipart('','class="form-horizontal" method="post" id="form2" name="myform" onsubmit="return disform()"');

?>

    <input type="hidden" value="<?php echo $this->input->post('tgldata'); ?>" name="tgldata"/>

    <input type="hidden" value="<?php echo $this->input->post('tgldata'); ?>" name="uploadter"/>

    <div class="form-body">

    <div class="form-group">

      <label class="control-label col-md-3">Tanggal Data</label>

      <div class="col-md-9">

      <input name="book_1" class="form-control" type="text" value="<?php echo $this->input->post('tgldata'); ?>" maxlength="10" readonly>

      </div>

    </div>

    <div class="form-group">

      <label class="control-label col-md-3">Pilih File</label>

      <div class="col-md-9">

  <input type="file" class="form-control pull-right" id="userfile" name="userfile" >

      </div>

    </div>

    </div>

    </div>

    <div class="modal-footer">

    <button type="submit" id="btnSave" name="import" class="btn btn-primary">Submit</button>

    <button type="button" class="btn btn-danger" data-dismiss="modal">Cancel</button>

    </div>

<?php

echo form_close();

?>

Oracle Menampilkan Tanggal Hari Kerja

select rownum as NOMOR,TANGGAL from (
SELECT TRUNC(SYSDATE) + 10 - LEVEL AS TANGGAL FROM DUAL
where to_char(TRUNC(SYSDATE) + 10 - LEVEL,'D') not in ('1','7')
CONNECT BY LEVEL <= 10 order by TRUNC(SYSDATE) + 10 - LEVEL asc
)

output

NOMOR    TANGGAL
1    12/20/2019
2    12/23/2019
3    12/24/2019
4    12/25/2019
5    12/26/2019
6    12/27/2019