Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INPUT BASE ARRAY
- (1) Halaman index :
- <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); ?>
- <div class="row">
- <div class="col-md-12 col-sm-12 col-xs-12">
- <div class="x-panel">
- <div class="x_title">
- <h2><?php echo $title?></h2>
- <div class="item form-group pull-right">
- <button type="button" id="btn-delete" class="btn btn-danger pull-right">
- <span class="glyphicon glyphicon-erase"></span>Delete
- </button>
- <button type="button" id="btn-tambah" class="btn btn-success pull-right">
- <span class="glyphicon glyphicon-plus"></span>Tambah
- </button>
- <button type="button" id="btn-browse" class="btn btn-default pull-right">
- <span class="glyphicon glyphicon-search"></span>Browse
- </button>
- <div id="itemasset" class="pull-right">
- <?php echo form_dropdown("nm_item",array('Pilih Item Asset'=>'Pilih Kategori Asset Dahulu'),"",'class ="form-control" id="item_id" disabled')?>
- </div>
- <div id="ktgrasset" class="pull-right">
- <?php echo form_dropdown("nm_ktgr_assets",$ktgr_asset,"",'class ="form-control" id="ktgr_assets_id" onChange="tampil_itemasset()"');?>
- </div>
- </div>
- <div class="clearfix"></div>
- </div>
- <div class="x_content">
- <div id="view">
- <table id="asset_sewa" class="display" width="100%" cellspacing="0">
- <thead>
- <tr class="headings">
- <th>
- <div>
- <input type="checkbox" id="check-all">
- </div>
- </th>
- <th>No</th>
- <th>Bulan/Tahun Perolehan</th>
- <th>Item Asset</th>
- <th>Kategori Asset</th>
- <th>Start Sewa</th>
- <th>End Sewa</th>
- <th>Pemilik</th>
- <th>Foto</th>
- <th>AtCost</th>
- <th>Status Approval</th>
- <th colspan = "2" class="text-center"><span class="glyphicon glyphicon-cog"></span></th>
- </tr>
- </thead>
- <tbody>
- <?php
- if ($data_awal->num_rows() > 0)
- {
- $i=1;
- foreach($data_awal->result_array() as $keys=>$key)
- {
- if ($i%2 == 0)
- $class = "odd pointer";
- else $class = "even pointer";
- if ($key['status_approval'] == '0')
- $status_approval = 'PENDING';
- else $status_approval = 'VALID';
- ?>
- <tr class="<?php echo $class?>">
- <td><div><input type="checkbox" class="data-check" value="<?php print $key['id_asset']?>"></div></td>
- <td class="align-middle"><?php print $key['id_asset']?></td>
- <td class="align-middle"><?php print $this->auth->formatTanggal($key['bln_thn_perolehan']);?></td>
- <td class="align-middle"><?php print $key['item']?></td>
- <td class="align-middle"><?php print $key['ktgr_assets']?></td>
- <td class="align-middle"><?php print $this->auth->formatTanggal($key['start_sewa'])?></td>
- <td class="align-middle"><?php print $this->auth->formatTanggal($key['end_sewa'])?></td>
- <td class="align-middle"><?php print $key['pemilik']?></td>
- <td class="align-middle">
- <?php
- if (!is_null($key['foto']))
- {
- $image_properties = array(
- 'src' => base_url($key['foto']),
- 'height' => '60',
- 'width' => '60',
- 'rel' => 'lightbox',
- );
- print img($image_properties);
- }
- else print '';
- ?>
- </td>
- <td class="align-middle"><?php print $this->auth->buatRp($key['at_cost'])?></td>
- <td class="align-middle"><?php print $status_approval?></td>
- <td class="align-middle text-center">
- <a href="javascript:void();" onclick="edit(<?php echo $key['id_asset']; ?>);" class="btn btn-default" title="Edit"><span class="glyphicon glyphicon-pencil"></span></a>
- </td>
- </tr>
- <?php
- $i++;
- }
- }
- ?>
- </tbody>
- </table>
- </div>
- </div>
- </div>
- </div>
- </div>
- <script>
- var table;
- var getIDAsset;
- var save_method;
- function edit(id)
- {
- $.ajax({
- url : "<?php echo site_url('asset_sewa/ajax_edit/')?>/" + id,
- type: "GET",
- dataType: "JSON",
- success: function(response)
- {
- if (response.status == 'true')
- {
- save_method = 'update';
- $('#form-id')[0].reset(); // reset form on modals
- var blnthn = new Date(response.data.bln_thn_perolehan);
- var new_blnthn = blnthn.toString('dd-MM-yyyy');
- var startsewa = new Date(response.data.start_sewa);
- var new_startsewa = startsewa.toString('dd-MM-yyyy');
- var endsewa = new Date(response.data.end_sewa);
- var new_endsewa = endsewa.toString('dd-MM-yyyy');
- $('[name="id_asset_edit"]').val(response.data.id_asset);
- $('[name="bln_thn_perolehan_edit"]').val(new_blnthn);
- $('#bln_thn_perolehan_edit').attr('readonly','readonly');
- $('[name="asset_edit"]').val(response.data.item);
- $('#asset_edit').attr('readonly','readonly');
- $('[name="kategori_asset_edit"]').val(response.data.ktgr_assets);
- $('#kategori_asset_edit').attr('readonly','readonly');
- $('[name="start_sewa_edit"]').val(new_startsewa);
- $('[name="end_sewa_edit"]').val(new_endsewa);
- $('[name="pemilik_edit"]').val(response.data.pemilik);
- $('[name="at_cost_edit"]').val(formatRupiah(response.data.at_cost));
- if (response.data.status_approval == 0)
- status = "PENDING";
- else status = "VALID";
- $('[name="status_approval_edit"]').val(status);
- $("#form-add").hide();
- $("#form-edit").show();
- $('#modal-id').modal('show'); // show bootstrap modal when complete loaded
- $('.modal-title').text('Edit Item Asset'); // Set title to Bootstrap modal title
- }
- else
- {
- alert(response.pesan);
- location.href = location.pathname;
- }
- },
- error: function (jqXHR, textStatus, errorThrown)
- {
- alert(jqXHR.responseText);
- }
- });
- }
- function formatRupiah(angka, prefix)
- {
- var number_string = angka.replace(/[^,\d]/g, '').toString(),
- split = number_string.split(','),
- sisa = split[0].length % 3,
- rupiah = split[0].substr(0, sisa),
- ribuan = split[0].substr(sisa).match(/\d{3}/gi);
- if (ribuan) {
- separator = sisa ? '.' : '';
- rupiah += separator + ribuan.join('.');
- }
- rupiah = split[1] != undefined ? rupiah + ',' + split[1] : rupiah;
- return prefix == undefined ? rupiah : (rupiah ? 'Rp. ' + rupiah : '');
- }
- function tampil_itemasset(){
- var selectValues = $("#ktgr_assets_id").val();
- if (selectValues == 0){
- var msg = "<br><select name=\"nm_item\" disabled><option value=\"Pilih Item Asset\">Pilih Kategori Asset Dahulu</option></select>";
- $('#itemasset').html(msg);
- }else{
- var ktgr_assets_id = {ktgr_assets_id:$("#ktgr_assets_id").val()};
- $('#item_id').attr("disabled",true);
- $.ajax({
- type: "POST",
- url : "<?php echo site_url('asset_sewa/select_itemasset')?>",
- data: ktgr_assets_id,
- success: function(msg){
- $('#itemasset').html(msg);
- }
- });
- }
- return false;
- };
- function tampil_itemasset1(){
- var selectValues = $("#id_ktgr_assets").val();
- if (selectValues == 0){
- var msg = "<br><select name=\"id_item\" disabled><option value=\"Pilih Item Asset\">Pilih Kategori Asset Dahulu</option></select>";
- $('#item_asset').html(msg);
- }else{
- var id_ktgr_assets = {id_ktgr_assets:$("#id_ktgr_assets").val()};
- $('#id_item').attr("disabled",true);
- $.ajax({
- type: "POST",
- url : "<?php echo site_url('asset_sewa/select_itemasset')?>",
- data: id_ktgr_assets,
- success: function(msg){
- $('#item_asset').html(msg);
- }
- });
- }
- return false;
- };
- $(document).ready(function(){
- var daysToAdd = 4;
- var addBtn = $('#btn-tambah');
- var addButton = $('#btn_add');
- var btnsave = $('#btnSave');
- var btnDelete = $('#btn-delete');
- var btnStart = $('#btn-start');
- var btnBrowse = $('#btn-browse');
- var getIDAsbb;
- var maxField;
- var valid_1;
- var valid_2;
- var oTable = $('#asset_sewa').dataTable({
- "aoColumnDefs": [
- {
- "orderable": true,
- 'bSortable': false,
- 'aTargets': [0]
- } //disables sorting for column one
- ],
- 'iDisplayLength': 10,
- "sPaginationType": "full_numbers"
- });
- $("#check-all").click(function () {
- $(".data-check").prop('checked', $(this).prop('checked'));
- });
- var tanpa_rupiah = document.getElementById('at_cost');
- tanpa_rupiah.addEventListener('keyup', function(e)
- {
- tanpa_rupiah.value = formatRupiah(this.value);
- });
- var tanpa_rupiah_1 = document.getElementById('at_cost_edit');
- tanpa_rupiah_1.addEventListener('keyup', function(e)
- {
- tanpa_rupiah_1.value = formatRupiah(this.value);
- });
- $("#txtFromDate, #start_sewa_edit").datepicker({
- onSelect: function (selected) {
- var dtMax = new Date(selected);
- dtMax.setDate(dtMax.getDate() + daysToAdd);
- var dd = dtMax.getDate();
- var mm = dtMax.getMonth() + 1;
- var y = dtMax.getFullYear();
- var dtFormatted = mm + '/'+ dd + '/'+ y;
- $("#txtToDate").datepicker("option", "minDate", dtFormatted);
- },
- dateFormat: 'dd-mm-yy'
- });
- $("#txtToDate, #end_sewa_edit").datepicker({
- onSelect: function (selected) {
- var dtMax = new Date(selected);
- dtMax.setDate(dtMax.getDate() - daysToAdd);
- var dd = dtMax.getDate();
- var mm = dtMax.getMonth() + 1;
- var y = dtMax.getFullYear();
- var dtFormatted= mm + '/'+ dd + '/'+ y;
- $("#txtFromDate").datepicker("option", "maxDate", dtFormatted)
- },
- dateFormat: 'dd-mm-yy'
- });
- $("#bln_thn_peroleh").datepicker({dateFormat: 'dd-mm-yy'});
- $("#izin_thn_asbb").datepicker({dateFormat: 'dd-mm-yy'});
- $(addBtn).on('click', function(e){
- $(btnSave).attr('disabled',true);
- save_method = 'add';
- $('#form-id')[0].reset(); // reset form on modals
- $('#modal-id').modal('show');
- $('#modal-id').fullscreen();
- $("#form-add").show();
- $("#form-edit").hide();
- $("#asbtb").hide();
- $("#asbb").hide();
- $("#astb").hide();
- $('.modal-title').text('Tambah Data');
- //alert('tambah');
- });
- $(addButton).on('click', function(e){
- if ($("#id_ktgr_assets").val() != 0)
- {
- if ($("#id_item").val() != 0)
- {
- if ($.trim($("#txtFromDate").val()).length > 0)
- {
- if ($.trim($("#txtToDate").val()).length > 0)
- {
- if ($.trim($("#bln_thn_peroleh").val()).length > 0)
- {
- if ($.trim($("#at_cost").val()).length > 0)
- {
- if (($("#jml_data").val() >= 1) && ($("#jml_data").val() <= 100))
- {
- if (confirm('Data sudah benar ?'))
- {
- $("#id_ktgr_assets").attr("disabled",true);
- $("#id_item").attr("disabled",true);
- $("#txtFromDate").attr("readonly",true);
- $("#txtToDate").attr("readonly",true);
- $("#pemilik").attr("readonly",true);
- $("#bln_thn_peroleh").attr("readonly",true);
- $("#at_cost").attr("readonly",true);
- $("#jml_data").attr("readonly",true);
- $(addButton).attr("disabled",true);
- getIDAsset = $("#id_ktgr_assets").val();
- maxField = $("#jml_data").val();
- if (getIDAsset == '3')
- {
- $(btnSave).attr('disabled',false);
- $("#asbtb").show();
- $("#asbb").hide();
- $("#astb").hide();
- var wrapper = $('.field_wrapper_asbtb'); //Input field wrapper
- for(i=1; i<=maxField; i++)
- {
- $(wrapper).append(
- '<div class="item form-group">'+
- '<label class="control-label col-md-3">Data['+i+']</label>'+
- '<div class="col-md-2"><input type="text" class="form-control" name="Id[]" placeholder = "IDAsset" id="id'+i+'"/></div>'+
- '<div class="col-md-2"><input type="text" class="form-control" placeholder = "Luas" name="luas[]" id="luas'+i+'"/></div>'+
- '<div class="col-md-2"><input type="text" class="form-control" placeholder = "Jenis" name="jenis[]" id="jenis'+i+'"/></div>'+
- '<div class="col-md-3"><input type="file" name="input01[]" id="input01'+i+'"/></div>'+
- '</div>'
- );
- }
- $("#child-form-asbtb").show();
- }
- }
- }
- else alert('Jumlah data minimal 1, maximal 100');
- }
- else alert('Harap tentukan at_cost');
- }
- else alert('Harap tentukan bln-tahun perolehan');
- }
- else alert('Harap tentukan batas awal sewa');
- }
- else alert('Harap tentukan batas awal sewa');
- }
- else alert('Harap tentukan Item Asset');
- }
- else alert('Harap tentukan Kategori Asset');
- });
- $(btnsave).on('click', function(e){
- var data = new FormData();
- var simpan = 0;
- if (save_method == 'add')
- {
- url = "<?php echo site_url('asset_sewa/tambah')?>";
- data.append('id_ktgr_assets', $("#id_ktgr_assets").val());
- data.append('id_item', $("#id_item").val());
- data.append('txtFromDate', $("#txtFromDate").val());
- data.append('txtToDate', $("#txtToDate").val());
- data.append('pemilik', $("#pemilik").val());
- data.append('bln_thn_peroleh', $("#bln_thn_peroleh").val());
- data.append('jml_data', $("#jml_data").val());
- data.append('at_cost', $("#at_cost").val());
- if (getIDAsset == '3')
- {
- if ($.trim($("#deskripsi_asbtb").val()).length > 0)
- {
- if ($.trim($("#alamat_asbtb").val()).length > 0)
- {
- if ($("#id_lokasi").val() > 0)
- {
- for (i=1; i<=maxField; i++)
- {
- if ($.trim($("#id"+i).val()).length > 0)
- {
- if ($.trim($("#luas"+i).val()).length > 0)
- {
- if ($.trim($("#jenis"+i).val()).length > 0)
- {
- if($("#input01"+i)[0].files[0].length > 0)
- {
- data.append('Id[]', $("#id"+i).val()+';'+$("#luas"+i).val()+';'+$("#jenis"+i).val()+';'+$("#input01"+i)[0].files[0]);
- }
- else
- {
- data.append('Id[]', $("#id"+i).val()+';'+$("#luas"+i).val()+';'+$("#jenis"+i).val());
- }
- }
- }
- }
- }
- data.append('alamat_asbtb', $("#alamat_asbtb").val());
- data.append('id_lokasi', $("#id_lokasi").val());
- data.append('deskripsi_asbtb', $("#deskripsi_asbtb").val());
- simpan = 1;
- }
- else alert('Harap tentukan lokasi asset');
- }
- else alert('Harap tentukan alamat');
- }
- else alert('Harap tentukan deskripsi/judul');
- }
- }
- if (simpan == 1)
- {
- $.ajax({
- url : url,
- type: "POST",
- data: data,
- enctype: 'multipart/form-data',
- processData: false,
- contentType: false,
- dataType: "json",
- beforeSend: function(e) {
- if(e && e.overrideMimeType) {
- e.overrideMimeType("application/json;charset=UTF-8");
- }
- },
- success: function(respon){
- $('#modal-id').on('hidden.bs.modal', function (e) {
- $(this)
- .find("input,select")
- .val('')
- .end()
- })
- if(respon.status == "sukses"){
- $("#view").html(respon.html);
- location.href = location.pathname;
- $("#modal-id").modal('hide');
- }else{
- alert(respon.pesan);
- location.href = location.pathname;
- }
- },
- error: function (jqXHR, textStatus, errorThrown)
- {
- alert(jqXHR.responseText);
- }
- });
- }
- });
- });
- </script>
- <!-- Bootstrap modal -->
- <div class="modal fade modal-fullscreen" id="modal-id" tabindex="-1" role="dialog">
- <div class="modal-dialog text-justify">
- <div class="modal-content">
- <div class="modal-header">
- <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
- <h3 class="modal-title"></h3>
- </div>
- <div class="modal-body form">
- <div class="x_panel">
- <div class="x_content">
- <form action="#" id="form-id" class="form-horizontal form-label-left" enctype="multipart/form-data">
- <div class="form-body">
- <div id="form-add">
- <div class="item form-group">
- <label class="control-label col-md-3">Kategori Asset</label>
- <div class="col-md-9">
- <div id="ktgr_asset"><?php echo form_dropdown("id_ktgr_assets",$ktgr_asset,"",'class ="form-control" id="id_ktgr_assets" onChange="tampil_itemasset1()"')?></div>
- </div>
- </div>
- <div class="item form-group">
- <label class="control-label col-md-3">Item Asset</label>
- <div class="col-md-9">
- <div id="item_asset"><?php echo form_dropdown("id_item",array('Pilih Item Asset'=>'Pilih Kategori Asset Dahulu'),"",'class ="form-control" id="id_item" disabled')?></div>
- </div>
- </div>
- <div class="item form-group">
- <label class="control-label col-md-3">Masa Berlaku Sewa</label>
- <div id="masa_sewa_start" class="col-md-4"><input type="text" id="txtFromDate" name="txtFromDate" class="form-control" placeholder="Start Date"/></div>
- <div id="masa_sewa_end" class="col-md-5"><input type="text" id="txtToDate" name="txtToDate" class="form-control" placeholder="End Date"/></div>
- </div>
- <div class="item form-group">
- <label class="control-label col-md-3">Pemilik</label>
- <div class="col-md-9">
- <input name="pemilik" class="form-control" type="text" id="pemilik">
- </div>
- </div>
- <div class="item form-group">
- <label class="control-label col-md-3">Bulan-Tahun Perolehan</label>
- <div class="col-md-9">
- <input name="bln_thn_peroleh" class="form-control" type="text" id="bln_thn_peroleh">
- </div>
- </div>
- <div class="item form-group">
- <label class="control-label col-md-3">At Cost</label>
- <div class="col-md-9">
- <input name="at_cost" class="form-control" type="text" id="at_cost">
- </div>
- </div>
- <div class="form-group" id="add_data">
- <label class="col-sm-3 control-label">Jumlah Data</label>
- <div class="col-sm-9">
- <div class="input-group">
- <input type="number" class="form-control" id="jml_data" min="1" max="100">
- <span class="input-group-btn">
- <button type="button" class="btn btn-primary" id="btn_add">Add Data</button>
- </span>
- </div>
- </div>
- </div>
- <div id="asbtb">
- <div class="item form-group">
- <label class="control-label col-md-3">Deskripsi</label>
- <div class="col-md-9">
- <input name="deskripsi_asbtb" class="form-control" type="text" id="deskripsi_asbtb">
- </div>
- </div>
- <div class="item form-group">
- <label class="control-label col-md-3">Lokasi</label>
- <div class="col-md-9">
- <div id="lokasi_asbtb"><?php echo form_dropdown("id_lokasi",$lokasi,"",'class ="form-control" id="id_lokasi"')?></div>
- </div>
- </div>
- <div class="item form-group">
- <label class="control-label col-md-3">Alamat</label>
- <div class="col-md-9">
- <input name="alamat_asbtb" class="form-control" type="text" id="alamat_asbtb">
- </div>
- </div>
- <div id="child-form-asbtb">
- <div class="field_wrapper_asbtb"></div>
- </div>
- </div>
- </div>
- <div id="form-edit">
- <input type="hidden" name="id_asset_edit" id="id_asset_edit" value="">
- <div class="item form-group">
- <label class="control-label col-md-3">Kategori Asset</label>
- <div class="col-md-9">
- <input name="kategori_asset_edit" class="form-control" type="text" id="kategori_asset_edit">
- </div>
- </div>
- <div class="item form-group">
- <label class="control-label col-md-3">Item Asset</label>
- <div class="col-md-9">
- <input name="asset_edit" class="form-control" type="text" id="asset_edit">
- </div>
- </div>
- <div class="item form-group">
- <label class="control-label col-md-3">Bulan-Tahun Perolehan</label>
- <div class="col-md-9">
- <input name="bln_thn_perolehan_edit" class="form-control" type="text" id="bln_thn_perolehan_edit">
- </div>
- </div>
- <div class="item form-group">
- <label class="control-label col-md-3">Masa Berlaku Sewa</label>
- <div id="masa_sewa_start" class="col-md-4"><input type="text" id="start_sewa_edit" name="start_sewa_edit" class="form-control"/></div>
- <div id="masa_sewa_end" class="col-md-5"><input type="text" id="end_sewa_edit" name="end_sewa_edit" class="form-control"/></div>
- </div>
- <div class="item form-group">
- <label class="control-label col-md-3">Pemilik</label>
- <div class="col-md-9">
- <input name="pemilik_edit" class="form-control" type="text" id="pemilik_edit">
- </div>
- </div>
- <div class="item form-group">
- <label class="control-label col-md-3">At-Cost</label>
- <div class="col-md-9">
- <input name="at_cost_edit" class="form-control" type="text" id="at_cost_edit">
- </div>
- </div>
- </div>
- </form>
- </div></div>
- </div>
- <div class="modal-footer">
- <button type="button" id="btnSave" class="btn btn-primary">Simpan</button>
- <button type="button" class="btn btn-danger" data-dismiss="modal" id="btnCancel" >Cancel</button>
- </div>
- </div><!-- /.modal-content -->
- </div><!-- /.modal-dialog -->
- </div><!-- /.modal -->
- <!-- End Bootstrap modal -->
- (2) Halaman Logic :
- <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
- class Asset_sewa extends CI_Controller
- {
- private $table = 'tb_asset';
- private $primary = 'id_asset';
- function __construct()
- {
- parent::__construct();
- $this->load->library(array('template'));
- $user = $this->session->userdata('username');
- if ($user)
- {
- $lvl = $this->session->userdata('level');
- if($lvl != '3')
- {
- redirect('temp/index');
- }
- }
- else redirect('web');
- }
- function index()
- {
- if (!isset($_POST['milik']) && !isset($_POST['id_ktgr']) && !isset($_POST['id_item']))
- {
- $data_awal = $this->m_all->cari('2',$this->session->userdata('namauser'),'','','','milik','update_user','',$this->table);
- $data['data_awal'] = $data_awal;
- $data['title']="Data Item Asset Sewa";
- $data['ktgr_asset']=$this->m_all->getList('tb_ktgr_assets', 'id_ktgr_assets', NULL, NULL);
- $data['lokasi']=$this->m_all->getList('tb_lokasi','id_lokasi',NULL,NULL);
- $data['user_ktr_pusat']=$this->m_all->getList('user_kantor','id_user',NULL,'1');
- $data['ukuran']=$this->m_all->getList('tb_ukuran','id_ukuran',NULL, NULL);
- $this->template->display('asset_sewa/index',$data);
- }
- else
- {
- $respon = array('status'=>'sukses','url_redirect'=>site_url('data_asset_'.$_POST['id_ktgr'].'/index/'.$_POST['milik'].'/'.$_POST['id_item']));
- echo json_encode($respon);
- }
- }
- function select_itemasset()
- {
- if('IS_AJAX')
- {
- if (isset($_POST['id_ktgr_assets']) && !empty($_POST['id_ktgr_assets']))
- {
- $ktgr_asset = $_POST['id_ktgr_assets'];
- $alamat = 'asset_sewa/select_itemasset';
- }
- else if (isset($_POST['ktgr_assets_id']) && !empty($_POST['ktgr_assets_id']))
- {
- $ktgr_asset = $_POST['ktgr_assets_id'];
- $alamat = 'asset_sewa/select_itemasset1';
- }
- else
- {
- $ktgr_asset = '';
- $alamat = '';
- }
- if ($ktgr_asset != '')
- {
- $data['itemasset'] = $this->m_all->getList('tb_item_asset','id_item', '', $ktgr_asset);
- //$data['option_kota'] = $this->MChain->getKotaList();
- $this->load->view($alamat,$data);
- }
- }
- else echo 'ajax gagal';
- }
- function cek_approval()
- {
- $cek_approval = $this->m_all->cek('2','ap_level','user_aplikasi');
- if ($cek_approval->num_rows() > 0)
- $response = array('status'=>'true');
- else $response = array('status'=>'false');
- echo json_encode($response);
- }
- function tambah()
- {
- $cek_approval = $this->m_all->cek('2','ap_level','user_aplikasi');
- if ($cek_approval->num_rows() > 0)
- {
- $this->m_all->delete_all('tb_temp_asset');
- $id_ktgr_assets = $this->input->post('id_ktgr_assets');
- $id_item = $this->input->post('id_item');
- $bln_thn_peroleh = $this->input->post('bln_thn_peroleh');
- $jml_input = $this->input->post('jml_data');
- $date_awal_sewa = $this->input->post('txtFromDate');
- $date_akhir_sewa = $this->input->post('txtToDate');
- $pemilik = db_clean($this->input->post('pemilik'));
- $at_cost = db_clean($this->input->post('at_cost'));
- $month = date("m", strtotime($bln_thn_peroleh));
- $year = date("y", strtotime($bln_thn_peroleh));
- $id = $this->auth->get_jumlah($this->primary, $this->table) + 1;
- $info_asset = array(
- 'id_asset' => $id,
- 'bln_thn_perolehan' => date('Y-m-d', strtotime($bln_thn_peroleh)),
- 'asset_id' => $id_item,
- 'ktgr_asset' => $id_ktgr_assets,
- 'jml_data' => $jml_input,
- 'milik' => '2',
- 'pemilik' => $pemilik,
- 'start_sewa' => date('Y-m-d', strtotime($date_awal_sewa)),
- 'end_sewa' => date('Y-m-d', strtotime($date_akhir_sewa)),
- 'at_cost' => preg_replace("/[^a-zA-Z0-9]/", "", $at_cost)
- );
- $this->m_all->simpan($info_asset, 'tb_temp_asset');
- $cek_asset = $this->m_all->cek($id_item,'id_item','tb_item_asset');
- foreach ($cek_asset->result() as $cs)
- {
- $db_item = $cs->item;
- $db_ktgrasset = $cs->ktgr_assets;
- }
- if ($id_ktgr_assets == '3')
- {
- $id_asset = $this->input->post('Id');
- if (count($id_asset))
- {
- $deskripsi = db_clean($this->input->post('deskripsi_asbtb'));
- $alamat = db_clean($this->input->post('alamat_asbtb'));
- $lokasi = $this->input->post('id_lokasi');
- $target_foto = "data/ft_3/";
- $i=1;
- foreach ($id_asset as $keys=>$key)
- {
- $var = explode(';', $key);
- $cek = $this->m_all->cek(str_replace(' ', '', $var[0]), 'kode_jurnal', 'tb_kdasbtb');
- if ($cek->num_rows() == 0)
- {
- if (!empty($var[0]) || !is_null($var[0]))
- {
- $id_dtasset = $this->auth->get_jumlah('id_dtasset','tb_kdasset') + 1;
- $info_kdasset = array(
- 'id_dtasset' => $id_dtasset,
- 'no_dtasset' => $this->auth->create_id_asset("GLI",$month.'-'.$year,$id_item,8,$id_dtasset),
- 'kode_asset' => $id,
- 'kode_jurnal' => $var[0]
- );
- $this->m_all->simpan($info_kdasset, 'tb_kdasset');
- if (!empty($var[1]) || !is_null($var[1]))
- $luas = $var[1];
- else $luas = null;
- if (!empty($var[2]) || !is_null($var[2]))
- $jenis = $var[2];
- else $jenis = null;
- //1 MARET 2018, SEMENTARA WAKTU FOTO & SURAT DI-NULL-KAN, SEBAB BUTUH MULTI-UPLOAD
- if (isset($_FILES[$var[3]]))
- {
- $info_kdasbtb = array(
- 'kode_jurnal' => $var[0],
- 'deskripsi' => $deskripsi,
- 'alamat' => $alamat,
- 'lokasi' => $lokasi,
- 'luas' => $luas,
- 'jenis' => $jenis,
- 'foto' => '1'//$this->auth->fileupload($_FILES[$var[3]], $var[0].'_'.date("YmdHis").rand(1000,9999), $target_foto)
- );
- }
- else
- {
- $info_kdasbtb = array(
- 'kode_jurnal' => $var[0],
- 'deskripsi' => $deskripsi,
- 'alamat' => $alamat,
- 'lokasi' => $lokasi,
- 'luas' => $luas,
- 'jenis' => $jenis,
- 'foto' => '0'
- );
- }
- $this->m_all->simpan($info_kdasbtb, 'tb_kdasbtb');
- }
- $i++;
- }
- }
- $status_simpan = true;
- $data_asset = $this->m_all->get_by_id('tb_temp_asset', 'id_asset', $id);
- $info_asset_1 = array(
- 'id_asset' => $data_asset->id_asset,
- 'bln_thn_perolehan' => $data_asset->bln_thn_perolehan,
- 'asset_id' => $data_asset->asset_id,
- 'ktgr_asset' => $data_asset->ktgr_asset,
- 'jml_data' => $data_asset->jml_data,
- 'milik' => $data_asset->milik,
- 'pemilik' => $data_asset->pemilik,
- 'start_sewa' => $data_asset->start_sewa,
- 'end_sewa' => $data_asset->end_sewa,
- 'at_cost' => $data_asset->at_cost,
- 'depreciation' => '0',
- 'update_date' => date('Y-m-d H:i:s', now()),
- 'update_user' => $this->session->userdata('namauser')
- );
- $this->m_all->simpan($info_asset_1, $this->table);
- $this->m_all->hapus($id, NULL, $this->primary, NULL, 'tb_temp_asset');
- }
- else $status_simpan = false;
- }
- if ($status_simpan == true)
- {
- foreach ($cek_approval->result() as $cp)
- {
- $get_approval = $cp->ap_username;
- $message1 = '<p> Kepada Yth : '.$cp->nm_user.'</p>';
- $message1.= '<p> Lokasi : '.$cp->lokasi.'</p>';
- $message1.= '<p> Posisi : '.$cp->posisi.'</p>';
- $message1.= '<p></p>';
- $message1.= '<p> Penambahan Data Asset Sewa</p>';
- $message1.= '<p> Data Asset : </p>';
- $message1.= '<p> ID Asset : '.$id.'</p>';
- $message1.= '<p> Item Asset : '.$db_item.'</p>';
- $message1.= '<p> Kategori Asset : '.$db_ktgrasset.'</p>';
- $message1.= '<p> Sejumlah : '.$jml_input.'</p>';
- $message1.= '<p></p>';
- $message1.= '<p> Harap, agar di-validkan</p>';
- $message1.= '<p> Terima Kasih </p>';
- $message1.= '<p>'.$this->session->userdata('namauser').'</p>';
- }
- if ($this->auth->send_email($this->session->userdata('username'), $this->session->userdata('password'), $this->session->userdata('namauser'), $get_approval, 'Konfirmasi Penambahan Asset Sewa', $message1))
- $status_approval = '1';
- else $status_approval = '0';
- $konfirm_id = $this->auth->get_jumlah('konfirm_id','tb_konfirmasi') + 1;
- $info_pesan = array(
- 'konfirm_id' => $konfirm_id,
- 'konfirm_jdl' => 'Konfirmasi Penambahan Asset Sewa',
- 'konfirm_isi' => $message1,
- 'konfirm_from' => $this->session->userdata('username'),
- 'konfirm_to' => $get_approval
- );
- $this->m_all->simpan($info_pesan, 'tb_konfirmasi');
- $info_log_admin = array(
- 'id_log' => $this->auth->get_jumlah('id_log','tb_log_admin') + 1,
- 'status' => '1 ; status_kirim_approval '.$status_approval,
- 'konfirm_id' => $konfirm_id,
- 'isi_table' => $message1,
- 'from_table' => $this->table,
- 'update_user' => $this->session->userdata('username')
- );
- $this->m_all->simpan($info_log_admin, 'tb_log_admin');
- ob_start();
- $html = ob_get_contents();
- ob_end_clean();
- $respon = array('status'=>'sukses','pesan'=>'Data berhasil di-simpan', 'html'=>$html);
- }
- else $respon = array('status'=>'gagal','pesan'=>'Data gagal di-simpan');
- }
- else $respon = array('status'=>'gagal','pesan'=>'Harap lengkapi data/APPROVAL belum di-setting - ADMIN');
- echo json_encode($respon);
- }
- function ajax_edit($id)
- {
- $cek_approval = $this->m_all->cek('2','ap_level','user_aplikasi');
- if ($cek_approval->num_rows() > 0)
- {
- $data = $this->m_all->get_by_id($this->table, $this->primary, $id);
- $response = array('status'=>'true','data'=>$data);
- }
- else $response = array('status'=>'false','pesan'=>'Harap setting User_Aplikasi Level APPROVAL terlebih dahulu - ADMIN');
- echo json_encode($response);
- }
- function edit()
- {
- $cek_approval = $this->m_all->cek('2','ap_level','user_aplikasi');
- if ($cek_approval->num_rows() > 0)
- {
- $id_asset = $this->input->post('id_asset_edit');
- $at_cost = preg_replace("/[^A-Za-z0-9\-\*\&\ ]/", "", db_clean($this->input->post('at_cost_edit')));
- $start_sewa = date('Y-m-d', strtotime($this->input->post('start_sewa_edit')));
- $end_sewa = date('Y-m-d', strtotime($this->input->post('end_sewa_edit')));
- $pemilik = db_clean($this->input->post('pemilik_edit'));
- $info_edit = array(
- 'pemilik' => $pemilik,
- 'start_sewa' => $start_sewa,
- 'end_sewa' => $end_sewa,
- 'at_cost' => $at_cost,
- 'update_user' => $this->session->userdata('username')
- );
- $this->m_all->update($id_asset, $info_edit, $this->primary, $this->table);
- foreach ($cek_approval->result() as $cp)
- {
- $get_approval = $cp->ap_username;
- $message1 = '<p> Kepada Yth : '.$cp->nm_user.'</p>';
- $message1.= '<p> Lokasi : '.$cp->lokasi.'</p>';
- $message1.= '<p> Posisi : '.$cp->posisi.'</p>';
- $message1.= '<p></p>';
- $message1.= '<p> Edit Data Asset Sewa</p>';
- $message1.= '<p> Data Asset : </p>';
- $message1.= '<p> ID Asset : '.$id_asset.'</p>';
- $message1.= '<p></p>';
- $message1.= '<p> Harap, agar di-validkan</p>';
- $message1.= '<p> Terima Kasih </p>';
- $message1.= '<p>'.$this->session->userdata('namauser').'</p>';
- }
- if ($this->auth->send_email($this->session->userdata('username'), $this->session->userdata('password'), $this->session->userdata('namauser'), $get_approval, 'Konfirmasi Edit Asset Sewa', $message1))
- $status_approval = '1';
- else $status_approval = '0';
- $konfirm_id = $this->auth->get_jumlah('konfirm_id','tb_konfirmasi') + 1;
- $info_pesan = array(
- 'konfirm_id' => $konfirm_id,
- 'konfirm_jdl' => 'Konfirmasi Edit Asset Sewa',
- 'konfirm_isi' => $message1,
- 'konfirm_from' => $this->session->userdata('username'),
- 'konfirm_to' => $get_approval
- );
- $this->m_all->simpan($info_pesan, 'tb_konfirmasi');
- $info_log_admin = array(
- 'id_log' => $this->auth->get_jumlah('id_log','tb_log_admin') + 1,
- 'status' => '2 ; status_kirim_approval '.$status_approval,
- 'konfirm_id' => $konfirm_id,
- 'isi_table' => $message1,
- 'from_table' => $this->table,
- 'update_user' => $this->session->userdata('username')
- );
- $this->m_all->simpan($info_log_admin, 'tb_log_admin');
- ob_start();
- $html = ob_get_contents();
- ob_end_clean();
- $respon = array('status'=>'sukses','pesan'=>'Data berhasil di-update', 'html'=>$html);
- }
- else $respon = array('status'=>'gagal','pesan'=>'Harap lengkapi data/APPROVAL belum di-setting - ADMIN');
- echo json_encode($respon);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement