PHP Item::onlyTrashed方法代码示例

/**
 * RESTORE an item 
 *
 * (the model migth allow soft deletes!)
 *
 * Make sure the new sequence number fits sequentially into 
 *    the list of sequence numbers of the existing items for a plan
 *    and that all current sequence numbers are in 1.0 steps
 *
 * @param object $items
 * @param number $new_seq_no
 */
function restoreItem($id)
{
    // this item should be restored
    $item = Item::onlyTrashed()->find($id);
    if (!$item) {
        return false;
    }
    $item->restore();
    // get all items of the related plan
    $plan = Plan::find($item->plan_id);
    $items = $plan->items()->orderBy('seq_no')->get();
    // numbering them countering with 1.0
    $counter = 1.0;
    foreach ($items as $item) {
        if ($item->seq_no != $counter) {
            $i = Item::find($item->id);
            # get the actual DB record
            $item->seq_no = $counter;
            # update the current selection
            $i->seq_no = $counter;
            # update the seq_no
            $i->save();
            # save the record
        }
        $counter += 1.0;
    }
    return true;
}

 /**
  * RESTORE all trashed items of a plan
  *
  */
 public function restoreAllTrashed($plan_id)
 {
     // this item should be restored
     $items = Item::onlyTrashed()->where('plan_id', $plan_id)->get();
     if (!$items) {
         return false;
     }
     // restore all items and try to restore their correct sequence number
     foreach ($items as $item) {
         restoreItem($item->id);
     }
     flash('All trashed items restored. Please review the sequence!');
     return \Redirect::back();
 }

 /**
  * PLAN DETAILS form
  *
  * @param  int  $id
  * @param  int  $new_item_id    indicates a newly inserted item 
  * @return \Illuminate\Http\Response
  */
 public function edit($id)
 {
     // find a single plan by ID
     $plan = Plan::with(['items' => function ($query) {
         $query->withTrashed()->orderBy('seq_no');
     }])->find($id);
     if ($plan) {
         // get list of service types
         $types = Type::get();
         // get list of users
         $users = User::orderBy('first_name')->get();
         // get list of trashed items (if any)
         $trashedItemsCount = Item::onlyTrashed()->where('plan_id', $id)->count();
         // check if a new item was just now inserted (used for highlighing in the view)
         $newest_item_id = 0;
         if (session()->has('newest_item_id')) {
             $newest_item_id = session()->get('newest_item_id');
             session()->forget('newest_item_id');
         }
         // get service times from plan dates
         $plan->start = Carbon::instance($plan->date)->toTimeString();
         // for backwards compatibility, we allowed for null as end date
         if ($plan->date_end) {
             $plan->end = Carbon::instance($plan->date_end)->toTimeString();
         } else {
             $plan->end = "23:59";
         }
         return view($this->view_one, array('plan' => $plan, 'types' => $types, 'users' => $users, 'versionsEnum' => json_decode(env('BIBLE_VERSIONS')), 'newest_item_id' => $newest_item_id, 'trashedItemsCount' => $trashedItemsCount));
     }
     flashError('Plan with id "' . $id . '" not found');
     return \Redirect::route($this->view_idx);
 }