public function delete($id)
{
LanguageModel::where('id', $id)->delete();
$alert['msg'] = 'Language has been deleted successfully';
$alert['type'] = 'success';
return Redirect::route('language')->with('alert', $alert);
}
public function getAutoCompleteWordsAjax(Request $request)
{
if (!$request->ajax()) {
return response()->json(['response' => 'reject', 'msg' => 'request Not Allowed', 'searchWord' => $request->searchWord, 'language' => $request->languageName, 'Ajax' => $request->ajax(), 'Request' => $request->method()]);
}
$searchWord = $request->searchWord;
$languageId = Language::where('id', '=', $request->languageId)->value('id');
$Words = Word::where('language_id', '=', $languageId)->where('word', 'LIKE', $searchWord . '%')->orderBy('word', 'asc')->limit(10)->get();
return $Words;
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$now = date('Y-m-d H:i:s', strtotime('now'));
$languages = [['name' => 'english', 'description' => 'the Language English', 'created_at' => $now, 'updated_at' => $now], ['name' => 'danish', 'description' => 'the Language Danish, spoken in Denmark', 'created_at' => $now, 'updated_at' => $now], ['name' => 'pashto', 'description' => 'the Language Pashto, spoken in Afghanistan', 'created_at' => $now, 'updated_at' => $now]];
foreach ($languages as $language) {
if (\App\Models\Language::where('name', '=', $language['name'])->exists()) {
echo $language['name'] . " Already exists\n";
} else {
\App\Models\Language::create($language);
}
}
//DB::table('words')->truncate();
//Schema::drop('words');
$passed = 0;
$exists = 0;
//word table - seed from a file
// $pashto_json = File::get(storage_path() . "/app/json_data/pashto.json");
// $pashto_word = json_decode($pashto_json);
//
// foreach ($pashto_word as $wordObj)
// {
// if(\App\Models\Word::where('word', '=', $wordObj->s2p[0])->exists())
// {
// echo $wordObj->s2p[0] . " Already exists\n";
// $exists++;
// }
// else
// {
// \App\Models\Word::create([
// 'language_id' => 3,
// 'user_id' => 3,
// 'word' => $wordObj->s2p[0],
// 'pronounce_audio_path' => '',
// 'pronounce_text' => 'pronounce_text missing',
// 'definition' => 'Word definition missing',
// 'created_at' => $now,
// 'updated_at' => $now,
// ]);
//
// $passed++;
// }
// }
foreach (File(storage_path() . "/app/danskOrde_49389.txt", FILE_SKIP_EMPTY_LINES | FILE_IGNORE_NEW_LINES) as $word) {
if (App\Models\Word::where(['language_id' => 2, 'word' => $word])->exists()) {
echo $word . ": Already exists in Danish\n";
$exists++;
} else {
App\Models\Word::create(['language_id' => 2, 'user_id' => 3, 'word' => $word, 'pronounce_audio_path' => '', 'pronounce_text' => 'pronounce_text missing', 'definition' => 'Word definition missing', 'created_at' => $now, 'updated_at' => $now]);
$passed++;
}
}
echo "\n Words Already Exists: " . $exists;
echo "\n Words added: " . $passed . "\n";
}
public function listing($page, $limit)
{
$response = array('data' => array(), 'paginator' => '');
if (!empty($limit)) {
$languages = Language::paginate($limit);
} else {
$languages = Language::where('id', '>', '0')->get();
}
if (!empty($languages)) {
foreach ($languages as $key => $language) {
$response['data'][] = $this->get($language->id, false);
}
}
if (!empty($limit)) {
$response = Utility::paginator($response, $languages, $limit);
}
return $response;
}
/**
* @SWG\Api(
* path="/language/get/{id}",
* @SWG\Operation(
* nickname="Get languge",
* method="GET",
* summary="Find language by ID",
* notes="Returns language",
* type="Language",
* authorizations={},
* @SWG\Parameter(
* name="id",
* description="ID of language",
* required=true,
* type="integer",
* format="int64",
* paramType="path",
* allowMultiple=false
* ),
* @SWG\ResponseMessage(code=404, message="language not found"),
* @SWG\ResponseMessage(code=500, message="Internal server error")
* )
* )
*/
public function get($id)
{
$statusCode = 200;
$response = [];
try {
$validator = Validator::make(['id' => $id], ['id' => 'required|numeric']);
if ($validator->fails()) {
$response = ['error' => $validator->errors()];
$statusCode = 500;
} else {
$languageModel = Models\Language::where('id', $id)->first();
if (!isset($languageModel)) {
throw new ModelNotFoundException();
}
$languageView = new ModelViews\Language($languageModel);
$response = $languageView->get();
}
} catch (ModelNotFoundException $e) {
$response = ['error' => 'Language doesn\'t exists'];
$statusCode = 404;
} finally {
return \Response::json($response, $statusCode);
}
}
public function getLocale()
{
$language = Language::where('id', '=', $this->account->language_id)->first();
return $language->locale;
}
public function getWordsAjax(Request $request)
{
//print_r($request->all());
if (!$request->ajax()) {
return response()->json(['response' => 'reject', 'msg' => 'request Not Allowed', 'searchWord' => $request->searchWord, 'language' => $request->languageName, 'Ajax' => $request->ajax(), 'Request' => $request->method()]);
}
$languageName = $request->languageName;
$searchWord = $request->searchWord;
$language = new Language();
$languageList = $language->lists('name')->all();
$words = Word::with(['user', 'language']);
if (!in_array($languageName, $languageList)) {
$languageName = '';
} else {
$language_id = $language->where('name', '=', $languageName)->value('id');
$words->where('language_id', '=', $language_id);
}
if ($searchWord != null) {
$words->where('word', 'LIKE', $searchWord . '%');
}
return $words->orderBy('word', 'asc')->limit(15)->get();
}
/**
* Returns name
*
* @return mixed
*/
public function getName()
{
$language = config('admin.default_language_code');
$languageId = Models\Language::where('code', $language)->first()->id;
return $this->model->descriptions()->where('language_id', $languageId)->first()->name;
}
