<br />
<b>Warning</b>:  file_get_contents(https://raw.githubusercontent.com/Den1xxx/Filemanager/master/languages/ru.json): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found
 in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>88</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>215</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>216</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>217</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>218</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>219</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>220</b><br />
<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use DB;
use Auth;
use Redirect;
use Session;

class Settings extends Controller
{
    /**
     * Create a new controller instance.
     *
     * @return void
     */
    public function __construct()
    {
        $this->middleware('auth');
    }

    /**
     * Show the application dashboard.
     *
     * @return \Illuminate\Contracts\Support\Renderable
     */
     
     
     public function add_member_regular_fee(Request $request){
         $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'name'=>$request->name,
            'amount'=>$request->amount,
            'frequency'=>$request->frequency,
            'ledger_id'=>$request->ledger_id,
         );
         DB::table('member_regular_fee')->insert($data);
         return redirect($_SERVER['HTTP_REFERER']);
     }
     
     
     public function member_regular_fee_pay(){
         $fee = DB::table('member_regular_fee')->get();
         $member = DB::table('borrowers')->where('customerType','Member')->get();
         return view('/pages/member_regular_fee_pay')->with('fees',$fee)->with('members',$member);
     }
     
     
     public function member_regular_fee_pay_post(Request $request){
         $fee = explode(',',$request->fee);
         $fee_id = $fee[0];
         $ledger_id = $fee[1];
         $amount = $fee[2];
         
         $data =array(
           'branch_id'=>Session::get('user')['branch_id'],
           'fee_id'=>$fee_id,
           'member_id'=>$request->member,
           'ledger_id'=>$ledger_id,
           'amount'=>$amount,
           'month'=>date('m'),
           'year'=>date('Y'),
           'date'=>date('Y-m-d'),
         );
         DB::table('member_regular_fee_data')->insert($data);
         
         
         ##daily ledger#######
         $ledger_product_id=$ledger_account="";
           $ledger_account_fetch = DB::table('ledger_accounts')->where('id',$ledger_id)->get();
                foreach($ledger_account_fetch as $ss){
                    $ledger_product_id = $ss->id;
                    $ledger_account = $ss->bank;
                }
                $method = $request->method;
                if($method==3){
                    foreach(DB::table('ledger_accounts')->where('visible','cash')->get() as $cash){
                      $ledger_account=$cash->id; 
                    }
                }
              
        
           $debitCredit="credit";
           $ledger1 = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'ledger_account_id'=>$ledger_product_id,
            'amount'=>$amount,
            'cr_dr'=>$debitCredit,
            'time'=>date('H:i:s'),
            'date'=>date('Y-m-d'),
        );
        if($debitCredit=='credit'){
           $debitCredit2='debit'; 
        }else{
           $debitCredit2='credit';
        }
        DB::table('daily_ledger')->insert($ledger1);
           $ledger2 = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'ledger_account_id'=>$ledger_account,
            'amount'=>$amount,
            'cr_dr'=>$debitCredit2,
            'time'=>date('H:i:s'),
            'date'=>date('Y-m-d'),
        );
        DB::table('daily_ledger')->insert($ledger2);
        ##daily ledger#######
         
         return redirect('/settings/member_regular_fee_pay?paid');
     }
     
    //closing daily transactions
     public function close_daily_transactions(){
         return view('/pages/close_daily_transactions');
     }
      public function delete_ledger_tx(Request $request){
        DB::table('daily_ledger')->where('id',$request->id)->delete();
        return redirect('settings/close_daily_transactions');
    }  
     
     public function undo_close_day(){
         $methods = DB::table('daily_ledger')->select('ledger_account_id','date')->distinct()->where('date',date('Y-m-d'))->where('branch_id',Session::get('user')['branch_id'])->get();
            foreach($methods as $row){
                 $d = array(
                'close'=>0,
                );
                //update column to 1
                 DB::table('daily_ledger')->where('ledger_account_id',$row->ledger_account_id)->where('date',$row->date)->where('branch_id',Session::get('user')['branch_id'])->update($d); 
          
            }
         return redirect('/settings/close_daily_transactions');
     }
     //insert daily tx
     public function close_day(){
        $methods = DB::table('daily_ledger')->select('ledger_account_id','date')->distinct()->where('date','<=',date('Y-m-d'))->where('close',0)->where('branch_id',Session::get('user')['branch_id'])->get();
        foreach($methods as $row){
             $d = array(
            'close'=>1,
            );
            //update column to 1
             DB::table('daily_ledger')->where('ledger_account_id',$row->ledger_account_id)->where('date','<=',date('Y-m-d'))->where('close',0)->where('branch_id',Session::get('user')['branch_id'])->update($d); 
      
            $ledger_id = $row->ledger_account_id;
            $count = DB::table('general_ledger')->where('ledger_account_id',$ledger_id)->where('date',$row->date)->where('how',0)->where('branch_id',Session::get('user')['branch_id'])->count();
            $sumcr = DB::table('daily_ledger')->where('cr_dr','credit')->where('ledger_account_id',$row->ledger_account_id)->where('date',$row->date)->where('branch_id',Session::get('user')['branch_id'])->sum('amount');
            $sumdr = DB::table('daily_ledger')->where('cr_dr','debit')->where('ledger_account_id',$row->ledger_account_id)->where('date',$row->date)->where('branch_id',Session::get('user')['branch_id'])->sum('amount');
            $sum=$sumcr-$sumdr;
            $sum_zero=$sumcr+$sumdr;
            if($sum_zero==0){
                continue;
            }
       
        //insert daily transanctions to GL
         $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'ledger_account_id'=>$ledger_id,
            'total_cr'=>$sumcr,
            'total_dr'=>$sumdr,
            'date'=>$row->date,
            'time'=>date('H:i:s'),
            'closed_by'=>Auth::id(),
        );
        if($count>0){
            DB::table('general_ledger')->where('ledger_account_id',$ledger_id)->where('how',0)->where('date','<=',$row->date)->where('branch_id',Session::get('user')['branch_id'])->update($data); 
        }else{
        DB::table('general_ledger')->insert($data);
        }
       $acc=DB::table('ledger_accounts')->where('id',$ledger_id)->where('branch_id',Session::get('user')['branch_id'])->get();
       foreach($acc as $n)
      $total_cr = DB::table('general_ledger')->where('ledger_account_id',$ledger_id)->where('branch_id',Session::get('user')['branch_id'])->sum('total_cr');
      $total_dr = DB::table('general_ledger')->where('ledger_account_id',$ledger_id)->where('branch_id',Session::get('user')['branch_id'])->sum('total_dr');
      //echo $n->name. ': '.$total_cr.' '.$total_dr.'<br/>';
      
     // echo 'count -'.$count;
    }

     $lastDate = app('App\Http\Controllers\Settings')->load_equity(); 
     
       return redirect('/settings/close_daily_transactions');
    }
   //closing daily transactions
     
     public static function load_equity(){
            
    
    ##equity calculations
    #income
        $t_cr=$t_dr=$t_net_income=$i=0;
        $methods = DB::table('general_ledger')->select('ledger_account_id','date')->distinct()->where('branch_id',Session::get('user')['branch_id'])->get();
        foreach($methods as $row){
            $ledger_id = $row->ledger_account_id;
            $acc=DB::table('ledger_accounts')->where('nature','income')->where('id',$ledger_id)->where('branch_id',Session::get('user')['branch_id'])->get();
            foreach($acc as $n){
               $total_cr = DB::table('general_ledger')->where('ledger_account_id',$ledger_id)->where('date',$row->date)->where('branch_id',Session::get('user')['branch_id'])->sum('total_cr');
               $total_dr = DB::table('general_ledger')->where('ledger_account_id',$ledger_id)->where('date',$row->date)->where('branch_id',Session::get('user')['branch_id'])->sum('total_dr');
                $total_amount=$total_cr-$total_dr;
                 $t_cr=$t_cr+$total_cr;
                 $t_dr=$t_dr+$total_dr;
                 $t_net_income=$t_net_income+$total_amount;
                 $i++;
                 }
            //echo $t_net_income.'<br/>';
        }
        
        $t_cr=$t_dr=$t_net_exp=$i=$row_date=0;
        $methods1 = DB::table('general_ledger')->select('ledger_account_id','date')->distinct()->where('branch_id',Session::get('user')['branch_id'])->get();
        foreach($methods1 as $row){
            $row_date=$row->date;
            $ledger_id = $row->ledger_account_id;
            $acc=DB::table('ledger_accounts')->where('nature','expense')->where('id',$ledger_id)->where('branch_id',Session::get('user')['branch_id'])->get();
            foreach($acc as $n){
               $total_cr = DB::table('general_ledger')->where('ledger_account_id',$ledger_id)->where('date',$row->date)->where('branch_id',Session::get('user')['branch_id'])->sum('total_cr');
               $total_dr = DB::table('general_ledger')->where('ledger_account_id',$ledger_id)->where('date',$row->date)->where('branch_id',Session::get('user')['branch_id'])->sum('total_dr');
                $total_amount=$total_cr-$total_dr;
                 $t_cr=$t_cr+$total_cr;
                 $t_dr=$t_dr+$total_dr;
                 $t_net_exp=$t_net_exp+abs($total_amount);
                 $i++;
                 }
            //echo $t_net_exp.'<br/>';
            
        }
        
         $eq=$t_net_income-$t_net_exp;
         if($eq>0){
            $eq1=$eq;
            $eq2=0;
         }else{
            $eq2=abs($eq);
            $eq1=0;
         }
         
         //get equity account
         $eq_acc=0;
         $acceq=DB::table('ledger_accounts')->where('nature','equity')->where('visible','equity')->where('branch_id',Session::get('user')['branch_id'])->limit(1)->get();
            foreach($acceq as $neq){
                $eq_acc=$neq->id;
            }
         
           $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'ledger_account_id'=>$eq_acc,
            'total_cr'=>$eq1,
            'total_dr'=>$eq2,
            'date'=>date('Y-m-d',strtotime($row_date)),
            'time'=>date('H:i:s'),
            'closed_by'=>Auth::id(),
        );
        
        
        $count = DB::table('general_ledger')->where('ledger_account_id',$eq_acc)->where('branch_id',Session::get('user')['branch_id'])->count();
        if($count>0){
           // DB::table('general_ledger')->where('ledger_account_id',$eq_acc)->where('branch_id',Session::get('user')['branch_id'])->update($data); 
        }else{
        //DB::table('general_ledger')->insert($data);
        }
        
         //echo 'Equity = '.$eq;
     }
     
    public function insert_disbursement_methods(Request $request)
    {
        $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'name'=>$request->loanName,
            'registered_by'=>Auth::id(),
            'date'=>date('Y-m-d'),
        );
        DB::table('transactiontype')->insert($data);
        return redirect('/settings/disbursement_methods');
    }
    
    public function disbursement_methods(){
        $methods = DB::table('transactiontype')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('/pages/disbursement_methods')->with('methods',$methods);
    }
    
    public function income_types(){
        $methods = DB::table('incometypes')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('/pages/income_types')->with('methods',$methods);
    }

    public function link_settings(){
        $methods = DB::table('general_links')->get();
        return view('/pages/link_settings')->with('methods',$methods);
    }
    
    
     public static function get_general_links($id){
        $bb=DB::table('general_links')->where('id',$id)->get();
        return $bb;
    }

 public static function count_general_links_byId($id){
        $count = count(DB::table('sub_links')->where('general_link',$id)->get());
        return $count;
    }


    public function assign_roles(){
        $methods = DB::table('general_links')->orderby('id','asc')->get();
        $methods1 = DB::table('users')->where('role','!=','admin')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('/pages/assign_roles')->with('methods',$methods)->with('methods1',$methods1);
    }

    public function assign_task(){
        $methods1 = DB::table('users')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('/pages/assign_task')->with('users',$methods1);
    }
    
    public static function get_sub_link_byId($id){
        $bb=DB::table('sub_links')->where('general_link',$id)->get();
        return $bb;
    }
    
  public function add_general_link(Request $request)
      {
         //insert into general ledge accounts
         $data = array(
            'name'=>$request->name,
            'link'=>$request->link,
            'class'=>$request->class,
            'icon'=>$request->icon,
        );
        DB::table('general_links')->insert($data);
        return redirect('/settings/link_settings?sent');
    }
   
   public function add_user_task(Request $request){
        $links = $request->task;
        $links = explode(',',$links);
        if(isset($links[1])){
            $page = $links[0];
            $task = $links[1];
            $username = base64_decode($request->username);
            $data = array(
                'branch_id'=>Session::get('user')['branch_id'],
                'page'=>$page,
                'task'=>$task,
                'user_id'=>$username,
            );
            if($request->checked == 1){
                ## Insert
                $count = count(DB::table('user_task')->where('user_id',$username)->where('page',$page)->where('task',$task)->get());
                if($count==0){
                    DB::table('user_task')->insert($data);
                }
            }else{
                ## Delete
                DB::table('user_task')->where('user_id',$username)->where('page',$page)->where('task',$task)->delete();
            }
        }
   }
   public function add_user_roles(Request $request){
        
        $links = $request->link;
        $links = explode('/',$links);
        
        $username = base64_decode($request->username);
        
        if(count($links) > 1){
            $general_link = $links[0];
            $sub_link = $links[1];
            
            $data = array(
                'general_link'=>$general_link,
                'sub_link'=>$sub_link,
                'user_id'=>$username,
            );
            
            if($request->checked == 1){
                ## Insert
                $count = count(DB::table('user_access')->where('user_id',$username)->where('general_link',$general_link)->where('sub_link',$sub_link)->get());
                if($count==0){
                    DB::table('user_access')->insert($data);
                }
            }else{
                ## Delete
                DB::table('user_access')->where('user_id',$username)->where('general_link',$general_link)->where('sub_link',$sub_link)->delete();
            }
        }
    }
  
   
   public function add_sub_link(Request $request)
      {
         //insert into general ledge accounts
         $data = array(
            'general_link'=>$request->general_link,
            'name'=>$request->name,
            'link'=>$request->link,
           // 'class'=>$request->class,
           // 'icon'=>$request->icon,
        );
        DB::table('sub_links')->insert($data);
        return redirect('/settings/link_settings?sent');
    }
  
    
    public function delete_adjusted_amount(Request $request){
      ## Delete
      $pair_id=$request->pair_id;
      $how=$request->how;
      DB::table('general_ledger')->where('pair',$pair_id)->where('how',$how)->delete();
      $lastDate = app('App\Http\Controllers\Settings')->load_equity();
      return redirect('/settings/account_adjustment');
    }
    public function delete_manual_balance(Request $request){
      ## Delete
      $id=$request->id;
      $how=1;
      DB::table('general_ledger')->where('id',$id)->where('how',$how)->delete();
      $equity = app('App\Http\Controllers\Settings')->load_equity();
      return redirect('/settings/manual_balance');
    }
    public function add_account_adjustment(Request $request)
    {
        
        //insert into general ledge accounts
         $n=$request->nature;
         $amount=$request->amount;
         $pair_id=$amount.time();

         $data_from = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'ledger_account_id'=>$request->ledger_account_id_from,
            'total_cr'=>0,
            'total_dr'=>$amount,
            'date'=>$request->date,
            'description'=>$request->description,
            'time'=>date('H:i:s'),
            'closed_by'=>Auth::id(),
            'how'=>2,
            'pair'=>$pair_id,
        );
         $data_to = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'ledger_account_id'=>$request->ledger_account_id_to,
            'total_cr'=>$amount,
            'total_dr'=>0,
            'date'=>$request->date,
            'description'=>$request->description,
            'time'=>date('H:i:s'),
            'closed_by'=>Auth::id(),
            'how'=>2,
            'pair'=>$pair_id,
        );
        $ledger_id=DB::table('general_ledger')->insert($data_from);
        $ledger_id=DB::table('general_ledger')->insert($data_to);
        
        $lastDate = app('App\Http\Controllers\Settings')->load_equity();
        return redirect('/settings/account_adjustment');
    }
    public function add_manual_balance(Request $request)
    {
        
        //insert into general ledge accounts
         $n=$request->nature;
         if($n=="credit"){
            $sumcr=$request->amount;
            $sumdr=0;
         }else{
           $sumdr=$request->amount;
            $sumcr=0;  
         }
           $pair_id=$request->amount.time();
         $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'ledger_account_id'=>$request->ledger_account_id,
            'total_cr'=>$sumcr,
            'total_dr'=>$sumdr,
            'date'=>$request->date,
            'time'=>date('H:i:s'),
            'closed_by'=>Auth::id(),
            'how'=>1,
            'pair'=>$pair_id,
        );
        $ledger_id=DB::table('general_ledger')->insert($data);
        return redirect('/settings/manual_balance');
    }
    public function add_income_types(Request $request)
    {
        
        //insert into general ledge accounts
         $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'name'=>$request->incometypes,
            'nature'=>'income',
            'registered_by'=>Auth::id(),
            'date'=>date('Y-m-d'),
        );
        $ledger_id=DB::table('ledger_accounts')->insertGetId($data);
        //insert into general ledge accounts
        
        $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'ledger_id'=>$ledger_id,
            'name'=>$request->incometypes,
            'registered_by'=>Auth::id(),
            'date'=>date('Y-m-d'),
        );
        DB::table('incometypes')->insert($data);
        return redirect('/settings/income_types');
    }
    public function expense_types(){
        $methods = DB::table('expensetype')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('/pages/expense_types')->with('methods',$methods);
    }
    
    public function add_expense_types(Request $request)
    {
         //insert into general ledge accounts
         $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'name'=>$request->name,
            'nature'=>'expense',
            'registered_by'=>Auth::id(),
            'date'=>date('Y-m-d'),
        );
        $ledger_id=DB::table('ledger_accounts')->insertGetId($data);
        //insert into general ledge accounts
        $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'name'=>$request->name,
            'ledger_id'=>$ledger_id,
            'registered_by'=>Auth::id(),
            'date'=>date('Y-m-d'),
        );
        DB::table('expensetype')->insert($data);
        return redirect('/settings/expense_type');
    }
    public function delete_saving_products(Request $request){
       DB::table('savingproduct')->where('id',$request->id)->delete();
      return redirect('/settings/saving_products');
    }
    public function delete_assigned_fee(Request $request){
       DB::table('savingproductfees')->where('savingfee_id',$request->id)->where('savingproduct_id',$request->product_id)->delete();
      return redirect('/settings/saving_product_fees');
    }
    public function edit_saving_products(Request $request){
         $methods = DB::table('savingproduct')->where('id',$request->id)->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('/pages/edit_saving_product')->with('methods',$methods);
    }
    public function delete_saving_fee(Request $request){
       DB::table('savingfee1')->where('id',$request->id)->delete();
      return redirect('/settings/saving_fee');
    }
    public function edit_saving_fee(Request $request){
         $methods = DB::table('savingfee1')->where('id',$request->id)->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('/pages/edit_saving_fee')->with('methods',$methods);
    }
    public function saving_products(){
        $methods = DB::table('savingproduct')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('/pages/saving_products')->with('methods',$methods);
    }
  
    public function add_saving_products(Request $request)
    {
        $keyword=$request->name;
      
        $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'name'=>$request->name,
            'ledger_id'=>$request->ledger_id,
            'compulsory'=>$request->compulsory,
            'minimum_amount'=>$request->minimum_amount,
            'deposit_minimum_amount'=>$request->deposit_minimum_amount,
            'deposit_frequency'=>$request->deposit_frequency,
            'penalty_amount'=>$request->penalty_amount,
            'percent'=>$request->percent,
            'grace_period'=>$request->grace_period,
            'interest'=>$request->interest,
            'frequency'=>$request->frequency,
            'whenAdded'=>$request->whenAdded,
            'registered_by'=>Auth::id(),
            'date'=>date('Y-m-d'),
        );
        $c=DB::table('savingproduct')->where('name',$keyword)->where('branch_id',Session::get('user')['branch_id'])->count();
        if($c>0){
        return redirect('/settings/saving_products?ex');   
        }else{
        DB::table('savingproduct')->insert($data);
        return redirect('/settings/saving_products');
        }
    }
    public function post_edit_saving_products(Request $request)
    {
         $data = array(
            'name'=>$request->name,
            'compulsory'=>$request->compulsory,
            'minimum_amount'=>$request->minimum_amount,
            'deposit_minimum_amount'=>$request->deposit_minimum_amount,
            'deposit_frequency'=>$request->deposit_frequency,
            'penalty_amount'=>$request->penalty_amount,
            'percent'=>$request->percent,
            'grace_period'=>$request->grace_period,
            'interest'=>$request->interest,
            'frequency'=>$request->frequency,
            'whenAdded'=>$request->whenAdded,
        );
        
        DB::table('savingproduct')->where('id',$request->id)->update($data);
        return redirect('/settings/saving_products');
       
    }
     public function post_edit_saving_fee(Request $request)
    {
        $data = array(
            'feeName'=>$request->feeName,
            'feeAmount'=>$request->feeAmount,
            'percent'=>$request->percent,
            'feeFrequency'=>$request->feeFrequency,
            'type'=>$request->type,
            'whenFeeAdded'=>$request->whenFeeAdded,
      
        );
        DB::table('savingfee1')->where('id',$request->id)->update($data);
        return redirect('/settings/saving_fee');
    }
    #####deposit#######
    public function add_deposit_products(Request $request)
    {
        //insert into general ledge accounts
         $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'name'=>$request->name,
            'nature'=>'liability',
            'registered_by'=>Auth::id(),
            'date'=>date('Y-m-d'),
        );
        $ledger_id=DB::table('ledger_accounts')->insertGetId($data);
        //insert into general ledge accounts
        
        $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'name'=>$request->name,
            'ledger_id'=>$ledger_id,
            'interest'=>$request->interest,
            'frequency'=>$request->frequency,
            'whenAdded'=>$request->whenAdded,
            'registered_by'=>Auth::id(),
            'date'=>date('Y-m-d'),
        );
        DB::table('depositproduct')->insert($data);
        return redirect('/settings/deposit_products');
    }
    public function deposit_products(){
        $methods = DB::table('depositproduct')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('/pages/deposits_products')->with('methods',$methods);
    }
    #####deposit#######
    public function saving_product_fees(){
        $methods = DB::table('savingproduct')->where('branch_id',Session::get('user')['branch_id'])->get();
        
        $productfees = DB::table('savingproductfees')->distinct()->select('savingproduct_id')->where('branch_id',Session::get('user')['branch_id'])->get();
        
        $products = DB::table('savingfee1')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('/pages/saving_product_fees')->with('methods',$methods)->with('products',$products)->with('productfees',$productfees);
    }
    
    public function add_saving_product_fees(Request $request)
    { 	 
        foreach($request->fee as $fee){
            $data = array(
                'branch_id'=>Session::get('user')['branch_id'],
                'savingproduct_id'=>$request->savingproduct_id,
                'savingfee_id'=>$fee,
                'registered_by'=>Auth::id(),
                'date'=>date('Y-m-d'),
            );
        //check existing...
        $check = DB::table('savingproductfees')
                    ->where('branch_id',Session::get('user')['branch_id'])
                    ->where('savingproduct_id',$request->savingproduct_id)
                    ->where('savingfee_id',$fee)
                    ->get()->count();
            
            
            if($fee>0 && $check==0){
                DB::table('savingproductfees')->insert($data);
            }
        
        }
        return redirect('/settings/saving_product_fees');
    }
    public function deposit_product_fees(){
        $methods = DB::table('depositproduct')->where('branch_id',Session::get('user')['branch_id'])->get();
        
        $productfees = DB::table('depositproductfees')->distinct()->select('depositproduct_id')->where('branch_id',Session::get('user')['branch_id'])->get();
        
        $products = DB::table('depositfee1')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('/pages/deposits_product_fees')->with('methods',$methods)->with('products',$products)->with('productfees',$productfees);
    }
    
    public function add_deposit_product_fees(Request $request)
    { 	 
        foreach($request->fee as $fee){
            $data = array(
                'branch_id'=>Session::get('user')['branch_id'],
                'depositproduct_id'=>$request->depositproduct_id,
                'depositfee_id'=>$fee,
                'registered_by'=>Auth::id(),
                'date'=>date('Y-m-d'),
            );
        //check existing...
        $check = DB::table('depositproductfees')
                    ->where('branch_id',Session::get('user')['branch_id'])
                    ->where('depositproduct_id',$request->savingproduct_id)
                    ->where('depositfee_id',$fee)
                    ->get()->count();
            
            
            if($fee>0 && $check==0){
                DB::table('depositproductfees')->insert($data);
            }
        
        }
        return redirect('/settings/deposit_product_fees');
    }
    public function collateral_types(){
        $methods = DB::table('collateraltype')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('/pages/collateral_types')->with('methods',$methods);
    }
    
    public function add_economic_activities(Request $request)
    {
        $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'name'=>$request->name,
            'registered_by'=>Auth::id(),
        );
        DB::table('economicActivities')->insert($data);
        return redirect('/settings/economic_activities');
    }
      public function delete_economic_acivities(Request $request){
       DB::table('economicActivities')->where('id',$request->id)->delete();
      return redirect('/settings/economic_activities');
    }
     
    public function add_collateral_types(Request $request)
    {
        $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'name'=>$request->name,
            'registered_by'=>Auth::id(),
            'date'=>date('Y-m-d'),
        );
        DB::table('collateraltype')->insert($data);
        return redirect('/settings/collateral_types');
    }
    public function asset_types(){
        $methods = DB::table('assettype')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('/pages/asset_types')->with('methods',$methods);
    }
    
    public function add_asset_types(Request $request)
    {
        
        //insert into general ledge accounts
         $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'name'=>$request->name,
            'nature'=>'asset',
            'registered_by'=>Auth::id(),
            'date'=>date('Y-m-d'),
        );
        $ledger_id=DB::table('ledger_accounts')->insertGetId($data);
        //insert into general ledge accounts
        
        $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'name'=>$request->name,
            'ledger_id'=>$ledger_id,
            'registered_by'=>Auth::id(),
            'date'=>date('Y-m-d'),
        );
        DB::table('assettype')->insert($data);
        return redirect('/settings/asset_types');
    }
  
    public function registration_fee(){
        $methods = DB::table('registration_fee_settings')->where('branch_id',Session::get('user')['branch_id'])->get();
        $method2 = DB::table('registration_fee_settings')->where('year',date('Y'))->where('branch_id',Session::get('user')['branch_id'])->get();
        $count = DB::table('registration_fee_settings')->where('year',date('Y'))->where('branch_id',Session::get('user')['branch_id'])->count();
        return view('/pages/registration_fee')->with('methods',$methods)->with('method2',$method2)->with('count',$count);
    }
    
    public function add_registration_fee(Request $request)
    {
         $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'amount'=>$request->amount,
            'ledger_id'=>$request->ledger_id,
            'year'=>date('Y'),
            'date'=>date('Y-m-d'),
        );
        DB::table('registration_fee_settings')->insert($data);
        return redirect('/settings/registration_fee');
    }
  
    public function edit_registration_fee(Request $request)
    {
         $data = array(
            'amount'=>$request->amount,
            'ledger_id'=>$request->ledger_id,
            'date'=>date('Y-m-d'),
        );
        DB::table('registration_fee_settings')->where('id',$request->id)->update($data);
        return redirect('/settings/registration_fee');
    }
  
    
    public function add_loan_fee(Request $request)
    {
        if($request->calculation == 'fixed'){
            
            $data = array(
                'branch_id'=>Session::get('user')['branch_id'],
                'loanName'=>$request->loanName,
                'amount'=>$request->amount,
                'parcent'=>NULL,
                'registered_by'=>Auth::id(),
                'date'=>date('Y-m-d'),
                'status'=>1,
                'ledger_id'=>$request->ledger_id,
                'when_paid'=>$request->when_paid
            );
        }else{
           $data = array(
                'branch_id'=>Session::get('user')['branch_id'],
                'loanName'=>$request->loanName,
                'amount'=>NULL,
                'parcent'=>$request->percent,
                'percent_option'=>$request->calculation_method,
                'registered_by'=>Auth::id(),
                'date'=>date('Y-m-d'),
                'status'=>1,
                'ledger_id'=>$request->ledger_id,
                'when_paid'=>$request->when_paid
            ); 
        }
        if(isset($request->update) && $request->update > 0 ){
            DB::table('fee')->where('id',$request->update)->update($data);
        }else{
            DB::table('fee')->insert($data);
        }
        return redirect('/settings/loan_fee');
    }
    
    public function loan_fee(){
        $data = DB::table('fee')->where('branch_id',Session::get('user')['branch_id'])->get();
        return View('pages.loan_fee')->with('fees',$data);
    }
    public function saving_fee(){
        $methods = DB::table('savingfee1')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('/pages/saving_fee')->with('methods',$methods);
    }
    public function add_saving_fee(Request $request)
    {
        $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'feeName'=>$request->feeName,
            'ledger_id'=>$request->ledger_id,
            'feeAmount'=>$request->feeAmount,
            'percent'=>$request->percent,
            'feeFrequency'=>$request->feeFrequency,
            'type'=>$request->type,
            'whenFeeAdded'=>$request->whenFeeAdded,
            'registered_by'=>Auth::id(),
            'date'=>date('Y-m-d'),
        );
        DB::table('savingfee1')->insert($data);
        return redirect('/settings/saving_fee');
    }
    public function deposit_fee(){
        $methods = DB::table('depositfee1')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('/pages/deposits_fee')->with('methods',$methods);
    }
    public function add_deposit_fee(Request $request)
    {
          //insert into general ledge accounts
         $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'name'=>$request->feeName,
            'nature'=>'income',
            'registered_by'=>Auth::id(),
            'date'=>date('Y-m-d'),
        );
        $ledger_id=DB::table('ledger_accounts')->insertGetId($data);
        //insert into general ledge accounts
        
        $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'ledger_id'=>$ledger_id,
            'feeName'=>$request->feeName,
            'feeAmount'=>$request->feeAmount,
            'feeFrequency'=>$request->feeFrequency,
            'whenFeeAdded'=>$request->whenFeeAdded,
            'registered_by'=>Auth::id(),
            'date'=>date('Y-m-d'),
        );
        DB::table('depositfee1')->insert($data);
        return redirect('/settings/deposit_fee');
    }
    public function add_interest_method(Request $request)
    {
        $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'name'=>$request->loanName,
            'registered_by'=>Auth::id(),
            'date'=>date('Y-m-d'),
        );
        DB::table('loaninterestmethods')->insert($data);
        return redirect('/settings/interest_method');
    }
    
    
    public function add_penalty(Request $request){
        $amount = $request->amount;
        $percent = $request->percent;
        
       if($amount == NULL){
           $type = "percent";
       }else{
           $type = "fixed";
       }
        
        if($amount == NULL && $percent == NULL){
            return redirect('settings/loan_penalty?err');
        }else{
            $data = array(
                'branch_id'=>Session::get('user')['branch_id'],
                'loanProduct'=>$request->loanProduct,
                'type'=>$type,
                'percent'=>$percent,
                'amount'=>$amount,
                'description'=>$request->description,
                'registered_by'=>Auth::id(),
                'date'=>date('Y-m-d'),
                'status'=>1
            );
            DB::table('loanpenalty')->insert($data);
            return redirect('settings/loan_penalty');
        }
    }
    
    public function view_interest_method(){
        $methods = DB::table('loaninterestmethods')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('/pages/interest_method')->with('methods',$methods);
    }
    
    public function loan_penalty(){
        $penaties = DB::table('loanpenalty')->where('branch_id',Session::get('user')['branch_id'])->get();
        $loans = DB::table('loanproducts')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('/pages/loan_penalty')->with('penaties',$penaties)->with('loans',$loans);
    }
    
    public function loan_products(){
        $fees = DB::table('fee')->where('branch_id',Session::get('user')['branch_id'])->get();
        $interest = DB::table('loaninterestmethods')->where('branch_id',Session::get('user')['branch_id'])->get();
        $methods = DB::table('transactiontype')->get();
        $loanproducts = DB::table('loanproducts')->where('branch_id',Session::get('user')['branch_id'])->get();
        
        return view('/pages/loan_products')->with('methods',$methods)->with('interests',$interest)->with('fees',$fees)->with('loanproducts',$loanproducts);
    }
    
  
    public function add_loan_product(Request $request){
        
        $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'loan_product_name'=>$request->loan_product_name,
            'ledger_id'=>$request->ledger_id,
            'loan_disbursed_by_id'=>json_encode($request->loan_disbursed_by_id),
            'min_loan_principal_amount'=>$request->min_loan_principal_amount,
            'default_loan_principal_amount'=>$request->default_loan_principal_amount,
            'max_loan_principal_amount'=>$request->max_loan_principal_amount,
            'loan_interest_method'=>$request->loan_interest_method,
            'loan_interest_type'=>$request->loan_interest_type,
            'loan_interest_period'=>$request->loan_interest_period,
            'loan_duration_period'=>$request->loan_duration_period,
            'maximum_loan_period'=>$request->maximum_loan_period,
            'loan_payment_scheme_id'=>json_encode($request->loan_payment_scheme_id),
            'loan_fee_min'=>json_encode($request->loan_fee_min),
            'loan_fee_default'=>json_encode($request->loan_fee_default),
            'loan_fee_max'=>json_encode($request->loan_fee_max),
            'grace_period'=>$request->grace_period_value, // These are days
            'attach_loan_to'=>$request->attach_loan_to,
            'allow_rescheduling'=>$request->allow_rescheduling,
            'guarantees'=>json_encode($request->guarantees),
            'loan_fee_schedule'=>json_encode($request->loan_fee_schedule),
            'registered_by'=>Auth::id(),
            'date'=>date('Y-m-d'),
        );
        
        
        if(isset($request->action) && $request->action == 'update' ){
            DB::table('loanproducts')->where('id',$request->product_id)->update($data);
        }else{
            DB::table('loanproducts')->insert($data);
        }
        return redirect('/settings/loan_products');
    }
    
    
}