Viewing file:  Plan.php (1.57 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
namespace App\Models;
use DB;
use Illuminate\Database\Eloquent\Model;
class Plan extends Model
{
protected $fillable = [
'name',
'price',
'duration',
'max_users',
'max_customers',
'max_drivers',
'max_taxis',
'max_venders',
'max_clients',
'max_blood_collectors',
'trial',
'trial_days',
'description',
'image',
'crm',
'hrm',
'account',
'project',
'blood_collector',
'pos',
'chatgpt',
'taxi_system',
'storage_limit',
'product_system'
];
private static $getplans = NULL;
public static $arrDuration = [
'lifetime' => 'Lifetime',
'month' => 'Per Month',
'year' => 'Per Year',
];
public function status()
{
return [
__('lifetime'),
__('Per Month'),
__('Per Year'),
];
}
public static function total_plan()
{
return Plan::count();
}
public static function most_purchese_plan()
{
$free_plan = Plan::where('price', '<=', 0)->first()->id;
$plan = User::select(DB::raw('count(*) as total') , 'plan')->where('type', '=', 'company')->where('plan', '!=', $free_plan)->groupBy('plan')->first();
return $plan;
}
public static function getPlan($id)
{
// dd($id);
if(self::$getplans == null)
{
$plan = Plan::find($id);
self::$getplans = $plan;
}
return self::$getplans;
}
}
|