lubusIN / laravel-gymie

app/Lubus/Utilities.php

Indentation +540 added lines, -540 removed lines

@@ -13,7 +13,7 @@ 
 
 static function setActiveMenu($uri,$isParent = false)
 {
-	$class = ($isParent) ? 'active open' : 'active';
+    $class = ($isParent) ? 'active open' : 'active';
     return \Request::is($uri) ? $class : '';
     //return \Request::is($uri);
 }
@@ -21,68 +21,68 @@ 
 // Get Setting
 static function getSetting($key)
 {
-	$settingValue = Setting::where('key','=',$key)->pluck('value');
-	return $settingValue;
+    $settingValue = Setting::where('key','=',$key)->pluck('value');
+    return $settingValue;
 }
 
 //get Settings
 static function getSettings()
 {
-	$settings = Setting::all();
-	$settings_array = array();
+    $settings = Setting::all();
+    $settings_array = array();
 
-	foreach ($settings as $setting) {
-		$settings_array[$setting->key] = $setting->value;
-	}
+    foreach ($settings as $setting) {
+        $settings_array[$setting->key] = $setting->value;
+    }
 
-	return $settings_array;
+    return $settings_array;
 }
 
 
 //Follow up Status
 static function getFollowUpStatus($status)
 {
-	switch ($status) {
-		case '1':
-			return "Done"; 
-			break;
-
-	    default :
-	        return "Pending";
-	        break;
-	}
+    switch ($status) {
+        case '1':
+            return "Done"; 
+            break;
+
+        default :
+            return "Pending";
+            break;
+    }
 }
 
 //Follow up by
 static function getFollowupBy($followUpBy)
 {
-	switch ($followUpBy) {
-		case '1':
-			return "SMS";
-			break;
-
-		case '2':
-			return "Personal";
-			break;
-
-	    default :
-	        return "Call";
-	        break;
-	}
+    switch ($followUpBy) {
+        case '1':
+            return "SMS";
+            break;
+
+        case '2':
+            return "Personal";
+            break;
+
+        default :
+            return "Call";
+            break;
+    }
 }
 
 //FollowUp Status Icon bg
 static function getIconBg($status)
 {
-	switch ($status) {
-		case '1':
-			return "bg-blue-400 border-blue-700"; 
-			break;
-
-	    default :
-	        return "bg-orange-400 border-orange-700";
-	        break;
-	}
+    switch ($status) {
+        case '1':
+            return "bg-blue-400 border-blue-700"; 
+            break;
+
+        default :
+            return "bg-orange-400 border-orange-700";
+            break;
+    }
 }
 
 
@@ -90,123 +90,123 @@ 
 //Followup Status Icon
 static function getStatusIcon($status)
 {
-	switch ($status) {
-		case '1':
-			return "fa fa-thumbs-up"; 
-			break;
-
-	    default :
-	        return "fa fa-refresh";
-	        break;
-	}
+    switch ($status) {
+        case '1':
+            return "fa fa-thumbs-up"; 
+            break;
+
+        default :
+            return "fa fa-refresh";
+            break;
+    }
 }
 
 
 // Aim for member & enquiry creation
 static function getAim($aim)
 {
-	switch ($aim) {
-		case '1':
-			return "Networking";
-			break;
+    switch ($aim) {
+        case '1':
+            return "Networking";
+            break;
 		
-		case '2':
-			return "Body Building";
-			break;
-
-		case '3':
-			return "Fatloss";
-			break;
-
-		case '4':
-			return "Weightgain";
-			break;
-
-		case '5':
-			return "Others";
-			break;
-
-	    default :
-	        return "Fitness";
-	        break;
-	}
+        case '2':
+            return "Body Building";
+            break;
+
+        case '3':
+            return "Fatloss";
+            break;
+
+        case '4':
+            return "Weightgain";
+            break;
+
+        case '5':
+            return "Others";
+            break;
+
+        default :
+            return "Fitness";
+            break;
+    }
 }
 
 
 // Invoice Labels
 static function getInvoiceLabel($status)
 {
-	switch ($status) {
-		case '0':
-			return "label label-danger";
-			break;
+    switch ($status) {
+        case '0':
+            return "label label-danger";
+            break;
 		
-		case '1':
-			return "label label-success";
-			break;
-
-		case '3':
-			return "label label-default";
-			break;
-
-	    default :
-	        return "label label-primary";
-	        break;
-	}
+        case '1':
+            return "label label-success";
+            break;
+
+        case '3':
+            return "label label-default";
+            break;
+
+        default :
+            return "label label-primary";
+            break;
+    }
 }
 
 // Expense alert repeat
 static function expenseRepeatIntervel($repeat)
 {
-	switch ($repeat) {
-		case '0':
-			return "Never Repeat";
-			break;
+    switch ($repeat) {
+        case '0':
+            return "Never Repeat";
+            break;
 		
-		case '1':
-			return "Every Day";
-			break;
-
-		case '2':
-			return "Every Week";
-			break;
-
-		case '3':
-			return "Every Month";
-			break;
-
-	    default :
-	        return "Every Year";
-	        break;
-	}
+        case '1':
+            return "Every Day";
+            break;
+
+        case '2':
+            return "Every Week";
+            break;
+
+        case '3':
+            return "Every Month";
+            break;
+
+        default :
+            return "Every Year";
+            break;
+    }
 }
 
 //Paid Unpaid Labels
 static function getPaidUnpaid($status)
 {
-	switch ($status) {
-		case '0':
-			return "label label-danger";
-			break;
-
-	    default :
-	        return "label label-primary";
-	        break;
-	}
+    switch ($status) {
+        case '0':
+            return "label label-danger";
+            break;
+
+        default :
+            return "label label-primary";
+            break;
+    }
 }
 
 //Active-Inactive Labels
 static function getActiveInactive($status)
 {
-	switch ($status) {
-		case '0':
-			return "label label-danger";
-			break;
-
-	    default :
-	        return "label label-primary";
-	        break;
-	}
+    switch ($status) {
+        case '0':
+            return "label label-danger";
+            break;
+
+        default :
+            return "label label-primary";
+            break;
+    }
 }
 
 
@@ -214,31 +214,31 @@ 
 // Occupation of members
 static function getOccupation($occupation)
 {
-	switch ($occupation) {
-		case '1':
-			return "Housewife";
-			break;
+    switch ($occupation) {
+        case '1':
+            return "Housewife";
+            break;
 		
-		case '2':
-			return "Self Employed";
-			break;
-
-		case '3':
-			return "Professional";
-			break;
-
-		case '4':
-			return "Freelancer";
-			break;
-
-		case '5':
-			return "Others";
-			break;
-
-	    default :
-	        return "Student";
-	        break;
-	}
+        case '2':
+            return "Self Employed";
+            break;
+
+        case '3':
+            return "Professional";
+            break;
+
+        case '4':
+            return "Freelancer";
+            break;
+
+        case '5':
+            return "Others";
+            break;
+
+        default :
+            return "Student";
+            break;
+    }
 }
 
 
@@ -246,82 +246,82 @@ 
 // Source for member & enquiry creation
 static function getSource($source)
 {
-	switch ($source) {
-		case '1':
-			return "Word of mouth";
-			break;
+    switch ($source) {
+        case '1':
+            return "Word of mouth";
+            break;
 		
-		case '2':
-			return "Others";
-			break;
-
-	    default :
-	        return "Promotions";
-	        break;
-	}
+        case '2':
+            return "Others";
+            break;
+
+        default :
+            return "Promotions";
+            break;
+    }
 }
 
 
 // Member Status
 static function getStatusValue($status)
 {
-	switch ($status) {
-		case '0':
-			return "Inactive";
-			break;
+    switch ($status) {
+        case '0':
+            return "Inactive";
+            break;
 		
-		case '2':
-			return "Archived";
-			break;
-
-	    default :
-	        return "Active";
-	        break;
-	}
+        case '2':
+            return "Archived";
+            break;
+
+        default :
+            return "Active";
+            break;
+    }
 }
 
 // Enquiry Status
 static function getEnquiryStatus($status)
 {
-	switch ($status) {
-		case '0':
-			return "Lost";
-			break;
+    switch ($status) {
+        case '0':
+            return "Lost";
+            break;
 		
-		case '2':
-			return "Member";
-			break;
+        case '2':
+            return "Member";
+            break;
 			
-	    default :
-	        return "Lead";
-	        break;
-	}
+        default :
+            return "Lead";
+            break;
+    }
 }
 
 // Enquiry Label
 static function getEnquiryLabel($status)
 {
-	switch ($status) {
-		case '0':
-			return "label label-danger";
-			break;
+    switch ($status) {
+        case '0':
+            return "label label-danger";
+            break;
 		
-		case '2':
-			return "label label-success";
-			break;
-
-	    default :
-	        return "label label-primary";
-	        break;
-	}
+        case '2':
+            return "label label-success";
+            break;
+
+        default :
+            return "label label-primary";
+            break;
+    }
 }
 
 // Set invoice status
 static function setInvoiceStatus($amount_due,$invoice_total)
 {
-	if($amount_due == 0)
+    if($amount_due == 0)
     {
-         $paymentStatus = \constPaymentStatus::Paid;
+            $paymentStatus = \constPaymentStatus::Paid;
     } 
     elseif($amount_due > 0 && $amount_due < $invoice_total) 
     {
@@ -342,162 +342,162 @@ 
 // Invoice Status
 static function getInvoiceStatus($status)
 {
-	switch ($status) {
-		case '1':
-			return "Paid";
-			break;
+    switch ($status) {
+        case '1':
+            return "Paid";
+            break;
 		
-		case '2':
-			return "Partial";
-			break;
-
-		case '3':
-			return "Overpaid";
-			break;
-
-	    default :
-	        return "Unpaid";
-	        break;
-	}
+        case '2':
+            return "Partial";
+            break;
+
+        case '3':
+            return "Overpaid";
+            break;
+
+        default :
+            return "Unpaid";
+            break;
+    }
 }
 
 
 // Subcription Status
 static function getSubscriptionStatus($status)
 {
-	switch ($status) {
-		case '0':
-			return "Expired";
-			break;
+    switch ($status) {
+        case '0':
+            return "Expired";
+            break;
 		
-		case '2':
-			return "Renewed";
-			break;
-
-		case '3':
-			return "Cancelled";
-			break;
-
-	    default :
-	        return "OnGoing";
-	        break;
-	}
+        case '2':
+            return "Renewed";
+            break;
+
+        case '3':
+            return "Cancelled";
+            break;
+
+        default :
+            return "OnGoing";
+            break;
+    }
 }
 
 
 // Subcription Label
 static function getSubscriptionLabel($status)
 {
-	switch ($status) {
-		case '0':
-			return "label label-danger";
-			break;
+    switch ($status) {
+        case '0':
+            return "label label-danger";
+            break;
 		
-		case '2':
-			return "label label-success";
-			break;
-
-		case '3':
-			return "label label-default";
-			break;
-
-	    default :
-	        return "label label-primary";
-	        break;
-	}
+        case '2':
+            return "label label-success";
+            break;
+
+        case '3':
+            return "label label-default";
+            break;
+
+        default :
+            return "label label-primary";
+            break;
+    }
 }
 
 
 // Payment Mode
 static function getPaymentMode($status)
 {
-	switch ($status) {
-		case '0':
-			return "Cheque";
-			break;
-
-	    default :
-	        return "Cash";
-	        break;
-	}
+    switch ($status) {
+        case '0':
+            return "Cheque";
+            break;
+
+        default :
+            return "Cash";
+            break;
+    }
 }
 
 // Cheque status
 static function getChequeStatus($status)
 {
-	switch ($status) {
-		case '1':
-			return "Deposited";
-			break;
-
-		case '2':
-			return "Cleared";
-			break;
-
-		case '3':
-			return "Bounced";
-			break;
-
-		case '4':
-			return "Reissued";
-			break;
-
-	    default :
-	        return "Recieved";
-	        break;
-	}
+    switch ($status) {
+        case '1':
+            return "Deposited";
+            break;
+
+        case '2':
+            return "Cleared";
+            break;
+
+        case '3':
+            return "Bounced";
+            break;
+
+        case '4':
+            return "Reissued";
+            break;
+
+        default :
+            return "Recieved";
+            break;
+    }
 }
 
 // Get Gender
 static function getGender($gender)
 {
-	switch ($gender) 
-	{
-		case 'm':
-			return "Male";
-			break;
+    switch ($gender) 
+    {
+        case 'm':
+            return "Male";
+            break;
 		
-		case 'f':
-			return "Female";
-			break;
-	}
+        case 'f':
+            return "Female";
+            break;
+    }
 }
 
 
 //Get invoice display name type
 static function getDisplay($display)
 {
-	switch ($display) 
-	{
-		case 'gym_logo':
-			return "Gym Logo";
-			break;
+    switch ($display) 
+    {
+        case 'gym_logo':
+            return "Gym Logo";
+            break;
 		
-		default:
-			return "Gym Name";
-			break;
-	}
+        default:
+            return "Gym Name";
+            break;
+    }
 }
 
 
 // Get Numbering mode 
 static function getMode($mode)
 {
-	switch ($mode) 
-	{
-		case '0':
-			return "Manual";
-			break;
+    switch ($mode) 
+    {
+        case '0':
+            return "Manual";
+            break;
 		
-		default :
-			return "Automatic";
-			break;
-	}
+        default :
+            return "Automatic";
+            break;
+    }
 }
 
 static function getGreeting(){
-	//$time = date("H");
-	$time = Carbon::now()->hour;
+    //$time = date("H");
+    $time = Carbon::now()->hour;
     /* If the time is less than 1200 hours, show good morning */
     if ($time < "12") {
         echo "Good morning";
@@ -521,258 +521,258 @@ 
 *File Upload
 **/
 
-	static function uploadFile(Request $request, $prefix, $recordId, $upload_field, $upload_path)
-		{		
-		if ($request->hasFile($upload_field)) 
-			{
-				$file = $request->file($upload_field);
+    static function uploadFile(Request $request, $prefix, $recordId, $upload_field, $upload_path)
+        {		
+        if ($request->hasFile($upload_field)) 
+            {
+                $file = $request->file($upload_field);
 
-	            if ($file->isValid())
+                if ($file->isValid())
                 {
-                	File::delete(public_path('assets/img/gym/gym_logo.jpg'));
-                	$fileName = "gym_logo.jpg";
+                    File::delete(public_path('assets/img/gym/gym_logo.jpg'));
+                    $fileName = "gym_logo.jpg";
                     $destinationPath = public_path($upload_path);
                     $request->file($upload_field)->move($destinationPath,$fileName);
                     Image::make($destinationPath."/".$fileName)->resize(600, null, function ($constraint) {
-																					    $constraint->aspectRatio();
-																					})->save();
+                                                                                        $constraint->aspectRatio();
+                                                                                    })->save();
                 }
-			}
-		}
-
-	static function registrationsTrend()
-	{
-		// Get Financial date
-		$startDate = new Carbon(Setting::where('key','=','financial_start')->pluck('value'));
-		$data = array();
+            }
+        }
+
+    static function registrationsTrend()
+    {
+        // Get Financial date
+        $startDate = new Carbon(Setting::where('key','=','financial_start')->pluck('value'));
+        $data = array();
 		
-		for ($i=1; $i <= 12 ; $i++) { 
-			//$members = member::registrations($startDate->month,$startDate->year); // Laravel Scoped Query Issue: Workaroud Needed
-			$members = Member::whereMonth('created_at', '=', $startDate->month)->whereYear('created_at', '=',$startDate->year)->count();
-			$data[] = array("month" => $startDate->format('Y-m'), "registrations" => $members);
-			$startDate->addMonth();
-		}
-
-		return json_encode($data);
-	}
-
-
-	static function membersPerPlan()
-	{
-		$data = array();
-
-		$plans = Plan::onlyActive()->get();
-
-		foreach ($plans as $plan) 
-		{
-			$subscriptions = Subscription::where('status','=',\constSubscription::onGoing)->where('plan_id','=',$plan->id)->count();
-			$data[] = array('label' =>$plan->plan_name ,'value'=>$subscriptions);
-		}
-		return json_encode($data);		
-	}
-
-	// Checking logonutility gateway status
-	static function smsGatewayStatus()
-	{
-		try
-		{
-			$api_key = Utilities::getSetting('sms_api_key');
-
-			$api_url = "http://logonutility.in/app/miscapi/".$api_key."/getBalance/true/";
-
-			if(Utilities::isDomainAvailible($api_url))
-	        {
-	               return true;
-	        }
-	        else
-	        {
-	               return false;
-	        }			
+        for ($i=1; $i <= 12 ; $i++) { 
+            //$members = member::registrations($startDate->month,$startDate->year); // Laravel Scoped Query Issue: Workaroud Needed
+            $members = Member::whereMonth('created_at', '=', $startDate->month)->whereYear('created_at', '=',$startDate->year)->count();
+            $data[] = array("month" => $startDate->format('Y-m'), "registrations" => $members);
+            $startDate->addMonth();
+        }
+
+        return json_encode($data);
+    }
+
+
+    static function membersPerPlan()
+    {
+        $data = array();
+
+        $plans = Plan::onlyActive()->get();
+
+        foreach ($plans as $plan) 
+        {
+            $subscriptions = Subscription::where('status','=',\constSubscription::onGoing)->where('plan_id','=',$plan->id)->count();
+            $data[] = array('label' =>$plan->plan_name ,'value'=>$subscriptions);
+        }
+        return json_encode($data);		
+    }
+
+    // Checking logonutility gateway status
+    static function smsGatewayStatus()
+    {
+        try
+        {
+            $api_key = Utilities::getSetting('sms_api_key');
+
+            $api_url = "http://logonutility.in/app/miscapi/".$api_key."/getBalance/true/";
+
+            if(Utilities::isDomainAvailible($api_url))
+            {
+                    return true;
+            }
+            else
+            {
+                    return false;
+            }			
 						
-		}
-		catch(Exception $e)
-		{
-			return false;
-		}
-	}
-
-
-   // returns true, if domain is availible, false if not
-   static function isDomainAvailible($domain)
-   {
-       //check, if a valid url is provided
-       if(!filter_var($domain, FILTER_VALIDATE_URL))
-       {
-               return false;
-       }
-
-       //initialize curl
-       $curlInit = curl_init($domain);
-       curl_setopt($curlInit,CURLOPT_CONNECTTIMEOUT,10);
-       curl_setopt($curlInit,CURLOPT_HEADER,true);
-       curl_setopt($curlInit,CURLOPT_NOBODY,true);
-       curl_setopt($curlInit,CURLOPT_RETURNTRANSFER,true);
-
-       //get answer
-       $response = curl_exec($curlInit);
-
-       curl_close($curlInit);
-
-       if ($response) return true;
-
-       return false;
-   }
-
-
-	static function Sms($sender_id,$member_contact,$sms_text,$sms_status)
-	{
-		$sms = Utilities::getSetting('sms');
-		$gatewayStatus = Utilities::smsGatewayStatus();
-
-		if ($sms && $sms_status) 
-		{
-			if($gatewayStatus)
-			{
-				$api_key = Utilities::getSetting('sms_api_key');
-				$contacts = $member_contact;
-				$from = $sender_id;
-				$send_sms_text = urlencode($sms_text);
-
-				//Transactional = 20 , Promo with sender id = 21 , only promotional = 18
-				$api_url = "http://www.logonutility.in/app/smsapi/index.php?key=".$api_key."&campaign=1&routeid=20&type=text&contacts=".$contacts."&senderid=".$from."&msg=".$send_sms_text;
-
-				//Submit to server
-				$response = file_get_contents($api_url);
-
-				if (str_contains($response,'SMS-SHOOT-ID')) 
-				{
-					//Log entry for SMS_log table
-					$SmsLogData = array('shoot_id' => substr($response, strpos($response, "SMS-SHOOT-ID/") + 13),
-										'number' => $member_contact,
-										'message' => $sms_text,
-										'sender_id' => $sender_id,
-										'send_time' => Carbon::now(),
-										'status' => 'NA');
-
-					$SmsLog  = new Sms_log($SmsLogData);
-					$SmsLog->save();
-				}
-				//Update SMS balance
-				Utilities::smsBalance();
-			}
-			else
-			{
-				$SmsLogData = array('shoot_id' => '',
-									'number' => $member_contact,
-									'message' => $sms_text,
-									'sender_id' => $sender_id,
-									'send_time' => Carbon::now(),
-									'status' => 'offline');
-
-				$SmsLog  = new Sms_log($SmsLogData);
-				$SmsLog->save();
-			}
+        }
+        catch(Exception $e)
+        {
+            return false;
+        }
+    }
+
+
+    // returns true, if domain is availible, false if not
+    static function isDomainAvailible($domain)
+    {
+        //check, if a valid url is provided
+        if(!filter_var($domain, FILTER_VALIDATE_URL))
+        {
+                return false;
+        }
+
+        //initialize curl
+        $curlInit = curl_init($domain);
+        curl_setopt($curlInit,CURLOPT_CONNECTTIMEOUT,10);
+        curl_setopt($curlInit,CURLOPT_HEADER,true);
+        curl_setopt($curlInit,CURLOPT_NOBODY,true);
+        curl_setopt($curlInit,CURLOPT_RETURNTRANSFER,true);
+
+        //get answer
+        $response = curl_exec($curlInit);
+
+        curl_close($curlInit);
+
+        if ($response) return true;
+
+        return false;
+    }
+
+
+    static function Sms($sender_id,$member_contact,$sms_text,$sms_status)
+    {
+        $sms = Utilities::getSetting('sms');
+        $gatewayStatus = Utilities::smsGatewayStatus();
+
+        if ($sms && $sms_status) 
+        {
+            if($gatewayStatus)
+            {
+                $api_key = Utilities::getSetting('sms_api_key');
+                $contacts = $member_contact;
+                $from = $sender_id;
+                $send_sms_text = urlencode($sms_text);
+
+                //Transactional = 20 , Promo with sender id = 21 , only promotional = 18
+                $api_url = "http://www.logonutility.in/app/smsapi/index.php?key=".$api_key."&campaign=1&routeid=20&type=text&contacts=".$contacts."&senderid=".$from."&msg=".$send_sms_text;
+
+                //Submit to server
+                $response = file_get_contents($api_url);
+
+                if (str_contains($response,'SMS-SHOOT-ID')) 
+                {
+                    //Log entry for SMS_log table
+                    $SmsLogData = array('shoot_id' => substr($response, strpos($response, "SMS-SHOOT-ID/") + 13),
+                                        'number' => $member_contact,
+                                        'message' => $sms_text,
+                                        'sender_id' => $sender_id,
+                                        'send_time' => Carbon::now(),
+                                        'status' => 'NA');
+
+                    $SmsLog  = new Sms_log($SmsLogData);
+                    $SmsLog->save();
+                }
+                //Update SMS balance
+                Utilities::smsBalance();
+            }
+            else
+            {
+                $SmsLogData = array('shoot_id' => '',
+                                    'number' => $member_contact,
+                                    'message' => $sms_text,
+                                    'sender_id' => $sender_id,
+                                    'send_time' => Carbon::now(),
+                                    'status' => 'offline');
+
+                $SmsLog  = new Sms_log($SmsLogData);
+                $SmsLog->save();
+            }
 			
-		}
-	}
-
-	static function retrySms($sender_id,$member_contact,$sms_text,$log)
-	{
-		$gatewayStatus = Utilities::smsGatewayStatus();
-
-		if($gatewayStatus)
-		{
-			$api_key = Utilities::getSetting('sms_api_key');
-			$contacts = $member_contact;
-			$from = $sender_id;
-			$send_sms_text = urlencode($sms_text);
-
-			//Transactional = 20 , Promo with sender id = 21 , only promotional = 18
-			$api_url = "http://www.logonutility.in/app/smsapi/index.php?key=".$api_key."&campaign=1&routeid=21&type=text&contacts=".$contacts."&senderid=".$from."&msg=".$send_sms_text;
-
-			//Submit to server
-			$response = file_get_contents($api_url);
-
-			if (str_contains($response,'SMS-SHOOT-ID')) 
-			{
-				//Log entry for SMS_log table
-				$log->update(['shoot_id' => substr($response, strpos($response, "SMS-SHOOT-ID/") + 13),
-							  'number' => $member_contact,
-							  'message' => $sms_text,
-							  'sender_id' => $sender_id,
-							  'send_time' => Carbon::now(),
-							  'status' => 'NA']);
-				$log->save();
-			}
-			//Update SMS balance
-			Utilities::smsBalance();
-		}
-	}
-
-	static function smsBalance()
-	{
-		$sms = Utilities::getSetting('sms');
-		$gatewayStatus = Utilities::smsGatewayStatus();
-
-		if($sms && $gatewayStatus)
-		{
-			$api_key = Utilities::getSetting('sms_api_key');
-
-			$api_url = "http://logonutility.in/app/miscapi/".$api_key."/getBalance/true/";
-
-			//Submit to server
-
-			$credit_balance = file_get_contents($api_url);
-			$balance = json_decode($credit_balance);
-			Setting::where('key', '=','sms_balance')->update(['value' => $balance[0]->BALANCE]);
-
-			// If balance turns zero turn off SMS
-			if($balance[0]->BALANCE == 0)
-			{
-				Setting::where('key', '=','sms')->update(['value' => 0]);
-			}
-		}
-	}
-
-	static function smsStatusUpdate()
-	{
-		$sms = Utilities::getSetting('sms');
-		$gatewayStatus = Utilities::smsGatewayStatus();
-
-		if($sms && $gatewayStatus)
-		{
-			$api_key = Utilities::getSetting('sms_api_key');
+        }
+    }
+
+    static function retrySms($sender_id,$member_contact,$sms_text,$log)
+    {
+        $gatewayStatus = Utilities::smsGatewayStatus();
+
+        if($gatewayStatus)
+        {
+            $api_key = Utilities::getSetting('sms_api_key');
+            $contacts = $member_contact;
+            $from = $sender_id;
+            $send_sms_text = urlencode($sms_text);
+
+            //Transactional = 20 , Promo with sender id = 21 , only promotional = 18
+            $api_url = "http://www.logonutility.in/app/smsapi/index.php?key=".$api_key."&campaign=1&routeid=21&type=text&contacts=".$contacts."&senderid=".$from."&msg=".$send_sms_text;
+
+            //Submit to server
+            $response = file_get_contents($api_url);
+
+            if (str_contains($response,'SMS-SHOOT-ID')) 
+            {
+                //Log entry for SMS_log table
+                $log->update(['shoot_id' => substr($response, strpos($response, "SMS-SHOOT-ID/") + 13),
+                                'number' => $member_contact,
+                                'message' => $sms_text,
+                                'sender_id' => $sender_id,
+                                'send_time' => Carbon::now(),
+                                'status' => 'NA']);
+                $log->save();
+            }
+            //Update SMS balance
+            Utilities::smsBalance();
+        }
+    }
+
+    static function smsBalance()
+    {
+        $sms = Utilities::getSetting('sms');
+        $gatewayStatus = Utilities::smsGatewayStatus();
+
+        if($sms && $gatewayStatus)
+        {
+            $api_key = Utilities::getSetting('sms_api_key');
+
+            $api_url = "http://logonutility.in/app/miscapi/".$api_key."/getBalance/true/";
+
+            //Submit to server
+
+            $credit_balance = file_get_contents($api_url);
+            $balance = json_decode($credit_balance);
+            Setting::where('key', '=','sms_balance')->update(['value' => $balance[0]->BALANCE]);
+
+            // If balance turns zero turn off SMS
+            if($balance[0]->BALANCE == 0)
+            {
+                Setting::where('key', '=','sms')->update(['value' => 0]);
+            }
+        }
+    }
+
+    static function smsStatusUpdate()
+    {
+        $sms = Utilities::getSetting('sms');
+        $gatewayStatus = Utilities::smsGatewayStatus();
+
+        if($sms && $gatewayStatus)
+        {
+            $api_key = Utilities::getSetting('sms_api_key');
 			
-			// Retry Offline Msg
-			$messages = Sms_log::where('status','offline')->get();
+            // Retry Offline Msg
+            $messages = Sms_log::where('status','offline')->get();
 		
-			foreach($messages as $message)
-			{
-				Utilities::retrySms($message->sender_id,$message->number,$message->message,$message);
-			}
+            foreach($messages as $message)
+            {
+                Utilities::retrySms($message->sender_id,$message->number,$message->message,$message);
+            }
 			
 			
-			// Update Status
-			$messages = Sms_log::whereNotIn('status', ['Delivered','Failed','offline'])->get();
+            // Update Status
+            $messages = Sms_log::whereNotIn('status', ['Delivered','Failed','offline'])->get();
 
-			foreach($messages as $message)
-				{
-					$sms_shoot_id = $message->shoot_id;				
-					$api_url = "http://logonutility.in/app/miscapi/".$api_key."/getDLR/".$sms_shoot_id;
+            foreach($messages as $message)
+                {
+                    $sms_shoot_id = $message->shoot_id;				
+                    $api_url = "http://logonutility.in/app/miscapi/".$api_key."/getDLR/".$sms_shoot_id;
 
-					//Submit to server
-					$response = file_get_contents($api_url);
+                    //Submit to server
+                    $response = file_get_contents($api_url);
 					
 					
-					$dlr_array = json_decode($response);
+                    $dlr_array = json_decode($response);
 
-					//Update Status
-					$message->status = $dlr_array[0]->DLR;
-					$message->save();
-				}
-		}
+                    //Update Status
+                    $message->status = $dlr_array[0]->DLR;
+                    $message->save();
+                }
+        }
 				
-	}
+    }
 
 }
 

Spacing +39 added lines, -39 removed lines

@@ -11,7 +11,7 @@ 
 
 class Utilities {
 
-static function setActiveMenu($uri,$isParent = false)
+static function setActiveMenu($uri, $isParent = false)
 {
 	$class = ($isParent) ? 'active open' : 'active';
     return \Request::is($uri) ? $class : '';
@@ -21,7 +21,7 @@ 
 // Get Setting
 static function getSetting($key)
 {
-	$settingValue = Setting::where('key','=',$key)->pluck('value');
+	$settingValue = Setting::where('key', '=', $key)->pluck('value');
 	return $settingValue;
 }
 
@@ -317,17 +317,17 @@ 
 }
 
 // Set invoice status
-static function setInvoiceStatus($amount_due,$invoice_total)
+static function setInvoiceStatus($amount_due, $invoice_total)
 {
-	if($amount_due == 0)
+	if ($amount_due == 0)
     {
          $paymentStatus = \constPaymentStatus::Paid;
     } 
-    elseif($amount_due > 0 && $amount_due < $invoice_total) 
+    elseif ($amount_due > 0 && $amount_due < $invoice_total) 
     {
         $paymentStatus = \constPaymentStatus::Partial;
     }
-    elseif($amount_due == $invoice_total) 
+    elseif ($amount_due == $invoice_total) 
     {
         $paymentStatus = \constPaymentStatus::Unpaid;
     }
@@ -495,7 +495,7 @@ 
 	}
 }
 
-static function getGreeting(){
+static function getGreeting() {
 	//$time = date("H");
 	$time = Carbon::now()->hour;
     /* If the time is less than 1200 hours, show good morning */
@@ -532,8 +532,8 @@ 
                 	File::delete(public_path('assets/img/gym/gym_logo.jpg'));
                 	$fileName = "gym_logo.jpg";
                     $destinationPath = public_path($upload_path);
-                    $request->file($upload_field)->move($destinationPath,$fileName);
-                    Image::make($destinationPath."/".$fileName)->resize(600, null, function ($constraint) {
+                    $request->file($upload_field)->move($destinationPath, $fileName);
+                    Image::make($destinationPath."/".$fileName)->resize(600, null, function($constraint) {
 																					    $constraint->aspectRatio();
 																					})->save();
                 }
@@ -543,12 +543,12 @@ 
 	static function registrationsTrend()
 	{
 		// Get Financial date
-		$startDate = new Carbon(Setting::where('key','=','financial_start')->pluck('value'));
+		$startDate = new Carbon(Setting::where('key', '=', 'financial_start')->pluck('value'));
 		$data = array();
 		
-		for ($i=1; $i <= 12 ; $i++) { 
+		for ($i = 1; $i <= 12; $i++) { 
 			//$members = member::registrations($startDate->month,$startDate->year); // Laravel Scoped Query Issue: Workaroud Needed
-			$members = Member::whereMonth('created_at', '=', $startDate->month)->whereYear('created_at', '=',$startDate->year)->count();
+			$members = Member::whereMonth('created_at', '=', $startDate->month)->whereYear('created_at', '=', $startDate->year)->count();
 			$data[] = array("month" => $startDate->format('Y-m'), "registrations" => $members);
 			$startDate->addMonth();
 		}
@@ -565,8 +565,8 @@ 
 
 		foreach ($plans as $plan) 
 		{
-			$subscriptions = Subscription::where('status','=',\constSubscription::onGoing)->where('plan_id','=',$plan->id)->count();
-			$data[] = array('label' =>$plan->plan_name ,'value'=>$subscriptions);
+			$subscriptions = Subscription::where('status', '=', \constSubscription::onGoing)->where('plan_id', '=', $plan->id)->count();
+			$data[] = array('label' =>$plan->plan_name, 'value'=>$subscriptions);
 		}
 		return json_encode($data);		
 	}
@@ -580,7 +580,7 @@ 
 
 			$api_url = "http://logonutility.in/app/miscapi/".$api_key."/getBalance/true/";
 
-			if(Utilities::isDomainAvailible($api_url))
+			if (Utilities::isDomainAvailible($api_url))
 	        {
 	               return true;
 	        }
@@ -590,7 +590,7 @@ 
 	        }			
 						
 		}
-		catch(Exception $e)
+		catch (Exception $e)
 		{
 			return false;
 		}
@@ -601,17 +601,17 @@ 
    static function isDomainAvailible($domain)
    {
        //check, if a valid url is provided
-       if(!filter_var($domain, FILTER_VALIDATE_URL))
+       if (!filter_var($domain, FILTER_VALIDATE_URL))
        {
                return false;
        }
 
        //initialize curl
        $curlInit = curl_init($domain);
-       curl_setopt($curlInit,CURLOPT_CONNECTTIMEOUT,10);
-       curl_setopt($curlInit,CURLOPT_HEADER,true);
-       curl_setopt($curlInit,CURLOPT_NOBODY,true);
-       curl_setopt($curlInit,CURLOPT_RETURNTRANSFER,true);
+       curl_setopt($curlInit, CURLOPT_CONNECTTIMEOUT, 10);
+       curl_setopt($curlInit, CURLOPT_HEADER, true);
+       curl_setopt($curlInit, CURLOPT_NOBODY, true);
+       curl_setopt($curlInit, CURLOPT_RETURNTRANSFER, true);
 
        //get answer
        $response = curl_exec($curlInit);
@@ -624,14 +624,14 @@ 
    }
 
 
-	static function Sms($sender_id,$member_contact,$sms_text,$sms_status)
+	static function Sms($sender_id, $member_contact, $sms_text, $sms_status)
 	{
 		$sms = Utilities::getSetting('sms');
 		$gatewayStatus = Utilities::smsGatewayStatus();
 
 		if ($sms && $sms_status) 
 		{
-			if($gatewayStatus)
+			if ($gatewayStatus)
 			{
 				$api_key = Utilities::getSetting('sms_api_key');
 				$contacts = $member_contact;
@@ -644,7 +644,7 @@ 
 				//Submit to server
 				$response = file_get_contents($api_url);
 
-				if (str_contains($response,'SMS-SHOOT-ID')) 
+				if (str_contains($response, 'SMS-SHOOT-ID')) 
 				{
 					//Log entry for SMS_log table
 					$SmsLogData = array('shoot_id' => substr($response, strpos($response, "SMS-SHOOT-ID/") + 13),
@@ -654,7 +654,7 @@ 
 										'send_time' => Carbon::now(),
 										'status' => 'NA');
 
-					$SmsLog  = new Sms_log($SmsLogData);
+					$SmsLog = new Sms_log($SmsLogData);
 					$SmsLog->save();
 				}
 				//Update SMS balance
@@ -669,18 +669,18 @@ 
 									'send_time' => Carbon::now(),
 									'status' => 'offline');
 
-				$SmsLog  = new Sms_log($SmsLogData);
+				$SmsLog = new Sms_log($SmsLogData);
 				$SmsLog->save();
 			}
 			
 		}
 	}
 
-	static function retrySms($sender_id,$member_contact,$sms_text,$log)
+	static function retrySms($sender_id, $member_contact, $sms_text, $log)
 	{
 		$gatewayStatus = Utilities::smsGatewayStatus();
 
-		if($gatewayStatus)
+		if ($gatewayStatus)
 		{
 			$api_key = Utilities::getSetting('sms_api_key');
 			$contacts = $member_contact;
@@ -693,7 +693,7 @@ 
 			//Submit to server
 			$response = file_get_contents($api_url);
 
-			if (str_contains($response,'SMS-SHOOT-ID')) 
+			if (str_contains($response, 'SMS-SHOOT-ID')) 
 			{
 				//Log entry for SMS_log table
 				$log->update(['shoot_id' => substr($response, strpos($response, "SMS-SHOOT-ID/") + 13),
@@ -714,7 +714,7 @@ 
 		$sms = Utilities::getSetting('sms');
 		$gatewayStatus = Utilities::smsGatewayStatus();
 
-		if($sms && $gatewayStatus)
+		if ($sms && $gatewayStatus)
 		{
 			$api_key = Utilities::getSetting('sms_api_key');
 
@@ -724,12 +724,12 @@ 
 
 			$credit_balance = file_get_contents($api_url);
 			$balance = json_decode($credit_balance);
-			Setting::where('key', '=','sms_balance')->update(['value' => $balance[0]->BALANCE]);
+			Setting::where('key', '=', 'sms_balance')->update(['value' => $balance[0]->BALANCE]);
 
 			// If balance turns zero turn off SMS
-			if($balance[0]->BALANCE == 0)
+			if ($balance[0]->BALANCE == 0)
 			{
-				Setting::where('key', '=','sms')->update(['value' => 0]);
+				Setting::where('key', '=', 'sms')->update(['value' => 0]);
 			}
 		}
 	}
@@ -739,23 +739,23 @@ 
 		$sms = Utilities::getSetting('sms');
 		$gatewayStatus = Utilities::smsGatewayStatus();
 
-		if($sms && $gatewayStatus)
+		if ($sms && $gatewayStatus)
 		{
 			$api_key = Utilities::getSetting('sms_api_key');
 			
 			// Retry Offline Msg
-			$messages = Sms_log::where('status','offline')->get();
+			$messages = Sms_log::where('status', 'offline')->get();
 		
-			foreach($messages as $message)
+			foreach ($messages as $message)
 			{
-				Utilities::retrySms($message->sender_id,$message->number,$message->message,$message);
+				Utilities::retrySms($message->sender_id, $message->number, $message->message, $message);
 			}
 			
 			
 			// Update Status
-			$messages = Sms_log::whereNotIn('status', ['Delivered','Failed','offline'])->get();
+			$messages = Sms_log::whereNotIn('status', ['Delivered', 'Failed', 'offline'])->get();
 
-			foreach($messages as $message)
+			foreach ($messages as $message)
 				{
 					$sms_shoot_id = $message->shoot_id;				
 					$api_url = "http://logonutility.in/app/miscapi/".$api_key."/getDLR/".$sms_shoot_id;

Braces +9 added lines, -13 removed lines

@@ -322,16 +322,13 @@ 
 	if($amount_due == 0)
     {
          $paymentStatus = \constPaymentStatus::Paid;
-    } 
-    elseif($amount_due > 0 && $amount_due < $invoice_total) 
+    } elseif($amount_due > 0 && $amount_due < $invoice_total) 
     {
         $paymentStatus = \constPaymentStatus::Partial;
-    }
-    elseif($amount_due == $invoice_total) 
+    } elseif($amount_due == $invoice_total) 
     {
         $paymentStatus = \constPaymentStatus::Unpaid;
-    }
-    else
+    } else
     {
         $paymentStatus = \constPaymentStatus::Overpaid;
     }    
@@ -583,14 +580,12 @@ 
 			if(Utilities::isDomainAvailible($api_url))
 	        {
 	               return true;
-	        }
-	        else
+	        } else
 	        {
 	               return false;
 	        }			
 						
-		}
-		catch(Exception $e)
+		} catch(Exception $e)
 		{
 			return false;
 		}
@@ -618,7 +613,9 @@ 
 
        curl_close($curlInit);
 
-       if ($response) return true;
+       if ($response) {
+           return true;
+       }
 
        return false;
    }
@@ -659,8 +656,7 @@ 
 				}
 				//Update SMS balance
 				Utilities::smsBalance();
-			}
-			else
+			} else
 			{
 				$SmsLogData = array('shoot_id' => '',
 									'number' => $member_contact,

app/Lubus/ImageFilters/Invoice.php

Indentation +3 added lines, -3 removed lines

@@ -9,7 +9,7 @@
     public function applyFilter(Image $image)
     {
         return $image->resize(150, null, function ($constraint) {
-		    $constraint->aspectRatio();
-		})->encode('jpg', 100);   
-	}
+            $constraint->aspectRatio();
+        })->encode('jpg', 100);   
+    }
 }
\ No newline at end of file

Spacing +1 added lines, -1 removed lines

@@ -8,7 +8,7 @@
 {
     public function applyFilter(Image $image)
     {
-        return $image->resize(150, null, function ($constraint) {
+        return $image->resize(150, null, function($constraint) {
 		    $constraint->aspectRatio();
 		})->encode('jpg', 100);   
 	}

app/Lubus/constants.php

Indentation +28 added lines, -28 removed lines

@@ -16,15 +16,15 @@ 
 
 //Follow Up Status
 class constFollowUpStatus {
-	const Pending = 0;
-	const Done = 1;
+    const Pending = 0;
+    const Done = 1;
 }
 
 //Follow Up By
 class constFollowUpBy {
-	const Call = 0;
-	const SMS = 1;
-	const Personal = 2;
+    const Call = 0;
+    const SMS = 1;
+    const Personal = 2;
 }
 
 // File PATHS
@@ -36,53 +36,53 @@ 
 }
 
 class constFilePrefix {
-	const UserProfilePhoto = 'profile_';
-	const UserProofPhoto = 'proof_';
-	const StaffPhoto = 'staff_';
+    const UserProfilePhoto = 'profile_';
+    const UserProofPhoto = 'proof_';
+    const StaffPhoto = 'staff_';
 }
 
 // Payment status
 class constPaymentStatus {
-	const Unpaid = 0;
-	const Paid = 1;
-	const Partial = 2;
-	const Overpaid = 3;
+    const Unpaid = 0;
+    const Paid = 1;
+    const Partial = 2;
+    const Overpaid = 3;
 }
 
 // Cheque status
 class constChequeStatus {
-	const Recieved = 0;
-	const Deposited = 1;
-	const Cleared = 2;
-	const Bounced = 3;
-	const Reissued = 4;
+    const Recieved = 0;
+    const Deposited = 1;
+    const Cleared = 2;
+    const Bounced = 3;
+    const Reissued = 4;
 }
 
 // Invoice Items
 class constInvoiceItem {
-	const admission = "Admission";
-	const gymSubscription = "Gym Subscription";
-	const taxes = "Taxes";
+    const admission = "Admission";
+    const gymSubscription = "Gym Subscription";
+    const taxes = "Taxes";
 }
 
 //subscription
 class constSubscription {
-	const Expired = 0;
-	const onGoing = 1;
-	const renewed = 2;
-	const cancelled = 3;  
+    const Expired = 0;
+    const onGoing = 1;
+    const renewed = 2;
+    const cancelled = 3;  
 }
 
 //numbering mode
 class constNumberingMode {
-	const Manual = 0;
-	const Auto = 1;
+    const Manual = 0;
+    const Auto = 1;
 }
 
 //Payment mode
 class constPaymentMode {
-	const Cheque = 0;
-	const Cash = 1;
+    const Cheque = 0;
+    const Cash = 1;
 }
 
 ?>
\ No newline at end of file

app/Service.php

Indentation +4 added lines, -4 removed lines

@@ -11,10 +11,10 @@
     protected $table = 'mst_services';
 
     protected $fillable = [
-    		'name',
-    		'description',
-    		'created_by',
-    		'updated_by'
+            'name',
+            'description',
+            'created_by',
+            'updated_by'
     ];
 
     //Eloquence Search mapping

Spacing +3 added lines, -3 removed lines

@@ -27,16 +27,16 @@
 
     public function createdBy()
     {
-        return $this->belongsTo('App\User','created_by');
+        return $this->belongsTo('App\User', 'created_by');
     }
 
     public function updatedBy()
     {
-        return $this->belongsTo('App\User','updated_by');
+        return $this->belongsTo('App\User', 'updated_by');
     }
 
     public function Plans()
     {
-        return $this->hasMany('App\Plan','service_id');
+        return $this->hasMany('App\Plan', 'service_id');
     }
 }

app/Sms_trigger.php

Spacing +2 added lines, -2 removed lines

@@ -27,11 +27,11 @@
 
     public function createdBy()
     {
-        return $this->belongsTo('App\User','created_by');
+        return $this->belongsTo('App\User', 'created_by');
     }
 
     public function updatedBy()
     {
-        return $this->belongsTo('App\User','updated_by');
+        return $this->belongsTo('App\User', 'updated_by');
     }
 }

Indentation +3 added lines, -3 removed lines

@@ -11,10 +11,10 @@
 
     protected $fillable = [
             'name',
-    		'alias',
+            'alias',
             'message',
-    		'status',
-    		'updated_by'
+            'status',
+            'updated_by'
     ];
 
     const CREATED_AT = null;

app/Sms_log.php

Indentation +1 added lines, -1 removed lines

@@ -33,6 +33,6 @@
 
     public function scopeDashboardLogs($query)
     {
-    	return $query->where('send_time','<=',Carbon::now())->take(5)->orderBy('send_time','desc');
+        return $query->where('send_time','<=',Carbon::now())->take(5)->orderBy('send_time','desc');
     }
 }

Spacing +2 added lines, -2 removed lines

@@ -20,7 +20,7 @@ 
 
     public $timestamps = false;
     
-    protected $dates  = ['send_time'];
+    protected $dates = ['send_time'];
 
     //Eloquence Search mapping
     use Eloquence;
@@ -33,6 +33,6 @@ 
 
     public function scopeDashboardLogs($query)
     {
-    	return $query->where('send_time','<=',Carbon::now())->take(5)->orderBy('send_time','desc');
+    	return $query->where('send_time', '<=', Carbon::now())->take(5)->orderBy('send_time', 'desc');
     }
 }

app/Permission.php

Indentation +4 added lines, -4 removed lines

@@ -7,13 +7,13 @@
 class Permission extends EntrustPermission
 {
 
-	protected $table = 'permissions';
+    protected $table = 'permissions';
 
     protected $fillable = [
-    		'name',
-    		'display_name',
+            'name',
+            'display_name',
             'description',
-    		'group_key',
+            'group_key',
     ];
 
     public function Roles()

app/Luser.php

Indentation +5 added lines, -5 removed lines

@@ -9,10 +9,10 @@
     protected $table = 'mst_staff';
 
     protected $fillable = [
-    		'username',
-    		'password',
-    		'name',
-    		'created_by',
-    		'updated_by'
+            'username',
+            'password',
+            'name',
+            'created_by',
+            'updated_by'
     ];
 }

app/Followup.php

Indentation +29 added lines, -29 removed lines

@@ -8,35 +8,35 @@
 
 class Followup extends Model
 {
-	protected $table = 'trn_enquiry_followups';
-
-	protected $fillable = [
-		'enquiry_id',
-		'followup_by',
-		'due_date',
-		'status',
-		'outcome',
-		'created_by',
-    	'updated_by',
-	];
-
-	protected $dates  = ['created_at', 'updated_at', 'due_date'];
-
-	public function Enquiry()
-	{
-		return $this->belongsTo('App\Enquiry','enquiry_id');
-	}
-
-	public function scopeReminders($query)
-	{
-		return $query->leftJoin('mst_enquiries','trn_enquiry_followups.enquiry_id','=','mst_enquiries.id')
-					 ->select('trn_enquiry_followups.*','mst_enquiries.status')
-					 ->where('trn_enquiry_followups.due_date','<=',Carbon::today())
-					 ->where('trn_enquiry_followups.status','=',\constFollowUpStatus::Pending)
-					 ->where('mst_enquiries.status','=',\constEnquiryStatus::Lead);
-	}
-
-	public function createdBy()
+    protected $table = 'trn_enquiry_followups';
+
+    protected $fillable = [
+        'enquiry_id',
+        'followup_by',
+        'due_date',
+        'status',
+        'outcome',
+        'created_by',
+        'updated_by',
+    ];
+
+    protected $dates  = ['created_at', 'updated_at', 'due_date'];
+
+    public function Enquiry()
+    {
+        return $this->belongsTo('App\Enquiry','enquiry_id');
+    }
+
+    public function scopeReminders($query)
+    {
+        return $query->leftJoin('mst_enquiries','trn_enquiry_followups.enquiry_id','=','mst_enquiries.id')
+                        ->select('trn_enquiry_followups.*','mst_enquiries.status')
+                        ->where('trn_enquiry_followups.due_date','<=',Carbon::today())
+                        ->where('trn_enquiry_followups.status','=',\constFollowUpStatus::Pending)
+                        ->where('mst_enquiries.status','=',\constEnquiryStatus::Lead);
+    }
+
+    public function createdBy()
     {
         return $this->belongsTo('App\User','created_by');
     }

Spacing +9 added lines, -9 removed lines

@@ -20,29 +20,29 @@
     	'updated_by',
 	];
 
-	protected $dates  = ['created_at', 'updated_at', 'due_date'];
+	protected $dates = ['created_at', 'updated_at', 'due_date'];
 
 	public function Enquiry()
 	{
-		return $this->belongsTo('App\Enquiry','enquiry_id');
+		return $this->belongsTo('App\Enquiry', 'enquiry_id');
 	}
 
 	public function scopeReminders($query)
 	{
-		return $query->leftJoin('mst_enquiries','trn_enquiry_followups.enquiry_id','=','mst_enquiries.id')
-					 ->select('trn_enquiry_followups.*','mst_enquiries.status')
-					 ->where('trn_enquiry_followups.due_date','<=',Carbon::today())
-					 ->where('trn_enquiry_followups.status','=',\constFollowUpStatus::Pending)
-					 ->where('mst_enquiries.status','=',\constEnquiryStatus::Lead);
+		return $query->leftJoin('mst_enquiries', 'trn_enquiry_followups.enquiry_id', '=', 'mst_enquiries.id')
+					 ->select('trn_enquiry_followups.*', 'mst_enquiries.status')
+					 ->where('trn_enquiry_followups.due_date', '<=', Carbon::today())
+					 ->where('trn_enquiry_followups.status', '=', \constFollowUpStatus::Pending)
+					 ->where('mst_enquiries.status', '=', \constEnquiryStatus::Lead);
 	}
 
 	public function createdBy()
     {
-        return $this->belongsTo('App\User','created_by');
+        return $this->belongsTo('App\User', 'created_by');
     }
 
     public function updatedBy()
     {
-        return $this->belongsTo('App\User','updated_by');
+        return $this->belongsTo('App\User', 'updated_by');
     }
 }
\ No newline at end of file