Welcome Guest, Not a member yet? Register   Sign In
Cara membuat nomor surat berulang setiap tahun secara otomatis dengan Codeigniter
#1

(This post was last modified: 09-03-2020, 07:09 AM by jreklund.)

Mohon pencerahannya suhu bagaimana cara membuat nomor surat berulang setiap tahun di codeigniter. Terima kasih sebelumnya.

Code:
function cetak_surat(){
        $kode = $this->input->post('nomor');
        $validasi_Data = $this->db->query("SELECT * FROM keluar ORDER BY id_skeluar DESC");
        $no_surat = $this->db->query("SELECT IFNULL(MAX(no_surat)+1,1) AS no_surat FROM keluar WHERE DATE_FORMAT(NOW(),'%Y%')");
        if ($validasi_Data->num_rows() > 0) {
            $datasurat = $validasi_Data->row();
            $nomer = substr($datasurat->no_surat, 0, 3);
            $addlist = $nomer+1;
            $no_surat = $addlist."/".$kode."";
        }else{
            $no_surat = "1/".$kode."";
         }
Reply


Messages In This Thread
Cara membuat nomor surat berulang setiap tahun secara otomatis dengan Codeigniter - by radenadhiyaksa - 09-03-2020, 06:41 AM



Theme © iAndrew 2016 - Forum software by © MyBB