<?php
class Admin_model extends CI_Model {

        var $gallery_path;
        var $gallery_path_url;

   function __construct ()
    {
        parent::__construct();

        $this->gallery_path = realpath(APPPATH . '../upload');
        $this->gallery_path_url = base_url().'upload/';
    }

   function menu()
   {
        return $this->db->get('sub_menu');
   }

   function show_sub($click)
   {
        $menu   = $this->db->where('click',$click);
        $menu   = $this->db->get('sub_menu');
        return  $menu;
   }

   function cek_user ($username,$password)
   {
        $pass   = md5($password);
        $cek    = $this->db->where('username',$username);
        $cek    = $this->db->where('password',$pass);
        $cek    = $this->db->get('admin');
        return $cek;
   }

   function edit_submenu($judul, $isi, $linknya, $id)
   {
        $data = array(
                'click' => $linknya,
                'nama_menu' => $judul,
                'isi_menu' => $isi
          );

        $this->db->where('id_menu', $id);
        $this->db->update('sub_menu', $data);
    }

   function sh_karir()
   {
        return $this->db->get('karir');
   }

   function sh_kontak()
   {
        return $this->db->get('kontak');
   }

   function sh_pesan()
   {
        $pesan = $this->db->order_by('status','desc');
        $pesan = $this->db->get('pesan');
        return $pesan;
   }

   function det_pesan($id_pesan)
   {
        $show       = $this->db->where('id_pesan',$id_pesan);
        $show       = $this->db->get('pesan');
        return $show;
   }

   function notif_pesan ()
   {
        $not        = $this->db->where('status','unread');
        $not        = $this->db->get('pesan');
        return $not;
   }

   function del_pesan($id_pesan)
   {
        $this->db->where('id_pesan',$id_pesan);
        $this->db->delete('pesan');
   }

   function e_karir($link_karir)
   {
        $this->db->where('link_karir', $link_karir);
        return $this->db->get('karir');
   }

    function del_karir($link_karir)
   {
        $this->db->where('link_karir', $link_karir);
        return $this->db->delete('karir');
   }



    function update_karir($id_karir, $title_karir, $isi_karir,$linknya)
    {
       $data = array(
       'lowongan'   => $title_karir,
       'deskripsi'  => $isi_karir,
       'link_karir' => $linknya,
        );
        $this->db->where('id_karir', $id_karir);
        $this->db->update('karir',$data);
    }


    function input_karir($title_karir,$isi_karir,$linknya)
    {
       $data = array(
       'id_karir' => '' ,
       'lowongan' => $title_karir ,
       'deskripsi' => $isi_karir,
       'link_karir' => $linknya,
        );
        $this->db->insert('karir', $data);
    }

    function upload_images($pilih) {

        $config = array(
            'allowed_types' => 'jpg|jpeg|gif|png',
            'upload_path'   => $this->gallery_path,
            'max_size'      => 2000,

        );

        $this->load->library('upload', $config);
        $this->upload->do_upload();
        $image_data = $this->upload->data();
        $namafile = $image_data ['file_name'];

        if ($namafile =="")
        {

        }else{

        $this->db->query("INSERT INTO images VALUES ('','$namafile','$namafile','$pilih')");

        }

        $config = array(
            'source_image' => $image_data['full_path'],
            'new_image' => $this->gallery_path . '/thumbs',
            'maintain_ration' => true,
            'width' => 150,
            'height' => 100
        );

        $this->load->library('image_lib', $config);
        $this->image_lib->resize();

    }

    function sh_image()

    {
    return $this->db->get('images');

    }

    function del_images($images)
    {
    $f  = $this->db->where('images',$images);
    $f  = $this->db->delete('images');
    $ImagePathAndName = "upload/".$images;
    $ImagePathAndName2 = "upload/thumbs/".$images;
    unlink($ImagePathAndName);
    unlink($ImagePathAndName2);

    return $f;

    }

    function sh_image_short($pilihan)

    {
    $r  = $this->db->where('jenis',$pilihan);
    $r  = $this->db->get('images');
    return $r;
    }

    function sh_proyek()
    {
    return $this->db->get('proyek');

    }

   function det_proyek($link_proyek)
   {
        $show       = $this->db->where('link_proyek',$link_proyek);
        $show       = $this->db->get('proyek');
        return $show;
   }

    function del_proyek($link_proyek)
   {
        $this->db->where('link_proyek', $link_proyek);
        return $this->db->delete('proyek');
   }

    function sh_artikel()
    {
    return $this->db->get('artikel');

    }

   function det_artikel($link)
   {
        $show       = $this->db->where('link',$link);
        $show       = $this->db->get('artikel');
        return $show;
   }

    function update_artikel($id_artikel,$linknya,$judul,$isi_artikel)
    {
       $data = array(
       'link'   => $linknya,
       'judul'  => $judul,
       'isi_artikel' => $isi_artikel,
        );
        $this->db->where('id_artikel', $id_artikel);
        $this->db->update('artikel',$data);
    }

   function del_artikel($link)
   {
        $this->db->where('link',$link);
        $this->db->delete('artikel');
   }

    function input_artikel($linknya,$judul,$isi_artikel)
    {
       $data = array(
       'id_artikel' => '' ,
       'link' => $linknya ,
       'judul' => $judul,
       'isi_artikel' => $isi_artikel,
        );
        $this->db->insert('artikel', $data);
    }

    function sh_berita()
    {
    return $this->db->get('berita');

    }

   function det_berita($link)
   {
        $show       = $this->db->where('link',$link);
        $show       = $this->db->get('berita');
        return $show;
   }

    function update_berita($id_berita,$linknya,$judul,$isi_berita)
    {
       $data = array(
       'link'   => $linknya,
       'judul_berita'  => $judul,
       'isi_berita' => $isi_berita,
        );
        $this->db->where('id_berita', $id_berita);
        $this->db->update('berita',$data);
    }

   function del_berita($link)
   {
        $this->db->where('link',$link);
        $this->db->delete('berita');
   }

    function input_berita($linknya,$judul_berita,$isi_berita)
    {
       $data = array(
       'id_berita' => '',
       'link' => $linknya,
       'judul_berita' => $judul_berita,
       'isi_berita' => $isi_berita,
        );
        $this->db->insert('berita', $data);
    }



}


?>