prefensi.php

<?php
//General Controller
include "General_Controller.php";
$gen_controller  = new General_Controller();

//Model Global
include "model/General_Model.php";
$gen_model      = new General_Model();

//Model User
include "model/user.php";
$md_user      = new user();


//Check Session
session_start();
if(empty($_SESSION['username'])){
  $gen_controller->redirect('');
}

$act="";
if(isset($_GET['do_act'])){
    $act = $_GET['do_act'];
}

$id_parameter="";
if(isset($_GET['id_parameter'])){
        $id_parameter =$_GET['id_parameter'];
}

if($act=="" or $act==null) {
  //View
  include "view/header.php";
  include "view/menu.php";
  include "view/prefensi.php";
  include "view/footer.php";
}
else if($act=="do_add"){
  if(!empty($_SESSION['user_id'])){
    //Proses
    $insert_data = array();
    $insert_data['id_kategori_barang']    = "kgb_".date("ymdhis")."_".rand(10000,99999);
    $insert_data['nama_kategori']         = $_POST['kategori_barang'];
    $insert_data['created_date']          = $date_now_indo_full;
    $insert_data['last_update']           = $date_now_indo_full;
    $insert_data['created_by']            = $_SESSION['user_id'];
    $insert_data['last_update_by']        = $_SESSION['user_id'];

    if($insert_data['nama_kategori']!=""){
        echo $gen_model->Insert('ms_kategori_barang',$insert_data);
    }
    else {
        echo 'Terjadi kesalahan';
    }
  }
  else {
    echo 'NOT_LOGIN';
  }
}

else if($act=="edit" and $id_parameter!=""){
    $edit = $gen_model->GetOneRow('ms_kategori_barang',array('id_kategori_barang'=>$gen_controller->decrypt($id_parameter)));
    foreach($edit as $key=>$val){
                  $key=strtolower($key);
                  $$key=$val;
    }
    $data = array('id_kategori_barang'=>$gen_controller->encrypt($id_kategori_barang),'nama_kategori'=>$nama_kategori);
    echo json_encode($data);
}
else if($act=="do_update"){
  if(!empty($_SESSION['user_id'])){

        //Foto
        $foto_asal = $_FILES['logo']['name'];
        $foto_asal_favicon = $_FILES['favicon']['name'];
        if($foto_asal!=""){
          $tmp       = $_FILES["logo"]["tmp_name"];
          $foto_name = "logo.png";
          $path      = "assets/img/";
        }
        if($foto_asal_favicon!=""){
          $tmp_fav       = $_FILES["favicon"]["tmp_name"];
          $foto_name_fav = "favicon.png";
          $path          = "assets/img/";
        }

        //Proses
        $update_data = array();
        $update_data['judul_web']      = $_POST['judul_web'];
        $update_data['alamat']         = $_POST['alamat'];
        $update_data['telepon']        = $_POST['telepon'];
        $update_data['handphone']      = $_POST['handphone'];
        $update_data['fax']            = $_POST['fax'];
        $update_data['last_update']    = $date_now_indo_full;
        $update_data['last_update_by'] = $_SESSION['user_id'];
        if($foto_asal!=""){
          $update_data['logo']       = $foto_name;
        }
        if ($foto_asal_favicon!=""){
          $update_data['favicon'] = $foto_name_fav;
        }


        if($update_data['judul_web']!=""){
          // Hapus Foto
          if($foto_asal!=""){
            $old_foto = $gen_model->GetOne('logo','web');
            $gen_controller->delete_file($path,$old_foto);
          }
          if($gen_model->Update('web',$update_data)=="OK"){
            if($foto_asal!=""){
              $gen_controller->upload_file($tmp,$path,$foto_name);
            }
            if($foto_asal_favicon!=""){
             $gen_controller->upload_file($tmp_fav,$path,$foto_name_fav);
            }

              echo "OK";

          }
        }
        else {
          echo 'Terjadi kesalahan';
        }
  }
  else {
    echo 'NOT_LOGIN';
  }
}
else if($act=="do_delete"){
  if(!empty($_SESSION['user_id'])){
    //Paramater
    $where_data = array();
    $where_data['id_kategori_barang']  = $gen_controller->decrypt($_POST['id_parameter']);
    echo $gen_model->Delete('ms_kategori_barang',$where_data);
  }
  else {
    echo 'NOT_LOGIN';
  }
}
else if($act=="list_rest"){
  $aColumns = array('kg.nama_kategori','kg.created_date','us_crt.username','kg.last_update','us_updt.username','kg.id_kategori_barang'); //Kolom Pada Tabel

    // Input method (use $_GET, $_POST or $_REQUEST)
  $input =& $_POST;
  $iColumnCount = count($aColumns);


  $sLimit = $gen_controller->Paging($input);
  $sOrder = $gen_controller->Ordering($input, $aColumns );
  $sWhere = $gen_controller->Filtering($aColumns, $iColumnCount, $input);

  $aQueryColumns = array();
  foreach ($aColumns as $col) {
    if ($col != ' ') {
      $aQueryColumns[] = $col;
    }
  }

  $rResult        = $md_kategori_barang->getDataKategoriBarang($sWhere,$sOrder,$sLimit);
  $rResultFilterTotal   = $md_kategori_barang->getCountKategoriBarang($sWhere);


  $output = array(
    "sEcho"                => (empty($input['sEcho']) ? '0' : intval($input['sEcho'])),
    "iTotalRecords"        => $rResultFilterTotal,
    "iTotalDisplayRecords" => $rResultFilterTotal,
    "aaData"               => array(),
  );

  while($aRow = $rResult->FetchRow()){

    $param_id = $gen_controller->encrypt($aRow['id_kategori_barang']);
    $edit = '<button  data-toggle="modal" data-target="#edit_modal" type="button" onclick="do_edit(\''.$param_id.'\')" class="btn btn-primary btn-xs"><i class="fa fa-pencil m-r-5"></i> Update</button>';
    $delete = '&nbsp; <button type="button" onclick="do_delete(\''.$param_id.'\')" class="btn btn-danger btn-xs"><i class="fa fa-trash-o m-r-5"></i> Delete</button>';

    $edit_delete = $edit.$delete;
    $row = array();
    $row = array($aRow['nama_kategori'],$gen_controller->get_date_indonesia($aRow['created_date'])." ".substr($aRow['created_date'],10,9),$aRow['pembuat'],$gen_controller->get_date_indonesia($aRow['last_update'])." ".substr($aRow['last_update'],10,9),$aRow['perubah'],"<center>".$edit_delete."</center>");
    $output['aaData'][] = $row;
  }
  echo json_encode($output);
}
else {
  $gen_controller->response_code(http_response_code());
}
?>