<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Accounting extends CI_Controller {
	
	public $page;
	public $limit;
  
	function __construct(){
		parent::__construct();
		$this->load->model(array('m_acc','spec','m_ppic'));
		//$this->load->model(array('m_ppic','spec'));
		//$this->load->helper('security');
		$this->data_view = 10;
	}
	function index(){
		redirect('accounting/data_suplyer');
		//redirect('accounting/bon_pps');
		//redirect('accounting/data_brng');
	}
	## =================================== BEGIN View Master Suplyer ============================================= ##
	function data_suplyer($paging=0){
		if(is_login()){
			if(acc()){
			
			$this->page = $paging;
			$this->limit = $this->data_view;
			
			$config['base_url']		= site_url('accounting/data_suplyer');
			$config['total_rows'] 	= $this->m_acc->totalSuplyer(); //20 data
			$config['per_page']		= $this->limit;			
			
				$this->pagination->initialize($config);
			
			$data['title']		= 'Daftar Supplier';
			$data['judul']		= 'Daftar Supplier';
			$data['sidebar'] 	= "sidebar/sd_file";			
			$data['suply'] 		= $this->m_acc->view_suplyer();
			$data['total_data'] = $config['total_rows'];
			$data['page_of']	= floor(($this->uri->segment(3)/$config['per_page']) + 1);
			$data['content'] 	= "accounting/view/suplyer";
			
			$this->load->view('theme/utamaAcc',$data);
			
	#		$this->load->view('migrate_view');
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}else{
			redirect('login');
		}
	}
	function data_suplyer_det(){
		$id = $this->input->post('id');
		$data['det_sup'] 	= $this->m_acc->view_suplyer_det($id);
		$data['tipe_sup']	= $this->m_acc->tipe_sup();
		$this->load->view('accounting/detail/suply',$data);
	}
	function save_new_tipe_sup(){
		$tipe = $this->input->post('tipe_masuk');
		$this->db->query("INSERT INTO m_tipe_sup(nama_tipe) VALUES('$tipe')");
		
	}
	## ==================================== END View Master Suplyer =========================================== ##

	## ====================================== BEGIN view Master barang ====================================== ##
	function data_brng(){
		if(is_login()){
			if(acc()){
			$data['title'] 		= 'Daftar Barang';
			$data['judul'] 		= 'Daftar Barang';
			$data['sidebar'] 	= "sidebar/sd_file";
			$data['brng'] 		= $this->m_acc->view_brng();
			$data['content'] 	= "accounting/view/brng";
			$this->load->view('theme/utamaAcc',$data);	
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}else{
			redirect('login');
		}
	}
	//--------------- Stok barang keseluruhan --------------------//
	function stok_brng($paging=0){
		if(is_login()){
			if(acc()){
			
			$this->page = $paging;
			$this->limit = $this->data_view;
			
			$config['base_url']		= site_url('accounting/stok_brng');
			$config['total_rows'] 	= $this->m_acc->totalStokBarang();
			$config['per_page']		= $this->limit;			
			
				$this->pagination->initialize($config);
			
			$data['title'] 		= 'All Stok Barang';
			$data['judul'] 		= 'Daftar Stok Barang';
			$data['sidebar'] 	= "sidebar/sd_file";
			$data['barang'] 	= $this->m_acc->barangAll();
			$data['total_data'] = $config['total_rows'];
			$data['page_of']	= floor(($this->uri->segment(3)/$config['per_page']) + 1);
			$data['content'] 	= "accounting/all_stok_barang";
			
			$this->load->view('theme/utamaAcc',$data);
		//	$this->output->enable_profiler(true);
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}else{
			redirect('login');
		}
	}
	
	function stokBarangIn($id, $paging=0){
		
		$this->page = $paging;
		$this->limit = $this->data_view;
	
		$config['base_url']		= site_url('accounting/stokBarangIn/'.$id.'/');
		$config['total_rows'] 	= $this->m_acc->totalStokBarangIn($id);
		$config['per_page']		= $this->limit;
		$config['uri_segment'] = 4;		
		
			$this->pagination->initialize($config);			
		
		$data['title'] 		= 'Barang Masuk';
		$data['judul'] 		= 'Barang Masuk &raquo; '.$id;
		$data['sidebar'] 	= "sidebar/sd_file";
		$data['content'] 	= "accounting/detail/barang_in";
		$data['det_in'] 	= $this->m_acc->barangAll_det_in($id);
		$data['total_data'] = $config['total_rows'];
		$data['page_of']	= floor(($this->uri->segment(4)/$config['per_page']) + 1);
		
		$this->load->view('theme/utamaAcc',$data);
	}
	function stokBarangOut($id, $paging=0){
		$this->page = $paging;
		$this->limit = $this->data_view;
	
		$config['base_url']		= site_url('accounting/stokBarangOut/'.$id.'/');
		$config['total_rows'] 	= $this->m_acc->totalStokBarangOut($id);
		$config['per_page']		= $this->limit;
		$config['uri_segment'] = 4;		
		
			$this->pagination->initialize($config);
		
		$data['title'] 		= 'Barang Keluar';
		$data['judul'] 		= 'Barang Keluar &raquo; '.$id;
		$data['sidebar'] 	= "sidebar/sd_file";
		$data['content'] 	= "accounting/detail/barang_out";
		$data['det_out'] 	= $this->m_acc->barangAll_det_out($id);
		$data['total_data'] = $config['total_rows'];
		$data['page_of']	= floor(($this->uri->segment(4)/$config['per_page']) + 1);
		
		$this->load->view('theme/utamaAcc',$data);
	}
	//--------------- End stok barang keseluruhan ---------------//
	## ===================================== = END view Master barang ========================================== ##
	
	## =========================================== BEGIN PPB =================================================== ##
	#! View --------------------------------
	function ppb($paging=0){
		if(is_login()){
			if(acc()){
				
				if(isset($_GET['search'])){
					$regexp = $_GET['search'];
				}else{
					$regexp = "PPB";
				}
				
				$this->page = $paging;
				$this->limit = $this->data_view;
			
				$config['base_url']		= site_url('accounting/ppb');
				$config['total_rows'] 	= $this->m_acc->totalPPB($regexp);
				$config['per_page']		= $this->limit;
		
					$this->pagination->initialize($config);			
			
				$data['title'] 	= 'Daftar Permintaan Pembelian Barang';
				$data['judul'] 	= 'Daftar Permintaan Pembelian Barang';
				$data['sidebar']= "sidebar/sd_file";
				$data['ppb'] 	= $this->m_acc->view_ppb($regexp);
				$data['ppbr'] 	= $this->m_acc->view_ppb_br($regexp);
				$data['content']= "accounting/view/ppb";
				$data['total_data'] = $config['total_rows'];
				$data['page_of']	= floor(($this->uri->segment(4)/$config['per_page']) + 1);
				
				$this->load->view('theme/utamaAcc',$data);
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}else{
			redirect('login');
		}
		//$this->output->enable_profiler(true);
	}
	# ------------------------------------!#
	#! Aprove dis Aprove -------------------
	function apr_ppb(){
		$id=$this->uri->segment(3);
        
		$this->m_acc->ppb_approve($id);
        redirect('accounting/ppb');
	}
	function apr_ppb_cancel(){
		$id=$this->uri->segment(3);
        
		$this->m_acc->ppb_cancelApprove($id);
        redirect('accounting/ppb');
	}
	# ------------------------------------!#
	## ==================================================== END PPB ==================================================== ##

	## ================================================== BEGIN Kontrak ================================================= ##
	#! View Kontrak ------------------------
	function kontrak($paging=0){
		if(is_login()){
			if(acc()){
				$regexp="PPB-";
				
				$this->page = $paging;
				$this->limit = $this->data_view;
			
				$config['base_url']		= site_url('accounting/kontrak');
				$config['total_rows'] 	= $this->m_acc->totalViewKon($regexp);
				$config['per_page']		= $this->limit;
		
					$this->pagination->initialize($config);			
				
				$data['title'] 		= 'Daftar Kontrak';
				$data['judul'] 		= 'Daftar Kontrak';
				$data['sidebar'] 	= "sidebar/sd_file";
				$data['ppb'] 		= $this->m_acc->view_kon($regexp);
				$data['ppbr'] 		= $this->m_acc->view_kon_br($regexp);
				$data['content'] 	= "accounting/view/kontrak";
				$data['total_data'] = $config['total_rows'];
				$data['page_of']	= floor(($this->uri->segment(4)/$config['per_page']) + 1);
				
				$this->load->view('theme/utamaAcc',$data);
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}else{
			redirect('login');
		}
	}
	# ------------------------------------!#
	#! call form add kontrak ---------------
	function add_kontrak(){
		# ---No Auto--- #
		$th 	   	= date("y"); 				        	# Tahun 2 digit dari belakang "12"
		$bln_ref 	= date("m"); 			            	# bulan dengan format 2 digit angka "04"
		$k_permin 	= "KON";			                	# kode untuk tiap jenis transaksi
		$k_gd 		= "GR";				               		# kode untuk setiap gudang hanya 2 digit
		$default	= "0000";
		$regexp		= $k_permin."-".$th."-".$k_gd;			# untuk query pada function count_ppb
		$qu			= $this->spec->count_permin($regexp);
		$count 		= $qu->num_rows();
		$no_count 	= $count + 1;
		$a 			= strlen($no_count);
		$no 		= substr($default,0,-$a).$no_count;
		# Array konversi bulan ke bentuk Romawi
		$bln_array 	= array( '01' => "I", '02' => "II", '03' => "III", '04' => "IV", '05' => "V", '06' => "VI",
							 '07' => "VII", '08' => "VIII", '09' => "IX", '10' => "X", '11' => "XI", '12' => "XII" );
		$bln 		= $bln_array[$bln_ref];					# Mencetak bulan dalam angka romawi "I";
		$no_trans 	= $k_permin."-".$th."-".$k_gd."-".$bln."-".$no;
		# ---No Auto--- #
		if (is_login()){
			$u_id = $this->session->userdata['id_user'];
			$data['gudang'] 	= $this->spec->gdng_by_uid($u_id);
			$data['kontrak'] 	= $no_trans;
			$data['title'] 		= 'Form Permintaan dan Pembelian Barang';
			$data['sidebar'] 	= "sidebar/sd_file";
			$data['content'] 	= "accounting/form/kontrak";
			if(acc()){
				$this->load->view('theme/utamaAcc',$data);
			}elseif(admin()){
				$this->load->view('theme/utama',$data);
			}else{
				redirect('login');
			}
		}
		else{
			redirect('login');
		}
		//$this->output->enable_profiler(true);
	}
	# ------------------------------------!#
	#! Save PPB ----------------------------
	function kontrak_pro(){	
		# post bukan array
		$u_id 			= $this->session->userdata['id_user'];
		$nm_supplier 	        = $this->input->post('nm_suply');
		$id_sup 		= $this->input->post('id_sup');
		$id_gd 			= $this->input->post('gudang');
		$no_trans 		= str_replace("/", "-", $this->input->post('no_trans'));
		$tgl_kon 		= str_replace("/", "-", $this->input->post('tgl_ppb'));
		$v_acc 			= "y";
		$v_dir	 		= "n";
			# post array
			$idbr 	= $this->input->post('kode_br');
			$nabar 	= $this->input->post('nama_br');
			$sat 	= $this->input->post('id_sat');
			$jml 	= $this->input->post('jumlah');
			$harga 	= $this->input->post('harga');
			$total 	= $this->input->post('total');
			$ket 	= $this->input->post('keterangan');
			
		for($i=0; $i<count($idbr); $i++){			
			$this->m_acc->savekonPerBrg($idbr[$i], $nabar[$i], $jml[$i], $sat[$i], $ket[$i], $u_id, $v_dir, $no_trans, $tgl_kon, $harga[$i], $total[$i]);			
		}
		$this->m_acc->savekonPer($u_id, $nm_supplier, $id_gd, $no_trans, $tgl_kon, $v_acc, $v_dir);
		//$this->output->enable_profiler(true);	
		redirect('accounting/kontrak');
	}
	# ------------------------------------!#
	## ============================================= END Kontrak ============================================= ##	
	
	## ======================================== BEGIN LPB =================================================== ##
	#! View --------------------------------
	function lpb($paging=0){
		if(is_login()){
			if(acc()){
			
			if(isset($_GET['search'])){
				$regexp = $_GET['search'];
			}else{
				$regexp = "LPB";
			}
			
			$this->page = $paging;
			$this->limit = $this->data_view;
		
			$config['base_url']		= site_url('accounting/lpb');
			$config['total_rows'] 	= $this->m_acc->totalViewLpb();
			$config['per_page']		= $this->limit;
	
				$this->pagination->initialize($config);			
			
			$data['title'] 		= 'Daftar Laporan Penerimaan Barang';
			$data['judul'] 		= 'Daftar Laporan Penerimaan Barang';
			$data['sidebar'] 	= "sidebar/sd_file";
			$data['lpb'] 		= $this->m_acc->view_lpb($regexp);
			$data['lpbr'] 		= $this->m_acc->view_lpb_br();
			$data['content'] 	= "accounting/view/lpb";
			
			$data['total_data'] = $config['total_rows'];
			$data['page_of']	= floor(($this->uri->segment(4)/$config['per_page']) + 1);
				
			$this->load->view('theme/utamaAcc',$data);
			
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}else{
			redirect('login');
		}
		//$this->output->enable_profiler(true);
	}
	# ------------------------------------!#
	#! Call Form LPB Set hrg ---------------
	function apr_lpb_frm(){
		$no_lpb = $this->uri->segment(3);
        if(is_login()){
			if(acc()){
			$data['title'] 		= 'Laporan Penerimaan Barang';
			$data['judul'] 		= 'Laporan Penerimaan Barang';
			$data['sidebar'] 	= "sidebar/sd_file";
			$data['lpb'] 		= $this->m_acc->view_lpb1($no_lpb);
			$data['lpbr'] 		= $this->m_acc->view_lpb1_br($no_lpb);
			$data['content'] 	= "accounting/form/lpb_hrg";
			$this->load->view('theme/utamaAcc',$data);
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}else{
			redirect('login');
		}
	}
	# ------------------------------------!#
	#! Aprove ------------------------------
	function apr_lpb(){
		$id_br 	= $this->input->post("kode_br");
		$hrg	= $this->input->post("hrg");
		$form	= $this->input->post("form");
		$no_lpb	= $this->input->post("no_lpb");
		$no_per = $this->input->post("no_permin");
		$this->m_acc->lpb_approve($id_br, $hrg, $form, $no_lpb, $no_per);	
		$this->output->enable_profiler(true);
		redirect('accounting/lpb');
	}
	# ------------------------------------!#
	#! View Detail LPB ---------------------
	function getDetailLPB(){
		#$no_lpb 			= $this->uri->segment(3);
		#$no_ppb 			= $this->uri->segment(4);
		$no_lpb = $this->input->post('valOne');
		$no_ppb = $this->input->post('valTwo');
		
		$data['detail_lpb'] 	= $this->m_acc->getDetail_lpb($no_lpb);
		$data['no_lpb']		= $no_lpb;
		$data['no_ppb'] 	= $no_ppb;
		$this->load->view('accounting/detail/lpb', $data);
	}
	# ------------------------------------!#
	## ==================================================== END LPB ==================================================== ##
	
	## ===================================================== BEGIN PPS ================================================= ##
	#! View PPS ----------------------------
	function pps($paging=0){
		if(is_login()){
			if(acc()){
			
				if(isset($_GET['search'])){
					$regexp = $_GET['search'];
				}else{
					$regexp = "LPB";
				}
				
				$this->page = $paging;
				$this->limit = $this->data_view;
			
				$config['base_url']		= site_url('accounting/pps');
				$config['total_rows'] 	= $this->m_acc->totalViewPps();
				$config['per_page']		= $this->limit;
		
					$this->pagination->initialize($config);
					
				$data['title'] 		= 'Daftar Permintaan Pembelian Sparepart';
				$data['judul'] 		= 'Daftar Permintaan Pembelian Sparepart';
				$data['sidebar'] 	= "sidebar/sd_file";
				$data['pps'] 		= $this->m_acc->view_pps();
				$data['ppsbr'] 		= $this->m_acc->view_pps_br();
				$data['content'] 	= "accounting/view/pps";
				
				$data['total_data'] = $config['total_rows'];
				$data['page_of']	= floor(($this->uri->segment(4)/$config['per_page']) + 1);
				
				$this->load->view('theme/utamaAcc',$data);
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}else{
			redirect('login');
		}
		///$this->output->enable_profiler(true);
	}
	# ------------------------------------!#
	## ==================================================== BEGIN PPS ================================================ ##

	## =========================================== BEGIN insert Suplyer ============================================== ##
	#! Call form add suply -----------------
	function input_suplyer(){
		if(is_login()){
			if(acc()){
			$data['content'] 	= "accounting/form/add_suply";
			$data['title'] 		= 'Tambah Master Suplyer';
			$data['judul'] 		= 'Tambah Master Suplyer';
			$data['sidebar'] 	= "sidebar/sd_file";
			$q 					= $this->db->query("SELECT kode_sup FROM m_suply ORDER BY kode_sup DESC LIMIT 1");
			$fq 				= $q->result();
			foreach($fq as $hq){
			$data['kode_terakhir'] = $hq->kode_sup;
			}
			$data['tipe_supplier'] = $this->m_acc->tipe_sup();
			$this->load->view('theme/utamaAcc',$data);	
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}else{
			redirect('login');
		}
	}
        
        #------------------------------- Master Warna --------------------------#
        function input_Warna(){
		if(is_login()){
			if(acc()){
			$data['content'] 	= "accounting/form/add_warna";
			$data['title'] 		= 'Tambah Master Warna';
			$data['judul'] 		= 'Tambah Master Warna';
			$data['sidebar'] 	= "sidebar/sd_file";
			$q 			= $this->db->query("SELECT kode_warna FROM master_warna ORDER BY kode_warna ASC LIMIT 1");
                        $q2                     = $this->db->query("SELECT warna from master_warna ORDER BY kode_warna ASC LIMIT 1");
			$fq 			= $q->result();
                        $fq2                    = $q2->result();
			
                        foreach($fq as $hq){
				$data['kode_terakhir'] = $hq->kode_warna;  
                        }
                        
                        foreach($fq2 as $hq2){
                                $data['ket_warna']=$hq2->warna;
                        }
                        
			$data['tipe_supplier'] = $this->m_acc->tipe_sup();
			$this->load->view('theme/utamaAcc',$data);	
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}else{
			redirect('login');
		}
	}
        
        function Tambah_Warna(){
		$tabel 		= "master_warna";
		$Kode_warna 	= strtoupper($this->input->post('kode_warna'));
		$Warna      	= strtoupper($this->input->post('warna'));
		
		
		$dtwarna 	= array(
			'kode_warna' =>$Kode_warna,
			'warna'	=> $Warna
		);
		$this->db->insert($tabel,$dtwarna);
		redirect('accounting/setting_warna');
	}
	# ------------------------------------!#
	#! Check kode -------------------------- 
        
        
        function MasterAnalisaBiaya_save(){
		
			$No_Profing           = $this->input->post("NoProf");
			$bahan                = $this->input->post("material1");
			$jumlah               = $this->input->post("kuantitas1");
                        $pembeli              = $this->input->post("buyer1");
                        
                        $tabel1 = "master_analisa_biaya";
			$tabel2 = "stok_brng";
			$dataS 	= array(
				'kode_analisa_biaya'	=> strtoupper($No_Profing),
				'material'              => strtoupper($bahan),
				'jumlah'                => $jumlah,
				'buyer'                 => $pembeli,
			);
			$this->db->insert($tabel1, $dataS);
			redirect('ppic/analisa_biaya');
            }
        
        
	function cek_kode_sup(){
		$kode 		= $this->input->post('kode');
		$forquery 	= $this->db->query("SELECT kode_sup FROM m_suply WHERE kode_sup='$kode'");
		$hasilquery = $forquery->result();
		if(count($hasilquery)>0){
			echo "Kode sudah ada !";
		}
	}
	# ------------------------------------!#
	#! Simpan Supplier ---------------------
	function tambah_suply_pro(){
		$tabel 		= "m_suply";
		$kode 		= strtoupper($this->input->post('kode'));
		$nama_sup 	= $this->input->post('nama');
		$no_telp 	= $this->input->post('telp');
		$fax 		= $this->input->post('fax');
		$email 		= $this->input->post('email');
		$cp 		= $this->input->post('cp');
		$tipe 		= $this->input->post('tipe');		
		$alamat 	= $this->input->post('alamat');
		$ket 		= $this->input->post('ket');
		
		#curent date time
		$tgl_input 	= date("Y/m/d H:i:s");
		#user login
		$user 		= $this->session->userdata['id_user'];
		
		$suplyer 	= array(
			'kode_sup'	=>$kode,
			'nama_sup'	=> $nama_sup,
			'alamat_sup'=> $alamat,
			'no_telp'	=> $no_telp,
			'no_fax'	=>$fax,
			'tipe_sup'	=>$tipe,
			'cp_sup'	=>$cp,
			'ket_sup'	=>$ket,
			'tgl_in'	=> $tgl_input,				
			'user_in' 	=> $user
		);
		$this->db->insert($tabel,$suplyer);
		//redirect('accounting/data_suplyer');
	}
	# ------------------------------------!#
	## =============================================== END insert Suplyer =========================================== ##
	
	/*==========================================	START Customer	==================================================*/
	function data_customer($paging=0){
		if(is_login()){
			if(acc()){
			
			$this->page = $paging;
			$this->limit = $this->data_view;
		
			$config['base_url']		= site_url('accounting/data_customer');
			$config['total_rows'] 	= $this->m_acc->totalCustomer();
			$config['per_page']		= $this->limit;
	
				$this->pagination->initialize($config);
					
			$data['title'] 		= 'Daftar Customer';
			$data['judul'] 		= 'Daftar Customer';
			$data['sidebar'] 	= "sidebar/sd_file";
			$data['customer'] 	= $this->m_acc->view_customer();
			$data['content'] 	= "accounting/view/customer";
			
			$data['total_data'] = $config['total_rows'];
			$data['page_of']	= floor(($this->uri->segment(4)/$config['per_page']) + 1);
			
			$this->load->view('theme/utamaAcc',$data);	
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}else{
			redirect('login');
		}
	}
	function detail_customer(){
		if(is_login() && acc()){
			$kode_customer = $this->input->post('id');
			$data['customer']	= $this->m_acc->getDetailCustomer($kode_customer);
			$this->load->view('accounting/detail/customer', $data);
		}else{
			redirect('login', 'refresh');
			exit;
		}
	}
	function saveEditCustomer(){
		if($this->input->post()){
			$id = $this->input->post('id_cust');
			$nama = $this->input->post('nama_customer');
			$telepon = $this->input->post('telepon');
			$fax = $this->input->post('fax');
			$contact = $this->input->post('contact');
			$alamat = $this->input->post('alamat');
			$keterangan = $this->input->post('keterangan');
			
			$dataEdit = array(
               'nama_cust' 	=> $nama,
               'alamat_cust'=> $alamat,
               'no_telp' 	=> $telepon,
			   'no_fax'		=> $fax,
			   'cp_cust'	=> $contact,
			   'ket_cust'	=> $keterangan,			   
            );
			$this->m_acc->save_edit_customer($id, $dataEdit);
			redirect('accounting/data_customer', 'refresh');
		}
	}
	function input_customer(){
		if(is_login()){
			if(acc()){
				if($this->input->post()):
					$this->form_validation->set_rules('kode', 'Kode Customer', 'required|is_unique[customer.kode_cust]|exact_length[6]');
					$this->form_validation->set_rules('nama', 'Nama Customer', 'required');
					$this->form_validation->set_rules('telepon', 'Nomor Telepon', 'required|numeric');
					$this->form_validation->set_rules('fax', 'Nomor Fax', 'required|numeric');
					$this->form_validation->set_rules('email', 'Email', 'required|valid_email|is_unique[customer.email]');
					$this->form_validation->set_rules('cp', 'Contact Person', 'required');
          
					if($this->form_validation->run() === TRUE){
						$kode	 = strtoupper($this->input->post("kode"));
						$nama	 = $this->input->post("nama");
						$telepon = $this->input->post("telepon");
						$fax	 = $this->input->post("fax");
						$email	 = $this->input->post("email");
						$cp	 = $this->input->post("cp");
						$alamat	 = $this->input->post("alamat");
						$keterangan	 = $this->input->post("keterangan");
						
						$dataMasuk = array(
										'kode_cust'		=> $kode,
										'nama_cust'		=> $nama,
										'email'			=> $email,
										'alamat_cust'	=> $alamat,
										'no_telp'		=> $telepon,
										'no_fax'		=> $fax,
										'cp_cust'		=> $cp,
										'ket_cust'		=> $keterangan,
										'tgl_in'		=> date('Y-m-d'),
										'user_in'		=> $this->session->userdata('id_user')
									);
						$this->m_acc->save_new_customer($dataMasuk);
						redirect('accounting/data_customer', 'refresh');
					}
				endif;
			
				$data['content'] 	= "accounting/form/add_customer";
				$data['title'] 		= 'Tambah Master Customer';
				$data['judul'] 		= 'Tambah Master Customer';				
				$data['sidebar'] 	= "sidebar/sd_file";
				$data['last_kode']	= $this->m_acc->last_kode_customer();
				$this->load->view('theme/utamaAcc',$data);	
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}else{
			redirect('login');
		}
	}
	function tambah_customer_pro(){
		#curent date time
		$tgl_input 	= date("Y/m/d");
		#user login
		$user 		= $this->session->userdata['id_user'];	
		
		$kode 		= $this->input->post('kode');
		$nama 		= $this->input->post('nama');
		$telp 		= $this->input->post('telp');
		$fax 		= $this->input->post('fax');
		$email 		= $this->input->post('email');
		$cp 		= $this->input->post('cp');
		$alamat 	= $this->input->post('alamat');
		$ket 		= $this->input->post('ket');
		$data_masuk = array(
			'kode_cust'		=>$kode,
			'nama_cust'		=>$nama,
			'alamat_cust'	=>$alamat,
			'no_telp'		=>$telp,
			'no_fax'		=>$fax,
			'cp_cust'		=>$cp,
			'ket_cust'		=>$ket,
			'tgl_in'		=>$tgl_input,
			'user_in'		=>$user
		);
		$this->db->insert('customer', $data_masuk);
		redirect('accounting/data_customer');
	}
	/*==========================================	END Customer	==================================================*/
	
	#### =========================================== BEGIN insert Master Barang =========================================== ####
	function input_barang(){
		if(is_login()){
			if(acc()){
			$data['content'] 	= "accounting/form/add_brng";
                        /*$data['content']        = "ppci/form/form_add_LJ";*/
			$data['title'] 		= 'Tambah Master Data Suplyer';
			$data['judul'] 		= 'Tambah Master Data Suplyer';
			$data['gudang'] 	= $this->m_acc->gudang();
			$data['satuan'] 	= $this->m_acc->getsatuan();
            $data['supplier']	= $this->m_acc->getSupplier();
			$data['sidebar'] 	= "sidebar/sd_file";
			$this->load->view('theme/utamaAcc',$data);	
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}
                else{
			redirect('login');
		}
	}
	function sub_gd(){
		$id_sub 		= $this->input->post('id_subgd');
		$data['sub_gd'] = $this->m_acc->sub_gudang($id_sub);
		$this->load->view('accounting/v_sub-gd',$data);
	}
	function cek_kode_br(){
		$kode 		= $this->input->post('kode');
		$forquery 	= $this->db->query("SELECT kode_br FROM m_brng WHERE kode_br='$kode'");
		$hasilquery = $forquery->result();
		if(count($hasilquery)>0){
			echo "Kode sudah ada !";
		}
	}
	function tambah_barang_pro(){
		//$tabel1 	= "m_brng";
		//$tabel2	 	= "stok_brng";
		
		$nama_br 	= $this->input->post('nm_brng');
		$id_sat 	= $this->input->post('sat_brng');
		$ket 		= $this->input->post('ket');
		$id_gd 		= $this->input->post('gudang');
		$sub_gd 	= $this->input->post('subgd');
		$kode_br 	= strtoupper($this->input->post('kode_barang'));
		$id_sup		= $this->input->post('id_sup');
		#curent date time
		//$tgl_input 	= date("Y/m/d H:i:s");
		#user login
		$user 		= $this->session->userdata['id_user'];
		
		$this->m_acc->brng_save($nama_br, $kode_br, $id_sat, $id_sup, $ket, $id_gd, $sub_gd, $user);
		redirect('accounting/input_barang');
		//$this->output->enable_profiler(true);
	}
	#### =========================================== END Insert Master Barang =========================================== ####
	
	/**
	*	sales
	*/
	function all_master_sales($paging=0){
		if(is_login()){
			if(acc()){				
				$this->page = $paging;
				$this->limit = $this->data_view;
			
				$config['base_url']		= site_url('accounting/all_master_sales');
				$config['total_rows'] 	= $this->m_acc->totalAllSales();
				$config['per_page']		= $this->limit;
		
					$this->pagination->initialize($config);
					
				$data['title'] 		= 'Master Sales';
				$data['judul']		= 'Master Data Sales';
				$data['list_sales'] = $this->m_acc->get_all_sales();
				$data['content'] 	= "accounting/all_sales";				
				$data['sidebar'] 	= "sidebar/sd_file";
				$data['total_data'] = $config['total_rows'];
				$data['page_of']	= floor(($this->uri->segment(4)/$config['per_page']) + 1);
				
				$this->load->view('theme/utamaAcc',$data);
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}else{
			redirect('login','refresh');
		}
	}
	function add_sales(){
		if(is_login()){
			if(acc()){
			
				if($this->input->post()):

					$this->form_validation->set_rules('nama', 'Nama', 'required');
					$this->form_validation->set_rules('telp', 'Telepon', 'required');
					$this->form_validation->set_rules('ktp', 'KTP', 'required');
					
					if($this->form_validation->run() === TRUE){
						$nama = $this->input->post('nama');
						$telp = $this->input->post('telp');
						$alamat = $this->input->post('alamat');
						$ktp = $this->input->post('ktp');
						
						$dataSales = array(
										'nama'	=> $nama,
										'noHp'	=> $telp,
										'alamat'=> $alamat,
										'noKTP'	=> $ktp
									);
						$this->m_acc->save_new_sales($dataSales);
						redirect('accounting/all_master_sales','refresh');
					}else{
						redirect('accounting/all_master_sales', 'refresh');
					}
				endif;
				// form add_sales ada pada folder view file sidebar/sd_file
				/*
				$data['title'] 		= 'Tambah Data Sales';
				$data['content'] = "accounting/form/add_sales";
				$data['sidebar'] 	= "sidebar/sd_file";
				$this->load->view('theme/utamaAcc',$data);
				*/
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}else{
			redirect('login','refresh');
		}
	}
        
        function edit_warna(){
		if(is_login()){
			if(acc()){
				if($this->input->post()):
					$id = $this->input->post('id');
					$kode_warna = $this->input->post('kode_warna');
					$warna = $this->input->post('warna');
					
					$datawarna = array(
								'id_warna'	=> $id,
								'kode_warna'	=> $kode_warna,
								'warna' => $warna
								
							);
					$this->m_acc->save_edit_warna($id, $datawarna);
					
					redirect('accounting/setting_warna', 'refresh');
				endif;
				
				if(isset($_GET['edit'])){
					$id = $_GET['edit'];
					$data['title'] 		= 'Edit Data Warna';
					$data['content'] 	= "accounting/form/edit_warna";
					$data['sidebar'] 	= "sidebar/sd_file";
					$data['data_warna'] = $this->m_acc->get_warna($id);
					$this->load->view('theme/utamaAcc',$data);
				}elseif(isset($_GET['del'])){
					$id = $_GET['del'];
					$this->m_acc->delete_sales($id);
					redirect('accounting/all_master_sales','redirect');
				}
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}else{
			redirect('login','refresh');
		}
	}
        
	function manage_sales(){
		if(is_login()){
			if(acc()){
				if($this->input->post()):
					$id = $this->input->post('id');
					$nama = $this->input->post('nama');
					$telp = $this->input->post('telp');
					$alamat = $this->input->post('alamat');
					$ktp = $this->input->post('ktp');					
					
                                                                         
                                        
					$dataSales = array(
								'nama'	=> $nama,
								'noHp'	=> $telp,
								'alamat' => $alamat,
								'noKTP'	=> $ktp
							);
					$this->m_acc->save_edit_sales($id, $dataSales);
					
					redirect('accounting/all_master_sales', 'refresh');
				endif;
				
				if(isset($_GET['edit'])){
					$id = $_GET['edit'];
					$data['title'] 		= 'Edit Data Sales';
					$data['content'] 	= "accounting/form/edit_sales";
					$data['sidebar'] 	= "sidebar/sd_file";
					$data['data_sales'] = $this->m_acc->get_sales($id);
					$this->load->view('theme/utamaAcc',$data);
				}elseif(isset($_GET['del'])){
					$id = $_GET['del'];
					$this->m_acc->delete_sales($id);
					redirect('accounting/all_master_sales','redirect');
				}
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}else{
			redirect('login','refresh');
		}
	}
        
        function manage_customer(){
		if(is_login()){
			if(acc()){
				if($this->input->post()):
                                        $id = $this->input->post('id');
					$kode = $this->input->post('kode');
                                        $nama = $this->input->post('nama');
                                        $alamat = $this->input->post('alamat');
                                        $telepon = $this->input->post('telepon');
					$fax = $this->input->post('fax');
                                        $email = $this->input->post('email');
                                        $cp = $this->input->post('cp');
                                        $keterangan = $this->input->post('keterangan');
                                                                            
				                                                                            
                                        $dataCustomer = array(                  'id_cust'               => $id, 
										'kode_cust'		=> $kode,
										'nama_cust'		=> $nama,
										'email'			=> $email,
										'alamat_cust'	        => $alamat,
										'no_telp'		=> $telepon,
										'no_fax'		=> $fax,
										'cp_cust'		=> $cp,
										'ket_cust'		=> $keterangan,
										'tgl_in'		=> date('Y-m-d'),
										'user_in'		=> $this->session->userdata('id_user')
									);
					$this->m_acc->save_edit_customer($id, $dataCustomer);
					
					redirect('accounting/data_customer', 'refresh');
				endif;
				
				if(isset($_GET['edit'])){
					$id = $_GET['edit'];
					$data['title'] 		= 'Edit Data Customer';
                                        $data['judul']          = 'Edit Data Customer';
					$data['content'] 	= "accounting/form/edit_customer";
					$data['sidebar'] 	= "sidebar/sd_file";
					$data['data_customer']  = $this->m_acc->get_customer($id);
					$this->load->view('theme/utamaAcc',$data);
				}elseif(isset($_GET['del'])){
					$id = $_GET['del'];
					$this->m_acc->delete_customer($id);
					redirect('accounting/data_customer','redirect');
				}
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}else{
			redirect('login','refresh');
		}
	}
	/**
	*		User Account
	*/
	function change_password(){
		if(is_login()){			
			if($this->input->post()){
				$this->form_validation->set_rules('nama','Nama Lengkap','required');
				$this->form_validation->set_rules('telp','Username','required');
				$this->form_validation->set_rules('pass','Password','required|matches[passconf]');
                                $this->form_validation->set_rules('passconf','Password Confirmation','required');
				if($this->form_validation->run() == FALSE){
					$data['title'] 		= 'Saved Error | '.$this->session->userdata('nama');
					$data['content'] 	= "accounting/detail/profile";
				}else{
					$nama = $this->input->post('nama');
					$username = $this->input->post('telp');
					$pass = $this->input->post('pass');
					
					$dataUser = array(
									'nama_lengkap'	=> $nama,
									'username'		=> $username,
									'password'		=> md5(md5($pass))
								);
					$this->spec->save_edit_profile($dataUser);
				}
			}
			$data['title'] 		= 'User Account | '.$this->session->userdata('nama');			
			$data['content'] 	= "accounting/detail/profile";			
			$data['profile']	= $this->spec->get_profile();
			if(acc()){
				$data['sidebar'] 	= "sidebar/sd_file";
				$this->load->view('theme/utamaAcc',$data);
			}elseif(grey()){
				$data['sidebar'] 	= "sidebar/sd_grey";
				$this->load->view('theme/utamaGrey',$data);
			}
			elseif(part()){
				$data['sidebar'] 	= "sidebar/sd_part";
				$this->load->view('theme/utamaPart',$data);
			}
			elseif(chem()){
				$data['sidebar'] 	= "sidebar/sd_ch";
				$this->load->view('theme/utamaCh',$data);
			}
			elseif(jadi()){
				$data['sidebar'] 	= "sidebar/sd_jadi";
				$this->load->view('theme/utamaJadi',$data);
			}
			elseif(prod()){
				$data['sidebar'] 	= "sidebar/sd_chprint";
				$this->load->view('theme/utamaProd',$data);
			}
			elseif(ppic()){
				$data['sidebar'] 	= "sidebar/sd_ppic";
				$this->load->view('theme/utamaPpic',$data);
			}
			elseif(david()){
				$data['sidebar']	= "sidebar/sd_d_utama";
				$this->load->view('david/utama', $data);
			}
			elseif(qc() || ob_pr() || ob_fin){
				$data['sidebar'] 	= "sidebar/sd_qc";
				$this->load->view('theme/utamaPpic',$data);
			}			
		}
	}
	
	/**
	*	Free Method
	*/
	public function setting_warna(){
		if(is_login()){
			if(acc()):
				$data['title'] 		= 'Master Warna';
				$data['judul']		= 'Master Warna';
				$data['content'] 	= "accounting/view/all_warna";
				$data['sidebar'] 	= "sidebar/sd_file";
				$data['data_warna'] = $this->m_acc->getAllWarna();
				$this->load->view('theme/utamaAcc',$data);
			endif;
		}else{
			redirect('login', 'refresh');
		}
	}
        
        function delete_customer($id){
		if(is_login() && acc()){
			$id = $this->uri->segment(3);
			$this->m_acc->delete_customer($id);
			redirect('accounting/data_customer', 'refresh');
                       
	}
        }
        
        function delete_warna($id){
		if(is_login() && acc()){
			$id = $this->uri->segment(3);
			$this->m_acc->delete_warna($id);
			redirect('accounting/setting_warna', 'refresh');
                       
	}
        }
        
        function BiayaProduksi(){
		if(is_login()){
			if(acc()){
			$data['content'] 	= "accounting/form/add_brng";
                        $data['title'] 		= 'Tambah Master Data Suplyer';
			$data['judul'] 		= 'Tambah Master Data Suplyer';
			$data['gudang'] 	= $this->m_acc->gudang();
			$data['satuan'] 	= $this->m_acc->getsatuan();
                        $data['supplier']	= $this->m_acc->getSupplier();
			$data['sidebar'] 	= "sidebar/sd_file";
			$this->load->view('theme/utamaAcc',$data);	
			}else{
				echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
			}
		}
                else{
			redirect('login');
		}
	}
        
           
        public function BiayaProduksidanLain(){
		if(is_login()){
			if(acc()):
				$data['title'] 		= 'Biaya Produksi dan Biaya Lain';
				$data['judul']		= 'Biaya Produksi';
				$data['content'] 	= "accounting/form/biayaproduksi";
                                //$data['content'] 	= "accounting/view/all_warna";
				$data['sidebar'] 	= "sidebar/sd_file";
                                $data['biaya']          = $this->m_acc->masterbiaya();
			endif;
		}
                else{
                    echo "Tidak Seharusnya Anda Disini klik <a href='".base_url()."'>BACK</a> untuk kembali Ke menu utama";
                }
                
	}
        
        function add1_biaya_produksi(){
		if(is_login()){
			$data['title']		= 'Biaya Produksi';
			$data['judul']		= 'Tambah Detail Biaya Produksi';
			$data['sidebar']	= 'sidebar/sd_file';
			$data['content']	= 'accounting/form/add_biaya_produksi';
			$data['biaya_produksi'] = $this->m_acc->masterbiayaproduksi();
                        $data['biaya_lain']     = $this->m_acc->masterbiayalain();
                       
		}else{
			redirect('login','refresh');
			exit;
		}
	}
        
        function getMasterbiaya(){
            $return_arr = array();
            $cari       = $_GET["term"];
            $fetch      = mysql_query("SELECT * FROM m_biaya WHERE Keterangan REGEXP '^$cari'");
            
                while   ($baris = mysql_fetch_array($fetch, MYSQL_ASSOC)){
			$baris_array['id']	       = $baris['id'];
			$baris_array['kode']           = $baris['kode'];
                        $baris_array['Keterangan']     = $baris['Keterangan'];
                        array_push($return_arr, $baris_array);
		}
		echo json_encode($return_arr);
               
        }

	function Rincian_biaya_finansial_Add(){
		if(is_login()){
			$data['title']		= 'Catatan Financial Tambah Biaya Produksi';
			$data['judul']		= 'Catatan Financial Tambah Biaya Produksi';
			$data['sidebar']	= 'sidebar/sd_file';
			$data['content']	= 'accounting/form/add_biaya_finansial';
			$data['ItemBulan']      = $this->m_acc->getbulan();
			$data['bproduksi']     = $this->m_acc->masterbiayaproduksi();
			$data['blain']         = $this->m_acc->masterbiayalain();
			$this->load->view('theme/utamaAcc', $data);
				
		}else{
			redirect('login','refresh');
			exit;
		}
	}
	
        
        function insert_new(){
		$kode = $this->input->post('tNo');			//lha iki digawe transaksi, tp yo iso digawe umum
		$kode_masuk = str_pad($kode,6,"TR0000", STR_PAD_LEFT);				
		$tglTrans =date('Y-m-d', strtotime($this->input->post('tTgl')));
		$customer = $this->input->post('tCus');
		$dis = $this->input->post('tDis');
		$pjk = $this->input->post('tPPN');
		$pmb = $this->input->post('tBayar');
		$date = mysql_datetime();
		
		$kode_br = $this->input->post('kd_br');		//mulai iki, ngisi ng table transaksi_brg
		$nama = $this->input->post('kd_br_des');
		$jml = $this->input->post('itemQty');
		$harga = $this->input->post('itemPrice');		
			for($i=0; $i<count($kode_br); $i++){
				$this->m_barang->save_tr($kode_masuk, $kode_br[$i], $nama[$i], $jml[$i], $harga[$i], $tot=($jml[$i]*$harga[$i]), $date);					
			}
			for($i=0; $i<count($kode_br); $i++){
				$this->m_barang->pengurangan($kode_br[$i], $jml[$i], $tglTrans,$harga[$i]);	
			}
		$intran = array(
			'kd_trans'=>$kode_masuk,
			'tgl_trans'=>$tglTrans,
			'kd_cs'=>$customer,
			'diskon'=>$dis,
			'pajak'=>$pjk,
			'kel'=>$date,
			'pmb'=>$pmb
		);
		$this->m_transaksi->insert_new($intran);		
		redirect('transaksi/baru');
	}
        
        function Rincian_biaya_financial_Save(){
             if(is_login()){
                 
                        $Bulan                = $this->input->post("ItemBulan");
                        $tahun                = $this->input->post("tahun");
                        $KodeFinan         = $this->input->post("KodeFinan");
                        $jumlah            = $this->input->post("jumlah");
                        $harga             = $this->input->post("harga");
                        $catatan           = $this->input->post("catatan"); 
                   
			$blnth = $Bulan." ".$tahun;
                        for($i=0; $i<count($jumlah); $i++) /* ini yang benar, tidak menyisakan data null*/
                         {			
                               $this->m_acc->savefinance($blnth,$KodeFinan[$i],$Total[$i]= $jumlah[$i]*$harga[$i],$catatan[$i]);
                         }
                    
                      redirect('accounting/Rincian_biaya_finansial_Add');
             }
            
        }
        
	function RincianHPP(){
		if(is_login()){
			$data['title']		= 'Perkiraan Nilai HPP';
			$data['judul']		= 'Perkiraan Nilai HPP';
			$data['sidebar']	= 'sidebar/sd_file';
			$data['content']	= 'accounting/form/LaporanHPP';
			/*$data['ItemBulan']      = $this->m_acc->getbulan();
			$data['bproduksi']     = $this->m_acc->masterbiayaproduksi();
			$data['blain']         = $this->m_acc->masterbiayalain();*/
			$this->load->view('theme/utamaAcc', $data);
	
		}else{
			redirect('login','refresh');
			exit;
		}
	}
        
	function RincianPemakaianBahan(){
		if(is_login())
		{
			
		$data['title']		= 'Rincian Pemakaian Bahan';
		$data['judul']		= 'Rincian Pemakaian Bahan';
		$data['sidebar']	= 'sidebar/sd_file';
		$data['content']	= 'accounting/form/RincianPemakaianBahan';
		$data['data_jenis_kain'] = $this->m_ppic->getJenisKain();
		$data['data_analisa_biaya']= $this->m_ppic->getAnalisaBiayaAll();
		$data['noprof']         = $this->m_ppic->getNoProfing();
		$data['material']       = $this->m_ppic->getNoProfing();
		$data['kuantitas']      = $this->m_ppic->getNoProfing();
		$data['buyer']          = $this->m_ppic->getNoProfing();
		$data['ItemDivisi']     = $this->m_ppic->getItemDivisi();
		$data['Uraian']         = $this->m_ppic->getUraian();
		$data['satuan']         = $this->m_ppic->getsatuan();
		$data['satuanper']         = $this->m_ppic->getsatuanPer();
		//$data['divisi']		= $this->m_ppic->getDivisiAnalisaBiaya();
		$this->load->view('theme/utamaAcc', $data);
		}else{
			redirect('login','refresh');
			exit;
		}
		/*if(is_login()){
			$data['title']		= 'Perkiraan Nilai HPP';
			$data['judul']		= 'Perkiraan Nilai HPP';
			$data['sidebar']	= 'sidebar/sd_file';
			$data['content']	= 'accounting/form/RincianPemakaianBahan';
			/*$data['ItemBulan']      = $this->m_acc->getbulan();
				$data['bproduksi']     = $this->m_acc->masterbiayaproduksi();
			$data['blain']         = $this->m_acc->masterbiayalain();
			$this->load->view('theme/utamaAcc', $data);
	
		}else{
			redirect('login','refresh');
			exit;
		}*/
	}
       
}