000

<?php 
function getUserById($user_id){
	$user = \App\User::find($user_id);
	return $user;
}

function getPRCurrentStatus1($pr_id) {
	$total_qty = \DB::table('purchase_request_items')->where('pr_id',$pr_id)->sum('qty');
	$total_rqty = \DB::table('purchase_request_items')->where('pr_id',$pr_id)->sum('rqty');

if($total_qty == $total_rqty) {
		return true;
	}
	return false;	
}

function getPRCurrentStatus2($pr_id) {
	$total_qty = \DB::table('purchase_request_items')->where('pr_id',$pr_id)->sum('qty');
	$total_rqty = \DB::table('purchase_request_items')->where('pr_id',$pr_id)->sum('rqty');

if($total_qty != 0) {
		if($total_rqty == 0) {
			return 'Completed';
		} elseif($total_qty == $total_rqty) {
			return 'Processing';
		} else{
			return 'Partially Completed';
		}
	}
	logger("pr id :".$pr_id);
	return '';
		
}

function getPRCurrentStatusForReport($pr_id, $item_code) {
	$total_qty = \DB::table('purchase_request_items')->where('item_code', $item_code)->where('pr_id',$pr_id)->sum('qty');
	$total_rqty = \DB::table('purchase_request_items')->where('item_code', $item_code)->where('pr_id',$pr_id)->sum('rqty');

if($total_qty != 0) {
		if($total_qty == $total_rqty) {
			return 'Requested';
		} elseif($total_rqty == 0) {
			return 'Completed';
		} else if($total_qty > $total_rqty) {
			return 'Partially Completed';
		}
	}
	return '';	
}

function getPONumberByStcId($stc_id) {
     
	$po_numbers = DB::table('short_closed_po_items as scp')->join('purchase_orders as po', 'scp.po_id', 'po.id')->select('po.po_number')->where('scp.stc_id', $stc_id)->groupBy('po.po_number')->get();
	return $po_numbers;
}

function getPOCurrentStatus1($po_id) {
	$total_qty = \DB::table('purchase_order_items')->where('po_id',$po_id)->sum('qty');
	$total_rqty = \DB::table('purchase_order_items')->where('po_id',$po_id)->sum('rqty');

if($total_qty != $total_rqty) {
		return true;
	} 
	return false;
}

function getPOCurrentStatusReport($po_id, $item_code) {
	$total_qty = \DB::table('purchase_order_items')->where('po_id',$po_id)->where('item_code', $item_code)->sum('qty');
	$total_rqty = \DB::table('purchase_order_items')->where('po_id',$po_id)->where('item_code', $item_code)->sum('rqty');

if($total_qty != 0) {
		if($total_qty == $total_rqty) {
			return 'Completed';
		} else if($total_rqty == 0) {
			return 'Requested';
		} else if($total_rqty < $total_qty){
			return 'Partially Completed';
		}
	}

return '';	
}

function getMRNStatus($po_id) {
	$status = '';
	$po_items = \App\PurchaseOrderItem::select(DB::raw('round(sum(qty), 2) as qty'), DB::raw('round(sum(rqty), 2) as rqty'))->where('po_id', $po_id)->groupBy('po_id')->get();

foreach ($po_items as $key => $item) {	
		if($item->qty == $item->rqty) {
			$status = 1;
		} elseif($item->rqty > 0) {
			$status = 2;
		} else {
			$status = 3;
		}
	}
	return $status;
}

function getMRNStatusReport($po_id, $item_code) {
	$status = '';
	// $po_items = \App\PurchaseOrderItem::select(DB::raw('sum(qty) as qty'))->where('po_id', $po_id)->where('item_code', $item_code)->groupBy('po_id')->first();

$po_total_qty = \DB::table('purchase_order_items')->where('po_id',$po_id)->where('item_code', $item_code)->sum('qty');
	$mrn_qty = \DB::table('irn_items')->where('item_code', $item_code)->where('po_id', $po_id)->sum('qty');

if($po_total_qty == $mrn_qty) {
		return 'Done';
	}	elseif($mrn_qty == 0) {
		return 'Not Done';
	} else {
		return 'Partially Done';
	}
}

function getModelById($modal,$id){
	$modal = "\App\\".$modal;
	$result = $modal::find($id);
	if($result!=''){
      return $result;
	}else{
     return new $modal;
	}
}

function getTableById($table_name,$id){
	$result = \DB::table($table_name)->where('id',$id)->first();

return $result;
}

function getSubmoduleByModule($role_id,$module_id){
	$sub_menus = \App\RoleModuleAssociation::with('sub_module')
	->where('role_id',$role_id)
	->where('module_id',$module_id)
	->get();
	return $sub_menus;
}

function calculateTimeSpan($date){
	$seconds  = strtotime(date('Y-m-d H:i:s')) - strtotime($date);

$months = floor($seconds / (3600*24*30));
	$day = floor($seconds / (3600*24));
	$hours = floor($seconds / 3600);
	$mins = floor(($seconds - ($hours*3600)) / 60);
	$secs = floor($seconds % 60);

if($seconds < 60){
		$time = $secs." sec ago";
	}
	else if($seconds < 60*60 ){
		$time = $mins." min ago";
	}
	else if($seconds < 24*60*60){
		$time = $hours." hrs ago";
	}
	else if($seconds < 24*60*60*30){
		$time = $day." day ago";
	}
	else{
		$time = $months." month ago";
	}
	return $time;
}

function keyFromSlug($slug,$delimiter){

$tmp = explode($delimiter, $slug);
	return ucfirst(implode(' ', $tmp));
}

function setOpen($path)
{
	return Request::is($path) ? 'open' : '';
}
function setActive($path)
{
	return Request::is($path) ? 'active' : '';
}

function getPOCurrentStatusPOReport($po_id) {
	$po_rqty = \DB::table('purchase_order_items')->where('po_id',$po_id)->sum('rqty');
	$po_qty = \DB::table('purchase_order_items')->where('po_id',$po_id)->sum('qty');

if($po_rqty == $po_qty) {
		return 'Completed';
	} elseif($po_rqty == 0) {
		return 'Requested';		
	} else if($po_rqty < $po_qty) {		
		return 'Partially Completed';
	} else {		
		return '';
	}
}

function getPRIdByPONumber($po_id){
    $all_pr_number = \DB::table('purchase_order_items')->where('po_id',$po_id)
    ->join('purchase_requests','purchase_requests.id','purchase_order_items.pr_id')
    ->select('purchase_requests.pr_number')
    ->groupBy('purchase_requests.pr_number')
    ->get();
    //return $all_pr_number;
    $all_pr_list=[];
    
    foreach ($all_pr_number as $key => $value) {
    	 $all_pr_list[]=$value->pr_number;
    }
    $a=implode(',', $all_pr_list);
    return $a;
}

function getPOIdByIRNNumber($irn_id){
   $all_po_number = \DB::table('irn_items')->where('irn_id',$irn_id)
    ->join('purchase_orders','purchase_orders.id','irn_items.po_id')
    ->select('purchase_orders.po_number')
    ->groupBy('purchase_orders.po_number')
    ->get();
    //return $all_pr_number;
    $all_po_list=[];
    
    foreach ($all_po_number as $key => $value) {
    	 $all_po_list[]=$value->po_number;
    }
    $a=implode(',', $all_po_list);
    return $a;
}

function getIrnModelById($modal,$id){
	$modal = "\App\\".$modal;
	$result = $modal::find($id);
	if($result!=null){
	return $result;
}else{
	return new $modal;
}
}

function getRole($role_id){
	$all = \DB::table('roles')
	->where('id',$role_id)
	->first();
     $role=$all->role;
     return $role;
}

function isFunHeadAvailable($creater_id){
		$data=\DB::table('users')
	  ->select('users.id','users.name','users.business_head','users.functional_head')
	  ->where('users.id',$creater_id)
	  ->first();
	  
		if($data->functional_head == null) {
			return 'requested';
		} else {
			return 'reviewed(FH)';
		}

}

//send mail check conditions
 function checkMailCondition($creater_id){
 	//dd($creater_id);
 	$data=\DB::table('users')
  ->select('users.id','users.name','users.business_head','users.functional_head')
  ->where('users.id',$creater_id)
  ->first();
  //dd($data);
 if($data->business_head==null && $data->functional_head==null){
  	return 'requested';
  }elseif($data->functional_head==null){
  	return 'reviewed';
  }elseif($data->functional_head==null){
  	return 'pending_approval';
  }
 }