public static function device($parameter = "") { $from = \Carbon\Carbon::now()->modify('-3 month'); $to = \Carbon\Carbon::now(); if ($parameter == "") { return Md\Device::count(); } if ($parameter == "trial") { return Md\Device::where(function ($query) use($from, $to) { $query->whereBetween('created_at', array($from, $to)); })->count(); } if ($parameter == "active") { return Md\Device::where(function ($query) use($from, $to) { $query->whereBetween('created_at', array($from, $to))->Where('created_at', '<=', $from); })->count(); } }