Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-513.24.1.lve.2.el8.x86_64

PHP Version:

7.4.33

User:

skby1167

Directory:

/home/skby1167/.vscode-server/data/User/History/-4c0457ce

Free Space:

514.52 GB

🔧 Quick Actions

✏️ Editing: sF6p.php

<?php

namespace App\Controllers;

use App\Models\GaleriModel;
use App\Models\AlbumFotoModel;
use App\Models\GaleriVideoModel;
use App\Models\AlbumVideoModel;
use App\Models\SejarahModel;
use App\Models\OrgschemeModel;
use App\Models\jabatanModel;
use App\Models\pejabatModel;
use App\Models\SliderModel;
use App\Models\NewsModel;
use App\Models\secretariatModel;
use App\Models\VisiModel;
use App\Models\TusiModel;
use App\Models\MbModel;
use App\Models\MbTableModel;
use App\Models\MsModel;
use App\Models\MsTableModel;
use App\Models\MenuAgendaModel;
use App\Models\AgendaModel;
use App\Models\AlurModel;
use App\Models\AlurFileModel;
use App\Models\AnggotaModel;
use App\Models\SKAModel;
use App\Models\AgamaModel;
use App\Models\PendidikanModel;
use App\Models\TingkatModel;
use App\Models\BiayaModel;

class Manage extends BaseController
{
    protected $NewsModel;
    protected $SejarahModel;
    protected $OrgschemeModel;
    protected $pejabatModel;
    protected $jabatanModel;
    protected $SliderModel;
    protected $secretariatModel;
    protected $TusiModel;
    protected $VisiModel;
    protected $MbModel;
    protected $MbTableModel;
    protected $MsModel;
    protected $MsTableModel;
    protected $GaleriModel;
    protected $AlbumFotoModel;
    protected $GaleriVideoModel;
    protected $MenuAgendaModel;
    protected $AgendaModel;
    protected $AlurModel;
    protected $AlurFileModel;
    protected $AnggotaModel;
    protected $SKAModel;
    protected $AgamaModel;
    protected $PendidikanModel;
    protected $TingkatModel;
    protected $BiayaModel;

public function __construct()
    {
        $this->NewsModel = new NewsModel();
        $this->SejarahModel = new SejarahModel();
        $this->OrgschemeModel = new OrgschemeModel();
        $this->OrgschemeModel = new OrgschemeModel();
        $this->jabatanModel = new jabatanModel();
        $this->pejabatModel = new pejabatModel();
        $this->SliderModel = new SliderModel();
        $this->secretariatModel = new secretariatModel();
        $this->TusiModel = new TusiModel();
        $this->VisiModel = new VisiModel();
        $this->MbModel = new MbModel();
        $this->MbTableModel = new MbTableModel();
        $this->MsModel = new MsModel();
        $this->MsTableModel = new MsTableModel();
        $this->GaleriModel = new GaleriModel();
        $this->AlbumFotoModel = new AlbumFotoModel();
        $this->GaleriVideoModel = new GaleriVideoModel();
        $this->AlbumVideoModel = new AlbumVideoModel();
        $this->MenuAgendaModel = new MenuAgendaModel();
        $this->AgendaModel = new AgendaModel();
        $this->AlurModel = new AlurModel();
        $this->AlurFileModel = new AlurFileModel();
        $this->AnggotaModel = new AnggotaModel();
        $this->SKAModel = new SKAModel();
        $this->AgamaModel = new AgamaModel();
        $this->PendidikanModel = new PendidikanModel();
        $this->TingkatModel = new TingkatModel();
        $this->BiayaModel = new BiayaModel();
    }

public function index()
    {
        $data       = [
            'anggota'    => $this->AnggotaModel->countAllResults(),
            'ska'    => $this->AnggotaModel->where('noreg_ska is NOT NULL', NULL, FALSE)->countAllResults(),
            'title'     => 'Home',
        ];

return view('admin/page/home', $data);
    }

//Tampilan Data
    public function index_slider()
    {
        $slider = $this->SliderModel->findAll();
        $data       = [
            'title'     => 'Gambar Slider',
            'row'    => $slider
        ];

return view('admin/page/Slider/index', $data);
    }

public function add_slider()
    {
        $data       = [
            'title'     => 'Tambah Gambar',
            'validation' => \Config\Services::validation()
        ];

return view('admin/page/Slider/input', $data);
    }

public function save_slider()
    {
        if (!$this->validate([
            'judul' => [
                'rules' => 'required',
                'errors' => [
                    'required' => '{field} berita harus diisi'
                ]
            ],

'gambar' => [
                'rules' => 'max_size[gambar,13064]|is_image[gambar]|mime_in[gambar,image/jpg,image/jpeg,image/png]',
                'errors' => [
                    'uploaded'    => 'Pilih gambar terlebih dahulu !',
                    'max_size'    => 'Ukuran gambar terlalu besar',
                    'is_image'    => 'Format yang dibolehkan jpg, jpeg, dan png',
                    'mime_in'    => 'Format yang dibolehkan jpg, jpeg, dan png'
                ]
            ]
        ])) {
            // $validation = \Config\Services::validation();
            return redirect()->to('/slider/add')->withInput();
        }

//ambil gambar
        $fileGambar = $this->request->getFile('gambar');
        //Jika tidak ada gambar diupload
        if ($fileGambar->getError() == 4) {
            $namaGambar = 'default.png';
        } else {
            //genarate nama gambar
            $namaGambar = $fileGambar->getRandomName();
            //pindahkan gambar
            $fileGambar->move('img-slider', $namaGambar);
        }

$this->GaleriModel = new SliderModel();
        $slug = url_title($this->request->getVar('judul'), '-', true);
        $status = $this->request->getVar('status');

$this->GaleriModel->save([
            'judul' => $this->request->getVar('judul'),
            'slug' => $slug,
            'isi' => $this->request->getVar('isi'),
            'gambar' => $namaGambar,
            'status' => $status

]);

session()->setFlashdata('pesan', 'Gambar Berhasil Ditambahkan.');

return redirect()->to('/Manage/Foto');
    }

public function edit_slider($slug)
    {
        $data       = [
            'title'     => 'Ubah Gambar',
            'validation' => \Config\Services::validation(),
            'slider'    => $this->SliderModel->getImg($slug)
        ];

return view('admin/page/Slider/edit', $data);
    }

public function update_slider($id)
    {
        //cek judul diganti atau tidak
        $GambarLama = $this->SliderModel->getImg($this->request->getVar('slug'));
        if ($GambarLama['judul'] == $this->request->getVar('judul')) {
            $rules = 'required';
        } else {
            $rules = 'required|is_unique[galeri.judul]';
        }

if (!$this->validate([
            'judul' => [
                'rules' => $rules,
                'errors' => [
                    'required' => 'Judul gambar harus diisi',
                    'is_unique' => 'Judul gambar sudah terdaftar'
                ]
            ],

'gambar' => [
                'rules' => 'max_size[gambar,2048]|is_image[gambar]|mime_in[gambar,image/jpg,image/jpeg,image/png]',
                'errors' => [
                    'uploaded'    => 'Pilih gambar terlebih dahulu !',
                    'max_size'    => 'Ukuran gambar terlalu besar',
                    'is_image'    => 'Format yang dibolehkan jpg, jpeg, dan png',
                    'mime_in'    => 'Format yang dibolehkan jpg, jpeg, dan png'
                ]
            ]
        ])) {
            // $validation = \Config\Services::validation();
            return redirect()->to('/gambar/edit/' . $this->request->getVar('slug'))->withInput();
        }

$fileGambar = $this->request->getFile('gambar');

//cek gambar
        if ($fileGambar->getError() == 4) {
            $namaGambar = $this->request->getVar('gambarLama');
        } else {
            //genarate nama gambar
            $namaGambar = $fileGambar->getRandomName();
            //pindahkan gambar
            $fileGambar->move('img-slider', $namaGambar);
            //hapus gambar lama
            unlink('img-slider/' . $this->request->getVar('gambarLama'));
        }

$slug = url_title($this->request->getVar('judul'), '-', true);
        $status = $this->request->getVar('status');

$this->GaleriModel->save([
            'id'    => $id,
            'judul' => $this->request->getVar('judul'),
            'isi' => $this->request->getVar('isi'),
            'slug' => $slug,
            'gambar' => $namaGambar,
            'status' => $status

]);

session()->setFlashdata('pesan', 'Gambar Berhasil Diubah.');

return redirect()->to('/Manage/Slider');
    }    
    
    public function delete_slider($id)
    {
        //cari id gambar
        $slider = $this->SlideriModel->find($id);

//hapus gambar
        unlink('img-slider/' . $slider['gambar']);

$this->SliderModel->delete($id);

return redirect()->to('/Manage/Slider');

}

public function index_berita()
    {
        $NewsModel         = $this->NewsModel->findAll();

$data       = [
            'title'     => 'Berita',
            'row'    => $NewsModel
        ];

return view('admin/page/Berita/index', $data);
    }

public function add_berita()
    {

$data       = [
            'title'     => 'Berita',
            'validation' => \Config\Services::validation()
        ];

return view('admin/page/Berita/input', $data);
    }

public function save_berita()
    {

if (!$this->validate([
            'judul' => [
                'rules' => 'required|is_unique[berita.judul]',
                'errors' => [
                    'required' => '{field} berita harus diisi',
                    'is_unique' => '{field} berita sudah terdaftar'
                ]
            ],

'gambar' => [
                'rules' => 'max_size[gambar,2048]|is_image[gambar]|mime_in[gambar,image/jpg,image/jpeg,image/png]',
                'errors' => [
                    'uploaded'    => 'Pilih gambar terlebih dahulu !',
                    'max_size'    => 'Ukuran gambar terlalu besar',
                    'is_image'    => 'Format yang dibolehkan jpg, jpeg, dan png',
                    'mime_in'    => 'Format yang dibolehkan jpg, jpeg, dan png'
                ]
            ]
        ])) {
            // $validation = \Config\Services::validation();
            return redirect()->to(base_url() . '/Manage/AddBerita')->withInput();
        }

$this->NewsModel = new NewsModel();
        $slug = url_title($this->request->getVar('judul'), '-', true);
        $status = $this->request->getVar('status');
        $originalDate = $this->request->getVar('tanggal');
        $newDate = date("Y-m-d", strtotime($originalDate));

$this->NewsModel->save([
            'judul' => $this->request->getVar('judul'),
            'slug' => $slug,
            'berita' => $this->request->getVar('berita'),
            'lokasi' => $this->request->getVar('lokasi'),
            'gambar_berita' => $namaGambar,
            'sumber' => $this->request->getVar('sumber'),
            'tgl_berita' => $this->request->getVar('tanggal'),
            'status_berita' => $status

]);

session()->setFlashdata('pesan', 'Berita Berhasil Ditambahkan.');

return redirect()->to(base_url() . '/Manage/Berita');
    }

public function delete_berita($id)
    {

//cari id gambar
        $berita = $this->NewsModel->find($id);

//hapus gambar
        //unlink('img-berita/' . $berita['gambar_berita']);

$this->NewsModel->delete($id);

return redirect()->to(base_url() . '/Manage/Berita');
    }

public function edit_berita($slug)
    {
        $data       = [
            'title'     => 'Ubah Berita',
            'validation' => \Config\Services::validation(),
            'berita'    => $this->NewsModel->getNews($slug)
        ];

return view('admin/page/Berita/edit', $data);
    }

public function update_berita($id)
    {
        //cek judul diganti atau tidak
        $BeritaLama = $this->NewsModel->getNews($this->request->getVar('slug'));
        if ($BeritaLama['judul'] == $this->request->getVar('judul')) {
            $rules = 'required';
        } else {
            $rules = 'required|is_unique[berita.judul]';
        }

if (!$this->validate([
            'judul' => [
                'rules' => $rules,
                'errors' => [
                    'required' => '{field} berita harus diisi',
                    'is_unique' => '{field} berita sudah terdaftar'
                ]
            ],

'gambar' => [
                'rules' => 'max_size[gambar,2048]|is_image[gambar]|mime_in[gambar,image/jpg,image/jpeg,image/png]',
                'errors' => [
                    'uploaded'    => 'Pilih gambar terlebih dahulu !',
                    'max_size'    => 'Ukuran gambar terlalu besar',
                    'is_image'    => 'Format yang dibolehkan jpg, jpeg, dan png',
                    'mime_in'    => 'Format yang dibolehkan jpg, jpeg, dan png'
                ]
            ]
        ])) {
            // $validation = \Config\Services::validation();
            return redirect()->to(base_url('') . '/Manage/EditBerita/' . $this->request->getVar('slug'))->withInput();
        }

$fileGambar = $this->request->getFile('gambar');

//cek gambar
        if ($fileGambar->getError() == 4) {
            $namaGambar = $this->request->getVar('gambarLama');
        } else {
            //genarate nama gambar
            $namaGambar = $fileGambar->getRandomName();
            //pindahkan gambar
            $fileGambar->move('img-berita', $namaGambar);
            //hapus gambar lama
            //unlink('img-berita/' . $this->request->getVar('gambarLama'));
        }

$slug = url_title($this->request->getVar('judul'), '-', true);
        $status = $this->request->getVar('status');
        $originalDate = $this->request->getVar('tanggal');
        $newDate = date("Y-m-d", strtotime($originalDate));

$this->NewsModel->save([
            'id'    => $id,
            'judul' => $this->request->getVar('judul'),
            'slug' => $slug,
            'berita' => $this->request->getVar('berita'),
            'gambar_berita' => $namaGambar,
            'tgl_berita' => $this->request->getVar('tanggal'),
            'status_berita' => $status

]);

session()->setFlashdata('pesan', 'Berita Berhasil Diubah.');

return redirect()->to(base_url() . '/Manage/Berita');
    }

//Tampilan Data Galeri Foto
    public function index_foto()
    {
        $galeri = $this->GaleriModel->findAll();
        $data       = [
            'title'    => 'Galeri',
            'row'        => $galeri,
            'album'    => $this->AlbumFotoModel->findAll(),
            'album2'   => $this->AlbumFotoModel->findAll()
        ];

return view('admin/page/Galeri/index', $data);
    }

public function add_foto()
    {

$data       = [
            'title'     => 'Tambah Gambar',
            'validation' => \Config\Services::validation(),
            'album'     => $this->AlbumFotoModel->findAll(),
            'album2'     => $this->AlbumFotoModel->findAll(),
        ];

return view('admin/page/Galeri/input', $data);
    }

public function save_foto()
    {

if (!$this->validate([
            'judul' => [
                'rules' => 'required',
                'errors' => [
                    'required' => '{field} berita harus diisi'
                ]
            ],

'album' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Album harus dipilih',
                ]
            ],

'gambar' => [
                'rules' => 'max_size[gambar,2048]|is_image[gambar]|mime_in[gambar,image/jpg,image/jpeg,image/png,image/webp]',
                'errors' => [
                    'uploaded'    => 'Pilih gambar terlebih dahulu !',
                    'max_size'    => 'Ukuran gambar terlalu besar',
                    'is_image'    => 'Format yang dibolehkan jpg, jpeg, dan png',
                    'mime_in'    => 'Format yang dibolehkan jpg, jpeg, dan png'
                ]
            ]
        ])) {
            // $validation = \Config\Services::validation();
            return redirect()->to(base_url() . '/Manage/AddFoto')->withInput();
        }

$this->GaleriModel = new GaleriModel();
        $slug = url_title($this->request->getVar('judul'), '-', true);
        $status = $this->request->getVar('status');

$this->GaleriModel->save([
            'judul' => $this->request->getVar('judul'),
            'slug' => $slug,
            'gambar' => $namaGambar,
            'album' => $this->request->getVar('album'),
            'status' => $status

]);

session()->setFlashdata('pesan', 'Gambar Berhasil Ditambahkan.');

return redirect()->to('/Manage/Foto');
    }

public function delete_foto($id)
    {

//cari id gambar
        $galeri = $this->GaleriModel->find($id);

//hapus gambar
        unlink('img-galeri/' . $galeri['gambar']);

$this->GaleriModel->delete($id);

return redirect()->to('/Manage/Foto');
    }

public function edit_foto($slug)
    {
        $data       = [
            'title'     => 'Ubah Gambar',
            'validation' => \Config\Services::validation(),
            'galeri'    => $this->GaleriModel->getImg($slug),
            'album'    => $this->AlbumFotoModel->findAll(),
            'album2'    => $this->AlbumFotoModel->findAll(),
        ];

return view('admin/page/Galeri/edit', $data);
    }

public function update_foto($id)
    {
        //cek judul diganti atau tidak
        $GambarLama = $this->GaleriModel->getImg($this->request->getVar('slug'));
        if ($GambarLama['judul'] == $this->request->getVar('judul')) {
            $rules = 'required';
        } else {
            $rules = 'required|is_unique[galeri.judul]';
        }

'album' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Album harus dipilih',
                ]
            ],

'gambar' => [
                'rules' => 'max_size[gambar,2048]|is_image[gambar]|mime_in[gambar,image/jpg,image/jpeg,image/png,image/webp]',
                'errors' => [
                    'uploaded'    => 'Pilih gambar terlebih dahulu !',
                    'max_size'    => 'Ukuran gambar terlalu besar',
                    'is_image'    => 'Format yang dibolehkan jpg, jpeg, dan png',
                    'mime_in'    => 'Format yang dibolehkan jpg, jpeg, dan png'
                ]
            ]
        ])) {
            // $validation = \Config\Services::validation();
            return redirect()->to('/gambar/edit/' . $this->request->getVar('slug'))->withInput();
        }

$fileGambar = $this->request->getFile('gambar');

//cek gambar
        if ($fileGambar->getError() == 4) {
            $namaGambar = $this->request->getVar('gambarLama');
        } else {
            //genarate nama gambar
            $namaGambar = $fileGambar->getRandomName();
            //pindahkan gambar
            $fileGambar->move('img-galeri', $namaGambar);
            //hapus gambar lama
            unlink('img-galeri/' . $this->request->getVar('gambarLama'));
        }

$slug = url_title($this->request->getVar('judul'), '-', true);
        $status = $this->request->getVar('status');

$this->GaleriModel->save([
            'id'    => $id,
            'judul' => $this->request->getVar('judul'),
            'slug' => $slug,
            'gambar' => $namaGambar,
            'album' => $this->request->getVar('album'),
            'status' => $status

]);

session()->setFlashdata('pesan', 'Gambar Berhasil Diubah.');

return redirect()->to('/Manage/Galeri');
    }

public function ubahstatus_foto($slug)
    {
        $statuslama = $this->GaleriModel->getImg($slug);

if ($statuslama['status'] == 1) {
            $status =  2;
        } else if ($statuslama['status'] == 2) {
            $status = 1;
        }

// dd($status);

$id = $statuslama['id'];

$this->GaleriModel->save([
            'id'    => $id,
            'status' => $status,
        ]);

// session()->setFlashdata('pesan', 'Gambar Berhasil Diubah.');

return redirect()->to(base_url() . '/Manage/Foto');
    }

public function saveAlbum_foto()
    {
        $this->AlbumFotoModel->save([
            'album' => $this->request->getVar('album'),

]);

// session()->setFlashdata('pesan', 'Gambar Berhasil Ditambahkan.');

return redirect()->to(base_url() . '/Manage/Foto');
    }

public function updateAlbum_foto()
    {

$this->AlbumFotoModel->save([
            'id'    => $this->request->getVar('id'),
            'album' => $this->request->getVar('album'),
        ]);

session()->setFlashdata('pesan', 'Gambar Berhasil Diubah.');

return redirect()->to(base_url() . '/Manage/Foto');
    }

public function deleteAlbum_foto($id)
    {

//cari id gambar
        $album = $this->AlbumFotoModel->find($id);

$this->AlbumFotoModel->delete($id);

//  return redirect()->to('/Manage/Berita');

//  $this->AlbumFotoModel->save([
        // 	 'id'    => $this->request->getVar('id'),
        // 	 'album' => $this->request->getVar('album'),
        //  ]);

session()->setFlashdata('pesan', 'Gambar Berhasil Diubah.');

return redirect()->to(base_url() . '/Manage/Foto');
    }

//Tampilan Data Video
    public function index_video()
    {

$data       = [
            'title'     => 'Galeri Video',
            'video'    => $this->GaleriVideoModel->findAll(),
            'album'    => $this->AlbumVideoModel->findAll(),
            'album2'     => $this->AlbumVideoModel->FindAll(),
        ];

return view('admin/page/Galeri/indexVideo', $data);
    }

public function add_video()
    {

$data       = [
            'title'     => 'Tambah Video',
            'album'     => $this->AlbumVideoModel->FindAll(),
            'album2'     => $this->AlbumVideoModel->FindAll(),

'validation' => \Config\Services::validation()
        ];

return view('admin/page/Galeri/inputVideo', $data);
    }

public function save_video()
    {

if (!$this->validate([
            'judul' => [
                'rules' => 'required|is_unique[galerivideo.judul]',
                'errors' => [
                    'required' => '{field} video harus diisi',
                    'is_unique' => '{field} video sudah terdaftar'
                ]
            ],

'album' => [
                'rules' => 'required',
                'errors' => [
                    'required' => '{field} harus dipilih',
                ]
            ],

'video' => [
                'rules' => 'required',
                'errors' => [
                    'required' => '{field} harus diisi',
                ]
            ],
        ])) {
            // $validation = \Config\Services::validation();
            return redirect()->to(base_url() . '/Manage/AddVideo')->withInput();
        }

$this->GaleriVideoModel = new GaleriVideoModel();
        $slug = url_title($this->request->getVar('judul'), '-', true);
        $status = $this->request->getVar('status');

$this->GaleriVideoModel->save([
            'judul' => $this->request->getVar('judul'),
            'slug' => $slug,
            'album' => $this->request->getVar('album'),
            'video' => $this->request->getVar('video'),
            'status' => $status

]);

session()->setFlashdata('pesan', 'Gambar Berhasil Ditambahkan.');

return redirect()->to(base_url() . '/Manage/Video');
    }

public function delete_video($id)
    {

//cari id gambar
        $galeri = $this->GaleriVideoModel->find($id);

return redirect()->to(base_url() . 'Manage/Video');
    }

public function edit_video($slug)
    {
        $data       = [
            'title'     => 'Ubah Video',
            'validation' => \Config\Services::validation(),
            'video'    => $this->GaleriVideoModel->getData($slug),
            'album'     => $this->AlbumVideoModel->FindAll(),
            'album2'     => $this->AlbumVideoModel->FindAll(),
        ];

return view('admin/page/Galeri/editVideo', $data);
    }

public function update_video($id)
    {
        //cek judul diganti atau tidak
        $videolama = $this->GaleriVideoModel->getData($this->request->getVar('slug'));
        if ($videolama['judul'] == $this->request->getVar('judul')) {
            $rules = 'required';
        } else {
            $rules = 'required|is_unique[galeri.judul]';
        }

if (!$this->validate([
            'judul' => [
                'rules' => $rules,
                'errors' => [
                    'required' => 'Judul Video harus diisi',
                    'is_unique' => 'Judul Video sudah terdaftar'
                ]
            ],

'album' => [
                'rules' => 'required',
                'errors' => [
                    'required' => '{field} harus dipilih',
                ]
            ],

$slug = url_title($this->request->getVar('judul'), '-', true);
        $status = $this->request->getVar('status');

$this->GaleriVideoModel->save([
            'id'    => $id,
            'judul' => $this->request->getVar('judul'),
            'slug' => $slug,
            'album' => $this->request->getVar('album'),
            'video' => $this->request->getVar('video'),
            'status' => $status

]);

session()->setFlashdata('pesan', 'Gambar Berhasil Diubah.');

return redirect()->to(base_url() . 'Manage/Video');
    }

public function saveAlbum_video()
    {
        $this->AlbumVideoModel->save([
            'album' => $this->request->getVar('album'),

]);

// session()->setFlashdata('pesan', 'Gambar Berhasil Ditambahkan.');

return redirect()->to('/Manage/Galeri-Video');
    }

public function updateAlbum_video()
    {

$this->AlbumVideoModel->save([
            'id'    => $this->request->getVar('id'),
            'album' => $this->request->getVar('album'),
        ]);

session()->setFlashdata('pesan', 'Gambar Berhasil Diubah.');

return redirect()->to('/Manage/Galeri-Video');
    }

public function ubahstatus_video($slug)
    {
        $statuslama = $this->GaleriVideoModel->getData($slug);

if ($statuslama['status'] == 1) {
            $status =  2;
        } else if ($statuslama['status'] == 2) {
            $status = 1;
        }

// dd($status);

$id = $statuslama['id'];

$this->GaleriVideoModel->save([
            'id'    => $id,
            'status' => $status,
        ]);

// session()->setFlashdata('pesan', 'Gambar Berhasil Diubah.');

return redirect()->to('/Manage/Galeri-Video');
    }

//Tampilan Data Sejarah
    public function index_sejarah()
    {
        $SejarahModel         = $this->SejarahModel->findAll();

$data       = [
            'title'     => 'Sejarah',
            'row'    => $SejarahModel
        ];

return view('admin/page/Sejarah/index', $data);
    }

public function edit_sejarah($id)
    {
        $data       = [
            'title'          => 'Ubah',
            'validation'     => \Config\Services::validation(),
            'sejarah'    => $this->SejarahModel->getData($id)
        ];

return view('admin/page/Sejarah/edit', $data);
    }

public function update_sejarah($id)
    {
        //cek judul diganti atau tidak
        $SejarahLama = $this->SejarahModel->getData($this->request->getVar('id'));
        if ($SejarahLama['judul'] == $this->request->getVar('judul')) {
            $rules = 'required';
        } else {
            $rules = 'required|is_unique[visimisi.judul]';
        }

if (!$this->validate([
            'judul' => [
                'rules' => $rules,
                'errors' => [
                    'required' => 'Judul harus diisi',
                    'is_unique' => 'Judul sudah terdaftar'
                ]
            ]

])) {
            // $validation = \Config\Services::validation();
            return redirect()->to(base_url() . '/Manage/EditSejarah/' . $this->request->getVar('id'))->withInput();
        }

$status = $this->request->getVar('status');

$this->SejarahModel->save([
            'id'    => $id,
            'judul' => $this->request->getVar('judul'),
            'isi' => $this->request->getVar('isi'),
            'status' => $status

]);

session()->setFlashdata('pesan', 'Berhasil Diubah.');

return redirect()->to(base_url() . '/Manage/Sejarah');
    }

//Tampilan Data Struktur Organisasi

public function index_struktur()
    {

$builder    = $this->jabatanModel;
        $builder->select('*');
        $builder->join('pejabat', 'pejabat.id_jabatan = jabatan.id');
        $query  = $builder->orderBy('pejabat.id', 'asc')->findAll();

$orgscheme = $this->OrgschemeModel->findAll();
        $data       = [
            'title'     => 'Struktur Organisasi',
            'row'    => $orgscheme,
            'pejabat'    => $query,
        ];

return view('admin/page/OrgScheme/index', $data);
    }

public function edit_struktur($id)
    {
        $data       = [
            'title'     => 'Ubah Gambar',
            'row'    => $this->OrgschemeModel->getImg($id)
        ];

return view('admin/page/OrgScheme/edit', $data);
    }

public function update_struktur($id)
    {
        //cek judul diganti atau tidak
        $GambarLama = $this->OrgschemeModel->getImg($this->request->getVar('id'));

$fileGambar = $this->request->getFile('gambar');
        //genarate nama gambar
        $namaGambar = $fileGambar->getRandomName();
        //pindahkan gambar
        $fileGambar->move('img', $namaGambar);

$this->OrgschemeModel->save([
            'id'    => $id,
            'org_image' => $namaGambar,

]);

session()->setFlashdata('pesan', 'Gambar Berhasil Diubah.');

//hapus gambar lama
        unlink('img/' . $this->request->getVar('gambarLama'));

return redirect()->to(base_url() . '/Manage/StrukturOrganisasi');
    }

public function add_pejabat()
    {

$data       = [
            'title'     => ' Tambah Pejabat',
            'pejabat'    => $this->pejabatModel->FindAll(),
            'jabatan'    => $this->jabatanModel->FindAll(),
            'validation' => \Config\Services::validation()
        ];

return view('admin/page/OrgScheme/inputpejabat', $data);
    }

public function save_pejabat()
    {

if (!$this->validate([

'nama' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Nama Pejabat harus diisi',
                ]
            ],

'jabatan' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Jabatan harus dipilih',
                ]
            ],

'masa_iuran' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Masa Iuran harus diisi',
                ]
            ],

])) {
            // $validation = \Config\Services::validation();
            return redirect()->to(base_url() . '/Manage/AddPejabat')->withInput();
        }

$fileGambar = $this->request->getFile('foto');
        //Jika tidak ada gambar diupload
        if ($fileGambar->getError() == 4) {
            $namaGambar = 'default.jpg';
        } else {
            //genarate nama gambar
            $namaGambar = $fileGambar->getRandomName();
            //pindahkan gambar
            $fileGambar->move('img-pejabat', $namaGambar);
        }

$this->pejabatModel = new pejabatModel();
        $status = $this->request->getVar('status');

$this->AnggotaModel->save([
            'nama' => $this->request->getVar('nama'),
            'id_jabatan' => $this->request->getVar('jabatan'),
            'foto' => $namaGambar,
            'status' => $status,

]);
        // dd($this->request->getVar());

session()->setFlashdata('pesan', 'Pejabat Berhasil Ditambahkan.');

return redirect()->to(base_url() . '/Manage/StrukturOrganisasi');
    }

public function delete_pejabat($id)
    {

//cari id gambar
        $pejabat = $this->OrgschemeModel->find($id);

if ($pejabat['foto'] == 'default.jpg') {

$this->OrgschemeModel->delete($id);
        } else {

unlink('img-pejabat/' . $pejabat['foto']);

$this->OrgschemeModel->delete($id);
        }

return redirect()->to(base_url() . '/Manage/StrukturOrganisasi');
    }

public function edit_pejabat($id)
    {
        $data       = [
            'title'         => 'Ubah Pejabat',
            'jabatan'         => $this->jabatanModel->findAll(),
            'validation'    => \Config\Services::validation(),
            'pejabat'       => $this->pejabatModel->getData($id),
        ];

return view('admin/page/OrgScheme/editpejabat', $data);
    }

public function update_pejabat($id)
    {

if (!$this->validate([
            'nama' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Nama Pejabat harus diisi',
                ]
            ],
            'jabatan' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Jabatan harus dipilih',
                ]
            ],

])) {

return redirect()->to(base_url() . '/Manage/edit_pejabat/' . $id)->withInput();
        }

//cek gambar
        $fileGambar = $this->request->getFile('foto');

if ($fileGambar->getError() == 4) {
            $namaGambar = $this->request->getVar('fotolama');
        } else {
            //genarate nama gambar
            $namaGambar = $fileGambar->getRandomName();
            //pindahkan gambar
            $fileGambar->move('/public/img-pejabat', $namaGambar);
            //hapus gambar lama
            unlink('/public/img-pejabat/' . $this->request->getVar('fotolama'));
        }

$status = $this->request->getVar('status');

$this->pejabatModel->save([
            'id' => $id,
            'id_jabatan' => $this->request->getVar('jabatan'),
            'nama' => $this->request->getVar('nama'),
            'foto' => $namaGambar,
            'status' => $status,

]);

session()->setFlashdata('pesan', 'Berhasil Diubah.');

return redirect()->to(base_url() . '/Manage/StrukturOrganisasi');
    }

//Tampilan Data Tugas Fungsi

public function index_tusi()
    {
        $TusiModel         = $this->TusiModel->findAll();

$data       = [
            'title'     => 'Tugas dan Fungsi',
            'row'    => $TusiModel
        ];

return view('admin/page/Tusi/index', $data);
    }

public function add_tusi()
    {

$data       = [
            'title'     => 'Tambah Tugas dan Fungsi',
            'validation' => \Config\Services::validation()
        ];

return view('admin/page/Tusi/input', $data);
    }

public function save_tusi()
    {

if (!$this->validate([
            'judul' => [
                'rules' => 'required|is_unique[tusi.judul]',
                'errors' => [
                    'required' => 'Judul harus diisi',
                    'is_unique' => 'Judul sudah terdaftar'
                ]
            ]
        ])) {
            // $validation = \Config\Services::validation();
            return redirect()->to('/TugasFungsi/add')->withInput();
        }

$this->TusiModel = new TusiModel();
        $status = $this->request->getVar('status');

$this->TusiModel->save([
            'judul' => $this->request->getVar('judul'),
            'isi' => $this->request->getVar('isi'),
            'status' => $status

]);

session()->setFlashdata('pesan', 'Berhasil Ditambahkan.');

return redirect()->to('/Manage/Tugas-Fungsi');
    }

public function delete_tusi($id)
    {

//cari id gambar
        $tusi = $this->TusiModel->find($id);

//hapus gambar
        //unlink('img-berita/' . $berita['gambar_berita']);

$this->TusiModel->delete($id);

session()->setFlashdata('pesan', 'Berhasil Dihapus.');

return redirect()->to(base_url() . '/Manage/Tusi');
    }

public function edit_tusi($id)
    {
        $data       = [
            'title'          => 'Ubah',
            'validation'     => \Config\Services::validation(),
            'tugasfungsi'    => $this->TusiModel->getData($id)
        ];

return view('admin/page/Tusi/edit', $data);
    }

public function update_tusi($id)
    {
        //cek judul diganti atau tidak
        $TusiLama = $this->TusiModel->getData($this->request->getVar('id'));
        if ($TusiLama['judul'] == $this->request->getVar('judul')) {
            $rules = 'required';
        } else {
            $rules = 'required|is_unique[tugasfungsi.judul]';
        }

])) {
            // $validation = \Config\Services::validation();
            return redirect()->to(base_url() . '/Manage/EditTusi/' . $this->request->getVar('id'))->withInput();
        }

$status = $this->request->getVar('status');

$this->TusiModel->save([
            'id'    => $id,
            'judul' => $this->request->getVar('judul'),
            'isi' => $this->request->getVar('isi'),
            'status' => $status

]);

session()->setFlashdata('pesan', 'Berhasil Diubah.');

return redirect()->to(base_url() . '/Manage/Tusi');
    }

//Tampilan Data Visi Misi

public function index_visi()
    {
        $VisiModel         = $this->VisiModel->findAll();

$data       = [
            'title'     => 'Visi dan Misi',
            'row'    => $VisiModel
        ];

return view('admin/page/Visi/index', $data);
    }

public function add_visi()
    {

$data       = [
            'title'     => 'Tambah Visi dan Misi',
            'validation' => \Config\Services::validation()
        ];

return view('admin/page/Visi/input', $data);
    }

public function save_visi()
    {

$this->VisiModel = new VisiModel();
        $status = $this->request->getVar('status');

$this->VisiModel->save([
            'judul' => $this->request->getVar('judul'),
            'isi' => $this->request->getVar('isi'),
            'status' => $status

]);

session()->setFlashdata('pesan', 'Berhasil Ditambahkan.');

return redirect()->to(base_url() . '/Manage/Visi');
    }

public function delete_visi($id)
    {

//cari id gambar
        $tusi = $this->VisiModel->find($id);

//hapus gambar
        //unlink('img-berita/' . $berita['gambar_berita']);

$this->VisiModel->delete($id);

session()->setFlashdata('pesan', 'Berhasil Dihapus.');

return redirect()->to(base_url() . '/Manage/Visi');
    }

public function edit_visi($id)
    {
        $data       = [
            'title'          => 'Ubah',
            'validation'     => \Config\Services::validation(),
            'visimisi'    => $this->VisiModel->getData($id)
        ];

return view('admin/page/Visi/edit', $data);
    }

public function update_visi($id)
    {
        //cek judul diganti atau tidak
        $VisiLama = $this->VisiModel->getData($this->request->getVar('id'));
        if ($VisiLama['judul'] == $this->request->getVar('judul')) {
            $rules = 'required';
        } else {
            $rules = 'required|is_unique[visimisi.judul]';
        }

])) {
            // $validation = \Config\Services::validation();
            return redirect()->to(base_url() . '/Manage/EditVisi/' . $this->request->getVar('id'))->withInput();
        }

$status = $this->request->getVar('status');

$this->VisiModel->save([
            'id'    => $id,
            'judul' => $this->request->getVar('judul'),
            'isi' => $this->request->getVar('isi'),
            'status' => $status

]);

session()->setFlashdata('pesan', 'Berhasil Diubah.');

return redirect()->to(base_url() . '/Manage/Visi');
    }

//Tampilan Data Agenda

public function index_agenda()
    {
        $AgendaModel         = $this->AgendaModel->findAll();
        $MenuAgendaModel         = $this->MenuAgendaModel->findAll();

$data       = [
            'title'     => 'Agenda',
            'rowAgenda'    => $AgendaModel,
            'rowMenu'    => $MenuAgendaModel
        ];

return view('admin/page/Agenda/index', $data);
    }

public function add_agenda($id)
    {
        $jenis = $this->MenuAgendaModel->getData($id);
        $data       = [

'jenis_agenda' => $jenis,
            'title'     => 'Tambah ' . $jenis['jenis'],
            'validation' => \Config\Services::validation()
        ];

return view('admin/page/Agenda/input', $data);
    }

public function save_agenda($id)
    {

$jenis = $this->MenuAgendaModel->getData($id);

if (!$this->validate([
            'judul' => [
                'rules' => 'required|is_unique[agenda.judul]',
                'errors' => [
                    'required' => '{field} agenda harus diisi',
                    'is_unique' => '{field} agenda sudah terdaftar'
                ]
            ],

'gambar' => [
                'rules' => 'max_size[gambar,12048]|is_image[gambar]|mime_in[gambar,image/jpg,image/jpeg,image/png]',
                'errors' => [
                    'uploaded'    => 'Pilih gambar terlebih dahulu !',
                    'max_size'    => 'Ukuran gambar terlalu besar',
                    'is_image'    => 'Format yang dibolehkan jpg, jpeg, dan png',
                    'mime_in'    => 'Format yang dibolehkan jpg, jpeg, dan png'
                ]
            ]
        ])) {
            // $validation = \Config\Services::validation();
            return redirect()->to(base_url('') . '/Manage/add_agenda/' . $jenis['id'])->withInput();
        }

$this->AgendaModel = new AgendaModel();
        $slug = url_title($this->request->getVar('judul'), '-', true);
        $status = $this->request->getVar('status');
        $originalDate = $this->request->getVar('tanggal');
        $newDate = date("Y-m-d", strtotime($originalDate));

$this->AgendaModel->save([
            'judul' => $this->request->getVar('judul'),
            'slug' => $slug,
            'isi' => $this->request->getVar('isi'),
            'gambar' => $namaGambar,
            'tanggal' => $this->request->getVar('tanggal'),
            'jenis' => $jenis['id'],
            'status' => $status

]);

session()->setFlashdata('pesan', 'Berita Berhasil Ditambahkan.');

return redirect()->to(base_url() . '/Manage/Agenda');
    }

public function delete_agenda($id)
    {

//cari id gambar
        $agenda = $this->AgendaModel->find($id);

//hapus gambar
        unlink('public/img-agenda/' . $agenda['gambar']);

$this->AgendaModel->delete($id);

return redirect()->to(base_url() . '/Manage/Agenda');
    }

public function edit_agenda($id)
    {
        $jenis_agenda = $this->MenuAgendaModel->getData($id);
        $data       = [
            'title'     => 'Ubah Agenda',
            'validation' => \Config\Services::validation(),
            'agenda'    => $this->AgendaModel->getAgenda($id),
            'jenis_agenda'     => $jenis_agenda
        ];

return view('admin/page/agenda/edit', $data);
    }

public function update_agenda($id)
    {
        //cek judul diganti atau tidak
        $AgendaLama = $this->AgendaModel->getData($this->request->getVar('slug'));
        if ($AgendaLama['judul'] == $this->request->getVar('judul')) {
            $rules = 'required';
        } else {
            $rules = 'required|is_unique[agenda.judul]';
        }

'gambar' => [
                'rules' => 'max_size[gambar,2048]|is_image[gambar]|mime_in[gambar,image/jpg,image/jpeg,image/png]',
                'errors' => [
                    'uploaded'    => 'Pilih gambar terlebih dahulu !',
                    'max_size'    => 'Ukuran gambar terlalu besar',
                    'is_image'    => 'Format yang dibolehkan jpg, jpeg, dan png',
                    'mime_in'    => 'Format yang dibolehkan jpg, jpeg, dan png'
                ]
            ]
        ])) {
            // $validation = \Config\Services::validation();
            return redirect()->to(base_url() . '/Manage/EditAgenda' . $this->request->getVar($id))->withInput();
        }

$fileGambar = $this->request->getFile('gambar');

//cek gambar
        if ($fileGambar->getError() == 4) {
            $namaGambar = $this->request->getVar('gambarLama');
        } else {
            //genarate nama gambar
            $namaGambar = $fileGambar->getRandomName();
            //pindahkan gambar
            $fileGambar->move('public/img-agenda', $namaGambar);
            //hapus gambar lama
            //unlink('img-berita/' . $this->request->getVar('gambarLama'));
        }

$this->AgendaModel->save([
            'id'    => $id,
            'judul' => $this->request->getVar('judul'),
            'slug' => $slug,
            'isi' => $this->request->getVar('isi'),
            'gambar' => $namaGambar,
            'tanggal' => $this->request->getVar('tanggal'),
            'status' => $status

]);

session()->setFlashdata('pesan', 'Agenda Berhasil Diubah.');

return redirect()->to(base_url() . '/Manage/Agenda');
    }

public function index_kontak()
    {
        $data       = [
            'title'          => 'Pengaturan Kontak',
            'validation'     => \Config\Services::validation(),
            'kontak'    => $this->secretariatModel->getData(1)
        ];

return view('admin/page/pengaturan-kontak', $data);
    }

public function update_kontak()
    {
        $this->secretariatModel->save([
            'id'    => 1,
            'alamat' => $this->request->getVar('alamat'),
            'telepon' => $this->request->getVar('telepon'),
            'email' => $this->request->getVar('email'),
            'website' => $this->request->getVar('website'),
            'linkmap' => $this->request->getVar('linkmap'),
            'bank' => $this->request->getVar('bank'),

]);

return redirect()->to(base_url() . '/Manage/Kontak');
    }

public function index_alur()
    {
        $Alur         = $this->AlurModel->findAll();
        $AlurFile         = $this->AlurFileModel->findAll();

$data       = [
            'title'     => 'Alur Registrasi',
            'alur'      => $Alur,
            'alurfile'  => $AlurFile
        ];

return view('admin/page/Alur/index', $data);
    }

public function add_alur()
    {
        $data = [
            'title' => 'Tambah Alur',
            'validation'     => \Config\Services::validation(),
        ];

return view('admin/page/alur/add', $data);
    }

public function edit_alur($id)
    {
        $data       = [
            'title'          => 'Ubah Alur Registrasi',
            'validation'     => \Config\Services::validation(),
            'alur'    => $this->AlurModel->getData($id)
        ];

return view('admin/page/Alur/edit', $data);
    }

public function update_alur($id)
    {

$fileGambar = $this->request->getFile('gambar');

if ($fileGambar->getError() == 4) {
            $namaGambar = $this->request->getVar('gambarlama');
        } else {
            //genarate nama gambar
            $namaGambar = $fileGambar->getRandomName();
            //pindahkan gambar
            $fileGambar->move(base_url('/public') . '/img-alur', $namaGambar);
            //hapus gambar lama
            // unlink('img-alur/' . $this->request->getVar('gambarlama'));
        }

$status = $this->request->getVar('status');

$this->AlurModel->save([
            'id'    => $id,
            'gambar'    => $namaGambar,
            'isi' => $this->request->getVar('isi'),
            'status' => $status

]);

session()->setFlashdata('pesan', 'Berhasil Diubah.');

return redirect()->to(base_url() . '/Manage/Alur');
    }

public function add_alurfile()
    {
        $data = [
            'title' => 'Tambah File Alur',
            'validation' => \Config\Services::validation()
        ];

return view('admin/page/Alur/tambahfile', $data);
    }

public function save_alurfile()
    {
    }

public function edit_alurfile($id)
    {
        $data       = [
            'title'     => 'Ubah File',
            'alurfile'    => $this->AlurFileModel->getData($id)
        ];

return view('admin/page/Alur/editfile', $data);
    }

public function updatefile($id)
    {
        $file = $this->request->getVar('namafile');

//cek gambar
        //genarate nama gambar
        //pindahkan gambar
        $file->move(base_url('/public') . '/img-berita', $file);
        //hapus gambar lama
        //unlink('img-berita/' . $this->request->getVar('gambarLama'));

$status = $this->request->getVar('status');

$this->AlurFileModel->save([
            'id'    => $id,
            'namafile' => $file,
            'status_berita' => $status

]);

session()->setFlashdata('pesan', 'Berita Berhasil Diubah.');

return redirect()->to(base_url() . '/Manage/Alur');
    }

public function index_anggota()
    {
        $AnggotaModel         = $this->AnggotaModel->findAll();

$builder    = $this->AnggotaModel;
        $builder->select('*');
        $builder->join('ska', 'ska.id_anggota = anggota.id_anggota');
        $query  = $builder->findAll();

$data       = [
            'title'     => 'Anggota',
            'row'    => $AnggotaModel,
            'query'    => $query

];

return view('admin/page/Anggota/index', $data);
    }

public function add_anggota()
    {
        $data       = [
            'title'     => 'Tambah Anggota',
            'agama'     => $this->AgamaModel->findAll(),
            'pendidikan'     => $this->PendidikanModel->findAll(),
            'tingkat'     => $this->TingkatModel->findAll(),
            'validation' => \Config\Services::validation()
        ];

return view('admin/page/Anggota/input', $data);
    }

public function save_anggota()
    {
        if (!$this->validate([
            'id' => [
                'rules' => 'required|is_unique[anggota.id]',
                'errors' => [
                    'required' => 'ID Anggota harus diisi',
                    'is_unique' => 'ID Anggota sudah terdaftar'
                ]
            ],

'nama' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Nama Anggota harus diisi',
                ]
            ],

'agama' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Agama Anggota harus diisi',
                ]
            ],

'tingkat' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Tingkat harus dipilih',
                ]
            ],

'pendidikan' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Pendidikan Anggota harus diisi',
                ]
            ],

'tempatlahir' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Tempat Lahir harus diisi',
                ]
            ],

'tgllahir' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Tanggal Lahir harus diisi',
                ]
            ],

'tgl_terdaftar' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Tanggal Terdaftar harus diisi',
                ]
            ],

'tgl_pemutihan' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Tanggal Pemutihan harus diisi',
                ]
            ],

'masa_iuran' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Masa Iuran harus diisi',
                ]
            ],

'noktp' => [
                'rules' => 'required|is_unique[anggota.noktp]|numeric|max_length[16]',
                'errors' => [
                    'required' => 'NIK Anggota harus diisi',
                    'is_unique' => 'NIK Anggota sudah terdaftar',
                    'numeric' => 'Hanya angka yang dimasukan',
                    'max_length' => 'Maksimal 16 Karakter'
                ]
            ],

'npwp' => [
                'rules' => 'required|is_unique[anggota.npwp]|numeric|max_length[16]',
                'errors' => [
                    'required' => 'NPWP Anggota harus diisi',
                    'is_unique' => 'NPWP Anggota sudah terdaftar',
                    'numeric' => 'Hanya angka yang dimasukan',
                    'max_length' => 'Karakter melebihi ketentuan'
                ]
            ],

'pekerjaan' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Pekerjaan harus diisi',
                ]
            ],

'email' => [
                'rules' => 'required|valid_email',
                'errors' => [
                    'required' => 'e-Mail Anggota harus diisi',
                    'valid_email' => 'Format email harus benar',
                ]
            ],

'notelp' => [
                'rules' => 'required|is_unique[anggota.notelp]|numeric|max_length[13]',
                'errors' => [
                    'required' => 'No Telepon harus diisi',
                    'is_unique' => 'No Telepon sudah terdaftar',
                    'numeric' => 'Isi dengan benar (ex : 08123457890)',
                    'max_length' => 'Karakter melebihi ketentuan'
                ]
            ],

'fax' => [
                'rules' => 'numeric|max_length[10]',
                'errors' => [
                    'numeric' => 'Isi dengan benar (ex : 08123457890)',
                ]
            ],

])) {
            // $validation = \Config\Services::validation();
            return redirect()->to(base_url() . '/Anggota/AddAnggota')->withInput();
        }

$this->AnggotaModel = new AnggotaModel();
        $status = $this->request->getVar('status');

$this->AnggotaModel->save([
            'id_anggota' => $this->request->getVar('id'),
            'nama' => $this->request->getVar('nama'),
            'tempatlahir' => $this->request->getVar('tempatlahir'),
            'tgllahir' => $this->request->getVar('tgllahir'),
            'noktp' => $this->request->getVar('noktp'),
            'npwp' => $this->request->getVar('npwp'),
            'agama' => $this->request->getVar('agama'),
            'pekerjaan' => $this->request->getVar('pekerjaan'),
            'pendidikan' => $this->request->getVar('pendidikan'),
            'email' => $this->request->getVar('email'),
            'alamat' => $this->request->getVar('alamat'),
            'notelp' => $this->request->getVar('notelp'),
            'fax' => $this->request->getVar('fax'),
            'nama_perusahaan' => $this->request->getVar('nama_perusahaan'),
            'notlp_perusahaan' => $this->request->getVar('notlp_perusahaan'),
            'fax_perusahaan' => $this->request->getVar('fax_perusahaan'),
            'alamat_perusahaan' => $this->request->getVar('alamat_perusahaan'),
            'status' => $status,
            'tingkat' => $this->request->getVar('tingkat'),
            'tgl_terdaftar' => $this->request->getVar('tgl_terdaftar'),
            'tgl_pemutihan' => $this->request->getVar('tgl_pemutihan'),
            'masa_iuran' => $this->request->getVar('masa_iuran'),
            'keterangan' => $this->request->getVar('keterangan'),

]);
        // dd($this->request->getVar());

session()->setFlashdata('pesan', 'Anggota Berhasil Ditambahkan.');

return redirect()->to(base_url() . '/Manage/Anggota');
    }

public function edit_anggota($id)
    {
        $anggota = $this->AnggotaModel->getData($id);
        $query1   = $anggota['id_anggota'];
        $ska     = $this->SKAModel->getAnggota($query1);

if ($ska == null) {
            $skahasil = 'Belum ada SKA';
        } else {
            $skahasil = $ska['noreg_ska'];
        }

$data       = [
            'title'         => 'Ubah Anggota',
            'agama'         => $this->AgamaModel->findAll(),
            'pendidikan'    => $this->PendidikanModel->findAll(),
            'tingkat'       => $this->TingkatModel->findAll(),
            'validation'    => \Config\Services::validation(),
            'anggota'       => $this->AnggotaModel->getData($id),
            'ska'           => $skahasil
        ];

return view('admin/page/Anggota/edit', $data);
    }

public function update_anggota($id)
    {
        // cek judul diganti atau tidak
        $id_lama = $this->AnggotaModel->getData($this->request->getVar('id'));
        if ($id_lama['id_anggota'] == $this->request->getVar('id_anggota')) {
            $rules = 'required';
        } else {
            $rules = 'required|is_unique[anggota.id_anggota]';
        }

// cek NIK diganti atau tidak
        $ktp_lama = $this->AnggotaModel->getData($this->request->getVar('id'));
        if ($ktp_lama['noktp'] == $this->request->getVar('noktp')) {
            $rulesktp = 'required';
        } else {
            $rulesktp = 'required|is_unique[anggota.noktp]';
        }

$npwp_lama = $this->AnggotaModel->getData($this->request->getVar('id'));
        if ($npwp_lama['npwp'] == $this->request->getVar('npwp')) {
            $rulesnpwp = 'required';
        } else {
            $rulesnpwp = 'required|is_unique[anggota.npwp]';
        }

$email_lama = $this->AnggotaModel->getData($this->request->getVar('id'));
        if ($email_lama['email'] == $this->request->getVar('email')) {
            $rulesemail = 'required|valid_email';
        } else {
            $rulesemail = 'required|valid_email';
        }

$telp_lama = $this->AnggotaModel->getData($this->request->getVar('id'));
        if ($telp_lama['notelp'] == $this->request->getVar('notelp')) {
            $rulestelp = 'required';
        } else {
            $rulestelp = 'required|is_unique[anggota.email]';
        }

if (!$this->validate([
            'id_anggota' => [
                'rules' => $rules,
                'errors' => [
                    'required' => 'ID Anggota harus diisi',
                    'is_unique' => 'ID Anggota sudah terdaftar'
                ]
            ],

'nama' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Nama Anggota harus diisi',
                ]
            ],

'agama' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Agama Anggota harus diisi',
                ]
            ],

'pendidikan' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Pendidikan Anggota harus diisi',
                ]
            ],

'tempatlahir' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Tempat Lahir harus diisi',
                ]
            ],

'tgllahir' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Tanggal Lahir harus diisi',
                ]
            ],

'noktp' => [
                'rules' => $rulesktp,
                'errors' => [
                    'required' => 'NIK Anggota harus diisi',
                    'is_unique' => 'NIK Anggota sudah terdaftar'
                ]
            ],

'npwp' => [
                'rules' => $rulesnpwp,
                'errors' => [
                    'required' => 'NPWP Anggota harus diisi',
                    'is_unique' => 'NPWP Anggota sudah terdaftar'
                ]
            ],

'pekerjaan' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Pekerjaan harus diisi',
                ]
            ],

'email' => [
                'rules' => $rulesemail,
                'errors' => [
                    'required' => 'e-Mail Anggota harus diisi',
                    'valid_email' => 'Masukan Email dengan benar contoh : example@example.com'
                ]
            ],

'notelp' => [
                'rules' => $rulestelp,
                'errors' => [
                    'required' => 'No Telepon harus diisi',
                    'is_unique' => 'No Telepon sudah terdaftar'
                ]
            ],

'tingkat' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Tingkat harus diisi',
                ]
            ],

])) {
            // $validation = \Config\Services::validation();
            return redirect()->to(base_url() . '/Anggota/EditAnggota/' . $this->request->getVar('id'))->withInput();
            // dd($this->request->getVar());
        }

$status = $this->request->getVar('status');

$this->AnggotaModel->save([
            'id' => $id,
            'id_anggota' => $this->request->getVar('id_anggota'),
            'nama' => $this->request->getVar('nama'),
            'tempatlahir' => $this->request->getVar('tempatlahir'),
            'tgllahir' => $this->request->getVar('tgllahir'),
            'noktp' => $this->request->getVar('noktp'),
            'npwp' => $this->request->getVar('npwp'),
            'agama' => $this->request->getVar('agama'),
            'pekerjaan' => $this->request->getVar('pekerjaan'),
            'pendidikan' => $this->request->getVar('pendidikan'),
            'email' => $this->request->getVar('email'),
            'alamat' => $this->request->getVar('alamat'),
            'notelp' => $this->request->getVar('notelp'),
            'fax' => $this->request->getVar('fax'),
            'nama_perusahaan' => $this->request->getVar('nama_perusahaan'),
            'notlp_perusahaan' => $this->request->getVar('notlp_perusahaan'),
            'fax_perusahaan' => $this->request->getVar('fax_perusahaan'),
            'alamat_perusahaan' => $this->request->getVar('alamat_perusahaan'),
            'status' => $status,
            'tingkat' => $this->request->getVar('tingkat'),
            'tgl_terdaftar' => $this->request->getVar('tgl_terdaftar'),
            'tgl_pemutihan' => $this->request->getVar('tgl_pemutihan'),
            'masa_iuran' => $this->request->getVar('masa_iuran'),
            'keterangan' => $this->request->getVar('keterangan'),

]);

session()->setFlashdata('pesan', 'Berhasil Diubah.');

return redirect()->to(base_url() . '/Manage/Anggota');
    }

public function delete_anggota($id)
    {
        //cari id gambar
        $anggota = $this->AnggotaModel->find($id);

//hapus gambar
        //unlink('img-berita/' . $berita['gambar_berita']);

$this->AnggotaModel->delete($id);

return redirect()->to('/Manage/Anggota');
    }

public function index_ska()
    {
        $AnggotaModel         = $this->AnggotaModel->where('noreg_ska is not NULL', NULL, FALSE)->FindAll();

$data       = [
            'title'     => 'SKA',
            'row'    => $AnggotaModel
        ];

return view('admin/page/ska/index', $data);
    }

public function get_anggota()
    {
        $kode = $this->input->post('kode');
        $data = $this->AnggotaModel->getAnggota($kode);
        echo json_encode($data);
    }

public function add_ska()
    {
        $data       = [
            'title'     => ' Tambah SKA',
            'anggota'    => $this->AnggotaModel->FindAll(),
            'validation' => \Config\Services::validation()
        ];

return view('admin/page/ska/input', $data);
    }

public function save_ska()
    {

if (!$this->validate([
            'noreg_ska' => [
                'rules' => 'required|is_unique[ska.noreg_ska]',
                'errors' => [
                    'required' => 'No Registrasi harus diisi',
                    'is_unique' => 'No Registrasi sudah terdaftar'
                ]
            ],

'tgl_terbit' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Tanggal terbit harus diisi',
                ]
            ],

'masa_berlaku' => [
                'rules' => 'required',
                'errors' => [
                    'required' => 'Masa berlaku harus diisi',
                ]
            ],

'lampiran' => [
                'rules' => 'uploaded[lampiran]|max_size[lampiran,1048]|mime_in[lampiran,application/pdf]',
                'errors' => [
                    'uploaded'    => 'Pilih file terlebih dahulu !',
                    'max_size'    => 'Ukuran gambar terlalu besar max 1mb',
                    'mime_in'    => 'Format yang dibolehkan PDF'
                ]
            ]
        ])) {
            // $validation = \Config\Services::validation();
            return redirect()->to(base_url() . '/Manage/AddSKA')->withInput();
        }

$id_cari = $this->request->getVar('id_anggota');
        $anggota = $this->AnggotaModel->getAnggota($id_cari);
        $nama_anggota = $anggota['nama'];

//ambil gambar
        $filelampiran = $this->request->getFile('lampiran');
        //Jika tidak ada gambar diupload
        //genarate nama gambar
        $namalampiran = $filelampiran->getRandomName();
        //pindahkan gambar
        $filelampiran->move('/public/lampiran-ska', $namalampiran);

$this->SKAModel = new SKAModel();

$this->SKAModel->save([
            'noreg_ska' => $this->request->getVar('noreg_ska'),
            'tgl_terbit' => $this->request->getVar('tgl_terbit'),
            'masa_berlaku' => $this->request->getVar('masa_berlaku'),
            'id_anggota' => $this->request->getVar('id_anggota'),
            'nama_anggota' => $nama_anggota,
            'lampiran' => $namalampiran,
        ]);

// dd($nama_anggota);

session()->setFlashdata('pesan', 'SKA Berhasil Ditambahkan.');

return redirect()->to(base_url() . 'Manage/AddSKA');
    }

public function index_biaya()
    {
        $Alur         = $this->BiayaModel->findAll();

$data       = [
            'title'     => 'Biaya Registrasi',
            'alur'      => $Alur
        ];

return view('admin/page/Alur/index', $data);
    }

}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: sF6p.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation