public function search($input)
{
$query = Partners::query();
$columns = Schema::getColumnListing('partners');
$attributes = array();
foreach ($columns as $attribute) {
if (isset($input[$attribute]) and !empty($input[$attribute])) {
$query->where($attribute, $input[$attribute]);
$attributes[$attribute] = $input[$attribute];
} else {
$attributes[$attribute] = null;
}
}
return [$query->get(), $attributes];
}
public static function partner($parameter = "")
{
$from = \Carbon\Carbon::now()->modify('-3 month');
$to = \Carbon\Carbon::now();
if ($parameter == "") {
return Md\Partners::where('status', 'active')->count();
}
if ($parameter == "trial") {
return Md\Partners::where(function ($query) use($from, $to) {
$query->where('status', 'active')->whereBetween('created_at', array($from, $to));
})->count();
}
if ($parameter == "active") {
return Md\Partners::where(function ($query) use($from, $to) {
$query->where('status', 'active')->whereBetween('created_at', array($from, $to))->Where('created_at', '<=', $from);
})->count();
}
}
