<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 Share extends Controller
{
    public function add(Request $request){
        $max=$min=0;
        ## Each investiment will be treated separately during profit calculations
        $setting = DB::table('shareSettings')->where('id',$request->type)->where('branch_id',Session::get('user')['branch_id'])->get();
        foreach($setting as $row){
            $max=$row->max;
            $min=$row->min;
        }
        $sum_amount_of_all=1;
        $sum_of_all = DB::table('shareholders')->select(DB::raw('SUM(amount) as amount'))->where('id',$request->type)->where('branch_id',Session::get('user')['branch_id'])->get();
        foreach($sum_of_all as $rows){
            $sum_amount_of_all=$rows->amount+$request->currentValue;
        }
        
         $sum_of_single = DB::table('shareholders')->select(DB::raw('SUM(amount) as amount'))->where('id',$request->type)->where('member_id',$request->borrower_id)->where('branch_id',Session::get('user')['branch_id'])->get();
            foreach($sum_of_single as $rows){
                $sum_of_single=$rows->amount+$request->currentValue;
            }
          
        $sum_of_single1 = DB::table('shareholders')->select(DB::raw('SUM(amount) as amount'))->where('id',$request->type)->where('member_id',$request->borrower_id)->where('branch_id',Session::get('user')['branch_id'])->get();
            foreach($sum_of_single1 as $rows){
                $sum_of_single1=$rows->amount;
            }
              
      if($sum_of_single>=$min){      
        $shareholders = count(DB::table('shareholders')->where('share_type',$request->type)->where('branch_id',Session::get('user')['branch_id'])->get());
        $amount_repaid=$request->currentValue;
       // echo $shareholders;exit;
        
        if($shareholders>0){
            
                $min_percent=($min/$sum_amount_of_all)*100;
                
                //echo "hh"; exit;
                
                $number=$sum_amount_of_all/$min;
              // echo $min_percent.' '.$number.' '.$shareholders;exit;
                if($number<=$shareholders){
                    $data = array(    
                        'branch_id'=>Session::get('user')['branch_id'],
                        'member_id'=>$request->borrower_id,
                        'share_type'=>$request->type,
                        'amount'=>$request->currentValue,
                        'valueDate'=>$request->valueDate,
                        'registeredBy'=>Auth::id(),
                        'date'=>date('Y-m-d'),
                    );
                    
                    if($sum_of_single1>0){
                      //  echo 'here';exit;
                        $data = array(    
                            'branch_id'=>Session::get('user')['branch_id'],
                            'member_id'=>$request->borrower_id,
                            'share_type'=>$request->type,
                            'amount'=>$request->currentValue+$sum_of_single,
                            'valueDate'=>$request->valueDate,
                            'registeredBy'=>Auth::id(),
                            'date'=>date('Y-m-d'),
                        );
                        DB::table('shareholders')->where('id',$request->type)->where('member_id',$request->borrower_id)->update($data);  
                    }else{
                        DB::table('shareholders')->insert($data);  
                    }
                    
                       #check payment methods for the ledger queries
                       

                        if($request->method==3){
                           $ledger_account=17; 
                        }else{
                          $ledger_account=18;   
                        }
                        #end
                        #debit cash/bank account of the total amount repaid
                            $ledgerBc = array(
                                'branch_id'=>Session::get('user')['branch_id'],
                                'ledger_account_id'=>$ledger_account,
                                'amount'=>$amount_repaid,
                                'cr_dr'=>'debit',
                                'time'=>date('H:i:s'),
                                'date'=>date('Y-m-d'),
                             );
                            DB::table('daily_ledger')->insert($ledgerBc);
                            #credit member shares account
                              $ledgerMc = array(
                                    'branch_id'=>Session::get('user')['branch_id'],
                                    'ledger_account_id'=>29,
                                    'amount'=>$amount_repaid,
                                    'cr_dr'=>'credit',
                                    'time'=>date('H:i:s'),
                                    'date'=>date('Y-m-d'),
                                );
                                DB::table('daily_ledger')->insert($ledgerMc);
                        #end
                    
                    return redirect('/share/add_shareholder?sent');
                }else{
    
                    $sum_of_single = DB::table('shareholders')->select(DB::raw('SUM(amount) as amount'))->where('id',$request->type)->where('member_id',$request->borrower_id)->where('branch_id',Session::get('user')['branch_id'])->get();
                    foreach($sum_of_single as $rows){
                        $sum_of_single=$rows->amount+$request->currentValue;
                        
                    }
                    $percent=($sum_of_single/$sum_amount_of_all)*100;
                    
                    //echo 'hapa';exit;
                
                    if($max<=$percent && $sum_of_single>=$min){
                        $data = array(    
                            'branch_id'=>Session::get('user')['branch_id'],
                            'member_id'=>$request->borrower_id,
                            'share_type'=>$request->type,
                            'amount'=>$request->currentValue,
                            'valueDate'=>$request->valueDate,
                            'registeredBy'=>Auth::id(),
                            'date'=>date('Y-m-d'),
                        );
                        
                        if($sum_of_single1>0){
                            //echo 'humu';exit;
                            $data = array(    
                                'branch_id'=>Session::get('user')['branch_id'],
                                'member_id'=>$request->borrower_id,
                                'share_type'=>$request->type,
                                'amount'=>$request->currentValue+$sum_of_single,
                                'valueDate'=>$request->valueDate,
                                'registeredBy'=>Auth::id(),
                                'date'=>date('Y-m-d'),
                            );
                            DB::table('shareholders')->where('id',$request->type)->where('member_id',$request->borrower_id)->update($data);  
                        }else{
                            DB::table('shareholders')->insert($data);  
                        }
                        
                        #check payment methods for the ledger queries
                        if($request->method==3){
                           $ledger_account=17; 
                        }else{
                          $ledger_account=18;   
                        }
                        #end
                        #debit cash/bank account of the total amount repaid
                            $ledgerBc = array(
                                'branch_id'=>Session::get('user')['branch_id'],
                                'ledger_account_id'=>$ledger_account,
                                'amount'=>$amount_repaid,
                                'cr_dr'=>'debit',
                                'time'=>date('H:i:s'),
                                'date'=>date('Y-m-d'),
                             );
                            DB::table('daily_ledger')->insert($ledgerBc);
                            #credit member shares account
                              $ledgerMc = array(
                                    'branch_id'=>Session::get('user')['branch_id'],
                                    'ledger_account_id'=>29,
                                    'amount'=>$amount_repaid,
                                    'cr_dr'=>'credit',
                                    'time'=>date('H:i:s'),
                                    'date'=>date('Y-m-d'),
                                );
                                DB::table('daily_ledger')->insert($ledgerMc);
                        #end
         
                        
                        return redirect('/share/add_shareholder?sent');

                    }else{
                        return redirect('/share/add_shareholder?error&amount='.base64_encode($min));
                    }
                } 
        }else{
          
        $data = array(    
            'branch_id'=>Session::get('user')['branch_id'],
            'member_id'=>$request->borrower_id,
            'share_type'=>$request->type,
            'amount'=>$request->currentValue,
            'valueDate'=>$request->valueDate,
            'registeredBy'=>Auth::id(),
            'date'=>date('Y-m-d'),
        );
        DB::table('shareholders')->insert($data);  
         return redirect('/share/add_shareholder?sent');
         
        #check payment methods for the ledger queries
        if($request->method==3){
           $ledger_account=17; 
        }else{
          $ledger_account=18;   
        }
        #end
        #debit cash/bank account of the total amount repaid
            $ledgerBc = array(
                'branch_id'=>Session::get('user')['branch_id'],
                'ledger_account_id'=>$ledger_account,
                'amount'=>$amount_repaid,
                'cr_dr'=>'debit',
                'time'=>date('H:i:s'),
                'date'=>date('Y-m-d'),
             );
            DB::table('daily_ledger')->insert($ledgerBc);
            #credit member shares account
              $ledgerMc = array(
                    'branch_id'=>Session::get('user')['branch_id'],
                    'ledger_account_id'=>29,
                    'amount'=>$amount_repaid,
                    'cr_dr'=>'credit',
                    'time'=>date('H:i:s'),
                    'date'=>date('Y-m-d'),
                );
                DB::table('daily_ledger')->insert($ledgerMc);
        #end
         
        }
      }else{
        return redirect('/share/add_shareholder?error1&share='.base64_encode($max));
      }
        
    }
    
    public function add_shareholder(){
        $borrowers = DB::table('borrowers')->where('customerType','Member')->where('branch_id',Session::get('user')['branch_id'])->get();
        $groups = DB::table('borrowergroups')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('pages.add_shareholder')->with('groups',$groups)->with('borrowers',$borrowers);
    }
    
    public function upload_excel_share(){
        $borrowers = DB::table('borrowers')->where('customerType','Member')->where('branch_id',Session::get('user')['branch_id'])->get();
        $groups = DB::table('borrowergroups')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('pages.upload_excel_share')->with('groups',$groups)->with('borrowers',$borrowers);
    }
    
    public function add_share_account(){
          //get account Number
            function generateRandomNumber($length = 6) {
                    $number = '1234567890';
                    $numberLength = strlen($number);
                    $randomNumber = '';
                    for ($i = 0; $i < $length; $i++) {
                        $randomNumber .= $number[rand(0, $numberLength - 1)];
                    }
                    $randomNumber='S00'.$randomNumber;
                    $count = DB::table('shareaccount')->where('account', $randomNumber)->get()->count();
                    if($count>0){
                      generateRandomNumber();  
                    }else{
                       return $randomNumber;  
                    }
                }
        $accountNumber = generateRandomNumber();
                
        $borrowers = DB::table('borrowers')->where('customerType','Member')->where('branch_id',Session::get('user')['branch_id'])->get();
        $groups = DB::table('borrowergroups')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('pages.add_share_account')->with('groups',$groups)->with('borrowers',$borrowers)->with('accountNumber',$accountNumber);
    }
    
     public function post_share_account(Request $request){
       $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'borrower_id'=>$request->borrower_id,
            'shareType'=>$request->shareType,
            'account'=>$request->account_number,
            'registered_by'=>Auth::id(),
            'date'=>date('Y-m-d'),
        );
        DB::table('shareaccount')->insert($data);         
                
       return redirect('/share/add_share_account?sent');      
                
                
     }
     public function add_shares(Request $request){
             //explode values...
             $ifsacoss=$request->account_id2;
             $v=explode('/',$request->account_id);
             $account_id=$v[0];
             $shareprice=$v[1];
             $member_id=$v[2];
             $share_type=$v[3];
             $shares=$request->amount/$shareprice;
             $batch_id = 'SH-'.rand().'-'.time();
             $data = array(    
                'branch_id'=>Session::get('user')['branch_id'],
                'member_id'=>$member_id,
                'account_id'=>$account_id,
                'share_type'=>$share_type,
                'amount'=>$request->amount,
                'shareprice'=>$shareprice,
                'shares'=>$shares,
                'purchase_sell'=>$request->purchasesell,
                'method'=>$request->method,
                'batch'=>$batch_id,
                'registeredBy'=>Auth::id(),
                'date'=>date('Y-m-d'),
            );
            if($ifsacoss!='saccos'){
                 $v=explode('/',$request->account_id2);
                 $account_id2=$v[0];
                 $shareprice=$v[1];
                 $member_id2=$v[2];
                 $share_type=$v[3];
              if($request->purchasesell=='sell'){
                  $sp='purchase';
              }else{
                 $sp='sell';  
              }
                
               $data2 = array(    
                'branch_id'=>Session::get('user')['branch_id'],
                'member_id'=>$member_id2,
                'account_id'=>$account_id2,
                'share_type'=>$share_type,
                'amount'=>$request->amount,
                'shareprice'=>$shareprice,
                'shares'=>$shares,
                'purchase/sell'=>$sp,
                'method'=>$request->method,
                'batch'=>$batch_id,
                'registeredBy'=>Auth::id(),
                'date'=>date('Y-m-d'),
            ); 
            DB::table('shareholders')->insert($data2);
            }
            
            if($request->method=='transfer'){
                $accfrom=$request->accountfrom;
                $accto=$request->accountto;
                
                 $savings = app('App\Http\Controllers\Load')::transact_savings($request->amount,$accfrom,$accto);
            }
            
            // DB::table('shareholders')->where('id',$request->type)->where('member_id',$request->borrower_id)->update($data);  
            DB::table('shareholders')->insert($data);
            $source_id=DB::getPdo()->lastInsertId();
            
            #check payment methods for the ledger queries
                    $ledger_account_fetch = DB::table('shareSettings')->where('shareSettings.id',$share_type)
                    ->join('ledger_accounts','shareSettings.ledger_id','=','ledger_accounts.id')->get();
                    foreach($ledger_account_fetch as $ss){
                        $ledger_product_id = $ss->ledger_id;
                        $ledger_account = $ss->bank;
                    }
                    $method = $request->method;
                    if($method==3){
                        foreach(DB::table('ledger_accounts')->where('visible','cash')->where('branch_id',Session::get('user')['branch_id'])->get() as $cash){
                          $ledger_account=$cash->id; 
                        }
                    }
                   

                #end
                #debit cash/bank account of the total amount repaid
                    $ledgerBc = array(
                        'branch_id'=>Session::get('user')['branch_id'],
                        'ledger_account_id'=>$ledger_account,
                        'amount'=>$request->amount,
                        'batch_id'=>$batch_id,
                        'ledger_source_id'=>$source_id,
                        'cr_dr'=>'debit',
                        'time'=>date('H:i:s'),
                        'date'=>date('Y-m-d'),
                     );
                    DB::table('daily_ledger')->insert($ledgerBc);
                    #credit member shares account
                      $ledgerMc = array(
                            'branch_id'=>Session::get('user')['branch_id'],
                            'ledger_account_id'=>$ledger_product_id,
                            'amount'=>$request->amount,
                            'batch_id'=>$batch_id,
                            'ledger_source_id'=>$source_id,
                            'cr_dr'=>'credit',
                            'time'=>date('H:i:s'),
                            'date'=>date('Y-m-d'),
                        );
                        DB::table('daily_ledger')->insert($ledgerMc);
                #end
                  
            
           return redirect('/share/add_shareholder');
     }
        
  public function get_share_type(Request $request){
          $name='';$price=0;
	     $shares = DB::table('shareaccount')->where('id',$request->id)->where('branch_id',Session::get('user')['branch_id'])->get();
	     foreach($shares as $share){
	     $tc = DB::table('shareSettings')->where('id',$share->shareType)->where('branch_id',Session::get('user')['branch_id'])->get();
		     foreach($tc as $t){
		         $type=$t->shareName;
		         $price=$t->nominalprice;
		     }	
        echo $price;
	     }
    }
  public function view_share_accounts(){
          $methods = DB::table('shareaccount')->where('branch_id',Session::get('user')['branch_id'])->get();
          return view('/pages/view_share_accounts')->with('methods',$methods);
    }
  public function print_view_share_accounts(){
          $methods = DB::table('shareaccount')->where('branch_id',Session::get('user')['branch_id'])->get();
          return view('/pages/print_view_share_accounts')->with('methods',$methods);
    }
     public function delete_share_product(Request $request){
         $id = $request->id;
         DB::table('shareSettings')->where('id',$id)->delete();
         return redirect('/share/general_settings?deleted');
    }
   public function delete_share_transaction(Request $request){
           $id=base64_decode($request->id);
           $batch_id=base64_decode($request->batch);
           DB::table('shareholders')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->delete();
           
           //delete transaction from daily ledger and update general ledger...
           DB::table('daily_ledger')->where('ledger_source_id',$id)->where('batch_id',$batch_id)->where('branch_id',Session::get('user')['branch_id'])->delete();
           #update ledger itakuja hapa...
           
           return redirect('share/view_shareholder?del');
    }
    
    public function view(){
        
        ## Total shares
        $shares = DB::table('shareholders')
                    ->select(DB::raw('SUM(amount) as share'))
                    ->where('branch_id',Session::get('user')['branch_id'])->get();
        
        foreach($shares as $share){
            $shares = $share->share;
        }
        
        $holders = DB::table('shareholders')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('pages.view_shareholders')->with('shareholders',$holders)->with('shares',$shares);
    }
    
    public function search(Request $request){
        
        $from = $request->from;
        $to = $request->to;
        
        ## Total shares
        $shares = DB::table('shareholders')
                    ->select(DB::raw('SUM(amount) as share'))
                    ->where('branch_id',Session::get('user')['branch_id'])->get();
        
        foreach($shares as $share){
            $shares = $share->share;
        }
        
        $holders = DB::table('shareholders')->where('valueDate','>=',$from)->where('valueDate','<=',$to)->where('branch_id',Session::get('user')['branch_id'])->get();
        
        ?>
        <table id="basic-datatables" class="display table  table-condensed  table-striped table-hover" nowrap>
  			<thead>
				<tr>
					<th>Full Name</th>
					<th>Type</th>
					<th>Unique#</th>
					<th>Business</th>
					<th>Amount</th>
					<th>Share %</th>
					<th>Status/Action</th>
				</tr>
			</thead>
			<tbody>
                <?php
                
                foreach($holders as $shareholder){
                    
                ?>
				<tr>
					<td nowrap>
                            <?php
                            $unique="";
                            $business="None";
                            if($shareholder->type == 'person'){
					            ?><a href="{{'/customers/view_customer?id='.base64_encode($shareholder->member_id)}}"><?php
                                foreach(DB::table('borrowers')->where('id',$shareholder->member_id)->get() as $borrower){
                                    echo ucfirst(strtolower($borrower->title))." ".ucfirst(strtolower($borrower->firstName))." ".ucfirst(strtolower($borrower->middleName))." ".ucfirst(strtolower($borrower->lastName));
                                    $unique = $borrower->uniqueNumber;
                                    if($borrower->businessName == ""){ $business="None"; }else{
                                        $business = $borrower->businessName;
                                    }
                                }
                                ?></a><?php
                            }else{
					            ?><a href="{{'/customers/view_single_borrowergroup?id='.base64_encode($shareholder->member_id)}}"><?php
                                foreach(DB::table('borrowergroups')->where('id',$shareholder->member_id)->get() as $group){
                                    echo $group->groupName;
                                    $unique = $group->uniqueNumber;
                                    $business="N/A";
                                }
                                ?></a><?php
                            }
                            
                            ?>
					</td>
					<td><?php echo ucfirst($shareholder->type);?></td>
					<td><?php echo $unique;?></td>
					<td>
					    <?php
					        if($business == ""){ echo "N/A"; }else{ echo $business;}
					    ?>
					</td>
					<td><?php echo number_format($shareholder->amount) ?></td>
					<td>
					    <?php
					        $share = round($shareholder->amount/$shares*100,2);
					        echo $share;
					    ?>
					</td>
					<td><span class="btn btn-success btn-xs">Active</span></td>
				</tr>
                <?php
                }
                ?>
            </tbody>
		</table>
	
        <?php
        
    }
    
    public function general_settings(){
        $share = DB::table('shareSettings')->where('branch_id',Session::get('user')['branch_id'])->get();
        return view('pages.share_general_settings')->with('shares',$share);
    }
    
    public function add_general_settings(Request $request){
        $id=$request->id;
        $data = array(
            'branch_id'=>Session::get('user')['branch_id'],
            'shareName'=>$request->shareName,
            'ledger_id'=>$request->ledger_id,
            'nominalprice'=>$request->Nominalprice,
            'default_share'=>$request->default,
            'min'=>$request->min,
            'max'=>$request->max,
            'interest'=>$request->interest,
            'allowInactive'=>$request->allowInactive,
            'allowWithdrawal'=>$request->allowWithdrawal,
        );
        $count = DB::table('shareSettings')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->get();
        if($count && $id>0){
            DB::table('shareSettings')->where('id',$id)->where('branch_id',Session::get('user')['branch_id'])->update($data);
        }else{
            DB::table('shareSettings')->insert($data);
        }
        return redirect('/share/general_settings');
    }
    
}