";
$getSubscription = CwoSubscription::where('status', '1')
->where('end_date', '<', $today)
->limit(20)
->get();
// print_r($getSubscription->toArray());exit;
if($getSubscription != ''){
foreach ($getSubscription as $s) {
echo "cwo subscription id: " . $s->id . "
";
$cwoSubscription = CwoSubscription::findorfail($s->id);
$cwoSubscription->update([
'status'=>'0',
'updated_at'=>$dt->toDayDateTimeString()
]);
$getCwoCount = CarWashOwner::where('id', $s->cwo_id)->where('cwo_subscription_id', $s->id)->count();
echo "cwo count" . $getCwoCount . "
";
if($getCwoCount > 0){
$cwoDetails = CarWashOwner::findorfail($s->cwo_id);
$cwoDetails->update([
'is_paid'=>'0',
'updated_at'=>$dt->toDayDateTimeString()
]);
}
}
}
}
public function unsubscribeFreeTrial(Request $request){
$dt = Carbon::now();
$today = date("Y-m-d");
echo "today - " . $today . "
";
$getSubscription = CarWashOwner::where('free_trial', 1)
->where('is_paid', 1)
->where('end_date', '<', $today)
->limit(20)
->get();
// print_r($getSubscription->toArray());exit;
if($getSubscription != ''){
foreach ($getSubscription as $s) {
echo "cwo id: " . $s->id . "
";
$cwoDetails = CarWashOwner::findorfail($s->id);
$cwoDetails->update([
'is_paid'=>'0',
'free_trial'=>'0',
'updated_at'=>$dt->toDayDateTimeString()
]);
}
}
}
}