public static function has_associated_members($package_id) { $member_packages = Memberpackage::where('package_id', '=', $package_id)->count(); if ($member_packages > 0) { return true; } else { return false; } }
/** * @return Checks if the member has this package then return the package object if exists. Return false if not */ public static function still_has($member_id, $package_id) { $package = Memberpackage::where('member_id', '=', $member_id)->where('package_id', '=', $package_id); if ($package->count() > 0) { return $package; } else { return false; } }
/** * Execute the console command. * * @return void */ public function fire() { DB::table('members_packages')->whereRaw("UNIX_TIMESTAMP(expiration) <= " . strtotime("NOW"))->update(array('status' => 0)); echo "Membership packages has been updated."; // SENDS EMAIL TO THE MEMBERS WITH EXPIRED PACKAGES if (Setting::value('email_users_expire') == 'yes') { // FIND THE MEMBERS $packages = Memberpackage::where('status', '=', 0)->where('expiration', '=', date("Y-m-d 00:00:00"))->get(); foreach ($packages as $package) { if ($package->member->email != '') { $data = array('package' => $package->package->service->name, 'date' => date("F j,Y", strtotime($package->expiration)), 'name' => $package->member->first_name); Mail::queue('emails.expired', $data, function ($message) use($package) { $message->to($package->member->email, $package->member->first_name)->subject('You package has expired.'); }); } else { // SEND THROUGH SMS INSTEAD ( FUTURE FEATURE) } } } }
public function expires() { $this->data['packages'] = Memberpackage::whereRaw("UNIX_TIMESTAMP(expiration) <= " . strtotime('NOW'))->orderBy('id', 'desc')->paginate(50); return $this->layout->content = View::make('packages_expires', $this->data); }
public function delete_package() { $this->layout = ''; $package_id = Input::get('package_id'); $memberpackage = Memberpackage::find($package_id); $memberpackage->delete(); echo 1; }