public function postChangefeed() { User::onlyHas('feed-edit'); $id = Input::get('id'); $fields = Input::get('addfields'); $exists = []; foreach (FeedField::get_($id) as $field) { $exists[$field->id] = $field; } // Insert inexistent fields foreach ($fields as $fieldId) { if (isset($exists[$fieldId]) == FALSE) { $newField = new FeedRel(); $newField->feed_id = $id; $newField->feed_field_id = $fieldId; $newField->save(); } } // Delete Existent fields foreach ($exists as $field) { if (in_array($field->id, $fields) == FALSE) { FeedRel::where('feed_field_id', $field->id)->where('feed_id', $id)->delete(); FeedFieldValue::where('feed_field_id', $field->id)->whereIn('post_id', function ($query) use($id) { $query->select(FeedPost::getField('post_id'))->from(FeedPost::getTableName())->where('feed_id', $id); })->delete(); } } return Illuminate\Support\Facades\Redirect::back(); }
// Closed }); /* |------------------------------------------------------------------ |Guest Routes |-------------------------------------------------------------------- | Here defining Guest User's routes | | */ // seasrch Route::POST('tickets/search/', function () { $keyword = Illuminate\Support\Str::lower(Input::get('auto')); $models = App\Model\Ticket\Tickets::where('ticket_number', '=', $keyword)->orderby('ticket_number')->take(10)->skip(0)->get(); $count = count($models); return Illuminate\Support\Facades\Redirect::back()->with("contents", $models)->with("counts", $count); }); Route::any('getdata', function () { $term = Illuminate\Support\Str::lower(Input::get('term')); $data = Illuminate\Support\Facades\DB::table("tickets")->distinct()->select('ticket_number')->where('ticket_number', 'LIKE', $term . '%')->groupBy('ticket_number')->take(10)->get(); foreach ($data as $v) { return ['value' => $v->ticket_number]; } }); Route::get('getform', ['as' => 'guest.getform', 'uses' => 'Client\\helpdesk\\FormController@getForm']); /* get the form for create a ticket by guest user */ Route::post('postform/{id}', 'Client\\helpdesk\\FormController@postForm'); /* post the AJAX form for create a ticket by guest user */ Route::post('postedform', 'Client\\helpdesk\\FormController@postedForm'); /* post the form to store the value */ Route::get('check', 'CheckController@getcheck');