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');
