000

<?php

namespace App\Http\Controllers;
use Illuminate\Support\Facades\Auth;
use App\Item;
use DB;
use Facade\FlareClient\View;
use Illuminate\Http\Request;

class FinanceController extends Controller
{

public function allPayment(){
	$data['role_id'] =Auth::user()->role_id;
	$data['email'] = Auth::user()->email;
		// $data['irns'] = \DB::table('irns')
		// ->select('irns.*', \DB::raw('DATEDIFF(irns.payment_date, NOW()) as diffday'))
		// ->orderBy('irns.payment_date', 'ASC')
		// ->get();
		$data['irns'] = \DB::table('irn_items')
		->join('irns','irn_items.irn_id','irns.id')
		->join('purchase_orders','purchase_orders.id','irn_items.po_id')
		->select('irns.id','irns.payment_status','irns.irn_no','irns.invoice_no','irns.invoice_date','irns.receive_date','irns.document','irns.payment_date','irns.status','irns.utr_no','irns.remark','irn_items.irn_id','irn_items.po_id','irn_items.item_code','purchase_orders.po_number', \DB::raw('DATEDIFF(irns.payment_date, NOW()) as diffday'), 'irns.final_grand_total as invoice_amount', 'purchase_orders.vendor_id')
		->orderBy('irns.payment_date', 'ASC')
		->groupBy(['purchase_orders.po_number','irns.irn_no'])
		->get();
//dd($data);
	return view('dashboard.finance.all-payment',$data);
	//echo 'This is Finance';
}

public function setPaymentStatus(Request $request){
   //dd($request);
	$response = array();
		$validator = \Validator::make($request->all(),
			array(
				'status' =>'required',
			)
		);
		if($validator->fails())
		{
			$response['flag'] = false;
			$response['errors'] = $validator->getMessageBag();
		}else{
			$mrn_details =  \App\Irn::where('id',$request->id)->first();
			if(is_null($mrn_details)){
				$response['flag'] = false;
				$response['error'] = "Item Not found";
			}else{
				$mrn_details->payment_status = $request->status;
				if($mrn_details->utr_no != ''){
					$mrn_details->utr_no = $mrn_details->utr_no.', '.$request->remark;   
		} else {
				$mrn_details->utr_no = $request->remark;   
		}
				if($mrn_details->save()){
                    //Create Log
					$IrnLog =  new \App\IrnPayment();
					$IrnLog->mrn_id = $mrn_details->id;
					$IrnLog->user_id = \Auth::user()->id;
					$IrnLog->status = $mrn_details->payment_status;
					$IrnLog->remark = $request->remark;
					$IrnLog->save();

$response['flag'] = true;
					$response['message'] = "Status Updated Successfully";
				}else{
					$response['flag'] = false;
					$response['error'] = "Something Went Wrong";
				}
				
			}
		}
		return response()->json($response);
}

public function getPaymentStatus($id){
		$data['mrn_id'] = $id;
		$data['role_id'] = \Auth::user()->role_id;
		$data['irns'] = \App\Irn::select('utr_no', 'payment_status')->where('id', $id)->first();
		return view('dashboard.finance.set-payment-status',$data);
	}

}