Beispiel #1
0
 /**
  * Execute the console command.
  *
  * @return mixed
  */
 public function handle()
 {
     $posts = Post::all(['slug', 'updated_at']);
     $works = Work::all(['slug', 'updated_at']);
     $this->sitemap = new Sitemap(public_path('sitemap.xml'));
     $this->comment('Starting generating the Sitemap...');
     // Home
     $this->addItem(config('app.url') . '/', 0.9);
     // Resume
     $this->addItem(config('app.url') . '/resume', 0.8);
     // Blog index
     $this->addItem(config('app.url') . '/blog', 0.8);
     // Works index
     $this->addItem(config('app.url') . '/works', 0.8);
     // @codeCoverageIgnoreStart
     // Blog posts
     foreach ($posts as $post) {
         $this->addItem(config('app.url') . '/blog/' . $post->slug, 0.7);
     }
     // Works items
     foreach ($works as $work) {
         $this->addItem(config('app.url') . '/works/' . $work->slug, 0.7);
     }
     // @codeCoverageIgnoreEnd
     $this->sitemap->write();
     $this->comment('Sitemap generated successfully!');
 }
 /**
  * Bootstrap any application services.
  *
  * @return void
  */
 public function boot()
 {
     WorkCategory::saving(function ($workCategory) {
         if ($workCategory->position > 0) {
             return true;
         }
         $workCategory->position = WorkCategory::max('position') + 1;
         return $workCategory;
     });
     Work::saving(function ($work) {
         if ($work->position > 0) {
             return true;
         }
         $work->position = Work::max('position') + 1;
         return $work;
     });
     Image::deleted(function ($image) {
         if (file_exists($image->path)) {
             unlink($image->path);
         }
         if (file_exists($image->thumbnail)) {
             unlink($image->thumbnail);
         }
         return true;
     });
 }
 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function show($slug)
 {
     $post = Post::where('slug', $slug)->firstOrFail();
     $moreWorks = Work::orderByRaw('RAND()')->take(3)->get();
     $morePosts = Post::where('slug', '!=', $post->slug)->orderByRaw('RAND()')->take(3)->get();
     return view('posts.show', compact("post", "moreWorks", "morePosts"));
 }
Beispiel #4
0
 public static function checkIfExists($text)
 {
     $work = Work::where('work_type_description', '=', $text)->first();
     if (!is_null($work)) {
         appGlobals::existsMessage(appGlobals::getWorkTableName(), $work->work_type_description, $work->id);
     }
     return $work;
 }
 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     // clear table
     \App\Work::truncate();
     // add 1st row
     \App\Work::create(['user_id' => 1, 'title' => 'Software Engineer', 'company' => 'Google Inc']);
     // add 2nd row
     \App\Work::create(['user_id' => 1, 'title' => 'System Administrator', 'company' => 'IBM', 'start' => \Carbon\Carbon::createFromDate(2010, 01, 10)->toDateTimeString(), 'end' => \Carbon\Carbon::createFromDate(2014, 07, 22)->toDateTimeString()]);
 }
 public function getMore($excludes)
 {
     $excludes = explode("SEPARATOR", $excludes);
     $whereString = "";
     foreach ($excludes as $exclude) {
         $whereString = $whereString . "slug != ? AND ";
     }
     $whereString = substr($whereString, 0, -5);
     $works = Work::whereRaw($whereString, $excludes)->take(3)->orderBy("created_at", "desc")->get();
     return view("works.ajax")->with("works", $works);
 }
 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     $works = \App\Work::where('status', 'active')->get()->toArray();
     $status = array('active', 'inactive');
     for ($i = 0; $i < 100; $i++) {
         $copy = new \App\Copy();
         $copy->work_id = $works[array_rand($works)]['id'];
         $copy->number = $i + 1;
         $copy->status = $status[array_rand($status)];
         $copy->save();
     }
 }
Beispiel #8
0
 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     DB::table('tags')->truncate();
     factory(App\Tag::class, 10)->create();
     $posts = Post::all();
     foreach ($posts as $post) {
         $tags = Tag::orderByRaw('RAND()')->take(rand(1, 5))->get(['id']);
         $post->tags()->sync($tags);
     }
     $works = Work::all();
     foreach ($works as $work) {
         $tags = Tag::orderByRaw('RAND()')->take(rand(1, 5))->get(['id']);
         $work->tags()->sync($tags);
     }
 }
Beispiel #9
0
 public function getWorks($parCategory)
 {
     // Retrieve offset param
     $offset = Input::get('offset');
     // Try to get current category by slug
     $category = Category::where('slug', $parCategory)->get()->first();
     // If not found try by id
     if (is_null($category)) {
         $category = Category::find($parCategory);
     }
     // Retrieve all works
     $works = is_null($category) ? Work::all() : $category->works;
     // Return the view
     return view('front.works', compact('works'));
 }
Beispiel #10
0
 public function run()
 {
     $faker = Faker\Factory::create();
     for ($i = 0; $i < 15; $i++) {
         $work['title'] = $faker->name;
         $work['intro_text'] = $faker->sentence($words = rand(10, 15));
         $work['lead'] = $faker->sentence($words = rand(10, 20));
         $work['content'] = $faker->sentence($words = rand(20, 40));
         $work['slug'] = $this->makeSlug($work['title']);
         $work['is_visible'] = 1;
         $work['is_featured'] = rand(0, 1);
         $work['gallery_id'] = 1;
         $work['type_id'] = rand(1, 5);
         \App\Work::create($work);
     }
 }
 /**
  * Register any other events for your application.
  *
  * @param  \Illuminate\Contracts\Events\Dispatcher  $events
  * @return void
  */
 public function boot(DispatcherContract $events)
 {
     parent::boot($events);
     // register the ProjectObserver class.
     Client::observe(new ClientObserver());
     // register the ProjectObserver class.
     Project::observe(new ProjectObserver());
     // register the WorkTypeObserver class.
     WorkType::observe(new WorkTypeObserver());
     // register the TimeCardFormatObserver class.
     TimeCardFormat::observe(new TimeCardFormatObserver());
     // register the WorkObserver class.
     Work::observe(new WorkObserver());
     // register the TimeCardObserver class.
     TimeCard::observe(new TimeCardObserver());
     // register the TimeCardHoursWorkedObserver class.
     TimeCardHoursWorked::observe(new TimeCardHoursWorkedObserver());
     // register the TaskTypeObserver class.
     TaskType::observe(new TaskTypeObserver());
     // register the TaskObserver class.
     Task::observe(new TaskObserver());
 }
Beispiel #12
0
 public function index()
 {
     return view('website.index')->with('categories', Category::orderBy('position', 'ASC')->get())->with('works', Work::orderBy('position', 'ASC')->get())->with('homeWorks', Work::where('display_home', true)->orderBy('position', 'ASC')->get());
 }
Route::get('auth/logout', 'Auth\\AuthController@getLogout');
Route::group(['namespace' => 'Admin', 'prefix' => 'admin', 'middleware' => 'auth'], function () {
    // Routes screens
    Route::resource('/users', 'UsersController');
    Route::resource('/loans', 'LoansController');
    Route::resource('/renew-loan-items', 'RenewLoanItemsController');
    Route::resource('/return-loan-items', 'ReturnLoanItemsController');
});
Route::group(['namespace' => 'Api', 'prefix' => 'api', 'middleware' => 'auth'], function () {
    // Routes services
    Route::resource('/users', 'UsersController');
    Route::resource('/loans', 'LoansController');
    Route::resource('/copies', 'CopiesController');
});
Route::get('/add-fake-copies', function () {
    $works = \App\Work::where('status', 'active')->get()->toArray();
    $status = array('active', 'inactive');
    for ($i = 1; $i < 50; $i++) {
        try {
            DB::beginTransaction();
            $copy = new \App\Copy();
            $copy->work_id = $works[array_rand($works)]['id'];
            $copy->number = $i;
            $copy->status = $status[array_rand($status)];
            $copy->save();
            DB::commit();
        } catch (Exception $e) {
            DB::rollBack();
        }
    }
    return array('ok');
Beispiel #14
0
 /**
  * Display the specified resource.
  *
  * @param Request $request
  * @param CV $cv
  * @return \Illuminate\Http\Response
  */
 public function show(Request $request, CV $cv)
 {
     // Get the cv sections.
     $sections = $cv->sections()->get();
     // Build empty subsections.
     $workSection = array();
     $languageSection = array();
     $educationSection = array();
     $hobbySection = array();
     $skillSection = array();
     // For each section, determine it's type, and append it's data to the corresponding subsection.
     foreach ($sections as $section) {
         $w = Work::whereSectionId($section->id)->get(['name', 'location', 'title', 'description', 'start_date', 'end_date'])->toArray();
         $l = Language::whereSectionId($section->id)->get(['name', 'level', 'creditation'])->toArray();
         $e = Education::whereSectionId($section->id)->get(['name', 'location', 'title', 'description', 'start_date', 'end_date'])->toArray();
         $h = Hobby::whereSectionId($section->id)->get(['text'])->toArray();
         $s = Skill::whereSectionId($section->id)->get(['name', 'level', 'description'])->toArray();
         if (count($w) != 0) {
             array_push($workSection, $w);
         }
         if (count($l) != 0) {
             array_push($languageSection, $l);
         }
         if (count($e) != 0) {
             array_push($educationSection, $e);
         }
         if (count($h) != 0) {
             array_push($hobbySection, $h);
         }
         if (count($s) != 0) {
             array_push($skillSection, $s);
         }
     }
     return view('pages.cvs.show', ['cv' => $cv, 'user' => $request->user(), 'workSection' => $workSection, 'languageSection' => $languageSection, 'educationSection' => $educationSection, 'hobbySection' => $hobbySection, 'skillSection' => $skillSection]);
 }
 public function revertAssignedWork(RevertAssignedWorkRequest $request)
 {
     if ($request->revert == 1) {
         $work = Work::where('id', '=', $request->work_id)->first();
         if ($work->created_by == $this->currentUser->getId()) {
             /**
              * İŞİ GERİ ÇEKİLİNCE
              */
             $departmentWork = DepartmentWork::where('id', '=', $work->last_department_work_id)->first();
             $departmentWithSenior = Department::where('id', '=', $departmentWork->department_id)->with('senior')->first();
             $seniorUser = $departmentWithSenior->senior[0];
             $username = $seniorUser->first_name . " " . $seniorUser->last_name;
             $username = mb_convert_case($username, MB_CASE_TITLE, 'utf-8');
             CommonController::mailSendNotQueue('IS TAKIP SISTEMI', [$seniorUser->email], ['fullname' => $username, 'message' => 'Departmanınıza açılan "' . $work->title . '" başlıklı iş geri
                 alınmıştır. Lütfen ' . $this->currentUser->first_name . ' ' . $this->currentUser->last_name . ' ile irtibata geçiniz. '], 'emails.work-mail-template');
             CommonController::sendSms('RHPOZTFYAY', $seniorUser->phone, 'Departmanınızdaki "' . $work->title . '" başlıklı iş geri
             alınmıştır.Lütfen ' . $this->currentUser->first_name . ' ' . $this->currentUser->last_name . '  ile irtibata geçiniz.');
             $work->last_department_work_id = null;
             $work->save();
         } else {
             $workDepartment = DepartmentWork::where('id', '=', $work->last_department_work_id)->first();
             $userWork = UserWork::where('id', '=', $workDepartment->last_user_work_id)->first();
             $user = User::where('id', '=', $userWork->assigned_to)->first();
             $username = $user->first_name . " " . $user->last_name;
             $username = mb_convert_case($username, MB_CASE_TITLE, 'utf-8');
             CommonController::mailSendNotQueue('IS TAKIP SISTEMI', [$user->email], ['fullname' => $username, 'message' => 'Size acılan "' . $work->title . '" başlıklı iş geri alınmıştır.
                  Lütfen departman lideriniz ile irtibata geçiniz. '], 'emails.work-mail-template');
             CommonController::sendSms('RHPOZTFYAY', $user->phone, 'Size açılmış  "' . $work->title . '" başlıklı iş geri alınmıştır.
             Lütfen departman lideri ile irtibata geçiniz.');
             $workDepartment->last_user_work_id = null;
             $workDepartment->accepted = null;
             $workDepartment->save();
         }
         return response()->json(['success' => true, 'messages' => 'İş Geri Alma İşlemi Başarılı', 'revert' => true, 'work_id' => $work->id]);
     } else {
         return response()->json(['success' => true, 'messages' => 'İş Geri Alma İşlemi Başarılı', 'revert' => false]);
     }
 }
Beispiel #16
0
 /**
  * Get slug for certain Work. If does not exist fails(404).
  * Else returning view for certain Work.
  * @param $slug
  */
 public function show($slug)
 {
     $work = \App\Work::where(['slug' => $slug])->firstOrFail();
 }
 /**
  * Remove the specified resource from storage.
  *
  * @param  int $id
  * @return \Illuminate\Http\Response
  */
 public function destroy($id)
 {
     if ($this->currentUser->hasAccess('wts.management.edit')) {
         DB::transaction(function () use($id) {
             $work = Work::where('id', '=', \Crypt::decrypt($id))->first();
             if ($work->file != '') {
                 \File::delete(public_path() . "/uploads/works-files/" . $work->file);
             }
             $work->delete();
         });
         return response()->json($this->deleteResponseMessage);
     } else {
         abort(403, $this->accessForbidden);
     }
 }
 /**
  * Remove the specified resource from storage.
  *
  * @param int $id
  *
  * @return \Illuminate\Http\Response
  */
 public function destroy($id)
 {
     Work::destroy($id);
     return back();
 }
 /**
  * Deleting certain Work
  * TODO Delete Gallery
  * TODO Are u sure u want to delete?
  * @param $id
  * @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector
  */
 public function delete($id)
 {
     $work = \App\Work::where(['id' => $id])->first();
     $work->videos()->forceDelete();
     $work->forceDelete();
     //Delete Gallery TODO
     return redirect(url('/admin/works/' . $work->type->slug));
 }
Beispiel #20
0
 /**
  * Store a newly created resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @return \Illuminate\Http\Response
  */
 public function store(Request $request)
 {
     //
     $input = $request->all();
     $userId = Auth::user()['id'];
     $work = Work::where('user_id', $userId)->first();
     //判断是否已经存在记录
     if ($work == null) {
         $id['user_id'] = $userId;
         Work::create($id);
     }
     $work = Work::where('user_id', $userId)->first();
     //判断来自第几个项目信息页面
     if ($input['info_id'] == '1') {
         $name = $input['name'];
         $big_class = $input['big_class'];
         $small_class = $input['small_class'];
         $a = DB::update('update work set name=?,big_class=?,small_class=? where user_id=?', [$name, $big_class, $small_class, $userId]);
         return redirect('/work/create/2');
     }
     if ($input['info_id'] == '2') {
         $aim = $input['aim'];
         $brief = $input['brief'];
         $detailed = $input['detailed'];
         $a = DB::update('update work set aim=?,brief=?,detailed=? where user_id=?', [$aim, $brief, $detailed, $userId]);
         return redirect('/work/create/3');
     }
     if ($input['info_id'] == '3') {
         //判断请求中是否存在文件,如果存在则保存文件,否则存储为null
         if ($request->hasFile('materials') && $request->hasFile('document')) {
             $fileName1 = 'document' . '_' . $userId;
             $fileName2 = 'materials' . '_' . $userId;
             $path1 = 'file/document/';
             $path2 = 'file/materials';
             $request->file('document')->move($path1, $fileName1 . '.pdf');
             $request->file('materials')->move($path2, $fileName2 . '.pdf');
             $document_address = $fileName1;
             $materials_address = $fileName2;
             $a = DB::update('update work set document_address=?,materials_address=? where user_id=?', [$document_address, $materials_address, $userId]);
         }
         return redirect('/work/create/4');
     }
     if ($input['info_id'] == '4') {
         //判断请求中是否存在文件,如果存在则保存文件,否则存储为null
         if ($request->hasFile('image') && $request->hasFile('video')) {
             $fileName1 = 'image' . '_' . $userId;
             $fileName2 = 'video' . '_' . $userId;
             $path1 = 'file/image/';
             $path2 = 'file/video/';
             $request->file('image')->move($path1, $fileName1 . '.jpg');
             $request->file('video')->move($path2, $fileName2 . '.mp4');
             $image_address = $fileName1;
             $video_address = $fileName2;
             $a = DB::update('update work set image_address=?,video_address=? where user_id=?', [$image_address, $video_address, $userId]);
         }
     }
     //存储作品后设置作品状态为schoolwait
     //根据userId获取workId
     $work = Work::where('user_id', $userId)->first();
     $workId = $work['id'];
     //根据workId 设置WorkStatus
     $workStatus['work_id'] = $workId;
     $workStatus['status'] = 'schoolWait';
     WorkStatus::create($workStatus);
     //填写完成所有资料,跳转到填写成功的页面
     return redirect('/work/storeSuccess');
 }
 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index()
 {
     $works = Work::orderBy('created_at', 'DESC')->take(3)->get();
     $posts = Post::orderBy('created_at', 'DESC')->take(3)->get();
     return view('index', compact(['works', 'posts']));
 }
Beispiel #22
0
    $type = 'Lunch';
    $description = 'Lunch break';
    if (is_null($taskType = TaskType::checkIfExists($type))) {
        // get $client->id
        $client = Client::where('name', '=', 'Kendra Scott')->first();
        $taskType = new TaskType();
        $taskType->type = $type;
        $taskType->description = $description;
        $taskType->client_id = $client->id;
        $taskType->save();
    }
});
Route::get('add_timeCard_data', function () {
    $date = '2015-11-09';
    // get $work->id
    $work = Work::where('work_type_description', '=', 'The catalog view is performing too slowly.')->first();
    // get $timeCardFormat->id
    $timeCardFormat = TimeCardFormat::where('description', '=', 'Day of week starts on SAT and ends on SUN')->first();
    $timeCard = new TimeCard();
    $timeCard->work_id = $work->id;
    $timeCard->time_card_format_id = $timeCardFormat->id;
    if (!is_null($timeCard = TimeCard::checkIfExists($timeCard))) {
        $timeCardHoursWorked = new TimeCardHoursWorked();
        $timeCardHoursWorked->work_id = $work->id;
        $timeCardHoursWorked->date_worked = $date;
        $timeCardHoursWorked->dow = "MON";
        if (is_null(TimeCardHoursWorked::checkIfDateWorkedDowExists($timeCardHoursWorked))) {
            $timeCardHoursWorked->hours_worked = 8.0;
            $timeCardHoursWorked->time_card_id = $timeCard->id;
            $timeCardHoursWorked->save();
        }
Beispiel #23
0
 /**
  * Remove the specified resource from storage.
  *
  * @param  int $id
  * @return RedirectResponse
  */
 public function destroy(int $id) : RedirectResponse
 {
     if (Work::destroy($id) > 0) {
         return Redirect::back()->with('message', ucfirst(trans('back/work.success_deleted')));
     } else {
         return Redirect::back()->with('message', ucfirst(trans('back/work.error_deleted')));
     }
 }
 /**
  *  Displays table of the resources for admin
  *
  * @return Response
  */
 public function manage()
 {
     $works = Work::all();
     return view('works.manage', compact('works'));
 }