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;
 }